{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Indtast","Nøgletal","Grafik","Selskab"],"not_rendered":{"charts":4,"images":0,"macros":1,"external_links":0,"defined_names":26,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Indtast","index":0,"n_rows":98,"n_cols":29,"rows_kept":98,"cut":false,"hidden":false,"merged":[[5,16,5,17],[30,3,30,5]]}
[{"$f":"VLOOKUP($F$3,$AA$4:$AC$9,3)","v":"5 ÅRS OVERSIGT"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 31.05.13 CHA"]
["   Ejendom",null,null,null,null,1," Indtast 1 for % af DB og 2 for % af bruttoudbytte"]
["   Alternativ",null,null,null,null,5," år indtastet. Gennemsnit beregnes på basis af dette tal. Indtast fra år 1."]
["   Bruger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Gns 1 år","1 ÅRS OVERSIGT"]
["Moms",null,null,null,null,"a",null,"a",null,"a",null,"a",null,"a",null,null,null,null,null,null,null,null,null,null,null,null,2,"Gns 1 år","1 ÅRS OVERSIGT"]
["RESULTAT",null,null,null,null,2010,null,{"$f":"F6+1","v":2011},null,{"$f":"H6+1","v":2012},null,{"$f":"J6+1","v":2013},null,{"$f":"L6+1","v":2014},null,null,{"$f":"VLOOKUP($F$3,$AA$4:$AC$9,2)","v":"Gns 5 år"},null,null,null,null,null,null,null,null,null,2,"Gns 2 år","2 ÅRS OVERSIGT"]
[null,null,null,null,null,null,"%",null,"%",null,"%",null,"%",null,"%",null,null,"%",null,null,null,null,null,null,null,null,3,"Gns 3 år","3 ÅRS OVERSIGT"]
["Bruttoudbytte",null,null,null,null,null,{"$f":"IF(AntalÅr<F$98,\"\",IF($F$2=1,\"\",F8/F$8*100))","v":""},null,{"$f":"IF(AntalÅr<H$98,\"\",IF($F$2=1,\"\",H8/H$8*100))","v":""},null,{"$f":"IF(AntalÅr<J$98,\"\",IF($F$2=1,\"\",J8/J$8*100))","v":""},null,{"$f":"IF(AntalÅr<L$98,\"\",IF($F$2=1,\"\",L8/L$8*100))","v":""},null,{"$f":"IF(AntalÅr<N$98,\"\",IF($F$2=1,\"\",N8/N$8*100))","v":""},null,{"$f":"(N8+L8+J8+H8+F8)/F3","v":0},{"$f":"IF($F$2=1,\"\",Q8/Q$8*100)","v":""},null,null,null,null,null,null,null,null,4,"Gns 4 år","4 ÅRS OVERSIGT"]
["Stykomkostninger",null,null,null,null,null,{"$f":"IF(AntalÅr<F$98,\"\",IF($F$2=1,\"\",F9/F$8*100))","v":""},null,{"$f":"IF(AntalÅr<H$98,\"\",IF($F$2=1,\"\",H9/H$8*100))","v":""},null,{"$f":"IF(AntalÅr<J$98,\"\",IF($F$2=1,\"\",J9/J$8*100))","v":""},null,{"$f":"IF(AntalÅr<L$98,\"\",IF($F$2=1,\"\",L9/L$8*100))","v":""},null,{"$f":"IF(AntalÅr<N$98,\"\",IF($F$2=1,\"\",N9/N$8*100))","v":""},null,{"$f":"(N9+L9+J9+H9+F9)/F3","v":0},{"$f":"IF($F$2=1,\"\",Q9/Q$8*100)","v":""},null,null,null,null,null,null,null,null,5,"Gns 5 år","5 ÅRS OVERSIGT"]
[{"$f":"IF(F2=1,\"Dækningsbidrag\",\"Dækningsbidrag   /   Dækningsgrad\")","v":"Dækningsbidrag"},null,null,null,null,{"$f":"F8+F9","v":0},{"$f":"IF(AntalÅr<F$98,\"\",IF($F$2=1,F10/F$10*100,F10/F$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"H8+H9","v":0},{"$f":"IF(AntalÅr<H$98,\"\",IF($F$2=1,H10/H$10*100,H10/H$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"J8+J9","v":0},{"$f":"IF(AntalÅr<J$98,\"\",IF($F$2=1,J10/J$10*100,J10/J$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"L8+L9","v":0},{"$f":"IF(AntalÅr<L$98,\"\",IF($F$2=1,L10/L$10*100,L10/L$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"N8+N9","v":0},{"$f":"IF(AntalÅr<N$98,\"\",IF($F$2=1,N10/N$10*100,N10/N$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"(N10+L10+J10+H10+F10)/F3","v":0},{"$f":"IF($F$2=1,Q10/Q$10*100,Q10/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Lønomkostninger",null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N11+L11+J11+H11+F11)/F3","v":0},{"$f":"IF($F$2=1,Q11/Q$10*100,Q11/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Andre kapacitetsomkostninger",null,null,null,{"$f":"F13-F11","v":0},{"$error":"#DIV/0!"},{"$f":"H13-H11","v":0},{"$error":"#DIV/0!"},{"$f":"J13-J11","v":0},{"$error":"#DIV/0!"},{"$f":"L13-L11","v":0},{"$error":"#DIV/0!"},{"$f":"N13-N11","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N12+L12+J12+H12+F12)/F3","v":0},{"$error":"#DIV/0!"}]
["Kontante kapacitetsomkostninger",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N13+L13+J13+H13+F13)/F3","v":0},{"$error":"#DIV/0!"}]
["Af- og nedskrivninger mv.",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N14+L14+J14+H14+F14)/F3","v":0},{"$error":"#DIV/0!"}]
["Resultat af primær drift",null,null,null,null,{"$f":"F10+F14+F13","v":0},{"$error":"#DIV/0!"},{"$f":"H10+H14+H13","v":0},{"$error":"#DIV/0!"},{"$f":"J10+J14+J13","v":0},{"$error":"#DIV/0!"},{"$f":"L10+L14+L13","v":0},{"$error":"#DIV/0!"},{"$f":"N10+N14+N13","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N15+L15+J15+H15+F15)/F3","v":0},{"$f":"IF($F$2=1,Q15/Q$10*100,Q15/Q$8*100)","v":{"$error":"#DIV/0!"}}]
["Anden indtjening/anden virksomhed",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N16+L16+J16+H16+F16)/F3","v":0},{"$error":"#DIV/0!"}]
["Afkoblet EU støtte",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N17+L17+J17+H17+F17)/F3","v":0},{"$f":"IF($F$2=1,Q17/Q$10*100,Q17/Q$8*100)","v":{"$error":"#DIV/0!"}}]
["Resultat før finansiering",null,null,null,null,{"$f":"SUM(F15:F17)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(H15:H17)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(J15:J17)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(L15:L17)","v":0},{"$error":"#DIV/0!"},{"$f":"SUM(N15:N17)","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N18+L18+J18+H18+F18)/F3","v":0},{"$f":"IF($F$2=1,Q18/Q$10*100,Q18/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Forpagtningsafgift",null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N19+L19+J19+H19+F19)/F3","v":0},{"$error":"#DIV/0!"}]
[null,"Finansiering i øvrigt",null,null,null,{"$f":"F21-F19","v":0},{"$error":"#DIV/0!"},{"$f":"H21-H19","v":0},{"$error":"#DIV/0!"},{"$f":"J21-J19","v":0},{"$error":"#DIV/0!"},{"$f":"L21-L19","v":0},{"$error":"#DIV/0!"},{"$f":"N21-N19","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N20+L20+J20+H20+F20)/F3","v":0},{"$error":"#DIV/0!"}]
["Finansiering i alt",null,null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N21+L21+J21+H21+F21)/F3","v":0},{"$error":"#DIV/0!"}]
["Resultat efter finansiering",null,null,null,null,{"$f":"F15+F16+F21+F17","v":0},{"$error":"#DIV/0!"},{"$f":"H15+H16+H21+H17","v":0},{"$error":"#DIV/0!"},{"$f":"J15+J16+J21+J17","v":0},{"$error":"#DIV/0!"},{"$f":"L15+L16+L21+L17","v":0},{"$error":"#DIV/0!"},{"$f":"N15+N16+N21+N17","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N22+L22+J22+H22+F22)/F3","v":0},{"$error":"#DIV/0!"}]
[null,"Private indtægter",null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N23+L23+J23+H23+F23)/F3","v":0},{"$f":"IF($F$2=1,Q23/Q$10*100,Q23/Q$8*100)","v":{"$error":"#DIV/0!"}}]
["Resultat før regulering og skat",null,null,null,null,{"$f":"F22+F23","v":0},{"$error":"#DIV/0!"},{"$f":"H22+H23","v":0},{"$error":"#DIV/0!"},{"$f":"J22+J23","v":0},{"$error":"#DIV/0!"},{"$f":"L22+L23","v":0},{"$error":"#DIV/0!"},{"$f":"N22+N23","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N24+L24+J24+H24+F24)/F3","v":0},{"$error":"#DIV/0!"}]
[null,"Regulering i alt",null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N25+L25+J25+H25+F25)/F3","v":0},{"$error":"#DIV/0!"}]
["Årets resultat før skat",null,null,null,null,{"$f":"F24+F25","v":0},{"$error":"#DIV/0!"},{"$f":"H24+H25","v":0},{"$error":"#DIV/0!"},{"$f":"J24+J25","v":0},{"$error":"#DIV/0!"},{"$f":"L24+L25","v":0},{"$error":"#DIV/0!"},{"$f":"N24+N25","v":0},{"$error":"#DIV/0!"},null,{"$f":"Q24+Q25","v":0},{"$error":"#DIV/0!"}]
[null,"Skat af årets resultat",null,null,null,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"(N27+L27+J27+H27+F27)/F3","v":0},{"$error":"#DIV/0!"}]
["Årets resultat",null,null,null,null,{"$f":"F26+F27","v":0},{"$error":"#DIV/0!"},{"$f":"H26+H27","v":0},{"$error":"#DIV/0!"},{"$f":"J26+J27","v":0},{"$error":"#DIV/0!"},{"$f":"L26+L27","v":0},{"$error":"#DIV/0!"},{"$f":"N26+N27","v":0},{"$error":"#DIV/0!"},null,{"$f":"(N28+L28+J28+H28+F28)/F3","v":0},{"$error":"#DIV/0!"}]
[]
[]
["BALANCE",null,null,{"$f":"F42","v":2010},null,null,null,{"$f":"H42","v":2011},null,{"$f":"J42","v":2012},null,{"$f":"L42","v":2013},null,{"$f":"N42","v":2014}]
[]
["Aktiver, gæld og egenkapital",null,null,"primo",null,"ultimo",null,"ultimo",null,"ultimo",null,"ultimo",null,"ultimo"]
["Landbrugsaktiver"]
["Andre aktiver"]
["Aktiver i alt",null,null,{"$f":"D34+D35","v":0},null,{"$f":"F34+F35","v":0},null,{"$f":"H34+H35","v":0},null,{"$f":"J34+J35","v":0},null,{"$f":"L34+L35","v":0},null,{"$f":"N34+N35","v":0}]
["Gæld i alt",null,null,null,null,{"$f":"D37","v":0}]
["Hensættelser",null,null,0,null,0]
["Egenkapital",null,null,{"$f":"D36+D37+D38","v":0},null,{"$f":"F36+F37+F38","v":0},null,{"$f":"H36+H37+H38","v":0},null,{"$f":"J36+J37+J38","v":0},null,{"$f":"L36+L37+L38","v":0},null,{"$f":"N36+N37+N38","v":0}]
[]
[]
["VANDRET INDEKS",null,null,null,null,{"$f":"Nøgletal!F5","v":2010},null,{"$f":"Nøgletal!H5","v":2011},null,{"$f":"Nøgletal!J5","v":2012},null,{"$f":"Nøgletal!L5","v":2013},null,{"$f":"Nøgletal!N5","v":2014}]
["    Svinenotering/mælkepris"]
[null,"Prisindeks",null,null,null,100,null,{"$f":"IF(ISBLANK($F43),0,H43/($F43+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F43),0,J43/($F43+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F43),0,L43/($F43+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F43),0,N43/($F43+0.000001)*100)","v":0}]
["Bruttoudbytte",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F8),0,H8/($F8+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F8),0,J8/($F8+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F8),0,L8/($F8+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F8),0,N8/($F8+0.000001)*100)","v":0}]
["Stykomkostninger",null,null,null,null,100,null,0,null,0,null,0,null,0]
[{"$f":"IF(F39=1,\"Dækningsbidrag\",\"Dækningsbidrag   /   Dækningsgrad\")","v":"Dækningsbidrag   /   Dækningsgrad"},null,null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Lønomkostninger",null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Andre kapacitetsomkostninger",null,null,null,100,null,0,null,0,null,0,null,0]
["Kontante kapacitetsomkostninger",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Driftsmæssige afskrivninger",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Resultat af primær drift",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Anden indtjening",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Afkoblet EU støtte",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Resultat før finansiering",null,null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Forpagtningsafgift",null,null,null,100,null,{"$f":"IF(ISBLANK($F19),0,H19/($F19+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F19),0,J19/($F19+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F19),0,L19/($F19+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F19),0,N19/($F19+0.000001)*100)","v":0}]
[null,"Finansiering i øvrigt",null,null,null,100,null,0,null,0,null,0,null,0]
["Finansiering i alt",null,null,null,null,100,null,0,null,0,null,0,null,0]
["Resultat efter finansiering",null,null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Private indtægter",null,null,null,100,null,0,null,0,null,0,null,0]
["Resultat før regulering og skat",null,null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Regulering i alt",null,null,null,100,null,0,null,0,null,0,null,0]
["Årets resultat før skat",null,null,null,null,100,null,0,null,0,null,0,null,0]
[null,"Skat af årets resultat",null,null,null,100,null,0,null,0,null,0,null,0]
["Årets resultat",null,null,null,null,100,null,0,null,0,null,0,null,0]
[]
["STATUS"]
[]
["Aktiver, gæld og egenkapital"]
["Landbrugsaktiver",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F34),0,H34/($F34+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F34),0,J34/($F34+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F34),0,L34/($F34+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F34),0,N34/($F34+0.000001)*100)","v":0}]
["Andre aktiver",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F35),0,H35/($F35+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F35),0,J35/($F35+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F35),0,L35/($F35+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F35),0,N35/($F35+0.000001)*100)","v":0}]
["I alt aktiver",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F36),0,H36/($F36+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F36),0,J36/($F36+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F36),0,L36/($F36+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F36),0,N36/($F36+0.000001)*100)","v":0}]
["Gæld i alt",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F37),0,H37/($F37+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F37),0,J37/($F37+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F37),0,L37/($F37+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F37),0,N37/($F37+0.000001)*100)","v":0}]
["Hensættelser",null,null,null,null,100,null,{"$f":"IF(ISBLANK($F38),0,H38/($F38+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F38),0,J38/($F38+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F38),0,L38/($F38+0.000001)*100)","v":0},null,{"$f":"IF(ISBLANK($F38),0,N38/($F38+0.000001)*100)","v":0}]
["Egenkapital",null,null,null,null,100,null,0,null,0,null,0,null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"D3","v":0}]
[]
[null,null,null,null,null,1,null,2,null,3,null,4,null,5]

{"sheet":"Nøgletal","index":1,"n_rows":99,"n_cols":17,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["NØGLETALSBEREGNING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!R1","v":"© 31.05.13 CHA"}]
[null,{"$f":"Indtast!B2","v":0}]
[null,{"$f":"Indtast!B3","v":0}]
[null,{"$f":"Indtast!B4","v":0}]
[null,null,null,null,null,{"$f":"Indtast!F6","v":2010},null,{"$f":"Indtast!H6","v":2011},null,{"$f":"Indtast!J6","v":2012},null,{"$f":"Indtast!L6","v":2013},null,{"$f":"Indtast!N6","v":2014},null,null,"Eks."]
[null,"Arbejdstimer totalt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,4500]
[null,"Medhjælpers arbejdstimer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1665]
[null,"Familiens arbejdstimer",null,null,null,{"$f":"F6-F7","v":0},null,{"$f":"H6-H7","v":0},null,{"$f":"J6-J7","v":0},null,{"$f":"L6-L7","v":0},null,{"$f":"N6-N7","v":0}]
[null,"Timesats",null,null,null,null,null,null,null,null,null,null,null,null,null,null,184]
[null,"Enten beregnet arbejdsvederlag, 1.000 kr",null,null,null,{"$f":"F8*F9/1000","v":0},null,{"$f":"H8*H9/1000","v":0},null,{"$f":"J8*J9/1000","v":0},null,{"$f":"L8*L9/1000","v":0},null,{"$f":"N8*N9/1000","v":0}]
[null,"eller direkte indtastet, 1.000 kr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"450  (en årsløn uanset antal timer)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!Q6","v":"Gns 5 år"}]
[null,"Resultat før finansiering",null,null,null,{"$f":"Indtast!F18","v":0},null,{"$f":"Indtast!H18","v":0},null,{"$f":"Indtast!J18","v":0},null,{"$f":"Indtast!L18","v":0},null,{"$f":"Indtast!N18","v":0},null,{"$f":"SUM(F13:N13)/Indtast!$F$3","v":0}]
[null," - forpagtningsafgift",null,null,null,{"$f":"Indtast!F19","v":0},null,{"$f":"Indtast!H19","v":0},null,{"$f":"Indtast!J19","v":0},null,{"$f":"Indtast!L19","v":0},null,{"$f":"Indtast!N19","v":0},null,{"$f":"SUM(F14:N14)/Indtast!$F$3","v":0}]
[null," - familiens arbejdsvederlag",null,null,null,{"$f":"IF(ISBLANK(F11),F10/-1,F11/-1)","v":0},null,{"$f":"IF(ISBLANK(H11),H10/-1,H11/-1)","v":0},null,{"$f":"IF(ISBLANK(J11),J10/-1,J11/-1)","v":0},null,{"$f":"IF(ISBLANK(L11),L10/-1,L11/-1)","v":0},null,{"$f":"IF(ISBLANK(N11),N10/-1,N11/-1)","v":0},null,{"$f":"SUM(F15:N15)/Indtast!$F$3","v":0}]
[null,"Nettoudbytte",null,null,null,{"$f":"SUM(F13:F15)","v":0},null,{"$f":"SUM(H13:H15)","v":0},null,{"$f":"SUM(J13:J15)","v":0},null,{"$f":"SUM(L13:L15)","v":0},null,{"$f":"SUM(N13:N15)","v":0},null,{"$f":"SUM(F16:N16)/Indtast!$F$3","v":0}]
[]
[null,"Afkastningsgrad"]
[null,"Nettoudbytte",null,null,null,{"$f":"F16","v":0},null,{"$f":"H16","v":0},null,{"$f":"J16","v":0},null,{"$f":"L16","v":0},null,{"$f":"N16","v":0}]
[null," / aktiver i alt i gns. * 100",null,null,null,{"$f":"IF(AntalÅr<F99,\"\",(Indtast!D36+Indtast!F36)/2)","v":0},null,{"$f":"IF(AntalÅr<H99,\"\",(Indtast!F36+Indtast!H36)/2)","v":0},null,{"$f":"IF(AntalÅr<J99,\"\",(Indtast!H36+Indtast!J36)/2)","v":0},null,{"$f":"IF(AntalÅr<L99,\"\",(Indtast!J36+Indtast!L36)/2)","v":0},null,{"$f":"IF(AntalÅr<N99,\"\",(Indtast!L36+Indtast!N36)/2)","v":0}]
["Afkastningsgrad (AG):",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F19/F20)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H19/H20)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J19/J20)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L19/L20)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N19/N20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F21:N21)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Overskudsgrad"]
[null,"Nettoudbytte",null,null,null,{"$f":"F16","v":0},null,{"$f":"H16","v":0},null,{"$f":"J16","v":0},null,{"$f":"L16","v":0},null,{"$f":"N16","v":0}]
[null," / bruttoudbytte",null,null,null,{"$f":"F29","v":0},null,{"$f":"H29","v":0},null,{"$f":"J29","v":0},null,{"$f":"L29","v":0},null,{"$f":"N29","v":0}]
["Overskudsgrad (OG):",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F24/F25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H24/H25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J24/J25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L24/L25)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N24/N25)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F26:N26)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Aktivernes omsætningshastighed"]
[null,"Bruttoudbytte",null,null,null,{"$f":"Indtast!F8","v":0},null,{"$f":"Indtast!H8","v":0},null,{"$f":"Indtast!J8","v":0},null,{"$f":"Indtast!L8","v":0},null,{"$f":"Indtast!N8","v":0}]
[null," / aktiver i alt i gns.",null,null,null,{"$f":"F20","v":0},null,{"$f":"H20","v":0},null,{"$f":"J20","v":0},null,{"$f":"L20","v":0},null,{"$f":"N20","v":0}]
["Aktivernes omsætningshastighed (AOH)",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F29/F30)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H29/H30)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J29/J30)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L29/L30)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N29/N30)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F31:N31)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Egenkapitalens forrentning "]
[null,"Nettoudbytte",null,null,null,{"$f":"F19","v":0},null,{"$f":"H19","v":0},null,{"$f":"J19","v":0},null,{"$f":"L19","v":0},null,{"$f":"N19","v":0}]
[null," - finansieringsomkostninger",null,null,null,{"$f":"Indtast!F21-Indtast!F19","v":0},null,{"$f":"Indtast!H21-Indtast!H19","v":0},null,{"$f":"Indtast!J21-Indtast!J19","v":0},null,{"$f":"Indtast!L21-Indtast!L19","v":0},null,{"$f":"Indtast!N21-Indtast!N19","v":0}]
[null," = rest til forrentning af egenkapital",null,null,null,{"$f":"F34+F35","v":0},null,{"$f":"H34+H35","v":0},null,{"$f":"J34+J35","v":0},null,{"$f":"L34+L35","v":0},null,{"$f":"N34+N35","v":0}]
[null," / egenkapital gns. * 100",null,null,null,{"$f":"IF(AntalÅr<F99,\"\",(Indtast!D39+Indtast!F39)/2)","v":0},null,{"$f":"IF(AntalÅr<H99,\"\",(Indtast!F39+Indtast!H39)/2)","v":0},null,{"$f":"IF(AntalÅr<J99,\"\",(Indtast!H39+Indtast!J39)/2)","v":0},null,{"$f":"IF(AntalÅr<L99,\"\",(Indtast!J39+Indtast!L39)/2)","v":0},null,{"$f":"IF(AntalÅr<N99,\"\",(Indtast!L39+Indtast!N39)/2)","v":0}]
["Egenkapitalens forrentning (EKF):",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",IF(F37<0,\"Neg. EK\",F36/F37))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",IF(H37<0,\"Neg. EK\",H36/H37))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",IF(J37<0,\"Neg. EK\",J36/J37))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",IF(L37<0,\"Neg. EK\",L36/L37))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",IF(N37<0,\"Neg. EK\",N36/N37))","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F38:N38)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Gældsrente"]
[null,"Finansiering excl. forpagtning",null,null,null,{"$f":"Indtast!F20","v":0},null,{"$f":"Indtast!H20","v":0},null,{"$f":"Indtast!J20","v":0},null,{"$f":"Indtast!L20","v":0},null,{"$f":"Indtast!N20","v":0}]
[null," / gæld+hensættelser gns. *100",null,null,null,{"$f":"IF(AntalÅr<F99,\"\",(Indtast!D37+Indtast!F37+Indtast!D38+Indtast!F38)/2)","v":0},null,{"$f":"IF(AntalÅr<H99,\"\",(Indtast!F37+Indtast!H37+Indtast!F38+Indtast!H38)/2)","v":0},null,{"$f":"IF(AntalÅr<J99,\"\",(Indtast!H37+Indtast!J37+Indtast!H38+Indtast!J38)/2)","v":0},null,{"$f":"IF(AntalÅr<L99,\"\",(Indtast!J37+Indtast!L37+Indtast!J38+Indtast!L38)/2)","v":0},null,{"$f":"IF(AntalÅr<N99,\"\",(Indtast!L37+Indtast!N37+Indtast!L38+Indtast!N38)/2)","v":0}]
["Gældsrente (GR):",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F41/F42)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H41/H42)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J41/J42)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L41/L42)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N41/N42)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F43:N43)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Gældsprocent"]
[null,"Gæld+hensættelser i alt",null,"Ultimo",null,{"$f":"(Indtast!F37+Indtast!F38)/-1","v":0},null,{"$f":"(Indtast!H37+Indtast!H38)/-1","v":0},null,{"$f":"(Indtast!J37+Indtast!J38)/-1","v":0},null,{"$f":"(Indtast!L37+Indtast!L38)/-1","v":0},null,{"$f":"(Indtast!N37+Indtast!N38)/-1","v":0}]
[null," / passiver i alt*100",null,"Ultimo",null,{"$f":"Indtast!F36","v":0},null,{"$f":"Indtast!H36","v":0},null,{"$f":"Indtast!J36","v":0},null,{"$f":"Indtast!L36","v":0},null,{"$f":"Indtast!N36","v":0}]
["Gældsprocent",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F46/F47)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H46/H47)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J46/J47)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L46/L47)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N46/N47)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F48:N48)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[null,"Lønningsevne"]
[null,"Resultat før finansiering",null,null,null,{"$f":"F13","v":0},null,{"$f":"H13","v":0},null,{"$f":"J13","v":0},null,{"$f":"L13","v":0},null,{"$f":"N13","v":0}]
[null," + lønomkostninger",null,null,null,{"$f":"Indtast!F11*-1","v":0},null,{"$f":"Indtast!H11*-1","v":0},null,{"$f":"Indtast!J11*-1","v":0},null,{"$f":"Indtast!L11*-1","v":0},null,{"$f":"Indtast!N11*-1","v":0}]
[null," - 4 pct. rente af egne aktiver i alt",null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F30*-0.04)","v":0},null,{"$f":"IF(AntalÅr<H99,\"\",H30*-0.04)","v":0},null,{"$f":"IF(AntalÅr<J99,\"\",J30*-0.04)","v":0},null,{"$f":"IF(AntalÅr<L99,\"\",L30*-0.04)","v":0},null,{"$f":"IF(AntalÅr<N99,\"\",N30*-0.04)","v":0}]
[null," - forpagtningsafgift",null,null,null,{"$f":"Indtast!F19","v":0},null,{"$f":"Indtast!H19","v":0},null,{"$f":"Indtast!J19","v":0},null,{"$f":"Indtast!L19","v":0},null,{"$f":"Indtast!N19","v":0}]
[null,"Lønningsevne i alt",null,null,null,{"$f":"SUM(F51:F54)","v":0},null,{"$f":"SUM(H51:H54)","v":0},null,{"$f":"SUM(J51:J54)","v":0},null,{"$f":"SUM(L51:L54)","v":0},null,{"$f":"SUM(N51:N54)","v":0}]
["Lønningsevne, kr. pr. time",null,null,null,null,{"$f":"IF(AntalÅr<F99,\"\",F55/F6*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<H99,\"\",H55/H6*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<J99,\"\",J55/J6*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<L99,\"\",L55/L6*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalÅr<N99,\"\",N55/N6*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(F56:N56)/Indtast!$F$3","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,null,2,null,3,null,4,null,5]

{"sheet":"Grafik","index":2,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Grafik"]
[null,{"$f":"Indtast!B2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Grafik data"]
[null,{"$f":"Indtast!B3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!F6","v":2010},{"$f":"W3+1","v":2011},{"$f":"X3+1","v":2012},{"$f":"Y3+1","v":2013},{"$f":"Z3+1","v":2014}]
[null,{"$f":"Indtast!B4","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A8","v":"Bruttoudbytte"},{"$f":"Indtast!F8","v":0},null,{"$f":"Indtast!H8","v":0},null,{"$f":"Indtast!J8","v":0},null,{"$f":"Indtast!L8","v":0},null,{"$f":"Indtast!N8","v":0},null,{"$f":"M5","v":0},{"$f":"O5","v":0},{"$f":"Q5","v":0},{"$f":"S5","v":0},{"$f":"U5","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A9","v":"Stykomkostninger"},{"$f":"Indtast!F9","v":0},null,{"$f":"Indtast!H9","v":0},null,{"$f":"Indtast!J9","v":0},null,{"$f":"Indtast!L9","v":0},null,{"$f":"Indtast!N9","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Dækningsbidrag",{"$f":"Indtast!F10","v":0},null,{"$f":"Indtast!H10","v":0},null,{"$f":"Indtast!J10","v":0},null,{"$f":"Indtast!L10","v":0},null,{"$f":"Indtast!N10","v":0},null,{"$f":"M7","v":0},{"$f":"O7","v":0},{"$f":"Q7","v":0},{"$f":"S7","v":0},{"$f":"U7","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A11","v":0},{"$f":"Indtast!F11","v":0},null,{"$f":"Indtast!H11","v":0},null,{"$f":"Indtast!J11","v":0},null,{"$f":"Indtast!L11","v":0},null,{"$f":"Indtast!N11","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A12","v":0},{"$f":"Indtast!F12","v":0},null,{"$f":"Indtast!H12","v":0},null,{"$f":"Indtast!J12","v":0},null,{"$f":"Indtast!L12","v":0},null,{"$f":"Indtast!N12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A13","v":"Kontante kapacitetsomkostninger"},{"$f":"Indtast!F13","v":0},null,{"$f":"Indtast!H13","v":0},null,{"$f":"Indtast!J13","v":0},null,{"$f":"Indtast!L13","v":0},null,{"$f":"Indtast!N13","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A14","v":"Af- og nedskrivninger mv."},{"$f":"Indtast!F14","v":0},null,{"$f":"Indtast!H14","v":0},null,{"$f":"Indtast!J14","v":0},null,{"$f":"Indtast!L14","v":0},null,{"$f":"Indtast!N14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A15","v":"Resultat af primær drift"},{"$f":"Indtast!F15","v":0},null,{"$f":"Indtast!H15","v":0},null,{"$f":"Indtast!J15","v":0},null,{"$f":"Indtast!L15","v":0},null,{"$f":"Indtast!N15","v":0},null,{"$f":"M12","v":0},{"$f":"O12","v":0},{"$f":"Q12","v":0},{"$f":"S12","v":0},{"$f":"U12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A16","v":"Anden indtjening/anden virksomhed"},{"$f":"Indtast!F16","v":0},null,{"$f":"Indtast!H16","v":0},null,{"$f":"Indtast!J16","v":0},null,{"$f":"Indtast!L16","v":0},null,{"$f":"Indtast!N16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A19","v":0},{"$f":"Indtast!F19","v":0},null,{"$f":"Indtast!H19","v":0},null,{"$f":"Indtast!J19","v":0},null,{"$f":"Indtast!L19","v":0},null,{"$f":"Indtast!N19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A20","v":0},{"$f":"Indtast!F20","v":0},null,{"$f":"Indtast!H20","v":0},null,{"$f":"Indtast!J20","v":0},null,{"$f":"Indtast!L20","v":0},null,{"$f":"Indtast!N20","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A21","v":"Finansiering i alt"},{"$f":"Indtast!F21","v":0},null,{"$f":"Indtast!H21","v":0},null,{"$f":"Indtast!J21","v":0},null,{"$f":"Indtast!L21","v":0},null,{"$f":"Indtast!N21","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A22","v":"Resultat efter finansiering"},{"$f":"Indtast!F22","v":0},null,{"$f":"Indtast!H22","v":0},null,{"$f":"Indtast!J22","v":0},null,{"$f":"Indtast!L22","v":0},null,{"$f":"Indtast!N22","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A25","v":0},{"$f":"Indtast!F25","v":0},null,{"$f":"Indtast!H25","v":0},null,{"$f":"Indtast!J25","v":0},null,{"$f":"Indtast!L25","v":0},null,{"$f":"Indtast!N25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Resultat før skat",{"$f":"Indtast!F26","v":0},null,{"$f":"Indtast!H26","v":0},null,{"$f":"Indtast!J26","v":0},null,{"$f":"Indtast!L26","v":0},null,{"$f":"Indtast!N26","v":0},null,{"$f":"M19","v":0},{"$f":"O19","v":0},{"$f":"Q19","v":0},{"$f":"S19","v":0},{"$f":"U19","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A27","v":0},{"$f":"Indtast!F27","v":0},null,{"$f":"Indtast!H27","v":0},null,{"$f":"Indtast!J27","v":0},null,{"$f":"Indtast!L27","v":0},null,{"$f":"Indtast!N27","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A29","v":0},{"$f":"Indtast!F29","v":0},null,{"$f":"Indtast!H29","v":0},null,{"$f":"Indtast!J29","v":0},null,{"$f":"Indtast!L29","v":0},null,{"$f":"Indtast!N29","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Konsolidering",{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"Indtast!#REF!","v":{"$error":"#REF!"}},null,{"$f":"M27","v":{"$error":"#REF!"}},{"$f":"O27","v":{"$error":"#REF!"}},{"$f":"Q27","v":{"$error":"#REF!"}},{"$f":"S27","v":{"$error":"#REF!"}},{"$f":"U27","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A30","v":0},{"$f":"Indtast!F30","v":0},null,{"$f":"Indtast!H30","v":0},null,{"$f":"Indtast!J30","v":0},null,{"$f":"Indtast!L30","v":0},null,{"$f":"Indtast!N30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A31","v":"BALANCE"},{"$f":"Indtast!D31","v":2010},null,{"$f":"Indtast!H31","v":2011},null,{"$f":"Indtast!J31","v":2012},null,{"$f":"Indtast!L31","v":2013},null,{"$f":"Indtast!N31","v":2014}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A32","v":0},{"$f":"Indtast!F32","v":0},null,{"$f":"Indtast!H32","v":0},null,{"$f":"Indtast!J32","v":0},null,{"$f":"Indtast!L32","v":0},null,{"$f":"Indtast!N32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A33","v":"Aktiver, gæld og egenkapital"},{"$f":"Indtast!F33","v":"ultimo"},null,{"$f":"Indtast!H33","v":"ultimo"},null,{"$f":"Indtast!J33","v":"ultimo"},null,{"$f":"Indtast!L33","v":"ultimo"},null,{"$f":"Indtast!N33","v":"ultimo"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A34","v":"Landbrugsaktiver"},{"$f":"Indtast!F34","v":0},null,{"$f":"Indtast!H34","v":0},null,{"$f":"Indtast!J34","v":0},null,{"$f":"Indtast!L34","v":0},null,{"$f":"Indtast!N34","v":0},{"$f":"L32","v":"Landbrugsaktiver"},0,{"$f":"O32","v":0},{"$f":"Q32","v":0},{"$f":"S32","v":0},{"$f":"U32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A35","v":"Andre aktiver"},{"$f":"Indtast!F35","v":0},null,{"$f":"Indtast!H35","v":0},null,{"$f":"Indtast!J35","v":0},null,{"$f":"Indtast!L35","v":0},null,{"$f":"Indtast!N35","v":0},"Andre aktiver",0,{"$f":"O33","v":0},{"$f":"Q33","v":0},{"$f":"S33","v":0},{"$f":"U33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A36","v":"Aktiver i alt"},{"$f":"Indtast!F36","v":0},null,{"$f":"Indtast!H36","v":0},null,{"$f":"Indtast!J36","v":0},null,{"$f":"Indtast!L36","v":0},null,{"$f":"Indtast!N36","v":0},"Aktiver i alt",0,{"$f":"O34","v":0},{"$f":"Q34","v":0},{"$f":"S34","v":0},{"$f":"U34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A37","v":"Gæld i alt"},{"$f":"Indtast!F37","v":0},null,{"$f":"Indtast!H37","v":0},null,{"$f":"Indtast!J37","v":0},null,{"$f":"Indtast!L37","v":0},null,{"$f":"Indtast!N37","v":0},"Gæld",{"$f":"M35*-1","v":0},{"$f":"O35*-1","v":0},{"$f":"Q35*-1","v":0},{"$f":"S35*-1","v":0},{"$f":"U35*-1","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!A39","v":"Egenkapital"},{"$f":"Indtast!F39","v":0},null,{"$f":"Indtast!H39","v":0},null,{"$f":"Indtast!J39","v":0},null,{"$f":"Indtast!L39","v":0},null,{"$f":"Indtast!N39","v":0},"Egenkapital",{"$f":"M36","v":0},{"$f":"O36","v":0},{"$f":"Q36","v":0},{"$f":"S36","v":0},{"$f":"U36","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Nøgletal",null,null,null,null,null,null,null,null,null,null,{"$f":"W3","v":2010},{"$f":"X3","v":2011},{"$f":"Y3","v":2012},{"$f":"Z3","v":2013},{"$f":"AA3","v":2014}]
[null,null,null,null,null,null,null,null,null,null,null,"Afkastningsgrad (AG):",{"$f":"Nøgletal!F21","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!H21","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!J21","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!L21","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!N21","v":{"$error":"#DIV/0!"}},{"$f":"L49","v":"Afkastningsgrad (AG):"},{"$error":"#DIV/0!"},{"$f":"O49","v":{"$error":"#DIV/0!"}},{"$f":"Q49","v":{"$error":"#DIV/0!"}},{"$f":"S49","v":{"$error":"#DIV/0!"}},{"$f":"U49","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Egenkapitalens forrentning (EKF):",{"$f":"Nøgletal!F38","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!H38","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!J38","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!L38","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!N38","v":{"$error":"#DIV/0!"}},"Egenkapitalens forrentning (EKF):",{"$error":"#DIV/0!"},{"$f":"O50","v":{"$error":"#DIV/0!"}},{"$f":"Q50","v":{"$error":"#DIV/0!"}},{"$f":"S50","v":{"$error":"#DIV/0!"}},{"$f":"U50","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Gældsrente (GR):",{"$f":"Nøgletal!F43","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!H43","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!J43","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!L43","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!N43","v":{"$error":"#DIV/0!"}},"Gældsrente (GR):",{"$error":"#DIV/0!"},{"$f":"O51","v":{"$error":"#DIV/0!"}},{"$f":"Q51","v":{"$error":"#DIV/0!"}},{"$f":"S51","v":{"$error":"#DIV/0!"}},{"$f":"U51","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Nøgletal!A48","v":"Gældsprocent"},{"$f":"Nøgletal!F48","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!H48","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!J48","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!L48","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!N48","v":{"$error":"#DIV/0!"}},{"$f":"L52","v":"Gældsprocent"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Lønningsevne",{"$f":"Nøgletal!F56","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!H56","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!J56","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!L56","v":{"$error":"#DIV/0!"}},null,{"$f":"Nøgletal!N56","v":{"$error":"#DIV/0!"}},null,{"$f":"M55","v":{"$error":"#DIV/0!"}},{"$f":"O55","v":{"$error":"#DIV/0!"}},{"$f":"Q55","v":{"$error":"#DIV/0!"}},{"$f":"S55","v":{"$error":"#DIV/0!"}},{"$f":"U55","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Prisindeks",{"$f":"Indtast!F43","v":0},null,{"$f":"Indtast!H43","v":0},null,{"$f":"Indtast!J43","v":0},null,{"$f":"Indtast!L43","v":0},null,{"$f":"Indtast!N43","v":0},"kr/kg",{"$f":"M56","v":0},{"$f":"O56","v":0},{"$f":"Q56","v":0},{"$f":"S56","v":0},{"$f":"U56","v":0}]

{"sheet":"Selskab","index":3,"n_rows":120,"n_cols":29,"rows_kept":120,"cut":false,"hidden":false,"merged":[[5,16,5,17],[35,3,35,5]]}
[{"$f":"VLOOKUP($F$3,$AA$4:$AC$8,3)","v":"5 ÅRS OVERSIGT SELSKAB"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!R1","v":"© 31.05.13 CHA"}]
["   Ejendom",null,null,null,null,2," Indtast 1 for % af Bruttofortjeneste 1 og 2 for % af Nettoomsætning"]
["   Alternativ",null,null,null,null,5," år indtastet. Gennemsnit beregnes på basis af dette tal. Indtast fra år 1."]
["   Bruger",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"Gns 1 år","1 ÅRS OVERSIGT SELSKAB"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,"Gns 2 år","2 ÅRS OVERSIGT SELSKAB"]
["RESULTAT",null,null,null,null,2008,null,{"$f":"F6+1","v":2009},null,{"$f":"H6+1","v":2010},null,{"$f":"J6+1","v":2011},null,{"$f":"L6+1","v":2012},null,null,{"$f":"VLOOKUP($F$3,$AA$4:$AC$8,2)","v":"Gns 5 år"},null,null,null,null,null,null,null,null,null,3,"Gns 3 år","3 ÅRS OVERSIGT SELSKAB"]
[null,null,null,null,null,null,"%",null,"%",null,"%",null,"%",null,"%",null,null,"%",null,null,null,null,null,null,null,null,4,"Gns 4 år","4 ÅRS OVERSIGT SELSKAB"]
[null,"Nettoomsætning",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,\"\",F8/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,\"\",H8/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,\"\",J8/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,\"\",L8/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,\"\",N8/N$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"(F8+H8+J8+L8+N8)/AntalSelskabsÅr","v":0},{"$f":"IF($F$2=1,\"\",Q8/Q$8*100)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,5,"Gns 5 år","5 ÅRS OVERSIGT SELSKAB"]
[null,"Ændring i varelager",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,\"\",F9/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,\"\",H9/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,\"\",J9/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,\"\",L9/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,\"\",N9/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$f":"IF($F$2=1,\"\",Q9/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Private indtægter",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,F10/F$10*100,F10/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,H10/H$10*100,H10/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,J10/J$10*100,J10/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,L10/L$10*100,L10/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,N10/N$10*100,N10/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$f":"IF($F$2=1,Q10/Q$10*100,Q10/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Andre driftsindtægter",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,F11/F$10*100,F11/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,H11/H$10*100,H11/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,J11/J$10*100,J11/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,L11/L$10*100,L11/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,N11/N$10*100,N11/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$f":"IF($F$2=1,Q11/Q$10*100,Q11/Q$8*100)","v":{"$error":"#DIV/0!"}}]
[null,"Omkostninger til råvarer og hjælpematerialer",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,F12/F$10*100,F12/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,H12/H$10*100,H12/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,J12/J$10*100,J12/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,L12/L$10*100,L12/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,N12/N$10*100,N12/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,"Andre eksterne omkostninger",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF($F$2=1,F13/F$10*100,F13/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF($F$2=1,H13/H$10*100,H13/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF($F$2=1,J13/J$10*100,J13/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF($F$2=1,L13/L$10*100,L13/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF($F$2=1,N13/N$10*100,N13/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[]
["Bruttoresultat",null,null,null,null,{"$f":"SUM(F8:F14)","v":0},{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F15/F$10*100,F15/F$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H8:H14)","v":0},{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H15/H$10*100,H15/H$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J8:J14)","v":0},{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J15/J$10*100,J15/J$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L8:L14)","v":0},{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L15/L$10*100,L15/L$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N8:N14)","v":0},{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N15/N$10*100,N15/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Personaleomkostninger",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F17/F$10*100,F17/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H17/H$10*100,H17/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J17/J$10*100,J17/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L17/L$10*100,L17/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N17/N$10*100,N17/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,"Af- og nedskrivninger anlægsaktiver",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F18/F$10*100,F18/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H18/H$10*100,H18/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J18/J$10*100,J18/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L18/L$10*100,L18/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N18/N$10*100,N18/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,"Gevinst ved salg af anlægsaktiver",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F19/F$10*100,F19/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H19/H$10*100,H19/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J19/J$10*100,J19/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L19/L$10*100,L19/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N19/N$10*100,N19/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,"Andre driftsomkostninger",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F20/F$10*100,F20/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H20/H$10*100,H20/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J20/J$10*100,J20/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L20/L$10*100,L20/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N20/N$10*100,N20/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Driftsresultat",null,null,null,null,{"$f":"SUM(F17:F20)+F15","v":0},{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F22/F$10*100,F22/F$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H17:H20)+H15","v":0},{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H22/H$10*100,H22/H$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J17:J20)+J15","v":0},{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J22/J$10*100,J22/J$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L17:L20)+L15","v":0},{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L22/L$10*100,L22/L$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N17:N20)+N15","v":0},{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N22/N$10*100,N22/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Finansielle indtægter",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F24/F$10*100,F24/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H24/H$10*100,H24/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J24/J$10*100,J24/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L24/L$10*100,L24/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N24/N$10*100,N24/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[null,"Forpagtningsafgift"]
[null,"Finansielle omkostninger i øvrigt",null,null,null,{"$f":"F27-F25","v":0},null,{"$f":"H27-H25","v":0},null,{"$f":"J27-J25","v":0},null,{"$f":"L27-L25","v":0},null,{"$f":"N27-N25","v":0}]
[null,"Finansielle omkostninger i alt",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F27/F$10*100,F27/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H27/H$10*100,H27/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J27/J$10*100,J27/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L27/L$10*100,L27/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N27/N$10*100,N27/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[]
["Årets resultat før skat",null,null,null,null,{"$f":"F22+F27+F24","v":0},{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F29/F$10*100,F29/F$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"H22+H27+H24","v":0},{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H29/H$10*100,H29/H$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"J22+J27+J24","v":0},{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J29/J$10*100,J29/J$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"L22+L27+L24","v":0},{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L29/L$10*100,L29/L$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"N22+N27+N24","v":0},{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N29/N$10*100,N29/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[]
[null,"Skat af årets resultat",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F31/F$10*100,F31/F$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H31/H$10*100,H31/H$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J31/J$10*100,J31/J$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L31/L$10*100,L31/L$8*100))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N31/N$10*100,N31/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[]
["Årets resultat",null,null,null,null,{"$f":"SUM(F29:F32)","v":0},{"$f":"IF(AntalSelskabsÅr<F$120,\"\",IF($F$2=1,F33/F$10*100,F33/F$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(H29:H32)","v":0},{"$f":"IF(AntalSelskabsÅr<H$120,\"\",IF($F$2=1,H33/H$10*100,H33/H$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J29:J32)","v":0},{"$f":"IF(AntalSelskabsÅr<J$120,\"\",IF($F$2=1,J33/J$10*100,J33/J$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(L29:L32)","v":0},{"$f":"IF(AntalSelskabsÅr<L$120,\"\",IF($F$2=1,L33/L$10*100,L33/L$8*100))","v":{"$error":"#DIV/0!"}},{"$f":"SUM(N29:N32)","v":0},{"$f":"IF(AntalSelskabsÅr<N$120,\"\",IF($F$2=1,N33/N$10*100,N33/N$8*100))","v":{"$error":"#DIV/0!"}},null,0,{"$error":"#DIV/0!"}]
[]
[]
["BALANCE",null,null,{"$f":"F54","v":2008},null,null,null,{"$f":"H54","v":2009},null,{"$f":"J54","v":2010},null,{"$f":"L54","v":2011},null,{"$f":"N54","v":2012}]
[]
[null,null,null,"primo",null,"ultimo",null,"ultimo",null,"ultimo",null,"ultimo",null,"ultimo"]
[null,"Anlægsaktiver"]
[null,"Omsætningsaktiver"]
["Aktiver i alt",null,null,{"$f":"D39+D40","v":0},null,{"$f":"F39+F40","v":0},null,{"$f":"H39+H40","v":0},null,{"$f":"J39+J40","v":0},null,{"$f":"L39+L40","v":0},null,{"$f":"N39+N40","v":0}]
[]
[null,"Egenkapital",null,{"$f":"D41-D44-D48","v":0},null,{"$f":"F41-F44-F48","v":0},null,{"$f":"H41-H44-H48","v":0},null,{"$f":"J41-J44-J48","v":0},null,{"$f":"L41-L44-L48","v":0},null,{"$f":"N41-N44-N48","v":0}]
[null,"Hensættelser"]
[]
[null,"Langfristet gæld"]
[null,"Kortfristet gæld"]
[null,"Gæld i alt",null,{"$f":"SUM(D46:D47)","v":0},null,{"$f":"SUM(F46:F47)","v":0},null,{"$f":"SUM(H46:H47)","v":0},null,{"$f":"SUM(J46:J47)","v":0},null,{"$f":"SUM(L46:L47)","v":0},null,{"$f":"SUM(N46:N47)","v":0}]
["Passiver i alt",null,null,{"$f":"D48+D43+D44","v":0},null,{"$f":"F48+F43+F44","v":0},null,{"$f":"H48+H43+H44","v":0},null,{"$f":"J48+J43+J44","v":0},null,{"$f":"L48+L43+L44","v":0},null,{"$f":"N48+N43+N44","v":0}]
[]
[]
["NØGLETALSBEREGNING"]
[null,{"$f":"Indtast!B79","v":0}]
[null,null,null,null,null,{"$f":"F6","v":2008},null,{"$f":"H6","v":2009},null,{"$f":"J6","v":2010},null,{"$f":"L6","v":2011},null,{"$f":"N6","v":2012}]
[null,"Arbejdstimer totalt"]
[null,"Medhjælpers arbejdstimer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1665]
[null,"Familiens arbejdstimer",null,null,null,{"$f":"F55-F56","v":0},null,{"$f":"H55-H56","v":0},null,{"$f":"J55-J56","v":0},null,{"$f":"L55-L56","v":0},null,{"$f":"N55-N56","v":0}]
[null,"Timesats",null,null,null,165,null,165,null,165,null,165,null,165,null,null,159]
[null,"Enten beregnet arbejdsvederlag, 1.000 kr",null,null,null,{"$f":"F57*F58/1000","v":0},null,{"$f":"H57*H58/1000","v":0},null,{"$f":"J57*J58/1000","v":0},null,{"$f":"L57*L58/1000","v":0},null,{"$f":"N57*N58/1000","v":0}]
[null,"eller direkte indtastet, 1.000 kr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Indtast!Q83","v":0}]
[null,"Driftsresultat (før finansielle poster)",null,null,null,{"$f":"F22","v":0},null,{"$f":"H22","v":0},null,{"$f":"J22","v":0},null,{"$f":"L22","v":0},null,{"$f":"N22","v":0},null,null,{"$f":"SUM(F62:N62)/Indtast!$F$3","v":0}]
[null," - forpagtningsafgift",null,null,null,{"$f":"F25","v":0},null,{"$f":"H25","v":0},null,{"$f":"J25","v":0},null,{"$f":"L25","v":0},null,{"$f":"N25","v":0},null,null,{"$f":"SUM(F63:N63)/Indtast!$F$3","v":0}]
[null,"Nettoudbytte",null,null,null,{"$f":"SUM(F62:F63)","v":0},null,{"$f":"SUM(H62:H63)","v":0},null,{"$f":"SUM(J62:J63)","v":0},null,{"$f":"SUM(L62:L63)","v":0},null,{"$f":"SUM(N62:N63)","v":0},null,null,{"$f":"SUM(F64:N64)/Indtast!$F$3","v":0}]
[]
[null,"Nettoudbytte",null,null,null,{"$f":"F64","v":0},null,{"$f":"H64","v":0},null,{"$f":"J64","v":0},null,{"$f":"L64","v":0},null,{"$f":"N64","v":0}]
[null," / Aktiver i alt gns. * 100",null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",(D41+F41)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",(F41+H41)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",(H41+J41)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",(J41+L41)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",(L41+N41)/2)","v":0}]
["Afkastningsgrad (AG):",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F66/F67)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H66/H67)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J66/J67)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L66/L67)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N66/N67)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F68:N68)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Nettoudbytte",null,null,null,{"$f":"F66","v":0},null,{"$f":"H66","v":0},null,{"$f":"J66","v":0},null,{"$f":"L66","v":0},null,{"$f":"N66","v":0}]
[null," / nettoomsætning",null,null,null,{"$f":"F8","v":0},null,{"$f":"H8","v":0},null,{"$f":"J8","v":0},null,{"$f":"L8","v":0},null,{"$f":"N8","v":0}]
["Overskudsgrad (OG):",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F70/F71)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H70/H71)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J70/J71)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L70/L71)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N70/N71)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F72:N72)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Nettoomsætning",null,null,null,{"$f":"F71","v":0},null,{"$f":"H71","v":0},null,{"$f":"J71","v":0},null,{"$f":"L71","v":0},null,{"$f":"N71","v":0}]
[null," / aktiver i alt i gns.",null,null,null,{"$f":"F67","v":0},null,{"$f":"H67","v":0},null,{"$f":"J67","v":0},null,{"$f":"L67","v":0},null,{"$f":"N67","v":0}]
["Aktivernes omsætningshastighed (AOH)",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F74/F75)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H74/H75)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J74/J75)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L74/L75)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N74/N75)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F76:N76)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Driftsresultat (før finansielle poster)",null,null,null,{"$f":"F62","v":0},null,{"$f":"H62","v":0},null,{"$f":"J62","v":0},null,{"$f":"L62","v":0},null,{"$f":"N62","v":0}]
[null," - finansieringsomkostninger",null,null,null,{"$f":"F84*-1","v":0},null,{"$f":"H84*-1","v":0},null,{"$f":"J84*-1","v":0},null,{"$f":"L84*-1","v":0},null,{"$f":"N84*-1","v":0}]
[null," = rest til forrentning af egenkapital",null,null,null,{"$f":"F78+F79","v":0},null,{"$f":"H78+H79","v":0},null,{"$f":"J78+J79","v":0},null,{"$f":"L78+L79","v":0},null,{"$f":"N78+N79","v":0}]
[null," / egenkapital gns. * 100",null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",(D43+F43)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",(F43+H43)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",(H43+J43)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",(J43+L43)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",(L43+N43)/2)","v":0}]
["Egenkapitalens forrentning (EKF):",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",IF(F81<0,\"Neg. EK\",F80/F81))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",IF(H81<0,\"Neg. EK\",H80/H81))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",IF(J81<0,\"Neg. EK\",J80/J81))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",IF(L81<0,\"Neg. EK\",L80/L81))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",IF(N81<0,\"Neg. EK\",N80/N81))","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F82:N82)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Finansieringsomk. netto",null,null,null,{"$f":"(F24+F27)*-1","v":0},null,{"$f":"(H24+H27)*-1","v":0},null,{"$f":"(J24+J27)*-1","v":0},null,{"$f":"(L24+L27)*-1","v":0},null,{"$f":"(N24+N27)*-1","v":0}]
[null," / gæld i alt i gns. *100",null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",(D48+F48)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",(F48+H48)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",(H48+J48)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",(J48+L48)/2)","v":0},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",(L48+N48)/2)","v":0}]
["Gældsrente (GR):",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F84/F85)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H84/H85)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J84/J85)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L84/L85)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N84/N85)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F86:N86)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Gæld i alt",null,"Ultimo",null,{"$f":"F48","v":0},null,{"$f":"H48","v":0},null,{"$f":"J48","v":0},null,{"$f":"L48","v":0},null,{"$f":"N48","v":0}]
[null," / passiver i alt*100",null,"Ultimo",null,{"$f":"F49","v":0},null,{"$f":"H49","v":0},null,{"$f":"J49","v":0},null,{"$f":"L49","v":0},null,{"$f":"N49","v":0}]
["Gældsprocent",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F88/F89)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H88/H89)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J88/J89)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L88/L89)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N88/N89)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F90:N90)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[null,"Driftsresultat (før finansielle poster)",null,null,null,{"$f":"F78","v":0},null,{"$f":"H78","v":0},null,{"$f":"J78","v":0},null,{"$f":"L78","v":0},null,{"$f":"N78","v":0}]
[null," + lønomkostninger",null,null,null,{"$f":"F17*-1","v":0},null,{"$f":"H17*-1","v":0},null,{"$f":"J17*-1","v":0},null,{"$f":"L17*-1","v":0},null,{"$f":"N17*-1","v":0}]
[null," - 4 pct. rente af egne aktiver",null,null,null,{"$f":"-F41*4%","v":0},null,{"$f":"-H41*4%","v":0},null,{"$f":"-J41*4%","v":0},null,{"$f":"-L41*4%","v":0},null,{"$f":"-N41*4%","v":0}]
[null,"Lønningsevne i alt",null,null,null,{"$f":"SUM(F92:F94)","v":0},null,{"$f":"SUM(H92:H94)","v":0},null,{"$f":"SUM(J92:J94)","v":0},null,{"$f":"SUM(L92:L94)","v":0},null,{"$f":"SUM(N92:N94)","v":0}]
["Lønningsevne, kr. pr. time",null,null,null,null,{"$f":"IF(AntalSelskabsÅr<F120,\"\",F95/F55*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<H120,\"\",H95/H55*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<J120,\"\",J95/J55*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<L120,\"\",L95/L55*1000)","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(AntalSelskabsÅr<N120,\"\",N95/N55*1000)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"SUM(F96:N96)/AntalSelskabsÅr","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,null,2,null,3,null,4,null,5]