set_schedules_spreadsheet

set_schedules_spreadsheet sets a spreadsheet containing schedules to allow the use of the reschedule command. To use the reschedule command, you need to have an unique id for each match.

Command	Example
::set_schedules_spreadsheet <spreadsheet_id> <global_range> <range_match_id> <team_name1_pos> <team_name2_pos> <referee_pos> <streamer_pos> <commentator_pos> <time_part1> <time_part2> ...	::set_schedules_spreadsheet 1234567890ABCDEF Sheet1!A:Z (1, 0) (2, 0) (6, 0) (3, 0, "%d") (4, 0, "%b") (5, 0, "%H:%M")

<global_range> must be a range containing all the times and their corresponding data (match ids, team names, referee...). A range is an array of cells. You can also write "None" or "All" to select all the sheets of your spreadsheet.
For example: A2, B5:B, A1:E4, Sheet2!C3:D3, None, All
IMPORTANT: If your sheet name (Sheet2 in the example) has spaces in it, you must write the range with quotation marks ("). Example: "My Sheet!A1:D6"

<range_match_id> must be a range containing all the match ids.
Example: A:A, C2:C

<team_name1_pos>, <team_name2_pos> and <referee_pos> must be defined by coordinates from the match id cell. In the spreadsheet, team_name1 and team_name2 must be the same that the Discord team role name or the Discord nickname of the players.
For example, if team_name1 is 1 cell to the right and 2 cells below, it would be: (1, 2)

<streamer_pos> and <commentator_pos> are like <team_name1_pos>, <team_name2_pos> and <referee_pos>, except than you can also put None if you don't want to add them. Also, <commentator_pos> can be an array of coordinates. For example: [(10, 0), (11, 0)]

<time_part1>, <time_part2> and etc... must be coordinates from the match id cell like <team_name1_pos>, but you also need to add a string for date formatting. You can find all the date formatting flag here. There can be any number of time_part cells that you want (1 minimum).
For example, if you have 2 cells indicating the time of a match (see image below), then <time_part1> will be (4, 0, "%d %B") and <time_part2> will be (5, 0, "%H:%M")

CAUTION: Do not surround coordinates with quotation marks (").

IMPORTANT: You must have admin rights on the bot to use this command.