Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Drainage

VIEWS: 5 PAGES: 11

									   Information
1. Set up the first sheet with the headings and formats desired. Error
   messages will appear until the file is saved. If more than one sheet is
   desired, copy the desired unit worksheet by holding the left mouse button on
   the worksheet's tab (below) and holding the <CTRL> key. A mini sheet with
   a plus sign should appear. Drag this and drop it where you would like the
   sheet to be (order is not important). Be sure that the Sheet Names in the
   chart on this page match the tabs. To modify the sheet names, double click
   on the tab. Sheet names may be modified, however make sure that modified
   names match the names shown in the table below.

2. If you want to automatically sync the headers of the remaining sheets with
   the first sheet, copy (CTRL-C) the red and blue "Formula" cell in this
   paragraph. Go to the destination cell(s) and either right click and choose
   from the menu OR
   "Paste Special" select Edit, Paste Special. Select the Formulas            0
   button and OK. DON'T DO THIS TO THE FIRST SHEET!

3. Rows and columns may be moved and inserted. The sheet will not move. Do
   not delete the rows above and to the left of the sheet border. Ensure that all
   content fits onto the sheet border. The width of the last columns and the
   height of the last row should be adjusted so that they correspond to the
   sheet border.

4. To print, highlight the entire area covered by the sheet and print the
   selection.
5. Errors will show up until the sheet is saved.

   Constants
  Insert the following values. They will appear on every sheet.

    State:                       ID            Note: If there is
                                               more than one project
                                               number, use
    Project:            PRA-CRMO 10(2)         <ALT><ENTER> to
                           Second line         insert page break for
                            Third line         additional lines.
    Designed by:       A. Designer
      Date:                   --/----
    Checked by:        D. Checker
      Date:                   --/----
    First sheet number:         H.1
    Units:                    Metric           Note: Unused base unit sheet may be deleted.


   Sheet Names
  Input the names of the worksheets in the order you would like the
  sheets numbered.
               Order Worksheet Name        Sheet
                      ** leave blank **    Undefined
 1   Metric                H.1
 2   Metric (2)            Undefined
 3   Metric (3)            Undefined
 4   Metric (4)            Undefined
 5   Metric (5)            Undefined
 6   Metric (6)            Undefined
 7   Metric (7)            Undefined
 8   Metric (8)            Undefined
 9   Metric (9)            Undefined
10   Metric (10)           Undefined
11   Metric (11)           Undefined
12   Metric (12)           Undefined
13   Metric (13)           Undefined
14   Metric (14)           Undefined
15   Metric (15)           Undefined
16   Metric (16)           Undefined
         * Worksheets *            * Sheets *

                   Revised: 18 July 2007
If you want to automatically sync the headers of the remaining sheets with
the first sheet, copy (CTRL-C) the red and blue "Formula" cell in this
          0
choose "Paste Special" OR from the menu select Edit, Paste Special.
Select the Formulas button and OK. DON'T DO THIS TO THE FIRST SHEET!
Sheet Information                                                                                         [    M E T R I C             U N I T S            C H O S E N           ]
  Sheet number:    #N/A  Filename
 Previous sheet: #N/A    C:\Docstoc\Working\pdf\[2e005592-7162-4d83-9333-69698eb9ba65.xls]US_Customary
                         Time
