To draw up a consolidated estimate, prepare all previously created documents with the amounts that need to be taken into account. These include cost summaries, local tables, and landed costs.
Instructions
Step 1
Create a table in Excel with the following column names:
- number in order;
- name of works or products;
- the cost for one service or unit of goods;
- total amount;
- total cost;
- notes.
Enter all the data in the table in order, starting with the most important ones. In the notes, indicate what work has already been completed and what materials have been purchased.
Step 2
Create as many lines as there are activity types and item names to be entered. If after the transfer of information they are not enough, add additional ones. This can be done by highlighting the area where the necessary information will be entered. By clicking on the right mouse button, you will see the inscription "Add cells". Follow this link. A window will appear in which further actions are indicated. They can be used to add or remove individual rows or entire columns.
Step 3
To calculate the total, format the columns with numbers. Do this by selecting the required cells by clicking on the left mouse button. Then click on the right one and go to "Format Cells". Click on the "Number" tab. Select Numeric or Monetary.
Step 4
If you need to add cells that are not in order, use a formula. It can be entered by clicking on the fx designation at the junction of columns B and C. Select the rows, columns or individual numbers that you want to sum by clicking on the left mouse button. Click on the formula and the calculation will be done automatically.
Step 5
Be sure to format the columns with text to display the information correctly. Select the one you need and go to "Format cells". Select the first box "Number". Determine the format - "Text".
