Examples
Examples
Try the starting example
- Suppliers: name, minimum eligible batch units
- A,3 B,1
- Reported failures: ID, supplier, units, purchase date, supplied warranty days after purchase, evidence recorded yes/no; or none
- I1,A,2,2026-10-01,30,yes I2,A,1,2026-10-10,10,yes I3,B,2,2026-09-01,30,no
- Audit date
- 2026-10-20
- Units within supplied window with recorded evidence by supplier
- A: 3; B: 0
- Records outside supplied date window
- I3
- Records lacking supplied evidence
- I3
- Earliest eligible supplied deadline by supplier
- A: 2026-10-20; B: None
- Suppliers meeting entered batch minimum
- A
Try another scenario
- Suppliers: name, minimum eligible batch units
- A,3 B,1
- Reported failures: ID, supplier, units, purchase date, supplied warranty days after purchase, evidence recorded yes/no; or none
- I1,A,2,2026-10-01,30,yes I2,A,1,2026-10-10,10,yes I3,B,2,2026-09-01,30,no
- Audit date
- 2026-10-21
- Units within supplied window with recorded evidence by supplier
- A: 2; B: 0
- Records outside supplied date window
- I2, I3
- Records lacking supplied evidence
- I3
- Earliest eligible supplied deadline by supplier
- A: 2026-10-31; B: None
- Suppliers meeting entered batch minimum
- None
Calculation method
Calculation method
Units within supplied window with recorded evidence by supplier
Count reported-failure units only when audit≤purchase date+entered days and evidence flag is yes.
Records outside supplied date window
List records where audit is after that entered inclusive deadline.
Records lacking supplied evidence
List evidence no independently of date eligibility.
Earliest eligible supplied deadline by supplier
Minimum deadline among eligible evidence-backed records, or None.
Suppliers meeting entered batch minimum
Compare eligible units to the supplier’s supplied minimum; no real return is created.
Symbols and units
- a
- Suppliers: name, minimum eligible batch units
- b
- Reported failures: ID, supplier, units, purchase date, supplied warranty days after purchase, evidence recorded yes/no; or none
- c
- Audit date
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 supplied reported-failure/date/evidence batch check, not a diagnosis, warranty entitlement decision or verification of a supplier’s terms.
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
Background reading; this does not imply endorsement or independent review of SumFizz.