1 / 11

Project Administration Spreadsheet

Project Administration Spreadsheet. Added Additional Lines to Allow More “Individual Budget Items” . Added Additional “Funding Sources” in Dropdown Boxes. No Changes . Updates to Bottom Table. Additional Cost Share Source in Dropdown Boxes New Way to Track Matching Cost Share

sovann
Download Presentation

Project Administration Spreadsheet

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Project Administration Spreadsheet

  2. Added Additional Lines to Allow More “Individual Budget Items”

  3. Added Additional “Funding Sources” in Dropdown Boxes

  4. No Changes

  5. Updates to Bottom Table • Additional Cost Share Source in Dropdown Boxes • New Way to Track Matching Cost Share • Revised Approach to Track Soil Loss Reductions • 2 Defaulted, 2 Open Columns to Track Loading

  6. Updates to Summary Table Increased from 5 to 8 years Additional Cost Share Program choices

  7. Entering Matching Cost Share

  8. Entering Load Reductions Use Other A & B at your discretion to track: the number of livestock “treated” the amount of solid waste being collected fewer gallons or acre-feet of runoff amount of land (acres or ft2) routed through infiltration BMPs still difficult to track bacteria nitrates/nitrites • Continue to use the Sediment Delivery Calculator • 1.3 lbs. of phosphorus per ton of sediment

  9. Transferring Data • Do you need to convert to the new format? • If current project is 2 years old or less? Yes * • If current project is 3 years or older? Maybe * • If current project is older than 5 years? No * (* unless someone in the Wallace Building says otherwise) • Are there procedures on how to transfer data? • Edited & added several new columns • Added several new choices to dropdown boxes • Changed how we enter piggy-back claims

  10. Copy & Paste

  11. Where can I find the update? • Go to the ftp website • Jeff Tisl • Project Admin Spreadsheet (Version 3).xls • Project Administration Spreadsheet 2010 Updates.pptx

More Related