{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Year 1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Year 1","index":0,"n_rows":48,"n_cols":35,"rows_kept":48,"cut":false,"hidden":false,"merged":[[98,33,98,37],[99,0,99,37],[100,19,100,21],[100,32,100,33],[100,34,100,35],[100,36,100,37],[97,30,97,32],[97,33,97,37],[98,0,98,9],[98,10,98,15],[98,16,98,18],[98,19,98,20],[98,21,98,22],[98,23,98,24],[98,25,98,27],[98,28,98,29],[97,0,97,9],[97,10,97,15],[97,16,97,18],[97,19,97,20],[97,21,97,22],[97,23,97,24],[97,25,97,27],[97,28,97,29],[98,30,98,32],[95,33,95,37],[96,0,96,9],[96,10,96,15],[96,16,96,18],[96,19,96,20],[96,21,96,22],[96,23,96,24],[96,25,96,27],[96,28,96,29],[96,30,96,32],[96,33,96,37],[95,0,95,9],[95,10,95,15],[95,16,95,18],[95,19,95,20],[95,21,95,22],[95,23,95,24],[95,25,95,27],[95,28,95,29],[95,30,95,32],[93,33,93,37],[94,0,94,9],[94,10,94,15],[94,16,94,18],[94,19,94,20],[94,21,94,22],[94,23,94,24],[94,25,94,27],[94,28,94,29],[94,30,94,32],[94,33,94,37],[93,0,93,9],[93,10,93,15],[93,16,93,18],[93,19,93,20],[93,21,93,22],[93,23,93,24],[93,25,93,27],[93,28,93,29],[93,30,93,32],[91,33,91,37],[92,0,92,9],[92,10,92,15],[92,16,92,18],[92,19,92,20],[92,21,92,22],[92,23,92,24],[92,25,92,27],[92,28,92,29],[92,30,92,32],[92,33,92,37],[91,0,91,9],[91,10,91,15],[91,16,91,18],[91,19,91,20],[91,21,91,22],[91,23,91,24],[91,25,91,27],[91,28,91,29],[91,30,91,32],[89,33,89,37],[90,0,90,9],[90,10,90,15],[90,16,90,18],[90,19,90,20],[90,21,90,22],[90,23,90,24],[90,25,90,27],[90,28,90,29],[90,30,90,32],[90,33,90,37],[89,0,89,9],[89,10,89,15],[89,16,89,18],[89,19,89,20],[89,21,89,22],[89,23,89,24],[89,25,89,27],[89,28,89,29],[89,30,89,32],[87,33,87,37],[88,0,88,9],[88,10,88,15],[88,16,88,18],[88,19,88,20],[88,21,88,22],[88,23,88,24],[88,25,88,27],[88,28,88,29],[88,30,88,32],[88,33,88,37],[87,0,87,9],[87,10,87,15],[87,16,87,18],[87,19,87,20],[87,21,87,22],[87,23,87,24],[87,25,87,27],[87,28,87,29],[87,30,87,32],[85,33,85,37],[86,0,86,9],[86,10,86,15],[86,16,86,18],[86,19,86,20],[86,21,86,22],[86,23,86,24],[86,25,86,27],[86,28,86,29],[86,30,86,32],[86,33,86,37],[85,0,85,9],[85,10,85,15],[85,16,85,18],[85,19,85,20],[85,21,85,22],[85,23,85,24],[85,25,85,27],[85,28,85,29],[85,30,85,32],[83,33,83,37],[84,0,84,9],[84,10,84,15],[84,16,84,18],[84,19,84,20],[84,21,84,22],[84,23,84,24],[84,25,84,27],[84,28,84,29],[84,30,84,32],[84,33,84,37],[83,0,83,9],[83,10,83,15],[83,16,83,18],[83,19,83,20],[83,21,83,22],[83,23,83,24],[83,25,83,27],[83,28,83,29],[83,30,83,32],[81,33,81,37],[82,0,82,9],[82,10,82,15],[82,16,82,18],[82,19,82,20],[82,21,82,22],[82,23,82,24],[82,25,82,27],[82,28,82,29],[82,30,82,32],[82,33,82,37],[81,0,81,9],[81,10,81,15],[81,16,81,18],[81,19,81,20],[81,21,81,22],[81,23,81,24],[81,25,81,27],[81,28,81,29],[81,30,81,32],[79,33,79,37],[80,0,80,9],[80,10,80,15],[80,16,80,18],[80,19,80,20],[80,21,80,22],[80,23,80,24],[80,25,80,27],[80,28,80,29],[80,30,80,32],[80,33,80,37],[79,0,79,9],[79,10,79,15],[79,16,79,18],[79,19,79,20],[79,21,79,22],[79,23,79,24],[79,25,79,27],[79,28,79,29],[79,30,79,32],[77,33,77,37],[78,0,78,9],[78,10,78,15],[78,16,78,18],[78,19,78,20],[78,21,78,22],[78,23,78,24],[78,25,78,27],[78,28,78,29],[78,30,78,32],[78,33,78,37],[77,0,77,9],[77,10,77,15],[77,16,77,18],[77,19,77,20],[77,21,77,22],[77,23,77,24],[77,25,77,27],[77,28,77,29],[77,30,77,32],[75,33,75,37],[76,0,76,9],[76,10,76,15],[76,16,76,18],[76,19,76,20],[76,21,76,22],[76,23,76,24],[76,25,76,27],[76,28,76,29],[76,30,76,32],[76,33,76,37],[75,0,75,9],[75,10,75,15],[75,16,75,18],[75,19,75,20],[75,21,75,22],[75,23,75,24],[75,25,75,27],[75,28,75,29],[75,30,75,32],[73,33,73,37],[74,0,74,9],[74,10,74,15],[74,16,74,18],[74,19,74,20],[74,21,74,22],[74,23,74,24],[74,25,74,27],[74,28,74,29],[74,30,74,32],[74,33,74,37],[73,0,73,9],[73,10,73,15],[73,16,73,18],[73,19,73,20],[73,21,73,22],[73,23,73,24],[73,25,73,27],[73,28,73,29],[73,30,73,32],[71,33,71,37],[72,0,72,9],[72,10,72,15],[72,16,72,18],[72,19,72,20],[72,21,72,22],[72,23,72,24],[72,25,72,27],[72,28,72,29],[72,30,72,32],[72,33,72,37],[71,0,71,9],[71,10,71,15],[71,16,71,18],[71,19,71,20],[71,21,71,22],[71,23,71,24],[71,25,71,27],[71,28,71,29],[71,30,71,32],[69,33,69,37],[70,0,70,9],[70,10,70,15],[70,16,70,18],[70,19,70,20],[70,21,70,22],[70,23,70,24],[70,25,70,27],[70,28,70,29],[70,30,70,32],[70,33,70,37],[69,0,69,9],[69,10,69,15],[69,16,69,18],[69,19,69,20],[69,21,69,22],[69,23,69,24],[69,25,69,27],[69,28,69,29],[69,30,69,32],[65,30,65,37],[67,0,68,9],[67,10,68,15],[67,16,68,18],[67,19,68,20],[67,21,68,22],[67,23,68,24],[67,25,68,27],[67,28,67,32],[67,33,68,37],[68,28,68,29],[68,30,68,32],[59,0,59,37],[60,0,60,37],[61,0,61,37],[63,8,63,13],[63,17,63,22],[63,27,63,30],[63,31,63,32],[63,33,63,37],[52,13,52,14],[52,22,52,25],[52,33,52,37],[54,34,54,37],[56,34,56,37],[58,19,58,21],[58,32,58,33],[58,34,58,35],[58,36,58,37],[51,13,51,14],[51,22,51,25],[51,33,51,37],[46,7,46,16],[46,17,46,19],[46,20,46,29],[46,30,46,32],[47,34,47,37],[49,0,49,12],[49,13,49,14],[49,22,49,25],[49,27,49,30],[49,31,50,32],[43,33,46,33],[43,34,46,37],[44,7,44,16],[44,17,44,19],[44,20,44,29],[44,30,44,32],[41,34,42,37],[42,7,42,16],[42,17,42,19],[42,20,42,29],[42,30,42,32],[41,33,42,33],[49,33,50,37],[50,11,50,12],[50,13,50,14],[50,22,50,25],[50,27,50,30],[43,0,46,6],[43,7,43,16],[43,17,43,19],[43,20,43,29],[43,30,43,32],[41,0,42,6],[41,7,41,16],[41,17,41,19],[41,20,41,29],[41,30,41,32],[45,7,45,16],[45,17,45,19],[45,20,45,29],[45,30,45,32],[39,0,40,6],[39,7,39,16],[39,17,39,19],[39,20,39,29],[39,30,39,32],[35,33,38,33],[35,34,38,37],[36,7,36,16],[36,17,36,19],[36,20,36,29],[36,30,36,32],[37,7,37,16],[37,17,37,19],[37,20,37,29],[37,30,37,32],[39,33,40,33],[39,34,40,37],[40,7,40,16],[40,17,40,19],[40,20,40,29],[40,30,40,32],[38,7,38,16],[38,17,38,19],[38,20,38,29],[33,34,34,37],[34,7,34,16],[34,17,34,19],[34,20,34,29],[34,30,34,32],[35,0,38,6],[35,7,35,16],[35,17,35,19],[35,20,35,29],[35,30,35,32],[33,0,34,6],[33,7,33,16],[33,17,33,19],[33,20,33,29],[33,30,33,32],[33,33,34,33],[38,30,38,32],[31,33,32,33],[31,34,32,37],[32,7,32,16],[32,17,32,19],[32,20,32,29],[32,30,32,32],[29,25,29,27],[29,29,29,31],[31,0,32,6],[31,7,31,16],[31,17,31,19],[31,20,31,29],[31,30,31,32],[25,25,25,37],[26,25,26,27],[26,29,26,31],[26,33,30,33],[26,34,30,37],[27,25,27,27],[27,29,27,31],[28,25,28,27],[28,29,28,31],[22,33,22,37],[23,26,23,27],[23,29,23,32],[23,34,23,37],[21,25,21,27],[21,28,21,29],[21,30,21,32],[21,33,21,37],[24,25,24,37],[22,1,22,9],[22,10,22,15],[22,16,22,18],[22,19,22,20],[22,21,22,22],[22,23,22,24],[20,25,20,27],[20,28,20,29],[20,30,20,32],[22,25,22,27],[22,28,22,29],[22,30,22,32],[20,33,20,37],[21,1,21,9],[21,10,21,15],[21,16,21,18],[21,19,21,20],[21,21,21,22],[21,23,21,24],[18,23,19,24],[20,1,20,9],[20,10,20,15],[20,16,20,18],[20,19,20,20],[20,21,20,22],[20,23,20,24],[15,33,15,37],[16,0,16,9],[16,10,16,15],[16,16,16,18],[16,19,16,20],[16,21,16,22],[16,23,16,24],[16,25,16,27],[18,0,19,0],[18,1,19,9],[18,10,19,15],[18,16,19,18],[18,19,19,20],[18,21,19,22],[16,28,16,29],[16,30,16,32],[16,33,16,37],[17,25,19,27],[17,28,19,32],[17,33,19,37],[15,0,15,9],[15,10,15,15],[15,16,15,18],[15,19,15,20],[15,21,15,22],[15,23,15,24],[15,25,15,27],[15,28,15,29],[15,30,15,32],[13,33,13,37],[14,0,14,9],[14,10,14,15],[14,16,14,18],[14,19,14,20],[14,21,14,22],[14,23,14,24],[14,25,14,27],[14,28,14,29],[14,30,14,32],[14,33,14,37],[13,0,13,9],[13,10,13,15],[13,16,13,18],[13,19,13,20],[13,21,13,22],[13,23,13,24],[13,25,13,27],[13,28,13,29],[13,30,13,32],[11,33,11,37],[12,0,12,9],[12,10,12,15],[12,16,12,18],[12,19,12,20],[12,21,12,22],[12,23,12,24],[12,25,12,27],[12,28,12,29],[12,30,12,32],[12,33,12,37],[11,0,11,9],[11,10,11,15],[11,16,11,18],[11,19,11,20],[11,21,11,22],[11,23,11,24],[11,25,11,27],[11,28,11,29],[11,30,11,32],[9,33,9,37],[10,0,10,9],[10,10,10,15],[10,16,10,18],[10,19,10,20],[10,21,10,22],[10,23,10,24],[10,25,10,27],[10,28,10,29],[10,30,10,32],[10,33,10,37],[9,0,9,9],[9,10,9,15],[9,16,9,18],[9,19,9,20],[9,21,9,22],[9,23,9,24],[9,25,9,27],[9,28,9,29],[9,30,9,32],[7,0,8,9],[7,10,8,15],[7,16,8,18],[7,19,8,20],[7,21,8,22],[7,23,8,24],[7,25,8,27],[7,28,7,32],[7,33,8,37],[8,28,8,29],[8,30,8,32],[0,0,0,37],[1,0,1,37],[3,8,3,13],[3,17,3,22],[3,27,3,30],[3,31,3,32],[3,33,3,37],[5,30,5,37],[6,30,6,34]]}
["UCSD PROPOSAL BUDGET FORM"]
["University of California San Diego"]
[]
["Budget Period:",null,null,null,null,null,null,"From",null,null,null,null,null,null,null,"Through",null,null,null,null,null,null,null,null,null,null," Year ",null,null,null,null,"of"]
[]
["List Personnel Salary and Fringe Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           UCSD#"]
[]
["Name",null,null,null,null,null,null,null,null,null,"Payroll Title",null,null,null,null,null,"Monthly Salary",null,null,"# of \nMonths",null,"% Effort",null,"Person Months",null,"Requested\nSalary",null,null,"* Fringe Benefits",null,null,null,null,"Total "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%",null,"Amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T10*V10/100","v":0},null,{"$f":"Q10*T10*V10/100","v":0},null,null,null,null,{"$f":"AC10/100*Z10","v":0},{"$f":"(LOOKUP($AC10,AG10:$AL25,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC10,AH10:$AL25,#REF!))","v":{"$error":"#REF!"}},{"$f":"(Z10+AE10)*1.55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,{"$f":"Q11*T11*V11/100","v":0},null,null,null,null,{"$f":"AC11/100*Z11","v":0},{"$f":"(LOOKUP($AC11,AG11:$AL26,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC11,AH11:$AL26,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC12,AG12:$AL27,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC12,AH12:$AL27,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC13,AG13:$AL28,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC13,AH13:$AL28,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC14,AG14:$AL29,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC14,AH14:$AL29,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC15,AG15:$AL30,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC15,AH15:$AL30,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC16,AG16:$AL31,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC16,AH16:$AL31,#REF!))","v":{"$error":"#REF!"}},0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,null,null,null,null,0,{"$f":"(LOOKUP($AC17,AG17:$AL32,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC17,AH17:$AL32,#REF!))","v":{"$error":"#REF!"}},0]
["List Graduate Student Researchers (GSRs) Salary and Fringe Benefits"]
["# of","Name",null,null,null,null,null,null,null,null,"Payroll Title",null,null,null,null,null,"Monthly Salary",null,null,"# of \nMonths",null,"% Effort",null,"Person Months"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T21*V21/100","v":0},null,{"$f":"A21*Q21*T21*V21/100","v":0},null,null,null,null,{"$f":"AC21/100*Z21","v":0},{"$f":"(LOOKUP($AC21,AG21:$AL37,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC21,AH21:$AL37,#REF!))","v":{"$error":"#REF!"}},{"$f":"(Z21+AE21)*1.55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T22*V22/100","v":0},null,{"$f":"A22*Q22*T22*V22/100","v":0},null,null,null,null,{"$f":"AC22/100*Z22","v":0},{"$f":"(LOOKUP($AC22,AG22:$AL38,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC22,AH22:$AL38,#REF!))","v":{"$error":"#REF!"}},{"$f":"(Z22+AE22)*1.55","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T23*V23/100","v":0},null,{"$f":"A23*Q23*T23*V23/100","v":0},null,null,null,null,{"$f":"AC23/100*Z23","v":0},{"$f":"(LOOKUP($AC23,AG23:$AL39,#REF!))","v":{"$error":"#REF!"}},{"$f":"(LOOKUP($AC23,AH23:$AL39,#REF!))","v":{"$error":"#REF!"}},{"$f":"(Z23+AE23)*1.55","v":0}]
["Fringe Benefit Rate % and Tuition Remission Calculation:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"SUM(Z10:AB17,Z21:AB23,Z70:AB99)","v":0},null,"$",{"$f":"SUM(AC10:AE17,AC21:AE23,AC70:AE99)","v":0},null,{"$f":"SUM(AE10:AG17,AE21:AG23,AE70:AG99)","v":{"$error":"#REF!"}},null,"$",{"$f":"SUM(AH10:AL17,AH21:AL23,AH70:AL99)","v":0}]
["* Enter the appropriate Fringe Benefit Rate %. For example: 17.0% enter 17 in the box.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The \"Totals\" above also include Salary and "]
["The budget form will calculate the Fringe Benefit Amount and the Total automatically.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fringe Benefit amounts from the next page."]
["Tuition Remission:",null,null,null,null,null,"# of GSR's:",null,null,null,null,"x","# of Months",null,null,null,null,null,null,null,null,null,null,null,"x   Tuition Remission Rate:",null,null,null,"=",{"$f":"K27*Q27*Z27","v":0},null,null,null,"$",{"$f":"SUM(AD27:AF30)","v":0}]
["Tuition Remission:",null,null,null,null,null,"# of GSR's:",null,null,null,null,"x","# of Months",null,null,null,null,null,null,null,null,null,null,null,"x   Tuition Remission Rate:",null,null,null,"=",{"$f":"K28*Q28*Z28","v":0}]
["Tuition Remission:",null,null,null,null,null,"# of GSR's:",null,null,null,null,"x","# of Months",null,null,null,null,null,null,null,null,null,null,null,"x   Tuition Remission Rate:",null,null,null,"=",{"$f":"K29*Q29*Z29","v":0}]
["Tuition Remission:",null,null,null,null,null,"# of GSR's:",null,null,null,null,"x","# of Months",null,null,null,null,null,null,null,null,null,null,null,"x   Tuition Remission Rate:",null,null,null,"=",{"$f":"K30*Q30*Z30","v":0}]
[]
["Consultant(s) ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"(R32+R33+AE32+AE33)*1.55","v":0}]
[]
["Equipment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"R34+R35+AE34+AE35","v":0}]
[]
["Supplies and Materials",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"(R36+R37+R38+R39+AE36+AE37+AE38+AE39)*1.55","v":0}]
[]
[]
[]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"(R40+R41+AE40+AE41)*1.55","v":0}]
[]
["Subaward(s)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"R42+R43+AE42+AE43","v":0}]
[]
["Other Expenses",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"$",{"$f":"(R44+R45+R46+R47+AE44+AE45+AE46+AE47)*1.55","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Costs  ","$",{"$f":"AI24+AI27+AI32+AI34+AI36+AI40+AI42+AI44","v":0}]