Login
A Mile A Day
12

New Chart Help (Read 106 times)
jeffdonahue
posted: 7/23/2008 at 1:54 PM
So I am trying out a new chart. It is in Excel using Google Documents. It will just be much easier for me to update than the current manual chart.

But I am trying to figure out how to get it to update on its own every time someone opens it. I have a formula in there that calculates the # of days in the streak and I was under the impression that it would update the formulas at least daily (I thought I read every 2 minutes somewehre) but when I logged in this morning it still had the totals from yesterday.

When I went into the document on Gooogle docs it updated and is now fine but I dont want to have to go intot he document every day to update it. Does anyone know anything about Google documents and how to get it to update on its own every day?
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
ShanHas
I'm excited!
 posted: 7/24/2008 at 10:40 PM
here this is! I went to find this last night to show DH but couldn't remember where it was! I will ask him if he knows when he gets home!
When's the next one?
2009 Goals - Do it up Big!
jugdish
posted: 7/25/2008 at 2:26 AM
Quick question on the google docs thing...can any of us update ours?

Congrats on your new 5k PR!
ShanHas
I'm excited!
 posted: 7/25/2008 at 11:47 AM
ok so Dh is thinking that you can't do it in Google Doc's because it doesn't have the functionality of Excel.
When's the next one?
2009 Goals - Do it up Big!
jeffdonahue
posted: 7/25/2008 at 12:15 PM
Quote from jugdish on 7/25/2008 at 2:26 AM:
Quick question on the google docs thing...can any of us update ours?

Congrats on your new 5k PR!


Give it a try. I put a new link on the front page that should open it up for editing - there is still a link to the graph I did at the bottom this time though. I would actually be interested to see if you guys can edit it because that would make things easier as well. I have it set up to email me whenever a change is made to the file.
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
jugdish
posted: 7/25/2008 at 1:01 PM
I can't edit the file.
jeffdonahue
posted: 7/25/2008 at 1:35 PM
Which link did you use?

It is under the link that says - "Time for another try" on the home page.
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
jeffdonahue
posted: 7/25/2008 at 1:37 PM
Never mind, I just tried it after logging out of google and I could only view it.

Let me check into it because I am pretty sure there is a way for me to share it so everyone can make their own changes. I think Bonkin did this on a spreadsheet in another forum for his little running/drinking challenge they are donig this week.
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
jeffdonahue
posted: 7/25/2008 at 1:41 PM
Okay, someone else give it a try now. You should be able to edit it. I just logged out of google and tried to get in and I got in okay.
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
ShanHas
I'm excited!
 posted: 7/25/2008 at 2:10 PM
Works! I could edit it.
When's the next one?
2009 Goals - Do it up Big!
jugdish
posted: 7/25/2008 at 2:30 PM
Drinking/Running challenge? details please...Smile

We have a pub crawl coming up where we cover roughly 6-7 miles stopping at 9 different bars.
jeffdonahue
posted: 7/25/2008 at 2:53 PM
modified: 7/25/2008 at 2:55 PM
Somebody on another post on this site somewhere has a team challenge going on for one week. I'm not sure on all the details but I think you get one point for every mile you run and one point for every drink you have during the week.

I just checked - should have known it was in the swamp.

Here is a link - the first 3 posts relate to the challenge

http://www.runningahead.com/groups/2000/Forum
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
ShanHas
I'm excited!
 posted: 7/25/2008 at 4:25 PM
oh yeah.. it's in the Swamp (2000 miles of new world order).

They drink and run as much as they can for a week.

It started Monday and ends Sunday. The minimum you hope for is 75 of each. It's a team competition of drunken anarchy.
When's the next one?
2009 Goals - Do it up Big!
ShanHas
I'm excited!
 posted: 7/28/2008 at 12:29 PM
I'm confused - do we have to update our "today's date" column ourselves?
When's the next one?
2009 Goals - Do it up Big!
jeffdonahue
posted: 7/28/2008 at 12:32 PM
Quote from ShanHas on 7/28/2008 at 12:29 PM:
I'm confused - do we have to update our "today's date" column ourselves?


No. it is a formula that automatically puts in todays current date. I think that rick didnt realize that and just put yesterday in hard-coded. I made the change so it is a formula for him now as well.
"80% of success is showing up." ~ Woody Allen

"Go that way... really fast. If something gets in your way... turn." ~ Charles DeMar

God doesn't give you what you want. He gives you what you need, the rest is up to you.
12
Feedback  |  Help
© 2005 – 2009 RunningAHEAD.com. All rights reserved.