drneau.com Forum Index drneau.com
A discussion board for drneau.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Scoring Method Help

 
Post new topic   Reply to topic    drneau.com Forum Index -> Scoring Methods
View previous topic :: View next topic  
Author Message
Commish
"Ace High"


Joined: 01 Apr 2008
Posts: 17
Location: Phoenix

PostPosted: Mon Jan 13, 2014 9:02 pm    Post subject: Scoring Method Help Reply with quote

Hey all, I'm trying to convert my league scoring method from Excel into Dr Neau and am having trouble. I think I'm close, but can't quite get it right. Can anyone help?

Here is my scoring method:

10 x (((Sqrt A) / (Sqrt B)) x (1 + (Sqrt C) - (B x 5))) + (10 x D)

A = Tournament Buy-in Count
B = Player Finish
C = Player Buy=in Cost
D = Player Knockout Count

For reference, using this method, last February, we had a tournament with 32 players, $60 buy-in, 1st place had 5 knockouts and earned 540 points.

I would post a picture or include the repository file of what I have so far in the software for reference, but I don't know how to do that on this bulletin board.


Any help that anyone can provide is greatly appreciated. Thanks in advance.

-Kurt
Back to top
View user's profile Send private message Visit poster's website
Commish
"Ace High"


Joined: 01 Apr 2008
Posts: 17
Location: Phoenix

PostPosted: Sat Jan 18, 2014 11:33 am    Post subject: Re: Scoring Method Help Reply with quote

Commish wrote:
Hey all, I'm trying to convert my league scoring method from Excel into Dr Neau and am having trouble. I think I'm close, but can't quite get it right. Can anyone help?

Here is my scoring method:

10 x (((Sqrt A) / (Sqrt B)) x (1 + (Sqrt C) - (B x 5))) + (10 x D)

A = Tournament Buy-in Count
B = Player Finish
C = Player Buy=in Cost
D = Player Knockout Count

For reference, using this method, last February, we had a tournament with 32 players, $60 buy-in, 1st place had 5 knockouts and earned 540 points.

I would post a picture or include the repository file of what I have so far in the software for reference, but I don't know how to do that on this bulletin board.


Any help that anyone can provide is greatly appreciated. Thanks in advance.

-Kurt



Anybody? I'd really appreciate some help if anyone is generous enough.

Thanks
Kurt
Back to top
View user's profile Send private message Visit poster's website
rumackay
"A Set of Mop Squeezers"


Joined: 15 Oct 2005
Posts: 60
Location: Queensland, Australia

PostPosted: Sun Jan 26, 2014 8:05 pm    Post subject: Reply with quote

G'day Kurt. There's not a lot of activity here any more but I still check in every so often to see if there's any news on updates, particularly the multiple tourneys at once option.

I had a look at your formula in excel and TM and I must have the order of operations wrong because I get 261.9 in TM and 226.9 in excel. Can you post some more info about your excel formula and I'll have a go in TM for you
_________________
-- Kingaroy High Rollers Poker Tour --
Back to top
View user's profile Send private message
Commish
"Ace High"


Joined: 01 Apr 2008
Posts: 17
Location: Phoenix

PostPosted: Sun Jan 26, 2014 8:49 pm    Post subject: Reply with quote

Thanks a bunch, rumackay. I really appreciate someone else giving this a shot. I'd attach the Dr Neau file with my attempt at the scoring method, but I don't know how to do that on this bulletin board.

We had our first tournament of the season last night and everyone was asking about their points, and I didn't have an answer for them. Worst case scenario, I use the manual method and still put the results in my spreadsheet and transfer the points manually, though that does defeat one large portion of Dr. Neau...

Here is my formula copied from Excel.

(10*(((SQRT(B4))/(SQRT(A7)))*(1+(SQRT(F2)))),0)-(A7*5))+10

A7 = Player Finish
B4 = Number of Players in Tournament
F2 = Buy-in cost

I added the 10 points at the end because we decided to award the bottom 1/3 with 10 points for playing, rather than 0 points. Top 2/3 will receive points based on the formula.

Our tournament last night had 23 players, $60 buy-in, 1st place had 5 knockouts and I calculate that he received 475 points.
Back to top
View user's profile Send private message Visit poster's website
rumackay
"A Set of Mop Squeezers"


Joined: 15 Oct 2005
Posts: 60
Location: Queensland, Australia

PostPosted: Mon Jan 27, 2014 6:14 am    Post subject: Reply with quote

Commish wrote:
Here is my formula copied from Excel.

(10*(((SQRT(B4))/(SQRT(A7)))*(1+(SQRT(F2)))),0)-(A7*5))+10

A7 = Player Finish
B4 = Number of Players in Tournament
F2 = Buy-in cost

