In the following video we process a set of EXCEL data that has all the required data just not in a usable form for TBC to consume. We write a CHATGPT Script that converts the spreadsheet into usable Station, Offset, Elevation data points and then use Cloud Services to import that data into TBC.
Once in TBC we then use Smart Map to create Linework between the points based on the Feature Coding we created on the points data during the Spreassheet conversion process.
In the AI Conversion process we do the following elements
- Remove the + in Station Fields
- Read 12.00’ Lt as -12.0 offset and 12.0’ Rt as 12.0 offset
- Read codes form a data line that says eg Cfm Offset - we strip the word Offset to create the root code. Then we read the Group Info from a second header line and add that to the code and then we add the L or R designator to the code to make the codes on the Left side of the road different to the codes on the right side of the road.
- We then order the data based on common codes first and then in order of increasing station. We then uniquely point number each point so that they are in line order and then write out an Excel File of Point ID, Station, Offset, Elevation, Code data that we can then open in Excel or Smart pane.
- We then copy the data from the Excel file and then p[aste it into the Cloud Services Tool to create the point data on the chosen layer
- We then uise Smart Map to create the linework from the points to complete the process
Video Shows You How
Alan