{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Input"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"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"}

{"sheet":"Input","index":0,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]]}
[]
[null,"Employer SS:",null,6.2E-2,null,null,"WH","Total SS","Total Med","Total FICA","Total Tax"]
[null,"Employee SS:",null,6.2E-2,null,"941's",{"$f":"D12","v":0},{"$f":"(D3/(D3+D2))*E12","v":0},{"$f":"(D5/(D5+D4))*G12","v":0},{"$f":"SUM(H3:I3)","v":0},{"$f":"SUM(G3:I3)","v":0}]
[null,"Employer Med:",null,1.4500000000000001E-2,null,"W-2's",{"$f":"SUM(Table1[WH])","v":0},{"$f":"SUM(Table1[SS Tax])","v":0},{"$f":"SUM(Table1[Medicare WH])","v":0},{"$f":"SUM(H4:I4)","v":0},{"$f":"SUM(G4:I4)","v":0}]
[null,"Employee Med:",null,1.4500000000000001E-2,null,"W-3",{"$f":"D16","v":0},{"$f":"E16","v":0},{"$f":"F16","v":0},{"$f":"SUM(H5:I5)","v":0},{"$f":"SUM(G5:I5)","v":0}]
[]
[null,"941's",null,"WH","SS Tax on Wages","SS Tax on Tips","Med Tax on Wages & Tips","Add'l WH","Total FICA","Total Taxes before adjust.","Adjustments","Total Tax after adjust."]
[null,null,"1st qtr.",null,null,null,null,null,{"$f":"SUM(E8:H8)","v":0},{"$f":"SUM(D8:H8)","v":0},null,{"$f":"SUM(J8:K8)","v":0}]
[null,null,"2nd qtr.",null,null,null,null,null,{"$f":"SUM(E9:H9)","v":0},{"$f":"SUM(D9:H9)","v":0},null,{"$f":"SUM(J9:K9)","v":0}]
[null,null,"3rd qtr.",null,null,null,null,null,0,0,null,0]
[null,null,"4th qtr.",null,null,null,null,null,0,0,null,0]
[null,null,null,{"$f":"SUM(D8:D11)","v":0},{"$f":"SUM(E8:E11)","v":0},0,0,0,0,0,0,0]
[]
[]
[null,"W-3","Wages, tips & other comp.","WH","SS Tax","Medicare WH","SS Tips"]
[]
[]
[]
[null,"W-2's","Name","Wages, tips & other comp.","WH","SS Tax","Medicare WH","SS Tips"]