90-2 Project Summary SHORT form

---

Overview

Instructions
90-2-Start Here
Yearly Breakdown
second 90-2
Yearly Breakdown (2)
NewPartner
PartnerSearch
90-2formulas
FocusAreas
SPcodes
TRLs
ProgramIDs
ProjectRecords
FundingRecords
yearly breakdown worksheet
CHECK DATA FIT
ProjDataInput
FundDataInput

---

Sheet 1: Instructions

90-2 SHORT FORM	filename:	90-2-Project-Summary-SHORT-Form-092717.xlsm
INSTRUCTIONS
You must use the lookup table to fill in boxes if it is available. Do not type alternate text in those boxes.
1. After you have fully read these instructions, go to first worksheet tab "90-1-Start Here"--this is the blank 90-2 form.
2. Fill in all the colored cells on the 90-2 form.. Your Sea Grant program can help if there are cells you don't know the answer to, or they may say to just leave those blank.
- First, Select the Program from a dropdown menu of all Sea Grant Program standard abbreviations.
- Unless your Sea Grant Program tells you differently, you can leave the Prefix and Project Number fields blank
- There's only room for four Pis. If you have more, report them in the Methodology. Add a sentence like this: "Additional PIs: John Smith, Auburn University; Jane Doe, Auburn University"
- Certain cells are filled using lookup tables. To fill these cells, click the "Look Up" button next to the cell, and follow the directions. If a cell has a "Look Up" button next to it, you must use the lookup table to fill it out (don't just write in).
- Some cells ("Partners","Classification Codes", "Focus Areas") allow multiple values. Get them from the lookup table one at a time. Look up your first partner, enter it and return to look up your second, etc. Again, consult with your SG program if you don't know what to do.
- Don't neglect to include the total Federal request, and the total match.
- You do not need to fill in any of the uncolored cells.
3. When you are done filling in the 90-2 tab, go to the second tab, "Yearly Breakdown", and fill in your total Federal and Matching Fund amounts for each year of your project.
4. Save the Excel file, and include the file in your full application as an "Other" attachment. ATTACH TO YOUR APPLICATION AS AN EXCEL FILE, NOT A PDF OF THE EXCEL FILE!

---

Sheet 2: 90-2-Start Here

This worksheet is:

#VALUE!

OMB no.

0648-0362, exp x/x/xxxx

S1-Start Here

(default worksheet name)

28

Don't use after

12/31/2017

This form is periodically updated with all the new Sea Grant partners. If you use too old a form, it will miss some of those partners. Why?

2

updated

12/6/2017

(temp workspace for a current cell value)

SEA GRANT PROJECT SUMMARY FORM 90-2

NSGO use only

2375 Resilient Communities and Economies

(temp workspace for a new selected value)

2375 Resilient Communities and Economies

(function to concatenate the above two cells)

INSTITUTION (Program):

TITLE:

(Program listed on first 90-2)

START DATE:

PREFIX (A,C,E,M,P or R):

PROJECT NUMBER

END DATE:

(every project must have a prefix)

READINESS LEVELS:

PI:

AFFILIATION:

Worksheet

tools:

co-PI:

AFFILIATION:

co-PI:

AFFILIATION:

co-PI:

AFFILIATION:

FEDERAL $ REQUEST:

0

MATCH $:

0

CLASSIFICATION CODES:

(Primary Code First)

FOCUS AREAS:

(Primary Focus Area First)

PARTNERS:

OBJECTIVES:

MULTIPROGRAM?

METHODOLOGY:

OTHER INFORMATION:

(The Data Sharing Plan may be included in the Methodology section)

RATIONALE:

DATA SHARING PLAN:

(Required for all research projects)

---

Sheet 3: Yearly Breakdown

	INFORMATION FROM 90-2 FORM
TITLE:
PI:
Project No:
	FEDERAL	MATCH
TOTAL REQUEST:	0	0
	PLEASE FILL IN YEARLY TOTALS:
	FEDERAL	MATCH
YEAR 1	0	0
YEAR 2	0	0
YEAR 3	0	0
YEAR 4	0	0
sum:	0	0

---

Sheet 4: second 90-2

This worksheet is:

#VALUE!

OMB no.

0648-0362, exp x/xx/xx

S1-Start Here

(default worksheet name)

30

Don't use after

21/31/2017

This form is periodically updated with all the new Sea Grant partners. If you use too old a form, it will miss some of those partners. Why?

2

updated

12/6/2017

(temp workspace for a current cell value)

SEA GRANT PROJECT SUMMARY FORM 90-2

NSGO use only

2392 Environmental Literacy and Workforce Development

(temp workspace for a new selected value)

2392 Environmental Literacy and Workforce Development

(function to concatenate the above two cells)

INSTITUTION (Program):

TITLE:

(Program listed on first 90-2)

START DATE:

PREFIX (A,C,E,M,P or R):

PROJECT NUMBER

END DATE:

(every project must have a prefix)

0

READINESS LEVELS:

PI:

AFFILIATION:

Worksheet

tools:

co-PI:

AFFILIATION:

co-PI:

AFFILIATION:

co-PI:

AFFILIATION:

FEDERAL $ REQUEST:

0

MATCH $:

0

CLASSIFICATION CODES:

(Primary Code First)

FOCUS AREAS:

(Primary Focus Area First)

PARTNERS:

OBJECTIVES:

MULTIPROGRAM?

METHODOLOGY:

OTHER INFORMATION:

(The Data Sharing Plan may be included in the Methodology section)

RATIONALE:

DATA SHARING PLAN:

(Required for all research projects)

---

Sheet 5: Yearly Breakdown (2)

	INFORMATION FROM 90-2 FORM
TITLE:
PI:
Project No:
	FEDERAL	MATCH
TOTAL REQUEST:	0	0
	PLEASE FILL IN YEARLY TOTALS:
	FEDERAL	MATCH
YEAR 1	0	0
YEAR 2	0	0
YEAR 3	0	0
YEAR 4	0	0
sum:	0	0

---

Sheet 6: NewPartner

ADD A NEW PARTNER

S1-Start Here

(worksheet that called the macro)

Use this page after you have tried unsuccessfully to search for your Partner or Affiliation on

32

(row to paste the result into)

the search page. If you haven't searched yet, hit "Cancel" and start over.

'S1-Start Here'!B32

(full formula of where the result is pasted into)

#REF!

(2) Answer these questions:

00000 () ()

(1) Write the name of the new partner below:

Scale?

Type?

Standard Naming Convention:

o Governmental - Office Name or Organization Name Spelled Out (Department

(3) Hit "Add" to add your new Partner

Abbreviation, Agency Abbreviation, Line Abbreviation, Office Abbreviation)

Example: Coastal Services Center (DOC, NOAA, NOS, CSC)

o Academic – University, Office Name or Organization Name Spelled Out (University

or hit "Cancel" if you change your mind.

Abbreviation)

Example: University of Hawaii at Manoa, Department of Zoology (UHM)

---

Sheet 7: PartnerSearch

AFFILIATION LOOKUP. Use the search function to find your institutional affiliation.		Partner info downloaded from PIER on:	11/30/2016		second 90-2	(worksheet that called the macro)
SEARCH DIRECTIONS: (1) put in search words or parts of words below; (2) click on "Search":					17	(row to paste the result into)
(3) Select one affiliation (single-click on that cell), then hit "Add":					'second 90-2'!B17	(full formula of where the result is pasted into)
To return without adding a partner, hit "Cancel":					return
SEARCH TERMS: Institution name contains:
	AND
(entering NAT will get you NATIONAL, natural, International, etc )	BUT NOT
IF YOU'RE SURE your Partner or Affiliation is not in the list below, click on the "****Add New Partner****" button.
	Can also search scale and type. Hit "Show All Partners" to clear.
Name	Scale	Type	found?						IDs	Names
Audubon Zoo	Unknown	Unknown	0
Baton Rouge Zoo	Unknown	Unknown	0
BRECs Baton Rouge Zoo	LOCAL	OTHER PARTNERS	0
Brevard Zoo	LOCAL	NGO	0
Brookfield Zoo	LOCAL	INDUSTRY AND BUSINESS	0
Buffalo Zoo	LOCAL	INDUSTRY AND BUSINESS	0
Chicago Zoological Society	LOCAL	NGO	0
Fish Smart Minnesota Zoo	REGIONAL	NGO	0
Gladys Porter Zoo	LOCAL	NGO	0
Indiana Zoo	LOCAL	INDUSTRY AND BUSINESS	0
Lake Superior Zoo	STATE	NGO	0
Milwaukee County Zoo	LOCAL	GOVERNMENT	0
New York Zoological Society	Unknown	Unknown	0
Oregon State University, Department of Zoology (OSU)	STATE	ACADEMIC INSTITUTION	0
Oregon Zoo	STATE	GOVERNMENT	0
Philadelphia Zoo	LOCAL	OTHER PARTNERS	0
Port Defiance Zoo and Aquarium	LOCAL	OTHER PARTNERS	0
San Diego Zoo	LOCAL	OTHER PARTNERS	0
San Diego Zoo	LOCAL	GOVERNMENT	0
Senaca Park Zoo	LOCAL	NGO	0
St. Louis Zoo	LOCAL	GOVERNMENT	0
Texas A&M University, Zoological Society	STATE	ACADEMIC INSTITUTION	0
The Association of Zoos and Aquariums (AZA)	INTERNATIONAL	NGO	0
University of Hawaii at Manoa, Department of Zoology (UHM)	STATE	ACADEMIC INSTITUTION	0
Virginia Zoo	LOCAL	GOVERNMENT	0
Woodland Park Zoo	LOCAL	NGO	0
Zoological Institute, Russian Academy of Sciences, St. Petersburg, Russia	INTERNATIONAL	ACADEMIC INSTITUTION	0
Zooniverse	INTERNATIONAL	NGO	0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0
			0

---

Sheet 8: 90-2formulas

Generated from row:

2

OMB no.

0648-0362

S1

(default worksheet name)

Don't use after

12/31/2013

2

default data row = (above numerical) plus one

(from ProjectRecord Data)

(temp workspace for a current cell value)

SEA GRANT PROJECT SUMMARY FORM 90-2

National Office does not track these fields:

NSGO use only

(temp workspace for a new selected value)

(function to concatenate the above two cells)

INSTITUTION (Program):

0

ICODE:

INSTITUTION (Program):

DE

ICODE:

TITLE:

REV. DATE:

(Program listed on first 90-2)

TITLE:

Sea Grant Extension Program

REV. DATE:

INIT. DATE:

INIT. DATE:

PROJECT NUMBER

COMPL. DATE:

PREFIX (A,C,E,M,P or R):

PROJECT NUMBER

COMPL. DATE:

PROJECT STATUS:

A/X-10

PROJECT STATUS:

SUBPRROGRAM:

SUBPRROGRAM:

PI:

EFFORT:

PI:

Kenneth La Valley

EFFORT:

AFFILIATION:

AFFIL. CODE:

Worksheet

AFFILIATION:

University of New Hampshire, Cooperative Extension (UNH)

AFFIL. CODE:

tools:

2nd PI:

EFFORT:

2nd PI:

p2

EFFORT:

AFFILIATION:

AFFIL. CODE:

AFFILIATION:

a2

AFFIL. CODE:

3rd PI:

EFFORT:

3rd PI:

p3

EFFORT:

AFFILIATION:

AFFIL. CODE:

AFFILIATION:

a3

AFFIL. CODE:

4th PI:

EFFORT:

4th PI:

p4

EFFORT:

AFFILIATION:

AFFIL. CODE:

AFFILIATION:

a4

AFFIL. CODE:

LAST YR FEDERAL:

LAST YR FEDERAL:

FEDERAL $ REQUEST:

0

LAST YR MATCH:

FEDERAL $ REQUEST:

332631

LAST YR MATCH:

MATCH $:

0

RELATED PROJECTS:

MATCH $:

127250

RELATED PROJECTS:

PARENT PROJECTS:

PARENT PROJECTS:

CLASSIFICATION CODES:

KEYWORDS:

CLASSIFICATION CODES:

151 Marine Extension Service - Core

KEYWORDS:

(Primary Code First)

MULTIPROGRAM?

(Primary Code First)

MULTIPROGRAM?

FOCUS AREAS:

OTHER INFORMATION:

FOCUS AREAS:

0954 Sustainable Fisheries and Aquaculture; 0951 Healthy Coastal Ecosystems

OTHER INFORMATION:

(Primary Focus Area First)

(Primary Focus Area First)

PARTNERS:

PARTNERS:

Alaska Sea Grant; American Fisheries Society (AFS); Aquaculture Industry; Atlantic States Marine Fisheries Commission (ASMFC); Blue Alaska Sea Grant; American Fisheries Society (AFS); Aquaculture Industry; Atlantic States Marine Fisheries Commission (ASMFC); Blue Ocean Society; Center for Coastal and Ocean Mapping, Joint Hydrographic Center (US DOC, NOAA, NOS, CCOM-JHC); City of Portsmouth, NH; Coastal and Estuarine Research Federation (ERF); Coastal Conservation Association; Commercial Fisheries News; Commercial Fishing Industry; Connecticut Sea Grant; Delaware Sea Grant; Eastman's Fresh Catch; Eastman’s Fishing Fleet; eXtension; Farm Service Agency (USDA); Fishermen's Voice; Granite State Fish; Granite State Whale Watch; Great Bay Aquaculture, LLCOcean Society; Center for Coastal and Ocean Mapping, Joint Hydrographic Center (US DOC, NOAA, NOS, CCOM-JHC); City of Portsmouth, NH; Coastal and Estuarine Research Federation (ERF); Coastal Conservation Association; Commercial Fisheries News; Commercial Fishing Industry; Connecticut Sea Grant; Delaware Sea Grant; Eastman's Fresh Catch; Eastman’s Fishing Fleet; eXtension; Farm Service Agency (USDA); Fishermen's Voice; Granite State Fish; Granite State Whale Watch; Great Bay Aquaculture, LLC

OBJECTIVES:

OBJECTIVES:

Objectives: Innovative collaborations between the fishing industry and research communities have continued since 1999. Two cooperative research funding organizations, the Northeast Consortium (NEC) and the Cooperative Research Partnership Program (CRPP), have supported these collaborations. The Northeast Consortium received limited funds from NOAA/NMFS and was able to offer a 2010 RFP ($1.2 million). The NMFS CRPP program initiated a collaborative approach to funding fisheries research in the Northeast. A broad agency announcement, or BAA, was released for regional partnerships to submit multi-year projects targeting conservation engineering and fisheries science. Two projects in particular were funded, GEARNET and REDNET. Both included the N.H. Sea Grant Fisheries Program to coordinate extension and outreach. Methodology: As in 2009, the NOAA S-K grant program was appropriated $5 million in 2010 to support fisheries, aquaculture and fisheries social science projects in the Northeast. A new investment in aquaculture research and extension occurred within the National Sea Grant program, which offered $4.8 million to fund research and $2.0 million for aquaculture extension. Although funding for broad topic collaborative research projects has suffered, organizations like the above have allowed for partnerships and cooperative projects to continue, and for aquaculture research, to grow. It has continued to be critical for the fisheries extension program to identify and support the development of outreach and technology transfer mechanisms that will encourage the incorporation of conservation minded fishing gear into the industry. Rationale: With the transition from days-at-sea groundfish management to the current sector allocation system, the small vessel fishing fleet in Maine, N.H. and Mass. has suffered economically, making it even more important that the industry diversify and pursue innovative marketing strategies to sustain their operations. In addition to these challenges, groundfishermen are facing cuts in the allowable catch for their most marketable species (e.g. cod) upwards of 70%. Although lobster catches have recently reached all-time highs, record low boat prices and increasing operational costs, such as fuel expenses, are presenting significant challenges to the sustainability of lobstering as well. The Fisheries Extension program continues to invest a significant portion of its resources and time to work with the industry, local organizations and seafood wholesalers and retailers to increase awareness of and demand and to facilitate development of alternative supply chains that deliver locally branded seafood that deliver higher profits to boats. Data Sharing Plan: dsp

METHODOLOGY:

METHODOLOGY:

(The Data Sharing Plan may be included in the Methodology section)

RATIONALE:

RATIONALE:

DATA SHARING PLAN:

DATA SHARING PLAN:

---

Sheet 9: FocusAreas

worksheet:

90-2-Start Here

Select one Focus Area (single-click on that cell). Hit "Add".

row:

30

SEA GRANT PROJECT SUMMARY FORM 90-2

program:

NJ

Plan

2018

year:

2018

<-- change this to 2014 to see earlier focus areas

Program

NJ

2392

Environmental Literacy and Workforce Development

FA ID

Focus Area

Plan

Program

Plan Start Year

Plan End Year

find?

2392 Environmental Literacy and Workforce Development

2361

Healthy Coastal Ecosystems (HCE)

NEW JERSEY SEA GRANT CONSORTIUM - STRATEGIC PLAN 2018-2021

NJ

2018

2021

1

2362

Sustainable Fisheries and Aquaculture (SFA)

NEW JERSEY SEA GRANT CONSORTIUM - STRATEGIC PLAN 2018-2021

NJ

2018

2021

1

2363

Resilient Communities and Economies (RCE)

NEW JERSEY SEA GRANT CONSORTIUM - STRATEGIC PLAN 2018-2021

NJ

2018

2021

1

2364

Environmental Literacy and Workforce Development (ELWD)

NEW JERSEY SEA GRANT CONSORTIUM - STRATEGIC PLAN 2018-2021

NJ

2018

2021

1

---

Sheet 10: SPcodes

	Find the appropriate classification code below. You may shorten the list
	by entering part or all of a word to search for, and clicking 'Search'.
search for:
	Select one classification code (single-click on that cell)
	then hit 'Add'.
No	Classification Code
10	Commercial Biotechnology		0
11	Molecular Genetics		0
12	Natural Products: Chemistry and Biological Activity		0
13	Bioprocessing, Bioreaction, Cell and Tissue Culture		0
20	Environmental Technology		0
21	Enhancement of Environmental Monitoring and Assessment		0
22	Pollution Control and Prevention		0
23	Remediation		0
30	Revitalize the Nation's Commercial Fisheries		0
31	Ecosystem-Based Fisheries Management		0
32	Fisheries Social and Economic Impacts		0
33	Minimizing Bycatch		0
34	Enhancing Wild Stocks through Aquaculture		0
40	Develop Sustainable U.S. Aquaculture		0
41	Administration and Coordination		0
42	Developing and Improving Grow-out Systems		0
43	Improving Husbandry		0
44	Enhancing Aquaculture through Biotechnology		0
50	Enhance Competitiveness through Advances in Seafood Technology		0
51	Product Quality and Safety		0
52	Processing Technology and Practices		0
53	Waste Management and Byproduct Recovery		0
54	Product Development		0
60	Coastal Business Development		0
61	Fishing Industries		0
62	Coastal Recreation Businesses		0
63	Marine Trades Industry		0
70	Coastal Community Development		0
71	Sustainable Coastal Tourism		0
72	Communities in Transition		0
73	Coastal and Waterfront Redevelopment/ Working Waterfronts		0
74	Ports,Harbors and Clean Marinas		0
75	Planning and Decision-Making Information		0
76	Coastal & Waterway Access		0
77	Green Infrastructure, Green Building and Community Design		0
80	Revitalizing Marine Infrastructure		0
81	Inspection and Condition Surveys		0
82	Environmental and Operational Loadings		0
83	Structure Performance Assessments		0
84	Rehabilitation, Repair, and Recycling Procedures		0
90	Coastal and Great Lakes Water Quality		0
91	Toxics		0
92	Biological Contaminants		0
93	Nutrients		0
94	Sedimentation		0
95	Biotoxins/Harmful Algal Blooms		0
96	Nonpoint Source Pollution		0
97	Chemical and Oil Spills		0
100	Coastal and Great Lakes Habitats		0
101	Habitat Structure and Function		0
102	Habitat Restoration		0
103	Aquatic Invasive Species		0
104	Cumulative Impacts on Habitats		0
105	Integrated Ecosystem Based Management		0
106	Ecosystem Services		0
107	Endangered Species		0
108	Marine Debris		0
110	Sustainable Development		0
111	Socioeconomic Dimensions of Environmental Change		0
112	Coastal Management Policy Tools		0
113	Multiple Use Management and Conflict Resolution/ CMSP		0
114	Water Availability		0
115	Cumulative Impacts of Development		0
120	Coastal and Natural Hazards		0
121	Severe Storms		0
122	Earthquakes and Tsunamis		0
123	Coastal Planning and Building Construction Techniques		0
124	Shoreline Processes and Erosion		0
125	Floodplain Management		0
126	Coastal Inundation		0
127	Hazard Mitigation & Adaptation		0
130	Safety at Sea		0
131	Vessel Stability Research		0
132	Equipment Design and Testing		0
133	Survival and Safety		0
134	Recreational and Commercial Diving		0
140	Education		0
141	Education - Pre-college		0
142	Education - University		0
143	Education - Informal		0
150	Marine Advisory Extension Service		0
151	Marine Extension Service - Core		0
152	Marine Extension Service - Special Projects		0
160	Communications		0
161	Communications - Core		0
162	Communications - Special Projects		0
170	Program Administration		0
170	Program Administration		0
171	Future Selected Projects		0
180	Program Development		0
180	Program Development		0
190	OTHER		0
200	Climate		0
201	Climate Modeling		0
202	Climate Impacts		0
203	Climate Literacy		0
204	Climate Mitigation		0
205	Climate Adaptation		0
206	Ocean Acidification		0
210	Energy		0
211	Alternative and Renewable Energy		0
212	Energy Conservation		0
213	Traditional Energy		0
220	Social Science		0
220	Social Science		0
221	Information on socioeconomic context		0
222	Impact evaluation		0
230	Marine & Aquatic Literacy		0
231	Pre-College GK-12 Literacy		0
232	University Literacy		0
233	Informal Literacy		0

---

Sheet 11: TRLs

SELECT READINESS LEVELS													90-2-Start Here
		selected:											5
Click the checkbox â	RESEARCH PROJECTS: Please use the checkboxes to select all of the Readiness Levels that describe components of your project. After you have selected the appropriate Readiness Levels, click on "Return". Click on "Cancel" to return without assigning any levels, NON-RESEARCH PROJECTS: No action is needed. Click "Cancel"
	1	RL 1: Basic research: experimental or theoretical work undertaken primarily to acquire new knowledge of the underlying foundations of phenomena and observable facts, without any particular application or use in view. Basic research can be oriented or directed towards some broad fields of general interest, with the explicit goal of a range of future applications (OECD, 2015);					0
	2	RL 2: Applied research: original investigation undertaken in order to acquire new knowledge. It is, however, directed primarily towards a specific, practical aim or objective. Applied research is undertaken either to determine possible uses for the findings of basic research or to determine new methods or ways of achieving specific and predetermined objectives (OECD, 2015).					0
	3	RL 3: Proof-of-concept for system, process, product, service or tool; this can be considered an early phase of experimental development; feasibility studies may be included;					0
	4	RL 4: Successful evaluation of system, subsystem, process, product, service or tool in laboratory or other experimental environment; this can be considered an intermediate phase of development;					0
	5	RL 5: Successful evaluation of system, subsystem process, product, service or tool in relevant environment through testing and prototyping; this can be considered the final stage of development before demonstration begins;					0
	6	RL 6: Demonstration of prototype system, subsystem, process, product, service or tool in relevant or test environment (potential demonstrated);					0
	7	RL 7: Prototype system, process, product, service or tool demonstrated in an operational or other relevant environment (functionality demonstrated in near-real world environment; subsystem components fully integrated into system).					0
	8	RL 8: Finalized system, process, product, service or tool tested, and shown to operate or function as expected within user's environment; user training and documentation completed; operator or user approval given;					0
	9	RL 9: System, process, product, service or tool deployed and used routinely.					0

---

Sheet 12: ProgramIDs

Abbrev	Names	Program ID	Abbrev
AK	ALASKA SEA GRANT	1	AK
CA	CALIFORNIA SEA GRANT	2	CA
CT	CONNECTICUT SEA GRANT	3	CT
DE	DELAWARE SEA GRANT	4	DE
FL	FLORIDA SEA GRANT	6	FL
GA	GEORGIA SEA GRANT	7	GA
HI	HAWAII SEA GRANT	8	HI
IL-IN	Illinois-Indiana Sea Grant	9	IL-IN
LA	LOUISIANA SEA GRANT	11	LA
ME	MAINE SEA GRANT	12	ME
MD	MARYLAND SEA GRANT	13	MD
MIT	Massachusetts Institute of Technology SEA GRANT	14	MIT
MI	MICHIGAN SEA GRANT	15	MI
MN	MINNESOTA SEA GRANT	16	MN
MS-AL	MISSISSIPPI-ALABAMA SEA GRANT	17	MS-AL
NH	NEW HAMPSHIRE SEA GRANT	18	NH
NJ	NEW JERSEY SEA GRANT	19	NJ
NY	NEW YORK SEA GRANT	20	NY
NC	NORTH CAROLINA SEA GRANT	21	NC
OH	OHIO SEA GRANT	22	OH
OR	OREGON SEA GRANT	23	OR
PA	PENNSYLVANIA SEA GRANT	24	PA
PR	PUERTO RICO SEA GRANT	25	PR
RI	RHODE ISLAND SEA GRANT	26	RI
SC	SOUTH CAROLINA SEA GRANT	27	SC
USC	UNIVERSITY OF SOUTHERN CALIFORNIA SEA GRANT	28	USC
TX	TEXAS SEA GRANT	29	TX
LC	LAKE CHAMPLAIN SEA GRANT	30	LC
VA	VIRGINIA SEA GRANT	31	VA
WA	WASHINGTON SEA GRANT	32	WA
WI	WISCONSIN SEA GRANT	33	WI
WHOI	Woods Hole Oceanographic Institution Sea Grant	34	WHOI
NSGCP	NATIONAL SEA GRANT COLLEGE PROGRAM	47	NSGCP
LAW	SEA GRANT LAW CENTER	48	LAW
NSGO	National Sea Grant Office	49	NSGO
GU	GUAM SEA GRANT	50	GU
LIB	NATIONAL SEA GRANT LIBRARY	51	LIB

---

Sheet 13: ProjectRecords

B6

B7

B30

B32

B28

B25

B26

B13

B14

B16

B17

B19

B20

B22

B23

G6

G7

G8

G9

G10

G11

B40

E8

E9

E34

B11

numbers below are drawn from the yearly breakdown tabs

E12

ID

worksheet

Abbrev

Proj No

Title

Focus Area

Partner

Class Code

Abstracts

Total Fed

Total Mat

PI1

Affiliation1

PI2

Affiliation2

PI3

Affiliation3

PI4

AFFIL4

NSGO1

NSGO2

NSGO3

NSGO4

NSGO5

NSGO6

Data Sharing Plan

Comments

StartDate

EndDate

MultiProgram

Competitive

FedYear1

MatchYear1

FedYear2

MatchYear2

FedYear3

MatchYear3

FedYear4

MatchYear4

TRL

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

0

0

0

0

0

0

0

0

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

#VALUE!

0

0

0

0

0

0

0

0

#VALUE!

---

Sheet 14: FundingRecords

Program ID number	Year	Proj No	Grant	Amendment	Fund Source	Federal	Match
#N/A	1900	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1901	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1902	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1903	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1900	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1901	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1902	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0
#N/A	1903	#VALUE!	#VALUE!	#VALUE!	#VALUE!	0	0

---

Sheet 15: yearly breakdown worksheet

Program ID number	Year	Proj No	Federal	Match	unique	row index	years	projects	PI	Title	FED	MATCH	FED	MATCH	FED	MATCH	FED	MATCH			COMMENT	2014
0	0	0	0	0			2014	#REF!			0	0	0	0	0	0	0	0				2014
0	0	0	0	0			2015	#REF!			0	0	0	0	0	0	0	0				9999
0	0	0	0	0			2016				0	0	0	0	0	0	0	0				9999
0	0	0	0	0			2017				0	0	0	0	0	0	0	0				9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999
0	0	0	0	0																		9999

---

Sheet 16: CHECK DATA FIT

CHECK FIT OF SYSTEM DATA
PROJECT RECORDS (into "ProjDataInput" Tab)						FUND RECORDS (into "FundDataInput" Tab)
NOTE: Field names don't have to match the name of your column header, the						NOTE: Field names don't have to match the name of your column header, the
columns just have to be in the correct order						columns just have to be in the correct order
			Data row shown:
FIELD NAME	YOUR COLUMN HEADER	YOUR Nth DATA ROW	N =	1		FIELD NAME	YOUR COLUMN HEADER	YOUR Nth DATA ROW
ProgramName	ProgramName					ProgramID	Program ID number	0
ProjectNumber	ProjectNumber					Year	Year	0
ProjectTitle	ProjectTitle					ProjectNumber	Proj No
ProgramFocusAreas	ProgramFocusArea					Federal	Federal	0
ProgramPartners	ProgramPartners					Match	Match	0
ClassificationCodes	ClassificationCodes					Comments	Comments
Abstract	Abstract
TotalFederal	TotalFederal	0
TotalMatch	TotalMatch	0
PI1	PI1
Affiliation1	Affiliation1
PI2	PI2
Affiliation2	Affiliation2
PI3	PI3
Affiliation3	Affiliation3
PI4	PI4
Affiliation4	AFFIL4
DataSharingPlan	Data Sharing Plan
Comments	COMMENTS

---

Sheet 17: ProjDataInput

ProgramName

ProjectNumber

ProjectTitle

ProgramFocusArea

ProgramPartners

ClassificationCodes

Abstract

TotalFederal

TotalMatch

PI1

Affiliation1

PI2

Affiliation2

PI3

Affiliation3

PI4

AFFIL4

Data Sharing Plan

COMMENTS

---

Sheet 18: FundDataInput

Program ID number

Year

Proj No

Federal

Match

Comments