{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Coversheet","Do not use","Census","Census Instructions","Sample","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":[[37,0,41,0],[42,0,49,0],[30,2,30,3],[27,4,27,9],[28,2,28,3],[29,2,29,3],[33,0,36,0],[27,0,32,0],[32,2,32,9],[33,4,33,9],[31,2,31,3],[43,2,49,9],[38,2,39,6],[40,3,40,9],[39,7,39,8],[0,0,0,10],[18,4,18,5],[18,6,18,7],[18,8,18,9],[6,0,16,0],[17,0,26,0],[10,4,10,9],[11,4,11,5],[3,2,3,3],[9,4,9,9],[23,4,23,9],[24,4,24,9],[1,0,5,0],[20,4,20,9],[21,4,21,5],[2,4,2,9],[1,2,1,3],[13,4,13,5],[15,4,15,5],[14,7,14,8],[8,6,8,9],[13,7,13,9],[15,7,15,9],[1,4,1,6],[3,4,3,5],[5,4,5,5],[26,4,26,9],[25,4,25,9],[12,5,12,9],[34,5,34,6],[35,3,35,9],[17,4,17,9],[19,4,19,9],[34,2,34,4]]}
["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,{"$f":"VLOOKUP(E5,'Do not use'!A1:L77,12,FALSE)","v":"centralsub@uhc.com"}]
[null,null,null,"Association Name",{"$f":"VLOOKUP(E5,'Do not use'!A1:L77,2,FALSE)","v":"WMC Employer Pulse – Manufacturing"}]
[null,null,"Association Type                                                                                                                       ",null,{"$f":"VLOOKUP(E5,'Do not use'!A1:L77,3,FALSE)","v":"Old AHP Rules"}]
[null,null,null,"Franchise Code",7951931]
[null,null,null,"AHP Zip Code",{"$f":"VLOOKUP(E5,'Do not use'!A2:M77,4,FALSE)","v":53703}]
["Group Information"]
[null,null,null,"Requested Effective Date"]
[null,null,null,"Sole Proprietor? ","Select from Dropdown"]
[null,null,null,"Group Name"]
[null,null,null," Group Physical Address  "]
[null,null,null,"City  ",null,null,"State  ",null,"Zip  "]
[null,null,null,{"$f":"IF(VLOOKUP(E5,'Do not use'!A1:L77,9,FALSE)=\"Yes\",(VLOOKUP(E5,'Do not use'!A1:L77,11,FALSE)),\"\")","v":""},"Select from Dropdown",{"$f":"IF(E5=7620724,IF(E13=\"No\",\"Group is not eligible for BFF quote through Mutual Med.\",\"\"),\"\")","v":""}]
[]
[null,null,null,"Employer Contribution %",null,"Employee",null,"Dependents"]
[null,null,null,"Group SIC Code  ","Select from Dropdown"]
[]
["Agency and Sales Contact Information"]
[null,null,null,"General Agent",{"$f":"IF(VLOOKUP(E5,'Do not use'!A1:L77,8,FALSE)=\"\",\"\",VLOOKUP(E5,'Do not use'!A1:L77,8,FALSE))","v":""},null,"GA Franchise Code"]
[null,null,null,"Writing Agent  "]
[null,null,null,"Agency Name  "]
[null,null,null,"City  ",null,null,"State  ",null,"Zip  "]
[null,null,null,{"$f":"IF(VLOOKUP(E5,'Do not use'!A1:L77,10,FALSE)=\"Yes\",(VLOOKUP(E5,'Do not use'!A1:L77,11,FALSE)),\"\")","v":""},"No"]
[null,null,null,"Broker Email (Where To Send Quote)  "]
[null,null,null," GA Email (Where To Send Quote)  ",{"$f":"IF(VLOOKUP(E5,'Do not use'!A1:M77,13,FALSE)=\"\",\"\",VLOOKUP(E5,'Do not use'!A1:M77,13,FALSE))","v":""}]
[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 for a new business quote.\",\"\")","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,null,null,null,"Select from Dropdown"]
[null,null,null,{"$f":"IF(H40=\"No\",\"Dependent Level Census is required, please see the Census tab for template.\",\"\")","v":""}]
[]
["Notes"]

{"sheet":"Do not use","index":1,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["Franchise Code","AHP Name","AHP Type","AHP Zip","First Eff Date","Sole Props Allowed?","GA's Allowed?","GA Name","Group Chamber Enrollment Verification Needed?","Agency Chamber Enrollment Verification Needed?","Chamber Verification Line","RFP Submission Email Address","GA Email Address",null,null,null,"Select from Dropdown"]
["Select Franchise Code","Please select a Franchise Code Below","Please select a Franchise Code Below","Please select a Franchise Code Above","2018-10-01","Yes","Yes",null,"N/A","N/A","N/A","txoksub@uhc.com",null,null,null,null,"Yes"]
[7580724,"West Texas Employer Health Plan","New AHP Rules",79401,"2018-10-01","No","Yes","HPGA, LLC DBA Mutual Med","Yes","Yes","Current Member of Lubbock Chamber of Commerce?","chamberquote@mutualmed.com","chamberquote@mutualmed.com",null,null,null,"No"]
[7620000,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes",null,"No","No",null,"txoksub@uhc.com"]
[7620025,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com","rates@fosterbenefits.com"]
[7620234,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7620671,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7620728,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7620898,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","Dallas Insurance Exchange","No","No",null,"TBD"]
[7620724,"BFF- Texas Children Battling Cancer","New AHP Rules",75080,"2018-11-01","No","Yes","HPGA, LLC DBA Mutual Med","Yes","No","Is group address in Midland or Ector Counties?","chamberquote@mutualmed.com","chamberquote@mutualmed.com"]
[7600000,"HealthyView East Texas","New AHP Rules",75601,"2018-11-01","No","Yes",null,"Yes","Yes","Current Member of Longview Chamber of Commerce?","txoksub@uhc.com"]
[7600234,"HealthyView East Texas","New AHP Rules",75601,"2018-11-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7600025,"HealthyView East Texas","New AHP Rules",75601,"2018-11-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com","rates@fosterbenefits.com"]
[7600728,"HealthyView East Texas","New AHP Rules",75601,"2018-11-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7600671,"HealthyView East Texas","New AHP Rules",75601,"2018-11-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7650000,"North Texas Employer Health Plan Cooperative","New AHP Rules",76051,"2018-11-01","No","No",null,"No","No",null,"txoksub@uhc.com"]
[7650025,"North Texas Employer Health Plan Cooperative","New AHP Rules",76051,"2018-11-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com","rates@fosterbenefits.com"]
[7650234,"North Texas Employer Health Plan Cooperative","New AHP Rules",76051,"2018-11-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7650671,"North Texas Employer Health Plan Cooperative","New AHP Rules",76051,"2018-11-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7650728,"North Texas Employer Health Plan Cooperative","New AHP Rules",76051,"2018-11-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7640000,"Wisconsin Manufacturing & Commerce Association (WMC)","New AHP Rules",53703,"2019-01-01","No","No",null,"No","No",null,"mflynn@wmc.org"]
[7700000,"Collin County Employers Health Plan Cooperative","New AHP Rules",75013,"2018-11-01","No","No",null,"No","No",null,"txoksub@uhc.com"]
[7700025,"Collin County Employers Health Plan Cooperative","New AHP Rules",75013,"2018-11-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com"]
[7700234,"Collin County Employers Health Plan Cooperative","New AHP Rules",75013,"2018-11-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7700671,"Collin County Employers Health Plan Cooperative","New AHP Rules",75013,"2018-11-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7700728,"Collin County Employers Health Plan Cooperative","New AHP Rules",75013,"2018-11-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7730000,"Texas Association Health Plan","New AHP Rules",78205,"2019-01-01","No","No",null,"No","No",null,"txoksub@uhc.com"]
[7730025,"Texas Association Health Plan","New AHP Rules",78205,"2019-01-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com"]
[7730234,"Texas Association Health Plan","New AHP Rules",78205,"2019-01-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7730728,"Texas Association Health Plan","New AHP Rules",78205,"2019-01-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7730671,"Texas Association Health Plan","New AHP Rules",78205,"2019-01-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7910000,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","No",null,"No","No",null,"txoksub@uhc.com"]
[7910234,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","Yes","Dallas Insurance Exchange II","No","No",null,"rfp@insxch.com"]
[7910025,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","Yes","Foster Benefit Resources","No","No",null,"rates@fosterbenefits.com","rates@fosterbenefits.com"]
[7910728,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","Yes","RBG Inc- Houston","No","No",null,"bmiser@rogersbenefit.com"]
[7910671,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","Yes","Kilpatrick Companies Ltd","No","No",null,"quotes@kilpatrickcos.com"]
[7910724,"Texas Sign Association","Old AHP Rules",77802,"2019-09-01","No","Yes","HPGA, LLC DBA Mutual Med","No","No",null,"quote@mutualmed.com"]
[7920000,"Printers Industries Midwest (PIM)","Old AHP Rules",55345,"2020-01-01","No","No",null,"Yes","No","Current Member of PIM?","PIMUHC@uhc.com"]
[7950931,"WMC Employer Pulse – Wholesale & Retail Trade","Old AHP Rules",53703,"2019-10-01","No","No",null,"No","No",null,"centralsub@uhc.com"]
[7951931,"WMC Employer Pulse – Manufacturing","Old AHP Rules",53703,"2019-10-01","No","No",null,"No","No",null,"centralsub@uhc.com"]

{"sheet":"Census","index":2,"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":3,"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":4,"n_rows":1694,"n_cols":1,"rows_kept":1694,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2011]
[2012]
[2013]
[2014]
[2015]
[2016]
[2017]
[2018]
[2019]
[2020]
[2021]
[2022]
[2023]
[2024]
[2025]
[2026]
[2027]
[2028]
[2029]
[2030]
[2031]
[2032]
[2033]
[2034]
[2035]
[2036]
[2037]
[2038]
[2039]
[2040]
[2041]
[2042]
[2043]
[2044]
[2045]
[2046]
[2047]
[2048]
[2049]
[2050]
[2051]
[2052]
[2053]
[2054]
[2055]
[2056]
[2057]
[2058]
[2059]
[2060]
[2061]
[2062]
[2063]
[2064]
[2065]
[2066]
[2067]
[2068]
[2069]
[2070]
[2071]
[2072]
[2073]
[2074]
[2075]
[2076]
[2077]
[2078]
[2079]
[2080]
[2081]
[2082]
[2083]
[2084]
[2085]
[2086]
[2087]
[2088]
[2089]
[2091]
[2092]
[2093]
[2094]
[2095]
[2096]
[2097]
[2098]
[2099]
[2111]
[2112]
[2113]
[2114]
[2115]
[2116]
[2117]
[2118]
[2119]
[2120]
[2121]
[2122]
[2123]
[2124]
[2125]
[2126]
[2127]
[2128]
[2129]
[2130]
[2131]
[2132]
[2133]
[2134]
[2135]
[2136]
[2137]
[2138]
[2139]
[2140]
[2141]
[2142]
[2143]
[2144]
[2145]
[2146]
[2147]
[2148]
[2149]
[2211]
[2212]
[2213]
[2214]
[2215]
[2216]
[2217]
[2218]
[2219]
[2220]
[2221]
[2222]
[2223]
[2224]
[2225]
[2226]
[2227]
[2228]
[2229]
[2230]
[2231]
[2232]
[2233]
[2234]
[2235]
[2236]
[2237]
[2238]
[2239]
[2240]
[2241]
[2242]
[2243]
[2244]
[2245]
[2246]
[2247]
[2248]
[2249]
[2250]
[2251]
[2252]
[2253]
[2254]
[2255]
[2256]
[2257]
[2258]
[2259]
[2260]
[2261]
[2262]
[2263]
[2264]
[2265]
[2266]
[2267]
[2268]
[2269]
[2270]
[2271]
[2272]
[2273]
[2274]
[2275]
[2276]
[2277]
[2278]
[2279]
[2280]
[2281]
[2282]
[2283]
[2284]
[2285]
[2286]
[2287]
[2288]
[2289]
[2290]
[2291]
[2292]
[2293]
[2294]
[2295]
[2296]
[2297]
[2298]
[2299]
[2311]
[2312]
[2313]
[2314]
[2315]
[2316]
[2317]
[2318]
[2319]
[2320]
[2321]
[2322]
[2323]
[2324]
[2325]
[2326]
[2327]
[2328]
[2329]
[2330]
[2331]
[2332]
[2333]
[2334]
[2335]
[2336]
[2337]
[2338]
[2339]
[2340]
[2341]
[2342]
[2343]
[2344]
[2345]
[2346]
[2347]
[2348]
[2349]
[2350]
[2351]
[2352]
[2353]
[2354]
[2355]
[2356]
[2357]
[2358]
[2359]
[2360]
[2361]
[2362]
[2363]
[2364]
[2365]
[2366]
[2367]
[2368]
[2369]
[2370]
[2371]
[2372]
[2373]
[2374]
[2375]
[2376]
[2377]
[2378]
[2379]
[2380]
[2381]
[2382]
[2383]
[2384]
[2385]
[2386]
[2387]
[2388]
[2389]
[2390]
[2391]
[2392]
[2393]
[2394]
[2395]
[2396]
[2397]
[2398]
[2399]
[2411]
[2412]
[2413]
[2414]
[2415]
[2416]
[2417]
[2418]
[2419]
[2420]
[2421]
[2422]
[2423]
[2424]
[2425]
[2426]
[2427]
[2428]
[2429]
[2431]
[2432]
[2433]
[2434]
[2435]
[2436]
[2437]
[2438]
[2439]
[2440]
[2441]
[2442]
[2443]
[2444]
[2445]
[2446]
[2447]
[2448]
[2449]
[2450]
[2451]
[2452]
[2453]
[2454]
[2455]
[2456]
[2457]
[2458]
[2459]
[2460]
[2461]
[2462]
[2463]
[2464]
[2465]
[2466]
[2467]
[2468]
[2469]
[2470]
[2471]
[2472]
[2473]
[2474]
[2475]
[2476]
[2477]
[2478]
[2479]
[2480]
[2481]
[2482]
[2483]
[2484]
[2485]
[2486]
[2487]
[2488]
[2489]
[2490]
[2491]
[2492]
[2493]
[2494]
[2495]
[2496]
[2497]
[2498]
[2499]
[2511]
[2512]
[2513]
[2514]
[2515]
[2516]
[2517]
[2518]
[2519]
[2520]
[2521]
[2522]
[2523]
[2524]
[2525]
[2526]
[2527]
[2528]
[2529]
[2530]
[2531]
[2532]
[2533]
[2534]
[2535]
[2536]
[2537]
[2538]
[2539]
[2540]
[2541]
[2542]
[2543]
[2544]
[2545]
[2546]
[2547]
[2548]
[2549]
[2550]
[2551]
[2552]
[2553]
[2554]
[2555]
[2556]
[2557]
[2558]
[2559]
[2560]
[2561]
[2562]
[2563]
[2564]
[2565]
[2566]
[2567]
[2568]
[2569]
[2570]
[2571]
[2572]
[2573]
[2574]
[2575]
[2576]
[2577]
[2578]
[2579]
[2580]
[2581]
[2582]
[2583]
[2584]
[2585]
[2586]
[2587]
[2588]
[2589]
[2590]
[2591]
[2592]
[2593]
[2594]
[2595]
[2596]
[2597]
[2598]
[2599]
[2611]
[2612]
[2613]
[2614]
[2615]
[2616]
[2617]
[2618]
[2619]
[2620]
[2621]
[2622]
[2623]
[2624]
[2625]
[2626]
[2627]
[2628]
[2629]
[2630]
[2631]
[2632]
[2633]
[2634]
[2635]
[2636]
[2637]
[2638]
[2639]
[2640]
[2641]
[2642]
[2643]
[2644]
[2645]
[2646]
[2647]
[2648]
[2649]
[2650]
[2651]
[2652]
[2653]
[2654]
[2655]
[2656]
[2657]
[2658]
[2659]
[2660]
[2661]
[2662]
[2663]
[2664]
[2665]
[2666]
[2667]
[2668]
[2669]
[2670]
[2671]
[2672]
[2673]
[2674]
[2675]
[2676]
[2677]
[2678]
[2679]
[2711]
[2712]
[2713]
[2714]
[2715]
[2716]
[2717]
[2718]
[2719]
[2720]
[2721]
[2722]
[2723]
[2724]
[2725]
[2726]
[2727]
[2728]
[2729]
[2730]
[2731]
[2732]
[2733]
[2734]
[2735]
[2736]
[2737]
[2738]
[2739]
[2740]
[2741]
[2742]
[2743]
[2744]
[2745]
[2746]
[2747]
[2748]
[2749]
[2750]
[2751]
[2752]
[2753]
[2754]
[2755]
[2756]
[2757]
[2758]
[2759]
[2760]
[2761]
[2762]
[2763]
[2764]
[2765]
[2766]
[2767]
[2768]
[2769]
[2770]
[2771]
[2772]
[2773]
[2774]
[2775]
[2776]
[2777]
[2778]
[2779]
[2780]
[2781]
[2782]
[2783]
[2784]
[2785]
[2786]
[2787]
[2788]
[2789]
[2790]
[2791]
[2792]
[2793]
[2794]
[2795]
[2796]
[2797]
[2798]
[2799]
[2811]
[2812]
[2813]
[2814]
[2815]
[2816]
[2817]
[2818]
[2819]
[2821]
[2822]
[2823]
[2824]
[2825]
[2826]
[2827]
[2828]
[2829]
[2830]
[2831]
[2832]
[2833]
[2834]
[2835]
[2836]
[2837]
[2838]
[2839]
[2840]
[2841]
[2842]
[2843]
[2844]
[2845]
[2846]
[2847]
[2848]
[2849]
[2850]
[2851]
[2852]
[2853]
[2854]
[2855]
[2856]
[2857]
[2858]
[2859]
[2860]
[2861]
[2862]
[2863]
[2864]
[2865]
[2866]
[2867]
[2868]
[2869]
[2871]
[2872]
[2873]
[2874]
[2875]
[2876]
[2877]
[2878]
[2879]
[2880]
[2881]
[2882]
[2883]
[2884]
[2885]
[2886]
[2887]
[2888]
[2889]
[2890]
[2891]
[2892]
[2893]
[2894]
[2895]
[2896]
[2897]
[2898]
[2899]
[2911]
[2912]
[2913]
[2914]
[2915]
[2916]
[2917]
[2918]
[2919]
[2920]
[2921]
[2922]
[2923]
[2924]
[2925]
[2926]
[2927]
[2928]
[2929]
[2930]
[2931]
[2932]
[2933]
[2934]
[2935]
[2936]
[2937]
[2938]
[2939]
[2940]
[2941]
[2942]
[2943]
[2944]
[2945]
[2946]
[2947]
[2948]
[2949]
[2950]
[2951]
[2952]
[2953]
[2954]
[2955]
[2956]
[2957]
[2958]
[2959]
[2960]
[2961]
[2962]
[2963]
[2964]
[2965]
[2966]
[2967]
[2968]
[2969]
[2970]
[2971]
[2972]
[2973]
[2974]
[2975]
[2976]
[2977]
[2978]
[2979]
[2980]
[2981]
[2982]
[2983]
[2984]
[2985]
[2986]
[2987]
[2988]
[2989]
[2990]
[2991]
[2992]
[2993]
[2994]
[2995]
[2996]
[2997]
[2998]
[2999]
[3011]
[3012]
[3013]
[3014]
[3015]
[3016]
[3017]
[3018]
[3019]
[3020]
[3021]
[3022]
[3023]
[3024]
[3025]
[3026]
[3027]
[3028]
[3029]
[3030]
[3031]
[3032]
[3033]
[3034]
[3035]
[3036]
[3037]
[3038]
[3039]
[3040]
[3041]
[3042]
[3043]
[3044]
[3045]
[3046]
[3047]
[3048]
[3049]
[3050]
[3051]
[3052]
[3053]
[3054]
[3055]
[3056]
[3057]
[3058]
[3059]
[3060]
[3061]
[3062]
[3063]
[3064]
[3065]
[3066]
[3067]
[3068]
[3069]
[3070]
[3071]
[3072]
[3073]
[3074]
[3075]
[3076]
[3077]
[3078]
[3079]
[3080]
[3081]
[3082]
[3083]
[3084]
[3085]
[3086]
[3087]
[3088]
[3089]
[3111]
[3112]
[3113]
[3114]
[3115]
[3116]
[3117]
[3118]
[3119]
[3120]
[3121]
[3122]
[3123]
[3124]
[3125]
[3126]
[3127]
[3128]
[3129]
[3130]
[3131]
[3132]
[3133]
[3134]
[3135]
[3136]
[3137]
[3138]
[3139]
[3140]
[3141]
[3142]
[3143]
[3144]
[3145]
[3146]
[3147]
[3148]
[3149]
[3150]
[3151]
[3152]
[3153]
[3154]
[3155]
[3156]
[3157]
[3158]
[3159]
[3160]
[3161]
[3162]
[3163]
[3164]
[3165]
[3166]
[3167]
[3168]
[3169]
[3170]
[3171]
[3172]
[3173]
[3174]
[3175]
[3176]
[3177]
[3178]
[3179]
[3180]
[3181]
[3182]
[3183]
[3184]
[3185]
[3186]
[3187]
[3188]
[3189]
[3190]
[3191]
[3192]
[3193]
[3194]
[3195]
[3196]
[3197]
[3198]
[3199]
[3211]
[3212]
[3213]
[3214]
[3215]
[3216]
[3217]
[3218]
[3219]
[3220]
[3221]
[3222]
[3223]
[3224]
[3225]
[3226]
[3227]
[3228]
[3229]
[3230]
[3231]
[3232]
[3233]
[3234]
[3235]
[3236]
[3237]
[3238]
[3239]
[3240]
[3241]
[3242]
[3243]
[3244]
[3245]
[3246]
[3247]
[3248]
[3249]
[3250]
[3251]
[3252]
[3253]
[3254]
[3255]
[3256]
[3257]
[3258]
[3259]
[3260]
[3261]
[3262]
[3263]
[3264]
[3265]
[3266]
[3267]
[3268]
[3269]
[3270]
[3271]
[3272]
[3273]
[3274]
[3275]
[3276]
[3277]
[3278]
[3279]
[3280]
[3281]
[3282]
[3283]
[3284]
[3285]
[3286]
[3287]
[3288]
[3289]
[3291]
[3292]
[3293]
[3294]
[3295]
[3296]
[3297]
[3298]
[3299]
[3311]
[3312]
[3313]
[3314]
[3315]
[3316]
[3317]
[3318]
[3319]
[3320]
[3321]
[3322]
[3323]
[3324]
[3325]
[3326]
[3327]
[3328]
[3329]
[3330]
[3331]
[3332]
[3333]
[3334]
[3335]
[3336]
[3337]
[3338]
[3339]
[3340]
[3341]
[3342]
[3343]
[3344]
[3345]
[3346]
[3347]
[3348]
[3349]
[3350]
[3351]
[3352]
[3353]
[3354]
[3355]
[3356]
[3357]
[3358]
[3359]
[3360]
[3361]
[3362]
[3363]
[3364]
[3365]
[3366]
[3367]
[3368]
[3369]
[3370]
[3371]
[3372]
[3373]
[3374]
[3375]
[3376]
[3377]
[3378]
[3379]
[3380]
[3381]
[3382]
[3383]
[3384]
[3385]
[3386]
[3387]
[3388]
[3389]
[3390]
[3391]
[3392]
[3393]
[3394]
[3395]
[3396]
[3397]
[3398]
[3399]
[3411]
[3412]
[3413]
[3414]
[3415]
[3416]
[3417]
[3418]
[3419]
[3420]
[3421]
[3422]
[3423]
[3424]
[3425]
[3426]
[3427]
[3428]
[3429]
[3430]
[3431]
[3432]
[3433]
[3434]
[3435]
[3436]
[3437]
[3438]
[3439]
[3440]
[3441]
[3442]
[3443]
[3444]
[3445]
[3446]
[3447]
[3448]
[3449]
[3450]
[3451]
[3452]
[3453]
[3454]
[3455]
[3456]
[3457]
[3458]
[3459]
[3460]
[3461]
[3462]
[3463]
[3464]
[3465]
[3466]
[3467]
[3468]
[3469]
[3470]
[3471]
[3472]
[3473]
[3474]
[3475]
[3476]
[3477]
[3478]
[3479]
[3480]
[3481]
[3482]
[3483]
[3484]
[3485]
[3486]
[3487]
[3488]
[3489]
[3490]
[3491]
[3492]
[3493]
[3494]
[3495]
[3496]
[3497]
[3498]
[3499]
[3511]
[3512]
[3513]
[3514]
[3515]
[3516]
[3517]
[3518]
[3519]
[3520]
[3521]
[3522]
[3523]
[3524]
[3525]
[3526]
[3527]
[3528]
[3529]
[3530]
[3531]
[3532]
[3533]
[3534]
[3535]
[3536]
[3537]
[3538]
[3539]
[3540]
[3541]
[3542]
[3543]
[3544]
[3545]
[3546]
[3547]
[3548]
[3549]
[3550]
[3551]
[3552]
[3553]
[3554]
[3555]
[3556]
[3557]
[3558]
[3559]
[3560]
[3561]
[3562]
[3563]
[3564]
[3565]
[3566]
[3567]
[3568]
[3569]
[3570]
[3571]
[3572]
[3573]
[3574]
[3575]
[3576]
[3577]
[3578]
[3579]
[3580]
[3581]
[3582]
[3583]
[3584]
[3585]
[3586]
[3587]
[3588]
[3589]
[3590]
[3591]
[3592]
[3593]
[3594]
[3595]
[3596]
[3597]
[3598]
[3599]
[3611]
[3612]
[3613]
[3614]
[3615]
[3616]
[3617]
[3618]
[3619]
[3620]
[3621]
[3622]
[3623]
[3624]
[3625]
[3626]
[3627]
[3628]
[3629]
[3630]
[3631]
[3632]
[3633]
[3634]
[3635]
[3636]
[3637]
[3638]
[3639]
[3640]
[3641]
[3642]
[3643]
[3644]
[3645]
[3646]
[3647]
[3648]
[3649]
[3650]
[3651]
[3652]
[3653]
[3654]
[3655]
[3656]
[3657]
[3658]
[3659]
[3660]
[3661]
[3662]
[3663]
[3664]
[3665]
[3666]
[3667]
[3668]
[3669]
[3670]
[3671]
[3672]
[3673]
[3674]
[3675]
[3676]
[3677]
[3678]
[3679]
[3680]
[3681]
[3682]
[3683]
[3684]
[3685]
[3686]
[3687]
[3688]
[3689]
[3690]
[3691]
[3692]
[3693]
[3694]
[3695]
[3696]
[3697]
[3698]
[3699]
[3711]
[3712]
[3713]
[3714]
[3715]
[3716]
[3717]
[3718]
[3719]
[3720]
[3721]
[3722]
[3723]
[3724]
[3725]
[3726]
[3727]
[3728]
[3729]
[3730]
[3731]
[3732]
[3733]
[3734]
[3735]
[3736]
[3737]
[3738]
[3739]
[3740]
[3741]
[3742]
[3743]
[3744]
[3745]
[3746]
[3747]
[3748]
[3749]
[3750]
[3751]
[3752]
[3753]
[3754]
[3755]
[3756]
[3757]
[3758]
[3759]
[3760]
[3761]
[3762]
[3763]
[3764]
[3765]
[3766]
[3767]
[3768]
[3769]
[3770]
[3771]
[3772]
[3773]
[3774]
[3775]
[3776]
[3777]
[3778]
[3779]
[3780]
[3781]
[3782]
[3783]
[3784]
[3785]
[3786]
[3787]
[3788]
[3789]
[3790]
[3791]
[3792]
[3793]
[3794]
[3795]
[3796]
[3797]
[3798]
[3799]
[3811]
[3812]
[3813]
[3814]
[3815]
[3816]
[3817]
[3818]
[3819]
[3820]
[3821]
[3822]
[3823]
[3824]
[3825]
[3826]
[3827]
[3828]
[3829]
[3830]
[3831]
[3832]
[3833]
[3834]
[3835]
[3836]
[3837]
[3838]
[3839]
[3840]
[3841]
[3842]
[3843]
[3844]
[3845]
[3846]
[3847]
[3848]
[3849]
[3850]
[3851]
[3852]
[3853]
[3854]
[3855]
[3856]
[3857]
[3858]
[3859]
[3860]
[3861]
[3862]
[3863]
[3864]
[3865]
[3866]
[3867]
[3868]
[3869]
[3870]
[3871]
[3872]
[3873]
[3874]
[3875]
[3876]
[3877]
[3878]
[3879]
[3911]
[3912]
[3913]
[3914]
[3915]
[3916]
[3917]
[3918]
[3919]
[3920]
[3921]
[3922]
[3923]
[3924]
[3925]
[3926]
[3927]
[3928]
[3929]
[3930]
[3931]
[3932]
[3933]
[3934]
[3935]
[3936]
[3937]
[3938]
[3939]
[3940]
[3941]
[3942]
[3943]
[3944]
[3945]
[3946]
[3947]
[3948]
[3949]
[3950]
[3951]
[3952]
[3953]
[3954]
[3955]
[3956]
[3957]
[3958]
[3959]
[3960]
[3961]
[3962]
[3963]
[3964]
[3965]
[3966]
[3967]
[3968]
[3969]
[3970]
[3971]
[3972]
[3973]
[3974]
[3975]
[3976]
[3977]
[3978]
[3979]
[3980]
[3981]
[3982]
[3983]
[3984]
[3985]
[3986]
[3987]
[3988]
[3989]
[3990]
[3991]
[3992]
[3993]
[3994]
[3995]
[3996]
[3997]
[3998]
[3999]

{"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."]