![]() |
#1 |
FFR Player
![]() Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
![]() 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.. |
![]() |
![]() |
#2 |
(+ (- (/ (* 1 2) 3) 4) 5)
![]() |
![]() If I enter in any scores, the box right next to Rank 1 (F4) turns into 0 when running the update ranks macro.
__________________
![]() |
![]() |
![]() |
#3 |
FFR Player
![]() Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
![]() Eh? I don't get any such issue. Do you have macros enabled?
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
![]() |
![]() |
#4 |
FFR Player
![]() Join Date: Mar 2006
Age: 33
Posts: 2,344
|
![]()
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?
__________________
![]() |
![]() |
![]() |
#5 |
(+ (- (/ (* 1 2) 3) 4) 5)
![]() |
![]() 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.
__________________
![]() |
![]() |
![]() |
#6 |
FFR Player
![]() Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
![]() 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 |
![]() |
![]() |
#7 |
FFR Player
![]() |
![]() 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.
__________________
![]() |
![]() |
![]() |
#8 |
FFR Player
![]() Join Date: Mar 2006
Age: 33
Posts: 2,344
|
![]()
It does not really help, and it requires the person to have Microsoft Excel.
__________________
![]() |
![]() |
![]() |
#9 |
(+ (- (/ (* 1 2) 3) 4) 5)
![]() |
![]() 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.
__________________
![]() |
![]() |
![]() |
#10 |
FFR Player
![]() Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
![]() 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 |
![]() |
![]() |
#11 |
FFR Player
![]() Join Date: Mar 2006
Age: 33
Posts: 2,344
|
![]()
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?
__________________
![]() |
![]() |
![]() |
#12 |
FFR Player
![]() Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
|
![]() Classes. One of my majors is Operations and Information Management, and we use Excel/VBA often
__________________
https://www.youtube.com/watch?v=0es0Mip1jWY |
![]() |
![]() |
#13 | |||
MCDC 2011
![]() |
![]() 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:
|
|||
![]() |
![]() |
#14 |
AKA Yotipo
![]() |
![]() 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.
|
![]() |
![]() |
#15 |
3 Fingers
![]() |
![]() I clicked on it and it said invalid file.
|
![]() |
![]() |
#16 |
Banned
Join Date: Aug 2008
Posts: 1,134
|
![]() its an old thread with an old mediafire link that probably expired
|
![]() |
![]() |
#17 |
Cowbelling FFR
![]() |
![]() link is gone
|
![]() |
![]() |
#18 |
Doing the wrong thing the right way since 2010.
Site and Game Administrator
![]() ![]() ![]() ![]() ![]() ![]() Join Date: Jul 2007
Posts: 1,813
|
![]() Closed/UnStuck for invalid Link.
|
![]() |
![]() |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
|
|