{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["BudgetWorksheet","Salary Worksheet","Subaward Worksheet","Ship rates"],"not_rendered":{"charts":0,"images":14,"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":113,"n_cols":13,"rows_kept":113,"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],[110,0,110,2],[36,0,36,1],[37,0,37,1],[28,0,28,1],[8,0,8,1],[49,0,49,1],[29,0,29,1],[53,0,53,1],[59,0,59,1],[71,0,71,1],[75,0,75,1],[80,0,80,1],[54,0,54,1],[17,0,17,1],[100,0,100,1],[104,0,104,1],[107,0,107,1],[0,0,0,4],[72,0,72,1],[38,0,38,1],[50,0,50,1],[60,0,60,1],[76,0,76,1],[81,0,81,1],[101,0,101,1],[94,0,94,1],[93,0,93,1],[2,2,2,3],[2,4,2,5],[92,0,92,1],[2,0,2,1],[1,2,1,3]]}
["Hobson DHS UAK budget",null,null,null,null,null,null,null,null,null,null,"Updated:",{"$f":"TODAY()","v":"2017-04-26"}]
[null,null,"DHS Year 3",null,"DHS Year 4"]
["TOTAL",null,{"$f":"D113","v":40000.090400000001},null,{"$f":"F113","v":117697.508},null,{"$f":"H113","v":0},null,{"$f":"J113","v":0},null,{"$f":"L113","v":0},null,{"$f":"M113","v":157697.59840000002}]
["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'!B4","v":"Brett Hobson "},null,10,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D16*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":752.47},40,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E16*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":3100},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F16*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G16*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H16*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":3852.4700000000003}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D17*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E17*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F17*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G17*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H17*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'!D18*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*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":752.47},null,{"$f":"SUM(F6:F8)","v":3100},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":3852.4700000000003}]
[{"$f":"'Salary Worksheet'!B7","v":"Ben Rannan"},null,54.15,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":2306.06},90,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":3947.4},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":6253.46}]
[{"$f":"'Salary Worksheet'!B8","v":"Brian Kieft"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D20*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":0},100,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":7726},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":0},7726]
[{"$f":"'Salary Worksheet'!B9","v":"Mark Chaffey"},null,70,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D21*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":6066.92},100,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E21*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":8927},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F21*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G21*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H21*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":0},14993.92]
[{"$f":"'Salary Worksheet'!B10","v":"Jon Erikson"},null,70,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":5003.04},65,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":4785.3},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},9788.34]
[{"$f":"'Salary Worksheet'!B11","v":"Jim Schofield"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":0},166,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":8341.5},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},8341.5]
[{"$f":"'Salary Worksheet'!B12","v":"Paul Coenen"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C15,2), ROUND('Salary Worksheet'!D12/12*C15,0))","v":0},200,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E15,2), ROUND('Salary Worksheet'!E12/12*E15,2))","v":9146},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G15,2), ROUND('Salary Worksheet'!F12/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I15,2), ROUND('Salary Worksheet'!G12/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K15,2), ROUND('Salary Worksheet'!H12/12*K15,2))","v":0},9146]
[{"$f":"'Salary Worksheet'!B13","v":"Jose Rosal"},null,20,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C16,2), ROUND('Salary Worksheet'!D13/12*C16,0))","v":1087.21},60,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E16,2), ROUND('Salary Worksheet'!E13/12*E16,2))","v":3359.4},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G16,2), ROUND('Salary Worksheet'!F13/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I16,2), ROUND('Salary Worksheet'!G13/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K16,2), ROUND('Salary Worksheet'!H13/12*K16,2))","v":0},4446.6100000000006]
[{"$f":"'Salary Worksheet'!B14","v":"Ray Thompson"},null,30,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C17,2), ROUND('Salary Worksheet'!D14/12*C17,0))","v":1550.18},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E17,2), ROUND('Salary Worksheet'!E14/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G17,2), ROUND('Salary Worksheet'!F14/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I17,2), ROUND('Salary Worksheet'!G14/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K17,2), ROUND('Salary Worksheet'!H14/12*K17,2))","v":0},1550.18]
["Subtotal Other Employee Salary",null,0,{"$f":"SUM(D10:D17)","v":16013.41},0,{"$f":"SUM(F10:F17)","v":46232.6},0,{"$f":"SUM(H10:H17)","v":0},0,{"$f":"SUM(J10:J17)","v":0},0,{"$f":"SUM(L10:L17)","v":0},{"$f":"SUM(J18+H18+F18+D18+L18)","v":62246.009999999995}]
["POSTDOCS, GSRs, PART-TIME, TEMPS",null,0,null,0,null,0,null,0,null,0]
["To calculate labor costs for Postdocs and GSRs, enter months of effort below; salary will calculate automatically based on MBARI rates.",null,0,null,0,null,0,null,0,null,0]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D29*C21,2), ROUND('Salary Worksheet'!D28/12*C21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E29*E21,2), ROUND('Salary Worksheet'!E28/12*E21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F29*G21,2), ROUND('Salary Worksheet'!F28/12*G21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G29*I21,2), ROUND('Salary Worksheet'!G28/12*I21,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H29*K21,2), ROUND('Salary Worksheet'!H28/12*K21,0))","v":0},{"$f":"SUM(J21+H21+F21+D21+L21)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D31*C22,2), ROUND('Salary Worksheet'!D30/12*C22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E31*E22,2), ROUND('Salary Worksheet'!E30/12*E22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F31*G22,2), ROUND('Salary Worksheet'!F30/12*G22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G31*I22,2), ROUND('Salary Worksheet'!G30/12*I22,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H31*K22,2), ROUND('Salary Worksheet'!H30/12*K22,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E44*C23,2), ROUND('Salary Worksheet'!E37/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F44*E23,2), ROUND('Salary Worksheet'!F37/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G44*G23,2), ROUND('Salary Worksheet'!G37/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H44*I23,2), ROUND('Salary Worksheet'!H37/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I44*K23,2), ROUND('Salary Worksheet'!I37/12*K23,0))","v":0},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E45*C24,2), ROUND('Salary Worksheet'!E38/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F45*E24,2), ROUND('Salary Worksheet'!F38/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G45*G24,2), ROUND('Salary Worksheet'!G38/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H45*I24,2), ROUND('Salary Worksheet'!H38/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I45*K24,2), ROUND('Salary Worksheet'!I38/12*K24,0))","v":0},{"$f":"SUM(J24+H24+F24+D24+L24)","v":0}]
["Part-time (<= 29 hrs/wk) 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E46*C25,2), ROUND('Salary Worksheet'!E39/12*C25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F46*E25,2), ROUND('Salary Worksheet'!F39/12*E25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G46*G25,2), ROUND('Salary Worksheet'!G39/12*G25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H46*I25,2), ROUND('Salary Worksheet'!H39/12*I25,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I46*K25,2), ROUND('Salary Worksheet'!I39/12*K25,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E47*C26,2), ROUND('Salary Worksheet'!E40/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F47*E26,2), ROUND('Salary Worksheet'!F40/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G47*G26,2), ROUND('Salary Worksheet'!G40/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H47*I26,2), ROUND('Salary Worksheet'!H40/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I47*K26,2), ROUND('Salary Worksheet'!I40/12*K26,0))","v":0},{"$f":"SUM(J26+H26+F26+D26+L26)","v":0}]
["Temporary Employee 1",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E48*C27,2), ROUND('Salary Worksheet'!E41/12*C27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F48*E27,2), ROUND('Salary Worksheet'!F41/12*E27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G48*G27,2), ROUND('Salary Worksheet'!G41/12*G27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H48*I27,2), ROUND('Salary Worksheet'!H41/12*I27,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I48*K27,2), ROUND('Salary Worksheet'!I41/12*K27,0))","v":0},0]
["Temporary Employee 2",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E49*C28,2), ROUND('Salary Worksheet'!E42/12*C28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F49*E28,2), ROUND('Salary Worksheet'!F42/12*E28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G49*G28,2), ROUND('Salary Worksheet'!G42/12*G28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H49*I28,2), ROUND('Salary Worksheet'!H42/12*I28,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I49*K28,2), ROUND('Salary Worksheet'!I42/12*K28,0))","v":0},{"$f":"SUM(J28+H28+F28+D28+L28)","v":0}]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D18:D27)","v":16013.41},null,{"$f":"SUM(F18:F27)","v":46232.6},null,{"$f":"SUM(H18:H27)","v":0},null,{"$f":"SUM(J18:J27)","v":0},null,{"$f":"SUM(L18:L27)","v":0},62246.009999999995]
["Total Salary & Wages",null,null,{"$f":"SUM(D29+D9)","v":16765.88},null,{"$f":"SUM(F29+F9)","v":49332.6},null,{"$f":"SUM(H29+H9)","v":0},null,{"$f":"SUM(J29+J9)","v":0},null,{"$f":"SUM(L29+L9)","v":0},66098.48]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57999999999999996,null,{"$f":"((D9+D18)*$B$32)","v":9724.2103999999999},null,{"$f":"((F9+F18)*$B$32)","v":28612.907999999996},null,{"$f":"((H9+H18)*$B$32)","v":0},null,{"$f":"((J9+J18)*$B$32)","v":0},null,{"$f":"((L9+L18)*$B$32)","v":0},{"$f":"SUM(J32+H32+F32+D32+L32)","v":38337.118399999992}]
["PostDoc",0.49,null,{"$f":"D21*$B$33","v":0},null,{"$f":"F21*$B$33","v":0},null,{"$f":"H21*$B$33","v":0},null,{"$f":"J21*$B$33","v":0},null,{"$f":"L21*$B$33","v":0},0]
["PT (30-39 hrs)",0.57999999999999996,null,{"$f":"(SUM(D23:D24))*$B$34","v":0},null,{"$f":"(SUM(F23:F24)*$B$34)","v":0},null,{"$f":"(SUM(H23:H24)*$B$34)","v":0},null,{"$f":"(SUM(J23:J24)*$B$34)","v":0},null,{"$f":"(SUM(L23:L24)*$B$34)","v":0},0]
["GSRs + PT (20-29 hrs)",0.32,null,{"$f":"(SUM(D22,D25,D26))*$B$35","v":0},null,{"$f":"(SUM(F22,F25,F26))*$B$35","v":0},null,{"$f":"(SUM(H22,H25,H26))*$B$35","v":0},null,{"$f":"(SUM(J22,J25,J26))*$B$35","v":0},null,{"$f":"(SUM(L22,L25,L26))*$B$35","v":0},0]
["Temp",0.1,null,{"$f":"(D27+D28)*$B$36","v":0},null,{"$f":"(F27+F28)*$B$36","v":0},null,{"$f":"(H27+H28)*$B$36","v":0},null,{"$f":"(J27+J28)*$B$36","v":0},null,{"$f":"(L27+L28)*$B$36","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D32:D36)","v":9724.2103999999999},null,{"$f":"SUM(F32:F36)","v":28612.907999999996},null,{"$f":"SUM(H32:H36)","v":0},null,{"$f":"SUM(J32:J36)","v":0},null,{"$f":"SUM(L32:L36)","v":0},38337.118399999992]
["Total Salary & Benefits",null,null,{"$f":"SUM(D37,D30)","v":26490.090400000001},null,{"$f":"SUM(F37,F30)","v":77945.508000000002},null,{"$f":"SUM(H37,H30)","v":0},null,{"$f":"SUM(J37,J30)","v":0},null,{"$f":"SUM(L37,L30)","v":0},104435.5984]
["CAPITAL EQUIPMENT  (items >$5K)"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J40+H40+F40+D40+L40)","v":0}]
["Item 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J41+H41+F41+D41+L41)","v":0}]
["Item 3",null,null,null,null,null,null,null,null,null,null,null,0]
["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(D40:D49)","v":0},null,{"$f":"SUM(F40:F49)","v":0},null,{"$f":"SUM(H40:H49)","v":0},null,{"$f":"SUM(J40:J49)","v":0},null,{"$f":"SUM(L40:L49)","v":0},{"$f":"SUM(L50,J50,H50,F50,D50)","v":0}]
["TRAVEL"]
["Travel - Domestic",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L52,J52,H52,F52,D52)","v":0}]
["Travel - Foreign",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L53,J53,H53,F53,D53)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D52:D53)","v":0},null,{"$f":"SUM(F52:F53)","v":0},null,{"$f":"SUM(H52:H53)","v":0},null,{"$f":"SUM(J52:J53)","v":0},null,{"$f":"SUM(L52:L53)","v":0},{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L56,J56,H56,F56,D56)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L57,J57,H57,F57,D57)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D56:D59)","v":0},null,{"$f":"SUM(F56:F59)","v":0},null,{"$f":"SUM(H56:H59)","v":0},null,{"$f":"SUM(J56:J59)","v":0},null,{"$f":"SUM(L56:L59)","v":0},{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["MATERIALS & SUPPLIES"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["Item 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L63,J63,H63,F63,D63)","v":0}]
["Item 3",null,null,null,null,null,null,null,null,null,null,null,0]
["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 Materials & Supplies",null,null,{"$f":"SUM(D62:D71)","v":0},null,{"$f":"SUM(F62:F71)","v":0},null,{"$f":"SUM(H62:H71)","v":0},null,{"$f":"SUM(J62:J71)","v":0},null,{"$f":"SUM(L62:L71)","v":0},{"$f":"SUM(L72,J72,H72,F72,D72)","v":0}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L74,J74,H74,F74,D74)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L75,J75,H75,F75,D75)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D74)","v":0},null,{"$f":"SUM(F74)","v":0},null,{"$f":"SUM(H74:H74)","v":0},null,{"$f":"SUM(J74:J74)","v":0},null,{"$f":"SUM(L74:L74)","v":0},{"$f":"SUM(L76,J76,H76,F76,D76)","v":0}]
["OUTSIDE SERVICES"]
["Item 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["Item 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L79,J79,H79,F79,D79)","v":0}]
["Item 3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L80,J80,H80,F80,D80)","v":0}]
["Total Outside Services",null,null,{"$f":"SUM(D78:D79)","v":0},null,{"$f":"SUM(F78:F79)","v":0},null,{"$f":"SUM(H78:H79)","v":0},null,{"$f":"SUM(J78:J79)","v":0},null,{"$f":"SUM(L78:L79)","v":0},{"$f":"SUM(L81,J81,H81,F81,D81)","v":0}]
["SUBAWARDS"]
["Subaward 1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L83,J83,H83,F83,D83)","v":0}]
["Subaward 2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L84,J84,H84,F84,D84)","v":0}]
["Subaward 3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L85,J85,H85,F85,D85)","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(D83:D92)","v":0},null,{"$f":"SUM(F83:F92)","v":0},null,{"$f":"SUM(H83:H92)","v":0},null,{"$f":"SUM(J83:J92)","v":0},null,{"$f":"SUM(L83:L92)","v":0},{"$f":"SUM(L93,J93,H93,F93,D93)","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(L95,J95,H95,F95,D95)","v":0}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
["none",{"$f":"INDEX('Ship rates'!A1:B9, MATCH(A97, ShipRates,0 ), 2)","v":0},0,{"$f":"B97*C97","v":0},null,{"$f":"29500*E97","v":0},null,{"$f":"29500*G97","v":0},null,{"$f":"29500*I97","v":0},null,{"$f":"29500*K97","v":0},{"$f":"SUM(L97,J97,H97,F97,D97)","v":0}]
["none",{"$f":"INDEX('Ship rates'!A1:B9, MATCH(A98, ShipRates,0 ), 2)","v":0},0,{"$f":"B98*C98","v":0},null,{"$f":"16900*E98","v":0},null,{"$f":"16900*G98","v":0},null,{"$f":"16900*I98","v":0},null,{"$f":"16900*K98","v":0},{"$f":"SUM(L98,J98,H98,F98,D98)","v":0}]
[null,null,0,{"$f":"B99*C99","v":0},null,{"$f":"B99*E99","v":0},null,{"$f":"B99*G99","v":0},null,{"$f":"B99*I99","v":0},null,{"$f":"B99*K99","v":0},{"$f":"SUM(L99,J99,H99,F99,D99)","v":0}]
[null,null,null,{"$f":"B100*C100","v":0},null,{"$f":"B100*E100","v":0},null,{"$f":"B100*G100","v":0},null,{"$f":"B100*I100","v":0},null,{"$f":"B100*K100","v":0},{"$f":"SUM(L100,J100,H100,F100,D100)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D97:D100)","v":0},null,{"$f":"SUM(F97:F99)","v":0},null,{"$f":"SUM(H97:H99)","v":0},null,{"$f":"SUM(J97:J99)","v":0},null,{"$f":"SUM(L97:L99)","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,0,{"$f":"(C103*'Salary Worksheet'!D32)","v":0},0,{"$f":"(E103*'Salary Worksheet'!E32)","v":0},0,{"$f":"(G103*'Salary Worksheet'!F32)","v":0},0,{"$f":"(I103*'Salary Worksheet'!G32)","v":0},0,{"$f":"(K103*'Salary Worksheet'!H32)","v":0},{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C104*'Salary Worksheet'!D33)","v":0},0,{"$f":"(E104*'Salary Worksheet'!E33)","v":0},0,{"$f":"(G104*'Salary Worksheet'!F33)","v":0},0,{"$f":"(I104*'Salary Worksheet'!G33)","v":0},0,{"$f":"(K104*'Salary Worksheet'!H33)","v":0},{"$f":"SUM(L104,J104,H104,F104,D104)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D103:D104)","v":0},null,{"$f":"SUM(F103:F104)","v":0},null,{"$f":"SUM(H103:H104)","v":0},null,{"$f":"SUM(J103:J104)","v":0},null,{"$f":"SUM(L103:L104)","v":0},{"$f":"SUM(L105,J105,H105,F105,D105)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L107,J107,H107,F107,D107)","v":0}]
["Total Shipping",null,null,{"$f":"SUM(D107)","v":0},null,{"$f":"SUM(F107)","v":0},null,{"$f":"SUM(H107:H107)","v":0},null,{"$f":"SUM(J107:J107)","v":0},null,{"$f":"SUM(L107:L107)","v":0},0]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D108,D105,D101,D93,D81,D76,D72,D60,D54,D50,D38)","v":26490.090400000001},null,{"$f":"SUM(F108,F105,F101,F93,F81,F76,F72,F60,F54,F50,F38)","v":77945.508000000002},null,{"$f":"SUM(H108,H105,H101,H93,H81,H76,H72,H60,H54,H50,H38)","v":0},null,{"$f":"SUM(J108,J105,J101,J93,J81,J76,J72,J60,J54,J50,J38)","v":0},null,{"$f":"SUM(L108,L105,L101,L93,L81,L76,L72,L60,L54,L50,L38)","v":0},104435.5984]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D110-D98-D97-D93+D94-D60-D50","v":26490.090400000001},null,{"$f":"F110-F98-F97-F93+F94-F60-F50","v":77945.508000000002},null,{"$f":"H110-H98-H97-H93+H94-H60-H50","v":0},null,{"$f":"J110-J98-J97-J93+J94-J60-J50","v":0},null,{"$f":"L110-L98-L97-L93+L94-L60-L50","v":0},104435.5984]
["TOTAL INDIRECT COSTS",null,0.51,{"$f":"ROUND(D111*$C$112,0)","v":13510},null,{"$f":"ROUND(F111*$C$112,0)","v":39752},null,{"$f":"ROUND(H111*$C$112,0)","v":0},null,0,null,0,53262]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D112+D110","v":40000.090400000001},null,{"$f":"+F112+F110","v":117697.508},null,{"$f":"+H112+H110","v":0},null,{"$f":"+J112+J110","v":0},null,{"$f":"+L112+L110","v":0},157697.59840000002]

