How to make an estimate yourself

The ability to make estimates can be useful not only at work, but also at home. When planning repairs, building a garage or a cottage, you need to correctly calculate the amount of necessary materials and the cost of work.

You will need

Microsoft Offise Excel program.

Instruction manual

1

To make an estimate, it is best to use the Microsoft Excel program. It has a very convenient interface that will help not only to calculate the total amount, but also add or subtract certain columns, or replace one value with another.

2

To make an estimate table, hover over the upper left cell. It is indicated in the program as A1.

3

Holding the left button of the computer mouse, count six columns to the right (to cell F1). The number of lines should correspond to the number of items that need to be taken into account in the estimate.

4

Now write the column names. The first is the number in order. Use the symbol No. to indicate it. The second is the name. For example, when calculating repairs, building materials should be listed here. The third is the cost per unit of goods (price per 1 piece). The fourth column is the quantity. The symbol for this column is "qty." It is written in numbers, how many pieces of a particular item must be taken into account.

5

The fifth column is the total cost. The amount for all items of the same name is entered into it. To subsequently automatically calculate the total cost for all items listed in the estimate, perform the following steps:

- left-click to select the entire column;

- click on the right mouse button so that a table with actions appears;

- select "Cell format";

- there click on the first tab "Number";

- select the format "Numeric" or "Money".

Now, after filling in all the cells, it will be possible to calculate the total amount. To do this, select the entire column and find the symbol Σ (sigma) in the upper right corner. Click on this icon to add all the numbers in the desired column.

6

The sixth column is “Notes.” All additional information is written here. Where to buy the necessary items, what color they will be, delivery dates, etc. To display the text correctly, do the following:

- select all rows of the sixth column with the left mouse button;

- click on the right mouse button to display a table with actions;

- select "Cell Format";

- click on the first tab "Number";

- select the "Text" format.

Estimated design work