To calculate an estimate in Excel, enter the quantity and unit price on each row. Multiply them to get each line total, then add those totals together. If you import the line items into 101, check the recognised rows and compare the total with the original spreadsheet before saving.
Contents:
How to calculate an estimate in Excel
Enter the work item in column A, the quantity in B, the unit price in C and the line total in D. In D2, enter =B2*C2. Copy the formula to the other rows with work items and check that each formula refers to its own row number.
| Row | A — work item | B — quantity | C — unit price, ₽ | D — formula and result, ₽ |
|---|---|---|---|---|
| 2 | Task A | 2 | 500 | =B2*C2 → 1000 |
| 3 | Task B | 3 | 200 | =B3*C3 → 600 |
| 4–10 | Other line items | Blank for now | ||
| 11 | Total | =СУММ(D2:D10) → 1600 |
In this example, D11 contains the total of 1600 ₽. Cell D11 is outside the range D2:D10 that it adds up. The table shows the function name in Russian-language Excel. In English-language Excel, enter =SUM(D2:D10) for the same calculation. For more examples, see Excel formulas for estimates.
What to check in the estimate
Check that the quantity and unit price use the same unit on each row. If the price is per square metre, enter the quantity in square metres too. When you add a row, check its formula and make sure its amount is included in the total range. Recheck the total after changing a quantity or price.
How to keep track of the current version
If several people work on the estimate, agree where to keep the working file and who accepts edits. Add the date or version number before sharing the estimate. Once the client agrees to the estimate, keep the agreed version so you can compare it with later changes.
How to import line items into 101
If the estimate allows custom line items, use the AI-assisted import. In the web version, you can upload an Excel file or paste copied rows. In the mobile app, copy and paste rows from the spreadsheet. AI prepares a list of line items. Check each name, unit and quantity against the spreadsheet, along with each unit price or internal cost value you can see. Correct any differences and fill in missing values. Then compare the total for the same rows and save the estimate. Step-by-step guide to importing line items from Excel.
What to share with the client
Show the list of work, quantities, units, prices and the total. If the client needs a separate document, export the estimate as a PDF and check the included items and client prices before sending it. Record agreed changes with the date and estimate version.
When to record planned and actual quantities separately
The estimate contains the planned work and costs. Once the work is complete, enter the actual quantities for the same line items in the work report (in Russian). Compare like-for-like items and units to see any differences. Record payment separately.
How to get started in 101
Choose one project and create an estimate for a stage (in Russian). If the expense category settings allow it, add items from the linked price list or import checked rows from the spreadsheet. Check the total, save the estimate and send it for approval.
