Hi, That is a pretty old sheet, most of the websites have change and i have moved away from excel for form downloads, but if you click on the "One Drive" link in my signature you will find a file called "R2P.exe" this file is a ratings program i built that follows very similar lines as that sheet, there is an instruction Tab to help you understand how it works.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

HI Shaun,
and thanks for answering . One Drive" link in my signature .I have clicked on your name and no one drive comes up any chance of posting it in this link or how i get to your one drive.Thanks again for answering.I read you use to live in perth same here then you moved to Qld. I moved to Ecuador lol

https://1drv.ms/u/s!AvPTpSl9kb-d61uoYe8VXU99dbpO?e=fX4tjT

Copy above link to a wb browser should let you download it.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________

thanks Shaun will try it

HI Shaun thanks for sending info this is what came up when trying to run the file
unhandled exception in the script

Traceback (most recent call last):
File "R2P.py", line 1272, in
File "R2P.py", line 73, in timedate
File "R2P.py", line 82, in get_race_meetings
File "json\__init__.py", line 357, in loads
File "json\decoder.py", line 337, in decode
File "json\decoder.py", line 355, in raw_decode
json.decoder.JSONDecodeError: Expecting value: line 1 column 1 (char 0)

I put it in ai chat this was answer
he error message you provided indicates a JSONDecodeError, which means there is an issue with decoding JSON data. The error specifically states that it was expecting a value at line 1, column 1 (char 0). This typically occurs when the JSON data you are trying to parse is empty or invalid.

To fix this error, you can try the following steps:

Verify the JSON data: Check the source of the JSON data and ensure that it is valid. Make sure the JSON data is not empty and follows the correct JSON syntax.

Validate the JSON data: Use a JSON validator or an online JSON formatter to validate the structure and syntax of the JSON data. This can help identify any potential errors or inconsistencies.

Ensure the file or API is providing the expected JSON data: If you are reading the JSON data from a file or an API, double-check that the source is providing the correct data. Confirm that the data being retrieved is not empty or corrupted.

Handle exceptions: Surround the code block where you are parsing the JSON data with a try-except block to catch the JSONDecodeError. This way, you can handle the error gracefully and provide appropriate feedback or fallback behavior in case of an error.

Here's an example of how you can use a try-except block to handle the JSONDecodeError:

python
Copy code
try:
# Code to parse JSON data
# ...
except json.decoder.JSONDecodeError as e:
print("Error decoding JSON data:", e)
# Handle the error or provide fallback behavior
# ...
By following these steps and handling the JSONDecodeError appropriately, you can troubleshoot and fix the issue in your code.
I don't understand any of it but once again thanks for replying and sending info
Ron