{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["MARS Budget w UW subaward","Sheet1","CIP MARS Node w UW subaward","MARS Budget","CIP MARS Node Upgrade","Salary Worksheet","Subaward Worksheet","Projected Ship Rates","Craig's Worksheet"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":53,"comments":6,"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":"MARS Budget w UW subaward","index":0,"n_rows":117,"n_cols":13,"rows_kept":117,"cut":false,"hidden":false,"merged":[[108,0,108,1],[111,0,111,1],[114,0,114,2],[85,0,85,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[104,0,104,1],[105,0,105,1],[84,0,84,1],[40,0,40,1],[51,0,51,1],[52,0,52,1],[55,0,55,1],[56,0,56,1],[61,0,61,1],[62,0,62,1],[73,0,73,1],[74,0,74,1],[77,0,77,1],[78,0,78,1],[39,0,39,1],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[8,0,8,1],[19,0,19,1],[30,0,30,1],[31,0,31,1],[38,0,38,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]]}
["MARS Renewal 2021-2026"]
[null,null,"03/01/21-02/28/22",null,"03/01/22-02/28/23",null,"03/01/23-02/28/24",null,"03/01/24-02/28/25",null,"03/01/25-02/28/26"]
["TOTAL",null,{"$f":"D117","v":930742.41449999996},null,{"$f":"F117","v":588941.62881000002},null,{"$f":"H117","v":484151.43},null,{"$f":"J117","v":779452.63719000004},null,{"$f":"L117","v":666416.62662500003},null,{"$f":"M117","v":3449704.737125}]
["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":"Mike Kelly"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D18*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*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'!D20*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*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":0},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":0}]
[{"$f":"'Salary Worksheet'!B7","v":"Craig Dawe"},null,5,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D21*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":79488},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E21*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":32748.83},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F21*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G21*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H21*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":112236.83}]
[{"$f":"'Salary Worksheet'!B8","v":"MARS Operations Manager"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":0},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":31795},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":65497.67},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":67462.67},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":69486.67},234242.01]
[{"$f":"'Salary Worksheet'!B9","v":"Dave French"},null,1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":9487},0.67,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":6547.13},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":20130},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":20733.830000000002},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":21355.83},78253.790000000008]
[{"$f":"'Salary Worksheet'!B10","v":"Paul McGill"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":4073},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":16779.919999999998},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":17283.330000000002},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":17801.830000000002},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":18335.919999999998},74274]
[{"$f":"'Salary Worksheet'!B11","v":"Ed Mellinger"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":3798},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},3798]
[{"$f":"'Salary Worksheet'!B12","v":"Rich Schramm"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C15,2), ROUND('Salary Worksheet'!D12/12*C15,0))","v":3598},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E15,2), ROUND('Salary Worksheet'!E12/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G15,2), ROUND('Salary Worksheet'!F12/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I15,2), ROUND('Salary Worksheet'!G12/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K15,2), ROUND('Salary Worksheet'!H12/12*K15,2))","v":0},3598]
[{"$f":"'Salary Worksheet'!B13","v":"Mike Risi"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C16,2), ROUND('Salary Worksheet'!D13/12*C16,0))","v":3732},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E16,2), ROUND('Salary Worksheet'!E13/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G16,2), ROUND('Salary Worksheet'!F13/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I16,2), ROUND('Salary Worksheet'!G13/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K16,2), ROUND('Salary Worksheet'!H13/12*K16,2))","v":0},3732]
[{"$f":"'Salary Worksheet'!B14","v":"Jon Erickson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C17,2), ROUND('Salary Worksheet'!D14/12*C17,0))","v":3511},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E17,2), ROUND('Salary Worksheet'!E14/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G17,2), ROUND('Salary Worksheet'!F14/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I17,2), ROUND('Salary Worksheet'!G14/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K17,2), ROUND('Salary Worksheet'!H14/12*K17,2))","v":0},3511]
[{"$f":"'Salary Worksheet'!B15","v":"Ray Thompson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D29*C18,2), ROUND('Salary Worksheet'!D15/12*C18,0))","v":2525},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E29*E18,2), ROUND('Salary Worksheet'!E15/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F29*G18,2), ROUND('Salary Worksheet'!F15/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G29*I18,2), ROUND('Salary Worksheet'!G15/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H29*K18,2), ROUND('Salary Worksheet'!H15/12*K18,2))","v":0},2525]
[{"$f":"'Salary Worksheet'!B16","v":"Duane Thompson"},null,2.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C19,2), ROUND('Salary Worksheet'!D16/12*C19,0))","v":23669},3,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E19,2), ROUND('Salary Worksheet'!E16/12*E19,2))","v":31390},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G19,2), ROUND('Salary Worksheet'!F16/12*G19,2))","v":43109},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I19,2), ROUND('Salary Worksheet'!G16/12*I19,2))","v":44402.33},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K19,2), ROUND('Salary Worksheet'!H16/12*K19,2))","v":45734.33},188304.66]
["Subtotal Other Employee Salary",null,null,{"$f":"SUM(D10:D19)","v":133881},null,{"$f":"SUM(F10:F19)","v":119260.88},null,{"$f":"SUM(H10:H19)","v":146020},null,{"$f":"SUM(J10:J19)","v":150400.66},null,{"$f":"SUM(L10:L19)","v":154912.75},{"$f":"SUM(J20+H20+F20+D20+L20)","v":704475.29}]
["POSTDOCS, GSRs, PART-TIME, TEMPS"]
[]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C23,2), ROUND('Salary Worksheet'!D27/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E23,2), ROUND('Salary Worksheet'!E27/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G23,2), ROUND('Salary Worksheet'!F27/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I23,2), ROUND('Salary Worksheet'!G27/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K23,2), ROUND('Salary Worksheet'!H27/12*K23,0))","v":0},{"$f":"SUM(J23+H23+F23+D23+L23)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C24,2), ROUND('Salary Worksheet'!D29/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E24,2), ROUND('Salary Worksheet'!E29/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G24,2), ROUND('Salary Worksheet'!F29/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I24,2), ROUND('Salary Worksheet'!G29/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K24,2), ROUND('Salary Worksheet'!H29/12*K24,0))","v":0},0]
["NA PT (30-39 hrs)",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},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E44*C26,2), ROUND('Salary Worksheet'!E37/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F44*E26,2), ROUND('Salary Worksheet'!F37/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G44*G26,2), ROUND('Salary Worksheet'!G37/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H44*I26,2), ROUND('Salary Worksheet'!H37/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I44*K26,2), ROUND('Salary Worksheet'!I37/12*K26,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 1",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]
["Part-time (<= 29 hrs/wk) 2",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]
["Temporary Employee 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]
["Temporary Employee 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]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D20:D29)","v":133881},null,{"$f":"SUM(F20:F29)","v":119260.88},null,{"$f":"SUM(H20:H29)","v":146020},null,{"$f":"SUM(J20:J29)","v":150400.66},null,{"$f":"SUM(L20:L29)","v":154912.75},704475.29]
["Total Salary & Wages",null,null,{"$f":"SUM(D31+D9)","v":133881},null,{"$f":"SUM(F31+F9)","v":119260.88},null,{"$f":"SUM(H31+H9)","v":146020},null,{"$f":"SUM(J31+J9)","v":150400.66},null,{"$f":"SUM(L31+L9)","v":154912.75},704475.29]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D20)*$B$34)","v":76512.991500000004},null,{"$f":"((F9+F20)*$B$34)","v":68157.59292000001},null,{"$f":"((H9+H20)*$B$34)","v":83450.430000000008},null,{"$f":"((J9+J20)*$B$34)","v":85953.977190000005},null,{"$f":"((L9+L20)*$B$34)","v":88532.636624999999},{"$f":"SUM(J34+H34+F34+D34+L34)","v":402607.62823500001}]
["PostDoc",0.4123,null,{"$f":"D23*$B$35","v":0},null,{"$f":"F23*$B$35","v":0},null,{"$f":"H23*$B$35","v":0},null,{"$f":"J23*$B$35","v":0},null,{"$f":"L23*$B$35","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D25:D26))*$B$36","v":0},null,{"$f":"(SUM(F25:F26)*$B$36)","v":0},null,{"$f":"(SUM(H25:H26)*$B$36)","v":0},null,{"$f":"(SUM(J25:J26)*$B$36)","v":0},null,{"$f":"(SUM(L25:L26)*$B$36)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D24,D27,D28))*$B$37","v":0},null,{"$f":"(SUM(F24,F27,F28))*$B$37","v":0},null,{"$f":"(SUM(H24,H27,H28))*$B$37","v":0},null,{"$f":"(SUM(J24,J27,J28))*$B$37","v":0},null,{"$f":"(SUM(L24,L27,L28))*$B$37","v":0},0]
["Temp",0.1111,null,{"$f":"(D29+D30)*$B$38","v":0},null,{"$f":"(F29+F30)*$B$38","v":0},null,{"$f":"(H29+H30)*$B$38","v":0},null,{"$f":"(J29+J30)*$B$38","v":0},null,{"$f":"(L29+L30)*$B$38","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D34:D38)","v":76512.991500000004},null,{"$f":"SUM(F34:F38)","v":68157.59292000001},null,{"$f":"SUM(H34:H38)","v":83450.430000000008},null,{"$f":"SUM(J34:J38)","v":85953.977190000005},null,{"$f":"SUM(L34:L38)","v":88532.636624999999},402607.62823500001]
["Total Salary & Benefits",null,null,{"$f":"SUM(D39,D32)","v":210393.9915},null,{"$f":"SUM(F39,F32)","v":187418.47292000003},null,{"$f":"SUM(H39,H32)","v":229470.43},null,{"$f":"SUM(J39,J32)","v":236354.63719000001},null,{"$f":"SUM(L39,L32)","v":243445.38662499998},1107082.918235]
["CAPITAL EQUIPMENT  (items >$5K)"]
["Computer Hardware",null,null,8250,null,8250,null,null,null,null,null,null,{"$f":"SUM(J42+H42+F42+D42+L42)","v":16500}]
["CIP: MARS Node Upgrade",null,null,{"$f":"'CIP MARS Node w UW subaward'!D117","v":190597.42300000001},null,{"$f":"'CIP MARS Node w UW subaward'!F117","v":47243.155889999995},null,null,null,null,null,null,{"$f":"SUM(J43+H43+F43+D43+L43)","v":237840.57889}]
[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(D42:D51)","v":198847.42300000001},null,{"$f":"SUM(F42:F51)","v":55493.155889999995},null,{"$f":"SUM(H42:H51)","v":0},null,{"$f":"SUM(J42:J51)","v":0},null,{"$f":"SUM(L42:L51)","v":0},{"$f":"SUM(L52,J52,H52,F52,D52)","v":254340.57889}]
["TRAVEL"]
["Travel - Domestic",null,null,1000,null,1000,null,1000,null,1000,null,1000,{"$f":"SUM(L54,J54,H54,F54,D54)","v":5000}]
["Travel - Foreign",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,J55,H55,F55,D55)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D54:D55)","v":1000},null,{"$f":"SUM(F54:F55)","v":1000},null,{"$f":"SUM(H54:H55)","v":1000},null,{"$f":"SUM(J54:J55)","v":1000},null,{"$f":"SUM(L54:L55)","v":1000},{"$f":"SUM(L56,J56,H56,F56,D56)","v":5000}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L61,J61,H61,F61,D61)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D58:D61)","v":0},null,{"$f":"SUM(F58:F61)","v":0},null,{"$f":"SUM(H58:H61)","v":0},null,{"$f":"SUM(J58:J61)","v":0},null,{"$f":"SUM(L58:L61)","v":0},{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["MATERIALS & SUPPLIES"]
["Supplies computer hardware",null,null,{"$f":"750*1.1","v":825.00000000000011},null,{"$f":"750*1.1","v":825.00000000000011},null,{"$f":"750*1.1","v":825.00000000000011},null,{"$f":"750*1.1","v":825.00000000000011},null,{"$f":"750*1.1","v":825.00000000000011},{"$f":"SUM(L64,J64,H64,F64,D64)","v":4125.0000000000009}]
["Computer software",null,null,200,null,200,null,200,null,200,null,200,{"$f":"SUM(L65,J65,H65,F65,D65)","v":1000}]
["Non-Cap Equipment",null,null,{"$f":"4500*1.1","v":4950},null,{"$f":"4500*1.1","v":4950},null,{"$f":"4500*1.1","v":4950},null,{"$f":"4500*1.1","v":4950},null,{"$f":"4500*1.1","v":4950},24750]
["Supplies General",null,null,{"$f":"1.1*2000","v":2200},null,{"$f":"1.1*2000","v":2200},null,{"$f":"1.1*2000","v":2200},null,{"$f":"1.1*2000","v":2200},null,{"$f":"1.1*2000","v":2200},11000]
[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(D64:D73)","v":8175},null,{"$f":"SUM(F64:F73)","v":8175},null,{"$f":"SUM(H64:H73)","v":8175},null,{"$f":"SUM(J64:J73)","v":8175},null,{"$f":"SUM(L64:L73)","v":8175},{"$f":"SUM(L74,J74,H74,F74,D74)","v":40875}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L76,J76,H76,F76,D76)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L77,J77,H77,F77,D77)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D76)","v":0},null,{"$f":"SUM(F76)","v":0},null,{"$f":"SUM(H76:H76)","v":0},null,{"$f":"SUM(J76:J76)","v":0},null,{"$f":"SUM(L76:L76)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["OUTSIDE SERVICES"]
["Router/Switch maintenance",null,null,1800,null,1854,null,1910,null,1967,null,2026,{"$f":"SUM(L80,J80,H80,F80,D80)","v":9557}]
["Software/Hardware maintenance Independent Contractor",null,null,null,null,null,null,44290,null,45619,null,46987,136896]
["Right of way MLHD",null,null,1460,null,1504,null,1549,null,1595,null,1643.24,7751.24]
["Linda Kuhnz Actual Impacts Assesment (AIA)",null,null,null,null,null,null,null,null,31150,null,null,31150]
["ABA Consultants Sample processing for AIA",null,null,null,null,null,null,null,null,24600,null,null,24600]
["Total Outside Services",null,null,{"$f":"SUM(D80:D84)","v":3260},null,{"$f":"SUM(F80:F84)","v":3358},null,{"$f":"SUM(H80:H84)","v":47749},null,{"$f":"SUM(J80:J84)","v":104931},null,{"$f":"SUM(L80:L84)","v":50656.24},209954.24]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L88,J88,H88,F88,D88)","v":0}]
[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,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]
["UW APL Subaward",null,null,291756,null,137802,null,null,null,null,null,null,429558]
["Total Subawards",null,null,{"$f":"SUM(D87:D96)","v":291756},null,{"$f":"SUM(F87:F96)","v":137802},null,{"$f":"SUM(H87:H96)","v":0},null,{"$f":"SUM(J87:J96)","v":0},null,{"$f":"SUM(L87:L96)","v":0},{"$f":"SUM(L97,J97,H97,F97,D97)","v":429558}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B35","v":25000},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":13125},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(L99,J99,H99,F99,D99)","v":13125}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B101*C101","v":0},null,{"$f":"29500*E101","v":0},null,{"$f":"29500*G101","v":0},null,{"$f":"29500*I101","v":0},null,{"$f":"29500*K101","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,0,{"$f":"B102*C102","v":0},null,{"$f":"16900*E102","v":0},null,{"$f":"16900*G102","v":0},null,{"$f":"16900*I102","v":0},null,{"$f":"16900*K102","v":0},{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
["Rachel Carson w Ventana",{"$f":"'Projected Ship Rates'!C12","v":21800},4,{"$f":"B103*C103","v":87200},4,{"$f":"'Projected Ship Rates'!D12*E103","v":90720},2,{"$f":"'Projected Ship Rates'!E12*G103","v":47400},10,{"$f":"'Projected Ship Rates'!F12*I103","v":245000},8,{"$f":"'Projected Ship Rates'!G12*K103","v":203920},{"$f":"SUM(L103,J103,H103,F103,D103)","v":674240}]
[null,null,null,{"$f":"B104*C104","v":0},null,{"$f":"B104*E104","v":0},null,{"$f":"B104*G104","v":0},null,{"$f":"B104*I104","v":0},null,{"$f":"B104*K104","v":0},{"$f":"SUM(L104,J104,H104,F104,D104)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D103:D104)","v":87200},null,{"$f":"SUM(F103:F104)","v":90720},null,{"$f":"SUM(H103:H104)","v":47400},null,{"$f":"SUM(J103:J104)","v":245000},null,{"$f":"SUM(L103:L104)","v":203920},{"$f":"SUM(L105,J105,H105,F105,D105)","v":674240}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,null,{"$f":"(C107*'Salary Worksheet'!D31)","v":0},null,{"$f":"(E107*'Salary Worksheet'!E31)","v":0},null,{"$f":"(G107*'Salary Worksheet'!F31)","v":0},0,{"$f":"(I107*'Salary Worksheet'!G31)","v":0},0,{"$f":"(K107*'Salary Worksheet'!H31)","v":0},{"$f":"SUM(L107,J107,H107,F107,D107)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C108*'Salary Worksheet'!D32)","v":0},0,{"$f":"(E108*'Salary Worksheet'!E32)","v":0},0,{"$f":"(G108*'Salary Worksheet'!F32)","v":0},0,{"$f":"(I108*'Salary Worksheet'!G32)","v":0},0,{"$f":"(K108*'Salary Worksheet'!H32)","v":0},{"$f":"SUM(L108,J108,H108,F108,D108)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D107:D108)","v":0},null,{"$f":"SUM(F107:F108)","v":0},null,{"$f":"SUM(H107:H108)","v":0},null,{"$f":"SUM(J107:J108)","v":0},null,{"$f":"SUM(L107:L108)","v":0},{"$f":"SUM(L109,J109,H109,F109,D109)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L111,J111,H111,F111,D111)","v":0}]
["Total Shipping",null,null,{"$f":"SUM(D111)","v":0},null,{"$f":"SUM(F111)","v":0},null,{"$f":"SUM(H111:H111)","v":0},null,{"$f":"SUM(J111:J111)","v":0},null,{"$f":"SUM(L111:L111)","v":0},0]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D112,D109,D105,D97,D85,D78,D74,D62,D56,D52,D40)","v":800632.41449999996},null,{"$f":"SUM(F112,F109,F105,F97,F85,F78,F74,F62,F56,F52,F40)","v":483966.62881000002},null,{"$f":"SUM(H112,H109,H105,H97,H85,H78,H74,H62,H56,H52,H40)","v":333794.43},null,{"$f":"SUM(J112,J109,J105,J97,J85,J78,J74,J62,J56,J52,J40)","v":595460.63719000004},null,{"$f":"SUM(L112,L109,L105,L97,L85,L78,L74,L62,L56,L52,L40)","v":507196.62662499998},2721050.737125]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D114-D97+D98-D62-D52-D105","v":247828.99149999995},null,{"$f":"F114-F97+F98-F62-F52-F105","v":199951.47292000003},null,{"$f":"H114-H97+H98-H62-H52-H105","v":286394.43},null,{"$f":"J114-J97+J98-J62-J52-J105","v":350460.63719000004},null,{"$f":"L114-L97+L98-L62-L52-L105","v":303276.62662499998},1387912.158235]
["TOTAL INDIRECT COSTS",null,0.52500000000000002,{"$f":"ROUND(D115*$C$116,0)","v":130110},null,{"$f":"ROUND(F115*$C$116,0)","v":104975},null,{"$f":"ROUND(H115*$C$116,0)","v":150357},null,183992,null,159220,728654]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D116+D114","v":930742.41449999996},null,{"$f":"+F116+F114","v":588941.62881000002},null,{"$f":"+H116+H114","v":484151.43},null,{"$f":"+J116+J114","v":779452.63719000004},null,{"$f":"+L116+L114","v":666416.62662500003},3449704.737125]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"CIP MARS Node w UW subaward","index":2,"n_rows":117,"n_cols":13,"rows_kept":117,"cut":false,"hidden":false,"merged":[[108,0,108,1],[111,0,111,1],[114,0,114,2],[85,0,85,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[104,0,104,1],[105,0,105,1],[84,0,84,1],[40,0,40,1],[51,0,51,1],[52,0,52,1],[55,0,55,1],[56,0,56,1],[61,0,61,1],[62,0,62,1],[73,0,73,1],[74,0,74,1],[77,0,77,1],[78,0,78,1],[39,0,39,1],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[8,0,8,1],[19,0,19,1],[30,0,30,1],[31,0,31,1],[38,0,38,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]]}
["CIP: MARS Node Upgrade",null,null,null,null,null,null,null,null,null,null,"Updated:"]
[null,null,"03/01/21-02/28/22",null,"03/01/22-02/28/23",null,"03/01/23-02/28/24",null,"03/01/24-02/28/25",null,"03/01/25-02/28/26"]
["TOTAL",null,{"$f":"D117","v":190597.42300000001},null,{"$f":"F117","v":47243.155889999995},null,{"$f":"H117","v":0},null,{"$f":"J117","v":0},null,{"$f":"L117","v":0},null,{"$f":"M117","v":237840.57889}]
["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":"Mike Kelly"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D18*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*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'!D20*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*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":0},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":0}]
[{"$f":"'Salary Worksheet'!B7","v":"Craig Dawe"},null,2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D21*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":31795},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E21*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":16374.42},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F21*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G21*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H21*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":48169.42}]
[{"$f":"'Salary Worksheet'!B8","v":"MARS Operations Manager"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":0},0]
[{"$f":"'Salary Worksheet'!B9","v":"Dave French"},null,0.67,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":6356},0.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":3224.71},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":0},9580.7099999999991]
[{"$f":"'Salary Worksheet'!B10","v":"Paul McGill"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":4073},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":0},4073]
[{"$f":"'Salary Worksheet'!B11","v":"Ed Mellinger"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":3798},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},3798]
[{"$f":"'Salary Worksheet'!B12","v":"Rich Schramm"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C15,2), ROUND('Salary Worksheet'!D12/12*C15,0))","v":3598},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E15,2), ROUND('Salary Worksheet'!E12/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G15,2), ROUND('Salary Worksheet'!F12/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I15,2), ROUND('Salary Worksheet'!G12/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K15,2), ROUND('Salary Worksheet'!H12/12*K15,2))","v":0},3598]
[{"$f":"'Salary Worksheet'!B13","v":"Mike Risi"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C16,2), ROUND('Salary Worksheet'!D13/12*C16,0))","v":3732},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E16,2), ROUND('Salary Worksheet'!E13/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G16,2), ROUND('Salary Worksheet'!F13/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I16,2), ROUND('Salary Worksheet'!G13/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K16,2), ROUND('Salary Worksheet'!H13/12*K16,2))","v":0},3732]
[{"$f":"'Salary Worksheet'!B14","v":"Jon Erickson"},null,0.75,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C17,2), ROUND('Salary Worksheet'!D14/12*C17,0))","v":10534},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E17,2), ROUND('Salary Worksheet'!E14/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G17,2), ROUND('Salary Worksheet'!F14/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I17,2), ROUND('Salary Worksheet'!G14/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K17,2), ROUND('Salary Worksheet'!H14/12*K17,2))","v":0},10534]
[{"$f":"'Salary Worksheet'!B15","v":"Ray Thompson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D29*C18,2), ROUND('Salary Worksheet'!D15/12*C18,0))","v":2525},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E29*E18,2), ROUND('Salary Worksheet'!E15/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F29*G18,2), ROUND('Salary Worksheet'!F15/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G29*I18,2), ROUND('Salary Worksheet'!G15/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H29*K18,2), ROUND('Salary Worksheet'!H15/12*K18,2))","v":0},2525]
[{"$f":"'Salary Worksheet'!B16","v":"Duane Thompson"},null,1.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C19,2), ROUND('Salary Worksheet'!D16/12*C19,0))","v":13511},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E19,2), ROUND('Salary Worksheet'!E16/12*E19,2))","v":10463.33},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G19,2), ROUND('Salary Worksheet'!F16/12*G19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I19,2), ROUND('Salary Worksheet'!G16/12*I19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K19,2), ROUND('Salary Worksheet'!H16/12*K19,2))","v":0},23974.33]
["Subtotal Other Employee Salary",null,null,{"$f":"SUM(D10:D19)","v":79922},null,{"$f":"SUM(F10:F19)","v":30062.46},null,{"$f":"SUM(H10:H19)","v":0},null,{"$f":"SUM(J10:J19)","v":0},null,{"$f":"SUM(L10:L19)","v":0},{"$f":"SUM(J20+H20+F20+D20+L20)","v":109984.45999999999}]
["POSTDOCS, GSRs, PART-TIME, TEMPS"]
[]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C23,2), ROUND('Salary Worksheet'!D27/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E23,2), ROUND('Salary Worksheet'!E27/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G23,2), ROUND('Salary Worksheet'!F27/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I23,2), ROUND('Salary Worksheet'!G27/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K23,2), ROUND('Salary Worksheet'!H27/12*K23,0))","v":0},{"$f":"SUM(J23+H23+F23+D23+L23)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C24,2), ROUND('Salary Worksheet'!D29/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E24,2), ROUND('Salary Worksheet'!E29/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G24,2), ROUND('Salary Worksheet'!F29/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I24,2), ROUND('Salary Worksheet'!G29/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K24,2), ROUND('Salary Worksheet'!H29/12*K24,0))","v":0},0]
["NA PT (30-39 hrs)",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},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E44*C26,2), ROUND('Salary Worksheet'!E37/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F44*E26,2), ROUND('Salary Worksheet'!F37/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G44*G26,2), ROUND('Salary Worksheet'!G37/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H44*I26,2), ROUND('Salary Worksheet'!H37/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I44*K26,2), ROUND('Salary Worksheet'!I37/12*K26,0))","v":0},0]
["Part-time (<= 29 hrs/wk) 1",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]
["Part-time (<= 29 hrs/wk) 2",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]
["Temporary Employee 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]
["Temporary Employee 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]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D20:D29)","v":79922},null,{"$f":"SUM(F20:F29)","v":30062.46},null,{"$f":"SUM(H20:H29)","v":0},null,{"$f":"SUM(J20:J29)","v":0},null,{"$f":"SUM(L20:L29)","v":0},109984.45999999999]
["Total Salary & Wages",null,null,{"$f":"SUM(D31+D9)","v":79922},null,{"$f":"SUM(F31+F9)","v":30062.46},null,{"$f":"SUM(H31+H9)","v":0},null,{"$f":"SUM(J31+J9)","v":0},null,{"$f":"SUM(L31+L9)","v":0},109984.45999999999]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D20)*$B$34)","v":45675.423000000003},null,{"$f":"((F9+F20)*$B$34)","v":17180.695889999999},null,{"$f":"((H9+H20)*$B$34)","v":0},null,{"$f":"((J9+J20)*$B$34)","v":0},null,{"$f":"((L9+L20)*$B$34)","v":0},{"$f":"SUM(J34+H34+F34+D34+L34)","v":62856.118889999998}]
["PostDoc",0.4123,null,{"$f":"D23*$B$35","v":0},null,{"$f":"F23*$B$35","v":0},null,{"$f":"H23*$B$35","v":0},null,{"$f":"J23*$B$35","v":0},null,{"$f":"L23*$B$35","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D25:D26))*$B$36","v":0},null,{"$f":"(SUM(F25:F26)*$B$36)","v":0},null,{"$f":"(SUM(H25:H26)*$B$36)","v":0},null,{"$f":"(SUM(J25:J26)*$B$36)","v":0},null,{"$f":"(SUM(L25:L26)*$B$36)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D24,D27,D28))*$B$37","v":0},null,{"$f":"(SUM(F24,F27,F28))*$B$37","v":0},null,{"$f":"(SUM(H24,H27,H28))*$B$37","v":0},null,{"$f":"(SUM(J24,J27,J28))*$B$37","v":0},null,{"$f":"(SUM(L24,L27,L28))*$B$37","v":0},0]
["Temp",0.1111,null,{"$f":"(D29+D30)*$B$38","v":0},null,{"$f":"(F29+F30)*$B$38","v":0},null,{"$f":"(H29+H30)*$B$38","v":0},null,{"$f":"(J29+J30)*$B$38","v":0},null,{"$f":"(L29+L30)*$B$38","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D34:D38)","v":45675.423000000003},null,{"$f":"SUM(F34:F38)","v":17180.695889999999},null,{"$f":"SUM(H34:H38)","v":0},null,{"$f":"SUM(J34:J38)","v":0},null,{"$f":"SUM(L34:L38)","v":0},62856.118889999998]
["Total Salary & Benefits",null,null,{"$f":"SUM(D39,D32)","v":125597.42300000001},null,{"$f":"SUM(F39,F32)","v":47243.155889999995},null,{"$f":"SUM(H39,H32)","v":0},null,{"$f":"SUM(J39,J32)","v":0},null,{"$f":"SUM(L39,L32)","v":0},172840.57889]
["CAPITAL EQUIPMENT  (items >$5K)"]
["ODI Hybrid Test lead (purchased under award OCE 1514756)",null,null,0,null,0,null,null,null,null,null,null,{"$f":"SUM(J42+H42+F42+D42+L42)","v":0}]
["Titanium Billet and end plates (new MVC housing)(purchased under award OCE 1514756)",null,null,0,null,null,null,null,null,null,null,null,{"$f":"SUM(J43+H43+F43+D43+L43)","v":0}]
["ODI Wet Mate Panel Connectors Refurbish x5",null,null,45000,null,null,null,null,null,null,null,null,45000]
["Data transport, data conv, timing connectors, supplies",null,null,15000,null,null,null,null,null,null,null,null,15000]
[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(D42:D51)","v":60000},null,{"$f":"SUM(F42:F51)","v":0},null,{"$f":"SUM(H42:H51)","v":0},null,{"$f":"SUM(J42:J51)","v":0},null,{"$f":"SUM(L42:L51)","v":0},{"$f":"SUM(L52,J52,H52,F52,D52)","v":60000}]
["TRAVEL"]
["Travel - Domestic",null,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["Travel - Foreign",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,J55,H55,F55,D55)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D54:D55)","v":0},null,{"$f":"SUM(F54:F55)","v":0},null,{"$f":"SUM(H54:H55)","v":0},null,{"$f":"SUM(J54:J55)","v":0},null,{"$f":"SUM(L54:L55)","v":0},{"$f":"SUM(L56,J56,H56,F56,D56)","v":0}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L61,J61,H61,F61,D61)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D58:D61)","v":0},null,{"$f":"SUM(F58:F61)","v":0},null,{"$f":"SUM(H58:H61)","v":0},null,{"$f":"SUM(J58:J61)","v":0},null,{"$f":"SUM(L58:L61)","v":0},{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["MATERIALS & SUPPLIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L64,J64,H64,F64,D64)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L65,J65,H65,F65,D65)","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(D64:D73)","v":0},null,{"$f":"SUM(F64:F73)","v":0},null,{"$f":"SUM(H64:H73)","v":0},null,{"$f":"SUM(J64:J73)","v":0},null,{"$f":"SUM(L64:L73)","v":0},{"$f":"SUM(L74,J74,H74,F74,D74)","v":0}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L76,J76,H76,F76,D76)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L77,J77,H77,F77,D77)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D76)","v":0},null,{"$f":"SUM(F76)","v":0},null,{"$f":"SUM(H76:H76)","v":0},null,{"$f":"SUM(J76:J76)","v":0},null,{"$f":"SUM(L76:L76)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["OUTSIDE SERVICES"]
[null,null,null,0,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,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 Outside Services",null,null,{"$f":"SUM(D80:D84)","v":0},null,{"$f":"SUM(F80:F84)","v":0},null,{"$f":"SUM(H80:H84)","v":0},null,{"$f":"SUM(J80:J84)","v":0},null,{"$f":"SUM(L80:L84)","v":0},0]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L88,J88,H88,F88,D88)","v":0}]
[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,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(D87:D96)","v":0},null,{"$f":"SUM(F87:F96)","v":0},null,{"$f":"SUM(H87:H96)","v":0},null,{"$f":"SUM(J87:J96)","v":0},null,{"$f":"SUM(L87:L96)","v":0},{"$f":"SUM(L97,J97,H97,F97,D97)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B35","v":25000},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":13125},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(L99,J99,H99,F99,D99)","v":13125}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B101*C101","v":0},null,{"$f":"29500*E101","v":0},null,{"$f":"29500*G101","v":0},null,{"$f":"29500*I101","v":0},null,{"$f":"29500*K101","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,0,{"$f":"B102*C102","v":0},null,{"$f":"16900*E102","v":0},null,{"$f":"16900*G102","v":0},null,{"$f":"16900*I102","v":0},null,{"$f":"16900*K102","v":0},{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
[null,null,0,{"$f":"B103*C103","v":0},0,{"$f":"'Projected Ship Rates'!D12*E103","v":0},0,{"$f":"'Projected Ship Rates'!E12*G103","v":0},0,{"$f":"'Projected Ship Rates'!F12*I103","v":0},0,{"$f":"'Projected Ship Rates'!G12*K103","v":0},{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
[null,null,null,{"$f":"B104*C104","v":0},null,{"$f":"B104*E104","v":0},null,{"$f":"B104*G104","v":0},null,{"$f":"B104*I104","v":0},null,{"$f":"B104*K104","v":0},{"$f":"SUM(L104,J104,H104,F104,D104)","v":0}]
["Total Ship Time",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}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,null,{"$f":"(C107*'Salary Worksheet'!D31)","v":0},null,{"$f":"(E107*'Salary Worksheet'!E31)","v":0},null,{"$f":"(G107*'Salary Worksheet'!F31)","v":0},0,{"$f":"(I107*'Salary Worksheet'!G31)","v":0},0,{"$f":"(K107*'Salary Worksheet'!H31)","v":0},{"$f":"SUM(L107,J107,H107,F107,D107)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C108*'Salary Worksheet'!D32)","v":0},0,{"$f":"(E108*'Salary Worksheet'!E32)","v":0},0,{"$f":"(G108*'Salary Worksheet'!F32)","v":0},0,{"$f":"(I108*'Salary Worksheet'!G32)","v":0},0,{"$f":"(K108*'Salary Worksheet'!H32)","v":0},{"$f":"SUM(L108,J108,H108,F108,D108)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D107:D108)","v":0},null,{"$f":"SUM(F107:F108)","v":0},null,{"$f":"SUM(H107:H108)","v":0},null,{"$f":"SUM(J107:J108)","v":0},null,{"$f":"SUM(L107:L108)","v":0},{"$f":"SUM(L109,J109,H109,F109,D109)","v":0}]
["SHIPPING"]
["UW to/from",null,null,5000,null,null,null,null,null,null,null,null,{"$f":"SUM(L111,J111,H111,F111,D111)","v":5000}]
["Total Shipping",null,null,{"$f":"SUM(D111)","v":5000},null,{"$f":"SUM(F111)","v":0},null,{"$f":"SUM(H111:H111)","v":0},null,{"$f":"SUM(J111:J111)","v":0},null,{"$f":"SUM(L111:L111)","v":0},5000]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D112,D109,D105,D97,D85,D78,D74,D62,D56,D52,D40)","v":190597.42300000001},null,{"$f":"SUM(F112,F109,F105,F97,F85,F78,F74,F62,F56,F52,F40)","v":47243.155889999995},null,{"$f":"SUM(H112,H109,H105,H97,H85,H78,H74,H62,H56,H52,H40)","v":0},null,{"$f":"SUM(J112,J109,J105,J97,J85,J78,J74,J62,J56,J52,J40)","v":0},null,{"$f":"SUM(L112,L109,L105,L97,L85,L78,L74,L62,L56,L52,L40)","v":0},237840.57889]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D114-D102-D101-D97+D98-D62-D52-D105","v":155597.42300000001},null,{"$f":"F114-F102-F101-F97+F98-F62-F52","v":47243.155889999995},null,{"$f":"H114-H102-H101-H97+H98-H62-H52","v":0},null,{"$f":"J114-J102-J101-J97+J98-J62-J52","v":0},null,{"$f":"L114-L102-L101-L97+L98-L62-L52","v":0},202840.57889]
["TOTAL INDIRECT COSTS",null,0,{"$f":"ROUND(D115*$C$116,0)","v":0},null,{"$f":"ROUND(F115*$C$116,0)","v":0},null,{"$f":"ROUND(H115*$C$116,0)","v":0},null,0,null,0,0]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D116+D114","v":190597.42300000001},null,{"$f":"+F116+F114","v":47243.155889999995},null,{"$f":"+H116+H114","v":0},null,{"$f":"+J116+J114","v":0},null,{"$f":"+L116+L114","v":0},237840.57889]

