{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Introduktion","Vejledning","Investerings kalkule m. makro","Investerings kalkule u. makro","Smågrisepriser"],"not_rendered":{"charts":6,"images":4,"macros":1,"external_links":0,"defined_names":80,"comments":4,"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":"Introduktion","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,2,6,2]]}
[]
[]
[]
[]
[null,"Udgiver:","SEGES Innovation P/S"]
[null,null,"Formålet med regnearket er at beregne rentabiliteten ved et byggeprojekt af en ny svineejendom baseret på langsigtede realistiske forudsætninger."]
[]
[null,"Udgivelsesdato:","2022-12-20"]
[null,"Forfatter:","Michael Groes Christiansen"]
[null,"Version:","1.05"]
[null,"Datagrundlag og opdateringsfrekvens:"]
[null,"Dokument:","Sådan bruge du investeringsoversigten"]
[null,"Ansvar:","Se vilkår"]

{"sheet":"Vejledning","index":1,"n_rows":112,"n_cols":8,"rows_kept":112,"cut":false,"hidden":false,"merged":[[90,0,90,11],[82,0,83,10],[46,0,46,5],[8,0,8,15]]}
[]
[]
[]
[]
[]
[]
[]
["Spørgsmål til regnearket kan rettes til Michael Groes Christiansen, tlf. 5135 9333, e-mail:",null,null,null,null,null,null,"mgc@seges.dk"]
[]
[]
["Vejledning til rentabilitetsberegning – version 1.05"]
["Formålet med regnearket er at beregne rentabiliteten ved et byggeprojekt af en ny svineejendom baseret på langsigtede realistiske forudsætninger."]
["Til dette formål forsøger SEGES Innovation at stille fælles mellem-langsigtede prognoser for smågrisepriser og danske afregningspriser til rådighed. "]
["Disse prognoser er baseret på forventninger til fremtiden, der som oftest er baseret på, hvordan det historisk har været at sælge smågrise eller få rentablitet i dansk svineproduktion for en gennemsnitsproducent."]
["Prognosen på mellenlang sigt er p.t. 2,00 kr./FEsv for indkøbt slagtesvinefoder og en gennnemsnitlig afregningspris på ca. 12,9  kr./kg, hvoraf basisnotering udgør de 11,5 kr./kg."]
["Afregningspriser og foderpriser følges oftest ad. Besætningens egen foderpris kan være lavere/højere men bør sættes i forhold til den langsigtede foderprisprognose."]
["Tillæg/fradrag pr. smågris i forhold til beregnet smågrisenotering sker på eget ansvar. Tillæg på smågrise kan skyldes undenlandsk efterspørgsel efter smågrise."]
["SEGES Innovation, forventer at standardtillæg i Danmark pr. smågris er cirka 10 kr./smågris i fremtidige kalkuler, men afhænger af kvalitet og mængder."]
[]
["Programmet kan beregne"]
["En investeringsafkastningsgrad (AG)."]
["EVA (økonomisk værdi tilføjet) = AG-WACC."]
["WACC er engelsk for en vægtet kalkulationsrente (læs senere i vejledning)."]
["Investeringens tilbagebetalingstid i år ekskl. besætningsværdien. Besætningsværdien betragtes som et kort aktiv, der til enhver tid kan elimeres (dog med noget tab)."]
["Projektets kapitalværdi (kun positiv hvis AG > WACC), en tilbagediskontering af pengestrøm med WACC."]
["Nulpunktsnotering og sikkersmargin i forhold til langtidsprognosen men kun i arket Investerings kalkule med makro"]
["Resultat pr. gris."]
[]
["Eksempel på hvordan WACC beregnes: FINANSIERINGSANDELE OG RENTESATSER"]
["FINANSIERINGSKILDE:","ANDELE","AKTUEL RENTE INKL. ADM. OMK."]
["Realkredit Fast",0.1,{"$f":"5+0.6","v":5.6}]
["Realkredit Variabel",0.5,{"$f":"3.25+0.6","v":3.85}]
["Bank",0.3,{"$f":"7+0.6","v":7.6}]
["Vækstfond ea.",0,9.25]
["Egenkapital",0.1,9.75]
["WACC ",{"$f":"SUM(B31:B35)","v":0.99999999999999989},{"$f":"SUMPRODUCT(B31:B35,C31:C35)","v":5.74}]
["WACC uden egenkapitalforretningskrav",null,{"$f":"C36-B35*C35","v":4.7650000000000006}]
[]
["Hvis WACC uden egenkapital bruges, bliver renteomkostninger lavere. "]
["Egenkapitalens forretning er så: EVA/(egenkapital i % af investeret kapital)."]
["En EVA på 1 % med 10 % egenkapitalfinansiering, svarer til 10 % i egenkapital forretning."]
[]
["Vejledning til regnearket"]
[]
["Forudsætninger indlægges i farvede celler"]
["I gule celler kan der indlægges egne værdier"]
[]
["Input til langsigtet prognose."]
["Anbefalet prrognose prisniveau på mellemlang sigt fra SEGES er 2 kr. FEsv/slagtegrisefoder og 11,5 kr./kg i notering"]
[]
["Programmet funktionalitet er bedst med makro slået til"]
["Hvis programmet afvikles uden makro, er målsøgning nøjagtig nulpunktsnotering sat ud af kraft."]
["Der er tre driftsgrene: søer, smågrise og slagtesvin."]
[]
["Produktivitet og investeringsomfang"]
["Det forudsættes som udgangspunkt at anlægget vil have en produktivitet på niveau med"]
["de 33 % bedste svinebedrifter."]
["Når programmet åbnes er årssøer samt alle smågrise- og slagtesvinestipladser sat til nul."]
["De indlagte stipladspriser er for cirka 1.200 søer, cirka 6.000 smågrisestipladser og 5.000 slagtesvinepladser."]
["Oplyste antal stiplads bruges til at beregne produktionsomfang og er pr. årsso eller til indsatte grise."]
["Ekstra stipladser i form af sygestier eller bufferstier skal derfor ikke indlægges, men de skal inkluderes i stipladsprisen."]
["Stipladspriser er for et funktionsdygtigt anlæg uden miljøteknologi. Programmets stipladspriser kan overskrives med egne."]
["Miljøteknologi investering pr. stiplads indlægges særskilt."]
["Der indlægges en del produktivitetsoplysninger i den indledende fase om foderforbrug samt forventet salgsvægt."]
["Priser for grise op til 40 kg findes automatisk af programmet, og er således fra beregnet smågrisenotering ved given notering og foderpris på landsplan."]
[]
["Værdier og input kan også overskrives i rentablitetskalkulens gule celler"]
["Bruger er således først færdig, når gule celler i denne del af programmet er gennemgået for egne justeringer."]
["Først når de cirka 2 sider/driftgren er gennemgået, bør nulpunktnotering findes via makroknap. "]
[]
["Tillæg/fradrag til smågrisepris(er). Korrektion for mængde- og kvalitetstillæg."]
["Transportpriser"]
["Egne Foderpriser. Forventede gennemsnitlige foderpriser over investeringens levetid set i forhold til langtidsprognosens priser."]
["Timeløn. Forventet timeløn til ansatte eller minutpris ved smågrise og slagtesvin."]
["Tidsforbrug. Antal time pr. årsso  samt antal minutter pr. smågris og pr. slagtesvin."]
["Hvis gyllens nettoværdi er positiv skrives enhedsværdien/ton med negativt fortegn."]
["Disse faktorer er de vigtigste at tage stilling til, men de øvrige faktorer bør også gennemgås og tilrettes."]
[]
["Kontante kapacitetsomkostninger"]
["Generelt er det forudsat, at de kontante kapacitetsomkostninger vil ligge"]
["på niveau med de 33 % bedste med hensyn til kapacitetsomkostninger i Danmark."]
[]
["Afskrivninger er udspecificeres på bygninger/inventar samt miljøteknologi samt diverse, som dækker renteomkostning under byggerifasen, ind- afkøringstab samt miljøtilladelse."]
[]
[]
["Vigtigt: Alle levetider skal være angivet i halve eller hele år."]
["Afskrivninger på inventar etc.: Afrundes med loft til heltal i forhold til bygningens levetid. Hvis bygning holder 25 år, inventar kun 10 år, skal der investeres 3 gange i inventar ink. start investering."]
["Alle reinvesteringer, som foretages mere end 5 gange set i forhold til bygningens levetid (eksemplevis noget miljøteknologi), skal tages som driftsomkostning og ikke som investering."]
["Tilskud fratrækkes afskrivninger og fordeles på bygningens levetid. Det vides eksemplevis ikke, om der er tilskud om 13 år, hvis en en mlijøteknologi skal erstattes til den tid."]
[]
["Renteomkostninger: Investeret kapital forudsættes afdraget så hurligt som muligt i beregninger via pengestrømmen før afskrivninger og renteomkostninger (EBID) sat i forhold til restgæld. Renteomkostningen er dynamisk, det vil sige, at den er baseret på pengestrømsanalyse i projektets levetid."]
[]
["Ordinært resultat og resultat per enhed"]
["Hvis investeringen er lønsom er ordinært resultat og resultat ens."]
["Der er kun forskel på ordinært resultat og resultat, hvis investeringen ikke er lønsom ved en givent niveau, fx ved lav notering."]
["Årsagen er, at afskrivninger, medtaget i rentabilitetskalkulen, reelt ikke er afdraget til investorer."]
["Derfor indlægges der en ekstraordinær renteomkostning, baseret på at ikke-afdragne afskrivninger forrrentes 5 år ekstra *0,5 * WACC som ikke fremgår af cashflow opstilling."]
[]
["Rentabilitet"]
["Alle resultater er før skat."]
[]
["Beregningsmæssige forhold"]
["Alle berenginger er før skat. Der gøres opmærksom på, at der ikke er indlagt hverken prisstigninger, effektivitetsstigninger,"]
["scrapværdi eller skat. Der kan argumenteres for, at input-faktorer, fx arbejdsløn, vil stige"]
["med mere end inflationen over tid, mens der ikke er belæg for at afregningsprisen over tid"]
["har udvist nogen stigende trend, eller vil gøre det i fremtiden. Dette hænger sammen med, at"]
["der historisk har været en stigende effektivitet i svineproduktionen. Det er oplagt at forvente,"]
["at eventuelle effektivitetsforbedringer i svineproduktionen går til at betale for stigende priser"]
["på input-faktorerne. Der er ikke medtaget nogen scrapværdi, da det forventes, at stald og"]
["inventar vil være værdiløse ved investeringsperiodens afslutning."]
["Der er ikke medtaget eventuelle omkostninger til nedrivning af staldbygninger. "]
["Der er ikke taget hensyn til virksomhedsskat."]

