{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Budget Overview","Year 1","Year 2","Year 3","Year 4","(Optional) Year 5 - Evaluation","Matching","Related Outside Funding","Projects Overview"],"not_rendered":{"charts":0,"images":99,"macros":1,"external_links":0,"defined_names":4,"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":"Instructions","index":0,"n_rows":37,"n_cols":1,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,0,34,6],[36,0,36,6],[20,0,20,6],[22,0,22,6],[24,0,24,6],[26,0,26,6],[28,0,28,6],[32,0,32,6],[14,0,16,6],[0,0,0,6],[1,0,1,6],[4,0,6,6],[8,0,8,6],[10,0,12,6]]}
[]
["Digital Equity Competitive Grant Program (DECGP)\nConsolidated Budget Form\nOMB Control Number: 0660-0055   Expiration Date: 07/31/2027"]
["Consolidated Budget Form Instructions"]
["WORKSHEET INSTRUCTIONS"]
["NOTE: This document requires enabled macros to function properly. Please ensure that macros are enabled before entering any data. You may be able to enable macros by choosing the \"Enable this content\" option from the Security Warning Ribbon above.\n\nIf the ribbon is not visible you may have been prompted to enable macros when you opened the document as pictured here. If you elected to disable the macros, please close the document and reopen it with macros enabled. "]
[]
[]
["PURPOSE"]
["This form will serve as a tool to capture budget information for the Digital Equity Competitive Grant Program application. Per section IV.B.8 of the NOFO, any entity applying for the Digital Equity Competitive Grant Program must submit the Consolidated Budget Form as part of their application. \n\nApplications from Eligible Entities, including Indian Tribes, Alaska Native entities, and Native Hawaiian organizations (\"Native Entities\"), for the Digital Equity Competitive Grant Program must be received no later 11:59 p.m. ET on September 23, 2024. Applications from the United States Virgin Islands, Guam, American Samoa, the Commonwealth of the Northern Mariana Islands, and any other territory or possession of the United States (\"U.S. Territories\") must be received no later than 11:59 p.m. ET on October 22, 2024."]
["WORKSHEET NAVIGATION"]
["1. This workbook includes several different sheets. The first tab (this current sheet) is an instruction sheet. The second tab, \"Budget Overview\", is a summary sheet where data from subsequent tabs will be compiled. The next four tabs are where you will provide detailed budget information for each of the four years of the project(s) period of performance. The following tab, \"(Optional) Year 5 - Evaluation,\" captures budget information for applicants who elect to continue to measure and evaluate the activities for one (1) year after the initial four (4) year Period of Performance. The \"Matching\" tab is where you will provide detailed information on each source of matching funds provided cash or in-kind that are proposed by the eligible entity or by third party contributors. The \"Related Outside Funding,\" is where you will provide information on the source and amount of other outside funding you have received, or applied for, that fund activities to which the application relates. The final tab, \"Projects Overview\", is where you will provide background high level budget information for each specific intervention or activity to be funded by the program.\n\n2. Note that gray/blue shaded cells indicate the presence of a locked calculation. Only populate blank, white cells; the budget form will then calculate any required totals on your behalf.\n\n3. Add rows as needed in the budget sheets. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions sheet or Budget Overview tab.\n\n4. The totals of ALL cost categories should be exact amounts; please do not round totals."]
[]
[]
["INSTRUCTIONS"]
["Please fill out the entirety of this consolidated budget form with all currently available information, including estimated values. While an application may be selected for award with the information provided at time of application, distribution of award funds is contingent upon the submission of a comprehensive and complete Consolidated Budget Form.\n\n\n1. On the \"Budget Overview\" tab only complete the \"Total expenses related to the administration of the grant\" and \"Total expenses related to the evaluation of the grant\" fields. All other cells on this tab will auto populate based on data entered in within the subsequent tabs. \n2. Populate the blank white cells under Budget Details for Year 1, Year 2, Year 3, and Year 4. Any line item costs covered by matching should be recorded in the corresponding cell (Matching Contribution). If applicable, include additional matching information in the Narrative section below, including the type (cash or in-kind) and the source. In the Narrative section indicate the value of any costs that will contribute to the administrative and evaluation cost caps. \n3. If you intend to continue to measure and evaluate the activities for one (1) year after the initial four (4) year Period of Performance, populate the blank white cells in the \"(Optional) Year 5 - Evaluation\" tab. Any line item costs covered by matching should be recorded in the corresponding cell (Matching Contribution). If applicable, include additional matching information in the Narrative section below, including the type (cash or in-kind) and the source. In the Narrative section indicate the value of any costs that will contribute to the administrative and evaluation cost caps. \n4. For the yearly tabs, all costs incurred by the grantee's subrecipients and contractors should be entered only in “E. Contractual/Subaward.” All other sections are for the costs of the grantee only.\n5. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200. Only include costs that can be directly attributed to the project. Do not include costs that will be incurred for any other Federal financial assistance award. \n      • Allowable refers to costs that may be charged to a grant in accordance with the cost principles prescribed in 2 CFR 200.403.\n      • Allocable refers to costs that can be directly charged to the grant award based on the benefit provided. See 2 CFR 200.405.\n      • Reasonable refers to actions a prudent business person would employ and are necessary to the execution of the award. See 2 CFR 200.404.\n6. Populate the \"Matching\" tab with information on each instance of matching proposed by the eligible entity or by third party contributors in the table below. Please do NOT enter any matching funding provided by a subrecipient on this tab. All matching funding provided by a subrecipient should be entered within the \"SUBRECIPIENTS\" section on the Years 1-4 and (Optional) Year 5 - Evaluation tabs.\n7. Populate the \"Related Outside Funding\" tab with information on other outside funding you have received, or applied for, that fund activities to which the application relates.\n10. Lastly, fill out project-level information on the \"Projects Overview\" sheet. List all of the projects included in your application (i.e., the discrete activities/interventions to be implemented) and provide budget information that will be allocated to that project for each project year. Note that the information on this tab is not calculated based on other entries and must be manually input.\n8. Expenses relating to the administration of the grant: A grantee may not use more than ten (10) percent of the grant amounts received under the Digital Equity Competitive Grant Program for expenses relating (directly or indirectly) to the administration of the grant under Section 60305(d)(2)(c) of the Infrastructure Investment and Jobs Act. Please enter the total expenses related to the administration of the grant in cell B22 of the \"Budget Overview\" tab. The percentage of the total grant amount that will be allocated towards the administration of the grant will calculate automatically. \n9. Expenses relating to grant evaluation: A grantee may not use more than ten (10) percent of the grant amounts received under the Digital Equity Competitive Grant Program for expenses relating (directly or indirectly) to the evaluation of the grant under Section 60305(d)(2)(b)of the Infrastructure Investment and Jobs Act. Please enter the total expenses related to the evaluation of the grant in cell B23 of the  \"Budget Overview\" tab. The percentage of the total grant amount that will be allocated towards the evaluation of the grant will calculate automatically.\n\nWhen completing this form, use the revised OMB Guidance for Federal Financial Assistance in 2 C.F.R., linked below:"]
[]
[]
["Guidance for Federal Financial Assistance"]
["CATEGORIES"]
["A. Personnel"]
["List personnel-related project costs solely for employees of eligible entities. All personnel costs for subrecipients and contractors must be included under E. Contractual-Subawards. \"Level of Effort\" (column D) refers to the amount of time based on the \"Unit\" (column E) selected. For example, \"12\" \"Hours.\"\n\nIf loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the “Narrative” section below. NIST/DOC must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g., fee or profit)."]
["B. Travel"]
["All listed travel must be necessary for the performance of the project and must be directly associated with the award. Mileage should be the total cost, not the amount of miles traveled. To calculate mileage, use GSA rates. Please note, every line item in this section should be broken down by trip, not by traveler. Additionally, this category is reserved only for project staff travel; trips for consultants/contractors should be shown in the \"Contractual-Subawards” cost category along with consultant/contractor fees. Because these costs are associated with contract-related work, they must be under the \"Contractual-Subawards\" cost category. \n\nNote that federal travel regulations are contained within the applicable cost principles for all entity types.\n                                                                                                                                                                                                                                                                                          \nFinally, travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organization's written travel policy. In the absence of a written travel policy, organizations must follow the regulations prescribed by the General Services Administration (GSA). "]
["C. Equipment"]
["Equipment means a single item of tangible, personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost that equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $10,000. Please refer to the applicable Federal regulations in 2 CFR 200 for specific equipment definitions and treatment. \n\nDo not include supply items under “Equipment”.  Please refer to 2 CFR 200 and d. Supplies on what constitutes a supply item.\n\nAny equipment that is leased must be listed under the “Other” tab and not under “Equipment.”"]
["D. Supplies"]
["Supplies are generally defined as an item with an acquisition cost of $10,000 or less and a useful life expectancy of less than one year. Supplies are generally consumed during the project performance. Please refer to the applicable Federal regulations in 2 CFR 200 for specific supplies definitions and treatment. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $10,000, regardless of the length of its useful life. \n\nNote that Supply items must be direct costs to the project in this budget category and not duplicate supply costs included in the indirect pool, which is the basis of the indirect rate applied for this project. Supply costs must be allocable specifically to the project.\n\nIf supply items and costs are ambiguous in nature, contact your DOC representative for proper categorization.  "]
["E. Contractual-Subawards"]
["List all costs related to subrecipients and contractors. For partnership applications, include costs related to partners in this category only if the partner(s) will be a subrecipient(s). \n\nSubrecipients (sub-awardees): A subrecipient is a legal entity to which a sub-award is made, who has performance measured against whether the objectives of the Federal program are met, is responsible for programmatic decision-making, must adhere to applicable Federal program compliance requirements, and uses the Federal funds to carry out a program of the organization. Not all characteristics may be present, and judgment must be used to determine the status of subrecipient vs. contractor.\n\nContractors: A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the Federal program, and is not subject to compliance requirements of the Federal program. Not all characteristics may be present, and judgment must be used to determine the status of subrecipient vs. contractor. List all contractors supplying commercial supplies or services used to support the project. \n\nIn determining whether an agreement between a pass-through entity and another non-Federal entity casts the latter as a subrecipient or a contractor, the substance of the relationship is more important than the form of the agreement. Please refer to 2 CFR 200.331 Subrecipient and contractor determinations for more information on making a determination on subrecipient vs contractor.\n\nUse the narrative space to explain how the costs associated with each line item relate to the implementation of the project as outlined in the proposal being submitted. Justifications should be concise and written so that someone not specifically familiar with the project can conceptually understand the rationale, purpose, and calculation of the anticipated costs identified. Explain why items are essential in relation to the aims of the project and meet the goals of the project. Do not merely restate the proposed expenditure. The specific items in the subrecipient budget(s) should not be explained here."]
["F. Construction"]
["Provide a description of the construction project elements and estimates of the cost. Minor repairs or renovations may be allowable and should be classified in the \"Other\" category."]
["G. Other"]
["Other direct costs are direct cost items required for the project that do not fit clearly into other categories. These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project). Examples are: tuition, printing costs, etc., which can be directly charged to the project and are not duplicated in indirect costs (overhead costs)."]
["H. Indirect"]
["Indirect costs means those costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved.\n\nIndirect costs may be charged to the award if the applicant has a Federally approved indirect cost rate or the applicant has never received a negotiated indirect cost rate and elects to charge a de minimis rate of up to 15 percent of modified total direct costs (MTDC), which can be used indefinitely. MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $50,000 of each sub-award (regardless of the period of performance of the sub-awards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs, and the portion of each subaward in excess of $50,000.\n\nIndirect costs that are related to the administration of the Eligible Entity's grant count toward the statutory ten percent cap on administrative expenses. By their nature, indirect costs are those recipient costs that are not directly associated with the recipient's execution of its grant-funded project but that are necessary to the operation of the organization and the performance of its programs. A grantee should describe the types of indirect costs that it will charge to the grant. A grantee can never double-charge a cost as both a direct and an indirect administrative cost. The budget provided by the Eligible Entity must explain how it applied or calculated its administrative costs and demonstrate that its combined direct and indirect administrative costs are at or under the 10% statutory limit. It is the Eligible Entity's responsibility to determine whether their indirect costs include such expenses subject to the cap, and account for them appropriately. The Eligible Entity must document such accounting and make it available to NTIA and NIST if requested.\n\nNOTE: A Recipient who elects to employ the de minimis Indirect Cost rate cannot claim resulting costs as a Cost Share contribution, nor can the Recipient claim \"unrecovered indirect costs\" as a Cost Share contribution. Neither of these costs can be reflected as actual indirect cost rates realized by the organization, and therefore are not verifiable in the Recipient records as required by Federal Regulation (2 C.F.R. §200.306(b)(1))."]
["NOTES ON MATCHING"]
["Applicants shall identify funds used to meet the statutory ten percent match requirement by populating the “Matching Contribution” column included in each budget category. Any line item costs covered by cost sharing or matching should be recorded in the corresponding cell (“Matching Contribution”). If applicable, include additional information in the Narrative section below, including the type (cash or in-kind) and the source.\n\n1. Cash Contributions - Cash contributions means the grantee's cash outlay, including the outlay of money contributed to the grantee or subgrantee by other public agencies and institutions, and private organizations and individuals.\n\n2. In-Kind Contributions - Contributions, which may include third-party in-kind contributions, are non-cash donations of property, goods or services, that benefit a federally assisted project and which may count toward satisfying the non-federal matching requirement of a project's total budgeted costs when such contributions meet certain criteria. NTIA encourages applicants to thoroughly consider potential sources of in-kind contributions that, depending on the particular property or service and the applicable federal cost principles, could include employee or volunteer services; equipment; supplies; indirect costs; computer hardware and software; and use of facilities. \n\n3. All matching must be necessary to the performance of the project. If questions exist, consult your NTIA contact before filling out In-Kind cost share in this section. \n\n4. Contractors may not provide cost share. Any partial donation of goods or services is considered a discount and is not allowable.  \n\n5. Fee or profit, including foregone fee or profit, are not allowable as project costs (including cost share) under any resulting award. The project may only incur those costs that are allowable and allocable to the project (including cost share) as determined in accordance with the applicable cost principles prescribed in 2 CFR Part 200.\n\n6. A Recipient who elects to employ the de minimis Indirect Cost rate cannot claim the resulting indirect costs as a Cost Share contribution. \n\n7. A Recipient cannot claim \"unrecovered indirect costs\" as a Cost Share contribution.    "]

{"sheet":"Budget Overview","index":1,"n_rows":29,"n_cols":20,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,18],[1,0,1,18],[2,1,2,3],[2,4,2,6],[2,7,2,9],[2,10,2,12],[2,13,2,15],[2,16,2,18],[21,2,21,3],[26,2,26,3],[26,5,26,6],[16,0,16,18],[18,0,18,18],[22,2,22,3]]}
["Budget Overview"]
["NOTE: All values in rows 5-20 are locked. Any errors found should be fixed on the corresponding budget detail tab.\n\nCells B22 and B23 are not locked and should be used to specify the total expenses how much of the total proposed grant amount will be allocated towards administration and evaluation of the program. A percentage allocation will be automatically calculated, and must not exceed 10% of the total grant award (See IIJA Section 60305(d)(2)).\n\nCells B25, B26, and B27 are locked and will populate totals for matching contribution based on information input in the corresponding tabs. The percentage of the total award matched by non-federal contributions will be automatically calculated; note that statutorily at least a 10% match must be provided.  \n\nCell B29 is also locked and will populate the total additional supplementary funds based on information input in the corresponding tabs. "]
[null,"Fiscal / Project Year 1 ",null,null,"Fiscal / Project Year 2",null,null,"Fiscal / Project Year 3",null,null,"Fiscal / Project Year 4",null,null,"(Optional) Year 5 - Evaluation Period",null,null,"Totals"]
["Budget Category","Federal Request","Matching Contribution","Total","Federal Request","Matching Contribution","Total","Federal Request","Matching Contribution","Total","Federal Request","Matching Contribution","Total","Federal Request","Matching Contribution","Total","Total Federal Request","Total Matching Contribution","Total(s)"]
["A. Personnel",{"$f":"'Year 1'!$K$21","v":130200},{"$f":"'Year 1'!$J$21","v":60000},{"$f":"SUM(B5:C5)","v":190200},{"$f":"'Year 2'!$K$21","v":130200},{"$f":"'Year 2'!$J$21","v":60000},{"$f":"SUM(E5:F5)","v":190200},{"$f":"'Year 3'!$K$23","v":130200},{"$f":"'Year 3'!$J$23","v":60000},{"$f":"SUM(H5:I5)","v":190200},{"$f":"'Year 4'!$K$17","v":130200},{"$f":"'Year 4'!$J$17","v":60000},{"$f":"SUM(K5:L5)","v":190200},{"$f":"'(Optional) Year 5 - Evaluation'!$K$27","v":33500},{"$f":"'(Optional) Year 5 - Evaluation'!$J$27","v":25000},{"$f":"SUM(N5,O5)","v":58500},{"$f":"SUM(B5,E5,H5,K5,N5)","v":554300},{"$f":"SUM(C5,F5,I5,L5,O5)","v":265000},{"$f":"SUM(D5,G5,J5,M5,P5)","v":819300},{"$f":"SUM(F5,I5,L5,#REF!)","v":{"$error":"#REF!"}}]
["Salary",{"$f":"'Year 1'!$G$21","v":180000},null,{"$f":"SUM(B6:C6)","v":180000},{"$f":"'Year 2'!$G$21","v":180000},null,{"$f":"SUM(E6:F6)","v":180000},{"$f":"'Year 3'!$G$23","v":180000},null,{"$f":"SUM(H6:I6)","v":180000},{"$f":"'Year 4'!$G$17","v":180000},null,{"$f":"SUM(K6:L6)","v":180000},{"$f":"'(Optional) Year 5 - Evaluation'!$G$27","v":50000},null,{"$f":"SUM(N6,O6)","v":50000},{"$f":"SUM(B6,E6,H6,K6,N6)","v":770000},null,{"$f":"SUM(D6,G6,J6,M6,P6)","v":770000},{"$f":"SUM(F6,I6,L6,#REF!)","v":{"$error":"#REF!"}}]
["Fringe",{"$f":"'Year 1'!$H$21","v":10200},null,10200,{"$f":"'Year 2'!$H$21","v":10200},null,10200,{"$f":"'Year 3'!$H$23","v":10200},null,10200,{"$f":"'Year 4'!$H$17","v":10200},null,10200,{"$f":"'(Optional) Year 5 - Evaluation'!$H$27","v":8500},null,8500,49300,null,49300,{"$f":"SUM(F7,I7,L7,#REF!)","v":{"$error":"#REF!"}}]
["B. Travel",{"$f":"'Year 1'!$M$45","v":1883.75},{"$f":"'Year 1'!$L$45","v":3247.5},5131.25,{"$f":"'Year 2'!$M$45","v":1883.75},{"$f":"'Year 2'!$L$45","v":3247.5},5131.25,{"$f":"'Year 3'!$M$47","v":1883.75},{"$f":"'Year 3'!$L$47","v":3247.5},5131.25,{"$f":"'Year 4'!$M$41","v":1883.75},{"$f":"'Year 4'!$L$41","v":3247.5},5131.25,{"$f":"'(Optional) Year 5 - Evaluation'!$M$51","v":558},{"$f":"'(Optional) Year 5 - Evaluation'!$L$51","v":0},558,8093,{"$f":"SUM(C8,F8,I8,L8,O8)","v":12990},21083,{"$f":"SUM(F8,I8,L8,#REF!)","v":{"$error":"#REF!"}}]
["C. Equipment",{"$f":"'Year 1'!$E$69","v":12614.03},{"$f":"'Year 1'!$D$69","v":0},12614.03,{"$f":"'Year 2'!$E$69","v":0},{"$f":"'Year 2'!$D$69","v":0},0,{"$f":"'Year 3'!$E$71","v":0},{"$f":"'Year 3'!$D$71","v":0},0,{"$f":"'Year 4'!$E$64","v":0},{"$f":"'Year 4'!$D$64","v":0},0,{"$f":"'(Optional) Year 5 - Evaluation'!$E$75","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$D$75","v":0},0,12614.03,0,12614.03,{"$f":"SUM(F9,I9,L9,#REF!)","v":{"$error":"#REF!"}}]
["D. Supplies",{"$f":"'Year 1'!$E$95","v":2299.88},{"$f":"'Year 1'!$D$95","v":0},2299.88,{"$f":"'Year 2'!$E$92","v":299.89999999999998},{"$f":"'Year 2'!$D$92","v":0},299.89999999999998,{"$f":"'Year 3'!$E$94","v":299.89999999999998},{"$f":"'Year 3'!$D$94","v":0},299.89999999999998,{"$f":"'Year 4'!$E$88","v":299.89999999999998},{"$f":"'Year 4'!$D$88","v":0},299.89999999999998,{"$f":"'(Optional) Year 5 - Evaluation'!$E$99","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$D$99","v":0},0,3199.5800000000004,0,3199.5800000000004,{"$f":"SUM(F10,I10,L10,#REF!)","v":{"$error":"#REF!"}}]
["E. Contractual/Subawards",{"$f":"'Year 1'!$H$146","v":2600000},{"$f":"'Year 1'!$E$144","v":250000},2850000,{"$f":"'Year 2'!$H$143","v":2600000},{"$f":"'Year 2'!$E$141","v":250000},2850000,{"$f":"'Year 3'!$H$141","v":1800000},{"$f":"'Year 3'!$E$139","v":250000},2050000,{"$f":"'Year 4'!$H$136","v":1650000},{"$f":"'Year 4'!$E$134","v":250000},1900000,{"$f":"'(Optional) Year 5 - Evaluation'!$H$147","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$E$145","v":0},0,8650000,1000000,9650000,{"$f":"SUM(F11,I11,L11,#REF!)","v":{"$error":"#REF!"}}]
["         Contractors",{"$f":"'Year 1'!$E$124","v":1150000},null,1150000,{"$f":"'Year 2'!$E$122","v":1150000},null,1150000,{"$f":"'Year 3'!$E$120","v":650000},null,650000,{"$f":"'Year 4'!$E$114","v":500000},null,500000,{"$f":"'(Optional) Year 5 - Evaluation'!$E$124","v":0},null,0,3450000,null,{"$f":"SUM(D12,G12,J12,M12,P12)","v":3450000},{"$f":"SUM(F12,I12,L12,#REF!)","v":{"$error":"#REF!"}}]
["         Subrecipients",{"$f":"'Year 1'!$H$144","v":1450000},{"$f":"'Year 1'!$E$144","v":250000},1700000,{"$f":"'Year 2'!$H$141","v":1450000},{"$f":"'Year 2'!$E$141","v":250000},1700000,{"$f":"'Year 3'!$H$139","v":1150000},{"$f":"'Year 3'!$E$139","v":250000},1400000,{"$f":"'Year 4'!$H$134","v":1150000},{"$f":"'Year 4'!$E$134","v":250000},1400000,{"$f":"'(Optional) Year 5 - Evaluation'!$H$145","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$E$145","v":0},0,5200000,1000000,6200000,{"$f":"SUM(F13,I13,L13,#REF!)","v":{"$error":"#REF!"}}]
["F. Construction",{"$f":"'Year 1'!$F$170","v":9333.17},{"$f":"'Year 1'!$E$170","v":0},9333.17,{"$f":"'Year 2'!$F$169","v":0},{"$f":"'Year 2'!$E$169","v":0},0,{"$f":"'Year 3'!$F$165","v":0},{"$f":"'Year 3'!$E$165","v":0},0,{"$f":"'Year 4'!$F$160","v":0},{"$f":"'Year 4'!$E$160","v":0},0,{"$f":"'(Optional) Year 5 - Evaluation'!$F$172","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$E$172","v":0},0,9333.17,0,9333.17,{"$f":"SUM(F14,I14,L14,#REF!)","v":{"$error":"#REF!"}}]
["G. Other Direct Costs",{"$f":"'Year 1'!$E$194","v":3700},{"$f":"'Year 1'!$D$194","v":3500},7200,{"$f":"'Year 2'!$E$193","v":3700},{"$f":"'Year 2'!$D$193","v":3500},7200,{"$f":"'Year 3'!$E$189","v":3700},{"$f":"'Year 3'!$D$189","v":3500},7200,{"$f":"'Year 4'!$E$184","v":3700},{"$f":"'Year 4'!$D$184","v":3500},7200,{"$f":"'(Optional) Year 5 - Evaluation'!$E$196","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$D$196","v":0},0,14800,14000,28800,{"$f":"SUM(F15,I15,L15,#REF!)","v":{"$error":"#REF!"}}]
["TOTAL Direct Costs",{"$f":"SUM(B5:B15)-SUM(B6:B7,B12:B13)","v":2760030.83},316747.5,3076778.33,{"$f":"SUM(E5:E15)-SUM(E6:E7,E12:E13)","v":2736083.6500000004},316747.5,{"$f":"SUM(G5:G15)-SUM(G6:G7,G12:G13)","v":3052831.1500000004},1936083.65,316747.5,2252831.1500000004,1786083.65,316747.5,2102831.15,{"$f":"SUM(N5:N15)-SUM(N6:N7,N12:N13)","v":34058},{"$f":"SUM(O5:O15)-SUM(O6:O7,O12:O13)","v":25000},{"$f":"SUM(P5:P15)-SUM(P6:P7,P12:P13)","v":59058},9252339.7800000012,1291990,10544329.780000001,{"$f":"SUM(F16,I16,L16,#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F17,I17,L17,#REF!)","v":{"$error":"#REF!"}}]
["H. Total Indirect Costs",{"$f":"'Year 1'!$G$218","v":24726},{"$f":"'Year 1'!$F$218","v":0},{"$f":"SUM(B18,C18)","v":24726},{"$f":"'Year 2'!$G$217","v":24726},{"$f":"'Year 2'!$F$217","v":0},{"$f":"SUM(E18,F18)","v":24726},{"$f":"'Year 3'!$G$213","v":24726},{"$f":"'Year 3'!$F$213","v":0},{"$f":"SUM(H18,I18)","v":24726},{"$f":"'Year 4'!$G$208","v":24726},{"$f":"'Year 4'!$F$208","v":0},{"$f":"SUM(K18,L18)","v":24726},{"$f":"'(Optional) Year 5 - Evaluation'!$G$220","v":0},{"$f":"'(Optional) Year 5 - Evaluation'!$F$220","v":0},{"$f":"SUM(N18,O18)","v":0},{"$f":"SUM(B18,E18,H18,K18,N18)","v":98904},{"$f":"SUM(C18,F18,I18,L18,O18)","v":0},{"$f":"SUM(D18,G18,J18,M18,P18)","v":98904},{"$f":"SUM(F18,I18,L18,#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F19,I19,L19,#REF!)","v":{"$error":"#REF!"}}]
["Total Costs",null,null,{"$f":"SUM(D16,D18)","v":3101504.33},null,null,{"$f":"SUM(G16,G18)","v":3077557.1500000004},null,null,{"$f":"SUM(J16,J18)","v":2277557.1500000004},null,null,{"$f":"SUM(M16,M18)","v":2127557.15},null,null,{"$f":"SUM(P16,P18)","v":59058},{"$f":"SUM(Q16,Q18)","v":9351243.7800000012},{"$f":"SUM(R16,R18)","v":1291990},{"$f":"S16+S18","v":10643233.780000001},{"$f":"SUM(F20,I20,L20,#REF!)","v":{"$error":"#REF!"}}]
[]
["Total expenses related to the administration of the grant",681057.63,"Percentage of the total award that will be  allocated to the administration of the grant",null,{"$f":"IFERROR(B22/$S$20,0)","v":6.3989727565676002E-2}]
["Total expenses related to the evaluation of the grant",87138,"Percentage of the total award that will be  allocated to the evaluation of the grant",null,{"$f":"IFERROR(B23/$S$20,0)","v":8.187173353623357E-3}]
[]
["Total Applicant/Third Party Matching Contribution (Please note, this value should match the \"Total Matching\" value on the \"Matching\" tab - cell E13.)",{"$f":"(R20-R13)","v":291990}]
["Total Subrecipient Match",{"$f":"R13","v":1000000}]
["Total Matching Contribution",{"$f":"R20","v":1291990},"Percentage of the total award matched by non-federal contributions",null,{"$f":"IFERROR(B27/S20,0)","v":0.12139073769363355},"The statutory matching requirement for this Program is at least 10% of the total project cost. This cell will turn red if this percentage is calculated as less than 10%."]
[]
["Total Outside Funding",{"$f":"'Related Outside Funding'!E10","v":500000}]

