ILoveTTATT2

Joined

• started 144 topics
• posted 932 times   see topics posted on
• send a message

Posts by ILoveTTATT2

• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  Uploaded.
  
  Try the link.
  
  All names used by the WT (and I had to remove some) for every country, and every country that reported, from 1926 to 2016.

  The link is HERE.
  
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  I have now finished all of the names of the countries that were in the report.

  Pre-1947, when the first report came out like we know it, I had to judge whether to include that country in or not. For many years, for example, the name appears in the report, only to say that there is no report because the country is banned. So I had to use my judgement there.
  
  Posting it up soon!!
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  What are you going to do with all the data?

  There is an incredible amount of things you can do once you have the data. For example, in what year were the witnesses covering the most/minimum amount of landmass of the Earth? There are some years, for example, where Russia and China were reporting. Easily the year in which the least number of countries reported was 1942.

  Once we have access to all of the data in digital form, there is sooooo much that is possible to analyze!!
• 
  45

  Are there any doctrines which all Christian religions follow.

  by jwfacts in

  1. watchtower
  2. beliefs

  i cannot think of a single doctrine that is so clearly laid out in the bible that every christian sect teaches the same point.

  are there any doctrine where there is total consensus amongst all christian religions, including jehovah's witnesses?.

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  How about fornication being wrong? I don't know... but putting it out there. At least "officially" I mean. In practice a whole different thing.
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  You can see the Excel Spreadsheet of the names HERE.

  It contains three sheets:

  1) As in yearbook. The exact order and almost the exact spelling used.

  2) Alphabetically: Organized alphabetically per year.

  3) Alpha + years active. This helps to see when a "land" was added and/or removed and/or had a name change.

  I am going to try and fill this spreadsheet up to 2016.
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  Hi Darkspilver,

  Could you upload the excel spreadsheet onto a Google Drive and share the link?

  I have the list of countries as listed in the yearbook, alphabetically, and also the years in which they appeared.

  (I am going to upload it soon, just needs some tweaking).
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  Thank you Darkspilver!

  However, that is per page... and there are about three pages per year so... 1.5 hours per year.

  The country matching from year to year... I have done that actually!

  You mean the names???
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  Hi Konceptual99,

  It really depends on your skills in Excel. If all goes well, you just have to copy something that has been OCRed, paste it in Excel with the text paster that does the brunt of the work, and do clean up. About 80% of the data gets pulled in correctly.
  
  It takes about an hour to clean up, I use macros that speed up the process (such as recording a macro to shift left, insert a row of specific length, etc).
  
  As long as it is exactly what's on the report but in Excel, I can work with that to make it in the same format as 88JM.
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  Anyone?

  Could you please PM me if you'd like to help even with just one year, i.e. 1977, 1976, etc??

  I would really appreciate the help!
• 
  16

  Goal: To digitize all WT statistical data

  by ILoveTTATT2 in

  1. jw
  2. friends

  i have the goal of digitizing all wt statistical data, as much as possible, as far back as possible.user 88jm.

  i recently did 1980 and i had a friend help me with 1979 and 1978.. do we have any volunteers to help me with previous years??.

  it's a lot of work, but if you know excel you can make some macros that will speed up the work..

  1. 
  2. 
  3. 
• 

  ILoveTTATT2

  I have the goal of digitizing all WT Statistical Data, as much as possible, as far back as possible.
  
  User 88JM

  has already done from 1981-2016

  https://drive.google.com/open?id=0B_bzL2A4XRiodmp0OWpWUmJjaFU//

  I recently did 1980 and I had a friend help me with 1979 and 1978.

  Do we have any volunteers to help me with previous years??

  It's a lot of work, but if you know Excel you can make some Macros that will speed up the work.