I added the 10 points at the end because we decided to award the bottom 1/3 with 10 points for playing, rather than 0 points. Top 2/3 will receive points based on the formula.

Our tournament last night had 23 players, $60 buy-in, 1st place had 5 knockouts and I calculate that he received 475 points.

That's a little different from the first formula you posted Smile

That formula as copied and pasted returns an error. If it's "=round" there seems to be some brackets out of place. If I take a guess and remove a bracket at the end it calculated 424

Can you take a screen shot of the formula and post it here so I can take a look

Don't worry about the TM file. If we get the excel formula sorted I should be able to convert that to a TM scoring method for you easy enough
_________________
-- Kingaroy High Rollers Poker Tour --
Back to top
View user's profile Send private message
Commish
"Ace High"


Joined: 01 Apr 2008
Posts: 17
Location: Phoenix

PostPosted: Mon Jan 27, 2014 7:32 pm    Post subject: Reply with quote

You are correct sir. I copied only part of the formula from Excel. Guess I missed some key parts. Here is the entire formula.

=IF(A7<=(B4*(2/3)),(ROUNDUP(10*(((SQRT(B4))/(SQRT(A7)))*(1+(SQRT(F2)))),0)-(A7*5))+10,(10))

I believe your formula is correct, because if you add 10 points per knockout, you'd have 474, then the remaining point may just be a rounding issue. I tally the knockouts in a different column, then add the two to get the total tournament score.

If you want to private message me your email, I will send you my TM file as well as a screen shot or whatever else you think may be helpful, since I can't link an image here.

Thanks again.
Back to top
View user's profile Send private message Visit poster's website
rumackay
"A Set of Mop Squeezers"


Joined: 15 Oct 2005
Posts: 60
Location: Queensland, Australia

PostPosted: Tue Jan 28, 2014 3:48 pm    Post subject: Reply with quote

Cheers mate. I'll have a play around with it and see how I go. It's a shame there's not much happening in here anymore because a few of the old regulars were great at scoring formulas. But we'll give it a shot Smile
_________________
-- Kingaroy High Rollers Poker Tour --
Back to top
View user's profile Send private message
drneau
Site Admin


Joined: 13 Feb 2005
Posts: 2385
Location: Woodbury, MN

PostPosted: Fri Jan 31, 2014 9:56 am    Post subject: Reply with quote

rumackay wrote:
Cheers mate. I'll have a play around with it and see how I go. It's a shame there's not much happening in here anymore because a few of the old regulars were great at scoring formulas. But we'll give it a shot Smile


Just need new regulars.
_________________
--
Dr. Neau (not a real doctor)
http://drneau.com
http://home.comcast.net/~jneau
Back to top
View user's profile Send private message Send e-mail Visit poster's website
rumackay
"A Set of Mop Squeezers"


Joined: 15 Oct 2005
Posts: 60
Location: Queensland, Australia

PostPosted: Wed Feb 05, 2014 4:06 am    Post subject: Reply with quote

Ok, I finally had some time this evening so I sat down and I think I have it working, knockouts included:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<ScoringMethod Name="Commish" Type="Formula" Locked="false" LastModified="February 05, 2014 7:55:38:19 PM">
    <PlaceTieMethod Type="Average" />
    <TournamentScoringFormula>
        <TSFIfStatement>
            <TSFNumericalComparison Type="=&lt;">
                <TSFNumericVariable Type="Player Finish" />
                <TSFNumericFormula Type="Multiply">
                    <TSFNumericVariable Type="Tournament Buy-in Count" />
                    <TSFNumericFormula Type="Divide">
                        <TSFNumericConstant Value="2.0" />
                        <TSFNumericConstant Value="3.0" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
            </TSFNumericalComparison>
            <TSFNumericFormula Type="Add">
                <TSFNumericFormula Type="Add">
                    <TSFNumericConstant Value="10.0" />
                    <TSFNumericFormula Type="Multiply">
                        <TSFNumericConstant Value="10.0" />
                        <TSFNumericVariable Type="Player Knockout Count" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
                <TSFNumericFormula Type="Subtract">
                    <TSFNumericFormula Type="Round">
                        <TSFNumericFormula Type="Multiply">
                            <TSFNumericConstant Value="10.0" />
                            <TSFNumericFormula Type="Multiply">
                                <TSFNumericFormula Type="Divide">
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Tournament Buy-in Count" />
                                    </TSFNumericFormula>
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Player Finish" />
                                    </TSFNumericFormula>
                                </TSFNumericFormula>
                                <TSFNumericFormula Type="Add">
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Player Total Expense" />
                                    </TSFNumericFormula>
                                    <TSFNumericConstant Value="1.0" />
                                </TSFNumericFormula>
                            </TSFNumericFormula>
                        </TSFNumericFormula>
                    </TSFNumericFormula>
                    <TSFNumericFormula Type="Multiply">
                        <TSFNumericVariable Type="Player Finish" />
                        <TSFNumericConstant Value="5.0" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
            </TSFNumericFormula>
            <TSFNumericFormula Type="Add">
                <TSFNumericConstant Value="10.0" />
                <TSFNumericFormula Type="Multiply">
                    <TSFNumericConstant Value="10.0" />
                    <TSFNumericVariable Type="Player Knockout Count" />
                </TSFNumericFormula>
            </TSFNumericFormula>
        </TSFIfStatement>
    </TournamentScoringFormula>
