{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["About","Summary Projections","Board Gifts ","Foundations","Corporations","Government","Individuals","Patron Society","Benefits","Annual Campaign"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"About","index":0,"n_rows":36,"n_cols":2,"rows_kept":36}
[]
[]
[]
[]
[null,"The Fundraising System Projections Tool"]
[null,"A planning workbook for organizing your fundraising projections by revenue stream"]
[]
[null,"How to use this workbook"]
[null,"1.  Start on the Summary Projections tab to see your overall goal and current totals."]
[null,"2.  Use each category tab to enter your donors, funders, and prospects, along with target gift amounts and confidence percentages."]
[null,"3.  Return to the Summary tab — your totals update automatically as you enter data."]
[]
[null,"Revenue categories tracked"]
[null,"•  Board Gifts"]
[null,"•  Foundations"]
[null,"•  Corporations"]
[null,"•  Government"]
[null,"•  Individuals (non-board)"]
[null,"•  Patron Society (membership program)"]
[null,"•  Benefit Events"]
[null,"•  Annual Campaign"]
[null,"Adjust these categories to fit your organization. To add or remove a category, unprotect the relevant tab (Review ▸ Unprotect Sheet) before editing."]
[]
[null,"How to classify each gift"]
[null,"Received / Confirmed.  Money already in hand for this fiscal year, or written confirmation that you will receive it. For multi-year grants, include only the portion allocated to the current fiscal year."]
[null,"Expected.  Gifts you are counting on but have not yet received. Assign a confidence percentage (0–100%) to each one. Err on the side of caution — a reliable longtime supporter might be 90%, while someone who has gone quiet might be 50%. If a donor has not recently given and has not committed, move them to Prospect."]
[null,"Prospect.  Funders or donors you plan to pursue to close the gap between confirmed/expected revenue and your goal. These are not counted toward your forecast until they commit."]
[]
[null,"What the Summary tab shows"]
[null,"For each category, the Summary displays your Goal, your Received/Confirmed total, your discounted Expected total (target × confidence %), the To-Be-Identified gap, and your Prospect pipeline. The To-Be-Identified column is what you still need to raise after accounting for confirmed and expected gifts."]
[]
[null,"How this workbook is protected"]
[null,"Each tab is locked to protect the formulas. You can freely edit donor and funder names, target gift amounts, confidence percentages, and the TOTAL GOAL on each tab. Other cells are read-only."]
[null,"If you need to add or remove rows, unprotect the sheet (Review ▸ Unprotect Sheet), make your changes, then re-protect it. Adding or removing rows may require you to extend the subtotal formulas."]
[]
[null,"* All names and gift amounts in this workbook are fictitious. Any resemblance to actual individuals or entities is coincidental."]

{"sheet":"Summary Projections","index":1,"n_rows":17,"n_cols":6,"rows_kept":17}
["Summary Projections*"]
["Fiscal Year Beginning July 1, 2026"]
[]
["Revenue Stream","Goal","Received/Confirmed","Expected","To Be Identified","Prospect"]
["Board Gifts",{"$f":"'Board Gifts '!C63","v":{"v":1200000,"d":"$1,200,000"}},{"$f":"'Board Gifts '!E27","v":{"v":530500,"d":"$530,500"}},{"$f":"'Board Gifts '!E51","v":{"v":473100,"d":"$473,100"}},{"$f":"'Board Gifts '!C64","v":{"v":196400,"d":"$196,400"}},{"$f":"'Board Gifts '!C60","v":{"v":85000,"d":"$85,000"}}]
["Foundations",{"$f":"Foundations!E44","v":{"v":825000,"d":"$825,000"}},{"$f":"Foundations!E17","v":{"v":390125,"d":"$390,125"}},{"$f":"Foundations!E29","v":{"v":326125,"d":"$326,125"}},{"$f":"Foundations!E45","v":{"v":108750,"d":"$108,750"}},{"$f":"Foundations!C41","v":{"v":343500,"d":"$343,500"}}]
["Corporations",{"$f":"Corporations!E51","v":{"v":795000,"d":"$795,000"}},{"$f":"Corporations!E24","v":{"v":556000,"d":"$556,000"}},{"$f":"Corporations!E37","v":{"v":216700,"d":"$216,700"}},{"$f":"Corporations!E52","v":{"v":22300,"d":"$22,300"}},{"$f":"Corporations!C48","v":{"v":245000,"d":"$245,000"}}]
["Government",{"$f":"Government!E23","v":{"v":750000,"d":"$750,000"}},{"$f":"Government!E11","v":{"v":593000,"d":"$593,000"}},{"$f":"Government!E15","v":{"v":120000,"d":"$120,000"}},{"$f":"Government!E24","v":{"v":37000,"d":"$37,000"}},{"$f":"Government!C20","v":{"v":60000,"d":"$60,000"}}]
["Individuals",{"$f":"Individuals!E63","v":{"v":1200000,"d":"$1,200,000"}},{"$f":"Individuals!E22","v":{"v":523500,"d":"$523,500"}},{"$f":"Individuals!E49","v":{"v":369720,"d":"$369,720"}},{"$f":"Individuals!E64","v":{"v":306780,"d":"$306,780"}},{"$f":"Individuals!C60","v":{"v":367500,"d":"$367,500"}}]
["Patron Society",{"$f":"'Patron Society'!E69","v":{"v":125000,"d":"$125,000"}},{"$f":"'Patron Society'!E25","v":{"v":47500,"d":"$47,500"}},{"$f":"'Patron Society'!E55","v":{"v":52925,"d":"$52,925"}},{"$f":"'Patron Society'!E70","v":{"v":24575,"d":"$24,575"}},{"$f":"'Patron Society'!C66","v":{"v":26700,"d":"$26,700"}}]
["Benefit Events",{"$f":"Benefits!E85","v":{"v":221000,"d":"$221,000"}},{"$f":"Benefits!E14+Benefits!E47+Benefits!E79","v":{"v":102600,"d":"$102,600"}},{"$f":"Benefits!E24+Benefits!E57","v":{"v":56380,"d":"$56,380"}},{"$f":"Benefits!E86","v":{"v":62020,"d":"$62,020"}},{"$f":"Benefits!C33+Benefits!C66","v":{"v":83350,"d":"$83,350"}}]
["Annual Campaign",{"$f":"'Annual Campaign'!B8","v":{"v":85000,"d":"$85,000"}},{"$f":"'Annual Campaign'!C8","v":{"v":61073,"d":"$61,073"}},{"$f":"'Annual Campaign'!D8","v":{"v":20000,"d":"$20,000"}},{"$f":"B12-(C12+D12)","v":{"v":3927,"d":"$3,927"}}]
["Total",{"$f":"SUM(B5:B12)","v":{"v":5201000,"d":"$5,201,000"}},{"$f":"SUM(C5:C12)","v":{"v":2804298,"d":"$2,804,298"}},{"$f":"SUM(D5:D12)","v":{"v":1634950,"d":"$1,634,950"}},{"$f":"SUM(E5:E12)","v":{"v":761752,"d":"$761,752"}},{"$f":"SUM(F5:F12)","v":{"v":1211050,"d":"$1,211,050"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Board Gifts ","index":2,"n_rows":68,"n_cols":5,"rows_kept":68}
["Board Gifts"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Trustee","Target Gift","Confidence %","Revenue\nforecast"]
["Received/Confirmed"]
[null,"Sallie Field",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"$f":"C6*D6","v":{"v":50000,"d":"$50,000"}}]
[null,"Neha Lindsey",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Efe Simmonds",{"v":35000,"d":"$35,000"},{"v":1,"d":"100%"},{"v":35000,"d":"$35,000"}]
[null,"Melisa Haynes",{"v":100000,"d":"$100,000"},{"v":1,"d":"100%"},{"v":100000,"d":"$100,000"}]
[null,"Onur Holland",{"v":500,"d":"$500"},{"v":1,"d":"100%"},{"v":500,"d":"$500"}]
[null,"Amira Redman",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"$50,000"}]
[null,"Denise Whitehouse",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"$10,000"}]
[null,"Atticus Middleton",{"v":12500,"d":"$12,500"},{"v":1,"d":"100%"},{"v":12500,"d":"$12,500"}]
[null,"Ryder Myers",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"$10,000"}]
[null,"Clifford Bean",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"$5,000"}]
[null,"Maurice Lynch",{"v":7500,"d":"$7,500"},{"v":1,"d":"100%"},{"v":7500,"d":"$7,500"}]
[null,"Rosa Petersen",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"$50,000"}]
[null,"Crystal Turner",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Charly Mathews",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"$10,000"}]
[null,"Paul Jenkins",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"$50,000"}]
[null,"Brandy Felix",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"$5,000"}]
[null,"Jamil Rojas",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"$5,000"}]
[null,"Milton Mcgill",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Aroush Pike",{"v":20000,"d":"$20,000"},{"v":1,"d":"100%"},{"v":20000,"d":"$20,000"}]
[null,"Rohaan Thomas",{"v":35000,"d":"$35,000"},{"v":1,"d":"100%"},{"v":35000,"d":"$35,000"}]
[]
[null,"Subtotal",{"$f":"SUM(C6:C26)","v":{"v":530500,"d":"$530,500"}},null,{"$f":"SUM(E6:E26)","v":{"v":530500,"d":"$530,500"}}]
[]
["Expected"]
[null,"Sallie Field",{"v":25000,"d":"$25,000"},{"v":0.05,"d":"5%"},{"$f":"C30*D30","v":{"v":1250,"d":"$1,250"}}]
[null,"Neha Lindsey",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Efe Simmonds",{"v":15000,"d":"$15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"$15,000"}]
[null,"Melisa Haynes",{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
[null,"Onur Holland",{"v":4500,"d":"$4,500"},{"v":0.5,"d":"50%"},{"v":2250,"d":"$2,250"}]
[null,"Amira Redman",{"v":45000,"d":"$45,000"},{"v":0.9,"d":"90%"},{"v":40500,"d":"$40,500"}]
[null,"Denise Whitehouse",{"v":40000,"d":"$40,000"},{"v":1,"d":"100%"},{"v":40000,"d":"$40,000"}]
[null,"Atticus Middleton",{"v":37500,"d":"$37,500"},{"v":0.9,"d":"90%"},{"v":33750,"d":"$33,750"}]
[null,"Ryder Myers",{"v":40000,"d":"$40,000"},{"v":0.9,"d":"90%"},{"v":36000,"d":"$36,000"}]
[null,"Clifford Bean",{"v":50000,"d":"$50,000"},{"v":0.75,"d":"75%"},{"v":37500,"d":"$37,500"}]
[null,"Maurice Lynch",{"v":42500,"d":"$42,500"},{"v":1,"d":"100%"},{"v":42500,"d":"$42,500"}]
[null,"Rosa Petersen",{"v":100000,"d":"$100,000"},null,{"v":0,"d":"$0"}]
[null,"Crystal Turner",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Charly Mathews",{"v":40000,"d":"$40,000"},{"v":1,"d":"100%"},{"v":40000,"d":"$40,000"}]
[null,"Paul Jenkins",{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
[null,"Brandy Felix",{"v":45000,"d":"$45,000"},{"v":0.9,"d":"90%"},{"v":40500,"d":"$40,500"}]
[null,"Jamil Rojas",{"v":45000,"d":"$45,000"},{"v":0.9,"d":"90%"},{"v":40500,"d":"$40,500"}]
[null,"Milton Mcgill",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"$25,000"}]
[null,"Aroush Pike",{"v":30000,"d":"$30,000"},{"v":0.9,"d":"90%"},{"v":27000,"d":"$27,000"}]
[null,"Rohaan Thomas",{"v":1500,"d":"$1,500"},{"v":0.9,"d":"90%"},{"v":1350,"d":"$1,350"}]
[]
[null,"Subtotal",{"$f":"SUM(C30:C50)","v":{"v":636000,"d":"$636,000"}},null,{"$f":"SUM(E30:E50)","v":{"v":473100,"d":"$473,100"}}]
[]
["PROSPECTS"]
[null,"Efe Simmonds",{"v":10000,"d":"$10,000"},"N.A","N.A."]
[null,"Denise Whitehouse",{"v":25000,"d":"$25,000"},"N.A","N.A."]
[null,"Maurice Lynch",{"v":5000,"d":"$5,000"},"N.A","N.A."]
[null,"Crystal Turner",{"v":10000,"d":"$10,000"},"N.A","N.A."]
[null,"Charly Mathews",{"v":10000,"d":"$10,000"},"N.A","N.A."]
[null,"Milton McGill",{"v":25000,"d":"$25,000"},"N.A","N.A."]
[null,"Subtotal",{"$f":"SUM(C54:C59)","v":{"v":85000,"d":"$85,000"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",null,{"$f":"SUM(E27+E51)","v":{"v":1003600,"d":"$1,003,600"}},null," "]
["TOTAL GOAL",null,{"v":1200000,"d":"$1,200,000"}]
["REMAINING TO BE IDENTIFIED",null,{"$f":"C63-C62","v":{"v":196400,"d":"$196,400"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Foundations","index":3,"n_rows":49,"n_cols":5,"rows_kept":49}
["Foundations"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Funder/Prospect","Target Gift","Confidence %","Revenue\nforecast"]
["Received/Confirmed"]
[null,"Abacus Foundation",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"$f":"C6*D6","v":{"v":25000,"d":"$25,000"}}]
[null,"Amphora Trust",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Alberti Fund",{"v":10000,"d":"10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Aurora Philanthropic Trust",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"v":2500,"d":"2,500"}]
[null,"Chirico Foundation",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Botticelli Trust",{"v":150000,"d":"150,000"},{"v":1,"d":"100%"},{"v":150000,"d":"150,000"}]
[null,"Van Eyck Foundation",{"v":20000,"d":"20,000"},{"v":1,"d":"100%"},{"v":20000,"d":"20,000"}]
[null,"Garnier Foundation",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Hamilton Family Foundation",{"v":15000,"d":"15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"The Hopper Fund",{"v":40000,"d":"40,000"},{"v":1,"d":"100%"},{"v":40000,"d":"40,000"}]
[null,"Lorrenzo Foundation",{"v":27625,"d":"27,625"},{"v":1,"d":"100%"},{"v":27625,"d":"27,625"}]
["Subtotal",null,{"$f":"SUM(C6:C16)","v":{"v":390125,"d":"$390,125"}},null,{"$f":"SUM(E6:E16)","v":{"v":390125,"d":"$390,125"}}]
[]
["Expected"]
[null,"La Tour Foundation",{"v":50000,"d":"$50,000"},{"v":0.9,"d":"90%"},{"$f":"C20*D20","v":{"v":45000,"d":"$45,000"}}]
[null,"Lippi Trust",{"v":100000,"d":"100,000"},{"v":0.75,"d":"75%"},{"v":75000,"d":"$75,000"}]
[null,"The Judd Endowment",{"v":50000,"d":"50,000"},{"v":0.5,"d":"50%"},{"v":25000,"d":"$25,000"}]
[null,"Thomas Foundation",{"v":25000,"d":"25,000"},{"v":0.5,"d":"50%"},{"v":12500,"d":"$12,500"}]
[null,"Villard Trust",{"v":10000,"d":"10,000"},{"v":0.75,"d":"75%"},{"v":7500,"d":"$7,500"}]
[null,"The Stuart Family Foundation",{"v":150000,"d":"150,000"},{"v":0.95,"d":"95%"},{"v":142500,"d":"$142,500"}]
[null,"The Robert Smithson Estate",{"v":4500,"d":"4,500"},{"v":0.25,"d":"25%"},{"v":1125,"d":"$1,125"}]
[null,"Ed Steichen Family Trust",{"v":10000,"d":"10,000"},{"v":0.5,"d":"50%"},{"v":5000,"d":"$5,000"}]
[null,"Picasso Charitable Foundation",{"v":25000,"d":"25,000"},{"v":0.5,"d":"50%"},{"v":12500,"d":"$12,500"}]
["Subtotal",null,{"$f":"SUM(C20:C28)","v":{"v":424500,"d":"$424,500"}},null,{"$f":"SUM(E20:E28)","v":{"v":326125,"d":"$326,125"}}]
[]
["Prospects"]
[null,"Hartwig Foundation",{"v":5000,"d":"$5,000"},"N.A.","N.A."]
[null,"Alexander Trust",{"v":50000,"d":"$50,000"},"N.A.","N.A."]
[null,"Vita Philanthropic Trust",{"v":25000,"d":"$25,000"},"N.A.","N.A."]
[null,"Macy Family Foundation",{"v":1000,"d":"$1,000"},"N.A.","N.A."]
[null,"Bloomlander Foundation",{"v":125000,"d":"$125,000"},"N.A.","N.A."]
[null,"Lichtenberg Fund",{"v":50000,"d":"$50,000"},"N.A.","N.A."]
[null,"Johnson Family Foundation",{"v":10000,"d":"$10,000"},"N.A.","N.A."]
[null,"Saperstein Charitable Trust",{"v":2500,"d":"$2,500"},"N.A.","N.A."]
[null,"Lawrence Foundation",{"v":75000,"d":"$75,000"},"N.A.","N.A."]
["Subtotal",null,{"$f":"SUM(C32:C40)","v":{"v":343500,"d":"$343,500"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"SUM(E17+E29)","v":{"v":716250,"d":"$716,250"}}]
["TOTAL GOAL",{"$nulls":3},{"v":825000,"d":"$825,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E44-E43","v":{"v":108750,"d":"$108,750"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Corporations","index":4,"n_rows":56,"n_cols":5,"rows_kept":56}
["Corporations"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Funder/Prospect","Target Gift","Confidence %","Revenue\nforecast"]
["Received/Confirmed"]
[null,"Pope Corporation",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"$f":"C6*D6","v":{"v":25000,"d":"$25,000"}}]
[null,"Thomson Corporation",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Wesley Inc.",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Gray Industries",{"v":125000,"d":"$125,000"},{"v":1,"d":"100%"},{"v":125000,"d":"125,000"}]
[null,"Collins Manufacturing Corp",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Akenside Trust Co.",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Smart Corporation",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Cowper, MacPherson and Chatterton, LLP",{"v":15000,"d":"$15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"Crabbe Retail Stores",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"The Blake Restaurant Group",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Burns, Bloomfield",{"v":15000,"d":"$15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"Wordsworth Advertising",{"v":35000,"d":"$35,000"},{"v":1,"d":"100%"},{"v":35000,"d":"35,000"}]
[null,"Scott Foods",{"v":1000,"d":"$1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Coleridge Packaging",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Southey and Landor",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"The Thomas Moore Group",{"v":50000,"d":"$50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Elliot Shipping",{"v":10000,"d":"$10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"The Gordon Fund",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
["Subtotal",null,{"$f":"SUM(C6:C23)","v":{"v":556000,"d":"$556,000"}},null,{"$f":"SUM(E6:E23)","v":{"v":556000,"d":"$556,000"}}]
["Expected"]
[null,"Thomas, Love & Peacock",{"v":50000,"d":"$50,000"},{"v":0.9,"d":"90%"},{"$f":"C26*D26","v":{"v":45000,"d":"$45,000"}}]
[null,"Shelley Development Group",{"v":75000,"d":"$75,000"},{"v":0.9,"d":"90%"},{"v":67500,"d":"$67,500"}]
[null,"Clare Sporting Goods",{"v":25000,"d":"$25,000"},{"v":0.75,"d":"75%"},{"v":18750,"d":"$18,750"}]
[null,"Keats Lighting",{"v":10000,"d":"$10,000"},{"v":0.5,"d":"50%"},{"v":5000,"d":"$5,000"}]
[null,"Darley Trucking",{"v":50000,"d":"$50,000"},{"v":0.75,"d":"75%"},{"v":37500,"d":"$37,500"}]
[null,"Hartley Solutions",{"v":15000,"d":"$15,000"},{"v":0.9,"d":"90%"},{"v":13500,"d":"$13,500"}]
[null,"Hood Furniture",{"v":10000,"d":"$10,000"},{"v":0.5,"d":"50%"},{"v":5000,"d":"$5,000"}]
[null,"Mangan Exterminating",{"v":5000,"d":"$5,000"},{"v":0.75,"d":"75%"},{"v":3750,"d":"$3,750"}]
[null,"Beddoes Plumbing Supply",{"v":3000,"d":"$3,000"},{"v":0.9,"d":"90%"},{"v":2700,"d":"$2,700"}]
[null,"Tennyson Resort Wear",{"v":10000,"d":"$10,000"},{"v":0.9,"d":"90%"},{"v":9000,"d":"$9,000"}]
[null,"Browning Hotes",{"v":10000,"d":"$10,000"},{"v":0.9,"d":"90%"},{"v":9000,"d":"$9,000"}]
["Subtotal",null,{"$f":"SUM(C26:C36)","v":{"v":263000,"d":"$263,000"}},null,{"$f":"SUM(E26:E36)","v":{"v":216700,"d":"$216,700"}}]
["Prospect"]
[null,"Souther Trust",{"v":10000,"d":"$10,000"},"N.A.","N.A."]
[null,"Validation National",{"v":25000,"d":"$25,000"},"N.A.","N.A."]
[null,"Kugelman Financial",{"v":50000,"d":"$50,000"},"N.A.","N.A."]
[null,"National Industries",{"v":25000,"d":"$25,000"},"N.A.","N.A."]
[null,"Acme Construction",{"v":10000,"d":"$10,000"},"N.A.","N.A."]
[null,"Apex Pharmaceutical",{"v":100000,"d":"$100,000"},"N.A.","N.A."]
[null,"Saperstein Knoxley",{"v":10000,"d":"$10,000"},"N.A.","N.A."]
[null,"Food Fair",{"v":5000,"d":"$5,000"},"N.A.","N.A."]
[null,"Bank One",{"v":10000,"d":"$10,000"},"N.A.","N.A."]
["Subtotal",null,{"$f":"SUM(C39:C47)","v":{"v":245000,"d":"$245,000"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"SUM(E24+E37)","v":{"v":772700,"d":"$772,700"}}]
["TOTAL GOAL",{"$nulls":3},{"v":795000,"d":"$795,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E51-E50","v":{"v":22300,"d":"$22,300"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Government","index":5,"n_rows":28,"n_cols":5,"rows_kept":28}
["Government"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Funder/Prospect","Target Gift","Confidence %","Revenue\nforecast"]
["Confirmed/Continuing"]
[null,"Municipal Services Fund",{"v":150000,"d":"$150,000"},{"v":1,"d":"100%"},{"$f":"C6*D6","v":{"v":150000,"d":"$150,000"}}]
[null,"Department of Agriculture ",{"v":230000,"d":"$230,000"},{"v":1,"d":"100%"},{"$f":"C7*D7","v":{"v":230000,"d":"230,000"}}]
[null,"Corporation for National and Community Svcs",{"v":63000,"d":"$63,000"},{"v":1,"d":"100%"},{"$f":"C8*D8","v":{"v":63000,"d":"63,000"}}]
[null,"New York State Council on the Arts",{"v":75000,"d":"$75,000"},{"v":1,"d":"100%"},{"$f":"C9*D9","v":{"v":75000,"d":"75,000"}}]
[null,"National Endowment for the Humanities",{"v":75000,"d":"$75,000"},{"v":1,"d":"100%"},{"$f":"C10*D10","v":{"v":75000,"d":"75,000"}}]
["Subtotal",null,{"$f":"SUM(C6:C10)","v":{"v":593000,"d":"$593,000"}},null,{"$f":"SUM(E6:E10)","v":{"v":593000,"d":"$593,000"}}]
["Expected"]
[null,"U.S. Dept of Education",{"v":50000,"d":"$50,000"},{"v":0.9,"d":"90%"},{"$f":"C13*D13","v":{"v":45000,"d":"$45,000"}}]
[null,"State Dept of Rehabilitation",{"v":150000,"d":"$150,000"},{"v":0.5,"d":"50%"},{"$f":"C14*D14","v":{"v":75000,"d":"75,000"}}]
["Subtotal",null,{"$f":"SUM(C13:C14)","v":{"v":200000,"d":"$200,000"}},null,{"$f":"SUM(E13:E14)","v":{"v":120000,"d":"$120,000"}}]
[]
["Prospect"]
[null,"Congressional earmark",{"v":35000,"d":"$35,000"}]
[null,"Governor's earmark",{"v":25000,"d":"$25,000"}]
["Subtotal",null,{"$f":"SUM(C18:C19)","v":{"v":60000,"d":"$60,000"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"E11+E15","v":{"v":713000,"d":"$713,000"}}]
["TOTAL GOAL",{"$nulls":3},{"v":750000,"d":"$750,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E23-E22","v":{"v":37000,"d":"$37,000"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Individuals","index":6,"n_rows":68,"n_cols":5,"rows_kept":68}
["Individuals"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Funder/Prospect","Target Gift","Confidence %","Revenue\nforecast"]
["Received/Confirmed"]
[null,"John Johnson",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"$f":"C6*D6","v":{"v":25000,"d":"$25,000"}}]
[null,"Edmund Bridges",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Seth Mendez",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Victor Barber",{"v":125000,"d":"125,000"},{"v":1,"d":"100%"},{"v":125000,"d":"125,000"}]
[null,"Marta Bowen",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Anna Gardner",{"v":10000,"d":"10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Cassandra Cross",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Antonio Fox",{"v":15000,"d":"15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"Tyrone Barker",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
[null,"Troy Dunn",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Paula McDonald",{"v":15000,"d":"15,000"},{"v":0.5,"d":"50%"},{"v":7500,"d":"7,500"}]
[null,"Nicholas Hoffman",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Ben Cohen",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Leah Russell",{"v":10000,"d":"10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Louisa Ford",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"Clark Sanders",{"v":50000,"d":"50,000"},{"v":1,"d":"100%"},{"v":50000,"d":"50,000"}]
["Subtotal",null,{"$f":"SUM(C6:C21)","v":{"v":531000,"d":"$531,000"}},null,{"$f":"SUM(E6:E21)","v":{"v":523500,"d":"$523,500"}}]
["Expected"]
[null,"Marjorie Norman",{"v":10000,"d":"$10,000"},{"v":0.9,"d":"90%"},{"$f":"C24*D24","v":{"v":9000,"d":"$9,000"}}]
[null,"Tabitha Thornton",{"v":5000,"d":"5,000"},{"v":0.9,"d":"90%"},{"v":4500,"d":"4,500"}]
[null,"Laurence Washington",{"v":25000,"d":"25,000"},{"v":0.75,"d":"75%"},{"v":18750,"d":"18,750"}]
[null,"Monica King",{"v":16500,"d":"16,500"},{"v":0.5,"d":"50%"},{"v":8250,"d":"8,250"}]
[null,"Arturo Munoz",{"v":1800,"d":"1,800"},{"v":0.75,"d":"75%"},{"v":1350,"d":"1,350"}]
[null,"Angela Jenkins",{"v":1800,"d":"1,800"},{"v":0.9,"d":"90%"},{"v":1620,"d":"1,620"}]
[null,"Celia Wolfe",{"v":2500,"d":"2,500"},{"v":0.5,"d":"50%"},{"v":1250,"d":"1,250"}]
[null,"Ramona Dixon",{"v":50000,"d":"50,000"},{"v":0.9,"d":"90%"},{"v":45000,"d":"45,000"}]
[null,"Franklin Thompson",{"v":25000,"d":"25,000"},{"v":0.9,"d":"90%"},{"v":22500,"d":"22,500"}]
[null,"Terry Moran",{"v":10000,"d":"10,000"},{"v":0.75,"d":"75%"},{"v":7500,"d":"7,500"}]
[null,"Jimmy Stokes",{"v":5000,"d":"5,000"},{"v":0.5,"d":"50%"},{"v":2500,"d":"2,500"}]
[null,"Malcolm Torres",{"v":10000,"d":"10,000"},{"v":0.75,"d":"75%"},{"v":7500,"d":"7,500"}]
[null,"Wanda Hall",{"v":100000,"d":"100,000"},{"v":0.9,"d":"90%"},{"v":90000,"d":"90,000"}]
[null,"Frank Daniel",{"v":5000,"d":"5,000"},{"v":0.5,"d":"50%"},{"v":2500,"d":"2,500"}]
[null,"Warren Higgins",{"v":5000,"d":"5,000"},{"v":0.9,"d":"90%"},{"v":4500,"d":"4,500"}]
[null,"Genevieve Rivera",{"v":7500,"d":"7,500"},{"v":0.9,"d":"90%"},{"v":6750,"d":"6,750"}]
[null,"Leticia Chambers",{"v":1000,"d":"1,000"},{"v":0.75,"d":"75%"},750]
[null,"Marta Harper",{"v":1500,"d":"1,500"},{"v":0.5,"d":"50%"},750]
[null,"Jeanne Banks",{"v":50000,"d":"50,000"},{"v":0.75,"d":"75%"},{"v":37500,"d":"37,500"}]
[null,"Dolores Allison",{"v":75000,"d":"75,000"},{"v":0.9,"d":"90%"},{"v":67500,"d":"67,500"}]
[null,"Hector Boyd",{"v":5000,"d":"5,000"},{"v":0.5,"d":"50%"},{"v":2500,"d":"2,500"}]
[null,"Lois Wilkins",{"v":10000,"d":"10,000"},{"v":0.5,"d":"50%"},{"v":5000,"d":"5,000"}]
[null,"Glen Benson",{"v":5000,"d":"5,000"},{"v":0.75,"d":"75%"},{"v":3750,"d":"3,750"}]
[null,"Susie Ballard",{"v":15000,"d":"15,000"},{"v":0.9,"d":"90%"},{"v":13500,"d":"13,500"}]
[null,"Janice Hubbard",{"v":10000,"d":"10,000"},{"v":0.5,"d":"50%"},{"v":5000,"d":"5,000"}]
["Subtotal",null,{"$f":"SUM(C24:C48)","v":{"v":452600,"d":"$452,600"}},null,{"$f":"SUM(E24:E48)","v":{"v":369720,"d":"$369,720"}}]
["Prospect"]
[null,"Alan Ginsburg",{"v":25000,"d":"$25,000"},"N.A.","N.A."]
[null,"Greg Corso",{"v":250000,"d":"250,000"},"N.A.","N.A."]
[null,"Jack Kay",{"v":10000,"d":"10,000"},"N.A.","N.A."]
[null,"Neal Cassady",{"v":50000,"d":"50,000"},"N.A.","N.A."]
[null,"Joyce Johnson",{"v":5000,"d":"5,000"},"N.A.","N.A."]
[null,"Diana Prima",{"v":2500,"d":"2,500"},"N.A.","N.A."]
[null,"Pete Orlov",{"v":10000,"d":"10,000"},"N.A.","N.A."]
[null,"Bill Burrows",{"v":5000,"d":"5,000"},"N.A.","N.A."]
[null,"Carolyn Cassady",{"v":10000,"d":"10,000"},"N.A.","N.A."]
["Subtotal",null,{"$f":"SUM(C51:C59)","v":{"v":367500,"d":"$367,500"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"SUM(E22+E49)","v":{"v":893220,"d":"$893,220"}}]
["TOTAL GOAL",{"$nulls":3},{"v":1200000,"d":"$1,200,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E63-E62","v":{"v":306780,"d":"$306,780"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Patron Society","index":7,"n_rows":74,"n_cols":5,"rows_kept":74}
["Patron Society"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category","Funder/Prospect","Target Gift","Confidence %","Revenue\nforecast"]
["Received/Confirmed"]
["Platinum Circle"]
[null,"John Johnson",{"v":5000,"d":"$5,000"},{"v":1,"d":"100%"},{"$f":"C7*D7","v":{"v":5000,"d":"$5,000"}}]
[null,"Natalie Consuelo",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Avram Kadish",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Victor Barber",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Marta Bowen",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
[null,"Mary Gardner",{"v":5000,"d":"5,000"},{"v":1,"d":"100%"},{"v":5000,"d":"5,000"}]
["Gold Circle"]
[null,"Jim Jefferson",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"$f":"C14*D14","v":{"v":2500,"d":"$2,500"}}]
[null,"Antonio Fox",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"$f":"C15*D15","v":{"v":2500,"d":"2,500"}}]
[null,"Taylor Caldwwell",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"$f":"C16*D16","v":{"v":2500,"d":"2,500"}}]
[null,"Troy Dunn",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"$f":"C17*D17","v":{"v":2500,"d":"2,500"}}]
[null,"Paulette Humphries",{"v":2500,"d":"2,500"},{"v":1,"d":"100%"},{"$f":"C18*D18","v":{"v":2500,"d":"2,500"}}]
["Silver Circle"]
[null,"Noh-si Flynn",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"$f":"C20*D20","v":{"v":1000,"d":"$1,000"}}]
[null,"Blazes Boyland",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"$f":"C21*D21","v":{"v":1000,"d":"1,000"}}]
[null,"Leopold Bloom",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"$f":"C22*D22","v":{"v":1000,"d":"1,000"}}]
[null,"Lydia Dedalus",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"$f":"C23*D23","v":{"v":1000,"d":"1,000"}}]
[null,"Clark Sanders",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"$f":"C24*D24","v":{"v":1000,"d":"1,000"}}]
["Subtotal",null,{"$f":"SUM(C7:C24)","v":{"v":47500,"d":"$47,500"}},null,{"$f":"SUM(E7:E24)","v":{"v":47500,"d":"$47,500"}}]
["Expected"]
["Platinum Circle"]
[null,"Marjorie Norman",{"v":5000,"d":"$5,000"},{"v":0.9,"d":"90%"},{"$f":"C28*D28","v":{"v":4500,"d":"$4,500"}}]
[null,"Tabitha Thornton",{"v":5000,"d":"5,000"},{"v":0.9,"d":"90%"},{"v":4500,"d":"4,500"}]
[null,"Laurence Washington",{"v":5000,"d":"5,000"},{"v":0.75,"d":"75%"},{"v":3750,"d":"3,750"}]
[null,"Monica King",{"v":5000,"d":"5,000"},{"v":0.5,"d":"50%"},{"v":2500,"d":"2,500"}]
[null,"Arturo Munoz",{"v":5000,"d":"5,000"},{"v":0.75,"d":"75%"},{"v":3750,"d":"3,750"}]
[null,"Angela Jenkins",{"v":5000,"d":"5,000"},{"v":0.9,"d":"90%"},{"v":4500,"d":"4,500"}]
[null,"Celia Wolfe",{"v":5000,"d":"5,000"},{"v":0.5,"d":"50%"},{"v":2500,"d":"2,500"}]
[null,"Ramona Dixon",{"v":5000,"d":"5,000"},{"v":0.9,"d":"90%"},{"v":4500,"d":"4,500"}]
["Gold Circle"]
[null,"Franklin Thompson",{"v":2500,"d":"2,500"},{"v":0.9,"d":"90%"},{"$f":"C37*D37","v":{"v":2250,"d":"$2,250"}}]
[null,"Terry Moran",{"v":2500,"d":"2,500"},{"v":0.75,"d":"75%"},{"v":1875,"d":"1,875"}]
[null,"Jimmy Stokes",{"v":2500,"d":"2,500"},{"v":0.5,"d":"50%"},{"v":1250,"d":"1,250"}]
[null,"Malcolm Torres",{"v":2500,"d":"2,500"},{"v":0.75,"d":"75%"},{"v":1875,"d":"1,875"}]
[null,"Wanda Hall",{"v":2500,"d":"2,500"},{"v":0.9,"d":"90%"},{"v":2250,"d":"2,250"}]
[null,"Frank Daniel",{"v":2500,"d":"2,500"},{"v":0.5,"d":"50%"},{"v":1250,"d":"1,250"}]
[null,"Warren Higgins",{"v":2500,"d":"2,500"},{"v":0.9,"d":"90%"},{"v":2250,"d":"2,250"}]
[null,"Genevieve Rivera",{"v":2500,"d":"2,500"},{"v":0.9,"d":"90%"},{"v":2250,"d":"2,250"}]
[null,"Leticia Chambers",{"v":2500,"d":"2,500"},{"v":0.75,"d":"75%"},{"v":1875,"d":"1,875"}]
["Silver Circle"]
[null,"Marta Harper",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},{"$f":"C47*D47","v":{"v":500,"d":"$500"}}]
[null,"Jeanne Banks",{"v":1000,"d":"1,000"},{"v":0.75,"d":"75%"},750]
[null,"Delores Allison",{"v":1000,"d":"1,000"},{"v":0.9,"d":"90%"},900]
[null,"Hector Boyd",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},500]
[null,"Lois Wilkins",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},500]
[null,"Glen Benson",{"v":1000,"d":"1,000"},{"v":0.75,"d":"75%"},750]
[null,"Susie Ballard",{"v":1000,"d":"1,000"},{"v":0.9,"d":"90%"},900]
[null,"Janice Hubbard",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},500]
["Subtotal",null,{"$f":"SUM(C28:C54)","v":{"v":70500,"d":"$70,500"}},null,{"$f":"SUM(E28:E54)","v":{"v":52925,"d":"$52,925"}}]
["Prospect"]
[null,"Alan Ginsburg",{"v":700,"d":"$700"},"N.A.","N.A."]
[null,"Greg Corso",{"v":2500,"d":"2,500"},"N.A.","N.A."]
[null,"Jack Kay",{"v":2500,"d":"2,500"},"N.A.","N.A."]
[null,"Neal Cassady",{"v":5000,"d":"5,000"},"N.A.","N.A."]
[null,"Joyce Johnson",{"v":1000,"d":"1,000"},"N.A.","N.A."]
[null,"Diana Prima",{"v":2500,"d":"2,500"},"N.A.","N.A."]
[null,"Pete Orlov",{"v":5000,"d":"5,000"},"N.A.","N.A."]
[null,"Bill Burrows",{"v":5000,"d":"5,000"},"N.A.","N.A."]
[null,"Carolyn Cassady",{"v":2500,"d":"2,500"},"N.A.","N.A."]
["Subtotal",null,{"$f":"SUM(C57:C65)","v":{"v":26700,"d":"$26,700"}}]
[]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"SUM(E25+E55)","v":{"v":100425,"d":"$100,425"}}]
["TOTAL GOAL",{"$nulls":3},{"v":125000,"d":"$125,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E69-E68","v":{"v":24575,"d":"$24,575"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Benefits","index":8,"n_rows":90,"n_cols":5,"rows_kept":90}
["Benefits"]
["Blue cells are calculated for you, and they generally should not be altered. "]
[]
["Category",null,"Target Gift","Confidence %","Revenue\nforecast"]
["Spring Dance"]
["Received/Confirmed"]
[null,"Claudio Monteverdi",{"v":25000,"d":"$25,000"},{"v":1,"d":"100%"},{"$f":"C7*D7","v":{"v":25000,"d":"$25,000"}}]
[null,"Felix Mendelssohn",{"v":15000,"d":"15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"Rossini, Donizetti, and Bellini LP",{"v":10000,"d":"10,000"},{"v":1,"d":"100%"},{"v":10000,"d":"10,000"}]
[null,"Verdi Industries",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Wagner Foundation",500,{"v":1,"d":"100%"},500]
[null,"Joseph Bach",{"v":25000,"d":"25,000"},{"v":1,"d":"100%"},{"v":25000,"d":"25,000"}]
[null,"George Handel",{"v":15000,"d":"15,000"},{"v":1,"d":"100%"},{"v":15000,"d":"15,000"}]
[null,"Subtotal",{"$f":"SUM(C7:C13)","v":{"v":91500,"d":"$91,500"}},null,{"$f":"SUM(E7:E13)","v":{"v":91500,"d":"$91,500"}}]
["Expected"]
[null,"Hugo Wolf, Esq",{"v":25000,"d":"$25,000"},{"v":0.9,"d":"90%"},{"$f":"C16*D16","v":{"v":22500,"d":"$22,500"}}]
[null,"Strauss, Offenbach & Sullivan",{"v":1500,"d":"1,500"},{"v":0.75,"d":"75%"},{"v":1125,"d":"1,125"}]
[null,"Gounod and Sons",{"v":15000,"d":"15,000"},{"v":0.9,"d":"90%"},{"v":13500,"d":"13,500"}]
[null,"The Tschaikovsky Company",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},500]
[null,"Frank Faure",{"v":1000,"d":"1,000"},{"v":0.9,"d":"90%"},900]
[null,"Puccini Doggy Day Care",500,{"v":0.9,"d":"90%"},450]
[null,"Gluck Enterprises",{"v":2000,"d":"2,000"},{"v":0.9,"d":"90%"},{"v":1800,"d":"1,800"}]
[null,"Haydn, Mozart LLP",{"v":15000,"d":"$15,000"},{"v":0.75,"d":"75%"},{"v":11250,"d":"11,250"}]
[null,"Subtotal",{"$f":"SUM(C16:C23)","v":{"v":61000,"d":"$61,000"}},null,{"$f":"SUM(E16:E23)","v":{"v":52025,"d":"$52,025"}}]
["Prospect"]
[null,"Bruckner Trucking",{"v":25000,"d":"$25,000"}]
[null,"Mahler & Mahler",{"v":10000,"d":"10,000"}]
[null,"Claude Debussy ",{"v":1000,"d":"1,000"}]
[null,"Franz Schubert",500]
[null,"Hector Berlioz",{"v":25000,"d":"25,000"}]
[null,"Robert Schumann",{"v":15000,"d":"15,000"}]
[null,"Frederic Chopin",{"v":1000,"d":"1,000"}]
[null,"Subtotal",{"$f":"SUM(C26:C32)","v":{"v":77500,"d":"$77,500"}}]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"E14+E24","v":{"v":143525,"d":"$143,525"}}]
["TOTAL GOAL",{"$nulls":3},{"v":200000,"d":"$200,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E35-E34","v":{"v":56475,"d":"$56,475"}}]
[]
["Summer Picnic"]
["Received/Confirmed"]
[null,"Claudio Monteverdi",{"v":1000,"d":"$1,000"},{"v":1,"d":"100%"},{"$f":"C40*D40","v":{"v":1000,"d":"$1,000"}}]
[null,"Felix Mendelssohn",500,{"v":1,"d":"100%"},500]
[null,"Rossini, Donizetti, and Bellini LP",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Verdi Industries",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Wagner Foundation",500,{"v":1,"d":"100%"},500]
[null,"Joseph Bach",250,{"v":1,"d":"100%"},250]
[null,"George Handel",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Subtotal",{"$f":"SUM(C40:C46)","v":{"v":5250,"d":"$5,250"}},null,{"$f":"SUM(E40:E46)","v":{"v":5250,"d":"$5,250"}}]
["Expected"]
[null,"Hugo Wolf, Esq",{"v":1000,"d":"$1,000"},{"v":0.9,"d":"90%"},{"$f":"C49*D49","v":{"v":900,"d":"$900"}}]
[null,"Strauss, Offenbach & Sullivan",{"v":1500,"d":"1,500"},{"v":0.75,"d":"75%"},{"v":1125,"d":"1,125"}]
[null,"Gounod and Sons",100,{"v":0.9,"d":"90%"},90]
[null,"The Tschaikovsky Company",{"v":1000,"d":"1,000"},{"v":0.5,"d":"50%"},500]
[null,"Frank Faure",500,{"v":0.9,"d":"90%"},450]
[null,"Puccini Doggy Day Care",100,{"v":0.9,"d":"90%"},90]
[null,"Gluck Enterprises",500,{"v":0.9,"d":"90%"},450]
[null,"Haydn, Mozart LLP",{"v":1000,"d":"1,000"},{"v":0.75,"d":"75%"},750]
[null,"Subtotal",{"$f":"SUM(C49:C56)","v":{"v":5700,"d":"$5,700"}},null,{"$f":"SUM(E49:E56)","v":{"v":4355,"d":"$4,355"}}]
["Prospect"]
[null,"Bruckner Trucking",{"v":2500,"d":"$2,500"}]
[null,"Mahler & Mahler",{"v":1000,"d":"1,000"}]
[null,"Claude Debussy ",500]
[null,"Franz Schubert",100]
[null,"Hector Berlioz",250]
[null,"Robert Schumann",{"v":1000,"d":"1,000"}]
[null,"Frederic Chopin",500]
[null,"Subtotal",{"$f":"SUM(C59:C65)","v":{"v":5850,"d":"5,850"}}]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"E47+E57","v":{"v":9605,"d":"$9,605"}}]
["TOTAL GOAL",{"$nulls":3},{"v":15000,"d":"$15,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E68-E67","v":{"v":5395,"d":"$5,395"}}]
[]
["Fall Golf Outing"]
[null,"Bruckner Trucking",{"v":2500,"d":"$2,500"},{"v":1,"d":"100%"},{"$f":"C72*D72","v":{"v":2500,"d":"$2,500"}}]
[null,"Mahler & Mahler",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Claude Debussy ",500,{"v":1,"d":"100%"},500]
[null,"Franz Schubert",100,{"v":1,"d":"100%"},100]
[null,"Hector Berlioz",250,{"v":1,"d":"100%"},250]
[null,"Robert Schumann",{"v":1000,"d":"1,000"},{"v":1,"d":"100%"},{"v":1000,"d":"1,000"}]
[null,"Frederic Chopin",500,{"v":1,"d":"100%"},500]
["TOTAL CONFIRMED AND EXPECTED",null,{"$f":"SUM(C72:C78)","v":{"v":5850,"d":"$5,850"}},null,{"$f":"SUM(E72:E78)","v":{"v":5850,"d":"$5,850"}}]
["TOTAL GOAL",{"$nulls":3},{"v":6000,"d":"$6,000"}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E80-E79","v":{"v":150,"d":"$150"}}]
[]
["GRAND TOTAL"]
["TOTAL CONFIRMED AND EXPECTED",{"$nulls":3},{"$f":"E34+E67+E79","v":{"v":158980,"d":"$158,980"}}]
["TOTAL GOAL",{"$nulls":3},{"$f":"E35+E68+E80","v":{"v":221000,"d":"$221,000"}}]
["REMAINING TO BE IDENTIFIED",{"$nulls":3},{"$f":"E85-E84","v":{"v":62020,"d":"$62,020"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]

{"sheet":"Annual Campaign","index":9,"n_rows":12,"n_cols":5,"rows_kept":12}
["Annual Campaign"]
[]
["Category","Revenue Goal","Actuals","Still Expected","Adjusted Forecast"]
["Summer Appeal",{"v":45000,"d":"$45,000"},{"v":37500,"d":"$37,500"},{"v":5000,"d":"$5,000"},{"$f":"C4+D4","v":{"v":42500,"d":"$42,500"}}]
["Fall Mail Appeal",{"v":25000,"d":"$25,000"},{"v":23573,"d":"$23,573"},0,{"$f":"C5+D5","v":{"v":23573,"d":"$23,573"}}]
["Giving Tuesday Email",{"v":5000,"d":"$5,000"},0,{"v":5000,"d":"$5,000"},{"$f":"C6+D6","v":{"v":5000,"d":"$5,000"}}]
["End of Year Email",{"v":10000,"d":"$10,000"},0,{"v":10000,"d":"$10,000"},{"$f":"C7+D7","v":{"v":10000,"d":"$10,000"}}]
["Total",{"$f":"SUM(B4:B7)","v":{"v":85000,"d":"$85,000"}},{"$f":"SUM(C4:C7)","v":{"v":61073,"d":"$61,073"}},{"$f":"SUM(D4:D7)","v":{"v":20000,"d":"$20,000"}},{"$f":"SUM(E4:E7)","v":{"v":81073,"d":"$81,073"}}]
[]
[]
["© The Fundraising System"]
["www.thefundraisingsystem.com"]