{"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-09-05"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Simi Valley Buick GMC"]
["Dealership "]
[]
["Josh Isbell"]
["Student "]
[]
["N324  /  03"]
["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":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"Tech #","Tech Pay Per FRH"]
[null,710,25]
[null,716,21]
[null,717,26]
[null,735,32]
[null,743,21]
[null,753,15.5,"          "]
[null,769,11.5]
[null,770,21]
[null,773,30]
[null,757,14]

{"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,150745,2011,"lacrosse",68808,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I6,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I6,TechNumber,2,FALSE))","v":15.5},{"$f":"IF(ISERROR(H6*J6),\"\",H6*J6)","v":9.2999999999999989},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!#REF!,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!#REF!,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(#REF!*O6),\" \",#REF!*O6)","v":" "},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":9.2999999999999989},1]
[null,2,150747,2013,"sierra",57642,32.950000000000003,0.6,753,15.5,{"$f":"IF(ISERROR(H7*J7),\" \",H7*J7)","v":9.2999999999999989},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S7,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S7,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U7,K7,)","v":9.2999999999999989},1]
[null,3,150753,2003,"envoy",195234,22.85,0.6,753,15.5,{"$f":"IF(ISERROR(H8*J8),\" \",H8*J8)","v":9.2999999999999989},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U8,K8,)","v":9.2999999999999989},1]
[null,4,150756,2016,"terrain",13866,22.85,0.6,753,15.5,{"$f":"IF(ISERROR(H9*J9),\" \",H9*J9)","v":9.2999999999999989},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U9,K9,)","v":9.2999999999999989},1]
[null,5,150599,2009,"acadia",122461,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":""},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N10,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N10,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(M10*O10),\" \",M10*O10)","v":" "},260,2,735,32,64,{"$f":"SUM(U10,P10,K10)","v":64},1]
[null,6,150603,2012,"acadia",36209,22.85,0.6,716,21,{"$f":"IF(ISERROR(H11*J11),\" \",H11*J11)","v":12.6},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S11,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S11,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U11,K11)","v":12.6},1]
[null,7,150612,2016,"yukon",21875,22.85,0.6,717,26,{"$f":"IF(ISERROR(H12*J12),\" \",H12*J12)","v":15.6},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U12,K12,)","v":15.6},1]
[null,8,150615,2016,"canyon",22702,32.950000000000003,0.6,716,21,{"$f":"IF(ISERROR(H13*J13),\" \",H13*J13)","v":12.6},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U13,K13,)","v":12.6},1]
[null,9,150626,2016,"yukon",21258,22.85,0.6,743,21,{"$f":"IF(ISERROR(H14*J14),\" \",H14*J14)","v":12.6},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U14,K14)","v":12.6},1]
[null,10,150631,2011,"lacrosse",87727,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H15*J15),\"\",H15*J15)","v":""},217.85,2.1,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N15,TechNumber,2,FALSE))","v":26},{"$f":"IF(ISERROR(M15*O15),\"\",M15*O15)","v":54.6},null,null,null,null,null,{"$f":"SUM(P15,K15)","v":54.6},2]
[null,11,150635,2013,"verano",16172,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N16,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,12,150601,2007,"yukon",169149,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE))","v":""}," ",559,4.3,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S17,TechNumber,2,FALSE))","v":32},{"$f":"IF(ISERROR(R17*T17),\"\",R17*T17)","v":137.6},{"$f":"SUM(P17,U17)","v":137.6},1]
[null,13,150648,2014,"sierra",75207,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N18,TechNumber,2,FALSE))","v":""}," ",152.85,1.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE))","v":15.5},24.8,24.8,2]
[null,14,150649,2015,"yukon xl",42330,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N19,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,15,150653,2007,"yukon",47031,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE))","v":""},"",118.1,0.4,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N20,TechNumber,2,FALSE))","v":26},10.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE))","v":""},"",10.4,2]
[null,16,150667,2008,"lacrosse",53223,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N21,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S21,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U21,P21,K21)","v":9.2999999999999989},1]
[null,17,150684,2015,"acadia",40511,22.85,0.6,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE))","v":26},15.6,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N22,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S22,TechNumber,2,FALSE))","v":""},"",15.6,1]
[null,18,150669,2002,"lesabre",100000,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N23,TechNumber,2,FALSE))","v":""}," ",334.85,3,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE))","v":15.5},46.5,46.5,3]
[null,19,150691,2012,"verano",25085,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N24,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S24,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,20,150703,2007,"ion",66314,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N25,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S25,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,21,150706,2015,"yukon xl",47906,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N26,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,22,150629,2010,"tahoe",108447,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N27,TechNumber,2,FALSE))","v":""}," ",585,4.5,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE))","v":21},94.5,94.5,2]
[null,23,150700,2004,"yukon",133816,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I28,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N28,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,24,150714,2015,"sierra 2500",32953,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE))","v":""},"",147.94999999999999,2.6,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N29,TechNumber,2,FALSE))","v":21},54.6,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE))","v":""},"",54.6,2]
[null,25,150726,2015,"terrain",44895,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE))","v":""},"",69.98,1,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N30,TechNumber,2,FALSE))","v":21},21,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE))","v":""},"",21,1]
[null,26,150657,2011,"sierra 2500",89668,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N31,TechNumber,2,FALSE))","v":""}," ",201.9,2.1,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE))","v":15.5},32.550000000000004,32.550000000000004,3]
[null,27,150668,2009,"sierra",138570,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N32,TechNumber,2,FALSE))","v":""}," ",347.85,3.1,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE))","v":21},65.100000000000009,65.100000000000009,3]
[null,28,150733,2011,"acadia",97540,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I33,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N33,TechNumber,2,FALSE))","v":""}," ",182,1.4,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE))","v":21},29.4,29.4,1]
[null,29,150744,2016,"sierra",23304,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N34,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S34,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,30,150746,2002,"sierra",48805,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N35,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,31,150751,2015,"acadia",28585,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N36,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,32,150755,2013,"escalade",51530,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N37,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,33,150758,2015,"verano",38428,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N38,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S38,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,34,150760,2009,"sierra",23230,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I39,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S39,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,35,150763,2016,"emcore",16509,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S40,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,36,150764,2009,"yukon",135281,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I41,TechNumber,2,FALSE))","v":""},"",282.85000000000002,2.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N41,TechNumber,2,FALSE))","v":15.5},40.300000000000004,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S41,TechNumber,2,FALSE))","v":""},"",40.300000000000004,2]
[null,37,150775,2015,"yukon xl",29452,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE))","v":""},"",260,2,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N42,TechNumber,2,FALSE))","v":26},52,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE))","v":""},"",52,1]
[null,38,150771,2004,"sierra 2500",83059,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N43,TechNumber,2,FALSE))","v":""}," ",438.85,3.8,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE))","v":15.5},58.9,58.9,3]
[null,39,150778,2015,"sierra",67885,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N44,TechNumber,2,FALSE))","v":""}," ",130,1,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE))","v":32},32,32,1]
[null,40,150818,2013,"cts",33936,37.950000000000003,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N45,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,41,150824,2003,"rendezvous",67918,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE))","v":""},"",152.85,1.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE))","v":15.5},24.8,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S46,TechNumber,2,FALSE))","v":""},"",24.8,2]
[null,42,150837,2013,"lacrosse",23705,62.5,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N47,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,43,150840,2012,"yukon",60278,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I48,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N48,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,44,150795,2001,"sierra",252286,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N49,TechNumber,2,FALSE))","v":""}," ",234,1.8,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE))","v":32},57.6,57.6,1]
[null,45,150835,2007,"hhr",57059,12.6,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S50,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,46,150842,2015,"acadia",19997,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N51,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,47,150844,2015,"terrain",71988,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE))","v":""},"",118.1,1.6,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE))","v":26},41.6,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S52,TechNumber,2,FALSE))","v":""},"",41.6,2]
[null,48,150847,2016,"yukon",24025,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N53,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S53,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,49,150854,2012,"sierra",58312,22.85,0.6,753,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE))","v":15.5},9.2999999999999989,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N54,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE))","v":""},"",9.2999999999999989,1]
[null,50,150850,1996,"sierra 3500",151130,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N55,TechNumber,2,FALSE))","v":""}," ",15521.83,20.6,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S55,TechNumber,2,FALSE))","v":32},659.2,700,3]
[null,51,151870,2001,"corvette",82756,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N56,TechNumber,2,FALSE))","v":""}," ",74.849999999999994,0.8,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE))","v":32},25.6,28,3]
[null,52,"152414*",2014,"sierra 1500",54400,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I57,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE))","v":""}," ",2054.64,2.7,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S57,TechNumber,2,FALSE))","v":32},86.4,94.5,4]
[null,53,152548,2006,"yukon xl",179745,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":""}," ",1066.18,6.5,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S58,TechNumber,2,FALSE))","v":32},208,227.5,4]
[null,54,152555,2007,"Hummer H3",113405,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I59,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N59,TechNumber,2,FALSE))","v":""}," ",1188.8800000000001,8.1,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE))","v":21},170.1,157.5,4]
[null,55,152677,2014,"Camaro",61516,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE))","v":""},"",182.08,1.6,743,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N60,TechNumber,2,FALSE))","v":21},33.6,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE))","v":""},"",182.08,3]
[null,56,152736,2012,"Yukon XL",78856,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N61,TechNumber,2,FALSE))","v":""}," ",1286.96,5.6,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE))","v":32},179.2,196,4]
[null,57,152745,2005,"Yukon ",149595,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N62,TechNumber,2,FALSE))","v":""}," ",1450.79,1.5,770,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE))","v":21},31.5,195,1]
[null,58,152770,2016,"Canyon",17468,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N63,TechNumber,2,FALSE))","v":""}," ",920.32,6.6,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE))","v":26},171.6,156,1]
[null,59,152790,2001,"Safari",225023,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE))","v":""},"",591.71,2,773,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N64,TechNumber,2,FALSE))","v":30},60,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE))","v":""},"",60,2]
[null,60,152791,2003,"Yukon XL",151524,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I65,TechNumber,2,FALSE))","v":""},"",152.69999999999999,1.8,710,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N65,TechNumber,2,FALSE))","v":25},45,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE))","v":""},"",30,3]
[null,61,152792,2015,"Sierra 2500HD",30771,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE))","v":""},"",583.94000000000005,2.9,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N66,TechNumber,2,FALSE))","v":26},75.399999999999991,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE))","v":""},"",110.4,4]
[null,62,152804,2015,"Sierra 2500HD",58450,452.03,1.8,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N67,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE))","v":""},"",162.94999999999999,2]
[null,63,152823,2008,"PT Cruiser",67576,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N68,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,64,152889,2014,"Sierra 2500HD",22662,284.45999999999998,1.4,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N69,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE))","v":""},"",147.94999999999999,1]
[null,65,152894,2015,"Yukon ",49725,22.85,0.6,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":""},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N70,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N70,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(M70*O70),\" \",M70*O70)","v":" "},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":""},12.6,1]
[null,66,152898,2016,"Acadia",32512,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N71,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,67,152899,2015,"Acadia",47402,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE))","v":""},"",130,0.1,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N72,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE))","v":""},"",13,1]
[null,68,152902,2003,"Yukon XL",204593,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N73,TechNumber,2,FALSE))","v":""}," ",130,1,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE))","v":32},32,35,1]
[null,69,152912,2014,"sierra 1500",81315,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N74,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S74,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,70,152922,2014,"Sierra 1500",30702,292.77999999999997,1.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I75,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N75,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE))","v":""},"",15.6,1]
[null,71,152947,2012,"Yukon",64328,393.34,1.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I76,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N76,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S76,TechNumber,2,FALSE))","v":""},"",15.6,1]
[null,72,152949,2016,"Yukon XL",32916,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N77,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,73,152950,2009,"Colorado",92056,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N78,TechNumber,2,FALSE))","v":""}," ",195,1.5,735,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S78,TechNumber,2,FALSE))","v":32},48,35,1]
[null,74,152951,2012,"Town & Country",75979,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N79,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,75,152963,2014,"Acadia",55821,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I80,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I80,TechNumber,2,FALSE))","v":""},"",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":""},"",12.6,1]
[null,76,152973,2015,"sierra 1500",37437,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE))","v":""},"",112,0.3,773,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N81,TechNumber,2,FALSE))","v":30},9,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE))","v":""},"",6,1]
[null,77,152982,2011,"Acadia",115834,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE))","v":""},"",155.21,1.1000000000000001,782,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N82,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S82,TechNumber,2,FALSE))","v":""},"",87.85,2]
[null,78,152983,2011,"Acadia ",146372,22.85,0.6,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":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S83,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,79,152995,2009,"Sierra 2500HD",62770,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE))","v":""},"",424.06,3.3,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N84,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE))","v":""},"",80.5,2]
[null,80,153009,2015,"Sierra 3500",24464,29.95,0.3,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I85,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N85,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE))","v":""},"",42.05,1]
[null,81,153010,2011,"Terrain",80389,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N86,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,82,153012,2016,"Sierra 2500HD",92526,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE))","v":""},"",209.14,0.9,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N87,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE))","v":""},"",94.95,1]
[null,83,153013,2015,"Sierra 2500HD",42431,121.6,0.9,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N88,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE))","v":""},"",32.950000000000003,1]
[null,84,153032,2015,"Yukon XL",55352,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I89,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N89,TechNumber,2,FALSE))","v":""}," ",653.28,2.5,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE))","v":""},"",78,1]
[null,85,153040,2013,"Cruze",71780,631.04999999999995,1,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N90,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE))","v":""},"",95,1]
[null,86,153057,2005,"Silverado 2500",197835,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N91,TechNumber,2,FALSE))","v":""}," ",599.66,2.8,773,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S91,TechNumber,2,FALSE))","v":30},84,45,2]
[null,87,153060,2015,"Sierra 2500HD",63478,360.43,1.8,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N92,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE))","v":""},"",46.8,2]
[null,88,153061,2015,"Sierra 2500HD",63574,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE))","v":""},"",939.91,2,717,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N93,TechNumber,2,FALSE))","v":26},52,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE))","v":""},"",52,3]
[null,89,153066,2015,"Sierra 1500",25120,224.28,1.2,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I94,TechNumber,2,FALSE))","v":""},"",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":""},"",87.85,2]
[null,90,153069,2011,"Yukon XL",62393,198.71,1,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N95,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE))","v":""},"",26,1]
[null,91,153079,2012,"Cruze",150476,794.11,1,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N96,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE))","v":""},"",95,1]
[null,92,153080,2013,"Suburban",84433,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE))","v":""},"",230.91,1.2,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N97,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE))","v":""},"",25.2,2]
[null,93,153081,2005,"Yukon",198796,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N98,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE))","v":""},"",133,2]
[null,94,153089,2012,"Acadia",97424,287.2,1.3,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N99,TechNumber,2,FALSE))","v":""}," ",622.70000000000005,1.6,773,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE))","v":30},48,"30,00",1]
[null,95,153095,2007,"Sierra 1500",104414,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N100,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,96,153128,2007,"Envoy",113072,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE))","v":""},"",220.73,1.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N101,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE))","v":""},"",76,2]
[null,97,153131,2011,"Acadia",100097,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE))","v":""},"",543.80999999999995,2.6,757,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N102,TechNumber,2,FALSE))","v":14},36.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S102,TechNumber,2,FALSE))","v":""},"",70,2]
[null,98,153141,2014,"Equinox",71379,112.95,1,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N103,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE))","v":""},"",35,1]
[null,99,153152,2014,"Terrain",7101,22.85,0.6,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N104,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S104,TechNumber,2,FALSE))","v":""},"",12.6,1]
[null,100,153156,2003,"Sierra 1500",18170,22.85,0.6,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":" "},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S105,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S105,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(R105*T105),\"\",R105*T105)","v":""},12.6,1]
[null,null,null,null,"Totals","Totals",{"$f":"SUM(G6:G105)","v":5207.29},{"$f":"SUM(H6:H105)","v":41.100000000000016},null,null,{"$f":"SUM(K6:K105)","v":301.50000000000017},{"$f":"SUM(L6:L105)","v":5843.8799999999992},{"$f":"SUM(M6:M105)","v":35.300000000000004},null,null,610.70000000000005,29191.39,90.399999999999977,null,null,2386.5500000000002,5166.1799999999994,{"$f":"COUNTIF(W5:W105,1)","v":67}]
[null,null,null,null,"Number of RO's in Sample",null,"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":23,"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":150745},{"$f":"'Input Sheet'!D6","v":2011},{"$f":"'Input Sheet'!E6","v":"lacrosse"},{"$f":"'Input Sheet'!F6","v":68808},{"$f":"'Input Sheet'!G6","v":22.85},{"$f":"'Input Sheet'!H6","v":0.6},{"$f":"'Input Sheet'!I6","v":753},{"$f":"'Input Sheet'!J6","v":15.5},{"$f":"F6*H6","v":9.2999999999999989},0,0,{"$f":"'Input Sheet'!I6","v":753},{"$f":"'Input Sheet'!J6","v":15.5},{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W6","v":1}]
[{"$f":"'Input Sheet'!C7","v":150747},{"$f":"'Input Sheet'!D7","v":2013},{"$f":"'Input Sheet'!E7","v":"sierra"},{"$f":"'Input Sheet'!F7","v":57642},{"$f":"'Input Sheet'!G7","v":32.950000000000003},{"$f":"'Input Sheet'!H6","v":0.6},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"F7*H7","v":{"$error":"#REF!"}},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"K7*M7","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!Q7","v":0},{"$f":"'Input Sheet'!R7","v":0},{"$f":"'Input Sheet'!S7","v":0},{"$f":"'Input Sheet'!T7","v":""},{"$f":"P7*R7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V7","v":9.2999999999999989},{"$f":"'Input Sheet'!W7","v":1}]
[{"$f":"'Input Sheet'!C8","v":150753},{"$f":"'Input Sheet'!D8","v":2003},{"$f":"'Input Sheet'!E8","v":"envoy"},{"$f":"'Input Sheet'!F8","v":195234},{"$f":"'Input Sheet'!G8","v":22.85},{"$f":"'Input Sheet'!H7","v":0.6},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W8","v":1}]
[{"$f":"'Input Sheet'!C9","v":150756},{"$f":"'Input Sheet'!D9","v":2016},{"$f":"'Input Sheet'!E9","v":"terrain"},{"$f":"'Input Sheet'!F9","v":13866},{"$f":"'Input Sheet'!G9","v":22.85},{"$f":"'Input Sheet'!H8","v":0.6},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W9","v":1}]
[{"$f":"'Input Sheet'!C10","v":150599},{"$f":"'Input Sheet'!D10","v":2009},{"$f":"'Input Sheet'!E10","v":"acadia"},{"$f":"'Input Sheet'!F10","v":122461},{"$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":0},{"$f":"'Input Sheet'!M10","v":0},{"$f":"'Input Sheet'!I10","v":0},{"$f":"'Input Sheet'!J10","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q10","v":260},{"$f":"'Input Sheet'!R10","v":2},{"$f":"'Input Sheet'!S10","v":735},{"$f":"'Input Sheet'!T10","v":32},64,{"$f":"'Input Sheet'!V10","v":64},{"$f":"'Input Sheet'!W10","v":1}]
[{"$f":"'Input Sheet'!C11","v":150603},{"$f":"'Input Sheet'!D11","v":2012},{"$f":"'Input Sheet'!E11","v":"acadia"},{"$f":"'Input Sheet'!F11","v":36209},{"$f":"'Input Sheet'!G11","v":22.85},{"$f":"'Input Sheet'!H10","v":0},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'Input Sheet'!Q11","v":0},{"$f":"'Input Sheet'!R11","v":0},{"$f":"'Input Sheet'!S11","v":0},{"$f":"'Input Sheet'!T11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V11","v":12.6},{"$f":"'Input Sheet'!W11","v":1},null," "]
[{"$f":"'Input Sheet'!C12","v":150612},{"$f":"'Input Sheet'!D12","v":2016},{"$f":"'Input Sheet'!E12","v":"yukon"},{"$f":"'Input Sheet'!F12","v":21875},{"$f":"'Input Sheet'!G12","v":22.85},{"$f":"'Input Sheet'!R11","v":0},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$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":15.6},{"$f":"'Input Sheet'!W12","v":1}]
[{"$f":"'Input Sheet'!C13","v":150615},{"$f":"'Input Sheet'!D13","v":2016},{"$f":"'Input Sheet'!E13","v":"canyon"},{"$f":"'Input Sheet'!F13","v":22702},{"$f":"'Input Sheet'!G13","v":32.950000000000003},{"$f":"'Input Sheet'!R12","v":0},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$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":12.6},{"$f":"'Input Sheet'!W13","v":1}]
[{"$f":"'Input Sheet'!C14","v":150626},{"$f":"'Input Sheet'!D14","v":2016},{"$f":"'Input Sheet'!E14","v":"yukon"},{"$f":"'Input Sheet'!F14","v":21258},{"$f":"'Input Sheet'!G14","v":22.85},{"$f":"'Input Sheet'!H15","v":0},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},0,0,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$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":12.6},{"$f":"'Input Sheet'!W14","v":1}]
[{"$f":"'Input Sheet'!C15","v":150631},{"$f":"'Input Sheet'!D15","v":2011},{"$f":"'Input Sheet'!E15","v":"lacrosse"},{"$f":"'Input Sheet'!F15","v":87727},{"$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!"},217.85,2.1,{"$f":"'Input Sheet'!I15","v":0},{"$f":"'Input Sheet'!J15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L15","v":217.85},{"$f":"'Input Sheet'!M15","v":2.1},{"$f":"'Input Sheet'!N15","v":717},{"$f":"'Input Sheet'!O15","v":26},54.6,{"$f":"'Input Sheet'!V15","v":54.6},{"$f":"'Input Sheet'!W15","v":2}]
[{"$f":"'Input Sheet'!C16","v":150635},{"$f":"'Input Sheet'!D16","v":2013},{"$f":"'Input Sheet'!E16","v":"verano"},{"$f":"'Input Sheet'!F16","v":16172},{"$f":"'Input Sheet'!G16","v":22.85},{"$f":"'Input Sheet'!H16","v":0.6},{"$f":"'Input Sheet'!I16","v":753},{"$f":"'Input Sheet'!J16","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L16","v":0},{"$f":"'Input Sheet'!M16","v":0},{"$f":"'Input Sheet'!I16","v":753},{"$f":"'Input Sheet'!J16","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W16","v":1}]
[150601,{"$f":"'Input Sheet'!D17","v":2007},{"$f":"'Input Sheet'!E17","v":"yukon"},{"$f":"'Input Sheet'!F17","v":169149},{"$f":"'Input Sheet'!Q17","v":559},{"$f":"'Input Sheet'!R17","v":4.3},{"$f":"'Input Sheet'!S17","v":735},{"$f":"'Input Sheet'!T17","v":32},137.6,{"$f":"'Input Sheet'!L17","v":0},{"$f":"'Input Sheet'!M17","v":0},{"$f":"'Input Sheet'!S17","v":735},{"$f":"'Input Sheet'!T17","v":32},0,559,4.9000000000000004,{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"'Input Sheet'!V17","v":137.6},{"$f":"'Input Sheet'!W17","v":1}]
[{"$f":"'Input Sheet'!C18","v":150648},{"$f":"'Input Sheet'!D18","v":2014},{"$f":"'Input Sheet'!E18","v":"sierra"},{"$f":"'Input Sheet'!F18","v":75207},{"$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":0},{"$f":"'Input Sheet'!M18","v":0},{"$f":"'Input Sheet'!I18","v":0},{"$f":"'Input Sheet'!J18","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q18","v":152.85},{"$f":"'Input Sheet'!R18","v":1.6},{"$f":"'Input Sheet'!S18","v":753},{"$f":"'Input Sheet'!T18","v":15.5},24.8,{"$f":"'Input Sheet'!V18","v":24.8},{"$f":"'Input Sheet'!W18","v":2}]
[{"$f":"'Input Sheet'!C19","v":150649},{"$f":"'Input Sheet'!D19","v":2015},{"$f":"'Input Sheet'!E19","v":"yukon xl"},{"$f":"'Input Sheet'!F19","v":42330},{"$f":"'Input Sheet'!G19","v":22.85},{"$f":"'Input Sheet'!H19","v":0.6},{"$f":"'Input Sheet'!I19","v":753},{"$f":"'Input Sheet'!J19","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L19","v":0},{"$f":"'Input Sheet'!M19","v":0},{"$f":"'Input Sheet'!I19","v":753},{"$f":"'Input Sheet'!J19","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W19","v":1}]
[{"$f":"'Input Sheet'!C20","v":150653},{"$f":"'Input Sheet'!D20","v":2007},{"$f":"'Input Sheet'!E20","v":"yukon"},{"$f":"'Input Sheet'!F20","v":47031},{"$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":118.1},{"$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":10.4},{"$f":"'Input Sheet'!W20","v":2}]
[{"$f":"'Input Sheet'!C21","v":150667},{"$f":"'Input Sheet'!D21","v":2008},{"$f":"'Input Sheet'!E21","v":"lacrosse"},{"$f":"'Input Sheet'!F21","v":53223},{"$f":"'Input Sheet'!G21","v":22.85},{"$f":"'Input Sheet'!H21","v":0.6},{"$f":"'Input Sheet'!I21","v":753},{"$f":"'Input Sheet'!J21","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L21","v":0},{"$f":"'Input Sheet'!M21","v":0},{"$f":"'Input Sheet'!I21","v":753},{"$f":"'Input Sheet'!J21","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W21","v":1}]
[{"$f":"'Input Sheet'!C22","v":150684},{"$f":"'Input Sheet'!D22","v":2015},{"$f":"'Input Sheet'!E22","v":"acadia"},{"$f":"'Input Sheet'!F22","v":40511},{"$f":"'Input Sheet'!G22","v":22.85},{"$f":"'Input Sheet'!H22","v":0.6},{"$f":"'Input Sheet'!I22","v":717},{"$f":"'Input Sheet'!J22","v":26},15.6,{"$f":"'Input Sheet'!L22","v":0},{"$f":"'Input Sheet'!M22","v":0},{"$f":"'Input Sheet'!I22","v":717},{"$f":"'Input Sheet'!J22","v":26},0,{"$f":"'Input Sheet'!Q22","v":0},{"$f":"'Input Sheet'!R22","v":0},{"$f":"'Input Sheet'!S22","v":0},{"$f":"'Input Sheet'!T22","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V22","v":15.6},{"$f":"'Input Sheet'!W22","v":1}]
[{"$f":"'Input Sheet'!C23","v":150669},{"$f":"'Input Sheet'!D23","v":2002},{"$f":"'Input Sheet'!E23","v":"lesabre"},{"$f":"'Input Sheet'!F23","v":100000},{"$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":0},{"$f":"'Input Sheet'!M23","v":0},{"$f":"'Input Sheet'!I23","v":0},{"$f":"'Input Sheet'!J23","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q23","v":334.85},{"$f":"'Input Sheet'!R23","v":3},{"$f":"'Input Sheet'!S23","v":753},{"$f":"'Input Sheet'!T23","v":15.5},46.5,{"$f":"'Input Sheet'!V23","v":46.5},{"$f":"'Input Sheet'!W23","v":3}]
[{"$f":"'Input Sheet'!C24","v":150691},{"$f":"'Input Sheet'!D24","v":2012},{"$f":"'Input Sheet'!E24","v":"verano"},{"$f":"'Input Sheet'!F24","v":25085},{"$f":"'Input Sheet'!G24","v":22.85},{"$f":"'Input Sheet'!H24","v":0.6},{"$f":"'Input Sheet'!I24","v":753},{"$f":"'Input Sheet'!J24","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L24","v":0},{"$f":"'Input Sheet'!M24","v":0},{"$f":"'Input Sheet'!I24","v":753},{"$f":"'Input Sheet'!J24","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W24","v":1}]
[{"$f":"'Input Sheet'!C25","v":150703},{"$f":"'Input Sheet'!D25","v":2007},{"$f":"'Input Sheet'!E25","v":"ion"},{"$f":"'Input Sheet'!F25","v":66314},{"$f":"'Input Sheet'!G25","v":22.85},{"$f":"'Input Sheet'!H25","v":0.6},{"$f":"'Input Sheet'!I25","v":753},{"$f":"'Input Sheet'!J25","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L25","v":0},{"$f":"'Input Sheet'!M25","v":0},{"$f":"'Input Sheet'!I25","v":753},{"$f":"'Input Sheet'!J25","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W25","v":1}]
[{"$f":"'Input Sheet'!C26","v":150706},{"$f":"'Input Sheet'!D26","v":2015},{"$f":"'Input Sheet'!E26","v":"yukon xl"},{"$f":"'Input Sheet'!F26","v":47906},{"$f":"'Input Sheet'!G26","v":22.85},{"$f":"'Input Sheet'!H26","v":0.6},{"$f":"'Input Sheet'!I26","v":753},{"$f":"'Input Sheet'!J26","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L26","v":0},{"$f":"'Input Sheet'!M26","v":0},{"$f":"'Input Sheet'!I26","v":753},{"$f":"'Input Sheet'!J26","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W26","v":1}]
[{"$f":"'Input Sheet'!C27","v":150629},{"$f":"'Input Sheet'!D27","v":2010},{"$f":"'Input Sheet'!E27","v":"tahoe"},{"$f":"'Input Sheet'!F27","v":108447},{"$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":0},{"$f":"'Input Sheet'!M27","v":0},{"$f":"'Input Sheet'!I27","v":0},{"$f":"'Input Sheet'!J27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q27","v":585},{"$f":"'Input Sheet'!R27","v":4.5},{"$f":"'Input Sheet'!S27","v":743},{"$f":"'Input Sheet'!T27","v":21},94.5,{"$f":"'Input Sheet'!V27","v":94.5},{"$f":"'Input Sheet'!W27","v":2}]
[{"$f":"'Input Sheet'!C28","v":150700},{"$f":"'Input Sheet'!D28","v":2004},{"$f":"'Input Sheet'!E28","v":"yukon"},{"$f":"'Input Sheet'!F28","v":133816},{"$f":"'Input Sheet'!G28","v":22.85},{"$f":"'Input Sheet'!H28","v":0.6},{"$f":"'Input Sheet'!I28","v":753},{"$f":"'Input Sheet'!J28","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L28","v":0},{"$f":"'Input Sheet'!M28","v":0},{"$f":"'Input Sheet'!I28","v":753},{"$f":"'Input Sheet'!J28","v":15.5},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":9.2999999999999989},{"$f":"'Input Sheet'!W28","v":1}]
[{"$f":"'Input Sheet'!C29","v":150714},{"$f":"'Input Sheet'!D29","v":2015},{"$f":"'Input Sheet'!E29","v":"sierra 2500"},{"$f":"'Input Sheet'!F29","v":32953},{"$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":147.94999999999999},{"$f":"'Input Sheet'!M29","v":2.6},{"$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":54.6},{"$f":"'Input Sheet'!W29","v":2}]
[{"$f":"'Input Sheet'!C30","v":150726},{"$f":"'Input Sheet'!D30","v":2015},{"$f":"'Input Sheet'!E30","v":"terrain"},{"$f":"'Input Sheet'!F30","v":44895},{"$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":69.98},{"$f":"'Input Sheet'!M30","v":1},{"$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":21},{"$f":"'Input Sheet'!W30","v":1}]
[{"$f":"'Input Sheet'!C31","v":150657},{"$f":"'Input Sheet'!D31","v":2011},{"$f":"'Input Sheet'!E31","v":"sierra 2500"},{"$f":"'Input Sheet'!F31","v":89668},{"$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":0},{"$f":"'Input Sheet'!M31","v":0},{"$f":"'Input Sheet'!I31","v":0},{"$f":"'Input Sheet'!J31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q31","v":201.9},{"$f":"'Input Sheet'!R31","v":2.1},{"$f":"'Input Sheet'!S31","v":753},{"$f":"'Input Sheet'!T31","v":15.5},32.550000000000004,{"$f":"'Input Sheet'!V31","v":32.550000000000004},{"$f":"'Input Sheet'!W31","v":3}]
[{"$f":"'Input Sheet'!C32","v":150668},{"$f":"'Input Sheet'!D32","v":2009},{"$f":"'Input Sheet'!E32","v":"sierra"},{"$f":"'Input Sheet'!F32","v":138570},{"$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":0},{"$f":"'Input Sheet'!M32","v":0},{"$f":"'Input Sheet'!I32","v":0},{"$f":"'Input Sheet'!J32","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q32","v":347.85},{"$f":"'Input Sheet'!R32","v":3.1},{"$f":"'Input Sheet'!S32","v":743},{"$f":"'Input Sheet'!T32","v":21},65.100000000000009,{"$f":"'Input Sheet'!V32","v":65.100000000000009},{"$f":"'Input Sheet'!W32","v":3}]
[{"$f":"'Input Sheet'!C33","v":150733},{"$f":"'Input Sheet'!D33","v":2011},{"$f":"'Input Sheet'!E33","v":"acadia"},{"$f":"'Input Sheet'!F33","v":97540},{"$f":"'Input Sheet'!G33","v":0},{"$f":"'Input Sheet'!H33","v":0},{"$f":"'Input Sheet'!I33","v":0},{"$f":"'Input Sheet'!J33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L33","v":0},{"$f":"'Input Sheet'!M33","v":0},{"$f":"'Input Sheet'!I33","v":0},{"$f":"'Input Sheet'!J33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q33","v":182},{"$f":"'Input Sheet'!R33","v":1.4},{"$f":"'Input Sheet'!S33","v":743},{"$f":"'Input Sheet'!T33","v":21},29.4,{"$f":"'Input Sheet'!V33","v":29.4},{"$f":"'Input Sheet'!W33","v":1}]
[{"$f":"'Input Sheet'!C34","v":150744},{"$f":"'Input Sheet'!D34","v":2016},{"$f":"'Input Sheet'!E34","v":"sierra"},{"$f":"'Input Sheet'!F34","v":23304},{"$f":"'Input Sheet'!G34","v":22.85},{"$f":"'Input Sheet'!H34","v":0.6},{"$f":"'Input Sheet'!I34","v":753},{"$f":"'Input Sheet'!J34","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L34","v":0},{"$f":"'Input Sheet'!M34","v":0},{"$f":"'Input Sheet'!I34","v":753},{"$f":"'Input Sheet'!J34","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W34","v":1}]
[{"$f":"'Input Sheet'!C35","v":150746},{"$f":"'Input Sheet'!D35","v":2002},{"$f":"'Input Sheet'!E35","v":"sierra"},{"$f":"'Input Sheet'!F35","v":48805},{"$f":"'Input Sheet'!G35","v":22.85},{"$f":"'Input Sheet'!H35","v":0.6},{"$f":"'Input Sheet'!I35","v":753},{"$f":"'Input Sheet'!J35","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L35","v":0},{"$f":"'Input Sheet'!M35","v":0},{"$f":"'Input Sheet'!I35","v":753},{"$f":"'Input Sheet'!J35","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W35","v":1}]
[{"$f":"'Input Sheet'!C36","v":150751},{"$f":"'Input Sheet'!D36","v":2015},{"$f":"'Input Sheet'!E36","v":"acadia"},{"$f":"'Input Sheet'!F36","v":28585},{"$f":"'Input Sheet'!G36","v":22.85},{"$f":"'Input Sheet'!H36","v":0.6},{"$f":"'Input Sheet'!I36","v":753},{"$f":"'Input Sheet'!J36","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L36","v":0},{"$f":"'Input Sheet'!M36","v":0},{"$f":"'Input Sheet'!I36","v":753},{"$f":"'Input Sheet'!J36","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W36","v":1}]
[{"$f":"'Input Sheet'!C37","v":150755},{"$f":"'Input Sheet'!D37","v":2013},{"$f":"'Input Sheet'!E37","v":"escalade"},{"$f":"'Input Sheet'!F37","v":51530},{"$f":"'Input Sheet'!G37","v":22.85},{"$f":"'Input Sheet'!H37","v":0.6},{"$f":"'Input Sheet'!I37","v":753},{"$f":"'Input Sheet'!J37","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L37","v":0},{"$f":"'Input Sheet'!M37","v":0},{"$f":"'Input Sheet'!I37","v":753},{"$f":"'Input Sheet'!J37","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W37","v":1}]
[{"$f":"'Input Sheet'!C38","v":150758},{"$f":"'Input Sheet'!D38","v":2015},{"$f":"'Input Sheet'!E38","v":"verano"},{"$f":"'Input Sheet'!F38","v":38428},{"$f":"'Input Sheet'!G38","v":22.85},{"$f":"'Input Sheet'!H38","v":0.6},{"$f":"'Input Sheet'!I38","v":753},{"$f":"'Input Sheet'!J38","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L38","v":0},{"$f":"'Input Sheet'!M38","v":0},{"$f":"'Input Sheet'!I38","v":753},{"$f":"'Input Sheet'!J38","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W38","v":1}]
[{"$f":"'Input Sheet'!C39","v":150760},{"$f":"'Input Sheet'!D39","v":2009},{"$f":"'Input Sheet'!E39","v":"sierra"},{"$f":"'Input Sheet'!F39","v":23230},{"$f":"'Input Sheet'!G39","v":22.85},{"$f":"'Input Sheet'!H39","v":0.6},{"$f":"'Input Sheet'!I39","v":753},{"$f":"'Input Sheet'!J39","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L39","v":0},{"$f":"'Input Sheet'!M39","v":0},{"$f":"'Input Sheet'!I39","v":753},{"$f":"'Input Sheet'!J39","v":15.5},0,{"$f":"'Input Sheet'!Q39","v":0},{"$f":"'Input Sheet'!R39","v":0},{"$f":"'Input Sheet'!S39","v":0},{"$f":"'Input Sheet'!T39","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V39","v":9.2999999999999989},{"$f":"'Input Sheet'!W39","v":1}]
[{"$f":"'Input Sheet'!C40","v":150763},{"$f":"'Input Sheet'!D40","v":2016},{"$f":"'Input Sheet'!E40","v":"emcore"},{"$f":"'Input Sheet'!F40","v":16509},{"$f":"'Input Sheet'!G40","v":22.85},{"$f":"'Input Sheet'!H40","v":0.6},{"$f":"'Input Sheet'!I40","v":753},{"$f":"'Input Sheet'!J40","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L40","v":0},{"$f":"'Input Sheet'!M40","v":0},{"$f":"'Input Sheet'!I40","v":753},{"$f":"'Input Sheet'!J40","v":15.5},0,{"$f":"'Input Sheet'!Q40","v":0},{"$f":"'Input Sheet'!R40","v":0},{"$f":"'Input Sheet'!S40","v":0},{"$f":"'Input Sheet'!T40","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V40","v":9.2999999999999989},{"$f":"'Input Sheet'!W40","v":1}]
[{"$f":"'Input Sheet'!C41","v":150764},{"$f":"'Input Sheet'!D41","v":2009},{"$f":"'Input Sheet'!E41","v":"yukon"},{"$f":"'Input Sheet'!F41","v":135281},{"$f":"'Input Sheet'!G41","v":0},{"$f":"'Input Sheet'!H41","v":0},{"$f":"'Input Sheet'!I41","v":0},{"$f":"'Input Sheet'!J41","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L41","v":282.85000000000002},{"$f":"'Input Sheet'!M41","v":2.6},{"$f":"'Input Sheet'!I41","v":0},{"$f":"'Input Sheet'!J41","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q41","v":0},{"$f":"'Input Sheet'!R41","v":0},{"$f":"'Input Sheet'!S41","v":0},{"$f":"'Input Sheet'!T41","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V41","v":40.300000000000004},{"$f":"'Input Sheet'!W41","v":2}]
[{"$f":"'Input Sheet'!C42","v":150775},{"$f":"'Input Sheet'!D42","v":2015},{"$f":"'Input Sheet'!E42","v":"yukon xl"},{"$f":"'Input Sheet'!F42","v":29452},{"$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":260},{"$f":"'Input Sheet'!M42","v":2},{"$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":52},{"$f":"'Input Sheet'!W42","v":1}]
[{"$f":"'Input Sheet'!C43","v":150771},{"$f":"'Input Sheet'!D43","v":2004},{"$f":"'Input Sheet'!E43","v":"sierra 2500"},{"$f":"'Input Sheet'!F43","v":83059},{"$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":0},{"$f":"'Input Sheet'!M43","v":0},{"$f":"'Input Sheet'!I43","v":0},{"$f":"'Input Sheet'!J43","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q43","v":438.85},{"$f":"'Input Sheet'!R43","v":3.8},{"$f":"'Input Sheet'!S43","v":753},{"$f":"'Input Sheet'!T43","v":15.5},58.9,{"$f":"'Input Sheet'!V43","v":58.9},{"$f":"'Input Sheet'!W43","v":3}]
[{"$f":"'Input Sheet'!C44","v":150778},{"$f":"'Input Sheet'!D44","v":2015},{"$f":"'Input Sheet'!E44","v":"sierra"},{"$f":"'Input Sheet'!F44","v":67885},{"$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":0},{"$f":"'Input Sheet'!M44","v":0},{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q44","v":130},{"$f":"'Input Sheet'!R44","v":1},{"$f":"'Input Sheet'!S44","v":735},{"$f":"'Input Sheet'!T44","v":32},32,{"$f":"'Input Sheet'!V44","v":32},{"$f":"'Input Sheet'!W44","v":1}]
[{"$f":"'Input Sheet'!C45","v":150818},{"$f":"'Input Sheet'!D45","v":2013},{"$f":"'Input Sheet'!E45","v":"cts"},{"$f":"'Input Sheet'!F45","v":33936},{"$f":"'Input Sheet'!G45","v":37.950000000000003},{"$f":"'Input Sheet'!H45","v":0.6},{"$f":"'Input Sheet'!I45","v":753},{"$f":"'Input Sheet'!J45","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L45","v":0},{"$f":"'Input Sheet'!M45","v":0},{"$f":"'Input Sheet'!I45","v":753},{"$f":"'Input Sheet'!J45","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W45","v":1}]
[{"$f":"'Input Sheet'!C46","v":150824},{"$f":"'Input Sheet'!D46","v":2003},{"$f":"'Input Sheet'!E46","v":"rendezvous"},{"$f":"'Input Sheet'!F46","v":67918},{"$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":152.85},{"$f":"'Input Sheet'!M46","v":1.6},{"$f":"'Input Sheet'!I46","v":0},{"$f":"'Input Sheet'!J46","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q46","v":0},{"$f":"'Input Sheet'!R46","v":0},{"$f":"'Input Sheet'!S46","v":0},{"$f":"'Input Sheet'!T46","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V46","v":24.8},{"$f":"'Input Sheet'!W46","v":2}]
[{"$f":"'Input Sheet'!C47","v":150837},{"$f":"'Input Sheet'!D47","v":2013},{"$f":"'Input Sheet'!E47","v":"lacrosse"},{"$f":"'Input Sheet'!F47","v":23705},{"$f":"'Input Sheet'!G47","v":62.5},{"$f":"'Input Sheet'!H47","v":0.6},{"$f":"'Input Sheet'!I47","v":753},{"$f":"'Input Sheet'!J47","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L47","v":0},{"$f":"'Input Sheet'!M47","v":0},{"$f":"'Input Sheet'!I47","v":753},{"$f":"'Input Sheet'!J47","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W47","v":1}]
[{"$f":"'Input Sheet'!C48","v":150840},{"$f":"'Input Sheet'!D48","v":2012},{"$f":"'Input Sheet'!E48","v":"yukon"},{"$f":"'Input Sheet'!F48","v":60278},{"$f":"'Input Sheet'!G48","v":22.85},{"$f":"'Input Sheet'!H48","v":0.6},{"$f":"'Input Sheet'!I48","v":753},{"$f":"'Input Sheet'!J48","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L48","v":0},{"$f":"'Input Sheet'!M48","v":0},{"$f":"'Input Sheet'!I48","v":753},{"$f":"'Input Sheet'!J48","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W48","v":1}]
[{"$f":"'Input Sheet'!C49","v":150795},{"$f":"'Input Sheet'!D49","v":2001},{"$f":"'Input Sheet'!E49","v":"sierra"},{"$f":"'Input Sheet'!F49","v":252286},{"$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":0},{"$f":"'Input Sheet'!M49","v":0},{"$f":"'Input Sheet'!I49","v":0},{"$f":"'Input Sheet'!J49","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q49","v":234},{"$f":"'Input Sheet'!R49","v":1.8},{"$f":"'Input Sheet'!S49","v":735},{"$f":"'Input Sheet'!T49","v":32},57.6,{"$f":"'Input Sheet'!V49","v":57.6},{"$f":"'Input Sheet'!W49","v":1}]
[{"$f":"'Input Sheet'!C50","v":150835},{"$f":"'Input Sheet'!D50","v":2007},{"$f":"'Input Sheet'!E50","v":"hhr"},{"$f":"'Input Sheet'!F50","v":57059},{"$f":"'Input Sheet'!G50","v":12.6},{"$f":"'Input Sheet'!H50","v":0.6},{"$f":"'Input Sheet'!I50","v":753},{"$f":"'Input Sheet'!J50","v":15.5},9.2999999999999989,{"$f":"'Input Sheet'!L50","v":0},{"$f":"'Input Sheet'!M50","v":0},{"$f":"'Input Sheet'!I50","v":753},{"$f":"'Input Sheet'!J50","v":15.5},0,{"$f":"'Input Sheet'!Q50","v":0},{"$f":"'Input Sheet'!R50","v":0},{"$f":"'Input Sheet'!S50","v":0},{"$f":"'Input Sheet'!T50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V50","v":9.2999999999999989},{"$f":"'Input Sheet'!W50","v":1}]
[{"$f":"'Input Sheet'!C51","v":150842},{"$f":"'Input Sheet'!D51","v":2015},{"$f":"'Input Sheet'!E51","v":"acadia"},{"$f":"'Input Sheet'!D51","v":2015},{"$f":"'Input Sheet'!G51","v":22.85},{"$f":"'Input Sheet'!H51","v":0.6},{"$f":"'Input Sheet'!I51","v":753},{"$f":"'Input Sheet'!J51","v":15.5},{"$f":"#REF!*H51","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!L51","v":0},{"$f":"'Input Sheet'!M51","v":0},{"$f":"'Input Sheet'!I51","v":753},{"$f":"'Input Sheet'!J51","v":15.5},0,{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W51","v":1}]
[{"$f":"'Input Sheet'!C52","v":150844},{"$f":"'Input Sheet'!D52","v":2015},{"$f":"'Input Sheet'!E52","v":"terrain"},{"$f":"'Input Sheet'!F52","v":71988},{"$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":118.1},{"$f":"'Input Sheet'!M52","v":1.6},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q52","v":0},{"$f":"'Input Sheet'!R52","v":0},{"$f":"'Input Sheet'!S99","v":773},{"$f":"'Input Sheet'!T99","v":30},0,{"$f":"'Input Sheet'!V52","v":41.6},{"$f":"'Input Sheet'!W52","v":2}]
[{"$f":"'Input Sheet'!C53","v":150847},{"$f":"'Input Sheet'!D53","v":2016},{"$f":"'Input Sheet'!E53","v":"yukon"},{"$f":"'Input Sheet'!F53","v":24025},{"$f":"'Input Sheet'!G53","v":22.85},{"$f":"'Input Sheet'!H53","v":0.6},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L53","v":0},{"$f":"'Input Sheet'!M53","v":0},{"$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":9.2999999999999989},{"$f":"'Input Sheet'!W53","v":1}]
[150850,1996,"sierra 3500",151130,null,null,null,null,null,null,null,null,null,null,15521.83,20.6,null,null,null,700,3]
[{"$f":"'Input Sheet'!C54","v":150854},{"$f":"'Input Sheet'!D54","v":2012},{"$f":"'Input Sheet'!E54","v":"sierra"},{"$f":"'Input Sheet'!F54","v":58312},{"$f":"'Input Sheet'!G54","v":22.85},{"$f":"'Input Sheet'!H54","v":0.6},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"F55*H55","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L54","v":0},{"$f":"'Input Sheet'!M54","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"K55*M55","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":"P55*R55","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V54","v":9.2999999999999989},{"$f":"'Input Sheet'!W54","v":1}]
["RO's 1-50",null,null,"Totals",{"$f":"SUM(E6:E55)","v":1309.1999999999994},{"$f":"SUM(F6:F55)","v":19.900000000000006},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#REF!"}},{"$f":"SUM(J6:J55)","v":1367.6799999999998},{"$f":"SUM(K6:K55)","v":13.899999999999999},{"$f":"SUM(L6:L55)","v":{"$error":"#REF!"}},{"$f":"SUM(M6:M55)","v":{"$error":"#REF!"}},{"$f":"SUM(N6:N55)","v":{"$error":"#REF!"}},{"$f":"SUM(O6:O55)","v":19165.98},{"$f":"SUM(P6:P55)","v":51.900000000000006},null,null,{"$f":"SUM(S6:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T6:T55)","v":1943.7499999999991},{"$f":"COUNTIF(U5:U55,1)","v":37}]
["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"]
[151870,2001,"corvette",82756,{"$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":0},{"$f":"'Input Sheet'!M56","v":0},{"$f":"'Input Sheet'!N56","v":0},{"$f":"'Input Sheet'!O56","v":""},{"$f":"K6*M6","v":{"$error":"#VALUE!"}},74.849999999999994,0.8,{"$f":"'Input Sheet'!S56","v":735},{"$f":"'Input Sheet'!T56","v":32},{"$f":"P6*R6","v":25.6},28,3]
["152414*",2014,"sierra 1500",54400,{"$f":"'Input Sheet'!G57","v":0},{"$f":"'Input Sheet'!H57","v":0},{"$f":"'Input Sheet'!I57","v":0},{"$f":"'Input Sheet'!J57","v":""},{"$error":"#VALUE!"},{"$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!"},2054.64,2.7,{"$f":"'Input Sheet'!S57","v":735},{"$f":"'Input Sheet'!T57","v":32},86.4,94.5,4]
[152548,2006,"yukon xl",179745,{"$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!"},1066.18,6.5,{"$f":"'Input Sheet'!S58","v":735},{"$f":"'Input Sheet'!T58","v":32},208,227.5,4]
[152555,2007,"Hummer H3",113405,0,0,{"$f":"'Input Sheet'!I59","v":0},{"$f":"'Input Sheet'!J59","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L59","v":0},{"$f":"'Input Sheet'!M59","v":0},{"$f":"'Input Sheet'!N59","v":0},{"$f":"'Input Sheet'!O59","v":""},{"$error":"#VALUE!"},1188.8800000000001,8.1,{"$f":"'Input Sheet'!S59","v":743},{"$f":"'Input Sheet'!T59","v":21},170.1,157.5,4]
[152677,2014,"Camaro",61516,0,0,{"$f":"'Input Sheet'!I60","v":0},{"$f":"'Input Sheet'!J60","v":""},{"$error":"#VALUE!"},182.08,1.6,{"$f":"'Input Sheet'!N60","v":743},{"$f":"'Input Sheet'!O60","v":21},33.6,{"$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!"},182.08,3]
[152736,2012,"Yukon XL",78856,0,0,{"$f":"'Input Sheet'!I61","v":0},{"$f":"'Input Sheet'!J61","v":""},{"$error":"#VALUE!"},0,0,{"$f":"'Input Sheet'!N61","v":0},{"$f":"'Input Sheet'!O61","v":""},{"$error":"#VALUE!"},1286.96,5.6,{"$f":"'Input Sheet'!S61","v":735},{"$f":"'Input Sheet'!T61","v":32},179.2,196,4]
[152745,2005,"Yukon ",149595,{"$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":0},{"$f":"'Input Sheet'!M62","v":0},{"$f":"'Input Sheet'!N62","v":0},{"$f":"'Input Sheet'!O62","v":""},{"$error":"#VALUE!"},1450.79,1.5,{"$f":"'Input Sheet'!S62","v":770},{"$f":"'Input Sheet'!T62","v":21},31.5,195,1]
[152770,2016,"Canyon",17468,0,0,{"$f":"'Input Sheet'!I63","v":0},{"$f":"'Input Sheet'!J63","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L63","v":0},{"$f":"'Input Sheet'!M63","v":0},{"$f":"'Input Sheet'!N63","v":0},{"$f":"'Input Sheet'!O63","v":""},{"$error":"#VALUE!"},920.32,6.6,{"$f":"'Input Sheet'!S63","v":717},{"$f":"'Input Sheet'!T63","v":26},171.6,156,1]
[152790,2001,"Safari",225023,{"$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!"},591.71,2,{"$f":"'Input Sheet'!N64","v":773},{"$f":"'Input Sheet'!O64","v":30},60,{"$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!"},60,2]
[152791,2003,"Yukon XL",151524,0,0,{"$f":"'Input Sheet'!I65","v":0},{"$f":"'Input Sheet'!J65","v":""},{"$error":"#VALUE!"},152.69999999999999,1.8,{"$f":"'Input Sheet'!N65","v":710},{"$f":"'Input Sheet'!O65","v":25},45,{"$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!"},30,3]
[152792,2015,"Sierra 2500HD",30771,0,0,{"$f":"'Input Sheet'!I66","v":0},{"$f":"'Input Sheet'!J66","v":""},{"$error":"#VALUE!"},583.94000000000005,2.9,{"$f":"'Input Sheet'!N66","v":717},{"$f":"'Input Sheet'!O66","v":26},75.399999999999991,{"$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!"},110.4,4]
[152804,2015,"Sierra 2500HD",58450,452.03,1.8,{"$f":"'Input Sheet'!I67","v":0},{"$f":"'Input Sheet'!J67","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L67","v":0},{"$f":"'Input Sheet'!M67","v":0},{"$f":"'Input Sheet'!N67","v":0},{"$f":"'Input Sheet'!O67","v":""},{"$error":"#VALUE!"},{"$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!"},162.94999999999999,2]
[152823,2008,"PT Cruiser",67576,22.85,0.6,{"$f":"'Input Sheet'!I68","v":0},{"$f":"'Input Sheet'!J68","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L68","v":0},{"$f":"'Input Sheet'!M68","v":0},{"$f":"'Input Sheet'!N68","v":0},{"$f":"'Input Sheet'!O68","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152889,2014,"Sierra 2500HD",22662,284.45999999999998,1.4,{"$f":"'Input Sheet'!I69","v":0},{"$f":"'Input Sheet'!J69","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L69","v":0},{"$f":"'Input Sheet'!M69","v":0},{"$f":"'Input Sheet'!N69","v":0},{"$f":"'Input Sheet'!O69","v":""},{"$error":"#VALUE!"},{"$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!"},147.94999999999999,1]
[152894,2015,"Yukon ",49725,22.85,0.6,{"$f":"'Input Sheet'!I70","v":0},{"$f":"'Input Sheet'!J70","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L70","v":0},{"$f":"'Input Sheet'!M70","v":0},{"$f":"'Input Sheet'!N70","v":0},{"$f":"'Input Sheet'!O70","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152898,2016,"Acadia",32512,22.85,0.6,{"$f":"'Input Sheet'!I71","v":0},{"$f":"'Input Sheet'!J71","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L71","v":0},{"$f":"'Input Sheet'!M71","v":0},{"$f":"'Input Sheet'!N71","v":0},{"$f":"'Input Sheet'!O71","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152899,2015,"Acadia",47402,{"$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!"},130,0.1,{"$f":"'Input Sheet'!N72","v":0},{"$f":"'Input Sheet'!O72","v":""},{"$error":"#VALUE!"},{"$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!"},13,1]
[152902,2003,"Yukon XL",204593,{"$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":0},{"$f":"'Input Sheet'!M73","v":0},{"$f":"'Input Sheet'!N73","v":0},{"$f":"'Input Sheet'!O73","v":""},{"$error":"#VALUE!"},130,1,{"$f":"'Input Sheet'!S73","v":735},{"$f":"'Input Sheet'!T73","v":32},32,35,1]
[152912,2014,"sierra 1500",81315,22.85,0.6,{"$f":"'Input Sheet'!I74","v":0},{"$f":"'Input Sheet'!J74","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L74","v":0},{"$f":"'Input Sheet'!M74","v":0},{"$f":"'Input Sheet'!N74","v":0},{"$f":"'Input Sheet'!O74","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152922,2014,"Sierra 1500",30702,292.77999999999997,1.6,{"$f":"'Input Sheet'!I75","v":0},{"$f":"'Input Sheet'!J75","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L75","v":0},{"$f":"'Input Sheet'!M75","v":0},{"$f":"'Input Sheet'!N75","v":0},{"$f":"'Input Sheet'!O75","v":""},{"$error":"#VALUE!"},{"$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!"},15.6,1]
[152947,2012,"Yukon",64328,393.34,1.6,{"$f":"'Input Sheet'!I76","v":0},{"$f":"'Input Sheet'!J76","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L76","v":0},{"$f":"'Input Sheet'!M76","v":0},{"$f":"'Input Sheet'!N76","v":0},{"$f":"'Input Sheet'!O76","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q76","v":0},{"$f":"'Input Sheet'!R76","v":0},{"$f":"'Input Sheet'!S76","v":0},{"$f":"'Input Sheet'!T76","v":""},{"$error":"#VALUE!"},15.6,1]
[152949,2016,"Yukon XL",32916,22.85,0.6,{"$f":"'Input Sheet'!I77","v":0},{"$f":"'Input Sheet'!J77","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L77","v":0},{"$f":"'Input Sheet'!M77","v":0},{"$f":"'Input Sheet'!N77","v":0},{"$f":"'Input Sheet'!O77","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152950,2009,"Colorado",92056,{"$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":0},{"$f":"'Input Sheet'!M78","v":0},{"$f":"'Input Sheet'!N78","v":0},{"$f":"'Input Sheet'!O78","v":""},{"$error":"#VALUE!"},195,1.5,{"$f":"'Input Sheet'!S78","v":735},{"$f":"'Input Sheet'!T78","v":32},48,35,1]
[152951,2012,"Town & Country",75979,22.85,0.6,{"$f":"'Input Sheet'!I79","v":0},{"$f":"'Input Sheet'!J79","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L79","v":0},{"$f":"'Input Sheet'!M79","v":0},{"$f":"'Input Sheet'!N79","v":0},{"$f":"'Input Sheet'!O79","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152963,2014,"Acadia",55821,22.85,0.6,{"$f":"'Input Sheet'!I80","v":0},{"$f":"'Input Sheet'!J80","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[152973,2015,"sierra 1500",37437,{"$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!"},112,0.3,{"$f":"'Input Sheet'!N81","v":773},{"$f":"'Input Sheet'!O81","v":30},9,{"$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!"},6,1]
[152982,2011,"Acadia",115834,{"$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!"},155.21,1.1000000000000001,{"$f":"'Input Sheet'!N82","v":782},{"$f":"'Input Sheet'!O82","v":""},{"$error":"#VALUE!"},{"$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!"},87.85,2]
[152983,2011,"Acadia ",146372,22.85,0.6,{"$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":0},{"$f":"'Input Sheet'!R83","v":0},{"$f":"'Input Sheet'!S83","v":0},{"$f":"'Input Sheet'!T83","v":""},{"$error":"#VALUE!"},12.6,1]
[152995,2009,"Sierra 2500HD",62770,{"$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!"},424.06,3.3,{"$f":"'Input Sheet'!N84","v":0},{"$f":"'Input Sheet'!O84","v":""},{"$error":"#VALUE!"},{"$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!"},80.5,2]
[153009,2015,"Sierra 3500",24464,29.95,0.3,{"$f":"'Input Sheet'!I85","v":0},{"$f":"'Input Sheet'!J85","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L85","v":0},{"$f":"'Input Sheet'!M85","v":0},{"$f":"'Input Sheet'!N85","v":0},{"$f":"'Input Sheet'!O85","v":""},{"$error":"#VALUE!"},{"$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!"},42.05,1]
[153010,2011,"Terrain",80389,22.85,0.6,{"$f":"'Input Sheet'!I86","v":0},{"$f":"'Input Sheet'!J86","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L86","v":0},{"$f":"'Input Sheet'!M86","v":0},{"$f":"'Input Sheet'!N86","v":0},{"$f":"'Input Sheet'!O86","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[153012,2016,"Sierra 2500HD",92526,{"$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!"},209.14,0.9,{"$f":"'Input Sheet'!N87","v":0},{"$f":"'Input Sheet'!O87","v":""},{"$error":"#VALUE!"},{"$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!"},94.95,{"$f":"'Input Sheet'!W87","v":1}]
[153013,2015,"Sierra 2500HD",42431,121.6,0.9,{"$f":"'Input Sheet'!I88","v":0},{"$f":"'Input Sheet'!J88","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L88","v":0},{"$f":"'Input Sheet'!M88","v":0},{"$f":"'Input Sheet'!N88","v":0},{"$f":"'Input Sheet'!O88","v":""},{"$error":"#VALUE!"},{"$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!"},32.950000000000003,1]
[153032,2015,"Yukon XL",55352,{"$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":0},{"$f":"'Input Sheet'!M89","v":0},{"$f":"'Input Sheet'!N89","v":0},{"$f":"'Input Sheet'!O89","v":""},{"$error":"#VALUE!"},653.28,2.5,{"$f":"'Input Sheet'!S89","v":0},{"$f":"'Input Sheet'!T89","v":""},{"$error":"#VALUE!"},78,1]
[153040,2013,"Cruze",71780,631.04999999999995,1,{"$f":"'Input Sheet'!I90","v":0},{"$f":"'Input Sheet'!J90","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L90","v":0},{"$f":"'Input Sheet'!M90","v":0},{"$f":"'Input Sheet'!N90","v":0},{"$f":"'Input Sheet'!O90","v":""},{"$error":"#VALUE!"},{"$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!"},95,1]
[153057,2005,"Silverado 2500",197835,{"$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":0},{"$f":"'Input Sheet'!M91","v":0},{"$f":"'Input Sheet'!N91","v":0},{"$f":"'Input Sheet'!O91","v":""},{"$error":"#VALUE!"},599.66,2.8,{"$f":"'Input Sheet'!S91","v":773},{"$f":"'Input Sheet'!T91","v":30},84,45,2]
[153060,2015,"Sierra 2500HD",63478,360.43,1.8,{"$f":"'Input Sheet'!I92","v":0},{"$f":"'Input Sheet'!J92","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L92","v":0},{"$f":"'Input Sheet'!M92","v":0},{"$f":"'Input Sheet'!N92","v":0},{"$f":"'Input Sheet'!O92","v":""},{"$error":"#VALUE!"},{"$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!"},46.8,2]
[153061,2015,"Sierra 2500HD",63574,{"$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!"},939.91,2,{"$f":"'Input Sheet'!N93","v":717},{"$f":"'Input Sheet'!O93","v":26},52,{"$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!"},52,3]
[153066,2015,"Sierra 1500",25120,224.28,1.2,{"$f":"'Input Sheet'!I94","v":0},{"$f":"'Input Sheet'!J94","v":""},{"$error":"#VALUE!"},{"$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!"},87.85,2]
[153069,2011,"Yukon XL",62393,198.71,1,{"$f":"'Input Sheet'!I95","v":0},{"$f":"'Input Sheet'!J95","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L95","v":0},{"$f":"'Input Sheet'!M95","v":0},{"$f":"'Input Sheet'!N95","v":0},{"$f":"'Input Sheet'!O95","v":""},{"$error":"#VALUE!"},{"$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!"},26,1]
[153079,2012,"Cruze",150476,794.11,1,{"$f":"'Input Sheet'!I96","v":0},{"$f":"'Input Sheet'!J96","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L96","v":0},{"$f":"'Input Sheet'!M96","v":0},{"$f":"'Input Sheet'!N96","v":0},{"$f":"'Input Sheet'!O96","v":""},{"$error":"#VALUE!"},{"$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!"},95,1]
[153080,2013,"Suburban",84433,{"$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!"},230.91,1.2,{"$f":"'Input Sheet'!N97","v":0},{"$f":"'Input Sheet'!O97","v":""},{"$error":"#VALUE!"},{"$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!"},25.2,2]
[153081,2005,"Yukon",198796,{"$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":0},{"$f":"'Input Sheet'!M98","v":0},{"$f":"'Input Sheet'!N98","v":0},{"$f":"'Input Sheet'!O98","v":""},{"$error":"#VALUE!"},622.70000000000005,1.6,{"$f":"'Input Sheet'!S98","v":0},{"$f":"'Input Sheet'!T98","v":""},{"$error":"#VALUE!"},133,2]
[153089,2012,"Acadia",97424,287.2,1.3,{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L99","v":0},{"$f":"'Input Sheet'!M99","v":0},{"$f":"'Input Sheet'!N99","v":0},{"$f":"'Input Sheet'!O99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q99","v":622.70000000000005},{"$f":"'Input Sheet'!R99","v":1.6},{"$f":"'Input Sheet'!S99","v":773},{"$f":"'Input Sheet'!T99","v":30},48,"30,00",1]
[153095,2007,"Sierra 1500",104414,22.85,0.6,{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L100","v":0},{"$f":"'Input Sheet'!M100","v":0},{"$f":"'Input Sheet'!N100","v":0},{"$f":"'Input Sheet'!O100","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[153128,2007,"Envoy",113072,0,{"$f":"'Input Sheet'!H101","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$error":"#VALUE!"},220.73,1.6,{"$f":"'Input Sheet'!N101","v":0},{"$f":"'Input Sheet'!O101","v":""},{"$error":"#VALUE!"},{"$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!"},76,2]
[153131,2011,"Acadia",100097,{"$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!"},543.80999999999995,2.6,{"$f":"'Input Sheet'!N102","v":757},{"$f":"'Input Sheet'!O102","v":14},36.4,{"$f":"'Input Sheet'!Q102","v":0},{"$f":"'Input Sheet'!R102","v":0},{"$f":"'Input Sheet'!S102","v":0},{"$f":"'Input Sheet'!T102","v":""},{"$error":"#VALUE!"},70,2]
[153141,2014,"Equinox",71379,112.95,1,{"$f":"'Input Sheet'!I103","v":0},{"$f":"'Input Sheet'!J103","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L103","v":0},{"$f":"'Input Sheet'!M103","v":0},{"$f":"'Input Sheet'!N103","v":0},{"$f":"'Input Sheet'!O103","v":""},{"$error":"#VALUE!"},{"$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!"},35,1]
[153152,2014,"Terrain",7101,22.85,0.6,{"$f":"'Input Sheet'!I104","v":0},{"$f":"'Input Sheet'!J104","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L104","v":0},{"$f":"'Input Sheet'!M104","v":0},{"$f":"'Input Sheet'!N104","v":0},{"$f":"'Input Sheet'!O104","v":""},{"$error":"#VALUE!"},{"$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!"},12.6,1]
[153156,2003,"Sierra 1500",18170,22.85,0.6,{"$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":0},{"$f":"'Input Sheet'!R105","v":0},{"$f":"'Input Sheet'!S105","v":0},{"$f":"'Input Sheet'!T105","v":""},{"$error":"#VALUE!"},12.6,1]
["RO's 51-100",null,null,"Totals",{"$f":"SUM(E6:E55)","v":4457.0900000000011},{"$f":"SUM(F6:F55)","v":23.100000000000005},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J6:J55)","v":4476.2},{"$f":"SUM(K6:K55)","v":21.400000000000002},null,null,{"$f":"SUM(N6:N55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O6:O55)","v":10865.960000000001},{"$f":"SUM(P6:P55)","v":42.800000000000004},null,null,{"$f":"SUM(S6:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T6:T55)","v":3222.4299999999985},{"$f":"COUNTIF(U5:U55,1)","v":30}]
["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":5766.2900000000009},"÷",{"$f":"'RO Report 1-50'!F56+'RO Report 51-100'!F56","v":43.000000000000014},"=",{"$f":"IF(ISERROR(E5/G5),\"\",E5/G5)","v":134.09976744186045},"FRH Average"]
[null,null,"Maintenance",null,{"$f":"'RO Report 1-50'!J56+'RO Report 51-100'!J56","v":5843.8799999999992},"÷",{"$f":"'RO Report 1-50'!K56+'RO Report 51-100'!K56","v":35.299999999999997},"=",{"$f":"IF(ISERROR(E6/G6),\"\",E6/G6)","v":165.54900849858356},"FRH Average"]
[null,null,"Repair",null,{"$f":"'RO Report 1-50'!O56+'RO Report 51-100'!O56","v":30031.940000000002},"÷",{"$f":"'RO Report 1-50'!P56+'RO Report 51-100'!P56","v":94.700000000000017},"=",{"$f":"IF(ISERROR(E7/G7),\"\",E7/G7)","v":317.12713833157335},"FRH Average"]
[null,null,"Totals",null,{"$f":"SUM(E5:E7)","v":41642.11},"÷",{"$f":"SUM(G5:G7)","v":173.00000000000003},"=",{"$f":"IF(ISERROR(E8/G8),\"\",E8/G8)","v":240.70583815028897},"Customer ELR"]
[null,null,null,null,null,null,null,"Target Labor Rate",130,"Per FRH"]
[null,null,"Total Ro's in Sample",null,100,null,null,"Difference",{"$f":"IF(ISERROR(I8-I9),\"\",I8-I9)","v":110.70583815028897},"Per FRH"]
[]
[null,null,"Cost of Labor"]
[null,null,"Total Cost of Labor",null,{"$f":"'Input Sheet'!V106","v":5166.1799999999994},"÷","Total Sales","=",{"$f":"IF(ISERROR(E13/E8),\"\",E13/E8)","v":0.12406143684842097},"Percent Cost of Sales"]
[null,null,"Total Cost of Labor",null,{"$f":"E13","v":5166.1799999999994},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E14/G8),\"\",E14/G8)","v":29.862312138728313},"Cost per FRH"]
[]
[null,null,"Repair Order Measurements"]
[null,null,"Total Labor Sales",null,{"$f":"E8","v":41642.11},"÷","Total RO's","=",{"$f":"IF(ISERROR(E17/E10),\"\",E17/E10)","v":416.42110000000002},"Avg Labor per RO"]
[null,null,"Total FRH's",null,{"$f":"G8","v":173.00000000000003},"÷","Total RO's","=",{"$f":"IF(ISERROR(E18/E10),\"\",E18/E10)","v":1.7300000000000002},"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":43.000000000000014},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E20/G8),\"\",(E20/G8))","v":0.24855491329479773},"Percent Competitive"]
[null,null,"Maintenance FRH's",null,{"$f":"G6","v":35.299999999999997},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E21/G8),\"\",(E21/G8))","v":0.20404624277456643},"Percent Maintenance "]
[null,null,"Repair FRH'",null,{"$f":"G7","v":94.700000000000017},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E22/G8),\"\",E22/G8)","v":0.54739884393063587},"Percent Repair "]
[null,null,"One item RO's",null,{"$f":"'RO Report 1-50'!U56+'RO Report 51-100'!U56","v":67},"÷","Total RO's","=",{"$f":"IF(ISERROR(E23/E10),\"\",E23/E10)","v":0.67},"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":0},{"$f":"COUNTIF('Input Sheet'!D6:D105,E26)","v":11},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,G26)","v":22},{"$f":"COUNTIF('Input Sheet'!D6:D105,H26)","v":9},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,J26)","v":7},{"$f":"L27-(SUM(C27:J27))","v":51},{"$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},{"$f":"IF(ISERROR(E27/L27),\"\",E27/L27)","v":0.11},null,{"$f":"IF(ISERROR(G27/L27),\"\",G27/L27)","v":0.22},{"$f":"IF(ISERROR(H27/L27),\"\",H27/L27)","v":0.09},null,{"$f":"IF(ISERROR(J27/L27),\"\",J27/L27)","v":7.0000000000000007E-2},{"$f":"IF(ISERROR(K27/L27),\"\",K27/L27)","v":0.51}]