{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["UdenMakro","Faktura side 1","Faktura side 2"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":2,"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":"UdenMakro","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"1. Ups… DET VIRKER IKKE",null,null,null,null,null,null,null,null,"3. Når du har aktiveret indholdet,"]
[null,null,"Men det kan det heldigvis komme til.",null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"[Faktura Master.xlsm]'Faktura side 1'!A1\",\"KLIK HER for at fortsætte\")","v":"KLIK HER for at fortsætte"}]
[]
[null,null,"2. Klik på knappen for at tillade programmet at køre"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Det KAN se lidt anderledes ud hos dig, men overordnet set er det bare vores makroer som skal aktiveres før du"]
[null,null,"kan bruge vores regneark."]
[null,null,"Undskyld forstyrelsen - vi håber du bliver glad for værktøjet. Aktiver indholdet for at komme videre."]
[null,null,"https://www.excel-regneark.dk"]

{"sheet":"Faktura side 1","index":1,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[56,1,56,5],[57,1,57,5],[52,1,52,5],[51,1,51,5],[0,1,0,5],[1,1,1,5],[49,2,50,2],[49,5,50,5],[49,1,50,1],[49,4,50,4],[49,3,50,3]]}
[null,"Dit firmanavn                                    Dit logo"]
[]
[]
[]
[null,null,null,null,"Dato:"]
[null,null,null,null,"Fakturanummer:"]
[null,"Navn",null,null,"Vor ref:","Dit navn"]
[null,"Adresse",null,null,"Deres ref:"]
[null,"Postnummer / by"]
[null,"Andet",null,null,"Reg nr.","xxxx"]
[null,null,null,null,"Kontonummer:","xxxxxxx"]
[null,null,null,null,"Swift/Bic kode:","XXXXXXXXX"]
[null,null,null,null,"IBAN:","DKXXXXXXXXXXXX"]
[]
[null,null,null,null,"Betalingsdato:"]
[null,null,null,null,"Betaling:","Kontant"]
[]
[null,null,null,null,"Sider:"]
[]
[null,"Tekst","Antal","á pris","Rabat","I alt"]
[null,null,null,null,null,{"$f":"IF(C21*D21=0,\"\",(D21-(D21*E21))*C21)","v":""}]
[null,null,null,null,null,{"$f":"IF(C22*D22=0,\"\",(D22-(D22*E22))*C22)","v":""}]
[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,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,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,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,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,"Fragttype",null,"Vare angivelse"]
[null,"Fragten er inkl. moms",null,"Inkl. moms"]
[]
[null,{"$f":"IF(F18>1,\"\",\"Fragt:\")","v":"Fragt:"},{"$f":"IF(F18>1,\"\",\"Ekskl. moms:\")","v":"Ekskl. moms:"},{"$f":"IF(F18>1,\"\",\"Moms sats:\")","v":"Moms sats:"},{"$f":"IF(F18>1,\"\",\"Moms:\")","v":"Moms:"},{"$f":"IF(F18>1,\"Subtotal:\",\"I alt inkl. moms\")","v":"I alt inkl. moms"}]
[null,0,{"$f":"IF(D50=\"\",\"\",IF(D50=0,SUM(F21:F48),IF(AND(B47=\"Fragten er ekskl. moms\",D47=\"Ekskl. moms\"),SUM(F21:F48)+B50,IF(AND(B47=\"Fragten er ekskl. moms\",D47=\"Inkl. moms\"),(SUM(F21:F48)-SUM(F21:F48)*1/(1/D50+1))+B50,IF(AND(B47=\"Fragten er inkl. moms\",D47=\"Ekskl. moms\"),SUM(F21:F48),IF(AND(B47=\"Fragten er inkl. moms\",D47=\"Inkl. moms\"),(SUM(F21:F48)-SUM(F21:F48)*1/(1/D50+1))))))))","v":0},{"$f":"IF(F18>1,\"\",IF(D47=\"Uden moms\",0,0.25))","v":0.25},{"$f":"IF(D50=0,0,IF(F18>1,\"\",C50*(1+D50)-C50))","v":0},{"$f":"IF(F18>1,SUM(F21:F48),IF(B47=\"Fragten er ekskl. moms\",C50+E50,C50+E50+B50))","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Navn • Adresse1 • Adresse2 • Postnr By"]
[null,"CVR • Bank: Bank konto nr.: xxxx xxxxxxx • Web: www.excel-regneark.dk"]

{"sheet":"Faktura side 2","index":2,"n_rows":58,"n_cols":6,"rows_kept":58,"cut":false,"hidden":false,"merged":[[49,3,50,3],[56,1,56,5],[57,1,57,5],[52,1,52,5],[51,1,51,5],[0,1,0,5],[1,1,1,5],[49,2,50,2],[49,5,50,5],[49,1,50,1],[49,4,50,4]]}
[null,{"$f":"'Faktura side 1'!B1:F1","v":"Dit firmanavn                                    Dit logo"}]
[]
[]
[]
[null,null,null,null,{"$f":"'Faktura side 1'!E5","v":"Dato:"},{"$f":"'Faktura side 1'!F5","v":"00:00:00"}]
[null,null,null,null,{"$f":"'Faktura side 1'!E6","v":"Fakturanummer:"},{"$f":"'Faktura side 1'!F6","v":0}]
[null,{"$f":"'Faktura side 1'!B7","v":"Navn"},null,null,{"$f":"'Faktura side 1'!E7","v":"Vor ref:"},{"$f":"'Faktura side 1'!F7","v":"Dit navn"}]
[null,{"$f":"'Faktura side 1'!B8","v":"Adresse"},null,null,{"$f":"'Faktura side 1'!E8","v":"Deres ref:"},{"$f":"'Faktura side 1'!F8","v":0}]
[null,{"$f":"'Faktura side 1'!B9","v":"Postnummer / by"}]
[null,{"$f":"'Faktura side 1'!B10","v":"Andet"},null,null,{"$f":"'Faktura side 1'!E10","v":"Reg nr."},{"$f":"'Faktura side 1'!F10","v":"xxxx"}]
[null,null,null,null,{"$f":"'Faktura side 1'!E11","v":"Kontonummer:"},{"$f":"'Faktura side 1'!F11","v":"xxxxxxx"}]
[null,null,null,null,{"$f":"'Faktura side 1'!E12","v":"Swift/Bic kode:"},{"$f":"'Faktura side 1'!F12","v":"XXXXXXXXX"}]
[null,null,null,null,{"$f":"'Faktura side 1'!E13","v":"IBAN:"},{"$f":"'Faktura side 1'!F13","v":"DKXXXXXXXXXXXX"}]
[]
[null,null,null,null,{"$f":"'Faktura side 1'!E15","v":"Betalingsdato:"},{"$f":"'Faktura side 1'!F15","v":"00:00:00"}]
[null,null,null,null,{"$f":"'Faktura side 1'!E16","v":"Betaling:"},{"$f":"'Faktura side 1'!F16","v":"Kontant"}]
[]
[null,null,null,null,{"$f":"'Faktura side 1'!E18","v":"Sider:"},{"$f":"'Faktura side 1'!F18","v":0}]
[]
[null,{"$f":"'Faktura side 1'!B20","v":"Tekst"},{"$f":"'Faktura side 1'!C20","v":"Antal"},{"$f":"'Faktura side 1'!D20","v":"á pris"},{"$f":"'Faktura side 1'!E20","v":"Rabat"},{"$f":"'Faktura side 1'!F20","v":"I alt"}]
[null,null,null,null,null,{"$f":"IF(C21*D21=0,\"\",(D21-(D21*E21))*C21)","v":""}]
[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,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,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,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,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[null,null,null,null,null,""]
[]
[null,{"$f":"'Faktura side 1'!B47","v":"Fragten er inkl. moms"},null,{"$f":"'Faktura side 1'!D47","v":"Inkl. moms"}]
[]
[null,{"$f":"IF(F18=1,\"\",\"Fragt:\")","v":"Fragt:"},{"$f":"IF(F18=1,\"\",\"Excl moms:\")","v":"Excl moms:"},{"$f":"IF(F18=1,\"\",\"Moms sats:\")","v":"Moms sats:"},{"$f":"IF(F18=1,\"\",\"Moms:\")","v":"Moms:"},{"$f":"IF(F18=1,\"\",\"I alt inkl. moms\")","v":"I alt inkl. moms"}]
[null,null,{"$f":"IF(D50=\"\",\"\",IF(D50=0,'Faktura side 1'!F50+SUM(F21:F48),IF(AND(B47=\"Fragten er ekskl. moms\",D47=\"Ekskl. moms\"),SUM(F21:F48)+SUM('Faktura side 1'!F21:F48)+B50,IF(AND(B47=\"Fragten er ekskl. moms\",D47=\"Inkl. moms\"),((SUM(F21:F48)++SUM('Faktura side 1'!F21:F48))-(SUM(F21:F48)+SUM('Faktura side 1'!F21:F48))*1/(1/D50+1))+B50,IF(AND(B47=\"Fragten er inkl. moms\",D47=\"Ekskl. moms\"),SUM(F21:F48)+SUM('Faktura side 1'!F21:F48),IF(AND(B47=\"Fragten er inkl. moms\",D47=\"Inkl. moms\"),((SUM(F21:F48)+SUM('Faktura side 1'!F21:F48))-(SUM(F21:F48)+SUM('Faktura side 1'!F21:F48))*1/(1/D50+1))))))))","v":0},{"$f":"IF(F18=1,\"\",IF(D47=\"Uden moms\",0,0.25))","v":0.25},{"$f":"IF(F18=1,\"\",C50*(1+D50)-C50)","v":0},{"$f":"IF(F18=1,\"\",IF(B47=\"Fragten er ekskl. moms\",C50+E50,C50+E50+B50))","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Faktura side 1'!B57","v":"Navn • Adresse1 • Adresse2 • Postnr By"}]
[null,{"$f":"'Faktura side 1'!$B$58","v":"CVR • Bank: Bank konto nr.: xxxx xxxxxxx • Web: www.excel-regneark.dk"}]