{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Wheels Calculator","Wheel_Tire_Data","Weight Variables - Wheels","2 Tracks Calculator","Weight Variables -2 Track","4 Tracks Calculator","Weight Variables - 4 Track"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":185,"comments":9,"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":"Wheels Calculator","index":0,"n_rows":81,"n_cols":14,"rows_kept":81,"cut":false,"hidden":false,"merged":[[8,11,17,11],[46,3,46,5],[47,3,47,5],[33,2,35,2],[33,6,35,6],[31,7,31,9],[32,7,32,9],[44,8,45,8],[43,7,43,9],[43,3,43,5],[44,3,44,5],[4,3,4,5],[5,3,5,5],[4,7,4,9],[5,7,5,9],[28,1,28,3],[28,5,28,9],[27,1,27,3],[27,5,27,9],[25,1,25,3],[119,5,120,5],[46,8,47,8],[45,3,45,5],[37,11,43,11],[26,1,26,3],[37,3,37,9],[38,8,39,8],[40,8,41,8],[33,8,35,8],[29,8,30,8],[42,1,44,1],[38,4,39,4],[40,4,41,4],[38,6,39,6],[40,6,41,6],[37,1,39,1]]}
[]
[]
[]
[]
[null,null,null,"Customer Name:",null,null,null,"Name of analysis:"]
[null,null,null,"Customer",null,null,null,"Application"]
[]
[null," Model:",null,"Emission Level:",null," Transmission:",null," Front Axle:",null," Rear Axle:"]
[null,"8R 370",null,"Final Tier 4/ Stage 5",null,"e23",null,"1300 MFWD",null,"120mm x 3012mm (Double Taper)"]
["(kg)",{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!B27:B34,MATCH('Wheels Calculator'!B9,'Weight Variables - Wheels'!B3:B10,0)),0)","v":370},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!C27:C30,MATCH('Wheels Calculator'!D9,'Weight Variables - Wheels'!C3:C6,0)),0)","v":1504},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!D27:D30,MATCH('Wheels Calculator'!F9,'Weight Variables - Wheels'!D3:D6,0)),0)","v":1167.8},null,{"$f":"INDEX('Weight Variables - Wheels'!E28:E31,MATCH('Wheels Calculator'!H9,FrontAxle,0))","v":1044.3510100000001},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!F27:F33,MATCH(J9,'Weight Variables - Wheels'!F3:F9,0)),0)","v":494.61}]
["(mm)",5300,null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!C59:C61,MATCH('Wheels Calculator'!D9,'Weight Variables - Wheels'!C4:C6,0)),0)","v":-2967.8050000000003},null,{"$f":"_xlfn.IFNA(INDEX(mm_Trans, MATCH(F9,Trans,0)),0)","v":-1977},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!E59:E62,MATCH('Wheels Calculator'!H9,FrontAxle,0)),0)","v":-3050},null,0]
[null,-880,null,null,null,"16 PST not available for 345hp or 370hp models ",null,"1300 not available for 320/345/370/410hp models ",null,"110mm options not available for 320/345/370/410hp models"]
[]
[null,"Front Fenders:",null,"Rear Fenders:",null,"Front PTO:",null,"Trailer Brakes:",null,"Fuel Level:"]
[null,"500mm (19.7in)",null,"2.55m",null,"Not Included",null,"Dual line Air",null,"Half "]
["(kg)",{"$f":"_xlfn.IFNA(INDEX(kg_FrontFenders, MATCH(B15,FrontFenders,0)),0)","v":60.921402},null,{"$f":"_xlfn.IFNA(INDEX(kg_RearFenders, MATCH(D15,RearFenders,0)),0)","v":53.4},null,{"$f":"_xlfn.IFNA(INDEX(kg_FrontPTO, MATCH(F15,FrontPTO,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX(kg_TrailerBrakes,MATCH(H15,TrailerBrakes,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!AB28:AB33, MATCH(J15,'Weight Variables - Wheels'!AB4:AB9,0)),0)","v":274.125}]
["(mm)",{"$f":"_xlfn.IFNA(INDEX(mm_FrontFenders, MATCH(B15,FrontFenders,0)),0)","v":-2636},null,{"$f":"_xlfn.IFNA(INDEX(mm_RearFenders, MATCH(D15,RearFenders,0)),0)","v":29.826000000000001},null,{"$f":"_xlfn.IFNA(INDEX(mm_FrontPTO, MATCH(F15,FrontPTO,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX(mm_TrailerBrakes,MATCH(H15,TrailerBrakes,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!AB59:AB64, MATCH(J15,'Weight Variables - Wheels'!AB4:AB9,0)),0)","v":-1305}]
[null,null,null,null,null,"Requires ILS",null,"   ",null,"Assuming .85 kg/L"]
[]
[null," Front Hitch",null," Rear Hitch:",null," Drawbar:",null,"3 in 1 Rails Option:",null,"# of SCVs:"]
[null,"Not Included",null,"CAT 4 Ball Ends w/ Sway Block",null,"Cat 4",null,"Not Included",null,5]
["(kg)",{"$f":"_xlfn.IFNA(INDEX(kg_FrontHitch, MATCH(B21,FrontHitch,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!W28:W39,MATCH('Wheels Calculator'!D21,'Weight Variables - Wheels'!W4:W15,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!X27:X34, MATCH(F21,'Weight Variables - Wheels'!X3:X10,0)),0)","v":165.76999999999998},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!Y27:Y33,MATCH('Wheels Calculator'!H21,'Weight Variables - Wheels'!Y3:Y8,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!AC27:AC32,MATCH('Wheels Calculator'!J21,'Weight Variables - Wheels'!AC3:AC8,0)),0)","v":84.161861000000002}]
["(mm)",{"$f":"_xlfn.IFNA(INDEX(mm_FrontHitch, MATCH(B21,FrontHitch,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!W59:W70,MATCH('Wheels Calculator'!D21,'Weight Variables - Wheels'!W4:W15,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!X58:X65,MATCH('Wheels Calculator'!F21,'Weight Variables - Wheels'!X3:X10,0)),0)","v":685.12220365325459},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!Y57:Y62,MATCH('Wheels Calculator'!H21,'Weight Variables - Wheels'!Y3:Y8,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!AC58:AC63,MATCH('Wheels Calculator'!J21,'Weight Variables - Wheels'!AC3:AC8,0)),0)","v":388}]
[null,"None",null,"None",null,"None",null,"None",null,"None"]
[]
[null,"Brand"]
[null,"Firestone"]
[null,"Front Tires",null,null,null,"Rear Tires"]
[null,"Group 44",null,null,null,"Group 48"]
[null," Single:",null," Dual:",null," Single:",null," Dual:",null," Triple:"]
[null,"420/85R34",null,"Not Included",null,"480/80R50",null,"480/80R50"]
[null," Tire Load Index",null,"Configuration",null," Tire Load Index",null,"Configuration"]
[null,{"$f":"INDEX(Wheel_Tire_Data!$AF$5:$AF$99,MATCH($B$27&'Wheels Calculator'!$B$31,INDEX(Wheel_Tire_Data!$AD$5:$AD$99&Wheel_Tire_Data!$AB$5:$AB$99,),0))","v":147},null,{"$f":"_xlfn.IFNA(IF(AND($H$9='Weight Variables - Wheels'!$E$4,$D$31<>\"\",D31<>\"Not Available\",$D$31<>\"Not Included\"), \"Duals Not Permissible On 1300 MFWD Axle\",IF(AND(B31<>D31,D31<>\"\",D31<>\"Not Available\",D31<>\"Not Included\"), \"Please select the same size dual\",IF(AND($B$31<>0,$B$31=$D$31,$D$36>$B$33),CONCATENATE(\"Axle Load Exceeds Tire Load Index. Requires \",D36),IF(AND(B31<>D31,$B$36>$B$33),CONCATENATE(\"Axle Load Exceeds Tire Load Index. Requires \",B36),\"GOOD\")))),\"GOOD\")","v":"GOOD"},null,{"$f":"INDEX(Wheel_Tire_Data!$G$5:$G$99,MATCH($B$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$99&Wheel_Tire_Data!C5:C99,),0))","v":159},null,{"$f":"_xlfn.IFNA(_xlfn.IFS(AND(J31<>F31,AND(LEN(J31)>4,J31<>\"Not Included\",$J$31<>\"Not Available\")),\"Please select the same size triple\",OR(AND(H31<>F31,AND(LEN(H31)>4,H31<>\"Not Included\",H31<>\"Not Available\")),AND($J$31<>\"Not Available\",$J$31<>\"Not Included\",LEN(J31)>4,$J$31<>$H$31)),\"Please select the same size dual or remove triple\"),IF(AND(F31=H31,H31<>J31,$F$33<$H$36),CONCATENATE(\"Requires a minimum load index of \",H36),IF(AND(F31<>H31,F31<>J31,$F$33<$F$36),CONCATENATE(\"Requires a minimum load index of \",F36),IF(AND(F31=H31,H31=J31,$F$33<$J$36),CONCATENATE(\"Requires minimum load index of \",J36),\"GOOD\"))))","v":"GOOD"}]
["(kg)",{"$f":"_xlfn.IFNA(INDEX(Wheel_Tire_Data!$AN$5:$AN$99,MATCH($B$27&$B$31,INDEX(Wheel_Tire_Data!$AD$5:$AD$99&Wheel_Tire_Data!$AB$5:$AB$99,),0)),0)","v":487.5},null,{"$f":"IF(OR($D$31=\"\",$D$31=\"Not Included\", $D$31=\"Not Available\"),0,INDEX(Wheel_Tire_Data!AO5:AO99,MATCH('Wheels Calculator'!B27:D27&'Wheels Calculator'!B31,INDEX(Wheel_Tire_Data!$AD$5:$AD$99&Wheel_Tire_Data!$AB$5:$AB$99,),0)))","v":0},null,{"$f":"_xlfn.IFNA(INDEX(Wheel_Tire_Data!$U$5:$U$73,MATCH($B$27&$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$73&Wheel_Tire_Data!$C$5:$C$73,),0)),0)","v":776},null,{"$f":"IF(OR(H31=\"\",H31=Wheel_Tire_Data!M103,H31=\"Not Available\"),0,IF(OR($J$31=\"\",$J$31=\"Not Available\", $J$31=\"Not Included\"),_xlfn.IFNA(INDEX(Wheel_Tire_Data!$V$5:$V$99,MATCH($B$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$99&Wheel_Tire_Data!$C$5:$C$99,),0)),0),_xlfn.IFNA(INDEX(Wheel_Tire_Data!$W$5:$W$99,MATCH($B$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$99&Wheel_Tire_Data!$C$5:$C$99,),0)),0)))","v":999.48},null,{"$f":"_xlfn.IFNA(IF(OR(J31=Wheel_Tire_Data!$N$103,J31=\"\",J31=\"Not Available\"),0,INDEX(Wheel_Tire_Data!$X$5:$X$99,MATCH($B$27&$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$99&Wheel_Tire_Data!$C$5:$C$99,),0))+Wheel_Tire_Data!C115),0)","v":0}]
["(mm)",{"$f":"IF(H9='Weight Variables - Wheels'!$E$4,'Weight Variables - Wheels'!$E$59,'Weight Variables - Wheels'!$E$60)","v":-3050},null,{"$f":"IF(H9='Weight Variables - Wheels'!$E$4,'Weight Variables - Wheels'!$E$59,'Weight Variables - Wheels'!$E$60)","v":-3050},null,0,null,0,null,0]
[null,{"$f":"INDEX(Wheel_Tire_Data!$P$102:$P$134,MATCH('Wheels Calculator'!$D$64/2,Wheel_Tire_Data!$Q$102:$Q$134,-1))","v":145},null,{"$f":"INDEX(Wheel_Tire_Data!$P$102:$P$134,MATCH('Wheels Calculator'!$D$64/4/0.88,Wheel_Tire_Data!$Q$102:$Q$134,-1))","v":133},null,{"$f":"INDEX(Wheel_Tire_Data!$P$102:$P$134,MATCH('Wheels Calculator'!$D$65/2,Wheel_Tire_Data!$Q$102:$Q$134,-1))","v":152},null,{"$f":"INDEX(Wheel_Tire_Data!$P$102:$P$134,MATCH('Wheels Calculator'!$D$65/4/0.88,Wheel_Tire_Data!$Q$102:$Q$134,-1))","v":133},null,{"$f":"INDEX(Wheel_Tire_Data!$P$102:$P$134,MATCH('Wheels Calculator'!D65/6/0.82,Wheel_Tire_Data!$Q$102:$Q$134,-1))","v":133},null,null,null,{"$f":"L36*1","v":0}]
[]
[null,"Choose a rear dual ballast package -OR- build a custom package with the options to the right ",null,"Rear Wheel Weights"]
[null,null,null,"Inside Drive:",null,"Outside Drive:",null,"Outside Dual/Triple:",null,"Configuration "]
[null,1,null,"Not Included",null,"Not Included",null,"Not Included",null,{"$f":"_xlfn.IFNA(_xlfn.IFS(D63>20000,'Weight Variables - Wheels'!T16,AND(AND(H31<>Wheel_Tire_Data!M102,H31<>\"Not Included\",H31<>\"NOT AVAILABLE\"),OR(F40<>\"Not Included\",$B$43='Weight Variables - Wheels'!AD10,$B$43='Weight Variables - Wheels'!AD11,$B$43='Weight Variables - Wheels'!AD12,$B$43='Weight Variables - Wheels'!AD13)),'Weight Variables - Wheels'!T10,AND(OR(H31=0,H31=\"Not Included\",H31=\"NOT AVAILABLE\"),OR(H40<>\"Not Included\",$B$43='Weight Variables - Wheels'!AD6,$B$43='Weight Variables - Wheels'!AD7,$B$43='Weight Variables - Wheels'!AD8,$B$43='Weight Variables - Wheels'!AD9)),'Weight Variables - Wheels'!T11,AND(OR(RIGHT(F31,2)=\"30\",RIGHT(F31,2)=\"28\",RIGHT(F31,2)=\"32\",RIGHT(F31,2)=\"34\",RIGHT(F31,2)=\"38\"),RIGHT('Wheels Calculator'!J9,6)=\"Taper)\",OR(F40='Weight Variables - Wheels'!R5,F40='Weight Variables - Wheels'!R6,B43='Weight Variables - Wheels'!AD10,B43='Weight Variables - Wheels'!AD11,B43='Weight Variables - Wheels'!AD12,B43='Weight Variables - Wheels'!AD13)),'Weight Variables - Wheels'!T12,AND(RIGHT('Wheels Calculator'!J9,6)=\"Taper)\",OR(F40='Weight Variables - Wheels'!R5,F40='Weight Variables - Wheels'!R6,B43='Weight Variables - Wheels'!AD10,B43='Weight Variables - Wheels'!AD11,B43='Weight Variables - Wheels'!AD12,B43='Weight Variables - Wheels'!AD13)),'Weight Variables - Wheels'!T13,AND(OR(RIGHT(F31,2)=\"30\",RIGHT(F31,2)=\"28\",RIGHT(F31,2)=\"32\",RIGHT(F31,2)=\"34\",RIGHT(F31,2)=\"38\"),OR(F40='Weight Variables - Wheels'!R5,F40='Weight Variables - Wheels'!R6,H40='Weight Variables - Wheels'!S5,'Wheels Calculator'!H40='Weight Variables - Wheels'!S6,'Wheels Calculator'!H40='Weight Variables - Wheels'!S7,B43='Weight Variables - Wheels'!AD6, B43='Weight Variables - Wheels'!AD7, B43='Weight Variables - Wheels'!AD8, B43='Weight Variables - Wheels'!AD9, B43='Weight Variables - Wheels'!AD10,B43='Weight Variables - Wheels'!AD11,B43='Weight Variables - Wheels'!AD12,B43='Weight Variables - Wheels'!AD13)),'Weight Variables - Wheels'!T14,AND(B43<>\"None\",OR(D41<>0,F41<>0,H41<>0,D46<>'Weight Variables - Wheels'!P5)),'Weight Variables - Wheels'!T15,AND(AND(J31<>Wheel_Tire_Data!M102,J31<>\"Not Included\",J31<>\"NOT AVAILABLE\"),OR(H40<>\"Not Included\",B43='Weight Variables - Wheels'!AD6, B43='Weight Variables - Wheels'!AD7, B43='Weight Variables - Wheels'!AD8,B43='Weight Variables - Wheels'!AD9, B43='Weight Variables - Wheels'!AD10)),'Weight Variables - Wheels'!T17), \"GOOD\")","v":"GOOD"}]
["(kg)",{"$f":"INDEX('Weight Variables - Wheels'!AD28:AD37,MATCH(B43,'Weight Variables - Wheels'!AD4:AD13,0))","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!Q28:Q32, MATCH(D40,'Weight Variables - Wheels'!Q4:Q8,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX(kg_rearW2, MATCH(F40,rearW2,0)),0)","v":0},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - Wheels'!R28:R34, MATCH('Wheels Calculator'!H40,'Weight Variables - Wheels'!R4:R10, 0)),0)","v":0},null,{"$f":"TEXT(D57,\"yymmdd\")","v":"230123"}]
["(mm)",{"$f":"INDEX('Weight Variables - Wheels'!AD59:AD68,MATCH(B43,'Weight Variables - Wheels'!AD4:AD13,0))","v":0},null,"Not Included",null,"None",null,"None",null,0]
[null,"None"]
[null,null,null,"Front Ballast",null,null,null,"Other Ballast"]
[null,null,null," Front Suitcase Weights:",null,null,null,"Front Mono Weight:",null," Additional Ballast (kg)"]
[null,null,null,"Front Weight Support, No Weights",null,null,null,"   ",null,"Expand Rows, Enter Below"]
[null,"(kg)",null,{"$f":"_xlfn.IFNA(INDEX(kg_SuitcaseWeights, MATCH(D46,SuitcaseWeights,0)),0)","v":191.64},null,null,null,{"$f":"_xlfn.IFNA(INDEX(kg_PickUpWeights, MATCH(H46,PickUpWeights,0)),0)","v":0}]
[null,"(mm)",null,{"$f":"_xlfn.IFNA(INDEX(mm_SuitcaseWeights, MATCH(D46,SuitcaseWeights,0)),0)","v":-4496.1000000000004},null,null,null,{"$f":"_xlfn.IFNA(INDEX(mm_PickUpWeights, MATCH(H46,PickUpWeights,0)),0)","v":0},null,0]
[null,null,null,null,null,null,null,null,null,"Input wieght (kg), and distance from rear axle (mm). Forward is negative."]
[]
[]
[]
[]
[null,null,null,null,null,"Configuration Summary:"]
[]
[null,"Analysis:",null,{"$f":"IF(H6=\"\",\"Not specified\",H6)","v":"Application"},null,"Model:",null,{"$f":"B9","v":"8R 370"}]
[null,"Date Completed:",null,{"$f":"TODAY()","v":"2023-01-23"},null,"Emission Levels: ",null,{"$f":"D9","v":"Final Tier 4/ Stage 5"}]
[null,"Performed by:",null,{"$f":"IF(D6=\"\",\"Not specified\",D6)","v":"Customer"},null,"Transmission:",null,{"$f":"F9","v":"e23"}]
[null,null,null,null,null,"Front Axle:",null,{"$f":"H9","v":"1300 MFWD"}]
[null,null,null,null,null,"Rear Axle:",null,{"$f":"J9","v":"120mm x 3012mm (Double Taper)"}]
[null,null,null,null,null,"Front Fenders:",null,{"$f":"B15","v":"500mm (19.7in)"}]
[null,null,null,null,null,"Rear Fenders:",null,{"$f":"D15","v":"2.55m"}]
[null,"Total Weight (kg)",null,{"$f":"SUM(F10,H10,J10,B16,D16,F16,H16,J16,B22,D22,F22,H22,J22,B34,D34,F34,H34,J34,D41,F41,H41,D47,H47,J47,D10,B41,B11)","v":12603.759273},null,"Front PTO:",null,{"$f":"F15","v":"Not Included"}]
[null,"Front Axle Weight (kg)",null,{"$f":"IF(H9=\"1300 MFWD\",(D63*-D68)/-H11,(D63*-D68)/-H11)","v":5685.4423695096384},null,"Trailer Brakes:",null,{"$f":"H15","v":"Dual line Air"}]
[null,"Rear Axle Weight (kg)",null,{"$f":"D63-D64","v":6918.3169034903613},null,"Fuel Level:",null,{"$f":"J15","v":"Half "}]
[null,"Front Split",null,{"$f":"D64/D63","v":0.45109099962652377},null,"Front Hitch (3 point):",null,{"$f":"B21","v":"Not Included"}]
[null,"Rear Split",null,{"$f":"D65/D63","v":0.54890900037347623},null,{"$f":"D20","v":" Rear Hitch:"},null,{"$f":"D21","v":"CAT 4 Ball Ends w/ Sway Block"}]
[null,"Dist. from Rear Axle forward to C.G. (mm)",null,{"$f":"SUM(B11*B12,D10*D11,F10*F11,H10*H11,J10*J11,B16*B17,D16*D17,F16*F17,H16*H17,J17*J16,B22*B23,D22*D23,F22*F23,H22*H23,J22*J23,B34*B35,D34*D35,D47*D48,H47*H48,J47*J48)/SUM(F10,H10,J10,B16,D16,F16,H16,J16,B22,D22,F22,H22,J22,B34,D34,F34,H34,J34,D41,F41,H41,D47,H47,J47,D10,B41,B11)","v":-1375.8275488608977},null,{"$f":"F20","v":" Drawbar:"},null,{"$f":"F21","v":"Cat 4"}]
[null,null,null,null,null,{"$f":"H20","v":"3 in 1 Rails Option:"},null,{"$f":"H21","v":"Not Included"}]
[null,"Kg / Engine Power (ps)",null,{"$f":"D63/B10","v":34.064214251351352},null,{"$f":"J20","v":"# of SCVs:"},null,{"$f":"J21","v":5}]
[null,null,null,null,null,"Front Wheel  - Single:",null,{"$f":"B31","v":"420/85R34"}]
[null,null,null,null,null,"Front Wheel - Dual:",null,{"$f":"D31","v":"Not Included"}]
[null,null,null,null,null,"Rear Wheel - Single:",null,{"$f":"F31","v":"480/80R50"}]
[null,"Total Weight (lb)",null,{"$f":"D63*2.20462","v":27786.499768441256},null,"Rear Wheel - Dual:",null,{"$f":"H31","v":"480/80R50"}]
[null,"Front Axle Weight (lb)",null,{"$f":"D64*2.20462","v":12534.239956668338},null,"Rear Wheel - Triple:",null,{"$f":"J31","v":0}]
[null,"Rear Axle Weight (lb)",null,{"$f":"D65*2.20462","v":15252.259811772919},null,"Inside Drive Rear Wheel Weights:",null,{"$f":"IF(AND(B43=\"964 kg\",J40=\"GOOD\"),\"2x205 kg\",IF(OR(B43=\"2450 kg\",B43=\"3795 kg\",B43=\"5409 kg\",B43=\"3723 kg\",B43=\"4463 kg\",B43=\"2623 kg\",B43=\"3363 kg\"),\"625 kg\",D40))","v":"Not Included"}]
[null,"lb / Engine Power (ps)",null,{"$f":"D74/B10","v":75.098648022814203},null,"Outside Drive Rear Wheel Weights:",null,{"$f":"IF(OR(B43=\"1940 kg\",B43=\"4463 kg\",B43=\"3363 kg\"),'Weight Variables - Wheels'!R6,IF(OR(B43=\"2450 kg\",B43=\"3723 kg\",B43=\"2623 kg\"),'Weight Variables - Wheels'!R5,IF(OR(B43=\"3795 kg\",B43=\"5409 kg\"),'Weight Variables - Wheels'!S7,F40)))","v":"Not Included"}]
[null,null,null,null,null,"Outside dual/triple Rear Wheel Weights:",null,{"$f":"H40","v":"Not Included"}]
[null,null,null,null,null,{"$f":"D45","v":" Front Suitcase Weights:"},null,{"$f":"D46","v":"Front Weight Support, No Weights"}]
[null,null,null,null,null,"Pick-up (Monster) Weights:",null,{"$f":"H46","v":"   "}]
[null,null,null,null,null,"Additional Ballast (kg):",null,{"$f":"J47","v":0}]

{"sheet":"Wheel_Tire_Data","index":1,"n_rows":134,"n_cols":43,"rows_kept":134,"cut":false,"hidden":true,"merged":[[100,27,100,29],[2,32,2,33],[2,34,2,35],[2,36,2,38],[0,1,1,4],[100,1,100,4],[100,9,100,10],[2,7,2,8],[2,9,2,10],[2,11,2,13],[2,14,2,16],[2,17,2,19],[100,33,100,34],[0,8,0,23],[0,27,0,42]]}
[null,"Do not add rows above or below. To input new tires replace \"x\" in lower rows",null,null,null,null,"No R2 Tread included",null,"Rear",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Front"]
[]
[null,null,null,null,null,null,null,"Tire",null,"Single Wheel ",null,"Dual/Dual Wheel",null,null,"Dual/Trip Wheel",null,null,"Triple Wheel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tire",null,"Single Wheel ",null,"Dual/Dual Wheel"]
[null,null,"Tire Size","Section width","Brand","Group","Load Rating","PN","Mass (kg)","PN","Weight","Size","PN","Weight","Size","PN","Weight","Size","PN","Weight","Single Mass","Dual/D Mass","Dual/T mass","Triple Mass",null,null,null,"Tire Size","Section width","Brand","Group","Load Rating","PN","Mass (kg)","PN","Weight","Size","PN","Weight","Single Mass","Dual/D Mass","Dual/T mass","Triple Mass"]
[null,"Rear","320/105R54",{"$f":"MID(C5,FIND(\"/\",C5)-3,3)","v":"320"},"Goodyear","Group 48",163,"R345492",155,"RE564283",81,{"$f":"C5","v":"320/105R54"},"RE564284",145,{"$f":"C5","v":"320/105R54"},"RE564284",145,{"$f":"C5","v":"320/105R54"},"RE564284",145,{"$f":"(2*I5)+(2*K5)","v":472},{"$f":"IFERROR((2*N5)+(2*I5)+IF(D5>800,$D$103,($D$103+$D$104)),\"\")","v":747},{"$f":"IFERROR((2*I5)+(2*Q5)+IF(D5>800,$D$103,($D$103+$D$104)),\"\")","v":747},{"$f":"IFERROR((2*I5)+(2*T5),\"\")","v":600},null,null,null,"320/80R42",{"$f":"MID(AB5,FIND(\"/\",AB5)-3,3)","v":"320"},"Goodyear","Group 43",141,"R333095",93,"RE558176",139,{"$f":"AB5","v":"320/80R42"},"RE558178",141.6,{"$f":"IFERROR((AJ5*2)+(AH5*2),\"\")","v":464},{"$f":"IFERROR(((AH5*2)+(AM5*2))+$AC$108,\"\")","v":469.2}]
[null,"Rear","IF710/70R42","710","Michelin","Group 48",179,"R248946",348,"RE283141",175.05,{"$f":"C6","v":"IF710/70R42"},"RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1046.0999999999999,1371.72,"","",null,null,null,"IF320/80R42",{"$f":"MID(AB6,FIND(\"/\",AB6)-3,3)","v":"320"},"Goodyear","Group 43",149,"R538505",100,"RE558176",144,"IF320/80R42","RE558178",141.6,{"$f":"IFERROR((AJ6*2)+(AH6*2),\"\")","v":488},{"$f":"IFERROR(((AH6*2)+(AM6*2))+$AC$108,\"\")","v":483.2}]
[null,"Rear","320/90R54","320","Firestone","Group 47",149,"R171126",140,"RE161991",190,{"$f":"C7","v":"320/90R54"},"RE211636",254.77,{"$f":"C7","v":"320/90R54"},"RE211636",254.77,{"$f":"C7","v":"320/90R54"},"RE211636",254.77,660,936.54,936.54,789.54,null,null,null,"380/80R38",{"$f":"MID(AB7,FIND(\"/\",AB7)-3,3)","v":"380"},"Mitas","Group 43",142,"R333095",96,"RE589286",105.36,"380/80R38","RE589284",111,{"$f":"IFERROR((AJ7*2)+(AH7*2),\"\")","v":402.72},{"$f":"IFERROR(((AH7*2)+(AM7*2))+$AC$108,\"\")","v":414}]
[null,"Rear","320/90R54","320","Goodyear","Group 47",149,"R171125",109,"RE161991",190,{"$f":"C8","v":"320/90R54"},"RE211636",254.77,{"$f":"C8","v":"320/90R54"},{"$f":"M8","v":"RE211636"},254.77,{"$f":"C8","v":"320/90R54"},"RE211636",254.77,598,874.54,874.54,727.54,null,null,null,"380/80R38","380","Firestone","Group 43",142,"R186620",121,"RE589286",105.36,"380/80R38","RE589284",111,452.72,{"$f":"IFERROR(((AH8*2)+(AM8*2))+$AC$108,\"\")","v":464}]
[null,"Rear","380/90R50","380","Firestone","Group 47",151,"R150849",153,"RE172186",129,"380/90R50","RE172939",257.39999999999998,"380/90R50","RE172939",257.39999999999998,"380/90R50","RE172939",257.39999999999998,564,967.8,967.8,820.8,null,null,null,"IF380/80R38","380","Firestone","Group 43",149,"R325308",139,"RE589286",105.36,"IF380/80R38","RE589284",111,488.72,500]
[null,"Rear","380/90R50","380","Goodyear","Group 47",151,"R566170",153,"RE172186",129,"380/90R50","RE172939",257.39999999999998,"380/90R50","RE172939",257.39999999999998,"380/90R50","RE172939",257.39999999999998,564,967.8,967.8,820.8,null,null,null,"380/80R38","380","Goodyear","Group 43",142,"R171118",98,"RE589286",105.36,"380/80R38","RE589284",111,406.72,418]
[null,"Rear","380/90R54","380","Firestone","Group 48",152,"R542548",165,"RE223670",201.5,{"$f":"C11","v":"380/90R54"},"RE211235",252.7,"Not Available","NA","NA","Not Available","NA","NA",733,982.4,"","",null,null,null,"380/80R38","380","Michelin","Group 43",142,"L220846",95,"RE589286",105.36,"380/80R38","RE589284",111,400.72,412]
[null,"Rear","380/90R54","380","Goodyear","Group 48",152,"R223672",165,"RE223670",201.5,"380/90R54","RE211235",252.7,"Not Available","NA","NA","Not Available","NA","NA",733,982.4,"","",null,null,null,"IF380/80R38","380","Goodyear","Group 43",149,"R569945",113,"RE589286",105.36,"IF380/80R38","RE589284",111,436.72,448]
[null,"Rear","480/80R46","480","Mitas","Group 47",158,"R554863",178,"RE175533",122.23,"480/80R46","RE214650",167.65,{"$f":"C13","v":"480/80R46"},"RE167955",197.74,{"$f":"C13","v":"480/80R46"},"RE214650",167.65,600.46,838.3,898.48,691.3,null,null,null,"380/80R38","380","Trelleborg","Group 43",142,"R569958",117,"RE589286",105.36,"380/80R38","RE589284",111,444.72,456]
[null,"Rear","480/80R46","480","Goodyear","Group 47",158,"R569949",196,"RE175533",122.23,"480/80R46","RE214650",167.65,{"$f":"C14","v":"480/80R46"},"RE167955",197.74,{"$f":"C14","v":"480/80R46"},"RE214650",167.65,636.46,874.3,934.48,727.3,null,null,null,"380/85R34","380","Mitas","Group 42",145,"R554852",95,"RE171021",112.71,"380/85R34","RE588915",107.5,415.41999999999996,405]
[null,"Rear","480/80R46","480","Trelleborg","Group 47",158,"R555810",185,"RE175533",122.23,"480/80R46","RE214650",167.65,"Not Available",null,null,"Not Available",null,null,614.46,852.3,517,370,null,null,null,"380/85R34","380","Firestone","Group 42",137,"R224601",112,"RE171021",112.71,"380/85R34","RE588915",107.5,449.41999999999996,439]
[null,"Rear","480/80R46","480","Michelin","Group 47",158,"R567426",190,"RE175533",122.23,"480/80R46","RE214650",167.65,{"$f":"C16","v":"480/80R46"},"RE167955",197.74,{"$f":"C16","v":"480/80R46"},"RE214650",167.65,624.46,862.3,922.48,715.3,null,null,null,"380/85R34","380","Firestone","Group 42",145,"R325307",114,"RE171021",112.71,"380/85R34","RE588915",107.5,453.41999999999996,443]
[null,"Rear","480/80R46","480","Firestone","Group 47",158,"L224788",214,"RE175533",122.23,"480/80R46","RE214650",167.65,"480/80R46","RE167955",197.74,"480/80R46","RE214650",167.65,672.46,910.3,970.48,763.3,null,null,null,"380/85R34","380","Goodyear","Group 42",137,"R173357",92,"RE171021",112.71,"380/85R34","RE588915",107.5,409.41999999999996,399]
[null,"Rear","480/80R50","480","Mitas","Group 48",159,"R333091",185,"RE269701",143,"480/80R50","RE248310",181.24,"480/80R50","RE173099",212.5,"480/80R50","RE248310",181.24,656,879.48,942,732.48,null,null,null,"VF420/85R34","420","Michelin","Group 43",154,"R538498",125,"RE588914",105.75,"VF420/85R34","RE588915",107.5,461.5,465]
[null,"Rear","480/80R50","480","Firestone","Group 48",159,"R166191",245,"RE269701",143,"480/80R50","RE248310",181.24,"480/80R50","RE173099",212.5,"480/80R50","RE248310",181.24,776,999.48,1062,852.48,null,null,null,"420/85R34","420","Mitas","Group 43",147,"R333093",108,"RE588914",105.75,"420/85R34","RE588915",107.5,427.5,431]
[null,"Rear","480/80R50","480","Michelin","Group 48",159,"R563549",200,"RE269701",143,"480/80R50","RE248310",181.24,"480/80R50","RE173099",212.5,"480/80R50","RE248310",181.24,686,909.48,972,762.48,null,null,null,"420/85R34","420","Firestone","Group 43",147,"R166192",138,"RE588914",105.75,"420/85R34","RE588915",107.5,487.5,491]
[null,"Rear","480/80R50","480","Goodyear","Group 48",159,"R569957",215,"RE269701",143,"480/80R50","RE248310",181.24,"480/80R50","RE173099",212.5,"480/80R50","RE248310",181.24,716,939.48,1002,792.48,null,null,null,"IF420/85R34","420","Firestone","Group 43",152,"R318666",140,"RE588914",105.75,"IF420/85R34","RE588915",107.5,491.5,495]
[null,"Rear","480/80R50","480","Trelleborg","Group 48",159,"R569960",201,"RE269701",143,"480/80R50","RE248310",181.24,"480/80R50","RE173099",212.5,"480/80R50","RE248310",181.24,688,911.48,974,764.48,null,null,null,"420/85R34","420","Michelin","Group 43",147,"L204354",108,"RE588914",105.75,"420/85R34","RE588915",107.5,427.5,431]
[null,"Rear","480/95R50","480","Michelin","Group 49",164,"R552963",230,"RE339637",147.82,"480/95R50","RE339639",183.3,"Not Available","NA","NA","Not Available","NA","NA",755.64,973.6,"","",null,null,null,"420/85R34","420","Michelin","Group 43",147,"R563557",110,"RE588914",105.75,"420/85R34","RE588915",107.5,431.5,435]
[null,"Rear","480/95R50","480","Mitas","Group 49",164,"R542354",279,"RE339637",147.82,"480/95R50","RE339639",183.3,"Not Available","NA","NA","Not Available","NA","NA",853.64,1071.5999999999999,"","",null,null,null,"420/85R34","420","Goodyear","Group 43",147,"R569944",124,"RE588914",105.75,"420/85R34","RE588915",107.5,459.5,463]
[null,"Rear","480/95R50","480","Goodyear","Group 49",164,"R304876",249,"RE339637",147.82,"480/95R50","RE339639",183.3,"Not Available","NA","NA","Not Available","NA","NA",793.64,1011.6,"","",null,null,null,"420/85R34","420","Trelleborg","Group 43",147,"R569959",133,"RE588914",105.75,"420/85R34","RE588915",107.5,477.5,481]
[null,"Rear","IF480/80R50","480","Firestone","Group 48",166,"R318687",248,"RE339637",148,"IF480/80R50","RE339639",183.3,{"$f":"C26","v":"IF480/80R50"},"RE339639",183.3,{"$f":"C26","v":"IF480/80R50"},"RE339639",183.3,792,1009.6,1009.6,862.6,null,null,null,"420/85R38","420","Goodyear","Group 44",149,"R304877",155,"RE309225",125.51,"Not Available","NA","NA",561.02,""]
[null,"Rear","IF480/95R50","480","Firestone","Group 49",154,"R571092",258.5,"RE339637",147.82,"IF480/95R50","RE339639",183.3,"Not Available","NA","NA","Not Available","NA","NA",{"$f":"(2*I27)+(2*K27)","v":812.64},1030.5999999999999,"","",null,null,null,"420/90R30","420","Mitas","Group 42",147,"R554869",109,"RE156708",87.47,"Not Available","NA","NA",392.94,""]
[null,"Rear","VF480/80R50","480","Michelin","Group 48",166,"R538497",205,"RE339637",147.82,"VF480/80R50","RE339639",183.3,{"$f":"C28","v":"VF480/80R50"},"RE339639",183.3,{"$f":"C28","v":"VF480/80R50"},"RE339639",183.3,705.64,923.6,923.6,776.6,null,null,null,"420/90R30",{"$f":"MID(AB28,FIND(\"/\",AB28)-3,3)","v":"420"},"Goodyear","Group 42",142,"R173356",102,"RE156708",87.47,"Not Available","NA","NA",378.94,""]
[null,"Rear","520/85R42","520","Mitas","Group 47",162,"L216048",207,"RE175533",122.23,"520/85R42","RE214649",167.7,"520/85R42","RE214649",167.6,"520/85R42","RE160189",214,658.46,896.4,896.2,842,null,null,null,"420/90R30",{"$f":"MID(AB29,FIND(\"/\",AB29)-3,3)","v":"420"},"Michelin","Group 42",147,"R567425",115.5,"RE156708",87.47,"Not Available","NA","NA",405.94,""]
[null,"Rear","520/85R42","520","Goodyear","Group 47",157,"R127989",196.4,"RE175533",122.23,"520/85R42","RE214649",167.7,"520/85R42","RE214649",167.6,"520/85R42","RE160189",214,637.26,875.2,875,820.8,null,null,{"$f":"IFERROR(INDEX($T$15:$T$36,SMALL(IF(#REF!=#REF!,ROW($T$15:$T$36)),ROW(#REF!))-38,1),\"\")","v":""},"420/90R30",{"$f":"MID(AB30,FIND(\"/\",AB30)-3,3)","v":"420"},"Firestone","Group 42",145,"L224790",136,"RE156708",87.47,"Not Available","NA","NA",446.94,""]
[null,"Rear","520/85R42","520","Firestone","Group 47",157,"R571093",212,"RE175533",122.23,"520/85R42","RE214649",167.7,"520/85R42","RE214649",167.6,"520/85R42","RE160189",214,668.46,906.4,906.2,852,null,null,null,"420/90R30",{"$f":"MID(AB31,FIND(\"/\",AB31)-3,3)","v":"420"},"Trelleborg","Group 42",147,"R555809",115,"RE156708",87.47,"Not Available","NA","NA",404.94,""]
[null,"Rear","520/85R46","520","Mitas","Group 48",158,"R310935",212,"RE175533",122.23,"520/85R46","RE214649",167.7,"520/85R46","RE273209",168,"520/85R46","RE160189",214,668.46,906.4,907,852,null,null,null,"480/70R30",{"$f":"MID(AB32,FIND(\"/\",AB32)-3,3)","v":"480"},"Mitas","Group 42",152,"R554870",120,"RE156708",87.47,"Not Available","NA","NA",414.94,""]
[null,"Rear","520/85R46","520","Firestone","Group 48",158,"R160187",268,"RE175533",122.23,"520/85R46","RE214649",167.7,"520/85R46","RE273209",168,"520/85R46","RE160189",214,780.46,1018.4,1019,964,null,null,null,"480/70R30","480","Goodyear","Group 42",152,"R570508",147,"RE156708",87.47,"Not Available","NA","NA",468.94,""]
[null,"Rear","520/85R46","520","Goodyear","Group 48",158,"R569954",210,"RE175533",122.23,"520/85R46","RE214649",167.7,"520/85R46","RE273209",168,"520/85R46","RE160189",214,664.46,902.4,903,848,null,null,null,"480/70R30","480","Firestone","Group 42",152,"L224787",143,"RE156708",87.47,"Not Available","NA","NA",460.94,""]
[null,"Rear","620/70R42","620","Michelin","Group 47",160,"R211252",245,"RE175487",139,"620/70R42","RE557607",227.11,"Not Available","NA","NA","Not Available","NA","NA",768,1091.22,"","",null,null,null,"480/70R34","480","Michelin","Group 43",143,"R211247",126,"RE588914",105.75,{"$f":"AB35","v":"480/70R34"},"RE588915",107.5,463.5,467]
[null,"Rear","620/70R42","620","Firestone","Group 47",160,"R154264",285,"RE175487",139,"620/70R42","RE557607",227.11,"Not Available","NA","NA","Not Available","NA","NA",848,1171.22,"","",null,null,null,"480/70R34","480","Mitas","Group 43",143,"R310936",117,"RE588914",105.75,{"$f":"AB36","v":"480/70R34"},"RE588915",107.5,445.5,449]
[null,"Rear","620/70R46",{"$f":"MID(C37,FIND(\"/\",C37)-3,3)","v":"620"},"Goodyear","Group 48",167,"R171114",252,"RE174387",139,"620/70R46","RE174388",252.64,"Not Available","NA","NA","Not Available","NA","NA",782,{"$f":"IFERROR((2*N37)+(2*I37)+IF(D37>800,$D$103,($D$103+$D$104)),\"\")","v":1156.28},{"$f":"IFERROR((2*I37)+(2*Q37)+IF(D37>800,$D$103,($D$103+$D$104)),\"\")","v":""},{"$f":"IFERROR((2*I37)+(2*T37),\"\")","v":""},null,null,null,"480/70R34","480","Firestone","Group 43",155,"R186696",166,"RE588914",105.75,{"$f":"AB37","v":"480/70R34"},"RE588915",107.5,543.5,547]
[null,"Rear","620/70R46","620","Firestone","Group 48",167,"R566173",252,"RE174387",139,"620/70R46","RE174388",252.64,"Not Available","NA","NA","Not Available","NA","NA",782,1156.28,"","",null,null,null,"480/70R34",{"$f":"MID(AB38,FIND(\"/\",AB38)-3,3)","v":"480"},"Goodyear","Group 43",155,"R171120",117,"RE588914",105.75,{"$f":"AB38","v":"480/70R34"},"RE588915",107.5,445.5,449]
[null,"Rear","650/65R42","650","Michelin","Group 47",158,"R271828",223,"RE175487",139,"Not Available",null,null,"Not Available","NA","NA","Not Available","NA","NA",724,593,"","",null,null,null,"480/70R34",{"$f":"MID(AB39,FIND(\"/\",AB39)-3,3)","v":"480"},"Trelleborg","Group 43",155,"R567049",132,"RE588914",105.75,{"$f":"AB39","v":"480/70R34"},"RE588915",107.5,475.5,479]
[null,"Rear","650/85R38","650","Michelin","Group 48",173,"R211250",341,"RE174770",135,{"$f":"C40","v":"650/85R38"},"RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",952,1229,"","",null,null,null,"540/65R34",{"$f":"MID(AB40,FIND(\"/\",AB40)-3,3)","v":"540"},"Michelin","Group 43",145,"R211246",115,"RE196210",118.7,"Not Available","NA","NA",467.4,""]
[null,"Rear","650/85R38","650","Trelleborg","Group 48",173,"R244256",340,"RE174770",135,"650/85R38","RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",950,1227,"","",null,null,null,"600/65R28",{"$f":"MID(AB41,FIND(\"/\",AB41)-3,3)","v":"600"},"Michelin","Group 42",147,"R151661",164,"RE219302",88,"Not Available","NA","NA",504,""]
[null,"Rear","650/85R38","650","Mitas","Group 48",173,"R310951",331,"RE174770",135,"650/85R38","RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",932,1209,"","",null,null,null,"600/65R28",{"$f":"MID(AB42,FIND(\"/\",AB42)-3,3)","v":"600"},"Goodyear","Group 42",147,"R569953",169,"RE219302",88,"Not Available","NA","NA",514,""]
[null,"Rear","650/85R38","650","Goodyear","Group 48",173,"R227825",322,"RE174770",135,"650/85R38","RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",914,1191,"","",null,null,null,"600/65R28",{"$f":"MID(AB43,FIND(\"/\",AB43)-3,3)","v":"600"},"Firestone","Group 42",154,"L224785",180,"RE219302",88,"Not Available","NA","NA",536,""]
[null,"Rear","IF650/85R38","650","Michelin","Group 48",179,"R234776",341,"RE249816",149.57,"IF650/85R38","RE275968",226.24,"Not Available","NA","NA","Not Available","NA","NA",981.14,1281.48,"","",null,null,null,"600/65R34",{"$f":"MID(AB44,FIND(\"/\",AB44)-3,3)","v":"600"},"Trelleborg","Group 44",157,"R345486",173,"RE556739",144,"Not Available","NA","NA",634,""]
[null,"Rear","710/70R38","710","Michelin","Group 47",171,"R151662",314,"RE174770",135,"710/70R38","RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",898,1175,"","",null,null,null,"600/70R30","600","Michelin","Group 43",152,"R211245",185,"RE196207",109,"Not Available","NA","NA",588,""]
[null,"Rear","710/70R38","710","Firestone","Group 47",166,"R131230",310,"RE174770",135,"710/70R38","RE557609",200,"Not Available","NA","NA","Not Available","NA","NA",890,1167,"","",null,null,null,"IF600/70R30","600","Michelin","Group 43",159,"R248948",185,"RE196207",109,"Not Available","NA","NA",588,""]
[null,"Rear","710/70R38","710","Goodyear","Group 47",166,"R227823",305,"RE174770",135,"Not Available",null,null,"Not Available","NA","NA","Not Available","NA","NA",880,757,"","",null,null,null,"600/70R30","600","Trelleborg","Group 43",158,"R244049",182,"RE196207",109,"Not Available","NA","NA",582,""]
[null,"Rear","710/70R38","710","Mitas","Group 47",169,"R551512",306,"RE557689",133.71,"Not Available",null,null,"Not Available","NA","NA","Not Available","NA","NA",879.42000000000007,759,"","",null,null,null,"600/70R30","600","Mitas","Group 43",152,"R310950",172,"RE196207",109,"Not Available","NA","NA",562,""]
[null,"Rear","710/70R42","710","Michelin","Group 48",173,"R211249",353,"RE175488",152,{"$f":"C49","v":"710/70R42"},"RE557602",240,"Not Available","NA","NA","Not Available","NA","NA",1010,1333,"","",null,null,null,"600/70R30","600","Firestone","Group 43",152,"R186623",194,"RE196207",109,"Not Available","NA","NA",606,""]
[null,"Rear","710/70R42","710","Trelleborg","Group 48",173,"R244050",317,"RE175488",152,"710/70R42","RE557602",240,"Not Available","NA","NA","Not Available","NA","NA",938,1261,"","",null,null,null,"IF600/70R30","600","Firestone","Group 43",159,"R318670",200,"RE196207",109,"Not Available","NA","NA",618,""]
[null,"Rear","710/70R42","710","Mitas","Group 48",173,"R310934",347,"RE175488",152,"710/70R42","RE557602",240,"Not Available","NA","NA","Not Available","NA","NA",998,1321,"","",null,null,null,"IF600/70R30","600","Trelleborg","Group 43",159,"R567050",183,"RE196207",109,"Not Available","NA","NA",584,""]
[null,"Rear","710/70R42","710","Goodyear","Group 48",173,"R569951",349,"RE175488",152,"710/70R42","RE557602",240,"Not Available","NA","NA","Not Available","NA","NA",1002,1325,"","",null,null,null,"600/70R30","600","Goodyear","Group 43",152,"R569946",205,"RE196207",109,"Not Available","NA","NA",628,""]
[null,"Rear","710/70R42","710","Firestone","Group 48",168,"L224786",331,"RE175488",152,"710/70R42","RE557602",240,"Not Available","NA","NA","Not Available","NA","NA",966,1289,"","",null,null,null,"IF620/75R30","620","Michelin","Group 44",164,"R301870",214,"RE320695",125.7,"Not Available","x","x",679.4,""]
[null,"Rear","710/75R42","710","Trelleborg","Group 49",175,"R538211",360,"RE287485",175,"710/75R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1070,1395.72,"","",null,null,null,"IF650/60R34","650","Michelin","Group 44",165,"R345489",216,"RE345476",153.86000000000001,"Not Available","NA","NA",739.72,""]
[null,"Rear","710/75R42","710","Goodyear","Group 49",175,"R569948",366,"RE287485",175,"710/75R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1082,1407.72,"","",null,null,null,"650/60R34","650","Trelleborg","Group 44",159,"R345484",205,"RE556739",144,"Not Available","NA","NA",698,""]
[null,"Rear","IF710/70R42","710","Trelleborg","Group 48",179,"R567051",372.72727272727269,"RE283141",175.05,"IF710/70R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1095.5545454545454,1421.1745454545453,"","",null,null,null,"IF650/60R34","650","Trelleborg","Group 44",159,"R544207",205,"RE345476",153.86000000000001,"Not Available","NA","NA",717.72,{"$f":"IFERROR(((AH56*2)+(AM56*2))+$AC$108,\"\")","v":""}]
[null,"Rear","IF710/70R42","710","Firestone","Group 48",179,"R571094",339,"RE283141",175.05,"IF710/70R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1028.0999999999999,1353.72,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF710/75R42","710","Michelin","Group 49",176,"R322686",354,"RE287485",175,"IF710/75R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1058,1383.72,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF710/75R42","710","Trelleborg","Group 49",176,"R544208",385,"RE287485",175,"IF710/75R42","RE262592",264.36,"Not Available","NA","NA","Not Available","NA","NA",1120,1445.72,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","800/70R38","800","Michelin","Group 48",173,"R211248",363,"RE311098",153,"800/70R38","RE557605",215.5,"Not Available","NA","NA","Not Available","NA","NA",1032,1304,"","",null,null,null,"x",{"$f":"MID(AB60,FIND(\"/\",AB60)-3,3)","v":{"$error":"#VALUE!"}},"x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR((AJ60*2)+(AH60*2),\"\")","v":""},""]
[null,"Rear","800/70R38","800","Mitas","Group 48",173,"R540554",375,"RE311098",153,"800/70R38","RE557605",215.5,"Not Available","NA","NA","Not Available","NA","NA",1056,1328,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","800/70R38","800","Goodyear","Group 48",173,"R569947",408,"RE311098",153,"800/70R38","RE557605",215.5,"Not Available","NA","NA","Not Available","NA","NA",1122,1394,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","800/70R38","800","Trelleborg","Group 48",178,"R569961",332,"RE311098",153,"800/70R38","RE557605",215.5,"Not Available","NA","NA","Not Available","NA","NA",970,1242,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","800/70R38","800","Firestone","Group 48",173,"R571095",411,"RE311098",153,"800/70R38","RE557605",215.5,"Not Available","NA","NA","Not Available","NA","NA",1128,1400,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF800/70R38","800","Michelin","Group 48",179,"R248947",400,"RE267759",165.52,"IF800/70R38","RE267760",242,"Not Available","NA","NA","Not Available","NA","NA",1131.04,1431,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF800/70R38","800","Firestone","Group 48",179,"R571096",422,"RE267759",165.52,"IF800/70R38","RE267760",242,"Not Available","NA","NA","Not Available","NA","NA",1175.04,1475,"","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF900/60R42","900","Trelleborg","Group 49",180,"R544209",453,"RE586794",287.08999999999997,"Not Available","NA","NA","Not Available","NA","NA","Not Available","NA","NA",1480.1799999999998,"","","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"Rear","IF900/60R42","900","Michelin","Group 49",186,"R563361",475,"RE586794",287.08999999999997,"Not Available","NA","NA","Not Available","NA","NA","Not Available","NA","NA",1524.1799999999998,"","","",null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$f":"MID(C69,FIND(\"/\",C69)-3,3)","v":{"$error":"#VALUE!"}},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$f":"MID(AB69,FIND(\"/\",AB69)-3,3)","v":{"$error":"#VALUE!"}},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR((AJ70*2)+(AH70*2),\"\")","v":""},{"$f":"IFERROR(((AH70*2)+(AM70*2))+$AC$108,\"\")","v":""}]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[null,"x","x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",null,null,null,null,null,"x",{"$error":"#VALUE!"},"x","x","x","x","x","x","x","x","x","x","",""]
[]
[null,"Hubs",null,null,null,null,null,"Brand","Grp_R","By Brand",null,"Group","Dual","Triple",null,"load index","Weight capacity ",null,null,null,null,null,null,null,null,null,null,"Hubs",null,null,null,null,"Grp_F","By Brand",null,"By Group","Dual"]
[null,"Dual",null,null,null,null,null,"Firestone","Group 47",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(1:1))-4,1),\"\")","v":"320/90R54"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(1:1))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(1:1))-101,1),\"\")","v":"380/90R54"},null,null,null,186,9500,null,null,null,null,null,null,null,null,null,null,"Dual",null,null,null,"Firestone","Group 42",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(1:1))-4,1),\"\")","v":"380/80R38"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(1:1))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(1:1))-101,1),\"\")","v":""}]
[null,"Standard hub",null,147,null,null,null,"Goodyear","Group 48",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(2:2))-4,1),\"\")","v":"380/90R50"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(2:2))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(2:2))-101,1),\"\")","v":"480/80R50"},"Not Included","Not Included",null,179,7750,null,null,null,null,null,null,null,null,null,null,"1500/ILS <320hp","ETN21256",272,null,"Goodyear","Group 43",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(2:2))-4,1),\"\")","v":"IF380/80R38"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(2:2))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(2:2))-101,1),\"\")","v":""},"Not Included"]
[null,">800mm tire","ETN174189",109,null,null,null,"Mitas","Group 49",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(3:3))-4,1),\"\")","v":"380/90R54"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(3:3))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(3:3))-101,1),\"\")","v":"IF480/80R50"},{"$f":"INDEX($L$5:$L$73,MATCH('Wheels Calculator'!$B$27:$D$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$73&Wheel_Tire_Data!$C$5:$C$73,),0))","v":"480/80R50"},{"$f":"_xlfn.IFNA(INDEX($R$5:$R$73,MATCH('Wheels Calculator'!$B$27:$D$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$73&$C$5:$C$73,),0)),0)","v":"480/80R50"},null,176,7100,null,null,null,null,null,null,null,null,null,null,"ILS >320","ETN21255",362,null,"Mitas","Group 44",{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(3:3))-4,1),\"\")","v":"380/85R34"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(3:3))-4,1),\"\")","v":"Group 42"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(3:3))-101,1),\"\")","v":""},{"$f":"INDEX($AK$5:$AK$99,MATCH('Wheels Calculator'!$B$27:$D$27&'Wheels Calculator'!$B$31,INDEX(Wheel_Tire_Data!$AD$5:$AD$99&Wheel_Tire_Data!$AB$5:$AB$99,),0))","v":"420/85R34"}]
[null,null,null,null,null,null,null,"Trelleborg",null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(4:4))-4,1),\"\")","v":"480/80R46"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(4:4))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(4:4))-101,1),\"\")","v":"520/85R46"},null,null,null,175,6900,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Trelleborg",null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(4:4))-4,1),\"\")","v":"380/85R34"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(4:4))-4,1),\"\")","v":"Group 42"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(4:4))-101,1),\"\")","v":""}]
[null,"Triple",null,null,null,null,null,"Michelin",null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(5:5))-4,1),\"\")","v":"480/80R50"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(5:5))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(5:5))-101,1),\"\")","v":"620/70R46"},null,null,null,173,6500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Michelin",null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(5:5))-4,1),\"\")","v":"420/85R34"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(5:5))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(5:5))-101,1),\"\")","v":""}]
[null,"DT 300-419","ETN174297",279.39999999999998,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(6:6))-4,1),\"\")","v":"IF480/80R50"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(6:6))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(6:6))-101,1),\"\")","v":"710/70R42"},null,null,null,171,6150,null,null,null,null,null,null,null,null,null,null,"Chosen Axle",{"$f":"'Wheels Calculator'!H9","v":"1300 MFWD"},null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(6:6))-4,1),\"\")","v":"IF420/85R34"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(6:6))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(6:6))-101,1),\"\")","v":""}]
[null,"DT 420-519","ETN174203",384.7,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(7:7))-4,1),\"\")","v":"IF480/95R50"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(7:7))-4,1),\"\")","v":"Group 49"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(7:7))-101,1),\"\")","v":"IF710/70R42"},null,null,null,170,6000,null,null,null,null,null,null,null,null,null,null,"Extension weight",{"$f":"_xlfn.IFNA(_xlfn.IFS(OR($AC$107='Weight Variables - Wheels'!$E$5,$AC$107='Weight Variables - Wheels'!$E$6),Wheel_Tire_Data!$AD$103,Wheel_Tire_Data!$AC$107='Weight Variables - Wheels'!$E$7,Wheel_Tire_Data!$AD$104),0)","v":0},null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(7:7))-4,1),\"\")","v":"420/90R30"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(7:7))-4,1),\"\")","v":"Group 42"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(7:7))-101,1),\"\")","v":""}]
[null,"DF 300-419","NA",0,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(8:8))-4,1),\"\")","v":"520/85R42"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(8:8))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(8:8))-101,1),\"\")","v":"800/70R38"},null,null,null,169,5800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(8:8))-4,1),\"\")","v":"480/70R30"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(8:8))-4,1),\"\")","v":"Group 42"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(8:8))-101,1),\"\")","v":""}]
[null,"DF 420-519","ETN174205",269.39999999999998,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(9:9))-4,1),\"\")","v":"520/85R46"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(9:9))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(9:9))-101,1),\"\")","v":"IF800/70R38"},null,null,null,168,5600,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(9:9))-4,1),\"\")","v":"480/70R34"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(9:9))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(9:9))-101,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(10:10))-4,1),\"\")","v":"620/70R42"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(10:10))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(10:10))-100,1),\"\")","v":""},null,null,null,167,5450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(10:10))-4,1),\"\")","v":"600/65R28"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(10:10))-4,1),\"\")","v":"Group 42"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(10:10))-100,1),\"\")","v":""}]
[null,"Chosen Size",{"$f":"_xlfn.IFNA(INDEX(Wheel_Tire_Data!$C$5:$C$73,MATCH('Wheels Calculator'!$B$27:$D$27&'Wheels Calculator'!$F$31,INDEX(Wheel_Tire_Data!$E$5:$E$73&Wheel_Tire_Data!$C$5:$C$73,),0)),0)","v":"480/80R50"},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(11:11))-4,1),\"\")","v":"620/70R46"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(11:11))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(11:11))-100,1),\"\")","v":""},null,null,null,166,5300,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(11:11))-4,1),\"\")","v":"600/70R30"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(11:11))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(11:11))-100,1),\"\")","v":""}]
[null,"section Width",{"$f":"MID(C112,FIND(\"/\",C112)-3,3)","v":"480"},{"$f":"C113-0","v":480},null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(12:12))-4,1),\"\")","v":"710/70R38"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(12:12))-4,1),\"\")","v":"Group 47"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(12:12))-100,1),\"\")","v":""},null,null,null,165,5150,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(12:12))-4,1),\"\")","v":"IF600/70R30"},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(12:12))-4,1),\"\")","v":"Group 43"},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(12:12))-100,1),\"\")","v":""}]
[null,"Chosen Axle",{"$f":"'Wheels Calculator'!J9","v":"120mm x 3012mm (Double Taper)"},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(13:13))-4,1),\"\")","v":"710/70R42"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(13:13))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(13:13))-100,1),\"\")","v":""},null,null,null,164,5000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(13:13))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(13:13))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(13:13))-100,1),\"\")","v":""}]
[null,"Hub Weight",{"$f":"_xlfn.IFNA(_xlfn.IFS(AND(OR($C$114='Weight Variables - Wheels'!F4,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F5,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F6,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F8),Wheel_Tire_Data!$D$113>419,Wheel_Tire_Data!$D$113<519),Wheel_Tire_Data!$D$108,AND(OR($C$114='Weight Variables - Wheels'!F4,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F5,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F6,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F8),Wheel_Tire_Data!$D$113>300,Wheel_Tire_Data!$D$113<419),$D$107,AND(OR($C$114='Weight Variables - Wheels'!F7,Wheel_Tire_Data!$C$114='Weight Variables - Wheels'!F9),Wheel_Tire_Data!$D$113>419,Wheel_Tire_Data!$D$113<519),$D$110),0)","v":384.7},null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(14:14))-4,1),\"\")","v":"IF710/70R42"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(14:14))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(14:14))-100,1),\"\")","v":""},null,null,null,163,4875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(14:14))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(14:14))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(14:14))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(15:15))-4,1),\"\")","v":"800/70R38"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(15:15))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(15:15))-100,1),\"\")","v":""},null,null,null,162,4750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(15:15))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(15:15))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(15:15))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(16:16))-4,1),\"\")","v":"IF800/70R38"},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(16:16))-4,1),\"\")","v":"Group 48"},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(16:16))-100,1),\"\")","v":""},null,null,null,160,4500,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(16:16))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(16:16))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(16:16))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(17:17))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(17:17))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(17:17))-100,1),\"\")","v":""},null,null,null,159,4375,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(17:17))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(17:17))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(17:17))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(18:18))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(18:18))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(18:18))-100,1),\"\")","v":""},null,null,null,158,4250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(18:18))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(18:18))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(18:18))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(19:19))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(19:19))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(19:19))-100,1),\"\")","v":""},null,null,null,157,4125,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(19:19))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(19:19))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(19:19))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$C$5:$C$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(20:20))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$F$5:$F$99,SMALL(IF(Wheel_Tire_Data!$E$5:$E$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!C$5:C$99)),ROW(20:20))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($J$102:$J$121,SMALL(IF($K$102:$K$121='Wheels Calculator'!$F$29:$J$29,ROW(Wheel_Tire_Data!$J$102:$J$121)),ROW(20:20))-100,1),\"\")","v":""},null,null,null,155,3875,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(20:20))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(20:20))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(20:20))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,154,3750,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(21:21))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(21:21))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(21:21))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,3550,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(22:22))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(22:22))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(22:22))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,3450,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(23:23))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(23:23))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(23:23))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,3350,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(24:24))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(24:24))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(24:24))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,149,3250,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX(Wheel_Tire_Data!$AB$5:$AB$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW(Wheel_Tire_Data!AB$5:AB$99)),ROW(25:25))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AE$5:$AE$99,SMALL(IF(Wheel_Tire_Data!$AD$5:$AD$99='Wheels Calculator'!$B$27:$D$27,ROW($AE$5:$AE$99)),ROW(25:25))-4,1),\"\")","v":""},{"$f":"IFERROR(INDEX($AH$102:$AH$126,SMALL(IF($AI$102:$AI$126='Wheels Calculator'!$B$29:$D$29,ROW(Wheel_Tire_Data!$AH$102:$AH$126)),ROW(25:25))-100,1),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,147,3075]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,146,3000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,2900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,143,2725]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,142,2650]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,141,2575]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,137,2300]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,2060]

{"sheet":"Weight Variables - Wheels","index":2,"n_rows":138,"n_cols":43,"rows_kept":138,"cut":false,"hidden":true,"merged":[[24,29,25,29],[55,20,56,20],[55,21,56,21],[55,27,56,27],[55,28,56,28],[55,22,56,22],[55,23,56,23],[55,24,56,24],[55,25,56,25],[55,26,56,26],[55,0,56,0],[55,1,56,1],[55,3,56,3],[55,4,56,4],[55,5,56,5],[0,29,1,29],[24,24,25,24],[24,13,25,13],[24,28,25,28],[0,11,1,11],[0,26,1,26],[0,27,1,27],[0,28,1,28],[0,23,1,23],[0,25,1,25],[0,24,1,24],[0,13,1,13],[0,12,1,12],[0,20,1,20],[24,23,25,23],[24,25,25,25],[0,0,1,0],[24,1,25,1],[24,3,25,3],[24,8,24,10],[0,1,1,1],[0,3,1,3],[0,8,0,10],[0,4,1,4],[0,6,0,7],[24,6,24,7],[24,4,25,4],[0,5,1,5],[24,0,25,0],[24,5,25,5],[23,2,23,27],[24,21,25,21],[0,14,1,14],[24,26,25,26],[24,27,25,27],[24,11,25,11],[24,14,25,14],[24,15,25,15],[24,16,24,19],[24,20,25,20],[24,12,25,12],[24,22,25,22],[0,21,1,21],[0,22,1,22],[0,15,1,15],[0,16,0,19],[124,3,124,4],[105,5,105,6],[105,7,105,8],[0,2,1,2],[24,2,25,2],[55,2,56,2],[105,1,105,2],[54,2,54,27],[55,6,55,7],[55,8,55,10],[55,11,56,11],[55,12,56,12],[55,13,56,13],[55,14,56,14],[55,15,56,15],[55,16,55,19]]}
["Option #","Tractor Model","Emissions Level","Transmission","Front Axle","Rear Axle (diameter, 2438 or 3012 mm length)","Front Wheel Assemblies",null,"Rear Wheel Assemblies",null,null,"Front Fenders","Rear Fenders","Front PTO","Front Weight Support","Front Suitcase Weights (NA)","Rear Wheel Weights",null,null,null,"Pick-up (Monster) Weights ","Front Hitch (3 point)","Rear Hitch","Drawbar","Pickup / Wagon Hitch","Trailer Brakes","Air Trailer Brake, Single Line","Fuel Level (0.85 kg/L)","# of SCVs","Ballast Package"]
[null,null,null,null,null,null,"Single","Dual","Single","Dual","Triple",null,null,null,null,null,"Inside Drive","Outside Drive","Outside Dual/Triple","Configurations",null,null,null,null,null,null,null,null,null,null,72,205,625,530,970,"550+900","front support","suitcase weights"]
[null," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," "," ",null,null,null,null,null,null,null,null,null,null,"Rim Size","Duals","Singles","Double Flat"]
[1,"8R 230","Final Tier 4/ Stage 5","16 speed","1300 MFWD","110mm x 3012mm (Single Taper)","N/A","N/A","N/A","N/A","N/A","No Fenders","No Extensions","Not Included","Not Included","Front Hitch (No Front Weight Support)","Not Included","Not Included","Not Included","Not Included","Not Included","Not Included","  ","Not Included","Not Included","Not Included","Not Included","Empty","4 w/out Hitch","None"]
[2,"8R 250","Tier 3A/ Stage 3","e23","1500 MFWD","110mm x 3012mm (Double Taper)",null,null,null,null,null,"500mm (19.7in)","2.55m","Included","Included","Front Weight Support, No Weights","625 kg (1378 lb)","70kg (154 lb)+530kg(1169 lb)","70kg (154 lb)+530kg(1169 lb)","Not compatible with 60 inch treads","900 kg","Included","CAT 3, Quick Coupler","CAT 3","Wagon Hitch, Piton"," Dual line Air ","Included","23 GAL",4,"820kg (1808lb)","One Pair","One Pair","None",null,"None",null,"Included","None","Includes Front Weight Support with No Front Suitcase Weights, Two Pair 205 kg (452 lb.) Inside/Inner Rear Wheel Weights, and No Outside/Outer Dual Rear Wheel Weights."]
[3,"8R 280","Tier 2/ Stage 2","IVT ","ILS (</= 320 hp)","120mm x 2438mm (Double Taper)",null,null,null,null,null,"620mm (24.1in)","2.75m",null,null,"4 x 43kg (North America)","205 kg (452 lb)","70kg (154 lb)+900kg(1985 lb)","70kg (154 lb)+900kg(1985 lb) lb)","No compatible < 42 in rims","1150 kg",null,"CAT 3, Quick Coupler (Hydraulic)","CAT 4","Wagon Hitch, Ball","Dual line Air & Hydraulic",null,"Half ",5,"1940 kg (4277 lb) - For Duals","One Pair","None","One Pair",null,"None",null,"Included",4,"Includes Front Weight Support with No Front Suitcase Weights, No Inside/Inner Rear Wheel Weights and One Pair 70 kg (154 lb.) with One Pair 900 kg (1984 lb.) Outside/Outer Dual Rear Wheel Weights","X","X"]
[4,"8R 310",null,null,"ILS (>320 hp)","120mm x 2550mm (Double Flat)",null,null,null,null,null,"720mm (28.35in)",null,null,null,"8 x 43kg (North America)","2x205 kg (904 lb)","72kg (159 lb)+205kg(452 lb)","70kg (154 lb)+550kg (1213 lb)+900kg (1985 lb)","Requires Double Flat axle","1500 kg",null,"CAT 3, Hook w/ Sway Blocks","CAT 4 HD","Wagon Hitch, Pin","Dual Line Hydraulic",null,"Full ",6,"2450 kg (5401 lb) - For Duals","One Pair","One Pairs","One Pair",null,"None",null,"Included",8,"Includes Front Weight Support with No Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inside/Inner Rear Wheel Weights, and One Pair 70 kg (154 lb.) with One Pair 530 kg (1168 lb.) Outside/Outer Dual Rear Wheel Weights.","X","X"]
[5,"8R 340",null,null,null,"120mm x 3012mm (Double Taper)",null,null,null,null,null,null,null,null,null,"12 x 43kg (North America)","72kg +(2x205 kg) (2126 lb)","72kg (159 lb)+(2x205kg) (904 lb)","72kg (159 lb)+205kg(452 lb)","Wheel not compatible < 42 & Requires a Double Flat axle","1800 kg",null,"CAT 3, Hook w/ Sway Blocks (Hydraulic)","3 in 1 CAT 3","Drawbar Support Insert",null,null,null,"5 (4+1 Hi-Flow Coup) ","3795 kg (8367 lb) - For Duals","One Pair","Three Pairs","One Pair",null,"None",null,"Included",16,"Includes Front Weight Support with Four Front Suitcase Weights, One Pair 205 kg (452 lb.) Inside/Inner Rear Wheel Weights, One Pair 70 kg (154 lb.) with One Pair 550 kg (1213 lb.), and One Pair 900 kg (1984 lb.) Outside/Outer Dual Rear Wheel Weights.","X","X"]
[6,"8R 370",null,null,null,"120mm x 3012mm (Double Flat)",null,null,null,null,null,null,null,null,null,"16 x 43kg (North America)",null,"72kg (159 lb)+(3x205kg) (1356 lb)","72kg (159 lb)+(2x205kg) (904 lb)","Not compatible with Duals or Triples",null,null,"CAT 3, Hook w/ Stabilizer","3 in 1 CAT 4",null,null,null,null,null,"5409 kg (11925 lb) - For Duals","One Pair","Three Pairs","One Pair",null,"None",null,"Included",22,"Includes Front Weight Support with 22 Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inside/Inner Rear Wheel Weights, One Pair 70 kg (154 lb.), with One Pair 550 kg (1213 lb.), and One Pair 900 kg (1984 lb.) Outside/Outer Dual Rear Wheel Weights. ","X","X"]
[7,"8R 410",null,null,null,null,null,null,null,null,null,null,null,null,null,"22 x 43kg (North America)",null,null,"72kg (159 lb)+(3x205kg) (1356 lb)","Outside Drive Ballast Not Compatible with Duals or Triples. ",null,null,"CAT 4, Quick Coupler","Pickup Hitch",null,null,null,null,null,"3723 kg (8208 lb) - For Singles",null,null,null,null,null,null,null,null,"Includes Front Weight Support with 22 Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inner Rear Wheel Weights, and One Pair 70 kg (154 lb.) with One Pair 530 kg (1168 lb.) Outer Rear Wheel Weights.","X",null,"X","X"]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 x 50kg (Europe, Asia)",null,null,null,"Not Compatible with Single Tire Configurations",null,null,"CAT 4, Quick Coupler (Hydrualic)",null,null,null,null,null,null,"4463 kg (9839 lb) - For Singles",null,null,null,null,null,null,null,null,"Includes Front Weight Support with 22 Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inner Rear Wheel Weights, and One Pair 70 kg (154 lb.) with One Pair 900 kg (1984 lb.) Outer Rear Wheel Weights.","X",null,"X","X"]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8 x 50kg (Europe, Asia)",null,null,null,"Requires Double flat axle and 42in, 46in, or 50in rims",null,null,"CAT 4, Hook w/ Sway Blocks",null,null,null,null,null,null,"2623 kg (5783 lb) - For Singles",null,null,null,null,null,null,null,null,"Includes Front Weight Support with No Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inner Rear Wheel Weights, and One Pair 70 kg (154 lb.) with One Pair 530 kg (1168 lb.) Outer Rear Wheel Weights.","X",null,"X","X"]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12 x 50kg (Europe, Asia)",null,null,null,"Requires Double Flat Axle",null,null,"CAT 4, Hook w/ Sway Blocks (Hydraulic)",null,null,null,null,null,null,"3363 kg (7414 lb) - For Singles",null,null,null,null,null,null,null,null,"Includes Front Weight Support with No Front Suitcase Weights, One Pair 625 kg (1378 lb.) Inner Rear Wheel Weights, and One Pair 70 kg (154 lb.) with One Pair 900 kg (1984 lb.) Outer Rear Wheel Weights.","X",null,"X","X"]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16 x 50kg (Europe, Asia)",null,null,null,"Requires 42in, 46in, or 50in diameter wheels",null,null,"CAT 4, Hook w/ Stabilizers"]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22 x 50kg (Europe, Asia)",null,null,null,"Additional ballast not compatible with ballast packages",null,null,"CAT 4, Hook w/ Stabilizers (Hydraulic)"]
[13,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle exceeds Max Ballast Weight of 20,000kg (44,100lb)"]
[14,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outside Wheel Weights not Recommended with Triples"]
[15]
[]
[null,null," = Updated"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"900*2.20462","v":1984.1579999999999}]
[]
[null,"Power (hp)","Weight (kg)"]
[{"$f":"A1","v":"Option #"},"Tractor Model","Emissions Level","Transmission","Front Axle","Rear Axle","Front Wheel Assemblies",null,"Rear Wheel Assemblies",null,null,"Front Fenders","Rear Fenders","Front PTO","Front Weight Support","Front Suitcase Weights (NA)","Rear Wheel Weights",null,null,null,"Monster Weights (Front Hitch)","Front Hitch","Rear Hitch","Drawbar","Pickup / Wagon Hitch","Trailer Brakes","Single Line","Fuel Level (0.85 kg/L)","# of SCV's","Ballast Package"]
[null,null,null,null,null,null,"Single","Dual","Single","Dual","Triple",null,null,null,null,null,"Inside Drive","Outside Drive ","Outside Dual/Triple","Configs"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,230,1504,947.85,{"$f":"SUM(F107:F122)","v":1044.3510100000001},460.11,0,0,0,0,0,0,49.5,0,0,0,0,0,0,null,0,0,0,0,0,0,0,0,64.805621000000002,0]
[2,250,1216,1167.8,{"$f":"SUM(H107:H125)","v":1406.1906000000001},460.11,null,null,null,null,null,60.921402,53.4,{"$f":"SUM(K107:K111)","v":162.91119},191.64,191.64,1250,1200,1200,null,907.7,743.6,316.60000000000002,142.87,{"$f":"31.298+K114","v":52.468000000000004},50,11.0097,{"$f":"23*3.785412*0.85","v":74.0048046},73.055413999999999,964]
[3,250,1216,1319.73,1521,374.41498999999999,null,null,null,null,null,86.893856,55.5,null,null,{"$f":"43*4+O29","v":363.64},410,1940,1940,null,1156.3,null,326.40000000000003,165.76999999999998,{"$f":"37.05+K114","v":58.22},63.019799999999996,null,{"$f":"0.5*AB31","v":274.125},84.161861000000002,1940]
[4,310,null,null,1610,453.09,null,null,null,null,null,72.341444999999993,null,null,null,{"$f":"43*8+O29","v":535.64},820,544,544,null,1506,null,215.59999999999997,183.24,{"$f":"R107","v":29.26},33.26,null,{"$f":"645*0.85","v":548.25},95.271770000000004,2450]
[5,340,null,null,null,494.61,null,null,null,null,null,null,null,null,null,{"$f":"43*12+O29","v":707.64},964,964,964,null,1806,null,231.3,171.18200000000002,{"$f":"K114","v":21.17},null,null,null,88.446464000000006,3795]
[6,370,null,null,null,493.73,null,null,null,null,null,null,null,null,null,{"$f":"43*16+O29","v":879.64},null,1374,1374,null,null,null,374.7,171.762,143.373479,null,null,null,null,5409]
[7,410,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"43*22+P29","v":1137.6399999999999},null,3040,null,null,null,null,455.50000000000006,277,null,null,null,null,null,3723]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$29+4*50","v":391.64},null,null,null,null,null,null,473.90000000000003,null,null,null,null,null,null,4463]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$29+8*50","v":591.64},null,null,null,null,null,null,252.60000000000002,null,null,null,null,null,null,2623]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$29+12*50","v":791.64},null,null,null,null,null,null,277.10000000000002,null,null,null,null,null,null,3363]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$29+16*50","v":991.64},null,null,null,null,null,null,406.9]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$P$29+22*50","v":1291.6399999999999},null,null,null,null,null,null,431.40000000000009]
[13]
[]
[]
[]
[]
[]
[]
[]
[]
[14]
[15]
[]
[null,"updated","did not include differential between 40 and 50 km/h, using DB tractor averages (see below) ",null,"From Pro E",null,null,null,null,null,"ILS Avgs","From MMI OSB100, U8 and Argos",null,"ETN96116",null,null,null,null,"1962kg from ProE, ETN20077","Field Installed","From ETN 20929, with density correction on R538129_S1RE.prt ",null,null,"Pickup hitch weight from SAP\nWagon from Aeros -- \n*Subtracting 3.2kg if Stab (values are shown for sway blocks)",null,"74.0295-63.0198","Capacity:\nFT4/48=645 L\nFT4/49=686 L\nNon-FT4=719 L","From Pro E, See \"Aeros ETNS\" for ETN numbers -- RE3272882_V1 must be suppressed",null,null,null,null,{"$f":"63*208-29.2*68","v":11118.4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Refer to ETN tab for ProE Data",null,null,null,null,null,null,null,null,null,"1 L = .2641721 gal",null,null,null,null,null,{"$f":"AG52/92.24","v":120.53772766695577}]
[]
[null,"Power (hp)","Dist. from Rear Axle forward to C.G. (mm)"]
[{"$f":"A24","v":0},"Tractor Model","Emissions Level","Transmission","Front Axle","Rear Axle (diameter, 2438 or 3012 mm length)","Front Wheel Assemblies",null,"Rear Wheel Assemblies",null,null,"Front Fenders","Rear Fenders","Front PTO","Front Weight Support","Front Suitcase Weights (NA)","Rear Wheel Weights",null,null,null,"Monster Weights (Front Hitch)","Front Hitch","Rear Hitch","Drawbar","Pickup / Wagon Hitch","Trailer Brakes","Single Line","Fuel Level (0.85 kg/L)","# of SCV's"]
[null,null,null,null,null,null,"Single","Dual","Single","Dual","Triple",null,null,null,null,null,"72 kg","205 kg","625 kg","970 kg"]
[null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,245,{"$f":"AVERAGE(-3002.32,-2933.29)","v":-2967.8050000000003},{"$f":"-2393+377.15","v":-2015.85},-3050,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"-388*-1","v":388},0]
[2,270,{"$f":"AVERAGE(-2966.13, -2934.78,-2918.77)","v":-2939.8933333333334},{"$f":"-2393+416","v":-1977},-3050,0,null,null,null,null,null,-2636,29.826000000000001,-3769.24,4524.12,-4496.1000000000004,0,0,0,0,-5259.7,-4558,949.38825615919143,659.24356059634636,792.83100000000002,208,-381,-1325,{"$f":"-388*-1","v":388},0]
[3,295,{"$f":"AVERAGE(-2996.036, -2927.35)","v":-2961.6930000000002},{"$f":"-2393+404","v":-1989},-3080,0,null,null,null,null,null,-2906,242.09899999999999,null,null,-4651.107,null,0,null,null,-5255.51,null,945.69789999999989,685.12220365325459,844.07899999999995,121,null,-1305,{"$f":"-388*-1","v":388},0]
[4,320,null,null,-3080,0,null,null,null,null,null,-2781,null,null,null,-4706.192,null,0,null,null,-5361.71,null,755.12429978200362,690.20773845284862,834.06100000000004,-43.966000000000001,null,-1098,{"$f":"-388*-1","v":388},0]
[5,345,null,null,null,0,null,null,null,null,null,null,null,null,null,-4734.4859999999999,null,0,null,null,-5361.47,null,759.19805525291815,731.36563204659365,null,null,null,-1288,{"$f":"-388*-1","v":388},-210]
[6,370,null,null,null,null,null,null,null,null,null,null,null,null,null,-4751.7359999999999,null,0,null,null,null,null,498.36011388043778,731.98816825607526,null,null,null,-1070,null,-1002]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4768.24,null,null,null,null,null,null,954.42940966849608,201,null,null,null,null,null,-1456]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4651.107,null,null,null,null,null,null,955.02346603080809,null,null,null,null,null,null,-1214]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4706.192,null,null,null,null,null,null,836.37851167854296,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4734.4859999999999,null,null,null,null,null,null,838.0659899386502,null,null,null,null,null,null,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4751.7359999999999,null,null,null,null,null,null,564.72750640206436]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-4768.24,null,null,null,null,null,null,581.23898033611488]
[13]
[14]
[15]
[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,"1 gal = 3.785412 L"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"From Creo","From Creo",null,null,null,null,"From Creo",null,null,"From Creo"]
[]
[null,"AVERAGES"]
[null,"16 PST",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(23*7.05)/645","v":0.25139534883720932}]
[null,"Minimum",7567.8213254112597]
[null,null,1300,0]
[null,null,1500,549.17867458874105]
[null,null,"ILS",907.31066701999998]
[]
[null,"23 PST"]
[null,"Minimum",7793.6378182312601]
[null,null,1300,0]
[null,null,1500,495.39337559999899]
[null,null,"ILS",817.85848579999799]
[]
[null,"IVT"]
[null,"Minimum",7884]
[null,null,1300,0]
[null,null,1500,532.45839663126003]
[null,null,"ILS",921.65832493125902]
[]
[]
[]
[null,"MIN",{"$f":"MIN(C28:C50)","v":1216},{"$f":"MIN(D28:D50)","v":947.85},1044.3510100000001,374.41498999999999,0,0,0,0,0,0,49.5,0,0,{"$f":"MIN(P29:P50)","v":191.64},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"16 PST","1300 MFWD"]
[]
[null,"MAX",{"$f":"MAX(C28:C50)","v":1504},{"$f":"MAX(D28:D50)","v":1319.73},1610,494.61,0,0,0,0,0,86.893856,55.5,162.91119,191.64,{"$f":"MAX(P29:P50)","v":1291.6399999999999},1250,3040,1940,0,1806,743.6,473.90000000000003,277,143.373479,63.019799999999996,11.0097,548.25]
[null,null,{"$f":"INDEX(Trans, MATCH(C101,kg_Trans,0))","v":{"$error":"#N/A"}},"IVT","120mm, extra long",null,null,null,null,null,"750mm","Extra Wide","Front PTO","Front Support",22,2,null,null,null,null,null,"CAT 4, Quick Coupler (Hydraulic)","3 in 1 CAT 4","Pickup Hitch","Air & Hydraulic","Included","Full","6 w/ hitch"]
[]
[]
[null,"Front Axle"]
[null,"ILS < 295 HP",null," ILS 320 hp >>",null,"1300 MWFD",null,"1500 MFWD",null,null,"Front PTO",null,"RearHitch",null,null,null,null,"Wangon Hitch ",null,null,"Rear Axle ETNs",null,null,null,null,null,"Fenders"]
[null,310.99,"ETN200503",310.99,"ETN200503",16.8,"ETN10223",7.63,"ETN12361",null,106.61,"ETN112759",168.46,"ETN194236","CAT 3 hook w/ stablizers",null,null,29.26,"ETN179681",null,594.91999999999996,"ETN203066","110 mm R&P",null,null,"2.55 SW","BRE10459",7.11]
[null,4.3099999999999996,"ETN10642",4.3099999999999996,"ETN10642",41.98,"ETN4349",33.89,"ETN10220",null,1.1900000000000001E-3,"ETN96528",21.73,"ETN4463_19",null,null,null,null,null,null,460.11,"ETN170965",null,null,null,"2.55LW","BRE10460",14.83]
[null,7.98,"ETN173484",7.98,"ETN173484",1.99,"ETN10646",58.75,"ETN19168",null,38.520000000000003,"ETN216142",108.9,"ETN21079",null,null,null,null,null,null,40.729999999999997,"ETN18314",null,null,null,"2.75 SW","BRE10461"]
[null,431.77,"ETN188604",429.11,"ETN188606",41.61,"ETN4343",1.67,"ETN171363",null,9.16,"ETN16693",null,"ETN4465_19",null,null,null,null,null,null,315.22000000000003,"ETN224157",null,null,null,"2.75LW","BRE10462"]
[null,74.19,"ETN18989",89.66,"ETN19575",0,"ETN183896",23.67,"ETN185089",null,8.6199999999999992,"ETN16762",50.67,"ETN171078",null,null,null,null,null,null,81.84,"ETN170961",null,null,null,"2.55 lw","ETN170306",57.06,{"$f":"AB111-AB108","v":42.230000000000004}]
[null,63.73,"ETN19789",7.53,"ETN18969",38.35,"ETN15623",2.4900000000000002,"ETN183895",null,null,null,76.010000000000005,"ETN97038","CAT 3 hook w/ swayblocks(hydraulic) ",null,null,null,null,null,147.72999999999999,"ETN181748"]
[null,12.97,"ETN184069",12.69,"ETN184069",3.5810000000000002E-2,"ETN185052",0.93540000000000001,"ETN19611",null,"drawbar support",null,9.2799999999999994,"ETN4723_05",null,null,null,null,null,null,21.25,"ETN170002"]
[null,80.989999999999995,"ETN19347",72.62,"ETN106761",26.32,"ETN4350",121.41,"ETN202392",null,21.17,"ETN21221",50.67,"ETN171078",null,null,null,null,null,null,285.89,"ETN170969"]
[null,1.98,"ETN189894",80.989999999999995,"ETN19347",0,"ETN167222",6.9,"ETN167224",null,"CAT 3 support",null,32.299999999999997,"ETN93372",null,null,null,null,null,null,3.83,"ETN185838"]
[null,39.53,"ETN4321",1.98,"ETN189894",0.42599999999999999,"ETN181035",0.27900000000000003,"ETN181036",null,70.7,"ETN92940",21.13,"ETN4462_07","CAT 3 hook w/ sway block ",null,null,null,null,null,16.18,"ETN20683","IVT"]
[null,4.8600000000000003,"ETN167227",39.520000000000003,"ETN4321",169.97,"ETN197045",147.79,"ETN185050",null,"Cat 4 support",null,85.45,"ETN97036","CAT 3 QC",null,null,null,null,null,24.31,"ETN184769"]
[null,12.43,"ETN167272",2.59,"ETN184297",169.97,"ETN14572",224.45,"ETN185051",null,68.58,"ETN20564",9.14,"ETN4471_07",null,null,null,null,null,null,4.2878999999999999E-3,"ETN179470"]
[null,2.59,"ETN184297",85.67,"ETN173498",161.19,"ETN128505",222.62,"ETN19893",null,null,null,50.67,"ETN171078_05",null,null,null,null,null,null,34.22,"ETN184515"]
[null,0.9163,"ETN178609",4.8600000000000003,"ETN167227",161.19999999999999,"ETN128504",0.25069999999999998,"ETN15593",null,"CAT 4",null,21.14,"ETN4462_07",null,null,null,null,null,null,1.454,"ETN174060"]
[null,195.58,"ETN219942",0.9163,"ETN178609",0.1192,"ETN107943",0.1192,"ETN107943_02",null,88.21,"ETN20103",111.08,"ETN3744_01",null,null,null,null,null,null,12.55,"ETN170446"]
[null,195.58,"ETN219943",233.57,"ETN219938",214.39,"RE587670",222.63,"ETN19892",null,8.99,"ETN4479",30.97,"ETN93370","CAT 3 QC (hydraulic)",null,null,null,null,null,{"$f":"SUM(U107:U121)","v":2040.2382878999999}]
[null,72.62,"ETN122144",233.57,"ETN219939",{"$f":"SUM(F107:F121)","v":829.9610100000001},null,310.93,"R563354",null,68.58,"ETN20564",null,null,null,null,null,null,null,null,493.73,"ETN170964"]
[null,null,"16 PST",0.1192,"ETN19486","pres",null,0.93500000000000005,"ETN185135",null,"CAT 4 HD",null,85.41,"ETN97036","CAT 4 QC",null,null,null,null,null,{"$f":"SUM(U107:U121)-U108+U123","v":2073.8582879000001}]
[null,1.37,"ETN20435","IVT",null,null,"ETN15806",{"$f":"(0.89*7.57)+(0.89*13.6)","v":18.8413},"Oil volume",null,105.68,"ETN20105",9.14,"ETN4471_09"]
[null,2.27,"ETN180259",0.49199999999999999,"ETN15806",null,null,null,null,null,8.99,"ETN4479",50.67,"ETN171078_05"]
[null,1.1299999999999999,"ETN173492",1.0900000000000001,"ETN20436",null,null,null,null,null,68.58,"ETN20564",23.87,"ETN4464_07","Mech"]
[null,{"$f":"0.89*11.32","v":10.0748},"oil volume",8.34,"ETN188984",null,null,null,null,null,null,null,42.23,"ETN20979","Hydrualic"]
[null,null,null,2.92,"ETN180260",null,null,null,null,null,null,null,229.62,"ETN4470_30"]
[null,null,null,1.17,"ETN173493",null,null,null,null,null,null,null,138.38,"ETN149338","CAT 4 SwayBlocks"]
[null,null,null,{"$f":"0.89*11.32","v":10.0748},"Oil volume",null,null,null,null,null,null,null,9.1999999999999993,"ETN4723_07"]
[null,null,null,null,null,null,null,null,null,null,null,null,50.67,"ETN171078_02"]
[null,null,null,null,null,null,null,null,null,null,null,null,24.56,"ETN4465_19","Mech"]
[null,null,null,null,null,null,null,null,null,null,null,null,43.91,"ETN20980","Hydraulic"]
[null,null,null,null,null,null,null,null,null,null,null,null,110.99,"ETN97039","Stabilizers"]
[null,null,null,null,null,null,null,null,null,null,null,null,50.67,"ETN171078_02"]
[null,null,null,null,null,null,null,null,null,null,null,null,24.56,"ETN4465_19","Mech"]
[null,null,null,null,null,null,null,null,null,null,null,null,43.91,"ETN20980","Hydraulic"]

{"sheet":"2 Tracks Calculator","index":3,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,3,4,5],[4,7,4,9],[5,3,5,5],[5,7,5,9],[20,7,20,9],[20,1,20,3],[23,7,23,9],[24,7,24,9],[21,7,21,9],[25,7,25,9],[21,5,22,5],[22,7,22,9]]}
[]
[]
[]
[]
[null,null,null,"Customer Name:",null,null,null,"Name of analysis:"]
[null,null,null,"Customer",null,null,null,"Application"]
[]
[]
[null," Model:",null,"Emissions level:",null," Transmission:",null,"Max Tread Setting:",null," Rear Drive Wheels:"]
[null,"RT 370",null,"Final Tier 4/ Stage 5",null,"IVT",null,"96in/120in (2038mm/3048mm)",null,"Standard"]
["(kg)",{"$f":"RIGHT(B10,3)*1","v":370},null,{"$f":"INDEX('Weight Variables -2 Track'!N22:N24,MATCH(_23_PST,'Weight Variables -2 Track'!N3:N5,0))","v":1504},null,{"$f":"INDEX('Weight Variables -2 Track'!C22:C23,MATCH('2 Tracks Calculator'!F10,'Weight Variables -2 Track'!C3:C4,0))","v":1319.73},null,{"$f":"INDEX(kg_RearAxleT,MATCH(H10,RearAxleT,0))","v":1511},null,{"$f":"INDEX(kg_RearDriveWheels, MATCH(J10,RearDriveWheels,0))","v":741.89}]
["(mm)",6700,null,{"$f":"F12","v":-2388},null,{"$f":"INDEX(mm_TransT, MATCH(F10,TransT,0))","v":-2388},null,{"$f":"INDEX(mm_RearAxleT,MATCH(H10,RearAxleT,0))","v":-689},null,{"$f":"INDEX(mm_RearDriveWheels, MATCH(J10,RearDriveWheels,0))","v":0}]
[null,-950]
[]
[null,"Rear Hitch:",null,"Drawbar:",null,"SCVs:",null,"Fuel Level:",null,"Tracks:"]
[null,"CAT 4, Quick Coupler",null,"CAT 4 HD",null,4,null,"Full",null,"30in (762mm), 6500"]
["(kg)",{"$f":"INDEX(kg_RearHitchT, MATCH(B16,RearHitchT,0))","v":455.50000000000006},null,{"$f":"INDEX(kg_DrawbarT, MATCH(D16,DrawbarT,0))","v":183},null,{"$f":"INDEX(kg_SCVsT, MATCH(F16,SCVsT,0))","v":73.055413999999999},null,{"$f":"INDEX(kg_FuelT, MATCH(H16,FuelT,0))","v":644.29999999999995},null,{"$f":"INDEX('Weight Variables -2 Track'!D22:D29,MATCH('2 Tracks Calculator'!J16,'Weight Variables -2 Track'!D3:D10,0))","v":3998.4}]
["(mm)",{"$f":"INDEX(mm_RearHitchT, MATCH(B16,RearHitchT,0))","v":0},null,{"$f":"INDEX(mm_DrawbarT, MATCH(D16,DrawbarT,0))","v":590},null,{"$f":"INDEX(mm_SCVsT, MATCH(F16,SCVsT,0))","v":294},null,{"$f":"INDEX(mm_FuelT, MATCH(H16,FuelT,0))","v":-832},null,{"$f":"INDEX(mm_Tracks, MATCH(J16,Tracks,0))","v":-1269.981}]
[null,null,null,null,null,null,null,"Assuming .85 kg/L"]
[]
[null,"Front Ballast",null,null,null,"Configuration",null,"Other Ballast"]
[null," Front Suitcase Weights:",null," Idler Weights:",null,{"$f":"IF(D39>17700,'Weight Variables -2 Track'!O3, \"GOOD\")","v":"GOOD"},null," Additional Ballast (kg):"]
[null,"Front Weight Support, No Weights",null,"None",null,null,null,"Expand Rows, Enter Below"]
["(kg)",{"$f":"INDEX('Weight Variables -2 Track'!H22:H29, MATCH(B23,'Weight Variables -2 Track'!H3:H10,0))","v":191.64},null,{"$f":"INDEX(kg_IdlerWeights, MATCH(D23,IdlerWeights,0))","v":0},null,null,null,0]
["(mm)",{"$f":"INDEX('Weight Variables -2 Track'!H41:H48, MATCH(B23,'Weight Variables -2 Track'!H3:H10,0))","v":-4896.1000000000004},null,{"$f":"INDEX(mm_IdlerWeights, MATCH(D23,IdlerWeights,0))","v":0},null,null,null,0]
[null,"Must include Front Weight Support",null,null,null,{"$f":"TEXT(D33,\"yymmdd\")","v":"230123"},null,"Input wieght (kg), and distance from rear axle (mm). Forward is negative."]
[]
[]
[]
[]
[null,null,null,null,null,"Configuration Summary:"]
[null,"Analysis:",null,{"$f":"IF(H6=\"\",\"Not specified\",H6)","v":"Application"}]
[null,"Date Completed:",null,{"$f":"TODAY()","v":"2023-01-23"},null,"Model:",null,{"$f":"B10","v":"RT 370"}]
[null,"Performed by:",null,{"$f":"IF(D6=\"\",\"Not specified\",D6)","v":"Customer"},null,"Engine Emissions level:",null,{"$f":"_23_PST","v":"Final Tier 4/ Stage 5"}]
[null,null,null,null,null,"Transmission:",null,{"$f":"F10","v":"IVT"}]
[null,null,null,null,null,"Max Tread Setting:",null,{"$f":"H10","v":"96in/120in (2038mm/3048mm)"}]
[null,null,null,null,null,"Rear Drive Wheels:",null,{"$f":"J10","v":"Standard"}]
[null,null,null,null,null,"Tracks:",null,{"$f":"J16","v":"30in (762mm), 6500"}]
[null,"Total Weight (kg)",null,{"$f":"SUM(D11,F11,H11,J11,B17,D17,F17,H17,J17,B24,D24,H24,B12)","v":17322.515414000001},null,"Rear Hitch:",null,{"$f":"B16","v":"CAT 4, Quick Coupler"}]
[null,"Front Axle Weight (kg)",null,{"$f":"(D39*D44)/-2508","v":8202.5263886299836},null,"Drawbar:",null,{"$f":"D16","v":"CAT 4 HD"}]
[null,"Rear Axle Weight (kg)",null,{"$f":"D39-D40","v":9119.9890253700178},null,"# of SCVs:",null,{"$f":"F16","v":4}]
[null,"Front Split",null,{"$f":"D40/D39","v":0.47351820405948247},null,"Fuel Level:",null,{"$f":"H16","v":"Full"}]
[null,"Rear Split",null,{"$f":"D41/D39","v":0.52648179594051747}]
[null,"Dist. from Rear Axle forward to C.G. (mm)",null,{"$f":"(SUM(D11*D12,F11*F12,H11*H12,J11*J12,B17*B18,D17*D18,J17*J18,F17*F18,H17*H18,B24*B25,D24*D25,H24*H25,B12*B13))/D39","v":-1187.5836557811822},null,"Front Suitcase Weights:",null,{"$f":"B23","v":"Front Weight Support, No Weights"}]
[null,null,null,null,null,"Idler Weights:",null,{"$f":"D23","v":"None"}]
[null,"Kg / Engine Power (ps)",null,{"$f":"D39/B11","v":46.817609227027027},null,"Additional Ballast (kg):",null,{"$f":"H24","v":0}]
[]
[]
[null,"Total Weight (lb)",null,{"$f":"D39*2.20462","v":38189.563932012679}]
[null,"Front Axle Weight (lb)",null,{"$f":"D39*2.20462","v":38189.563932012679}]
[null,"Rear Axle Weight (lb)",null,{"$f":"D40*2.20462","v":18083.453726901433}]
[]
[null,"lb / Engine Power (ps)",null,{"$f":"D49/B11","v":103.21503765408832}]

