{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["9R-S","9RT-S","9R-S Option Weights","9RT-S Option Weights"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":78,"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-S","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[35,2,36,2],[35,4,36,4],[18,4,18,9],[27,2,27,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]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,null,null,"Model:",null,"Fuel level:",null,"Drawbar support"]
[null,null,null,null,null,null,"9470R Scraper",null,"Half",null,"Short"]
[null,null,null,null,null,null,{"$f":"INDEX(model_9_w,MATCH(G9,model_9,0))","v":13627.6},null,{"$f":"INDEX(fuel_9_w,MATCH(I9,fuel_9,0))","v":688.47749999999996},null,{"$f":"INDEX(DS_9_w,MATCH(K9,DS_9,0))","v":0}]
[null,null,null,null,null,null,{"$f":"INDEX(model_9_s,MATCH(G9,model_9,0))","v":0.73},null,{"$f":"INDEX(fuel_9_s,MATCH(I9,fuel_9,0))","v":0.152},null,{"$f":"INDEX(DS_9_s,MATCH(K9,DS_9,0))","v":0}]
[null,null,null,null,null,null,{"$f":"INDEX(hp_9,MATCH(G9,model_9,0))","v":470}]
[]
[null,null,"Name of analysis:",null,null,null,"No. of wheels:",null,"Tire size:"]
[null,null,"",null,null,null,"Duals",null,"710/70R42"]
[null,null,null,null,null,null,{"$f":"INDEX(wheels_9_w,MATCH(G15,wheels_9,0))","v":0},null,{"$f":"IF(G15=\"Singles\",INDEX(singles_9_w,MATCH(I15,singles_9,0)),IF(G15=\"Duals\",INDEX(duals_9_w,MATCH(I15,duals_9,0))))","v":5599.9610519199996}]
[null,null,null,null,null,null,{"$f":"INDEX(wheels_9_s,MATCH(G15,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,"Enter any additional ballast (kg)"]
[null,null,"Front support:",null,"Front axle:",null,"Side mount:",null,"Rear axle:",null,"Rear drawbar:"]
[null,null,0,null,0,null,0,null,0,null,0]
[null,null,{"$f":"C30","v":0},null,{"$f":"E30","v":0},null,{"$f":"G30","v":0},null,{"$f":"I30","v":0},null,{"$f":"K30","v":0}]
[null,null,1.57,null,1,null,0.6,null,0,null,-0.35499999999999998]
[]
[]
[null,null,"Total weight:",null,{"$f":"C43& \" kg       \"&ROUND(C43*2.20462,0)& \" lb\"","v":"19916 kg       43907 lb"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C$43/G$12,0)& \" kg/hp          \"& ROUND((C$43*2.20462)/G$12,0) &\" lb/hp\"","v":"42 kg/hp          93 lb/hp"}]
[]
[null,null,"Front axle weight:",null,{"$f":"E43&\" kg          \"&ROUND(E43*2.20462,0)& \" lb\"","v":"12853 kg          28336 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C43-E43&\" kg           \"&ROUND((C43-E43)*2.20462,0)& \" lb\"","v":"7063 kg           15571 lb"},null,{"$f":"G43","v":0.64500000000000002},null,{"$f":"100%-G39","v":0.35499999999999998},null,{"$f":"TODAY()","v":"2014-09-26"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(G10,I10,K10,G16,I16,C25,E25,G25,I25,K25,C31,E31,G31,I31,K31),0)","v":19916},null,{"$f":"ROUND(SUM(G10*G11,K10*K11,,I10*I11,G16*G17,I16*I17,C25*C26,E25*E26,G25*G26,I25*I26,K25*K26,C31*C32,E31*E32,G31*G32,I31*I32,K31*K32),0)","v":12853},null,{"$f":"ROUND(E43/C43,3)","v":0.64500000000000002}]

{"sheet":"9RT-S","index":1,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[7,4,7,6],[8,4,8,6],[19,2,19,4],[25,2,25,8],[33,4,34,4],[33,2,34,2],[13,2,13,4],[13,6,13,10]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Type your name:",null,"Name of analysis:",null,null,null,"Model:",null,"Fuel level:"]
[null,null,null,null,"",null,null,null,"9470RT Scraper",null,"Half"]
[null,null,null,null,"",null,null,null,{"$f":"INDEX(model_9T_w,MATCH(I9,model_9T,0))","v":19890.5},null,{"$f":"INDEX(fuel_9T_w,MATCH(K9,fuel_9T,0))","v":607.72749999999996}]
[null,null,null,null,null,null,null,null,{"$f":"INDEX(model_9T_s,MATCH(I9,model_9T,0))","v":0.52600000000000002},null,{"$f":"INDEX(fuel_9T_s,MATCH(K9,fuel_9T,0))","v":0.4}]
[null,null,null,null,"",null,null,null,{"$f":"INDEX(hp_9T,MATCH(I9,model_9T,0))","v":470}]
[null,null,null,null,""]
[null,null,"Front ballast",null,null,null,"Front idler weights"]
[null,null,"Weight support:",null,"",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(C16,FWS_9T,0))","v":0},null,{"$f":"INDEX(FSW_9T_w,MATCH(E16,FSW_9T,0))","v":0},null,{"$f":"INDEX(w36_9T_w,MATCH(G16,w36_9T,0))","v":0},null,{"$f":"INDEX(w72_9T_w,MATCH(I16,w72_9T,0))","v":0},null,{"$f":"INDEX(w205_9T_w,MATCH(K16,w205_9T,0))","v":0}]
[null,null,{"$f":"INDEX(FWS_9T_s,MATCH(C16,FWS_9T,0))","v":0},null,{"$f":"INDEX(FSW_9T_s,MATCH(E16,FSW_9T,0))","v":1.8484},null,1,null,1,null,1]
[]
[null,null,"Side ballast"]
[null,null,"Weight support:",null,"Suitcase weights:"]
[null,null,"Not Included",null,"None"]
[null,null,{"$f":"INDEX(SWS_9T_w,MATCH(C22,SWS_9T,0))","v":0},null,{"$f":"INDEX(SSW_9T_w,MATCH(E22,SSW_9T,0))","v":0}]
[null,null,{"$f":"INDEX(SWS_9T_s,MATCH(C22,SWS_9T,0))","v":0.63700000000000001},null,{"$f":"INDEX(SSW_9T_s,MATCH(E22,SSW_9T,0))","v":0.63700000000000001}]
[]
[null,null,"Enter any additional ballast (kg)"]
[null,null,"Front support:",null,"Front axle:",null,"Side support:",null,"Rear drawbar:"]
[null,null,0,null,0,null,0,null,0]
[null,null,{"$f":"C28","v":0},null,{"$f":"E28","v":0},null,{"$f":"G28","v":0},null,{"$f":"I28","v":0}]
[null,null,1.75,null,1,null,0.63700000000000001,null,-0.35499999999999998]
[]
[]
[null,null,"Total weight:",null,{"$f":"C41& \" kg       \"&ROUND(C41*2.20462,0)& \" lb\"","v":"20498 kg       45190 lb"}]
[null,null,"Weight / Engine power:",null,{"$f":"ROUND(C$41/I$12,0)& \" kg/hp          \"& ROUND((C$41*2.20462)/I$12,0) &\" lb/hp\"","v":"44 kg/hp          96 lb/hp"}]
[]
[null,null,"Front axle weight:",null,{"$f":"E41&\" kg         \"&ROUND(E41*2.20462,0)& \" lb\"","v":"10705 kg         23600 lb"}]
[null,null,"Rear axle weight:",null,{"$f":"C41-E41&\" kg           \"&ROUND((C41-E41)*2.20462,0)& \" lb\"","v":"9793 kg           21590 lb"},null,{"$f":"G41","v":0.52200000000000002},null,{"$f":"100%-G37","v":0.47799999999999998},null,{"$f":"TODAY()","v":"2014-09-26"}]
[]
[]
[]
[null,null,{"$f":"ROUND(SUM(I10,K10,C17,E17,G17,I17,K17,C23,E23,C29,E29,G29,I29),0)","v":20498},null,{"$f":"ROUND(SUM(I10*I11,K10*K11,C17*C18,E17*E18,G17*G18,I17*I18,K17*K18,C23*C24,E23*E24,C29*C30,E29*E30,G29*G30,I29*I30),0)","v":10705},null,{"$f":"ROUND(E41/C41,3)","v":0.52200000000000002}]

{"sheet":"9R-S Option Weights","index":2,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"kg total","% front axle"]
["Model",null,null,"hp"]
["9470R Scraper",13627.6,0.73,470]
["9520R Scraper",13643.9,0.73,520]
["9570R Scraper",13624.6,0.72,570]
["9620R Scraper",13624.6,0.72,620]
[]
["Drawbar Support"]
["Short",0,0]
["Long",182.9,-7.5999999999999998E-2]
[]
["Fuel level",null,null,null,"Diesel + DEF"]
["Empty",0,0,null,"diesel volume of 1514 L at .85kg/L"]
["Half",{"$f":"0.5*B17","v":688.47749999999996},0.152,null,"def volume of 83 L at 1.085 kg/L"]
["Full",{"$f":"(1514*0.85)+(83*1.085)","v":1376.9549999999999},0.16800000000000001]
[]
["No. of wheels"]
["Singles",0,0]
["Duals",0,0]
[]
["Tire size"]
["Singles"]
["76x50-32",5217.2,0.5,"76x50-32 Flotation 23-Degree Deep Tread Logger Tire in Single Configuration"]
["Duals"]
["620/70R42",4739.9045022800001,0.5]
["620/70R46",4879.9284761600002,0.5]
["650/85R38",5060,0.5]
["IF650/85R38",5539.9507774000003,0.5]
["710/70R38",5199.9379143599999,0.5]
["IF710/70R38",5262.3,0.5]
["710/70R42",5599.9610519199996,0.5]
["IF710/70R42",5879.9182811999999,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*A42","v":344},1.581]
[16,{"$f":"43*A43","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":"B53*2","v":820},1]
["Three pairs",{"$f":"B53*3","v":1230},1]
["625 kg"]
["None",0,1]
["One pair",1250,1]
[]
["Ballast packages"]
["None"]
[8982]

{"sheet":"9RT-S Option Weights","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"% front axle"]
["Model",null,null,"hp"]
["9470RT Scraper",19890.5,0.52600000000000002,470]
["9520RT Scraper",19890.5,0.52600000000000002,520]
["9570RT Scraper",19746.2,0.52500000000000002,570]
[]
["Fuel level",null,null,null,"Diesel + DEF"]
["Empty",0,0.4,null,"diesel volume of 1324 L at .85kg/L"]
["Half",{"$f":"0.5*B12","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, 6500 Series",1600,0.42520000000000002,"Update for scraper tracks and add to base weight"]
[]
["Front Weight Support"]
["Not Included",0,0]
["Included",310.7,1.7194]
[]
["Front Suitcase Weights"]
["None",0,1.8484]
[4,{"$f":"43*A23","v":172},1.8484]
[8,{"$f":"43*A24","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]