{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Y7 Roll-Over Funds Request","Y8 New Activities 100k Request","Salary Worksheet","Subaward Worksheet","Projected Ship Rates"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":1,"defined_names":37,"comments":3,"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":"1904"}

{"sheet":"Y7 Roll-Over Funds Request","index":0,"n_rows":129,"n_cols":13,"rows_kept":129,"cut":false,"hidden":false,"merged":[[120,0,120,1],[123,0,123,1],[126,0,126,2],[87,0,87,1],[110,0,110,1],[111,0,111,1],[112,0,112,1],[116,0,116,1],[117,0,117,1],[86,0,86,1],[42,0,42,1],[53,0,53,1],[54,0,54,1],[59,0,59,1],[60,0,60,1],[65,0,65,1],[66,0,66,1],[77,0,77,1],[78,0,78,1],[81,0,81,1],[82,0,82,1],[41,0,41,1],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[8,0,8,1],[21,0,21,1],[32,0,32,1],[33,0,33,1],[40,0,40,1],[2,8,2,9],[2,10,2,11],[0,0,0,4],[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11]]}
["Hobson UAK DHS Y7 Carry-forward/Roll Over Request"]
[]
["TOTAL",null,{"$f":"D129","v":156355.36981},null,{"$f":"F129","v":0},null,{"$f":"H129","v":0},null,{"$f":"J129","v":0},null,{"$f":"L129","v":0},null,{"$f":"M129","v":156355.36981}]
["SALARY/WAGES",null,1,"Y1",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y2",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y3",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y4",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y5","Total"]
[]
[{"$f":"'Salary Worksheet'!B13","v":"Hobson"},null,231.21,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D13*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":20662.11},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E13*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F13*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G13*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H13*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":20662.11}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D14*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E14*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F14*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G14*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H14*K7,2), ROUND('Salary Worksheet'!H5/12*K7,0))","v":0},{"$f":"SUM(J7+H7+F7+D7+L7)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D15*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E15*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F15*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G15*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H15*K8,2), ROUND('Salary Worksheet'!H6/12*K8,0))","v":0},{"$f":"SUM(J8+H8+F8+D8+L8)","v":0}]
["Subtotal Sr. Personnel Salary",null,null,{"$f":"SUM(D6:D8)","v":20662.11},null,{"$f":"SUM(F6:F8)","v":0},null,{"$f":"SUM(H6:H8)","v":0},null,{"$f":"SUM(J6:J8)","v":0},null,{"$f":"SUM(L6:L8)","v":0},{"$f":"SUM(J9+H9+F9+D9+L9)","v":20662.11}]
[{"$f":"'Salary Worksheet'!B16","v":"Kieft"},null,230,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D16*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":20390.91},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E16*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F16*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G16*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H16*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":20390.91}]
[{"$f":"'Salary Worksheet'!B17","v":"Raanan"},null,230,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D17*C11,2), ROUND('Salary Worksheet'!D4/12*C11,0))","v":14644.32},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E17*E11,2), ROUND('Salary Worksheet'!E4/12*E11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F17*G11,2), ROUND('Salary Worksheet'!F4/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G17*I11,2), ROUND('Salary Worksheet'!G4/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H17*K11,2), ROUND('Salary Worksheet'!H4/12*K11,2))","v":0},14644.32]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C15,2), ROUND('Salary Worksheet'!D8/12*C15,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E15,2), ROUND('Salary Worksheet'!E8/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G15,2), ROUND('Salary Worksheet'!F8/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I15,2), ROUND('Salary Worksheet'!G8/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K15,2), ROUND('Salary Worksheet'!H8/12*K15,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D20*C16,2), ROUND('Salary Worksheet'!D6/12*C16,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E16,2), ROUND('Salary Worksheet'!E6/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G16,2), ROUND('Salary Worksheet'!F6/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I16,2), ROUND('Salary Worksheet'!G6/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*K16,2), ROUND('Salary Worksheet'!H6/12*K16,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C17,2), ROUND('Salary Worksheet'!D7/12*C17,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E17,2), ROUND('Salary Worksheet'!E7/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G17,2), ROUND('Salary Worksheet'!F7/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I17,2), ROUND('Salary Worksheet'!G7/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K17,2), ROUND('Salary Worksheet'!H7/12*K17,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C18,2), ROUND('Salary Worksheet'!D8/12*C18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E18,2), ROUND('Salary Worksheet'!E8/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G18,2), ROUND('Salary Worksheet'!F8/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I18,2), ROUND('Salary Worksheet'!G8/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K18,2), ROUND('Salary Worksheet'!H8/12*K18,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C19,2), ROUND('Salary Worksheet'!D9/12*C19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E19,2), ROUND('Salary Worksheet'!E9/12*E19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G19,2), ROUND('Salary Worksheet'!F9/12*G19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I19,2), ROUND('Salary Worksheet'!G9/12*I19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K19,2), ROUND('Salary Worksheet'!H9/12*K19,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C20,2), ROUND('Salary Worksheet'!D10/12*C20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E20,2), ROUND('Salary Worksheet'!E10/12*E20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G20,2), ROUND('Salary Worksheet'!F10/12*G20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I20,2), ROUND('Salary Worksheet'!G10/12*I20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K20,2), ROUND('Salary Worksheet'!H10/12*K20,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C21,2), ROUND('Salary Worksheet'!D11/12*C21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E21,2), ROUND('Salary Worksheet'!E11/12*E21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G21,2), ROUND('Salary Worksheet'!F11/12*G21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I21,2), ROUND('Salary Worksheet'!G11/12*I21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K21,2), ROUND('Salary Worksheet'!H11/12*K21,2))","v":0},0]
["Subtotal Other Employee Salary",null,0,{"$f":"SUM(D10:D21)","v":35035.229999999996},0,{"$f":"SUM(F10:F21)","v":0},0,{"$f":"SUM(H10:H21)","v":0},0,{"$f":"SUM(J10:J21)","v":0},0,{"$f":"SUM(L10:L21)","v":0},{"$f":"SUM(J22+H22+F22+D22+L22)","v":35035.229999999996}]
["POSTDOCS, GSRs, PART-TIME, TEMPS",null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C25,2), ROUND('Salary Worksheet'!D29/12*C25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E25,2), ROUND('Salary Worksheet'!E29/12*E25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G25,2), ROUND('Salary Worksheet'!F29/12*G25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I25,2), ROUND('Salary Worksheet'!G29/12*I25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K25,2), ROUND('Salary Worksheet'!H29/12*K25,0))","v":0},{"$f":"SUM(J25+H25+F25+D25+L25)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D32*C26,2), ROUND('Salary Worksheet'!D31/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E32*E26,2), ROUND('Salary Worksheet'!E31/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F32*G26,2), ROUND('Salary Worksheet'!F31/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G32*I26,2), ROUND('Salary Worksheet'!G31/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H32*K26,2), ROUND('Salary Worksheet'!H31/12*K26,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E45*C27,2), ROUND('Salary Worksheet'!E38/12*C27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F45*E27,2), ROUND('Salary Worksheet'!F38/12*E27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G45*G27,2), ROUND('Salary Worksheet'!G38/12*G27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H45*I27,2), ROUND('Salary Worksheet'!H38/12*I27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I45*K27,2), ROUND('Salary Worksheet'!I38/12*K27,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E46*C28,2), ROUND('Salary Worksheet'!E39/12*C28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F46*E28,2), ROUND('Salary Worksheet'!F39/12*E28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G46*G28,2), ROUND('Salary Worksheet'!G39/12*G28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H46*I28,2), ROUND('Salary Worksheet'!H39/12*I28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I46*K28,2), ROUND('Salary Worksheet'!I39/12*K28,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E47*C29,2), ROUND('Salary Worksheet'!E40/12*C29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F47*E29,2), ROUND('Salary Worksheet'!F40/12*E29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G47*G29,2), ROUND('Salary Worksheet'!G40/12*G29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H47*I29,2), ROUND('Salary Worksheet'!H40/12*I29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I47*K29,2), ROUND('Salary Worksheet'!I40/12*K29,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E48*C30,2), ROUND('Salary Worksheet'!E41/12*C30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F48*E30,2), ROUND('Salary Worksheet'!F41/12*E30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G48*G30,2), ROUND('Salary Worksheet'!G41/12*G30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H48*I30,2), ROUND('Salary Worksheet'!H41/12*I30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I48*K30,2), ROUND('Salary Worksheet'!I41/12*K30,0))","v":0},0]
["Temporary Employee 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E49*C31,2), ROUND('Salary Worksheet'!E42/12*C31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F49*E31,2), ROUND('Salary Worksheet'!F42/12*E31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G49*G31,2), ROUND('Salary Worksheet'!G42/12*G31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H49*I31,2), ROUND('Salary Worksheet'!H42/12*I31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I49*K31,2), ROUND('Salary Worksheet'!I42/12*K31,0))","v":0},0]
["Temporary Employee 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E50*C32,2), ROUND('Salary Worksheet'!E43/12*C32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F50*E32,2), ROUND('Salary Worksheet'!F43/12*E32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G50*G32,2), ROUND('Salary Worksheet'!G43/12*G32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H50*I32,2), ROUND('Salary Worksheet'!H43/12*I32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I50*K32,2), ROUND('Salary Worksheet'!I43/12*K32,0))","v":0},0]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D22:D31)","v":35035.229999999996},null,{"$f":"SUM(F22:F31)","v":0},null,{"$f":"SUM(H22:H31)","v":0},null,{"$f":"SUM(J22:J31)","v":0},null,{"$f":"SUM(L22:L31)","v":0},35035.229999999996]
["Total Salary & Wages",null,null,{"$f":"SUM(D33+D9)","v":55697.34},null,{"$f":"SUM(F33+F9)","v":0},null,{"$f":"SUM(H33+H9)","v":0},null,{"$f":"SUM(J33+J9)","v":0},null,{"$f":"SUM(L33+L9)","v":0},55697.34]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D22)*$B$36)","v":31831.02981},null,{"$f":"((F9+F22)*$B$36)","v":0},null,{"$f":"((H9+H22)*$B$36)","v":0},null,{"$f":"((J9+J22)*$B$36)","v":0},null,{"$f":"((L9+L22)*$B$36)","v":0},{"$f":"SUM(J36+H36+F36+D36+L36)","v":31831.02981}]
["PostDoc",0.4123,null,{"$f":"D25*$B$37","v":0},null,{"$f":"F25*$B$37","v":0},null,{"$f":"H25*$B$37","v":0},null,{"$f":"J25*$B$37","v":0},null,{"$f":"L25*$B$37","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D27:D28))*$B$38","v":0},null,{"$f":"(SUM(F27:F28)*$B$38)","v":0},null,{"$f":"(SUM(H27:H28)*$B$38)","v":0},null,{"$f":"(SUM(J27:J28)*$B$38)","v":0},null,{"$f":"(SUM(L27:L28)*$B$38)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D26,D29,D30))*$B$39","v":0},null,{"$f":"(SUM(F26,F29,F30))*$B$39","v":0},null,{"$f":"(SUM(H26,H29,H30))*$B$39","v":0},null,{"$f":"(SUM(J26,J29,J30))*$B$39","v":0},null,{"$f":"(SUM(L26,L29,L30))*$B$39","v":0},0]
["Temp",0.1111,null,{"$f":"(D31+D32)*$B$40","v":0},null,{"$f":"(F31+F32)*$B$40","v":0},null,{"$f":"(H31+H32)*$B$40","v":0},null,{"$f":"(J31+J32)*$B$40","v":0},null,{"$f":"(L31+L32)*$B$40","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D36:D40)","v":31831.02981},null,{"$f":"SUM(F36:F40)","v":0},null,{"$f":"SUM(H36:H40)","v":0},null,{"$f":"SUM(J36:J40)","v":0},null,{"$f":"SUM(L36:L40)","v":0},31831.02981]
["Total Salary & Benefits",null,null,{"$f":"SUM(D41,D34)","v":87528.369810000004},null,{"$f":"SUM(F41,F34)","v":0},null,{"$f":"SUM(H41,H34)","v":0},null,{"$f":"SUM(J41,J34)","v":0},null,{"$f":"SUM(L41,L34)","v":0},87528.369810000004]
["CAPITAL EQUIPMENT  (items >$5K)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J44+H44+F44+D44+L44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J45+H45+F45+D45+L45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Equipment",null,null,{"$f":"SUM(D44:D53)","v":0},null,{"$f":"SUM(F44:F53)","v":0},null,{"$f":"SUM(H44:H53)","v":0},null,{"$f":"SUM(J44:J53)","v":0},null,{"$f":"SUM(L44:L53)","v":0},{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["TRAVEL"]
["Trip 1: New England Expedition",null,null,{"$f":"1350+2730+1491+315+630","v":6516},null,null,null,null,null,null,null,null,{"$f":"SUM(L56,J56,H56,F56,D56)","v":6516}]
["Trip 2: Lake Superior Under Ice Demo",null,null,{"$f":"1350+2730+1491+315+630","v":6516},null,null,null,null,null,null,null,null,{"$f":"SUM(L57,J57,H57,F57,D57)","v":6516}]
["Trip 3: Washington D.C.: Hobson Program review meeting",null,null,{"$f":"495+260+213","v":968},null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":968}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D56:D59)","v":14000},null,{"$f":"SUM(F56:F58)","v":0},null,{"$f":"SUM(H56:H58)","v":0},null,{"$f":"SUM(J56:J58)","v":0},null,{"$f":"SUM(L56:L58)","v":0},{"$f":"SUM(L60,J60,H60,F60,D60)","v":14000}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L63,J63,H63,F63,D63)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L64,J64,H64,F64,D64)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L65,J65,H65,F65,D65)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D62:D65)","v":0},null,{"$f":"SUM(F62:F65)","v":0},null,{"$f":"SUM(H62:H65)","v":0},null,{"$f":"SUM(J62:J65)","v":0},null,{"$f":"SUM(L62:L65)","v":0},{"$f":"SUM(L66,J66,H66,F66,D66)","v":0}]
["MATERIALS & SUPPLIES"]
["expedition clothing: 3 sets of jackt and parka liners",null,null,480,null,null,null,null,null,null,null,null,{"$f":"SUM(L68,J68,H68,F68,D68)","v":480}]
["expedition clothing: 3 jackets",null,null,520,null,null,null,null,null,null,null,null,{"$f":"SUM(L69,J69,H69,F69,D69)","v":520}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Materials & Supplies",null,null,{"$f":"SUM(D68:D77)","v":1000},null,{"$f":"SUM(F68:F77)","v":0},null,{"$f":"SUM(H68:H77)","v":0},null,{"$f":"SUM(J68:J77)","v":0},null,{"$f":"SUM(L68:L77)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":1000}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L80,J80,H80,F80,D80)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L81,J81,H81,F81,D81)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D80)","v":0},null,{"$f":"SUM(F80)","v":0},null,{"$f":"SUM(H80:H80)","v":0},null,{"$f":"SUM(J80:J80)","v":0},null,{"$f":"SUM(L80:L80)","v":0},{"$f":"SUM(L82,J82,H82,F82,D82)","v":0}]
["OUTSIDE SERVICES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L84,J84,H84,F84,D84)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L85,J85,H85,F85,D85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L86,J86,H86,F86,D86)","v":0}]
["Total Outside Services",null,null,{"$f":"SUM(D84:D85)","v":0},null,{"$f":"SUM(F84:F85)","v":0},null,{"$f":"SUM(H84:H85)","v":0},null,{"$f":"SUM(J84:J85)","v":0},null,{"$f":"SUM(L84:L85)","v":0},{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L89,J89,H89,F89,D89)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L90,J90,H90,F90,D90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L91,J91,H91,F91,D91)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L92,J92,H92,F92,D92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L93,J93,H93,F93,D93)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Subawards",null,null,{"$f":"SUM(D89:D110)","v":0},null,{"$f":"SUM(F89:F110)","v":0},null,{"$f":"SUM(H89:H110)","v":0},null,{"$f":"SUM(J89:J110)","v":0},null,{"$f":"SUM(L89:L110)","v":0},{"$f":"SUM(M89:M110)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B71","v":0},null,{"$f":"'Subaward Worksheet'!C71","v":0},null,{"$f":"'Subaward Worksheet'!D71","v":0},null,{"$f":"'Subaward Worksheet'!E71","v":0},null,{"$f":"'Subaward Worksheet'!F71","v":0}]
["OH on Subawards",null,null,{"$f":"'Subaward Worksheet'!$B$72","v":0},null,{"$f":"'Subaward Worksheet'!$C$72","v":0},null,{"$f":"'Subaward Worksheet'!$D$72","v":0},null,{"$f":"'Subaward Worksheet'!$E$72","v":0},null,{"$f":"'Subaward Worksheet'!$F$72","v":0},{"$f":"SUM(L113,J113,H113,F113,D113)","v":0}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B115*C115","v":0},null,{"$f":"B115*E115","v":0},null,{"$f":"B115*G115","v":0},null,{"$f":"B115*I115","v":0},null,{"$f":"B115*K115","v":0},{"$f":"SUM(L115,J115,H115,F115,D115)","v":0}]
[null,null,null,{"$f":"B116*C116","v":0},null,{"$f":"B116*E116","v":0},null,{"$f":"B116*G116","v":0},null,{"$f":"B116*I116","v":0},null,{"$f":"B116*K116","v":0},{"$f":"SUM(L116,J116,H116,F116,D116)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D115:D116)","v":0},null,{"$f":"SUM(F115:F116)","v":0},null,{"$f":"SUM(H115:H116)","v":0},null,{"$f":"SUM(J115:J116)","v":0},null,{"$f":"SUM(L115:L116)","v":0},{"$f":"SUM(L117,J117,H117,F117,D117)","v":0}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,0,{"$f":"(C119*'Salary Worksheet'!D33)","v":0},0,{"$f":"(E119*'Salary Worksheet'!E33)","v":0},0,{"$f":"(G119*'Salary Worksheet'!F33)","v":0},0,{"$f":"(I119*'Salary Worksheet'!G33)","v":0},0,{"$f":"(K119*'Salary Worksheet'!H33)","v":0},{"$f":"SUM(L119,J119,H119,F119,D119)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C120*'Salary Worksheet'!D34)","v":0},0,{"$f":"(E120*'Salary Worksheet'!E34)","v":0},0,{"$f":"(G120*'Salary Worksheet'!F34)","v":0},0,{"$f":"(I120*'Salary Worksheet'!G34)","v":0},0,{"$f":"(K120*'Salary Worksheet'!H34)","v":0},{"$f":"SUM(L120,J120,H120,F120,D120)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D119:D120)","v":0},null,{"$f":"SUM(F119:F120)","v":0},null,{"$f":"SUM(H119:H120)","v":0},null,{"$f":"SUM(J119:J120)","v":0},null,{"$f":"SUM(L119:L120)","v":0},{"$f":"SUM(L121,J121,H121,F121,D121)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L123,J123,H123,F123,D123)","v":0}]
["Total Shipping",null,null,{"$f":"SUM(D123)","v":0},null,{"$f":"SUM(F123)","v":0},null,{"$f":"SUM(H123:H123)","v":0},null,{"$f":"SUM(J123:J123)","v":0},null,{"$f":"SUM(L123:L123)","v":0},0]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D124,D121,D117,D111,D87,D82,D78,D66,D60,D54,D42)","v":102528.36981},null,{"$f":"SUM(F124,F121,F117,F111,F87,F82,F78,F66,F60,F54,F42)","v":0},null,{"$f":"SUM(H124,H121,H117,H111,H87,H82,H78,H66,H60,H54,H42)","v":0},null,{"$f":"SUM(J124,J121,J117,J111,J87,J82,J78,J66,J60,J54,J42)","v":0},null,{"$f":"SUM(L124,L121,L117,L111,L87,L82,L78,L66,L60,L54,L42)","v":0},102528.36981]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D126-D117-D111+D112-D66-D54","v":102528.36981},null,{"$f":"F126-F117-F111+F112-F66-F54","v":0},null,{"$f":"H126-H117-H111+H112-H66-H54","v":0},null,{"$f":"J126-J117-J111+J112-J66-J54","v":0},null,{"$f":"L126-L117-L111+L112-L66-L54","v":0},102528.36981]
["TOTAL INDIRECT COSTS",null,0.52500000000000002,{"$f":"ROUND(D127*$C$128,0)","v":53827},null,{"$f":"ROUND(F127*$C$128,0)","v":0},null,{"$f":"ROUND(H127*$C$128,0)","v":0},null,0,null,0,53827]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D128+D126","v":156355.36981},null,{"$f":"+F128+F126","v":0},null,{"$f":"+H128+H126","v":0},null,{"$f":"+J128+J126","v":0},null,{"$f":"+L128+L126","v":0},156355.36981]

