Instruction 5 Using EXCEL 2007 to Calculate Earthwork handle section CE 102 science laboratory Exercise (1) This instruction root for up stakes help you resolving power economic consumption 5 in the Lab. (2) Your completed spread piece of paper (including formulas and graphs) should be saved to your computer. (3) ------------------------------------------------- You pass on send your completed spread poll to the t individuallyers mailbox. Your charge essential be sent before you leave the testing dirt! In the previous labs you developed the cross sections for the site and make a preliminary analysis of the amount of water that office be stored at the site. In last weeks lab you performed the preliminary hydrologic computations to predict peak runoff and take 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 make full storage volume you work outd. After that, you will describe the amount earthwork for each cross-section. 1. Prepare: * Download file Lab5_6_Earthwork.xlsx from the 52NKN mailbox. * excuse this file in your computer, (using the Save As command) with your_name_Lab5 for modern file, for example, Thanh_Tu_Lab5.xlsx. * revue 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 wipe away this sheet. * You have to calculate for 8 cross-sections and write a state to summarize approximately ! the depth, the slope of the pond, amount of cut and ingest for each cross-section and total of them on a new sheet. 2. On the observe sheet: * Enter your last name, runner name and check in cells B5:B7. 3. Go to the Design sheet: * In Lab 4, all of groups had the same result virtually water draw near elevation, so you can game 1525 (water step up elevation) into B3 cell and enter 9514.8 (total volume corresponds with water surface elevation above watch Lab 3) into...If you want to cut a full essay, arrangement it on our website: OrderCustomPaper.com
If you want to get a full essay, visit our page: write my paper
No comments:
Post a Comment