{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["WPS Quote","WPS Tables","WPS Rating Factors"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"WPS Quote","index":0,"n_rows":65,"n_cols":19,"rows_kept":65,"cut":false,"hidden":false,"merged":[[34,1,34,3],[34,12,34,13],[4,16,5,17],[12,1,13,14],[17,3,17,4],[31,7,33,7],[31,8,31,11],[31,12,31,13],[31,14,33,14],[32,9,33,9],[32,10,33,10],[32,12,32,13],[33,12,33,13],[31,1,31,3],[32,1,32,3],[33,1,33,3],[88,1,88,14],[43,1,43,3],[43,12,43,13],[44,1,44,3],[44,12,44,13],[50,14,52,14],[53,1,53,3],[53,12,53,13],[54,1,54,3],[54,12,54,13],[50,4,52,5],[54,4,54,5],[54,6,54,7],[52,1,52,3],[54,8,54,11],[51,1,51,3],[35,1,35,3],[35,12,35,13],[50,6,52,7],[50,8,52,11],[50,12,52,13],[37,1,37,3],[37,12,37,13],[38,12,38,13],[39,1,39,3],[39,12,39,13],[40,12,40,13],[41,1,41,3],[41,12,41,13],[50,1,50,3]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Quote Date: ",{"$f":"TODAY()","v":"2023-07-21"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Valid Through: ","2024-12-31"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK('WPS Tables'!O1,\"Enroll Now\")","v":"Enroll Now"}]
[]
[]
[]
[]
[]
[]
[]
[null,"2024 Individual Off-Exchange ACA Plan Quote"]
[]
[]
[]
[]
[null,null,"Applicant Name: ",null,null,null,null,"Effective Date: "]
[]
[null,null,"Spouse: ",null,null,null,null,"County: "]
[]
[null,null,"# of Dependents: "]
[]
[]
[]
[null,null,"Date of Birth",null,"Tobacco Status",null,{"$f":"IF('WPS Quote'!D22>0,\"Date of Birth\",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>2,\"Date of Birth\",\"\")","v":""},null,null,{"$f":"IF('WPS Quote'!D22>4,\"Date of Birth\",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>6,\"Date of Birth\",\"\")","v":""}]
[]
[null,"Applicant: ",null,null,null,{"$f":"IF('WPS Quote'!D22>0,\"Dependent 1: \",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>2,\"Dependent 3: \",\"\")","v":""},null,null,{"$f":"IF('WPS Quote'!D22>4,\"Dependent 5: \",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>6,\"Dependent 7: \",\"\")","v":""},null,null,null,null,null,{"$f":"IF('WPS Quote'!D22>8,\"Dependent 9: \",\"\")","v":""}]
[]
[null,{"$f":"IF('WPS Tables'!G5=3,\"Spouse: \",\"\")","v":""},null,null,null,{"$f":"IF('WPS Quote'!D22>1,\"Dependent 2: \",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>3,\"Dependent 4: \",\"\")","v":""},null,null,{"$f":"IF('WPS Quote'!D22>5,\"Dependent 6: \",\"\")","v":""},null,{"$f":"IF('WPS Quote'!D22>7,\"Dependent 8: \",\"\")","v":""},null,null,null,null,null,{"$f":"IF('WPS Quote'!D22>9,\"Dependent 10: \",\"\")","v":""}]
[]
[null,"Medical Plan Name",null,null,null,"Individual",null,"Individual Out-of-Pocket Limit (In/Out)1","         In Network Plan Copays          ",null,null,null,"Prescription Drug Copays",null,"Monthly Rate"]
[null,"Statewide Network",null,null,"Metal","Deductible","Coins.",null,"Telehealth/","PCP","Spec.","Emerg.","Preventive/Pref Gen/Non-Pref Gen/"]
[null,"(select plan name for SBC)",null,null,null,"(In/Out)1","(In/Out)",null,"Retail",null,null,"Room","Pref Brand/Non-Pref Brand/Specialty"]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O4,'WPS Tables'!N4)","v":"WPS PPO Bronze $6,500 with 3 Free PCP Visits"},null,null,{"$f":"'WPS Rating Factors'!AO8","v":"Bronze"},{"$f":"\"$\"&'WPS Rating Factors'!AP8&\"/$\"&'WPS Rating Factors'!AQ8","v":"$6500/$13000"},{"$f":"100*'WPS Rating Factors'!AR8&\"% / \"&100*'WPS Rating Factors'!AS8&\"%\"","v":"20% / 50%"},{"$f":"\"$\"&'WPS Rating Factors'!AT8&\"/$\"&'WPS Rating Factors'!AU8","v":"$9100/$23000"},{"$f":"'WPS Rating Factors'!AV8","v":"D/C"},{"$f":"'WPS Rating Factors'!AW8","v":"3 Free"},{"$f":"'WPS Rating Factors'!AX8","v":"D/C"},{"$f":"'WPS Rating Factors'!AY8","v":"D/C"},{"$f":"'WPS Rating Factors'!BA8","v":"$0 preventive, D/C all others"},null,{"$f":"'WPS Rating Factors'!BC8","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O5,'WPS Tables'!N5)","v":"WPS PPO Bronze $9,450"},null,null,{"$f":"'WPS Rating Factors'!AO9","v":"Bronze"},{"$f":"\"$\"&'WPS Rating Factors'!AP9&\"/$\"&'WPS Rating Factors'!AQ9","v":"$9450/$18900"},{"$f":"100*'WPS Rating Factors'!AR9&\"% / \"&100*'WPS Rating Factors'!AS9&\"%\"","v":"0% / 30%"},{"$f":"\"$\"&'WPS Rating Factors'!AT9&\"/$\"&'WPS Rating Factors'!AU9","v":"$9450/$24900"},{"$f":"'WPS Rating Factors'!AV9","v":"D/C"},{"$f":"'WPS Rating Factors'!AW9","v":"D/C"},{"$f":"'WPS Rating Factors'!AX9","v":"D/C"},{"$f":"'WPS Rating Factors'!AY9","v":"D/C"},{"$f":"'WPS Rating Factors'!BA9","v":"$0 preventive, D/C all others"},null,{"$f":"'WPS Rating Factors'!BC9","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O6,'WPS Tables'!N6)","v":"WPS PPO Catastrophic $9,100 with 3 Free PCP Visits"},null,null,"Catastrophic2",{"$f":"\"$\"&'WPS Rating Factors'!AP13&\"/$\"&'WPS Rating Factors'!AQ13","v":"$9100/$18200"},{"$f":"130*'WPS Rating Factors'!AR13&\"% / \"&100*'WPS Rating Factors'!AS13&\"%\"","v":"0% / 30%"},{"$f":"\"$\"&'WPS Rating Factors'!AT13&\"/$\"&'WPS Rating Factors'!AU13","v":"$9100/$24200"},{"$f":"'WPS Rating Factors'!AV13","v":"D/C"},{"$f":"'WPS Rating Factors'!AW13","v":"3 Free"},{"$f":"'WPS Rating Factors'!AX13","v":"D/C"},{"$f":"'WPS Rating Factors'!AY13","v":"D/C"},{"$f":"'WPS Rating Factors'!BA13","v":"$0 preventive, D/C all others"},null,{"$f":"'WPS Rating Factors'!BC13","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O7,'WPS Tables'!N7)","v":"WPS PPO HDHP Bronze $6,000"},null,null,{"$f":"'WPS Rating Factors'!AO14","v":"Bronze"},{"$f":"\"$\"&'WPS Rating Factors'!AP14&\"/$\"&'WPS Rating Factors'!AQ14","v":"$6000/$12000"},{"$f":"100*'WPS Rating Factors'!AR14&\"% / \"&100*'WPS Rating Factors'!AS14&\"%\"","v":"30% / 50%"},{"$f":"\"$\"&'WPS Rating Factors'!AT14&\"/$\"&'WPS Rating Factors'!AU14","v":"$7500/$22000"},{"$f":"'WPS Rating Factors'!AV14","v":"D/C"},{"$f":"'WPS Rating Factors'!AW14","v":"D/C"},{"$f":"'WPS Rating Factors'!AX14","v":"D/C"},{"$f":"'WPS Rating Factors'!AY14","v":"D/C"},{"$f":"'WPS Rating Factors'!BA14","v":"$0 preventive, D/C all others"},null,{"$f":"'WPS Rating Factors'!BC14","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O8,'WPS Tables'!N8)","v":"WPS PPO HDHP Bronze $7,500"},null,null,{"$f":"'WPS Rating Factors'!AO15","v":"Bronze"},{"$f":"\"$\"&'WPS Rating Factors'!AP15&\"/$\"&'WPS Rating Factors'!AQ15","v":"$7500/$15000"},{"$f":"100*'WPS Rating Factors'!AR15&\"% / \"&100*'WPS Rating Factors'!AS15&\"%\"","v":"0% / 30%"},{"$f":"\"$\"&'WPS Rating Factors'!AT15&\"/$\"&'WPS Rating Factors'!AU15","v":"$7500/$21000"},{"$f":"'WPS Rating Factors'!AV15","v":"D/C"},{"$f":"'WPS Rating Factors'!AW15","v":"D/C"},{"$f":"'WPS Rating Factors'!AX15","v":"D/C"},{"$f":"'WPS Rating Factors'!AY15","v":"D/C"},{"$f":"'WPS Rating Factors'!BA15","v":"$0 preventive, D/C all others"},null,{"$f":"'WPS Rating Factors'!BC15","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[null,"Optional Dental Plan",null,null,"Annual Maximum Benefit",null,"Annual Deductible",null,"Diagnostic & Preventive Care",null,null,null,"Restorative Services",null,"Monthly Rate"]
[null,"(select plan for Brochure)"]
[]
[]
[null,{"$f":"HYPERLINK('WPS Tables'!O9,'WPS Tables'!N9)","v":"Delta Dental PPO Individual Plan"},null,null,"$1,200 per person",null,"$50 per person",null,"20% Coinsurance after Deductible",null,null,null,"50% after Deductible",null,{"$f":"SUM('WPS Rating Factors'!CS16:CU16)","v":0}]
[]
[]
[null,"D/C = Deductible & Coinsurance, PCP = Primary Care Practitioner"]
[]
[null,"Premium estimates are based on the information you have provided. Actual rates will be based on the information provided in your signed application."]
[]
[null,"1Family deductibles and out-of-pocket limits are 2x the individual amounts."]
[]
[]
[null,"2The catastrophic plan is only available to people under age 30 or those who qualify for a hardship exemption from the Federally Facilitated Marketplace (FFM)."]

{"sheet":"WPS Tables","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":true,"merged":[[3,1,3,2],[3,5,3,6],[3,8,3,9],[9,5,9,6],[9,8,9,9]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"On Exchange Link","https://my.wpshealth.com/en/Individual/healthplanhome?WebsiteId=b5bgurh&state=pjn2yxr&producttype=tvewa9w"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Off Exchange Link","https://my.wpshealth.com/en/Individual/healthplanhome?WebsiteId=b5bgurh&state=pjn2yxr&producttype=tvewa9w"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTE: These plan names are supposed to have \"| Statewide Network\" at the end, but do to size constraints, im leaving that off and putting it in the title of the categorey"]
[null,"WPS County Selection",null,null,null,"Spouse Selection",null,null,"App. Tobacco",null,null,null,null,"WPS PPO Bronze $6,500 with 3 Free PCP Visits","https://www.wpshealth.com/resources/sbc/files/2023/81974WI1880048-00.pdf"]
[null,null,null,null,null,"Indicator",{"$f":"IF('WPS Quote'!D20=G6,1,IF('WPS Quote'!D20=G7,2,3))","v":1},null,"Indicator",{"$f":"IF('WPS Quote'!E28=J6,1,IF('WPS Quote'!E28=J7,2,3))","v":1},null,null,null,"WPS PPO Bronze $9,450","https://www.wpshealth.com/resources/sbc/files/2024/81974WI1880030-00.pdf"]
[null,"Oconto",2,null,null,1,null,null,1,null,null,null,null,"WPS PPO Catastrophic $9,100 with 3 Free PCP Visits","https://www.wpshealth.com/resources/sbc/files/2023/81974WI1880044-00.pdf"]
[null,null,null,null,null,2,"No",null,2,"No",null,null,null,"WPS PPO HDHP Bronze $6,000","https://www.wpshealth.com/resources/sbc/files/2023/81974WI1880042-00.pdf"]
[null,null,null,null,null,3,"Yes",null,3,"Yes",null,null,null,"WPS PPO HDHP Bronze $7,500","https://www.wpshealth.com/resources/sbc/files/2023/81974WI1880049-00.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Delta Dental PPO Individual Plan","https://secure.wpsic.com/sales-materials/files/33873_2023-wps-hi-hp-delta-dental-rate-sheet.pdf"]
[null,null,null,null,null,"Dependent Sel.",null,null,"Spouse Tabacco"]
[null,null,null,null,null,1,null,null,"Indicator",{"$f":"IF('WPS Quote'!E30=J12,1,IF('WPS Quote'!E30=J13,2,3))","v":1}]
[null,null,null,null,null,2,0,null,1]
[null,null,null,null,null,3,1,null,2,"No"]
[null,null,null,null,null,4,2,null,3,"Yes"]
[null,null,null,null,null,5,3]
[null,null,null,null,null,6,4,null,"Under Age 26?"]
[null,null,null,null,null,7,5,null,"Eff Date",{"$f":"DATE(YEAR('WPS Quote'!I18),MONTH('WPS Quote'!I18),DAY('WPS Quote'!I18))","v":"00:00:00"}]
[null,null,null,null,null,8,6,null,"Age 26",{"$f":"EDATE(DATE(YEAR('WPS Quote'!I18),MONTH('WPS Quote'!I18),DAY('WPS Quote'!I18)),-312)","v":{"$error":"#NUM!"}}]
[null,null,null,null,null,9,7]
[null,null,null,null,null,10,8]
[null,null,null,null,null,11,9,null,"Count of Dependents"]
[null,null,null,null,null,12,10,null,{"$f":"COUNT('WPS Quote'!G28,'WPS Quote'!G30,'WPS Quote'!I28,'WPS Quote'!I30,'WPS Quote'!L28,'WPS Quote'!L30,'WPS Quote'!N30,'WPS Quote'!N28)","v":0},{"$f":"'WPS Quote'!D22","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,"Under Age 18?"]
[null,null,null,null,null,null,null,null,"Eff Date",{"$f":"DATE(YEAR('WPS Quote'!I18),MONTH('WPS Quote'!I18),DAY('WPS Quote'!I18))","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,"Age 18",{"$f":"EDATE(DATE(YEAR('WPS Quote'!I18),MONTH('WPS Quote'!I18),DAY('WPS Quote'!I18)),-216)","v":{"$error":"#NUM!"}}]

{"sheet":"WPS Rating Factors","index":2,"n_rows":93,"n_cols":117,"rows_kept":93,"cut":false,"hidden":true,"merged":[[5,56,5,66],[5,67,5,77],[5,78,5,88],[32,98,32,99],[33,98,33,99]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Eff. Date",{"$f":"'WPS Quote'!I18","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"the formula starting in",null,null,"Rate Calc Date"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"row 2 column CS used to"]
[null,null,null,null,null,null,null,null,"On/Off",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"be for plan changes, no ",null,null,"Member","Applicant","Spouse","Dep. 1","Dep. 2","Dep. 3","Dep. 4","Dep. 5","Dep. 6","Dep. 7","Dep. 8","Dep. 9","Dep. 10",null,null,null,null,null,"TOTAL"]
[null,null,null,null,null,null,null,"PPO",{"$f":"VLOOKUP('WPS Quote'!I20,'WPS Tables'!$B$6:$C$28,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Original",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"longer needed since",null,null,"DOB",{"$f":"IF('WPS Quote'!C28=\"\",\"\",'WPS Quote'!C28)","v":""},{"$f":"IF('WPS Quote'!C30=\"\",\"\",'WPS Quote'!C30)","v":""},{"$f":"IF('WPS Quote'!G28=\"\",\"\",'WPS Quote'!G28)","v":""},{"$f":"IF('WPS Quote'!G30=\"\",\"\",'WPS Quote'!G30)","v":""},{"$f":"IF('WPS Quote'!I28=\"\",\"\",'WPS Quote'!I28)","v":""},{"$f":"IF('WPS Quote'!I30=\"\",\"\",'WPS Quote'!I30)","v":""},{"$f":"IF('WPS Quote'!L28=\"\",\"\",'WPS Quote'!L28)","v":""},{"$f":"IF('WPS Quote'!L30=\"\",\"\",'WPS Quote'!L30)","v":""},{"$f":"IF('WPS Quote'!N28=\"\",\"\",'WPS Quote'!N28)","v":""},{"$f":"IF('WPS Quote'!N30=\"\",\"\",'WPS Quote'!N30)","v":""},{"$f":"IF('WPS Quote'!T28=\"\",\"\",'WPS Quote'!T28)","v":""},{"$f":"IF('WPS Quote'!T30=\"\",\"\",'WPS Quote'!T30)","v":""},null,null,null,null,null,null,null,null,"Value of the"]
[null,null,null,"Age","Tobacco",null,null,"HDHP",2,null,null,null,null,null,null,"PPO",1,null,null,"Plan Order",null,null,null,"Aspirus Arise","ThedaCare","ThedaCare","ThedaCare","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora","Aurora",null,null,null,null,null,null,null,null,"Retail","PCP","SPC","ER",null,null,"POS",null,null,"Poverty Level 101-150",null,null,null,null,null,null,null,null,null,null,"Poverty Level 151%-200%",null,null,null,null,null,null,null,null,null,null,"Poverty Level 201%-250%",null,null,null,null,null,null,null,null,null,null,null,null,null,"facets rates",null,null,"Age",{"$f":"IF(MONTH(IF(CS2=\"\",$CS$1,CS2))<MONTH(CS5),YEAR(IF(CS2=\"\",$CS$1,CS2))-YEAR(CS5)-1,IF(MONTH(IF(CS2=\"\",$CS$1,CS2))>MONTH(CS5),YEAR(IF(CS2=\"\",$CS$1,CS2))-YEAR(CS5),IF(DAY(IF(CS2=\"\",$CS$1,CS2))<DAY(CS5),YEAR(IF(CS2=\"\",$CS$1,CS2))-YEAR(CS5)-1,YEAR(IF(CS2=\"\",$CS$1,CS2))-YEAR(CS5))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,null,null,null,null,null,null,"For Subsidy Calculator","Smoker Surcharge"]
["Index Rate",null,"Age","Factor","Factor",null,null,"County","OCI Region","Factor","Network 1","Network 2","Network 3",null,null,"Network","HMO Factor","POS Factor",null,"Plan Number","AV Value","Plan Name","HIOS #","Pricing Value","Plan Name","HIOS #","Pricing Value","Plan Name","HIOS #","Pricing Value","Plan Name","HIOS #","Pricing Value","Plan Name","HIOS #","Pricing Value","Plan Name","HIOS #","Pricing Value","Plan Type","Metal","Deductible (IN)","Deductible (OUT)","Coins. (IN)","Coins. (OUT)","OOP Max (IN)","OOP Max (OUT)","Copay","Copay","Copay","Copay","Free\nPCP Visits","Prev/Gen-Prf/Gen-Oth/Brand-Prf/Brand-Oth/Spcl","Factor","Rate","Metal","Deductible (IN)","Deductible (OUT)","Coins. (IN)","Coins. (OUT)","OOP Max (IN)","OOP Max (OUT)","Retail","PCP","SPC","ER","Prescription Plan\nPreventive/Generic/Preferred/\nNon-Preferred/Specialty","Deductible (IN)","Deductible (OUT)","Coins. (IN)","Coins. (OUT)","OOP Max (IN)","OOP Max (OUT)","Retail","PCP","SPC","ER","Prescription Plan\nPreventive/Generic/Preferred/\nNon-Preferred/Specialty","Deductible (IN)","Deductible (OUT)","Coins. (IN)","Coins. (OUT)","OOP Max (IN)","OOP Max (OUT)","Retail","PCP","SPC","ER","Prescription Plan\nPreventive/Generic/Preferred/\nNon-Preferred/Specialty",null,null,null,null,null,null,"Tobacco",{"$f":"IF('WPS Quote'!E28=\"Yes\",3,1)","v":1},{"$f":"IF('WPS Quote'!E30=\"Yes\",3,1)","v":1},1,1,1,1,1,1,1,1,1,1,null,null,null,null,null,null,null,"Always Assume No Smoker","and children under 19"]
[966.52,null,0,0.76500000000000001,1,null,1,null,null,0,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,2,"Select",0,null,null,15,null,"WPS PPO Bronze $6,500 with 3 Free PCP Visits | Statewide Network","81974WI1880048",null,"ThedaCare HMO 6000","84670WI1250101",0.49209999999999998,"Aurora HMO 6000","84670WI1250107",0.49209999999999998,"Aurora and ThedaCare HMO 6000","84670WI1250117",5681.25,"Aurora and Bellin HMO 6000","84670WI1250127",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6000","84670WI1250137",{"$error":"#VALUE!"},"PPO","Bronze",6500,13000,0.2,0.5,9100,23000,"D/C","3 Free","D/C","D/C",3,"$0 preventive, D/C all others",0.52449999999999997,{"$f":"ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$10,2)+ROUND(ROUND(ROUND(ROUND(BB8*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$10,2)","v":{"$error":"#N/A"}},"Bronze",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,"Over 21 Value",{"$f":"IF(CS5=\"\",0,VLOOKUP(CS6,$C$8:$E$58,2)*IF(CS7=3,VLOOKUP(CS6,$C$8:$E$58,3),1))","v":0},{"$f":"IF(CT5=\"\",0,VLOOKUP(CT6,$C$8:$E$58,2)*IF(CT7=3,VLOOKUP(CT6,$C$8:$E$58,3),1))","v":0},{"$f":"IF(CU5=\"\",0,VLOOKUP(CU6,$C$8:$E$58,2)*IF(CU7=3,VLOOKUP(CU6,$C$8:$E$58,3),1)*IF(CU6<21,0,1))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(CS8:DD8)","v":0},null,{"$f":"ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CS$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CT$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CU$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CV$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CW$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CX$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CY$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CZ$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DA$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DB$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DC$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DD$12,2)+ROUND(ROUND(ROUND(ROUND(BB8*$Q$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$D$8,2)*$DJ$13","v":{"$error":"#N/A"}},{"$f":"BC8-DL8","v":{"$error":"#N/A"}}]
[null,null,15,0.83299999999999996,1,null,2,"Oconto",16,0.96299999999999997,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,1,{"$f":"VLOOKUP(I5,$G$8:$M$80,5,FALSE)","v":{"$error":"#N/A"}},0.93500000000000005,1,null,14,null,"WPS PPO Bronze $9,450 | Statewide Network","81974WI1880030",null,"ThedaCare HMO 6850","84670WI1250102",0.46560000000000001,"Aurora HMO 6850","84670WI1250108",0.46560000000000001,"Aurora and ThedaCare HMO 6850","84670WI1250118",6499.35,"Aurora and Bellin HMO 6850","84670WI1250128",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6850","84670WI1250138",{"$error":"#VALUE!"},"PPO","Bronze",9450,18900,0,0.3,9450,24900,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.49270000000000003,{"$f":"ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$10,2)+ROUND(ROUND(ROUND(ROUND(BB9*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$10,2)","v":{"$error":"#N/A"}},"Bronze",6250,"-",0.2,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",6250,"-",0.2,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",6250,"-",0.2,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,"21 and Under Value",{"$f":"IF(CS5=\"\",0,IF(CS6<21,1,0))","v":0},{"$f":"IF(CT5=\"\",0,IF(CT6<21,1,0))","v":0},{"$f":"IF(CU5=\"\",0,IF(CU6<21,VLOOKUP(CU6,$C$8:$D$58,2),0))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"IF(SUM(CS9:DD9)>3,3,SUM(CS9:DD9))","v":0},null,{"$error":"#N/A"},{"$f":"BC9-DL9","v":{"$error":"#N/A"}}]
[null,null,16,0.85899999999999999,1,null,3,"Barron",8,0.89300000000000002,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,3,{"$f":"VLOOKUP(I5,$G$8:$M$80,6,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(#REF!=\"Arise\",0.959,IF(#REF!=\"Aspirus Arise\",0.909,IF(#REF!=\"Arise Metro\",0.909,IF(#REF!=\"Southern\",0.93,IF(#REF!=\"Healthy U\",0.93,0)))))","v":{"$error":"#REF!"}},null,null,13,null,"HMO Silver 7000","86584WI0010001",null,"ThedaCare HMO 5000","84670WI1250100",{"$f":"ROUND(BB10*0.909,4)","v":0.57150000000000001},"Aurora HMO 5000","84670WI1250106",{"$f":"ROUND(BB10*0.909,4)","v":0.57150000000000001},"Aurora and ThedaCare HMO 5000","84670WI1250116",{"$f":"ROUND(BE10*0.909,4)","v":0},"Aurora and Bellin HMO 5000","84670WI1250126",{"$f":"ROUND(BH10*0.909,4)","v":{"$error":"#VALUE!"}},"ProHealth and Aurora HMO 5000","84670WI1250136",{"$f":"ROUND(BK10*0.909,4)","v":{"$error":"#VALUE!"}},"HMO","Silver",7000,"-",0,"-",7000,"-","$0/$10",30,60,250,0,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",0.62870000000000004,{"$f":"ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB10*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$D$8,2)*$DJ$9","v":{"$error":"#N/A"}},"Silver",0,"-",0,"-",400,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $400",400,"-",0,"-",1400,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",3000,"-",0,"-",5000,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",null,null,null,null,null,null,null,null,null,{"$f":"LARGE(CU9:DD9,1)","v":0},{"$f":"LARGE(CU9:DD9,2)","v":0},{"$f":"LARGE(CU9:DD9,3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(DJ8:DJ9)","v":0},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,17,0.88500000000000001,1,null,4,"Bayfield",5,0.79300000000000004,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,4,{"$f":"VLOOKUP(I5,$G$8:$M$80,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(#REF!=\"Arise\",0.959,IF(#REF!=\"Aspirus Arise\",0.909,IF(#REF!=\"Arise Metro\",0.909,IF(#REF!=\"Southern\",0.93,IF(#REF!=\"Healthy U\",0.93,0)))))","v":{"$error":"#REF!"}},null,null,9,null,"HMO Silver 4500","86584WI0010002",null,"ThedaCare HMO 4000","84670WI1250015",0.59360000000000002,"Aurora HMO 4000","84670WI1250054",0.59360000000000002,"Aurora and ThedaCare HMO 4000","84670WI1250109",0,"Aurora and Bellin HMO 4000","84670WI1250119",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 4000","84670WI1250129",{"$error":"#VALUE!"},"HMO","Silver",4500,"-",0.3,"-",7150,"-","$0/$10",30,60,250,0,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",0.65300000000000002,{"$f":"ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB11*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$D$8,2)*$DJ$9","v":{"$error":"#N/A"}},"Silver",0,"-",0,"-",400,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $400",400,"-",0,"-",1400,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",3000,"-",0,"-",5000,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,18,0.91300000000000003,1,null,5,"Brown",16,0.96299999999999997,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,12,null,"HMO Gold 2000","86584WI0010007",null,"ThedaCare HMO 1500","84670WI1250007",0.89049999999999996,"Aurora HMO 1500","84670WI1250051",0.89049999999999996,"Aurora and ThedaCare HMO 1500","84670WI1250110",1818,"Aurora and Bellin HMO 1500","84670WI1250120",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 1500","84670WI1250130",{"$error":"#VALUE!"},"HMO","Gold",2000,"-",0.2,"-",3850,"-","$0/$10",30,60,250,0,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",0.97970000000000002,{"$f":"ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB12*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$D$8,2)*$DJ$9","v":{"$error":"#N/A"}},"Gold",2000,"-",0.2,"-",3850,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",2000,"-",0.2,"-",3850,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",2000,"-",0.2,"-",3850,"-","$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",null,null,null,null,null,null,"Over 21 Value",{"$f":"IF(CS5=\"\",0,VLOOKUP(CS6,$C$8:$E$53,2)*IF(CS6<21,0,1))","v":0},{"$f":"IF(CT5=\"\",0,VLOOKUP(CT6,$C$8:$E$53,2)*IF(CT6<21,0,1))","v":0},{"$f":"IF(CU5=\"\",0,VLOOKUP(CU6,$C$8:$E$53,2)*IF(CU6<21,0,1))","v":0},0,0,0,{"$f":"IF(CY5=\"\",0,VLOOKUP(CY6,$C$8:$E$53,2)*IF(CY6<21,0,1))","v":0},{"$f":"IF(CZ5=\"\",0,VLOOKUP(CZ6,$C$8:$E$53,2)*IF(CZ6<21,0,1))","v":0},{"$f":"IF(DA5=\"\",0,VLOOKUP(DA6,$C$8:$E$53,2)*IF(DA6<21,0,1))","v":0},0,0,0,null,null,null,null,null,{"$f":"SUM(CS12:DD12)","v":0},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,19,0.94099999999999995,1,null,6,"Buffalo",6,1.0289999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,8,null,"WPS PPO Catastrophic $9,100 with 3 Free PCP Visits | Statewide Network","81974WI1880044",null,"ThedaCare HMO 6850 Catastrophic","84670WI1250039",0.40110000000000001,"Aurora HMO 6850 Catastrophic","84670WI1250094",0.40110000000000001,"Aurora and ThedaCare HMO 6850 Catastrophic","84670WI1250111",6499.35,"Aurora and Bellin HMO 6850 Catastrophic","84670WI1250121",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6850 Catastrophic","84670WI1250131",{"$error":"#VALUE!"},"PPO","Catastrophic",9100,18200,0,0.3,9100,24200,"D/C","3 Free","D/C","D/C",3,"$0 preventive, D/C all others",0.4294,{"$f":"ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$10,2)+ROUND(ROUND(ROUND(ROUND(BB13*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$10,2)","v":{"$error":"#N/A"}},"Catastrophic",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",7150,"-",0,"-",7150,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,"21 and Under Value",{"$f":"IF(CS5=\"\",0,IF(AND(CS6<19,#REF!<3.0633),0,IF(CS6<21,1,0)))","v":0},{"$f":"IF(CT5=\"\",0,IF(AND(CT6<19,#REF!<3.0633),0,IF(CT6<21,1,0)))","v":0},{"$f":"IF(CU5=\"\",0,IF(AND(CU6<19,#REF!<3.0633),0,IF(CU6<21,1,0)))","v":0},{"$f":"IF(CV5=\"\",0,IF(AND(CV6<19,#REF!<3.0633),0,IF(CV6<21,1,0)))","v":0},{"$f":"IF(CW5=\"\",0,IF(AND(CW6<19,#REF!<3.0633),0,IF(CW6<21,1,0)))","v":0},{"$f":"IF(CX5=\"\",0,IF(AND(CX6<19,#REF!<3.0633),0,IF(CX6<21,1,0)))","v":0},{"$f":"IF(CY5=\"\",0,IF(AND(CY6<19,#REF!<3.0633),0,IF(CY6<21,1,0)))","v":0},{"$f":"IF(CZ5=\"\",0,IF(AND(CZ6<19,#REF!<3.0633),0,IF(CZ6<21,1,0)))","v":0},{"$f":"IF(DA5=\"\",0,IF(AND(DA6<19,#REF!<3.0633),0,IF(DA6<21,1,0)))","v":0},{"$f":"IF(DB5=\"\",0,IF(AND(DB6<19,#REF!<3.0633),0,IF(DB6<21,1,0)))","v":0},{"$f":"IF(DC5=\"\",0,IF(AND(DC6<19,#REF!<3.0633),0,IF(DC6<21,1,0)))","v":0},{"$f":"IF(DD5=\"\",0,IF(AND(DD6<19,#REF!<3.0633),0,IF(DD6<21,1,0)))","v":0},null,null,null,null,null,{"$f":"IF(SUM(CS13:DD13)>3,3,SUM(CS13:DD13))","v":0},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,20,0.97,1,null,7,"Burnett",5,0.79300000000000004,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,10,null,"WPS PPO HDHP Bronze $6,000 | Statewide Network","81974WI1880042",null,"ThedaCare HMO 5500 HDHP","84670WI1250036",0.47720000000000001,"Aurora HMO 5500 HDHP","84670WI1250091",0.47720000000000001,"Aurora and ThedaCare HMO 5500 HDHP","84670WI1250112",4999.5,"Aurora and Bellin HMO 5500 HDHP","84670WI1250122",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 5500 HDHP","84670WI1250132",{"$error":"#VALUE!"},"PPO HDHP","Bronze",6000,12000,0.3,0.5,7500,22000,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.51570000000000005,{"$f":"ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$10,2)+ROUND(ROUND(ROUND(ROUND(BB14*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$10,2)","v":{"$error":"#N/A"}},"Bronze",6550,"-",0,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",6550,"-",0,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",6550,"-",0,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,{"$f":"SUM(CS14:DD14)","v":0},"Under 19?",{"$f":"IF(CS5=\"\",0,IF(CS6<19,1,0))","v":0},{"$f":"IF(CT5=\"\",0,IF(CT6<19,1,0))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"SUM(DJ12:DJ13)","v":0},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,21,1,1,null,8,"Chippewa",4,0.86799999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,7,null,"WPS PPO HDHP Bronze $7,500 | Statewide Network","81974WI1880049",null,"ThedaCare HMO 6450 HDHP","84670WI1250034",0.47849999999999998,"Aurora HMO 6450 HDHP","84670WI1250090",0.47849999999999998,"Aurora and ThedaCare HMO 6450 HDHP","84670WI1250113",5953.95,"Aurora and Bellin HMO 6450 HDHP","84670WI1250123",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6450 HDHP","84670WI1250133",{"$error":"#VALUE!"},"PPO HDHP","Bronze",7500,15000,0,0.3,7500,21000,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.51339999999999997,{"$f":"ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CU$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CV$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CW$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CX$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CY$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$CZ$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DA$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DB$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DC$10,2)+ROUND(ROUND(ROUND(ROUND(BB15*1,4)*$A$8,2)*VLOOKUP($I$5,$G$9:$J$31,4,FALSE),2)*$DD$10,2)","v":{"$error":"#N/A"}},"Bronze",5500,"-",0.2,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",5500,"-",0.2,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",5500,"-",0.2,"-",6550,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,22,1,1,null,9,"Door",16,0.96299999999999997,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,11,null,"HMO HDHP Silver 2700","86584WI0010004",null,"ThedaCare HMO 3500 HDHP","84670WI1250029",0.5847,"Aurora HMO 3500 HDHP","84670WI1250084",0.5847,"Aurora and ThedaCare HMO 3500 HDHP","84670WI1250114",409.05,"Aurora and Bellin HMO 3500 HDHP","84670WI1250124",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 3500 HDHP","84670WI1250134",{"$error":"#VALUE!"},"HMO HDHP","Silver",2700,"-",0.2,"-",6550,"-","D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.64319999999999999,{"$f":"ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CS$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CT$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CU$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CV$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CW$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CX$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CY$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$CZ$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DA$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DB$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DC$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$DD$8,2)+ROUND(ROUND(ROUND(ROUND(BB16*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$28,4,FALSE),2)*$D$8,2)*$DJ$9","v":{"$error":"#N/A"}},"Silver",450,"-",0,"-",450,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",1350,"-",0,"-",1350,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",2000,"-",0.2,"-",4200,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,"Dental Rate",{"$f":"IF(ISERROR(CS6),0,VLOOKUP(CS6,$CQ$34:$CS$42,3))","v":0},{"$f":"IF(ISERROR(CT6),0,VLOOKUP(CT6,$CQ$34:$CS$42,3))","v":0},{"$f":"VLOOKUP(IF(ISERROR(CU6),0,1) + IF(ISERROR(CV6),0,1) + IF(ISERROR(CW6),0,1) + IF(ISERROR(CX6),0,1) + IF(ISERROR(CY6),0,1) + IF(ISERROR(CZ6),0,1) + IF(ISERROR(DA6),0,1) + IF(ISERROR(DB6),0,1),$CQ$44:$CS$47,3)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,23,1,1,null,10,"Douglas",5,0.79300000000000004,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,"HDHP",1,null,null,5,null,"HMO HDHP Silver 4000","86584WI0010010",null,"ThedaCare HMO 2600 HDHP","84670WI1250032",0.59060000000000001,"Aurora HMO 2600 HDHP","84670WI1250087",0.59060000000000001,"Aurora and ThedaCare HMO 2600 HDHP","84670WI1250115",409.05,"Aurora and Bellin HMO 2600 HDHP","84670WI1250125",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 2600 HDHP","84670WI1250135",{"$error":"#VALUE!"},"HMO HDHP","Silver",4000,"-",0,"-",4000,"-","D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.64970000000000006,{"$error":"#N/A"},"Silver",450,"-",0,"-",450,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",1350,"-",0,"-",1350,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",3250,"-",0,"-",3250,"-","D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,24,1,1,null,11,"Dunn",4,0.86799999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,"Network","Factor",null,null,4,null,"HMO STANDARD Bronze 6650","86584WI0010011",null,"ThedaCare 6850","84670WI1270102",0.48089999999999999,"Aurora 6850","84670WI1270108",0.48089999999999999,"Aurora and ThedaCare 6850","84670WI1270118",6044.85,"Aurora and Bellin 6850","84670WI1270128",{"$error":"#VALUE!"},"ProHealth and Aurora 6850","84670WI1270138",{"$error":"#VALUE!"},"HMO STANDARD","Bronze",6650,"-",0.5,"-",7150,"-","$45/(D/C)",45,"D/C","D/C",0,"0$/$35/$35/35%/40%/45%",0.52900000000000003,{"$error":"#N/A"},"Bronze",6650,"-",0.5,"-",7150,"-","$45/(D/C)",45,"D/C","D/C","0$/$35/$35/35%/40%/45%",6650,"-",0.5,"-",7150,"-","$45/(D/C)",45,"D/C","D/C","0$/$35/$35/35%/40%/45%",6650,"-",0.5,"-",7150,"-","$45/(D/C)",45,"D/C","D/C","0$/$35/$35/35%/40%/45%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,25,1.004,1,null,12,"Eau Claire",4,0.86799999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,1,"Arise",1,null,null,6,null,"HMO STANDARD Silver 3500","86584WI0010012",null,"ThedaCare 4000","84670WI1270015",0.58699999999999997,"Aurora 4000","84670WI1270054",0.58699999999999997,"Aurora and ThedaCare 4000","84670WI1270109",227.25,"Aurora and Bellin 4000","84670WI1270119",{"$error":"#VALUE!"},"ProHealth and Aurora 4000","84670WI1270129",{"$error":"#VALUE!"},"HMO STANDARD","Silver",3500,"-",0.2,"-",7150,"-","$30/$75",30,65,400,0,"$0/$15/$15/$50/$100/40%",0.64580000000000004,{"$error":"#N/A"},"Silver",250,"-",0.05,"-",1250,"-","$5/$25",5,15,100,"$0/$3/$3/$5/$10/25%",700,"-",0.2,"-",2000,"-","$10/$40",10,25,150,"$0/$5/$5/$25/$50/30%",3000,"-",0.2,"-",5700,"-","$30/$75",30,65,300,"$0/$10/$10/$50/$100/40%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,26,1.024,1,null,13,"Jackson",6,1.0289999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,2,{"$f":"VLOOKUP(I6,$G$8:$M$80,5,FALSE)","v":0},{"$f":"IF(#REF!=\"Statewide\",1,IF(#REF!=\"Western\",0.95,IF(#REF!=\"Aspirus\",0.84,IF(#REF!=\"Southern\",0.93,IF(#REF!=\"Healthy U\",0.93,0)))))","v":{"$error":"#REF!"}},null,null,2,null,"POS Silver 7150","84670WI1270143",null,"ThedaCare 5500 HDHP","84670WI1270036",0.46429999999999999,"Aurora 5500 HDHP","84670WI1270091",0.46429999999999999,"Aurora and ThedaCare 5500 HDHP","84670WI1270112",0,"Aurora and Bellin 5500 HDHP","84670WI1270122",0.2727,"ProHealth and Aurora 5500 HDHP","84670WI1270132",{"$error":"#VALUE!"},"POS","Bronze",7150,14300,0,0.3,7150,20300,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.51080000000000003,{"$error":"#N/A"},"Silver",0,14000,0,0.3,400,20000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $400",400,14000,0,0.3,1400,20000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",3000,14000,0,0.3,5000,20000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",null,null,null,null,null,null,"HDHP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CS$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CT$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CU$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CV$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CW$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CX$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CY$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CZ$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DA$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DB$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DC$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DD$12,2)+ROUND(ROUND(ROUND(ROUND(BB20*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$D$8,2)*$DJ$13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,27,1.048,1,null,14,"La Crosse",6,1.0289999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,3,{"$f":"VLOOKUP(I6,$G$8:$M$80,6,FALSE)","v":""},{"$f":"IF(#REF!=\"Statewide\",1,IF(#REF!=\"Western\",0.95,IF(#REF!=\"Aspirus\",0.84,IF(#REF!=\"Southern\",0.93,IF(#REF!=\"Healthy U\",0.93,0)))))","v":{"$error":"#REF!"}},null,null,3,null,"POS Silver 4500","86584WI0020002",null,"ThedaCare 2600 HDHP","84670WI1270032",0.59360000000000002,"Aurora 2600 HDHP","84670WI1270087",0.59360000000000002,"Aurora and ThedaCare 2600 HDHP","84670WI1270115",0,"Aurora and Bellin 2600 HDHP","84670WI1270125",0.45450000000000002,"ProHealth and Aurora 2600 HDHP","84670WI1270135",{"$error":"#VALUE!"},"POS","Silver",4500,9000,0.3,0.5,7150,19000,"$0/$10",30,60,250,0,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",0.65300000000000002,{"$error":"#N/A"},"Silver",0,9000,0,0.5,400,19000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $400",400,9000,0,0.5,1400,19000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",3000,9000,0,0.5,5000,19000,"$0/$10",30,60,250,"$0 / $0 / $20 / $50 / $75 / 50% to $1000",null,null,null,null,null,null,"Eff. Date",{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CS$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CT$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CU$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CV$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CW$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CX$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CY$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CZ$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DA$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DB$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DC$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DD$12,2)+ROUND(ROUND(ROUND(ROUND(BB21*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$D$8,2)*$DJ$13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,28,1.087,1,null,15,"Monroe",6,1.0289999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,4,{"$f":"VLOOKUP(I6,$G$8:$M$80,7,FALSE)","v":""},{"$f":"IF(#REF!=\"Statewide\",1,IF(#REF!=\"Western\",0.95,IF(#REF!=\"Aspirus\",0.84,IF(#REF!=\"Southern\",0.93,IF(#REF!=\"Healthy U\",0.93,0)))))","v":{"$error":"#REF!"}},null,null,1,null,"POS HDHP Bronze 5500","84670WI1270145",null,"Aspirus Arise Platinum HMO 250","84670WI1250043",0.48259999999999997,"Arise Metro Platinum HMO 250","84670WI1250049",0.48259999999999997,"Arise Metro Platinum HMO 250","84670WI1250049",4999.5,"Arise Metro Platinum HMO 250","84670WI1250049",0.45450000000000002,"Arise Metro Platinum HMO 250","84670WI1250049",{"$error":"#VALUE!"},"POS HDHP","Bronze",5500,11000,0.2,0.5,6550,21000,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.53090000000000004,{"$error":"#N/A"},"Bronze",5500,11000,0.2,0.5,6550,21000,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",5500,11000,0.2,0.5,6550,21000,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",5500,11000,0.2,0.5,6550,21000,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,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":"ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CS$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CT$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CU$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CV$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CW$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CX$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CY$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CZ$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DA$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DB$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DC$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DD$12,2)+ROUND(ROUND(ROUND(ROUND(BB22*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$D$8,2)*$DJ$13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,29,1.119,1,null,16,"Oconto",16,0.96299999999999997,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,16,null,"POS HDHP Silver 2700","86584WI0020004",null,"Aspirus Arise Catastrophic HMO 6600","84670WI1250093",0.58819999999999995,"Arise Metro Catastrophic HMO 6600","84670WI1250094",0.58819999999999995,"Arise Metro Catastrophic HMO 6600","84670WI1250094",409.05,"Arise Metro Catastrophic HMO 6600","84670WI1250094",0.45450000000000002,"Arise Metro Catastrophic HMO 6600","84670WI1250094",{"$error":"#VALUE!"},"POS HDHP","Silver",2700,5400,0.2,0.5,6550,15400,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.64710000000000001,{"$error":"#N/A"},"Silver",450,5400,0,0.5,450,15400,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",1350,5400,0,0.5,1350,15400,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",2000,5400,0.2,0.5,4200,15400,"D/C","D/C","D/C","D/C","$0 preventive, D/C all others",null,null,null,null,null,null,"Member","Applicant","Spouse","Dep.<21","Dep. 1","Dep. 2","Dep. 3","Dep. 4","Dep. 5","Dep. 6",null,null,null,null,null,null,null,null,"TOTAL",null,{"$f":"ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CS$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CT$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CU$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CV$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CW$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CX$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CY$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$CZ$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DA$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DB$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DC$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$DD$12,2)+ROUND(ROUND(ROUND(ROUND(BB23*$R$9,4)*$A$8,2)*VLOOKUP($I$5,$G$10:$J$26,4,FALSE),2)*$D$8,2)*$DJ$13","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,30,1.135,1,null,17,"Pepin",4,0.86799999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,25,null,"HMO SE Bronze 7150","84670WI1250143",null,"Aspirus Arise Bronze HMO 5500 HSA","84670WI1250081",0,"Arise Metro Bronze HMO 5500 HSA","84670WI1250091",0,"Arise Metro Bronze HMO 5500 HSA","84670WI1250091",4999.5,"Arise Metro Bronze HMO 5500 HSA","84670WI1250091",{"$error":"#VALUE!"},"Arise Metro Bronze HMO 5500 HSA","84670WI1250091",{"$error":"#VALUE!"},"HMO","Bronze",5500,"-",0.8,"-",6450,"-","D/C","D/C","D/C","D/C",0,"D/C",null,{"$f":"ROUND($DJ$10*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$42,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$9:$Q$9,3,FALSE)*BB24,4),2),2)","v":{"$error":"#N/A"}},"Bronze",5500,"-",0.8,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",5500,"-",0.8,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",5500,"-",0.8,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,"DOB",{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(ISERROR(VALUE(#REF!)),0,IF(VALUE(#REF!)>3,3,#REF!))","v":0},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=\"\",\"\",#REF!)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($DJ$14*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$42,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$9:$Q$9,3,FALSE)*BB24,4),2),2)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,31,1.159,1,null,18,"Pierce",3,1.036,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,26,null,"HMO SE Catastrophic 7150","84670WI1250144",null,"Aspirus Arise Bronze HMO 6000 HSA","84670WI1250080",0,"Arise Metro Bronze HMO 6000 HSA","84670WI1250090",0,"Arise Metro Bronze HMO 6000 HSA","84670WI1250090",5454,"Arise Metro Bronze HMO 6000 HSA","84670WI1250090",{"$error":"#VALUE!"},"Arise Metro Bronze HMO 6000 HSA","84670WI1250090",{"$error":"#VALUE!"},"HMO","Bronze",6000,"-",1,"-",6000,"-","D/C","D/C","D/C","D/C",0,"D/C",null,{"$error":"#N/A"},"Bronze",6000,"-",1,"-",6000,"-","D/C","D/C","D/C","D/C","D/C",6000,"-",1,"-",6000,"-","D/C","D/C","D/C","D/C","D/C",6000,"-",1,"-",6000,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,"Age",{"$f":"IF(MONTH($CS$21)<MONTH(CS24),YEAR($CS$21)-YEAR(CS24)-1,IF(MONTH($CS$21)>MONTH(CS24),YEAR($CS$21)-YEAR(CS24),IF(DAY($CS$21)<DAY(CS24),YEAR($CS$21)-YEAR(CS24)-1,YEAR($CS$21)-YEAR(CS24))))","v":{"$error":"#REF!"}},{"$f":"IF(MONTH($CS$21)<MONTH(CT24),YEAR($CS$21)-YEAR(CT24)-1,IF(MONTH($CS$21)>MONTH(CT24),YEAR($CS$21)-YEAR(CT24),IF(DAY($CS$21)<DAY(CT24),YEAR($CS$21)-YEAR(CT24)-1,YEAR($CS$21)-YEAR(CT24))))","v":{"$error":"#REF!"}},"N/A",{"$f":"IF(MONTH($CS$21)<MONTH(CV24),YEAR($CS$21)-YEAR(CV24)-1,IF(MONTH($CS$21)>MONTH(CV24),YEAR($CS$21)-YEAR(CV24),IF(DAY($CS$21)<DAY(CV24),YEAR($CS$21)-YEAR(CV24)-1,YEAR($CS$21)-YEAR(CV24))))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,32,1.1830000000000001,1,null,19,"Polk",3,1.036,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,24,null,"HMO SE HDHP Bronze 5500","84670WI1250145",null,"Aspirus Arise Bronze HMO 3500 HSA","84670WI1250082",0,"Arise Metro Bronze HMO 3500 HSA","84670WI1250092",0,"Arise Metro Bronze HMO 3500 HSA","84670WI1250092",3181.5,"Arise Metro Bronze HMO 3500 HSA","84670WI1250092",{"$error":"#VALUE!"},"Arise Metro Bronze HMO 3500 HSA","84670WI1250092",{"$error":"#VALUE!"},"HMO HDHP","Bronze",3500,"-",0.7,"-",6450,"-","D/C","D/C","D/C","D/C",0,"D/C",null,{"$error":"#N/A"},"Bronze",3500,"-",0.7,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",3500,"-",0.7,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",3500,"-",0.7,"-",6450,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,"Tobacco",2,1,"N/A",1,1,1,1,1,1,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,33,1.198,1,null,20,"Rusk",8,0.89300000000000002,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,23,null,null,"84670WI1270143",null,"Aspirus Arise Silver HMO 3500 HSA","84670WI1250074",0,"Arise Metro Silver HMO 3500 HSA","84670WI1250084",0,"Arise Metro Silver HMO 3500 HSA","84670WI1250084",454.5,"Arise Metro Silver HMO 3500 HSA","84670WI1250084",{"$error":"#VALUE!"},"Arise Metro Silver HMO 3500 HSA","84670WI1250084",{"$error":"#VALUE!"},"POS","Silver",3500,"-",1,"-",3500,"-","D/C","D/C","D/C","D/C",0,"D/C",null,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",2800,"-",1,"-",2800,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,{"$f":"IF(CS24=\"\",0,VLOOKUP(CS25,$C$8:$E$53,2)*IF(CS26=3,VLOOKUP(CS25,$C$8:$E$53,3),1))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"CU24*D8","v":0},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,{"$f":"SUM(CS27:DA27)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,34,1.214,1,null,21,"Saint Croix",3,1.036,null,null,null,null,null,null,null,null,null,22,null,null,"84670WI1270145",null,"Aspirus Arise Silver HMO 3000-90 HSA","84670WI1250076",0,"Arise Metro Silver HMO 3000-90 HSA","84670WI1250086",0,"Arise Metro Silver HMO 3000-90 HSA","84670WI1250086",454.5,"Arise Metro Silver HMO 3000-90 HSA","84670WI1250086",{"$error":"#VALUE!"},"Arise Metro Silver HMO 3000-90 HSA","84670WI1250086",{"$error":"#VALUE!"},"POS HDHP","Silver",3000,"-",0.9,"-",4000,"-","D/C","D/C","D/C","D/C",0,"D/C",null,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",2800,"-",1,"-",2800,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,35,1.222,1.1000000000000001,null,22,"Sawyer",5,0.79300000000000004,null,null,null,null,null,"Tobacco",null,null,null,20,0.68400000000000005,"Arise Silver HMO 2500 HSA","84670WI1250032",{"$f":"ROUND(BB29*0.959,4)","v":0.64370000000000005},"Aspirus Arise Silver HMO 2500 HSA","84670WI1250077",0.61009999999999998,"Arise Metro Silver HMO 2500 HSA","84670WI1250087",0.61009999999999998,"Arise Metro Silver HMO 2500 HSA","84670WI1250087",454.5,"Arise Metro Silver HMO 2500 HSA","84670WI1250087",{"$error":"#VALUE!"},"Arise Metro Silver HMO 2500 HSA","84670WI1250087",{"$error":"#VALUE!"},"HMO","Silver",2500,"-",0.8,"-",4500,"-","D/C","D/C","D/C","D/C",0,"D/C",0.67120000000000002,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",2000,"-",0.8,"-",3000,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,{"$f":"IF(CS24=\"\",0,VLOOKUP(CS25,$C$8:$E$53,2))","v":{"$error":"#REF!"}},{"$f":"IF(CT24=\"\",0,VLOOKUP(CT25,$C$8:$E$53,2))","v":{"$error":"#REF!"}},{"$f":"CU24*D8","v":0},{"$f":"IF(CV24=\"\",0,VLOOKUP(CV25,$C$8:$E$53,2))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,{"$f":"SUM(CS29:DA29)","v":{"$error":"#REF!"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,36,1.23,1.105,null,23,"Trempealeau",6,1.0289999999999999,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,1,"Select",null,null,null,18,0.68700000000000006,"Arise Silver HMO 1400 HSA","84670WI1250033",0.65880000000000005,"Aspirus Arise Silver HMO 1400 HSA","84670WI1250078",0.62450000000000006,"Arise Metro Silver HMO 1400 HSA","84670WI1250088",0.62450000000000006,"Arise Metro Silver HMO 1400 HSA","84670WI1250088",454.5,"Arise Metro Silver HMO 1400 HSA","84670WI1250088",{"$error":"#VALUE!"},"Arise Metro Silver HMO 1400 HSA","84670WI1250088",{"$error":"#VALUE!"},"HMO","Silver",1400,"-",0.7,"-",6450,"-","D/C","D/C","D/C","D/C",0,"D/C",0.68700000000000006,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",1400,"-",0.8,"-",4500,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,37,1.238,1.1099999999999999,null,24,"Washburn",5,0.79300000000000004,null,{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,2,"No",null,null,null,21,0.71699999999999997,"Arise Silver HMO 3000-100 HSA","84670WI1250030",0.67959999999999998,"Aspirus Arise Silver HMO 3000-100 HSA","84670WI1250075",0.64419999999999999,"Arise Metro Silver HMO 3000-100 HSA","84670WI1250085",0.64419999999999999,"Arise Metro Silver HMO 3000-100 HSA","84670WI1250085",454.5,"Arise Metro Silver HMO 3000-100 HSA","84670WI1250085",{"$error":"#VALUE!"},"Arise Metro Silver HMO 3000-100 HSA","84670WI1250085",{"$error":"#VALUE!"},"HMO","Silver",3000,"-",1,"-",3000,"-","D/C","D/C","D/C","D/C",0,"D/C",0.7087,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",2650,"-",1,"-",2650,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,38,1.246,1.1149999999999998,null,23,"Sheboygan",11,0.90700000000000003,"About Health",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,3,"Yes",null,null,null,19,0.71399999999999997,"Arise Silver HMO 2000 HSA","84670WI1250042",0.68679999999999997,"Aspirus Arise Silver HMO 2000 HSA","84670WI1250079",0.65100000000000002,"Arise Metro Silver HMO 2000 HSA","84670WI1250089",0.65100000000000002,"Arise Metro Silver HMO 2000 HSA","84670WI1250089",454.5,"Arise Metro Silver HMO 2000 HSA","84670WI1250089",{"$error":"#VALUE!"},"Arise Metro Silver HMO 2000 HSA","84670WI1250089",{"$error":"#VALUE!"},"HMO","Silver",2000,"-",0.8,"-",4000,"-","D/C","D/C","D/C","D/C",0,"D/C",0.71619999999999995,{"$error":"#N/A"},"Silver",500,"-",1,"-",500,"-","D/C","D/C","D/C","D/C","D/C",1000,"-",1,"-",1000,"-","D/C","D/C","D/C","D/C","D/C",2000,"-",0.8,"-",3000,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,39,1.262,1.1199999999999997,null,24,"Walworth",14,0.95799999999999996,"About Health",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,null,null,null,null,17,0.78800000000000003,"Arise Gold HMO 2000 HSA","84670WI1250028",0.79459999999999997,"Aspirus Arise Gold HMO 2000 HSA","84670WI1250073",0.75319999999999998,"Arise Metro Gold HMO 2000 HSA","84670WI1250083",0.75319999999999998,"Arise Metro Gold HMO 2000 HSA","84670WI1250083",1818,"Arise Metro Gold HMO 2000 HSA","84670WI1250083",{"$error":"#VALUE!"},"Arise Metro Gold HMO 2000 HSA","84670WI1250083",{"$error":"#VALUE!"},"HMO","Gold",2000,"-",1,"-",2000,"-","D/C","D/C","D/C","D/C",0,"D/C",0.8286,{"$error":"#N/A"},"Gold",2000,"-",1,"-",2000,"-","D/C","D/C","D/C","D/C","D/C",2000,"-",1,"-",2000,"-","D/C","D/C","D/C","D/C","D/C",2000,"-",1,"-",2000,"-","D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,40,1.278,1.1249999999999996,null,25,"Washington",12,0.98,"About Health",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,"PPO",1,null,null,32,0.61299999999999999,"Arise Bronze POS 5000","84670WI1270026",{"$f":"BB34","v":0.58499999999999996},"Aspirus Arise Bronze POS 5000","84670WI1270068",{"$f":"BB34","v":0.58499999999999996},"Arise Metro Bronze POS 5000","84670WI1270071",{"$f":"BB34","v":0.58499999999999996},"Arise Metro Bronze POS 5000","84670WI1270071",{"$f":"BE34","v":5000},"Arise Metro Bronze POS 5000","84670WI1270071",{"$f":"BH34","v":0.6},"Arise Metro Bronze POS 5000","84670WI1270071",{"$f":"BK34","v":"D/C"},"POS","Bronze",5000,10000,0.8,0.6,6600,18000,"D/C","D/C","D/C","D/C",3,"D/C",0.58499999999999996,{"$f":"ROUND($DJ$10*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$42,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$9:$R$9,4,FALSE)*BB34,4),2),2)","v":{"$error":"#N/A"}},"Bronze",5000,10000,0.8,0.6,6600,18000,"D/C","D/C","D/C","D/C","D/C",5000,10000,0.8,0.6,6600,18000,"D/C","D/C","D/C","D/C","D/C",5000,10000,0.8,0.6,6600,18000,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,-10,"Under 30",23.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND($DJ$14*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$42,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$9:$R$9,4,FALSE)*BB34,4),2),2)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,41,1.302,1.1299999999999994,null,26,"Waukesha",12,0.98,"About Health",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,"HDHP",1,null,null,30,0.68,"Arise Silver POS 4000","84670WI1270015",0.64090000000000003,"Aspirus Arise Silver POS 4000","84670WI1270048",0.64090000000000003,"Arise Metro Silver POS 4000","84670WI1270054",0.64090000000000003,"Arise Metro Silver POS 4000","84670WI1270054",250,"Arise Metro Silver POS 4000","84670WI1270054",0.5,"Arise Metro Silver POS 4000","84670WI1270054",10,"POS","Silver",4000,8000,0.7,0.5,6600,18000,10,30,60,200,0,"$20/$50/$75/25% to $500",0.64090000000000003,{"$error":"#N/A"},"Silver",250,8000,1,0.5,500,18000,10,20,40,100,"$10/$35/$60/25% to $500",500,8000,1,0.5,1500,18000,10,25,50,150,"$15/$40/$65/25% to $500",1500,8000,1,0.5,5000,18000,10,30,60,200,"$20/$50/$75/25% to $500",null,null,null,null,null,30,"30 - 34",27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,42,1.325,1.1349999999999993,null,27,"Portage",10,0.83199999999999996,"Aspirus Arise",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,null,"Under 21",null,null,null,31,0.7,"Arise Silver POS 2500","84670WI1270022",0.69520000000000004,"Aspirus Arise Silver POS 2500","84670WI1270060",0.69520000000000004,"Arise Metro Silver POS 2500","84670WI1270066",0.69520000000000004,"Arise Metro Silver POS 2500","84670WI1270066",250,"Arise Metro Silver POS 2500","84670WI1270066",0.5,"Arise Metro Silver POS 2500","84670WI1270066","D/C","POS","Silver",2500,5000,0.7,0.5,5000,15000,"D/C","D/C","D/C","D/C",3,"$20/$50/$75/25% to $500",0.69520000000000004,{"$error":"#N/A"},"Silver",250,5000,1,0.5,500,15000,"D/C","D/C","D/C","D/C","$10/$35/$60/25% to $500",500,5000,1,0.5,1500,15000,"D/C","D/C","D/C","D/C","$15/$40/$65/25% to $500",1500,5000,1,0.5,5000,15000,"D/C","D/C","D/C","D/C","$20/$50/$75/25% to $500",null,null,null,null,null,35,"35 - 39",28.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,43,1.357,1.1399999999999992,null,28,"Price",8,0.871,"Aspirus Arise",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,1,"Select",0,null,null,29,0.71099999999999997,"Arise Silver POS 2000","84670WI1270014",0.7147,"Aspirus Arise Silver POS 2000","84670WI1270047",0.7147,"Arise Metro Silver POS 2000","84670WI1270053",0.7147,"Arise Metro Silver POS 2000","84670WI1270053",250,"Arise Metro Silver POS 2000","84670WI1270053",0.6,"Arise Metro Silver POS 2000","84670WI1270053",10,"POS","Silver",2000,4000,0.8,0.6,6600,12000,10,30,60,200,0,"$20/$50/$75/25% to $500",0.7147,{"$error":"#N/A"},"Silver",250,4000,1,0.6,500,12000,10,20,40,100,"$10/$35/$60/25% to $500",500,4000,1,0.6,1500,12000,10,25,50,150,"$15/$40/$65/25% to $500",1500,4000,1,0.6,6600,12000,10,30,60,200,"$20/$50/$75/25% to $500",null,null,null,null,null,40,"40 - 44",30.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,44,1.397,1.1449999999999991,null,29,"Racine",9,1.069,"Aurora",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,2,0,0,null,null,28,0.81699999999999995,"Arise Gold POS 1000","84670WI1270007",0.90080000000000005,"Aspirus Arise Gold POS 1000","84670WI1270045",0.90080000000000005,"Arise Metro Gold POS 1000","84670WI1270051",0.90080000000000005,"Arise Metro Gold POS 1000","84670WI1270051",1000,"Arise Metro Gold POS 1000","84670WI1270051",0.6,"Arise Metro Gold POS 1000","84670WI1270051",10,"POS","Gold",1000,2000,0.8,0.6,2500,10000,10,25,50,150,0,"$15/$40/$65/25% to $500",0.90080000000000005,{"$error":"#N/A"},"Gold",1000,2000,0.8,0.6,2500,10000,10,25,50,150,"$15/$40/$65/25% to $500",1000,2000,0.8,0.6,2500,10000,10,25,50,150,"$15/$40/$65/25% to $500",1000,2000,0.8,0.6,2500,10000,10,25,50,150,"$15/$40/$65/25% to $500",null,null,null,null,null,45,"45 - 49",34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,45,1.444,1.149999999999999,null,30,"Shawano",16,0.91800000000000004,"ThedaCare",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,3,1,1,null,null,27,0.88900000000000001,"Arise Platinum POS 250","84670WI1270001",1.2447999999999999,"Aspirus Arise Platinum POS 250","84670WI1270043",1.2447999999999999,"Arise Metro Platinum POS 250","84670WI1270049",1.2447999999999999,"Arise Metro Platinum POS 250","84670WI1270049",250,"Arise Metro Platinum POS 250","84670WI1270049",0.8,"Arise Metro Platinum POS 250","84670WI1270049",10,"POS","Platinum",250,500,1,0.8,1250,4500,10,20,40,150,0,"$10/$35/$60/25% to $500",1.2447999999999999,{"$error":"#N/A"},"Platinum",250,500,1,0.8,1250,4500,10,20,40,150,"$10/$35/$60/25% to $500",250,500,1,0.8,1250,4500,10,20,40,150,"$10/$35/$60/25% to $500",250,500,1,0.8,1250,4500,10,20,40,150,"$10/$35/$60/25% to $500",null,null,null,null,null,50,"50 - 54",36.299999999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,46,1.5,1.1549999999999989,null,31,"Sheboygan",11,0.88500000000000001,"Aurora",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},null,4,2,2,null,null,33,0.49199999999999999,"Arise Catastrophic POS 6600","84670WI1270039",0.45040000000000002,"Aspirus Arise Catastrophic POS 6600","84670WI1270093",0.45040000000000002,"Arise Metro Catastrophic POS 6600","84670WI1270094",0.45040000000000002,"Arise Metro Catastrophic POS 6600","84670WI1270094",6600,"Arise Metro Catastrophic POS 6600","84670WI1270094",0.8,"Arise Metro Catastrophic POS 6600","84670WI1270094","D/C","POS","Catastrophic",6600,13200,1,0.8,6600,17200,"D/C","D/C","D/C","D/C",3,"D/C",0.45040000000000002,{"$error":"#N/A"},"Catastrophic",6600,13200,1,0.8,6600,17200,"D/C","D/C","D/C","D/C","D/C",6600,13200,1,0.8,6600,17200,"D/C","D/C","D/C","D/C","D/C",6600,13200,1,0.8,6600,17200,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,55,"55 - 59",38.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,47,1.5629999999999999,1.1599999999999988,null,32,"Taylor",8,0.871,"Aspirus Arise",null,null,null,5,"3 +",3,null,null,37,0.58299999999999996,"Arise Bronze POS 5500 HSA","84670WI1270036",{"$f":"BB41","v":0.53090000000000004},"Aspirus Arise Bronze POS 5500 HSA","84670WI1270081",{"$f":"BB41","v":0.53090000000000004},"Arise Metro Bronze POS 5500 HSA","84670WI1270091",{"$f":"BB41","v":0.53090000000000004},"Arise Metro Bronze POS 5500 HSA","84670WI1270091",{"$f":"BE41","v":5500},"Arise Metro Bronze POS 5500 HSA","84670WI1270091",{"$f":"BH41","v":0.6},"Arise Metro Bronze POS 5500 HSA","84670WI1270091",{"$f":"BK41","v":"D/C"},"POS","Bronze",5500,11000,0.8,0.6,6450,19000,"D/C","D/C","D/C","D/C",0,"D/C",0.53090000000000004,{"$error":"#N/A"},"Bronze",5500,11000,0.8,0.6,6450,19000,"D/C","D/C","D/C","D/C","D/C",5500,11000,0.8,0.6,6450,19000,"D/C","D/C","D/C","D/C","D/C",5500,11000,0.8,0.6,6450,19000,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,60,"60 - 64",38.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,48,1.635,1.1649999999999987,null,33,"Vilas",13,0.85699999999999998,"Aspirus Arise",null,null,null,null,null,null,null,null,36,0.68400000000000005,"Arise Silver POS 2500 HSA","84670WI1270032",{"$f":"BB42","v":0.67120000000000002},"Aspirus Arise Silver POS 2500 HSA","84670WI1270077",{"$f":"BB42","v":0.67120000000000002},"Arise Metro Silver POS 2500 HSA","84670WI1270087",{"$f":"BB42","v":0.67120000000000002},"Arise Metro Silver POS 2500 HSA","84670WI1270087",{"$f":"BE42","v":500},"Arise Metro Silver POS 2500 HSA","84670WI1270087",{"$f":"BH42","v":0.6},"Arise Metro Silver POS 2500 HSA","84670WI1270087",{"$f":"BK42","v":"D/C"},"POS","Silver",2500,5000,0.8,0.6,4500,13000,"D/C","D/C","D/C","D/C",0,"D/C",0.67120000000000002,{"$error":"#N/A"},"Silver",500,5000,1,0.6,500,13000,"D/C","D/C","D/C","D/C","D/C",1000,5000,1,0.6,1000,13000,"D/C","D/C","D/C","D/C","D/C",2000,5000,0.8,0.6,3000,13000,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,65,"65+",44.1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,49,1.706,1.1699999999999986,null,34,"Walworth",14,0.95799999999999996,"Aurora",null,null,null,null,"PPO",1,null,null,35,0.68700000000000006,"Arise Silver POS 1400 HSA","84670WI1270033",{"$f":"BB43","v":0.68700000000000006},"Aspirus Arise Silver POS 1400 HSA","84670WI1270078",{"$f":"BB43","v":0.68700000000000006},"Arise Metro Silver POS 1400 HSA","84670WI1270088",{"$f":"BB43","v":0.68700000000000006},"Arise Metro Silver POS 1400 HSA","84670WI1270088",{"$f":"BE43","v":500},"Arise Metro Silver POS 1400 HSA","84670WI1270088",{"$f":"BH43","v":0.5},"Arise Metro Silver POS 1400 HSA","84670WI1270088",{"$f":"BK43","v":"D/C"},"POS","Silver",1400,2800,0.7,0.5,6450,12800,"D/C","D/C","D/C","D/C",0,"D/C",0.68700000000000006,{"$error":"#N/A"},"Silver",500,2800,1,0.5,500,12800,"D/C","D/C","D/C","D/C","D/C",1000,2800,1,0.5,1000,12800,"D/C","D/C","D/C","D/C","D/C",1400,2800,0.8,0.5,4500,12800,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,50,1.786,1.1749999999999985,null,35,"Washington",12,0.98,"Aurora",null,null,null,null,"HDHP",2,null,null,34,0.78800000000000003,"Arise Gold POS 2000 HSA","84670WI1270028",{"$f":"BB44","v":0.8286},"Aspirus Arise Gold POS 2000 HSA","84670WI1270073",{"$f":"BB44","v":0.8286},"Arise Metro Gold POS 2000 HSA","84670WI1270083",{"$f":"BB44","v":0.8286},"Arise Metro Gold POS 2000 HSA","84670WI1270083",{"$f":"BE44","v":2000},"Arise Metro Gold POS 2000 HSA","84670WI1270083",{"$f":"BH44","v":0.8},"Arise Metro Gold POS 2000 HSA","84670WI1270083",{"$f":"BK44","v":"D/C"},"POS","Gold",2000,4000,1,0.8,2000,8000,"D/C","D/C","D/C","D/C",0,"D/C",0.8286,{"$error":"#N/A"},"Gold",2000,4000,1,0.8,2000,8000,"D/C","D/C","D/C","D/C","D/C",2000,4000,1,0.8,2000,8000,"D/C","D/C","D/C","D/C","D/C",2000,4000,1,0.8,2000,8000,"D/C","D/C","D/C","D/C","D/C",null,null,null,null,null,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,51,1.865,1.1799999999999984,null,36,"Waukesha",12,0.98,"ProHealth and Aurora",null,null,null,null,"Product",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Gold","PCP",null,500,null,1000,null,null,null,null,null,0.60000000000000009,3500,0.90480000000000005,{"$f":"$DJ$8*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$36,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$8:$Q$8,3,FALSE)*BB45,4),2)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,1,23.3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$DJ$12*ROUND($A$8*VLOOKUP($I$5,$G$8:$J$36,4,FALSE)*ROUND(VLOOKUP($Q$6,$O$8:$Q$8,3,FALSE)*BB45,4),2)","v":{"$error":"#N/A"}}]
[null,null,52,1.952,1.1849999999999983,null,37,"Waupaca",11,0.88500000000000001,"ThedaCare",null,null,null,1,"Select",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,4500,null,9000,null,null,null,null,null,0.8,6350,0.73270000000000002,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,46.6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,53,2.04,1.1899999999999982,null,38,"Waushara",11,0.88500000000000001,"Aurora and ThedaCare",null,null,null,2,"HMO",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,3000,null,6000,null,null,null,null,null,0.7,6350,0.66839999999999999,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,"3+",80.2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,54,2.1349999999999998,1.1949999999999981,null,39,"Winnebago",11,0.88500000000000001,"Aurora and ThedaCare",null,null,null,3,"POS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,2500,null,5000,null,null,null,null,null,0.60000000000000009,5000,0.69489999999999996,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,55,2.23,1.199999999999998,null,40,"Wood",10,0.83199999999999996,"Aspirus Arise",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,2000,null,4000,null,null,null,null,null,0.60000000000000009,6350,0.66069999999999995,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,56,2.3330000000000002,1.2049999999999979,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,4500,null,9000,null,null,null,null,null,0.49999999999999994,6350,0.62419999999999998,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,57,2.4369999999999998,1.2099999999999977,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","Copay",null,3000,null,6000,null,null,null,null,null,0.49999999999999994,6350,0.62790000000000001,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,58,2.548,1.2149999999999976,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,4000,null,8000,null,null,null,null,null,0.8,5000,0.71009999999999995,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,59,2.6030000000000002,1.2199999999999975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,3000,null,6000,null,null,null,null,null,0.7,6350,0.64570000000000005,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,60,2.714,1.2259999999999975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,2000,null,4000,null,null,null,null,null,0.60000000000000009,6350,0.64019999999999999,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,61,2.81,1.2319999999999975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,2000,null,4000,null,null,null,null,null,0.60000000000000009,5000,0.68769999999999998,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,62,2.8730000000000002,1.2379999999999975,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,1500,null,3000,null,null,null,null,null,0.49999999999999994,6350,0.67210000000000003,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,63,2.952,1.2439999999999976,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","PCP",null,2500,null,5000,null,null,null,null,null,0.49999999999999994,5000,0.65329999999999999,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,64,3,1.2499999999999976,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,0,null,1000,null,null,null,null,null,0.5,6350,0.83350000000000002,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","PCP",null,6350,null,12700,null,null,null,null,null,0.8,6350,0.59540000000000004,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","PCP",null,5500,null,11000,null,null,null,null,null,0.7,6350,0.57879999999999998,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","PCP",null,5000,null,10000,null,null,null,null,null,0.60000000000000009,6350,0.56179999999999997,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","PCP",null,4500,null,9000,null,null,null,null,null,0.49999999999999994,6350,0.56730000000000003,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Catastrophic","PCP",null,6350,null,12700,null,null,null,null,null,0.8,6350,0.49409999999999998,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Gold","D/C",null,2000,null,"-",null,null,null,null,null,"-",2000,0.7792,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Silver","D/C",null,3500,null,"-",null,null,null,null,null,"-",3500,0.6663,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Silver","D/C",null,3000,null,"-",null,null,null,null,null,"-",3000,0.69410000000000005,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Silver","D/C",null,3000,null,"-",null,null,null,null,null,"-",4000,0.64019999999999999,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Silver","D/C",null,2500,null,"-",null,null,null,null,null,"-",4500,0.62019999999999997,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Silver","D/C",null,1500,null,"-",null,null,null,null,null,"-",6350,0.61280000000000001,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Bronze","D/C",null,6000,null,"-",null,null,null,null,null,"-",6000,0.55189999999999995,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Bronze","D/C",null,4500,null,"-",null,null,null,null,null,"-",6350,0.54930000000000001,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Bronze","D/C",null,5500,null,"-",null,null,null,null,null,"-",6350,0.51029999999999998,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMO","Bronze","D/C",null,3500,null,"-",null,null,null,null,null,"-",6350,0.52829999999999999,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Gold","D/C",null,2000,null,2000,null,null,null,null,null,0.8,2000,0.82289999999999996,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,3500,null,3500,null,null,null,null,null,0.8,3500,0.7036,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,3000,null,3000,null,null,null,null,null,0.8,3000,0.73250000000000004,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,3000,null,3000,null,null,null,null,null,0.7,4000,0.67569999999999997,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,2500,null,2500,null,null,null,null,null,0.6,4500,0.65449999999999997,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Silver","D/C",null,1500,null,1500,null,null,null,null,null,0.5,6350,0.64759999999999995,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","D/C",null,6000,null,6000,null,null,null,null,null,0.8,6000,0.58289999999999997,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","D/C",null,4500,null,4500,null,null,null,null,null,0.7,6350,0.58030000000000004,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","D/C",null,5500,null,5500,null,null,null,null,null,0.6,6350,0.53810000000000002,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"POS","Bronze","D/C",null,3500,null,3500,null,null,null,null,null,0.5,6350,0.55740000000000001,{"$error":"#N/A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$error":"#N/A"}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS PPO Bronze 4700","81974WI1880048",null,"ThedaCare HMO 6000","84670WI1250101",0.49209999999999998,"Aurora HMO 6000","84670WI1250107",0.49209999999999998,"Aurora and ThedaCare HMO 6000","84670WI1250117",5681.25,"Aurora and Bellin HMO 6000","84670WI1250127",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6000","84670WI1250137",{"$error":"#VALUE!"},"PPO","Bronze",4700,9400,0.2,0.5,7900,19400,"D/C","3 Free","D/C","D/C",3,"$0 preventive, D/C all others",0.54139999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS PPO Bronze 7900","81974WI1880030",null,"ThedaCare HMO 6850","84670WI1250102",0.46560000000000001,"Aurora HMO 6850","84670WI1250108",0.46560000000000001,"Aurora and ThedaCare HMO 6850","84670WI1250118",6499.35,"Aurora and Bellin HMO 6850","84670WI1250128",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6850","84670WI1250138",{"$error":"#VALUE!"},"PPO","Bronze",7900,15800,0,0.3,7900,21800,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.51219999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS PPO Catastrophic 7900","81974WI1880044",null,"ThedaCare HMO 6850 Catastrophic","84670WI1250039",0.40110000000000001,"Aurora HMO 6850 Catastrophic","84670WI1250094",0.40110000000000001,"Aurora and ThedaCare HMO 6850 Catastrophic","84670WI1250111",6499.35,"Aurora and Bellin HMO 6850 Catastrophic","84670WI1250121",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6850 Catastrophic","84670WI1250131",{"$error":"#VALUE!"},"PPO","Catastrophic",7900,15800,0,0.3,7900,21800,"D/C","3 Free","D/C","D/C",3,"$0 preventive, D/C all others",0.44130000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS PPO HDHP Bronze 5500","81974WI1880042",null,"ThedaCare HMO 5500 HDHP","84670WI1250036",0.47720000000000001,"Aurora HMO 5500 HDHP","84670WI1250091",0.47720000000000001,"Aurora and ThedaCare HMO 5500 HDHP","84670WI1250112",4999.5,"Aurora and Bellin HMO 5500 HDHP","84670WI1250122",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 5500 HDHP","84670WI1250132",{"$error":"#VALUE!"},"PPO HDHP","Bronze",5500,11000,0.3,0.5,6750,21000,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.52500000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"WPS PPO HDHP Bronze 6750","81974WI1880049",null,"ThedaCare HMO 6450 HDHP","84670WI1250034",0.47849999999999998,"Aurora HMO 6450 HDHP","84670WI1250090",0.47849999999999998,"Aurora and ThedaCare HMO 6450 HDHP","84670WI1250113",5953.95,"Aurora and Bellin HMO 6450 HDHP","84670WI1250123",{"$error":"#VALUE!"},"ProHealth and Aurora HMO 6450 HDHP","84670WI1250133",{"$error":"#VALUE!"},"PPO HDHP","Bronze",6750,13500,0,0.3,6750,19500,"D/C","D/C","D/C","D/C",0,"$0 preventive, D/C all others",0.52639999999999998]