Fix / add features - office scripts to atera automation project
Budget: $30 – $250 AUD
Project Description: Fix office script
I am looking for someone to fix my office script that is currently experiencing error messages. The script is written in typescript. The script links with the atera API. The script is in relation to a excel spreadsheet. The project will include ensuring the script is functioning correctly.
Skills and Experience:
- Expertise in typescript and office scripting
- Strong understanding of error handling and debugging
- Familiarity with office applications and their scripting capabilities
- Experience with restful API'S and in particular Atera
Timeline:
- The project needs to be completed ASAP.
Script requirements:
- Currently talk to a CORS proxy on cloudflare.
- A spreadsheet will be filled with customer names and the hours included in there atera contact
- Only clients with the block hours contract type should come over to the sheet.
- The other columns a titled each month respectively
- The script needs to calculate how many hours each client has accumalated each month and return the number amount
- The script needs to be configured to run automatically each month at 1159pm EAST on the 15th
- The script will look for last months tickets eg. feb will be filled with hours used from jan 15 to feb 15
- The script will ensure customers are not duplicated
- Script needs to add any new clients each month
- The customer list needs to be alphabetical order
- Each year the script needs to move between yearly sheets eg. 2023, 2024
- The script needs to work with Atera's pagination feature
- CORS proxy script may need some work as well
All scripts can be provided and access to the spreadsheet on sharepoint can be provided
I am looking for someone to fix my office script that is currently experiencing error messages. The script is written in typescript. The script links with the atera API. The script is in relation to a excel spreadsheet. The project will include ensuring the script is functioning correctly.
Skills and Experience:
- Expertise in typescript and office scripting
- Strong understanding of error handling and debugging
- Familiarity with office applications and their scripting capabilities
- Experience with restful API'S and in particular Atera
Timeline:
- The project needs to be completed ASAP.
Script requirements:
- Currently talk to a CORS proxy on cloudflare.
- A spreadsheet will be filled with customer names and the hours included in there atera contact
- Only clients with the block hours contract type should come over to the sheet.
- The other columns a titled each month respectively
- The script needs to calculate how many hours each client has accumalated each month and return the number amount
- The script needs to be configured to run automatically each month at 1159pm EAST on the 15th
- The script will look for last months tickets eg. feb will be filled with hours used from jan 15 to feb 15
- The script will ensure customers are not duplicated
- Script needs to add any new clients each month
- The customer list needs to be alphabetical order
- Each year the script needs to move between yearly sheets eg. 2023, 2024
- The script needs to work with Atera's pagination feature
- CORS proxy script may need some work as well
All scripts can be provided and access to the spreadsheet on sharepoint can be provided