{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["WPS Quote","WPS Benefits and Selection","Calculations","Duration"],"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":53,"n_cols":12,"rows_kept":53,"cut":false,"hidden":false,"merged":[[83,1,83,11],[39,1,39,3],[50,1,50,3],[30,1,30,3],[31,1,31,3],[33,1,33,3],[35,1,35,3],[37,1,37,3],[41,1,41,3],[43,1,43,3],[45,1,45,3],[47,1,47,3],[49,1,49,3],[12,1,13,11],[17,3,17,4],[27,1,29,3],[27,11,29,11],[27,4,27,5],[27,6,27,7],[28,10,29,10],[27,8,27,9],[28,6,29,6],[28,7,29,7],[17,7,17,8],[23,3,23,4],[21,3,21,4],[19,3,19,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2026 Short Term Health Plan Quote"]
[]
[]
[]
[]
[null,null,"Applicant Name: ",null,null,null,"Policy Type: ",null,null,"ACH Billing Discount:"]
[]
[null,null,"Effective Date: ",null,null,null,{"$f":"IF(H18='WPS Benefits and Selection'!B23,\"\",\"Applicant Date of Birth: \")","v":""},null,null,{"$f":"IF(OR(H18='WPS Benefits and Selection'!B25,H18='WPS Benefits and Selection'!B27),\"Spouse Date of Birth: \",\"\")","v":""}]
[]
[null,null,"Term Date: ",null,null,null,{"$f":"IF(H18='WPS Benefits and Selection'!B23,\"\",\"Applicant Gender: \")","v":""},null,null,{"$f":"IF(OR(H18='WPS Benefits and Selection'!B25,H18='WPS Benefits and Selection'!B27),\"Spouse Gender: \",\"\")","v":""}]
[]
[null,null,"County:",null,null,null,{"$f":"IF(OR(H18='WPS Benefits and Selection'!B26,H18='WPS Benefits and Selection'!B27),\"# of Dependents: \",\"\")","v":""}]
[]
[]
[]
[null,"Medical Plan Name                                         (select plan name for brochure)",null,null,"Medical Deductible",null,"Medical Coinsurance",null,"Medical Out-of Pocket Limit",null,"Drug Deductible","Monthly Rate"]
[null,null,null,null,"In-Network","Out-Network","In-Network","Out-Network","In-Network","Out-Network","Individual/Family"]
[null,null,null,null,"Individual/Family","Individual/Family",null,null,"Individual/Family","Individual/Family"]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V5,'WPS Benefits and Selection'!B5)","v":"WPS Short Term Health Plan 1500 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C5&\"/$\"&'WPS Benefits and Selection'!D5","v":"$1500/$4500"},{"$f":"\"$\"&'WPS Benefits and Selection'!E5&\"/$\"&'WPS Benefits and Selection'!F5","v":"$3000/$9000"},{"$f":"'WPS Benefits and Selection'!G5","v":0.25},{"$f":"'WPS Benefits and Selection'!H5","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I5&\"/$\"&'WPS Benefits and Selection'!J5","v":"$4000/$12000"},{"$f":"\"$\"&'WPS Benefits and Selection'!K5&\"/$\"&'WPS Benefits and Selection'!L5","v":"$8000/$24000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M5&\"/$\"&'WPS Benefits and Selection'!N5","v":"$500/$1500"},{"$f":"Calculations!AM16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V6,'WPS Benefits and Selection'!B6)","v":"WPS Short Term Health Plan 2500 0%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C6&\"/$\"&'WPS Benefits and Selection'!D6","v":"$2500/$7500"},{"$f":"\"$\"&'WPS Benefits and Selection'!E6&\"/$\"&'WPS Benefits and Selection'!F6","v":"$5000/$15000"},{"$f":"'WPS Benefits and Selection'!G6","v":0},{"$f":"'WPS Benefits and Selection'!H6","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I6&\"/$\"&'WPS Benefits and Selection'!J6","v":"$2500/$7500"},{"$f":"\"$\"&'WPS Benefits and Selection'!K6&\"/$\"&'WPS Benefits and Selection'!L6","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M6&\"/$\"&'WPS Benefits and Selection'!N6","v":"$500/$1500"},{"$f":"Calculations!AN16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V7,'WPS Benefits and Selection'!B7)","v":"WPS Short Term Health Plan 2500 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C7&\"/$\"&'WPS Benefits and Selection'!D7","v":"$2500/$7500"},{"$f":"\"$\"&'WPS Benefits and Selection'!E7&\"/$\"&'WPS Benefits and Selection'!F7","v":"$5000/$15000"},{"$f":"'WPS Benefits and Selection'!G7","v":0.25},{"$f":"'WPS Benefits and Selection'!H7","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I7&\"/$\"&'WPS Benefits and Selection'!J7","v":"$5000/$15000"},{"$f":"\"$\"&'WPS Benefits and Selection'!K7&\"/$\"&'WPS Benefits and Selection'!L7","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M7&\"/$\"&'WPS Benefits and Selection'!N7","v":"$500/$1500"},{"$f":"Calculations!AO16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V8,'WPS Benefits and Selection'!B8)","v":"WPS Short Term Health Plan 5000 0%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C8&\"/$\"&'WPS Benefits and Selection'!D8","v":"$5000/$15000"},{"$f":"\"$\"&'WPS Benefits and Selection'!E8&\"/$\"&'WPS Benefits and Selection'!F8","v":"$10000/$30000"},{"$f":"'WPS Benefits and Selection'!G8","v":0},{"$f":"'WPS Benefits and Selection'!H8","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I8&\"/$\"&'WPS Benefits and Selection'!J8","v":"$5000/$15000"},{"$f":"\"$\"&'WPS Benefits and Selection'!K8&\"/$\"&'WPS Benefits and Selection'!L8","v":"$15000/$45000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M8&\"/$\"&'WPS Benefits and Selection'!N8","v":"$500/$1500"},{"$f":"Calculations!AP16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V9,'WPS Benefits and Selection'!B9)","v":"WPS Short Term Health Plan 5000 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C9&\"/$\"&'WPS Benefits and Selection'!D9","v":"$5000/$15000"},{"$f":"\"$\"&'WPS Benefits and Selection'!E9&\"/$\"&'WPS Benefits and Selection'!F9","v":"$10000/$30000"},{"$f":"'WPS Benefits and Selection'!G9","v":0.25},{"$f":"'WPS Benefits and Selection'!H9","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I9&\"/$\"&'WPS Benefits and Selection'!J9","v":"$7500/$22500"},{"$f":"\"$\"&'WPS Benefits and Selection'!K9&\"/$\"&'WPS Benefits and Selection'!L9","v":"$15000/$45000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M9&\"/$\"&'WPS Benefits and Selection'!N9","v":"$500/$1500"},{"$f":"Calculations!AQ16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V10,'WPS Benefits and Selection'!B10)","v":"WPS Short Term Health Plan 7500 0%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C10&\"/$\"&'WPS Benefits and Selection'!D10","v":"$7500/$22500"},{"$f":"\"$\"&'WPS Benefits and Selection'!E10&\"/$\"&'WPS Benefits and Selection'!F10","v":"$15000/$45000"},{"$f":"'WPS Benefits and Selection'!G10","v":0},{"$f":"'WPS Benefits and Selection'!H10","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I10&\"/$\"&'WPS Benefits and Selection'!J10","v":"$7500/$22500"},{"$f":"\"$\"&'WPS Benefits and Selection'!K10&\"/$\"&'WPS Benefits and Selection'!L10","v":"$20000/$60000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M10&\"/$\"&'WPS Benefits and Selection'!N10","v":"$500/$1500"},{"$f":"Calculations!AR16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V11,'WPS Benefits and Selection'!B11)","v":"WPS Short Term Health Plan 7500 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C11&\"/$\"&'WPS Benefits and Selection'!D11","v":"$7500/$22500"},{"$f":"\"$\"&'WPS Benefits and Selection'!E11&\"/$\"&'WPS Benefits and Selection'!F11","v":"$15000/$45000"},{"$f":"'WPS Benefits and Selection'!G11","v":0.25},{"$f":"'WPS Benefits and Selection'!H11","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I11&\"/$\"&'WPS Benefits and Selection'!J11","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!K11&\"/$\"&'WPS Benefits and Selection'!L11","v":"$20000/$60000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M11&\"/$\"&'WPS Benefits and Selection'!N11","v":"$500/$1500"},{"$f":"Calculations!AS16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V12,'WPS Benefits and Selection'!B12)","v":"WPS Short Term Health Plan 10000 0%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C12&\"/$\"&'WPS Benefits and Selection'!D12","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!E12&\"/$\"&'WPS Benefits and Selection'!F12","v":"$20000/$60000"},{"$f":"'WPS Benefits and Selection'!G12","v":0},{"$f":"'WPS Benefits and Selection'!H12","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I12&\"/$\"&'WPS Benefits and Selection'!J12","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!K12&\"/$\"&'WPS Benefits and Selection'!L12","v":"$25000/$75000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M12&\"/$\"&'WPS Benefits and Selection'!N12","v":"$500/$1500"},{"$f":"Calculations!AT16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V13,'WPS Benefits and Selection'!B13)","v":"WPS Short Term Health Plan 10000 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C13&\"/$\"&'WPS Benefits and Selection'!D13","v":"$10000/$30000"},{"$f":"\"$\"&'WPS Benefits and Selection'!E13&\"/$\"&'WPS Benefits and Selection'!F13","v":"$20000/$60000"},{"$f":"'WPS Benefits and Selection'!G13","v":0.25},{"$f":"'WPS Benefits and Selection'!H13","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I13&\"/$\"&'WPS Benefits and Selection'!J13","v":"$12500/$37500"},{"$f":"\"$\"&'WPS Benefits and Selection'!K13&\"/$\"&'WPS Benefits and Selection'!L13","v":"$25000/$75000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M13&\"/$\"&'WPS Benefits and Selection'!N13","v":"$500/$1500"},{"$f":"Calculations!AU16","v":0}]
[]
[null,{"$f":"HYPERLINK('WPS Benefits and Selection'!V14,'WPS Benefits and Selection'!B14)","v":"WPS Short Term Health Plan 15000 25%"},null,null,{"$f":"\"$\"&'WPS Benefits and Selection'!C14&\"/$\"&'WPS Benefits and Selection'!D14","v":"$15000/$45000"},{"$f":"\"$\"&'WPS Benefits and Selection'!E14&\"/$\"&'WPS Benefits and Selection'!F14","v":"$30000/$90000"},{"$f":"'WPS Benefits and Selection'!G14","v":0.25},{"$f":"'WPS Benefits and Selection'!H14","v":0.5},{"$f":"\"$\"&'WPS Benefits and Selection'!I14&\"/$\"&'WPS Benefits and Selection'!J14","v":"$17500/$52500"},{"$f":"\"$\"&'WPS Benefits and Selection'!K14&\"/$\"&'WPS Benefits and Selection'!L14","v":"$35000/$105000"},{"$f":"\"$\"&'WPS Benefits and Selection'!M14&\"/$\"&'WPS Benefits and Selection'!N14","v":"$500/$1500"},{"$f":"Calculations!AV16","v":0}]
[]
[]
[null,"Premium estimates are based on the information you have provided. Actual rates will be based on the information provided in your signed application."]

