{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["9R","9RT","9R Option Weights","9RT Option Weights"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":101,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"9R","index":0,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[41,2,42,2],[41,4,42,4],[27,2,27,4],[27,6,27,10],[33,2,33,10],[21,6,21,10],[7,2,7,4],[8,2,8,4],[13,2,13,4],[14,2,14,4],[21,2,21,4],[18,4,18,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Rear Hitch:",null,"Rear PTO:"]
[null,null,null,null,null,null,"9370R",null,"Not Included",null,"Not Included"]
[null,null,null,null,null,null,{"$f":"INDEX(model_9_w,MATCH(G9,model_9,0))","v":12909.6072563006},null,{"$f":"INDEX(hitch_9_w,MATCH(I9,hitch_9,0))","v":0},null,{"$f":"INDEX(PTO_9_w,MATCH(K9,PTO_9,0))","v":0}]
[null,null,null,null,null,null,{"$f":"INDEX(model_9_s,MATCH(G9,model_9,0))","v":0.63219999999999998},null,{"$f":"INDEX(hitch_9_s,MATCH(I9,hitch_9,0))","v":-0.14000000000000001},null,{"$f":"INDEX(PTO_9_s,MATCH(I9,PTO_9,0))","v":-0.36799999999999999}]
[null,null,null,null,null,null,{"$f":"INDEX(hp_9,MATCH(G9,model_9,0))","v":370}]
[]
[null,null,"Name of analysis:",null,null,null,"Fuel level:",null,"No. of wheels:",null,"Tire size:"]
[null,null,"",null,null,null,"Half",null,"Duals",null,"710/70R42"]
[null,null,null,null,null,null,{"$f":"IF(OR(G9=\"9370R\",G9=\"9420R\",G9=\"9470R\"),INDEX(fuel_9_w,MATCH(G15,fuel_9,0)),INDEX(fuel_9_w_520,MATCH(G15,fuel_9,0)))","v":543.55250000000001},null,{"$f":"INDEX(wheels_9_w,MATCH(I15,wheels_9,0))","v":0},null,{"$f":"IF(I15=\"Singles\",INDEX(singles_9_w,MATCH(K15,singles_9,0)),IF(I15=\"Duals\",INDEX(duals_9_w,MATCH(K15,duals_9,0)),IF(I15=\"Triples\",INDEX(triples_9_w,MATCH(K15,triples_9,0)))))","v":5599.9610519199996}]
[null,null,null,null,null,null,{"$f":"INDEX(fuel_9_s,MATCH(G15,fuel_9,0))","v":0.152},null,{"$f":"INDEX(wheels_9_s,MATCH(I15,wheels_9,0))","v":0},null,0.5]
[]
[null,null,null,null,"Choose a wheel weight code -OR- build a custom package with the options below"]
[null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,"Front ballast",null,null,null,"Front wheel weights"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"72 kg:",null,"205 kg:",null,"625 kg:"]
[null,null,"Not Included",null,"None",null,"None",null,"None",null,"None"]
[null,null,{"$f":"INDEX(FWS_9_w,MATCH(C24,FWS_9,0))","v":0},null,{"$f":"INDEX(FSW_9_w,MATCH(E24,FSW_9,0))","v":0},null,{"$f":"INDEX(w72_9_w,MATCH(G24,w72_9,0))","v":0},null,{"$f":"INDEX(w205_9_w,MATCH(I24,w205_9,0))","v":0},null,{"$f":"INDEX(w625_9_w,MATCH(K24,w625_9,0))","v":0}]
[null,null,{"$f":"INDEX(FWS_9_s,MATCH(C24,FWS_9,0))","v":1.5609999999999999},null,{"$f":"INDEX(FSW_9_s,MATCH(E24,FSW_9,0))","v":1.581},null,1,null,1,null,1]
[]
[null,null,"Rear ballast",null,null,null,"Rear wheel weights"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"72 kg:",null,"205 kg:",null,"625 kg:"]
[null,null,"Not Included",null,"None",null,"None",null,"None",null,"None"]
[null,null,{"$f":"INDEX(RWS_9_w,MATCH(C30,RWS_9,0))","v":0},null,{"$f":"IF(OR(G9=\"9370R\",G9=\"9420R\",G9=\"9470R\"),INDEX(RSW_9_w,MATCH(E30,RSW_9,0)),INDEX(RSW_9_w_520,MATCH(E30,RSW_9_520,0)))","v":0},null,{"$f":"INDEX(Rw72_9_w,MATCH(G30,Rw72_9,0))","v":0},null,{"$f":"INDEX(Rw205_9_w,MATCH(I30,Rw205_9,0))","v":0},null,{"$f":"INDEX(Rw625_9_w,MATCH(K30,Rw625_9,0))","v":0}]
[null,null,{"$f":"INDEX(RWS_9_s,MATCH(C30,RWS_9,0))","v":-0.35499999999999998},null,{"$f":"IF(OR(G9=\"9370R\",G9=\"9420R\",G9=\"9470R\"),INDEX(RSW_9_s,MATCH(E30,RSW_9,0)),INDEX(RSW_9_s_520,MATCH(E30,RSW_9_520,0)))","v":-0.35499999999999998},null,0,null,0,null,0]
[]
[null,null,"Enter any additional ballast (kg)"]
[null,null,"Front support:",null,"Front axle:",null,"Side mount:",null,"Rear axle:",null,"Rear support:"]
[null,null,0,null,0,null,0,null,0,null,0]
[null,null,{"$f":"C36","v":0},null,{"$f":"E36","v":0},null,{"$f":"G36","v":0},null,{"$f":"I36","v":0},null,{"$f":"K36","v":0}]
[null,null,1.57,null,1,null,0.6,null,0,null,-0.35499999999999998]
[]
[]
[null,null,"Total weight:",null,{"$f":"C49& \" kg       \"&ROUND(C49*2.20462,0)& \" lb\"","v":"19053 kg       42005 lb"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C$49/G$12,0)& \" kg/hp          \"& ROUND((C$49*2.20462)/G$12,0) &\" lb/hp\"","v":"51 kg/hp          114 lb/hp"}]
[]
[null,null,"Front axle weight:",null,{"$f":"E49&\" kg          \"&ROUND(E49*2.20462,0)& \" lb\"","v":"11044 kg          24348 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C49-E49&\" kg           \"&ROUND((C49-E49)*2.20462,0)& \" lb\"","v":"8009 kg           17657 lb"},null,{"$f":"G49","v":0.57999999999999996},null,{"$f":"100%-G45","v":0.42000000000000004},null,{"$f":"TODAY()","v":"2014-09-23"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,K16,C25,E25,G25,I25,K25,C31,E31,G31,I31,K31,C37,E37,G37,I37,K37),0)","v":19053},null,{"$f":"ROUND(SUM(G10*G11,I10*I11,K10*K11,G16*G17,I16*I17,K16*K17,C25*C26,E25*E26,G25*G26,I25*I26,K25*K26,C31*C32,E31*E32,G31*G32,I31*I32,K31*K32,C37*C38,E37*E38,G37*G38,I37*I38,K37*K38),0)","v":11044},null,{"$f":"ROUND(E49/C49,3)","v":0.57999999999999996},null,{"$f":"INDEX(PTOhp_9,MATCH(G9,model_9,0))","v":335}]

