ClideyPricing logic you can test and trust.
An industrial fabricator replaced brittle spreadsheet logic with a testable function and connected quote records. Every quote now comes from logic the team can check.
45reference calculations validate the engine
1tested pricing function
Every quotelinked to the logic that produced it
Draftreview before changes go live
IN THE PRODUCT
The pricing engine, as a function.
Pick a point on the left to see where it lives on the screen. Every screen shown here comes from the Clidey ERP demo project.
APP.WHODB.COM / FUNCTIONS / PRICE_QUOTEDARK
HOW IT WORKS
How the team moved off the spreadsheet.
01
Capture the rulesThe spreadsheet formulas were rewritten as one function.02
Check against references45 reference calculations confirm the function gives the expected price.03
Connect the quotesQuote records link to their inputs and to the function that priced them.04
Change safelyNew pricing goes through a draft and review before it is promoted.TESTING
Reference cases, not guesswork.
Known good calculations are kept with the function, so any change is checked against them before it ships.
✓Reference calculations kept with the logic✓Run with smart, form or raw input✓Output visible on every run
Reference checks45 OF 45 PASS
CASEEXPECTEDRESULTSTATUS
REF 0011,240.001,240.00Pass
REF 0023,815.503,815.50Pass
REF 003920.75920.75Pass
REF 00412,400.0012,400.00Pass
REF 0056,055.206,055.20Pass
LINEAGE
Every quote can be explained.
Lineage connects quote records to the sources and logic behind them, so sales can answer where a price came from.
✓Sources to transforms to entities✓Apps that show the final quote✓Schedules and run status
Quote lineage6 NODES
SOURCE
FILE
ENTITY
FUNCTION
ENTITY
APP
What it changes for each team
SALESFaster, consistent quotes.Every rep gets the same price for the same job.
ENGINEERINGRules in one place.No more hunting for the latest copy of the pricing sheet.
FINANCEMargins you can audit.Each quote links back to the inputs and logic that produced it.
THE DETAILS
For the people who will ask.
The specifics your architects and security reviewers will want before a rollout.
FUNCTIONPython, versioned with draft and promote
VALIDATION45 reference calculations
RECORDSQuote records connected to the function
INPUTSSmart, form or raw
ACCESSProject members and roles
DEPLOYMENTWhoDB Cloud or Managed Private
MANUFACTURING / PRICING45
Reference calculations validate the pricing engine.An industrial fabricator replaced brittle spreadsheet logic with a testable function and connected quote records. Customer details are anonymized in the published story.
Common questions
No. Most teams start with the one workflow that causes the most trouble, often pricing.
Keep exploring Industries
Industries overview →01Retail→Allocation plans from your own rules.02Warehousing and distribution→Receiving, put away, picking and stock.03Banking→Customer, account and risk data in one model.04Accounting and finance→Close faster with reconciled, traceable numbers.05Insurance→Policies, claims and pricing on one model.06Logistics and transport→Shipments, fleet and capacity in one place.07Wholesale and trade→Orders from every channel in one model.08Energy and utilities→Assets, readings and work orders connected.09Healthcare operations→Capacity, supplies and staffing on shared data.