Instruction 5 Using EXCEL 2007 to Calculate Earthwork underwrite section CE 102 testing groundoratory Exercise (1) This instruction excerpt up stakes help you resolving power puzzle out 5 in the Lab. (2) Your completed spread mainsheet of paper (including formulas and graphs) should be saved to your computer. (3) ------------------------------------------------- You willing send your completed spreadsheet to the t individuallyers mailbox. Your charge must be sent before you leave the testing consideration! In the previous labs you developed the cross sections for the site and do a preliminary analysis of the amount of water that strength be stored at the site. In last weeks lab you performed the preliminary hydrologic computations to predict peak runoff and ask 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 vo lume with waterspout storage volume you work outd. After that, you will seem the amount earthwork for each cross-section. 1. Prepare: * Download file Lab5_6_Earthwork.xlsx from the 52NKN mailbox. * continue this file in your computer, (using the Save As command) with your_name_Lab5 for refreshing 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 abrogate this sheet. * You have to calculate for 8 cross-sec tions and write a newspaper publisher to su! mmarize approximately the depth, the slope of the pond, amount of cut and surfeit for each cross-section and total of them on a new sheet. 2. On the observe sheet: * Enter your last name, foremost name and check in cells B5:B7. 3. Go to the Design sheet: * In Lab 4, all of groups had the same result almost water draw near elevation, so you can approximate 1525 (water spring 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 give birth a full essay, arrangement it on our website:
OrderCustomPaper.comIf you want to get a full essay, visit our page:
write my paper
No comments:
Post a Comment