DDR Extreme Scoresheet

ninjafetus · Posted: Wed Oct 22, 2003 8:33 am Post subject: DDR Extreme Scoresheet

I made a DDR scoresheet in MS Excel, for anyone who's interested.

The biggest feature is that it allows you to "level up" in different categories (singles, From GF&DM, IIDXBoss?) based on your song scores. Light, standard, heavy, and foot levels are all included in the "experience" given per song. It's pretty self explanatory, idiot-proof (you won't accidentally mess it up), and easy to use.

You can get it here. Please copy and paste into browser. It is on a free account, so if it goes down, just try again tomorrow.

http://www28.brinkster.com/ninjafetus/random%20stuff/DDR%20Scoresheet.xls

The sheet is protected so you can only select to boxes to place scores in, and won't mess up any formulas. For anyone who wants to mess around with it, and see how it works, the unprotect password (for all three sheets) is "ddrscoresheet" (without quotes, obviously).

Any feedback and errors pointed out would be appreciated. The only feature it's really missing is doubles oni scores, and I don't want to find the max values myself. Also, I might be putting this up as part of a webpage (which will then keep track of everyone and rank them against each other), so if enough people express interest, I might get working on that sooner.

If you read this, or downloaded, thanks! "We are happy if you have enjoyed!"
_________________

Drunk Slugs.

cfusionpm · Trick Member Joined: 24 Jan 2002 Location: San Diego, CA

HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.
_________________

DDR | My YouTube Channel

J.R. · Posted: Wed Oct 22, 2003 8:41 am Post subject:

If your gonna post a link make sure it works and also it should be in your sig. I think this counts as advertising.
_________________

J.R.'s Bemani page mainly IIDX.
http://www.livejournal.com/users/solidsnake2085/
Song of the week:Mr.Larpus/Banya
Rated #177 Vjarmy IIDX player!AWESOME!

ninjafetus · Posted: Wed Oct 22, 2003 8:46 am Post subject:

Ok, first off, I did say "Please copy and paste into browser". Brinkster doesn't like direct linking... if THAT didn't work, tell me again.

And, I wouldn't consider this advertising. It's not another site, it's just a DDR related thing to use if you're interested.
_________________

Drunk Slugs.

Syxx · Trick Member Joined: 20 Feb 2003 Location: Chicagoland

Stop giving this guy such a hard time. And pretending that you're a mod. He didn't post a link to his webpage, just a spread sheet he made to help people. Anyway, the link works fine now.
_________________

whites

J.R. · Posted: Wed Oct 22, 2003 9:22 am Post subject:

Ok I got it but it won't let me put in any scores except in the Extreme section all the other sections it says the value you entered is not valid,A user has restricted values that can be entered into this cell.
_________________

J.R.'s Bemani page mainly IIDX.
http://www.livejournal.com/users/solidsnake2085/
Song of the week:Mr.Larpus/Banya
Rated #177 Vjarmy IIDX player!AWESOME!

ninjafetus · Posted: Wed Oct 22, 2003 9:45 am Post subject:

That's odd... I just d/l-ed it from the site and tried it, and it works fine for me. It won't let you put anything but positive whole numbers in the sheet, though, so if you tried 13.6 or "fish" for some reason, that won't work... Also, you are only supposed to put values in the page labeled "great count"... you aren't allowed to change the "foot difficulty" or "score calculation" page.

If you want to, try opening it in Excel, and go to Tools...Protection...unprotect sheet. Password "ddrscoresheet". Then, click on one of those cells, and go to data...validation. If the settings aren't "whole number greater than or equal to zero", then something's up... I don't know why mine would work and your's not, though...

There is also a typo... the points are not 100* foot difficulty. They are foot difficulty times 100 for light, 125 for standard, and 150 for heavy/oni.
*EDIT* Fixed typo.
_________________

Drunk Slugs.

Zukin-Man · Trick Member Joined: 25 Nov 2002 Location: War Agony

Very nice. Expect me to use it today/tonight.

_________________

DD:Recall (Defunct) - Last.fm - YouTube
Newest Video - Soul Calibur IV - Bemani Critical Finishes ver. 1.5

ninjafetus · Posted: Wed Oct 22, 2003 12:51 pm Post subject:

GD-Man · Trick Member Joined: 01 Jul 2002

Nice work.

This is exactly what I wanted, but with 10 times the functionality.
_________________