{"sheet":"Y8 New Activities 100k Request","index":1,"n_rows":129,"n_cols":13,"rows_kept":129,"cut":false,"hidden":false,"merged":[[1,4,1,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[1,6,1,7],[1,8,1,9],[1,10,1,11],[126,0,126,2],[40,0,40,1],[41,0,41,1],[32,0,32,1],[8,0,8,1],[53,0,53,1],[33,0,33,1],[59,0,59,1],[65,0,65,1],[77,0,77,1],[81,0,81,1],[86,0,86,1],[60,0,60,1],[21,0,21,1],[116,0,116,1],[120,0,120,1],[123,0,123,1],[0,0,0,4],[78,0,78,1],[42,0,42,1],[54,0,54,1],[66,0,66,1],[82,0,82,1],[87,0,87,1],[117,0,117,1],[112,0,112,1],[111,0,111,1],[2,2,2,3],[2,4,2,5],[110,0,110,1],[2,0,2,1],[1,2,1,3]]}
["Hobson UAK DHS Y8 New Activities Request"]
[]
["TOTAL",null,{"$f":"D129","v":100000.23194},null,{"$f":"F129","v":0},null,{"$f":"H129","v":0},null,{"$f":"J129","v":0},null,{"$f":"L129","v":0},null,{"$f":"M129","v":100000.23194}]
["SALARY/WAGES",null,1,"Y1",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y2",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y3",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y4",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"HOURS"},"Y5","Total"]
[]
[{"$f":"'Salary Worksheet'!B13","v":"Hobson"},null,80,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D13*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":7149.21},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E13*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F13*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G13*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H13*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":7149.21}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D14*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E14*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F14*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G14*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H14*K7,2), ROUND('Salary Worksheet'!H5/12*K7,0))","v":0},{"$f":"SUM(J7+H7+F7+D7+L7)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D15*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E15*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F15*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G15*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H15*K8,2), ROUND('Salary Worksheet'!H6/12*K8,0))","v":0},{"$f":"SUM(J8+H8+F8+D8+L8)","v":0}]
["Subtotal Sr. Personnel Salary",null,null,{"$f":"SUM(D6:D8)","v":7149.21},null,{"$f":"SUM(F6:F8)","v":0},null,{"$f":"SUM(H6:H8)","v":0},null,{"$f":"SUM(J6:J8)","v":0},null,{"$f":"SUM(L6:L8)","v":0},{"$f":"SUM(J9+H9+F9+D9+L9)","v":7149.21}]
[{"$f":"'Salary Worksheet'!B16","v":"Kieft"},null,225,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D16*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":19947.63},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E16*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F16*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G16*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H16*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":19947.63}]
[{"$f":"'Salary Worksheet'!B17","v":"Raanan"},null,229.78,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D17*C11,2), ROUND('Salary Worksheet'!D4/12*C11,0))","v":14630.32},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E17*E11,2), ROUND('Salary Worksheet'!E4/12*E11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F17*G11,2), ROUND('Salary Worksheet'!F4/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G17*I11,2), ROUND('Salary Worksheet'!G4/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H17*K11,2), ROUND('Salary Worksheet'!H4/12*K11,2))","v":0},14630.32]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C15,2), ROUND('Salary Worksheet'!D8/12*C15,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E15,2), ROUND('Salary Worksheet'!E8/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G15,2), ROUND('Salary Worksheet'!F8/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I15,2), ROUND('Salary Worksheet'!G8/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K15,2), ROUND('Salary Worksheet'!H8/12*K15,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D20*C16,2), ROUND('Salary Worksheet'!D6/12*C16,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E16,2), ROUND('Salary Worksheet'!E6/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G16,2), ROUND('Salary Worksheet'!F6/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I16,2), ROUND('Salary Worksheet'!G6/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*K16,2), ROUND('Salary Worksheet'!H6/12*K16,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C17,2), ROUND('Salary Worksheet'!D7/12*C17,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E17,2), ROUND('Salary Worksheet'!E7/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G17,2), ROUND('Salary Worksheet'!F7/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I17,2), ROUND('Salary Worksheet'!G7/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K17,2), ROUND('Salary Worksheet'!H7/12*K17,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C18,2), ROUND('Salary Worksheet'!D8/12*C18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E18,2), ROUND('Salary Worksheet'!E8/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G18,2), ROUND('Salary Worksheet'!F8/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I18,2), ROUND('Salary Worksheet'!G8/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K18,2), ROUND('Salary Worksheet'!H8/12*K18,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C19,2), ROUND('Salary Worksheet'!D9/12*C19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E19,2), ROUND('Salary Worksheet'!E9/12*E19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G19,2), ROUND('Salary Worksheet'!F9/12*G19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I19,2), ROUND('Salary Worksheet'!G9/12*I19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K19,2), ROUND('Salary Worksheet'!H9/12*K19,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C20,2), ROUND('Salary Worksheet'!D10/12*C20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E20,2), ROUND('Salary Worksheet'!E10/12*E20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G20,2), ROUND('Salary Worksheet'!F10/12*G20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I20,2), ROUND('Salary Worksheet'!G10/12*I20,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K20,2), ROUND('Salary Worksheet'!H10/12*K20,2))","v":0},0]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C21,2), ROUND('Salary Worksheet'!D11/12*C21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E21,2), ROUND('Salary Worksheet'!E11/12*E21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G21,2), ROUND('Salary Worksheet'!F11/12*G21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I21,2), ROUND('Salary Worksheet'!G11/12*I21,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K21,2), ROUND('Salary Worksheet'!H11/12*K21,2))","v":0},0]
["Subtotal Other Employee Salary",null,0,{"$f":"SUM(D10:D21)","v":34577.949999999997},0,{"$f":"SUM(F10:F21)","v":0},0,{"$f":"SUM(H10:H21)","v":0},0,{"$f":"SUM(J10:J21)","v":0},0,{"$f":"SUM(L10:L21)","v":0},{"$f":"SUM(J22+H22+F22+D22+L22)","v":34577.949999999997}]
["POSTDOCS, GSRs, PART-TIME, TEMPS",null,0,null,0,null,0,null,0,null,0]
[null,null,0,null,0,null,0,null,0,null,0]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C25,2), ROUND('Salary Worksheet'!D29/12*C25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E25,2), ROUND('Salary Worksheet'!E29/12*E25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G25,2), ROUND('Salary Worksheet'!F29/12*G25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I25,2), ROUND('Salary Worksheet'!G29/12*I25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K25,2), ROUND('Salary Worksheet'!H29/12*K25,0))","v":0},{"$f":"SUM(J25+H25+F25+D25+L25)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D32*C26,2), ROUND('Salary Worksheet'!D31/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E32*E26,2), ROUND('Salary Worksheet'!E31/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F32*G26,2), ROUND('Salary Worksheet'!F31/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G32*I26,2), ROUND('Salary Worksheet'!G31/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H32*K26,2), ROUND('Salary Worksheet'!H31/12*K26,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E45*C27,2), ROUND('Salary Worksheet'!E38/12*C27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F45*E27,2), ROUND('Salary Worksheet'!F38/12*E27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G45*G27,2), ROUND('Salary Worksheet'!G38/12*G27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H45*I27,2), ROUND('Salary Worksheet'!H38/12*I27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I45*K27,2), ROUND('Salary Worksheet'!I38/12*K27,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E46*C28,2), ROUND('Salary Worksheet'!E39/12*C28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F46*E28,2), ROUND('Salary Worksheet'!F39/12*E28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G46*G28,2), ROUND('Salary Worksheet'!G39/12*G28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H46*I28,2), ROUND('Salary Worksheet'!H39/12*I28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I46*K28,2), ROUND('Salary Worksheet'!I39/12*K28,0))","v":0},{"$f":"SUM(J28+H28+F28+D28+L28)","v":0}]
["Part-time (<= 29 hrs/wk) 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E47*C29,2), ROUND('Salary Worksheet'!E40/12*C29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F47*E29,2), ROUND('Salary Worksheet'!F40/12*E29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G47*G29,2), ROUND('Salary Worksheet'!G40/12*G29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H47*I29,2), ROUND('Salary Worksheet'!H40/12*I29,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I47*K29,2), ROUND('Salary Worksheet'!I40/12*K29,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E48*C30,2), ROUND('Salary Worksheet'!E41/12*C30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F48*E30,2), ROUND('Salary Worksheet'!F41/12*E30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G48*G30,2), ROUND('Salary Worksheet'!G41/12*G30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H48*I30,2), ROUND('Salary Worksheet'!H41/12*I30,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I48*K30,2), ROUND('Salary Worksheet'!I41/12*K30,0))","v":0},{"$f":"SUM(J30+H30+F30+D30+L30)","v":0}]
["Temporary Employee 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E49*C31,2), ROUND('Salary Worksheet'!E42/12*C31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F49*E31,2), ROUND('Salary Worksheet'!F42/12*E31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G49*G31,2), ROUND('Salary Worksheet'!G42/12*G31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H49*I31,2), ROUND('Salary Worksheet'!H42/12*I31,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I49*K31,2), ROUND('Salary Worksheet'!I42/12*K31,0))","v":0},0]
["Temporary Employee 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E50*C32,2), ROUND('Salary Worksheet'!E43/12*C32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F50*E32,2), ROUND('Salary Worksheet'!F43/12*E32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G50*G32,2), ROUND('Salary Worksheet'!G43/12*G32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H50*I32,2), ROUND('Salary Worksheet'!H43/12*I32,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I50*K32,2), ROUND('Salary Worksheet'!I43/12*K32,0))","v":0},{"$f":"SUM(J32+H32+F32+D32+L32)","v":0}]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D22:D31)","v":34577.949999999997},null,{"$f":"SUM(F22:F31)","v":0},null,{"$f":"SUM(H22:H31)","v":0},null,{"$f":"SUM(J22:J31)","v":0},null,{"$f":"SUM(L22:L31)","v":0},34577.949999999997]
["Total Salary & Wages",null,null,{"$f":"SUM(D33+D9)","v":41727.159999999996},null,{"$f":"SUM(F33+F9)","v":0},null,{"$f":"SUM(H33+H9)","v":0},null,{"$f":"SUM(J33+J9)","v":0},null,{"$f":"SUM(L33+L9)","v":0},41727.159999999996]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D22)*$B$36)","v":23847.071939999998},null,{"$f":"((F9+F22)*$B$36)","v":0},null,{"$f":"((H9+H22)*$B$36)","v":0},null,{"$f":"((J9+J22)*$B$36)","v":0},null,{"$f":"((L9+L22)*$B$36)","v":0},{"$f":"SUM(J36+H36+F36+D36+L36)","v":23847.071939999998}]
["PostDoc",0.4123,null,{"$f":"D25*$B$37","v":0},null,{"$f":"F25*$B$37","v":0},null,{"$f":"H25*$B$37","v":0},null,{"$f":"J25*$B$37","v":0},null,{"$f":"L25*$B$37","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D27:D28))*$B$38","v":0},null,{"$f":"(SUM(F27:F28)*$B$38)","v":0},null,{"$f":"(SUM(H27:H28)*$B$38)","v":0},null,{"$f":"(SUM(J27:J28)*$B$38)","v":0},null,{"$f":"(SUM(L27:L28)*$B$38)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D26,D29,D30))*$B$39","v":0},null,{"$f":"(SUM(F26,F29,F30))*$B$39","v":0},null,{"$f":"(SUM(H26,H29,H30))*$B$39","v":0},null,{"$f":"(SUM(J26,J29,J30))*$B$39","v":0},null,{"$f":"(SUM(L26,L29,L30))*$B$39","v":0},0]
["Temp",0.1111,null,{"$f":"(D31+D32)*$B$40","v":0},null,{"$f":"(F31+F32)*$B$40","v":0},null,{"$f":"(H31+H32)*$B$40","v":0},null,{"$f":"(J31+J32)*$B$40","v":0},null,{"$f":"(L31+L32)*$B$40","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D36:D40)","v":23847.071939999998},null,{"$f":"SUM(F36:F40)","v":0},null,{"$f":"SUM(H36:H40)","v":0},null,{"$f":"SUM(J36:J40)","v":0},null,{"$f":"SUM(L36:L40)","v":0},23847.071939999998]
["Total Salary & Benefits",null,null,{"$f":"SUM(D41,D34)","v":65574.231939999998},null,{"$f":"SUM(F41,F34)","v":0},null,{"$f":"SUM(H41,H34)","v":0},null,{"$f":"SUM(J41,J34)","v":0},null,{"$f":"SUM(L41,L34)","v":0},65574.231939999998]
["CAPITAL EQUIPMENT  (items >$5K)"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J44+H44+F44+D44+L44)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J45+H45+F45+D45+L45)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Equipment",null,null,{"$f":"SUM(D44:D53)","v":0},null,{"$f":"SUM(F44:F53)","v":0},null,{"$f":"SUM(H44:H53)","v":0},null,{"$f":"SUM(J44:J53)","v":0},null,{"$f":"SUM(L44:L53)","v":0},{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["TRAVEL"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L56,J56,H56,F56,D56)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L57,J57,H57,F57,D57)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D56:D59)","v":0},null,{"$f":"SUM(F56:F58)","v":0},null,{"$f":"SUM(H56:H58)","v":0},null,{"$f":"SUM(J56:J58)","v":0},null,{"$f":"SUM(L56:L58)","v":0},{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L63,J63,H63,F63,D63)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L64,J64,H64,F64,D64)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L65,J65,H65,F65,D65)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D62:D65)","v":0},null,{"$f":"SUM(F62:F65)","v":0},null,{"$f":"SUM(H62:H65)","v":0},null,{"$f":"SUM(J62:J65)","v":0},null,{"$f":"SUM(L62:L65)","v":0},{"$f":"SUM(L66,J66,H66,F66,D66)","v":0}]
["MATERIALS & SUPPLIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L68,J68,H68,F68,D68)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L69,J69,H69,F69,D69)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Materials & Supplies",null,null,{"$f":"SUM(D68:D77)","v":0},null,{"$f":"SUM(F68:F77)","v":0},null,{"$f":"SUM(H68:H77)","v":0},null,{"$f":"SUM(J68:J77)","v":0},null,{"$f":"SUM(L68:L77)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L80,J80,H80,F80,D80)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L81,J81,H81,F81,D81)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D80)","v":0},null,{"$f":"SUM(F80)","v":0},null,{"$f":"SUM(H80:H80)","v":0},null,{"$f":"SUM(J80:J80)","v":0},null,{"$f":"SUM(L80:L80)","v":0},{"$f":"SUM(L82,J82,H82,F82,D82)","v":0}]
["OUTSIDE SERVICES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L84,J84,H84,F84,D84)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L85,J85,H85,F85,D85)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L86,J86,H86,F86,D86)","v":0}]
["Total Outside Services",null,null,{"$f":"SUM(D84:D85)","v":0},null,{"$f":"SUM(F84:F85)","v":0},null,{"$f":"SUM(H84:H85)","v":0},null,{"$f":"SUM(J84:J85)","v":0},null,{"$f":"SUM(L84:L85)","v":0},{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L89,J89,H89,F89,D89)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L90,J90,H90,F90,D90)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L91,J91,H91,F91,D91)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L92,J92,H92,F92,D92)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L93,J93,H93,F93,D93)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Subawards",null,null,{"$f":"SUM(D89:D110)","v":0},null,{"$f":"SUM(F89:F110)","v":0},null,{"$f":"SUM(H89:H110)","v":0},null,{"$f":"SUM(J89:J110)","v":0},null,{"$f":"SUM(L89:L110)","v":0},{"$f":"SUM(M89:M110)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B71","v":0},null,{"$f":"'Subaward Worksheet'!C71","v":0},null,{"$f":"'Subaward Worksheet'!D71","v":0},null,{"$f":"'Subaward Worksheet'!E71","v":0},null,{"$f":"'Subaward Worksheet'!F71","v":0}]
["OH on Subawards",null,null,{"$f":"'Subaward Worksheet'!$B$72","v":0},null,{"$f":"'Subaward Worksheet'!$C$72","v":0},null,{"$f":"'Subaward Worksheet'!$D$72","v":0},null,{"$f":"'Subaward Worksheet'!$E$72","v":0},null,{"$f":"'Subaward Worksheet'!$F$72","v":0},{"$f":"SUM(L113,J113,H113,F113,D113)","v":0}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B115*C115","v":0},null,{"$f":"B115*E115","v":0},null,{"$f":"B115*G115","v":0},null,{"$f":"B115*I115","v":0},null,{"$f":"B115*K115","v":0},{"$f":"SUM(L115,J115,H115,F115,D115)","v":0}]
[null,null,null,{"$f":"B116*C116","v":0},null,{"$f":"B116*E116","v":0},null,{"$f":"B116*G116","v":0},null,{"$f":"B116*I116","v":0},null,{"$f":"B116*K116","v":0},{"$f":"SUM(L116,J116,H116,F116,D116)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D115:D116)","v":0},null,{"$f":"SUM(F115:F116)","v":0},null,{"$f":"SUM(H115:H116)","v":0},null,{"$f":"SUM(J115:J116)","v":0},null,{"$f":"SUM(L115:L116)","v":0},{"$f":"SUM(L117,J117,H117,F117,D117)","v":0}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,0,{"$f":"(C119*'Salary Worksheet'!D33)","v":0},0,{"$f":"(E119*'Salary Worksheet'!E33)","v":0},0,{"$f":"(G119*'Salary Worksheet'!F33)","v":0},0,{"$f":"(I119*'Salary Worksheet'!G33)","v":0},0,{"$f":"(K119*'Salary Worksheet'!H33)","v":0},{"$f":"SUM(L119,J119,H119,F119,D119)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C120*'Salary Worksheet'!D34)","v":0},0,{"$f":"(E120*'Salary Worksheet'!E34)","v":0},0,{"$f":"(G120*'Salary Worksheet'!F34)","v":0},0,{"$f":"(I120*'Salary Worksheet'!G34)","v":0},0,{"$f":"(K120*'Salary Worksheet'!H34)","v":0},{"$f":"SUM(L120,J120,H120,F120,D120)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D119:D120)","v":0},null,{"$f":"SUM(F119:F120)","v":0},null,{"$f":"SUM(H119:H120)","v":0},null,{"$f":"SUM(J119:J120)","v":0},null,{"$f":"SUM(L119:L120)","v":0},{"$f":"SUM(L121,J121,H121,F121,D121)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L123,J123,H123,F123,D123)","v":0}]
["Total Shipping",null,null,{"$f":"SUM(D123)","v":0},null,{"$f":"SUM(F123)","v":0},null,{"$f":"SUM(H123:H123)","v":0},null,{"$f":"SUM(J123:J123)","v":0},null,{"$f":"SUM(L123:L123)","v":0},0]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D124,D121,D117,D111,D87,D82,D78,D66,D60,D54,D42)","v":65574.231939999998},null,{"$f":"SUM(F124,F121,F117,F111,F87,F82,F78,F66,F60,F54,F42)","v":0},null,{"$f":"SUM(H124,H121,H117,H111,H87,H82,H78,H66,H60,H54,H42)","v":0},null,{"$f":"SUM(J124,J121,J117,J111,J87,J82,J78,J66,J60,J54,J42)","v":0},null,{"$f":"SUM(L124,L121,L117,L111,L87,L82,L78,L66,L60,L54,L42)","v":0},65574.231939999998]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D126-D117-D111+D112-D66-D54","v":65574.231939999998},null,{"$f":"F126-F117-F111+F112-F66-F54","v":0},null,{"$f":"H126-H117-H111+H112-H66-H54","v":0},null,{"$f":"J126-J117-J111+J112-J66-J54","v":0},null,{"$f":"L126-L117-L111+L112-L66-L54","v":0},65574.231939999998]
["TOTAL INDIRECT COSTS",null,0.52500000000000002,{"$f":"ROUND(D127*$C$128,0)","v":34426},null,{"$f":"ROUND(F127*$C$128,0)","v":0},null,{"$f":"ROUND(H127*$C$128,0)","v":0},null,0,null,0,34426]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D128+D126","v":100000.23194},null,{"$f":"+F128+F126","v":0},null,{"$f":"+H128+H126","v":0},null,{"$f":"+J128+J126","v":0},null,{"$f":"+L128+L126","v":0},100000.23194]

