Spreadsheet usage is making things easier.

+15 votes

Ever since the Source-A-Thon I've been keeping a spreadsheet with multiple tabs going that covers the weekly suggestion report, direct links to unsourced profiles, and the weekly data doctor challenge.

This sheet can be used by anyone and has the added benefit of a live chat feature. Many of you have been hearing about this but have trouble finding it or understanding how it is used.

When you first access the sheet you will be assigned a random animal unless I have your email address that is assigned to a google or youtube account. You don't want to be the skunk because that just stinks up the whole sheet. This animal is not assigned to YOU, it is assigned to an unknown connection. Leaving and rejoining will cause it to change.

That being said, the suggestions and week challenge are wiped and updated as soon as I have access to the reports from Ales Trtnik. This spreadsheet is definitely NOT a replacement for his awesome work but merely a way for his static report to become "interactive".

You will not "break the sheet". It automatically backs itself up and I can restore it. This should help to relieve people who worry about messing things up. We all do it, it is part of learning.

This is the link to the sheet. http://tinyurl.com/Doctorsheet

I also have a screenshot showing features that are on this sheet. Feel free to study the photo as it will answer most of your questions.


Feel free to stop by and say hi.


Questions, comments, suggestions are all welcome.

asked 4 days ago in The Tree House by Steven Tibbetts G2G6 Mach 2 (29,360 points)
edited 4 days ago by Steven Tibbetts
i love google docs and spreadsheets. PGM is using them, too, differently.

Nice work, Steven.
Question: other than the chat feature, how is using a google sheet easier? (People will want to know.)
Google Docs is different but it does have the advantage of being free and available for everyone. Whereas, one needs to buy Microsoft Office in one form or another. Google Docs encourages "free genealogy" which is a boon in my book.

I love seeing what you are doing, Steven. It's fabulous.
If you need something for free on your computer, search for "open office". I'ts free and it reads all the latest office files and saves as slightly older versions.

Glad you like the sheet.
we currently have a skunk in the spreadsheet. hold your nose. LOL
Any suggestions on improvements?

3 Answers

+5 votes
Best answer
I started using the Doctorsheet 2 or 3 challenges ago, and love it! I have had an easier time just going down a list updating profiles without running into other people who've already done the work. The possibility for headbumps is still there, but it is much diminished now and no longer a frustration. I hope anyone who plans to work on a particular group visits this spreadsheet. It really helps!
answered 4 days ago by Joyce Rivette G2G5 (5,780 points)
selected 4 days ago by Debbie Parsons
+3 votes
I am interested in this, but I don't feel like I will be very active this month. I don't understand how it works though. What do the coloured cells mean?
answered 4 days ago by Dawn Ellis G2G6 Mach 6 (65,180 points)
If you are working in a certain area you color the cell to let people know you are doing those. In cases where you are working on a really big one you can if you chose find a blank spot, type the column row in and then put pages you will work on. Like "G44, pg 1-6". This lets someone know that they can start in at page 7.

The sheet usage is for convenience so we don't do the same areas. Chat is to communicate and possibly holler for help. The "open" and "new"  columns aren't good choices though because they spread through all the century columns.

And of course, when you want to take a break you can always chat for a few minutes and get to know fellow wikitreers.
+1 vote
Just to let everyone know, I have started an "Info" tab where we can put quick links, info to make profiles better, etc. I'm sure quite a bit of it can be found in the help section but it is sometimes more convenient to have it 1 tab over and directly to it.

Feel free to add links, tips, tricks, etc.
answered 14 hours ago by Steven Tibbetts G2G6 Mach 2 (29,360 points)
Thanks Steven!

Related questions

+5 votes
1 answer
+4 votes
2 answers

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

disclaimer - terms - copyright