Worksheet name: US_Customary
     Next sheet: #N/A    20-Nov-2012 1:36 AM




                          --/----
                                                                                                                                                                                                                                                                                                                                         STATE           PROJECT
                                                                                                      Note: The quantities shown
                                                                                                      hereon are approximate and are
                                                                                                      subject to field adjustments.
                                                                                                                                                                                                     TABULATION OF DRAINAGE QUANTITIES                                                                                                    ID         PRA-CRMO 1
                                                                                                                                                                                                                                                                                                                                                       Second lin
                                                                                                     10.4 x 16                                                                                                                                                                                                                                          Third line

                                                                                                                                                   20301                     25101                       60201              60213    60401   60403              60701       60704         60707      60801        62011
                                                                                                              PAY ITEM NUMBER
                                                                                                                                         -1200     -1400      -1900      -1000   -2000       -0600   -0800 -0900    -1000    -100    -0000   -1200              -1000       -0000     -0500 -0600    -0200    -0500 -0600      Allow.
                                                                                                                                                                                                                                                             Removing,                                                          Pipe           BEVELS
                                                                                                                       EST                                                Placed riprap,                                    Branch                                         Cleaning                  Paved    Stone masonry   Material          1V:nH
                                                                                                                                                  Removal                                                                                     Inlet           cleaning,                Lining pipe
                                                                                                                       MAX STR EXC                                      energy dissapator            Pipe Culvert           Connec- Manhole                                culverts                  water-    headwall for
                                                                                                       STATION                                     (Each)                                                                                   type 5A              and                     culvert
                          D. Checker                                                                                  COVER (CUYD)                                           (CUYD)                     (LNFT)                tion                                         in place                   way,     pipe culvert
                                                                                                                                                                                                                                                             stockpiling                 (LNFT)                               (See key
                                                                                                                       (ft)                                                                                                  (Each)                                                                  type 2                    below)
                                                                                                                                         Head-                 Pipe                                                                  (Each)  (Each)            culvert     (Each)                                (Each)
                                                                                                                                                    Inlet               Class 1   Class 2                                                                                                                                                      Lt   Rt
                                                                                                      DIAMETER or SPAN x RISE (inch)      wall               Culverts                        450     600     750    900       600                               (Each)                600     750    (Each)   600     750
          #N/A                                                                                                 #N/A             #N/A     #N/A      #N/A       #N/A       #N/A         #N/A   #N/A    #N/A    #N/A   #N/A      #N/A    #N/A    #N/A    #N/A       #N/A       #N/A      #N/A    #N/A    #N/A    #N/A   #N/A
                                                                                                     2345+67                                                                                                                                                                                                                               1.5
                                                                                                        4+00 Rt                                                                              300
                          --/---- Checked by:
                          A. Designer
                          Designed by:
                           20-Nov-2012 1:36 AM




                                                                                                                                 8
                           stoc\Working\pdf\[2e005592-7162-4d83-9333-69698eb9ba65.xls]US_Customary




    Don't delete row ->                                                                                        #N/A             #N/A     #N/A                                                #N/A    #N/A    #N/A   #N/A     #N/A    #N/A    #N/A     #N/A     #N/A         #N/A      #N/A    #N/A            #N/A   #N/A

                                                                                                                 NOTE:                                                                                                                                                                                                              Allowable pipe culvert
                                                                                                                1. Steel pipe culvert minimum wall thickness is the larger of ____" or the thickness required                                                                                                                 A         Aluminum
                                                                                                                by the Std. 602-1 fill height table.                                                                                                                                                                          AS        Aluminized steel
                                                                                                                2. Aluminized steel pipe culvert minimum wall thickness is the larger of ____" or the                                                                                                                         C         Concrete
                                                                                                                thickness required by the Std. 602-1 fill height table (steel).                                                                                                                                               GS        Galvanized steel
                                                                                                                3. Aluminum pipe culvert minimum wall thickness is the larger of ____" or the thickness                                                                                                                       P         Plastic
                                                                                                                required by the Std. 602-1 fill height table.                                                                                                                                                                 (blank) Any appropriate m
                                                                                                                4. Plastic pipe is not allowed when final installation is exposed. Furnish metal end sections for                                                                                                             X/__      Any appropriate m
                                                                                                                all plastic pipe including those specified with bevels. See Std. 602-5 for acceptable cell class.                                                                                                                        except __
C:\Docstoc




             5. See Std. 602-7 for acceptable concrete cell class.
  STATE        PROJECT          SHEET
                               NUMBER
            PRA-CRMO 10(2)      #N/A
              Second line
               Third line




                    FOOTNOTES

                  See below for
                numbered footnotes




Allowable pipe culvert material

    Aluminized steel

    Galvanized steel

    Any appropriate material
    Any appropriate material
Sheet Information
  Sheet number:     H.1                     Filename
 Previous sheet: None                       C:\Docstoc\Working\pdf\[2e005592-7162-4d83-9333-69698eb9ba65.xls]Metric