{"sheet":"Salary Worksheet","index":1,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[[34,0,34,8],[49,0,49,8],[0,0,0,8],[26,0,26,8],[32,0,32,2],[31,0,31,2],[29,1,29,2],[27,1,27,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,"Brett Hobson ",{"$f":"75.2465*2080","v":156512.72},{"$f":"C4","v":156512.72},{"$f":"ROUND(D4*($C$2+1),0)","v":161208},{"$f":"ROUND(E4*($C$2+1),0)","v":166044},{"$f":"ROUND(F4*($C$2+1),0)","v":171025},{"$f":"ROUND(G4*($C$2+1),0)","v":176156}]
[null,null,0,{"$f":"C5","v":0},{"$f":"ROUND(D5*(C2+1),0)","v":0},{"$f":"ROUND(E5*($C$2+1),0)","v":0},0,0]
[null,null,0,{"$f":"C6","v":0},{"$f":"ROUND(D6*(C2+1),0)","v":0},0,0,0]
[null,"Ben Rannan",{"$f":"42.5865*2080","v":88579.92},88579.92,{"$f":"ROUND(D7*(C2+1),0)","v":91237},93974,96793,99697]
[null,"Brian Kieft",{"$f":"75.011*2080","v":156022.88},156022.88,{"$f":"ROUND(D8*(C2+1),0)","v":160704},165525,170491,175606]
[null,"Mark Chaffey",{"$f":"86.6703*2080","v":180274.22399999999},180274.22399999999,{"$f":"ROUND(D9*(C2+1),0)","v":185682},191252,196990,202900]
[null,"Jon Erikson",{"$f":"71.472*2080","v":148661.75999999998},148661.75999999998,{"$f":"ROUND(D10*(C2+1),0)","v":153122},157716,162447,167320]
[null,"Jim Schofield",{"$f":"48.79*2080","v":101483.2},101483.2,{"$f":"D11*1.03","v":104527.696},107664,110894,114221]
[null,"Paul Coenen",{"$f":"44.4009*2080","v":92353.872000000003},{"$f":"C12","v":92353.872000000003},{"$f":"D12*1.03","v":95124.488160000008},{"$f":"ROUND(E12*($C$2+1),0)","v":97978},{"$f":"ROUND(F12*($C$2+1),0)","v":100917},{"$f":"ROUND(G12*($C$2+1),0)","v":103945}]
[null,"Jose Rosal",{"$f":"54.3607*2080","v":113070.25600000001},{"$f":"C13","v":113070.25600000001},{"$f":"1.03*D13","v":116462.36368000001},{"$f":"ROUND(E13*($C$2+1),0)","v":119956},{"$f":"ROUND(F13*($C$2+1),0)","v":123555},{"$f":"ROUND(G13*($C$2+1),0)","v":127262}]
[null,"Ray Thompson",{"$f":"51.6728*2080","v":107479.424},107479.424,{"$f":"D14*1.03","v":110703.80672000001},114025,117446,120969]
[null,null,"HOURLY RATE","YR-1","YR-2","YR-3","YR-4","YR-5"]
[null,"Brett Hobson ",75.246499999999997,{"$f":"C16","v":75.246499999999997},{"$f":"ROUND(D16*1.03, 2)","v":77.5},{"$f":"ROUND(E16*1.03, 2)","v":79.83},82.22,84.69]
[null,null,0,{"$f":"C17","v":0},{"$f":"ROUND(D17*1.03, 2)","v":0},0,0,0]
[null,null,0,0,0,0,0,0]
[null,"Ben Rannan",42.586500000000001,42.586500000000001,43.86,45.18,46.54,47.94]
[null,"Brian Kieft",75.010999999999996,75.010999999999996,77.260000000000005,79.58,81.97,84.43]
[null,"Mark Chaffey",86.670299999999997,{"$f":"C21","v":86.670299999999997},{"$f":"ROUND(D21*1.03, 2)","v":89.27},{"$f":"ROUND(E21*1.03, 2)","v":91.95},{"$f":"ROUND(F21*1.03, 2)","v":94.71},{"$f":"ROUND(G21*1.03, 2)","v":97.55}]
[null,"Jon Erikson",71.471999999999994,71.471999999999994,73.62,75.83,78.099999999999994,80.44]
[null,"Jim Schofield",48.79,48.79,50.25,51.76,53.31,54.91]
[null,"Paul Coenen",44.4009,44.4009,45.73,47.1,48.51,49.97]
[null,"Jose Rosal",54.360700000000001,54.360700000000001,55.99,57.67,59.4,61.18]
[null,"Ray Thompson",51.672800000000002,51.672800000000002,53.22,54.82,56.46,58.15]
["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,55000,57000,59000,{"$f":"F28*1.03","v":60770},{"$f":"G28*1.03","v":62593.1}]
[null,null,"Postdoc (Hourly)",{"$f":"D28/1920","v":28.645833333333332},{"$f":"E28/1920","v":29.6875},30.729166666666668,31.651041666666668,32.600572916666664]
[null,"Graduate Students",null,27950,27950,27950,31200,31200]
[null,null,"Grad Student (Hourly)",21.5,21.5,21.5,24,24]
["UCSC Resident Tuition (per quarter)",null,null,5916.86,{"$f":"D32*1.07","v":6331.0402000000004},{"$f":"E32*1.07","v":6774.2130140000008},7248.4079249800016,7755.7964797286022]
["UCSC Non-Res Tuition (per quarter)",null,null,15102,16159.140000000001,17290.279800000004,18500.599386000005,19795.641343020008]
[]
["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(C37*40*52,0)","v":0},{"$f":"ROUND(E37*(1+$C$2),0)","v":0},0,0,{"$f":"ROUND(H37*($C$2+1),0)","v":0}]
[null,"PT (30-39 hrs) 2",0,null,{"$f":"ROUND(C38*40*52,0)","v":0},0,0,0,{"$f":"ROUND(H38*($C$2+1),0)","v":0}]
[null,"PT (≤29 hrs) 1",0,null,{"$f":"ROUND(C39*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(E42*(1+$C$2),0)","v":0},{"$f":"ROUND(F42*(1+$C$2),0)","v":0},{"$f":"ROUND(G42*(1+$C$2),0)","v":0},{"$f":"ROUND(H42*($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":"C37","v":0},null,{"$f":"C37","v":0},{"$f":"E44*(1+$C$2)","v":0},{"$f":"F44*(1+$C$2)","v":0},0,0]
[null,"PT (30-39 hrs) 2",0,null,0,{"$f":"E45*(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":"E49*(1+$C$2)","v":0},{"$f":"F49*(1+$C$2)","v":0},{"$f":"G49*(1+$C$2)","v":0},{"$f":"H49*(1+$C$2)","v":0}]
["SALARY CALCULATOR"]
["Hours","Hours",null,"Hourly rate:",0,"Annual Salary:",{"$f":"ROUND(E51*40*52,0)","v":0}]
["Months","Months",null,"Monthly rate:",0,"Annual Salary:",{"$f":"ROUND(E52*12,0)","v":0}]
[null,null,null,"Annual Salary",0,"Hourly rate:",{"$f":"ROUND(E53/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$83","v":"Subaward 1"},{"$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},{"$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$84","v":"Subaward 2"},{"$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(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$85","v":"Subaward 3"},{"$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(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$86","v":"Subaward 4"},{"$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},{"$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$87","v":"Subaward 5"},{"$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(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$88","v":"Subaward 6"},{"$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(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$89","v":"Subaward 7"},{"$f":"BudgetWorksheet!$D$89","v":0},{"$f":"BudgetWorksheet!$F$89","v":0},{"$f":"BudgetWorksheet!$H$89","v":0},{"$f":"BudgetWorksheet!$J$89","v":0},{"$f":"BudgetWorksheet!$L$89","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$90","v":"Subaward 8"},{"$f":"BudgetWorksheet!$D$90","v":0},{"$f":"BudgetWorksheet!$F$90","v":0},{"$f":"BudgetWorksheet!$H$90","v":0},{"$f":"BudgetWorksheet!$J$90","v":0},{"$f":"BudgetWorksheet!$L$90","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$91","v":"Subaward 9"},{"$f":"BudgetWorksheet!$D$91","v":0},{"$f":"BudgetWorksheet!$F$91","v":0},{"$f":"BudgetWorksheet!$H$91","v":0},{"$f":"BudgetWorksheet!$J$91","v":0},{"$f":"BudgetWorksheet!$L$91","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$92","v":"Subaward 10"},{"$f":"BudgetWorksheet!$D$92","v":0},{"$f":"BudgetWorksheet!$F$92","v":0},{"$f":"BudgetWorksheet!$H$92","v":0},{"$f":"BudgetWorksheet!$J$92","v":0},{"$f":"BudgetWorksheet!$L$92","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":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["none",0]
["Western Flyer w/ Doc Ricketts",31500]
["Rachel Carson 10/12hr",12500]
["Rachel Carson 24hr",13700]
["ROV Ventana",5500]
["AUV - single vehicle",6500]
["AUV - multiple vehicles",9300]
["Mini ROV",3300]
["Test Tank",450]
[2017]