{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Data","Sheet2"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Data","index":0,"n_rows":28,"n_cols":34,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,26,0,33]]}
[2012,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TAX RATES"]
["EE SS",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE SS])","v":4.2000000000000003E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE SS])","v":4.2000000000000003E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE SS])","v":4.2000000000000003E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE SS])","v":4.2000000000000003E-2},{"$f":"E2","v":4.2000000000000003E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year","EE SS","EE Med","EE FICA","Add'l Med. Tax","ER SS","ER Med","ER FICA"]
["EE Med",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE Med])","v":1.4500000000000001E-2},{"$f":"E3","v":1.4500000000000001E-2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2000,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF3:AG3)","v":7.6499999999999999E-2}]
["EE FICA",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE FICA])","v":5.6500000000000002E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE FICA])","v":5.6500000000000002E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE FICA])","v":5.6500000000000002E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[EE FICA])","v":5.6500000000000002E-2},5.6500000000000002E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2001,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["ER SS",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER SS])","v":6.2E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER SS])","v":6.2E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER SS])","v":6.2E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER SS])","v":6.2E-2},6.2E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2002,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["ER Med",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER Med])","v":1.4500000000000001E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER Med])","v":1.4500000000000001E-2},1.4500000000000001E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2003,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["ER FICA",{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER FICA])","v":7.6499999999999999E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER FICA])","v":7.6499999999999999E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER FICA])","v":7.6499999999999999E-2},{"$f":"LOOKUP($A$1,TaxRates[Year],TaxRates[ER FICA])","v":7.6499999999999999E-2},7.6499999999999999E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2004,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF8:AG8)","v":7.6499999999999999E-2}]
["Column1","1st","2nd","3rd","4th","Total",null,null,"W-3","Amounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF9:AG9)","v":7.6499999999999999E-2}]
["# Employees",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"# Employees",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF10:AG10)","v":7.6499999999999999E-2}]
["Wages, tips, comp",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Wages, tips, comp",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Ttl Income Tax WH",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Ttl Income Tax WH",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Taxable SS Wage",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Taxable SS Wage",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Taxable SS tips",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Sagable SS tips",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,4.2000000000000003E-2,1.4500000000000001E-2,5.6500000000000002E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Taxable Medicare wages & tips",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Taxable Medicare wages & tips",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,4.2000000000000003E-2,1.4500000000000001E-2,5.6500000000000002E-2,null,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Additional Med Tax",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Additional Med Tax",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["SS Tax on wages",{"$f":"(B13*B2)+(B13*B5)","v":0},{"$f":"(C13*C2)+(C13*C5)","v":0},0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"SS Tax on wages",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["SS tax on tips",{"$f":"(B14*B2)+(B14*B5)","v":0},{"$f":"(C14*C2)+(C14*C5)","v":0},0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"SS tax on tips",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2]
["Med tax on wages & tips",{"$f":"(B15*B6)+(B15*B6)","v":0},{"$f":"(C15*C6)+(C15*C6)","v":0},0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Med tax on wages & tips",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF19:AG19)","v":7.6499999999999999E-2}]
["Adjustments",0,0,0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Adjustments",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF20:AG20)","v":7.6499999999999999E-2}]
["Total SS & Medicare Tax",{"$f":"SUM(B16:B19)","v":0},{"$f":"SUM(C16:C19)","v":0},0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Total SS & Medicare Tax",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,6.2E-2,1.4500000000000001E-2,7.6499999999999999E-2,8.9999999999999993E-3,6.2E-2,1.4500000000000001E-2,{"$f":"SUM(AF21:AG21)","v":7.6499999999999999E-2}]
["Total Tax with Adjustments",{"$f":"SUM(B12,B16,B21)","v":0},{"$f":"SUM(C12,C16,C21)","v":0},0,0,{"$f":"SUM(F941sReported[[#This Row],[1st]:[4th]])","v":0},null,null,"Total Tax with Adjustments",0]
[]
[]
[]
[]
[{"$f":"\"Total number of W-2's: \"&COUNTA(W2Reported[Name])","v":"Total number of W-2's: 0"},{"$f":"SUM(W2Reported[Wages])","v":0},{"$f":"SUM(W2Reported[FICA WH])","v":0},{"$f":"SUM(W2Reported[Taxable SS])","v":0},{"$f":"SUM(W2Reported[Taxable Med])","v":0},{"$f":"SUM(W2Reported[Taxable Tips])","v":0},{"$f":"SUM(W2Reported[Additional Med])","v":0},{"$f":"B27*F2","v":0},{"$f":"F27*F2","v":0},{"$f":"E27*F3","v":0},{"$f":"+C27","v":0},{"$f":"W2Reported[Total SS & Med Tax]+W2Reported[FICA WH]","v":0}]
["Name","Wages","FICA WH","Taxable SS","Taxable Med","Taxable Tips","Additional Med","SS Tax on Wages","SS Tax on Tips","Med Tax on wages & Tips","Total SS & Med Tax","Total Tax"]

{"sheet":"Sheet2","index":1,"n_rows":92,"n_cols":10,"rows_kept":92,"cut":false,"hidden":false,"merged":[]}
["Sub UpdateBottom()",null,null,null,null,null,null,null,null,"\""]
["CAWR.TextBox",80," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",11,"\"), \"$#,##0.00\")",null,"Wages, tips, comp",{"$f":"\"Data!\"&D2&E2","v":"Data!F11"},{"$f":"A2&B2&\".ControlSource=\"&$J$1&I2&$J$1","v":"CAWR.TextBox80.ControlSource=\"Data!F11\""}]
["CAWR.TextBox",{"$f":"B2+1","v":81}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",12,"\"), \"$#,##0.00\")",null,"Ttl Income Tax WH","Data!F12",{"$f":"A3&B3&\".ControlSource=\"&$J$1&I3&$J$1","v":"CAWR.TextBox81.ControlSource=\"Data!F12\""}]
["CAWR.TextBox",{"$f":"B3+1","v":82}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",13,"\"), \"$#,##0.00\")",null,"Taxable SS Wage","Data!F13","CAWR.TextBox82.ControlSource=\"Data!F13\""]
["CAWR.TextBox",83," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",14,"\"), \"$#,##0.00\")",null,"Taxable SS tips",{"$f":"\"Data!\"&D5&E5","v":"Data!F14"},"CAWR.TextBox83.ControlSource=\"Data!F14\""]
["CAWR.TextBox",84," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",15,"\"), \"$#,##0.00\")",null,"Taxable Medicare wages & tips",{"$f":"\"Data!\"&D6&E6","v":"Data!F15"},"CAWR.TextBox84.ControlSource=\"Data!F15\""]
["CAWR.TextBox",85," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",16,"\"), \"$#,##0.00\")",null,"Additional Med Tax","Data!F16","CAWR.TextBox85.ControlSource=\"Data!F16\""]
["CAWR.TextBox",86," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",17,"\"), \"$#,##0.00\")",null,"SS Tax on wages","Data!F17","CAWR.TextBox86.ControlSource=\"Data!F17\""]
["CAWR.TextBox",87," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",18,"\"), \"$#,##0.00\")",null,"SS tax on tips","Data!F18","CAWR.TextBox87.ControlSource=\"Data!F18\""]
["CAWR.TextBox",88," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",19,"\"), \"$#,##0.00\")",null,"Med tax on wages & tips","Data!F19","CAWR.TextBox88.ControlSource=\"Data!F19\""]
["CAWR.TextBox",89," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",20,"\"), \"$#,##0.00\")",null,"Adjustments","Data!F20","CAWR.TextBox89.ControlSource=\"Data!F20\""]
["CAWR.TextBox",90," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",21,"\"), \"$#,##0.00\")",null,"Total SS & Medicare Tax","Data!F21","CAWR.TextBox90.ControlSource=\"Data!F21\""]
["CAWR.TextBox",91," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",11,"\"), \"$#,##0.00\")",null,"Total Tax with Adjustments","Data!F11","CAWR.TextBox91.ControlSource=\"Data!F11\""]
["CAWR.TextBox",{"$f":"B13+1","v":92}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",12,"\"), \"$#,##0.00\")",null,"Wages, tips, comp","Data!J12","CAWR.TextBox92.ControlSource=\"Data!J12\""]
["CAWR.TextBox",{"$f":"B14+1","v":93}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",13,"\"), \"$#,##0.00\")",null,"Ttl Income Tax WH","Data!J13","CAWR.TextBox93.ControlSource=\"Data!J13\""]
["CAWR.TextBox",94," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",14,"\"), \"$#,##0.00\")",null,"Taxable SS Wage","Data!J14","CAWR.TextBox94.ControlSource=\"Data!J14\""]
["CAWR.TextBox",95," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",15,"\"), \"$#,##0.00\")",null,"Taxable SS tips","Data!J15","CAWR.TextBox95.ControlSource=\"Data!J15\""]
["CAWR.TextBox",96," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",16,"\"), \"$#,##0.00\")",null,"Taxable Medicare wages & tips","Data!J16","CAWR.TextBox96.ControlSource=\"Data!J16\""]
["CAWR.TextBox",97," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",17,"\"), \"$#,##0.00\")",null,"Additional Med Tax","Data!J17","CAWR.TextBox97.ControlSource=\"Data!J17\""]
["CAWR.TextBox",98," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",18,"\"), \"$#,##0.00\")",null,"SS Tax on wages","Data!J18","CAWR.TextBox98.ControlSource=\"Data!J18\""]
["CAWR.TextBox",99," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",19,"\"), \"$#,##0.00\")",null,"SS tax on tips","Data!J19","CAWR.TextBox99.ControlSource=\"Data!J19\""]
["CAWR.TextBox",100," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",20,"\"), \"$#,##0.00\")",null,"Med tax on wages & tips","Data!J20","CAWR.TextBox100.ControlSource=\"Data!J20\""]
["CAWR.TextBox",101," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",21,"\"), \"$#,##0.00\")",null,"Adjustments","Data!J21","CAWR.TextBox101.ControlSource=\"Data!J21\""]
["CAWR.TextBox",102," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",21,"\"), \"$#,##0.00\")",null,"Total SS & Medicare Tax","Data!J21","CAWR.TextBox102.ControlSource=\"Data!J21\""]
["CAWR.TextBox",103," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",11,"\"), \"$#,##0.00\")",null,"Total Tax with Adjustments","Data!J11","CAWR.TextBox103.ControlSource=\"Data!J11\""]
["CAWR.TextBox",{"$f":"B25+1","v":104}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","B",27,"\"), \"$#,##0.00\")",null,"Wages, tips, comp","Data!B27","CAWR.TextBox104.ControlSource=\"Data!B27\""]
["CAWR.TextBox",{"$f":"B26+1","v":105}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","C",27,"\"), \"$#,##0.00\")",null,"Ttl Income Tax WH","Data!C27","CAWR.TextBox105.ControlSource=\"Data!C27\""]
["CAWR.TextBox",106," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","D",27,"\"), \"$#,##0.00\")",null,"Taxable SS Wage","Data!D27","CAWR.TextBox106.ControlSource=\"Data!D27\""]
["CAWR.TextBox",107," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","E",27,"\"), \"$#,##0.00\")",null,"Taxable Medicare wages & tips","Data!E27","CAWR.TextBox107.ControlSource=\"Data!E27\""]
["CAWR.TextBox",108," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","F",27,"\"), \"$#,##0.00\")",null,"Taxable SS tips","Data!F27","CAWR.TextBox108.ControlSource=\"Data!F27\""]
["CAWR.TextBox",{"$f":"B30+1","v":109}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","G",27,"\"), \"$#,##0.00\")",null,"Taxable SS tips","Data!G27","CAWR.TextBox109.ControlSource=\"Data!G27\""]
["CAWR.TextBox",{"$f":"B30+1","v":109}," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","H",27,"\"), \"$#,##0.00\")",null,"SS Tax on wages","Data!H27","CAWR.TextBox109.ControlSource=\"Data!H27\""]
["CAWR.TextBox",110," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","I",27,"\"), \"$#,##0.00\")",null,"SS tax on tips","Data!I27","CAWR.TextBox110.ControlSource=\"Data!I27\""]
["CAWR.TextBox",111," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","J",27,"\"), \"$#,##0.00\")",null,"Med tax on wages & tips","Data!J27","CAWR.TextBox111.ControlSource=\"Data!J27\""]
["CAWR.TextBox",112," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","K",27,"\"), \"$#,##0.00\")",null,"Total SS & Medicare Tax","Data!K27","CAWR.TextBox112.ControlSource=\"Data!K27\""]
["CAWR.TextBox",113," = Format(ThisWorkbook.Sheets(\"Data\").Range(\"","L",27,"\"), \"$#,##0.00\")",null,"Total Tax with Adjustments","Data!L27","CAWR.TextBox113.ControlSource=\"Data!L27\""]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["End With"]
["UpdateAllQ"]
[]
["End Sub"]