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).
it seems most of the us growth is in spanish-speaking territory, and of course, there is growth in the nations where spanish is the predominant language.
most sites oriented around ttatt, are english-speaking.
there seems then to be a great need for translators...for instance, imagine if there was a spanish version of www.jwfacts.com.. unfortunately, i dont speak this language.
It shouldn't be necessary to translate the parts from a Spanish WT publication on jwfacts.I know that.
I would conrtact Paul with your ideas in a practical form.I am in constant contact with Paul. In fact, many times the English articles have been improved by my research. Things that Paul missed, things like that.
or advertise in more sitesThat site doesn't work anymore. I haven't been to the new Spanish forum, but it seems like it's single-issue, and I am already the admin of the largest Spanish exJW page on Facebook.
http://extj.com/
