Google Sheets Improvements

I am looking for a freelancer who can help me improve my Google Sheets by automating processes. The ideal candidate should have intermediate level skills in automation processes in Google Sheets. The improvements need to be completed within a month.

This project has 2 parts:

1. Conditional colour formatting which queries another sheet
2. Sports draw automation and generation

Skills and Experience:

- Intermediate level skills in automation processes in Google Sheets
- Experience in automating processes in Google Sheets
- Ability to meet deadlines

Please see the requirements document for more information.

*IMPORTANT this sheet already has quite a lot of script. The improvements need to be tested thoroughly.