Our Griffi(..) surname project has grown to sufficient size that maintaining the results chart was becoming overly time-consuming. The large table also made it more difficult for participants to compare results. Consequently, I revamped the project website to build the table dynamically from an Access database each time the table is accessed. Now, I simply download the results chart from FTDNA as an Excel spreadsheet and then import the results directly into Access. Upload the new database and Voila!, the results table is updated with any new results.
I also added new functionality that allows a participant to click on their kit number and a program will calculate the genetic distance of the selected kit against all other records in the table...and show those other participants that are potentially related (11-12/12, 22-25/25, etc.).
If other project administrators are interested in this approach, let me know.
Robert D. Griffith
Project Administrator
Griffi(th)(n)(s) Surname DNA Project
DuBose-DuBois Surname DNA Project
I also added new functionality that allows a participant to click on their kit number and a program will calculate the genetic distance of the selected kit against all other records in the table...and show those other participants that are potentially related (11-12/12, 22-25/25, etc.).
If other project administrators are interested in this approach, let me know.
Robert D. Griffith
Project Administrator
Griffi(th)(n)(s) Surname DNA Project
DuBose-DuBois Surname DNA Project
Comment