{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["INSTRUCTIONS","Slide Options","PPT Charts & Data","Source Data"],"not_rendered":{"charts":7,"images":11,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"INSTRUCTIONS","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["    Click any of the below instructions for further information & illustration"]
[null,"Enable Macros\nIf the Security Warning yellow ribbon is visible above your formula bar in Excel, click Enable Content"]
[]
[null,"1. Create required charts in the PPT Charts & Data worksheet tab, or modify the samples included"]
[]
[null,"2. Name data ranges to be included in the presentation in the PPT Charts & Data worksheet tab"]
[]
[null,"3. Add new slides by clicking the 'Add' button in the Slide Options worksheet tab"]
[]
[null,"4. Delete slides to include in the presentation by clicking the 'Minus' button in the Slide Options worksheet tab"]
[]
[null,"5. Enter slide title and select content type (Chart, Data or Title)"]
[]
[null,"6. Choose the content (chart name or data range name) from the drop down list\n(Note that the drop down lists automatically populate with new charts and data ranges)"]
[]
[null,"7. Repeat steps 5 & 6 to populate Content 2 Type & Content 2 Range if a side by side layout is desired\n(Note that the PowerPoint slide layout will automatically format based on whether Content 2 is selected)"]
[]
[null,"8. To create a title slide (with text only, no charts or data): Add a new slide & choose the content type 'Title'\n    Enter the text in the Text column, using ALT+Enter to begin each new line"]
[]
[null,"9. In the Slide Options worksheet tab, enter the file path and name of your PowerPoint template"]
[]
[null,"10. In the Slide Options worksheet tabClick Export to PPT"]
[]
[null,"11. Watch the PowerPoint presentation build automatically using all of the selections made in Excel."]

{"sheet":"Slide Options","index":1,"n_rows":10,"n_cols":14,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,12,6,13]]}
[]
[null,"Slide No","Slide Title","Content Boxes","Content 1 Type","Content 1 Range/Chart","Content 2 Type","Content 2 Range/Chart","Text (Title Slides Only)","Layout","Add / Delete Slide"]
[null,1,"2014 Sales Update",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":0},"Title",null,null,null,"A presentation showing automatic generation of powerpoint slides from dynamic charts that update to the most current source data\nThe content is driven by the users selection\nThe layout is driven by the users selection\nThe tedious and time consuming tasks are all taken care of - automatically",{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":16}]
[null,{"$f":"B3+1","v":2},"2014 Sales by Vehicle Make",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":1},"Chart","SALES BY MAKE",null,null,null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":16},null,null,null,"Enter Presentation Template File Path & Name (if applicable)"]
[null,3,"2014 Sales by Region",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":2},"Data","sales_by_region","Chart","SALES BY REGION",null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":29},null,null,"e.g.:","C:\\Users\\USER\\SkyDrive\\DOC Office\\Training\\Word Introduction.pptx"]
[null,{"$f":"#REF!+1","v":{"$error":"#REF!"}},"2014 Vehicle Sales by Sales Person",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":2},"Data","sales_by_rep","Chart","SALES BY QUARTER",null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":29}]
[null,{"$error":"#REF!"},"2014 Vehicle Sales by Month",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":1},"Data","sales_by_quarter",null,null,null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":16},null,null,"Note: if the file path & name are incorrect, a generic template will be used instead"]
[null,{"$error":"#REF!"},"2014 Vehicle Sales by Quarter",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":1},"Chart","Sales by Month",null,null,null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":16}]
[null,{"$f":"B8+1","v":{"$error":"#REF!"}},"2014 Vehicle Sales by Sales Person",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":2},"Chart","# No of Sales","Chart","$ Value of Sales",null,{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":29}]
[null,{"$f":"B8+1","v":{"$error":"#REF!"}},"In Summary",{"$f":"IF(tblSlide_Data[[#This Row],[Content 1 Type]]<>\"Title\",COUNTA(tblSlide_Data[[#This Row],[Content 1 Type]],tblSlide_Data[[#This Row],[Content 2 Type]]),0)","v":0},"Title",null,null,null,"We've created a method to generate our powerpoint presentations in seconds - not hours\nWe've ensured consistency - the presentation will always present information in a the same format - until we change it\nWe've negated the need to do any manual analysis with our clever formulas that update to the most current data\nWe've eliminated the need to manually copy and paste.\nAll round, we've saved ourselves heaps of time and eliminated the boring admin required to analyse and present the data.",{"$f":"IF(tblSlide_Data[[#This Row],[Content Boxes]]<2,16,29)","v":16}]

{"sheet":"PPT Charts & Data","index":2,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SALES BY QUARTER"]
[null,null,null,"Lois Lane","Oliver Queen","Peter Parker","Mary Jane","TOTAL"]
[null,"Quarter",1,{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/01/2014\",'Source Data'!$B:$B,\"<=31/03/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!D$3)","v":388890},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/01/2014\",'Source Data'!$B:$B,\"<=31/03/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!E$3)","v":293400},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/01/2014\",'Source Data'!$B:$B,\"<=31/03/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!F$3)","v":146800},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/01/2014\",'Source Data'!$B:$B,\"<=31/03/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!G$3)","v":64000},{"$f":"SUM(D4:G4)","v":893090}]
[null,"Quarter",2,{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/04/2014\",'Source Data'!$B:$B,\"<=30/06/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!D$3)","v":334500},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/04/2014\",'Source Data'!$B:$B,\"<=30/06/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!E$3)","v":219700},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/04/2014\",'Source Data'!$B:$B,\"<=30/06/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!F$3)","v":204000},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/04/2014\",'Source Data'!$B:$B,\"<=30/06/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!G$3)","v":113340},{"$f":"SUM(D5:G5)","v":871540}]
[null,"Quarter",3,{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/07/2014\",'Source Data'!$B:$B,\"<=30/09/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!D$3)","v":324700},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/07/2014\",'Source Data'!$B:$B,\"<=30/09/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!E$3)","v":206700},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/07/2014\",'Source Data'!$B:$B,\"<=30/09/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!F$3)","v":245200},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/07/2014\",'Source Data'!$B:$B,\"<=30/09/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!G$3)","v":77300},853900]
[null,"Quarter",4,{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/10/2014\",'Source Data'!$B:$B,\"<=31/12/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!D$3)","v":338800},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/10/2014\",'Source Data'!$B:$B,\"<=31/12/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!E$3)","v":455500},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/10/2014\",'Source Data'!$B:$B,\"<=31/12/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!F$3)","v":138000},{"$f":"SUMIFS('Source Data'!$J:$J,'Source Data'!$B:$B,\">=01/10/2014\",'Source Data'!$B:$B,\"<=31/12/2014\",'Source Data'!$C:$C,'PPT Charts & Data'!G$3)","v":81599},1013899]
[null,"TOTAL",null,{"$f":"SUM(D4:D7)","v":1386890},{"$f":"SUM(E4:E7)","v":1175300},734000,336239,3632429]
[]
[]
[null,"SALES BY MAKE"]
[null,"Make","# No of Sales","$ Value of Sales"]
[null,"Hyundai",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B13)","v":10},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B13,'Source Data'!J:J)","v":46800}]
[null,"Peugot",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B14)","v":21},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B14,'Source Data'!J:J)","v":86600}]
[null,"KIA",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B15)","v":35},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B15,'Source Data'!J:J)","v":204900}]
[null,"GMH",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B16)","v":25},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B16,'Source Data'!J:J)","v":206800}]
[null,"Renault",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B17)","v":40},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B17,'Source Data'!J:J)","v":259600}]
[null,"Volkswagen",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B18)","v":45},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B18,'Source Data'!J:J)","v":282690}]
[null,"Nissan",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B19)","v":60},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B19,'Source Data'!J:J)","v":392890}]
[null,"Ford",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B20)","v":70},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B20,'Source Data'!J:J)","v":424800}]
[null,"Mitsubishi",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B21)","v":35},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B21,'Source Data'!J:J)","v":479900}]
[null,"Toyota",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B22)","v":73},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B22,'Source Data'!J:J)","v":502799}]
[null,"BMW",{"$f":"COUNTIF('Source Data'!D:D,'PPT Charts & Data'!B23)","v":101},{"$f":"SUMIF('Source Data'!D:D,'PPT Charts & Data'!B23,'Source Data'!J:J)","v":744650}]
[null,"TOTAL",{"$f":"SUM(C13:C23)","v":515},{"$f":"SUM(D13:D23)","v":3632429}]
[]
[null,"SALES BY REP"]
[null,"Sales Person","# No of Sales","$ Value of Sales"]
[null,"Lois Lane",{"$f":"COUNTIF('Source Data'!C:C,'PPT Charts & Data'!B28)","v":170},{"$f":"SUMIF('Source Data'!C:C,'PPT Charts & Data'!B28,'Source Data'!J:J)","v":1386890},{"$f":"ROUND(D28/1000000,1)&\"m\"","v":"1.4m"}]
[null,"Peter Parker",{"$f":"COUNTIF('Source Data'!C:C,'PPT Charts & Data'!B29)","v":105},{"$f":"SUMIF('Source Data'!C:C,'PPT Charts & Data'!B29,'Source Data'!J:J)","v":734000},{"$f":"ROUND(D29/1000000,1)&\"m\"","v":"0.7m"}]
[null,"Mary Jane",{"$f":"COUNTIF('Source Data'!C:C,'PPT Charts & Data'!B30)","v":55},{"$f":"SUMIF('Source Data'!C:C,'PPT Charts & Data'!B30,'Source Data'!J:J)","v":336239},"0.3m"]
[null,"Oliver Queen",{"$f":"COUNTIF('Source Data'!C:C,'PPT Charts & Data'!B31)","v":185},{"$f":"SUMIF('Source Data'!C:C,'PPT Charts & Data'!B31,'Source Data'!J:J)","v":1175300},"1.2m"]
[null,"TOTAL",{"$f":"SUM(C28:C31)","v":515},{"$f":"SUM(D28:D31)","v":3632429},{"$f":"D32","v":3632429}]
[]
[null,"SALES BY REGION"]
[null,"Region","# No of Sales","$ Value of Sales"]
[null,"East",{"$f":"COUNTIF('Source Data'!K:K,'PPT Charts & Data'!B36)","v":97},{"$f":"SUMIF('Source Data'!K:K,'PPT Charts & Data'!B36,'Source Data'!J:J)","v":568490}]
[null,"North",{"$f":"COUNTIF('Source Data'!K:K,'PPT Charts & Data'!B37)","v":165},{"$f":"SUMIF('Source Data'!K:K,'PPT Charts & Data'!B37,'Source Data'!J:J)","v":1427200}]
[null,"South",{"$f":"COUNTIF('Source Data'!K:K,'PPT Charts & Data'!B38)","v":253},{"$f":"SUMIF('Source Data'!K:K,'PPT Charts & Data'!B38,'Source Data'!J:J)","v":1636739}]
[null,"West",{"$f":"COUNTIF('Source Data'!K:K,'PPT Charts & Data'!B39)","v":0},{"$f":"SUMIF('Source Data'!K:K,'PPT Charts & Data'!B39,'Source Data'!J:J)","v":0}]
[null,"TOTAL",{"$f":"SUM(C36:C39)","v":515},{"$f":"SUM(D36:D39)","v":3632429}]
[]
[null,"SALES BY MONTH"]
[null,"Month","# No of Sales","$ Value of Sales","Average Price"]
[null,"2014-01-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B44,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B44,0))","v":45},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B44,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B44,0))","v":376400},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B44,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B44,0))","v":8364.4444444444453}]
[null,"2014-02-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B45,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B45,0))","v":43},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B45,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B45,0))","v":235290},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B45,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B45,0))","v":5471.8604651162786}]
[null,"2014-03-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B46,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B46,0))","v":45},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B46,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B46,0))","v":281400},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B46,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B46,0))","v":6253.333333333333}]
[null,"2014-04-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B47,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B47,0))","v":41},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B47,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B47,0))","v":337150},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B47,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B47,0))","v":8223.1707317073178}]
[null,"2014-05-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B48,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B48,0))","v":39},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B48,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B48,0))","v":204900},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B48,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B48,0))","v":5253.8461538461543}]
[null,"2014-06-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B49,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B49,0))","v":45},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B49,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B49,0))","v":329490},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B49,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B49,0))","v":7322}]
[null,"2014-07-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B50,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B50,0))","v":39},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B50,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B50,0))","v":210000},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B50,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B50,0))","v":5384.6153846153848}]
[null,"2014-08-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B51,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B51,0))","v":36},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B51,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B51,0))","v":296700},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B51,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B51,0))","v":8241.6666666666661}]
[null,"2014-09-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B52,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B52,0))","v":40},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B52,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B52,0))","v":347200},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B52,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B52,0))","v":8680}]
[null,"2014-10-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B53,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B53,0))","v":55},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B53,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B53,0))","v":465199},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B53,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B53,0))","v":8458.1636363636371}]
[null,"2014-11-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B54,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B54,0))","v":41},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B54,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B54,0))","v":287500},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B54,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B54,0))","v":7012.1951219512193}]
[null,"2014-12-01",{"$f":"COUNTIFS('Source Data'!B:B,\">=\"&'PPT Charts & Data'!B55,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B55,0))","v":46},{"$f":"SUMIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B55,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B55,0))","v":261200},{"$f":"AVERAGEIFS('Source Data'!J:J,'Source Data'!B:B,\">=\"&'PPT Charts & Data'!B55,'Source Data'!B:B,\"<=\"&EOMONTH('PPT Charts & Data'!B55,0))","v":5678.260869565217}]
[null,"TOTAL",{"$f":"SUM(C44:C55)","v":515},{"$f":"SUM(D44:D55)","v":3632429},{"$f":"SUM(E44:E55)","v":84343.556807609653}]

