{"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":14,"rows_kept":6}
[]
[null,"EMPLOYEE INFORMATION"]
[]
[null,"Employee ID","Name","Hourly Wage","Tax Status","Federal Allowance (From W-4)","State Tax (Percentage)","Federal Income Tax (Percentage based on Federal Allowance)","Social Security Tax (Percentage)","Medicare Tax (Percentage)","Total Taxes Withheld (Percentage)","Insurance\nDeduction\n(Dollars)","Other Regular\nDeduction\n(Dollars)","Total Regular Deductions (Excluding taxes, in dollars)"]
[null,1,"Jay Adams",{"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":"SUM(tblEmployees[[#This Row],[State Tax (Percentage)]:[Medicare Tax (Percentage)]])","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":20,"d":"$20.00"},{"v":40,"d":"$40.00"},{"$f":"tblEmployees[[#This Row],[Insurance\nDeduction\n(Dollars)]]+tblEmployees[[#This Row],[Other Regular\nDeduction\n(Dollars)]]","v":{"v":60,"d":"$60.00"}}]
[null,2,"Kim Abercrombie",{"v":15,"d":"$15.00"},1,1,{"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":"SUM(tblEmployees[[#This Row],[State Tax (Percentage)]:[Medicare Tax (Percentage)]])","v":{"v":0.38050000000000006,"d":"38.05%"}},{"v":50,"d":"$50.00"},{"v":20,"d":"$20.00"},{"$f":"tblEmployees[[#This Row],[Insurance\nDeduction\n(Dollars)]]+tblEmployees[[#This Row],[Other Regular\nDeduction\n(Dollars)]]","v":{"v":70,"d":"$70.00"}}]

