TGH Tech
Case study · Workflow 02 of 20 · Win the work · Live

The whole estimate workbook goes in. An analysis and a customer quotation with no costs or margins come out.

Viya prices every house in an Excel workbook copied from the last similar job. Questions about a quotation pulled in senior people. Now the estimator attaches the workbook, picks which total is the basis and answers questions one at a time, while fixed logic reconciles every stage. Today the workflow produces documents and writes nothing to ProjectSignal. Budgets built from the estimate are in build.

Client
Viya Constructions
Department
Estimation, with sales
Starts from
One estimate workbook, in Excel
Gives you
An internal analysis and a customer quotation
Connected to
Nothing in ProjectSignal yet. Budgets are in build.
Status
Live. Live since 21 October 2026. Documents only today. Budgets from the estimate are in build.

[01]What changedViya Constructions

One total, chosen by a person. Every stage reconciled to it before a customer sees a number.

Before

One workbook, several possible totals.

  • Each estimate starts as a copy of the last similar job, old tabs included
  • In one real workbook, four cells could each pass for the total
  • Cost and commercial amount sit on the same rows
  • Quotation queries pulled in senior people
Now

Read whole, reconciled, then split in two.

  • Possible totals are listed from visible sheets, and the estimator picks one
  • Stages must add back to that total within one paisa, a hundredth of a rupee
  • Every finding and every score cites a sheet and a cell
  • The customer quotation carries a fixed list of fields: no cost, margin or profit
  • 200,000
    filled cells read per workbook, at most
  • 7
    quality checks, each scored 0 to 5 with cell evidence
  • 3
    rounds of questions, at most
  • 268
    line items reconciled across 27 stages in the verification run

From the workflow's rules and its verification run on a real workbook, 21 October 2026.

The quotation is the number a customer holds the company to, and the file behind it also shows what the house costs. This workflow checks the first and keeps back the second. It has been live for Viya's estimation team since 21 October 2026.

[02]Why this is hardViya Constructions

The estimate workbook is a working file. It was never built to be handed to a customer.

Builders who price in Excel know these.

  1. 01

    Copied workbooks carry old tabs

    Each estimate starts from the nearest earlier job. In the workbook used to verify this workflow, 20 of 37 sheets were hidden, and different sheets carried different versions and scopes.

  2. 02

    Cost and price share a row

    Every line is costed first, then given a commercial rate and amount a few columns across. Sales, management, purchase and planning all open the same file.

  3. 03

    Errors look like numbers

    A broken reference or a sum over the wrong range still produces a plausible figure. That workbook held 7,998 formulas. Nobody checks 268 lines by hand before a customer meeting.

  4. 04

    Words disagree with amounts

    A line called discount whose amount is added to the total. A heading that says stainless steel handrail above a detail that says galvanized iron. Arithmetic catches neither. A customer might.

[03]How it worksViya Constructions

Eight steps from workbook to quotation. A person chooses the basis and answers every question about money.

The estimator types "/", picks the job and attaches the workbook.

  1. 01The workflow

    Read the whole workbook

    Every sheet is read, hidden ones included: cell addresses, formulas and the values Excel last saved. A formula with no saved value is reported as unavailable, never treated as zero.

  2. 02Fixed logic

    List the possible totals

    Totals are looked for on visible sheets only, and only in the commercial amount column, never the cost column beside it.

  3. 03Estimator confirms

    Choose the basis

    The estimator picks one. The card accepts only a listed total: the basis cannot be guessed or put off.

  4. 04Fixed logic

    Reconcile the stages

    The chosen total is opened into its stages by following its sums down through each subtotal. If the stages do not add back to it within one paisa, the gap is reported and no customer quotation is produced.

  5. 05The workflow

    Score and question, with cells as evidence

    Fixed checks come first: a discount line that adds to the total, a handrail specified two ways, error cells on the chosen sheet. Then the AI scores seven quality checks from 0 to 5 and marks each stage may be reduced, should not be reduced or needs review. A finding that cannot cite a real cell on a visible sheet is dropped.

  6. 06Estimator confirms

    Answer one question at a time

    Each question shows why it is asked and the cells behind it. The estimator picks an option, types an answer or attaches evidence. After the third round, documents are produced with remaining issues stated.

  7. 07Fixed logic

    Two documents, two readers

    The internal analysis is always produced. The customer quotation, in PDF and Excel, is produced only when the total reconciles and no broken reference is confirmed as affecting it.

  8. 08The workflow

    Revise in chat

    The AI matches a change asked for in plain words to the lines it names. Fixed logic prices it, using only numbers the estimator typed. Each accepted change makes a new numbered revision, without a new upload.