Worksheet name: Metric                      Time
     Next sheet: None                       20-Nov-2012 1:36 AM




                          --/----
                                                                                                                                                                                                                                                                                                                             STATE             PROJECT
                                                                                                Note: The quantities shown
                                                                                                hereon are approximate and are
                                                                                                subject to field adjustments.
                                                                                                                                                                                           TABULATION OF DRAINAGE QUANTITIES                                                                                                    ID        PRA-CRMO 1
                                                                                                                                                                                                                                                                                                                                            Second lin
                                                                                               10.4 x 16                                                                                                                                                                                                                                     Third line

                                                                                                                                           20301                    25101                       60201                 60213    60401   60403           60701       60704         60707      60801        62011
                                                                                                     PAY ITEM NUMBER
                                                                                                                                  -1200    -1400      -1900     -1000   -2000      -0600    -0800 -0900       -1000    -100    -0000   -1200           -1000       -0000     -0500 -0600    -0200    -0500 -0600      Allow.
                                                                                                                                                                                                                                                    Removing,                                                          Pipe          BEVELS
                                                                                                               EST                                               Placed riprap,                                       Branch                                      Cleaning                  Paved    Stone masonry   Material         1V:nH
                                                                                                                                          Removal                                                                                       Inlet        cleaning,                Lining pipe
                                                                                                               MAX STR EXC                                     energy dissapator             Pipe Culvert             Connec- Manhole                             culverts                  water-    headwall for
                                                                                                 STATION                                   (Each)                                                                                     type 5A           and                     culvert
                          D. Checker                                                                          COVER (m3)                                             (m3)                        (m)                    tion                                      in place                   way,     pipe culvert
                                                                                                                                                                                                                                                    stockpiling                   (m)                                (See key
                                                                                                               (m)                                                                                                     (Each)                                                               type 2                    below)
                                                                                                                                  Head-               Pipe                                                                     (Each)  (Each)         culvert     (Each)                                (Each)
                                                                                                                                            Inlet              Class 1   Class 2                                                                                                                                                     Lt   Rt
                                                                                                DIAMETER or SPAN x RISE (mm)       wall             Culverts                        450      600      750     900       600                            (Each)                600     750    (Each)    600    750
    Leave line blank ->
                                                                                               234+567                                                                                                                                                                                                                           1.5
                                                                                                 0+400 Rt                                                                           300
                          --/---- Checked by:
                          A. Designer
                          Designed by:
                           20-Nov-2012 1:36 AM




                                                                                                                          8
                           stoc\Working\pdf\[2e005592-7162-4d83-9333-69698eb9ba65.xls]Metric




    Don't delete row ->                                                                          PROJECT TOTAL            8         0                                               300       0        0       0        0        0       0      0       0            0        0        0               0      0

                                                                                                         NOTE:                                                                                                                                                                                                             Allowable pipe culvert
                                                                                                         1. Steel pipe culvert minimum wall thickness is the larger of ____ mm or the thickness required                                                                                                             A         Aluminum
                                                                                                         by the Std. M602-1 fill height table.                                                                                                                                                                       AS        Aluminized steel
                                                                                                         2. Aluminized steel pipe culvert minimum wall thickness is the larger of ____ mm or the                                                                                                                     C         Concrete
                                                                                                         thickness required by the Std. M602-1 fill height table (steel).                                                                                                                                            GS        Galvanized steel
                                                                                                         3. Aluminum pipe culvert minimum wall thickness is the larger of ____ mm or the thickness                                                                                                                   P         Plastic
                                                                                                         required by the Std. M602-1 fill height table.                                                                                                                                                              (blank) Any appropriate m
                                                                                                         4. Plastic pipe is not allowed when final installation is exposed. Furnish metal end sections for                                                                                                           X/__      Any appropriate m
                                                                                                         all plastic pipe including those specified with bevels. See Std. M602-5 for acceptable cell class.                                                                                                                     except __
C:\Docstoc




             5. See Std. M602-7 for acceptable concrete cell class.
  STATE        PROJECT          SHEET
                               NUMBER
            PRA-CRMO 10(2)       H.1
              Second line
               Third line




                    FOOTNOTES

                  See below for
                numbered footnotes




Allowable pipe culvert material

    Aluminized steel

    Galvanized steel

    Any appropriate material
    Any appropriate material

								
To top