Scoresheet Template

[MrRubix]

Download link: http://www.mediafire.com/?tindmxzihs9

This is a very basic version of an automatic rank-generator. You type a name and their corresponding score, and it will insert as needed.

If you wish to rank people by some number (e.g. time) where a LOWER number is better than a higher one, then you need to change one line of code in the VBA editor (Tools->Macro->Visual Basic Editor):

If insertscore <= Cells(i, 6) And Cells(i, 1) <> "" Then
should be changed to
If insertscore >= Cells(i, 6) And Cells(i, 1) <> "" Then

Other than that this should all work fine. Feel free to edit the code as you need depending on what you wish to use it for.

[sumzup]

Re: Scoresheet Template

If I enter in any scores, the box right next to Rank 1 (F4) turns into 0 when running the update ranks macro.

[MrRubix]

Re: Scoresheet Template

Eh? I don't get any such issue. Do you have macros enabled?

[Commandersa1]

Re: Scoresheet Template

Eh? I don't get any such issue. Do you have macros enabled?

It works for me, but when you input scores in the yellow box. Is it suppose to add the score to the already entered box, or replace the score that was previously entered?

[sumzup]

Re: Scoresheet Template

Oh em gee. I get it now...I thought you just entered all the scores in and then the macro would rank them, but now I understand that you enter them into the box and update for each entry.

[MrRubix]

Re: Scoresheet Template

Yes, sorry, I should have clarified. You type a name and score and then press the button, and it adds it into the list and sorts it. If you enter in a score for someone already in the list, it replaces the score. If you're holding multiple ranks for multiple rounds, then simply make a new worksheet and copy the button over and you'll have a second list.

[lxDestinyxl]

Re: Scoresheet Template

Eh. Is this really necessary? Some people might put it to good use, but I don't see anything wrong with the old way of scoring, other than being a little time consuming.

[Commandersa1]

Re: Scoresheet Template

Eh. Is this really necessary? Some people might put it to good use, but I don't see anything wrong with the old way of scoring, other than being a little time consuming.

It does not really help, and it requires the person to have Microsoft Excel.

[sumzup]

Re: Scoresheet Template

I think he only released this because Tass requested a version of whatever Rubix was using for Omnipwn2.

Most people do have Excel, and it's useful if you're lazy (though I will concede that there isn't that much of a convenience gain).

Personally, I would've preferred a template where you could go in and directly edit scores, and then have a macro rank them, but this works fine too.

[MrRubix]

Re: Scoresheet Template

Well there's nothing stopping you from directly editing scores and such, but if you're after a re-ordering function I could probably make one of those too

[Commandersa1]

Re: Scoresheet Template

Well there's nothing stopping you from directly editing scores and such, but if you're after a re-ordering function I could probably make one of those too

Where did you learn to use the VBA editor? I have always wanted to learn, but never really tried. Did you learn from practice, books, classes?

[MrRubix]

Re: Scoresheet Template

Classes. One of my majors is Operations and Information Management, and we use Excel/VBA often

[tha Guardians]

Re: Scoresheet Template

Where did you learn to use the VBA editor? I have always wanted to learn, but never really tried. Did you learn from practice, books, classes?

http://3volutionize.com/forums/

It's a really good community. It's not solely about programming, but the programmers there are really helpful. They got me started using VB6. Once you learn how to properly use VB, the rest is just remembering functions.

[danny53x]

Re: Scoresheet Template

I'm in a programming class this year (We're doing some vbasic inside of vstudio and 2nd semester we're doing some Java). Maybe I could organize a tournament using this, but I can't try it out right now since mediafire is blocked on this comp and I can't run anything.

[StepmaniaGod6969]

Re: Scoresheet Template

I clicked on it and it said invalid file.