I routinely have to do the following workflow:
Map GPS points;-
Create lines based on those GPS points;
Split the lines at a set interval distance (every 50m, every 100m etc.)
Add from / to fields for chainages along the line.
I use ModelBuilder to automate this process as much as possible, but to generate the chainages, I need to use Excel because I have very limited experience with Python. So I generate the chainage values in Excel, then in the editor context in ArcGIS copy those values from Excel into the attribute table of my polyline features.
How can I transfer the logic I have in my Excel sheet over to Python to use in the Calculate Field tool within ModelBuilder?
The format of the from / to fields ends up being "K+MMM" where the K is the kilometer and the M's represent meters. So if I've got a starting point of 0km and 0m and an interval of 100m, the first chainage would read "0+000", followed by "0+100", "0+200".
Here are some screenshots of the logic in the Excel file: https://i.sstatic.net/DUUYT.jpg