Page 2 of 3
Posted: Fri Feb 09, 2007 5:19 am
by WAY
QUOTExlsx files are nt supported, and I can't convert them back, because I don't have 2007.
so, save in 2003 format, and resend.
Hmm, didn't I tell you guys this would happen? lol
Posted: Fri Feb 09, 2007 5:47 am
by Bot
QUOTE(œbermensch @ Feb 9 2007, 12:45 AM) Kramer, after you see this, you might want to consider switching over...I'm pretty sure this could be streamed lined to work w/a DB relatively easily...
I don't know. My tables seem to be working fine for me for now. They hold all my stats. lol
Posted: Fri Feb 09, 2007 6:25 am
by WAY
Yes Kramsie, but you can't sort them WHAT-SO-EVER..
Plus, it's more of a pain in the arse to share..
Posted: Fri Feb 09, 2007 6:49 am
by Bot
Sort them how exactly? I have my teams sorted in their respective divisions and in alphabetical order.
Posted: Fri Feb 09, 2007 9:46 am
by Bot
All right... so Excel isn't bad. lol
I added Games Behind to my stats, so now I have the divisions sorted by Games Behind. I forgot that you could sort specific areas in the spreadsheet without sorting everything else. lol
Posted: Fri Feb 09, 2007 9:25 pm
by WAY
My point exactly.. lol
Posted: Sat Feb 10, 2007 4:28 am
by raum
I gave Ayhja a spreadsheet that does a little bit more.
If he is cool with it, I might do more.
Posted: Sun Feb 11, 2007 12:17 am
by raum
QUOTE(raum @ Feb 9 2007, 11:28 PM) I gave Ayhja a spreadsheet that does a little bit more.
If he is cool with it, I might do more.
One thing though,.. due to the actual file he showed me, and what I wanted to do with it, it is limited.
I created parameters in the file.
Basically, there is only enough room for 22 teams of ten members each. It allows you to schedule 5 matches a week for 26 weeks and keep tracks of wins by each team and member.
This reflects one season of one year. It allows for no "switching of girls" or late season changes.
There is also a week at a glance report that has a drop down box that will let you put together a sheet of the five matches for the given week.
I can add a bunch of stuff, but I was going to just show this to Ayhja and find out what he thinks.
Posted: Sun Feb 11, 2007 12:47 am
by Bot
You can actually add drop-down menus in Excel? lol
Posted: Sun Feb 11, 2007 2:16 am
by raum
QUOTE(Kramer @ Feb 10 2007, 07:47 PM) You can actually add drop-down menus in Excel? lol
yes, and much more. excel has a lot of functionality most peolpe never think of.
i can make a tetris game in excel, for example.
but even more so, I can make a way of analyzing all kinds of data across different metrics.