Excel Help
 

I need a spreadsheet that records the horese i bet the amount of the bet the return the profit and a running balance.

Can someone help?

Mad Gambler

Gday Mad

Try the attached it may help you .. if no no harm done.. some others may be able to help you more but this works fine for me...

In column D be sure there is a number one in each row... I am sorry I don't know how to do it otherwise... and just enter the info as you go along... Hope it helps

I put in the data from the start of the year. There have been 9 bets for 4 winners. It's telling there has been 9 races for 9 winners which is incorrect there should be 9 races and 4 winners for a strike rate of 44.4%. All the other information is correct.


Mad Gambler

U Have been putting the number 1 in column D? Or you have a divvie in each divvie column? coz it really should work.. see attached.. I ahve added a couple of fictional races to show you how it works...

It works fine. Thanks.


Mad Gambler

One thought. How about changing the number of races to the number of selections as I sometime bet 2 or 3 horses in a rave if the prices permit.

Mad Gambler

Gday mad

just insert another row and format accordingly, that will do the same job..

I tried, but it doesn't seem to format correctly.


Mad Gambler

I'm confused, are you a gambler or a punter, are you mad or not?

Am i the only one on the forum without a split personality? :)
Are you out there Whiteycat?

MEOOOOW.

I'm sorry. My nephew (who is fred the punter) was logged on and before he could log out the computer crashed. It was down for an hour.

I had an other go at formating the column, but it truns out all wrong. I must be doing it all wrong can sonmeone help with the formating og the extra column.

Mad Gambler

With tthe regards to the speadsheet I need to add a couple of colums for the place divie and the place strike rate.


mad gambler

Mad Gambler,

I have been hanging by my b++++ I mean tail waiting for your reply and my b++++ I mean tail are now 2 foot long.

MeeeeeeeoooooooooooooooooooooooooooooooW

With a sickening CRASH, the penny drops, hee hee, I might be a bit trusting and slow, but you know what EVENTUALLY NOTHING gets past me!!