tag:blogger.com,1999:blog-1804307342977220552.post2611090972361563345..comments2023-11-20T05:01:03.614-08:00Comments on The Lakefront Trail: Exactly how many runners did I pass?Pete Bhttp://www.blogger.com/profile/09655789227670205830noreply@blogger.comBlogger19125tag:blogger.com,1999:blog-1804307342977220552.post-23532297559601530192015-04-18T16:42:08.153-07:002015-04-18T16:42:08.153-07:00Love this! So cool you actually sat down and look...Love this! So cool you actually sat down and looked through the results to get those numbers.Zenaida Arroyohttps://www.blogger.com/profile/18137949290555784656noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-69620159081553260472015-04-16T10:07:04.291-07:002015-04-16T10:07:04.291-07:00Thanks. Do you have to erase a "kill" if...Thanks. Do you have to erase a "kill" if they pass you? Can you double count them if you pass them twice? Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-73317185960070951982015-04-16T05:06:18.258-07:002015-04-16T05:06:18.258-07:00Oooh, I love some math and spreadsheets! You shoul...Oooh, I love some math and spreadsheets! You should be running Ragnar so you can keep track of your kills! Though I suspect you'd run out of room to mark up the van with those :)Annehttps://www.blogger.com/profile/18403024177515079403noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-65397061160458609912015-04-15T14:02:23.392-07:002015-04-15T14:02:23.392-07:00Thanks Beth. It's fun for me to over-analyze m...Thanks Beth. It's fun for me to over-analyze my races! Glad you enjoy these posts! :)Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-11117642733830018172015-04-15T13:40:46.977-07:002015-04-15T13:40:46.977-07:00One of the things I really love about your blog is...One of the things I really love about your blog is the mathematical analyses you do. Love your charts and your number crunching. It's really fun to read! Thanks for taking the time to share your analyses with us, Pete!Anonymoushttps://www.blogger.com/profile/12494309191473191830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-52274901146104603062015-04-14T09:25:59.871-07:002015-04-14T09:25:59.871-07:00Thanks Sara! Yes, I could definitely make an app l...Thanks Sara! Yes, I could definitely make an app like for this. However, would anyone pay for it? :)Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-67166083646883037292015-04-14T09:24:53.039-07:002015-04-14T09:24:53.039-07:00Ha, ha. I should get a shirt like that! "Eat ...Ha, ha. I should get a shirt like that! "Eat my Dust" would be printed on the back and I could somehow change it to "I'm Eating Your Dust" if I'm forced to slow down or walk!Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-23828563490474580192015-04-14T09:16:38.608-07:002015-04-14T09:16:38.608-07:00So cool! You are an analytics wizard! You should m...So cool! You are an analytics wizard! You should make an app for this. $$$ :) Sarahttps://www.blogger.com/profile/09219737912315601922noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-40707684050521706102015-04-14T09:15:17.978-07:002015-04-14T09:15:17.978-07:00This is the coolest analysis ever!!! Way to tear i...This is the coolest analysis ever!!! Way to tear it up! You should get a shirt that says "Eat My Dust" =Demmers712https://www.blogger.com/profile/15865493476823978890noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-23331695353831425292015-04-14T07:46:08.094-07:002015-04-14T07:46:08.094-07:00Thanks! Yes, it is possible to add the folks that ...Thanks! Yes, it is possible to add the folks that started before me that I passed during the race. That would give me my true "kill rate". The Shamrock results include time of day for start, 5k and finish, but it is only available by selecting an individual runner (i.e. not in the "category" view). That means I would have to comb through 300+ individual records again. I should have noted those times the first time around! :)Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-27831065167051284742015-04-14T07:33:09.230-07:002015-04-14T07:33:09.230-07:00I love your analytics. ;)
Impressive #s, but what...I love your analytics. ;)<br /><br />Impressive #s, but what about adding in the folks that started before you, but you passed during the run? By looking at time of day.. I have a feeling your number would be even higher :) but- on my phone at least, that info is not available... So maybe it is not possible. Xaarlinhttps://www.blogger.com/profile/09103441780159368391noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-22759905950811985902015-04-13T20:08:01.695-07:002015-04-13T20:08:01.695-07:00Thanks. If the race reports splits, it can be done...Thanks. If the race reports splits, it can be done.Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-74358880216221155232015-04-13T19:18:39.030-07:002015-04-13T19:18:39.030-07:00Holy cow that's amazing. I always wonder how ...Holy cow that's amazing. I always wonder how many people I pass. Meghanhttps://www.blogger.com/profile/18163506803993332134noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-44402957407912389512015-04-13T18:24:33.456-07:002015-04-13T18:24:33.456-07:00It involves a little database wizardry! It is a si...It involves a little database wizardry! It is a simple query once I loaded it in the database. You could do some sorting in Excel based on first half time and finish time then do a count. Unfortunately, I don't think I'll run the Lakefront 10 miler. Maybe we'll run the same race soon! :)Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-8427383102641916142015-04-13T17:48:44.747-07:002015-04-13T17:48:44.747-07:00Thank you for this! I have no idea how you figured...Thank you for this! I have no idea how you figured it out, but I'm happy you did! <br /><br />You're not running the Lakefront 10 miler on Sat? I was hoping to meet you!Wendy at Taking the Long Way Homehttps://www.blogger.com/profile/09934786207724059919noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-74352179507068575552015-04-13T17:46:14.561-07:002015-04-13T17:46:14.561-07:00Thanks. I hope all my analysis is correct! See you...Thanks. I hope all my analysis is correct! See you at the Ravenswood Run! :)Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-44760140259294413752015-04-13T17:45:38.542-07:002015-04-13T17:45:38.542-07:00According to my analysis of your times, you passed...According to my analysis of your times, you passed 4,429 runners and were passed by only 164. Nice job! Goes to show how smart you were and how few runners run even splits in the marathon!Pete Bhttps://www.blogger.com/profile/09655789227670205830noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-41183669499069530412015-04-13T17:42:23.013-07:002015-04-13T17:42:23.013-07:00And our analytics wizard strikes again! Can't...And our analytics wizard strikes again! Can't wait to see you at the Ravenswood 5k! Anonymoushttps://www.blogger.com/profile/17152316282069493934noreply@blogger.comtag:blogger.com,1999:blog-1804307342977220552.post-72852816154479723252015-04-13T17:02:03.985-07:002015-04-13T17:02:03.985-07:00Geez. How did you do all that math? And I looked a...Geez. How did you do all that math? And I looked at the Marathon spreadsheet and couldn't figure anything out except that I ran even splits the whole time. 2:08 at the half and 4:17 to finish. Hmmm.Wendy at Taking the Long Way Homehttps://www.blogger.com/profile/09934786207724059919noreply@blogger.com