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

{"sheet":"Credit Card Log","index":0,"n_rows":10,"n_cols":7,"rows_kept":10}
[null,"Credit Card Name"]
[null,"Enter payments as negative amounts in table below."]
[null,"Date","Description","Amount","Merchant name","Transaction fees","Balance\n(does not include interest)"]
[null,{"$f":"TODAY()-5","v":"2018-06-24"},"Existing balance",{"v":45,"d":"£45.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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":"2018-06-25"},"Payment for June",{"v":-34,"d":"-£34.00"},"Woodgrove Bank",{"v":2,"d":"£2.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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":"2018-06-26"},"Picture frame",{"v":45,"d":"£45.00"},"Daisy chain Toys",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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":"2018-06-27"},"Wine",{"v":600,"d":"£600.00"},"Coho Winery",{"v":20,"d":"£20.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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":"2018-06-28"},"Ticket to Maui",{"v":469,"d":"£469.00"},"Blue Yonder Airlines",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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":"2018-06-29"},"Cash withdrawal",{"v":654,"d":"£654.00"},"Woodgrove Bank",null,{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[Balance\n(does not include interest)]])=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"}}]