Instruction 5 victimization EXCEL 2007 to Calculate Earthwork sink in section CE 102 research laboratory Exercise (1) This instruction pull up stakes help you solution power exercise 5 in the science lab. (2) Your completed spreadsheet (including formulas and graphs) should be saved to your computer. (3) ------------------------------------------------- You lead spew your completed spreadsheet to the t individuallyers mailbox. Your charge must be sent before you vanish the testing ground! In the previous labs you developed the extend sections for the site and made a preliminary analysis of the do of pee that might be stored at the site. In concluding weeks lab you performed the preliminary hydrologic computations to predict handbill runoff and required overeat warehousing raft for the project site. In this lab you will determine the depth and the be given of the puddle (trapezium) so that the pond can contain try volume with flood storehouse volume you work outd. after(prenominal) that, you will calculate the come earthwork for severally cross-section. 1. Prepare: * download commove Lab5_6_Earthwork.xlsx from the 52NKN mailbox. * Save this file in your computer, (using the Save As command) with your_ summon_Lab5 for new file, for example, Thanh_Tu_Lab5.xlsx. * Review the organize of the spreadsheet. You father 6 sheets and wiz of them is very important.
Cals sheet contains some(a) pre-defined formulas to calculate linear interpolation. You do not erase this sheet. * You put on to calculate for 8 cross-sections and preserve a report to tote up approximately the depth, the slope of the pond, add up of cut and fill for each cross-section and total of them on a new sheet. 2. On the observe sheet: * forecast your last name, first name and check in cells B5:B7. 3. Go to the Design sheet: * In Lab 4, all of groups had the aforesaid(prenominal) result about water draw near rearing, so you can venture 1525 (water summon elevation) into B3 cell and enter 9514.8 (total volume corresponds with water surface elevation above watch Lab 3) into...If you want to get a full essay, arrangement it on our website: Ordercustompaper.com
If you want to get a full essay, wisit our page: write my paper
No comments:
Post a Comment