We've seen many of these threads, and they always end up the same -- otherwise intelligent posters not getting the concept of 2*pi()*r, and not quite grasping the concept of nominal measure vs actual measure of a track.
I've added a LaneMeister module (I like saying 'module') to my upgraded version of the PaceMeister. Hopefully, I've laid it out in such a manner that everyone will finally "get it."
http://2008olympictrialsakatommyleonard.shutterfly.com/filecabinet
Nice program, I'm going to save it.
One question. Lane width. Does that refer to the lane width in between the white lines dividing the lanes, or is the lane width from the leftmost of the left white line to the left most of the right white line? Put another way (if my description is too confusing), does the lane width include one of the lines dividing the lanes or just the lanes themselves between the white lines?
Another unrelated question (but related to Excel). Do you know how to correctly organize dates chronologically in the format dd.mm.yyyy? All of the all-time athletics records (ex.
http://www.alltime-athletics.com/mmaraok.htm
) are listed this way and it would be neat to create more stats for athletes easier.
I forgot to mention that I know how to use a period (".") delimiter to put the parts of the date in different columns, but I don't know how to sort them chronologically with all of them depending on each other.
Easier rule of thumb: 2 seconds per lap per lane.
800m in lane two ~ 4 sec slow. If you need to know EXACTLY how far you are running (which is really almost never), learn the staggers or run in lane one.
Your description isn't too confusing. I don't have the answer to that. The lanes whether or not measured on center or on edge will still be the same width.
Your second question, copy/paste in text format, then text to columns. Manipulate the colums then concatenate MANUALLY. CELL&"/"&CELL&"/"&CELL.
Chris, I see the problem. I have tricks to crack these goofy formatting issues. Let me see if I can crack this one too.
Usually it involves copying a column then pasting it onto a text document like an email, then recopying back to excel.
It worked.
Chris this is the biggest trick that I have when manipulating the formatting from websites. When you have a problem like that, copy the data (just the column you want to 'clean' of formatting) to a TEXT ONLY formatted Outlook email. Then recopy it back to Excel.
In this case I was able to then sort by date, and here's what I got for the top 30 times of that link.
10/31/2010
9/26/2010
9/26/2010
9/26/2010
5/9/2010
4/25/2010
4/11/2010
4/11/2010
4/11/2010
4/11/2010
12/6/2009
10/11/2009
4/26/2009
4/26/2009
4/26/2009
4/5/2009
4/5/2009
4/5/2009
1/16/2009
9/28/2008
9/28/2008
4/13/2008
4/13/2008
4/13/2008
1/18/2008
9/30/2007
9/28/2003
9/28/2003
4/14/2002
10/24/1999
Why not just look at the staggered starting lines for the 400m dash? It's already pre-measured.
Jack Rabbit wrote:
Why not just look at the staggered starting lines for the 400m dash? It's already pre-measured.
didn't Malmo respectfully ask people not to go down this road?
Jack Rabbit wrote:
Why not just look at the staggered starting lines for the 400m dash? It's already pre-measured.
Becasue LOOKING at the staggers doesn't tell you HOW FAR, that's why.
Chris Wasnetsky wrote:
I forgot to mention that I know how to use a period (".") delimiter to put the parts of the date in different columns, but I don't know how to sort them chronologically with all of them depending on each other.
If you just want to sort the dates by columns after separating day, month and year, then simply use DATA>FILTER (make sure you either label the columns or put a placeholder int hem.
Now you have drop a drop down box that allows you to sort by criteria like LASRGEST TO SMALLEST, SMALLEST TO LARGEST, etc. In this case you would sort the DAY, MONTH, AND YEAR COLUMNS in succession so that the entire data table is sorted chronologically.
Or you could fix the date formatting with the little trick I showed you and just sort by DATE.
Make sense?
fasdfsdafas wrote:
Easier rule of thumb: 2 seconds per lap per lane.
800m in lane two ~ 4 sec slow. If you need to know EXACTLY how far you are running (which is really almost never), learn the staggers or run in lane one.
"Does not follow instructions"
Again, the question is "how far is it in lane X" not "how much longer is it for hobbyjoggers to run a lap in lane X" If we wanted the answer to that question we would have asked Brian Sells wife.
malmo wrote:
...copy the data (just the column you want to 'clean' of formatting) to a TEXT ONLY formatted Outlook email. Then recopy it back to Excel...
Malmo, a nifty little utility called PureText, which lets you paste whatever is on the clipboard as plain text, will save you a few steps. And the price is right at $Free.
http://www.stevemiller.net/puretext/malmo wrote:Make sense?
From reading your posts, yes. I'll fiddle around with it later, I'm sure I will figure it out. Thanks for the tips.
Chris, I've left an Excel Spreadsheet with the data from that marathon list for you to download. From Left to right I've left the intermediate steps with a written commentary in a text box. This should get you where you need to be.
http://2008olympictrialsakatommyleonard.shutterfly.com/filecabinet
The copy text from Excel to unformatted text document, then back to excel trick works. I don't know why.
HiRes wrote:
Malmo, a nifty little utility called PureText, which lets you paste whatever is on the clipboard as plain text, will save you a few steps. And the price is right at $Free.
http://www.stevemiller.net/puretext/
HiRes, thanks. But that utility only adds more steps on GOOFY formatting problems that you get for online data tables.
http://2008olympictrialsakatommyleonard.shutterfly.com/filecabinetCheck out sheet 2 on the Chris Wasintinsky Excel sheet so that you can see the result.
No instead 1) text>columns 2) (.) period replace with (/) then copy to and from Excel etc, with this utility I have to 1) create MULITPLE empty colums 2) test>colums 3) Concatenate to get the date correct 4) concatenate to get the birthdate back 5) concatentate to get the names back.
I'll keep it handy to see how well it works on other websites in the future.
Thanks, malmo, I finally got it to work. Thankfully there is the click and drag format feature on Excel, otherwise concatenating 1000s of cells would take forever. I was stuck for a few minutes at the very last step because I was trying to import the concatenated dates from text, but they would only give me the option to sort A to Z and vice versa. Like you said (which I overlooked at first), you need to copy the values from the actual text file and paste them into the cells (without importing).
Here's my proof that I did it correctly with the 5K times.
6 12:44.39 Haile Gebrselassie ETH 18.04.73 1 Z黵ich 8/16/1995
8 12:45.09 Daniel Komen KEN 17.05.76 1 Z黵ich 8/14/1996
5 12:41.86 Haile Gebrselassie ETH 18.04.73 1 Z黵ich 8/13/1997
7 12:44.90 Daniel Komen KEN 17.05.76 2 Z黵ich 8/13/1997
3 12:39.74 Daniel Komen KEN 17.05.76 1 Bruxelles 8/22/1997
2 12:39.36 Haile Gebrselassie ETH 18.04.73 1 Helsinki 6/13/1998
14 12:48.81 Stephen Cherono KEN 15.10.82 1 Ostrava 6/12/2003
1 12:37.35 Kenenisa Bekele ETH 13.06.82 1 Hengelo 5/31/2004
9 12:46.53 Eliud Kipchoge KEN 05.11.84 1 Roma 7/2/2004
10 12:47.04 Sileshi Sihine ETH 29.01.83 2 Roma 7/2/2004
4 12:40.18 Kenenisa Bekele ETH 13.06.82 1 Saint-Denis 7/1/2005
12 12:48.25 Kenenisa Bekele ETH 13.06.82 1 Z黵ich 8/18/2006
13 12:48.66 Issac Songok KEN 25.04.84 2 Z黵ich 8/18/2006
11 12:48.09 Kenenisa Bekele ETH 13.06.82 1 Bruxelles 8/25/2006
I can see a lot of cool data tables being made sorting by dates. Calculating age at time of race (race date - birth date) to get youngest ever under xx:xx:xx at [event], a progression of world records for obscure events that might not be online (2000m steeple e.g.), average age of all competitors between xx:xx:xx and xx:xx:xx at [event], etc.
Sorry I didn't respond earlier, I had a bunch of class work to do for today. I appreciate the help, malmo.