Examples
Examples
Try the starting example
- Quotes: provider, option name, price $
- A,Service,100 A,Urn,50 B,Service,90 B,Urn,70
- Options to compare, comma separated
- Service,Urn
- Comparable provider totals ($)
- A: 150; B: 160
- Lowest entered quote provider(s)
- A
- Lowest comparable quote total ($)
- $150.00
- Spread between highest and lowest total ($)
- $10.00
- Providers missing required options
- None
Try another scenario
- Quotes: provider, option name, price $
- A,Service,100 A,Urn,50 B,Service,90 B,Urn,70
- Options to compare, comma separated
- Service
- Comparable provider totals ($)
- A: 100; B: 90
- Lowest entered quote provider(s)
- B
- Lowest comparable quote total ($)
- $90.00
- Spread between highest and lowest total ($)
- $10.00
- Providers missing required options
- None
Calculation method
Calculation method
Comparable provider totals ($)
Sum selected option prices only for providers supplying every requested option.
Lowest entered quote provider(s)
List all ties for the lowest complete quote.
Lowest comparable quote total ($)
Minimum complete quote total; an error is shown if no quote is complete.
Spread between highest and lowest total ($)
Highest complete total minus lowest.
Providers missing required options
List providers excluded because at least one selected option was not supplied.
Symbols and units
- a
- Quotes: provider, option name, price $
- b
- Options to compare, comma separated
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
- Compares fictional or supplied itemised quotes in one currency, requiring identical selected line items. It does not assess service quality, recommend a provider or add taxes or fees that are not entered.
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
OpenStax: arithmetic and geometry ↗
Background reading; this does not imply endorsement or independent review of SumFizz.