{"sheet":"Source Data","index":3,"n_rows":516,"n_cols":11,"rows_kept":516,"cut":false,"hidden":false,"merged":[]}
["No","Date","Salesperson","Make","Model","Type","Colour","Year","Age","Price","Region"]
[1,"2014-09-12","Lois Lane","Toyota","Corolla","Sedan","Red",2002,{"$f":"YEAR(NOW())-H2","v":14},2100,"South"]
[2,"2014-09-08","Peter Parker","BMW","3 Series","Sedan","Silver",1997,{"$f":"YEAR(NOW())-H3","v":19},3000,"East"]
[3,"2014-05-09","Oliver Queen","Toyota","Celica","Coupe","Yellow",2000,16,1800,"South"]
[4,"2014-03-04","Lois Lane","Ford","Explorer","SUV","Silver",2002,14,2100,"South"]
[5,"2014-05-03","Mary Jane","Hyundai","Elantra","Sedan","White",1996,20,1400,"East"]
[6,"2014-03-06","Peter Parker","Ford","Fiesta","Sedan","Green",2006,10,6300,"East"]
[7,"2014-07-25","Oliver Queen","BMW","Z3","Coupe","Silver",2003,13,2300,"South"]
[8,"2014-12-15","Oliver Queen","Toyota","Corolla","Sedan","White",1992,24,2300,"South"]
[9,"2014-01-07","Lois Lane","Toyota","Camry","Wagon","Yellow",2008,8,4200,"South"]
[10,"2014-04-22","Lois Lane","KIA","Mini","Sedan","Red",1993,23,2400,"North"]
[11,"2014-05-11","Lois Lane","Volkswagen","Toureg","SUV","Silver",2001,15,3900,"North"]
[12,"2014-09-29","Peter Parker","Mitsubishi","Lancer","Sedan","Red",1997,19,3000,"North"]
[13,"2014-10-31","Oliver Queen","GMH","Adventurer","SUV","White",1998,18,3200,"South"]
[14,"2014-07-11","Oliver Queen","KIA","Micro","Sedan","Red",2012,4,25000,"East"]
[15,"2014-05-28","Mary Jane","Ford","Mercury","Coupe","Blue",2008,8,4200,"North"]
[16,"2014-09-24","Peter Parker","BMW","Z4","Coupe","Red",2007,9,7200,"South"]
[17,"2014-10-29","Peter Parker","Renault","Tricolour","Wagon","Silver",1992,24,1200,"North"]
[18,"2014-06-06","Oliver Queen","Hyundai","Elantra","Coupe","Silver",1996,20,1400,"North"]
[19,"2014-11-05","Lois Lane","Peugot","Supreme","Sedan","White",1998,18,3200,"South"]
[20,"2014-07-08","Oliver Queen","Ford","Mercury","Coupe","Red",1995,21,2700,"South"]
[21,"2014-09-29","Lois Lane","Renault","Mountaineer","SUV","Yellow",1996,20,2800,"South"]
[22,"2014-08-24","Oliver Queen","Toyota","Landcruiser","SUV","White",2007,9,3600,"South"]
[23,"2014-03-26","Oliver Queen","GMH","Adventurer","SUV","Silver",2006,10,3200,"East"]
[24,"2014-06-24","Lois Lane","Volkswagen","Beetle","Sedan","Red",2013,3,50000,"North"]
[25,"2014-04-20","Mary Jane","BMW","7 Series","Sedan","Red",2005,11,2800,"South"]
[26,"2014-12-05","Oliver Queen","BMW","Z3","Coupe","Blue",2000,16,3600,"North"]
[27,"2014-04-28","Lois Lane","Ford","Ecstasy","Wagon","Silver",2010,6,6300,"North"]
[28,"2014-12-28","Lois Lane","Ford","Fiesta","Sedan","Red",2001,15,2000,"South"]
[29,"2014-08-03","Lois Lane","Volkswagen","Beetle","Sedan","Red",2011,5,16700,"East"]
[30,"2014-11-22","Lois Lane","Renault","Formula 1","Coupe","Blue",1996,20,2800,"South"]
[31,"2014-12-20","Peter Parker","Nissan","Pulsar","Sedan","Silver",1999,17,1700,"East"]
[32,"2014-04-24","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2003,13,2300,"North"]
[33,"2014-06-30","Oliver Queen","Nissan","Pulsar","Sedan","Yellow",1996,20,2800,"South"]
[34,"2014-08-16","Oliver Queen","KIA","Stellar","Sedan","Silver",2008,8,4200,"South"]
[35,"2014-05-18","Mary Jane","Toyota","Celica","Coupe","Red",2000,16,3600,"South"]
[36,"2014-09-18","Peter Parker","Toyota","Celica","Coupe","Red",2003,13,2300,"South"]
[37,"2014-11-04","Oliver Queen","Ford","Mercury","Coupe","Red",2001,15,2000,"North"]
[38,"2014-03-22","Lois Lane","Renault","Megane","Sedan","Green",2011,5,16700,"South"]
[39,"2014-02-01","Lois Lane","Volkswagen","Golf","Coupe","Green",2005,11,2890,"East"]
[40,"2014-11-22","Oliver Queen","BMW","3 Series","Sedan","Red",2000,16,3600,"North"]
[41,"2014-10-10","Peter Parker","KIA","Micro","Sedan","Red",1999,17,3400,"South"]
[42,"2014-07-19","Oliver Queen","Renault","Megane","Sedan","Red",2008,8,8400,"South"]
[43,"2014-01-07","Lois Lane","Renault","LeMans","Sedan","Green",2002,14,4200,"North"]
[44,"2014-01-14","Oliver Queen","BMW","X5","SUV","Silver",1995,21,1400,"North"]
[45,"2014-12-08","Mary Jane","Renault","Lemans","Sedan","Silver",2007,9,3600,"South"]
[46,"2014-09-28","Lois Lane","KIA","Ranger","SUV","Silver",2003,13,4600,"East"]
[47,"2014-09-12","Peter Parker","BMW","3 Series","Sedan","White",2003,13,2300,"North"]
[48,"2014-07-25","Oliver Queen","BMW","X3","SUV","White",2007,9,3600,"South"]
[49,"2014-11-16","Lois Lane","Ford","Fiesta","Sedan","Red",1994,22,1300,"East"]
[50,"2014-03-31","Lois Lane","Nissan","Pulsar","Sedan","Silver",1992,24,2300,"East"]
[51,"2014-12-13","Oliver Queen","Nissan","Pulsar","Sedan","Green",2012,4,12500,"North"]
[52,"2014-06-24","Oliver Queen","Mitsubishi","Magna","Sedan","Silver",2004,12,5000,"South"]
[53,"2014-06-22","Lois Lane","Peugot","Supreme","Sedan","Silver",1997,19,1500,"North"]
[54,"2014-02-10","Oliver Queen","Toyota","Corolla","Sedan","Blue",2013,3,22000,"South"]
[55,"2014-04-25","Mary Jane","BMW","7 Series","Sedan","Green",2013,3,37950,"South"]
[56,"2014-08-26","Lois Lane","GMH","Traveller","Wagon","Red",2010,6,12500,"East"]
[57,"2014-04-04","Peter Parker","BMW","Z3","Coupe","Green",2005,11,2800,"South"]
[58,"2014-11-28","Peter Parker","Volkswagen","Golf","Coupe","Red",1991,25,1100,"South"]
[59,"2014-11-08","Oliver Queen","GMH","Adventurer","SUV","Silver",2003,13,2300,"North"]
[60,"2014-03-10","Lois Lane","Ford","Explorer","SUV","Yellow",1996,20,1400,"North"]
[61,"2014-09-30","Oliver Queen","BMW","3 Series","Sedan","White",1991,25,2200,"South"]
[62,"2014-05-21","Lois Lane","Nissan","350z","Coupe","Green",1998,18,1600,"East"]
[63,"2014-12-06","Oliver Queen","Mitsubishi","Pajero","SUV","Red",2008,8,8400,"South"]
[64,"2014-05-30","Peter Parker","Toyota","Camry","Sedan","Red",1994,22,1300,"North"]
[65,"2014-07-01","Mary Jane","BMW","7 Series","Sedan","Silver",2004,12,2500,"East"]
[66,"2014-03-29","Lois Lane","Ford","Mercury","Coupe","Blue",1994,{"$f":"YEAR(NOW())-H67","v":22},1300,"South"]
[67,"2014-02-15","Lois Lane","Volkswagen","Golf","Coupe","White",1999,17,1700,"South"]
[68,"2014-01-20","Lois Lane","Nissan","Estate","Wagon","Red",2012,4,25000,"South"]
[69,"2014-11-20","Peter Parker","BMW","7 Series","Sedan","Red",1998,18,3200,"South"]
[70,"2014-12-26","Oliver Queen","Peugot","Supreme","Coupe","Red",1998,18,1600,"East"]
[71,"2014-03-22","Oliver Queen","Toyota","Rav 4","Coupe","Silver",1991,25,2200,"North"]
[72,"2014-06-29","Lois Lane","Volkswagen","Passat","Wagon","Green",2012,4,25000,"South"]
[73,"2014-10-24","Oliver Queen","Nissan","350z","Coupe","Red",2005,11,2800,"East"]
[74,"2014-11-25","Oliver Queen","Ford","Fiesta","Sedan","Silver",1992,24,1200,"North"]
[75,"2014-06-21","Mary Jane","Nissan","Pulsar","Sedan","Silver",1999,17,3490,"South"]
[76,"2014-05-09","Peter Parker","Ford","Raven","Sedan","Yellow",1998,18,3200,"South"]
[77,"2014-06-14","Peter Parker","BMW","Z4","Coupe","Red",2011,5,8400,"North"]
[78,"2014-12-01","Oliver Queen","Toyota","Camry","Sedan","White",2013,3,50000,"North"]
[79,"2014-07-26","Lois Lane","Toyota","Corolla","Wagon","Silver",2004,12,5000,"South"]
[80,"2014-02-08","Oliver Queen","KIA","Stellar","Sedan","Silver",1999,17,3400,"South"]
[81,"2014-11-26","Oliver Queen","Volkswagen","Toureg","SUV","Silver",1998,18,3200,"South"]
[82,"2014-04-01","Lois Lane","Mitsubishi","Lancer","Sedan","Silver",2007,9,7200,"North"]
[83,"2014-11-20","Peter Parker","GMH","Adventurer","SUV","Green",1999,17,3400,"North"]
[84,"2014-07-08","Oliver Queen","BMW","5 Series","Sedan","White",1998,18,1600,"South"]
[85,"2014-07-28","Mary Jane","Nissan","350z","Coupe","Silver",2009,7,10000,"North"]
[86,"2014-02-09","Lois Lane","Mitsubishi","Pajero","SUV","Red",1999,17,3400,"South"]
[87,"2014-03-11","Lois Lane","Toyota","Camry","Sedan","Silver",2010,6,12500,"South"]
[88,"2014-08-30","Oliver Queen","BMW","5 Series","Sedan","Blue",1996,20,2800,"East"]
[89,"2014-02-11","Oliver Queen","Ford","Mustang","Coupe","Green",1997,19,3000,"North"]
[90,"2014-01-09","Oliver Queen","Volkswagen","Golf","Coupe","Silver",1994,22,2500,"South"]
[91,"2014-09-12","Lois Lane","Nissan","Estate","Wagon","Green",2000,16,3600,"South"]
[92,"2014-03-15","Peter Parker","BMW","3 Series","Sedan","Red",2009,7,5000,"South"]
[93,"2014-01-20","Peter Parker","Renault","Megane","Sedan","Green",1998,18,3200,"East"]
[94,"2014-03-16","Oliver Queen","KIA","Ranger","SUV","Silver",2006,10,6300,"North"]
[95,"2014-10-19","Mary Jane","BMW","7 Series","Sedan","Red",1997,19,1500,"South"]
[96,"2014-02-14","Peter Parker","BMW","X5","SUV","Yellow",2011,5,16700,"North"]
[97,"2014-06-12","Lois Lane","Ford","Fiesta","Sedan","Green",1999,17,1700,"North"]
[98,"2014-05-11","Oliver Queen","Nissan","Maxima","Sedan","Red",1992,24,2300,"South"]
[99,"2014-07-21","Oliver Queen","Nissan","Maxima","Sedan","White",2007,9,7200,"North"]
[100,"2014-03-12","Lois Lane","Mitsubishi","Magna","Sedan","Silver",1997,19,3000,"North"]
[101,"2014-07-19","Lois Lane","Peugot","Supreme","Sedan","Blue",2007,9,3600,"East"]
[102,"2014-08-22","Peter Parker","Toyota","Corolla","Sedan","Red",2006,10,3200,"South"]
[103,"2014-09-27","Lois Lane","Toyota","Corolla","Sedan","Red",2009,{"$f":"YEAR(NOW())-H104","v":7},5000,"South"]
[104,"2014-08-30","Peter Parker","BMW","3 Series","Sedan","Silver",2013,{"$f":"YEAR(NOW())-H105","v":3},25000,"East"]
[105,"2014-11-21","Oliver Queen","Toyota","Celica","Coupe","Yellow",1999,17,1700,"South"]
[106,"2014-10-09","Lois Lane","Ford","Explorer","SUV","Silver",2007,9,3600,"South"]
[107,"2014-08-16","Mary Jane","Hyundai","Elantra","Sedan","White",2012,4,25000,"East"]
[108,"2014-03-21","Peter Parker","Ford","Fiesta","Sedan","Green",1994,22,2500,"East"]
[109,"2014-02-28","Oliver Queen","BMW","Z3","Coupe","Silver",1997,19,1500,"South"]
[110,"2014-07-16","Oliver Queen","Toyota","Corolla","Sedan","White",2013,3,25000,"South"]
[111,"2014-10-07","Lois Lane","Toyota","Camry","Wagon","Yellow",2011,5,16700,"South"]
[112,"2014-06-07","Lois Lane","KIA","Mini","Sedan","Red",2003,13,2300,"North"]
[113,"2014-06-17","Lois Lane","Volkswagen","Toureg","SUV","Silver",2000,16,1800,"North"]
[114,"2014-10-16","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2000,16,3600,"North"]
[115,"2014-01-24","Oliver Queen","GMH","Adventurer","SUV","White",2009,7,10000,"South"]
[116,"2014-10-27","Oliver Queen","KIA","Micro","Sedan","Red",2011,5,8400,"East"]
[117,"2014-01-12","Mary Jane","Ford","Mercury","Coupe","Blue",2013,3,25000,"North"]
[118,"2014-08-15","Peter Parker","BMW","Z4","Coupe","Red",2011,5,16700,"South"]
[119,"2014-04-27","Peter Parker","Renault","Tricolour","Wagon","Silver",2002,14,4200,"North"]
[120,"2014-04-11","Oliver Queen","Hyundai","Elantra","Coupe","Silver",1997,19,3000,"North"]
[121,"2014-02-09","Lois Lane","Peugot","Supreme","Sedan","White",1991,25,2200,"South"]
[122,"2014-04-30","Oliver Queen","Ford","Mercury","Coupe","Red",2004,12,5000,"South"]
[123,"2014-07-07","Lois Lane","Renault","Mountaineer","SUV","Yellow",1999,17,1700,"South"]
[124,"2014-10-22","Oliver Queen","Toyota","Landcruiser","SUV","White",2010,6,6300,"South"]
[125,"2014-12-19","Oliver Queen","GMH","Adventurer","SUV","Silver",2003,13,2300,"East"]
[126,"2014-08-18","Lois Lane","Volkswagen","Beetle","Sedan","Red",1994,22,2500,"North"]
[127,"2014-10-06","Mary Jane","BMW","7 Series","Sedan","Red",2013,3,25000,"South"]
[128,"2014-06-20","Oliver Queen","BMW","Z3","Coupe","Blue",2005,11,5600,"North"]
[129,"2014-06-11","Lois Lane","Ford","Ecstasy","Wagon","Silver",1992,24,1200,"North"]
[130,"2014-05-18","Lois Lane","Ford","Fiesta","Sedan","Red",1991,25,2200,"South"]
[131,"2014-12-31","Lois Lane","Volkswagen","Beetle","Sedan","Red",1999,17,3400,"East"]
[132,"2014-03-04","Lois Lane","Renault","Formula 1","Coupe","Blue",1999,17,3400,"South"]
[133,"2014-01-01","Peter Parker","Nissan","Pulsar","Sedan","Silver",1991,25,2200,"East"]
[134,"2014-09-18","Peter Parker","Mitsubishi","Lancer","Sedan","Red",1995,21,2700,"North"]
[135,"2014-12-16","Oliver Queen","Nissan","Pulsar","Sedan","Yellow",2002,14,2100,"South"]
[136,"2014-08-07","Oliver Queen","KIA","Stellar","Sedan","Silver",2005,11,5600,"South"]
[137,"2014-10-10","Mary Jane","Toyota","Celica","Coupe","Red",2009,7,4999,"South"]
[138,"2014-06-25","Peter Parker","Toyota","Celica","Coupe","Red",1992,24,1200,"South"]
[139,"2014-03-30","Oliver Queen","Ford","Mercury","Coupe","Red",1993,23,2400,"North"]
[140,"2014-09-17","Lois Lane","Renault","Megane","Sedan","Green",2013,3,25000,"South"]
[141,"2014-11-03","Lois Lane","Volkswagen","Golf","Coupe","Green",2003,13,4600,"East"]
[142,"2014-01-13","Oliver Queen","BMW","3 Series","Sedan","Red",1994,22,2500,"North"]
[143,"2014-06-20","Peter Parker","KIA","Micro","Sedan","Red",1995,21,2700,"South"]
[144,"2014-08-16","Oliver Queen","Renault","Megane","Sedan","Red",1998,18,1600,"South"]
[145,"2014-09-03","Lois Lane","Renault","LeMans","Sedan","Green",1999,17,3400,"North"]
[146,"2014-04-19","Oliver Queen","BMW","X5","SUV","Silver",2010,6,6300,"North"]
[147,"2014-10-24","Mary Jane","Renault","Lemans","Sedan","Silver",2004,12,2500,"South"]
[148,"2014-07-05","Lois Lane","KIA","Ranger","SUV","Silver",2005,11,5600,"East"]
[149,"2014-07-19","Peter Parker","BMW","3 Series","Sedan","White",2007,9,3600,"North"]
[150,"2014-07-19","Oliver Queen","BMW","X3","SUV","White",2009,7,10000,"South"]
[151,"2014-06-22","Lois Lane","Ford","Fiesta","Sedan","Red",2004,12,5000,"East"]
[152,"2014-04-25","Lois Lane","Nissan","Pulsar","Sedan","Silver",2013,3,50000,"East"]
[153,"2014-10-17","Oliver Queen","Nissan","Pulsar","Sedan","Green",1996,20,1400,"North"]
[154,"2014-04-06","Oliver Queen","Mitsubishi","Magna","Sedan","Silver",2013,3,25000,"South"]
[155,"2014-02-23","Lois Lane","Peugot","Supreme","Sedan","Silver",1996,20,1400,"North"]
[156,"2014-02-28","Oliver Queen","Toyota","Corolla","Sedan","Blue",2011,5,8400,"South"]
[157,"2014-01-21","Mary Jane","BMW","7 Series","Sedan","Green",2002,14,2100,"South"]
[158,"2014-11-08","Lois Lane","GMH","Traveller","Wagon","Red",2006,10,3200,"East"]
[159,"2014-03-06","Peter Parker","BMW","Z3","Coupe","Green",2004,12,2500,"South"]
[160,"2014-10-19","Peter Parker","Volkswagen","Golf","Coupe","Red",1994,22,2500,"South"]
[161,"2014-05-25","Oliver Queen","GMH","Adventurer","SUV","Silver",1996,20,1400,"North"]
[162,"2014-01-10","Lois Lane","Ford","Explorer","SUV","Yellow",1992,24,2300,"North"]
[163,"2014-04-14","Oliver Queen","BMW","3 Series","Sedan","White",2011,5,8400,"South"]
[164,"2014-07-05","Lois Lane","Nissan","350z","Coupe","Green",1994,22,1300,"East"]
[165,"2014-04-14","Oliver Queen","Mitsubishi","Pajero","SUV","Red",2013,3,25000,"South"]
[166,"2014-06-12","Peter Parker","Toyota","Camry","Sedan","Red",2013,3,50000,"North"]
[167,"2014-03-28","Mary Jane","BMW","7 Series","Sedan","Silver",2001,15,3900,"East"]
[168,"2014-10-07","Lois Lane","Ford","Mercury","Coupe","Blue",1997,{"$f":"YEAR(NOW())-H169","v":19},1500,"South"]
[169,"2014-05-13","Lois Lane","Volkswagen","Golf","Coupe","White",2004,12,5000,"South"]
[170,"2014-10-27","Lois Lane","Nissan","Estate","Wagon","Red",2013,3,50000,"South"]
[171,"2014-10-19","Peter Parker","BMW","7 Series","Sedan","Red",2005,11,2800,"South"]
[172,"2014-11-13","Oliver Queen","Peugot","Supreme","Coupe","Red",2012,4,12500,"East"]
[173,"2014-05-21","Oliver Queen","Toyota","Rav 4","Coupe","Silver",2004,12,5000,"North"]
[174,"2014-07-22","Lois Lane","Volkswagen","Passat","Wagon","Green",1998,18,3200,"South"]
[175,"2014-09-21","Oliver Queen","Nissan","350z","Coupe","Red",2005,11,2800,"East"]
[176,"2014-01-12","Oliver Queen","Ford","Fiesta","Sedan","Silver",2009,7,10000,"North"]
[177,"2014-11-04","Mary Jane","Nissan","Pulsar","Sedan","Silver",2002,14,4200,"South"]
[178,"2014-06-06","Peter Parker","Ford","Raven","Sedan","Yellow",2001,15,3900,"South"]
[179,"2014-03-09","Peter Parker","BMW","Z4","Coupe","Red",2003,13,2300,"North"]
[180,"2014-07-06","Oliver Queen","Toyota","Camry","Sedan","White",2007,9,7200,"North"]
[181,"2014-09-21","Lois Lane","Toyota","Corolla","Wagon","Silver",2007,9,3600,"South"]
[182,"2014-01-21","Oliver Queen","KIA","Stellar","Sedan","Silver",2005,11,2800,"South"]
[183,"2014-01-08","Oliver Queen","Volkswagen","Toureg","SUV","Silver",1996,20,1400,"South"]
[184,"2014-01-02","Lois Lane","Mitsubishi","Lancer","Sedan","Silver",2013,3,50000,"North"]
[185,"2014-02-22","Peter Parker","GMH","Adventurer","SUV","Green",2003,13,4600,"North"]
[186,"2014-10-17","Oliver Queen","BMW","5 Series","Sedan","White",2013,3,50000,"South"]
[187,"2014-05-12","Mary Jane","Nissan","350z","Coupe","Silver",1998,18,1600,"North"]
[188,"2014-04-03","Lois Lane","Mitsubishi","Pajero","SUV","Red",1991,25,2200,"South"]
[189,"2014-01-15","Lois Lane","Toyota","Camry","Sedan","Silver",1997,19,3000,"South"]
[190,"2014-10-18","Oliver Queen","BMW","5 Series","Sedan","Blue",1997,19,1500,"East"]
[191,"2014-09-28","Oliver Queen","Ford","Mustang","Coupe","Green",1999,17,1700,"North"]
[192,"2014-05-24","Oliver Queen","Volkswagen","Golf","Coupe","Silver",2005,11,2800,"South"]
[193,"2014-02-07","Lois Lane","Nissan","Estate","Wagon","Green",2008,8,4200,"South"]
[194,"2014-06-29","Peter Parker","BMW","3 Series","Sedan","Red",1997,19,3000,"South"]
[195,"2014-02-08","Peter Parker","Renault","Megane","Sedan","Green",2003,13,4600,"East"]
[196,"2014-01-25","Oliver Queen","KIA","Ranger","SUV","Silver",2012,4,25000,"North"]
[197,"2014-12-13","Mary Jane","BMW","7 Series","Sedan","Red",2004,12,5000,"South"]
[198,"2014-09-21","Peter Parker","BMW","X5","SUV","Yellow",1995,21,1400,"North"]
[199,"2014-11-03","Lois Lane","Ford","Fiesta","Sedan","Green",2013,3,25000,"North"]
[200,"2014-04-05","Oliver Queen","Nissan","Maxima","Sedan","Red",1996,20,1400,"South"]
[201,"2014-11-17","Oliver Queen","Nissan","Maxima","Sedan","White",1994,22,2500,"North"]
[202,"2014-10-29","Lois Lane","Mitsubishi","Magna","Sedan","Silver",2013,3,50000,"North"]
[203,"2014-07-29","Lois Lane","Peugot","Supreme","Sedan","Blue",2006,10,3200,"East"]
[204,"2014-04-30","Peter Parker","Toyota","Corolla","Sedan","Red",2001,15,2000,"South"]
[205,"2014-10-31","Lois Lane","Toyota","Corolla","Sedan","Red",2003,{"$f":"YEAR(NOW())-H206","v":13},2300,"South"]
[206,"2014-10-22","Peter Parker","BMW","3 Series","Sedan","Silver",1996,{"$f":"YEAR(NOW())-H207","v":20},1400,"East"]
[207,"2014-02-18","Oliver Queen","Toyota","Celica","Coupe","Yellow",2006,10,6300,"South"]
[208,"2014-12-12","Lois Lane","Ford","Explorer","SUV","Silver",1998,18,3200,"South"]
[209,"2014-05-16","Mary Jane","Hyundai","Elantra","Sedan","White",2008,8,4200,"East"]
[210,"2014-10-27","Peter Parker","Ford","Fiesta","Sedan","Green",1995,21,2700,"East"]
[211,"2014-01-02","Oliver Queen","BMW","Z3","Coupe","Silver",1998,18,1600,"South"]
[212,"2014-07-09","Oliver Queen","Toyota","Corolla","Sedan","White",2000,16,3600,"South"]
[213,"2014-05-07","Lois Lane","Toyota","Camry","Wagon","Yellow",1999,17,3400,"South"]
[214,"2014-08-08","Lois Lane","KIA","Mini","Sedan","Red",1998,18,3200,"North"]
[215,"2014-10-19","Lois Lane","Volkswagen","Toureg","SUV","Silver",1999,17,3400,"North"]
[216,"2014-02-07","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2006,10,3200,"North"]
[217,"2014-12-14","Oliver Queen","GMH","Adventurer","SUV","White",2004,12,5000,"South"]
[218,"2014-07-05","Oliver Queen","KIA","Micro","Sedan","Red",1993,23,1200,"East"]
[219,"2014-07-05","Mary Jane","Ford","Mercury","Coupe","Blue",1999,17,3400,"North"]
[220,"2014-10-04","Peter Parker","BMW","Z4","Coupe","Red",2008,8,8400,"South"]
[221,"2014-06-09","Peter Parker","Renault","Tricolour","Wagon","Silver",2009,7,10000,"North"]
[222,"2014-04-08","Oliver Queen","Hyundai","Elantra","Coupe","Silver",2005,11,2800,"North"]
[223,"2014-10-10","Lois Lane","Peugot","Supreme","Sedan","White",1998,18,1600,"South"]
[224,"2014-08-15","Oliver Queen","Ford","Mercury","Coupe","Red",1996,20,1400,"South"]
[225,"2014-01-13","Lois Lane","Renault","Mountaineer","SUV","Yellow",1994,22,2500,"South"]
[226,"2014-03-15","Oliver Queen","Toyota","Landcruiser","SUV","White",2011,5,8400,"South"]
[227,"2014-12-12","Oliver Queen","GMH","Adventurer","SUV","Silver",2011,5,8400,"East"]
[228,"2014-08-18","Lois Lane","Volkswagen","Beetle","Sedan","Red",2012,4,12500,"North"]
[229,"2014-08-04","Mary Jane","BMW","7 Series","Sedan","Red",2004,12,5000,"South"]
[230,"2014-11-02","Oliver Queen","BMW","Z3","Coupe","Blue",2008,8,8400,"North"]
[231,"2014-04-14","Lois Lane","Ford","Ecstasy","Wagon","Silver",1998,18,1600,"North"]
[232,"2014-02-19","Lois Lane","Ford","Fiesta","Sedan","Red",2008,8,4200,"South"]
[233,"2014-02-06","Lois Lane","Volkswagen","Beetle","Sedan","Red",1998,18,1600,"East"]
[234,"2014-07-19","Lois Lane","Renault","Formula 1","Coupe","Blue",2006,10,3200,"South"]
[235,"2014-08-15","Peter Parker","Nissan","Pulsar","Sedan","Silver",1997,19,3000,"East"]
[236,"2014-04-03","Peter Parker","Mitsubishi","Lancer","Sedan","Red",1998,18,3200,"North"]
[237,"2014-01-07","Oliver Queen","Nissan","Pulsar","Sedan","Yellow",1996,20,2800,"South"]
[238,"2014-03-09","Oliver Queen","KIA","Stellar","Sedan","Silver",1994,22,1300,"South"]
[239,"2014-11-30","Mary Jane","Toyota","Celica","Coupe","Red",1995,21,2700,"South"]
[240,"2014-12-23","Peter Parker","Toyota","Celica","Coupe","Red",1992,24,2300,"South"]
[241,"2014-10-19","Oliver Queen","Ford","Mercury","Coupe","Red",1995,21,2700,"North"]
[242,"2014-02-07","Lois Lane","Renault","Megane","Sedan","Green",1993,23,2400,"South"]
[243,"2014-08-26","Lois Lane","Volkswagen","Golf","Coupe","Green",1993,23,1200,"East"]
[244,"2014-10-19","Oliver Queen","BMW","3 Series","Sedan","Red",2002,14,2100,"North"]
[245,"2014-10-27","Peter Parker","KIA","Micro","Sedan","Red",2006,10,3200,"South"]
[246,"2014-07-25","Oliver Queen","Renault","Megane","Sedan","Red",2000,16,1800,"South"]
[247,"2014-07-11","Lois Lane","Renault","LeMans","Sedan","Green",1997,19,1500,"North"]
[248,"2014-10-18","Oliver Queen","BMW","X5","SUV","Silver",2003,13,2300,"North"]
[249,"2014-05-29","Mary Jane","Renault","Lemans","Sedan","Silver",1995,21,2700,"South"]
[250,"2014-11-06","Lois Lane","KIA","Ranger","SUV","Silver",1995,21,1400,"East"]
[251,"2014-08-09","Peter Parker","BMW","3 Series","Sedan","White",2006,10,6300,"North"]
[252,"2014-10-23","Oliver Queen","BMW","X3","SUV","White",2004,12,2500,"South"]
[253,"2014-07-15","Lois Lane","Ford","Fiesta","Sedan","Red",2011,5,16700,"East"]
[254,"2014-09-29","Lois Lane","Nissan","Pulsar","Sedan","Silver",2013,3,25000,"East"]
[255,"2014-02-12","Oliver Queen","Nissan","Pulsar","Sedan","Green",1998,18,3200,"North"]
[256,"2014-05-04","Oliver Queen","Mitsubishi","Magna","Sedan","Silver",1999,17,1700,"South"]
[257,"2014-11-22","Lois Lane","Peugot","Supreme","Sedan","Silver",2002,14,4200,"North"]
[258,"2014-12-16","Oliver Queen","Toyota","Corolla","Sedan","Blue",1999,17,3400,"South"]
[259,"2014-05-30","Mary Jane","BMW","7 Series","Sedan","Green",2013,3,25000,"South"]
[260,"2014-05-20","Lois Lane","GMH","Traveller","Wagon","Red",1996,20,1400,"East"]
[261,"2014-08-03","Peter Parker","BMW","Z3","Coupe","Green",2001,15,2000,"South"]
[262,"2014-02-27","Peter Parker","Volkswagen","Golf","Coupe","Red",2005,11,2800,"South"]
[263,"2014-10-12","Oliver Queen","GMH","Adventurer","SUV","Silver",2013,3,50000,"North"]
[264,"2014-05-23","Lois Lane","Ford","Explorer","SUV","Yellow",2002,14,4200,"North"]
[265,"2014-02-09","Oliver Queen","BMW","3 Series","Sedan","White",2000,16,1800,"South"]
[266,"2014-05-04","Lois Lane","Nissan","350z","Coupe","Green",2011,5,16700,"East"]
[267,"2014-10-25","Oliver Queen","Mitsubishi","Pajero","SUV","Red",2007,9,7200,"South"]
[268,"2014-11-26","Peter Parker","Toyota","Camry","Sedan","Red",1995,21,2700,"North"]
[269,"2014-08-28","Mary Jane","BMW","7 Series","Sedan","Silver",2008,8,4200,"East"]
[270,"2014-11-27","Lois Lane","Ford","Mercury","Coupe","Blue",1995,{"$f":"YEAR(NOW())-H271","v":21},1400,"South"]
[271,"2014-08-17","Lois Lane","Volkswagen","Golf","Coupe","White",2013,3,50000,"South"]
[272,"2014-04-07","Lois Lane","Nissan","Estate","Wagon","Red",2002,14,4200,"South"]
[273,"2014-09-26","Peter Parker","BMW","7 Series","Sedan","Red",2011,5,16700,"South"]
[274,"2014-11-22","Oliver Queen","Peugot","Supreme","Coupe","Red",2012,4,25000,"East"]
[275,"2014-01-03","Oliver Queen","Toyota","Rav 4","Coupe","Silver",1993,23,1200,"North"]
[276,"2014-09-27","Lois Lane","Volkswagen","Passat","Wagon","Green",1995,21,2700,"South"]
[277,"2014-12-08","Oliver Queen","Nissan","350z","Coupe","Red",1993,23,2400,"East"]
[278,"2014-01-07","Oliver Queen","Ford","Fiesta","Sedan","Silver",1991,25,2200,"North"]
[279,"2014-05-16","Mary Jane","Nissan","Pulsar","Sedan","Silver",2000,16,3600,"South"]
[280,"2014-01-13","Peter Parker","Ford","Raven","Sedan","Yellow",2012,4,12500,"South"]
[281,"2014-04-26","Peter Parker","BMW","Z4","Coupe","Red",2013,3,25000,"North"]
[282,"2014-03-15","Oliver Queen","Toyota","Camry","Sedan","White",2005,11,5600,"North"]
[283,"2014-10-16","Lois Lane","Toyota","Corolla","Wagon","Silver",1996,20,1400,"South"]
[284,"2014-03-26","Oliver Queen","KIA","Stellar","Sedan","Silver",1995,21,2700,"South"]
[285,"2014-12-31","Oliver Queen","Volkswagen","Toureg","SUV","Silver",1993,23,2400,"South"]
[286,"2014-03-07","Lois Lane","Mitsubishi","Lancer","Sedan","Silver",2011,5,8400,"North"]
[287,"2014-03-25","Peter Parker","GMH","Adventurer","SUV","Green",2008,8,4200,"North"]
[288,"2014-03-21","Oliver Queen","BMW","5 Series","Sedan","White",1997,19,3000,"South"]
[289,"2014-12-07","Mary Jane","Nissan","350z","Coupe","Silver",2002,14,4200,"North"]
[290,"2014-06-23","Lois Lane","Mitsubishi","Pajero","SUV","Red",2004,12,5000,"South"]
[291,"2014-07-31","Lois Lane","Toyota","Camry","Sedan","Silver",2007,9,7200,"South"]
[292,"2014-03-19","Oliver Queen","BMW","5 Series","Sedan","Blue",2000,16,3600,"East"]
[293,"2014-04-12","Oliver Queen","Ford","Mustang","Coupe","Green",2004,12,2500,"North"]
[294,"2014-01-16","Oliver Queen","Volkswagen","Golf","Coupe","Silver",2008,8,4200,"South"]
[295,"2014-06-23","Lois Lane","Nissan","Estate","Wagon","Green",1996,20,2800,"South"]
[296,"2014-01-17","Peter Parker","BMW","3 Series","Sedan","Red",2006,10,3200,"South"]
[297,"2014-12-17","Peter Parker","Renault","Megane","Sedan","Green",1994,22,2500,"East"]
[298,"2014-09-14","Oliver Queen","KIA","Ranger","SUV","Silver",2008,8,8400,"North"]
[299,"2014-12-30","Mary Jane","BMW","7 Series","Sedan","Red",2007,9,7200,"South"]
[300,"2014-07-10","Peter Parker","BMW","X5","SUV","Yellow",2011,5,8400,"North"]
[301,"2014-06-17","Lois Lane","Ford","Fiesta","Sedan","Green",1998,18,3200,"North"]
[302,"2014-11-24","Oliver Queen","Nissan","Maxima","Sedan","Red",2000,16,1800,"South"]
[303,"2014-02-10","Oliver Queen","Nissan","Maxima","Sedan","White",2009,7,10000,"North"]
[304,"2014-03-17","Lois Lane","Mitsubishi","Magna","Sedan","Silver",2013,3,50000,"North"]
[305,"2014-03-11","Lois Lane","Peugot","Supreme","Sedan","Blue",1996,20,2800,"East"]
[306,"2014-02-20","Peter Parker","Toyota","Corolla","Sedan","Red",2007,9,3600,"South"]
[307,"2014-11-23","Lois Lane","Toyota","Corolla","Sedan","Red",2013,{"$f":"YEAR(NOW())-H308","v":3},25000,"South"]
[308,"2014-03-04","Peter Parker","BMW","3 Series","Sedan","Silver",2008,{"$f":"YEAR(NOW())-H309","v":8},4200,"East"]
[309,"2014-07-03","Oliver Queen","Toyota","Celica","Coupe","Yellow",1993,23,1200,"South"]
[310,"2014-04-17","Lois Lane","Ford","Explorer","SUV","Silver",2013,3,25000,"South"]
[311,"2014-02-14","Mary Jane","Hyundai","Elantra","Sedan","White",1995,21,1400,"East"]
[312,"2014-05-11","Peter Parker","Ford","Fiesta","Sedan","Green",2000,16,1800,"East"]
[313,"2014-12-09","Oliver Queen","BMW","Z3","Coupe","Silver",2002,14,2100,"South"]
[314,"2014-11-27","Oliver Queen","Toyota","Corolla","Sedan","White",2005,11,2800,"South"]
[315,"2014-08-15","Lois Lane","Toyota","Camry","Wagon","Yellow",2003,13,4600,"South"]
[316,"2014-04-29","Lois Lane","KIA","Mini","Sedan","Red",2006,10,6300,"North"]
[317,"2014-02-05","Lois Lane","Volkswagen","Toureg","SUV","Silver",1994,22,2500,"North"]
[318,"2014-06-13","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2005,11,2800,"North"]
[319,"2014-10-14","Oliver Queen","GMH","Adventurer","SUV","White",1993,23,1200,"South"]
[320,"2014-01-17","Oliver Queen","KIA","Micro","Sedan","Red",2006,10,6300,"East"]
[321,"2014-10-07","Mary Jane","Ford","Mercury","Coupe","Blue",2002,14,4200,"North"]
[322,"2014-04-25","Peter Parker","BMW","Z4","Coupe","Red",2007,9,3600,"South"]
[323,"2014-04-05","Peter Parker","Renault","Tricolour","Wagon","Silver",2004,12,2500,"North"]
[324,"2014-08-15","Oliver Queen","Hyundai","Elantra","Coupe","Silver",1995,21,2700,"North"]
[325,"2014-02-17","Lois Lane","Peugot","Supreme","Sedan","White",2003,13,2300,"South"]
[326,"2014-12-25","Oliver Queen","Ford","Mercury","Coupe","Red",2009,7,5000,"South"]
[327,"2014-10-04","Lois Lane","Renault","Mountaineer","SUV","Yellow",1992,24,2300,"South"]
[328,"2014-06-22","Oliver Queen","Toyota","Landcruiser","SUV","White",2010,6,12500,"South"]
[329,"2014-01-10","Oliver Queen","GMH","Adventurer","SUV","Silver",2006,10,3200,"East"]
[330,"2014-03-06","Lois Lane","Volkswagen","Beetle","Sedan","Red",1992,24,1200,"North"]
[331,"2014-06-25","Mary Jane","BMW","7 Series","Sedan","Red",2011,5,8400,"South"]
[332,"2014-06-23","Oliver Queen","BMW","Z3","Coupe","Blue",1994,22,2500,"North"]
[333,"2014-12-22","Lois Lane","Ford","Ecstasy","Wagon","Silver",2000,16,1800,"North"]
[334,"2014-10-19","Lois Lane","Ford","Fiesta","Sedan","Red",2006,10,6300,"South"]
[335,"2014-03-13","Lois Lane","Volkswagen","Beetle","Sedan","Red",2011,5,8400,"East"]
[336,"2014-09-15","Lois Lane","Renault","Formula 1","Coupe","Blue",2013,3,50000,"South"]
[337,"2014-12-01","Peter Parker","Nissan","Pulsar","Sedan","Silver",2003,13,2300,"East"]
[338,"2014-09-30","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2013,3,50000,"North"]
[339,"2014-12-30","Oliver Queen","Nissan","Pulsar","Sedan","Yellow",2004,12,5000,"South"]
[340,"2014-03-08","Oliver Queen","KIA","Stellar","Sedan","Silver",1996,20,1400,"South"]
[341,"2014-06-15","Mary Jane","Toyota","Celica","Coupe","Red",1995,21,2700,"South"]
[342,"2014-12-04","Peter Parker","Toyota","Celica","Coupe","Red",1996,20,1400,"South"]
[343,"2014-04-20","Oliver Queen","Ford","Mercury","Coupe","Red",1994,22,1300,"North"]
[344,"2014-06-07","Lois Lane","Renault","Megane","Sedan","Green",1993,23,2400,"South"]
[345,"2014-08-29","Lois Lane","Volkswagen","Golf","Coupe","Green",1992,24,1200,"East"]
[346,"2014-04-26","Oliver Queen","BMW","3 Series","Sedan","Red",2009,7,5000,"North"]
[347,"2014-12-29","Peter Parker","KIA","Micro","Sedan","Red",2010,6,12500,"South"]
[348,"2014-12-03","Oliver Queen","Renault","Megane","Sedan","Red",2000,16,1800,"South"]
[349,"2014-07-05","Lois Lane","Renault","LeMans","Sedan","Green",1995,21,1400,"North"]
[350,"2014-11-06","Oliver Queen","BMW","X5","SUV","Silver",1992,24,1200,"North"]
[351,"2014-10-15","Mary Jane","Renault","Lemans","Sedan","Silver",2002,14,4200,"South"]
[352,"2014-12-08","Lois Lane","KIA","Ranger","SUV","Silver",1995,21,2700,"East"]
[353,"2014-12-07","Peter Parker","BMW","3 Series","Sedan","White",2005,11,2800,"North"]
[354,"2014-12-02","Oliver Queen","BMW","X3","SUV","White",1999,17,1700,"South"]
[355,"2014-04-17","Lois Lane","Ford","Fiesta","Sedan","Red",2003,13,2300,"East"]
[356,"2014-09-21","Lois Lane","Nissan","Pulsar","Sedan","Silver",1995,21,1400,"East"]
[357,"2014-09-09","Oliver Queen","Nissan","Pulsar","Sedan","Green",1999,17,3400,"North"]
[358,"2014-11-16","Oliver Queen","Mitsubishi","Magna","Sedan","Silver",2007,9,3600,"South"]
[359,"2014-12-29","Lois Lane","Peugot","Supreme","Sedan","Silver",1996,20,1400,"North"]
[360,"2014-07-25","Oliver Queen","Toyota","Corolla","Sedan","Blue",1993,23,2400,"South"]
[361,"2014-08-27","Mary Jane","BMW","7 Series","Sedan","Green",2004,12,5000,"South"]
[362,"2014-07-08","Lois Lane","GMH","Traveller","Wagon","Red",2009,7,10000,"East"]
[363,"2014-02-12","Peter Parker","BMW","Z3","Coupe","Green",2012,4,25000,"South"]
[364,"2014-11-09","Peter Parker","Volkswagen","Golf","Coupe","Red",2002,14,4200,"South"]
[365,"2014-10-28","Oliver Queen","GMH","Adventurer","SUV","Silver",2010,6,6300,"North"]
[366,"2014-02-08","Lois Lane","Ford","Explorer","SUV","Yellow",2012,4,25000,"North"]
[367,"2014-12-05","Oliver Queen","BMW","3 Series","Sedan","White",1996,20,2800,"South"]
[368,"2014-05-03","Lois Lane","Nissan","350z","Coupe","Green",1998,18,3200,"East"]
[369,"2014-02-20","Oliver Queen","Mitsubishi","Pajero","SUV","Red",2012,4,12500,"South"]
[370,"2014-02-15","Peter Parker","Toyota","Camry","Sedan","Red",1995,21,2700,"North"]
[371,"2014-08-07","Mary Jane","BMW","7 Series","Sedan","Silver",2012,4,12500,"East"]
[372,"2014-05-08","Lois Lane","Ford","Mercury","Coupe","Blue",2004,{"$f":"YEAR(NOW())-H373","v":12},2500,"South"]
[373,"2014-02-22","Lois Lane","Volkswagen","Golf","Coupe","White",1994,22,2500,"South"]
[374,"2014-07-30","Lois Lane","Nissan","Estate","Wagon","Red",1999,17,3400,"South"]
[375,"2014-02-05","Peter Parker","BMW","7 Series","Sedan","Red",2009,7,5000,"South"]
[376,"2014-05-13","Oliver Queen","Peugot","Supreme","Coupe","Red",2004,12,2500,"East"]
[377,"2014-12-29","Oliver Queen","Toyota","Rav 4","Coupe","Silver",1991,25,2200,"North"]
[378,"2014-05-03","Lois Lane","Volkswagen","Passat","Wagon","Green",2006,10,3200,"South"]
[379,"2014-12-02","Oliver Queen","Nissan","350z","Coupe","Red",1992,24,1200,"East"]
[380,"2014-02-19","Oliver Queen","Ford","Fiesta","Sedan","Silver",1999,17,1700,"North"]
[381,"2014-03-08","Mary Jane","Nissan","Pulsar","Sedan","Silver",1998,18,3200,"South"]
[382,"2014-03-01","Peter Parker","Ford","Raven","Sedan","Yellow",1998,18,3200,"South"]
[383,"2014-09-18","Peter Parker","BMW","Z4","Coupe","Red",2000,16,1800,"North"]
[384,"2014-02-23","Oliver Queen","Toyota","Camry","Sedan","White",1998,18,1600,"North"]
[385,"2014-04-17","Lois Lane","Toyota","Corolla","Wagon","Silver",1998,18,3200,"South"]
[386,"2014-05-16","Oliver Queen","KIA","Stellar","Sedan","Silver",2009,7,5000,"South"]
[387,"2014-06-07","Oliver Queen","Volkswagen","Toureg","SUV","Silver",1996,20,1400,"South"]
[388,"2014-02-22","Lois Lane","Mitsubishi","Lancer","Sedan","Silver",1998,18,1600,"North"]
[389,"2014-11-21","Peter Parker","GMH","Adventurer","SUV","Green",2013,3,50000,"North"]
[390,"2014-07-13","Oliver Queen","BMW","5 Series","Sedan","White",1999,17,1700,"South"]
[391,"2014-11-10","Mary Jane","Nissan","350z","Coupe","Silver",1997,19,3000,"North"]
[392,"2014-01-26","Lois Lane","Mitsubishi","Pajero","SUV","Red",2013,3,25000,"South"]
[393,"2014-06-02","Lois Lane","Toyota","Camry","Sedan","Silver",1992,24,2300,"South"]
[394,"2014-01-06","Oliver Queen","BMW","5 Series","Sedan","Blue",2009,7,5000,"East"]
[395,"2014-08-28","Oliver Queen","Ford","Mustang","Coupe","Green",2009,7,10000,"North"]
[396,"2014-03-30","Oliver Queen","Volkswagen","Golf","Coupe","Silver",1999,17,3400,"South"]
[397,"2014-05-09","Lois Lane","Nissan","Estate","Wagon","Green",2011,5,8400,"South"]
[398,"2014-10-10","Peter Parker","BMW","3 Series","Sedan","Red",1992,24,2300,"South"]
[399,"2014-04-09","Peter Parker","Renault","Megane","Sedan","Green",1991,25,2200,"East"]
[400,"2014-09-27","Oliver Queen","KIA","Ranger","SUV","Silver",1994,22,2500,"North"]
[401,"2014-11-18","Mary Jane","BMW","7 Series","Sedan","Red",1994,22,1300,"South"]
[402,"2014-06-22","Peter Parker","BMW","X5","SUV","Yellow",2002,14,2100,"North"]
[403,"2014-09-26","Lois Lane","Ford","Fiesta","Sedan","Green",2001,15,3900,"North"]
[404,"2014-06-01","Oliver Queen","Nissan","Maxima","Sedan","Red",1994,22,1300,"South"]
[405,"2014-02-10","Oliver Queen","Nissan","Maxima","Sedan","White",1997,19,1500,"North"]
[406,"2014-05-06","Lois Lane","Mitsubishi","Magna","Sedan","Silver",2013,3,50000,"North"]
[407,"2014-01-08","Lois Lane","Peugot","Supreme","Sedan","Blue",2003,13,4600,"East"]
[408,"2014-10-13","Peter Parker","Toyota","Corolla","Sedan","Red",2007,9,3600,"South"]
[409,"2014-02-07","Lois Lane","Toyota","Corolla","Sedan","Red",2001,{"$f":"YEAR(NOW())-H410","v":15},3900,"South"]
[410,"2014-05-30","Peter Parker","BMW","3 Series","Sedan","Silver",1994,{"$f":"YEAR(NOW())-H411","v":22},1300,"East"]
[411,"2014-06-12","Oliver Queen","Toyota","Celica","Coupe","Yellow",1999,17,1700,"South"]
[412,"2014-10-09","Lois Lane","Ford","Explorer","SUV","Silver",1991,25,1100,"South"]
[413,"2014-09-02","Mary Jane","Hyundai","Elantra","Sedan","White",2000,16,3600,"East"]
[414,"2014-06-19","Peter Parker","Ford","Fiesta","Sedan","Green",1999,17,3400,"East"]
[415,"2014-08-16","Oliver Queen","BMW","Z3","Coupe","Silver",2001,15,3900,"South"]
[416,"2014-04-22","Oliver Queen","Toyota","Corolla","Sedan","White",2003,13,4600,"South"]
[417,"2014-12-02","Lois Lane","Toyota","Camry","Wagon","Yellow",2001,15,2000,"South"]
[418,"2014-01-24","Lois Lane","KIA","Mini","Sedan","Red",1997,19,1500,"North"]
[419,"2014-06-28","Lois Lane","Volkswagen","Toureg","SUV","Silver",1995,21,2700,"North"]
[420,"2014-06-21","Peter Parker","Mitsubishi","Lancer","Sedan","Red",2003,13,2300,"North"]
[421,"2014-05-17","Oliver Queen","GMH","Adventurer","SUV","White",2007,9,7200,"South"]
[422,"2014-04-29","Oliver Queen","KIA","Micro","Sedan","Red",2010,6,12500,"East"]
[423,"2014-03-18","Mary Jane","Ford","Mercury","Coupe","Blue",2003,13,4600,"North"]
[424,"2014-04-20","Peter Parker","BMW","Z4","Coupe","Red",2005,11,2800,"South"]
[425,"2014-12-20","Peter Parker","Renault","Tricolour","Wagon","Silver",1994,22,2500,"North"]
[426,"2014-03-29","Oliver Queen","Hyundai","Elantra","Coupe","Silver",1994,22,1300,"North"]
[427,"2014-11-18","Lois Lane","Peugot","Supreme","Sedan","White",1997,19,3000,"South"]
[428,"2014-11-26","Oliver Queen","Ford","Mercury","Coupe","Red",2013,3,50000,"South"]
[429,"2014-11-19","Lois Lane","Renault","Mountaineer","SUV","Yellow",2000,16,3600,"South"]
[430,"2014-07-31","Oliver Queen","Toyota","Landcruiser","SUV","White",1996,20,2800,"South"]
[431,"2014-09-03","Oliver Queen","GMH","Adventurer","SUV","Silver",1995,21,1400,"East"]
[432,"2014-01-27","Lois Lane","Volkswagen","Beetle","Sedan","Red",1993,23,2400,"North"]
[433,"2014-06-29","Mary Jane","BMW","7 Series","Sedan","Red",1992,24,1200,"South"]
[434,"2014-01-06","Oliver Queen","BMW","Z3","Coupe","Blue",1998,18,1600,"North"]
[435,"2014-06-18","Lois Lane","Ford","Ecstasy","Wagon","Silver",2004,12,5000,"North"]
[436,"2014-06-24","Lois Lane","Ford","Fiesta","Sedan","Red",1992,24,1200,"South"]
[437,"2014-02-01","Lois Lane","Volkswagen","Beetle","Sedan","Red",2007,9,3600,"East"]
[438,"2014-02-26","Lois Lane","Renault","Formula 1","Coupe","Blue",2004,12,2500,"South"]
[439,"2014-08-13","Peter Parker","Nissan","Pulsar","Sedan","Silver",2002,14,4200,"East"]
[440,"2014-09-17","Peter Parker","Mitsubishi","Lancer","Sedan","Red",1996,20,1400,"North"]
[441,"2014-08-24","Oliver Queen","Nissan","Pulsar","Sedan","Yellow",2011,5,16700,"South"]
[442,"2014-09-09","Oliver Queen","KIA","Stellar","Sedan","Silver",2005,11,2800,"South"]
[443,"2014-01-29","Mary Jane","Toyota","Celica","Coupe","Red",1999,17,1700,"South"]
[444,"2014-08-19","Peter Parker","Toyota","Celica","Coupe","Red",2009,7,10000,"South"]
[445,"2014-04-24","Oliver Queen","Ford","Mercury","Coupe","Red",2012,4,12500,"North"]
[446,"2014-01-15","Lois Lane","Renault","Megane","Sedan","Green",2005,11,5600,"South"]
[447,"2014-12-18","Lois Lane","Volkswagen","Golf","Coupe","Green",2002,14,2100,"East"]
[448,"2014-01-05","Oliver Queen","BMW","3 Series","Sedan","Red",2011,5,8400,"North"]
[449,"2014-06-20","Peter Parker","KIA","Micro","Sedan","Red",2008,8,4200,"South"]
[450,"2014-09-17","Oliver Queen","Renault","Megane","Sedan","Red",2007,9,7200,"South"]
[451,"2014-12-23","Lois Lane","Renault","LeMans","Sedan","Green",2013,3,50000,"North"]
[452,"2014-06-20","Oliver Queen","BMW","X5","SUV","Silver",1998,18,3200,"North"]
[453,"2014-03-20","Mary Jane","Renault","Lemans","Sedan","Silver",2006,10,3200,"South"]
[454,"2014-10-12","Lois Lane","KIA","Ranger","SUV","Silver",2012,4,12500,"East"]
[455,"2014-09-10","Peter Parker","BMW","3 Series","Sedan","White",2008,8,8400,"North"]
[456,"2014-10-03","Oliver Queen","BMW","X3","SUV","White",2012,4,25000,"South"]
[457,"2014-08-13","Lois Lane","Ford","Fiesta","Sedan","Red",2010,6,6300,"East"]
[458,"2014-08-02","Lois Lane","Nissan","Pulsar","Sedan","Silver",2008,8,8400,"East"]
[459,"2014-03-12","Oliver Queen","Nissan","Pulsar","Sedan","Green",2005,11,2800,"North"]
[460,"2014-01-02","Oliver Queen","Mitsubishi","Magna","Sedan","Silver",2009,7,5000,"South"]
[461,"2014-09-20","Lois Lane","Peugot","Supreme","Sedan","Silver",2008,8,4200,"North"]
[462,"2014-10-17","Oliver Queen","Toyota","Corolla","Sedan","Blue",2002,14,2100,"South"]
[463,"2014-05-31","Mary Jane","BMW","7 Series","Sedan","Green",2002,14,2100,"South"]
[464,"2014-11-24","Lois Lane","GMH","Traveller","Wagon","Red",2000,16,3600,"East"]
[465,"2014-01-12","Peter Parker","BMW","Z3","Coupe","Green",2013,3,25000,"South"]
[466,"2014-05-30","Peter Parker","Volkswagen","Golf","Coupe","Red",2000,16,1800,"South"]
[467,"2014-10-04","Oliver Queen","GMH","Adventurer","SUV","Silver",2006,10,3200,"North"]
[468,"2014-02-10","Lois Lane","Ford","Explorer","SUV","Yellow",2005,11,5600,"North"]
[469,"2014-05-14","Oliver Queen","BMW","3 Series","Sedan","White",1995,21,2700,"South"]
[470,"2014-10-14","Lois Lane","Nissan","350z","Coupe","Green",2002,14,2100,"East"]
[471,"2014-08-11","Oliver Queen","Mitsubishi","Pajero","SUV","Red",1998,18,1600,"South"]
[472,"2014-06-16","Peter Parker","Toyota","Camry","Sedan","Red",2013,3,50000,"North"]
[473,"2014-03-20","Mary Jane","BMW","7 Series","Sedan","Silver",2007,9,3600,"East"]
[474,"2014-03-14","Lois Lane","Ford","Mercury","Coupe","Blue",2008,{"$f":"YEAR(NOW())-H475","v":8},4200,"South"]
[475,"2014-12-23","Lois Lane","Volkswagen","Golf","Coupe","White",1998,18,1600,"South"]
[476,"2014-11-08","Lois Lane","Nissan","Estate","Wagon","Red",2003,13,2300,"South"]
[477,"2014-11-10","Peter Parker","BMW","7 Series","Sedan","Red",1995,21,1400,"South"]
[478,"2014-12-12","Oliver Queen","Peugot","Supreme","Coupe","Red",1991,25,1100,"East"]
[479,"2014-01-05","Oliver Queen","Toyota","Rav 4","Coupe","Silver",2006,10,6300,"North"]
[480,"2014-03-14","Lois Lane","Volkswagen","Passat","Wagon","Green",2010,6,12500,"South"]
[481,"2014-05-20","Oliver Queen","Nissan","350z","Coupe","Red",2005,11,5600,"East"]
[482,"2014-01-23","Oliver Queen","Ford","Fiesta","Sedan","Silver",2004,12,2500,"North"]
[483,"2014-02-23","Mary Jane","Nissan","Pulsar","Sedan","Silver",2012,4,12500,"South"]
[484,"2014-10-10","Peter Parker","Ford","Raven","Sedan","Yellow",2004,12,5000,"South"]
[485,"2014-11-15","Peter Parker","BMW","Z4","Coupe","Red",2001,15,3900,"North"]
[486,"2014-09-06","Oliver Queen","Toyota","Camry","Sedan","White",2012,4,12500,"North"]
[487,"2014-10-25","Lois Lane","Toyota","Corolla","Wagon","Silver",2002,14,4200,"South"]
[488,"2014-12-07","Oliver Queen","KIA","Stellar","Sedan","Silver",1998,18,3200,"South"]
[489,"2014-04-11","Oliver Queen","Volkswagen","Toureg","SUV","Silver",2011,5,8400,"South"]
[490,"2014-04-06","Lois Lane","Mitsubishi","Lancer","Sedan","Silver",1994,22,2500,"North"]
[491,"2014-09-26","Peter Parker","GMH","Adventurer","SUV","Green",2005,11,5600,"North"]
[492,"2014-01-02","Oliver Queen","BMW","5 Series","Sedan","White",2013,3,50000,"South"]
[493,"2014-05-22","Mary Jane","Nissan","350z","Coupe","Silver",1999,17,3400,"North"]
[494,"2014-03-19","Lois Lane","Mitsubishi","Pajero","SUV","Red",2002,14,2100,"South"]
[495,"2014-03-30","Lois Lane","Toyota","Camry","Sedan","Silver",1996,20,2800,"South"]
[496,"2014-06-07","Oliver Queen","BMW","5 Series","Sedan","Blue",2011,5,16700,"East"]
[497,"2014-12-27","Oliver Queen","Ford","Mustang","Coupe","Green",2012,4,12500,"North"]
[498,"2014-01-11","Oliver Queen","Volkswagen","Golf","Coupe","Silver",2003,13,4600,"South"]
[499,"2014-06-16","Lois Lane","Nissan","Estate","Wagon","Green",2004,12,2500,"South"]
[500,"2014-08-31","Peter Parker","BMW","3 Series","Sedan","Red",1995,21,1400,"South"]
[501,"2014-01-09","Peter Parker","Renault","Megane","Sedan","Green",2003,13,2300,"East"]
[502,"2014-01-26","Oliver Queen","KIA","Ranger","SUV","Silver",2008,8,8400,"North"]
[503,"2014-07-14","Mary Jane","BMW","7 Series","Sedan","Red",1995,21,2700,"South"]
[504,"2014-09-15","Peter Parker","BMW","X5","SUV","Yellow",2013,3,50000,"North"]
[505,"2014-10-15","Lois Lane","Ford","Fiesta","Sedan","Green",2013,3,25000,"North"]
[506,"2014-10-05","Oliver Queen","Nissan","Maxima","Sedan","Red",2012,4,12500,"South"]
[507,"2014-04-13","Oliver Queen","Nissan","Maxima","Sedan","White",2001,15,3900,"North"]
[508,"2014-03-27","Lois Lane","Mitsubishi","Magna","Sedan","Silver",2013,3,50000,"North"]
[509,"2014-07-28","Lois Lane","Peugot","Supreme","Sedan","Blue",1994,22,1300,"East"]
[510,"2014-09-11","Peter Parker","Toyota","Corolla","Sedan","Red",2005,11,5600,"South"]
[511,"2014-07-29","Mary Jane","Peugot","Supreme","Sedan","Blue",1999,17,3400,"East"]
[512,"2014-04-30","Mary Jane","Toyota","Corolla","Sedan","Red",2009,7,5000,"South"]
[513,"2014-10-31","Mary Jane","Toyota","Corolla","Sedan","Red",2010,{"$f":"YEAR(NOW())-H514","v":6},6300,"South"]
[514,"2014-10-22","Mary Jane","BMW","3 Series","Sedan","Silver",1999,{"$f":"YEAR(NOW())-H515","v":17},1700,"East"]
[515,"2014-02-18","Mary Jane","Toyota","Celica","Coupe","Yellow",1996,{"$f":"YEAR(NOW())-H516","v":20},2800,"South"]