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

{"sheet":"Kreditkortslogg","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[null,"Kreditkortsnamn"]
[null,"Ange betalningar som negativa belopp i tabellen nedan."]
[null,"Datum","Beskrivning","Belopp","Företagsnamn","Transaktionsavgifter","Saldo\n(inkluderar inte ränta)"]
[null,{"$f":"TODAY()-5","v":"2018-06-24"},"Befintligt saldo",{"v":45,"d":"45.00 kr"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":45,"d":"45.00 kr"}}]
[null,{"$f":"TODAY()-4","v":"2018-06-25"},"Betalning för juni",{"v":-34,"d":"-34.00 kr"},"Woodgrove Bank",{"v":2,"d":"2.00 kr"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":13,"d":"13.00 kr"}}]
[null,{"$f":"TODAY()-3","v":"2018-06-26"},"Bildram",{"v":45,"d":"45.00 kr"},"Northwind Traders",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":58,"d":"58.00 kr"}}]
[null,{"$f":"TODAY()-2","v":"2018-06-27"},"Vin",{"v":600,"d":"600.00 kr"},"Coho Winery",{"v":20,"d":"20.00 kr"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":678,"d":"678.00 kr"}}]
[null,{"$f":"TODAY()-1","v":"2018-06-28"},"Biljett till Maui",{"v":469,"d":"469.00 kr"},"Blue Yonder Airlines",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":1147,"d":"1,147.00 kr"}}]
[null,{"$f":"TODAY()","v":"2018-06-29"},"Kontantuttag",{"v":654,"d":"654.00 kr"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Saldo\n(inkluderar inte ränta)]])=1,Data[[#This Row],[Transaktionsavgifter]]+Data[[#This Row],[Belopp]],SUM(INDEX(Data[Belopp],1,1):Data[[#This Row],[Belopp]],INDEX(Data[Transaktionsavgifter],1,1):Data[[#This Row],[Transaktionsavgifter]])), \"\")","v":{"v":1801,"d":"1,801.00 kr"}}]
[null,"Summa",null,{"$f":"SUBTOTAL(109,Data[Belopp])","v":{"v":1779,"d":"1,779.00 kr"}},null,{"$f":"SUBTOTAL(109,Data[Transaktionsavgifter])","v":{"v":22,"d":"22.00 kr"}}]