My Latest Tweet

12.28.2008

Family Organizer Calendar

Last year, a friend of mine gave me a calendar made by www.leapyearpublishing.com. It was a "family" calendar, and on each month it contained a separate column for each member of the family (it had five blank columns).

We love it! It hangs on the side of the fridge, and we can all see at a glance, all four schedules and how they overlap and interact. I went to the website of the publisher today and couldn't find the 2009 version - I guess they've stopped making it.

Well! That didn't stop me ;-) I made one myself, and here's how:

1) Using Excel, I created a spread sheet with 33 rows and 7 columns.

2) Down the first column, starting on the third row, I numbered 1 through 31.

3) On the left side of the top row, I typed "Month:" and left the space after it blank (to create a perpetual template - after I printed it, I had Alyssa write the months at the top of each sheet in the blank space).

4) Across the second row, I entered column headers as follows:
Date, Day, Name1, Name2, Name3, Name4, Other.
(Under the "date" header are the numbers 1-31; under the "day" column are blank spaces to insert the days of the week).

5) I adjust the column widths and row heights so that the document would fill two pages when printed, and then printed using 8 1/2 x 11 card stock.

6) I printed 12 copies (24 sheets), and trimmed the bottom of the page 1's and taped them to the top of the page 2's.

7) I used a hole punch and three key rings to fasten them together at the top.

Now I have an 8 1/2 x 22 family calendar for 2009. It may not look quite as slick as last year's, but I know it will be a scheduling life saver.
____________________
Return to Jeanne's Blog List

3 comments:

LadyBanana said...

Very resourceful!

I don't know how I'd manage without my calendar each year!!

I have an award for you :)

JEANNE said...

Aw, that's so nice!!! Thanks :-)

Jaina said...

Very clever. Thanks for the step-by-step. :)

More Posts!

Blog Upp