Estimator Application‎ > ‎Tutorial‎ > ‎

24. Use dim pad

The dim pad works with all formulas of open office calc. Look for more information in the open office calc tutorial.

Go to the row with specification number 10.

Click on the spreadsheet button.

Now enter the following values in the cells A5, A6, A7, A8: 100, 200, 300 and 50. These are some m3 measured from a hypothetical drawing. And enter in cell A1: =SUM(A5:A8).

As you see in the upper left part of the spreadsheet we find the sum of the values we entered. On the left you see that the quantity values has changed to this sum value. Click on the formula button to see what happens.

You see the sum formula appear in cell A1. Make column A a little bit more width.

You see the sum formula very clearly. Delete the values in cells: A5, A6, A7, A8. Make sure focus is on the spreadsheet and use the delete button.

Now enter the following values in the cells A5, A6, A7, A8: height, width, depth, volume.

Enter in the cells B5, B6, B7, B8: 10, 20, 4, =B5*B6*B7.

Make column B a little bit more width. That we can see the formula in cell B8.

Click on the formula button to see the result.

You see the result 800. Now put in cell A1: =B8.

The quantity value has changed from 0 to 800. Make depth: 5.

Click on the spreadsheet button to close the spreadsheet.