Review the saved financial record and its payment state separately.
From an Excel estimate to a usable project budget
A practical guide to checking an Excel construction cost structure, importing it to a project and validating the budget baseline before use.
A spreadsheet becomes a useful project baseline only when its scope, structure and assumptions are understood. Before import, identify the workbook version, check that the estimate is complete, and agree which totals, exclusions, allowances and risk items are part of the control budget.
Crystal Quant supports an Excel cost-structure import workflow. After importing, compare the project structure with the workbook: verify item descriptions, units, quantities, rates, extensions, tax treatment where relevant and section totals. Resolve any mapping or rounding differences before the project team treats the imported values as approved.
Record the baseline date and approval, then define how commitments, changes, valuations and actual costs will be captured. Decide who may change the baseline and how revisions are reported. A budget is not a static spreadsheet; it needs a controlled change process and regular reconciliation.
Use Crystal Quant as a project workflow, not as an independent audit of an estimate. Keep the original workbook and the agreed review record according to your document-control procedure.
Important limitations
- Import support does not guarantee that every workbook layout or formula is interpreted as intended.
- Budget approval, accounting treatment and cost forecasts remain the project team's responsibility.
- The workflow is in functional Beta and may change.
Does importing Excel prove the estimate is correct?
No. Import transfers a supported cost structure into the project workflow; the estimator or project team must check the result against the original workbook and underlying scope.
What should I check after importing?
Compare descriptions, units, quantities, rates, totals, exclusions and the intended budget baseline. Investigate any differences before approving the project values.
Can the imported budget replace our finance system?
Do not assume that it can. Agree which records remain in your accounting system and how project controls are reconciled with finance.
Connect the programme to procurement without treating dates as facts
Practical steps for using programme dates to plan package tender timing while checking lead times, scope, approvals and delivery constraints.
A procurement plan should reflect when a package is needed on site, how long the procurement process may take and what information bidders require. Start with the programme's required-on-site dates, then work backwards through realistic tender periods, review and approval time, order placement and known lead times.
In Crystal Quant, a project programme and tender packages can be managed as connected project workflows. Use task dates to prompt package planning, then confirm dates with the project team, suppliers and subcontractors. Check that package scope and project information are sufficiently complete before inviting bids.
Treat the resulting sequence as a coordination plan, not a guarantee. Track assumptions and changes, update the programme when decisions move, and make the current revision clear. A late design decision, unavailable product or changed site sequence can invalidate earlier procurement dates.
Important limitations
- The platform does not guarantee supplier availability, lead times or delivery dates.
- Programme and procurement boundaries, approvals and commitments remain the team's responsibility.
- AI-generated suggestions require review and Beta capabilities may change.
Does Crystal Quant automatically create a procurement schedule from the programme?
The platform provides programme and tender workflows, but users must plan and verify the relationship between tasks, packages, lead times and approvals.
What should be checked before issuing a package?
Check scope, drawing and specification revisions, bidder list, tender period, required-on-site date, approvals and any known constraints.
Are AI programme dates reliable commitments?
AI-assisted programme output is a draft, not a commitment. Review logic, durations, calendars and project constraints before using it.
A practical drawing revision-control routine
A practical drawing-register process for recording revisions, checking issue status, communicating changes and avoiding reliance on superseded drawings.
A drawing register helps a team identify documents consistently, but it only works when the project agrees how revisions are recorded and communicated. Establish the drawing number, title, originator, revision, status and issue date fields your team needs, and name the person responsible for maintaining the record.
When a new file arrives, check its identifier and revision against the transmittal or issuing source. Record it, review the change, identify affected work and notify the people who need to act. Mark superseded information clearly according to your document-control process; do not rely on filename alone to establish current status.
Crystal Quant's drawing register includes structured drawing metadata and associated files. Use it as part of the agreed process, and confirm the authoritative issue with the designer or document controller before construction use. AI-assisted classification or review can help organise information but cannot replace a technical check.
Important limitations
- The register is not a substitute for a controlled document issue process or design approval.
- AI-assisted classifications and observations must be verified against source documents.
- Feature availability and workflow depth may change during Beta.
What is the first check when a drawing revision arrives?
Confirm the drawing identifier, revision and issue status with the issuing source or transmittal, then compare it with the register and identify affected work.
Does a drawing register automatically stop teams using superseded drawings?
No. It supports identification and tracking, but communication, access control and site document procedures are still needed.
Can AI approve drawing revisions?
No. AI assistance may help with classification or review, but a competent person must verify the drawing and make any technical or approval decision.
Frequently asked questions
What is NRM classification and why is it important?
NRM (New Rules of Measurement) provides a structured way to categorise construction costs. Crystal Quant supports NRM-aligned estimating; review the classifications, quantities and rates before relying on an estimate.
Do I need a template to upload an Excel estimate?
No. In New → Custom Estimate → Upload Excel file, choose your own Excel or CSV cost schedule; the example template is optional. Claude analyses structure, while source amounts and totals require validation and your review. If permitted, Create draft project saves incomplete costs to finish later. Use Remove file or Start new project to discard the current upload or attempt deliberately.
How does the tender management system work?
Prepare the tender scope and packages, select the appropriate saved project files, invite bidders, compare responses and record the authorised award decision. Check document revisions and recipients before issuing. An invitation does not grant access to all project files, and an award is not a signed contract.
Can I view and annotate PDF drawings?
Open Project Information → Drawing Register and use the row's PDF icon. Choose the annotation tool and mouse, touch or Pencil input mode, then check Saved before closing. Measurements require page-specific calibration verified against a known dimension. Area is displayed in m²; a printed scale is not proof of accuracy.
Why are drawing numbers or revisions blank?
Embedded text reading can miss a title block, and scanned PDFs may contain no usable text. Inspect the original legend, edit the register cells, and Save changes. Optional local OCR or AI fill blanks can help, but every proposed value still needs review. A filename or extracted revision does not decide which drawing is approved or current.
Can I track multiple projects simultaneously?
Use the projects available to your account and switch to the correct project before editing. During functional Beta, registered users can access currently available Beta workflows at no cost. Any post-Beta project limits have not yet been published.
What does Crystal Quant cost?
Currently available functional-Beta features are free for registered users, with no payment card required. Published post-Beta prices are Premium at £29.99 per seat/month and Enterprise at £99.99 per seat/month, each with a three-seat minimum. Final paid-plan inclusions and post-Beta Free-plan limits have not been published; check Pricing for the current statement.
How does the JCT contract system work?
Crystal Quant provides functional-Beta contract-administration workflows for selected JCT 2016 families, including SBC, DB, IC and MW. It does not provide licensed JCT contract documents, legal advice or certification of contract validity. Appropriate licences and professional review remain your responsibility.
How does the cash flow system work?
Cash Flow shows invoice income, expense outflows and net cash flow, with due or planned amounts distinguished from paid amounts. A valuation is not itself cash received: its linked invoice represents income. Review uncertain historical links before counting them, and do not create duplicate receipts.
How do I verify and screen subcontractors?
Use the available company review and verification workflows and inspect the actual supporting evidence. Companies House data can help check company details, but a listing, imported company or profile approval does not itself establish external compliance. Automated checks and third-party data do not grant marketplace verification by themselves; an authorised reviewer must make the appropriate decision.
Why is a button disabled or a tab missing?
Check the company/project selection, required fields, a pending save and the record's draft or issued status. Actual company membership, project access and action permissions determine access; a job title alone does not. Ask an authorised administrator to review the specific permission rather than using another person's account.
How do interim valuations and expense suggestions work?
Create a draft, assess actual completion, review this-period and cumulative values, save and resolve any errors before submitting. Expense-based percentages are suggestions, not proof of work completed. Submission and certification retain issued evidence and are separate from invoicing and actual payment. Review PDF and Excel approval documents; do not overwrite an issued original.
How do I add costs for additional work?
In Variations, link an existing cost item or use the new additional-work option for an Excel/custom project. NRM projects can use the available unused NRM element option. The tracking allocation and any permitted internal allowance are separate from the client variation price. Record actual expenditure through normal expense entries; internal approval is not client agreement.
Why does procurement need budgets and programme dates?
Prepared packages should be supported by saved budget scope and linked programme activities. Inspect those links and the Gantt dates, resolve missing sources and review lead-time assumptions. Do not retain unsupported packages. Ordering, supplier commitments and verified receipt are separate states.
How are Prepare TO DO Actions proposals created?
Proposals use the saved programme and purchasing plan. Review each source, deliverable, assignee and due date, exclude irrelevant actions, and publish only what you intend to create or update. A proposal is not an order, payment or programme amendment, and completing a reminder does not verify a delivery.
Why could project files not be loaded?
The message does not by itself mean files were deleted. Retain unsaved work, check your connection and sign-in, confirm the selected project and access, and use Retry. If it persists, send private support the time, action, device/browser and a redacted screenshot, not confidential files or credentials.
Why can I not save report or daily reminder settings?
Report scheduling and daily reminder settings can have separate permissions. A permission-denied response requires an authorised administrator to review that specific access. For a network or server error, retain the settings and retry where offered; do not assume a failed request was saved.
Can every directory or marketplace listing be ordered?
No. Discovery, verification, ordering and financial access are different. Inspect the supplier and product's available actions and terms. A preloaded product or company listing is not automatically verified or orderable, and a contact match does not prove ownership of a supplier account.
Where should suppliers start?
Use the supplier onboarding and portal workflow available to your account, complete your business details and inspect the product, enquiry or order actions enabled for you. Keep supplier identity and company authorisation separate from a public directory listing.
Where should professionals start?
Complete your professional profile, then use the Professional Portal for available appointments, project work and invoicing. Access to discipline-specific records depends on the appointment and permissions; professional status does not grant access to every project.
Where should tradespeople and subcontractors start?
Tradespeople can start with their profile, availability, jobs and payslips in the Tradesperson Portal. Subcontractors should review company details, network discovery and the permitted tender-response workflow. Advertised rates do not automatically change an employer's agreed rate or payroll records.