C
Charles Reid
Hello All,
a.. Could someone possibly help me out with this issue? I have created a
bowling brackets program and everything is working fine with the exception
of the PAYOUT sheet. I have a max total of at least 20 brackets and any one
can be in as many brackets he or she wants.
b.. The payout per bracket is for the top two bowlers in each bracket with
the winner of the bracket getting $15.00 and second place get $6.00.
c.. So as you can imagine, if a bowler gets into all 20 brackets and gets
first place in all of them, then he or she could possible win a total of
$300.00 or if a person takes second place in all of the brackets, the he or
she can win a total of $120.00.
With the listed table below, how can I generate a list to give the total
winning for each bowler if the bowler appears more than once on the list?
Winners
$$$
Bugs Bunny
15.00
Brkt1
Lana Bunny
15.00
Brkt2
Daffy Duck
15.00
Brkt3
Droopy Dog
15.00
Brkt4
Marvin Martian
15.00
Brkt5
Scooby Doo
15.00
Brkt6
Tom Mouse
15.00
Brkt7
Jerry Cat
15.00
Brkt8
Spike DaDog
15.00
Brkt9
Hulk Hogan
15.00
Brkt10
The Undertaker
15.00
Brkt11
John Cena
15.00
Brkt12
Marvin Martian
15.00
Brkt13
Droopy Dog
15.00
Brkt14
Droopy Dog
15.00
Brkt15
Bugs Bunny
15.00
Brkt16
Space Ghost
15.00
Brkt17
Space Ghost
6.00
Brkt1
Space Ghost
6.00
Brkt2
Jerry Cat
6.00
Brkt3
Scooby Doo
6.00
Brkt4
Daffy Duck
6.00
Brkt5
Daffy Duck
6.00
Brkt6
John Cena
6.00
Brkt7
Hulk Hogan
6.00
Brkt8
Bugs Bunny
6.00
Brkt9
Bugs Bunny
6.00
Brkt10
Tom Mouse
6.00
Brkt11
Tom Mouse
6.00
Brkt12
The Undertaker
6.00
Brkt13
Marvin Martian
6.00
Brkt14
Speed Racer
6.00
Brkt15
Speed Racer
6.00
Brkt16
PokeMon
6.00
Brkt17
Hence the following:
Bugs Bunny
42
Lana Bunny
15
Daffy Duck
27
Droopy Dog
45
Marvin Martian
36
And etc.
Any and all help in this matter is greatly appreciated
a.. Could someone possibly help me out with this issue? I have created a
bowling brackets program and everything is working fine with the exception
of the PAYOUT sheet. I have a max total of at least 20 brackets and any one
can be in as many brackets he or she wants.
b.. The payout per bracket is for the top two bowlers in each bracket with
the winner of the bracket getting $15.00 and second place get $6.00.
c.. So as you can imagine, if a bowler gets into all 20 brackets and gets
first place in all of them, then he or she could possible win a total of
$300.00 or if a person takes second place in all of the brackets, the he or
she can win a total of $120.00.
With the listed table below, how can I generate a list to give the total
winning for each bowler if the bowler appears more than once on the list?
Winners
$$$
Bugs Bunny
15.00
Brkt1
Lana Bunny
15.00
Brkt2
Daffy Duck
15.00
Brkt3
Droopy Dog
15.00
Brkt4
Marvin Martian
15.00
Brkt5
Scooby Doo
15.00
Brkt6
Tom Mouse
15.00
Brkt7
Jerry Cat
15.00
Brkt8
Spike DaDog
15.00
Brkt9
Hulk Hogan
15.00
Brkt10
The Undertaker
15.00
Brkt11
John Cena
15.00
Brkt12
Marvin Martian
15.00
Brkt13
Droopy Dog
15.00
Brkt14
Droopy Dog
15.00
Brkt15
Bugs Bunny
15.00
Brkt16
Space Ghost
15.00
Brkt17
Space Ghost
6.00
Brkt1
Space Ghost
6.00
Brkt2
Jerry Cat
6.00
Brkt3
Scooby Doo
6.00
Brkt4
Daffy Duck
6.00
Brkt5
Daffy Duck
6.00
Brkt6
John Cena
6.00
Brkt7
Hulk Hogan
6.00
Brkt8
Bugs Bunny
6.00
Brkt9
Bugs Bunny
6.00
Brkt10
Tom Mouse
6.00
Brkt11
Tom Mouse
6.00
Brkt12
The Undertaker
6.00
Brkt13
Marvin Martian
6.00
Brkt14
Speed Racer
6.00
Brkt15
Speed Racer
6.00
Brkt16
PokeMon
6.00
Brkt17
Hence the following:
Bugs Bunny
42
Lana Bunny
15
Daffy Duck
27
Droopy Dog
45
Marvin Martian
36
And etc.
Any and all help in this matter is greatly appreciated