Crazy Spreadsheets

[BullsGM-old]

Ok, I admit, I suck at Excel.  I never learned it, and don't really know the 'power' of spreadsheets.  How many of you guys use Excel to keep stats and what can your spreadsheets do?

I'm interested in learning, only if it's worth while

[NetsGM]

I use excel for this.  Simply because it's easy enough to paste boxscores into.

I'd like to throw it into a full-scale mysql db and run queries from that, but don't have the time.

But for this purpose, it's great.  definitely worth learning at least the basics.

For example, when a new draft comes, I simply paste the class into the spreadsheet.  Formulas are entered, and "scores" calculated automatically.  I don't even have to re-enter the formulas, convert any numbers, it just happens.  It's very nice.

[Anonymous]

interested in how you do that for drafts      


like whats the formula.  i remember learning how to do addition and post sums and such

[NetsGM]

lots of if statements.

[Anonymous]

ifs?

so did you make each rating a point... then say if it is this rating, then it equals that point... i.e A- = 4 points

then just sum up the points?

[NetsGM]

for example:
=IF(J9="B-",7,0)

Means, If J9 is B-, then the value is 7.  Otherwise, 0.

You have to do one of these for every possible letter, for every possible rating.

then add it all up

[Anonymous]

i see... J9 would be the cell... so you have to make on for every cell in that row?

and where do you put that code... in any cell?