Directions for Editing District Directory Spreadsheet – Excel Version

The District Directory contains the following information on each member:

Last Name – The member’s last name and required suffix.  Ex:  Smith or Smith, Jr.

Title, First, MI – The member’s title if used, member’s first name and member’s middle initial.  Ex. Dr. John E. or John E. Note: We do not use Mr., Mrs., or Ms. designations.

Address – The member’s address.  Note: The address must only be a single line fitting the space provided. Use USPS authorized abbreviations (See Secretary Information File -
Vol. I , Item #11).

City – The member’s hometown or city. The city's name must fit the space provided.

St – The member’s home state utilizing the US Postal Service two-digit identification code.

Zip – 5 digit zip code. Note: We do not use the nine digit zip codes

Partner – The member’s partner’s name if appropriate. 

H Phone - The member’s home phone number in the following format: 724-555-1234. 
Note: This is a change in format that no longer uses parentheses.

Club – The club’s new initial format to make it easier to identify a member’s club in the Directory.

O Phone – The member’s office phone number in the following format: 724-555-1234. 

Email Address – The member’s primary email address, only one address to be entered.  The email address must fit the space provided.

PH – The member’s Paul Harris Fellowship status.  Codes: PHF – Paul Harris Fellow, PH+1, PH+2, PH+3, PH+4, PH+5, PH+6, PH+7, PH+8, Major – Major Donor (any Rotarian who has contributed in excess of $10,000), RFSM – Rotary Foundation Sustaining Member (any Rotarian who contributes on an annual basis to the Rotary Foundation who is not yet a Paul Harris Fellow), or blank.  These notations may be found on your club’s Club Recognition Summary (CRS).   

Note: If an item of a member’s information is not available, leave the cell blank. Do not put N/A.

Corrections:     Go to cell(s) that needs to be corrected and simply type in the correct information. 

Additions:     Enter data on first available blank row of the spreadsheet and then use the sort command to alphabetize.

Deletions:     Click on Row Number of the person you wish to delete. Click on Edit then Delete.

When all corrections have been made to the file, sort into an alphabetical list and SAVE by clicking the save icon.  The spreadsheet should then be emailed to Peter Richdale at peterjody@zoominternet.net and PDG Lee Ahlum at ahlum2@verizon.net as an attachment.

CLA Associates

Rotary Graphics have been supplied compliments of Tord Elfwendahl. The Rotary Club of Stockholm Strand, RI District 2360 Creator and Curator of a very extensive Library of Rotary Graphics.