{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Kommersiell faktura","Kunder"],"not_rendered":{"defined_names":18},"read":"whole","date_system":"1900"}

{"sheet":"Kommersiell faktura","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"merged":[[0,1,1,3],[0,6,0,7],[1,6,1,7]]}
[null,"TAILSPIN TOYS",null,null,"Storgatan 123","T: 123-555-0123","tailspin@interestingsite.com",null,null,"Kunder"]
[{"$nulls":4},"12345 Sjöstaden","F: 123-555-0124","www.tailspintoys.com"]
[]
[null,"Faktureringsadress:","Lilli Allik","Telefon:",{"$f":"IFERROR(VLOOKUP(Fakturanamn,Kundlista[],8,FALSE),\"\")","v":"432-555-0178"},null,"Fakturanummer:",34567]
[null,"Adress:",{"$f":"IFERROR(VLOOKUP(Fakturanamn,Kundlista[],3,FALSE),\"\")","v":"Kungsgatan 345"},"Fax:",{"$f":"IFERROR(VLOOKUP(Fakturanamn,Kundlista[],10,FALSE),\"\")","v":"432-555-0187"},null,"Fakturadatum:",{"$f":"TODAY()","v":"2022-12-08"}]
[null,null,{"$f":"IF(VLOOKUP(Fakturanamn,Kundlista[],4,FALSE)<>\"\",VLOOKUP(Fakturanamn,Kundlista[],4,FALSE),IF(VLOOKUP(Fakturanamn,Kundlista[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(Fakturanamn,Kundlista[],5,FALSE),\", \",VLOOKUP(Fakturanamn,Kundlista[],6,FALSE),\" \",VLOOKUP(Fakturanamn,Kundlista[],7,FALSE)),CONCATENATE(VLOOKUP(Fakturanamn,Kundlista[],6,FALSE),\" \",VLOOKUP(Fakturanamn,Kundlista[],7,FALSE))))","v":"Svit 123"},"E-postadress:",{"$f":"IFERROR(VLOOKUP(Fakturanamn,Kundlista[],9,FALSE),\"\")","v":"mike@excellentwebsite.com"},null,"Kontakt:",{"$f":"IFERROR(VLOOKUP(Fakturanamn,Kundlista[],2,FALSE),\"\")","v":"Allan Sandberg"}]
[null,null,{"$f":"IF(VLOOKUP(Fakturanamn,Kundlista[],4,FALSE)=\"\",\"\",IF(VLOOKUP(Fakturanamn,Kundlista[],5,FALSE)<>\"\",CONCATENATE(VLOOKUP(Fakturanamn,Kundlista[],5,FALSE),\", \",VLOOKUP(Fakturanamn,Kundlista[],6,FALSE),\" \",VLOOKUP(Fakturanamn,Kundlista[],7,FALSE)),CONCATENATE(VLOOKUP(Fakturanamn,Kundlista[],6,FALSE),\" \",VLOOKUP(Fakturanamn,Kundlista[],7,FALSE))))","v":"Storstad, SD 12345"}]
[null,"DATUM","ARTIKELNR","BESKRIVNING","ANTAL","AENHETSPRIS","RABATT","SUMMA"]
[null,{"$f":"TODAY()","v":"2022-12-08"},789807,"Träblock",4,{"v":10,"d":"10.00 kr"},{"v":2,"d":"2.00 kr"},{"$f":"IF(AND(Fakturaposter[[#This Row],[ANTAL]]<>\"\",Fakturaposter[[#This Row],[AENHETSPRIS]]<>\"\"),(Fakturaposter[[#This Row],[ANTAL]]*Fakturaposter[[#This Row],[AENHETSPRIS]])-Fakturaposter[[#This Row],[RABATT]],\"\")","v":{"v":38,"d":"38.00 kr"}}]
[{"$nulls":7},{"$f":"IF(AND(Fakturaposter[[#This Row],[ANTAL]]<>\"\",Fakturaposter[[#This Row],[AENHETSPRIS]]<>\"\"),(Fakturaposter[[#This Row],[ANTAL]]*Fakturaposter[[#This Row],[AENHETSPRIS]])-Fakturaposter[[#This Row],[RABATT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Fakturaposter[[#This Row],[ANTAL]]<>\"\",Fakturaposter[[#This Row],[AENHETSPRIS]]<>\"\"),(Fakturaposter[[#This Row],[ANTAL]]*Fakturaposter[[#This Row],[AENHETSPRIS]])-Fakturaposter[[#This Row],[RABATT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Fakturaposter[[#This Row],[ANTAL]]<>\"\",Fakturaposter[[#This Row],[AENHETSPRIS]]<>\"\"),(Fakturaposter[[#This Row],[ANTAL]]*Fakturaposter[[#This Row],[AENHETSPRIS]])-Fakturaposter[[#This Row],[RABATT]],\"\")","v":""}]
[{"$nulls":7},{"$f":"IF(AND(Fakturaposter[[#This Row],[ANTAL]]<>\"\",Fakturaposter[[#This Row],[AENHETSPRIS]]<>\"\"),(Fakturaposter[[#This Row],[ANTAL]]*Fakturaposter[[#This Row],[AENHETSPRIS]])-Fakturaposter[[#This Row],[RABATT]],\"\")","v":""}]
[{"$nulls":6},"Delsumma för faktura",{"$f":"SUM(Fakturaposter[SUMMA])","v":{"v":38,"d":"38.00 kr"}}]
[{"$nulls":6},"Skattesats",{"v":0.089,"d":"9%"}]
[{"$nulls":6},"Moms",{"$f":"FakturaDelsumma*Momssats","v":{"v":3.3819999999999997,"d":"3.38 kr"}}]
[{"$nulls":6},"Frakt",{"v":5,"d":"5.00 kr"}]
[null,{"$f":"\"Alla checkar ska ställas ut till \"&UPPER(Företagsnamn)&\".\"","v":"Alla checkar ska ställas ut till TAILSPIN TOYS."},{"$nulls":4},"Insättning mottagen",{"v":0,"d":"0.00 kr"}]
[null,"Betalning inom 10 dagar. Försenad betalning omfattas av en ränteavgift på 2 % per månad.",{"$nulls":4},"Summa",{"$f":"FakturaDelsumma+Moms+Frakt-Insättning","v":{"v":46.382,"d":"46.38 kr"}}]

{"sheet":"Kunder","index":1,"n_rows":4,"n_cols":13,"rows_kept":4}
[null,"KUNDER",{"$nulls":10},"Kommersiell faktura"]
[null,"FÖRETAGETS NAMN","KONTAKTINFORMATION","ADRESS","ADDRESS2","ORT","LAND","POSTNUMMER","TELEFON","E-POST","FAX"]
[null,"Lilli Allik","Allan Sandberg","Kungsgatan 345","Svit 123","Storstad","SD",12345,"432-555-0178","mike@excellentwebsite.com","432-555-0187"]
[null,"Contoso, Ltd","Naima Larsson","Drottninggatan 567",null,"Småstad","MO","09876","432-555-0189","contoso@websitegoeshere.com","432-555-0123"]