Celebrate

PowerPoint macro for generating work anniversary and birthday slides.

Celebrate is compatible with Workday®'s RaaS json output. See information on creating the json with Workday RaaS below.

Installation

• View the latest release - https://github.com/swhitley/Celebrate/releases/latest
• Download Celebrate.pptm and data.txt to the same directory. Open Celebrate.pptm and follow the instructions.

Sample Data

This is an example of the json format that Celebrate can process. Celebrate also recognizes the json that is produced by Workday's Reporting as a Service (RaaS).

[
	{
		"group": "5",
		"photo": "https://tile.loc.gov/image-services/iiif/service:music:musgottlieb:musgottlieb-00151:ver01:0001/full/pct:25.0/0/default.jpg",
		"name": "Louis Armstrong",
		"title": "Satchmo'"
	},
	{
		"group": "5",
		"photo": "https://tile.loc.gov/image-services/iiif/service:music:musgottlieb:musgottlieb-04291:ver01:0001/full/pct:25.0/0/default.jpg",
		"name": "Lena Horne",
		"title": "Jazz Woman"
	}
]

About the Json Data

• photo can be a url, file path, or a base64-encoded image. Use double-backslashes (\\) for local files on Windows (e.g. c:\\temp\\pic.jpg) -- or use single, forward slashes (/).
• group can be any text, but special groups such as "1" and "0" have their own labels. You should sort all data items by group. Celebrate will not sort the data. For birthdays, you can use the birth month as the text for group.

Note: If you are viewing the text version of this README file, you will see four backslashes when referring to double-backslashes. This is due to markdown requirements. A double-backslash refers to two consecutive backslashes.

Control Slide

Run the macro from this slide.

• Change the values in the options table to change titles and labels.
• Enter presentation mode.
• Click the document image to open the data.txt file.
• Paste the Json into data.txt. Save and close the file.
• Click the Run button.

Slide Formatting

• You can change the design of the slides using standard PowerPoint formatting options.
• Beyond theme changes, you can alter the master slide by clicking View and Slide Master.
• Celebrate uses the last layout slide on the master. You can make changes to the title and subtitle on the Celebrate layout.
• The Celebrate layout is expected to be the last layout in the master list.

Workday RaaS Configuration

Create a Workday report to generate the json data for Celebrate.

If your photos are stored outside of Workday, use a calculated field to generate the unique url for each worker photo. Celebrate will use the generated url and will not need the base64-encoded photo data from Workday.

Credits

WebHelpers (c) Tim Hall - https://github.com/VBA-tools/VBA-Web (MIT License)

Base64Decode (for Mac) Antonin Foller, http://www.motobit.com

Thank you to Ellie Khorasani for her testing feedback, contributions, and support.

Celebrate is compatible with Workday®. It is not sponsored, affiliated with, or endorsed by Workday.