Sáaaasda

Instruction 5 Using EXCEL 2007 to Calculate Earthwork cover section CE 102 laboratoryoratory Exercise (1) This instruction squeeze up stakes help you resolving power role 5 in the Lab. (2) Your completed spread shroud (including formulas and graphs) should be saved to your computer. (3) ------------------------------------------------- You leave send your completed spread tacking to the t individuallyers mailbox. Your charge must be sent before you leave the testing primer coat! In the previous labs you developed the cross sections for the site and do a preliminary analysis of the amount of water that aptitude be stored at the site. In last weeks lab you performed the preliminary hydrologic computations to predict peak runoff and essential gourmandize warehousing volume for the project site. In this lab you will determine the depth and the slope of the puddle (trapezium) so that the pond can contain approximate volume with gush storage volume you work outd. After that, you will train the amount earthwork for each cross-section. 1. Prepare: * Download file Lab5_6_Earthwork.xlsx from the 52NKN mailbox. * palliate this file in your computer, (using the Save As command) with your_name_Lab5 for new-fashioned file, for example, Thanh_Tu_Lab5.xlsx. * freshen the structure of the spreadsheet. You father 6 sheets and one of them is very important.

Cals sheet contains some pre-defined formulas to calculate linear interpolation. You do not repeal this sheet. * You have to calculate for 8 cross-sections and write a report to summariz e approximately the depth, the slope of the! pond, amount of cut and reside for each cross-section and total of them on a new sheet. 2. On the observe sheet: * Enter your last name, showtime name and check in cells B5:B7. 3. Go to the Design sheet: * In Lab 4, all of groups had the same result close water draw near elevation, so you can conjecture 1525 (water out elevation) into B3 cell and enter 9514.8 (total volume corresponds with water surface elevation above watch Lab 3) into...If you want to originate a full essay, arrangement it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper