November miles for @mobycarp
Elise4270
Posts: 8,375 Member
To honor our friend and virtual running partner we are putting together a 26 hour virtual relay.
2
Replies
-
eleanorhawkins wrote: »Just had a quick look at the google doc for the miles for Kevin (MobyCarp) runs.
https://docs.google.com/spreadsheets/d/1u1kakszOV9CNZ6ONIzsQjF2Oq8lgpOZh/edit#gid=1527975205
As it stands, from what I can make out (I suck at spreadsheets lol) if we moved the start back an hour and start the 24 hour period at 6pm EST, we would still have 8 hours to cover to make the full 24. Anyone able to take any of those slots?
0 -
I am running the Marshall University Marathon on 11/3, so will check start time and try to add to spreadsheet. Also, we have daylight savings time change on there, right? The spreadsheet is a bit wonky on phone, so may try from conputer later.2
-
Ok, I got it updated on my phone with the Google Sheets app... works much better than opening in MFP as it tries when just selecting link.
Anyway, I did not adjust the file for daylight savings. It is too complicated of a change to want
to mess with on the phone and I didn't want to break the file. I assume everyone is going to plan on the same times and we just need to add 1 hr from 2a-3a. (For the 2nd 2a-3a) inder just the U.S. schedules.0 -
How does this work? Sorry having trouble figuring it out...
I'll be in Mexico - which is PST
Thanks0 -
hamsterwheel6 wrote: »How does this work? Sorry having trouble figuring it out...
I'll be in Mexico - which is PST
Thanks
I think there is a column in the file for PST. Find the time you plan to run and put your username in whichever colum best fits the description.0 -
Is this before or after day light saving time? Because that will change my time zone...0
-
RunsOnEspresso wrote: »Is this before or after day light saving time? Because that will change my time zone...
I just went into the file and spent some time cleaning up and adding for the different time zones for DST and such. The new time zones are in a new tab and I left the original information intact and labeled it "Original" so you can see what you signed up for before I made changes. I kept everyone's times intact in accordance with time in New York (column B ) and added the hour. You will notice that 1am repeats itself now in that time zone.1 -
T1DCarnivoreRunner wrote: »RunsOnEspresso wrote: »Is this before or after day light saving time? Because that will change my time zone...
I just went into the file and spent some time cleaning up and adding for the different time zones for DST and such. The new time zones are in a new tab and I left the original information intact and labeled it "Original" so you can see what you signed up for before I made changes. I kept everyone's times intact in accordance with time in New York (column B ) and added the hour. You will notice that 1am repeats itself now in that time zone.
I'll have to look on a computer. Not sure adding a new tab helps me.
I don't actually change times. Just time zones. I'm technically Mountain - Phoenix which is only mountain half the year. 🤣0 -
Ok so phone not playing properly. C unless @ContraryMaryMary wants to change her time, can you put me in the first too slots. I'll do a 10k for Kevin at that time.0
-
I am not sure why we need to add an extra hour for DST - wouldn't we just be using the times as they are that weekend, unless that is the weekend that we actually change?
Also there are spots for multiple runners per slot so we can have up to 4 runners without anyone having to 'give up' a time slot.0 -
I am not sure why we need to add an extra hour for DST - wouldn't we just be using the times as they are that weekend, unless that is the weekend that we actually change?
Confusing me too... pretty sure it changes the weekend before here (last weekend in October) but I think America is different to Europe.0 -
I am not sure why we need to add an extra hour for DST - wouldn't we just be using the times as they are that weekend, unless that is the weekend that we actually change?
Also there are spots for multiple runners per slot so we can have up to 4 runners without anyone having to 'give up' a time slot.
Yes, that is the weekend we change in the U.S.eleanorhawkins wrote: »I am not sure why we need to add an extra hour for DST - wouldn't we just be using the times as they are that weekend, unless that is the weekend that we actually change?
Confusing me too... pretty sure it changes the weekend before here (last weekend in October) but I think America is different to Europe.
Right. Original tab has CEST. By Nov. 2, Europe will be on CET. I fixed that also when I updated times.RunsOnEspresso wrote: »T1DCarnivoreRunner wrote: »RunsOnEspresso wrote: »Is this before or after day light saving time? Because that will change my time zone...
I just went into the file and spent some time cleaning up and adding for the different time zones for DST and such. The new time zones are in a new tab and I left the original information intact and labeled it "Original" so you can see what you signed up for before I made changes. I kept everyone's times intact in accordance with time in New York (column B ) and added the hour. You will notice that 1am repeats itself now in that time zone.
I'll have to look on a computer. Not sure adding a new tab helps me.
I don't actually change times. Just time zones. I'm technically Mountain - Phoenix which is only mountain half the year. 🤣
The whole point of adding the extra tab was to preserve the original information. In case anyone wants to look back at it.1 -
Look, I acknowledge the time change is a bit confusing when you add multiple zones changing at different times (or not at all) during that time window. I put a lot of thought into making updates accordingly.
If it helps you feel better, this is my schedule that weekend (includes 4 time zones in 2 days)
Nov. 2 Drive from CDT to EDT
Nov. 3 Time changes from EDT to EST, run race, then drive from EST to CST1 -
@T1DCarnivoreRunner I'm extremely grateful to you for doing that! As I've said before, words are my thing, numbers and spreadsheets.... not so much. Just kidding, I'm a total dunce at spreadsheets, I can't even use excel!
So, all contributions and assistance with that is very much appreciated :-)T1DCarnivoreRunner wrote: »
If it helps you feel better, this is my schedule that weekend (includes 4 time zones in 2 days)
Nov. 2 Drive from CDT to EDT
Nov. 3 Time changes from EDT to EST, run race, then drive from EST to CST
Does that mean you'll be going back to the future? COOL!!!0 -
Not really back to the future... just re-labeling the present. My time changes:
1. Back 1 hr.
2. Back 1 hr.
3. Forward 1 hr.
In the end, I will be home with 1 hr. back change, as intended with the end of daylight savings.0 -
I love spreadsheets! But I am time zone challenged and hate the time changes DT-DST and back. Wish they would just pick one and leave it at that.
Thanks for updating the spreadsheet for the time change, @T1DCarnivoreRunner1 -
Hey, it sounds like @T1DCarnivoreRunner has a handle on the DST change. But if it’s still a challenge why not assume dst doesn’t happen and run from there? It is an arbitrary change and can be ignored.3
-
I only asked about DST because I didn't know when it was and thought it was usually the first weekend in November. I don't pay attention because I don't change times. This is all far too confusing for me. I am going to gracefully bow out at this point.1
-
I realize keeping track of the time zones is confusing, so I had an idea to try to help...
For techies that are interested:I changed the file time zone to UTC with no daylight savings time (file was previously setup in Pacific time). Then used NOW function for current time and calculated additional hours or fewer hours with UTC as base.
At the top of each column (Row 1) for the different time zones, I have put the time as of right now.
In the 2nd row, I have put the time it will be after the daylight savings time change.
Open the file, look at your watch/clock/phone/computer/whatever you use to tell time, then slide over in row 1 until you get to the time that matches your current local time and that is your time zone.
If you recently changed for daylight savings time, then use row 2 instead.
If you live in the U.S. in a state that does not observe daylight savings time, then use row 2 instead.
*There may be exceptions, but I believe this will work for 95%+ of us.
The current times in rows 1 and 2 will update when you open the file and it will update whenever the sheet calculates (such as when you put your username in somewhere), and again when you close the file. If you are working in the file, it likely will never be more than a couple min. since updating unless you just open it and leave it open for a long time without doing much or anything.1 -
I want to add... the day chosen is tougher because of the time change in much of the U.S. However, this day was chosen for a particular reason. I wanted to accommodate the time change, but if you are still struggling to understand what time is what; then don't worry about getting sidelined by those details. Put in your time as best as you understand it and then go run. I'm sure @mobycarp would have said the same and that would still be a fine way to honor his memory. That's the whole spirit of this, right?!2
-
The time columns look good to me. Nice work, @T1DCarnivoreRunner.
Unfortunately I can't help. I'm tentatively planning an 8 hour race which runs from 8am to 4pm on November 2nd, CST, so it ends just as this campaign starts. If I do that, I won't be running at all on Nov 3rd.
1 -
@7lenny7 - add your name to the sheet for November 2nd - we will count it! You know Kevin would be so supportive of an 8 hour run!
@shanaber
Done. I didn't expand the time slots but just put my name on the 5 hours shown on top. I didn't want to screw things up. The race is not a sure thing, my busy race schedule has become an issue again, but I think I've smoothed things over enough I can do that race.
And she won't even be home that weekend so it will be easy to sneak off if I have to....3 -
I've added my name to a couple of slots - running late at night isn't my thing so I might plump for the early morning slots instead but it would be nice for one of us to manage to start it off or is that in hand?
0 -
Ok so phone not playing properly. C unless @ContraryMaryMary wants to change her time, can you put me in the first too slots. I'll do a 10k for Kevin at that time.
I think this post may have been missed @eleanorhawkins?
Happy to slot in anywhere if this has now passed. If the first slots aren't available, I'll take the final hr.0 -
-
Yes, I had missed it completely, sorry!
1 -
I checked the empty slots to see if I cud move my run to fill an hour but it will be middle of night here and I just can't. Is there any way we can get more people to help1
-
i may or may not be able to fill a hole. it will be the middle of the night. i have a concert that night. either way, i'll try to run at some point during that 24 hour period2
