Stake statistical reports and graphs from quarterly reports

Discussions around using and interfacing with the Church MLS program.
stevewilson-p40
New Member
Posts: 5
Joined: Sun Jan 24, 2010 1:44 pm
Location: Phoenix, AZ, USA
Contact:

Stake statistical reports and graphs from quarterly reports

Postby stevewilson-p40 » Sun Jan 24, 2010 2:56 pm

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.php?p=32553#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

jpapke-p40
New Member
Posts: 15
Joined: Mon Aug 13, 2007 2:20 pm
Location: Boise, Idaho, USA

Postby jpapke-p40 » Sun Jan 24, 2010 5:26 pm

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

stevewilson-p40
New Member
Posts: 5
Joined: Sun Jan 24, 2010 1:44 pm
Location: Phoenix, AZ, USA
Contact:

Postby stevewilson-p40 » Sun Jan 24, 2010 6:04 pm

PM sent! Thanks!

agregory-p40
New Member
Posts: 2
Joined: Mon Jan 25, 2010 1:30 pm
Location: Indianapolis, Indiana

Postby agregory-p40 » Mon Jan 25, 2010 1:32 pm

I would also love this workbook. Could you send it to me?

User avatar
aebrown
Community Administrator
Posts: 14693
Joined: Tue Nov 27, 2007 8:48 pm
Location: Sandy, Utah

Postby aebrown » Mon Jan 25, 2010 1:42 pm

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.

jshiels-p40
New Member
Posts: 1
Joined: Thu Dec 13, 2007 4:13 pm
Location: Sacramento, CA

Quarterly reports

Postby jshiels-p40 » Tue Mar 02, 2010 9:27 pm

I would also appreciate a copy of the workbook. thanks.

hawkenph
New Member
Posts: 6
Joined: Sat Aug 01, 2009 6:37 am
Location: Cebu, Philippines

HI

Postby hawkenph » Fri Mar 12, 2010 7:35 am

May I plz have a copy too?
Thank u..
Kurt

pete_arnett-p40
Member
Posts: 152
Joined: Fri Jan 19, 2007 10:54 am
Location: Sunny South Florida, USA

Postby pete_arnett-p40 » Sat Mar 13, 2010 2:32 pm

As Alan_Brown suggested, would you please attach a copy to the wiki article Quarterly Report.
:cool: Your Fellow Servant,
Porter (Pete) Lee Arnett Jr.
USA

User avatar
ericb
Member
Posts: 105
Joined: Fri Feb 23, 2007 8:51 am
Location: Vancouver USA

Report update

Postby ericb » Sun Mar 28, 2010 10:27 pm

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.

ragraf-p40
New Member
Posts: 5
Joined: Mon Jun 28, 2010 7:46 am
Location: New Harmony,Utah,USA

Whitelaw program

Postby ragraf-p40 » Mon Jun 28, 2010 8:39 am

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/wardgraphs/importHelp.htm

makes all kinds of graphs.:)


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest