 |
|
|
 |
|
|
|
|
|
|
|
#1
21st January 2006, 04:58 PM
|
|||
|
|||
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 
|
|
#2
21st January 2006, 05:08 PM
|
|||
|
|||
|
Quote:
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
|
|
#3
21st January 2006, 07:00 PM
|
|||
|
|||
|
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
|
|
#4
21st January 2006, 07:07 PM
|
|||
|
|||
|
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...
|
|
#5
21st January 2006, 07:20 PM
|
|||
|
|||
|
It works fine. Thanks.
Mad Gambler
|
|
#6
22nd January 2006, 06:02 PM
|
|||
|
|||
|
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
|
 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
