tricast spreadsheet

[piggy]

:yikes: HELP,i'm putting a racenight on in the near future and iv'e been trying to work out how to print a sheet with 120 squares each containing a different tricast, just can't get my head around it can anyone help??? please

[mathare]

Are you struggling with the printing of the sheet or actually getting the 120 tricasts worked out?

120 tricasts means you have a fixed (known) number of runners, yes? I could work out what that is but I can't be bothered.

What format do you want it in? I am guessing Excel but how do you want it arranged within the file? A 10x12 grid or what? What format do you want for the tricast strings? 1-2-3 for example or something else

[TheOldhamWhisper]

Use excel and then format the cells to be square.

[bigmazey]

Is it for 8 runners per race piggy

[mathare]

Is it for 8 runners per race piggyIf tricast is first 3 in the correct order, which I thought it was, then 120 tricasts means 6 runners in the race. 1-2-3 is not the same as 1-3-2 etc which means there are 6 times as many permutations as combinations. There are 20 ways of selecting 3 from 6 (combinations) so 120 ways of selecting 3 from 6 when the order matters (permutations).

[TheOldhamWhisper]

http://www.racingwhisper.com/tritest.asp

Is this what you are looking for?

[piggy]

thats it but for 8 runners oldham

[piggy]

arrgghh, i was reading this page and thought it would be an extra to make money on.
http://www.racenights.co.uk/#
they reckon 8 runners = 120

[TheOldhamWhisper]

I've updated it for 8 runners - but you probably worked out by now that there's a few extra columns :D

[piggy]

no they don't i misread it so is it 112 squares 3 in a square so 336

[mathare]

no they don't i misread it so is it 112 squares 3 in a square so 336Sounds right to me.

[bigmazey]

You would have 280 different tricasts for eight runners. Why not do forecasts
There are 56 for each race pay out half to winner ie £28.

if you dont sell them all and noone wins in race 1 then roll over to race 2 increasing the pool.

i have attached a simple sheet you can use

[mathare]

You would have 280 different tricasts for eight runners.Definitely 336 tricasts for 8 runners. Excel says so :)

=permut(8,3)

[TheOldhamWhisper]

or, if you want to get really scientific:

In general, the permutation, nPr, is the number of subgroups of size r that can be taken from a set with n elements:

http://img.sparknotes.com/content/testprep/bookimgs/sat2/math1c/0045/npr=n!(nr!!.gif
For our example, we need to find 6P3:


http://img.sparknotes.com/content/testprep/bookimgs/sat2/math1c/0005/6p3=6!.gif

[bigmazey]

Definitely 336 tricasts for 8 runners. Excel says so :)

=permut(8,3)

Right I get the message and to think I use to be an assistant manager in a bookies.:headbange


or, if you want to get really scientific:

In general, the permutation, nPr, is the number of subgroups of size r that can be taken from a set with n elements:

http://img.sparknotes.com/content/testprep/bookimgs/sat2/math1c/0045/npr=n%21%28nr%21%21.gif
For our example, we need to find 6P3:


http://img.sparknotes.com/content/testprep/bookimgs/sat2/math1c/0005/6p3=6%21.gif


Blinded By Science!:blac4

[paul183195]

I could work out what that is but I can't be bothered.



:laugh :laugh :laugh what was your award for :laugh :laugh

[vegyjones]

:laugh :laugh :laugh what was your award for :laugh :laugh

:laugh

[mathare]

:laugh :laugh :laugh what was your award for :laugh :laugh:splapme

I guess I won't be defending my title next year then