Trapshooters Forum banner

Status
Not open for further replies.
1 - 20 of 46 Posts

·
Registered
Joined
·
112 Posts
Discussion Starter · #1 ·
Hey folks,

I haven't posted here in a while, but I thought maybe some of you might be able to use my latest monster. It is an Excel spreadsheet to figure a simple three class Lewis.

On the first sheet you need to enter a value (any value 1,y,n,x) in the left LEW column, to indicate if the shooter is playing the purse. You then enter all shooters' first and last names in the appropriate columns. You then enter the scores for each round in the appropriate columns.

On the second sheet (the tab on the bottom named LEWIS PAYOUT) you simply enter the amount you are charging for the option in the cell next to "lewis cost". It is at 5 right now.

The spreadsheet will calculate the winning scores and return the names and dollar amounts of the winners on the second sheet. It is an even money division with 1 place in each of 3 classes.

I have tested this on quite a few scenarios. It has come back correct every time, but it is new.

You can download the sheet at www.cwtatrap.com/lewis

Thanks,

Jake
 

·
Registered
Joined
·
2,829 Posts
B 525 ...

Basic Lewis Class:

When all the shooting has been completed, the scores are listed in numerical order from the highest to the lowest. They are then divided into as many groups as there are classes. For example, if there were 30 entries and 5 classes, there would be 6 scores in each class. The highest score in each class would then be the winner.

See the link above for other "options". Bill Malcolm
 

·
Registered
Joined
·
112 Posts
Discussion Starter · #4 ·
It most certainly does. All basic lewis rules are accounted for. I wouldn't have any use for it if it didn't. That stuff was the tricky part.
 

·
Registered
Joined
·
112 Posts
Discussion Starter · #5 ·
1100 nut,

if you need any other options or customizing added let me know (including category trophies). 50's, 25's, and HighGun are a piece of cake compared to the Lewis.
 

·
Registered
Joined
·
4,120 Posts
It asks me to unprotect, tools>protection. I did, it asked for a password, I put mine in and it said incorrect. What now?
 

·
Super Moderator
Joined
·
5,320 Posts
If you follow the instructions provided by Jake, above, you should have no need to "unprotect" anything. My guess is you tried to put something in column "J." The indication as to whether someone played the Lewis needs to go in column "B" instead.
 

·
Registered
Joined
·
112 Posts
Discussion Starter · #14 ·
The sheet has been updated. The cell on the second sheet to enter the amount for the option is now blue. The cells on the first sheet where you enter whether or not a shooter is playing the option are also blue. Remember, do not enter ANY value in the LEW column on the first sheet if the shooter is not playing the Lewis.
 

·
Registered
Joined
·
112 Posts
Discussion Starter · #18 ·
What version of Excel are you running? Perhaps there are some formulas that won't translate to an older version. I'm running Office 2003.
 
G

·
That might be it...I'm using the newest version of Open Office which is supposed to take the place of both MSWord and Excel.

Mike
 
1 - 20 of 46 Posts
Status
Not open for further replies.
Top