Products & rating

The product workbook: questions, rates and rules in one Excel file

Configure a whole product from Excel yourself: the Questions, Rates and Rules sheets, what is checked before saving, and how to update a live product.

Updated 13 November 2026 · Written and reviewed by the Soldek team

Your tariff, your application form and your acceptance guidelines probably already live in a spreadsheet. The product workbook is one Excel file with three sheets — Questions, Rates and Rules — that describes a complete product. You fill it in, upload it on the product's Workbook tab, check the preview and confirm. Nothing is estimated and nothing is saved until you say so. The same workbook fits every line of business; only the rows differ.

The three steps

  1. 1Open the product → Workbook tab → Download the workbook. An empty product gives you the three sheets with example rows and a How-to sheet that explains every column; a product that already has questions, rates or rules gives you the product exactly as it is today.
  2. 2Fill in the sheets in Excel. Replace the example rows with your own questions, your own tariff and your own rules. Keep the column headers.
  3. 3Upload the file in the same tab. Every line is checked and shown to you per sheet; lines the engine cannot use are listed with their row number. Fix the sheet and upload again, or confirm — only then is anything written.

The Questions sheet: what the application asks

question
The text the applicant sees, for example 'Occupation class'.
key
The short name the Rates and Rules sheets use to refer to it, for example occupation_class (letters, digits, underscores). Left empty, it is made from the question text.
type
choice, yes/no, date, number, amount, text or long text. Left empty: choice when options are given, otherwise text.
options
For a choice question: the answers, separated by commas — Office, Light manual, Heavy manual. When an answer contains a comma itself, separate the answers with | instead: Up to 1,000 | 1,000 to 5,000.
required
yes or no. Default yes.
section
An optional heading that groups questions on the form, for example Insured, Risk, History.

Questions are matched by key. Upload the same key again and the question is updated in place (wording, type, options, required flag); a new key is added at the end of the form. Nothing is deleted by an upload — remove a question on the Questions tab.

The Rates sheet: one row per price

type
base (one percentage of the sum insured), age, duration, question, or coverage for a loading on a coverage option of the product.
name
A label for the line, shown in every premium breakdown.
rate
For base: the percentage (0.8 or 0.8%). For a factor: the multiplier (1.25 means +25%).
question
For question factors: the key of the question the factor belongs to, for example occupation_class.
values
The answer(s) the factor applies to, comma-separated (or with | when an answer contains a comma), for choice or yes/no questions. For type coverage: the coverage options the loading applies to.
from / to
The band for age, duration or a numeric question: 50 to 64.
derive
age, when the band is read as years from a date-of-birth question or a year question (year of manufacture).

Per question one row applies: the first row of the sheet that matches the answer. The order of the sheet is the order the engine reads, so put an exception above the general row. The download gives the rows back in that same order.

The Rules sheet: one row per decision

name
A label for the rule, shown as the reason on a referred or declined submission.
outcome
accept, refer or decline. On a row below a rule: and or or, which adds that row's condition to the rule above it.
question
A question key, or one of the standard inputs sum_insured, age, duration or premium.
is
The comparison: > >= < <= = != in contains.
value
The number or the answer(s). For in: a comma-separated list, for example Office, Light manual.
derive
age, when the question is a date of birth or a year and the rule is about the age in years.

Example rows from the workbook: decline when sum_insured > 250000; refer when date_of_birth >= 70 (derive: age); accept when occupation_class in Office, Light manual.

A rule with more than one condition takes more than one row. The first row carries the name, the outcome and the first condition; each further condition is a row of its own with and (every condition must hold) or or (one is enough) in the outcome column. 'Refer heavy manual work above 250,000' is a refer row on occupation_class = Heavy manual followed by an and row on sum_insured > 250000. One rule uses and or or, not both; a guideline that needs both is two rules.

What is checked before anything is saved

  • Questions: a text, a unique key, a known type; a choice question needs at least two options.
  • Rates: at most one base line per sheet, with a percentage between 0 and 100 (leave it out when you only add factors to an existing product); multipliers between 0 and 50; a question factor needs either values or a from/to band.
  • Rules: an outcome, a question and a value; the comparison defaults to = when left empty. A greater-than or less-than comparison needs a number.
  • Numbers are accepted in European and British notation (1.250,50 and 1,250.50) and with or without a % sign.
  • Questions that Rates or Rules mention but the Questions sheet does not list are created for you with the type implied by their use — add them to the Questions sheet when you want to control the wording.
  • Up to 500 questions, 2,000 rates and 1,000 rules per upload.

Updating a live product

Download the product as a workbook, change what you need in Excel and upload it with 'Replace the product's current rates and rules' ticked. The rates and rules are swapped for the sheet in one go; questions are updated by key. An upload is applied as a whole or not at all: when one line is refused, the product is exactly as it was. Existing quotes and policies keep the values they were rated with, and the audit trail records the import.

The product check

A row the engine cannot use is skipped without a word, so the product tells you where that happens. The Workbook tab shows the product check for the whole configuration, the Rating and Rules tabs for their own part: a factor on an answer the question does not offer, a factor or rule on a question the form no longer asks, two rows of one question that overlap (only the first is used), a band that runs backwards, a product without a base rate or without rules. A clean check means every rate can apply and every rule can fire.

A tariff in a different layout

If your tariff is a matrix (ages down, packages across) or any other shape, reshape it in Excel into the Rates sheet first: one row per rate line, with the question key, the band or answer it applies to and the figure. The How-to sheet in the downloaded workbook shows the columns; the preview tells you exactly which lines the engine cannot read.

Questions

Do I need a different template for each product?
No. The workbook is the same for every product: Questions describe the form, Rates how the premium is built, Rules when to accept, refer or decline. Only the rows differ.
Do I have to use the workbook?
No. The Questions, Rating and Rules tabs edit exactly the same configuration one line at a time: add, change or remove a question, a rate row or a rule. Most teams start with the workbook and fine-tune on screen.
Can I upload only questions?
Yes. A workbook with just a Questions sheet builds or updates the application form; add Rates and Rules later.
What if a question in my sheet does not exist yet on the product?
List it on the Questions sheet and it is created with your wording and type. If you only mention it in Rates or Rules, it is created with the type implied by its use (a choice with the answers found, a date when derive = age — or a number when its name says year — a number for a band); you can change it on the Questions tab afterwards.

See it running.

Book a demo and we show you the complete platform live. Still stuck? Write to hello@soldek.io.