World Cup Bar Pool

Ivanhoe · May 20th, 2002, 01:45 PM

Am trying to produce a worksheet for a World Cup bar pool.
The Worksheet should consist of 3 Pages. The first (Tables) consisting of the eight tables of groups showing the standings as the tournament progresses. My 2nd page (Schedule) has the schedule of the whole tournament and will include the results of the games as they happen. And the last page is that of the table of participants in the pool hopefully showing the current position of the participants as the results are entered.
I am trying to update both the Tables and Pool Standings from the Schedule sheet automatically.
The pool will be based on the goals 'for' column and the winner of the pool will be he/she who selects the 8 eight teams that produce the most goals over the tournament. Initially they will select 4 teams (1 per any group) then draw another 4 teams from the 'hat' from the other 4 groups. These entries will be entered in the Pool Standings sheet.
Is there anyway that when the score is entered on the Schedule sheet both the Tables and Pool Standings can automatically be updated. If so please mention a few hints but if you think it might be beyond an enthusiastic, but keen, amateur at this (Excel)I will find another way to do it but probably much more labout intensive than I had in mind. Am not too clever at Arrays and VB Subs but willing to learn if it's possible before the start on May 31.
Any help or advice would be appreciated.
Bill Findlater, Calgary, Canada

Brian from Maui · May 20th, 2002, 02:06 PM

I'm not a soccer fan, but.....these guys are

http://www.mrexcel.com/board/viewtop...c=8028&forum=2

Jack in the UK · May 20th, 2002, 03:42 PM

Hi guys

before ANYONE asks me NO im not sending billions of these, i am helping develope a betting pool world cup spreadsheets, ill make it avalible ASAP in time to play if i can, no promises, email me and ill forward what i have when i have it and im shore my best mate chris d will be in the frame here

DO NOT feed this feed with requests as i will ignor them, i will when i ready send and this will be via email to email requests, i let you know when im ready, i have much to do.

if anyone has web space i can use so guys can download this please advise me and it will be for all at will.

no request on this feed PLEASE, i will ignor the, email only

If i fail in my prodution im sorry

If Bill or Juan read this please @lock@ this feed NOW

thank you in advance,

May 20th, 2002, 03:42 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi guys before ANYONE asks me NO im not sending billions of these, i am helping develope a betting pool world cup spreadsheets, ill make it avalible ASAP in time to play if i can, no promises, email me and ill forward what i have when i have it and im shore my best mate chris d will be in the frame here DO NOT feed this feed with requests as i will ignor them, i will when i ready send and this will be via email to email requests, i let you know when im ready, i have much to do. if anyone has web space i can use so guys can download this please advise me and it will be for all at will. no request on this feed PLEASE, i will ignor the, email only If i fail in my prodution im sorry If Bill or Juan read this please @lock@ this feed NOW thank you in advance, __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 20th, 2002, 01:45 PM	#1
Ivanhoe New Member Join Date: May 2002 Location: Calgary, Canada Posts: 3	Am trying to produce a worksheet for a World Cup bar pool. The Worksheet should consist of 3 Pages. The first (Tables) consisting of the eight tables of groups showing the standings as the tournament progresses. My 2nd page (Schedule) has the schedule of the whole tournament and will include the results of the games as they happen. And the last page is that of the table of participants in the pool hopefully showing the current position of the participants as the results are entered. I am trying to update both the Tables and Pool Standings from the Schedule sheet automatically. The pool will be based on the goals 'for' column and the winner of the pool will be he/she who selects the 8 eight teams that produce the most goals over the tournament. Initially they will select 4 teams (1 per any group) then draw another 4 teams from the 'hat' from the other 4 groups. These entries will be entered in the Pool Standings sheet. Is there anyway that when the score is entered on the Schedule sheet both the Tables and Pool Standings can automatically be updated. If so please mention a few hints but if you think it might be beyond an enthusiastic, but keen, amateur at this (Excel)I will find another way to do it but probably much more labout intensive than I had in mind. Am not too clever at Arrays and VB Subs but willing to learn if it's possible before the start on May 31. Any help or advice would be appreciated. Bill Findlater, Calgary, Canada

May 20th, 2002, 02:06 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	I'm not a soccer fan, but.....these guys are http://www.mrexcel.com/board/viewtop...c=8028&forum=2