Excel spreadsheet

[christine]

Hi all, I know I'm being a pain & I wish I was 1/10th as knowledgeable about Excel as many of you are! However I have another query re the spreadsheets. This time I want to be able to place my lay bet at an exact time before the off, say 30 seconds & if it isn't within the odds range at that precise moment, I want to bin the bet. At the moment, the bet will stay open after the 30 seconds mark up until the off. I want to avoid horses whose odds are dropping after my cut-off point. Is there a formula that could do this for me? Many thanks as always.

[osknows]

Hi Christine,

In the spreadsheets you already have change cell AJ5

from
=IF(AND(AK5<=AL5,E2="Not In Play",F2<>"Suspended"),"Y","N")

to

=IF(AND(AK5=AL5,E2="Not In Play",F2<>"Suspended"),"Y","N")

Essentially, the bet will only fire when AK5 equals AL5 and not when AK5 is less than or equal AL5 and other conditions are met

[osknows]

ps your not being a pain

[2020vision]

hi Christine

assuming you are still talking about this post, still second fav btw:
http://www.gruss-software.co.uk/forum/v ... php?t=4899

take the following trigger as supplied before:
=IF(AND($T$1<$T$2,AA5=2,H5<6,$F$2="",COUNTBLANK(T$5:T$50)=46,$E$2="Not in Play"),"LAY","")

and change to:
=IF(AND($T$1>25,$T$1<30,AA5=2,H5<6,$F$2="",COUNTBLANK(T$5:T$50)=46,$E$2="Not in Play"),"LAY","")

Hopefully this will work for you? Notice $T$1 was the timer cell, change >25 and <30
to any time window you want but make sure it's logical? The above should
allow just 5 seconds when the bet will be fired (I think), be careful.

Ttfn - Michael

P.S. Once again if anyone spots an error please say asap - thanks.

[osknows]

Hi Michael.. don't you love a good cross post Hope all is well with you.

Christine - like anything with Excel there's a million ways to do most things so both answers are correct...

[christine]

Wow guys that was quick (& thanks Os for the reassurance!). I'm just wondering if you know how small the window can be for the bet to be placed eg 25-30 seconds is a 5 second window, do you reckon I could make the window smaller, say 25-27 seconds (2 second gap), or might that miss the bet altogether even if the odds are ok? Thanks again though, as that formula is definitely what I was looking for!

[christine]

Hmm, now I've read Os' last post I think I may need to use that formula from Os as that will trigger exactly at a precise point rather than within a window of time, is that right? I should really concentrate more when people are trying to help me, but it is getting late after a long day (that's my excuse anyway!).

[osknows]

As long as your refresh rate is under 1 second you should hit it.

If you do want to introduce windows think of
AK5 = seconds before start countdown
AL5 = seconds before off trigger time

to introduce a window you could use somethinglike

AJ5 =IF(AND(AK5<=AL5,AK5>=AL5-2,E2="Not In Play",F2<>"Suspended"),"Y","N")

would give a 2 second window. Eg if you set AL to 30 secs bet would only fire between 30 and 28 seconds before off

[christine]

That's excellent Os, I'm going to try that one tomorrow when betting commences.