{"sheet":"PAYROLL CALCULATOR","index":1,"n_rows":9,"n_cols":12,"rows_kept":9}
[]
[null,"PAYROLL CALCULATOR",{"$nulls":8},"Period Ending:",{"v":41671,"d":"4167100.00%"}]
[]
[null,"Employee ID","Employee Name","Regular Hours Worked","Vacation Hours","Sick Hours","Overtime Hours","Overtime Rate","Gross Pay","Taxes and Deductions ","Other\nDeduction","Net Pay"]
[null,1,{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],2,0),\"ID not found\")","v":"Jay Adams"},40,5,1,10,{"v":15,"d":"$15.00"},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],3,FALSE)*(tblPayroll[[#This Row],[Regular Hours Worked]]+tblPayroll[[#This Row],[Vacation Hours]]+tblPayroll[[#This Row],[Sick Hours]])+tblPayroll[[#This Row],[Overtime Hours]]*tblPayroll[[#This Row],[Overtime Rate]],\"ID not found\")","v":{"v":610,"d":"$610.00"}},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],10,FALSE)*tblPayroll[[#This Row],[Gross Pay]]+tblEmployees[[#This Row],[Total Regular Deductions (Excluding taxes, in dollars)]],\"ID not found\")","v":{"v":292.105,"d":"$292.11"}},{"v":20,"d":"$20.00"},{"$f":"IFERROR(tblPayroll[[#This Row],[Gross Pay]]-tblPayroll[[#This Row],[Taxes and Deductions ]]-tblPayroll[[#This Row],[Other\nDeduction]],\"ID not found\")","v":{"v":297.895,"d":"$297.90"}}]
[null,2,{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],2,0),\"ID not found\")","v":"Kim Abercrombie"},40,{"$nulls":3},{"v":22.5,"d":"$22.50"},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],3,FALSE)*(tblPayroll[[#This Row],[Regular Hours Worked]]+tblPayroll[[#This Row],[Vacation Hours]]+tblPayroll[[#This Row],[Sick Hours]])+tblPayroll[[#This Row],[Overtime Hours]]*tblPayroll[[#This Row],[Overtime Rate]],\"ID not found\")","v":{"v":600,"d":"$600.00"}},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],10,FALSE)*tblPayroll[[#This Row],[Gross Pay]]+tblEmployees[[#This Row],[Total Regular Deductions (Excluding taxes, in dollars)]],\"ID not found\")","v":{"v":298.30000000000007,"d":"$298.30"}},null,{"$f":"IFERROR(tblPayroll[[#This Row],[Gross Pay]]-tblPayroll[[#This Row],[Taxes and Deductions ]]-tblPayroll[[#This Row],[Other\nDeduction]],\"ID not found\")","v":{"v":301.69999999999993,"d":"$301.70"}}]
[null,3,{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],2,0),\"ID not found\")","v":"ID not found"},{"$nulls":5},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],3,FALSE)*(tblPayroll[[#This Row],[Regular Hours Worked]]+tblPayroll[[#This Row],[Vacation Hours]]+tblPayroll[[#This Row],[Sick Hours]])+tblPayroll[[#This Row],[Overtime Hours]]*tblPayroll[[#This Row],[Overtime Rate]],\"ID not found\")","v":"ID not found"},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],10,FALSE)*tblPayroll[[#This Row],[Gross Pay]]+tblEmployees[[#This Row],[Total Regular Deductions (Excluding taxes, in dollars)]],\"ID not found\")","v":"ID not found"},null,{"$f":"IFERROR(tblPayroll[[#This Row],[Gross Pay]]-tblPayroll[[#This Row],[Taxes and Deductions ]]-tblPayroll[[#This Row],[Other\nDeduction]],\"ID not found\")","v":"ID not found"}]
[null,4,{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],2,0),\"ID not found\")","v":"ID not found"},{"$nulls":5},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],3,FALSE)*(tblPayroll[[#This Row],[Regular Hours Worked]]+tblPayroll[[#This Row],[Vacation Hours]]+tblPayroll[[#This Row],[Sick Hours]])+tblPayroll[[#This Row],[Overtime Hours]]*tblPayroll[[#This Row],[Overtime Rate]],\"ID not found\")","v":"ID not found"},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],10,FALSE)*tblPayroll[[#This Row],[Gross Pay]]+tblEmployees[[#This Row],[Total Regular Deductions (Excluding taxes, in dollars)]],\"ID not found\")","v":"ID not found"},null,{"$f":"IFERROR(tblPayroll[[#This Row],[Gross Pay]]-tblPayroll[[#This Row],[Taxes and Deductions ]]-tblPayroll[[#This Row],[Other\nDeduction]],\"ID not found\")","v":"ID not found"}]
[null,5,{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],2,0),\"ID not found\")","v":"ID not found"},{"$nulls":5},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],3,FALSE)*(tblPayroll[[#This Row],[Regular Hours Worked]]+tblPayroll[[#This Row],[Vacation Hours]]+tblPayroll[[#This Row],[Sick Hours]])+tblPayroll[[#This Row],[Overtime Hours]]*tblPayroll[[#This Row],[Overtime Rate]],\"ID not found\")","v":"ID not found"},{"$f":"IFERROR(VLOOKUP(tblPayroll[[#This Row],[Employee ID]],tblEmployees[],10,FALSE)*tblPayroll[[#This Row],[Gross Pay]]+tblEmployees[[#This Row],[Total Regular Deductions (Excluding taxes, in dollars)]],\"ID not found\")","v":"ID not found"},null,{"$f":"IFERROR(tblPayroll[[#This Row],[Gross Pay]]-tblPayroll[[#This Row],[Taxes and Deductions ]]-tblPayroll[[#This Row],[Other\nDeduction]],\"ID not found\")","v":"ID not found"}]

{"sheet":"INDIVIDUAL PAYSTUBS","index":2,"n_rows":55,"n_cols":8,"rows_kept":55}
[null,null,{"$f":"IF(ISNA(VLOOKUP(H5,tblEmployees[],2,0)),FALSE,TRUE)","v":true}]
[]
[null,null,"[Company Name]"]
[]
[null,null,"Period:",{"$f":"IF(F5<>\"\",'PAYROLL CALCULATOR'!$L$2,\"\")","v":{"v":41671,"d":"4167100.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H5,tblEmployees[],2,0),\"\")","v":"Jay Adams"},"Employee ID",1]
[]
[null,null,"Tax Status",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],4,0),0),0)","v":1},"Federal Allowance (From W-4)",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],5,0),0),0)","v":4},"Hours Worked",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],3,0),0),0)","v":40}]
[null,null,"Hourly Rate",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],3,0),0),0)","v":{"v":10,"d":"$10.00"}},"Overtime Rate",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],7,0),0),0)","v":{"v":15,"d":"$15.00"}},"Sick Hours",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],5,0),0),0)","v":1}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],8,0)*H11,0),0)","v":{"v":38.43,"d":"$38.43"}},"Federal Income Tax ",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],7,0)*H11,0),0)","v":{"v":170.8,"d":"$170.80"}},"Vacation Hours",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],4,0),0),0)","v":5}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],9,0)*H11,0),0)","v":{"v":8.845,"d":"$8.85"}},"State Tax ",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],6,0)*H11,0),0)","v":{"v":14.03,"d":"$14.03"}},"Overtime Hours",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],6,0),0),0)","v":10}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],11,0),0),0)","v":{"v":20,"d":"$20.00"}},"Other Regular Deduction",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblEmployees[],12,0),0),0)","v":{"v":40,"d":"$40.00"}},"Gross Pay",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],8,0),0),0)","v":{"v":610,"d":"$610.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"SUM(D9:D11,F9:F11)","v":{"v":292.105,"d":"$292.11"}},"Other Deduction",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],10,0),0),0)","v":{"v":20,"d":"$20.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],9,0)+F12,0),0)","v":{"v":312.105,"d":"$312.11"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(IF(C1,VLOOKUP($H$5,tblPayroll[],11,0),0),0)","v":{"v":297.895,"d":"$297.90"}}]
[]
[null,null,{"$f":"IF(ISNA(VLOOKUP(H19,tblEmployees[],2,0)),FALSE,TRUE)","v":true}]
[]
[null,null,{"$f":"C3","v":"[Company Name]"}]
[]
[null,null,"Period:",{"$f":"IF(F19<>\"\",'PAYROLL CALCULATOR'!$L$2,\"\")","v":{"v":41671,"d":"4167100.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H19,tblEmployees[],2,0),\"\")","v":"Kim Abercrombie"},"Employee ID",2]
[]
[null,null,"Tax Status",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],4,0),0),0)","v":1},"Federal Allowance (From W-4)",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],5,0),0),0)","v":1},"Hours Worked",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],3,0),0),0)","v":40}]
[null,null,"Hourly Rate",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],3,0),0),0)","v":{"v":15,"d":"$15.00"}},"Overtime Rate",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],7,0),0),0)","v":{"v":22.5,"d":"$22.50"}},"Sick Hours",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],5,0),0),0)","v":0}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],8,0)*H25,0),0)","v":{"v":37.8,"d":"$37.80"}},"Federal Income Tax ",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],7,0)*H25,0),0)","v":{"v":168.00000000000003,"d":"$168.00"}},"Vacation Hours",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],4,0),0),0)","v":0}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],9,0)*H25,0),0)","v":{"v":8.700000000000001,"d":"$8.70"}},"State Tax ",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],6,0)*H25,0),0)","v":{"v":13.799999999999999,"d":"$13.80"}},"Overtime Hours",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],6,0),0),0)","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],11,0),0),0)","v":{"v":50,"d":"$50.00"}},"Other Regular Deduction",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblEmployees[],12,0),0),0)","v":{"v":20,"d":"$20.00"}},"Gross Pay",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],8,0),0),0)","v":{"v":600,"d":"$600.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"SUM(D23:D25,F23:F25)","v":{"v":298.3,"d":"$298.30"}},"Other Deduction",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],10,0),0),0)","v":{"v":0,"d":"$0.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],9,0)+F26,0),0)","v":{"v":298.30000000000007,"d":"$298.30"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(IF(C15,VLOOKUP($H$19,tblPayroll[],11,0),0),0)","v":{"v":301.69999999999993,"d":"$301.70"}}]
[]
[null,null,{"$f":"IF(ISNA(VLOOKUP(H33,tblEmployees[],2,0)),FALSE,TRUE)","v":false}]
[]
[null,null,{"$f":"C3","v":"[Company Name]"}]
[]
[null,null,"Period:",{"$f":"IF(F33<>\"\",'PAYROLL CALCULATOR'!$L$2,\"\")","v":""},"Employee Name",{"$f":"IFERROR(VLOOKUP(H33,tblEmployees[],2,0),\"\")","v":""},"Employee ID",3]
[]
[null,null,"Tax Status",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],4,0),0),0)","v":0},"Federal Allowance (From W-4)",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],5,0),0),0)","v":0},"Hours Worked",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],3,0),0),0)","v":0}]
[null,null,"Hourly Rate",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],3,0),0),0)","v":{"v":0,"d":"$0.00"}},"Overtime Rate",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],7,0),0),0)","v":{"v":0,"d":"$0.00"}},"Sick Hours",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],5,0),0),0)","v":0}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],8,0)*H39,0),0)","v":{"v":0,"d":"$0.00"}},"Federal Income Tax ",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],7,0)*H39,0),0)","v":{"v":0,"d":"$0.00"}},"Vacation Hours",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],4,0),0),0)","v":0}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],9,0)*H39,0),0)","v":{"v":0,"d":"$0.00"}},"State Tax ",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],6,0)*H39,0),0)","v":{"v":0,"d":"$0.00"}},"Overtime Hours",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],6,0),0),0)","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],11,0),0),0)","v":{"v":0,"d":"$0.00"}},"Other Regular Deduction",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblEmployees[],12,0),0),0)","v":{"v":0,"d":"$0.00"}},"Gross Pay",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],8,0),0),0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"SUM(D37:D39,F37:F39)","v":{"v":0,"d":"$0.00"}},"Other Deduction",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],10,0),0),0)","v":{"v":0,"d":"$0.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],9,0)+F40,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(IF(C29,VLOOKUP($H$33,tblPayroll[],11,0),0),0)","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,{"$f":"IF(ISNA(VLOOKUP(H47,tblEmployees[],2,0)),FALSE,TRUE)","v":false}]
[]
[null,null,{"$f":"C3","v":"[Company Name]"}]
[]
[null,null,"Period:",{"$f":"IF(F47<>\"\",'PAYROLL CALCULATOR'!$L$2,\"\")","v":{"v":41671,"d":"4167100.00%"}},"Employee Name",{"$f":"IFERROR(VLOOKUP(H47,tblEmployees[],2,0),\"ID not found\")","v":"ID not found"},"Employee ID",4]
[]
[null,null,"Tax Status",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],4,0),0),0)","v":0},"Federal Allowance (From W-4)",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],5,0),0),0)","v":0},"Hours Worked",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],3,0),0),0)","v":0}]
[null,null,"Hourly Rate",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],3,0),0),0)","v":{"v":0,"d":"$0.00"}},"Overtime Rate",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],7,0),0),0)","v":{"v":0,"d":"$0.00"}},"Sick Hours",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],5,0),0),0)","v":0}]
[null,null,"Social Security Tax",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],8,0)*H53,0),0)","v":{"v":0,"d":"$0.00"}},"Federal Income Tax ",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],7,0)*H53,0),0)","v":{"v":0,"d":"$0.00"}},"Vacation Hours",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],4,0),0),0)","v":0}]
[null,null,"Medicare Tax ",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],9,0)*H53,0),0)","v":{"v":0,"d":"$0.00"}},"State Tax ",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],6,0)*H53,0),0)","v":{"v":0,"d":"$0.00"}},"Overtime Hours",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],6,0),0),0)","v":0}]
[null,null,"Insurance Deduction",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],11,0),0),0)","v":{"v":0,"d":"$0.00"}},"Other Regular Deduction",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblEmployees[],12,0),0),0)","v":{"v":0,"d":"$0.00"}},"Gross Pay",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],8,0),0),0)","v":{"v":0,"d":"$0.00"}}]
[null,null,"Total Taxes and Regular Deductions ",{"$f":"SUM(D51:D53,F51:F53)","v":{"v":0,"d":"$0.00"}},"Other Deduction",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],10,0),0),0)","v":{"v":0,"d":"$0.00"}},"Total Taxes and Deductions ",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],9,0)+F54,0),0)","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},"Net Pay",{"$f":"IFERROR(IF(C43,VLOOKUP($H$47,tblPayroll[],11,0),0),0)","v":{"v":0,"d":"$0.00"}}]