We currently have a script which takes the information present in the excel spreadsheet and populates it to a json template (see the zip file). Though, we have a new excel spreadsheet with 10 tabs (see "App1 Song [url removed, login to view]" attached). We would like a script that can be ran within App1 Song [url removed, login to view] to collect all the purple/blue cells into the json template.
Please reply with "Dear Ben" indicating you've read the description.
The purple/blue cells of "App1 Song List Tim [url removed, login to view]" will be where the data is pulled from. Later we will fill these purple/blue cells.
The json template, will include the following keys:
Song Title, "lyricLine" (lines are taken from the green box), "beginningLineTime", "endingLineTime", "syllable", "beginningSyllableTime" are required.
We would like to pay around $50 for this task, so bid competitively.