</ScoringMethod>


If copy/paste into a new file in the scoring folder of your repository doesn't work then PM your email and I'll send you the file. I think save as xml, is that right Doc?
_________________
-- Kingaroy High Rollers Poker Tour --
Back to top
View user's profile Send private message
Commish
"Ace High"


Joined: 01 Apr 2008
Posts: 17
Location: Phoenix

PostPosted: Sat Feb 08, 2014 3:41 pm    Post subject: Reply with quote

rumackay wrote:
Ok, I finally had some time this evening so I sat down and I think I have it working, knockouts included:

Code:
<?xml version="1.0" encoding="UTF-8"?>
<ScoringMethod Name="Commish" Type="Formula" Locked="false" LastModified="February 05, 2014 7:55:38:19 PM">
    <PlaceTieMethod Type="Average" />
    <TournamentScoringFormula>
        <TSFIfStatement>
            <TSFNumericalComparison Type="=&lt;">
                <TSFNumericVariable Type="Player Finish" />
                <TSFNumericFormula Type="Multiply">
                    <TSFNumericVariable Type="Tournament Buy-in Count" />
                    <TSFNumericFormula Type="Divide">
                        <TSFNumericConstant Value="2.0" />
                        <TSFNumericConstant Value="3.0" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
            </TSFNumericalComparison>
            <TSFNumericFormula Type="Add">
                <TSFNumericFormula Type="Add">
                    <TSFNumericConstant Value="10.0" />
                    <TSFNumericFormula Type="Multiply">
                        <TSFNumericConstant Value="10.0" />
                        <TSFNumericVariable Type="Player Knockout Count" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
                <TSFNumericFormula Type="Subtract">
                    <TSFNumericFormula Type="Round">
                        <TSFNumericFormula Type="Multiply">
                            <TSFNumericConstant Value="10.0" />
                            <TSFNumericFormula Type="Multiply">
                                <TSFNumericFormula Type="Divide">
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Tournament Buy-in Count" />
                                    </TSFNumericFormula>
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Player Finish" />
                                    </TSFNumericFormula>
                                </TSFNumericFormula>
                                <TSFNumericFormula Type="Add">
                                    <TSFNumericFormula Type="Square Root">
                                        <TSFNumericVariable Type="Player Total Expense" />
                                    </TSFNumericFormula>
                                    <TSFNumericConstant Value="1.0" />
                                </TSFNumericFormula>
                            </TSFNumericFormula>
                        </TSFNumericFormula>
                    </TSFNumericFormula>
                    <TSFNumericFormula Type="Multiply">
                        <TSFNumericVariable Type="Player Finish" />
                        <TSFNumericConstant Value="5.0" />
                    </TSFNumericFormula>
                </TSFNumericFormula>
            </TSFNumericFormula>
            <TSFNumericFormula Type="Add">
                <TSFNumericConstant Value="10.0" />
                <TSFNumericFormula Type="Multiply">
                    <TSFNumericConstant Value="10.0" />
                    <TSFNumericVariable Type="Player Knockout Count" />
                </TSFNumericFormula>
            </TSFNumericFormula>
        </TSFIfStatement>
    </TournamentScoringFormula>
</ScoringMethod>


If copy/paste into a new file in the scoring folder of your repository doesn't work then PM your email and I'll send you the file. I think save as xml, is that right Doc?


You are a genius. I owe you a beer. I just gave it a shot with some of the old results from last year and everything seems to work. It may be a point off due to rounding, but I am not at all worried about that. Close enough for government work.

Thank you so much for lending a hand, rumackay. I really do appreciate your help!
Back to top
View user's profile Send private message Visit poster's website
rumackay
"A Set of Mop Squeezers"


Joined: 15 Oct 2005
Posts: 60
Location: Queensland, Australia

PostPosted: Sun Feb 09, 2014 12:17 am    Post subject: Reply with quote

Not a problem, happy I could help
_________________
-- Kingaroy High Rollers Poker Tour --
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    drneau.com Forum Index -> Scoring Methods All times are GMT - 6 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group