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

{"sheet":"Employee information","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"merged":[[0,0,0,12],[1,0,1,5]]}
["Employee Information"]
["[Company Name]"]
["Employee ID","Employee Name","Hourly\nWage","Tax\nStatus","Federal Allowance\n(From W-4)","State Tax","Federal Income Tax\n(Based on Federal Allowance)","Social Security\nTax","Medicare\nTax","Total Taxes\nWithheld","Insurance\nDeduction","Other Regular\nDeduction","Total\nRegular Deductions\n(Excluding taxes)"]
[1,"[Employee 1]",{"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":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"$20.00"},{"v":40,"d":"$40.00"},{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":{"v":60,"d":"$60.00"}}]
[2,"[Employee 2]",{"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":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"$20.00"},{"v":52,"d":"$52.00"},{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":{"v":72,"d":"$72.00"}}]
[3,"[Employee 3]",{"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":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"$20.00"},0,{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":{"v":20,"d":"$20.00"}}]

{"sheet":"Payroll calculator","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"merged":[[0,0,0,10],[1,0,1,5]]}
["Payroll calculator"]
[{"$f":"'Employee information'!$A$2","v":"[Company Name]"},{"$nulls":5},"Period Ending:",{"$f":"TODAY()","v":{"v":42304,"d":"4230400.00%"}}]
["Employee ID","Employee Name","Regular Hours\nWorked","Vacation\nHours","Sick\nHours","Overtime\nHours","Overtime\nRate","Gross\nPay","Taxes\nand\nDeductions ","Other\nDeduction","Net Pay"]
[1,{"$f":"VLOOKUP(A4,EmployeeInformation[],2,FALSE)","v":"[Employee 1]"},{"v":50,"d":"50.00"},{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},null,null,{"$f":"(VLOOKUP(A4,EmployeeInformation[],3,FALSE)*(PayrollCalculator[Regular Hours\nWorked]+PayrollCalculator[Vacation\nHours]+PayrollCalculator[Sick\nHours])+PayrollCalculator[Overtime\nHours]*PayrollCalculator[Overtime\nRate])","v":{"v":560,"d":"$560.00"}},{"$f":"VLOOKUP(A4,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":{"v":273.08000000000004,"d":"$273.08"}},{"v":20,"d":"$20.00"},{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":{"v":266.91999999999996,"d":"$266.92"}}]
[2,{"$f":"VLOOKUP(A5,EmployeeInformation[],2,FALSE)","v":"[Employee 2]"},{"v":40,"d":"40.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,{"$f":"(VLOOKUP(A5,EmployeeInformation[],3,FALSE)*(PayrollCalculator[Regular Hours\nWorked]+PayrollCalculator[Vacation\nHours]+PayrollCalculator[Sick\nHours])+PayrollCalculator[Overtime\nHours]*PayrollCalculator[Overtime\nRate])","v":{"v":520,"d":"$520.00"}},{"$f":"VLOOKUP(A5,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":{"v":269.86,"d":"$269.86"}},{"v":52,"d":"$52.00"},{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":{"v":198.14,"d":"$198.14"}}]
[3,{"$f":"VLOOKUP(A6,EmployeeInformation[],2,FALSE)","v":"[Employee 3]"},{"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(A6,EmployeeInformation[],3,FALSE)*(PayrollCalculator[Regular Hours\nWorked]+PayrollCalculator[Vacation\nHours]+PayrollCalculator[Sick\nHours])+PayrollCalculator[Overtime\nHours]*PayrollCalculator[Overtime\nRate])","v":{"v":560,"d":"$560.00"}},{"$f":"VLOOKUP(A6,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":{"v":233.08000000000004,"d":"$233.08"}},{"v":20,"d":"$20.00"},{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":{"v":306.91999999999996,"d":"$306.92"}}]

{"sheet":"Individual paystubs","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"merged":[[0,2,0,7],[12,2,12,7],[24,2,24,7],[37,2,37,7]]}
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":{"v":42304,"d":"4230400.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],2),\"\")","v":"[Employee 1]"},"Employee ID",1]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],4),\"\")","v":1},"Federal Allowance (From W-4)",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],3,FALSE),\"\")","v":50}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],3,FALSE),\"\")","v":{"v":10,"d":"$10.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],7,FALSE),\"\")","v":0},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],5,FALSE),\"\")","v":1}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],8,FALSE),\"\")*H8,\"\")","v":{"v":35.28,"d":"$35.28"}},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],7,FALSE),\"\")*H8,\"\")","v":{"v":156.8,"d":"$156.80"}},"Vacation Hours",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],4,FALSE),\"\")","v":5}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],9,FALSE),\"\")*H8,\"\")","v":{"v":8.120000000000001,"d":"$8.12"}},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],6,FALSE),\"\")*H8,\"\")","v":{"v":12.879999999999999,"d":"$12.88"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],11,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],12,FALSE),\"\")","v":{"v":40,"d":"$40.00"}},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],8,FALSE),\"\")","v":{"v":560,"d":"$560.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F6:F8)+SUM(D6:D8),\"\")","v":{"v":273.08000000000004,"d":"$273.08"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],10,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,PayrollCalculator[],9,FALSE),\"\")+F9,\"\")","v":{"v":293.08000000000004,"d":"$293.08"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],11,FALSE),\"\")","v":{"v":266.91999999999996,"d":"$266.92"}}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":{"v":42304,"d":"4230400.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],2),\"\")","v":"[Employee 2]"},"Employee ID",2]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],4),\"\")","v":1},"Federal Allowance (From W-4)",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],3,FALSE),\"\")","v":40}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],3,FALSE),\"\")","v":{"v":13,"d":"$13.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],7,FALSE),\"\")","v":0},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],5,FALSE),\"\")","v":0}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],8,FALSE),\"\")*H20,\"\")","v":{"v":32.76,"d":"$32.76"}},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],7,FALSE),\"\")*H20,\"\")","v":{"v":145.60000000000002,"d":"$145.60"}},"Vacation Hours",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],4,FALSE),\"\")","v":0}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],9,FALSE),\"\")*H20,\"\")","v":{"v":7.54,"d":"$7.54"}},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],6,FALSE),\"\")*H20,\"\")","v":{"v":11.959999999999999,"d":"$11.96"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],11,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],12,FALSE),\"\")","v":{"v":52,"d":"$52.00"}},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],8,FALSE),\"\")","v":{"v":520,"d":"$520.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F18:F20)+SUM(D18:D20),\"\")","v":{"v":269.86,"d":"$269.86"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],10,FALSE),\"\")","v":{"v":52,"d":"$52.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,PayrollCalculator[],9,FALSE),\"\")+F21,\"\")","v":{"v":321.86,"d":"$321.86"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],11,FALSE),\"\")","v":{"v":198.14,"d":"$198.14"}}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":{"v":42304,"d":"4230400.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],2),\"\")","v":"[Employee 3]"},"Employee ID",3]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],4),\"\")","v":1},"Federal Allowance (From W-4)",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],5,FALSE),\"\")","v":4},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],3,FALSE),\"\")","v":52}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],3,FALSE),\"\")","v":{"v":10,"d":"$10.00"}},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],7,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],5,FALSE),\"\")","v":0}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],8,FALSE),\"\")*H32,\"\")","v":{"v":35.28,"d":"$35.28"}},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],7,FALSE),\"\")*H32,\"\")","v":{"v":156.8,"d":"$156.80"}},"Vacation Hours",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],4,FALSE),\"\")","v":0}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],9,FALSE),\"\")*H32,\"\")","v":{"v":8.120000000000001,"d":"$8.12"}},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],6,FALSE),\"\")*H32,\"\")","v":{"v":12.879999999999999,"d":"$12.88"}},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],6,FALSE),\"\")","v":2}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],11,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],12,FALSE),\"\")","v":0},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],8,FALSE),\"\")","v":{"v":560,"d":"$560.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F30:F32)+SUM(D30:D32),\"\")","v":{"v":233.08,"d":"$233.08"}},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],10,FALSE),\"\")","v":{"v":20,"d":"$20.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,PayrollCalculator[],9,FALSE),\"\")+F33,\"\")","v":{"v":253.08000000000004,"d":"$253.08"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],11,FALSE),\"\")","v":{"v":306.91999999999996,"d":"$306.92"}}]
[]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":{"v":42304,"d":"4230400.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],2),\"\")","v":""},"Employee ID"]
[]
[null,null,"Tax Status",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],4),\"\")","v":""},"Federal Allowance (From W-4)",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],5,FALSE),\"\")","v":""},"Hours Worked",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],3,FALSE),\"\")","v":""}]
[null,null,"Hourly Rate",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],3,FALSE),\"\")","v":""},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],7,FALSE),\"\")","v":""},"Sick Hours",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],5,FALSE),\"\")","v":""}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IFERROR(VLOOKUP(H39,EmployeeInformation[],8,FALSE),\"\")*H45,\"\")","v":""},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H39,EmployeeInformation[],7,FALSE),\"\")*H45,\"\")","v":""},"Vacation Hours",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],4,FALSE),\"\")","v":""}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H39,EmployeeInformation[],9,FALSE),\"\")*H45,\"\")","v":""},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H39,EmployeeInformation[],6,FALSE),\"\")*H45,\"\")","v":""},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],6,FALSE),\"\")","v":""}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],11,FALSE),\"\")","v":""},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H39,EmployeeInformation[],12,FALSE),\"\")","v":""},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],8,FALSE),\"\")","v":""}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F43:F45)+SUM(D43:D45),\"\")","v":0},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],10,FALSE),\"\")","v":""},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H39,PayrollCalculator[],9,FALSE),\"\")+F46,\"\")","v":""}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],11,FALSE),\"\")","v":""}]