Is there a way to sort the Data Doctors Google spreadsheet by surname

+7 votes
219 views

I've been told that there is a way to sort the submenus of the Google Data Doctors spreadsheet by surname. The URL is: https://docs.google.com/spreadsheets/d/1jlRaiRtaMEpsPdeuRLS2ids4HAXJyGVCKiQyEMh4NNE/edit#gid=785282410

I would like to combine all of the same unsourced surnames together so I can work faster in the Sourcerer's Challenge. Some users can work 2-3 times faster than I can by combining all family members together. I would greatly appreciate any help because the faster I can work, the more profiles I can correct which benefits our common tree. 

in The Tree House by Living Smith G2G6 Mach 1 (14.3k points)

1 Answer

+6 votes
 
Best answer

If you are wanting by last name, you can get such a list by clicking on the last name in any profile to get to the "Genealogy" page,  the selecting the unsourced quick link, and then you will get a list like this example for Erwin.  However, this is not sorted by location. If this is important for you, you can use WikiTree+ (example for Erwin focusing on Missouri)

by W Robertson G2G6 Pilot (116k points)
selected by Living Smith
I'm working on your example and trying to get to the name Hicken, from Utah and must be unsourced. The problem I have is that H starts with Ha and I need a quick way to get to Hicken. Can I sort for all these factors? Also, I don't understand WikiTree+ or how to get there.
Pretty neat trick, WR. I’ve got to remember that one.

In wikitree+ in the text search part of the search section, put unsourced + surname + place in the search box, so unsourced  Hicken Utah is what you would want. These results are sorted by Creation date, so families will often be together. http://wikitree.sdms.si/default.htm?report=srch1&Query=unsourced++Hicken+Utah&MaxProfiles=500&SortOrder=Default&PageSize=500

When you add a source, be sure to remember to remove {{Unsourced}} above the Biography heading. This is what creates the big grey note saying "This profile lacks source information." at the top of the profile.  In the wikitree+ results in the last column you can see if there are templates (like unsourced) used in the profile

Okay, that is good stuff. I know about removing the unsourced designation. What I've been told is that some Wikitreers use one source for a group of family members. I don't see how that is possible if the source is unrelated to the profile.  

I added sources to 1341 profiles last month but it takes me too long to do that. I've seen people do several hundred a day and I'm trying to figure out how they do it.

I appreciate your help.
Wow! Congratulations on adding sources to 1341 profiles lady month.  That is far more than I have ever done and I am impressed.
I am in awe!  I did one today and puffed out my chest!  Hats off!
Don't be in awe because anyone is capable of doing the same thing. I have no magic way of doing so many profiles but if you want to know my secret here it is: I'm retired with nothing to do; I don't sleep well; I do 10-15 and take a break. I'll be on the computer all hours of the day and I challenged myself to do this and I set daily goals of about 50 and I break those down to groups of 10. I've learned a couple of shortcuts and I have a repetition that's similar to working on the line at the factory.
The way people use one source for multiple profiles is by using a census record and not switching it to each individual for the profile. They may use it from the father and then copy it to spouse and all the children. It isn't the correct way but is better than no sources.

Related questions

+23 votes
33 answers
+15 votes
26 answers
+18 votes
52 answers
+19 votes
42 answers
+7 votes
2 answers
+6 votes
1 answer
+5 votes
0 answers

WikiTree  ~  About  ~  Help Help  ~  Search Person Search  ~  Surname:

disclaimer - terms - copyright

...