{"sheet":"WPS Benefits and Selection","index":1,"n_rows":90,"n_cols":24,"rows_kept":90,"cut":false,"hidden":true,"merged":[]}
[]
["1-1-2026 Plans & Benefits Template - Short Term Plans"]
[]
["HIOS Plan ID","Plan Marketing Name","Single Medical Deductible In-Net","Family Medical Deductible In-Net","Single Medical Deductible Out-Net","Family Medical Deductible Out-Net","Medical Coinsurance In-Net","Medical Coinsurance Out-Net","Single Medical Max OOP In-Net","Family Medical Max OOP In-Net","Single Medical Max OOP Out-Net","Family Medical Max OOP Out-Net","Single Drug Deductible","Family Drug Deductible","Medical Maximum Benefit","Drug Maximum Benefit","Doctor Office Visit","Urgent Care Visit","Emergency Room","Teladoc ","SBC URL","Brochure URL","Plan Effective Date","Plan Expiration Date"]
["81974ST0000001","WPS Short Term Health Plan 1500 25%",1500,{"$f":"C5*3","v":4500},{"$f":"C5*2","v":3000},{"$f":"E5*3","v":9000},0.25,0.5,{"$f":"C5 + 10000*G5","v":4000},{"$f":"I5*3","v":12000},{"$f":"E5 + 10000*H5","v":8000},{"$f":"K5*3","v":24000},500,{"$f":"M5*3","v":1500},"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000006","WPS Short Term Health Plan 2500 0%",2500,{"$f":"C6*3","v":7500},{"$f":"C6*2","v":5000},{"$f":"E6*3","v":15000},0,0.5,{"$f":"C6 + 10000*G6","v":2500},{"$f":"I6*3","v":7500},{"$f":"E6 + 10000*H6","v":10000},30000,500,{"$f":"M6*3","v":1500},"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000002","WPS Short Term Health Plan 2500 25%",2500,7500,5000,15000,0.25,0.5,5000,15000,10000,30000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000007","WPS Short Term Health Plan 5000 0%",5000,15000,10000,30000,0,0.5,5000,15000,15000,45000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000003","WPS Short Term Health Plan 5000 25%",5000,15000,10000,30000,0.25,0.5,7500,22500,15000,45000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000009","WPS Short Term Health Plan 7500 0%",7500,22500,15000,45000,0,0.5,7500,22500,20000,60000,500,{"$f":"M10*3","v":1500},"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000010","WPS Short Term Health Plan 7500 25%",7500,22500,15000,45000,0.25,0.5,10000,30000,20000,60000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000008","WPS Short Term Health Plan 10000 0%",10000,30000,20000,60000,0,0.5,10000,30000,25000,75000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000004","WPS Short Term Health Plan 10000 25%",10000,30000,20000,60000,0.25,0.5,12500,37500,25000,75000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
["81974ST0000005","WPS Short Term Health Plan 15000 25%",15000,45000,30000,90000,0.25,0.5,17500,52500,35000,105000,500,1500,"$1,000,000 per covered person","$3,000 per covered person","Subject to Deductible and Coinsurance","Subject to Deductible and Coinsurance","$350 Copay, then subject to Deductible and Coinsurance","$55 Copay ","N/A","https://secure.wpsic.com/sales-materials/files/33544_2026-wps-short-term-insurance-plan-brochure.pdf","2026-01-01","2026-12-31"]
[]
[]
["County Select","Gender Select"]
[]
["Adams","Male"]
["Ashland","Female"]
["Barron"]
["Bayfield","Policy Type Select"]
["Brown"]
["Buffalo","Applicant Only"]
["Burnett","Applicant & Spouse"]
["Calumet","Applicant & Dependents"]
["Chippewa","Family"]
["Clark",null,null,null,null,null,null,"List of February 29ths","Year Type","Is in Date Range?"]
["Columbia",null,null,null,null,"Effective Date",{"$f":"'WPS Quote'!D20","v":"00:00:00"},"2020-02-29",{"$f":"IF(OR(MOD(YEAR(H29),400)=0,AND(MOD(YEAR(H29),4)=0,MOD(YEAR(H29),100)<>0)),\"Leap\", \"Standard\")","v":"Leap"},{"$f":"IF(AND(H29<=$G$30,H29>=$G$29),\"Yes\",\"No\")","v":"No"}]
["Crawford",null,null,null,null,"Date +365",{"$f":"G29+365","v":"1900-12-30"},"2024-02-29",{"$f":"IF(OR(MOD(YEAR(H30),400)=0,AND(MOD(YEAR(H30),4)=0,MOD(YEAR(H30),100)<>0)),\"Leap\", \"Standard\")","v":"Leap"},{"$f":"IF(AND(H30<=$G$30,H30>=$G$29),\"Yes\",\"No\")","v":"No"}]
["Dane","Dependents",null,null,null,"Feb. 29 In Range?",{"$f":"IF(OR(J29=\"Yes\",J30=\"Yes\",J31=\"Yes\",J32=\"Yes\",J33=\"Yes\",J34=\"Yes\",J35=\"Yes\",J36=\"Yes\"),\"Yes\",\"No\")","v":"No"},"2028-02-29","Leap","No"]
["Dodge",null,null,null,null,"Term Min Date",{"$f":"G29+27","v":"1900-01-27"},"2032-02-29","Leap","No"]
["Door",0,null,null,null,"Term Max Date",{"$f":"IF(G31=\"Yes\",G29+365,G29+364)","v":"1900-12-29"},"2036-02-29","Leap","No"]
["Douglas",1,null,null,null,null,null,"2040-02-29","Leap","No"]
["Dunn",2,null,null,null,null,null,"2044-02-29","Leap","No"]
["Eau Claire",3,null,null,null,null,null,"2048-02-29","Leap","No"]
["Florence",4]
["Fond Du Lac",5,null,null,null,"NTT Duration Counter"]
["Forest",6,null,null,null,{"$f":"Duration!G15","v":1}]
["Grant",7]
["Green",8,null,null,null,"From what I can tell, NTT is counting months by ignoring the days entirely, and inclusively counting the months between begin and end date, for example:"]
["Green Lake",9,null,null,null,"10/31/2019 to 4/1/2020 is equal to 7 months, even though in reality, its really more like 5 months of coverage, verified on website 10/11/2019"]
["Iowa",10]
["Iron"]
["Jackson"]
["Jefferson"]
["Juneau","ACH Billing"]
["Kenosha"]
["Kewaunee","Yes"]
["La Crosse","No"]
["Lafayette"]
["Langlade"]
["Lincoln"]
["Manitowoc"]
["Marathon"]
["Marinette"]
["Marquette"]
["Menominee"]
["Milwaukee"]
["Monroe"]
["Oconto"]
["Oneida"]
["Outagamie"]
["Ozaukee"]
["Pepin"]
["Pierce"]
["Polk"]
["Portage"]
["Price"]
["Racine"]
["Richland"]
["Rock"]
["Rusk"]
["Saint Croix"]
["Sauk"]
["Sawyer"]
["Shawano"]
["Sheboygan"]
["Taylor"]
["Trempealeau"]
["Vernon"]
["Vilas"]
["Walworth"]
["Washburn"]
["Washington"]
["Waukesha"]
["Waupaca"]
["Waushara"]
["Winnebago"]
["Wood"]

{"sheet":"Calculations","index":2,"n_rows":128,"n_cols":48,"rows_kept":128,"cut":false,"hidden":true,"merged":[[4,19,4,21],[4,1,4,2],[4,4,4,5],[4,7,4,8],[4,16,4,17],[4,10,4,14]]}
[]
[]
[]
[]
[null,"Base",null,null,"Trend",null,null,"Benefit Relativities",null,null,"Age/Gender Table",null,null,null,null,null,"Duration",null,null,"Area"]
[]
[null,"Eff Date","Factor",null,"Eff Date","Factor",null,"Plan ID","Factor",null,"Lookup Key","Age","Male","Female","Dep",null,"Time","Factor",null,"Network","County","Factor",null,"Age","Male","Female","Dep",null,null,"Effective Date",{"$f":"'WPS Quote'!D20","v":"00:00:00"}]
[null,"2026-01-01",164.46,null,"2026-01-01",1,null,"81974ST0000001",1.4083000000000001,null,0,"0 - 24",1.1406000000000001,1,0.5,null,"<= 6 Months",0.8,null,"Statewide","Adams",1.0150000000000001,null,0,1.1406000000000001,1,0.5,null,null,"County",{"$f":"'WPS Quote'!D24","v":0}]
[null,null,null,null,"2026-07-01",1.04,null,"81974ST0000006",1.2948999999999999,null,25,"25 - 29",1.0612999999999999,1.087,0.5,null,"> 6 Months",1,null,"Statewide","Ashland",1.0449999999999999,null,1,1.1406000000000001,1,0.5,null,null,"ACH Billing",{"$f":"'WPS Quote'!K18","v":0}]
[null,null,null,null,"2027-01-01",1.0815999999999999,null,"81974ST0000002",1.0708,null,30,"30 - 34",1.077,1.2131000000000001,0.5,null,null,null,null,"Statewide","Barron",1.0449999999999999,null,2,1.1406000000000001,1,0.5]
[null,null,null,null,"2027-07-01",1.1249,null,"81974ST0000007",1.0359,null,35,"35 - 39",1.1049,1.298,0.5,null,null,null,null,"Statewide","Bayfield",1.0449999999999999,null,3,1.1406000000000001,1,0.5,null,null,null,null,null,null,null,null,null,null,null,"1500 25%","2500 0%","2500 25%","5000 0%","5000 25%","7500 0%","7500 25%","10000 0%","10000 25%","15000 25%"]
[null,null,null,null,null,null,null,"81974ST0000003",0.85629999999999995,null,40,"40 - 44",1.4229000000000001,1.5177,0.5,null,null,null,null,"Statewide","Brown",1.01,null,4,1.1406000000000001,1,0.5,null,null,null,"Use in Calc?","DOB","Age","Gender","Base Rate","Trend","Duration","Area","Rate","Rate","Rate","Rate","Rate","Rate","Rate","Rate","Rate","Rate"]
[null,null,null,null,null,null,null,"81974ST0000009",0.80279999999999996,null,45,"45 - 49",1.76,1.8425,0.5,null,null,null,null,"Statewide","Buffalo",1.08,null,5,1.1406000000000001,1,0.5,null,null,"Applicant",{"$f":"IF('WPS Quote'!H18=\"\",0,1)","v":0},{"$f":"IF('WPS Quote'!H20=\"\", \"N/A\",'WPS Quote'!H20)","v":"N/A"},{"$f":"IF(MONTH(AE7)<MONTH(AF13),YEAR(AE7)-YEAR(AF13)-1,IF(MONTH(AE7)>MONTH(AF13),YEAR(AE7)-YEAR(AF13),IF(DAY(AE7)<DAY(AF13),YEAR(AE7)-YEAR(AF13)-1,YEAR(AE7)-YEAR(AF13))))","v":{"$error":"#VALUE!"}},{"$f":"IF('WPS Quote'!H22=\"\", \"N/A\",'WPS Quote'!H22)","v":"N/A"},{"$f":"ROUND(C8*IF(AH13=\"Male\",VLOOKUP(AG13,$K$8:$N$16,3),IF(AH13=\"Female\",VLOOKUP(AG13,$K$8:$N$16,4),\"N/A\")),2)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($AE$7,$E$8:$F$11,2)","v":{"$error":"#N/A"}},{"$f":"IF('WPS Benefits and Selection'!$F$39>6,$R$9,$R$8)","v":0.8},{"$f":"VLOOKUP(AE8,Calculations!$U$8:$V$79,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$8,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$9,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$10,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$11,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$12,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$13,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$14,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$15,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$16,2)*$AL$13,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$13*$AJ$13*$AK$13*$I$17,2)*$AL$13,2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"81974ST0000010",0.66390000000000005,null,50,"50 - 54",2.2877999999999998,2.2890000000000001,0.5,null,null,null,null,"Statewide","Burnett",0.96500000000000008,null,6,1.1406000000000001,1,0.5,null,null,"Spouse",{"$f":"IF(OR('WPS Quote'!H18=\"Applicant & Spouse\",'WPS Quote'!H18=\"Family\"),1,0)","v":0},{"$f":"IF('WPS Quote'!K20=\"\", \"N/A\",'WPS Quote'!K20)","v":"N/A"},{"$f":"IF(MONTH(AE7)<MONTH(AF14),YEAR(AE7)-YEAR(AF14)-1,IF(MONTH(AE7)>MONTH(AF14),YEAR(AE7)-YEAR(AF14),IF(DAY(AE7)<DAY(AF14),YEAR(AE7)-YEAR(AF14)-1,YEAR(AE7)-YEAR(AF14))))","v":{"$error":"#VALUE!"}},{"$f":"IF('WPS Quote'!K22=\"\", \"N/A\",'WPS Quote'!K22)","v":"N/A"},{"$f":"ROUND(C8*IF(AH14=\"Male\",VLOOKUP(AG14,$K$8:$N$16,3),IF(AH14=\"Female\",VLOOKUP(AG14,$K$8:$N$16,4),\"N/A\")),2)","v":{"$error":"#VALUE!"}},{"$f":"VLOOKUP($AE$7,$E$8:$F$11,2)","v":{"$error":"#N/A"}},{"$f":"IF('WPS Benefits and Selection'!$F$39>6,$R$9,$R$8)","v":0.8},{"$f":"VLOOKUP(AE8,Calculations!$U$8:$V$79,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$8,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$9,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$10,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$11,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$12,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$13,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$14,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$15,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$16,2)*$AL$14,2)","v":{"$error":"#VALUE!"}},{"$f":"ROUND(ROUND($AI$14*$AJ$14*$AK$14*$I$17,2)*$AL$14,2)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,"81974ST0000008",0.75739999999999996,null,55,"55 - 59",3.1147999999999998,2.7698999999999998,0.5,null,null,null,null,"Statewide","Calumet",0.92999999999999994,null,7,1.1406000000000001,1,0.5,null,null,"# of Dependents",{"$f":"IF(OR('WPS Quote'!H18=\"Applicant & Dependents\",'WPS Quote'!H18=\"Family\"),1,0)","v":0},{"$f":"IF('WPS Quote'!H24=\"\", \"N/A\",'WPS Quote'!H24)","v":"N/A"},null,null,{"$f":"ROUND(C8*O8,2)","v":82.23},{"$f":"VLOOKUP($AE$7,$E$8:$F$11,2)","v":{"$error":"#N/A"}},{"$f":"IF('WPS Benefits and Selection'!$F$39>6,$R$9,$R$8)","v":0.8},{"$f":"VLOOKUP('WPS Quote'!$D$24,Calculations!$U$8:$V$79,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$8,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$9,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$10,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$11,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$12,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$13,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$14,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$15,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$16,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}},{"$f":"ROUND(ROUND($AI$15*$AJ$15*$AK$15*$I$17,2)*$AL$15,2)*$AF$15","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"81974ST0000004",0.62639999999999996,null,60,"60 - 120",3.8178999999999998,3.1572,0.5,null,null,null,null,"Statewide","Chippewa",1.1400000000000001,null,8,1.1406000000000001,1,0.5,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AM13:AM15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AN13:AN15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AO13:AO15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AP13:AP15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AQ13:AQ15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},{"$f":"ROUND(SUMIF($AE$13:$AE$15,1,AR13:AR15)*IF($AE$9=\"Yes\",0.98,1),2)","v":0},0,0,0,0]
[null,null,null,null,null,null,null,"81974ST0000005",0.49259999999999998,null,null,null,null,null,null,null,null,null,null,"Statewide","Clark",1.02,null,9,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Columbia",1.0449999999999999,null,10,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Crawford",1.05,null,11,1.1406000000000001,1,0.5]
[null,"Under Age 18?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Dane",1.08,null,12,1.1406000000000001,1,0.5]
[null,"Eff Date",{"$f":"DATE(YEAR('WPS Quote'!$D$20), MONTH('WPS Quote'!$D$20), DAY('WPS Quote'!$D$20))","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Dodge",1.03,null,13,1.1406000000000001,1,0.5]
[null,"Age 18",{"$f":"EDATE(DATE(YEAR('WPS Quote'!$D$20), MONTH('WPS Quote'!$D$20), DAY('WPS Quote'!$D$20)),-216)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Door",1.0049999999999999,null,14,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Douglas",1.06,null,15,1.1406000000000001,1,0.5]
[null,"Under Age 26?",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Dunn",1.0150000000000001,null,16,1.1406000000000001,1,0.5]
[null,"Eff Date",{"$f":"DATE(YEAR('WPS Quote'!$D$20), MONTH('WPS Quote'!$D$20), DAY('WPS Quote'!$D$20))","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Eau Claire",1.1299999999999999,null,17,1.1406000000000001,1,0.5]
[null,"Age 26",{"$f":"EDATE(DATE(YEAR('WPS Quote'!$D$20), MONTH('WPS Quote'!$D$20), DAY('WPS Quote'!$D$20)),-312)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Florence",1.0649999999999999,null,18,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Fond Du Lac",1.04,null,19,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Forest",0.96,null,20,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Grant",1.04,null,21,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Green",1.1800000000000002,null,22,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Green Lake",1.02,null,23,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Iowa",1.0150000000000001,null,24,1.1406000000000001,1,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Iron",1.0249999999999999,null,25,1.0612999999999999,1.087,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Jackson",1.05,null,26,1.0612999999999999,1.087,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Jefferson",1.06,null,27,1.0612999999999999,1.087,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Juneau",1.02,null,28,1.0612999999999999,1.087,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Kenosha",0.97499999999999998,null,29,1.0612999999999999,1.087,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Kewaunee",0.98,null,30,1.077,1.2131000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","La Crosse",1.0449999999999999,null,31,1.077,1.2131000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Lafayette",1.0449999999999999,null,32,1.077,1.2131000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Langlade",0.94500000000000006,null,33,1.077,1.2131000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Lincoln",1.0049999999999999,null,34,1.077,1.2131000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Manitowoc",1.01,null,35,1.1049,1.298,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Marathon",1.0350000000000001,null,36,1.1049,1.298,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Marinette",1.04,null,37,1.1049,1.298,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Marquette",0.99,null,38,1.1049,1.298,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Menominee",1.04,null,39,1.1049,1.298,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Milwaukee",1,null,40,1.4229000000000001,1.5177,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Monroe",1.0699999999999998,null,41,1.4229000000000001,1.5177,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Oconto",1.0150000000000001,null,42,1.4229000000000001,1.5177,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Oneida",1.0150000000000001,null,43,1.4229000000000001,1.5177,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Outagamie",0.94,null,44,1.4229000000000001,1.5177,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Ozaukee",0.98,null,45,1.76,1.8425,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Pepin",1.0449999999999999,null,46,1.76,1.8425,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Pierce",1.0350000000000001,null,47,1.76,1.8425,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Polk",0.96500000000000008,null,48,1.76,1.8425,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Portage",1.02,null,49,1.76,1.8425,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Price",1.0150000000000001,null,50,2.2877999999999998,2.2890000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Racine",0.99,null,51,2.2877999999999998,2.2890000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Richland",1.04,null,52,2.2877999999999998,2.2890000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Rock",1.085,null,53,2.2877999999999998,2.2890000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Rusk",1.01,null,54,2.2877999999999998,2.2890000000000001,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Saint Croix",1.0249999999999999,null,55,3.1147999999999998,2.7698999999999998,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Sauk",1.0899999999999999,null,56,3.1147999999999998,2.7698999999999998,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Sawyer",1.0449999999999999,null,57,3.1147999999999998,2.7698999999999998,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Shawano",0.97499999999999998,null,58,3.1147999999999998,2.7698999999999998,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Sheboygan",0.95500000000000007,null,59,3.1147999999999998,2.7698999999999998,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Taylor",1.0150000000000001,null,60,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Trempealeau",1.0649999999999999,null,61,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Vernon",1.0550000000000002,null,62,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Vilas",0.96500000000000008,null,63,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Walworth",1.0150000000000001,null,64,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Washburn",1.0449999999999999,null,65,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Washington",0.97499999999999998,null,66,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Waukesha",1.01,null,67,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Waupaca",0.94,null,68,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Waushara",0.97499999999999998,null,69,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Winnebago",0.92500000000000004,null,70,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Statewide","Wood",1.0150000000000001,null,71,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,72,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,76,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,77,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,78,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,81,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,82,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,83,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,86,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,87,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,88,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,89,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,90,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,93,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,94,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,95,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,96,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,98,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,99,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,101,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,102,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,105,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,107,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,108,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,110,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,111,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,112,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,113,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,114,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,117,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,118,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,119,3.8178999999999998,3.1572,0.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,120,3.8178999999999998,3.1572,0.5]

{"sheet":"Duration","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"Month","Day","Year",null,"Month Order","Year","Total Possible Days","Accumulation","Month Count"]
["Start Date",{"$f":"MONTH('WPS Quote'!D20)","v":1},{"$f":"DAY('WPS Quote'!D20)","v":0},{"$f":"YEAR('WPS Quote'!D20)","v":1900},null,{"$f":"B2","v":1},{"$f":"D2","v":1900},{"$f":"IF(F2<>2,VLOOKUP(F2,$A$7:$B$18,2,FALSE),IF(AND(F2=2,OR(G2=2020, G2=2024,G2= 2028,G2= 2032,G2= 2036,G2=2040)),29,28))","v":31},{"$f":"H2","v":31},1]
["End Date",{"$f":"MONTH('WPS Quote'!D22)","v":1},{"$f":"DAY('WPS Quote'!D22)","v":0},{"$f":"YEAR('WPS Quote'!D22)","v":1900},null,{"$f":"IF(F2+1=13,1,F2+1)","v":2},{"$f":"IF(F3=1,G2+1,G2)","v":1900},28,{"$f":"H3+I2","v":59},2]
[null,null,null,null,null,{"$f":"IF(F3+1=13,1,F3+1)","v":3},{"$f":"IF(F4=1,G3+1,G3)","v":1900},31,{"$f":"H4+I3","v":90},3]
["Contract Length:",null,{"$f":"DATE(D3,B3,C3)-DATE(D2,B2,C2) +1","v":1},null,null,4,1900,30,120,4]
[null,null,null,null,null,5,1900,31,151,5]
[1,31,null,null,null,6,1900,30,181,6]
[2,"28/29",null,null,null,7,1900,31,212,7]
[3,31,null,null,null,8,1900,31,243,8]
[4,30,null,null,null,9,1900,30,273,9]
[5,31,null,null,null,10,1900,31,304,10]
[6,30,null,null,null,11,1900,30,334,11]
[7,31,null,null,null,12,1900,31,365,12]
[8,31]
[9,30,null,null,null,"Total Month Count:",{"$f":"IF(AND(B2=B3,D2=D3),1,_xlfn.IFNA(VLOOKUP(C5,$I$2:$J$13,2,FALSE),VLOOKUP(C5,$I$2:$J$13,2) +1))","v":1}]
[10,31]
[11,30]
[12,31]
[]
["All the calculations here are based on the belief that NTT starts the day counter with how many days are in the first month."]
["For example, if the start date was 3/15/2021, then, since March has 31 days, the first month will be 31 days, at 32 days, the month"]
["count will be 2, until the next 30 days are satisfied (since April is the next month), at 62 days, the count will be 3, etc…."]
[]
[]
[]
[]
[]
["This currently cant handle starting a 28 or 29 policy that crosses months"]
["This has always been a problem that hasn’t been brought up."]