{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Coversheet","Census","Census Instructions","Sample","Do not use","ATNE Calculator"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":17,"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":"Coversheet","index":0,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,10],[42,0,49,0],[38,2,38,4],[30,2,30,3],[27,4,27,9],[28,2,28,3],[29,2,29,3],[33,0,36,0],[27,0,32,0],[1,0,5,0],[5,4,5,9],[32,2,32,9],[43,2,49,9],[35,3,35,8],[17,0,26,0],[1,4,1,5],[26,4,26,9],[1,2,1,3],[4,4,4,9],[13,4,13,5],[15,4,15,5],[14,7,14,8],[8,6,8,9],[13,7,13,9],[2,4,2,9],[10,4,10,9],[11,4,11,5],[3,4,3,9],[3,2,3,3],[9,4,9,9],[6,0,16,0],[39,7,39,8],[34,2,34,4],[34,5,34,6],[15,7,15,9],[37,0,41,0],[33,4,33,9],[31,2,31,3],[39,2,39,6],[23,4,23,9],[24,4,24,9],[25,4,25,9],[17,4,17,9],[19,4,19,9],[20,4,20,9],[21,4,21,5]]}
["AHP: Quote Request Form\n(Complete all fields and submit to emailbox indicated to obtain quote)"]
["Association Information",null,"Please submit to Emailbox address",null,"mflynn@wmc.org"]
[null,null,null,"Association Name","Wisconsin Manufacturing & Commerce Association (WMC)"]
[null,null,"Association Type                                                                                                                       ",null,"New AHP Rules"]
[null,null,null,"Franchise Code",764000]
[null,null,null,"AHP Zip Code",53703]
["Group Information"]
[null,null,null,"Requested Effective Date"]
[]
[null,null,null,"Group Name"]
[null,null,null," Group Physical Address  "]
[null,null,null,"City  ",null,null,"State  ",null,"Zip  "]
[null,null,null,"Current Member of Lubbock Chamber of Commerce?","Select from Dropdown"]
[]
[null,null,null,"Employer Contribution %",null,"Employee",null,"Dependents"]
[null,null,null,"Group SIC Code  "]
[]
["Agency and Sales Contact Information"]
[null,null,null,"General Agent","HPGA, LLC DBA Mutual Med"]
[null,null,null,"Writing Agent  "]
[null,null,null,"Agency Name  "]
[null,null,null,"City  ",null,null,"State  ",null,"Zip  "]
[null,null,null,"Current Member of Lubbock Chamber of Commerce?","Select from Dropdown"]
[null,null,null,"Broker Email (Where To Send Quote)  "]
[null,null,null," GA Email (Where To Send Quote)  ","chamberquote@mutualmed.com"]
[null,null,null,"UHC Account Executive  "]
[]
["Group Size"]
[null,null,"Average Total Number of (W-2) Employees (ATNE) "]
[null,null,"Total Number of Eligible Employees"]
[null,null,"Total Number of Enrolling Employees"]
[null,null,"Total Number of Valid Waivers"]
[]
["Carrier history"]
[null,null,"Is this group currently covered by UHC or one of its Affiliates? ",null,null,"Select from Dropdown"]
[null,null,null,{"$f":"IF(F35=\"Yes\",\"Please contact your Renewal Representative, do not submit this request to centralsub@uhc.com\",\"\")","v":""}]
[]
["Other Required Documents"]
[]
[null,null,"Dependent Level Census in Excel format listing all enrolling members (DOB, Gender, Home Zip, Relationship):",null,null,null,null,"Select from Dropdown"]
[]
[]
["Notes"]

