• Hi Guest, The forum will be moving hosts on 26 July and as such will be closed from Midday until the move has completed.
    As we will be with new hosts it may take a while before DNS get updated so it could take while before you can get back on the forum.
    I think it will take at least 4 hours but could easily be 48!
    Ark Royal
  • There seems to be a problem with some alerts not being emailed to members. I have told the hosts and they are investigating.
  • Hi Guest Just in case you were not aware I wanted to highlight that you can now get a 20% discount on Inform Racing.
    Simply enter the coupon code ukbettingform when subscribing here.
    We have a lot of members who are existing users of Inform Racing so help is always available if needed.
    Best Wishes
    AR
  • Sorry for the ongoing issues that you may have been experiencing whilst using the forum lately

    It really is frustrating when the forum slows down or Server Error 500 pops up.

    Apparently the hosts acknowledge there is a problem.
    Thank you for using our services and sorry for the experienced delay!
    Unfortunately, these errors are due to a higher server load. Our senior department knows about the issue and they are working towards a permanent resolution of the issue, however, I'd advise you to consider using our new cPanel cloud solutions: https://www.tsohost.com/web-hosting


    I will have to investigate what the differences are with what We have know compared to the alternative service they want us to migrate to.
    Keep safe.
    AR

Win/Place test

runnerjp

Colt
Thanks for your comments and I find this quite extraordinary as I've just checked my spreadsheet again and using the Epsilon auto sum mode (Open Office Calc), it still comes up with the total as being £322.34 but you are quite right that the total, checked by hand on a calculator, is £173.96. Totally weird and worrying as to why it has incorrectly added up the column and made this error.

I have just opened a blank spreadsheet and copied the Win P/L figures into it applied the Epsilon and id comes to £322.24 again....however the copy column had two odd entries that were not on the first sheet as high lighted below which explains the difference of £148.38! I have no idea where they came from...a real mystery. Any my thanks for pointing it out and my apologies to all for not noticing it myself...a Stupid Boy Pike moment!! I'm not sure about today's selections as I am about to go out for several hours but there may be some late afternoon bets when I get back!



19.2​
19.02
129.36
-20​
8.24​
-20​
-20​
-20​
28.62​
26.66​
-20​
20.38​
-20​
84.28​
-20​
53.9​
-20​
-20​
46.06​
-20​
-20​
57.23​
49.39​
322.34​
you might have had hidden columns which would still be counted in the equation. when copying to a new spreadsheet those rows would no longer be hidden
 
Thanks for the explanation as that sounds exactly what must have happened. Not sure what I should do to avoid it in the future. What I have done is I've rewritten both thread spreadsheets from scratch, deleted the old ones and hopefully that should cause no more problems.
 

runnerjp

Colt
You can use the SUBTOTAL function.
SUBTOTAL(3;A1:A100) counts only the visible rows in A1:A100.

the first number will give you a different means to calculate.
functionFunction
1​
AVERAGE
2​
COUNT
3​
COUNTA
4​
MAX
5​
MIN
6​
PRODUCT
7​
STDEV
8​
STDEVP
9​
SUM
10​
VAR
11​
VARP
 
Top