- Fill out the Hard Problem stakeholder spreadsheet for the event, with attendees in rows and meetings in columns.
- Have stakeholders fill out the sprint attendance spreadsheet (copy from the sprint template).
- Important: Remove any unnecessary commas or linebreaks from cells of the two spreadsheets. They will interfere with parsing.
- Ensure that participants have entered their d.o username exactly in the signup sheet.
- Export the Hard Problems stakeholder spreadsheet as
meetings.csv
and the sprint spreadsheet asavailability.csv
using Google Docs' default CSV export. - Clean up any remaining commas or linebreaks within cells. For the sprint spreadsheet saved in
availability.csv
, you may just wish to delete the leading rows that contain instructions for the sheet. - Update the
M_HEADER_ROWS
,M_HEADER_COLS
, andA_PRE_HEADER_ROWS
constants inschedule.php
based on the files you have. - Run
php schedule.php
.