{"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":"2018-05-03"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"Tech #","Tech Pay Per FRH"]
[]
[]
[]
[]
[]
[null,null,null,"          "]

{"sheet":"Input Sheet","index":2,"n_rows":113,"n_cols":23,"rows_kept":113,"cut":false,"hidden":false,"merged":[[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],[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],[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],[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]]}
[]
[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,188333,2011,"Camry",64665,{"$f":"'Input Sheet'!I6","v":400},{"$f":"'Input Sheet'!J6","v":20},{"$f":"'Input Sheet'!K6","v":400},{"$f":"'Input Sheet'!L6","v":20},{"$f":"H6*J6","v":400},20,0.4,{"$f":"'Input Sheet'!K6","v":400},{"$f":"'Input Sheet'!L6","v":20},{"$f":"M6*O6","v":8},0,{"$f":"'Input Sheet'!T6","v":20},{"$f":"'Input Sheet'!U6","v":400},{"$f":"'Input Sheet'!V6","v":20},{"$f":"R6*T6","v":400},20,1]
[null,2,188337,2006,"4Runner",139923,{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":0},{"$f":"'Input Sheet'!K7","v":0},{"$f":"'Input Sheet'!L7","v":""},{"$f":"H7*J7","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!N7","v":0},{"$f":"'Input Sheet'!O7","v":0},{"$f":"'Input Sheet'!K7","v":0},{"$f":"'Input Sheet'!L7","v":""},{"$f":"M7*O7","v":{"$error":"#VALUE!"}},35.700000000000003,0.3,{"$f":"'Input Sheet'!U7","v":10.71},{"$f":"'Input Sheet'!V7","v":35.700000000000003},{"$f":"R7*T7","v":10.71},35.700000000000003,1]
[null,3,188343,2013,"Sequoia",99915,19.95,0.15,{"$f":"'Input Sheet'!K8","v":8.2424999999999997},{"$f":"'Input Sheet'!L8","v":54.95},8.2424999999999997,54.95,0.6,{"$f":"'Input Sheet'!K8","v":8.2424999999999997},{"$f":"'Input Sheet'!L8","v":54.95},32.97,29.95,0.4,{"$f":"'Input Sheet'!U8","v":41.94},{"$f":"'Input Sheet'!V8","v":104.85},41.94,104.85,3]
[null,4,188344,2014,"LEXUS",31093,{"$f":"'Input Sheet'!I9","v":400},{"$f":"'Input Sheet'!J9","v":20},{"$f":"'Input Sheet'!K9","v":400},{"$f":"'Input Sheet'!L9","v":20},400,20,0.35,{"$f":"'Input Sheet'!K9","v":400},{"$f":"'Input Sheet'!L9","v":20},7,{"$f":"'Input Sheet'!S9","v":400},{"$f":"'Input Sheet'!T9","v":20},{"$f":"'Input Sheet'!U9","v":400},{"$f":"'Input Sheet'!V9","v":20},400,20,2]
[null,5,188345,2014,"COROLLA",8947,{"$f":"'Input Sheet'!I10","v":0},{"$f":"'Input Sheet'!J10","v":0},{"$f":"'Input Sheet'!K10","v":0},{"$f":"'Input Sheet'!L10","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N10","v":0},{"$f":"'Input Sheet'!O10","v":0},{"$f":"'Input Sheet'!K10","v":0},{"$f":"'Input Sheet'!L10","v":""},{"$error":"#VALUE!"},119.99,1,{"$f":"'Input Sheet'!U10","v":0},{"$f":"'Input Sheet'!V10","v":0},0,{"$f":"'Input Sheet'!X10","v":0},1]
[null,6,188348,2011,"Camry",85279,89.95,1.2,{"$f":"'Input Sheet'!K11","v":0},{"$f":"'Input Sheet'!L11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N11","v":0},{"$f":"'Input Sheet'!O11","v":0},{"$f":"'Input Sheet'!K11","v":0},{"$f":"'Input Sheet'!L11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S11","v":8091.0025000000005},{"$f":"'Input Sheet'!T11","v":89.95},{"$f":"'Input Sheet'!U11","v":8091.0025000000005},{"$f":"'Input Sheet'!V11","v":89.95},8091.0025000000005,89.95,1]
[null,7,188350,2015,"Camry",35674,119.99,1,{"$f":"'Input Sheet'!K12","v":0},{"$f":"'Input Sheet'!L12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N12","v":0},{"$f":"'Input Sheet'!O12","v":0},{"$f":"'Input Sheet'!K12","v":0},{"$f":"'Input Sheet'!L12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S12","v":14161},{"$f":"'Input Sheet'!T12","v":119},{"$f":"'Input Sheet'!U12","v":14161},{"$f":"'Input Sheet'!V12","v":119},14161,119,1]
[null,8,188351,2006,"AVALON",145971,89.95,1.2,{"$f":"'Input Sheet'!K13","v":0},{"$f":"'Input Sheet'!L13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N13","v":0},{"$f":"'Input Sheet'!O13","v":0},{"$f":"'Input Sheet'!K13","v":0},{"$f":"'Input Sheet'!L13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S13","v":8091.0025000000005},{"$f":"'Input Sheet'!T13","v":89.95},{"$f":"'Input Sheet'!U13","v":8091.0025000000005},{"$f":"'Input Sheet'!V13","v":89.95},8091.0025000000005,89.95,2]
[null,9,188353,2009,"CAMRY",58973,{"$f":"'Input Sheet'!I14","v":400},{"$f":"'Input Sheet'!J14","v":20},{"$f":"'Input Sheet'!K14","v":400},{"$f":"'Input Sheet'!L14","v":20},400,20,0.64,{"$f":"'Input Sheet'!K14","v":400},{"$f":"'Input Sheet'!L14","v":20},12.8,{"$f":"'Input Sheet'!S14","v":400},{"$f":"'Input Sheet'!T14","v":20},{"$f":"'Input Sheet'!U14","v":400},{"$f":"'Input Sheet'!V14","v":20},400,20,1]
[null,10,188354,2011,"CAMRY",71094,89.95,1.2,{"$f":"'Input Sheet'!K15","v":0},{"$f":"'Input Sheet'!L15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N15","v":0},{"$f":"'Input Sheet'!O15","v":0},{"$f":"'Input Sheet'!K15","v":0},{"$f":"'Input Sheet'!L15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S15","v":8091.0025000000005},{"$f":"'Input Sheet'!T15","v":89.95},{"$f":"'Input Sheet'!U15","v":8091.0025000000005},{"$f":"'Input Sheet'!V15","v":89.95},8091.0025000000005,89.95,2]
[null,11,188355,2008,"LEXUS",101626,{"$f":"'Input Sheet'!I16","v":400},{"$f":"'Input Sheet'!J16","v":20},{"$f":"'Input Sheet'!K16","v":400},{"$f":"'Input Sheet'!L16","v":20},400,20,0.4,{"$f":"'Input Sheet'!K16","v":400},{"$f":"'Input Sheet'!L16","v":20},8,{"$f":"'Input Sheet'!S16","v":1844.7025000000003},{"$f":"'Input Sheet'!T16","v":42.95},{"$f":"'Input Sheet'!U16","v":1844.7025000000003},{"$f":"'Input Sheet'!V16","v":42.95},1844.7025000000003,42.95,1]
[null,12,188356,2010,"SCION XD",125764,119.99,1,{"$f":"'Input Sheet'!K17","v":0},{"$f":"'Input Sheet'!L17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N17","v":0},{"$f":"'Input Sheet'!O17","v":0},{"$f":"'Input Sheet'!K17","v":0},{"$f":"'Input Sheet'!L17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S17","v":14161},{"$f":"'Input Sheet'!T17","v":119},{"$f":"'Input Sheet'!U17","v":14161},{"$f":"'Input Sheet'!V17","v":119},14161,119,1]
[null,13,188359,2015,"CAMRY",24457,{"$f":"'Input Sheet'!I18","v":400},{"$f":"'Input Sheet'!J18","v":20},{"$f":"'Input Sheet'!K18","v":400},{"$f":"'Input Sheet'!L18","v":20},400,20,0.4,{"$f":"'Input Sheet'!K18","v":400},{"$f":"'Input Sheet'!L18","v":20},8,{"$f":"'Input Sheet'!S18","v":400},{"$f":"'Input Sheet'!T18","v":20},{"$f":"'Input Sheet'!U18","v":400},{"$f":"'Input Sheet'!V18","v":20},400,20,2]
[null,14,188361,2015,"CAMRY",43270,{"$f":"'Input Sheet'!I19","v":1764},{"$f":"'Input Sheet'!J19","v":42},{"$f":"'Input Sheet'!K19","v":1764},{"$f":"'Input Sheet'!L19","v":42},1764,42,0.6,{"$f":"'Input Sheet'!K19","v":1764},{"$f":"'Input Sheet'!L19","v":42},25.2,{"$f":"'Input Sheet'!S19","v":5176.8025000000007},{"$f":"'Input Sheet'!T19","v":71.95},{"$f":"'Input Sheet'!U19","v":5176.8025000000007},{"$f":"'Input Sheet'!V19","v":71.95},5176.8025000000007,71.95,1]
[null,15,188362,2012,"CAMRY",100597,{"$f":"'Input Sheet'!I20","v":400},{"$f":"'Input Sheet'!J20","v":20},{"$f":"'Input Sheet'!K20","v":400},{"$f":"'Input Sheet'!L20","v":20},400,20,0.4,{"$f":"'Input Sheet'!K20","v":400},{"$f":"'Input Sheet'!L20","v":20},8,{"$f":"'Input Sheet'!S20","v":400},{"$f":"'Input Sheet'!T20","v":20},{"$f":"'Input Sheet'!U20","v":400},{"$f":"'Input Sheet'!V20","v":20},400,20,1]
[null,16,188364,2008,"FJ CRUSIER",116692,{"$f":"'Input Sheet'!I21","v":400},{"$f":"'Input Sheet'!J21","v":20},{"$f":"'Input Sheet'!K21","v":400},{"$f":"'Input Sheet'!L21","v":20},400,20,0.4,{"$f":"'Input Sheet'!K21","v":400},{"$f":"'Input Sheet'!L21","v":20},8,{"$f":"'Input Sheet'!S21","v":1844.7025000000003},{"$f":"'Input Sheet'!T21","v":42.95},{"$f":"'Input Sheet'!U21","v":1844.7025000000003},{"$f":"'Input Sheet'!V21","v":42.95},1844.7025000000003,42.95,1]
[null,17,188366,2013,"PRIUS",96180,{"$f":"'Input Sheet'!I22","v":400},{"$f":"'Input Sheet'!J22","v":20},{"$f":"'Input Sheet'!K22","v":400},{"$f":"'Input Sheet'!L22","v":20},400,20,0.4,{"$f":"'Input Sheet'!K22","v":400},{"$f":"'Input Sheet'!L22","v":20},8,{"$f":"'Input Sheet'!S22","v":2495.0025000000005},{"$f":"'Input Sheet'!T22","v":49.95},{"$f":"'Input Sheet'!U22","v":2495.0025000000005},{"$f":"'Input Sheet'!V22","v":49.95},2495.0025000000005,49.95,1]
[null,18,188367,2014,"TACOMA",53420,{"$f":"'Input Sheet'!I23","v":400},{"$f":"'Input Sheet'!J23","v":20},{"$f":"'Input Sheet'!K23","v":400},{"$f":"'Input Sheet'!L23","v":20},400,20,0.4,{"$f":"'Input Sheet'!K23","v":400},{"$f":"'Input Sheet'!L23","v":20},8,{"$f":"'Input Sheet'!S23","v":3019.5025000000005},{"$f":"'Input Sheet'!T23","v":54.95},{"$f":"'Input Sheet'!U23","v":3019.5025000000005},{"$f":"'Input Sheet'!V23","v":54.95},3019.5025000000005,54.95,3]
[null,19,188369,2012,"SCION XB",56386,{"$f":"'Input Sheet'!I24","v":400},{"$f":"'Input Sheet'!J24","v":20},{"$f":"'Input Sheet'!K24","v":400},{"$f":"'Input Sheet'!L24","v":20},400,20,0.4,{"$f":"'Input Sheet'!K24","v":400},{"$f":"'Input Sheet'!L24","v":20},8,{"$f":"'Input Sheet'!S24","v":1596.0025000000003},{"$f":"'Input Sheet'!T24","v":39.950000000000003},{"$f":"'Input Sheet'!U24","v":1596.0025000000003},{"$f":"'Input Sheet'!V24","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[null,20,188370,2011,"COROLLA",93014,{"$f":"'Input Sheet'!I25","v":100},{"$f":"'Input Sheet'!J25","v":10},{"$f":"'Input Sheet'!K25","v":100},{"$f":"'Input Sheet'!L25","v":10},100,10,0.4,{"$f":"'Input Sheet'!K25","v":100},{"$f":"'Input Sheet'!L25","v":10},4,{"$f":"'Input Sheet'!S25","v":2495.0025000000005},{"$f":"'Input Sheet'!T25","v":49.95},{"$f":"'Input Sheet'!U25","v":2495.0025000000005},{"$f":"'Input Sheet'!V25","v":49.95},2495.0025000000005,49.95,1]
[null,21,188371,2015,"CAMRY",53107,{"$f":"'Input Sheet'!I26","v":100},{"$f":"'Input Sheet'!J26","v":10},{"$f":"'Input Sheet'!K26","v":100},{"$f":"'Input Sheet'!L26","v":10},100,10,0.4,{"$f":"'Input Sheet'!K26","v":100},{"$f":"'Input Sheet'!L26","v":10},4,{"$f":"'Input Sheet'!S26","v":2495.0025000000005},{"$f":"'Input Sheet'!T26","v":49.95},{"$f":"'Input Sheet'!U26","v":2495.0025000000005},{"$f":"'Input Sheet'!V26","v":49.95},2495.0025000000005,49.95,1]
[null,22,188372,2009,"AVALON",183323,89.95,1.2,{"$f":"'Input Sheet'!K27","v":0},{"$f":"'Input Sheet'!L27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N27","v":0},{"$f":"'Input Sheet'!O27","v":0},{"$f":"'Input Sheet'!K27","v":0},{"$f":"'Input Sheet'!L27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S27","v":8091.0025000000005},{"$f":"'Input Sheet'!T27","v":89.95},{"$f":"'Input Sheet'!U27","v":8091.0025000000005},{"$f":"'Input Sheet'!V27","v":89.95},8091.0025000000005,89.95,1]
[null,23,188373,2011,"CAMRY",72797,89.95,1.2,{"$f":"'Input Sheet'!K28","v":0},{"$f":"'Input Sheet'!L28","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N28","v":0},{"$f":"'Input Sheet'!O28","v":0},{"$f":"'Input Sheet'!K28","v":0},{"$f":"'Input Sheet'!L28","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S28","v":8091.0025000000005},{"$f":"'Input Sheet'!T28","v":89.95},{"$f":"'Input Sheet'!U28","v":8091.0025000000005},{"$f":"'Input Sheet'!V28","v":89.95},8091.0025000000005,89.95,1]
[null,24,188375,1997,"4 RUNNER",182844,{"$f":"'Input Sheet'!I29","v":400},{"$f":"'Input Sheet'!J29","v":20},{"$f":"'Input Sheet'!K29","v":400},{"$f":"'Input Sheet'!L29","v":20},400,20,0.4,{"$f":"'Input Sheet'!K29","v":400},{"$f":"'Input Sheet'!L29","v":20},8,{"$f":"'Input Sheet'!S29","v":2111.4025000000001},{"$f":"'Input Sheet'!T29","v":45.95},{"$f":"'Input Sheet'!U29","v":2111.4025000000001},{"$f":"'Input Sheet'!V29","v":45.95},2111.4025000000001,45.95,1]
[null,25,188383,2007,"CAMRY",163777,{"$f":"'Input Sheet'!I30","v":400},{"$f":"'Input Sheet'!J30","v":20},{"$f":"'Input Sheet'!K30","v":400},{"$f":"'Input Sheet'!L30","v":20},400,20,0.4,{"$f":"'Input Sheet'!K30","v":400},{"$f":"'Input Sheet'!L30","v":20},8,{"$f":"'Input Sheet'!S30","v":1596.0025000000003},{"$f":"'Input Sheet'!T30","v":39.950000000000003},{"$f":"'Input Sheet'!U30","v":1596.0025000000003},{"$f":"'Input Sheet'!V30","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[null,26,188384,2016,"RAV 4",76906,28.95,0.21,{"$f":"'Input Sheet'!K31","v":0},{"$f":"'Input Sheet'!L31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N31","v":0},{"$f":"'Input Sheet'!O31","v":0},{"$f":"'Input Sheet'!K31","v":0},{"$f":"'Input Sheet'!L31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S31","v":838.10249999999996},{"$f":"'Input Sheet'!T31","v":28.95},{"$f":"'Input Sheet'!U31","v":838.10249999999996},{"$f":"'Input Sheet'!V31","v":28.95},838.10249999999996,28.95,2]
[null,27,188385,2013,"COROLLA",67773,{"$f":"'Input Sheet'!I32","v":400},{"$f":"'Input Sheet'!J32","v":20},{"$f":"'Input Sheet'!K32","v":400},{"$f":"'Input Sheet'!L32","v":20},400,20,0.4,{"$f":"'Input Sheet'!K32","v":400},{"$f":"'Input Sheet'!L32","v":20},8,{"$f":"'Input Sheet'!S32","v":2495.0025000000005},{"$f":"'Input Sheet'!T32","v":49.95},{"$f":"'Input Sheet'!U32","v":2495.0025000000005},{"$f":"'Input Sheet'!V32","v":49.95},2495.0025000000005,49.95,1]
[null,28,"188387C",2016,"HIGHLANDWE",32604,89.95,1.2,{"$f":"'Input Sheet'!K33","v":0},{"$f":"'Input Sheet'!L33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N33","v":0},{"$f":"'Input Sheet'!O33","v":0},{"$f":"'Input Sheet'!K33","v":0},{"$f":"'Input Sheet'!L33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S33","v":8091.0025000000005},{"$f":"'Input Sheet'!T33","v":89.95},{"$f":"'Input Sheet'!U33","v":8091.0025000000005},{"$f":"'Input Sheet'!V33","v":89.95},8091.0025000000005,89.95,1]
[null,29,188388,2003,"SEQUOIA",61036,{"$f":"'Input Sheet'!I34","v":400},{"$f":"'Input Sheet'!J34","v":20},{"$f":"'Input Sheet'!K34","v":400},{"$f":"'Input Sheet'!L34","v":20},400,20,0.4,{"$f":"'Input Sheet'!K34","v":400},{"$f":"'Input Sheet'!L34","v":20},8,{"$f":"'Input Sheet'!S34","v":2111.4025000000001},{"$f":"'Input Sheet'!T34","v":45.95},{"$f":"'Input Sheet'!U34","v":2111.4025000000001},{"$f":"'Input Sheet'!V34","v":45.95},2111.4025000000001,45.95,1]
[null,30,188390,2005,"CAMRY",223961,64.31,0.7,{"$f":"'Input Sheet'!K35","v":0},{"$f":"'Input Sheet'!L35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N35","v":0},{"$f":"'Input Sheet'!O35","v":0},{"$f":"'Input Sheet'!K35","v":0},{"$f":"'Input Sheet'!L35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S35","v":14871.802500000002},{"$f":"'Input Sheet'!T35","v":121.95},{"$f":"'Input Sheet'!U35","v":14871.802500000002},{"$f":"'Input Sheet'!V35","v":121.95},14871.802500000002,121.95,5]
[null,31,188391,2016,"CAMRY",30395,15,0.4,{"$f":"'Input Sheet'!K36","v":0},{"$f":"'Input Sheet'!L36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N36","v":0},{"$f":"'Input Sheet'!O36","v":0},{"$f":"'Input Sheet'!K36","v":0},{"$f":"'Input Sheet'!L36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S36","v":1288.81},{"$f":"'Input Sheet'!T36","v":35.9},{"$f":"'Input Sheet'!U36","v":1288.81},{"$f":"'Input Sheet'!V36","v":35.9},1288.81,35.9,1]
[null,32,188392,2013,"AVALON",66748,22.99,0.3,{"$f":"'Input Sheet'!K37","v":0},{"$f":"'Input Sheet'!L37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N37","v":0},{"$f":"'Input Sheet'!O37","v":0},{"$f":"'Input Sheet'!K37","v":0},{"$f":"'Input Sheet'!L37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S37","v":528.54009999999994},{"$f":"'Input Sheet'!T37","v":22.99},{"$f":"'Input Sheet'!U37","v":528.54009999999994},{"$f":"'Input Sheet'!V37","v":22.99},528.54009999999994,22.99,1]
[null,33,188393,2008,"CAMRY HYBRID",80067,{"$f":"'Input Sheet'!I38","v":400},{"$f":"'Input Sheet'!J38","v":20},{"$f":"'Input Sheet'!K38","v":400},{"$f":"'Input Sheet'!L38","v":20},400,20,0.4,{"$f":"'Input Sheet'!K38","v":400},{"$f":"'Input Sheet'!L38","v":20},8,{"$f":"'Input Sheet'!S38","v":1596.0025000000003},{"$f":"'Input Sheet'!T38","v":39.950000000000003},{"$f":"'Input Sheet'!U38","v":1596.0025000000003},{"$f":"'Input Sheet'!V38","v":39.950000000000003},1596.0025000000003,39.950000000000003,2]
[null,34,188394,2007,"COROLLA",187558,{"$f":"'Input Sheet'!I39","v":1764},{"$f":"'Input Sheet'!J39","v":42},{"$f":"'Input Sheet'!K39","v":1764},{"$f":"'Input Sheet'!L39","v":42},1764,42,0.6,{"$f":"'Input Sheet'!K39","v":1764},{"$f":"'Input Sheet'!L39","v":42},25.2,{"$f":"'Input Sheet'!S39","v":3794.5600000000004},{"$f":"'Input Sheet'!T39","v":61.6},{"$f":"'Input Sheet'!U39","v":3794.5600000000004},{"$f":"'Input Sheet'!V39","v":61.6},3794.5600000000004,61.6,3]
[null,35,188395,2013,"CAMRY",54949,{"$f":"'Input Sheet'!I40","v":400},{"$f":"'Input Sheet'!J40","v":20},{"$f":"'Input Sheet'!K40","v":400},{"$f":"'Input Sheet'!L40","v":20},400,20,0.4,{"$f":"'Input Sheet'!K40","v":400},{"$f":"'Input Sheet'!L40","v":20},8,{"$f":"'Input Sheet'!S40","v":1221.5025000000003},{"$f":"'Input Sheet'!T40","v":34.950000000000003},{"$f":"'Input Sheet'!U40","v":1221.5025000000003},{"$f":"'Input Sheet'!V40","v":34.950000000000003},1221.5025000000003,34.950000000000003,2]
[null,36,188398,2009,"TUNDRA",88510,{"$f":"'Input Sheet'!I41","v":400},{"$f":"'Input Sheet'!J41","v":20},{"$f":"'Input Sheet'!K41","v":400},{"$f":"'Input Sheet'!L41","v":20},400,20,0.4,{"$f":"'Input Sheet'!K41","v":400},{"$f":"'Input Sheet'!L41","v":20},8,{"$f":"'Input Sheet'!S41","v":2111.4025000000001},{"$f":"'Input Sheet'!T41","v":45.95},{"$f":"'Input Sheet'!U41","v":2111.4025000000001},{"$f":"'Input Sheet'!V41","v":45.95},2111.4025000000001,45.95,1]
[null,37,188399,2009,"LEXUS",121680,{"$f":"'Input Sheet'!I42","v":400},{"$f":"'Input Sheet'!J42","v":20},{"$f":"'Input Sheet'!K42","v":400},{"$f":"'Input Sheet'!L42","v":20},400,20,0.4,{"$f":"'Input Sheet'!K42","v":400},{"$f":"'Input Sheet'!L42","v":20},8,{"$f":"'Input Sheet'!S42","v":2111.4025000000001},{"$f":"'Input Sheet'!T42","v":45.95},{"$f":"'Input Sheet'!U42","v":2111.4025000000001},{"$f":"'Input Sheet'!V42","v":45.95},2111.4025000000001,45.95,1]
[null,38,188400,2008,"LEXUS",134079,{"$f":"'Input Sheet'!I43","v":400},{"$f":"'Input Sheet'!J43","v":20},{"$f":"'Input Sheet'!K43","v":400},{"$f":"'Input Sheet'!L43","v":20},400,20,0.4,{"$f":"'Input Sheet'!K43","v":400},{"$f":"'Input Sheet'!L43","v":20},8,{"$f":"'Input Sheet'!S43","v":2860.1103999999996},{"$f":"'Input Sheet'!T43","v":53.48},{"$f":"'Input Sheet'!U43","v":2860.1103999999996},{"$f":"'Input Sheet'!V43","v":53.48},2860.1103999999996,53.48,1]
[null,39,188401,2016,"SCION IM",44851,{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":0},{"$f":"'Input Sheet'!K44","v":0},{"$f":"'Input Sheet'!L44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N44","v":0},{"$f":"'Input Sheet'!O44","v":0},{"$f":"'Input Sheet'!K44","v":0},{"$f":"'Input Sheet'!L44","v":""},{"$error":"#VALUE!"},159.99,2,{"$f":"'Input Sheet'!U44","v":429.98},{"$f":"'Input Sheet'!V44","v":214.99},429.98,214.99,1]
[null,40,188402,2016,"TACOMA",36943,{"$f":"'Input Sheet'!I45","v":484},{"$f":"'Input Sheet'!J45","v":22},{"$f":"'Input Sheet'!K45","v":484},{"$f":"'Input Sheet'!L45","v":22},484,22,0.6,{"$f":"'Input Sheet'!K45","v":484},{"$f":"'Input Sheet'!L45","v":22},13.2,{"$f":"'Input Sheet'!S45","v":2124.2881000000002},{"$f":"'Input Sheet'!T45","v":46.09},{"$f":"'Input Sheet'!U45","v":2124.2881000000002},{"$f":"'Input Sheet'!V45","v":46.09},2124.2881000000002,46.09,1]
[null,41,188404,2011,"COROLLA",50202,{"$f":"'Input Sheet'!I46","v":400},{"$f":"'Input Sheet'!J46","v":20},{"$f":"'Input Sheet'!K46","v":400},{"$f":"'Input Sheet'!L46","v":20},400,20,0.4,{"$f":"'Input Sheet'!K46","v":400},{"$f":"'Input Sheet'!L46","v":20},8,{"$f":"'Input Sheet'!S46","v":1596.0025000000003},{"$f":"'Input Sheet'!T46","v":39.950000000000003},{"$f":"'Input Sheet'!U46","v":1596.0025000000003},{"$f":"'Input Sheet'!V46","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[null,42,188405,2008,"LEXUS",76407,{"$f":"'Input Sheet'!I47","v":400},{"$f":"'Input Sheet'!J47","v":20},{"$f":"'Input Sheet'!K47","v":400},{"$f":"'Input Sheet'!L47","v":20},400,20,0.4,{"$f":"'Input Sheet'!K47","v":400},{"$f":"'Input Sheet'!L47","v":20},8,{"$f":"'Input Sheet'!S47","v":2396.1025000000004},{"$f":"'Input Sheet'!T47","v":48.95},{"$f":"'Input Sheet'!U47","v":2396.1025000000004},{"$f":"'Input Sheet'!V47","v":48.95},2396.1025000000004,48.95,1]
[null,43,188407,2014,"CAMRY",55017,90.29,1,{"$f":"'Input Sheet'!K48","v":0},{"$f":"'Input Sheet'!L48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N48","v":0},{"$f":"'Input Sheet'!O48","v":0},{"$f":"'Input Sheet'!K48","v":0},{"$f":"'Input Sheet'!L48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S48","v":19897.923600000002},{"$f":"'Input Sheet'!T48","v":141.06},{"$f":"'Input Sheet'!U48","v":19897.923600000002},{"$f":"'Input Sheet'!V48","v":141.06},19897.923600000002,141.06,1]
[null,44,188409,2002,"HIGHLANDER",235329,{"$f":"'Input Sheet'!I49","v":400},{"$f":"'Input Sheet'!J49","v":20},{"$f":"'Input Sheet'!K49","v":400},{"$f":"'Input Sheet'!L49","v":20},400,20,0.4,{"$f":"'Input Sheet'!K49","v":400},{"$f":"'Input Sheet'!L49","v":20},8,{"$f":"'Input Sheet'!S49","v":2202.4249},{"$f":"'Input Sheet'!T49","v":46.93},{"$f":"'Input Sheet'!U49","v":2202.4249},{"$f":"'Input Sheet'!V49","v":46.93},2202.4249,46.93,1]
[null,45,188411,2013,"TACOMA",70174,138,1.5,{"$f":"'Input Sheet'!K50","v":0},{"$f":"'Input Sheet'!L50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N50","v":0},{"$f":"'Input Sheet'!O50","v":0},{"$f":"'Input Sheet'!K50","v":0},{"$f":"'Input Sheet'!L50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S50","v":69142.702499999999},{"$f":"'Input Sheet'!T50","v":262.95},{"$f":"'Input Sheet'!U50","v":69142.702499999999},{"$f":"'Input Sheet'!V50","v":262.95},69142.702499999999,262.95,3]
[null,46,188412,2015,"CAMRY",52290,{"$f":"'Input Sheet'!I51","v":0},{"$f":"'Input Sheet'!J51","v":20},{"$f":"'Input Sheet'!K51","v":0},{"$f":"'Input Sheet'!L51","v":20},{"$f":"H55*J51","v":0},20,0.4,{"$f":"'Input Sheet'!K51","v":0},{"$f":"'Input Sheet'!L51","v":20},8,{"$f":"'Input Sheet'!S51","v":2495.0025000000005},{"$f":"'Input Sheet'!T51","v":49.95},{"$f":"'Input Sheet'!U51","v":2495.0025000000005},{"$f":"'Input Sheet'!V51","v":49.95},2495.0025000000005,49.95,1]
[null,47,"188413C",2016,"CAMRY",40114,119.99,1.2,{"$f":"'Input Sheet'!K99","v":0},{"$f":"'Input Sheet'!L99","v":0},0,{"$f":"'Input Sheet'!N52","v":0},{"$f":"'Input Sheet'!O52","v":0},{"$f":"'Input Sheet'!K99","v":0},{"$f":"'Input Sheet'!L99","v":0},0,{"$f":"'Input Sheet'!S52","v":0},{"$f":"'Input Sheet'!T52","v":247.6},{"$f":"'Input Sheet'!U99","v":0},{"$f":"'Input Sheet'!V99","v":247.6},61305.759999999995,119.99,2]
[null,48,188414,2011,"AVALON",60096,{"$f":"'Input Sheet'!I53","v":0},{"$f":"'Input Sheet'!J53","v":20},{"$f":"'Input Sheet'!K100","v":0},{"$f":"'Input Sheet'!L100","v":20},400,20,0.4,{"$f":"'Input Sheet'!K100","v":0},{"$f":"'Input Sheet'!L100","v":20},8,{"$f":"'Input Sheet'!S53","v":0},{"$f":"'Input Sheet'!T53","v":49.95},{"$f":"'Input Sheet'!U100","v":0},{"$f":"'Input Sheet'!V100","v":49.95},2495.0025000000005,45.95,1]
[null,49,188415,2016,"COROLLA",18472,{"$f":"'Input Sheet'!I54","v":0},{"$f":"'Input Sheet'!J54","v":20},{"$f":"'Input Sheet'!K101","v":0},{"$f":"'Input Sheet'!L101","v":20},{"$f":"H54*J54","v":400},{"$f":"'Input Sheet'!N54","v":0},0.5,{"$f":"'Input Sheet'!K101","v":0},{"$f":"'Input Sheet'!L101","v":20},{"$f":"M54*O54","v":10},{"$f":"'Input Sheet'!S54","v":0},{"$f":"'Input Sheet'!T54","v":49.95},{"$f":"'Input Sheet'!U101","v":0},{"$f":"'Input Sheet'!V101","v":49.95},{"$f":"R54*T54","v":2495.0025000000005},{"$f":"'Input Sheet'!X54","v":0},1]
[null,50,188416,2008,"CAMRY",82297,{"$f":"'Input Sheet'!I55","v":0},{"$f":"'Input Sheet'!J55","v":0},{"$f":"'Input Sheet'!K105","v":0},{"$f":"'Input Sheet'!L105","v":0},{"$f":"#REF!*J55","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!N55","v":0},{"$f":"'Input Sheet'!O55","v":0},{"$f":"'Input Sheet'!K105","v":0},{"$f":"'Input Sheet'!L105","v":0},0,119.99,1,{"$f":"'Input Sheet'!U105","v":0},{"$f":"'Input Sheet'!V105","v":22.99},22.99,236.11,1]
[null,51,188417,2011,"CAMRY",123056,{"$f":"'Input Sheet'!I106","v":0},{"$f":"'Input Sheet'!J106","v":0},{"$f":"'Input Sheet'!K106","v":0},{"$f":"'Input Sheet'!L106","v":""},{"$f":"H56*J56","v":{"$error":"#VALUE!"}},20,0.4,{"$f":"'Input Sheet'!P106","v":0},{"$f":"'Input Sheet'!Q106","v":239617.32709999999},95846.930840000001,{"$f":"'Input Sheet'!S106","v":0},{"$f":"'Input Sheet'!T106","v":0},{"$f":"'Input Sheet'!U106","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!V106","v":7700.1399999999921},0,49.95,2]
[null,52,188418,2014,"CAMRY",49844,{"$f":"'Input Sheet'!I107","v":0},{"$f":"'Input Sheet'!J107","v":0},{"$f":"'Input Sheet'!K107","v":0},{"$f":"'Input Sheet'!L107","v":"Maintenance Labor"},{"$error":"#VALUE!"},42,0.6,{"$f":"'Input Sheet'!P107","v":0},{"$f":"'Input Sheet'!Q107","v":"Repair Labor"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S107","v":0},{"$f":"'Input Sheet'!T107","v":0},{"$f":"'Input Sheet'!U107","v":0},{"$f":"'Input Sheet'!V107","v":"Total Cost of Labor"},{"$error":"#VALUE!"},71.95,1]
[null,53,188419,2016,"PRIUS",35479,22.99,0.3,{"$f":"'Input Sheet'!K108","v":"Labor Cost "},{"$f":"'Input Sheet'!L108","v":"Labor Sales"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!N108","v":"Technican Number"},{"$f":"'Input Sheet'!O108","v":"Pay Per FRH"},{"$f":"'Input Sheet'!P108","v":"Labor Cost "},{"$f":"'Input Sheet'!Q108","v":"Labor Sales"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!S108","v":"Technican Number"},{"$f":"'Input Sheet'!T108","v":"Pay Per FRH"},{"$f":"'Input Sheet'!U108","v":"Labor Cost "},{"$f":"'Input Sheet'!V108","v":0},{"$error":"#VALUE!"},25.12,1]
[null,54,188420,2015,"COROLLA",63436,{"$f":"'Input Sheet'!I109","v":0},{"$f":"'Input Sheet'!J109","v":0},{"$f":"'Input Sheet'!K109","v":0},{"$f":"'Input Sheet'!L109","v":0},0,20,0.4,{"$f":"'Input Sheet'!P109","v":0},{"$f":"'Input Sheet'!Q109","v":0},0,{"$f":"'Input Sheet'!S109","v":0},{"$f":"'Input Sheet'!T109","v":0},{"$f":"'Input Sheet'!U109","v":0},{"$f":"'Input Sheet'!V109","v":0},0,40.9,1]
[null,55,188422,2017,"CAMRY",31732,22,0.3,{"$f":"'Input Sheet'!K110","v":0},{"$f":"'Input Sheet'!L110","v":0},0,{"$f":"'Input Sheet'!N110","v":0},{"$f":"'Input Sheet'!O110","v":0},{"$f":"'Input Sheet'!P110","v":0},{"$f":"'Input Sheet'!Q110","v":0},0,{"$f":"'Input Sheet'!S110","v":0},{"$f":"'Input Sheet'!T110","v":0},{"$f":"'Input Sheet'!U110","v":0},{"$f":"'Input Sheet'!V110","v":0},0,237.45,1]
[null,56,188423,2007,"AVALON",120429,{"$f":"'Input Sheet'!I111","v":0},{"$f":"'Input Sheet'!J111","v":0},{"$f":"'Input Sheet'!K111","v":0},{"$f":"'Input Sheet'!L111","v":0},0,20,0.4,{"$f":"'Input Sheet'!P111","v":0},{"$f":"'Input Sheet'!Q111","v":0},0,{"$f":"'Input Sheet'!S111","v":0},{"$f":"'Input Sheet'!T111","v":0},{"$f":"'Input Sheet'!U111","v":0},{"$f":"'Input Sheet'!V111","v":0},0,42.95,1]
[null,57,"188424C",2009,"COROLLA",100958,119.99,1,{"$f":"'Input Sheet'!K112","v":0},{"$f":"'Input Sheet'!L112","v":0},0,{"$f":"'Input Sheet'!N112","v":0},{"$f":"'Input Sheet'!O112","v":0},{"$f":"'Input Sheet'!P112","v":0},{"$f":"'Input Sheet'!Q112","v":0},0,{"$f":"'Input Sheet'!S112","v":0},{"$f":"'Input Sheet'!T112","v":0},{"$f":"'Input Sheet'!U112","v":0},{"$f":"'Input Sheet'!V112","v":0},0,131.09,1]
[null,58,188425,2013,"HIGHLANDER",60836,{"$f":"'Input Sheet'!I113","v":0},{"$f":"'Input Sheet'!J113","v":0},{"$f":"'Input Sheet'!K113","v":0},{"$f":"'Input Sheet'!L113","v":0},0,42,0.6,{"$f":"'Input Sheet'!P113","v":0},{"$f":"'Input Sheet'!Q113","v":0},0,{"$f":"'Input Sheet'!S113","v":0},{"$f":"'Input Sheet'!T113","v":0},{"$f":"'Input Sheet'!U113","v":0},{"$f":"'Input Sheet'!V113","v":0},0,76.95,1]
[null,59,188426,2014,"COROLLA",89057,{"$f":"'Input Sheet'!I114","v":0},{"$f":"'Input Sheet'!J114","v":0},{"$f":"'Input Sheet'!K114","v":0},{"$f":"'Input Sheet'!L114","v":0},0,42,0.6,{"$f":"'Input Sheet'!P114","v":0},{"$f":"'Input Sheet'!Q114","v":0},0,{"$f":"'Input Sheet'!S114","v":0},{"$f":"'Input Sheet'!T114","v":0},{"$f":"'Input Sheet'!U114","v":0},{"$f":"'Input Sheet'!V114","v":0},0,83.65,1]
[null,60,188427,2004,"CAMRY",105362,{"$f":"'Input Sheet'!I115","v":0},{"$f":"'Input Sheet'!J115","v":0},{"$f":"'Input Sheet'!K115","v":0},{"$f":"'Input Sheet'!L115","v":0},0,20,0.4,{"$f":"'Input Sheet'!P115","v":0},{"$f":"'Input Sheet'!Q115","v":0},0,{"$f":"'Input Sheet'!S115","v":0},{"$f":"'Input Sheet'!T115","v":0},{"$f":"'Input Sheet'!U115","v":0},{"$f":"'Input Sheet'!V115","v":0},0,49.95,5]
[null,61,188428,2015,"RAV4",25629,22.99,0.3,{"$f":"'Input Sheet'!K116","v":0},{"$f":"'Input Sheet'!L116","v":0},0,{"$f":"'Input Sheet'!N116","v":0},{"$f":"'Input Sheet'!O116","v":0},{"$f":"'Input Sheet'!P116","v":0},{"$f":"'Input Sheet'!Q116","v":0},0,{"$f":"'Input Sheet'!S116","v":0},{"$f":"'Input Sheet'!T116","v":0},{"$f":"'Input Sheet'!U116","v":0},{"$f":"'Input Sheet'!V116","v":0},0,56.75,2]
[null,62,188429,2013,"RAV4",74960,{"$f":"'Input Sheet'!I117","v":0},{"$f":"'Input Sheet'!J117","v":0},{"$f":"'Input Sheet'!K117","v":0},{"$f":"'Input Sheet'!L117","v":0},0,20,0.4,{"$f":"'Input Sheet'!P117","v":0},{"$f":"'Input Sheet'!Q117","v":0},0,{"$f":"'Input Sheet'!S117","v":0},{"$f":"'Input Sheet'!T117","v":0},{"$f":"'Input Sheet'!U117","v":0},{"$f":"'Input Sheet'!V117","v":0},0,49.95,1]
[null,63,"188431C",2016,"4 RUNNER",33251,{"$f":"'Input Sheet'!I118","v":0},{"$f":"'Input Sheet'!J118","v":0},{"$f":"'Input Sheet'!K118","v":0},{"$f":"'Input Sheet'!L118","v":0},0,{"$f":"'Input Sheet'!N118","v":0},{"$f":"'Input Sheet'!O118","v":0},{"$f":"'Input Sheet'!P118","v":0},{"$f":"'Input Sheet'!Q118","v":0},0,22.99,0.4,{"$f":"'Input Sheet'!U118","v":0},{"$f":"'Input Sheet'!V118","v":0},0,25.12,1]
[null,64,188432,2013,"AVALON",109905,{"$f":"'Input Sheet'!I119","v":0},{"$f":"'Input Sheet'!J119","v":0},{"$f":"'Input Sheet'!K119","v":0},{"$f":"'Input Sheet'!L119","v":0},0,20,0.6,{"$f":"'Input Sheet'!P119","v":0},{"$f":"'Input Sheet'!Q119","v":0},0,{"$f":"'Input Sheet'!S119","v":0},{"$f":"'Input Sheet'!T119","v":0},{"$f":"'Input Sheet'!U119","v":0},{"$f":"'Input Sheet'!V119","v":0},0,30.54,1]
[null,65,199434,2004,"AVALON",130944,159.99,2,{"$f":"'Input Sheet'!K120","v":0},{"$f":"'Input Sheet'!L120","v":0},0,{"$f":"'Input Sheet'!N120","v":0},{"$f":"'Input Sheet'!O120","v":0},{"$f":"'Input Sheet'!P120","v":0},{"$f":"'Input Sheet'!Q120","v":0},0,{"$f":"'Input Sheet'!S120","v":0},{"$f":"'Input Sheet'!T120","v":0},{"$f":"'Input Sheet'!U120","v":0},{"$f":"'Input Sheet'!V120","v":0},0,374.99,2]
[null,66,188436,2008,"AVALON",153451,{"$f":"'Input Sheet'!I121","v":0},{"$f":"'Input Sheet'!J121","v":0},{"$f":"'Input Sheet'!K121","v":0},{"$f":"'Input Sheet'!L121","v":0},0,20,0.4,{"$f":"'Input Sheet'!P121","v":0},{"$f":"'Input Sheet'!Q121","v":0},{"$f":"M71*O71","v":0},{"$f":"'Input Sheet'!S121","v":0},{"$f":"'Input Sheet'!T121","v":0},{"$f":"'Input Sheet'!U121","v":0},{"$f":"'Input Sheet'!V121","v":0},{"$f":"R71*T71","v":0},45.95,4]
[null,67,188437,2004,"CELICA",189908,89.95,1.2,{"$f":"'Input Sheet'!K122","v":0},{"$f":"'Input Sheet'!L122","v":0},0,{"$f":"'Input Sheet'!N122","v":0},{"$f":"'Input Sheet'!O122","v":0},{"$f":"'Input Sheet'!P122","v":0},{"$f":"'Input Sheet'!Q122","v":0},0,{"$f":"'Input Sheet'!S122","v":0},{"$f":"'Input Sheet'!T122","v":0},{"$f":"'Input Sheet'!U122","v":0},{"$f":"'Input Sheet'!V122","v":0},0,89.95,3]
[null,68,188438,2001,"LEXUS",63841,{"$f":"'Input Sheet'!I123","v":0},{"$f":"'Input Sheet'!J123","v":0},{"$f":"'Input Sheet'!K123","v":0},{"$f":"'Input Sheet'!L123","v":0},0,20,0.4,{"$f":"'Input Sheet'!P123","v":0},{"$f":"'Input Sheet'!Q123","v":0},0,{"$f":"'Input Sheet'!S123","v":0},{"$f":"'Input Sheet'!T123","v":0},{"$f":"'Input Sheet'!U123","v":0},{"$f":"'Input Sheet'!V123","v":0},0,59.95,1]
[null,69,188439,2010,"SCION XD",65478,22.99,0.3,{"$f":"'Input Sheet'!K124","v":0},{"$f":"'Input Sheet'!L124","v":0},0,{"$f":"'Input Sheet'!N124","v":0},{"$f":"'Input Sheet'!O124","v":0},{"$f":"'Input Sheet'!P124","v":0},{"$f":"'Input Sheet'!Q124","v":0},0,{"$f":"'Input Sheet'!S124","v":0},{"$f":"'Input Sheet'!T124","v":0},{"$f":"'Input Sheet'!U124","v":0},{"$f":"'Input Sheet'!V124","v":0},0,25.12,1]
[null,70,188440,2010,"CAMRY",112717,{"$f":"'Input Sheet'!I125","v":0},{"$f":"'Input Sheet'!J125","v":0},{"$f":"'Input Sheet'!K125","v":0},{"$f":"'Input Sheet'!L125","v":0},0,42,0.6,{"$f":"'Input Sheet'!P125","v":0},{"$f":"'Input Sheet'!Q125","v":0},0,{"$f":"'Input Sheet'!S125","v":0},{"$f":"'Input Sheet'!T125","v":0},{"$f":"'Input Sheet'!U125","v":0},{"$f":"'Input Sheet'!V125","v":0},0,71.95,3]
[null,71,188441,2016,"CAMRY",27950,22.99,0.3,{"$f":"'Input Sheet'!K126","v":0},{"$f":"'Input Sheet'!L126","v":0},0,{"$f":"'Input Sheet'!N126","v":0},{"$f":"'Input Sheet'!O126","v":0},{"$f":"'Input Sheet'!P126","v":0},{"$f":"'Input Sheet'!Q126","v":0},0,{"$f":"'Input Sheet'!S126","v":0},{"$f":"'Input Sheet'!T126","v":0},{"$f":"'Input Sheet'!U126","v":0},{"$f":"'Input Sheet'!V126","v":0},0,25.12,1]
[null,72,188442,2009,"TACOMA",110169,{"$f":"'Input Sheet'!I127","v":0},{"$f":"'Input Sheet'!J127","v":0},{"$f":"'Input Sheet'!K127","v":0},{"$f":"'Input Sheet'!L127","v":0},0,42,0.6,{"$f":"'Input Sheet'!P127","v":0},{"$f":"'Input Sheet'!Q127","v":0},0,{"$f":"'Input Sheet'!S127","v":0},{"$f":"'Input Sheet'!T127","v":0},{"$f":"'Input Sheet'!U127","v":0},{"$f":"'Input Sheet'!V127","v":0},0,64.709999999999994,5]
[null,73,188447,1997,"CAMRY",264339,null,{"$f":"'Input Sheet'!J128","v":0},{"$f":"'Input Sheet'!K128","v":0},{"$f":"'Input Sheet'!L128","v":0},0,{"$f":"'Input Sheet'!N128","v":0},{"$f":"'Input Sheet'!O128","v":0},{"$f":"'Input Sheet'!P128","v":0},{"$f":"'Input Sheet'!Q128","v":0},0,5,0.4,{"$f":"'Input Sheet'!U128","v":0},{"$f":"'Input Sheet'!V128","v":0},0,15.94,2]
[null,74,188453,2014,"COROLLA",54098,{"$f":"'Input Sheet'!I129","v":0},{"$f":"'Input Sheet'!J129","v":0},{"$f":"'Input Sheet'!K129","v":0},{"$f":"'Input Sheet'!L129","v":0},0,20,0.3,{"$f":"'Input Sheet'!P129","v":0},{"$f":"'Input Sheet'!Q129","v":0},0,{"$f":"'Input Sheet'!S129","v":0},{"$f":"'Input Sheet'!T129","v":0},{"$f":"'Input Sheet'!U129","v":0},{"$f":"'Input Sheet'!V129","v":0},0,49.95,1]
[null,75,188454,2015,"COROLLA",24619,22.99,0.3,{"$f":"'Input Sheet'!K130","v":0},{"$f":"'Input Sheet'!L130","v":0},0,{"$f":"'Input Sheet'!N130","v":0},{"$f":"'Input Sheet'!O130","v":0},{"$f":"'Input Sheet'!P130","v":0},{"$f":"'Input Sheet'!Q130","v":0},0,{"$f":"'Input Sheet'!S130","v":0},{"$f":"'Input Sheet'!T130","v":0},{"$f":"'Input Sheet'!U130","v":0},{"$f":"'Input Sheet'!V130","v":0},0,22.99,1]
[null,76,188455,2014,"LEXUS",47634,22.99,0.3,{"$f":"'Input Sheet'!K131","v":0},{"$f":"'Input Sheet'!L131","v":0},0,{"$f":"'Input Sheet'!N131","v":0},{"$f":"'Input Sheet'!O131","v":0},{"$f":"'Input Sheet'!P131","v":0},{"$f":"'Input Sheet'!Q131","v":0},0,{"$f":"'Input Sheet'!S131","v":0},{"$f":"'Input Sheet'!T131","v":0},{"$f":"'Input Sheet'!U131","v":0},{"$f":"'Input Sheet'!V131","v":0},0,22.99,1]
[null,77,188456,2013,"PRIUS",71106,22.99,0.3,{"$f":"'Input Sheet'!K132","v":0},{"$f":"'Input Sheet'!L132","v":0},0,{"$f":"'Input Sheet'!N132","v":0},{"$f":"'Input Sheet'!O132","v":0},{"$f":"'Input Sheet'!P132","v":0},{"$f":"'Input Sheet'!Q132","v":0},0,{"$f":"'Input Sheet'!S132","v":0},{"$f":"'Input Sheet'!T132","v":0},{"$f":"'Input Sheet'!U132","v":0},{"$f":"'Input Sheet'!V132","v":0},0,22.99,1]
[null,78,188457,2013,"LAND CRUISER",62307,{"$f":"'Input Sheet'!I133","v":0},{"$f":"'Input Sheet'!J133","v":0},{"$f":"'Input Sheet'!K133","v":0},{"$f":"'Input Sheet'!L133","v":0},0,42,0.6,{"$f":"'Input Sheet'!P133","v":0},{"$f":"'Input Sheet'!Q133","v":0},0,{"$f":"'Input Sheet'!S133","v":0},{"$f":"'Input Sheet'!T133","v":0},{"$f":"'Input Sheet'!U133","v":0},{"$f":"'Input Sheet'!V133","v":0},0,86.95,2]
[null,79,188459,2012,"4 RUNNER",89623,{"$f":"'Input Sheet'!I134","v":0},{"$f":"'Input Sheet'!J134","v":0},{"$f":"'Input Sheet'!K134","v":0},{"$f":"'Input Sheet'!L134","v":0},0,20,0.4,{"$f":"'Input Sheet'!P134","v":0},{"$f":"'Input Sheet'!Q134","v":0},0,{"$f":"'Input Sheet'!S134","v":0},{"$f":"'Input Sheet'!T134","v":0},{"$f":"'Input Sheet'!U134","v":0},{"$f":"'Input Sheet'!V134","v":0},0,54.95,1]
[null,80,188460,2013,"TUNDRA",127145,{"$f":"'Input Sheet'!I135","v":0},{"$f":"'Input Sheet'!J135","v":0},{"$f":"'Input Sheet'!K135","v":0},{"$f":"'Input Sheet'!L135","v":0},0,20,0.4,{"$f":"'Input Sheet'!P135","v":0},{"$f":"'Input Sheet'!Q135","v":0},0,{"$f":"'Input Sheet'!S135","v":0},{"$f":"'Input Sheet'!T135","v":0},{"$f":"'Input Sheet'!U135","v":0},{"$f":"'Input Sheet'!V135","v":0},0,64.95,1]
[null,81,188461,2001,"TUNDRA",200925,{"$f":"'Input Sheet'!I136","v":0},{"$f":"'Input Sheet'!J136","v":0},{"$f":"'Input Sheet'!K136","v":0},{"$f":"'Input Sheet'!L136","v":0},0,{"$f":"'Input Sheet'!N136","v":0},{"$f":"'Input Sheet'!O136","v":0},{"$f":"'Input Sheet'!P136","v":0},{"$f":"'Input Sheet'!Q136","v":0},0,178.5,1.5,{"$f":"'Input Sheet'!U136","v":0},{"$f":"'Input Sheet'!V136","v":0},0,739.16,2]
[null,82,188463,2009,"CAMRY",149782,{"$f":"'Input Sheet'!I137","v":0},{"$f":"'Input Sheet'!J137","v":0},{"$f":"'Input Sheet'!K137","v":0},{"$f":"'Input Sheet'!L137","v":0},0,{"$f":"'Input Sheet'!N137","v":0},{"$f":"'Input Sheet'!O137","v":0},{"$f":"'Input Sheet'!P137","v":0},{"$f":"'Input Sheet'!Q137","v":0},0,119.99,1,{"$f":"'Input Sheet'!U137","v":0},{"$f":"'Input Sheet'!V137","v":0},0,119.99,1]
[null,83,"188465C",2013,"COROLLA",71114,{"$f":"'Input Sheet'!I138","v":0},{"$f":"'Input Sheet'!J138","v":0},{"$f":"'Input Sheet'!K138","v":0},{"$f":"'Input Sheet'!L138","v":0},0,20,0.4,{"$f":"'Input Sheet'!P138","v":0},{"$f":"'Input Sheet'!Q138","v":0},0,{"$f":"'Input Sheet'!S138","v":0},{"$f":"'Input Sheet'!T138","v":0},{"$f":"'Input Sheet'!U138","v":0},{"$f":"'Input Sheet'!V138","v":0},0,49.95,3]
[null,84,188469,2016,"AVALON",29934,{"$f":"'Input Sheet'!I139","v":0},{"$f":"'Input Sheet'!J139","v":0},{"$f":"'Input Sheet'!K139","v":0},{"$f":"'Input Sheet'!L139","v":0},0,20,0.4,{"$f":"'Input Sheet'!P139","v":0},{"$f":"'Input Sheet'!Q139","v":0},0,{"$f":"'Input Sheet'!S139","v":0},{"$f":"'Input Sheet'!T139","v":0},{"$f":"'Input Sheet'!U139","v":0},{"$f":"'Input Sheet'!V139","v":0},0,47.28,1]
[null,85,188471,2016,"RAV4",49966,22,0.28000000000000003,{"$f":"'Input Sheet'!K140","v":0},{"$f":"'Input Sheet'!L140","v":0},0,{"$f":"'Input Sheet'!N140","v":0},{"$f":"'Input Sheet'!O140","v":0},{"$f":"'Input Sheet'!P140","v":0},{"$f":"'Input Sheet'!Q140","v":0},0,{"$f":"'Input Sheet'!S140","v":0},{"$f":"'Input Sheet'!T140","v":0},{"$f":"'Input Sheet'!U140","v":0},{"$f":"'Input Sheet'!V140","v":0},0,185.6,2]
[null,86,188473,2012,"COROLLA",64367,{"$f":"'Input Sheet'!I141","v":0},{"$f":"'Input Sheet'!J141","v":0},{"$f":"'Input Sheet'!K141","v":0},{"$f":"'Input Sheet'!L141","v":0},0,22,0.4,{"$f":"'Input Sheet'!P141","v":0},{"$f":"'Input Sheet'!Q141","v":0},0,{"$f":"'Input Sheet'!S141","v":0},{"$f":"'Input Sheet'!T141","v":0},{"$f":"'Input Sheet'!U141","v":0},{"$f":"'Input Sheet'!V141","v":0},0,49.95,7]
[null,87,188474,2013,"CAMRY",72455,{"$f":"'Input Sheet'!I142","v":0},{"$f":"'Input Sheet'!J142","v":0},{"$f":"'Input Sheet'!K142","v":0},{"$f":"'Input Sheet'!L142","v":0},0,20,0.4,{"$f":"'Input Sheet'!P142","v":0},{"$f":"'Input Sheet'!Q142","v":0},0,{"$f":"'Input Sheet'!S142","v":0},{"$f":"'Input Sheet'!T142","v":0},{"$f":"'Input Sheet'!U142","v":0},{"$f":"'Input Sheet'!V142","v":0},0,49.95,2]
[null,88,188479,2011,"PRIUS",44550,{"$f":"'Input Sheet'!I143","v":0},{"$f":"'Input Sheet'!J143","v":0},{"$f":"'Input Sheet'!K143","v":0},{"$f":"'Input Sheet'!L143","v":0},0,20,0.4,{"$f":"'Input Sheet'!P143","v":0},{"$f":"'Input Sheet'!Q143","v":0},0,{"$f":"'Input Sheet'!S143","v":0},{"$f":"'Input Sheet'!T143","v":0},{"$f":"'Input Sheet'!U143","v":0},{"$f":"'Input Sheet'!V143","v":0},0,49.95,1]
[null,89,188480,2014,"TUNDRA",107051,91.03,1,{"$f":"'Input Sheet'!K144","v":0},{"$f":"'Input Sheet'!L144","v":0},0,{"$f":"'Input Sheet'!N144","v":0},{"$f":"'Input Sheet'!O144","v":0},{"$f":"'Input Sheet'!P144","v":0},{"$f":"'Input Sheet'!Q144","v":0},0,{"$f":"'Input Sheet'!S144","v":0},{"$f":"'Input Sheet'!T144","v":0},{"$f":"'Input Sheet'!U144","v":0},{"$f":"'Input Sheet'!V144","v":0},0,169.95,2]
[null,90,188481,2010,"LEXUS",147604,42,0.6,{"$f":"'Input Sheet'!K145","v":0},{"$f":"'Input Sheet'!L145","v":0},0,{"$f":"'Input Sheet'!N145","v":0},{"$f":"'Input Sheet'!O145","v":0},{"$f":"'Input Sheet'!P145","v":0},{"$f":"'Input Sheet'!Q145","v":0},0,{"$f":"'Input Sheet'!S145","v":0},{"$f":"'Input Sheet'!T145","v":0},{"$f":"'Input Sheet'!U145","v":0},{"$f":"'Input Sheet'!V145","v":0},0,81.95,2]
[null,91,188482,2009,"HIGHLANDER",182668,{"$f":"'Input Sheet'!I146","v":0},{"$f":"'Input Sheet'!J146","v":0},{"$f":"'Input Sheet'!K146","v":0},{"$f":"'Input Sheet'!L146","v":0},0,20,0.4,{"$f":"'Input Sheet'!P146","v":0},{"$f":"'Input Sheet'!Q146","v":0},0,{"$f":"'Input Sheet'!S146","v":0},{"$f":"'Input Sheet'!T146","v":0},{"$f":"'Input Sheet'!U146","v":0},{"$f":"'Input Sheet'!V146","v":0},0,39.950000000000003,1]
[null,92,188483,2011,"CAMRY HYBRID",49535,{"$f":"'Input Sheet'!I147","v":0},{"$f":"'Input Sheet'!J147","v":0},{"$f":"'Input Sheet'!K147","v":0},{"$f":"'Input Sheet'!L147","v":0},0,42,0.6,{"$f":"'Input Sheet'!P147","v":0},{"$f":"'Input Sheet'!Q147","v":0},0,{"$f":"'Input Sheet'!S147","v":0},{"$f":"'Input Sheet'!T147","v":0},{"$f":"'Input Sheet'!U147","v":0},{"$f":"'Input Sheet'!V147","v":0},0,61.95,4]
[null,93,188484,2005,"LAND CRUISER",227975,{"$f":"'Input Sheet'!I148","v":0},{"$f":"'Input Sheet'!J148","v":0},{"$f":"'Input Sheet'!K148","v":0},{"$f":"'Input Sheet'!L148","v":0},0,42,0.6,{"$f":"'Input Sheet'!P148","v":0},{"$f":"'Input Sheet'!Q148","v":0},0,{"$f":"'Input Sheet'!S148","v":0},{"$f":"'Input Sheet'!T148","v":0},{"$f":"'Input Sheet'!U148","v":0},{"$f":"'Input Sheet'!V148","v":0},0,70.95,2]
[null,94,188488,2011,"HIGHLANDER",191384,22,0.3,{"$f":"'Input Sheet'!K149","v":0},{"$f":"'Input Sheet'!L149","v":0},0,{"$f":"'Input Sheet'!N149","v":0},{"$f":"'Input Sheet'!O149","v":0},{"$f":"'Input Sheet'!P149","v":0},{"$f":"'Input Sheet'!Q149","v":0},0,{"$f":"'Input Sheet'!S149","v":0},{"$f":"'Input Sheet'!T149","v":0},{"$f":"'Input Sheet'!U149","v":0},{"$f":"'Input Sheet'!V149","v":0},0,247.6,2]
[null,95,188489,2012,"CAMRY",75810,{"$f":"'Input Sheet'!I150","v":0},{"$f":"'Input Sheet'!J150","v":0},{"$f":"'Input Sheet'!K150","v":0},{"$f":"'Input Sheet'!L150","v":0},0,20,0.4,{"$f":"'Input Sheet'!P150","v":0},{"$f":"'Input Sheet'!Q150","v":0},0,{"$f":"'Input Sheet'!S150","v":0},{"$f":"'Input Sheet'!T150","v":0},{"$f":"'Input Sheet'!U150","v":0},{"$f":"'Input Sheet'!V150","v":0},0,49.95,2]
[null,96,188491,2012,"CAMRY",106030,{"$f":"'Input Sheet'!I151","v":0},{"$f":"'Input Sheet'!J151","v":0},{"$f":"'Input Sheet'!K151","v":0},{"$f":"'Input Sheet'!L151","v":0},0,20,0.4,{"$f":"'Input Sheet'!P151","v":0},{"$f":"'Input Sheet'!Q151","v":0},0,{"$f":"'Input Sheet'!S151","v":0},{"$f":"'Input Sheet'!T151","v":0},{"$f":"'Input Sheet'!U151","v":0},{"$f":"'Input Sheet'!V151","v":0},0,49.95,2]
[null,97,188492,2015,"COROLLA",47158,22.99,0.3,{"$f":"'Input Sheet'!K152","v":0},{"$f":"'Input Sheet'!L152","v":0},0,{"$f":"'Input Sheet'!N152","v":0},{"$f":"'Input Sheet'!O152","v":0},{"$f":"'Input Sheet'!P152","v":0},{"$f":"'Input Sheet'!Q152","v":0},0,{"$f":"'Input Sheet'!S152","v":0},{"$f":"'Input Sheet'!T152","v":0},{"$f":"'Input Sheet'!U152","v":0},{"$f":"'Input Sheet'!V152","v":0},0,25.12,1]
[null,98,188493,2003,"SEQUOIA",291414,{"$f":"'Input Sheet'!I153","v":0},{"$f":"'Input Sheet'!J153","v":0},{"$f":"'Input Sheet'!K153","v":0},{"$f":"'Input Sheet'!L153","v":0},0,20,0.4,{"$f":"'Input Sheet'!P153","v":0},{"$f":"'Input Sheet'!Q153","v":0},0,{"$f":"'Input Sheet'!S153","v":0},{"$f":"'Input Sheet'!T153","v":0},{"$f":"'Input Sheet'!U153","v":0},{"$f":"'Input Sheet'!V153","v":0},0,48.95,1]
[null,99,"188413C",2016,"CAMRY",40114,119.99,1,{"$f":"'Input Sheet'!K154","v":0},{"$f":"'Input Sheet'!L154","v":0},0,{"$f":"'Input Sheet'!N154","v":0},{"$f":"'Input Sheet'!O154","v":0},{"$f":"'Input Sheet'!P154","v":0},{"$f":"'Input Sheet'!Q154","v":0},0,{"$f":"'Input Sheet'!S154","v":0},{"$f":"'Input Sheet'!T154","v":0},{"$f":"'Input Sheet'!U154","v":0},{"$f":"'Input Sheet'!V154","v":0},0,119.99,2]
[null,100,188418,2011,"CAMRY",123056,22.99,0.3,{"$f":"'Input Sheet'!K155","v":0},{"$f":"'Input Sheet'!L155","v":0},0,{"$f":"'Input Sheet'!N155","v":0},{"$f":"'Input Sheet'!O155","v":0},{"$f":"'Input Sheet'!P155","v":0},{"$f":"'Input Sheet'!Q155","v":0},0,{"$f":"'Input Sheet'!S155","v":0},{"$f":"'Input Sheet'!T155","v":0},{"$f":"'Input Sheet'!U155","v":0},{"$f":"'Input Sheet'!V155","v":0},0,22.99,2]
[null,null,null,null,"Totals","Totals",{"$f":"SUM(G6:G105)","v":400},{"$f":"SUM(H6:H105)","v":20},null,null,{"$f":"SUM(K6:K105)","v":400},20,0.4,null,null,8,239617.32709999999,2945.15,null,null,{"$error":"#VALUE!"},7700.1399999999921,{"$f":"COUNTIF(W5:W105,1)","v":63}]
[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":[[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],[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],[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],[2,19,4,19],[3,11,4,11],[3,18,4,18],[3,16,4,16],[3,17,4,17]]}
["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"]
[188333,2011,"Camry",64665,{"$f":"'Input Sheet'!G6","v":400},{"$f":"'Input Sheet'!H6","v":20},{"$f":"'Input Sheet'!I6","v":400},{"$f":"'Input Sheet'!J6","v":20},{"$f":"F6*H6","v":400},20,0.4,{"$f":"'Input Sheet'!I6","v":400},{"$f":"'Input Sheet'!J6","v":20},{"$f":"K6*M6","v":8},0,{"$f":"'Input Sheet'!R6","v":20},{"$f":"'Input Sheet'!S6","v":400},{"$f":"'Input Sheet'!T6","v":20},{"$f":"P6*R6","v":400},20,1]
[188337,2006,"4Runner",139923,{"$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":0},{"$f":"'Input Sheet'!M7","v":0},{"$f":"'Input Sheet'!I7","v":0},{"$f":"'Input Sheet'!J7","v":""},{"$f":"K7*M7","v":{"$error":"#VALUE!"}},35.700000000000003,0.3,{"$f":"'Input Sheet'!S7","v":10.71},{"$f":"'Input Sheet'!T7","v":35.700000000000003},{"$f":"P7*R7","v":10.71},35.700000000000003,1]
[188343,2013,"Sequoia",99915,19.95,0.15,{"$f":"'Input Sheet'!I8","v":8.2424999999999997},{"$f":"'Input Sheet'!J8","v":54.95},8.2424999999999997,54.95,0.6,{"$f":"'Input Sheet'!I8","v":8.2424999999999997},{"$f":"'Input Sheet'!J8","v":54.95},32.97,29.95,0.4,{"$f":"'Input Sheet'!S8","v":41.94},{"$f":"'Input Sheet'!T8","v":104.85},41.94,104.85,3]
[188344,2014,"LEXUS",31093,{"$f":"'Input Sheet'!G9","v":400},{"$f":"'Input Sheet'!H9","v":20},{"$f":"'Input Sheet'!I9","v":400},{"$f":"'Input Sheet'!J9","v":20},400,20,0.35,{"$f":"'Input Sheet'!I9","v":400},{"$f":"'Input Sheet'!J9","v":20},7,{"$f":"'Input Sheet'!Q9","v":400},{"$f":"'Input Sheet'!R9","v":20},{"$f":"'Input Sheet'!S9","v":400},{"$f":"'Input Sheet'!T9","v":20},400,20,2]
[188345,2014,"COROLLA",8947,{"$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!"},119.99,1,{"$f":"'Input Sheet'!S10","v":0},{"$f":"'Input Sheet'!T10","v":0},0,{"$f":"'Input Sheet'!V10","v":0},1]
[188348,2011,"Camry",85279,89.95,1.2,{"$f":"'Input Sheet'!I11","v":0},{"$f":"'Input Sheet'!J11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L11","v":0},{"$f":"'Input Sheet'!M11","v":0},{"$f":"'Input Sheet'!I11","v":0},{"$f":"'Input Sheet'!J11","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q11","v":8091.0025000000005},{"$f":"'Input Sheet'!R11","v":89.95},{"$f":"'Input Sheet'!S11","v":8091.0025000000005},{"$f":"'Input Sheet'!T11","v":89.95},8091.0025000000005,89.95,1]
[188350,2015,"Camry",35674,119.99,1,{"$f":"'Input Sheet'!I12","v":0},{"$f":"'Input Sheet'!J12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L12","v":0},{"$f":"'Input Sheet'!M12","v":0},{"$f":"'Input Sheet'!I12","v":0},{"$f":"'Input Sheet'!J12","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q12","v":14161},{"$f":"'Input Sheet'!R12","v":119},{"$f":"'Input Sheet'!S12","v":14161},{"$f":"'Input Sheet'!T12","v":119},14161,119,1]
[188351,2006,"AVALON",145971,89.95,1.2,{"$f":"'Input Sheet'!I13","v":0},{"$f":"'Input Sheet'!J13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L13","v":0},{"$f":"'Input Sheet'!M13","v":0},{"$f":"'Input Sheet'!I13","v":0},{"$f":"'Input Sheet'!J13","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q13","v":8091.0025000000005},{"$f":"'Input Sheet'!R13","v":89.95},{"$f":"'Input Sheet'!S13","v":8091.0025000000005},{"$f":"'Input Sheet'!T13","v":89.95},8091.0025000000005,89.95,2]
[188353,2009,"CAMRY",58973,{"$f":"'Input Sheet'!G14","v":400},{"$f":"'Input Sheet'!H14","v":20},{"$f":"'Input Sheet'!I14","v":400},{"$f":"'Input Sheet'!J14","v":20},400,20,0.64,{"$f":"'Input Sheet'!I14","v":400},{"$f":"'Input Sheet'!J14","v":20},12.8,{"$f":"'Input Sheet'!Q14","v":400},{"$f":"'Input Sheet'!R14","v":20},{"$f":"'Input Sheet'!S14","v":400},{"$f":"'Input Sheet'!T14","v":20},400,20,1]
[188354,2011,"CAMRY",71094,89.95,1.2,{"$f":"'Input Sheet'!I15","v":0},{"$f":"'Input Sheet'!J15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L15","v":0},{"$f":"'Input Sheet'!M15","v":0},{"$f":"'Input Sheet'!I15","v":0},{"$f":"'Input Sheet'!J15","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q15","v":8091.0025000000005},{"$f":"'Input Sheet'!R15","v":89.95},{"$f":"'Input Sheet'!S15","v":8091.0025000000005},{"$f":"'Input Sheet'!T15","v":89.95},8091.0025000000005,89.95,2]
[188355,2008,"LEXUS",101626,{"$f":"'Input Sheet'!G16","v":400},{"$f":"'Input Sheet'!H16","v":20},{"$f":"'Input Sheet'!I16","v":400},{"$f":"'Input Sheet'!J16","v":20},400,20,0.4,{"$f":"'Input Sheet'!I16","v":400},{"$f":"'Input Sheet'!J16","v":20},8,{"$f":"'Input Sheet'!Q16","v":1844.7025000000003},{"$f":"'Input Sheet'!R16","v":42.95},{"$f":"'Input Sheet'!S16","v":1844.7025000000003},{"$f":"'Input Sheet'!T16","v":42.95},1844.7025000000003,42.95,1]
[188356,2010,"SCION XD",125764,119.99,1,{"$f":"'Input Sheet'!I17","v":0},{"$f":"'Input Sheet'!J17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L17","v":0},{"$f":"'Input Sheet'!M17","v":0},{"$f":"'Input Sheet'!I17","v":0},{"$f":"'Input Sheet'!J17","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q17","v":14161},{"$f":"'Input Sheet'!R17","v":119},{"$f":"'Input Sheet'!S17","v":14161},{"$f":"'Input Sheet'!T17","v":119},14161,119,1]
[188359,2015,"CAMRY",24457,{"$f":"'Input Sheet'!G18","v":400},{"$f":"'Input Sheet'!H18","v":20},{"$f":"'Input Sheet'!I18","v":400},{"$f":"'Input Sheet'!J18","v":20},400,20,0.4,{"$f":"'Input Sheet'!I18","v":400},{"$f":"'Input Sheet'!J18","v":20},8,{"$f":"'Input Sheet'!Q18","v":400},{"$f":"'Input Sheet'!R18","v":20},{"$f":"'Input Sheet'!S18","v":400},{"$f":"'Input Sheet'!T18","v":20},400,20,2]
[188361,2015,"CAMRY",43270,{"$f":"'Input Sheet'!G19","v":1764},{"$f":"'Input Sheet'!H19","v":42},{"$f":"'Input Sheet'!I19","v":1764},{"$f":"'Input Sheet'!J19","v":42},1764,42,0.6,{"$f":"'Input Sheet'!I19","v":1764},{"$f":"'Input Sheet'!J19","v":42},25.2,{"$f":"'Input Sheet'!Q19","v":5176.8025000000007},{"$f":"'Input Sheet'!R19","v":71.95},{"$f":"'Input Sheet'!S19","v":5176.8025000000007},{"$f":"'Input Sheet'!T19","v":71.95},5176.8025000000007,71.95,1]
[188362,2012,"CAMRY",100597,{"$f":"'Input Sheet'!G20","v":400},{"$f":"'Input Sheet'!H20","v":20},{"$f":"'Input Sheet'!I20","v":400},{"$f":"'Input Sheet'!J20","v":20},400,20,0.4,{"$f":"'Input Sheet'!I20","v":400},{"$f":"'Input Sheet'!J20","v":20},8,{"$f":"'Input Sheet'!Q20","v":400},{"$f":"'Input Sheet'!R20","v":20},{"$f":"'Input Sheet'!S20","v":400},{"$f":"'Input Sheet'!T20","v":20},400,20,1]
[188364,2008,"FJ CRUSIER",116692,{"$f":"'Input Sheet'!G21","v":400},{"$f":"'Input Sheet'!H21","v":20},{"$f":"'Input Sheet'!I21","v":400},{"$f":"'Input Sheet'!J21","v":20},400,20,0.4,{"$f":"'Input Sheet'!I21","v":400},{"$f":"'Input Sheet'!J21","v":20},8,{"$f":"'Input Sheet'!Q21","v":1844.7025000000003},{"$f":"'Input Sheet'!R21","v":42.95},{"$f":"'Input Sheet'!S21","v":1844.7025000000003},{"$f":"'Input Sheet'!T21","v":42.95},1844.7025000000003,42.95,1]
[188366,2013,"PRIUS",96180,{"$f":"'Input Sheet'!G22","v":400},{"$f":"'Input Sheet'!H22","v":20},{"$f":"'Input Sheet'!I22","v":400},{"$f":"'Input Sheet'!J22","v":20},400,20,0.4,{"$f":"'Input Sheet'!I22","v":400},{"$f":"'Input Sheet'!J22","v":20},8,{"$f":"'Input Sheet'!Q22","v":2495.0025000000005},{"$f":"'Input Sheet'!R22","v":49.95},{"$f":"'Input Sheet'!S22","v":2495.0025000000005},{"$f":"'Input Sheet'!T22","v":49.95},2495.0025000000005,49.95,1]
[188367,2014,"TACOMA",53420,{"$f":"'Input Sheet'!G23","v":400},{"$f":"'Input Sheet'!H23","v":20},{"$f":"'Input Sheet'!I23","v":400},{"$f":"'Input Sheet'!J23","v":20},400,20,0.4,{"$f":"'Input Sheet'!I23","v":400},{"$f":"'Input Sheet'!J23","v":20},8,{"$f":"'Input Sheet'!Q23","v":3019.5025000000005},{"$f":"'Input Sheet'!R23","v":54.95},{"$f":"'Input Sheet'!S23","v":3019.5025000000005},{"$f":"'Input Sheet'!T23","v":54.95},3019.5025000000005,54.95,3]
[188369,2012,"SCION XB",56386,{"$f":"'Input Sheet'!G24","v":400},{"$f":"'Input Sheet'!H24","v":20},{"$f":"'Input Sheet'!I24","v":400},{"$f":"'Input Sheet'!J24","v":20},400,20,0.4,{"$f":"'Input Sheet'!I24","v":400},{"$f":"'Input Sheet'!J24","v":20},8,{"$f":"'Input Sheet'!Q24","v":1596.0025000000003},{"$f":"'Input Sheet'!R24","v":39.950000000000003},{"$f":"'Input Sheet'!S24","v":1596.0025000000003},{"$f":"'Input Sheet'!T24","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[188370,2011,"COROLLA",93014,{"$f":"'Input Sheet'!G25","v":100},{"$f":"'Input Sheet'!H25","v":10},{"$f":"'Input Sheet'!I25","v":100},{"$f":"'Input Sheet'!J25","v":10},100,10,0.4,{"$f":"'Input Sheet'!I25","v":100},{"$f":"'Input Sheet'!J25","v":10},4,{"$f":"'Input Sheet'!Q25","v":2495.0025000000005},{"$f":"'Input Sheet'!R25","v":49.95},{"$f":"'Input Sheet'!S25","v":2495.0025000000005},{"$f":"'Input Sheet'!T25","v":49.95},2495.0025000000005,49.95,1]
[188371,2015,"CAMRY",53107,{"$f":"'Input Sheet'!G26","v":100},{"$f":"'Input Sheet'!H26","v":10},{"$f":"'Input Sheet'!I26","v":100},{"$f":"'Input Sheet'!J26","v":10},100,10,0.4,{"$f":"'Input Sheet'!I26","v":100},{"$f":"'Input Sheet'!J26","v":10},4,{"$f":"'Input Sheet'!Q26","v":2495.0025000000005},{"$f":"'Input Sheet'!R26","v":49.95},{"$f":"'Input Sheet'!S26","v":2495.0025000000005},{"$f":"'Input Sheet'!T26","v":49.95},2495.0025000000005,49.95,1]
[188372,2009,"AVALON",183323,89.95,1.2,{"$f":"'Input Sheet'!I27","v":0},{"$f":"'Input Sheet'!J27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L27","v":0},{"$f":"'Input Sheet'!M27","v":0},{"$f":"'Input Sheet'!I27","v":0},{"$f":"'Input Sheet'!J27","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q27","v":8091.0025000000005},{"$f":"'Input Sheet'!R27","v":89.95},{"$f":"'Input Sheet'!S27","v":8091.0025000000005},{"$f":"'Input Sheet'!T27","v":89.95},8091.0025000000005,89.95,1]
[188373,2011,"CAMRY",72797,89.95,1.2,{"$f":"'Input Sheet'!I28","v":0},{"$f":"'Input Sheet'!J28","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L28","v":0},{"$f":"'Input Sheet'!M28","v":0},{"$f":"'Input Sheet'!I28","v":0},{"$f":"'Input Sheet'!J28","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q28","v":8091.0025000000005},{"$f":"'Input Sheet'!R28","v":89.95},{"$f":"'Input Sheet'!S28","v":8091.0025000000005},{"$f":"'Input Sheet'!T28","v":89.95},8091.0025000000005,89.95,1]
[188375,1997,"4 RUNNER",182844,{"$f":"'Input Sheet'!G29","v":400},{"$f":"'Input Sheet'!H29","v":20},{"$f":"'Input Sheet'!I29","v":400},{"$f":"'Input Sheet'!J29","v":20},400,20,0.4,{"$f":"'Input Sheet'!I29","v":400},{"$f":"'Input Sheet'!J29","v":20},8,{"$f":"'Input Sheet'!Q29","v":2111.4025000000001},{"$f":"'Input Sheet'!R29","v":45.95},{"$f":"'Input Sheet'!S29","v":2111.4025000000001},{"$f":"'Input Sheet'!T29","v":45.95},2111.4025000000001,45.95,1]
[188383,2007,"CAMRY",163777,{"$f":"'Input Sheet'!G30","v":400},{"$f":"'Input Sheet'!H30","v":20},{"$f":"'Input Sheet'!I30","v":400},{"$f":"'Input Sheet'!J30","v":20},400,20,0.4,{"$f":"'Input Sheet'!I30","v":400},{"$f":"'Input Sheet'!J30","v":20},8,{"$f":"'Input Sheet'!Q30","v":1596.0025000000003},{"$f":"'Input Sheet'!R30","v":39.950000000000003},{"$f":"'Input Sheet'!S30","v":1596.0025000000003},{"$f":"'Input Sheet'!T30","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[188384,2016,"RAV 4",76906,28.95,0.21,{"$f":"'Input Sheet'!I31","v":0},{"$f":"'Input Sheet'!J31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L31","v":0},{"$f":"'Input Sheet'!M31","v":0},{"$f":"'Input Sheet'!I31","v":0},{"$f":"'Input Sheet'!J31","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q31","v":838.10249999999996},{"$f":"'Input Sheet'!R31","v":28.95},{"$f":"'Input Sheet'!S31","v":838.10249999999996},{"$f":"'Input Sheet'!T31","v":28.95},838.10249999999996,28.95,2]
[188385,2013,"COROLLA",67773,{"$f":"'Input Sheet'!G32","v":400},{"$f":"'Input Sheet'!H32","v":20},{"$f":"'Input Sheet'!I32","v":400},{"$f":"'Input Sheet'!J32","v":20},400,20,0.4,{"$f":"'Input Sheet'!I32","v":400},{"$f":"'Input Sheet'!J32","v":20},8,{"$f":"'Input Sheet'!Q32","v":2495.0025000000005},{"$f":"'Input Sheet'!R32","v":49.95},{"$f":"'Input Sheet'!S32","v":2495.0025000000005},{"$f":"'Input Sheet'!T32","v":49.95},2495.0025000000005,49.95,1]
["188387C",2016,"HIGHLANDWE",32604,89.95,1.2,{"$f":"'Input Sheet'!I33","v":0},{"$f":"'Input Sheet'!J33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L33","v":0},{"$f":"'Input Sheet'!M33","v":0},{"$f":"'Input Sheet'!I33","v":0},{"$f":"'Input Sheet'!J33","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q33","v":8091.0025000000005},{"$f":"'Input Sheet'!R33","v":89.95},{"$f":"'Input Sheet'!S33","v":8091.0025000000005},{"$f":"'Input Sheet'!T33","v":89.95},8091.0025000000005,89.95,1]
[188388,2003,"SEQUOIA",61036,{"$f":"'Input Sheet'!G34","v":400},{"$f":"'Input Sheet'!H34","v":20},{"$f":"'Input Sheet'!I34","v":400},{"$f":"'Input Sheet'!J34","v":20},400,20,0.4,{"$f":"'Input Sheet'!I34","v":400},{"$f":"'Input Sheet'!J34","v":20},8,{"$f":"'Input Sheet'!Q34","v":2111.4025000000001},{"$f":"'Input Sheet'!R34","v":45.95},{"$f":"'Input Sheet'!S34","v":2111.4025000000001},{"$f":"'Input Sheet'!T34","v":45.95},2111.4025000000001,45.95,1]
[188390,2005,"CAMRY",223961,64.31,0.7,{"$f":"'Input Sheet'!I35","v":0},{"$f":"'Input Sheet'!J35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L35","v":0},{"$f":"'Input Sheet'!M35","v":0},{"$f":"'Input Sheet'!I35","v":0},{"$f":"'Input Sheet'!J35","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q35","v":14871.802500000002},{"$f":"'Input Sheet'!R35","v":121.95},{"$f":"'Input Sheet'!S35","v":14871.802500000002},{"$f":"'Input Sheet'!T35","v":121.95},14871.802500000002,121.95,5]
[188391,2016,"CAMRY",30395,15,0.4,{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L36","v":0},{"$f":"'Input Sheet'!M36","v":0},{"$f":"'Input Sheet'!I36","v":0},{"$f":"'Input Sheet'!J36","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q36","v":1288.81},{"$f":"'Input Sheet'!R36","v":35.9},{"$f":"'Input Sheet'!S36","v":1288.81},{"$f":"'Input Sheet'!T36","v":35.9},1288.81,35.9,1]
[188392,2013,"AVALON",66748,22.99,0.3,{"$f":"'Input Sheet'!I37","v":0},{"$f":"'Input Sheet'!J37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L37","v":0},{"$f":"'Input Sheet'!M37","v":0},{"$f":"'Input Sheet'!I37","v":0},{"$f":"'Input Sheet'!J37","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q37","v":528.54009999999994},{"$f":"'Input Sheet'!R37","v":22.99},{"$f":"'Input Sheet'!S37","v":528.54009999999994},{"$f":"'Input Sheet'!T37","v":22.99},528.54009999999994,22.99,1]
[188393,2008,"CAMRY HYBRID",80067,{"$f":"'Input Sheet'!G38","v":400},{"$f":"'Input Sheet'!H38","v":20},{"$f":"'Input Sheet'!I38","v":400},{"$f":"'Input Sheet'!J38","v":20},400,20,0.4,{"$f":"'Input Sheet'!I38","v":400},{"$f":"'Input Sheet'!J38","v":20},8,{"$f":"'Input Sheet'!Q38","v":1596.0025000000003},{"$f":"'Input Sheet'!R38","v":39.950000000000003},{"$f":"'Input Sheet'!S38","v":1596.0025000000003},{"$f":"'Input Sheet'!T38","v":39.950000000000003},1596.0025000000003,39.950000000000003,2]
[188394,2007,"COROLLA",187558,{"$f":"'Input Sheet'!G39","v":1764},{"$f":"'Input Sheet'!H39","v":42},{"$f":"'Input Sheet'!I39","v":1764},{"$f":"'Input Sheet'!J39","v":42},1764,42,0.6,{"$f":"'Input Sheet'!I39","v":1764},{"$f":"'Input Sheet'!J39","v":42},25.2,{"$f":"'Input Sheet'!Q39","v":3794.5600000000004},{"$f":"'Input Sheet'!R39","v":61.6},{"$f":"'Input Sheet'!S39","v":3794.5600000000004},{"$f":"'Input Sheet'!T39","v":61.6},3794.5600000000004,61.6,3]
[188395,2013,"CAMRY",54949,{"$f":"'Input Sheet'!G40","v":400},{"$f":"'Input Sheet'!H40","v":20},{"$f":"'Input Sheet'!I40","v":400},{"$f":"'Input Sheet'!J40","v":20},400,20,0.4,{"$f":"'Input Sheet'!I40","v":400},{"$f":"'Input Sheet'!J40","v":20},8,{"$f":"'Input Sheet'!Q40","v":1221.5025000000003},{"$f":"'Input Sheet'!R40","v":34.950000000000003},{"$f":"'Input Sheet'!S40","v":1221.5025000000003},{"$f":"'Input Sheet'!T40","v":34.950000000000003},1221.5025000000003,34.950000000000003,2]
[188398,2009,"TUNDRA",88510,{"$f":"'Input Sheet'!G41","v":400},{"$f":"'Input Sheet'!H41","v":20},{"$f":"'Input Sheet'!I41","v":400},{"$f":"'Input Sheet'!J41","v":20},400,20,0.4,{"$f":"'Input Sheet'!I41","v":400},{"$f":"'Input Sheet'!J41","v":20},8,{"$f":"'Input Sheet'!Q41","v":2111.4025000000001},{"$f":"'Input Sheet'!R41","v":45.95},{"$f":"'Input Sheet'!S41","v":2111.4025000000001},{"$f":"'Input Sheet'!T41","v":45.95},2111.4025000000001,45.95,1]
[188399,2009,"LEXUS",121680,{"$f":"'Input Sheet'!G42","v":400},{"$f":"'Input Sheet'!H42","v":20},{"$f":"'Input Sheet'!I42","v":400},{"$f":"'Input Sheet'!J42","v":20},400,20,0.4,{"$f":"'Input Sheet'!I42","v":400},{"$f":"'Input Sheet'!J42","v":20},8,{"$f":"'Input Sheet'!Q42","v":2111.4025000000001},{"$f":"'Input Sheet'!R42","v":45.95},{"$f":"'Input Sheet'!S42","v":2111.4025000000001},{"$f":"'Input Sheet'!T42","v":45.95},2111.4025000000001,45.95,1]
[188400,2008,"LEXUS",134079,{"$f":"'Input Sheet'!G43","v":400},{"$f":"'Input Sheet'!H43","v":20},{"$f":"'Input Sheet'!I43","v":400},{"$f":"'Input Sheet'!J43","v":20},400,20,0.4,{"$f":"'Input Sheet'!I43","v":400},{"$f":"'Input Sheet'!J43","v":20},8,{"$f":"'Input Sheet'!Q43","v":2860.1103999999996},{"$f":"'Input Sheet'!R43","v":53.48},{"$f":"'Input Sheet'!S43","v":2860.1103999999996},{"$f":"'Input Sheet'!T43","v":53.48},2860.1103999999996,53.48,1]
[188401,2016,"SCION IM",44851,{"$f":"'Input Sheet'!G44","v":0},{"$f":"'Input Sheet'!H44","v":0},{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L44","v":0},{"$f":"'Input Sheet'!M44","v":0},{"$f":"'Input Sheet'!I44","v":0},{"$f":"'Input Sheet'!J44","v":""},{"$error":"#VALUE!"},159.99,2,{"$f":"'Input Sheet'!S44","v":429.98},{"$f":"'Input Sheet'!T44","v":214.99},429.98,214.99,1]
[188402,2016,"TACOMA",36943,{"$f":"'Input Sheet'!G45","v":484},{"$f":"'Input Sheet'!H45","v":22},{"$f":"'Input Sheet'!I45","v":484},{"$f":"'Input Sheet'!J45","v":22},484,22,0.6,{"$f":"'Input Sheet'!I45","v":484},{"$f":"'Input Sheet'!J45","v":22},13.2,{"$f":"'Input Sheet'!Q45","v":2124.2881000000002},{"$f":"'Input Sheet'!R45","v":46.09},{"$f":"'Input Sheet'!S45","v":2124.2881000000002},{"$f":"'Input Sheet'!T45","v":46.09},2124.2881000000002,46.09,1]
[188404,2011,"COROLLA",50202,{"$f":"'Input Sheet'!G46","v":400},{"$f":"'Input Sheet'!H46","v":20},{"$f":"'Input Sheet'!I46","v":400},{"$f":"'Input Sheet'!J46","v":20},400,20,0.4,{"$f":"'Input Sheet'!I46","v":400},{"$f":"'Input Sheet'!J46","v":20},8,{"$f":"'Input Sheet'!Q46","v":1596.0025000000003},{"$f":"'Input Sheet'!R46","v":39.950000000000003},{"$f":"'Input Sheet'!S46","v":1596.0025000000003},{"$f":"'Input Sheet'!T46","v":39.950000000000003},1596.0025000000003,39.950000000000003,1]
[188405,2008,"LEXUS",76407,{"$f":"'Input Sheet'!G47","v":400},{"$f":"'Input Sheet'!H47","v":20},{"$f":"'Input Sheet'!I47","v":400},{"$f":"'Input Sheet'!J47","v":20},400,20,0.4,{"$f":"'Input Sheet'!I47","v":400},{"$f":"'Input Sheet'!J47","v":20},8,{"$f":"'Input Sheet'!Q47","v":2396.1025000000004},{"$f":"'Input Sheet'!R47","v":48.95},{"$f":"'Input Sheet'!S47","v":2396.1025000000004},{"$f":"'Input Sheet'!T47","v":48.95},2396.1025000000004,48.95,1]
[188407,2014,"CAMRY",55017,90.29,1,{"$f":"'Input Sheet'!I48","v":0},{"$f":"'Input Sheet'!J48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L48","v":0},{"$f":"'Input Sheet'!M48","v":0},{"$f":"'Input Sheet'!I48","v":0},{"$f":"'Input Sheet'!J48","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q48","v":19897.923600000002},{"$f":"'Input Sheet'!R48","v":141.06},{"$f":"'Input Sheet'!S48","v":19897.923600000002},{"$f":"'Input Sheet'!T48","v":141.06},19897.923600000002,141.06,1]
[188409,2002,"HIGHLANDER",235329,{"$f":"'Input Sheet'!G49","v":400},{"$f":"'Input Sheet'!H49","v":20},{"$f":"'Input Sheet'!I49","v":400},{"$f":"'Input Sheet'!J49","v":20},400,20,0.4,{"$f":"'Input Sheet'!I49","v":400},{"$f":"'Input Sheet'!J49","v":20},8,{"$f":"'Input Sheet'!Q49","v":2202.4249},{"$f":"'Input Sheet'!R49","v":46.93},{"$f":"'Input Sheet'!S49","v":2202.4249},{"$f":"'Input Sheet'!T49","v":46.93},2202.4249,46.93,1]
[188411,2013,"TACOMA",70174,138,1.5,{"$f":"'Input Sheet'!I50","v":0},{"$f":"'Input Sheet'!J50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L50","v":0},{"$f":"'Input Sheet'!M50","v":0},{"$f":"'Input Sheet'!I50","v":0},{"$f":"'Input Sheet'!J50","v":""},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q50","v":69142.702499999999},{"$f":"'Input Sheet'!R50","v":262.95},{"$f":"'Input Sheet'!S50","v":69142.702499999999},{"$f":"'Input Sheet'!T50","v":262.95},69142.702499999999,262.95,3]
[188412,2015,"CAMRY",52290,{"$f":"'Input Sheet'!G51","v":0},{"$f":"'Input Sheet'!H51","v":20},{"$f":"'Input Sheet'!I51","v":0},{"$f":"'Input Sheet'!J51","v":20},{"$f":"F55*H51","v":0},20,0.4,{"$f":"'Input Sheet'!I51","v":0},{"$f":"'Input Sheet'!J51","v":20},8,{"$f":"'Input Sheet'!Q51","v":2495.0025000000005},{"$f":"'Input Sheet'!R51","v":49.95},{"$f":"'Input Sheet'!S51","v":2495.0025000000005},{"$f":"'Input Sheet'!T51","v":49.95},2495.0025000000005,49.95,1]
["188413C",2016,"CAMRY",40114,119.99,1.2,{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":0},0,{"$f":"'Input Sheet'!L52","v":0},{"$f":"'Input Sheet'!M52","v":0},{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":0},0,{"$f":"'Input Sheet'!Q52","v":0},{"$f":"'Input Sheet'!R52","v":247.6},{"$f":"'Input Sheet'!S99","v":0},{"$f":"'Input Sheet'!T99","v":0},0,119.99,2]
[188414,2011,"AVALON",60096,{"$f":"'Input Sheet'!G53","v":0},{"$f":"'Input Sheet'!H53","v":20},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":0},0,20,0.4,{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":0},0,{"$f":"'Input Sheet'!Q53","v":0},{"$f":"'Input Sheet'!R53","v":49.95},{"$f":"'Input Sheet'!S100","v":0},{"$f":"'Input Sheet'!T100","v":0},0,45.95,1]
[188415,2016,"COROLLA",18472,{"$f":"'Input Sheet'!G54","v":0},{"$f":"'Input Sheet'!H54","v":20},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":0},{"$f":"F54*H54","v":0},{"$f":"'Input Sheet'!L54","v":0},0.5,{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":0},{"$f":"K54*M54","v":0},{"$f":"'Input Sheet'!Q54","v":0},{"$f":"'Input Sheet'!R54","v":49.95},{"$f":"'Input Sheet'!S101","v":0},{"$f":"'Input Sheet'!T101","v":0},{"$f":"P54*R54","v":0},{"$f":"'Input Sheet'!V54","v":0},1]
[188416,2008,"CAMRY",82297,{"$f":"'Input Sheet'!G55","v":0},{"$f":"'Input Sheet'!H55","v":0},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":0},{"$f":"#REF!*H55","v":{"$error":"#REF!"}},{"$f":"'Input Sheet'!L55","v":0},{"$f":"'Input Sheet'!M55","v":0},{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":0},0,119.99,1,{"$f":"'Input Sheet'!S105","v":0},{"$f":"'Input Sheet'!T105","v":0},0,236.11,1]
["RO's 1-50",null,null,"Totals",{"$f":"SUM(E6:E55)","v":1679.16},{"$f":"SUM(F6:F55)","v":34.659999999999997},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},660.95,13.490000000000006,400,20,{"$error":"#VALUE!"},{"$f":"SUM(O6:O55)","v":239290.84710000001},2941.85,null,null,239707.85710000008,3347.2399999999993,{"$f":"COUNTIF(U5:U55,1)","v":37}]
["Date of Study:",null,null,null,"C Labor",null,null,null,null,"M Labor",null,null,null,null,"R Labor",null,null,null,null,"Total Cost of Labor","One Item Repair Order"]
["Study Compiled by",null,null,null,"Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost ","Labor Sales","Flat Rate Hours","Technician Number","Pay Per FRH","Labor Cost "]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"`"]

{"sheet":"RO Report 51-100","index":4,"n_rows":58,"n_cols":21,"rows_kept":58,"cut":false,"hidden":false,"merged":[[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],[57,7,58,7],[57,8,58,8],[57,9,58,9],[57,10,58,10],[57,11,58,11],[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],[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]]}
["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"]
[188417,2011,"CAMRY",123056,{"$f":"'Input Sheet'!G56","v":0},{"$f":"'Input Sheet'!H56","v":0},{"$f":"'Input Sheet'!I56","v":0},{"$f":"'Input Sheet'!J56","v":""},{"$f":"F6*H6","v":{"$error":"#VALUE!"}},20,0.4,{"$f":"'Input Sheet'!N56","v":0},{"$f":"'Input Sheet'!O56","v":239617.32709999999},{"$f":"K6*M6","v":95846.930840000001},{"$f":"'Input Sheet'!Q56","v":0},{"$f":"'Input Sheet'!R56","v":0},{"$f":"'Input Sheet'!S56","v":{"$error":"#VALUE!"}},{"$f":"'Input Sheet'!T56","v":7700.1399999999921},{"$f":"P6*R6","v":0},49.95,2]
[188418,2014,"CAMRY",49844,{"$f":"'Input Sheet'!G57","v":0},{"$f":"'Input Sheet'!H57","v":0},{"$f":"'Input Sheet'!I57","v":0},{"$f":"'Input Sheet'!J57","v":"Maintenance Labor"},{"$error":"#VALUE!"},42,0.6,{"$f":"'Input Sheet'!N57","v":0},{"$f":"'Input Sheet'!O57","v":"Repair Labor"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q57","v":0},{"$f":"'Input Sheet'!R57","v":0},{"$f":"'Input Sheet'!S57","v":0},{"$f":"'Input Sheet'!T57","v":"Total Cost of Labor"},{"$error":"#VALUE!"},71.95,1]
[188419,2016,"PRIUS",35479,22.99,0.3,{"$f":"'Input Sheet'!I58","v":"Labor Cost "},{"$f":"'Input Sheet'!J58","v":"Labor Sales"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!L58","v":"Technican Number"},{"$f":"'Input Sheet'!M58","v":"Pay Per FRH"},{"$f":"'Input Sheet'!N58","v":"Labor Cost "},{"$f":"'Input Sheet'!O58","v":"Labor Sales"},{"$error":"#VALUE!"},{"$f":"'Input Sheet'!Q58","v":"Technican Number"},{"$f":"'Input Sheet'!R58","v":"Pay Per FRH"},{"$f":"'Input Sheet'!S58","v":"Labor Cost "},{"$f":"'Input Sheet'!T58","v":0},{"$error":"#VALUE!"},25.12,1]
[188420,2015,"COROLLA",63436,{"$f":"'Input Sheet'!G59","v":0},{"$f":"'Input Sheet'!H59","v":0},{"$f":"'Input Sheet'!I59","v":0},{"$f":"'Input Sheet'!J59","v":0},0,20,0.4,{"$f":"'Input Sheet'!N59","v":0},{"$f":"'Input Sheet'!O59","v":0},0,{"$f":"'Input Sheet'!Q59","v":0},{"$f":"'Input Sheet'!R59","v":0},{"$f":"'Input Sheet'!S59","v":0},{"$f":"'Input Sheet'!T59","v":0},0,40.9,1]
[188422,2017,"CAMRY",31732,22,0.3,{"$f":"'Input Sheet'!I60","v":0},{"$f":"'Input Sheet'!J60","v":0},0,{"$f":"'Input Sheet'!L60","v":0},{"$f":"'Input Sheet'!M60","v":0},{"$f":"'Input Sheet'!N60","v":0},{"$f":"'Input Sheet'!O60","v":0},0,{"$f":"'Input Sheet'!Q60","v":0},{"$f":"'Input Sheet'!R60","v":0},{"$f":"'Input Sheet'!S60","v":0},{"$f":"'Input Sheet'!T60","v":0},0,237.45,1]
[188423,2007,"AVALON",120429,{"$f":"'Input Sheet'!G61","v":0},{"$f":"'Input Sheet'!H61","v":0},{"$f":"'Input Sheet'!I61","v":0},{"$f":"'Input Sheet'!J61","v":0},0,20,0.4,{"$f":"'Input Sheet'!N61","v":0},{"$f":"'Input Sheet'!O61","v":0},0,{"$f":"'Input Sheet'!Q61","v":0},{"$f":"'Input Sheet'!R61","v":0},{"$f":"'Input Sheet'!S61","v":0},{"$f":"'Input Sheet'!T61","v":0},0,42.95,1]
["188424C",2009,"COROLLA",100958,119.99,1,{"$f":"'Input Sheet'!I62","v":0},{"$f":"'Input Sheet'!J62","v":0},0,{"$f":"'Input Sheet'!L62","v":0},{"$f":"'Input Sheet'!M62","v":0},{"$f":"'Input Sheet'!N62","v":0},{"$f":"'Input Sheet'!O62","v":0},0,{"$f":"'Input Sheet'!Q62","v":0},{"$f":"'Input Sheet'!R62","v":0},{"$f":"'Input Sheet'!S62","v":0},{"$f":"'Input Sheet'!T62","v":0},0,131.09,1]
[188425,2013,"HIGHLANDER",60836,{"$f":"'Input Sheet'!G63","v":0},{"$f":"'Input Sheet'!H63","v":0},{"$f":"'Input Sheet'!I63","v":0},{"$f":"'Input Sheet'!J63","v":0},0,42,0.6,{"$f":"'Input Sheet'!N63","v":0},{"$f":"'Input Sheet'!O63","v":0},0,{"$f":"'Input Sheet'!Q63","v":0},{"$f":"'Input Sheet'!R63","v":0},{"$f":"'Input Sheet'!S63","v":0},{"$f":"'Input Sheet'!T63","v":0},0,76.95,1]
[188426,2014,"COROLLA",89057,{"$f":"'Input Sheet'!G64","v":0},{"$f":"'Input Sheet'!H64","v":0},{"$f":"'Input Sheet'!I64","v":0},{"$f":"'Input Sheet'!J64","v":0},0,42,0.6,{"$f":"'Input Sheet'!N64","v":0},{"$f":"'Input Sheet'!O64","v":0},0,{"$f":"'Input Sheet'!Q64","v":0},{"$f":"'Input Sheet'!R64","v":0},{"$f":"'Input Sheet'!S64","v":0},{"$f":"'Input Sheet'!T64","v":0},0,83.65,1]
[188427,2004,"CAMRY",105362,{"$f":"'Input Sheet'!G65","v":0},{"$f":"'Input Sheet'!H65","v":0},{"$f":"'Input Sheet'!I65","v":0},{"$f":"'Input Sheet'!J65","v":0},0,20,0.4,{"$f":"'Input Sheet'!N65","v":0},{"$f":"'Input Sheet'!O65","v":0},0,{"$f":"'Input Sheet'!Q65","v":0},{"$f":"'Input Sheet'!R65","v":0},{"$f":"'Input Sheet'!S65","v":0},{"$f":"'Input Sheet'!T65","v":0},0,49.95,5]
[188428,2015,"RAV4",25629,22.99,0.3,{"$f":"'Input Sheet'!I66","v":0},{"$f":"'Input Sheet'!J66","v":0},0,{"$f":"'Input Sheet'!L66","v":0},{"$f":"'Input Sheet'!M66","v":0},{"$f":"'Input Sheet'!N66","v":0},{"$f":"'Input Sheet'!O66","v":0},0,{"$f":"'Input Sheet'!Q66","v":0},{"$f":"'Input Sheet'!R66","v":0},{"$f":"'Input Sheet'!S66","v":0},{"$f":"'Input Sheet'!T66","v":0},0,56.75,2]
[188429,2013,"RAV4",74960,{"$f":"'Input Sheet'!G67","v":0},{"$f":"'Input Sheet'!H67","v":0},{"$f":"'Input Sheet'!I67","v":0},{"$f":"'Input Sheet'!J67","v":0},0,20,0.4,{"$f":"'Input Sheet'!N67","v":0},{"$f":"'Input Sheet'!O67","v":0},0,{"$f":"'Input Sheet'!Q67","v":0},{"$f":"'Input Sheet'!R67","v":0},{"$f":"'Input Sheet'!S67","v":0},{"$f":"'Input Sheet'!T67","v":0},0,49.95,1]
["188431C",2016,"4 RUNNER",33251,{"$f":"'Input Sheet'!G68","v":0},{"$f":"'Input Sheet'!H68","v":0},{"$f":"'Input Sheet'!I68","v":0},{"$f":"'Input Sheet'!J68","v":0},0,{"$f":"'Input Sheet'!L68","v":0},{"$f":"'Input Sheet'!M68","v":0},{"$f":"'Input Sheet'!N68","v":0},{"$f":"'Input Sheet'!O68","v":0},0,22.99,0.4,{"$f":"'Input Sheet'!S68","v":0},{"$f":"'Input Sheet'!T68","v":0},0,25.12,1]
[188432,2013,"AVALON",109905,{"$f":"'Input Sheet'!G69","v":0},{"$f":"'Input Sheet'!H69","v":0},{"$f":"'Input Sheet'!I69","v":0},{"$f":"'Input Sheet'!J69","v":0},0,20,0.6,{"$f":"'Input Sheet'!N69","v":0},{"$f":"'Input Sheet'!O69","v":0},0,{"$f":"'Input Sheet'!Q69","v":0},{"$f":"'Input Sheet'!R69","v":0},{"$f":"'Input Sheet'!S69","v":0},{"$f":"'Input Sheet'!T69","v":0},0,30.54,1]
[199434,2004,"AVALON",130944,159.99,2,{"$f":"'Input Sheet'!I70","v":0},{"$f":"'Input Sheet'!J70","v":0},0,{"$f":"'Input Sheet'!L70","v":0},{"$f":"'Input Sheet'!M70","v":0},{"$f":"'Input Sheet'!N70","v":0},{"$f":"'Input Sheet'!O70","v":0},0,{"$f":"'Input Sheet'!Q70","v":0},{"$f":"'Input Sheet'!R70","v":0},{"$f":"'Input Sheet'!S70","v":0},{"$f":"'Input Sheet'!T70","v":0},0,374.99,2]
[188436,2008,"AVALON",153451,{"$f":"'Input Sheet'!G71","v":0},{"$f":"'Input Sheet'!H71","v":0},{"$f":"'Input Sheet'!I71","v":0},{"$f":"'Input Sheet'!J71","v":0},0,20,0.4,{"$f":"'Input Sheet'!N71","v":0},{"$f":"'Input Sheet'!O71","v":0},0,{"$f":"'Input Sheet'!Q71","v":0},{"$f":"'Input Sheet'!R71","v":0},{"$f":"'Input Sheet'!S71","v":0},{"$f":"'Input Sheet'!T71","v":0},0,45.95,4]
[188437,2004,"CELICA",189908,89.95,1.2,{"$f":"'Input Sheet'!I72","v":0},{"$f":"'Input Sheet'!J72","v":0},0,{"$f":"'Input Sheet'!L72","v":0},{"$f":"'Input Sheet'!M72","v":0},{"$f":"'Input Sheet'!N72","v":0},{"$f":"'Input Sheet'!O72","v":0},0,{"$f":"'Input Sheet'!Q72","v":0},{"$f":"'Input Sheet'!R72","v":0},{"$f":"'Input Sheet'!S72","v":0},{"$f":"'Input Sheet'!T72","v":0},0,89.95,3]
[188438,2001,"LEXUS",63841,{"$f":"'Input Sheet'!G73","v":0},{"$f":"'Input Sheet'!H73","v":0},{"$f":"'Input Sheet'!I73","v":0},{"$f":"'Input Sheet'!J73","v":0},0,20,0.4,{"$f":"'Input Sheet'!N73","v":0},{"$f":"'Input Sheet'!O73","v":0},0,{"$f":"'Input Sheet'!Q73","v":0},{"$f":"'Input Sheet'!R73","v":0},{"$f":"'Input Sheet'!S73","v":0},{"$f":"'Input Sheet'!T73","v":0},0,59.95,1]
[188439,2010,"SCION XD",65478,22.99,0.3,{"$f":"'Input Sheet'!I74","v":0},{"$f":"'Input Sheet'!J74","v":0},0,{"$f":"'Input Sheet'!L74","v":0},{"$f":"'Input Sheet'!M74","v":0},{"$f":"'Input Sheet'!N74","v":0},{"$f":"'Input Sheet'!O74","v":0},0,{"$f":"'Input Sheet'!Q74","v":0},{"$f":"'Input Sheet'!R74","v":0},{"$f":"'Input Sheet'!S74","v":0},{"$f":"'Input Sheet'!T74","v":0},0,25.12,1]
[188440,2010,"CAMRY",112717,{"$f":"'Input Sheet'!G75","v":0},{"$f":"'Input Sheet'!H75","v":0},{"$f":"'Input Sheet'!I75","v":0},{"$f":"'Input Sheet'!J75","v":0},0,42,0.6,{"$f":"'Input Sheet'!N75","v":0},{"$f":"'Input Sheet'!O75","v":0},0,{"$f":"'Input Sheet'!Q75","v":0},{"$f":"'Input Sheet'!R75","v":0},{"$f":"'Input Sheet'!S75","v":0},{"$f":"'Input Sheet'!T75","v":0},0,71.95,3]
[188441,2016,"CAMRY",27950,22.99,0.3,{"$f":"'Input Sheet'!I76","v":0},{"$f":"'Input Sheet'!J76","v":0},0,{"$f":"'Input Sheet'!L76","v":0},{"$f":"'Input Sheet'!M76","v":0},{"$f":"'Input Sheet'!N76","v":0},{"$f":"'Input Sheet'!O76","v":0},0,{"$f":"'Input Sheet'!Q76","v":0},{"$f":"'Input Sheet'!R76","v":0},{"$f":"'Input Sheet'!S76","v":0},{"$f":"'Input Sheet'!T76","v":0},0,25.12,1]
[188442,2009,"TACOMA",110169,{"$f":"'Input Sheet'!G77","v":0},{"$f":"'Input Sheet'!H77","v":0},{"$f":"'Input Sheet'!I77","v":0},{"$f":"'Input Sheet'!J77","v":0},0,42,0.6,{"$f":"'Input Sheet'!N77","v":0},{"$f":"'Input Sheet'!O77","v":0},0,{"$f":"'Input Sheet'!Q77","v":0},{"$f":"'Input Sheet'!R77","v":0},{"$f":"'Input Sheet'!S77","v":0},{"$f":"'Input Sheet'!T77","v":0},0,64.709999999999994,5]
[188447,1997,"CAMRY",264339,null,{"$f":"'Input Sheet'!H78","v":0},{"$f":"'Input Sheet'!I78","v":0},{"$f":"'Input Sheet'!J78","v":0},0,{"$f":"'Input Sheet'!L78","v":0},{"$f":"'Input Sheet'!M78","v":0},{"$f":"'Input Sheet'!N78","v":0},{"$f":"'Input Sheet'!O78","v":0},0,5,0.4,{"$f":"'Input Sheet'!S78","v":0},{"$f":"'Input Sheet'!T78","v":0},0,15.94,2]
[188453,2014,"COROLLA",54098,{"$f":"'Input Sheet'!G79","v":0},{"$f":"'Input Sheet'!H79","v":0},{"$f":"'Input Sheet'!I79","v":0},{"$f":"'Input Sheet'!J79","v":0},0,20,0.3,{"$f":"'Input Sheet'!N79","v":0},{"$f":"'Input Sheet'!O79","v":0},0,{"$f":"'Input Sheet'!Q79","v":0},{"$f":"'Input Sheet'!R79","v":0},{"$f":"'Input Sheet'!S79","v":0},{"$f":"'Input Sheet'!T79","v":0},0,49.95,1]
[188454,2015,"COROLLA",24619,22.99,0.3,{"$f":"'Input Sheet'!I80","v":0},{"$f":"'Input Sheet'!J80","v":0},0,{"$f":"'Input Sheet'!L80","v":0},{"$f":"'Input Sheet'!M80","v":0},{"$f":"'Input Sheet'!N80","v":0},{"$f":"'Input Sheet'!O80","v":0},0,{"$f":"'Input Sheet'!Q80","v":0},{"$f":"'Input Sheet'!R80","v":0},{"$f":"'Input Sheet'!S80","v":0},{"$f":"'Input Sheet'!T80","v":0},0,22.99,1]
[188455,2014,"LEXUS",47634,22.99,0.3,{"$f":"'Input Sheet'!I81","v":0},{"$f":"'Input Sheet'!J81","v":0},0,{"$f":"'Input Sheet'!L81","v":0},{"$f":"'Input Sheet'!M81","v":0},{"$f":"'Input Sheet'!N81","v":0},{"$f":"'Input Sheet'!O81","v":0},0,{"$f":"'Input Sheet'!Q81","v":0},{"$f":"'Input Sheet'!R81","v":0},{"$f":"'Input Sheet'!S81","v":0},{"$f":"'Input Sheet'!T81","v":0},0,22.99,1]
[188456,2013,"PRIUS",71106,22.99,0.3,{"$f":"'Input Sheet'!I82","v":0},{"$f":"'Input Sheet'!J82","v":0},0,{"$f":"'Input Sheet'!L82","v":0},{"$f":"'Input Sheet'!M82","v":0},{"$f":"'Input Sheet'!N82","v":0},{"$f":"'Input Sheet'!O82","v":0},0,{"$f":"'Input Sheet'!Q82","v":0},{"$f":"'Input Sheet'!R82","v":0},{"$f":"'Input Sheet'!S82","v":0},{"$f":"'Input Sheet'!T82","v":0},0,22.99,1]
[188457,2013,"LAND CRUISER",62307,{"$f":"'Input Sheet'!G83","v":0},{"$f":"'Input Sheet'!H83","v":0},{"$f":"'Input Sheet'!I83","v":0},{"$f":"'Input Sheet'!J83","v":0},0,42,0.6,{"$f":"'Input Sheet'!N83","v":0},{"$f":"'Input Sheet'!O83","v":0},0,{"$f":"'Input Sheet'!Q83","v":0},{"$f":"'Input Sheet'!R83","v":0},{"$f":"'Input Sheet'!S83","v":0},{"$f":"'Input Sheet'!T83","v":0},0,86.95,2]
[188459,2012,"4 RUNNER",89623,{"$f":"'Input Sheet'!G84","v":0},{"$f":"'Input Sheet'!H84","v":0},{"$f":"'Input Sheet'!I84","v":0},{"$f":"'Input Sheet'!J84","v":0},0,20,0.4,{"$f":"'Input Sheet'!N84","v":0},{"$f":"'Input Sheet'!O84","v":0},0,{"$f":"'Input Sheet'!Q84","v":0},{"$f":"'Input Sheet'!R84","v":0},{"$f":"'Input Sheet'!S84","v":0},{"$f":"'Input Sheet'!T84","v":0},0,54.95,1]
[188460,2013,"TUNDRA",127145,{"$f":"'Input Sheet'!G85","v":0},{"$f":"'Input Sheet'!H85","v":0},{"$f":"'Input Sheet'!I85","v":0},{"$f":"'Input Sheet'!J85","v":0},0,20,0.4,{"$f":"'Input Sheet'!N85","v":0},{"$f":"'Input Sheet'!O85","v":0},0,{"$f":"'Input Sheet'!Q85","v":0},{"$f":"'Input Sheet'!R85","v":0},{"$f":"'Input Sheet'!S85","v":0},{"$f":"'Input Sheet'!T85","v":0},0,64.95,1]
[188461,2001,"TUNDRA",200925,{"$f":"'Input Sheet'!G86","v":0},{"$f":"'Input Sheet'!H86","v":0},{"$f":"'Input Sheet'!I86","v":0},{"$f":"'Input Sheet'!J86","v":0},0,{"$f":"'Input Sheet'!L86","v":0},{"$f":"'Input Sheet'!M86","v":0},{"$f":"'Input Sheet'!N86","v":0},{"$f":"'Input Sheet'!O86","v":0},0,178.5,1.5,{"$f":"'Input Sheet'!S86","v":0},{"$f":"'Input Sheet'!T86","v":0},0,739.16,2]
[188463,2009,"CAMRY",149782,{"$f":"'Input Sheet'!G87","v":0},{"$f":"'Input Sheet'!H87","v":0},{"$f":"'Input Sheet'!I87","v":0},{"$f":"'Input Sheet'!J87","v":0},0,{"$f":"'Input Sheet'!L87","v":0},{"$f":"'Input Sheet'!M87","v":0},{"$f":"'Input Sheet'!N87","v":0},{"$f":"'Input Sheet'!O87","v":0},0,119.99,1,{"$f":"'Input Sheet'!S87","v":0},{"$f":"'Input Sheet'!T87","v":0},0,119.99,1]
["188465C",2013,"COROLLA",71114,{"$f":"'Input Sheet'!G88","v":0},{"$f":"'Input Sheet'!H88","v":0},{"$f":"'Input Sheet'!I88","v":0},{"$f":"'Input Sheet'!J88","v":0},0,20,0.4,{"$f":"'Input Sheet'!N88","v":0},{"$f":"'Input Sheet'!O88","v":0},0,{"$f":"'Input Sheet'!Q88","v":0},{"$f":"'Input Sheet'!R88","v":0},{"$f":"'Input Sheet'!S88","v":0},{"$f":"'Input Sheet'!T88","v":0},0,49.95,3]
[188469,2016,"AVALON",29934,{"$f":"'Input Sheet'!G89","v":0},{"$f":"'Input Sheet'!H89","v":0},{"$f":"'Input Sheet'!I89","v":0},{"$f":"'Input Sheet'!J89","v":0},0,20,0.4,{"$f":"'Input Sheet'!N89","v":0},{"$f":"'Input Sheet'!O89","v":0},0,{"$f":"'Input Sheet'!Q89","v":0},{"$f":"'Input Sheet'!R89","v":0},{"$f":"'Input Sheet'!S89","v":0},{"$f":"'Input Sheet'!T89","v":0},0,47.28,1]
[188471,2016,"RAV4",49966,22,0.28000000000000003,{"$f":"'Input Sheet'!I90","v":0},{"$f":"'Input Sheet'!J90","v":0},0,{"$f":"'Input Sheet'!L90","v":0},{"$f":"'Input Sheet'!M90","v":0},{"$f":"'Input Sheet'!N90","v":0},{"$f":"'Input Sheet'!O90","v":0},0,{"$f":"'Input Sheet'!Q90","v":0},{"$f":"'Input Sheet'!R90","v":0},{"$f":"'Input Sheet'!S90","v":0},{"$f":"'Input Sheet'!T90","v":0},0,185.6,2]
[188473,2012,"COROLLA",64367,{"$f":"'Input Sheet'!G91","v":0},{"$f":"'Input Sheet'!H91","v":0},{"$f":"'Input Sheet'!I91","v":0},{"$f":"'Input Sheet'!J91","v":0},0,22,0.4,{"$f":"'Input Sheet'!N91","v":0},{"$f":"'Input Sheet'!O91","v":0},0,{"$f":"'Input Sheet'!Q91","v":0},{"$f":"'Input Sheet'!R91","v":0},{"$f":"'Input Sheet'!S91","v":0},{"$f":"'Input Sheet'!T91","v":0},0,49.95,7]
[188474,2013,"CAMRY",72455,{"$f":"'Input Sheet'!G92","v":0},{"$f":"'Input Sheet'!H92","v":0},{"$f":"'Input Sheet'!I92","v":0},{"$f":"'Input Sheet'!J92","v":0},0,20,0.4,{"$f":"'Input Sheet'!N92","v":0},{"$f":"'Input Sheet'!O92","v":0},0,{"$f":"'Input Sheet'!Q92","v":0},{"$f":"'Input Sheet'!R92","v":0},{"$f":"'Input Sheet'!S92","v":0},{"$f":"'Input Sheet'!T92","v":0},0,49.95,2]
[188479,2011,"PRIUS",44550,{"$f":"'Input Sheet'!G93","v":0},{"$f":"'Input Sheet'!H93","v":0},{"$f":"'Input Sheet'!I93","v":0},{"$f":"'Input Sheet'!J93","v":0},0,20,0.4,{"$f":"'Input Sheet'!N93","v":0},{"$f":"'Input Sheet'!O93","v":0},0,{"$f":"'Input Sheet'!Q93","v":0},{"$f":"'Input Sheet'!R93","v":0},{"$f":"'Input Sheet'!S93","v":0},{"$f":"'Input Sheet'!T93","v":0},0,49.95,1]
[188480,2014,"TUNDRA",107051,91.03,1,{"$f":"'Input Sheet'!I94","v":0},{"$f":"'Input Sheet'!J94","v":0},0,{"$f":"'Input Sheet'!L94","v":0},{"$f":"'Input Sheet'!M94","v":0},{"$f":"'Input Sheet'!N94","v":0},{"$f":"'Input Sheet'!O94","v":0},0,{"$f":"'Input Sheet'!Q94","v":0},{"$f":"'Input Sheet'!R94","v":0},{"$f":"'Input Sheet'!S94","v":0},{"$f":"'Input Sheet'!T94","v":0},0,169.95,2]
[188481,2010,"LEXUS",147604,42,0.6,{"$f":"'Input Sheet'!I95","v":0},{"$f":"'Input Sheet'!J95","v":0},0,{"$f":"'Input Sheet'!L95","v":0},{"$f":"'Input Sheet'!M95","v":0},{"$f":"'Input Sheet'!N95","v":0},{"$f":"'Input Sheet'!O95","v":0},0,{"$f":"'Input Sheet'!Q95","v":0},{"$f":"'Input Sheet'!R95","v":0},{"$f":"'Input Sheet'!S95","v":0},{"$f":"'Input Sheet'!T95","v":0},0,81.95,2]
[188482,2009,"HIGHLANDER",182668,{"$f":"'Input Sheet'!G96","v":0},{"$f":"'Input Sheet'!H96","v":0},{"$f":"'Input Sheet'!I96","v":0},{"$f":"'Input Sheet'!J96","v":0},0,20,0.4,{"$f":"'Input Sheet'!N96","v":0},{"$f":"'Input Sheet'!O96","v":0},0,{"$f":"'Input Sheet'!Q96","v":0},{"$f":"'Input Sheet'!R96","v":0},{"$f":"'Input Sheet'!S96","v":0},{"$f":"'Input Sheet'!T96","v":0},0,39.950000000000003,1]
[188483,2011,"CAMRY HYBRID",49535,{"$f":"'Input Sheet'!G97","v":0},{"$f":"'Input Sheet'!H97","v":0},{"$f":"'Input Sheet'!I97","v":0},{"$f":"'Input Sheet'!J97","v":0},0,42,0.6,{"$f":"'Input Sheet'!N97","v":0},{"$f":"'Input Sheet'!O97","v":0},0,{"$f":"'Input Sheet'!Q97","v":0},{"$f":"'Input Sheet'!R97","v":0},{"$f":"'Input Sheet'!S97","v":0},{"$f":"'Input Sheet'!T97","v":0},0,61.95,4]
[188484,2005,"LAND CRUISER",227975,{"$f":"'Input Sheet'!G98","v":0},{"$f":"'Input Sheet'!H98","v":0},{"$f":"'Input Sheet'!I98","v":0},{"$f":"'Input Sheet'!J98","v":0},0,42,0.6,{"$f":"'Input Sheet'!N98","v":0},{"$f":"'Input Sheet'!O98","v":0},0,{"$f":"'Input Sheet'!Q98","v":0},{"$f":"'Input Sheet'!R98","v":0},{"$f":"'Input Sheet'!S98","v":0},{"$f":"'Input Sheet'!T98","v":0},0,70.95,2]
[188488,2011,"HIGHLANDER",191384,22,0.3,{"$f":"'Input Sheet'!I99","v":0},{"$f":"'Input Sheet'!J99","v":0},0,{"$f":"'Input Sheet'!L99","v":0},{"$f":"'Input Sheet'!M99","v":0},{"$f":"'Input Sheet'!N99","v":0},{"$f":"'Input Sheet'!O99","v":0},0,{"$f":"'Input Sheet'!Q99","v":0},{"$f":"'Input Sheet'!R99","v":0},{"$f":"'Input Sheet'!S99","v":0},{"$f":"'Input Sheet'!T99","v":0},0,247.6,2]
[188489,2012,"CAMRY",75810,{"$f":"'Input Sheet'!G100","v":0},{"$f":"'Input Sheet'!H100","v":0},{"$f":"'Input Sheet'!I100","v":0},{"$f":"'Input Sheet'!J100","v":0},0,20,0.4,{"$f":"'Input Sheet'!N100","v":0},{"$f":"'Input Sheet'!O100","v":0},0,{"$f":"'Input Sheet'!Q100","v":0},{"$f":"'Input Sheet'!R100","v":0},{"$f":"'Input Sheet'!S100","v":0},{"$f":"'Input Sheet'!T100","v":0},0,49.95,2]
[188491,2012,"CAMRY",106030,{"$f":"'Input Sheet'!G101","v":0},{"$f":"'Input Sheet'!H101","v":0},{"$f":"'Input Sheet'!I101","v":0},{"$f":"'Input Sheet'!J101","v":0},0,20,0.4,{"$f":"'Input Sheet'!N101","v":0},{"$f":"'Input Sheet'!O101","v":0},0,{"$f":"'Input Sheet'!Q101","v":0},{"$f":"'Input Sheet'!R101","v":0},{"$f":"'Input Sheet'!S101","v":0},{"$f":"'Input Sheet'!T101","v":0},0,49.95,2]
[188492,2015,"COROLLA",47158,22.99,0.3,{"$f":"'Input Sheet'!I102","v":0},{"$f":"'Input Sheet'!J102","v":0},0,{"$f":"'Input Sheet'!L102","v":0},{"$f":"'Input Sheet'!M102","v":0},{"$f":"'Input Sheet'!N102","v":0},{"$f":"'Input Sheet'!O102","v":0},0,{"$f":"'Input Sheet'!Q102","v":0},{"$f":"'Input Sheet'!R102","v":0},{"$f":"'Input Sheet'!S102","v":0},{"$f":"'Input Sheet'!T102","v":0},0,25.12,1]
[188493,2003,"SEQUOIA",291414,{"$f":"'Input Sheet'!G103","v":0},{"$f":"'Input Sheet'!H103","v":0},{"$f":"'Input Sheet'!I103","v":0},{"$f":"'Input Sheet'!J103","v":0},0,20,0.4,{"$f":"'Input Sheet'!N103","v":0},{"$f":"'Input Sheet'!O103","v":0},0,{"$f":"'Input Sheet'!Q103","v":0},{"$f":"'Input Sheet'!R103","v":0},{"$f":"'Input Sheet'!S103","v":0},{"$f":"'Input Sheet'!T103","v":0},0,48.95,1]
["188413C",2016,"CAMRY",40114,119.99,1,{"$f":"'Input Sheet'!I104","v":0},{"$f":"'Input Sheet'!J104","v":0},0,{"$f":"'Input Sheet'!L104","v":0},{"$f":"'Input Sheet'!M104","v":0},{"$f":"'Input Sheet'!N104","v":0},{"$f":"'Input Sheet'!O104","v":0},0,{"$f":"'Input Sheet'!Q104","v":0},{"$f":"'Input Sheet'!R104","v":0},{"$f":"'Input Sheet'!S104","v":0},{"$f":"'Input Sheet'!T104","v":0},0,119.99,2]
[188418,2011,"CAMRY",123056,22.99,0.3,{"$f":"'Input Sheet'!I105","v":0},{"$f":"'Input Sheet'!J105","v":0},0,{"$f":"'Input Sheet'!L105","v":0},{"$f":"'Input Sheet'!M105","v":0},{"$f":"'Input Sheet'!N105","v":0},{"$f":"'Input Sheet'!O105","v":0},0,{"$f":"'Input Sheet'!Q105","v":0},{"$f":"'Input Sheet'!R105","v":0},{"$f":"'Input Sheet'!S105","v":0},{"$f":"'Input Sheet'!T105","v":0},0,22.99,2]
["RO's 51-100",null,null,"Totals",{"$f":"SUM(E6:E55)","v":895.86},{"$f":"SUM(F6:F55)","v":10.380000000000003},null,null,{"$f":"SUM(I6:I55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(J6:J55)","v":738},{"$f":"SUM(K6:K55)","v":12.900000000000002},null,null,{"$f":"SUM(N6:N55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(O6:O55)","v":326.48},{"$f":"SUM(P6:P55)","v":3.3},null,null,{"$f":"SUM(S6:S55)","v":{"$error":"#VALUE!"}},{"$f":"SUM(T6:T55)","v":4352.8999999999969},{"$f":"COUNTIF(U5:U55,1)","v":26}]
["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":[[26,11,27,11],[26,7,26,8],[28,2,28,10],[26,4,26,5],[27,4,27,5],[27,7,27,8],[11,2,11,9],[15,2,15,9],[25,4,25,5],[25,7,25,8],[24,2,24,9],[9,2,9,3],[0,2,0,10],[2,6,3,6],[2,4,3,5],[3,9,3,10],[1,2,1,10]]}
[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":2575.02},"÷",{"$f":"'RO Report 1-50'!F56+'RO Report 51-100'!F56","v":45.04},"=",{"$f":"IF(ISERROR(E5/G5),\"\",E5/G5)","v":57.171847246891652},"FRH Average"]
[null,null,"Maintenance",null,{"$f":"'RO Report 1-50'!J56+'RO Report 51-100'!J56","v":1398.95},"÷",{"$f":"'RO Report 1-50'!K56+'RO Report 51-100'!K56","v":26.390000000000008},"=",{"$f":"IF(ISERROR(E6/G6),\"\",E6/G6)","v":53.010610079575585},"FRH Average"]
[null,null,"Repair",null,{"$f":"'RO Report 1-50'!O56+'RO Report 51-100'!O56","v":239617.32710000002},"÷",{"$f":"'RO Report 1-50'!P56+'RO Report 51-100'!P56","v":2945.15},"=",{"$f":"IF(ISERROR(E7/G7),\"\",E7/G7)","v":81.359973889275594},"FRH Average"]
[null,null,"Totals",null,{"$f":"SUM(E5:E7)","v":4766.0700000000006},"÷",{"$f":"SUM(G5:G7)","v":99.43},"=",{"$f":"IF(ISERROR(E8/G8),\"\",E8/G8)","v":47.933923363170074},"Customer ELR"]
[null,null,null,null,null,null,null,"Target Labor Rate",93,"Per FRH"]
[null,null,"Total Ro's in Sample",null,100,null,null,"Difference",{"$f":"IF(ISERROR(I8-I9),\"\",I8-I9)","v":47.933923363170074},"Per FRH"]
[]
[null,null,"Cost of Labor"]
[null,null,"Total Cost of Labor",null,{"$f":"'Input Sheet'!V106","v":7700.1399999999921},"÷","Total Sales","=",{"$f":"IF(ISERROR(E13/E8),\"\",E13/E8)","v":4.1963294706120549E-3},"Percent Cost of Sales"]
[null,null,"Total Cost of Labor",null,{"$f":"E13","v":7700.1399999999921},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E14/G8),\"\",E14/G8)","v":0.20114653525093029},"Cost per FRH"]
[]
[null,null,"Repair Order Measurements"]
[null,null,"Total Labor Sales",null,{"$f":"E8","v":4766.0700000000006},"÷","Total RO's","=",{"$f":"IF(ISERROR(E17/E10),\"\",E17/E10)","v":""},"Avg Labor per RO"]
[null,null,"Total FRH's",null,{"$f":"G8","v":99.43},"÷","Total RO's","=",{"$f":"IF(ISERROR(E18/E10),\"\",E18/E10)","v":""},"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":45.04},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E20/G8),\"\",(E20/G8))","v":0.45298199738509498},"Percent Competitive"]
[null,null,"Maintenance FRH's",null,{"$f":"G6","v":26.390000000000008},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E21/G8),\"\",(E21/G8))","v":0.26541285326360259},"Percent Maintenance "]
[null,null,"Repair FRH'",null,{"$f":"G7","v":2945.15},"÷","Total FRH's","=",{"$f":"IF(ISERROR(E22/G8),\"\",E22/G8)","v":0.28160514935130243},"Percent Repair "]
[null,null,"One item RO's",null,{"$f":"'RO Report 1-50'!U56+'RO Report 51-100'!U56","v":63},"÷","Total RO's","=",{"$f":"IF(ISERROR(E23/E10),\"\",E23/E10)","v":0.63},"Percent One Item RO"]
[]
[null,null,"Model Year Analysis"]
[null,null,{"$f":"YEAR(Title!K17)+1","v":2019},{"$f":"YEAR(Title!K17)","v":2018},{"$f":"YEAR(Title!K17)-1","v":2017},null,{"$f":"YEAR(Title!K17)-2","v":2016},{"$f":"YEAR(Title!K17)-3","v":2015},null,{"$f":"YEAR(Title!K17)-4","v":2014},"Older","Total"]
[null,null,{"$f":"COUNTIF('Input Sheet'!D6:D105,C26)","v":0},{"$f":"COUNTIF('Input Sheet'!D6:D105,D26)","v":0},{"$f":"COUNTIF('Input Sheet'!D6:D105,E26)","v":1},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,G26)","v":13},{"$f":"COUNTIF('Input Sheet'!D6:D105,H26)","v":9},null,{"$f":"COUNTIF('Input Sheet'!D6:D105,J26)","v":9},{"$f":"L27-(SUM(C27:J27))","v":68},{"$f":"DCOUNTA('Input Sheet'!C4:F105,\"Year\",'Input Sheet'!D4:D105)","v":100}]
[null,null,{"$f":"IF(ISERROR(C27/L27),\"\",C27/L27)","v":0},{"$f":"IF(ISERROR(D27/L27),\"\",D27/L27)","v":0},{"$f":"IF(ISERROR(E27/L27),\"\",E27/L27)","v":0.01},null,{"$f":"IF(ISERROR(G27/L27),\"\",G27/L27)","v":0.13},{"$f":"IF(ISERROR(H27/L27),\"\",H27/L27)","v":0.09},null,{"$f":"IF(ISERROR(J27/L27),\"\",J27/L27)","v":0.09},{"$f":"IF(ISERROR(K27/L27),\"\",K27/L27)","v":0.68}]