Using EXCEL

[the big bang]

wasn't sure where to post this, as it has several categories (AFL, gambling, IT), so mods, feel free to move to where you deem fit. cheers.

basically, last year with two of my mates, i ran a "punting comp" on the AFL.

we had $50 to spend on any AFL bets we wanted to, from head to head, to multi's and first goal kickers, whatever you wanted. we kept track, and whoever made the most proifit at the end, won the comp.

i'm looking at doing the same thing, but bigger and better, and involving a heap more people. so i was just wondering if someone could point me in the right direction on if EXCEL would be my best option? if not, what would be? if so, is it hard to figure out what i would need it for?

[mickey]

We did the same thing at work, on a smaller scale though... Excel was perfect i found..

How much detail u looking to have in there?

[the big bang]

hard to say how many participants o'll have, but for now we'll work on 20.

the way i ran it last season, the other 2 lads sent me a message on facebook (easiest way for all 3 of us to be able to see each others bets and chat/banter between ourselves).

for example, this is how the message on FB would look on the friday night......

LEADERBOARD AFTER Rd 3.....

Big Bang +$115.50
Steve +$43.90
Mark -$11.10

round 4

Big Bang's bets.

$10 on collingwood win over 15pts @ $1.45 = $14.50
$20 on multi, coll/geel/dogs/freo wins @ $2.95 = $59.00
$20 on LeCras first goal kicker @ $8.00 = $160

steve's bets

$25 on crows under 39.5pts @ $3.40 = $85
$25 on geelong v hawthorn qtr by qtr, haw/geel/geel/geel @ $11.00 = $275

mark's bets

$10 on andrew swallow most disposals @ $14 = $140
$10 on jack riewoldt most goals of the round @ $6 = $60
$30 on multi pies over 15/geel/ freo over 39.5/ @ $5.05 = $151.50

then, at the completion of round 4, i'd go through all our bets and figure out the leaderboard ready to head into the next week. with 3 of us, i was more than happy to just figure it all out manually, and update it all myself. but with 20 peoople, would love to be able to figure out something to make it a lil bit easier. i understand i'll still have to be switched on to weather or not the bets were successful, but any help/suggestions would be appreciated!

[mickey]

Here is a screenshot of part of my excel file..

we had 5 people in the group, 1 person bet each week.

[mickey]

And can turn the data from sheet 1 into a graph very easily

[mighty_tiger_79]

beautiful

going in a syndicate this year so that looks the easy way of keeping track of it all

[mickey]

Using excel you can easily keep track of bank balances etc..

Just set the formulas at the start so all you have to do is enter the numbers..

[the big bang]

looks good mate. cheers.

the only thing is, i can only vaguely remember how to do the formula setup thingy from school. is this hard to figure out?

[smac]

Get rid of Brad, he's a bad gambler.

And there are some syndicate spreadsheets available online that you may be able to tweak.

[mickey]

Get rid of Brad, he's a bad gambler.

LOL, he was the only non collector all year.. got a bit unlucky though.. R1 port up by 50 odd points and couldnt cover the 15.5
and then a couple of multis to 'make the big money' but dont make any when u miss by a few points..lol

[Bully]

i didnt realise how good excel was until about 5 years ago. Its brilliant for info to be stored and presentations.

Theres alot of people out there that dont know anything about this program but believe me its very good