Creating a grading model from start to end by jim schneider
This presentation is the property of its rightful owner.
Sponsored Links
1 / 41

CREATING A GRADING MODEL FROM START TO END By Jim Schneider PowerPoint PPT Presentation


  • 53 Views
  • Uploaded on
  • Presentation posted in: General

CREATING A GRADING MODEL FROM START TO END By Jim Schneider. PROGRAMS NEEDED. TEXTPAD MICROSTATION GEOPAK CUSTOM VISUAL BASICS PROGRAMS EXCEL. GETTING STARTED. FIRST OF ALL WE NEED TO ACQUIRE THE FILES NEEDED TO ACCOMPLISH THIS TASK. FILES NEEDED.

Download Presentation

CREATING A GRADING MODEL FROM START TO END By Jim Schneider

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Creating a grading model from start to end by jim schneider

CREATING A GRADING MODEL FROM START TO ENDBy Jim Schneider


Programs needed

PROGRAMS NEEDED

  • TEXTPAD

  • MICROSTATION

  • GEOPAK

  • CUSTOM VISUAL BASICS PROGRAMS

  • EXCEL


Getting started

GETTING STARTED

  • FIRST OF ALL WE NEED TO ACQUIRE THE FILES NEEDED TO ACCOMPLISH THIS TASK.


Files needed

FILES NEEDED

ALL OF THESE FILES NEED TO BE PLACED INTO A COMMON WORKING DIRECTORY

  • BLANK EXCEL FILE

  • BLANK TEXTPAD FILE

  • CONSTRUCTION .DGN FILE (MICROSTATION)

  • E3DSEED04-COMMON .DGN FILE (MICROSTATION)

  • .GPK FILE (GEOPAK)


Microstation

MICROSTATION

  • FIRST THING IS TO OPEN UP THE CONSTRUCTION .DGN IN MICROSTATION


Microstation1

MICROSTATION

  • THE NEXT STEP IS TO OPEN THE KEY IN.


Microstation2

MICROSTATION

  • THE KEY IN IS WHERE YOU WILL INITIALIZE THE VISUAL BASICS PROGRAMS


Microstation3

MICROSTATION

  • TYPE IN VBA LOADAND HIT ENTER


Microstation4

MICROSTATION

  • THE NEXT DIALOG BOX THAT APPEARS ALLOWS YOU TO CHOOSE WHICH VBA YOU WISH TO USE.


Microstation5

MICROSTATION

  • CHOOSE THE PROFILELEVINC.MVBA AND HIT OK.

  • THIS PROGRAM WILL PULL THE STATION AND PROFILE GRADES OUT OF GEOPAK.


Microstation6

MICROSTATION

  • NEXT,TYPE IN VBA RUN INTO THE KEY IN. HIT ENTER.


Microstation7

MICROSTATION

  • THE NEXT DIALOG THAT APPEARS ALLOWS YOU TO RUN THE VBA. (MAKE SURE THAT THE VBA YOU LOADED IS THE ONE THAT APPEARS IN THIS BOX) AND CHOOSE RUN.


Microstation8

MICROSTATION

  • THE DIALOG BOX THAT APPEARS NEXT SHOWS THE VBA CHOSEN.

  • FILL IN THIS DIALOG BOX WITH THE INFO NEEDED TO EXTRACT THE STATIONING AND PROFILE GRADES OUT OF THE .GPK FILE


Creating a grading model from start to end by jim schneider

VBA

  • WHEN FINISHED, THE DIALOG BOX SHOULD LOOK LIKE THIS. (WITH THE .GPK FILE LISTED, CHAIN, AND PROFILE).


Creating a grading model from start to end by jim schneider

VBA

  • CLICK THE ACTIVATE CHAIN/PROFILE BUTTON

  • THE BEGINNING AND ENDING STATIONING OF THE CHAIN SHOULD APPEAR AS SHOWN


Creating excel file

CREATING EXCEL FILE

  • TYPE IN THE NAME OF THE BLANK EXCEL FILE (AS SHOWN) THAT IS IN YOUR WORKING DIRECTORY AND CLICK CREATE EXCEL FILE.


Excel

EXCEL

  • NOW THAT YOU HAVE CREATED THE BASIC EXCEL FILE TO START WITH, OPEN IT AND COMPLETE YOUR NOTES.


Excel1

EXCEL

  • ONCE FINISHED WITH THE NOTES IN EXCEL WE WILL SAVE IT AS A .CSV (COMMA DELIMITED FILE)


Textpad

TEXTPAD

  • NEXT OPEN THE .CSV FILE IN TEXTPAD.

  • THIS IS WHERE WE WILL EDIT THE FILE TO CHANGE IT FROM STATION, OFFSET, ELEVATION TO COORDINANTS AND ELEVATIONS.


Textpad1

TEXTPAD

  • THE EDITING NEEDED SETS THE COLUMNS TO STATION, RANGE, OFFSET, ELEVATION, OFFSET, ELEVATION, OFFSET, ELEVATION, ETC. AND SHOULD LOOK LIKE THIS


Textpad2

TEXTPAD

  • THE RANGE DENOTES WHERE THE ROAD IS BROKEN UP IN PARTS AS DICTATED BY THE STATION EQUATIONS.