{"sheet":"Weight Variables -2 Track","index":4,"n_rows":72,"n_cols":20,"rows_kept":72,"cut":false,"hidden":true,"merged":[[55,17,55,18],[55,14,55,15],[55,11,55,12],[0,13,1,13],[18,2,18,13],[19,13,20,13],[37,2,37,13],[38,13,39,13],[55,8,55,9],[38,5,39,5],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,9,39,9],[38,10,39,10],[38,11,39,11],[38,12,39,12],[19,11,20,11],[18,0,20,0],[19,7,20,7],[19,8,20,8],[19,9,20,9],[19,10,20,10],[37,0,39,0],[38,1,39,1],[38,2,39,2],[38,3,39,3],[38,4,39,4],[19,6,20,6],[19,1,20,1],[19,2,20,2],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,9,1,9],[19,3,20,3],[19,4,20,4],[19,5,20,5],[0,14,1,14],[0,11,1,11],[0,12,1,12],[0,10,1,10],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[19,12,20,12]]}
["Option #","Tractor Model","Transmission","Tracks","Rear Drive Wheels","Max Tread Setting ","Front Weight Support","Front Suitcase Weights (NA)","Idler Weights","Drawbar","Rear Hitch","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Emission Levels","Configurations"]
[]
[1,"RT 310","e23","16in (406mm), 6500","Standard","96in/120in (2038mm/3048mm)","Not Included","No Front Weight Support","None","Not Included","CAT 4, Quick Coupler","Empty",4,"Final Tier 4/ Stage 5","Vehicle exceeds Max Ballast Weight of 17,700kg (39,000lb)"]
[2,"RT 340","IVT","18in (457mm), 4500","Wide","160in (4064mm)","Included","Front Weight Support, No Weights","146kg (323 lb) -  4x36kg (80lb) Weights","CAT 4","CAT 4, Hook w/ Sway Blocks","23 GAL",5,"Tier 3/ Stage 3"]
[3,"RT 370",null,"18in (457mm), 6500",null,null,null,"4 x 43kg (North America)","432kg (953lb) - 4x36kg (80lb) + 4x72kg (159lb) ","CAT 4 HD",null,"Half",6,"Tier 2/ Stage 2 engine"]
[4,"RT 410",null,"24in (610mm), 4500",null,null,null,"8 x 43kg (North America)","1252kg (2760 lb) -  4x36kg (80lb) + 4x72kg (159lb) + 4x205kg (452lb)",null,null,"Full","5 (4+1 Hi-Flow Coup)"]
[5,null,null,"25in (635mm), 4500",null,null,null,"12 x 43kg (North America)"]
[6,null,null,"25in (635mm), 6500",null,null,null,"16 x 43kg (North America)"]
[7,null,null,"30in (762mm), 4500",null,null,null,"22 x 43kg (North America)"]
[8,null,null,"30in (762mm), 6500",null,null,null,"34 x 43kg (22 + 12 \"cheek\" weights)"]
[9]
[10]
[11]
[12]
[]
[null,null," = Updated/Confirmed"]
[]
[]
["Option #","Power (hp)","Weight (kg)"]
[null,"Tractor Model","Transmission","Tracks","Rear Drive Wheels","Max Tread Setting ","Front Weight Support","Front Suitcase Weights (NA)","Idler Weights","Drawbar","Rear Hitch","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Emissions levels"]
[]
[1,310,1167.8,{"$f":"SUM(L57:L58)","v":3236.6},741.89,1511,0,0,0,0,455.50000000000006,0,73.055413999999999,1504]
[2,340,1319.73,{"$f":"SUM(L59:L60)","v":3108.6499999999996},1039.08,2141.5,191.64,191.64,156.55136300000001,166,252.60000000000002,{"$f":"23*3.785412*0.85","v":74.0048046},84.161861000000002,1216]
[3,370,null,{"$f":"SUM(L61:L62)","v":3284.6},null,null,null,{"$f":"43*4+H23","v":363.64},{"$f":"36*4+I23","v":300.55136300000004},183,null,{"$f":"0.5*L25","v":322.14999999999998},95.271770000000004,1216]
[4,410,null,{"$f":"SUM(L63:L64)","v":3315.88},null,null,null,{"$f":"43*8+H23","v":535.64},{"$f":"(36*4)+(72*4)+I23","v":588.55136300000004},null,null,{"$f":"758*0.85","v":644.29999999999995},88.446464000000006]
[5,null,null,{"$f":"SUM(L65:L66)","v":3577.77},null,null,null,{"$f":"43*12+H23","v":707.64},{"$f":"(36*4)+(205*4)+I23","v":1120.551363}]
[6,null,null,{"$f":"SUM(L67:L68)","v":3769.9300000000003},null,null,null,{"$f":"43*16+H23","v":879.64},{"$f":"(36*4)+(72*4)+(205*4)+I23","v":1408.551363}]
[7,null,null,{"$f":"SUM(L69:L70)","v":3772.08},null,null,null,{"$f":"43*22+H23","v":1137.6399999999999}]
[8,null,null,{"$f":"SUM(L71:L72)","v":3998.4},null,null,null,1653]
[9]
[10]
[11]
[12]
[]
["Comments","updated",null,null,null,null,"Using same value as wheels, updated tracks etn gives 175.9672","Same as wheels, plus 10 weight package for 32","323 lb = 4 starter weight package",null,null,null,"^currently wheels"]
[]
[]
["Option #","Power (hp)","Dist. from Rear Axle forward to C.G. (mm)"]
[null,"Tractor Model","Transmission","Tracks","Rear Drive Wheels","Max Tread Setting ","Front Weight Support","Front Suitcase Weights (NA)","Idler Weights","Drawbar","Rear Hitch","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Emissions levels"]
[]
[1,320,-2376,{"$f":"-400+-869.981","v":-1269.981},0,-689,0,0,0,0,0,0,294,{"$f":"-2967.805-573","v":-3540.8049999999998}]
[2,340,-2388,{"$f":"-400+-869.981","v":-1269.981},0,-640.70000000000005,-4496.1000000000004,{"$f":"-400+G42","v":-4896.1000000000004},-2508,585,855,-1300,294,{"$f":"-2939.89333333333-573","v":-3512.8933333333298}]
[3,370,null,-1269.981,null,0,".",{"$f":"-400+-4651.107","v":-5051.107},-2508,590,736,-1181,294,{"$f":"-573-2961.693","v":-3534.6930000000002}]
[4,410,null,-1269.981,null,null,null,{"$f":"-400+-4706.192","v":-5106.192},-2508,null,null,-832,294]
[5,null,null,-1269.981,null,null,null,{"$f":"-400+-4734.486","v":-5134.4859999999999}]
[6,null,null,-1269.981,null,null,null,{"$f":"-400+-4751.736","v":-5151.7359999999999}]
[7,null,null,-1269.981,null,null,null,{"$f":"-400+-4768.24","v":-5168.24}]
[8,null,null,-1269.981,null,null,null,-4500]
[9,null,null,-1269.981]
[10]
[11]
[12]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Rear Axle ETN",null,null,"Track ETNS",null,null,"Drawbar ETN",null,null,"Rear Hitch ETN"]
[null,null,"  ",null,null,null,null,null,null,null,null,{"$f":"1160.3*2","v":2320.6},"ETN191458_01","16\" severe",86.39,"ETN4487_02","CAT 4",85.41,"ETN97036_03","CAT 4 QC"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"458*2","v":916},"ETN17717_01",null,8.9,"ETN4479",null,10.64,"ETN11948_09"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1160.3*2","v":2320.6},"ETN191458_01","18\" STD",103.85,"ETN4728_02","CAT 4 HD",49.8,"ETN198335_03"]
[null,null,null,null,null,null,null,null,null,null,null,788.05,"ETN117711_01",null,8.9,"ETN4479",null,23.87,"ETN4464_09"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1160.3*2","v":2320.6},"ETN191458_01","18\" severe",null,null,null,292.62,"ETN4470_36"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"482*2","v":964},"ETN117716_01",null,null,null,null,110.69,"ETN97039_03","Sway"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1160.3*2","v":2320.6},"ETN191458_01","24\" STD",null,null,null,10.69,"ETN11949_06"]
[null,null,null,null,null,null,null,null,null,null,null,995.28,"ETN117712_01",null,null,null,null,49.8,"ETN198335_03"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1267.2*2","v":2534.4},"ETN191457_01","25\" STD",null,null,null,24.56,"ETN4465_24"]
[null,null,null,null,null,null,null,null,null,null,null,1043.3699999999999,"ETN117713_01"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1267.2*2","v":2534.4},"ETN191457_01","25\" severe"]
[null,null,null,null,null,null,null,null,null,null,null,1235.53,"ETN117717_01"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1267.2*2","v":2534.4},"ETN191457_01","30\" STD"]
[null,null,null,null,null,null,null,null,null,null,null,1237.68,"ETN117714_03"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"1267.2*2","v":2534.4},"ETN191457_01","30\" severe"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"732*2","v":1464},"ETN117718_02"]

