{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Tractor","Ploughing","S-tine harrow","Instructions","Information"],"not_rendered":{"charts":7,"images":2,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Tractor","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,5,34,8]]}
[null,null,"Fill in the tractor information. The green cells are input cells. Brown cells are calculated cells."]
[null,null,"To use this model you need tractor engine or pto power curve."]
[null,null,"You can find more information at the Instructions sheet"]
[null,"Tractor"]
[null,"Model"," CASE IH CX 90 DIESEL",null,"Fuel dens.",0.84,"kg/l"]
[null,"Mass",3705,"kg","Nom. speed",{"$f":"+D14","v":2200},"1/min"]
[null,"Rear wheel radius",0.74399999999999999,"m"]
[]
[]
[null,"Engine"]
[null,"Point","Torque Nm","Eng speed 1/min","Fuel cons. l/h",null,"Fuel cons. kg/h","Spec. cons. g/kWh","Power kW"]
[null,"Mmax",319,1400,14.1,null,{"$f":"+E12*$F$5","v":11.843999999999999},{"$f":"+G12*1000/I12","v":253.25093765970561},{"$f":"+C12*(D12*2*PI()/60)/1000","v":46.767842636440044},null,"Maximum torque"]
[null,"Pmax/P80%",289,2000,18,null,15.12,{"$f":"+G13*1000/I13","v":249.80166846534163},60.528018459163341,null,"A point between the nomimal power and maximum torque or maximum power point"]
[null,"Pnim",258,2200,18.8,null,15.792,{"$f":"+G14*1000/I14","v":265.68444622697797},59.438933005918884,null,"Nominal power"]
[null,"P85",219,2272,17.5,null,14.7,{"$f":"+G15*1000/I15","v":282.12155887647856},52.105199115378873,null,"Part load, for example 85%"]
[null,"P25",54,2336,9.6,null,8.0640000000000001,{"$f":"+G16*1000/I16","v":610.45731596891369},13.209768789814362,null,"Part load, for example 25%"]
[null,"P0",0,2361,6,null,5.04,null,0,null,"High idle"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Check that the curves run smoothly"]
[null,"Transmission","Gear","Nom. speed. km/h","Ratio"]
[null,null,1,2.1,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D21*3.6","v":293.83764887975843},"In column \"Gear\" you can give the gear nomination. In nominal speed column give the nominal speed of the gear. With CVT transmissions you can give evenly spread speeds in the normal working range. Altogehter you can have 12 gears. ."]
[null,null,2,2.6,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D22*3.6","v":237.33040871057415}]
[null,null,3,3.7,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D23*3.6","v":166.77271963445753}]
[null,null,4,4.5,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D24*3.6","v":137.12423614388729}]
[null,null,5,5.5,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D25*3.6","v":112.19255684499869}]
[null,null,6,6.7,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D26*3.6","v":92.098367559327286}]
[null,null,7,8,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D27*3.6","v":77.132382830936606}]
[null,null,8,8.6999999999999993,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D28*3.6","v":70.926329039941706}]
[null,null,9,9.6,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D29*3.6","v":64.27698569244717}]
[null,null,10,10.5,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D30*3.6","v":58.767529775951701}]
[null,null,11,14,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D31*3.6","v":44.075647331963772}]
[null,null,12,16.899999999999999,{"$f":"+Tractor!$C$7*Tractor!$F$6*PI()/30/D32*3.6","v":36.51237057085757}]

{"sheet":"Ploughing","index":1,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Mounted reversible plough"]
[]
[]
[null,"Soil condition","Share width","Number of furrows","Working depth cm","Soil traficability","Slope ˚","Extra ballast kg","Weight transfer","Working width ",null,null,"Tuloksia"]
[null,null,null,{"$f":"+D8","v":3},{"$f":"+E8","v":20},null,{"$f":"+G8","v":0},{"$f":"+H8","v":501},null,{"$f":"+O10","v":1.0668},"m"]
[null,null,null,null,null,null,null,null,null,null,null,null,"f",null,{"$f":"+IF(F12=1,0.15,IF(F12=2,0.1,0.07))","v":0.1}]
[null,"Hard",12,3,20,"Poor",0,501,"No",null,null,null,"Tr kulkuvastus",null,{"$f":"+Tractor!C6*9.81/1000*O7","v":3.6346050000000005},"kN"]
[null,"Moderate",14,null,null,"Normal",null,null,"Weak",null,null,null,"Mäkivastus",null,{"$f":"+(Tractor!C6+O11)*9.81/1000*SIN(RADIANS(G8))","v":0},"kN"]
[null,"Light",16,null,null,"Good",null,null,"Good",null,null,null,"Työleveys",null,{"$f":"+(10+C12*2)*0.0254*D8","v":1.0668},"m"]
[null,null,18,null,null,null,null,null,"Excellent",null,null,null,"Auran massa",null,{"$f":"+D8*350","v":1050},"kg"]
[null,2,2,null,null,2,null,null,3]
[]
[null,"Gear","Nom. speed. km/h","Draft kN","Wheel slip %","Engine 1/min","Consumption l/h","Driving speed km/h","Work rate ha/h","Cons. l/ha",null,null,null,"Välityssuhde","Kehävoima","Akselimomentti","Moottorimom.","PA g/kWh","P kW","μ","Kehän. km/h"]
[{"$f":"+IF(F15=0,\"Engine stopped\",\" \")","v":" "},{"$f":"+Tractor!C21","v":1},{"$f":"+Tractor!D21","v":2.1},{"$f":"+kynto($B$12,C15,$O$10,$E$8/100)","v":9.3563053919999994},{"$f":"+IF(AND(F15>0,Luisto($F$12,T15)<100),Luisto($F$12,T15),\"\")","v":8.2103330655415512},{"$f":"+Piste(Tractor!$C$12:$E$17,Q15,1)","v":2345.7717032522573},{"$f":"IF(F15>1000,Piste(Tractor!$C$12:$E$16,Q15,2),\"\")","v":8.1928747316749551},{"$f":"+IF(AND(E15<100,F15>0),U15*(1-E15/100),\"\")","v":2.055304395573565},{"$f":"+IF(F15>0,H15*$O$10/10,\"\")","v":0.21925987291978793},{"$f":"+IF(F15>0,G15/I15,\"\")","v":37.366047068138926},{"$f":"+IF(ISNUMBER(E15),LOOKUP(E15,$W$15:$W$18,$X$15:$X$18),\"\")","v":"Slip OK!"},null,null,{"$f":"+Tractor!E21","v":293.83764887975843},{"$f":"+D15+$O$8+$O$9","v":12.990910392},{"$f":"+O15*Tractor!$C$7","v":9.6652373316479991},{"$f":"+P15/N15*1000","v":32.893120975124326},{"$f":"+IF(F15>0,G15*Tractor!$F$5*1000/S15,0)","v":851.71865035363101},{"$f":"+Q15*(F15*2*PI()/60)/1000","v":8.080150378002843},{"$f":"+IF(F15>0,O15/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.29291126384720434},{"$f":"+F15/N15*2*PI()/60*Tractor!$C$7*3.6","v":2.2391457167407918},null,0,"Slip OK!"]
[{"$f":"+IF(F16=0,\"Engine stopped\",\" \")","v":" "},{"$f":"+Tractor!C22","v":2},{"$f":"+Tractor!D22","v":2.6},9.5668917119999985,{"$f":"+IF(AND(F16>0,Luisto($F$12,T16)<100),Luisto($F$12,T16),\"\")","v":8.4642677028226263},{"$f":"+Piste(Tractor!$C$12:$E$17,Q16,1)","v":2341.8402883326034},{"$f":"IF(F16>1000,Piste(Tractor!$C$12:$E$16,Q16,2),\"\")","v":8.7589984801051148},{"$f":"+IF(AND(E16<100,F16>0),U16*(1-E16/100),\"\")","v":2.5333698675475023},{"$f":"+IF(F16>0,H16*$O$10/10,\"\")","v":0.27025989746996754},{"$f":"+IF(F16>0,G16/I16,\"\")","v":32.409538233760536},{"$f":"+IF(ISNUMBER(E16),LOOKUP(E16,$W$15:$W$18,$X$15:$X$18),\"\")","v":"Slip OK!"},null,null,{"$f":"+Tractor!E22","v":237.33040871057415},13.201496711999999,{"$f":"+O16*Tractor!$C$7","v":9.8219135537279989},41.384977201576731,{"$f":"+IF(F16>0,G16*Tractor!$F$5*1000/S16,0)","v":724.94511139604128},10.14912523393626,{"$f":"+IF(F16>0,O16/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.29765943801505307},{"$f":"+F16/N16*2*PI()/60*Tractor!$C$7*3.6","v":2.7676294316658043},null,20,"Rut deformation danger!"]
[" ",{"$f":"+Tractor!C23","v":3},{"$f":"+Tractor!D23","v":3.7},10.187897327999998,{"$f":"+IF(AND(F17>0,Luisto($F$12,T17)<100),Luisto($F$12,T17),\"\")","v":9.2597600376366991},{"$f":"+Piste(Tractor!$C$12:$E$17,Q17,1)","v":2333.0271370749483},{"$f":"IF(F17>1000,Piste(Tractor!$C$12:$E$16,Q17,2),\"\")","v":9.9669627673110455},3.5603997106839964,0.37982344113576871,26.241041725880034,"Slip OK!",null,null,{"$f":"+Tractor!E23","v":166.77271963445753},13.822502327999999,{"$f":"+O17*Tractor!$C$7","v":10.283941732032},61.664412228648438,{"$f":"+IF(F17>0,G17*Tractor!$F$5*1000/S17,0)","v":555.7239543261602},15.065481088885214,{"$f":"+IF(F17>0,O17/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.31166150056109204},{"$f":"+F17/N17*2*PI()/60*Tractor!$C$7*3.6","v":3.9237274578078676},null,30,"High Slip!"]
[" ",{"$f":"+Tractor!C24","v":4},{"$f":"+Tractor!D24","v":4.5},10.7757468,{"$f":"+IF(AND(F18>0,Luisto($F$12,T18)<100),Luisto($F$12,T18),\"\")","v":10.081549128381148},{"$f":"+Piste(Tractor!$C$12:$E$17,Q18,1)","v":2326.6184631978422},{"$f":"IF(F18>1000,Piste(Tractor!$C$12:$E$16,Q18,2),\"\")","v":10.758033449016366},4.2792121632284283,0.45650635357320873,23.566010340951649,"Slip OK!",null,null,{"$f":"+Tractor!E24","v":137.12423614388729},14.410351800000001,{"$f":"+O18*Tractor!$C$7","v":10.721301739200001},78.186774568063356,{"$f":"+IF(F18>0,G18*Tractor!$F$5*1000/S18,0)","v":474.37860166930585},19.049653726736512,{"$f":"+IF(F18>0,O18/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.3249159782381506},{"$f":"+F18/N18*2*PI()/60*Tractor!$C$7*3.6","v":4.7589923110864953},null,100]
[" ",{"$f":"+Tractor!C25","v":5},{"$f":"+Tractor!D25","v":5.5},11.671858800000001,{"$f":"+IF(AND(F19>0,Luisto($F$12,T19)<100),Luisto($F$12,T19),\"\")","v":11.476758690479762},{"$f":"+Piste(Tractor!$C$12:$E$17,Q19,1)","v":2317.5741515147124},{"$f":"IF(F19>1000,Piste(Tractor!$C$12:$E$16,Q19,2),\"\")","v":11.87444067240266},5.1289793966810873,0.54715952203793838,21.701972083343041,"Slip OK!",null,null,{"$f":"+Tractor!E25","v":112.19255684499869},15.306463800000001,{"$f":"+O19*Tractor!$C$7","v":11.388009067200001},101.50414062613152,{"$f":"+IF(F19>0,G19*Tractor!$F$5*1000/S19,0)","v":404.89874718932737},24.634628370816433,{"$f":"+IF(F19>0,O19/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.34512097469708131},{"$f":"+F19/N19*2*PI()/60*Tractor!$C$7*3.6","v":5.7939353787867809}]
[" ",{"$f":"+Tractor!C26","v":6},{"$f":"+Tractor!D26","v":6.7},12.983766767999999,{"$f":"+IF(AND(F20>0,Luisto($F$12,T20)<100),Luisto($F$12,T20),\"\")","v":13.874927044231816},{"$f":"+Piste(Tractor!$C$12:$E$17,Q20,1)","v":2304.873305308482},{"$f":"IF(F20>1000,Piste(Tractor!$C$12:$E$16,Q20,2),\"\")","v":13.442201375984247},6.04545207519282,0.64492882738156998,20.842922203617384,"Slip OK!",null,null,{"$f":"+Tractor!E26","v":92.098367559327286},16.618371767999999,{"$f":"+O20*Tractor!$C$7","v":12.364068595392},134.24850975156971,{"$f":"+IF(F20>0,G20*Tractor!$F$5*1000/S20,0)","v":348.46930875737303},32.40299467431322,{"$f":"+IF(F20>0,O20/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.37470108951295583},{"$f":"+F20/N20*2*PI()/60*Tractor!$C$7*3.6","v":7.0193868843485587}]
[" ",{"$f":"+Tractor!C27","v":7},{"$f":"+Tractor!D27","v":8},14.696236800000001,{"$f":"+IF(AND(F21>0,Luisto($F$12,T21)<100),Luisto($F$12,T21),\"\")","v":17.774798289477765},{"$f":"+Piste(Tractor!$C$12:$E$17,Q21,1)","v":2288.3627469809535},{"$f":"IF(F21>1000,Piste(Tractor!$C$12:$E$16,Q21,2),\"\")","v":15.480223419538563},6.8422213984492242,0.72992817878656324,21.207872047456743,"Slip OK!",null,null,{"$f":"+Tractor!E27","v":77.132382830936606},18.330841800000002,{"$f":"+O21*Tractor!$C$7","v":13.638146299200001},176.81479293972947,{"$f":"+IF(F21>0,G21*Tractor!$F$5*1000/S21,0)","v":306.89119377810624},42.371328783758869,{"$f":"+IF(F21>0,O21/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.41331283774597244},{"$f":"+F21/N21*2*PI()/60*Tractor!$C$7*3.6","v":8.3213190799307402}]
[" ",{"$f":"+Tractor!C28","v":8},{"$f":"+Tractor!D28","v":8.6999999999999993},15.743791727999998,{"$f":"+IF(AND(F22>0,Luisto($F$12,T22)<100),Luisto($F$12,T22),\"\")","v":20.682832032009191},{"$f":"+Piste(Tractor!$C$12:$E$17,Q22,1)","v":2278.0995162752588},{"$f":"IF(F22>1000,Piste(Tractor!$C$12:$E$16,Q22,2),\"\")","v":16.747090959772741},7.1455631692171311,0.76228867889208352,21.969486657093082,"Rut deformation danger!",null,null,{"$f":"+Tractor!E28","v":70.926329039941706},19.378396727999998,{"$f":"+O22*Tractor!$C$7","v":14.417527165631999},203.27468460284842,{"$f":"+IF(F22>0,G22*Tractor!$F$5*1000/S22,0)","v":290.09086932523473},48.493620081634802,{"$f":"+IF(F22>0,O22/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.43693247860646234},{"$f":"+F22/N22*2*PI()/60*Tractor!$C$7*3.6","v":9.0088480870885235}]
[" ",{"$f":"+Tractor!C29","v":9},{"$f":"+Tractor!D29","v":9.6},17.219688191999996,{"$f":"+IF(AND(F23>0,Luisto($F$12,T23)<100),Luisto($F$12,T23),\"\")","v":25.604888866328704},{"$f":"+Piste(Tractor!$C$12:$E$17,Q23,1)","v":2230.671147923541},{"$f":"IF(F23>1000,Piste(Tractor!$C$12:$E$16,Q23,2),\"\")","v":18.246215384713842},7.2414994015612786,0.77252315615855716,23.618988297315042,"Rut deformation danger!",null,null,{"$f":"+Tractor!E29","v":64.27698569244717},20.854293191999997,{"$f":"+O23*Tractor!$C$7","v":15.515594134847998},241.38646154141526,{"$f":"+IF(F23>0,G23*Tractor!$F$5*1000/S23,0)","v":271.81599342497606},56.38675167725178,{"$f":"+IF(F23>0,O23/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.47021010777432115},{"$f":"+F23/N23*2*PI()/60*Tractor!$C$7*3.6","v":9.7338377363936335}]
[" ",{"$f":"+Tractor!C30","v":10},{"$f":"+Tractor!D30","v":10.5},18.840754799999999,{"$f":"+IF(AND(F24>0,Luisto($F$12,T24)<100),Luisto($F$12,T24),\"\")","v":32.37092324833695},{"$f":"+Piste(Tractor!$C$12:$E$17,Q24,1)","v":2028.7791591222795},{"$f":"IF(F24>1000,Piste(Tractor!$C$12:$E$16,Q24,2),\"\")","v":18.11511663648912},6.5483947517126282,0.69858275211270315,25.931239472638151,"High Slip!",null,null,{"$f":"+Tractor!E30","v":58.767529775951701},22.4753598,{"$f":"+O24*Tractor!$C$7","v":16.7216676912},284.53923033604667,{"$f":"+IF(F24>0,G24*Tractor!$F$5*1000/S24,0)","v":251.71834948117944},60.451286153807338,{"$f":"+IF(F24>0,O24/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.50676094636852687},{"$f":"+F24/N24*2*PI()/60*Tractor!$C$7*3.6","v":9.6828096230836067}]
["Engine stopped",{"$f":"+Tractor!C31","v":11},{"$f":"+Tractor!D31","v":14},26.524915199999999,{"$f":"+IF(AND(F25>0,Luisto($F$12,T25)<100),Luisto($F$12,T25),\"\")","v":""},{"$f":"+Piste(Tractor!$C$12:$E$17,Q25,1)","v":0},{"$f":"IF(F25>1000,Piste(Tractor!$C$12:$E$16,Q25,2),\"\")","v":""},"","","","",null,null,{"$f":"+Tractor!E31","v":44.075647331963772},30.159520199999999,{"$f":"+O25*Tractor!$C$7","v":22.4386830288},509.09480375407691,{"$f":"+IF(F25>0,G25*Tractor!$F$5*1000/S25,0)","v":0},0,{"$f":"+IF(F25>0,O25/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0},{"$f":"+F25/N25*2*PI()/60*Tractor!$C$7*3.6","v":0}]
["Engine stopped",{"$f":"+Tractor!C32","v":12},{"$f":"+Tractor!D32","v":16.899999999999999},34.554974831999992,{"$f":"+IF(AND(F26>0,Luisto($F$12,T26)<100),Luisto($F$12,T26),\"\")","v":""},{"$f":"+Piste(Tractor!$C$12:$E$17,Q26,1)","v":0},{"$f":"IF(F26>1000,Piste(Tractor!$C$12:$E$16,Q26,2),\"\")","v":""},"","","","",null,null,{"$f":"+Tractor!E32","v":36.51237057085757},38.189579831999993,{"$f":"+O26*Tractor!$C$7","v":28.413047395007993},778.17591547139727,{"$f":"+IF(F26>0,G26*Tractor!$F$5*1000/S26,0)","v":0},0,{"$f":"+IF(F26>0,O26/((Tractor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0},{"$f":"+F26/N26*2*PI()/60*Tractor!$C$7*3.6","v":0}]
[]
[]
[]
[]
[" "]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]

{"sheet":"S-tine harrow","index":2,"n_rows":23,"n_cols":28,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"S-tine harrow"]
[]
[null,null,{"$f":"+C9","v":4.0999999999999996},{"$f":"+D6","v":10},{"$f":"+E6","v":7},null,{"$f":"+G6","v":2},{"$f":"+H6","v":0}]
[null,"Soil type","Workin width m","Row spacing cm","Working depth cm","Soil traficability","Slope ˚","Extra ballast kg",null,null,null,"Tuloksia"]
[null,null,null,null,null,null,null,null,null,null,null,"f",null,{"$f":"+IF(F9=1,0.15,IF(F9=2,0.1,0.07))","v":0.1}]
[null,"Soft soil",41,10,7,"Pehmeä",2,0,null,null,null,"Tr kulkuvastus",null,{"$f":"+Tractor!C6*9.81/1000*N5","v":3.6346050000000005},"kN"]
[null,"Hard soil",null,null,null,"Normaali",null,null,null,null,null,"Tr mäkivastus",null,{"$f":"+Tractor!C6*9.81/1000*SIN(RADIANS(G6))","v":1.2684588521239355},"kN"]
[null,null,null,null,null,"Kova",null,null,null,null,null,"Työleveys",null,{"$f":"+C9","v":4.0999999999999996},"m"]
[null,2,{"$f":"+C6/10","v":4.0999999999999996},null,null,2]
[]
[null,"Gear","Nom. speed. km/h","Draft kN","Wheel slip %","Engine 1/min","Consumption l/h","Driving speed km/h","Work rate ha/h","Consumption l/ha",null,null,null,null,null,null,null,null,null,"Vetohyötysuhde","Kehän. km/h","Välityssuhde","Kehävoima","Akselimomentti","Moottorimom.","PA g/kWh","P kW","μ"]
[{"$f":"+IF(F12=0,\"Engine stopped!\",\" \")","v":" "},{"$f":"+Tractor!C21","v":1},{"$f":"+Tractor!D21","v":2.1},{"$f":"+spiikki($B$9,C12,+$C$9/($D$6/100),$E$6,$C$9)","v":9.602568999999999},{"$f":"+IF(AND(F12>0,Luisto($F$9,AB12)<100),Luisto($F$9,AB12),\"\")","v":16.225620261427572},{"$f":"+Piste(Tractor!$C$12:$E$17,Y12,1)","v":2343.9961045900232},{"$f":"IF(F12>1000,Piste(Tractor!$C$12:$E$16,Y12,2),\"\")","v":8.4485609390366641},{"$f":"+IF(AND(E12<100,F12>0),U12*(1-E12/100),\"\")","v":1.8744105523658374},{"$f":"+IF(ISNUMBER(H12),H12*$N$8/10,\"\")","v":0.76850832646999323},{"$f":"+IF(ISNUMBER(I12),G12/I12,\"\")","v":10.993454004387475},{"$f":"+IF(ISNUMBER(E12),LOOKUP(E12,$Q$12:$Q$15,$R$12:$R$15),\"\")","v":"Slip OK!"},null,null,null,null,null,0,"Slip OK!",null,{"$f":"+(1-E12/100)*(1-$N$5/AB12)*100","v":62.783445901092129},{"$f":"+F12/V12*2*PI()/60*Tractor!$C$7*3.6","v":2.2374508271086588},{"$f":"+Tractor!E21","v":293.83764887975843},{"$f":"+D12+$N$6+$N$7","v":14.505632852123934},{"$f":"+W12*Tractor!$C$7","v":10.792190841980208},{"$f":"+X12/V12*1000","v":36.728414085549979},{"$f":"+IF(F12>0,G12*Tractor!$F$5*1000/AA12,0)","v":787.18053639757613},{"$f":"+Y12*(F12*2*PI()/60)/1000","v":9.015455617422008},{"$f":"+IF(F12>0,W12/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.39909791716359638}]
[{"$f":"+IF(F13=0,\"Engine stopped!\",\" \")","v":" "},{"$f":"+Tractor!C22","v":2},{"$f":"+Tractor!D22","v":2.6},10.100513999999997,{"$f":"+IF(AND(F13>0,Luisto($F$9,AB13)<100),Luisto($F$9,AB13),\"\")","v":17.716193120439865},{"$f":"+Piste(Tractor!$C$12:$E$17,Y13,1)","v":2339.2248761714472},{"$f":"IF(F13>1000,Piste(Tractor!$C$12:$E$16,Y13,2),\"\")","v":9.1356178313116025},{"$f":"+IF(AND(E13<100,F13>0),U13*(1-E13/100),\"\")","v":2.2747675122398245},0.93265468001832796,{"$f":"+IF(ISNUMBER(I13),G13/I13,\"\")","v":9.7952843930746969},{"$f":"+IF(ISNUMBER(E13),LOOKUP(E13,$Q$12:$Q$15,$R$12:$R$15),\"\")","v":"Slip OK!"},null,null,null,null,null,20,"Rut deformation danger!",null,62.350619019229413,{"$f":"+F13/V13*2*PI()/60*Tractor!$C$7*3.6","v":2.7645384900208017},{"$f":"+Tractor!E22","v":237.33040871057415},15.003577852123932,{"$f":"+W13*Tractor!$C$7","v":11.162661921980206},47.034267469674056,{"$f":"+IF(F13>0,G13*Tractor!$F$5*1000/AA13,0)","v":666.04294635069505},11.521657905616731,{"$f":"+IF(F13>0,W13/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.412798030380851}]
[" ",{"$f":"+Tractor!C23","v":3},{"$f":"+Tractor!D23","v":3.7},11.195992999999998,{"$f":"+IF(AND(F14>0,Luisto($F$9,AB14)<100),Luisto($F$9,AB14),\"\")","v":21.495246093766802},{"$f":"+Piste(Tractor!$C$12:$E$17,Y14,1)","v":2329.0878102761667},{"$f":"IF(F14>1000,Piste(Tractor!$C$12:$E$16,Y14,2),\"\")","v":10.453223419035663},3.0751114630701388,1.2607956998587568,8.2909732482484717,"Rut deformation danger!",null,null,null,null,null,30,"High Slip!",null,60.781121168473092,{"$f":"+F14/V14*2*PI()/60*Tractor!$C$7*3.6","v":3.9171022263735527},{"$f":"+Tractor!E23","v":166.77271963445753},16.099056852123933,{"$f":"+W14*Tractor!$C$7","v":11.977698297980206},71.820489131757554,{"$f":"+IF(F14>0,G14*Tractor!$F$5*1000/AA14,0)","v":501.26418985804287},17.517125399435848,{"$f":"+IF(F14>0,W14/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.44293827945881137}]
[" ",{"$f":"+Tractor!C24","v":4},{"$f":"+Tractor!D24","v":4.5},11.992704999999997,{"$f":"+IF(AND(F15>0,Luisto($F$9,AB15)<100),Luisto($F$9,AB15),\"\")","v":24.740756706308336},{"$f":"+Piste(Tractor!$C$12:$E$17,Y15,1)","v":2321.3878329897043},{"$f":"IF(F15>1000,Piste(Tractor!$C$12:$E$16,Y15,2),\"\")","v":11.40368936533336},3.5735296029952064,1.4651471372280345,7.7833065878341872,"Rut deformation danger!",null,null,null,null,null,100,null,null,59.069531871527978,{"$f":"+F15/V15*2*PI()/60*Tractor!$C$7*3.6","v":4.7482932947516687},{"$f":"+Tractor!E24","v":137.12423614388729},16.895768852123933,{"$f":"+W15*Tractor!$C$7","v":12.570452025980206},91.671993073418264,{"$f":"+IF(F15>0,G15*Tractor!$F$5*1000/AA15,0)","v":429.84479211741814},22.28501831950393,{"$f":"+IF(F15>0,W15/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.46485846060641883}]
[" ",{"$f":"+Tractor!C25","v":5},{"$f":"+Tractor!D25","v":5.5},12.988594999999997,{"$f":"+IF(AND(F16>0,Luisto($F$9,AB16)<100),Luisto($F$9,AB16),\"\")","v":29.495188414424334},{"$f":"+Piste(Tractor!$C$12:$E$17,Y16,1)","v":2310.9245099566965},{"$f":"IF(F16>1000,Piste(Tractor!$C$12:$E$16,Y16,2),\"\")","v":12.695255802220247},4.0732824290746414,1.6700457959206028,7.6017411218487352,"Rut deformation danger!",null,null,null,null,null,null,null,null,56.182096021246039,{"$f":"+F16/V16*2*PI()/60*Tractor!$C$7*3.6","v":5.7773112748917415},{"$f":"+Tractor!E25","v":112.19255684499869},17.891658852123932,{"$f":"+W16*Tractor!$C$7","v":13.311394185980205},118.64774776789125,{"$f":"+IF(F16>0,G16*Tractor!$F$5*1000/AA16,0)","v":371.40424800335677},28.712689559136724,{"$f":"+IF(F16>0,W16/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.49225868704092823}]
[" ",{"$f":"+Tractor!C26","v":6},{"$f":"+Tractor!D26","v":6.7},14.183662999999996,{"$f":"+IF(AND(F17>0,Luisto($F$9,AB17)<100),Luisto($F$9,AB17),\"\")","v":36.421431416712984},{"$f":"+Piste(Tractor!$C$12:$E$17,Y17,1)","v":2297.1389402271907},{"$f":"IF(F17>1000,Piste(Tractor!$C$12:$E$16,Y17,2),\"\")","v":14.396912065706175},4.4478499904501989,1.8236184960845816,7.8946951331197885,"High Slip!",null,null,null,null,null,null,null,null,51.471569564754738,{"$f":"+F17/V17*2*PI()/60*Tractor!$C$7*3.6","v":6.9958322270555362},{"$f":"+Tractor!E26","v":92.098367559327286},19.086726852123931,{"$f":"+W17*Tractor!$C$7","v":14.200524777980204},154.18866972677455,{"$f":"+IF(F17>0,G17*Tractor!$F$5*1000/AA17,0)","v":326.04706468099425},37.09098300585967,{"$f":"+IF(F17>0,W17/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.52513895876233951}]
[" ",{"$f":"+Tractor!C27","v":7},{"$f":"+Tractor!D27","v":8},15.478319999999997,{"$f":"+IF(AND(F18>0,Luisto($F$9,AB18)<100),Luisto($F$9,AB18),\"\")","v":45.771660212433432},{"$f":"+Piste(Tractor!$C$12:$E$17,Y18,1)","v":2280.6908829474355},{"$f":"IF(F18>1000,Piste(Tractor!$C$12:$E$16,Y18,2),\"\")","v":16.427219136175935},4.4973847327592269,1.8439277404312828,8.9088193512039222,"High Slip!",null,null,null,null,null,null,null,null,44.557819063182635,{"$f":"+F18/V18*2*PI()/60*Tractor!$C$7*3.6","v":8.2934213925361284},{"$f":"+Tractor!E27","v":77.132382830936606},20.381383852123932,{"$f":"+W18*Tractor!$C$7","v":15.163749585980206},196.59381740114296,{"$f":"+IF(F18>0,G18*Tractor!$F$5*1000/AA18,0)","v":293.88568776472272},46.953168013526394,{"$f":"+IF(F18>0,W18/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.56075925312720165}]
[" ",{"$f":"+Tractor!C28","v":8},{"$f":"+Tractor!D28","v":8.6999999999999993},16.175442999999994,{"$f":"+IF(AND(F19>0,Luisto($F$9,AB19)<100),Luisto($F$9,AB19),\"\")","v":51.764664385245851},{"$f":"+Piste(Tractor!$C$12:$E$17,Y19,1)","v":2268.1075180551943},{"$f":"IF(F19>1000,Piste(Tractor!$C$12:$E$16,Y19,2),\"\")","v":17.570280924003438},4.3263884904115102,1.7738192810687192,9.9053387859316828,"High Slip!",null,null,null,null,null,null,null,null,39.918029591514738,{"$f":"+F19/V19*2*PI()/60*Tractor!$C$7*3.6","v":8.9693342759455401},{"$f":"+Tractor!E28","v":70.926329039941706},21.07850685212393,{"$f":"+W19*Tractor!$C$7","v":15.682409097980203},221.10842772010315,{"$f":"+IF(F19>0,G19*Tractor!$F$5*1000/AA19,0)","v":281.03501859534839},52.516714998474477,{"$f":"+IF(F19>0,W19/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.5799394116313582}]
[" ",{"$f":"+Tractor!C29","v":9},{"$f":"+Tractor!D29","v":9.6},17.071743999999995,{"$f":"+IF(AND(F20>0,Luisto($F$9,AB20)<100),Luisto($F$9,AB20),\"\")","v":60.637010144102042},{"$f":"+Piste(Tractor!$C$12:$E$17,Y20,1)","v":2206.7268081910888},{"$f":"IF(F20>1000,Piste(Tractor!$C$12:$E$16,Y20,2),\"\")","v":18.678543740994229},3.7904013803155161,1.5540645659293615,12.019155542500958,"High Slip!",null,null,null,null,null,null,null,null,32.8524018813429,{"$f":"+F20/V20*2*PI()/60*Tractor!$C$7*3.6","v":9.6293533448338433},{"$f":"+Tractor!E29","v":64.27698569244717},21.974807852123931,{"$f":"+W20*Tractor!$C$7","v":16.349257041980206},254.35631222982684,{"$f":"+IF(F20>0,G20*Tractor!$F$5*1000/AA20,0)","v":266.93319891878855},58.778663748036273,{"$f":"+IF(F20>0,W20/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.60459961542241669}]
[" ",{"$f":"+Tractor!C30","v":10},{"$f":"+Tractor!D30","v":10.5},17.968044999999996,{"$f":"+IF(AND(F21>0,Luisto($F$9,AB21)<100),Luisto($F$9,AB21),\"\")","v":71.030055789638652},{"$f":"+Piste(Tractor!$C$12:$E$17,Y21,1)","v":1989.0113193958416},{"$f":"IF(F21>1000,Piste(Tractor!$C$12:$E$16,Y21,2),\"\")","v":17.928573576072971},2.7501192865685664,{"$f":"+IF(ISNUMBER(H21),H21*$N$8/10,\"\")","v":1.1275489074931122},15.900484189137037,"High Slip!",null,null,null,null,null,null,null,null,24.366131393173767,{"$f":"+F21/V21*2*PI()/60*Tractor!$C$7*3.6","v":9.4930085698437878},{"$f":"+Tractor!E30","v":58.767529775951701},22.871108852123932,{"$f":"+W21*Tractor!$C$7","v":17.016104985980206},289.54943403020792,{"$f":"+IF(F21>0,G21*Tractor!$F$5*1000/AA21,0)","v":249.71028530263112},60.309897870845184,{"$f":"+IF(F21>0,W21/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0.62925981921347518}]
["Engine stopped!",{"$f":"+Tractor!C31","v":11},{"$f":"+Tractor!D31","v":14},21.453659999999996,{"$f":"+IF(AND(F22>0,Luisto($F$9,AB22)<100),Luisto($F$9,AB22),\"\")","v":""},{"$f":"+Piste(Tractor!$C$12:$E$17,Y22,1)","v":0},{"$f":"IF(F22>1000,Piste(Tractor!$C$12:$E$16,Y22,2),\"\")","v":""},"",{"$f":"+IF(ISNUMBER(H22),H22*$N$8/10,\"\")","v":""},"","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F22/V22*2*PI()/60*Tractor!$C$7*3.6","v":0},{"$f":"+Tractor!E31","v":44.075647331963772},26.356723852123931,{"$f":"+W22*Tractor!$C$7","v":19.609402545980206},444.90333626386507,{"$f":"+IF(F22>0,G22*Tractor!$F$5*1000/AA22,0)","v":0},0,{"$f":"+IF(F22>0,W22/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0}]
["Engine stopped!",{"$f":"+Tractor!C32","v":12},{"$f":"+Tractor!D32","v":16.899999999999999},24.341740999999995,{"$f":"+IF(AND(F23>0,Luisto($F$9,AB23)<100),Luisto($F$9,AB23),\"\")","v":""},{"$f":"+Piste(Tractor!$C$12:$E$17,Y23,1)","v":0},{"$f":"IF(F23>1000,Piste(Tractor!$C$12:$E$16,Y23,2),\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F23/V23*2*PI()/60*Tractor!$C$7*3.6","v":0},{"$f":"+Tractor!E32","v":36.51237057085757},29.244804852123931,{"$f":"+W23*Tractor!$C$7","v":21.758134809980206},595.91131635113584,{"$f":"+IF(F23>0,G23*Tractor!$F$5*1000/AA23,0)","v":0},0,{"$f":"+IF(F23>0,W23/((Tractor!$C$6+$H$6)*9.81/1000),0)","v":0}]

{"sheet":"Instructions","index":3,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["First fill in the tractor information. Only green cells are in use. The program calculates the other needed values."]
["You can find the tractor information from test reporsts or from magazines. Altogether five points from the power curve are needed:"]
["- Mmax = maximum torque of the engine"]
["- Pmax/P80% = maximum power point if it differs from nomimal power, otherwise a point between maximum torque and nomimal power."]
["- Prated = rated (nominal) power point"]
["- P85% = point, where torque is 85% from torque at nominal power or a point near this"]
["- P25% = point, where torque is 25% from torque at nominal power or a point near this"]
["- P0 = high idle, maximum speed without load"]
[]
["Example. CASE IH CX 90 DIESEL "]
["Engine points picked from the report"]
[null,"M Nm","r/min","l/h",null,"Remark"]
["Mmax",319,1400,14.1,null,"Fuel consumption estimated using lowest specific figure of the report"]
["Pmax",289,2000,18]
["Prated",258,2200,18.8]
["P85%",219,2272,17.5]
["P25%  ",54,2336,9.6]
["P0 ",0,2361,6]
[]
[]
[]
[null,"Power calculators"]
[null,"n",2336,"1/min",null,"n",1400,"1/min",null,"n",2336,"1/min"]
[null,"P",13.3,"kW",null,"M",319,"Nm",null,"M",54,"Nm"]
[null,"Q",18.8,"l/h",null,"Q",16,"l/h",null,"Qspec",600,"g/kWh"]
[null,"M",{"$f":"+C25*1000/(C24*2*PI()/60)","v":54.368854703481375},"Nm",null,"P",55,"kW",null,"P",{"$f":"+K24*K25*PI()/30/1000","v":13.209768789814362},"kW"]
[null,"Qspec",{"$f":"+IF(C26*0.835/C25*1000<190,\"Virhe arvoissa\",C26*0.835/C25*1000)","v":1180.3007518796992},"g/kWh",null,"Qspec",{"$f":"+IF(G26*0.835/G27*1000<190,\"--\",G26*0.835/G27*1000)","v":242.90909090909091},"g/kWh",null,"Q ",{"$f":"+K26/1000/0.83*K27","v":9.5492304504682135},"l/h"]
[]
[null,"n",2336,"1/min"]
[null,"P",13.3,"kW"]
[null,"Qspec",600,"g/kWh"]
[null,"M",{"$f":"+C31*1000/(C30*PI()/30)","v":54.368854703481375},"Nm"]
[null,"Q ",{"$f":"+C31*C32/1000/0.83","v":9.6144578313253017},"l/h"]
[]
[]
[null,"Tractor test results",null,null,null,null,null,null,null,null,null,null,null,null,"http://tractortestlab.unl.edu/IH/Ih90.pdf "]
[null,"http://www2.oecd.org/agr-coddb/index_en.asp "]
[null,"http://tractortestlab.unl.edu/testreports.htm "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Ohjelma on elävää elämää yksinkertaisempi. Se ei ota huomioon esimerkiksi lisäpainojen aiheuttamaa mahdollista renkaiden uppoumaa.  Arvot myöskin lasketaan vain nelivetoiselle traktorille"]
[]
["Kommentit ja kysymykset",null,null,"jukka.ahokas@helsinki.fi "]
[]
["Lukitussalasana",null,"akatemia"]

{"sheet":"Information","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}