05-20-2008, 12:59 PM | #1 |
FFR Player
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
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.
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY Last edited by MrRubix; 05-20-2008 at 01:03 PM.. |
05-20-2008, 01:13 PM | #2 |
(+ (- (/ (* 1 2) 3) 4) 5)
|
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.
__________________
|
05-20-2008, 01:51 PM | #3 |
FFR Player
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
Re: Scoresheet Template
Eh? I don't get any such issue. Do you have macros enabled?
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
05-20-2008, 05:02 PM | #4 |
FFR Player
Join Date: Mar 2006
Age: 33
Posts: 2,344
|
Re: Scoresheet Template
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?
__________________
|
05-20-2008, 05:05 PM | #5 |
(+ (- (/ (* 1 2) 3) 4) 5)
|
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.
__________________
|
05-20-2008, 09:34 PM | #6 |
FFR Player
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
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.
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
05-20-2008, 10:26 PM | #7 |
FFR Player
|
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.
__________________
|
05-20-2008, 10:29 PM | #8 |
FFR Player
Join Date: Mar 2006
Age: 33
Posts: 2,344
|
Re: Scoresheet Template
It does not really help, and it requires the person to have Microsoft Excel.
__________________
|
05-20-2008, 10:57 PM | #9 |
(+ (- (/ (* 1 2) 3) 4) 5)
|
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.
__________________
|
05-20-2008, 11:31 PM | #10 |
FFR Player
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
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
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
05-20-2008, 11:49 PM | #11 |
FFR Player
Join Date: Mar 2006
Age: 33
Posts: 2,344
|
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?
__________________
|
05-20-2008, 11:54 PM | #12 |
FFR Player
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
Re: Scoresheet Template
Classes. One of my majors is Operations and Information Management, and we use Excel/VBA often
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
10-11-2008, 01:46 AM | #13 | |||
MCDC 2011
|
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.
__________________
Quote:
Quote:
|
|||
10-16-2008, 06:20 AM | #14 |
AKA Yotipo
|
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.
|
05-2-2009, 12:50 PM | #15 |
3 Fingers
|
Re: Scoresheet Template
I clicked on it and it said invalid file.
|
05-2-2009, 02:03 PM | #16 |
Banned
Join Date: Aug 2008
Posts: 1,134
|
Re: Scoresheet Template
its an old thread with an old mediafire link that probably expired
|
10-17-2010, 10:25 PM | #17 |
Cowbelling FFR
|
Re: Scoresheet Template
link is gone
|
11-24-2010, 02:06 AM | #18 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
Join Date: Jul 2007
Posts: 1,813
|
Re: Scoresheet Template
Closed/UnStuck for invalid Link.
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|