Earthwork-Quantity

Last updated: 2020-10-26

Example sheets:

090101-ew-01.pdf

090101-ew-02.pdf

  1. Review the FDM for file naming conventions: https://wisconsindot.gov/rdwy/fdm/fd-15-05-att.pdf#fd15-5a3.3

  2. Complete the Earthwork quantities volume calc (https://c3dkb.dot.wi.gov/Content/c3d/qnty/qnty-erthwrk.htm)

  3. Create Earthwork file speed sheet layout.

    1. WisDOT Sheets > Support > Palettes ON/OFF

    2. WisDOT Sheets > Sheet Creation > Earthwork

    3. Startup Main tab > Earthwork Data Speed Sheet

    4. Save file in 12345678\SheetsPlan\090101-ew.dwg

    5. Click Save.

  1. Spreadsheet was created using workflow here: http://www.c3dkb.dot.wi.gov/Content/c3d/qnty/qnty-erthwrk.htm

  2. Open the Excel spreadsheet from 12345678\Design\Quantities\EWKDetailWorkbooks\EWK-25.xlsx.

  3. In Excel, File > Options > Formula Tabs > Error Checking Rules. Uncheck both Formulas which omit cells in a region, and Unlocked cells containing formulas. Click OK.

    Info: This step is important since it turns green arrow error markers in cells off.The green arrow markers will appear in most cells of the Civil3D linked table causing confusion and clutter.

  4. Switch to the View tab of the ribbon > Show panel > Uncheck the Gridlines option.

  1. Open the EWK-25.xlsx file in Excel.

  2. Scroll to the right to see the Notes area (X11 through Z22).

    1. Widen the X, Y, and Z columns so all the text in these cells is readable.

  3. Select the X11 through Z22 cells, right-click and choose Copy.

  4. In Civil 3D, open 090101-ew.dwg.

  5. Home ribbon > Clipboard panel > Paste pull-down > Paste Special

    1. In the Paste Special dialog select the Paste Link button

    2. Select the Microsoft Excel Worksheet.

    3. Click OK.

  6. Place the frame of the Notes table at the bottom of the first frame.

  7. Repeat the Paste Special steps to place the Notes table at the bottom of the next several frames.

  1. In the Excel spreadsheet.

  2. Select the cells A2 through W93.

  3. Right-click and choose Copy.

  4. In Civil 3D, open 090101-ew.dwg.

  5. Home ribbon > Clipboard panel > Paste pull-down > Paste Special

    1. In the Paste Special dialog select the Paste Link button

    2. Select the Microsoft Excel Worksheet.

    3. Click OK.

  6. Move the data frame into the frame of Layout1. Click to place it inside the frame.

  1. Inspect where the data grid falls outside the Layout 1 frame or over the Notes table.

    1. If the frame is too wide

      1. Return to the Excel spreadsheet and adjust the columns to fit the table inside the frame.

      2. Save the file.

      3. Return to the 090101-ew.dwg file and notice the change to the inserted table. You may need to move the table to fit it more appropriately on the sheet.

    2. If the frame is too long

      1. Find the last full row that will fit on the sheet without overlapping the Notes table. Remember the station of the row that will be the last for the page.

    3. Copy the table cells that will fit.

      1. Return to the Excel spreadsheet.

      2. Scroll down to the table station that will fit on the page (row 50).

      3. Select the ROW BELOW that station’s row(51), right-click and choose Insert. Repeat this to insert a second row.

      4. Scroll to the top and select cells A2 through W6. Right-click and choose Copy.

      5. Select the A51 cell, right-click and Insert Copied Cells.

      6. This may create an extra unneeded row. Select that extra row (56) right-click and choose Delete. Select Shift cells up.

  1. Copy and paste the adjusted table data into the frames.

    1. Select the cells A2 through W46, right-click and choose Copy.

    2. Return to the 090101-ew.dwg.

    3. Delete the original table that was placed in the Layout1 frame.

    4. Home ribbon > Clipboard panel > Paste pull-down > Paste Special

      1. In the Paste Special dialog select the Paste Link button

      2. Select the Microsoft Excel Worksheet.

      3. Click OK.

    5. Place the table frame at the top of the Layout1 frame.

    6. Return to the Excel spreadsheet.

    7. Select the rows A48 through W99, right-click and choose Copy.

    8. Return to the 090101-ew.dwg.

    9. Home ribbon > Clipboard panel > Paste drop-down > Paste Special

      1. In the Paste Special dialog select the Paste Link button.

      2. Select the Microsoft Excel Worksheet.

      3. Click OK.

    10. Place the table frame in the Layout2 frame.

  1. Return to the Excel spreadsheet.

  2. Select the rows X56 through Z64, right-click and choose Copy.

  3. Return to the 090101-ew.dwg.

  4. Paste the Notes table below the second frame’s table.

    1. Home ribbon > Clipboard panel > Paste drop-down > Paste Special

    2. In the Paste Special dialog select the Paste Link button

    3. select the Microsoft Excel Worksheet. Click OK.

  5. If the tables are longer than the layout frame, return to the Excel spreadsheet to copy a smaller portion of the table.

  1. Add sheets to sheet set manually (https://c3dkb.dot.wi.gov/Content/c3d/pln-prod/pln-prod-basc/pln-prod-basc-sht-set.htm#add)