{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Traktor","Künd","Kultivaator","Instruktsioon","Sheet1"],"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":"Traktor","index":0,"n_rows":32,"n_cols":12,"rows_kept":32,"cut":false,"hidden":false,"merged":[[20,5,34,8]]}
[null,null,"Sisesta traktori andmed rohelistesse lahtritesse. Pruuni värvi lahtrid arvutatakse automaatselt."]
[null,null,"Arvutusmudeli kasutamiseks on vaja traktori mootori või jõuvõtuvõlli (PTO) võimsuskõverat."]
[null,null,"Täiendav informatsioon instruktsiooni lehelt."]
[null,"Traktor"]
[null,"Mudel"," CASE IH CX 90 DIESEL",null,"Kütuse tihedus",0.84,"kg/l"]
[null,"Mass",3705,"kg","Nimipöörded",{"$f":"+D14","v":2200},"1/min"]
[null,"Tagaratta raadius",0.74399999999999999,"m"]
[]
[]
[null,"Mootor"]
[null,"Näitaja","Pöördem. Nm","Moot. Pöörded, 1/min","Kütusekulu, l/h",null,"Kütusekulu, kg/h","Kütuse erikulu, g/kWh","Võimsus, 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,"Suurim pöördemoment."]
[null,"Pmax/P80%",289,2000,18,null,15.12,{"$f":"+G13*1000/I13","v":249.80166846534163},60.528018459163341,null,"Punkt nimivõimsuse ja suurima pöördemomendi või suurima võimsusmomendi vahel."]
[null,"Pnim",258,2200,18.8,null,15.792,{"$f":"+G14*1000/I14","v":265.68444622697797},59.438933005918884,null,"Nimivõimsus."]
[null,"P85",219,2272,17.5,null,14.7,{"$f":"+G15*1000/I15","v":282.12155887647856},52.105199115378873,null,"Osakoormus, näiteks 85% juures."]
[null,"P25",54,2336,9.6,null,8.0640000000000001,{"$f":"+G16*1000/I16","v":610.45731596891369},13.209768789814362,null,"Osakoormus, näiteks 25% juures."]
[null,"P0",0,2361,6,null,5.04,null,0,null,"Maksimumpööretel ilma koormuseta."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Kontrolli, et kõverad oleksid sujuvad."]
[null,"Jõuülekanne","Käik","Nimikiirus, km/h","Suhe"]
[null,null,1,2.1,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D21*3.6","v":293.83764887975843},"Veerus „käik“ saate anda käikude nimiväärtused. „Nimikiirus“ veergu kirjutage käikudele vastavad nimikiirused. Ühtlaselt muutuva kiirusega käigukastiga (CVT) saate anda ühtlaselt jagatud väärtused normaalses tööpiirkonnas. Kokku saate 12 käiku.."]
[null,null,2,2.6,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D22*3.6","v":237.33040871057415}]
[null,null,3,3.7,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D23*3.6","v":166.77271963445753}]
[null,null,4,4.5,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D24*3.6","v":137.12423614388729}]
[null,null,5,5.5,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D25*3.6","v":112.19255684499869}]
[null,null,6,6.7,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D26*3.6","v":92.098367559327286}]
[null,null,7,8,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D27*3.6","v":77.132382830936606}]
[null,null,8,8.6999999999999993,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D28*3.6","v":70.926329039941706}]
[null,null,9,9.6,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D29*3.6","v":64.27698569244717}]
[null,null,10,10.5,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D30*3.6","v":58.767529775951701}]
[null,null,11,14,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D31*3.6","v":44.075647331963772}]
[null,null,12,16.899999999999999,{"$f":"+Traktor!$C$7*Traktor!$F$6*PI()/30/D32*3.6","v":36.51237057085757}]

{"sheet":"Künd","index":1,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kinnitatud pöördader"]
[]
[]
[null,"Mulla seisund","Vannaste vahe \"(toll)","Vagude arv","Töösügavus, cm","Mullal sõidetavus","Kalle ˚","Lisaraskus, kg","Kaalujaotus","Töölaius ",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,"Raske",12,3,20,"Halb",0,501,"Puudub",null,null,null,"Tr kulkuvastus",null,{"$f":"+Traktor!C6*9.81/1000*O7","v":3.6346050000000005},"kN"]
[null,"Keskmine",14,null,null,"Normaalne",null,null,"Nõrk",null,null,null,"Mäkivastus",null,{"$f":"+(Traktor!C6+O11)*9.81/1000*SIN(RADIANS(G8))","v":0},"kN"]
[null,"Kerge",16,null,null,"Hea",null,null,"Hea",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,"Suurepärane",null,null,null,"Auran massa",null,{"$f":"+D8*350","v":1050},"kg"]
[null,2,2,null,null,2,null,null,2]
[]
[null,"Käik","Nimikiirus, km/h","Vajalik veojõud kN","Nühamus, %","Moot. Pöörded, 1/min","Kütusekulu, l/h","Liikumiskiirus, km/h","Jõudlus, ha/h","Kütusekulu, l/ha",null,null,null,"Välityssuhde","Kehävoima","Akselimomentti","Moottorimom.","PA g/kWh","P kW","μ","Kehän. km/h"]
[{"$f":"+IF(F15=0,\"Mootor seisukus!\",\" \")","v":" "},{"$f":"+Traktor!C21","v":1},{"$f":"+Traktor!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.7865114306869909},{"$f":"+Piste(Traktor!$C$12:$E$17,Q15,1)","v":2345.7717032522573},{"$f":"IF(F15>1000,Piste(Traktor!$C$12:$E$16,Q15,2),\"\")","v":8.1928747316749551},{"$f":"+IF(AND(E15<100,F15>0),U15*(1-E15/100),\"\")","v":2.0424029223896238},{"$f":"+IF(F15>0,H15*$O$10/10,\"\")","v":0.21788354376052504},{"$f":"+IF(F15>0,G15/I15,\"\")","v":37.602081324139434},{"$f":"+IF(ISNUMBER(E15),LOOKUP(E15,$W$15:$W$18,$X$15:$X$18),\"\")","v":"Nühamus OK!"},null,null,{"$f":"+Traktor!E21","v":293.83764887975843},{"$f":"+D15+$O$8+$O$9","v":12.990910392},{"$f":"+O15*Traktor!$C$7","v":9.6652373316479991},{"$f":"+P15/N15*1000","v":32.893120975124326},{"$f":"+IF(F15>0,G15*Traktor!$F$5*1000/S15,0)","v":851.71865035363101},{"$f":"+Q15*(F15*2*PI()/60)/1000","v":8.080150378002843},{"$f":"+IF(F15>0,O15/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.30348386017032447},{"$f":"+F15/N15*2*PI()/60*Traktor!$C$7*3.6","v":2.2391457167407918},null,0,"Nühamus OK!"]
[{"$f":"+IF(F16=0,\"Mootor seisukus!\",\" \")","v":" "},{"$f":"+Traktor!C22","v":2},{"$f":"+Traktor!D22","v":2.6},9.5668917119999985,{"$f":"+IF(AND(F16>0,Luisto($F$12,T16)<100),Luisto($F$12,T16),\"\")","v":9.068231087032002},{"$f":"+Piste(Traktor!$C$12:$E$17,Q16,1)","v":2341.8402883326034},{"$f":"IF(F16>1000,Piste(Traktor!$C$12:$E$16,Q16,2),\"\")","v":8.7589984801051148},{"$f":"+IF(AND(E16<100,F16>0),U16*(1-E16/100),\"\")","v":2.5166543991696386},{"$f":"+IF(F16>0,H16*$O$10/10,\"\")","v":0.268476691303417},{"$f":"+IF(F16>0,G16/I16,\"\")","v":32.624800453184207},{"$f":"+IF(ISNUMBER(E16),LOOKUP(E16,$W$15:$W$18,$X$15:$X$18),\"\")","v":"Nühamus OK!"},null,null,{"$f":"+Traktor!E22","v":237.33040871057415},13.201496711999999,{"$f":"+O16*Traktor!$C$7","v":9.8219135537279989},41.384977201576731,{"$f":"+IF(F16>0,G16*Traktor!$F$5*1000/S16,0)","v":724.94511139604128},10.14912523393626,{"$f":"+IF(F16>0,O16/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.30840341910531793},{"$f":"+F16/N16*2*PI()/60*Traktor!$C$7*3.6","v":2.7676294316658043},null,20,"Rööbaste tekke oht!"]
[" ",{"$f":"+Traktor!C23","v":3},{"$f":"+Traktor!D23","v":3.7},10.187897327999998,{"$f":"+IF(AND(F17>0,Luisto($F$12,T17)<100),Luisto($F$12,T17),\"\")","v":9.9527018464107435},{"$f":"+Piste(Traktor!$C$12:$E$17,Q17,1)","v":2333.0271370749483},{"$f":"IF(F17>1000,Piste(Traktor!$C$12:$E$16,Q17,2),\"\")","v":9.9669627673110455},3.5332105626664982,0.37692290282526203,26.442974657689181,{"$f":"+IF(ISNUMBER(E17),LOOKUP(E17,$W$15:$W$18,$X$15:$X$18),\"\")","v":"Nühamus OK!"},null,null,{"$f":"+Traktor!E23","v":166.77271963445753},13.822502327999999,{"$f":"+O17*Traktor!$C$7","v":10.283941732032},61.664412228648438,{"$f":"+IF(F17>0,G17*Traktor!$F$5*1000/S17,0)","v":555.7239543261602},15.065481088885214,{"$f":"+IF(F17>0,O17/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.32291088439021359},{"$f":"+F17/N17*2*PI()/60*Traktor!$C$7*3.6","v":3.9237274578078676},null,30,"Suur nühamus!"]
[" ",{"$f":"+Traktor!C24","v":4},{"$f":"+Traktor!D24","v":4.5},10.7757468,{"$f":"+IF(AND(F18>0,Luisto($F$12,T18)<100),Luisto($F$12,T18),\"\")","v":10.869296292736905},{"$f":"+Piste(Traktor!$C$12:$E$17,Q18,1)","v":2326.6184631978422},{"$f":"IF(F18>1000,Piste(Traktor!$C$12:$E$16,Q18,2),\"\")","v":10.758033449016366},4.2417233362459363,0.45250704551071647,23.774289385648007,"Nühamus OK!",null,null,{"$f":"+Traktor!E24","v":137.12423614388729},14.410351800000001,{"$f":"+O18*Traktor!$C$7","v":10.721301739200001},78.186774568063356,{"$f":"+IF(F18>0,G18*Traktor!$F$5*1000/S18,0)","v":474.37860166930585},19.049653726736512,{"$f":"+IF(F18>0,O18/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.33664378082151458},{"$f":"+F18/N18*2*PI()/60*Traktor!$C$7*3.6","v":4.7589923110864953},null,100]
[" ",{"$f":"+Traktor!C25","v":5},{"$f":"+Traktor!D25","v":5.5},11.671858800000001,{"$f":"+IF(AND(F19>0,Luisto($F$12,T19)<100),Luisto($F$12,T19),\"\")","v":12.43154937479054},{"$f":"+Piste(Traktor!$C$12:$E$17,Q19,1)","v":2317.5741515147124},{"$f":"IF(F19>1000,Piste(Traktor!$C$12:$E$16,Q19,2),\"\")","v":11.87444067240266},5.0736594414294451,0.54125798921169321,21.938596582559462,"Nühamus OK!",null,null,{"$f":"+Traktor!E25","v":112.19255684499869},15.306463800000001,{"$f":"+O19*Traktor!$C$7","v":11.388009067200001},101.50414062613152,{"$f":"+IF(F19>0,G19*Traktor!$F$5*1000/S19,0)","v":404.89874718932737},24.634628370816433,{"$f":"+IF(F19>0,O19/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.35757807416191234},{"$f":"+F19/N19*2*PI()/60*Traktor!$C$7*3.6","v":5.7939353787867809}]
[" ",{"$f":"+Traktor!C26","v":6},{"$f":"+Traktor!D26","v":6.7},12.983766767999999,{"$f":"+IF(AND(F20>0,Luisto($F$12,T20)<100),Luisto($F$12,T20),\"\")","v":15.132523209150678},{"$f":"+Piste(Traktor!$C$12:$E$17,Q20,1)","v":2304.873305308482},{"$f":"IF(F20>1000,Piste(Traktor!$C$12:$E$16,Q20,2),\"\")","v":13.442201375984247},5.9571765349344341,0.63551159274680535,21.15177996656902,"Nühamus OK!",null,null,{"$f":"+Traktor!E26","v":92.098367559327286},16.618371767999999,{"$f":"+O20*Traktor!$C$7","v":12.364068595392},134.24850975156971,{"$f":"+IF(F20>0,G20*Traktor!$F$5*1000/S20,0)","v":348.46930875737303},32.40299467431322,{"$f":"+IF(F20>0,O20/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.38822587961225463},{"$f":"+F20/N20*2*PI()/60*Traktor!$C$7*3.6","v":7.0193868843485587}]
[" ",{"$f":"+Traktor!C27","v":7},{"$f":"+Traktor!D27","v":8},14.696236800000001,{"$f":"+IF(AND(F21>0,Luisto($F$12,T21)<100),Luisto($F$12,T21),\"\")","v":19.559970293020108},{"$f":"+Piste(Traktor!$C$12:$E$17,Q21,1)","v":2288.3627469809535},{"$f":"IF(F21>1000,Piste(Traktor!$C$12:$E$16,Q21,2),\"\")","v":15.480223419538563},6.6936715399088742,0.7140808798774787,21.678529499620048,"Nühamus OK!",null,null,{"$f":"+Traktor!E27","v":77.132382830936606},18.330841800000002,{"$f":"+O21*Traktor!$C$7","v":13.638146299200001},176.81479293972947,{"$f":"+IF(F21>0,G21*Traktor!$F$5*1000/S21,0)","v":306.89119377810624},42.371328783758869,{"$f":"+IF(F21>0,O21/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.42823131418575483},{"$f":"+F21/N21*2*PI()/60*Traktor!$C$7*3.6","v":8.3213190799307402}]
[" ",{"$f":"+Traktor!C28","v":8},{"$f":"+Traktor!D28","v":8.6999999999999993},15.743791727999998,{"$f":"+IF(AND(F22>0,Luisto($F$12,T22)<100),Luisto($F$12,T22),\"\")","v":22.884885823502259},{"$f":"+Piste(Traktor!$C$12:$E$17,Q22,1)","v":2278.0995162752588},{"$f":"IF(F22>1000,Piste(Traktor!$C$12:$E$16,Q22,2),\"\")","v":16.747090959772741},6.9471834883455479,0.74112553453670305,22.596834381427414,"Rööbaste tekke oht!",null,null,{"$f":"+Traktor!E28","v":70.926329039941706},19.378396727999998,{"$f":"+O22*Traktor!$C$7","v":14.417527165631999},203.27468460284842,{"$f":"+IF(F22>0,G22*Traktor!$F$5*1000/S22,0)","v":290.09086932523473},48.493620081634802,{"$f":"+IF(F22>0,O22/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.45270350310067975},{"$f":"+F22/N22*2*PI()/60*Traktor!$C$7*3.6","v":9.0088480870885235}]
[" ",{"$f":"+Traktor!C29","v":9},{"$f":"+Traktor!D29","v":9.6},17.219688191999996,{"$f":"+IF(AND(F23>0,Luisto($F$12,T23)<100),Luisto($F$12,T23),\"\")","v":28.550130693275335},{"$f":"+Piste(Traktor!$C$12:$E$17,Q23,1)","v":2230.671147923541},{"$f":"IF(F23>1000,Piste(Traktor!$C$12:$E$16,Q23,2),\"\")","v":18.246215384713842},6.9548143411818977,0.74193959391728481,24.592588849959697,"Rööbaste tekke oht!",null,null,{"$f":"+Traktor!E29","v":64.27698569244717},20.854293191999997,{"$f":"+O23*Traktor!$C$7","v":15.515594134847998},241.38646154141526,{"$f":"+IF(F23>0,G23*Traktor!$F$5*1000/S23,0)","v":271.81599342497606},56.38675167725178,{"$f":"+IF(F23>0,O23/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.48718228423231486},{"$f":"+F23/N23*2*PI()/60*Traktor!$C$7*3.6","v":9.7338377363936335}]
[" ",{"$f":"+Traktor!C30","v":10},{"$f":"+Traktor!D30","v":10.5},18.840754799999999,{"$f":"+IF(AND(F24>0,Luisto($F$12,T24)<100),Luisto($F$12,T24),\"\")","v":36.401217701850982},{"$f":"+Piste(Traktor!$C$12:$E$17,Q24,1)","v":2028.7791591222795},{"$f":"IF(F24>1000,Piste(Traktor!$C$12:$E$16,Q24,2),\"\")","v":18.11511663648912},6.158149012529166,0.65695133665661143,27.574518272055659,"Suur nühamus!",null,null,{"$f":"+Traktor!E30","v":58.767529775951701},22.4753598,{"$f":"+O24*Traktor!$C$7","v":16.7216676912},284.53923033604667,{"$f":"+IF(F24>0,G24*Traktor!$F$5*1000/S24,0)","v":251.71834948117944},60.451286153807338,{"$f":"+IF(F24>0,O24/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.52505242088509452},{"$f":"+F24/N24*2*PI()/60*Traktor!$C$7*3.6","v":9.6828096230836067}]
[{"$f":"+IF(F25=0,\"Mootor seiskus!\",\" \")","v":"Mootor seiskus!"},{"$f":"+Traktor!C31","v":11},{"$f":"+Traktor!D31","v":14},26.524915199999999,{"$f":"+IF(AND(F25>0,Luisto($F$12,T25)<100),Luisto($F$12,T25),\"\")","v":""},{"$f":"+Piste(Traktor!$C$12:$E$17,Q25,1)","v":0},{"$f":"IF(F25>1000,Piste(Traktor!$C$12:$E$16,Q25,2),\"\")","v":""},"","","","",null,null,{"$f":"+Traktor!E31","v":44.075647331963772},30.159520199999999,{"$f":"+O25*Traktor!$C$7","v":22.4386830288},509.09480375407691,{"$f":"+IF(F25>0,G25*Traktor!$F$5*1000/S25,0)","v":0},0,{"$f":"+IF(F25>0,O25/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0},{"$f":"+F25/N25*2*PI()/60*Traktor!$C$7*3.6","v":0}]
[{"$f":"+IF(F26=0,\"Mootor seiskus!\",\" \")","v":"Mootor seiskus!"},{"$f":"+Traktor!C32","v":12},{"$f":"+Traktor!D32","v":16.899999999999999},34.554974831999992,{"$f":"+IF(AND(F26>0,Luisto($F$12,T26)<100),Luisto($F$12,T26),\"\")","v":""},{"$f":"+Piste(Traktor!$C$12:$E$17,Q26,1)","v":0},{"$f":"IF(F26>1000,Piste(Traktor!$C$12:$E$16,Q26,2),\"\")","v":""},"","","","",null,null,{"$f":"+Traktor!E32","v":36.51237057085757},38.189579831999993,{"$f":"+O26*Traktor!$C$7","v":28.413047395007993},778.17591547139727,{"$f":"+IF(F26>0,G26*Traktor!$F$5*1000/S26,0)","v":0},0,{"$f":"+IF(F26>0,O26/((Traktor!$C$6+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0},{"$f":"+F26/N26*2*PI()/60*Traktor!$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":"Kultivaator","index":2,"n_rows":23,"n_cols":28,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"S-piiga kultivaator"]
[]
[null,null,{"$f":"+C9","v":4.8},{"$f":"+D6","v":11},{"$f":"+E6","v":10},null,{"$f":"+G6","v":2},{"$f":"+H6","v":937}]
[null,"Mulla seisund","Töölaius, m","Reavahe, cm","Töösügavus, cm","Mullal sõidetavus","Kalle ˚","Lisaraskus, 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,"Kerge muld",48,11,10,"Halb",2,937,null,null,null,"Tr kulkuvastus",null,{"$f":"+Traktor!C6*9.81/1000*N5","v":3.6346050000000005},"kN"]
[null,"Raske muld",null,null,null,"Normaalne",null,null,null,null,null,"Tr mäkivastus",null,{"$f":"+Traktor!C6*9.81/1000*SIN(RADIANS(G6))","v":1.2684588521239355},"kN"]
[null,null,null,null,null,"Hea",null,null,null,null,null,"Työleveys",null,{"$f":"+C9","v":4.8},"m"]
[null,1,{"$f":"+C6/10","v":4.8},null,null,2]
[]
[null,"Käik","Nimikiirus km/h","Vajalik veojõud kN","Nühamus %","Pöörded 1/min","Kütusekulu l/h","Liikumiskiirus km/h","Jõudlus ha/h","Kütusekulu 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,\"Mootor seiskus!\",\" \")","v":" "},{"$f":"+Traktor!C21","v":1},{"$f":"+Traktor!D21","v":2.1},{"$f":"+spiikki($B$9,C12,+$C$9/($D$6/100),$E$6,$C$9)","v":11.843345454545453},{"$f":"+IF(AND(F12>0,Luisto($F$9,AB12)<100),Luisto($F$9,AB12),\"\")","v":13.269439879057037},{"$f":"+Piste(Traktor!$C$12:$E$17,Y12,1)","v":2341.3694057855892},{"$f":"IF(F12>1000,Piste(Traktor!$C$12:$E$16,Y12,2),\"\")","v":8.826805566875132},{"$f":"+IF(AND(E12<100,F12>0),U12*(1-E12/100),\"\")","v":1.9383790364955886},{"$f":"+IF(ISNUMBER(H12),H12*$N$8/10,\"\")","v":0.93042193751788249},{"$f":"+IF(ISNUMBER(I12),G12/I12,\"\")","v":9.4868846175560897},{"$f":"+IF(ISNUMBER(E12),LOOKUP(E12,$Q$12:$Q$15,$R$12:$R$15),\"\")","v":"Nühamus OK!"},null,null,null,null,null,0,"Nühamus OK!",null,{"$f":"+(1-E12/100)*(1-$N$5/AB12)*100","v":63.14617310953885},{"$f":"+F12/V12*2*PI()/60*Traktor!$C$7*3.6","v":2.2349435237044264},{"$f":"+Traktor!E21","v":293.83764887975843},{"$f":"+D12+$N$6+$N$7","v":16.746409306669388},{"$f":"+W12*Traktor!$C$7","v":12.459328524162025},{"$f":"+X12/V12*1000","v":42.402083503126981},{"$f":"+IF(F12>0,G12*Traktor!$F$5*1000/AA12,0)","v":713.17661153584709},{"$f":"+Y12*(F12*2*PI()/60)/1000","v":10.396466395901189},{"$f":"+IF(F12>0,W12/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.36774566190338065}]
[{"$f":"+IF(F13=0,\"Mootor seiskus!\",\" \")","v":" "},{"$f":"+Traktor!C22","v":2},{"$f":"+Traktor!D22","v":2.6},12.020072727272726,{"$f":"+IF(AND(F13>0,Luisto($F$9,AB13)<100),Luisto($F$9,AB13),\"\")","v":13.603945028875392},{"$f":"+Piste(Traktor!$C$12:$E$17,Y13,1)","v":2336.4389654110596},{"$f":"IF(F13>1000,Piste(Traktor!$C$12:$E$16,Y13,2),\"\")","v":9.5367889808073958},{"$f":"+IF(AND(E13<100,F13>0),U13*(1-E13/100),\"\")","v":2.3856076552730081},1.1450916745310438,{"$f":"+IF(ISNUMBER(I13),G13/I13,\"\")","v":8.3284065310430755},{"$f":"+IF(ISNUMBER(E13),LOOKUP(E13,$Q$12:$Q$15,$R$12:$R$15),\"\")","v":"Nühamus OK!"},null,null,null,null,null,20,"Rööbaste tekke oht!",null,63.147969365137989,{"$f":"+F13/V13*2*PI()/60*Traktor!$C$7*3.6","v":2.7612460500312528},{"$f":"+Traktor!E22","v":237.33040871057415},16.923136579396662,{"$f":"+W13*Traktor!$C$7","v":12.590813615071117},53.051834712110953,{"$f":"+IF(F13>0,G13*Traktor!$F$5*1000/AA13,0)","v":617.16031624808556},12.980262231666233,{"$f":"+IF(F13>0,W13/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.371626534912951}]
[" ",{"$f":"+Traktor!C23","v":3},{"$f":"+Traktor!D23","v":3.7},12.408872727272726,{"$f":"+IF(AND(F14>0,Luisto($F$9,AB14)<100),Luisto($F$9,AB14),\"\")","v":14.369838206436684},{"$f":"+Piste(Traktor!$C$12:$E$17,Y14,1)","v":2326.9890555295906},{"$f":"IF(F14>1000,Piste(Traktor!$C$12:$E$16,Y14,2),\"\")","v":10.712288458066158},3.3511984657833849,1.6085752635760246,6.6594884930977143,"Nühamus OK!",null,null,null,null,null,30,"Suur nühamus!",null,63.105656793935935,{"$f":"+F14/V14*2*PI()/60*Traktor!$C$7*3.6","v":3.9135725024815837},{"$f":"+Traktor!E23","v":166.77271963445753},17.311936579396662,{"$f":"+W14*Traktor!$C$7","v":12.880080815071116},77.231341212774197,{"$f":"+IF(F14>0,G14*Traktor!$F$5*1000/AA14,0)","v":478.12891568440472},18.81986637828663,{"$f":"+IF(F14>0,W14/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.38016445553400569}]
[" ",{"$f":"+Traktor!C24","v":4},{"$f":"+Traktor!D24","v":4.5},12.691636363636363,{"$f":"+IF(AND(F15>0,Luisto($F$9,AB15)<100),Luisto($F$9,AB15),\"\")","v":14.953798419032815},{"$f":"+Piste(Traktor!$C$12:$E$17,Y15,1)","v":2319.9169122438575},{"$f":"IF(F15>1000,Piste(Traktor!$C$12:$E$16,Y15,2),\"\")","v":11.58525614489886},4.0356843007456247,1.9371284643578999,5.9806338908653771,"Nühamus OK!",null,null,null,null,null,100,null,null,63.034825535758657,{"$f":"+F15/V15*2*PI()/60*Traktor!$C$7*3.6","v":4.7452845932260725},{"$f":"+Traktor!E24","v":137.12423614388729},17.594700215760298,{"$f":"+W15*Traktor!$C$7","v":13.090456960525662},95.464210621305313,{"$f":"+IF(F15>0,G15*Traktor!$F$5*1000/AA15,0)","v":419.60754787928613},23.192183293410778,{"$f":"+IF(F15>0,W15/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.38637385234931815}]
[" ",{"$f":"+Traktor!C25","v":5},{"$f":"+Traktor!D25","v":5.5},13.045090909090909,{"$f":"+IF(AND(F16>0,Luisto($F$9,AB16)<100),Luisto($F$9,AB16),\"\")","v":15.717232459450205},{"$f":"+Piste(Traktor!$C$12:$E$17,Y16,1)","v":2310.7791911171607},{"$f":"IF(F16>1000,Piste(Traktor!$C$12:$E$16,Y16,2),\"\")","v":12.71319359647547},4.8689716350616843,2.3371063848296085,5.439715401488816,"Nühamus OK!",null,null,null,null,null,null,null,null,62.898561726753243,{"$f":"+F16/V16*2*PI()/60*Traktor!$C$7*3.6","v":5.7769479777929025},{"$f":"+Traktor!E25","v":112.19255684499869},17.948154761214845,{"$f":"+W16*Traktor!$C$7","v":13.353427142343845},119.02239790106997,{"$f":"+IF(F16>0,G16*Traktor!$F$5*1000/AA16,0)","v":370.78160920396419},28.801543431365044,{"$f":"+IF(F16>0,W16/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.39413559836845879}]
[" ",{"$f":"+Traktor!C26","v":6},{"$f":"+Traktor!D26","v":6.7},13.469236363636362,{"$f":"+IF(AND(F17>0,Luisto($F$9,AB17)<100),Luisto($F$9,AB17),\"\")","v":16.684974294537469},{"$f":"+Piste(Traktor!$C$12:$E$17,Y17,1)","v":2299.3775308031477},{"$f":"IF(F17>1000,Piste(Traktor!$C$12:$E$16,Y17,2),\"\")","v":14.120586041486478},5.8342594416925557,2.8004445320124267,5.0422659260239966,"Nühamus OK!",null,null,null,null,null,null,null,null,62.664365405337122,{"$f":"+F17/V17*2*PI()/60*Traktor!$C$7*3.6","v":7.0026497529004947},{"$f":"+Traktor!E26","v":92.098367559327286},18.372300215760298,{"$f":"+W17*Traktor!$C$7","v":13.668991360525661},148.41730339813529,{"$f":"+IF(F17>0,G17*Traktor!$F$5*1000/AA17,0)","v":331.90100675513509},35.737439879474316,{"$f":"+IF(F17>0,W17/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.40344969359142746}]
[" ",{"$f":"+Traktor!C27","v":7},{"$f":"+Traktor!D27","v":8},13.928727272727272,{"$f":"+IF(AND(F18>0,Luisto($F$9,AB18)<100),Luisto($F$9,AB18),\"\")","v":17.800715649584944},{"$f":"+Piste(Traktor!$C$12:$E$17,Y18,1)","v":2286.4885034832596},{"$f":"IF(F18>1000,Piste(Traktor!$C$12:$E$16,Y18,2),\"\")","v":15.711575351285148},6.8344624967918346,3.2805419984600803,4.7893230321880713,"Nühamus OK!",null,null,null,null,null,null,null,null,62.322297451408851,{"$f":"+F18/V18*2*PI()/60*Traktor!$C$7*3.6","v":8.3145036490300352},{"$f":"+Traktor!E27","v":77.132382830936606},18.831791124851208,{"$f":"+W18*Traktor!$C$7","v":14.010852596889299},181.64682695722144,{"$f":"+IF(F18>0,G18*Traktor!$F$5*1000/AA18,0)","v":303.44051213369204},43.493610007040772,{"$f":"+IF(F18>0,W18/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.41353996341631027}]
[" ",{"$f":"+Traktor!C28","v":8},{"$f":"+Traktor!D28","v":8.6999999999999993},14.176145454545454,{"$f":"+IF(AND(F19>0,Luisto($F$9,AB19)<100),Luisto($F$9,AB19),\"\")","v":18.432092912819975},{"$f":"+Piste(Traktor!$C$12:$E$17,Y19,1)","v":2279.3168364325743},{"$f":"IF(F19>1000,Piste(Traktor!$C$12:$E$16,Y19,2),\"\")","v":16.596828002854103},7.3522554738476487,3.5290826274468712,4.7028731698643007,"Nühamus OK!",null,null,null,null,null,null,null,null,62.099380249457703,{"$f":"+F19/V19*2*PI()/60*Traktor!$C$7*3.6","v":9.013662034983362},{"$f":"+Traktor!E28","v":70.926329039941706},19.079209306669391,{"$f":"+W19*Traktor!$C$7","v":14.194931724162027},200.13628107226927,{"$f":"+IF(F19>0,G19*Traktor!$F$5*1000/AA19,0)","v":291.840282769868},47.77042905139642,{"$f":"+IF(F19>0,W19/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.41897318562970876}]
[" ",{"$f":"+Traktor!C29","v":9},{"$f":"+Traktor!D29","v":9.6},14.494254545454545,{"$f":"+IF(AND(F20>0,Luisto($F$9,AB20)<100),Luisto($F$9,AB20),\"\")","v":19.276880273374314},{"$f":"+Piste(Traktor!$C$12:$E$17,Y20,1)","v":2261.8053228707836},{"$f":"IF(F20>1000,Piste(Traktor!$C$12:$E$16,Y20,2),\"\")","v":17.684070559277522},7.9671264818800385,3.8242207113024187,4.6242285407357775,"Nühamus OK!",null,null,null,null,null,null,null,null,61.772195865766776,{"$f":"+F20/V20*2*PI()/60*Traktor!$C$7*3.6","v":9.8696959543452376},{"$f":"+Traktor!E29","v":64.27698569244717},19.397318397578481,{"$f":"+W20*Traktor!$C$7","v":14.43160488779839},224.52211677832565,{"$f":"+IF(F20>0,G20*Traktor!$F$5*1000/AA20,0)","v":279.3306277019791},53.179343031590776,{"$f":"+IF(F20>0,W20/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.42595875704693525}]
[" ",{"$f":"+Traktor!C30","v":10},{"$f":"+Traktor!D30","v":10.5},14.812363636363635,{"$f":"+IF(AND(F21>0,Luisto($F$9,AB21)<100),Luisto($F$9,AB21),\"\")","v":20.160386280146845},{"$f":"+Piste(Traktor!$C$12:$E$17,Y21,1)","v":2215.5107514740198},{"$f":"IF(F21>1000,Piste(Traktor!$C$12:$E$16,Y21,2),\"\")","v":18.519944765052422},8.4422635781527582,{"$f":"+IF(ISNUMBER(H21),H21*$N$8/10,\"\")","v":4.0522865175133242},4.5702456341653601,"Rööbaste tekke oht!",null,null,null,null,null,null,null,null,61.398532853156432,{"$f":"+F21/V21*2*PI()/60*Traktor!$C$7*3.6","v":10.57402858658055},{"$f":"+Traktor!E30","v":58.767529775951701},19.71542748848757,{"$f":"+W21*Traktor!$C$7","v":14.668278051434752},249.59834295157268,{"$f":"+IF(F21>0,G21*Traktor!$F$5*1000/AA21,0)","v":268.64254643442536},57.908748294423198,{"$f":"+IF(F21>0,W21/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0.43294432846416181}]
["Mootor seiskus!",{"$f":"+Traktor!C31","v":11},{"$f":"+Traktor!D31","v":14},16.049454545454545,{"$f":"+IF(AND(F22>0,Luisto($F$9,AB22)<100),Luisto($F$9,AB22),\"\")","v":""},{"$f":"+Piste(Traktor!$C$12:$E$17,Y22,1)","v":0},{"$f":"IF(F22>1000,Piste(Traktor!$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*Traktor!$C$7*3.6","v":0},{"$f":"+Traktor!E31","v":44.075647331963772},20.95251839757848,{"$f":"+W22*Traktor!$C$7","v":15.588673687798389},353.67997139984021,{"$f":"+IF(F22>0,G22*Traktor!$F$5*1000/AA22,0)","v":0},0,{"$f":"+IF(F22>0,W22/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0}]
["Mootor seiskus!",{"$f":"+Traktor!C32","v":12},{"$f":"+Traktor!D32","v":16.899999999999999},17.074472727272724,{"$f":"+IF(AND(F23>0,Luisto($F$9,AB23)<100),Luisto($F$9,AB23),\"\")","v":""},{"$f":"+Piste(Traktor!$C$12:$E$17,Y23,1)","v":0},{"$f":"IF(F23>1000,Piste(Traktor!$C$12:$E$16,Y23,2),\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F23/V23*2*PI()/60*Traktor!$C$7*3.6","v":0},{"$f":"+Traktor!E32","v":36.51237057085757},21.977536579396659,{"$f":"+W23*Traktor!$C$7","v":16.351287215071114},447.8286936571007,{"$f":"+IF(F23>0,G23*Traktor!$F$5*1000/AA23,0)","v":0},0,{"$f":"+IF(F23>0,W23/((Traktor!$C$6+$H$6)*9.81/1000),0)","v":0}]

{"sheet":"Instruktsioon","index":3,"n_rows":59,"n_cols":15,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Esmalt sisestage traktori andmed. Andmed sisestatakse rohelistesse lahtritesse. Ülejäänud arvutatakse programmi poolt automaatselt."]
["Traktori andmeid leiate testide raportitest (vaata allolevaid linke) või ajakirjadest. Kokku on vaja sisse kanda 5 punkti traktori võimsuskõveralt."]
["- Mmax = mootori maksimaalne pöördemoment."]
["- Pmax/P80% = maksimaalne võimsuspunkt, juhul kui see erineb nimivõimsusest. Vastasel juhul punkt maksimaalnse pöördemomendi ja nimivõimsuse vahelt."]
["- Prated = võimsus pööretel kui jõuvõtuvõlli(PTO) kiirus on saavutatud."]
["- P85% = võimsuspunkt 85% pöördemomendi juures nimivõimsusel või selle lähedal."]
["- P25% = võimsuspunkt 25% pöördemomendi juures nimivõimsusel või selle lähedal."]
["- P0 = Maksimaalsetel pööretel ilma koormuseta."]
[]
["Näide. CASE IH CX 90 DIESEL "]
["Mootori väärtused võetuna jooniselt."]
[null,"M Nm","r/min","l/h",null,"Märkus"]
["Mmax",319,1400,14.1,null,"Kütusekuluks märgitakse väikseim sellele grupile spetsiifiline väärtus"]
["Pmax",289,2000,18]
["Prated",258,2200,18.8]
["P85%",219,2272,17.5]
["P25%  ",54,2336,9.6]
["P0 ",0,2361,6]
[]
[]
[]
[null,"Võimsuse kalkulaatorid"]
[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,"Traktorite testide raportid",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":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}