{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Employee information","Payroll calculator","Individual payslips"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Employee information","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"merged":[[1,0,1,12],[2,0,2,5]]}
[]
["Employee information"]
["[Company Name]"]
["Employee ID","Employee name","Hourly wage","Tax status","Tax allowance (if applicable)","Student loan","Income tax (based on tax allowance)","National Insurance","Medical insurance","Total taxes withheld","Insurance deduction","Other regular deduction","Total regular deductions (excluding taxes)"]
[1,"Jesper Aaberg",{"v":10,"d":"£10.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[[#This Row],[Student loan]]+Table1[[#This Row],[Income tax (based on tax allowance)]]+Table1[[#This Row],[National Insurance]]+Table1[[#This Row],[Medical insurance]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"£20.00"},{"v":40,"d":"£40.00"},{"$f":"Table1[[#This Row],[Insurance deduction]]+Table1[[#This Row],[Other regular deduction]]","v":{"v":60,"d":"£60.00"}}]
[2,"Wilson Pais",{"v":13,"d":"£13.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[[#This Row],[Student loan]]+Table1[[#This Row],[Income tax (based on tax allowance)]]+Table1[[#This Row],[National Insurance]]+Table1[[#This Row],[Medical insurance]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"£20.00"},{"v":52,"d":"£52.00"},{"$f":"Table1[[#This Row],[Insurance deduction]]+Table1[[#This Row],[Other regular deduction]]","v":{"v":72,"d":"£72.00"}}]
[3,"Kathie Flood",{"v":10,"d":"£10.00"},1,4,{"v":0.023,"d":"2.30%"},{"v":0.28,"d":"28.00%"},{"v":0.063,"d":"6.30%"},{"v":0.0145,"d":"1.45%"},{"$f":"Table1[[#This Row],[Student loan]]+Table1[[#This Row],[Income tax (based on tax allowance)]]+Table1[[#This Row],[National Insurance]]+Table1[[#This Row],[Medical insurance]]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"£20.00"},0,{"$f":"Table1[[#This Row],[Insurance deduction]]+Table1[[#This Row],[Other regular deduction]]","v":{"v":20,"d":"£20.00"}}]

{"sheet":"Payroll calculator","index":1,"n_rows":7,"n_cols":11,"rows_kept":7,"merged":[[0,0,1,8],[2,0,2,5]]}
["Payroll calculator"]
[{"$nulls":9},"Period ending:",{"v":45688,"d":"4568800.00%"}]
[{"$f":"'Employee information'!$A$3","v":"[Company Name]"}]
["Employee ID","Employee name","Regular hours worked","Holiday hours","Sick hours","Overtime hours","Overtime rate","Gross pay","Taxes and deductions ","Other deduction","Net pay"]
[1,{"$f":"VLOOKUP(A5,Table1[],2,FALSE)","v":"Jesper Aaberg"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A5,Table1[],3,FALSE)*(Table2[[#This Row],[Regular hours worked]]+Table2[[#This Row],[Holiday hours]]+Table2[[#This Row],[Sick hours]])+Table2[[#This Row],[Overtime hours]]*Table2[[#This Row],[Overtime rate]])","v":{"v":560,"d":"£560.00"}},{"$f":"VLOOKUP(A5,Table1[],10,FALSE)*Table2[[#This Row],[Gross pay]]+Table1[[#This Row],[Total regular deductions (excluding taxes)]]","v":{"v":273.08000000000004,"d":"£273.08"}},{"v":20,"d":"£20.00"},{"$f":"Table2[[#This Row],[Gross pay]]-Table2[[#This Row],[Taxes and deductions ]]-Table2[[#This Row],[Other deduction]]","v":{"v":266.91999999999996,"d":"£266.92"}}]
[2,{"$f":"VLOOKUP(A6,Table1[],2,FALSE)","v":"Wilson Pais"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A6,Table1[],3,FALSE)*(Table2[[#This Row],[Regular hours worked]]+Table2[[#This Row],[Holiday hours]]+Table2[[#This Row],[Sick hours]])+Table2[[#This Row],[Overtime hours]]*Table2[[#This Row],[Overtime rate]])","v":{"v":520,"d":"£520.00"}},{"$f":"VLOOKUP(A6,Table1[],10,FALSE)*Table2[[#This Row],[Gross pay]]+Table1[[#This Row],[Total regular deductions (excluding taxes)]]","v":{"v":269.86,"d":"£269.86"}},{"v":52,"d":"£52.00"},{"$f":"Table2[[#This Row],[Gross pay]]-Table2[[#This Row],[Taxes and deductions ]]-Table2[[#This Row],[Other deduction]]","v":{"v":198.14,"d":"£198.14"}}]
[3,{"$f":"VLOOKUP(A7,Table1[],2,FALSE)","v":"Kathie Flood"},{"v":52,"d":"52.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":2,"d":"2.00"},{"v":20,"d":"£20.00"},{"$f":"(VLOOKUP(A7,Table1[],3,FALSE)*(Table2[[#This Row],[Regular hours worked]]+Table2[[#This Row],[Holiday hours]]+Table2[[#This Row],[Sick hours]])+Table2[[#This Row],[Overtime hours]]*Table2[[#This Row],[Overtime rate]])","v":{"v":560,"d":"£560.00"}},{"$f":"VLOOKUP(A7,Table1[],10,FALSE)*Table2[[#This Row],[Gross pay]]+Table1[[#This Row],[Total regular deductions (excluding taxes)]]","v":{"v":233.08000000000004,"d":"£233.08"}},{"v":20,"d":"£20.00"},{"$f":"Table2[[#This Row],[Gross pay]]-Table2[[#This Row],[Taxes and deductions ]]-Table2[[#This Row],[Other deduction]]","v":{"v":306.91999999999996,"d":"£306.92"}}]

{"sheet":"Individual payslips","index":2,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[1,2,1,7],[13,2,13,7],[25,2,25,7],[38,2,38,7]]}
[]
[null,null,{"$f":"('Employee information'!$A$3)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H3,Table1[],2),\"\")","v":"Jesper Aaberg"},"Employee ID",1]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H3,Table1[],4),\"\")","v":1},"Tax Allowance (if applicable)",{"$f":"IFERROR(VLOOKUP(H3,Table1[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H3,Table2[],3,FALSE),\"\")","v":50}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H3,Table1[],3,FALSE),\"\")","v":{"v":10,"d":"£10.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H3,Table2[],7,FALSE),\"\")","v":0},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H3,Table2[],5,FALSE),\"\")","v":1}]
[null,null,"National Insurance",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],8,FALSE),\"\")*H9,\"\")","v":{"v":35.28,"d":"£35.28"}},"Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],7,FALSE),\"\")*H9,\"\")","v":{"v":156.8,"d":"£156.80"}},"Holiday Hours",{"$f":"IFERROR(VLOOKUP(H3,Table2[],4,FALSE),\"\")","v":5}]
[null,null,"Medical Insurance ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],9,FALSE),\"\")*H9,\"\")","v":{"v":8.120000000000001,"d":"£8.12"}},"Student loan ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table1[],6,FALSE),\"\")*H9,\"\")","v":{"v":12.879999999999999,"d":"£12.88"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H3,Table2[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H3,Table1[],11,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H3,Table1[],12,FALSE),\"\")","v":{"v":40,"d":"£40.00"}},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H3,Table2[],8,FALSE),\"\")","v":{"v":560,"d":"£560.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F7:F9)+SUM(D7:D9),\"\")","v":{"v":273.08000000000004,"d":"£273.08"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H3,Table2[],10,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H3,Table2[],9,FALSE),\"\")+F10,\"\")","v":{"v":293.08000000000004,"d":"£293.08"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H3,Table2[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"£266.92"}}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$3)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H15,Table1[],2),\"\")","v":"Wilson Pais"},"Employee ID",2]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H15,Table1[],4),\"\")","v":1},"Tax Allowance (if applicable)",{"$f":"IFERROR(VLOOKUP(H15,Table1[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H15,Table2[],3,FALSE),\"\")","v":40}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H15,Table1[],3,FALSE),\"\")","v":{"v":13,"d":"£13.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H15,Table2[],7,FALSE),\"\")","v":0},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H15,Table2[],5,FALSE),\"\")","v":0}]
[null,null,"National Insurance",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],8,FALSE),\"\")*H21,\"\")","v":{"v":32.76,"d":"£32.76"}},"Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],7,FALSE),\"\")*H21,\"\")","v":{"v":145.60000000000002,"d":"£145.60"}},"Holiday Hours",{"$f":"IFERROR(VLOOKUP(H15,Table2[],4,FALSE),\"\")","v":0}]
[null,null,"Medical Insurance ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],9,FALSE),\"\")*H21,\"\")","v":{"v":7.54,"d":"£7.54"}},"Student loan ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table1[],6,FALSE),\"\")*H21,\"\")","v":{"v":11.959999999999999,"d":"£11.96"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H15,Table2[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H15,Table1[],11,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H15,Table1[],12,FALSE),\"\")","v":{"v":52,"d":"£52.00"}},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H15,Table2[],8,FALSE),\"\")","v":{"v":520,"d":"£520.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F19:F21)+SUM(D19:D21),\"\")","v":{"v":269.86,"d":"£269.86"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H15,Table2[],10,FALSE),\"\")","v":{"v":52,"d":"£52.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H15,Table2[],9,FALSE),\"\")+F22,\"\")","v":{"v":321.86,"d":"£321.86"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H15,Table2[],11,FALSE),\"\")","v":{"v":198.14,"d":"£198.14"}}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$3)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H27,Table1[],2),\"\")","v":"Kathie Flood"},"Employee ID",3]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H27,Table1[],4),\"\")","v":1},"Tax Allowance (if applicable)",{"$f":"IFERROR(VLOOKUP(H27,Table1[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H27,Table2[],3,FALSE),\"\")","v":52}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H27,Table1[],3,FALSE),\"\")","v":{"v":10,"d":"£10.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H27,Table2[],7,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H27,Table2[],5,FALSE),\"\")","v":0}]
[null,null,"National Insurance",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],8,FALSE),\"\")*H33,\"\")","v":{"v":35.28,"d":"£35.28"}},"Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],7,FALSE),\"\")*H33,\"\")","v":{"v":156.8,"d":"£156.80"}},"Holiday Hours",{"$f":"IFERROR(VLOOKUP(H27,Table2[],4,FALSE),\"\")","v":0}]
[null,null,"Medical Insurance ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],9,FALSE),\"\")*H33,\"\")","v":{"v":8.120000000000001,"d":"£8.12"}},"Student loan ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table1[],6,FALSE),\"\")*H33,\"\")","v":{"v":12.879999999999999,"d":"£12.88"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H27,Table2[],6,FALSE),\"\")","v":2}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H27,Table1[],11,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H27,Table1[],12,FALSE),\"\")","v":0},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H27,Table2[],8,FALSE),\"\")","v":{"v":560,"d":"£560.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F31:F33)+SUM(D31:D33),\"\")","v":{"v":233.08,"d":"£233.08"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H27,Table2[],10,FALSE),\"\")","v":{"v":20,"d":"£20.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H27,Table2[],9,FALSE),\"\")+F34,\"\")","v":{"v":253.08000000000004,"d":"£253.08"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H27,Table2[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"£306.92"}}]
[]
[]
[]
[null,null,{"$f":"('Employee information'!$A$3)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$K$2","v":{"v":45688,"d":"4568800.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H40,Table1[],2),\"\")","v":""},"Employee ID"]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H40,Table1[],4),\"\")","v":""},"Tax Allowance (if applicable)",{"$f":"IFERROR(VLOOKUP(H40,Table1[],5,FALSE),\"\")","v":""},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H40,Table2[],3,FALSE),\"\")","v":""}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H40,Table1[],3,FALSE),\"\")","v":""},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H40,Table2[],7,FALSE),\"\")","v":""},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H40,Table2[],5,FALSE),\"\")","v":""}]
[null,null,"National Insurance",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],8,FALSE),\"\")*H46,\"\")","v":""},"Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],7,FALSE),\"\")*H46,\"\")","v":""},"Holiday Hours",{"$f":"IFERROR(VLOOKUP(H40,Table2[],4,FALSE),\"\")","v":""}]
[null,null,"Medical Insurance ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],9,FALSE),\"\")*H46,\"\")","v":""},"Student loan ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table1[],6,FALSE),\"\")*H46,\"\")","v":""},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H40,Table2[],6,FALSE),\"\")","v":""}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H40,Table1[],11,FALSE),\"\")","v":""},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H40,Table1[],12,FALSE),\"\")","v":""},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H40,Table2[],8,FALSE),\"\")","v":""}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F44:F46)+SUM(D44:D46),\"\")","v":0},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H40,Table2[],10,FALSE),\"\")","v":""},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H40,Table2[],9,FALSE),\"\")+F47,\"\")","v":""}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H40,Table2[],11,FALSE),\"\")","v":""}]