Gee, the One thing that FrUstrates me the most is when i see a sCreenname or sentence lacKing anY Ordinary rUles foR SpElling and capitaLization. Funny that very few actually have a rhyme or reason behind their methods.

Zukin-Man · Trick Member Joined: 25 Nov 2002 Location: War Agony

Just tried it out tonight. Haven't gotten too far into it yet, though.

Extreme = Level 3
Max 2 = Level 7
Max = Level 4
4th Mix = Level 1
DDR Home Versions = Level 2
Keyboard Mania = Level 14
GF/DM = Level 4
Pop'n = Level 7
IIDX = Level 3
Everything else is untouched.

Yet, somehow this makes me a Level 4 Heavy and Level 8 Oni player, and a Level 2 overall player. Explain the grading system for a moment.
_________________

DD:Recall (Defunct) - Last.fm - YouTube
Newest Video - Soul Calibur IV - Bemani Critical Finishes ver. 1.5

ninjafetus · Posted: Thu Oct 23, 2003 10:52 am Post subject:

Zukin-Man · Trick Member Joined: 25 Nov 2002 Location: War Agony

Thanks for the explanation. Thought, mind, and nasal passages are all clear!
_________________

DD:Recall (Defunct) - Last.fm - YouTube
Newest Video - Soul Calibur IV - Bemani Critical Finishes ver. 1.5

matt4596 · Trick Member Joined: 09 Jul 2002 Location: Orlando, FL

could you make a non-password'd file? my pda that i bring to the arcade can't read password protected excel workbooks. i don't have excel on my computer to make the modification myself.

otherwise i love this idea.

Irish.MTA (Retired?) · Trick Member Joined: 28 Apr 2003 Location: Clemson, SC

I'm now keeping scores on my site, AIJ, and this spread sheet... What a pain. I hate you for making me use this.

-Irish
_________________

The winds of change are oft unpredictable...

ninjafetus · Posted: Fri Oct 24, 2003 9:09 am Post subject:

matt4596 · Trick Member Joined: 09 Jul 2002 Location: Orlando, FL

Crescent · Posted: Fri Oct 24, 2003 11:47 am Post subject:

I hate you, because I tried to open the file and now excel won't work correctly anymore. And I have a lab writeup due monday, so that's really not a GOOD thing.

EXCEL caused an invalid page fault in
module KERNEL32.DLL at 017f:bff7b9a6.
Registers:
EAX=00000000 CS=017f EIP=bff7b9a6 EFLGS=00000246
EBX=0000c000 SS=0187 ESP=0062e3f4 EBP=0062e404
ECX=842ac7c0 DS=0187 ESI=007f0e20 FS=775f
EDX=842ac7c0 ES=0187 EDI=00000000 GS=0000
Bytes at CS:EIP:
ff 76 04 e8 13 89 ff ff 5e c2 04 00 56 8b 74 24
Stack dump:
7803a08c 78001075 007f0e20 00000004 0062e434 780040e9 00000019 00000000 00000004 0000c000 007f0e40 bff95faa bff8c5da 0000c000 780040cb 00000000
_________________

i'd walk in the rain

ninjafetus · Posted: Fri Oct 24, 2003 10:33 pm Post subject:

technos> Ok, get the unlocked version at

http://www28.brinkster.com/ninjafetus/random%20stuff/DDR%20Scoresheet%20unlocked.xls

Remember, copy and paste, you can't just click it. If I'm correct, though, Excel viewer is just that. You can only view, and I don't think you can change things, or save. I'm not sure, but the sheets are unlocked on this one. If it doesn't work, it looks like you'll just need to find Excel somewhere. Eventually, if enough people like this, I'll put it on a web page so you won't need Excel, but for now, this is all I can do

stephanie> Holy crap, that's not good. I don't know what went wrong (it seems to work for other people), but I apologize... the only thing I can think of is a corrupt download or some different Excel version error. I don't see how a different version should matter, but I'm running Excel 2002 on an XP system... If you can't get Excel to open at all, I think your best bet is to probably re-install it. (Unless someone else knows what to do).

As far as your lab, I'd say just write it up at your school library if there's absolutely no other computers you can use.
_________________

Drunk Slugs.

matt4596 · Trick Member Joined: 09 Jul 2002 Location: Orlando, FL

thanks, it works on my pda now.

very excellent sheet. will be very useful at the arcade.