{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["90-4"],"not_rendered":{"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"90-4","index":0,"n_rows":50,"n_cols":25,"rows_kept":50,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[2,2,2,3],[4,2,4,3],[5,2,5,3],[6,2,6,5],[6,6,6,9],[6,10,6,13],[6,14,6,17],[6,19,6,21],[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],[18,0,18,1],[19,0,19,1],[20,0,20,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[47,0,47,1],[48,0,48,1],[49,0,49,1]]}
["National Oceanic and Atmospheric Administration (NOAA)",{"$nulls":4},"Adapted from OMB Control No: 0648-0362 Exp 01/31/2018"]
["Form 90-4 (Adapted)",{"$nulls":23},"default tab name"]
["Project Status:  New",null,"Project Number:",{"$nulls":20},true,"90-4"]
["Grantee: ",{"$nulls":3},"from","to",{"$nulls":18},"number of years to show"]
["ProjTitle: ",null,"Project Period: ",{"$nulls":21},1]
["PI:  ",{"$nulls":23},{"$f":"IF(Y5>=1,\"Delete Year \"&Y5,\"- - - - - - -\")","v":"Delete Year 1"}]
["Institution:  ",null,"YEAR 1",{"$nulls":3},"YEAR 2",{"$nulls":3},"YEAR 3",{"$nulls":3},"YEAR 4",{"$nulls":4},"TOTAL",{"$nulls":4},{"$f":"IF(Y5>3,\"- - - - -\",\"Add a year\")","v":"Add a year"}]
[null,null,"No. of Personnel","Months of Effort","Sea Grant Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant Funds","Matching Funds","No. of Personnel","Months of Effort","Sea Grant Funds","Matching Funds",null,"Months of Effort","Sea Grant Funds","Matching Funds"]
["A. Salaries & Wages",{"$nulls":23},"AK"]
["     1) Senior Personnel",{"$nulls":23},"CA"]
["         a.  (Co) Principal Investigator(s) ",{"$nulls":18},{"$f":"D11+H11+L11+P11","v":0},{"$f":"E11+I11+M11+Q11","v":0},{"$f":"F11+J11+N11+R11","v":0},null,null,"CT"]
["         b.  Associate (Faculty or Staff) ",{"$nulls":18},0,0,0,null,null,"DE"]
["     2) Other Personnel",{"$nulls":23},"FL"]
["         a. Professionals: ",{"$nulls":18},0,{"$f":"E14+I14+M14+Q14","v":0},{"$f":"F14+J14+N14+R14","v":0},null,null,"GA"]
["         b. Research Associates",{"$nulls":18},0,0,0,null,null,"GU"]
["         c. Research Asst. Grad Students",{"$nulls":18},0,0,0,null,null,"HI"]
["         d. Prof. School Students",{"$nulls":18},0,0,0,null,null,"IL-IN"]
["         e. Pre-Bac Students",{"$nulls":18},0,0,0,null,null,"LA"]
["         f.  Secretarial-Clerical: ",{"$nulls":18},0,0,0,null,null,"LAW"]
["         g. Technical-Shop",{"$nulls":18},0,0,0,null,null,"LC"]
["         h.  Misc.",{"$nulls":18},0,0,0,null,null,"LIB"]
["         Total Salaries &Wages (A1a-A2h)",null,{"$f":"SUM(C11,C12,C14:C21)","v":0},{"$f":"SUM(D11,D12,D14:D21)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(E10:E21)","v":0},0,{"$f":"SUM(G11,G12,G14:G21)","v":0},{"$f":"SUM(H11,H12,H14:H21)","v":0},{"$f":"SUM(I10:I21)","v":0},0,{"$f":"SUM(K11,K12,K14:K21)","v":0},{"$f":"SUM(L11,L12,L14:L21)","v":0},{"$f":"SUM(M10:M21)","v":0},0,{"$f":"SUM(O11,O12,O14:O21)","v":0},{"$f":"SUM(P11,P12,P14:P21)","v":0},{"$f":"SUM(Q10:Q21)","v":0},0,null,0,{"$f":"SUM(U10:U21)","v":0},0,null,null,"MD"]
["B. Fringe Benefits",{"$nulls":23},"ME"]
["     1) XX% of  ",null,null,"%",{"$f":"$C24*E$22/100","v":0},{"$f":"$C24*F$22/100","v":0},{"$f":"$C24*G$22/100","v":0},0,{"$f":"$C24*I$22/100","v":0},0,null,null,{"$f":"$C24*M$22/100","v":0},{"$f":"$C24*N$22/100","v":0},null,null,{"$f":"$C24*Q$22/100","v":0},{"$f":"$C24*R$22/100","v":0},null,null,{"$f":"E24+I24+M24+Q24","v":0},{"$f":"F24+J24+N24+R24","v":0},null,null,"MI"]
["     2) XX% of ",null,null,"%",{"$f":"$C25*E$22/100","v":0},0,0,0,0,0,null,null,{"$f":"$C25*M$22/100","v":0},0,null,null,{"$f":"$C25*Q$22/100","v":0},0,null,null,0,0,null,null,"MIT"]
["         Total Fringe Benefits",{"$nulls":3},{"$f":"SUM(E24:E25)","v":0},0,null,null,{"$f":"SUM(I24:I25)","v":0},0,null,null,{"$f":"SUM(M24:M25)","v":0},0,null,null,{"$f":"SUM(Q24:Q25)","v":0},0,null,null,0,0,null,null,"MN"]
["Total Salaries & Fringe Benefits",{"$nulls":3},{"$f":"E22+E26","v":0},0,null,null,{"$f":"I22+I26","v":0},0,null,null,{"$f":"M22+M26","v":0},0,null,null,{"$f":"Q22+Q26","v":0},0,null,null,0,0,null,null,"MS-AL"]
["C. Permanent Equipment",{"$nulls":19},0,0,null,null,"NC"]
["D. Expendable Supplies",{"$nulls":19},0,0,null,null,"NH"]
["E. Travel",{"$nulls":23},"NJ"]
["    1) Domestic U.S. (Inc. Puerto Rico)",{"$nulls":19},{"$f":"E31+I31+M31+Q31","v":0},{"$f":"F31+J31+N31+R31","v":0},null,null,"NSGCP"]
["    2) Foreign",{"$nulls":19},0,0,null,null,"NSGO"]
["        Total Travel",{"$nulls":3},{"$f":"SUM(E31:E32)","v":0},0,null,null,{"$f":"SUM(I31:I32)","v":0},0,null,null,{"$f":"SUM(M31:M32)","v":0},0,null,null,{"$f":"SUM(Q31:Q32)","v":0},0,null,null,0,0,null,null,"NY"]
["F. Publication & Documentation Costs",{"$nulls":19},0,0,null,null,"OH"]
["G. Other Costs",{"$nulls":23},"OR"]
["     1)",{"$nulls":19},{"$f":"E36+I36+M36+Q36","v":0},{"$f":"F36+J36+N36+R36","v":0},null,null,"PA"]
["     2)",{"$nulls":19},0,0,null,null,"PR"]
["     3)",{"$nulls":19},0,0,null,null,"RI"]
["     4)",{"$nulls":19},0,0,null,null,"SC"]
["     5)",{"$nulls":19},0,0,null,null,"TX"]
["     6)",{"$nulls":19},0,0,null,null,"USC"]
["     7) ",{"$nulls":19},0,0,null,null,"VA"]
["     8)",{"$nulls":19},0,0,null,null,"WA"]
["         Total Other Costs",{"$nulls":3},{"$f":"SUM(E36:E43)","v":0},0,null,null,{"$f":"SUM(I36:I43)","v":0},0,null,null,{"$f":"SUM(M36:M43)","v":0},0,null,null,{"$f":"SUM(Q36:Q43)","v":0},0,null,null,0,0,null,null,"WHOI"]
["Total Direct Costs",{"$nulls":3},{"$f":"E27+E28+E29+E33+E34+E44","v":0},0,null,null,{"$f":"I27+I28+I29+I33+I34+I44","v":0},0,null,null,{"$f":"M27+M28+M29+M33+M34+M44","v":0},0,null,null,{"$f":"Q27+Q28+Q29+Q33+Q34+Q44","v":0},0,null,null,0,0,null,null,"WI"]
["H. Indirect Costs"]
["    1) On Campus XX% of ",{"$nulls":3},{"$f":"E$45*$C47/100","v":0},{"$f":"F$45*$C47/100","v":0},{"$f":"G$45*$C47/100","v":0},0,{"$f":"I$45*$C47/100","v":0},0,null,null,{"$f":"M$45*$C47/100","v":0},{"$f":"N$45*$C47/100","v":0},null,null,{"$f":"Q$45*$C47/100","v":0},{"$f":"R$45*$C47/100","v":0},null,null,{"$f":"E47+I47+M47+Q47","v":0},{"$f":"F47+J47+N47+R47","v":0}]
["    2) ",{"$nulls":3},{"$f":"E$45*$C48/100","v":0},0,0,0,0,0,null,null,{"$f":"M$45*$C48/100","v":0},0,null,null,{"$f":"Q$45*$C48/100","v":0},0,null,null,0,0]
["Total Indirect Costs",{"$nulls":3},{"$f":"SUM(E47:E48)","v":0},0,null,null,{"$f":"SUM(I47:I48)","v":0},0,null,null,{"$f":"SUM(M47:M48)","v":0},0,null,null,{"$f":"SUM(Q47:Q48)","v":0},0,null,null,0,0]
["Total Cost",{"$nulls":3},{"$f":"E45+E49","v":0},0,null,null,{"$f":"I45+I49","v":0},0,null,null,{"$f":"M45+M49","v":0},0,null,null,{"$f":"Q45+Q49","v":0},0,null,null,0,0]