+ Reply to Thread
Results 1 to 3 of 3

Fundraising Model

  1. #1
    Registered User
    Join Date
    01-11-2007
    Posts
    4

    Fundraising Model

    I have a spreadsheet with a list of years as column headers, beginning with this year.

    2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 etc.

    Below each year I have a figure in dollars of what funds could be raised for that particular year (a special church building fundraiser). The data for each year is calculated from other budget data.

    The main point is that there is no way the church can run a fundraiser every year, so I want to program the spreadsheet to be able to respond to a certain number of criteria:

    A) How many years from now will you start your first cycle of fundraising?
    B) How many years will each cycle last?
    C) How many years break will you take before starting the next cycle?
    D) How many cycles of fundraising overall will you have?

    I want to have a way for these user-inputted criteria above to be accounted for. So, if the answers to questions A-D above are:

    A) Start in 1 year
    B) 3 year cycle
    C) 1 year break
    D) 2 cycles total

    ... then I want to see fundraising figures for only the bold, starred years below:

    2007 *2008 *2009 *2010 2011 *2012 *2013 *2014 2015 2016

    Anybody have a suggestion for a strategy and any particular helpful functions for tackling this?

    I have been trying different VBA functions, but have gotten lost. I am pretty new to this but can learn quickly if you give me a suggestion to go research. Thanks!

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by automatq
    I have a spreadsheet with a list of years as column headers, beginning with this year.

    2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 etc.

    Below each year I have a figure in dollars of what funds could be raised for that particular year (a special church building fundraiser). The data for each year is calculated from other budget data.

    The main point is that there is no way the church can run a fundraiser every year, so I want to program the spreadsheet to be able to respond to a certain number of criteria:

    A) How many years from now will you start your first cycle of fundraising?
    B) How many years will each cycle last?
    C) How many years break will you take before starting the next cycle?
    D) How many cycles of fundraising overall will you have?

    I want to have a way for these user-inputted criteria above to be accounted for. So, if the answers to questions A-D above are:

    A) Start in 1 year
    B) 3 year cycle
    C) 1 year break
    D) 2 cycles total

    ... then I want to see fundraising figures for only the bold, starred years below:

    2007 *2008 *2009 *2010 2011 *2012 *2013 *2014 2015 2016

    Anybody have a suggestion for a strategy and any particular helpful functions for tackling this?

    I have been trying different VBA functions, but have gotten lost. I am pretty new to this but can learn quickly if you give me a suggestion to go research. Thanks!
    Hi,

    not fully understanding your question.

    If your data is in year/column then would you not simply add together figures from the required columns, ie, ignore A, add B + C + D, ignore E and add F + G + H ?

    This could be in two separate 'helper' columns if row-by-row numbers are required, and simply formula-filled to complete the columns.

    Does this give what you are seeking?

    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    01-11-2007
    Posts
    4
    I appreciate you taking the time to reply, Bryan. I dont quite understand your suggestion, and may in the next few days take more time to explain my dilemma, but I think I am figuring out a solution, and I would rather not waste your time if I can fix it myself. I'll let you know if I can't get it soon.

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1