Audition Global

Full Version: Audition Stats Calcluator
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I was bored so I decided to create a excel spreadsheet that will calculate your stats based on submitted data!
<a href="http://amidamaruflame.googlepages.com/AuditionScoresTemplate.xls" target="_blank">Score Calculator (Right Click>Save As)</a>

Here's an example:
[Image: example.jpg]

How to use:
First off... you have to have the data.... either ss it or write it down... your choice!

Second, enter the data starting in row 3. (For each game, enter data for column a to h (in order to get a correct average score and games recorded, you MUST enter a BPM!)

After that the data is automatically generated! I'm working on a way for you to upload your excel SS, and generate an image signature (it may be a while tho)

oh and a breakdown of the calculations:
Total Moves: Total of all moves (Perfect, Great, Cool etc...)
% (Perfect, Great, Cool etc...):Percent of moves that were (Perfect, Great, Cool etc...) this also calculates your odds of getting a perfect (mine is 44%)
Average Rank:Shows what you generally get when playing
Average BPM:How fast can you go?
Games Recorded:Amount of games you have data for.
Average Score:good, but gets fucked up if you include b-boy XDXD
Average Points Per Move: If you were to do your average for every move, this is what you'd score
Name:Type it in
Level:Type it in

if you want anything else, please let me know!
So... let's see your stats XD
<!--coloro:hotpink--><span style="color:hotpink"><!--/coloro-->Whoaaaaa thats uber awsome!!! I'ma gonna try it out Big Grin !! <!--colorc--></span><!--/colorc-->
That must've been a headache to put together, or it would have for me anyway. (Me and math aren't on speaking terms.) I can't look at the spreadsheet right now, need to reinstall OpenOffice. Tongue
I love you for this Tsuyo. Let's see how much I suck after seven games.

Total Moves 342
% Perfect 30%
% Great 56%
% Cool 8%
% Bad 1%
% Missed 6%
Average Rank 1
Average BPM 114.1428571
Games Recorded 7
Average Score 400000.5714
Average Points Per Move 1169.592314
Name Rewind
Level 19
Rofl, I'll try this later XD
Ok I heard of boredom but nottt quite like this. Cool ^^
lol I fail:
[Image: eau01.png]
I was playing with 1 other girl in eAU today so yeah XD;
shubygirl Wrote:lol I fail:
[Image: eau01.png]
I was playing with 1 other girl in eAU today so yeah XD;

lol that is why my rank was soo high too~

oh yeah.... i'm thinking of adding a way to monitor progress by date..... and make it viewable as a bar graph? what should i make the statistics? this is a question for anyone.... not just shuby...
hey nice invention Smile
ill try this, as soon as my graphics driver starts working Smile
Oh that's an cool idea! Well done ^^
Sweet ._.

Very, very useful ;D
why don't you try use macros?

just use some VB codes and you can put in the graphs and/or modify the table to include more than 5 rounds
The only thing it's lacking here is dance style option, chance option, and combos.

Though if we did disregard those, we'd really be pressured into doing better. DISCIPLINE FTL!
(01-13-2009 01:06 PM)Silverhawke Wrote: [ -> ]why don't you try use macros?

just use some VB codes and you can put in the graphs and/or modify the table to include more than 5 rounds

2 YEAR OLD TOPIC PERSON IT..........read.... reviving dead threads kills a kittenSad
Whoops

didn't saw that xD

i'm still new to this forum
Reference URL's