Page 1 of 1
trailing 12 month giving analysis
Posted: Mon Sep 01, 2014 1:32 am
by dellio01
Is there any way to import this report into excel? I like to pull a 12 month report at the end of each month and then manipulate the data in excel. I can usually come pretty close to what we should expect for the next months giving.
Re: trailing 12 month giving analysis
Posted: Mon Sep 01, 2014 1:33 am
by dellio01
by manipulate, I am not changing the data. I just add a column in excel and look over the past 12 months. Then I decide if I can expect support from that church this coming month. If so, I add the expected amount to the column I added in excel. Then I can just total the column I added.
Re: trailing 12 month giving analysis
Posted: Mon Sep 01, 2014 4:30 am
by jmuehleisen
I like that idea.
let me put that on my to do list.
Re: trailing 12 month giving analysis
Posted: Wed Sep 03, 2014 1:02 am
by dellio01
jmuehleisen wrote:I like that idea.
let me put that on my to do list.
Thank you. Will be looking forward to it...
Re: trailing 12 month giving analysis
Posted: Thu Oct 09, 2014 3:47 pm
by agrosh
This would be very useful for me. There are numerous times when I would like to export the Trailing 12 months of support to an excel spreadsheet so I can resort and filter those results in a variety of ways and then cut and paste it into other forms/formats. This functionality would simply my reporting to supporting churches and also my preparation of taxes in Papua New Guinea.
Andy
Re: trailing 12 month giving analysis
Posted: Mon Dec 29, 2014 1:57 pm
by jmuehleisen
I was looking over messages here on the forum today and ran across this thread again.
Then I remembered, the new report preview tool allows you to export reports as xls files.
So, actually, this feature is already built into the program.
Here's how to use it:
Step 1: Go to the Trailing 12 Month Giving Analysis Report. Select that item.
- ss-trailing-12-months-step-1.gif (17.34 KiB) Viewed 16281 times
Step 2: Select your dates and say <Preview> the report. Let it crunch the numbers and generate the report preview.
Step 3: On the report preview toolbar, click on the <Save> icon and choose <Save as XLS>
- ss-trailing-12-months-step-3.gif (7.93 KiB) Viewed 16281 times
Step 4: Save the name and location to save the xls file. The DM will generate a copy of the report in Excel and then you can work with is as you wish.
Let me know how that works for you.