Scoresheet Template
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. |
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.
|
Re: Scoresheet Template
Eh? I don't get any such issue. Do you have macros enabled?
|
Re: Scoresheet Template
Quote:
|
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.
|
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.
|
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.
|
Re: Scoresheet Template
Quote:
|
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. |
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
|
Re: Scoresheet Template
Quote:
|
Re: Scoresheet Template
Classes. One of my majors is Operations and Information Management, and we use Excel/VBA often
|
Re: Scoresheet Template
Quote:
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. |
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.
|
Re: Scoresheet Template
I clicked on it and it said invalid file.
|
Re: Scoresheet Template
its an old thread with an old mediafire link that probably expired
|
Re: Scoresheet Template
link is gone
|
Re: Scoresheet Template
Closed/UnStuck for invalid Link.
|
All times are GMT -5. The time now is 09:36 AM. |
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright FlashFlashRevolution