Step Detail
- Florida Department of Transportation Workflows
- 1. Florida Department of Transportation Tools
- 1.0 - Create Project
- 2.0 - Create Files
- 3.0 - Entity Manager
- 3.1 - Create Pay Item Database for New Project
- 3.2 - Open the Project's Pay Item Database
- 3.3 - Draw Entity with Pay Item
- 3.4 - Append a Pay Item to an Entity
- 3.5 - Append Multiple Pay Items to an Entity
- 3.6 - View Pay Item(s) on an Entity
- 3.7 - Edit Pay Items on an Entity
- 3.8 - Validate Entities with Pay Items
- 4.0 - Quality Control Inspector Suite
- 5.0 - Sheet Set Organizer
- 2. Importing Survey Data
- 3. Existing Features Workflow
- 4. Right of Way Workflow
- 5. Urban and Rural Highway Design Workflow
- 1.0 - Data Sharing
- 2.0 - Alignment Layout
- 3.0 - Superelevation
- 4.0 - Profile Design
- 5.0 - Typical Sections
- 6.0 - Roadway Model - Corridors
- 7.0 - Cross Sections
- 6. Intersection Design - Structures Workflow
- 7. Plans Production Workflow
- 1.0 - Overview of Plans Production Workflow
- 1.1 - Introduction to Plans Production in Civil 3D
- 1.2 - Prepare Plotters
- 1.2.1 - Open the FDOTMaster.DWT
- 1.2.2 - Identify Which Offset You Wish to Modify
- 1.2.3 - Set the Origin of the Bottom Left Corner to be the Bottom Left Corner of the Paper
- 1.2.4 - Setup or Locate the Printable Area Margins
- 1.2.5 - Modify the Paper Sizes and Margins
- 1.2.6 - Modify the Plot Offset Origin
- 1.2.7 - Notes
- 1.1 - Introduction to Plans Production in Civil 3D
- 2.0 - Create Plan Sheets Manually
- 3.0 - Create Plan Sheets using Alignments
- 3.1 - Create the View Frames for Plan and Dual Plan Sheets
- 3.1.1 - Create the CLIPRD##.DWG
- 3.1.2 - Data Reference the Alignment in the New Drawing
- 3.1.3 - Confirm the Alignment Style is Not Set to _No Display
- 3.1.4 - Zoom to Extents
- 3.1.5 - Run the View Frame Wizard
- 3.1.6 - Keep the Defaults for the Alignment
- 3.1.7 - Select the Template You Will Use for Your Plan Sheet
- 3.1.8 - Change the Name of the View Frame Group
- 3.1.9 - Setup the Match Lines for the Sheet
- 3.1.10 - Clean Up the Drawing Before Saving It
- 3.1.11 - Share the View Frame Group(s)
- 3.2 - Create the Plan or Dual Plan Sheets (PLANRD##.DWG)
- 3.2.1 - Create the CLIPRD##.DWG
- 3.2.2 - Data Reference the Alignment
- 3.2.3 - Confirm the Alignment Styles is Not Set to _No Display
- 3.2.4 - Zoom to Extents
- 3.2.5 - Data Reference the View Frame Group
- 3.2.6 - Confirm the Referenced View Frame Group Settings
- 3.2.7 - XREF and Data Reference Any Additional Information
- 3.2.8 - Start the Create Sheets Wizard
- 3.2.9 - Adjust the View Frame Group and Layout Settings
- 3.2.10 - Set the Correct Settings in the Sheet Set Options
- 3.2.11 - Confirm the Drawings are Correct
- 3.2.12 - Delete Extra Layout Tabs
- 3.2.13 - Manually Create the Dual Plan Sheets
- 3.2.14 - Paste the Data from the Second Sheet into the First
- 3.2.15 - Proceed to the Next Two Tabs
- 3.2.16 - Clean Out the DST
- 3.1 - Create the View Frames for Plan and Dual Plan Sheets
- 4.0 - Create Cross-Section Sheets
- 4.1 - Create Section Views - RDXSRD##.DWG
- 4.2 - Create Section Views within the DSGNRD##.DWG
- 4.3 - Create Section Views to an External File
- 4.3.1 - Create the RDXSRD##.DWG File
- 4.3.2 - Set the Scale for Your Sheets
- 4.3.3 - Data Reference the Alignment
- 4.3.4 - Zoom to Extents
- 4.3.5 - Attach the DSGNRD##.DWG File as an External Reference
- 4.3.6 - For Ease of Viewing, Send the XREF to the Back
- 4.3.7 - Open the Sample Line Toolbar
- 4.3.8 - Create Sample Lines
- 4.3.9 - Create Multiple Section Views
- 4.4 - Create the Section Sheets for Plotting
- 4.1 - Create Section Views - RDXSRD##.DWG
- 5.0 - Create Profile Sheets
- 5.1 - Create the View Frames for CLIPRD##.DWG
- 5.1.1 - Create the CLIPRD##.DWG
- 5.1.2 - Data Reference the Alignment in the New Drawing
- 5.1.3 - Confirm the Alignment Style is Not Set to _No Display
- 5.1.4 - Zoom to Extents
- 5.1.5 - Data Reference All the Profiles
- 5.1.6 - Setup the Appropriate Styles
- 5.1.7 - Data Reference Additional Objects
- 5.1.8 - Start the View Frame Wizard
- 5.1.9 - Select the Alignment
- 5.1.10 - Set the Sheet Settings
- 5.1.11 - Set the View Frame Group Name
- 5.1.12 - Set the Positioning of the Match Lines
- 5.1.13 - Set the Correct Profile View Values
- 5.2 - Create the Profile Sheets (PROFRD##.DWG)
- 5.1 - Create the View Frames for CLIPRD##.DWG
- 1.0 - Overview of Plans Production Workflow
- 8. Drainage and Utilities
- 9. Quantity TakeOff with FDOT Enhancements Workflow
- 1. Florida Department of Transportation Tools
2.3.3 - Import Quantity Takeoff XML Data
Step Description:
Go to the Raw Data tab and clear any data from the form so that the XML file can be imported into the new file.
Next, Import XML file by going to the Developer tab in Microsoft Excel 2007, then select Import. Navigate to the XML file created earlier. This will Import all the data from the XML file into the spreadsheet with the correct headings for the data.
Go to a Type tab and click on the first line of data and then pull it down to see all the other lines of data. You will also see totals at the bottom as well. Click Save to save Excel data file at the top of Excel.
For more information watch the video below:
Quantity Takeoff (WMV)
Next, Import XML file by going to the Developer tab in Microsoft Excel 2007, then select Import. Navigate to the XML file created earlier. This will Import all the data from the XML file into the spreadsheet with the correct headings for the data.
Go to a Type tab and click on the first line of data and then pull it down to see all the other lines of data. You will also see totals at the bottom as well. Click Save to save Excel data file at the top of Excel.
For more information watch the video below: