{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Report Flowchart","Setup","CSA Cost Worksheet","CSA Budget Worksheet","SubcontractConsultant Worksheet","Subawards Worksheet","Indirect Cost Rate Worksheet","Program Expenditures Worksheet","Accounting Notes Worksheet","Certificate of Costs","State","CSAType"],"not_rendered":{"images":3,"macros":1,"external_links":1,"defined_names":33},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"merged":[[1,1,1,2],[2,1,2,2],[5,2,6,8],[8,2,8,8],[9,2,9,8],[10,2,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,7],[14,2,14,8],[15,2,15,8],[16,2,16,8]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Instructions"]
[]
[null,null,"OVERVIEW"]
[null,null,"This Financial Data Collection Tool  was designed by the National Science Foundation (NSF) to assist recipients in submitting substantiated program expenditures for construction and operations and management costs for its large facility cooperative agreements (CAs) and cooperative support agreements (CSAs) over $100 million and may be comprised of several different CA and CSAs funded by multiple appropriations. This user-friendly reporting tool is comprised of several worksheets that enable recipients to submit adequate incurred program expenditures in accordance with NSF terms and conditions and the Large Facilities Manual. This reporting tool was instituted to ensure that funds for large facilities are properly expended and managed.  The tool has color coded cells which will assist the user.  Yellow cells are manually filled in by the user, Blue cells are linked from other worksheets and Gray cells are auto calculated.  Once this data tool is completed, the recipient must submit it to the cognizant Grants Officer 60 days after the end of the current funding year (current performance period).  For example, If your agreement's award year runs from October 1, through September 30, you will submit this completed Data Collection Tool to your NSF Grants and Agreements Officer by November 30, each year for the 12-month funding period ended September 30."]
[]
[null,null,"WORKSHEET PREPARATION"]
[null,null,"Prior to completing the worksheets, retrieve a breakdown of federal funding (budget) for each cooperative agreement (CA) and for each cooperative support agreement (CSA), and a breakdown of all expenditures claimed for each CA and CSA. Suggested sources for this data include your Chart of Accounts, General Ledger, Project Cost Ledger, CA and CSA award budgets, subcontracts/vendors, consultants and subawards information, and your negotiated indirect cost rate agreement (NICRA). Please do not change the names of any existing worksheets or delete columns or rows on existing worksheets. In addition, the following guidance is provided for completing each tab of this worksheet. This financial data will not tie to any other report submitted to NSF."]
[null,null,"Setup: Complete this tab first as it will customize this reporting tool for your award. Input your institution and award data as requested. Your award data should agree with the information listed in your CA and subsequent CSA(s). Once you have entered all the required information including the number of CSAs in the Award Data box and select \"RUN SETUP\" you will start to enter information into each of the tabs starting with the CSA Cost Worksheet and then the CSA Budget Worksheet and then the Subcontract/Consultant Worksheet etc. Go in order of the worksheets from left to right."]
[null,null,"Cooperative Support Agreement Cost Worksheet: The purpose of the CSA Cost Worksheet is to perform a reconciliation of costs from the General Ledger to the Job Cost Ledger for all award CSAs.  A separate CSA worksheet will be created for each CSA based on the number entered in the Setup tab under the Award Data Section. Enter the number of CSAs in your award and a new worksheet will be created once you hit \"Run Setup\".  Input your current year expenditures from your General Ledger, Job Cost Ledger and any adjustments in each of the cost categories.  If there is a difference between the General Ledger and Job Cost Ledger on the CSA Cost Worksheet, provide an explanation in the comments field. Add any additional comments which can provide clarity or explanation to the reviewer on costs.  * Contingency Funds and Management Fee must be included in the Other Direct Costs: Other and a note added below. **Program Income should not be included in your costs but provided on the Program Income Reporting Worksheet per the \"Proposal and Awards Policies and Procedures Guide\" (PAPPG).\n"]
[null,null,"Cooperative Support Agreement Budget Worksheet: The CSA Budget Worksheet captures the reported costs for each of the major cost elements for each CSA (for the cumulative approved budget to date and cumulative expenditures to date). These costs are compared to approved budgets for each CSA to indicate the amount remaining for each budget category. Input your cumulative to date approved NSF budget in each of the cost categories and your expenditures to date.  *Contingency Funds and Management Fee must be included in the Other Direct Costs: Other and a note added below. **Program Income should not be included in your costs but provided on the Program Income Reporting Worksheet per the PAPPG.\n\n"]
[null,null,"Subcontract & Consultants Worksheet: The Subcontracts and Consultants Worksheet provides details of costs for each subcontract/consultant identified by the recipient. A subcontract or consultant is for the purpose of obtaining goods and services and creates a procurement relationship with the contractor. Information is to be provided for all subcontracts/consultants. Make sure you enter the subcontract type.  Add any other important information in the Recipient Preparation Notes.  If you have more subcontracts than 21, please submit the same information for the additional subcontracts on a separate word or Excel document and submit it with this report."]
[null,null,"Subawards Worksheet: The Subawards Worksheet provides details of costs for each subaward identified by the recipient.  A Subaward means an award provided by a pass-through entity to a subrecipient for the subrecipient to carry out part of a Federal award received by the pass-through entity. It does not include payments to a contractor or payments to an individual that is a beneficiary of a Federal program. A subaward may be provided through any form of legal agreement, including an agreement that the pass-through entity considers a contract. Information is to be provided for all subawards.  Add any other important information in the Recipient Preparation Notes.  If you have more subcontracts than 21, please submit the same information for the additional subcontracts on a separate word or Excel document and submit it with this report."]
[null,null,"Indirect Cost Rate Worksheet: The purpose of the Indirect Cost Rate Worksheet is to capture details associated with the indirect cost rates. The schedule of indirect cost includes the period of performance start and end dates, the base amount, and rate applied for each identified rate type such as F&A, G&A or other specified.  "]
[null,null,"Program Expenditures Worksheet: The purpose of the Program Expenditures Worksheet is to capture a summary of award expenditures as consolidated from the recipient’s General Ledger/Trial Balance. This summary also shows a summary of expenditures as compared to the approved budget for the entire CA."]
[null,null,"Certificate of Costs: The Certificate of Costs tab requests recipients to certify that all data is accurate and based upon official records used by the recipient to record all expenditures for its CA and CSAs. The \"Validate\" button will identify any input errors that need to be corrected before submitting."]
[null,null,"REPORT PREPARATION NOTES"]
[null,null,"1. Macros must be enabled in order for this data collection tool to work properly"]
[null,null,"2. Throughout this workbook, the cells that are intended for data entry by the recipient are shaded a light yellow. All other cells (blue or gray) are linked/protected based on other cell data"]
[null,null,"3. Double check all data on all worksheets before submitting to NSF"]
[null,null,"4. All worksheet tabs are required to be completed unless instructed otherwise by NSF"]
[null,null,"5. Be sure to save your progress as go complete the tool"]
[null,null,"6. Press the \"Validate\" button on the \"Certificate of Costs\" tab in order to finalize the data"]

