Examples
Examples
Try the starting example
- Card transactions JSON [ID,vehicle ID,elapsed day,liters,amount currency,odometer km] (USD)
- [["T1","V1",1,40,60,1000],["T2","V1",2,70,105,1200]]
- Independent odometer logs JSON [vehicle ID,elapsed day,odometer km]
- [["V1",1,1000],["V1",2,1210]]
- Supplied tank capacities JSON {vehicle ID:liters}
- {"V1":60}
- Exactly matched transaction IDs
- ["T1"]
- Unmatched transaction IDs
- ["T2"]
- Consistency flags [transaction,reason]
- [["T2","Purchase exceeds supplied tank capacity"]]
- Total card amount (USD)
- $165.00
Try another scenario
- Card transactions JSON [ID,vehicle ID,elapsed day,liters,amount currency,odometer km] (USD)
- [["T1","V1",1,40,60,1000],["T2","V1",2,70,105,1200]]
- Independent odometer logs JSON [vehicle ID,elapsed day,odometer km]
- [["V1",1,1000],["V1",2,1200]]
- Supplied tank capacities JSON {vehicle ID:liters}
- {"V1":60}
- Exactly matched transaction IDs
- ["T1","T2"]
- Unmatched transaction IDs
- []
- Consistency flags [transaction,reason]
- [["T2","Purchase exceeds supplied tank capacity"]]
- Total card amount (USD)
- $165.00
Calculation method
Calculation method
Exactly matched transaction IDs
One-to-one exact match by vehicle, day, odometer; consume first unused log row in input order.
Unmatched transaction IDs
No unused exact log match.
Consistency flags [transaction,reason]
Flag purchase liters>suppliedTankCapacity or liters<=0, descriptive only.
Total card amount (USD)
Sum supplied transaction amounts.
Symbols and units
- a
- Card transactions JSON [ID,vehicle ID,elapsed day,liters,amount currency,odometer km] (USD)
- b
- Independent odometer logs JSON [vehicle ID,elapsed day,odometer km]
- c
- Supplied tank capacities JSON {vehicle ID:liters}
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
- Literal reconciliation and limited plausibility flags, not fraud detection. A fill can legitimately cover containers or multiple vehicles; supplied tank comparison does not establish wrongdoing. No data fetched or altered. Supported limits: Unique transaction IDs; known vehicle capacity>0; integer day>=0; odometer>=0; cost>=0; <=1000 rows.
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.