Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Morphius

Pages: [1] 2
1
Help Me / Re: Formula Help
« on: February 23, 2008, 09:00:03 AM »
nevermind i got it i shouldve scrolled down half an inch more lol count(scores) =D

Thanks Corey for all your help you've got an amazing program :D

2
Help Me / Re: Formula Help
« on: February 23, 2008, 08:55:08 AM »
Thanks Corey thats much better...

However just noticed an error in the formula.... n is the number of players in a tournament, when I want to be using number of tournaments played... i cant find a variable for this in the help... is there one that i just havent noticed?

3
Help Me / Re: Formula Help
« on: February 22, 2008, 09:32:57 AM »
If I used Scores it averages the rank that people came in the tournament, i wanted to use points

Just noticed the formula works on scores not points... if i change the word to points will it recognise it as all i get at the moment is Formula Error

Ignore it.  It's a bug in 2.4.3 that the "points" variable isn't recognized, but it's only in the dialog.  It will still work in the formula itself.

4
Help Me / Re: Formula Help
« on: February 21, 2008, 09:47:03 PM »
p.s. its named league points but its the same as Overall Score 1

5
Help Me / Re: Formula Help
« on: February 21, 2008, 09:33:53 PM »
Just thought, I'm meant to be putting this code in Overall Scores yes?

exporting my stats tab to CSV ive posted at the bottom, the overall score formula is if(n >= 5, average(points) + 0.5*n, 0)


Code: [Select]
#,Name,Buy-ins,Hits,Total Cost,Total Winnings,Total Take,Points,League Points
1,Naveen Bhatia,7,2,46.00,107.50,61.50,70.00,0.0000
2,Jason Lloyd,9,3,59.00,108.50,49.50,68.00,0.0000
3,Jack Robinson,8,1,60.00,81.00,21.00,67.00,0.0000
4,ciaran ellis,3,2,19.00,149.50,130.50,64.00,0.0000
5,Tom Cooper,9,2,61.00,85.00,24.00,57.00,0.0000
6,Jahnyah Rose,10,7,64.00,125.00,61.00,51.00,0.0000
7,Andrew Fox,10,1,68.00,70.00,2.00,51.00,0.0000
8,Matt Bennington,7,2,57.00,45.00,-12.00,44.00,0.0000
9,divya patel,9,1,61.00,35.00,-26.00,44.00,0.0000
10,James Browne,4,0,20.00,35.00,15.00,39.00,0.0000
11,Kieran Girvan,3,4,25.00,60.00,35.00,32.00,0.0000
12,Stephen Demergasso,2,0,10.00,10.00,0.00,29.00,0.0000
13,Luke Morgan,2,0,10.00,55.00,45.00,26.00,0.0000
14,Fred Thurgood,6,3,43.00,52.50,9.50,25.00,0.0000
15,Scott Russell,6,1,36.00,15.00,-21.00,24.00,0.0000
16,Malcolm Kotwal,1,0,5.00,20.00,15.00,21.00,0.0000
17,Kieran Butterworth,6,0,40.00,0.00,-40.00,21.00,0.0000
18,Jon Barnes,3,0,21.00,67.00,46.00,21.00,0.0000
19,James Pollock,4,1,30.00,20.00,-10.00,20.00,0.0000
20,Andy Cooper,2,0,15.00,30.00,15.00,19.00,0.0000
21,Adam Bulleid,7,0,42.00,0.00,-42.00,18.00,0.0000
22,Martin Werren,3,1,25.00,10.00,-15.00,17.00,0.0000
23,Tassilo Rukavina,6,0,34.00,5.00,-29.00,16.00,0.0000
24,Matthew Brown,3,2,28.00,24.00,-4.00,16.00,0.0000
25,AB Saraswat,1,0,5.00,0.00,-5.00,15.00,0.0000
26,Stephen Hughes,3,5,25.00,40.00,15.00,13.00,0.0000
27,Ashley Long,8,0,60.00,0.00,-60.00,13.00,0.0000
28,Paul Jones,6,2,42.00,20.00,-22.00,12.00,0.0000
29,Liam Casey,3,0,15.00,10.00,-5.00,12.00,0.0000
30,Brad Prichard,1,0,10.00,5.00,-5.00,12.00,0.0000
31,Daniel Solicari,6,0,52.00,0.00,-52.00,11.00,0.0000
32,Zar Damani,1,2,10.00,15.00,5.00,6.00,0.0000
33,Paul Dennett,4,0,25.00,0.00,-25.00,2.00,0.0000
34,Tom Howells,1,0,5.00,0.00,-5.00,0.00,0.0000
35,Simon Barker,1,0,5.00,0.00,-5.00,0.00,0.0000
36,Ryan Harmer,1,0,7.00,5.00,-2.00,0.00,0.0000
37,Quentin R,1,0,5.00,0.00,-5.00,0.00,0.0000
38,Peter Howe,1,0,5.00,0.00,-5.00,0.00,0.0000
39,Mike Williams,2,0,10.00,0.00,-10.00,0.00,0.0000
40,Laura Noakes,2,0,16.00,0.00,-16.00,0.00,0.0000
41,Kyle Stuart,2,0,10.00,0.00,-10.00,0.00,0.0000
42,jonny baig,1,0,5.00,0.00,-5.00,0.00,0.0000
43,john bailey,1,0,5.00,0.00,-5.00,0.00,0.0000
44,Joe Seals,1,0,5.00,0.00,-5.00,0.00,0.0000
45,Jim Lawell,6,1,45.00,10.00,-35.00,0.00,0.0000
46,Jamie Harland,1,0,10.00,5.00,-5.00,0.00,0.0000
47,Freddy,1,0,5.00,0.00,-5.00,0.00,0.0000
48,Chris Thussan,2,0,15.00,0.00,-15.00,0.00,0.0000
49,chris donze,1,0,5.00,0.00,-5.00,0.00,0.0000
50,Chris Aston,3,0,15.00,0.00,-15.00,0.00,0.0000
51,Catie Dear,1,0,4.00,0.00,-4.00,0.00,0.0000
52,Andy Scraton,1,0,5.00,0.00,-5.00,0.00,0.0000
53,adam bennett,1,0,5.00,0.00,-5.00,0.00,0.0000

