Define the comparison boundary
Choose the exact activity you want the quotation to describe before comparing amounts. A broad phrase such as finish the house can conceal different work, materials and responsibilities. Write down the room or project reference, intended outcome and the documents supplied to each provider. For a fictional household gathering painting proposals in Harare, one offer might include preparation while another lists only application. Copy those descriptions accurately. This exercise is about organising information from actual written offers, not estimating a current market price, recommending a provider or deciding what the household should spend.
Separate every stated unit
Create fields for quotation date, stated currency, quantity, unit, rate, stated total and source page. Keep the provider's exact description beside any shorthand label you add. Do not combine different currencies or assume that a square-metre rate covers the same work as a room total. If the quote does not state the currency or unit, leave the comparison unresolved and ask the provider. In a paper exercise, use fictional values labelled practice only. Real tax treatment, exchange arrangements and transaction terms need current confirmation from the relevant qualified people; the worksheet supplies no default percentages or conversion rates.
Make exclusions part of the record
Add distinct columns for included work, excluded work, client responsibilities and clarification requested. Note whether transport, access arrangements, waste handling and final clean-up are actually mentioned, without assuming they must always belong to one party. If a description uses an unfamiliar product name, ask for the applicable manufacturer information and specification rather than replacing it with a guessed equivalent. Compare the same revised brief once the questions are answered. A lower displayed total is not evidence of a better offer if the scope differs, and a complete-looking quotation is not proof of credentials or technical suitability.
Check transcription before discussing choices
Read the worksheet against each original quotation line by line. Ask another participant to check one unit, one exclusion and one document date independently. If using LibreOffice Calc, validity rules can constrain new entries to an agreed list of units, but the software documentation warns that pasted or existing data may bypass such checks. Review those entries separately. Date each clarification and keep the original offer unchanged in the evidence folder. The result should be a clear set of comparable questions for the providers and appropriate advisers, not an automated ranking or an instruction to accept an offer.
Try a fictional comparison in which both totals are identical but one description excludes transport. Ask a reader what still needs clarification. If they immediately rank the offers, add the missing scope note more prominently and repeat the exercise before transcribing any real provider documents.
Sources & further reading
Use these references to check the underlying guidance and any current local requirements. Practical worksheets and illustrative examples in this guide are original educational material.
This guide is general information. Source notes are not a claim of independent professional review.