{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Omloppskalkyl","Etableringsår","Skördeår 1","Skördeår 2","Maskiner","Bevattningsutrustning","Byggnader","Prislista"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":29,"comments":7,"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":"Omloppskalkyl","index":0,"n_rows":55,"n_cols":7,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
["Ekologiska jordgubbar på bar mark",null,null,"Beräkning per ha",null,"Företaget har 30 ha odling varav 10 ha jordgubbar"]
["2020 års prisnivå"]
["Omloppskalkyl "]
[]
[]
["Kalkylränta",{"$f":"Prislista!B17","v":0.02},null,"Självkostnadspris",null,23.412251710235751,"kr/liter"]
[]
[null,null,"År 0","År 1","År 2"]
["Skörd (kartonger á 500 g)","st",{"$f":"Etableringsår!C7","v":0},{"$f":"'Skördeår 1'!C7","v":14000},{"$f":"'Skördeår 2'!C7","v":14000}]
["Bärförsäljning","kr",{"$f":"C9*F6","v":0},{"$f":"D9*F6","v":327771.52394330053},{"$f":"E9*F6","v":327771.52394330053}]
["Miljöersättning och gårdsstöd","kr",{"$f":"Etableringsår!E8+Etableringsår!E9","v":9500},{"$f":"'Skördeår 1'!E8+'Skördeår 1'!E9","v":9500},{"$f":"'Skördeår 2'!E8+'Skördeår 2'!E9","v":9500}]
["Intäkter","kr",{"$f":"SUM(C10:C11)","v":9500},{"$f":"SUM(D10:D11)","v":337271.52394330053},{"$f":"SUM(E10:E11)","v":337271.52394330053}]
[]
["Skördebundna kostnader","kr",null,{"$f":"'Skördeår 1'!E34","v":117598.57619716504},{"$f":"'Skördeår 2'!E34","v":111043.14571829901}]
["Arealbundna kostnader","kr",{"$f":"Etableringsår!E25","v":164664.05271704131},{"$f":"'Skördeår 1'!E24","v":34404.952717041298},{"$f":"'Skördeår 2'!E24","v":29674.192717041296}]
["S:a särkostnader","kr",{"$f":"C14+C15","v":164664.05271704131},{"$f":"D14+D15","v":152003.52891420634},{"$f":"E14+E15","v":140717.33843534032}]
[]
["Administration","kr",{"$f":"Etableringsår!E47","v":20000},{"$f":"'Skördeår 1'!E45","v":40000},{"$f":"'Skördeår 2'!E45","v":40000}]
["Fasta maskinkostnader","kr",{"$f":"Etableringsår!E43+Etableringsår!E44","v":20772.602873403215},{"$f":"'Skördeår 1'!E41+'Skördeår 1'!E42","v":20772.602873403215},{"$f":"'Skördeår 2'!E41+'Skördeår 2'!E42","v":20772.602873403215}]
["Byggnader","kr",{"$f":"Etableringsår!E45","v":13420.528740381382},{"$f":"'Skördeår 1'!E43","v":13420.528740381382},{"$f":"'Skördeår 2'!E43","v":13420.528740381382}]
["Mark/Certifiering","kr",{"$f":"Etableringsår!E46+Etableringsår!E48","v":5500},{"$f":"'Skördeår 1'!E44+'Skördeår 1'!E46","v":6000},{"$f":"'Skördeår 2'!E44+'Skördeår 2'!E46","v":6000}]
["Summa kostnader","kr",{"$f":"SUM(C18:C21)+C16","v":224357.18433082593},{"$f":"SUM(D18:D21)+D16","v":232196.66052799096},{"$f":"SUM(E18:E21)+E16","v":220910.47004912491}]
["Överskott","kr",{"$f":"C12-C22","v":-214857.18433082593},{"$f":"D12-D22","v":105074.86341530958},{"$f":"E12-E22","v":116361.05389417562}]
["Nuvärdefaktor",null,{"$f":"(1+$B$6)^0","v":1},{"$f":"(1+$B$6)^-1","v":0.98039215686274506},{"$f":"(1+$B$6)^-2","v":0.96116878123798544}]
["Nuvärde","kr",{"$f":"+C23*C24","v":-214857.18433082593},{"$f":"+D23*D24","v":103014.5719757937},{"$f":"+E23*E24","v":111842.61235503232}]
["Summa nuvärde","kr",{"$f":"+C25","v":-214857.18433082593},{"$f":"+C26+D25","v":-111842.61235503222},{"$f":"+D26+E25","v":0}]
[]
["Gårdsareal jordbruksmark",30,"ha"]
["Areal jordgubbar ",10,"ha"]
["Skörd",14000,"l/ha",null,"14 000 l normalt"]
["Känslighetsanalys för hur skörden påverkar självkostnadspriset"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Skörd (l/ha)",6000,10000,14000,18000,22000]
["Självkostnadspris",45.516536438547327,30.04353712872922,23.412251710235743,19.728204255517149,17.383810420696229]

{"sheet":"Etableringsår","index":1,"n_rows":77,"n_cols":7,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Omloppskalkyl!A1","v":"Ekologiska jordgubbar på bar mark"},null,null,null,"etableringsåret"]
[]
["Areal enhet",null,1,"ha",33400,null,"plantor"]
["Skördenivå brutto",null,0,"kg/ha"]
[]
["Intäkter          ","Enhet","Kvantitet","á-pris","Summa"]
["Jordgubbar i 500 g kartong","st",{"$f":"C4*2","v":0},null,{"$f":"C7*D7","v":0},null,"Självkostnadspris"]
["Miljöersättning",null,null,null,{"$f":"Prislista!B7","v":7500}]
["Gårdsstöd",null,null,null,{"$f":"Prislista!B8","v":2000}]
["Summa Intäkter",null,null,null,{"$f":"SUM(E7:E9)","v":9500}]
[]
["Särkostnader"]
["Arbete odling kvalificerat","tim",{"$f":"SUM(C58:C65)","v":51},{"$f":"Prislista!B11","v":283},{"$f":"C13*D13","v":14433}]
["Arbete odling okvalificerat","tim",{"$f":"SUM(B58:B65)","v":235},{"$f":"Prislista!B12","v":186},43710]
["Plantor","st",{"$f":"E3","v":33400},{"$f":"Prislista!B27","v":2.15},71810,null,"Radavstånd: 1,2 m. Plantavstånd: 25 cm"]
["Nötgödsel","kg",30000,{"$f":"Prislista!B39","v":0.2},6000,null,"inkl. spridning"]
["Växtskydd",null,1,{"$f":"G77","v":3470},3470]
["Halm","kg",0,{"$f":"Prislista!B31","v":1},0]
["Drivm. traktor arealbundet","tim",{"$f":"SUM(D58:D65)","v":31},{"$f":"Prislista!B23","v":88},2728]
["Bevattning (elkostnad)","kWh",650,{"$f":"Prislista!B24","v":0.96},624]
["Fiberduk, 19 g/m2","m²",10000,{"$f":"Prislista!B30","v":1.1000000000000001},11000,null,"väven läggs ut under hösten"]
["Trampnät",null,1,{"$f":"Prislista!B56","v":7160.3458010208778},7160.3458010208778,null,"Avskrivs på 5 år"]
["Analyser","st",1,{"$f":"Prislista!B32","v":500},500]
["Ränta rörelsekapital",null,{"$f":"SUM(E13:E23)","v":161435.34580102089},{"$f":"Prislista!B20","v":0.02},3228.7069160204178]
["Summa arealbundna kostnader",null,null,null,{"$f":"SUM(E13:E24)","v":164664.05271704131}]
[]
[]
["Arbete skörd kvalificerat","tim",{"$f":"SUM(C66:C67)","v":0},{"$f":"Prislista!B11","v":283},{"$f":"C28*D28","v":0}]
["Plockning","l",{"$f":"C7","v":0},{"$f":"Prislista!B13","v":4},{"$f":"C29*D29","v":0}]
["Plockning, sociala avgifter",{"$f":"Prislista!B14","v":0.36499999999999999},{"$f":"C29","v":0},{"$f":"D29*B30","v":1.46},{"$f":"C30*D30","v":0}]
["Drivm. traktor skördebundet","tim",{"$f":"SUM(D66:D67)","v":0},{"$f":"Prislista!B23","v":88},{"$f":"C31*D31","v":0}]
["Jordgubbskartonger","st",{"$f":"C7","v":0},{"$f":"Prislista!B33","v":0.5},{"$f":"C32*D32","v":0}]
["Engångslådor (för 15 kartonger)","st",{"$f":"C7/15","v":0},{"$f":"Prislista!B34","v":9},0]
["Transport","st",{"$f":"C7","v":0},{"$f":"Prislista!B35","v":0},0,null,"Säljs fritt odlingen"]
["Försäljningskostnad","%",{"$f":"E7","v":0},{"$f":"Prislista!B36","v":0.03},0]
["Summa skördebundna kostnader",null,null,null,{"$f":"SUM(E28:E35)","v":0}]
[]
["Summa särkostnader",null,null,null,{"$f":"E25+E36","v":164664.05271704131}]
[]
["Täckningsbidrag",null,null,null,{"$f":"E10-E38","v":-155164.05271704131}]
[]
["Samkostnader"]
["Maskiner",null,1,{"$f":"Maskiner!O26","v":12616.384655763834},{"$f":"C43*D43","v":12616.384655763834}]
["Bevattningsmaskin",null,1,{"$f":"Bevattningsutrustning!C21","v":8156.2182176393817},8156.2182176393817]
["Byggnader",null,1,{"$f":"Byggnader!G24","v":13420.528740381382},13420.528740381382]
["Arrende/jorddränta",null,1,{"$f":"Prislista!B4","v":5000},5000]
["Administration/företagsledning",null,0.1,200000,20000]
["Certifieringsavgifter ",null,0.1,{"$f":"Prislista!B5","v":5000},500]
["Summa samkostnader",null,null,null,{"$f":"SUM(E43:E48)","v":59693.131613784601}]
[]
["Resultat",null,null,null,{"$f":"E40-E49","v":-214857.18433082593}]
[]
[]
["Arbete"]
[]
[null,"Okvali-ficerat arbete","Kvalificerat arbete","Traktor"]
["Moment","tim/ha","tim/ha","tim/ha",null,null,"Kommentar"]
["Markberedning",null,3,3]
["Plantering",24,8,8,null,null,"1000 pl/tim, 3 radig, 4 man, 32 tim "]
["Växtskydd",2,2,2,null,null,"4 ggr sprutning + kvalster"]
["Bevattning",null,4,4]
["Radhackning/Radfräsning",null,8,8,null,null,"1 gång/vecka enl Winter, jo16_25"]
["Handrensning",200,20]
["Halmning",3,3,3,null,null,"maskin, 2 pers"]
["Vävtäckning",6,3,3]
["Skörd, arbetsledning"]
["Skörd, intern transport"]
["Summa",{"$f":"SUM(B58:B67)","v":235},{"$f":"SUM(C58:C67)","v":51},{"$f":"SUM(D58:D67)","v":31}]
[]
[]
["Specifikation av växtskyddsmedel"]
[null,"enhet","mängd","ggr","à-pris",null,"Summa"]
["Kumulus DF","kg",4,2,{"$f":"Prislista!B46","v":160},null,{"$f":"C73*D73*E73","v":1280}]
["Serenade ASO (Bacillus subtilis)","l",5,2,{"$f":"Prislista!B47","v":154},null,{"$f":"C74*D74*E74","v":1540}]
["Sluxx HP mot sniglar","kg",null,null,{"$f":"Prislista!B48","v":69},null,0]
["Rovkvalster Neoseiulus cucmeris","300000 st",2,1,{"$f":"Prislista!B49","v":325},null,{"$f":"C76*D76*E76","v":650}]
[null,null,null,null,"Summa:",null,{"$f":"SUM(G73:G76)","v":3470}]

{"sheet":"Skördeår 1","index":2,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Omloppskalkyl!A1","v":"Ekologiska jordgubbar på bar mark"},null,null,null,"skördeår 1"]
[]
["Areal enhet",null,1,"ha","33 400 plantor"]
["Skördenivå brutto",null,{"$f":"Omloppskalkyl!B30/2","v":7000},"kg/ha"]
[]
["Intäkter          ","Enhet","Kvantitet","á-pris","Summa"]
["Jordgubbar i 500 g kartong","st",{"$f":"C4*2","v":14000},{"$f":"Omloppskalkyl!F6","v":23.412251710235751},{"$f":"C7*D7","v":327771.52394330053},null,"Självkostnadspris"]
["Miljöersättning eko",null,null,null,{"$f":"Prislista!B7","v":7500}]
["Gårdsstöd",null,null,null,{"$f":"Prislista!B8","v":2000}]
["Summa Intäkter",null,null,null,{"$f":"SUM(E7:E9)","v":337271.52394330053}]
[]
["Särkostnader"]
["Arbete odling kvalificerat","tim",{"$f":"SUM(C57:C64)","v":41},{"$f":"Prislista!B11","v":283},{"$f":"C13*D13","v":11603}]
["Arbete odling okvalificerat","tim",{"$f":"SUM(B57:B64)","v":115},{"$f":"Prislista!B12","v":186}]
["Pelleterad ekogödsel","kg",600,{"$f":"Prislista!B40","v":4.7},2820]
["Växtskydd",null,1,{"$f":"G76","v":4295},4295]
["Halm","kg",4000,{"$f":"Prislista!B31","v":1},4000]
["Drivm. traktor arealbundet","tim",{"$f":"SUM(D57:D64)","v":31},{"$f":"Prislista!B23","v":88},2728]
["Bevattning (elkostnad)","kWh",650,{"$f":"Prislista!B24","v":0.96},624]
["Fiberduk, 19 g/m²","m²",0,{"$f":"Prislista!B30","v":1.1000000000000001},0,null,"väven håller i två år"]
["Trampnät",null,1,{"$f":"Prislista!B56","v":7160.3458010208778},7160.3458010208778,null,"Avskrivs på 5 år"]
["Analyser","st",1,{"$f":"Prislista!B32","v":500},500]
["Ränta rörelsekapital",null,{"$f":"SUM(E13:E22)","v":33730.345801020878},{"$f":"Prislista!B20","v":0.02},674.60691602041754]
["Summa arealbundna kostnader",null,null,null,{"$f":"SUM(E13:E23)","v":34404.952717041298}]
[]
["Arbete skörd kvalificerat","tim",{"$f":"SUM(C65:C66)","v":30},{"$f":"Prislista!B11","v":283},{"$f":"C26*D26","v":8490}]
["Plockning","l",{"$f":"C7","v":14000},{"$f":"Prislista!B13","v":4},{"$f":"C27*D27","v":56000}]
["Plockning, sociala avgifter",{"$f":"Prislista!B14","v":0.36499999999999999},{"$f":"C27","v":14000},{"$f":"D27*B28","v":1.46},{"$f":"C28*D28","v":20440}]
["Drivm. traktor skördebundet","tim",{"$f":"SUM(D65:D66)","v":10},{"$f":"Prislista!B23","v":88},{"$f":"C29*D29","v":880}]
["Jordgubbskartonger","st",{"$f":"C7","v":14000},{"$f":"Prislista!B33","v":0.5},{"$f":"C30*D30","v":7000}]
["Returlådor","st",{"$f":"C7/15","v":933.33333333333337},{"$f":"Prislista!B34","v":9},{"$f":"D31*C31","v":8400}]
["Transport","st",{"$f":"C7","v":14000},{"$f":"Prislista!B35","v":0},{"$f":"D32*C32","v":0}]
["Försäljningskostnad","%",{"$f":"E7","v":327771.52394330053},0.05,{"$f":"D33*C33","v":16388.576197165028}]
["Summa skördebundna kostnader",null,null,null,{"$f":"SUM(E26:E33)","v":117598.57619716504}]
[]
["Summa särkostnader",null,null,null,{"$f":"E24+E34","v":152003.52891420634}]
[]
["Täckningsbidrag",null,null,null,{"$f":"E10-E36","v":185267.99502909419}]
[]
["Samkostnader"]
["Maskiner",null,1,{"$f":"Maskiner!O26","v":12616.384655763834},{"$f":"C41*D41","v":12616.384655763834}]
["Bevattningsmaskin",null,1,{"$f":"Bevattningsutrustning!C21","v":8156.2182176393817},8156.2182176393817]
["Byggnader",null,1,{"$f":"Byggnader!G24","v":13420.528740381382},13420.528740381382]
["Arrende/jorddränta",null,1,{"$f":"Prislista!B4","v":5000},5000]
["Administration/företagsledning",null,0.2,{"$f":"Prislista!B6","v":200000},40000]
["Certifieringsavgifter ",null,0.2,{"$f":"Prislista!B5","v":5000},1000]
["Avskrivning etablering",null,1,{"$f":"Omloppskalkyl!D23","v":105074.86341530958},105074.86341530958]
["Summa samkostnader",null,null,null,{"$f":"SUM(E40:E47)","v":185267.99502909416}]
[]
["Resultat",null,null,null,{"$f":"E38-E48","v":0}]
[]
[]
["Arbete"]
[]
[null,"Okvali-ficerat arbete","Kvalificerat arbete","Traktor"]
["Moment","tim/ha","tim/ha","tim/ha",null,null,"Kommentar"]
["Gödsling",null,4,4]
["Växtskydd",4,3,3,null,null,"4 ggr sprutning + Sluxx + 2 ggr kvalster"]
["Bevattning",null,5,5]
["Radhackning/Radfräsning",null,8,8]
["Handrensning",100,10]
["Halmning",3,3,3,null,null,"maskin, 2 pers"]
["Blasthuggning",null,2,2]
["Vävtäckning",8,6,6]
["Skörd, arbetsledning",null,20]
["Skörd, intern transport",null,10,10]
["Summa",{"$f":"SUM(B57:B66)","v":115},{"$f":"SUM(C57:C66)","v":71},{"$f":"SUM(D57:D66)","v":41}]
[]
[]
["Specifikation av växtskyddsmedel"]
[null,"enhet","mängd","ggr","à-pris",null,"Summa"]
["Kumulus DF","kg",4,2,{"$f":"Prislista!B46","v":160},null,{"$f":"C72*D72*E72","v":1280}]
["Serenade ASO (Bacillus subtilis)","l",4,2,{"$f":"Prislista!B47","v":154},null,{"$f":"C73*D73*E73","v":1232}]
["Sluxx HP mot sniglar","kg",7,1,{"$f":"Prislista!B48","v":69},null,{"$f":"C74*D74*E74","v":483}]
["Rovkvalster Neoseiulus cucmeris","300000 st",2,2,{"$f":"Prislista!B49","v":325},null,{"$f":"C75*D75*E75","v":1300}]
[null,null,null,null,"Summa:",null,{"$f":"SUM(G72:G75)","v":4295}]

{"sheet":"Skördeår 2","index":3,"n_rows":76,"n_cols":7,"rows_kept":76,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Omloppskalkyl!A1","v":"Ekologiska jordgubbar på bar mark"},null,null,null,"skördeår 2"]
[]
["Areal enhet",null,1,"ha",{"$f":"'Skördeår 1'!E3","v":"33 400 plantor"}]
["Skördenivå brutto",null,{"$f":"Omloppskalkyl!B30/2","v":7000},"kg/ha"]
[]
["Intäkter          ","Enhet","Kvantitet","á-pris","Summa"]
["Jordgubbar i 500 g kartong","st",{"$f":"C4*2","v":14000},{"$f":"Omloppskalkyl!F6","v":23.412251710235751},{"$f":"C7*D7","v":327771.52394330053},null,"Självkostnadspris"]
["Miljöersättning",null,null,null,{"$f":"Prislista!B7","v":7500}]
["Gårdsstöd",null,null,null,{"$f":"Prislista!B8","v":2000}]
["Summa Intäkter",null,null,null,{"$f":"SUM(E7:E9)","v":337271.52394330053}]
[]
["Särkostnader"]
["Arbete odling kvalificerat","tim",{"$f":"SUM(C57:C64)","v":33},{"$f":"Prislista!B11","v":283},{"$f":"C13*D13","v":9339}]
["Arbete odling okvalificerat","tim",{"$f":"SUM(B57:B64)","v":77},{"$f":"Prislista!B12","v":186}]
["Pelleterad ekogödsel","kg",600,{"$f":"Prislista!B40","v":4.7},2820]
["Växtskydd",null,1,{"$f":"G76","v":3005},3005]
["Halm","kg",4000,{"$f":"Prislista!B31","v":1},4000]
["Drivm. traktor arealbundet","tim",{"$f":"SUM(D57:D64)","v":26},{"$f":"Prislista!B23","v":88},2288]
["Bevattning (elkostnad)","kWh",500,{"$f":"Prislista!B24","v":0.96},480]
["Fiberduk, 19 g/m²","m²",0,{"$f":"Prislista!B30","v":1.1000000000000001},0,null,"väven håller i två år"]
["Trampnät",null,1,{"$f":"Prislista!B56","v":7160.3458010208778},7160.3458010208778,null,"Avskrivs på 5 år"]
["Analyser","st",0,{"$f":"Prislista!B32","v":500},0]
["Ränta rörelsekapital",null,{"$f":"SUM(E13:E22)","v":29092.345801020878},{"$f":"Prislista!B20","v":0.02},581.84691602041755]
["Summa arealbundna kostnader",null,null,null,{"$f":"SUM(E13:E23)","v":29674.192717041296}]
[]
["Arbete skörd kvalificerat","tim",{"$f":"SUM(C65:C66)","v":30},{"$f":"Prislista!B11","v":283},{"$f":"C26*D26","v":8490}]
["Plockning","l",{"$f":"C7","v":14000},{"$f":"Prislista!B13","v":4},{"$f":"C27*D27","v":56000}]
["Plockning, sociala avgifter",{"$f":"Prislista!B14","v":0.36499999999999999},{"$f":"C27","v":14000},{"$f":"D27*B28","v":1.46},{"$f":"C28*D28","v":20440}]
["Drivm. traktor skördebundet","tim",{"$f":"SUM(D65:D66)","v":10},{"$f":"Prislista!B23","v":88},{"$f":"C29*D29","v":880}]
["Jordgubbskartonger","st",{"$f":"C7","v":14000},{"$f":"Prislista!B33","v":0.5},{"$f":"C30*D30","v":7000}]
["Returlådor","st",{"$f":"C7/15","v":933.33333333333337},{"$f":"Prislista!B34","v":9},{"$f":"D31*C31","v":8400}]
["Transport","st",{"$f":"C7","v":14000},{"$f":"Prislista!B35","v":0},{"$f":"D32*C32","v":0},null,"Säljs fritt odlingen"]
["Försäljningskostnad","%",{"$f":"E7","v":327771.52394330053},{"$f":"Prislista!B36","v":0.03},{"$f":"D33*C33","v":9833.1457182990162}]
["Summa skördebundna kostnader",null,null,null,{"$f":"SUM(E26:E33)","v":111043.14571829901}]
[]
["Summa särkostnader",null,null,null,{"$f":"E24+E34","v":140717.33843534032}]
[]
["Täckningsbidrag",null,null,null,{"$f":"E10-E36","v":196554.18550796021}]
[]
["Samkostnader"]
["Maskiner",null,1,{"$f":"Maskiner!O26","v":12616.384655763834},{"$f":"C41*D41","v":12616.384655763834}]
["Bevattningsmaskin",null,1,{"$f":"Bevattningsutrustning!C21","v":8156.2182176393817},8156.2182176393817]
["Byggnader",null,1,{"$f":"Byggnader!G24","v":13420.528740381382},13420.528740381382]
["Arrende/jorddränta",null,1,{"$f":"Prislista!B4","v":5000},5000]
["Administration/företagsledning",null,0.2,{"$f":"Prislista!B6","v":200000},40000]
["Certifieringsavgifter ",null,0.2,{"$f":"Prislista!B5","v":5000},1000]
["Avskrivning etablering",null,1,{"$f":"Omloppskalkyl!E23","v":116361.05389417562},116361.05389417562]
["Summa samkostnader",null,null,null,{"$f":"SUM(E40:E47)","v":196554.18550796021}]
[]
["Resultat",null,null,null,{"$f":"E38-E48","v":0}]
[]
[]
["Arbete"]
[]
[null,"Okvali-ficerat arbete","Kvalificerat arbete","Traktor"]
["Moment","tim/ha","tim/ha","tim/ha",null,null,"Kommentar"]
["Gödsling",null,4,4]
["Växtskydd",2,3,3,null,null,"3 ggr sprutning + Sluxx + kvalster"]
["Bevattning",null,5,5]
["Radhackning/Radfräsning",null,6,6]
["Handrensning",70,7]
["Vävborttagning",2,3,3]
["Halmning",3,3,3,null,null,"maskin, 2 pers"]
["Röjning",null,2,2]
["Skörd, arbetsledning",null,20]
["Skörd, intern transport",null,10,10]
["Summa",{"$f":"SUM(B57:B66)","v":77},{"$f":"SUM(C57:C66)","v":63},{"$f":"SUM(D57:D66)","v":36}]
[]
[]
["Specifikation av växtskyddsmedel"]
[null,"enhet","mängd","ggr","à-pris",null,"Summa"]
["Kumulus DF","kg",4,1,{"$f":"Prislista!B46","v":160},null,{"$f":"C72*D72*E72","v":640}]
["Serenade ASO (Bacillus subtilis)","l",4,2,{"$f":"Prislista!B47","v":154},null,{"$f":"C73*D73*E73","v":1232}]
["Sluxx HP mot sniglar","kg",7,1,{"$f":"Prislista!B48","v":69},null,{"$f":"C74*D74*E74","v":483}]
["Rovkvalster Neoseiulus cucmeris","300000 st",2,1,{"$f":"Prislista!B49","v":325},null,{"$f":"C75*D75*E75","v":650}]
[null,null,null,null,"Summa:",null,{"$f":"SUM(G72:G75)","v":3005}]

{"sheet":"Maskiner","index":4,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Maskinkostnader  frilandsodling på barmark"]
[]
[null,null,"Traktor","Traktor","Plog+harvar+gödsel-spridare m.f. basmaskiner","Planterings-maskin","Spruta för rader","Radfräs","Vävläggare","Halmnings-maskin","Blast-huggare","Såmaskin för gräs och snigelgift","Skörde-vagnar","Hand-redskap"]
[null,null,"50 kW 4WD","40 kW 2WD","vagn, beg. traktorredskap","3-radig ny","3-radig bandspruta"]
["Ny/begagnad",null,"beg","beg","beg","ny","ny","ny","ny","ny","ny","ny","nya","nya"]
["Odlingsareal","ha",{"$f":"Omloppskalkyl!B28","v":30},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!B28","v":30},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10},{"$f":"Omloppskalkyl!$B$29","v":10}]
[]
["Årlig användningstid","tim",300,300,60,30,30,70,50,30,10,10,6000,200]
[]
["Inköpspris","kr",300000,100000,300000,140000,100000,100000,85000,150000,30000,35000,24000,20000]
["Återstående livslängd","år",8,8,8,12,12,12,12,12,12,12,6,5]
["Restvärde","kr",100000,50000,50000,28000,20000,10000,5000,15000,5000,10000,0,0]
["Värdeminskning per år","kr",{"$f":"(C10-C12)/C11","v":25000},{"$f":"(D10-D12)/D11","v":6250},31250,{"$f":"(F10-F12)/F11","v":9333.3333333333339},6666.666666666667,7500,6666.666666666667,11250,2083.3333333333335,2083.3333333333335,4000,4000]
[]
["Räntesats","%",{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02}]
["Annuitetsfaktor",null,{"$f":"C15/(1-(1+C15)^-C11)","v":0.13650979913376274},{"$f":"D15/(1-(1+D15)^-D11)","v":0.13650979913376274},0.13650979913376274,{"$f":"F15/(1-(1+F15)^-F11)","v":9.4559596622951519E-2},9.4559596622951519E-2,9.4559596622951519E-2,{"$f":"I15/(1-(1+I15)^-I11)","v":9.4559596622951519E-2},{"$f":"J15/(1-(1+J15)^-J11)","v":9.4559596622951519E-2},{"$f":"K15/(1-(1+K15)^-K11)","v":9.4559596622951519E-2},{"$f":"L15/(1-(1+L15)^-L11)","v":9.4559596622951519E-2},0.17852581233520237,0.2121583941043223]
["Årskostnad","kr",{"$f":"C16*(C10-(C12*(1+C15)^-C11))","v":29301.959826752547},{"$f":"D16*(D10-(D12*(1+D15)^-D11))","v":7825.4899566881368},35127.449783440687,{"$f":"F16*(F10-(F12*(1+F15)^-F11))","v":11150.67482177057},7964.7677298361214,8710.3636960656368,{"$f":"I16*(I10-(I12*(1+I15)^-I11))","v":7664.7677298361214},{"$f":"J16*(J10-(J12*(1+J15)^-J11))","v":13065.545544098455},{"$f":"K16*(K10-(K12*(1+K15)^-K11))","v":2463.989915573788},{"$f":"L16*(L10-(L12*(1+L15)^-L11))","v":2563.989915573788},4284.6194960448565,4243.1678820864463]
[]
["Nypris","kr",470000,230000,600000,40000,100000,100000,{"$f":"I10","v":85000},20000,30000,35000,24000,20000]
["Underhåll per 1000 kr nypris","kr/tim",0.1,0.1,0.5,1.5,0.7,1.5,0.5,0.5,0.5,0.5,0,0]
["Underhållskostnad per år","kr",{"$f":"C8*C19*C20/1000","v":14100},{"$f":"D8*D19*D20/1000","v":6900},18000,{"$f":"F8*F19*F20/1000","v":1800},2100,10500,{"$f":"I8*I19*I20/1000","v":2125},{"$f":"J8*J19*J20/1000","v":300},{"$f":"K8*K19*K20/1000","v":150},{"$f":"L8*L19*L20/1000","v":175},0,0]
[]
["Redskapskostnad"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S:a"]
["Kostnad per år","kr",{"$f":"C17+C21","v":43401.959826752543},{"$f":"D17+D21","v":14725.489956688136},{"$f":"E17+E21","v":53127.449783440687},{"$f":"F17+F21","v":12950.67482177057},10064.767729836121,19210.363696065637,{"$f":"I17+I21","v":9789.7677298361214},{"$f":"J17+J21","v":13365.545544098455},{"$f":"K17+K21","v":2613.989915573788},{"$f":"L17+L21","v":2738.989915573788},4284.6194960448565,4243.1678820864463]
["Kostnad per ha och år","kr",{"$f":"C25/C6","v":1446.7319942250847},{"$f":"D25/D6","v":1472.5489956688136},1770.9149927813562,{"$f":"F25/F6","v":1295.0674821770569},1006.4767729836121,1921.0363696065638,{"$f":"I25/I6","v":978.97677298361214},{"$f":"J25/J6","v":1336.5545544098454},{"$f":"K25/K6","v":261.39899155737879},{"$f":"L25/L6","v":273.89899155737879},428.46194960448565,424.31678820864465,{"$f":"SUM(C26:N26)","v":12616.384655763834}]

{"sheet":"Bevattningsutrustning","index":5,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Kostnader för bevattningsmaskiner"]
[]
[]
[null,null,"Bevattnings-maskin med ramp"]
[]
["Odlingsareal","ha",{"$f":"Omloppskalkyl!B29","v":10}]
[]
["Inköpspris","kr",590000]
["Återstående livslängd","år",12]
["Restvärde","kr",50000]
["Värdeminskning per år","kr",{"$f":"(C8-C10)/C9","v":45000}]
[]
["Räntesats","%",{"$f":"Prislista!B19","v":0.02}]
["Annuitetsfaktor",null,{"$f":"C13/(1-(1+C13)^-C9)","v":9.4559596622951519E-2}]
["Årskostnad","kr",{"$f":"C14*(C8-(C10*(1+C13)^-C9))","v":52062.182176393821}]
[]
["Underhåll per år","%",0.05]
["Underhållskostnad per år","kr",{"$f":"C17*C8","v":29500}]
[]
["Kostnad per år","kr",{"$f":"C15+C18","v":81562.182176393821}]
["Kostnad per ha och år","kr",{"$f":"C20/C6","v":8156.2182176393817}]

{"sheet":"Byggnader","index":6,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Kostnader för byggnader    "]
[]
[null,null,"Maskinhall\noisolerad \nplåthall","Inredning av personalutrymme i befintlig byggnad","Kyl i befintlig lokal","Två inhyrda bajamajor"]
[null,null,"12 x 18 m",null,"30 m²","8 månadshyror"]
[]
["Areal som betjänas","ha",{"$f":"Omloppskalkyl!B28","v":30},{"$f":"Omloppskalkyl!B29","v":10},{"$f":"Omloppskalkyl!B29","v":10},{"$f":"Omloppskalkyl!B29","v":10}]
[]
["Plåthall",null,540000]
["Uppsättning",null,165000]
["Markarbete",null,120000]
["Elinstallation",null,100000]
[]
["Investering","kr",{"$f":"SUM(C8:C11)","v":925000},400000,150000]
[]
["Avskrivningstid","år",20,15,10]
["Värdeminskning per år","kr",{"$f":"C13/C15","v":46250},{"$f":"D13/D15","v":26666.666666666668},{"$f":"E13/E15","v":15000}]
["Räntesats","%",{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02},{"$f":"Prislista!$B$19","v":0.02}]
["Annuitetsfaktor",null,{"$f":"C17/(1-(1+C17)^-C15)","v":6.1156718125290402E-2},0.10296276395531263,0.13586795822038372]
["Årskostnad","kr",{"$f":"C18*C13","v":56569.964265893621},{"$f":"D18*D13","v":41185.105582125056},{"$f":"E18*E13","v":20380.193733057557}]
["Underhåll","%",0.01,0.02,0.05]
["Underhåll","kr",{"$f":"C20*C13","v":9250},{"$f":"D20*D13","v":8000},{"$f":"E13*E20","v":7500}]
[null,null,null,null,null,null,"S:a"]
["Totalkostnad per år","kr",{"$f":"C19+C21","v":65819.964265893621},{"$f":"D19+D21","v":49185.105582125056},{"$f":"E19+E21","v":27880.193733057557},35200]
["Årskostnad per ha","kr",{"$f":"C23/C6","v":2193.9988088631208},{"$f":"D23/D6","v":4918.5105582125052},{"$f":"E23/E6","v":2788.0193733057558},{"$f":"F23/F6","v":3520},{"$f":"SUM(C24:F24)","v":13420.528740381382}]

{"sheet":"Prislista","index":7,"n_rows":56,"n_cols":5,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Priser på insatsmaterial i jordgubbsodling 2020"]
[]
["Fasta kostnader och stöd"]
["Arrende/jordränta",5000,"kr/ha"]
["Certifiering",5000,"kr/ha"]
["Administration och företagsledning",200000,"kr/ha"]
["Miljöersättning",7500,"kr/ha"]
["Gårdsstöd",2000,"kr/ha"]
[]
["Arbete"]
["Kvalificerat arbete",283,"kr/tim"]
["Okvalificerat arbete",186,"kr/tim"]
["Plockningsackord",4,"kr/l"]
["Sociala kostnader plockning",0.36499999999999999]
[]
["Räntor"]
["Kalkylränta, nuvärdeberäkning ",0.02]
["Ränta byggnader",0.02]
["Ränta inventarier och maskiner",0.02]
["Ränta rörelsekapital",0.02]
[]
["Drivmedel och energi"]
["Driv- och smörjmedel traktor",88,"kr/tim",null,"Maskinkostnader 2019, 50 KW traktor"]
["El",0.96,"kr/KWh",null,"AgriWise: 0,96 kr/kWh. "]
[]
["Material mm"]
["Plantor, A+",2.15,"kr/st",null,"Thilda, Olssons"]
["Gräsfröblandning",40,"kr/kg",null,"50% ängsgröe och 50% rödsvingel. Utsädesmängd 20 kg räknat bara sådd i gång"]
["Plastfolie, svart nedbrytbar 35 my",3.3,"kr/m²",null,"Nedbrytbar"]
["Fiberduk, 19 g/m²",1.1000000000000001,"kr/m²",null,"0,90 kr/m2 + säckar 0,20 kr/m2"]
["Halm",1,"kr/kg",null,"0,40 öre i sträng på marken + 0.20 kr pressning + transport"]
["Analyser (köpt tjänst)",500,"kr/st"]
["Jordgubbskatonger, 1 l",0.5,"kr/st"]
["Engångslådor (för 15 kartonger)",9,"kr/st",null,"Thilda"]
["Transport",null,"kr/l",null,"Säljs fritt odlingen"]
["Försäljningskostnad",0.03]
[]
["Gödselmedel"]
["Fastgödsel, nöt",0.2,"kr/kg"]
["Pelleterad ekogödsel",4.7,"kr/kg"]
["Vinass",1.75,"kr/kg"]
["Kaliumsulfat",7.5,"kr/kg",null,"SW horto 2020"]
["Kalimagnesia 25-6",4.5599999999999996,"kr/kg"]
[]
["Växtskydd"]
["Kumulus DF (Svavelpreparat)",160,"kr/kg"]
["Serenade ASO (Bacillus subtilis)",154,"kr/l"]
["Sluxx HP mot sniglar",69,"kr/kg"]
["Rovkvalster Neoseiulus cucmeris",325,"kr/300 000"]
["Humlor",500,"kr/samhälle"]
[]
["Trampnät (skrivs av på 5 år)"]
["Pris: 12500 m2/ha à2,70 kr/m2",33750,"kr/ha"]
["Avskrivningstid",5,"år"]
["Räntesats",{"$f":"B17","v":0.02}]
["Årskostnad",{"$f":"B53*B55/(1-(1+B55)^-B54)","v":7160.3458010208778},"kr/ha/år"]