Interoperability CBA Spreadsheet Model

I need a dynamic Excel or Google Sheets workbook that lets me run a full cost-benefit analysis on linking health-facility birth records with the civil registry system in a developing-country setting.

Data that must feed the model
• Health facility records
• Civil registry data
• Any relevant external government databases we can access or import

Core analysis
The sheet should calculate Return on Investment, Net Present Value, and the Benefit-Cost Ratio across multiple scenarios and time horizons. All assumptions—capital outlay, recurring costs, discount rate, uptake projections, and monetized social benefits—should be editable from a single input tab that automatically updates every downstream output.

What I expect to see
1. Clearly separated tabs for Input Assumptions, Calculations, Dashboards, and Sensitivity Analysis.
2. Built-in scenario toggles (e.g., low / medium / high adoption) with results updating instantly.
3. Transparent formulas with comments so the logic is easy to audit.
4. Visual summaries (charts or heat maps) highlighting ROI, NPV, and BCR under each scenario.
5. The option to work seamlessly in either Microsoft Excel (O365) or Google Sheets without losing functionality.

Acceptance
I will consider the job complete when the workbook:
• Imports a small dummy dataset I provide from all three data sources without errors.
• Produces ROI, NPV, and BCR values that match my manual spot checks.
• Lets me alter a key assumption (e.g., discount rate) and immediately see refreshed outputs and charts.

If you have experience building financial or health-sector CBAs and can turn complex inputs into an intuitive model, I’m ready to review your proposal and timeline.