   Sooner or later you’ll probably volunteer to head up your family reunion, won’t you? What a way to make memories and enjoy conversations and great food. But, yes, it involves some work. Thankfully, you will use your Mac; that makes the job easier.
   Let’s start with Address Book. A lot of preparation here, but it saves time later. You’ll be notifying the relatives, later reminding the relatives, corresponding with them, and then finally thanking them after it’s over.
   Probably you’ve already got those names and addresses of the chosen relatives under a title such as Christmas Cards. Click under File to make a Family Reunion 2011 group. Now just drag address listings under Name to add them to this group.
   If some of the relatives have email you might not want to notify them by mail. For this, just click to Edit individual cards and omit the mailing address. When you open Mail and New Message just type in the group name, Family Reunion 2011. The names of those people who do have email addresses will be the recipients.
   For relatives without email you will mail the Reunion info. When you have Address Book open click on the Group name. At the menu at the top of the screen go to File > Print. Uncheck Attributes since they don’t apply. Click on Address Book and see the selections available. Click on Style and see the selections there. You can print on the envelopes or print out address labels. Under Paper Size you have lots of possibilities.
   Under Style is where you choose the address label size. Click on Mailing Labels and note two places: Layout and Label. Specify to print in alphabetical order or postal code order. You can choose the font name and size. Lucida Grande - 12.0 comes up automatically.
   Click on Layout. I’m using Avery Standard labels, 5160. You get a little preview look to verify that’s what you want.
   Now for sharing some wonderful family photos, old and new. Call on Keynote!
   Go to Applications > iWork 9 and look at Keynote. This is the handy way to make a slideshow for the Reunion. Up comes Theme Chooser. Nifty templates are ready for your pictures to be added. On the menu at the top of the screen go to Help > Video Tutorials. Brush up on the how-to directions and then play and have fun. It’s Mac and it’s easy.

   Next to Numbers! Now to make lists, lists, and more lists. Go to iWork > Numbers and choose a format, perhaps Checklist, Budget, Expense, or Event Planner. Take a look at all the possibilities on the Event Planner template shown just above. Click on illustration to enlarge.
   Obviously, you want to delegate, delegate and delegate. Location? Menu? Assigned photographer? Name tags? Written introductions? Music?
   Map: Google > Prescott Valley AZ then click on maps.google.com. You can email the URL or go in closer to do a screen shot of the area on the map you want to print off and send to family.
   Accommodations in Prescott: Google: hotels, Prescott AZ and up comes listings with links, descriptions, prices, reviews, directions, etc.
   If you haven’t already done it, make a new folder on your desktop and put all of these items you’re working on into it.
   Going to make up a booklet of family remembrances, names & dates, etc? Go to www.bluesquirrel.com for the Mac ClickBook program. Inexpensive & easy to do.
   Plan ahead! You’ll appreciate your Mac computer all the more as you sail through the Family Reunion this year!
   (If you attended today's PMUG meeting you received the printed copy of this handout. If you weren't there WE MISSED YOU. See you in July?)

Here's a tip John Carter has discovered regarding NUMBERS. He begins, "Let's say you have two DATE columns (formatted for dates). Let's call them Start and Finish.

"Now let's say you want to know the number of months between these dates, and you want the result in Integer format to a two decimal precision.

"The standard way of subtracting the two dates gives a result that looks like an Integer, but it is actually a DURATION format. You can't operate on a DURATION value in the same way that you can operate on an Integer and expect an Integer value, because what you get will still be in DURATION format.

John continues, "For instance, let's say that the Start value is 1/1/2009 and the Finish value is 10/1/2009. The difference (=Finish-Start) will be 273 days, and it will appear as 273d in the cell. The 'd' stands for days, not duration. Now if you want to find the number of months as an Integer you might think that just dividing by 30 (or by (364/12) to be a little more accurate) would give you the number of months in Integer format, but it doesn't. Look:

"The manner in which Months is displayed depends on how many places you want to show in the result (using the Inspector). But notice that the result appears to be 9 days, given by the '9d' value. This is actually supposed to be read as 9m, because it's months, not days, but Apple didn't think ahead on this one and didn't provide the Inspector with the ability to format a duration in months, and if we set the display for weeks, we get 1w 2d 0h. Well, fortunately that equates to 9d. Oh, what a mess! It's very awkward in this format to read properly, so let's change the value of Days to an Integer format.

"With Microsoft Excel, you could simply change the Days cell format to be an Integer and be done with it. NUMBERS doesn't allow changing the format of a DURATION in such a direct fashion.

In the Days cell where you are subtracting the two dates, e.g., "=Finish-Start", use the following formula instead:

=DUR2DAYS(Finish-Start)

This converts that value to an integer.

Then in the next column when you divide Days by (364/12), you get a real Integer instead of a duration that doesn't even look right.

John concludes, "We could have used DUR2DAYS() on the Months value. It will amount to the same Integer value." ###

Your Family Reunion!

Using NUMBERS