Road Estimate Excel Sheet / Software - How To Use

How To Use Road Estimate Excel Sheet / Software

STEP 1 :- Open the excel sheet in word 2007 or lower & click on "options" on top left as shown is image & a dialogue box will open, select "Enable this content", then click "OK".



- After enabling macro you will see such screen. 



STEP 2 :- Enter your project name (optional) & fill all the necessary data as R.L. of formation, width of formation, R.L. of ground, slopes, Gradient.

- If you have uniform distance between all your stations then enter uniform distance in "Distance b/w stations" & enter chainage or station number in "Chainage".
- If you have two different gradients then enter the value of S. no. upto which a gradient is being applied & select it is whether upward or downward gradient.



STEP 3 :- After filling all the necessary data click on "Calculate" button on Top Left.


- Then table will be filled up automatically.
- A chart also will be prepared on second page & rate table also will be filled up.


STEP 4 :- If you wish , enter rate per cubic meter (not for per cent-100 cubic meter) & then again click on "Calculate" button on page 1 as previous. rates will also be calculated automatically.


 STEP 5 :- Congratulations !!! Now save the file at any location as you prefer. 


- Feel free to comment your opinions. Thank You !

*To watch video explanation click - here.
*To download excel sheet/software click - here.
*Subscribe us on YouTube at - "Be Excelled"




Post a Comment

9 Comments

  1. This comment has been removed by the author.

    ReplyDelete
  2. How to prepare this sheet. Please guide

    ReplyDelete
    Replies
    1. For Better Understanding its Procedure Please Visit :-
      1. Blog - https://excelledengineering.blogspot.com/2018/10/how-to-use-road-estimate-excel-sheet.html
      2. Youtube - https://www.youtube.com/watch?v=ENMKP0cHk0s&t=36s

      Delete