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/
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.
Three years later, there's over 20 articles translated and going now at a rate of about 1 per week!
http://www.verdadtj.com/
The articles translated are:
UN
Birthdays
Blood
1914
1925
1975
Why it's wrong to be a JW
Watchtower Scandals
Disfellowshipping
General Pamphlet
Growing up a JW
Jehovah in the NT
Fear and Mind Control
False Dates
How to Help Someone Come Out
Misquotes, Lies, Deception
Generation
Light Gets Brighter
Paradise
Organization
Governing Body
Faithful and Discreet Slave (in progress).
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!.
.
When Tony and Goofery got their appointments in 2005, followed by the the baby, Mark Sanderson, in 2012, the org had to come up with a way to leave the door open a crackAnd that door was officially opened in 2007. http://www.jwfacts.com/watchtower/memorial-partakers.php
