{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Employee information","Payroll calculator","Individual paystubs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Employee information","index":0,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"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]",10,1,4,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":0.38050000000000006},20,40,{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":60}]
[2,"[Employee 2]",13,1,4,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":0.38050000000000006},20,52,{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":72}]
[3,"[Employee 3]",10,1,4,2.3E-2,0.28000000000000003,6.3E-2,1.4500000000000001E-2,{"$f":"EmployeeInformation[State Tax]+EmployeeInformation[Federal Income Tax\n(Based on Federal Allowance)]+EmployeeInformation[Social Security\nTax]+EmployeeInformation[Medicare\nTax]","v":0.38050000000000006},20,0,{"$f":"EmployeeInformation[Insurance\nDeduction]+EmployeeInformation[Other Regular\nDeduction]","v":20}]

{"sheet":"Payroll calculator","index":1,"n_rows":6,"n_cols":11,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,0,1,5],[0,0,0,10]]}
["Payroll calculator"]
[{"$f":"'Employee information'!$A$2","v":"[Company Name]"},null,null,null,null,null,"Period Ending:",{"$f":"TODAY()","v":42304}]
["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]"},50,5,1,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":560},{"$f":"VLOOKUP(A4,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":273.08000000000004},20,{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":266.91999999999996}]
[2,{"$f":"VLOOKUP(A5,EmployeeInformation[],2,FALSE)","v":"[Employee 2]"},40,0,0,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":520},{"$f":"VLOOKUP(A5,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":269.86},52,{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":198.14}]
[3,{"$f":"VLOOKUP(A6,EmployeeInformation[],2,FALSE)","v":"[Employee 3]"},52,0,0,2,20,{"$f":"(VLOOKUP(A6,EmployeeInformation[],3,FALSE)*(PayrollCalculator[Regular Hours\nWorked]+PayrollCalculator[Vacation\nHours]+PayrollCalculator[Sick\nHours])+PayrollCalculator[Overtime\nHours]*PayrollCalculator[Overtime\nRate])","v":560},{"$f":"VLOOKUP(A6,EmployeeInformation[],10,FALSE)*PayrollCalculator[Gross\nPay]+EmployeeInformation[Total\nRegular Deductions\n(Excluding taxes)]","v":233.08000000000004},20,{"$f":"PayrollCalculator[Gross\nPay]-PayrollCalculator[Taxes\nand\nDeductions ]-PayrollCalculator[Other\nDeduction]","v":306.91999999999996}]

{"sheet":"Individual paystubs","index":2,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"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":42304},"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":10},"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":35.28},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],7,FALSE),\"\")*H8,\"\")","v":156.80000000000001},"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":8.120000000000001},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,EmployeeInformation[],6,FALSE),\"\")*H8,\"\")","v":12.879999999999999},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],11,FALSE),\"\")","v":20},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H2,EmployeeInformation[],12,FALSE),\"\")","v":40},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],8,FALSE),\"\")","v":560}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F6:F8)+SUM(D6:D8),\"\")","v":273.08000000000004},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],10,FALSE),\"\")","v":20},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H2,PayrollCalculator[],9,FALSE),\"\")+F9,\"\")","v":293.08000000000004}]
[null,null,null,null,null,null,"Net Pay",{"$f":"IFERROR(VLOOKUP(H2,PayrollCalculator[],11,FALSE),\"\")","v":266.91999999999996}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":42304},"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":13},"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":32.76},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],7,FALSE),\"\")*H20,\"\")","v":145.60000000000002},"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":7.54},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,EmployeeInformation[],6,FALSE),\"\")*H20,\"\")","v":11.959999999999999},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],6,FALSE),\"\")","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],11,FALSE),\"\")","v":20},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H14,EmployeeInformation[],12,FALSE),\"\")","v":52},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],8,FALSE),\"\")","v":520}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F18:F20)+SUM(D18:D20),\"\")","v":269.86},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],10,FALSE),\"\")","v":52},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H14,PayrollCalculator[],9,FALSE),\"\")+F21,\"\")","v":321.86}]
[null,null,null,null,null,null,"Net Pay",{"$f":"IFERROR(VLOOKUP(H14,PayrollCalculator[],11,FALSE),\"\")","v":198.14}]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":42304},"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":10},"Overtime Rate",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],7,FALSE),\"\")","v":20},"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":35.28},"Federal Income Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],7,FALSE),\"\")*H32,\"\")","v":156.80000000000001},"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":8.120000000000001},"State Tax ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,EmployeeInformation[],6,FALSE),\"\")*H32,\"\")","v":12.879999999999999},"Overtime Hours",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],6,FALSE),\"\")","v":2}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],11,FALSE),\"\")","v":20},"Other Regular Deduction",{"$f":"IFERROR(VLOOKUP(H26,EmployeeInformation[],12,FALSE),\"\")","v":0},"Gross Pay",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],8,FALSE),\"\")","v":560}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"IFERROR(SUM(F30:F32)+SUM(D30:D32),\"\")","v":233.08},"Other Deduction",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],10,FALSE),\"\")","v":20},"Total Taxes and Deductions ",{"$f":"IFERROR(IFERROR(VLOOKUP(H26,PayrollCalculator[],9,FALSE),\"\")+F33,\"\")","v":253.08000000000004}]
[null,null,null,null,null,null,"Net Pay",{"$f":"IFERROR(VLOOKUP(H26,PayrollCalculator[],11,FALSE),\"\")","v":306.91999999999996}]
[]
[]
[]
[null,null,{"$f":"('Employee information'!$A$2)","v":"[Company Name]"}]
[null,null,"Period:",{"$f":"'Payroll calculator'!$H$2","v":42304},"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":""}]
[null,null,null,null,null,null,"Net Pay",{"$f":"IFERROR(VLOOKUP(H39,PayrollCalculator[],11,FALSE),\"\")","v":""}]