?

Log in

prev | next

here's a silly little problem.

warning: Excel formula language combined with DDR geekdom ahead.

The DDR Records spreadsheet i made in Excel has a feature where it automatically tabulates the number of SDGs i have.

The literal definition of the term SDG ("Single Digit Greats") refers to getting less than 10 greats on a tune in DDR. So i created two hidden columns in my spreadsheet. The first column (column L) totals the "Good", "Boo", and "Miss" count. The second column (column M) then says "If Column L is zero and Column D (the great column) is less than 10, then the condition for SDG is met.

Recently, I got 4 greats and 1 good on a tune, and even though that's not technically an SDG, when you calculate the Dance Points, it's the *equivalent* of an SDG. It's the same as getting 6 greats on a tune (i think), which is still less than 10. NNR calls that an SDG. Tyler calls that an SDG. i think that I do too now.

but my excel spreadsheet doesn't. It sees the "1" in the good column and negates any possibility of it being an SDG.

so i need to change my spreadsheet a little. I need to find a way to get it to calculate the Great Count Equivalent, and not just the literal count.

I think Column L will then turn into something like:

SUM(D1+(PRODUCT(E1*2))+(PRODUCT(F1*6))+(PRODUCT(G1*10)).

Or in layman's terms, Great count + (good count * 2) + (boo count * 6) + (miss count * 10).

Then Column M will just turn into IF(L1<10, "SDG", "--").

I suppose i should factor "OK"s in there too, which is a nuisance, but i need to change how my spreadsheet handles them anyway - the NNR FAQ claims that "OK"s are the equivalent of 3 DP, and a lot of us were under the impression that it was 6 DP.

< / end geek post>

Comments

( read spoken (4) — speak )
abstracted
May. 20th, 2004 03:18 pm (UTC)
worst part being that i understood all of it.
i'm making a face.
lifeofmendel
May. 20th, 2004 03:22 pm (UTC)
hehe. geeks unite! 8-B
(Deleted comment)
lifeofmendel
May. 20th, 2004 07:46 pm (UTC)
rowr! :)
( read spoken (4) — speak )

profile



welcome to the lifeofmendel

you can also find me here:

meSubscribe to me on YouTube

calendar

March 2017
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031