CSV format for Quarterly report

Discussions around using and interfacing with the Church MLS program.
brianc-p40
New Member
Posts: 11
Joined: Thu May 03, 2007 11:13 am
Contact:

CSV format for Quarterly report

Postby brianc-p40 » Sat Oct 31, 2009 1:03 pm

The quarterly report provides valuable information for a quarter. We have in the past, used a spreadsheet to map that over time, so we can see trends. That proved to be a time consuming process because the data had to be re-entered by hand.

If we could get the data in the printed Quarterly statistics report in a soft format, such as a CSV file, we could pull the data in and prepare a view over time.

Is there a way to get the data in a soft format?

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

Postby aebrown » Sat Oct 31, 2009 3:37 pm

brianc wrote:The quarterly report provides valuable information for a quarter. We have in the past, used a spreadsheet to map that over time, so we can see trends. That proved to be a time consuming process because the data had to be re-entered by hand.

If we could get the data in the printed Quarterly statistics report in a soft format, such as a CSV file, we could pull the data in and prepare a view over time.

Is there a way to get the data in a soft format?


As with most screens in MLS (financial data is the big exception), you can click somewhere in the Quarterly Report then click Ctrl+Shift+C (or using the Menu, do File > Copy to Clipboard). Then you can paste the data in a spreadsheet for further formatting and analysis.

Note that for the quarterly report, there are some cells you can click in where Ctrl+Shift+C won't work, so your best bet is the upper left corner cell, or just do File > Copy to Clipboard.


Return to “MLS Support, Help, and Feedback”

Who is online

Users browsing this forum: No registered users and 1 guest