{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Credit Card Transactions","Formula","Lambda","Pivot Table","Power Query","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":10,"comments":1,"pivot_tables":1},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Credit Card Transactions","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Date","Details","Category","Withdrawal","Deposit","Balance"]
["2023-05-27","CARRIED OVER","Start",null,null,0]
["2023-05-27","Café Latte","Food & Drink",5.9,null,{"$f":"F2-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-5.9}]
["2023-06-19","Supermarket","Food & Drink",8.25,null,{"$f":"F3-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-14.15}]
["2023-06-19","Café Latte","Food & Drink",8.5,null,{"$f":"F4-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-22.65}]
["2023-06-24","Clothes","Presents",199.49,null,{"$f":"F5-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-222.14000000000001}]
["2023-06-30","ACE Cards","Repayment",null,5.9,{"$f":"F6-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-216.24}]
["2023-07-31","ACE Cards","Repayment",null,216.24,{"$f":"F7-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":0}]
["2023-10-03","Supermarket","Food & Drink",25.56,null,{"$f":"F8-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-25.56}]
["2023-10-23","Supermarket","Food & Drink",15.71,null,{"$f":"F9-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-41.269999999999996}]
["2023-10-28","Supermarket","Food & Drink",16.920000000000002,null,{"$f":"F10-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-58.19}]
["2023-11-11","Supermarket","Food & Drink",32.69,null,{"$f":"F11-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-90.88}]
["2023-11-14","Supermarket","Food & Drink",16.13,null,{"$f":"F12-TableTransactions[[#This Row],[Withdrawal]]+TableTransactions[[#This Row],[Deposit]]","v":-107.00999999999999}]

{"sheet":"Formula","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Month","Amount Owed"]
[null,"May",{"$f":"SUM(_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(TableTransactions[],TEXT(TableTransactions[Date],\"mmm\")=B3, 0),4))","v":5.9}]
[null,"Jun",{"$f":"SUM(_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(TableTransactions[],TEXT(TableTransactions[Date],\"mmm\")=B4, 0),4))","v":216.24}]
[null,"Jul",{"$f":"SUM(_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(TableTransactions[],TEXT(TableTransactions[Date],\"mmm\")=B5, 0),4))","v":0}]
[null,"Oct",{"$f":"SUM(_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(TableTransactions[],TEXT(TableTransactions[Date],\"mmm\")=B6, 0),4))","v":58.19}]
[null,"Nov",{"$f":"SUM(_xlfn.CHOOSECOLS(_xlfn._xlws.FILTER(TableTransactions[],TEXT(TableTransactions[Date],\"mmm\")=B7, 0),4))","v":48.819999999999993}]

{"sheet":"Lambda","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"References"]
[null,"Excel LAMBDA function: how to write, calculate and use (ablebits.com)"]
[]
[]
[]
[null,"Month","Amount Owed"]
[null,"Oct",{"$f":"AmountOwedLambda(B8)","v":58.19}]
[null,"Nov",{"$f":"AmountOwedLambda(B9)","v":48.819999999999993}]

{"sheet":"Pivot Table","index":3,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Amount Owed"]
[null,"May",5.9]
[null,"Jun",216.24]
[null,"Jul"]
[null,"Oct",58.19]
[null,"Nov",48.819999999999993]

{"sheet":"Power Query","index":4,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[[5,1,5,2],[5,4,5,6],[5,14,5,15]]}
[null,"References"]
[null,"Create a parameter query (Power Query) - Microsoft Support"]
[null,"Parameters - Power Query | Microsoft Learn"]
[]
[]
[null,"Basic Table",null,null,"Basic Table (w/ Month and Year)",null,null,null,"Parameterised Query",null,"1) Input Month",null,"2) Filter Month",null,"Filtered Query"]
[]
[null,"Month","Amount Owed",null,"Month","Year","Amount Owed",null,"Amount Owed",null,"Month",null,"FilterMonthValue",null,"MonthName","Amount Owed"]
[null,"May",5.9,null,5,2023,5.9,null,5.9,null,"Oct",null,"Oct",null,"Oct",58.19]
[null,"Jun",216.24,null,6,2023,216.24]
[null,"Jul",null,null,7,2023]
[null,"Oct",58.19,null,10,2023,58.19]
[null,"Nov",48.82,null,11,2023,48.819999999999993]

{"sheet":"VBA","index":5,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Month","Amount Owed"]
[null,"May",{"$f":"AmountOwed(B3)","v":5.9}]
[null,"Jun",{"$f":"AmountOwed(B4)","v":216.24}]
[null,"Jul",{"$f":"AmountOwed(B5)","v":0}]
[null,"Oct",{"$f":"AmountOwed(B6)","v":58.19}]
[null,"Nov",{"$f":"AmountOwed(B7)","v":48.82}]