A never ending minor contention in cue sheet design is segment vs.
total miles. I use both, with cumulative miles first.
My cue sheets are ASCII files and have 4 columns;
cumulative miles, segment miles, action, and description.
Format, with column #s:
Cum Seg
Distances Action Description
12345678901234567890123456789012345678901234567890123456789012345
XXX.X XX.X TTTTTTT TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
45.7 0.6 X Daisy La. Ed Warfield---> Union Chapel Rd.
I have 2 programs, both in BASIC. BASIC can be seasoned to taste
by almost anyone. I and others use them. One can create a 2 mileage
column cue sheet with about 6k of s/w. Thus, this approach requires
little in the way of computer skills or resources. The volunteers
who create cue sheets should not also have to be s/w people.
ADDSEG.BAS Prompts one for filenames of input and output files.
It reads the input file and creates an output file
with a new segment miles column.
ADDTOT.BAS Prompts one for filenames of input and output files.
It reads the input file and creates an output file
with a new total miles column.
Common traits, ADDSEG.BAS & ADDTOT.BAS
1. Column locations, non-negotiable
-The decimal points are column 4 for the total miles column
and 10 for the segment column
-The Action column( turn right/left, cross, etc) is from col 12-19
-Street names start in column 21. The length is limited by BASIC
rules, or 230ish chars.
2. Case
Any lower case letter in cols 12-21 gets converted to upper case.
Thue, the Action col and the 1st letter in the description col
are upper cased.
3. Operation
The programs are smart enough not to change lines that do not have
mileage info on them. They do this by looking for a decimal point
in col 4(addseg.bas) or 10(addtot.bas). This means that any text NOT
used as a mileage line should not have a decimal point(i.e. period)
in col 4 or 10.
4. Usage will sometimes mean using one program, then the other. For
example, one may scout a ride, writing down odometer readings.
One can use those readings to create a total miles column. One
needn't start at odometer mile 0. Simply enter the odometer values
as seen. Then run the segment program to get segment miles from
the odometer. After that, run the total program so that the
totals column starts at 0.0 miles.
5. Enjoy!