Examples
Examples
Try the starting example
- Prices: ID, source currency, source price, published currency, published price
- A,USD,100,USD,101 B,USD,50,EUR,50 C,USD,0,USD,0
- Absolute price tolerance in that currency
- 0.5
- Relative tolerance against source (%)
- 0.5
- Flag when either tolerance exceeded, or both: either/both
- either
- Published minus source by same-currency offer
- A: 1.00; C: 0.00
- Offers exceeding selected tolerance rule
- A
- Offers with currency mismatch
- B
- Same-currency offers compared
- 2
- Largest same-currency absolute difference
- 1
Try another scenario
- Prices: ID, source currency, source price, published currency, published price
- A,USD,100,USD,101 B,USD,50,EUR,50 C,USD,0,USD,0
- Absolute price tolerance in that currency
- 2
- Relative tolerance against source (%)
- 2
- Flag when either tolerance exceeded, or both: either/both
- either
- Published minus source by same-currency offer
- A: 1.00; C: 0.00
- Offers exceeding selected tolerance rule
- None
- Offers with currency mismatch
- B
- Same-currency offers compared
- 2
- Largest same-currency absolute difference
- 1
Calculation method
Calculation method
Published minus source by same-currency offer
Subtract exact-cent source from published only when currency codes match.
Offers exceeding selected tolerance rule
Compare absolute difference and absolute difference/source×100 under the selected either/both rule. Any positive change from zero source exceeds a finite relative tolerance.
Offers with currency mismatch
List different-currency rows without converting or comparing their amounts.
Same-currency offers compared
Count rows with identical supplied three-letter uppercase currency codes.
Largest same-currency absolute difference
Maximum absolute cent difference among comparable rows; undefined when no same-currency rows.
Symbols and units
- a
- Prices: ID, source currency, source price, published currency, published price
- b
- Absolute price tolerance in that currency
- c
- Relative tolerance against source (%)
- d
- Flag when either tolerance exceeded, or both: either/both
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 same-currency cent comparison using tolerances you choose. Currency codes are labels, not a verified currency registry; no exchange rates or live prices are fetched.
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
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.