Page 1 of 2

Stake statistical reports and graphs from quarterly reports

Posted: Sun Jan 24, 2010 2:56 pm
by stevewilson-p40
Has anyone had success creating an Excel or OpenOffice spreadsheet to track and graph quarterly reports at a stake level?

I found this old thread to be helpful, and the sample report by ericb was very helpful. http://tech.lds.org/forum/showthread.ph ... #post32553

However, my stake president is asking me to track multiple units in my stake over time. I have many years of quarterly reports in .csv format but haven't found a good way to put them together in a spreadsheet and graph that information as a whole.

Has anyone done that successfully? If so I would really appreciate seeing an example of how you did it.

-Steve in Phx

Posted: Sun Jan 24, 2010 5:26 pm
by jpapke-p40
We have been doing this for years. Our format may not be what you desire but each quarter I take all the MPR data and place it in a excel spreadsheet that keeps the last 3 years data. Each ward has one side of a page with all the numerical data and on the backside I have charts for the areas our stake president wishes to track. The first page of the set is the entire stake rolled up into a similar sheet. Give me your email address and I will be happy to send you our workbook.

Jeff Papke
Meridian Idaho North Stake Clerk

Posted: Sun Jan 24, 2010 6:04 pm
by stevewilson-p40
PM sent! Thanks!

Posted: Mon Jan 25, 2010 1:32 pm
by agregory-p40
I would also love this workbook. Could you send it to me?

Posted: Mon Jan 25, 2010 1:42 pm
by aebrown
agregory wrote:I would also love this workbook. Could you send it to me?
Rather than the hassle of sending it to lots of people, why don't you just attach it to a post? Or better yet, attach it to the wiki article Quarterly Report.

Quarterly reports

Posted: Tue Mar 02, 2010 9:27 pm
by jshiels-p40
I would also appreciate a copy of the workbook. thanks.

HI

Posted: Fri Mar 12, 2010 7:35 am
by hawkenph
May I plz have a copy too?
Thank u..
Kurt

Posted: Sat Mar 13, 2010 2:32 pm
by pete_arnett-p40
As Alan_Brown suggested, would you please attach a copy to the wiki article Quarterly Report.

Report update

Posted: Sun Mar 28, 2010 10:27 pm
by ericb
Alan_Brown wrote:Rather than the hassle of sending it to lots of people, why don't you just attach it to a post? Or better yet, attach it to the wiki article Quarterly Report.

I've updated the wiki article with the latest version of the spreadsheet (as mentioned at the beginning of this thread, I posted the original some time ago in another thread). This includes some instructions regarding the inputting of data.

Whitelaw program

Posted: Mon Jun 28, 2010 8:39 am
by ragraf-p40
This has made it possible to do all I need including sending a link to the stake president so he can browse at his leisure.

http://www.whitelawdesigns.com/software ... rtHelp.htm

makes all kinds of graphs.:)