Budget Template Instructions

System/Software Requirements:

For PC: MSOffice Excel 2007 with Service Pack 2 or higher; download from here: http://www.microsoft.com/download/en/details.aspx?id=5

The Mac option is under development. Users requiring the old versions of the spreadsheet may contact Dee Evans at ddevans [at] grants [dot] rutgers [dot] edu

 

Instructions for use:

Macros must be enabled to activate the dropdown menus in the worksheets. On the Basic Worksheet, in the upper left corner on a toolbar above the worksheet, the user will see “Security Warning: Some active content has been disabled”.

A box next to that statement is labeled Options.
Click on Options, then click on Enable Content, which will enable the macros.

  1. The top portion of the Basic Worksheet must be completed first, including correct project dates, to preserve the integrity of the calculations that follow.
  2. Note that data entry will take place in the Basic Worksheet and Cost-Sharing Worksheet, which will populate the remaining pages. Neither the Basic or the Cost-Sharing Worksheet will print out (first two tabs). The pages that are able to be printed are Cumulative Basic, Cumulative Cost-Sharing, Personnel and Subcontractor.
  3. Do not enter data into the Cost-Sharing Worksheet unless cost-sharing is needed in the proposal budget.

Budget Template Download (Excel)