{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Payroll Input","stubs_template"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":7,"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":"Payroll Input","index":0,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"PAYROLL CALCULATOR",null,null,null,null,null,null,null,null,"PERIOD ENDING:",42181,null,"COMPANY NAME:",null,"ADVENTURE WORKS"]
[]
[null,"ID","Employee Name","Reg Hours Worked","Vacation Hours","Sick\nHours","Overtime Hours","Overtime Rate","Gross\nPay","Taxes and Ded's","Other\nDed's","Net Pay"," ","Hourly Wage","Tax\nStatus","Income Tax","Insurance Deduction","Other Reg. Deduction","Total Reg.\nDeductions"]
[null,1001,"Tony Smith",50,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":560},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":112},20,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":428},null,10,1,0.2,20,40,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":60}]
[null,1002,"David Jones",40,null,null,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":320},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":64},null,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":256},null,8,1,0.2,0,10,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":10}]
[null,1003,"Denise Smith",35,3,null,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":532},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":106.4},null,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":425.6},null,14,1,0.2,18,20,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":38}]
[null,1008,"Sebastien Motte",50,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":1120},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":224},null,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":896},null,20,1,0.2,15,null,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":15}]
[null,1011,"Isabelle Scemla",40,null,null,2,15,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":430},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":86},null,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":344},null,10,1,0.2,20,40,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":60}]
[null,1012,"David Bristol",40,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":552},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":110.4},null,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":441.6},null,12,1,0.2,20,40,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":60}]
[null,1025,"Anne Weiler",36,null,2,1,18,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":474},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":94.800000000000011},25,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":354.2},null,12,1,0.2,25,20,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":45}]
[null,1032,"Luka Abrus",40,5,1,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":460},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":92},50,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":318},null,10,1,0.2,null,null,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":0}]
[null,1049,"David Ludwig",40,1,null,null,null,{"$f":"SUM(Employees[[#This Row],[Reg Hours Worked]:[Sick\nHours]])*Employees[[#This Row],[Hourly Wage]]+Employees[[#This Row],[Overtime Hours]]*Employees[[#This Row],[Overtime Rate]]","v":615},{"$f":"Employees[[#This Row],[Income Tax]]*Employees[Gross\nPay]","v":123},23,{"$f":"Employees[[#This Row],[Gross\nPay]]-Employees[[#This Row],[Taxes and Ded''s]]-Employees[[#This Row],[Other\nDed''s]]","v":469},null,15,1,0.2,25,null,{"$f":"SUM(Employees[[#This Row],[Insurance Deduction]:[Other Reg. Deduction]])","v":25}]
[null,"Totals",{"$f":"SUBTOTAL(103,Employees[Employee Name])","v":9},{"$f":"SUBTOTAL(109,Employees[Reg Hours Worked])","v":371},{"$f":"SUBTOTAL(109,Employees[Vacation Hours])","v":24},{"$f":"SUBTOTAL(109,Employees[Sick\nHours])","v":6},{"$f":"SUBTOTAL(109,Employees[Overtime Hours])","v":3},null,{"$f":"SUBTOTAL(109,Employees[Gross\nPay])","v":5063},{"$f":"SUBTOTAL(109,Employees[Taxes and Ded''s])","v":1012.5999999999999},{"$f":"SUBTOTAL(109,Employees[Other\nDed''s])","v":118},{"$f":"SUBTOTAL(109,Employees[Net Pay])","v":3932.3999999999996},null,null,null,null,{"$f":"SUBTOTAL(109,Employees[Insurance Deduction])","v":143},{"$f":"SUBTOTAL(109,Employees[Other Reg. Deduction])","v":170},{"$f":"SUBTOTAL(109,Employees[Total Reg.\nDeductions])","v":313}]

