• 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
  • Hi Guest Just in case you were not aware I wanted to highlight that you can now get a free 7 day trial of Horseracebase here.
    We have a lot of members who are existing users of Horseracebase so help is always available if needed, as well as dedicated section of the fourm here.
    Best Wishes
    AR

VRR Lite Puntology

Stumbled across this freebie from:
Code:
www.puntology.com

Just by sending your E-mail address, you can download their excel spreadsheet to produce a rating. The video explains how you copy and paste onto the spreadsheet.



Not sure if any good, just thought I'd pass it on. :party:
 

Attachments

  • VRRLite.xlsx
    746.4 KB · Views: 51
I downloaded the excel spreadsheet and was interested in the formula used, I see it was password protected
so I just cracked the spreadsheet and took a look :D
 

nedloh

Mare
has it to do with the average of the 3 ratings and each horses average taken away to give the rating
if it has, its been done to death on other forums and it doesn't work
 
nedloh said:
has it to do with the average of the 3 ratings and each horses average taken away to give the rating
if it has, its been done to death on other forums and it doesn't work

You are correct :cool:

Formula used:

Col L - =AVERAGE(H:H)
Col M - =AVERAGE(I:I)
Col N - =AVERAGE(J:J)
Col O - =IF(H11="","",H11-L$10)
Col P - =IF(I11="","",I11-M$10)
Col Q - =IF(J11="","",J11-N$10)
Col R- =IF(Q11="","",SUM(O11:Q11))
Col s - =IF(R11="","",RANK(R11,R:R))

Password protecting an excel sheet to somebody like me is like the formula
used here, as must use as rocking horse shit :D
 

pawras

Gelding
I downloaded the excel spreadsheet and was interested in the formula used, I see it was password protected
so I just cracked the spreadsheet and took a look :D
is it saved as an old version of excel? cos the recent versions have much stronger encryption than they used to i.e could hack the old ones with a simple brute force attack
 
is it saved as an old version of excel?
It's saved as a .xlsx file, brute-forcing would only work on websites, the old methods do not work now, back in the day I used programs like "John The Ripper" etc, I grew out of hacking back in the '90s when a member of the ex Deny forum out of Germany.

Mike.
 
Last edited:

pawras

Gelding
It's saved as a .xlsx file, brute-forcing would only work on websites, the old methods do not work now, back in the day I used programs like "John The Ripper" etc, I grew out of hacking back in the '90s when a member of the ex Deny forum out of Germany.

Mike.
Yeah but depends what version of excel it was saved and encrypted with i.e

1635777193044.png

Are you saying you can crack 256-bit key AES ?
 
Are you saying you can crack 256-bit key AES ?
It was not the key I cracked it was the Excel sheet protection password, all I did was to remove the sheet password so I could unhide the columns to see what formulas they used as requested.
If you look at the original Excel sheet from 2013 several of the columns were hidden, you needed a password to unhide the columns, I just removed the protection.
There's been many a manager that has password-protected an excel sheet and forgotten the password...

Mike.
 
Last edited:

pawras

Gelding
so in other words who did the sheet hadn't really thought properly about how to stop people hacking it

gonna say if you could get past 256-bit key AES......
 

pawras

Gelding
When I've done dashboard stuff for others in excel I've been inclined to save as xlsb regardless so people can't just 'tweak' internal xml files to get rid of sheet protection plus I put most things in vba and even obfuscate it before I lock it for viewing with a decent password. So even if they start hacking the internal vbproject.bin file with a hex editor and manage to succeed it shouldn't be very readable.
 
Mike, TheBluesBrother TheBluesBrother, big thanks for cracking the protection on the spreadsheet and attaching it. (y)

I had a go watching a YT video (as you suggested). I did manage, after a few attempts to "hack" the protection.

Changed the file extension to .zip, extracted and located worksheet. Copied onto notepad and removed the protected coding (carefully). Copied it into the .zip file and changed the .zip back to .xlsx. That's the gist anyway.

Tidied up the sheet for user entry. Attached for anyone to use.

The reason I revisited this idea was not to use the OR/TS/RPR ratings, but 3 other ratings instead. in the last 10 years there's so many ratings out there, it's just a question of combining the right ones... :headbang:

Shout out to Michael Wilding for the original concept and spreadsheet. He's gone onto bigger and greater things, so I'm sure he won't mind us hacking an old resource....:cool:
 

Attachments

  • UKBettingVRR.xlsx
    13.5 KB · Views: 18
Last edited:
Top