{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Dental"],"read":"whole","date_system":"1900"}

{"sheet":"Dental","index":0,"n_rows":50,"n_cols":6,"rows_kept":50,"merged":[[0,3,0,5],[3,2,3,3],[4,2,4,3],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3],[9,0,9,1],[9,2,9,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[13,0,13,1],[13,2,13,3],[14,0,14,1],[14,2,14,3],[15,0,15,1],[15,2,15,3],[16,0,16,1],[16,2,16,3],[17,0,17,1],[17,2,17,3],[18,0,18,1],[18,2,18,3],[19,0,19,1],[19,2,19,3],[20,0,20,1],[20,2,20,3],[21,0,21,1],[21,2,21,3],[22,0,22,1],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,0,26,1],[26,2,26,3],[27,0,27,1],[27,2,27,3],[28,0,28,1],[28,2,28,3],[29,0,29,1],[29,2,29,3],[30,0,30,1],[30,2,30,3],[31,0,31,1],[31,2,31,3],[32,0,32,1],[32,2,32,3],[33,0,33,1],[33,2,33,3],[34,0,34,1],[34,2,34,3],[35,0,35,1],[35,2,35,3],[37,2,37,3],[42,0,42,1],[43,0,43,1],[44,2,44,3]]}
["Knoxville's Community Development Community",null,null,"Exhibit C Summary of current and proposed plan design  "]
["Voluntary Dental Proposal",{"$nulls":3},"Updated 07-30-19"]
["2020-01-01"]
[null,null,"Current Delta Dental "]
[]
["Benefits",null,"Current/Renewal",null,"Option 1 -  Prepaid ","Option 2 - DPPO"]
["Deductible"]
["Individual",null,{"v":50,"d":"$50"},null,"Member pays according to covered charge schedule",{"v":25,"d":"$25"}]
["Deductible is Calendar Year or Plan Year?",null,"Calendar",null,"\"","Calendar"]
["Family limit",null,{"v":150,"d":"$150"},null,"\"",{"v":75,"d":"$75"}]
["Deductible Applies to?",null,"Basic & Major",null,"\"","Basic & Major"]
["Maximum"]
["* Basic & Major (Annual per Member)",null,{"v":1500,"d":"$1,500"},null,"\"",{"v":1500,"d":"$1,500"}]
["Orthodontia (Child Under Age 19)",null,{"v":2000,"d":"$2,000"},null,"\"",{"v":1250,"d":"$1,250"}]
["Diagnostic & Preventive",null,"In/Out",null,null,"In/Out"]
["Oral Exams",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["Cleanings",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["Fluoride Treatment",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["Space Maintainers",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["X-Rays",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["Sealants - to prevent decay of permanent teeth",null,{"v":1,"d":"100%"},null,"\"",{"v":1,"d":"100%"}]
["Basic - Restorative Services"]
["Fillings",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Crown Repair - to individual crowns",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Relines and Rebase",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Implant Repair - maintenance, repair and removal",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Simple Extractions",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Periodontics & Endodontics",null,{"v":0.9,"d":"90%"},null,"\"",{"v":0.8,"d":"80%"}]
["Major Services"]
["Crown, Inlay, Onlay Services",null,{"v":0.6,"d":"60%"},null,"\"",{"v":0.5,"d":"50%"}]
["Relines and Rebase",null,{"v":0.6,"d":"60%"},null,"\"",{"v":0.5,"d":"50%"}]
["Implant Repair - maintenance, repair and removal",null,{"v":0.6,"d":"60%"},null,"\"",{"v":0.5,"d":"50%"}]
["Prosthodontic Services (Bridges and Dentures)",null,{"v":0.6,"d":"60%"},null,"\"",{"v":0.5,"d":"50%"}]
["Orthodontic Services"]
["Braces",null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
["MAC or UCR?",null,"MAC",null,"MAC","MAC"]
[]
["Composite Rates","Counts","Current/Renewal"]
["Single",49,{"v":31.07,"d":"$31.07"},{"$f":"C39","v":{"v":31.07,"d":"$31.07"}}]
["Employee + Spouse",26,{"v":92.76,"d":"$92.76"},{"$f":"C40","v":{"v":92.76,"d":"$92.76"}}]
["Employee + Child(ren)",18,{"v":92.76,"d":"$92.76"},{"v":92.76,"d":"$92.76"}]
["Family",36,{"v":92.76,"d":"$92.76"},{"v":92.76,"d":"$92.76"}]
["Estimated Monthly Premium",null,{"$f":"SUMPRODUCT(C39:C42,$B$39:$B$42)","v":{"v":8943.230000000001,"d":"$8,943.23"}},{"v":8943.230000000001,"d":"$8,943.23"}]
["Estimated Annual Premium",null,{"$f":"C43*12","v":{"v":107318.76000000001,"d":"$107,318.76"}},{"v":107318.76000000001,"d":"$107,318.76"}]
["% Change",null,{"$f":"(D44/$C$44)-1","v":{"v":0,"d":"0.00%"}},null,{"$f":"(E44/$C$44)-1","v":{"v":-1,"d":"-100%"}},{"$f":"(F44/$C$44)-1","v":{"v":-1,"d":"-100%"}}]
[]
[]
[]
[]
[-2]