The following link would open a COPY of the AGL Database. The original AGL Database is an Excel spreadsheet file, but I had to copy and save it to PDF format in order to be able to attach it here.
The AGL Database was prepared on a rush and surely has a lot of topo errors. The data so far entered were taken from two (2) separate postings shared in the Four Sisters Facebook Group. One posting shows the so-called 4 Sisters, their immediate children and their grandchildren. The other one is limited to the “Alagon Family Tree”, but still the most comprehensive and detailed I’ve come across yet to account a certain group within the AGL.
Anyway, the AGL Database I just created would enable me to enter any set of data relating to our genealogy. The idea is to put them altogether in one big database. It would thus be appreciated if anyone could send their own account of their own genealogy or family, be it limited to a certain level or section. As various and different accounts are compiled together in this AGL Database, every descendant’s position in our AGL genealogy would be sorted out automatically at ease.
Although this link is to show you the current update of the AGL Database, kindly read further down about my thoughts in creating this AGL Database so you could better understand/appreciate about the ‘AGL ID’ and the ‘CELL CODE’ in the AGL Database.
The LINK to the AGL DATABASE: AGL Database
Introduction
With the idea of coming up with a handy simple database for the whole of AGL, I would like to share my thoughts.
I’m going to use Excel Spreadsheet because it’s the most versatile Microsoft program, a most portable, and a simplest database program to use. Excel Spreadsheet can be shared to everyone who has a computer, as Excel Spreadsheet is available in almost any computer. Unlike a Word document file, Excel document file can be filtered, or sorted, or processed and analyzed with little programs (like apps) that come with Excel. Any name can be added at the bottom of the list and then later sorted to be automatically placed where you want it placed in the list. The list can be rearranged automatically in various ways, which could not be done in a Word document. As long as the database is designed enough to have key fields to contain essential data for each record of AGL member, the sorting, filtering, processing, or analyzing is conveniently possible with the operator’s fingertips.
Here’s a snapshot of the AGL Excel Spreadsheet with a few records randomly extracted from the AGL Database.
| AGL ID | Cell Code | Name (name of spouse) |
| B.1.1.1.1.1 | B5 | Lot Alvictus ‘Alagon’ Bacoling |
| B.1.1.1.6 | B4 | Thomas Magalgalit, Jr (Andrea) |
| B.1.1.1.7.5 | B5 | Emmanuel ‘Magalgalit’ M. Soliba |
| B.1.1.2.4 | B4 | Danny |
The above records are not in any order; just randomly selected. I only want to point out two significant columns here: AGL Lineage ID and Cell Code. The ‘Name’ is self explanatory and the “(name of spouse)” that follows a name in some cases is enclosed with parentheses. Maybe later on, a separate column can be created for the name of the spouse. We can later also add other columns, such as DOB (date of birth) and address. But for now, my priority are the above three (3) columns to be hopefully filled out eventually with every descendant of Ganga and Labanet.
The AGL Lineage ID (or AGL ID for short)
The format of the AGL Lineage ID (or AGL ID for short) as shown above is taken from the format used for the “Alagon Family Tree”, as shared by Hilaria (Bilalay-Batnag) in the Four Sisters Facebook Group. (The “Alagon Family Tree” appears to have been prepared by Sha Yahn as shown on the posting. A great work you di Sha Yahn, and thanks Hilaria for sharing.)
Since the “Alagon Family Tree” is understandably confined with the descendants of Edith Kaluguidan (married to Thomas Alagon), the numeric system used by Sha Yahn was modified for the AGL Database to account two levels further up. Whatever “numeric set” was used in the “Alagon Family Tree” is now preceded with “B.1.” to show that the person in the Alagon Family Tree is from Bistanga, then Edith ‘Kaluguidan’ Longid – Alagon. The “B” in B.1 is for Bistanga and the “1” in “B.1” is for Edith ‘Kaluguidan’ Longid – Alagon, as Edith was the 1st child of Bistanga.
To illustrate further how to understand the AGL ID No. for each person, I will use my AGL ID No. as an example:
C.4.7 – Jeremy B. Abeya (Eva Killip)
“C” for Calogidan; “4” for Ricario as 4th child of Calogidan, and “7” for me as 7th child of Ricario
(and Flora)Abeya.
My 3rd child would have AGL ID as C.4.7.3
Note that they are separated by dots because if there was C.4.7.12 for example and there were no dots between the numbers, it would look “C4712” and it could be mistaken as C.4.7.1.2. Therefore, it’s best to use a dot in between and also for readability.
The CELL CODE
The Cell Codes, as you can see above, are very short and can be figured out from the AGL ID by counting the number of numeric digits attached to the alphabet.
Two examples:
- C.4.7 would have a cell code of C2 because “C.4.7” has C and 2 numeric digits.
- C.4.7.2 would have a cell code of C3 because “C.4.7.2” has C and 3 numeric digits.
The cell code could help us more quickly have an idea how we are related to each other or how one is related to the other. By looking at anyone’s Cell Code, you could figure out how you are related with him or her even if you did not know the names of his/her parents and/or grandparents and/or great-grandparents.
My initial draft to explain how “The AGL Cell Codes” could help us quickly have an idea our relationship is attached, but the draft has yet to be completed and edited.
Attachment: AGL Cell Codes (This is downloadable).
Meli Kolismas am-in ken dakayo,
Jeremy ‘Pageet’ Abeya
Ap-on Ganga yas Labanet (AGL) 