Incorrect Refresh Rate When Using Excel ?

[dogform]

Hi,

I have an excel workbook linked to Gruss but the refresh rate is not changing in accordance with the formula I am using in excel to change the refresh closer to the off time.

In cell Q2 which controls the refresh rate I have the formula:

=IF(S1>170,1,0.1)

Where S1 contains the long formula that works out the countdown to the off time in seconds.

The logic is to keep the refresh rate at 1 second until 2mins 50seconds before the off time then change the refresh rate to 0.1 seconds when there is less that 170 seconds to the off.

The refresh is just sitting stuck on 1 second in Gruss even though the value from excel is showing 0.1 seconds for the refresh rate. In Gruss I notice there is an "Auto" tick box nect to the refresh rate, what is this for, I have it ticked?

Any help most appreciated.

Rgds
dog

[MarkRussell]

Hi,

Unticking the "Auto" box will stop Betting Assistant from refreshing all together so you should keep it ticked.
Its for people who want to keep BA open but don't want it using any bandwidth for a period of time.

I believe your problem is because you have specified 0.1 for the refresh which is not a valid amount.
The smallest amount you can use is 0.2
Amend your formula and it should be ok.

Regards,
Mark

[dogform]

Mark,

Thx for the quick reply.

Yes, it works OK now with 0.2 as the refresh rate. On a point of information what incremental scale is used between 1 second and 0.2 seconds, is it in 0.2 second segments?


Rgds
dog

[MarkRussell]

Mark,

Thx for the quick reply.

Yes, it works OK now with 0.2 as the refresh rate. On a point of information what incremental scale is used between 1 second and 0.2 seconds, is it in 0.2 second segments?


Rgds
dog

Increments of 0.1

Regards,
Mark