{"sheet":"Investerings kalkule m. makro","index":2,"n_rows":728,"n_cols":16,"rows_kept":728,"cut":false,"hidden":false,"merged":[[4,2,4,9],[1,2,2,4],[1,5,2,5],[1,6,2,9],[13,5,14,9],[10,5,11,9],[16,2,16,9],[7,5,8,9],[535,3,535,8],[157,3,157,8],[148,3,148,7],[241,2,241,8],[424,2,424,9],[49,2,49,8],[17,4,17,9]]}
[]
[null,null,"Rentabilitetsanalyser svin ved investeringer i stalde",null,null,"For:","SEGES"]
[]
[null,null,"Navigationslink række visninger","Prisprognose på mellemlang sigt",null,"So kalkule","Smågrise kalkule","Slagtesvin kalkule",null,"Samlet R-analyse"]
["Vis"]
["Nej"]
["Ja",null,"Styring af rækker som vises. Vælg og tryk på opdater rækkevisning",null,null,"Når alle input er indlagt kan nulpunkt beregnes via makroknap"]
["Ja",null,"Vis langsigtet prognose","Ja",null,"Når alle input er indlagt kan nulpunkt beregnes via makroknap"]
["Ja",null,"Vis søer","Ja"]
["Ja",null,"Vis smågrise","Ja"]
["Ja",null,"Vis slagtesvin","Ja",null,"Gule celler er input celle. Indsæt ikke egne rækker etc. I dette regneark"]
["Ja",null,"Vis cashflow søer","Ja"]
["Ja",null,"Vis cashflow smågrise","Ja"]
["Ja",null,"Vis cashflow slagtesvin","Ja",null,"Der kan laves et kopi af arket som kan gives nyt navn, hvis man gerne vil have flere scenarier i samme regnearksfil"]
["Ja",null,"Konsolideret ved mere end 1 driftsgren","Ja"]
["Ja",null,"Konsolideret cashflow","Nej"]
["Ja",null,"Rentabilitetsanalyser svin ved investeringer i stalde"]
[{"$f":"IF($D$8=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Prisprognose dansk griseproduktion mellemlang sigt",null,"Anbefalet prisniveau på mellemlang sigt er 2 kr. FEsv/slagtegrisefoder og 11,5 kr./kg i notering"]
["Ja",null,"Sidste længere prisprognose","2022-11-28",null,"Normpristal"]
["Ja",null,"Indkøbt slagtegrisefoderpris prognose landsplan",2,"kr./FEsv","Produktionsafgift søer og slagtepolte",null,null,null,10.9]
["Ja",null,"Mellemlamgsigtet notering svin ved denne foderpris",11.5,"kr./kg","Produktionsafgift slagtesvin",null,null,null,5.5]
["Ja",null,"Diverse standard korrektioner, kr../kg",1.36,null,"Genafgift søer",null,null,null,70]
["Ja",null,"Gns. dansk afregningspris",{"$f":"D21+D22","v":12.86},"kr./kg","Anslået købspris LY sopolte ved givet niveau",null,null,null,{"$f":"(D25+0.12)*125+500","v":2122.5}]
["Ja",null,"Følsomhed notering svin (bruges af program)",0,null,"Vedligehold bygninger af investeringssum",null,null,null,6.0000000000000001E-3]
["Ja",null,"Dansk afregningspris inkl. følsomhedsfaktor",{"$f":"D21+D22+D24","v":12.86},null,"Vedligehold inventar af investeringssum",null,null,null,0.02]
["Ja",null,"Afregningspris kr./kg slagtesøer",{"$f":"ROUND((D21+D24)*Smågrisepriser!B12,2)+(D22-Smågrisepriser!B10)","v":9.7900000000000009}]
["Ja",null,"Følsomhedsanalyse (+/- 2 intervaller) "]
["Ja",null,{"$f":"\"+/-  gns. dansk notering kr./kg\"","v":"+/-  gns. dansk notering kr./kg"},0.5,"kr/kg"]
["Ja",null,"Renteniveau indlagt (wacc)"]
["Ja",null,"Kalkulationsrente i beregningerne (wacc)",5.74E-2,"pa"]
["Ja",null,"Byggerente",{"$f":"D30","v":5.74E-2},"pa"]
["Ja",null,"Investeringens startdato","2023-07-01"]
[{"$f":"IF($D$8=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
["Ja",null,"Tabel for smågrisenotering ved angivet notering og langsigtet foderprognose. Over 40 kg findes ingen beregnet notering"]
["Ja",null,"Indlagt notering + følsomhedsfaktor",{"$f":"D21+D24","v":11.5}]
["Ja",null,"7 kg smågrisepris",{"$f":"VLOOKUP(D20,Nulpunktstabel,4,FALSE)+(D35-VLOOKUP(D20,Nulpunktstabel,3,FALSE))*Normtal_slagtevægt*Finansieringssandel_7_kg","v":268.81795599999998},"Kr./gris"]
["Ja",null,"30 kg smågrisepris",{"$f":"VLOOKUP(D20,Nulpunktstabel,5,FALSE)+(D35-VLOOKUP(D20,Nulpunktstabel,3,FALSE))*Normtal_slagtevægt*Finansieringsandel_30_kg","v":465.61659599999996},"Kr./gris"]
["Ja"]
["Ja",null,"Kg regulering","Fra kg","Til kg","Kr/.kg","Startpris","Slutpris"]
["Ja",null,null,0,7,{"$f":"F41+Smågrisepriser!B$20","v":12.969431836223098},{"$f":"G41-E40*F40","v":178.03193314643829},{"$f":"G40+(E40-D40)*F40","v":268.81795599999998}]
["Ja",null,null,{"$f":"E40","v":7},9,{"$f":"VLOOKUP(D$20,Nulpunktstabel,7,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":9.969431836223098},{"$f":"D36","v":268.81795599999998},288.75681967244617]
["Ja",null,null,9,12,{"$f":"VLOOKUP(D$20,Nulpunktstabel,8,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":13.998315629830786},{"$f":"H41","v":288.75681967244617},330.75176656193855]
["Ja",null,null,12,25,{"$f":"VLOOKUP(D$20,Nulpunktstabel,9,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":8.0577675872153716},{"$f":"H42","v":330.75176656193855},435.50274519573838]
["Ja",null,null,25,30,{"$f":"VLOOKUP(D$20,Nulpunktstabel,10,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":6.0227701608523061},{"$f":"H43","v":435.50274519573838},465.6165959999999]
["Ja",null,null,30,40,{"$f":"VLOOKUP(D$20,Nulpunktstabel,11,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":6.7524914602047197},{"$f":"H44","v":465.6165959999999},533.14151060204711]
["Ja",null,null,40,130,{"$f":"F45","v":6.7524914602047197},{"$f":"H45","v":533.14151060204711},1140.8657420204718]
["Ja",null," ",130,1000,{"$f":"F46","v":6.7524914602047197}]
["Ja"]
["Ja"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Rentabilitetsberegning søer"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Antal årssøer",{"$f":"0*1200","v":0},null,"Investeringsbeløb pr. årsso"]
["Ja",null,"Produktions oplysninger"]
["Ja",null,"Fravænningsvægt, kg",6.5,null,"Stalde, bygninger, miljøteknologi og tilskud",null,null,null,null,null," "]
["Ja",null,"Spildfoderdage/kuld",13,null,"Investeringsbeløb, kr.årsso",null,null,25000]
["Ja",null,"Soens laktationsperiode, dage/kuld",32,null,"Bygningsandel i % investeringsbeløb",null,null,0.68]
["Ja",null,"Kuld/årsso",{"$f":"365/(D54+D55+117)","v":2.2530864197530862},null,"Levetid bygninger, år",null,null,25]
["Ja",null,"Fravænnede grise/kuld",16.100000000000001,null,"Levetid inventar, år",null,null,15]
["Ja",null,"Fravænnnede grise/årsso",{"$f":"ROUND(D56*D57,1)","v":36.299999999999997},null,"Miljøinvestering, kr./årsso",null,null,1100]
["Ja",null,"Slagtevægt søer, kg",185,null,"Forventet levetid miljøteknologi, år",null,null,12.5]
["Ja",null,"1 lægspct. efter indkøring, % af farekuld",0.23499999999999999,null,"Miljøtilladelse i kr./årsso",null,null,{"$f":"IF(D51>0,41+55,0)","v":0}]
["Ja",null,"Årlig soudskiftning, pct.",{"$f":"D56*D60","v":0.52947530864197523},null,"Levetid miljøansøgning, år",null,null,9]
["Ja",null,"Udnyttelsesprocent polte, %",0.95,null,"Fornyet miljøansøgning i kr./årsso",null,null,{"$f":"I60*0.5","v":0}]
["Ja",null,"Sodødelighed, i % af årssøer",0.12,null,"Tilskud pr. årsso, kr./årsso",null,null,0]
["Ja",null,"Kernestyring eller indkøbte polte","Nej"]
["Ja",null,"Prisreduktion polte 22 uger ved egen avl",400," ","Sum startinvestering"]
["Ja",null,"Indkøringstab % af fuld produktion",0.5,null,"Investering bygninger",null,null,{"$f":"D51*I54*I55","v":0}]
["Ja",null,null,null,null,"Investering inventar",null,null,{"$f":"D51*I54*(1-I55)","v":0}]
["Ja",null,"WACC overført pa.",{"$f":"D30","v":5.74E-2},null,"Renteomkostning byggeri",null,null,{"$f":"(I66*0.33+I67*0.25)*D31","v":0}]
["Ja",null,null," ",null,"Miljøteknologi",null,null,{"$f":"I58*D51","v":0}]
["Ja",null,"Vælg afrapportering enhed tabeller","Kr./frav.",null,"Miljøansøgning",null,null,{"$f":"I60*D51","v":0}]
["Ja",null,null,null,null,"Indkøringstab",null,null,{"$f":"D66*(21/52)*I125*D51","v":0},null,null," "]
["Ja",null,"Investerings nøgletal",null,null,"Tilskud",null,null,{"$f":"I63*D51*-1","v":0}]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D51>0,XIRR(I179:I239,K179:K239,5%),\"\")","v":""},null,"Lange aktiver i alt",null,null,{"$f":"SUM(I66:I72)","v":0}]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D51>0,D73-D68,\"\")","v":""},null,"Anskaffelsessum besætning",null,null,{"$f":"(J23-IF(D64=\"Ja\",D65,0))*D51","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D51>0,IF(MAX(J179:J239)>0,VLOOKUP(0,B179:C239,2,FALSE)+IF(VLOOKUP(0,B179:C239,2,FALSE)<I56,0.5),\"Aldrig\"),\"\")","v":""},null,"Gns. værditilvækst besætning",null,null,{"$f":"(-1*(G112+G113+G124+G133)*D57/2)*D51","v":0}," "]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D51>0,I150*-1,\"\")","v":""},null,"Korte aktiver i alt",null,null,{"$f":"SUM(I74:I75)","v":0},null,null," "]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D51>0,D21-D76,\"\")","v":""},null,"Bunden Investering ",null,null,{"$f":"I73+I76","v":0}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D51>0,XNPV(D68,I179:I239,K179:K239)/1000,\"\")","v":""}]
["Ja",null,null,null,null,"Beløb ved investeringens ophør"]
["Ja",null,"Nulpunkts priser",{"$f":"D70","v":"Kr./frav."},null,"Afviklingstab søer",null,null,{"$f":"I71*-1*(50%/D66)","v":0}]
["Ja",null,{"$f":"C151","v":"Salgspris fravænnede"},{"$f":"I151","v":""},null,"Sobesætningselimeringstab",null,null,{"$f":"(D51*(J23-IF(D64=\"Ja\",D65,0))-D26*D51*D59)*-1","v":0}]
["Ja",null,"DB pr. enhed",{"$f":"I152","v":""},null,"Besætningsværdi ved eliminering",null,null,{"$f":"I74+I75","v":0}]
["Ja",null,"Resultat pr. enhed",{"$f":"I153","v":""},null,"I alt",null,null,{"$f":"SUM(I80:I82)","v":0}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null,null,null,null,null,null,null,null,null," "]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null,"Søer rentabilitetskalkule","Enhed input","Enheder","Enheds-værdi kr./enhed","Kr./frav.","Beløb pr år i kr.","Kr./årsso"]
["Ja",null,"Salg fravænnede grise beregnet inkl. kg regulering","pr. årsso",{"$f":"ROUND(D56*D57,1)","v":36.299999999999997},{"$f":"VLOOKUP(D53,$D$40:$H$47,5,TRUE)-(VLOOKUP(D53,$D$40:$F$47,2,TRUE)-D53)*(VLOOKUP(D53,$D$40:$F$47,3,TRUE))","v":262.33324008188845},{"$f":"F108","v":262.33324008188845},{"$f":"$E$108*$D$51*G108","v":0},{"$f":"H108/IF(D$51>0,D$51,1)","v":0},null,null," "]
["Ja",null,"Tillæg/fradrag i forhold til beregnet not. ved salg","pr. årsso",{"$f":"E108","v":36.299999999999997},10,{"$f":"F109","v":10},0,{"$f":"H109/IF(D$51>0,D$51,1)","v":0}]
["Ja",null,"Salg af slagtesøer","pr. årsso",{"$f":"(D61-D63)","v":0.40947530864197523},{"$f":"D59*D26","v":1811.15},{"$f":"F110*E110/E$108","v":20.430336232697343},0,0," "]
["Ja",null,"Salg af slagtepolte","pr. årsso",{"$f":"D61*(1-D62)","v":2.6473765432098784E-2},{"$f":"D25*83","v":1067.3799999999999},{"$f":"F111*E111/E$108","v":0.77844539247695865},0,0]
["Ja",null,"Sopolte udgift (Indkøbt/kostpris)","pr. årsso",{"$f":"D61/D62","v":0.55734243014944762},{"$f":"J23-IF(D64=\"Ja\",D65,0)","v":2122.5},{"$f":"-1*F112*E112/E$108","v":-32.588410688490434},0,0]
["Ja",null,"Diverse faste afgifter pr. årsso","kr./årsso",1,{"$f":"J22+SUM(E110:E111)*J20","v":74.751844907407403},{"$f":"-1*F113/E$108","v":-2.0592794740332621},0,0]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G108:G113)","v":258.89433154453906},{"$f":"SUM(H108:H113)","v":0},0]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Sofoder","Fesv/årsso",1536,{"$f":"D20+0.05","v":2.0499999999999998},{"$f":"-1*E115*F115/$E$108","v":-86.743801652892557},{"$f":"$E$108*$D$51*G115","v":0},{"$f":"H115/IF(D$51>0,D$51,1)","v":0}]
["Ja",null,"Foderudgift pattegrise","kr./fravænnet",1,5,{"$f":"-1*(E116*F116)","v":-5},0,0]
["Ja",null,"Smågrisefoder","Fesv/årsso",0,0,{"$f":"-1*E117*F117/$E$108","v":0},0,0]
["Ja",null,"Slagtesvinfoder","Fesv/årsso",0,0,0,0,0]
["Ja",null,"Grovfoder","Fesv/årsso",0,0,0,0,0]
["Ja",null,"KS udgifter","Doser/årsso",{"$f":"D56*2/0.9","v":5.0068587105624136},18,-2.4827398564772301,0,0]
["Ja",null,"Rådgivning","pr. årsso",1,0,{"$f":"-1*E121*F121/$E$108","v":0},0,{"$f":"H121/IF(D$51>0,D$51,1)","v":0}]
["Ja",null,"Medicin & vacciner","pr. årsso",1,353,-9.7245179063360894,0,0]
["Ja",null,"Diverse stykomkostninger","pr. årsso",1,222,-6.115702479338843,0,0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G115:G123)","v":-110.06676189504472},0,0]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G114+G124","v":148.82756964949434},0,0]
["Ja",null,"Arbejde","timer pr. årsso",9.1999999999999993,192,{"$f":"-1*E126*F126/$E$108","v":-48.66115702479339},0,0]
["Ja",null,"Energi","kwh/årsso",320,0.8,-7.0523415977961434,{"$f":"$E$108*$D$51*G127","v":0},0]
["Ja",null,"Forsikring","kr./årsso",1,71,-1.9559228650137743,0,0]
["Ja",null,"Driftsomkostning miljøteknologi","kr./årsso",1,{"$f":"56+26","v":82},-2.2589531680440773,0,0]
["Ja",null,"Vedligehold","kr./årsso",1,{"$f":"F135*J24+F136*J25","v":262},-7.2176308539944909,0,0]
["Ja",null,"Gyllens nettoværdi pr. ton (negativ hvis indtægt)","ton/årsso",5.25,-20,2.8925619834710745,0,0]
["Ja",null,"Diverse kapacitetsomkostninger","kr./årsso",1,300,{"$f":"-1*E132*F132/$E$108","v":-8.2644628099173563},0,0]
["Ja",null,"Kontante kapacitetsomkostninger/enhed","Kr./årsso",1,null,{"$f":"SUM(G126:G132)","v":-72.517906336088174},{"$f":"$E$108*$D$51*G133","v":0},0,null,null," "]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G125+G133","v":76.309663313406162},{"$f":"H125+H133","v":0},0]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I$56","v":0.04},{"$f":"I54*I55","v":17000},{"$f":"-1*E135*F135/E$108","v":-18.732782369146008},{"$f":"$E$108*$D$51*G135","v":0},0]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I56/I57,1)/I56","v":0.08},{"$f":"I54*(1-I55)","v":7999.9999999999991},{"$f":"-1*E136*F136/E$108","v":-17.630853994490355},{"$f":"$E$108*$D$51*G136","v":0},0]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I56/I59,1)/I56","v":0.08},{"$f":"I58","v":1100},{"$f":"-1*E137*F137/E$108","v":-2.4242424242424243},{"$f":"$E$108*$D$51*G137","v":0},0]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"E135","v":0.04},{"$f":"(I68+I70+I71+I80*-1+I81*-1+SUM(I171:I175))/IF(D51>0,D51,1)","v":0},{"$f":"-1*E138*F138/E$108","v":0},{"$f":"$E$108*$D$51*G138","v":0},0]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"E135","v":0.04},{"$f":"I63","v":0},{"$f":"E139*F139/E$108","v":0},{"$f":"$E$108*$D$51*G139","v":0},0]
["Ja",null,"Afskrivninger i alt",null,null,null,{"$f":"SUM(G135:G139)","v":-38.787878787878782},{"$f":"SUM(H135:H139)","v":0},{"$f":"SUM(I135:I139)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G134+G140","v":37.52178452552738},{"$f":"H134+H140","v":0},{"$f":"I134+I140","v":0}]
["Ja",null,{"$f":"\"Renteomkostning\"","v":"Renteomkostning"},"  ",null,null,{"$f":"I142/D58","v":0},{"$f":"(SUM(F179:F239)*-1)/I56","v":0},0]
["Ja",null,"Ordinært resultat pr. enhed",null,null,null,{"$f":"G141+G142","v":37.52178452552738},{"$f":"H141+H142","v":0},{"$f":"I141+I142","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger","  ",null,null,{"$f":"H144/IF(D51>0,D51*D58,1)","v":0},{"$f":"IF(H239<0,H239*D68*5*0.5/I56,0)","v":0},{"$f":"H144/IF(D51>0,D51,1)","v":0}]
["Ja",null,"Resultat pr. enhed",null,null,null,{"$f":"G143+G144","v":37.52178452552738},{"$f":"H143+H144","v":0},{"$f":"I143+I144","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,{"$f":"D73","v":""},{"$f":"D73","v":""},{"$f":"D73","v":""}]
["Ja"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,null,null,null,"Nulpunktregulator kr./kg",null,null,-0.13205326056306932]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\"  kr./kg\"","v":"Følsomhed notering i forhold til: 11,5  kr./kg"},null,null,null,null,"Nulpunkts prognose"]
["Ja",null,"Noteringsændring kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D51>0,I148,0)","v":0}]
["Ja",null,"Salgspris fravænnede",{"$f":"D160","v":""},"","","","",""]
["Ja",null,{"$f":"C125","v":"DB pr. enhed"},"","","","","",""]
["Ja",null,"Resultat pr. enhed",{"$f":"D164","v":""},"","","","",""]
["Nej"]
["Nej",null,"Følsomhedstabel søer"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg fravænnede grise beregnet"]
["Nej",null," ","Noteringsændring i kr./kg"]
["Nej",null,{"$f":"IF(D51>0,VLOOKUP(C157,$C$107:$I$146,IF(D70=G107,5,7),FALSE)+IF(C157=C108,IF(D70=\"Kr./årsso\",I109,F109),0),\"\")","v":""},{"$f":"D150","v":-1},-0.5,0,0.5,1,{"$f":"I148","v":-0.13205326056306932}]
["Nej",null,{"$f":"C108","v":"Salg fravænnede grise beregnet inkl. kg regulering"},"","","","","",""]
["Nej",null,{"$f":"C152","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,"Resultat af primær drift","","","","","",""]
["Nej",null,{"$f":"C143","v":"Ordinært resultat pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C145","v":"Resultat pr. enhed"},"","","","","",""]
["Nej",null," "]
["Nej"]
["Nej",null,"Søer reinvesteringstabel","Halvårlig rente",{"$f":"POWER(10,LOG(D68+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse år efter start","Miljø tilladelse, omkostning ved fornyelse"]
["Nej",null,"Levetid angivet",{"$f":"I57","v":15},null,{"$f":"I59","v":12.5},null,{"$f":"I61","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING($I$56/I57,1)-1","v":1},null,{"$f":"CEILING($I$56/I59,1)-1","v":1},null,{"$f":"CEILING($I$56/I61,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C171<=D$170,D$169*$C171,\"\")","v":15},{"$f":"IF(ISNUMBER(D171),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C171<=F$170,F$169*$C171,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F171),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C171<=H$170,H$169*$C171,\"\")","v":9},{"$f":"IF(ISNUMBER(H171),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C172<=D$170,D$169*$C172,\"\")","v":""},{"$f":"IF(ISNUMBER(D172),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C172<=F$170,F$169*$C172,\"\")","v":""},{"$f":"IF(ISNUMBER(F172),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C172<=H$170,H$169*$C172,\"\")","v":18},{"$f":"IF(ISNUMBER(H172),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,3,{"$f":"IF($C173<=D$170,D$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(D173),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C173<=F$170,F$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(F173),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C173<=H$170,H$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(H173),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,4,{"$f":"IF($C174<=D$170,D$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(D174),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C174<=F$170,F$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(F174),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C174<=H$170,H$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(H174),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,5,{"$f":"IF($C175<=D$170,D$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(D175),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C175<=F$170,F$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(F175),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C175<=H$170,H$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(H175),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["ja"]
[{"$f":"IF($D$12=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow søer"]
[{"$f":"IF($D$12=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}," ","Terminer i halvår","Investerings-summer","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato",null,null,null," "]
["Ja",{"$f":"IF(J179>=0,0,J179)","v":0},0,{"$f":"I77*-1","v":0},0,0,0,{"$f":"D179","v":0},{"$f":"D179+E179","v":0},{"$f":"(H179+IF(C179<$I$56,$I$83,0))/1000","v":0},{"$f":"DATE(YEAR(D32),IF(MONTH(D32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J180>=0,0,J180)","v":0},{"$f":"IF(AND(C179<>FALSE,C179+0.5<=$I$56),C179+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C180,$D$171:$E$175,2,FALSE)),0,VLOOKUP(C180,$D$171:$E$175,2,FALSE))+IF(ISNA(VLOOKUP(C180,$F$171:$G$175,2,FALSE)),0,VLOOKUP(C180,$F$171:$G$175,2,FALSE))+IF(ISNA(VLOOKUP(C180,$H$171:$I$175,2,FALSE)),0,VLOOKUP(C180,$H$171:$I$175,2,FALSE)))*-1+IF(C180=$I$56,$I$83,0)","v":0},{"$f":"IF(C180<=$I$56,H$134*0.5,0)","v":0},{"$f":"IF(C180<=$I$56,IF(H179<0,H179*$E$167*-1,0),0)","v":0},{"$f":"IF(H179>=0,0,IF(E180-F180>H179*-1,H179*-1,E180-F180))","v":0},{"$f":"H179+D180+G180","v":0},{"$f":"D180+E180","v":0},0,{"$f":"IF(MONTH(K179)+6>12,DATE(YEAR(K179)+1,MONTH(K179)+6-12,1),DATE(YEAR(K179),MONTH(K179)+6,1))","v":"2024-01-01"}," "]
["Ja",0,1,0,0,0,0,0,{"$f":"D181+E181","v":0},0,{"$f":"IF(MONTH(K180)+6>12,DATE(YEAR(K180)+1,MONTH(K180)+6-12,1),DATE(YEAR(K180),MONTH(K180)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,{"$f":"(H211+IF(C211<$I$56,$I$83,0))/1000","v":0},"2039-07-01"]
["Ja",0,{"$f":"IF(AND(C211<>FALSE,C211+0.5<=$I$56),C211+0.5)","v":16.5},{"$f":"(IF(ISNA(VLOOKUP(C212,$D$171:$E$175,2,FALSE)),0,VLOOKUP(C212,$D$171:$E$175,2,FALSE))+IF(ISNA(VLOOKUP(C212,$F$171:$G$175,2,FALSE)),0,VLOOKUP(C212,$F$171:$G$175,2,FALSE))+IF(ISNA(VLOOKUP(C212,$H$171:$I$175,2,FALSE)),0,VLOOKUP(C212,$H$171:$I$175,2,FALSE)))*-1+IF(C212=$I$56,$I$83,0)","v":0},{"$f":"IF(C212<=$I$56,H$134*0.5,0)","v":0},{"$f":"IF(C212<=$I$56,IF(H211<0,H211*$E$167*-1,0),0)","v":0},{"$f":"IF(H211>=0,0,IF(E212-F212>H211*-1,H211*-1,E212-F212))","v":0},0,0,0,"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
[{"$f":"IF($D$12=\"Ja\",\"Nej\",\"Nej\")","v":"Nej"}]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Smågrise rentabilitet"]
["Ja",null,"Smågrisestipladser ekskl. sygestier",{"$f":"0*36.3*1200/6.5","v":0},null,"Investeringsbeløb"]
["Ja",null,"Produktionsoplysninger",null,null,"Stipladspris inkl. sygestier kr./stiplads",null,null,2320]
["Ja",null,"Indsættelsesvægt (default frav. Vægt)",{"$f":"D53","v":6.5},null,"Bygningsandel af investeringsbeløb",null,null,0.72]
["Ja",null,"Opholdstid i uger",8," ","Levetid bygninger, år",null,null,25]
["Ja",null,"Omsætningshastighed pr. stiplads",{"$f":"365/(D246*7)","v":6.5178571428571432},null,"Levetid inventar, år",null,null,15]
["Ja",null,"Smågrisedødelighed",0.03," ","Miljøinvestering, kr./stiplads",null,null,0]
["Ja",null,"Årligt solgte grise",{"$f":"(D243*365/(D246*7))*(1-D248)","v":0}," ","Forventet levetid miljøteknologi,  år",null,null,12.5]
["Ja",null,"Salgsvægt",30,null,"Miljøtilladelse kr./stiplads",null,null,{"$f":"IF(D243>0,5,0)","v":0}]
["Ja",null,"Fesv pr. kg tilvækst",1.72," ","Levetid miljøansøgning, år",null,null,9]
["Ja",null,"Indkøringstab % af fyldt stald",0.5,null,"Fornyet miljøansøgning kr./stiplads",null,null,{"$f":"I250*0.5","v":0}]
["Ja",null,"Producerede smågrise per solgt",{"$f":"1/(1-D248/2)","v":1.015228426395939},null,"Tilskud kr./stiplads",null,null,0]
["Ja"]
["Ja"]
["Ja",null,"Wacc overført pa.",{"$f":"$D$30","v":5.74E-2},null,"Sum startinvestering"]
["Ja",null,null,null,null,"Investering bygninger",null,null,{"$f":"I244*I245*D243","v":0}]
["Ja",null,"Investerings nøgletal",null,null,"Investering inventar",null,null,{"$f":"I244*(1-I245)*D243","v":0}]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D243>0,XIRR(I363:I423,K363:K423,5%),\"\")","v":""},null,"Renteomkostning byggeri",null,null,{"$f":"(I257*0.33+I258*0.25)*D31","v":0}]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D243>0,D259-D256,\"\")","v":""},null,"Miljøteknologi",null,null,{"$f":"I248*D243","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D243>0,IF(MAX(J363:J423)>0,VLOOKUP(0,B363:C423,2,FALSE)+IF(VLOOKUP(0,B363:C423,2,FALSE)<I246,0.5),\"Aldrig\"),\"\")","v":""},null,"Miljøansøgning",null,null,{"$f":"I250*D243","v":0}]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D243>0,I334*-1,\"\")","v":""},null,"Indkøringstab",null,null,{"$f":"G309*D252*D249*(D246*7/365)","v":0},null,null," "]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D243>0,D21-D262,\"\")","v":""},null,"Tilskud",null,null,{"$f":"D243*I253*-1","v":0}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D243>0,XNPV(D256,I363:I423,K363:K423)/1000,\"\")","v":""},null,"Lange aktiver i alt",null,null,{"$f":"SUM(I257:I263)","v":0}]
["Ja",null,null,null,null,"Anskaffelsessum besætning",null,null,{"$f":"D243*SUM(F298:F300)","v":0}]
["Ja",null,"Nulpunktspriser","Kr./smågris",null,"Værditilvækst besætning",null,null,{"$f":"IF(D243>0,(G308+G317)*D243*0.5*-1,0)","v":0}]
["Ja",null,"Salgspris",{"$f":"IF(D243>0,I335,\"\")","v":""},null,"Korte aktiver i alt",null,null,{"$f":"SUM(I265:I266)","v":0}]
["Ja",null,"Indkøbspris",{"$f":"IF(D243>0,I336,\"\")","v":""},null,"Bunden Investering ",null,null,{"$f":"I264+I267","v":0}]
["Ja",null,"DB pr. enhed",{"$f":"IF(D243>0,I337,\"\")","v":""}]
["Ja",null,"Resultat pr. enhed",{"$f":"I338","v":""},null,"Beløb ved investeringens ophør"]
["Ja",null,null,null,null,"Afviklingstab",null,null,{"$f":"I262*-1*IF(D252>50%,50%/D252,1)","v":0}]
["Ja",null,null,null,null,"Besætningseliminering",null,null,{"$f":"I265+I266","v":0}]
["Ja",null,null,null,null,"I alt ",null,null,{"$f":"SUM(I271:I272)","v":0}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null," "]
["Ja",null,"Smågrise rentabilitetskalkule","Start enhed","Enheder","Enhedsværdi","kr./solgt smågris","kr. årligt"]
["Ja",null,{"$f":"\"Salg af smågrise beregnet \" &ROUND(D250,1)&\" kg\"","v":"Salg af smågrise beregnet 30 kg"},"pr./solgt",1,{"$f":"VLOOKUP(D250,$D$40:$H$47,5,TRUE)-(VLOOKUP(D250,$D$40:$F$47,2,TRUE)-D250)*(VLOOKUP(D250,$D$40:$F$47,3,TRUE))","v":465.6165959999999},{"$f":"E296*F296","v":465.6165959999999},{"$f":"G296*$D$249","v":0}]
["Ja",null,"Tillæg/fradrag beregnet not. ved salg",null,1,{"$f":"F109","v":10},{"$f":"E297*F297","v":10},{"$f":"G297*$D$249","v":0}]
["Ja",null,{"$f":"\"Køb af smågrise ved  \"& ROUND(D245,1)& \" kg\"","v":"Køb af smågrise ved  6,5 kg"},"pr./solgt",{"$f":"1/(1-D248)","v":1.0309278350515465},{"$f":"VLOOKUP(D245,$D$40:$H$47,5,TRUE)-(VLOOKUP(D245,$D$40:$F$47,2,TRUE)-D245)*(VLOOKUP(D245,$D$40:$F$47,3,TRUE))","v":262.33324008188845},{"$f":"E298*F298*-1","v":-270.44663925967882},{"$f":"G298*$D$249","v":0}]
["Ja",null,"Tillæg/fradrag beregnet not. ved køb","pr. indkøbt",{"$f":"1/(1-D248)","v":1.0309278350515465},{"$f":"F109","v":10},{"$f":"E299*F299*-1","v":-10.309278350515465},{"$f":"G299*$D$249","v":0}]
["Ja",null,"Transport smågrise","pr. indkøbt",{"$f":"1/(1-D248)","v":1.0309278350515465},0,{"$f":"E300*F300*-1","v":0},{"$f":"G300*$D$249","v":0}]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G296:G300)","v":194.86067838980563},{"$f":"SUM(H296:H300)","v":0}]
["Ja",null,"Smågriseblanding 1","pr. produceret",8,{"$f":"D20+2.43","v":4.43},{"$f":"(E302*F302)*-1*D$253","v":-35.979695431472074},{"$f":"G302*$D$249","v":0}]
["Ja",null,"Smågriseblanding 2 (residual)","pr. produceret",{"$f":"(D250-D245)*D251-E302","v":32.42},{"$f":"D20+0.28","v":2.2800000000000002},{"$f":"(E303*F303)*-1*D$253","v":-75.043248730964464},0]
["Ja",null,"Grovfoder","pr. produceret",0,0,0,0]
["Ja",null,"Rådgivning","pr. produceret",{"$f":"D$253","v":1.015228426395939},1,{"$f":"E305*F305*-1","v":-1.015228426395939},0]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Medicin & vacciner","pr. produceret",{"$f":"D$253","v":1.015228426395939},3.63,{"$f":"E306*F306*-1","v":-3.6852791878172586},0]
["Ja",null,"Diverse stykomkostninger","pr. produceret",1.015228426395939,3,{"$f":"E307*F307*-1","v":-3.0456852791878171},0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G302:G307)","v":-118.76913705583756},0]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G301+G308","v":76.091541333968067},{"$f":"H301+H308","v":0}]
["Ja",null,"Arbejde","min./smågris prod.",5,{"$f":"192/60","v":3.2},{"$f":"IF($D$243>0,H310/$D$249,1)","v":1},{"$f":"E310*F310*D$249*D$253*-1","v":0},null,null,null," "]
["Ja",null,"Energi","kWh/smågris prod.",12,0.8,{"$f":"IF($D$243>0,H311/$D$249,1)","v":1},{"$f":"E311*F311*D$249*D$253*-1","v":0},null,null,null," "]
["Ja",null,"Forsikring","pr. produceret",{"$f":"D$253","v":1.015228426395939},1,1,{"$f":"E312*F312*D$249*D$253*-1","v":0}]
["Ja",null,"Driftsomkostning miljøteknologi","pr. produceret",{"$f":"D$253","v":1.015228426395939},2,1,{"$f":"E313*F313*D$249*D$253*-1","v":0}]
["Ja",null,"Vedligehold","pr. produceret",1.015228426395939,{"$f":"-1*G314/E314","v":-0.9850000000000001},1,{"$f":"(F319*J24+F320*J25)*D243*-1","v":0},null," "]
["Ja",null,"Gyllens nettoværdi pr. ton (negativ hvis indtægt)","Tons/produceret",{"$f":"SUM(E302:E303)*2.7/1000","v":0.10913400000000001},-20,1,{"$f":"E315*F315*D$249*D$253*-1","v":0},null,null," "]
["Ja",null,"Diverse kapacitetsomkostninger","pr. produceret",{"$f":"D$253","v":1.015228426395939},2.25,1,{"$f":"E316*F316*D$249*D$253*-1","v":0}]
["Ja",null,"Kontante kapacitetsomkostning i alt enhed",null,null,null,{"$f":"SUM(G310:G316)","v":7},{"$f":"SUM(H310:H316)","v":0}]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G309+G317","v":83.091541333968067},{"$f":"H309+H317","v":0}]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"I244*I245","v":1670.3999999999999},{"$f":"E319*F319*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E319*F319*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I246/I247,1)/I246","v":0.08},{"$f":"(1-I245)*I244","v":649.6},{"$f":"E320*F320*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E320*F320*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I246/I249,1)/I246","v":0.08},{"$f":"I248","v":0},{"$f":"E321*F321*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E321*F321*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"-1*G322/E322","v":0},{"$f":"IF(D243>0,H322/D249,0)","v":0},{"$f":"(I259+I261+I262+I271+SUM(I354:I358))*-1/I246","v":0}]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"I253","v":0},{"$f":"H323/IF(D243>0,D249,1)","v":0},{"$f":"E323*F323*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger  i alt",null,null,null,{"$f":"SUM(G319:G323)","v":0},{"$f":"SUM(H319:H323)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G318+G324","v":83.091541333968067},{"$f":"H318+H324","v":0}]
["Ja",null,"Renteomkostning ",null,null,null,{"$f":"IF(D243>0,H326/D249,0)","v":0},{"$f":"-1*SUM(F363:F423)/I246","v":0}]
["Ja",null,"Ordinært resultat/enhed",null,null,null,{"$f":"G325+G326","v":83.091541333968067},{"$f":"H325+H326","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger",null,null,null,{"$f":"IF(D243>0,H328/D249,0)","v":0},{"$f":"IF(H423<0,H423*D256*0.5*5/I246,0)","v":0}]
["Ja",null,"Resultat/enhed",null,null,null,{"$f":"G327+G328","v":83.091541333968067},{"$f":"H327+H328","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,{"$f":"D259","v":""},{"$f":"D259","v":""}]
["Ja",null,null,null,null,null,null,null," "]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,null,null,null,"Nulpunktregulator kr./kg (målsøgning)",null,null,-0.59300263947856524]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\" kr./kg\"","v":"Følsomhed notering i forhold til: 11,5 kr./kg"},null,null,null,null,"Nulpunkt prognose"]
["Ja",null,"Noteringsændring +/- kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D243>0,I332,\"\")","v":""}]
["Ja",null,"Salgspris smågrise",{"$f":"D344","v":""},"","","","",""]
["Ja",null,{"$f":"C345","v":"Køb af smågrise ved  6,5 kg"},{"$f":"D345","v":""},"","","","",""]
["Ja",null,{"$f":"C346","v":"DB pr. enhed"},"","","","","",""]
["Ja",null,{"$f":"C348","v":"Resultat/enhed"},{"$f":"D348","v":""},"","","","",""]
["Ja"]
["Nej",null,"Følsomhedstabel smågrise"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg af smågrise beregnet 30 kg"]
["Nej",null,{"$f":"IF(D243>0,VLOOKUP(C342,C296:G330,5,FALSE)+IF(C342=C296,F297,0)+IF(C342=C298,F299,0),\"\")","v":""},{"$f":"D334","v":-1},-0.5,0,0.5,1,{"$f":"I332","v":-0.59300263947856524}]
["Nej",null,{"$f":"C296","v":"Salg af smågrise beregnet 30 kg"},"","","","","",""]
["Nej",null,{"$f":"C298","v":"Køb af smågrise ved  6,5 kg"},"","","","","",""]
["Nej",null,{"$f":"C309","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C327","v":"Ordinært resultat/enhed"},"","","","","",""]
["Nej",null,{"$f":"C329","v":"Resultat/enhed"},"","","","","",""]
["Nej"]
["Nej",null,"Investeringer smågrise","Halvårlig rente",{"$f":"POWER(10,LOG(D256+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse  år efter start","Miljøtilladelse omkostning ved fornyelse"]
["Nej",null,"Levetid angivet år",{"$f":"I247","v":15},null,{"$f":"I249","v":12.5},null,{"$f":"I251","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING(I246/D352,1)-1","v":1},null,{"$f":"CEILING($I$246/F352,1)-1","v":1},null,{"$f":"CEILING($I$246/H352,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C354<=D$353,D$352*$C354,\"\")","v":15},{"$f":"IF(ISNUMBER(D354),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},{"$f":"IF($C354<=F$353,F$352*$C354,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F354),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},{"$f":"IF($C354<=H$353,H$352*$C354,\"\")","v":9},{"$f":"IF(ISNUMBER(H354),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C355<=D$353,D$352*$C355,\"\")","v":""},{"$f":"IF(ISNUMBER(D355),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F355),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},18,{"$f":"IF(ISNUMBER(H355),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,3,"",{"$f":"IF(ISNUMBER(D356),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F356),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H356),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,4,"",{"$f":"IF(ISNUMBER(D357),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F357),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H357),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,5,"",{"$f":"IF(ISNUMBER(D358),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F358),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H358),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej"]
[{"$f":"IF($D$13=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$13=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow smågrise"]
["Ja",null,"Terminer i halvår","Investerings-summer","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato"]
["Ja",{"$f":"IF(J363>=0,0,J363)","v":0},0,{"$f":"I268*-1","v":0},0,0,0,{"$f":"D363","v":0},{"$f":"D363+E363","v":0},{"$f":"(D363+IF(C363<$I$246,$I$273,0))/1000","v":0},{"$f":"DATE(YEAR($D$32),IF(MONTH($D$32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J364>=0,0,J364)","v":0},{"$f":"IF(AND(C363<>FALSE,C363+0.5<=$I$246),C363+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C364,$D$354:$E$358,2,FALSE)),0,VLOOKUP(C364,$D$354:$E$359,2,FALSE))+IF(ISNA(VLOOKUP(C364,$F$354:$G$358,2,FALSE)),0,VLOOKUP(C364,$F$354:$G$358,2,FALSE))+IF(ISNA(VLOOKUP(C364,$H$354:$I$358,2,FALSE)),0,VLOOKUP(C364,$H$354:$I$358,2,FALSE)))*-1+IF(C364=$I$246,$I$273,0)","v":0},{"$f":"IF(C364<=$I$246,$H$318*0.5,0)","v":0},{"$f":"IF(C364<=$I$246,IF(H363<0,H363*$E$350*-1,0),0)","v":0},{"$f":"IF(H363>=0,0,IF(E364-F364>H363*-1,H363*-1,E364-F364))","v":0},{"$f":"H363+D364+G364","v":0},{"$f":"D364+E364","v":0},{"$f":"(H364+IF(C364<$I$246,$I$273,0))/1000","v":0},{"$f":"IF(MONTH(K363)+6>12,DATE(YEAR(K363)+1,MONTH(K363)+6-12,1),DATE(YEAR(K363),MONTH(K363)+6,1))","v":"2024-01-01"}]
["Ja",0,{"$f":"IF(AND(C364<>FALSE,C364+0.5<=$I$246),C364+0.5)","v":1},0,0,0,0,0,{"$f":"D365+E365","v":0},0,{"$f":"IF(MONTH(K364)+6>12,DATE(YEAR(K364)+1,MONTH(K364)+6-12,1),DATE(YEAR(K364),MONTH(K364)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,0,"2039-07-01"]
["Ja",0,16.5,{"$f":"(IF(ISNA(VLOOKUP(C396,$D$354:$E$358,2,FALSE)),0,VLOOKUP(C396,$D$354:$E$359,2,FALSE))+IF(ISNA(VLOOKUP(C396,$F$354:$G$358,2,FALSE)),0,VLOOKUP(C396,$F$354:$G$358,2,FALSE))+IF(ISNA(VLOOKUP(C396,$H$354:$I$358,2,FALSE)),0,VLOOKUP(C396,$H$354:$I$358,2,FALSE)))*-1+IF(C396=$I$246,$I$273,0)","v":0},{"$f":"IF(C396<=$I$246,$H$318*0.5,0)","v":0},{"$f":"IF(C396<=$I$246,IF(H395<0,H395*$E$350*-1,0),0)","v":0},{"$f":"IF(H395>=0,0,IF(E396-F396>H395*-1,H395*-1,E396-F396))","v":0},0,0,{"$f":"(H396+IF(C396<$I$246,$I$273,0))/1000","v":0},"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
["Ja"]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Rentabilitets analyse slagtesvin"]
[{"$f":"IF($D$11=\"Ja\",\"Nej\",\"Nej\")","v":"Nej"}]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Slagtesvine stipladser ekskl. sygestier",{"$f":"0*5057","v":0},null,"Investeringsbeløb"]
["Ja",null,null,null,null,"Stipladspris inkl. sygestier kr./stiplads",null,null,4400]
["Ja",null,"Indsættelsesvægt",30,null,"Bygningsandel af investeringsbeløb",null,null,0.72," "]
["Ja",null,"Slagtevægt",89,null,"Levetid bygninger, år",null,null,25," "]
["Ja",null,"Beregnet levendevægt E-kontrol",{"$f":"D430*1.31","v":116.59},null,"Levetid inventar, år",null,null,15," "]
["Ja",null,"Opholdstid i uger",13,null,"Miljøinvestering, kr./stiplads",null,null,275," "]
["Ja",null,"Omsætningshastighed pr. stiplads",{"$f":"365/(D432*7)","v":4.0109890109890109},null,"Forventet levetid miljøteknologi,  år",null,null,12.5," "]
["Ja",null,"Slagtesvine dødelighed",2.4E-2,null,"Miljøtilladelse kr./stiplads",null,null,{"$f":"39","v":39}]
["Ja",null,"Kasserede slagtesvin",1E-3,null,"Levetid miljøansøgning, år",null,null,9," "]
["Ja",null,"Årligt solgte slagtesvin",{"$f":"D427*D433*(1-D434-D435)","v":0},null,"Fornyet miljøansøgning kr./stiplads",null,null,{"$f":"I434*0.5","v":19.5}]
["Ja",null,"Fesv pr. kg tilvækst",2.6," ","Tilskud kr./stiplads",null,null,0]
["Ja",null,"Indkøringstab i % af fyldt stald",0.5]
["Ja",null,"Producerede slagtesvin per solgt",{"$f":"1/(1-D435-D434/2)","v":1.0131712259371835}]
["Ja",null,"Overført notering kr./kg",{"$f":"D25-D22","v":11.5},"kr./kg","Sum startinvestering"]
["Ja",null,"Vægtregulering",-0.08,"kr./kg","Investering bygninger",null,null,{"$f":"I428*I429*D427","v":0},null,null," "]
["Ja",null,"Specialgrisetillæg",0,"kr./kg","Investering inventar",null,null,{"$f":"I428*(1-I429)*D427","v":0}]
["Ja",null,"Kødprocent",0.09,"kr./kg","Renteomkostning byggeri",null,null,{"$f":"(I441*0.33+I442*0.25)*D31","v":0}]
["Ja",null,"Sygdomsfradrag",{"$f":"-0.01","v":-0.01},"kr./kg","Miljøteknologi",null,null,{"$f":"I432*D427","v":0}]
["Ja",null,"Indtransport fratrukket indberetningsbonus",{"$f":"-0.05+0.1+0.01","v":6.0000000000000005E-2},"kr./kg","Miljøansøgning",null,null,{"$f":"I434*D427","v":0}]
["Ja",null,"DB garantier eller byggebonus, NPV sandsynlighed",0.05,"kr./kg","Indkøringstab",null,null,{"$f":"(D432*D438*7/365)*H501","v":0},null,null," "]
["Ja",null,"Mængdetillæg",0.05,"kr./kg","Tilskud",null,null,{"$f":"I437*D427*-1","v":0}]
["Ja",null,"Efterbetaling eller anden bonus i NPV",1.3,"kr./kg","Lange aktiver i alt",null,null,{"$f":"SUM(I441:I447)","v":0}]
["Ja",null,"Produktionsafgift pr. kg",{"$f":"-J21/D430","v":-6.1797752808988762E-2},"kr./kg","Anskaffelsessum besætning",null,null,{"$f":"D427*SUM(F490:F492)","v":0}]
["Ja",null,"Projektets afregningspris",{"$f":"SUM(D440:D449)","v":12.898202247191014},"kr./kg","Værditilvækst besætning",null,null,{"$f":"(G500+G509)*D427*0.5*-1","v":0}]
["Ja",null,null,null,null,"Korte aktiver i alt",null,null,{"$f":"SUM(I449:I450)","v":0}]
["Ja",null,"Wacc overført pa",{"$f":"$D$30","v":5.74E-2},null,"Bunden Investering ",null,null,{"$f":"I448+I451","v":0}]
["Ja"]
["Ja",null,"Investeringens nøgletal"]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D427>0,XIRR(I558:I618,K558:K618,5%),\"\")","v":""},null,"Beløb ved investeringens ophør"]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D427>0,D455-D452,\"\")","v":""},null,"Afviklingstab",null,null,{"$f":"I446*-1*IF(D438>50%,50%/D438,1)","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D427>0,IF(MAX(J558:J618)>0,VLOOKUP(0,B558:C618,2,FALSE)+IF(VLOOKUP(0,B558:C618,2,FALSE)<I430,0.5),\"Aldrig\"),\"\")","v":""},null,"Besætning",null,null,{"$f":"I451","v":0}]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D427>0,I527*-1,\"\")","v":""},null,"I alt ",null,null,{"$f":"SUM(I456:I457)","v":0}]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D427>0,D21-D458,\"\")","v":""}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D427>0,XNPV(D452,I558:I618,K558:K618)/1000,\"\")","v":""}]
["Ja"]
["Ja",null,"Nulpunktspriser","Kr./slagtesvin"]
["Ja",null,"Salgspris",{"$f":"IF(D427>0,I529,\"\")","v":""}]
["Ja",null,"Indkøbspris",{"$f":"IF(D427>0,I530,\"\")","v":""}]
["Ja",null,"DB pr. enhed",{"$f":"IF(D427>0,I531,\"\")","v":""}]
["Ja",null,"Resultat pr. enhed",{"$f":"I532","v":""}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null,"Slagtesvin rentabilitetskalkule","Start enhed","Enheder","Enheds-værdi","kr./solgt slagtesvin","Kr. årligt"]
["Ja",null,{"$f":"\"Salg af slagtesvin ved \" & ROUND(D430,1)& \" kg slagtet\"","v":"Salg af slagtesvin ved 89 kg slagtet"},"Slagtevægt i kg",{"$f":"D430","v":89},{"$f":"D450","v":12.898202247191014},{"$f":"E489*F489","v":1147.9400000000003},{"$f":"D$436*G489","v":0}]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,{"$f":"\"Køb af smågrise ved \"&ROUND(D429,1)& \" kg pris beregnet not.\"","v":"Køb af smågrise ved 30 kg pris beregnet not."},"pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},{"$f":"VLOOKUP(D429,$D$40:$H$47,5,TRUE)-(VLOOKUP(D429,$D$40:$F$47,2,TRUE)-D429)*(VLOOKUP(D429,$D$40:$F$47,3,TRUE))","v":465.6165959999999},{"$f":"E490*F490*-1","v":-477.55548307692305},{"$f":"D$436*G490","v":0},null,null," "]
["Ja",null,"Tillæg/fradrag","pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},{"$f":"F109","v":10},{"$f":"E491*F491*-1","v":-10.256410256410257},{"$f":"D$436*G491","v":0}]
["Ja",null,"Transport","pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},9,{"$f":"E492*F492*-1","v":-9.2307692307692317},{"$f":"D$436*G492","v":0},null,null," "]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G489:G492)","v":650.89733743589761},{"$f":"SUM(H489:H492)","v":0}]
["Ja",null,"Slagtesvineblanding 1","FEsv/produceret",0,{"$f":"D20","v":2},{"$f":"E494*F494*(1+$D$434/2+$D$435)*-1","v":0},{"$f":"D$436*G494","v":0}]
["Ja",null,"Slagtesvineblanding 2 (residual)","FEsv/produceret",{"$f":"D437*(D431-D429)-E494","v":225.13400000000001},{"$f":"D20","v":2},{"$f":"E495*F495*(1+$D$434/2+$D$435)*-1","v":-456.12148400000001},0]
["Ja",null,"Grovfoder","pr. produceret",0,0,{"$f":"E496*F496*-1","v":0},0]
["Ja",null,"Rådgivning","pr. produceret",{"$f":"D$439","v":1.0131712259371835},1,{"$f":"E497*F497*-1","v":-1.0131712259371835},0,null,null," "]
["Ja",null,"Medicin & vacciner","pr. produceret",{"$f":"D$439","v":1.0131712259371835},4,{"$f":"E498*F498*-1","v":-4.0526849037487338},0]
["Ja",null,"Diverse stykomkostninger","pr. produceret",{"$f":"D$439","v":1.0131712259371835},6,{"$f":"E499*F499*-1","v":-6.0790273556231007},0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G494:G499)","v":-467.26636748530905},{"$f":"SUM(H494:H499)","v":0}]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G493+G500","v":183.63096995058856},{"$f":"H493+H500","v":0}]
["Ja",null,"Arbejde, min./slagtesvin","min./produceret",11,{"$f":"192/60","v":3.2},{"$f":"E502*F502*-1*D$439","v":-35.663627152988859},{"$f":"D$436*G502","v":0}]
["Ja",null,"Energi","kWh/produceret",14,0.8,{"$f":"E503*F503*-1*D$439","v":-11.347517730496456},0]
["Ja",null,"Forsikring","pr. produceret",{"$f":"D$439","v":1.0131712259371835},4,{"$f":"E504*F504*-1","v":-4.0526849037487338},0]
["Ja",null,"Driftsomkostning miljøteknologi","pr. produceret",{"$f":"D$439","v":1.0131712259371835},{"$f":"3.5+1.4","v":4.9000000000000004},{"$f":"E505*F505*-1","v":-4.9645390070921991},0]
["Ja",null,"Vedligehold","pr. produceret",{"$f":"D$439","v":1.0131712259371835},{"$f":"-1*G506/E506","v":0},{"$f":"IF(D427>0,H506/D436,0)","v":0},{"$f":"(F511*J24+F512*J25)*D427*-1","v":0}]
["Ja",null,"Gyllens nettoværdi","Tons/produceret",{"$f":"SUM(E494:E495)*2.3/1000","v":0.51780819999999994},-20,{"$f":"E507*F507*-1*D$439","v":10.492567375886525},{"$f":"D$436*G507*-1","v":0}]
["Ja",null,"Diverse kapacitetsomkostninger","pr. produceret",{"$f":"D$439","v":1.0131712259371835},8,{"$f":"E508*F508*-1","v":-8.1053698074974676},0]
["Ja",null,"Kontante kapacitetsomkostning pr. enhed",null,null,null,{"$f":"SUM(G502:G508)","v":-53.641171225937192},0]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G501+G509","v":129.98979872465137},{"$f":"H501+H509","v":0}]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"I428*I429","v":3168},{"$f":"IF(D$427>0,H511/D$436,0)","v":0},{"$f":"E511*F511*D$427*-1","v":0}]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I430/I431,1)/I430","v":0.08},{"$f":"(1-I429)*I428","v":1232.0000000000002},{"$f":"IF(D$427>0,H512/D$436,0)","v":0},{"$f":"E512*F512*D$427*-1","v":0}," "]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I430/I433,1)/I430","v":0.08},{"$f":"I432","v":275},{"$f":"IF(D$427>0,H513/D$436,0)","v":0},{"$f":"E513*F513*D$427*-1","v":0}]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"H514/E514/IF(D427>0,D427,1)*-1","v":0},{"$f":"IF(D$427>0,H514/D$436,0)","v":0},{"$f":"(I443+I445+I446*2+SUM(I549:I553))*-1/I430","v":0},null,null,null,null,null,null,null," "]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"(H515/E515)/IF(D427>0,D427,1)","v":0},{"$f":"H515/IF(D427>0,D436,1)","v":0},{"$f":"E515*I447*-1","v":0}]
["Ja",null,"Afskrivninger  i  alt",null,null,null,{"$f":"SUM(G511:G515)","v":0},{"$f":"SUM(H511:H515)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G510+G516","v":129.98979872465137},{"$f":"H510+H516","v":0}]
["Ja",null,"Renteomkostning ",null,null,null,{"$f":"IF(D427>0,H518/D436,0)","v":0},{"$f":"(SUM(F558:F618)/I430)*-1","v":0}]
["Ja",null,"Ordinært resultat/enhed",null,null,null,{"$f":"G517+G518","v":129.98979872465137},{"$f":"H517+H518","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger",null,null,null,{"$f":"IF(D427>0,H520/D436,0)","v":0},{"$f":"IF(H618<0,H618*5*0.5*D452/I430,0)","v":0}]
["Ja",null,"Resultat/enhed",null,null,null,{"$f":"G519+G520","v":129.98979872465137},{"$f":"H519+H520","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,null,{"$f":"D455","v":""}]
["Ja"]
["Ja"]
["Ja",null,null,null,null,"Nulpunktregulator kr./kg",null,null,-8.5922479011059961E-3]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\" kr./kg\"","v":"Følsomhed notering i forhold til: 11,5 kr./kg"},null,null,null,null,"Nulpunkt prognose"]
["Ja",null,"Noteringsændring +/- kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D427>0,I525,\"\")","v":""}]
["Ja",null,"Afregningspris i kr./kg",{"$f":"$F528+D527","v":11.898202247191014},{"$f":"$F528+E527","v":12.398202247191014},{"$f":"$D$450+F527","v":12.898202247191014},{"$f":"$D$450+G527","v":13.398202247191014},{"$f":"$D$450+H527","v":13.898202247191014},{"$f":"$D$450+I527","v":{"$error":"#VALUE!"}}]
["Ja",null,{"$f":"C538","v":"Salg af slagtesvin ved 89 kg slagtet"},{"$f":"D538","v":""},"","","","",""]
["Ja",null,"Smågrise købspris",{"$f":"D539","v":""},"","","","",""]
["Ja",null,{"$f":"C540","v":"DB pr. enhed"},{"$f":"D540","v":""},"","","","",""]
["Ja",null,{"$f":"C542","v":"Resultat/enhed"},{"$f":"D542","v":""},"","","","",""]
["Ja"]
["Nej",null,"Følsomhedstabel slagtesvin"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg af slagtesvin ved 85 kg slagtet","Noteringsændring kr./kg"]
["Nej",null,{"$f":"IF(D427>0,VLOOKUP(C536,C488:G522,5,FALSE)+IF(C536=C490,F491+F492,0),\"\")","v":""},{"$f":"D527","v":-1},-0.5,0,0.5,1,{"$f":"I525","v":-8.5922479011059961E-3}]
["Nej",null,{"$f":"C489","v":"Salg af slagtesvin ved 89 kg slagtet"},"","","","","",""]
["Nej",null,{"$f":"C490","v":"Køb af smågrise ved 30 kg pris beregnet not."},"","","","","",""]
["Nej",null,{"$f":"C501","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C519","v":"Ordinært resultat/enhed"},"","","","","",""]
["Nej",null,{"$f":"C521","v":"Resultat/enhed"},"","","","","",""]
["Nej"]
["Nej",null," "]
["Nej",null,"Investeringer slagtesvin","Halvårlig rente",{"$f":"POWER(10,LOG(D452+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse  år efter start","Miljøtilladelse omkostning ved fornyelse"]
["Nej",null,"Levetid angivet",{"$f":"I431","v":15},null,{"$f":"I433","v":12.5},null,{"$f":"I435","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING($I$430/D547,1)-1","v":1},null,{"$f":"CEILING($I$430/F547,1)-1","v":1},null,{"$f":"CEILING($I$430/H547,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C549<=D$548,D$547*$C549,\"\")","v":15},{"$f":"IF(ISNUMBER(D549),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},{"$f":"IF($C549<=F$548,F$547*$C549,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F549),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C549<=H$548,H$547*$C549,\"\")","v":9},{"$f":"IF(ISNUMBER(H549),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C550<=D$548,D$547*$C550,\"\")","v":""},{"$f":"IF(ISNUMBER(D550),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F550),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},18,{"$f":"IF(ISNUMBER(H550),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,3,"",{"$f":"IF(ISNUMBER(D551),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F551),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H551),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,4,"",{"$f":"IF(ISNUMBER(D552),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F552),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H552),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,5,"",{"$f":"IF(ISNUMBER(D553),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F553),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H553),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej"]
[{"$f":"IF($D$14=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$14=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow Slagtesvin"]
["Ja",null,"Terminer i halvår","Investeringssum","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato"]
["Ja",{"$f":"IF(J558>=0,0,J558)","v":0},0,{"$f":"I452*-1","v":0},0,0,0,{"$f":"D558","v":0},{"$f":"D558","v":0},{"$f":"D558/1000","v":0},{"$f":"DATE(YEAR($D$32),IF(MONTH($D$32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J559>=0,0,J559)","v":0},{"$f":"IF(AND(C558<>FALSE,C558+0.5<=$I$430),C558+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C559,$D$549:$E$553,2,FALSE)),0,VLOOKUP(C559,$D$549:$E$553,2,FALSE))+IF(ISNA(VLOOKUP(C559,$F$549:$G$553,2,FALSE)),0,VLOOKUP(C559,$F$549:$G$553,2,FALSE))+IF(ISNA(VLOOKUP(C559,$H$549:$I$553,2,FALSE)),0,VLOOKUP(C559,$H$549:$I$553,2,FALSE)))*-1+IF(C559=$I$430,$I$458,0)","v":0},{"$f":"IF(C559<=$I$430,$H$510*0.5,0)","v":0},{"$f":"IF(C559<=$I$430,IF(H558<0,H558*$E$545*-1,0),0)","v":0},{"$f":"IF(H558>=0,0,IF(E559-F559>H558*-1,H558*-1,E559-F559))","v":0},{"$f":"H558+D559+G559","v":0},{"$f":"D559+E559","v":0},{"$f":"(H559+IF(C559<$I$430,$I$458,0))/1000","v":0},{"$f":"IF(MONTH(K558)+6>12,DATE(YEAR(K558)+1,MONTH(K558)+6-12,1),DATE(YEAR(K558),MONTH(K558)+6,1))","v":"2024-01-01"}]
["Ja",0,{"$f":"IF(AND(C559<>FALSE,C559+0.5<=$I$430),C559+0.5)","v":1},0,0,0,0,0,{"$f":"D560+E560","v":0},0,{"$f":"IF(MONTH(K559)+6>12,DATE(YEAR(K559)+1,MONTH(K559)+6-12,1),DATE(YEAR(K559),MONTH(K559)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,0,"2039-07-01"]
["Ja",0,16.5,{"$f":"(IF(ISNA(VLOOKUP(C591,$D$549:$E$553,2,FALSE)),0,VLOOKUP(C591,$D$549:$E$553,2,FALSE))+IF(ISNA(VLOOKUP(C591,$F$549:$G$553,2,FALSE)),0,VLOOKUP(C591,$F$549:$G$553,2,FALSE))+IF(ISNA(VLOOKUP(C591,$H$549:$I$553,2,FALSE)),0,VLOOKUP(C591,$H$549:$I$553,2,FALSE)))*-1+IF(C591=$I$430,$I$458,0)","v":0},{"$f":"IF(C591<=$I$430,$H$510*0.5,0)","v":0},{"$f":"IF(C591<=$I$430,IF(H590<0,H590*$E$545*-1,0),0)","v":0},0,0,0,0,"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
["Ja"]
[{"$f":"IF($D$15=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Samlet rentabilitetsanalyse","Årlig enheder","Investerings sum mio.","Levetid år bygninger"]
[{"$f":"IF($D$15=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Antal årssøer",{"$f":"D51","v":0},{"$f":"I77/1000000","v":0},{"$f":"I56","v":25}]
["Ja",null,"Solgte fravænnede ",{"$f":"D51*D58","v":0}]
["Ja",null,"Solgte smågrise",{"$f":"D249","v":0},{"$f":"I268/1000000","v":0},{"$f":"I246","v":25}]
["Ja",null,"Solgte slagtesvin",{"$f":"D436","v":0},{"$f":"I452/1000000","v":0},{"$f":"I430","v":25}]
["Ja",null,"Maks.",null,null,{"$f":"MAX(F621:F624)","v":25}]
["Ja",null,null,"Søer","Smågrise","Slagtesvin","I alt"]
["Ja",null,"Bruttoudbytte",{"$f":"IF(D$51>0,H114,0)","v":0},{"$f":"IF($D$243>0,H301,0)","v":0},{"$f":"IF($D$427>0,H493,0)","v":0},{"$f":"SUM(D627:F627)","v":0}]
["Ja",null,"Stykomkostninger i alt",{"$f":"IF(D$51>0,H124,0)","v":0},{"$f":"IF($D$243>0,H308,0)","v":0},{"$f":"IF($D$427>0,H500,0)","v":0},{"$f":"SUM(D628:F628)","v":0}]
["Ja",null,"Dækningsbidrag i alt",{"$f":"D627+D628","v":0},{"$f":"E627+E628","v":0},{"$f":"F627+F628","v":0},0]
["Ja",null,"Kontante kapacitetsomkostning i alt",{"$f":"IF(D$51>0,H133,0)","v":0},{"$f":"IF($D$243>0,H317,0)","v":0},{"$f":"IF($D$427>0,H509,0)","v":0},0]
["Ja",null,"EBID",{"$f":"D629+D630","v":0},{"$f":"E629+E630","v":0},{"$f":"F629+F630","v":0},0]
["Ja",null,"Afskrivninger",{"$f":"IF(D$51>0,H140,0)","v":0},{"$f":"IF($D$243>0,H324,0)","v":0},{"$f":"IF($D$427>0,H516,0)","v":0},0]
["Ja",null,"Resultat af primær drift",{"$f":"D631+D632","v":0},{"$f":"E631+E632","v":0},{"$f":"F631+F632","v":0},0]
["Ja",null,"Renteomkostninger",{"$f":"IF(D$51>0,H142,0)","v":0},{"$f":"IF($D$243>0,H326,0)","v":0},{"$f":"IF($D$427>0,H518,0)","v":0},0]
["Ja",null,"Ordinært resultat",{"$f":"D633+D634","v":0},{"$f":"E633+E634","v":0},{"$f":"F633+F634","v":0},0]
["Ja",null,"Ekstraordinære renteomkostninger",{"$f":"IF(D54>0,H144,0)","v":0},{"$f":"IF($D$243>0,H328,0)","v":0},{"$f":"IF($D$427>0,H520,0)","v":0},0]
["Ja",null,"Resultat i alt",{"$f":"D635+D636","v":0},{"$f":"E635+E636","v":0},{"$f":"F635+F636","v":0},0]
["Ja",null,"Afkastningsgrad",{"$f":"D73","v":""},{"$f":"D259","v":""},{"$f":"D455","v":""},{"$f":"IF(SUM(E621:E624)>0,XIRR(I653:I713,K653:K713,5%),0)","v":0}]
["Ja",null,"EVA","","","",{"$f":"IF(SUM(E621:E625)>0,G638-D30,0)","v":0}]
["Ja",null,"Tilbagebetalingstid i år","","","",{"$f":"IF(MAX(J653:J713)>=0,VLOOKUP(0,J653:L713,3,TRUE),\"Aldrig\")","v":30}]
["Ja",null,"Sikkerhedsmargin notering, kr./kg","","",""]
["Ja",null,"Nulpunktsnotering kr./kg","","",""]
["Ja",null,"Kapitalværdi i 1000 kr.","","","",{"$f":"XNPV(D30,I653:I713,K653:K713)/1000","v":0}]
["Ja"]
["Ja"]
["Ja",null,"Note: De enkelte driftsgrene er lagt sammen, dvs. høj EVA for en driftsgren ikke afdrager gælden hurtigere for en anden"]
["Ja",null,"Afkastningsgraden er dog beregnet selvstændigt, og den overordnede WACC er brugt"]
["Ja"]
["Ja"]
["Ja"]
[{"$f":"IF($D$16=\"Ja\",\"Ja\",\"Nej\")","v":"Nej"},null,"Cashflow konsolideret"]
[{"$f":"IF($D$16=\"Ja\",\"Ja\",\"Nej\")","v":"Nej"},null,"Terminer i halvår","Investeringssum","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato","År"]
["Nej",null,0,{"$f":"IF($D$51>0,D179,0)+IF($D$243>0,D363,0)+IF($D$427>0,D558,0)","v":0},0,0,0,0,0,0,{"$f":"K179","v":"2023-07-01"},{"$f":"C653","v":0}]
["Nej",null,{"$f":"C653+0.5","v":0.5},0,0,0,0,0,0,0,"2024-01-01",{"$f":"C654","v":0.5}]
["Nej",null,{"$f":"C654+0.5","v":1},0,0,0,0,0,0,0,"2024-07-01",1]
["Nej",null,1.5,0,0,0,0,0,0,0,"2025-01-01",1.5]
["Nej",null,2,0,0,0,0,0,0,0,"2025-07-01",2]
["Nej",null,2.5,0,0,0,0,0,0,0,"2026-01-01",2.5]
["Nej",null,3,0,0,0,0,0,0,0,"2026-07-01",3]
["Nej",null,3.5,0,0,0,0,0,0,0,"2027-01-01",3.5]
["Nej",null,4,0,0,0,0,0,0,0,"2027-07-01",4]
["Nej",null,4.5,0,0,0,0,0,0,0,"2028-01-01",4.5]
["Nej",null,5,{"$f":"IF($D$51>0,D189,0)+IF($D$243>0,D373,0)+IF($D$427>0,D568,0)","v":0},0,0,0,0,0,0,"2028-07-01",5]
["Nej",null,5.5,0,0,0,0,0,0,0,"2029-01-01",5.5]
["Nej",null,6,0,0,0,0,0,0,0,"2029-07-01",6]
["Nej",null,6.5,0,0,0,0,0,0,0,"2030-01-01",6.5]
["Nej",null,7,0,0,0,0,0,0,0,"2030-07-01",7]
["Nej",null,7.5,0,0,0,0,0,0,0,"2031-01-01",7.5]
["Nej",null,8,0,0,0,0,0,0,0,"2031-07-01",8]
["Nej",null,8.5,0,0,0,0,0,0,0,"2032-01-01",8.5]
["Nej",null,9,0,0,0,0,0,0,0,"2032-07-01",9]
["Nej",null,9.5,0,0,0,0,0,0,0,"2033-01-01",9.5]
["Nej",null,10,{"$f":"IF($D$51>0,D199,0)+IF($D$243>0,D383,0)+IF($D$427>0,D578,0)","v":0},0,0,0,0,0,0,"2033-07-01",10]
["Nej",null,10.5,0,0,0,0,0,0,0,"2034-01-01",10.5]
["Nej",null,11,0,0,0,0,0,0,0,"2034-07-01",11]
["Nej",null,11.5,0,0,0,0,0,0,0,"2035-01-01",11.5]
["Nej",null,12,0,0,0,0,0,0,0,"2035-07-01",12]
["Nej",null,12.5,0,0,0,0,0,0,0,"2036-01-01",12.5]
["Nej",null,13,0,0,0,0,0,0,0,"2036-07-01",13]
["Nej",null,13.5,0,0,0,0,0,0,0,"2037-01-01",13.5]
["Nej",null,14,0,0,0,0,0,0,0,"2037-07-01",14]
["Nej",null,14.5,0,0,0,0,0,0,0,"2038-01-01",14.5]
["Nej",null,15,{"$f":"IF($D$51>0,D209,0)+IF($D$243>0,D393,0)+IF($D$427>0,D588,0)","v":0},0,0,0,0,0,0,"2038-07-01",15]
["Nej",null,15.5,0,0,0,0,0,0,0,"2039-01-01",15.5]
["Nej",null,16,0,0,0,0,0,0,0,{"$f":"K211","v":"2039-07-01"},16]
["Nej",null,16.5,0,0,0,0,0,0,0,"2040-01-01",16.5]
["Nej",null,17,0,0,0,0,0,0,0,"2040-07-01",17]
["Nej",null,17.5,0,0,0,0,0,0,0,"2041-01-01",17.5]
["Nej",null,18,0,0,0,0,0,0,0,"2041-07-01",18]
["Nej",null,18.5,0,0,0,0,0,0,0,"2042-01-01",18.5]
["Nej",null,19,0,0,0,0,0,0,0,"2042-07-01",19]
["Nej",null,19.5,0,0,0,0,0,0,0,"2043-01-01",19.5]
["Nej",null,20,{"$f":"IF($D$51>0,D219,0)+IF($D$243>0,D403,0)+IF($D$427>0,D598,0)","v":0},0,0,0,0,0,0,"2043-07-01",20]
["Nej",null,20.5,0,0,0,0,0,0,0,"2044-01-01",20.5]
["Nej",null,21,0,0,0,0,0,0,0,"2044-07-01",21]
["Nej",null,21.5,0,0,0,0,0,0,0,"2045-01-01",21.5]
["Nej",null,22,0,0,0,0,0,0,0,"2045-07-01",22]
["Nej",null,22.5,0,0,0,0,0,0,0,"2046-01-01",22.5]
["Nej",null,23,0,0,0,0,0,0,0,"2046-07-01",23]
["Nej",null,23.5,0,0,0,0,0,0,0,"2047-01-01",23.5]
["Nej",null,24,0,0,0,0,0,0,0,"2047-07-01",24]
["Nej",null,24.5,0,0,0,0,0,0,0,"2048-01-01",24.5]
["Nej",null,25,{"$f":"IF($D$51>0,D229,0)+IF($D$243>0,D413,0)+IF($D$427>0,D608,0)","v":0},0,0,0,0,0,0,"2048-07-01",25]
["Nej",null,25.5,0,0,0,0,0,0,0,"2049-01-01",25.5]
["Nej",null,26,0,0,0,0,0,0,0,"2049-07-01",26]
["Nej",null,26.5,0,0,0,0,0,0,0,"2050-01-01",26.5]
["Nej",null,27,0,0,0,0,0,0,0,"2050-07-01",27]
["Nej",null,27.5,0,0,0,0,0,0,0,"2051-01-01",27.5]
["Nej",null,28,0,0,0,0,0,0,0,"2051-07-01",28]
["Nej",null,28.5,0,0,0,0,0,0,0,"2052-01-01",28.5]
["Nej",null,29,0,0,0,0,0,0,0,"2052-07-01",29]
["Nej",null,29.5,0,0,0,0,0,0,0,"2053-01-01",29.5]
["Nej",null,30,{"$f":"IF($D$51>0,D239,0)+IF($D$243>0,D423,0)+IF($D$427>0,D618,0)","v":0},0,0,0,0,0,0,"2053-07-01",30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"Investerings kalkule u. makro","index":3,"n_rows":728,"n_cols":16,"rows_kept":728,"cut":false,"hidden":false,"merged":[[241,2,241,8],[424,2,424,9],[535,3,535,8],[13,5,14,9],[16,2,16,9],[17,4,17,9],[49,2,49,8],[148,3,148,7],[157,3,157,8],[10,5,11,9],[1,2,2,4],[1,5,2,5],[1,6,2,9],[4,2,4,9],[7,5,8,9]]}
[]
[null,null,"Rentabilitetsanalyser svin ved investeringer i stalde",null,null,"For:","SEGES"]
[]
[null,null,"Navigationslink række visninger","Prisprognose på mellem langsigt",null,"So kalkule","Smågrise kalkule","Slagtesvin kalkule",null,"Samlet R-analyse"]
["Vis"]
["Nej"]
["Ja",null,"Styring af rækker som vises via egne valg. Vælg celle A4 og vælg ja og tryk ok",null,null," "]
["Ja",null,"Vis langsigtet prognose","Ja",null," Foretag dine valg, og vælg celle A4 og sig Ok til vis Ja"]
["Ja",null,"Vis søer","Ja"]
["Ja",null,"Vis smågrise","Ja"]
["Ja",null,"Vis slagtesvin","Ja",null,"Gule celler er input celle. Indsæt ikke egne rækker etc. I dette regneark"]
["Ja",null,"Vis cashflow søer","Ja"]
["Ja",null,"Vis cashflow smågrise","Ja"]
["Ja",null,"Vis cashflow slagtesvin","Ja",null,"Der kan laves et kopi af arket som kan gives nyt navn, hvis man gerne vil have flere scenarier i samme regnearksfil"]
["Ja",null,"Konsolideret ved mere end 1 driftsgren","Ja"]
["Ja",null,"Konsolideret cashflow","Nej"]
["Ja",null,"Rentabilitetsanalyser svin ved investeringer i stalde"]
[{"$f":"IF($D$8=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Prisprognose dansk griseproduktion mellemlang sigt",null,"Anbefalet prisniveau på mellemlang sigt er 2 kr. FEsv/slagtegrisefoder og 11,5 kr./kg i notering"]
["Ja",null,"Sidste længere prisprognose","2022-11-28",null,"Normpristal"]
["Ja",null,"Indkøbt slagtegrisefoderpris prognose landsplan",2,"kr./FEsv","Produktionsafgift søer og slagtepolte",null,null,null,10.9]
["Ja",null,"Mellemlamgsigtet notering svin ved denne foderpris",11.5,"kr./kg","Produktionsafgift slagtesvin",null,null,null,5.5]
["Ja",null,"Diverse standard korrektioner, kr../kg",1.36,null,"Genafgift søer",null,null,null,70]
["Ja",null,"Gns. dansk afregningspris",{"$f":"D21+D22","v":12.86},"kr./kg","Anslået købspris LY sopolte ved givet niveau",null,null,null,{"$f":"(D25+0.12)*125+500","v":2122.5}]
["Ja",null,"Følsomhed notering svin (bruges af program)",0,null,"Vedligehold bygninger af investeringssum",null,null,null,6.0000000000000001E-3]
["Ja",null,"Dansk afregningspris inkl. følsomhedsfaktor",{"$f":"D21+D22+D24","v":12.86},null,"Vedligehold inventar af investeringssum",null,null,null,0.02]
["Ja",null,"Afregningspris kr./kg slagtesøer",{"$f":"ROUND((D21+D24)*Smågrisepriser!B12,2)+(D22-Smågrisepriser!B10)","v":9.7900000000000009}]
["Ja",null,"Følsomhedsanalyse (+/- 2 intervaller) "]
["Ja",null,{"$f":"\"+/-  gns. dansk notering kr./kg\"","v":"+/-  gns. dansk notering kr./kg"},0.5,"kr/kg"]
["Ja",null,"Renteniveau indlagt (wacc)"]
["Ja",null,"Kalkulationsrente i beregningerne (wacc)",5.74E-2,"pa"]
["Ja",null,"Byggerente",5.74E-2,"pa"]
["Ja",null,"Investeringens startdato","2023-07-01"]
[{"$f":"IF($D$8=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
["Ja",null,"Tabel for smågrisenotering ved angivet notering og langsigtet foderprognose. Over 40 kg findes ingen beregnet notering"]
["Ja",null,"Indlagt notering + følsomhedsfaktor",{"$f":"D21+D24","v":11.5}]
["Ja",null,"7 kg smågrisepris",{"$f":"VLOOKUP(D20,Nulpunktstabel,4,FALSE)+(D35-VLOOKUP(D20,Nulpunktstabel,3,FALSE))*Normtal_slagtevægt*Finansieringssandel_7_kg","v":268.81795599999998},"Kr./gris"]
["Ja",null,"30 kg smågrisepris",{"$f":"VLOOKUP(D20,Nulpunktstabel,5,FALSE)+(D35-VLOOKUP(D20,Nulpunktstabel,3,FALSE))*Normtal_slagtevægt*Finansieringsandel_30_kg","v":465.61659599999996},"Kr./gris"]
["Ja"]
["Ja",null,"Kg regulering","Fra kg","Til kg","Kr/.kg","Startpris","Slutpris"]
["Ja",null,null,0,7,{"$f":"F41+Smågrisepriser!B$20","v":12.969431836223098},{"$f":"G41-E40*F40","v":178.03193314643829},{"$f":"G40+(E40-D40)*F40","v":268.81795599999998}]
["Ja",null,null,{"$f":"E40","v":7},9,{"$f":"VLOOKUP(D$20,Nulpunktstabel,7,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":9.969431836223098},{"$f":"D36","v":268.81795599999998},288.75681967244617]
["Ja",null,null,9,12,{"$f":"VLOOKUP(D$20,Nulpunktstabel,8,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":13.998315629830786},{"$f":"H41","v":288.75681967244617},330.75176656193855]
["Ja",null,null,12,25,{"$f":"VLOOKUP(D$20,Nulpunktstabel,9,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":8.0577675872153716},{"$f":"H42","v":330.75176656193855},435.50274519573838]
["Ja",null,null,25,30,{"$f":"VLOOKUP(D$20,Nulpunktstabel,10,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":6.0227701608523061},{"$f":"H43","v":435.50274519573838},465.6165959999999]
["Ja",null,null,30,40,{"$f":"VLOOKUP(D$20,Nulpunktstabel,11,FALSE)*((D37-D36)/(VLOOKUP(D20,Nulpunktstabel,5,FALSE)-VLOOKUP(D20,Nulpunktstabel,4,FALSE)))","v":6.7524914602047197},{"$f":"H44","v":465.6165959999999},533.14151060204711]
["Ja",null,null,40,130,{"$f":"F45","v":6.7524914602047197},{"$f":"H45","v":533.14151060204711},1140.8657420204718]
["Ja",null," ",130,1000,{"$f":"F46","v":6.7524914602047197}]
["Ja"]
["Ja"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Rentabilitetsberegning søer"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Antal årssøer",{"$f":"0*1200","v":0},null,"Investeringsbeløb pr. årsso"]
["Ja",null,"Produktions oplysninger"]
["Ja",null,"Fravænningsvægt, kg",6.5,null,"Stalde, bygninger, miljøteknologi og tilskud",null,null,null,null,null," "]
["Ja",null,"Spildfoderdage/kuld",13,null,"Investeringsbeløb, kr.årsso",null,null,25000]
["Ja",null,"Soens laktationsperiode, dage/kuld",32,null,"Bygningsandel i % investeringsbeløb",null,null,0.68]
["Ja",null,"Kuld/årsso",{"$f":"365/(D54+D55+117)","v":2.2530864197530862},null,"Levetid bygninger, år",null,null,25]
["Ja",null,"Fravænnede grise/kuld",16.100000000000001,null,"Levetid inventar, år",null,null,15]
["Ja",null,"Fravænnnede grise/årsso",{"$f":"ROUND(D56*D57,1)","v":36.299999999999997},null,"Miljøinvestering, kr./årsso",null,null,1100]
["Ja",null,"Slagtevægt søer, kg",185,null,"Forventet levetid miljøteknologi, år",null,null,12.5]
["Ja",null,"1 lægspct. efter indkøring, % af farekuld",0.23499999999999999,null,"Miljøtilladelse i kr./årsso",null,null,{"$f":"IF(D51>0,41+55,0)","v":0}]
["Ja",null,"Årlig soudskiftning, pct.",{"$f":"D56*D60","v":0.52947530864197523},null,"Levetid miljøansøgning, år",null,null,9]
["Ja",null,"Udnyttelsesprocent polte, %",0.95,null,"Fornyet miljøansøgning i kr./årsso",null,null,{"$f":"I60*0.5","v":0}]
["Ja",null,"Sodødelighed, i % af årssøer",0.12,null,"Tilskud pr. årsso, kr./årsso",null,null,0]
["Ja",null,"Kernestyring eller indkøbte polte","Nej"]
["Ja",null,"Prisreduktion polte 22 uger ved egen avl",400," ","Sum startinvestering"]
["Ja",null,"Indkøringstab % af fuld produktion",0.5,null,"Investering bygninger",null,null,{"$f":"D51*I54*I55","v":0}]
["Ja",null,null,null,null,"Investering inventar",null,null,{"$f":"D51*I54*(1-I55)","v":0}]
["Ja",null,"WACC overført pa.",{"$f":"D30","v":5.74E-2},null,"Renteomkostning byggeri",null,null,{"$f":"(I66*0.33+I67*0.25)*D31","v":0}]
["Ja",null,null," ",null,"Miljøteknologi",null,null,{"$f":"I58*D51","v":0}]
["Ja",null,"Vælg afrapportering enhed tabeller","Kr./frav.",null,"Miljøansøgning",null,null,{"$f":"I60*D51","v":0}]
["Ja",null,null,null,null,"Indkøringstab",null,null,{"$f":"D66*(21/52)*I125*D51","v":0},null,null," "]
["Ja",null,"Investerings nøgletal",null,null,"Tilskud",null,null,{"$f":"I63*D51*-1","v":0}]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D51>0,XIRR(I179:I239,K179:K239,5%),\"\")","v":""},null,"Lange aktiver i alt",null,null,{"$f":"SUM(I66:I72)","v":0}]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D51>0,D73-D68,\"\")","v":""},null,"Anskaffelsessum besætning",null,null,{"$f":"(J23-IF(D64=\"Ja\",D65,0))*D51","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D51>0,IF(MAX(J179:J239)>0,VLOOKUP(0,B179:C239,2,FALSE)+IF(VLOOKUP(0,B179:C239,2,FALSE)<I56,0.5),\"Aldrig\"),\"\")","v":""},null,"Gns. værditilvækst besætning",null,null,{"$f":"(-1*(G112+G113+G124+G133)*D57/2)*D51","v":0}," "]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D51>0,I150*-1,\"\")","v":""},null,"Korte aktiver i alt",null,null,{"$f":"SUM(I74:I75)","v":0},null,null," "]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D51>0,D21-D76,\"\")","v":""},null,"Bunden Investering ",null,null,{"$f":"I73+I76","v":0}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D51>0,XNPV(D68,I179:I239,K179:K239)/1000,\"\")","v":""}]
["Ja",null,null,null,null,"Beløb ved investeringens ophør"]
["Ja",null,"Nulpunkts priser",{"$f":"D70","v":"Kr./frav."},null,"Afviklingstab søer",null,null,{"$f":"I71*-1*(50%/D66)","v":0}]
["Ja",null,{"$f":"C151","v":"Salgspris fravænnede"},{"$f":"I151","v":""},null,"Sobesætningselimeringstab",null,null,{"$f":"(D51*(J23-IF(D64=\"Ja\",D65,0))-D26*D51*D59)*-1","v":0}]
["Ja",null,"DB pr. enhed",{"$f":"I152","v":""},null,"Besætningsværdi ved eliminering",null,null,{"$f":"I74+I75","v":0}]
["Ja",null,"Resultat pr. enhed",{"$f":"I153","v":""},null,"I alt",null,null,{"$f":"SUM(I80:I82)","v":0}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null,null,null,null,null,null,null,null,null," "]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null,"Søer rentabilitetskalkule","Enhed input","Enheder","Enheds-værdi kr./enhed","Kr./frav.","Beløb pr år i kr.","Kr./årsso"]
["Ja",null,"Salg fravænnede grise beregnet inkl. kg regulering","pr. årsso",{"$f":"ROUND(D56*D57,1)","v":36.299999999999997},{"$f":"VLOOKUP(D53,$D$40:$H$47,5,TRUE)-(VLOOKUP(D53,$D$40:$F$47,2,TRUE)-D53)*(VLOOKUP(D53,$D$40:$F$47,3,TRUE))","v":262.33324008188845},{"$f":"F108","v":262.33324008188845},{"$f":"$E$108*$D$51*G108","v":0},{"$f":"H108/IF(D$51>0,D$51,1)","v":0},null,null," "]
["Ja",null,"Tillæg/fradrag i forhold til beregnet not. ved salg","pr. årsso",{"$f":"E108","v":36.299999999999997},10,{"$f":"F109","v":10},0,{"$f":"H109/IF(D$51>0,D$51,1)","v":0}]
["Ja",null,"Salg af slagtesøer","pr. årsso",{"$f":"(D61-D63)","v":0.40947530864197523},{"$f":"D59*D26","v":1811.15},{"$f":"F110*E110/E$108","v":20.430336232697343},0,0," "]
["Ja",null,"Salg af slagtepolte","pr. årsso",{"$f":"D61*(1-D62)","v":2.6473765432098784E-2},{"$f":"D25*83","v":1067.3799999999999},{"$f":"F111*E111/E$108","v":0.77844539247695865},0,0]
["Ja",null,"Sopolte udgift (Indkøbt/kostpris)","pr. årsso",{"$f":"D61/D62","v":0.55734243014944762},{"$f":"J23-IF(D64=\"Ja\",D65,0)","v":2122.5},{"$f":"-1*F112*E112/E$108","v":-32.588410688490434},0,0]
["Ja",null,"Diverse faste afgifter pr. årsso","kr./årsso",1,{"$f":"J22+SUM(E110:E111)*J20","v":74.751844907407403},{"$f":"-1*F113/E$108","v":-2.0592794740332621},0,0]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G108:G113)","v":258.89433154453906},{"$f":"SUM(H108:H113)","v":0},0]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Sofoder","Fesv/årsso",1536,{"$f":"D20+0.05","v":2.0499999999999998},{"$f":"-1*E115*F115/$E$108","v":-86.743801652892557},{"$f":"$E$108*$D$51*G115","v":0},0]
["Ja",null,"Foderudgift pattegrise","kr./fravænnet",1,5,{"$f":"-1*(E116*F116)","v":-5},0,0]
["Ja",null,"Smågrisefoder","Fesv/årsso",0,0,{"$f":"-1*E117*F117/$E$108","v":0},0,0]
["Ja",null,"Slagtesvinfoder","Fesv/årsso",0,0,0,0,0]
["Ja",null,"Grovfoder","Fesv/årsso",0,0,0,0,0]
["Ja",null,"KS udgifter","Doser/årsso",{"$f":"D56*2/0.9","v":5.0068587105624136},18,-2.4827398564772301,0,0]
["Ja",null,"Rådgivning","pr. årsso",1,0,{"$f":"-1*E121*F121/$E$108","v":0},0,{"$f":"H121/IF(D$51>0,D$51,1)","v":0}]
["Ja",null,"Medicin & vacciner","pr. årsso",1,353,-9.7245179063360894,0,0]
["Ja",null,"Diverse stykomkostninger","pr. årsso",1,222,-6.115702479338843,0,0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G115:G123)","v":-110.06676189504472},0,0]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G114+G124","v":148.82756964949434},0,0]
["Ja",null,"Arbejde","timer pr. årsso",9.1999999999999993,192,{"$f":"-1*E126*F126/$E$108","v":-48.66115702479339},0,0]
["Ja",null,"Energi","kwh/årsso",320,0.8,-7.0523415977961434,0,0]
["Ja",null,"Forsikring","kr./årsso",1,71,-1.9559228650137743,0,0]
["Ja",null,"Driftsomkostning miljøteknologi","kr./årsso",1,{"$f":"56+26","v":82},-2.2589531680440773,0,0]
["Ja",null,"Vedligehold","kr./årsso",1,{"$f":"F135*J24+F136*J25","v":262},-7.2176308539944909,0,0]
["Ja",null,"Gyllens nettoværdi pr. ton (negativ hvis indtægt)","ton/årsso",5.25,-20,2.8925619834710745,0,0]
["Ja",null,"Diverse kapacitetsomkostninger","kr./årsso",1,300,{"$f":"-1*E132*F132/$E$108","v":-8.2644628099173563},0,0]
["Ja",null,"Kontante kapacitetsomkostninger/enhed","Kr./årsso",1,null,{"$f":"SUM(G126:G132)","v":-72.517906336088174},{"$f":"$E$108*$D$51*G133","v":0},0,null,null," "]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G125+G133","v":76.309663313406162},{"$f":"H125+H133","v":0},0]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I$56","v":0.04},{"$f":"I54*I55","v":17000},{"$f":"-1*E135*F135/E$108","v":-18.732782369146008},{"$f":"$E$108*$D$51*G135","v":0},0]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I56/I57,1)/I56","v":0.08},{"$f":"I54*(1-I55)","v":7999.9999999999991},{"$f":"-1*E136*F136/E$108","v":-17.630853994490355},{"$f":"$E$108*$D$51*G136","v":0},0]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I56/I59,1)/I56","v":0.08},{"$f":"I58","v":1100},{"$f":"-1*E137*F137/E$108","v":-2.4242424242424243},{"$f":"$E$108*$D$51*G137","v":0},0]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"E135","v":0.04},{"$f":"(I68+I70+I71+I80*-1+I81*-1+SUM(I171:I175))/IF(D51>0,D51,1)","v":0},{"$f":"-1*E138*F138/E$108","v":0},{"$f":"$E$108*$D$51*G138","v":0},0]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"E135","v":0.04},{"$f":"I63","v":0},{"$f":"E139*F139/E$108","v":0},{"$f":"$E$108*$D$51*G139","v":0},0]
["Ja",null,"Afskrivninger i alt",null,null,null,{"$f":"SUM(G135:G139)","v":-38.787878787878782},{"$f":"SUM(H135:H139)","v":0},{"$f":"SUM(I135:I139)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G134+G140","v":37.52178452552738},{"$f":"H134+H140","v":0},{"$f":"I134+I140","v":0}]
["Ja",null,{"$f":"\"Renteomkostning\"","v":"Renteomkostning"},"  ",null,null,{"$f":"I142/D58","v":0},{"$f":"(SUM(F179:F239)*-1)/I56","v":0},0]
["Ja",null,"Ordinært resultat pr. enhed",null,null,null,{"$f":"G141+G142","v":37.52178452552738},{"$f":"H141+H142","v":0},{"$f":"I141+I142","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger","  ",null,null,{"$f":"H144/IF(D51>0,D51*D58,1)","v":0},{"$f":"IF(H239<0,H239*D68*5*0.5/I56,0)","v":0},{"$f":"H144/IF(D51>0,D51,1)","v":0}]
["Ja",null,"Resultat pr. enhed",null,null,null,{"$f":"G143+G144","v":37.52178452552738},{"$f":"H143+H144","v":0},{"$f":"I143+I144","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,{"$f":"D73","v":""},{"$f":"D73","v":""},{"$f":"D73","v":""}]
["Ja"]
[{"$f":"IF($D$9=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,null,null,null,"Nulpunktregulator kr./kg",null,null,-0.22587910622156018]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\"  kr./kg\"","v":"Følsomhed notering i forhold til: 11,5  kr./kg"},null,null,null,null,"Nulpunkts prognose"]
["Ja",null,"Noteringsændring kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D51>0,I148,0)","v":0}]
["Ja",null,"Salgspris fravænnede",{"$f":"D160","v":""},"","","","",""]
["Ja",null,{"$f":"C125","v":"DB pr. enhed"},"","","","","",""]
["Ja",null,"Resultat pr. enhed",{"$f":"D164","v":""},"","","","",""]
["Nej"]
["Nej",null,"Følsomhedstabel søer"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg fravænnede grise beregnet"]
["Nej",null," ","Noteringsændring i kr./kg"]
["Nej",null,{"$f":"IF(D51>0,VLOOKUP(C157,$C$107:$I$146,IF(D70=G107,5,7),FALSE)+IF(C157=C108,IF(D70=\"Kr./årsso\",I109,F109),0),\"\")","v":""},{"$f":"D150","v":-1},-0.5,0,0.5,1,{"$f":"I148","v":-0.22587910622156018}]
["Nej",null,{"$f":"C108","v":"Salg fravænnede grise beregnet inkl. kg regulering"},"","","","","",""]
["Nej",null,{"$f":"C152","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,"Resultat af primær drift","","","","","",""]
["Nej",null,{"$f":"C143","v":"Ordinært resultat pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C145","v":"Resultat pr. enhed"},"","","","","",""]
["Nej",null," "]
["Nej"]
["Nej",null,"Søer reinvesteringstabel","Halvårlig rente",{"$f":"POWER(10,LOG(D68+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse år efter start","Miljø tilladelse, omkostning ved fornyelse"]
["Nej",null,"Levetid angivet",{"$f":"I57","v":15},null,{"$f":"I59","v":12.5},null,{"$f":"I61","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING($I$56/I57,1)-1","v":1},null,{"$f":"CEILING($I$56/I59,1)-1","v":1},null,{"$f":"CEILING($I$56/I61,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C171<=D$170,D$169*$C171,\"\")","v":15},{"$f":"IF(ISNUMBER(D171),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C171<=F$170,F$169*$C171,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F171),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C171<=H$170,H$169*$C171,\"\")","v":9},{"$f":"IF(ISNUMBER(H171),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C172<=D$170,D$169*$C172,\"\")","v":""},{"$f":"IF(ISNUMBER(D172),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C172<=F$170,F$169*$C172,\"\")","v":""},{"$f":"IF(ISNUMBER(F172),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C172<=H$170,H$169*$C172,\"\")","v":18},{"$f":"IF(ISNUMBER(H172),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,3,{"$f":"IF($C173<=D$170,D$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(D173),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C173<=F$170,F$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(F173),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C173<=H$170,H$169*$C173,\"\")","v":""},{"$f":"IF(ISNUMBER(H173),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,4,{"$f":"IF($C174<=D$170,D$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(D174),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C174<=F$170,F$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(F174),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C174<=H$170,H$169*$C174,\"\")","v":""},{"$f":"IF(ISNUMBER(H174),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,5,{"$f":"IF($C175<=D$170,D$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(D175),(1-$I$55)*$I$54*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C175<=F$170,F$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(F175),$I$58*$D$51,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C175<=H$170,H$169*$C175,\"\")","v":""},{"$f":"IF(ISNUMBER(H175),$I$62*$D$51,0)*IF(D$51>0,1,0)","v":0}]
["ja"]
[{"$f":"IF($D$12=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow søer"]
[{"$f":"IF($D$12=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}," ","Terminer i halvår","Investerings-summer","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato",null,null,null," "]
["Ja",{"$f":"IF(J179>=0,0,J179)","v":0},0,{"$f":"I77*-1","v":0},0,0,0,{"$f":"D179","v":0},{"$f":"D179+E179","v":0},{"$f":"(H179+IF(C179<$I$56,$I$83,0))/1000","v":0},{"$f":"DATE(YEAR(D32),IF(MONTH(D32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J180>=0,0,J180)","v":0},{"$f":"IF(AND(C179<>FALSE,C179+0.5<=$I$56),C179+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C180,$D$171:$E$175,2,FALSE)),0,VLOOKUP(C180,$D$171:$E$175,2,FALSE))+IF(ISNA(VLOOKUP(C180,$F$171:$G$175,2,FALSE)),0,VLOOKUP(C180,$F$171:$G$175,2,FALSE))+IF(ISNA(VLOOKUP(C180,$H$171:$I$175,2,FALSE)),0,VLOOKUP(C180,$H$171:$I$175,2,FALSE)))*-1+IF(C180=$I$56,$I$83,0)","v":0},{"$f":"IF(C180<=$I$56,H$134*0.5,0)","v":0},{"$f":"IF(C180<=$I$56,IF(H179<0,H179*$E$167*-1,0),0)","v":0},{"$f":"IF(H179>=0,0,IF(E180-F180>H179*-1,H179*-1,E180-F180))","v":0},{"$f":"H179+D180+G180","v":0},{"$f":"D180+E180","v":0},0,{"$f":"IF(MONTH(K179)+6>12,DATE(YEAR(K179)+1,MONTH(K179)+6-12,1),DATE(YEAR(K179),MONTH(K179)+6,1))","v":"2024-01-01"}]
["Ja",0,1,0,0,0,0,0,{"$f":"D181+E181","v":0},0,{"$f":"IF(MONTH(K180)+6>12,DATE(YEAR(K180)+1,MONTH(K180)+6-12,1),DATE(YEAR(K180),MONTH(K180)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,0,"2039-07-01"]
["Ja",0,16.5,0,0,0,0,0,0,0,"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
[{"$f":"IF($D$12=\"Ja\",\"Nej\",\"Nej\")","v":"Nej"}]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Smågrise rentabilitet"]
["Ja",null,"Smågrisestipladser ekskl. sygestier",{"$f":"0*36.3*1200/6.5","v":0},null,"Investeringsbeløb"]
["Ja",null,"Produktionsoplysninger",null,null,"Stipladspris inkl. sygestier kr./stiplads",null,null,2320]
["Ja",null,"Indsættelsesvægt (default frav. Vægt)",{"$f":"D53","v":6.5},null,"Bygningsandel af investeringsbeløb",null,null,0.72]
["Ja",null,"Opholdstid i uger",8," ","Levetid bygninger, år",null,null,25]
["Ja",null,"Omsætningshastighed pr. stiplads",{"$f":"365/(D246*7)","v":6.5178571428571432},null,"Levetid inventar, år",null,null,15]
["Ja",null,"Smågrisedødelighed",0.03," ","Miljøinvestering, kr./stiplads",null,null,0]
["Ja",null,"Årligt solgte grise",{"$f":"(D243*365/(D246*7))*(1-D248)","v":0}," ","Forventet levetid miljøteknologi,  år",null,null,12.5]
["Ja",null,"Salgsvægt",30,null,"Miljøtilladelse kr./stiplads",null,null,{"$f":"IF(D243>0,5,0)","v":0}]
["Ja",null,"Fesv pr. kg tilvækst",1.72," ","Levetid miljøansøgning, år",null,null,9]
["Ja",null,"Indkøringstab % af fyldt stald",0.5,null,"Fornyet miljøansøgning kr./stiplads",null,null,{"$f":"I250*0.5","v":0}]
["Ja",null,"Producerede smågrise per solgt",{"$f":"1/(1-D248/2)","v":1.015228426395939},null,"Tilskud kr./stiplads",null,null,0]
["Ja"]
["Ja"]
["Ja",null,"Wacc overført pa.",{"$f":"$D$30","v":5.74E-2},null,"Sum startinvestering"]
["Ja",null,null,null,null,"Investering bygninger",null,null,{"$f":"I244*I245*D243","v":0}]
["Ja",null,"Investerings nøgletal",null,null,"Investering inventar",null,null,{"$f":"I244*(1-I245)*D243","v":0}]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D243>0,XIRR(I363:I423,K363:K423,5%),\"\")","v":""},null,"Renteomkostning byggeri",null,null,{"$f":"(I257*0.33+I258*0.25)*D31","v":0}]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D243>0,D259-D256,\"\")","v":""},null,"Miljøteknologi",null,null,{"$f":"I248*D243","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D243>0,IF(MAX(J363:J423)>0,VLOOKUP(0,B363:C423,2,FALSE)+IF(VLOOKUP(0,B363:C423,2,FALSE)<I246,0.5),\"Aldrig\"),\"\")","v":""},null,"Miljøansøgning",null,null,{"$f":"I250*D243","v":0}]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D243>0,I334*-1,\"\")","v":""},null,"Indkøringstab",null,null,{"$f":"G309*D252*D249*(D246*7/365)","v":0},null,null," "]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D243>0,D21-D262,\"\")","v":""},null,"Tilskud",null,null,{"$f":"D243*I253*-1","v":0}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D243>0,XNPV(D256,I363:I423,K363:K423)/1000,\"\")","v":""},null,"Lange aktiver i alt",null,null,{"$f":"SUM(I257:I263)","v":0}]
["Ja",null,null,null,null,"Anskaffelsessum besætning",null,null,{"$f":"D243*SUM(F298:F300)","v":0}]
["Ja",null,"Nulpunktspriser","Kr./smågris",null,"Værditilvækst besætning",null,null,{"$f":"IF(D243>0,(G308+G317)*D243*0.5*-1,0)","v":0}]
["Ja",null,"Salgspris",{"$f":"IF(D243>0,I335,\"\")","v":""},null,"Korte aktiver i alt",null,null,{"$f":"SUM(I265:I266)","v":0}]
["Ja",null,"Indkøbspris",{"$f":"IF(D243>0,I336,\"\")","v":""},null,"Bunden Investering ",null,null,{"$f":"I264+I267","v":0}]
["Ja",null,"DB pr. enhed",{"$f":"IF(D243>0,I337,\"\")","v":""}]
["Ja",null,"Resultat pr. enhed",{"$f":"I338","v":""},null,"Beløb ved investeringens ophør"]
["Ja",null,null,null,null,"Afviklingstab",null,null,{"$f":"I262*-1*IF(D252>50%,50%/D252,1)","v":0}]
["Ja",null,null,null,null,"Besætningseliminering",null,null,{"$f":"I265+I266","v":0}]
["Ja",null,null,null,null,"I alt ",null,null,{"$f":"SUM(I271:I272)","v":0}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null," "]
["Ja",null,"Smågrise rentabilitetskalkule","Start enhed","Enheder","Enhedsværdi","kr./solgt smågris","kr. årligt"]
["Ja",null,{"$f":"\"Salg af smågrise beregnet \" &ROUND(D250,1)&\" kg\"","v":"Salg af smågrise beregnet 30 kg"},"pr./solgt",1,{"$f":"VLOOKUP(D250,$D$40:$H$47,5,TRUE)-(VLOOKUP(D250,$D$40:$F$47,2,TRUE)-D250)*(VLOOKUP(D250,$D$40:$F$47,3,TRUE))","v":465.6165959999999},{"$f":"E296*F296","v":465.6165959999999},{"$f":"G296*$D$249","v":0}]
["Ja",null,"Tillæg/fradrag beregnet not. ved salg",null,1,{"$f":"F109","v":10},{"$f":"E297*F297","v":10},{"$f":"G297*$D$249","v":0}]
["Ja",null,{"$f":"\"Køb af smågrise ved  \"& ROUND(D245,1)& \" kg\"","v":"Køb af smågrise ved  6,5 kg"},"pr./solgt",{"$f":"1/(1-D248)","v":1.0309278350515465},{"$f":"VLOOKUP(D245,$D$40:$H$47,5,TRUE)-(VLOOKUP(D245,$D$40:$F$47,2,TRUE)-D245)*(VLOOKUP(D245,$D$40:$F$47,3,TRUE))","v":262.33324008188845},{"$f":"E298*F298*-1","v":-270.44663925967882},{"$f":"G298*$D$249","v":0}]
["Ja",null,"Tillæg/fradrag beregnet not. ved køb","pr. indkøbt",{"$f":"1/(1-D248)","v":1.0309278350515465},{"$f":"F109","v":10},{"$f":"E299*F299*-1","v":-10.309278350515465},{"$f":"G299*$D$249","v":0}]
["Ja",null,"Transport smågrise","pr. indkøbt",{"$f":"1/(1-D248)","v":1.0309278350515465},0,{"$f":"E300*F300*-1","v":0},{"$f":"G300*$D$249","v":0}]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G296:G300)","v":194.86067838980563},{"$f":"SUM(H296:H300)","v":0}]
["Ja",null,"Smågriseblanding 1","pr. produceret",8,{"$f":"D20+2.43","v":4.43},{"$f":"(E302*F302)*-1*D$253","v":-35.979695431472074},{"$f":"G302*$D$249","v":0}]
["Ja",null,"Smågriseblanding 2 (residual)","pr. produceret",{"$f":"(D250-D245)*D251-E302","v":32.42},{"$f":"D20+0.28","v":2.2800000000000002},{"$f":"(E303*F303)*-1*D$253","v":-75.043248730964464},0]
["Ja",null,"Grovfoder","pr. produceret",0,0,0,0]
["Ja",null,"Rådgivning","pr. produceret",{"$f":"D$253","v":1.015228426395939},1,{"$f":"E305*F305*-1","v":-1.015228426395939},0]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Medicin & vacciner","pr. produceret",{"$f":"D$253","v":1.015228426395939},3.63,{"$f":"E306*F306*-1","v":-3.6852791878172586},0]
["Ja",null,"Diverse stykomkostninger","pr. produceret",1.015228426395939,3,{"$f":"E307*F307*-1","v":-3.0456852791878171},0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G302:G307)","v":-118.76913705583756},0]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G301+G308","v":76.091541333968067},{"$f":"H301+H308","v":0}]
["Ja",null,"Arbejde","min./smågris prod.",5,{"$f":"192/60","v":3.2},{"$f":"IF($D$243>0,H310/$D$249,1)","v":1},{"$f":"E310*F310*D$249*D$253*-1","v":0},null,null,null," "]
["Ja",null,"Energi","kWh/smågris prod.",12,0.8,{"$f":"IF($D$243>0,H311/$D$249,1)","v":1},{"$f":"E311*F311*D$249*D$253*-1","v":0},null,null,null," "]
["Ja",null,"Forsikring","pr. produceret",{"$f":"D$253","v":1.015228426395939},1,1,{"$f":"E312*F312*D$249*D$253*-1","v":0}]
["Ja",null,"Driftsomkostning miljøteknologi","pr. produceret",{"$f":"D$253","v":1.015228426395939},2,1,{"$f":"E313*F313*D$249*D$253*-1","v":0}]
["Ja",null,"Vedligehold","pr. produceret",1.015228426395939,{"$f":"-1*G314/E314","v":-0.9850000000000001},1,{"$f":"(F319*J24+F320*J25)*D243*-1","v":0},null," "]
["Ja",null,"Gyllens nettoværdi pr. ton (negativ hvis indtægt)","Tons/produceret",{"$f":"SUM(E302:E303)*2.7/1000","v":0.10913400000000001},-20,1,{"$f":"E315*F315*D$249*D$253*-1","v":0},null,null," "]
["Ja",null,"Diverse kapacitetsomkostninger","pr. produceret",{"$f":"D$253","v":1.015228426395939},2.25,1,{"$f":"E316*F316*D$249*D$253*-1","v":0}]
["Ja",null,"Kontante kapacitetsomkostning i alt enhed",null,null,null,{"$f":"SUM(G310:G316)","v":7},{"$f":"SUM(H310:H316)","v":0}]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G309+G317","v":83.091541333968067},{"$f":"H309+H317","v":0}]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"I244*I245","v":1670.3999999999999},{"$f":"E319*F319*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E319*F319*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I246/I247,1)/I246","v":0.08},{"$f":"(1-I245)*I244","v":649.6},{"$f":"E320*F320*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E320*F320*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I246/I249,1)/I246","v":0.08},{"$f":"I248","v":0},{"$f":"E321*F321*$D$243/IF($D$249>0,$D$249,1)*-1","v":0},{"$f":"E321*F321*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"-1*G322/E322","v":0},{"$f":"IF(D243>0,H322/D249,0)","v":0},{"$f":"(I259+I261+I262+I271+SUM(I354:I358))*-1/I246","v":0}]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"1/I246","v":0.04},{"$f":"I253","v":0},{"$f":"H323/IF(D243>0,D249,1)","v":0},{"$f":"E323*F323*$D$243*-1","v":0}]
["Ja",null,"Afskrivninger  i alt",null,null,null,{"$f":"SUM(G319:G323)","v":0},{"$f":"SUM(H319:H323)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G318+G324","v":83.091541333968067},{"$f":"H318+H324","v":0}]
["Ja",null,"Renteomkostning ",null,null,null,{"$f":"IF(D243>0,H326/D249,0)","v":0},{"$f":"-1*SUM(F363:F423)/I246","v":0}]
["Ja",null,"Ordinært resultat/enhed",null,null,null,{"$f":"G325+G326","v":83.091541333968067},{"$f":"H325+H326","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger",null,null,null,{"$f":"IF(D243>0,H328/D249,0)","v":0},{"$f":"IF(H423<0,H423*D256*0.5*5/I246,0)","v":0}]
["Ja",null,"Resultat/enhed",null,null,null,{"$f":"G327+G328","v":83.091541333968067},{"$f":"H327+H328","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,{"$f":"D259","v":""},{"$f":"D259","v":""}]
["Ja",null,null,null,null,null,null,null," "]
[{"$f":"IF($D$10=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,null,null,null,"Nulpunktregulator kr./kg (målsøgning)",null,null,-0.66217135194203758]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\" kr./kg\"","v":"Følsomhed notering i forhold til: 11,5 kr./kg"},null,null,null,null,"Nulpunkt prognose"]
["Ja",null,"Noteringsændring +/- kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D243>0,I332,\"\")","v":""}]
["Ja",null,"Salgspris smågrise",{"$f":"D344","v":""},"","","","",""]
["Ja",null,{"$f":"C345","v":"Køb af smågrise ved  6,5 kg"},"","","","","",""]
["Ja",null,{"$f":"C346","v":"DB pr. enhed"},"","","","","",""]
["Ja",null,{"$f":"C348","v":"Resultat/enhed"},{"$f":"D348","v":""},"","","","",""]
["Ja"]
["Nej",null,"Følsomhedstabel smågrise"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg af smågrise beregnet 30 kg"]
["Nej",null,{"$f":"IF(D243>0,VLOOKUP(C342,C296:G330,5,FALSE)+IF(C342=C296,F297,0)+IF(C342=C298,F299,0),\"\")","v":""},{"$f":"D334","v":-1},-0.5,0,0.5,1,{"$f":"I332","v":-0.66217135194203758}]
["Nej",null,{"$f":"C296","v":"Salg af smågrise beregnet 30 kg"},"","","","","",""]
["Nej",null,{"$f":"C298","v":"Køb af smågrise ved  6,5 kg"},"","","","","",""]
["Nej",null,{"$f":"C309","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C327","v":"Ordinært resultat/enhed"},"","","","","",""]
["Nej",null,{"$f":"C329","v":"Resultat/enhed"},"","","","","",""]
["Nej"]
["Nej",null,"Investeringer smågrise","Halvårlig rente",{"$f":"POWER(10,LOG(D256+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse  år efter start","Miljøtilladelse omkostning ved fornyelse"]
["Nej",null,"Levetid angivet år",{"$f":"I247","v":15},null,{"$f":"I249","v":12.5},null,{"$f":"I251","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING(I246/D352,1)-1","v":1},null,{"$f":"CEILING($I$246/F352,1)-1","v":1},null,{"$f":"CEILING($I$246/H352,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C354<=D$353,D$352*$C354,\"\")","v":15},{"$f":"IF(ISNUMBER(D354),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},{"$f":"IF($C354<=F$353,F$352*$C354,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F354),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},{"$f":"IF($C354<=H$353,H$352*$C354,\"\")","v":9},{"$f":"IF(ISNUMBER(H354),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C355<=D$353,D$352*$C355,\"\")","v":""},{"$f":"IF(ISNUMBER(D355),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F355),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},18,{"$f":"IF(ISNUMBER(H355),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,3,"",{"$f":"IF(ISNUMBER(D356),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F356),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H356),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,4,"",{"$f":"IF(ISNUMBER(D357),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F357),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H357),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej",null,5,"",{"$f":"IF(ISNUMBER(D358),(1-$I$245)*$I$244*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F358),$I$248*$D$243,0)*IF(D$243>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H358),$I$252*$D$243,0)*IF(D$243>0,1,0)","v":0}]
["Nej"]
[{"$f":"IF($D$13=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$13=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow smågrise"]
["Ja",null,"Terminer i halvår","Investerings-summer","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato"]
["Ja",{"$f":"IF(J363>=0,0,J363)","v":0},0,{"$f":"I268*-1","v":0},0,0,0,{"$f":"D363","v":0},{"$f":"D363+E363","v":0},{"$f":"(D363+IF(C363<$I$246,$I$273,0))/1000","v":0},{"$f":"DATE(YEAR($D$32),IF(MONTH($D$32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J364>=0,0,J364)","v":0},{"$f":"IF(AND(C363<>FALSE,C363+0.5<=$I$246),C363+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C364,$D$354:$E$358,2,FALSE)),0,VLOOKUP(C364,$D$354:$E$359,2,FALSE))+IF(ISNA(VLOOKUP(C364,$F$354:$G$358,2,FALSE)),0,VLOOKUP(C364,$F$354:$G$358,2,FALSE))+IF(ISNA(VLOOKUP(C364,$H$354:$I$358,2,FALSE)),0,VLOOKUP(C364,$H$354:$I$358,2,FALSE)))*-1+IF(C364=$I$246,$I$273,0)","v":0},{"$f":"IF(C364<=$I$246,$H$318*0.5,0)","v":0},{"$f":"IF(C364<=$I$246,IF(H363<0,H363*$E$350*-1,0),0)","v":0},{"$f":"IF(H363>=0,0,IF(E364-F364>H363*-1,H363*-1,E364-F364))","v":0},{"$f":"H363+D364+G364","v":0},{"$f":"D364+E364","v":0},{"$f":"(H364+IF(C364<$I$246,$I$273,0))/1000","v":0},{"$f":"IF(MONTH(K363)+6>12,DATE(YEAR(K363)+1,MONTH(K363)+6-12,1),DATE(YEAR(K363),MONTH(K363)+6,1))","v":"2024-01-01"}]
["Ja",0,{"$f":"IF(AND(C364<>FALSE,C364+0.5<=$I$246),C364+0.5)","v":1},0,0,0,0,0,{"$f":"D365+E365","v":0},0,{"$f":"IF(MONTH(K364)+6>12,DATE(YEAR(K364)+1,MONTH(K364)+6-12,1),DATE(YEAR(K364),MONTH(K364)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,0,"2039-07-01"]
["Ja",0,16.5,0,0,0,0,0,0,0,"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
["Ja"]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Rentabilitets analyse slagtesvin"]
[{"$f":"IF($D$11=\"Ja\",\"Nej\",\"Nej\")","v":"Nej"}]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Slagtesvine stipladser ekskl. sygestier",{"$f":"0*5057","v":0},null,"Investeringsbeløb"]
["Ja",null,null,null,null,"Stipladspris inkl. sygestier kr./stiplads",null,null,4400]
["Ja",null,"Indsættelsesvægt",30,null,"Bygningsandel af investeringsbeløb",null,null,0.72," "]
["Ja",null,"Slagtevægt",89,null,"Levetid bygninger, år",null,null,25," "]
["Ja",null,"Beregnet levendevægt E-kontrol",{"$f":"D430*1.31","v":116.59},null,"Levetid inventar, år",null,null,15," "]
["Ja",null,"Opholdstid i uger",13,null,"Miljøinvestering, kr./stiplads",null,null,275," "]
["Ja",null,"Omsætningshastighed pr. stiplads",{"$f":"365/(D432*7)","v":4.0109890109890109},null,"Forventet levetid miljøteknologi,  år",null,null,12.5," "]
["Ja",null,"Slagtesvine dødelighed",2.4E-2,null,"Miljøtilladelse kr./stiplads",null,null,{"$f":"39","v":39}]
["Ja",null,"Kasserede slagtesvin",1E-3,null,"Levetid miljøansøgning, år",null,null,9," "]
["Ja",null,"Årligt solgte slagtesvin",{"$f":"D427*D433*(1-D434-D435)","v":0},null,"Fornyet miljøansøgning kr./stiplads",null,null,{"$f":"I434*0.5","v":19.5}]
["Ja",null,"Fesv pr. kg tilvækst",2.6," ","Tilskud kr./stiplads",null,null,0]
["Ja",null,"Indkøringstab i % af fyldt stald",0.5]
["Ja",null,"Producerede slagtesvin per solgt",{"$f":"1/(1-D435-D434/2)","v":1.0131712259371835}]
["Ja",null,"Overført notering kr./kg",{"$f":"D25-D22","v":11.5},"kr./kg","Sum startinvestering"]
["Ja",null,"Vægtregulering",-0.08,"kr./kg","Investering bygninger",null,null,{"$f":"I428*I429*D427","v":0},null,null," "]
["Ja",null,"Specialgrisetillæg",0,"kr./kg","Investering inventar",null,null,{"$f":"I428*(1-I429)*D427","v":0}]
["Ja",null,"Kødprocent",0.09,"kr./kg","Renteomkostning byggeri",null,null,{"$f":"(I441*0.33+I442*0.25)*D31","v":0}]
["Ja",null,"Sygdomsfradrag",{"$f":"-0.01","v":-0.01},"kr./kg","Miljøteknologi",null,null,{"$f":"I432*D427","v":0}]
["Ja",null,"Indtransport fratrukket indberetningsbonus",{"$f":"-0.05+0.1+0.01","v":6.0000000000000005E-2},"kr./kg","Miljøansøgning",null,null,{"$f":"I434*D427","v":0}]
["Ja",null,"DB garantier eller byggebonus, NPV sandsynlighed",0.05,"kr./kg","Indkøringstab",null,null,{"$f":"(D432*D438*7/365)*H501","v":0},null,null," "]
["Ja",null,"Mængdetillæg",0.05,"kr./kg","Tilskud",null,null,{"$f":"I437*D427*-1","v":0}]
["Ja",null,"Efterbetaling eller anden bonus i NPV",1.3,"kr./kg","Lange aktiver i alt",null,null,{"$f":"SUM(I441:I447)","v":0}]
["Ja",null,"Produktionsafgift pr. kg",{"$f":"-J21/D430","v":-6.1797752808988762E-2},"kr./kg","Anskaffelsessum besætning",null,null,{"$f":"D427*SUM(F490:F492)","v":0}]
["Ja",null,"Projektets afregningspris",{"$f":"SUM(D440:D449)","v":12.898202247191014},"kr./kg","Værditilvækst besætning",null,null,{"$f":"(G500+G509)*D427*0.5*-1","v":0}]
["Ja",null,null,null,null,"Korte aktiver i alt",null,null,{"$f":"SUM(I449:I450)","v":0}]
["Ja",null,"Wacc overført pa",{"$f":"$D$30","v":5.74E-2},null,"Bunden Investering ",null,null,{"$f":"I448+I451","v":0}]
["Ja"]
["Ja",null,"Investeringens nøgletal"]
["Ja",null,"Projektets afkastningsgrad (AG = Intern rente)",{"$f":"IF(D427>0,XIRR(I558:I618,K558:K618,5%),\"\")","v":""},null,"Beløb ved investeringens ophør"]
["Ja",null,"Økonomisk værdi tilføjet (EVA= AG-WACC), %",{"$f":"IF(D427>0,D455-D452,\"\")","v":""},null,"Afviklingstab",null,null,{"$f":"I446*-1*IF(D438>50%,50%/D438,1)","v":0}]
["Ja",null,"Tilbagebetalingstid, år",{"$f":"IF(D427>0,IF(MAX(J558:J618)>0,VLOOKUP(0,B558:C618,2,FALSE)+IF(VLOOKUP(0,B558:C618,2,FALSE)<I430,0.5),\"Aldrig\"),\"\")","v":""},null,"Besætning",null,null,{"$f":"I451","v":0}]
["Ja",null,"Sikkerhedsmargin noteringsændring, kr./kg",{"$f":"IF(D427>0,I527*-1,\"\")","v":""},null,"I alt ",null,null,{"$f":"SUM(I456:I457)","v":0}]
["Ja",null,"Projektets nulpunktsnotering. kr./kg",{"$f":"IF(D427>0,D21-D458,\"\")","v":""}]
["Ja",null,"Projektets kapitalværdi i 1000 kr.",{"$f":"IF(D427>0,XNPV(D452,I558:I618,K558:K618)/1000,\"\")","v":""}]
["Ja"]
["Ja",null,"Nulpunktspriser","Kr./slagtesvin"]
["Ja",null,"Salgspris",{"$f":"IF(D427>0,I529,\"\")","v":""}]
["Ja",null,"Indkøbspris",{"$f":"IF(D427>0,I530,\"\")","v":""}]
["Ja",null,"DB pr. enhed",{"$f":"IF(D427>0,I531,\"\")","v":""}]
["Ja",null,"Resultat pr. enhed",{"$f":"I532","v":""}]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja"]
["Ja",null," "]
["Ja",null,"Slagtesvin rentabilitetskalkule","Start enhed","Enheder","Enheds-værdi","kr./solgt slagtesvin","Kr. årligt"]
["Ja",null,{"$f":"\"Salg af slagtesvin ved \" & ROUND(D430,1)& \" kg slagtet\"","v":"Salg af slagtesvin ved 89 kg slagtet"},"Slagtevægt i kg",{"$f":"D430","v":89},{"$f":"D450","v":12.898202247191014},{"$f":"E489*F489","v":1147.9400000000003},{"$f":"D$436*G489","v":0}]
["Ja",null,{"$f":"\"Køb af smågrise ved \"&ROUND(D429,1)& \" kg pris beregnet not.\"","v":"Køb af smågrise ved 30 kg pris beregnet not."},"pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},{"$f":"VLOOKUP(D429,$D$40:$H$47,5,TRUE)-(VLOOKUP(D429,$D$40:$F$47,2,TRUE)-D429)*(VLOOKUP(D429,$D$40:$F$47,3,TRUE))","v":465.6165959999999},{"$f":"E490*F490*-1","v":-477.55548307692305},{"$f":"D$436*G490","v":0},null,null," "]
[{"$f":"IF($D$11=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Tillæg/fradrag","pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},{"$f":"F109","v":10},{"$f":"E491*F491*-1","v":-10.256410256410257},{"$f":"D$436*G491","v":0}]
["Ja",null,"Transport","pr. købt",{"$f":"1/(1-SUM($D$434:$D$435))","v":1.0256410256410258},9,{"$f":"E492*F492*-1","v":-9.2307692307692317},{"$f":"D$436*G492","v":0},null,null," "]
["Ja",null,"Bruttoudbytte pr. enhed",null,null,null,{"$f":"SUM(G489:G492)","v":650.89733743589761},{"$f":"SUM(H489:H492)","v":0}]
["Ja",null,"Slagtesvineblanding 1","FEsv/produceret",0,{"$f":"D20","v":2},{"$f":"E494*F494*(1+$D$434/2+$D$435)*-1","v":0},{"$f":"D$436*G494","v":0}]
["Ja",null,"Slagtesvineblanding 2 (residual)","FEsv/produceret",{"$f":"D437*(D431-D429)-E494","v":225.13400000000001},{"$f":"D20","v":2},{"$f":"E495*F495*(1+$D$434/2+$D$435)*-1","v":-456.12148400000001},0]
["Ja",null,"Grovfoder","pr. produceret",0,0,{"$f":"E496*F496*-1","v":0},0]
["Ja",null,"Rådgivning","pr. produceret",{"$f":"D$439","v":1.0131712259371835},1,{"$f":"E497*F497*-1","v":-1.0131712259371835},0,null,null," "]
["Ja",null,"Medicin & vacciner","pr. produceret",{"$f":"D$439","v":1.0131712259371835},4,{"$f":"E498*F498*-1","v":-4.0526849037487338},0]
["Ja",null,"Diverse stykomkostninger","pr. produceret",{"$f":"D$439","v":1.0131712259371835},6,{"$f":"E499*F499*-1","v":-6.0790273556231007},0]
["Ja",null,"Stykomkostninger i alt",null,null,null,{"$f":"SUM(G494:G499)","v":-467.26636748530905},{"$f":"SUM(H494:H499)","v":0}]
["Ja",null,"DB pr. enhed",null,null,null,{"$f":"G493+G500","v":183.63096995058856},{"$f":"H493+H500","v":0}]
["Ja",null,"Arbejde, min./slagtesvin","min./produceret",11,{"$f":"192/60","v":3.2},{"$f":"E502*F502*-1*D$439","v":-35.663627152988859},{"$f":"D$436*G502","v":0}]
["Ja",null,"Energi","kWh/produceret",14,0.8,{"$f":"E503*F503*-1*D$439","v":-11.347517730496456},0]
["Ja",null,"Forsikring","pr. produceret",{"$f":"D$439","v":1.0131712259371835},4,{"$f":"E504*F504*-1","v":-4.0526849037487338},0]
["Ja",null,"Driftsomkostning miljøteknologi","pr. produceret",{"$f":"D$439","v":1.0131712259371835},{"$f":"3.5+1.4","v":4.9000000000000004},{"$f":"E505*F505*-1","v":-4.9645390070921991},0]
["Ja",null,"Vedligehold","pr. produceret",{"$f":"D$439","v":1.0131712259371835},{"$f":"-1*G506/E506","v":0},{"$f":"IF(D427>0,H506/D436,0)","v":0},{"$f":"(F511*J24+F512*J25)*D427*-1","v":0}]
["Ja",null,"Gyllens nettoværdi","Tons/produceret",{"$f":"SUM(E494:E495)*2.3/1000","v":0.51780819999999994},-20,{"$f":"E507*F507*-1*D$439","v":10.492567375886525},{"$f":"D$436*G507*-1","v":0}]
["Ja",null,"Diverse kapacitetsomkostninger","pr. produceret",{"$f":"D$439","v":1.0131712259371835},8,{"$f":"E508*F508*-1","v":-8.1053698074974676},0]
["Ja",null,"Kontante kapacitetsomkostning pr. enhed",null,null,null,{"$f":"SUM(G502:G508)","v":-53.641171225937192},0]
["Ja",null,"EBID resultat",null,null,null,{"$f":"G501+G509","v":129.98979872465137},{"$f":"H501+H509","v":0}]
["Ja",null,"Afskrivninger bygninger","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"I428*I429","v":3168},{"$f":"IF(D$427>0,H511/D$436,0)","v":0},{"$f":"E511*F511*D$427*-1","v":0}]
["Ja",null,"Afskrivninger inventar","% årligt/stiplads",{"$f":"CEILING(I430/I431,1)/I430","v":0.08},{"$f":"(1-I429)*I428","v":1232.0000000000002},{"$f":"IF(D$427>0,H512/D$436,0)","v":0},{"$f":"E512*F512*D$427*-1","v":0}," "]
["Ja",null,"Afskrivninger miljøteknologi","% årligt/stiplads",{"$f":"CEILING(I430/I433,1)/I430","v":0.08},{"$f":"I432","v":275},{"$f":"IF(D$427>0,H513/D$436,0)","v":0},{"$f":"E513*F513*D$427*-1","v":0}]
["Ja",null,"Afskrivninger diverse","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"H514/E514/IF(D427>0,D427,1)*-1","v":0},{"$f":"IF(D$427>0,H514/D$436,0)","v":0},{"$f":"(I443+I445+I446*2+SUM(I549:I553))*-1/I430","v":0},null,null,null,null,null,null,null," "]
["Ja",null,"Korrektion afskrivninger pga. tilskud","% årligt/stiplads",{"$f":"1/I430","v":0.04},{"$f":"(H515/E515)/IF(D427>0,D427,1)","v":0},{"$f":"H515/IF(D427>0,D436,1)","v":0},{"$f":"E515*I447*-1","v":0}]
["Ja",null,"Afskrivninger  i  alt",null,null,null,{"$f":"SUM(G511:G515)","v":0},{"$f":"SUM(H511:H515)","v":0}]
["Ja",null,"Resultat af primær drift",null,null,null,{"$f":"G510+G516","v":129.98979872465137},{"$f":"H510+H516","v":0}]
["Ja",null,"Renteomkostning ",null,null,null,{"$f":"IF(D427>0,H518/D436,0)","v":0},{"$f":"(SUM(F558:F618)/I430)*-1","v":0}]
["Ja",null,"Ordinært resultat/enhed",null,null,null,{"$f":"G517+G518","v":129.98979872465137},{"$f":"H517+H518","v":0}]
["Ja",null,"Ekstra ordinære renteomkostninger",null,null,null,{"$f":"IF(D427>0,H520/D436,0)","v":0},{"$f":"IF(H618<0,H618*5*0.5*D452/I430,0)","v":0}]
["Ja",null,"Resultat/enhed",null,null,null,{"$f":"G519+G520","v":129.98979872465137},{"$f":"H519+H520","v":0}]
["Ja",null,"Projektets afkastningsgrad",null,null,null,null,{"$f":"D455","v":""}]
["Ja"]
["Ja"]
["Ja",null,null,null,null,"Nulpunktregulator kr./kg",null,null,-0.20676033524701162]
["Ja",null,null,{"$f":"\"Følsomhed notering i forhold til: \"&D$21&\" kr./kg\"","v":"Følsomhed notering i forhold til: 11,5 kr./kg"},null,null,null,null,"Nulpunkt prognose"]
["Ja",null,"Noteringsændring +/- kr./kg",{"$f":"2*$D$28*-1","v":-1},{"$f":"1*$D$28*-1","v":-0.5},0,{"$f":"1*$D$28","v":0.5},{"$f":"2*$D$28","v":1},{"$f":"IF(D427>0,I525,\"\")","v":""}]
["Ja",null,"Afregningspris i kr./kg",{"$f":"$F528+D527","v":11.898202247191014},{"$f":"$F528+E527","v":12.398202247191014},{"$f":"$D$450+F527","v":12.898202247191014},{"$f":"$D$450+G527","v":13.398202247191014},{"$f":"$D$450+H527","v":13.898202247191014},{"$f":"$D$450+I527","v":{"$error":"#VALUE!"}}]
["Ja",null,{"$f":"C538","v":"Salg af slagtesvin ved 89 kg slagtet"},{"$f":"D538","v":""},"","","","",""]
["Ja",null,"Smågrise købspris","","","","","",""]
["Ja",null,{"$f":"C540","v":"DB pr. enhed"},"","","","","",""]
["Ja",null,{"$f":"C542","v":"Resultat/enhed"},{"$f":"D542","v":""},"","","","",""]
["Ja"]
["Nej",null,"Følsomhedstabel slagtesvin"]
["Nej",null,"Valgt enhed"]
["Nej",null,"Salg af slagtesvin ved 85 kg slagtet","Noteringsændring kr./kg"]
["Nej",null,{"$f":"IF(D427>0,VLOOKUP(C536,C488:G522,5,FALSE)+IF(C536=C490,F491+F492,0),\"\")","v":""},{"$f":"D527","v":-1},-0.5,0,0.5,1,{"$f":"I525","v":-0.20676033524701162}]
["Nej",null,{"$f":"C489","v":"Salg af slagtesvin ved 89 kg slagtet"},"","","","","",""]
["Nej",null,{"$f":"C490","v":"Køb af smågrise ved 30 kg pris beregnet not."},"","","","","",""]
["Nej",null,{"$f":"C501","v":"DB pr. enhed"},"","","","","",""]
["Nej",null,{"$f":"C519","v":"Ordinært resultat/enhed"},"","","","","",""]
["Nej",null,{"$f":"C521","v":"Resultat/enhed"},"","","","","",""]
["Nej"]
["Nej",null," "]
["Nej",null,"Investeringer slagtesvin","Halvårlig rente",{"$f":"POWER(10,LOG(D452+1)/2)-1","v":2.8299567246821367E-2}]
["Nej",null,"Forventede reinvesteringer i projektet levetid","Inventar fornyelse år efter start","Inventar  investering år efter start","Miljøteknologi fornyelse år efter start","Miljøteknoloi investering år efter start","Miljø tilladelse  år efter start","Miljøtilladelse omkostning ved fornyelse"]
["Nej",null,"Levetid angivet",{"$f":"I431","v":15},null,{"$f":"I433","v":12.5},null,{"$f":"I435","v":9}]
["Nej",null,"Fornyet investering antal gange",{"$f":"CEILING($I$430/D547,1)-1","v":1},null,{"$f":"CEILING($I$430/F547,1)-1","v":1},null,{"$f":"CEILING($I$430/H547,1)-1","v":2}]
["Nej",null,1,{"$f":"IF($C549<=D$548,D$547*$C549,\"\")","v":15},{"$f":"IF(ISNUMBER(D549),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},{"$f":"IF($C549<=F$548,F$547*$C549,\"\")","v":12.5},{"$f":"IF(ISNUMBER(F549),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},{"$f":"IF($C549<=H$548,H$547*$C549,\"\")","v":9},{"$f":"IF(ISNUMBER(H549),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,2,{"$f":"IF($C550<=D$548,D$547*$C550,\"\")","v":""},{"$f":"IF(ISNUMBER(D550),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F550),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},18,{"$f":"IF(ISNUMBER(H550),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,3,"",{"$f":"IF(ISNUMBER(D551),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F551),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H551),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,4,"",{"$f":"IF(ISNUMBER(D552),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F552),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H552),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej",null,5,"",{"$f":"IF(ISNUMBER(D553),(1-$I$429)*$I$428*$D$427,0)*IF($D$427>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(F553),$I$432*$D$427,0)*IF(D$51>0,1,0)","v":0},"",{"$f":"IF(ISNUMBER(H553),$I$436*$D$427,0)*IF(D$51>0,1,0)","v":0}]
["Nej"]
[{"$f":"IF($D$14=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"}]
[{"$f":"IF($D$14=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Cashflow Slagtesvin"]
["Ja",null,"Terminer i halvår","Investeringssum","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato"]
["Ja",{"$f":"IF(J558>=0,0,J558)","v":0},0,{"$f":"I452*-1","v":0},0,0,0,{"$f":"D558","v":0},{"$f":"D558","v":0},{"$f":"D558/1000","v":0},{"$f":"DATE(YEAR($D$32),IF(MONTH($D$32)<=6,1,7),1)","v":"2023-07-01"}]
["Ja",{"$f":"IF(J559>=0,0,J559)","v":0},{"$f":"IF(AND(C558<>FALSE,C558+0.5<=$I$430),C558+0.5)","v":0.5},{"$f":"(IF(ISNA(VLOOKUP(C559,$D$549:$E$553,2,FALSE)),0,VLOOKUP(C559,$D$549:$E$553,2,FALSE))+IF(ISNA(VLOOKUP(C559,$F$549:$G$553,2,FALSE)),0,VLOOKUP(C559,$F$549:$G$553,2,FALSE))+IF(ISNA(VLOOKUP(C559,$H$549:$I$553,2,FALSE)),0,VLOOKUP(C559,$H$549:$I$553,2,FALSE)))*-1+IF(C559=$I$430,$I$458,0)","v":0},{"$f":"IF(C559<=$I$430,$H$510*0.5,0)","v":0},{"$f":"IF(C559<=$I$430,IF(H558<0,H558*$E$545*-1,0),0)","v":0},{"$f":"IF(H558>=0,0,IF(E559-F559>H558*-1,H558*-1,E559-F559))","v":0},{"$f":"H558+D559+G559","v":0},{"$f":"D559+E559","v":0},{"$f":"(H559+IF(C559<$I$430,$I$458,0))/1000","v":0},{"$f":"IF(MONTH(K558)+6>12,DATE(YEAR(K558)+1,MONTH(K558)+6-12,1),DATE(YEAR(K558),MONTH(K558)+6,1))","v":"2024-01-01"}]
["Ja",0,{"$f":"IF(AND(C559<>FALSE,C559+0.5<=$I$430),C559+0.5)","v":1},0,0,0,0,0,{"$f":"D560+E560","v":0},0,{"$f":"IF(MONTH(K559)+6>12,DATE(YEAR(K559)+1,MONTH(K559)+6-12,1),DATE(YEAR(K559),MONTH(K559)+6,1))","v":"2024-07-01"}]
["Ja",0,1.5,0,0,0,0,0,0,0,"2025-01-01"]
["Ja",0,2,0,0,0,0,0,0,0,"2025-07-01"]
["Ja",0,2.5,0,0,0,0,0,0,0,"2026-01-01"]
["Ja",0,3,0,0,0,0,0,0,0,"2026-07-01"]
["Ja",0,3.5,0,0,0,0,0,0,0,"2027-01-01"]
["Ja",0,4,0,0,0,0,0,0,0,"2027-07-01"]
["Ja",0,4.5,0,0,0,0,0,0,0,"2028-01-01"]
["Ja",0,5,0,0,0,0,0,0,0,"2028-07-01"]
["Ja",0,5.5,0,0,0,0,0,0,0,"2029-01-01"]
["Ja",0,6,0,0,0,0,0,0,0,"2029-07-01"]
["Ja",0,6.5,0,0,0,0,0,0,0,"2030-01-01"]
["Ja",0,7,0,0,0,0,0,0,0,"2030-07-01"]
["Ja",0,7.5,0,0,0,0,0,0,0,"2031-01-01"]
["Ja",0,8,0,0,0,0,0,0,0,"2031-07-01"]
["Ja",0,8.5,0,0,0,0,0,0,0,"2032-01-01"]
["Ja",0,9,0,0,0,0,0,0,0,"2032-07-01"]
["Ja",0,9.5,0,0,0,0,0,0,0,"2033-01-01"]
["Ja",0,10,0,0,0,0,0,0,0,"2033-07-01"]
["Ja",0,10.5,0,0,0,0,0,0,0,"2034-01-01"]
["Ja",0,11,0,0,0,0,0,0,0,"2034-07-01"]
["Ja",0,11.5,0,0,0,0,0,0,0,"2035-01-01"]
["Ja",0,12,0,0,0,0,0,0,0,"2035-07-01"]
["Ja",0,12.5,0,0,0,0,0,0,0,"2036-01-01"]
["Ja",0,13,0,0,0,0,0,0,0,"2036-07-01"]
["Ja",0,13.5,0,0,0,0,0,0,0,"2037-01-01"]
["Ja",0,14,0,0,0,0,0,0,0,"2037-07-01"]
["Ja",0,14.5,0,0,0,0,0,0,0,"2038-01-01"]
["Ja",0,15,0,0,0,0,0,0,0,"2038-07-01"]
["Ja",0,15.5,0,0,0,0,0,0,0,"2039-01-01"]
["Ja",0,16,0,0,0,0,0,0,0,"2039-07-01"]
["Ja",0,16.5,0,0,0,0,0,0,0,"2040-01-01"]
["Ja",0,17,0,0,0,0,0,0,0,"2040-07-01"]
["Ja",0,17.5,0,0,0,0,0,0,0,"2041-01-01"]
["Ja",0,18,0,0,0,0,0,0,0,"2041-07-01"]
["Ja",0,18.5,0,0,0,0,0,0,0,"2042-01-01"]
["Ja",0,19,0,0,0,0,0,0,0,"2042-07-01"]
["Ja",0,19.5,0,0,0,0,0,0,0,"2043-01-01"]
["Ja",0,20,0,0,0,0,0,0,0,"2043-07-01"]
["Ja",0,20.5,0,0,0,0,0,0,0,"2044-01-01"]
["Ja",0,21,0,0,0,0,0,0,0,"2044-07-01"]
["Ja",0,21.5,0,0,0,0,0,0,0,"2045-01-01"]
["Ja",0,22,0,0,0,0,0,0,0,"2045-07-01"]
["Ja",0,22.5,0,0,0,0,0,0,0,"2046-01-01"]
["Ja",0,23,0,0,0,0,0,0,0,"2046-07-01"]
["Ja",0,23.5,0,0,0,0,0,0,0,"2047-01-01"]
["Ja",0,24,0,0,0,0,0,0,0,"2047-07-01"]
["Ja",0,24.5,0,0,0,0,0,0,0,"2048-01-01"]
["Ja",0,25,0,0,0,0,0,0,0,"2048-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2049-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2050-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2051-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2052-07-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-01-01"]
["Ja",0,false,0,0,0,0,0,0,0,"2053-07-01"]
["Ja"]
[{"$f":"IF($D$15=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Samlet rentabilitetsanalyse","Årlig enheder","Investerings sum mio.","Levetid år bygninger"]
[{"$f":"IF($D$15=\"Ja\",\"Ja\",\"Nej\")","v":"Ja"},null,"Antal årssøer",{"$f":"D51","v":0},{"$f":"I77/1000000","v":0},{"$f":"I56","v":25}]
["Ja",null,"Solgte fravænnede ",{"$f":"D51*D58","v":0}]
["Ja",null,"Solgte smågrise",{"$f":"D249","v":0},{"$f":"I268/1000000","v":0},{"$f":"I246","v":25}]
["Ja",null,"Solgte slagtesvin",{"$f":"D436","v":0},{"$f":"I452/1000000","v":0},{"$f":"I430","v":25}]
["Ja",null,"Maks.",null,null,{"$f":"MAX(F621:F624)","v":25}]
["Ja",null,null,"Søer","Smågrise","Slagtesvin","I alt"]
["Ja",null,"Bruttoudbytte",{"$f":"IF(D$51>0,H114,0)","v":0},{"$f":"IF($D$243>0,H301,0)","v":0},{"$f":"IF($D$427>0,H493,0)","v":0},{"$f":"SUM(D627:F627)","v":0}]
["Ja",null,"Stykomkostninger i alt",{"$f":"IF(D$51>0,H124,0)","v":0},{"$f":"IF($D$243>0,H308,0)","v":0},{"$f":"IF($D$427>0,H500,0)","v":0},{"$f":"SUM(D628:F628)","v":0}]
["Ja",null,"Dækningsbidrag i alt",{"$f":"D627+D628","v":0},{"$f":"E627+E628","v":0},{"$f":"F627+F628","v":0},0]
["Ja",null,"Kontante kapacitetsomkostning i alt",{"$f":"IF(D$51>0,H133,0)","v":0},{"$f":"IF($D$243>0,H317,0)","v":0},{"$f":"IF($D$427>0,H509,0)","v":0},0]
["Ja",null,"EBID",{"$f":"D629+D630","v":0},{"$f":"E629+E630","v":0},{"$f":"F629+F630","v":0},0]
["Ja",null,"Afskrivninger",{"$f":"IF(D$51>0,H140,0)","v":0},{"$f":"IF($D$243>0,H324,0)","v":0},{"$f":"IF($D$427>0,H516,0)","v":0},0]
["Ja",null,"Resultat af primær drift",{"$f":"D631+D632","v":0},{"$f":"E631+E632","v":0},{"$f":"F631+F632","v":0},0]
["Ja",null,"Renteomkostninger",{"$f":"IF(D$51>0,H142,0)","v":0},{"$f":"IF($D$243>0,H326,0)","v":0},{"$f":"IF($D$427>0,H518,0)","v":0},0]
["Ja",null,"Ordinært resultat",{"$f":"D633+D634","v":0},{"$f":"E633+E634","v":0},{"$f":"F633+F634","v":0},0]
["Ja",null,"Ekstraordinære renteomkostninger",{"$f":"IF(D54>0,H144,0)","v":0},{"$f":"IF($D$243>0,H328,0)","v":0},{"$f":"IF($D$427>0,H520,0)","v":0},0]
["Ja",null,"Resultat i alt",{"$f":"D635+D636","v":0},{"$f":"E635+E636","v":0},{"$f":"F635+F636","v":0},0]
["Ja",null,"Afkastningsgrad",{"$f":"D73","v":""},{"$f":"D259","v":""},{"$f":"D455","v":""},{"$f":"IF(SUM(E621:E624)>0,XIRR(I653:I713,K653:K713,5%),0)","v":0}]
["Ja",null,"EVA","","","",{"$f":"IF(SUM(E621:E625)>0,G638-D30,0)","v":0}]
["Ja",null,"Tilbagebetalingstid i år","","","",{"$f":"IF(MAX(J653:J713)>=0,VLOOKUP(0,J653:L713,3,TRUE),\"Aldrig\")","v":30}]
["Ja",null,"Sikkerhedsmargin notering, kr./kg","","",""]
["Ja",null,"Nulpunktsnotering kr./kg","","",""]
["Ja",null,"Kapitalværdi i 1000 kr.","","","",{"$f":"XNPV(D30,I653:I713,K653:K713)/1000","v":0}]
["Ja"]
["Ja"]
["Ja",null,"Note: De enkelte driftsgrene er lagt sammen, dvs. høj EVA for en driftsgren ikke afdrager gælden hurtigere for en anden"]
["Ja",null,"Afkastningsgraden er dog beregnet selvstændigt, og den overordnede WACC er brugt"]
["Ja"]
["Ja"]
["Ja"]
[{"$f":"IF($D$16=\"Ja\",\"Ja\",\"Nej\")","v":"Nej"},null,"Cashflow konsolideret"]
[{"$f":"IF($D$16=\"Ja\",\"Ja\",\"Nej\")","v":"Nej"},null,"Terminer i halvår","Investeringssum","EBID Cashflow","Rente-omkostning","Rest afdrag","Gæld saldo","Cash flow ½ årligt","PB saldo 1000 kr.","Dato","År"]
["Nej",null,0,{"$f":"IF($D$51>0,D179,0)+IF($D$243>0,D363,0)+IF($D$427>0,D558,0)","v":0},0,0,0,0,0,0,{"$f":"K179","v":"2023-07-01"},{"$f":"C653","v":0}]
["Nej",null,{"$f":"C653+0.5","v":0.5},0,0,0,0,0,0,0,"2024-01-01",{"$f":"C654","v":0.5}]
["Nej",null,{"$f":"C654+0.5","v":1},0,0,0,0,0,0,0,"2024-07-01",1]
["Nej",null,1.5,0,0,0,0,0,0,0,"2025-01-01",1.5]
["Nej",null,2,0,0,0,0,0,0,0,"2025-07-01",2]
["Nej",null,2.5,0,0,0,0,0,0,0,"2026-01-01",2.5]
["Nej",null,3,0,0,0,0,0,0,0,"2026-07-01",3]
["Nej",null,3.5,0,0,0,0,0,0,0,"2027-01-01",3.5]
["Nej",null,4,0,0,0,0,0,0,0,"2027-07-01",4]
["Nej",null,4.5,0,0,0,0,0,0,0,"2028-01-01",4.5]
["Nej",null,5,0,0,0,0,0,0,0,"2028-07-01",5]
["Nej",null,5.5,0,0,0,0,0,0,0,"2029-01-01",5.5]
["Nej",null,6,0,0,0,0,0,0,0,"2029-07-01",6]
["Nej",null,6.5,0,0,0,0,0,0,0,"2030-01-01",6.5]
["Nej",null,7,0,0,0,0,0,0,0,"2030-07-01",7]
["Nej",null,7.5,0,0,0,0,0,0,0,"2031-01-01",7.5]
["Nej",null,8,{"$f":"IF($D$51>0,D195,0)+IF($D$243>0,D379,0)+IF($D$427>0,D574,0)","v":0},0,0,0,0,0,0,"2031-07-01",8]
["Nej",null,8.5,0,0,0,0,0,0,0,"2032-01-01",8.5]
["Nej",null,9,0,0,0,0,0,0,0,"2032-07-01",9]
["Nej",null,9.5,0,0,0,0,0,0,0,"2033-01-01",9.5]
["Nej",null,10,0,0,0,0,0,0,0,"2033-07-01",10]
["Nej",null,10.5,0,0,0,0,0,0,0,"2034-01-01",10.5]
["Nej",null,11,0,0,0,0,0,0,0,"2034-07-01",11]
["Nej",null,11.5,0,0,0,0,0,0,0,"2035-01-01",11.5]
["Nej",null,12,0,0,0,0,0,0,0,"2035-07-01",12]
["Nej",null,12.5,0,0,0,0,0,0,0,"2036-01-01",12.5]
["Nej",null,13,0,0,0,0,0,0,0,"2036-07-01",13]
["Nej",null,13.5,0,0,0,0,0,0,0,"2037-01-01",13.5]
["Nej",null,14,0,0,0,0,0,0,0,"2037-07-01",14]
["Nej",null,14.5,0,0,0,0,0,0,0,"2038-01-01",14.5]
["Nej",null,15,0,0,0,0,0,0,0,"2038-07-01",15]
["Nej",null,15.5,0,0,0,0,0,0,0,"2039-01-01",15.5]
["Nej",null,16,{"$f":"IF($D$51>0,D211,0)+IF($D$243>0,D395,0)+IF($D$427>0,D590,0)","v":0},0,0,0,0,0,0,"2039-07-01",16]
["Nej",null,16.5,0,0,0,0,0,0,0,"2040-01-01",16.5]
["Nej",null,17,0,0,0,0,0,0,0,"2040-07-01",17]
["Nej",null,17.5,0,0,0,0,0,0,0,"2041-01-01",17.5]
["Nej",null,18,0,0,0,0,0,0,0,"2041-07-01",18]
["Nej",null,18.5,0,0,0,0,0,0,0,"2042-01-01",18.5]
["Nej",null,19,0,0,0,0,0,0,0,"2042-07-01",19]
["Nej",null,19.5,0,0,0,0,0,0,0,"2043-01-01",19.5]
["Nej",null,20,0,0,0,0,0,0,0,"2043-07-01",20]
["Nej",null,20.5,0,0,0,0,0,0,0,"2044-01-01",20.5]
["Nej",null,21,0,0,0,0,0,0,0,"2044-07-01",21]
["Nej",null,21.5,0,0,0,0,0,0,0,"2045-01-01",21.5]
["Nej",null,22,0,0,0,0,0,0,0,"2045-07-01",22]
["Nej",null,22.5,0,0,0,0,0,0,0,"2046-01-01",22.5]
["Nej",null,23,0,0,0,0,0,0,0,"2046-07-01",23]
["Nej",null,23.5,0,0,0,0,0,0,0,"2047-01-01",23.5]
["Nej",null,24,{"$f":"IF($D$51>0,D227,0)+IF($D$243>0,D411,0)+IF($D$427>0,D606,0)","v":0},0,0,0,0,0,0,"2047-07-01",24]
["Nej",null,24.5,0,0,0,0,0,0,0,"2048-01-01",24.5]
["Nej",null,25,0,0,0,0,0,0,0,"2048-07-01",25]
["Nej",null,25.5,0,0,0,0,0,0,0,"2049-01-01",25.5]
["Nej",null,26,0,0,0,0,0,0,0,"2049-07-01",26]
["Nej",null,26.5,0,0,0,0,0,0,0,"2050-01-01",26.5]
["Nej",null,27,0,0,0,0,0,0,0,"2050-07-01",27]
["Nej",null,27.5,0,0,0,0,0,0,0,"2051-01-01",27.5]
["Nej",null,28,0,0,0,0,0,0,0,"2051-07-01",28]
["Nej",null,28.5,0,0,0,0,0,0,0,"2052-01-01",28.5]
["Nej",null,29,0,0,0,0,0,0,0,"2052-07-01",29]
["Nej",null,29.5,0,0,0,0,0,0,0,"2053-01-01",29.5]
["Nej",null,30,0,0,0,0,0,0,0,"2053-07-01",30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]

{"sheet":"Smågrisepriser","index":4,"n_rows":231,"n_cols":15,"rows_kept":231,"cut":false,"hidden":true,"merged":[[6,2,6,4],[20,1,20,2],[20,3,20,4],[20,5,20,6],[234,0,236,0],[234,4,236,4],[12,6,12,7]]}
["Forbeholdt SEGES"]
["Fra notering til afregningspris beregnet notering"]
["Korrektion, kr/kg ",0.06]
["Efterbetaling NPV, kr/kg",1.3,null,null,null,null," "]
["Korrektion til DC notering",{"$f":"SUM(B3:B4)","v":1.36}]
["Normtal slagtevægt",89]
["Forventet langtidsprognose",{"$f":"'Investerings kalkule m. makro'!D23","v":12.86},"Følsomheds noteringsændring"]
["Finansieringssandel 7 kg",0.32890000000000003,{"$f":"B8*B6","v":29.272100000000002},{"$f":"\"+/- kr/gris ved 7 kg\"","v":"+/- kr/gris ved 7 kg"}]
["Finansieringsandel 30 kg",{"$f":"1-50.51%","v":0.49490000000000001},{"$f":"B6*B9","v":44.046100000000003},{"$f":"\"+/- kr/gris ved 30 kg\"","v":"+/- kr/gris ved 30 kg"}]
["Mindre efterbetaling søer",{"$f":"0.2","v":0.2},"kr/kg"]
[]
["Sonotering er på langt sigt antaget at være 75 % af DC notering",0.75,{"$f":"11.2*0.75","v":8.3999999999999986},{"$f":"10.15*0.75","v":7.6125000000000007},{"$f":"12*0.75","v":9}]
["Opdateret 2022-11-27",null,null,null,null,null,"Indlagt"]
["Marginalpriser andre foderblandinger i forhold til ","Kr./fesv","Prisforskel i forhold til slagtesvinefoder",null,"Kontrol",null,-0.3,0.3]
["Pris per slagtesvinefoder, kr/fesv",2,0,null,{"$f":"B15+C$15","v":2},null,{"$f":"$E15+G$14","v":1.7},{"$f":"$E15+H$14","v":2.2999999999999998}]
["Sofoder",{"$f":"B$15+C16","v":2.0499999999999998},0.05,null,{"$f":"B16+C$15","v":2.0499999999999998},null,{"$f":"$E16+G$14","v":1.7499999999999998},2.3499999999999996]
["Smågrisefoder 1",{"$f":"B$15+C17","v":4.43},2.4300000000000002,null,4.43,null,4.13,4.7299999999999995]
["Smågrise foder 2",{"$f":"B$15+C18","v":2.2800000000000002},0.28000000000000003,null,2.2800000000000002,null,1.9800000000000002,2.58]
["Smågrisefoder vægtet",{"$f":"B$15+C19","v":2.6399999999999997},{"$f":"0.57+0.07","v":0.6399999999999999},null,2.6399999999999997,null,2.34,2.9399999999999995]
["Kg regulering per kg under 7 kg",3]
[null,"Kr. kg slagtekrop",null,"Smågrisepriser nulpunkt",null,"Kg reguleringer nulpunkt"]
["Slagtesvinefoderpris, kr/fesv","Afregningspris nulpunkt","DC not. nulpunkt","7 kg","30 kg","7-9 kg","9-12 kg","12-25 kg","25-30 kg","30-40 kg"]
[{"$f":"A24-0.3","v":1.7},11.38,{"$f":"B23-$B$5","v":10.020000000000001},242.91,420.68,8.1300000000000008,13.63,7.24,5.3,5.84,null,null,"ok",{"$f":"D23+F23*2+3*G23+13*H23+5*I23","v":420.68},{"$f":"N23-E23","v":0}]
[{"$f":"B15","v":2},12.5,{"$f":"B24-$B$5","v":11.14},258.27999999999997,449.76,9.6999999999999993,13.62,7.84,5.86,6.57,null,null,"ok",{"$f":"D24+F24*2+3*G24+13*H24+5*I24","v":449.76},{"$f":"N24-E24","v":0}]
[{"$f":"A24+0.3","v":2.2999999999999998},13.62,{"$f":"B25-$B$5","v":12.26},272.10000000000002,476.7,11.15,13.64,8.41,6.41,7.28,null,null,"ok",{"$f":"D25+F25*2+3*G25+13*H25+5*I25","v":476.70000000000005},{"$f":"N25-E25","v":0}]
[]
[]
["Beregnet smågrisenotering, priser nulpunktsnotering"]
["7 kg smågrisepris",{"$f":"VLOOKUP(B15,A61:D231,4,FALSE)","v":258.27999999999997},"Kr./gris"," "]
["30 kg smågrisepris",{"$f":"VLOOKUP(B15,A61:E231,5,FALSE)","v":449.76},"Kr./gris"]
["Nulpunkts notering gns",{"$f":"VLOOKUP(B15,A60:C231,3,FALSE)","v":11.14},null,null,"Beregnet notering"]
["Kg regulering","Fra kg","Til kg","Kr/kg","Startpris","Slutpris",null,"Kolonnenr"]
[null,0,7,{"$f":"D34+B20","v":12.699999999999998},{"$f":"B29-7*D33","v":169.38},{"$f":"E34","v":258.27999999999997},null,null," "]
[null,{"$f":"C33","v":7},{"$f":"B35","v":9},{"$f":"VLOOKUP($B$15,$A$60:$K$231,H34,FALSE)","v":9.6999999999999975},{"$f":"B29","v":258.27999999999997},{"$f":"E34+(C34-B34)*D34","v":277.67999999999995},null,7]
[null,9,12,{"$f":"VLOOKUP($B$15,$A$60:$K$231,H35,FALSE)","v":13.62},{"$f":"F33","v":258.27999999999997},299.14,null,{"$f":"H34+1","v":8}]
[null,12,25,7.84,{"$f":"F35","v":299.14},401.06,null,{"$f":"H35+1","v":9}]
[null,25,30,5.8599999999999994,{"$f":"F36","v":401.06},430.36,null,10]
[null,30,40,6.57,{"$f":"F37","v":430.36},496.06,null,11]
[null,40,130,{"$f":"D38","v":6.57},{"$f":"F38","v":496.06},1087.3600000000001,null,12]
[" ",130,1000,{"$f":"D39","v":6.57}]
[]
["Tabel for smågrisenotering ved angivet notering og langsigtet foderprognose",null,null,null,null,null,"Kontrol"]
["Indlagt notering+ følsomhed",{"$f":"'Investerings kalkule m. makro'!D21+'Investerings kalkule m. makro'!D24","v":11.5},null,"Niveau",null,null,{"$f":"(B45-B30)-(B43-B31)*Normtal_slagtevægt*Finansieringsandel_30_kg","v":0}]
["7 kg smågrisepris",{"$f":"B29+(B43-B31)*B6*B8","v":268.81795599999998},"Kr./gris",{"$f":"(B44/B29)","v":1.0408005110732539}]
["30 kg smågrisepris",{"$f":"B30+(B43-B31)*B6*B9","v":465.61659599999996},"Kr./gris",{"$f":"(B45/B30)","v":1.0352556830309498}]
["Ændret niveau regulering",null,null,{"$f":"(B45-B44)/(B30-B29)","v":1.0277764779611445},"Beregnet notering"]
["Kg regulering","Fra kg","Til kg","Kr/kg","Startpris","Slutpris"]
[null,{"$f":"B33","v":0},7,{"$f":"D33*$D$46","v":13.052761270106533},{"$f":"B44-7*D48","v":177.44862710925423},{"$f":"E49","v":268.81795599999998}," "," "]
[null,7,9,{"$f":"D34*$D$46","v":9.969431836223098},{"$f":"B44","v":268.81795599999998},{"$f":"E49+(C49-B49)*D48","v":294.92347854021307}]
[null,9,12,13.998315629830786,{"$f":"F49","v":294.92347854021307},{"$f":"E50+(C50-B50)*D49","v":324.83177404888238}]
[null,12,25,8.0577675872153716,{"$f":"F50","v":324.83177404888238},506.80987723668261]
[null,25,30,6.0227701608523061,{"$f":"F51","v":506.80987723668261},547.09871517275951]
[null,30,40,6.7524914602047197,{"$f":"F52","v":547.09871517275951},607.32641678128255]
[null,40,130,6.7524914602047197,{"$f":"F53","v":607.32641678128255},1215.0506481997072]
[" ",130,1000,6.7524914602047197]
[]
[]
[]
[]
["Slagtesvine foder, kr. fesv","Nulpunktsnotering",{"$f":"C22","v":"DC not. nulpunkt"},{"$f":"D22","v":"7 kg"},{"$f":"E22","v":"30 kg"},"0-7","7-9 kg","9-12 kg","12-25 kg","25-30 kg","30-40 kg","Match"]
[{"$f":"0.96+0.46","v":1.42},{"$f":"IF($A61<=$A$24,FORECAST($A61,B$23:B$24,$A$23:$A$24),FORECAST($A61,B$24:B$25,$A$24:$A$25))","v":10.334666666666669},8.9746666666666695,228.56466666666665,393.5386666666667,{"$f":"G61+B$20","v":9.6646666666666672},{"$f":"IF($A61<=$A$24,FORECAST($A61,F$23:F$24,$A$23:$A$24),FORECAST($A61,F$24:F$25,$A$24:$A$25))","v":6.6646666666666672},13.639333333333335,6.6800000000000006,4.777333333333333,5.1586666666666661,0]
[{"$f":"ROUND(A61+0.01,2)","v":1.43},10.372000000000003,9.012000000000004,229.077,394.50800000000004,{"$f":"G62+B$20","v":9.7170000000000005},6.7170000000000005,13.639000000000003,6.7000000000000011,4.7959999999999994,5.1829999999999998,0]
[{"$f":"ROUND(A62+0.01,2)","v":1.44},10.409333333333336,9.0493333333333368,229.58933333333334,395.47733333333338,9.7693333333333339,6.7693333333333339,13.638666666666669,6.7200000000000006,4.8146666666666658,5.2073333333333327,0]
[1.45,10.446666666666669,9.0866666666666696,230.10166666666666,396.44666666666672,9.8216666666666672,6.8216666666666672,13.638333333333335,6.74,4.8333333333333321,5.2316666666666656,0]
[1.46,10.484000000000002,9.1240000000000023,230.61399999999998,397.41600000000005,9.8740000000000006,6.8740000000000006,13.638000000000002,6.7600000000000007,4.8519999999999985,5.2560000000000002,0]
[1.47,10.521333333333335,9.1613333333333351,231.12633333333332,398.38533333333339,9.9263333333333339,6.9263333333333339,13.637666666666668,6.7800000000000011,4.8706666666666658,5.2803333333333331,0]
[1.48,10.558666666666669,9.1986666666666697,231.63866666666667,399.35466666666673,9.9786666666666672,6.9786666666666672,13.637333333333336,6.8000000000000007,4.8893333333333331,5.304666666666666,0]
[1.49,10.596000000000004,9.2360000000000042,232.15099999999998,400.32400000000007,10.031000000000001,7.0310000000000006,13.637000000000002,6.82,4.9079999999999995,5.3289999999999997,0]
[1.5,10.633333333333336,9.273333333333337,232.66333333333333,401.29333333333341,10.083333333333334,7.0833333333333339,13.636666666666668,6.8400000000000007,4.9266666666666659,5.3533333333333335,0]
[1.51,10.670666666666669,9.3106666666666698,233.17566666666664,402.26266666666675,10.135666666666665,7.1356666666666664,13.636333333333335,6.86,4.9453333333333322,5.3776666666666664,0]
[1.52,{"$f":"IF($A71<=$A$24,FORECAST($A71,B$23:B$24,$A$23:$A$24),FORECAST($A71,B$24:B$25,$A$24:$A$25))","v":10.708000000000002},9.3480000000000025,233.68799999999999,403.23200000000008,10.187999999999999,{"$f":"IF($A71<=$A$24,FORECAST($A71,F$23:F$24,$A$23:$A$24),FORECAST($A71,F$24:F$25,$A$24:$A$25))","v":7.1879999999999997},13.636000000000001,6.8800000000000008,4.9639999999999995,5.4019999999999992,0]
[1.53,10.745333333333335,9.3853333333333353,234.20033333333333,404.20133333333342,10.240333333333334,7.240333333333334,13.635666666666669,6.9,4.9826666666666659,5.426333333333333,0]
[1.54,10.782666666666669,9.4226666666666699,234.71266666666665,405.17066666666676,10.292666666666667,7.2926666666666673,13.635333333333335,6.92,5.0013333333333332,5.4506666666666668,0]
[1.55,10.820000000000002,9.4600000000000026,235.22499999999997,406.14000000000004,10.345000000000001,7.3450000000000006,13.635000000000002,6.94,5.0199999999999996,5.4749999999999996,0]
[1.56,10.857333333333337,9.4973333333333372,235.73733333333331,407.10933333333338,10.397333333333334,7.397333333333334,13.634666666666668,6.9600000000000009,5.038666666666666,5.4993333333333334,0]
[1.57,10.894666666666669,9.53466666666667,236.24966666666666,408.07866666666672,10.449666666666667,7.4496666666666673,13.634333333333334,6.98,5.0573333333333323,5.5236666666666672,0]
[1.58,10.932000000000002,9.5720000000000027,236.762,409.04800000000006,10.502000000000001,7.5020000000000007,13.634000000000002,7,5.0759999999999996,5.548,0]
[1.59,10.969333333333335,9.6093333333333355,237.27433333333332,410.0173333333334,10.554333333333334,7.554333333333334,13.633666666666668,7.0200000000000005,5.094666666666666,5.5723333333333329,0]
[1.6,11.006666666666669,9.6466666666666701,237.78666666666663,410.98666666666674,10.606666666666667,7.6066666666666674,13.633333333333335,7.0400000000000009,5.1133333333333333,5.5966666666666667,0]
[1.61,11.044000000000002,9.6840000000000028,238.29899999999998,411.95600000000002,10.659000000000001,7.6590000000000007,13.633000000000001,7.0600000000000005,5.1319999999999997,5.6210000000000004,0]
[1.62,{"$f":"IF($A81<=$A$24,FORECAST($A81,B$23:B$24,$A$23:$A$24),FORECAST($A81,B$24:B$25,$A$24:$A$25))","v":11.081333333333337},9.7213333333333374,238.81133333333332,412.92533333333336,10.711333333333334,{"$f":"IF($A81<=$A$24,FORECAST($A81,F$23:F$24,$A$23:$A$24),FORECAST($A81,F$24:F$25,$A$24:$A$25))","v":7.711333333333334},13.632666666666667,7.08,5.1506666666666661,5.6453333333333333,0]
[1.63,11.11866666666667,9.7586666666666702,239.32366666666664,413.89466666666669,10.763666666666666,7.7636666666666656,13.632333333333335,7.1,5.1693333333333324,5.6696666666666662,{"$f":"0","v":0}]
[1.64,11.156000000000002,9.7960000000000029,239.83599999999996,414.86400000000003,10.815999999999999,7.8159999999999989,13.632000000000001,7.12,5.1879999999999988,5.6939999999999991,{"$f":"0","v":0}]
[1.65,11.193333333333335,9.8333333333333357,240.3483333333333,415.83333333333337,10.868333333333332,7.8683333333333323,13.631666666666668,7.1400000000000006,5.2066666666666661,5.7183333333333328,{"$f":"0","v":0}]
[1.66,11.230666666666668,9.8706666666666685,240.86066666666665,416.80266666666671,10.920666666666666,7.9206666666666656,13.631333333333334,7.16,5.2253333333333325,5.7426666666666666,{"$f":"0","v":0}]
[1.67,11.268000000000001,9.9080000000000013,241.37299999999996,417.77200000000005,10.972999999999999,7.972999999999999,13.631,7.18,5.2439999999999998,5.7669999999999995,{"$f":"0","v":0}]
[1.68,11.305333333333335,9.9453333333333358,241.88533333333331,418.74133333333339,11.025333333333332,8.0253333333333323,13.630666666666668,7.2,5.2626666666666662,5.7913333333333332,{"$f":"0","v":0}]
[1.69,11.342666666666668,9.9826666666666686,242.39766666666662,419.71066666666673,11.077666666666666,8.0776666666666657,13.630333333333335,7.2200000000000006,5.2813333333333325,5.8156666666666661,{"$f":"0","v":0}]
[1.7,11.380000000000003,10.020000000000003,242.90999999999997,420.68000000000006,11.129999999999999,8.129999999999999,13.63,7.24,5.2999999999999989,5.84,1]
[1.71,11.417333333333335,10.057333333333336,243.42233333333331,421.6493333333334,11.182333333333332,8.1823333333333323,13.629666666666667,7.26,5.3186666666666662,5.8643333333333336,{"$f":"0","v":0}]
[1.72,{"$f":"IF($A91<=$A$24,FORECAST($A91,B$23:B$24,$A$23:$A$24),FORECAST($A91,B$24:B$25,$A$24:$A$25))","v":11.454666666666668},10.094666666666669,243.93466666666663,422.61866666666674,11.234666666666666,{"$f":"IF($A91<=$A$24,FORECAST($A91,F$23:F$24,$A$23:$A$24),FORECAST($A91,F$24:F$25,$A$24:$A$25))","v":8.2346666666666657},13.629333333333333,7.28,5.3373333333333335,5.8886666666666665,{"$f":"0","v":0}]
[1.73,11.492000000000001,10.132000000000001,244.44699999999995,423.58800000000002,11.286999999999999,8.286999999999999,13.629000000000001,7.3000000000000007,5.3559999999999999,5.9130000000000003,{"$f":"0","v":0}]
[1.74,11.529333333333334,10.169333333333334,244.95933333333329,424.55733333333336,11.339333333333332,8.3393333333333324,13.628666666666668,7.32,5.3746666666666663,5.9373333333333331,{"$f":"0","v":0}]
[1.75,11.566666666666668,10.206666666666669,245.47166666666664,425.5266666666667,11.391666666666666,8.3916666666666657,13.628333333333334,7.34,5.3933333333333326,5.9616666666666669,{"$f":"0","v":0}]
[1.76,11.604000000000003,10.244000000000003,245.98399999999998,426.49600000000004,11.443999999999999,8.4439999999999991,13.628,7.36,5.411999999999999,5.9859999999999998,{"$f":"0","v":0}]
[1.77,11.641333333333336,10.281333333333336,246.4963333333333,427.46533333333338,11.496333333333332,8.4963333333333324,13.627666666666666,7.3800000000000008,5.4306666666666663,6.0103333333333335,{"$f":"0","v":0}]
[1.78,11.678666666666668,10.318666666666669,247.00866666666661,428.43466666666671,11.548666666666666,8.5486666666666657,13.627333333333334,7.4,5.4493333333333336,6.0346666666666664,{"$f":"0","v":0}]
[1.79,11.716000000000001,10.356000000000002,247.52099999999996,429.404,11.600999999999999,8.6009999999999991,13.627000000000001,7.42,5.468,6.0590000000000002,{"$f":"0","v":0}]
[1.8,11.753333333333334,10.393333333333334,248.0333333333333,430.37333333333333,11.653333333333332,8.6533333333333324,13.626666666666667,7.44,5.4866666666666664,6.0833333333333339,{"$f":"0","v":0}]
[1.81,11.790666666666668,10.430666666666669,248.54566666666665,431.34266666666667,11.705666666666666,8.7056666666666658,13.626333333333333,7.4600000000000009,5.5053333333333327,6.1076666666666668,{"$f":"0","v":0}]
[1.82,{"$f":"IF($A101<=$A$24,FORECAST($A101,B$23:B$24,$A$23:$A$24),FORECAST($A101,B$24:B$25,$A$24:$A$25))","v":11.828000000000003},10.468000000000004,249.05799999999996,432.31200000000001,11.757999999999999,{"$f":"IF($A101<=$A$24,FORECAST($A101,F$23:F$24,$A$23:$A$24),FORECAST($A101,F$24:F$25,$A$24:$A$25))","v":8.7579999999999991},13.625999999999999,7.48,5.5239999999999991,6.1320000000000006,{"$f":"0","v":0}]
[1.83,11.865333333333336,10.505333333333336,249.57033333333328,433.28133333333335,11.810333333333332,8.8103333333333325,13.625666666666667,7.5,5.5426666666666664,6.1563333333333334,{"$f":"0","v":0}]
[1.84,11.902666666666669,10.542666666666669,250.08266666666663,434.25066666666669,11.862666666666666,8.8626666666666658,13.625333333333334,7.52,5.5613333333333337,6.1806666666666672,{"$f":"0","v":0}]
[1.85,11.940000000000001,10.580000000000002,250.59499999999997,435.22,11.914999999999999,8.9149999999999991,13.625,7.54,5.58,6.2050000000000001,{"$f":"0","v":0}]
[1.86,11.977333333333334,10.617333333333335,251.10733333333332,436.18933333333337,11.967333333333332,8.9673333333333325,13.624666666666666,7.5600000000000005,5.5986666666666665,6.2293333333333338,{"$f":"0","v":0}]
[1.87,12.014666666666669,10.654666666666669,251.61966666666663,437.1586666666667,12.019666666666666,9.0196666666666658,13.624333333333333,7.58,5.6173333333333328,6.2536666666666667,{"$f":"0","v":0}]
[1.88,12.052,10.692,252.13199999999995,438.12800000000004,12.071999999999997,9.0719999999999974,13.624000000000001,7.6,5.6359999999999992,6.2779999999999996,{"$f":"0","v":0}]
[1.89,12.089333333333334,10.729333333333335,252.64433333333329,439.09733333333338,12.124333333333331,9.1243333333333307,13.623666666666667,7.6199999999999992,5.6546666666666656,6.3023333333333333,{"$f":"0","v":0}]
[1.9,12.126666666666669,10.766666666666669,253.15666666666661,440.06666666666672,12.176666666666664,9.1766666666666641,13.623333333333333,7.64,5.6733333333333329,6.3266666666666662,{"$f":"0","v":0}]
[1.91,12.164000000000001,10.804000000000002,253.66899999999995,441.03600000000006,12.228999999999997,9.2289999999999974,13.622999999999999,7.66,5.6920000000000002,6.351,{"$f":"0","v":0}]
[1.92,{"$f":"IF($A111<=$A$24,FORECAST($A111,B$23:B$24,$A$23:$A$24),FORECAST($A111,B$24:B$25,$A$24:$A$25))","v":12.201333333333334},10.841333333333335,254.18133333333327,442.00533333333334,12.281333333333331,{"$f":"IF($A111<=$A$24,FORECAST($A111,F$23:F$24,$A$23:$A$24),FORECAST($A111,F$24:F$25,$A$24:$A$25))","v":9.2813333333333308},13.622666666666666,7.68,5.7106666666666666,6.3753333333333337,{"$f":"0","v":0}]
[1.93,12.238666666666667,10.878666666666668,254.69366666666662,442.97466666666668,12.333666666666664,9.3336666666666641,13.622333333333334,7.6999999999999993,5.7293333333333329,6.3996666666666666,{"$f":"0","v":0}]
[1.94,12.276,10.916,255.20599999999996,443.94400000000002,12.385999999999997,9.3859999999999975,13.622,7.72,5.7479999999999993,6.4240000000000004,{"$f":"0","v":0}]
[1.95,12.313333333333334,10.953333333333335,255.71833333333328,444.91333333333336,12.438333333333331,9.4383333333333308,13.621666666666666,7.74,5.7666666666666666,6.4483333333333333,{"$f":"0","v":0}]
[1.96,12.350666666666667,10.990666666666668,256.23066666666659,445.88266666666669,12.490666666666664,9.4906666666666641,13.621333333333332,7.76,5.785333333333333,6.472666666666667,{"$f":"0","v":0}]
[1.97,12.388000000000002,11.028000000000002,256.74299999999994,446.85200000000003,12.542999999999997,9.5429999999999975,13.620999999999999,7.7799999999999994,5.8040000000000003,6.4969999999999999,{"$f":"0","v":0}]
[1.98,12.425333333333334,11.065333333333335,257.25533333333328,447.82133333333331,12.595333333333331,9.5953333333333308,13.620666666666667,7.8,5.8226666666666667,6.5213333333333336,{"$f":"0","v":0}]
[1.99,12.462666666666667,11.102666666666668,257.76766666666663,448.79066666666665,12.647666666666664,9.6476666666666642,13.620333333333333,7.82,5.841333333333333,6.5456666666666665,{"$f":"0","v":0}]
[2,12.5,11.14,258.27999999999997,449.76,12.699999999999998,9.6999999999999975,13.62,7.84,5.8599999999999994,6.57,1]
[2.0099999999999998,12.537333333333333,11.177333333333333,258.74066666666658,450.65800000000002,12.748333333333333,9.7483333333333331,13.620666666666665,7.859,5.878333333333333,6.5936666666666675,{"$f":"0","v":0}]
[2.02,{"$f":"IF($A121<=$A$24,FORECAST($A121,B$23:B$24,$A$23:$A$24),FORECAST($A121,B$24:B$25,$A$24:$A$25))","v":12.574666666666666},11.214666666666666,259.20133333333331,451.55600000000004,12.796666666666669,{"$f":"IF($A121<=$A$24,FORECAST($A121,F$23:F$24,$A$23:$A$24),FORECAST($A121,F$24:F$25,$A$24:$A$25))","v":9.7966666666666686},13.621333333333332,7.8780000000000001,5.8966666666666665,6.6173333333333346,{"$f":"0","v":0}]
[2.0299999999999998,12.611999999999998,11.251999999999999,259.66199999999992,452.45400000000001,12.845000000000001,9.8450000000000006,13.621999999999998,7.8970000000000002,5.9149999999999991,6.6410000000000009,{"$f":"0","v":0}]
[2.04,12.649333333333333,11.289333333333333,260.12266666666665,453.35200000000003,12.893333333333334,9.8933333333333344,13.622666666666666,7.9160000000000004,5.9333333333333336,6.6646666666666681,{"$f":"0","v":0}]
[2.0499999999999998,12.686666666666664,11.326666666666664,260.58333333333326,454.25,12.941666666666666,9.9416666666666664,13.623333333333331,7.9350000000000005,5.9516666666666662,6.6883333333333344,{"$f":"0","v":0}]
[2.06,12.724,11.364000000000001,261.04399999999998,455.14800000000002,12.990000000000002,9.990000000000002,13.623999999999999,7.9540000000000006,5.9700000000000006,6.7120000000000015,{"$f":"0","v":0}]
[2.0699999999999998,12.761333333333333,11.401333333333334,261.50466666666665,456.04600000000005,{"$f":"G126+B$20","v":13.038333333333334},10.038333333333334,13.624666666666664,7.9730000000000008,5.9883333333333333,6.7356666666666678,{"$f":"0","v":0}]
[{"$f":"ROUND(A126+0.01,2)","v":2.08},12.798666666666666,11.438666666666666,261.96533333333332,456.94400000000002,13.086666666666668,10.086666666666668,13.625333333333332,7.9920000000000009,6.0066666666666668,6.759333333333335,{"$f":"0","v":0}]
[2.09,12.835999999999999,11.475999999999999,262.42599999999999,457.84199999999998,13.135000000000002,10.135000000000002,13.625999999999998,8.0109999999999992,6.0249999999999995,6.7830000000000013,{"$f":"0","v":0}]
[2.1,12.873333333333333,11.513333333333334,262.88666666666666,458.74,13.183333333333335,10.183333333333335,13.626666666666665,8.0300000000000011,6.043333333333333,6.8066666666666684,{"$f":"0","v":0}]
[2.11,12.910666666666664,11.550666666666665,263.34733333333332,459.63800000000003,13.231666666666667,10.231666666666667,13.627333333333333,8.0489999999999995,6.0616666666666665,6.8303333333333347,{"$f":"0","v":0}]
[2.12,{"$f":"IF($A131<=$A$24,FORECAST($A131,B$23:B$24,$A$23:$A$24),FORECAST($A131,B$24:B$25,$A$24:$A$25))","v":12.948},11.588000000000001,263.80799999999999,460.53600000000006,13.280000000000003,{"$f":"IF($A131<=$A$24,FORECAST($A131,F$23:F$24,$A$23:$A$24),FORECAST($A131,F$24:F$25,$A$24:$A$25))","v":10.280000000000003},13.627999999999998,8.0680000000000014,6.08,6.8540000000000019,0]
[2.13,12.985333333333333,11.625333333333334,264.26866666666666,461.43400000000003,13.328333333333335,10.328333333333335,13.628666666666666,8.0869999999999997,6.0983333333333327,6.8776666666666681,0]
[2.14,13.022666666666666,11.662666666666667,264.72933333333333,462.33199999999999,13.376666666666669,10.376666666666669,13.629333333333332,8.1060000000000016,6.1166666666666671,6.9013333333333353,0]
[2.15,13.059999999999999,11.7,265.19,463.23,13.425000000000001,10.425000000000001,13.629999999999999,8.125,6.1349999999999998,6.9250000000000007,0]
[2.16,13.097333333333333,11.737333333333334,265.65066666666667,464.12800000000004,13.473333333333336,10.473333333333336,13.630666666666665,8.1440000000000019,6.1533333333333342,6.9486666666666679,0]
[2.17,13.134666666666666,11.774666666666667,266.11133333333333,465.02600000000001,13.521666666666668,10.521666666666668,13.631333333333332,8.1630000000000003,6.1716666666666669,6.9723333333333342,0]
[2.1800000000000002,13.171999999999999,11.811999999999999,266.572,465.92400000000004,13.570000000000002,10.570000000000002,13.632,8.1820000000000022,6.19,6.9960000000000013,0]
[2.19,13.209333333333332,11.849333333333332,267.03266666666667,466.822,13.618333333333336,10.618333333333336,13.632666666666665,8.2010000000000005,6.2083333333333339,7.0196666666666676,0]
[2.2000000000000002,13.246666666666666,11.886666666666667,267.49333333333334,467.72,13.66666666666667,10.66666666666667,13.633333333333333,8.2200000000000006,6.2266666666666666,7.0433333333333348,0]
[2.21,13.283999999999999,11.923999999999999,267.95400000000001,468.61800000000005,13.715000000000002,10.715000000000002,13.633999999999999,8.2390000000000008,6.2449999999999992,7.0670000000000011,0]
[2.2200000000000002,{"$f":"IF($A141<=$A$24,FORECAST($A141,B$23:B$24,$A$23:$A$24),FORECAST($A141,B$24:B$25,$A$24:$A$25))","v":13.321333333333333},11.961333333333334,268.41466666666668,469.51600000000008,13.763333333333337,{"$f":"IF($A141<=$A$24,FORECAST($A141,F$23:F$24,$A$23:$A$24),FORECAST($A141,F$24:F$25,$A$24:$A$25))","v":10.763333333333337},13.634666666666666,8.2580000000000009,6.2633333333333336,7.0906666666666682,0]
[2.23,13.358666666666666,11.998666666666667,268.87533333333334,470.41399999999999,13.811666666666669,10.811666666666669,13.635333333333332,8.277000000000001,6.2816666666666663,7.1143333333333345,0]
[2.2400000000000002,13.395999999999999,12.036,269.33600000000001,471.31200000000001,13.860000000000003,10.860000000000003,13.635999999999999,8.2960000000000012,6.3000000000000007,7.1380000000000017,0]
[2.25,13.433333333333332,12.073333333333332,269.79666666666668,472.21000000000004,13.908333333333337,10.908333333333337,13.636666666666667,8.3150000000000013,6.3183333333333334,7.161666666666668,0]
[2.2599999999999998,13.470666666666665,12.110666666666665,270.25733333333335,473.108,13.956666666666669,10.956666666666669,13.637333333333332,8.3339999999999996,6.336666666666666,7.1853333333333342,0]
[2.27,13.507999999999999,12.148,270.71800000000002,474.00600000000003,14.005000000000003,11.005000000000003,13.638,8.3530000000000015,6.3550000000000004,7.2090000000000014,0]
[2.2799999999999998,13.545333333333332,12.185333333333332,271.17866666666669,474.904,14.053333333333335,11.053333333333335,13.638666666666666,8.3719999999999999,6.3733333333333331,7.2326666666666677,0]
[2.29,13.582666666666665,12.222666666666665,271.63933333333335,475.80200000000002,14.10166666666667,11.10166666666667,13.639333333333333,8.3910000000000018,6.3916666666666675,7.2563333333333349,0]
[2.2999999999999998,13.619999999999997,12.259999999999998,272.10000000000002,476.70000000000005,14.150000000000002,11.150000000000002,13.639999999999999,8.41,6.41,7.2800000000000011,1]
[2.31,13.657333333333332,12.297333333333333,272.56066666666669,477.59800000000007,14.198333333333336,11.198333333333336,13.640666666666666,8.429000000000002,6.4283333333333328,7.3036666666666683,0]
[2.3199999999999998,{"$f":"IF($A151<=$A$24,FORECAST($A151,B$23:B$24,$A$23:$A$24),FORECAST($A151,B$24:B$25,$A$24:$A$25))","v":13.694666666666665},12.334666666666665,273.02133333333336,478.49599999999998,14.24666666666667,{"$f":"IF($A151<=$A$24,FORECAST($A151,F$23:F$24,$A$23:$A$24),FORECAST($A151,F$24:F$25,$A$24:$A$25))","v":11.24666666666667},13.641333333333332,8.4480000000000004,6.4466666666666672,7.3273333333333346,0]
[2.33,13.731999999999999,12.372,273.48200000000003,479.39400000000001,14.295000000000003,11.295000000000003,13.641999999999999,8.4670000000000023,6.4649999999999999,7.3510000000000018,0]
[2.34,13.769333333333332,12.409333333333333,273.9426666666667,480.29200000000003,14.343333333333335,11.343333333333335,13.642666666666667,8.4860000000000007,6.4833333333333325,7.374666666666668,0]
[2.35,13.806666666666665,12.446666666666665,274.40333333333336,481.19000000000005,14.391666666666671,11.391666666666671,13.643333333333333,8.5050000000000008,6.5016666666666669,7.3983333333333352,0]
[2.36,13.843999999999998,12.483999999999998,274.86400000000003,482.08800000000002,14.440000000000003,11.440000000000003,13.644,8.5240000000000009,6.52,7.4220000000000015,0]
[2.37,13.881333333333332,12.521333333333333,275.3246666666667,482.98600000000005,14.488333333333337,11.488333333333337,13.644666666666666,8.543000000000001,6.538333333333334,7.4456666666666687,0]
[2.38,13.918666666666665,12.558666666666666,275.78533333333337,483.88400000000001,14.536666666666669,11.536666666666669,13.645333333333333,8.5620000000000012,6.5566666666666666,7.4693333333333349,0]
[2.39,13.956,12.596,276.24600000000004,484.78200000000004,14.585000000000004,11.585000000000004,13.645999999999999,8.5810000000000013,6.5750000000000011,7.4930000000000021,0]
[2.4,13.993333333333332,12.633333333333333,276.70666666666671,485.68000000000006,14.633333333333336,11.633333333333336,13.646666666666667,8.6000000000000014,6.5933333333333337,7.5166666666666684,0]
[2.41,14.030666666666665,12.670666666666666,277.16733333333337,486.57800000000003,14.68166666666667,11.68166666666667,13.647333333333334,8.6190000000000015,6.6116666666666664,7.5403333333333356,0]
[2.42,{"$f":"IF($A161<=$A$24,FORECAST($A161,B$23:B$24,$A$23:$A$24),FORECAST($A161,B$24:B$25,$A$24:$A$25))","v":14.067999999999998},12.707999999999998,277.62800000000004,487.476,14.730000000000004,{"$f":"IF($A161<=$A$24,FORECAST($A161,F$23:F$24,$A$23:$A$24),FORECAST($A161,F$24:F$25,$A$24:$A$25))","v":11.730000000000004},13.648,8.6380000000000017,6.6300000000000008,7.5640000000000018,0]
[2.4300000000000002,14.105333333333332,12.745333333333333,278.08866666666671,488.37400000000002,14.778333333333338,11.778333333333338,13.648666666666667,8.6570000000000018,6.6483333333333334,7.587666666666669,0]
[2.44,14.142666666666665,12.782666666666666,278.54933333333338,489.27200000000005,14.82666666666667,11.82666666666667,13.649333333333333,8.6760000000000019,6.6666666666666661,7.6113333333333344,0]
[2.4500000000000002,14.18,12.82,279.01000000000005,490.17000000000007,14.875000000000005,11.875000000000005,13.65,8.6950000000000003,6.6850000000000005,7.6350000000000016,0]
[2.46,14.217333333333332,12.857333333333333,279.47066666666672,491.06800000000004,14.923333333333337,11.923333333333337,13.650666666666666,8.7140000000000022,6.7033333333333331,7.6586666666666678,0]
[2.4700000000000002,14.254666666666665,12.894666666666666,279.93133333333338,491.96600000000001,14.971666666666671,11.971666666666671,13.651333333333334,8.7330000000000005,6.7216666666666676,7.682333333333335,0]
[2.48,14.291999999999998,12.931999999999999,280.39200000000005,492.86400000000003,15.020000000000003,12.020000000000003,13.652000000000001,8.7520000000000024,6.74,7.7060000000000013,0]
[2.4900000000000002,14.329333333333333,12.969333333333333,280.85266666666672,493.76200000000006,15.068333333333339,12.068333333333339,13.652666666666667,8.7710000000000008,6.7583333333333346,7.7296666666666685,0]
[2.5,14.366666666666665,13.006666666666666,281.31333333333339,494.66,15.116666666666671,12.116666666666671,13.653333333333334,8.7900000000000009,6.7766666666666673,7.7533333333333347,0]
[2.5099999999999998,14.403999999999998,13.043999999999999,281.77400000000006,495.55799999999999,15.165000000000003,12.165000000000003,13.654,8.8090000000000011,6.7949999999999999,7.777000000000001,0]
[2.52,{"$f":"IF($A171<=$A$24,FORECAST($A171,B$23:B$24,$A$23:$A$24),FORECAST($A171,B$24:B$25,$A$24:$A$25))","v":14.441333333333333},13.081333333333333,282.23466666666673,496.45600000000002,15.213333333333338,{"$f":"IF($A171<=$A$24,FORECAST($A171,F$23:F$24,$A$23:$A$24),FORECAST($A171,F$24:F$25,$A$24:$A$25))","v":12.213333333333338},13.654666666666667,8.8280000000000012,6.8133333333333344,7.8006666666666682,0]
[2.5299999999999998,14.478666666666664,13.118666666666664,282.69533333333339,497.35400000000004,15.26166666666667,12.26166666666667,13.655333333333333,8.8470000000000013,6.831666666666667,7.8243333333333345,0]
[2.54,14.515999999999998,13.155999999999999,283.15600000000006,498.25200000000007,15.310000000000004,12.310000000000004,13.656000000000001,8.8660000000000014,6.85,7.8480000000000016,0]
[2.5499999999999998,14.553333333333331,13.193333333333332,283.61666666666673,499.15,15.358333333333336,12.358333333333336,13.656666666666668,8.8850000000000016,6.8683333333333341,7.8716666666666679,0]
[2.56,14.590666666666666,13.230666666666666,284.0773333333334,500.048,15.406666666666672,12.406666666666672,13.657333333333334,8.9040000000000017,6.8866666666666667,7.8953333333333351,0]
[2.57,14.627999999999998,13.267999999999999,284.53800000000007,500.94600000000003,15.455000000000004,12.455000000000004,13.658000000000001,8.9230000000000018,6.9049999999999994,7.9190000000000014,0]
[2.58,14.665333333333331,13.305333333333332,284.99866666666674,501.84400000000005,15.503333333333337,12.503333333333337,13.658666666666667,8.9420000000000019,6.9233333333333338,7.9426666666666685,0]
[2.59,14.702666666666664,13.342666666666664,285.4593333333334,502.74200000000002,15.551666666666671,12.551666666666671,13.659333333333334,8.9610000000000021,6.9416666666666664,7.9663333333333348,0]
[2.6,14.739999999999998,13.379999999999999,285.92000000000007,503.64000000000004,15.600000000000005,12.600000000000005,13.66,8.98,6.9600000000000009,7.990000000000002,0]
[2.61,14.777333333333331,13.417333333333332,286.38066666666674,504.53800000000001,15.648333333333337,12.648333333333337,13.660666666666668,8.9990000000000023,6.9783333333333335,8.0136666666666692,0]
[2.62,{"$f":"IF($A181<=$A$24,FORECAST($A181,B$23:B$24,$A$23:$A$24),FORECAST($A181,B$24:B$25,$A$24:$A$25))","v":14.814666666666666},13.454666666666666,286.84133333333341,505.43600000000004,15.696666666666673,{"$f":"IF($A181<=$A$24,FORECAST($A181,F$23:F$24,$A$23:$A$24),FORECAST($A181,F$24:F$25,$A$24:$A$25))","v":12.696666666666673},13.661333333333335,9.0180000000000007,6.9966666666666679,8.0373333333333363,0]
[2.63,14.851999999999999,13.491999999999999,287.30200000000008,506.33400000000006,15.745000000000005,12.745000000000005,13.662000000000001,9.0370000000000026,7.0150000000000006,8.0610000000000017,0]
[2.64,14.889333333333331,13.529333333333332,287.76266666666675,507.23200000000008,15.793333333333338,12.793333333333338,13.662666666666668,9.0560000000000009,7.0333333333333332,8.0846666666666689,0]
[2.65,14.926666666666664,13.566666666666665,288.22333333333341,508.13,15.84166666666667,12.84166666666667,13.663333333333334,9.0750000000000011,7.0516666666666676,8.1083333333333343,0]
[2.66,14.963999999999999,13.603999999999999,288.68400000000008,509.02800000000002,15.890000000000006,12.890000000000006,13.664000000000001,9.0940000000000012,7.07,8.1320000000000014,0]
[2.67,15.001333333333331,13.641333333333332,289.14466666666675,509.92600000000004,15.938333333333338,12.938333333333338,13.664666666666667,9.1130000000000013,7.0883333333333329,8.1556666666666686,0]
[2.68,15.038666666666666,13.678666666666667,289.60533333333342,510.82400000000007,15.986666666666672,12.986666666666672,13.665333333333335,9.1320000000000014,7.1066666666666674,8.1793333333333358,0]
[2.69,15.075999999999999,13.715999999999999,290.06600000000009,511.72200000000004,16.035000000000004,13.035000000000005,13.666,9.1510000000000016,7.125,8.203000000000003,0]
[2.7,15.113333333333332,13.753333333333332,290.52666666666676,512.62000000000012,16.083333333333339,13.083333333333339,13.666666666666668,9.1700000000000017,7.1433333333333344,8.2266666666666701,0]
[2.71,15.150666666666664,13.790666666666665,290.98733333333342,513.51800000000003,{"$f":"G190+B$20","v":16.131666666666671},13.131666666666671,13.667333333333335,9.1890000000000018,7.1616666666666671,8.2503333333333355,0]
[{"$f":"ROUND(A190+0.01,2)","v":2.72},{"$f":"IF($A191<=$A$24,FORECAST($A191,B$23:B$24,$A$23:$A$24),FORECAST($A191,B$24:B$25,$A$24:$A$25))","v":15.187999999999999},13.827999999999999,291.44800000000009,514.41600000000005,16.180000000000007,{"$f":"IF($A191<=$A$24,FORECAST($A191,F$23:F$24,$A$23:$A$24),FORECAST($A191,F$24:F$25,$A$24:$A$25))","v":13.180000000000007},13.668000000000001,9.208000000000002,7.1800000000000015,8.2740000000000027,0]
[2.73,15.225333333333332,13.865333333333332,291.90866666666676,515.31400000000008,16.228333333333339,13.228333333333339,13.668666666666669,9.2270000000000021,7.1983333333333341,8.2976666666666681,0]
[2.74,15.262666666666666,13.902666666666667,292.36933333333343,516.21199999999999,16.276666666666671,13.276666666666673,13.669333333333334,9.2460000000000022,7.2166666666666668,8.3213333333333352,0]
[2.75,15.299999999999999,13.94,292.8300000000001,517.11,16.325000000000003,13.325000000000005,13.670000000000002,9.2650000000000006,7.2349999999999994,8.3450000000000024,0]
[2.76,15.33733333333333,13.977333333333331,293.29066666666677,518.00800000000004,16.373333333333338,13.373333333333338,13.670666666666667,9.2840000000000025,7.2533333333333339,8.3686666666666678,0]
[2.77,15.374666666666664,14.014666666666665,293.75133333333343,518.90600000000006,16.421666666666674,13.421666666666672,13.671333333333335,9.3030000000000008,7.2716666666666665,8.392333333333335,0]
[2.78,15.411999999999997,14.051999999999998,294.2120000000001,519.80400000000009,16.470000000000006,13.470000000000004,13.672000000000002,9.3220000000000027,7.2899999999999991,8.4160000000000004,0]
[2.79,15.449333333333332,14.089333333333332,294.67266666666677,520.702,16.518333333333338,13.51833333333334,13.672666666666668,9.3410000000000011,7.3083333333333336,8.4396666666666675,0]
[2.8,15.486666666666665,14.126666666666665,295.13333333333344,521.6,16.56666666666667,13.566666666666672,13.673333333333336,9.3600000000000012,7.3266666666666662,8.4633333333333347,0]
[2.81,15.523999999999999,14.164,295.59400000000011,522.49800000000005,16.615000000000006,13.615000000000006,13.674000000000001,9.3790000000000013,7.3450000000000006,8.4870000000000019,0]
[2.82,{"$f":"IF($A201<=$A$24,FORECAST($A201,B$23:B$24,$A$23:$A$24),FORECAST($A201,B$24:B$25,$A$24:$A$25))","v":15.56133333333333},14.201333333333331,296.05466666666678,523.39599999999996,16.663333333333341,{"$f":"IF($A201<=$A$24,FORECAST($A201,F$23:F$24,$A$23:$A$24),FORECAST($A201,F$24:F$25,$A$24:$A$25))","v":13.663333333333339},13.674666666666669,9.3980000000000015,7.3633333333333333,8.510666666666669,0]
[2.83,15.598666666666665,14.238666666666665,296.51533333333344,524.2940000000001,16.711666666666673,13.711666666666673,13.675333333333334,9.4170000000000016,7.3816666666666677,8.5343333333333362,0]
[2.84,15.635999999999997,14.275999999999998,296.97600000000011,525.19200000000001,16.760000000000005,13.760000000000005,13.676000000000002,9.4360000000000017,7.4,8.5580000000000016,0]
[2.85,15.673333333333332,14.313333333333333,297.43666666666678,526.09,16.808333333333341,13.808333333333341,13.676666666666669,9.4550000000000018,7.418333333333333,8.5816666666666688,0]
[2.86,15.710666666666665,14.350666666666665,297.89733333333345,526.98800000000006,16.856666666666673,13.856666666666673,13.677333333333335,9.474000000000002,7.4366666666666674,8.6053333333333342,0]
[2.87,15.747999999999998,14.387999999999998,298.35800000000012,527.88599999999997,16.905000000000008,13.905000000000006,13.678000000000003,9.4930000000000021,7.4550000000000001,8.6290000000000013,0]
[2.88,15.78533333333333,14.425333333333331,298.81866666666679,528.78400000000011,16.95333333333334,13.953333333333338,13.678666666666668,9.5120000000000005,7.4733333333333327,8.6526666666666685,0]
[2.89,15.822666666666665,14.462666666666665,299.27933333333345,529.68200000000002,17.001666666666672,14.001666666666674,13.679333333333336,9.5310000000000024,7.4916666666666671,8.6763333333333357,0]
[2.9,15.859999999999998,14.499999999999998,299.74000000000012,530.58000000000004,17.050000000000004,14.050000000000006,13.680000000000001,9.5500000000000007,7.51,8.7000000000000028,0]
[2.91,15.897333333333332,14.537333333333333,300.20066666666679,531.47800000000007,17.09833333333334,14.09833333333334,13.680666666666669,9.5690000000000026,7.5283333333333342,8.72366666666667,0]
[2.92,{"$f":"IF($A211<=$A$24,FORECAST($A211,B$23:B$24,$A$23:$A$24),FORECAST($A211,B$24:B$25,$A$24:$A$25))","v":15.934666666666665},14.574666666666666,300.66133333333346,532.37599999999998,17.146666666666675,{"$f":"IF($A211<=$A$24,FORECAST($A211,F$23:F$24,$A$23:$A$24),FORECAST($A211,F$24:F$25,$A$24:$A$25))","v":14.146666666666674},13.681333333333335,9.588000000000001,7.5466666666666669,8.7473333333333354,0]
[2.93,15.971999999999998,14.611999999999998,301.12200000000013,533.27400000000011,17.195000000000007,14.195000000000007,13.682000000000002,9.6070000000000029,7.5650000000000013,8.7710000000000026,0]
[2.94,16.009333333333331,14.649333333333331,301.5826666666668,534.17200000000003,17.243333333333339,14.243333333333339,13.68266666666667,9.6260000000000012,7.5833333333333339,8.794666666666668,0]
[2.95,16.046666666666667,14.686666666666666,302.04333333333352,535.07000000000005,17.291666666666675,14.291666666666675,13.683333333333335,9.6450000000000031,7.6016666666666666,8.8183333333333351,0]
[2.96,16.083999999999996,14.723999999999998,302.50400000000013,535.96800000000007,17.340000000000007,14.340000000000007,13.684000000000003,9.6640000000000015,7.620000000000001,8.8420000000000023,0]
[2.97,16.121333333333332,14.761333333333333,302.96466666666686,536.86599999999999,17.388333333333343,14.388333333333341,13.684666666666669,9.6830000000000034,7.6383333333333336,8.8656666666666695,0]
[2.98,16.158666666666665,14.798666666666666,303.42533333333347,537.76400000000012,17.436666666666675,14.436666666666673,13.685333333333336,9.7020000000000017,7.6566666666666663,8.8893333333333366,0]
[2.99,16.195999999999998,14.835999999999999,303.88600000000019,538.66200000000003,17.485000000000007,14.485000000000008,13.686000000000002,9.7210000000000036,7.6750000000000007,8.9130000000000038,0]
[3,16.233333333333331,14.873333333333331,304.34666666666681,539.56000000000006,17.533333333333339,14.53333333333334,13.686666666666669,9.740000000000002,7.6933333333333334,8.9366666666666692,0]
[3.01,16.270666666666664,14.910666666666664,304.80733333333347,540.45800000000008,17.581666666666671,14.581666666666672,13.687333333333337,9.7590000000000021,7.711666666666666,8.9603333333333346,0]
[3.02,{"$f":"IF($A221<=$A$24,FORECAST($A221,B$23:B$24,$A$23:$A$24),FORECAST($A221,B$24:B$25,$A$24:$A$25))","v":16.308},14.947999999999999,305.26800000000014,541.35599999999999,17.63000000000001,{"$f":"IF($A221<=$A$24,FORECAST($A221,F$23:F$24,$A$23:$A$24),FORECAST($A221,F$24:F$25,$A$24:$A$25))","v":14.630000000000008},13.688000000000002,9.7780000000000022,7.73,8.9840000000000018,0]
[3.03,16.345333333333329,14.985333333333331,305.72866666666681,542.25400000000002,17.678333333333342,14.67833333333334,13.68866666666667,9.7970000000000006,7.7483333333333331,9.0076666666666689,0]
[3.04,16.382666666666665,15.022666666666666,306.18933333333348,543.15200000000004,17.726666666666674,14.726666666666674,13.689333333333336,9.8160000000000025,7.7666666666666675,9.0313333333333361,0]
[3.05,16.419999999999995,15.059999999999997,306.65000000000015,544.04999999999995,17.775000000000006,14.775000000000006,13.690000000000003,9.8350000000000009,7.7850000000000001,9.0550000000000015,0]
[3.06,16.457333333333331,15.097333333333331,307.11066666666682,544.94800000000009,17.823333333333341,14.823333333333341,13.690666666666669,9.8540000000000028,7.8033333333333346,9.0786666666666687,0]
[3.07,16.494666666666664,15.134666666666664,307.57133333333348,545.846,17.871666666666673,14.871666666666673,13.691333333333336,9.8730000000000011,7.8216666666666672,9.1023333333333341,0]
[3.08,16.531999999999996,15.171999999999999,308.03200000000015,546.74400000000003,17.920000000000009,14.920000000000007,13.692000000000004,9.892000000000003,7.84,9.1260000000000012,0]
[3.09,16.569333333333333,15.209333333333332,308.49266666666682,547.64200000000005,17.968333333333341,14.968333333333341,13.692666666666669,9.9110000000000014,7.8583333333333343,9.1496666666666684,0]
[3.1,16.606666666666666,15.246666666666666,308.95333333333349,548.54000000000008,18.016666666666673,15.016666666666675,13.693333333333337,9.9300000000000033,7.8766666666666669,9.1733333333333356,0]
[3.11,16.643999999999998,15.283999999999997,309.41400000000016,549.4380000000001,18.065000000000005,15.065000000000007,13.694000000000003,9.9490000000000016,7.8949999999999996,9.1970000000000027,0]
[3.12,16.681333333333331,15.321333333333332,309.87466666666683,550.33600000000001,18.113333333333344,{"$f":"IF($A231<=$A$24,FORECAST($A231,F$23:F$24,$A$23:$A$24),FORECAST($A231,F$24:F$25,$A$24:$A$25))","v":15.113333333333342},13.69466666666667,9.9680000000000035,7.913333333333334,9.2206666666666699,0]