{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Calculate","Example"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Calculate","index":0,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["WORKING FROM HOME DEDUCTIONS 2020-21"]
["Please input only in cells shaded in yellow. See comments for details and sheet \"Example\" for reference."]
["Start date",{"$nulls":4},"2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01"]
["End date",{"$nulls":4},"2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30"]
[]
["1 Input expense numbers (without decimals)",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
["Electricity",{"$nulls":16},{"$f":"SUM(F7:Q7)","v":0}]
["Gas",{"$nulls":16},0]
["Cleaning",{"$nulls":16},0]
["Repairs to above $300 items",{"$nulls":16},0]
["Landline",{"$nulls":16},0]
["Mobile",{"$nulls":16},0]
["Internet",{"$nulls":16},0]
["Consumables",{"$nulls":16},0]
["Stationery",{"$nulls":16},0]
["Other expenses",{"$nulls":16},0]
["Purchases up to $300 each item",{"$nulls":16},0]
[{"$nulls":4},"Total",{"$f":"SUM(F7:F17)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["2 Input purchase numbers for above $300 items",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
[null,"Purchase date","Purchase amount","Useful life","End date"]
["Asset name",null,null,4,{"$f":"B22+D22*365-1","v":"1903-12-29"},{"$f":"ROUND(((IF($E22>F$3,IF($E22<F$4,_xlfn.DAYS($E22,F$3)+1,IF($B22<F$3,_xlfn.DAYS(F$4,F$3)+1,IF($B22<F$4,_xlfn.DAYS(F$4,$B22)+1,0))))*$C22*100/$D22)/100)/365,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F22:Q22)","v":0}]
["Asset name",null,null,4,{"$f":"B23+D23*365-1","v":"1903-12-29"},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(F23:Q23)","v":0}]
["Asset name",null,null,4,{"$f":"B24+D24*365-1","v":"1903-12-29"},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Asset name",null,null,4,{"$f":"B25+D25*365-1","v":"1903-12-29"},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Asset name",null,null,4,{"$f":"B26+D26*365-1","v":"1903-12-29"},0,0,0,0,0,0,0,0,0,0,0,0,0]
["Asset name",null,null,4,{"$f":"B27+D27*365-1","v":"1903-12-29"},0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Total",{"$f":"SUM(F22:F27)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["3 Work% (only numbers-no sign)"]
["4 Hours worked from home"]
[]
["5 Calculation (Automatic)",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
["Fixed Rate Method",null,null,null,0.52,{"$f":"ROUND(F31*$E$34,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Other actuals to add with fixed rate",{"$nulls":4},{"$f":"ROUND((SUM(F11,F12,F13,F14,F15,F17,F16)+F28)*F30/100,0)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Option 1 : Fixed rate method (if you have dedicated work area)",{"$nulls":4},{"$f":"SUM(F34:F35)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(F36:Q36),0)","v":0}]
[]
["Option 2 : All actual expenses",{"$nulls":4},{"$f":"ROUND((SUM(F7:F17)+SUM(F22:F27))*F30/100,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(F38:Q38),0)","v":0},"Highest"]
[]
["Option 3 : Shortcut method (available Mar-Jun 2020)",null,null,null,0.8,{"$f":"F31*$E$40","v":0},0,0,0,0,0,0,{"$f":"M31*$E$40","v":0},{"$f":"N31*$E$40","v":0},{"$f":"O31*$E$40","v":0},{"$f":"P31*$E$40","v":0},{"$f":"Q31*$E$40","v":0},{"$f":"ROUND(SUM(F40:Q40),0)","v":0}]
[]
["6 Select your option for each month (whichever is higher)",{"$nulls":16},{"$f":"ROUND(SUM(F42:Q42),0)","v":0}]

{"sheet":"Example","index":1,"n_rows":42,"n_cols":19,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
["WORKING FROM HOME DEDUCTIONS 2020-21"]
["Please input only in cells shaded in yellow. See comments for details and sheet \"Example\" for reference."]
["Start date",{"$nulls":4},"2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01"]
["End date",{"$nulls":4},"2020-07-31","2020-08-31","2020-09-30","2020-10-31","2020-11-30","2020-12-31","2021-01-31","2021-02-28","2021-03-31","2021-04-30","2021-05-31","2021-06-30"]
[]
["1 Input expense numbers (without decimals)",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
["Electricity",{"$nulls":4},138,138,138,138,138,138,138,138,138,138,138,138,{"$f":"SUM(F7:Q7)","v":1656}]
["Gas",{"$nulls":4},31,31,31,31,31,31,31,31,31,31,31,31,372]
["Cleaning",{"$nulls":16},0]
["Repairs to above $300 items",{"$nulls":16},0]
["Landline",{"$nulls":16},0]
["Mobile",{"$nulls":4},112,112,112,112,112,112,112,112,112,112,112,112,1344]
["Internet",{"$nulls":4},99,99,99,99,99,99,99,99,99,99,99,99,1188]
["Consumables",{"$nulls":16},0]
["Stationery",{"$nulls":16},0]
["Other expenses",{"$nulls":16},0]
["Purchases up to $300 each item",{"$nulls":4},250,207,194,{"$nulls":9},651]
[{"$nulls":4},"Total",{"$f":"SUM(F7:F17)","v":630},587,574,380,380,380,380,380,380,380,380,380]
[]
["2 Input purchase numbers for above $300 items",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
[null,"Purchase date","Purchase amount","Useful life","End date"]
["Chair","2020-08-24",624,4,{"$f":"B22+D22*365-1","v":"2024-08-22"},{"$f":"ROUND(((IF($E22>F$3,IF($E22<F$4,_xlfn.DAYS($E22,F$3)+1,IF($B22<F$3,_xlfn.DAYS(F$4,F$3)+1,IF($B22<F$4,_xlfn.DAYS(F$4,$B22)+1,0))))*$C22*100/$D22)/100)/365,0)","v":0},3,13,13,13,13,13,12,13,13,13,13,{"$f":"SUM(F22:Q22)","v":132}]
["Monitor","2020-09-12",580,4,{"$f":"B23+D23*365-1","v":"2024-09-10"},0,0,8,12,12,12,12,11,12,12,12,12,{"$f":"SUM(F23:Q23)","v":115}]
["Audio","2021-02-02",335,4,{"$f":"B24+D24*365-1","v":"2025-01-31"},0,0,0,0,0,0,0,6,7,7,7,7,34]
["Computer","2020-10-27",1998,4,{"$f":"B25+D25*365-1","v":"2024-10-25"},0,0,0,7,41,42,42,38,42,41,42,41,336]
["Computer","2020-11-05",663,4,{"$f":"B26+D26*365-1","v":"2024-11-03"},0,0,0,0,12,14,14,13,14,14,14,14,109]
["Computer","2020-11-13",1314,4,{"$f":"B27+D27*365-1","v":"2024-11-11"},0,0,0,0,16,28,28,25,28,27,28,27,207]
[{"$nulls":4},"Total",{"$f":"SUM(F22:F27)","v":0},3,21,32,94,109,109,105,116,114,116,114]
[]
["3 Work% (only numbers-no sign)",{"$nulls":4},70,70,70,70,70,70,70,70,70,70,70,70]
["4 Hours worked from home",{"$nulls":4},217,217,217,217,217,217,217,217,217,217,217,217]
[]
["5 Calculation (Automatic)",{"$nulls":4},"Jul","Aug","Sep","Oct","Nov","Dec","Jan","Feb","Mar","Apr","Mar","Jun","Total"]
["Fixed Rate Method",null,null,null,0.52,{"$f":"ROUND(F31*$E$34,0)","v":113},113,113,113,113,113,113,113,113,113,113,113]
["Other actuals to add with fixed rate",{"$nulls":4},{"$f":"ROUND((SUM(F11,F12,F13,F14,F15,F17,F16)+F28)*F30/100,0)","v":323},295,298,170,214,224,224,221,229,228,229,228]
["Option 1 : Fixed rate method (if you have dedicated work area)",{"$nulls":4},{"$f":"SUM(F34:F35)","v":436},408,411,283,327,337,337,334,342,341,342,341,{"$f":"ROUND(SUM(F36:Q36),0)","v":4239}]
[]
["Option 2 : All actual expenses",{"$nulls":4},{"$f":"ROUND((SUM(F7:F17)+SUM(F22:F27))*F30/100,0)","v":441},413,417,288,332,342,342,340,347,346,347,346,{"$f":"ROUND(SUM(F38:Q38),0)","v":4301},"Highest"]
[]
["Option 3 : Shortcut method (available Mar-Jun 2020)",null,null,null,0.8,{"$f":"F31*$E$40","v":173.60000000000002},173.60000000000002,173.60000000000002,173.60000000000002,173.60000000000002,173.60000000000002,173.60000000000002,{"$f":"M31*$E$40","v":173.60000000000002},{"$f":"N31*$E$40","v":173.60000000000002},{"$f":"O31*$E$40","v":173.60000000000002},{"$f":"P31*$E$40","v":173.60000000000002},{"$f":"Q31*$E$40","v":173.60000000000002},{"$f":"ROUND(SUM(F40:Q40),0)","v":2083}]
[]
["6 Select your option for each month (whichever is higher)",{"$nulls":16},{"$f":"ROUND(SUM(F42:Q42),0)","v":0}]