{"sheet":"stubs_template","index":1,"n_rows":47,"n_cols":13,"rows_kept":47,"cut":false,"hidden":true,"merged":[[45,2,45,3],[32,2,32,3],[33,2,33,3],[20,2,20,3],[21,2,21,3],[2,3,2,4],[14,3,14,4],[26,3,26,4],[38,3,38,4],[44,2,44,3],[8,2,8,3],[9,2,9,3],[2,7,2,8],[14,7,14,8],[26,7,26,8],[38,7,38,8],[38,11,38,12],[26,11,26,12],[14,11,14,12],[2,11,2,12]]}
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIOD",{"$f":"PeriodEnding","v":42181},null,null,"NAME",{"$f":"IFERROR(INDEX(Employees[Employee Name],Stub),\"\")","v":"Tony Smith"},null,null,"EMPLOYEE ID",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1001}]
[null,null,"Tax Status",null,{"$f":"IFERROR(INDEX(Employees[Tax\nStatus],Stub),\"\")","v":1},null,"Federal Allowance (From W-4)",null,{"$f":"IFERROR(INDEX(#REF!,Stub),\"\")","v":""},null,"Hours Worked",null,{"$f":"IFERROR(INDEX(Employees[Reg Hours Worked],Stub),\"\")","v":50}]
[null,null,"Hourly Rate",null,{"$f":"IFERROR(INDEX(Employees[Hourly Wage],Stub),\"\")","v":10},null,"Overtime Rate",null,{"$f":"IFERROR(INDEX(Employees[Overtime Rate],Stub),\"\")","v":0},null,"Sick Hours",null,{"$f":"IFERROR(INDEX(Employees[Sick\nHours],Stub),\"\")","v":1}]
[null,null,"Social Security Tax",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Federal Income Tax ",null,{"$f":"IFERROR(INDEX(Employees[Income Tax],Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":112},null,"Vacation Hours",null,{"$f":"IFERROR(INDEX(Employees[Vacation Hours],Stub),\"\")","v":5}]
[null,null,"Medicare Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"State Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Overtime Hours",null,{"$f":"IFERROR(INDEX(Employees[Overtime Hours],Stub),\"\")","v":0}]
[null,null,"Insurance Deduction",null,{"$f":"IFERROR(INDEX(Employees[Insurance Deduction],Stub),\"\")","v":20},null,"Other Regular Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other Reg. Deduction],Stub),\"\")","v":40},null,"Gross Pay",null,{"$f":"IFERROR(INDEX(Employees[Gross\nPay],Stub),\"\")","v":560}]
[null,null,"Total Taxes and",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub),\"\")","v":112},null,"Other Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other\nDed''s],Stub),\"\")","v":20},null,"Total Taxes and Deductions ",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub)  +  INDEX(Employees[Other\nDed''s],Stub),\"\")","v":132}]
[null,null,"Regular Deductions "]
[null,null,null,null,null,null,null,null,null,null,"NET PAY",null,{"$f":"IFERROR(INDEX(Employees[Net Pay],Stub),\"\")","v":428}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIOD",{"$f":"PeriodEnding","v":42181},null,null,"NAME",{"$f":"IFERROR(INDEX(Employees[Employee Name],Stub),\"\")","v":"David Jones"},null,null,"EMPLOYEE ID",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1002}]
[null,null,"Tax Status",null,{"$f":"IFERROR(INDEX(Employees[Tax\nStatus],Stub),\"\")","v":1},null,"Federal Allowance (From W-4)",null,{"$f":"IFERROR(INDEX(#REF!,Stub),\"\")","v":""},null,"Hours Worked",null,{"$f":"IFERROR(INDEX(Employees[Reg Hours Worked],Stub),\"\")","v":40}]
[null,null,"Hourly Rate",null,{"$f":"IFERROR(INDEX(Employees[Hourly Wage],Stub),\"\")","v":8},null,"Overtime Rate",null,{"$f":"IFERROR(INDEX(Employees[Overtime Rate],Stub),\"\")","v":0},null,"Sick Hours",null,{"$f":"IFERROR(INDEX(Employees[Sick\nHours],Stub),\"\")","v":0}]
[null,null,"Social Security Tax",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Federal Income Tax ",null,{"$f":"IFERROR(INDEX(Employees[Income Tax],Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":64},null,"Vacation Hours",null,{"$f":"IFERROR(INDEX(Employees[Vacation Hours],Stub),\"\")","v":0}]
[null,null,"Medicare Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"State Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Overtime Hours",null,{"$f":"IFERROR(INDEX(Employees[Overtime Hours],Stub),\"\")","v":0}]
[null,null,"Insurance Deduction",null,{"$f":"IFERROR(INDEX(Employees[Insurance Deduction],Stub),\"\")","v":0},null,"Other Regular Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other Reg. Deduction],Stub),\"\")","v":10},null,"Gross Pay",null,{"$f":"IFERROR(INDEX(Employees[Gross\nPay],Stub),\"\")","v":320}]
[null,null,"Total Taxes and",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub),\"\")","v":64},null,"Other Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other\nDed''s],Stub),\"\")","v":0},null,"Total Taxes and Deductions ",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub)  +  INDEX(Employees[Other\nDed''s],Stub),\"\")","v":64}]
[null,null,"Regular Deductions "]
[null,null,null,null,null,null,null,null,null,null,"NET PAY",null,{"$f":"IFERROR(INDEX(Employees[Net Pay],Stub),\"\")","v":256}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PEROID",{"$f":"PeriodEnding","v":42181},null,null,"NAME",{"$f":"IFERROR(INDEX(Employees[Employee Name],Stub),\"\")","v":"Denise Smith"},null,null,"EMPLOYEE ID",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1003}]
[null,null,"Tax Status",null,{"$f":"IFERROR(INDEX(Employees[Tax\nStatus],Stub),\"\")","v":1},null,"Federal Allowance (From W-4)",null,{"$f":"IFERROR(INDEX(#REF!,Stub),\"\")","v":""},null,"Hours Worked",null,{"$f":"IFERROR(INDEX(Employees[Reg Hours Worked],Stub),\"\")","v":35}]
[null,null,"Hourly Rate",null,{"$f":"IFERROR(INDEX(Employees[Hourly Wage],Stub),\"\")","v":14},null,"Overtime Rate",null,{"$f":"IFERROR(INDEX(Employees[Overtime Rate],Stub),\"\")","v":0},null,"Sick Hours",null,{"$f":"IFERROR(INDEX(Employees[Sick\nHours],Stub),\"\")","v":0}]
[null,null,"Social Security Tax",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Federal Income Tax ",null,{"$f":"IFERROR(INDEX(Employees[Income Tax],Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":106.4},null,"Vacation Hours",null,{"$f":"IFERROR(INDEX(Employees[Vacation Hours],Stub),\"\")","v":3}]
[null,null,"Medicare Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"State Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Overtime Hours",null,{"$f":"IFERROR(INDEX(Employees[Overtime Hours],Stub),\"\")","v":0}]
[null,null,"Insurance Deduction",null,{"$f":"IFERROR(INDEX(Employees[Insurance Deduction],Stub),\"\")","v":18},null,"Other Regular Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other Reg. Deduction],Stub),\"\")","v":20},null,"Gross Pay",null,{"$f":"IFERROR(INDEX(Employees[Gross\nPay],Stub),\"\")","v":532}]
[null,null,"Total Taxes and",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub),\"\")","v":106.4},null,"Other Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other\nDed''s],Stub),\"\")","v":0},null,"Total Taxes and Deductions ",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub)  +  INDEX(Employees[Other\nDed''s],Stub),\"\")","v":106.4}]
[null,null,"Regular Deductions "]
[null,null,null,null,null,null,null,null,null,null,"NET PAY",null,{"$f":"IFERROR(INDEX(Employees[Net Pay],Stub),\"\")","v":425.6}]
[]
[]
[null,null,{"$f":"CompanyName","v":"ADVENTURE WORKS"}]
[null,null,"PERIOD",{"$f":"PeriodEnding","v":42181},null,null,"NAME",{"$f":"IFERROR(INDEX(Employees[Employee Name],Stub),\"\")","v":"Sebastien Motte"},null,null,"EMPLOYEE ID",{"$f":"IFERROR(INDEX(Employees[ID],Stub),\"\")","v":1008}]
[null,null,"Tax Status",null,{"$f":"IFERROR(INDEX(Employees[Tax\nStatus],Stub),\"\")","v":1},null,"Federal Allowance (From W-4)",null,{"$f":"IFERROR(INDEX(#REF!,Stub),\"\")","v":""},null,"Hours Worked",null,{"$f":"IFERROR(INDEX(Employees[Reg Hours Worked],Stub),\"\")","v":50}]
[null,null,"Hourly Rate",null,{"$f":"IFERROR(INDEX(Employees[Hourly Wage],Stub),\"\")","v":20},null,"Overtime Rate",null,{"$f":"IFERROR(INDEX(Employees[Overtime Rate],Stub),\"\")","v":0},null,"Sick Hours",null,{"$f":"IFERROR(INDEX(Employees[Sick\nHours],Stub),\"\")","v":1}]
[null,null,"Social Security Tax",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Federal Income Tax ",null,{"$f":"IFERROR(INDEX(Employees[Income Tax],Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":224},null,"Vacation Hours",null,{"$f":"IFERROR(INDEX(Employees[Vacation Hours],Stub),\"\")","v":5}]
[null,null,"Medicare Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"State Tax ",null,{"$f":"IFERROR(INDEX(#REF!,Stub)  *  INDEX(Employees[Gross\nPay],Stub),\"\")","v":""},null,"Overtime Hours",null,{"$f":"IFERROR(INDEX(Employees[Overtime Hours],Stub),\"\")","v":0}]
[null,null,"Insurance Deduction",null,{"$f":"IFERROR(INDEX(Employees[Insurance Deduction],Stub),\"\")","v":15},null,"Other Regular Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other Reg. Deduction],Stub),\"\")","v":0},null,"Gross Pay",null,{"$f":"IFERROR(INDEX(Employees[Gross\nPay],Stub),\"\")","v":1120}]
[null,null,"Total Taxes and",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub),\"\")","v":224},null,"Other Deduction",null,{"$f":"IFERROR(INDEX(Employees[Other\nDed''s],Stub),\"\")","v":0},null,"Total Taxes and Deductions ",null,{"$f":"IFERROR(INDEX(Employees[Taxes and Ded''s],Stub)  +  INDEX(Employees[Other\nDed''s],Stub),\"\")","v":224}]
[null,null,"Regular Deductions "]
[null,null,null,null,null,null,null,null,null,null,"NET PAY",null,{"$f":"IFERROR(INDEX(Employees[Net Pay],Stub),\"\")","v":896}]