Examples
Examples
Try the starting example
- Managed asset inventory: asset ID, last supplied inventory-seen date
- A,2026-10-01 B,2026-10-19 C,2026-10-05
- Discovery records: asset ID, observed date; repeated IDs allowed, or none
- A,2026-10-20 X,2026-10-19 X,2026-10-18 Y,2026-10-01
- Audit date
- 2026-10-20
- Freshness/staleness threshold elapsed days
- 7
- Recently discovered IDs absent from managed inventory
- X
- Managed inventory records older than threshold
- A, C
- Managed IDs absent from supplied discovery records by audit
- B, C
- Duplicate discovery rows beyond unique observed IDs
- 1
- Discovery IDs whose latest observed date is older than threshold
- Y
- Managed inventory IDs with recent supplied discovery (%)
- 33.333333
Try another scenario
- Managed asset inventory: asset ID, last supplied inventory-seen date
- A,2026-10-01 B,2026-10-19 C,2026-10-05
- Discovery records: asset ID, observed date; repeated IDs allowed, or none
- A,2026-10-20 X,2026-10-19 X,2026-10-18 Y,2026-10-01
- Audit date
- 2026-10-20
- Freshness/staleness threshold elapsed days
- 20
- Recently discovered IDs absent from managed inventory
- X, Y
- Managed inventory records older than threshold
- None
- Managed IDs absent from supplied discovery records by audit
- B, C
- Duplicate discovery rows beyond unique observed IDs
- 1
- Discovery IDs whose latest observed date is older than threshold
- None
- Managed inventory IDs with recent supplied discovery (%)
- 33.333333
Calculation method
Calculation method
Recently discovered IDs absent from managed inventory
Take latest discovery≤audit per ID and require age≤threshold; compare exact IDs to managed inventory.
Managed inventory records older than threshold
Audit−last supplied inventory-seen date>threshold.
Managed IDs absent from supplied discovery records by audit
No supplied discovery record on/before audit for that managed ID; this is not proof the asset is absent.
Duplicate discovery rows beyond unique observed IDs
Count included discovery rows−distinct included discovered IDs.
Discovery IDs whose latest observed date is older than threshold
Latest included discovery older than threshold.
Managed inventory IDs with recent supplied discovery (%)
Recent discovered managed IDs/all managed inventory IDs×100.
Symbols and units
- a
- Managed asset inventory: asset ID, last supplied inventory-seen date
- b
- Discovery records: asset ID, observed date; repeated IDs allowed, or none
- c
- Audit date
- d
- Freshness/staleness threshold elapsed days
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 exact-identifier inventory/discovery reconciliation, not an asset scan or identity matching system. Discovery may be incomplete and older sightings do not prove retirement; no asset is deleted or enrolled.
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.