{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Check register"],"not_rendered":{"charts":1,"images":2,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Check register","index":0,"n_rows":22,"n_cols":19,"rows_kept":22}
[]
[{"$nulls":12},"Breakdown of withdrawals"]
[{"$nulls":5},"CHECK REGISTER",{"$nulls":10},{"$f":"_xlfn.RANK.EQ(S3,$S$3:$S$9,0)","v":2},"Credit card",{"$f":"SUMIF(TBL_Transactions[Category],R3, TBL_Transactions[Withdrawal])+ROW(R3)/10000","v":936.4803}]
[{"$nulls":5},"Bank account number: ",null,987654321,{"$nulls":8},{"$f":"_xlfn.RANK.EQ(S4,$S$3:$S$9,0)","v":3},"Groceries",{"$f":"SUMIF(TBL_Transactions[Category],R4, TBL_Transactions[Withdrawal])+ROW(R4)/10000","v":205.61040000000003}]
[{"$nulls":5},"Current balance: ",null,{"$f":"\" \" & TEXT(OFFSET(I1,COUNTA(I:I)+5,0),\"$ #,##0.00\")","v":" $ 613.89"},{"$nulls":8},7,"Insurance",{"$f":"SUMIF(TBL_Transactions[Category],R5, TBL_Transactions[Withdrawal])+ROW(R5)/10000","v":35.200500000000005}]
[{"$nulls":16},4,"Investment",{"$f":"SUMIF(TBL_Transactions[Category],R6, TBL_Transactions[Withdrawal])+ROW(R6)/10000","v":200.0006}]
[{"$nulls":16},1,"Mortgage",{"$f":"SUMIF(TBL_Transactions[Category],R7, TBL_Transactions[Withdrawal])+ROW(R7)/10000","v":961.7707}]
[{"$nulls":16},6,"Other",{"$f":"SUMIF(TBL_Transactions[Category],R8, TBL_Transactions[Withdrawal])+ROW(R8)/10000","v":53.6508}]
[{"$nulls":16},5,"Utilities",{"$f":"SUMIF(TBL_Transactions[Category],R9, TBL_Transactions[Withdrawal])+ROW(R9)/10000","v":194.20090000000002}]
[null,null,"Date","Check #","Description","Category","Withdrawal","Deposit","Balance"]
[null,null,{"$f":"TODAY()-B11","v":"2023-02-27"}]
[null,60,"2022-12-29",null,"Beginning balance","Deposit",null,{"v":2916.73,"d":"$2,916.73"},{"$f":"Balance","v":{"v":2916.73,"d":"$2,916.73"}}]
[null,45,"2023-01-13",2251,"Grocery store","Groceries",{"v":205.61,"d":"$205.61"},null,{"$f":"Balance","v":{"v":2711.12,"d":"$2,711.12"}}]
[null,40,"2023-01-18",67112449,"Home mortgage","Mortgage",{"v":961.77,"d":"$961.77"},null,{"$f":"Balance","v":{"v":1749.35,"d":"$1,749.35"}}]
[null,35,"2023-01-23","Debit","Coffee shop","Other",{"v":3.65,"d":"$3.65"},null,{"$f":"Balance","v":{"v":1745.6999999999998,"d":"$1,745.70"}}]
[null,30,"2023-01-28",2252,"Gas and electric company","Utilities",{"v":145.33,"d":"$145.33"},null,{"$f":"Balance","v":{"v":1600.37,"d":"$1,600.37"}},{"$nulls":4},{"$f":"VLOOKUP(1,$Q$3:$S$9,2,FALSE)","v":"Mortgage"},{"$f":"VLOOKUP(1,$Q$3:$S$9,3,FALSE)","v":{"v":961.7707,"d":"$ 961.77"}}]
[null,25,"2023-02-02","ATM","Cash","Other",{"v":50,"d":"$50.00"},null,{"$f":"Balance","v":{"v":1550.37,"d":"$1,550.37"}},{"$nulls":4},{"$f":"VLOOKUP(2,$Q$3:$S$9,2,FALSE)","v":"Credit card"},{"$f":"VLOOKUP(2,$Q$3:$S$9,3,FALSE)","v":{"v":936.4803,"d":"$ 936.48"}}]
[null,20,"2023-02-07",68240158,"Credit card","Credit card",{"v":936.48,"d":"$936.48"},null,{"$f":"Balance","v":{"v":613.8899999999999,"d":"$613.89"}},{"$nulls":4},{"$f":"VLOOKUP(3,$Q$3:$S$9,2,FALSE)","v":"Groceries"},{"$f":"VLOOKUP(3,$Q$3:$S$9,3,FALSE)","v":{"v":205.61040000000003,"d":"$ 205.61"}}]
[null,15,"2023-02-12",null,"Paycheck","Deposit",null,{"v":2365.82,"d":"$2,365.82"},{"$f":"Balance","v":{"v":2979.71,"d":"$2,979.71"}},{"$nulls":4},{"$f":"VLOOKUP(4,$Q$3:$S$9,2,FALSE)","v":"Investment"},{"$f":"VLOOKUP(4,$Q$3:$S$9,3,FALSE)","v":{"v":200.0006,"d":"$ 200.00"}}]
[null,7,"2023-02-20",null,"Mutual fund investment","Investment",{"v":200,"d":"$200.00"},null,{"$f":"Balance","v":{"v":2779.71,"d":"$2,779.71"}},{"$nulls":4},{"$f":"VLOOKUP(5,$Q$3:$S$9,2,FALSE)","v":"Utilities"},{"$f":"VLOOKUP(5,$Q$3:$S$9,3,FALSE)","v":{"v":194.20090000000002,"d":"$ 194.20"}}]
[null,1,"2023-02-26",2253,"The Phone Company","Utilities",{"v":48.87,"d":"$48.87"},null,{"$f":"Balance","v":{"v":2730.84,"d":"$2,730.84"}},{"$nulls":4},{"$f":"VLOOKUP(6,$Q$3:$S$9,2,FALSE)","v":"Other"},{"$f":"VLOOKUP(6,$Q$3:$S$9,3,FALSE)","v":{"v":53.6508,"d":"$ 53.65"}}]
[null,0,"2023-02-27","25-552","Insurance","Insurance",{"v":35.2,"d":"$35.20"},null,{"$f":"Balance","v":{"v":2695.6400000000003,"d":"$2,695.64"}},{"$nulls":4},{"$f":"VLOOKUP(7,$Q$3:$S$9,2,FALSE)","v":"Insurance"},{"$f":"VLOOKUP(7,$Q$3:$S$9,3,FALSE)","v":{"v":35.200500000000005,"d":"$ 35.20"}}]