{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["NSF COA Template"],"read":"whole","date_system":"1900"}

{"sheet":"NSF COA Template","index":0,"n_rows":65,"n_cols":5,"rows_kept":65}
["The following information regarding collaborators and other affiliations (COA) must be separately provided for each individual identified as senior project personnel. The COA information must be provided through use of this COA template.  \n\nPlease complete this template (e.g., Excel, Google Sheets, LibreOffice), save as .xlsx or .xls, and upload directly as a Research.gov or FastLane Collaborators and Other Affiliations single-copy document. Do not upload .pdf. Grants.gov Users: The COA information must be provided through use of the COA template and uploaded as a PDF attachment.\n\nPlease note that some information requested in prior versions of the PAPPG is no longer requested. THIS IS PURPOSEFUL AND WE NO LONGER REQUIRE THIS INFORMATION TO BE REPORTED. Certain relationships will be reported in other sections (i.e., the names of postdoctoral scholar sponsors should not be reported, however if the individual collaborated on research with their postdoctoral scholar sponsor, then they would be reported as a collaborator). The information in the tables is not required to be sorted, alphabetically or otherwise. "]
["There are five separate categories of information which correspond to the five tables in the COA template:\n\nCOA template Table 1:\nList the individual’s last name, first name, middle initial, and organizational affiliation in the last 12 months. "]
["COA template Table 2:\nList names as last name, first name, middle initial, for whom a personal, family, or business relationship would otherwise preclude their service as a reviewer."]
["COA template Table 3:\nList names as last name, first name, middle initial, and provide organizational affiliations, if known, for the following: \n• The individual’s Ph.D. advisors; and\n• All of the individual’s Ph.D. thesis advisees."]
["COA template Table 4:\nList names as last name, first name, middle initial, and provide organizational affiliations, if known, for the following:\n• Co-authors on any book, article, report, abstract or paper with collaboration in the last 48 months (publication date may be later); and\n• Collaborators on projects, such as funded grants, graduate research or others in the last 48 months. \n"]
["COA template Table 5:\nList editorial board, editor-in chief and co-editors with whom the individual interacts.  An editor-in-chief must list the entire editorial board.\n • Editorial Board: List name(s) of editor-in-chief and journal in the past 24 months; and\n• Other co-Editors of journal or collections with whom the individual has directly interacted in the last 24 months."]
["The template has been developed to be fillable, however, the content and format requirements must not be altered by the user. This template must be saved in .xlsx or .xls format, and directly uploaded into Research.gov or FastLane as a Collaborators and Other Affiliations single-copy document. Using the .xlsx or .xls format will enable preservation of searchable text that otherwise would be lost. It is therefore imperative that this document be uploaded in .xlsx or .xls only. Uploading a document in any format other than .xlsx or .xls may delay the timely processing and review of the proposal.\n\nThis information is used to manage reviewer selection. See Exhibit II-2 for additional information on potential reviewer conflicts.  "]
[" 1. Note that graduate advisors are no longer required to be reported.\n 2. Editorial Board does not include Editorial Advisory Board, International Advisory Board, Scientific Editorial Board, or any other subcategory of Editorial Board. It is limited to those individuals who perform editing duties or manage the editing process (i.e., editor in chief)."]
["List names as Last Name, First Name, Middle Initial.  Additionally, provide email, organization, and department (optional) to disambiguate common names."]
["Fixed column widths keep this sheet one page wide; if you cut and paste text, set font size at 10pt or smaller, and abbreviate, where necessary, to make the data fit. "]
["To insert n blank rows, select n row numbers to move down, right click, and choose Insert from the menu. "]
["\nYou may fill-down (crtl-D) to mark a sequence of collaborators, or copy affiliations.  Excel has arrows that enable sorting."]
["For \"Last Active Date\" and \"Last Active\" columns dates are optional, but will help NSF staff easily determine which information remains relevant for reviewer selection. \n“Last Active Date” and “Last Active” columns may be left blank for ongoing or current affiliations. "]
[]
["Table 1: List the individual’s last name, first name, middle initial, and organizational affiliation in the last 12 months."]
["1","Your Name:","Your Organizational Affiliation(s), last \n12 mo","Last Active Date"]
[null,"Alphaman, Alan K","Test University XYZ "]
[null,null,"Test University ABC (adjunct)","2017-01-01"]
[null,null,"Test University DEF (interviewed)","2016-12-12"]
[]
[]
[]
["Table 2: List names as last name, first name, middle initial, for whom a personal, family, or business relationship would otherwise preclude their service as a reviewer."]
[null,"R: Additional names for whom some relationship would otherwise preclude their service as a reviewer."]
[]
[{"$nulls":3},"to disambiguate common names"]
["2","Name:","Type of Relationship","Optional  (email, Department)","Last Active"]
["R:","Alphaman, Alexander","Family"]
[]
[]
[]
[]
[]
["Table 3: List names as last name, first name, middle initial, and provide organizational affiliations, if known, for the following.\nG: The individual’s Ph.D. advisors; and \nT: All of the individual’s Ph.D. thesis advisees."]
[]
[{"$nulls":3},"to disambiguate common names"]
["3","Advisor/Advisee Name:","Organizational Affiliation","Optional  (email, Department)"]
["G:","Alphaman2, Alice","Test University XYZ ","Department X"]
["T:"]
[]
[]
[]
[]
[]
[]
["Table 4: List names as last name, first name, middle initial, and provide organizational affiliations, if known, for the following:"]
["A: Co-authors on any book, article, report, abstract or paper with collaboration in the last 48 months (publication date may be later); and "]
["C: Collaborators on projects, such as funded grants, graduate research or others in the last 48 months."]
[]
[{"$nulls":3},"to disambiguate common names"]
["4","Name:","Organizational Affiliation","Optional  (email, Department)","Last Active"]
["A:","Alphaman3, Adam","Test University 1234","example@example.com","2015-01-01"]
["A:"]
["C:"]
[]
[]
[]
["Table 5: List editorial board, editor-in chief and co-editors with whom the individual interacts. An editor-in-chief must list the entire editorial board."]
["B: Editorial Board:  List name(s) of editor-in-chief and journal in the past 24 months; and "]
["E: Other co-Editors of journal or collections with whom the individual has directly interacted in the last 24 months."]
[]
[{"$nulls":3},"to disambiguate common names"]
["5","Name:","Organizational Affiliation","Journal/Collection","Last Active"]
["B:","Alphaman4, Ann","Test University XYZ ","Journal ABC","2017-01-01"]
["E:"]