{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["90-4 for R&R Budget","Read Me","FringeTable","Notice","dropdowns"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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 for R&R Budget","index":0,"n_rows":80,"n_cols":30,"rows_kept":80,"cut":false,"hidden":false,"merged":[[78,0,78,1],[79,0,79,1],[77,0,77,1],[33,0,33,1],[42,0,42,1],[43,0,43,1],[44,0,44,1],[45,0,45,1],[46,0,46,1],[48,0,48,1],[50,0,50,1],[49,0,49,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[76,0,76,1],[63,0,63,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[51,0,51,1],[52,0,52,1],[53,0,53,1],[54,0,54,1],[62,0,62,1],[32,0,32,1],[37,0,37,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[27,0,27,1],[8,0,8,1],[9,0,9,1],[23,0,23,1],[6,2,6,7],[5,4,5,5],[7,27,7,29],[1,0,1,1],[2,0,2,1],[3,0,3,1],[2,3,2,4],[7,6,7,7],[7,12,7,13],[6,8,6,13],[3,5,3,7],[6,14,6,19],[6,20,6,25],[7,18,7,19],[7,24,7,25],[3,2,3,4]]}
[]
["National Oceanic and Atmospheric Administration (NOAA)",null,null,null,null,null,null,"Adapted from OMB Control No: 0648-0362 Exp 04/30/2024"]
["Form 90-4 (Adapted)",null,"Budget Type","SELECT BUDGET TYPE"]
["Project Status:  New",null,"Project Number: "]
["SG Program: ",null,null,null,null,null,"from","to"]
["Project Title: ",null,null,null,"Project Period: "]
["PI:  ",null,"YEAR 1",null,null,null,null,null,"YEAR 2",null,null,null,null,null,"YEAR 3",null,null,null,null,null,"YEAR 4"]
["Institution:  ",null,"start:",null,"end:",null,null,null,"start:",null,"end:",null,null,null,"start:",null,"end:",null,null,null,"start:",null,"end:",null,null,null,null,"TOTAL"]
[null,null,"No. of Personnel","Months of Effort","Requested Salary","Fringe Benefits","Sea Grant / Federal Funds","Match / Non-Federal Funds","No. of Personnel","Months of Effort","Requested Salary","Fringe Benefits","Sea Grant (Federal) Funds","Match/Non-Federal Funds","No. of Personnel","Months of Effort","Requested Salary","Fringe Benefits","Sea Grant (Federal) Funds","Match/Non-Federal Funds","No. of Personnel","Months of Effort","Requested Salary","Fringe Benefits","Sea Grant (Federal) Funds","Match/Non-Federal Funds",null,"Months of Effort","Sea Grant (Federal) Funds","Matching/Non-Federal Funds"]
["A. Senior/Key Person"]
["         a.  Senior/Key Person Salary",null,{"$f":"COUNTIF(D12:D23, \"<>\")","v":0},{"$f":"SUM(D12:D23)","v":0},{"$f":"SUM(E12:E23)","v":0},{"$f":"SUM(F12:F23)","v":0},0,0,{"$f":"COUNTIF(J12:J23, \"<>\")","v":0},{"$f":"SUM(J12:J23)","v":0},{"$f":"SUM(K12:K23)","v":0},{"$f":"SUM(L12:L23)","v":0},{"$f":"SUM(M12:M23)","v":0},{"$f":"SUM(N12:N23)","v":0},{"$f":"COUNTIF(P12:P23, \"<>\")","v":0},{"$f":"SUM(P12:P23)","v":0},{"$f":"SUM(Q12:Q23)","v":0},{"$f":"SUM(R12:R23)","v":0},{"$f":"SUM(S12:S23)","v":0},{"$f":"SUM(T12:T23)","v":0},{"$f":"COUNTIF(V12:V23, \"<>\")","v":0},{"$f":"SUM(V12:V23)","v":0},{"$f":"SUM(W12:W23)","v":0},{"$f":"SUM(X12:X23)","v":0},{"$f":"SUM(Y12:Y23)","v":0},{"$f":"SUM(Z12:Z23)","v":0},null,{"$f":"SUM(AB12:AB23)","v":0},{"$f":"SUM(AC12:AC23)","v":0},{"$f":"SUM(AD12:AD23)","v":0}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D12+J12+P12+V12","v":0},{"$f":"G12+M12+S12+Y12","v":0},{"$f":"H12+N12+T12+Z12","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D13+J13+P13+V13","v":0},{"$f":"G13+M13+S13+Y13","v":0},{"$f":"H13+N13+T13+Z13","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[10,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["B. Other Personnel"]
["         a. Post Doctoral Associates",null,null,null,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(D25+J25+P25+V25=0,\"\",D25+J25+P25+V25)","v":""},{"$f":"G25+M25+S25+Y25","v":0},0]
["         b. Graduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         c. Undergraduate Students",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         d. Secretarial/Clerical",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         e. Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         f.  Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         g.  Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         h.  Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",0,0]
["         Total Salary, Wages and Fringe Benefits (A+B)",null,{"$f":"SUM(C11,C25:C32)","v":0},{"$f":"SUM(D11,D25:D32)","v":0},{"$f":"SUM(E11,E25:E32)","v":0},{"$f":"SUM(F11,F25:F32)","v":0},0,0,0,0,{"$f":"SUM(K11,K25:K32)","v":0},{"$f":"SUM(L11,L25:L32)","v":0},0,0,0,0,{"$f":"SUM(Q11,Q25:Q32)","v":0},{"$f":"SUM(R11,R25:R32)","v":0},{"$f":"SUM(S11,S25:S32)","v":0},{"$f":"SUM(T11,T25:T32)","v":0},{"$f":"SUM(U11,U25:U32)","v":0},0,{"$f":"SUM(W11,W25:W32)","v":0},{"$f":"SUM(X11,X25:X32)","v":0},{"$f":"SUM(Y11,Y25:Y32)","v":0},{"$f":"SUM(Z11,Z25:Z32)","v":0},null,{"$f":"AB11+SUM(AB25:AB32)","v":0},{"$f":"AC11+SUM(AC25:AC32)","v":0},{"$f":"AD11+SUM(AD25:AD32)","v":0}]
["C. Permanent Equipment"]
["        1) Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G35+M35+S35+Y35","v":0},{"$f":"H35+N35+T35+Z35","v":0}]
["        2) Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G36+M36+S36+Y36","v":0},{"$f":"H36+N36+T36+Z36","v":0}]
["        3) Item",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G37+M37+S37+Y37","v":0},0]
["         Total Permanent Equipment",null,null,null,null,null,{"$f":"SUM(G35:G37)","v":0},{"$f":"SUM(H35:H37)","v":0},null,null,null,null,{"$f":"SUM(M35:M37)","v":0},{"$f":"SUM(N35:N37)","v":0},null,null,null,null,{"$f":"SUM(S35:S37)","v":0},{"$f":"SUM(T35:T37)","v":0},null,null,null,null,{"$f":"SUM(Y35:Y37)","v":0},{"$f":"SUM(Z35:Z37)","v":0},null,null,0,0]
["D. Travel"]
["    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,null,null,null,null,null,null,null,null,{"$f":"G40+M40+S40+Y40","v":0},0]
["    2) Foreign",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["        Total Travel",null,null,null,null,null,{"$f":"SUM(G40:G41)","v":0},0,null,null,null,null,{"$f":"SUM(M40:M41)","v":0},{"$f":"SUM(N40:N41)","v":0},null,null,null,null,{"$f":"SUM(S40:S41)","v":0},0,null,null,null,null,{"$f":"SUM(Y40:Y41)","v":0},0,null,null,0,0]
["E. Participant/Trainee Support Costs"]
["    1) Tuition/Fees/Health Insurance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G44+M44+S44+Y44","v":0},0]
["    2) Stipends",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["    3) Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["    4) Subsistence",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["    5) Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["         Total Participant/Trainee Support Costs",null,null,null,null,null,{"$f":"SUM(G44:G48)","v":0},{"$f":"SUM(H44:H48)","v":0},null,null,null,null,{"$f":"SUM(M44:M48)","v":0},{"$f":"SUM(N44:N48)","v":0},null,null,null,null,{"$f":"SUM(S44:S48)","v":0},{"$f":"SUM(T44:T48)","v":0},null,null,null,null,{"$f":"SUM(Y44:Y48)","v":0},{"$f":"SUM(Z44:Z48)","v":0},null,null,0,0]
["F. Other Direct Costs"]
["     1) Materials and Supplies",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G51+M51+S51+Y51","v":0},0]
["     2) Publication Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     3) Consultant Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     4) ADP/Computer Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     5) Subawards/Consortium/Contractual Costs",null,null,null,null,null,{"$f":"SUM(C57:C62)","v":0},{"$f":"SUM(E57:E62)","v":0},null,null,null,null,{"$f":"SUM(I57:I62)","v":0},{"$f":"SUM(K57:K62)","v":0},null,null,null,null,{"$f":"SUM(O57:O62)","v":0},{"$f":"SUM(Q57:Q62)","v":0},null,null,null,null,{"$f":"SUM(U57:U62)","v":0},{"$f":"SUM(W57:W62)","v":0},null,null,0,0]
[null,null,"Fed Sub","IDC Apply","non-Fed Sub",null,null,null,"Fed Sub","IDC Apply","non-Fed Sub",null,null,null,"Fed Sub","IDC Apply","non-Fed Sub",null,null,null,"Fed Sub","IDC Apply","non-Fed Sub"]
["Sub1",null,null,null,null,null,{"$f":"C57","v":0},{"$f":"E57","v":0},null,null,null,null,{"$f":"I57","v":0},{"$f":"K57","v":0},null,null,null,null,{"$f":"O57","v":0},{"$f":"Q57","v":0},null,null,null,null,{"$f":"U57","v":0},{"$f":"W57","v":0},null,null,{"$f":"G57+M57+S57+Y57","v":0},{"$f":"H57+N57+T57+Z57","v":0}]
["Sub2",null,null,null,null,null,{"$f":"C58","v":0},{"$f":"E58","v":0},null,null,null,null,{"$f":"I58","v":0},{"$f":"K58","v":0},null,null,null,null,{"$f":"O58","v":0},{"$f":"Q58","v":0},null,null,null,null,{"$f":"U58","v":0},{"$f":"W58","v":0},null,null,0,0]
["Sub3",null,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,0,0,null,null,0,0]
["Sub4",null,null,null,null,null,{"$f":"C60","v":0},{"$f":"E60","v":0},null,null,null,null,{"$f":"I60","v":0},{"$f":"K60","v":0},null,null,null,null,{"$f":"O60","v":0},{"$f":"Q60","v":0},null,null,null,null,null,null,null,null,{"$f":"G60+M60+S60+Y60","v":0},{"$f":"H60+N60+T60+Z60","v":0}]
["Sub5",null,null,null,null,null,{"$f":"C61","v":0},{"$f":"E61","v":0},null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
["Sub6",null,null,null,null,null,{"$f":"C62","v":0},{"$f":"E62","v":0},null,null,null,null,0,0,null,null,null,null,0,0,null,null,null,null,null,null,null,null,0,0]
["     6) Equipment or Faculity Rental/User Fees",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     7) Alterations and Renovations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     8) Tuition NOT Subject to Indirect",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     9) Other NOT Subject to Indirect",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     10) Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     11) Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     12) Other",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["         Total Other Direct Costs",null,null,null,null,null,{"$f":"SUM(G51:G54)+G55+SUM(G63:G69)","v":0},{"$f":"SUM(H51:H54)+H55+SUM(H63:H69)","v":0},null,null,null,null,{"$f":"SUM(M51:M55)+SUM(M63:M69)","v":0},{"$f":"SUM(N51:N55)+SUM(N63:N69)","v":0},null,null,null,null,{"$f":"SUM(S51:S55)+SUM(S63:S69)","v":0},{"$f":"SUM(T51:T55)+SUM(T63:T69)","v":0},null,null,null,null,{"$f":"SUM(Y51:Y55)+SUM(Y63:Y69)","v":0},{"$f":"SUM(Z51:Z55)+SUM(Z63:Z69)","v":0},null,null,0,0]
["G. Total Direct Costs",null,null,null,null,null,{"$f":"G33+G38+G42+G49+G70","v":0},{"$f":"H33+H38+H42+H49+H70","v":0},null,null,null,null,{"$f":"M33+M38+M42+M49+M70","v":0},{"$f":"N33+N38+N42+N49+N70","v":0},null,null,null,null,{"$f":"S33+S38+S42+S49+S70","v":0},{"$f":"T33+T38+T42+T49+T70","v":0},null,null,null,null,{"$f":"Y33+Y38+Y42+Y49+Y70","v":0},{"$f":"Z33+Z38+Z42+Z49+Z70","v":0},null,null,{"$f":"AC33+AC38+AC42+AC49+AC70","v":0},{"$f":"AD33+AD38+AD42+AD49+AD70","v":0}]
["MODIFIED Direct Costs - used for calculating indirect",null,null,null,null,null,{"$f":"G33+G42+SUM(G51:G54)+SUM(D57:D62)+G63+G64+SUM(G67:G69)","v":0},{"$f":"H33+H42+SUM(H51:H54)+H63+H64+SUM(H67:H69)","v":0},null,null,null,null,{"$f":"M33+M42+SUM(M51:M54)+SUM(J57:J62)+M63+M64+SUM(M67:M69)","v":0},{"$f":"N33+N42+SUM(N51:N54)+N63+N64+SUM(N67:N69)","v":0},null,null,null,null,{"$f":"S33+S42+SUM(S51:S54)+SUM(P57:P62)+S63+S64+SUM(S67:S69)","v":0},{"$f":"T33+T42+SUM(T51:T54)+T63+T64+SUM(T67:T69)","v":0},null,null,null,null,{"$f":"Y33+Y42+SUM(Y51:Y54)+SUM(V57:V62)+Y63+Y64+SUM(Y67:Y69)","v":0},{"$f":"Z33+Z42+SUM(Z51:Z54)+Z63+Z64+SUM(Z67:Z69)","v":0},null,null,{"$f":"G72+M72+S72+Y72","v":0},{"$f":"H72+N72+T72+Z72","v":0}]
["H. Indirect Costs -  on Modified Direct Costs (see FUNCTIONS to overwrite)",null,"SG%","Inst%","waived $",null,null,null,"SG%","Inst%","waived $",null,null,null,"SG%","Inst%","waived $",null,null,null,"SG%","Inst%","waived $"]
["    1) On campus: ",null,null,null,{"$f":"(G72*D74/100)-G74","v":0},null,{"$f":"(G72*C74/100)","v":0},{"$f":"(H72*D74/100)","v":0},null,null,{"$f":"(M72*J74/100)-M74","v":0},null,{"$f":"(M72*I74/100)","v":0},{"$f":"(N72*J74/100)","v":0},null,null,{"$f":"(S72*P74/100)-S74","v":0},null,{"$f":"(S72*O74/100)","v":0},{"$f":"(T72*P74/100)","v":0},null,null,{"$f":"(Y72*V74/100)-Y74","v":0},null,{"$f":"(Y72*U74/100)","v":0},{"$f":"(Z72*V74/100)","v":0},null,null,{"$f":"G74+M74+S74+Y74","v":0},0]
["    2) Off campus:",null,null,null,{"$f":"(G72*D75/100)-G75","v":0},null,{"$f":"(G72*C75/100)","v":0},{"$f":"(H72*D75/100)","v":0},null,null,{"$f":"(M72*J75/100)-M75","v":0},null,{"$f":"(M72*I75/100)","v":0},{"$f":"(N72*J75/100)","v":0},null,null,{"$f":"(S72*P75/100)-S75","v":0},null,{"$f":"(S72*O75/100)","v":0},{"$f":"(T72*P75/100)","v":0},null,null,{"$f":"(Y72*V75/100)-Y75","v":0},null,{"$f":"(Y72*U75/100)","v":0},{"$f":"(Z72*V75/100)","v":0},null,null,0,0]
["    3) other:",null,null,null,{"$f":"(G72*D76/100)-G76","v":0},null,{"$f":"(G72*C76/100)","v":0},{"$f":"(H72*D76/100)","v":0},null,null,{"$f":"(M72*J76/100)-M76","v":0},null,{"$f":"(M72*I76/100)","v":0},{"$f":"(N72*J76/100)","v":0},null,null,{"$f":"(S72*P76/100)-S76","v":0},null,{"$f":"(S72*O76/100)","v":0},{"$f":"(T72*P76/100)","v":0},null,null,{"$f":"(Y72*V76/100)-Y76","v":0},null,{"$f":"(Y72*U76/100)","v":0},{"$f":"(Z72*V76/100)","v":0},null,null,0,0]
["Total Indirect Costs",null,null,null,null,null,{"$f":"SUM(G74:G76)","v":0},0,null,null,null,null,{"$f":"SUM(M74:M76)","v":0},0,null,null,null,null,{"$f":"SUM(S74:S76)","v":0},0,null,null,null,null,{"$f":"SUM(Y74:Y76)","v":0},0,null,null,0,0]
["I. Total Cost - (Total Direct) + (Total Indirect)",null,null,null,null,null,{"$f":"G71+G77","v":0},{"$f":"H71+H77+SUM(E74:E76)","v":0},null,null,null,null,{"$f":"M71+M77","v":0},{"$f":"N71+N77+SUM(K74:K76)","v":0},null,null,null,null,{"$f":"S71+S77","v":0},{"$f":"T71+T77+SUM(Q74:Q76)","v":0},null,null,null,null,{"$f":"Y71+Y77","v":0},{"$f":"Z71+Z77+SUM(W74:W76)","v":0},null,null,0,0]
["J. Fee",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["K. Total Costs and Fees",null,null,null,null,null,{"$f":"G78+G79","v":0},{"$f":"H78+H79","v":0},null,null,null,null,{"$f":"M78+M79","v":0},{"$f":"N78+N79","v":0},null,null,null,null,{"$f":"S78+S79","v":0},{"$f":"T78+T79","v":0},null,null,null,null,{"$f":"Y78+Y79","v":0},{"$f":"Z78+Z79","v":0},null,null,0,0]

{"sheet":"Read Me","index":1,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CLICK THE    SHOW FUNCTIONS   BUTTON FIRST"]
[null,"**see text below for details**"]
[null,"MAC USERS—Download / Open the Excel document. Click \"Enable Macros\" button when queried."]
[null,"non-MAC USERS—Download / Open the Excel document. Save to desired drive / directory and Close the document. Open the document and macros will be functional. IF at any point you receive a message box / screen asking to Trust / Enable macros, reply YES — macros should then be functional."]
[null,"Unlock Modifed Direct & H. Indirect Costs to set initial indirect cost rates for your budget; Lock when done so any change is purposeful."]
[null,"Read Me for Excel 90-4 Adapted Workbook "]
[null,"This Excel 90-4 worksheet is adapted to better comply with budget categories found in the SF424RR budget form. While many categories are similar to the previously used 90-4 budget, there are new budget categories and differences in several data aggregations. It is not the intent of this Excel workbook to conduct all calculations needed to develop budgets for proposals. This workbook instead is meant to be a companion to other platforms, such as eSeaGrant that conduct the tedious calculations. The 90-4 Adapted budget is revised to more closely align to categories used in the SF424RR budget now required by use of eRA. The 90-4 Adapted displays specific budget data, not adequately displayed in the SF424RR form, needed by NSGO to effectively and efficiently manage project funding at the national level. "]
[null,"GENERAL INFORMATION"]
[null,"Macros—This Excel workbook contains macros. All macros function to expose or hide portions of the 90-4 budget form, lock or unlock specific cells, or reinstall formulas in cells that allow overwriting. No data are manipulated via a macro and none connect to any data outside of that contained in the Excel 90-4 budget document. If a calculation is found to be in error, the problem is in an embedded formula, not in the VBA macro code. In all instances of button use the cursor is returned the “Select Budget Type” dropdown (budget selection is not affected)."]
[null,"Protected Worksheet—The 90-4 Excel worksheet is protected, but without a password. All cells with yellow background color are available for data entry; white cells are locked (those outside of the budget form area however, are not). You can “unprotect” the worksheet but do so with caution. The worksheet has embedded formulas and macros that call on specific rows, columns, and cells. Adding or removing cells, rows, or columns, may cause macros to malfunction and/or formulas to provide incorrect calculations. It is recommended that you leave the worksheet in a “protected” state; work from a copy if you decide to alter the worksheet."]
[null,"Dropdown Menus—are contained on a “hidden” Excel workbook tab. If for some reason you need to amend a dropdown list, you can “unhide” the tab. The only dropdown lists are for Budget Type and Sea Grant Program and should not need editing. "]
[null,"Fringe Table—mimics the \"B. Fringe Benefits\" section of the original 90-4 form where fringe rate detail can be added for institutional use. This tab pulls Key Person information from the budget form to the table, which can then be populated with fringe rate data for Key Persons as well as any notes of explanation. Data in this table are not used in any budget calculations."]
[null,"NON-DESTRUCTIVE FUNCTION BUTTONS (BLUE and GREY)"]
[null,"SHOW / HIDE FUNCTIONS—This pair of buttons toggles between showing or hiding the series of command buttons as described below. It is recommended that you HIDE FUNCTIONS prior to creating the PDF budget file that will be submitted to the funder. No data are affected by use of these buttons."]
[null,"Show Xtra Subs / Hide Xtra Subs—This pair of buttons toggles between showing or hiding 3 extra subaward lines in “F. Other Direct Costs, 5) Subawards.” Data are not affected by show/hide action."]
[null,"Open / Close Key Persons—This pair of buttons opens Senior/Key Person rows for input of individual PI, co-PI, and other key persons on the project. Input values are summed in Row 11. CLOSE KEY PERSONS should be initiated prior to creating the PDF budget file that will be submitted to the funder. "]
[null,"Lock / Unlock Modified Direct & H. Indirect Costs—This pair of buttons toggles between locking (cannot edit) and unlocking (can edit) workbook Row 72 “Modified Direct Costs” and Rows 74-76 “H. Indirect Costs,” including indirect cost rates (SG% and Inst%). Cell color is yellow when unlocked, white when locked. Data already input are not affected by lock/unlock action. Unlock to set indirect cost rates and/or when Modified Direct or Indirect Cost totals need to be overwritten (see RESET YrX ModDir & IDC)."]
[null,"Freeze / UnFreeze Headers—This pair of buttons locks, or unlocks, the top 10 rows and leftmost 2 columns to keep row and column headers visible. Data are not affected by freeze/unfreeze action."]
[null,"Open / Close Yr—These buttons open or close individual budget years. Data are not affected by open/close action."]
[null,"DESTRUCTIVE FUNCTION BUTTONS (RED)"]
[null,"RESET ENTIRE SHEET—Use of this button clears ALL data contained in the entire Excel worksheet for all budget years. All formulas are restored to their original state, and the worksheet is restored to its original condition (i.e., as if it were the first time opened for use). It is suggested that you save a copy before using this function. If you make a copy of this workbook for use with other proposals it is recommended that you \"Reset Entire Sheet\" before saving for reuse."]
[null,"RESET Yr”X” ModDir & IDC—Use of this button replaces input data with the original formulas in those cells that can be unlocked when using the “Unlock Modified Direct & H. Indirect Costs”  button. This function can be useful when there is the need to replace the original formulas an individual budget year. For instance, the amount of indirect cost is replaced with a specific dollar value in Yr2 to get the budget total to a desired value. Further budget work occurs, and it may be useful to replace the formula—click the “RESET Yr2 ModDir & IDC” button. Use of this button ONLY affects cells where formulas have been replaced by specific values (e.g., replacing the original formula in a cell containing the original formula has no affect). SG% and Inst% are not affected as they do not contain formulas. "]
[null,"NOTES (red triangles)"]
[null,"Other than Project Number and Project Period, all descriptors apply to each budget year in the project. Totals across budget years are automatically calculated and displayed in the TOTAL section (light blue cells)."]
[null,"PROJECT NUMBER—A unique project identification number given by the Sea Grant program and used for tracking in PIER and other database systems. "]
[null,"PROJECT PERIOD FROM and TO—Start and end dates of the project length; includes all budget years."]
[null,"BUDGET YEAR START and END—Start and end date of each individual budget year in the project; each budget year requests input of a start and end date."]
[null,"NO. OF PERSONNEL—Total number of persons in A. Senior/Key and B. Other Personnel budget line categories. A. Senior/Key Person number auto-calculates as effort is entered."]
[null,"MONTHS OF EFFORT—Total months of effort for all persons in the A. Senior/Key (auto-calculating) and B. Other Personnel categories."]
[null,"REQUESTED SALARY—Total salaries—federal + non-federal. "]
[null,"FRINGE BENEFITS—Total fringe benefits—federal + non-federal."]
[null,"SEA GRANT / FEDERAL FUNDS— Total salaries + fringe—federal funds only."]
[null,"MATCH / NON-FEDERAL FUNDS— Total salaries + fringe—non-federal funds only."]
[null,"C. PERMANENT EQUIPMENT—see Uniform Guidance for Federal Awards for details. This category is NOT included in Modified Direct Costs (e.g., it is not subject to indirect costs)."]
[null,"E. PARTICIPANT / TRAINEE SUPPORT COSTS—see Uniform Guidance for Federal Awards for details. This category is NOT included in Modified Direct Costs (e.g., it is not subject to indirect costs)."]
[null,"F. 5) SUBAWARDS: The default is 3 subaward options; 3 additional subawards can be accessed by clicking SHOW FUNCTIONS and Show Xtra Subs buttons."]
[null,"FED SUB­—Total amount of federal funds in the subaward."]
[null,"IDC APPLY—Amount of federal funds subject to indirect cost rate set in H. Indirect Costs budget section. "]
[null,"NON-FED SUB—Total amount of non-federal funds (match) in the subaward."]
[null,"IDC APPLY—Amount of non-federal funds subject to indirect cost rate set in H. Indirect Costs budget section."]
[null,"F. 8) TUITION NOT SUBJECT TO INDIRECT­—Total of tuition for supported students. This category is NOT included in Modified Direct Costs (e.g., it is not subject to indirect costs)."]
[null,"F. 9) OTHER NOT SUBJECT TO INDIRECT—A budget line that can include other items that are not subject to indirect costs. This category is NOT included in Modified Direct Costs (e.g., it is not subject to indirect costs)."]
[null,"MODIFIED DIRECT COSTS—The total of all budget costs that are subject to indirect costs. C. Permanent Equipment, E. Participant Support, F. 5) Subaward costs not subject to indirect, F. 8) Tuition, and F. 9) Other Not Subject to Indirect, are not included in this total."]
[null,"H. INDIRECT COSTS—Indirect cost applied to the Modified Direct Cost total using the Indirect Cost Rates provided in H. 1), 2), and 3)."]
[null,"SG%—The indirect cost rate used by the Sea Grant program."]
[null,"Inst%—The indirect cost rate used by the host institution for non-Sea Grant projects."]
[null,"WAIVED $—The indirect costs not charged by the host institution for Sea Grant projects (e.g., Inst% - SG% = waived) can be claimed as match. If SG% = Inst% then there is no waived indirect costs to claim as match."]
[null,"The above items are locked by default and can be accessed by clicking SHOW FUNCTIONS and Unlock Modified Direct & H. Indirect Costs buttons."]

{"sheet":"FringeTable","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
["Fringe Benefit Rates Table"]
[null,"key person/personnel","fringe %","notes"]
[1,{"$f":"IF('90-4 for R&R Budget'!B12=\" \",\" \",IF('90-4 for R&R Budget'!B12=0,\" \",'90-4 for R&R Budget'!B12))","v":" "}]
[2,{"$f":"IF('90-4 for R&R Budget'!B13=\" \",\" \",IF('90-4 for R&R Budget'!B13=0,\" \",'90-4 for R&R Budget'!B13))","v":" "}]
[3,{"$f":"IF('90-4 for R&R Budget'!B14=\" \",\" \",IF('90-4 for R&R Budget'!B14=0,\" \",'90-4 for R&R Budget'!B14))","v":" "}]
[4,{"$f":"IF('90-4 for R&R Budget'!B15=\" \",\" \",IF('90-4 for R&R Budget'!B15=0,\" \",'90-4 for R&R Budget'!B15))","v":" "}]
[5,{"$f":"IF('90-4 for R&R Budget'!B16=\" \",\" \",IF('90-4 for R&R Budget'!B16=0,\" \",'90-4 for R&R Budget'!B16))","v":" "}]
[6,{"$f":"IF('90-4 for R&R Budget'!B17=\" \",\" \",IF('90-4 for R&R Budget'!B17=0,\" \",'90-4 for R&R Budget'!B17))","v":" "}]
[7,{"$f":"IF('90-4 for R&R Budget'!B18=\" \",\" \",IF('90-4 for R&R Budget'!B18=0,\" \",'90-4 for R&R Budget'!B18))","v":" "}]
[8,{"$f":"IF('90-4 for R&R Budget'!B19=\" \",\" \",IF('90-4 for R&R Budget'!B19=0,\" \",'90-4 for R&R Budget'!B19))","v":" "}]
[9,{"$f":"IF('90-4 for R&R Budget'!B20=\" \",\" \",IF('90-4 for R&R Budget'!B20=0,\" \",'90-4 for R&R Budget'!B20))","v":" "}]
[10,{"$f":"IF('90-4 for R&R Budget'!B21=\" \",\" \",IF('90-4 for R&R Budget'!B21=0,\" \",'90-4 for R&R Budget'!B21))","v":" "}]
[11,{"$f":"IF('90-4 for R&R Budget'!B22=\" \",\" \",IF('90-4 for R&R Budget'!B22=0,\" \",'90-4 for R&R Budget'!B22))","v":" "}]
[12,{"$f":"IF('90-4 for R&R Budget'!B23=\" \",\" \",IF('90-4 for R&R Budget'!B23=0,\" \",'90-4 for R&R Budget'!B23))","v":" "}]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
["Key Person 1-12 is autofilled from 90-4 Adapted budget; 13-24 open for user input. No budget calculations are altered by use of this table"]

{"sheet":"Notice","index":3,"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.\nA Federal agency may not conduct or sponsor, and a person is not required to respond to, nor shall a person be subject to a penalty\nfor failure to comply with an information collection subject to the requirements of the Paperwork Reduction Act of 1995 unless the\ninformation collection has a currently valid OMB Control Number. The approved OMB Control Number for this information\ncollection is 0648-0362. Without this approval, we could not conduct this information collection. Public reporting for this\ninformation collection is estimated to be approximately 30 minutes/hours per response, including the time for reviewing\ninstructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the\ninformation collection. All responses to this information collection are required to obtain benefits. Send comments regarding this\nburden estimate or any other aspect of this information collection, including suggestions for reducing this burden to the National\nSea Grant College Program, R/SG, NOAA, 1315 East-West Highway, Silver Spring, MD 20910 (Attn: Paperwork Reduction Act -\nChelsea Berg). \n"]

{"sheet":"dropdowns","index":4,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
[]
[]
["AK","SELECT BUDGET TYPE"]
["CT","Primary Budget"]
["DE","Subaward Budget"]
["FL"]
["GA"]
["GU"]
["HI"]
["IL-IN"]
["LA"]
["LC"]
["MD"]
["ME"]
["MI"]
["MIT"]
["MN"]
["MS-AL"]
["NC"]
["MN"]
["MS-AL"]
["NC"]
["NH"]
["NJ"]
["NSGLC"]
["NY"]
["OH"]
["OR"]
["PA"]
["PR"]
["RI"]
["SC"]
["TX"]
["USC"]
["UCSD"]
["VA"]
["WA"]
["WHOI"]
["WI"]
["Other"]
["non-SG"]