Illustrative assumptions. The included workshop, costs, counts and dates are fictional. The workbook describes no real charity or measured benefit.
One worksheet, 7,675 bytes, version 1. It uses ordinary formulas, with editable input cells and no macros or external workbook connections.
Define what the count means
A budget and an activity count are two signals in the charity system. Writing their scope and assumptions makes them easier to inspect and revise from feedback. An output describes work completed; an outcome asks what changed for people or communities.
- Name one output and its counting rule. Keep the same inclusive period for every cost and count.
- Replace the blue, amber-filled inputs. Use nominal planned cash costs in USD, including your allocated shared costs. Record the price year, inclusions, exclusions and each source or assumption.
- Enter nonnegative cash amounts and whole output counts, with a point estimate and any bounds you can justify. Keep lower ≤ point ≤ upper. Leave unknown values blank. Enter 0 only for an explicit zero.
- Inspect the formulas and result notes. Keep private source writing out of copies you share.
The three cost rows cover staff, direct nonstaff and allocated shared cash costs. Explain your allocation and omissions. This is a cash-cost plan; unpriced volunteer time and donated resources are separate exclusions. It is not an accounting ledger.
Follow the arithmetic
| Result | Calculation |
|---|---|
| Point estimate | Sum of point cash costs ÷ point output count |
| Conditional lower bound | Sum of lower cash-cost bounds ÷ upper output bound |
| Conditional upper bound | Sum of upper cash-cost bounds ÷ lower output bound |
The fictional example gives USD 100 per completed workshop, with conditional bounds of about USD 57.14–200. These bounds depend on the inputs covering the relevant costs and counts. They are not probabilities, percentiles or confidence intervals, and they do not establish whether a combination is plausible.
A missing bound leaves that result unknown while a valid point estimate remains available. Zero cost with positive outputs gives 0.00. Zero outputs makes the point ratio unavailable. Positive possible cost with a zero lower output bound has no finite upper ratio; 0 cost divided by 0 outputs stays undefined.
Inspect the source and checks
Read the exact cell, input and formula specification. The workbook formulas are visible and unlocked. Text supplied through the authoring path stays literal; the template cannot prevent deliberate formula edits in your own spreadsheet app.
The authored template and formulas are MIT-licensed. Future user-supplied data keep their own rights.
Read the 20 native recalculation cases. Each disposable input had its formula caches removed before actual headless LibreOfficeDev 26.8.0.0.alpha0 recalculated it. The cases cover changed costs/counts, unknown values, zeros, invalid inputs and literal formula-leading text. Native Excel, Google Sheets and spreadsheet-app UI behavior have not been checked.
This deterministic output planner is separate from the Model Kit’s expected-outcome simulation and reproducible bundles. It does not import those files or change their frozen interpretation. A calculated ratio supplies no causal evidence, charity rating or judgment about the good being done.
For shared program, grant and task coordination, explore Charity OS.
Download SHA-256: 29ef1b668f6a14bdc76ad8fa57ad305cf21a5ac8a7a28d40712675b51979fbd7