Creating a grading model from start to end by jim schneider

VBA

  • WHEN THE TEXTPAD FILE IS COMPLETED THE NEXT STEP IS TO CHANGE THE STATION OFFSET ELEVATION FORMAT INTO COORDINANTS.

  • TO DO THIS, USE SOETODAT.MVBA


Creating a grading model from start to end by jim schneider

VBA

  • OPEN MICROSTATION AGAIN AND USE THE KEY IN AS BEFORE AND RUN THE SOETODAT.MVBA PROGRAM


Creating a grading model from start to end by jim schneider

VBA

  • NOW IN THIS DIALOG BOX FILL IN THE NAME OF THE TEXTPAD FILE JUST CREATED FOR THE INPUT SOE FILE:.


Creating a grading model from start to end by jim schneider

VBA

  • CREATE A .DAT FILE AND TO DO THIS, NAME IT BY TYPING IN A NAME IN THE OUTPUT (.DAT) FILE: LOCATION OF THE DIALOG BOX.

  • MAKE SURE THAT THE DROP DOWN SAYS CREATE

  • THEN CHOOSE CONVERT SOE TO .DAT BY CLICKING IT


Microstation9

MICROSTATION

  • NOW THAT WE HAVE A .DAT FILE CREATED WE CAN CONVERT THAT FILE INTO A .TIN MODEL BY USING GEOPAK.


Creating a grading model from start to end by jim schneider

MICROSTATION

MICROSTATION

  • GO BACK TO OUR CONSTRUCTION.DGN AND OPEN GEOPAK SURVEY.

  • CLICK ON (APPLICATIONS, GEOPAK SURVEY, SURVEY)


Geopak

GEOPAK

  • THE SURVEY TOOLBAR WILL APPEAR.

  • CLICK ON (DTM, BUILD DTM, FROM DAT FILE)


Geopak1

GEOPAK

  • IN THE DIALOG BOX THAT APPEARS CHOOSE YOUR .DAT FILE THAT YOU CREATED, AND GIVE A NAME FOR THE .TIN FILE THAT YOU ARE GOING TO CREATE.


Geopak2

GEOPAK

  • NEXT CHOOSE THE SIDE METHOD INSTEAD OF SLIVER, AND TYPE IN THE EXTENT WIDTH OF YOUR PROJECT FROM CENTERLINE.

  • THEN CLICK PROCESS.


Tin file

.TIN FILE

  • NOW THAT THE .TIN FILE IS CREATED, VIEW IT TO MAKE SURE THAT IT LOOKS CORRECT.


Microstation10

MICROSTATION

  • TO VIEW THE .TIN WE MUST OPEN THE E3DSEED04.DGN FILE.


Microstation11

MICROSTATION

  • ONCE IN THE MICROSTATION FILE, ACTIVATE THE GEOPAK SURVEY TOOLBAR AGAIN.


Geopak3

GEOPAK

  • CLICK ON THE DTM DROP DOWN AND SELECT LOAD DTM FEATURES.


Geopak4

GEOPAK

  • THE LOAD DTM FEATURES DIALOG BOX APPEARS.

  • IN THIS DIALOG BOX MAKE SURE THAT THE TIN OPTION IS SELECTED.


Geopak5

GEOPAK

  • NOW THAT TIN IS SELECTED, SELECT THE .TIN FILE THAT WE CREATED.


Geopak6

GEOPAK

  • WITHIN THIS DIALOG BOX WE HAVE TO TURN ON SOME FEATURES THAT WE WANT TO VIEW.

  • GO TO CONTOURS. TURN ON CONTOURS, MAJOR AND MINOR LINES.

  • THIS IS ALSO WHERE WE CAN SELECT THE COLOR THAT WE WANT THE CONTOURS TO APPEAR ON THE SCREEN.


Geopak7

GEOPAK

  • CLICK ON THE CONTOURS IN THE DIALOG BOX.

  • THIS WILL GIVE MORE OPTIONS ON THE BOTTOM OF THE BOX.


Geopak8

GEOPAK

  • CLICK ON READ AND IT WILL READ THE ELEVATION EXTENTS OF YOUR TIN.

  • SET THE CONTOUR LINE INTERVAL AT THIS POINT.

  • THIS EXAMPLE IS USING A MINOR INTERVAL OF 0.01, AND A MAJOR INTERVAL OF 0.10.

  • NEXT CLICK LOAD


Microstation12

MICROSTATION

  • THE TIN FILE SHOULD APPEAR ON YOUR MICROSTATION SCREEN.

  • ZOOM IN AND SCROLL YOUR WAY THROUGH THE JOB TO SEE IF THERE ARE ANY ERRORS OR IF SOMETHING DOESN’T LOOK RIGHT.


Conclusion

CONCLUSION

  • NOW THAT YOU HAVE CREATED A .TIN MODEL IT CAN BE EXPORTED AS A .TTM FILE AND HANDED TO THE CONTRACTOR FOR USE IN THEIR EQUIPMENT.

  • I LEFT A FEW ERRORS IN THIS MOVIE SO THAT YOU CAN SEE WHAT IT LOOKS LIKE WHEN THERE IS SOMETHING WRONG.


  • Login