{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tomat 300 eko","Arbete 300 m2 ekotomat","Inv-båghus"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":3,"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":"Tomat 300 eko","index":0,"n_rows":64,"n_cols":8,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Liten ekologisk tomatodling, kort kultur, enkel värme",null,null,null,null,"Växthus: 300 m2 plasttunnel "]
["Kort kultur",null,"Kulturtid: v. 12 - 43",null,null,"täckt med dubbel folie"]
["Skördenivå",null,28,"kg/m2"]
[]
[null,null,"Per",300,"m2","Per 1000 m2","kr/kg"]
[]
[null,"Enh.","Antal","à-pris","summa"]
["Intäkter",null,{"$f":"C3*D5","v":8400},{"$f":"(E27+E38)/C8","v":29.166097802293251},{"$f":"C8*D8","v":244995.22153926332},{"$f":"E8*1000/D5","v":816650.738464211},{"$f":"F8/$C$3/1000","v":29.166097802293251}]
[null,null,null,null,null,null,{"$f":"F9/$C$3/1000","v":0}]
["Kostnader",null,null,null,null,null,0]
["Arbete","tim",{"$f":"E56","v":360.71085714285715},200,{"$f":"C11*D11","v":72142.171428571426},{"$f":"E11*1000/$D$5","v":240473.90476190476},8.5883537414965989]
["Pellets","ton",{"$f":"'Arbete 300 m2 ekotomat'!L65","v":22.947990543735227},1700,39011.583924349885,{"$f":"E12*1000/$D$5","v":130038.61308116627},4.6442361814702249]
["El","kWh",1000,0.75,750,2500,8.9285714285714288E-2]
["Plantor","st",390,36,14040,46800,1.6714285714285713]
["Uppbindning/Div","st",300,6,1800,6000,0.21428571428571427]
["Jordförbättring","m3",3,400,1200,4000,0.14285714285714285]
["Gödsel","m2",300,8,{"$f":"C17*D17","v":2400},8000,0.2857142857142857]
["Vatten","m3",200,6,{"$f":"C18*D18","v":1200},4000,0.14285714285714285]
["Biol.bek, såpa",null,{"$f":"D5","v":300},5,{"$f":"C19*D19","v":1500},5000,0.17857142857142858]
["Humlor","samh.",3,650,2500,8333.3333333333339,0.29761904761904767]
["Analyser",null,4,300,2500,8333.3333333333339,0.29761904761904767]
["Ränta driftskapital","kr",{"$f":"SUM(E11:E21)","v":139043.75535292132},0.02,{"$f":"C22*D22","v":2780.8751070584262},9269.583690194755,0.33105656036409842]
[]
["Emballage (5,5 kg retur)","st",{"$f":"C8/5.5","v":1527.2727272727273},2.2000000000000002,{"$f":"C24*D24","v":3360},11200,0.4]
["Transporter",null,{"$f":"C8","v":8400},0.25,{"$f":"C25*D25","v":2100},7000,0.25]
["Försäljningskostnad",null,{"$f":"(SUM(E11:E25)+E38)/(1-D26)","v":244995.22153926329},0.03,{"$f":"C26*D26","v":7349.8566461778983},24499.522153926326,0.87498293406879735]
["Summa särkostnader",null,null,null,{"$f":"SUM(E11:E26)","v":154634.48710615767},515448.29035385884,18.408867512637816]
["TB",null,null,null,{"$f":"E8-E27","v":90360.734433105652},301202.44811035215,10.757230289655434]
[]
["Samkostnader"]
["Kravavgifter",null,null,null,2675,8916.6666666666661,0.31845238095238093]
["Adm. Samkostnader",null,{"$f":"D5","v":300},30,{"$f":"C32*D32","v":9000},30000,1.0714285714285714]
["Mark",null,{"$f":"D5","v":300},3,{"$f":"C33*D33","v":900},3000,0.10714285714285714]
["Underhåll",null,{"$f":"D5","v":300},20,{"$f":"C34*D34","v":6000},20000,0.7142857142857143]
["Avskr växthus",null,{"$f":"'Inv-båghus'!B34","v":458000},0.1,{"$f":"C35*D35","v":45800},152666.66666666666,5.4523809523809526]
["Avskr. Invent.",null,{"$f":"'Inv-båghus'!B35","v":54000},0.2,{"$f":"C36*D36","v":10800},36000,1.2857142857142858]
["Räntor",null,null,null,{"$f":"'Inv-båghus'!G36","v":15185.734433105632},50619.114777018774,1.8078255277506705]
["S:a samkostnader",null,null,null,{"$f":"SUM(E31:E37)","v":90360.734433105637},301202.4481103521,10.757230289655432,{"$f":"SUM(G35:G37)","v":8.5459207658459082}]
["Resultat",null,null,null,{"$f":"E28-E38","v":0},0,0]
[]
[]
[]
["Arbete"]
["Moment",null,"Arbete "]
[null,null,"arealb.","skördeb."]
[]
["Plantering/Uppbindning","tim",{"$f":"'Arbete 300 m2 ekotomat'!D20+'Arbete 300 m2 ekotomat'!D21","v":35}]
["Pincering/nedläggning","tim",{"$f":"'Arbete 300 m2 ekotomat'!F62","v":74.567999999999998}]
["Avbladning","tim",{"$f":"'Arbete 300 m2 ekotomat'!G62","v":28.6}]
["Övrigt arbete","tim",{"$f":"'Arbete 300 m2 ekotomat'!H62","v":65.742857142857133}]
["Skörd/Packning","tim",null,{"$f":"'Arbete 300 m2 ekotomat'!J62","v":136.80000000000001}]
["Utrivning/sanering","tim",{"$f":"'Arbete 300 m2 ekotomat'!D53+'Arbete 300 m2 ekotomat'!D54","v":20}]
["Försäljning","tim"]
["Transporter externt","tim",null,null,"Summa"]
[null,null,null,null,"arbete"]
["Summa","tim",{"$f":"SUM(C47:C55)","v":223.91085714285714},{"$f":"SUM(D47:D55)","v":136.80000000000001},{"$f":"C56+D56","v":360.71085714285715}]
[]
[]
[]
["Känslighetsanalys för hur skörden påverkar självkostnadspriset"]
[]
[]
["Skörd (kg/m2)",20,24,28,32,36]
["Självkostnadspris (kr/kg)",39.194480958556639,33.344590784069659,29.166097802293251,26.032228065960936,23.594773826591361]

{"sheet":"Arbete 300 m2 ekotomat","index":1,"n_rows":65,"n_cols":13,"rows_kept":65,"cut":false,"hidden":false,"merged":[]}
["Arbete i tomatodling",null,"Ekologisk liten",null,null,"Arbetsprestationer",null,null,null,null,"Resultat"]
[null,"Areal",300,"m2",null,"Pincering/Snurrning",null,250,"toppar/tim",null,"Skörd",{"$f":"'Tomat 300 eko'!C3","v":28},"kg/m2"]
[null,"Normalskörd",28,"kg/m2",null,"Avbladning",null,600,"toppar/tim",null,"Arbete",{"$f":"K62*1000/C2","v":1202.3695238095233},"tim/1000 m2"]
[null,"Planttäthet",1.3,"pl/m2",null,"Tillsyn, bek mm",null,350,"toppar/tim",null,"Pro.pris",{"$f":"'Tomat 300 eko'!D8","v":29.166097802293251},"kr/kg"]
[]
["Vecka","Text","Skörd ","Övrigt","Toppar","Pincering","Avbladn.","Tillsyn","Skörd","Skörde-","Summa","Energi"]
[null,null,null,"arbete","per planta","Snurrning",null,"Bek/gödsl","sortering","arbete","arbete","förbrukning"]
[null,null,"kg/m2","tim/vecka","st","tim/vecka","tim/vecka","tim/vecka","(kg/tim)","tim/vecka","tim/vecka","MWh/vecka"]
[null,null,null,"hela ytan"]
[1,null,null,null,null,null,null,null,null,null,{"$f":"D10+F10+G10+H10+J10","v":0},0]
[{"$f":"A10+1","v":2},null,null,null,null,null,null,null,null,null,0,0]
[3,null,null,null,null,null,null,null,null,null,0,0]
[4,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,0,0]
[7,null,null,null,null,null,null,null,null,null,0,0]
[8,null,null,null,null,null,null,null,null,null,0,0]
[9,null,null,null,null,null,null,null,null,null,0,0]
[10,null,null,null,null,null,null,null,null,null,0,0]
[11,"Förberedelse",null,20,null,null,null,null,null,null,20,9.3222222222222229]
[12,"Plantering",null,15,null,null,null,null,null,null,15,8.5777777777777775]
[13,null,null,null,2,{"$f":"0.2*$C$2*$C$4*E22/$H$2","v":0.624},null,{"$f":"0.5*$C$4*E22*$C$2/$H$4","v":1.1142857142857143},null,null,1.7382857142857144,7.7111111111111112]
[14,null,null,null,2,{"$f":"0.4*$C$2*$C$4*E23/$H$2","v":1.248},null,1.1142857142857143,null,null,2.3622857142857141,7.0111111111111102]
[15,null,null,null,2,{"$f":"0.6*$C$2*$C$4*E24/$H$2","v":1.8720000000000001},null,1.1142857142857143,null,null,2.9862857142857147,6.1888888888888891]
[16,null,null,null,2,{"$f":"0.8*$C$2*$C$4*E25/$H$2","v":2.496},{"$f":"0.2*$C$4*E22*$C$2/$H$3","v":0.26},1.1142857142857143,null,null,3.8702857142857146,5.333333333333333]
[17,null,null,null,2,{"$f":"0.8*$C$2*$C$4*E26/$H$2","v":2.496},{"$f":"0.4*$C$4*E23*$C$2/$H$3","v":0.52},1.1142857142857143,null,null,4.1302857142857139,4.4888888888888889]
[18,null,null,null,2,{"$f":"0.8*$C$2*$C$4*E27/$H$2","v":2.496},{"$f":"0.6*$C$4*E24*$C$2/$H$3","v":0.78},1.1142857142857143,null,null,4.3902857142857137,3.6555555555555554]
[19,null,null,null,2,{"$f":"0.8*$C$2*$C$4*E28/$H$2","v":2.496},{"$f":"0.8*$C$4*E25*$C$2/$H$3","v":1.04},{"$f":"$C$4*E28*$C$2/$H$4","v":2.2285714285714286},null,null,5.7645714285714291,3.0111111111111111]
[20,null,null,null,2,{"$f":"$C$2*$C$4*E29/$H$2","v":3.12},{"$f":"$C$4*E29*$C$2/$H$3","v":1.3},2.2285714285714286,null,null,6.6485714285714286,2.0333333333333332]
[21,null,{"$f":"0.2*$L$2/$C$3","v":0.2},null,2,3.12,1.3,2.2285714285714286,40,{"$f":"C30*$C$2/I30","v":1.5},8.1485714285714295,1.788888888888889]
[22,null,{"$f":"0.8*$L$2/$C$3","v":0.8},null,2,3.12,1.3,2.2285714285714286,50,4.8,11.448571428571428,1.5666666666666664]
[23,null,{"$f":"1.2*$L$2/$C$3","v":1.2},null,2,3.12,1.3,2.2285714285714286,60,6,12.648571428571429,1.4]
[24,null,{"$f":"1.4*$L$2/$C$3","v":1.4},null,2,3.12,1.3,2.2285714285714286,60,7,13.648571428571429,1.2666666666666666]
[25,null,{"$f":"1.4*$L$2/$C$3","v":1.4},null,2,3.12,1.3,2.2285714285714286,60,7,13.648571428571429,1.1555555555555557]
[26,null,{"$f":"1.5*$L$2/$C$3","v":1.5},null,2,3.12,1.3,2.2285714285714286,60,7.5,14.148571428571429,1.0888888888888888]
[27,null,{"$f":"1.6*$L$2/$C$3","v":1.6},null,2,3.12,1.3,2.2285714285714286,60,8,14.648571428571429,1]
[28,null,{"$f":"1.7*$L$2/$C$3","v":1.7},null,2,3.12,1.3,2.2285714285714286,60,8.5,15.148571428571429,0.93333333333333324]
[29,null,{"$f":"1.7*$L$2/$C$3","v":1.7},null,2,3.12,1.3,2.2285714285714286,60,8.5,15.148571428571429,0.92222222222222217]
[30,null,1.7,null,2,3.12,1.3,2.2285714285714286,60,8.5,15.148571428571429,0.93333333333333324]
[31,null,1.7,null,2,3.12,1.3,2.2285714285714286,60,8.5,15.148571428571429,1.0222222222222221]
[32,null,{"$f":"1.6*$L$2/$C$3","v":1.6},null,2,3.12,1.3,2.2285714285714286,60,8,14.648571428571429,1.0777777777777777]
[33,null,{"$f":"1.5*$L$2/$C$3","v":1.5},null,2,3.12,1.3,2.2285714285714286,60,7.5,14.148571428571429,1.1333333333333333]
[34,null,{"$f":"1.4*$L$2/$C$3","v":1.4},null,2,3.12,1.3,2.2285714285714286,60,7,13.648571428571429,1.2777777777777777]
[35,null,{"$f":"1.4*$L$2/$C$3","v":1.4},null,2,3.12,1.3,2.2285714285714286,60,7,13.648571428571429,1.5222222222222224]
[36,null,{"$f":"1.3*$L$2/$C$3","v":1.3},null,2,3.12,1.3,2.2285714285714286,60,6.5,13.148571428571429,1.822222222222222]
[37,"Toppning",{"$f":"1.1*$L$2/$C$3","v":1.1000000000000001},null,2,{"$f":"0.5*$C$2*$C$4*E46/$H$2","v":1.56},1.3,2.2285714285714286,60,5.5,10.588571428571429,2.3888888888888888]
[38,null,{"$f":"1*$L$2/$C$3","v":1},null,2,{"$f":"0.5*$C$2*$C$4*E47/$H$2","v":1.56},{"$f":"0.5*$C$4*E47*$C$2/$H$3","v":0.65},{"$f":"1.5*$C$4*E47*$C$2/$H$4","v":3.342857142857143},60,5,10.552857142857142,3.1]
[39,null,{"$f":"0.9*$L$2/$C$3","v":0.9},null,2,{"$f":"0.5*$C$2*$C$4*E48/$H$2","v":1.56},{"$f":"0.5*$C$4*E48*$C$2/$H$3","v":0.65},{"$f":"1.5*$C$4*E48*$C$2/$H$4","v":3.342857142857143},60,4.5,10.052857142857142,3.6777777777777776]
[40,null,{"$f":"0.8*$L$2/$C$3","v":0.8},null,2,{"$f":"0.5*$C$2*$C$4*E49/$H$2","v":1.56},{"$f":"0.5*$C$4*E49*$C$2/$H$3","v":0.65},{"$f":"1.5*$C$4*E49*$C$2/$H$4","v":3.342857142857143},60,4,9.5528571428571425,4.3555555555555552]
[41,null,{"$f":"0.7*$L$2/$C$3","v":0.7},null,2,{"$f":"0.5*$C$2*$C$4*E50/$H$2","v":1.56},{"$f":"0.5*$C$4*E50*$C$2/$H$3","v":0.65},{"$f":"1.5*$C$4*E50*$C$2/$H$4","v":3.342857142857143},60,3.5,9.0528571428571425,5.0222222222222213]
[42,null,{"$f":"0.5*$L$2/$C$3","v":0.5},null,2,null,null,{"$f":"$C$4*E51*$C$2/$H$4","v":2.2285714285714286},60,2.5,4.7285714285714286,5.7333333333333334]
[43,null,{"$f":"0.9*$L$2/$C$3","v":0.9},null,2,null,null,{"$f":"0.5*$C$4*E52*$C$2/$H$4","v":1.1142857142857143},null,null,{"$f":"D52+F52+G52+H52+J52","v":1.1142857142857143},6.333333333333333]
[44,"Utrivning",null,12,null,null,null,null,null,null,{"$f":"D53+F53+G53+H53+J53","v":12},0]
[45,"Städning",null,8,null,null,null,null,null,null,8,0]
[46,null,null,null,null,null,null,null,null,null,0,0]
[47,null,null,null,null,null,null,null,null,null,0,0]
[48,null,null,null,null,null,null,null,null,null,0,0]
[49,null,null,null,null,null,null,null,null,null,null,0]
[50,null,null,null,null,null,null,null,null,null,null,0]
[51,null,null,null,null,null,null,null,null,null,null,0]
[52,null,null,null,null,null,null,null,null,null,null,0]
[null,"Summa",{"$f":"SUM(C10:C61)","v":27.999999999999993},{"$f":"SUM(D8:D61)","v":55},null,{"$f":"SUM(F8:F61)","v":74.567999999999998},{"$f":"SUM(G8:G61)","v":28.6},{"$f":"SUM(H8:H61)","v":65.742857142857133},null,{"$f":"SUM(J8:J61)","v":136.80000000000001},{"$f":"SUM(K8:K61)","v":360.71085714285698},{"$f":"SUM(L10:L61)","v":107.85555555555557}]
[]
[null,null,null,null,null,null,null,null,null,"Pellets energiinnehåll",null,4.7,"MW/ton"]
[null,null,null,null,null,null,null,null,null,"Pellets",null,{"$f":"L62/L64","v":22.947990543735227},"ton"]

{"sheet":"Inv-båghus","index":2,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["Typföretag 1"]
["Litet bågväxthus täckt med dubbelfolie och takventilation. 30x10 m"]
["Invändig frihöjd ca 4 m. Totalhöjd ca 6 m"]
["Varmluftspanna som eldas med pelltes"]
[]
[null,null,"i kalkylen","**"]
["Växthustyp","Båghus med dubbelplast"]
["Växthusareal",300,"m2"]
[null,null,null,null,null,"Avskrivnings-"]
["Kostnader","kr/m2","m2","Summa",null,"tid"]
[]
["Växthusstomme",null,{"$f":"$B$8","v":300},180000,null,10]
["Täckmaterial",60,{"$f":"$B$8","v":300},20000,null,5]
["Markarbeten",70,300,{"$f":"C14*B14","v":21000},null,10]
["Vävar","inga",300]
["Panna, skorsten mm 60 kW",null,300,150000,null,10]
["Ackumulatortank","ingen",300]
["Värmefördelningssystem",null,300,10000,null,5]
["Fläktar",null,300,8000,null,10]
["Klimatstyrning",null,300,60000,null,10]
["Gödselblandare",null,300,18000,null,10]
["Droppbevattning",80,300,{"$f":"B22*C22","v":24000},null,5]
["Nedläggningssystem",20,300,{"$f":"B23*C23","v":6000},null,10]
["Vagnar ",null,300,15000,null,10]
["Sorteringsutrustning","ingen",300]
["Kyllager ","inget",300]
[]
["Summa",{"$f":"D28/C28","v":1706.6666666666667},300,{"$f":"SUM(D12:D26)","v":512000}]
[]
["Räntesats",0.05]
[null,"Avskrivn.","Avskrivn.",null,null,"Annuitets-","Årlig"]
[null,"underlag","tid (år)","Avskrivning",null,"faktor","räntekostn."]
["Årskostnader 300 m2"]
["Växthus mm 10 år",{"$f":"D12+D14+D16+D19+D20+D21+D23+D24","v":458000},10,{"$f":"B34/C34","v":45800},null,{"$f":"$B$30/(1-(1+$B$30)^-C34)","v":0.12950457496545667},{"$f":"F34*B34-D34","v":13513.095334179154}]
["Inventarier 5 år",{"$f":"D13+D18+D22","v":54000},5,{"$f":"B35/C35","v":10800},null,{"$f":"$B$30/(1-(1+$B$30)^-C35)","v":0.2309747981282681},{"$f":"F35*B35-D35","v":1672.6390989264783}]
[null,"S:a årskostnad",null,{"$f":"SUM(D34:D35)","v":56600},null,null,{"$f":"SUM(G34:G35)","v":15185.734433105632},{"$f":"SUM(D36:G36)","v":71785.734433105637}]
[null,"Årskostnad/m2",null,{"$f":"D36/250","v":226.4},null,null,{"$f":"G36/250","v":60.742937732422526},{"$f":"SUM(D37:G37)","v":287.14293773242252}]