{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Vejledning","Indtastninger","Simulering","Udskrift"],"not_rendered":{"charts":2,"images":9,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Vejledning","index":0,"n_rows":136,"n_cols":2,"rows_kept":136,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Vejledning til brug af dette likviditetsstyringsværktøj"]
[]
[null,"Formål:"]
[null,"Værktøjet har til formål at skabe et overblik over den kommende periodes ind- og udbetalinger - altså likviditetsflowet."]
[null,"Med dette overblik kan du få indblik i, om likviditeten udvikler sig som forventet (jf. budget)."]
[null,"Såfremt likviditetsudviklingen afviger fra forventningen, har du mulighed for at iværksætte nogle handlinger,"]
[null,"så du kan være på forkant og bede om enten udsættelse af nogle betalinger og/eller midlertidig udvidelse af kreditrammen"]
[null," hos dit pengeinstitut."]
[]
[null,"Fane-beskrivelser:"]
[null,"\"Indtastning\": Denne fane anvendes til manuel indtastning af kommende ind- og udbetalinger, herunder betalings- og forfaldsdato."]
[null,"\"Simulering\": I denne fane har du mulighed for at simulere likviditetsflowet i en given periode."]
[null,"\"Udskrift\": Her vises likviditetsflowet, både med og uden forskydning i planlagt betalingsdato."]
[]
[null,"Sådan bruger du værktøjet:"]
[null,"Steps i fanen \"Indtastning\":"]
[1,"Indtast kommende ind- og udbetalinger i kolonne B, D & E."]
[]
[]
[]
[]
[]
[]
[null,"Har du f.eks. en faktura fra smeden med forfaldsdato den 1. november 2016, skal du indtaste følgende:"]
[null,"I kolonne B: Indtast forfaldsdato = 01-11-2016"]
[null,"I kolonne D: Indtast passende tekst  - det kan f.eks. være kreditornavn + hvad der er indkøbt, eller debitornavn + hvad der er solgt."]
[null,"I kolonne E: Indtast beløb - husk køb angives med et minus fortegn, f.eks. -1.000, mens salg angives uden fortegn, f.eks. 1.000"]
[null,"Kolonne C vil automatisk blive fyldt med samme dato som forfaldsdatoen, når processen sættes i gang."]
[]
[null,"Eksempel på udfyldt række:"]
[]
[]
[]
[]
[]
[]
[2,"derefter indtastes trækningsretten for de relevante måneder i kolonne I"]
[]
[3,"I kolonne I 3 og 4 taster du det tidsinterval du ønsker at få vist og arbejde videre med "]
[]
[4,"Når alle kommende ind- og udbetalinger er indtastet, trykker du på den grønne knap \"Opdater og sorter posteringer\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[5,"Når processen bagved er færdig med at køre, så står man i \"Udskrift\" - fanen."]
[null,"Du bør vente til beregningsprocessen er gennemført før du går videre i arket, ellers risikerer du at det ikke virker efter hensigten"]
[null,"I \"Udskrift\" arket kan man se et overblik over det gældende likviditetsflow."]
[]
[null,"I udskriftsfanen er det muligt at gemme fremstillingen som en pdf ved at trykke på knappen i højre hjørne."]
[]
[]
[]
[]
[]
[]
[null,"Hvis der er behov for justeringer kan det ske ved i simuleringsfanen"]
[null,"at ændre datoen for betaling eller helt at fravælge betalingen."]
[]
[6,"Herefter får du overblik såvel i tabel som grafer:"]
[]
[null,"Tabel overblik:"]
[]
[]
[]
[]
[]
[]
[null,"Grafisk overblik - viser saldo på kassekreditten samt trækningsretten i den gældende periode:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"I grafen ses det at der f.eks er et overtræk fra d. 1-11 til d. 6-11, der bør tages hånd om."]
[]
[7,"Hvis man eksempelvis har valgt en periode fra 01-11-2016, men der er regninger fra oktober, som"]
[null,"ikke er betalt, så skal disse blot indtastes under indtastninger, og så vil"]
[null,"de blive medtaget i periodens likviditet og sat til betaling 01-11-2016."]
[]
[8,"Ændres betalingsdatoen, så vil man i graf nr. 2 kunne se, hvor stort et beløb man samlet har udskudt længere ind i"]
[null,"periodens og man kan derfor se, hvordan likviditeten påvirkes. Udskydes eksempelvis A-Skat med 3 dage, så vil det se sådan ud:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Derudover vil man også i listen over betalinger kunne se, at en rød farve markerer,"]
[null,"at betalingsdatoen nu ligger senere end selve forfaldsdatoen."]
[]
[]
[]
[]
[]
[]
[null,"Modsat, hvis betalingsdatoen er før forfaldsdatoen, så markeres dette med grøn."]
[]
[9,"Ønskes et beløb helt fjernet fra den grafiske visning, så kan dette gøres ved at skrive et 'x' i kolonnen Fravælg."]
[]
[10,"Efter man enten har ændret betalingsdatoen, eller fravalgt beløb, så skal man trykke på \"Simuler Data\""]
[null,"for at få en ny fremstilling at den brugte kassekredit samt den udskudte likviditet."]
[null,"Hermed får man en mulighed for at se den effekt ens valg har på likviditetsudviklingen"]

{"sheet":"Indtastninger","index":1,"n_rows":25,"n_cols":14,"rows_kept":25,"cut":false,"hidden":false,"merged":[[1,7,1,8],[0,13,0,16],[3,1,3,4],[1,1,1,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Styringspanel"]
[null,{"$f":"\"Primo Saldo Kassekredit pr. \" & TEXT(I3,\"dd-mm-åååå\")","v":"Primo Saldo Kassekredit pr. 21-06-2017"},null,null,-1500000,null,null,"Tidsperiode"]
[null,null,null,null,null,null,null,"Start","2017-06-21",{"$f":"TODAY()","v":42907}]
[null,"Indsæt Dato m.m. herunder",null,null,null,null,null,"Slut","2017-07-21"]
[null,"Forfaldsdato","Betalingsdato","Tekst","Beløb",null,null,"Dato","Trækningsret"]
[null,"2017-06-22","2017-06-22","Maskiner",-27500,null,null,{"$f":"L6","v":"2017-06-01"},-1200000,{"$f":"TEXT(I3,\"dd-mm-åååå\")","v":"21-06-2017"},{"$f":"\"01-\"& RIGHT(J6,7)","v":"01-06-2017"},{"$f":"DATEVALUE(K6)","v":42887}]
[null,"2017-06-23","2017-06-23","moms",-40000,null,null,{"$f":"L7","v":"2017-07-01"},-1300000,null,{"$f":"LEFT(K6,3) & (IF(MONTH(L6)=12,1,MONTH(L6)+1)) &\"-\"& IF(MONTH(L6)=12,YEAR(L6)+1,YEAR(L6))","v":"01-7-2017"},{"$f":"DATEVALUE(K7)","v":42917}]
[null,"2017-06-23","2017-06-23","a-skat",-165000,null,"Løn","2017-08-01",-1450000,null,{"$f":"LEFT(K7,3) & (IF(MONTH(L7)=12,1,MONTH(L7)+1)) &\"-\"& IF(MONTH(L7)=12,YEAR(L7)+1,YEAR(L7))","v":"01-8-2017"},{"$f":"DATEVALUE(K8)","v":42948}]
[null,"2017-06-26","2017-06-26","løn",-90000,null,"A-skat","2017-09-01",-1000000,null,{"$f":"LEFT(K8,3) & (IF(MONTH(L8)=12,1,MONTH(L8)+1)) &\"-\"& IF(MONTH(L8)=12,YEAR(L8)+1,YEAR(L8))","v":"01-9-2017"},42979]
[null,"2017-06-28","2017-06-28","Smed",-10000,null,"Moms","2017-10-01",-1100000,null,"01-10-2017",43009]
[null,"2017-06-30","2017-06-30","Maskinstation",-70000,null,"DLG","2017-11-01",-1200000,null,"01-11-2017",43040]
[null,"2017-07-06","2017-07-06","DC - Smågrise",300000,null,"DC - Smågrise","2017-12-01",-600000,null,"01-12-2017",43070]
[null,"2017-07-06","2017-07-06","DC - Smågrise",250000,null,"Dyrlæge","2018-01-01",-750000,null,"01-1-2018",43101]
[null,"2017-07-06","2017-07-06","Brændstof",-60000,null,"Maskinstation","2018-02-01",-850000,null,"01-2-2018",43132]
[null,"2017-07-09","2017-07-09","DC - Smågrise",2000,null,"Smed","2018-03-01",-1000000,null,"01-3-2018",43160]
[null,"2017-07-09","2017-07-09","Foderstof",-25000,null,null,"2018-04-01",-1050000,null,"01-4-2018",43191]
[null,"2017-07-09","2017-07-09","Foderstof",-250000,null,null,{"$f":"L17","v":"2018-05-01"},-1100000,null,"01-5-2018",43221]
[null,"2017-07-09","2017-07-09","Foderstof",-250000]
[null,"2017-07-10","2017-07-10","Dyrlæge",-20000]
[null,"2017-07-10","2017-07-10","Maskinstation",-25000]
[null,"2017-07-10","2017-07-10","Moms",-75000]
[null,"2017-07-11","2017-07-11","DC - Smågrise",15250]
[null,"2017-07-12","2017-07-12","Maskinstation",-70000]
[null,"2017-07-13","2017-07-13","EU-støtte",596000]
[null,"2017-07-15","2017-07-15","Salg af korn",450000]

{"sheet":"Simulering","index":2,"n_rows":40,"n_cols":29,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,0,4,2],[5,0,5,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dato","Trækningsret"]
["Start",{"$f":"Indtastninger!I3","v":"2017-06-21"},{"$f":"TODAY()","v":42907},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01",-1200000,"21-06-2017","01-06-2017",42887]
["Slut",{"$f":"Indtastninger!I4","v":"2017-07-21"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01",-1300000,null,"01-7-2017",42917]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01",-1450000,null,"01-8-2017",42948]
["Trækningsret start periode",null,null,{"$f":"IFERROR(VLOOKUP(B2,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01",-1000000,null,"01-9-2017",42979]
["Primo saldo kassekredit",null,null,{"$f":"Indtastninger!E2","v":-1500000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01",-1100000,null,"01-10-2017",43009]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01",-1200000,null,"01-11-2017",43040]
[null,"Start","Start",null,null,null,null,null,"Start","Start","Start","Start",null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01",-600000,null,"01-12-2017",43070]
[null,"Forfaldsdato","Betalingsdato","Tekst","Beløb","Saldo Kassekredit","Disponibelt beløb","Fravælg","her","her","her","her",null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01",-750000,null,"01-1-2018",43101]
[null,"2017-06-21","2017-06-21","Primo periode",null,-1500000,-300000,null,"2017-06-21",-1500000,null,-1200000,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01",-850000,null,"01-2-2018",43132]
[null,"2017-06-22","2017-06-22","Maskiner",-27500,-1527500,null,null,"2017-06-22",-1527500,null,-1200000,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01",-1000000,null,"01-3-2018",43160]
[null,"2017-06-23","2017-06-23","moms",-40000,-1567500,null,null,"2017-06-23",-1732500,null,-1200000,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01",-1050000,null,"01-4-2018",43191]
[null,"2017-06-23","2017-06-23","a-skat",-165000,-1732500,null,null,"2017-06-24",-1732500,null,-1200000,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01",-1100000,null,"01-5-2018",43221]
[null,"2017-06-26","2017-06-26","løn",-90000,-1822500,null,null,"2017-06-25",-1732500,null,-1200000]
[null,"2017-06-28","2017-06-28","Smed",-10000,-1832500,null,null,"2017-06-26",-1822500,null,-1200000]
[null,"2017-06-30","2017-06-30","Maskinstation",-70000,-1902500,null,null,"2017-06-27",-1822500,null,-1200000]
[null,"2017-07-06","2017-07-06","DC - Smågrise",300000,-1602500,null,null,"2017-06-28",-1832500,null,-1200000]
[null,"2017-07-06","2017-07-06","DC - Smågrise",250000,-1352500,null,null,"2017-06-29",-1832500,null,-1200000]
[null,"2017-07-06","2017-07-06","Brændstof",-60000,-1412500,null,null,"2017-06-30",-1902500,null,-1200000]
[null,"2017-07-09","2017-07-09","DC - Smågrise",2000,-1410500,null,null,"2017-07-01",-1902500,null,-1300000]
[null,"2017-07-09","2017-07-09","Foderstof",-25000,-1435500,null,null,"2017-07-02",-1902500,null,-1300000]
[null,"2017-07-09","2017-07-09","Foderstof",-250000,-1685500,null,null,"2017-07-03",-1902500,null,-1300000]
[null,"2017-07-09","2017-07-09","Foderstof",-250000,-1935500,null,null,"2017-07-04",-1902500,null,-1300000]
[null,"2017-07-10","2017-07-10","Dyrlæge",-20000,-1955500,null,null,"2017-07-05",-1902500,null,-1300000]
[null,"2017-07-10","2017-07-10","Maskinstation",-25000,-1980500,null,null,"2017-07-06",-1412500,null,-1300000]
[null,"2017-07-10","2017-07-10","Moms",-75000,-2055500,null,null,"2017-07-07",-1412500,null,-1300000]
[null,"2017-07-11","2017-07-11","DC - Smågrise",15250,-2040250,null,null,"2017-07-08",-1412500,null,-1300000]
[null,"2017-07-12","2017-07-12","Maskinstation",-70000,-2110250,null,null,"2017-07-09",-1935500,null,-1300000]
[null,"2017-07-13","2017-07-13","EU-støtte",596000,-1514250,null,null,"2017-07-10",-2055500,null,-1300000]
[null,"2017-07-15","2017-07-15","Salg af korn",450000,-1064250,null,null,"2017-07-11",-2040250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-12",-2110250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-13",-1514250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-14",-1514250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-15",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-16",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-17",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-18",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-19",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-20",-1064250,null,-1300000]
[null,null,null,null,null,null,null,null,"2017-07-21",-1064250,null,-1300000]

{"sheet":"Udskrift","index":3,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":false,"merged":[[75,8,75,9],[76,8,76,9],[77,8,77,9],[78,8,78,9],[71,8,71,9],[72,8,72,9],[88,8,88,9],[73,8,73,9],[67,8,67,9],[68,8,68,9],[69,8,69,9],[70,8,70,9],[74,8,74,9],[90,8,90,9],[79,8,79,9],[80,8,80,9],[81,8,81,9],[82,8,82,9],[83,8,83,9],[84,8,84,9],[85,8,85,9],[86,8,86,9],[87,8,87,9],[89,8,89,9],[60,8,60,9],[61,8,61,9],[62,8,62,9],[63,8,63,9],[64,8,64,9],[65,8,65,9],[66,8,66,9],[49,4,49,6],[55,8,55,9],[56,8,56,9],[57,8,57,9],[58,8,58,9],[49,8,49,9],[50,8,50,9],[51,8,51,9],[52,8,52,9],[42,8,42,9],[43,8,43,9],[56,4,56,6],[57,4,57,6],[44,8,44,9],[89,4,89,6],[71,4,71,6],[72,4,72,6],[73,4,73,6],[74,4,74,6],[67,4,67,6],[68,4,68,6],[69,4,69,6],[70,4,70,6],[87,4,87,6],[88,4,88,6],[61,4,61,6],[62,4,62,6],[63,4,63,6],[64,4,64,6],[65,4,65,6],[66,4,66,6],[55,4,55,6],[59,8,59,9],[90,4,90,6],[37,8,37,9],[38,8,38,9],[39,8,39,9],[40,8,40,9],[81,4,81,6],[82,4,82,6],[83,4,83,6],[84,4,84,6],[85,4,85,6],[86,4,86,6],[75,4,75,6],[76,4,76,6],[77,4,77,6],[78,4,78,6],[79,4,79,6],[80,4,80,6],[54,8,54,9],[53,8,53,9],[46,8,46,9],[45,8,45,9],[58,4,58,6],[59,4,59,6],[60,4,60,6],[36,8,36,9],[1,1,3,13],[50,4,50,6],[51,4,51,6],[52,4,52,6],[53,4,53,6],[54,4,54,6],[34,5,34,8],[36,4,36,6],[43,4,43,6],[44,4,44,6],[45,4,45,6],[46,4,46,6],[47,4,47,6],[48,4,48,6],[37,4,37,6],[38,4,38,6],[39,4,39,6],[40,4,40,6],[41,4,41,6],[42,4,42,6],[47,8,47,9],[48,8,48,9],[41,8,41,9]]}
[]
[null,"Udskrift af periodens likviditet"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"Simulering!$A$2","v":"Start"},{"$f":"Indtastninger!I3","v":"2017-06-21"},{"$f":"TODAY()","v":"2017-06-21"}]
[null,null,{"$f":"Simulering!$A$3","v":"Slut"},{"$f":"Simulering!$B$3","v":"2017-07-21"},null,{"$f":"Simulering!A6","v":"Primo saldo kassekredit"},null,null,null,{"$f":"Simulering!D6","v":-1500000}]
[]
[null,null,{"$f":"IF(Simulering!B9=0,\"\",Simulering!B9)","v":"Forfaldsdato"},{"$f":"IF(Simulering!C9=0,\"\",Simulering!C9)","v":"Betalingsdato"},{"$f":"IF(Simulering!D9=0,\"\",Simulering!D9)","v":"Tekst"},null,null,{"$f":"IF(Simulering!E9=0,\"\",Simulering!E9)","v":"Beløb"},{"$f":"IF(Simulering!F9=0,\"\",Simulering!F9)","v":"Saldo Kassekredit"},null,"Trækningsret"]
[null,null,{"$f":"IF(Simulering!B10=0,\"\",Simulering!B10)","v":"2017-06-21"},{"$f":"IF(Simulering!C10=0,\"\",Simulering!C10)","v":"2017-06-21"},{"$f":"IF(Simulering!D10=0,\"\",Simulering!D10)","v":"Primo periode"},null,null,{"$f":"IF(Simulering!E10=0,\"\",Simulering!E10)","v":""},{"$f":"IF(Simulering!F10=0,\"\",Simulering!F10)","v":-1500000},null,{"$f":"IFERROR(VLOOKUP(D38,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H10=0,\"\",Simulering!H10)","v":""}]
[null,null,{"$f":"IF(Simulering!B11=0,\"\",Simulering!B11)","v":"2017-06-22"},{"$f":"IF(Simulering!C11=0,\"\",Simulering!C11)","v":"2017-06-22"},{"$f":"IF(Simulering!D11=0,\"\",Simulering!D11)","v":"Maskiner"},null,null,{"$f":"IF(Simulering!E11=0,\"\",Simulering!E11)","v":-27500},{"$f":"IF(Simulering!F11=0,\"\",Simulering!F11)","v":-1527500},null,{"$f":"IFERROR(VLOOKUP(D39,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H11=0,\"\",Simulering!H11)","v":""}]
[null,null,{"$f":"IF(Simulering!B12=0,\"\",Simulering!B12)","v":"2017-06-23"},{"$f":"IF(Simulering!C12=0,\"\",Simulering!C12)","v":"2017-06-23"},{"$f":"IF(Simulering!D12=0,\"\",Simulering!D12)","v":"moms"},null,null,{"$f":"IF(Simulering!E12=0,\"\",Simulering!E12)","v":-40000},{"$f":"IF(Simulering!F12=0,\"\",Simulering!F12)","v":-1567500},null,{"$f":"IFERROR(VLOOKUP(D40,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H12=0,\"\",Simulering!H12)","v":""}]
[null,null,{"$f":"IF(Simulering!B13=0,\"\",Simulering!B13)","v":"2017-06-23"},{"$f":"IF(Simulering!C13=0,\"\",Simulering!C13)","v":"2017-06-23"},{"$f":"IF(Simulering!D13=0,\"\",Simulering!D13)","v":"a-skat"},null,null,{"$f":"IF(Simulering!E13=0,\"\",Simulering!E13)","v":-165000},{"$f":"IF(Simulering!F13=0,\"\",Simulering!F13)","v":-1732500},null,{"$f":"IFERROR(VLOOKUP(D41,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H13=0,\"\",Simulering!H13)","v":""}]
[null,null,{"$f":"IF(Simulering!B14=0,\"\",Simulering!B14)","v":"2017-06-26"},{"$f":"IF(Simulering!C14=0,\"\",Simulering!C14)","v":"2017-06-26"},{"$f":"IF(Simulering!D14=0,\"\",Simulering!D14)","v":"løn"},null,null,{"$f":"IF(Simulering!E14=0,\"\",Simulering!E14)","v":-90000},{"$f":"IF(Simulering!F14=0,\"\",Simulering!F14)","v":-1822500},null,{"$f":"IFERROR(VLOOKUP(D42,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H14=0,\"\",Simulering!H14)","v":""}]
[null,null,{"$f":"IF(Simulering!B15=0,\"\",Simulering!B15)","v":"2017-06-28"},{"$f":"IF(Simulering!C15=0,\"\",Simulering!C15)","v":"2017-06-28"},{"$f":"IF(Simulering!D15=0,\"\",Simulering!D15)","v":"Smed"},null,null,{"$f":"IF(Simulering!E15=0,\"\",Simulering!E15)","v":-10000},{"$f":"IF(Simulering!F15=0,\"\",Simulering!F15)","v":-1832500},null,{"$f":"IFERROR(VLOOKUP(D43,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H15=0,\"\",Simulering!H15)","v":""}]
[null,null,{"$f":"IF(Simulering!B16=0,\"\",Simulering!B16)","v":"2017-06-30"},{"$f":"IF(Simulering!C16=0,\"\",Simulering!C16)","v":"2017-06-30"},{"$f":"IF(Simulering!D16=0,\"\",Simulering!D16)","v":"Maskinstation"},null,null,{"$f":"IF(Simulering!E16=0,\"\",Simulering!E16)","v":-70000},{"$f":"IF(Simulering!F16=0,\"\",Simulering!F16)","v":-1902500},null,{"$f":"IFERROR(VLOOKUP(D44,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1200000},{"$f":"IF(Simulering!H16=0,\"\",Simulering!H16)","v":""}]
[null,null,{"$f":"IF(Simulering!B17=0,\"\",Simulering!B17)","v":"2017-07-06"},{"$f":"IF(Simulering!C17=0,\"\",Simulering!C17)","v":"2017-07-06"},{"$f":"IF(Simulering!D17=0,\"\",Simulering!D17)","v":"DC - Smågrise"},null,null,{"$f":"IF(Simulering!E17=0,\"\",Simulering!E17)","v":300000},{"$f":"IF(Simulering!F17=0,\"\",Simulering!F17)","v":-1602500},null,{"$f":"IFERROR(VLOOKUP(D45,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H17=0,\"\",Simulering!H17)","v":""}]
[null,null,{"$f":"IF(Simulering!B18=0,\"\",Simulering!B18)","v":"2017-07-06"},{"$f":"IF(Simulering!C18=0,\"\",Simulering!C18)","v":"2017-07-06"},{"$f":"IF(Simulering!D18=0,\"\",Simulering!D18)","v":"DC - Smågrise"},null,null,{"$f":"IF(Simulering!E18=0,\"\",Simulering!E18)","v":250000},{"$f":"IF(Simulering!F18=0,\"\",Simulering!F18)","v":-1352500},null,{"$f":"IFERROR(VLOOKUP(D46,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H18=0,\"\",Simulering!H18)","v":""}]
[null,null,{"$f":"IF(Simulering!B19=0,\"\",Simulering!B19)","v":"2017-07-06"},{"$f":"IF(Simulering!C19=0,\"\",Simulering!C19)","v":"2017-07-06"},{"$f":"IF(Simulering!D19=0,\"\",Simulering!D19)","v":"Brændstof"},null,null,{"$f":"IF(Simulering!E19=0,\"\",Simulering!E19)","v":-60000},{"$f":"IF(Simulering!F19=0,\"\",Simulering!F19)","v":-1412500},null,{"$f":"IFERROR(VLOOKUP(D47,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H19=0,\"\",Simulering!H19)","v":""}]
[null,null,{"$f":"IF(Simulering!B20=0,\"\",Simulering!B20)","v":"2017-07-09"},{"$f":"IF(Simulering!C20=0,\"\",Simulering!C20)","v":"2017-07-09"},{"$f":"IF(Simulering!D20=0,\"\",Simulering!D20)","v":"DC - Smågrise"},null,null,{"$f":"IF(Simulering!E20=0,\"\",Simulering!E20)","v":2000},{"$f":"IF(Simulering!F20=0,\"\",Simulering!F20)","v":-1410500},null,{"$f":"IFERROR(VLOOKUP(D48,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H20=0,\"\",Simulering!H20)","v":""}]
[null,null,{"$f":"IF(Simulering!B21=0,\"\",Simulering!B21)","v":"2017-07-09"},{"$f":"IF(Simulering!C21=0,\"\",Simulering!C21)","v":"2017-07-09"},{"$f":"IF(Simulering!D21=0,\"\",Simulering!D21)","v":"Foderstof"},null,null,{"$f":"IF(Simulering!E21=0,\"\",Simulering!E21)","v":-25000},{"$f":"IF(Simulering!F21=0,\"\",Simulering!F21)","v":-1435500},null,{"$f":"IFERROR(VLOOKUP(D49,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H21=0,\"\",Simulering!H21)","v":""}]
[null,null,{"$f":"IF(Simulering!B22=0,\"\",Simulering!B22)","v":"2017-07-09"},{"$f":"IF(Simulering!C22=0,\"\",Simulering!C22)","v":"2017-07-09"},{"$f":"IF(Simulering!D22=0,\"\",Simulering!D22)","v":"Foderstof"},null,null,{"$f":"IF(Simulering!E22=0,\"\",Simulering!E22)","v":-250000},{"$f":"IF(Simulering!F22=0,\"\",Simulering!F22)","v":-1685500},null,{"$f":"IFERROR(VLOOKUP(D50,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H22=0,\"\",Simulering!H22)","v":""}]
[null,null,{"$f":"IF(Simulering!B23=0,\"\",Simulering!B23)","v":"2017-07-09"},{"$f":"IF(Simulering!C23=0,\"\",Simulering!C23)","v":"2017-07-09"},{"$f":"IF(Simulering!D23=0,\"\",Simulering!D23)","v":"Foderstof"},null,null,{"$f":"IF(Simulering!E23=0,\"\",Simulering!E23)","v":-250000},{"$f":"IF(Simulering!F23=0,\"\",Simulering!F23)","v":-1935500},null,{"$f":"IFERROR(VLOOKUP(D51,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H23=0,\"\",Simulering!H23)","v":""}]
[null,null,{"$f":"IF(Simulering!B24=0,\"\",Simulering!B24)","v":"2017-07-10"},{"$f":"IF(Simulering!C24=0,\"\",Simulering!C24)","v":"2017-07-10"},{"$f":"IF(Simulering!D24=0,\"\",Simulering!D24)","v":"Dyrlæge"},null,null,{"$f":"IF(Simulering!E24=0,\"\",Simulering!E24)","v":-20000},{"$f":"IF(Simulering!F24=0,\"\",Simulering!F24)","v":-1955500},null,{"$f":"IFERROR(VLOOKUP(D52,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H24=0,\"\",Simulering!H24)","v":""}]
[null,null,{"$f":"IF(Simulering!B25=0,\"\",Simulering!B25)","v":"2017-07-10"},{"$f":"IF(Simulering!C25=0,\"\",Simulering!C25)","v":"2017-07-10"},{"$f":"IF(Simulering!D25=0,\"\",Simulering!D25)","v":"Maskinstation"},null,null,{"$f":"IF(Simulering!E25=0,\"\",Simulering!E25)","v":-25000},{"$f":"IF(Simulering!F25=0,\"\",Simulering!F25)","v":-1980500},null,{"$f":"IFERROR(VLOOKUP(D53,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H25=0,\"\",Simulering!H25)","v":""}]
[null,null,{"$f":"IF(Simulering!B26=0,\"\",Simulering!B26)","v":"2017-07-10"},{"$f":"IF(Simulering!C26=0,\"\",Simulering!C26)","v":"2017-07-10"},{"$f":"IF(Simulering!D26=0,\"\",Simulering!D26)","v":"Moms"},null,null,{"$f":"IF(Simulering!E26=0,\"\",Simulering!E26)","v":-75000},{"$f":"IF(Simulering!F26=0,\"\",Simulering!F26)","v":-2055500},null,{"$f":"IFERROR(VLOOKUP(D54,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H26=0,\"\",Simulering!H26)","v":""}]
[null,null,{"$f":"IF(Simulering!B27=0,\"\",Simulering!B27)","v":"2017-07-11"},{"$f":"IF(Simulering!C27=0,\"\",Simulering!C27)","v":"2017-07-11"},{"$f":"IF(Simulering!D27=0,\"\",Simulering!D27)","v":"DC - Smågrise"},null,null,{"$f":"IF(Simulering!E27=0,\"\",Simulering!E27)","v":15250},{"$f":"IF(Simulering!F27=0,\"\",Simulering!F27)","v":-2040250},null,{"$f":"IFERROR(VLOOKUP(D55,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H27=0,\"\",Simulering!H27)","v":""}]
[null,null,{"$f":"IF(Simulering!B28=0,\"\",Simulering!B28)","v":"2017-07-12"},{"$f":"IF(Simulering!C28=0,\"\",Simulering!C28)","v":"2017-07-12"},{"$f":"IF(Simulering!D28=0,\"\",Simulering!D28)","v":"Maskinstation"},null,null,{"$f":"IF(Simulering!E28=0,\"\",Simulering!E28)","v":-70000},{"$f":"IF(Simulering!F28=0,\"\",Simulering!F28)","v":-2110250},null,{"$f":"IFERROR(VLOOKUP(D56,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H28=0,\"\",Simulering!H28)","v":""}]
[null,null,{"$f":"IF(Simulering!B29=0,\"\",Simulering!B29)","v":"2017-07-13"},{"$f":"IF(Simulering!C29=0,\"\",Simulering!C29)","v":"2017-07-13"},{"$f":"IF(Simulering!D29=0,\"\",Simulering!D29)","v":"EU-støtte"},null,null,{"$f":"IF(Simulering!E29=0,\"\",Simulering!E29)","v":596000},{"$f":"IF(Simulering!F29=0,\"\",Simulering!F29)","v":-1514250},null,{"$f":"IFERROR(VLOOKUP(D57,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H29=0,\"\",Simulering!H29)","v":""}]
[null,null,{"$f":"IF(Simulering!B30=0,\"\",Simulering!B30)","v":"2017-07-15"},{"$f":"IF(Simulering!C30=0,\"\",Simulering!C30)","v":"2017-07-15"},{"$f":"IF(Simulering!D30=0,\"\",Simulering!D30)","v":"Salg af korn"},null,null,{"$f":"IF(Simulering!E30=0,\"\",Simulering!E30)","v":450000},{"$f":"IF(Simulering!F30=0,\"\",Simulering!F30)","v":-1064250},null,{"$f":"IFERROR(VLOOKUP(D58,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":-1300000},{"$f":"IF(Simulering!H30=0,\"\",Simulering!H30)","v":""}]
[null,null,{"$f":"IF(Simulering!B31=0,\"\",Simulering!B31)","v":""},{"$f":"IF(Simulering!C31=0,\"\",Simulering!C31)","v":""},{"$f":"IF(Simulering!D31=0,\"\",Simulering!D31)","v":""},null,null,{"$f":"IF(Simulering!E31=0,\"\",Simulering!E31)","v":""},{"$f":"IF(Simulering!F31=0,\"\",Simulering!F31)","v":""},null,{"$f":"IFERROR(VLOOKUP(D59,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H31=0,\"\",Simulering!H31)","v":""}]
[null,null,{"$f":"IF(Simulering!B32=0,\"\",Simulering!B32)","v":""},{"$f":"IF(Simulering!C32=0,\"\",Simulering!C32)","v":""},{"$f":"IF(Simulering!D32=0,\"\",Simulering!D32)","v":""},null,null,{"$f":"IF(Simulering!E32=0,\"\",Simulering!E32)","v":""},{"$f":"IF(Simulering!F32=0,\"\",Simulering!F32)","v":""},null,{"$f":"IFERROR(VLOOKUP(D60,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H32=0,\"\",Simulering!H32)","v":""}]
[null,null,{"$f":"IF(Simulering!B33=0,\"\",Simulering!B33)","v":""},{"$f":"IF(Simulering!C33=0,\"\",Simulering!C33)","v":""},{"$f":"IF(Simulering!D33=0,\"\",Simulering!D33)","v":""},null,null,{"$f":"IF(Simulering!E33=0,\"\",Simulering!E33)","v":""},{"$f":"IF(Simulering!F33=0,\"\",Simulering!F33)","v":""},null,{"$f":"IFERROR(VLOOKUP(D61,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H33=0,\"\",Simulering!H33)","v":""}]
[null,null,{"$f":"IF(Simulering!B34=0,\"\",Simulering!B34)","v":""},{"$f":"IF(Simulering!C34=0,\"\",Simulering!C34)","v":""},{"$f":"IF(Simulering!D34=0,\"\",Simulering!D34)","v":""},null,null,{"$f":"IF(Simulering!E34=0,\"\",Simulering!E34)","v":""},{"$f":"IF(Simulering!F34=0,\"\",Simulering!F34)","v":""},null,{"$f":"IFERROR(VLOOKUP(D62,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H34=0,\"\",Simulering!H34)","v":""}]
[null,null,{"$f":"IF(Simulering!B35=0,\"\",Simulering!B35)","v":""},{"$f":"IF(Simulering!C35=0,\"\",Simulering!C35)","v":""},{"$f":"IF(Simulering!D35=0,\"\",Simulering!D35)","v":""},null,null,{"$f":"IF(Simulering!E35=0,\"\",Simulering!E35)","v":""},{"$f":"IF(Simulering!F35=0,\"\",Simulering!F35)","v":""},null,{"$f":"IFERROR(VLOOKUP(D63,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H35=0,\"\",Simulering!H35)","v":""}]
[null,null,{"$f":"IF(Simulering!B36=0,\"\",Simulering!B36)","v":""},{"$f":"IF(Simulering!C36=0,\"\",Simulering!C36)","v":""},{"$f":"IF(Simulering!D36=0,\"\",Simulering!D36)","v":""},null,null,{"$f":"IF(Simulering!E36=0,\"\",Simulering!E36)","v":""},{"$f":"IF(Simulering!F36=0,\"\",Simulering!F36)","v":""},null,{"$f":"IFERROR(VLOOKUP(D64,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H36=0,\"\",Simulering!H36)","v":""}]
[null,null,{"$f":"IF(Simulering!B37=0,\"\",Simulering!B37)","v":""},{"$f":"IF(Simulering!C37=0,\"\",Simulering!C37)","v":""},{"$f":"IF(Simulering!D37=0,\"\",Simulering!D37)","v":""},null,null,{"$f":"IF(Simulering!E37=0,\"\",Simulering!E37)","v":""},{"$f":"IF(Simulering!F37=0,\"\",Simulering!F37)","v":""},null,{"$f":"IFERROR(VLOOKUP(D65,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H37=0,\"\",Simulering!H37)","v":""}]
[null,null,{"$f":"IF(Simulering!B38=0,\"\",Simulering!B38)","v":""},{"$f":"IF(Simulering!C38=0,\"\",Simulering!C38)","v":""},{"$f":"IF(Simulering!D38=0,\"\",Simulering!D38)","v":""},null,null,{"$f":"IF(Simulering!E38=0,\"\",Simulering!E38)","v":""},{"$f":"IF(Simulering!F38=0,\"\",Simulering!F38)","v":""},null,{"$f":"IFERROR(VLOOKUP(D66,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H38=0,\"\",Simulering!H38)","v":""}]
[null,null,{"$f":"IF(Simulering!B39=0,\"\",Simulering!B39)","v":""},{"$f":"IF(Simulering!C39=0,\"\",Simulering!C39)","v":""},{"$f":"IF(Simulering!D39=0,\"\",Simulering!D39)","v":""},null,null,{"$f":"IF(Simulering!E39=0,\"\",Simulering!E39)","v":""},{"$f":"IF(Simulering!F39=0,\"\",Simulering!F39)","v":""},null,{"$f":"IFERROR(VLOOKUP(D67,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H39=0,\"\",Simulering!H39)","v":""}]
[null,null,{"$f":"IF(Simulering!B40=0,\"\",Simulering!B40)","v":""},{"$f":"IF(Simulering!C40=0,\"\",Simulering!C40)","v":""},{"$f":"IF(Simulering!D40=0,\"\",Simulering!D40)","v":""},null,null,{"$f":"IF(Simulering!E40=0,\"\",Simulering!E40)","v":""},{"$f":"IF(Simulering!F40=0,\"\",Simulering!F40)","v":""},null,{"$f":"IFERROR(VLOOKUP(D68,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H40=0,\"\",Simulering!H40)","v":""}]
[null,null,{"$f":"IF(Simulering!B41=0,\"\",Simulering!B41)","v":""},{"$f":"IF(Simulering!C41=0,\"\",Simulering!C41)","v":""},{"$f":"IF(Simulering!D41=0,\"\",Simulering!D41)","v":""},null,null,{"$f":"IF(Simulering!E41=0,\"\",Simulering!E41)","v":""},{"$f":"IF(Simulering!F41=0,\"\",Simulering!F41)","v":""},null,{"$f":"IFERROR(VLOOKUP(D69,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H41=0,\"\",Simulering!H41)","v":""}]
[null,null,{"$f":"IF(Simulering!B42=0,\"\",Simulering!B42)","v":""},{"$f":"IF(Simulering!C42=0,\"\",Simulering!C42)","v":""},{"$f":"IF(Simulering!D42=0,\"\",Simulering!D42)","v":""},null,null,{"$f":"IF(Simulering!E42=0,\"\",Simulering!E42)","v":""},{"$f":"IF(Simulering!F42=0,\"\",Simulering!F42)","v":""},null,{"$f":"IFERROR(VLOOKUP(D70,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H42=0,\"\",Simulering!H42)","v":""}]
[null,null,{"$f":"IF(Simulering!B43=0,\"\",Simulering!B43)","v":""},{"$f":"IF(Simulering!C43=0,\"\",Simulering!C43)","v":""},{"$f":"IF(Simulering!D43=0,\"\",Simulering!D43)","v":""},null,null,{"$f":"IF(Simulering!E43=0,\"\",Simulering!E43)","v":""},{"$f":"IF(Simulering!F43=0,\"\",Simulering!F43)","v":""},null,{"$f":"IFERROR(VLOOKUP(D71,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H43=0,\"\",Simulering!H43)","v":""}]
[null,null,{"$f":"IF(Simulering!B44=0,\"\",Simulering!B44)","v":""},{"$f":"IF(Simulering!C44=0,\"\",Simulering!C44)","v":""},{"$f":"IF(Simulering!D44=0,\"\",Simulering!D44)","v":""},null,null,{"$f":"IF(Simulering!E44=0,\"\",Simulering!E44)","v":""},{"$f":"IF(Simulering!F44=0,\"\",Simulering!F44)","v":""},null,{"$f":"IFERROR(VLOOKUP(D72,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H44=0,\"\",Simulering!H44)","v":""}]
[null,null,{"$f":"IF(Simulering!B45=0,\"\",Simulering!B45)","v":""},{"$f":"IF(Simulering!C45=0,\"\",Simulering!C45)","v":""},{"$f":"IF(Simulering!D45=0,\"\",Simulering!D45)","v":""},null,null,{"$f":"IF(Simulering!E45=0,\"\",Simulering!E45)","v":""},{"$f":"IF(Simulering!F45=0,\"\",Simulering!F45)","v":""},null,{"$f":"IFERROR(VLOOKUP(D73,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H45=0,\"\",Simulering!H45)","v":""}]
[null,null,{"$f":"IF(Simulering!B46=0,\"\",Simulering!B46)","v":""},{"$f":"IF(Simulering!C46=0,\"\",Simulering!C46)","v":""},{"$f":"IF(Simulering!D46=0,\"\",Simulering!D46)","v":""},null,null,{"$f":"IF(Simulering!E46=0,\"\",Simulering!E46)","v":""},{"$f":"IF(Simulering!F46=0,\"\",Simulering!F46)","v":""},null,{"$f":"IFERROR(VLOOKUP(D74,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H46=0,\"\",Simulering!H46)","v":""}]
[null,null,{"$f":"IF(Simulering!B47=0,\"\",Simulering!B47)","v":""},{"$f":"IF(Simulering!C47=0,\"\",Simulering!C47)","v":""},{"$f":"IF(Simulering!D47=0,\"\",Simulering!D47)","v":""},null,null,{"$f":"IF(Simulering!E47=0,\"\",Simulering!E47)","v":""},{"$f":"IF(Simulering!F47=0,\"\",Simulering!F47)","v":""},null,{"$f":"IFERROR(VLOOKUP(D75,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H47=0,\"\",Simulering!H47)","v":""}]
[null,null,{"$f":"IF(Simulering!B52=0,\"\",Simulering!B52)","v":""},{"$f":"IF(Simulering!C52=0,\"\",Simulering!C52)","v":""},{"$f":"IF(Simulering!D52=0,\"\",Simulering!D52)","v":""},null,null,{"$f":"IF(Simulering!E52=0,\"\",Simulering!E52)","v":""},{"$f":"IF(Simulering!F52=0,\"\",Simulering!F52)","v":""},null,{"$f":"IFERROR(VLOOKUP(D76,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H48=0,\"\",Simulering!H48)","v":""}]
[null,null,{"$f":"IF(Simulering!B53=0,\"\",Simulering!B53)","v":""},{"$f":"IF(Simulering!C53=0,\"\",Simulering!C53)","v":""},{"$f":"IF(Simulering!D53=0,\"\",Simulering!D53)","v":""},null,null,{"$f":"IF(Simulering!E53=0,\"\",Simulering!E53)","v":""},{"$f":"IF(Simulering!F53=0,\"\",Simulering!F53)","v":""},null,{"$f":"IFERROR(VLOOKUP(D77,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H49=0,\"\",Simulering!H49)","v":""}]
[null,null,{"$f":"IF(Simulering!B54=0,\"\",Simulering!B54)","v":""},{"$f":"IF(Simulering!C54=0,\"\",Simulering!C54)","v":""},{"$f":"IF(Simulering!D54=0,\"\",Simulering!D54)","v":""},null,null,{"$f":"IF(Simulering!E54=0,\"\",Simulering!E54)","v":""},{"$f":"IF(Simulering!F54=0,\"\",Simulering!F54)","v":""},null,{"$f":"IFERROR(VLOOKUP(D78,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H50=0,\"\",Simulering!H50)","v":""}]
[null,null,{"$f":"IF(Simulering!B55=0,\"\",Simulering!B55)","v":""},{"$f":"IF(Simulering!C55=0,\"\",Simulering!C55)","v":""},{"$f":"IF(Simulering!D55=0,\"\",Simulering!D55)","v":""},null,null,{"$f":"IF(Simulering!E55=0,\"\",Simulering!E55)","v":""},{"$f":"IF(Simulering!F55=0,\"\",Simulering!F55)","v":""},null,{"$f":"IFERROR(VLOOKUP(D79,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H51=0,\"\",Simulering!H51)","v":""}]
[null,null,{"$f":"IF(Simulering!B56=0,\"\",Simulering!B56)","v":""},{"$f":"IF(Simulering!C56=0,\"\",Simulering!C56)","v":""},{"$f":"IF(Simulering!D56=0,\"\",Simulering!D56)","v":""},null,null,{"$f":"IF(Simulering!E56=0,\"\",Simulering!E56)","v":""},{"$f":"IF(Simulering!F56=0,\"\",Simulering!F56)","v":""},null,{"$f":"IFERROR(VLOOKUP(D80,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H52=0,\"\",Simulering!H52)","v":""}]
[null,null,{"$f":"IF(Simulering!B57=0,\"\",Simulering!B57)","v":""},{"$f":"IF(Simulering!C57=0,\"\",Simulering!C57)","v":""},{"$f":"IF(Simulering!D57=0,\"\",Simulering!D57)","v":""},null,null,{"$f":"IF(Simulering!E57=0,\"\",Simulering!E57)","v":""},{"$f":"IF(Simulering!F57=0,\"\",Simulering!F57)","v":""},null,{"$f":"IFERROR(VLOOKUP(D81,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H53=0,\"\",Simulering!H53)","v":""}]
[null,null,{"$f":"IF(Simulering!B58=0,\"\",Simulering!B58)","v":""},{"$f":"IF(Simulering!C58=0,\"\",Simulering!C58)","v":""},{"$f":"IF(Simulering!D58=0,\"\",Simulering!D58)","v":""},null,null,{"$f":"IF(Simulering!E58=0,\"\",Simulering!E58)","v":""},{"$f":"IF(Simulering!F58=0,\"\",Simulering!F58)","v":""},null,{"$f":"IFERROR(VLOOKUP(D82,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H54=0,\"\",Simulering!H54)","v":""}]
[null,null,{"$f":"IF(Simulering!B59=0,\"\",Simulering!B59)","v":""},{"$f":"IF(Simulering!C59=0,\"\",Simulering!C59)","v":""},{"$f":"IF(Simulering!D59=0,\"\",Simulering!D59)","v":""},null,null,{"$f":"IF(Simulering!E59=0,\"\",Simulering!E59)","v":""},{"$f":"IF(Simulering!F59=0,\"\",Simulering!F59)","v":""},null,{"$f":"IFERROR(VLOOKUP(D83,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H55=0,\"\",Simulering!H55)","v":""}]
[null,null,{"$f":"IF(Simulering!B60=0,\"\",Simulering!B60)","v":""},{"$f":"IF(Simulering!C60=0,\"\",Simulering!C60)","v":""},{"$f":"IF(Simulering!D60=0,\"\",Simulering!D60)","v":""},null,null,{"$f":"IF(Simulering!E60=0,\"\",Simulering!E60)","v":""},{"$f":"IF(Simulering!F60=0,\"\",Simulering!F60)","v":""},null,{"$f":"IFERROR(VLOOKUP(D84,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H56=0,\"\",Simulering!H56)","v":""}]
[null,null,{"$f":"IF(Simulering!B61=0,\"\",Simulering!B61)","v":""},{"$f":"IF(Simulering!C61=0,\"\",Simulering!C61)","v":""},{"$f":"IF(Simulering!D61=0,\"\",Simulering!D61)","v":""},null,null,{"$f":"IF(Simulering!E61=0,\"\",Simulering!E61)","v":""},{"$f":"IF(Simulering!F61=0,\"\",Simulering!F61)","v":""},null,{"$f":"IFERROR(VLOOKUP(D85,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H57=0,\"\",Simulering!H57)","v":""}]
[null,null,{"$f":"IF(Simulering!B62=0,\"\",Simulering!B62)","v":""},{"$f":"IF(Simulering!C62=0,\"\",Simulering!C62)","v":""},{"$f":"IF(Simulering!D62=0,\"\",Simulering!D62)","v":""},null,null,{"$f":"IF(Simulering!E62=0,\"\",Simulering!E62)","v":""},{"$f":"IF(Simulering!F62=0,\"\",Simulering!F62)","v":""},null,{"$f":"IFERROR(VLOOKUP(D86,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H58=0,\"\",Simulering!H58)","v":""}]
[null,null,{"$f":"IF(Simulering!B63=0,\"\",Simulering!B63)","v":""},{"$f":"IF(Simulering!C63=0,\"\",Simulering!C63)","v":""},{"$f":"IF(Simulering!D63=0,\"\",Simulering!D63)","v":""},null,null,{"$f":"IF(Simulering!E63=0,\"\",Simulering!E63)","v":""},{"$f":"IF(Simulering!F63=0,\"\",Simulering!F63)","v":""},null,{"$f":"IFERROR(VLOOKUP(D87,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H59=0,\"\",Simulering!H59)","v":""}]
[null,null,{"$f":"IF(Simulering!B64=0,\"\",Simulering!B64)","v":""},{"$f":"IF(Simulering!C64=0,\"\",Simulering!C64)","v":""},{"$f":"IF(Simulering!D64=0,\"\",Simulering!D64)","v":""},null,null,{"$f":"IF(Simulering!E64=0,\"\",Simulering!E64)","v":""},{"$f":"IF(Simulering!F64=0,\"\",Simulering!F64)","v":""},null,{"$f":"IFERROR(VLOOKUP(D88,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H60=0,\"\",Simulering!H60)","v":""}]
[null,null,{"$f":"IF(Simulering!B65=0,\"\",Simulering!B65)","v":""},{"$f":"IF(Simulering!C65=0,\"\",Simulering!C65)","v":""},{"$f":"IF(Simulering!D65=0,\"\",Simulering!D65)","v":""},null,null,{"$f":"IF(Simulering!E65=0,\"\",Simulering!E65)","v":""},{"$f":"IF(Simulering!F65=0,\"\",Simulering!F65)","v":""},null,{"$f":"IFERROR(VLOOKUP(D89,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H61=0,\"\",Simulering!H61)","v":""}]
[null,null,{"$f":"IF(Simulering!B66=0,\"\",Simulering!B66)","v":""},{"$f":"IF(Simulering!C66=0,\"\",Simulering!C66)","v":""},{"$f":"IF(Simulering!D66=0,\"\",Simulering!D66)","v":""},null,null,{"$f":"IF(Simulering!E66=0,\"\",Simulering!E66)","v":""},{"$f":"IF(Simulering!F66=0,\"\",Simulering!F66)","v":""},null,{"$f":"IFERROR(VLOOKUP(D90,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H62=0,\"\",Simulering!H62)","v":""}]
[null,null,{"$f":"IF(Simulering!B67=0,\"\",Simulering!B67)","v":""},{"$f":"IF(Simulering!C67=0,\"\",Simulering!C67)","v":""},{"$f":"IF(Simulering!D67=0,\"\",Simulering!D67)","v":""},null,null,{"$f":"IF(Simulering!E67=0,\"\",Simulering!E67)","v":""},{"$f":"IF(Simulering!F67=0,\"\",Simulering!F67)","v":""},null,{"$f":"IFERROR(VLOOKUP(D91,Indtastninger!$H$6:$I$1048576,2,TRUE),\"\")","v":""},{"$f":"IF(Simulering!H63=0,\"\",Simulering!H63)","v":""}]