{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["20XX HO Deductions","20XX Business Deductions"],"read":"whole","date_system":"1900"}

{"sheet":"20XX HO Deductions","index":0,"n_rows":42,"n_cols":9,"rows_kept":42}
["Utilities"]
[null,"Heat","Electric","Mobile phone","Landline","Internet","Water","Other","Total"]
["Bill Date","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)"]
["January",{"$nulls":7},{"$f":"SUM(B4:H4)","v":0}]
["February",{"$nulls":7},0]
["March",{"$nulls":7},0]
["April",{"$nulls":7},0]
["May",{"$nulls":7},0]
["June",{"$nulls":7},0]
["July",{"$nulls":7},0]
["August",{"$nulls":7},0]
["September",{"$nulls":7},0]
["October",{"$nulls":7},0]
["November",{"$nulls":7},0]
["December",{"$nulls":7},0]
["Total",{"$f":"SUM(B4:B15)","v":0},0,0,0,0,0,0,0]
[]
["Housing","Mortgage/ rent","Property taxes","Condo fees","Homeowners insurance","Home improvement","Other","Total"]
["Bill Date","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)","Amount ($)"]
["January",{"$nulls":6},{"$f":"SUM(B20:G20)","v":0}]
["February",{"$nulls":6},0]
["March",{"$nulls":6},0]
["April",{"$nulls":6},0]
["May",{"$nulls":6},0]
["June",{"$nulls":6},0]
["July",{"$nulls":6},0]
["August",{"$nulls":6},0]
["September",{"$nulls":6},0]
["October",{"$nulls":6},0]
["November",{"$nulls":6},0]
["December",{"$nulls":6},0]
["Total",{"$f":"SUM(B20:B31)","v":0},0,0,0,0,{"$f":"SUM(G20:G31)","v":0},{"$f":"SUM(H20:H31)","v":0}]
[]
[]
[]
["Office space (sq. ft.)"]
["Total living space (sq. ft.)"]
["% of home used for business",{"$f":"B36/B37","v":{"$error":"#DIV/0!"}}]
[]
["% of utilities",{"$f":"I16*B38","v":{"$error":"#DIV/0!"}}]
["% of housing",{"$f":"H32*B38","v":{"$error":"#DIV/0!"}}]
["Total deduction",{"$f":"SUM(B40:B41)","v":{"$error":"#DIV/0!"}},"<--This is the magic number"]

{"sheet":"20XX Business Deductions","index":1,"n_rows":63,"n_cols":4,"rows_kept":63}
["Date","Description","Amount ($)","Tag"]
{"$rows_empty":18}
["1Q 20XX",null,{"$f":"SUM(C2:C19)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":9}
["2Q 20XX",null,{"$f":"SUM(C22:C29)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":11}
["3Q 20XX",null,{"$f":"SUM(C22:C41)","v":{"v":0,"d":"0.00"}}]
{"$rows_empty":18}
["4Q 20XX",null,{"$f":"SUM(C44:C60)","v":{"v":0,"d":"0.00"}}]
[]
["20XX Total",null,{"$f":"C20+C42","v":{"v":0,"d":"0.00"}}]