A discount line is settled by a person, never by the AI.

When a line named discount carries a positive amount, the workflow stops and asks. The four answers are fixed, and fixed logic applies the one the estimator chooses.

  • Treat it as a deduction and the amount turns negative
  • Remove it and the line leaves the quotation
  • Leave it unresolved and that line, with anything calculated from it, stays locked
Clarify the quotation · Question 2 of 6
Asked becauseA line named Discount adds to the totalFixed check
Source cellSummary sheet, D31: 85,000
AnswerTreat it as a deductionChosen
Other answersKeep the amount as quoted · Remove this amount · Leave unresolved for now
Illustrative. Made-up sheet, cell and figure. The four answers are the workflow's own.

[04]Connected to ProjectSignalViya Constructions

Today this workflow produces documents. It reads and writes nothing in ProjectSignal.

  1. Reads

    From ProjectSignal

    • Nothing. The estimator attaches the workbook.
  2. Does

    What happens in between

    • Reads the attached workbook
    • Reconciles the stages to the chosen total
    • Asks, then applies the changes the estimator typed
    • Builds the analysis and the customer quotation
  3. Writes

    To ProjectSignal

    • Nothing today. The documents are saved in Bleno.

It runs without a ProjectSignal sign-in and has no sending step.

Several other Viya workflows do write to the platform: as the signed-in person, within that person's permissions, through the platform's own validation and after a preview. This one has nothing to write yet.

What the estimate feeds next is in build. On 1 November 2026 Viya decided to build Viya Estimator, which reads an estimate and BOQ (bill of quantities) and turns them into labor and material budgets per stage and work item. Purchase requests, work orders and purchase orders in ProjectSignal are then checked against those budgets. This workflow passes nothing to Viya Estimator today. Before the plan was written, we traced one real 37-tab estimate cell by cell: 10 tabs feed the price. The Signal Estimator page has the full account.

  1. Sales call filed
  2. Estimate check and quotation
  3. Agreements
  4. Budgets per stage, in build

[05]Who decides whatViya Constructions

The AI reads. Fixed logic calculates. A person confirms.

StepDone by
Reading sheets, formulas and saved valuesThe workbook reader. No AI.
Listing totals, opening the total into stages, reconciling within one paisaFixed logic
Which total is the basisThe estimator, from the listed totals only
Findings, the seven scores, the label on each stageThe AI, kept only where a real visible cell is cited
How a discount line is treated, and whether broken references affect this quotationThe estimator. The AI cannot settle either.
Which lines a change request refers toThe AI proposes. Anything unclear comes back as a question and nothing is applied.
Every changed amount and the revised totalFixed logic, using only numbers the estimator typed
What a customer file may containA fixed list of fields
Sharing the quotation with the customerA person, outside the workflow

No approval or sending step today. A commercial approval card before customer documents are released is the recorded next step.

[06]More detailViya Constructions

The rules it follows

What it refuses, what it checks, what it never does.

For the estimation head who will ask how it decides.

