![]() ![]() ![]() Sea pay and benefits on a fabrication worksheet are added into the 06 Equipment line. Sea pay and sea pay benefit amounts for personnel on the primary or internal worksheets will be included in the 01 Salaries and 07 Benefits lines. The Direct Costs section includes a row for Salaries and a row for Benefits, followed by the Total Personnel row. For the row entries, the period columns display the total dollar amounts. The period column headings include the start and end dates, and the period descriptions. Salary Cap note – the text of the optional note, if any.Sponsor Salary Cap – the amount of the cap or “None”.Project Dates – budget start and end dates.Worksheet(s) Security Grant Hierarchy – the SGH values from any additional worksheets.Worksheet(s) Fiscally Responsible Cost Center – the Cost Center name and code from any additional worksheets.Primary Security Grant Hierarchy – the SGH value from the Primary Worksheet.Primary Cost Center Receiving Funding – the Cost Center name and code from the Primary Worksheet.Principal Investigator(s) – first and last name of the PI on the Primary Worksheet and the PIs on additional worksheets.Report title – either Summary by Period or the period description.Budget Title and Number, and the Run Date (when the data was exported).The header for this tab includes the following information: The All Periods tab displays the totals for the budget by period. ![]() To download an example Excel spreadsheet, right-click the link Budget_Summary_Export_Example, select “Save link as…,” and then save the file to your computer. These are labeled as Period 1, Period 2, and so forth. Additional tabs show the details for each of the budget’s periods. The first one is the Budget Summary All Periods. To close the dialog window without creating an export, select Cancel or the blue X in the upper-right corner, or click outside of the dialog window. Depending on your settings, you may need to “enable editing” once you have opened the downloaded file. Select the choice you want and click “Export” to generate the report as an Excel file (extension. The remaining items, if any, are the titles of each additional worksheet in your budget, in the order added.The next item is the title of the primary worksheet.Both NIH and non-NIH options of the SF424 (R&R) Detailed Budget Format – matches the SF424 R&R Detailed Budget form layout.Budget Summary (all worksheets) – selected by default.A dialog will display with a list of choices, as shown in the following image. On the budget header, click on the “‘more options” menu icon at the far right (three blue vertical dots). R&R Detailed Budget Formats – NIH and Non-NIH.Note: The exported file contains just labels and values, and is editable. Each option includes a tab for each period’s values and one for all period totals. This article covers how to create an export, and then describes the export options you can choose. You can export your budget data to Excel, so that you can easily share the information with colleagues. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |