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..
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!!
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..
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!!
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?.
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.
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..
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.
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..
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).
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..
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???
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..
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.
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..
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!
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..
I have the goal of digitizing all WT Statistical Data, as much as possible, as far back as possible.
User 88JM
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.
i gathered the data for the memorial partakers every year since 1935 (the first year they had data) until now.. the latest figures haven't been that high since 1954!.
this stat looks very bad in watchtower land because the decreasing # of partakers was given, for decades, as proof that the end was near!.
.
I'd prefer the graph starting at zero on the Y axis.The graph like it is accentuates the rise in partakers since 2007. You can do it if you wish, I have shared the data in the link. (Just too tired to do it right now).
