Advanced FFR Stats Made Easy

[tj28]

Re: Advanced FFR Stats Made Easy

I'm surprised that the drag 'n drop method didn't work. It worked like a charm using Vista + Excel 2007 and also with XP + Excel 2003. It must be that you copied the data a little differently. Don't worry, The Text Import Wizard (see above post) should sort that out for you

It works.
Paste Special->Text only.

[tofurox]

Re: Advanced FFR Stats Made Easy

Copy it directly from your level ranks. Then make the row height 20. And you got it. But wait, how do you remove all the hyperlinks....

[tofurox]

Re: Advanced FFR Stats Made Easy

I can fix it. Just copy straight from the level ranks. If the row heights are messed up, make them a uniform size, like 15. Then press alt+f11. Then ctr+g. And enter "selection.hyperlinks.delete" no quotes. And to fix the color, press ctr+a and then right click, and format. Then under patterns, make it white.

[tofurox]

Re: Advanced FFR Stats Made Easy

Ctr+A. Then go to Format> Row height. Make the row height 15. Next make sure the width of the columns is ok so everything appears on one line. Do that for your score, and for the level name. Just highlight the entire column and drag it larger. Then, with everything highlighted press Alr+F11. Then Ctr+G. And type in "selection.hyperlinks.delete" no quotes. Then highlight all again, and right click. Then click Format Cells> Patterns. And choose the color white. Got it? It's really basic, I just suck at explaining. If you get stuck anywhere tell me. It should look normal afterwords. Then continue following his steps.


WORKS 100% now! THANK YOU SO MUCH!

[musicdemon]

Re: Advanced FFR Stats Made Easy

If you've got Excel 2007, click the Normal button that you see in this screenshot to remove the hyperlinks:

[tofurox]

Re: Advanced FFR Stats Made Easy

Siily me and XP.

[tofurox]

Re: Advanced FFR Stats Made Easy

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

[tofurox]

Re: Advanced FFR Stats Made Easy

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]

Re: Advanced FFR Stats Made Easy

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]

Re: Advanced FFR Stats Made Easy

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

[samurai7694]

Re: Advanced FFR Stats Made Easy

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

[PsYcHoZeRoSk8eR]

Re: Advanced FFR Stats Made Easy

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]

Re: Advanced FFR Stats Made Easy

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]

Re: Advanced FFR Stats Made Easy

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.

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.

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.

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]

Re: Advanced FFR Stats Made Easy

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