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.

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). Include events for the next two full calendar months.

Example:  On July 15th, submit events for August and September; remove any July events)

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

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.

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

All fields are required unless otherwise indicated.

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.

Date Start and Date End You may leave the Date End field blank unless the event is multi-day. If an event is all month, please enter the first and last day of the calendar month (like 5/01/2019 and 05/31/2019) even if the library is closed on one of those dates.

Branch Please use BB, CB, FL, or MPL.

Descriptions

Calendar entries in the Word calendar will be grouped together in a block if the Titles and Descriptions are identical.
If your event happens multiple times per month, I recommend copy and pasting the description from one event entry to another. Or, copy and paste the entire event row.

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.
• 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).
• Don’t put a singular descriptions on multiple Excel rows. A description must go in a singular cell.
• It is OK if your event description scrolls far to the right, overlapping adjacent cells.
• It is OK to use the Wrap Text tool (Home ribbon, Alignment section) at your preference for ease of viewing.
• Do not use multiple space characters to align text or attempt formatting.

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.