-
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
UK All Weather Speed Ratings Template
- Thread starter Outlander
- Start date
Hi
Cashelman the DP no weight spreadsheet I posted as
David Punshon had request an amendment to is the MAX OR was zero it would return zero, those races you mention were all races where no horses had ORs so that will be the reason, use the template I posted before this the original no weight template and there will not be such problems
Cashelman the DP no weight spreadsheet I posted as
David Punshon had request an amendment to is the MAX OR was zero it would return zero, those races you mention were all races where no horses had ORs so that will be the reason, use the template I posted before this the original no weight template and there will not be such problems
That is how it is with so many calculations
I have a different sheet for each course and link them to a database
This can be useful because you can spot trends in each course distance.
The sheets I use have even more calculations and just 3 1/2 years of data for Wolverhampton has 17000 rows by itself.
If you didn’t want to have one for each course, you could split into AW and Turf
But there is no avoiding it excel can only do what it can do, that’s why originally I had the sheet set for 20000 lines but I made it do 200000 for you , bit too much for one sheet.
How many months data do you have in the sheet now?
im surprised it’s creaking that much, I reckon if we had kept the formulas at 20000 it wouldn’t be slow at all with 10000 rows, I reckon this is the downside of the 200000 contingency.
I remember I originally tried 1 million and it was slow
That’s ridiculous lots of my sheets have more than 10000 rows and way more complicated than the template and even the worst one I had wouldn’t take more than a few minutes, defeats the whole purpose of the sheet if it takes that long.
CashelmanI tested it today I downloaded the template straight from the thread, copied nearly 11000 rows of data from the last 3 years from Newcastle into the template, it took 11mins 11 seconds to calculate ratings for these initial 11000 horses.
Then I copied a whole weeks results from HRB into the sheet another 3200 rows of form and it took 6mins 22 seconds to calculate the whole weeks ratings.
Bit slower than I anticipated but I think thi should is dues to having contingency for 200000 rows of form in the sheet.
Nowhere near 4 hours so it must be you machine.
To be honest if it's taking 4 hours it's not worth it, could do it all quicker without the template.
Last edited: