{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Traktori","Kyntö","S-piikki","Apuja","Ohjeita","Info"],"not_rendered":{"charts":6,"images":4,"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":"Traktori","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":false,"merged":[[19,5,33,8]]}
[]
[]
[null,"Traktorin tiedot"]
[null,"Merkki","Massey-Ferguson 7497",null,"PA tiheys",0.84,"kg/l"]
[null,"Massa",7700,"kg","Nim. nopeus",{"$f":"+D13","v":2200},"1/min"]
[null,"Takarenkaan säde",0.95,"m"]
[]
[]
[null,"Moottori"]
[null,"Piste","Momentti Nm","Nopeus 1/min","PA l/h",null,"PA kg/h","PA g/kWh","P kW"]
[null,"Mmax",800,1200,30,null,{"$f":"+E11*$F$4","v":25.2},{"$f":"+G11*1000/I11","v":250.66903536973516},{"$f":"+C11*(D11*2*PI()/60)/1000","v":100.53096491487338},null,"Suurimman vääntömomentin kohta"]
[null,"Pmax/P80%",700,2000,49,null,41.16,{"$f":"+G12*1000/I12","v":280.74931961410346},146.60765716752366,null,"Nimellistehon ja suurimman vääntömomentin  väliltä piste, esim. suurimman tehon piste"]
[null,"Pnim",600,2200,47,null,39.479999999999997,{"$f":"+G13*1000/I13","v":285.61077969400128},138.23007675795088,null,"Nimellistehon piste"]
[null,"P85",500,2220,45,null,37.799999999999997,{"$f":"+G14*1000/I14","v":325.19226210127806},116.23892818282235,null,"Osatehon piste esim. 85% piste"]
[null,"P25",150,2250,20,null,16.8,{"$f":"+G15*1000/I15","v":475.34276336779408},35.342917352885173,null,"Osatehon piste esim. 25% piste"]
[null,"P0",0,2260,9,null,7.56,null,0,null,"Ilman kuormaa suurin nopeus"]
[]
[null,"Vaihteisto",null,null,null,null,null,null,null,null,null,"Katso että alla olevat kuvat näyttävät tehokäyrän oikein"]
[null,null,"Vaihde","Nim. nop. km/h","Välitys"]
[null,null,2,2,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D20*3.6","v":393.9557187601601},"Anna tähän vaihteiden merkinnät ja nimellisnopeudet. Voit myös antaa vaihtoehtoisesti esim. tasaisin välein nopeuksia. Kaikkiaan tähän mahtuu 12 vaihdetta. Jos et anna kaikkia kohtia, tyhjennä ylimääräiset kohdat. Tyhjät kohdat voivbat näkyä muilla sivuilla virheinä, mutta se ei haittaa laskentaa."]
[null,null,3,3,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D21*3.6","v":262.63714584010677}]
[null,null,4,4,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D22*3.6","v":196.97785938008005}]
[null,null,5,5,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D23*3.6","v":157.58228750406406}]
[null,null,6,6,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D24*3.6","v":131.31857292005338}]
[null,null,7,7,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D25*3.6","v":112.55877678861717}]
[null,null,8,8,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D26*3.6","v":98.488929690040024}]
[null,null,9,9,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D27*3.6","v":87.54571528003558}]
[null,null,10,10,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D28*3.6","v":78.791143752032028}]
[null,null,11,11,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D29*3.6","v":71.62831250184729}]
[null,null,12,12,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D30*3.6","v":65.659286460026692}]
[null,null,13,13,{"$f":"+Traktori!$C$6*Traktori!$F$5*PI()/30/D31*3.6","v":60.608572116947713}]

{"sheet":"Kyntö","index":1,"n_rows":36,"n_cols":24,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Kaksoisaura"]
[]
[]
[null,"Maalaji","Terän leveys","Teriä","Työsyvyys cm","Maan kulkukyky","Rinnekulma","Lisäpainoja","Painonsiirto","Työleveys",null,null,"Tuloksia"]
[null,null,null,{"$f":"+D8","v":5},{"$f":"+E8","v":21},null,{"$f":"+G8","v":0},{"$f":"+H8","v":493},null,{"$f":"+O10","v":2.032},"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,"Jäykkä",12,5,21,"Pehmeä",0,493,"Ei",null,null,null,"Tr kulkuvastus",null,{"$f":"+Traktori!C5*9.81/1000*O7","v":7.553700000000001},"kN"]
[null,"Keskijäykkä",14,null,null,"Normaali",null,null,"Heikko",null,null,null,"Mäkivastus",null,{"$f":"+(Traktori!C5+O11)*9.81/1000*SIN(RADIANS(G8))","v":0},"kN"]
[null,"Kevyt",16,null,null,"Kova",null,null,"Hyvä",null,null,null,"Työleveys",null,{"$f":"+(10+C12*2)*0.0254*D8","v":2.032},"m"]
[null,null,18,null,null,null,null,null,"Erinomainen",null,null,null,"Auran massa",null,{"$f":"+D8*350","v":1750},"kg"]
[null,2,3,null,null,2,null,null,3]
[]
[null,"Vaihde","Nim. nop. km/h","Vetovastus kN","Luisto %","Moottori 1/min","Kulutus l/h","Ajonopeus km/h","Työsaavutus ha/h","Kulutus l/ha",null,null,null,"Välityssuhde","Kehävoima","Akselimomentti","Moottorimom.","PA g/kWh","P kW","μ","Kehän. km/h"]
[{"$f":"+IF(F15=0,\"Moottori sammui!\",\" \")","v":" "},{"$f":"+Traktori!C20","v":2},{"$f":"+Traktori!D20","v":2},{"$f":"+kynto($B$12,C15,$O$10,$E$8/100)","v":18.6391296},{"$f":"+IF(AND(F15>0,Luisto($F$12,T15)<=100),Luisto($F$12,T15),\"\")","v":8.9446476107503639},{"$f":"+Piste(Traktori!$C$11:$E$16,Q15,1)","v":2255.7891734298951},{"$f":"IF(F15>1000,Piste(Traktori!$C$11:$E$15,Q15,2),\"\")","v":13.631909227115235},{"$f":"+IF(ISNUMBER(E15),U15*(1-E15/100),\"\")","v":1.8672879827501201},{"$f":"+IF(ISNUMBER(H15),H15*$O$10/10,\"\")","v":0.37943291809482443},{"$f":"+IF(ISNUMBER(I15),G15/I15,\"\")","v":35.927060033595907},{"$f":"+IF(ISNUMBER(E15),LOOKUP(E15,$W$15:$W$19,$X$15:$X$19),\"\")","v":"Luisto pieni!"},null,null,{"$f":"+Traktori!E20","v":393.9557187601601},{"$f":"+D15+$O$8+$O$9","v":26.192829600000003},{"$f":"+O15*Traktori!$C$6","v":24.883188120000003},{"$f":"+P15/N15*1000","v":63.162398551571393},{"$f":"+IF(F15>0,G15*Traktori!$F$4*1000/S15,0)","v":767.45025011527889},{"$f":"+Q15*(F15*2*PI()/60)/1000","v":14.920581169993456},{"$f":"+IF(F15>0,O15/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.30626441970740709},{"$f":"+F15/N15*2*PI()/60*Traktori!$C$6*3.6","v":2.0507174303908133},null,0,"Luisto pieni!"]
[" ",{"$f":"+Traktori!C21","v":3},{"$f":"+Traktori!D21","v":3},19.535241599999999,{"$f":"+IF(AND(F16>0,Luisto($F$12,T16)<=100),Luisto($F$12,T16),\"\")","v":9.5665480349541063},{"$f":"+Piste(Traktori!$C$11:$E$16,Q16,1)","v":2253.4676682442914},{"$f":"IF(F16>1000,Piste(Traktori!$C$11:$E$15,Q16,2),\"\")","v":16.185564931279458},{"$f":"+IF(ISNUMBER(E16),U16*(1-E16/100),\"\")","v":2.7789390017857376},{"$f":"+IF(ISNUMBER(H16),H16*$O$10/10,\"\")","v":0.56468040516286189},{"$f":"+IF(ISNUMBER(I16),G16/I16,\"\")","v":28.663231065386995},{"$f":"+IF(ISNUMBER(E16),LOOKUP(E16,$W$15:$W$19,$X$15:$X$19),\"\")","v":"Luisto pieni!"},null,null,{"$f":"+Traktori!E21","v":262.63714584010677},27.088941599999998,{"$f":"+O16*Traktori!$C$6","v":25.734494519999998},97.984976335628986,{"$f":"+IF(F16>0,G16*Traktori!$F$4*1000/S16,0)","v":587.98697666478984},23.122747750968855,{"$f":"+IF(F16>0,O16/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.31674237210369349},{"$f":"+F16/N16*2*PI()/60*Traktori!$C$6*3.6","v":3.0729104566967607},null,10,"Sopiva luisto!"]
[" ",{"$f":"+Traktori!C22","v":4},{"$f":"+Traktori!D22","v":4},20.789798399999995,{"$f":"+IF(AND(F17>0,Luisto($F$12,T17)<=100),Luisto($F$12,T17),\"\")","v":10.510517167664561},{"$f":"+Piste(Traktori!$C$11:$E$16,Q17,1)","v":2250.886852778026},{"$f":"IF(F17>1000,Piste(Traktori!$C$11:$E$15,Q17,2),\"\")","v":19.024461944171613},3.6623763703492482,0.74419487845496723,25.56381734804269,"Sopiva luisto!",null,null,{"$f":"+Traktori!E22","v":196.97785938008005},28.343498399999994,{"$f":"+O17*Traktori!$C$6","v":26.926323479999994},136.69720832961289,{"$f":"+IF(F17>0,G17*Traktori!$F$4*1000/S17,0)","v":495.96352836026853},32.2212161163106,{"$f":"+IF(F17>0,O17/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.33141150545849457},{"$f":"+F17/N17*2*PI()/60*Traktori!$C$6*3.6","v":4.0925215505055004},null,20,"Uravaara!"]
[" ",{"$f":"+Traktori!C23","v":5},{"$f":"+Traktori!D23","v":5},22.402799999999999,{"$f":"+IF(AND(F18>0,Luisto($F$12,T18)<=100),Luisto($F$12,T18),\"\")","v":11.862322411315432},{"$f":"+Piste(Traktori!$C$11:$E$16,Q18,1)","v":2247.3775160625573},{"$f":"IF(F18>1000,Piste(Traktori!$C$11:$E$15,Q18,2),\"\")","v":22.185403281202273},4.5017871575177377,0.91476315040760436,24.252620223406243,"Sopiva luisto!",null,null,{"$f":"+Traktori!E23","v":157.58228750406406},29.956499999999998,{"$f":"+O18*Traktori!$C$6","v":28.458674999999996},180.59564593683186,{"$f":"+IF(F18>0,G18*Traktori!$F$4*1000/S18,0)","v":438.4647542475293},42.502250353489885,{"$f":"+IF(F18>0,O18/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.35027181977181032},{"$f":"+F18/N18*2*PI()/60*Traktori!$C$6*3.6","v":5.1076761728694482},null,30,"Suuri luisto !"]
[" ",{"$f":"+Traktori!C24","v":6},{"$f":"+Traktori!D24","v":6},24.374246399999993,{"$f":"+IF(AND(F19>0,Luisto($F$12,T19)<=100),Luisto($F$12,T19),\"\")","v":13.752833017789943},{"$f":"+Piste(Traktori!$C$11:$E$16,Q19,1)","v":2243.059127951949},{"$f":"IF(F19>1000,Piste(Traktori!$C$11:$E$15,Q19,2),\"\")","v":25.784060040042476},5.2761135043484231,1.0721062640835997,24.049910819317731,"Sopiva luisto!",null,null,{"$f":"+Traktori!E24","v":131.31857292005338},31.927946399999996,{"$f":"+O19*Traktori!$C$6","v":30.331549079999995},230.97684056059467,{"$f":"+IF(F19>0,G19*Traktori!$F$4*1000/S19,0)","v":399.20209653436194},54.254751219151927,{"$f":"+IF(F19>0,O19/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.37332331504364058},{"$f":"+F19/N19*2*PI()/60*Traktori!$C$6*3.6","v":6.1174339853234958},null,100]
[" ",{"$f":"+Traktori!C25","v":7},{"$f":"+Traktori!D25","v":7},26.704137599999999,{"$f":"+IF(AND(F20>0,Luisto($F$12,T20)<=100),Luisto($F$12,T20),\"\")","v":16.379152429124886},{"$f":"+Piste(Traktori!$C$11:$E$16,Q20,1)","v":2238.073941976782},{"$f":"IF(F20>1000,Piste(Traktori!$C$11:$E$15,Q20,2),\"\")","v":29.938381686015013},5.9547612712759843,1.21000749032328,24.742311039757546,"Sopiva luisto!",null,null,{"$f":"+Traktori!E25","v":112.55877678861717},34.257837600000002,{"$f":"+O20*Traktori!$C$6","v":32.544945720000001},289.13734360421017,{"$f":"+IF(F20>0,G20*Traktori!$F$4*1000/S20,0)","v":371.10804700063193},67.765279733235715,{"$f":"+IF(F20>0,O20/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.40056599127398551},{"$f":"+F20/N20*2*PI()/60*Traktori!$C$6*3.6","v":7.1211443608352152}]
[" ",{"$f":"+Traktori!C26","v":8},{"$f":"+Traktori!D26","v":8},29.392473599999999,{"$f":"+IF(AND(F21>0,Luisto($F$12,T21)<=100),Luisto($F$12,T21),\"\")","v":20.038605141661872},{"$f":"+Piste(Traktori!$C$11:$E$16,Q21,1)","v":2232.3108251596295},{"$f":"IF(F21>1000,Piste(Traktori!$C$11:$E$15,Q21,2),\"\")","v":34.740979033641928},6.4908613577138796,1.3189430278874603,26.340014920345919,"Uravaara!",null,null,{"$f":"+Traktori!E26","v":98.488929690040024},36.946173600000002,{"$f":"+O21*Traktori!$C$6","v":35.098864919999997},356.37370647098697,{"$f":"+IF(F21>0,G21*Traktori!$F$4*1000/S21,0)","v":350.2937607409317},83.308427551017076,{"$f":"+IF(F21>0,O21/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.431999848462845},{"$f":"+F21/N21*2*PI()/60*Traktori!$C$6*3.6","v":8.1174939096713778}]
[" ",{"$f":"+Traktori!C27","v":9},{"$f":"+Traktori!D27","v":9},32.439254399999996,{"$f":"+IF(AND(F22>0,Luisto($F$12,T22)<=100),Luisto($F$12,T22),\"\")","v":25.183747659320719},{"$f":"+Piste(Traktori!$C$11:$E$16,Q22,1)","v":2225.6586445230655},{"$f":"IF(F22>1000,Piste(Traktori!$C$11:$E$15,Q22,2),\"\")","v":40.28446289744528},6.8119952225257583,1.3841974292172341,29.103119285683263,"Uravaara!",null,null,{"$f":"+Traktori!E27","v":87.54571528003558},39.992954399999995,{"$f":"+O22*Traktori!$C$6","v":37.993306679999996},433.98248056423387,{"$f":"+IF(F22>0,G22*Traktori!$F$4*1000/S22,0)","v":334.54727116936647},101.1484825913372,{"$f":"+IF(F22>0,O22/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.46762488661021906},{"$f":"+F22/N22*2*PI()/60*Traktori!$C$6*3.6","v":9.1049671821398128}]
[" ",{"$f":"+Traktori!C28","v":10},{"$f":"+Traktori!D28","v":10},35.844479999999997,{"$f":"+IF(AND(F23>0,Luisto($F$12,T23)<=100),Luisto($F$12,T23),\"\")","v":32.512475573867384},{"$f":"+Piste(Traktori!$C$11:$E$16,Q23,1)","v":2215.3479565425482},{"$f":"IF(F23>1000,Piste(Traktori!$C$11:$E$15,Q23,2),\"\")","v":45.465204345745192},6.7958340604340082,1.3809134810801904,32.924006441142858,"Suuri luisto !",null,null,{"$f":"+Traktori!E28","v":78.791143752032028},43.398179999999996,{"$f":"+O23*Traktori!$C$6","v":41.228270999999992},523.26021728725971,{"$f":"+IF(F23>0,G23*Traktori!$F$4*1000/S23,0)","v":314.608280661994},121.39150174326471,{"$f":"+IF(F23>0,O23/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.50744110571610779},{"$f":"+F23/N23*2*PI()/60*Traktori!$C$6*3.6","v":10.069763438829764}]
[" ",{"$f":"+Traktori!C29","v":11},{"$f":"+Traktori!D29","v":11},39.608150399999992,{"$f":"+IF(AND(F24>0,Luisto($F$12,T24)<=100),Luisto($F$12,T24),\"\")","v":43.11779339229647},{"$f":"+Piste(Traktori!$C$11:$E$16,Q24,1)","v":2148.9930639132535},{"$f":"IF(F24>1000,Piste(Traktori!$C$11:$E$15,Q24,2),\"\")","v":47.510069360867469},6.111973373001776,1.2419529893939609,38.254321835523811,"Suuri luisto !",null,null,{"$f":"+Traktori!E29","v":71.62831250184729},47.161850399999992,{"$f":"+O24*Traktori!$C$6","v":44.803757879999992},625.50346804337335,{"$f":"+IF(F24>0,G24*Traktori!$F$4*1000/S24,0)","v":283.51209867989547},140.76456859849233,{"$f":"+IF(F24>0,O24/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.55144850578051097},{"$f":"+F24/N24*2*PI()/60*Traktori!$C$6*3.6","v":10.744965319566267}]
[" ",{"$f":"+Traktori!C30","v":12},{"$f":"+Traktori!D30","v":12},43.730265599999989,{"$f":"+IF(AND(F25>0,Luisto($F$12,T25)<=100),Luisto($F$12,T25),\"\")","v":58.740795520791615},{"$f":"+Piste(Traktori!$C$11:$E$16,Q25,1)","v":1663.929726112935},{"$f":"IF(F25>1000,Piste(Traktori!$C$11:$E$15,Q25,2),\"\")","v":41.018330995182204},3.7446772804760058,0.76091842339272442,53.906344930239477,"Suuri luisto !",null,null,{"$f":"+Traktori!E30","v":65.659286460026692},51.283965599999988,{"$f":"+O25*Traktori!$C$6","v":48.719767319999988},742.00878423588313,{"$f":"+IF(F25>0,G25*Traktori!$F$4*1000/S25,0)","v":266.49227613700253},129.29229520423203,{"$f":"+IF(F25>0,O25/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0.59964708680342882},{"$f":"+F25/N25*2*PI()/60*Traktori!$C$6*3.6","v":9.0759803242523702}]
["Moottori sammui!",{"$f":"+Traktori!C31","v":13},{"$f":"+Traktori!D31","v":13},48.210825599999993,{"$f":"+IF(AND(F26>0,Luisto($F$12,T26)<=100),Luisto($F$12,T26),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Q26,1)","v":0},{"$f":"IF(F26>1000,Piste(Traktori!$C$11:$E$15,Q26,2),\"\")","v":""},"","","","",null,null,{"$f":"+Traktori!E31","v":60.608572116947713},55.764525599999992,{"$f":"+O26*Traktori!$C$6","v":52.976299319999988},874.07271726809836,{"$f":"+IF(F26>0,G26*Traktori!$F$4*1000/S26,0)","v":0},0,{"$f":"+IF(F26>0,O26/((Traktori!$C$5+$H$8+($I$12-1)*0.15*$O$11)*9.81/1000),0)","v":0},{"$f":"+F26/N26*2*PI()/60*Traktori!$C$6*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-piikki","index":2,"n_rows":23,"n_cols":28,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[null,"S-piikkiäes"]
[]
[null,null,{"$f":"+C9","v":6.7},{"$f":"+D6","v":7},{"$f":"+E6","v":7},null,{"$f":"+G6","v":0},{"$f":"+H6","v":400}]
[null,"Maalaji","Työleveys m","Piikkiväli cm","Työsyvyys cm","Maan kulkukyky","Rinnekulma","Lisäpainoja 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,"Multamaa",67,7,7,"Pehmeä",0,400,null,null,null,"Tr kulkuvastus",null,{"$f":"+Traktori!C5*9.81/1000*N5","v":7.553700000000001},"kN"]
[null,"Savimaa",null,null,null,"Normaali",null,null,null,null,null,"Tr mäkivastus",null,{"$f":"+Traktori!C5*9.81/1000*SIN(RADIANS(G6))","v":0},"kN"]
[null,null,null,null,null,"Kova",null,null,null,null,null,"Työleveys",null,{"$f":"+C9","v":6.7},"m"]
[null,2,{"$f":"+C6/10","v":6.7},null,null,2]
[]
[null,"Vaihde","Nim. nop. km/h","Vetovastus kN","Luisto %","Moottori 1/min","Kulutus l/h","Ajonopeus km/h","Työsaavutus ha/h","Kulutus 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,\"Moottori sammui!\",\" \")","v":" "},{"$f":"+Traktori!C20","v":2},{"$f":"+Traktori!D20","v":2},{"$f":"+spiikki($B$9,C12,+$C$9/($D$6/100),$E$6,$C$9)","v":23.878799999999998},{"$f":"+IF(AND(F12>0,Luisto($F$9,AB12)<50),Luisto($F$9,AB12),\"\")","v":15.862670947905199},{"$f":"+Piste(Traktori!$C$11:$E$16,Y12,1)","v":2254.9468305568325},{"$f":"IF(F12>1000,Piste(Traktori!$C$11:$E$15,Y12,2),\"\")","v":14.558486387484443},{"$f":"+IF(ISNUMBER(E12),U12*(1-E12/100),\"\")","v":1.7247745770685314},{"$f":"+IF(ISNUMBER(H12),H12*$C$3/10,\"\")","v":1.1555989666359161},{"$f":"+IF(ISNUMBER(I12),G12/I12,\"\")","v":12.598216862261395},{"$f":"+IF(ISNUMBER(E12),LOOKUP(E12,$R$12:$R$16,$S$12:$S$16),\"\")","v":"Sopiva luisto!"},null,null,null,null,null,null,0,"Luisto pieni!",{"$f":"+(1-E12/100)*(1-$N$5/AB12)*100","v":62.867508631165812},{"$f":"+F12/V12*2*PI()/60*Traktori!$C$6*3.6","v":2.0499516641425748},{"$f":"+Traktori!E20","v":393.9557187601601},{"$f":"+D12+$N$6+$N$7","v":31.432499999999997},{"$f":"+W12*Traktori!$C$6","v":29.860874999999997},{"$f":"+X12/V12*1000","v":75.797541647515132},{"$f":"+IF(F12>0,G12*Traktori!$F$4*1000/AA12,0)","v":683.24343335806407},{"$f":"+Y12*(F12*2*PI()/60)/1000","v":17.898640467544855},{"$f":"+IF(F12>0,W12/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.39557141239098426}]
[" ",{"$f":"+Traktori!C21","v":3},{"$f":"+Traktori!D21","v":3},26.203699999999998,{"$f":"+IF(AND(F13>0,Luisto($F$9,AB13)<50),Luisto($F$9,AB13),\"\")","v":19.137773125504449},{"$f":"+Piste(Traktori!$C$11:$E$16,Y13,1)","v":2251.8596104910148},{"$f":"IF(F13>1000,Piste(Traktori!$C$11:$E$15,Y13,2),\"\")","v":17.954428459883911},{"$f":"+IF(ISNUMBER(E13),U13*(1-E13/100),\"\")","v":2.4830506733596041},{"$f":"+IF(ISNUMBER(H13),H13*$C$3/10,\"\")","v":1.6636439511509349},{"$f":"+IF(ISNUMBER(I13),G13/I13,\"\")","v":10.79223018090064},{"$f":"+IF(ISNUMBER(E13),LOOKUP(E13,$R$12:$R$16,$S$12:$S$16),\"\")","v":"Sopiva luisto!"},null,null,null,null,null,null,10,"Sopiva luisto!",61.828197566331141,{"$f":"+F13/V13*2*PI()/60*Traktori!$C$6*3.6","v":3.0707176506695655},{"$f":"+Traktori!E21","v":262.63714584010677},33.757399999999997,{"$f":"+W13*Traktori!$C$6","v":32.069529999999993},122.10584263478059,{"$f":"+IF(F13>0,G13*Traktori!$F$4*1000/AA13,0)","v":523.77467557939178},28.794290005753542,{"$f":"+IF(F13>0,W13/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.42482979071494187}]
[" ",{"$f":"+Traktori!C22","v":4},{"$f":"+Traktori!D22","v":4},28.528599999999997,{"$f":"+IF(AND(F14>0,Luisto($F$9,AB14)<50),Luisto($F$9,AB14),\"\")","v":23.089072540564018},{"$f":"+Piste(Traktori!$C$11:$E$16,Y14,1)","v":2247.941100251624},{"$f":"IF(F14>1000,Piste(Traktori!$C$11:$E$15,Y14,2),\"\")","v":21.715749790313193},3.1434769980824973,2.1061295887152731,10.310737718451444,"Uravaara!",null,null,null,null,null,null,20,"Uravaara!",59.973483873926625,{"$f":"+F14/V14*2*PI()/60*Traktori!$C$6*3.6","v":4.0871656368211342},{"$f":"+Traktori!E22","v":196.97785938008005},36.082299999999996,{"$f":"+W14*Traktori!$C$6","v":34.278184999999993},174.02049706438467,{"$f":"+IF(F14>0,G14*Traktori!$F$4*1000/AA14,0)","v":445.28715201771524},40.965093515964227,{"$f":"+IF(F14>0,W14/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.45408816903889954}]
[" ",{"$f":"+Traktori!C23","v":5},{"$f":"+Traktori!D23","v":5},30.8535,{"$f":"+IF(AND(F15>0,Luisto($F$9,AB15)<50),Luisto($F$9,AB15),\"\")","v":27.856180930108891},{"$f":"+Piste(Traktori!$C$11:$E$16,Y15,1)","v":2243.0107281483147},{"$f":"IF(F15>1000,Piste(Traktori!$C$11:$E$15,Y15,2),\"\")","v":25.824393209737668},3.6777127305308337,2.4640675294556589,10.48039183221678,"Uravaara!",null,null,null,null,null,null,30,"Suuri luisto !",57.217919740826204,{"$f":"+F15/V15*2*PI()/60*Traktori!$C$6*3.6","v":5.0977516548825319},{"$f":"+Traktori!E23","v":157.58228750406406},38.407200000000003,{"$f":"+W15*Traktori!$C$6","v":36.486840000000001},231.54150493632733,{"$f":"+IF(F15>0,G15*Traktori!$F$4*1000/AA15,0)","v":398.86009776412868},54.386213155390109,{"$f":"+IF(F15>0,W15/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.48334654736285732}]
[" ",{"$f":"+Traktori!C24","v":6},{"$f":"+Traktori!D24","v":6},33.178399999999996,{"$f":"+IF(AND(F16>0,Luisto($F$9,AB16)<50),Luisto($F$9,AB16),\"\")","v":33.607535107688037},{"$f":"+Piste(Traktori!$C$11:$E$16,Y16,1)","v":2237.5998114642334},{"$f":"IF(F16>1000,Piste(Traktori!$C$11:$E$15,Y16,2),\"\")","v":30.333490446472037},4.0516300070640794,2.7145921047329331,11.174235124895976,"Suuri luisto !",null,null,null,null,null,null,100,null,53.440489293685815,{"$f":"+F16/V16*2*PI()/60*Traktori!$C$6*3.6","v":6.1025449403569976},{"$f":"+Traktori!E24","v":131.31857292005338},40.732099999999996,{"$f":"+W16*Traktori!$C$6","v":38.695494999999994},294.66886625060852,{"$f":"+IF(F16>0,G16*Traktori!$F$4*1000/AA16,0)","v":369.02550754839041},69.047075212532008,{"$f":"+IF(F16>0,W16/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.51260492568681482}]
[" ",{"$f":"+Traktori!C25","v":7},{"$f":"+Traktori!D25","v":7},35.503299999999996,{"$f":"+IF(AND(F17>0,Luisto($F$9,AB17)<50),Luisto($F$9,AB17),\"\")","v":40.546348361547288},{"$f":"+Piste(Traktori!$C$11:$E$16,Y17,1)","v":2231.7083501993802},{"$f":"IF(F17>1000,Piste(Traktori!$C$11:$E$15,Y17,2),\"\")","v":35.24304150051632},4.2217385258166358,2.8285648122971461,12.459690280844084,"Suuri luisto !",null,null,null,null,null,null,null,null,48.481575987935742,{"$f":"+F17/V17*2*PI()/60*Traktori!$C$6*3.6","v":7.1008902051798461},{"$f":"+Traktori!E25","v":112.55877678861717},43.056999999999995,{"$f":"+W17*Traktori!$C$6","v":40.904149999999994},363.40258100722843,{"$f":"+IF(F17>0,G17*Traktori!$F$4*1000/AA17,0)","v":348.57690018114715},84.928619323452381,{"$f":"+IF(F17>0,W17/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.54186330401077254}]
[" ",{"$f":"+Traktori!C26","v":8},{"$f":"+Traktori!D26","v":8},37.828199999999995,{"$f":"+IF(AND(F18>0,Luisto($F$9,AB18)<50),Luisto($F$9,AB18),\"\")","v":48.917790614160985},{"$f":"+Piste(Traktori!$C$11:$E$16,Y18,1)","v":2225.3363443537555},{"$f":"IF(F18>1000,Piste(Traktori!$C$11:$E$15,Y18,2),\"\")","v":40.553046371870494},4.1336398944071311,2.769538729252778,14.642527271251307,"Suuri luisto !",null,null,null,null,null,null,null,null,42.138019213086984,{"$f":"+F18/V18*2*PI()/60*Traktori!$C$6*3.6","v":8.0921321612863846},{"$f":"+Traktori!E26","v":98.488929690040024},45.381899999999995,{"$f":"+W18*Traktori!$C$6","v":43.112804999999994},437.74264920618691,{"$f":"+IF(F18>0,G18*Traktori!$F$4*1000/AA18,0)","v":333.93322328319471},102.01009236952291,{"$f":"+IF(F18>0,W18/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.57112168233473015}]
[" ",{"$f":"+Traktori!C27","v":9},{"$f":"+Traktori!D27","v":9},40.153099999999995,{"$f":"+IF(AND(F19>0,Luisto($F$9,AB19)<50),Luisto($F$9,AB19),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Y19,1)","v":2216.4621858305031},{"$f":"IF(F19>1000,Piste(Traktori!$C$11:$E$15,Y19,2),\"\")","v":45.35378141694968},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F19/V19*2*PI()/60*Traktori!$C$6*3.6","v":9.0673453056702371},{"$f":"+Traktori!E27","v":87.54571528003558},47.706799999999994,{"$f":"+W19*Traktori!$C$6","v":45.321459999999995},517.68907084748389,{"$f":"+IF(F19>0,G19*Traktori!$F$4*1000/AA19,0)","v":317.05517622696732},120.15945250793023,{"$f":"+IF(F19>0,W19/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.60038006065868788}]
[" ",{"$f":"+Traktori!C28","v":10},{"$f":"+Traktori!D28","v":10},42.477999999999994,{"$f":"+IF(AND(F20>0,Luisto($F$9,AB20)<50),Luisto($F$9,AB20),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Y20,1)","v":2193.5163081377609},{"$f":"IF(F20>1000,Piste(Traktori!$C$11:$E$15,Y20,2),\"\")","v":47.06483691862239},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F20/V20*2*PI()/60*Traktori!$C$6*3.6","v":9.9705286733534564},{"$f":"+Traktori!E28","v":78.791143752032028},50.031699999999994,{"$f":"+W20*Traktori!$C$6","v":47.530114999999995},603.24184593111954,{"$f":"+IF(F20>0,G20*Traktori!$F$4*1000/AA20,0)","v":285.30862347435294},138.56736095183837,{"$f":"+IF(F20>0,W20/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.62963843898264549}]
[" ",{"$f":"+Traktori!C29","v":11},{"$f":"+Traktori!D29","v":11},44.802899999999994,{"$f":"+IF(AND(F21>0,Luisto($F$9,AB21)<50),Luisto($F$9,AB21),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Y21,1)","v":2011.1980510858125},{"$f":"IF(F21>1000,Piste(Traktori!$C$11:$E$15,Y21,2),\"\")","v":48.888019489141875},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F21/V21*2*PI()/60*Traktori!$C$6*3.6","v":10.055990255429061},{"$f":"+Traktori!E29","v":71.62831250184729},52.356599999999993,{"$f":"+W21*Traktori!$C$6","v":49.738769999999988},694.40097445709375,{"$f":"+IF(F21>0,G21*Traktori!$F$4*1000/AA21,0)","v":280.7940822764167},146.24929427983253,{"$f":"+IF(F21>0,W21/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.65889681730660321}]
[" ",{"$f":"+Traktori!C30","v":12},{"$f":"+Traktori!D30","v":12},47.127799999999993,{"$f":"+IF(AND(F22>0,Luisto($F$9,AB22)<50),Luisto($F$9,AB22),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Y22,1)","v":1270.6683485967478},{"$f":"IF(F22>1000,Piste(Traktori!$C$11:$E$15,Y22,2),\"\")","v":31.67837327917276},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F22/V22*2*PI()/60*Traktori!$C$6*3.6","v":6.9309182650731671},{"$f":"+Traktori!E30","v":65.659286460026692},54.681499999999993,{"$f":"+W22*Traktori!$C$6","v":51.947424999999988},791.16645642540652,{"$f":"+IF(F22>0,G22*Traktori!$F$4*1000/AA22,0)","v":252.76297714910208},105.27583530877733,{"$f":"+IF(F22>0,W22/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0.68815519563056082}]
["Moottori sammui!",{"$f":"+Traktori!C31","v":13},{"$f":"+Traktori!D31","v":13},49.452699999999993,{"$f":"+IF(AND(F23>0,Luisto($F$9,AB23)<50),Luisto($F$9,AB23),\"\")","v":""},{"$f":"+Piste(Traktori!$C$11:$E$16,Y23,1)","v":0},{"$f":"IF(F23>1000,Piste(Traktori!$C$11:$E$15,Y23,2),\"\")","v":""},"","","","",null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},{"$f":"+F23/V23*2*PI()/60*Traktori!$C$6*3.6","v":0},{"$f":"+Traktori!E31","v":60.608572116947713},57.006399999999992,{"$f":"+W23*Traktori!$C$6","v":54.156079999999989},893.53829183605797,{"$f":"+IF(F23>0,G23*Traktori!$F$4*1000/AA23,0)","v":0},0,{"$f":"+IF(F23>0,W23/((Traktori!$C$5+$H$6)*9.81/1000),0)","v":0}]

{"sheet":"Apuja","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Traktoritiedot"]
[null,"http://www2.oecd.org/agr-coddb/index_en.asp "]
[null,"http://tractortestlab.unl.edu/testreports.htm "]
[]
[]
[null,"Traktorin suoritusarvot"]
[null,"n",2000,"1/min",null,"n",2200,"1/min"]
[null,"P",50,"kW",null,"M",{"$f":"+G12*1000/(G9*2*PI()/60)","v":238.73241463784302},"Nm"]
[null,"Q",18,"l/h",null,"Q",16,"l/h"]
[null,"M",{"$f":"+C10*1000/(C9*2*PI()/60)","v":238.73241463784302},"Nm",null,"P",55,"kW"]
[null,"Qom",{"$f":"+IF(C11*0.835/C10*1000<190,\"Virhe arvoissa\",C11*0.835/C10*1000)","v":300.59999999999997},"g/kWh",null,"Qom",{"$f":"+IF(G11*0.835/G12*1000<190,\"--\",G11*0.835/G12*1000)","v":242.90909090909091},"g/kWh"]

{"sheet":"Ohjeita","index":4,"n_rows":61,"n_cols":4,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Syötä 'Traktori' osaan vihreisiin kohtiin moottorin ja traktori tiedot. Näiden perusteella ohjelma laskee muut arvot."]
["Moottorin tiedot täytyy hakea joko koetusselostuksista tai lehtien testeistä. Moottorin käyrästä tarvitaan kaikkiaan viisi pistettä ja ne pitää antaa oheisessa järjestyksessä."]
["Mmax = suurimman vääntömomentin kohta"]
["Pmax/P80% = suurimman tehon kohta, jos se poikkeaa nimellistehosta. Muutoin piste, joka on suurimman momentin ja nimellistehon väliltä."]
["Pnim = nimellistehon arvot"]
["P85 = piste, jossa momentti on 85% nimellistehon momentista tai niiltä paikkeilta oleva piste"]
["P25 = piste, jossa momentti on 25% nimellistehon momentista tai niiltä paikkeilta oleva piste"]
["P0=Suurin nopeus ilman kuormaa"]
["Esim. Koneviesti nro4/2011"]
["Moottorin tehopisteet olisivat seuraavat (poimittu kuvista):"]
[null,"M Nm","r/min","l/h"]
["Mmax",800,1200,30]
["Pmax",700,2000,49]
["Pnim",600,2200,47]
["P85",500,2220,45]
["P25  ",150,2250,20]
["P0 ",0,2260,9]
[]
[]
["Maan kulkukykyä varten voit valita kolmesta erilaisesta vaihtoehdosta. Käyrät ovat likimain oheisten kuvien mukaiset."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["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"]
[]
["Versio",2,"Korjattu väärin tapahtuva ajonopeuden laskenta"]

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