Google Sheets Automated Set List Creator
Budget: $30 – $250 AUD
Automated Set List Generator in Google Sheets
Project overview
I have a Spreadsheet that contains set list information for songs, and I need it to generate a new set list every time I click a button. The generated set list must adhere to specific rules and be visually formatted (e.g., multicolored) and ready for printing.
Rules for Set List Creation:
Alternate songs as much as possible between three performers: Wilton, Claudia, and Duo.
Always start a set with a high-energy song.
Sets must be exactly 11 songs long.
Never have more than 3 high-energy songs in a row.
The set list should randomize the songs each time but still follow these rules.
Deliverables:
A functional Google Sheet with a "Generate Set List" button.
A script (using Google Apps Script) that:
Randomly selects songs based on the rules above.
Outputs the selected set list to a specific sheet within the spreadsheet.
Applies formatting as per example of a manually completed setlist that I will attach for reference.
Additional information
- The solution must be user-friendly, not requiring technical skills for operation.
- Documentation should be provided explaining the script workings and modification procedures as I will want to continuously add new songs to the spreadsheet
Project overview
I have a Spreadsheet that contains set list information for songs, and I need it to generate a new set list every time I click a button. The generated set list must adhere to specific rules and be visually formatted (e.g., multicolored) and ready for printing.
Rules for Set List Creation:
Alternate songs as much as possible between three performers: Wilton, Claudia, and Duo.
Always start a set with a high-energy song.
Sets must be exactly 11 songs long.
Never have more than 3 high-energy songs in a row.
The set list should randomize the songs each time but still follow these rules.
Deliverables:
A functional Google Sheet with a "Generate Set List" button.
A script (using Google Apps Script) that:
Randomly selects songs based on the rules above.
Outputs the selected set list to a specific sheet within the spreadsheet.
Applies formatting as per example of a manually completed setlist that I will attach for reference.
Additional information
- The solution must be user-friendly, not requiring technical skills for operation.
- Documentation should be provided explaining the script workings and modification procedures as I will want to continuously add new songs to the spreadsheet