A custom asset/sponsor scheduler.

Version 1.0.8

• Increased the max rows for processing schedule spreadsheet from 200 to 250.

• Added MaxRows setting will be used instead of the hardcoded 200 max rows.

• Changed 'Stock Indices' default matching text to 'Indices'.

Version 1.0.7

• Fixed a bug with assuming that sales ads always have non-empty creative data.

• Added handling for Premium sales ads with rotations.

Version 1.0.6

• Updated to .NET Framework 8.0 since .NET 7.0 has reached end of support.

• Updated vulnerable DLLs from Nuget.

Version 1.0.5

• Modified to save instance settings on change instead of needing to click on the Save/Save All/Save Instance menu options.

• Added a button to the instance UI to use the last converted sales worksheet file.

• Removed the prompt to open the converted sales worksheet file after the conversion is completed.

Version 1.0.4

• Properly fixed issue with duplication of creative titles for adjacent rows with same rotation and offsets when the house numbers are different (in v1.0.2).

• Fixed issue with items scheduled in the same zone and offset by bumping the start time of each subsequent conflict by 30 seconds.

• Added Zone & Comment columns to Saved Scheduled Items xlsx files in the logs folder. The Comment column can show which items' start times were bumped.

Version 1.0.3

• Added UI to set the Default Asset Duration for each Scheduler Instance. Default value is 10 seconds.

Version 1.0.2

• Fixed issue with duplication of creative titles for adjacent rows with same rotation and offsets when the house numbers are different.

Version 1.0.1

• Added new ‘Sales Spreadsheet Converter’ tab for converting of Excel Sale files to Ad Scheduler Excel files.

Version 1.0.0

• Copy the Creative field into the Asset description field.

• Use the Advertiser as the campaign and client.

• Open the last used file folder if the current input file field is blank.

• Save the schedule items in batches instead a single large transaction.

Version 0.1.2

• An initial test version

• Reads an Excel file to get sponsor schedules to apply to a Tick-It instance.

• Creates an asset placeholder for scheduling if the asset cannot be found.

Working Assumptions

1. Each day starts at 5:00 am and runs to 5:00 am the next day

2. If no Start and End Time is given then assume 5:00 am to 5:00 am the next day

   1. Example for an End Date of 2023-10-01 the actual end is 2023-10-02 5:00

      1. The last possible asset scheduled time would be 2023-10-02 4:59

3. Use the House# (example: AB15117) to identify the asset to be scheduled.

4. If no Rotate value is provided then the sponsor is scheduled once per hour at the given offset (example 5:08) of each day.

5. If the given End Time is at or before 5:00 it is assumed to be the next day. (example Start: 19:00 with End: 5:00)

6. If the asset doesn’t yet exist in the Tick-it database, then create a placeholder asset and schedule it assuming a user will assign the required template and campaign information in Flow.

7. Requires the following columns in the given order:

   1. Feature

   2. Advertiser

   3. House #

   4. Zone #

   5. Start Time (HH:mm)

   6. End Time (HH:mm)

   7. Rotate

   8. Start Day

   9. End Day

   10. (another column)

   11. Offset