|
Title: now heres the REAL question Post by: BigTomatoes on June 03, 2006, 07:19:48 PM is there a formula which gives all the combinations ? Title: Re: now heres the REAL question Post by: Jim-D on June 03, 2006, 07:21:38 PM To what?
Title: Re: now heres the REAL question Post by: BigTomatoes on June 03, 2006, 07:24:36 PM 8 matches = 6561 outcomes is there a formula to work out all the combinations Title: Re: now heres the REAL question Post by: gatso on June 03, 2006, 07:59:15 PM This is easy in spreadsheet form
You need one with 8 columns each of 6561 rows (or 8 rows of 6561 columns if you prefer) with H=home, A=away and D=draw column 1 reading sown should be H,A,D,H,A,D,H,A,D etc all the way to the bottom column 2 HHH,AAA,DDD,HHH,AAA,DDD,HHH etc column 3 HHHHHHHHH,AAAAAAAAA,DDDDDDDDD,HHHHHHHHH etc. (9 of each letter) column 4 same as before but with 27 of each letter column 5 same again but 81 of each letter column 6 243 of each letter column 7 729 of each letter column 8 2187 of each letter shouldn't take too long to set up in excel if your familiar with clicking and dragging on columns Title: Re: now heres the REAL question Post by: BigTomatoes on June 03, 2006, 09:17:13 PM CHEERS MATEY
|