{"sheet":"MARS Budget","index":3,"n_rows":117,"n_cols":13,"rows_kept":117,"cut":false,"hidden":false,"merged":[[108,0,108,1],[111,0,111,1],[114,0,114,2],[85,0,85,1],[96,0,96,1],[97,0,97,1],[98,0,98,1],[104,0,104,1],[105,0,105,1],[84,0,84,1],[40,0,40,1],[51,0,51,1],[52,0,52,1],[55,0,55,1],[56,0,56,1],[61,0,61,1],[62,0,62,1],[73,0,73,1],[74,0,74,1],[77,0,77,1],[78,0,78,1],[39,0,39,1],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[8,0,8,1],[19,0,19,1],[30,0,30,1],[31,0,31,1],[38,0,38,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]]}
["MARS Renewal 2021-2026",null,null,null,null,null,null,null,null,null,null,"Updated:",{"$f":"TODAY()","v":"2021-06-01"}]
[null,null,"03/01/21-02/28/22",null,"03/01/22-02/28/23",null,"03/01/23-02/28/24",null,"03/01/24-02/28/25",null,"03/01/25-02/28/26"]
["TOTAL",null,{"$f":"D117","v":1067131.4145},null,{"$f":"F117","v":560200.68496500002},null,{"$f":"H117","v":507930.43},null,{"$f":"J117","v":906971.63719000004},null,{"$f":"L117","v":772369.62662500003},null,{"$f":"M117","v":3814603.7932800003}]
["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":"Mike Kelly"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D18*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*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'!D20*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*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":0},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":0}]
[{"$f":"'Salary Worksheet'!B7","v":"Craig Dawe"},null,5,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D21*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":79488},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E21*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F21*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G21*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H21*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":79488}]
[{"$f":"'Salary Worksheet'!B8","v":"MARS Operations Manager"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":0},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":63590},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":65497.67},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":67462.67},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":69486.67},266037.01]
[{"$f":"'Salary Worksheet'!B9","v":"Dave French"},null,1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":9487},0.67,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":6547.13},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":20130},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":20733.830000000002},2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":21355.83},78253.790000000008]
[{"$f":"'Salary Worksheet'!B10","v":"Paul McGill"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":4073},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":16779.919999999998},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":17283.330000000002},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":17801.830000000002},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":18335.919999999998},74274]
[{"$f":"'Salary Worksheet'!B11","v":"Ed Mellinger"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":3798},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},3798]
[{"$f":"'Salary Worksheet'!B12","v":"Rich Schramm"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C15,2), ROUND('Salary Worksheet'!D12/12*C15,0))","v":3598},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E15,2), ROUND('Salary Worksheet'!E12/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G15,2), ROUND('Salary Worksheet'!F12/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I15,2), ROUND('Salary Worksheet'!G12/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K15,2), ROUND('Salary Worksheet'!H12/12*K15,2))","v":0},3598]
[{"$f":"'Salary Worksheet'!B13","v":"Mike Risi"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C16,2), ROUND('Salary Worksheet'!D13/12*C16,0))","v":3732},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E16,2), ROUND('Salary Worksheet'!E13/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G16,2), ROUND('Salary Worksheet'!F13/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I16,2), ROUND('Salary Worksheet'!G13/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K16,2), ROUND('Salary Worksheet'!H13/12*K16,2))","v":0},3732]
[{"$f":"'Salary Worksheet'!B14","v":"Jon Erickson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C17,2), ROUND('Salary Worksheet'!D14/12*C17,0))","v":3511},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E17,2), ROUND('Salary Worksheet'!E14/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G17,2), ROUND('Salary Worksheet'!F14/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I17,2), ROUND('Salary Worksheet'!G14/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K17,2), ROUND('Salary Worksheet'!H14/12*K17,2))","v":0},3511]
[{"$f":"'Salary Worksheet'!B15","v":"Ray Thompson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D29*C18,2), ROUND('Salary Worksheet'!D15/12*C18,0))","v":2525},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E29*E18,2), ROUND('Salary Worksheet'!E15/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F29*G18,2), ROUND('Salary Worksheet'!F15/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G29*I18,2), ROUND('Salary Worksheet'!G15/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H29*K18,2), ROUND('Salary Worksheet'!H15/12*K18,2))","v":0},2525]
[{"$f":"'Salary Worksheet'!B16","v":"Duane Thompson"},null,2.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C19,2), ROUND('Salary Worksheet'!D16/12*C19,0))","v":23669},3,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E19,2), ROUND('Salary Worksheet'!E16/12*E19,2))","v":31390},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G19,2), ROUND('Salary Worksheet'!F16/12*G19,2))","v":43109},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I19,2), ROUND('Salary Worksheet'!G16/12*I19,2))","v":44402.33},4,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K19,2), ROUND('Salary Worksheet'!H16/12*K19,2))","v":45734.33},188304.66]
["Subtotal Other Employee Salary",null,null,{"$f":"SUM(D10:D19)","v":133881},null,{"$f":"SUM(F10:F19)","v":118307.05},null,{"$f":"SUM(H10:H19)","v":146020},null,{"$f":"SUM(J10:J19)","v":150400.66},null,{"$f":"SUM(L10:L19)","v":154912.75},{"$f":"SUM(J20+H20+F20+D20+L20)","v":703521.46}]
["POSTDOCS, GSRs, PART-TIME, TEMPS"]
[]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C23,2), ROUND('Salary Worksheet'!D27/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E23,2), ROUND('Salary Worksheet'!E27/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G23,2), ROUND('Salary Worksheet'!F27/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I23,2), ROUND('Salary Worksheet'!G27/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K23,2), ROUND('Salary Worksheet'!H27/12*K23,0))","v":0},{"$f":"SUM(J23+H23+F23+D23+L23)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C24,2), ROUND('Salary Worksheet'!D29/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E24,2), ROUND('Salary Worksheet'!E29/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G24,2), ROUND('Salary Worksheet'!F29/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I24,2), ROUND('Salary Worksheet'!G29/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K24,2), ROUND('Salary Worksheet'!H29/12*K24,0))","v":0},0]
["NA PT (30-39 hrs)",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},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E44*C26,2), ROUND('Salary Worksheet'!E37/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F44*E26,2), ROUND('Salary Worksheet'!F37/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G44*G26,2), ROUND('Salary Worksheet'!G37/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H44*I26,2), ROUND('Salary Worksheet'!H37/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I44*K26,2), ROUND('Salary Worksheet'!I37/12*K26,0))","v":0},{"$f":"SUM(J26+H26+F26+D26+L26)","v":0}]
["Part-time (<= 29 hrs/wk) 1",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]
["Part-time (<= 29 hrs/wk) 2",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}]
["Temporary Employee 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]
["Temporary Employee 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}]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D20:D29)","v":133881},null,{"$f":"SUM(F20:F29)","v":118307.05},null,{"$f":"SUM(H20:H29)","v":146020},null,{"$f":"SUM(J20:J29)","v":150400.66},null,{"$f":"SUM(L20:L29)","v":154912.75},703521.46]
["Total Salary & Wages",null,null,{"$f":"SUM(D31+D9)","v":133881},null,{"$f":"SUM(F31+F9)","v":118307.05},null,{"$f":"SUM(H31+H9)","v":146020},null,{"$f":"SUM(J31+J9)","v":150400.66},null,{"$f":"SUM(L31+L9)","v":154912.75},703521.46]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D20)*$B$34)","v":76512.991500000004},null,{"$f":"((F9+F20)*$B$34)","v":67612.479074999996},null,{"$f":"((H9+H20)*$B$34)","v":83450.430000000008},null,{"$f":"((J9+J20)*$B$34)","v":85953.977190000005},null,{"$f":"((L9+L20)*$B$34)","v":88532.636624999999},{"$f":"SUM(J34+H34+F34+D34+L34)","v":402062.51438999997}]
["PostDoc",0.4123,null,{"$f":"D23*$B$35","v":0},null,{"$f":"F23*$B$35","v":0},null,{"$f":"H23*$B$35","v":0},null,{"$f":"J23*$B$35","v":0},null,{"$f":"L23*$B$35","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D25:D26))*$B$36","v":0},null,{"$f":"(SUM(F25:F26)*$B$36)","v":0},null,{"$f":"(SUM(H25:H26)*$B$36)","v":0},null,{"$f":"(SUM(J25:J26)*$B$36)","v":0},null,{"$f":"(SUM(L25:L26)*$B$36)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D24,D27,D28))*$B$37","v":0},null,{"$f":"(SUM(F24,F27,F28))*$B$37","v":0},null,{"$f":"(SUM(H24,H27,H28))*$B$37","v":0},null,{"$f":"(SUM(J24,J27,J28))*$B$37","v":0},null,{"$f":"(SUM(L24,L27,L28))*$B$37","v":0},0]
["Temp",0.1111,null,{"$f":"(D29+D30)*$B$38","v":0},null,{"$f":"(F29+F30)*$B$38","v":0},null,{"$f":"(H29+H30)*$B$38","v":0},null,{"$f":"(J29+J30)*$B$38","v":0},null,{"$f":"(L29+L30)*$B$38","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D34:D38)","v":76512.991500000004},null,{"$f":"SUM(F34:F38)","v":67612.479074999996},null,{"$f":"SUM(H34:H38)","v":83450.430000000008},null,{"$f":"SUM(J34:J38)","v":85953.977190000005},null,{"$f":"SUM(L34:L38)","v":88532.636624999999},402062.51438999997]
["Total Salary & Benefits",null,null,{"$f":"SUM(D39,D32)","v":210393.9915},null,{"$f":"SUM(F39,F32)","v":185919.529075},null,{"$f":"SUM(H39,H32)","v":229470.43},null,{"$f":"SUM(J39,J32)","v":236354.63719000001},null,{"$f":"SUM(L39,L32)","v":243445.38662499998},1105583.9743899999]
["CAPITAL EQUIPMENT  (items >$5K)"]
["Computer Hardware",null,null,7500,null,7500,null,null,null,null,null,null,{"$f":"SUM(J42+H42+F42+D42+L42)","v":15000}]
["CIP: MARS Node Upgrade",null,null,{"$f":"'CIP MARS Node Upgrade'!D117","v":620597.42299999995},null,{"$f":"'CIP MARS Node Upgrade'!F117","v":47243.155889999995},null,null,null,null,null,null,{"$f":"SUM(J43+H43+F43+D43+L43)","v":667840.57889}]
[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(D42:D51)","v":628097.42299999995},null,{"$f":"SUM(F42:F51)","v":54743.155889999995},null,{"$f":"SUM(H42:H51)","v":0},null,{"$f":"SUM(J42:J51)","v":0},null,{"$f":"SUM(L42:L51)","v":0},{"$f":"SUM(L52,J52,H52,F52,D52)","v":682840.57889}]
["TRAVEL"]
["Travel - Domestic",null,null,1000,null,1000,null,1000,null,1000,null,1000,{"$f":"SUM(L54,J54,H54,F54,D54)","v":5000}]
["Travel - Foreign",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,J55,H55,F55,D55)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D54:D55)","v":1000},null,{"$f":"SUM(F54:F55)","v":1000},null,{"$f":"SUM(H54:H55)","v":1000},null,{"$f":"SUM(J54:J55)","v":1000},null,{"$f":"SUM(L54:L55)","v":1000},{"$f":"SUM(L56,J56,H56,F56,D56)","v":5000}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L61,J61,H61,F61,D61)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D58:D61)","v":0},null,{"$f":"SUM(F58:F61)","v":0},null,{"$f":"SUM(H58:H61)","v":0},null,{"$f":"SUM(J58:J61)","v":0},null,{"$f":"SUM(L58:L61)","v":0},{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["MATERIALS & SUPPLIES"]
["Supplies computer hardware",null,null,750,null,750,null,750,null,750,null,750,{"$f":"SUM(L64,J64,H64,F64,D64)","v":3750}]
["Computer software",null,null,200,null,200,null,200,null,200,null,200,{"$f":"SUM(L65,J65,H65,F65,D65)","v":1000}]
["Non-Cap Equipment",null,null,4500,null,4500,null,4500,null,4500,null,4500,22500]
["Supplies General",null,null,2000,null,2000,null,2000,null,2000,null,2000,10000]
[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(D64:D73)","v":7450},null,{"$f":"SUM(F64:F73)","v":7450},null,{"$f":"SUM(H64:H73)","v":7450},null,{"$f":"SUM(J64:J73)","v":7450},null,{"$f":"SUM(L64:L73)","v":7450},{"$f":"SUM(L74,J74,H74,F74,D74)","v":37250}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L76,J76,H76,F76,D76)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L77,J77,H77,F77,D77)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D76)","v":0},null,{"$f":"SUM(F76)","v":0},null,{"$f":"SUM(H76:H76)","v":0},null,{"$f":"SUM(J76:J76)","v":0},null,{"$f":"SUM(L76:L76)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["OUTSIDE SERVICES"]
["Router/Switch maintenance",null,null,1800,null,1854,null,1910,null,1967,null,2026,{"$f":"SUM(L80,J80,H80,F80,D80)","v":9557}]
["Software/Hardware maintenance UW",null,null,null,null,43000,null,44290,null,45619,null,46987,179896]
["Right of way MLHD",null,null,1460,null,1504,null,1549,null,1595,null,1643.24,7751.24]
["Linda Kuhnz Actual Impacts Assesment (AIA)",null,null,null,null,null,null,null,null,31150,null,null,31150]
["ABA Consultants Sample processing for AIA",null,null,null,null,null,null,null,null,24600,null,null,24600]
["Total Outside Services",null,null,{"$f":"SUM(D80:D84)","v":3260},null,{"$f":"SUM(F80:F84)","v":46358},null,{"$f":"SUM(H80:H84)","v":47749},null,{"$f":"SUM(J80:J84)","v":104931},null,{"$f":"SUM(L80:L84)","v":50656.24},252954.23999999999]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L88,J88,H88,F88,D88)","v":0}]
[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,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(D87:D96)","v":0},null,{"$f":"SUM(F87:F96)","v":0},null,{"$f":"SUM(H87:H96)","v":0},null,{"$f":"SUM(J87:J96)","v":0},null,{"$f":"SUM(L87:L96)","v":0},{"$f":"SUM(L97,J97,H97,F97,D97)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B35","v":25000},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":13125},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(L99,J99,H99,F99,D99)","v":13125}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B101*C101","v":0},null,{"$f":"29500*E101","v":0},null,{"$f":"29500*G101","v":0},null,{"$f":"29500*I101","v":0},null,{"$f":"29500*K101","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,0,{"$f":"B102*C102","v":0},null,{"$f":"16900*E102","v":0},null,{"$f":"16900*G102","v":0},null,{"$f":"16900*I102","v":0},null,{"$f":"16900*K102","v":0},{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
["Rachel Carson w Ventana",{"$f":"'Projected Ship Rates'!C12","v":21800},4,{"$f":"B103*C103","v":87200},4,{"$f":"'Projected Ship Rates'!D12*E103","v":90720},2,{"$f":"'Projected Ship Rates'!E12*G103","v":47400},10,{"$f":"'Projected Ship Rates'!F12*I103","v":245000},8,{"$f":"'Projected Ship Rates'!G12*K103","v":203920},{"$f":"SUM(L103,J103,H103,F103,D103)","v":674240}]
[null,null,null,{"$f":"B104*C104","v":0},null,{"$f":"B104*E104","v":0},null,{"$f":"B104*G104","v":0},null,{"$f":"B104*I104","v":0},null,{"$f":"B104*K104","v":0},{"$f":"SUM(L104,J104,H104,F104,D104)","v":0}]
["Total Ship Time",null,null,{"$f":"SUM(D103:D104)","v":87200},null,{"$f":"SUM(F103:F104)","v":90720},null,{"$f":"SUM(H103:H104)","v":47400},null,{"$f":"SUM(J103:J104)","v":245000},null,{"$f":"SUM(L103:L104)","v":203920},{"$f":"SUM(L105,J105,H105,F105,D105)","v":674240}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,null,{"$f":"(C107*'Salary Worksheet'!D31)","v":0},null,{"$f":"(E107*'Salary Worksheet'!E31)","v":0},null,{"$f":"(G107*'Salary Worksheet'!F31)","v":0},0,{"$f":"(I107*'Salary Worksheet'!G31)","v":0},0,{"$f":"(K107*'Salary Worksheet'!H31)","v":0},{"$f":"SUM(L107,J107,H107,F107,D107)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C108*'Salary Worksheet'!D32)","v":0},0,{"$f":"(E108*'Salary Worksheet'!E32)","v":0},0,{"$f":"(G108*'Salary Worksheet'!F32)","v":0},0,{"$f":"(I108*'Salary Worksheet'!G32)","v":0},0,{"$f":"(K108*'Salary Worksheet'!H32)","v":0},{"$f":"SUM(L108,J108,H108,F108,D108)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D107:D108)","v":0},null,{"$f":"SUM(F107:F108)","v":0},null,{"$f":"SUM(H107:H108)","v":0},null,{"$f":"SUM(J107:J108)","v":0},null,{"$f":"SUM(L107:L108)","v":0},{"$f":"SUM(L109,J109,H109,F109,D109)","v":0}]
["SHIPPING"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L111,J111,H111,F111,D111)","v":0}]
["Total Shipping",null,null,{"$f":"SUM(D111)","v":0},null,{"$f":"SUM(F111)","v":0},null,{"$f":"SUM(H111:H111)","v":0},null,{"$f":"SUM(J111:J111)","v":0},null,{"$f":"SUM(L111:L111)","v":0},0]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D112,D109,D105,D97,D85,D78,D74,D62,D56,D52,D40)","v":937401.41449999996},null,{"$f":"SUM(F112,F109,F105,F97,F85,F78,F74,F62,F56,F52,F40)","v":386190.68496500002},null,{"$f":"SUM(H112,H109,H105,H97,H85,H78,H74,H62,H56,H52,H40)","v":333069.43},null,{"$f":"SUM(J112,J109,J105,J97,J85,J78,J74,J62,J56,J52,J40)","v":594735.63719000004},null,{"$f":"SUM(L112,L109,L105,L97,L85,L78,L74,L62,L56,L52,L40)","v":506471.62662499998},2757868.7932799999]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D114-D102-D101-D97+D98-D62-D52-D105","v":247103.9915},null,{"$f":"F114-F102-F101-F97+F98-F62-F52","v":331447.52907500003},null,{"$f":"H114-H102-H101-H97+H98-H62-H52","v":333069.43},null,{"$f":"J114-J102-J101-J97+J98-J62-J52","v":594735.63719000004},null,{"$f":"L114-L102-L101-L97+L98-L62-L52","v":506471.62662499998},2012828.2143899999]
["TOTAL INDIRECT COSTS",null,0.52500000000000002,{"$f":"ROUND(D115*$C$116,0)","v":129730},null,{"$f":"ROUND(F115*$C$116,0)","v":174010},null,{"$f":"ROUND(H115*$C$116,0)","v":174861},null,312236,null,265898,1056735]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D116+D114","v":1067131.4145},null,{"$f":"+F116+F114","v":560200.68496500002},null,{"$f":"+H116+H114","v":507930.43},null,{"$f":"+J116+J114","v":906971.63719000004},null,{"$f":"+L116+L114","v":772369.62662500003},3814603.7932800003]

