{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Title","Tech Pay","Input Sheet","RO Report 1-50","RO Report 51-100","Summary Report"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,0,15,9],[16,0,16,9],[35,7,39,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Repair Order Analysis"]
["And Summary",null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2017-07-31"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Dealership "]
[]
[]
["Student "]
[]
[]
["Class and ID Number",null,null,null,null,null,null,"Computer Application by            George A. Parker                Management Instructor           NADA Dealer Academy"]

{"sheet":"Tech Pay","index":1,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"Tech #","Tech Pay Per FRH"]
[null,1317,27.5]
[null,1441,26.5]
[null,1335,25]
[null,913,26.5]
[null,464,27]
[null,1332,24]
[null,1067,27.5]
[null,494,31.5]
[null,940,31]
[null,774,35]
[null,1278,23.5]
[null,1489,19]
[null,988,13]

{"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,"1M+S838485  (1)",2011,"COUNTRYMAN",65926,189,1.4,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I6,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I6,TechNumber,2,FALSE))","v":23.5},{"$f":"IF(ISERROR(H6*J6),\"\",H6*J6)","v":32.9},null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N6,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N6,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(M6*O6),\" \",M6*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":32.9},1]
[null,2,"1M+S838487  (2)",2013,"COOPER",50693,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I7,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I7,TechNumber,2,FALSE))","v":""},"",135,1,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N7,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N7,TechNumber,2,FALSE))","v":31},31,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S7,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S7,TechNumber,2,FALSE))","v":""},"",{"$f":"SUM(U7,P7,K7)","v":31}]
[null,3,"1M+S838488  (3)",2011,"COOPER",58686,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I8,TechNumber,2,FALSE))","v":""},"",297,2.2000000000000002,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N8,TechNumber,2,FALSE))","v":25},55.000000000000007,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S8,TechNumber,2,FALSE))","v":""},"",55.000000000000007]
[null,4,"1M+S838494",2017,"COOPER",11663,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I9,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N9,TechNumber,2,FALSE))","v":""}," ",55,0.5,988,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S9,TechNumber,2,FALSE))","v":13},6.5,6.5,1]
[null,5,"1M+S838496",2011,"COOPER",52709,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":""}," ",472.5,3.5,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S10,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S10,TechNumber,2,FALSE))","v":31},108.5,108.5]
[null,6,"1M+S838511",2011,"COOPER",79203,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I11,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I11,TechNumber,2,FALSE))","v":""},"",162,1.2,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N11,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N11,TechNumber,2,FALSE))","v":27.5},33,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S11,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S11,TechNumber,2,FALSE))","v":""},"",33]
[null,7,"1M+S838505",2014,"COOPER",18063,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I12,TechNumber,2,FALSE))","v":26.5},10.600000000000001,90.95,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N12,TechNumber,2,FALSE))","v":26.5},26.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S12,TechNumber,2,FALSE))","v":""},"",37.1]
[null,8,"1M+s838512",2010,"COOPER",65759,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I13,TechNumber,2,FALSE))","v":26.5},10.600000000000001,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N13,TechNumber,2,FALSE))","v":""}," ",504,3.6,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S13,TechNumber,2,FALSE))","v":26.5},95.4,106]
[null,9,"1M+S838518",2016,"COOPER",5123,49.95,0.6,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I14,TechNumber,2,FALSE))","v":26.5},15.899999999999999,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N14,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S14,TechNumber,2,FALSE))","v":""},"",15.899999999999999,1]
[null,10,"1M+S838519",2013,"COOPER",34013,31.41,0.4,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I15,TechNumber,2,FALSE))","v":25},10,161,1.4,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N15,TechNumber,2,FALSE))","v":25},35,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S15,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S15,TechNumber,2,FALSE))","v":""},"",45]
[null,11,"1M+S838528",2015,"COOPER",47094,29.95,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I16,TechNumber,2,FALSE))","v":27.5},11,86.25,0.75,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N16,TechNumber,2,FALSE))","v":27.5},20.625,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S16,TechNumber,2,FALSE))","v":""},"",31.625]
[null,12,"1M+S838531",2013,"COOPER",42970,5,0.1,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I17,TechNumber,2,FALSE))","v":31},3.1,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N17,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S17,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S17,TechNumber,2,FALSE))","v":""},"",3.1]
[null,13,"1M+S838537",2010,"COOPER",111780,31.41,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I18,TechNumber,2,FALSE))","v":27.5},11,189,1.9,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N18,TechNumber,2,FALSE))","v":27.5},52.25,297,2.2000000000000002,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S18,TechNumber,2,FALSE))","v":27.5},60.500000000000007,123.75]
[null,14,"1M+S838544",2008,"COOPER",47414,31.41,0.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I19,TechNumber,2,FALSE))","v":26.5},10.600000000000001,86.25,0.75,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N19,TechNumber,2,FALSE))","v":26.5},19.875,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S19,TechNumber,2,FALSE))","v":""},"",30.475000000000001]
[null,15,"1M+S838560",2006,"COOPER",20660,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I20,TechNumber,2,FALSE))","v":""},"",119.95,0.2,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N20,TechNumber,2,FALSE))","v":27.5},5.5,756,5.6,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S20,TechNumber,2,FALSE))","v":27.5},154,159.5]
[null,16,"1M+S838563",2009,"COOPER",35579,29.95,0.5,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I21,TechNumber,2,FALSE))","v":31},15.5,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":""},"",15.5,1]
[null,17,"1M+S838567",2014,"COOPER",29142,119.95,0.2,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I22,TechNumber,2,FALSE))","v":31},6.2,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":""},"",6.2,1]
[null,18,"1M+S838574",2004,"COOPER",10800,31.41,0.4,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I23,TechNumber,2,FALSE))","v":31.5},12.600000000000001,81,0.6,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N23,TechNumber,2,FALSE))","v":31.5},18.899999999999999,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S23,TechNumber,2,FALSE))","v":""},"",31.5]
[null,19,"1M+S838575",2016,"COOPER",2721,25,0.3,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I24,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,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":""},"",7.9499999999999993,1]
[null,20,"1M+S838577",2013,"COOPER",62359,29.95,0.5,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I25,TechNumber,2,FALSE))","v":25},12.5,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":""},"",12.5,1]
[null,21,"1M+S838579",2013,"COOPER",86197,31.41,0.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I26,TechNumber,2,FALSE))","v":26.5},10.600000000000001,207,1.8,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N26,TechNumber,2,FALSE))","v":26.5},47.7,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S26,TechNumber,2,FALSE))","v":""},"",58.300000000000004]
[null,22,"1M+S838584",2010,"COOPER",56719,81,0.6,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I27,TechNumber,2,FALSE))","v":31},18.599999999999998,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N27,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S27,TechNumber,2,FALSE))","v":""},"",18.599999999999998,1]
[null,23,"1M+S838588",2005,"COOPER",40625,31.41,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I28,TechNumber,2,FALSE))","v":27.5},11,67.5,0.5,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N28,TechNumber,2,FALSE))","v":27.5},13.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S28,TechNumber,2,FALSE))","v":""},"",24.75]
[null,24,"1M+S838486   (5)",2014,"COOPER",29368,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I29,TechNumber,2,FALSE))","v":""},"",178,0.8,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N29,TechNumber,2,FALSE))","v":27.5},22,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S29,TechNumber,2,FALSE))","v":""},"",22]
[null,25,"1M+S838492  (4)",2017,"cooper",7362,25,0.3,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I30,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,119.95,0.2,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N30,TechNumber,2,FALSE))","v":26.5},5.3000000000000007,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S30,TechNumber,2,FALSE))","v":""},"",13.25]
[null,26,"1M+S838966",2008,"COOPER",80052,270,2,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I31,TechNumber,2,FALSE))","v":31.5},63,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N31,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S31,TechNumber,2,FALSE))","v":""},"",63]
[null,27,"1M+S839190",2004,"COOPER",65651,31.41,0.4,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I32,TechNumber,2,FALSE))","v":31.5},12.600000000000001,648,4.8,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N32,TechNumber,2,FALSE))","v":31.5},151.19999999999999,756,5.6,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S32,TechNumber,2,FALSE))","v":31.5},176.39999999999998,340.2]
[null,28,"1M+S839204",2012,"COOPER",15605,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I33,TechNumber,2,FALSE))","v":""},"",119,2,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N33,TechNumber,2,FALSE))","v":31.5},63,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S33,TechNumber,2,FALSE))","v":""},"",63]
[null,29,"1M+S839211",2017,"COOPER",14637,49.95,0.6,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I34,TechNumber,2,FALSE))","v":23.5},14.1,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":""},"",14.1,1]
[null,30,"1M+S839237",2015,"COOPER",23451,49.95,0.6,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I35,TechNumber,2,FALSE))","v":25},15,119.95,2,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N35,TechNumber,2,FALSE))","v":25},50,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S35,TechNumber,2,FALSE))","v":""},"",65]
[null,31,"1M+S839250",2009,"COOPER",90202,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I36,TechNumber,2,FALSE))","v":""},"",540,4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N36,TechNumber,2,FALSE))","v":26.5},106,297,2.2000000000000002,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S36,TechNumber,2,FALSE))","v":26.5},58.300000000000004,164.3]
[null,32,"1M+S839277",2009,"COOPER",95260,49.95,0.6,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I37,TechNumber,2,FALSE))","v":25},15,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N37,TechNumber,2,FALSE))","v":""}," ",1256,9.3000000000000007,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S37,TechNumber,2,FALSE))","v":25},232.50000000000003,247.50000000000003]
[null,33,"1M+S839285",2012,"COOPER",42390,49.95,0.6,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I38,TechNumber,2,FALSE))","v":26.5},15.899999999999999,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":""},"",15.899999999999999,1]
[null,34,"1M+S839286",2013,"COOPER",52853,49.95,0.6,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I39,TechNumber,2,FALSE))","v":27.5},16.5,63,0.6,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N39,TechNumber,2,FALSE))","v":27.5},16.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S39,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S39,TechNumber,2,FALSE))","v":""},"",33]
[null,35,"1M+S839290",2015,"COOPER",32789,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I40,TechNumber,2,FALSE))","v":""},"",100,1.2,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N40,TechNumber,2,FALSE))","v":27},32.4,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S40,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S40,TechNumber,2,FALSE))","v":""},"",32.4,1]
[null,36,"1M+S839293",2012,"COOPER",49461,31.41,0.4,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I41,TechNumber,2,FALSE))","v":27},10.8,72.5,0.5,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N41,TechNumber,2,FALSE))","v":27},13.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S41,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S41,TechNumber,2,FALSE))","v":""},"",24.3]
[null,37,"1M+S839295",2012,"COOPER",60644,24.9,0.2,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I42,TechNumber,2,FALSE))","v":31},6.2,348,2.4,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N42,TechNumber,2,FALSE))","v":31},74.399999999999991,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S42,TechNumber,2,FALSE))","v":""},"",80.599999999999994]
[null,38,"1M+S839307",2009,"COOPER",37070,13.5,0.1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I43,TechNumber,2,FALSE))","v":23.5},2.35,135,1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N43,TechNumber,2,FALSE))","v":23.5},23.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S43,TechNumber,2,FALSE))","v":""},"",25.85]
[null,39,"1M+S839342",2003,"COOPER",176615,15.5,0.3,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I44,TechNumber,2,FALSE))","v":31.5},9.4499999999999993,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N44,TechNumber,2,FALSE))","v":""}," ",891,6.6,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S44,TechNumber,2,FALSE))","v":31.5},207.89999999999998,217.34999999999997]
[null,40,"1M+S839353",2007,"COOPER",29777,31.41,0.4,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I45,TechNumber,2,FALSE))","v":25},10,119.95,2,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N45,TechNumber,2,FALSE))","v":25},50,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S45,TechNumber,2,FALSE))","v":""},"",60]
[null,41,"1M+S839355",2013,"COOPER",19240,29.95,0.3,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I46,TechNumber,2,FALSE))","v":25},7.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N46,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S46,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S46,TechNumber,2,FALSE))","v":""},"",7.5,1]
[null,42,"1M+S839373",2012,"COOPER",49474,31.41,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I47,TechNumber,2,FALSE))","v":27.5},11,73.5,0.7,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N47,TechNumber,2,FALSE))","v":27.5},19.25,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S47,TechNumber,2,FALSE))","v":""},"",30.25]
[null,43,"1M+S839377",2011,"COOPER",106930,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I48,TechNumber,2,FALSE))","v":""},"",202.5,1.5,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N48,TechNumber,2,FALSE))","v":31},46.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S48,TechNumber,2,FALSE))","v":""},"",46.5,1]
[null,44,"1M+S839382",2010,"COOPER",105881,15,0.3,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I49,TechNumber,2,FALSE))","v":23.5},7.05,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N49,TechNumber,2,FALSE))","v":""}," ",270,2,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S49,TechNumber,2,FALSE))","v":23.5},47,54.05]
[null,45,"1M+S839401",2012,"COOPER",78541,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I50,TechNumber,2,FALSE))","v":26.5},10.600000000000001,135,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N50,TechNumber,2,FALSE))","v":26.5},26.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S50,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S50,TechNumber,2,FALSE))","v":""},"",37.1]
[null,46,"1M+S839406",2013,"COOPER",91151,30,0.6,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I51,TechNumber,2,FALSE))","v":35},21,119.95,2,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N51,TechNumber,2,FALSE))","v":35},70,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S51,TechNumber,2,FALSE))","v":""},"",91]
[null,47,"1M+S839407",2007,"COOPER",93167,15,0.3,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I52,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,135,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N52,TechNumber,2,FALSE))","v":26.5},26.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S52,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S52,TechNumber,2,FALSE))","v":""},"",34.450000000000003]
[null,48,"1M+S839412",2012,"COOPER",48235,29.95,0.3,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I53,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,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":""},"",7.9499999999999993,1]
[null,49,"1M+S839419",2011,"COOPER",73580,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I54,TechNumber,2,FALSE))","v":""},"",172.5,1.7,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N54,TechNumber,2,FALSE))","v":35},59.5,232,1.6,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S54,TechNumber,2,FALSE))","v":35},56,115.5]
[null,50,"1M+S839425",2013,"COOPER",37562,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I55,TechNumber,2,FALSE))","v":26.5},10.600000000000001,90.95,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N55,TechNumber,2,FALSE))","v":26.5},26.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S55,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S55,TechNumber,2,FALSE))","v":""},"",37.1]
[null,51,"1M+S839428",2009,"COOPER",111525,135,1,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I56,TechNumber,2,FALSE))","v":35},35,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N56,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S56,TechNumber,2,FALSE))","v":""},"",35]
[null,52,"1M+S839429",2012,"COOPER",75020,31.41,0.4,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I57,TechNumber,2,FALSE))","v":23.5},9.4,145,1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N57,TechNumber,2,FALSE))","v":23.5},23.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S57,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S57,TechNumber,2,FALSE))","v":""},"",32.9]
[null,53,"1M+S839433",2011,"COOPER",47309,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I58,TechNumber,2,FALSE))","v":""},"",135,1,1489,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N58,TechNumber,2,FALSE))","v":19},19,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S58,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S58,TechNumber,2,FALSE))","v":""},"",19]
[null,54,"1M+S839451",2013,"COOPER",55118,494.12,1.2,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I59,TechNumber,2,FALSE))","v":26.5},31.799999999999997,119.95,2,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N59,TechNumber,2,FALSE))","v":26.5},53,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S59,TechNumber,2,FALSE))","v":""},"",84.8]
[null,55,"1M+S839453",2016,"COOPER",13641,29.95,0.3,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I60,TechNumber,2,FALSE))","v":23.5},7.05,119.95,2,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N60,TechNumber,2,FALSE))","v":23.5},47,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S60,TechNumber,2,FALSE))","v":""},"",54.05]
[null,56,"1M+S839458",2005,"COOPER",95499,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I61,TechNumber,2,FALSE))","v":""},"",135,1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N61,TechNumber,2,FALSE))","v":23.5},23.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S61,TechNumber,2,FALSE))","v":""},"",23.5,1]
[null,57,"1M+S839461",2014,"COOPER",30539,100,1.2,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I62,TechNumber,2,FALSE))","v":25},30,119.95,2,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N62,TechNumber,2,FALSE))","v":25},50,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S62,TechNumber,2,FALSE))","v":""},"",80]
[null,58,"1M+S839463",2015,"COOPER",34882,157.30000000000001,0.3,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I63,TechNumber,2,FALSE))","v":27.5},8.25,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N63,TechNumber,2,FALSE))","v":""}," ",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S63,TechNumber,2,FALSE))","v":""},"",8.25]
[null,59,"1M+S839468",2013,"COOPER",17013,31.41,0.4,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I64,TechNumber,2,FALSE))","v":27},10.8,90.95,1,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N64,TechNumber,2,FALSE))","v":27},27,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S64,TechNumber,2,FALSE))","v":""},"",37.799999999999997]
[null,60,"1M+S839469",2013,"COOPER",77975,31.41,0.4,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I65,TechNumber,2,FALSE))","v":35},14,29.95,0.3,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N65,TechNumber,2,FALSE))","v":35},10.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S65,TechNumber,2,FALSE))","v":""},"",24.5]
[null,61,"1M+S839473",2009,"COOPER",123819,90.95,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I66,TechNumber,2,FALSE))","v":26.5},26.5,316.56,1.2,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N66,TechNumber,2,FALSE))","v":26.5},31.799999999999997,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S66,TechNumber,2,FALSE))","v":""},"",58.3]
[null,62,"1M+S839477",2009,"COOPER",42268,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I67,TechNumber,2,FALSE))","v":""},"",135,1,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N67,TechNumber,2,FALSE))","v":27.5},27.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S67,TechNumber,2,FALSE))","v":""},"",27.5,1]
[null,63,"1M+S839480",2015,"COOPER",12540,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I68,TechNumber,2,FALSE))","v":""},"",119.95,2,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N68,TechNumber,2,FALSE))","v":23.5},47,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S68,TechNumber,2,FALSE))","v":""},"",47,1]
[null,64,"1M+S839487",2011,"COOPER",55705,31.41,0.4,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I69,TechNumber,2,FALSE))","v":31.5},12.600000000000001,108.75,0.75,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N69,TechNumber,2,FALSE))","v":31.5},23.625,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S69,TechNumber,2,FALSE))","v":""},"",36.225000000000001]
[null,65,"1M+S839483",2015,"COOPER",29721,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I70,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I70,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H70*J70),\"\",H70*J70)","v":""},119.95,2,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N70,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N70,TechNumber,2,FALSE))","v":23.5},{"$f":"IF(ISERROR(M70*O70),\" \",M70*O70)","v":47},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":""},47,1]
[null,66,"1M+S839496",2014,"COOPER",33487,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I71,TechNumber,2,FALSE))","v":""},"",119.95,2,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N71,TechNumber,2,FALSE))","v":27.5},55,145,1,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S71,TechNumber,2,FALSE))","v":27.5},27.5,{"$f":"SUM(U71,P71,K71)","v":82.5}]
[null,67,"1M+S839498",2011,"COOPER",58848,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I72,TechNumber,2,FALSE))","v":""},"",110,1.5,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N72,TechNumber,2,FALSE))","v":31},46.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S72,TechNumber,2,FALSE))","v":""},"",46.5]
[null,68,"1M+S839504",2011,"COOPER",40935,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I73,TechNumber,2,FALSE))","v":""},"",110,1.5,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N73,TechNumber,2,FALSE))","v":27},40.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S73,TechNumber,2,FALSE))","v":""},"",40.5]
[null,69,"1M+S839514",2015,"COOPER",37729,29.95,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I74,TechNumber,2,FALSE))","v":27.5},11,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":""},"",11]
[null,70,"1M+S839520",2013,"COOPER",25474,null,null,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":""}," ",217.5,1.5,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S75,TechNumber,2,FALSE))","v":35},52.5,52.5]
[null,71,"1M+S839522",2006,"COOPER",94279,31.41,0.4,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I76,TechNumber,2,FALSE))","v":27},10.8,90.95,1,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N76,TechNumber,2,FALSE))","v":27},27,499.5,3.7,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S76,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S76,TechNumber,2,FALSE))","v":27},99.9,137.70000000000002]
[null,72,"1M+S839525",2010,"COOPER",71590,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I77,TechNumber,2,FALSE))","v":""},"",135,1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N77,TechNumber,2,FALSE))","v":23.5},23.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S77,TechNumber,2,FALSE))","v":""},"",23.5]
[null,73,"1M+S839530",2011,"COOPER",82647,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I78,TechNumber,2,FALSE))","v":""},"",135,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N78,TechNumber,2,FALSE))","v":26.5},26.5,15,0.3,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S78,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S78,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,34.450000000000003]
[null,74,"1M+S839531",2011,"COOPER",41315,90.95,1,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I79,TechNumber,2,FALSE))","v":25},25,270,2,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N79,TechNumber,2,FALSE))","v":25},50,135,1,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S79,TechNumber,2,FALSE))","v":25},25,100]
[null,75,"1M+S839534",2009,"COOPER",86824,31.41,0.4,1489,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I80,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I80,TechNumber,2,FALSE))","v":19},7.6000000000000005,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":""},"",7.6000000000000005,1]
[null,76,"1M+S839535",2012,"COOPER",43245,31.41,0.4,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I81,TechNumber,2,FALSE))","v":25},10,73.5,0.7,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N81,TechNumber,2,FALSE))","v":25},17.5,207,1.8,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S81,TechNumber,2,FALSE))","v":25},45,72.5]
[null,77,"1M+S839539",2014,"COOPER",64860,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I82,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$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":""},"",0]
[null,78,"1M+S839541",2004,"COOPER",71649,31.41,0.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I83,TechNumber,2,FALSE))","v":27.5},11,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N83,TechNumber,2,FALSE))","v":""}," ",30,0.6,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S83,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S83,TechNumber,2,FALSE))","v":27.5},16.5,27.5]
[null,79,"1M+S839543",2013,"COOPER",10470,31.41,0.4,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I84,TechNumber,2,FALSE))","v":23.5},9.4,90.95,1,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N84,TechNumber,2,FALSE))","v":23.5},23.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S84,TechNumber,2,FALSE))","v":""},"",32.9]
[null,80,"1M+S839561",2014,"COOPER",38806,31.41,0.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I85,TechNumber,2,FALSE))","v":26.5},10.600000000000001,161,1.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N85,TechNumber,2,FALSE))","v":26.5},37.099999999999994,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S85,TechNumber,2,FALSE))","v":""},"",47.699999999999996]
[null,81,"1M+S839566",2012,"COOPER",44729,31.41,0.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I86,TechNumber,2,FALSE))","v":26.5},10.600000000000001,42,0.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N86,TechNumber,2,FALSE))","v":26.5},10.600000000000001,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S86,TechNumber,2,FALSE))","v":""},"",21.200000000000003]
[null,82,"1M+S839573",2016,"COOPER",33660,25,0.3,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I87,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,119.95,2,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N87,TechNumber,2,FALSE))","v":26.5},53,75,0.9,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S87,TechNumber,2,FALSE))","v":26.5},23.85,84.8]
[null,83,"1M+S839229",2005,"COOPER",157089,31.41,0.4,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I88,TechNumber,2,FALSE))","v":23.5},9.4,{"$f":"92+162","v":254},1.8,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N88,TechNumber,2,FALSE))","v":23.5},42.300000000000004,567,4.2,1278,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S88,TechNumber,2,FALSE))","v":23.5},98.7,150.4]
[null,84,"1M+S839270",2012,"COOPER",50884,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":""}," ",87,0.6,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S89,TechNumber,2,FALSE))","v":31},18.599999999999998,18.599999999999998,1]
[null,85,"1M+S839279",2012,"COOPER",50421,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I90,TechNumber,2,FALSE))","v":""},"",391.5,2.7,494,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N90,TechNumber,2,FALSE))","v":31.5},85.050000000000011,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S90,TechNumber,2,FALSE))","v":""},"",85.050000000000011,1]
[null,86,"1M+S839287",2011,"COOPER",61709,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I91,TechNumber,2,FALSE))","v":26.5},10.600000000000001,73,0.7,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N91,TechNumber,2,FALSE))","v":26.5},18.549999999999997,540,4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S91,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S91,TechNumber,2,FALSE))","v":26.5},106,135.15]
[null,87,"1M+S839294",2010,"COOPER",75011,25,0.3,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I92,TechNumber,2,FALSE))","v":26.5},7.9499999999999993,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N92,TechNumber,2,FALSE))","v":""}," ",189,1.4,913,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S92,TechNumber,2,FALSE))","v":26.5},37.099999999999994,45.05]
[null,88,"1M+S839311",2015,"COOPER",28327,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I93,TechNumber,2,FALSE))","v":""},"",null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N93,TechNumber,2,FALSE))","v":""}," ",232,1.6,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S93,TechNumber,2,FALSE))","v":26.5},42.400000000000006,42.400000000000006]
[null,89,"1M+S836347",2014,"COOPER",55688,{"$f":"31.41+49.95","v":81.36},1,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I94,TechNumber,2,FALSE))","v":25},25,{"$f":"60+73.5","v":133.5},1.5,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N94,TechNumber,2,FALSE))","v":25},37.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S94,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S94,TechNumber,2,FALSE))","v":""},"",62.5]
[null,90,"1M+S839351",2013,"COOPER",83420,31.41,0.4,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I95,TechNumber,2,FALSE))","v":26.5},10.600000000000001,90.95,1,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N95,TechNumber,2,FALSE))","v":26.5},26.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S95,TechNumber,2,FALSE))","v":""},"",37.1]
[null,91,"1M+S839294",2010,"COOPER",75011,229.5,1.7,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I96,TechNumber,2,FALSE))","v":27.5},46.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N96,TechNumber,2,FALSE))","v":""}," ",864,6.4,1317,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S96,TechNumber,2,FALSE))","v":27.5},176,222.75]
[null,92,"1M+S839365",2012,"COOPER",53536,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I97,TechNumber,2,FALSE))","v":""},"",217.5,1.5,1441,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N97,TechNumber,2,FALSE))","v":26.5},39.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S97,TechNumber,2,FALSE))","v":""},"",39.75,1]
[null,93,"1M+S839360",2008,"COOPER",93246,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I98,TechNumber,2,FALSE))","v":""},"",217.5,1.5,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N98,TechNumber,2,FALSE))","v":31},46.5,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S98,TechNumber,2,FALSE))","v":""},"",46.5,1]
[null,94,"1M+S839378",2011,"COOPER",3,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I99,TechNumber,2,FALSE))","v":""},"",378,2.8,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N99,TechNumber,2,FALSE))","v":31},86.8,756,5.6,940,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S99,TechNumber,2,FALSE))","v":31},173.6,260.39999999999998]
[null,95,"1M+S839408",2011,"COOPER",51721,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I100,TechNumber,2,FALSE))","v":""},"",540,4,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N100,TechNumber,2,FALSE))","v":27},108,270,2,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S100,TechNumber,2,FALSE))","v":27},54,162]
[null,96,"1M+S839427",2007,"COOPER",105224,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I101,TechNumber,2,FALSE))","v":""},"",90.95,1,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N101,TechNumber,2,FALSE))","v":25},25,472.5,3.5,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S101,TechNumber,2,FALSE))","v":25},87.5,112.5]
[null,97,"1M+S839448",2012,"COOPER",46168,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I102,TechNumber,2,FALSE))","v":""},"",86.25,0.75,1335,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N102,TechNumber,2,FALSE))","v":25},18.75,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S102,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S102,TechNumber,2,FALSE))","v":""},"",18.75,1]
[null,98,"1M+S839450",2008,"COOPER",35155,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I103,TechNumber,2,FALSE))","v":""},"",90.95,0.3,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N103,TechNumber,2,FALSE))","v":35},10.5,189,1.4,774,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$S103,TechNumber,2,FALSE))","v":35},49,59.5]
[null,99,"1M+S839452",2009,"COOPER",91119,90.95,1,1489,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I104,TechNumber,2,FALSE))","v":19},19,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":""},"",19,1]
[null,100,"1M+S839462",2011,"COOPER",76633,null,null,null,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$I105,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$I105,TechNumber,2,FALSE))","v":""},{"$f":"IF(ISERROR(H105*J105),\"\",H105*J105)","v":""},{"$f":"189+432","v":621},4.5999999999999996,464,{"$f":"IF(ISERROR(VLOOKUP('Input Sheet'!$N105,TechNumber,2,FALSE)),\"\",VLOOKUP('Input Sheet'!$N105,TechNumber,2,FALSE))","v":27},{"$f":"IF(ISERROR(M105*O105),\" \",M105*O105)","v":124.19999999999999},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":""},124.19999999999999,1]
[null,null,null,null,"Totals","Totals",{"$f":"SUM(G6:G105)","v":3737.8099999999986},{"$f":"SUM(H6:H105)","v":34.199999999999982},null,null,{"$f":"SUM(K6:K105)","v":921.8},11515.010000000002,100.60000000000001,null,null,2752.1750000000002,11277,84.2,null,null,2344.1,6018.0749999999989,{"$f":"COUNTIF(W5:W105,1)","v":26}]
[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":21,"rows_kept":65,"cut":false,"hidden":false,"merged":[[2,19,4,19],[3,11,4,11],[3,18,4,18],[3,16,4,16],[3,17,4,17],[56,20,58,20],[57,4,58,4],[57,5,58,5],[57,6,58,6],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,11],[57,12,58,12],[56,19,58,19],[57,13,58,13],[57,14,58,14],[57,15,58,15],[57,16,58,16],[57,17,58,17],[57,18,58,18],[56,4,56,8],[56,9,56,13],[56,14,56,18],[3,12,4,12],[3,13,4,13],[3,14,4,14],[1,0,1,3],[0,0,0,20],[3,7,4,7],[3,8,4,8],[3,9,4,9],[3,10,4,10],[3,0,4,0],[3,4,4,4],[3,5,4,5],[3,6,4,6],[3,15,4,15],[2,20,4,20],[2,0,2,3],[1,4,2,8],[1,9,2,13],[1,14,2,18]]}
["Repair Order Analysis"]
[null,null,null,null,"Competitive Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor"]
["Dealership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["RO Number",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[null,"Year","Model ","Mileage"]
[{"$f":"'Input Sheet'!C6","v":"1M+S838485  (1)"},{"$f":"'Input Sheet'!D6","v":2011},{"$f":"'Input Sheet'!E6","v":"COUNTRYMAN"},{"$f":"'Input Sheet'!F6","v":65926},{"$f":"'Input Sheet'!G6","v":189},{"$f":"'Input Sheet'!H6","v":1.4},{"$f":"'Input Sheet'!I6","v":1278},{"$f":"'Input Sheet'!J6","v":23.5},{"$f":"F6*H6","v":32.9},{"$f":"'Input Sheet'!L6","v":0},{"$f":"'Input Sheet'!M6","v":0},{"$f":"'Input Sheet'!I6","v":1278},{"$f":"'Input Sheet'!J6","v":23.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":32.9},{"$f":"'Input Sheet'!W6","v":1}]
[{"$f":"'Input Sheet'!C7","v":"1M+S838487  (2)"},{"$f":"'Input Sheet'!D7","v":2013},{"$f":"'Input Sheet'!E7","v":"COOPER"},{"$f":"'Input Sheet'!F7","v":50693},{"$f":"'Input Sheet'!G7","v":0},{"$f":"'Input Sheet'!H7","v":0},{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":""},{"$f":"F7*H7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L7","v":135},{"$f":"'Input Sheet'!M7","v":1},{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":""},{"$f":"K7*M7","v":{"$error":"#VALUE!"}},{"$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":31},{"$f":"'Input Sheet'!W7","v":0}]
[{"$f":"'Input Sheet'!C8","v":"1M+S838488  (3)"},{"$f":"'Input Sheet'!D8","v":2011},{"$f":"'Input Sheet'!E8","v":"COOPER"},{"$f":"'Input Sheet'!F8","v":58686},{"$f":"'Input Sheet'!G8","v":0},{"$f":"'Input Sheet'!H8","v":0},{"$f":"'Input Sheet'!I8","v":0},{"$f":"'Input Sheet'!J8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L8","v":297},{"$f":"'Input Sheet'!M8","v":2.2000000000000002},{"$f":"'Input Sheet'!I8","v":0},{"$f":"'Input Sheet'!J8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q8","v":0},{"$f":"'Input Sheet'!R8","v":0},{"$f":"'Input Sheet'!S8","v":0},{"$f":"'Input Sheet'!T8","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V8","v":55.000000000000007},{"$f":"'Input Sheet'!W8","v":0}]
[{"$f":"'Input Sheet'!C9","v":"1M+S838494"},{"$f":"'Input Sheet'!D9","v":2017},{"$f":"'Input Sheet'!E9","v":"COOPER"},{"$f":"'Input Sheet'!F9","v":11663},{"$f":"'Input Sheet'!G9","v":0},{"$f":"'Input Sheet'!H9","v":0},{"$f":"'Input Sheet'!I9","v":0},{"$f":"'Input Sheet'!J9","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L9","v":0},{"$f":"'Input Sheet'!M9","v":0},{"$f":"'Input Sheet'!I9","v":0},{"$f":"'Input Sheet'!J9","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q9","v":55},{"$f":"'Input Sheet'!R9","v":0.5},{"$f":"'Input Sheet'!S9","v":988},{"$f":"'Input Sheet'!T9","v":13},6.5,{"$f":"'Input Sheet'!V9","v":6.5},{"$f":"'Input Sheet'!W9","v":1}]
[{"$f":"'Input Sheet'!C10","v":"1M+S838496"},{"$f":"'Input Sheet'!D10","v":2011},{"$f":"'Input Sheet'!E10","v":"COOPER"},{"$f":"'Input Sheet'!F10","v":52709},{"$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":472.5},{"$f":"'Input Sheet'!R10","v":3.5},{"$f":"'Input Sheet'!S10","v":940},{"$f":"'Input Sheet'!T10","v":31},108.5,{"$f":"'Input Sheet'!V10","v":108.5},{"$f":"'Input Sheet'!W10","v":0}]
[{"$f":"'Input Sheet'!C11","v":"1M+S838511"},{"$f":"'Input Sheet'!D11","v":2011},{"$f":"'Input Sheet'!E11","v":"COOPER"},{"$f":"'Input Sheet'!F11","v":79203},{"$f":"'Input Sheet'!G11","v":0},{"$f":"'Input Sheet'!H11","v":0},{"$f":"'Input Sheet'!I11","v":0},{"$f":"'Input Sheet'!J11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L11","v":162},{"$f":"'Input Sheet'!M11","v":1.2},{"$f":"'Input Sheet'!I11","v":0},{"$f":"'Input Sheet'!J11","v":""},{"$error":"#VALUE!"},{"$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":33},{"$f":"'Input Sheet'!W11","v":0}]
[{"$f":"'Input Sheet'!C12","v":"1M+S838505"},{"$f":"'Input Sheet'!D12","v":2014},{"$f":"'Input Sheet'!E12","v":"COOPER"},{"$f":"'Input Sheet'!F12","v":18063},{"$f":"'Input Sheet'!G12","v":31.41},{"$f":"'Input Sheet'!H12","v":0.4},{"$f":"'Input Sheet'!I12","v":1441},{"$f":"'Input Sheet'!J12","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L12","v":90.95},{"$f":"'Input Sheet'!M12","v":1},{"$f":"'Input Sheet'!I12","v":1441},{"$f":"'Input Sheet'!J12","v":26.5},26.5,{"$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":37.1},{"$f":"'Input Sheet'!W12","v":0}]
[{"$f":"'Input Sheet'!C13","v":"1M+s838512"},{"$f":"'Input Sheet'!D13","v":2010},{"$f":"'Input Sheet'!E13","v":"COOPER"},{"$f":"'Input Sheet'!F13","v":65759},{"$f":"'Input Sheet'!G13","v":31.41},{"$f":"'Input Sheet'!H13","v":0.4},{"$f":"'Input Sheet'!I13","v":1441},{"$f":"'Input Sheet'!J13","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L13","v":0},{"$f":"'Input Sheet'!M13","v":0},{"$f":"'Input Sheet'!I13","v":1441},{"$f":"'Input Sheet'!J13","v":26.5},0,{"$f":"'Input Sheet'!Q13","v":504},{"$f":"'Input Sheet'!R13","v":3.6},{"$f":"'Input Sheet'!S13","v":1441},{"$f":"'Input Sheet'!T13","v":26.5},95.4,{"$f":"'Input Sheet'!V13","v":106},{"$f":"'Input Sheet'!W13","v":0}]
[{"$f":"'Input Sheet'!C14","v":"1M+S838518"},{"$f":"'Input Sheet'!D14","v":2016},{"$f":"'Input Sheet'!E14","v":"COOPER"},{"$f":"'Input Sheet'!F14","v":5123},{"$f":"'Input Sheet'!G14","v":49.95},{"$f":"'Input Sheet'!H14","v":0.6},{"$f":"'Input Sheet'!I14","v":913},{"$f":"'Input Sheet'!J14","v":26.5},15.899999999999999,{"$f":"'Input Sheet'!L14","v":0},{"$f":"'Input Sheet'!M14","v":0},{"$f":"'Input Sheet'!I14","v":913},{"$f":"'Input Sheet'!J14","v":26.5},0,{"$f":"'Input Sheet'!Q14","v":0},{"$f":"'Input Sheet'!R14","v":0},{"$f":"'Input Sheet'!S14","v":0},{"$f":"'Input Sheet'!T14","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V14","v":15.899999999999999},{"$f":"'Input Sheet'!W14","v":1}]
[{"$f":"'Input Sheet'!C15","v":"1M+S838519"},{"$f":"'Input Sheet'!D15","v":2013},{"$f":"'Input Sheet'!E15","v":"COOPER"},{"$f":"'Input Sheet'!F15","v":34013},{"$f":"'Input Sheet'!G15","v":31.41},{"$f":"'Input Sheet'!H15","v":0.4},{"$f":"'Input Sheet'!I15","v":1335},{"$f":"'Input Sheet'!J15","v":25},10,{"$f":"'Input Sheet'!L15","v":161},{"$f":"'Input Sheet'!M15","v":1.4},{"$f":"'Input Sheet'!I15","v":1335},{"$f":"'Input Sheet'!J15","v":25},35,{"$f":"'Input Sheet'!Q15","v":0},{"$f":"'Input Sheet'!R15","v":0},{"$f":"'Input Sheet'!S15","v":0},{"$f":"'Input Sheet'!T15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V15","v":45},{"$f":"'Input Sheet'!W15","v":0}]
[{"$f":"'Input Sheet'!C16","v":"1M+S838528"},{"$f":"'Input Sheet'!D16","v":2015},{"$f":"'Input Sheet'!E16","v":"COOPER"},{"$f":"'Input Sheet'!F16","v":47094},{"$f":"'Input Sheet'!G16","v":29.95},{"$f":"'Input Sheet'!H16","v":0.4},{"$f":"'Input Sheet'!I16","v":1317},{"$f":"'Input Sheet'!J16","v":27.5},11,{"$f":"'Input Sheet'!L16","v":86.25},{"$f":"'Input Sheet'!M16","v":0.75},{"$f":"'Input Sheet'!I16","v":1317},{"$f":"'Input Sheet'!J16","v":27.5},20.625,{"$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":31.625},{"$f":"'Input Sheet'!W16","v":0}]
[{"$f":"'Input Sheet'!C17","v":"1M+S838531"},{"$f":"'Input Sheet'!D17","v":2013},{"$f":"'Input Sheet'!E17","v":"COOPER"},{"$f":"'Input Sheet'!F17","v":42970},{"$f":"'Input Sheet'!G17","v":5},{"$f":"'Input Sheet'!H17","v":0.1},{"$f":"'Input Sheet'!I17","v":940},{"$f":"'Input Sheet'!J17","v":31},3.1,{"$f":"'Input Sheet'!L17","v":0},{"$f":"'Input Sheet'!M17","v":0},{"$f":"'Input Sheet'!I17","v":940},{"$f":"'Input Sheet'!J17","v":31},0,{"$f":"'Input Sheet'!Q17","v":0},{"$f":"'Input Sheet'!R17","v":0},{"$f":"'Input Sheet'!S17","v":0},{"$f":"'Input Sheet'!T17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V17","v":3.1},{"$f":"'Input Sheet'!W17","v":0}]
[{"$f":"'Input Sheet'!C18","v":"1M+S838537"},{"$f":"'Input Sheet'!D18","v":2010},{"$f":"'Input Sheet'!E18","v":"COOPER"},{"$f":"'Input Sheet'!F18","v":111780},{"$f":"'Input Sheet'!G18","v":31.41},{"$f":"'Input Sheet'!H18","v":0.4},{"$f":"'Input Sheet'!I18","v":1317},{"$f":"'Input Sheet'!J18","v":27.5},11,{"$f":"'Input Sheet'!L18","v":189},{"$f":"'Input Sheet'!M18","v":1.9},{"$f":"'Input Sheet'!I18","v":1317},{"$f":"'Input Sheet'!J18","v":27.5},52.25,{"$f":"'Input Sheet'!Q18","v":297},{"$f":"'Input Sheet'!R18","v":2.2000000000000002},{"$f":"'Input Sheet'!S18","v":1317},{"$f":"'Input Sheet'!T18","v":27.5},60.500000000000007,{"$f":"'Input Sheet'!V18","v":123.75},{"$f":"'Input Sheet'!W18","v":0}]
[{"$f":"'Input Sheet'!C19","v":"1M+S838544"},{"$f":"'Input Sheet'!D19","v":2008},{"$f":"'Input Sheet'!E19","v":"COOPER"},{"$f":"'Input Sheet'!F19","v":47414},{"$f":"'Input Sheet'!G19","v":31.41},{"$f":"'Input Sheet'!H19","v":0.4},{"$f":"'Input Sheet'!I19","v":913},{"$f":"'Input Sheet'!J19","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L19","v":86.25},{"$f":"'Input Sheet'!M19","v":0.75},{"$f":"'Input Sheet'!I19","v":913},{"$f":"'Input Sheet'!J19","v":26.5},19.875,{"$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":30.475000000000001},{"$f":"'Input Sheet'!W19","v":0}]
[{"$f":"'Input Sheet'!C20","v":"1M+S838560"},{"$f":"'Input Sheet'!D20","v":2006},{"$f":"'Input Sheet'!E20","v":"COOPER"},{"$f":"'Input Sheet'!F20","v":20660},{"$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":119.95},{"$f":"'Input Sheet'!M20","v":0.2},{"$f":"'Input Sheet'!I20","v":0},{"$f":"'Input Sheet'!J20","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q20","v":756},{"$f":"'Input Sheet'!R20","v":5.6},{"$f":"'Input Sheet'!S20","v":1317},{"$f":"'Input Sheet'!T20","v":27.5},154,{"$f":"'Input Sheet'!V20","v":159.5},{"$f":"'Input Sheet'!W20","v":0}]
[{"$f":"'Input Sheet'!C21","v":"1M+S838563"},{"$f":"'Input Sheet'!D21","v":2009},{"$f":"'Input Sheet'!E21","v":"COOPER"},{"$f":"'Input Sheet'!F21","v":35579},{"$f":"'Input Sheet'!G21","v":29.95},{"$f":"'Input Sheet'!H21","v":0.5},{"$f":"'Input Sheet'!I21","v":940},{"$f":"'Input Sheet'!J21","v":31},15.5,{"$f":"'Input Sheet'!L21","v":0},{"$f":"'Input Sheet'!M21","v":0},{"$f":"'Input Sheet'!I21","v":940},{"$f":"'Input Sheet'!J21","v":31},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":15.5},{"$f":"'Input Sheet'!W21","v":1}]
[{"$f":"'Input Sheet'!C22","v":"1M+S838567"},{"$f":"'Input Sheet'!D22","v":2014},{"$f":"'Input Sheet'!E22","v":"COOPER"},{"$f":"'Input Sheet'!F22","v":29142},{"$f":"'Input Sheet'!G22","v":119.95},{"$f":"'Input Sheet'!H22","v":0.2},{"$f":"'Input Sheet'!I22","v":940},{"$f":"'Input Sheet'!J22","v":31},6.2,{"$f":"'Input Sheet'!L22","v":0},{"$f":"'Input Sheet'!M22","v":0},{"$f":"'Input Sheet'!I22","v":940},{"$f":"'Input Sheet'!J22","v":31},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":6.2},{"$f":"'Input Sheet'!W22","v":1}]
[{"$f":"'Input Sheet'!C23","v":"1M+S838574"},{"$f":"'Input Sheet'!D23","v":2004},{"$f":"'Input Sheet'!E23","v":"COOPER"},{"$f":"'Input Sheet'!F23","v":10800},{"$f":"'Input Sheet'!G23","v":31.41},{"$f":"'Input Sheet'!H23","v":0.4},{"$f":"'Input Sheet'!I23","v":494},{"$f":"'Input Sheet'!J23","v":31.5},12.600000000000001,{"$f":"'Input Sheet'!L23","v":81},{"$f":"'Input Sheet'!M23","v":0.6},{"$f":"'Input Sheet'!I23","v":494},{"$f":"'Input Sheet'!J23","v":31.5},18.899999999999999,{"$f":"'Input Sheet'!Q23","v":0},{"$f":"'Input Sheet'!R23","v":0},{"$f":"'Input Sheet'!S23","v":0},{"$f":"'Input Sheet'!T23","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V23","v":31.5},{"$f":"'Input Sheet'!W23","v":0}]
[{"$f":"'Input Sheet'!C24","v":"1M+S838575"},{"$f":"'Input Sheet'!D24","v":2016},{"$f":"'Input Sheet'!E24","v":"COOPER"},{"$f":"'Input Sheet'!F24","v":2721},{"$f":"'Input Sheet'!G24","v":25},{"$f":"'Input Sheet'!H24","v":0.3},{"$f":"'Input Sheet'!I24","v":1441},{"$f":"'Input Sheet'!J24","v":26.5},7.9499999999999993,{"$f":"'Input Sheet'!L24","v":0},{"$f":"'Input Sheet'!M24","v":0},{"$f":"'Input Sheet'!I24","v":1441},{"$f":"'Input Sheet'!J24","v":26.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":7.9499999999999993},{"$f":"'Input Sheet'!W24","v":1}]
[{"$f":"'Input Sheet'!C25","v":"1M+S838577"},{"$f":"'Input Sheet'!D25","v":2013},{"$f":"'Input Sheet'!E25","v":"COOPER"},{"$f":"'Input Sheet'!F25","v":62359},{"$f":"'Input Sheet'!G25","v":29.95},{"$f":"'Input Sheet'!H25","v":0.5},{"$f":"'Input Sheet'!I25","v":1335},{"$f":"'Input Sheet'!J25","v":25},12.5,{"$f":"'Input Sheet'!L25","v":0},{"$f":"'Input Sheet'!M25","v":0},{"$f":"'Input Sheet'!I25","v":1335},{"$f":"'Input Sheet'!J25","v":25},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":12.5},{"$f":"'Input Sheet'!W25","v":1}]
[{"$f":"'Input Sheet'!C26","v":"1M+S838579"},{"$f":"'Input Sheet'!D26","v":2013},{"$f":"'Input Sheet'!E26","v":"COOPER"},{"$f":"'Input Sheet'!F26","v":86197},{"$f":"'Input Sheet'!G26","v":31.41},{"$f":"'Input Sheet'!H26","v":0.4},{"$f":"'Input Sheet'!I26","v":913},{"$f":"'Input Sheet'!J26","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L26","v":207},{"$f":"'Input Sheet'!M26","v":1.8},{"$f":"'Input Sheet'!I26","v":913},{"$f":"'Input Sheet'!J26","v":26.5},47.7,{"$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":58.300000000000004},{"$f":"'Input Sheet'!W26","v":0}]
[{"$f":"'Input Sheet'!C27","v":"1M+S838584"},{"$f":"'Input Sheet'!D27","v":2010},{"$f":"'Input Sheet'!E27","v":"COOPER"},{"$f":"'Input Sheet'!F27","v":56719},{"$f":"'Input Sheet'!G27","v":81},{"$f":"'Input Sheet'!H27","v":0.6},{"$f":"'Input Sheet'!I27","v":940},{"$f":"'Input Sheet'!J27","v":31},18.599999999999998,{"$f":"'Input Sheet'!L27","v":0},{"$f":"'Input Sheet'!M27","v":0},{"$f":"'Input Sheet'!I27","v":940},{"$f":"'Input Sheet'!J27","v":31},0,{"$f":"'Input Sheet'!Q27","v":0},{"$f":"'Input Sheet'!R27","v":0},{"$f":"'Input Sheet'!S27","v":0},{"$f":"'Input Sheet'!T27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V27","v":18.599999999999998},{"$f":"'Input Sheet'!W27","v":1}]
[{"$f":"'Input Sheet'!C28","v":"1M+S838588"},{"$f":"'Input Sheet'!D28","v":2005},{"$f":"'Input Sheet'!E28","v":"COOPER"},{"$f":"'Input Sheet'!F28","v":40625},{"$f":"'Input Sheet'!G28","v":31.41},{"$f":"'Input Sheet'!H28","v":0.4},{"$f":"'Input Sheet'!I28","v":1317},{"$f":"'Input Sheet'!J28","v":27.5},11,{"$f":"'Input Sheet'!L28","v":67.5},{"$f":"'Input Sheet'!M28","v":0.5},{"$f":"'Input Sheet'!I28","v":1317},{"$f":"'Input Sheet'!J28","v":27.5},13.75,{"$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":24.75},{"$f":"'Input Sheet'!W28","v":0}]
[{"$f":"'Input Sheet'!C29","v":"1M+S838486   (5)"},{"$f":"'Input Sheet'!D29","v":2014},{"$f":"'Input Sheet'!E29","v":"COOPER"},{"$f":"'Input Sheet'!F29","v":29368},{"$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":178},{"$f":"'Input Sheet'!M29","v":0.8},{"$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":22},{"$f":"'Input Sheet'!W29","v":0}]
[{"$f":"'Input Sheet'!C30","v":"1M+S838492  (4)"},{"$f":"'Input Sheet'!D30","v":2017},{"$f":"'Input Sheet'!E30","v":"cooper"},{"$f":"'Input Sheet'!F30","v":7362},{"$f":"'Input Sheet'!G30","v":25},{"$f":"'Input Sheet'!H30","v":0.3},{"$f":"'Input Sheet'!I30","v":913},{"$f":"'Input Sheet'!J30","v":26.5},7.9499999999999993,{"$f":"'Input Sheet'!L30","v":119.95},{"$f":"'Input Sheet'!M30","v":0.2},{"$f":"'Input Sheet'!I30","v":913},{"$f":"'Input Sheet'!J30","v":26.5},5.3000000000000007,{"$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":13.25},{"$f":"'Input Sheet'!W30","v":0}]
[{"$f":"'Input Sheet'!C31","v":"1M+S838966"},{"$f":"'Input Sheet'!D31","v":2008},{"$f":"'Input Sheet'!E31","v":"COOPER"},{"$f":"'Input Sheet'!F31","v":80052},{"$f":"'Input Sheet'!G31","v":270},{"$f":"'Input Sheet'!H31","v":2},{"$f":"'Input Sheet'!I31","v":494},{"$f":"'Input Sheet'!J31","v":31.5},63,{"$f":"'Input Sheet'!L31","v":0},{"$f":"'Input Sheet'!M31","v":0},{"$f":"'Input Sheet'!I31","v":494},{"$f":"'Input Sheet'!J31","v":31.5},0,{"$f":"'Input Sheet'!Q31","v":0},{"$f":"'Input Sheet'!R31","v":0},{"$f":"'Input Sheet'!S31","v":0},{"$f":"'Input Sheet'!T31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V31","v":63},{"$f":"'Input Sheet'!W31","v":0}]
[{"$f":"'Input Sheet'!C32","v":"1M+S839190"},{"$f":"'Input Sheet'!D32","v":2004},{"$f":"'Input Sheet'!E32","v":"COOPER"},{"$f":"'Input Sheet'!F32","v":65651},{"$f":"'Input Sheet'!G32","v":31.41},{"$f":"'Input Sheet'!H32","v":0.4},{"$f":"'Input Sheet'!I32","v":494},{"$f":"'Input Sheet'!J32","v":31.5},12.600000000000001,{"$f":"'Input Sheet'!L32","v":648},{"$f":"'Input Sheet'!M32","v":4.8},{"$f":"'Input Sheet'!I32","v":494},{"$f":"'Input Sheet'!J32","v":31.5},151.19999999999999,{"$f":"'Input Sheet'!Q32","v":756},{"$f":"'Input Sheet'!R32","v":5.6},{"$f":"'Input Sheet'!S32","v":494},{"$f":"'Input Sheet'!T32","v":31.5},176.39999999999998,{"$f":"'Input Sheet'!V32","v":340.2},{"$f":"'Input Sheet'!W32","v":0}]
[{"$f":"'Input Sheet'!C33","v":"1M+S839204"},{"$f":"'Input Sheet'!D33","v":2012},{"$f":"'Input Sheet'!E33","v":"COOPER"},{"$f":"'Input Sheet'!F33","v":15605},{"$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":119},{"$f":"'Input Sheet'!M33","v":2},{"$f":"'Input Sheet'!I33","v":0},{"$f":"'Input Sheet'!J33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q33","v":0},{"$f":"'Input Sheet'!R33","v":0},{"$f":"'Input Sheet'!S33","v":0},{"$f":"'Input Sheet'!T33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V33","v":63},{"$f":"'Input Sheet'!W33","v":0}]
[{"$f":"'Input Sheet'!C34","v":"1M+S839211"},{"$f":"'Input Sheet'!D34","v":2017},{"$f":"'Input Sheet'!E34","v":"COOPER"},{"$f":"'Input Sheet'!F34","v":14637},{"$f":"'Input Sheet'!G34","v":49.95},{"$f":"'Input Sheet'!H34","v":0.6},{"$f":"'Input Sheet'!I34","v":1278},{"$f":"'Input Sheet'!J34","v":23.5},14.1,{"$f":"'Input Sheet'!L34","v":0},{"$f":"'Input Sheet'!M34","v":0},{"$f":"'Input Sheet'!I34","v":1278},{"$f":"'Input Sheet'!J34","v":23.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":14.1},{"$f":"'Input Sheet'!W34","v":1}]
[{"$f":"'Input Sheet'!C35","v":"1M+S839237"},{"$f":"'Input Sheet'!D35","v":2015},{"$f":"'Input Sheet'!E35","v":"COOPER"},{"$f":"'Input Sheet'!F35","v":23451},{"$f":"'Input Sheet'!G35","v":49.95},{"$f":"'Input Sheet'!H35","v":0.6},{"$f":"'Input Sheet'!I35","v":1335},{"$f":"'Input Sheet'!J35","v":25},15,{"$f":"'Input Sheet'!L35","v":119.95},{"$f":"'Input Sheet'!M35","v":2},{"$f":"'Input Sheet'!I35","v":1335},{"$f":"'Input Sheet'!J35","v":25},50,{"$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":65},{"$f":"'Input Sheet'!W35","v":0}]
[{"$f":"'Input Sheet'!C36","v":"1M+S839250"},{"$f":"'Input Sheet'!D36","v":2009},{"$f":"'Input Sheet'!E36","v":"COOPER"},{"$f":"'Input Sheet'!F36","v":90202},{"$f":"'Input Sheet'!G36","v":0},{"$f":"'Input Sheet'!H36","v":0},{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L36","v":540},{"$f":"'Input Sheet'!M36","v":4},{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q36","v":297},{"$f":"'Input Sheet'!R36","v":2.2000000000000002},{"$f":"'Input Sheet'!S36","v":913},{"$f":"'Input Sheet'!T36","v":26.5},58.300000000000004,{"$f":"'Input Sheet'!V36","v":164.3},{"$f":"'Input Sheet'!W36","v":0}]
[{"$f":"'Input Sheet'!C37","v":"1M+S839277"},{"$f":"'Input Sheet'!D37","v":2009},{"$f":"'Input Sheet'!E37","v":"COOPER"},{"$f":"'Input Sheet'!F37","v":95260},{"$f":"'Input Sheet'!G37","v":49.95},{"$f":"'Input Sheet'!H37","v":0.6},{"$f":"'Input Sheet'!I37","v":1335},{"$f":"'Input Sheet'!J37","v":25},15,{"$f":"'Input Sheet'!L37","v":0},{"$f":"'Input Sheet'!M37","v":0},{"$f":"'Input Sheet'!I37","v":1335},{"$f":"'Input Sheet'!J37","v":25},0,{"$f":"'Input Sheet'!Q37","v":1256},{"$f":"'Input Sheet'!R37","v":9.3000000000000007},{"$f":"'Input Sheet'!S37","v":1335},{"$f":"'Input Sheet'!T37","v":25},232.50000000000003,{"$f":"'Input Sheet'!V37","v":247.50000000000003},{"$f":"'Input Sheet'!W37","v":0}]
[{"$f":"'Input Sheet'!C38","v":"1M+S839285"},{"$f":"'Input Sheet'!D38","v":2012},{"$f":"'Input Sheet'!E38","v":"COOPER"},{"$f":"'Input Sheet'!F38","v":42390},{"$f":"'Input Sheet'!G38","v":49.95},{"$f":"'Input Sheet'!H38","v":0.6},{"$f":"'Input Sheet'!I38","v":913},{"$f":"'Input Sheet'!J38","v":26.5},15.899999999999999,{"$f":"'Input Sheet'!L38","v":0},{"$f":"'Input Sheet'!M38","v":0},{"$f":"'Input Sheet'!I38","v":913},{"$f":"'Input Sheet'!J38","v":26.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":15.899999999999999},{"$f":"'Input Sheet'!W38","v":1}]
[{"$f":"'Input Sheet'!C39","v":"1M+S839286"},{"$f":"'Input Sheet'!D39","v":2013},{"$f":"'Input Sheet'!E39","v":"COOPER"},{"$f":"'Input Sheet'!F39","v":52853},{"$f":"'Input Sheet'!G39","v":49.95},{"$f":"'Input Sheet'!H39","v":0.6},{"$f":"'Input Sheet'!I39","v":1317},{"$f":"'Input Sheet'!J39","v":27.5},16.5,{"$f":"'Input Sheet'!L39","v":63},{"$f":"'Input Sheet'!M39","v":0.6},{"$f":"'Input Sheet'!I39","v":1317},{"$f":"'Input Sheet'!J39","v":27.5},16.5,{"$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":33},{"$f":"'Input Sheet'!W39","v":0}]
[{"$f":"'Input Sheet'!C40","v":"1M+S839290"},{"$f":"'Input Sheet'!D40","v":2015},{"$f":"'Input Sheet'!E40","v":"COOPER"},{"$f":"'Input Sheet'!F40","v":32789},{"$f":"'Input Sheet'!G40","v":0},{"$f":"'Input Sheet'!H40","v":0},{"$f":"'Input Sheet'!I40","v":0},{"$f":"'Input Sheet'!J40","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L40","v":100},{"$f":"'Input Sheet'!M40","v":1.2},{"$f":"'Input Sheet'!I40","v":0},{"$f":"'Input Sheet'!J40","v":""},{"$error":"#VALUE!"},{"$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":32.4},{"$f":"'Input Sheet'!W40","v":1}]
[{"$f":"'Input Sheet'!C41","v":"1M+S839293"},{"$f":"'Input Sheet'!D41","v":2012},{"$f":"'Input Sheet'!E41","v":"COOPER"},{"$f":"'Input Sheet'!F41","v":49461},{"$f":"'Input Sheet'!G41","v":31.41},{"$f":"'Input Sheet'!H41","v":0.4},{"$f":"'Input Sheet'!I41","v":464},{"$f":"'Input Sheet'!J41","v":27},10.8,{"$f":"'Input Sheet'!L41","v":72.5},{"$f":"'Input Sheet'!M41","v":0.5},{"$f":"'Input Sheet'!I41","v":464},{"$f":"'Input Sheet'!J41","v":27},13.5,{"$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":24.3},{"$f":"'Input Sheet'!W41","v":0}]
[{"$f":"'Input Sheet'!C42","v":"1M+S839295"},{"$f":"'Input Sheet'!D42","v":2012},{"$f":"'Input Sheet'!E42","v":"COOPER"},{"$f":"'Input Sheet'!F42","v":60644},{"$f":"'Input Sheet'!G42","v":24.9},{"$f":"'Input Sheet'!H42","v":0.2},{"$f":"'Input Sheet'!I42","v":940},{"$f":"'Input Sheet'!J42","v":31},6.2,{"$f":"'Input Sheet'!L42","v":348},{"$f":"'Input Sheet'!M42","v":2.4},{"$f":"'Input Sheet'!I42","v":940},{"$f":"'Input Sheet'!J42","v":31},74.399999999999991,{"$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":80.599999999999994},{"$f":"'Input Sheet'!W42","v":0}]
[{"$f":"'Input Sheet'!C43","v":"1M+S839307"},{"$f":"'Input Sheet'!D43","v":2009},{"$f":"'Input Sheet'!E43","v":"COOPER"},{"$f":"'Input Sheet'!F43","v":37070},{"$f":"'Input Sheet'!G43","v":13.5},{"$f":"'Input Sheet'!H43","v":0.1},{"$f":"'Input Sheet'!I43","v":1278},{"$f":"'Input Sheet'!J43","v":23.5},2.35,{"$f":"'Input Sheet'!L43","v":135},{"$f":"'Input Sheet'!M43","v":1},{"$f":"'Input Sheet'!I43","v":1278},{"$f":"'Input Sheet'!J43","v":23.5},23.5,{"$f":"'Input Sheet'!Q43","v":0},{"$f":"'Input Sheet'!R43","v":0},{"$f":"'Input Sheet'!S43","v":0},{"$f":"'Input Sheet'!T43","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V43","v":25.85},{"$f":"'Input Sheet'!W43","v":0}]
[{"$f":"'Input Sheet'!C44","v":"1M+S839342"},{"$f":"'Input Sheet'!D44","v":2003},{"$f":"'Input Sheet'!E44","v":"COOPER"},{"$f":"'Input Sheet'!F44","v":176615},{"$f":"'Input Sheet'!G44","v":15.5},{"$f":"'Input Sheet'!H44","v":0.3},{"$f":"'Input Sheet'!I44","v":494},{"$f":"'Input Sheet'!J44","v":31.5},9.4499999999999993,{"$f":"'Input Sheet'!L44","v":0},{"$f":"'Input Sheet'!M44","v":0},{"$f":"'Input Sheet'!I44","v":494},{"$f":"'Input Sheet'!J44","v":31.5},0,{"$f":"'Input Sheet'!Q44","v":891},{"$f":"'Input Sheet'!R44","v":6.6},{"$f":"'Input Sheet'!S44","v":494},{"$f":"'Input Sheet'!T44","v":31.5},207.89999999999998,{"$f":"'Input Sheet'!V44","v":217.34999999999997},{"$f":"'Input Sheet'!W44","v":0}]
[{"$f":"'Input Sheet'!C45","v":"1M+S839353"},{"$f":"'Input Sheet'!D45","v":2007},{"$f":"'Input Sheet'!E45","v":"COOPER"},{"$f":"'Input Sheet'!F45","v":29777},{"$f":"'Input Sheet'!G45","v":31.41},{"$f":"'Input Sheet'!H45","v":0.4},{"$f":"'Input Sheet'!I45","v":1335},{"$f":"'Input Sheet'!J45","v":25},10,{"$f":"'Input Sheet'!L45","v":119.95},{"$f":"'Input Sheet'!M45","v":2},{"$f":"'Input Sheet'!I45","v":1335},{"$f":"'Input Sheet'!J45","v":25},50,{"$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":60},{"$f":"'Input Sheet'!W45","v":0}]
[{"$f":"'Input Sheet'!C46","v":"1M+S839355"},{"$f":"'Input Sheet'!D46","v":2013},{"$f":"'Input Sheet'!E46","v":"COOPER"},{"$f":"'Input Sheet'!F46","v":19240},{"$f":"'Input Sheet'!G46","v":29.95},{"$f":"'Input Sheet'!H46","v":0.3},{"$f":"'Input Sheet'!I46","v":1335},{"$f":"'Input Sheet'!J46","v":25},7.5,{"$f":"'Input Sheet'!L46","v":0},{"$f":"'Input Sheet'!M46","v":0},{"$f":"'Input Sheet'!I46","v":1335},{"$f":"'Input Sheet'!J46","v":25},0,{"$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":7.5},{"$f":"'Input Sheet'!W46","v":1}]
[{"$f":"'Input Sheet'!C47","v":"1M+S839373"},{"$f":"'Input Sheet'!D47","v":2012},{"$f":"'Input Sheet'!E47","v":"COOPER"},{"$f":"'Input Sheet'!F47","v":49474},{"$f":"'Input Sheet'!G47","v":31.41},{"$f":"'Input Sheet'!H47","v":0.4},{"$f":"'Input Sheet'!I47","v":1317},{"$f":"'Input Sheet'!J47","v":27.5},11,{"$f":"'Input Sheet'!L47","v":73.5},{"$f":"'Input Sheet'!M47","v":0.7},{"$f":"'Input Sheet'!I47","v":1317},{"$f":"'Input Sheet'!J47","v":27.5},19.25,{"$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":30.25},{"$f":"'Input Sheet'!W47","v":0}]
[{"$f":"'Input Sheet'!C48","v":"1M+S839377"},{"$f":"'Input Sheet'!D48","v":2011},{"$f":"'Input Sheet'!E48","v":"COOPER"},{"$f":"'Input Sheet'!F48","v":106930},{"$f":"'Input Sheet'!G48","v":0},{"$f":"'Input Sheet'!H48","v":0},{"$f":"'Input Sheet'!I48","v":0},{"$f":"'Input Sheet'!J48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L48","v":202.5},{"$f":"'Input Sheet'!M48","v":1.5},{"$f":"'Input Sheet'!I48","v":0},{"$f":"'Input Sheet'!J48","v":""},{"$error":"#VALUE!"},{"$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":46.5},{"$f":"'Input Sheet'!W48","v":1}]
[{"$f":"'Input Sheet'!C49","v":"1M+S839382"},{"$f":"'Input Sheet'!D49","v":2010},{"$f":"'Input Sheet'!E49","v":"COOPER"},{"$f":"'Input Sheet'!F49","v":105881},{"$f":"'Input Sheet'!G49","v":15},{"$f":"'Input Sheet'!H49","v":0.3},{"$f":"'Input Sheet'!I49","v":1278},{"$f":"'Input Sheet'!J49","v":23.5},7.05,{"$f":"'Input Sheet'!L49","v":0},{"$f":"'Input Sheet'!M49","v":0},{"$f":"'Input Sheet'!I49","v":1278},{"$f":"'Input Sheet'!J49","v":23.5},0,{"$f":"'Input Sheet'!Q49","v":270},{"$f":"'Input Sheet'!R49","v":2},{"$f":"'Input Sheet'!S49","v":1278},{"$f":"'Input Sheet'!T49","v":23.5},47,{"$f":"'Input Sheet'!V49","v":54.05},{"$f":"'Input Sheet'!W49","v":0}]
[{"$f":"'Input Sheet'!C50","v":"1M+S839401"},{"$f":"'Input Sheet'!D50","v":2012},{"$f":"'Input Sheet'!E50","v":"COOPER"},{"$f":"'Input Sheet'!F50","v":78541},{"$f":"'Input Sheet'!G50","v":31.41},{"$f":"'Input Sheet'!H50","v":0.4},{"$f":"'Input Sheet'!I50","v":1441},{"$f":"'Input Sheet'!J50","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L50","v":135},{"$f":"'Input Sheet'!M50","v":1},{"$f":"'Input Sheet'!I50","v":1441},{"$f":"'Input Sheet'!J50","v":26.5},26.5,{"$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":37.1},{"$f":"'Input Sheet'!W50","v":0}]
[{"$f":"'Input Sheet'!C51","v":"1M+S839406"},{"$f":"'Input Sheet'!D51","v":2013},{"$f":"'Input Sheet'!E51","v":"COOPER"},{"$f":"'Input Sheet'!D51","v":2013},{"$f":"'Input Sheet'!G51","v":30},{"$f":"'Input Sheet'!H51","v":0.6},{"$f":"'Input Sheet'!I51","v":774},{"$f":"'Input Sheet'!J51","v":35},{"$f":"F55*H51","v":14},{"$f":"'Input Sheet'!L51","v":119.95},{"$f":"'Input Sheet'!M51","v":2},{"$f":"'Input Sheet'!I51","v":774},{"$f":"'Input Sheet'!J51","v":35},70,{"$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":91},{"$f":"'Input Sheet'!W51","v":0}]
[{"$f":"'Input Sheet'!C52","v":"1M+S839407"},{"$f":"'Input Sheet'!D52","v":2007},{"$f":"'Input Sheet'!E52","v":"COOPER"},{"$f":"'Input Sheet'!F52","v":93167},{"$f":"'Input Sheet'!G52","v":15},{"$f":"'Input Sheet'!H52","v":0.3},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L52","v":135},{"$f":"'Input Sheet'!M52","v":1},{"$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":940},{"$f":"'Input Sheet'!T99","v":31},0,{"$f":"'Input Sheet'!V52","v":34.450000000000003},{"$f":"'Input Sheet'!W52","v":0}]
[{"$f":"'Input Sheet'!C53","v":"1M+S839412"},{"$f":"'Input Sheet'!D53","v":2012},{"$f":"'Input Sheet'!E53","v":"COOPER"},{"$f":"'Input Sheet'!F53","v":48235},{"$f":"'Input Sheet'!G53","v":29.95},{"$f":"'Input Sheet'!H53","v":0.3},{"$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":464},{"$f":"'Input Sheet'!T100","v":27},0,{"$f":"'Input Sheet'!V53","v":7.9499999999999993},{"$f":"'Input Sheet'!W53","v":1}]
[{"$f":"'Input Sheet'!C54","v":"1M+S839419"},{"$f":"'Input Sheet'!D54","v":2011},{"$f":"'Input Sheet'!E54","v":"COOPER"},{"$f":"'Input Sheet'!F54","v":73580},{"$f":"'Input Sheet'!G54","v":0},{"$f":"'Input Sheet'!H54","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"F54*H54","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!L54","v":172.5},{"$f":"'Input Sheet'!M54","v":1.7},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$f":"K54*M54","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!Q54","v":232},{"$f":"'Input Sheet'!R54","v":1.6},{"$f":"'Input Sheet'!S101","v":1335},{"$f":"'Input Sheet'!T101","v":25},{"$f":"P54*R54","v":40},{"$f":"'Input Sheet'!V54","v":115.5},{"$f":"'Input Sheet'!W54","v":0}]
[{"$f":"'Input Sheet'!C55","v":"1M+S839425"},{"$f":"'Input Sheet'!D55","v":2013},{"$f":"'Input Sheet'!E55","v":"COOPER"},{"$f":"'Input Sheet'!F55","v":37562},{"$f":"'Input Sheet'!G55","v":31.41},{"$f":"'Input Sheet'!H55","v":0.4},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$f":"#REF!*H55","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!L55","v":90.95},{"$f":"'Input Sheet'!M55","v":1},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q55","v":0},{"$f":"'Input Sheet'!R55","v":0},{"$f":"'Input Sheet'!S105","v":0},{"$f":"'Input Sheet'!T105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V55","v":37.1},{"$f":"'Input Sheet'!W55","v":0}]
["RO's 1-50",null,null,"Totals",{"$f":"SUM(E6:E55)","v":1718.0400000000009},{"$f":"SUM(F6:F55)","v":17.900000000000002},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},5175.6499999999996,43.7,37950,963,{"$error":"#VALUE!"},{"$f":"SUM(O6:O55)","v":5786.5},42.7,null,null,{"$error":"#VALUE!"},2937.7999999999997,{"$f":"COUNTIF(U5:U55,1)","v":14}]
["Date of Study:",null,null,null,"C Labor",null,null,null,null,"M Labor",null,null,null,null,"R Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["Study Compiled by",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"RO Report 51-100","index":4,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,0,1,3],[0,0,0,20],[1,4,2,8],[1,9,2,13],[1,14,2,18],[2,0,2,3],[2,20,4,20],[3,0,4,0],[3,4,4,4],[3,5,4,5],[2,19,4,19],[3,12,4,12],[3,13,4,13],[3,14,4,14],[3,15,4,15],[3,16,4,16],[56,19,58,19],[56,20,58,20],[57,15,58,15],[57,16,58,16],[57,17,58,17],[57,18,58,18],[56,14,56,18],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,11],[3,17,4,17],[3,18,4,18],[57,4,58,4],[57,5,58,5],[57,6,58,6],[3,6,4,6],[3,7,4,7],[3,8,4,8],[3,9,4,9],[56,4,56,8],[56,9,56,13],[3,10,4,10],[3,11,4,11],[57,12,58,12],[57,13,58,13],[57,14,58,14]]}
["Repair Order Analysis "]
[null,null,null,null,"Competitive Labor",null,null,null,null,"Maintenance Labor",null,null,null,null,"Repair Labor"]
["Dealership",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["RO Number",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[null,"Year","Model ","Mileage"]
[{"$f":"'Input Sheet'!C56","v":"1M+S839428"},{"$f":"'Input Sheet'!D56","v":2009},{"$f":"'Input Sheet'!E56","v":"COOPER"},{"$f":"'Input Sheet'!F56","v":111525},{"$f":"'Input Sheet'!G56","v":135},{"$f":"'Input Sheet'!H56","v":1},{"$f":"'Input Sheet'!I56","v":774},{"$f":"'Input Sheet'!J56","v":35},{"$f":"F6*H6","v":35},{"$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!"}},{"$f":"'Input Sheet'!Q56","v":0},{"$f":"'Input Sheet'!R56","v":0},{"$f":"'Input Sheet'!S56","v":0},{"$f":"'Input Sheet'!T56","v":""},{"$f":"P6*R6","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V56","v":35},{"$f":"'Input Sheet'!W56","v":0}]
[{"$f":"'Input Sheet'!C57","v":"1M+S839429"},{"$f":"'Input Sheet'!D57","v":2012},{"$f":"'Input Sheet'!E57","v":"COOPER"},{"$f":"'Input Sheet'!F57","v":75020},{"$f":"'Input Sheet'!G57","v":31.41},{"$f":"'Input Sheet'!H57","v":0.4},{"$f":"'Input Sheet'!I57","v":1278},{"$f":"'Input Sheet'!J57","v":23.5},9.4,{"$f":"'Input Sheet'!L57","v":145},{"$f":"'Input Sheet'!M57","v":1},{"$f":"'Input Sheet'!N57","v":1278},{"$f":"'Input Sheet'!O57","v":23.5},23.5,{"$f":"'Input Sheet'!Q57","v":0},{"$f":"'Input Sheet'!R57","v":0},{"$f":"'Input Sheet'!S57","v":0},{"$f":"'Input Sheet'!T57","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V57","v":32.9},{"$f":"'Input Sheet'!W57","v":0}]
[{"$f":"'Input Sheet'!C58","v":"1M+S839433"},{"$f":"'Input Sheet'!D58","v":2011},{"$f":"'Input Sheet'!E58","v":"COOPER"},{"$f":"'Input Sheet'!F58","v":47309},{"$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":135},{"$f":"'Input Sheet'!M58","v":1},{"$f":"'Input Sheet'!N58","v":1489},{"$f":"'Input Sheet'!O58","v":19},19,{"$f":"'Input Sheet'!Q58","v":0},{"$f":"'Input Sheet'!R58","v":0},{"$f":"'Input Sheet'!S58","v":0},{"$f":"'Input Sheet'!T58","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V58","v":19},{"$f":"'Input Sheet'!W58","v":0}]
[{"$f":"'Input Sheet'!C59","v":"1M+S839451"},{"$f":"'Input Sheet'!D59","v":2013},{"$f":"'Input Sheet'!E59","v":"COOPER"},{"$f":"'Input Sheet'!F59","v":55118},{"$f":"'Input Sheet'!G59","v":494.12},{"$f":"'Input Sheet'!H59","v":1.2},{"$f":"'Input Sheet'!I59","v":1441},{"$f":"'Input Sheet'!J59","v":26.5},31.799999999999997,{"$f":"'Input Sheet'!L59","v":119.95},{"$f":"'Input Sheet'!M59","v":2},{"$f":"'Input Sheet'!N59","v":1441},{"$f":"'Input Sheet'!O59","v":26.5},53,{"$f":"'Input Sheet'!Q59","v":0},{"$f":"'Input Sheet'!R59","v":0},{"$f":"'Input Sheet'!S59","v":0},{"$f":"'Input Sheet'!T59","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V59","v":84.8},{"$f":"'Input Sheet'!W59","v":0}]
[{"$f":"'Input Sheet'!C60","v":"1M+S839453"},{"$f":"'Input Sheet'!D60","v":2016},{"$f":"'Input Sheet'!E60","v":"COOPER"},{"$f":"'Input Sheet'!F60","v":13641},{"$f":"'Input Sheet'!G60","v":29.95},{"$f":"'Input Sheet'!H60","v":0.3},{"$f":"'Input Sheet'!I60","v":1278},{"$f":"'Input Sheet'!J60","v":23.5},7.05,{"$f":"'Input Sheet'!L60","v":119.95},{"$f":"'Input Sheet'!M60","v":2},{"$f":"'Input Sheet'!N60","v":1278},{"$f":"'Input Sheet'!O60","v":23.5},47,{"$f":"'Input Sheet'!Q60","v":0},{"$f":"'Input Sheet'!R60","v":0},{"$f":"'Input Sheet'!S60","v":0},{"$f":"'Input Sheet'!T60","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V60","v":54.05},{"$f":"'Input Sheet'!W60","v":0}]
[{"$f":"'Input Sheet'!C61","v":"1M+S839458"},{"$f":"'Input Sheet'!D61","v":2005},{"$f":"'Input Sheet'!E61","v":"COOPER"},{"$f":"'Input Sheet'!F61","v":95499},{"$f":"'Input Sheet'!G61","v":0},{"$f":"'Input Sheet'!H61","v":0},{"$f":"'Input Sheet'!I61","v":0},{"$f":"'Input Sheet'!J61","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L61","v":135},{"$f":"'Input Sheet'!M61","v":1},{"$f":"'Input Sheet'!N61","v":1278},{"$f":"'Input Sheet'!O61","v":23.5},23.5,{"$f":"'Input Sheet'!Q61","v":0},{"$f":"'Input Sheet'!R61","v":0},{"$f":"'Input Sheet'!S61","v":0},{"$f":"'Input Sheet'!T61","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V61","v":23.5},{"$f":"'Input Sheet'!W61","v":1}]
[{"$f":"'Input Sheet'!C62","v":"1M+S839461"},{"$f":"'Input Sheet'!D62","v":2014},{"$f":"'Input Sheet'!E62","v":"COOPER"},{"$f":"'Input Sheet'!F62","v":30539},{"$f":"'Input Sheet'!G62","v":100},{"$f":"'Input Sheet'!H62","v":1.2},{"$f":"'Input Sheet'!I62","v":1335},{"$f":"'Input Sheet'!J62","v":25},30,{"$f":"'Input Sheet'!L62","v":119.95},{"$f":"'Input Sheet'!M62","v":2},{"$f":"'Input Sheet'!N62","v":1335},{"$f":"'Input Sheet'!O62","v":25},50,{"$f":"'Input Sheet'!Q62","v":0},{"$f":"'Input Sheet'!R62","v":0},{"$f":"'Input Sheet'!S62","v":0},{"$f":"'Input Sheet'!T62","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V62","v":80},{"$f":"'Input Sheet'!W62","v":0}]
[{"$f":"'Input Sheet'!C63","v":"1M+S839463"},{"$f":"'Input Sheet'!D63","v":2015},{"$f":"'Input Sheet'!E63","v":"COOPER"},{"$f":"'Input Sheet'!F63","v":34882},{"$f":"'Input Sheet'!G63","v":157.30000000000001},{"$f":"'Input Sheet'!H63","v":0.3},{"$f":"'Input Sheet'!I63","v":1317},{"$f":"'Input Sheet'!J63","v":27.5},8.25,{"$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!"},{"$f":"'Input Sheet'!Q63","v":0},{"$f":"'Input Sheet'!R63","v":0},{"$f":"'Input Sheet'!S63","v":0},{"$f":"'Input Sheet'!T63","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V63","v":8.25},{"$f":"'Input Sheet'!W63","v":0}]
[{"$f":"'Input Sheet'!C64","v":"1M+S839468"},{"$f":"'Input Sheet'!D64","v":2013},{"$f":"'Input Sheet'!E64","v":"COOPER"},{"$f":"'Input Sheet'!F64","v":17013},{"$f":"'Input Sheet'!G64","v":31.41},{"$f":"'Input Sheet'!H64","v":0.4},{"$f":"'Input Sheet'!I64","v":464},{"$f":"'Input Sheet'!J64","v":27},10.8,{"$f":"'Input Sheet'!L64","v":90.95},{"$f":"'Input Sheet'!M64","v":1},{"$f":"'Input Sheet'!N64","v":464},{"$f":"'Input Sheet'!O64","v":27},27,{"$f":"'Input Sheet'!Q64","v":0},{"$f":"'Input Sheet'!R64","v":0},{"$f":"'Input Sheet'!S64","v":0},{"$f":"'Input Sheet'!T64","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V64","v":37.799999999999997},{"$f":"'Input Sheet'!W64","v":0}]
[{"$f":"'Input Sheet'!C65","v":"1M+S839469"},{"$f":"'Input Sheet'!D65","v":2013},{"$f":"'Input Sheet'!E65","v":"COOPER"},{"$f":"'Input Sheet'!F65","v":77975},{"$f":"'Input Sheet'!G65","v":31.41},{"$f":"'Input Sheet'!H65","v":0.4},{"$f":"'Input Sheet'!I65","v":774},{"$f":"'Input Sheet'!J65","v":35},14,{"$f":"'Input Sheet'!L65","v":29.95},{"$f":"'Input Sheet'!M65","v":0.3},{"$f":"'Input Sheet'!N65","v":774},{"$f":"'Input Sheet'!O65","v":35},10.5,{"$f":"'Input Sheet'!Q65","v":0},{"$f":"'Input Sheet'!R65","v":0},{"$f":"'Input Sheet'!S65","v":0},{"$f":"'Input Sheet'!T65","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V65","v":24.5},{"$f":"'Input Sheet'!W65","v":0}]
[{"$f":"'Input Sheet'!C66","v":"1M+S839473"},{"$f":"'Input Sheet'!D66","v":2009},{"$f":"'Input Sheet'!E66","v":"COOPER"},{"$f":"'Input Sheet'!F66","v":123819},{"$f":"'Input Sheet'!G66","v":90.95},{"$f":"'Input Sheet'!H66","v":1},{"$f":"'Input Sheet'!I66","v":1441},{"$f":"'Input Sheet'!J66","v":26.5},26.5,{"$f":"'Input Sheet'!L66","v":316.56},{"$f":"'Input Sheet'!M66","v":1.2},{"$f":"'Input Sheet'!N66","v":1441},{"$f":"'Input Sheet'!O66","v":26.5},31.799999999999997,{"$f":"'Input Sheet'!Q66","v":0},{"$f":"'Input Sheet'!R66","v":0},{"$f":"'Input Sheet'!S66","v":0},{"$f":"'Input Sheet'!T66","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V66","v":58.3},{"$f":"'Input Sheet'!W66","v":0}]
[{"$f":"'Input Sheet'!C67","v":"1M+S839477"},{"$f":"'Input Sheet'!D67","v":2009},{"$f":"'Input Sheet'!E67","v":"COOPER"},{"$f":"'Input Sheet'!F67","v":42268},{"$f":"'Input Sheet'!G67","v":0},{"$f":"'Input Sheet'!H67","v":0},{"$f":"'Input Sheet'!I67","v":0},{"$f":"'Input Sheet'!J67","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L67","v":135},{"$f":"'Input Sheet'!M67","v":1},{"$f":"'Input Sheet'!N67","v":1317},{"$f":"'Input Sheet'!O67","v":27.5},27.5,{"$f":"'Input Sheet'!Q67","v":0},{"$f":"'Input Sheet'!R67","v":0},{"$f":"'Input Sheet'!S67","v":0},{"$f":"'Input Sheet'!T67","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V67","v":27.5},{"$f":"'Input Sheet'!W67","v":1}]
[{"$f":"'Input Sheet'!C68","v":"1M+S839480"},{"$f":"'Input Sheet'!D68","v":2015},{"$f":"'Input Sheet'!E68","v":"COOPER"},{"$f":"'Input Sheet'!F68","v":12540},{"$f":"'Input Sheet'!G68","v":0},{"$f":"'Input Sheet'!H68","v":0},{"$f":"'Input Sheet'!I68","v":0},{"$f":"'Input Sheet'!J68","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L68","v":119.95},{"$f":"'Input Sheet'!M68","v":2},{"$f":"'Input Sheet'!N68","v":1278},{"$f":"'Input Sheet'!O68","v":23.5},47,{"$f":"'Input Sheet'!Q68","v":0},{"$f":"'Input Sheet'!R68","v":0},{"$f":"'Input Sheet'!S68","v":0},{"$f":"'Input Sheet'!T68","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V68","v":47},{"$f":"'Input Sheet'!W68","v":1}]
[{"$f":"'Input Sheet'!C69","v":"1M+S839487"},{"$f":"'Input Sheet'!D69","v":2011},{"$f":"'Input Sheet'!E69","v":"COOPER"},{"$f":"'Input Sheet'!F69","v":55705},{"$f":"'Input Sheet'!G69","v":31.41},{"$f":"'Input Sheet'!H69","v":0.4},{"$f":"'Input Sheet'!I69","v":494},{"$f":"'Input Sheet'!J69","v":31.5},12.600000000000001,{"$f":"'Input Sheet'!L69","v":108.75},{"$f":"'Input Sheet'!M69","v":0.75},{"$f":"'Input Sheet'!N69","v":494},{"$f":"'Input Sheet'!O69","v":31.5},23.625,{"$f":"'Input Sheet'!Q69","v":0},{"$f":"'Input Sheet'!R69","v":0},{"$f":"'Input Sheet'!S69","v":0},{"$f":"'Input Sheet'!T69","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V69","v":36.225000000000001},{"$f":"'Input Sheet'!W69","v":0}]
[{"$f":"'Input Sheet'!C70","v":"1M+S839483"},{"$f":"'Input Sheet'!D70","v":2015},{"$f":"'Input Sheet'!E70","v":"COOPER"},{"$f":"'Input Sheet'!F70","v":29721},{"$f":"'Input Sheet'!G70","v":0},{"$f":"'Input Sheet'!H70","v":0},{"$f":"'Input Sheet'!I70","v":0},{"$f":"'Input Sheet'!J70","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L70","v":119.95},{"$f":"'Input Sheet'!M70","v":2},{"$f":"'Input Sheet'!N70","v":1278},{"$f":"'Input Sheet'!O70","v":23.5},47,{"$f":"'Input Sheet'!Q70","v":0},{"$f":"'Input Sheet'!R70","v":0},{"$f":"'Input Sheet'!S70","v":0},{"$f":"'Input Sheet'!T70","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V70","v":47},{"$f":"'Input Sheet'!W70","v":1}]
[{"$f":"'Input Sheet'!C71","v":"1M+S839496"},{"$f":"'Input Sheet'!D71","v":2014},{"$f":"'Input Sheet'!E71","v":"COOPER"},{"$f":"'Input Sheet'!F71","v":33487},{"$f":"'Input Sheet'!G71","v":0},{"$f":"'Input Sheet'!H71","v":0},{"$f":"'Input Sheet'!I71","v":0},{"$f":"'Input Sheet'!J71","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L71","v":119.95},{"$f":"'Input Sheet'!M71","v":2},{"$f":"'Input Sheet'!N71","v":1317},{"$f":"'Input Sheet'!O71","v":27.5},55,{"$f":"'Input Sheet'!Q71","v":145},{"$f":"'Input Sheet'!R71","v":1},{"$f":"'Input Sheet'!S71","v":1317},{"$f":"'Input Sheet'!T71","v":27.5},27.5,{"$f":"'Input Sheet'!V71","v":82.5},{"$f":"'Input Sheet'!W71","v":0}]
[{"$f":"'Input Sheet'!C72","v":"1M+S839498"},{"$f":"'Input Sheet'!D72","v":2011},{"$f":"'Input Sheet'!E72","v":"COOPER"},{"$f":"'Input Sheet'!F72","v":58848},{"$f":"'Input Sheet'!G72","v":0},{"$f":"'Input Sheet'!H72","v":0},{"$f":"'Input Sheet'!I72","v":0},{"$f":"'Input Sheet'!J72","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L72","v":110},{"$f":"'Input Sheet'!M72","v":1.5},{"$f":"'Input Sheet'!N72","v":940},{"$f":"'Input Sheet'!O72","v":31},46.5,{"$f":"'Input Sheet'!Q72","v":0},{"$f":"'Input Sheet'!R72","v":0},{"$f":"'Input Sheet'!S72","v":0},{"$f":"'Input Sheet'!T72","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V72","v":46.5},{"$f":"'Input Sheet'!W72","v":0}]
[{"$f":"'Input Sheet'!C73","v":"1M+S839504"},{"$f":"'Input Sheet'!D73","v":2011},{"$f":"'Input Sheet'!E73","v":"COOPER"},{"$f":"'Input Sheet'!F73","v":40935},{"$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":110},{"$f":"'Input Sheet'!M73","v":1.5},{"$f":"'Input Sheet'!N73","v":464},{"$f":"'Input Sheet'!O73","v":27},40.5,{"$f":"'Input Sheet'!Q73","v":0},{"$f":"'Input Sheet'!R73","v":0},{"$f":"'Input Sheet'!S73","v":0},{"$f":"'Input Sheet'!T73","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V73","v":40.5},{"$f":"'Input Sheet'!W73","v":0}]
[{"$f":"'Input Sheet'!C74","v":"1M+S839514"},{"$f":"'Input Sheet'!D74","v":2015},{"$f":"'Input Sheet'!E74","v":"COOPER"},{"$f":"'Input Sheet'!F74","v":37729},{"$f":"'Input Sheet'!G74","v":29.95},{"$f":"'Input Sheet'!H74","v":0.4},{"$f":"'Input Sheet'!I74","v":1317},{"$f":"'Input Sheet'!J74","v":27.5},11,{"$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!"},{"$f":"'Input Sheet'!V74","v":11},{"$f":"'Input Sheet'!W74","v":0}]
[{"$f":"'Input Sheet'!C75","v":"1M+S839520"},{"$f":"'Input Sheet'!D75","v":2013},{"$f":"'Input Sheet'!E75","v":"COOPER"},{"$f":"'Input Sheet'!F75","v":25474},{"$f":"'Input Sheet'!G75","v":0},{"$f":"'Input Sheet'!H75","v":0},{"$f":"'Input Sheet'!I75","v":0},{"$f":"'Input Sheet'!J75","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L75","v":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":217.5},{"$f":"'Input Sheet'!R75","v":1.5},{"$f":"'Input Sheet'!S75","v":774},{"$f":"'Input Sheet'!T75","v":35},52.5,{"$f":"'Input Sheet'!V75","v":52.5},{"$f":"'Input Sheet'!W75","v":0}]
[{"$f":"'Input Sheet'!C76","v":"1M+S839522"},{"$f":"'Input Sheet'!D76","v":2006},{"$f":"'Input Sheet'!E76","v":"COOPER"},{"$f":"'Input Sheet'!F76","v":94279},{"$f":"'Input Sheet'!G76","v":31.41},{"$f":"'Input Sheet'!H76","v":0.4},{"$f":"'Input Sheet'!I76","v":464},{"$f":"'Input Sheet'!J76","v":27},10.8,{"$f":"'Input Sheet'!L76","v":90.95},{"$f":"'Input Sheet'!M76","v":1},{"$f":"'Input Sheet'!N76","v":464},{"$f":"'Input Sheet'!O76","v":27},27,{"$f":"'Input Sheet'!Q76","v":499.5},{"$f":"'Input Sheet'!R76","v":3.7},{"$f":"'Input Sheet'!S76","v":464},{"$f":"'Input Sheet'!T76","v":27},99.9,{"$f":"'Input Sheet'!V76","v":137.70000000000002},{"$f":"'Input Sheet'!W76","v":0}]
[{"$f":"'Input Sheet'!C77","v":"1M+S839525"},{"$f":"'Input Sheet'!D77","v":2010},{"$f":"'Input Sheet'!E77","v":"COOPER"},{"$f":"'Input Sheet'!F77","v":71590},{"$f":"'Input Sheet'!G77","v":0},{"$f":"'Input Sheet'!H77","v":0},{"$f":"'Input Sheet'!I77","v":0},{"$f":"'Input Sheet'!J77","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L77","v":135},{"$f":"'Input Sheet'!M77","v":1},{"$f":"'Input Sheet'!N77","v":1278},{"$f":"'Input Sheet'!O77","v":23.5},23.5,{"$f":"'Input Sheet'!Q77","v":0},{"$f":"'Input Sheet'!R77","v":0},{"$f":"'Input Sheet'!S77","v":0},{"$f":"'Input Sheet'!T77","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V77","v":23.5},{"$f":"'Input Sheet'!W77","v":0}]
[{"$f":"'Input Sheet'!C78","v":"1M+S839530"},{"$f":"'Input Sheet'!D78","v":2011},{"$f":"'Input Sheet'!E78","v":"COOPER"},{"$f":"'Input Sheet'!F78","v":82647},{"$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":135},{"$f":"'Input Sheet'!M78","v":1},{"$f":"'Input Sheet'!N78","v":1441},{"$f":"'Input Sheet'!O78","v":26.5},26.5,{"$f":"'Input Sheet'!Q78","v":15},{"$f":"'Input Sheet'!R78","v":0.3},{"$f":"'Input Sheet'!S78","v":1441},{"$f":"'Input Sheet'!T78","v":26.5},7.9499999999999993,{"$f":"'Input Sheet'!V78","v":34.450000000000003},{"$f":"'Input Sheet'!W78","v":0}]
[{"$f":"'Input Sheet'!C79","v":"1M+S839531"},{"$f":"'Input Sheet'!D79","v":2011},{"$f":"'Input Sheet'!E79","v":"COOPER"},{"$f":"'Input Sheet'!F79","v":41315},{"$f":"'Input Sheet'!G79","v":90.95},{"$f":"'Input Sheet'!H79","v":1},{"$f":"'Input Sheet'!I79","v":1335},{"$f":"'Input Sheet'!J79","v":25},25,{"$f":"'Input Sheet'!L79","v":270},{"$f":"'Input Sheet'!M79","v":2},{"$f":"'Input Sheet'!N79","v":1335},{"$f":"'Input Sheet'!O79","v":25},50,{"$f":"'Input Sheet'!Q79","v":135},{"$f":"'Input Sheet'!R79","v":1},{"$f":"'Input Sheet'!S79","v":1335},{"$f":"'Input Sheet'!T79","v":25},25,{"$f":"'Input Sheet'!V79","v":100},{"$f":"'Input Sheet'!W79","v":0}]
[{"$f":"'Input Sheet'!C80","v":"1M+S839534"},{"$f":"'Input Sheet'!D80","v":2009},{"$f":"'Input Sheet'!E80","v":"COOPER"},{"$f":"'Input Sheet'!F80","v":86824},{"$f":"'Input Sheet'!G80","v":31.41},{"$f":"'Input Sheet'!H80","v":0.4},{"$f":"'Input Sheet'!I80","v":1489},{"$f":"'Input Sheet'!J80","v":19},7.6000000000000005,{"$f":"'Input Sheet'!L80","v":0},{"$f":"'Input Sheet'!M80","v":0},{"$f":"'Input Sheet'!N80","v":0},{"$f":"'Input Sheet'!O80","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q80","v":0},{"$f":"'Input Sheet'!R80","v":0},{"$f":"'Input Sheet'!S80","v":0},{"$f":"'Input Sheet'!T80","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V80","v":7.6000000000000005},{"$f":"'Input Sheet'!W80","v":1}]
[{"$f":"'Input Sheet'!C81","v":"1M+S839535"},{"$f":"'Input Sheet'!D81","v":2012},{"$f":"'Input Sheet'!E81","v":"COOPER"},{"$f":"'Input Sheet'!F81","v":43245},{"$f":"'Input Sheet'!G81","v":31.41},{"$f":"'Input Sheet'!H81","v":0.4},{"$f":"'Input Sheet'!I81","v":1335},{"$f":"'Input Sheet'!J81","v":25},10,{"$f":"'Input Sheet'!L81","v":73.5},{"$f":"'Input Sheet'!M81","v":0.7},{"$f":"'Input Sheet'!N81","v":1335},{"$f":"'Input Sheet'!O81","v":25},17.5,{"$f":"'Input Sheet'!Q81","v":207},{"$f":"'Input Sheet'!R81","v":1.8},{"$f":"'Input Sheet'!S81","v":1335},{"$f":"'Input Sheet'!T81","v":25},45,{"$f":"'Input Sheet'!V81","v":72.5},{"$f":"'Input Sheet'!W81","v":0}]
[{"$f":"'Input Sheet'!C82","v":"1M+S839539"},{"$f":"'Input Sheet'!D82","v":2014},{"$f":"'Input Sheet'!E82","v":"COOPER"},{"$f":"'Input Sheet'!F82","v":64860},{"$f":"'Input Sheet'!G82","v":0},{"$f":"'Input Sheet'!H82","v":0},{"$f":"'Input Sheet'!I82","v":0},{"$f":"'Input Sheet'!J82","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L82","v":0},{"$f":"'Input Sheet'!M82","v":0},{"$f":"'Input Sheet'!N82","v":0},{"$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!"},{"$f":"'Input Sheet'!V82","v":0},{"$f":"'Input Sheet'!W82","v":0}]
[{"$f":"'Input Sheet'!C83","v":"1M+S839541"},{"$f":"'Input Sheet'!D83","v":2004},{"$f":"'Input Sheet'!E83","v":"COOPER"},{"$f":"'Input Sheet'!F83","v":71649},{"$f":"'Input Sheet'!G83","v":31.41},{"$f":"'Input Sheet'!H83","v":0.4},{"$f":"'Input Sheet'!I83","v":1317},{"$f":"'Input Sheet'!J83","v":27.5},11,{"$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":30},{"$f":"'Input Sheet'!R83","v":0.6},{"$f":"'Input Sheet'!S83","v":1317},{"$f":"'Input Sheet'!T83","v":27.5},16.5,{"$f":"'Input Sheet'!V83","v":27.5},{"$f":"'Input Sheet'!W83","v":0}]
[{"$f":"'Input Sheet'!C84","v":"1M+S839543"},{"$f":"'Input Sheet'!D84","v":2013},{"$f":"'Input Sheet'!E84","v":"COOPER"},{"$f":"'Input Sheet'!F84","v":10470},{"$f":"'Input Sheet'!G84","v":31.41},{"$f":"'Input Sheet'!H84","v":0.4},{"$f":"'Input Sheet'!I84","v":1278},{"$f":"'Input Sheet'!J84","v":23.5},9.4,{"$f":"'Input Sheet'!L84","v":90.95},{"$f":"'Input Sheet'!M84","v":1},{"$f":"'Input Sheet'!N84","v":1278},{"$f":"'Input Sheet'!O84","v":23.5},23.5,{"$f":"'Input Sheet'!Q84","v":0},{"$f":"'Input Sheet'!R84","v":0},{"$f":"'Input Sheet'!S84","v":0},{"$f":"'Input Sheet'!T84","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V84","v":32.9},{"$f":"'Input Sheet'!W84","v":0}]
[{"$f":"'Input Sheet'!C85","v":"1M+S839561"},{"$f":"'Input Sheet'!D85","v":2014},{"$f":"'Input Sheet'!E85","v":"COOPER"},{"$f":"'Input Sheet'!F85","v":38806},{"$f":"'Input Sheet'!G85","v":31.41},{"$f":"'Input Sheet'!H85","v":0.4},{"$f":"'Input Sheet'!I85","v":913},{"$f":"'Input Sheet'!J85","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L85","v":161},{"$f":"'Input Sheet'!M85","v":1.4},{"$f":"'Input Sheet'!N85","v":913},{"$f":"'Input Sheet'!O85","v":26.5},37.099999999999994,{"$f":"'Input Sheet'!Q85","v":0},{"$f":"'Input Sheet'!R85","v":0},{"$f":"'Input Sheet'!S85","v":0},{"$f":"'Input Sheet'!T85","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V85","v":47.699999999999996},{"$f":"'Input Sheet'!W85","v":0}]
[{"$f":"'Input Sheet'!C86","v":"1M+S839566"},{"$f":"'Input Sheet'!D86","v":2012},{"$f":"'Input Sheet'!E86","v":"COOPER"},{"$f":"'Input Sheet'!F86","v":44729},{"$f":"'Input Sheet'!G86","v":31.41},{"$f":"'Input Sheet'!H86","v":0.4},{"$f":"'Input Sheet'!I86","v":913},{"$f":"'Input Sheet'!J86","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L86","v":42},{"$f":"'Input Sheet'!M86","v":0.4},{"$f":"'Input Sheet'!N86","v":913},{"$f":"'Input Sheet'!O86","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!Q86","v":0},{"$f":"'Input Sheet'!R86","v":0},{"$f":"'Input Sheet'!S86","v":0},{"$f":"'Input Sheet'!T86","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V86","v":21.200000000000003},{"$f":"'Input Sheet'!W86","v":0}]
[{"$f":"'Input Sheet'!C87","v":"1M+S839573"},{"$f":"'Input Sheet'!D87","v":2016},{"$f":"'Input Sheet'!E87","v":"COOPER"},{"$f":"'Input Sheet'!F87","v":33660},{"$f":"'Input Sheet'!G87","v":25},{"$f":"'Input Sheet'!H87","v":0.3},{"$f":"'Input Sheet'!I87","v":913},{"$f":"'Input Sheet'!J87","v":26.5},7.9499999999999993,{"$f":"'Input Sheet'!L87","v":119.95},{"$f":"'Input Sheet'!M87","v":2},{"$f":"'Input Sheet'!N87","v":913},{"$f":"'Input Sheet'!O87","v":26.5},53,{"$f":"'Input Sheet'!Q87","v":75},{"$f":"'Input Sheet'!R87","v":0.9},{"$f":"'Input Sheet'!S87","v":913},{"$f":"'Input Sheet'!T87","v":26.5},23.85,{"$f":"'Input Sheet'!V87","v":84.8},{"$f":"'Input Sheet'!W87","v":0}]
[{"$f":"'Input Sheet'!C88","v":"1M+S839229"},{"$f":"'Input Sheet'!D88","v":2005},{"$f":"'Input Sheet'!E88","v":"COOPER"},{"$f":"'Input Sheet'!F88","v":157089},{"$f":"'Input Sheet'!G88","v":31.41},{"$f":"'Input Sheet'!H88","v":0.4},{"$f":"'Input Sheet'!I88","v":1278},{"$f":"'Input Sheet'!J88","v":23.5},9.4,{"$f":"'Input Sheet'!L88","v":254},{"$f":"'Input Sheet'!M88","v":1.8},{"$f":"'Input Sheet'!N88","v":1278},{"$f":"'Input Sheet'!O88","v":23.5},42.300000000000004,{"$f":"'Input Sheet'!Q88","v":567},{"$f":"'Input Sheet'!R88","v":4.2},{"$f":"'Input Sheet'!S88","v":1278},{"$f":"'Input Sheet'!T88","v":23.5},98.7,{"$f":"'Input Sheet'!V88","v":150.4},{"$f":"'Input Sheet'!W88","v":0}]
[{"$f":"'Input Sheet'!C89","v":"1M+S839270"},{"$f":"'Input Sheet'!D89","v":2012},{"$f":"'Input Sheet'!E89","v":"COOPER"},{"$f":"'Input Sheet'!F89","v":50884},{"$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!"},{"$f":"'Input Sheet'!Q89","v":87},{"$f":"'Input Sheet'!R89","v":0.6},{"$f":"'Input Sheet'!S89","v":940},{"$f":"'Input Sheet'!T89","v":31},18.599999999999998,{"$f":"'Input Sheet'!V89","v":18.599999999999998},{"$f":"'Input Sheet'!W89","v":1}]
[{"$f":"'Input Sheet'!C90","v":"1M+S839279"},{"$f":"'Input Sheet'!D90","v":2012},{"$f":"'Input Sheet'!E90","v":"COOPER"},{"$f":"'Input Sheet'!F90","v":50421},{"$f":"'Input Sheet'!G90","v":0},{"$f":"'Input Sheet'!H90","v":0},{"$f":"'Input Sheet'!I90","v":0},{"$f":"'Input Sheet'!J90","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L90","v":391.5},{"$f":"'Input Sheet'!M90","v":2.7},{"$f":"'Input Sheet'!N90","v":494},{"$f":"'Input Sheet'!O90","v":31.5},85.050000000000011,{"$f":"'Input Sheet'!Q90","v":0},{"$f":"'Input Sheet'!R90","v":0},{"$f":"'Input Sheet'!S90","v":0},{"$f":"'Input Sheet'!T90","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V90","v":85.050000000000011},{"$f":"'Input Sheet'!W90","v":1}]
[{"$f":"'Input Sheet'!C91","v":"1M+S839287"},{"$f":"'Input Sheet'!D91","v":2011},{"$f":"'Input Sheet'!E91","v":"COOPER"},{"$f":"'Input Sheet'!F91","v":61709},{"$f":"'Input Sheet'!G91","v":31.41},{"$f":"'Input Sheet'!H91","v":0.4},{"$f":"'Input Sheet'!I91","v":1441},{"$f":"'Input Sheet'!J91","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L91","v":73},{"$f":"'Input Sheet'!M91","v":0.7},{"$f":"'Input Sheet'!N91","v":1441},{"$f":"'Input Sheet'!O91","v":26.5},18.549999999999997,{"$f":"'Input Sheet'!Q91","v":540},{"$f":"'Input Sheet'!R91","v":4},{"$f":"'Input Sheet'!S91","v":1441},{"$f":"'Input Sheet'!T91","v":26.5},106,{"$f":"'Input Sheet'!V91","v":135.15},{"$f":"'Input Sheet'!W91","v":0}]
[{"$f":"'Input Sheet'!C92","v":"1M+S839294"},{"$f":"'Input Sheet'!D92","v":2010},{"$f":"'Input Sheet'!E92","v":"COOPER"},{"$f":"'Input Sheet'!F92","v":75011},{"$f":"'Input Sheet'!G92","v":25},{"$f":"'Input Sheet'!H92","v":0.3},{"$f":"'Input Sheet'!I92","v":913},{"$f":"'Input Sheet'!J92","v":26.5},7.9499999999999993,{"$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":189},{"$f":"'Input Sheet'!R92","v":1.4},{"$f":"'Input Sheet'!S92","v":913},{"$f":"'Input Sheet'!T92","v":26.5},37.099999999999994,{"$f":"'Input Sheet'!V92","v":45.05},{"$f":"'Input Sheet'!W92","v":0}]
[{"$f":"'Input Sheet'!C93","v":"1M+S839311"},{"$f":"'Input Sheet'!D93","v":2015},{"$f":"'Input Sheet'!E93","v":"COOPER"},{"$f":"'Input Sheet'!F93","v":28327},{"$f":"'Input Sheet'!G93","v":0},{"$f":"'Input Sheet'!H93","v":0},{"$f":"'Input Sheet'!I93","v":0},{"$f":"'Input Sheet'!J93","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L93","v":0},{"$f":"'Input Sheet'!M93","v":0},{"$f":"'Input Sheet'!N93","v":0},{"$f":"'Input Sheet'!O93","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q93","v":232},{"$f":"'Input Sheet'!R93","v":1.6},{"$f":"'Input Sheet'!S93","v":1441},{"$f":"'Input Sheet'!T93","v":26.5},42.400000000000006,{"$f":"'Input Sheet'!V93","v":42.400000000000006},{"$f":"'Input Sheet'!W93","v":0}]
[{"$f":"'Input Sheet'!C94","v":"1M+S836347"},{"$f":"'Input Sheet'!D94","v":2014},{"$f":"'Input Sheet'!E94","v":"COOPER"},{"$f":"'Input Sheet'!F94","v":55688},{"$f":"'Input Sheet'!G94","v":81.36},{"$f":"'Input Sheet'!H94","v":1},{"$f":"'Input Sheet'!I94","v":1335},{"$f":"'Input Sheet'!J94","v":25},25,{"$f":"'Input Sheet'!L94","v":133.5},{"$f":"'Input Sheet'!M94","v":1.5},{"$f":"'Input Sheet'!N94","v":1335},{"$f":"'Input Sheet'!O94","v":25},37.5,{"$f":"'Input Sheet'!Q94","v":0},{"$f":"'Input Sheet'!R94","v":0},{"$f":"'Input Sheet'!S94","v":0},{"$f":"'Input Sheet'!T94","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V94","v":62.5},{"$f":"'Input Sheet'!W94","v":0}]
[{"$f":"'Input Sheet'!C95","v":"1M+S839351"},{"$f":"'Input Sheet'!D95","v":2013},{"$f":"'Input Sheet'!E95","v":"COOPER"},{"$f":"'Input Sheet'!F95","v":83420},{"$f":"'Input Sheet'!G95","v":31.41},{"$f":"'Input Sheet'!H95","v":0.4},{"$f":"'Input Sheet'!I95","v":1441},{"$f":"'Input Sheet'!J95","v":26.5},10.600000000000001,{"$f":"'Input Sheet'!L95","v":90.95},{"$f":"'Input Sheet'!M95","v":1},{"$f":"'Input Sheet'!N95","v":1441},{"$f":"'Input Sheet'!O95","v":26.5},26.5,{"$f":"'Input Sheet'!Q95","v":0},{"$f":"'Input Sheet'!R95","v":0},{"$f":"'Input Sheet'!S95","v":0},{"$f":"'Input Sheet'!T95","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V95","v":37.1},{"$f":"'Input Sheet'!W95","v":0}]
[{"$f":"'Input Sheet'!C96","v":"1M+S839294"},{"$f":"'Input Sheet'!D96","v":2010},{"$f":"'Input Sheet'!E96","v":"COOPER"},{"$f":"'Input Sheet'!F96","v":75011},{"$f":"'Input Sheet'!G96","v":229.5},{"$f":"'Input Sheet'!H96","v":1.7},{"$f":"'Input Sheet'!I96","v":1317},{"$f":"'Input Sheet'!J96","v":27.5},46.75,{"$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":864},{"$f":"'Input Sheet'!R96","v":6.4},{"$f":"'Input Sheet'!S96","v":1317},{"$f":"'Input Sheet'!T96","v":27.5},176,{"$f":"'Input Sheet'!V96","v":222.75},{"$f":"'Input Sheet'!W96","v":0}]
[{"$f":"'Input Sheet'!C97","v":"1M+S839365"},{"$f":"'Input Sheet'!D97","v":2012},{"$f":"'Input Sheet'!E97","v":"COOPER"},{"$f":"'Input Sheet'!F97","v":53536},{"$f":"'Input Sheet'!G97","v":0},{"$f":"'Input Sheet'!H97","v":0},{"$f":"'Input Sheet'!I97","v":0},{"$f":"'Input Sheet'!J97","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L97","v":217.5},{"$f":"'Input Sheet'!M97","v":1.5},{"$f":"'Input Sheet'!N97","v":1441},{"$f":"'Input Sheet'!O97","v":26.5},39.75,{"$f":"'Input Sheet'!Q97","v":0},{"$f":"'Input Sheet'!R97","v":0},{"$f":"'Input Sheet'!S97","v":0},{"$f":"'Input Sheet'!T97","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V97","v":39.75},{"$f":"'Input Sheet'!W97","v":1}]
[{"$f":"'Input Sheet'!C98","v":"1M+S839360"},{"$f":"'Input Sheet'!D98","v":2008},{"$f":"'Input Sheet'!E98","v":"COOPER"},{"$f":"'Input Sheet'!F98","v":93246},{"$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":217.5},{"$f":"'Input Sheet'!M98","v":1.5},{"$f":"'Input Sheet'!N98","v":940},{"$f":"'Input Sheet'!O98","v":31},46.5,{"$f":"'Input Sheet'!Q98","v":0},{"$f":"'Input Sheet'!R98","v":0},{"$f":"'Input Sheet'!S98","v":0},{"$f":"'Input Sheet'!T98","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!V98","v":46.5},{"$f":"'Input Sheet'!W98","v":1}]
[{"$f":"'Input Sheet'!C99","v":"1M+S839378"},{"$f":"'Input Sheet'!D99","v":2011},{"$f":"'Input Sheet'!E99","v":"COOPER"},{"$f":"'Input Sheet'!F99","v":3},{"$f":"'Input Sheet'!G99","v":0},{"$f":"'Input Sheet'!H99","v":0},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L99","v":378},{"$f":"'Input Sheet'!M99","v":2.8},{"$f":"'Input Sheet'!N99","v":940},{"$f":"'Input Sheet'!O99","v":31},86.8,{"$f":"'Input Sheet'!Q99","v":756},{"$f":"'Input Sheet'!R99","v":5.6},{"$f":"'Input Sheet'!S99","v":940},{"$f":"'Input Sheet'!T99","v":31},173.6,{"$f":"'Input Sheet'!V99","v":260.39999999999998},{"$f":"'Input Sheet'!W99","v":0}]
[{"$f":"'Input Sheet'!C100","v":"1M+S839408"},{"$f":"'Input Sheet'!D100","v":2011},{"$f":"'Input Sheet'!E100","v":"COOPER"},{"$f":"'Input Sheet'!F100","v":51721},{"$f":"'Input Sheet'!G100","v":0},{"$f":"'Input Sheet'!H100","v":0},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L100","v":540},{"$f":"'Input Sheet'!M100","v":4},{"$f":"'Input Sheet'!N100","v":464},{"$f":"'Input Sheet'!O100","v":27},108,{"$f":"'Input Sheet'!Q100","v":270},{"$f":"'Input Sheet'!R100","v":2},{"$f":"'Input Sheet'!S100","v":464},{"$f":"'Input Sheet'!T100","v":27},54,{"$f":"'Input Sheet'!V100","v":162},{"$f":"'Input Sheet'!W100","v":0}]
[{"$f":"'Input Sheet'!C101","v":"1M+S839427"},{"$f":"'Input Sheet'!D101","v":2007},{"$f":"'Input Sheet'!E101","v":"COOPER"},{"$f":"'Input Sheet'!F101","v":105224},{"$f":"'Input Sheet'!G101","v":0},{"$f":"'Input Sheet'!H101","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L101","v":90.95},{"$f":"'Input Sheet'!M101","v":1},{"$f":"'Input Sheet'!N101","v":1335},{"$f":"'Input Sheet'!O101","v":25},25,{"$f":"'Input Sheet'!Q101","v":472.5},{"$f":"'Input Sheet'!R101","v":3.5},{"$f":"'Input Sheet'!S101","v":1335},{"$f":"'Input Sheet'!T101","v":25},87.5,{"$f":"'Input Sheet'!V101","v":112.5},{"$f":"'Input Sheet'!W101","v":0}]
[{"$f":"'Input Sheet'!C102","v":"1M+S839448"},{"$f":"'Input Sheet'!D102","v":2012},{"$f":"'Input Sheet'!E102","v":"COOPER"},{"$f":"'Input Sheet'!F102","v":46168},{"$f":"'Input Sheet'!G102","v":0},{"$f":"'Input Sheet'!H102","v":0},{"$f":"'Input Sheet'!I102","v":0},{"$f":"'Input Sheet'!J102","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L102","v":86.25},{"$f":"'Input Sheet'!M102","v":0.75},{"$f":"'Input Sheet'!N102","v":1335},{"$f":"'Input Sheet'!O102","v":25},18.75,{"$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!"},{"$f":"'Input Sheet'!V102","v":18.75},{"$f":"'Input Sheet'!W102","v":1}]
[{"$f":"'Input Sheet'!C103","v":"1M+S839450"},{"$f":"'Input Sheet'!D103","v":2008},{"$f":"'Input Sheet'!E103","v":"COOPER"},{"$f":"'Input Sheet'!F103","v":35155},{"$f":"'Input Sheet'!G103","v":0},{"$f":"'Input Sheet'!H103","v":0},{"$f":"'Input Sheet'!I103","v":0},{"$f":"'Input Sheet'!J103","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L103","v":90.95},{"$f":"'Input Sheet'!M103","v":0.3},{"$f":"'Input Sheet'!N103","v":774},{"$f":"'Input Sheet'!O103","v":35},10.5,{"$f":"'Input Sheet'!Q103","v":189},{"$f":"'Input Sheet'!R103","v":1.4},{"$f":"'Input Sheet'!S103","v":774},{"$f":"'Input Sheet'!T103","v":35},49,{"$f":"'Input Sheet'!V103","v":59.5},{"$f":"'Input Sheet'!W103","v":0}]
[{"$f":"'Input Sheet'!C104","v":"1M+S839452"},{"$f":"'Input Sheet'!D104","v":2009},{"$f":"'Input Sheet'!E104","v":"COOPER"},{"$f":"'Input Sheet'!F104","v":91119},{"$f":"'Input Sheet'!G104","v":90.95},{"$f":"'Input Sheet'!H104","v":1},{"$f":"'Input Sheet'!I104","v":1489},{"$f":"'Input Sheet'!J104","v":19},19,{"$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!"},{"$f":"'Input Sheet'!V104","v":19},{"$f":"'Input Sheet'!W104","v":1}]
[{"$f":"'Input Sheet'!C105","v":"1M+S839462"},{"$f":"'Input Sheet'!D105","v":2011},{"$f":"'Input Sheet'!E105","v":"COOPER"},{"$f":"'Input Sheet'!F105","v":76633},{"$f":"'Input Sheet'!G105","v":0},{"$f":"'Input Sheet'!H105","v":0},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L105","v":621},{"$f":"'Input Sheet'!M105","v":4.5999999999999996},{"$f":"'Input Sheet'!N105","v":464},{"$f":"'Input Sheet'!O105","v":27},124.19999999999999,{"$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!"},{"$f":"'Input Sheet'!V105","v":124.19999999999999},{"$f":"'Input Sheet'!W105","v":1}]
["RO's 51-100",null,null,"Totals",{"$f":"SUM(E6:E55)","v":2019.7700000000009},{"$f":"SUM(F6:F55)","v":16.300000000000004},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J6:J55)","v":6339.36},{"$f":"SUM(K6:K55)","v":56.9},null,null,{"$f":"SUM(N6:N55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O6:O55)","v":5490.5},{"$f":"SUM(P6:P55)","v":41.5},null,null,{"$f":"SUM(S6:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T6:T55)","v":3080.2750000000001},{"$f":"COUNTIF(U5:U55,1)","v":12}]
["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":3737.8100000000018},"÷",{"$f":"'RO Report 1-50'!F56+'RO Report 51-100'!F56","v":34.200000000000003},"=",{"$f":"IF(ISERROR(E5/G5),\"\",E5/G5)","v":109.29269005847958},"FRH Average"]
[null,null,"Maintenance",null,{"$f":"'RO Report 1-50'!J56+'RO Report 51-100'!J56","v":11515.009999999998},"÷",{"$f":"'RO Report 1-50'!K56+'RO Report 51-100'!K56","v":100.6},"=",{"$f":"IF(ISERROR(E6/G6),\"\",E6/G6)","v":114.46332007952286},"FRH Average"]
[null,null,"Repair",null,{"$f":"'RO Report 1-50'!O56+'RO Report 51-100'!O56","v":11277},"÷",{"$f":"'RO Report 1-50'!P56+'RO Report 51-100'!P56","v":84.2},"=",{"$f":"IF(ISERROR(E7/G7),\"\",E7/G7)","v":133.93111638954869},"FRH Average"]
[null,null,"Totals",null,{"$f":"SUM(E5:E7)","v":26529.82},"÷",{"$f":"SUM(G5:G7)","v":219},"=",{"$f":"IF(ISERROR(E8/G8),\"\",E8/G8)","v":121.1407305936073},"Customer ELR"]
[null,null,null,null,null,null,null,"Target Labor Rate",126.5,"Per FRH"]
[null,null,"Total Ro's in Sample",null,25,null,null,"Difference",{"$f":"IF(ISERROR(I8-I9),\"\",I8-I9)","v":-5.3592694063926984},"Per FRH"]
[]
[null,null,"Cost of Labor"]
[null,null,"Total Cost of Labor",null,{"$f":"'Input Sheet'!V106","v":6018.0749999999989},"÷","Total Sales","=",{"$f":"IF(ISERROR(E13/E8),\"\",E13/E8)","v":0.22684190846375885},"Percent Cost of Sales"]
[null,null,"Total Cost of Labor",null,{"$f":"E13","v":6018.0749999999989},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E14/G8),\"\",E14/G8)","v":27.479794520547941},"Cost per FRH"]
[]
[null,null,"Repair Order Measurements"]
[null,null,"Total Labor Sales",null,{"$f":"E8","v":26529.82},"÷","Total RO's","=",{"$f":"IF(ISERROR(E17/E10),\"\",E17/E10)","v":1061.1928},"Avg Labor per RO"]
[null,null,"Total FRH's",null,{"$f":"G8","v":219},"÷","Total RO's","=",{"$f":"IF(ISERROR(E18/E10),\"\",E18/E10)","v":8.76},"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":34.200000000000003},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E20/G8),\"\",(E20/G8))","v":0.15616438356164386},"Percent Competitive"]
[null,null,"Maintenance FRH's",null,{"$f":"G6","v":100.6},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E21/G8),\"\",(E21/G8))","v":0.45936073059360727},"Percent Maintenance "]
[null,null,"Repair FRH'",null,{"$f":"G7","v":84.2},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E22/G8),\"\",E22/G8)","v":0.38447488584474887},"Percent Repair "]
[null,null,"One item RO's",null,{"$f":"'RO Report 1-50'!U56+'RO Report 51-100'!U56","v":26},"÷","Total RO's","=",{"$f":"IF(ISERROR(E23/E10),\"\",E23/E10)","v":1.04},"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":3},{"$f":"COUNTIF('Input Sheet'!D6:D105,E26)","v":4},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,G26)","v":8},{"$f":"COUNTIF('Input Sheet'!D6:D105,H26)","v":8},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,J26)","v":15},{"$f":"L27-(SUM(C27:J27))","v":62},{"$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.03},{"$f":"IF(ISERROR(E27/L27),\"\",E27/L27)","v":0.04},null,{"$f":"IF(ISERROR(G27/L27),\"\",G27/L27)","v":0.08},{"$f":"IF(ISERROR(H27/L27),\"\",H27/L27)","v":0.08},null,{"$f":"IF(ISERROR(J27/L27),\"\",J27/L27)","v":0.15},{"$f":"IF(ISERROR(K27/L27),\"\",K27/L27)","v":0.62}]