{"sheet":"9RT","index":1,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[7,2,7,4],[8,2,8,4],[13,2,13,4],[14,2,14,4],[32,4,33,4],[32,2,33,2],[18,2,18,4],[24,2,24,4],[18,6,18,10],[24,6,24,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Rear Hitch:",null,"Rear PTO:"]
[null,null,null,null,null,null,"9470RT",null,"Not Included",null,"Not Included"]
[null,null,null,null,null,null,{"$f":"INDEX(model_9T_w,MATCH(G9,model_9T,0))","v":18539.599999999999},null,{"$f":"INDEX(hitch_9T_w,MATCH(I9,hitch_9T,0))","v":0},null,{"$f":"INDEX(PTO_9T_w,MATCH(K9,PTO_9T,0))","v":0}]
[null,null,null,null,null,null,{"$f":"INDEX(model_9T_s,MATCH(G9,model_9T,0))","v":0.52610000000000001},null,{"$f":"INDEX(hitch_9T_s,MATCH(I9,hitch_9T,0))","v":0},null,{"$f":"INDEX(PTO_9T_s,MATCH(I9,PTO_9T,0))","v":0}]
[null,null,null,null,null,null,{"$f":"INDEX(hp_9T,MATCH(G9,model_9T,0))","v":470}]
[]
[null,null,"Name of analysis:",null,null,null,"Fuel level:",null,"Tracks:"]
[null,null,"",null,null,null,"Half",null,"30 in, 4500 Series"]
[null,null,null,null,null,null,{"$f":"INDEX(fuel_9T_w,MATCH(G15,fuel_9T,0))","v":607.72749999999996},null,{"$f":"INDEX(tracks_9T_w,MATCH(I15,tracks_9T,0))","v":1560}]
[null,null,null,null,null,null,{"$f":"INDEX(fuel_9T_s,MATCH(G15,fuel_9T,0))","v":0.4},null,{"$f":"INDEX(tracks_9T_s,MATCH(I15,tracks_9T,0))","v":0.42520000000000002}]
[]
[null,null,"Front ballast",null,null,null,"Front idler weights"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"36 kg:",null,"72 kg:",null,"205 kg:"]
[null,null,"Not Included",null,"None",null,"None",null,"None",null,"None"]
[null,null,{"$f":"INDEX(FWS_9T_w,MATCH(C21,FWS_9T,0))","v":0},null,{"$f":"INDEX(FSW_9T_w,MATCH(E21,FSW_9T,0))","v":0},null,{"$f":"INDEX(w36_9T_w,MATCH(G21,w36_9T,0))","v":0},null,{"$f":"INDEX(w72_9T_w,MATCH(I21,w72_9T,0))","v":0},null,{"$f":"INDEX(w205_9T_w,MATCH(K21,w205_9T,0))","v":0}]
[null,null,{"$f":"INDEX(FWS_9T_s,MATCH(C21,FWS_9T,0))","v":0},null,{"$f":"INDEX(FSW_9T_s,MATCH(E21,FSW_9T,0))","v":1.8484},null,1,null,1,null,1]
[]
[null,null,"Side ballast",null,null,null,"Enter any additional ballast (kg)"]
[null,null,"Weight support:",null,"Suitcase weights:",null,"Front support:",null,"Front axle:",null,"Side support:"]
[null,null,"Not Included",null,"None",null,0,null,0,null,0]
[null,null,{"$f":"INDEX(SWS_9T_w,MATCH(C27,SWS_9T,0))","v":0},null,{"$f":"INDEX(SSW_9T_w,MATCH(E27,SSW_9T,0))","v":0},null,{"$f":"G27","v":0},null,{"$f":"I27","v":0},null,{"$f":"K27","v":0}]
[null,null,{"$f":"INDEX(SWS_9T_s,MATCH(C27,SWS_9T,0))","v":0.63700000000000001},null,{"$f":"INDEX(SSW_9T_s,MATCH(E27,SSW_9T,0))","v":0.63700000000000001},null,1.75,null,1,null,0.63700000000000001]
[]
[]
[null,null,"Total weight:",null,{"$f":"C40& \" kg       \"&ROUND(C40*2.20462,0)& \" lb\"","v":"20707 kg       45651 lb"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C$40/G$12,0)& \" kg/hp          \"& ROUND((C$40*2.20462)/G$12,0) &\" lb/hp\"","v":"44 kg/hp          97 lb/hp"}]
[]
[null,null,"Front axle weight:",null,{"$f":"E40&\" kg         \"&ROUND(E40*2.20462,0)& \" lb\"","v":"10660 kg         23501 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C40-E40&\" kg           \"&ROUND((C40-E40)*2.20462,0)& \" lb\"","v":"10047 kg           22150 lb"},null,{"$f":"G40","v":0.51500000000000001},null,{"$f":"100%-G36","v":0.48499999999999999},null,{"$f":"TODAY()","v":"2014-09-23"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,C22,E22,G22,I22,K22,C28,E28,G28,I28,K28),0)","v":20707},null,{"$f":"ROUND(SUM(G10*G11,I10*I11,K10*K11,G16*G17,I16*I17,C22*C23,E22*E23,G22*G23,I22*I23,K22*K23,C28*C29,E28*E29,G28*G29,I28*I29,K28*K29),0)","v":10660},null,{"$f":"ROUND(E40/C40,3)","v":0.51500000000000001},null,{"$f":"INDEX(PTOhp_9T,MATCH(G9,model_9T,0))","v":329}]

{"sheet":"9R Option Weights","index":2,"n_rows":113,"n_cols":6,"rows_kept":113,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle"]
["Model",null,null,"hp","PTO-hp"]
["9370R",12909.6072563006,0.63219999999999998,370,335]
["9420R",13505.121524679682,0.64370000000000005,420,335]
["9470R",13505.121524679682,0.64370000000000005,470,335]
["9520R",13521.436984087328,0.63680000000000003,520,335]
["9570R",13502.062376040747,0.63109999999999999,570,335]
["9620R",13502.062376040747,0.63109999999999999,620,335]
[]
["Rear 3-Point Hitch"]
["Not Included",0,-0.14000000000000001]
["Included",823.8,-0.14000000000000001]
[]
["Rear PTO"]
["Not Included",0,-0.36799999999999999]
["Included",419.3,-0.36799999999999999]
[]
["Fuel level","370-420",null,"520+",null,"Diesel + DEF"]
["Empty",0,0,0,null,"370-470: diesel volume of 1173 L at .85kg/L"]
["Half",{"$f":"0.5*B23","v":543.55250000000001},0.152,{"$f":"0.5*D23","v":688.47749999999996},null,"520-620: diesel volume of 1514 L at .85kg/L"]
["Full",{"$f":"(1173*0.85)+(83*1.085)","v":1087.105},0.16800000000000001,{"$f":"(1514*0.85)+(83*1.085)","v":1376.9549999999999},null,"def volume of 83 L at 1.085 kg/L"]
[]
["No. of wheels"]
["Singles",0,0]
["Duals",0,0]
["Triples",0,0]
[]
["Tire size"]
["Singles"]
["800/70R38",3139.9480297599998,0.5]
["IF800/70R38",3059.9796896400003,0.5]
["Duals"]
["480/80R46",3967.9809559599998,0.5]
["480/80R50",4599.9712468800008,0.5]
["IF480/80R50",5039.95587488,0.5]
["520/85R42",4099.9763443599995,0.5]
["520/85R46",4679.9395869999998,0.5]
["620/70R42",4739.9045022800001,0.5]
["620/70R46",4879.9284761600002,0.5]
["650/85R38",5060,0.5,"added from 8R calc"]
["IF650/85R38",5539.9507774000003,0.5]
["710/70R38",5199.9379143599999,0.5]
["IF710/70R38",5262.3,0.5,"added from 8R calc"]
["710/70R42",5599.9610519199996,0.5]
["IF710/70R42",5879.9182811999999,0.5]
["800/70R38",6099.9559544399999,0.5]
["IF800/70R38",5939.9285557200001,0.5]
["Triples"]
["480/80R46",5827.9365921600001,0.5]
["480/80R50",6759.9328964400001,0.5]
["IF480/80R50",7399.9064135999997,0.5]
["520/85R42",6059.9491047599995,0.5]
["520/85R46",6959.9217856000005,0.5]
[]
["Front Weight Support"]
["Not Included",0,1.5609999999999999]
["Included",389.2,1.5609999999999999]
[]
["Front Suitcase Weights"]
["None",0,1.581]
[8,{"$f":"43*A63","v":344},1.581]
[16,{"$f":"43*A64","v":688},1.581]
[26,1118,1.581]
[36,1548,1.581]
[]
["Front Wheel Weights"]
["72 kg"]
["None",0,1]
["One pair",144,1]
["205 kg"]
["None",0,1]
["One pair",410,1]
["Two pairs",{"$f":"B74*2","v":820},1]
["625 kg"]
["None",0,1]
["One pair",1250,1]
[]
["Drawbar Weight Support"]
["Not Included",0,-0.35499999999999998]
["Included",81,-0.35499999999999998]
[]
["Rear Suitcase Weights","370-420",null,"520+"]
["None",0,-0.35499999999999998,"None",0,-0.35499999999999998]
[10,{"$f":"43*A86","v":430},-0.35499999999999998,13,{"$f":"43*D86","v":559},-0.35499999999999998]
[15,{"$f":"43*A87","v":645},-0.35499999999999998,18,{"$f":"43*D87","v":774},-0.35499999999999998]
[]
["Rear Wheel Weights"]
["72 kg"]
["None",0,0]
["One pair",144,0]
["205 kg"]
["None",0,0]
["One pair",410,0]
["Two pairs",{"$f":"B95*2","v":820},0]
["Three pairs",{"$f":"B95*3","v":1230},0]
["Four pairs",{"$f":"B95*4","v":1640},0]
["625 kg"]
["None",0,0]
["One pair",1250,0]
[]
["Ballast packages"]
["None"]
["897A"]
["897B"]
["897C"]
["897D"]
["897E"]
["897F"]
["897G","hitch"]
["897H","hitch"]
["897J","hitch"]

{"sheet":"9RT Option Weights","index":3,"n_rows":65,"n_cols":5,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle"]
["Model",null,null,"hp","PTO-hp"]
["9470RT",18539.599999999999,0.52610000000000001,470,329]
["9520RT",18539.599999999999,0.52610000000000001,520,329]
["9570RT",18395.400000000001,0.52590000000000003,570,329]
[]
["Rear 3-Point Hitch"]
["Not Included",0,0]
["Included",1007.7,-0.23930000000000001]
[]
["Rear PTO"]
["Not Included",0,0]
["Included",604.5,-1.54E-2]
[]
["Fuel level",null,null,null,"Diesel + DEF"]
["Empty",0,0.4,null,"diesel volume of 1324 L at .85kg/L"]
["Half",{"$f":"0.5*B20","v":607.72749999999996},0.4,null,"def volume of 83 L at 1.085 kg/L"]
["Full",{"$f":"(1324*0.85)+(83*1.085)","v":1215.4549999999999},0.4]
[]
[]
["Tracks"]
["30 in, 4500 Series",1560,0.42520000000000002]
["30 in, 6500 Series",1558.7,0.42520000000000002]
["36 in, 4500 Series",1650,0.42520000000000002]
["36 in, 6500 Series",1828,0.42520000000000002]
[]
["Front Weight Support"]
["Not Included",0,0]
["Included",310.7,1.7194]
[]
["Front Suitcase Weights"]
["None",0,1.8484]
[4,{"$f":"43*A35","v":172},1.8484]
[8,{"$f":"43*A36","v":344},1.8484]
[12,516,1.8484]
[16,688,1.8484]
[20,860,1.8484]
[26,1118,1.8484]
[]
["Idler Weights"]
["36 kg"]
["None",0,1]
["One pair",72,1]
["Two pairs",144,1]
["72 kg"]
["None",0,1]
["One pair",144,1]
["Two pairs",{"$f":"144*2","v":288},1]
["205 kg"]
["None",0,1]
["One pair",410,1]
["Two pairs",{"$f":"410*2","v":820},1]
[]
["Side Weight Supports"]
["Not Included",0,0.63700000000000001]
["Included",99.3,0.63700000000000001]
[]
["Side Suitcase Weights"]
["None",0,0.63700000000000001]
["4 per side",{"$f":"43*8","v":344},0.63700000000000001]
["8 per side",{"$f":"43*16","v":688},0.63700000000000001]
["12 per side",{"$f":"43*24","v":1032},0.63700000000000001]
["16 per side",{"$f":"43*32","v":1376},0.63700000000000001]