Excel2GEDv092-family.xls is Copyright Paul D Pruitt and  
ILC of Rent-a-Coder 2008 and distributed under the  
terms of the GNU General Public License.

If you have any questions, please contact me at  
socrtwo@s2services.com.  My phone number is 240-277- 
6233.

My address and name are
Paul D Pruitt
9006 Friars Rd
Bethesda, MD  20817

Below is the same information from the Help Tab of the  
spreadsheet.  I do not know if the spreadsheet  
functions in Open Office.

I am not the actual coder of this file.  It was done  
under contract by a coder from Pakistan whose handle is  
ILC ("I love Coding") on the coder contractor site  
rentacoder.com.  ILC's strengths are databases and VBA.  
 He is a professional reasonable and hard working coder  
and I would recommend him to anyone.


User Guide
	
Where to enter data?	Fill-in the columns A through  
N, currently up to 999 rows are populated with  
formulas.
	
What if you want more rows?	If you want to enter  
more rows, you have to copy formula from any row of the  
O through S column and paste it into the new rows.  
Before you can do that you have to unprotect the  
worksheet first. After copying the formula reset the  
protection back.
	
Where to enter output .GED file name?	Enter full path  
of the GED file name next to File Name: - in cell G2.  
You can also click on Browse button to select a folder  
and enter a file name.
	
Where NOT to make any change?	Do not enter anything  
in the cells with red text, those are automatically  
calculated, these cells are however protected. So, the  
instruction is only applicable when you are enhancing  
the sheet in unprotected mode. You may want to  
unprotect the sheet to add more rows or to increase the  
column width for example.
	There is a hidden worksheet named "Family"  
which is also automatically calculated, so do not enter  
anything on this sheet either.
	Also the worksheet names "Family Names" and  
"Family" are used in code, so changing the names are  
not recommended unless you can change the code also.
	
How to protect/unprotect the worksheet	To unprotect  
the "Family Names" worksheet select Tools > Protection  
> Unprotect Sheet from the menu, enter the password on  
the displayed dialog and click ok. To protect it back  
select Tools > Protection > Protect Sheet menu option.  
You have to enter and re-enter the password to complete  
the process. The protection password is x2g (please  
remember the password and delete this instruction).
	
How to generate the .GED file?	Make sure that you have  
specified the file to be created. Click on Export  
GEDCOM File button to generate the GEDCOM file.
	
	Back to Data Sheet
	
	
	
	Technical Guide
	
Where to change the code?	Module "Genealogy"  
contains all the codes for Excel to GEDCOM export  
application. Press [ALT+F11] to see the VBA module.
	
How to alter the column sequences?	There are some  
constants defined in the beginning of the module
	There are comments besides the constants that  
are self explanatory
	In the event of any enhancement you may have to  
change the value of these constants
	
How to increase the number of header rows?	If you  
want to increase the header rows on first sheet or  
second sheet you can do so by changing the values of  
wrks1row0 or wrks1row0
	
How to extend the schema?	a) If you want to add  
additional information field for individuals you have  
to change the value of ncCount. Number of columns to be  
added has to be determined from the GEDCOM coding  
structure.
	b) In addition you have to introduce additional  
constant variables to represent sequence of each column  
added (see in code: 'Column sequences on sheet1)
	Also review the sequence values according to  
the altered column sequences
	You may not need to change 'Column sequences on  
sheet2
	c) Analyze GEDCOM coding structure for the  
changes
	d) Also you need to add code to represent newly  
added fields in the GED file. The code should go below  
the following section:
	*************** ADD EXTENDED FIELD'S CODE HERE  
***********************
	Please see the schema extension example in the  
following section for further clarification.
	
	
	Back to Data Sheet
	
	
	
	Schema Extension Example
	
Example of adding a Photo file path to the individual  
record	Extending the schema is a technical matter and  
VBA knowledge is required to do it. In this example we  
want to add a photo file path to the individual's  
record. We are assuming that all photo images are of  
.JPG format. A new column O [Photo File Path] is added  
to the worksheet.
	
Step 1: Change ncCount	Since there are now a total of  
20 columns ncCount is changed to 20
	'@PHOTO-CHANGE-1
	Const ncCount = 20 'how many columns are on the  
sheet1
	
Step 2: Add a variable to store column sequence	Add a  
new column sequence for new column. And also review the  
sequence value of the columns that follow the new one.
	'@PHOTO-CHANGE-2
	Const ncPhotoFilePath = 15
	
	Const ncFatherListed = 16 'seq changed from 15  
to 16
	Const ncMotherListed = 17 'seq changed from 16  
to 17
	Const ncSpouseListed = 18 'seq changed from 17  
to 18
	Const ncParentFamilyID = 19 'seq changed from  
18 to 19
	Const ncOwnFamilyID = 20 'seq changed from 19  
to 20
	
Step 3: Analyze GEDCOM coding structure	Multimedia file  
requires following GEDCOM code to be added:
	n OBJE
	+1 FORM <MULTIMEDIA_FORMAT>
	+1 TITL <DESCRIPTIVE_TITLE>
	+1 FILE <MULTIMEDIA_FILE_REFERENCE>
	For example, in our case, the code should be as  
below (after discarding the photo title)
	1 OBJE
	2 FORM jpeg
	2 FILE c:\photo\name.jpg
	Required source code changes are to be made to  
the following section of the code as shown:
	
Step 4: Add required VBA code 	Required source code  
changes are to be made to the following section of the  
code as shown:
	        '*************** ADD EXTENDED FIELD'S  
CODE HERE ***********************
	        '@PHOTO-CHANGE-3
	        If sColumn(ncPhotoFilePath) <> "" Then  
'PhotoFilePath present
	            sGed = sGed + "1 OBJE" & vbCrLf
	            sGed = sGed + "2 FORM jpeg" &  
vbCrLf
	            sGed = sGed + "2 FILE " & sColumn 
(ncPhotoFilePath) & vbCrLf
	        End If
	         
'****************************************************** 
****************
	
