{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BudgetWorksheet","Salary Worksheet","Subaward Worksheet","Ship rates"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":15,"comments":2,"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":"BudgetWorksheet","index":0,"n_rows":109,"n_cols":13,"rows_kept":109,"cut":false,"hidden":false,"merged":[[103,0,103,1],[0,0,0,4],[68,0,68,1],[34,0,34,1],[46,0,46,1],[56,0,56,1],[72,0,72,1],[77,0,77,1],[97,0,97,1],[90,0,90,1],[89,0,89,1],[2,2,2,3],[2,4,2,5],[88,0,88,1],[2,0,2,1],[1,2,1,3],[106,0,106,2],[32,0,32,1],[33,0,33,1],[25,0,25,1],[8,0,8,1],[45,0,45,1],[26,0,26,1],[49,0,49,1],[55,0,55,1],[67,0,67,1],[71,0,71,1],[76,0,76,1],[50,0,50,1],[14,0,14,1],[96,0,96,1],[100,0,100,1],[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]]}
["Etchemendy NSF MARS Renewal ",null,null,null,null,null,null,null,null,null,null,"Updated:",{"$f":"TODAY()","v":"2014-12-05"}]
[null,null,"Year1",null,"Year 2 ",null,"Year 3 ",null,"Year 4",null,"Year 5"]
["TOTAL",null,{"$f":"D109","v":522321.50439999998},null,{"$f":"F109","v":315500.21999999997},null,{"$f":"H109","v":379636.79000000004},null,{"$f":"J109","v":332199.05480000004},null,{"$f":"L109","v":594759.26040000003},null,{"$f":"M109","v":2144416.8295999998}]
["SALARY/WAGES",null,2,"Y1",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"MONTHS"},"Y2",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"MONTHS"},"Y3",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"MONTHS"},"Y4",{"$f":"IF($C$4=1, \"HOURS\", \"MONTHS\")","v":"MONTHS"},"Y5","Total"]
[]
[{"$f":"'Salary Worksheet'!B4","v":"Etchemendy"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D13*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":0},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":0}]
[{"$f":"'Salary Worksheet'!B5","v":"Dawe"},null,2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D14*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":25989.99},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E14*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":26769.67},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F14*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":27573},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G14*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":28400},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H14*K7,2), ROUND('Salary Worksheet'!H5/12*K7,0))","v":29252},{"$f":"SUM(J7+H7+F7+D7+L7)","v":137984.66}]
[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":25989.99},null,{"$f":"SUM(F6:F8)","v":26769.67},null,{"$f":"SUM(H6:H8)","v":27573},null,{"$f":"SUM(J6:J8)","v":28400},null,{"$f":"SUM(L6:L8)","v":29252},{"$f":"SUM(J9+H9+F9+D9+L9)","v":137984.66}]
[{"$f":"'Salary Worksheet'!B7","v":"Ken Heller"},null,12,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D16*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":62225},12,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E16*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":64092},12,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F16*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":66015},12,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G16*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":67995},12,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H16*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":70035},{"$f":"SUM(L10+J10+H10+F10+D10)","v":330362}]
[{"$f":"'Salary Worksheet'!B8","v":"Maughan/McGill"},null,3,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D17*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":40629},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E17*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F17*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G17*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H17*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":0},{"$f":"SUM(L11+J11+H11+F11+D11)","v":40629}]
[{"$f":"'Salary Worksheet'!B9","v":"Enginnering Support "},null,1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D18*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":10983},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":11312.83},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":11652.25},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":12001.83},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":12361.92},{"$f":"SUM(L12+J12+H12+F12+D12)","v":58311.83}]
[{"$f":"'Salary Worksheet'!B10","v":"Linda Kuhnz"},null,1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":6865},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":0},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":15453.17},{"$f":"SUM(L13+J13+H13+F13+D13)","v":22318.17}]
[]
["Subtotal Other Employee Salary",null,null,{"$f":"SUM(D10:D14)","v":120702},null,{"$f":"SUM(F10:F14)","v":75404.83},null,{"$f":"SUM(H10:H14)","v":77667.25},null,{"$f":"SUM(J10:J14)","v":79996.83},null,{"$f":"SUM(L10:L14)","v":97850.09},{"$f":"SUM(J15+H15+F15+D15+L15)","v":451621}]
["POSTDOCS, GSRs, PART-TIME, TEMPS"]
["To calculate labor costs for Postdocs and GSRs, enter months of effort below; salary will calculate automatically based on MBARI rates."]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C18,2), ROUND('Salary Worksheet'!D22/12*C18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E18,2), ROUND('Salary Worksheet'!E22/12*E18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G18,2), ROUND('Salary Worksheet'!F22/12*G18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I18,2), ROUND('Salary Worksheet'!G22/12*I18,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K18,2), ROUND('Salary Worksheet'!H22/12*K18,0))","v":0},{"$f":"SUM(J18+H18+F18+D18+L18)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C19,2), ROUND('Salary Worksheet'!D24/12*C19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E19,2), ROUND('Salary Worksheet'!E24/12*E19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G19,2), ROUND('Salary Worksheet'!F24/12*G19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I19,2), ROUND('Salary Worksheet'!G24/12*I19,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K19,2), ROUND('Salary Worksheet'!H24/12*K19,0))","v":0},0]
["Part-time (30-39 hrs/wk) 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E38*C20,2), ROUND('Salary Worksheet'!E31/12*C20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F38*E20,2), ROUND('Salary Worksheet'!F31/12*E20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G38*G20,2), ROUND('Salary Worksheet'!G31/12*G20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H38*I20,2), ROUND('Salary Worksheet'!H31/12*I20,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I38*K20,2), ROUND('Salary Worksheet'!I31/12*K20,0))","v":0},0]
["Part-time (30-39 hrs/wk) 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E39*C21,2), ROUND('Salary Worksheet'!E32/12*C21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F39*E21,2), ROUND('Salary Worksheet'!F32/12*E21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G39*G21,2), ROUND('Salary Worksheet'!G32/12*G21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H39*I21,2), ROUND('Salary Worksheet'!H32/12*I21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I39*K21,2), ROUND('Salary Worksheet'!I32/12*K21,0))","v":0},{"$f":"SUM(J21+H21+F21+D21+L21)","v":0}]
["Part-time (<= 29 hrs/wk) 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E40*C22,2), ROUND('Salary Worksheet'!E33/12*C22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F40*E22,2), ROUND('Salary Worksheet'!F33/12*E22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G40*G22,2), ROUND('Salary Worksheet'!G33/12*G22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H40*I22,2), ROUND('Salary Worksheet'!H33/12*I22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I40*K22,2), ROUND('Salary Worksheet'!I33/12*K22,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E41*C23,2), ROUND('Salary Worksheet'!E34/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F41*E23,2), ROUND('Salary Worksheet'!F34/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G41*G23,2), ROUND('Salary Worksheet'!G34/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H41*I23,2), ROUND('Salary Worksheet'!H34/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I41*K23,2), ROUND('Salary Worksheet'!I34/12*K23,0))","v":0},{"$f":"SUM(J23+H23+F23+D23+L23)","v":0}]
["Temporary Employee 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E42*C24,2), ROUND('Salary Worksheet'!E35/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F42*E24,2), ROUND('Salary Worksheet'!F35/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G42*G24,2), ROUND('Salary Worksheet'!G35/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H42*I24,2), ROUND('Salary Worksheet'!H35/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I42*K24,2), ROUND('Salary Worksheet'!I35/12*K24,0))","v":0},0]
["Temporary Employee 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E43*C25,2), ROUND('Salary Worksheet'!E36/12*C25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F43*E25,2), ROUND('Salary Worksheet'!F36/12*E25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G43*G25,2), ROUND('Salary Worksheet'!G36/12*G25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H43*I25,2), ROUND('Salary Worksheet'!H36/12*I25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I43*K25,2), ROUND('Salary Worksheet'!I36/12*K25,0))","v":0},{"$f":"SUM(J25+H25+F25+D25+L25)","v":0}]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D15:D24)","v":120702},null,{"$f":"SUM(F15:F24)","v":75404.83},null,{"$f":"SUM(H15:H24)","v":77667.25},null,{"$f":"SUM(J15:J24)","v":79996.83},null,{"$f":"SUM(L15:L24)","v":97850.09},451621]
["Total Salary & Wages",null,null,{"$f":"SUM(D26+D9)","v":146691.99},null,{"$f":"SUM(F26+F9)","v":102174.5},null,{"$f":"SUM(H26+H9)","v":105240.25},null,{"$f":"SUM(J26+J9)","v":108396.83},null,{"$f":"SUM(L26+L9)","v":127102.09},589605.66]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.56000000000000005,null,{"$f":"((D9+D15)*$B$29)","v":82147.5144},null,{"$f":"((F9+F15)*$B$29)","v":57217.720000000008},null,{"$f":"((H9+H15)*$B$29)","v":58934.540000000008},null,{"$f":"((J9+J15)*$B$29)","v":60702.224800000004},null,{"$f":"((L9+L15)*$B$29)","v":71177.170400000003},{"$f":"SUM(J29+H29+F29+D29+L29)","v":330179.16960000002}]
["PostDoc",0.46,null,{"$f":"D18*$B$30","v":0},null,{"$f":"F18*$B$30","v":0},null,{"$f":"H18*$B$30","v":0},null,{"$f":"J18*$B$30","v":0},null,{"$f":"L18*$B$30","v":0},0]
["GSRs + PT (20-29 hrs)",0.32,null,{"$f":"(SUM(D19,D22,D23))*$B$31","v":0},null,{"$f":"(SUM(F19,F22,F23))*$B$31","v":0},null,{"$f":"(SUM(H19,H22,H23))*$B$31","v":0},null,{"$f":"(SUM(J19,J22,J23))*$B$31","v":0},null,{"$f":"(SUM(L19,L22,L23))*$B$31","v":0},0]
["Temp",0.12,null,{"$f":"(D24+D25)*$B$32","v":0},null,{"$f":"(F24+F25)*$B$32","v":0},null,{"$f":"(H24+H25)*$B$32","v":0},null,{"$f":"(J24+J25)*$B$32","v":0},null,{"$f":"(L24+L25)*$B$32","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D29:D32)","v":82147.5144},null,{"$f":"SUM(F29:F32)","v":57217.720000000008},null,{"$f":"SUM(H29:H32)","v":58934.540000000008},null,{"$f":"SUM(J29:J32)","v":60702.224800000004},null,{"$f":"SUM(L29:L32)","v":71177.170400000003},330179.16960000002]
["Total Salary & Benefits",null,null,{"$f":"SUM(D33,D27)","v":228839.50439999998},null,{"$f":"SUM(F33,F27)","v":159392.22},null,{"$f":"SUM(H33,H27)","v":164174.79},null,{"$f":"SUM(J33,J27)","v":169099.05480000001},null,{"$f":"SUM(L33,L27)","v":198279.2604},919784.82960000006]
["CAPITAL EQUIPMENT  (items >$5K)"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J36+H36+F36+D36+L36)","v":0}]
["computer equipment (routers)",null,null,16000,null,0,null,16000,null,8000,null,0,{"$f":"SUM(J37+H37+F37+D37+L37)","v":40000}]
["equipment ODI connectors",null,null,null,null,18000,null,null,null,9000,null,null,27000]
["Item 4",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 5",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 6",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 7",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 8",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 9",null,null,null,null,null,null,null,null,null,null,null,0]
["Item 10",null,null,null,null,null,null,null,null,null,null,null,0]
["Total Equipment",null,null,{"$f":"SUM(D36:D45)","v":16000},null,{"$f":"SUM(F36:F45)","v":18000},null,{"$f":"SUM(H36:H45)","v":16000},null,{"$f":"SUM(J36:J45)","v":17000},null,{"$f":"SUM(L36:L45)","v":0},{"$f":"SUM(L46,J46,H46,F46,D46)","v":67000}]
["TRAVEL"]
["Travel - Domestic",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L48,J48,H48,F48,D48)","v":0}]
["Travel - Domestic",null,null,1000,null,1000,null,1000,null,1000,null,1000,{"$f":"SUM(L49,J49,H49,F49,D49)","v":5000}]
["Total Travel",null,null,{"$f":"SUM(D48:D49)","v":1000},null,{"$f":"SUM(F48:F49)","v":1000},null,{"$f":"SUM(H48:H49)","v":1000},null,{"$f":"SUM(J48:J49)","v":1000},null,{"$f":"SUM(L48:L49)","v":1000},{"$f":"SUM(L50,J50,H50,F50,D50)","v":5000}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L52,J52,H52,F52,D52)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L53,J53,H53,F53,D53)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,J55,H55,F55,D55)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D52:D55)","v":0},null,{"$f":"SUM(F52:F55)","v":0},null,{"$f":"SUM(H52:H55)","v":0},null,{"$f":"SUM(J52:J55)","v":0},null,{"$f":"SUM(L52:L55)","v":0},{"$f":"SUM(L56,J56,H56,F56,D56)","v":0}]
["MATERIALS & SUPPLIES"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["computer hardware",null,null,750,null,750,null,750,null,750,null,750,{"$f":"SUM(L59,J59,H59,F59,D59)","v":3750}]
["computer software",null,null,200,null,200,null,200,null,200,null,200,1000]
["non-cap equipment",null,null,4500,null,4500,null,4500,null,4500,null,4500,22500]
["general MARS supplies including bio survey ",null,null,5000,null,2000,null,17000,null,2000,null,2000,28000]
[]
[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(D58:D67)","v":10450},null,{"$f":"SUM(F58:F67)","v":7450},null,{"$f":"SUM(H58:H67)","v":22450},null,{"$f":"SUM(J58:J67)","v":7450},null,{"$f":"SUM(L58:L67)","v":7450},{"$f":"SUM(L68,J68,H68,F68,D68)","v":55250}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L70,J70,H70,F70,D70)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L71,J71,H71,F71,D71)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D70)","v":0},null,{"$f":"SUM(F70)","v":0},null,{"$f":"SUM(H70:H70)","v":0},null,{"$f":"SUM(J70:J70)","v":0},null,{"$f":"SUM(L70:L70)","v":0},{"$f":"SUM(L72,J72,H72,F72,D72)","v":0}]
["OUTSIDE SERVICES"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L74,J74,H74,F74,D74)","v":0}]
["Biological Survey ",null,null,22980,null,null,null,null,null,null,null,null,{"$f":"SUM(L75,J75,H75,F75,D75)","v":22980}]
["Normal MARS operation services",null,null,6280,null,6468,null,6663,null,7171,null,30151,{"$f":"SUM(L76,J76,H76,F76,D76)","v":56733}]
["Total Outside Services",null,null,{"$f":"SUM(D74:D76)","v":29260},null,{"$f":"SUM(F74:F76)","v":6468},null,{"$f":"SUM(H74:H76)","v":6663},null,{"$f":"SUM(J74:J76)","v":7171},null,{"$f":"SUM(L74:L76)","v":30151},{"$f":"SUM(L77,J77,H77,F77,D77)","v":79713}]
["SUBAWARDS"]
["Subaward 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L79,J79,H79,F79,D79)","v":0}]
["Subaward 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L80,J80,H80,F80,D80)","v":0}]
["Subaward 3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L81,J81,H81,F81,D81)","v":0}]
["Subaward 4",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 5",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 6",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 7",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 8",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 9",null,null,null,null,null,null,null,null,null,null,null,0]
["Subaward 10",null,null,null,null,null,null,null,null,null,null,null,0]
["Total Subawards",null,null,{"$f":"SUM(D79:D88)","v":0},null,{"$f":"SUM(F79:F88)","v":0},null,{"$f":"SUM(H79:H88)","v":0},null,{"$f":"SUM(J79:J88)","v":0},null,{"$f":"SUM(L79:L88)","v":0},{"$f":"SUM(L89,J89,H89,F89,D89)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B35","v":0},null,{"$f":"'Subaward Worksheet'!C35","v":0},null,{"$f":"'Subaward Worksheet'!D35","v":0},null,{"$f":"'Subaward Worksheet'!E35","v":0},null,{"$f":"'Subaward Worksheet'!F35","v":0}]
["OH on Subawards",null,null,{"$f":"'Subaward Worksheet'!$B$36","v":0},null,{"$f":"'Subaward Worksheet'!$C$36","v":0},null,{"$f":"'Subaward Worksheet'!$D$36","v":0},null,{"$f":"'Subaward Worksheet'!$E$36","v":0},null,{"$f":"'Subaward Worksheet'!$F$36","v":0},{"$f":"SUM(L91,J91,H91,F91,D91)","v":0}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
["none",{"$f":"INDEX('Ship rates'!A1:B13, MATCH(A93, ShipRates,0 ), 2)","v":0},0,{"$f":"B93*C93","v":0},null,{"$f":"29500*E93","v":0},null,{"$f":"29500*G93","v":0},null,{"$f":"29500*I93","v":0},null,{"$f":"29500*K93","v":0},{"$f":"SUM(L93,J93,H93,F93,D93)","v":0}]
["Western Flyer w/ Doc Ricketts, 24hr",{"$f":"INDEX('Ship rates'!A1:B13, MATCH(A94, ShipRates,0 ), 2)","v":28100},0,{"$f":"B94*C94","v":0},0,{"$f":"B94*E94*1.03","v":0},0,{"$f":"B94*G94*1.03","v":0},0,{"$f":"B94*I94*1.03","v":0},4,{"$f":"B94*K94*1.12","v":125888.00000000001},{"$f":"SUM(L94,J94,H94,F94,D94)","v":125888.00000000001}]
["Rachel Carson w/ Ventana, 12 hr",16500,6,{"$f":"B95*C95","v":99000},2,{"$f":"B95*E95*1.03","v":33990},4,{"$f":"B95*G95*1.06","v":69960},2,{"$f":"B95*I95*1.09","v":35970},6,{"$f":"B95*K95*1.12","v":110880.00000000001},{"$f":"SUM(L95,J95,H95,F95,D95)","v":349800}]
[null,null,null,{"$f":"B96*C96","v":0},null,{"$f":"B96*E96","v":0},null,{"$f":"B96*G96","v":0},null,{"$f":"B96*I96","v":0},null,{"$f":"B96*K96","v":0},{"$f":"SUM(L96,J96,H96,F96,D96)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D93:D96)","v":99000},null,{"$f":"SUM(F93:F95)","v":33990},null,{"$f":"SUM(H93:H95)","v":69960},null,{"$f":"SUM(J93:J95)","v":35970},null,{"$f":"SUM(L93:L95)","v":236768.00000000003},{"$f":"SUM(L97,J97,H97,F97,D97)","v":475688}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,0,{"$f":"(C99*'Salary Worksheet'!D26)","v":0},0,{"$f":"(E99*'Salary Worksheet'!E26)","v":0},0,{"$f":"(G99*'Salary Worksheet'!F26)","v":0},0,{"$f":"(I99*'Salary Worksheet'!G26)","v":0},0,{"$f":"(K99*'Salary Worksheet'!H26)","v":0},{"$f":"SUM(L99,J99,H99,F99,D99)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C100*'Salary Worksheet'!D27)","v":0},0,{"$f":"(E100*'Salary Worksheet'!E27)","v":0},0,{"$f":"(G100*'Salary Worksheet'!F27)","v":0},0,{"$f":"(I100*'Salary Worksheet'!G27)","v":0},0,{"$f":"(K100*'Salary Worksheet'!H27)","v":0},{"$f":"SUM(L100,J100,H100,F100,D100)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D99:D100)","v":0},null,{"$f":"SUM(F99:F100)","v":0},null,{"$f":"SUM(H99:H100)","v":0},null,{"$f":"SUM(J99:J100)","v":0},null,{"$f":"SUM(L99:L100)","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
["Total Shipping",null,null,200,null,200,null,200,null,200,null,200,1000]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D104,D101,D97,D89,D77,D72,D68,D56,D50,D46,D34)","v":384749.50439999998},null,{"$f":"SUM(F104,F101,F97,F89,F77,F72,F68,F56,F50,F46,F34)","v":226500.22},null,{"$f":"SUM(H104,H101,H97,H89,H77,H72,H68,H56,H50,H46,H34)","v":280447.79000000004},null,{"$f":"SUM(J104,J101,J97,J89,J77,J72,J68,J56,J50,J46,J34)","v":237890.05480000001},null,{"$f":"SUM(L104,L101,L97,L89,L77,L72,L68,L56,L50,L46,L34)","v":473848.26040000003},1603435.8296000001]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D106-D97-D93-D89+D90-D56-D46","v":269749.50439999998},null,{"$f":"F106-F97-F93-F89+F90-F56-F46","v":174510.22},null,{"$f":"H106-H97-H93-H89+H90-H56-H46","v":194487.79000000004},null,{"$f":"J106-J97-J93-J89+J90-J56-J46","v":184920.05480000001},null,{"$f":"L106-L97-L93-L89+L90-L56-L46","v":237080.2604},1060747.8296000001]
["TOTAL INDIRECT COSTS",null,0.51,{"$f":"ROUND(D107*$C$108,0)","v":137572},null,{"$f":"ROUND(F107*$C$108,0)","v":89000},null,{"$f":"ROUND(H107*$C$108,0)","v":99189},null,{"$f":"ROUND(J107*$C$108,0)","v":94309},null,120911,540981]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D108+D106","v":522321.50439999998},null,{"$f":"+F108+F106","v":315500.21999999997},null,{"$f":"+H108+H106","v":379636.79000000004},null,{"$f":"+J108+J106","v":332199.05480000004},null,{"$f":"+L108+L106","v":594759.26040000003},2144416.8295999998]

{"sheet":"Salary Worksheet","index":1,"n_rows":47,"n_cols":11,"rows_kept":47,"cut":false,"hidden":false,"merged":[[28,0,28,8],[43,0,43,8],[0,0,0,8],[20,0,20,8],[26,0,26,2],[25,0,25,2],[23,1,23,2],[21,1,21,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,"Etchemendy",0,{"$f":"C4","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,"Dawe",151398,{"$f":"C5*1.03","v":155939.94},{"$f":"ROUND(D5*(C2+1),0)","v":160618},{"$f":"ROUND(E5*($C$2+1),0)","v":165437},170400,175512]
[null,null,0,{"$f":"C6","v":0},{"$f":"ROUND(D6*(C2+1),0)","v":0},0,0,0]
[null,"Ken Heller",60413,{"$f":"C7*1.03","v":62225.39},{"$f":"ROUND(D7*(C2+1),0)","v":64092},66015,67995,70035]
[null,"Maughan/McGill",157781,{"$f":"C8*1.03","v":162514.43},{"$f":"ROUND(D8*(C2+1),0)","v":167390},172412,177584,182912]
[null,"Enginnering Support ",127961,{"$f":"C9*1.03","v":131799.83000000002},{"$f":"ROUND(D9*(C2+1),0)","v":135754},139827,144022,148343,null,null,{"$f":"61.52*2080","v":127961.60000000001}]
[null,"Linda Kuhnz",79979,{"$f":"C10*1.03","v":82378.37},{"$f":"ROUND(D10*(C2+1),0)","v":84850},87396,90018,92719]
[null,null,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,"PI/Co-PI 1",0,{"$f":"C13","v":0},{"$f":"ROUND(D13*1.03, 2)","v":0},{"$f":"ROUND(E13*1.03, 2)","v":0},0,0]
[null,"PI/Co-PI 2",0,{"$f":"C14","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,"Other Employee 1",0,0,0,0,0,0]
[null,"Other Employee 2",0,0,0,0,0,0]
[null,"Other Employee 3",0,0,0,0,0,0]
[null,"Other Employee 4",0,0,0,0,0,0]
[null,"Other Employes 5",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,54000,56000,{"$f":"56000*1.03","v":57680},{"$f":"F22*1.03","v":59410.400000000001},{"$f":"G22*1.03","v":61192.712}]
[null,null,"Postdoc (Hourly)",{"$f":"D22/1920","v":28.125},{"$f":"E22/1920","v":29.166666666666668},30.041666666666668,30.942916666666669,31.871204166666665]
[null,"Graduate Students",null,27950,27950,27950,31200,31200]
[null,null,"Grad Student (Hourly)",{"$f":"D24/1920","v":14.557291666666666},{"$f":"E24/1920","v":14.557291666666666},14.557291666666666,16.25,16.25]
["UCSC Resident Tuition (per quarter)",null,null,5652.86,{"$f":"D26*1.07","v":6048.5601999999999},6471.9594139999999,6924.9965729800006,7409.7463330886012]
["UCSC Non-Res Tuition (per quarter)",null,null,10686.86,11434.940200000001,12235.386014000002,13091.863034980002,14008.293447428603]
[]
["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(C31*40*52,0)","v":0},{"$f":"ROUND(E31*(1+$C$2),0)","v":0},0,0,{"$f":"ROUND(H31*($C$2+1),0)","v":0}]
[null,"PT (30-39 hrs) 2",0,null,{"$f":"ROUND(C32*40*52,0)","v":0},0,0,0,{"$f":"ROUND(H32*($C$2+1),0)","v":0}]
[null,"PT (≤29 hrs) 1",0,null,{"$f":"ROUND(C33*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(E36*(1+$C$2),0)","v":0},{"$f":"ROUND(F36*(1+$C$2),0)","v":0},{"$f":"ROUND(G36*(1+$C$2),0)","v":0},{"$f":"ROUND(H36*($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":"C31","v":0},null,{"$f":"C31","v":0},{"$f":"E38*(1+$C$2)","v":0},{"$f":"F38*(1+$C$2)","v":0},0,0]
[null,"PT (30-39 hrs) 2",0,null,0,{"$f":"E39*(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":"E43*(1+$C$2)","v":0},{"$f":"F43*(1+$C$2)","v":0},{"$f":"G43*(1+$C$2)","v":0},{"$f":"H43*(1+$C$2)","v":0}]
["SALARY CALCULATOR"]
["Hours","Hours",null,"Hourly rate:",0,"Annual Salary:",{"$f":"ROUND(E45*40*52,0)","v":0}]
["Months","Months",null,"Monthly rate:",0,"Annual Salary:",{"$f":"ROUND(E46*12,0)","v":0}]
[null,null,null,"Annual Salary",0,"Hourly rate:",{"$f":"ROUND(E47/2080,2)","v":0}]

{"sheet":"Subaward Worksheet","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"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":"BudgetWorksheet!$A$79","v":"Subaward 1"},{"$f":"BudgetWorksheet!$D$79","v":0},{"$f":"BudgetWorksheet!$F$79","v":0},{"$f":"BudgetWorksheet!$H$79","v":0},{"$f":"BudgetWorksheet!$J$79","v":0},{"$f":"BudgetWorksheet!$L$79","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, 12750, (B4*0.51))","v":0},{"$f":"IF(C4+B4>25000,12750-B6,ROUND(C4*0.51,0))","v":0},{"$f":"IF(D4+C4+B4>25000,12750-(B6+C6),(D4*0.51))","v":0},{"$f":"IF(E4+D4+C4+B4>25000,12750-(B6+C6+D6),(E4*0.51))","v":0},{"$f":"IF(F4+E4+D4+C4+B4>25000,12750-(B6+C6+D6+E6),(F4*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$80","v":"Subaward 2"},{"$f":"BudgetWorksheet!$D$80","v":0},{"$f":"BudgetWorksheet!$F$80","v":0},{"$f":"BudgetWorksheet!$H$80","v":0},{"$f":"BudgetWorksheet!$J$80","v":0},{"$f":"BudgetWorksheet!$L$80","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, 12750, (B7*0.51))","v":0},{"$f":"IF(C7+B7>25000,12750-B9,ROUND(C7*0.51,0))","v":0},{"$f":"IF(D7+C7+B7>25000,12750-(B9+C9),(D7*0.51))","v":0},{"$f":"IF(E7+D7+C7+B7>25000,12750-(B9+C9+D9),(E7*0.51))","v":0},{"$f":"IF(F7+E7+D7+C7+B7>25000,12750-(B9+C9+D9+E9),(F7*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$81","v":"Subaward 3"},{"$f":"BudgetWorksheet!$D$81","v":0},{"$f":"BudgetWorksheet!$F$81","v":0},{"$f":"BudgetWorksheet!$H$81","v":0},{"$f":"BudgetWorksheet!$J$81","v":0},{"$f":"BudgetWorksheet!$L$81","v":0},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, 12750, (B10*0.51))","v":0},{"$f":"IF(C10+B10>25000,12750-B12,ROUND(C10*0.51,0))","v":0},{"$f":"IF(D10+C10+B10>25000,12750-(B12+C12),(D10*0.51))","v":0},{"$f":"IF(E10+D10+C10+B10>25000,12750-(B12+C12+D12),(E10*0.51))","v":0},{"$f":"IF(F10+E10+D10+C10+B10>25000,12750-(B12+C12+D12+E12),(F10*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$82","v":"Subaward 4"},{"$f":"BudgetWorksheet!$D$82","v":0},{"$f":"BudgetWorksheet!$F$82","v":0},{"$f":"BudgetWorksheet!$H$82","v":0},{"$f":"BudgetWorksheet!$J$82","v":0},{"$f":"BudgetWorksheet!$L$82","v":0},{"$f":"SUM(B13:F13)","v":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, 12750, (B13*0.51))","v":0},{"$f":"IF(C13+B13>25000,12750-B15,ROUND(C13*0.51,0))","v":0},{"$f":"IF(D13+C13+B13>25000,12750-(B15+C15),(D13*0.51))","v":0},{"$f":"IF(E13+D13+C13+B13>25000,12750-(B15+C15+D15),(E13*0.51))","v":0},{"$f":"IF(F13+E13+D13+C13+B13>25000,12750-(B15+C15+D15+E15),(F13*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$83","v":"Subaward 5"},{"$f":"BudgetWorksheet!$D$83","v":0},{"$f":"BudgetWorksheet!$F$83","v":0},{"$f":"BudgetWorksheet!$H$83","v":0},{"$f":"BudgetWorksheet!$J$83","v":0},{"$f":"BudgetWorksheet!$L$83","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, 12750, (B16*0.51))","v":0},{"$f":"IF(C16+B16>25000,12750-B18,ROUND(C16*0.51,0))","v":0},{"$f":"IF(D16+C16+B16>25000,12750-(B18+C18),(D16*0.51))","v":0},{"$f":"IF(E16+D16+C16+B16>25000,12750-(B18+C18+D18),(E16*0.51))","v":0},{"$f":"IF(F16+E16+D16+C16+B16>25000,12750-(B18+C18+D18+E18),(F16*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$84","v":"Subaward 6"},{"$f":"BudgetWorksheet!$D$84","v":0},{"$f":"BudgetWorksheet!$F$84","v":0},{"$f":"BudgetWorksheet!$H$84","v":0},{"$f":"BudgetWorksheet!$J$84","v":0},{"$f":"BudgetWorksheet!$L$84","v":0},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, 12750, (B19*0.51))","v":0},{"$f":"IF(C19+B19>25000,12750-B21,ROUND(C19*0.51,0))","v":0},{"$f":"IF(D19+C19+B19>25000,12750-(B21+C21),(D19*0.51))","v":0},{"$f":"IF(E19+D19+C19+B19>25000,12750-(B21+C21+D21),(E19*0.51))","v":0},{"$f":"IF(F19+E19+D19+C19+B19>25000,12750-(B21+C21+D21+E21),(F19*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$85","v":"Subaward 7"},{"$f":"BudgetWorksheet!$D$85","v":0},{"$f":"BudgetWorksheet!$F$85","v":0},{"$f":"BudgetWorksheet!$H$85","v":0},{"$f":"BudgetWorksheet!$J$85","v":0},{"$f":"BudgetWorksheet!$L$85","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, 12750, (B22*0.51))","v":0},{"$f":"IF(C22+B22>25000,12750-B24,ROUND(C22*0.51,0))","v":0},{"$f":"IF(D22+C22+B22>25000,12750-(B24+C24),(D22*0.51))","v":0},{"$f":"IF(E22+D22+C22+B22>25000,12750-(B24+C24+D24),(E22*0.51))","v":0},{"$f":"IF(F22+E22+D22+C22+B22>25000,12750-(B24+C24+D24+E24),(F22*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$86","v":"Subaward 8"},{"$f":"BudgetWorksheet!$D$86","v":0},{"$f":"BudgetWorksheet!$F$86","v":0},{"$f":"BudgetWorksheet!$H$86","v":0},{"$f":"BudgetWorksheet!$J$86","v":0},{"$f":"BudgetWorksheet!$L$86","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, 12750, (B25*0.51))","v":0},{"$f":"IF(C25+B25>25000,12750-B27,ROUND(C25*0.51,0))","v":0},{"$f":"IF(D25+C25+B25>25000,12750-(B27+C27),(D25*0.51))","v":0},{"$f":"IF(E25+D25+C25+B25>25000,12750-(B27+C27+D27),(E25*0.51))","v":0},{"$f":"IF(F25+E25+D25+C25+B25>25000,12750-(B27+C27+D27+E27),(F25*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$87","v":"Subaward 9"},{"$f":"BudgetWorksheet!$D$87","v":0},{"$f":"BudgetWorksheet!$F$87","v":0},{"$f":"BudgetWorksheet!$H$87","v":0},{"$f":"BudgetWorksheet!$J$87","v":0},{"$f":"BudgetWorksheet!$L$87","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, 12750, (B28*0.51))","v":0},{"$f":"IF(C28+B28>25000,12750-B30,ROUND(C28*0.51,0))","v":0},{"$f":"IF(D28+C28+B28>25000,12750-(B30+C30),(D28*0.51))","v":0},{"$f":"IF(E28+D28+C28+B28>25000,12750-(B30+C30+D30),(E28*0.51))","v":0},{"$f":"IF(F28+E28+D28+C28+B28>25000,12750-(B30+C30+D30+E30),(F28*0.51))","v":0},0]
[{"$f":"BudgetWorksheet!$A$88","v":"Subaward 10"},{"$f":"BudgetWorksheet!$D$88","v":0},{"$f":"BudgetWorksheet!$F$88","v":0},{"$f":"BudgetWorksheet!$H$88","v":0},{"$f":"BudgetWorksheet!$J$88","v":0},{"$f":"BudgetWorksheet!$L$88","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, 12750, (B31*0.51))","v":0},{"$f":"IF(C31+B31>25000,12750-B33,ROUND(C31*0.51,0))","v":0},{"$f":"IF(D31+C31+B31>25000,12750-(B33+C33),(D31*0.51))","v":0},{"$f":"IF(E31+D31+C31+B31>25000,12750-(B33+C33+D33),(E31*0.51))","v":0},{"$f":"IF(F31+E31+D31+C31+B31>25000,12750-(B33+C33+D33+E33),(F31*0.51))","v":0},0]
["Total Subawards",{"$f":"SUM(B31,B28,B22,B19,B16,B13,B10,B7,B4)","v":0},{"$f":"SUM(C31,C28,C22,C19,C16,C13,C10,C7,C4)","v":0},0,0,0,{"$f":"SUM(B34:F34)","v":0}]
["Total Subject to OH",{"$f":"SUM(B32,B29,B26,B23,B20,B17,B14,B11,B8,B5)","v":0},{"$f":"SUM(C32,C29,C26,C23,C20,C17,C14,C11,C8,C5)","v":0},0,0,0,{"$f":"SUM(B35:F35)","v":0}]
["Total Overhead",{"$f":"SUM(B33,B30,B27,B24,B21,B18,B15,B12,B9,B6)","v":0},{"$f":"SUM(C33,C30,C27,C24,C21,C18,C15,C12,C9,C6)","v":0},0,0,0,0]
[]
["pw: edit"]

{"sheet":"Ship rates","index":3,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["none",0,null,null,null,null,null,0]
["Western Flyer w/ Doc Ricketts, 24hr",28100,null,null,null,null,null,26500]
["Rachel Carson w/ Ventana, 10hr",16500,null,null,null,null,null,16200]
["Rachel Carson w/ Ventana, 12 hr",16500,null,null,null,null,null,17000]
["Rachel Carson w/ AUV, 10hr",25000,null,null,null,null,null,16300]
["Rachel Carson w/ AUV, 12hr",25000,null,null,null,null,null,17100]
["Rachel Carson w/ ROV + AUV, 10hr",30100,null,null,null,null,null,23100]
["Rachel Carson w/ ROV + AUV, 12hr",30100,null,null,null,null,null,23900]
["Rachel Carson only, 10hr",11400,null,null,null,null,null,9400]
["Rachel Carson only, 12hr",11400,null,null,null,null,null,10200]
["Rachel Carson only, 24hr",12600,null,null,null,null,null,14100]
["AUV only, 10 or 12hr",13600,null,null,null,null,null,6900]
["Test Tank",450,null,null,null,null,null,450]
[]
[null,"2014 rates",null,null,null,null,null,"2013 rates"]