{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["Form Info","Form DAT"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Form Info","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[5,1,5,2],[6,0,10,0],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,2]],"flags":["formulas_cached_only"]}
["FORM INFORMATION"]
["Form Name / Title","EPA KEY CONTACTS FORM"]
["Form ID",674]
["Form Version","2.0"]
["OMB Control Number ","2030-0020"]
["OMB Expiration Date ","06/30/2024"]
["Form Family\n(select all that apply)","X","SF424"]
[null,null,"SF424 R&R"]
[null,null,"SF424 Individual"]
[null,null,"SF424 Mandatory"]
[null,null,"SF424 Short Organizational"]

{"sheet":"Form DAT","index":1,"n_rows":84,"n_cols":19,"rows_kept":84,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["FORM TITLE:",null,"EPA KEY CONTACTS FORM"]
["[1]","[2]\n","[3]\n","[4]\n","[5]\n","[6]\n","[7]\n","[8]\n","[9]","[10]\n","[11]\n","[12]","[13]","[14]","[15]\n","[16]\n","[17]\n","[18]\n","[19]\n"]
["Field #","Field\nLabel","Field ID","Required?","Minimum\nOccurrences","Maximum\nOccurrences","Agency Field\nName","Field Type","Global Library\nField Name","Field Type\nSource","Business Rules","Data Type","List of\nValues","Min  # of Chars or\nMin Value","Max # of\nChars or\nMax Value","Field\nImplementation","Help Tip","Mandatory Message","Validation Message"]
["0-0","View Burden Statement","Burden Statement Button",{"$nulls":4},"Agency-specific",null,null,"Clicking displays the following:\nThis collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2030-0020). Responses to this collection of information are required to obtain an assistance agreement (40 CFR Part 30, 40 CFR Part 31, and 40 CFR Part 33 for awards made prior to December 26, 2014, and 2 CFR 200, 2 CFR 1500, and 40 CFR Part 33 for awards made after December 26, 2014). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The public reporting and recordkeeping burden for this collection of information is estimated to be 0.5 hours per response. Send comments on the Agency’s need for this information, the accuracy of the provided burden estimates and any suggested methods for minimizing respondent burden to the Regulatory Support Division Director, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., NW, Washington, D.C. 20460. Include the OMB control number in any correspondence. Do not send the completed form to this address.",{"$nulls":4},"Button","View Burden Statement"]
["0-1","OMB Number: 2030-0020 \nExpiration Date: 06/30/2024","OMB Number and Expiration Date Text",{"$nulls":12},"Label"]
["0-2","EPA KEY CONTACTS FORM","Form Title Text",{"$nulls":7},"Heading appears on each page",{"$nulls":4},"Label"]
["B1-0","Authorized Representative:","Authorized Representative Header",{"$nulls":12},"Label"]
["B1-01","Original awards and amendments will be sent to this individual for review and acceptance, unless otherwise indicated.","Original Awards and Amendments Text",{"$nulls":12},"Label"]
["B1-02","Name:","AOR Name Text","No",0,1,"AuthorizedRepresentative","Global","globLib:HumanNameDataType",{"$nulls":6},"Label"]
["B1-03","Prefix:","AOR Prefix","No",0,1,"PrefixName","Global","globLib:PrefixName",null,null,"LIST","Mr.; Mrs.; Miss; Ms.; Dr.; Rev.; Prof.",0,10,"Combobox","Please select the Authorized Representative's Prefix from the provided list or enter a new Prefix not provided on the list."]
["B1-04","First Name:","AOR First Name","No",0,1,"FirstName","Global","globLib:FirstName",null,"Conditionally required if any Authorized Representative fields are entered.","AN",null,0,35,"Field","Please enter the Authorized Representative's First Name.","First Name is required: Please enter the Authorized Representative's First Name."]
["B1-05","Middle Name:","AOR Middle Name","No",0,1,"MiddleName","Global","globLib:MiddleName",null,null,"AN",null,0,25,"Field","Please enter the Authorized Representative's Middle Name."]
["B1-06","Last Name:","AOR Last Name","No",0,1,"LastName","Global","globLib:LastName",null,"Conditionally required if any Authorized Representative fields are entered.","AN",null,0,60,"Field","Please enter the Authorized Representative's Last Name.","Last Name is required: Please enter the Authorized Representative's Last Name."]
["B1-07","Suffix:","AOR Suffix","No",0,1,"SuffixName","Global","globLib:SuffixName",null,null,"LIST","Jr.; Sr.; M.D.; Ph.D",0,10,"Combobox","Please select the Authorized Representative's Suffix from the provided list or enter a new Suffix not provided on the list."]
["B1-08","Title:","AOR Title ","No","0","1","Title","Global","globLib:HumanTitleDataType",null,null,"AN",null,"0",45,"Field","Please enter the Authorized Representative's Title."]
["B1-09","Complete Address:","AOR Address","No","0","1","Address","Global","globLib:AddressDataType",{"$nulls":6},"Label"]
["B1-10","Street1:","AOR Street 1","No","0","1","Street1","Global","globLib:Street1",null,"Conditionally required if any Authorized Representative fields are entered.","AN",null,0,55,"Field","Please enter the first line of the Authorized Representative's Street Address.","Street1 is required: Please enter the first line of the Authorized Representative's Street Address."]
["B1-11","Street2:","AOR Street 2","No",0,1,"Street2","Global","globLib:Street2",null,null,"AN",null,0,55,"Field","Please enter the second line of the Authorized Representative's Street Address."]
["B1-12","City:","AOR City","No",0,1,"City","Global","globLib:City",null,"Conditionally required if any Authorized Representative fields are entered.","AN",null,0,35,"Field","Please enter the Authorized Representative's City.","City is required: Please enter the Authorized Representative's City."]
["B1-13","State:","AOR State","No",0,1,"State","Global","globLib:State",null,"Active & not required when form is first opened. After exiting country field, conditionally active and required if Country is US, inactive if Country is not US.","LIST","50 US States, US possessions, territories, military codes",0,55,"Popup","Please enter the Authorized Representative's State. Select from the pull down menu.","State is required: Please select the Authorized Representative's State."]
["B1-14","Zip / Postal Code:","AOR Zip / Postal Code","No",0,1,"ZipPostalCode","Global","globLib:ZipPostalCode",null,"Conditionally required if Country is US. If Country is not US, then optional.","AN",null,0,30,"Field","Please enter the Authorized Representative's Zip / Postal Code.","ZIP / Postal Code is required: Please enter the Authorized Representative's ZIP / Postal Code."]
["B1-15","Country:","AOR Country","No",0,1,"Country","Global","globLib:Country",null,"Conditionally required if any Authorized Representative fields are entered.","LIST","GENC Standard Ed3.0 Update 11",0,49,"Popup","Please enter the Authorized Representative's Country. Select from the pull down menu.","Country is required: Please select the Authorized Representative's Country."]
["B1-16","Phone Number:","AOR Phone Number","No","0","1","Phone","Global","globLib:TelephoneNumberDataType",null,"Conditionally required if any Authorized Representative fields are entered.","AN",null,"0",25,"Field","Please enter the Authorized Representative's Phone Number.","Phone Number is required: Please enter the Authorized Representative's Phone Number."]
["B1-17","Fax Number:","AOR Fax Number","No","0","1","Fax","Global","globLib:TelephoneNumberDataType",null,null,"AN",null,"0",25,"Field","Please enter the Authorized Representative's Fax Number."]
["B1-18","E-mail Address:","AOR E-mail Address","No","0","1","Email","Global","globLib:EmailDataType",null,"E-mail validation","AN",null,"0",60,"Field","Please enter the Authorized Representative's E-mail Address.",null,"Email Address is invalid: Enter a valid Email Address."]
["B2-0","Payee:","Payee Header",{"$nulls":12},"Label"]
["B2-01","Individual authorized to accept payments.","Individual to Accept Payments Text",{"$nulls":12},"Label"]
["B2-02","Name:","Payee Name","No",0,1,"Payee","Global","globLib:HumanNameDataType",{"$nulls":6},"Label"]
["B2-03","Prefix:","Payee Prefix","No",0,1,"PrefixName","Global","globLib:PrefixName",null,null,"LIST","Mr.; Mrs.; Miss; Ms.; Dr.; Rev.; Prof.",0,10,"Combobox","Please select the Payee's Prefix from the provided list or enter a new Prefix not provided on the list."]
["B2-04","First Name:","Payee First Name","No",0,1,"FirstName","Global","globLib:FirstName",null,"Conditionally required if any Payee fields are entered.","AN",null,0,35,"Field","Please enter the Payee's First Name.","First Name is required: Please enter the Payee’s First Name."]
["B2-05","Middle Name:","Payee Middle Name","No",0,1,"MiddleName","Global","globLib:MiddleName",null,null,"AN",null,0,25,"Field","Please enter the Payee's Middle Name."]
["B2-06","Last Name:","Payee Last Name","No",0,1,"LastName","Global","globLib:LastName",null,"Conditionally required if any Payee fields are entered.","AN",null,0,60,"Field","Please enter the Payee's Last Name.","Last Name is required: Please enter the Payee’s Last Name."]
["B2-07","Suffix:","Payee Suffix","No",0,1,"SuffixName","Global","globLib:SuffixName",null,null,"LIST","Jr.; Sr.; M.D.; Ph.D",0,10,"Combobox","Please select the Payee's Suffix from the provided list or enter a new Suffix not provided on the list."]
["B2-08","Title:","Payee Title ","No","0","1","Title","Global","globLib:HumanTitleDataType",null,null,"AN",null,"0",45,"Field","Please enter the Payee's Title."]
["B2-09","Complete Address:","Payee Address","No",0,1,"Address","Global","globLib:AddressDataType",{"$nulls":6},"Label"]
["B2-10","Street1:","Payee Street 1","No",0,1,"Street1","Global","globLib:Street1",null,"Conditionally required if any Payee fields are entered.","AN",null,0,55,"Field","Please enter the first line of the Payee's Street Address.","Street1 is required: Please enter the first line of the Payee’s Street Address."]
["B2-11","Street2:","Payee Street 2","No",0,1,"Street2","Global","globLib:Street2",null,null,"AN",null,0,55,"Field","Please enter the second line of the Payee's Street Address."]
["B2-12","City:","Payee City","No",0,1,"City","Global","globLib:City",null,"Conditionally required if any Payee fields are entered.","AN",null,0,35,"Field","Please enter the Payee's City.","City is required: Please enter the Payee’s City."]
["B2-13","State:","Payee State","No",0,1,"State","Global","globLib:State",null,"Active & not required when form is first opened. After exiting country field, conditionally active and required if Country is US, inactive if Country is not US.","LIST","50 US States, US possessions, territories, military codes",0,55,"Popup","Please enter the Payee's State. Select from the pull down menu.","State is required: Please select the Payee’s State."]
["B2-14","Zip / Postal Code:","Payee Zip / Postal Code","No",0,1,"ZipPostalCode","Global","globLib:ZipPostalCode",null,"Conditionally required if Country is US. If Country is not US, then optional.","AN",null,0,30,"Field","Please enter the Payee's Zip / Postal Code.","ZIP / Postal Code is required: Please enter the Payee’s ZIP / Postal Code."]
["B2-15","Country:","Payee Country","No",0,1,"Country","Global","globLib:Country",null,"Conditionally required if any Payee fields are entered.","LIST","GENC Standard Ed3.0 Update 11",0,49,"Popup","Please enter the Payee's Country. Select from the pull down menu.","Country is required: Please select the Payee’s Country."]
["B2-16","Phone Number:","Payee Phone Number","No","0","1","Phone","Global","globLib:TelephoneNumberDataType",null,"Conditionally required if any Payee fields are entered.","AN",null,"0",25,"Field","Please enter the Payee's Phone Number.","Phone Number is required: Please enter the Payee’s Phone Number."]
["B2-17","Fax Number:","Payee Fax Number","No","0","1","Fax","Global","globLib:TelephoneNumberDataType",null,null,"AN",null,"0",25,"Field","Please enter the Payee's Fax Number."]
["B2-18","E-mail Address:","Payee E-mail Address","No","0","1","Email","Global","globLib:EmailDataType",null,"E-mail validation","AN",null,"0",60,"Field","Please enter the Payee's E-mail Address.",null,"Email Address is invalid: Enter a valid Email Address."]
["B3-0","Administrative Contact:","Administrative Contact Header",{"$nulls":12},"Label"]
["B3-01","Individual from Sponsored Programs Office to contact concerning administrative matters (i.e., indirect cost rate computation, rebudgeting requests etc).","Individual From Sponsored Programs Office Text",{"$nulls":12},"Label"]
["B3-02","Name:","Administrative Contact Name ","No",0,1,"AdminstrativeContact","Global","globLib:HumanNameDataType",{"$nulls":6},"Label"]
["B3-03","Prefix:","Administrative Contact Prefix","No",0,1,"PrefixName","Global","globLib:PrefixName",null,null,"LIST","Mr.; Mrs.; Miss; Ms.; Dr.; Rev.; Prof.",0,10,"Combobox","Please select the Administrative Contact's Prefix from the provided list or enter a new Prefix not provided on the list."]
["B3-04","First Name:","Administrative Contact First Name","No",0,1,"FirstName","Global","globLib:FirstName",null,"Conditionally required if any Administrative Contact  fields are entered.","AN",null,0,35,"Field","Please enter the Administrative Contact's First Name.","First Name is required: Please enter the Administrative Contact’s First Name."]
["B3-05","Middle Name:","Administrative Contact Middle Name","No",0,1,"MiddleName","Global","globLib:MiddleName",null,null,"AN",null,0,25,"Field","Please enter the Administrative Contact's Middle Name."]
["B3-06","Last Name:","Administrative Contact Last Name","No",0,1,"LastName","Global","globLib:LastName",null,"Conditionally required if any Administrative Contact  fields are entered.","AN",null,0,60,"Field","Please enter the Administrative Contact's Last Name.","Last Name is required: Please enter the Administrative Contact’s Last Name."]
["B3-07","Suffix:","Administrative Contact Suffix","No",0,1,"SuffixName","Global","globLib:SuffixName",null,null,"LIST","Jr.; Sr.; M.D.; Ph.D",0,10,"Combobox","Please select the Administrative Contact's Suffix from the provided list or enter a new Suffix not provided on the list."]
["B3-08","Title:","Administrative Contact Title ","No","0","1","Title","Global","globLib:HumanTitleDataType",null,null,"AN",null,"0",45,"Field","Please enter the Administrative Contact's Title."]
["B3-09","Complete Address:","Administrative Contact Address","No",0,1,"Address","Global","globLib:AddressDataType",{"$nulls":6},"Label"]
["B3-10","Street1:","Administrative Contact Street 1","No",0,1,"Street1","Global","globLib:Street1",null,"Conditionally required if any Administrative Contact  fields are entered.","AN",null,0,55,"Field","Please enter the first line of the Administrative Contact's Street Address.","Street1 is required: Please enter the first line of the Administrative Contact’s Street Address."]
["B3-11","Street2:","Administrative Contact Street 2","No",0,1,"Street2","Global","globLib:Street2",null,null,"AN",null,0,55,"Field","Please enter the second line of the Administrative Contact's Street Address."]
["B3-12","City:","Administrative Contact City","No",0,1,"City","Global","globLib:City",null,"Conditionally required if any Administrative Contact  fields are entered.","AN",null,0,35,"Field","Please enter the Administrative Contact's City.","City is required: Please enter the Administrative Contact’s City."]
["B3-13","State:","Administrative Contact State","No",0,1,"State","Global","globLib:State",null,"Active & not required when form is first opened. After exiting country field, conditionally active and required if Country is US, inactive if Country is not US.","LIST","50 US States, US possessions, territories, military codes",0,55,"Popup","Please enter the Administrative Contact's State. Select from the pull down menu.","State is required: Please select the Administrative Contact’s State."]
["B3-14","Zip / Postal Code:","Administrative Contact Zip / Postal Code","No",0,1,"ZipPostalCode","Global","globLib:ZipPostalCode",null,"Conditionally required if Country is US. If Country is not US, then optional.","AN",null,0,30,"Field","Please enter the Administrative Contact's Zip / Postal Code.","ZIP / Postal Code is required: Please enter the Administrative Contact’s ZIP / Postal Code."]
["B3-15","Country:","Administrative Contact Country","No",0,1,"Country","Global","globLib:Country",null,"Conditionally required if any Administrative Contact  fields are entered.","LIST","GENC Standard Ed3.0 Update 11",0,49,"Popup","Please enter the Administrative Contact's Country. Select from the pull down menu.","Country is required: Please select the Administrative Contact’s Country."]
["B3-16","Phone Number:","Administrative Contact Phone Number","No",0,1,"Phone","Global","globLib:TelephoneNumberDataType",null,"Conditionally required if any Administrative Contact  fields are entered.","AN",null,0,25,"Field","Please enter the Administrative Contact's Phone Number.","Phone Number is required: Please enter the Administrative Contact’s Phone Number."]
["B3-17","Fax Number:","Administrative Contact Fax Number","No","0","1","Fax","Global","globLib:TelephoneNumberDataType",null,null,"AN",null,"0",25,"Field","Please enter the Administrative Contact's Fax Number."]
["B3-18","E-mail Address:","Administrative Contact E-mail Address","No","0","1","Email","Global","globLib:EmailDataType",null,"E-mail validation","AN",null,"0",60,"Field","Please enter the Administrative Contact's E-mail Address.",null,"Email Address is invalid: Enter a valid Email Address."]
["B3-a","EPA Form 5700-54 (Rev 4-02)","EPA Form Front Text",{"$nulls":12},"Label"]
["B4-0","Project Manager:","Project Manager Header ",{"$nulls":12},"Label"]
["B4-01","Individual responsible for the technical completion of the proposed work.","Individual Responsible for Technical Completion Text",{"$nulls":12},"Label"]
["B4-02","Name:","Project Manager Name","No",0,1,"ProjectManager","Global","globLib:HumanNameDataType",{"$nulls":6},"Label"]
["B4-03","Prefix:","Project Manager Prefix","No",0,1,"PrefixName","Global","globLib:PrefixName",null,null,"LIST","Mr.; Mrs.; Miss; Ms.; Dr.; Rev.; Prof.",0,10,"Combobox","Please select the Project Manager's Prefix from the provided list or enter a new Prefix not provided on the list."]
["B4-04","First Name:","Project Manager First Name","No",0,1,"FirstName","Global","globLib:FirstName",null,"Conditionally required if any Project Manager fields are entered.","AN",null,0,35,"Field","Please enter the Project Manager's First Name.","First Name is required: Please enter the Project Manager’s First Name."]
["B4-05","Middle Name:","Project Manager Middle Name","No",0,1,"MiddleName","Global","globLib:MiddleName",null,null,"AN",null,0,25,"Field","Please enter the Project Manager's Middle Name."]
["B4-06","Last Name:","Project Manager Last Name","No",0,1,"LastName","Global","globLib:LastName",null,"Conditionally required if any Project Manager fields are entered.","AN",null,0,60,"Field","Please enter the Project Manager's Last Name.","Last Name is required: Please enter the Project Manager’s Last Name."]
["B4-07","Suffix:","Project Manager Suffix","No",0,1,"SuffixName","Global","globLib:SuffixName",null,null,"LIST","Jr.; Sr.; M.D.; Ph.D",0,10,"Combobox","Please select the Project Manager's Suffix from the provided list or enter a new Suffix not provided on the list."]
["B4-08","Title:","Project Manager Title ","No","0","1","Title","Global","globLib:HumanTitleDataType",null,null,"AN",null,"0",45,"Field","Please enter the Project Manager's Title."]
["B4-09","Complete Address:","Project Manager Address","No","0","1","Address","Global","globLib:AddressDataType",{"$nulls":6},"Label"]
["B4-10","Street1:","Project Manager Street 1","No",0,1,"Street1","Global","globLib:Street1",null,"Conditionally required if any Project Manager fields are entered.","AN",null,0,55,"Field","Please enter the first line of the Project Manager's Street Address.","Street1 is required: Please enter the first line of the Project Manager’s Street Address."]
["B4-11","Street2:","Project Manager Street 2","No",0,1,"Street2","Global","globLib:Street2",null,null,"AN",null,0,55,"Field","Please enter the second line of the Project Manager's Street Address."]
["B4-12","City:","Project Manager City","No",0,1,"City","Global","globLib:City",null,"Conditionally required if any Project Manager fields are entered.","AN",null,0,35,"Field","Please enter the Project Manager's City.","City is required: Please enter the Project Manager’s City."]
["B4-13","State:","Project Manager State","No",0,1,"State","Global","globLib:State",null,"Active & not required when form is first opened. After exiting country field, conditionally active and required if Country is US, inactive if Country is not US.","LIST","50 US States, US possessions, territories, military codes",0,55,"Popup","Please enter the Project Manager's State. Select from the pull down menu.","State is required: Please select the Project Manager’s State."]
["B4-14","Zip / Postal Code:","Project Manager Zip / Postal Code","No",0,1,"ZipPostalCode","Global","globLib:ZipPostalCode",null,"Conditionally required if Country is US. If Country is not US, then optional.","AN",null,0,30,"Field","Please enter the Project Manager's Zip / Postal Code.","ZIP / Postal Code is required: Please enter the Project Manager’s ZIP / Postal Code."]
["B4-15","Country:","Project Manager Country","No",0,1,"Country","Global","globLib:Country",null,"Conditionally required if any Project Manager fields are entered.","LIST","GENC Standard Ed3.0 Update 11",0,49,"Popup","Please enter the Project Manager's Country. Select from the pull down menu.","Country is required: Please select the Project Manager’s Country."]
["B4-16","Phone Number:","Project Manager Phone Number","No","0","1","Phone","Global","globLib:TelephoneNumberDataType",null,"Conditionally required if any Project Manager fields are entered.","AN",null,0,25,"Field","Please enter the Project Manager's Phone Number.","Phone Number is required: Please enter the Project Manager’s Phone Number."]
["B4-17","Fax Number:","Project Manager Fax Number","No","0","1","Fax","Global","globLib:TelephoneNumberDataType",null,null,"AN",null,"0",25,"Field","Please enter the Project Manager's Fax Number."]
["B4-18","E-mail Address:","Project Manager E-mail Address","No","0","1","Email","Global","globLib:EmailDataType",null,"E-mail validation","AN",null,"0",60,"Field","Please enter the Project Manager's E-mail Address.",null,"Email Address is invalid: Enter a valid Email Address."]
["B4-a","EPA Form 5700-54 (Rev 4-02)","EPA Form Back Text",{"$nulls":12},"Label"]