Clydesdales/Athenas (200+ lb / 91+ kg) - ****Spinner Saturday Announcement****

Bikeforums.net is a forum about nothing but bikes. Our community can help you find information about hard-to-find and localized information like bicycle tours, specialties like where in your area to have your recumbent bike serviced, or what are the best bicycle tires and seats for the activities you use your bike for.




Tom Stormcrowe
04-06-08, 08:29 PM
Things have gotten scrambled on the YTD totals somehow. I won't have time to address it til Wednesday at least. Just letting every one know I'll get on it. I have to prep for a major presentation on the nature of Free Will. This presentation is going to be to Freshman Class, and will make or break my semester grade for the class I'm dong it for.

Just letting y'all know I will get on it as soon as I can.:D

Wish me luck!!!!!


Ray Dockrey
04-06-08, 08:45 PM
Hey Tom, is it the group totals because my individuals are correct.

Tom Stormcrowe
04-06-08, 09:01 PM
It hit some but not all apparently, so I'm going to have to recheck all the codes. :(


piper_chuck
04-07-08, 04:32 AM
It hit some but not all apparently, so I'm going to have to recheck all the codes. :(

Tom, I took a look and found a couple obvious problems. I can fix them if you'd like. If not, to save you time, they are:
The YTD total for Feb only goes to row 51. It should go to row 76. Most of the rest of the months also end early, on row 75 instead of 76.

The individual YTD formulas for April pull in March sums for a different person: G15 = Sum(MARCH!G16)+F15. This is broken in rows 15 through 75.

Tom Stormcrowe
04-07-08, 04:59 AM
Chuck, that would be great! I appreciate the offer and the reply is a resounding YES! :D

piper_chuck
04-07-08, 06:39 AM
Fixed the problems I noted already. It turns out the spreadsheet has autosave on, so earlier testing that I did actually ended up being saved. :eek:

I also went through the rest of the months and cleaned up errors with individual totals in each month that were throwing off the YTD total. I confirmed that the YTD total works each month through year end.

The final fix I did was to correct the weekly total for each column. It wasn't going to the bottom row.

Tom Stormcrowe
04-07-08, 10:14 AM
Thank you VERY much! It's much appreciated by all of us (Especially me :D)

Neil_B
04-07-08, 10:15 AM
Thank you VERY much! It's much appreciated by all of us (Especially me :D)

Not so much by me. It reminds me I need to ride more. :eek:

epcolt
04-07-08, 10:30 AM
Reminds me I have to really get out a lot more

AirBeagle1
04-07-08, 10:41 AM
Good luck with the presentation!

piper_chuck
04-07-08, 10:53 AM
Thank you VERY much! It's much appreciated by all of us (Especially me :D)
You're welcome

piper_chuck
04-07-08, 10:58 AM
Not so much by me. It reminds me I need to ride more. :eek:

I've managed to ride exactly 11.3 miles since the second week of Feb :cry:, so I don't want to hear your complaints! :mad: :fight: Go ride already. :p:lol:

WhaleOil
04-07-08, 11:18 AM
Luck Tom! Prayers are with you.

Tom Stormcrowe
04-07-08, 11:20 AM
Gonna be fun.....I am sure of that! :eek:

Mazama
04-07-08, 02:35 PM
Yeah, I had to go in and redo a lot of my data. Luckily I had a copy of it elsewhere. :/

Barabus
04-07-08, 04:03 PM
Tom, your presentation is destined for success. LOL.

Ray Dockrey
04-07-08, 06:15 PM
Thanks Piper and good luck to you Tom. I am sure you will do fine.