The following new message has been added to the Williams Genealogy Forums, on the Williams DNA Project board under the existing topic of Re: DNA Results Page - Making Some Much Needed Changes... -------------------------------- Y'all!! OK, I have semi-finished my changes to the results page and the spreadsheet. This went a little quicker than I thought it would. I have just finished uploading the new versions of the Matched Groups and No-Match results pages. Although they don't look it, they are significantly different from the old versions, mainly in that the data is all pulled from a database now instead hand coded in an html page. What's the big deal, you might ask? Well, a number of really cool things. First, this change reduced the size of the results page file from over 500Kb to just over 30Kb. This translates quite simply into a much quicker load time for anyone viewing the page. Also, since I have the information in a database, and the page is pulling it's information from the database, then anytime I make a change in the database, then the website is automatically up to date. For example, if I get a 12-25 marker upgrade result in: It used to be that I'd copy those results into my spreadsheet and then when I had enough time, I would copy those entries, by hand and add them to the 12,000+ lines of code that made up the old results page....then I would upload that to the website. Usually, it would take me between 2weeks and a month to get the latest results posted. Now, when I get the results in, instead of copying them to a spreadsheet, I copy them to the database. As soon as I get them in the database, they are viewable on the website....no waiting. So, the time to get the results on the site just went from weeks to literally hours. There are a couple of other changes with this version of the results page. 1.) You will notice that the kit numbers are all underlined. I have linked each persons kit number to their email address (as it is listed in the database). Hopefully this will solve a couple of things. First, hopefully it will reduce the amount of email I get, requesting so-and-so's email address. Secondly, I hope it will help with and possibly spurn more communication between project members. 2.) The order of the participants in the groups may have changed. Although this is just a slight modification, it may still throw some folks. The change isn't arbitrary either. Essentially, I have corrected a long standing problem with the results...the results have been out of order based on DYS values....the proper order of the results relies on them being sort by each DYS value. In other words, for any given group, the participants are sorted first by marker 383, lowest to highest, then marker 390, lowest to highest, and so on and so forth thru the entire 37 marker series. A good place to look to see this in action is the first three members of the no match group. The all have the same numbers for the first four marker, but at 385a, they are all different. And you will see that they are listed in the order. 3.) Mismatched values are no longer highlighted. I have struggled to come up with a way to do this programmatically and have not been successful. Before, this was a visual and manual intervention by me. Now that the results are automatically pulled from the database, I don't have the ability to manually perform this anymore. I said in the beginning that this is semi-finished. I still have the Pending Results and mtDNA Results to finish, but those shouldn't take very long (knock on wood). I hope that these changes meet with everyones approval and if anyone finds anything wrong, please let me know so I can get it corrected!! - Adrian