| View previous topic :: View next topic |
| Author |
Message |
Cuthbert Collingwood 
Once was on fire, now all at sea
Joined: 08 Dec 2005
Location: The BBC (Brunswick Bowling Club)
|
| Post subject: GB Medal - can someone take over? |  |
|
Hi all,
I'm really busy at the moment so cant promise any timely release on the GB medal results. If anyone wants to do it that would be grand. Any takers with a bit of spare time?
Thanks,
CC
_________________
McRae for Governor-General! |
|
|
|
 |
qldmagpie67
Joined: 18 Dec 2008
|
| Post subject: Re: GB Medal - can someone take over? | |
|
| CC what's involved I may be able to help and knock it out in the next few days if someone has a round by round summary ? |
|
|
|
|
Donny 
Formerly known as MAGFAN8.
Joined: 04 Aug 2002
Location: Toonumbar NSW Australia
|
| Post subject: | |
|
That's up to the tallier, mate.
All the votes are there, in Gavin Brown Medal (under Match).
_________________
Donny.
It's a game. Enjoy it.  |
|
|
|
|
qldmagpie67
Joined: 18 Dec 2008
|
| Post subject: | |
|
Ok Donny I'll start tallying the votes round by round and post after let's say each 4 rounds
Time to break out the ole excel |
|
|
|
|
Donny
Formerly known as MAGFAN8.
Joined: 04 Aug 2002
Location: Toonumbar NSW Australia
|
| Post subject: | |
|
Sounds good.
Any probs, PM CC or me. 
_________________
Donny.
It's a game. Enjoy it. |
|
|
|
|
Pies4shaw 
pies4shaw
Joined: 08 Oct 2007
|
| Post subject: | |
|
| qldmagpie67 wrote: | Ok Donny I'll start tallying the votes round by round and post after let's say each 4 rounds
Time to break out the ole excel |
Best of luck.
The formula you need for each round is IF((SUM V1:V5=15),Sidebottom,Pendlebury), where V1 to V5 are, respectively, the votes cast by each NIckster for that round.
That should simplify the process a bit for you!  |
|
|
|
|
Mugwump
Joined: 28 Jul 2007
Location: Between London and Melbourne
|
| Post subject: | |
|
^. Should be fine if you title the resultant thread "Nicks scandal as Treloar denied GB medal in Excel fraud..... "
_________________
Two more flags before I die! |
|
|
|
|
qldmagpie67
Joined: 18 Dec 2008
|
| Post subject: | |
|
| Pies4shaw wrote: | | qldmagpie67 wrote: | Ok Donny I'll start tallying the votes round by round and post after let's say each 4 rounds
Time to break out the ole excel |
Best of luck.
The formula you need for each round is IF((SUM V1:V5=15),Sidebottom,Pendlebury), where V1 to V5 are, respectively, the votes cast by each NIckster for that round.
That should simplify the process a bit for you! |
P4S I thought it would be easier if I just disregarded any votes I didn't like and replaced them with my own thoughts !!
The actual formula would be (votes for Treloar X posters who actually watched game / Sidey turnovers X amount of swear words uttered by me during round 1) lol
Rounds 1-4 will be posted today and maybe 5-8 as well.
Betting will commence after first posting and suitable odds posted at the same time |
|
|
|
|
|
The Rules
FAQ
Usergroups
Calendar
Search
Log in
Register
