{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Fakturaöversikt"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Fakturaöversikt","index":0,"n_rows":9,"n_cols":10,"rows_kept":9}
[null,"Fakturaöversikt"]
[null,"Fakturanummer","Datum","Förfallodatum för betalning","Kundens namn","Belopp ","Förseningsavgift ","Totalt betalat","Betalningsdatum","Utestående"]
[null,1001,{"$f":"DATE(YEAR(TODAY()),1,15)","v":"2018-01-15"},{"$f":"DATE(YEAR(TODAY()),2,15)","v":"2018-02-15"},"Svensson",{"v":141393,"d":"141,393.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":0},{"v":141393,"d":"141,393.00 SEK"},{"$f":"DATE(YEAR(TODAY()),2,1)","v":"2018-02-01"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":0}]
[null,1002,{"$f":"DATE(YEAR(TODAY()),2,11)","v":"2018-02-11"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Svensson",{"v":109900,"d":"109,900.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":{"v":5,"d":"5.00 SEK"}},{"v":52500,"d":"52,500.00 SEK"},{"$f":"DATE(YEAR(TODAY()),4,10)","v":"2018-04-10"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":{"v":57405,"d":"57,405.00 SEK"}}]
[null,1003,{"$f":"DATE(YEAR(TODAY()),2,17)","v":"2018-02-17"},{"$f":"DATE(YEAR(TODAY()),4,15)","v":"2018-04-15"},"Contoso",{"v":96593,"d":"96,593.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":0},{"v":38500,"d":"38,500.00 SEK"},{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":{"v":58093,"d":"58,093.00 SEK"}}]
[null,1004,{"$f":"DATE(YEAR(TODAY()),3,8)","v":"2018-03-08"},{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},"Jens Persson",{"v":840,"d":"840.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":{"v":5,"d":"5.00 SEK"}},{"v":525,"d":"525.00 SEK"},{"$f":"DATE(YEAR(TODAY()),4,16)","v":"2018-04-16"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":{"v":320,"d":"320.00 SEK"}}]
[null,1005,{"$f":"DATE(YEAR(TODAY()),3,17)","v":"2018-03-17"},{"$f":"DATE(YEAR(TODAY()),4,30)","v":"2018-04-30"},"Contoso",{"v":1050,"d":"1,050.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":0},{"v":525,"d":"525.00 SEK"},{"$f":"DATE(YEAR(TODAY()),4,11)","v":"2018-04-11"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":{"v":525,"d":"525.00 SEK"}}]
[null,1006,{"$f":"DATE(YEAR(TODAY()),4,1)","v":"2018-04-01"},{"$f":"DATE(YEAR(TODAY()),6,1)","v":"2018-06-01"},"Martina Mattsson",{"v":10325,"d":"10,325.00 SEK"},{"$f":"IFERROR(IF(Fakturor[[#This Row],[Förfallodatum för betalning]]>=Fakturor[[#This Row],[Betalningsdatum]],,5), \"\")","v":0},{"v":8400,"d":"8,400.00 SEK"},{"$f":"DATE(YEAR(TODAY()),4,28)","v":"2018-04-28"},{"$f":"IFERROR(Fakturor[[#This Row],[Belopp ]]-Fakturor[[#This Row],[Totalt betalat]]+Fakturor[[#This Row],[Förseningsavgift ]], \"\")","v":{"v":1925,"d":"1,925.00 SEK"}}]
[null,"Summa",{"$nulls":3},{"$f":"SUBTOTAL(109,Fakturor[[Belopp ]])","v":{"v":360101,"d":"360,101.00 SEK"}},null,{"$f":"SUBTOTAL(109,Fakturor[Totalt betalat])","v":{"v":241843,"d":"241,843.00 SEK"}},null,{"$f":"SUBTOTAL(109,Fakturor[Utestående])","v":{"v":118268,"d":"118,268.00 SEK"}}]