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

#1

Post 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
jpapke-p40
New Member
Posts: 15
Joined: Mon Aug 13, 2007 3:20 pm
Location: Boise, Idaho, USA

#2

Post 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
stevewilson-p40
New Member
Posts: 5
Joined: Sun Jan 24, 2010 1:44 pm
Location: Phoenix, AZ, USA
Contact:

#3

Post by stevewilson-p40 »

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

#4

Post by agregory-p40 »

I would also love this workbook. Could you send it to me?
User avatar
aebrown
Community Administrator
Posts: 15153
Joined: Tue Nov 27, 2007 8:48 pm
Location: Draper, Utah

#5

Post 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.
jshiels-p40
New Member
Posts: 1
Joined: Thu Dec 13, 2007 4:13 pm
Location: Sacramento, CA

Quarterly reports

#6

Post by jshiels-p40 »

I would also appreciate a copy of the workbook. thanks.
hawkenswva
New Member
Posts: 6
Joined: Sat Aug 01, 2009 7:37 am
Location: Cebu, Philippines

HI

#7

Post by hawkenswva »

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

#8

Post by pete_arnett-p40 »

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: 109
Joined: Fri Feb 23, 2007 8:51 am
Location: Vancouver USA

Report update

#9

Post 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.
ragraf-p40
New Member
Posts: 5
Joined: Mon Jun 28, 2010 8:46 am
Location: New Harmony,Utah,USA

Whitelaw program

#10

Post 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.:)
Locked

Return to “MLS Support, Help, and Feedback”