{"sheet":"Report Flowchart","index":1,"n_rows":5,"n_cols":3,"rows_kept":5}
[]
[null,null,"Large Facility Financial Data Collection Tool"]
[null,null,"Flowchart"]
[]
[null,"    ","This process diagram indicates the steps to complete the data collection tool. It identifies the core data sources recipients should utilize to complete the worksheets to accurately capture the data. Progressing through the tool's worksheets from left to right will streamline the data capture and submission process."]

{"sheet":"Setup","index":2,"n_rows":68,"n_cols":6,"rows_kept":68,"merged":[[1,1,1,6],[2,1,2,2],[7,3,7,11],[8,3,8,11],[9,3,9,11],[10,3,10,11],[11,3,11,11],[12,3,12,11],[14,3,14,11],[15,3,15,11],[16,3,16,11],[17,3,17,11],[24,3,24,11],[25,3,25,11],[29,3,29,11],[30,3,30,11],[31,3,31,11],[32,3,32,11],[33,3,33,11],[38,1,39,1],[40,1,41,1],[42,1,43,1],[44,1,45,1],[46,1,47,1],[48,1,49,1],[50,1,51,1],[52,1,53,1],[54,1,55,1],[60,5,61,7],[62,6,62,7],[63,6,63,7],[66,6,66,7],[67,6,67,7]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Setup"]
[null,"This Setup information will be used to customize the reporting tool to reflect your award. After completing all information on this tab click the \"Run "]
[null,"Setup\" button at the bottom to complete the customization. Note: The \"Run Setup\" button can only be selected once; if you need to correct "]
["    ","setup data after the \"Run Setup\" button is clicked, you will need to open a new file of this tool and begin again."]
[null,null,"INSTITUTION DATA"]
[null,null,"Recipient Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Website:"]
[null,null,"AWARD DATA"]
[null,null,"CA Award Number:","Enter CA number as listed on your CA award letter"]
[null,null,"Project Title:","Enter the project title as listed on your CA"]
[null,null,"Name of Facility:"]
[null,null,"CFDA Number:","Enter number listed on the CA/CSA award letter"]
[null,null,"Recipient Fiscal Year Start:"]
[null,null,"Recipient Fiscal Year End:"]
[null,null,"CA Period of Performance Start:"]
[null,null,"CA Period of Performance End:"]
[null,null,"Reporting Period Start:"]
[null,null,"Reporting Period End:"]
[null,null,"Total Award Amount:","Enter amount of all CA/CSA awards"]
[null,null,"Funded to Date Amount:"]
[null,null,"No. of CSAs:"]
[]
[null,null,"POC DATA"]
[null,null,"First Name:"]
[null,null,"Last Name:"]
[null,null,"Title:"]
[null,null,"Phone No.:"]
[null,null,"Email:"]
[]
[null,null,"SUBCONTRACT/SUBAWARD DATA"]
[null,null,"CSA's:","# of Subcontracts","# of Subawards"]
[null,null,"CSA 1",0,0]
[null,null,"CSA 2",0,0]
[null,null,"CSA 3",0,0]
[null,null,"CSA 4",0,0]
[null,null,"CSA 5",0,0]
[null,null,"CSA 6",0,0]
[null,null,"CSA 7",0,0]
[null,null,"CSA 8",0,0]
[null,null,"CSA 9",0,0]
[null,null,"CSA 10",0,0]
[null,null,"CSA 11",0,0]
[null,null,"CSA 12",0,0]
[null,null,"CSA 13",0,0]
[null,null,"CSA 14",0,0]
[null,null,"CSA 15",0,0]
[null,null,"CSA 16",0,0]
[null,null,"CSA 17",0,0]
[null,null,"CSA 18",0,0]
[null,null,"CSA 19",0,0]
[null,null,"CSA 20",0,0]
[]
[]
[null,null,"INDIRECT COST RATE DATA"]
[null,null,"F&A",null,null,"If Other type of Indirect Cost Rate, list name below:"]
[null,null,"G&A"]
[null,null,"Other",null,null,"Name 1:"]
[{"$nulls":5},"Name 2:"]
[{"$nulls":5},"Name 3:"]
[{"$nulls":5},"Name 4:"]
[{"$nulls":5},"Name 5:"]
[{"$nulls":5},"Name 6:"]

{"sheet":"CSA Cost Worksheet","index":3,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[1,1,1,3],[4,1,4,3],[6,1,6,3],[10,3,10,7],[35,1,35,7],[36,1,36,7],[38,1,38,2],[39,1,39,6]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Cooperative Support Agreement Cost Worksheet",{"$nulls":3},"Yellow Cells:","Manual fill by user"]
[{"$nulls":5},"Blue Cells:","Linked from other worksheets"]
["    ","Recipient Name (pull from set up)",{"$nulls":3},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)",{"$nulls":3},"Report Period Start:"]
[{"$nulls":5},"Report Period End:"]
[]
[]
[{"$nulls":3},"Reconciliation of Claimed Expenditures to Job Cost Ledger"]
[null,null,"Select CSA Type"]
[null,null,"Enter CSA #","General Ledger","Job Cost Ledger","Adjustment","Current Expenditures","Comment"]
[null,null,"Claimed Direct Costs\nby Budget Category"]
[null,null,"Senior Personnel",0,0,0,{"$f":"D15+F15","v":0}]
[null,null,"Other Personnel",0,0,0,{"$f":"D16+F16","v":0}]
[null,null,"Total Salaries and Wages",{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":0},{"$f":"SUM(F15:F16)","v":0},{"$f":"SUM(G15:G16)","v":0}]
[null,null,"Fringe Benefits",0,0,0,{"$f":"D18+F18","v":0}]
[null,null,"Total Salaries/Wages/Benefits",{"$f":"SUM(D17:D18)","v":0},{"$f":"SUM(E17:E18)","v":0},{"$f":"SUM(F17:F18)","v":0},{"$f":"SUM(G17:G18)","v":0}]
[null,null,"Equipment",0,0,0,{"$f":"D20+F20","v":0}]
[null,null,"Travel",0,0,0,{"$f":"D21+F21","v":0}]
[null,null,"Participant Support",0,0,0,0]
[null,null,"Other Direct Costs: Materials and Supplies",0,0,0,0]
[null,null,"Other Direct Costs: Publication/Documentation/Dissemination",0,0,0,0]
[null,null,"Other Direct Costs: Consultant Services",0,0,0,0]
[null,null,"Other Direct Costs: Computer Services",0,0,0,0]
[null,null,"Other Direct Costs: Subawards",0,0,0,0]
[null,null,"Other Direct Costs: Other",0,0,0,0]
[null,null,"Total Other Direct Costs",{"$f":"SUM(D23:D28)","v":0},{"$f":"SUM(E23:E28)","v":0},{"$f":"SUM(F23:F28)","v":0},{"$f":"SUM(G23:G28)","v":0}]
[null,null,"Total Direct Costs",{"$f":"SUM(D19:D28)","v":0},{"$f":"SUM(E19:E28)","v":0},{"$f":"SUM(F19:F28)","v":0},{"$f":"SUM(G19:G28)","v":0}]
[null,null,"Indirect Costs: F&A",0,0,0,{"$f":"D31+F31","v":0}]
[null,null,"Indirect Costs: G&A",0,0,0,{"$f":"D32+F32","v":0}]
[null,null,"Indirect Costs: Name",0,0,0,0]
[null,null,"Total Indirect Costs:",{"$f":"SUM(D31:D33)","v":0},{"$f":"SUM(E31:E33)","v":0},{"$f":"SUM(F31:F33)","v":0},{"$f":"SUM(G31:G33)","v":0}]
[null,null,"Total Direct and Indirect Costs:",{"$f":"SUM(D30,D34)","v":0},{"$f":"SUM(E30,E34)","v":0},0,{"$f":"SUM(G30,G34)","v":0}]
[null,"* Contingency Funds and Management Fee must be included in the Other Direct Costs: Other and a note added below."]
[null,"**Program Income should not be included in your costs but provided on the Program Income Reporting Worksheet per the PAPPG."]
[]
[null,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or the data submitted for this worksheet."]

{"sheet":"CSA Budget Worksheet","index":4,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[1,1,1,3],[4,1,4,3],[6,1,6,3],[10,3,10,6],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[35,3,35,6],[36,1,36,6],[37,1,37,6],[39,1,39,2],[40,1,40,6]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Cooperative Support Agreement Budget Worksheet",{"$nulls":4},"Yellow Cells:","Manual fill by user"]
[{"$nulls":6},"Blue Cells:","Linked from other worksheet tabs"]
["    ","Recipient Name (pull from set up)",{"$nulls":4},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)",{"$nulls":4},"Report Period Start:"]
[{"$nulls":6},"Report Period End:"]
[]
[]
[{"$nulls":3},"Summary of CSA Expenditures"]
[]
[null,null,"Select CSA Type","Approved Budget         (to Date)","Current Expenditures","Total Expenditures (to Date)","Amount Remaining"]
[null,null,"CSA Number"]
[null,null,"Senior Personnel",0,0,0,{"$f":"D15-F15","v":0}]
[null,null,"Other Personnel",0,0,0,{"$f":"D16-F16","v":0}]
[null,null,"Total Salaries and Wages",{"$f":"SUM(D15:D16)","v":0},{"$f":"SUM(E15:E16)","v":0},{"$f":"SUM(F15:F16)","v":0},{"$f":"D17-F17","v":0}]
[null,null,"Fringe Benefits",0,0,0,0]
[null,null,"Total Salaries/Wages/Benefits",{"$f":"SUM(D17:D18)","v":0},{"$f":"SUM(E17:E18)","v":0},{"$f":"SUM(F17:F18)","v":0},0]
[null,null,"Equipment",0,0,0,0]
[null,null,"Travel",0,0,0,0]
[null,null,"Participant Support",0,0,0,0]
[null,null,"Other Direct Costs: Materials and Supplies",0,0,0,0]
[null,null,"Other Direct Costs: Publication/Documentation/Dissemination",0,0,0,0]
[null,null,"Other Direct Costs: Consultant Services",0,0,0,0]
[null,null,"Other Direct Costs: Computer Services",0,0,0,0]
[null,null,"Other Direct Costs: Subawards",0,0,0,0]
[null,null,"Other Direct Costs: Other",0,0,0,0]
[null,null,"Total Other Direct Costs",{"$f":"SUM(D23:D28)","v":0},{"$f":"SUM(E23:E28)","v":0},{"$f":"SUM(F23:F28)","v":0},0]
[null,null,"Total Direct Costs",{"$f":"SUM(D19:D28)","v":0},{"$f":"SUM(E19:E28)","v":0},{"$f":"SUM(F19:F28)","v":0},0]
[null,null,"Indirect Costs",0,0,0,0]
[null,null,"Total Direct and Indirect Costs",{"$f":"SUM(D30:D31)","v":0},{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0},0]
[null,null,"CSA Period of Performance Start:","Date"]
[null,null,"CSA Period of Performance End:","Date"]
[null,null,"Budget Start Date:","Date"]
[null,null,"Purpose of CSA:","Text"]
[null,"* Contingency Funds and Management Fee must be included in the Other Direct Costs: Other and a note added below."]
[null,"**Program Income should not be included in your costs but provided on the Program Income Reporting Worksheet per the PAPPG."]
[]
[null,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or data submitted for this worksheet."]

{"sheet":"SubcontractConsultant Worksheet","index":5,"n_rows":61,"n_cols":23,"rows_kept":61,"merged":[[1,1,1,5],[4,1,4,5],[6,1,6,5],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,15,16,16],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[18,13,18,14],[18,15,18,16],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[19,13,19,14],[19,15,19,16],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[22,15,22,16],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[23,15,23,16],[24,3,24,4],[24,5,24,6],[24,7,24,8],[24,9,24,10],[24,11,24,12],[24,13,24,14],[24,15,24,16],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,14],[32,15,32,16],[33,3,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[34,3,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[35,3,35,4],[35,5,35,6],[35,7,35,8],[35,9,35,10],[35,11,35,12],[35,13,35,14],[35,15,35,16],[36,3,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[36,13,36,14],[36,15,36,16],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[40,3,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[41,3,41,4],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[41,13,41,14],[41,15,41,16],[42,3,42,4],[42,5,42,6],[42,7,42,8],[42,9,42,10],[42,11,42,12],[42,13,42,14],[42,15,42,16],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[48,15,48,16],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[52,13,52,14],[52,15,52,16],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[53,15,53,16],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[58,15,58,16],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[59,15,59,16],[60,3,60,4],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[60,13,60,14],[60,15,60,16]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Subcontracts & Consultants Worksheet",{"$nulls":6},"Yellow Cells:","Manual fill by user",{"$nulls":12},"Fixed"]
[{"$nulls":8},"Blue Cells:","Linked from other worksheets",{"$nulls":12},"Performance Based"]
["    ","Recipient Name (pull from set up)",{"$nulls":6},"Gray Cells:","Auto-calculated",{"$nulls":12},"Cost Reimbursable"]
[{"$nulls":22},"T&M"]
[null,"Name of Facility (pull from set up)"]
[]
[]
[null,null,"Subcontract Information","Subcontract #1",null,"Subcontract #2",null,"Subcontract #3",null,"Subcontract #4",null,"Subcontract #5",null,"Subcontract #6",null,"Subcontract #7"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award Number:"]
[null,null,"Subcontract #: "]
[null,null,"Subcontractor Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subcontract Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Signed Date of Contract:"]
[null,null,"Subcontract Type:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]
[]
[]
[null,null,"Subcontract Information","Subcontract #8",null,"Subcontract #9",null,"Subcontract #10",null,"Subcontract #11",null,"Subcontract #12",null,"Subcontract #13",null,"Subcontract #14"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award #:"]
[null,null,"Subcontract #:"]
[null,null,"Subcontractor Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subcontract Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Signed Date of Contract:"]
[null,null,"Contract Type:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]
[]
[]
[null,null,"Subcontract Information","Subcontract #15",null,"Subcontract #16",null,"Subcontract #17",null,"Subcontract #18",null,"Subcontract #19",null,"Subcontract #20",null,"Subcontract #21"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award #:"]
[null,null,"Subcontract #:"]
[null,null,"Subcontractor Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subcontract Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Signed Date of Contract:"]
[null,null,"Contract Type:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]

{"sheet":"Subawards Worksheet","index":6,"n_rows":58,"n_cols":16,"rows_kept":58,"merged":[[1,1,1,5],[4,1,4,5],[6,1,6,5],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[9,15,9,16],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[15,3,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[15,13,15,14],[15,15,15,16],[16,3,16,4],[16,5,16,6],[16,7,16,8],[16,9,16,10],[16,11,16,12],[16,13,16,14],[16,15,16,16],[17,3,17,4],[17,5,17,6],[17,7,17,8],[17,9,17,10],[17,11,17,12],[17,13,17,14],[17,15,17,16],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[21,3,21,4],[21,5,21,6],[21,7,21,8],[21,9,21,10],[21,11,21,12],[21,13,21,14],[21,15,21,16],[22,3,22,4],[22,5,22,6],[22,7,22,8],[22,9,22,10],[22,11,22,12],[22,13,22,14],[22,15,22,16],[23,3,23,4],[23,5,23,6],[23,7,23,8],[23,9,23,10],[23,11,23,12],[23,13,23,14],[23,15,23,16],[26,3,26,4],[26,5,26,6],[26,7,26,8],[26,9,26,10],[26,11,26,12],[26,13,26,14],[26,15,26,16],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[27,11,27,12],[27,13,27,14],[27,15,27,16],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[30,13,30,14],[30,15,30,16],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[31,11,31,12],[31,13,31,14],[31,15,31,16],[32,3,32,4],[32,5,32,6],[32,7,32,8],[32,9,32,10],[32,11,32,12],[32,13,32,14],[32,15,32,16],[33,3,33,4],[33,5,33,6],[33,7,33,8],[33,9,33,10],[33,11,33,12],[33,13,33,14],[33,15,33,16],[34,3,34,4],[34,5,34,6],[34,7,34,8],[34,9,34,10],[34,11,34,12],[34,13,34,14],[34,15,34,16],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[37,13,37,14],[37,15,37,16],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,13,38,14],[38,15,38,16],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[39,15,39,16],[40,3,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[40,13,40,14],[40,15,40,16],[43,3,43,4],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[43,15,43,16],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[44,15,44,16],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[45,15,45,16],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[46,15,46,16],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[47,15,47,16],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[48,15,48,16],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[49,15,49,16],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[50,13,50,14],[50,15,50,16],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[51,15,51,16],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[54,15,54,16],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[55,15,55,16],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[56,15,56,16],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[57,15,57,16]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Subawards Worksheet",{"$nulls":6},"Yellow Cells:","Manual fill by user"]
[{"$nulls":8},"Blue Cells:","Linked from other worksheets"]
["    ","Recipient Name (pull from set up)",{"$nulls":6},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)"]
[]
[]
[null,null,"Subaward Information","Subaward #1",null,"Subaward #2",null,"Subaward #3",null,"Subaward #4",null,"Subaward #5",null,"Subaward #6",null,"Subaward #7"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award #:"]
[null,null,"Subaward #:"]
[null,null,"Subrecipient Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subaward Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Date of Award:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]
[]
[]
[null,null,"Subaward Information","Subaward #8",null,"Subaward #9",null,"Subaward #10",null,"Subaward #11",null,"Subaward #12",null,"Subaward #13",null,"Subaward #14"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award #:"]
[null,null,"Subaward #:"]
[null,null,"Subrecipient Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subaward Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Date of Award:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]
[]
[]
[null,null,"Subaward Information","Subaward #15",null,"Subaward #16",null,"Subaward #17",null,"Subaward #18",null,"Subaward #19",null,"Subaward #20",null,"Subaward #21"]
[null,null,"CSA # from CSA Cost Worksheet:"]
[null,null,"CSA Award #:"]
[null,null,"Subaward #:"]
[null,null,"Subrecipient Name:"]
[null,null,"City:"]
[null,null,"State:"]
[null,null,"Zip Code:"]
[null,null,"Country:"]
[null,null,"Subaward Amount:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Cumulative Expenditures to Date:",{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"}]
[null,null,"Date of Award:"]
[null,null,"Period of Performance Start:"]
[null,null,"Period of Performance End:"]
[null,null,"Brief Statement of Work:"]

{"sheet":"Indirect Cost Rate Worksheet","index":7,"n_rows":20,"n_cols":11,"rows_kept":20,"merged":[[1,1,1,5],[4,1,4,5],[6,1,6,5],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,6],[12,7,13,7],[12,8,13,8],[12,9,13,9],[14,9,14,12],[15,9,15,12],[16,9,16,12],[18,1,18,3],[19,1,26,9]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Indirect Cost Rate Worksheet",{"$nulls":7},"Yellow Cells:","Manual fill by user"]
[{"$nulls":9},"Blue Cells:","Linked from other worksheets"]
["    ","Recipient Name (pull from set up)",{"$nulls":7},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)",{"$nulls":7},"Report Period Start:"]
[{"$nulls":9},"Report Period End:"]
[]
[]
[{"$nulls":5},"Schedule of Indirect Costs"]
[]
[{"$nulls":3},"Period of Performance Start Date","Period of Performance End Date","Allocation Base","$$ Amount Base","Rate Applied","Total Expended","   Comments"]
[null,null,"Description"]
[null,null,"F&A",{"$nulls":3},0,null,0,"Text"]
[null,null,"G&A",{"$nulls":3},0,null,0,"Text"]
[null,null,"ID Other",{"$nulls":3},0,null,0,"Text"]
[]
[null,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or data submitted for this worksheet."]

{"sheet":"Program Expenditures Worksheet","index":8,"n_rows":62,"n_cols":8,"rows_kept":62,"merged":[[1,1,1,3],[4,1,4,3],[6,1,6,3],[11,3,12,3],[11,4,12,4],[11,5,12,5],[11,6,12,6],[13,6,13,9],[14,6,14,9],[15,6,15,9],[16,6,16,9],[17,6,17,9],[18,6,18,9],[19,6,19,9],[20,6,20,9],[21,6,21,9],[22,6,22,9],[23,6,23,9],[24,6,24,9],[25,6,25,9],[26,6,26,9],[27,6,27,9],[28,6,28,9],[29,6,29,9],[30,6,30,9],[31,6,31,9],[32,6,32,9],[33,6,33,9],[39,3,40,3],[39,4,40,4],[39,5,40,5],[39,6,40,6],[60,1,60,2],[61,1,67,6]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Program Expenditures Worksheet",{"$nulls":4},"Yellow Cells:","Manual fill by user"]
[{"$nulls":6},"Blue Cells:","Linked from other worksheets"]
["    ","Recipient Name (pull from set up)",{"$nulls":4},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)",{"$nulls":4},"Report Period Start:"]
[{"$nulls":6},"Report Period End:"]
[]
[{"$nulls":3},"Reconciliation of Books of Account for all CSAs"]
[]
[{"$nulls":3},"General Ledger","Adjustments","Current Expenditures","Comments"]
[null,null,"Current Expenditures\nby Major Cost Element"]
[null,null,"Senior Personnel",0,0,0,"Text"]
[null,null,"Other Personnel",0,0,0,"Text"]
[null,null,"Total Salaries and Wages",{"$f":"SUM(D14:D15)","v":0},{"$f":"SUM(E14:E15)","v":0},{"$f":"SUM(F14:F15)","v":0},"Text"]
[null,null,"Fringe Benefits",0,0,0,"Text"]
[null,null,"Total Salaries/Wages/Benefits",{"$f":"SUM(D16:D17)","v":0},{"$f":"SUM(E16:E17)","v":0},{"$f":"SUM(F16:F17)","v":0},"Text"]
[null,null,"Equipment",{"$f":"SUM(D14:D18)","v":0},{"$f":"SUM(E14:E18)","v":0},0,"Text"]
[null,null,"Travel",0,0,0,"Text"]
[null,null,"Participant Support",0,0,0,"Text"]
[null,null,"Other Direct Costs: Materials and Supplies",0,0,0,"Text"]
[null,null,"Other Direct Costs: Publication/Documentation/Dissemination",0,0,0,"Text"]
[null,null,"Other Direct Costs: Consultant Services",0,0,0,"Text"]
[null,null,"Other Direct Costs: Computer Services",0,0,0,"Text"]
[null,null,"Other Direct Costs: Subawards",0,0,0,"Text"]
[null,null,"Other Direct Costs: Other",0,0,0,"Text"]
[null,null,"Total Other Direct Costs",{"$f":"SUM(D22:D27)","v":0},{"$f":"SUM(E22:E27)","v":0},{"$f":"SUM(F22:F27)","v":0},"Text"]
[null,null,"Total Direct Costs",{"$f":"SUM(D18:D27)","v":0},{"$f":"SUM(E18:E27)","v":0},{"$f":"SUM(F18:F27)","v":0},"Text"]
[null,null,"Indirect Costs: F&A",0,0,0,"Text"]
[null,null,"Indirect Costs: G&A",0,0,0,"Text"]
[null,null,"Indirect Costs: Name",0,0,0,"Text"]
[null,null,"Total Indirect Costs:",{"$f":"SUM(D30:D32)","v":0},{"$f":"SUM(E30:E32)","v":0},{"$f":"SUM(F30:F32)","v":0},"Text"]
[null,null,"Total Direct and Indirect Costs:",{"$f":"SUM(D29,D33)","v":0},{"$f":"SUM(E29,E33)","v":0},{"$f":"SUM(F29,F33)","v":0},"Text"]
[]
[]
[]
[{"$nulls":5},"Summary of Total Costs for all CSAs"]
[]
[{"$nulls":3},"Approved Budget","Current Expenditures","Total Expenditures\nto Date ","Amount Remaining"]
[null,null,"Program Budget Summary"]
[null,null,"Senior Personnel",0,0,0,{"$f":"D42-F42","v":0}]
[null,null,"Other Personnel",0,0,0,{"$f":"D43-F43","v":0}]
[null,null,"Total Salaries and Wages",{"$f":"SUM(D42:D43)","v":0},{"$f":"SUM(E42:E43)","v":0},0,{"$f":"D44-F44","v":0}]
[null,null,"Fringe Benefits",0,0,0,{"$f":"D45-F45","v":0}]
[null,null,"Total Salaries/Wages/Benefits",{"$f":"SUM(D44:D45)","v":0},{"$f":"SUM(E44:E45)","v":0},0,{"$f":"D46-F46","v":0}]
[null,null,"Equipment",0,0,0,{"$f":"D47-F47","v":0}]
[null,null,"Travel",0,0,0,0]
[null,null,"Participant Support",0,0,0,0]
[null,null,"Other Direct Costs: Materials and Supplies",0,0,0,0]
[null,null,"Other Direct Costs: Publication/Documentation/Dissemination",0,0,0,0]
[null,null,"Other Direct Costs: Consultant Services",0,0,0,0]
[null,null,"Other Direct Costs: Computer Services",0,0,0,0]
[null,null,"Other Direct Costs: Subawards",0,0,0,0]
[null,null,"Other Direct Costs: Other",0,0,0,0]
[null,null,"Total Other Direct Costs",{"$f":"SUM(D50:D55)","v":0},{"$f":"SUM(E50:E55)","v":0},{"$f":"SUM(F50:F55)","v":0},0]
[null,null,"Total Direct Costs",{"$f":"SUM(D46:D55)","v":0},{"$f":"SUM(E46:E55)","v":0},{"$f":"SUM(F46:F55)","v":0},0]
[null,null,"Indirect Costs",0,0,0,0]
[null,null,"Total Direct and Indirect Costs",{"$f":"SUM(D57:D58)","v":0},{"$f":"SUM(E57:E58)","v":0},0,0]
[]
[null,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or data submitted for this worksheet."]

{"sheet":"Accounting Notes Worksheet","index":9,"n_rows":18,"n_cols":5,"rows_kept":18,"merged":[[1,1,1,5],[12,4,12,7],[13,4,13,7],[14,4,14,7],[15,4,15,7],[16,4,16,7],[17,4,17,7]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Accounting Notes Worksheet"]
[]
["    "]
[null,"The information in this section will be used to identify the awardee's accounting resources "]
[null,"utilized to consolidate program expenditures in this collection tool. Please select \"Y\" or \"N\" "]
[null,"in the column below to identify which accounting documents where referenced as "]
[null,"supporting documentation in your submission. If you select \"N,\" please explain your "]
[null,"response in further detail and/or submit additional documentation, as necessary, with this "]
[null,"tool. Use the \"Comment\" field to supply NSF with additional information regarding the "]
[null,"source or computation of data submitted."]
[null,"#","Checklist Item","Y/N","Comments/Notes"]
[null,1,"General Ledger"]
[null,2,"Job Cost Ledger"]
[null,3,"Chart of Accounts"]
[null,4,"CA/CSA Budgets \n(most recently approved)"]
[null,5,"Negotiated Indirect Cost Rate Agreement (NICRA) \n(most current)"]

{"sheet":"Certificate of Costs","index":10,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[1,1,1,3],[4,1,4,3],[6,1,6,3]]}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Certificate of Costs",{"$nulls":3},"Yellow Cells:","Manual fill by user"]
[{"$nulls":5},"Blue Cells:","Linked from other report tabs"]
["    ","Recipient Name (pull from set up)",{"$nulls":3},"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)"]
[]
[]
[]
[null,null,"Overview: Please complete this tab to certify that the information included in these worksheets"]
[null,null,"are based on your current accounting records and ledgers."]
[null,null,"Awardee Name:","Linked from \"Setup\""]
[null,null,"Current Expenditures:"]
[null,null,"AOR Name:"]
[null,null,"AOR Title:"]
[null,null,"Name of Certifying Official:"]
[null,null,"Title of Certifying Official:"]
[null,null,"Date:"]
[{"$nulls":3},"By checking this box, the certifying official named above attests and certifies that all information contained in these worksheets are accurate and applicable to the cooperative agreement and cooperative support agreements identified for this reporting period. The data does not include any expenditures that are expressly unallowable according to Office of Budget and Management’s Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (2 CFR 200)."]

{"sheet":"State","index":11,"n_rows":58,"n_cols":1,"rows_kept":58,"hidden":true}
["Alaska"]
["Alabama"]
["Arkansas"]
["Austria"]
["Arizona"]
["California"]
["Colorado"]
["Connecticut"]
["District of Columbia"]
["Delaware"]
["Florida"]
["France"]
["Georgia"]
["Hawaii"]
["Iowa"]
["Idaho"]
["Illinois"]
["Indiana"]
["Kansas"]
["Kentucky"]
["Louisiana"]
["Massachusetts"]
["Maryland"]
["Maine"]
["Michigan"]
["Minnesota"]
["Missouri"]
["Mississippi"]
["Montana"]
["Mexico"]
["North Carolina"]
["North Dakota"]
["Nebraska"]
["New Hampshire"]
["New Jersey"]
["New Mexico"]
["Nevada"]
["New York"]
["Ohio"]
["Oklahoma"]
["Ontario"]
["Oregon"]
["Pennsylvania"]
["Puerto Rico"]
["Rhode Island"]
["South Carolina"]
["South Dakota"]
["Tennessee"]
["Texas"]
["Utah"]
["Virginia"]
["Virgin Islands"]
["Vermont"]
["Washington"]
["Wisconsin"]
["West Virginia"]
["Wyoming"]
["Other"]

{"sheet":"CSAType","index":12,"n_rows":3,"n_cols":1,"rows_kept":3,"hidden":true}
["Construction"]
["Operations"]
["Other"]