Page History

eSeaGrant's RFP FMP interface may be used to generate the following omnibus sections:

1. Project Narrative PDF
2. Budget Narrative PDF
3. 90-2 Bulk Upload Template

*eSeaGrant provides for and requests proposal-specific Data Management Plans (DMPs) from PIs, so inclusion of an overall program DMP is optional

A. For each proposal to be included in the omnibus, click the Full Proposals > 90-2 tab > "All parts for this proposal" button to export to your desktop a folder containing all of the proposal's documents and forms.

B. For each omnibus narrative section,

1. Compile all parts for a narrative into a single PDF. It's recommended that you reduce the size of PDFs generated by Filemaker Pro using a third-party program, such as PDF Shrink (http://www.apagoinc.com/prod_home.php?prod_id=36)
2. Delete blank pages
3. Number pages
4. Update Table of Contents

Project Narrative PDF

1. Table of Contents - use 'TOC - Budget Summaries' FMP report (see RFP Reports in FMP).
2. For each proposal, compile the following parts from the exported proposal folders:
   • 90-2
   • project description
   • references and citations
   • CVs

Budget Narrative PDF

1. Table of Contents - use 'TOC - Budget Summaries' FMP report (see  RFP Reports in FMP).
2. For each proposal, compile the following parts from the exported proposal folders:
   • Overall 90-4 Sub-award Coverpage (if applicable)
   • Overall 90-4
   • FY 90-4 Sub-award Coverpages (if applicable)
   • FY 90-4s

90-2 Bulk Upload Template

The "90-2 Bulk Upload Template" requirement is satisfied via Excel spreadsheets generated from two FMP layouts, "Proposal Bulk Export (Excel) - 90-2s" and "Proposal Bulk Export (Excel) - budgets", both of which are located in the 'FMP Administration' section of the main RFP FMP layout drop-down. Log-in to the Filemaker Pro interfaces as the Super-Admin user to access these layouts.

*Since eSeaGrant generates an approved equivalent to the 90-2 Bulk Upload Template provided by NSGO, programs using eSeaGrant to compile their omnibus are NOT required to manually complete the 90-2 Bulk Upload Template.

The set of proposals included in both of these layouts is controlled via the 'Include in Omnibus?' toggle of each full proposal.

Most of the fields in these two layouts are read-only, since they reflect data elsewhere in the system.
 

A. Prior to exporting spreadsheets

You must verify accuracy and completeness of each layout prior to exporting them to Excel spreadsheets:

Investigator affiliations

If all of the preceding steps have been fully completed, the only task remaining to ensure a complete spreadsheet export is to check investigator affiliations in the FMP layout "Proposal Bulk Export (Excel) - 90-2s", as follows:

If an investigator's affiliation...

a) is not in the maintained Institutions list (i.e. the PI typed it into the field "enter unlisted affiliation here" when adding the investigator to their proposal),

or

b) is in the list but the investigators affiliation code isn't set in the 90-2 Proposal Bulk Export layout,

…then the corresponding affiliation box in the 90-2 Proposal Bulk Export layout will display 'not set or included in list' in red. A write-in institution should be added to the maintained Institutions list, toggled for display in web form drop-down lists (if desired), and the corresponding NSGO Partner ID (if available) should be retrieved from the NSGO Partners list ( download: Partner IDs and Names.xlsx). The new institution's type and scale should also be set, regardless of whether an NSGO Partner ID is available. If this institution is not included in the NSGO Partners list, then the NSGO Partners ID field in the Institutions list should be left blank until that institution is included in the NSGP Partners list. once the new institution is added to the Institutions list, return to the 90-2 Proposal Bulk Export layout and select it for the investigator. This sets the investigator’s affiliation code.

B. Exporting spreadsheets

When accuracy and completeness of the data in each Proposal Bulk Export layout is verified, click the 'Export' button at top right of both layouts to generate spreadsheets.


C. Using spreadsheet exports to fulfill 90-2 Bulk-Upload Template requirement

The "90-2 Bulk Upload Template" requirement is fulfilled when the contents of these two spreadsheets are copied and pasted into the 90-2 Bulk Upload template, as follows:

[ download: 90-2 Bulk Upload Template (mod4.8) ]

To put your eSeaGrant-generated data into the 90-2 template, you need only copy it to the appropriate tab in the template. The 90-2 project data goes into the "ProjDataInput" tab, and the yearly budget data goes into the "FundDataInput" tab.

You can check to see if the formatting worked by going to the "CHECK DATA FIT" tab on the template, to see if the data you entered is showing up in the fields where you expect it.

NOTE - As of version 5.5a, the 90-2 Bulk Upload template requires at least one budget record for each project record, even if the budget totals for that project are zero.

After you have successfully copied your data into the two data input tabs, the entire rest of the template (the Table of Contents, and all of the 90-2s) will pre-fill with your data. From this point you can manually edit the data, add more information or more projects as you need to, until you are satisfied with all of your information. There are buttons to print out the Table of Contents and the 90-2s, to clear, copy, or paste data, and to reset the data to just the eSeagrant pre-fill data if you are unhappy with your manual edits.

If you use a Mac for this work, you will need Excel 2011 for Mac--earlier versions won't work. Any recent version of Excel for PC seems to work.