{"sheet":"4 Tracks Calculator","index":5,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[27,8,29,8],[4,3,4,5],[5,3,5,5],[25,5,25,7],[26,5,26,7],[27,5,27,7],[28,5,28,7],[29,5,29,7],[35,1,35,3],[31,5,31,7],[36,1,36,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3]]}
[]
[]
[]
[]
[null,null,null,"Customer Name:",null,null,null,"Name of analysis:"]
[null,null,null,"Customer",null,null,null,"Application"]
[]
[null," Model:",null," Emissions level:",null," Transmission:",null,"Tread Setting"]
[null,"RX 370",null,"Final Tier 4/ Stage 5",null,"e23",null,"120in (3048mm)"]
["(kg)",{"$f":"RIGHT(B9,3)*1","v":370},null,{"$f":"INDEX('Weight Variables - 4 Track'!C22:C24,MATCH('4 Tracks Calculator'!D9,'Weight Variables - 4 Track'!C3:C5,0))","v":1504},null,{"$f":"INDEX('Weight Variables - 4 Track'!D22:D23,MATCH('4 Tracks Calculator'!F9,'Weight Variables - 4 Track'!D3:D4,0))","v":1163.5},null,{"$f":"INDEX('Weight Variables - 4 Track'!N22:N25,MATCH('4 Tracks Calculator'!H9,'Weight Variables - 4 Track'!N3:N6,0))","v":2885}]
["(mm)",5880,null,{"$f":"INDEX('Weight Variables - 4 Track'!C41:C43,MATCH('4 Tracks Calculator'!D9,'Weight Variables - 4 Track'!C3:C5,0))","v":-3152.8049999999998},null,{"$f":"INDEX('Weight Variables - 4 Track'!D41:D42,MATCH('4 Tracks Calculator'!F9,'Weight Variables - 4 Track'!D3:D4,0))","v":-2162},null,{"$f":"INDEX('Weight Variables - 4 Track'!N41:N44,MATCH('4 Tracks Calculator'!H9,'Weight Variables - 4 Track'!N3:N6,0))","v":-1739}]
[null,-1200,null,"16 PST not available for 345hp or 370hp models ",null,"16 PST not available for 345hp or 370hp models "]
[]
[null," Front Hitch:",null," Rear Hitch:",null," Drawbar:",null,"3 in 1 Rails Option:"]
[null,"Not Included",null,"CAT 4, Quick Coupler",null,"CAT 4 HD",null,"Not Included"]
[null,{"$f":"INDEX('Weight Variables - 4 Track'!O22:O23, MATCH(B15,'Weight Variables - 4 Track'!O3:O4,0))","v":0},null,{"$f":"INDEX('Weight Variables - 4 Track'!J22:J28,MATCH('4 Tracks Calculator'!D15,'Weight Variables - 4 Track'!J3:J9,0))","v":455.50000000000006},null,{"$f":"INDEX('Weight Variables - 4 Track'!H22:H25,MATCH('4 Tracks Calculator'!F15,'Weight Variables - 4 Track'!H3:H5,0))","v":183.24},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - 4 Track'!I22:I26,MATCH('4 Tracks Calculator'!$H$15,'Weight Variables - 4 Track'!$I$3:$I$7,0)),0)","v":0}]
[null,{"$f":"INDEX('Weight Variables - 4 Track'!O41:O42, MATCH(B15,'Weight Variables - 4 Track'!O3:O4,0))","v":0},null,{"$f":"INDEX('Weight Variables - 4 Track'!J41:J47,MATCH('4 Tracks Calculator'!D15,'Weight Variables - 4 Track'!J3:J9,0))","v":1079.8313910164652},null,{"$f":"INDEX('Weight Variables - 4 Track'!H41:H44,MATCH('4 Tracks Calculator'!F15,'Weight Variables - 4 Track'!H3:H5,0))","v":895.20773830566463},null,{"$f":"_xlfn.IFNA(INDEX('Weight Variables - 4 Track'!$I$41:$I$45,MATCH('4 Tracks Calculator'!$H$15,'Weight Variables - 4 Track'!$I$3:$I$7,0)),0)","v":0}]
[null,"None",null,"None",null,"None",null,"None"]
[]
[null,"Fuel Level:",null,"Trailer Brakes:",null,"# of SCVs:"]
[null,"Half",null,"Dual line Air & Hydraulic",null,6]
[null,{"$f":"INDEX('Weight Variables - 4 Track'!L22:L25,MATCH('4 Tracks Calculator'!B21,'Weight Variables - 4 Track'!FuelT,0))","v":322.14999999999998},null,{"$f":"INDEX('Weight Variables - 4 Track'!K22:K25,MATCH('4 Tracks Calculator'!D21,'Weight Variables - 4 Track'!K3:K6,0))","v":63.019799999999996},null,{"$f":"INDEX(kg_SCVs, MATCH(F21,SCVs,0))","v":95.271770000000004}]
[null,{"$f":"INDEX('Weight Variables - 4 Track'!mm_FuelT,MATCH('4 Tracks Calculator'!B21,'Weight Variables - 4 Track'!FuelT,0))","v":-1243.4798000000001},null,{"$f":"INDEX('Weight Variables - 4 Track'!K41:K44,MATCH('4 Tracks Calculator'!D21,'Weight Variables - 4 Track'!K3:K6,0))","v":121},null,{"$f":"INDEX(mm_SCVs, MATCH(F21,SCVs,0))","v":388}]
[null,"Assuming .85 kg/L",null,null,null,"None"]
[]
[null,"Front Tracks:",null,"Rear Tracks:",null,"Configuration"]
[null,"24in (609.6mm)",null,"24in (609.6mm)",null,{"$f":"IF(D50>20000,'Weight Variables - 4 Track'!P3,\"GOOD\")","v":"GOOD"},null,null,16.5]
["(kg)",{"$f":"INDEX('Weight Variables - 4 Track'!E22:E24,MATCH('4 Tracks Calculator'!B27,'Weight Variables - 4 Track'!E3:E5,0))","v":2770.76},null,{"$f":"INDEX('Weight Variables - 4 Track'!F22:F25,MATCH('4 Tracks Calculator'!D27,'Weight Variables - 4 Track'!F3:F6,0))","v":4486.8900000000003}]
["(mm)",{"$f":"INDEX('Weight Variables - 4 Track'!E41:E43,MATCH('4 Tracks Calculator'!B27,'Weight Variables - 4 Track'!E3:E5,0))","v":-3253.692},null,0]
[null,"None",null,"None",null,{"$f":"TEXT(D44,\"yymmdd\")","v":"230123"}]
[]
[null,"Front Ballast",null,null,null,"Other Ballast"]
[null," Front Suitcase Weights:",null,null,null,"Front Mono Weights:",null," Additional Ballast (kg):"]
[null,"Front Weight Support, No Starter Weight, No Suitcase Weights",null,null,null,"Not Included",null,"Expand Rows, Enter Below"]
["(kg)",{"$f":"INDEX('Weight Variables - 4 Track'!G22:G27,MATCH('4 Tracks Calculator'!B34,'Weight Variables - 4 Track'!G3:G8,0))","v":104},null,null,null,{"$f":"INDEX(kg_PickUpWeights, MATCH(F34,PickUpWeights,0))","v":0},null,0]
["(mm)",{"$f":"INDEX('Weight Variables - 4 Track'!G41:G46,MATCH('4 Tracks Calculator'!B34,'Weight Variables - 4 Track'!G3:G8,0))","v":-4606},null,null,null,0,null,0]
[null,null,null,null,null,"Region 2 only, Not compatible with front weight support and suitcase weights",null,"Input distance forward from rear axle (mm)"]
[]
[]
[]
[null,null,null,null,null,"Configuration Summary:"]
[null,null,null,null,null,null,null,null,null,0]
[null,"Analysis:",null,{"$f":"IF(H6=\"\",\"Not specified\",H6)","v":"Application"},null,"Model:",null,{"$f":"B9","v":"RX 370"}]
[null,"Date Completed:",null,{"$f":"TODAY()","v":"2023-01-23"},null,"Emssion Levels:",null,{"$f":"D9","v":"Final Tier 4/ Stage 5"}]
[null,"Performed by:",null,{"$f":"IF(D6=\"\",\"Not specified\",D6)","v":"Customer"},null,"Transmission:",null,{"$f":"F9","v":"e23"}]
[null,null,null,null,null,"Tread Setting:",null,{"$f":"H9","v":"120in (3048mm)"}]
[null,null,null,null,null,"Front Hitch:",null,{"$f":"B15","v":"Not Included"}]
[null,null,null,null,null,"Rear Hitch:",null,{"$f":"D15","v":"CAT 4, Quick Coupler"}]
[null,null,null,null,null,"Drawbar:",null,{"$f":"F15","v":"CAT 4 HD"}]
[null,"Total Weight (kg)",null,{"$f":"SUM(D10,F10,H10,B16,D16,F16,H16,B22,D22,F22,B28,D28,B35,F35,H35,B11)","v":19913.331569999998},null,"3 in 1 Rails Option:",null,{"$f":"H15","v":"Not Included"}]
[null,"Front Axle Weight (kg)",null,{"$f":"D50*(D55/B29)","v":8657.4400101007941},null,"Fuel Level:",null,{"$f":"B21","v":"Half"}]
[null,"Rear Axle Weight (kg)",null,{"$f":"D50-D51","v":11255.891559899204},null,"Trailer Brakes:",null,{"$f":"D21","v":"Dual line Air & Hydraulic"}]
[null,"Front Split",null,{"$f":"D51/D50","v":0.43475598142218824},null,"# of SCVs:",null,{"$f":"F21","v":6}]
[null,"Rear Split",null,{"$f":"D52/D50","v":0.5652440185778117},null,"Drawbar:",null,{"$f":"F15","v":"CAT 4 HD"}]
[null,"Dist. from Rear Axle forward to C.G. (mm)",null,{"$f":"SUM(D10*D11,F10*F11,H10*H11,B16*B17,D16*D17,F16*F17,H16*H17,B28*B29,D28*D29,B35*B36,F35*F36,H35*H36,B11*B12)/D50","v":-1414.5620587055225},null,"Front Tracks:",null,{"$f":"B27","v":"24in (609.6mm)"}]
[null,null,null,null,null,"Rear Tracks:",null,{"$f":"D27","v":"24in (609.6mm)"}]
[null,"Kg / Engine Power (ps)",null,{"$f":"D50/B10","v":53.819815054054047},null,"Front Suitcase Weights:",null,{"$f":"B34","v":"Front Weight Support, No Starter Weight, No Suitcase Weights"}]
[null,null,null,null,null,"Pickup (Monster) Weights:",null,{"$f":"F34","v":"Not Included"}]
[null,null,null,null,null,"Additional Ballast:",null,{"$f":"H34","v":"Expand Rows, Enter Below"}]
[]
[null,"Total Weight (lb)",null,{"$f":"D50*2.20462","v":43901.329045853396}]
[null,"Front Axle Weight (lb)",null,{"$f":"D51*2.20462","v":19086.365395068409}]
[null,"Rear Axle Weight (lb)",null,{"$f":"D52*2.20462","v":24814.963650784983}]
[]
[null,"lb / Engine Power (ps)",null,{"$f":"D61/B10","v":118.65224066446864}]

{"sheet":"Weight Variables - 4 Track","index":6,"n_rows":81,"n_cols":22,"rows_kept":81,"cut":false,"hidden":true,"merged":[[69,4,69,5],[69,2,69,3],[0,15,1,15],[0,6,1,6],[0,7,1,7],[0,8,1,8],[56,10,56,11],[56,13,56,14],[0,14,1,14],[0,9,1,9],[0,11,1,11],[0,10,1,10],[0,12,1,12],[56,16,56,17],[56,19,56,20],[19,7,20,7],[19,9,20,9],[19,13,20,13],[19,11,20,11],[19,8,20,8],[19,12,20,12],[19,10,20,10],[38,10,39,10],[37,0,39,0],[38,1,39,1],[38,3,39,3],[38,5,39,5],[38,9,39,9],[38,6,39,6],[38,7,39,7],[38,8,39,8],[38,4,39,4],[38,2,39,2],[37,3,37,14],[38,14,39,14],[38,11,39,11],[38,12,39,12],[38,13,39,13],[18,0,20,0],[19,1,20,1],[19,3,20,3],[19,5,20,5],[19,2,20,2],[19,4,20,4],[18,3,18,14],[19,6,20,6],[0,0,1,0],[0,1,1,1],[0,3,1,3],[0,5,1,5],[0,2,1,2],[0,4,1,4]]}
["Option #","Tractor Model","Emissions Levels","Transmission","Front Tracks","Rear Tracks","Front Suitcase Weights (NA)","Drawbar","3in1 Rails Option","Rear Hitch","Trailer Brakes ","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Tread Settings","Front Hitch ","Configuration"]
[]
[1,"RX 310","Final Tier 4/ Stage 5","e23","16in (406.4mm)","16in (406.4mm)","Front Hitch (No Front Weight Support)","Not Included","Not Included","CAT 4, Quick Coupler","Not Included","Empty",4,"76in (1930mm)","Not Included","Vehicle exceeds Max Ballast Weight of 20,000kg (44,100lb)"]
[2,"RX 340","Tier 3/ Stage 3","IVT ","18in (457.2mm)","18in (457.2mm)","Front Weight Support, No Starter Weight, No Suitcase Weights","CAT 4","Wagon Hitch, Piton","CAT 4, Quick Coupler (Hydraulic)"," Dual line Air ","23 GAL",5,"80in (2032mm)","Included"]
[3,"RX 370",null,null,"24in (609.6mm)","24in (609.6mm)","Front Weight Support with Starter Weight, No Suitcase Weights","CAT 4 HD","Wagon Hitch, Ball","CAT 4, Hook w/ Sway Blocks","Dual line Air & Hydraulic","Half",6,"88in (2235mm)"]
[4,"RX 410",null,null,null,"30in (762mm)","Front Weight Support with Starter Weight and 8 Suitcase Weights","3 in 1 CAT 3","Wagon Hitch, Pin","CAT 4, Hook w/ Stabilizers (Hydraulic)","Dual Line Hydraulic","Full","5 (4+1 Hi-Flow Coup)","120in (3048mm)"]
[5,null,null,null,null,null,"Front Weight Support with Starter Weight and 12 Suitcase Weights","3 in 1 CAT 4","Drawbar support insert","CAT 4, Hook w/ Stabilizers"]
[6,null,null,null,null,null,"Front Weight Support with Starter Weight and 18 Suitcase Weights","Pickup Hitch",null,"CAT 4, Hook w/ Stabilizers (Hydraulic)"]
[7]
[8]
[9]
[10]
[11]
[12]
[]
[null,null,null," = Updated/Confirmed"]
[]
[]
["Option #","Power (hp)",null,"Weight (kg)"]
[null,"Tractor Model","Emissions Levels","Transmission","Front Tracks","Rear Tracks","Front Suitcase Weights (NA)","Drawbar","3in1 Rails Option","Rear Hitch","Trailer brakes","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Tread Settings","Front Hitch "]
[]
[1,310,1504,1163.5,2550.25,4203.54,0,0,0,455.50000000000006,0,0,73.055413999999999,2452,0]
[2,340,1216,1314.6,2603.3200000000002,4271.4799999999996,104,165.76999999999998,31.3,473.90000000000003,50,{"$f":"23*3.785412*0.85","v":74.0048046},84.161861000000002,2546,780]
[3,370,null,null,2770.76,4486.8900000000003,260.60000000000002,183.24,33,252.60000000000002,63.019799999999996,{"$f":"0.5*L25","v":322.14999999999998},95.271770000000004,2752]
[4,410,null,null,null,4645.2299999999996,609.79999999999995,171.18200000000002,26,277.10000000000002,33.26,{"$f":"758*0.85","v":644.29999999999995},88.446464000000006,2885]
[5,null,null,null,null,null,783.1,171.762,0,406.9]
[6,null,null,null,null,null,1043.0999999999999,277,null,431.40000000000009]
[7]
[8]
[9]
[10]
[11]
[12]
[]
["Comments","updated",null,null,null,null,"Same as wheels, plus 10 weight package for 32",null,null,null,null,null,"^currently wheels"]
[]
[]
["Option #","Power (hp)",null,"Dist. from Rear Axle forward to C.G. (mm)"]
[null,"Tractor Model","Emissions Levels","Transmission","Front Tracks","Rear Tracks","Front Suitcase Weights (NA)","Drawbar","3in1 Rails Option","Rear Hitch","Trailer brakes","Fuel Level (758 L capacity at 0.85 kg/L)","# of SCV's","Tread Setting ","Front Hitch"]
[]
[1,320,{"$f":"-2967.805-185","v":-3152.8049999999998},{"$f":"-1977-185","v":-2162},{"$f":"-185+-3069.161","v":-3254.1610000000001},0,0,0,0,1079.8313910164652,0,0,{"$f":"388+205","v":593},-1727,0]
[2,345,{"$f":"-2939.89333333333-185","v":-3124.8933333333298},{"$f":"-1989-185","v":-2174},{"$f":"-185+-3069.014","v":-3254.0140000000001},0,-4606,890.12220349055929,997.83133999999995,1083.5159842329604,208,-1433,{"$f":"388+205","v":593},-1710,{"$f":"-4495+150","v":-4345}]
[3,370,null,null,{"$f":"-185+-3068.692","v":-3253.692},0,-4722,895.20773830566463,1000.0221,896.79360098178927,121,-1243.4798000000001,{"$f":"388+205","v":593},-1690]
[4,null,null,null,null,0,-4787.5,936.36563582853341,1050.4580000000001,903.72388220137123,-43.966000000000001,-1282.3604,{"$f":"388+205","v":593},-1739]
[5,null,null,null,null,null,-4798.3,936.98817341670451,0,735.8544426394692,null,null,{"$f":"388+205","v":593}]
[6,null,null,null,null,null,-4808,406,null,749.44598252202115]
[7]
[8]
[9]
[10]
[11]
[12]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Trailer Brakes ETN",null,null,"Drawbar ETN",null,null,"Rear hitch ETNs",null,null,"Tread setting ETNs"]
[null,null,null,null,null,null,null,null,"Drawbar",null,59.92,"ETN209856",null,8.99,"ETN4479","CAT 4",85.42,"ETN97036_02","CAT 4 OC",18.55,"ETN189907","76\" FA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,88.21,"ETN20103",null,9.15,"ETN4471_10",null,{"$f":"131.86","v":131.86000000000001},"ETN185709"]
[null,null,null,null,null,null,null,null,null,"ETN4478",null,null,null,68.58,"ETN20564",null,50.67,"ETN171078_05",null,131.41,"ETN185711"]
[null,null,342743160,null,null,null,null,null,null,"ETN92940",null,null,null,105.68,"ETN20105","CAT 4 HD",23.87,"ETN4464_08","IF mech",345.71,"ETN204518"]
[null,null,null,null,null,null,null,null,"CAT 4 ","ETN126256","CAT 3",null,null,8.99,"ETN4479",null,229.62,"ETN4470_34",null,342.69,"ETN204520"]
[null,null,null,null,null,null,null,null,"CAT HD","ETN216810",null,null,null,68.58,"ETN20564",null,42.24,"ETN20979","IF Hydraulic",55.75,"ETN189022","80\"FA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,138.38999999999999,"ETN149338","CAT 4 hook sway",{"$f":"131.86","v":131.86000000000001},"ETN185709"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.2010000000000005,"ETN4723_05",null,131.41,"ETN185711"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51.14,"ETN198336",null,345.71,"ETN204518"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.57,"ETN4465_19","Mech",342.69,"ETN204520"]
[null,null,null,null,null,null,87060000,null,null,null,null,null,null,null,null,null,43.91,"ETN20980","Hydraulic",147.62,"ETN190102","88\"FA"]
[null,null,null,null,null,null,{"$f":"G72/4","v":212977930},null,null,null,null,null,null,null,null,null,138.32,"ETN20373","CAT 4 hook stab",{"$f":"131.86","v":131.86000000000001},"ETN185709"]
[null,null,"Tank 1 -612",null,"Tank 2",null,null,null,null,null,null,null,null,null,null,null,51.14,"ETN198336",null,131.41,"ETN185711"]
[null,null,"Volume","Mass","Volume","Mass","Volume","Mass","Total ETN","CG",null,null,null,null,null,null,24.57,"ETN4465_19","Mech",345.71,"ETN204518"]
[null,"Full of Fuel",365092880,310.32893999999999,486818840,413.94206000000003,{"$f":"E72+C72","v":851911720},724.27099999999996,856.12284999999997,-1282.3604,null,null,null,null,null,null,43.91,"ETN20980","Hydraulic",342.69,"ETN204520"]
[null,"1/2 Fuel",138191250,117.46256,290572060,247.07342,428763310,364.53598,496.38781999999998,-1243.4798000000001,null,null,null,null,null,null,null,null,null,258.02999999999997,"ETN186508","120\"FA"]
[null,"23 Gallons",34351287,29.198594,49832914,42.372926999999997,84184201,71.57152099999999,203.42336,-1433.7679000000001,null,null,null,null,null,null,null,null,null,{"$f":"131.86","v":131.86000000000001},"ETN185709"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,131.41,"ETN185711"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,345.71,"ETN204518"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,342.69,"ETN204520"]
[null,null,null,null,null,null,null,{"$f":"7*23","v":161}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,811.95,"ETN176215"," 80\" RA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,920,"ETN188759","88\" RA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,918.47,"ETN190372","120\" RA"]