TOTAL YDS1 O+ COMPACTED +ILL Prepared by Minnesota Board of Water & Soil Resources 06/17/02 Version !0
SUR+ACE AREA O+ EMBANKMENT (ACRES
2022 2022
CLICK PRO+ILE TAB TO SEE A /RAPHIC REPRESENTATION O+ EMBANKMENT
12!00
10!00
) . T F ( N O I T A V E L E
#!00
6!00
"!00
2!00
0!00 0
2
"
$MB%'M$(
6
S)B*)(
STATION (FT.)
#
$+,S(,- -R.)
10
*.R$
12
Instructions/tips for using BSWR Earthwork-St Spreadsheet
The spreadsheet is “Protected”, meaning that only certain cells c with a white background may be edited or have info. entered into Cells with a red triangle in the upper right corner have “Tool Tips them. ust place the pointer in one of these cells and a bo! will a about what that cell does or what values should be entered into it. The "st station entered should be the beginning station of the plan e!ample$ %our profile runs from &'&& to (')&. %our embankmen station entered must be “"&”. *f your embankment starts at &'&&, entered must be “&”, etc+ The elevation of the "st station entered must be eual to the value Embankment Elevation field. *n order for the subcut uantity to calculate correctly, the -nd stati within " or - feet of the " st station and the -nd e!iting ground elev tenths less than the "st e!isting ground elevation. Conversely, the should be within " or - feet of the last station and the - nd to last e elevation should a few tenths less than the last e!isting ground el Example$ the "st value is station 0 with an e!isting ground elevati value should be station " with an e!isting ground elevation of ((. applies to the end of the series. *f the last value is station & with elevation of "&& ft., than the second to last value should be statio ground elevation of ((.( ft. This will force the spreadsheet to cal and ending points of the subcut in the correct spots. Clicking the Profile tab at the bottom of the spreadsheet gives the information entered. This page has been si/ed to print out so that trimmed and be manually placed on the 0123 standard design s the need to hand draw the profile and should save people not usin on C45 a lot of time. *f anyone has problems using the spreadsheet or has any uestion contact$