RuleWhat it does
Saved valuesUses the values Excel last saved and does not recalculate. The analysis says so.
Where a total can come fromVisible sheets and the commercial amount column only. At most 40 are listed.
Kind of totalOnly a total built by adding. A circular subtotal, or one that counts a cell twice, is refused and the cell is named.
Detail linesLines on other visible sheets are attached to a stage only when they add up to it within one paisa. A change to one then rolls up into its stage.
Quantity and rateShown on a line only when quantity times rate equals its amount within one paisa.
Percentage linesA line worked out as a percentage of other lines keeps that basis and is recalculated when those lines change.
Broken referencesError cells are counted across the workbook. Only those on the chosen total's sheet raise a question. If the estimator says they affect this quotation, the customer quotation is withheld.
Cell evidenceA score with no real cell on a visible sheet stays empty, and a stage without one is marked needs review. Hidden sheets are never shown to the AI.
The seven checksCompleteness, descriptions, calculations, material specifications, inclusions and exclusions, readability and discussion readiness. Each runs from 0, absent or unusable, to 5, complete and supported.
Overall scoreThe average of the seven as a mark out of 100. Given only when all seven are scored with evidence. Otherwise it reads "Needs confirmation".
Stage adviceStructural work is not called non-negotiable on its name alone. A zero design cost is not read as design being left out.
What the AI may not doInfer a price, a rate, a quantity, structural safety, market competitiveness or a saving. No discount is applied automatically.
Numbers in a changeEach must appear in the estimator's own instruction, or in evidence the estimator asked to use. If any part is in doubt, none of the request is applied.
Unreconciled or negative totalPrice changes are refused until the total reconciles. So is any change that takes the quotation below zero.
After a changeThe revision number goes up by one, scores reset to "Needs confirmation", and each changed line keeps its before, its after and the instruction behind it.
Customer wordingSpecifications are copied from the workbook's own cells, never reworded. An open question becomes a neutral note. One that mentions cost, margin or profit never reaches the customer.
What goes in, what comes out

One workbook in. Up to two documents out, per revision.

ItemFormatDetail
In: estimate workbookExcelOne file. A revision continues from the earlier run and does not read the workbook again.
In: choice of total and answersReview cardsOne listed total. Then an option or typed text per question, up to 2,000 characters.
In: evidenceAttached filesKept for the internal record. Uploading a file does not answer a question.
In: change requestPlain words in chatA percentage change needs a stated percentage and basis.
Out: internal analysisPDFTotals, reconciliation, the seven scores, recommendations, stage advice with customer questions, clarification answers, change history, source limitations.
Out: customer quotationPDF and ExcelQuoted scope, total, specifications, changes in this revision and notes. Priced items where detail lines exist.

In the verification run the internal analysis ran to 10 pages and the customer quotation to 14.

What it means for you

Four readers, four answers.

  1. For owners

    Margin stays inside the company

    The customer file is built from a fixed list of fields. Cost columns and hidden sheets never reach it.

  2. For estimation heads

    Checked before the meeting

    Every stage is reconciled to the total you chose. Each doubt arrives as a question with its cell.

  3. For sales

    A position on every stage

    Each stage carries a label, its evidence and a prepared customer question and answer. Nothing is discounted on its own.

  4. For your technical person

    Workbook text is data, not instructions

    Cell contents are treated as untrusted data. Formula-like text is stored as plain text in the customer Excel. The workflow has 23 automated tests.

Is this your problem too?

Four signs, and what we would need to start.

  • Each new estimate starts as a copy of an old workbook
  • More than one sheet carries a figure that could be the total
  • The file that sets the customer's price also shows your cost
  • Quotation queries go to the same one or two senior people

To start we need one real estimate workbook, one owner in estimation and thirty minutes a week. The discount and handrail checks here were written from patterns in a real Viya workbook. Yours will have its own, and we write those from your files.

How many cells in your estimate workbook could pass for the total?

Send us one real estimate workbook. We will come back with how the check would run on it and what a first version would look like. Start with one workflow. You only pay if it works.