Examples
Examples
Try the starting example
- Promises: contract ID, promised units, deadline date
- Logo,2,2026-10-31
- Delivery records: unique record ID, contract ID, units, delivered date, evidence verified yes/no
- D1,Logo,1,2026-10-20,yes D2,Logo,1,2026-11-01,yes D3,Logo,1,2026-10-20,no
- Audit as-of date, inclusive
- 2026-11-02
- Verified delivered units by contract as of date
- Logo: 2
- Units still short of promise by contract
- Logo: 0
- Verified units delivered after contract deadline
- 1
- Unverified units on or before audit date
- 1
- Units in records after audit date
- 0
Try another scenario
- Promises: contract ID, promised units, deadline date
- Logo,2,2026-10-31
- Delivery records: unique record ID, contract ID, units, delivered date, evidence verified yes/no
- D1,Logo,1,2026-10-20,yes D2,Logo,1,2026-11-01,yes D3,Logo,1,2026-10-20,no
- Audit as-of date, inclusive
- 2026-10-31
- Verified delivered units by contract as of date
- Logo: 1
- Units still short of promise by contract
- Logo: 1
- Verified units delivered after contract deadline
- 0
- Unverified units on or before audit date
- 1
- Units in records after audit date
- 1
Calculation method
Calculation method
Verified delivered units by contract as of date
Sum recorded units only where supplied evidence flag is yes and delivery date≤audit cutoff.
Units still short of promise by contract
max(0,promised−verified delivered); over-delivery does not offset another contract.
Verified units delivered after contract deadline
Among verified deliveries through cutoff, count units whose date exceeds that contract deadline.
Unverified units on or before audit date
Count units in past/current records marked evidence no.
Units in records after audit date
Count all units dated after cutoff, excluded from current fulfillment.
Symbols and units
- a
- Promises: contract ID, promised units, deadline date
- b
- Delivery records: unique record ID, contract ID, units, delivered date, evidence verified yes/no
- c
- Audit as-of date, inclusive
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A unit-and-evidence fulfillment audit from supplied records, not automatic verification that a logo, impression, placement or other promised benefit was actually delivered.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Charity Commission: funds and reserves background; no universal reserve target ↗
Background reading; this does not imply endorsement or independent review of SumFizz.