1 / 41

CREATING A GRADING MODEL FROM START TO END By Jim Schneider

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.

natan
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CREATING A GRADING MODEL FROM START TO ENDBy Jim Schneider

  2. PROGRAMS NEEDED • TEXTPAD • MICROSTATION • GEOPAK • CUSTOM VISUAL BASICS PROGRAMS • EXCEL

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

  4. 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)

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

  6. MICROSTATION • THE NEXT STEP IS TO OPEN THE KEY IN.

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

  8. MICROSTATION • TYPE IN VBA LOADAND HIT ENTER

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

  10. MICROSTATION • CHOOSE THE PROFILELEVINC.MVBA AND HIT OK. • THIS PROGRAM WILL PULL THE STATION AND PROFILE GRADES OUT OF GEOPAK.

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

  12. 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.

  13. 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

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

  15. VBA • CLICK THE ACTIVATE CHAIN/PROFILE BUTTON • THE BEGINNING AND ENDING STATIONING OF THE CHAIN SHOULD APPEAR AS SHOWN

  16. 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.

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

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

  19. 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.

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

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

  22. 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

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

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

  25. 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

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

  27. MICROSTATION MICROSTATION • GO BACK TO OUR CONSTRUCTION.DGN AND OPEN GEOPAK SURVEY. • CLICK ON (APPLICATIONS, GEOPAK SURVEY, SURVEY)

  28. GEOPAK • THE SURVEY TOOLBAR WILL APPEAR. • CLICK ON (DTM, BUILD DTM, FROM DAT FILE)

  29. 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.

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

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

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

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

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

  35. GEOPAK • THE LOAD DTM FEATURES DIALOG BOX APPEARS. • IN THIS DIALOG BOX MAKE SURE THAT THE TIN OPTION IS SELECTED.

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

  37. 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.

  38. GEOPAK • CLICK ON THE CONTOURS IN THE DIALOG BOX. • THIS WILL GIVE MORE OPTIONS ON THE BOTTOM OF THE BOX.

  39. 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

  40. 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.

  41. 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.

More Related