{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["1) Instructions","2) Input Assumptions","3) Personnel","4) Non-Personnel","5) Secured Funding","6) Summary Charts","7) Summary Graphs & Discussion"],"not_rendered":{"charts":9,"images":4,"macros":1,"external_links":2,"defined_names":22,"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":"1) Instructions","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[35,0,35,16383],[1,0,1,12],[0,0,0,12],[18,0,18,12],[20,0,20,12],[33,0,33,12],[16,0,16,12],[3,0,3,12],[5,4,13,4],[5,5,14,5]]}
["Community-Based Organization and Health Care Partnership: What Does It Cost?"]
["Estimating the Total Cost of Partnership"]
[]
["As partnerships between healthcare and community-based organizations develop, launch, grow, and evolve, understanding cost structure throughout a partnership's lifecycle is essential to making informed decisions, planning for the future, and ensuring a sustaining funding model. This tool is intended to help your partnership estimate the total cost of partnering for up to three years. Understanding what it takes financially to partner can help you and your partner(s) stay aligned on goals, prioritize decisions, communicate with external stakeholders, and advocate for funding that covers the total cost of what it takes to achieve outcomes."]
[]
[null,null,null,null,"Considerations for Estimating Total Cost of Partnership\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Who should use the tool?"]
["This tool is designed for use by partnerships between one or more healthcare organizations and one or more community-based organizations planning for or currently engaged in a partnership, and can be used by partnerships involving up to five organizations. We recommend that staff from each organization who are or will be deeply engaged in the partnership and have relevant budgetary, program, and strategic knowledge complete the tool. \n\nTo capture a comprehensive view of partnership cost, the tool is designed to be completed collectively, with input from representatives from each partnering organization. However, an organization may also complete the tool on its own to gain a better understanding of its own costs of participating in the partnership.\n"]
["What are the goals of the tool?"]
["Calculating cost can be a daunting and complex process, but one that is critical to informed and strategic decision-making. This tool provides a simplified framework to help your partnership estimate total cost of partnering in up to three years and understand the current surplus or gap between total cost and secured funding. The tool provides a view of costs through a variety of lenses, including personnel versus non-personnel costs, one-time versus ongoing costs, cash versus in-kind costs, unit cost, and the share of total cost incurred by each partnering organization. Through the process of collecting information on the partnership's costs as a whole, along with data about each partnering organization, the exercise is intended to align partners around what it takes financially to achieve collective goals. In planning, the tool can provide valuable information about the costs to be considered in building a sustaining funding model. \n\nBecause each partnership is different, you may wish to supplement data in this tool with additional information and analysis when developing budgets, projections, and funding proposals."]
["How do I complete the tool?"]
["This tool contains several worksheets to help you identify partnership assumptions, estimate personnel and non-personnel costs, and consolidate secured funding sources. Each worksheet contains detailed guidance and considerations for collecting and inputting data. After completing each worksheet, the tool will synthesize all data to provide your partnership with a series of summary charts and graphs. \n\nBefore you begin, it may be helpful for you and your partners to gather relevant data such as budgets, staff lists, timecard data, and indirect cost rate information.\n\nThroughout the tool, data can be entered only in cells containing BLUE text. Cells with BLACK text contain formulas and cannot be edited.\n\nThe tool includes the following worksheets:"]
["2) Input Assumptions","A worksheet to enter assumptions about partnering organizations, indirect cost rate, fringe rate, wage growth rate, funding sources, and units of service"]
[]
["3) Personnel","A worksheet to enter personnel-related costs of partnership, including salary costs, fringe information, and payments to consultants and/or contractors"]
[]
["4) Non-Personnel","A worksheet to enter non-personnel costs of partnership, including space, systems, supplies, and other supports"]
[]
["5) Secured Funding","A worksheet to enter current secured funding that supports partnership costs"]
[]
["6) Summary Charts","A series of charts that summarize tool data to calculate total cost of partnership and funding surplus/gap (no data entry on this tab)"]
[]
["7) Summary Graphs & Discussion","A dashboard of tool data, including summary graphs and related discussion questions (no data entry on this tab)"]
[]
["Advancing  Community-Based Organization and Health Care Partnerships to Address Social Determinants of Health\nHealth care and community-based organizations (CBOs) across the country are increasingly working together to better address the root causes of poor health among low-income and vulnerable populations. To assist these efforts, there is a need to identify the financial, operational, and strategic considerations necessary to make these partnerships a win-win for all parties: consumers, the communities being served, health care providers, and CBOs. Through support from Kaiser Permanente Community Health, the Center for Health Care Strategies and Nonprofit Finance Fund collaborated to identify new strategies for advancing effective CBO-health care partnerships, building on work done under the Partnership for Healthy Outcomes project funded by the Robert Wood Johnson Foundation. This tool is part of a series highlighting and supporting diverse partnership models between CBOs and healthcare organizations. \n\nTo learn more, visit www.nff.org or www.chcs.org/cbo-collaborate. \n"]
[]
["Made possible through support from Kaiser Permanente Community Health."]

{"sheet":"2) Input Assumptions","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[1,0,2,7],[0,0,0,7],[3,0,3,2],[4,5,23,7],[3,4,3,7],[30,4,34,7],[23,2,27,2],[4,2,9,2],[12,0,12,2],[22,0,22,2],[30,0,30,2],[28,5,28,7],[26,4,26,7],[13,2,19,2],[31,2,34,2]]}
["Input Assumptions"]
["Estimating total cost of partnership requires key assumptions about each partnering organization. Before completing the worksheets in subsequent tabs, use this worksheet to enter assumptions. Enter data only in cells containing BLUE text below. "]
[]
["Participating Organizations",null,null,null,"Funding Source"]
["Organization Name","Type","Partnership requires at least two organizations, but may include more. Use this table to list up to five partnering organization names and types. To identify partnering organizations, consider those organizations that dedicate meaningful time to partnership activities.",null,{"$f":"A6","v":"Organization Name 1"},"Partnership costs are supported by a variety of funding sources. Some funding may be contributed directly from partnering organizations, whereas other funding is secured from external sources. Use this table to list partnership funding sources. Examples of common funding sources include: foundation grants, corporate sponsorships, individual donations, local government, state government, federal government, health system contracts, insurance reimbursement, Medicaid/Medicare funds, and settlement funds."]
["Organization Name 1","Enter organization type",null,null,{"$f":"A7","v":"Organization Name 2"}]
["Organization Name 2","Enter organization type",null,null,"Organization Name 3",null,null,null,null,null,null," "]
["Organization Name 3","Enter organization type",null,null,"Organization Name 4"]
["Organization Name 4","Enter organization type",null,null,"Organization Name 5"]
["Organization Name 5","Enter organization type",null,null,"Funding Source 1"]
[null,null,null,null,"Funding Source 2",null,null,null," "]
[null,null,null,null,"Funding Source 3"]
["Indirect Cost Rate",null,null,null,"Funding Source 4"]
[{"$f":"A6","v":"Organization Name 1"},0,"Indirect costs are those that can't be directly attributed to the partnership and are incurred for shared organizational needs. These costs would still be incurred even if the partnership did not exist. Examples include organization-wide systems, human resources, IT, and office space. Use this table to list each organization's estimated indirect cost rate. For additional guidance on calculating indirect cost rate, see these resources: https://www.councilofnonprofits.org/tools-resources/own-your-own-costs; https://www.dol.gov/oasam/boc/DCD-2-CFR-Guid.pdf",null,"Funding Source 5"]
[{"$f":"A7","v":"Organization Name 2"},0,null,null,"Funding Source 6"]
[{"$f":"A8","v":"Organization Name 3"},0,null,null,"Funding Source 7"]
[{"$f":"A9","v":"Organization Name 4"},0,null,null,"Funding Source 8",null,null,null,null,null,null," "]
[{"$f":"A10","v":"Organization Name 5"},0,null,null,"Funding Source 9"]
[null,null,null,null,"Funding Source 10"]
[null,null,null,null,"Funding Source 11"]
[null,null,null,null,"Funding Source 12",null,null,null,null,null,null,null," "]
[null,null,null,null,"Funding Source 13"]
["Fringe Rate",null,null,null,"Funding Source 14"]
[{"$f":"A6","v":"Organization Name 1"},0,"Fringe rate refers to an organization's employee benefits and payroll taxes as a percentage of total salary costs. Examples of employee benefits that might be included in a fringe rate calculation are health insurance, life insurance, workers' compensation, and retirement contributions. Use this table to list each organization's estimated fringe rate.",null,"Funding Source 15"]
[{"$f":"A7","v":"Organization Name 2"},0]
[{"$f":"A8","v":"Organization Name 3"},0]
[{"$f":"A9","v":"Organization Name 4"},0,null,null,"Units of Service"]
[{"$f":"A10","v":"Organization Name 5"},0,null,null,null,"Year 1","Year 2","Year 3"]
[null,null,null,null,"Unit of Service","Unit"]
[null,null,null,null,"Estimated Quantity",0,0,0]
["Wage Growth Rate",null,null,null,"Units of service refers to beneficiaries served or outcomes delivered by the partnership and should be linked to your partnership's unique goals. Examples include clients served or services delivered. Use this table to define and estimate units of service for your partnership in each of up to 3 years."]
["Wage Growth Rate",0,"Wage growth rate refers to the average percentage by which wages are expected to grow each year. Enter an assumption of average annual wage growth of all individuals involved in the partnership."]
[]
[]
[]
[]
[]
[]
[]
[]
[" "]
[]
["Yes/No"]
["Yes"]
["No"]
[]
["Cash/In-Kind"]
["Cash"]
["In-Kind"]
[]
["One-Time/Ongoing"]
["One-Time"]
["Ongoing"]

{"sheet":"3) Personnel","index":2,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,13,8,13],[3,1,4,12],[1,0,2,12],[0,0,0,12],[3,0,4,0],[5,0,38,0],[7,4,8,4],[7,3,8,3],[7,2,8,2],[7,1,8,1],[8,7,8,8],[8,9,8,10],[8,11,8,12],[7,7,7,12],[7,5,8,5],[7,6,8,6],[5,1,6,1],[5,2,6,2],[5,4,6,4],[5,3,6,3],[5,7,6,12],[5,6,6,6],[5,5,6,5]]}
["Personnel Costs"]
["Partnerships are driven by people, which often represent a significant cost. This worksheet will help you identify personnel-related costs of partnership, including wage and benefit costs at each partnering organization and payments to consultants and/or contractors. Data from this worksheet, along with information from the Input Assumptions tab, will guide a calculation of your partnership's personnel costs in the Summary Tab. Enter data only in cells containing BLUE text below. "]
[]
["Estimating Personnel Costs","Worksheet"]
[]
["\n1) Who is involved in partnership activities? \nList the title in Column B and organization in Column C of each person spending time on partnership activities in each of up to three years. Consider individuals who are involved in direct service delivery, as well as those involved in administrative or strategic partnership functions. \n\nIn addition to those directly employed by each partnering organization, include consultants or contractors the partnership utilizes in each of up to three years. List the organization funding this consultant/contractor in Column C.\n\nFor example, in addition to case managers and nurses, your partnership may involve an administrative assistant who spends time coordinating schedules, executive directors at each organization who meet monthly to discuss strategic direction, and a development consultant who spends time fundraising for the partnership. Each of these individuals should be listed in the worksheet.\n \n2) What is each individual's base salary or payment? Does this individual receive fringe benefits?\nEnter each individual's annual base salary or payment amount in Column D.\n\nFor part-time or hourly employees, enter real annual salary, rather than a full-time equivalent salary.\n\nIn Column E, select whether or not (Yes/No) this person receives fringe benefits. For more information about fringe benefits, see the Input Assumptions tab.\n\n3) Is this individual needed by the partnership on a one-time or ongoing basis?\nIn Column F, indicate whether each individual listed supports the partnership on a one-time or ongoing basis. Select \"one-time\" for individuals only needed by the partnership as it is developing or changing and \"ongoing\" for individuals needed by the partnership each year on a regular basis.\n\n4) Is this individual's salary or payment a cash (funded) or in-kind cost?\nFor each individual listed, indicate in Column G whether this person's wages or payment are a cash (funded) cost or an in-kind contribution to the partnership, donated by the partnering organization listed in Column C.\n\n5) What portion of each individual's time is spent on partnership activities over the course of three years? \nFor each individual listed, estimate average time spent on partnership activities as a percentage of total annual time in each of up to 3 years in Columns H, J, and L. If the individual is needed on a one-time basis, only estimate time allocation in the year(s) that person is working on partnership activities. If the individual is needed by the partnership on an ongoing basis, estimate average time spent each year, taking into consideration evolving partnership needs.\n\nFor example, as your partnership is in its first year and making decisions about future strategy, your executive director may need to spend more time on partnership activities than in subsequent years. This individual's time allocated to the partnership would likely be higher in Year 1 than in Years 2 and 3.","Enter employee, consultant, or contractor title","From the drop-down menu, select organization that employs this individual; for consultants or contractors, select organization that pays this individual","Enter individual's Year 1 base salary or payment","From the drop-down menu, select whether or not this individual receives fringe benefits","From the drop-down menu, select whether this individual is needed on a one-time or ongoing basis","From the drop-down menu, select whether this item is a cash (funded) or in-kind cost","Estimate average time spent on partnership activities as a percentage of total annual time, in each of up to 3 years",null,null,null,null,null,"Notes"]
[]
[null,"Title","Organization (dropdown)","Base Salary or Payment","Fringe (dropdown)","One-Time or Ongoing (dropdown)","Cash or In-Kind (dropdown)","Time Allocation %"]
[null,null,null,null,null,null,null,"Year 1",null,"Year 2",null,"Year 3"]
[null,"Title 1",null,0,null,null,null,0,{"$f":"D10*H10","v":0},0,{"$f":"D10*J10*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D10*L10*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 2",null,0,null,null,null,0,{"$f":"D11*H11","v":0},0,{"$f":"D11*J11*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D11*L11*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 3",null,0,null,null,null,0,0,0,{"$f":"D12*J12*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D12*L12*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 4",null,0,null,null,null,0,0,0,{"$f":"D13*J13*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D13*L13*(1+'2) Input Assumptions'!$B$32)^2","v":0}," "]
[null,"Title 5",null,0,null,null,null,0,0,0,{"$f":"D14*J14*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D14*L14*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 6",null,0,null,null,null,0,0,0,{"$f":"D15*J15*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D15*L15*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 7",null,0,null,null,null,0,0,0,{"$f":"D16*J16*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D16*L16*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 8",null,0,null,null,null,0,{"$f":"D17*H17","v":0},0,{"$f":"D17*J17*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D17*L17*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 9",null,0,null,null,null,0,0,0,{"$f":"D18*J18*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D18*L18*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 10",null,0,null,null,null,0,0,0,{"$f":"D19*J19*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D19*L19*(1+'2) Input Assumptions'!$B$32)^2","v":0}," "]
[null,"Title 11",null,0,null,null,null,0,0,0,{"$f":"D20*J20*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D20*L20*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 12",null,0,null,null,null,0,0,0,{"$f":"D21*J21*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D21*L21*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 13",null,0,null,null,null,0,0,0,{"$f":"D22*J22*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D22*L22*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 14",null,0,null,null,null,0,0,0,{"$f":"D23*J23*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D23*L23*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 15",null,0,null,null,null,0,0,0,{"$f":"D24*J24*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D24*L24*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 16",null,0,null,null,null,0,0,0,{"$f":"D25*J25*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D25*L25*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 17",null,0,null,null,null,0,0,0,{"$f":"D26*J26*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D26*L26*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 18",null,0,null,null,null,0,0,0,{"$f":"D27*J27*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D27*L27*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 19",null,0,null,null,null,0,0,0,{"$f":"D28*J28*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D28*L28*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 20",null,0,null,null,null,0,0,0,{"$f":"D29*J29*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D29*L29*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 21",null,0,null,null,null,0,0,0,{"$f":"D30*J30*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D30*L30*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 22",null,0,null,null,null,0,0,0,{"$f":"D31*J31*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D31*L31*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 23",null,0,null,null,null,0,0,0,{"$f":"D32*J32*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D32*L32*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 24",null,0,null,null,null,0,0,0,{"$f":"D33*J33*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D33*L33*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 25",null,0,null,null,null,0,0,0,{"$f":"D34*J34*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D34*L34*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 26",null,0,null,null,null,0,0,0,{"$f":"D35*J35*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D35*L35*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 27",null,0,null,null,null,0,{"$f":"D36*H36","v":0},0,{"$f":"D36*J36*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D36*L36*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 28",null,0,null,null,null,0,0,0,{"$f":"D37*J37*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D37*L37*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 29",null,0,null,null,null,0,0,0,{"$f":"D38*J38*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D38*L38*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[null,"Title 30",null,0,null,null,null,0,0,0,{"$f":"D39*J39*(1+'2) Input Assumptions'!$B$32)","v":0},0,{"$f":"D39*L39*(1+'2) Input Assumptions'!$B$32)^2","v":0}]
[]
[]
[]
[]
[]
[" "]

{"sheet":"4) Non-Personnel","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[5,8,7,8],[0,0,0,7],[1,0,2,7],[3,0,4,0],[3,1,4,7],[5,0,37,0],[6,1,7,1],[6,2,7,2],[5,5,6,7],[6,3,7,3],[6,4,7,4]]}
["Non-Personnel Costs"]
["In addition to people, partnerships require space, systems, supplies, and other supports. This worksheet will help you identify non-personnel costs directly tied to your partnership. Data from this worksheet, along with information from the Input Assumptions tab, will guide a calculation of your partnership's non-personnel costs in the Summary Tab. Enter data only in cells containing BLUE text below. "]
[]
["Estimating Non-Personnel Costs","Worksheet"]
[]
["\n1) Other than personnel, what costs are directly attributed to the partnership?\nTo determine which costs are directly tied to the partnership, ask yourself: \"If the partnership did not exist, would this cost item go away?\" If the answer is \"yes,\" that item should be listed in this worksheet in Column B, along with the organization that incurs the cost in Column C. If the answer is \"no,\" that cost is likely a shared organizational cost. Rather than listing it in this worksheet, it will be captured through each organization's indirect cost rate listed in the Input Assumptions tab. \n\nFor example, your organization rents office space for all of its staff, as well as a meeting room for services delivered through the partnership. If the partnership did not exist, your organization would still need office space, but not the extra meeting room. In this example, only the meeting room is directly attributed to the partnership and would be listed on this worksheet.\n\nWhile specific cost items are unique to each partnership, common costs are listed below:\n\nOccupancy costs: rent, utilities, mortgage payments, depreciation, equipment rental, maintenance, property insurance, real estate taxes, security\nData & Technology costs: software, hardware, licenses, IT support, feasibility studies, evaluation expenses\nSupport costs: travel, training, telephone, supplies, printing, meeting expenses, conferences, board expenses, education & outreach, legal fees, subgrants, membership dues, office expenses, postage, production, advertising, recruitment, registration, shipping, subscriptions\n\n2) Is this cost item needed by the partnership one-time or on an ongoing basis?\nFor each cost item listed, indicate in Column D whether it is needed on a one-time or ongoing basis. Select \"one-time\" for cost items only needed by the partnership as it is developing or changing and \"ongoing\" for items needed by the partnership each year on a regular basis.\n\n3) Is this a cash (funded) or in-kind cost?\nFor each cost item listed, indicate in Column E whether this item is a cash (funded) cost or an in-kind contribution to the partnership, donated by the partnering organization listed in Column C.\n\n4) What is the cost amount in each of up to three years?\nFor each item listed, estimate cost in each of up to 3 years in Columns F, G, and H. If the item is a one-time cost, only list an amount in the year(s) the cost is incurred. If the cost item is ongoing, estimate the amount incurred each year, taking into consideration factors such as inflation and evolving partnership needs. \n\nFor example, as your partnership is launching, you may need to purchase a software system. This would be considered a one-time cost because you only need to make this purchase once, and the amount would be listed only in Year 1. However, your partnership may also need annual licenses to operate this system. Because license costs are incurred each year, this is an ongoing cost item, and the licensing fee amount would be listed in Years 1, 2, and 3.","Enter non-personnel cost item","From the drop-down menu, select organization that incurs this cost","From the drop-down menu, select whether this item is incurred on a one-time or ongoing basis","From the drop-down menu, select whether this item is a cash (funded) or in-kind cost","Estimate annual cost in each of up to 3 years; consider factors such as inflation and evolving partnership needs in determining yearly cost",null,null," Notes"]
[null,"Cost Item","Organization (dropdown)","One-Time or Ongoing (dropdown)","Cash or In-Kind (dropdown)"]
[null,null,null,null,null,"Year 1","Year 2","Year 3"]
[null,"Cost Item 1",null,null,null,0,0,0," "]
[null,"Cost Item 2",null,null,null,0,0,0]
[null,"Cost Item 3",null,null,null,0,0,0]
[null,"Cost Item 4",null,null,null,0,0,0,null,null,null," "]
[null,"Cost Item 5",null,null,null,0,0,0," "]
[null,"Cost Item 6",null,null,null,0,0,0]
[null,"Cost Item 7",null,null,null,0,0,0]
[null,"Cost Item 8",null,null,null,0,0,0]
[null,"Cost Item 9",null,null,null,0,0,0]
[null,"Cost Item 10",null,null,null,0,0,0]
[null,"Cost Item 11",null,null,null,0,0,0]
[null,"Cost Item 12",null,null,null,0,0,0]
[null,"Cost Item 13",null,null,null,0,0,0]
[null,"Cost Item 14",null,null,null,0,0,0]
[null,"Cost Item 15",null,null,null,0,0,0]
[null,"Cost Item 16",null,null,null,0,0,0]
[null,"Cost Item 17",null,null,null,0,0,0]
[null,"Cost Item 18",null,null,null,0,0,0]
[null,"Cost Item 19",null,null,null,0,0,0]
[null,"Cost Item 20",null,null,null,0,0,0]
[null,"Cost Item 21",null,null,null,0,0,0]
[null,"Cost Item 22",null,null,null,0,0,0]
[null,"Cost Item 23",null,null,null,0,0,0]
[null,"Cost Item 24",null,null,null,0,0,0]
[null,"Cost Item 25",null,null,null,0,0,0]
[null,"Cost Item 26",null,null,null,0,0,0]
[null,"Cost Item 27",null,null,null,0,0,0]
[null,"Cost Item 28",null,null,null,0,0,0]
[null,"Cost Item 29",null,null,null,0,0,0]
[null,"Cost Item 30",null,null,null,0,0,0]
[]
[]
[]
[]
[]
[]
[null,"   ",null,null,null,null,null,null," "]

{"sheet":"5) Secured Funding","index":4,"n_rows":33,"n_cols":8,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,2,32,3],[5,6,7,6],[3,0,4,0],[0,0,0,5],[1,0,2,5],[6,2,7,2],[3,1,4,5],[5,3,6,5],[6,1,7,1],[5,0,27,0]]}
["Secured Partnership Funding"]
["Partnerships rely on a variety of funding sources to cover their costs. This worksheet is intended to consolidate secured funding that supports partnership costs. Data from this worksheet will guide a calculation of the partnership's confirmed funding and funding surplus/gap in the Summary Tab. Enter data only in cells containing BLUE text below."]
[null,null,null,null,null,null," "]
["Estimating Partnership Funding","Worksheet"]
[]
["\n1) What funding sources have been secured to support the partnership?\nSelect secured partnership funding source in Column B. The funding source drop-down can be updated in the Input Assumptions tab. Include only funding sources that have been confirmed and not those that are speculative or planned.\n\nAdd any relevant notes in Column C, such as information about the specific funder or restrictions tied to this funding.\n\n2) For each source, input confirmed amount of funding in each of up to 3 years.\nList funding amount in Columns D, E, and F. If the funding source is one-time or episodic in nature, list amount only in the year(s) for which the funding is intended. For funding sources that provide ongoing revenue, list amount confirmed in each year. \n\nFor example, as your partnership is launching, you may receive a two-year grant to support development. For this funding source, amounts would be listed in Years 1 and 2. You may also receive annual funding through a state contract. For this funding source, amounts would be listed in Years 1, 2, and 3.\n\n3) Check that total secured funding approximately matches total cash (funded) costs.\nAfter entering all secured funding, check whether total secured funding in Row 30 approximately matches total cash partnership costs in Row 32.\n\nIf the two totals differ significantly, check that you have correctly entered all secured funding and that all costs on the personnel and non-personnel tabs have been input and appropriately categorized as cash or in-kind.","From the drop-down menu, select funding source","Enter relevant notes about this funding source","Estimate secured funding amount in each of up to 3 years",null,null,"Notes"]
[null,"Funding Source (dropdown)","Funding Source Notes"]
[null,null,null,"Year 1","Year 2","Year 3"]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0," "]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0," "]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0," "," "]
[null,null,null,0,0,0," "]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[null,null,null,0,0,0]
[]
[null,null,"Total Secured Funding",{"$f":"SUM(D9:D28)","v":0},{"$f":"SUM(E9:E28)","v":0},{"$f":"SUM(F9:F28)","v":0}]
[null,null,null,null,null,null," "]
[null,null,"Total Cash Costs",{"$f":"'6) Summary Charts'!D34","v":0},{"$f":"'6) Summary Charts'!G34","v":0},{"$f":"'6) Summary Charts'!J34","v":0}]
[null,null,"(includes direct and indirect costs)"]

{"sheet":"6) Summary Charts","index":5,"n_rows":78,"n_cols":24,"rows_kept":78,"cut":false,"hidden":false,"merged":[[71,15,71,22],[72,15,77,15],[57,15,57,22],[51,15,56,15],[58,15,63,15],[64,15,64,22],[65,15,70,15],[1,23,2,25],[44,15,49,15],[50,15,50,22],[43,15,43,16],[27,15,32,15],[34,15,39,15],[43,17,43,18],[43,19,43,20],[43,21,43,22],[5,17,5,18],[5,19,5,20],[5,21,5,22],[6,15,11,15],[13,15,18,15],[12,15,12,22],[19,15,19,22],[38,2,39,2],[38,3,38,5],[38,6,38,8],[38,9,38,11],[15,2,16,2],[15,3,15,4],[15,5,15,6],[15,7,15,8],[26,2,27,2],[26,3,26,5],[26,6,26,8],[26,15,26,22],[20,15,25,15],[33,15,33,22],[1,0,1,12],[5,3,5,5],[5,6,5,8],[5,9,5,11],[5,2,6,2],[26,9,26,11],[3,15,3,16]]}
[]
["Partnership Summary Charts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click (+) to see additional details related to summary chart calculations "]
[]
[null,null,"Total Cost of Partnership \n",null,null,null,null,null,null,null,null,null,null,null,null,"Cost Summary Details\n"]
[null,null,"Personnel and Non-Personnel Costs ",null,null,null,null,null,null,null,null,null,null,null,null,"One-time vs Ongoing Costs "]
[null,null,"Total Cost\n(includes direct and indirect costs)","Year 1",null,null,"Year 2 ",null,null,"Year 3",null,null,null,null,null,null,null,"Year 1",null,"Year 2 ",null,"Year 3 "]
[null,null,null,"Personnel","Non-Personnel","Total Cost","Personnel","Non-Personnel","Total Cost","Personnel","Non-Personnel","Total Cost",null,null,null,{"$f":"C41","v":"Organization Name 1"},null,"One-Time","Ongoing","One-Time","Ongoing","One-Time","Ongoing"]
[null,null,{"$f":"'2) Input Assumptions'!A6","v":"Organization Name 1"},{"$f":"(D18+E18)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A6,'4) Non-Personnel'!$F$9:$F$38)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUM(D8:E8)","v":0},{"$f":"(F18+G18)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A6,'4) Non-Personnel'!$G$9:$G$38)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"(SUM(G8:H8))","v":0},{"$f":"(H18+I18)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A6,'4) Non-Personnel'!$H$9:$H$38)*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"(SUM(J8:K8))","v":0},null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A7","v":"Organization Name 2"},{"$f":"(D19+E19)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A7,'4) Non-Personnel'!$F$9:$F$38)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUM(D9:E9)","v":0},{"$f":"(F19+G19)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A7,'4) Non-Personnel'!$G$9:$G$38)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"(SUM(G9:H9))","v":0},{"$f":"(H19+I19)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A7,'4) Non-Personnel'!$H$9:$H$38)*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"(SUM(J9:K9))","v":0},null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\"))","v":0},{"$f":"(('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\")))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$41&\"*\"))","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A8","v":"Organization Name 3"},{"$f":"(D20+E20)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A8,'4) Non-Personnel'!$F$9:$F$38)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"SUM(D10:E10)","v":0},{"$f":"(F20+G20)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A8,'4) Non-Personnel'!$G$9:$G$38)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"(SUM(G10:H10))","v":0},{"$f":"(H20+I20)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A8,'4) Non-Personnel'!$H$9:$H$38)*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"(SUM(J10:K10))","v":0},null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$41&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A9","v":"Organization Name 4"},{"$f":"(D21+E21)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A9,'4) Non-Personnel'!$F$9:$F$38)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"SUM(D11:E11)","v":0},{"$f":"(F21+G21)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A9,'4) Non-Personnel'!$G$9:$G$38)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"(SUM(G11:H11))","v":0},{"$f":"(H21+I21)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A9,'4) Non-Personnel'!$H$9:$H$38)*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"(SUM(J11:K11))","v":0},null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A10","v":"Organization Name 5"},{"$f":"(D22+E22)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A10,'4) Non-Personnel'!$F$9:$F$38)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"SUM(D12:E12)","v":0},{"$f":"(F22+G22)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A10,'4) Non-Personnel'!$G$9:$G$38)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"(SUM(G12:H12))","v":0},{"$f":"(H22+I22)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"SUMIF('4) Non-Personnel'!$C$9:$C$38,'2) Input Assumptions'!A10,'4) Non-Personnel'!$H$9:$H$38)*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"(SUM(J12:K12))","v":0},null,null,null,null,"Total",{"$f":"SUM(R8:R10)*(1+R11)","v":0},{"$f":"SUM(S8:S10)*(1+S11)","v":0},0,0,0,0]
[null,null,"Total Cost ",{"$f":"SUM(D8:D12)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C42","v":"Organization Name 2"},null,"One-Time","Ongoing","One-Time","Ongoing","One-Time","Ongoing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0}]
[null,null,"Personnel Cost \n(direct costs only)","Year 1 ",null,"Year 2 ",null,"Year 3 ",null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\"))","v":0},{"$f":"(('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\"))","v":0},{"$f":"'2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$42&\"*\")","v":0}]
[null,null,null,"Wages ","Fringe","Wages","Fringe","Wages ","Fringe",null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$42&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A6","v":"Organization Name 1"},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A6,'3) Personnel'!$I$10:$I$39)","v":0},{"$f":"'2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C18&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A6,'3) Personnel'!$K$10:$K$39)","v":0},{"$f":"'2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C18&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A6,'3) Personnel'!$M$10:$M$39)","v":0},{"$f":"'2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C18&\"*\")","v":0}," ",null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A7","v":"Organization Name 2"},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A7,'3) Personnel'!$I$10:$I$39)","v":0},{"$f":"'2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C19&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A7,'3) Personnel'!$K$10:$K$39)","v":0},{"$f":"'2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C19&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A7,'3) Personnel'!$M$10:$M$39)","v":0},{"$f":"'2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C19&\"*\")","v":0},null,null,null,null,null,null,null,"Total",{"$f":"SUM(R15:R17)*(1+R18)","v":0},{"$f":"SUM(S15:S17)*(1+S18)","v":0},{"$f":"SUM(T15:T17)*(1+T18)","v":0},{"$f":"SUM(U15:U17)*(1+U18)","v":0},{"$f":"SUM(V15:V17)*(1+V18)","v":0},{"$f":"SUM(W15:W17)*(1+W18)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A8","v":"Organization Name 3"},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A8,'3) Personnel'!$I$10:$I$39)","v":0},{"$f":"'2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C20&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A8,'3) Personnel'!$K$10:$K$39)","v":0},{"$f":"'2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C20&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A8,'3) Personnel'!$M$10:$M$39)","v":0},{"$f":"'2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C20&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A9","v":"Organization Name 4"},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A9,'3) Personnel'!$I$10:$I$39)","v":0},{"$f":"'2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C21&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A9,'3) Personnel'!$K$10:$K$39)","v":0},{"$f":"'2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C21&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A9,'3) Personnel'!$M$10:$M$39)","v":0},{"$f":"'2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C21&\"*\")","v":0},null,null,null,null,null,null,{"$f":"C43","v":"Organization Name 3"},null,"One-Time","Ongoing","One-Time","Ongoing","One-Time","Ongoing"]
[null,null,{"$f":"'2) Input Assumptions'!A10","v":"Organization Name 5"},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A10,'3) Personnel'!$I$10:$I$39)","v":0},{"$f":"'2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C22&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A10,'3) Personnel'!$K$10:$K$39)","v":0},{"$f":"'2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C22&\"*\")","v":0},{"$f":"SUMIF('3) Personnel'!$C$10:$C$39,'2) Input Assumptions'!A10,'3) Personnel'!$M$10:$M$39)","v":0},{"$f":"'2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39, '3) Personnel'!$E$10:$E$39, \"yes\", '3) Personnel'!$C$10:$C$39, \"*\"&C22&\"*\")","v":0},null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")","v":0}]
[null,null,"Total",{"$f":"SUM(D18:D22)","v":0},{"$f":"SUM(E18:E22)","v":0},0,0,0,0,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\"))","v":0},{"$f":"(('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\")))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$43&\"*\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0},{"$f":"+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0}]
[null,null,"Cash and In-Kind Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R22:R24)*(1+R25)","v":0},{"$f":"SUM(S22:S24)*(1+S25)","v":0},{"$f":"SUM(T22:T24)*(1+T25)","v":0},{"$f":"SUM(U22:U24)*(1+U25)","v":0},{"$f":"SUM(V22:V24)*(1+V25)","v":0},{"$f":"SUM(W22:W24)*(1+W25)","v":0}]
[null,null,"Total Cost\n(includes direct and indirect costs)","Year 1",null,null,"Year 2 ",null,null,"Year 3"]
[null,null,null,"Cash","In-Kind","Total Cost","Cash","In-Kind","Total Cost","Cash","In-Kind","Total Cost",null,null,null,{"$f":"C44","v":"Organization Name 4"},null,"One-Time","Ongoing","One-Time","Ongoing","One-Time","Ongoing"]
[null,null,{"$f":"'2) Input Assumptions'!A6","v":"Organization Name 1"},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUM(D29:E29)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"(SUM(G29:H29))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C29&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C29&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"(SUM(J29:K29))","v":0},null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A7","v":"Organization Name 2"},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUM(D30:E30)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"(SUM(G30:H30))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C30&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C30&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"(SUM(J30:K30))","v":0},null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\"))","v":0},{"$f":"(('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\")))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$44&\"*\"))","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A8","v":"Organization Name 3"},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"SUM(D31:E31)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"(SUM(G31:H31))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C31&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C31&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"(SUM(J31:K31))","v":0},null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$44&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A9","v":"Organization Name 4"},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"SUM(D32:E32)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"(SUM(G32:H32))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C32&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C32&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"(SUM(J32:K32))","v":0},null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A10","v":"Organization Name 5"},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"SUM(D33:E33)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"(SUM(G33:H33))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&C33&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C33&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"(SUM(J33:K33))","v":0},null,null,null,null,"Total",{"$f":"SUM(R29:R31)*(1+R32)","v":0},{"$f":"SUM(S29:S31)*(1+S32)","v":0},{"$f":"SUM(T29:T31)*(1+T32)","v":0},{"$f":"SUM(U29:U31)*(1+U32)","v":0},{"$f":"SUM(V29:V31)*(1+V32)","v":0},{"$f":"SUM(W29:W31)*(1+W32)","v":0}]
[null,null,"Total Cost ",{"$f":"SUM(D29:D33)","v":0},{"$f":"SUM(E29:E33)","v":0},0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C45","v":"Organization Name 5"}," ","One-Time","Ongoing","One-Time","Ongoing","One-Time","Ongoing"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\"))","v":0},{"$f":"(('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\")))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$45&\"*\"))","v":0}]
[null,null,"One-Time and Ongoing Costs ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$45&\"*\")","v":0}]
[null,null,"Total Cost\n(includes direct and indirect costs)","Year 1 ",null,null,"Year 2 ",null,null,"Year 3",null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0}]
[null,null,null,"One-Time","Ongoing","Total Cost","One-Time","Ongoing","Total Cost","One-Time","Ongoing","Total Cost",null,null,null,null,"Total",{"$f":"SUM(R36:R38)*(1+R39)","v":0},{"$f":"SUM(S36:S38)*(1+S39)","v":0},{"$f":"SUM(T36:T38)*(1+T39)","v":0},{"$f":"SUM(U36:U38)*(1+U39)","v":0},{"$f":"SUM(V36:V38)*(1+V39)","v":0},{"$f":"SUM(W36:W38)*(1+W39)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A6","v":"Organization Name 1"},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"(('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14))","v":0},{"$f":"SUM(D41:E41)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUM(G41:H41)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C41&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C41&\"*\"))*(1+'2) Input Assumptions'!B14)","v":0},{"$f":"SUM(J41:K41)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A7","v":"Organization Name 2"},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"(('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15))","v":0},{"$f":"SUM(D42:E42)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUM(G42:H42)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C42&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C42&\"*\"))*(1+'2) Input Assumptions'!B15)","v":0},{"$f":"SUM(J42:K42)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!A8","v":"Organization Name 3"},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"(('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16))","v":0},0,{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},0,{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C43&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C43&\"*\"))*(1+'2) Input Assumptions'!B16)","v":0},0,null,null,null,"Cash and In-Kind Costs "]
[null,null,{"$f":"'2) Input Assumptions'!A9","v":"Organization Name 4"},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"(('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17))","v":0},0,{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},0,{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C44&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C44&\"*\"))*(1+'2) Input Assumptions'!B17)","v":0},0,null,null,null,null,null,"Year 1",null,"Year 2 ",null,"Year 3 "]
[null,null,{"$f":"'2) Input Assumptions'!A10","v":"Organization Name 5"},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"(('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18))","v":0},0,{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},0,{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"one-time\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"one-time\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$F$10:$F$39,\"ongoing\",'3) Personnel'!$C$10:$C$39,\"*\"&C45&\"*\")+SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$D$9:$D$38,\"ongoing\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&C45&\"*\"))*(1+'2) Input Assumptions'!B18)","v":0},0,null,null,null,{"$f":"C29","v":"Organization Name 1"},null,"Cash","In-Kind","Cash","In-Kind","Cash","In-Kind"]
[null,null,"Total Cost ",{"$f":"SUM(D41:D45)","v":0},0,0,0,0,0,0,0,0,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\")","v":0}]
[null,null,{"$f":"CONCATENATE(\"Cost per \",'2) Input Assumptions'!F29)","v":"Cost per Unit"},null,{"$f":"E46/'2) Input Assumptions'!F30","v":{"$error":"#DIV/0!"}},{"$f":"F46/'2) Input Assumptions'!F30","v":{"$error":"#DIV/0!"}},null,{"$f":"H46/'2) Input Assumptions'!G30","v":{"$error":"#DIV/0!"}},{"$f":"I46/'2) Input Assumptions'!G30","v":{"$error":"#DIV/0!"}},null,{"$f":"K46/'2) Input Assumptions'!H30","v":{"$error":"#DIV/0!"}},{"$f":"L46/'2) Input Assumptions'!H30","v":{"$error":"#DIV/0!"}},null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$24*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$29&\"*\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$29&\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0},{"$f":"'2) Input Assumptions'!$B$14","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R46:R48)*(1+R49)","v":0},{"$f":"SUM(S46:S48)*(1+S49)","v":0},{"$f":"SUM(T46:T48)*(1+T49)","v":0},{"$f":"SUM(U46:U48)*(1+U49)","v":0},{"$f":"SUM(V46:V48)*(1+V49)","v":0},{"$f":"SUM(W46:W48)*(1+W49)","v":0}]
[null,null,"Secured Partnership Funding"]
[null,null,"Funding Source ","Year 1 ","Year 2 ","Year 3","Total ",null,null,null,null,null,null,null,null,{"$f":"C30","v":"Organization Name 2"},null,"Cash","In-Kind","Cash","In-Kind","Cash","In-Kind"]
[null,null,{"$f":"'2) Input Assumptions'!E5","v":"Organization Name 1"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C53&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C53&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C53&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},{"$f":"SUM(D53:F53)","v":0},null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E6","v":"Organization Name 2"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C54&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C54&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C54&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$25*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$30&\"*\"))","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E7","v":"Organization Name 3"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C55&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C55&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C55&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$30&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E8","v":"Organization Name 4"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C56&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C56&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C56&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0},{"$f":"'2) Input Assumptions'!$B$15","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E9","v":"Organization Name 5"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C57&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C57&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C57&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R53:R55)*(1+R56)","v":0},{"$f":"SUM(S53:S55)*(1+S56)","v":0},{"$f":"SUM(T53:T55)*(1+T56)","v":0},{"$f":"SUM(U53:U55)*(1+U56)","v":0},{"$f":"SUM(V53:V55)*(1+V56)","v":0},{"$f":"SUM(W53:W55)*(1+W56)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E10","v":"Funding Source 1"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C58&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C58&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C58&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0]
[null,null,{"$f":"'2) Input Assumptions'!E11","v":"Funding Source 2"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C59&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C59&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C59&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"C31","v":"Organization Name 3"},null,"Cash","In-Kind","Cash","In-Kind","Cash","In-Kind"]
[null,null,{"$f":"'2) Input Assumptions'!E12","v":"Funding Source 3"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C60&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C60&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C60&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E13","v":"Funding Source 4"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C61&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C61&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C61&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$26*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$31&\"*\"))","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E14","v":"Funding Source 5"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C62&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C62&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C62&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$31&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E15","v":"Funding Source 6"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C63&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C63&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C63&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0},{"$f":"'2) Input Assumptions'!$B$16","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E19","v":"Funding Source 10"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C64&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C64&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C64&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R60:R62)*(1+R63)","v":0},{"$f":"SUM(S60:S62)*(1+S63)","v":0},{"$f":"SUM(T60:T62)*(1+T63)","v":0},{"$f":"SUM(U60:U62)*(1+U63)","v":0},{"$f":"SUM(V60:V62)*(1+V63)","v":0},{"$f":"SUM(W60:W62)*(1+W63)","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E20","v":"Funding Source 11"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C65&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C65&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C65&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0]
[null,null,{"$f":"'2) Input Assumptions'!E21","v":"Funding Source 12"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C66&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C66&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C66&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,{"$f":"C32","v":"Organization Name 4"},null,"Cash","In-Kind","Cash","In-Kind","Cash","In-Kind"]
[null,null,{"$f":"'2) Input Assumptions'!E22","v":"Funding Source 13"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C67&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C67&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C67&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\")","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E23","v":"Funding Source 14"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C68&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C68&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C68&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$27*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$32&\"*\"))","v":0}]
[null,null,{"$f":"'2) Input Assumptions'!E24","v":"Funding Source 15"},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C69&\"*\",'5) Secured Funding'!$D$9:$D$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C69&\"*\",'5) Secured Funding'!$E$9:$E$28)","v":0},{"$f":"SUMIF('5) Secured Funding'!$B$9:$B$28,\"*\"&C69&\"*\",'5) Secured Funding'!$F$9:$F$28)","v":0},0,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$32&\"*\")","v":0}]
[null,null,"Secured Funding ",{"$f":"SUM('5) Secured Funding'!D9:D28)","v":0},{"$f":"SUM('5) Secured Funding'!E9:E28)","v":0},{"$f":"SUM('5) Secured Funding'!F9:F28)","v":0},0,null,null,null,null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0},{"$f":"'2) Input Assumptions'!$B$17","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R67:R69)*(1+R70)","v":0},{"$f":"SUM(S67:S69)*(1+S70)","v":0},{"$f":"SUM(T67:T69)*(1+T70)","v":0},{"$f":"SUM(U67:U69)*(1+U70)","v":0},{"$f":"SUM(V67:V69)*(1+V70)","v":0},{"$f":"SUM(W67:W69)*(1+W70)","v":0}]
[null,null,"Total Cost",{"$f":"F13","v":0},{"$f":"I13","v":0},{"$f":"L13","v":0},{"$f":"SUM(D72:F72)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C33","v":"Organization Name 5"},null,"Cash","In-Kind","Cash","In-Kind","Cash","In-Kind"]
[null,null,"Funding Surplus / (Funding Gap)",{"$f":"D70-D72","v":0},{"$f":"E70-E72","v":0},0,{"$f":"G70-G72","v":0},null,null,null,null,null,null,null,null,null,"Wages",{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fringe",{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$I$10:$I$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$K$10:$K$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"cash\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0},{"$f":"('2) Input Assumptions'!$B$28*SUMIFS('3) Personnel'!$M$10:$M$39,'3) Personnel'!$G$10:$G$39,\"in-kind\",'3) Personnel'!$E$10:$E$39,\"yes\",'3) Personnel'!$C$10:$C$39,\"*\"&$C$33&\"*\"))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non-Personnel Costs ",{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$F$9:$F$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$G$9:$G$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"cash\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0},{"$f":"SUMIFS('4) Non-Personnel'!$H$9:$H$38,'4) Non-Personnel'!$E$9:$E$38,\"in-kind\",'4) Non-Personnel'!$C$9:$C$38,\"*\"&$C$33&\"*\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indirect Rate ",{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0},{"$f":"'2) Input Assumptions'!$B$18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(R74:R76)*(1+R77)","v":0},{"$f":"SUM(S74:S76)*(1+S77)","v":0},{"$f":"SUM(T74:T76)*(1+T77)","v":0},{"$f":"SUM(U74:U76)*(1+U77)","v":0},{"$f":"SUM(V74:V76)*(1+V77)","v":0},{"$f":"SUM(W74:W76)*(1+W77)","v":0}]

{"sheet":"7) Summary Graphs & Discussion","index":6,"n_rows":79,"n_cols":8,"rows_kept":79,"cut":false,"hidden":false,"merged":[[1,0,1,11],[78,7,78,11],[79,7,101,11]]}
[]
["Partnership Summary Graphs & Discussion"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Notes"]