 |
|
|
 |
|
|
|
|
|
#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
|
|
#7
23rd January 2006, 02:31 PM
|
|||
|
|||
|
Quote:
Gday mad just insert another row and format accordingly, that will do the same job..
|
|
#8
23rd January 2006, 03:53 PM
|
|||
|
|||
|
I tried, but it doesn't seem to format correctly.
Mad Gambler
|
|
#9
23rd January 2006, 04:25 PM
|
|||
|
|||
|
Quote:
|
|
#10
23rd January 2006, 04:35 PM
|
|||
|
|||
Quote:
Am i the only one on the forum without a split personality?  Are you out there Whiteycat? Last edited by DR RON : 23rd January 2006 at 04:38 PM.
|
 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
