Clarifies how completed milestone allocations, recorded local costs, and remaining budget are computed, with a practical evidence-led workflow. This guide is part of FRELUX’s educational library. It explains how to interpret a preliminary calculator output and how to keep the assumptions visible. It is not a substitute for project specifications, professional design, supplier quotations, legal advice, or local approvals.
The product is a budget and variance calculator, not escrow custody, payment processing, a regulated financial service, an audit opinion, or proof that funds were transferred. A milestone marked completed is a user-maintained status and must be supported by evidence outside the calculation. The future inflation calculation is a scenario, not a market forecast. An annual rate compounded over a number of months can help illustrate one assumption, but actual construction inputs may change at different rates and on different dates. Build a small scenario table with a low, base, and high rate based on dated evidence and replace the assumptions as supplier quotations arrive. The calculation is useful when its input boundary is clear and its output is treated at the right project stage. It cannot establish facts that were never supplied, independently confirm a site condition, or grant approval for construction, procurement, payment, or compliance. A consistent formula can make the same result reproducible; it cannot make an unsuitable assumption valid.
Clarifies how completed milestone allocations, recorded local costs, and remaining budget are computed, with a practical evidence-led workflow. The product is a budget and variance calculator, not escrow custody, payment processing, a regulated financial service, an audit opinion, or proof that funds were transferred. A milestone marked completed is a user-maintained status and must be supported by evidence outside the calculation.
The future inflation calculation is a scenario, not a market forecast. An annual rate compounded over a number of months can help illustrate one assumption, but actual construction inputs may change at different rates and on different dates. Build a small scenario table with a low, base, and high rate based on dated evidence and replace the assumptions as supplier quotations arrive.
n
A useful estimate begins by stating what decision it is meant to support. A concept-stage feasibility check, a quantity review, a tender comparison, a procurement schedule, and an issued-for-construction package have different evidence requirements. Write the intended stage and audience at the top of the worksheet. State what is included, what is excluded, who supplied the inputs, and which drawing or record revision was used. This prevents a preliminary calculation from silently acquiring the authority of a construction instruction. If the scope changes, preserve the earlier version and record what changed rather than editing history away. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Gather the primary source documents first: current drawings, schedules, specifications, surveys, supplier data, or financial records appropriate to the task. Check revision numbers, dates, units, naming conventions, and whether the information is approved or provisional. List missing inputs explicitly. Do not replace a missing dimension, rate, grade, or site condition with a plausible-looking default unless the interface clearly identifies it as an assumption and the reviewer accepts it. When several documents disagree, log the discrepancy and ask the responsible designer or project lead to resolve it before relying on the output. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
For each assumption, record its value, unit, source, date, reason, owner, and status. Separate confirmed facts from estimates, defaults, and unresolved questions. The distinction matters because arithmetic can be exact while its inputs remain uncertain. A result with two decimal places does not become more reliable merely because it is formatted precisely. When an input is changed, document the reason and compare the old and new result. If the app supplies a default, make sure the person using the result understands that the default is a convenience for a preliminary scenario, not evidence of local practice or project approval. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Before comparing quantities, confirm that both sides use the same unit system and scope boundary. A length may be measured along a centreline or to an outside face; a cost may include or exclude tax, delivery, labour, or fees; a material volume may refer to compacted output or loose supply. Write down the conversion factor and keep the source quantity visible. Avoid mixing nominal labels with physical equivalence: standards, products, and quality classes require explicit specification review. Unit conversion can preserve a physical dimension, but it cannot reconcile different engineering criteria or procurement definitions. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Recalculate at least one representative line independently, preferably using a hand check or a second reviewer. Check whether totals reconcile to component lines, whether rounding is applied at the right stage, and whether a zero or blank has a clear meaning. Test a small and a large case to notice discontinuities caused by whole-package rounding or preset thresholds. Review warnings and missing inputs; do not hide them in a screenshot or export. Where possible, retain the unrounded intermediate values and show how the displayed purchase quantity was derived. A transparent worksheet is easier to correct than a polished total with no traceable path. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
A quantity and a price answer different questions. A product price should identify the exact specification, supplier, market, currency, quotation date, tax treatment, delivery terms, and whether stock is actually available. A stale, unverified, or generic price should not be presented as a current local rate. Record price coverage separately from calculation coverage. If no defensible price is configured, leave the cost unpriced or request a dated quotation rather than multiplying a quantity by an unsupported placeholder. Keep labour, plant, transport, waste, taxes, and contingency visible as separate assumptions when they are relevant. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Give each calculation a project identifier, preparer, reviewer, date, source revision, and status. Keep an immutable exported copy for each decision gate, with the input assumptions included. If the design team revises a drawing or the sponsor changes a budget, create a new revision and explain the impact. Assign an owner to resolve open questions and set a due date. The review should ask not only whether the arithmetic is correct, but whether the inputs are authorized, the method is applicable, and the proposed use falls within the calculator’s limits. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
Stop using an estimate as soon as it would be asked to make a design, life-safety, legal, payment, or compliance decision that the tool does not support. Escalate to the appropriately qualified professional or authorized commercial party. Provide them with the source documents, assumptions, units, calculation output, unresolved questions, and the intended decision. The purpose of a preliminary tool is to make a discussion more informed, not to bypass professional review. A conservative, clearly marked unknown is safer and more useful than an invented value presented as certainty. For this topic, apply that discipline to the relevant records and questions rather than treating a default as a project fact. Ask who owns the input, how current it is, what unit and scope it uses, and what evidence will close any uncertainty. If the record is missing, mark it as missing and assign an owner to obtain it. That practice makes the estimate easier to revise and safer to share.
For a small exercise, select one element, location, or financial milestone and prepare a source-to-output trace. Record the source revision, relevant quantity, unit, rule, and any rounding. Ask a second person to reproduce the result without looking at the first calculation. Differences should be resolved through evidence, not by choosing the more convenient result. Keep the exercise clearly labelled as illustrative unless it is based on approved project information.
The word escrow has a specific custody and legal meaning that a calculation screen does not provide. Do not tell a sponsor that funds are protected or held in escrow because a tracker records budgets. Use a regulated and contractually appropriate service for custody, release conditions, dispute handling, identity checks, and applicable legal obligations. The tracker should complement, not replace, those controls.
The current tracker sums foreign allocations only for milestones marked completed, totals the local spending entered for all milestones, and converts that spend back to sponsor currency using the manually entered parallel rate. It then compares this equivalent spend with completed allocations and the sponsor budget.
No. The rates are entered by the user and the result is a scenario calculation. Record the source, time, rate basis, fees, and currency convention for every rate used. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
No. It does not hold, transfer, or safeguard funds and does not provide escrow custody, legal protections, payment execution, or dispute resolution. Use an appropriate regulated service and contract for those functions. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
The current engine sums foreign allocations for milestones marked completed. That status is a user-entered tracking signal, not proof of a transfer. Reconcile against bank and remittance statements. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
It compares local spend converted at the entered rate with allocations for completed milestones. It does not identify the cause. Review timing, scope, rate evidence, receipts, and milestone statuses before drawing conclusions. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
No. It applies the entered annual percentage and duration using a compounding formula. It does not draw on live inflation data or predict supplier prices; use documented scenarios and updated quotations. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.
Keep dated transfer confirmations, received amounts after fees, receipts, approvals, exchange-rate evidence, work certificates, commitments, milestone status changes, and a versioned local-currency ledger. For a project-specific decision, confirm the applicable specification and evidence with the responsible professional or authorized supplier.