Converting back and forth between minutes and seconds to get your splits is tedious, so I wrote a simple python program to do it. Maybe MS excel does it for you, but I wouldn't know, I haven't used any MS products in almost a decade. This will work on a Mac from the shell window (renamed to splits.txt to upload. rename it back to splits.py and make it executable with chmod to run it, but you knew that if you use a Mac, right?)
$ cat 500-20080413.txt | ./splits.py
31.88 31.88
1:06.17 34.29
1:40.66 34.49
2:15.71 35.05
2:50.31 34.60
3:24.67 34.36
3:58.76 34.09
4:33.59 34.83
5:08.66 35.07
5:43.08 34.42
ah, I can't get python format strings to work like I'm used to other languages behaving. change __str__ if you want seconds 't get python float format strings to behave.
if (self>60):
return '%d:%02d.%02d' % (self / 60, self % 60, 100 *((self % 60) - int(self % 60)))
else:
return '%02d.%02d' % (self % 60, 100 *((self % 60) - int(self % 60)))
I do all my LMSC Top Ten record-keeping in Excel, so I can answer this for people who want to track times in that program (not saying it is the best, but I can get the job done with it just fine). This post will undoubtedly raise my perceived geek factor, but maybe some people will find it useful.
Times can be a little tricky in Excel but just remember the distinction between the FORMATTING and the actual VALUE. If you type in something like "4:46.18" it will assume you are typing in a time (time of day or duration, doesn't matter). The display looks just as you type it (except it may round the decimal place) but the VALUE it stores is actually the fraction of the day of the time, in this case 0.003312269. (More technically, this is a serial number that represents the time elapsed from a date of Jan 0, 1900.)
Keeping in mind that the value is fraction of a day, converting to seconds is easy:in an empty cell, type the formula "= *24*60*60" where refers to the cell with the time. Make sure the formatting in the cell with the formula is "normal" (ie, general number format) and not "time." Use the cell properties to check or change the formatting if something is screwy.
If you type in a time -- and want it treated as such, for example in formulas that calculate cumulative/subtractive splits -- don't forget to include the minutes. For example, a 50 time of 30.29 should be entered as "0:30.29" or (if entered in a cell that expects a time/date) Excel assumes that 30.29 refers to DAYS and gives you something that corresponds to 6:57:36AM on Jan 30, 1900 (ie, 30.29 days from Jan 0 1900; the value actually displayed depends on the formatting of the cell).
Entering "0:30.29" avoids that mess; you can get rid of the leading zero if you don't like it through custom formatting (PM me if you want to know how, there is only so much geekiness the general population can take).
Converting back and forth between minutes and seconds to get your splits is tedious, so I wrote a simple python program to do it. Maybe MS excel does it for you, but I wouldn't know, I haven't used any MS products in almost a decade. This will work on a Mac from the shell window (renamed to splits.txt to upload. rename it back to splits.py and make it executable with chmod to run it, but you knew that if you use a Mac, right?)
$ cat 500-20080413.txt | ./splits.py
31.88 31.88
1:06.17 34.29
1:40.66 34.49
2:15.71 35.05
2:50.31 34.60
3:24.67 34.36
3:58.76 34.09
4:33.59 34.83
5:08.66 35.07
5:43.08 34.42
ah, I can't get python format strings to work like I'm used to other languages behaving. change __str__ if you want seconds 't get python float format strings to behave.
if (self>60):
return '%d:%02d.%02d' % (self / 60, self % 60, 100 *((self % 60) - int(self % 60)))
else:
return '%02d.%02d' % (self % 60, 100 *((self % 60) - int(self % 60)))
I do all my LMSC Top Ten record-keeping in Excel, so I can answer this for people who want to track times in that program (not saying it is the best, but I can get the job done with it just fine). This post will undoubtedly raise my perceived geek factor, but maybe some people will find it useful.
Times can be a little tricky in Excel but just remember the distinction between the FORMATTING and the actual VALUE. If you type in something like "4:46.18" it will assume you are typing in a time (time of day or duration, doesn't matter). The display looks just as you type it (except it may round the decimal place) but the VALUE it stores is actually the fraction of the day of the time, in this case 0.003312269. (More technically, this is a serial number that represents the time elapsed from a date of Jan 0, 1900.)
Keeping in mind that the value is fraction of a day, converting to seconds is easy:in an empty cell, type the formula "= *24*60*60" where refers to the cell with the time. Make sure the formatting in the cell with the formula is "normal" (ie, general number format) and not "time." Use the cell properties to check or change the formatting if something is screwy.
If you type in a time -- and want it treated as such, for example in formulas that calculate cumulative/subtractive splits -- don't forget to include the minutes. For example, a 50 time of 30.29 should be entered as "0:30.29" or (if entered in a cell that expects a time/date) Excel assumes that 30.29 refers to DAYS and gives you something that corresponds to 6:57:36AM on Jan 30, 1900 (ie, 30.29 days from Jan 0 1900; the value actually displayed depends on the formatting of the cell).
Entering "0:30.29" avoids that mess; you can get rid of the leading zero if you don't like it through custom formatting (PM me if you want to know how, there is only so much geekiness the general population can take).
Converting back and forth between minutes and seconds to get your splits is tedious, so I wrote a simple python program to do it. Maybe MS excel does it for you, but I wouldn't know, I haven't used any MS products in almost a decade. This will work on a Mac from the shell window (renamed to splits.txt to upload. rename it back to splits.py and make it executable with chmod to run it, but you knew that if you use a Mac, right?)
$ cat 500-20080413.txt | ./splits.py
31.88 31.88
1:06.17 34.29
1:40.66 34.49
2:15.71 35.05
2:50.31 34.60
3:24.67 34.36
3:58.76 34.09
4:33.59 34.83
5:08.66 35.07
5:43.08 34.42
ah, I can't get python format strings to work like I'm used to other languages behaving. change __str__ if you want seconds 't get python float format strings to behave.
if (self>60):
return '%d:%02d.%02d' % (self / 60, self % 60, 100 *((self % 60) - int(self % 60)))
else:
return '%02d.%02d' % (self % 60, 100 *((self % 60) - int(self % 60)))
