{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["90-4","cont"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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"}

{"sheet":"90-4","index":0,"n_rows":60,"n_cols":25,"rows_kept":60,"cut":false,"hidden":false,"merged":[[6,19,6,21],[0,0,0,1],[1,0,1,1],[2,0,2,1],[2,2,2,3],[2,4,2,5],[4,2,4,3],[5,2,5,3],[6,2,6,5],[6,6,6,9],[6,10,6,13],[6,14,6,17],[18,0,18,1],[7,0,7,1],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[37,0,37,1],[19,0,19,1],[21,0,21,1],[22,0,22,3],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[59,0,59,1],[38,0,38,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,3],[58,0,58,1]]}
["National Oceanic and Atmospheric Administration (NOAA)",null,null,null,null,"Adapted from OMB Control No: 0648-0362 Exp 02/28/2021"," Use buttons below to add or remove additional years"]
["Form 90-4 (Adapted)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"default tab name"]
["Project Status:  New",null,"Project Number:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,true,"90-4"]
["SG Program: ",null,null,null,"from","to"," Use button below to add or remove extra rows to Fringe and Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"number of years to show"]
["Project Title: ",null,"Project Period: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
["PI:  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Y5>=1,\"Delete Year \"&Y5,\"- - - - - - -\")","v":"Delete Year 2"}]
["Institution:  ",null,"YEAR 1",null,null,null,"YEAR 2",null,null,null,"YEAR 3",null,null,null,"YEAR 4",null,null,null,null,"TOTAL",null,null,null,null,{"$f":"IF(Y5>3,\"- - - - -\",\"Add a year\")","v":"Add a year"}]
[null,null,"No. of Personnel","Months of Effort","Sea Grant (Federal) Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant (Federal) Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant (Federal) Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant (Federal) Funds","Matching Funds",null,"Months of Effort","Sea Grant (Federal) Funds","Matching Funds",null,null,"Show Extra Rows"]
["A. Salaries & Wages"]
["     1) Senior Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AK"]
["         a.  (Co) Principal Investigator(s) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D11+H11+L11+P11=0,\"\",D11+H11+L11+P11)","v":""},{"$f":"E11+I11+M11+Q11","v":0},{"$f":"F11+J11+N11+R11","v":0},null,null,"CA"]
["         b.  Associate (Faculty or Staff) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D12+H12+L12+P12=0,\"\",D12+H12+L12+P12)","v":""},{"$f":"E12+I12+M12+Q12","v":0},0,null,null,"CT"]
["     2) Other Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE"]
["         a. Professionals",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D14+H14+L14+P14=0,\"\",D14+H14+L14+P14)","v":""},{"$f":"E14+I14+M14+Q14","v":0},0,null,null,"FL"]
["         b. Research Associates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"GA"]
["         c. Research Asst. Grad Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"GU"]
["         d. Prof. School Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"HI"]
["         e. Pre-Bac Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"IL-IN"]
["         f.  Secretarial-Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"LA"]
["         g. Technical-Shop",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"LC"]
["         h.  Misc.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0,null,null,"MD"]
["         Total Salaries &Wages (A1a-A2h)",null,{"$f":"IF(SUM(C11,C12,C14:C21)=0,\"\",SUM(C11,C12,C14:C21))","v":""},{"$f":"IF(SUM(D11,D12,D14:D21)=0,\"\",SUM(D11,D12,D14:D21))","v":""},{"$f":"SUM(E10:E21)","v":0},0,{"$f":"IF(SUM(G11,G12,G14:G21)=0,\"\",SUM(G11,G12,G14:G21))","v":""},{"$f":"IF(SUM(H11,H12,H14:H21)=0,\"\",SUM(H11,H12,H14:H21))","v":""},{"$f":"SUM(I10:I21)","v":0},0,{"$f":"IF(SUM(K11,K12,K14:K21)=0,\"\",SUM(K11,K12,K14:K21))","v":""},{"$f":"IF(SUM(L11,L12,L14:L21)=0,\"\",SUM(L11,L12,L14:L21))","v":""},{"$f":"SUM(M10:M21)","v":0},0,{"$f":"IF(SUM(O11,O12,O14:O21)=0,\"\",SUM(O11,O12,O14:O21))","v":""},{"$f":"IF(SUM(P11,P12,P14:P21)=0,\"\",SUM(P11,P12,P14:P21))","v":""},{"$f":"SUM(Q10:Q21)","v":0},0,null,{"$f":"IF(SUM(D22,H22,L22,P22)=0,\"\",D22+H22+L22+P22)","v":""},{"$f":"SUM(U10:U21)","v":0},0,null,null,"ME"]
["B. Fringe Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MI"]
["        1) notes",null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E24+I24+M24+Q24","v":0},0,null,null,"MIT"]
["        2) notes",null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"MN"]
["        3) notes",null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"MS-AL"]
["        4) notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"NC"]
["        5) notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"NH"]
["        6) notes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"NJ"]
["         Total Fringe Benefits",null,null,null,{"$f":"SUM(E24:E29)","v":0},{"$f":"SUM(F24:F29)","v":0},null,null,{"$f":"SUM(I24:I29)","v":0},{"$f":"SUM(J24:J29)","v":0},null,null,{"$f":"SUM(M24:M29)","v":0},{"$f":"SUM(N24:N29)","v":0},null,null,{"$f":"SUM(Q24:Q29)","v":0},{"$f":"SUM(R24:R29)","v":0},null,null,0,0,null,null,"NSGLC"]
["Total Salaries & Fringe Benefits",null,null,null,{"$f":"E22+E30","v":0},0,null,null,{"$f":"I22+I30","v":0},0,null,null,{"$f":"M22+M30","v":0},0,null,null,{"$f":"Q22+Q30","v":0},0,null,null,0,0,null,null,"NSGL"]
["C. Permanent Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"NSGO"]
["D. Expendable Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"NY"]
["E. Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"OH"]
["    1) Domestic U.S. (Inc. Puerto Rico)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E35+I35+M35+Q35","v":0},0,null,null,"OR"]
["    2) Foreign",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"PA"]
["        Total Travel",null,null,null,{"$f":"SUM(E35:E36)","v":0},0,null,null,{"$f":"SUM(I35:I36)","v":0},0,null,null,{"$f":"SUM(M35:M36)","v":0},0,null,null,{"$f":"SUM(Q35:Q36)","v":0},0,null,null,0,0,null,null,"PR"]
["F. Publication & Documentation Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"RI"]
["G. Other Costs - the examples provided can be changed",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SC"]
["     1)","Computer Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"E40+I40+M40+Q40","v":0},0,null,null,"TX"]
["     2)","Consultants",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"USC"]
["     3)","Copying, Library, and Communication ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"VA"]
["     4)","Analytical and Shop Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"WA"]
["     5)","Boat time, Vehicle Usage, Space Rental",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"WHOI"]
["     6)","Tuition / Stipend",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"WI"]
["     7) ","Subaward to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"not a SG Progam"]
["     8) ","Subaward to",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,null,"other"]
["     9) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     10) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     11) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     12)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["         Total Other Costs",null,null,null,{"$f":"SUM(E40:E51)","v":0},0,null,null,{"$f":"SUM(I40:I51)","v":0},0,null,null,{"$f":"SUM(M40:M51)","v":0},0,null,null,{"$f":"SUM(Q40:Q51)","v":0},0,null,null,0,0]
["Total Direct Costs",null,null,null,{"$f":"E31+E32+E33+E37+E38+E52","v":0},0,null,null,{"$f":"I31+I32+I33+I37+I38+I52","v":0},0,null,null,{"$f":"M31+M32+M33+M37+M38+M52","v":0},0,null,null,{"$f":"Q31+Q32+Q33+Q37+Q38+Q52","v":0},0,null,null,0,0]
["MODIFIED Direct Costs - used for calculating indirect",null,null,null,{"$f":"E53","v":0},{"$f":"F53","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["H. Indirect Costs - calculated from %*Modified Direct, but you can overwrite"]
["    1) On: ",null,null,"%",{"$f":"ROUND(E$54*$C56/100,0)","v":0},{"$f":"ROUND(F$54*$C56/100,0)","v":0},{"$f":"G$54*$C56/100","v":0},0,{"$f":"ROUND(I$54*$C56/100,0)","v":0},{"$f":"ROUND(J$54*$C56/100,0)","v":0},null,null,{"$f":"M$54*$C56/100","v":0},0,null,null,{"$f":"Q$54*$C56/100","v":0},0,null,null,{"$f":"E56+I56+M56+Q56","v":0},0]
["    2) Off:",null,null,"%",{"$f":"ROUND(E$54*$C57/100,0)","v":0},0,0,0,{"$f":"ROUND(I$54*$C57/100,0)","v":0},0,null,null,0,0,null,null,0,0,null,null,0,0]
["    3) other:",null,null,"%",0,0,0,0,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Total Indirect Costs",null,null,null,{"$f":"SUM(E56:E58)","v":0},0,null,null,{"$f":"SUM(I56:I58)","v":0},0,null,null,{"$f":"SUM(M56:M58)","v":0},0,null,null,{"$f":"SUM(Q56:Q58)","v":0},0,null,null,0,0]
["Total Cost - (Total Direct) + (Total Indirect)",null,null,null,{"$f":"E53+E59","v":0},0,null,null,{"$f":"I53+I59","v":0},0,null,null,{"$f":"M53+M59","v":0},0,null,null,{"$f":"Q53+Q59","v":0},0,null,null,0,0]

{"sheet":"cont","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["\nSEA GRANT BUDGET FORM 90-4\n(Continued)\n\nPAPERWORK REDUCTION ACT, PRIVACY ACT, AND PUBLIC BURDEN\n\nNOAA's National Sea Grant College Program exists to increase the understanding, assessment, development, utilization, and conservation of the Nation's ocean, coastal, and Great Lakes resources. It does this by providing grant monies to promote a strong educational base, responsive research, and training. The information requested on this form is required in order to be considered for an award under the authority of the National Sea Grant College Act, as amended. The information will be used to determine the cost of each project and whether proposed matching costs are allowable. The information is also used in negotiating costs and in the administrative control of expenditures. The information requested may be disclosed to qualified reviewers and staff assistants as part of the application review process; to applicant institutions/grantees to provide or obtain data regarding the application review process, award decisions, or the administration of awards; to government contractors, experts, volunteers and researchers as necessary to complete assigned work; to other government agencies needing information as part of the review process or in order to coordinate programs; and to another Federal agency, court or party in a court or Federal administrative proceeding if the Government is a party. Notwithstanding any other provision of the law, no person is required to respond to, nor shall any person be subject to a penalty for failure to comply with, a collection of information subject to the requirements of the Paperwork Reduction Act, unless that collection of information displays a currently valid OMB Control Number.\n\nPublic reporting burden for this collection of information is estimated to average 15 minutes per response, including the time necessary for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments regarding this burden estimate or any other aspect of this collection of information, including suggestions to reduce this burden, to National Sea Grant College Program, R/SG, NOAA, 1315 East-West Highway, Silver Spring, MD 20910 (Attn: Paperwork Reduction Act).\n"]