Old 05-20-2008, 12:59 PM   #1
MrRubix
FFR Player
FFR Veteran
 
MrRubix's Avatar
 
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
Default 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.

Last edited by MrRubix; 05-20-2008 at 01:03 PM..
MrRubix is offline  
Old 05-20-2008, 01:13 PM   #2
sumzup
(+ (- (/ (* 1 2) 3) 4) 5)
FFR Veteran
 
sumzup's Avatar
 
Join Date: Nov 2005
Location: Seattle
Age: 32
Posts: 1,398
Send a message via AIM to sumzup Send a message via MSN to sumzup
Default 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.
__________________
sumzup is offline  
Old 05-20-2008, 01:51 PM   #3
MrRubix
FFR Player
FFR Veteran
 
MrRubix's Avatar
 
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
Default Re: Scoresheet Template

Eh? I don't get any such issue. Do you have macros enabled?
MrRubix is offline  
Old 05-20-2008, 05:02 PM   #4
Commandersa1
FFR Player
FFR Veteran
 
Commandersa1's Avatar
 
Join Date: Mar 2006
Age: 33
Posts: 2,344
Default Re: Scoresheet Template

Quote:
Originally Posted by MrRubix View Post
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?
__________________
Commandersa1 is offline  
Old 05-20-2008, 05:05 PM   #5
sumzup
(+ (- (/ (* 1 2) 3) 4) 5)
FFR Veteran
 
sumzup's Avatar
 
Join Date: Nov 2005
Location: Seattle
Age: 32
Posts: 1,398
Send a message via AIM to sumzup Send a message via MSN to sumzup
Default 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.
__________________
sumzup is offline  
Old 05-20-2008, 09:34 PM   #6
MrRubix
FFR Player
FFR Veteran
 
MrRubix's Avatar
 
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
Default 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.
MrRubix is offline  
Old 05-20-2008, 10:26 PM   #7
lxDestinyxl
FFR Player
FFR Veteran
 
Join Date: Mar 2006
Posts: 3,247
Send a message via AIM to lxDestinyxl
Default 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.
__________________
lxDestinyxl is offline  
Old 05-20-2008, 10:29 PM   #8
Commandersa1
FFR Player
FFR Veteran
 
Commandersa1's Avatar
 
Join Date: Mar 2006
Age: 33
Posts: 2,344
Default Re: Scoresheet Template

Quote:
Originally Posted by lxDestinyxl View Post
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.
__________________
Commandersa1 is offline  
Old 05-20-2008, 10:57 PM   #9
sumzup
(+ (- (/ (* 1 2) 3) 4) 5)
FFR Veteran
 
sumzup's Avatar
 
Join Date: Nov 2005
Location: Seattle
Age: 32
Posts: 1,398
Send a message via AIM to sumzup Send a message via MSN to sumzup
Default 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.
__________________
sumzup is offline  
Old 05-20-2008, 11:31 PM   #10
MrRubix
FFR Player
FFR Veteran
 
MrRubix's Avatar
 
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
Default 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
MrRubix is offline  
Old 05-20-2008, 11:49 PM   #11
Commandersa1
FFR Player
FFR Veteran
 
Commandersa1's Avatar
 
Join Date: Mar 2006
Age: 33
Posts: 2,344
Default Re: Scoresheet Template

Quote:
Originally Posted by MrRubix View Post
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?
__________________
Commandersa1 is offline  
Old 05-20-2008, 11:54 PM   #12
MrRubix
FFR Player
FFR Veteran
 
MrRubix's Avatar
 
Join Date: Dec 1969
Location: New York City, New York
Posts: 8,340
Default Re: Scoresheet Template

Classes. One of my majors is Operations and Information Management, and we use Excel/VBA often
MrRubix is offline  
Old 10-11-2008, 01:46 AM   #13
tha Guardians
MCDC 2011
FFR Veteran
 
tha Guardians's Avatar
 
Join Date: Nov 2006
Location: location, location~
Age: 83
Posts: 1,680
Send a message via AIM to tha Guardians Send a message via MSN to tha Guardians Send a message via Yahoo to tha Guardians
Default Re: Scoresheet Template

Quote:
Originally Posted by Commandersa1 View Post
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.
__________________

Quote:
Originally Posted by sonic-fast-fingers View Post
can someone clarrify what QFT means my friend told me its quit ****ing talking, but im not 100 percent sure

Quote:
Originally Posted by Synthlight
I need a car that drives itself completely automated and I want it for free and it needs infinite gas mileage.

Cheers,

Synthlight
tha Guardians is offline  
Old 10-16-2008, 06:20 AM   #14
danny53x
AKA Yotipo
FFR Veteran
 
danny53x's Avatar
 
Join Date: Jan 2007
Location: Henrico, Virginia
Age: 32
Posts: 1,008
Send a message via Skype™ to danny53x
Default 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.
__________________
danny53x is offline  
Old 05-2-2009, 12:50 PM   #15
StepmaniaGod6969
3 Fingers
FFR Veteran
 
StepmaniaGod6969's Avatar
 
Join Date: Jan 2007
Location: Flint, Michigan
Age: 39
Posts: 1,015
Send a message via AIM to StepmaniaGod6969
Default Re: Scoresheet Template

I clicked on it and it said invalid file.
__________________
Quote:
Originally Posted by Tasselfoot View Post
use your cock. unless it isn't long enough. and then i feel sorry for you.



StepmaniaGod6969 is offline  
Old 05-2-2009, 02:03 PM   #16
Dr Tran
Banned
 
Join Date: Aug 2008
Posts: 1,134
Default Re: Scoresheet Template

its an old thread with an old mediafire link that probably expired
Dr Tran is offline  
Old 10-17-2010, 10:25 PM   #17
wargasm1
Cowbelling FFR
FFR Veteran
 
wargasm1's Avatar
 
Join Date: Apr 2007
Age: 95
Posts: 1,289
Send a message via Skype™ to wargasm1
Default Re: Scoresheet Template

link is gone
wargasm1 is offline  
Old 11-24-2010, 02:06 AM   #18
Velocity
Doing the wrong thing the right way since 2010.
Site and Game Administrator
AdministratorRetired StaffDeveloperFFR Simfile AuthorD7 Elite KeysmasherFFR Veteran
 
Velocity's Avatar
 
Join Date: Jul 2007
Posts: 1,812
Default Re: Scoresheet Template

Closed/UnStuck for invalid Link.
Velocity is offline  
Closed Thread


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump



All times are GMT -5. The time now is 09:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright FlashFlashRevolution