{"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,"defined_names":32},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":25,"n_cols":3,"rows_kept":25}
[]
[null,"Large Facility Financial Data Collection Tool"]
[]
[]
["    "]
[null,null,"INSTRUCTIONS"]
[null,null,"Overview: This workbook was designed by the National Science Foundation (NSF) to assist awardees in submitting substantiated program expenditures for construction and O&M costs for its large facility cooperative agreement (CA) and cooperative support agreements (CSAs). This user-friendly workbook is comprised of several worksheets that enable awardees to submit adequate incurred program expenditures in accordance with NSF terms and conditions. Only this NSF-approved tool should be used to submit incurred cost data."]
[null,null,"How to Submit: Awardees are instructed to download this tool from NSF.gov, complete all worksheets, and submit this tool annually to NSF or as required by its award terms and conditions.  This tool should be downloaded and saved before starting. When completed, this report is to be submitted electronically (e.g., email) to your NSF Grants and Agreements Official. Questions regarding this report should be directed to your NSF Grants and Agreements Official. "]
[null,null,"WORKSHEET PREPARATION"]
[null,null,"Overview: Prior to completing the worksheets, retrieve a breakdown of federal funding (budget) for each cooperative support agreement (CSA), and a breakdown of all expenditures claimed for each CSA issued under your cooperative agreement. Suggested sources for this data include your Chart of Accounts, General Ledger, Project Cost Ledger, CSA award budgets, and your 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:"]
[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 cooperative agreement and subsequent CSAs. As data is entered, some data fields will prompt you to input additional data specific to the number of subcontract, subawards, and award-specific indirect data applicable for your awards."]
[null,null,"CSA Cost Worksheet: The purpose of this worksheet is to perform a reconciliation of costs from the General Ledger to the Job Cost Ledger for all award CSAs; the Program Charges Worksheet consolidates this data for all CSAs.\n"]
[null,null,"CSA Budget Worksheet: The CSA Budget Worksheet captures the reported costs for each of the major cost elements for each CSA (for the reporting period and cumulative to date). These costs are compared to approved budgets for each CSA to indicate the amount remaining for each budget category.\n\n"]
[null,null,"Subcontract & Consultants Worksheet: The Subcontracts and Consultants Schedule provides details of costs for each subcontract identified by the awardee during Setup. Information only to be provided for those subcontracts/consultant contracts totaling a minimum of $150,000. Costs are to be inputted according to NSF budget cost elements (e.g., award budget category)."]
[null,null,"Subawards Worksheet: The Subawards Schedule provides details of costs for each subaward identified by the awardee during Setup. Information only to be provided for those subawards totaling a minimum of $150,000. Costs are inputted according to NSF budget cost elements (e.g., award budget category)."]
[null,null,"Indirect Cost Rate Worksheet: The purpose of the Indirect Rate Worksheet is to capture details associated with the indirect cost rates. The schedule of indirect cost includes the POP 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 awardee’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 awardee to certify that all data is accurate and based upon official records used by the awardee to record all expenditures for its 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 awardee 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":4,"n_cols":2,"rows_kept":4}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Flowchart"]
["    ","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":65,"n_cols":16,"rows_kept":65}
[]
[null,"Large Facility Financial Data Collection Tool"]
[null,"Report Setup",{"$nulls":13},1]
[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:",1]
[]
[null,null,"POC DATA"]
[null,null,"First Name:"]
[null,null,"Last Name:"]
[null,null,"Title:"]
[null,null,"Phone No.:"]
[null,null,"Email:"]
[]
[]
[null,null," INDIRECT CHARGE DATA",null,null,"If Other, list name below:"]
[null,null,"F&A",null,null,"Name 1:"]
[null,null,"G&A",null,null,"Name 2:"]
[null,null,"Other",null,null,"Name 3:"]
[{"$nulls":5},"Name 4:"]
[{"$nulls":5},"Name 5:"]
[{"$nulls":5},"Name 6:"]
[]
[{"$nulls":5},"CSA","# of Subcontracts","# of Subawards"]
[{"$nulls":5},"CSA 1",0,0]
[{"$nulls":5},"CSA 2",0,0]
[{"$nulls":5},"CSA 3",0,0]
[{"$nulls":5},"CSA 4",0,0]
[{"$nulls":5},"CSA 5",0,0]
[{"$nulls":5},"CSA 6",0,0]
[{"$nulls":5},"CSA 7",0,0]
[{"$nulls":5},"CSA 8",0,0]
[{"$nulls":5},"CSA 9",0,0]
[{"$nulls":5},"CSA 10",0,0]
[{"$nulls":5},"CSA 11",0,0]
[{"$nulls":5},"CSA 12",0,0]
[{"$nulls":5},"CSA 13",0,0]
[{"$nulls":5},"CSA 14",0,0]
[{"$nulls":5},"CSA 15",0,0]
[{"$nulls":5},"CSA 16",0,0]
[{"$nulls":5},"CSA 17",0,0]
[{"$nulls":5},"CSA 18",0,0]
[{"$nulls":5},"CSA 19",0,0]
[{"$nulls":5},"CSA 20",0,0]

{"sheet":"CSA Cost Worksheet","index":3,"n_rows":40,"n_cols":8,"rows_kept":40}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":5},"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)",{"$nulls":3},"Report Period Start:"]
[{"$nulls":5},"Report Period End:"]
[null,"Cooperative Support Agreement (CSA) Cost Schedule"]
[]
[{"$nulls":4},"Reconciliation of Claimed Expenditures to Job Cost Ledger"]
[null,null,"Select CSA Type"]
[null,null,"Enter CSA #","General Ledger","Job Cost Ledger","Adjustment","Current Claimed","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,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":39,"n_cols":8,"rows_kept":39}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":6},"Yellow Cells:","Manual fill by user"]
[{"$nulls":6},"Blue Cells:","Linked from other report 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:"]
[null,"Cooperative Support Agreement (CSA) Budget Worksheet"]
[]
[{"$nulls":4},"Summary of CSA Expenditures"]
[]
[null,null,"Select CSA Type","Approved Budget","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,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":36,"n_cols":23,"rows_kept":36}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":6},"Yellow Cells:","Manual fill by user",{"$nulls":14},"Fixed"]
[{"$nulls":6},"Blue Cells:","Linked from other report tabs",null,"Report Period Start:",{"$nulls":12},"Performance Based"]
["    ","Recipient Name (pull from set up)",{"$nulls":4},"Gray Cells:","Auto-calculated",null,"Report Period End:",{"$nulls":12},"Cost Reimbursable"]
[{"$nulls":22},"T&M"]
[null,"Name of Facility (pull from set up)"]
[]
[null,"Subcontracts & Consultants Worksheet"]
[{"$nulls":7},"Costs by Subcontract/Consultants - Proposed",{"$nulls":7},"Costs by Subcontract/Consultants - Actual (Current Report Period)"]
[]
[{"$nulls":3},"Salary & Wages","Fringe / Benefits","Equipment","Travel","ODCs","Indirect Costs","TOTAL","Salary & Wages","Fringe / Benefits","Equipment","Travel","ODCs","Indirect Costs","TOTAL"]
[null,null,"Subcontract Number"]
[null,null,"Subcontract #1",0,0,0,0,0,0,{"$f":"SUM(D14:I14)","v":0},0,0,0,0,0,0,{"$f":"SUM(K14:P14)","v":0}]
[]
[null,null,"Total Costs:",{"$f":"SUM(D14:D15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Notes:"]
[null,null,"Subcontract Information","Subcontract #1"]
[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,null,"Cumulative Expenditures to Date:",{"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,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or data submitted for this worksheet."]

{"sheet":"Subawards Worksheet","index":6,"n_rows":33,"n_cols":17,"rows_kept":33}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":6},"Yellow Cells:","Manual fill by user"]
[{"$nulls":6},"Blue Cells:","Linked from other report tabs",null,"Report Period Start:"]
["    ","Recipient Name (pull from set up)",{"$nulls":4},"Gray Cells:","Auto-calculated",null,"Report Period End:"]
[]
[null,"Name of Facility (pull from set up)"]
[]
[null,"Subawards Worksheet"]
[{"$nulls":6},"Costs by Subaward - Proposed",{"$nulls":7},"Costs by Subaward - Actual (Current Report Period)"]
[]
[{"$nulls":3},"Salary & Wages","Fringe","Equipment","Travel","ODCs","Indirect Costs","TOTAL","Salary & Wages","Fringe","Equipment","Travel","ODCs","Indirect Costs","TOTAL"]
[null,null,"Subaward Number"]
[null,null,"Subaward #1",0,0,0,0,0,0,{"$f":"SUM(D14:I14)","v":0},0,0,0,0,0,0,{"$f":"SUM(K14:P14)","v":0}]
[]
[null,null,"Total Costs:",{"$f":"SUM(D14:D15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"Notes:"]
[null,null,"Subaward Information","Subaward #1"]
[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,null,"Cumulative Expenditures to Date:",{"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,"Recipient Preparation Notes"]
[null,"Please enter any notes or comments regarding your calculations or data submitted for this worksheet."]

{"sheet":"Indirect Cost Rate Worksheet","index":7,"n_rows":20,"n_cols":11,"rows_kept":20}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":9},"Yellow Cells:","Manual fill by user"]
[{"$nulls":9},"Blue Cells:","Linked from other report tabs"]
["    ","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:"]
[null,"Indirect Cost Rate Worksheet"]
[]
[{"$nulls":5},"Schedule of Indirect Costs"]
[]
[{"$nulls":3},"Period of Performance Start","Period of Performance End","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,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}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":6},"Yellow Cells:","Manual fill by user"]
[{"$nulls":6},"Blue Cells:","Linked from other report 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:"]
[null,"Program Expenditures Worksheet"]
[{"$nulls":3},"Reconciliation of Books of Account for all CSAs"]
[]
[{"$nulls":3},"General Ledger","Adjustments","Current Claimed","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,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":7,"rows_kept":18}
[]
[null,"Large Facility Financial Data Collection Tool"]
[]
[]
["    ","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",null,null,"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":6,"rows_kept":20}
[]
[null,"Large Facility Financial Data Collection Tool"]
[{"$nulls":4},"Yellow Cells:","Manual fill by user"]
[{"$nulls":4},"Blue Cells:","Linked from other report tabs"]
["    ","Recipient Name (pull from set up)",null,null,"Gray Cells:","Auto-calculated"]
[]
[null,"Name of Facility (pull from set up)"]
[]
[]
[null,null,"CERTIFICATE OF COSTS"]
[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 Charges:"]
[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"]