Spreadsheet UPDATES!

[disneybelle]

DUH! My Brain is fried! I posted this at the end of the linked thread...

Okay teams...I've had some "lost in translation issues" with the upload from full Excel to more limited Google Docs Excel and have had to do some work-arounds. Thanks, Scott for all your help!

First, I've made some updates to the spreadsheet tips thread:

http://www.disboards.com/showthread.php?t=1707261

Some changes:

1. As of 2/6/08, Google Docs has made available a "freeze columns" option which will allow for easy scrolling across the sheets.

2. I've added a column to convert time into a number. Just enter time (hh:mm) in the "Time Entry" field and the "Time Calc" field will automatically convert it. (This may become a problem if/ when an individual's weekly time goes beyod 24 hours.)

I think that's it, except for some current "technical difficulties" Google is attempting to resolve.

Thanks for everyone's patience while we work out the bugs. Those numbers are really adding up...QUITE IMPRESSIVE!

 

[Steffwalks]

Darcy you are such a sweetheart. Thanks for fixing everything. I know it wasn't easy!

 

[Big Vic]

Thanks Darcey!

 

[ScoJo15]

Darcey,

Just wanted to say a big THANK YOU!! I know how much you've put in to this and that Excel to Google Doc to Excel stuff is mind numbing (as found out today with the whole.."i've got it!...oh crap, no I don't" that went on repeatedly for a few hours )!

Your hard work is certainly appreciated!! :

 

[AmyBeth68]

Thank you so much guys!!! My fellow teammates...you guys rock!!!!

Darcey....I know how much time it took to put this together and try to work out the bugs. GREATLY appreciated!!!! THANK YOU!

Scott...thanks for working hard on the fix today with Darcey..you put a lot of hours in too.

Good thing you guys know what you're doing....it's mind-numbing to me to start with LOL forget about all the complex formulas needed to get the results you want. I'm in awe of your spreadsheet genius!