Page 1 of 1

Quarterly report datasets

Posted: Mon Dec 05, 2016 11:19 pm
by chamb606
I'm wanting to do some trend analysis of the data collected in the quarterly report for our District (I'm the district clerk). Is the data presented on LCR under the quarterly report available digitally so I can import it into Excel so I can generate custom graphs. I'm wanting the data from the last 10 years. I understand that this may present privacy and IP (intellectual property) issues.
If this isn't possible does someone have any other ideas so I don't have to spend hours transcribing the data into Excel.

Regards

Re: Quarterly report datasets

Posted: Mon Dec 05, 2016 11:44 pm
by russellhltn
chamb606 wrote:I'm wanting the data from the last 10 years.
I tend to doubt if it goes back that far. Even if it did, I'd be very careful in the interpretation of it. For example, HT/VT stats isn't about grading the teachers, but how well the member's needs have been met. As a result, as members move in/out, the stats for prior quarters will change based on each family's(sister's) visit record.

Re: Quarterly report datasets

Posted: Tue Dec 06, 2016 6:22 am
by eblood66
russellhltn wrote:For example, HT/VT stats isn't about grading the teachers, but how well the member's needs have been met. As a result, as members move in/out, the stats for prior quarters will change based on each family's(sister's) visit record.
Actually, quarterly report data is static and doesn't change. It's the HT/VT statistics page where it changes based on membership changes. The quarterly report data is entered manually so there is no way the system can tie it to specific membership changes.
chamb606 wrote:so I can generate custom graphs.
The Key Indicator report on LCR already graphs most of the values from the quarterly report but it only goes back 4 years. But I'm not sure you're going to get much more unless you have paper records that go back further.