Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > Horse Race Betting Systems
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 24th June 2005, 05:32 PM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default Excell Help Please

Can one of you expert excell gurus please help me with the following.

I am trying to put the retirement staking plan on excell. I have as a primary target $600 (divsor 6 thus min bet $100) I have this in col C. In colD I have my losses. This is from col M which is the profit and loss col. Thus my formula in col D is =-M4. ColE is the total of colC +ColD formula =C5+C5. At present this offsets all profit and losses in colM into my total target instead of the desired stop when previous losses are recouped.

My formula for col D should in fact be =-M4 if <0 use 0. How I can I effect this I've played with it for hours and I concede defeat The computor has been saved two inches from the floor several times.

I thank you in advance
Regards Beton
Reply With Quote
  #2  
Old 24th June 2005, 06:13 PM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default

OOps just had another look at this. It is col E that this should occur thus it should have the formula =C4+D4 if <600 use 600 Again how can I achieve this?

Thanks again Beton
Reply With Quote
  #3  
Old 24th June 2005, 06:54 PM
jose jose is offline
Member
 
Join Date: Jan 1970
Location: brisbane
Posts: 419
Default

Beton, I don't know if it will help but in an old post there is a copy of this staking plan, which is on an Excel spreadsheet.
I shall go back thru for you and see if I can find it if you like.
__________________
Jose'.
Reply With Quote
  #4  
Old 24th June 2005, 07:42 PM
Zlotti Zlotti is offline
Suspended. Invalid e-mail address.
 
Join Date: Jan 1970
Posts: 93
Post

Quote:
Originally Posted by beton
Can one of you expert excell gurus please help me with the following.

I am trying to put the retirement staking plan on excell. I have as a primary target $600 (divsor 6 thus min bet $100) I have this in col C. In colD I have my losses. This is from col M which is the profit and loss col. Thus my formula in col D is =-M4. ColE is the total of colC +ColD formula =C5+C5. At present this offsets all profit and losses in colM into my total target instead of the desired stop when previous losses are recouped.

My formula for col D should in fact be =-M4 if <0 use 0. How I can I effect this I've played with it for hours and I concede defeat The computor has been saved two inches from the floor several times.

I thank you in advance
Regards Beton
I have the plan you are looking for but I can't uplaod to this part of the forum... no idea why! Email me 'retireme at mailup dot net' and I will forward.

If your system produces the odd long run of outs then maybe another type of staking plan is better. As I said drop me a line and I will send a few different ones for you to peruse.

Regards

Zlotti

Last edited by Zlotti : 24th June 2005 at 07:49 PM. Reason: Update
Reply With Quote
  #5  
Old 24th June 2005, 07:46 PM
Wunfluova Wunfluova is offline
Member
 
Join Date: Jun 2005
Posts: 84
Default

Hi Beton,

Put this formula in cell E4
=IF(C4+D4<600,600,C4+D4)

Regards,
Wun
Reply With Quote
  #6  
Old 24th June 2005, 09:51 PM
beton beton is offline
Member
 
Join Date: Jan 1970
Posts: 589
Default

Thanks that seems to do the trick I'll start loading my data tommorrow
regards Beton
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



All times are GMT +10. The time now is 07:45 AM.


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655