Interactive Excel Program For Cut And Fill Computations In Road Design

     This paper presents the creation and usage of a program that generates three different design grade lines and calculates cut and fill. A design grade line refers to the state of soil during an iterative assumption. This grade line is then compared to the natural grade line, which is the initial profile state of the soil, to generate volumes. The final design grade line refers to ideal grading of compacted soil, wherein the difference between the generated volumes is within a given range or is the most cost efficient.

     Cut or excavation refers to the positive volume generated. In practice, this is the amount of removed soil in a given area. Fill or embankment refers to the negative volume generated. In practice, this is the amount of added soil in a given area.

     The researcher started this paper to enhance accuracy in calculating volume difference in road construction. Through the suggestions of the panels; he added a function wherein the most cost-efficient design grade line can be generated. He also created many more function for the convenience of the user.           The computer program that is being discussed in this paper is developed via Microsoft Excel 2010 version using its VBA feature. The program has sheets namely the Welcome, cut-fill, IMPORT, dgl-ngl, EXPORT and Data Point Locations sheets. The Welcome sheet has the buttons 3 POINT SURVEY and 5 POINT SURVEY buttons that will set the program in how to interpret your data. The cut-fill sheet has a the DGL, CLEAR IMPORT, IMPORT, and CLEAR TABLE buttons. Soil data and prices are also inputted in this sheet. The IMPORT sheet has the CLEAR TRACKS, Check for Redundant, Track Redundant and Delete buttons. Soil profile are inputted in this sheet.The dgl-ngl sheet depicts the graph of the natural grade line of soil and the generated design grade line. The Exportsheet contains the CREATE EXPORT and EXPORTFILE buttons. This sheet is responsible for creating .csv file. The Data point Locations is a graph showing the location of the survey point data inputted in the program.