{"sheet":"Year 1","index":2,"n_rows":220,"n_cols":17,"rows_kept":220,"cut":false,"hidden":false,"merged":[[4,3,4,11],[219,0,220,16],[74,2,74,6],[195,0,196,16],[171,0,172,16],[147,0,148,16],[96,0,97,16],[175,1,175,5],[199,2,199,7],[50,2,50,6],[22,0,23,16],[46,0,47,16],[70,0,71,16],[26,3,26,15],[124,0,124,16]]}
["Budget Detail - Year 1"]
[]
[]
["A. Personnel"]
[]
["Position Title","Key Personnel","Relevant Specific Project(s)","Level of Effort ","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Matching Contribution","Federal Request","Total ","Column2","Column3","Column4","Column5","Column6"]
["Grant Manager","Yes","Project A",1,"Annual",60000,{"$f":"D7*F7","v":60000},{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":10200},0.17,0,{"$f":"G7+H7-J7","v":70200},{"$f":"J7+K7","v":70200}]
["Legal Staff","No",null,400,"Hour",300,{"$f":"D8*F8","v":120000},{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},0,60000,60000,120000]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D13*F13","v":0},{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D16*F16","v":0},{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D20*F20","v":0},{"$f":"Table1[[#This Row],[Subtotal Salary]]*Table1[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
["TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(G7:G20)","v":180000},{"$f":"SUM(H7:H20)","v":10200},null,{"$f":"SUM(J7:J20)","v":60000},{"$f":"SUM(K7:K20)","v":130200},{"$f":"SUM(L7:L20)","v":190200}]
["Narrative (as needed)"]
["The Grant Manager (FTE) will be responsible for completing grant reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. The grant manager will spend 70% of their time ($70,200 x 0.70 = $49,140) on programmatic activities for Project A, 20% of their time ($70,200 x 0.20 = $14,040) on grants administration, and 10% of their time ($70,200 x 0.10 = $7,020) on evaluation. Fringe benefits for this employee include  health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges. \n\nLegal staff (FTE) will be responsible for drafting, execution, and filing fees of legal agreements and Memorandum of Understandings (MOUs) between organizations involved in the grant, including subgrantees. Legal hours also include time to conduct legal reviews for all contracts. Although this employee is FTE, they will only spend 70% of their time on Competitive Grant Program activities. The hourly rate has been prorated to reflect the division of effort ($428.57 * .7 = $300 pro-rated hourly rate). The legal staff will spend 100% of their time on grants administration. The applicant will provide $60,000 as a cash match to cover half of the legal staff's level of effort."]
[]
[]
["B. Travel"]
[]
[]
["Purpose of Travel/Justification of Need","Type of Travel (Domestic or International)","No. of Days","No. of Travelers","Lodging per Traveler/per night","Flight Cost per Traveler","Vehicle Cost per Traveler","Per Diem per Traveler","Mileage Cost","Miscellaneous","Cost per Trip","Matching Contribution","Federal Request","Total","Used Federal Cost Estimation Tool? ","Basis of cost","Column1"]
["Digital Literacy Training\n\nFunds are requested for 2 employees to travel to X city for the Annual Digital Literacy Training series kick-off.\n\n","Domestic",5,2,210,120,100,201,146.25,60,{"$f":"(((C30-1)*E30)*D30)+(D30*F30)+(D30*G30)+(D30*H30*C30)+I30+J30","v":4336.25},2850,{"$f":"K30-L30","v":1486.25},{"$f":"L30+M30","v":4336.25},"Yes","Lodging per Traveler/per night was calculated using the average price of X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nFlight per Traveler was calculated using the average price of an economy ticket from Y city to X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nVehicle per Traveler was calculated using the average price of a basic car rental in X city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $201 accounts for the cost of one traveler for one day.\n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Y city ($0.585 per mile) and multiplying it by the expected number of miles for the entire trip (250 miles): $0.59 * 250 = $146.25 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for X city."]
["Subgrantee Monitoring\n\nFunds are requested for 1 employee to travel to Z city to monitor subgrantee activities.","Domestic",2,1,150,0,100,79,120,30,{"$f":"(((C31-1)*E31)*D31)+(D31*F31)+(D31*G31)+(D31*H31*C30)+I31+J31","v":795},397.5,397.5,795,"Yes","Lodging per Traveler/per night was calculated using the average price of Z city for the estimated monitoring dates. Figures are accurate as of application submission date. \n\nFlights will not be required.\n\nVehicle per Traveler was calculated using the average price of a basic car rental in Z city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $79 accounts for the cost of one traveler for one day.\n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Z city ($0.40 per mile) and multiplying it by the expected number of miles for the entire trip (300 miles): $0.40*300 = $120 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for Z city."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C32-1)*E32)*D32)+(D32*F32)+(D32*G32)+(D32*H32*C32)+I32+J32","v":0},null,0,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C33-1)*E33)*D33)+(D33*F33)+(D33*G33)+(D33*H33*C33)+I33+J33","v":0},null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L44)","v":3247.5},{"$f":"SUM(M30:M44)","v":1883.75},{"$f":"SUM(N30:N44)","v":5131.25}]
["Narrative (as needed)"]
["Digital Literacy Training costs will be 100% for programmatic purposes in support of Project A (no costs towards administration or evaluation). The applicant will provide match at the value of per diem ($201*2*5 = $2010) plus lodging ($210*4 = $840) (total match provided will be $2,850). \n\nThe Subgrantee Monitoring trip will be entirely for administrative purposes. The applicant will provide a 50% cash match for the trip ($795*0.5 = $397.5)."]
[]
[]
["C. Equipment"]
[]
[]
["Equipment Item","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Computer Server",1,12614.03,null,{"$f":"(B54*C54)-D54","v":12614.03},{"$f":"D54+E54","v":12614.03},"Online listing at [list URL here]"]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D54:D68)","v":0},{"$f":"SUM(E54:E68)","v":12614.03},{"$f":"SUM(F54:F68)","v":12614.03}]
["Narrative (as needed)"]
["The server will run IT applications and provide storage. The server will be required for office staff to execute all program objectives. The server will be allocable 100% to the administrative cost cap."]
[]
[]
["D. Supplies"]
[]
[]
["General Category of Supplies","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Tablet Computers",2,999.99,0,{"$f":"(B78*C78)-D78","v":1999.98},{"$f":"D78+E78","v":1999.98},"Online listing at [list URL here]"]
["Office Supply Set",10,29.99,0,299.89999999999998,299.89999999999998,"Online listing at [list URL here]"]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D78:D94)","v":0},{"$f":"SUM(E78:E94)","v":2299.88},{"$f":"SUM(F78:F94)","v":2299.88}]
["Narrative (as needed)"]
["Two (2) tablets will be used by office staff to help develop digital literacy training. 90% of each tablet's use will be programmatic towards Project A (($999.99*0.9)*2 = $1799.98) and 10% of each tablet's use (($999.99*0.1)*2 = $200) will be administrative.\n\nOffice supplies will be used by office staff to carry out project objectives. 100% of the supplies will go towards administrative costs."]
[]
[]
["E. Contractual-Subawards"]
[]
["CONTRACTORS"]
["Contractor Name / Organization","Project Description","Basis of cost","Value ($)","Federal Request","Total Cost","Column11","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Y City General Contractor","Y City General Contractor is a general contractor who will assist with building 1500 sq foot public access computing center additions across libraries in the county, as part of Project A.","Market research on general contractor quotes",750000,{"$f":"F104","v":750000},{"$f":"D104","v":750000},null,null,null,null,null,null,null,null,null,"Column10"]
["Digital Literacy Advisors, LLC","Digital Literacy Advisors, LLC will provide consultants to assist with digital literacy strategy development in support of Project C.","Market research on consultant quotes",400000,400000,400000,null,null,null,null,null,null,null,null,null,"Column11"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column12"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column13"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column14"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column15"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column16"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column17"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column18"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column19"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column20"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column21"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column22"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column23"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column24"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,"Column25"]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E104:E123)","v":1150000},{"$f":"SUM(F104:F123)","v":1150000}]
[]
["SUBRECIPIENTS"]
["Subrecipient Name / Organization","Project Description","Value of Subaward ($)","Basis of Cost","Matching Contribution","Type (Cash, In-Kind, or N/A)","Source","Federal Request","Total Cost","Column8","Column1","Column2","Column3","Column4","Column5","Column6","Column7"]
["X City Public Library","This subrecipient will be responsible for executing Project B.",700000,"Estimated cost of Project B",150000,"In-Kind","Subrecipient",{"$f":"C128","v":700000},{"$f":"(E128+H128)","v":850000}]
["State University","This subrecipient will be responsible for implementing part of Project C.",750000,"Estimated cost of Project C",100000,"Cash","Subrecipient ",{"$f":"C129","v":750000},850000]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(Table7[Matching Contribution])","v":250000},null,null,{"$f":"SUM(H128:H143)","v":1450000},{"$f":"SUM(I128:I143)","v":1700000}]
[]
["TOTAL CONTRACTUAL-SUBAWARDS",null,null,null,{"$f":"E144","v":250000},null,null,{"$f":"E124+H144","v":2600000},{"$f":"F124+I144","v":2850000}]
["Narrative (as needed)"]
["X City Public Library will provide in-kind contributions in terms of facilities valued at $150,000."]
[]
[]
["F. Construction"]
[]
[]
["Purpose","General Description","# of Items","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Computer lab addition at Y City Public Library","Sheet of drywall",58,15,null,{"$f":"(C155*D155)-E155","v":870},{"$f":"E155+F155","v":870}]
["Computer lab addition at Y City Public Library","40 Sq foot roll of insulation",38,23.47,null,891.8599999999999,891.8599999999999]
["Computer lab addition at Y City Public Library","26.62 sq foot pack of vinyl plank flooring",57,132.83000000000001,null,7571.31,7571.31]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL CONSTRUCTION",null,null,null,{"$f":"SUM(E155:E169)","v":0},{"$f":"SUM(F155:F169)","v":9333.17},{"$f":"SUM(G155:G169)","v":9333.17}]
["Narrative (as needed)"]
["The 2000 square foot classroom at the Y City Public Library will provide free learning classes on digital literacy to Veterans. These costs will be 100% programmatic towards Project A. Any EHP-related costs will not be charged to this grant or be a matching contribution."]
[]
[]
["G. Other"]
[]
[]
["General Description","Quantity","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
["Project Management Training for Competitive Grant Program Staff",1,7200,3500,{"$f":"(B179*C179)-D179","v":3700},{"$f":"D179+E179","v":7200}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL OTHER",null,null,{"$f":"SUM(D179:D193)","v":3500},{"$f":"SUM(E179:E193)","v":3700},{"$f":"SUM(F179:F193)","v":7200}]
["Narrative (as needed)"]
["Annual Project Management Training conducted by XYZ Corporation or the Grant Manager. The training will cover project management areas necessary for the successful implementation and oversight of the Competitive Grant Program. The applicant will provide a $3,500 cash match."]
[]
[]
["H. Indirect"]
[]
[]
["General Description","Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9"]
["The applicant has a Federally-negotiated indirect cost rate agreement with an indirect cost rate of 13%. The indirect cost base is based on labor (salary and fringe benefits).","Period of Performance",190200,0.13,{"$f":"C203*D203","v":24726},null,{"$f":"E203-F203","v":24726},{"$f":"F203+G203","v":24726}]
[null,null,null,null,{"$f":"C204*D204","v":0},null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
["TOTAL INDIRECT",null,null,null,null,{"$f":"SUM(F203:F217)","v":0},{"$f":"SUM(G203:G217)","v":24726},{"$f":"SUM(H203:H217)","v":24726}]
["Narrative (as needed)"]
["The indirect cost base is the sum of all salaries ($180,000) and fringe benefits ($10,200) charged to the grant  during the grant year. The indirect costs are 100% administrative costs and will be subject to the administrative cost cap."]

{"sheet":"Year 2","index":3,"n_rows":219,"n_cols":17,"rows_kept":219,"cut":false,"hidden":false,"merged":[[198,2,198,7],[218,0,219,16],[4,3,4,11],[74,2,74,6],[93,0,94,16],[146,0,147,16],[170,0,171,16],[174,1,174,5],[194,0,195,16],[22,0,23,16],[26,3,26,15],[46,0,47,16],[50,2,50,6],[70,0,71,16],[122,0,122,16],[143,0,144,16]]}
["Budget Detail - Year 2"]
[]
[]
["A. Personnel"]
[]
["Position Title","Key Personnel","Relevant Specific Project(s)","Level of Effort ","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Matching Contribution","Federal Request","Total ","Column2","Column3","Column4","Column5","Column6"]
["Grant Manager","Yes","Project A",1,"Annual",60000,60000,10200,0.17,0,70200,70200]
["Legal Staff","No",null,400,"Hour",300,120000,0,0,60000,60000,120000]
[null,null,null,null,null,null,{"$f":"D9*F9","v":0},{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,{"$f":"G9+H9-J9","v":0},{"$f":"J9+K9","v":0}]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table16[[#This Row],[Subtotal Salary]]*Table16[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
["TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(G7:G20)","v":180000},{"$f":"SUM(H7:H20)","v":10200},null,{"$f":"SUM(J7:J20)","v":60000},{"$f":"SUM(K7:K20)","v":130200},{"$f":"SUM(L7:L20)","v":190200}]
["Narrative (as needed)"]
["The Grant Manager (FTE) will be responsible for completing grant reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. The grant manager will spend 70% of their time ($70,200 x 0.70 = $49,140) on programmatic activities for Project A, 20% of their time ($70,200 x 0.20 = $14,040) on grants administration, and 10% of their time ($70,200 x 0.10 = $7,020) on evaluation. Fringe benefits for this employee include  health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges. \n\nLegal staff (FTE) will be responsible for drafting, execution, and filing fees of legal agreements and Memorandum of Understandings (MOUs) between organizations involved in the grant, including subgrantees. Legal hours also include time to conduct legal reviews for all contracts. Although this employee is FTE, they will only spend 70% of their time on Competitive Grant Program activities. The hourly rate has been prorated to reflect the division of effort ($428.57 * .7 = $300 pro-rated hourly rate). The legal staff will spend 100% of their time on grants administration. The applicant will provide $60,000 as a cash match to cover half of the legal staff's level of effort."]
[]
[]
["B. Travel"]
[]
[]
["Purpose of Travel/Justification of Need","Type of Travel (Domestic or International)","No. of Days","No. of Travelers","Lodging per Traveler/per night","Flight Cost per Traveler","Vehicle Cost per Traveler","Per Diem per Traveler","Mileage Cost","Miscellaneous","Cost per Trip","Matching Contribution","Federal Request","Total","Used Federal Cost Estimation Tool? ","Basis of cost","Column1"]
["Digital Literacy Training\n\nFunds are requested for 2 employees to travel to X city for the Annual Digital Literacy Training series.\n\n","Domestic",5,2,210,120,100,201,146.25,60,4336.25,2850,1486.25,4336.25,"Yes","Lodging per Traveler/per night was calculated using the average price of X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nFlight per Traveler was calculated using the average price of an economy ticket from Y city to X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nVehicle per Traveler was calculated using the average price of a basic car rental in X city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $201 accounts for the cost of one traveler for one day. The total amount of costs allocated towards Per Diems can be reached by multiplying the Per Diem rate ($201) by the number of travelers (2) and the number of days (5): 201*2*5 = $2,010 Total for Per Diem.\n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Y city ($0.585 per mile) and multiplying it by the expected number of miles for the entire trip (250 miles): $0.59 * 250 = $146.25 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for X city."]
["Subgrantee Monitoring\n\nFunds are requested for 1 employee to travel to Z city to monitor subgrantee activities.","Domestic",2,1,150,0,100,79,120,30,795,397.5,397.5,795,"Yes","Lodging per Traveler/per night was calculated using the average price of Z city for the estimated monitoring dates. Figures are accurate as of application submission date. \n\nFlights will not be required.\n\nVehicle per Traveler was calculated using the average price of a basic car rental in Z city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $79 accounts for the cost of one traveler for one day. The total amount of costs allocated towards Per Diems can be reached by multiplying the Per Diem rate ($79) by the number of travelers (1) and the number of days (2): 79*1*2 = $158 Total for Per Diem.\n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Z city ($0.40 per mile) and multiplying it by the expected number of miles for the entire trip (300 miles): $0.40*300 = $120 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for Z city."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C32-1)*E32)*D32)+(D32*F32)+(D32*G32)+(D32*H32*C32)+I32+J32","v":0},null,{"$f":"K32-L32","v":0},{"$f":"L32+M32","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L30:L44)","v":3247.5},{"$f":"SUM(M30:M44)","v":1883.75},{"$f":"SUM(N30:N44)","v":5131.25}]
["Narrative (as needed)"]
["Digital Literacy Training costs will be 100% for programmatic purposes in support of Project A (no costs towards administration or evaluation). The applicant will provide match at the value of per diem ($201*2*5 = $2010) plus lodging ($210*4 = $840) (total match provided will be $2,850). \n\nThe Subgrantee Monitoring trip will be entirely for administrative purposes. The applicant will provide a 50% cash match for the trip ($795*0.5 = $397.5)."]
[]
[]
["C. Equipment"]
[]
[]
["Equipment Item","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"(B54*C54)-D54","v":0},{"$f":"D54+E54","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D54:D68)","v":0},{"$f":"SUM(E54:E68)","v":0},{"$f":"SUM(F54:F68)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["D. Supplies"]
[]
[]
["General Category of Supplies","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Office Supply Set",10,29.99,0,299.89999999999998,299.89999999999998,"Online listing at [list URL here]"]
[null,null,null,null,{"$f":"(B79*C79)-D79","v":0},{"$f":"D79+E79","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D78:D91)","v":0},{"$f":"SUM(E78:E91)","v":299.89999999999998},{"$f":"SUM(F78:F91)","v":299.89999999999998}]
["Narrative (as needed)"]
["Office supplies will be used by office staff to carry out project objectives. 100% of the supplies will go towards administrative costs."]
[]
[]
["E. Contractual-Subawards"]
[]
["CONTRACTORS"]
["Contractor Name / Organization","Project Description","Basis of cost","Value ($)","Federal Request","Total Cost","Column11","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Y City General Contractor","Y City General Contractor is a general contractor who will assist with building 1500 sq foot public access computing center additions across libraries in the county, as part of Project A.","Market research on general contractor quotes",750000,750000,750000,null,null,null,null,null,null,null,null,null,"Column10"]
["Digital Literacy Advisors, LLC","Digital Literacy Advisors, LLC will provide consultants to assist with digital literacy strategy development in support of Project C.","Market research on consultant quotes",400000,400000,400000,null,null,null,null,null,null,null,null,null,"Column11"]
[null,null,null,null,{"$f":"F103","v":0},{"$f":"D103","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E101:E121)","v":1150000},{"$f":"SUM(F101:F121)","v":1150000}]
[]
["SUBRECIPIENTS"]
["Subrecipient Name / Organization","Project Description","Value of Subaward ($)","Basis of Cost","Matching Contribution","Type (Cash, In-Kind, or N/A)","Source","Federal Request","Total Cost","Column8","Column1","Column2","Column3","Column4","Column5","Column6","Column7"]
["X City Public Library","This subrecipient will be responsible for administering the entirety of Project B.",700000,"Estimated cost of Project B",150000,"In-Kind","Subrecipient",700000,850000]
["State University","This subrecipient will be responsible for implementing the entirety of Project C.",750000,"Estimated cost of Project C",100000,"Cash","Subrecipient ",750000,850000]
[null,null,null,null,null,null,null,{"$f":"C128","v":0},{"$f":"(E128+H128)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(Table716[Matching Contribution])","v":250000},null,null,{"$f":"SUM(H126:H140)","v":1450000},{"$f":"SUM(I126:I140)","v":1700000}]
[]
["TOTAL CONTRACTUAL-SUBAWARDS",null,null,null,{"$f":"E141","v":250000},null,null,{"$f":"E122+H141","v":2600000},{"$f":"F122+I141","v":2850000}]
[]
[]
["Narrative (as needed)"]
["X City Public Library will provide in-kind contributions in terms of facilities valued at $150,000."]
[]
[]
["F. Construction"]
[]
[]
["Purpose","General Description","# of Items","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,null,{"$f":"(C154*D154)-E154","v":0},{"$f":"E154+F154","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL CONSTRUCTION",null,null,null,{"$f":"SUM(E154:E168)","v":0},{"$f":"SUM(F154:F168)","v":0},{"$f":"SUM(G154:G168)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["G. Other"]
[]
[]
["General Description","Quantity","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
["Project Management Training for Competitive Grant Program Staff",1,7200,3500,{"$f":"(B178*C178)-D178","v":3700},{"$f":"D178+E178","v":7200}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL OTHER",null,null,{"$f":"SUM(D178:D192)","v":3500},{"$f":"SUM(E178:E192)","v":3700},{"$f":"SUM(F178:F192)","v":7200}]
["Narrative (as needed)"]
["Annual Project Management Training conducted by XYZ Corporation or the Grant Manager. The training will cover project management areas necessary for the successful implementation and oversight of the Competitive Grant Program. The applicant will provide a $3,500 cash match."]
[]
[]
["H. Indirect"]
[]
[]
["General Description","Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9"]
["The applicant has a Federally-negotiated indirect cost rate agreement with an indirect cost rate of 13%. The indirect cost base is based on labor (salary and fringe benefits).","Period of Performance",190200,0.13,{"$f":"C202*D202","v":24726},null,{"$f":"E202-F202","v":24726},{"$f":"F202+G202","v":24726}]
[null,null,null,null,{"$f":"C203*D203","v":0},null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
["TOTAL INDIRECT",null,null,null,null,{"$f":"SUM(F202:F216)","v":0},{"$f":"SUM(G202:G216)","v":24726},{"$f":"SUM(H202:H216)","v":24726}]
["Narrative (as needed)"]
["The indirect cost base is the sum of all salaries ($180,000) and fringe benefits ($10,200) charged to the grant  during the grant year. The indirect costs are 100% administrative costs and will be subject to the administrative cost cap."]

{"sheet":"Year 3","index":4,"n_rows":215,"n_cols":17,"rows_kept":215,"cut":false,"hidden":false,"merged":[[194,2,194,7],[214,0,215,16],[4,3,4,11],[76,2,76,6],[95,0,96,16],[142,0,143,16],[166,0,167,16],[170,1,170,5],[190,0,191,16],[24,0,25,16],[28,3,28,15],[48,0,49,16],[52,2,52,6],[72,0,73,16],[120,0,120,16]]}
["Budget Detail - Year 3"]
[]
[]
["A. Personnel"]
[]
["Position Title","Key Personnel","Relevant Specific Project(s)","Level of Effort ","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Matching Contribution","Federal Request","Total ","Column2","Column3","Column4","Column5","Column6"]
["Grant Manager","Yes","Project A",1,"Annual",60000,60000,10200,0.17,0,70200,70200]
["Legal Staff","No",null,400,"Hour",300,120000,0,0,60000,60000,120000]
[null,null,null,null,null,null,{"$f":"D9*F9","v":0},{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,{"$f":"G9+H9-J9","v":0},{"$f":"J9+K9","v":0}]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D21*F21","v":0},{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D22*F22","v":0},{"$f":"Table1620[[#This Row],[Subtotal Salary]]*Table1620[[#This Row],[Fringe Rate]]","v":0},null,null,{"$f":"G22+H22-J22","v":0},0]
["TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(G7:G22)","v":180000},{"$f":"SUM(H7:H22)","v":10200},null,{"$f":"SUM(J7:J22)","v":60000},{"$f":"SUM(K7:K22)","v":130200},{"$f":"SUM(L7:L22)","v":190200}]
["Narrative (as needed)"]
["The Grant Manager (FTE) will be responsible for completing grant reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. The grant manager will spend 70% of their time ($70,200 x 0.70 = $49,140) on programmatic activities for Project A, 20% of their time ($70,200 x 0.20 = $14,040) on grants administration, and 10% of their time ($70,200 x 0.10 = $7,020) on evaluation. Fringe benefits for this employee include  health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges. \n\nLegal staff (FTE) will be responsible for drafting, execution, and filing fees of legal agreements and Memorandum of Understandings (MOUs) between organizations involved in the grant, including subgrantees. Legal hours also include time to conduct legal reviews for all contracts. Although this employee is FTE, they will only spend 70% of their time on Competitive Grant Program activities. The hourly rate has been prorated to reflect the division of effort ($428.57 * .7 = $300 pro-rated hourly rate). The legal staff will spend 100% of their time on grants administration. The applicant will provide $60,000 as a cash match to cover half of the legal staff's level of effort."]
[]
[]
["B. Travel"]
[]
[]
["Purpose of Travel/Justification of Need","Type of Travel (Domestic or International)","No. of Days","No. of Travelers","Lodging per Traveler/per night","Flight Cost per Traveler","Vehicle Cost per Traveler","Per Diem per Traveler","Mileage Cost","Miscellaneous","Cost per Trip","Matching Contribution","Federal Request","Total","Used Federal Cost Estimation Tool? ","Basis of cost","Column1"]
["Digital Literacy Training\n\nFunds are requested for 2 employees to travel to X city for the Annual Digital Literacy Training series.\n\n","Domestic",5,2,210,120,100,201,146.25,60,4336.25,2850,1486.25,4336.25,"Yes","Lodging per Traveler/per night was calculated using the average price of X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nFlight per Traveler was calculated using the average price of an economy ticket from Y city to X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nVehicle per Traveler was calculated using the average price of a basic car rental in X city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $201 accounts for the cost of one traveler for one day. \n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Y city ($0.585 per mile) and multiplying it by the expected number of miles for the entire trip (250 miles): $0.59 * 250 = $146.25 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for X city."]
["Subgrantee Monitoring\n\nFunds are requested for 1 employee to travel to Z city to monitor subgrantee activities.","Domestic",2,1,150,0,100,79,120,30,795,397.5,397.5,795,"Yes","Lodging per Traveler/per night was calculated using the average price of Z city for the estimated monitoring dates. Figures are accurate as of application submission date. \n\nFlights will not be required.\n\nVehicle per Traveler was calculated using the average price of a basic car rental in Z city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $79 accounts for the cost of one traveler for one day. \n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Z city ($0.40 per mile) and multiplying it by the expected number of miles for the entire trip (300 miles): $0.40*300 = $120 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for Z city."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C34-1)*E34)*D34)+(D34*F34)+(D34*G34)+(D34*H34*C34)+I34+J34","v":0},null,{"$f":"K34-L34","v":0},{"$f":"L34+M34","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L32:L46)","v":3247.5},{"$f":"SUM(M32:M46)","v":1883.75},{"$f":"SUM(N32:N46)","v":5131.25}]
["Narrative (as needed)"]
["Digital Literacy Training costs will be 100% for programmatic purposes in support of Project A (no costs towards administration or evaluation). The applicant will provide match at the value of per diem ($201*2*5 = $2010) plus lodging ($210*4 = $840) (total match provided will be $2,850). \n\nThe Subgrantee Monitoring trip will be entirely for administrative purposes. The applicant will provide a 50% cash match for the trip ($795*0.5 = $397.5)."]
[]
[]
["C. Equipment"]
[]
[]
["Equipment Item","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"(B56*C56)-D56","v":0},{"$f":"D56+E56","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D56:D70)","v":0},{"$f":"SUM(E56:E70)","v":0},{"$f":"SUM(F56:F70)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["D. Supplies"]
[null,null,"Computation"]
[]
["General Category of Supplies","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Office Supply Set",10,29.99,0,299.89999999999998,299.89999999999998,"Online listing at [list URL here]"]
[null,null,null,null,{"$f":"(B81*C81)-D81","v":0},{"$f":"D81+E81","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D80:D93)","v":0},{"$f":"SUM(E80:E93)","v":299.89999999999998},{"$f":"SUM(F80:F93)","v":299.89999999999998}]
["Narrative (as needed)"]
["Office supplies will be used by office staff to carry out project objectives. 100% of the supplies will go towards administrative costs."]
[]
[]
["E. Contractual-Subawards"]
[]
["CONTRACTORS"]
["Contractor Name / Organization","Project Description","Basis of cost","Value ($)","Federal Request","Total Cost","Column11","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Y City General Contractor","Y City General Contractor is a general contractor who will assist with building 1500 sq foot public access computing center additions across libraries in the county, as part of Project A.","Market research on general contractor quotes",250000,250000,250000,null,null,null,null,null,null,null,null,null,"Column10"]
["Digital Literacy Advisors, LLC","Digital Literacy Advisors, LLC will provide consultants to assist with digital literacy strategy development in support of Project C.","Market research on consultant quotes",400000,400000,400000,null,null,null,null,null,null,null,null,null,"Column11"]
[null,null,null,null,{"$f":"F105","v":0},{"$f":"D105","v":0},null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E103:E119)","v":650000},{"$f":"SUM(F103:F119)","v":650000}]
[]
["SUBRECIPIENTS"]
["Subrecipient Name / Organization","Project Description","Value of Subaward ($)","Basis of Cost","Matching Contribution","Type (Cash, In-Kind, or N/A)","Source","Federal Request","Total Cost","Column8","Column1","Column2","Column3","Column4","Column5","Column6","Column7"]
["X City Public Library","This subrecipient will be responsible for administering the entirety of Project B.",400000,"Estimated cost of Project B",150000,"In-Kind","Subrecipient",400000,550000]
["State University","This subrecipient will be responsible for implementing the entirety of Project C.",750000,"Estimated cost of Project C",100000,"Cash","Subrecipient ",750000,850000]
[null,null,null,null,null,null,null,{"$f":"C126","v":0},{"$f":"(E126+H126)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(Table71625[Matching Contribution])","v":250000},null,null,{"$f":"SUM(H124:H138)","v":1150000},{"$f":"SUM(I124:I138)","v":1400000}]
[]
["TOTAL CONTRACTUAL-SUBAWARDS",null,null,null,{"$f":"E139","v":250000},null,null,{"$f":"E120+H139","v":1800000},{"$f":"F120+I139","v":2050000}]
["Narrative (as needed)"]
["X City Public Library will provide in-kind contributions in terms of facilities valued at $150,000."]
[]
[]
["F. Construction"]
[]
[]
["Purpose","General Description","# of Items","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,null,{"$f":"(C150*D150)-E150","v":0},{"$f":"E150+F150","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL CONSTRUCTION",null,null,null,{"$f":"SUM(E150:E164)","v":0},{"$f":"SUM(F150:F164)","v":0},{"$f":"SUM(G150:G164)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["G. Other"]
[]
[]
["General Description","Quantity","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
["Project Management Training for Competitive Grant Program Staff",1,7200,3500,{"$f":"(B174*C174)-D174","v":3700},{"$f":"D174+E174","v":7200}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL OTHER",null,null,{"$f":"SUM(D174:D188)","v":3500},{"$f":"SUM(E174:E188)","v":3700},{"$f":"SUM(F174:F188)","v":7200}]
["Narrative (as needed)"]
["Annual Project Management Training conducted by XYZ Corporation or the Grant Manager. The training will cover project management areas necessary for the successful implementation and oversight of the Competitive Grant Program. The applicant will provide a $3,500 cash match."]
[]
[]
["H. Indirect"]
[]
[]
["General Description","Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9"]
["The applicant has a Federally-negotiated indirect cost rate agreement with an indirect cost rate of 13%. The indirect cost base is based on labor (salary and fringe benefits).","Period of Performance",190200,0.13,{"$f":"C198*D198","v":24726},null,{"$f":"E198-F198","v":24726},{"$f":"F198+G198","v":24726}]
[null,null,null,null,{"$f":"C199*D199","v":0},null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
["TOTAL INDIRECT",null,null,null,null,{"$f":"SUM(F198:F212)","v":0},{"$f":"SUM(G198:G212)","v":24726},{"$f":"SUM(H198:H212)","v":24726}]
["Narrative (as needed)"]
["The indirect cost base is the sum of all salaries ($180,000) and fringe benefits ($10,200) charged to the grant  during the grant year. The indirect costs are 100% administrative costs and will be subject to the administrative cost cap."]

{"sheet":"Year 4","index":5,"n_rows":210,"n_cols":17,"rows_kept":210,"cut":false,"hidden":false,"merged":[[189,2,189,7],[209,0,210,16],[4,3,4,11],[69,2,69,6],[89,0,90,16],[137,0,138,16],[161,0,162,16],[165,1,165,5],[185,0,186,16],[18,0,19,16],[22,3,22,15],[42,0,43,16],[46,2,46,6],[65,0,66,16]]}
["Budget Detail - Year 4"]
[]
[]
["A. Personnel"]
[]
["Position Title","Key Personnel","Relevant Specific Project(s)","Level of Effort","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Matching Contribution","Federal Request","Total ","Column2","Column3","Column4","Column5","Column6"]
["Grant Manager","Yes","Project A",1,"Annual",60000,60000,10200,0.17,0,70200,70200]
["Legal Staff","No",null,400,"Hour",300,120000,0,0,60000,60000,120000]
[null,null,null,null,null,null,{"$f":"D9*F9","v":0},{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,{"$f":"G9+H9-J9","v":0},{"$f":"J9+K9","v":0}]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D16*F16","v":0},{"$f":"Table129[[#This Row],[Subtotal Salary]]*Table129[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
["TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(G7:G16)","v":180000},{"$f":"SUM(H7:H16)","v":10200},null,{"$f":"SUM(J7:J16)","v":60000},{"$f":"SUM(K7:K16)","v":130200},{"$f":"SUM(L7:L16)","v":190200}]
["Narrative (as needed)"]
["The Grant Manager (FTE) will be responsible for completing grant reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. The grant manager will spend 70% of their time ($70,200 x 0.70 = $49,140) on programmatic activities for Project A, 20% of their time ($70,200 x 0.20 = $14,040) on grants administration, and 10% of their time ($70,200 x 0.10 = $7,020) on evaluation. Fringe benefits for this employee include  health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges. \n\nLegal staff (FTE) will be responsible for drafting, execution, and filing fees of legal agreements and Memorandum of Understandings (MOUs) between organizations involved in the grant, including subgrantees. Legal hours also include time to conduct legal reviews for all contracts. Although this employee is FTE, they will only spend 70% of their time on Competitive Grant Program activities. The hourly rate has been prorated to reflect the division of effort ($428.57 * .7 = $300 pro-rated hourly rate). The legal staff will spend 100% of their time on grants administration. The applicant will provide $60,000 as a cash match to cover half of the legal staff's level of effort."]
[]
[]
["B. Travel"]
[]
[]
["Purpose of Travel/Justification of Need","Type of Travel (Domestic or International)","No. of Days","No. of Travelers","Lodging per Traveler/per night","Flight Cost per Traveler","Vehicle Cost per Traveler","Per Diem per Traveler","Mileage Cost","Miscellaneous","Cost per Trip","Matching Contribution","Federal Request","Total","Used Federal Cost Estimation Tool? ","Basis of cost","Column1"]
["Digital Literacy Training\n\nFunds are requested for 2 employees to travel to X city for the Annual Digital Literacy Training series.\n\n","Domestic",5,2,210,120,100,201,146.25,60,4336.25,2850,1486.25,4336.25,"Yes","Lodging per Traveler/per night was calculated using the average price of X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nFlight per Traveler was calculated using the average price of an economy ticket from Y city to X city for the planned kick-off dates. Figures are accurate as of application submission date. \n\nVehicle per Traveler was calculated using the average price of a basic car rental in X city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $201 accounts for the cost of one traveler for one day. \n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Y city ($0.585 per mile) and multiplying it by the expected number of miles for the entire trip (250 miles): $0.59 * 250 = $146.25 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for X city."]
["Subgrantee Monitoring\n\nFunds are requested for 1 employee to travel to Z city to monitor subgrantee activities.","Domestic",2,1,150,0,100,79,120,30,795,397.5,397.5,795,"Yes","Lodging per Traveler/per night was calculated using the average price of Z city for the estimated monitoring dates. Figures are accurate as of application submission date. \n\nFlights will not be required.\n\nVehicle per Traveler was calculated using the average price of a basic car rental in Z city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $79 accounts for the cost of one traveler for one day. \n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Z city ($0.40 per mile) and multiplying it by the expected number of miles for the entire trip (300 miles): $0.40*300 = $120 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for Z city."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C28-1)*E28)*D28)+(D28*F28)+(D28*G28)+(D28*H28*C28)+I28+J28","v":0},null,{"$f":"K28-L28","v":0},{"$f":"L28+M28","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L26:L40)","v":3247.5},{"$f":"SUM(M26:M40)","v":1883.75},{"$f":"SUM(N26:N40)","v":5131.25}]
["Narrative (as needed)"]
["Digital Literacy Training costs will be 100% for programmatic purposes in support of Project A (no costs towards administration or evaluation). The applicant will provide match at the value of per diem ($201*2*5 = $2010) plus lodging ($210*4 = $840) (total match provided will be $2,850). \n\nThe Subgrantee Monitoring trip will be entirely for administrative purposes. The applicant will provide a 50% cash match for the trip ($795*0.5 = $397.5)."]
[]
[]
["C. Equipment"]
[]
[]
["Equipment Item","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"(B50*C50)-D50","v":0},{"$f":"D50+E50","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D50:D63)","v":0},{"$f":"SUM(E50:E63)","v":0},{"$f":"SUM(F50:F63)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["D. Supplies"]
[]
[]
["General Category of Supplies","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Office Supply Set",10,29.99,0,299.89999999999998,299.89999999999998,"Online listing at [list URL here]"]
[null,null,null,null,{"$f":"(B74*C74)-D74","v":0},{"$f":"D74+E74","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D73:D87)","v":0},{"$f":"SUM(E73:E87)","v":299.89999999999998},{"$f":"SUM(F73:F87)","v":299.89999999999998}]
["Narrative (as needed)"]
["Office supplies will be used by office staff to carry out project objectives. 100% of the supplies will go towards administrative costs."]
[]
[]
["E. Contractual-Subawards"]
[]
["CONTRACTORS"]
["Contractor Name / Organization","Project Description","Basis of cost","Value ($)","Federal Request","Total Cost","Column11","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
["Y City General Contractor","Y City General Contractor is a general contractor who will assist with building 1500 sq foot public access computing center additions across libraries in the county, as part of Project A.","Market research on general contractor quotes",100000,100000,100000,null,null,null,null,null,null,null,null,null,"Column10"]
["Digital Literacy Advisors, LLC","Digital Literacy Advisors, LLC will provide consultants to assist with digital literacy strategy development in support of Project C.","Market research on consultant quotes",400000,400000,400000,null,null,null,null,null,null,null,null,null,"Column11"]
[null,null,null,null,{"$f":"F99","v":0},{"$f":"D99","v":0},null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0,null,null,null,null,null,null,null,null,"Column8","Column9","Column10"]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E97:E113)","v":500000},{"$f":"SUM(F97:F113)","v":500000}]
[]
["SUBRECIPIENTS"]
["Subrecipient Name / Organization","Project Description","Value of Subaward ($)","Basis of Cost","Matching Contribution","Type (Cash, In-Kind, or N/A)","Source","Federal Request","Total Cost","Column8","Column1","Column2","Column3","Column4","Column5","Column6","Column7"]
["X City Public Library","This subrecipient will be responsible for administering the entirety of Project B.",400000,"Estimated cost of Project B",150000,"In-Kind","Subrecipient",400000,550000]
["State University","This subrecipient will be responsible for implementing the entirety of Project C.",750000,"Estimated cost of Project C",100000,"Cash","Subrecipient ",750000,850000]
[null,null,null,null,null,null,null,{"$f":"C120","v":0},{"$f":"(E120+H120)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(Table734[Matching Contribution])","v":250000},null,null,{"$f":"SUM(H118:H133)","v":1150000},{"$f":"SUM(I118:I133)","v":1400000}]
[]
["TOTAL CONTRACTUAL-SUBAWARDS",null,null,null,{"$f":"E134","v":250000},null,null,{"$f":"E114+H134","v":1650000},{"$f":"F114+I134","v":1900000}]
["Narrative (as needed)"]
["X City Public Library will provide in-kind contributions in terms of facilities valued at $150,000."]
[]
[]
["F. Construction"]
[]
[]
["Purpose","General Description","# of Items","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,null,{"$f":"(C145*D145)-E145","v":0},{"$f":"E145+F145","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL CONSTRUCTION",null,null,null,{"$f":"SUM(E145:E159)","v":0},{"$f":"SUM(F145:F159)","v":0},{"$f":"SUM(G145:G159)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["G. Other"]
[]
[]
["General Description","Quantity","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
["Project Management Training for Competitive Grant Program Staff",1,7200,3500,{"$f":"(B169*C169)-D169","v":3700},{"$f":"D169+E169","v":7200}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL OTHER",null,null,{"$f":"SUM(D169:D183)","v":3500},{"$f":"SUM(E169:E183)","v":3700},{"$f":"SUM(F169:F183)","v":7200}]
["Narrative (as needed)"]
["Annual Project Management Training conducted by XYZ Corporation or the Grant Manager. The training will cover project management areas necessary for the successful implementation and oversight of the Competitive Grant Program. The applicant will provide a $3,500 cash match."]
[]
[]
["H. Indirect"]
[]
[]
["General Description","Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9"]
["The applicant has a Federally-negotiated indirect cost rate agreement with an indirect cost rate of 13%. The indirect cost base is based on labor (salary and fringe benefits).","Period of Performance",190200,0.13,{"$f":"C193*D193","v":24726},null,{"$f":"E193-F193","v":24726},{"$f":"F193+G193","v":24726}]
[null,null,null,null,{"$f":"C194*D194","v":0},null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
["TOTAL INDIRECT",null,null,null,null,{"$f":"SUM(F193:F207)","v":0},{"$f":"SUM(G193:G207)","v":24726},{"$f":"SUM(H193:H207)","v":24726}]
["Narrative (as needed)"]
["The indirect cost base is the sum of all salaries ($180,000) and fringe benefits ($10,200) charged to the grant  during the grant year. The indirect costs are 100% administrative costs and will be subject to the administrative cost cap."]

{"sheet":"(Optional) Year 5 - Evaluation","index":6,"n_rows":221,"n_cols":17,"rows_kept":221,"cut":false,"hidden":false,"merged":[[76,0,77,16],[4,3,4,11],[28,0,29,16],[32,3,32,15],[52,0,53,16],[56,2,56,6],[201,2,201,7],[221,0,222,16],[80,2,80,6],[100,0,101,16],[148,0,149,16],[173,0,174,16],[177,1,177,5],[197,0,198,16],[124,0,124,16]]}
["Budget Detail - (Optional) Year 5 - Evaluation Period"]
[]
[]
["A. Personnel"]
[]
["Position Title","Key Personnel","Relevant Specific Project(s)","Level of Effort","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Matching Contribution","Federal Request","Total ","Column2","Column3","Column4","Column5","Column6"]
["Grant Manager","Yes","Project A, Project B, Project C",1,"Annual",50000,{"$f":"D7*F7","v":50000},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":8500},0.17,25000,{"$f":"G7+H7-J7","v":33500},{"$f":"J7+K7","v":58500}]
[null,null,null,null,null,null,{"$f":"D8*F8","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,0,{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D22*F22","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D23*F23","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D24*F24","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D25*F25","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
[null,null,null,null,null,null,{"$f":"D26*F26","v":0},{"$f":"Table12941[[#This Row],[Subtotal Salary]]*Table12941[[#This Row],[Fringe Rate]]","v":0},null,null,0,0]
["TOTAL PERSONNEL",null,null,null,null,null,{"$f":"SUM(G7:G26)","v":50000},{"$f":"SUM(H7:H26)","v":8500},null,{"$f":"SUM(J7:J26)","v":25000},{"$f":"SUM(K7:K26)","v":33500},{"$f":"SUM(L7:L26)","v":58500}]
["Narrative (as needed)"]
["The Grant Manager (FTE) will be responsible for all activities related to project evaluation, including compiling, reconciling, and managing the submission of reports and documents. The grant manager will spend 100% of their time on evaluation. Fringe benefits for this employee include  health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges. "]
[]
[]
["B. Travel"]
[]
[]
["Purpose of Travel/Justification of Need","Type of Travel (Domestic or International)","No. of Days","No. of Travelers","Lodging per Traveler/per night","Flight Cost per Traveler","Vehicle Cost per Traveler","Per Diem per Traveler","Mileage Cost","Miscellaneous","Cost per Trip","Matching Contribution","Federal Request","Total","Used Federal Cost Estimation Tool? ","Basis of cost","Column1"]
["Project Evaluation\n\nFunds are requested for 1 employee to travel to Z city to evaluate project outcomes.","Domestic",2,1,150,0,100,79,120,30,{"$f":"(((C36-1)*E36)*D36)+(D36*F36)+(D36*G36)+(D36*H36*C36)+I36+J36","v":558},null,{"$f":"K36-L36","v":558},{"$f":"L36+M36","v":558},null,"Lodging per Traveler/per night was calculated using the average price of Z city for the estimated monitoring dates. Figures are accurate as of application submission date. \n\nFlights will not be required.\n\nVehicle per Traveler was calculated using the average price of a basic car rental in Z city. The total includes the flat price of the vehicle itself ($90) and insurance ($10): $90 + $10 = $100 Total Cost for Vehicle per Traveler). \n\nPer Diem per Traveler was calculated using the current GSA rates (https://www.gsa.gov/travel/plan-book/per-diem-rates). The listed $79 accounts for the cost of one traveler for one day. \n\nMileage was calculated using the accompanying per mile cost for a basic car rental in Z city ($0.40 per mile) and multiplying it by the expected number of miles for the entire trip (300 miles): $0.40*300 = $120 Mileage cost for the trip. \n\nMiscellaneous costs account for potential variable costs such as parking, internet access, etc. with rates researched online for Z city."]
[null,null,null,null,null,null,null,null,null,null,{"$f":"(((C37-1)*E37)*D37)+(D37*F37)+(D37*G37)+(D37*H37*C37)+I37+J37","v":0},null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
[null,null,null,null,null,null,null,null,null,null,0,null,0,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L36:L50)","v":0},{"$f":"SUM(M36:M50)","v":558},{"$f":"SUM(N36:N50)","v":558}]
["Narrative (as needed)"]
[]
[]
[]
["C. Equipment"]
[]
[]
["Equipment Item","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"(B60*C60)-D60","v":0},{"$f":"D60+E60","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D60:D74)","v":0},{"$f":"SUM(E60:E74)","v":0},{"$f":"SUM(F60:F74)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["D. Supplies"]
[]
[]
["General Category of Supplies","Qty","Unit Cost         ","Matching Contribution","Federal Request","Total Cost","Basis of Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"(B84*C84)-D84","v":0},{"$f":"D84+E84","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D84:D98)","v":0},{"$f":"SUM(E84:E98)","v":0},{"$f":"SUM(F84:F98)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["E. Contractual-Subawards"]
[]
["CONTRACTORS"]
["Contractor Name / Organization","Project Description","Basis of cost","Value ($)","Federal Request","Total Cost","Column11","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,{"$f":"F108","v":0},{"$f":"D108","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E108:E123)","v":0},{"$f":"SUM(F108:F123)","v":0}]
[]
["SUBRECIPIENTS"]
["Subrecipient Name / Organization","Project Description","Value of Subaward ($)","Basis of Cost","Matching Contribution","Type (Cash, In-Kind, or N/A)","Source","Federal Request","Total Cost","Column8","Column1","Column2","Column3","Column4","Column5","Column6","Column7"]
[null,null,null,null,null,null,null,{"$f":"C128","v":0},{"$f":"(E128+H128)","v":0}]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,0,0]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(Table73446[Matching Contribution])","v":0},null,null,{"$f":"SUM(H128:H144)","v":0},{"$f":"SUM(I128:I144)","v":0}]
[]
["TOTAL CONTRACTUAL-SUBAWARDS",null,null,null,{"$f":"E145","v":0},null,null,{"$f":"E124+H145","v":0},{"$f":"F124+I145","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["F. Construction"]
[]
[]
["Purpose","General Description","# of Items","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10"]
[null,null,null,null,null,{"$f":"(C156*D156)-E156","v":0},{"$f":"E156+F156","v":0}]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
[null,null,null,null,null,0,0]
["TOTAL CONSTRUCTION",null,null,null,{"$f":"SUM(E156:E171)","v":0},{"$f":"SUM(F156:F171)","v":0},{"$f":"SUM(G156:G171)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["G. Other"]
[]
[]
["General Description","Quantity","Cost","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11"]
[null,null,null,null,{"$f":"(B181*C181)-D181","v":0},{"$f":"D181+E181","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
["TOTAL OTHER",null,null,{"$f":"SUM(D181:D195)","v":0},{"$f":"SUM(E181:E195)","v":0},{"$f":"SUM(F181:F195)","v":0}]
["Narrative (as needed)"]
[]
[]
[]
["H. Indirect"]
[]
[]
["General Description","Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Matching Contribution","Federal Request","Total Cost","Column1","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9"]
[null,null,null,null,{"$f":"C205*D205","v":0},null,{"$f":"E205-F205","v":0},{"$f":"F205+G205","v":0}]
[null,null,null,null,{"$f":"C206*D206","v":0},null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
[null,null,null,null,0,null,0,0]
["TOTAL INDIRECT",null,null,null,null,{"$f":"SUM(F205:F219)","v":0},{"$f":"SUM(G205:G219)","v":0},{"$f":"SUM(H205:H219)","v":0}]
["Narrative (as needed)"]

{"sheet":"Matching","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[14,0,15,5],[1,0,1,5]]}
["Matching"]
["Record the cash or cash value of any intended instances of matching proposed by the eligible entity or by third party contributors in the table below. Please do NOT enter any matching funding provided by a subrecipient on this tab. All matching funding provided by a subrecipient should be entered within the \"SUBRECIPIENTS\" section on the Years 1-4 and (Optional) Year 5 - Evaluation tabs."]
[]
["Organization/Source","Type","Cost Share Item/Description (Required for In-Kind Match) \nE.g., use of a facility, providing tablets to be used in Project A, etc.","Source Type","Value","Share Value of Total Award Cost"]
["Applicant","Cash","N/A","Local",291990,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":2.7434331147426883E-2}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
[null,null,null,null,null,{"$f":"IFERROR(Table37[[#This Row],[Value]]/('Budget Overview'!$S$20),0)","v":0}]
["TOTAL MATCHING",null,null,null,{"$f":"SUM(Table37[Value])","v":291990},{"$f":"SUM(Table37[Share Value of Total Award Cost])","v":2.7434331147426883E-2}]
["Narrative (as needed)"]

{"sheet":"Related Outside Funding","index":8,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,4],[11,0,12,4]]}
["Related Outside Funding"]
["Record the source and amount of other Federal, State, or outside funding sources the entity receives, or has applied for, that fund the activities or projects to which the application relates. This includes any funding requests through the Digital Equity Capacity Grant Program, the Tribal Broadband Connectivity Program (TBCP), and the Broadband Equity Access and Deployment (BEAD) Program. Please see Section IV B (15) of the DE Competitive NOFO for more information."]
[]
["Organization/Source","Funding Description","Source Type","Received / Anticipated (i.e., applied for)","Amount"]
["National Telecommunications and Information Administration","Applied to be a subrecipient of the State Digital Equity Capacity Grant Program in X state.","Federal","Anticipated",500000]
[]
[]
[]
[]
["TOTAL RELATED OUTSIDE FUNDING",null,null,null,{"$f":"SUM(Table39[Amount])","v":500000}]
["Narrative (as needed)"]
["The activities proposed in our application to be a subrecipient to the State Digital Equity Capacity Grant focus on online safety trainings which supplements but does not supplant the activities proposed in this application. "]

{"sheet":"Projects Overview","index":9,"n_rows":22,"n_cols":16,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,0,1,15],[3,19,3,25],[3,3,3,5],[3,6,3,8],[3,9,3,11],[3,12,3,14]]}
["Projects Overview"]
["List all of the projects included in your application (i.e., the discrete activities/interventions to be implemented) below, and provide budget information that will be allocated to that project for each project year. Note that the information on this tab is not calculated based on other entries and must be manually input below. The Total Amount Allocated is the total amount of funding designated for the specific project in each Project Year. The Amount to be Subgranted is the amount of funding designated for the specific project that will be subgranted for each Project Year. The Total Amount to be Implemented Directly is the total amount of funding the eligible entity intends to implement without subgranted funds designated for the specific project for each Project Year."]
[]
[null,null,null,"Project Year 1",null,null,"Project Year 2",null,null,"Project Year 3",null,null,"Project Year 4",null,null,"TOTAL"]
["Project Name","Project ID","Brief Project Description","Total Amount Allocated","Amount to be Subgranted","Amount to be Implemented Directly","Total Amount Allocated ","Amount to be Subgranted ","Amount to be Implemented Directly "," Total Amount Allocated"," Amount to be Subgranted"," Amount to be Implemented Directly"," Total Amount Allocated "," Amount to be Subgranted "," Amount to be Implemented Directly "," Total Amount Allocated  "]
["Project A","LeadApplicant-01","Narrative",814609.4,0,814609.4,803476.25,0,803476.25,303476.25,0,303476.25,153476.25,0,153476.25,{"$f":"SUM(D6,G6,J6,M6)","v":2075038.15}]
["Project B",null,null,850000,850000,0,850000,850000,0,550000,550000,null,550000,550000,null,2800000]
["Project C",null,null,1250000,850000,400000,1250000,850000,400000,1250000,850000,400000,1250000,850000,400000,5000000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Totals",null,null,{"$f":"SUM(Table3850[Total Amount Allocated])","v":2914609.4},{"$f":"SUM(Table3850[Amount to be Subgranted])","v":1700000},{"$f":"SUM(Table3850[Amount to be Implemented Directly])","v":1214609.3999999999},{"$f":"SUM(Table3850[[Total Amount Allocated ]])","v":2903476.25},{"$f":"SUM(Table3850[[Amount to be Subgranted ]])","v":1700000},{"$f":"SUM(Table3850[[Amount to be Implemented Directly ]])","v":1203476.25},{"$f":"SUM(Table3850[[ Total Amount Allocated]])","v":2103476.25},{"$f":"SUM(Table3850[[ Amount to be Subgranted]])","v":1400000},{"$f":"SUM(Table3850[[ Amount to be Implemented Directly]])","v":703476.25},{"$f":"SUM(Table3850[[ Total Amount Allocated ]])","v":1953476.25},{"$f":"SUM(Table3850[[ Amount to be Subgranted ]])","v":1400000},{"$f":"SUM(Table3850[[ Amount to be Implemented Directly ]])","v":553476.25},{"$f":"SUM(Table3850[[ Total Amount Allocated  ]])","v":9875038.1500000004}]