{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Viljan  tuotanto","Sheet2","Sheet3","Info"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Viljan  tuotanto","index":0,"n_rows":41,"n_cols":38,"rows_kept":41,"cut":false,"hidden":false,"merged":[[33,2,33,3],[26,2,26,3],[27,2,27,3],[28,2,28,3],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3]]}
["Vihreät ruudut ovat syöttöruutuja, syötä näihin tilasi tiedot"]
[]
[]
[null,null,"Lohko",null,null,null,null,"Kylvömuokkaus, perinteinen",null,null,null,null,null,"Kylvölannoitus",null,null,null,null,null,null,"Kasvinsuojelu",null,null,null,null,"Puinti",null,null,null,null,null,"Perusmuokkaus"]
[null,null,null,"Etäisyys tilasta km","Ala ha","Maalaji",null,"Äestyskertoja",null,"Äestys l/ha","Matka l","Lohkon kulutus",null,"Kylvetään",null,"Kylvö l/ha","Matka l","Lohkon kulutus",null,null,"Ruiskutuskertoja","Kulutus l/ha","Matka l","Lohkon kulutus",null,"Sato",null,"Kulutus l/ha","Matka l","Lohkon kulutus",null,"Muokkaustapa",null,"Maalaji",null,"Kulutus l/ha",{"$f":"+AC5","v":"Matka l"},{"$f":"+AD5","v":"Lohkon kulutus"}]
[null,null,"Lohko 1",0,2.2999999999999998,null,1,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G6)*H6","v":9.1999999999999993},{"$f":"0.063*5*D6*2","v":0},{"$f":"+J6+K6","v":9.1999999999999993},null,{"$f":"+IF(H6=0,0,1)","v":1},3.7,{"$f":"+O6","v":3.7},{"$f":"0.063*(9*D6*2+0.6*E6)","v":8.693999999999999E-2},{"$f":"+N6*P6*E6+Q6","v":8.59694},null,1.8,1,{"$f":"+T6","v":1.8},{"$f":"0.063*5*D6*2","v":0},{"$f":"+E6*V6*U6+W6","v":4.1399999999999997},null,null,3,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA6)","v":9},{"$f":"0.063*7*D6*2+3.5*E6*0.063","v":0.50714999999999999},{"$f":"+AB6*E6+AC6","v":21.207149999999999},null,null,3,null,3,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG6,'Viljan  tuotanto'!AI6)","v":9.25},{"$f":"0.063*5*D6*2","v":0},{"$f":"+AJ6*E6+AK6","v":21.274999999999999}]
[null,null,"Lohko 2",2,3.2,null,1,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G7)*H7","v":9.1999999999999993},{"$f":"0.063*5*D7*2","v":1.26},{"$f":"+J7+K7","v":10.459999999999999},null,1,3.7,3.7,{"$f":"0.063*(9*D7*2+0.6*E7)","v":2.38896},{"$f":"+N7*P7*E7+Q7","v":14.228960000000001},null,1.8,1,1.8,{"$f":"0.063*5*D7*2","v":1.26},{"$f":"+E7*V7*U7+W7","v":7.0200000000000005},null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA7)","v":19},{"$f":"0.063*7*D7*2+3.5*E7*0.063","v":2.4696000000000002},{"$f":"+AB7*E7+AC7","v":63.269600000000004},null,null,2,null,3,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG7,'Viljan  tuotanto'!AI7)","v":11},{"$f":"0.063*5*D7*2","v":1.26},{"$f":"+AJ7*E7+AK7","v":36.46}]
[null,null,"Lohko 3",2,3.2,null,1,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G8)*H8","v":9.1999999999999993},1.26,10.459999999999999,null,1,3.7,3.7,2.38896,14.228960000000001,null,1.8,1,1.8,1.26,7.0200000000000005,null,null,3,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA8)","v":9},2.4696000000000002,31.269600000000001,null,null,3,null,3,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG8,'Viljan  tuotanto'!AI8)","v":9.25},1.26,30.860000000000003]
[null,null,"Lohko 4",4,5,null,2,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G9)*H9","v":10.8},2.52,13.32,null,1,3.7,3.7,4.7249999999999996,23.225000000000001,null,1.8,1,1.8,2.52,11.52,null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA9)","v":19},4.6304999999999996,99.630499999999998,null,null,2,null,3,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG9,'Viljan  tuotanto'!AI9)","v":11},2.52,57.52]
[null,null,"Lohko 5",1,4.5999999999999996,null,1,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G10)*H10","v":9.1999999999999993},0.63,9.83,null,1,3.7,3.7,1.3078799999999999,18.32788,null,1.8,1,1.8,0.63,8.91,null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA10)","v":19},1.8963000000000001,89.296299999999988,null,null,1,null,3,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG10,'Viljan  tuotanto'!AI10)","v":30},0.63,138.63]
[null,null,"Lohko 6",22,3.6,null,3,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G11)*H11","v":12.4},13.86,26.259999999999998,null,1,3.7,3.7,25.08408,38.40408,null,1.8,1,1.8,13.86,20.34,null,null,2,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA11)","v":14},20.197800000000001,70.597800000000007,null,null,2,null,2,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG11,'Viljan  tuotanto'!AI11)","v":10},13.86,49.86]
[null,null,"Lohko 7",2,3,null,2,2,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G12)*H12","v":10.8},1.26,12.06,null,1,3.7,3.7,2.3813999999999997,13.481400000000001,null,1.8,1,1.8,1.26,6.66,null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA12)","v":19},2.4255,59.4255,null,null,1,null,1,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG12,'Viljan  tuotanto'!AI12)","v":10},1.26,31.26]
[null,null,"Lohko 8",0,0,null,1,0,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G13)*H13","v":0},0,0,null,0,3.7,3.7,0,0,null,1.8,0,1.8,0,0,null,null,3,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA13)","v":9},0,0,null,null,2,null,1,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG13,'Viljan  tuotanto'!AI13)","v":9},0,0]
[null,null,"Lohko 9",0,0,null,1,0,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G14)*H14","v":0},0,0,null,0,3.7,3.7,0,0,null,1.8,0,1.8,0,0,null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA14)","v":19},0,0,null,null,2,null,1,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG14,'Viljan  tuotanto'!AI14)","v":9},0,0]
[null,null,"Lohko 10",0,0,null,1,0,null,{"$f":"+INDEX(Sheet2!$C$5:$C$7,G15)*H15","v":0},0,0,null,0,3.7,3.7,0,0,null,1.8,0,1.8,0,0,null,null,1,{"$f":"+INDEX(Sheet2!$C$11:$C$13,AA15)","v":19},0,0,null,null,2,null,1,{"$f":"+INDEX(Sheet2!$G$11:$I$13,'Viljan  tuotanto'!AG15,'Viljan  tuotanto'!AI15)","v":9},0,0]
[null,null,"Summa",null,{"$f":"+SUM(E6:E15)","v":24.9},null,null,null,null,null,null,{"$f":"+SUM(L6:L15)","v":91.59},null,null,null,null,null,{"$f":"+SUM(R6:R15)","v":130.49322000000001},null,null,null,null,null,{"$f":"+SUM(X6:X15)","v":65.61},null,null,null,null,null,{"$f":"+SUM(AD6:AD15)","v":434.69644999999997},null,null,null,null,null,null,null,{"$f":"+SUM(AL6:AL15)","v":365.86500000000001}]
[]
[]
[]
["Kuivaus","Viljan keskisato kuivana",null,null,3500,"kg/ha",{"$f":"+E20*E16","v":87150}]
[null,"Puintikosteus keskimäärin",null,null,20,"%"]
[null,"Sato",null,null,{"$f":"+E20*E16","v":87150},"kg"]
[null,"Poistettava vesimäärä",null,null,{"$f":"+(E21/100-0.14)/(1-E21/100)*G20","v":6536.25},"kg vettä"]
[null,"Öljyn kulutus",null,null,{"$f":"0.15*E23","v":980.4375},"l"]
[null,null,null,null,{"$f":"+E24/E16","v":39.375},"l/ha"]
[]
[null,null,"Työ",null,"Määrä l","Määrä l/ha"]
["TULOS",null,"Kylvömuokkaus",null,{"$f":"+L16","v":91.59},{"$f":"+E28/$E$16","v":3.6783132530120484}]
[null,null,"Kylvölannoitus",null,{"$f":"+R16","v":130.49322000000001},{"$f":"+E29/$E$16","v":5.2406915662650606}]
[null,null,"Kasvinsuojelu",null,{"$f":"+X16","v":65.61},2.6349397590361447]
[null,null,"Puinti",null,{"$f":"+AD16","v":434.69644999999997},17.457688755020079]
[null,null,"Perusmuokkaus",null,{"$f":"+AL16","v":365.86500000000001},14.693373493975905]
[null,null,"Kuivaus",null,{"$f":"+E24","v":980.4375},39.375]
[null,null,"Yhteensä",null,{"$f":"+SUM(E28:E33)","v":2068.6921700000003},83.080006827309248]
[]
[]
[null,null,"Ohjelma laskee tilan polttoainekulutuksen arvion lohkoittain."]
[null,null,"Koska olosuhteet, kuljettajat ja säät vaihtelevat vuosittain,"]
[null,null," todellisissa kulutuksissa on usein melkoista vaihtelua. "]
[null,null,"Tämä laskentaa antaa arvion, joka voi erota useita"]
[null,null,"kymmeniä prosentteja todellisuudesta."]

{"sheet":"Sheet2","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Näillä luvuilla kulutukset arvioidaan. Vaihtamalla luvut saadaan erilailla laskettu tulos."]
[null,"Äestys"]
[null,"Maalaji","l/ha"]
[null,"Kevyt",4.5999999999999996]
[null,"Keskijäykkä",5.4]
[null,"Jäykkä",6.2]
[]
[null,"Puinti"]
[null,"Sato","l/ha",null,"Muokkaus l/ha",null,"Kevyt","Keskijäykkä ","Jäykkä"]
[null,"Hyvä",19,null,"Kyntö",null,10,20,30]
[null,"Keskinkertainen",14,null,"Sänkim. kultiv.",null,9,10,11]
[null,"Heikko",9,null,"Sänkim. lautas.",null,7.75,8.5,9.25]

{"sheet":"Sheet3","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,7,10]
[null,null,null,{"$f":"+(E9-D9)/4","v":0.75}]
[]
[null,null,null,{"$f":"+D9+D10","v":7.75},{"$f":"+D12+D10","v":8.5},{"$f":"+E12+D10","v":9.25}]

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