Google Sheets Randomized Setlist Generator
Budget: $30 – $250 AUD
Project Overview
I need a Google Sheets-based automation that generates a randomized setlist at the press of a button while ensuring it follows specific placement rules. The tool should work for 1-set, 2-set, 3-set, and 4-set versions and be user-friendly for any band or musical act. It will be based on a sample setlist that i provide.
Key Requirements
Setlist Structure (Sheet 1 - Template)
The sheet will have columns for each set:
1-set version: Column B
2-set version: Columns B, D
3-set version: Columns B, D, F
4-set version: Columns B, D, F, H
Each set contains a specific number of songs (to be determined).
Below each set, unused songs (spares) should be listed evenly as backups.
Song List (Sheet 2 - Data Source)
This sheet will contain all available songs with the following attributes:
Song Title
Song Characteristics (e.g., energy level, singer, etc.)
Rules for Song Placement
The system must follow specific rules regarding:
Alternating singers with specific colours to differentiate (ability to add multiple if needed).
Energy levels and song flow.
Ensuring no duplicates across the main setlist and the spares.
Even distribution of unused songs below each set as spares.
Automation & Usability
(Rules to be explained later)
A button should be added to Sheet 1, which triggers the Google Apps Script.
Clicking the button will randomly generate a new setlist while ensuring all placement rules are followed.
The script should work for 1-set, 2-set, 3-set, and 4-set versions, detecting the number of sets dynamically.
Deliverables
Google Sheets file with embedded Google Apps Script for automation.
A well-documented script that allows for easy modifications.
A simple user guide explaining how to use the tool.
I need a Google Sheets-based automation that generates a randomized setlist at the press of a button while ensuring it follows specific placement rules. The tool should work for 1-set, 2-set, 3-set, and 4-set versions and be user-friendly for any band or musical act. It will be based on a sample setlist that i provide.
Key Requirements
Setlist Structure (Sheet 1 - Template)
The sheet will have columns for each set:
1-set version: Column B
2-set version: Columns B, D
3-set version: Columns B, D, F
4-set version: Columns B, D, F, H
Each set contains a specific number of songs (to be determined).
Below each set, unused songs (spares) should be listed evenly as backups.
Song List (Sheet 2 - Data Source)
This sheet will contain all available songs with the following attributes:
Song Title
Song Characteristics (e.g., energy level, singer, etc.)
Rules for Song Placement
The system must follow specific rules regarding:
Alternating singers with specific colours to differentiate (ability to add multiple if needed).
Energy levels and song flow.
Ensuring no duplicates across the main setlist and the spares.
Even distribution of unused songs below each set as spares.
Automation & Usability
(Rules to be explained later)
A button should be added to Sheet 1, which triggers the Google Apps Script.
Clicking the button will randomly generate a new setlist while ensuring all placement rules are followed.
The script should work for 1-set, 2-set, 3-set, and 4-set versions, detecting the number of sets dynamically.
Deliverables
Google Sheets file with embedded Google Apps Script for automation.
A well-documented script that allows for easy modifications.
A simple user guide explaining how to use the tool.