{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Data","StepByStep","GiG Overview","Core GiG Report","Number of Donors","GiG Report - Totals","What if","GiG Report - Ratios","Number of Donors - Ratios","FEPdata","FEP100Dn","FEP100to249","FEP250to999","FEP1000to4999","FEP5000Up"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":84,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Data","index":0,"n_rows":5,"n_cols":17,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Acct","Date","Amt","Year","Last row","First year","No. Gifts","Total Amt",null,null,null,null,null,null,null,"P","Q"]
[null,null,null,null,59741,2002,{"$f":"E2-1","v":59740},{"$f":"SUM(C2:C440264)","v":0},null,null,null,null,null,null,null,14,9]
[null,null,null,null,null,null,{"$f":"FEPdata!X6","v":0},{"$f":"FEPdata!W6","v":0},null,null,null,null,null,null,null,14,4]
[null,null,null,null,null,null,"  ------- need to be equal ---------",null,null,null,null,null,null,null,null,14,3]
[null,null,null,null,null,null,"If not, contact FEP@afpnet.org",null,null,null,null,null,null,null,null,14,7]

{"sheet":"StepByStep","index":1,"n_rows":39,"n_cols":14,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[null,null,"                    FEP Analytics",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:41:22","19:35:37","16:08:39"]
[null,null,"By Fundraising Effectiveness Project",null,null,null,null,"10:50:46","10:50:46","16:35:34","Include gift-trans by month range"]
[null,null,null,null,null,null,null,{"$f":"H2-H1","v":"00:09:24"},{"$f":"I2-I1","v":-0.36447916666666663},{"$f":"J2-J1","v":"00:26:55"},0," <-- 1st month"]
[null,"      Growth-in-Giving (GiG) Reports",null,null,null,null,null,"FEP Fitness","Indicators","Indicators",0," <-- Last month"]
[null,null,null,null,null,null,null,"Test","By Year2","Trends","   E.G., where '1' = Jan & '12' = Dec"]
["MUST Enable Content (above) before macros can be run.","FEP Fundraising Performance Indicators",null,null,null,null,null,null,null,null,"0' in either field & option ignored"]
[null,"Using Gift Transaction Data* By Giving Level/Range",null,null,null,null,12,"<-- 12 = Jan-Dec. Change Year for Fiscal Calculations."]
[null,"* Can be all gifts or by fundraising program"]
[null,null,null,null,null,null,"Initial Year2"]
[null,"Growth-in-Giving is measured for Year2 -------->",null,null,null,"Year2: ",2012,"<-- Always the most current year",null,null,null,null,null," "]
[null,null,null,null,null,"Year1: ",{"$f":"G10-1","v":2011},"<-- Always the prior year"]
[]
["Step 1","Enter gift transaction data in columns A, B and C of \"Data\" Worksheet - start in row 2.  [See \"Data\" worksheet instructions]"]
[null,"    First, delete prior data from row 2 down to end of data."]
["Step 2","Enter Year2 above for the initial year to be analyzed"]
["Step 3","Click on the \"FEP Fitness Test\" button ---------------------->",null,null,null,null,"          FEP Fitness Test"]
[null,"Can take up to 30 minutes -- or more"]
["Step 4","Print and/or save(*) FEP Analytics Tables 1 & 4 and other FEP report worksheets for analysis"]
[]
["Steps 5-7 replace results in Tables 1 & 4 for each additional Year2"]
["Step 5","Enter another Year2 for each additional year as needed using same gift data."]
["Step 6","Click on the \"FEP Indicators by Year2\" button ------------->",null,null,null,null,null,null,"   <---Macro calculates in worksheet \"FEPdata\""]
[null,"Can take up to 10 minutes -- or more",null,null,null,null,"  FEP Indicators by Year2"]
["Step 7","Repeat print-or-save Step 4 for each Year2.",null,null,null,null,null,null,null,"<-- MultiGift yearly analysis:"]
[null,null,null,null,null,null,null,null,null,"      Enter 'Only' to include MultiGift donors"]
["Additional \"FEP Growth-in-Giving (GiG) Reports\" are availble at www.afpnet.org/FEP",null,null,null,null,null,null,null,null,"      or 'Not' to exclude MultiGift donors."]
["1.  Goto www.afpnet.org/FEP, scroll down to and click on \"FEP Growth-in-Giving (GiG) Reports\"",null,null,null,null,null,null,null,null,"      Leave blank to skip MultiGift analysis."]
["and download the Excel-based \"GiG Reports Template\" that has 8 more very useful GiG reports."]
["2.  For instruction #2 in the \"GiG Reports Template,\" you can copy gain(loss) data sets from the FEP Fitness Test",null,null,null,null,null,null,null,null,"       Where \"X\" ="]
["to the \"DataInput\" worksheet.  Copy cells B12 to E18 in Fitness Test worksheets \"FEPdata,\" \"FEP100dn,\"",null,null,null,null,null,null,null,null,null,"From:",1,"times yearly"]
["\"FEP100to249.\" \"FEP250to999,\" \"FEP1000to4999,\" or \"FEP5000up\"to cells B22 to E28 in the \"DataInput\" worksheet",null,null,null,null,null,null,null,null,null,"To:",100,"times yearly"]
["of the \"GiG Reports Template\" and print and/or save the 8 GiG reports."]
["3.  Other useful FEP data and guidance can be found at www.afpnet.org/FEP."]
[]
["Questions or comments"]
["Email FEP@afpnet.org"]
[]
["(*) Save FEP report worksheets by copying them (Alt-E;M;Alt-C) to new worksheets in a separate or new workbook."]
["     Then selecting and copying all cells (A1 to Xn) in each new workbook and pasting in cell A1 as values (Alt-E;S;V)."]

{"sheet":"GiG Overview","index":2,"n_rows":108,"n_cols":8,"rows_kept":108,"cut":false,"hidden":false,"merged":[]}
["GiG Overview",null,"       Growth-in-Giving (GiG) Reports"]
[null,null,"           By Fundraising Effectiveness Project"]
[{"$f":"StepByStep!$A$3","v":0}]
[]
["First, become familiar with the FEP and the basic GiG concepts "]
["Be sure to visit http//www.afpnet.org/fep for a better understanding of the gain(loss) concepts "]
["and to learn how to use the GiG Reports to help you develop growth-oriented fundraising "]
["strategies and justify your growth-oriented budgets to your CEO and board.  You will find "]
["\"A Better Measure of Success - how to use GiG reports to improve fundrising performance,\" "]
["Fundraising Effectiveness Survey Reports from 2004-05 forward and other useful resources.  "]
[]
["Caution"]
["ONLY enter data in the \"Data\" worksheet and ONLY enter data in columns A, B and C (*)."]
["This is necessary in order to preserve the formulas in all the worksheets in this Excel file."]
["Of course, if you should overwrite a formula, you can always down load the FEP "]
["Fundraising Fitness Test Level I, v1.2.xlsm Excel file again."]
["(*) Exceptions: comparative data fields in worksheets \"Comparison\" and \"Comparison - FEP Ratios.\""]
[]
["There are eight GiG Reports.  The eight worksheets containing seven “Growth-in-Giving "]
["(GiG) Reports” and the “What If….” report are automatically populated with the gain(loss) "]
["data you have provided.  You can employ just the \"Core GiG Report\" or any combination of"]
["the eight reports in this template that you find useful in support of your fundraisign programs."]
[]
["You can prepare GiG reports for more than one fundraising activity. The queries for extracting the "]
["relevant gift transactions data from your donor database can be set up for the fundraising program "]
["overall, as well as for each fundraising activity, such as direct mail, annual gving and major gifts."]
[]
["You can prepare GiG reports for more than one year. You can repeat this procedure for "]
["more than one year. This will enable you to measure and compare growth in giving over time "]
["by gain/loss category (see \"Comparison\" worksheet)."]
[]
["Exclude one-time major gifts. Large one-time major gifts can distort year-to-year GiG "]
["reports and should be excluded from the analysis for both year 1 and year 2."]
[]
["Definitions for Gain/Loss categories in GiG Reports:"]
["New – donors who never gave prior to year 2 (current year)"]
["Recaptured – previously lapsed donors who gave again in year 2."]
["Upgraded – donors who gave more in year 2 than in year 1 (previous year)."]
["Same – donors who gave the same amount in both years."]
["Downgraded – donors who gave less in year 2 than in year 1."]
["Lapsed new – new, first-time donors in year 1 who did not give in year 2"]
["Lapsed repeat – other lapsed donors who gave in year 1 and prior years but not in year 2"]
[]
[null,null," ------------- Donations made --------------"]
[null,null,"Before","During","During"]
[null,null,"Year 1","Year 1","Year 1"]
[null,"New","no","no","yes"]
[null,"Recaptured","yes","no","yes"]
[null,"Upgraded","n/a","yes","yes"]
[null,"Same","n/a","yes","yes"]
[null,"Downgraded","n/a","yes","yes"]
[null,"Lapsed new","no","yes","no"]
[null,"Lapsed repeat","yes","yes","no"]
[]
[{"$f":"A1","v":"GiG Overview"},null,null,{"$f":"FEPdata!$C$1","v":0},null,null,null,"Page 2"]
[]
["Descriptions of Growth-in-Giving (GiG) Reports"]
[]
["There are 7 useful growth-oriented fundraising reports.  Important: all required data "]
["is entered only into the “Data” worksheet – all the other worksheets are populated "]
["automatically by macro and formula from the “Data” worksheet (*)."]
["(*) Exception: comparative data fields in worksheet \"Comparison - FEP Ratios.\""]
[]
["NOTE: Crossreferences to tables and figures in the \"A Better measure of Success\" article (*) are in [..]"]
[null,"(*) A copy of the article in PDF is available at"]
[null,"http://www.afpnet.org//Audiences/ReportsResearchDetail.cfm?ItemNumber=5181.  "]
[null,"Or, you can goto http://www.afpnet.org/FEP and find “AFP's Growth-in-Giving (GiG) Reports” "]
[null,"on the Fundraising Effectiveness Project home page. "]
[]
["Core GiG Report",null,null,"[Tables 2 & 3 and Figure 3]"]
["The centerpiece of the GiG Reports: gains and losses in amount of gifts by gain(loss) category "]
[]
["The core AFP Growth-in-Giving (GiG) Report provides a concise, yet informative picture "]
["of fundraising gains and losses - growth in giving and attrition - together in a simple, "]
["reader-friendly format that the executive staff and board members can understand.   "]
[]
["Fundraising managers can use GiG Reports with CEOs and boards to help justify "]
["growth-oriented fundraising budgets  "]
[]
["Number of Donors"]
["GiG Report for growth in number of donors.—by gain(loss) category"]
[]
["GIG Report - Totals",null,null,"[Figure 1]"]
["GiG Report showing total gains in gifts, total losses in gifts and net gain(loss) in gifts."]
[]
["What if",null,null,"[Table 1 and Figure 2]"]
["The \"What If\" Gains Increased and/or Losses Decreased? report shows the enormous "]
["potential for increasing the organization’s “Net” with various levels of improved gain(lloss) performance.   "]
[]
["GiG Report Worksheets With Gain (Loss) Ratios"]
["All gain(loss) statistics published in the annual Fundraising Effectiveness Survey reports for use "]
["in comparative analysis are in the form of ratios(**)."]
[]
["GiG Report - Ratios",null,null,"[Table 4]"]
["The “Core GiG Report” with columns added for “Gain(Loss) ratios” and “Percentage Distribution”"]
[]
["Number of Donors - Ratios",null,null,"[Table 5]"]
["The “Number of Donors” GiG report with columns added for “Gain(Loss) ratios,” “Percentage "]
["Distribution,” and “Average Gift Size.”"]
[]
["Comparison – FEP Ratios"]
["The “GiG Report - Ratios” GiG report with columns added for comparing “FEP Survey "]
["Ratios(*)” to the Year 2 “Gain(Loss) ratios” column plus a column for “Differences” between the "]
["organization’s Year 2.gain(loss) ratios and FEP survey ratios(**).  "]
[]
["(**) Comparative FEP survey ratios by size, subsector, region and age for several years can be "]
["found in the appendices of the annual Fundraising Effectiveness Survey reports at "]
["http://www.afpnet.org/FEP. "]

{"sheet":"Core GiG Report","index":3,"n_rows":50,"n_cols":8,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
["Core GiG Report",null,"       Growth-in-Giving (GiG) Report"]
[null,null,"           By Fundraising Effectiveness Project"]
[]
["[Table 3 & Figure 3 *]",null,null,"Gains & Losses for ",{"$f":"StepByStep!$G$10","v":2012}]
[]
[null,"Gain(Loss) Category","Year 1","Year 2","Gains",null,"Caution: if you"]
[null,"For Year 2 Donors",{"$f":"D7-1","v":2011},{"$f":"StepByStep!$G$10","v":2012},"(Losses)",null,"enter data in this"]
[null,null,"(A$)  ","(B$)  ","(C$=B-A) ",null,"worksheet, you"]
[null,null,null,null,null,null,"will destroy the"]
["Gains",null,null,"Amount of Gifts",null,null,"formula cells."]
[null,"New","n/a",{"$f":"FEPdata!E12","v":133838},{"$f":"D11","v":133838}]
[null,"Recaptured","n/a",{"$f":"FEPdata!E13","v":54477},{"$f":"D12","v":54477}]
[null,"Upgraded",{"$f":"FEPdata!C14","v":183332},{"$f":"FEPdata!E14","v":307294},{"$f":"D13-C13","v":123962}]
[null,"Subtotal gains",{"$f":"SUM(C11:C13)","v":183332},{"$f":"SUM(D11:D13)","v":495609},{"$f":"D14-C14","v":312277}]
["Same",null,{"$f":"FEPdata!C15","v":54201},{"$f":"FEPdata!E15","v":54201},{"$f":"D15-C15","v":0}]
["Losses"]
[null,"Downgraded",{"$f":"FEPdata!C16","v":314530},{"$f":"FEPdata!E16","v":187866},{"$f":"D17-C17","v":-126664}]
[null,"Lapsed new",{"$f":"FEPdata!C17","v":103250},"n/a",{"$f":"-C18","v":-103250}]
[null,"Lapsed repeat",{"$f":"FEPdata!C18","v":162936},"n/a",{"$f":"-C19","v":-162936}]
[null,"Subtotal losses",{"$f":"SUM(C16:C19)","v":580716},{"$f":"SUM(D16:D19)","v":187866},{"$f":"D20-C20","v":-392850}]
[]
["Total - gifts",null,{"$f":"C14+C15+C20","v":818249},{"$f":"D14+D15+D20","v":737676},{"$f":"D22-C22","v":-80573}]
[null,null,null,null,"Overall net growth in giving"]
[]
[]
[null,null,null,null,null,null,"For chart:"]
[null,null,null,null,null,null,null,"Gifts"]
[null,null,null,null,null,null,"New",{"$f":"E11","v":133838}]
[null,null,null,null,null,null,"Recaptured",{"$f":"E12","v":54477}]
[null,null,null,null,null,null,"Upgraded",{"$f":"E13","v":123962}]
[null,null,null,null,null,null,"Total gains",{"$f":"E14","v":312277}]
[null,null,null,null,null,null,"Downgraded",{"$f":"E17","v":-126664}]
[null,null,null,null,null,null,"Laps new",{"$f":"E18","v":-103250}]
[null,null,null,null,null,null,"Laps repeat",{"$f":"E19","v":-162936}]
[null,null,null,null,null,null,"Total losses",{"$f":"E20","v":-392850}]
[null,null,null,null,null,null,"Net",{"$f":"E22","v":-80573}]
[]
[]
[]
[]
["Definitions for Gain/Loss categories in GiG Reports:"]
["New – donors who never gave prior to year 2 (current year)"]
["Recaptured – previously lapsed donors who gave again in year 2."]
["Upgraded – donors who gave more in year 2 than in year 1 (previous year)."]
["Same – donors who gave the same amount in both years."]
["Downgraded – donors who gave less in year 2 than in year 1."]
["Lapsed new – new, first-time donors in year 1 who did not give in year 2"]
["Lapsed repeat – other lapsed donors who gave in yr 1 & prior yrs but not in yr 2"]
[]
["* Tables and figures in A Better Measure of Success article"]

{"sheet":"Number of Donors","index":4,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["Number of Donors",null,"       Growth-in-Giving (GiG) Report"]
[null,null,"           By Fundraising Effectiveness Project"]
[]
[null,null,null,null,"Gains & Losses in Number of Donors for ",{"$f":"StepByStep!$G$10","v":2012}]
[]
[null,"Gain(Loss) Category","Year 1","Year 2","Gains",null,null,"Caution: if you"]
[null,"For Year 2 Donors",{"$f":"D7-1","v":2011},{"$f":"StepByStep!$G$10","v":2012},"(Losses)",null,null,"enter data in this"]
[null,null,"(A)   ","(B)   ","(C=B-A) ",null,null,"worksheet, you"]
[null,null,null,null,null,null,null,"will destroy the"]
["Gains",null,null,"Number of Donors",null,null,null,"formula cells."]
[null,"New","n/a",{"$f":"FEPdata!D12","v":1012},{"$f":"D11","v":1012}]
[null,"Recaptured","n/a",{"$f":"FEPdata!D13","v":275},{"$f":"D12","v":275}]
[null,"Upgraded",{"$f":"FEPdata!B14","v":582},{"$f":"FEPdata!D14","v":582},{"$f":"D13-C13","v":0}]
[null,"Subtotal gains",{"$f":"SUM(C11:C13)","v":582},{"$f":"SUM(D11:D13)","v":1869},{"$f":"D14-C14","v":1287}]
["Same",null,{"$f":"FEPdata!B15","v":299},{"$f":"FEPdata!D15","v":299},{"$f":"D15-C15","v":0}]
["Losses"]
[null,"Downgraded",{"$f":"FEPdata!B16","v":602},{"$f":"FEPdata!D16","v":602},{"$f":"D17-C17","v":0}]
[null,"Lapsed new",{"$f":"FEPdata!B17","v":619},"n/a",{"$f":"-C18","v":-619}]
[null,"Lapsed repeat",{"$f":"FEPdata!B18","v":405},"n/a",{"$f":"-C19","v":-405}]
[null,"Subtotal losses",{"$f":"SUM(C16:C19)","v":1626},{"$f":"SUM(D16:D19)","v":602},{"$f":"D20-C20","v":-1024}]
[]
["Total - gifts",null,{"$f":"C14+C15+C20","v":2507},{"$f":"D14+D15+D20","v":2770},{"$f":"D22-C22","v":263}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Gifts"]
[null,null,null,null,null,null,null,"New",{"$f":"E11","v":1012}]
[null,null,null,null,null,null,null,"Recaptured",{"$f":"E12","v":275}]
[null,null,null,null,null,null,null,"Upgraded",{"$f":"E13","v":0}]
[null,null,null,null,null,null,null,"Total gains",{"$f":"E14","v":1287}]
[null,null,null,null,null,null,null,"Downgraded",{"$f":"E17","v":0}]
[null,null,null,null,null,null,null,"Laps new",{"$f":"E18","v":-619}]
[null,null,null,null,null,null,null,"Laps repeat",{"$f":"E19","v":-405}]
[null,null,null,null,null,null,null,"Total losses",{"$f":"E20","v":-1024}]
[]
[]
[]
[]
[]
["Definitions for Gain/Loss categories in GiG Reports:"]
["New – donors who never gave prior to year 2 (current year)"]
["Recaptured – previously lapsed donors who gave again in year 2."]
["Upgraded – donors who gave more in year 2 than in year 1 (previous year)."]
["Same – donors who gave the same amount in both years."]
["Downgraded – donors who gave less in year 2 than in year 1."]
["Lapsed new – new, first-time donors in year 1 who did not give in year 2"]
["Lapsed repeat – other lapsed donors who gave in year 1 and prior years but not in year 2"]

{"sheet":"GiG Report - Totals","index":5,"n_rows":38,"n_cols":7,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["GiG Report - Totals",null,"       Growth-in-Giving (GiG) Report"]
[null,null,"           By Fundraising Effectiveness Project"]
[]
["[Figure 1*]",null,null,"Gains & Losses for ",{"$f":"StepByStep!$G$10","v":2012}]
[]
[null,"Gain(Loss) Category","Year 1","Year 2","Gains",null,"Caution: if you"]
[null,"For Year 2 Donors",{"$f":"D7-1","v":2011},{"$f":"StepByStep!$G$10","v":2012},"(Losses)",null,"enter data in this"]
[null,null,"(A)    ","(B)    ","(C=B-A) ",null,"worksheet, you"]
[null,null,null,null,null,null,"will destroy the"]
[null,"Total gains",{"$f":"'Core GiG Report'!C14","v":183332},{"$f":"'Core GiG Report'!D14","v":495609},{"$f":"D10-C10","v":312277},null,"formula cells."]
[]
[null,"Same",{"$f":"D12","v":54201},{"$f":"'Core GiG Report'!D15","v":54201},{"$f":"D12-C12","v":0}]
[]
[null,"Total losses",{"$f":"'Core GiG Report'!C20","v":580716},{"$f":"'Core GiG Report'!D20","v":187866},{"$f":"D14-C14","v":-392850}]
[]
[null,"Total and net gain[loss]",{"$f":"C10+C12+C14","v":818249},{"$f":"D10+D12+D14","v":737676},{"$f":"D16-C16","v":-80573}]
[null,null,null,null,"Overall growth in giving"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["* Tables and figures in A Better Measure of Success article"]

{"sheet":"What if","index":6,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["What If",null,"       Growth-in-Giving (GiG) Report"]
[null,null,"           By Fundraising Effectiveness Project"]
[]
["                 \"What If\" Gains Increased and/or Losses Decreased?",null,null,null,null,null,{"$f":"StepByStep!$G$10","v":2012}]
["[Table 1 and Figure 2 *]"]
[null,null,"Total","Total",null,"What if net",null,"Caution: if you"]
[null,null,"Gains","Losses","Net","Increase",null,"enter data in this"]
[null,null,"(A)  ","(B)  ","(A-B) ","(%)  ",null,"worksheet, you"]
["Current Year-2 results",null,{"$f":"'Core GiG Report'!E14","v":312277},{"$f":"'Core GiG Report'!E20","v":-392850},{"$f":"C9+D9","v":-80573},null,null,"will destroy the"]
["What if gains increased by",null,{"$f":"C9*$A11","v":62455.4},null,null,null,null,"formula cells."]
[0.2,null,{"$f":"C$9+C10","v":374732.4},{"$f":"D$9+D10","v":-392850},{"$f":"C11+D11","v":-18117.599999999977},{"$f":"(E11-E$9)/E$9","v":-0.77514055576930263}]
["What if losses decreased by",null,null,{"$f":"-D11*$A13","v":78570}]
[0.2,null,{"$f":"C$9+C12","v":312277},{"$f":"D$9+D12","v":-314280},{"$f":"C13+D13","v":-2003},{"$f":"(E13-E$9)/E$9","v":-0.97514055576930236}]
["What if losses decreased by",null,null,{"$f":"-D11*$A15","v":157140}]
[0.4,null,{"$f":"C$9+C14","v":312277},{"$f":"D$9+D14","v":-235710},{"$f":"C15+D15","v":76567},{"$f":"(E15-E$9)/E$9","v":-1.9502811115386047}]
["What if gains increased",null,{"$f":"C10","v":62455.4},{"$f":"D14","v":157140}]
["and losses decreased",null,{"$f":"C$9+C16","v":374732.4},{"$f":"D$9+D16","v":-235710},{"$f":"C17+D17","v":139022.40000000002},{"$f":"(E17-E$9)/E$9","v":-2.7254216673079075}]
[]
[]
[null,null,null,null,null,null,null,null,"Current Year 2","Gains +20%","Losses +20%","Losses +40%","Gains +20%, Losses +40%"]
[]
[null,null,null,null,null,null,null,"Gains",{"$f":"$C9","v":312277},{"$f":"$C11","v":374732.4},{"$f":"$C13","v":312277},{"$f":"$C15","v":312277},{"$f":"$C17","v":374732.4}]
[null,null,null,null,null,null,null,"Losses",{"$f":"$D9","v":-392850},{"$f":"$D11","v":-392850},{"$f":"$D13","v":-314280},{"$f":"$D15","v":-235710},{"$f":"$D17","v":-235710}]
[null,null,null,null,null,null,null,"Net",{"$f":"$E9","v":-80573},{"$f":"$E11","v":-18117.599999999977},{"$f":"$E13","v":-2003},{"$f":"$E15","v":76567},{"$f":"$E17","v":139022.40000000002}]
[]
[]
[]
[]
[]
[]
[]
[]
["* Tables and figures in A Better Measure of Success article"]

{"sheet":"GiG Report - Ratios","index":7,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["GiG Report - Ratios",null,"       Growth-in-Giving (GiG) Report"]
[null,null,"           By Fundraising Effectiveness Project"]
[]
["[Table 4 *]",null,null,null,"Gains & Losses for ",{"$f":"StepByStep!$G$10","v":2012}]
[]
[null,"Gain(Loss) Category","Year 1","Year 2","Gains","Gain(Loss)","Percentage",null,"Caution: if you"]
[null,"For Year 2 Donors",{"$f":"D7-1","v":2011},{"$f":"StepByStep!$G$10","v":2012},"(Losses)","Ratio","Distribution",null,"enter data in this"]
[null,null,"(A)   ","(B)   ","(C=B-A) ","(D%=","(E%=",null,"worksheet, you"]
[null,null,null,null,null,"C/totA)","C/tots in C)",null,"will destroy the"]
["Gains",null,null,"Amount of Gifts",null,null,null,null,"formula cells."]
[null,"New","n/a",{"$f":"FEPdata!E12","v":133838},{"$f":"D11","v":133838},{"$f":"E11/(C$22+0.00001)","v":0.16356634716127286},{"$f":"E11/(E$14+0.00001)","v":0.42858743998345739}]
[null,"Recaptured","n/a",{"$f":"FEPdata!E13","v":54477},{"$f":"D12","v":54477},{"$f":"E12/(C$22+0.00001)","v":6.6577533243956585E-2},{"$f":"E12/(E$14+0.00001)","v":0.17445088814820012}]
[null,"Upgraded",{"$f":"FEPdata!C14","v":183332},{"$f":"FEPdata!E14","v":307294},{"$f":"D13-C13","v":123962},{"$f":"E13/(C$22+0.00001)","v":0.15149667154922894},{"$f":"E13/(E$14+0.00001)","v":0.39696167183631959}]
[null,"Subtotal gains",{"$f":"SUM(C11:C13)","v":183332},{"$f":"SUM(D11:D13)","v":495609},{"$f":"D14-C14","v":312277},{"$f":"E14/(C$22+0.00001)","v":0.3816405519544584},{"$f":"E14/(E$14+0.00001)","v":0.99999999996797706}]
["Same",null,{"$f":"FEPdata!C15","v":54201},{"$f":"FEPdata!E15","v":54201},{"$f":"D15-C15","v":0},{"$f":"E15/(C$22+0.00001)","v":0}]
["Losses"]
[null,"Downgraded",{"$f":"FEPdata!C16","v":314530},{"$f":"FEPdata!E16","v":187866},{"$f":"D17-C17","v":-126664},{"$f":"E17/(C$22+0.00001)","v":-0.15479884484851436},{"$f":"E17/(E$20+0.00001)","v":0.32242331679578529}]
[null,"Lapsed new",{"$f":"FEPdata!C17","v":103250},"n/a",{"$f":"-C18","v":-103250},{"$f":"E18/(C$22+0.00001)","v":-0.12618408332761563},{"$f":"E18/(E$20+0.00001)","v":0.26282296042415232}]
[null,"Lapsed repeat",{"$f":"FEPdata!C18","v":162936},"n/a",{"$f":"-C19","v":-162936},{"$f":"E19/(C$22+0.00001)","v":-0.19912764940502065},{"$f":"E19/(E$20+0.00001)","v":0.41475372280551748}]
[null,"Subtotal losses",{"$f":"SUM(C16:C19)","v":580716},{"$f":"SUM(D16:D19)","v":187866},{"$f":"D20-C20","v":-392850},{"$f":"E20/(C$22+0.00001)","v":-0.48011057758115061},{"$f":"E20/(E$20+0.00001)","v":1.000000000025455}]
[]
["Total - gifts",null,{"$f":"C14+C15+C20","v":818249},{"$f":"D14+D15+D20","v":737676},{"$f":"D22-C22","v":-80573},{"$f":"E22/(C$22+0.00001)","v":-9.8470025626692242E-2}]
[null,null,null,null,null,"Overall rate of growth"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Gifts"]
[null,null,null,null,null,null,null,null,null,"New",{"$f":"G11","v":0.42858743998345739}]
[null,null,null,null,null,null,null,null,null,"Recaptured",{"$f":"G12","v":0.17445088814820012}]
[null,null,null,null,null,null,null,null,null,"Upgraded",{"$f":"G13","v":0.39696167183631959}]
[null,null,null,null,null,null,null,null,null,"Total gains",{"$f":"G14","v":0.99999999996797706}]
[null,null,null,null,null,null,null,null,null,"Downgraded",{"$f":"G17","v":0.32242331679578529}]
[null,null,null,null,null,null,null,null,null,"Laps new",{"$f":"G18","v":0.26282296042415232}]
[null,null,null,null,null,null,null,null,null,"Laps repeat",{"$f":"G19","v":0.41475372280551748}]
[null,null,null,null,null,null,null,null,null,"Total losses",{"$f":"G20","v":1.000000000025455}]
[]
[]
[]
[]
[]
["Definitions for Gain/Loss categories in GiG Reports:"]
["New – donors who never gave prior to year 2 (current year)"]
["Recaptured – previously lapsed donors who gave again in year 2."]
["Upgraded – donors who gave more in year 2 than in year 1 (previous year)."]
["Same – donors who gave the same amount in both years."]
["Downgraded – donors who gave less in year 2 than in year 1."]
["Lapsed new – new, first-time donors in year 1 who did not give in year 2"]
["Lapsed repeat – other lapsed donors who gave in year 1 and prior years but not in year 2"]
[]
["* Tables and figures in A Better Measure of Success article"]

{"sheet":"Number of Donors - Ratios","index":8,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
["Number of Donors - Ratios",null,null,"       Growth-in-Giving (GiG) Report"]
[null,null,null,"           By Fundraising Effectiveness Project"]
["[Table 5 *]"]
[null,null,null,null,null,"Gains & Losses in Number of Donors for ",{"$f":"StepByStep!$G$10","v":2012}]
[null,null,null,null,null,null,null,"Year 2"]
[null,"Gain(Loss) Category","Year 1","Year 2","Gains","Gain/Loss","Percentage","Average",null,"Caution: if you"]
[null,"For Year 2 Donors",{"$f":"D7-1","v":2011},{"$f":"StepByStep!$G$10","v":2012},"(Losses)","Ratio","Distribution","Giftsize",null,"enter data in this"]
[null,null,"(A)   ","(B)   ","(C=B-A) ","(D%=","(E%=","(F$=",null,"worksheet, you"]
[null,null,null,null,null,"C/totA)","C/tots in C)","Gift$/B)",null,"will destroy the"]
["Gains",null,null,"Number of Donors",null,null,null,null,null,"formula cells."]
[null,"New","n/a",{"$f":"FEPdata!D12","v":1012},{"$f":"D11","v":1012},{"$f":"E11/(C$22+0.00001)","v":0.40366972316047173},{"$f":"E11/(E$14+0.00001)","v":0.78632478021503671},{"$f":"'Core GiG Report'!D11/D11","v":132.2509881422925}]
[null,"Recaptured","n/a",{"$f":"FEPdata!D13","v":275},{"$f":"D12","v":275},{"$f":"E12/(C$22+0.00001)","v":0.10969285955447602},{"$f":"E12/(E$14+0.00001)","v":0.21367521201495562},{"$f":"'Core GiG Report'!D12/D12","v":198.09818181818181}]
[null,"Upgraded",{"$f":"FEPdata!B14","v":582},{"$f":"FEPdata!D14","v":582},{"$f":"D13-C13","v":0},{"$f":"E13/(C$22+0.00001)","v":0},{"$f":"E13/(E$14+0.00001)","v":0},{"$f":"'Core GiG Report'!D13/D13","v":527.99656357388312}]
[null,"Subtotal gains",{"$f":"SUM(C11:C13)","v":582},{"$f":"SUM(D11:D13)","v":1869},{"$f":"D14-C14","v":1287},{"$f":"E14/(C$22+0.00001)","v":0.51336258271494772},{"$f":"E14/(E$14+0.00001)","v":0.99999999222999236},{"$f":"'Core GiG Report'!D14/D14","v":265.17335473515249}]
["Same",null,{"$f":"FEPdata!B15","v":299},{"$f":"FEPdata!D15","v":299},{"$f":"D15-C15","v":0},{"$f":"E15/(C$22+0.00001)","v":0},null,{"$f":"'Core GiG Report'!D15/D15","v":181.27424749163879}]
["Losses"]
[null,"Downgraded",{"$f":"FEPdata!B16","v":602},{"$f":"FEPdata!D16","v":602},{"$f":"D17-C17","v":0},{"$f":"E17/(C$22+0.00001)","v":0},{"$f":"E17/(E$20+0.00001)","v":0},{"$f":"'Core GiG Report'!D17/D17","v":312.06976744186045}]
[null,"Lapsed new",{"$f":"FEPdata!B17","v":619},"n/a",{"$f":"-C18","v":-619},{"$f":"E18/(C$22+0.00001)","v":-0.24690865477898422},{"$f":"E18/(E$20+0.00001)","v":0.60449219340324412},"n/a"]
[null,"Lapsed repeat",{"$f":"FEPdata!B18","v":405},"n/a",{"$f":"-C19","v":-405},{"$f":"E19/(C$22+0.00001)","v":-0.16154766588931924},{"$f":"E19/(E$20+0.00001)","v":0.39550781636238103},"n/a"]
[null,"Subtotal losses",{"$f":"SUM(C16:C19)","v":1626},{"$f":"SUM(D16:D19)","v":602},{"$f":"D20-C20","v":-1024},{"$f":"E20/(C$22+0.00001)","v":-0.40845632066830345},{"$f":"E20/(E$20+0.00001)","v":1.000000009765625},"n/a"]
[]
["Total - gifts",null,{"$f":"C14+C15+C20","v":2507},{"$f":"D14+D15+D20","v":2770},{"$f":"D22-C22","v":263},{"$f":"E22/(C$22+0.00001)","v":0.10490626204664434},null,{"$f":"'Core GiG Report'!D22/D22","v":266.30902527075813}]
[null,null,null,null,null,"Overall rate of growth"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Gifts"]
[null,null,null,null,null,null,null,null,null,"New",{"$f":"G11","v":0.78632478021503671}]
[null,null,null,null,null,null,null,null,null,"Recaptured",{"$f":"G12","v":0.21367521201495562}]
[null,null,null,null,null,null,null,null,null,"Upgraded",{"$f":"G13","v":0}]
[null,null,null,null,null,null,null,null,null,"Total gains",{"$f":"G14","v":0.99999999222999236}]
[null,null,null,null,null,null,null,null,null,"Downgraded",{"$f":"G17","v":0}]
[null,null,null,null,null,null,null,null,null,"Laps new",{"$f":"G18","v":0.60449219340324412}]
[null,null,null,null,null,null,null,null,null,"Laps repeat",{"$f":"G19","v":0.39550781636238103}]
[null,null,null,null,null,null,null,null,null,"Total losses",{"$f":"G20","v":1.000000009765625}]
[]
[]
[]
[]
[]
["Definitions for Gain/Loss categories in GiG Reports:"]
["New – donors who never gave prior to year 2 (current year)"]
["Recaptured – previously lapsed donors who gave again in year 2."]
["Upgraded – donors who gave more in year 2 than in year 1 (previous year)."]
["Same – donors who gave the same amount in both years."]
["Downgraded – donors who gave less in year 2 than in year 1."]
["Lapsed new – new, first-time donors in year 1 who did not give in year 2"]
["Lapsed repeat – other lapsed donors who gave in year 1 and prior years but not in year 2"]
[]
["* Tables and figures in A Better Measure of Success article"]

{"sheet":"FEPdata","index":9,"n_rows":30,"n_cols":25,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEPdata",null,null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC","10:48:17",null,null,null,"Last row",{"$f":"TODAY()","v":"2013-12-09"},"10:48:17",null,"Step","Sub","Start Sub","End Sub","Sub time","Last cell"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,"Current Year 2",null,null,"10:09:11",null,null,null,null,14981,null,"10:49:32"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K8","v":31},"<---- =\"K\" & row",null,null,14981,null,{"$f":"O2-O1","v":"00:01:15"},null,"All","FitnessAll","05:41:28","07:37:36",{"$f":"T3-S3","v":"01:56:08"},null,"Step 3 - Data2"]
[null,null,null,"Year 2",{"$f":"StepByStep!G10","v":2012},null,null,"To -->",{"$f":"L19","v":14981},"<---- =\"L\" & row",null,null,null,null,"FEPdata",null,1,"SortData","10:41:22","10:41:22","00:00:00",null,"Amt","Gifts"]
["All donors","All",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month",null,null,null,null,null,null,null,null,null,null,2,"DateYr","10:41:22","10:43:50","00:02:28",null,"Control","Control"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L",null,null,null,null,3,"Data2","10:43:50","10:47:16","00:03:26",null,{"$f":"SUM(C30:C185050)","v":0},{"$f":"SUM(D30:D185050)","v":0}," <--- FEPdata worksheet"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count",null,null,null,4,"FirstYr","10:47:16","10:47:39","00:00:23",null,{"$f":"SUM(Data!C2:'Data'!C440264)","v":0},{"$f":"Data!E2-1","v":59740}," <--- \"Data\" worksheet"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36},null,null,null,5,"LargestYrAmt","10:47:39","10:47:56","00:00:17",null,{"$f":"W6-W7","v":0},{"$f":"X6-X7","v":-59740}," <--- needs to be zero"]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77},null,null,null,6,"FEPdataToRow","10:47:56","10:48:14","00:00:18"]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106,null,null,null,7,"CopyData2","10:48:14","10:48:17","00:00:03"]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168,null,null,null,8,"FEP5DataSets","10:48:17","10:50:46",{"$f":"T11-S11","v":"00:02:29"}]
["New","n/a","n/a",1012,133838,null,null,null,"1,000-2,499",12,418,1061,644,null,null,null,null,"Total - 1 to 8",null,null,{"$f":"SUM(U4:U11)","v":"00:09:24"}]
["Recaptured","n/a","n/a",275,54477,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",582,183332,582,307294,null,null,null,"250-499",14,2415,4953,2539]
["Same",299,54201,299,54201,null,null,"100-249","100-249",15,4954,9606,4653,null,null,null,null,"FEPdataToRpt","09:30:02","09:56:00",{"$f":"T15-S15","v":"00:25:58"},"<--old"]
["Downgraded",602,314530,602,187866,null,null,"Under 100","50-99",16,9607,12101,2495,null,null,null,null,"Ignore",null,"Delete from PSI, etc."]
["Lapsed new",619,103250,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",405,162936,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763,null,null,null,null,null,null,"Ignore"]
["Total",{"$f":"SUM(B12:B18)","v":2507},{"$f":"SUM(C12:C18)","v":818249},{"$f":"SUM(D12:D18)","v":2770},{"$f":"SUM(E12:E18)","v":737676},{"$f":"(D19-B19)/B19","v":0.10490626246509772},{"$f":"(E19-C19)/C19","v":-9.8470025627895669E-2},null,"Under 10",19,14885,14981,97,null,null,"Must run all steps in order!!",null,null,null,"Leaves 1st year data in FEP100dn, etc!!"]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951},null,null,null,null,null,null,"Generates \"FEPrptData\" worksheet - Trend analysis"]
[null,"Number","Gift$"]
["New in  year 1",905,186095,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",5910,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,6922,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",3069,594358,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,10946,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,167,45006,"  <-- Portion of Recaptured",null,null,null,null,1025,1641365,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,629,352864," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,41,14903," <-- Portion NEW monthly donors in Year2",null,null,null,null,null,"<-- deletes A31:P200000"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,null,"Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I",null,null,"L","M","N"]

{"sheet":"FEP100Dn","index":10,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEP100Dn",null,"Fundraising Effectiveness Survey - 2012",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC","15:41:59",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:50:14"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"10:50:46"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K16","v":9607},"<---- =\"K\" & row",null,null,null,null,{"$f":"O2-O1","v":"00:00:32"}]
[null,null,null,"Year 2",{"$f":"FEPdata!E4","v":2012},null,null,"To -->",{"$f":"L19","v":14981},"<---- =\"L\" & row",null,null,null,null,"FEPdata"]
["Under $100","A 100 dn",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36}]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77}]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168]
["New","n/a","n/a",684,23326,null,null,null,"1,000-2,499",12,418,1061,644]
["Recaptured","n/a","n/a",125,4465,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",99,2631,99,4756,null,null,null,"250-499",14,2415,4953,2539]
["Same",89,3540,89,3540,null,null,"100-249","100-249",15,4954,9606,4653]
["Downgraded",109,5519,109,3069,null,null,"Under 100","50-99",16,9607,12101,2495]
["Lapsed new",441,14912,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",156,5138,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763]
["Total",{"$f":"SUM(B12:B18)","v":894},{"$f":"SUM(C12:C18)","v":31740},{"$f":"SUM(D12:D18)","v":1106},{"$f":"SUM(E12:E18)","v":39156},{"$f":"(D19-B19)/B19","v":0.23713646532438479},{"$f":"(E19-C19)/C19","v":0.23364839319470698},null,"Under 10",19,14885,14981,97]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951}]
[null,"Number","Gift$"]
["New in  year 1",545,18836,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",3089,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,3773,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",2214,77232,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,1434,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,70,2651,"  <-- Portion of Recaptured",null,null,null,null,49,6906,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,10,712," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,2,144," <-- Portion NEW monthly donors in Year2"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,null,"Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I",null,null,"L","M","N"]

{"sheet":"FEP100to249","index":11,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEP100to249",null,"Fundraising Effectiveness Survey - 2012",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC",null,null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:49:51"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"10:50:14"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K15","v":4954},"<---- =\"K\" & row",null,null,null,null,{"$f":"O2-O1","v":"00:00:23"}]
[null,null,null,"Year 2",{"$f":"FEPdata!E4","v":2012},null,null,"To -->",{"$f":"L15","v":9606},"<---- =\"L\" & row",null,null,null,null,"FEPdata"]
["$100 to $249","B 100-249",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36}]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77}]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168]
["New","n/a","n/a",242,33245,null,null,null,"1,000-2,499",12,418,1061,644]
["Recaptured","n/a","n/a",101,8213,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",156,13647,156,23331,null,null,null,"250-499",14,2415,4953,2539]
["Same",133,16746,133,16746,null,null,"100-249","100-249",15,4954,9606,4653]
["Downgraded",211,31802,211,20229,null,null,"Under 100","50-99",16,9607,12101,2495]
["Lapsed new",147,19463,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",146,13272,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763]
["Total",{"$f":"SUM(B12:B18)","v":793},{"$f":"SUM(C12:C18)","v":94930},{"$f":"SUM(D12:D18)","v":843},{"$f":"SUM(E12:E18)","v":101764},{"$f":"(D19-B19)/B19","v":6.3051702395964693E-2},{"$f":"(E19-C19)/C19","v":7.1989887285368162E-2},null,"Under 10",19,14885,14981,97]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951}]
[null,"Number","Gift$"]
["New in  year 1",251,32641,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",1692,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,1934,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",702,90035,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,3026,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,66,5320,"  <-- Portion of Recaptured",null,null,null,null,362,175095,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,191,33007," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,19,3379," <-- Portion NEW monthly donors in Year2"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,null,"Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I",null,null,"L","M","N"]

{"sheet":"FEP250to999","index":12,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEP250to999",null,"Fundraising Effectiveness Survey - 2012",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC",null,null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:49:36"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"10:49:51"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K13","v":1062},"<---- =\"K\" & row",null,null,null,null,{"$f":"O2-O1","v":"00:00:15"}]
[null,null,null,"Year 2",{"$f":"FEPdata!E4","v":2012},null,null,"To -->",{"$f":"L14","v":4953},"<---- =\"L\" & row",null,null,null,null,"FEPdata"]
["$250 to $999","C 250-999",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36}]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77}]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168]
["New","n/a","n/a",79,30246,null,null,null,"1,000-2,499",12,418,1061,644]
["Recaptured","n/a","n/a",36,9102,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",261,72482,261,115251,null,null,null,"250-499",14,2415,4953,2539]
["Same",63,19118,63,19118,null,null,"100-249","100-249",15,4954,9606,4653]
["Downgraded",225,90964,225,61243,null,null,"Under 100","50-99",16,9607,12101,2495]
["Lapsed new",25,9125,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",86,19607,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763]
["Total",{"$f":"SUM(B12:B18)","v":660},{"$f":"SUM(C12:C18)","v":211296},{"$f":"SUM(D12:D18)","v":664},{"$f":"SUM(E12:E18)","v":234960},{"$f":"(D19-B19)/B19","v":6.0606060606060606E-3},{"$f":"(E19-C19)/C19","v":0.11199454793275784},null,"Under 10",19,14885,14981,97]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951}]
[null,"Number","Gift$"]
["New in  year 1",90,25140,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",904,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,983,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",109,39741,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,5108,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,19,4838,"  <-- Portion of Recaptured",null,null,null,null,519,688126,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,353,148207," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,17,7473," <-- Portion NEW monthly donors in Year2"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,null,"Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I",null,null,"L","M","N"]

{"sheet":"FEP1000to4999","index":13,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEP1000to4999",null,"Fundraising Effectiveness Survey - 2012",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC",null,null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:49:33"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"10:49:36"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K11","v":250},"<---- =\"K\" & row",null,null,null,null,{"$f":"O2-O1","v":"00:00:03"}]
[null,null,null,"Year 2",{"$f":"FEPdata!E4","v":2012},null,null,"To -->",{"$f":"L12","v":1061},"<---- =\"L\" & row",null,null,null,null,"FEPdata"]
["$1,000 to $4,999","D 1,000-4,999",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36}]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77}]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168]
["New","n/a","n/a",6,7021,null,null,null,"1,000-2,499",12,418,1061,644]
["Recaptured","n/a","n/a",10,10519,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",55,59523,55,90392,null,null,null,"250-499",14,2415,4953,2539]
["Same",13,14197,13,14197,null,null,"100-249","100-249",15,4954,9606,4653]
["Downgraded",47,68748,47,49099,null,null,"Under 100","50-99",16,9607,12101,2495]
["Lapsed new",3,3750,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",12,12819,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763]
["Total",{"$f":"SUM(B12:B18)","v":130},{"$f":"SUM(C12:C18)","v":159037},{"$f":"SUM(D12:D18)","v":131},{"$f":"SUM(E12:E18)","v":171228},{"$f":"(D19-B19)/B19","v":7.6923076923076927E-3},{"$f":"(E19-C19)/C19","v":7.6655117991410809E-2},null,"Under 10",19,14885,14981,97]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951}]
[null,"Number","Gift$"]
["New in  year 1",13,13678,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",170,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,176,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",24,35401,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,1056,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,10,10519,"  <-- Portion of Recaptured",null,null,null,null,78,370360,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,63,91696," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,3,3907," <-- Portion NEW monthly donors in Year2"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,null,"Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I",null,null,"L","M","N"]

{"sheet":"FEP5000Up","index":14,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["FEP5000Up",null,"Fundraising Effectiveness Survey - 2012",null,null,null,{"$f":"TODAY()","v":"2013-12-09"},null,"Sort Largest Year (col. G) - DESC",null,null,null,null,{"$f":"TODAY()","v":"2013-12-09"},"10:49:32"]
[{"$f":"StepByStep!$A$3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"10:49:33"]
["Growth-in-Giving is measured for Year 2:",null,null,null,null,null,null,"From -->",{"$f":"K8","v":31},"<---- =\"K\" & row",null,null,null,null,{"$f":"O2-O1","v":"00:00:01"}]
[null,null,null,"Year 2",{"$f":"FEPdata!E4","v":2012},null,null,"To -->",{"$f":"L10","v":249},"<---- =\"L\" & row",null,null,null,null,"FEPdata"]
["$5,000 and up","E 5,000 up",null,null,{"$f":"StepByStep!$G$7","v":12},"<-- Year-end month"]
["Gain(Loss) Data - Software Extract for Year 2 and Year 1 data",null,null,null,null,null,null,null,null,null,"Col K","Col L"]
[null,null,null,null,null,null,null,null,null,"Row","From","To","Count"]
[null,"Number of","Amount of","Number of","Amount of",null,null,"5,000 up","25,000 & up",8,31,66,{"$f":"L8-K8+1","v":36}]
["Gain(Loss)",{"$f":"D9-1","v":2011},{"$f":"E9-1","v":2011},{"$f":"$E4","v":2012},{"$f":"$E4","v":2012},null,null,null,"10,000-24,999",9,{"$f":"L8+1","v":67},143,{"$f":"L9-L8","v":77}]
["Category","Donors","Gifts ($)","Donors","Gifts ($)",null,null,null,"5,000-9,999",10,144,249,106]
[null,null,null,null,null,null,null,"1,000-4,999","2,500-4,999",11,250,417,168]
["New","n/a","n/a",1,40000,null,null,null,"1,000-2,499",12,418,1061,644]
["Recaptured","n/a","n/a",3,22178,null,null,"250-999","500-999",13,1062,2414,1353]
["Upgraded",11,35049,11,73564,null,null,null,"250-499",14,2415,4953,2539]
["Same",1,600,1,600,null,null,"100-249","100-249",15,4954,9606,4653]
["Downgraded",10,117497,10,54226,null,null,"Under 100","50-99",16,9607,12101,2495]
["Lapsed new",3,56000,"n/a","n/a",null,null,null,"25-49",17,12102,14121,2020]
["Lapsed repeat",5,112100,"n/a","n/a","GiG#","GiG$",null,"10-24",18,14122,14884,763]
["Total",{"$f":"SUM(B12:B18)","v":30},{"$f":"SUM(C12:C18)","v":321246},{"$f":"SUM(D12:D18)","v":26},{"$f":"SUM(E12:E18)","v":190568},{"$f":"(D19-B19)/B19","v":-0.13333333333333333},{"$f":"(E19-C19)/C19","v":-0.40678483156210504},null,"Under 10",19,14885,14981,97]
["36 hilighted data fields are retrieved from gift transaction data below",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M8:M19)","v":14951}]
[null,"Number","Gift$"]
["New in  year 1",6,95800,"  <-- i.e., last year's new donors and gift$"]
["Database EOY1",55,null,"  <-- i.e., Total number of donors on file at end of Year1 ",null,null,null,null,null,null,56,"  <-- i.e., TOTAL number of donors on file "]
["One time donors",20,351949,"  <-- i.e., Number of one-time donors and gifts",null,null,null,null,null,null,322,"  <-- Total # of gifts in Year2 (vs #donors)"]
["Recaptured lapsed 1 year",null,null,2,21678,"  <-- Portion of Recaptured",null,null,null,null,17,400878,"  <-- Total # & $ for monthly donors in database  "]
["Monthly donors in Year2",null,null,12,79242," <-- i.e., Year2 donors making 6 to 24 gifts.",null,null,null,null,0,0," <-- Portion NEW monthly donors in Year2"]
[]
[null,"[Asc]",null,"Gifts",null,"First","Largest","Monthly","Gain/Loss",null,null,"Years of","One time","Recap 1"]
["Acct","Year","AmtYr","Per year","Seq#","Year","Year","Giving","Category",null,"Dupes","Giving","Donor","Donor"]
["A ","B","C","D","E","F ","G","H","I","J","K","L","M","N"]