AUGUST 2014 - Move Your @ss Challenge
Replies
-
8/1: bicycling 17.41km
8/2: rowing 2km, elliptical trainer 4km
8/3: bicycling 16.19km
8/4: stationary bike 8.5km
8/6: bicycling 24.74km
Total: 72.84km
Left: 177.16km
0 -
2 mile run and walked the dog this morning
0 -
8/4: 1.25
8/5: 1.67
8/6: 1.48
TOTAL: 4.40 MILES
0 -
Yes, that was bothering me too!I was playing around with the spreadsheet a little today and added a new column that might interest some of you.
Column Q - Miles Needed for "Green"
It contains the number you need to be equal or greater than in Column G in order to be "In the Green" or considered "On Track".
I had been doing it for myself for a little while when a lightbulb went off today (or maybe it was a candle flicker :laugh::laugh:) and I thought, "Hey!! I bet I can figure out an easy way to do that for everyone!!" And sure enough...it was* super simple! Only took me about 90 seconds to fully implement. :drinker:
I hope you like it and find it useful!!
Dave
Thanks Dave! You might beat me in spreadsheet geekery. ha. :bigsmile:
(except it doesn't seem to be working... there are several people in the green who still show they "need" miles to get to the green.... or maybe I don't understand what is being shown in the column... :ohwell: ) Because right now it just shows the number to beat and still shows if someone is past it. I have it set to not display if the number is zero, but I haven't figured out how to make it not show if someone is already green. I'll think about it some more today and see if I can solve that problem too.
Maybe calling the column name something else would be clearer?
Dave0 -
YES!!! I figured it out!! NOW it does not show how many miles you need if you're already green!!! :happy::happy::happy:
Just please keep in mind that it might still occasionally show the miles if you're already green because that calculation is based off of cell A1 which *always* automatically rolls over and updates *precisely* at midnight every night, but I pretty much *never* get the formulas to change the colors updated at the same time. It is almost always later in the day. Some days, much, much, MUCH later. :laugh: I wish there was a way to make that process "automatic" at midnight as well, but I don't believe it's possible. Yet anyway. I'll keep thinking about that too and maybe the candle will light again. :bigsmile:
But still, that number (if it shows) is not wrong. It is just the number you need to be beyond to be green....it's the bar you have to pass. If you're already past it, then great!! :bigsmile:
Dave0 -
8/5 - 9.37 walking and biking (I biked on 8/4 also, not just walking!)
Total to date: 38.83 of 200 miles0 -
Here we go! Updated:
8/1: 5.8 miles walking
8/2: 6.1 miles walking
8/3: 7.5 miles walking incl 9 holes of golf!
8/4 - Zero - had food poisoning which has thrown this week in to a tizzy
8/5 - 5 miles walking (which was supposed to be my cycling day :-((
24.5 /120
I was hoping to get a ride i but that probably wont happen before Tuesday.0 -
8/5 - 1 mile
Total - 5.62 out of 50 miles
0 -
adding 3.19
mtd 13.81
0 -
YES!!! I figured it out!! NOW it does not show how many miles you need if you're already green!!! :happy::happy::happy:
Just please keep in mind that it might still occasionally show the miles if you're already green because that calculation is based off of cell A1 which *always* automatically rolls over and updates *precisely* at midnight every night, but I pretty much *never* get the formulas to change the colors updated at the same time. It is almost always later in the day. Some days, much, much, MUCH later. :laugh: I wish there was a way to make that process "automatic" at midnight as well, but I don't believe it's possible. Yet anyway. I'll keep thinking about that too and maybe the candle will light again. :bigsmile:
But still, that number (if it shows) is not wrong. It is just the number you need to be beyond to be green....it's the bar you have to pass. If you're already past it, then great!! :bigsmile:
Dave
You did Great!! Thank you0 -
Yesterday walked 6.08 miles
24.58 miles walked to date0 -
4 mile run w .3 warm up walking
0 -
Cool, thanks! Now you get both the number to beat for "Green" annnnd how many miles to get there!!
I hope this isn't too* much info and has the opposite effect of making you feel bad if you get too far behind and making you want to give up.... :blushing: ...but I guess then the best solution is to do your best not to get behind in the first place. :flowerforyou: Or just do whatever you can to chip away at it if you fall back.
Dave0 -
Aug 5 - 4.7 km
Aug 6 - 2 km
Total 24.8/1200 -
Going for another 750 miles as have another 11 day holiday in a fortnight
01-08: Rest day
02-08: 31.98 miles
03-08: 17.91 miles
04-08: 36.97 miles
05-08: 31.01 miles
06-08: 27.20 milesAugust miles: 145.07
YTD miles: 73510 -
8.30 miles walked today
32.88 miles walked to date0 -
New total 25.5 miles0
-
Dave, you rock!! :drinker: :flowerforyou:
To the person asking about Fitbit miles for this challenge - my two cents and how I do it - (although I'm currently waiting for another Fitbit replacement after my current replacement died) - I only count the miles I do for the sole purpose of exercise/calorie burning/steps. I don't consider everyday normal walking - to the mailbox, parking lots, around the house, etc - to be exercise. I'm a nurse, I average 3-5 miles per shift, yet I've always been obese. My interpretation of this group is to help me increase what's normal for me and move more - and it's done that. I started out with 35 miles per month, now I'm aiming for 80. This is all my opinion, I know there are people who do count all their Fitbit miles and that's just as okay. It's what you want and like someone upthread said, just stay consistent to what you decide.
After three long shifts, I got 4 miles in. Ran a mile - and why is it 90 freakin' degrees when it was in the 70s before I started those shifts? Did another half mile in intervals, trying to string them all together so I can not make a fool of myself at my subdivision's 5K next month.
0 -
Aug 6: 8.25 miles running 4.25 miles and walking 4 miles
TTD: 59.25 miles
0 -
... 4.5 mile run this evening!
0 -
Hi, I missed last month completely...I think, and won't get a lot done this month.....
but put me down for..
50 miles gym bike.
I've already gotten in 15 of them. I'll put in a post claiming them later on .
Thanks,
Gail0 -
Aug 5--7 miles walked
**total 23.5 of 150 miles walking0 -
8/6 - 1.05 mile walk
5.3 miles exercise bike
0 -
Exercise total for
Wednesday 8/06
(Exercise bike 30.91 miles & walk 1.25 miles)
**total 32.10 miles for today
***192.80 miles done and 707.20 miles to go....:happy:0 -
08.05 7.81
0 -
To the person asking about Fitbit miles for this challenge - my two cents and how I do it - (although I'm currently waiting for another Fitbit replacement after my current replacement died) - I only count the miles I do for the sole purpose of exercise/calorie burning/steps. I don't consider everyday normal walking - to the mailbox, parking lots, around the house, etc - to be exercise. I'm a nurse, I average 3-5 miles per shift, yet I've always been obese. My interpretation of this group is to help me increase what's normal for me and move more - and it's done that. I started out with 35 miles per month, now I'm aiming for 80. This is all my opinion, I know there are people who do count all their Fitbit miles and that's just as okay. It's what you want and like someone upthread said, just stay consistent to what you decide.
After three long shifts, I got 4 miles in. Ran a mile - and why is it 90 freakin' degrees when it was in the 70s before I started those shifts? Did another half mile in intervals, trying to string them all together so I can not make a fool of myself at my subdivision's 5K next month.
@Kar328 - You have "influenced me" I have been using a fitbit, but have been counting "all" miles and I realize that is not necessarily "right" in my book. From now on I am only going to count "intentional" miles: running, walking, stationary bike and not "incidental" miles. (I do a step challenge on fitbit) -
Thanks so much for posting what you did :flowerforyou:0 -
I actually "docked" myself miles today. I am not going to just count the distance on my fitbit. I am only going to count "intentional" miles. It is definitely going to be a challenge to make my goal.
i just need to really pay attention to my runkeeper app, the elliptical distance, and stationary bike.
It is a personal choice, but I feel good about it. ( A post by Kar328 really made me stop and think :drinker: )
Today: 2.5 mile run/walk AM. 1 mile walk pM
Revised Total 18.0 miltes
0 -
Rest day, I am back in training again. I am not going to let that half century ride last month get to me. I have signed up for another ride, but it is a little different. Called Tour De Blast, you start in a small town in Washington State, and ride the Spirit Lake Memorial Highway, til the road ends. Did I mention that road ends 5 miles directly in front of the open crater of an active volcano? This is the Mt Saint Helens ride, it is an out and back. It also has a 6000 ft elevation gain. Boy do I know how to pick em. My son is going along to keep me safe. They don't call them rest stops, they are called decision points, as each segment is way tougher until the last 10 miles where you are virtually doing a switch back climb to the top of the debris flow. Got 5 weeks to prepare.
08/01 - 14.0 miles biking
08/02 - 7.0 miles biking
08/03 - 2.0 miles walking
08/04 - 14.0 miles biking
08/05 - 14.0 miles biking
08/06 - 2.0 miles walking
Total: 53.0 miles
0 -
Wow! Everybody's doing really well so far. As for myself, not so much. I'm getting off to a slow start, with only 2.5 mile walks on 8/4/14 and 8/2/14. I plan on going for a bike ride tomorrow, so hopefully I'll get some much needed mileage. So it's 5 miles down, 95 to go for the month.
-Kelly0 -
short 0.86 walk on my coffee break
0
This discussion has been closed.