{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Employee Information","Payroll Calculator","Individual Paystubs"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"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","formulas":"cached_only"}

{"sheet":"Employee Information","index":0,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Employee Information"]
["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)"]
[1,"Jay Adams",10,1,4,0.023,0.28,0.063,0.0145,0.38050000000000006,20,40,60]
[2,null,null,null,null,null,null,null,null,0,null,null,0]
[3,null,null,null,null,null,null,null,null,0,null,null,0]
[4,null,null,null,null,null,null,null,null,0,null,null,0]
[5,null,null,null,null,null,null,null,null,0,null,null,0]
[6,null,null,null,null,null,null,null,null,0,null,null,0]
[7,null,null,null,null,null,null,null,null,0,null,null,0]
[8,null,null,null,null,null,null,null,null,0,null,null,0]
[9,null,null,null,null,null,null,null,null,0,null,null,0]
[10,null,null,null,null,null,null,null,null,0,null,null,0]
[11,null,null,null,null,null,null,null,null,0,null,null,0]
[12,null,null,null,null,null,null,null,null,0,null,null,0]
[13,null,null,null,null,null,null,null,null,0,null,null,0]
[14,null,null,null,null,null,null,null,null,0,null,null,0]
[15,null,null,null,null,null,null,null,null,0,null,null,0]
[16,null,null,null,null,null,null,null,null,0,null,null,0]
[17,null,null,null,null,null,null,null,null,0,null,null,0]
[18,null,null,null,null,null,null,null,null,0,null,null,0]
[19,null,null,null,null,null,null,null,null,0,null,null,0]
[20,null,null,null,null,null,null,null,null,0,null,null,0]
[21,null,null,null,null,null,null,null,null,0,null,null,0]
[22,null,null,null,null,null,null,null,null,0,null,null,0]
[23,null,null,null,null,null,null,null,null,0,null,null,0]
[24,null,null,null,null,null,null,null,null,0,null,null,0]
[25,null,null,null,null,null,null,null,null,0,null,null,0]

{"sheet":"Payroll Calculator","index":1,"n_rows":28,"n_cols":11,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,"Payroll Calculator"]
["Period Ending:","2003-04-25"]
["Employee ID","Employee Name","Regular Hours Worked","Vacation Hours","Sick Hours","Overtime Hours","Overtime Rate","Gross Pay","Taxes and Deductions ","Other\n Deduction","Net Pay"]
[1,"Jay Adams",50,5,1,null,null,560,273.08000000000004,20,266.91999999999996]
[2,0,null,null,null,null,null,0,0,null,0]
[3,0,null,null,null,null,null,0,0,null,0]
[4,0,null,null,null,null,null,0,0,null,0]
[5,0,null,null,null,null,null,0,0,null,0]
[6,0,null,null,null,null,null,0,0,null,0]
[7,0,null,null,null,null,null,0,0,null,0]
[8,0,null,null,null,null,null,0,0,null,0]
[9,0,null,null,null,null,null,0,0,null,0]
[10,0,null,null,null,null,null,0,0,null,0]
[11,0,null,null,null,null,null,0,0,null,0]
[12,0,null,null,null,null,null,0,0,null,0]
[13,0,null,null,null,null,null,0,0,null,0]
[14,0,null,null,null,null,null,0,0,null,0]
[15,0,null,null,null,null,null,0,0,null,0]
[16,0,null,null,null,null,null,0,0,null,0]
[17,0,null,null,null,null,null,0,0,null,0]
[18,0,null,null,null,null,null,0,0,null,0]
[19,0,null,null,null,null,null,0,0,null,0]
[20,0,null,null,null,null,null,0,0,null,0]
[21,0,null,null,null,null,null,0,0,null,0]
[22,0,null,null,null,null,null,0,0,null,0]
[23,0,null,null,null,null,null,0,0,null,0]
[24,0,null,null,null,null,null,0,0,null,0]
[25,0,null,null,null,null,null,0,0,null,0]

{"sheet":"Individual Paystubs","index":2,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["[Company Name]"]
[]
["Period:","2003-04-25","Employee Name","Jay Adams","Employee ID",1]
[]
["Tax Status",1,"Federal Allowance (From W-4)",4,"Hours Worked",50]
["Hourly Rate",10,"Overtime Rate",0,"Sick Hours",1]
["Social Security Tax",35.28,"Federal Income Tax ",156.8,"Vacation Hours",5]
["Medicare Tax ",8.120000000000001,"State Tax ",12.879999999999999,"Overtime Hours",0]
["Insurance\nDeduction",20,"Other Regular\nDeduction",40,"Gross Pay",560]
["Total Taxes and Regular Deductions ",273.08000000000004,"Other Deduction",20,"Total Taxes and Deductions ",293.08000000000004]
[null,null,null,null,"Net Pay",266.91999999999996]
[]
[]
["[Company Name]"]
[]
["Period:","2003-04-25","Employee Name",0,"Employee ID",2]
[]
["Tax Status",0,"Federal Allowance (From W-4)",0,"Hours Worked",0]
["Hourly Rate",0,"Overtime Rate",0,"Sick Hours",0]
["Social Security Tax",0,"Federal Income Tax ",0,"Vacation Hours",0]
["Medicare Tax ",0,"State Tax ",0,"Overtime Hours",0]
["Insurance\nDeduction",0,"Other Regular\nDeduction",0,"Gross Pay",0]
["Total Taxes and Regular Deductions ",0,"Other Deduction",0,"Total Taxes and Deductions ",0]
[null,null,null,null,"Net Pay",0]
[]
[]
["[Company Name]"]
[]
["Period:","2003-04-25","Employee Name",0,"Employee ID",3]
[]
["Tax Status",0,"Federal Allowance (From W-4)",0,"Hours Worked",0]
["Hourly Rate",0,"Overtime Rate",0,"Sick Hours",0]
["Social Security Tax",0,"Federal Income Tax ",0,"Vacation Hours",0]
["Medicare Tax ",0,"State Tax ",0,"Overtime Hours",0]
["Insurance\nDeduction",0,"Other Regular\nDeduction",0,"Gross Pay",0]
["Total Taxes and Regular Deductions ",0,"Other Deduction",0,"Total Taxes and Deductions ",0]
[null,null,null,null,"Net Pay",0]
[]
[]
["[Company Name]"]
[]
["Period:","2003-04-25","Employee Name",0,"Employee ID",4]
[]
["Tax Status",0,"Federal Allowance (From W-4)",0,"Hours Worked",0]
["Hourly Rate",0,"Overtime Rate",0,"Sick Hours",0]
["Social Security Tax",0,"Federal Income Tax ",0,"Vacation Hours",0]
["Medicare Tax ",0,"State Tax ",0,"Overtime Hours",0]
["Insurance\nDeduction",0,"Other Regular\nDeduction",0,"Gross Pay",0]
["Total Taxes and Regular Deductions ",0,"Other Deduction",0,"Total Taxes and Deductions ",0]
[null,null,null,null,"Net Pay",0]