{"sheet":"Salary Worksheet","index":2,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,0,35,8],[50,0,50,8],[0,0,0,8],[27,0,27,8],[33,0,33,2],[32,0,32,2],[30,1,30,2],[28,1,28,2],[1,6,1,8]]}
["SALARY WORKSHEET"]
[null,"Salary Increase Rate:",0.03,null,null,null,"CONFIDENTIAL INFORMATION"]
[null,null,"ANNUAL SALARY","YR-1","YR-2","YR-3","YR-4","YR-5"]
[null,"PI/Co-PI1",0,{"$f":"ROUND(C4*($C$2+1),0)","v":0},{"$f":"ROUND(D4*($C$2+1),0)","v":0},{"$f":"ROUND(E4*($C$2+1),0)","v":0},{"$f":"ROUND(F4*($C$2+1),0)","v":0},{"$f":"ROUND(G4*($C$2+1),0)","v":0}]
[null,"PI/Co-PI 2",0,{"$f":"ROUND(C5*($C$2+1),0)","v":0},{"$f":"ROUND(D5*(C2+1),0)","v":0},{"$f":"ROUND(E5*($C$2+1),0)","v":0},0,0]
[null,"PI/Co-PI 3",0,0,{"$f":"ROUND(D6*(C2+1),0)","v":0},0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D7*(C2+1),0)","v":0},0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D8*(C2+1),0)","v":0},0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D9*(C2+1),0)","v":0},0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D10*(C2+1),0)","v":0},0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D11*(C2+1),0)","v":0},0,0,0]
[null,null,"HOURLY RATE","YR-1","YR-2","YR-3","YR-4","YR-5"]
[null,"Hobson",{"$f":"84.2352*1.03","v":86.762256000000008},{"$f":"C13*1.03","v":89.365123680000011},{"$f":"ROUND(D13*1.03, 2)","v":92.05},{"$f":"ROUND(E13*1.03, 2)","v":94.81},97.65,100.58]
[null,"PI/Co-PI 2",0,{"$f":"C14*1.03","v":0},{"$f":"ROUND(D14*1.03, 2)","v":0},0,0,0]
[null,"PI/Co-PI 3",0,0,0,0,0,0]
[null,"Kieft",{"$f":"83.5669*1.03","v":86.073907000000005},88.656124210000002,{"$f":"ROUND(D16*1.03, 2)","v":91.32},{"$f":"ROUND(E16*1.03, 2)","v":94.06},{"$f":"ROUND(F16*1.03, 2)","v":96.88},{"$f":"ROUND(G16*1.03, 2)","v":99.79}]
[null,"Raanan",{"$f":"60.016*1.03","v":61.816479999999999},63.670974399999999,65.58,67.55,69.58,71.67]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,{"$f":"ROUND(D24*1.03, 2)","v":0},{"$f":"ROUND(E24*1.03, 2)","v":0},{"$f":"ROUND(F24*1.03, 2)","v":0},{"$f":"ROUND(G24*1.03, 2)","v":0}]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
[null,"Other Employee ",0,0,0,0,0,0]
["Postdoc salaries and grad student salaries and tuition are set by MBARI and UCSC policies. The cells below are locked and you do not need to enter any information here. Calculate postdoc and grad student salaries and tuition by entering months of effort/academic quarters in the corresponding cells in the Budget Worksheet."]
[null,"Postdocs",null,60000,63000,65000,{"$f":"F29*1.03","v":66950},{"$f":"G29*1.03","v":68958.5}]
[null,null,"Postdoc (Hourly)",{"$f":"D29/2080","v":28.846153846153847},{"$f":"E29/2080","v":30.28846153846154},{"$f":"F29/2080","v":31.25},{"$f":"G29/2080","v":32.1875},{"$f":"H29/2080","v":33.153125000000003}]
[null,"Graduate Students",null,30875,30875,30875,24450,34450]
[null,null,"Grad Student (Hourly)",23.75,23.75,23.75,26.5,26.5]
["UCSC Resident Tuition (per quarter)",null,null,6660,{"$f":"D33*1.07","v":7126.2000000000007},{"$f":"E33*1.07","v":7625.0340000000015},8158.7863800000023,8729.9014266000031]
["UCSC Non-Res Tuition (per quarter)",null,null,15000,16050.000000000002,17173.500000000004,18375.645000000004,19661.940150000006]
[]
["PART-TIME & TEMP EMPLOYEES"]
["ANNUAL",null,"Hourly Rate","Hrs/Wk","ANNUAL SALARY","YR-2","YR-3","YR-4","YR-5"]
[null,"PT (30-39 hrs) 1",0,null,{"$f":"ROUND(C38*40*52,0)","v":0},{"$f":"ROUND(E38*(1+$C$2),0)","v":0},0,0,{"$f":"ROUND(H38*($C$2+1),0)","v":0}]
[null,"PT (30-39 hrs) 2",0,null,{"$f":"ROUND(C39*40*52,0)","v":0},0,0,0,{"$f":"ROUND(H39*($C$2+1),0)","v":0}]
[null,"PT (≤29 hrs) 1",0,null,{"$f":"ROUND(C40*40*52,0)","v":0},0,0,0,0]
[null,"PT (≤29 hrs) 2",0,null,0,0,0,0,0]
[null,"Temp 1",0,null,0,0,0,0,0]
[null,"Temp 2",0,null,0,{"$f":"ROUND(E43*(1+$C$2),0)","v":0},{"$f":"ROUND(F43*(1+$C$2),0)","v":0},{"$f":"ROUND(G43*(1+$C$2),0)","v":0},{"$f":"ROUND(H43*($C$2+1),0)","v":0}]
["HOURLY",null,"Hourly Rate",null,"Y1","YR-2","YR-3","YR-4","YR-5"]
[null,"PT (30-39 hrs) 1",{"$f":"C38","v":0},null,{"$f":"C38","v":0},{"$f":"E45*(1+$C$2)","v":0},{"$f":"F45*(1+$C$2)","v":0},0,0]
[null,"PT (30-39 hrs) 2",0,null,0,{"$f":"E46*(1+$C$2)","v":0},0,0,0]
[null,"PT (≤29 hrs) 1",0,null,0,0,0,0,0]
[null,"PT (≤29 hrs) 2",0,null,0,0,0,0,0]
[null,"Temporary Employee 1",0,null,0,0,0,0,0]
[null,"Temporary Employee 2",0,null,0,{"$f":"E50*(1+$C$2)","v":0},{"$f":"F50*(1+$C$2)","v":0},{"$f":"G50*(1+$C$2)","v":0},{"$f":"H50*(1+$C$2)","v":0}]
["SALARY CALCULATOR"]
["Hours","Hours",null,"Hourly rate:",0,"Annual Salary:",{"$f":"ROUND(E52*40*52,0)","v":0}]
["Months","Months",null,"Monthly rate:",0,"Annual Salary:",{"$f":"ROUND(E53*12,0)","v":0}]
[null,null,null,"Annual Salary",0,"Hourly rate:",{"$f":"ROUND(E54/2080,2)","v":0}]

