{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["DataEntryPage","Group LifeADD_with DEP","Group LifeADD Deviations","VolLifeADD","VolLIfeADD Deviations","GroupSTD","GroupSTD Deviations","VolSTD","VolSTD Deviations","GroupLTD","GroupLTD Deviations","Hospital Indemnity","Critical Illness","Accident","HSA","Cobra","Wellness","Whole Life"],"not_rendered":{"external_links":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"DataEntryPage","index":0,"n_rows":4,"n_cols":3,"rows_kept":4}
["Company Name:","Hamilton County Department of Education"]
["Renewal Date:","2022-01-01"]
["Payroll Schedule:",null,"Example: Semi-monthly / bi-weekly / weekly"]
["# of Payrolls Per Year:",null,"Example: 26, 24, 12, 52"]

{"sheet":"Group LifeADD_with DEP","index":1,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[0,0,0,1],[2,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,15,2]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Basic Life and AD&D"]
[null,null,"Alternative "]
[null,null,"CARRIERNAME"]
["Rates per month per $1,000 of Coverage"]
["Life (5022 lives)","Life"]
["AD&D (5022 lives)","AD&D"]
["Volume","Dep"]
[]
["Monthly Premium",null,{"$f":"((SUMPRODUCT(C6:C7)*#REF!/1000)+(#REF!*C9))","v":{"$error":"#REF!"}}]
["Annual Premium",null,{"$f":"C10*12","v":{"$error":"#REF!"}}]
["Annual $ Change from Current",null,{"$f":"C11-#REF!","v":{"$error":"#REF!"}}]
["% Change from Current",null,{"$f":"C11/#REF!-1","v":{"$error":"#REF!"}}]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Group LifeADD Deviations","index":2,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,1,15]]}
["NOTE ANY DEVIATIONS BELOW THAT APPLY FOR YOUR RESPONSE - FULL LIST"]

{"sheet":"VolLifeADD","index":3,"n_rows":38,"n_cols":3,"rows_kept":38,"merged":[[2,0,3,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[11,0,11,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[37,0,37,2]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Voluntary Life and AD&D"]
[null,null,"Alternative "]
[null,null,"CARRIERNAME"]
["Participation Requirement"]
[" CompositeRates per month per $1,000 of Coverage"]
["Life (1425 lives)","Life"]
["AD&D (1046 lives)","AD&D"]
["Dependent Life Spouse (803 Lives)"]
["Volume Life","Dep"]
[null,"Volume Dependent Life SP"]
["Units Dependent Child Per $5,000 (860)"]
[null,"Volume AD&D"]
[]
["Monthly Premium"]
["Annual Premium"]
["Rate per $1000 benefit"]
[null,"Applies to ","EE Only v. EE & SP"]
[null,"<20"]
[null,"20-24"]
[null,"25-29"]
[null,"30-34"]
[null,"35-39"]
[null,"40-44"]
[null,"45-49"]
[null,"50-54"]
[null,"55-59"]
[null,"60-64"]
[null,"65+"]
[null,"70-74"]
[null,"75+"]
["Child(ren) Flat Rate"]
["AD&D per $1,000"]
["Monthly Premium Example:\n40 Year Old with $____ Salary \nelecting coverage"]
["Rate Guarantee"]
["Notes"]
[]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"VolLIfeADD Deviations","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,1,15]]}
["NOTE ANY DEVIATIONS BELOW THAT APPLY FOR YOUR RESPONSE - FULL LIST"]

{"sheet":"GroupSTD","index":5,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[2,0,3,1],[4,0,4,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[13,0,14,2]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Group Short-Term Disability (ER Paid)"]
[null,null,"Alternative "]
[null,null,"CARRIERNAME"]
["Rate per $10 weekly benefit"]
[null,"STD Rate"]
["Lives 5182","Volume"]
["Monthly Premium",null,{"$f":"(C6*#REF!)/10","v":{"$error":"#REF!"}}]
["Annual Premium",null,{"$f":"C8*12","v":{"$error":"#REF!"}}]
["Annual Increase",null,{"$f":"C9-#REF!","v":{"$error":"#REF!"}}]
["Percentage Change",null,{"$f":"C9/#REF!-1","v":{"$error":"#REF!"}}]
["Rate Guarantee"]
[]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"GroupSTD Deviations","index":6,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,1,15]]}
["NOTE ANY DEVIATIONS BELOW THAT APPLY FOR YOUR RESPONSE - FULL LIST"]

{"sheet":"VolSTD","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"merged":[[2,0,3,1],[5,0,5,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,2]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Voluntary Short-Term Disability"]
[null,null,"Alternative "]
[null,null,"CARRIERNAME"]
["Participation Requirement"]
["Rate per $10 weekly benefit"]
[null,"STD Rate"]
["Lives 463","Volume"]
["Monthly Premium",null,{"$f":"C8/10*C7","v":{"v":0,"d":"$0.00"}}]
["Annual Premium",null,{"$f":"C9*12","v":{"v":0,"d":"$0"}}]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"VolSTD Deviations","index":8,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,1,15]]}
["NOTE ANY DEVIATIONS BELOW THAT APPLY FOR YOUR RESPONSE - FULL LIST"]

{"sheet":"GroupLTD","index":9,"n_rows":14,"n_cols":3,"rows_kept":14,"merged":[[2,0,3,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[11,2,12,3],[13,0,14,2]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Group Long-Term Disability"]
[null,null,"Alternative "]
[null,null,"CARRIERNAME"]
["Rate Per $100 of \ncovered monthly payroll"]
["Volume \nCovered monthly payroll"]
["Monthly Premium"]
["Annual Premium"]
["Annual Increase",null,{"$f":"(C7-#REF!)*12","v":{"$error":"#REF!"}}]
["Percentage Change",null,{"$f":"C7/#REF!-1","v":{"$error":"#REF!"}}]
["Rate Guarantee"]
["Notes"]
[]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"GroupLTD Deviations","index":10,"n_rows":1,"n_cols":1,"rows_kept":1,"merged":[[0,0,1,15]]}
["NOTE ANY DEVIATIONS BELOW THAT APPLY FOR YOUR RESPONSE - FULL LIST"]

{"sheet":"Hospital Indemnity","index":11,"n_rows":14,"n_cols":17,"rows_kept":14,"merged":[[3,0,4,0],[3,1,3,4],[3,5,3,8],[3,9,3,12],[3,13,3,16],[4,1,4,4],[4,5,4,8],[4,9,4,12],[4,13,4,16],[5,0,6,0],[5,1,5,4],[5,5,5,8],[5,9,5,12],[5,13,5,16],[13,0,14,12]]}
[{"$f":"[1]DataEntryPage!B1","v":"Hamilton County Department of Education"}]
[{"$f":"[1]DataEntryPage!B2","v":"2021-07-01"}]
["Hospital Indemnity"]
["$1,000 Lump Sum","Alternative ",{"$nulls":3},"Alternative ",{"$nulls":3},"Alternative ",{"$nulls":3},"Alternative "]
["General Plan Design","CARRIERNAME",{"$nulls":3},"CARRIERNAME",{"$nulls":3},"CARRIERNAME",{"$nulls":3},"CARRIERNAME"]
["Monthly Premiums\nIssue Age\n","H S A - Guarantee Issue",null,null,"Employee &\nSpouse","H S A - Simplified Issue",null,null,"Employee &\nSpouse"," NON H S A - Guarantee Issue",null,null,"Employee &\nSpouse"," NON H S A - Simplified Issue",null,null,"Employee &\nSpouse"]
[null,"EE","EE+SP","EE+CH","Fam","EE","EE+SP","EE+CH","Fam","EE","EE+SP","EE+CH","Fam","EE","EE+SP","EE+CH","Fam"]
["18-49"]
["50-59"]
["60-64"]
["65-69"]
["Average  Rate"]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Critical Illness","index":12,"n_rows":20,"n_cols":4,"rows_kept":20,"merged":[[2,0,3,0],[2,1,2,4],[3,1,3,4],[4,0,5,0],[4,1,4,4],[5,1,5,2],[5,3,5,4],[19,0,20,4]]}
[{"$f":"[1]DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Critical Illness with Cancer"]
[null,"Alternative "]
["General Plan Design","CARRIERNAME"]
["Monthly Premiums\nEmployee - $10,000\n","Employee",null,"Employee &\nSpouse"]
[null,"Non-Tobacco",null,"Tobacco"]
["< 24"]
["25-29"]
["30-34"]
["35-39"]
["40-44"]
["45-49"]
["50-54"]
["55-59"]
["60-64"]
["65-69"]
["70+"]
["Average  Rate"]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Accident","index":13,"n_rows":13,"n_cols":2,"rows_kept":13,"merged":[[2,0,3,0],[12,0,13,1]]}
[{"$f":"[1]DataEntryPage!B1","v":"Hamilton County Department of Education"}]
["Accident"]
["On and Off Job","Alternative "]
[null,"CARRIERNAME"]
["Monthly Rates"]
["Employee Only"]
["Employee and Spouse"]
["Employee and Child(ren)"]
["Family"]
[]
[]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"HSA","index":14,"n_rows":34,"n_cols":6,"rows_kept":34,"hidden":true,"merged":[[3,0,4,0],[33,0,34,5]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
[{"$f":"DataEntryPage!B2","v":"2022-01-01"}]
["HSA"]
[null,"Current","Renewal","Alternative 1","Alternative 2","Alternative 3"]
[null,"CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME"]
["24/7 Call Center"]
["Debit Card "]
["Unlimited Check Transactions"]
["Monthly Statements"]
["Tax Reporting"]
["Online Banking and Bill Payment"]
["Monthly Fees "]
["Additional Services"]
["First Year Set Up Fee"]
["Card Replacement Fee"]
["Termination of Debit Card Access"]
["New Account Welcome Packet"]
["Per PIN Withdrawal"]
["Overdraft / NSF per Item"]
["Manual Withdrawal Process Fee"]
["Copy of Check, Statement or Tax Document"]
["Close Account Fee"]
["Excess Contribution Distribution"]
["Deposit Item Returned Unpaid"]
["Wire Transfer Sent / Received"]
["Stop Payment Request per Item"]
["Copy of Debit Card Transaction Receipt"]
["Corrected IRS Filing Fee (Non Bank Error)"]
["Options for Accountholders"]
["Interest Earned Information"]
["Investment Options"]
["Annual Premium"]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Cobra","index":15,"n_rows":29,"n_cols":6,"rows_kept":29,"hidden":true,"merged":[[3,0,4,0],[28,0,29,5]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
[{"$f":"DataEntryPage!B2","v":"2022-01-01"}]
["Cobra"]
[null,"Current","Renewal","Alternative 1","Alternative 2","Alternative 3"]
[null,"CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME"]
["Setup"]
["Reports / Premium Distribution"]
["Customer Service"]
["Compliance, Minimum monthly charge"]
["Ongoing Admin"]
["Mailing Dept. of Labor general notices to new hires/new dependents"]
["Sending COBRA elections form to employees and/or dependents who lose coverage"]
["Tracking COBRA timetable for each participant"]
["Collecting Monthly Premiums"]
["Liason between COBRA participants and insurance carriers"]
["Providing HIPPA certificates to participants and/or dependents at the end of the COBRA continuation period"]
["Open Enrollment Services"]
["Optional Services"]
["Premium Surcharge returned to employer"]
["Estimated Costs"]
["Initial Setup"]
["Renewal Fee"]
["Cobra Administration"]
["Open Enrollment Service Fee"]
["Minimum Cobra Administration Fee"]
["Approximate Annual Cost"]
["Annual Premium"]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Wellness","index":16,"n_rows":42,"n_cols":6,"rows_kept":42,"hidden":true,"merged":[[3,0,4,0],[39,0,39,1],[39,2,40,5],[41,0,42,5]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
[{"$f":"DataEntryPage!B2","v":"2022-01-01"}]
["Wellness Options"]
[null,"Current","Renewal","Alternative 1","Alternative 2","Alternative 3"]
[null,"CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME","CARRIERNAME"]
["Costs"]
["Initial Set Up Cost"]
["Annual Cost"]
["Core Wellness / Services Included"]
["Online or Paper HRA "]
["Review of HRA Results"]
["Incentive Program Tracking "]
["Associate Education/Communication Materials"]
["Reporting "]
["Annual Cost"]
["Biometric Screenings"]
["Fee Per Screening"]
["Minimum Participation"]
["Services Provided:"]
["Individual Biometric Screening Report"]
["Glucose"]
["Blood Pressure"]
["BMI"]
["Cholesterol Panel "]
["Height/Weight Measurement"]
["Tobacco Usage"]
["Travel Expenses"]
["Annual Cost"]
["Disease Management"]
["High Risk Multiple Disease States"]
["Health Coaching"]
["On Site follow ups"]
["Outbound Telephonic Health Coaching"]
["Inbound Calls from Associates "]
[" Tobacco Cessation Program"]
["Reporting"]
["Annual Cost"]
["Per Employee Cost"]
["Total Annual Cost"]
["Notes"]
[]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]

{"sheet":"Whole Life","index":17,"n_rows":24,"n_cols":13,"rows_kept":24,"hidden":true,"merged":[[3,0,4,0],[3,1,3,4],[3,5,3,8],[3,9,3,12],[4,1,4,4],[4,5,4,8],[4,9,4,12],[5,1,5,4],[5,5,5,8],[5,9,5,12],[6,1,6,4],[6,5,6,8],[6,9,6,12],[7,1,7,4],[7,5,7,8],[7,9,7,12],[8,1,8,4],[8,5,8,8],[8,9,8,12],[9,1,9,4],[9,5,9,8],[9,9,9,12],[10,1,10,4],[10,5,10,8],[10,9,10,12],[11,1,11,4],[11,5,11,8],[11,9,11,12],[12,1,12,4],[12,5,12,8],[12,9,12,12],[14,1,14,4],[14,5,14,8],[14,9,14,12],[15,1,15,4],[15,5,15,8],[15,9,15,12],[16,1,16,2],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[23,0,24,12]]}
[{"$f":"DataEntryPage!B1","v":"Hamilton County Department of Education"}]
[{"$f":"DataEntryPage!B2","v":"2022-01-01"}]
["Whole Life"]
[null,"Current",{"$nulls":3},"Alternative 1",{"$nulls":3},"Alternative 2"]
["General Plan Design","CARRIERNAME",{"$nulls":3},"CARRIERNAME",{"$nulls":3},"CARRIERNAME"]
["Benefit Amount"]
["Is premium guaranteed for life?"]
["Builds Cash Value?"]
["Opportunity for guaranteed issue?"]
["Work status"]
["Coverage effective date?"]
["Accidental Death available?"]
["Child Rider "]
["Portable"]
["Weekly Rates"]
["Employee / Spouse Example"]
["Tobacco Status","Non-Tobacco",null,"Tobacco",null,"Non-Tobacco",null,"Tobacco",null,"Non-Tobacco",null,"Tobacco"]
["Amount of Coverage","Death Benefit","Guaranteed Cash Value @ 65","Death Benefit","Guaranteed Cash Value @ 65","Death Benefit","Guaranteed Cash Value @ 65","Death Benefit","Guaranteed Cash Value @ 65","Death Benefit","Guaranteed Cash Value @ 65","Death Benefit","Guaranteed Cash Value @ 65"]
["Age 25"]
["Age 35"]
["Age 45"]
["Age 55"]
["Rate Guarantee"]
["This summary is issued as a matter of information only.  It does not amend, extend or alter the quotes offered by the insurance companies.  \nPlease refer to the actual quote from the insurance company for specific coverage details and rates"]