{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Tech Pay","Input Sheet","RO Report 1-50","RO Report 51-100","Summary Report"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"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":"Title","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,0,15,9],[16,0,16,9],[35,7,39,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Repair Order Analysis"]
["And Summary",null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-28"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dealership "]
[]
[]
["Student "]
[]
[]
["Class and ID Number",null,null,null,null,null,null,"Computer Application by            George A. Parker                Management Instructor           NADA Dealer Academy"]

{"sheet":"Tech Pay","index":1,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Tech #","Tech Pay Per FRH"]
[null,61,34]
[null,131,22]
[null,223,30]
[null,439,15]
[null,1354,26]
[null,1404,24,"          "]
[null,1408,28]
[null,2087,13.5]
[null,2111,19]
[null,2140,20]
[null,2170,31]
[null,2331,19]
[null,2384,12.5]
[null,2529,30]
[null,2623,25]
[null,2664,15]
[null,2674,12.5]
[null,2762,12.5]
[null,2678,12.5]
[null,2768,12.5]
[null,2801,12.5]
[null,2816,20]
[null,2830,24]
[null,2833,17]
[null,2840,12.5]
[null,3044,22]

{"sheet":"Input Sheet","index":2,"n_rows":113,"n_cols":23,"rows_kept":113,"cut":false,"hidden":false,"merged":[[2,22,4,22],[3,2,4,2],[2,16,2,20],[3,16,4,16],[3,17,4,17],[3,3,4,3],[3,4,4,4],[3,5,4,5],[1,2,1,6],[2,21,4,21],[2,6,2,10],[2,11,2,15],[3,11,4,11],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,20,4,20],[107,18,108,18],[107,19,108,19],[107,6,108,6],[107,7,108,7],[107,8,108,8],[107,9,108,9],[107,10,108,10],[107,20,108,20],[106,21,108,21],[106,22,108,22],[106,6,106,10],[3,10,4,10],[106,11,106,15],[106,16,106,20],[107,11,108,11],[107,12,108,12],[107,13,108,13],[107,14,108,14],[107,15,108,15],[107,16,108,16],[107,17,108,17],[3,18,4,18],[3,19,4,19]]}
[]
[null,null,"Repair Order Analysis Input Sheet"]
[null,null,null,null,null,null,"Competitive Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
[null,null,"RO Number","Year","Model ","Mileage","Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost "]
[]
[null,1,630003,2013,"SUBURBAN",66161,null,null,null,null," ",90.52,1.5,2762,12.5,{"$f":"IF(ISERROR(M6*O6),\" \",M6*O6)","v":18.75},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S6,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S6,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(R6*T6),\"\",R6*T6)","v":""},{"$f":"SUM(U6,P6,K6)","v":18.75},0]
[null,2,630006,2015,"SIERRA",32182," ",null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I7,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I7,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H7*J7),\"\",H7*J7)","v":""},36.520000000000003,0.9,2762,12.5,11.25," "," "," "," ","",{"$f":"SUM(U7,P7,K7)","v":11.25},0]
[null,3,630009,2010,"WRANGLER",147618,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I8,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H8*J8),\"\",H8*J8)","v":""},66.47,1.2,2860,12.5,15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE))","v":""},"",15,0]
[null,4,630010,2016,"TERRAIN",26550,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I9,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2860,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,5,630013,2012,"SIENNA",52281,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I10,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I10,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H10*J10),\"\",H10*J10)","v":""},24.95,0.7,2087,13.5,9.4499999999999993,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S10,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S10,TechNumber,2,FALSE))","v":""},"",9.4499999999999993,0]
[null,6,630016,2013,"YUKON",92099,1078,9.6,2331,19,182.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N11,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N11,TechNumber,2,FALSE))","v":""}," ",183.2,1.5,1354,26,39,221.4,0]
[null,7,630018,2016,"TERRAIN",19222,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I12,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,8,630024,2017,"ENCLAVE",7620,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I13,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE))","v":""},"",5,1]
[null,9,630025,2013,"MALIBU",81249,125,1.5,2830,24,36,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N14,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE))","v":""},"",36,0]
[null,10,630026,2008,"YUKON",215634,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE))","v":""},"",56.52,1.2,2768,12.5,15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S15,TechNumber,2,FALSE))","v":""},"",15,0]
[null,11,630029,2006,"GTO",102288,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE))","v":""},"",5,1]
[null,12,630036,2015,"SIERRA",48110,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I17,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE))","v":""}," ",236,2,131,22,44,44,0]
[null,13,630037,2016,"REGAL",23894,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE))","v":""},"",30,0.6,2762,12.5,7.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE))","v":""},"",7.5,1]
[null,14,630039,2016,"SIERRA",30149,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE))","v":""},"",200,0.7,2860,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,15,630040,2016,"TERRAIN",27399,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2087,13.5,5.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE))","v":""},"",5.4,1]
[null,16,630043,2011,"SIERRA",168435,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S21,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,17,630045,2006,"CORVETTE",42596,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N22,TechNumber,2,FALSE))","v":""}," ",590,5,131,22,110,110,0]
[null,18,630048,2015,"SILVERADO",49027,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE))","v":""},"",5,1]
[null,19,630049,2016,"TERRAIN",17267,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S24,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,20,630050,2015,"SIERRA",27094,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE))","v":""},"",14.62,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S25,TechNumber,2,FALSE))","v":""},"",5,1]
[null,21,630051,2016,"TERRAIN",20260,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE))","v":""},"",53.52,1.2,2768,12.8,15.36,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE))","v":""},"",15.36,0]
[null,22,630052,2015,"TERRAIN",16712,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,23,630056,2015,"YUKON",29079,80,1,131,22,22,null,null,null," "," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE))","v":""},"",22,0]
[null,24,630059,2012,"TERRAIN",76069,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE))","v":""},"",5,1]
[null,25,630064,2016,"SIERRA",20925,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE))","v":""},"",27,0.3,2674,12.5,3.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE))","v":""},"",3.75,1]
[null,26,630067,2008,"AURA",103932,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE))","v":""},"",5,0]
[null,27,630069,2015,"TERRAIN",87540,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,28,630071,2012,"ACADIA",104376,129.94999999999999,1.5,61,34,51,48,1.2,2678,12.5,15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE))","v":""},"",66,0]
[null,29,630073,2013,"TERRAIN",46165,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE))","v":""},"",12,0.3,2674,12.5,3.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S34,TechNumber,2,FALSE))","v":""},"",3.75,1]
[null,30,630075,2015,"SIERRA",46084,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE))","v":""},"",24.57,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,31,630081,2014,"CAMARO",71002,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE))","v":""},"",5,1]
[null,32,630090,2012,"SIERRA",49898,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2801,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,33,630091,2011,"F-150",133571,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE))","v":""},"",24.95,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S38,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,34,630092,2009,"SILVERADO",56244,50,0.5,1354,26,13,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE))","v":""}," ",244.26,2,1354,26,52,65,0]
[null,35,630096,2015,"YUKON",44801,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE))","v":""}," ",641.22,5.5,"2830/2529",28,154,154,0]
[null,36,630099,2011,"SIERRA",38406,439.69,5.3,"2623/1354/2830",25,132.5,74.52,1.9,"2768/2830",20,38,295,2.5,2830,24,60,230.5,0]
[null,37,631001,2008,"LACROSSE",152107,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE))","v":""},"",18.36,0.4,2762,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE))","v":""},"",5,0]
[null,38,631003,2014,"ENCORE",54260,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE))","v":""},"",21.57,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE))","v":""},"",5,0]
[null,39,631005,2016,"ACADIA",26420,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2781,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,40,631007,2016,"ENVISION",28340,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2860,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,41,631009,2008,"VUE",44316,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE))","v":""}," ",59,0.5,2331,19,9.5,9.5,1]
[null,42,631016,2014,"ENCLAVE",34488,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE))","v":""},"",66.52,1.2,2678,12.5,15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE))","v":""},"",15,0]
[null,43,631017,2014,"SILVERADO",33497,59.95,1,2816,20,20,39.950000000000003,0.8,2816,20,16,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE))","v":""},"",36,0]
[null,44,631019,2016,"CHEVROLET",28569,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2762,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,45,631021,2004,"ALERO",111000,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE))","v":""}," ",244.26,2,131,22,44,44,0]
[null,46,631027,2014,"REGAL",45709,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE))","v":""},"",5,1]
[null,47,631029,2012,"ACADIA",63847,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE))","v":""}," ",177,1.5,2170,32,48,48,1]
[null,48,631039,2009,"CANYON",138232,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S53,TechNumber,2,FALSE))","v":""},"",5,1]
[null,49,631040,2011,"MALIBU",53819,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE))","v":""},"",5,1]
[null,50,631042,2016,"ACADIA",42324,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2087,13.5,5.4,118,1,131,22,22,27.4,0]
[null,51,631043,2015,"SILVERADO",35557,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE))","v":""},"",26.52,0.8,2860,12.5,10,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE))","v":""},"",10,0]
[null,52,631049,2011,"ACADIA",120043,139.94999999999999,1.5,2816,20,30,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE))","v":""}," ",247.8,2.1,2816,20,42,72,0]
[null,53,631050,2009,"ENCLAVE",94062,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I58,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N58,TechNumber,2,FALSE))","v":""}," ",916.89,6.5,2170,32,208,208,1]
[null,54,631055,2012,"MALIBU",81283,222.1,2.9,"2786/2180",16,46.4,35,1,2786,12.5,12.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE))","v":""},"",58.9,0]
[null,55,631059,2015,"LACROSSE",30178,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE))","v":""},"",5,1]
[null,56,631063,2012,"SIERRA",51378,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2860,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE))","v":""},"",5,1]
[null,57,631069,2007,"9-7 SAAB",130382,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2762,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE))","v":""},"",5,1]
[null,58,631073,2014,"SIERRA",33580,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2087,13.5,5.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE))","v":""},"",5.4,1]
[null,59,631074,2014,"TERRAIN",37902,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,60,631077,2010,"IMPALA",88318,76.05,1,61,34,34,9.9499999999999993,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE))","v":""},"",39,0]
[null,61,631086,2008,"LUCERNE",94860,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE))","v":""},"",5,1]
[null,62,632008,2004,"AZTEK",89096,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE))","v":""},"",32,0.4,2801,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE))","v":""},"",5,1]
[null,63,632012,2016,"TRAX",27653,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,64,632013,2005,"VENTURE",66808,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE))","v":""},"",23.31,0.7,2781,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,65,632015,2011,"SIERRA",109691,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I70,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I70,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H70*J70),\"\",H70*J70)","v":""},26.52,0.7,2860,12.5,{"$f":"IF(ISERROR(M70*O70),\" \",M70*O70)","v":8.75},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S70,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S70,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(R70*T70),\"\",R70*T70)","v":""},8.75,0]
[null,66,632031,2010,"MARINER",182552,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2860,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U71,P71,K71)","v":5},1]
[null,67,632033,2014,"ENCORE",37603,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE))","v":""},"",5,1]
[null,68,632036,2016,"FUSION",39941,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE))","v":""},"",29.95,0.7,2781,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,69,632041,2011,"TERRAIN",157488,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S74,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,70,632043,2011,"SILVERADO",28240,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I75,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2678,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE))","v":""},"",5,1]
[null,71,632045,2009,"ENCLAVE",74912,89.95,1.5,1354,26,39," "," "," "," "," ",1345,12.1,1354,26,314.59999999999997,353.59999999999997,0]
[null,72,632047,2016,"ACADIA",19352,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,73,632048,2011,"TERRAIN",124023,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE))","v":""},"",40.57,1,2762,12.5,12.5,396.83,3.3,1354,26,85.8,98.3,0]
[null,74,632049,2015,"YUKON",46046,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE))","v":""},"",24.57,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,75,632052,2015,"SIERRA",96614,112,1.4,1404,28,39.199999999999996,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N80,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N80,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S80,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S80,TechNumber,2,FALSE))","v":""},"",39.199999999999996,0]
[null,76,632053,2015,"SIERRA",39783,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,77,632054,2013,"TOWN&COUNTRY",34188,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2860,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S82,TechNumber,2,FALSE))","v":""},"",5,1]
[null,78,632056,2011,"REGAL",94093,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I83,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N83,TechNumber,2,FALSE))","v":""}," ",118,1,224,30,30,30,1]
[null,79,632057,2016,"EQUINOX",25334,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,80,632059,2008,"TRAILBLAZER",83900,35,0.5,2816,20,10,13.36,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE))","v":""},"",15,0]
[null,81,632061,2014,"CRUZE",71437,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2762,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE))","v":""},"",5,0]
[null,82,632063,2014,"ENCORE",34532,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE))","v":""},"",29.02,0.8,2768,12.5,10,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE))","v":""},"",10,0]
[null,83,632065,2011,"SIERRA",123962,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2801,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,84,632080,2017,"TERRAIN",7048,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I89,TechNumber,2,FALSE))","v":""},"",20,0.4,2762,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE))","v":""},"",5,0]
[null,85,632083,2014,"EQUINOX",19572,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2801,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE))","v":""},"",5,1]
[null,86,632085,2015,"YUKON",48065,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2860,12.5,8.75,177,1.5,1354,26,39,47.75,0]
[null,87,632088,2015,"TERRAIN",50363,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE))","v":""},"",16.57,0.4,1404,24,9.6000000000000014,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE))","v":""},"",9.6000000000000014,1]
[null,88,632092,2011,"TERRAIN",74584,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2768,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE))","v":""},"",5,1]
[null,89,632094,2015,"ACADIA",33374,92,1,131,92,92,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N94,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S94,TechNumber,2,FALSE))","v":""},"",92,0]
[null,90,633002,2017,"ENCLAVE",8488,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE))","v":""},"",12,0.3,2087,12.5,3.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE))","v":""},"",3.75,1]
[null,91,633004,2009,"VUE",110386,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE))","v":""},"",13.36,0.4,2087,13.5,5.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE))","v":""},"",5.4,0]
[null,92,633005,2009,"VIBE",85066,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE))","v":""},"",58.31,1.2,2781,12.5,15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE))","v":""},"",15,0]
[null,93,633006,2008,"ENVOY",135506,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE))","v":""},"",23.31,0.7,2087,13.5,9.4499999999999993,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE))","v":""},"",9.4499999999999993,0]
[null,94,633019,2015,"ENCLAVE",39354,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE))","v":""},"",16.57,0.4,2781,12.5,5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE))","v":""},"",5,1]
[null,95,633021,2017,"TAHOE",7329,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2762,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,96,633022,2016,"ENCORE",16176,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2678,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,97,633024,2013,"LACROSSE",80933,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE))","v":""},"",46.52,1,2762,12.5,12.5,1852.6,15.7,61,34,533.79999999999995,546.29999999999995,0]
[null,98,633028,2016,"SIERRA",20646,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE))","v":""},"",26.52,0.7,2768,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,99,633029,2017,"YUKON",13642,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE))","v":""},"",24.57,0.7,2781,12.5,8.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S104,TechNumber,2,FALSE))","v":""},"",8.75,0]
[null,100,633035,2004,"IMPALA",27046,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I105,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I105,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H105*J105),\"\",H105*J105)","v":""},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N105,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N105,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(M105*O105),\" \",M105*O105)","v":" "},236,2,2331,19,{"$f":"IF(ISERROR(R105*T105),\"\",R105*T105)","v":38},38,1]
[null,null,null,null,"Totals","Totals",{"$f":"SUM(G6:G105)","v":2729.64},{"$f":"SUM(H6:H105)","v":30.199999999999996},null,null,{"$f":"SUM(K6:K105)","v":747.5},{"$f":"SUM(L6:L105)","v":2368.099999999999},{"$f":"SUM(M6:M105)","v":53.300000000000004},null,null,{"$f":"SUM(P6:P105)","v":694.46},8078.0600000000013,67.7,null,null,1873.6999999999998,3315.66,{"$f":"COUNTIF(W5:W105,1)","v":33}]
[null,null,null,null,"Number of RO's in Sample",100,"Competative Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
[null,null,null,null,null,null,"Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technican Number","Pay Per FRH","Labor Cost "]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"RO Report 1-50","index":3,"n_rows":65,"n_cols":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,19,4,19],[3,11,4,11],[3,18,4,18],[3,16,4,16],[3,17,4,17],[56,20,58,20],[57,4,58,4],[57,5,58,5],[57,6,58,6],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,11],[57,12,58,12],[56,19,58,19],[57,13,58,13],[57,14,58,14],[57,15,58,15],[57,16,58,16],[57,17,58,17],[57,18,58,18],[56,4,56,8],[56,9,56,13],[56,14,56,18],[3,12,4,12],[3,13,4,13],[3,14,4,14],[1,0,1,3],[0,0,0,20],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,0,4,0],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,15,4,15],[2,20,4,20],[2,0,2,3],[1,4,2,8],[1,9,2,13],[1,14,2,18]]}
["Repair Order Analysis"]
[null,null,null,null,"Competitive Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor"]
["Dealership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["RO Number",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[null,"Year","Model ","Mileage"]
[{"$f":"'Input Sheet'!C6","v":630003},{"$f":"'Input Sheet'!D6","v":2013},{"$f":"'Input Sheet'!E6","v":"SUBURBAN"},{"$f":"'Input Sheet'!F6","v":66161},{"$f":"'Input Sheet'!G6","v":0},{"$f":"'Input Sheet'!H6","v":0},{"$f":"'Input Sheet'!I6","v":0},{"$f":"'Input Sheet'!J6","v":0},{"$f":"F6*H6","v":0},{"$f":"'Input Sheet'!L6","v":90.52},{"$f":"'Input Sheet'!M6","v":1.5},{"$f":"'Input Sheet'!I6","v":0},{"$f":"'Input Sheet'!J6","v":0},{"$f":"K6*M6","v":0},{"$f":"'Input Sheet'!Q6","v":0},{"$f":"'Input Sheet'!R6","v":0},{"$f":"'Input Sheet'!S6","v":0},{"$f":"'Input Sheet'!T6","v":""},{"$f":"P6*R6","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V6","v":18.75},{"$f":"'Input Sheet'!W6","v":0}]
[{"$f":"'Input Sheet'!C7","v":630006},{"$f":"'Input Sheet'!D7","v":2015},{"$f":"'Input Sheet'!E7","v":"SIERRA"},{"$f":"'Input Sheet'!F7","v":32182},{"$f":"'Input Sheet'!G7","v":" "},{"$f":"'Input Sheet'!H7","v":0},{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":""},{"$f":"F7*H7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L7","v":36.520000000000003},{"$f":"'Input Sheet'!M7","v":0.9},{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":""},{"$f":"K7*M7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!Q7","v":" "},{"$f":"'Input Sheet'!R7","v":" "},{"$f":"'Input Sheet'!S7","v":" "},{"$f":"'Input Sheet'!T7","v":" "},{"$f":"P7*R7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V7","v":11.25},{"$f":"'Input Sheet'!W7","v":0}]
[{"$f":"'Input Sheet'!C8","v":630009},{"$f":"'Input Sheet'!D8","v":2010},{"$f":"'Input Sheet'!E8","v":"WRANGLER"},{"$f":"'Input Sheet'!F8","v":147618},{"$f":"'Input Sheet'!G8","v":0},{"$f":"'Input Sheet'!H8","v":0},{"$f":"'Input Sheet'!I8","v":0},{"$f":"'Input Sheet'!J8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L8","v":66.47},{"$f":"'Input Sheet'!M8","v":1.2},{"$f":"'Input Sheet'!I8","v":0},{"$f":"'Input Sheet'!J8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q8","v":0},{"$f":"'Input Sheet'!R8","v":0},{"$f":"'Input Sheet'!S8","v":0},{"$f":"'Input Sheet'!T8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V8","v":15},{"$f":"'Input Sheet'!W8","v":0}]
[{"$f":"'Input Sheet'!C9","v":630010},{"$f":"'Input Sheet'!D9","v":2016},{"$f":"'Input Sheet'!E9","v":"TERRAIN"},{"$f":"'Input Sheet'!F9","v":26550},{"$f":"'Input Sheet'!G9","v":0},{"$f":"'Input Sheet'!H9","v":0},{"$f":"'Input Sheet'!I9","v":0},{"$f":"'Input Sheet'!J9","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L9","v":26.52},{"$f":"'Input Sheet'!M9","v":0.7},{"$f":"'Input Sheet'!I9","v":0},{"$f":"'Input Sheet'!J9","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q9","v":0},{"$f":"'Input Sheet'!R9","v":0},{"$f":"'Input Sheet'!S9","v":0},{"$f":"'Input Sheet'!T9","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V9","v":8.75},{"$f":"'Input Sheet'!W9","v":0}]
[{"$f":"'Input Sheet'!C10","v":630013},{"$f":"'Input Sheet'!D10","v":2012},{"$f":"'Input Sheet'!E10","v":"SIENNA"},{"$f":"'Input Sheet'!F10","v":52281},{"$f":"'Input Sheet'!G10","v":0},{"$f":"'Input Sheet'!H10","v":0},{"$f":"'Input Sheet'!I10","v":0},{"$f":"'Input Sheet'!J10","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L10","v":24.95},{"$f":"'Input Sheet'!M10","v":0.7},{"$f":"'Input Sheet'!I10","v":0},{"$f":"'Input Sheet'!J10","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q10","v":0},{"$f":"'Input Sheet'!R10","v":0},{"$f":"'Input Sheet'!S10","v":0},{"$f":"'Input Sheet'!T10","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V10","v":9.4499999999999993},{"$f":"'Input Sheet'!W10","v":0}]
[{"$f":"'Input Sheet'!C11","v":630016},{"$f":"'Input Sheet'!D11","v":2013},{"$f":"'Input Sheet'!E11","v":"YUKON"},{"$f":"'Input Sheet'!F11","v":92099},{"$f":"'Input Sheet'!G11","v":1078},{"$f":"'Input Sheet'!H11","v":9.6},{"$f":"'Input Sheet'!I11","v":2331},{"$f":"'Input Sheet'!J11","v":19},182.4,{"$f":"'Input Sheet'!L11","v":0},{"$f":"'Input Sheet'!M11","v":0},{"$f":"'Input Sheet'!I11","v":2331},{"$f":"'Input Sheet'!J11","v":19},0,{"$f":"'Input Sheet'!Q11","v":183.2},{"$f":"'Input Sheet'!R11","v":1.5},{"$f":"'Input Sheet'!S11","v":1354},{"$f":"'Input Sheet'!T11","v":26},39,{"$f":"'Input Sheet'!V11","v":221.4},{"$f":"'Input Sheet'!W11","v":0}]
[{"$f":"'Input Sheet'!C12","v":630018},{"$f":"'Input Sheet'!D12","v":2016},{"$f":"'Input Sheet'!E12","v":"TERRAIN"},{"$f":"'Input Sheet'!F12","v":19222},{"$f":"'Input Sheet'!G12","v":0},{"$f":"'Input Sheet'!H12","v":0},{"$f":"'Input Sheet'!I12","v":0},{"$f":"'Input Sheet'!J12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L12","v":26.52},{"$f":"'Input Sheet'!M12","v":0.7},{"$f":"'Input Sheet'!I12","v":0},{"$f":"'Input Sheet'!J12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q12","v":0},{"$f":"'Input Sheet'!R12","v":0},{"$f":"'Input Sheet'!S12","v":0},{"$f":"'Input Sheet'!T12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V12","v":8.75},{"$f":"'Input Sheet'!W12","v":0}]
[{"$f":"'Input Sheet'!C13","v":630024},{"$f":"'Input Sheet'!D13","v":2017},{"$f":"'Input Sheet'!E13","v":"ENCLAVE"},{"$f":"'Input Sheet'!F13","v":7620},{"$f":"'Input Sheet'!G13","v":0},{"$f":"'Input Sheet'!H13","v":0},{"$f":"'Input Sheet'!I13","v":0},{"$f":"'Input Sheet'!J13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L13","v":16.57},{"$f":"'Input Sheet'!M13","v":0.4},{"$f":"'Input Sheet'!I13","v":0},{"$f":"'Input Sheet'!J13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q13","v":0},{"$f":"'Input Sheet'!R13","v":0},{"$f":"'Input Sheet'!S13","v":0},{"$f":"'Input Sheet'!T13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V13","v":5},{"$f":"'Input Sheet'!W13","v":1}]
[{"$f":"'Input Sheet'!C14","v":630025},{"$f":"'Input Sheet'!D14","v":2013},{"$f":"'Input Sheet'!E14","v":"MALIBU"},{"$f":"'Input Sheet'!F14","v":81249},{"$f":"'Input Sheet'!G14","v":125},{"$f":"'Input Sheet'!H14","v":1.5},{"$f":"'Input Sheet'!I14","v":2830},{"$f":"'Input Sheet'!J14","v":24},36,{"$f":"'Input Sheet'!L14","v":0},{"$f":"'Input Sheet'!M14","v":0},{"$f":"'Input Sheet'!I14","v":2830},{"$f":"'Input Sheet'!J14","v":24},0,{"$f":"'Input Sheet'!Q14","v":0},{"$f":"'Input Sheet'!R14","v":0},{"$f":"'Input Sheet'!S14","v":0},{"$f":"'Input Sheet'!T14","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V14","v":36},{"$f":"'Input Sheet'!W14","v":0}]
[{"$f":"'Input Sheet'!C15","v":630026},{"$f":"'Input Sheet'!D15","v":2008},{"$f":"'Input Sheet'!E15","v":"YUKON"},{"$f":"'Input Sheet'!F15","v":215634},{"$f":"'Input Sheet'!G15","v":0},{"$f":"'Input Sheet'!H15","v":0},{"$f":"'Input Sheet'!I15","v":0},{"$f":"'Input Sheet'!J15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L15","v":56.52},{"$f":"'Input Sheet'!M15","v":1.2},{"$f":"'Input Sheet'!I15","v":0},{"$f":"'Input Sheet'!J15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q15","v":0},{"$f":"'Input Sheet'!R15","v":0},{"$f":"'Input Sheet'!S15","v":0},{"$f":"'Input Sheet'!T15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V15","v":15},{"$f":"'Input Sheet'!W15","v":0}]
[{"$f":"'Input Sheet'!C16","v":630029},{"$f":"'Input Sheet'!D16","v":2006},{"$f":"'Input Sheet'!E16","v":"GTO"},{"$f":"'Input Sheet'!F16","v":102288},{"$f":"'Input Sheet'!G16","v":0},{"$f":"'Input Sheet'!H16","v":0},{"$f":"'Input Sheet'!I16","v":0},{"$f":"'Input Sheet'!J16","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L16","v":16.57},{"$f":"'Input Sheet'!M16","v":0.4},{"$f":"'Input Sheet'!I16","v":0},{"$f":"'Input Sheet'!J16","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q16","v":0},{"$f":"'Input Sheet'!R16","v":0},{"$f":"'Input Sheet'!S16","v":0},{"$f":"'Input Sheet'!T16","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V16","v":5},{"$f":"'Input Sheet'!W16","v":1}]
[{"$f":"'Input Sheet'!C17","v":630036},{"$f":"'Input Sheet'!D17","v":2015},{"$f":"'Input Sheet'!E17","v":"SIERRA"},{"$f":"'Input Sheet'!F17","v":48110},{"$f":"'Input Sheet'!G17","v":0},{"$f":"'Input Sheet'!H17","v":0},{"$f":"'Input Sheet'!I17","v":0},{"$f":"'Input Sheet'!J17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L17","v":0},{"$f":"'Input Sheet'!M17","v":0},{"$f":"'Input Sheet'!I17","v":0},{"$f":"'Input Sheet'!J17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q17","v":236},{"$f":"'Input Sheet'!R17","v":2},{"$f":"'Input Sheet'!S17","v":131},{"$f":"'Input Sheet'!T17","v":22},44,{"$f":"'Input Sheet'!V17","v":44},{"$f":"'Input Sheet'!W17","v":0}]
[{"$f":"'Input Sheet'!C18","v":630037},{"$f":"'Input Sheet'!D18","v":2016},{"$f":"'Input Sheet'!E18","v":"REGAL"},{"$f":"'Input Sheet'!F18","v":23894},{"$f":"'Input Sheet'!G18","v":0},{"$f":"'Input Sheet'!H18","v":0},{"$f":"'Input Sheet'!I18","v":0},{"$f":"'Input Sheet'!J18","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L18","v":30},{"$f":"'Input Sheet'!M18","v":0.6},{"$f":"'Input Sheet'!I18","v":0},{"$f":"'Input Sheet'!J18","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q18","v":0},{"$f":"'Input Sheet'!R18","v":0},{"$f":"'Input Sheet'!S18","v":0},{"$f":"'Input Sheet'!T18","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V18","v":7.5},{"$f":"'Input Sheet'!W18","v":1}]
[{"$f":"'Input Sheet'!C19","v":630039},{"$f":"'Input Sheet'!D19","v":2016},{"$f":"'Input Sheet'!E19","v":"SIERRA"},{"$f":"'Input Sheet'!F19","v":30149},{"$f":"'Input Sheet'!G19","v":0},{"$f":"'Input Sheet'!H19","v":0},{"$f":"'Input Sheet'!I19","v":0},{"$f":"'Input Sheet'!J19","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L19","v":200},{"$f":"'Input Sheet'!M19","v":0.7},{"$f":"'Input Sheet'!I19","v":0},{"$f":"'Input Sheet'!J19","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q19","v":0},{"$f":"'Input Sheet'!R19","v":0},{"$f":"'Input Sheet'!S19","v":0},{"$f":"'Input Sheet'!T19","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V19","v":8.75},{"$f":"'Input Sheet'!W19","v":0}]
[{"$f":"'Input Sheet'!C20","v":630040},{"$f":"'Input Sheet'!D20","v":2016},{"$f":"'Input Sheet'!E20","v":"TERRAIN"},{"$f":"'Input Sheet'!F20","v":27399},{"$f":"'Input Sheet'!G20","v":0},{"$f":"'Input Sheet'!H20","v":0},{"$f":"'Input Sheet'!I20","v":0},{"$f":"'Input Sheet'!J20","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L20","v":16.57},{"$f":"'Input Sheet'!M20","v":0.4},{"$f":"'Input Sheet'!I20","v":0},{"$f":"'Input Sheet'!J20","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q20","v":0},{"$f":"'Input Sheet'!R20","v":0},{"$f":"'Input Sheet'!S20","v":0},{"$f":"'Input Sheet'!T20","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V20","v":5.4},{"$f":"'Input Sheet'!W20","v":1}]
[{"$f":"'Input Sheet'!C21","v":630043},{"$f":"'Input Sheet'!D21","v":2011},{"$f":"'Input Sheet'!E21","v":"SIERRA"},{"$f":"'Input Sheet'!F21","v":168435},{"$f":"'Input Sheet'!G21","v":0},{"$f":"'Input Sheet'!H21","v":0},{"$f":"'Input Sheet'!I21","v":0},{"$f":"'Input Sheet'!J21","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L21","v":26.52},{"$f":"'Input Sheet'!M21","v":0.7},{"$f":"'Input Sheet'!I21","v":0},{"$f":"'Input Sheet'!J21","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q21","v":0},{"$f":"'Input Sheet'!R21","v":0},{"$f":"'Input Sheet'!S21","v":0},{"$f":"'Input Sheet'!T21","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V21","v":8.75},{"$f":"'Input Sheet'!W21","v":0}]
[{"$f":"'Input Sheet'!C22","v":630045},{"$f":"'Input Sheet'!D22","v":2006},{"$f":"'Input Sheet'!E22","v":"CORVETTE"},{"$f":"'Input Sheet'!F22","v":42596},{"$f":"'Input Sheet'!G22","v":0},{"$f":"'Input Sheet'!H22","v":0},{"$f":"'Input Sheet'!I22","v":0},{"$f":"'Input Sheet'!J22","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L22","v":0},{"$f":"'Input Sheet'!M22","v":0},{"$f":"'Input Sheet'!I22","v":0},{"$f":"'Input Sheet'!J22","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q22","v":590},{"$f":"'Input Sheet'!R22","v":5},{"$f":"'Input Sheet'!S22","v":131},{"$f":"'Input Sheet'!T22","v":22},110,{"$f":"'Input Sheet'!V22","v":110},{"$f":"'Input Sheet'!W22","v":0}]
[{"$f":"'Input Sheet'!C23","v":630048},{"$f":"'Input Sheet'!D23","v":2015},{"$f":"'Input Sheet'!E23","v":"SILVERADO"},{"$f":"'Input Sheet'!F23","v":49027},{"$f":"'Input Sheet'!G23","v":0},{"$f":"'Input Sheet'!H23","v":0},{"$f":"'Input Sheet'!I23","v":0},{"$f":"'Input Sheet'!J23","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L23","v":16.57},{"$f":"'Input Sheet'!M23","v":0.4},{"$f":"'Input Sheet'!I23","v":0},{"$f":"'Input Sheet'!J23","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q23","v":0},{"$f":"'Input Sheet'!R23","v":0},{"$f":"'Input Sheet'!S23","v":0},{"$f":"'Input Sheet'!T23","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V23","v":5},{"$f":"'Input Sheet'!W23","v":1}]
[{"$f":"'Input Sheet'!C24","v":630049},{"$f":"'Input Sheet'!D24","v":2016},{"$f":"'Input Sheet'!E24","v":"TERRAIN"},{"$f":"'Input Sheet'!F24","v":17267},{"$f":"'Input Sheet'!G24","v":0},{"$f":"'Input Sheet'!H24","v":0},{"$f":"'Input Sheet'!I24","v":0},{"$f":"'Input Sheet'!J24","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L24","v":26.52},{"$f":"'Input Sheet'!M24","v":0.7},{"$f":"'Input Sheet'!I24","v":0},{"$f":"'Input Sheet'!J24","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q24","v":0},{"$f":"'Input Sheet'!R24","v":0},{"$f":"'Input Sheet'!S24","v":0},{"$f":"'Input Sheet'!T24","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V24","v":8.75},{"$f":"'Input Sheet'!W24","v":0}]
[{"$f":"'Input Sheet'!C25","v":630050},{"$f":"'Input Sheet'!D25","v":2015},{"$f":"'Input Sheet'!E25","v":"SIERRA"},{"$f":"'Input Sheet'!F25","v":27094},{"$f":"'Input Sheet'!G25","v":0},{"$f":"'Input Sheet'!H25","v":0},{"$f":"'Input Sheet'!I25","v":0},{"$f":"'Input Sheet'!J25","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L25","v":14.62},{"$f":"'Input Sheet'!M25","v":0.4},{"$f":"'Input Sheet'!I25","v":0},{"$f":"'Input Sheet'!J25","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q25","v":0},{"$f":"'Input Sheet'!R25","v":0},{"$f":"'Input Sheet'!S25","v":0},{"$f":"'Input Sheet'!T25","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V25","v":5},{"$f":"'Input Sheet'!W25","v":1}]
[{"$f":"'Input Sheet'!C26","v":630051},{"$f":"'Input Sheet'!D26","v":2016},{"$f":"'Input Sheet'!E26","v":"TERRAIN"},{"$f":"'Input Sheet'!F26","v":20260},{"$f":"'Input Sheet'!G26","v":0},{"$f":"'Input Sheet'!H26","v":0},{"$f":"'Input Sheet'!I26","v":0},{"$f":"'Input Sheet'!J26","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L26","v":53.52},{"$f":"'Input Sheet'!M26","v":1.2},{"$f":"'Input Sheet'!I26","v":0},{"$f":"'Input Sheet'!J26","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q26","v":0},{"$f":"'Input Sheet'!R26","v":0},{"$f":"'Input Sheet'!S26","v":0},{"$f":"'Input Sheet'!T26","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V26","v":15.36},{"$f":"'Input Sheet'!W26","v":0}]
[{"$f":"'Input Sheet'!C27","v":630052},{"$f":"'Input Sheet'!D27","v":2015},{"$f":"'Input Sheet'!E27","v":"TERRAIN"},{"$f":"'Input Sheet'!F27","v":16712},{"$f":"'Input Sheet'!G27","v":0},{"$f":"'Input Sheet'!H27","v":0},{"$f":"'Input Sheet'!I27","v":0},{"$f":"'Input Sheet'!J27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L27","v":26.52},{"$f":"'Input Sheet'!M27","v":0.7},{"$f":"'Input Sheet'!I27","v":0},{"$f":"'Input Sheet'!J27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q27","v":0},{"$f":"'Input Sheet'!R27","v":0},{"$f":"'Input Sheet'!S27","v":0},{"$f":"'Input Sheet'!T27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V27","v":8.75},{"$f":"'Input Sheet'!W27","v":0}]
[{"$f":"'Input Sheet'!C28","v":630056},{"$f":"'Input Sheet'!D28","v":2015},{"$f":"'Input Sheet'!E28","v":"YUKON"},{"$f":"'Input Sheet'!F28","v":29079},{"$f":"'Input Sheet'!G28","v":80},{"$f":"'Input Sheet'!H28","v":1},{"$f":"'Input Sheet'!I28","v":131},{"$f":"'Input Sheet'!J28","v":22},22,{"$f":"'Input Sheet'!L28","v":0},{"$f":"'Input Sheet'!M28","v":0},{"$f":"'Input Sheet'!I28","v":131},{"$f":"'Input Sheet'!J28","v":22},0,{"$f":"'Input Sheet'!Q28","v":0},{"$f":"'Input Sheet'!R28","v":0},{"$f":"'Input Sheet'!S28","v":0},{"$f":"'Input Sheet'!T28","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V28","v":22},{"$f":"'Input Sheet'!W28","v":0}]
[{"$f":"'Input Sheet'!C29","v":630059},{"$f":"'Input Sheet'!D29","v":2012},{"$f":"'Input Sheet'!E29","v":"TERRAIN"},{"$f":"'Input Sheet'!F29","v":76069},{"$f":"'Input Sheet'!G29","v":0},{"$f":"'Input Sheet'!H29","v":0},{"$f":"'Input Sheet'!I29","v":0},{"$f":"'Input Sheet'!J29","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L29","v":16.57},{"$f":"'Input Sheet'!M29","v":0.4},{"$f":"'Input Sheet'!I29","v":0},{"$f":"'Input Sheet'!J29","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q29","v":0},{"$f":"'Input Sheet'!R29","v":0},{"$f":"'Input Sheet'!S29","v":0},{"$f":"'Input Sheet'!T29","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V29","v":5},{"$f":"'Input Sheet'!W29","v":1}]
[{"$f":"'Input Sheet'!C30","v":630064},{"$f":"'Input Sheet'!D30","v":2016},{"$f":"'Input Sheet'!E30","v":"SIERRA"},{"$f":"'Input Sheet'!F30","v":20925},{"$f":"'Input Sheet'!G30","v":0},{"$f":"'Input Sheet'!H30","v":0},{"$f":"'Input Sheet'!I30","v":0},{"$f":"'Input Sheet'!J30","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L30","v":27},{"$f":"'Input Sheet'!M30","v":0.3},{"$f":"'Input Sheet'!I30","v":0},{"$f":"'Input Sheet'!J30","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q30","v":0},{"$f":"'Input Sheet'!R30","v":0},{"$f":"'Input Sheet'!S30","v":0},{"$f":"'Input Sheet'!T30","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V30","v":3.75},{"$f":"'Input Sheet'!W30","v":1}]
[{"$f":"'Input Sheet'!C31","v":630067},{"$f":"'Input Sheet'!D31","v":2008},{"$f":"'Input Sheet'!E31","v":"AURA"},{"$f":"'Input Sheet'!F31","v":103932},{"$f":"'Input Sheet'!G31","v":0},{"$f":"'Input Sheet'!H31","v":0},{"$f":"'Input Sheet'!I31","v":0},{"$f":"'Input Sheet'!J31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L31","v":13.36},{"$f":"'Input Sheet'!M31","v":0.4},{"$f":"'Input Sheet'!I31","v":0},{"$f":"'Input Sheet'!J31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q31","v":0},{"$f":"'Input Sheet'!R31","v":0},{"$f":"'Input Sheet'!S31","v":0},{"$f":"'Input Sheet'!T31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V31","v":5},{"$f":"'Input Sheet'!W31","v":0}]
[{"$f":"'Input Sheet'!C32","v":630069},{"$f":"'Input Sheet'!D32","v":2015},{"$f":"'Input Sheet'!E32","v":"TERRAIN"},{"$f":"'Input Sheet'!F32","v":87540},{"$f":"'Input Sheet'!G32","v":0},{"$f":"'Input Sheet'!H32","v":0},{"$f":"'Input Sheet'!I32","v":0},{"$f":"'Input Sheet'!J32","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L32","v":26.52},{"$f":"'Input Sheet'!M32","v":0.7},{"$f":"'Input Sheet'!I32","v":0},{"$f":"'Input Sheet'!J32","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q32","v":0},{"$f":"'Input Sheet'!R32","v":0},{"$f":"'Input Sheet'!S32","v":0},{"$f":"'Input Sheet'!T32","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V32","v":8.75},{"$f":"'Input Sheet'!W32","v":0}]
[{"$f":"'Input Sheet'!C33","v":630071},{"$f":"'Input Sheet'!D33","v":2012},{"$f":"'Input Sheet'!E33","v":"ACADIA"},{"$f":"'Input Sheet'!F33","v":104376},{"$f":"'Input Sheet'!G33","v":129.94999999999999},{"$f":"'Input Sheet'!H33","v":1.5},{"$f":"'Input Sheet'!I33","v":61},{"$f":"'Input Sheet'!J33","v":34},51,{"$f":"'Input Sheet'!L33","v":48},{"$f":"'Input Sheet'!M33","v":1.2},{"$f":"'Input Sheet'!I33","v":61},{"$f":"'Input Sheet'!J33","v":34},40.799999999999997,{"$f":"'Input Sheet'!Q33","v":0},{"$f":"'Input Sheet'!R33","v":0},{"$f":"'Input Sheet'!S33","v":0},{"$f":"'Input Sheet'!T33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V33","v":66},{"$f":"'Input Sheet'!W33","v":0}]
[{"$f":"'Input Sheet'!C34","v":630073},{"$f":"'Input Sheet'!D34","v":2013},{"$f":"'Input Sheet'!E34","v":"TERRAIN"},{"$f":"'Input Sheet'!F34","v":46165},{"$f":"'Input Sheet'!G34","v":0},{"$f":"'Input Sheet'!H34","v":0},{"$f":"'Input Sheet'!I34","v":0},{"$f":"'Input Sheet'!J34","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L34","v":12},{"$f":"'Input Sheet'!M34","v":0.3},{"$f":"'Input Sheet'!I34","v":0},{"$f":"'Input Sheet'!J34","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q34","v":0},{"$f":"'Input Sheet'!R34","v":0},{"$f":"'Input Sheet'!S34","v":0},{"$f":"'Input Sheet'!T34","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V34","v":3.75},{"$f":"'Input Sheet'!W34","v":1}]
[{"$f":"'Input Sheet'!C35","v":630075},{"$f":"'Input Sheet'!D35","v":2015},{"$f":"'Input Sheet'!E35","v":"SIERRA"},{"$f":"'Input Sheet'!F35","v":46084},{"$f":"'Input Sheet'!G35","v":0},{"$f":"'Input Sheet'!H35","v":0},{"$f":"'Input Sheet'!I35","v":0},{"$f":"'Input Sheet'!J35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L35","v":24.57},{"$f":"'Input Sheet'!M35","v":0.7},{"$f":"'Input Sheet'!I35","v":0},{"$f":"'Input Sheet'!J35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q35","v":0},{"$f":"'Input Sheet'!R35","v":0},{"$f":"'Input Sheet'!S35","v":0},{"$f":"'Input Sheet'!T35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V35","v":8.75},{"$f":"'Input Sheet'!W35","v":0}]
[{"$f":"'Input Sheet'!C36","v":630081},{"$f":"'Input Sheet'!D36","v":2014},{"$f":"'Input Sheet'!E36","v":"CAMARO"},{"$f":"'Input Sheet'!F36","v":71002},{"$f":"'Input Sheet'!G36","v":0},{"$f":"'Input Sheet'!H36","v":0},{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L36","v":16.57},{"$f":"'Input Sheet'!M36","v":0.4},{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q36","v":0},{"$f":"'Input Sheet'!R36","v":0},{"$f":"'Input Sheet'!S36","v":0},{"$f":"'Input Sheet'!T36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V36","v":5},{"$f":"'Input Sheet'!W36","v":1}]
[{"$f":"'Input Sheet'!C37","v":630090},{"$f":"'Input Sheet'!D37","v":2012},{"$f":"'Input Sheet'!E37","v":"SIERRA"},{"$f":"'Input Sheet'!F37","v":49898},{"$f":"'Input Sheet'!G37","v":0},{"$f":"'Input Sheet'!H37","v":0},{"$f":"'Input Sheet'!I37","v":0},{"$f":"'Input Sheet'!J37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L37","v":26.52},{"$f":"'Input Sheet'!M37","v":0.7},{"$f":"'Input Sheet'!I37","v":0},{"$f":"'Input Sheet'!J37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q37","v":0},{"$f":"'Input Sheet'!R37","v":0},{"$f":"'Input Sheet'!S37","v":0},{"$f":"'Input Sheet'!T37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V37","v":8.75},{"$f":"'Input Sheet'!W37","v":0}]
[{"$f":"'Input Sheet'!C38","v":630091},{"$f":"'Input Sheet'!D38","v":2011},{"$f":"'Input Sheet'!E38","v":"F-150"},{"$f":"'Input Sheet'!F38","v":133571},{"$f":"'Input Sheet'!G38","v":0},{"$f":"'Input Sheet'!H38","v":0},{"$f":"'Input Sheet'!I38","v":0},{"$f":"'Input Sheet'!J38","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L38","v":24.95},{"$f":"'Input Sheet'!M38","v":0.7},{"$f":"'Input Sheet'!I38","v":0},{"$f":"'Input Sheet'!J38","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q38","v":0},{"$f":"'Input Sheet'!R38","v":0},{"$f":"'Input Sheet'!S38","v":0},{"$f":"'Input Sheet'!T38","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V38","v":8.75},{"$f":"'Input Sheet'!W38","v":0}]
[{"$f":"'Input Sheet'!C39","v":630092},{"$f":"'Input Sheet'!D39","v":2009},{"$f":"'Input Sheet'!E39","v":"SILVERADO"},{"$f":"'Input Sheet'!F39","v":56244},{"$f":"'Input Sheet'!G39","v":50},{"$f":"'Input Sheet'!H39","v":0.5},{"$f":"'Input Sheet'!I39","v":1354},{"$f":"'Input Sheet'!J39","v":26},13,{"$f":"'Input Sheet'!L39","v":0},{"$f":"'Input Sheet'!M39","v":0},{"$f":"'Input Sheet'!I39","v":1354},{"$f":"'Input Sheet'!J39","v":26},0,{"$f":"'Input Sheet'!Q39","v":244.26},{"$f":"'Input Sheet'!R39","v":2},{"$f":"'Input Sheet'!S39","v":1354},{"$f":"'Input Sheet'!T39","v":26},52,{"$f":"'Input Sheet'!V39","v":65},{"$f":"'Input Sheet'!W39","v":0}]
[{"$f":"'Input Sheet'!C40","v":630096},{"$f":"'Input Sheet'!D40","v":2015},{"$f":"'Input Sheet'!E40","v":"YUKON"},{"$f":"'Input Sheet'!F40","v":44801},{"$f":"'Input Sheet'!G40","v":0},{"$f":"'Input Sheet'!H40","v":0},{"$f":"'Input Sheet'!I40","v":0},{"$f":"'Input Sheet'!J40","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L40","v":0},{"$f":"'Input Sheet'!M40","v":0},{"$f":"'Input Sheet'!I40","v":0},{"$f":"'Input Sheet'!J40","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q40","v":641.22},{"$f":"'Input Sheet'!R40","v":5.5},{"$f":"'Input Sheet'!S40","v":"2830/2529"},{"$f":"'Input Sheet'!T40","v":28},154,{"$f":"'Input Sheet'!V40","v":154},{"$f":"'Input Sheet'!W40","v":0}]
[{"$f":"'Input Sheet'!C41","v":630099},{"$f":"'Input Sheet'!D41","v":2011},{"$f":"'Input Sheet'!E41","v":"SIERRA"},{"$f":"'Input Sheet'!F41","v":38406},{"$f":"'Input Sheet'!G41","v":439.69},{"$f":"'Input Sheet'!H41","v":5.3},{"$f":"'Input Sheet'!I41","v":"2623/1354/2830"},{"$f":"'Input Sheet'!J41","v":25},132.5,{"$f":"'Input Sheet'!L41","v":74.52},{"$f":"'Input Sheet'!M41","v":1.9},{"$f":"'Input Sheet'!I41","v":"2623/1354/2830"},{"$f":"'Input Sheet'!J41","v":25},47.5,{"$f":"'Input Sheet'!Q41","v":295},{"$f":"'Input Sheet'!R41","v":2.5},{"$f":"'Input Sheet'!S41","v":2830},{"$f":"'Input Sheet'!T41","v":24},60,{"$f":"'Input Sheet'!V41","v":230.5},{"$f":"'Input Sheet'!W41","v":0}]
[{"$f":"'Input Sheet'!C42","v":631001},{"$f":"'Input Sheet'!D42","v":2008},{"$f":"'Input Sheet'!E42","v":"LACROSSE"},{"$f":"'Input Sheet'!F42","v":152107},{"$f":"'Input Sheet'!G42","v":0},{"$f":"'Input Sheet'!H42","v":0},{"$f":"'Input Sheet'!I42","v":0},{"$f":"'Input Sheet'!J42","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L42","v":18.36},{"$f":"'Input Sheet'!M42","v":0.4},{"$f":"'Input Sheet'!I42","v":0},{"$f":"'Input Sheet'!J42","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q42","v":0},{"$f":"'Input Sheet'!R42","v":0},{"$f":"'Input Sheet'!S42","v":0},{"$f":"'Input Sheet'!T42","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V42","v":5},{"$f":"'Input Sheet'!W42","v":0}]
[{"$f":"'Input Sheet'!C43","v":631003},{"$f":"'Input Sheet'!D43","v":2014},{"$f":"'Input Sheet'!E43","v":"ENCORE"},{"$f":"'Input Sheet'!F43","v":54260},{"$f":"'Input Sheet'!G43","v":0},{"$f":"'Input Sheet'!H43","v":0},{"$f":"'Input Sheet'!I43","v":0},{"$f":"'Input Sheet'!J43","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L43","v":21.57},{"$f":"'Input Sheet'!M43","v":0.4},{"$f":"'Input Sheet'!I43","v":0},{"$f":"'Input Sheet'!J43","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q43","v":0},{"$f":"'Input Sheet'!R43","v":0},{"$f":"'Input Sheet'!S43","v":0},{"$f":"'Input Sheet'!T43","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V43","v":5},{"$f":"'Input Sheet'!W43","v":0}]
[{"$f":"'Input Sheet'!C44","v":631005},{"$f":"'Input Sheet'!D44","v":2016},{"$f":"'Input Sheet'!E44","v":"ACADIA"},{"$f":"'Input Sheet'!F44","v":26420},{"$f":"'Input Sheet'!G44","v":0},{"$f":"'Input Sheet'!H44","v":0},{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L44","v":26.52},{"$f":"'Input Sheet'!M44","v":0.7},{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q44","v":0},{"$f":"'Input Sheet'!R44","v":0},{"$f":"'Input Sheet'!S44","v":0},{"$f":"'Input Sheet'!T44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V44","v":8.75},{"$f":"'Input Sheet'!W44","v":0}]
[{"$f":"'Input Sheet'!C45","v":631007},{"$f":"'Input Sheet'!D45","v":2016},{"$f":"'Input Sheet'!E45","v":"ENVISION"},{"$f":"'Input Sheet'!F45","v":28340},{"$f":"'Input Sheet'!G45","v":0},{"$f":"'Input Sheet'!H45","v":0},{"$f":"'Input Sheet'!I45","v":0},{"$f":"'Input Sheet'!J45","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L45","v":26.52},{"$f":"'Input Sheet'!M45","v":0.7},{"$f":"'Input Sheet'!I45","v":0},{"$f":"'Input Sheet'!J45","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q45","v":0},{"$f":"'Input Sheet'!R45","v":0},{"$f":"'Input Sheet'!S45","v":0},{"$f":"'Input Sheet'!T45","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V45","v":8.75},{"$f":"'Input Sheet'!W45","v":0}]
[{"$f":"'Input Sheet'!C46","v":631009},{"$f":"'Input Sheet'!D46","v":2008},{"$f":"'Input Sheet'!E46","v":"VUE"},{"$f":"'Input Sheet'!F46","v":44316},{"$f":"'Input Sheet'!G46","v":0},{"$f":"'Input Sheet'!H46","v":0},{"$f":"'Input Sheet'!I46","v":0},{"$f":"'Input Sheet'!J46","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L46","v":0},{"$f":"'Input Sheet'!M46","v":0},{"$f":"'Input Sheet'!I46","v":0},{"$f":"'Input Sheet'!J46","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q46","v":59},{"$f":"'Input Sheet'!R46","v":0.5},{"$f":"'Input Sheet'!S46","v":2331},{"$f":"'Input Sheet'!T46","v":19},9.5,{"$f":"'Input Sheet'!V46","v":9.5},{"$f":"'Input Sheet'!W46","v":1}]
[{"$f":"'Input Sheet'!C47","v":631016},{"$f":"'Input Sheet'!D47","v":2014},{"$f":"'Input Sheet'!E47","v":"ENCLAVE"},{"$f":"'Input Sheet'!F47","v":34488},{"$f":"'Input Sheet'!G47","v":0},{"$f":"'Input Sheet'!H47","v":0},{"$f":"'Input Sheet'!I47","v":0},{"$f":"'Input Sheet'!J47","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L47","v":66.52},{"$f":"'Input Sheet'!M47","v":1.2},{"$f":"'Input Sheet'!I47","v":0},{"$f":"'Input Sheet'!J47","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q47","v":0},{"$f":"'Input Sheet'!R47","v":0},{"$f":"'Input Sheet'!S47","v":0},{"$f":"'Input Sheet'!T47","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V47","v":15},{"$f":"'Input Sheet'!W47","v":0}]
[{"$f":"'Input Sheet'!C48","v":631017},{"$f":"'Input Sheet'!D48","v":2014},{"$f":"'Input Sheet'!E48","v":"SILVERADO"},{"$f":"'Input Sheet'!F48","v":33497},{"$f":"'Input Sheet'!G48","v":59.95},{"$f":"'Input Sheet'!H48","v":1},{"$f":"'Input Sheet'!I48","v":2816},{"$f":"'Input Sheet'!J48","v":20},20,{"$f":"'Input Sheet'!L48","v":39.950000000000003},{"$f":"'Input Sheet'!M48","v":0.8},{"$f":"'Input Sheet'!I48","v":2816},{"$f":"'Input Sheet'!J48","v":20},16,{"$f":"'Input Sheet'!Q48","v":0},{"$f":"'Input Sheet'!R48","v":0},{"$f":"'Input Sheet'!S48","v":0},{"$f":"'Input Sheet'!T48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V48","v":36},{"$f":"'Input Sheet'!W48","v":0}]
[{"$f":"'Input Sheet'!C49","v":631019},{"$f":"'Input Sheet'!D49","v":2016},{"$f":"'Input Sheet'!E49","v":"CHEVROLET"},{"$f":"'Input Sheet'!F49","v":28569},{"$f":"'Input Sheet'!G49","v":0},{"$f":"'Input Sheet'!H49","v":0},{"$f":"'Input Sheet'!I49","v":0},{"$f":"'Input Sheet'!J49","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L49","v":26.52},{"$f":"'Input Sheet'!M49","v":0.7},{"$f":"'Input Sheet'!I49","v":0},{"$f":"'Input Sheet'!J49","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q49","v":0},{"$f":"'Input Sheet'!R49","v":0},{"$f":"'Input Sheet'!S49","v":0},{"$f":"'Input Sheet'!T49","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V49","v":8.75},{"$f":"'Input Sheet'!W49","v":0}]
[{"$f":"'Input Sheet'!C50","v":631021},{"$f":"'Input Sheet'!D50","v":2004},{"$f":"'Input Sheet'!E50","v":"ALERO"},{"$f":"'Input Sheet'!F50","v":111000},{"$f":"'Input Sheet'!G50","v":0},{"$f":"'Input Sheet'!H50","v":0},{"$f":"'Input Sheet'!I50","v":0},{"$f":"'Input Sheet'!J50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L50","v":0},{"$f":"'Input Sheet'!M50","v":0},{"$f":"'Input Sheet'!I50","v":0},{"$f":"'Input Sheet'!J50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q50","v":244.26},{"$f":"'Input Sheet'!R50","v":2},{"$f":"'Input Sheet'!S50","v":131},{"$f":"'Input Sheet'!T50","v":22},44,{"$f":"'Input Sheet'!V50","v":44},{"$f":"'Input Sheet'!W50","v":0}]
[{"$f":"'Input Sheet'!C51","v":631027},{"$f":"'Input Sheet'!D51","v":2014},{"$f":"'Input Sheet'!E51","v":"REGAL"},{"$f":"'Input Sheet'!D51","v":2014},{"$f":"'Input Sheet'!G51","v":0},{"$f":"'Input Sheet'!H51","v":0},{"$f":"'Input Sheet'!I51","v":0},{"$f":"'Input Sheet'!J51","v":""},{"$f":"F55*H51","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L51","v":16.57},{"$f":"'Input Sheet'!M51","v":0.4},{"$f":"'Input Sheet'!I51","v":0},{"$f":"'Input Sheet'!J51","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q51","v":0},{"$f":"'Input Sheet'!R51","v":0},{"$f":"'Input Sheet'!S51","v":0},{"$f":"'Input Sheet'!T51","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V51","v":5},{"$f":"'Input Sheet'!W51","v":1}]
[{"$f":"'Input Sheet'!C52","v":631029},{"$f":"'Input Sheet'!D52","v":2012},{"$f":"'Input Sheet'!E52","v":"ACADIA"},{"$f":"'Input Sheet'!F52","v":63847},{"$f":"'Input Sheet'!G52","v":0},{"$f":"'Input Sheet'!H52","v":0},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L52","v":0},{"$f":"'Input Sheet'!M52","v":0},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q52","v":177},{"$f":"'Input Sheet'!R52","v":1.5},{"$f":"'Input Sheet'!S99","v":0},{"$f":"'Input Sheet'!T99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V52","v":48},{"$f":"'Input Sheet'!W52","v":1}]
[{"$f":"'Input Sheet'!C53","v":631039},{"$f":"'Input Sheet'!D53","v":2009},{"$f":"'Input Sheet'!E53","v":"CANYON"},{"$f":"'Input Sheet'!F53","v":138232},{"$f":"'Input Sheet'!G53","v":0},{"$f":"'Input Sheet'!H53","v":0},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L53","v":13.36},{"$f":"'Input Sheet'!M53","v":0.4},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q53","v":0},{"$f":"'Input Sheet'!R53","v":0},{"$f":"'Input Sheet'!S100","v":0},{"$f":"'Input Sheet'!T100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V53","v":5},{"$f":"'Input Sheet'!W53","v":1}]
[{"$f":"'Input Sheet'!C54","v":631040},{"$f":"'Input Sheet'!D54","v":2011},{"$f":"'Input Sheet'!E54","v":"MALIBU"},{"$f":"'Input Sheet'!F54","v":53819},{"$f":"'Input Sheet'!G54","v":0},{"$f":"'Input Sheet'!H54","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"F54*H54","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L54","v":13.36},{"$f":"'Input Sheet'!M54","v":0.4},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"K54*M54","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!Q54","v":0},{"$f":"'Input Sheet'!R54","v":0},{"$f":"'Input Sheet'!S101","v":0},{"$f":"'Input Sheet'!T101","v":""},{"$f":"P54*R54","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V54","v":5},{"$f":"'Input Sheet'!W54","v":1}]
[{"$f":"'Input Sheet'!C55","v":631042},{"$f":"'Input Sheet'!D55","v":2016},{"$f":"'Input Sheet'!E55","v":"ACADIA"},{"$f":"'Input Sheet'!F55","v":42324},{"$f":"'Input Sheet'!G55","v":0},{"$f":"'Input Sheet'!H55","v":0},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$f":"#REF!*H55","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!L55","v":16.57},{"$f":"'Input Sheet'!M55","v":0.4},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q55","v":118},{"$f":"'Input Sheet'!R55","v":1},{"$f":"'Input Sheet'!S105","v":2331},{"$f":"'Input Sheet'!T105","v":19},19,{"$f":"'Input Sheet'!V55","v":27.4},{"$f":"'Input Sheet'!W55","v":0}]
["RO's 1-50",null,null,"Totals",{"$f":"SUM(E6:E55)","v":1962.5900000000001},{"$f":"SUM(F6:F55)","v":20.399999999999999},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},1368.3999999999996,27.699999999999985,9523,170,{"$error":"#VALUE!"},{"$f":"SUM(O6:O55)","v":2787.9400000000005},23.5,null,null,{"$error":"#VALUE!"},1407.7600000000002,{"$f":"COUNTIF(U5:U55,1)","v":15}]
["Date of Study:",null,null,null,"C Labor",null,null,null,null,"M Labor",null,null,null,null,"R Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["Study Compiled by",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"RO Report 51-100","index":4,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,20],[1,4,2,8],[1,9,2,13],[1,14,2,18],[2,0,2,3],[2,20,4,20],[3,0,4,0],[3,4,4,4],[3,5,4,5],[2,19,4,19],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[56,19,58,19],[56,20,58,20],[57,15,58,15],[57,16,58,16],[57,17,58,17],[57,18,58,18],[56,14,56,18],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,11],[3,17,4,17],[3,18,4,18],[57,4,58,4],[57,5,58,5],[57,6,58,6],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[56,4,56,8],[56,9,56,13],[3,10,4,10],[3,11,4,11],[57,12,58,12],[57,13,58,13],[57,14,58,14]]}
["Repair Order Analysis "]
[null,null,null,null,"Competitive Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor"]
["Dealership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["RO Number",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[null,"Year","Model ","Mileage"]
[{"$f":"'Input Sheet'!C56","v":631043},{"$f":"'Input Sheet'!D56","v":2015},{"$f":"'Input Sheet'!E56","v":"SILVERADO"},{"$f":"'Input Sheet'!F56","v":35557},{"$f":"'Input Sheet'!G56","v":0},{"$f":"'Input Sheet'!H56","v":0},{"$f":"'Input Sheet'!I56","v":0},{"$f":"'Input Sheet'!J56","v":""},{"$f":"F6*H6","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L56","v":26.52},{"$f":"'Input Sheet'!M56","v":0.8},{"$f":"'Input Sheet'!N56","v":2860},{"$f":"'Input Sheet'!O56","v":12.5},{"$f":"K6*M6","v":10},{"$f":"'Input Sheet'!Q56","v":0},{"$f":"'Input Sheet'!R56","v":0},{"$f":"'Input Sheet'!S56","v":0},{"$f":"'Input Sheet'!T56","v":""},{"$f":"P6*R6","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V56","v":10},{"$f":"'Input Sheet'!W56","v":0}]
[{"$f":"'Input Sheet'!C57","v":631049},{"$f":"'Input Sheet'!D57","v":2011},{"$f":"'Input Sheet'!E57","v":"ACADIA"},{"$f":"'Input Sheet'!F57","v":120043},{"$f":"'Input Sheet'!G57","v":139.94999999999999},{"$f":"'Input Sheet'!H57","v":1.5},{"$f":"'Input Sheet'!I57","v":2816},{"$f":"'Input Sheet'!J57","v":20},30,{"$f":"'Input Sheet'!L57","v":0},{"$f":"'Input Sheet'!M57","v":0},{"$f":"'Input Sheet'!N57","v":0},{"$f":"'Input Sheet'!O57","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q57","v":247.8},{"$f":"'Input Sheet'!R57","v":2.1},{"$f":"'Input Sheet'!S57","v":2816},{"$f":"'Input Sheet'!T57","v":20},42,{"$f":"'Input Sheet'!V57","v":72},{"$f":"'Input Sheet'!W57","v":0}]
[{"$f":"'Input Sheet'!C58","v":631050},{"$f":"'Input Sheet'!D58","v":2009},{"$f":"'Input Sheet'!E58","v":"ENCLAVE"},{"$f":"'Input Sheet'!F58","v":94062},{"$f":"'Input Sheet'!G58","v":0},{"$f":"'Input Sheet'!H58","v":0},{"$f":"'Input Sheet'!I58","v":0},{"$f":"'Input Sheet'!J58","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L58","v":0},{"$f":"'Input Sheet'!M58","v":0},{"$f":"'Input Sheet'!N58","v":0},{"$f":"'Input Sheet'!O58","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q58","v":916.89},{"$f":"'Input Sheet'!R58","v":6.5},{"$f":"'Input Sheet'!S58","v":2170},{"$f":"'Input Sheet'!T58","v":32},208,{"$f":"'Input Sheet'!V58","v":208},{"$f":"'Input Sheet'!W58","v":1}]
[{"$f":"'Input Sheet'!C59","v":631055},{"$f":"'Input Sheet'!D59","v":2012},{"$f":"'Input Sheet'!E59","v":"MALIBU"},{"$f":"'Input Sheet'!F59","v":81283},{"$f":"'Input Sheet'!G59","v":222.1},{"$f":"'Input Sheet'!H59","v":2.9},{"$f":"'Input Sheet'!I59","v":"2786/2180"},{"$f":"'Input Sheet'!J59","v":16},46.4,{"$f":"'Input Sheet'!L59","v":35},{"$f":"'Input Sheet'!M59","v":1},{"$f":"'Input Sheet'!N59","v":2786},{"$f":"'Input Sheet'!O59","v":12.5},12.5,{"$f":"'Input Sheet'!Q59","v":0},{"$f":"'Input Sheet'!R59","v":0},{"$f":"'Input Sheet'!S59","v":0},{"$f":"'Input Sheet'!T59","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V59","v":58.9},{"$f":"'Input Sheet'!W59","v":0}]
[{"$f":"'Input Sheet'!C60","v":631059},{"$f":"'Input Sheet'!D60","v":2015},{"$f":"'Input Sheet'!E60","v":"LACROSSE"},{"$f":"'Input Sheet'!F60","v":30178},{"$f":"'Input Sheet'!G60","v":0},{"$f":"'Input Sheet'!H60","v":0},{"$f":"'Input Sheet'!I60","v":0},{"$f":"'Input Sheet'!J60","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L60","v":16.57},{"$f":"'Input Sheet'!M60","v":0.4},{"$f":"'Input Sheet'!N60","v":2781},{"$f":"'Input Sheet'!O60","v":12.5},5,{"$f":"'Input Sheet'!Q60","v":0},{"$f":"'Input Sheet'!R60","v":0},{"$f":"'Input Sheet'!S60","v":0},{"$f":"'Input Sheet'!T60","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V60","v":5},{"$f":"'Input Sheet'!W60","v":1}]
[{"$f":"'Input Sheet'!C61","v":631063},{"$f":"'Input Sheet'!D61","v":2012},{"$f":"'Input Sheet'!E61","v":"SIERRA"},{"$f":"'Input Sheet'!F61","v":51378},{"$f":"'Input Sheet'!G61","v":0},{"$f":"'Input Sheet'!H61","v":0},{"$f":"'Input Sheet'!I61","v":0},{"$f":"'Input Sheet'!J61","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L61","v":16.57},{"$f":"'Input Sheet'!M61","v":0.4},{"$f":"'Input Sheet'!N61","v":2860},{"$f":"'Input Sheet'!O61","v":12.5},5,{"$f":"'Input Sheet'!Q61","v":0},{"$f":"'Input Sheet'!R61","v":0},{"$f":"'Input Sheet'!S61","v":0},{"$f":"'Input Sheet'!T61","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V61","v":5},{"$f":"'Input Sheet'!W61","v":1}]
[{"$f":"'Input Sheet'!C62","v":631069},{"$f":"'Input Sheet'!D62","v":2007},{"$f":"'Input Sheet'!E62","v":"9-7 SAAB"},{"$f":"'Input Sheet'!F62","v":130382},{"$f":"'Input Sheet'!G62","v":0},{"$f":"'Input Sheet'!H62","v":0},{"$f":"'Input Sheet'!I62","v":0},{"$f":"'Input Sheet'!J62","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L62","v":13.36},{"$f":"'Input Sheet'!M62","v":0.4},{"$f":"'Input Sheet'!N62","v":2762},{"$f":"'Input Sheet'!O62","v":12.5},5,{"$f":"'Input Sheet'!Q62","v":0},{"$f":"'Input Sheet'!R62","v":0},{"$f":"'Input Sheet'!S62","v":0},{"$f":"'Input Sheet'!T62","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V62","v":5},{"$f":"'Input Sheet'!W62","v":1}]
[{"$f":"'Input Sheet'!C63","v":631073},{"$f":"'Input Sheet'!D63","v":2014},{"$f":"'Input Sheet'!E63","v":"SIERRA"},{"$f":"'Input Sheet'!F63","v":33580},{"$f":"'Input Sheet'!G63","v":0},{"$f":"'Input Sheet'!H63","v":0},{"$f":"'Input Sheet'!I63","v":0},{"$f":"'Input Sheet'!J63","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L63","v":16.57},{"$f":"'Input Sheet'!M63","v":0.4},{"$f":"'Input Sheet'!N63","v":2087},{"$f":"'Input Sheet'!O63","v":13.5},5.4,{"$f":"'Input Sheet'!Q63","v":0},{"$f":"'Input Sheet'!R63","v":0},{"$f":"'Input Sheet'!S63","v":0},{"$f":"'Input Sheet'!T63","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V63","v":5.4},{"$f":"'Input Sheet'!W63","v":1}]
[{"$f":"'Input Sheet'!C64","v":631074},{"$f":"'Input Sheet'!D64","v":2014},{"$f":"'Input Sheet'!E64","v":"TERRAIN"},{"$f":"'Input Sheet'!F64","v":37902},{"$f":"'Input Sheet'!G64","v":0},{"$f":"'Input Sheet'!H64","v":0},{"$f":"'Input Sheet'!I64","v":0},{"$f":"'Input Sheet'!J64","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L64","v":26.52},{"$f":"'Input Sheet'!M64","v":0.7},{"$f":"'Input Sheet'!N64","v":2768},{"$f":"'Input Sheet'!O64","v":12.5},8.75,{"$f":"'Input Sheet'!Q64","v":0},{"$f":"'Input Sheet'!R64","v":0},{"$f":"'Input Sheet'!S64","v":0},{"$f":"'Input Sheet'!T64","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V64","v":8.75},{"$f":"'Input Sheet'!W64","v":0}]
[{"$f":"'Input Sheet'!C65","v":631077},{"$f":"'Input Sheet'!D65","v":2010},{"$f":"'Input Sheet'!E65","v":"IMPALA"},{"$f":"'Input Sheet'!F65","v":88318},{"$f":"'Input Sheet'!G65","v":76.05},{"$f":"'Input Sheet'!H65","v":1},{"$f":"'Input Sheet'!I65","v":61},{"$f":"'Input Sheet'!J65","v":34},34,{"$f":"'Input Sheet'!L65","v":9.9499999999999993},{"$f":"'Input Sheet'!M65","v":0.4},{"$f":"'Input Sheet'!N65","v":2781},{"$f":"'Input Sheet'!O65","v":12.5},5,{"$f":"'Input Sheet'!Q65","v":0},{"$f":"'Input Sheet'!R65","v":0},{"$f":"'Input Sheet'!S65","v":0},{"$f":"'Input Sheet'!T65","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V65","v":39},{"$f":"'Input Sheet'!W65","v":0}]
[{"$f":"'Input Sheet'!C66","v":631086},{"$f":"'Input Sheet'!D66","v":2008},{"$f":"'Input Sheet'!E66","v":"LUCERNE"},{"$f":"'Input Sheet'!F66","v":94860},{"$f":"'Input Sheet'!G66","v":0},{"$f":"'Input Sheet'!H66","v":0},{"$f":"'Input Sheet'!I66","v":0},{"$f":"'Input Sheet'!J66","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L66","v":13.36},{"$f":"'Input Sheet'!M66","v":0.4},{"$f":"'Input Sheet'!N66","v":2781},{"$f":"'Input Sheet'!O66","v":12.5},5,{"$f":"'Input Sheet'!Q66","v":0},{"$f":"'Input Sheet'!R66","v":0},{"$f":"'Input Sheet'!S66","v":0},{"$f":"'Input Sheet'!T66","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V66","v":5},{"$f":"'Input Sheet'!W66","v":1}]
[{"$f":"'Input Sheet'!C67","v":632008},{"$f":"'Input Sheet'!D67","v":2004},{"$f":"'Input Sheet'!E67","v":"AZTEK"},{"$f":"'Input Sheet'!F67","v":89096},{"$f":"'Input Sheet'!G67","v":0},{"$f":"'Input Sheet'!H67","v":0},{"$f":"'Input Sheet'!I67","v":0},{"$f":"'Input Sheet'!J67","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L67","v":32},{"$f":"'Input Sheet'!M67","v":0.4},{"$f":"'Input Sheet'!N67","v":2801},{"$f":"'Input Sheet'!O67","v":12.5},5,{"$f":"'Input Sheet'!Q67","v":0},{"$f":"'Input Sheet'!R67","v":0},{"$f":"'Input Sheet'!S67","v":0},{"$f":"'Input Sheet'!T67","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V67","v":5},{"$f":"'Input Sheet'!W67","v":1}]
[{"$f":"'Input Sheet'!C68","v":632012},{"$f":"'Input Sheet'!D68","v":2016},{"$f":"'Input Sheet'!E68","v":"TRAX"},{"$f":"'Input Sheet'!F68","v":27653},{"$f":"'Input Sheet'!G68","v":0},{"$f":"'Input Sheet'!H68","v":0},{"$f":"'Input Sheet'!I68","v":0},{"$f":"'Input Sheet'!J68","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L68","v":26.52},{"$f":"'Input Sheet'!M68","v":0.7},{"$f":"'Input Sheet'!N68","v":2768},{"$f":"'Input Sheet'!O68","v":12.5},8.75,{"$f":"'Input Sheet'!Q68","v":0},{"$f":"'Input Sheet'!R68","v":0},{"$f":"'Input Sheet'!S68","v":0},{"$f":"'Input Sheet'!T68","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V68","v":8.75},{"$f":"'Input Sheet'!W68","v":0}]
[{"$f":"'Input Sheet'!C69","v":632013},{"$f":"'Input Sheet'!D69","v":2005},{"$f":"'Input Sheet'!E69","v":"VENTURE"},{"$f":"'Input Sheet'!F69","v":66808},{"$f":"'Input Sheet'!G69","v":0},{"$f":"'Input Sheet'!H69","v":0},{"$f":"'Input Sheet'!I69","v":0},{"$f":"'Input Sheet'!J69","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L69","v":23.31},{"$f":"'Input Sheet'!M69","v":0.7},{"$f":"'Input Sheet'!N69","v":2781},{"$f":"'Input Sheet'!O69","v":12.5},8.75,{"$f":"'Input Sheet'!Q69","v":0},{"$f":"'Input Sheet'!R69","v":0},{"$f":"'Input Sheet'!S69","v":0},{"$f":"'Input Sheet'!T69","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V69","v":8.75},{"$f":"'Input Sheet'!W69","v":0}]
[{"$f":"'Input Sheet'!C70","v":632015},{"$f":"'Input Sheet'!D70","v":2011},{"$f":"'Input Sheet'!E70","v":"SIERRA"},{"$f":"'Input Sheet'!F70","v":109691},{"$f":"'Input Sheet'!G70","v":0},{"$f":"'Input Sheet'!H70","v":0},{"$f":"'Input Sheet'!I70","v":0},{"$f":"'Input Sheet'!J70","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L70","v":26.52},{"$f":"'Input Sheet'!M70","v":0.7},{"$f":"'Input Sheet'!N70","v":2860},{"$f":"'Input Sheet'!O70","v":12.5},8.75,{"$f":"'Input Sheet'!Q70","v":0},{"$f":"'Input Sheet'!R70","v":0},{"$f":"'Input Sheet'!S70","v":0},{"$f":"'Input Sheet'!T70","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V70","v":8.75},{"$f":"'Input Sheet'!W70","v":0}]
[{"$f":"'Input Sheet'!C71","v":632031},{"$f":"'Input Sheet'!D71","v":2010},{"$f":"'Input Sheet'!E71","v":"MARINER"},{"$f":"'Input Sheet'!F71","v":182552},{"$f":"'Input Sheet'!G71","v":0},{"$f":"'Input Sheet'!H71","v":0},{"$f":"'Input Sheet'!I71","v":0},{"$f":"'Input Sheet'!J71","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L71","v":13.36},{"$f":"'Input Sheet'!M71","v":0.4},{"$f":"'Input Sheet'!N71","v":2860},{"$f":"'Input Sheet'!O71","v":12.5},5,{"$f":"'Input Sheet'!Q71","v":0},{"$f":"'Input Sheet'!R71","v":0},{"$f":"'Input Sheet'!S71","v":0},{"$f":"'Input Sheet'!T71","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V71","v":5},{"$f":"'Input Sheet'!W71","v":1}]
[{"$f":"'Input Sheet'!C72","v":632033},{"$f":"'Input Sheet'!D72","v":2014},{"$f":"'Input Sheet'!E72","v":"ENCORE"},{"$f":"'Input Sheet'!F72","v":37603},{"$f":"'Input Sheet'!G72","v":0},{"$f":"'Input Sheet'!H72","v":0},{"$f":"'Input Sheet'!I72","v":0},{"$f":"'Input Sheet'!J72","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L72","v":16.57},{"$f":"'Input Sheet'!M72","v":0.4},{"$f":"'Input Sheet'!N72","v":2768},{"$f":"'Input Sheet'!O72","v":12.5},5,{"$f":"'Input Sheet'!Q72","v":0},{"$f":"'Input Sheet'!R72","v":0},{"$f":"'Input Sheet'!S72","v":0},{"$f":"'Input Sheet'!T72","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V72","v":5},{"$f":"'Input Sheet'!W72","v":1}]
[{"$f":"'Input Sheet'!C73","v":632036},{"$f":"'Input Sheet'!D73","v":2016},{"$f":"'Input Sheet'!E73","v":"FUSION"},{"$f":"'Input Sheet'!F73","v":39941},{"$f":"'Input Sheet'!G73","v":0},{"$f":"'Input Sheet'!H73","v":0},{"$f":"'Input Sheet'!I73","v":0},{"$f":"'Input Sheet'!J73","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L73","v":29.95},{"$f":"'Input Sheet'!M73","v":0.7},{"$f":"'Input Sheet'!N73","v":2781},{"$f":"'Input Sheet'!O73","v":12.5},8.75,{"$f":"'Input Sheet'!Q73","v":0},{"$f":"'Input Sheet'!R73","v":0},{"$f":"'Input Sheet'!S73","v":0},{"$f":"'Input Sheet'!T73","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V73","v":8.75},{"$f":"'Input Sheet'!W73","v":0}]
[{"$f":"'Input Sheet'!C74","v":632041},{"$f":"'Input Sheet'!D74","v":2011},{"$f":"'Input Sheet'!E74","v":"TERRAIN"},{"$f":"'Input Sheet'!F74","v":157488},{"$f":"'Input Sheet'!G74","v":0},{"$f":"'Input Sheet'!H74","v":0},{"$f":"'Input Sheet'!I74","v":0},{"$f":"'Input Sheet'!J74","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L74","v":26.52},{"$f":"'Input Sheet'!M74","v":0.7},{"$f":"'Input Sheet'!N74","v":2768},{"$f":"'Input Sheet'!O74","v":12.5},8.75,{"$f":"'Input Sheet'!Q74","v":0},{"$f":"'Input Sheet'!R74","v":0},{"$f":"'Input Sheet'!S74","v":0},{"$f":"'Input Sheet'!T74","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V74","v":8.75},{"$f":"'Input Sheet'!W74","v":0}]
[{"$f":"'Input Sheet'!C75","v":632043},{"$f":"'Input Sheet'!D75","v":2011},{"$f":"'Input Sheet'!E75","v":"SILVERADO"},{"$f":"'Input Sheet'!F75","v":28240},{"$f":"'Input Sheet'!G75","v":0},{"$f":"'Input Sheet'!H75","v":0},{"$f":"'Input Sheet'!I75","v":0},{"$f":"'Input Sheet'!J75","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L75","v":16.57},{"$f":"'Input Sheet'!M75","v":0.4},{"$f":"'Input Sheet'!N75","v":2678},{"$f":"'Input Sheet'!O75","v":12.5},5,{"$f":"'Input Sheet'!Q75","v":0},{"$f":"'Input Sheet'!R75","v":0},{"$f":"'Input Sheet'!S75","v":0},{"$f":"'Input Sheet'!T75","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V75","v":5},{"$f":"'Input Sheet'!W75","v":1}]
[{"$f":"'Input Sheet'!C76","v":632045},{"$f":"'Input Sheet'!D76","v":2009},{"$f":"'Input Sheet'!E76","v":"ENCLAVE"},{"$f":"'Input Sheet'!F76","v":74912},{"$f":"'Input Sheet'!G76","v":89.95},{"$f":"'Input Sheet'!H76","v":1.5},{"$f":"'Input Sheet'!I76","v":1354},{"$f":"'Input Sheet'!J76","v":26},39,{"$f":"'Input Sheet'!L76","v":" "},{"$f":"'Input Sheet'!M76","v":" "},{"$f":"'Input Sheet'!N76","v":" "},{"$f":"'Input Sheet'!O76","v":" "},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q76","v":1345},{"$f":"'Input Sheet'!R76","v":12.1},{"$f":"'Input Sheet'!S76","v":1354},{"$f":"'Input Sheet'!T76","v":26},314.59999999999997,{"$f":"'Input Sheet'!V76","v":353.59999999999997},{"$f":"'Input Sheet'!W76","v":0}]
[{"$f":"'Input Sheet'!C77","v":632047},{"$f":"'Input Sheet'!D77","v":2016},{"$f":"'Input Sheet'!E77","v":"ACADIA"},{"$f":"'Input Sheet'!F77","v":19352},{"$f":"'Input Sheet'!G77","v":0},{"$f":"'Input Sheet'!H77","v":0},{"$f":"'Input Sheet'!I77","v":0},{"$f":"'Input Sheet'!J77","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L77","v":26.52},{"$f":"'Input Sheet'!M77","v":0.7},{"$f":"'Input Sheet'!N77","v":2768},{"$f":"'Input Sheet'!O77","v":12.5},8.75,{"$f":"'Input Sheet'!Q77","v":0},{"$f":"'Input Sheet'!R77","v":0},{"$f":"'Input Sheet'!S77","v":0},{"$f":"'Input Sheet'!T77","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V77","v":8.75},{"$f":"'Input Sheet'!W77","v":0}]
[{"$f":"'Input Sheet'!C78","v":632048},{"$f":"'Input Sheet'!D78","v":2011},{"$f":"'Input Sheet'!E78","v":"TERRAIN"},{"$f":"'Input Sheet'!F78","v":124023},{"$f":"'Input Sheet'!G78","v":0},{"$f":"'Input Sheet'!H78","v":0},{"$f":"'Input Sheet'!I78","v":0},{"$f":"'Input Sheet'!J78","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L78","v":40.57},{"$f":"'Input Sheet'!M78","v":1},{"$f":"'Input Sheet'!N78","v":2762},{"$f":"'Input Sheet'!O78","v":12.5},12.5,{"$f":"'Input Sheet'!Q78","v":396.83},{"$f":"'Input Sheet'!R78","v":3.3},{"$f":"'Input Sheet'!S78","v":1354},{"$f":"'Input Sheet'!T78","v":26},85.8,{"$f":"'Input Sheet'!V78","v":98.3},{"$f":"'Input Sheet'!W78","v":0}]
[{"$f":"'Input Sheet'!C79","v":632049},{"$f":"'Input Sheet'!D79","v":2015},{"$f":"'Input Sheet'!E79","v":"YUKON"},{"$f":"'Input Sheet'!F79","v":46046},{"$f":"'Input Sheet'!G79","v":0},{"$f":"'Input Sheet'!H79","v":0},{"$f":"'Input Sheet'!I79","v":0},{"$f":"'Input Sheet'!J79","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L79","v":24.57},{"$f":"'Input Sheet'!M79","v":0.7},{"$f":"'Input Sheet'!N79","v":2678},{"$f":"'Input Sheet'!O79","v":12.5},8.75,{"$f":"'Input Sheet'!Q79","v":0},{"$f":"'Input Sheet'!R79","v":0},{"$f":"'Input Sheet'!S79","v":0},{"$f":"'Input Sheet'!T79","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V79","v":8.75},{"$f":"'Input Sheet'!W79","v":0}]
[{"$f":"'Input Sheet'!C80","v":632052},{"$f":"'Input Sheet'!D80","v":2015},{"$f":"'Input Sheet'!E80","v":"SIERRA"},{"$f":"'Input Sheet'!F80","v":96614},{"$f":"'Input Sheet'!G80","v":112},{"$f":"'Input Sheet'!H80","v":1.4},{"$f":"'Input Sheet'!I80","v":1404},{"$f":"'Input Sheet'!J80","v":28},39.199999999999996,{"$f":"'Input Sheet'!L80","v":0},{"$f":"'Input Sheet'!M80","v":0},{"$f":"'Input Sheet'!N80","v":0},{"$f":"'Input Sheet'!O80","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q80","v":0},{"$f":"'Input Sheet'!R80","v":0},{"$f":"'Input Sheet'!S80","v":0},{"$f":"'Input Sheet'!T80","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V80","v":39.199999999999996},{"$f":"'Input Sheet'!W80","v":0}]
[{"$f":"'Input Sheet'!C81","v":632053},{"$f":"'Input Sheet'!D81","v":2015},{"$f":"'Input Sheet'!E81","v":"SIERRA"},{"$f":"'Input Sheet'!F81","v":39783},{"$f":"'Input Sheet'!G81","v":0},{"$f":"'Input Sheet'!H81","v":0},{"$f":"'Input Sheet'!I81","v":0},{"$f":"'Input Sheet'!J81","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L81","v":26.52},{"$f":"'Input Sheet'!M81","v":0.7},{"$f":"'Input Sheet'!N81","v":2768},{"$f":"'Input Sheet'!O81","v":12.5},8.75,{"$f":"'Input Sheet'!Q81","v":0},{"$f":"'Input Sheet'!R81","v":0},{"$f":"'Input Sheet'!S81","v":0},{"$f":"'Input Sheet'!T81","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V81","v":8.75},{"$f":"'Input Sheet'!W81","v":0}]
[{"$f":"'Input Sheet'!C82","v":632054},{"$f":"'Input Sheet'!D82","v":2013},{"$f":"'Input Sheet'!E82","v":"TOWN&COUNTRY"},{"$f":"'Input Sheet'!F82","v":34188},{"$f":"'Input Sheet'!G82","v":0},{"$f":"'Input Sheet'!H82","v":0},{"$f":"'Input Sheet'!I82","v":0},{"$f":"'Input Sheet'!J82","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L82","v":13.36},{"$f":"'Input Sheet'!M82","v":0.4},{"$f":"'Input Sheet'!N82","v":2860},{"$f":"'Input Sheet'!O82","v":12.5},5,{"$f":"'Input Sheet'!Q82","v":0},{"$f":"'Input Sheet'!R82","v":0},{"$f":"'Input Sheet'!S82","v":0},{"$f":"'Input Sheet'!T82","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V82","v":5},{"$f":"'Input Sheet'!W82","v":1}]
[{"$f":"'Input Sheet'!C83","v":632056},{"$f":"'Input Sheet'!D83","v":2011},{"$f":"'Input Sheet'!E83","v":"REGAL"},{"$f":"'Input Sheet'!F83","v":94093},{"$f":"'Input Sheet'!G83","v":0},{"$f":"'Input Sheet'!H83","v":0},{"$f":"'Input Sheet'!I83","v":0},{"$f":"'Input Sheet'!J83","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L83","v":0},{"$f":"'Input Sheet'!M83","v":0},{"$f":"'Input Sheet'!N83","v":0},{"$f":"'Input Sheet'!O83","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q83","v":118},{"$f":"'Input Sheet'!R83","v":1},{"$f":"'Input Sheet'!S83","v":224},{"$f":"'Input Sheet'!T83","v":30},30,{"$f":"'Input Sheet'!V83","v":30},{"$f":"'Input Sheet'!W83","v":1}]
[{"$f":"'Input Sheet'!C84","v":632057},{"$f":"'Input Sheet'!D84","v":2016},{"$f":"'Input Sheet'!E84","v":"EQUINOX"},{"$f":"'Input Sheet'!F84","v":25334},{"$f":"'Input Sheet'!G84","v":0},{"$f":"'Input Sheet'!H84","v":0},{"$f":"'Input Sheet'!I84","v":0},{"$f":"'Input Sheet'!J84","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L84","v":26.52},{"$f":"'Input Sheet'!M84","v":0.7},{"$f":"'Input Sheet'!N84","v":2678},{"$f":"'Input Sheet'!O84","v":12.5},8.75,{"$f":"'Input Sheet'!Q84","v":0},{"$f":"'Input Sheet'!R84","v":0},{"$f":"'Input Sheet'!S84","v":0},{"$f":"'Input Sheet'!T84","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V84","v":8.75},{"$f":"'Input Sheet'!W84","v":0}]
[{"$f":"'Input Sheet'!C85","v":632059},{"$f":"'Input Sheet'!D85","v":2008},{"$f":"'Input Sheet'!E85","v":"TRAILBLAZER"},{"$f":"'Input Sheet'!F85","v":83900},{"$f":"'Input Sheet'!G85","v":35},{"$f":"'Input Sheet'!H85","v":0.5},{"$f":"'Input Sheet'!I85","v":2816},{"$f":"'Input Sheet'!J85","v":20},10,{"$f":"'Input Sheet'!L85","v":13.36},{"$f":"'Input Sheet'!M85","v":0.4},{"$f":"'Input Sheet'!N85","v":2768},{"$f":"'Input Sheet'!O85","v":12.5},5,{"$f":"'Input Sheet'!Q85","v":0},{"$f":"'Input Sheet'!R85","v":0},{"$f":"'Input Sheet'!S85","v":0},{"$f":"'Input Sheet'!T85","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V85","v":15},{"$f":"'Input Sheet'!W85","v":0}]
[{"$f":"'Input Sheet'!C86","v":632061},{"$f":"'Input Sheet'!D86","v":2014},{"$f":"'Input Sheet'!E86","v":"CRUZE"},{"$f":"'Input Sheet'!F86","v":71437},{"$f":"'Input Sheet'!G86","v":0},{"$f":"'Input Sheet'!H86","v":0},{"$f":"'Input Sheet'!I86","v":0},{"$f":"'Input Sheet'!J86","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L86","v":16.57},{"$f":"'Input Sheet'!M86","v":0.4},{"$f":"'Input Sheet'!N86","v":2762},{"$f":"'Input Sheet'!O86","v":12.5},5,{"$f":"'Input Sheet'!Q86","v":0},{"$f":"'Input Sheet'!R86","v":0},{"$f":"'Input Sheet'!S86","v":0},{"$f":"'Input Sheet'!T86","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V86","v":5},{"$f":"'Input Sheet'!W86","v":0}]
[{"$f":"'Input Sheet'!C87","v":632063},{"$f":"'Input Sheet'!D87","v":2014},{"$f":"'Input Sheet'!E87","v":"ENCORE"},{"$f":"'Input Sheet'!F87","v":34532},{"$f":"'Input Sheet'!G87","v":0},{"$f":"'Input Sheet'!H87","v":0},{"$f":"'Input Sheet'!I87","v":0},{"$f":"'Input Sheet'!J87","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L87","v":29.02},{"$f":"'Input Sheet'!M87","v":0.8},{"$f":"'Input Sheet'!N87","v":2768},{"$f":"'Input Sheet'!O87","v":12.5},10,{"$f":"'Input Sheet'!Q87","v":0},{"$f":"'Input Sheet'!R87","v":0},{"$f":"'Input Sheet'!S87","v":0},{"$f":"'Input Sheet'!T87","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V87","v":10},{"$f":"'Input Sheet'!W87","v":0}]
[{"$f":"'Input Sheet'!C88","v":632065},{"$f":"'Input Sheet'!D88","v":2011},{"$f":"'Input Sheet'!E88","v":"SIERRA"},{"$f":"'Input Sheet'!F88","v":123962},{"$f":"'Input Sheet'!G88","v":0},{"$f":"'Input Sheet'!H88","v":0},{"$f":"'Input Sheet'!I88","v":0},{"$f":"'Input Sheet'!J88","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L88","v":26.52},{"$f":"'Input Sheet'!M88","v":0.7},{"$f":"'Input Sheet'!N88","v":2801},{"$f":"'Input Sheet'!O88","v":12.5},8.75,{"$f":"'Input Sheet'!Q88","v":0},{"$f":"'Input Sheet'!R88","v":0},{"$f":"'Input Sheet'!S88","v":0},{"$f":"'Input Sheet'!T88","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V88","v":8.75},{"$f":"'Input Sheet'!W88","v":0}]
[{"$f":"'Input Sheet'!C89","v":632080},{"$f":"'Input Sheet'!D89","v":2017},{"$f":"'Input Sheet'!E89","v":"TERRAIN"},{"$f":"'Input Sheet'!F89","v":7048},{"$f":"'Input Sheet'!G89","v":0},{"$f":"'Input Sheet'!H89","v":0},{"$f":"'Input Sheet'!I89","v":0},{"$f":"'Input Sheet'!J89","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L89","v":20},{"$f":"'Input Sheet'!M89","v":0.4},{"$f":"'Input Sheet'!N89","v":2762},{"$f":"'Input Sheet'!O89","v":12.5},5,{"$f":"'Input Sheet'!Q89","v":0},{"$f":"'Input Sheet'!R89","v":0},{"$f":"'Input Sheet'!S89","v":0},{"$f":"'Input Sheet'!T89","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V89","v":5},{"$f":"'Input Sheet'!W89","v":0}]
[{"$f":"'Input Sheet'!C90","v":632083},{"$f":"'Input Sheet'!D90","v":2014},{"$f":"'Input Sheet'!E90","v":"EQUINOX"},{"$f":"'Input Sheet'!F90","v":19572},{"$f":"'Input Sheet'!G90","v":0},{"$f":"'Input Sheet'!H90","v":0},{"$f":"'Input Sheet'!I90","v":0},{"$f":"'Input Sheet'!J90","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L90","v":16.57},{"$f":"'Input Sheet'!M90","v":0.4},{"$f":"'Input Sheet'!N90","v":2801},{"$f":"'Input Sheet'!O90","v":12.5},5,{"$f":"'Input Sheet'!Q90","v":0},{"$f":"'Input Sheet'!R90","v":0},{"$f":"'Input Sheet'!S90","v":0},{"$f":"'Input Sheet'!T90","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V90","v":5},{"$f":"'Input Sheet'!W90","v":1}]
[{"$f":"'Input Sheet'!C91","v":632085},{"$f":"'Input Sheet'!D91","v":2015},{"$f":"'Input Sheet'!E91","v":"YUKON"},{"$f":"'Input Sheet'!F91","v":48065},{"$f":"'Input Sheet'!G91","v":0},{"$f":"'Input Sheet'!H91","v":0},{"$f":"'Input Sheet'!I91","v":0},{"$f":"'Input Sheet'!J91","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L91","v":26.52},{"$f":"'Input Sheet'!M91","v":0.7},{"$f":"'Input Sheet'!N91","v":2860},{"$f":"'Input Sheet'!O91","v":12.5},8.75,{"$f":"'Input Sheet'!Q91","v":177},{"$f":"'Input Sheet'!R91","v":1.5},{"$f":"'Input Sheet'!S91","v":1354},{"$f":"'Input Sheet'!T91","v":26},39,{"$f":"'Input Sheet'!V91","v":47.75},{"$f":"'Input Sheet'!W91","v":0}]
[{"$f":"'Input Sheet'!C92","v":632088},{"$f":"'Input Sheet'!D92","v":2015},{"$f":"'Input Sheet'!E92","v":"TERRAIN"},{"$f":"'Input Sheet'!F92","v":50363},{"$f":"'Input Sheet'!G92","v":0},{"$f":"'Input Sheet'!H92","v":0},{"$f":"'Input Sheet'!I92","v":0},{"$f":"'Input Sheet'!J92","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L92","v":16.57},{"$f":"'Input Sheet'!M92","v":0.4},{"$f":"'Input Sheet'!N92","v":1404},{"$f":"'Input Sheet'!O92","v":24},9.6000000000000014,{"$f":"'Input Sheet'!Q92","v":0},{"$f":"'Input Sheet'!R92","v":0},{"$f":"'Input Sheet'!S92","v":0},{"$f":"'Input Sheet'!T92","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V92","v":9.6000000000000014},{"$f":"'Input Sheet'!W92","v":1}]
[{"$f":"'Input Sheet'!C93","v":632092},{"$f":"'Input Sheet'!D93","v":2011},{"$f":"'Input Sheet'!E93","v":"TERRAIN"},{"$f":"'Input Sheet'!F93","v":74584},{"$f":"'Input Sheet'!G93","v":0},{"$f":"'Input Sheet'!H93","v":0},{"$f":"'Input Sheet'!I93","v":0},{"$f":"'Input Sheet'!J93","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L93","v":16.57},{"$f":"'Input Sheet'!M93","v":0.4},{"$f":"'Input Sheet'!N93","v":2768},{"$f":"'Input Sheet'!O93","v":12.5},5,{"$f":"'Input Sheet'!Q93","v":0},{"$f":"'Input Sheet'!R93","v":0},{"$f":"'Input Sheet'!S93","v":0},{"$f":"'Input Sheet'!T93","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V93","v":5},{"$f":"'Input Sheet'!W93","v":1}]
[{"$f":"'Input Sheet'!C94","v":632094},{"$f":"'Input Sheet'!D94","v":2015},{"$f":"'Input Sheet'!E94","v":"ACADIA"},{"$f":"'Input Sheet'!F94","v":33374},{"$f":"'Input Sheet'!G94","v":92},{"$f":"'Input Sheet'!H94","v":1},{"$f":"'Input Sheet'!I94","v":131},{"$f":"'Input Sheet'!J94","v":92},92,{"$f":"'Input Sheet'!L94","v":0},{"$f":"'Input Sheet'!M94","v":0},{"$f":"'Input Sheet'!N94","v":0},{"$f":"'Input Sheet'!O94","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q94","v":0},{"$f":"'Input Sheet'!R94","v":0},{"$f":"'Input Sheet'!S94","v":0},{"$f":"'Input Sheet'!T94","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V94","v":92},{"$f":"'Input Sheet'!W94","v":0}]
[{"$f":"'Input Sheet'!C95","v":633002},{"$f":"'Input Sheet'!D95","v":2017},{"$f":"'Input Sheet'!E95","v":"ENCLAVE"},{"$f":"'Input Sheet'!F95","v":8488},{"$f":"'Input Sheet'!G95","v":0},{"$f":"'Input Sheet'!H95","v":0},{"$f":"'Input Sheet'!I95","v":0},{"$f":"'Input Sheet'!J95","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L95","v":12},{"$f":"'Input Sheet'!M95","v":0.3},{"$f":"'Input Sheet'!N95","v":2087},{"$f":"'Input Sheet'!O95","v":12.5},3.75,{"$f":"'Input Sheet'!Q95","v":0},{"$f":"'Input Sheet'!R95","v":0},{"$f":"'Input Sheet'!S95","v":0},{"$f":"'Input Sheet'!T95","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V95","v":3.75},{"$f":"'Input Sheet'!W95","v":1}]
[{"$f":"'Input Sheet'!C96","v":633004},{"$f":"'Input Sheet'!D96","v":2009},{"$f":"'Input Sheet'!E96","v":"VUE"},{"$f":"'Input Sheet'!F96","v":110386},{"$f":"'Input Sheet'!G96","v":0},{"$f":"'Input Sheet'!H96","v":0},{"$f":"'Input Sheet'!I96","v":0},{"$f":"'Input Sheet'!J96","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L96","v":13.36},{"$f":"'Input Sheet'!M96","v":0.4},{"$f":"'Input Sheet'!N96","v":2087},{"$f":"'Input Sheet'!O96","v":13.5},5.4,{"$f":"'Input Sheet'!Q96","v":0},{"$f":"'Input Sheet'!R96","v":0},{"$f":"'Input Sheet'!S96","v":0},{"$f":"'Input Sheet'!T96","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V96","v":5.4},{"$f":"'Input Sheet'!W96","v":0}]
[{"$f":"'Input Sheet'!C97","v":633005},{"$f":"'Input Sheet'!D97","v":2009},{"$f":"'Input Sheet'!E97","v":"VIBE"},{"$f":"'Input Sheet'!F97","v":85066},{"$f":"'Input Sheet'!G97","v":0},{"$f":"'Input Sheet'!H97","v":0},{"$f":"'Input Sheet'!I97","v":0},{"$f":"'Input Sheet'!J97","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L97","v":58.31},{"$f":"'Input Sheet'!M97","v":1.2},{"$f":"'Input Sheet'!N97","v":2781},{"$f":"'Input Sheet'!O97","v":12.5},15,{"$f":"'Input Sheet'!Q97","v":0},{"$f":"'Input Sheet'!R97","v":0},{"$f":"'Input Sheet'!S97","v":0},{"$f":"'Input Sheet'!T97","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V97","v":15},{"$f":"'Input Sheet'!W97","v":0}]
[{"$f":"'Input Sheet'!C98","v":633006},{"$f":"'Input Sheet'!D98","v":2008},{"$f":"'Input Sheet'!E98","v":"ENVOY"},{"$f":"'Input Sheet'!F98","v":135506},{"$f":"'Input Sheet'!G98","v":0},{"$f":"'Input Sheet'!H98","v":0},{"$f":"'Input Sheet'!I98","v":0},{"$f":"'Input Sheet'!J98","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L98","v":23.31},{"$f":"'Input Sheet'!M98","v":0.7},{"$f":"'Input Sheet'!N98","v":2087},{"$f":"'Input Sheet'!O98","v":13.5},9.4499999999999993,{"$f":"'Input Sheet'!Q98","v":0},{"$f":"'Input Sheet'!R98","v":0},{"$f":"'Input Sheet'!S98","v":0},{"$f":"'Input Sheet'!T98","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V98","v":9.4499999999999993},{"$f":"'Input Sheet'!W98","v":0}]
[{"$f":"'Input Sheet'!C99","v":633019},{"$f":"'Input Sheet'!D99","v":2015},{"$f":"'Input Sheet'!E99","v":"ENCLAVE"},{"$f":"'Input Sheet'!F99","v":39354},{"$f":"'Input Sheet'!G99","v":0},{"$f":"'Input Sheet'!H99","v":0},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L99","v":16.57},{"$f":"'Input Sheet'!M99","v":0.4},{"$f":"'Input Sheet'!N99","v":2781},{"$f":"'Input Sheet'!O99","v":12.5},5,{"$f":"'Input Sheet'!Q99","v":0},{"$f":"'Input Sheet'!R99","v":0},{"$f":"'Input Sheet'!S99","v":0},{"$f":"'Input Sheet'!T99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V99","v":5},{"$f":"'Input Sheet'!W99","v":1}]
[{"$f":"'Input Sheet'!C100","v":633021},{"$f":"'Input Sheet'!D100","v":2017},{"$f":"'Input Sheet'!E100","v":"TAHOE"},{"$f":"'Input Sheet'!F100","v":7329},{"$f":"'Input Sheet'!G100","v":0},{"$f":"'Input Sheet'!H100","v":0},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L100","v":26.52},{"$f":"'Input Sheet'!M100","v":0.7},{"$f":"'Input Sheet'!N100","v":2762},{"$f":"'Input Sheet'!O100","v":12.5},8.75,{"$f":"'Input Sheet'!Q100","v":0},{"$f":"'Input Sheet'!R100","v":0},{"$f":"'Input Sheet'!S100","v":0},{"$f":"'Input Sheet'!T100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V100","v":8.75},{"$f":"'Input Sheet'!W100","v":0}]
[{"$f":"'Input Sheet'!C101","v":633022},{"$f":"'Input Sheet'!D101","v":2016},{"$f":"'Input Sheet'!E101","v":"ENCORE"},{"$f":"'Input Sheet'!F101","v":16176},{"$f":"'Input Sheet'!G101","v":0},{"$f":"'Input Sheet'!H101","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L101","v":26.52},{"$f":"'Input Sheet'!M101","v":0.7},{"$f":"'Input Sheet'!N101","v":2678},{"$f":"'Input Sheet'!O101","v":12.5},8.75,{"$f":"'Input Sheet'!Q101","v":0},{"$f":"'Input Sheet'!R101","v":0},{"$f":"'Input Sheet'!S101","v":0},{"$f":"'Input Sheet'!T101","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V101","v":8.75},{"$f":"'Input Sheet'!W101","v":0}]
[{"$f":"'Input Sheet'!C102","v":633024},{"$f":"'Input Sheet'!D102","v":2013},{"$f":"'Input Sheet'!E102","v":"LACROSSE"},{"$f":"'Input Sheet'!F102","v":80933},{"$f":"'Input Sheet'!G102","v":0},{"$f":"'Input Sheet'!H102","v":0},{"$f":"'Input Sheet'!I102","v":0},{"$f":"'Input Sheet'!J102","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L102","v":46.52},{"$f":"'Input Sheet'!M102","v":1},{"$f":"'Input Sheet'!N102","v":2762},{"$f":"'Input Sheet'!O102","v":12.5},12.5,{"$f":"'Input Sheet'!Q102","v":1852.6},{"$f":"'Input Sheet'!R102","v":15.7},{"$f":"'Input Sheet'!S102","v":61},{"$f":"'Input Sheet'!T102","v":34},533.79999999999995,{"$f":"'Input Sheet'!V102","v":546.29999999999995},{"$f":"'Input Sheet'!W102","v":0}]
[{"$f":"'Input Sheet'!C103","v":633028},{"$f":"'Input Sheet'!D103","v":2016},{"$f":"'Input Sheet'!E103","v":"SIERRA"},{"$f":"'Input Sheet'!F103","v":20646},{"$f":"'Input Sheet'!G103","v":0},{"$f":"'Input Sheet'!H103","v":0},{"$f":"'Input Sheet'!I103","v":0},{"$f":"'Input Sheet'!J103","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L103","v":26.52},{"$f":"'Input Sheet'!M103","v":0.7},{"$f":"'Input Sheet'!N103","v":2768},{"$f":"'Input Sheet'!O103","v":12.5},8.75,{"$f":"'Input Sheet'!Q103","v":0},{"$f":"'Input Sheet'!R103","v":0},{"$f":"'Input Sheet'!S103","v":0},{"$f":"'Input Sheet'!T103","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V103","v":8.75},{"$f":"'Input Sheet'!W103","v":0}]
[{"$f":"'Input Sheet'!C104","v":633029},{"$f":"'Input Sheet'!D104","v":2017},{"$f":"'Input Sheet'!E104","v":"YUKON"},{"$f":"'Input Sheet'!F104","v":13642},{"$f":"'Input Sheet'!G104","v":0},{"$f":"'Input Sheet'!H104","v":0},{"$f":"'Input Sheet'!I104","v":0},{"$f":"'Input Sheet'!J104","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L104","v":24.57},{"$f":"'Input Sheet'!M104","v":0.7},{"$f":"'Input Sheet'!N104","v":2781},{"$f":"'Input Sheet'!O104","v":12.5},8.75,{"$f":"'Input Sheet'!Q104","v":0},{"$f":"'Input Sheet'!R104","v":0},{"$f":"'Input Sheet'!S104","v":0},{"$f":"'Input Sheet'!T104","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V104","v":8.75},{"$f":"'Input Sheet'!W104","v":0}]
[{"$f":"'Input Sheet'!C105","v":633035},{"$f":"'Input Sheet'!D105","v":2004},{"$f":"'Input Sheet'!E105","v":"IMPALA"},{"$f":"'Input Sheet'!F105","v":27046},{"$f":"'Input Sheet'!G105","v":0},{"$f":"'Input Sheet'!H105","v":0},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L105","v":0},{"$f":"'Input Sheet'!M105","v":0},{"$f":"'Input Sheet'!N105","v":0},{"$f":"'Input Sheet'!O105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q105","v":236},{"$f":"'Input Sheet'!R105","v":2},{"$f":"'Input Sheet'!S105","v":2331},{"$f":"'Input Sheet'!T105","v":19},38,{"$f":"'Input Sheet'!V105","v":38},{"$f":"'Input Sheet'!W105","v":1}]
["RO's 51-100",null,null,"Totals",{"$f":"SUM(E6:E55)","v":767.05},{"$f":"SUM(F6:F55)","v":9.8000000000000007},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J6:J55)","v":999.7},{"$f":"SUM(K6:K55)","v":25.599999999999987},null,null,{"$f":"SUM(N6:N55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O6:O55)","v":5290.12},{"$f":"SUM(P6:P55)","v":44.2},null,null,{"$f":"SUM(S6:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T6:T55)","v":1907.8999999999999},{"$f":"COUNTIF(U5:U55,1)","v":18}]
["Date of Study:",null,null,null,"C Labor",null,null,null,null,"M Labor",null,null,null,null,"R Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["Study Compiled by",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]

{"sheet":"Summary Report","index":5,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,2,9,3],[0,2,0,10],[2,6,3,6],[2,4,3,5],[3,9,3,10],[1,2,1,10],[11,2,11,9],[15,2,15,9],[25,4,25,5],[25,7,25,8],[24,2,24,9],[26,11,27,11],[26,7,26,8],[28,2,28,10],[26,4,26,5],[27,4,27,5],[27,7,27,8]]}
[null,null,"Repair Order Analysis Summary Report "]
[]
[null,null,null,null,"Sales in Dollars",null,"FRH's on RO's"]
[null,null,null,null,null,null,null,null,"Averages","Analysis"]
[null,null,"Competitive",null,{"$f":"'RO Report 1-50'!E56+'RO Report 51-100'!E56","v":2729.6400000000003},"÷",{"$f":"'RO Report 1-50'!F56+'RO Report 51-100'!F56","v":30.2},"=",{"$f":"IF(ISERROR(E5/G5),\"\",E5/G5)","v":90.385430463576171},"FRH Average"]
[null,null,"Maintenance",null,{"$f":"'RO Report 1-50'!J56+'RO Report 51-100'!J56","v":2368.0999999999995},"÷",{"$f":"'RO Report 1-50'!K56+'RO Report 51-100'!K56","v":53.299999999999969},"=",{"$f":"IF(ISERROR(E6/G6),\"\",E6/G6)","v":44.429643527204519},"FRH Average"]
[null,null,"Repair",null,{"$f":"'RO Report 1-50'!O56+'RO Report 51-100'!O56","v":8078.06},"÷",{"$f":"'RO Report 1-50'!P56+'RO Report 51-100'!P56","v":67.7},"=",{"$f":"IF(ISERROR(E7/G7),\"\",E7/G7)","v":119.32141802067947},"FRH Average"]
[null,null,"Totals",null,{"$f":"SUM(E5:E7)","v":13175.8},"÷",{"$f":"SUM(G5:G7)","v":151.19999999999999},"=",{"$f":"IF(ISERROR(E8/G8),\"\",E8/G8)","v":87.141534391534393},"Customer ELR"]
[null,null,null,null,null,null,null,"Target Labor Rate",85,"Per FRH"]
[null,null,"Total Ro's in Sample",null,100,null,null,"Difference",{"$f":"IF(ISERROR(I8-I9),\"\",I8-I9)","v":2.1415343915343925},"Per FRH"]
[]
[null,null,"Cost of Labor"]
[null,null,"Total Cost of Labor",null,{"$f":"'Input Sheet'!V106","v":3315.66},"÷","Total Sales","=",{"$f":"IF(ISERROR(E13/E8),\"\",E13/E8)","v":0.25164771778563733},"Percent Cost of Sales"]
[null,null,"Total Cost of Labor",null,{"$f":"E13","v":3315.66},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E14/G8),\"\",E14/G8)","v":21.928968253968254},"Cost per FRH"]
[]
[null,null,"Repair Order Measurements"]
[null,null,"Total Labor Sales",null,{"$f":"E8","v":13175.8},"÷","Total RO's","=",{"$f":"IF(ISERROR(E17/E10),\"\",E17/E10)","v":131.75799999999998},"Avg Labor per RO"]
[null,null,"Total FRH's",null,{"$f":"G8","v":151.19999999999999},"÷","Total RO's","=",{"$f":"IF(ISERROR(E18/E10),\"\",E18/E10)","v":1.5119999999999998},"Avg FRH's per RO"]
[null,null,"Menu Sales",null,null,"÷","Total RO's","=",null,"Percent Menu Sales"]
[null,null,"Competitive FRH's",null,{"$f":"G5","v":30.2},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E20/G8),\"\",(E20/G8))","v":0.19973544973544974},"Percent Competitive"]
[null,null,"Maintenance FRH's",null,{"$f":"G6","v":53.299999999999969},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E21/G8),\"\",(E21/G8))","v":0.35251322751322733},"Percent Maintenance "]
[null,null,"Repair FRH'",null,{"$f":"G7","v":67.7},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E22/G8),\"\",E22/G8)","v":0.44775132275132279},"Percent Repair "]
[null,null,"One item RO's",null,{"$f":"'RO Report 1-50'!U56+'RO Report 51-100'!U56","v":33},"÷","Total RO's","=",{"$f":"IF(ISERROR(E23/E10),\"\",E23/E10)","v":0.33},"Percent One Item RO"]
[]
[null,null,"Model Year Analysis"]
[null,null,{"$f":"YEAR(Title!K17)+1","v":2018},{"$f":"YEAR(Title!K17)","v":2017},{"$f":"YEAR(Title!K17)-1","v":2016},null,{"$f":"YEAR(Title!K17)-2","v":2015},{"$f":"YEAR(Title!K17)-3","v":2014},null,{"$f":"YEAR(Title!K17)-4","v":2013},"Older","Total"]
[null,null,{"$f":"COUNTIF('Input Sheet'!D6:D105,C26)","v":0},{"$f":"COUNTIF('Input Sheet'!D6:D105,D26)","v":5},{"$f":"COUNTIF('Input Sheet'!D6:D105,E26)","v":18},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,G26)","v":18},{"$f":"COUNTIF('Input Sheet'!D6:D105,H26)","v":11},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,J26)","v":6},{"$f":"L27-(SUM(C27:J27))","v":42},{"$f":"DCOUNTA('Input Sheet'!C4:F105,\"Year\",'Input Sheet'!D4:D105)","v":100}]
[null,null,{"$f":"IF(ISERROR(C27/L27),\"\",C27/L27)","v":0},{"$f":"IF(ISERROR(D27/L27),\"\",D27/L27)","v":0.05},{"$f":"IF(ISERROR(E27/L27),\"\",E27/L27)","v":0.18},null,{"$f":"IF(ISERROR(G27/L27),\"\",G27/L27)","v":0.18},{"$f":"IF(ISERROR(H27/L27),\"\",H27/L27)","v":0.11},null,{"$f":"IF(ISERROR(J27/L27),\"\",J27/L27)","v":0.06},{"$f":"IF(ISERROR(K27/L27),\"\",K27/L27)","v":0.42}]