{"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":15,"n_cols":8,"rows_kept":15,"merged":[[2,2,2,7],[3,2,3,7]]}
[]
[]
[null,null,"CREDIT CARD TRANSACTION LOG"]
[null,null,"Enter payments as negative amounts in table below."]
[]
[]
[]
[null,null,"DATE","DESCRIPTION","AMOUNT","MERCHANT NAME","TRANSACTION FEES","BALANCE (DOES NOT INCLUDE INTEREST)"]
[null,null,{"$f":"TODAY()-5","v":"2023-05-17"},"Existing balance",{"v":45,"d":"$45.00"},"Woodgrove Bank",{"v":0,"d":"$0.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,null,{"$f":"TODAY()-4","v":"2023-05-18"},"Payment for June",{"v":-34,"d":"-$34.00"},"Woodgrove Bank",{"v":2,"d":"$2.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,null,{"$f":"TODAY()-3","v":"2023-05-19"},"Picture frame",{"v":45,"d":"$45.00"},"Northwind Traders",{"v":0,"d":"$0.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,null,{"$f":"TODAY()-2","v":"2023-05-20"},"Wine",{"v":600,"d":"$600.00"},"Larkspur West",{"v":20,"d":"$20.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,null,{"$f":"TODAY()-1","v":"2023-05-21"},"Ticket to Maui",{"v":469,"d":"$469.00"},"Margie's Travel ",{"v":0,"d":"$0.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,null,{"$f":"TODAY()","v":"2023-05-22"},"Cash withdrawal",{"v":654,"d":"$654.00"},"Woodgrove Bank",{"v":0,"d":"$0.00"},{"$f":"IFERROR(IF(ROW()-ROW(Data[[#Headers],[BALANCE (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,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"}}]