Online Calendar

Submission

Each branch has an Excel Calendar submission file. This file is called Branch_CalendarSubmission.xlsx. This file is located directly in P:\Calendar Submission\Branch folder. That is, it’s not in the subfolder 2018 (or similar) that many of branches have.

Include events for the next two full calendar months. Don't include Storytimes or the regularly-occurring, after-storytime events (MOM club, Stay and Play...). Please delete prior months' events from CalendarSubmission.

Example: On July 15th, you should be submitting events for August and September; remove any July events)

You are free to create or use other files in your folders for future event planning, but CalendarSubmission is the only file used for the Calendar creation process.

Calendar submission work is due by the end of the day on the 15th of the month (or next business day if the 15th is a weekend/holiday).

Event Entry

Each Event should utilize one (and only one) row in the spreadsheet. If you have an event that occurs more than once in the month (Creative Writing Workshop, Read to Service Dog), create an entry for each day. Copy and paste to save yourself some time.

Fields

Time Start and Time End These fields are optional. Leave these both blank for all-day activities. It is permissible to leave the Time End field blank. Events will display as “10:30 - 11:30 AM” if both start / end times are used, and “10:30 AM” if only a start time is entered. The online calendar will default to a half hour block if there is no end time.

Do not use 3:00 p.m. as a time format. Unfortunately, Excel does not recognize that as a time format. Please use 3:00 PM formatting. Leave Date Start and Date End blank for all-month activities.

Date Start and Date End For normal, one day events, you may leave the Date End field blank. If an event is all month, leave Date Start and Date End blank.

Branch This is a required fields. Please use BB, CB, FL, MPL, or YS.

Description You can put as much text as you want in the description.

• To make it easier on yourself, you can increase / decrease the height of Excel's Formula Bar using Ctrl - Shift - U or drag the bottom of the formula bar to suit your preference.

• If your event happens multiple times per month, it's much easier to copy and paste the description from one event entry to another.
• Do not use multiple spaces or tabs to align text or attempt formatting.
• It is OK if your event description scrolls far to the right.
• It is OK to use the Wrap Text tool (Home ribbon, Alignment section) at your preference for ease of viewing.
• Don’t put a singular descriptions on multiple Excel rows. A description must go on one cell.
• You can have multiple paragraphs in one cell. How? Instead of “Enter” to end a paragraph like you’d do in Word, do an “Alt-Enter” (that is, hold Alt key down then press Enter).
• Spellcheck:  There aren’t automatic "red squiggly lines" in Excel like there are in Word.  But, a Spellcheck button lives on the Review tab, or press the F7 key at any time.