View Full Document

Proposal Budget Spreadsheet Instructions



View the full content.
View Full Document
View Full Document

4 views

Unformatted text preview:

Proposal Budget Spreadsheet Instructions ProBudgt xls ver 11 00 09 29 2010 This form has been modeled after and adapted from the form available from the Texas Engineering Experiment Station The proposal budget spreadsheet has been designed to allow the entry of budget information into one worksheet and then automatically transfer the entered budget information into the respective agency forms on subsequent worksheets making all necessary calculations along the way and allowing for instantaneous updates to all budget forms We will begin with a brief discussion of terms used within MS Excel when discussing Spreadsheets Microsoft has designed their spreadsheet format using the basic item called the workbook Within a workbook you have individual worksheets The worksheets are accessed using the filetabs along the bottom of the workbook screen In our particular case the workbook is called ProBudgt xls The worksheets are seen along the bottom of the screen labeled Data Entry File Copy NSF 1030 etc The first step for a new proposal is to save the Proposal Budget Spreadsheet under a different filename We suggest using your RO number The RO is the internal tracking number assigned by the Division of Research This will protect the integrity of the information in the master document The naming convention for these files should be RO bud xls i e 11075bud xls The Data Entry worksheet is where the pertinent information is entered and calculations are made At the top of the page the RO number is entered for reference and the date is automatically determined The project duration is entered and the applicable Indirect Cost Rate is entered The default indirect cost rate is our standard on campus rate currently 56 of MTDC A field is also available for the entry of an Annual Salary Escalation rate The default is 3 This field will increase the Investigator salaries annually by this percentage based on the entry of the first year figure To the right of these cells are five cells where the



Access the best Study Guides, Lecture Notes and Practice Exams

Loading Unlocking...
Login

Join to view Proposal Budget Spreadsheet Instructions and access 3M+ class-specific study document.

or
We will never post anything without your permission.
Don't have an account?
Sign Up

Join to view Proposal Budget Spreadsheet Instructions and access 3M+ class-specific study document.

or

By creating an account you agree to our Privacy Policy and Terms Of Use

Already a member?