Advanced FFR Stats Made Easy

[tofurox]

Siily me and XP.

[tofurox]

Oh god, my bad. It's under Format.

[tofurox]

Highligh all. Then right click. Format Cells. Then under patterns (or maybe a differnt tab in 2007) choose the clolor white. Either way click the color white.

[Bolth mannn]

i just realised how inconvenient this is. you have to keep copy pasting and go through all this whenever you update a score on a song. not worth the hassle.

guess its helpful to know i have 41 BFs though, easy enough to find out without this though

[foilman8805]

Delete and edit your ****ing posts Bolth. Try to keep this thread clean, it's not TGB.

[samurai7694]

hmm Didn't Rubix make something similar to this? Just wondering.

[PsYcHoZeRoSk8eR]

It is a really nice project you've started here. If I had known that there was a need for this kind of program I would have had it out weeks ago.

First, The only thing that yours is really missing that I know how to do is conditional formatting. Basically this will automatically color code and format cells based on the contents of the cells.

Also, You could look into automatically updating from a source file (possibly from the website itself) from another formula inside of the excel program. Unfortunately, I have not worked with this and I cannot offer much help other than where to look for this, though I would look into this to make things a whole lot easier for other users.


As for your question in the first post: you could compile a complete list of all of the songs and all of their stats on another sheet. Then reference this data based on the information inputted by the user. ie using excel as a mini database and query the information and compare it against the information provided. This might sound kinda stupid and redundant, but I know it will work.

I just spent way too long doing almost exactly this as a test to see if I could do this. Granted, I know that this would have been easier to do in other programs, I did it in excel anyways. Regardless, if you are looking for some help, or someone to bounce thoughts off give me a shout.

[musicdemon]

Originally Posted by PsYcHoZeRoSk8eR

It is a really nice project you've started here. If I had known that there was a need for this kind of program I would have had it out weeks ago.

First, The only thing that yours is really missing that I know how to do is conditional formatting. Basically this will automatically color code and format cells based on the contents of the cells.

Also, You could look into automatically updating from a source file (possibly from the website itself) from another formula inside of the excel program. Unfortunately, I have not worked with this and I cannot offer much help other than where to look for this, though I would look into this to make things a whole lot easier for other users.


As for your question in the first post: you could compile a complete list of all of the songs and all of their stats on another sheet. Then reference this data based on the information inputted by the user. ie using excel as a mini database and query the information and compare it against the information provided. This might sound kinda stupid and redundant, but I know it will work.

I just spent way too long doing almost exactly this as a test to see if I could do this. Granted, I know that this would have been easier to do in other programs, I did it in excel anyways. Regardless, if you are looking for some help, or someone to bounce thoughts off give me a shout.

I considered adding conditional formatting, but scrapped the idea for 2 reasons:

1) Excel 2003 only supports 7 nested IF statements. I currently have 6.
2) People will probably not like the default as a formatting style. For instance, I bold the lines of the songs that are AAAs. I also highlighted all Heavy-Get and Oni-Get songs in their respective colors (Green and Red). Some people may not like that, and will probably want some other combination of their choice for formatting.


Updating the source file is something I would DEFINITELY be interested in, because it nearly eliminates having to manually copy-paste your levelranks all the time. I'll do some research and see if it's even possible in Excel. It may only be do-able from the server-side using ASP.

The other more likely scenario would be to have a Greasemonkey script write the levelranks data to an excel file. I've made a few Greasemonkey scripts myself for Kongregate, and I'll see if I can find a way to export data to an Excel spreadsheet.

As for the querying a mini-database to get song information, I think that's a little overkill. If you can figure it out than be my guest, but that's a little out of my league at this point in time.

[PsYcHoZeRoSk8eR]

Originally Posted by musicdemon

I considered adding conditional formatting, but scrapped the idea for 2 reasons:

1) Excel 2003 only supports 7 nested IF statements. I currently have 6.
2) People will probably not like the default as a formatting style. For instance, I bold the lines of the songs that are AAAs. I also highlighted all Heavy-Get and Oni-Get songs in their respective colors (Green and Red). Some people may not like that, and will probably want some other combination of their choice for formatting.

1- correct, except that conditional formatting isn't something that you do from the formula. It is a completely separate process allowing up to 4 (i think) different formats based on a multitude of different things. This is by far the easiest thing to add that will really make the project a whole lot better in my opinion.

2- I'm going to assume that not everyone would like the same formatting. That being said if it is really bothering them that much they could always change it. It's a few simple clicks and then it's done. I realize that my idea of formatting is slightly different than what other people would like. Basically you are the one making this thing so you can have a little artistic control over what it is going to look like. After you release it, it's up to the users if they want to change it or not.

Originally Posted by musicdemon

Updating the source file is something I would DEFINITELY be interested in, because it nearly eliminates having to manually copy-paste your levelranks all the time. I'll do some research and see if it's even possible in Excel. It may only be do-able from the server-side using ASP.

Yeah, you're guess is as good as mine right now. But I would start off looking up how to use all the functions from excel as I know there was something there to do this.

Originally Posted by musicdemon

The other more likely scenario would be to have a Greasemonkey script write the levelranks data to an excel file. I've made a few Greasemonkey scripts myself for Kongregate, and I'll see if I can find a way to export data to an Excel spreadsheet.

This would work, but I was trying to stay away from scripts and work exclusively in excel.

Originally Posted by musicdemon

As for the querying a mini-database to get song information, I think that's a little overkill. If you can figure it out than be my guest, but that's a little out of my league at this point in time.

Yeah, it is overkill, but I can't think of a better way to have all of the information ready plus being able to compare things to. I'm pretty sure, depending on how in depth you wanted to go this could either be pretty simple or pretty complex. I'd start off with a simple version with the ability to add more if the users wanted something else.

[Card Man]

Interesting! This must have take a while to figure out! Thanks for sharing!

[musicdemon]

There's another way we can go with this. It still involves greasemonkey scripts, but it's possibly easier to do because it involves POSTing the data to Google Docs. The reason it may be easier is that it's already been done.

A good friend of mine over at Kongregate, Ventero, created a script that automatically updates the ratings of games in a spreadsheet on Google Docs. Here's the link: http://spreadsheets.google.com/ccc?k...ybHc&hl=en

I've already asked him to consider doing one like for the FFR levelranks, but he's kind of busy at the moment. For a more concrete example (source code) of what we're after, check out a similar script, Export To Google Docs from Google Analytics


Lastly, what does everyone do for formatting their spreadsheets? Now that I know we can do the formatting, what types do you use in your spreadsheets (a.k.a. bold, highlighting, text color, etc.) ?

I use:
1) Bold for AAAs
2) Italic for newly updated scores
3) Red/Green for Heavy & Oni-get songs

[championanwar]

From what's being said, I'm sure this would be really helpful +100!