{"sheet":"CIP MARS Node Upgrade","index":4,"n_rows":117,"n_cols":13,"rows_kept":117,"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],[114,0,114,2],[38,0,38,1],[39,0,39,1],[30,0,30,1],[8,0,8,1],[51,0,51,1],[31,0,31,1],[55,0,55,1],[61,0,61,1],[73,0,73,1],[77,0,77,1],[84,0,84,1],[56,0,56,1],[19,0,19,1],[104,0,104,1],[108,0,108,1],[111,0,111,1],[0,0,0,4],[74,0,74,1],[40,0,40,1],[52,0,52,1],[62,0,62,1],[78,0,78,1],[85,0,85,1],[105,0,105,1],[98,0,98,1],[97,0,97,1],[2,2,2,3],[2,4,2,5],[96,0,96,1],[2,0,2,1],[1,2,1,3]]}
["CIP: MARS Node Upgrade",null,null,null,null,null,null,null,null,null,null,"Updated:",{"$f":"TODAY()","v":"2021-06-01"}]
[null,null,"03/01/21-02/28/22",null,"03/01/22-02/28/23",null,"03/01/23-02/28/24",null,"03/01/24-02/28/25",null,"03/01/25-02/28/26"]
["TOTAL",null,{"$f":"D117","v":620597.42299999995},null,{"$f":"F117","v":47243.155889999995},null,{"$f":"H117","v":0},null,{"$f":"J117","v":0},null,{"$f":"L117","v":0},null,{"$f":"M117","v":667840.57889}]
["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":"Mike Kelly"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D18*C6,2), ROUND('Salary Worksheet'!D4/12*C6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E18*E6,2), ROUND('Salary Worksheet'!E4/12*E6,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F18*G6,2), ROUND('Salary Worksheet'!F4/12*G6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G18*I6,2), ROUND('Salary Worksheet'!G4/12*I6,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H18*K6,2), ROUND('Salary Worksheet'!H4/12*K6,0))","v":0},{"$f":"SUM(L6,J6,H6,F6,D6)","v":0}]
[null,null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D19*C7,2), ROUND('Salary Worksheet'!D5/12*C7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E19*E7,2), ROUND('Salary Worksheet'!E5/12*E7,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F19*G7,2), ROUND('Salary Worksheet'!F5/12*G7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G19*I7,2), ROUND('Salary Worksheet'!G5/12*I7,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H19*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'!D20*C8,2), ROUND('Salary Worksheet'!D6/12*C8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E20*E8,2), ROUND('Salary Worksheet'!E6/12*E8,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F20*G8,2), ROUND('Salary Worksheet'!F6/12*G8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G20*I8,2), ROUND('Salary Worksheet'!G6/12*I8,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H20*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":0},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":0}]
[{"$f":"'Salary Worksheet'!B7","v":"Craig Dawe"},null,2,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D21*C10,2), ROUND('Salary Worksheet'!D7/12*C10,0))","v":31795},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E21*E10,2), ROUND('Salary Worksheet'!E7/12*E10,2))","v":16374.42},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F21*G10,2), ROUND('Salary Worksheet'!F7/12*G10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G21*I10,2), ROUND('Salary Worksheet'!G7/12*I10,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H21*K10,2), ROUND('Salary Worksheet'!H7/12*K10,2))","v":0},{"$f":"SUM(L10+J10+H10+F10+D10)","v":48169.42}]
[{"$f":"'Salary Worksheet'!B8","v":"MARS Operations Manager"},null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D22*C11,2), ROUND('Salary Worksheet'!D8/12*C11,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E22*E11,2), ROUND('Salary Worksheet'!E8/12*E11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F22*G11,2), ROUND('Salary Worksheet'!F8/12*G11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G22*I11,2), ROUND('Salary Worksheet'!G8/12*I11,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H22*K11,2), ROUND('Salary Worksheet'!H8/12*K11,2))","v":0},0]
[{"$f":"'Salary Worksheet'!B9","v":"Dave French"},null,0.67,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D23*C12,2), ROUND('Salary Worksheet'!D9/12*C12,0))","v":6356},0.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E23*E12,2), ROUND('Salary Worksheet'!E9/12*E12,2))","v":3224.71},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F23*G12,2), ROUND('Salary Worksheet'!F9/12*G12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G23*I12,2), ROUND('Salary Worksheet'!G9/12*I12,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H23*K12,2), ROUND('Salary Worksheet'!H9/12*K12,2))","v":0},9580.7099999999991]
[{"$f":"'Salary Worksheet'!B10","v":"Paul McGill"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D24*C13,2), ROUND('Salary Worksheet'!D10/12*C13,0))","v":4073},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E24*E13,2), ROUND('Salary Worksheet'!E10/12*E13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F24*G13,2), ROUND('Salary Worksheet'!F10/12*G13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G24*I13,2), ROUND('Salary Worksheet'!G10/12*I13,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H24*K13,2), ROUND('Salary Worksheet'!H10/12*K13,2))","v":0},4073]
[{"$f":"'Salary Worksheet'!B11","v":"Ed Mellinger"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D25*C14,2), ROUND('Salary Worksheet'!D11/12*C14,0))","v":3798},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E25*E14,2), ROUND('Salary Worksheet'!E11/12*E14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F25*G14,2), ROUND('Salary Worksheet'!F11/12*G14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G25*I14,2), ROUND('Salary Worksheet'!G11/12*I14,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H25*K14,2), ROUND('Salary Worksheet'!H11/12*K14,2))","v":0},3798]
[{"$f":"'Salary Worksheet'!B12","v":"Rich Schramm"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D26*C15,2), ROUND('Salary Worksheet'!D12/12*C15,0))","v":3598},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E26*E15,2), ROUND('Salary Worksheet'!E12/12*E15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F26*G15,2), ROUND('Salary Worksheet'!F12/12*G15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G26*I15,2), ROUND('Salary Worksheet'!G12/12*I15,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H26*K15,2), ROUND('Salary Worksheet'!H12/12*K15,2))","v":0},3598]
[{"$f":"'Salary Worksheet'!B13","v":"Mike Risi"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D27*C16,2), ROUND('Salary Worksheet'!D13/12*C16,0))","v":3732},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E27*E16,2), ROUND('Salary Worksheet'!E13/12*E16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F27*G16,2), ROUND('Salary Worksheet'!F13/12*G16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G27*I16,2), ROUND('Salary Worksheet'!G13/12*I16,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H27*K16,2), ROUND('Salary Worksheet'!H13/12*K16,2))","v":0},3732]
[{"$f":"'Salary Worksheet'!B14","v":"Jon Erickson"},null,0.75,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C17,2), ROUND('Salary Worksheet'!D14/12*C17,0))","v":10534},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E17,2), ROUND('Salary Worksheet'!E14/12*E17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G17,2), ROUND('Salary Worksheet'!F14/12*G17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I17,2), ROUND('Salary Worksheet'!G14/12*I17,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K17,2), ROUND('Salary Worksheet'!H14/12*K17,2))","v":0},10534]
[{"$f":"'Salary Worksheet'!B15","v":"Ray Thompson"},null,0.25,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D29*C18,2), ROUND('Salary Worksheet'!D15/12*C18,0))","v":2525},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E29*E18,2), ROUND('Salary Worksheet'!E15/12*E18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F29*G18,2), ROUND('Salary Worksheet'!F15/12*G18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G29*I18,2), ROUND('Salary Worksheet'!G15/12*I18,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H29*K18,2), ROUND('Salary Worksheet'!H15/12*K18,2))","v":0},2525]
[{"$f":"'Salary Worksheet'!B16","v":"Duane Thompson"},null,1.33,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C19,2), ROUND('Salary Worksheet'!D16/12*C19,0))","v":13511},1,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E19,2), ROUND('Salary Worksheet'!E16/12*E19,2))","v":10463.33},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G19,2), ROUND('Salary Worksheet'!F16/12*G19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I19,2), ROUND('Salary Worksheet'!G16/12*I19,2))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K19,2), ROUND('Salary Worksheet'!H16/12*K19,2))","v":0},23974.33]
["Subtotal Other Employee Salary",null,null,{"$f":"SUM(D10:D19)","v":79922},null,{"$f":"SUM(F10:F19)","v":30062.46},null,{"$f":"SUM(H10:H19)","v":0},null,{"$f":"SUM(J10:J19)","v":0},null,{"$f":"SUM(L10:L19)","v":0},{"$f":"SUM(J20+H20+F20+D20+L20)","v":109984.45999999999}]
["POSTDOCS, GSRs, PART-TIME, TEMPS"]
[]
["PostDoc(s)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D28*C23,2), ROUND('Salary Worksheet'!D27/12*C23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E28*E23,2), ROUND('Salary Worksheet'!E27/12*E23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F28*G23,2), ROUND('Salary Worksheet'!F27/12*G23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G28*I23,2), ROUND('Salary Worksheet'!G27/12*I23,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H28*K23,2), ROUND('Salary Worksheet'!H27/12*K23,0))","v":0},{"$f":"SUM(J23+H23+F23+D23+L23)","v":0}]
["Graduate Student(s) (GSRs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!D30*C24,2), ROUND('Salary Worksheet'!D29/12*C24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E30*E24,2), ROUND('Salary Worksheet'!E29/12*E24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F30*G24,2), ROUND('Salary Worksheet'!F29/12*G24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G30*I24,2), ROUND('Salary Worksheet'!G29/12*I24,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H30*K24,2), ROUND('Salary Worksheet'!H29/12*K24,0))","v":0},0]
["NA PT (30-39 hrs)",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},0]
["NA PT (30-39 hrs)",null,0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!E44*C26,2), ROUND('Salary Worksheet'!E37/12*C26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!F44*E26,2), ROUND('Salary Worksheet'!F37/12*E26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!G44*G26,2), ROUND('Salary Worksheet'!G37/12*G26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!H44*I26,2), ROUND('Salary Worksheet'!H37/12*I26,0))","v":0},0,{"$f":"IF($C$4=1,ROUND('Salary Worksheet'!I44*K26,2), ROUND('Salary Worksheet'!I37/12*K26,0))","v":0},{"$f":"SUM(J26+H26+F26+D26+L26)","v":0}]
["Part-time (<= 29 hrs/wk) 1",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]
["Part-time (<= 29 hrs/wk) 2",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}]
["Temporary Employee 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]
["Temporary Employee 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}]
["Subtotal Other Personnel Salary",null,null,{"$f":"SUM(D20:D29)","v":79922},null,{"$f":"SUM(F20:F29)","v":30062.46},null,{"$f":"SUM(H20:H29)","v":0},null,{"$f":"SUM(J20:J29)","v":0},null,{"$f":"SUM(L20:L29)","v":0},109984.45999999999]
["Total Salary & Wages",null,null,{"$f":"SUM(D31+D9)","v":79922},null,{"$f":"SUM(F31+F9)","v":30062.46},null,{"$f":"SUM(H31+H9)","v":0},null,{"$f":"SUM(J31+J9)","v":0},null,{"$f":"SUM(L31+L9)","v":0},109984.45999999999]
["FRINGE BENEFITS"]
["Full-time (Regular)",0.57150000000000001,null,{"$f":"((D9+D20)*$B$34)","v":45675.423000000003},null,{"$f":"((F9+F20)*$B$34)","v":17180.695889999999},null,{"$f":"((H9+H20)*$B$34)","v":0},null,{"$f":"((J9+J20)*$B$34)","v":0},null,{"$f":"((L9+L20)*$B$34)","v":0},{"$f":"SUM(J34+H34+F34+D34+L34)","v":62856.118889999998}]
["PostDoc",0.4123,null,{"$f":"D23*$B$35","v":0},null,{"$f":"F23*$B$35","v":0},null,{"$f":"H23*$B$35","v":0},null,{"$f":"J23*$B$35","v":0},null,{"$f":"L23*$B$35","v":0},0]
["PT (30-39 hrs)",0.57150000000000001,null,{"$f":"(SUM(D25:D26))*$B$36","v":0},null,{"$f":"(SUM(F25:F26)*$B$36)","v":0},null,{"$f":"(SUM(H25:H26)*$B$36)","v":0},null,{"$f":"(SUM(J25:J26)*$B$36)","v":0},null,{"$f":"(SUM(L25:L26)*$B$36)","v":0},0]
["GSRs + PT (20-29 hrs)",0.30620000000000003,null,{"$f":"(SUM(D24,D27,D28))*$B$37","v":0},null,{"$f":"(SUM(F24,F27,F28))*$B$37","v":0},null,{"$f":"(SUM(H24,H27,H28))*$B$37","v":0},null,{"$f":"(SUM(J24,J27,J28))*$B$37","v":0},null,{"$f":"(SUM(L24,L27,L28))*$B$37","v":0},0]
["Temp",0.1111,null,{"$f":"(D29+D30)*$B$38","v":0},null,{"$f":"(F29+F30)*$B$38","v":0},null,{"$f":"(H29+H30)*$B$38","v":0},null,{"$f":"(J29+J30)*$B$38","v":0},null,{"$f":"(L29+L30)*$B$38","v":0},0]
["Total Fringe Benefits",null,null,{"$f":"SUM(D34:D38)","v":45675.423000000003},null,{"$f":"SUM(F34:F38)","v":17180.695889999999},null,{"$f":"SUM(H34:H38)","v":0},null,{"$f":"SUM(J34:J38)","v":0},null,{"$f":"SUM(L34:L38)","v":0},62856.118889999998]
["Total Salary & Benefits",null,null,{"$f":"SUM(D39,D32)","v":125597.42300000001},null,{"$f":"SUM(F39,F32)","v":47243.155889999995},null,{"$f":"SUM(H39,H32)","v":0},null,{"$f":"SUM(J39,J32)","v":0},null,{"$f":"SUM(L39,L32)","v":0},172840.57889]
["CAPITAL EQUIPMENT  (items >$5K)"]
["ODI Hybrid Test lead (purchased under award OCE 1514756)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J42+H42+F42+D42+L42)","v":0}]
["Titanium Billet and end plates (new MVC housing)(purchased under award OCE 1514756)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(J43+H43+F43+D43+L43)","v":0}]
["ODI Wet Mate Panel Connectors Refurbish x5",null,null,45000,null,null,null,null,null,null,null,null,45000]
["Data transport, data conv, timing connectors, supplies",null,null,15000,null,null,null,null,null,null,null,null,15000]
[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(D42:D51)","v":60000},null,{"$f":"SUM(F42:F51)","v":0},null,{"$f":"SUM(H42:H51)","v":0},null,{"$f":"SUM(J42:J51)","v":0},null,{"$f":"SUM(L42:L51)","v":0},{"$f":"SUM(L52,J52,H52,F52,D52)","v":60000}]
["TRAVEL"]
["Travel - Domestic",null,null,0,null,0,null,0,null,0,null,0,{"$f":"SUM(L54,J54,H54,F54,D54)","v":0}]
["Travel - Foreign",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L55,J55,H55,F55,D55)","v":0}]
["Total Travel",null,null,{"$f":"SUM(D54:D55)","v":0},null,{"$f":"SUM(F54:F55)","v":0},null,{"$f":"SUM(H54:H55)","v":0},null,{"$f":"SUM(J54:J55)","v":0},null,{"$f":"SUM(L54:L55)","v":0},{"$f":"SUM(L56,J56,H56,F56,D56)","v":0}]
["PARTICIPANT SUPPORT"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L58,J58,H58,F58,D58)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L59,J59,H59,F59,D59)","v":0}]
["Subsistence",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L60,J60,H60,F60,D60)","v":0}]
["Other",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L61,J61,H61,F61,D61)","v":0}]
["Total Participant Support",null,null,{"$f":"SUM(D58:D61)","v":0},null,{"$f":"SUM(F58:F61)","v":0},null,{"$f":"SUM(H58:H61)","v":0},null,{"$f":"SUM(J58:J61)","v":0},null,{"$f":"SUM(L58:L61)","v":0},{"$f":"SUM(L62,J62,H62,F62,D62)","v":0}]
["MATERIALS & SUPPLIES"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L64,J64,H64,F64,D64)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L65,J65,H65,F65,D65)","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(D64:D73)","v":0},null,{"$f":"SUM(F64:F73)","v":0},null,{"$f":"SUM(H64:H73)","v":0},null,{"$f":"SUM(J64:J73)","v":0},null,{"$f":"SUM(L64:L73)","v":0},{"$f":"SUM(L74,J74,H74,F74,D74)","v":0}]
["PUBLICATIONS/DOCUMENTATION"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L76,J76,H76,F76,D76)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L77,J77,H77,F77,D77)","v":0}]
["Total Publications",null,null,{"$f":"SUM(D76)","v":0},null,{"$f":"SUM(F76)","v":0},null,{"$f":"SUM(H76:H76)","v":0},null,{"$f":"SUM(J76:J76)","v":0},null,{"$f":"SUM(L76:L76)","v":0},{"$f":"SUM(L78,J78,H78,F78,D78)","v":0}]
["OUTSIDE SERVICES"]
["UW SPL build & install new low voltage electronics & control software",null,null,430000,null,null,null,null,null,null,null,null,{"$f":"SUM(L80,J80,H80,F80,D80)","v":430000}]
[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 Outside Services",null,null,{"$f":"SUM(D80:D84)","v":430000},null,{"$f":"SUM(F80:F84)","v":0},null,{"$f":"SUM(H80:H84)","v":0},null,{"$f":"SUM(J80:J84)","v":0},null,{"$f":"SUM(L80:L84)","v":0},430000]
["SUBAWARDS"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L87,J87,H87,F87,D87)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L88,J88,H88,F88,D88)","v":0}]
[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,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(D87:D96)","v":0},null,{"$f":"SUM(F87:F96)","v":0},null,{"$f":"SUM(H87:H96)","v":0},null,{"$f":"SUM(J87:J96)","v":0},null,{"$f":"SUM(L87:L96)","v":0},{"$f":"SUM(L97,J97,H97,F97,D97)","v":0}]
["Subawards subject to OH",null,null,{"$f":"'Subaward Worksheet'!B35","v":25000},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":13125},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(L99,J99,H99,F99,D99)","v":13125}]
["SHIP TIME","Rate","# Days",null,"# Days",null,"# Days",null,"# Days",null,"# Days"]
[null,null,0,{"$f":"B101*C101","v":0},null,{"$f":"29500*E101","v":0},null,{"$f":"29500*G101","v":0},null,{"$f":"29500*I101","v":0},null,{"$f":"29500*K101","v":0},{"$f":"SUM(L101,J101,H101,F101,D101)","v":0}]
[null,null,0,{"$f":"B102*C102","v":0},null,{"$f":"16900*E102","v":0},null,{"$f":"16900*G102","v":0},null,{"$f":"16900*I102","v":0},null,{"$f":"16900*K102","v":0},{"$f":"SUM(L102,J102,H102,F102,D102)","v":0}]
[null,null,0,{"$f":"B103*C103","v":0},0,{"$f":"'Projected Ship Rates'!D12*E103","v":0},0,{"$f":"'Projected Ship Rates'!E12*G103","v":0},0,{"$f":"'Projected Ship Rates'!F12*I103","v":0},0,{"$f":"'Projected Ship Rates'!G12*K103","v":0},{"$f":"SUM(L103,J103,H103,F103,D103)","v":0}]
[null,null,null,{"$f":"B104*C104","v":0},null,{"$f":"B104*E104","v":0},null,{"$f":"B104*G104","v":0},null,{"$f":"B104*I104","v":0},null,{"$f":"B104*K104","v":0},{"$f":"SUM(L104,J104,H104,F104,D104)","v":0}]
["Total Ship Time",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}]
["TUITION/FEES",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs.",null,"Qtrs."]
["UCSC Grad Student ",null,null,{"$f":"(C107*'Salary Worksheet'!D31)","v":0},null,{"$f":"(E107*'Salary Worksheet'!E31)","v":0},null,{"$f":"(G107*'Salary Worksheet'!F31)","v":0},0,{"$f":"(I107*'Salary Worksheet'!G31)","v":0},0,{"$f":"(K107*'Salary Worksheet'!H31)","v":0},{"$f":"SUM(L107,J107,H107,F107,D107)","v":0}]
["UCSC Grad Student - Nonres. ",null,0,{"$f":"(C108*'Salary Worksheet'!D32)","v":0},0,{"$f":"(E108*'Salary Worksheet'!E32)","v":0},0,{"$f":"(G108*'Salary Worksheet'!F32)","v":0},0,{"$f":"(I108*'Salary Worksheet'!G32)","v":0},0,{"$f":"(K108*'Salary Worksheet'!H32)","v":0},{"$f":"SUM(L108,J108,H108,F108,D108)","v":0}]
["Total Tuition/Fees",null,null,{"$f":"SUM(D107:D108)","v":0},null,{"$f":"SUM(F107:F108)","v":0},null,{"$f":"SUM(H107:H108)","v":0},null,{"$f":"SUM(J107:J108)","v":0},null,{"$f":"SUM(L107:L108)","v":0},{"$f":"SUM(L109,J109,H109,F109,D109)","v":0}]
["SHIPPING"]
["UW?",null,null,5000,null,null,null,null,null,null,null,null,{"$f":"SUM(L111,J111,H111,F111,D111)","v":5000}]
["Total Shipping",null,null,{"$f":"SUM(D111)","v":5000},null,{"$f":"SUM(F111)","v":0},null,{"$f":"SUM(H111:H111)","v":0},null,{"$f":"SUM(J111:J111)","v":0},null,{"$f":"SUM(L111:L111)","v":0},5000]
[]
["TOTAL DIRECT COSTS",null,null,{"$f":"SUM(D112,D109,D105,D97,D85,D78,D74,D62,D56,D52,D40)","v":620597.42299999995},null,{"$f":"SUM(F112,F109,F105,F97,F85,F78,F74,F62,F56,F52,F40)","v":47243.155889999995},null,{"$f":"SUM(H112,H109,H105,H97,H85,H78,H74,H62,H56,H52,H40)","v":0},null,{"$f":"SUM(J112,J109,J105,J97,J85,J78,J74,J62,J56,J52,J40)","v":0},null,{"$f":"SUM(L112,L109,L105,L97,L85,L78,L74,L62,L56,L52,L40)","v":0},667840.57889]
["MODIFIED TOTAL DIRECT COST BASE",null,null,{"$f":"D114-D102-D101-D97+D98-D62-D52-D105","v":585597.42299999995},null,{"$f":"F114-F102-F101-F97+F98-F62-F52","v":47243.155889999995},null,{"$f":"H114-H102-H101-H97+H98-H62-H52","v":0},null,{"$f":"J114-J102-J101-J97+J98-J62-J52","v":0},null,{"$f":"L114-L102-L101-L97+L98-L62-L52","v":0},632840.57889]
["TOTAL INDIRECT COSTS",null,0,{"$f":"ROUND(D115*$C$116,0)","v":0},null,{"$f":"ROUND(F115*$C$116,0)","v":0},null,{"$f":"ROUND(H115*$C$116,0)","v":0},null,0,null,0,0]
["TOTAL DIRECT & INDIRECT COSTS",null,null,{"$f":"+D116+D114","v":620597.42299999995},null,{"$f":"+F116+F114","v":47243.155889999995},null,{"$f":"+H116+H114","v":0},null,{"$f":"+J116+J114","v":0},null,{"$f":"+L116+L114","v":0},667840.57889]

{"sheet":"Salary Worksheet","index":5,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[[33,0,33,8],[48,0,48,8],[0,0,0,8],[25,0,25,8],[31,0,31,2],[30,0,30,2],[28,1,28,2],[26,1,26,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,"Mike Kelly",{"$f":"121.08*2080","v":251846.39999999999},{"$f":"ROUND(C4*($C$2+1),0)","v":259402},{"$f":"ROUND(D4*($C$2+1),0)","v":267184},{"$f":"ROUND(E4*($C$2+1),0)","v":275200},{"$f":"ROUND(F4*($C$2+1),0)","v":283456},{"$f":"ROUND(G4*($C$2+1),0)","v":291960}]
[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,"Craig Dawe",{"$f":"89.045*2080","v":185213.6},190770,{"$f":"ROUND(D7*($C$2+1),0)","v":196493},{"$f":"ROUND(E7*($C$2+1),0)","v":202388},{"$f":"ROUND(F7*($C$2+1),0)","v":208460},{"$f":"ROUND(G7*($C$2+1),0)","v":214714}]
[null,"MARS Operations Manager",185214,{"$f":"C8","v":185214},{"$f":"ROUND(D8*($C$2+1),0)","v":190770},196493,202388,208460]
[null,"Dave French",{"$f":"53.14*2080","v":110531.2},113847,117262,120780,124403,128135]
[null,"Paul McGill",{"$f":"91.25*2080","v":189800},195494,201359,207400,213622,220031]
[null,"Ed Mellinger",{"$f":"85.1*2080","v":177008},182318,187788,193422,199225,205202]
[null,"Rich Schramm",{"$f":"80.62*2080","v":167689.60000000001},172720,{"$f":"ROUND(D12*(C2+1),0)","v":177902},183239,188736,194398]
[null,"Mike Risi",{"$f":"83.62*2080","v":173929.60000000001},179147,{"$f":"ROUND(D13*(C2+1),0)","v":184521},190057,195759,201632]
[null,"Jon Erickson",{"$f":"78.67*2080","v":163633.60000000001},168543,{"$f":"ROUND(D14*(C2+1),0)","v":173599},178807,184171,189696]
[null,"Ray Thompson",{"$f":"56.57*2080","v":117665.60000000001},{"$f":"ROUND(C15*($C$2+1),0)","v":121196},{"$f":"ROUND(D15*(C2+1),0)","v":124832},128577,132434,136407]
[null,"Duane Thompson",{"$f":"56.9*2080","v":118352},121903,{"$f":"ROUND(D16*(C2+1),0)","v":125560},129327,133207,137203]
[null,null,"HOURLY RATE","YR-1","YR-2","YR-3","YR-4","YR-5"]
[null,null,0,{"$f":"C18","v":0},{"$f":"ROUND(D18*1.03, 2)","v":0},{"$f":"ROUND(E18*1.03, 2)","v":0},0,0]
[null,null,0,{"$f":"C19","v":0},{"$f":"ROUND(D19*1.03, 2)","v":0},0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,0,0,0,0,0,0]
[null,null,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":"F27*1.03","v":66950},{"$f":"G27*1.03","v":68958.5}]
[null,null,"Postdoc (Hourly)",{"$f":"D27/2080","v":28.846153846153847},{"$f":"E27/2080","v":30.28846153846154},{"$f":"F27/2080","v":31.25},{"$f":"G27/2080","v":32.1875},{"$f":"H27/2080","v":33.153125000000003}]
[null,"Graduate Students",null,30875,30875,30875,34450,34450]
[null,null,"Grad Student (Hourly)",23.75,23.75,23.75,26.5,26.5]
["UCSC Resident Tuition (per quarter)",null,null,6511,{"$f":"D31*1.07","v":6966.77},{"$f":"E31*1.07","v":7454.4439000000011},7976.2549730000019,8534.5928211100018]
["UCSC Non-Res Tuition (per quarter)",null,null,11897,12729.79,13620.875300000002,14574.336571000002,15594.540130970003]
[]
["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(C36*40*52,0)","v":0},{"$f":"ROUND(E36*(1+$C$2),0)","v":0},0,0,{"$f":"ROUND(H36*($C$2+1),0)","v":0}]
[null,"PT (30-39 hrs) 2",0,null,{"$f":"ROUND(C37*40*52,0)","v":0},0,0,0,{"$f":"ROUND(H37*($C$2+1),0)","v":0}]
[null,"PT (≤29 hrs) 1",0,null,{"$f":"ROUND(C38*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(E41*(1+$C$2),0)","v":0},{"$f":"ROUND(F41*(1+$C$2),0)","v":0},{"$f":"ROUND(G41*(1+$C$2),0)","v":0},{"$f":"ROUND(H41*($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":"C36","v":0},null,{"$f":"C36","v":0},{"$f":"E43*(1+$C$2)","v":0},{"$f":"F43*(1+$C$2)","v":0},0,0]
[null,"PT (30-39 hrs) 2",0,null,0,{"$f":"E44*(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":"E48*(1+$C$2)","v":0},{"$f":"F48*(1+$C$2)","v":0},{"$f":"G48*(1+$C$2)","v":0},{"$f":"H48*(1+$C$2)","v":0}]
["SALARY CALCULATOR"]
["Hours","Hours",null,"Hourly rate:",0,"Annual Salary:",{"$f":"ROUND(E50*40*52,0)","v":0}]
["Months","Months",null,"Monthly rate:",0,"Annual Salary:",{"$f":"ROUND(E51*12,0)","v":0}]
[null,null,null,"Annual Salary",0,"Hourly rate:",{"$f":"ROUND(E52/2080,2)","v":0}]

{"sheet":"Subaward Worksheet","index":6,"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":"'MARS Budget w UW subaward'!A96","v":"UW APL Subaward"},{"$f":"'MARS Budget w UW subaward'!D96","v":291756},{"$f":"'CIP MARS Node Upgrade'!$F$87","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$87","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$87","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$87","v":0},{"$f":"SUM(B4:F4)","v":291756}]
["Subject to OH",{"$f":"IF(B4>25000, 25000, B4)","v":25000},{"$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":25000}]
["OH",{"$f":"IF(B4>25000, 13125, (B4*0.51))","v":13125},{"$f":"IF(C4>25000, 13125, (C4*0.51))","v":0},{"$f":"IF(D4>25000, 13125, (D4*0.51))","v":0},{"$f":"IF(E4>25000, 13125, (E4*0.51))","v":0},{"$f":"IF(F4>25000, 13125, (F4*0.51))","v":0},13125]
[{"$f":"'CIP MARS Node Upgrade'!$A$88","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$88","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$88","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$88","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$88","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$88","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":"'CIP MARS Node Upgrade'!$A$89","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$89","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$89","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$89","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$89","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$89","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":"'CIP MARS Node Upgrade'!$A$90","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$90","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$90","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$90","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$90","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$90","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":"'CIP MARS Node Upgrade'!$A$91","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$91","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$91","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$91","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$91","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$91","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":"'CIP MARS Node Upgrade'!$A$92","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$92","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$92","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$92","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$92","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$92","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":"'CIP MARS Node Upgrade'!$A$93","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$93","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$93","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$93","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$93","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$93","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":"'CIP MARS Node Upgrade'!$A$94","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$94","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$94","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$94","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$94","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$94","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":"'CIP MARS Node Upgrade'!$A$95","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$95","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$95","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$95","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$95","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$95","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":"'CIP MARS Node Upgrade'!$A$96","v":0},{"$f":"'CIP MARS Node Upgrade'!$D$96","v":0},{"$f":"'CIP MARS Node Upgrade'!$F$96","v":0},{"$f":"'CIP MARS Node Upgrade'!$H$96","v":0},{"$f":"'CIP MARS Node Upgrade'!$J$96","v":0},{"$f":"'CIP MARS Node Upgrade'!$L$96","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":291756},{"$f":"SUM(C31,C28,C22,C19,C16,C13,C10,C7,C4)","v":0},0,0,0,{"$f":"SUM(B34:F34)","v":291756}]
["Total Subject to OH",{"$f":"SUM(B32,B29,B26,B23,B20,B17,B14,B11,B8,B5)","v":25000},{"$f":"SUM(C32,C29,C26,C23,C20,C17,C14,C11,C8,C5)","v":0},0,0,0,{"$f":"SUM(B35:F35)","v":25000}]
["Total Overhead",{"$f":"SUM(B33,B30,B27,B24,B21,B18,B15,B12,B9,B6)","v":13125},{"$f":"SUM(C33,C30,C27,C24,C21,C18,C15,C12,C9,C6)","v":0},0,0,0,13125]
[]
["pw: edit"]

{"sheet":"Projected Ship Rates","index":7,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Asset",2020,2021,2022,2023,2024,2025]
["Rachel Carson",13385,13885,14405,15180,15750,16350]
["Rachel Carson 12",14660,15200,15780,16600,17200,17890]
["Ventana",6400,6600,6900,7100,7300,7600]
["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},{"$f":"C3+C4","v":21800},22680,23700,24500,25490]
[null,null," "]
[]
[null,null,{"$f":"C3*4","v":60800}]
[null,null,{"$f":"C4*4","v":26400}]

{"sheet":"Craig's Worksheet","index":8,"n_rows":85,"n_cols":22,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"MARS O&M Operational Costs Mar 1 2021 - February 28 2026"]
[]
["Item",null,null,null,"Yr 1",null,"Yr 2",null,"Yr 3",null,"Yr 4",null,"Yr 5",null,"Item"]
[null,null,null,null,"months","cost","months","cost","months","cost","months","cost","months","cost"]
["Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personnel"]
[null,"Kelly",null,null,2,0,2,0,2,{"$f":"I6*4.5*80*R6","v":0},2,0,2,0]
[null,"Dawe",null,null,5,{"$f":"E7*4.5*40*R7","v":80136},4,{"$f":"G7*4.5*40*S7","v":66032.063999999998},4,{"$f":"I7*4.5*40*T7","v":68013.02592},4,{"$f":"K7*4.5*40*U7","v":70053.416697599998},4,{"$f":"M7*4.5*40*V7","v":72155.019198527996},null,"Dawe",null,89.04,{"$f":"R7+R7*0.03","v":91.711200000000005},94.462536,97.296412079999996,100.2153044424]
[null,"Thompson",null,null,2.33,27596.519999999997,3,36597.96,4,{"$f":"I8*4.5*40*T8","v":50261.198400000001},4,{"$f":"K8*4.5*40*U8","v":51769.034351999995},4,{"$f":"M8*4.5*40*V8","v":53322.105382560003},null,"Thompson",null,65.8,67.774000000000001,69.807220000000001,71.901436599999997,74.058479697999999]
[null,"French",null,null,1,12600,0.66700000000000004,8656.3259999999991,2,{"$f":"I9*4.5*40*T9","v":26734.679999999997},2,{"$f":"K9*4.5*40*U9","v":27536.720399999998},2,{"$f":"M9*4.5*40*V9","v":28362.822011999997},null,"French",null,70,72.099999999999994,74.262999999999991,76.490889999999993,78.785616699999991]
[null,"McGill/Mellinger",null,null,0.5,8377.2000000000007,null,0,null,null,null,null,null,null,null,"McGill/Mellinger",null,93.08,95.872399999999999,98.748571999999996,101.71102916,104.7623600348]
[null,"Schram/Risi",null,null,0.5,8377.2000000000007,null,0,null,null,null,null,null,null,null,"Schram/Risi",null,93.08,95.872399999999999,98.748571999999996,101.71102916,104.7623600348]
[null,"Erikson",null,null,0.25,3722.8500000000004,null,0,null,null,null,null,null,null,null,"Erikson",null,82.73,85.2119,87.768257000000006,90.401304710000005,93.113343851300002]
[null,"R Thompson",null,null,0.25,2596.9499999999998,null,0,null,null,null,null,null,null,null,"R Thompson",null,57.71,59.441299999999998,61.224539,63.061275170000002,64.9531134251]
[null,"Enginering support",null,null,null,null,1,15017.400000000001,1,{"$f":"I14*4.5*40*T14","v":15467.922},1,{"$f":"K14*4.5*40*U14","v":15931.959659999999},1,{"$f":"M14*4.5*40*V14","v":16409.9184498},null,"Enginering support",null,81,83.43,85.932900000000004,88.510886999999997,91.16621361]
[null,"total man months",null,null,{"$f":"SUM(E7:E14)","v":9.83},null,{"$f":"SUM(G7:G14)","v":8.6669999999999998},null,{"$f":"SUM(I7:I14)","v":11},null,{"$f":"SUM(K7:K14)","v":11},null,{"$f":"SUM(M7:M14)","v":11},null,null,"total man months"]
["total Labor",null,null,null,null,{"$f":"SUM(F7:F14)","v":143406.72},null,{"$f":"SUM(H7:H14)","v":126303.75},null,{"$f":"SUM(J7:J14)","v":160476.82631999999},null,{"$f":"SUM(L7:L14)","v":165291.13110959998},null,{"$f":"SUM(N7:N14)","v":170249.86504288798},null,null,{"$f":"SUM(F16:O16)","v":765728.2924724879}]
["Fringe Benefits"]
[null,null,null,null,null,{"$f":"SUM(F6:F14)*0.56","v":80307.763200000001},null,{"$f":"SUM(H6:H14)*0.56","v":70730.100000000006},null,{"$f":"SUM(J6:J14)*0.56","v":89867.022739200009},null,{"$f":"SUM(L6:L14)*0.56","v":92563.033421376007},null,{"$f":"SUM(N6:N14)*0.56","v":95339.92442401727},"total",null,{"$f":"SUM(F18:N18)","v":428807.84378459328}]
[]
["Equipment"]
[null,"Computer hardware",null,null,null,7500,null,7500]
[null,null,null,null,"annual total",10500,null,null,null,null,null,null,null,null,"total",null,{"$f":"SUM(F21:N21)","v":15000}]
[]
["Travel"]
[null,"Domestic",null,null,null,1000,null,1000,null,1000,null,1000,null,1000,"total",null,{"$f":"SUM(F25:N25)","v":5000}]
[null,"Foreign none"]
[null,null,null,null,"Yr 1",null,"Yr 2",null,"Yr 3",null,"Yr 4",null,"Yr 5"]
["Other direct costs"]
[null,"Supplies computer hardware",null,null,null,750,null,750,null,750,null,750,null,750,null,{"$f":"SUM(F29:N29)","v":3750}]
[null,"Computer software",null,null,null,200,null,200,null,200,null,200,null,200,null,{"$f":"SUM(F30:N30)","v":1000}]
[null,"Non-Cap Equipment",null,null,null,4500,null,4500,null,4500,null,4500,null,4500,null,{"$f":"SUM(F31:N31)","v":22500}]
[null,"Supplies General",null,null,null,2000,null,2000,null,2000,null,2000,null,2000,null,{"$f":"SUM(F32:N32)","v":10000}]
[null,null,null,"annual total",null,{"$f":"SUM(F29:F32)","v":7450},null,{"$f":"SUM(H29:H32)","v":7450},null,{"$f":"SUM(J29:J32)","v":7450},null,{"$f":"SUM(L29:L32)","v":7450},null,{"$f":"SUM(N29:N32)","v":7450},"total",null,{"$f":"SUM(P29:P32)","v":37250}]
[]
["Other"]
[null,"Internal Ship time",null,null,"days","cost","days","cost","days","cost","days","cost","days","cost",null,null,null,null,null,"Ship cost/Day based on 3% annual increase"]
[null,null,null,"annual total",6,{"$f":"E37*U37","v":129600},2,{"$f":"G37*U38","v":44500},2,{"$f":"I37*U39","v":45800},10,{"$f":"K37*U40","v":236000},8,{"$f":"M37*U41","v":194400},"total",null,{"$f":"F37+H37+J37+L37+N37","v":650300},null,null,2021,21600]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,22250]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,22900]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,23600]
["Outside Services",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2025,24300]
[null,"Router/Switch maintenance",null,null,null,1800,null,{"$f":"F42*0.03 +F42","v":1854},null,{"$f":"H42*0.03 +H42","v":1909.62},null,{"$f":"J42*0.03 +J42","v":1966.9086},null,{"$f":"L42*0.03 +L42","v":2025.9158580000001},null,{"$f":"F42+H42+J42+L42+N42","v":9556.4444579999999}]
[null,"Software/Hardware maintenance UW",null,null,null,null,null,43000,null,{"$f":"H43*0.03 +H43","v":44290},null,{"$f":"J43*0.03 +J43","v":45618.7},null,{"$f":"L43*0.03 +L43","v":46987.260999999999},null,{"$f":"F43+H43+J43+L43+N43","v":179895.96100000001}]
[null,"Right of way MLHD",null,null,null,1460,null,{"$f":"F44*0.03 +F44","v":1503.8},null,{"$f":"H44*0.03 +H44","v":1548.914},null,{"$f":"J44*0.03 +J44","v":1595.3814199999999},null,{"$f":"L44*0.03 +L44","v":1643.2428625999999},null,{"$f":"F44+H44+J44+L44+N44","v":7751.3382825999997}]
[null,"Linda Kuhnz Actual Impacts Assesment (AIA)",null,null,null,null,null,null,null,null,null,31150,null,null,null,{"$f":"F45+H45+J45+L45+N45","v":31150}]
[null,"ABA Consultants Sample processing for AIA",null,null,null,null,null,null,null,null,null,24600,null,null,null,{"$f":"F46+H46+J46+L46+N46","v":24600}]
[null,null,null,null,null,{"$f":"SUM(F42:F46)","v":3260},null,{"$f":"SUM(H42:H46)","v":46357.8},null,{"$f":"SUM(J42:J46)","v":47748.534},null,{"$f":"SUM(L42:L46)","v":104930.99002},null,{"$f":"SUM(N42:N46)","v":50656.419720599995},"total",null,{"$f":"P42+P43+P44+P45+P46","v":252953.74374060001}]
[]
["Shipping",null,null,null,null,1000,null,1000,null,1000,null,1000,null,1000,null,null,{"$f":"F49+H49+J49+L49+N49","v":5000}]
["indirect costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q49+Q33+Q25+Q22+Q18+Q16)*0.53","v":666096.6522162531}]
[null,null,null,null,null,"Node Upgrade Capital Project 2021"]
["Item",null,null,null,"Yr 1",null,"Yr 2",null,"Yr 3",null,"Yr 4",null,"Yr 5",null,"Item"]
[null,null,null,null,"months","cost","months","cost","months","cost","months","cost","months","cost"]
["Personnel",null,null,null,null,null,null,null,null,null,null,null,null,null,"Personnel"]
[]
[null,"Dawe",null,null,2,{"$f":"E56*4.5*40*R56","v":32054.400000000001},1,{"$f":"G56*4.5*40*S56","v":16508.016},null,null,null,null,null,null,null,"Dawe",null,89.04,{"$f":"R56+R56*0.03","v":91.711200000000005},94.462536,97.296412079999996,100.2153044424]
[null,"Thompson",null,null,1.33,15752.52,1,{"$f":"G57*4.5*40*S57","v":12199.32},null,null,null,null,null,null,null,"Thompson",null,65.8,67.774000000000001,69.807220000000001,71.901436599999997,74.058479697999999]
[null,"French",null,null,0.66700000000000004,8404.2000000000007,0.33,{"$f":"G58*4.5*40*S58","v":4282.74},null,null,null,null,null,null,null,"French",null,70,72.099999999999994,74.262999999999991,76.490889999999993,78.785616699999991]
[null,"McGill/Mellinger",null,null,0.5,8377.2000000000007,null,null,null,null,null,null,null,null,null,"McGill/Mellinger",null,93.08,95.872399999999999,98.748571999999996,101.71102916,104.7623600348]
[null,"Schram/Risi",null,null,0.5,8377.2000000000007,null,null,null,null,null,null,null,null,null,"Schram/Risi",null,93.08,95.872399999999999,98.748571999999996,101.71102916,104.7623600348]
[null,"Erikson",null,null,0.75,11168.550000000001,null,null,null,null,null,null,null,null,null,"Erikson",null,82.73,85.2119,87.768257000000006,90.401304710000005,93.113343851300002]
[null,"R Thompson",null,null,0.75,7790.85,null,null,null,null,null,null,null,null,null,"R Thompson",null,57.71,59.441299999999998,61.224539,63.061275170000002,64.9531134251]
[null,"Enginering support",null,null,null,{"$f":"E63*4.5*80*R63","v":0},null,null,null,null,null,null,null,null,null,"Enginering support",null,81,83.43,85.932900000000004,88.510886999999997,91.16621361]
[null,"total man months",null,null,{"$f":"SUM(E55:E63)","v":6.4969999999999999},null,{"$f":"SUM(G55:G63)","v":2.33},null,{"$f":"SUM(I55:I63)","v":0},null,{"$f":"SUM(K55:K63)","v":0},null,{"$f":"SUM(M55:M63)","v":0},null,null,"total man months"]
["Fringe Benefits"]
[null,null,null,null,null,{"$f":"SUM(F55:F63)*0.56","v":51477.955200000004},null,{"$f":"SUM(H55:H63)","v":32990.076000000001},null,{"$f":"SUM(J55:J63)","v":0},null,{"$f":"SUM(L55:L63)","v":0},null,{"$f":"SUM(N55:N63)","v":0},"total",{"$f":"SUM(E66:M66)","v":84468.031199999998}]
[]
["Equipment"]
[null,"ODI Hybrid Test lead",null,null,null,60000]
[null,"Titanium Billet and end plates (new MVC housing)",null,null,null,24100]
[null,"ODI Wet Mate Panel Connectors Refurbish x5",null,null,null,45000]
[null,"Data transport, data conv, timing"]
[null,"connectors, supplies",null,null,null,15000]
[]
[null,"total equipment",null,null,null,{"$f":"SUM(F69:F74)","v":144100},null,null,null,null,null,null,null,null,null,{"$f":"F75","v":144100}]
[]
["Outside Services"]
[null,"University of Washington APL build & install"]
[null,"of new low voltage electronics and control software",null,null,null,430000,null,null,null,null,null,null,null,null,null,{"$f":"F79","v":430000}]
[]
["Shipping",null,null,null,null,5000,null,null,null,null,null,null,null,null,null,{"$f":"F81","v":5000}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Node Refurbishment Capital",null,null,"total",null,{"$f":"SUM(P66:P82)","v":663568.03119999997}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Project Total",null,null,null,null,{"$f":"SUM(Q83+Q49+Q47+Q37+Q33+Q25+Q22+Q18+Q16)","v":2823607.911197681}]