{"sheet":"Subaward Worksheet","index":3,"n_rows":74,"n_cols":7,"rows_kept":74,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["SUBAWARD WORKSHEET"]
["Note: This worksheet calculates subaward overhead and is populated automatically. Enter subaward amounts in the main Budget Worksheet."]
[null,"Y1","Y2","Y3","Y4","Y5","Y1-5"]
[{"$f":"'Y8 New Activities 100k Request'!$A$89","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$89","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$89","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$89","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$89","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$89","v":0},{"$f":"SUM(B4:F4)","v":0}]
["Subject to OH",{"$f":"IF(B4>25000, 25000, B4)","v":0},{"$f":"IF(B4+C4>25000, 25000-B5, C4)","v":0},{"$f":"IF(B4+C4+D4>25000, 25000-(B5+C5), D4)","v":0},{"$f":"IF(B4+C4+D4+E4>25000, 25000-(B5+C5+D5), E4)","v":0},{"$f":"IF(B4+C4+D4+E4+F4>25000, 25000-(B5+C5+D5+E5), F4)","v":0},{"$f":"SUM(B5:F5)","v":0}]
["OH",{"$f":"IF(B4>25000,13125,(B4*0.525))","v":0},{"$f":"IF(C4+B4>25000,13125-B6,ROUND(C4*0.525,0))","v":0},{"$f":"IF(D4+C4+B4>25000,13125-(B6+C6),(D4*0.525))","v":0},{"$f":"IF(E4+D4+C4+B4>25000,13125-(B6+C6+D6),(E4*0.525))","v":0},{"$f":"IF(F4+E4+D4+C4+B4>25000,13125-(B6+C6+D6+E6),(F4*0.525))","v":0},{"$f":"SUM(B6:F6)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$90","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$90","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$90","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$90","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$90","v":0},0]
["Subject to OH",{"$f":"IF(B7>25000, 25000, B7)","v":0},{"$f":"IF(B7+C7>25000, 25000-B8, C7)","v":0},{"$f":"IF(B7+C7+D7>25000, 25000-(B8+C8), D7)","v":0},{"$f":"IF(B7+C7+D7+E7>25000, 25000-(B8+C8+D8), E7)","v":0},{"$f":"IF(B7+C7+D7+E7+F7>25000, 25000-(B8+C8+D8+E8), F7)","v":0},{"$f":"SUM(B8:F8)","v":0}]
["OH",{"$f":"IF(B7>25000,13125,(B7*0.525))","v":0},{"$f":"IF(C7+B7>25000,13125-B9,ROUND(C7*0.525,0))","v":0},{"$f":"IF(D7+C7+B7>25000,13125-(B9+C9),(D7*0.525))","v":0},{"$f":"IF(E7+D7+C7+B7>25000,13125-(B9+C9+D9),(E7*0.525))","v":0},{"$f":"IF(F7+E7+D7+C7+B7>25000,13125-(B9+C9+D9+E9),(F7*0.525))","v":0},{"$f":"SUM(B9:F9)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$91","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$91","v":0},{"$f":"SUM(B10:F10)","v":0}]
["Subject to OH",{"$f":"IF(B10>25000, 25000, B10)","v":0},{"$f":"IF(B10+C10>25000, 25000-B11, C10)","v":0},{"$f":"IF(B10+C10+D10>25000, 25000-(B11+C11), D10)","v":0},{"$f":"IF(B10+C10+D10+E10>25000, 25000-(B11+C11+D11), E10)","v":0},{"$f":"IF(B10+C10+D10+E10+F10>25000, 25000-(B11+C11+D11+E11), F10)","v":0},{"$f":"SUM(B11:F11)","v":0}]
["OH",{"$f":"IF(B10>25000,13125,(B10*0.525))","v":0},{"$f":"IF(C10+B10>25000,13125-B12,ROUND(C10*0.525,0))","v":0},{"$f":"IF(D10+C10+B10>25000,13125-(B12+C12),(D10*0.525))","v":0},{"$f":"IF(E10+D10+C10+B10>25000,13125-(B12+C12+D12),(E10*0.525))","v":0},{"$f":"IF(F10+E10+D10+C10+B10>25000,13125-(B12+C12+D12+E12),(F10*0.525))","v":0},{"$f":"SUM(B12:F12)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$92","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$92","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$92","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$92","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$92","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$92","v":0},0]
["Subject to OH",{"$f":"IF(B13>25000, 25000, B13)","v":0},{"$f":"IF(B13+C13>25000, 25000-B14, C13)","v":0},{"$f":"IF(B13+C13+D13>25000, 25000-(B14+C14), D13)","v":0},{"$f":"IF(B13+C13+D13+E13>25000, 25000-(B14+C14+D14), E13)","v":0},{"$f":"IF(B13+C13+D13+E13+F13>25000, 25000-(B14+C14+D14+E14), F13)","v":0},{"$f":"SUM(B14:F14)","v":0}]
["OH",{"$f":"IF(B13>25000,13125,(B13*0.525))","v":0},{"$f":"IF(C13+B13>25000,13125-B15,ROUND(C13*0.525,0))","v":0},{"$f":"IF(D13+C13+B13>25000,13125-(B15+C15),(D13*0.525))","v":0},{"$f":"IF(E13+D13+C13+B13>25000,13125-(B15+C15+D15),(E13*0.525))","v":0},{"$f":"IF(F13+E13+D13+C13+B13>25000,13125-(B15+C15+D15+E15),(F13*0.525))","v":0},{"$f":"SUM(B15:F15)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$93","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$93","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$93","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$93","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$93","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$93","v":0},0]
["Subject to OH",{"$f":"IF(B16>25000, 25000, B16)","v":0},{"$f":"IF(B16+C16>25000, 25000-B17, C16)","v":0},{"$f":"IF(B16+C16+D16>25000, 25000-(B17+C17), D16)","v":0},{"$f":"IF(B16+C16+D16+E16>25000, 25000-(B17+C17+D17), E16)","v":0},{"$f":"IF(B16+C16+D16+E16+F16>25000, 25000-(B17+C17+D17+E17), F16)","v":0},{"$f":"SUM(B17:F17)","v":0}]
["OH",{"$f":"IF(B16>25000,13125,(B16*0.525))","v":0},{"$f":"IF(C16+B16>25000,13125-B18,ROUND(C16*0.525,0))","v":0},{"$f":"IF(D16+C16+B16>25000,13125-(B18+C18),(D16*0.525))","v":0},{"$f":"IF(E16+D16+C16+B16>25000,13125-(B18+C18+D18),(E16*0.525))","v":0},{"$f":"IF(F16+E16+D16+C16+B16>25000,13125-(B18+C18+D18+E18),(F16*0.525))","v":0},{"$f":"SUM(B18:F18)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$94","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$94","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$94","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$94","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$94","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$94","v":0},{"$f":"SUM(B19:F19)","v":0}]
["Subject to OH",{"$f":"IF(B19>25000, 25000, B19)","v":0},{"$f":"IF(B19+C19>25000, 25000-B20, C19)","v":0},{"$f":"IF(B19+C19+D19>25000, 25000-(B20+C20), D19)","v":0},{"$f":"IF(B19+C19+D19+E19>25000, 25000-(B20+C20+D20), E19)","v":0},{"$f":"IF(B19+C19+D19+E19+F19>25000, 25000-(B20+C20+D20+E20), F19)","v":0},{"$f":"SUM(B20:F20)","v":0}]
["OH",{"$f":"IF(B19>25000,13125,(B19*0.525))","v":0},{"$f":"IF(C19+B19>25000,13125-B21,ROUND(C19*0.525,0))","v":0},{"$f":"IF(D19+C19+B19>25000,13125-(B21+C21),(D19*0.525))","v":0},{"$f":"IF(E19+D19+C19+B19>25000,13125-(B21+C21+D21),(E19*0.525))","v":0},{"$f":"IF(F19+E19+D19+C19+B19>25000,13125-(B21+C21+D21+E21),(F19*0.525))","v":0},{"$f":"SUM(B21:F21)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$95","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$95","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$95","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$95","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$95","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$95","v":0},0]
["Subject to OH",{"$f":"IF(B22>25000, 25000, B22)","v":0},{"$f":"IF(B22+C22>25000, 25000-B23, C22)","v":0},{"$f":"IF(B22+C22+D22>25000, 25000-(B23+C23), D22)","v":0},{"$f":"IF(B22+C22+D22+E22>25000, 25000-(B23+C23+D23), E22)","v":0},{"$f":"IF(B22+C22+D22+E22+F22>25000, 25000-(B23+C23+D23+E23), F22)","v":0},{"$f":"SUM(B23:F23)","v":0}]
["OH",{"$f":"IF(B22>25000,13125,(B22*0.525))","v":0},{"$f":"IF(C22+B22>25000,13125-B24,ROUND(C22*0.525,0))","v":0},{"$f":"IF(D22+C22+B22>25000,13125-(B24+C24),(D22*0.525))","v":0},{"$f":"IF(E22+D22+C22+B22>25000,13125-(B24+C24+D24),(E22*0.525))","v":0},{"$f":"IF(F22+E22+D22+C22+B22>25000,13125-(B24+C24+D24+E24),(F22*0.525))","v":0},{"$f":"SUM(B24:F24)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$96","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$96","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$96","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$96","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$96","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$96","v":0},0]
["Subject to OH",{"$f":"IF(B25>25000, 25000, B25)","v":0},{"$f":"IF(B25+C25>25000, 25000-B26, C25)","v":0},{"$f":"IF(B25+C25+D25>25000, 25000-(B26+C26), D25)","v":0},{"$f":"IF(B25+C25+D25+E25>25000, 25000-(B26+C26+D26), E25)","v":0},{"$f":"IF(B25+C25+D25+E25+F25>25000, 25000-(B26+C26+D26+E26), F25)","v":0},{"$f":"SUM(B26:F26)","v":0}]
["OH",{"$f":"IF(B25>25000,13125,(B25*0.525))","v":0},{"$f":"IF(C25+B25>25000,13125-B27,ROUND(C25*0.525,0))","v":0},{"$f":"IF(D25+C25+B25>25000,13125-(B27+C27),(D25*0.525))","v":0},{"$f":"IF(E25+D25+C25+B25>25000,13125-(B27+C27+D27),(E25*0.525))","v":0},{"$f":"IF(F25+E25+D25+C25+B25>25000,13125-(B27+C27+D27+E27),(F25*0.525))","v":0},{"$f":"SUM(B27:F27)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$97","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$97","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$97","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$97","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$97","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$97","v":0},0]
["Subject to OH",{"$f":"IF(B28>25000, 25000, B28)","v":0},{"$f":"IF(B28+C28>25000, 25000-B29, C28)","v":0},{"$f":"IF(B28+C28+D28>25000, 25000-(B29+C29), D28)","v":0},{"$f":"IF(B28+C28+D28+E28>25000, 25000-(B29+C29+D29), E28)","v":0},{"$f":"IF(B28+C28+D28+E28+F28>25000, 25000-(B29+C29+D29+E29), F28)","v":0},{"$f":"SUM(B29:F29)","v":0}]
["OH",{"$f":"IF(B28>25000,13125,(B28*0.525))","v":0},{"$f":"IF(C28+B28>25000,13125-B30,ROUND(C28*0.525,0))","v":0},{"$f":"IF(D28+C28+B28>25000,13125-(B30+C30),(D28*0.525))","v":0},{"$f":"IF(E28+D28+C28+B28>25000,13125-(B30+C30+D30),(E28*0.525))","v":0},{"$f":"IF(F28+E28+D28+C28+B28>25000,13125-(B30+C30+D30+E30),(F28*0.525))","v":0},{"$f":"SUM(B30:F30)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$98","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$98","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$98","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$98","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$98","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$98","v":0},0]
["Subject to OH",{"$f":"IF(B31>25000, 25000, B31)","v":0},{"$f":"IF(B31+C31>25000, 25000-B32, C31)","v":0},{"$f":"IF(B31+C31+D31>25000, 25000-(B32+C32), D31)","v":0},{"$f":"IF(B31+C31+D31+E31>25000, 25000-(B32+C32+D32), E31)","v":0},{"$f":"IF(B31+C31+D31+E31+F31>25000, 25000-(B32+C32+D32+E32), F31)","v":0},{"$f":"SUM(B32:F32)","v":0}]
["OH",{"$f":"IF(B31>25000,13125,(B31*0.525))","v":0},{"$f":"IF(C31+B31>25000,13125-B33,ROUND(C31*0.525,0))","v":0},{"$f":"IF(D31+C31+B31>25000,13125-(B33+C33),(D31*0.525))","v":0},{"$f":"IF(E31+D31+C31+B31>25000,13125-(B33+C33+D33),(E31*0.525))","v":0},{"$f":"IF(F31+E31+D31+C31+B31>25000,13125-(B33+C33+D33+E33),(F31*0.525))","v":0},{"$f":"SUM(B33:F33)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$99","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$99","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$99","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$99","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$99","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$99","v":0},0]
["Subject to OH",{"$f":"IF(B34>25000, 25000, B34)","v":0},{"$f":"IF(B34+C34>25000, 25000-B35, C34)","v":0},{"$f":"IF(B34+C34+D34>25000, 25000-(B35+C35), D34)","v":0},{"$f":"IF(B34+C34+D34+E34>25000, 25000-(B35+C35+D35), E34)","v":0},{"$f":"IF(B34+C34+D34+E34+F34>25000, 25000-(B35+C35+D35+E35), F34)","v":0},{"$f":"SUM(B35:F35)","v":0}]
["OH",{"$f":"IF(B34>25000,13125,(B34*0.525))","v":0},{"$f":"IF(C34+B34>25000,13125-B36,ROUND(C34*0.525,0))","v":0},{"$f":"IF(D34+C34+B34>25000,13125-(B36+C36),(D34*0.525))","v":0},{"$f":"IF(E34+D34+C34+B34>25000,13125-(B36+C36+D36),(E34*0.525))","v":0},{"$f":"IF(F34+E34+D34+C34+B34>25000,13125-(B36+C36+D36+E36),(F34*0.525))","v":0},{"$f":"SUM(B36:F36)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$100","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$100","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$100","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$100","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$100","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$100","v":0},0]
["Subject to OH",{"$f":"IF(B37>25000, 25000, B37)","v":0},{"$f":"IF(B37+C37>25000, 25000-B38, C37)","v":0},{"$f":"IF(B37+C37+D37>25000, 25000-(B38+C38), D37)","v":0},{"$f":"IF(B37+C37+D37+E37>25000, 25000-(B38+C38+D38), E37)","v":0},{"$f":"IF(B37+C37+D37+E37+F37>25000, 25000-(B38+C38+D38+E38), F37)","v":0},{"$f":"SUM(B38:F38)","v":0}]
["OH",{"$f":"IF(B37>25000,13125,(B37*0.525))","v":0},{"$f":"IF(C37+B37>25000,13125-B39,ROUND(C37*0.525,0))","v":0},{"$f":"IF(D37+C37+B37>25000,13125-(B39+C39),(D37*0.525))","v":0},{"$f":"IF(E37+D37+C37+B37>25000,13125-(B39+C39+D39),(E37*0.525))","v":0},{"$f":"IF(F37+E37+D37+C37+B37>25000,13125-(B39+C39+D39+E39),(F37*0.525))","v":0},{"$f":"SUM(B39:F39)","v":0}]
[{"$f":"'Y8 New Activities 100k Request'!$A$101","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$101","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$101","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$101","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$101","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$101","v":0},{"$f":"SUM(B40:F40)","v":0}]
["Subject to OH",{"$f":"IF(B40>25000, 25000, B40)","v":0},{"$f":"IF(B40+C40>25000, 25000-B41, C40)","v":0},{"$f":"IF(B40+C40+D40>25000, 25000-(B41+C41), D40)","v":0},{"$f":"IF(B40+C40+D40+E40>25000, 25000-(B41+C41+D41), E40)","v":0},{"$f":"IF(B40+C40+D40+E40+F40>25000, 25000-(B41+C41+D41+E41), F40)","v":0},{"$f":"SUM(B41:F41)","v":0}]
["OH",{"$f":"IF(B40>25000,13125,(B40*0.525))","v":0},{"$f":"IF(C40+B40>25000,13125-B42,ROUND(C40*0.525,0))","v":0},{"$f":"IF(D40+C40+B40>25000,13125-(B42+C42),(D40*0.525))","v":0},{"$f":"IF(E40+D40+C40+B40>25000,13125-(B42+C42+D42),(E40*0.525))","v":0},{"$f":"IF(F40+E40+D40+C40+B40>25000,13125-(B42+C42+D42+E42),(F40*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$102","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$102","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$102","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$102","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$102","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$102","v":0},0]
["Subject to OH",{"$f":"IF(B43>25000, 25000, B43)","v":0},{"$f":"IF(B43+C43>25000, 25000-B44, C43)","v":0},{"$f":"IF(B43+C43+D43>25000, 25000-(B44+C44), D43)","v":0},{"$f":"IF(B43+C43+D43+E43>25000, 25000-(B44+C44+D44), E43)","v":0},{"$f":"IF(B43+C43+D43+E43+F43>25000, 25000-(B44+C44+D44+E44), F43)","v":0},{"$f":"SUM(B44:F44)","v":0}]
["OH",{"$f":"IF(B43>25000,13125,(B43*0.525))","v":0},{"$f":"IF(C43+B43>25000,13125-B45,ROUND(C43*0.525,0))","v":0},{"$f":"IF(D43+C43+B43>25000,13125-(B45+C45),(D43*0.525))","v":0},{"$f":"IF(E43+D43+C43+B43>25000,13125-(B45+C45+D45),(E43*0.525))","v":0},{"$f":"IF(F43+E43+D43+C43+B43>25000,13125-(B45+C45+D45+E45),(F43*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$103","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$103","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$103","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$103","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$103","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$103","v":0},0]
["Subject to OH",{"$f":"IF(B46>25000, 25000, B46)","v":0},{"$f":"IF(B46+C46>25000, 25000-B47, C46)","v":0},{"$f":"IF(B46+C46+D46>25000, 25000-(B47+C47), D46)","v":0},{"$f":"IF(B46+C46+D46+E46>25000, 25000-(B47+C47+D47), E46)","v":0},{"$f":"IF(B46+C46+D46+E46+F46>25000, 25000-(B47+C47+D47+E47), F46)","v":0},{"$f":"SUM(B47:F47)","v":0}]
["OH",{"$f":"IF(B46>25000,13125,(B46*0.525))","v":0},{"$f":"IF(C46+B46>25000,13125-B48,ROUND(C46*0.525,0))","v":0},{"$f":"IF(D46+C46+B46>25000,13125-(B48+C48),(D46*0.525))","v":0},{"$f":"IF(E46+D46+C46+B46>25000,13125-(B48+C48+D48),(E46*0.525))","v":0},{"$f":"IF(F46+E46+D46+C46+B46>25000,13125-(B48+C48+D48+E48),(F46*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$104","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$104","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$104","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$104","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$104","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$104","v":0},{"$f":"SUM(B49:F49)","v":0}]
["Subject to OH",{"$f":"IF(B49>25000, 25000, B49)","v":0},{"$f":"IF(B49+C49>25000, 25000-B50, C49)","v":0},{"$f":"IF(B49+C49+D49>25000, 25000-(B50+C50), D49)","v":0},{"$f":"IF(B49+C49+D49+E49>25000, 25000-(B50+C50+D50), E49)","v":0},{"$f":"IF(B49+C49+D49+E49+F49>25000, 25000-(B50+C50+D50+E50), F49)","v":0},{"$f":"SUM(B50:F50)","v":0}]
["OH",{"$f":"IF(B49>25000,13125,(B49*0.525))","v":0},{"$f":"IF(C49+B49>25000,13125-B51,ROUND(C49*0.525,0))","v":0},{"$f":"IF(D49+C49+B49>25000,13125-(B51+C51),(D49*0.525))","v":0},{"$f":"IF(E49+D49+C49+B49>25000,13125-(B51+C51+D51),(E49*0.525))","v":0},{"$f":"IF(F49+E49+D49+C49+B49>25000,13125-(B51+C51+D51+E51),(F49*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$105","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$105","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$105","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$105","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$105","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$105","v":0},0]
["Subject to OH",{"$f":"IF(B52>25000, 25000, B52)","v":0},{"$f":"IF(B52+C52>25000, 25000-B53, C52)","v":0},{"$f":"IF(B52+C52+D52>25000, 25000-(B53+C53), D52)","v":0},{"$f":"IF(B52+C52+D52+E52>25000, 25000-(B53+C53+D53), E52)","v":0},{"$f":"IF(B52+C52+D52+E52+F52>25000, 25000-(B53+C53+D53+E53), F52)","v":0},{"$f":"SUM(B53:F53)","v":0}]
["OH",{"$f":"IF(B52>25000,13125,(B52*0.525))","v":0},{"$f":"IF(C52+B52>25000,13125-B54,ROUND(C52*0.525,0))","v":0},{"$f":"IF(D52+C52+B52>25000,13125-(B54+C54),(D52*0.525))","v":0},{"$f":"IF(E52+D52+C52+B52>25000,13125-(B54+C54+D54),(E52*0.525))","v":0},{"$f":"IF(F52+E52+D52+C52+B52>25000,13125-(B54+C54+D54+E54),(F52*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$106","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$106","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$106","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$106","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$106","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$106","v":0},0]
["Subject to OH",{"$f":"IF(B55>25000, 25000, B55)","v":0},{"$f":"IF(B55+C55>25000, 25000-B56, C55)","v":0},{"$f":"IF(B55+C55+D55>25000, 25000-(B56+C56), D55)","v":0},{"$f":"IF(B55+C55+D55+E55>25000, 25000-(B56+C56+D56), E55)","v":0},{"$f":"IF(B55+C55+D55+E55+F55>25000, 25000-(B56+C56+D56+E56), F55)","v":0},{"$f":"SUM(B56:F56)","v":0}]
["OH",{"$f":"IF(B55>25000,13125,(B55*0.525))","v":0},{"$f":"IF(C55+B55>25000,13125-B57,ROUND(C55*0.525,0))","v":0},{"$f":"IF(D55+C55+B55>25000,13125-(B57+C57),(D55*0.525))","v":0},{"$f":"IF(E55+D55+C55+B55>25000,13125-(B57+C57+D57),(E55*0.525))","v":0},{"$f":"IF(F55+E55+D55+C55+B55>25000,13125-(B57+C57+D57+E57),(F55*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$107","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$107","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$107","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$107","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$107","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$107","v":0},0]
["Subject to OH",{"$f":"IF(B58>25000, 25000, B58)","v":0},{"$f":"IF(B58+C58>25000, 25000-B59, C58)","v":0},{"$f":"IF(B58+C58+D58>25000, 25000-(B59+C59), D58)","v":0},{"$f":"IF(B58+C58+D58+E58>25000, 25000-(B59+C59+D59), E58)","v":0},{"$f":"IF(B58+C58+D58+E58+F58>25000, 25000-(B59+C59+D59+E59), F58)","v":0},{"$f":"SUM(B59:F59)","v":0}]
["OH",{"$f":"IF(B58>25000,13125,(B58*0.525))","v":0},{"$f":"IF(C58+B58>25000,13125-B60,ROUND(C58*0.525,0))","v":0},{"$f":"IF(D58+C58+B58>25000,13125-(B60+C60),(D58*0.525))","v":0},{"$f":"IF(E58+D58+C58+B58>25000,13125-(B60+C60+D60),(E58*0.525))","v":0},{"$f":"IF(F58+E58+D58+C58+B58>25000,13125-(B60+C60+D60+E60),(F58*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$108","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$108","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$108","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$108","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$108","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$108","v":0},0]
["Subject to OH",{"$f":"IF(B61>25000, 25000, B61)","v":0},{"$f":"IF(B61+C61>25000, 25000-B62, C61)","v":0},{"$f":"IF(B61+C61+D61>25000, 25000-(B62+C62), D61)","v":0},{"$f":"IF(B61+C61+D61+E61>25000, 25000-(B62+C62+D62), E61)","v":0},{"$f":"IF(B61+C61+D61+E61+F61>25000, 25000-(B62+C62+D62+E62), F61)","v":0},{"$f":"SUM(B62:F62)","v":0}]
["OH",{"$f":"IF(B61>25000,13125,(B61*0.525))","v":0},{"$f":"IF(C61+B61>25000,13125-B63,ROUND(C61*0.525,0))","v":0},{"$f":"IF(D61+C61+B61>25000,13125-(B63+C63),(D61*0.525))","v":0},{"$f":"IF(E61+D61+C61+B61>25000,13125-(B63+C63+D63),(E61*0.525))","v":0},{"$f":"IF(F61+E61+D61+C61+B61>25000,13125-(B63+C63+D63+E63),(F61*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$109","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$109","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$109","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$109","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$109","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$109","v":0},0]
["Subject to OH",{"$f":"IF(B64>25000, 25000, B64)","v":0},{"$f":"IF(B64+C64>25000, 25000-B65, C64)","v":0},{"$f":"IF(B64+C64+D64>25000, 25000-(B65+C65), D64)","v":0},{"$f":"IF(B64+C64+D64+E64>25000, 25000-(B65+C65+D65), E64)","v":0},{"$f":"IF(B64+C64+D64+E64+F64>25000, 25000-(B65+C65+D65+E65), F64)","v":0},{"$f":"SUM(B65:F65)","v":0}]
["OH",{"$f":"IF(B64>25000,13125,(B64*0.525))","v":0},{"$f":"IF(C64+B64>25000,13125-B66,ROUND(C64*0.525,0))","v":0},{"$f":"IF(D64+C64+B64>25000,13125-(B66+C66),(D64*0.525))","v":0},{"$f":"IF(E64+D64+C64+B64>25000,13125-(B66+C66+D66),(E64*0.525))","v":0},{"$f":"IF(F64+E64+D64+C64+B64>25000,13125-(B66+C66+D66+E66),(F64*0.525))","v":0},0]
[{"$f":"'Y8 New Activities 100k Request'!$A$110","v":0},{"$f":"'Y8 New Activities 100k Request'!$D$110","v":0},{"$f":"'Y8 New Activities 100k Request'!$F$110","v":0},{"$f":"'Y8 New Activities 100k Request'!$H$110","v":0},{"$f":"'Y8 New Activities 100k Request'!$J$110","v":0},{"$f":"'Y8 New Activities 100k Request'!$L$110","v":0},0]
["Subject to OH",{"$f":"IF(B67>25000, 25000, B67)","v":0},{"$f":"IF(B67+C67>25000, 25000-B68, C67)","v":0},{"$f":"IF(B67+C67+D67>25000, 25000-(B68+C68), D67)","v":0},{"$f":"IF(B67+C67+D67+E67>25000, 25000-(B68+C68+D68), E67)","v":0},{"$f":"IF(B67+C67+D67+E67+F67>25000, 25000-(B68+C68+D68+E68), F67)","v":0},{"$f":"SUM(B68:F68)","v":0}]
["OH",{"$f":"IF(B67>25000,13125,(B67*0.525))","v":0},{"$f":"IF(C67+B67>25000,13125-B69,ROUND(C67*0.525,0))","v":0},{"$f":"IF(D67+C67+B67>25000,13125-(B69+C69),(D67*0.525))","v":0},{"$f":"IF(E67+D67+C67+B67>25000,13125-(B69+C69+D69),(E67*0.525))","v":0},{"$f":"IF(F67+E67+D67+C67+B67>25000,13125-(B69+C69+D69+E69),(F67*0.525))","v":0},0]
["Total Subawards",{"$f":"SUM(B67,B64, B61, B58,B55,B52,B49,B46,B43,B40,B37,B34,B31,B28,B25,B22,B19,B16,B13,B10,B7,B4)","v":0},{"$f":"SUM(C67,C64, C61, C58,C55,C52,C49,C46,C43,C40,C37,C34,C31,C28,C25,C22,C19,C16,C13,C10,C7,C4)","v":0},{"$f":"SUM(D67,D64, D61, D58,D55,D52,D49,D46,D43,D40,D37,D34,D31,D28,D25,D22,D19,D16,D13,D10,D7,D4)","v":0},{"$f":"SUM(E67,E64, E61, E58,E55,E52,E49,E46,E43,E40,E37,E34,E31,E28,E25,E22,E19,E16,E13,E10,E7,E4)","v":0},{"$f":"SUM(F67,F64, F61, F58,F55,F52,F49,F46,F43,F40,F37,F34,F31,F28,F25,F22,F19,F16,F13,F10,F7,F4)","v":0},{"$f":"SUM(B70:F70)","v":0}]
["Total Subject to OH",{"$f":"SUM(B68,B65,B62,B59,B56,B53,B50,B47,B44,B41,B38,B35,B32,B29,B26,B23,B20,B17,B14,B11,B8,B5)","v":0},0,0,0,0,{"$f":"SUM(B71:F71)","v":0}]
["Total Overhead",0,0,0,0,0,{"$f":"SUM(G69,G66,G63,G60,G57,G54,G51,G48,G45,G42,G39,G36,G33,G30,G27,G24,G21,G18,G15,G12,G9,G6)","v":0}]
[]
["pw: edit"]

{"sheet":"Projected Ship Rates","index":4,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Asset",2020,2021,2022,2023,2024,2025,2026]
["Rachel Carson",13385,11500,11900,12300,12700,13100]
["Rachel Carson 12",14660,12500,12900,13400,13800,14200]
["Ventana",6400,5000,5200,5400,5600,5800]
["Western Flyer with Ricketts",33000,33990,35009.700000000004,"N/A","N/A","N/A"]
["AUV",12745,13100,13500,13900,14300,14775]
["Paragon",500,515,530,545,560,580]
[]
[]
[]
[]
["Carson w Ventana",{"$f":"B3+B4","v":21060},17500,18100,18800,19400,20000]
[null,null," "]