{"sheet":"Census","index":1,"n_rows":425,"n_cols":10,"rows_kept":425,"cut":false,"hidden":false,"merged":[[2,9,3,9],[1,5,1,8],[2,2,2,8],[5,0,6,0],[2,0,3,0],[2,1,3,1]]}
[]
["Member-Level Census"]
["Internal Use Only","Auto Populated","These yellow fields must be completed for all members (employees, spouses and children)",null,null,null,null,null,null,"Optional"]
[null,null,"E for Employee          S for Spouse              D for Children","Optional","Optional",null,null,null,"EE for Employee Only                           ES for Employee + Spouse                           EC for Employee + Child(ren)                          F for Family"]
["SEQ","EE ID","REL CODE","LAST NAME","FIRST NAME","DOB","GENDER","ZIP","MED TIER","EE STATUS"]
["Sample",1,"E","Smith","John","1970-06-01","M",45111,"ES ","Active"]
[null,1,"S","Smith","Jane","1972-10-01","F",45111]
[null,{"$f":"IF(C8=\"E\",1,\"\")","v":""}]
[null,{"$f":"IF(C9=\"E\",B8+1,IF(C9=\"S\",B8,IF(C9=\"D\",B8,\"\")))","v":""}]
[null,{"$f":"IF(C10=\"E\",B9+1,IF(C10=\"S\",B9,IF(C10=\"D\",B9,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C74=\"E\",B73+1,IF(C74=\"S\",B73,IF(C74=\"D\",B73,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C138=\"E\",B137+1,IF(C138=\"S\",B137,IF(C138=\"D\",B137,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C202=\"E\",B201+1,IF(C202=\"S\",B201,IF(C202=\"D\",B201,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C266=\"E\",B265+1,IF(C266=\"S\",B265,IF(C266=\"D\",B265,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C330=\"E\",B329+1,IF(C330=\"S\",B329,IF(C330=\"D\",B329,\"\")))","v":""}]
[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,""]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,{"$f":"IF(C394=\"E\",B393+1,IF(C394=\"S\",B393,IF(C394=\"D\",B393,\"\")))","v":""}]
[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,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"Census Instructions","index":2,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,7],[7,0,7,7],[0,0,0,4],[0,7,0,8],[2,0,2,7],[3,0,3,7],[5,0,5,7]]}
["Underwritten Quote: \n51-350 Eligible Subscribers"]
[]
["Important Instructions"]
["1. All fields are required, unless otherwise indicated."]
["2. Census must include all subscribers, spouses, and children who are eligible to enroll as of the effective date."]
["3. Dependents must be grouped immediately underneath the Subscriber to whom they are related."]
["4. Names, if provided, should not include middle initials or suffixes."]
["5. Census must include the home zip code for every employee and dependent."]

{"sheet":"Sample","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Do not use","index":4,"n_rows":36,"n_cols":1,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["yes"]
["no"]
[]
[]
["New AHP Rules"]
["Old AHP Rules"]
[]
[]
[]
["centralsub@uhc.com"]
["sesub@uhc.com"]
["nesub@uhc.com"]
["westsub@uhc.com"]
["txoksub@uhc.com"]
["nequotes@uhc.com"]
["sequotes@uhc.com"]
["centralquotes@uhc.com"]
["westquotes@uhc.com"]
["txokquotes@uhc.com"]
["vo_nationalaccounts@uhc.com"]
[]
["2018-01-01"]
["2018-02-01"]
["2018-03-01"]
["2018-04-01"]
["2018-05-01"]
["2018-06-01"]
["2018-07-01"]
["2018-08-01"]
["2018-09-01"]
["2018-10-01"]
["2018-11-01"]
["2018-12-01"]
["Select from Dropdown"]
["Yes"]
["No"]

{"sheet":"ATNE Calculator","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,7],[22,1,26,7],[2,1,2,7],[0,1,0,7],[14,1,14,7],[16,1,16,7],[18,1,18,7]]}
[null,"Average Total Number of Employees Calculator"]
[]
[null,"Enter the total number of all employees on payroll during the last day of each month in the previous calendar year.  (Ex. 10/1/18 effective date should use 2017 calendar year employee counts below)\nFor groups in business less than one year, enter the months the group has been in business.\nInclude full-time, part-time, seasonal, and eligible owners."]
[]
[]
[null,"***Fill out green shaded answer boxes***","Jan","Feb","Mar","Apr","May","Jun"]
[null,"Total Number of Employees (Monthly)"]
[null,null,{"$f":"IF(OR(C7=\"\",C7=0),0,1)","v":0},0,0,0,0,0]
[null,null,"Jul","Aug","Sept","Oct","Nov","Dec"]
[null,"Total Number of Employees (Monthly)"]
[null,null,{"$f":"IF(OR(C10=\"\",C10=0),0,1)","v":0},0,0,0,0,0]
[null,"Average Total Number of Employees",{"$f":"IF(ISERROR(SUM(C7:H7,C10:H10)/SUM(C8:H8,C11:H11)),\"\",SUM(C7:H7,C10:H10)/SUM(C8:H8,C11:H11))","v":""}]
[]
[]
[null,"-The ATNE count should include all employees employed by the group during the year in question, including full-time, part-time, and seasonal workers, as well as those who do not qualify for medical coverage.  Generally, inviduals receiving a W-2 qualify as \"employees\" whereas those who receive a 1099 statement are not employees (but independent contractors) and may be excluded; however, it is an employer's obligation to determine who their employees are."]
[]
[null,"-The ATNE count includes owners and partners who may not always get W-2's."]
[]
[null,"-Using whole numbers only, the employer should total the number of employees at the end of each month in the year being requested for ATNE calculation."]
[]
[null,"-The monthly totals for the full year should be added together and that total divided by the number of months in which the employer was in business for that calendar year.  For most employers, this will be 12 months."]
[]
[null,"DISCLAIMER:  This Tool is a calculator provided for informational purposes only.  Use of this tool is not intended as legal and/or tax advice and outcomes should not be considered determinative in any particular case.  Calculations for the Employer mandate are complex.  Employers and/or brokers need to consult their legal and tax advisors to determine applicability of the mandate and to determine their available options."]