1. Purpose of This Calculator
Dental caries (tooth decay) is among the most common chronic conditions in school-age children. Public dental workforce shortages mean that dentists visiting schools alone spend much of the camp day on oral health education and fluoride varnish as well as clinical procedures.
This tool evaluates how multidisciplinary team delegation (task-shifting) transforms school camps: delegating oral health education to trained classroom teachers and fluoride varnish to dental auxiliaries, leaving dental surgeons to deliver the clinical procedures.
2. Step-by-Step Workflow
- Select or Upload Your Country: Use the Country dropdown to choose India (pre-loaded with national data and 35 states) or upload a custom Excel file for any nation, province, or district.
- Choose a Policy Deployment Tier: Select between Status Quo (2 camps/month, solo dentist), Plausible Target (8 camps/month, 30% delegation — recommended), Stretch (12 camps/month), or Theoretical Maximum.
- Adjust Team Delegation Level: Choose 0% (no delegation) or 10%, 20% or 30% (delegation with that many more referrals per camp).
- Review Live Results: Watch the headline KPI cards, comparative table, and clinical breakdown update in real time.
- Export Outputs: Download comprehensive Excel spreadsheets (.xlsx) or copy executive policy text for reports and presentations.
3. Excel Template Field Reference
The downloadable Excel template (Dental_Caries_DES_Input_Template.xlsx) contains three structured sheets:
| Field Key |
Description |
Recommended Unit / Format |
country_name |
Official name of your country, state, or province |
Text (e.g. Kenya, Brazil, Universal) |
enrol_6_8, enrol_9_11, enrol_12_15 |
Target student population by primary, upper primary, and secondary grades |
Integer count (or 35% / 33% / 32% demographic split) |
dentists_public |
Total active government dental surgeons available for public programs |
FTE count |
prev_6_8, prev_9_11, prev_12_15 |
Untreated active caries prevalence across each age category |
Decimal proportion (e.g. 0.52 for 52%) |
camps_per_month |
Operational camp visit days per dentist per month |
2 to 22 (8 days/month recommended) |
task_shifting_level |
Team delegation intensity |
0%, 10%, 20%, or 30% |
4. Interpreting Output Indicators
- Annual Children Reached: The total count of unique students who receive complete treatment during the academic year.
- National Caries Coverage (%): The percentage of all school-age children with active untreated caries reached by the program.
- Time Outside Camp Procedures: Percentage of working time not spent on camp procedures. Camp days themselves also take dentists away from clinics.
- Dedicated Dentists Needed: The number of additional full-time school dental surgeons required to reach 100% universal caries coverage under the selected policy model.
- In-Year Morbidity Averted (YLDs): Cumulative Years Lived with Disability avoided among treated children using WHO Global Burden of Disease disability weights.