PDA

View Full Version : Excel Scoring

bennettr
06-02-2008, 11:16 AM
has anyone made an excel sheet for scoring??


If not I will see what I can do.
haasem99
06-02-2008, 02:40 PM
please do so!!
bennettr
06-02-2008, 04:09 PM
Does anyone know how to type in something and then have the excel spit out a value?
thebestauntie
06-02-2008, 04:27 PM
Does anyone know how to type in something and then have the excel spit out a value?
You mean like an "if, then" statement?
bennettr
06-02-2008, 07:04 PM
sort of.

I want to be able to type say Two Step O (for opener) and have it spit out 3 or whatever points it is. or if it is Two Step S (for set) then have it spit out the corresponding points.
thebestauntie
06-02-2008, 09:45 PM
sort of.

I want to be able to type say Two Step O (for opener) and have it spit out 3 or whatever points it is. or if it is Two Step S (for set) then have it spit out the corresponding points.
Hmmmmm, let me work on it, I might be able to.
bibby1044
06-02-2008, 10:10 PM
sort of.

I want to be able to type say Two Step O (for opener) and have it spit out 3 or whatever points it is. or if it is Two Step S (for set) then have it spit out the corresponding points.
That would be very efficient, but thats alot of songsand values your looking at.
bennettr
06-03-2008, 09:07 AM
I figure I will use a shit ton of If statements. I'll let you know when it's done
bennettr
06-03-2008, 09:49 AM
that would have worked great, but it will take forever, if only I could ask it to look up a value over an entire row/column and then return a value that I want..
bennettr
06-03-2008, 01:29 PM
I have almost done it!!!!!!!!!!!!!!!!!!!!!!!!! Wooo
rconverse
06-03-2008, 01:35 PM
I have almost done it!!!!!!!!!!!!!!!!!!!!!!!!! Wooo

If you have a question, please feel free to PM me. My other favorite message board is www.mrexcel.com. Yeah, I'm a geek. :)
bennettr
06-03-2008, 01:36 PM
man, I probably should have looked there for how to do stuf. I bet mine is pretty primative, but whatever
rconverse
06-03-2008, 02:23 PM
man, I probably should have looked there for how to do stuf. I bet mine is pretty primative, but whatever

:lol Compared to what a lot of those folks can do, yeah probably. The main thing is it fits your purpose. :)
bennettr
06-03-2008, 02:46 PM
the only things I can do are ISNA(Match) and IF()

haha, but it is done except for the guest factor. I'll probably do that tomorrow.

I'll put it up later tonight
bennettr
06-05-2008, 09:34 AM
Sorry I haven't put this up yet. I should get to it soon. PM me and I will be able to sent it to you
bradshaw06
06-08-2008, 09:01 PM
do you have this?
bennettr
06-10-2008, 09:34 AM
I have it done!

PM me your email and I'll give it to you