6
Help Me / Re: Formula Help
« on: February 15, 2008, 01:20:50 PM »
yeah they do, ill give it another go later, cheers for your help

7
Help Me / Re: Formula Help
« on: February 15, 2008, 11:49:19 AM »
basically that works on their ranking in the tournaments not the points theyve received, so when putting the attribute points in there it comes up with an error and puts all the overall scores to 0

8
Help Me / Re: Formula Help
« on: February 14, 2008, 11:06:21 AM »
Tournament Score
Code: [Select]
switch(r, 1, n,
  2, if(n >= 4, n-2*r, 0),
  3, if(n >= 6, n-2*r, 0),
  4, if(n >= 8, n-2*r, 0),
  5, if(n >= 10, n-2*r, 0),
  6, if(n >= 12, n-2*r, 0),
  7, if(n >= 14, n-2*r, 0),
  8, if(n >= 16, n-2*r, 0),
  9, if(n >= 18, n-2*r, 0),
  10, if(n >= 20, n-2*r, 0))

This works fine

Overall Score

Code: [Select]
if(n >= 5, average(scores) + 0.5*n, 0)

9
Help Me / Re: Formula Help
« on: February 10, 2008, 07:23:30 AM »
For example if i have the formula using scores for someone who has played 6 games with 48 points should have 11 league points, but it says 4.***

any help

10
Help Me / Re: Formula Help
« on: February 07, 2008, 08:44:22 AM »
if i use scores it uses the ranking rather than what points they have

11
Help Me / Re: Formula Help
« on: February 06, 2008, 01:16:38 PM »

if(n >= 5, average(points) + 0.5*n, 0)

doesn't seem to give anything but zero even after 5 games =/

12
Help Me / Re: Formula Help
« on: January 24, 2008, 07:41:25 PM »
i changed it to five so will wait until five games have been played to tell you cheers for the help

13
Help Me / Re: Formula Help
« on: January 23, 2008, 02:11:37 PM »
jsut trying the formula (we have played one game) with 1 instead of 7 games, and it gives the error which I ignoredbut then all the Overall scores show as 0 even people with points

14
Help Me / Re: Formula Help
« on: January 23, 2008, 12:47:20 PM »
Cheer's Corey... loving the system by the way =) does make everything look more professional and sleek and alot easier to run...

next step Layouts and learning them!

15
Help Me / Re: Tournament formulas throughout a series of events
« on: January 22, 2008, 09:25:34 AM »
You really need to think up your own formula...

You could do something like...

Points = Number of players - rank (so the better you do the more points) - Number of Rebuys + Number of hits

Pages: [1] 2