Upcoming Events Report

1. Navigate to https://ces.fas.harvard.edu/api/events/between/YYYY-MM-DD/YYYY-MM-DD.
2. Copy and paste the data into http://www.jsonquerytool.com/. Make sure query type is JSONPath.
3. Run this expression: $.items[?(@.calendar=='public')].['title','location','startDateTime','endDateTime'].
4. Copy output to Sublimetext.
5. Run this regular expression: [0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}-[0-9]{2}-[0-9]{2}.
6. Edit all lines to match this format: 12:34.
7. Remove commas, quotation marks, tabs, and square brackets from beginnings and ends of lines. Leave a line break at the end.
8. Run this regular expression: (?:[^\n]*\n){4}.
9. Change every first and second line break into a tab.
10. Copy and paste the whole thing into Excel.
11. Format dates with the following expression: mmmm d, yyyy, h:mmAM/PM.