{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Sample","Expense Report"],"read":"whole","date_system":"1900"}

{"sheet":"Sample","index":0,"n_rows":20,"n_cols":10,"rows_kept":20}
["Date","Expense","Category","Total Amount","Paid Amount","Due Amount"]
["2025-01-12","Office Rent","Office",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["2025-01-15","Grocery","Personal",{"v":90,"d":"$90"},{"v":90,"d":"$90"},0]
["2025-01-18","Internet Bill","Office",{"v":60,"d":"$60"},{"v":60,"d":"$60"},0]
["2025-01-20","Dinner","Personal",{"v":45,"d":"$45"},{"v":45,"d":"$45"},0]
["2025-01-23","Laptop Repair","Office",{"v":150,"d":"$150"},{"v":100,"d":"$100"},{"v":50,"d":"$50"}]
["2025-01-30","Electricity Bill","Personal",{"v":65,"d":"$65"},{"v":50,"d":"$50"},{"v":15,"d":"$15"}]
["2025-02-02","Office Rent","Office",{"v":500,"d":"$500"},{"v":500,"d":"$500"},0]
["2025-02-05","Grocery","Personal",{"v":95,"d":"$95"},{"v":95,"d":"$95"},0]
["2025-02-10","Internet Bill","Office",{"v":60,"d":"$60"},{"v":60,"d":"$60"},0]
["2025-02-13","Doctor Visit","Personal",{"v":75,"d":"$75"},{"v":50,"d":"$50"},{"v":25,"d":"$25"}]
[]
[]
[{"$nulls":7},{"$f":"_xlfn.UNIQUE(B2:B11)","v":"Office Rent"},null,"Office Rent,Grocery,Internet Bill,Dinner,Laptop Repair,Electricity Bill,Doctor Visit"]
[{"$nulls":7},"Grocery"]
[{"$nulls":7},"Internet Bill"]
[{"$nulls":7},"Dinner"]
[{"$nulls":7},"Laptop Repair"]
[{"$nulls":7},"Electricity Bill"]
[{"$nulls":7},"Doctor Visit"]

{"sheet":"Expense Report","index":1,"n_rows":15,"n_cols":7,"rows_kept":15,"merged":[[1,1,1,6]]}
[]
[null,"Expense Report"]
[]
[null,"Date","Expense","Category","Total Amount","Paid Amount","Due Amount"]
[null,"2025-01-12","Office Rent","Office",{"v":500,"d":"$500"},{"v":500,"d":"$500"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-01-15","Grocery","Personal",{"v":90,"d":"$90"},{"v":90,"d":"$90"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-01-18","Internet Bill","Office",{"v":60,"d":"$60"},{"v":60,"d":"$60"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-01-20","Dinner","Personal",{"v":45,"d":"$45"},{"v":45,"d":"$45"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-01-23","Electricity Bill","Personal",{"v":65,"d":"$65"},{"v":50,"d":"$50"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":{"v":15,"d":"$15"}}]
[null,"2025-01-30","Laptop Repair","Office",{"v":150,"d":"$150"},{"v":100,"d":"$100"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":{"v":50,"d":"$50"}}]
[null,"2025-02-02","Office Rent","Office",{"v":500,"d":"$500"},{"v":400,"d":"$400"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":{"v":100,"d":"$100"}}]
[null,"2025-02-05","Grocery","Personal",{"v":95,"d":"$95"},{"v":95,"d":"$95"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-02-10","Internet Bill","Office",{"v":60,"d":"$60"},{"v":60,"d":"$60"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":0}]
[null,"2025-02-13","Doctor Visit","Personal",{"v":75,"d":"$75"},{"v":50,"d":"$50"},{"$f":"Table2[[#This Row],[Total Amount]]-Table2[[#This Row],[Paid Amount]]","v":{"v":25,"d":"$25"}}]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Table2[Total Amount])","v":{"v":1640,"d":"$1,640"}},{"$f":"SUBTOTAL(109,Table2[Paid Amount])","v":{"v":1450,"d":"$1,450"}},{"$f":"SUBTOTAL(109,Table2[Due Amount])","v":{"v":190,"d":"$190"}}]