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

{"sheet":"Credit card log","index":0,"n_rows":11,"n_cols":7,"rows_kept":11,"merged":[[0,1,0,6],[10,5,10,6]]}
[null,"Credit Card Name"]
[null,"Enter payments as negative amounts in table below."]
[null,"Date","Description","Amount","Merchant name","Transaction fees","Balance*"]
[null,{"$f":"TODAY()-5","v":"2019-03-14"},"Existing balance",{"v":45,"d":"£45.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":45,"d":"£45.00"}}]
[null,{"$f":"TODAY()-4","v":"2019-03-15"},"Payment for June",{"v":-34,"d":"-£34.00"},"Woodgrove Bank",{"v":2,"d":"£2.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":13,"d":"£13.00"}}]
[null,{"$f":"TODAY()-3","v":"2019-03-16"},"Picture frame",{"v":45,"d":"£45.00"},"Daisychain Toys",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":58,"d":"£58.00"}}]
[null,{"$f":"TODAY()-2","v":"2019-03-17"},"Wine",{"v":600,"d":"£600.00"},"Wide World Importers",{"v":20,"d":"£20.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":678,"d":"£678.00"}}]
[null,{"$f":"TODAY()-1","v":"2019-03-18"},"Ticket to Maui",{"v":469,"d":"£469.00"},"Margie’s Travel",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":1147,"d":"£1,147.00"}}]
[null,{"$f":"TODAY()","v":"2019-03-19"},"Cash withdrawal",{"v":654,"d":"£654.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance*]])=1,Data[[#This Row],[Transaction fees]]+Data[[#This Row],[Amount]],SUM(INDEX(Data[Amount],1,1):Data[[#This Row],[Amount]],INDEX(Data[Transaction fees],1,1):Data[[#This Row],[Transaction fees]])), \"\")","v":{"v":1801,"d":"£1,801.00"}}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Data[Amount])","v":{"v":1779,"d":"£1,779.00"}},null,{"$f":"SUBTOTAL(109,Data[Transaction fees])","v":{"v":22,"d":"£22.00"}}]
[{"$nulls":5},"*(does not include interest)"]