{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instruction Sheet","Cover Page","Personnel Expense Calculator","Detailed Budget","Sub Awards","Equip Trav PartCost","Other Direct Costs","Reference","Cost Share"],"not_rendered":{"charts":0,"images":15,"macros":1,"external_links":0,"defined_names":38,"comments":0,"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":"Instruction Sheet","index":0,"n_rows":39,"n_cols":11,"rows_kept":39,"cut":false,"hidden":false,"merged":[[31,1,31,7],[14,10,14,16],[15,10,15,16],[16,10,16,16],[17,10,17,16],[29,0,29,7],[9,9,9,16],[10,10,10,16],[11,10,11,16],[12,10,12,16],[13,10,13,16],[9,0,9,7],[10,1,10,7],[11,1,11,7],[12,1,12,7],[2,0,2,7],[13,1,13,7],[14,1,14,7],[15,1,15,7],[16,1,16,7],[17,1,17,7],[35,1,35,7],[38,1,38,7],[36,1,36,7],[37,1,37,7],[18,1,18,7],[20,0,20,7],[21,0,21,7],[22,1,22,7],[32,1,32,7],[23,1,23,7],[24,1,24,7],[25,1,25,7],[26,1,26,7],[27,1,27,7],[34,0,34,7],[30,1,30,7]]}
[]
["v25"]
["Texas Tech University, Office of Research Services"]
[]
["DO NOT CHANGE OR EDIT THE REFERENCE SHEET. "]
[]
["YELLOW","BLUE","WHITE","GREY","ORANGE"]
["These cells are informational. Do not edit these cells.","These cells are to assist in working through the budget. Do not edit these cells","These cells are editable","Do not edit these cells. They automatically calculate.","These cells may be edited on the Detailed Budget sheet.  If using the \"Equip Trav PartCosts\" or \"Other Direct Costs\" sheets, do not edit these values."]
[]
["COVER PAGE",null,null,null,null,null,null,null,null,"Detailed Budget"]
["PI Name","Type in the Name of the Principal Investigator.",null,null,null,null,null,null,null,"Personnel Salary","These will automatically fill based on the \"Personnel Expense Calculator.\" Do not edit or alter these figures."]
["Project Title","Type in the Title of the project.",null,null,null,null,null,null,null,"Personnel Fringe Benefits","These will automatically fill based on the \"Personnel Expense Calculator.\" Do not edit or alter these figures."]
["Sponsor","Type in the agency or sponsor for the project to be funded.",null,null,null,null,null,null,null,"Total Salary and Fringe","These will automatically fill based on the \"Personnel Expense Calculator.\" Do not edit or alter these figures."]
["Project State and End Dates","Type in the Start and End Dates of the project.  Please refer to the proposal guidelines for instructions, if applicable.",null,null,null,null,null,null,null," Equipment","These values may either be directly entered into the cell, or itemized using the \"EQUIP TRAV PART COSTS\" tab. Quotes must be provided for all Capital Equipment. "]
["F&A Rate","Type in the appropriate F&A rate based on project start date.  Please contact your ORS Administrator for assistance.",null,null,null,null,null,null,null," Travel","These values may either be directly entered into the cell, or itemized using the \"EQUIP TRAV PART COSTS\" tab. Domestic and Foreign Travel must be budgeted within their respecitve categories."]
["F&A Rate Base","If the F&A Rate is the University Rate, please use MTDC (Modified Total Direct Costs).  If the F&A rate is reduced, pluse  use TDC (Total Direct Costs). Please contact your ORS Administrator for assistance.",null,null,null,null,null,null,null," Particpant Support Costs","These values may either be directly entered into the cell, or itemized using the \"EQUIP TRAV PART COSTS\" tab."]
["Cost Share","Select either \"Yes\" or \"No\" from the drop down menu.  Type in the requried cost share rate in the YELLOW box.  Please contact your ORS Administrator for assistance.",null,null,null,null,null,null,null,"Other Direct Costs","These values may either be directly entered into the cell, or itemized using the \"OTHER DIRECT COSTS\" tab."]
["ORS Deadline","Enter in date 2 weeks prior to submission date.  This is the date that the budget should be provided to your ORS Administrator. ",null,null,null,null,null,null,null,"Total Summary Table","These will automatically fill based on information enetered in tables above. Do not edit or alter these figures."]
["Sponsor Due Date","Type in the Due Date of the Proposal to the Sponsor. "]
[]
["Personnel Expense Calculator"]
["PROJECT PERSONNEL TABLE"]
["Name and Role","Type in Name and Role of the personnel working on the project"]
["Benefit Type","Please select one from the drop down menu: Faculty/Staff, Retired Employees, Students."]
["Monthly Salary","Type in current or escalated monthly salary for each personnel as appropriate. Undergraduates should be calculated as \"=hourly pay X 40 hours X 4.33 months\" OR total requested amount for each budget period (ie: $4,000)."]
["Salary Annual Increase","Type in Salary Annual Increase.  3% is the standard amount for salary. "]
["Insurance Type","Please select one from the drop down menu: Employee, Employee and Spouse, Retired Employees, etc.  Students should be listed as Average Part Time, unless otherwise noted on fringe report."]
["Add Rows","If additional rows are needed, rows must be added before moving on to subsequent tables."]
[]
[" SALARY and EFFORT & FRINGE BENEFITS"]
["Name and Role","These will automatically fill based on the \"Project Personnel\" Table. Do not edit or alter these figures."]
["Years 1- Year 5","Type in the month and percent effort for each person per year.  Graduate students are based on 100% effort.  Undergraduate students should be based on \"=# of weeks/4.33\" and 50% effort OR if using a total amount (ie: $4,000), use 1 month at 100% effort for each budget period. "]
["Fringe Benefits","These will automatically fill based on the \"Project Personnel\" Table.  Do not edit or alter these figures."]
[]
["GRADUATE & DOCTORAL FEE TABLE"]
["Student Name","Type in the student name, if known."]
["College","Select the College and Graduate Student Type from the drop down menu: WCOE - Doctoral, All Colleges except WCOE and RCOB - Doctoral, All Colleges excpet RCOB - Masters, RCOB - Doctoral, RCOB-Masters"]
["Credit","This is the amount of hours per long semester (Fall and/or Spring) that the student will be enrolled.  This is ususally 9 credit hours."]
["Term","Type in the term that the semester will begin.  If study does not start on a normal term basis, please contact your ORS Administrator for assistance. "]

{"sheet":"Cover Page","index":1,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[29,3,29,6],[20,1,20,2],[29,1,29,2],[27,1,27,2],[27,3,27,6],[25,4,25,5],[24,1,24,5],[43,1,51,12],[33,1,33,2],[31,3,31,6],[33,3,33,6],[31,1,31,2],[35,6,35,7],[3,1,3,12],[4,1,4,12],[7,1,7,12],[12,1,12,2],[12,3,12,6],[14,1,14,2],[14,3,14,12],[20,9,20,12],[22,9,22,10],[22,7,22,8],[22,1,22,2],[18,9,18,12],[20,7,20,8],[16,1,16,2],[18,1,18,2],[18,7,18,8],[16,3,16,6],[18,3,18,6],[20,3,20,6],[22,3,22,6]]}
[]
[]
[]
[null,"Texas Tech University, Office of Research Services"]
[null,"Project Budget Template "]
[]
[]
[null,"Summary / Cover Page "]
[]
[]
[]
[]
[null,"PI Name"]
[]
[null,"Project Title "]
[]
[null,"Sponsor"]
[]
[null,"Project Start Date",null,null,null,null,null,"Project End Dates"]
[]
[null,"F & A Rate",null,null,null,null,null,"Select"]
[]
[null,"Cost Share",null,"Is there cost share?",null,null,null,"Select"]
[]
[null,"Enter the Cost Share Rate in the Box Below"]
[null,null,null,null,0]
[]
[null," Select F & A Rate Type"]
[]
[null,"Cost Share"]
[]
[null," ORS Deadline"]
[]
[null," Sponsor Due Date"]
[]
[null,"F & A Rates Types",null,"On Campus Instruction Rate",0.51,null,"On Campus Research Rate",null,null,"Year","F & A Rate"]
[null,"On Campus Research Rate",null,"Off Campus Instruction Rate",0.26,null,"2022-09-01",0.53,null,1]
[null,"On Campus Instruction Rate",null,"Other Sponsor Rate",0.39,null,"2023-09-01",0.53,null,2]
[null,"Off Campus Rate",null,"Manual Rate",null,null,"2024-09-01",0.53,null,3]
[null,"Other Sponsor Rate",null,null,null,null,null,null,null,4]
[null,"Manual Rate",null,null,null,null,null,null,null,5]
[]
[null,"COMMENTS:"]

{"sheet":"Personnel Expense Calculator","index":2,"n_rows":83,"n_cols":22,"rows_kept":83,"cut":false,"hidden":false,"merged":[[80,10,80,11],[80,12,80,13],[80,14,80,15],[80,16,80,17],[80,18,80,19],[75,18,75,19],[67,10,67,11],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[65,12,65,13],[66,10,66,11],[60,14,60,15],[69,12,69,13],[76,10,76,11],[77,10,77,11],[78,10,78,11],[64,14,64,15],[61,14,61,15],[62,14,62,15],[63,14,63,15],[79,16,79,17],[80,6,80,9],[57,4,57,6],[65,4,65,5],[60,10,60,11],[61,10,61,11],[76,18,76,19],[75,8,75,9],[59,1,59,15],[61,8,61,9],[60,6,60,7],[61,6,61,7],[61,2,61,3],[63,10,63,11],[65,14,65,15],[62,6,62,7],[63,6,63,7],[64,6,64,7],[65,6,65,7],[60,4,60,5],[60,2,60,3],[77,18,77,19],[78,18,78,19],[73,18,73,19],[74,18,74,19],[79,12,79,13],[73,14,73,15],[74,14,74,15],[75,14,75,15],[76,16,76,17],[78,14,78,15],[77,14,77,15],[76,14,76,15],[73,16,73,17],[74,16,74,17],[75,16,75,17],[77,16,77,17],[73,12,73,13],[74,12,74,13],[75,12,75,13],[76,12,76,13],[78,16,78,17],[79,14,79,15],[79,8,79,9],[76,3,76,6],[73,3,73,6],[78,1,78,2],[79,1,79,2],[67,4,67,5],[67,6,67,7],[78,3,78,6],[77,3,77,6],[76,8,76,9],[74,8,74,9],[77,1,77,2],[73,1,73,2],[74,1,74,2],[75,1,75,2],[69,8,69,9],[69,10,69,11],[67,8,67,9],[78,8,78,9],[77,12,77,13],[78,12,78,13],[75,3,75,6],[67,14,67,15],[69,14,69,15],[69,4,69,5],[69,6,69,7],[67,1,67,3],[76,1,76,2],[74,3,74,6],[69,1,69,3],[72,1,72,22],[73,8,73,9],[73,20,73,22],[74,20,74,22],[75,20,75,22],[76,20,76,22],[77,20,77,22],[78,20,78,22],[79,20,79,22],[79,3,79,6],[46,1,46,2],[49,1,50,1],[63,2,63,3],[62,4,62,5],[63,4,63,5],[67,12,67,13],[64,8,64,9],[65,8,65,9],[62,8,62,9],[63,8,63,9],[64,2,64,3],[65,2,65,3],[62,2,62,3],[49,10,49,12],[62,10,62,11],[61,4,61,5],[64,4,64,5],[64,10,64,11],[65,10,65,11],[48,1,48,20],[49,2,50,3],[57,10,57,12],[56,2,56,3],[66,2,66,3],[51,2,51,3],[52,2,52,3],[53,2,53,3],[54,2,54,3],[55,2,55,3],[57,1,57,3],[49,4,49,6],[49,7,49,9],[57,7,57,9],[66,4,66,5],[66,6,66,7],[66,8,66,9],[66,12,66,13],[66,14,66,15],[46,4,46,5],[46,6,46,7],[41,4,41,5],[42,4,42,5],[43,4,43,5],[44,4,44,5],[45,4,45,5],[44,6,44,7],[38,1,38,14],[39,1,39,3],[44,11,44,14],[45,11,45,14],[40,1,40,2],[42,1,42,2],[43,1,43,2],[45,1,45,2],[40,8,40,10],[41,8,41,10],[42,8,42,10],[43,8,43,10],[44,8,44,10],[45,8,45,10],[40,6,40,7],[41,6,41,7],[45,6,45,7],[17,8,17,9],[18,8,18,9],[42,6,42,7],[43,6,43,7],[39,4,39,14],[40,4,40,5],[40,11,40,14],[41,1,41,2],[44,1,44,2],[30,4,30,5],[30,6,30,7],[30,8,30,9],[30,10,30,11],[30,12,30,13],[30,14,30,15],[31,1,31,3],[35,8,35,9],[35,10,35,11],[35,12,35,13],[35,14,35,15],[32,1,32,3],[32,4,32,5],[32,6,32,7],[33,1,33,3],[80,20,80,22],[41,11,41,14],[42,11,42,14],[43,11,43,14],[46,11,46,14],[56,19,56,20],[57,19,57,20],[49,13,49,15],[49,16,49,18],[49,19,50,20],[51,19,51,20],[52,19,52,20],[53,19,53,20],[54,19,54,20],[55,19,55,20],[57,13,57,15],[57,16,57,18],[79,18,79,19],[73,10,73,11],[74,10,74,11],[75,10,75,11],[46,8,46,10],[60,8,60,9],[79,10,79,11],[83,1,91,22],[11,1,11,15],[12,1,12,15],[17,2,17,6],[18,2,18,6],[17,10,17,15],[18,10,18,15],[34,1,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[34,10,34,11],[34,12,34,13],[34,14,34,15],[35,1,35,3],[35,4,35,5],[35,6,35,7],[31,4,31,5],[31,6,31,7],[31,8,31,9],[31,10,31,11],[31,12,31,13],[31,14,31,15],[30,1,30,3],[33,4,33,5],[33,6,33,7],[33,8,33,9],[33,10,33,11],[33,12,33,13],[33,14,33,15],[32,8,32,9],[32,10,32,11],[32,12,32,13],[32,14,32,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Texas Tech University, Office of Research Services"]
[null,"Project Budget Template "]
[]
[]
[]
[]
[null,"PI Name",{"$f":"IF('Cover Page'!D13 <> \"\",'Cover Page'!D13,\" \")","v":" "},null,null,null,null,null,"Project Start Date",null,{"$f":"IF('Cover Page'!D19 <> \"\", 'Cover Page'!D19,\" \" )","v":" "}]
[null,"Title",{"$f":"IF('Cover Page'!D15 <> \"\",'Cover Page'!D15,\" \")","v":" "},null,null,null,null,null,"Project End Date",null,{"$f":"IF('Cover Page'!J19 <> \"\", 'Cover Page'!J19,\" \" )","v":" "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Project Summary",null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total"]
[null,"Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D77","v":0},null,{"$f":"'Detailed Budget'!F77","v":0},null,{"$f":"'Detailed Budget'!H77","v":0},null,{"$f":"'Detailed Budget'!J77","v":0},null,{"$f":"'Detailed Budget'!L77","v":0},null,{"$f":"'Detailed Budget'!N77","v":0}]
[null,"Modified Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D78","v":0},null,{"$f":"'Detailed Budget'!F78","v":0},null,{"$f":"'Detailed Budget'!H78","v":0},null,{"$f":"'Detailed Budget'!J78","v":0},null,{"$f":"'Detailed Budget'!L78","v":0},null,{"$f":"'Detailed Budget'!N78","v":0}]
[null,"TDC minus Subs",null,null,{"$f":"'Detailed Budget'!D79","v":0},null,{"$f":"'Detailed Budget'!F79","v":0},null,{"$f":"'Detailed Budget'!H79","v":0},null,{"$f":"'Detailed Budget'!J79","v":0},null,{"$f":"'Detailed Budget'!L79","v":0},null,{"$f":"'Detailed Budget'!N79","v":0}]
[null,"F&A",null,null,{"$f":"'Detailed Budget'!D80","v":0},null,{"$f":"'Detailed Budget'!F80","v":0},null,{"$f":"'Detailed Budget'!H80","v":0},null,{"$f":"'Detailed Budget'!J80","v":0},null,{"$f":"'Detailed Budget'!L80","v":0},null,{"$f":"'Detailed Budget'!N80","v":0}]
[null,"Total Costs",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"'Detailed Budget'!N81","v":0}]
[]
[]
[null,"Project Personnel "]
[null,"Project Personnel ",null,null,"Salary and Fringe Calculation Information"]
[null,"Name",null,"Role","Benefit Type",null,"Monthly Salary ",null,"Salary Annual Increase",null,null,"Insurance Type"]
[]
[]
[]
[]
[]
[]
[]
[null,"Salary and Effort"]
[null,"Name ","Role ",null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"Total"]
[null,null,null,null,"Months","Effort %","Salary ","Months","Effort %","Salary ","Months","Effort %","Salary","Months","Effort %","Salary ","Months","Effort %","Salary "]
[null,{"$f":"B42","v":0},{"$f":"D42","v":0},null,null,null,{"$f":"(G42*E52*F52)","v":0},null,null,{"$f":"(G42*H52*I52)*(1+I42)","v":0},null,null,{"$f":"(G42*K52*L52)*(1+I42)^2","v":0},null,null,{"$f":"(G42*N52*O52)*(1+I42)^3","v":0},null,null,{"$f":"(G42*Q52*R52)*(1+I42)^4","v":0},{"$f":"SUM(A82,G52,J52,M52,P52,S52)","v":0}]
[null,0,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(A83,G53,J53,M53,P53,S53)","v":0}]
[null,0,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(A84,G54,J54,M54,P54,S54)","v":0}]
[null,0,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(A85,G55,J55,M55,P55,S55)","v":0}]
[null,0,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(A86,G56,J56,M56,P56,S56)","v":0}]
[null,0,0,null,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,{"$f":"SUM(A86,G57,J57,M57,P57,S57)","v":0}]
[null,"Total Salary",null,null,{"$f":"SUM(G52:G57)","v":0},null,null,{"$f":"SUM(J52:J57)","v":0},null,null,{"$f":"SUM(M52:M57)","v":0},null,null,{"$f":"SUM(P52:P57)","v":0},null,null,{"$f":"SUM(S52:S57)","v":0},null,null,{"$f":"SUM(T52:U57)","v":0}]
[]
[null," Fringe Benefits"]
[null,"Name ","Role ",null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total "]
[null,{"$f":"B42","v":0},{"$f":"D42","v":0},null,{"$f":"G52*IF(E42=Reference!$D$11,Reference!$C$11,IF(E42=Reference!$D$12,Reference!$C$12,IF(E42=Reference!$D$13,Reference!$C$13,0)))+(F52*E52*IF(L42=Reference!$I$11,Reference!$H$11,IF(L42=Reference!$I$12,Reference!$H$12,IF(L42=Reference!$I$13,Reference!$H$13,IF(L42=Reference!$I$14,Reference!$H$14,IF(L42=Reference!$I$15,Reference!$H$15,IF(L42=Reference!$I$16,Reference!$H$16,IF(L42=Reference!$I$18,Reference!$H$18,IF(L42=Reference!$I$19,Reference!$H$19,IF(L42=Reference!$I$20,Reference!$H$20,IF(L42=Reference!I21,Reference!H21,IF(L42=Reference!$I$22,Reference!$H$22,IF(L42=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J52>0,J52*IF(E42=Reference!$D$11,Reference!$C$11,IF(E42=Reference!$D$12,Reference!$C$12,IF(E42=Reference!$D$13,Reference!$C$13,0)))+(I52*H52*(IF(L42=Reference!$I$11,Reference!$H$11,IF(L42=Reference!$I$12,Reference!$H$12,IF(L42=Reference!$I$13,Reference!$H$13,IF(L42=Reference!$I$14,Reference!$H$14,IF(L42=Reference!$I$15,Reference!$H$15,IF(L42=Reference!$I$16,Reference!$H$16,IF(L42=Reference!$I$18,Reference!$H$18,IF(L42=Reference!$I$19,Reference!$H$19,IF(L42=Reference!$I$20,Reference!$H$20,IF(L42=Reference!I21,Reference!H21,IF(L42=Reference!$I$22,Reference!$H$22,IF(L42=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M52>0,M52*IF(E42=Reference!$D$11,Reference!$C$11,IF(E42=Reference!$D$12,Reference!$C$12,IF(E42=Reference!$D$13,Reference!$C$13,0)))+(L52*K52*((IF(L42=Reference!$I$11,Reference!$H$11,IF(L42=Reference!$I$12,Reference!$H$12,IF(L42=Reference!$I$13,Reference!$H$13,IF(L42=Reference!$I$14,Reference!$H$14,IF(L42=Reference!$I$15,Reference!$H$15,IF(L42=Reference!$I$16,Reference!$H$16,IF(L42=Reference!$I$18,Reference!$H$18,IF(L42=Reference!$I$19,Reference!$H$19,IF(L42=Reference!$I$20,Reference!$H$20,IF(L42=Reference!I21,Reference!H21,IF(L42=Reference!$I$22,Reference!$H$22,IF(L42=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P52>0,P52*IF(E42=Reference!$D$11,Reference!$C$11,IF(E42=Reference!$D$12,Reference!$C$12,IF(E42=Reference!$D$13,Reference!$C$13,0)))+(O52*N52*(((IF(L42=Reference!$I$11,Reference!$H$11,IF(L42=Reference!$I$12,Reference!$H$12,IF(L42=Reference!$I$13,Reference!$H$13,IF(L42=Reference!$I$14,Reference!$H$14,IF(L42=Reference!$I$15,Reference!$H$15,IF(L42=Reference!$I$16,Reference!$H$16,IF(L42=Reference!$I$18,Reference!$H$18,IF(L42=Reference!$I$19,Reference!$H$19,IF(L42=Reference!$I$20,Reference!$H$20,IF(L42=Reference!I21,Reference!H21,IF(L42=Reference!$I$22,Reference!$H$22,IF(L42=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S52>0,S52*IF(E42=Reference!$D$11,Reference!$C$11,IF(E42=Reference!$D$12,Reference!$C$12,IF(E42=Reference!$D$13,Reference!$C$13,0)))+(Q52*R52*((((IF(L42=Reference!$I$11,Reference!$H$11,IF(L42=Reference!$I$12,Reference!$H$12,IF(L42=Reference!$I$13,Reference!$H$13,IF(L42=Reference!$I$14,Reference!$H$14,IF(L42=Reference!$I$15,Reference!$H$15,IF(L42=Reference!$I$16,Reference!$H$16,IF(L42=Reference!$I$18,Reference!$H$18,IF(L42=Reference!$I$19,Reference!$H$19,IF(L42=Reference!$I$20,Reference!$H$20,IF(L42=Reference!$I$21,Reference!$H$21,IF(L42=Reference!$I$22,Reference!$H$22,IF(L42=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"SUM(E62:N62)","v":0}]
[null,0,0,null,{"$f":"G53*IF(E43=Reference!$D$11,Reference!$C$11,IF(E43=Reference!$D$12,Reference!$C$12,IF(E43=Reference!$D$13,Reference!$C$13,0)))+(F53*E53*IF(L43=Reference!$I$11,Reference!$H$11,IF(L43=Reference!$I$12,Reference!$H$12,IF(L43=Reference!$I$13,Reference!$H$13,IF(L43=Reference!$I$14,Reference!$H$14,IF(L43=Reference!$I$15,Reference!$H$15,IF(L43=Reference!$I$16,Reference!$H$16,IF(L43=Reference!$I$18,Reference!$H$18,IF(L43=Reference!$I$19,Reference!$H$19,IF(L43=Reference!$I$20,Reference!$H$20,IF(L43=Reference!I22,Reference!H22,IF(L43=Reference!$I$22,Reference!$H$22,IF(L43=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J53>0,J53*IF(E43=Reference!$D$11,Reference!$C$11,IF(E43=Reference!$D$12,Reference!$C$12,IF(E43=Reference!$D$13,Reference!$C$13,0)))+(I53*H53*(IF(L43=Reference!$I$11,Reference!$H$11,IF(L43=Reference!$I$12,Reference!$H$12,IF(L43=Reference!$I$13,Reference!$H$13,IF(L43=Reference!$I$14,Reference!$H$14,IF(L43=Reference!$I$15,Reference!$H$15,IF(L43=Reference!$I$16,Reference!$H$16,IF(L43=Reference!$I$18,Reference!$H$18,IF(L43=Reference!$I$19,Reference!$H$19,IF(L43=Reference!$I$20,Reference!$H$20,IF(L43=Reference!I22,Reference!H22,IF(L43=Reference!$I$22,Reference!$H$22,IF(L43=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M53>0,M53*IF(E43=Reference!$D$11,Reference!$C$11,IF(E43=Reference!$D$12,Reference!$C$12,IF(E43=Reference!$D$13,Reference!$C$13,0)))+(L53*K53*((IF(L43=Reference!$I$11,Reference!$H$11,IF(L43=Reference!$I$12,Reference!$H$12,IF(L43=Reference!$I$13,Reference!$H$13,IF(L43=Reference!$I$14,Reference!$H$14,IF(L43=Reference!$I$15,Reference!$H$15,IF(L43=Reference!$I$16,Reference!$H$16,IF(L43=Reference!$I$18,Reference!$H$18,IF(L43=Reference!$I$19,Reference!$H$19,IF(L43=Reference!$I$20,Reference!$H$20,IF(L43=Reference!I22,Reference!H22,IF(L43=Reference!$I$22,Reference!$H$22,IF(L43=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P53>0,P53*IF(E43=Reference!$D$11,Reference!$C$11,IF(E43=Reference!$D$12,Reference!$C$12,IF(E43=Reference!$D$13,Reference!$C$13,0)))+(O53*N53*(((IF(L43=Reference!$I$11,Reference!$H$11,IF(L43=Reference!$I$12,Reference!$H$12,IF(L43=Reference!$I$13,Reference!$H$13,IF(L43=Reference!$I$14,Reference!$H$14,IF(L43=Reference!$I$15,Reference!$H$15,IF(L43=Reference!$I$16,Reference!$H$16,IF(L43=Reference!$I$18,Reference!$H$18,IF(L43=Reference!$I$19,Reference!$H$19,IF(L43=Reference!$I$20,Reference!$H$20,IF(L43=Reference!I22,Reference!H22,IF(L43=Reference!$I$22,Reference!$H$22,IF(L43=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S53>0,S53*IF(E43=Reference!$D$11,Reference!$C$11,IF(E43=Reference!$D$12,Reference!$C$12,IF(E43=Reference!$D$13,Reference!$C$13,0)))+(Q53*R53*((((IF(L43=Reference!$I$11,Reference!$H$11,IF(L43=Reference!$I$12,Reference!$H$12,IF(L43=Reference!$I$13,Reference!$H$13,IF(L43=Reference!$I$14,Reference!$H$14,IF(L43=Reference!$I$15,Reference!$H$15,IF(L43=Reference!$I$16,Reference!$H$16,IF(L43=Reference!$I$18,Reference!$H$18,IF(L43=Reference!$I$19,Reference!$H$19,IF(L43=Reference!$I$20,Reference!$H$20,IF(L43=Reference!$I$21,Reference!$H$21,IF(L43=Reference!$I$22,Reference!$H$22,IF(L43=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,0]
[null,0,0,null,{"$f":"G54*IF(E44=Reference!$D$11,Reference!$C$11,IF(E44=Reference!$D$12,Reference!$C$12,IF(E44=Reference!$D$13,Reference!$C$13,0)))+(F54*E54*IF(L44=Reference!$I$11,Reference!$H$11,IF(L44=Reference!$I$12,Reference!$H$12,IF(L44=Reference!$I$13,Reference!$H$13,IF(L44=Reference!$I$14,Reference!$H$14,IF(L44=Reference!$I$15,Reference!$H$15,IF(L44=Reference!$I$16,Reference!$H$16,IF(L44=Reference!$I$18,Reference!$H$18,IF(L44=Reference!$I$19,Reference!$H$19,IF(L44=Reference!$I$20,Reference!$H$20,IF(L44=Reference!I23,Reference!H23,IF(L44=Reference!$I$22,Reference!$H$22,IF(L44=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J54>0,J54*IF(E44=Reference!$D$11,Reference!$C$11,IF(E44=Reference!$D$12,Reference!$C$12,IF(E44=Reference!$D$13,Reference!$C$13,0)))+(I54*H54*(IF(L44=Reference!$I$11,Reference!$H$11,IF(L44=Reference!$I$12,Reference!$H$12,IF(L44=Reference!$I$13,Reference!$H$13,IF(L44=Reference!$I$14,Reference!$H$14,IF(L44=Reference!$I$15,Reference!$H$15,IF(L44=Reference!$I$16,Reference!$H$16,IF(L44=Reference!$I$18,Reference!$H$18,IF(L44=Reference!$I$19,Reference!$H$19,IF(L44=Reference!$I$20,Reference!$H$20,IF(L44=Reference!I23,Reference!H23,IF(L44=Reference!$I$22,Reference!$H$22,IF(L44=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M54>0,M54*IF(E44=Reference!$D$11,Reference!$C$11,IF(E44=Reference!$D$12,Reference!$C$12,IF(E44=Reference!$D$13,Reference!$C$13,0)))+(L54*K54*((IF(L44=Reference!$I$11,Reference!$H$11,IF(L44=Reference!$I$12,Reference!$H$12,IF(L44=Reference!$I$13,Reference!$H$13,IF(L44=Reference!$I$14,Reference!$H$14,IF(L44=Reference!$I$15,Reference!$H$15,IF(L44=Reference!$I$16,Reference!$H$16,IF(L44=Reference!$I$18,Reference!$H$18,IF(L44=Reference!$I$19,Reference!$H$19,IF(L44=Reference!$I$20,Reference!$H$20,IF(L44=Reference!I23,Reference!H23,IF(L44=Reference!$I$22,Reference!$H$22,IF(L44=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P54>0,P54*IF(E44=Reference!$D$11,Reference!$C$11,IF(E44=Reference!$D$12,Reference!$C$12,IF(E44=Reference!$D$13,Reference!$C$13,0)))+(O54*N54*(((IF(L44=Reference!$I$11,Reference!$H$11,IF(L44=Reference!$I$12,Reference!$H$12,IF(L44=Reference!$I$13,Reference!$H$13,IF(L44=Reference!$I$14,Reference!$H$14,IF(L44=Reference!$I$15,Reference!$H$15,IF(L44=Reference!$I$16,Reference!$H$16,IF(L44=Reference!$I$18,Reference!$H$18,IF(L44=Reference!$I$19,Reference!$H$19,IF(L44=Reference!$I$20,Reference!$H$20,IF(L44=Reference!I23,Reference!H23,IF(L44=Reference!$I$22,Reference!$H$22,IF(L44=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S54>0,S54*IF(E44=Reference!$D$11,Reference!$C$11,IF(E44=Reference!$D$12,Reference!$C$12,IF(E44=Reference!$D$13,Reference!$C$13,0)))+(Q54*R54*((((IF(L44=Reference!$I$11,Reference!$H$11,IF(L44=Reference!$I$12,Reference!$H$12,IF(L44=Reference!$I$13,Reference!$H$13,IF(L44=Reference!$I$14,Reference!$H$14,IF(L44=Reference!$I$15,Reference!$H$15,IF(L44=Reference!$I$16,Reference!$H$16,IF(L44=Reference!$I$18,Reference!$H$18,IF(L44=Reference!$I$19,Reference!$H$19,IF(L44=Reference!$I$20,Reference!$H$20,IF(L44=Reference!$I$21,Reference!$H$21,IF(L44=Reference!$I$22,Reference!$H$22,IF(L44=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,0,null,null,null,null,null,null," "]
[null,0,0,null,{"$f":"G55*IF(E45=Reference!$D$11,Reference!$C$11,IF(E45=Reference!$D$12,Reference!$C$12,IF(E45=Reference!$D$13,Reference!$C$13,0)))+(F55*E55*IF(L45=Reference!$I$11,Reference!$H$11,IF(L45=Reference!$I$12,Reference!$H$12,IF(L45=Reference!$I$13,Reference!$H$13,IF(L45=Reference!$I$14,Reference!$H$14,IF(L45=Reference!$I$15,Reference!$H$15,IF(L45=Reference!$I$16,Reference!$H$16,IF(L45=Reference!$I$18,Reference!$H$18,IF(L45=Reference!$I$19,Reference!$H$19,IF(L45=Reference!$I$20,Reference!$H$20,IF(L45=Reference!I24,Reference!H24,IF(L45=Reference!$I$22,Reference!$H$22,IF(L45=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J55>0,J55*IF(E45=Reference!$D$11,Reference!$C$11,IF(E45=Reference!$D$12,Reference!$C$12,IF(E45=Reference!$D$13,Reference!$C$13,0)))+(I55*H55*(IF(L45=Reference!$I$11,Reference!$H$11,IF(L45=Reference!$I$12,Reference!$H$12,IF(L45=Reference!$I$13,Reference!$H$13,IF(L45=Reference!$I$14,Reference!$H$14,IF(L45=Reference!$I$15,Reference!$H$15,IF(L45=Reference!$I$16,Reference!$H$16,IF(L45=Reference!$I$18,Reference!$H$18,IF(L45=Reference!$I$19,Reference!$H$19,IF(L45=Reference!$I$20,Reference!$H$20,IF(L45=Reference!I24,Reference!H24,IF(L45=Reference!$I$22,Reference!$H$22,IF(L45=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M55>0,M55*IF(E45=Reference!$D$11,Reference!$C$11,IF(E45=Reference!$D$12,Reference!$C$12,IF(E45=Reference!$D$13,Reference!$C$13,0)))+(L55*K55*((IF(L45=Reference!$I$11,Reference!$H$11,IF(L45=Reference!$I$12,Reference!$H$12,IF(L45=Reference!$I$13,Reference!$H$13,IF(L45=Reference!$I$14,Reference!$H$14,IF(L45=Reference!$I$15,Reference!$H$15,IF(L45=Reference!$I$16,Reference!$H$16,IF(L45=Reference!$I$18,Reference!$H$18,IF(L45=Reference!$I$19,Reference!$H$19,IF(L45=Reference!$I$20,Reference!$H$20,IF(L45=Reference!I24,Reference!H24,IF(L45=Reference!$I$22,Reference!$H$22,IF(L45=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P55>0,P55*IF(E45=Reference!$D$11,Reference!$C$11,IF(E45=Reference!$D$12,Reference!$C$12,IF(E45=Reference!$D$13,Reference!$C$13,0)))+(O55*N55*(((IF(L45=Reference!$I$11,Reference!$H$11,IF(L45=Reference!$I$12,Reference!$H$12,IF(L45=Reference!$I$13,Reference!$H$13,IF(L45=Reference!$I$14,Reference!$H$14,IF(L45=Reference!$I$15,Reference!$H$15,IF(L45=Reference!$I$16,Reference!$H$16,IF(L45=Reference!$I$18,Reference!$H$18,IF(L45=Reference!$I$19,Reference!$H$19,IF(L45=Reference!$I$20,Reference!$H$20,IF(L45=Reference!I24,Reference!H24,IF(L45=Reference!$I$22,Reference!$H$22,IF(L45=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S55>0,S55*IF(E45=Reference!$D$11,Reference!$C$11,IF(E45=Reference!$D$12,Reference!$C$12,IF(E45=Reference!$D$13,Reference!$C$13,0)))+(Q55*R55*((((IF(L45=Reference!$I$11,Reference!$H$11,IF(L45=Reference!$I$12,Reference!$H$12,IF(L45=Reference!$I$13,Reference!$H$13,IF(L45=Reference!$I$14,Reference!$H$14,IF(L45=Reference!$I$15,Reference!$H$15,IF(L45=Reference!$I$16,Reference!$H$16,IF(L45=Reference!$I$18,Reference!$H$18,IF(L45=Reference!$I$19,Reference!$H$19,IF(L45=Reference!$I$20,Reference!$H$20,IF(L45=Reference!$I$21,Reference!$H$21,IF(L45=Reference!$I$22,Reference!$H$22,IF(L45=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,0]
[null,0,0,null,{"$f":"G56*IF(E46=Reference!$D$11,Reference!$C$11,IF(E46=Reference!$D$12,Reference!$C$12,IF(E46=Reference!$D$13,Reference!$C$13,0)))+(F56*E56*IF(L46=Reference!$I$11,Reference!$H$11,IF(L46=Reference!$I$12,Reference!$H$12,IF(L46=Reference!$I$13,Reference!$H$13,IF(L46=Reference!$I$14,Reference!$H$14,IF(L46=Reference!$I$15,Reference!$H$15,IF(L46=Reference!$I$16,Reference!$H$16,IF(L46=Reference!$I$18,Reference!$H$18,IF(L46=Reference!$I$19,Reference!$H$19,IF(L46=Reference!$I$20,Reference!$H$20,IF(L46=Reference!I25,Reference!H25,IF(L46=Reference!$I$22,Reference!$H$22,IF(L46=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J56>0,J56*IF(E46=Reference!$D$11,Reference!$C$11,IF(E46=Reference!$D$12,Reference!$C$12,IF(E46=Reference!$D$13,Reference!$C$13,0)))+(I56*H56*(IF(L46=Reference!$I$11,Reference!$H$11,IF(L46=Reference!$I$12,Reference!$H$12,IF(L46=Reference!$I$13,Reference!$H$13,IF(L46=Reference!$I$14,Reference!$H$14,IF(L46=Reference!$I$15,Reference!$H$15,IF(L46=Reference!$I$16,Reference!$H$16,IF(L46=Reference!$I$18,Reference!$H$18,IF(L46=Reference!$I$19,Reference!$H$19,IF(L46=Reference!$I$20,Reference!$H$20,IF(L46=Reference!I25,Reference!H25,IF(L46=Reference!$I$22,Reference!$H$22,IF(L46=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M56>0,M56*IF(E46=Reference!$D$11,Reference!$C$11,IF(E46=Reference!$D$12,Reference!$C$12,IF(E46=Reference!$D$13,Reference!$C$13,0)))+(L56*K56*((IF(L46=Reference!$I$11,Reference!$H$11,IF(L46=Reference!$I$12,Reference!$H$12,IF(L46=Reference!$I$13,Reference!$H$13,IF(L46=Reference!$I$14,Reference!$H$14,IF(L46=Reference!$I$15,Reference!$H$15,IF(L46=Reference!$I$16,Reference!$H$16,IF(L46=Reference!$I$18,Reference!$H$18,IF(L46=Reference!$I$19,Reference!$H$19,IF(L46=Reference!$I$20,Reference!$H$20,IF(L46=Reference!I25,Reference!H25,IF(L46=Reference!$I$22,Reference!$H$22,IF(L46=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P56>0,P56*IF(E46=Reference!$D$11,Reference!$C$11,IF(E46=Reference!$D$12,Reference!$C$12,IF(E46=Reference!$D$13,Reference!$C$13,0)))+(O56*N56*(((IF(L46=Reference!$I$11,Reference!$H$11,IF(L46=Reference!$I$12,Reference!$H$12,IF(L46=Reference!$I$13,Reference!$H$13,IF(L46=Reference!$I$14,Reference!$H$14,IF(L46=Reference!$I$15,Reference!$H$15,IF(L46=Reference!$I$16,Reference!$H$16,IF(L46=Reference!$I$18,Reference!$H$18,IF(L46=Reference!$I$19,Reference!$H$19,IF(L46=Reference!$I$20,Reference!$H$20,IF(L46=Reference!I25,Reference!H25,IF(L46=Reference!$I$22,Reference!$H$22,IF(L46=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S56>0,S56*IF(E46=Reference!$D$11,Reference!$C$11,IF(E46=Reference!$D$12,Reference!$C$12,IF(E46=Reference!$D$13,Reference!$C$13,0)))+(Q56*R56*((((IF(L46=Reference!$I$11,Reference!$H$11,IF(L46=Reference!$I$12,Reference!$H$12,IF(L46=Reference!$I$13,Reference!$H$13,IF(L46=Reference!$I$14,Reference!$H$14,IF(L46=Reference!$I$15,Reference!$H$15,IF(L46=Reference!$I$16,Reference!$H$16,IF(L46=Reference!$I$18,Reference!$H$18,IF(L46=Reference!$I$19,Reference!$H$19,IF(L46=Reference!$I$20,Reference!$H$20,IF(L46=Reference!$I$21,Reference!$H$21,IF(L46=Reference!$I$22,Reference!$H$22,IF(L46=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,0]
[null,0,0,null,{"$f":"G57*IF(E47=Reference!$D$11,Reference!$C$11,IF(E47=Reference!$D$12,Reference!$C$12,IF(E47=Reference!$D$13,Reference!$C$13,0)))+(F57*E57*IF(L47=Reference!$I$11,Reference!$H$11,IF(L47=Reference!$I$12,Reference!$H$12,IF(L47=Reference!$I$13,Reference!$H$13,IF(L47=Reference!$I$14,Reference!$H$14,IF(L47=Reference!$I$15,Reference!$H$15,IF(L47=Reference!$I$16,Reference!$H$16,IF(L47=Reference!$I$18,Reference!$H$18,IF(L47=Reference!$I$19,Reference!$H$19,IF(L47=Reference!$I$20,Reference!$H$20,IF(L47=Reference!I25,Reference!H25,IF(L47=Reference!$I$22,Reference!$H$22,IF(L47=Reference!$I$23,Reference!$H$23,0)))))))))))))","v":0},null,{"$f":"IF(J57>0,J57*IF(E47=Reference!$D$11,Reference!$C$11,IF(E47=Reference!$D$12,Reference!$C$12,IF(E47=Reference!$D$13,Reference!$C$13,0)))+(I57*H57*(IF(L47=Reference!$I$11,Reference!$H$11,IF(L47=Reference!$I$12,Reference!$H$12,IF(L47=Reference!$I$13,Reference!$H$13,IF(L47=Reference!$I$14,Reference!$H$14,IF(L47=Reference!$I$15,Reference!$H$15,IF(L47=Reference!$I$16,Reference!$H$16,IF(L47=Reference!$I$18,Reference!$H$18,IF(L47=Reference!$I$19,Reference!$H$19,IF(L47=Reference!$I$20,Reference!$H$20,IF(L47=Reference!I26,Reference!H26,IF(L47=Reference!$I$22,Reference!$H$22,IF(L47=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)),0)","v":0},null,{"$f":"IF(M57>0,M57*IF(E47=Reference!$D$11,Reference!$C$11,IF(E47=Reference!$D$12,Reference!$C$12,IF(E47=Reference!$D$13,Reference!$C$13,0)))+(L57*K57*((IF(L47=Reference!$I$11,Reference!$H$11,IF(L47=Reference!$I$12,Reference!$H$12,IF(L47=Reference!$I$13,Reference!$H$13,IF(L47=Reference!$I$14,Reference!$H$14,IF(L47=Reference!$I$15,Reference!$H$15,IF(L47=Reference!$I$16,Reference!$H$16,IF(L47=Reference!$I$18,Reference!$H$18,IF(L47=Reference!$I$19,Reference!$H$19,IF(L47=Reference!$I$20,Reference!$H$20,IF(L47=Reference!I26,Reference!H26,IF(L47=Reference!$I$22,Reference!$H$22,IF(L47=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)),0)","v":0},null,{"$f":"IF(P57>0,P57*IF(E47=Reference!$D$11,Reference!$C$11,IF(E47=Reference!$D$12,Reference!$C$12,IF(E47=Reference!$D$13,Reference!$C$13,0)))+(O57*N57*(((IF(L47=Reference!$I$11,Reference!$H$11,IF(L47=Reference!$I$12,Reference!$H$12,IF(L47=Reference!$I$13,Reference!$H$13,IF(L47=Reference!$I$14,Reference!$H$14,IF(L47=Reference!$I$15,Reference!$H$15,IF(L47=Reference!$I$16,Reference!$H$16,IF(L47=Reference!$I$18,Reference!$H$18,IF(L47=Reference!$I$19,Reference!$H$19,IF(L47=Reference!$I$20,Reference!$H$20,IF(L47=Reference!I26,Reference!H26,IF(L47=Reference!$I$22,Reference!$H$22,IF(L47=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)),0)","v":0},null,{"$f":"IF(S57>0,S57*IF(E47=Reference!$D$11,Reference!$C$11,IF(E47=Reference!$D$12,Reference!$C$12,IF(E47=Reference!$D$13,Reference!$C$13,0)))+(Q57*R57*((((IF(L47=Reference!$I$11,Reference!$H$11,IF(L47=Reference!$I$12,Reference!$H$12,IF(L47=Reference!$I$13,Reference!$H$13,IF(L47=Reference!$I$14,Reference!$H$14,IF(L47=Reference!$I$15,Reference!$H$15,IF(L47=Reference!$I$16,Reference!$H$16,IF(L47=Reference!$I$18,Reference!$H$18,IF(L47=Reference!$I$19,Reference!$H$19,IF(L47=Reference!$I$20,Reference!$H$20,IF(L47=Reference!$I$21,Reference!$H$21,IF(L47=Reference!$I$22,Reference!$H$22,IF(L47=Reference!$I$23,Reference!$H$23,0))))))))))))*1.1)*1.1)*1.1)*1.1)),0)","v":0},null,0]
[null,"Total Fringe",null,null,{"$f":"SUM(E62:F67)","v":0},null,{"$f":"SUM(G62:H67)","v":0},null,{"$f":"SUM(I62:J67)","v":0},null,{"$f":"SUM(K62:L67)","v":0},null,{"$f":"SUM(M62:N67)","v":0},null,{"$f":"SUM(O62:P67)","v":0}]
[]
[null,"Total Salary and Fringe ",null,null,{"$f":"SUM(E68,E58)","v":0},null,{"$f":"SUM(G68,H58)","v":0},null,{"$f":"SUM(K58,I68)","v":0},null,{"$f":"SUM(K68,N58)","v":0},null,{"$f":"SUM(Q58,M68)","v":0},null,{"$f":"SUM(O68,T58)","v":0}]
[]
[]
[null,"Graduate and Doctoral Students Fees"]
[null,"Student Name",null,"College",null,null,null,"Credit","Term",null,"Year1",null,"Year2",null,"Year3",null,"Year4",null,"Year5",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D75=Reference!$D$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$D$27,IF(I75=Reference!$C$28,Reference!$D$28,IF(I75=Reference!$C$29,Reference!$D$29,IF(I75=Reference!$C$30,Reference!$D$30,IF(I75=Reference!$C$31,Reference!$D$31,IF(I75=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D75=Reference!$F$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$F$27,IF(I75=Reference!$C$28,Reference!$F$28,IF(I75=Reference!$C$29,Reference!$F$29,IF(I75=Reference!$C$30,Reference!$F$30,IF(I75=Reference!$C$31,Reference!$F$31,IF(I75=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D75=Reference!$H$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$H$27,IF(I75=Reference!$C$28,Reference!$H$28,IF(I75=Reference!$C$29,Reference!$H$29,IF(I75=Reference!$C$30,Reference!$H$30,IF(I75=Reference!$C$31,Reference!$H$31,IF(I75=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D75=Reference!$J$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$J$27,IF(I75=Reference!$C$28,Reference!$J$28,IF(I75=Reference!$C$29,Reference!$J$29,IF(I75=Reference!$C$30,Reference!$J$30,IF(I75=Reference!$C$31,Reference!$J$31,IF(I75=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D75=Reference!$M$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$M$27,IF(I75=Reference!$C$28,Reference!$M$28,IF(I75=Reference!$C$29,Reference!$M$29,IF(I75=Reference!$C$30,Reference!$M$30,IF(I75=Reference!$C$31,Reference!$M$31,IF(I75=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D75=Reference!$O$26,H75=\"9/9/3/3\"),IF(I75=Reference!$C$27,Reference!$O$27,IF(I75=Reference!$C$28,Reference!$O$28,IF(I75=Reference!$C$29,Reference!$O$29,IF(I75=Reference!$C$30,Reference!$O$30,IF(I75=Reference!$C$31,Reference!$O$31,IF(I75=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K75*(1+Reference!$C$18)","v":0},null,{"$f":"K75*(1+Reference!$C$18)^2","v":0},null,{"$f":"K75*(1+Reference!$C$18)^3","v":0},null,{"$f":"K75*(1+Reference!$C$18)^4","v":0},null,{"$f":"SUM(K75:T75)","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D76=Reference!$D$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$D$27,IF(I76=Reference!$C$28,Reference!$D$28,IF(I76=Reference!$C$29,Reference!$D$29,IF(I76=Reference!$C$30,Reference!$D$30,IF(I76=Reference!$C$31,Reference!$D$31,IF(I76=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D76=Reference!$F$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$F$27,IF(I76=Reference!$C$28,Reference!$F$28,IF(I76=Reference!$C$29,Reference!$F$29,IF(I76=Reference!$C$30,Reference!$F$30,IF(I76=Reference!$C$31,Reference!$F$31,IF(I76=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D76=Reference!$H$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$H$27,IF(I76=Reference!$C$28,Reference!$H$28,IF(I76=Reference!$C$29,Reference!$H$29,IF(I76=Reference!$C$30,Reference!$H$30,IF(I76=Reference!$C$31,Reference!$H$31,IF(I76=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D76=Reference!$J$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$J$27,IF(I76=Reference!$C$28,Reference!$J$28,IF(I76=Reference!$C$29,Reference!$J$29,IF(I76=Reference!$C$30,Reference!$J$30,IF(I76=Reference!$C$31,Reference!$J$31,IF(I76=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D76=Reference!$M$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$M$27,IF(I76=Reference!$C$28,Reference!$M$28,IF(I76=Reference!$C$29,Reference!$M$29,IF(I76=Reference!$C$30,Reference!$M$30,IF(I76=Reference!$C$31,Reference!$M$31,IF(I76=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D76=Reference!$O$26,H76=\"9/9/3/3\"),IF(I76=Reference!$C$27,Reference!$O$27,IF(I76=Reference!$C$28,Reference!$O$28,IF(I76=Reference!$C$29,Reference!$O$29,IF(I76=Reference!$C$30,Reference!$O$30,IF(I76=Reference!$C$31,Reference!$O$31,IF(I76=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K76*(1+Reference!$C$18)","v":0},null,{"$f":"K76*(1+Reference!$C$18)^2","v":0},null,{"$f":"K76*(1+Reference!$C$18)^3","v":0},null,{"$f":"K76*(1+Reference!$C$18)^4","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D77=Reference!$D$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$D$27,IF(#REF!=Reference!$C$28,Reference!$D$28,IF(#REF!=Reference!$C$29,Reference!$D$29,IF(#REF!=Reference!$C$30,Reference!$D$30,IF(#REF!=Reference!$C$31,Reference!$D$31,IF(#REF!=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D77=Reference!$F$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$F$27,IF(#REF!=Reference!$C$28,Reference!$F$28,IF(#REF!=Reference!$C$29,Reference!$F$29,IF(#REF!=Reference!$C$30,Reference!$F$30,IF(#REF!=Reference!$C$31,Reference!$F$31,IF(#REF!=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D77=Reference!$H$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$H$27,IF(#REF!=Reference!$C$28,Reference!$H$28,IF(#REF!=Reference!$C$29,Reference!$H$29,IF(#REF!=Reference!$C$30,Reference!$H$30,IF(#REF!=Reference!$C$31,Reference!$H$31,IF(#REF!=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D77=Reference!$J$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$J$27,IF(#REF!=Reference!$C$28,Reference!$J$28,IF(#REF!=Reference!$C$29,Reference!$J$29,IF(#REF!=Reference!$C$30,Reference!$J$30,IF(#REF!=Reference!$C$31,Reference!$J$31,IF(#REF!=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D77=Reference!$M$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$M$27,IF(#REF!=Reference!$C$28,Reference!$M$28,IF(#REF!=Reference!$C$29,Reference!$M$29,IF(#REF!=Reference!$C$30,Reference!$M$30,IF(#REF!=Reference!$C$31,Reference!$M$31,IF(#REF!=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D77=Reference!$O$26,H77=\"9/9/3/3\"),IF(#REF!=Reference!$C$27,Reference!$O$27,IF(#REF!=Reference!$C$28,Reference!$O$28,IF(#REF!=Reference!$C$29,Reference!$O$29,IF(#REF!=Reference!$C$30,Reference!$O$30,IF(#REF!=Reference!$C$31,Reference!$O$31,IF(#REF!=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K77*(1+Reference!$C$18)","v":0},null,{"$f":"K77*(1+Reference!$C$18)^2","v":0},null,{"$f":"K77*(1+Reference!$C$18)^3","v":0},null,{"$f":"K77*(1+Reference!$C$18)^4","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D78=Reference!$D$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$D$27,IF(I77=Reference!$C$28,Reference!$D$28,IF(I77=Reference!$C$29,Reference!$D$29,IF(I77=Reference!$C$30,Reference!$D$30,IF(I77=Reference!$C$31,Reference!$D$31,IF(I77=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D78=Reference!$F$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$F$27,IF(I77=Reference!$C$28,Reference!$F$28,IF(I77=Reference!$C$29,Reference!$F$29,IF(I77=Reference!$C$30,Reference!$F$30,IF(I77=Reference!$C$31,Reference!$F$31,IF(I77=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D78=Reference!$H$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$H$27,IF(I77=Reference!$C$28,Reference!$H$28,IF(I77=Reference!$C$29,Reference!$H$29,IF(I77=Reference!$C$30,Reference!$H$30,IF(I77=Reference!$C$31,Reference!$H$31,IF(I77=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D78=Reference!$J$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$J$27,IF(I77=Reference!$C$28,Reference!$J$28,IF(I77=Reference!$C$29,Reference!$J$29,IF(I77=Reference!$C$30,Reference!$J$30,IF(I77=Reference!$C$31,Reference!$J$31,IF(I77=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D78=Reference!$M$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$M$27,IF(I77=Reference!$C$28,Reference!$M$28,IF(I77=Reference!$C$29,Reference!$M$29,IF(I77=Reference!$C$30,Reference!$M$30,IF(I77=Reference!$C$31,Reference!$M$31,IF(I77=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D78=Reference!$O$26,H78=\"9/9/3/3\"),IF(I77=Reference!$C$27,Reference!$O$27,IF(I77=Reference!$C$28,Reference!$O$28,IF(I77=Reference!$C$29,Reference!$O$29,IF(I77=Reference!$C$30,Reference!$O$30,IF(I77=Reference!$C$31,Reference!$O$31,IF(I77=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K78*(1+Reference!$C$18)","v":0},null,{"$f":"K78*(1+Reference!$C$18)^2","v":0},null,{"$f":"K78*(1+Reference!$C$18)^3","v":0},null,{"$f":"K78*(1+Reference!$C$18)^4","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D79=Reference!$D$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$D$27,IF(I79=Reference!$C$28,Reference!$D$28,IF(I79=Reference!$C$29,Reference!$D$29,IF(I79=Reference!$C$30,Reference!$D$30,IF(I79=Reference!$C$31,Reference!$D$31,IF(I79=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D79=Reference!$F$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$F$27,IF(I79=Reference!$C$28,Reference!$F$28,IF(I79=Reference!$C$29,Reference!$F$29,IF(I79=Reference!$C$30,Reference!$F$30,IF(I79=Reference!$C$31,Reference!$F$31,IF(I79=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D79=Reference!$H$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$H$27,IF(I79=Reference!$C$28,Reference!$H$28,IF(I79=Reference!$C$29,Reference!$H$29,IF(I79=Reference!$C$30,Reference!$H$30,IF(I79=Reference!$C$31,Reference!$H$31,IF(I79=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D79=Reference!$J$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$J$27,IF(I79=Reference!$C$28,Reference!$J$28,IF(I79=Reference!$C$29,Reference!$J$29,IF(I79=Reference!$C$30,Reference!$J$30,IF(I79=Reference!$C$31,Reference!$J$31,IF(I79=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D79=Reference!$M$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$M$27,IF(I79=Reference!$C$28,Reference!$M$28,IF(I79=Reference!$C$29,Reference!$M$29,IF(I79=Reference!$C$30,Reference!$M$30,IF(I79=Reference!$C$31,Reference!$M$31,IF(I79=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D79=Reference!$O$26,H79=\"9/9/3/3\"),IF(I79=Reference!$C$27,Reference!$O$27,IF(I79=Reference!$C$28,Reference!$O$28,IF(I79=Reference!$C$29,Reference!$O$29,IF(I79=Reference!$C$30,Reference!$O$30,IF(I79=Reference!$C$31,Reference!$O$31,IF(I79=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K79*(1+Reference!$C$18)","v":0},null,{"$f":"K79*(1+Reference!$C$18)^2","v":0},null,{"$f":"K79*(1+Reference!$C$18)^3","v":0},null,{"$f":"K79*(1+Reference!$C$18)^4","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D80=Reference!$D$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$D$27,IF(I80=Reference!$C$28,Reference!$D$28,IF(I80=Reference!$C$29,Reference!$D$29,IF(I80=Reference!$C$30,Reference!$D$30,IF(I80=Reference!$C$31,Reference!$D$31,IF(I80=Reference!$C$32,Reference!$D32,0)))))),IF(AND(D80=Reference!$F$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$F$27,IF(I80=Reference!$C$28,Reference!$F$28,IF(I80=Reference!$C$29,Reference!$F$29,IF(I80=Reference!$C$30,Reference!$F$30,IF(I80=Reference!$C$31,Reference!$F$31,IF(I80=Reference!$C$32,Reference!$F$32,0)))))),IF(AND(D80=Reference!$H$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$H$27,IF(I80=Reference!$C$28,Reference!$H$28,IF(I80=Reference!$C$29,Reference!$H$29,IF(I80=Reference!$C$30,Reference!$H$30,IF(I80=Reference!$C$31,Reference!$H$31,IF(I80=Reference!$C$32,Reference!$H$32,0)))))),IF(AND(D80=Reference!$J$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$J$27,IF(I80=Reference!$C$28,Reference!$J$28,IF(I80=Reference!$C$29,Reference!$J$29,IF(I80=Reference!$C$30,Reference!$J$30,IF(I80=Reference!$C$31,Reference!$J$31,IF(I80=Reference!$C$32,Reference!$J$32,0)))))),IF(AND(D80=Reference!$M$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$M$27,IF(I80=Reference!$C$28,Reference!$M$28,IF(I80=Reference!$C$29,Reference!$M$29,IF(I80=Reference!$C$30,Reference!$M$30,IF(I80=Reference!$C$31,Reference!$M$31,IF(I80=Reference!$C$32,Reference!$M$32,0)))))),IF(AND(D80=Reference!$O$26,H80=\"9/9/3/3\"),IF(I80=Reference!$C$27,Reference!$O$27,IF(I80=Reference!$C$28,Reference!$O$28,IF(I80=Reference!$C$29,Reference!$O$29,IF(I80=Reference!$C$30,Reference!$O$30,IF(I80=Reference!$C$31,Reference!$O$31,IF(I80=Reference!$C$32,Reference!$O$32,0)))))),0))))))","v":0},null,{"$f":"K80*(1+Reference!$C$18)","v":0},null,{"$f":"K80*(1+Reference!$C$18)^2","v":0},null,{"$f":"K80*(1+Reference!$C$18)^3","v":0},null,{"$f":"K80*(1+Reference!$C$18)^4","v":0},null,0]
[null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(K75:L80)","v":0},null,{"$f":"SUM(M75:N80)","v":0},null,{"$f":"SUM(O75:P80)","v":0},null,{"$f":"SUM(Q75:R80)","v":0},null,{"$f":"SUM(S75:T80)","v":0},null,{"$f":"SUM(U75:W80)","v":0}]
[]
[null,"COMMENTS:"]

{"sheet":"Detailed Budget","index":3,"n_rows":87,"n_cols":18,"rows_kept":87,"cut":false,"hidden":false,"merged":[[81,1,81,2],[80,3,80,4],[79,13,79,14],[80,13,80,14],[79,9,79,10],[80,9,80,10],[79,11,79,12],[80,11,80,12],[79,5,79,6],[80,5,80,6],[79,7,79,8],[80,7,80,8],[79,0,79,2],[80,0,80,2],[36,13,36,14],[79,3,79,4],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[76,9,76,10],[77,9,77,10],[78,9,78,10],[76,11,76,12],[78,13,78,14],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[76,13,76,14],[77,13,77,14],[47,9,47,10],[47,11,47,12],[50,11,50,12],[56,13,56,14],[57,5,57,6],[78,11,78,12],[55,0,55,2],[78,5,78,6],[76,7,76,8],[77,7,77,8],[78,7,78,8],[76,3,76,4],[77,3,77,4],[78,3,78,4],[78,0,78,2],[73,0,73,2],[73,3,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[58,0,58,12],[76,5,76,6],[77,5,77,6],[57,0,57,2],[57,3,57,4],[57,11,57,12],[68,0,68,2],[69,3,69,4],[57,13,57,14],[56,0,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[50,0,50,2],[52,0,52,12],[52,13,52,14],[53,0,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[54,13,54,14],[54,0,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[76,0,76,2],[77,0,77,2],[65,13,65,14],[64,0,64,2],[67,13,67,14],[65,3,65,4],[65,7,65,8],[65,9,65,10],[68,5,68,6],[68,7,68,8],[68,9,68,10],[67,9,67,10],[67,11,67,12],[68,11,68,12],[68,13,68,14],[71,13,71,14],[72,3,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[77,11,77,12],[64,7,64,8],[64,9,64,10],[73,13,73,14],[62,9,62,10],[62,11,62,12],[60,13,60,14],[64,13,64,14],[61,13,61,14],[62,13,62,14],[63,13,63,14],[61,7,61,8],[61,9,61,10],[61,11,61,12],[66,9,66,10],[66,11,66,12],[70,3,70,4],[70,5,70,6],[70,7,70,8],[69,7,69,8],[69,9,69,10],[69,11,69,12],[70,0,70,2],[66,13,66,14],[67,3,67,4],[67,5,67,6],[67,7,67,8],[68,3,68,4],[69,5,69,6],[72,11,72,12],[72,13,72,14],[69,0,69,2],[71,3,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[69,13,69,14],[71,0,71,2],[70,9,70,10],[70,11,70,12],[70,13,70,14],[67,0,67,2],[72,0,72,2],[66,3,66,4],[66,5,66,6],[66,7,66,8],[60,5,60,6],[60,7,60,8],[60,9,60,10],[60,11,60,12],[65,5,65,6],[59,0,59,2],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[65,0,65,2],[65,11,65,12],[64,3,64,4],[64,5,64,6],[63,0,63,2],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[64,11,64,12],[60,0,60,2],[62,7,62,8],[62,3,62,4],[61,0,61,2],[62,0,62,2],[61,3,61,4],[61,5,61,6],[50,13,50,14],[51,0,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[50,7,50,8],[50,9,50,10],[50,3,50,4],[55,11,55,12],[55,13,55,14],[58,13,58,14],[59,13,59,14],[57,7,57,8],[57,9,57,10],[62,5,62,6],[60,3,60,4],[45,13,45,14],[46,0,46,12],[46,13,46,14],[47,0,47,2],[48,0,48,2],[49,0,49,2],[47,7,47,8],[48,7,48,8],[49,7,49,8],[47,13,47,14],[45,0,45,2],[45,9,45,10],[45,11,45,12],[47,3,47,4],[48,3,48,4],[49,3,49,4],[48,13,48,14],[49,13,49,14],[48,9,48,10],[49,9,49,10],[48,11,48,12],[49,11,49,12],[42,11,42,12],[42,9,42,10],[42,7,42,8],[47,5,47,6],[48,5,48,6],[49,5,49,6],[50,5,50,6],[45,3,45,4],[45,5,45,6],[45,7,45,8],[42,0,42,2],[37,9,37,10],[39,9,39,10],[39,7,39,8],[38,3,38,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[42,5,42,6],[37,7,37,8],[37,5,37,6],[39,0,39,2],[39,5,39,6],[37,0,37,1],[38,0,38,1],[37,3,37,4],[39,3,39,4],[35,9,35,10],[36,9,36,10],[35,5,35,6],[35,7,35,8],[36,7,36,8],[36,5,36,6],[38,11,38,12],[37,11,37,12],[35,0,35,1],[36,0,36,1],[36,3,36,4],[19,13,19,14],[20,13,20,14],[19,0,19,2],[21,13,21,14],[22,13,22,14],[22,9,22,10],[19,3,19,4],[19,5,19,6],[19,7,19,8],[19,9,19,10],[19,11,19,12],[21,0,21,1],[22,0,22,1],[21,11,21,12],[21,3,21,4],[22,3,22,4],[21,5,21,6],[22,5,22,6],[21,7,21,8],[22,11,22,12],[22,7,22,8],[20,0,20,1],[21,9,21,10],[39,13,39,14],[42,13,42,14],[39,11,39,12],[42,3,42,4],[35,3,35,4],[34,11,34,12],[27,7,27,8],[27,9,27,10],[33,9,33,10],[32,0,32,12],[33,5,33,6],[34,5,34,6],[32,13,32,14],[33,13,33,14],[34,13,34,14],[27,11,27,12],[38,13,38,14],[33,0,33,1],[34,0,34,1],[27,0,27,2],[35,13,35,14],[37,13,37,14],[35,11,35,12],[36,11,36,12],[27,5,27,6],[33,3,33,4],[34,3,34,4],[23,13,23,14],[24,13,24,14],[25,13,25,14],[24,5,24,6],[25,5,25,6],[26,13,26,14],[27,13,27,14],[34,9,34,10],[33,7,33,8],[34,7,34,8],[33,11,33,12],[23,0,23,1],[24,0,24,1],[25,0,25,1],[26,0,26,1],[87,1,95,14],[6,0,6,14],[14,10,14,14],[14,8,14,9],[16,10,16,14],[17,10,17,14],[16,8,16,9],[17,8,17,9],[16,2,16,6],[14,2,14,6],[83,13,83,14],[84,13,84,14],[83,3,83,4],[84,3,84,4],[83,5,83,6],[84,5,84,6],[83,7,83,8],[14,0,14,1],[16,0,16,1],[25,7,25,8],[84,7,84,8],[83,9,83,10],[84,9,84,10],[83,11,83,12],[84,11,84,12],[23,9,23,10],[24,9,24,10],[26,3,26,4],[26,5,26,6],[26,7,26,8],[23,11,23,12],[23,7,23,8],[24,7,24,8],[23,3,23,4],[24,3,24,4],[25,3,25,4],[23,5,23,6],[25,9,25,10],[24,11,24,12],[25,11,25,12],[44,0,44,14],[26,9,26,10],[26,11,26,12],[27,3,27,4]]}
[]
[]
[]
[]
[]
[]
["Texas Tech University, Office of Research Services: Project Budget Detail"]
[]
[]
[]
[]
[]
[]
[]
["PI Name",null,{"$f":"IF('Cover Page'!D13 <> \"\",'Cover Page'!D13,\" \")","v":" "},null,null,null,null,null,"Sponsor",null,{"$f":"IF('Cover Page'!D17 <> \"\", 'Cover Page'!D17,\" \" )","v":" "}]
[]
["Title",null,{"$f":"IF('Cover Page'!D15 <> \"\",'Cover Page'!D15,\" \" )","v":" "},null,null,null,null,null,"Project Start Date",null,{"$f":"IF('Cover Page'!D19 <> \"\", 'Cover Page'!D19,\" \" )","v":" "}]
[null,null,null,null,null,null,null,null,"Project End Date",null,{"$f":"IF('Cover Page'!J19 <> \"\", 'Cover Page'!J19,\" \" )","v":" "}]
[]
["Personnel Salary",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total"]
["Name",null,"Role"]
[{"$f":"'Personnel Expense Calculator'!B52","v":0},null,{"$f":"'Personnel Expense Calculator'!C52:D52","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G52,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J52,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M52,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P52,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S52,0)","v":0},null,{"$f":"SUM(D22:M22)","v":0}]
[{"$f":"'Personnel Expense Calculator'!B53","v":0},null,{"$f":"'Personnel Expense Calculator'!C53:D53","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G53,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J53,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M53,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P53,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S53,0)","v":0},null,{"$f":"SUM(D23:M23)","v":0}]
[{"$f":"'Personnel Expense Calculator'!B54","v":0},null,{"$f":"'Personnel Expense Calculator'!C54:D54","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G54,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J54,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M54,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P54,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S54,0)","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B55","v":0},null,{"$f":"'Personnel Expense Calculator'!C55:D55","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G55,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J55,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M55,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P55,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S55,0)","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B56","v":0},null,{"$f":"'Personnel Expense Calculator'!C56:D56","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G56,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J56,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M56,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P56,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S56,0)","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B57","v":0},null,{"$f":"'Personnel Expense Calculator'!C57:D57","v":0},{"$f":"ROUND('Personnel Expense Calculator'!G57,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!J57,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!M57,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!P57,0)","v":0},null,{"$f":"ROUND('Personnel Expense Calculator'!S57,0)","v":0},null,{"$f":"SUM(D27:M27)","v":0}]
["Total Salary",null,null,{"$f":"SUM(D22:E27)","v":0},null,{"$f":"SUM(F22:G27)","v":0},null,{"$f":"SUM(H22:I27)","v":0},null,{"$f":"SUM(J22:K27)","v":0},null,{"$f":"SUM(L22:M27)","v":0},null,{"$f":"SUM(N22:O27)","v":0}]
[]
[]
[]
[]
["Personnel Fringe Benefits",null,null,null,null,null,null,null,null,null,null,null,null,"Total"]
[{"$f":"'Personnel Expense Calculator'!B62","v":0},null,{"$f":"'Personnel Expense Calculator'!C62:D62","v":0},{"$f":"'Personnel Expense Calculator'!E62","v":0},null,{"$f":"'Personnel Expense Calculator'!G62","v":0},null,{"$f":"'Personnel Expense Calculator'!I62","v":0},null,{"$f":"'Personnel Expense Calculator'!K62","v":0},null,{"$f":"'Personnel Expense Calculator'!M62","v":0},null,{"$f":"SUM(D34:M34)","v":0}]
[{"$f":"'Personnel Expense Calculator'!B63","v":0},null,{"$f":"'Personnel Expense Calculator'!C63:D63","v":0},{"$f":"'Personnel Expense Calculator'!E63","v":0},null,{"$f":"'Personnel Expense Calculator'!G63","v":0},null,{"$f":"'Personnel Expense Calculator'!I63","v":0},null,{"$f":"'Personnel Expense Calculator'!K63","v":0},null,{"$f":"'Personnel Expense Calculator'!M63","v":0},null,{"$f":"SUM(D35:M35)","v":0}]
[{"$f":"'Personnel Expense Calculator'!B64","v":0},null,{"$f":"'Personnel Expense Calculator'!C64:D64","v":0},{"$f":"'Personnel Expense Calculator'!E64","v":0},null,{"$f":"'Personnel Expense Calculator'!G64","v":0},null,{"$f":"'Personnel Expense Calculator'!I64","v":0},null,{"$f":"'Personnel Expense Calculator'!K64","v":0},null,{"$f":"'Personnel Expense Calculator'!M64","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B65","v":0},null,{"$f":"'Personnel Expense Calculator'!C65:D65","v":0},{"$f":"'Personnel Expense Calculator'!E65","v":0},null,{"$f":"'Personnel Expense Calculator'!G65","v":0},null,{"$f":"'Personnel Expense Calculator'!I65","v":0},null,{"$f":"'Personnel Expense Calculator'!K65","v":0},null,{"$f":"'Personnel Expense Calculator'!M65","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B66","v":0},null,{"$f":"'Personnel Expense Calculator'!C66:D66","v":0},{"$f":"'Personnel Expense Calculator'!E66","v":0},null,{"$f":"'Personnel Expense Calculator'!G66","v":0},null,{"$f":"'Personnel Expense Calculator'!I66","v":0},null,{"$f":"'Personnel Expense Calculator'!K66","v":0},null,{"$f":"'Personnel Expense Calculator'!M66","v":0},null,0]
[{"$f":"'Personnel Expense Calculator'!B67","v":0},null,{"$f":"'Personnel Expense Calculator'!C67:D67","v":0},{"$f":"'Personnel Expense Calculator'!E67","v":0},null,{"$f":"'Personnel Expense Calculator'!G67","v":0},null,{"$f":"'Personnel Expense Calculator'!I67","v":0},null,{"$f":"'Personnel Expense Calculator'!K67","v":0},null,{"$f":"'Personnel Expense Calculator'!M67","v":0},null,{"$f":"SUM(D39:M39)","v":0}]
["Fringe Benefits",null,null,{"$f":"SUM(D34:E39)","v":0},null,{"$f":"SUM(F34:G39)","v":0},null,{"$f":"SUM(H34:I39)","v":0},null,{"$f":"SUM(J34:K39)","v":0},null,{"$f":"SUM(L34:M39)","v":0},null,{"$f":"SUM(N34:O39)","v":0}]
[]
[]
["Total Salary and Fringe",null,null,{"$f":"SUM(D40,D28)","v":0},null,{"$f":"SUM(F40,F28)","v":0},null,{"$f":"SUM(H40,H28)","v":0},null,{"$f":"SUM(J40,J28)","v":0},null,{"$f":"SUM(L40,L28)","v":0},null,{"$f":"SUM(N40,N28)","v":0}]
[]
["Equipment (Excluded from MTDC) "]
["Total Equipment",null,null,{"$f":"SUMIF('Equip Trav PartCost'!A16:A21, 1, 'Equip Trav PartCost'!I16:J21)","v":0},null,{"$f":"SUMIF('Equip Trav PartCost'!A16:A21, 2, 'Equip Trav PartCost'!I16:J21)","v":0},null,{"$f":"SUMIF('Equip Trav PartCost'!A16:A21, 3, 'Equip Trav PartCost'!I16:J21)","v":0},null,{"$f":"SUMIF('Equip Trav PartCost'!A16:A21, 4, 'Equip Trav PartCost'!I16:J21)","v":0},null,{"$f":"SUMIF('Equip Trav PartCost'!A16:A21, 5, 'Equip Trav PartCost'!I16:J21)","v":0},null,{"$f":"SUM(D46:M46)","v":0}]
["Travel"]
["Domestic",null,null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 1, 'Equip Trav PartCost'!C29:C34, \"Domestic\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 2, 'Equip Trav PartCost'!C29:C34, \"Domestic\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 3, 'Equip Trav PartCost'!C29:C34, \"Domestic\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 4, 'Equip Trav PartCost'!C29:C34, \"Domestic\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 5, 'Equip Trav PartCost'!C29:C34, \"Domestic\")","v":0},null,{"$f":"SUM(D48:M48)","v":0}]
["Foreign",null,null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 1, 'Equip Trav PartCost'!C29:C34, \"Foreign\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 2, 'Equip Trav PartCost'!C29:C34, \"Foreign\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 3, 'Equip Trav PartCost'!C29:C34, \"Foreign\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 4, 'Equip Trav PartCost'!C29:C34, \"Foreign\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 5, 'Equip Trav PartCost'!C29:C34, \"Foreign\")","v":0},null,{"$f":"SUM(D49:M49)","v":0}]
["In-State ",null,null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 1, 'Equip Trav PartCost'!C29:C34, \"State\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 2, 'Equip Trav PartCost'!C29:C34, \"State\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 3, 'Equip Trav PartCost'!C29:C34, \"State\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 4, 'Equip Trav PartCost'!C29:C34, \"State\")","v":0},null,{"$f":"SUMIFS('Equip Trav PartCost'!T29:T34, 'Equip Trav PartCost'!A29:A34, 5, 'Equip Trav PartCost'!C29:C34, \"State\")","v":0},null,{"$f":"SUM(D50:M50)","v":0}]
[]
["Total Travel",null,null,{"$f":"SUM(D48:E51)","v":0},null,{"$f":"SUM(F48:G51)","v":0},null,{"$f":"SUM(H48:I51)","v":0},null,{"$f":"SUM(J48:K51)","v":0},null,{"$f":"SUM(L48:M51)","v":0},null,{"$f":"SUM(N48:O51)","v":0}]
["Participant Support Costs (Excluded from MTDC) "]
["Stipends",null,null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=1),'Equip Trav PartCost'!D41:'Equip Trav PartCost'!D46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=2),'Equip Trav PartCost'!D41:'Equip Trav PartCost'!D46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=3),'Equip Trav PartCost'!D41:'Equip Trav PartCost'!D46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=4),'Equip Trav PartCost'!D41:'Equip Trav PartCost'!D46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=5),'Equip Trav PartCost'!D41:'Equip Trav PartCost'!D46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUM(D54:M54)","v":0}]
["Travel",null,null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=1),'Equip Trav PartCost'!G41:'Equip Trav PartCost'!G46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=2),'Equip Trav PartCost'!G41:'Equip Trav PartCost'!G46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=3),'Equip Trav PartCost'!G41:'Equip Trav PartCost'!G46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=4),'Equip Trav PartCost'!G41:'Equip Trav PartCost'!G46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=5),'Equip Trav PartCost'!G41:'Equip Trav PartCost'!G46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUM(D55:M55)","v":0}]
["Subsistance",null,null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=1),'Equip Trav PartCost'!I41:'Equip Trav PartCost'!I46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=2),'Equip Trav PartCost'!I41:'Equip Trav PartCost'!I46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=3),'Equip Trav PartCost'!I41:'Equip Trav PartCost'!I46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=4),'Equip Trav PartCost'!I41:'Equip Trav PartCost'!I46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=5),'Equip Trav PartCost'!I41:'Equip Trav PartCost'!I46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUM(D56:M56)","v":0}]
["Other",null,null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=1),'Equip Trav PartCost'!K41:'Equip Trav PartCost'!K46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=2),'Equip Trav PartCost'!K41:'Equip Trav PartCost'!K46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=3),'Equip Trav PartCost'!K41:'Equip Trav PartCost'!K46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=4),'Equip Trav PartCost'!K41:'Equip Trav PartCost'!K46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUMPRODUCT(--('Equip Trav PartCost'!A41:A46=5),'Equip Trav PartCost'!K41:'Equip Trav PartCost'!K46,'Equip Trav PartCost'!B41:'Equip Trav PartCost'!B46)","v":0},null,{"$f":"SUM(D57:M57)","v":0}]
["Total Participant Support Costs",null,null,{"$f":"SUM(D54:E57)","v":0},null,{"$f":"SUM(F54:G57)","v":0},null,{"$f":"SUM(H54:I57)","v":0},null,{"$f":"SUM(J54:K57)","v":0},null,{"$f":"SUM(L54:M57)","v":0},null,{"$f":"SUM(D58:M58)","v":0}]
["Other Direct Costs -Please click on hyperlink to itemize"]
["Materials and Supplies ",null,null,{"$f":"SUMIF('Other Direct Costs'!A18:A23, 1, 'Other Direct Costs'!M18:N23)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A18:A23, 2, 'Other Direct Costs'!M18:N23)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A18:A23, 3, 'Other Direct Costs'!M18:N23)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A18:A23, 4, 'Other Direct Costs'!M18:N23)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A18:A23, 5, 'Other Direct Costs'!M18:N23)","v":0},null,{"$f":"SUM(D60:M60)","v":0}]
["Publication Costs",null,null,{"$f":"SUMIF('Other Direct Costs'!A29:A34, 1, 'Other Direct Costs'!M29:N34)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A29:A34, 2, 'Other Direct Costs'!M29:N34)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A29:A34, 3, 'Other Direct Costs'!M29:N34)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A29:A34, 4, 'Other Direct Costs'!M29:N34)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A29:A34, 5, 'Other Direct Costs'!M29:N34)","v":0},null,0]
["Professional Service Agreement/Consultants/Honorarium",null,null,{"$f":"SUMIF('Other Direct Costs'!A40:A45, 1, 'Other Direct Costs'!M40:N45)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A40:A45, 2, 'Other Direct Costs'!M40:N45)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A40:A45, 3, 'Other Direct Costs'!M40:N45)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A40:A45, 4, 'Other Direct Costs'!M40:N45)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A40:A45, 5, 'Other Direct Costs'!M40:N45)","v":0},null,0]
["Vendor Contracts ",null,null,{"$f":"SUMIF('Other Direct Costs'!A51:A56, 1, 'Other Direct Costs'!M51:N56)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A51:A56, 2, 'Other Direct Costs'!M51:N56)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A51:A56, 3, 'Other Direct Costs'!M51:N56)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A51:A56, 4, 'Other Direct Costs'!M51:N56)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A51:A56, 5, 'Other Direct Costs'!M51:N56)","v":0},null,0]
["Subawards subject to F&A rate",null,null,{"$f":"'Sub Awards'!D112:E112","v":0},null,{"$f":"'Sub Awards'!F112:G112","v":0},null,{"$f":"'Sub Awards'!H112:I112","v":0},null,{"$f":"'Sub Awards'!J112:K112","v":0},null,{"$f":"'Sub Awards'!L112:M112","v":0},null,0]
["Subawards not subject to F&A rate (Excluded from MTDC) ",null,null,{"$f":"'Sub Awards'!D113:E113","v":0},null,{"$f":"'Sub Awards'!F113:G113","v":0},null,{"$f":"'Sub Awards'!H113:I113","v":0},null,{"$f":"'Sub Awards'!J113:K113","v":0},null,{"$f":"'Sub Awards'!L113:M113","v":0},null,0]
["Service Centers ",null,null,{"$f":"SUMIF('Other Direct Costs'!A62:A67, 1, 'Other Direct Costs'!M62:N67)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A62:A67, 2, 'Other Direct Costs'!M62:N67)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A62:A67, 3, 'Other Direct Costs'!M62:N67)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A62:A67, 4, 'Other Direct Costs'!M62:N67)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A62:A67, 5, 'Other Direct Costs'!M62:N67)","v":0},null,0]
["Graduate Tuition and Fees (Excluded from MTDC) ",null,null,{"$f":"'Personnel Expense Calculator'!K81","v":0},null,{"$f":"'Personnel Expense Calculator'!M81","v":0},null,{"$f":"'Personnel Expense Calculator'!O81","v":0},null,{"$f":"'Personnel Expense Calculator'!Q81","v":0},null,{"$f":"'Personnel Expense Calculator'!S81","v":0},null,{"$f":"SUM(D67:M67)","v":0}]
["Repair and Maintenance ",null,null,{"$f":"SUMIF('Other Direct Costs'!A73:A78, 1, 'Other Direct Costs'!M73:N78)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A73:A78, 2, 'Other Direct Costs'!M73:N78)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A73:A78, 3, 'Other Direct Costs'!M73:N78)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A73:A78, 4, 'Other Direct Costs'!M73:N78)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A73:A78, 5, 'Other Direct Costs'!M73:N78)","v":0},null,0]
["Human Subject Payments ",null,null,{"$f":"SUMIF('Other Direct Costs'!A84:A89, 1, 'Other Direct Costs'!M84:N89)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A84:A89, 2, 'Other Direct Costs'!M84:N89)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A84:A89, 3, 'Other Direct Costs'!M84:N89)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A84:A89, 4, 'Other Direct Costs'!M84:N89)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A84:A89, 5, 'Other Direct Costs'!M84:N89)","v":0},null,0]
["Animal Care costs ",null,null,{"$f":"SUMIF('Other Direct Costs'!A96:A101, 1, 'Other Direct Costs'!N96:O101)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A96:A101, 2, 'Other Direct Costs'!N96:O101)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A96:A101, 3, 'Other Direct Costs'!N96:O101)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A96:A101, 4, 'Other Direct Costs'!N96:O101)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A96:A101, 5, 'Other Direct Costs'!N96:O101)","v":0},null,0]
["Rental of research space and equipment (Excluded from MTDC) ",null,null,{"$f":"SUMIF('Other Direct Costs'!A107:A112, 1, 'Other Direct Costs'!M107:N112)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A107:A112, 2, 'Other Direct Costs'!M107:N112)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A107:A112, 3, 'Other Direct Costs'!M107:N112)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A107:A112, 4, 'Other Direct Costs'!M107:N112)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A107:A112, 5, 'Other Direct Costs'!M107:N112)","v":0},null,0]
["Other costs ,subject to F&A rate",null,null,{"$f":"SUMIF('Other Direct Costs'!A118:A123, 1, 'Other Direct Costs'!M118:N123)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A118:A123, 2, 'Other Direct Costs'!M118:N123)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A118:A123, 3, 'Other Direct Costs'!M118:N123)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A118:A123, 4, 'Other Direct Costs'!M118:N123)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A118:A123, 5, 'Other Direct Costs'!M118:N123)","v":0},null,0]
["Other Costs, not Subject to F&A rate (Excluded from MTDC)",null,null,{"$f":"SUMIF('Other Direct Costs'!A129:A134, 1, 'Other Direct Costs'!M129:N134)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A129:A134, 2, 'Other Direct Costs'!M129:N134)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A129:A134, 3, 'Other Direct Costs'!M129:N134)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A129:A134, 4, 'Other Direct Costs'!M129:N134)","v":0},null,{"$f":"SUMIF('Other Direct Costs'!A129:A134, 5, 'Other Direct Costs'!M129:N134)","v":0},null,0]
["Total Other Direct Costs",null,null,{"$f":"SUM(D60:E73)","v":0},null,{"$f":"SUM(F60:G73)","v":0},null,{"$f":"SUM(H60:I73)","v":0},null,{"$f":"SUM(J60:K73)","v":0},null,{"$f":"SUM(L60:M73)","v":0},null,{"$f":"SUM(D74:M74)","v":0}]
[]
[null,null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total",null,null,"Year","F&A Rate"]
["Total Direct Costs",null,null,{"$f":"SUM(D74,D58,D52,D46,D43)","v":0},null,{"$f":"SUM(F74,F58,F52,F46,F43)","v":0},null,{"$f":"SUM(H74,H58,H52,H46,H43)","v":0},null,{"$f":"SUM(J74,J58,J52,J46,J43)","v":0},null,{"$f":"SUM(L74,L58,L52,L46,L43)","v":0},null,{"$f":"SUM(D77:M77)","v":0},null,null,{"$f":"'Cover Page'!$J$37","v":1},{"$f":"'Cover Page'!$K$37","v":0}]
["Modified Total Direct Costs",null,null,{"$f":"D77-D46-D58-D65-D67-D71-D73","v":0},null,{"$f":"F77-F46-F58-F65-F67-F71-F73","v":0},null,{"$f":"H77-H46-H58-H65-H67-H71-H73","v":0},null,{"$f":"J77-J46-J58-J65-J67-J71-J73","v":0},null,{"$f":"L77-L46-L58-L65-L67-L71-L73","v":0},null,{"$f":"SUM(D78:M78)","v":0},null,null,{"$f":"'Cover Page'!$J$38","v":2},{"$f":"'Cover Page'!$K$38","v":0}]
["TDC minus Subs",null,null,{"$f":"D77-D64-D65","v":0},null,{"$f":"F77-F64-F65","v":0},null,{"$f":"H77-H64-H65","v":0},null,{"$f":"J77-J64-J65","v":0},null,{"$f":"L77-L64-L65","v":0},null,{"$f":"SUM(D79:M79)","v":0},null,null,{"$f":"'Cover Page'!$J$39","v":3},{"$f":"'Cover Page'!$K$39","v":0}]
["F&A",null,null,{"$f":"IF('Cover Page'!$J$21='Detailed Budget'!$A$77,'Detailed Budget'!D77*R77,IF('Cover Page'!$J$21='Detailed Budget'!$A$78,'Detailed Budget'!D78*R77,IF('Cover Page'!$J$21='Detailed Budget'!$A$79,'Detailed Budget'!D79*R77)))","v":0},null,{"$f":"IF('Cover Page'!$J$21='Detailed Budget'!$A$77,'Detailed Budget'!F77*R78,IF('Cover Page'!$J$21='Detailed Budget'!$A$78,'Detailed Budget'!F78*R78,IF('Cover Page'!$J$21='Detailed Budget'!$A$79,'Detailed Budget'!F79*R78)))","v":0},null,{"$f":"IF('Cover Page'!$J$21='Detailed Budget'!$A$77,'Detailed Budget'!H77*R79,IF('Cover Page'!$J$21='Detailed Budget'!$A$78,'Detailed Budget'!H78*R79,IF('Cover Page'!$J$21='Detailed Budget'!$A$79,'Detailed Budget'!H79*R79)))","v":0},null,{"$f":"IF('Cover Page'!$J$21='Detailed Budget'!$A$77,'Detailed Budget'!J77*R80,IF('Cover Page'!$J$21='Detailed Budget'!$A$78,'Detailed Budget'!J78*R80,IF('Cover Page'!$J$21='Detailed Budget'!$A$79,'Detailed Budget'!J79*R80)))","v":0},null,{"$f":"IF('Cover Page'!$J$21='Detailed Budget'!$A$77,'Detailed Budget'!L77*R81,IF('Cover Page'!$J$21='Detailed Budget'!$A$78,'Detailed Budget'!L78*R81,IF('Cover Page'!$J$21='Detailed Budget'!$A$79,'Detailed Budget'!L79*R81)))","v":0},null,{"$f":"SUM(D80:M80)","v":0},null,null,{"$f":"'Cover Page'!$J$40","v":4},{"$f":"'Cover Page'!$K$40","v":0}]
["Total Costs",null,null,{"$f":"SUM(D77,D80)","v":0},null,{"$f":"SUM(F77,F80)","v":0},null,{"$f":"SUM(H77,H80)","v":0},null,{"$f":"SUM(J77,J80)","v":0},null,{"$f":"SUM(L77,L80)","v":0},null,{"$f":"SUM(N77,N80)","v":0},null,null,{"$f":"'Cover Page'!$J$41","v":5},{"$f":"'Cover Page'!$K$41","v":0}]
[null,{"$f":"'Cover Page'!J21","v":0}]
[]
[null,null,"Target Total",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D84:M84)","v":0}]
[null,null,"Difference",{"$f":"D84-D81","v":0},null,{"$f":"F84-F81","v":0},null,{"$f":"H84-H81","v":0},null,{"$f":"J84-J81","v":0},null,{"$f":"L84-L81","v":0},null,{"$f":"SUM(D85:M85)","v":0}]
[]
[null,"COMMENTS:"]

{"sheet":"Sub Awards","index":4,"n_rows":115,"n_cols":18,"rows_kept":115,"cut":false,"hidden":false,"merged":[[9,16,10,27],[11,17,11,27],[12,17,12,27],[13,17,13,27],[14,17,14,27],[15,17,15,27],[13,0,13,2],[13,3,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[14,0,14,2],[14,3,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[12,0,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14],[10,0,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[9,0,9,2],[111,13,111,14],[112,13,112,14],[27,13,27,14],[28,13,28,14],[29,13,29,14],[30,13,30,14],[31,13,31,14],[38,13,38,14],[39,13,39,14],[40,13,40,14],[109,13,109,14],[110,13,110,14],[100,13,100,14],[101,13,101,14],[25,11,26,12],[38,7,38,8],[38,9,38,10],[38,11,38,12],[2,11,3,12],[106,13,107,14],[108,13,108,14],[16,13,17,14],[18,13,18,14],[19,13,19,14],[20,13,20,14],[21,13,21,14],[22,13,22,14],[25,13,26,14],[2,13,3,14],[19,9,19,10],[19,11,19,12],[20,9,20,10],[20,11,20,12],[21,9,21,10],[21,11,21,12],[22,9,22,10],[22,11,22,12],[27,11,27,12],[34,3,35,4],[34,5,35,6],[34,7,35,8],[34,9,35,10],[34,11,35,12],[34,13,35,14],[36,13,36,14],[37,13,37,14],[37,0,37,2],[37,3,37,4],[37,5,37,6],[37,7,37,8],[37,9,37,10],[37,11,37,12],[35,0,35,2],[19,3,19,4],[19,5,19,6],[19,7,19,8],[22,3,22,4],[22,5,22,6],[22,7,22,8],[20,3,20,4],[20,5,20,6],[20,7,20,8],[21,3,21,4],[21,5,21,6],[21,7,21,8],[29,11,29,12],[28,0,28,2],[28,3,28,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[16,1,16,2],[16,3,17,4],[16,5,17,6],[16,7,17,8],[18,3,18,4],[18,5,18,6],[18,7,18,8],[18,9,18,10],[18,11,18,12],[16,9,17,10],[16,11,17,12],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[22,0,22,2],[26,0,26,2],[25,1,25,2],[25,3,26,4],[25,5,26,6],[25,7,26,8],[31,3,31,4],[31,5,31,6],[31,7,31,8],[31,9,31,10],[27,0,27,2],[27,3,27,4],[27,5,27,6],[27,7,27,8],[27,9,27,10],[25,9,26,10],[29,0,29,2],[29,3,29,4],[29,5,29,6],[29,7,29,8],[29,9,29,10],[31,0,31,2],[31,11,31,12],[30,0,30,2],[30,3,30,4],[30,5,30,6],[30,7,30,8],[30,9,30,10],[30,11,30,12],[108,0,108,2],[108,3,108,4],[108,5,108,6],[108,7,108,8],[108,9,108,10],[108,11,108,12],[107,0,107,2],[106,3,107,4],[106,5,107,6],[106,7,107,8],[106,9,107,10],[106,11,107,12],[43,1,43,2],[43,3,44,4],[43,5,44,6],[43,7,44,8],[34,1,34,2],[112,0,112,2],[112,3,112,4],[112,5,112,6],[112,7,112,8],[112,9,112,10],[112,11,112,12],[111,0,111,2],[111,3,111,4],[111,5,111,6],[111,7,111,8],[111,9,111,10],[111,11,111,12],[110,0,110,2],[110,3,110,4],[110,5,110,6],[110,7,110,8],[110,9,110,10],[110,11,110,12],[109,0,109,2],[109,3,109,4],[109,5,109,6],[109,7,109,8],[109,9,109,10],[109,11,109,12],[38,0,38,2],[38,3,38,4],[36,0,36,2],[36,3,36,4],[36,5,36,6],[36,7,36,8],[36,9,36,10],[36,11,36,12],[38,5,38,6],[40,0,40,2],[40,3,40,4],[40,5,40,6],[40,7,40,8],[40,9,40,10],[40,11,40,12],[39,0,39,2],[39,3,39,4],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[43,11,44,12],[43,13,44,14],[44,0,44,2],[45,0,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[45,11,45,12],[45,13,45,14],[43,9,44,10],[46,0,46,2],[46,3,46,4],[46,5,46,6],[46,7,46,8],[46,9,46,10],[46,11,46,12],[46,13,46,14],[47,0,47,2],[47,3,47,4],[47,5,47,6],[47,7,47,8],[47,9,47,10],[47,11,47,12],[47,13,47,14],[48,0,48,2],[48,3,48,4],[48,5,48,6],[48,7,48,8],[48,9,48,10],[48,11,48,12],[48,13,48,14],[49,0,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[49,11,49,12],[49,13,49,14],[52,1,52,2],[52,3,53,4],[52,5,53,6],[52,7,53,8],[52,9,53,10],[52,11,53,12],[52,13,53,14],[53,0,53,2],[54,0,54,2],[54,3,54,4],[54,5,54,6],[54,7,54,8],[54,9,54,10],[54,11,54,12],[54,13,54,14],[55,0,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[56,0,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[56,13,56,14],[57,0,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[58,0,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[58,13,58,14],[61,1,61,2],[61,3,62,4],[61,5,62,6],[61,7,62,8],[61,9,62,10],[61,11,62,12],[61,13,62,14],[62,0,62,2],[63,0,63,2],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[64,0,64,2],[64,3,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[64,13,64,14],[65,0,65,2],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[66,0,66,2],[66,3,66,4],[66,5,66,6],[66,7,66,8],[66,9,66,10],[66,11,66,12],[66,13,66,14],[67,0,67,2],[67,3,67,4],[67,5,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[67,13,67,14],[70,1,70,2],[70,3,71,4],[70,5,71,6],[70,7,71,8],[70,9,71,10],[70,11,71,12],[70,13,71,14],[71,0,71,2],[72,0,72,2],[72,3,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,11,72,12],[72,13,72,14],[73,0,73,2],[73,3,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[73,13,73,14],[74,0,74,2],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[74,13,74,14],[75,0,75,2],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[76,0,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[76,13,76,14],[79,1,79,2],[79,3,80,4],[79,5,80,6],[79,7,80,8],[79,9,80,10],[79,11,80,12],[79,13,80,14],[80,0,80,2],[81,0,81,2],[81,3,81,4],[81,5,81,6],[81,7,81,8],[81,9,81,10],[81,11,81,12],[81,13,81,14],[82,0,82,2],[82,3,82,4],[82,5,82,6],[82,7,82,8],[82,9,82,10],[82,11,82,12],[82,13,82,14],[83,0,83,2],[83,3,83,4],[83,5,83,6],[83,7,83,8],[83,9,83,10],[83,11,83,12],[83,13,83,14],[84,0,84,2],[84,3,84,4],[84,5,84,6],[84,7,84,8],[84,9,84,10],[84,11,84,12],[84,13,84,14],[85,0,85,2],[85,3,85,4],[85,5,85,6],[85,7,85,8],[85,9,85,10],[85,11,85,12],[85,13,85,14],[88,1,88,2],[88,3,89,4],[88,5,89,6],[88,7,89,8],[88,9,89,10],[88,11,89,12],[88,13,89,14],[89,0,89,2],[90,0,90,2],[90,3,90,4],[90,5,90,6],[90,7,90,8],[90,9,90,10],[90,11,90,12],[90,13,90,14],[91,0,91,2],[91,3,91,4],[91,5,91,6],[91,7,91,8],[91,9,91,10],[91,11,91,12],[91,13,91,14],[92,0,92,2],[92,3,92,4],[92,5,92,6],[92,7,92,8],[92,9,92,10],[92,11,92,12],[92,13,92,14],[93,0,93,2],[93,3,93,4],[93,5,93,6],[93,7,93,8],[93,9,93,10],[93,11,93,12],[93,13,93,14],[94,0,94,2],[94,3,94,4],[94,5,94,6],[94,7,94,8],[94,9,94,10],[94,11,94,12],[94,13,94,14],[97,1,97,2],[97,3,98,4],[97,5,98,6],[97,7,98,8],[97,9,98,10],[97,11,98,12],[97,13,98,14],[98,0,98,2],[99,0,99,2],[99,3,99,4],[99,5,99,6],[99,7,99,8],[99,9,99,10],[99,11,99,12],[99,13,99,14],[100,5,100,6],[100,7,100,8],[100,9,100,10],[100,11,100,12],[101,0,101,2],[101,3,101,4],[101,5,101,6],[101,7,101,8],[101,9,101,10],[101,11,101,12],[115,1,123,14],[114,1,114,2],[2,0,2,9],[3,0,3,9],[16,16,17,16],[16,17,17,27],[18,17,18,27],[106,0,106,2],[102,0,102,2],[102,3,102,4],[102,5,102,6],[102,7,102,8],[102,9,102,10],[102,11,102,12],[102,13,102,14],[103,0,103,2],[103,3,103,4],[103,5,103,6],[103,7,103,8],[103,9,103,10],[103,11,103,12],[103,13,103,14],[100,0,100,2],[100,3,100,4]]}
[]
[]
["Texas Tech University, Office of Research Services",null,null,null,null,null,null,null,null,null,null,"F&A Threshold",null,25000]
["Project Budget Template "]
[]
[]
[]
[]
[]
["Project Summary",null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total",null,null,"INSTRUCTIONS FOR ENTERING SUBAWARDS"]
["Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D77","v":0},null,{"$f":"'Detailed Budget'!F77","v":0},null,{"$f":"'Detailed Budget'!H77","v":0},null,{"$f":"'Detailed Budget'!J77","v":0},null,{"$f":"'Detailed Budget'!L77","v":0},null,{"$f":"'Detailed Budget'!N77","v":0}]
["Modified Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D78","v":0},null,{"$f":"'Detailed Budget'!F78","v":0},null,{"$f":"'Detailed Budget'!H78","v":0},null,{"$f":"'Detailed Budget'!J78","v":0},null,{"$f":"'Detailed Budget'!L78","v":0},null,{"$f":"'Detailed Budget'!N78","v":0},null,null,"Name","Type in Name of Subaward: ie. University of Texas - Austin, ABC Company, etc."]
["TDC minus Subs",null,null,{"$f":"'Detailed Budget'!D79","v":0},null,{"$f":"'Detailed Budget'!F79","v":0},null,{"$f":"'Detailed Budget'!H79","v":0},null,{"$f":"'Detailed Budget'!J79","v":0},null,{"$f":"'Detailed Budget'!L79","v":0},null,{"$f":"'Detailed Budget'!N79","v":0},null,null,"Year 1-Year 5","Type in Direct Costs and Indirect Costs per year. "]
["F&A",null,null,{"$f":"'Detailed Budget'!D80","v":0},null,{"$f":"'Detailed Budget'!F80","v":0},null,{"$f":"'Detailed Budget'!H80","v":0},null,{"$f":"'Detailed Budget'!J80","v":0},null,{"$f":"'Detailed Budget'!L80","v":0},null,{"$f":"'Detailed Budget'!N80","v":0},null,null,"Total","This will automatically calculate. Do not edit or alter these values."]
["Total Costs",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"'Detailed Budget'!N81","v":0},null,null,"<$25k","This will automatically calculate. Do not edit or alter these values."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,">$25k","This will automatically calculate. Do not edit or alter these values."]
["Name:","abc",null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL",null,null,"Additional Subs","If you require more than 3 sub-awards please \"unhide\" rows 34-97 as needed.  If you need more than 10 sub-awards, please contact your ORS Administrator for assistance."]
["Sub 1"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D19:M19)","v":0},null,null,"Total Table","This will automatically calculate. Do not edit or alter these values."]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D20:M20)","v":0}]
["Total",null,null,{"$f":"SUM(D18:E20)","v":0},null,{"$f":"SUM(F18:G20)","v":0},null,{"$f":"SUM(H18:I20)","v":0},null,{"$f":"SUM(J18:K20)","v":0},null,{"$f":"SUM(L18:M20)","v":0},null,{"$f":"SUM(D21:M21)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D21<=25000,D21,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D21:G21)<=25000,F21,25000-D22))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D21:I21)<=25000,H21,25000-F22-D22))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D21:K21)<=25000,J21,25000-H22-F22-D22))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D21:M21)<=25000,L21,25000-F22-H22-J22-D22))","v":0},null,{"$f":"SUM(D22:M22)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D21,IF(D21>25000,D21-25000,0))","v":0},null,{"$f":"IF(N3=0,F21,IF(D21+F21>25000,F21-F22,0))","v":0},null,{"$f":"IF(N3=0,H21,IF(SUM(D21:I21)>25000,H21-H22,0))","v":0},null,{"$f":"IF(N3=0,J21,IF(SUM(D21:K21)>25000,J21-J22,0))","v":0},null,{"$f":"IF(N3=0,L21,IF(SUM(D21:M21)>25000,L21-L22,0))","v":0},null,{"$f":"SUM(D23:M23)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 2"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D28:M28)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D29:M29)","v":0}]
["Total",null,null,{"$f":"SUM(D28:E29)","v":0},null,{"$f":"SUM(F28:G29)","v":0},null,{"$f":"SUM(H28:I29)","v":0},null,0,null,0,null,{"$f":"SUM(D30:M30)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D30<=25000,D30,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D30:G30)<=25000,F30,25000-D31))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D30:I30)<=25000,H30,25000-F31-D31))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D30:K30)<=25000,J30,25000-D31-F31-H31))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F30:M30)<=25000,L30,25000-F31-H31-J31-D31))","v":0},null,{"$f":"SUM(D31:M31)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D30,IF(D30>25000,D30-25000,0))","v":0},null,{"$f":"IF(N3=0,F30,IF(D30+F30>25000,F30-F31,0))","v":0},null,{"$f":"IF(N3=0,H30,IF(SUM(D30:I30)>25000,H30-H31,0))","v":0},null,{"$f":"IF(N3=0,J30,IF(SUM(D30:K30)>25000,J30-J31,0))","v":0},null,{"$f":"IF(N3=0,L30,IF(SUM(D30:M30)>25000,L30-L31,0))","v":0},null,{"$f":"SUM(D32:M32)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 3"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D37:M37)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D38:M38)","v":0}]
["Total",null,null,{"$f":"SUM(D37:E38)","v":0},null,{"$f":"SUM(F37:G38)","v":0},null,{"$f":"SUM(H37:I38)","v":0},null,0,null,0,null,{"$f":"SUM(D39:M39)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D39<=25000,D39,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D39:G39)<=25000,F39,25000-D40))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D39:I39)<=25000,H39,25000-F40-D40))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D39:K39)<=25000,J39,25000-D40-F40-H40))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F39:M39)<=25000,L39,25000-F40-H40-J40-D40))","v":0},null,{"$f":"SUM(D40:M40)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D39,IF(D39>25000,D39-25000,0))","v":0},null,{"$f":"IF(N3=0,F39,IF(D39+F39>25000,F39-F40,0))","v":0},null,{"$f":"IF(N3=0,H39,IF(SUM(D39:I39)>25000,H39-H40,0))","v":0},null,{"$f":"IF(N3=0,J39,IF(SUM(D39:K39)>25000,J39-J40,0))","v":0},null,{"$f":"IF(N3=0,L39,IF(SUM(D39:M39)>25000,L39-L40,0))","v":0},null,{"$f":"SUM(D41:M41)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 4"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D46:M46)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D47:M47)","v":0}]
["Total",null,null,{"$f":"SUM(D46:E47)","v":0},null,{"$f":"SUM(F46:G47)","v":0},null,{"$f":"SUM(H46:I47)","v":0},null,{"$f":"SUM(J46:K47)","v":0},null,{"$f":"SUM(L46:M47)","v":0},null,{"$f":"SUM(D48:M48)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D48<=25000,D48,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D48:G48)<=25000,F48,25000-D49))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D48:I48)<=25000,H48,25000-F49-D49))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D48:K48)<=25000,J48,25000-D49-F49-H49))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F48:M48)<=25000,L48,25000-F49-H49-J49-D49))","v":0},null,{"$f":"SUM(D49:M49)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D48,IF(D48>25000,D48-25000,0))","v":0},null,{"$f":"IF(N3=0,F48,IF(D48+F48>25000,F48-F49,0))","v":0},null,{"$f":"IF(N3=0,H48,IF(SUM(D48:I48)>25000,H48-H49,0))","v":0},null,{"$f":"IF(N3=0,J48,IF(SUM(D48:K48)>25000,J48-J49,0))","v":0},null,{"$f":"IF(N3=0,L48,IF(SUM(D48:M48)>25000,L48-L49,0))","v":0},null,{"$f":"SUM(D50:M50)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 5"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D55:M55)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:M56)","v":0}]
["Total",null,null,{"$f":"SUM(D55:E56)","v":0},null,{"$f":"SUM(F55:G56)","v":0},null,{"$f":"SUM(H55:I56)","v":0},null,{"$f":"SUM(J55:K56)","v":0},null,{"$f":"SUM(L55:M56)","v":0},null,{"$f":"SUM(D57:M57)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D57<=25000,D57,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D57:G57)<=25000,F57,25000-D58))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D57:I57)<=25000,H57,25000-F58-D58))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D57:K57)<=25000,J57,25000-D58-F58-H58))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F57:M57)<=25000,L57,25000-F58-H58-J58-D58))","v":0},null,{"$f":"SUM(D58:M58)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D57,IF(D57>25000,D57-25000,0))","v":0},null,{"$f":"IF(N3=0,F57,IF(D57+F57>25000,F57-F58,0))","v":0},null,{"$f":"IF(N3=0,H57,IF(SUM(D57:I57)>25000,H57-H58,0))","v":0},null,{"$f":"IF(N3=0,J57,IF(SUM(D57:K57)>25000,J57-J58,0))","v":0},null,{"$f":"IF(N3=0,L57,IF(SUM(D57:M57)>25000,L57-L58,0))","v":0},null,{"$f":"SUM(D59:M59)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 6"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D64:M64)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D65:M65)","v":0}]
["Total",null,null,{"$f":"SUM(D64:E65)","v":0},null,{"$f":"SUM(F64:G65)","v":0},null,{"$f":"SUM(H64:I65)","v":0},null,{"$f":"SUM(J64:K65)","v":0},null,{"$f":"SUM(L64:M65)","v":0},null,{"$f":"SUM(D66:M66)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D66<=25000,D66,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D66:G66)<=25000,F66,25000-D67))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D66:I66)<=25000,H66,25000-F67-D67))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D66:K66)<=25000,J66,25000-D67-F67-H67))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F66:M66)<=25000,L66,25000-F67-H67-J67-D67))","v":0},null,{"$f":"SUM(D67:M67)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D66,IF(D66>25000,D66-25000,0))","v":0},null,{"$f":"IF(N3=0,F66,IF(D66+F66>25000,F66-F67,0))","v":0},null,{"$f":"IF(N3=0,H66,IF(SUM(D66:I66)>25000,H66-H67,0))","v":0},null,{"$f":"IF(N3=0,J66,IF(SUM(D66:K66)>25000,J66-J67,0))","v":0},null,{"$f":"IF(N3=0,L66,IF(SUM(D66:M66)>25000,L66-L67,0))","v":0},null,{"$f":"SUM(D68:M68)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 7"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D73:M73)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D74:M74)","v":0}]
["Total",null,null,{"$f":"SUM(D73:E74)","v":0},null,{"$f":"SUM(F73:G74)","v":0},null,{"$f":"SUM(H73:I74)","v":0},null,{"$f":"SUM(J73:K74)","v":0},null,{"$f":"SUM(L73:M74)","v":0},null,{"$f":"SUM(D75:M75)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D75<=25000,D75,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D75:G75)<=25000,F75,25000-D76))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D75:I75)<=25000,H75,25000-F76-D76))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D75:K75)<=25000,J75,25000-D76-F76-H76))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F75:M75)<=25000,L75,25000-F76-H76-J76-D76))","v":0},null,{"$f":"SUM(D76:M76)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D75,IF(D75>25000,D75-25000,0))","v":0},null,{"$f":"IF(N3=0,F75,IF(D75+F75>25000,F75-F76,0))","v":0},null,{"$f":"IF(N3=0,H75,IF(SUM(D75:I75)>25000,H75-H76,0))","v":0},null,{"$f":"IF(N3=0,J75,IF(SUM(D75:K75)>25000,J75-J76,0))","v":0},null,{"$f":"IF(N3=0,L75,IF(SUM(D75:M75)>25000,L75-L76,0))","v":0},null,{"$f":"SUM(D77:M77)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 8"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D82:M82)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D83:M83)","v":0}]
["Total",null,null,{"$f":"SUM(D82:E83)","v":0},null,{"$f":"SUM(F82:G83)","v":0},null,{"$f":"SUM(H82:I83)","v":0},null,{"$f":"SUM(J82:K83)","v":0},null,{"$f":"SUM(L82:M83)","v":0},null,{"$f":"SUM(D84:M84)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D84<=25000,D84,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D84:G84)<=25000,F84,25000-D85))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D84:I84)<=25000,H84,25000-F85-D85))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D84:K84)<=25000,J84,25000-D85-F85-H85))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F84:M84)<=25000,L84,25000-F85-H85-J85-D85))","v":0},null,{"$f":"SUM(D85:M85)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D84,IF(D84>25000,D84-25000,0))","v":0},null,{"$f":"IF(N3=0,F84,IF(D84+F84>25000,F84-F85,0))","v":0},null,{"$f":"IF(N3=0,H84,IF(SUM(D84:I84)>25000,H84-H85,0))","v":0},null,{"$f":"IF(N3=0,J84,IF(SUM(D84:K84)>25000,J84-J85,0))","v":0},null,{"$f":"IF(N3=0,L84,IF(SUM(D84:M84)>25000,L84-L85,0))","v":0},null,{"$f":"SUM(D86:M86)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 9"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D91:M91)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D92:M92)","v":0}]
["Total",null,null,{"$f":"SUM(D91:E92)","v":0},null,{"$f":"SUM(F91:G92)","v":0},null,{"$f":"SUM(H91:I92)","v":0},null,{"$f":"SUM(J91:K92)","v":0},null,{"$f":"SUM(L91:M92)","v":0},null,{"$f":"SUM(D93:M93)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D93<=25000,D93,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D93:G93)<=25000,F93,25000-D94))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D93:I93)<=25000,H93,25000-F94-D94))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D93:K93)<=25000,J93,25000-D94-F94-H94))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F93:M93)<=25000,L93,25000-F94-H94-J94-D94))","v":0},null,{"$f":"SUM(D94:M94)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D93,IF(D93>25000,D93-25000,0))","v":0},null,{"$f":"IF(N3=0,F93,IF(D93+F93>25000,F93-F94,0))","v":0},null,{"$f":"IF(N3=0,H93,IF(SUM(D93:I93)>25000,H93-H94,0))","v":0},null,{"$f":"IF(N3=0,J93,IF(SUM(D93:K93)>25000,J93-J94,0))","v":0},null,{"$f":"IF(N3=0,L93,IF(SUM(D93:M93)>25000,L93-L94,0))","v":0},null,{"$f":"SUM(D95:M95)","v":0}]
[]
[]
["Name:",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Sub 10"]
["Direct Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D100:M100)","v":0}]
["Indirect Costs",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D101:M101)","v":0}]
["Total",null,null,{"$f":"SUM(D100:E101)","v":0},null,{"$f":"SUM(F100:G101)","v":0},null,{"$f":"SUM(H100:I101)","v":0},null,{"$f":"SUM(J100:K101)","v":0},null,{"$f":"SUM(L100:M101)","v":0},null,{"$f":"SUM(D102:M102)","v":0}]
["<$25K",null,null,{"$f":"IF(N3=0,0,IF(D102<=25000,D102,25000))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D102:G102)<=25000,F102,25000-D103))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D102:I102)<=25000,H102,25000-F103-D103))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(D102:K102)<=25000,J102,25000-D103-F103-H103))","v":0},null,{"$f":"IF(N3=0,0,IF(SUM(F102:M102)<=25000,L102,25000-F103-H103-J103-D103))","v":0},null,{"$f":"SUM(D103:M103)","v":0}]
[">$25K",null,null,{"$f":"IF(N3=0,D102,IF(D102>25000,D102-25000,0))","v":0},null,{"$f":"IF(N3=0,F102,IF(D102+F102>25000,F102-F103,0))","v":0},null,{"$f":"IF(N3=0,H102,IF(SUM(D102:I102)>25000,H102-H103,0))","v":0},null,{"$f":"IF(N3=0,J102,IF(SUM(D102:K102)>25000,J102-J103,0))","v":0},null,{"$f":"IF(N3=0,L102,IF(SUM(D102:M102)>25000,L102-L103,0))","v":0},null,{"$f":"SUM(D104:M104)","v":0}]
[]
[]
[null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"TOTAL"]
["Total"]
["Direct Costs",null,null,{"$f":"SUM(D37,D28,D19,D46,D55,D64,D73,D82,D91,D100)","v":0},null,{"$f":"SUM(F37,F28,F19,F46,F55,F64,F73,F82,F91,F100)","v":0},null,{"$f":"SUM(H37,H28,H19,H46,H55,H64,H73,H82,H91,H100)","v":0},null,{"$f":"SUM(J37,J28,J19,J46,J55,J64,J73,J82,J91,J100)","v":0},null,{"$f":"SUM(L37,L28,L19,L46,L55,L64,L73,L82,L91,L100)","v":0},null,{"$f":"SUM(D109:M109)","v":0}]
["Indirect Costs",null,null,{"$f":"SUM(D38,D29,D20,D47,D56,D65,D74,D83,D92,D101)","v":0},null,{"$f":"SUM(F38,F29,F20,F47,F56,F65,F74,F83,F92,F101)","v":0},null,{"$f":"SUM(H38,H29,H20,H47,H56,H65,H74,H83,H92,H101)","v":0},null,{"$f":"SUM(J38,J29,J20,J47,J56,J65,J74,J83,J92,J101)","v":0},null,{"$f":"SUM(L38,L29,L20,L47,L56,L65,L74,L83,L92,L101)","v":0},null,{"$f":"SUM(D110:M110)","v":0}]
["Total",null,null,{"$f":"SUM(D109:E110)","v":0},null,{"$f":"SUM(F109:G110)","v":0},null,{"$f":"SUM(H109:I110)","v":0},null,{"$f":"SUM(J109:K110)","v":0},null,{"$f":"SUM(L109:M110)","v":0},null,{"$f":"SUM(D111:M111)","v":0}]
["<$25K",null,null,{"$f":"SUM(D40,D31,D22,D49,D58,D67,D76,D85,D94,D103)","v":0},null,{"$f":"SUM(F40,F31,F22,F49,F58,F67,F76,F85,F94,F103)","v":0},null,{"$f":"SUM(H40,H31,H22,H49,H58,H67,H76,H85,H94,H103)","v":0},null,{"$f":"SUM(J40,J31,J22,J49,J58,J67,J76,J85,J94,J103)","v":0},null,{"$f":"SUM(L40,L31,L22,L49,L58,L67,L76,L85,L94,L103)","v":0},null,{"$f":"SUM(D112:M112)","v":0}]
[">$25K",null,null,{"$f":"SUM(D41,D32,D23,D50,D59,D68,D77,D86,D95,D104)","v":0},null,{"$f":"SUM(F41,F32,F23,F50,F59,F68,F77,F86,F95,F104)","v":0},null,{"$f":"SUM(H41,H32,H23,H50,H59,H68,H77,H86,H95,H104)","v":0},null,{"$f":"SUM(J41,J32,J23,J50,J59,J68,J77,J86,J95,J104)","v":0},null,{"$f":"SUM(L41,L32,L23,L50,L59,L68,L77,L86,L95,L104)","v":0},null,{"$f":"SUM(D113:M113)","v":0}]
[]
[null,"COMMENTS:"]

{"sheet":"Equip Trav PartCost","index":5,"n_rows":52,"n_cols":26,"rows_kept":52,"cut":false,"hidden":false,"merged":[[31,6,31,7],[32,6,32,7],[44,12,44,13],[45,12,45,13],[32,14,32,15],[33,6,33,7],[28,6,28,7],[29,6,29,7],[20,8,20,9],[40,6,40,7],[41,6,41,7],[42,6,42,7],[43,6,43,7],[44,6,44,7],[39,10,39,11],[40,10,40,11],[41,10,41,11],[42,10,42,11],[43,10,43,11],[44,10,44,11],[42,8,42,9],[44,8,44,9],[26,9,27,9],[26,10,27,10],[18,8,18,9],[19,8,19,9],[15,6,15,7],[16,6,16,7],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[19,4,19,5],[46,8,46,11],[38,0,38,13],[39,3,39,5],[40,3,40,5],[41,3,41,5],[42,3,42,5],[43,3,43,5],[44,3,44,5],[45,3,45,5],[43,8,43,9],[40,8,40,9],[41,8,41,9],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[30,6,30,7],[46,12,46,13],[45,1,45,2],[45,6,45,7],[45,8,45,9],[45,10,45,11],[39,6,39,7],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[39,12,39,13],[40,12,40,13],[41,12,41,13],[42,12,42,13],[43,12,43,13],[39,8,39,9],[34,16,34,18],[25,0,25,19],[33,12,33,13],[33,14,33,15],[26,2,27,3],[32,12,32,13],[31,12,31,13],[30,12,30,13],[29,12,29,13],[28,12,28,13],[28,14,28,15],[26,18,27,18],[26,19,27,19],[26,0,27,0],[26,1,27,1],[26,4,27,5],[26,6,27,7],[26,8,27,8],[26,16,27,16],[26,17,27,17],[29,14,29,15],[30,14,30,15],[31,14,31,15],[28,4,28,5],[26,11,27,11],[26,12,27,13],[26,14,27,15],[13,0,13,9],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[20,1,20,3],[14,6,14,7],[14,8,14,9],[14,4,14,5],[14,1,14,3],[21,4,21,7],[21,8,21,9],[20,6,20,7],[20,4,20,5],[15,8,15,9],[16,8,16,9],[17,8,17,9],[15,1,15,3],[17,6,17,7],[18,6,18,7],[19,6,19,7],[9,1,9,3],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[6,4,6,5],[6,6,6,7],[6,8,6,9],[6,10,6,11],[6,12,6,13],[6,14,6,15],[7,1,7,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[7,10,7,11],[11,8,11,9],[11,10,11,11],[11,12,11,13],[11,14,11,15],[6,1,6,2],[7,12,7,13],[7,14,7,15],[8,1,8,3],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[10,1,10,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[11,1,11,3],[11,4,11,5],[11,6,11,7],[35,23,35,24],[35,25,35,33],[18,23,18,24],[18,25,18,33],[19,23,19,24],[19,25,19,33],[20,23,20,24],[20,25,20,33],[21,23,21,24],[21,25,21,33],[22,23,22,24],[22,25,22,33],[23,23,23,24],[23,25,23,33],[24,23,24,24],[24,25,24,33],[25,23,25,24],[25,25,25,33],[28,23,29,24],[28,25,29,33],[30,23,31,24],[17,23,17,24],[17,25,17,33],[26,23,27,24],[26,25,27,33],[34,23,34,24],[34,25,34,33],[30,25,31,33],[32,23,33,24],[32,25,33,33],[52,1,60,17],[51,1,51,2],[2,0,2,15],[3,0,3,15],[44,18,45,19],[44,20,45,28],[46,18,47,19],[46,20,47,28],[48,18,48,19],[48,20,48,28],[49,18,49,19],[49,20,49,28],[38,18,39,28],[40,18,40,19],[40,20,40,28],[41,18,41,19],[41,20,41,28],[42,18,42,19],[42,20,42,28],[43,18,43,19],[43,20,43,28],[14,23,15,33],[16,23,16,24],[16,25,16,33]]}
[]
[]
["Texas Tech University, Office of Research Services"]
["Project Budget Template "]
[]
[]
[null,"Project Summary",null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total"]
[null,"Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D77","v":0},null,{"$f":"'Detailed Budget'!F77","v":0},null,{"$f":"'Detailed Budget'!H77","v":0},null,{"$f":"'Detailed Budget'!J77","v":0},null,{"$f":"'Detailed Budget'!L77","v":0},null,{"$f":"'Detailed Budget'!N77","v":0}]
[null,"Modified Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D78","v":0},null,{"$f":"'Detailed Budget'!F78","v":0},null,{"$f":"'Detailed Budget'!H78","v":0},null,{"$f":"'Detailed Budget'!J78","v":0},null,{"$f":"'Detailed Budget'!L78","v":0},null,{"$f":"'Detailed Budget'!N78","v":0}]
[null,"TDC minus Subs",null,null,{"$f":"'Detailed Budget'!D79","v":0},null,{"$f":"'Detailed Budget'!F79","v":0},null,{"$f":"'Detailed Budget'!H79","v":0},null,{"$f":"'Detailed Budget'!J79","v":0},null,{"$f":"'Detailed Budget'!L79","v":0},null,{"$f":"'Detailed Budget'!N79","v":0}]
[null,"F&A",null,null,{"$f":"'Detailed Budget'!D80","v":0},null,{"$f":"'Detailed Budget'!F80","v":0},null,{"$f":"'Detailed Budget'!H80","v":0},null,{"$f":"'Detailed Budget'!J80","v":0},null,{"$f":"'Detailed Budget'!L80","v":0},null,{"$f":"'Detailed Budget'!N80","v":0}]
[null,"Total Costs",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"'Detailed Budget'!N81","v":0}]
[]
["Equipment"]
["Year","Item",null,null,"Number of Items",null,"Price",null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions on Entering Travel"]
[null,null,null,null,null,null,null,null,{"$f":"E16*G16","v":0}]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,"Type in the appropriate Year (ie: 1-5)."]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Month",null,"Type in month expense will occur, if necessary."]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Travel Type",null,"Please select one from the drop down menu: State, Domestic, Foreign. "]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Departure Location",null,"Type in Departure Location."]
[null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Arrival Destination",null,"Type in Arrival Destination."]
[null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(I16:J21)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Trips",null,"Type in the expected number of trips."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Travelers",null,"Type in the expected number of travelers."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Days",null,"Type in the expected number of days."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Number of Nights",null,"Type in the expected number of nights."]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Meeting Registration",null,"Type in amount of meeting registration, if applicable. "]
["Year","Month","Travel Type",null,"Departure Location",null,"Arrival Destination",null,"Number of Trips","# of Travelers","Number of Days","Number of Nights","Meeting Registration",null,"Rental Car/Ground Transport",null,"Airfare","Lodging","Per Diem","Total",null,null,null,"Rental Car/Ground Transport",null,"Type in expected amount of rental car or ground transportation expenses.  If you need assistance for estimate, please contact your ORS Administrator. Current mileage reimbusrement rate: https://fmx.cpa.texas.gov/fmx/travel/textravel/rates/current.php"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I29*J29*K29*S29+I29*J29*L29*R29+M29*J29*I29+O29*I29+J29*Q29*I29","v":0},null,null,null,"Airfare",null,"Type in expected amount of airefare.  If you need assistance with an estimate, please contact your ORS Administrator."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I30*J30*K30*S30+I30*J30*L30*R30+M30*J30*I30+O30*I30+J30*Q30*I30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,"Lodging",null,"Type in the allowed per diem for lodging based on location.  Use https://www.gsa.gov/travel/plan-book/per-diem-rates or contact your ORS Administrator."]
[null,null,null,null,null,null,null,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,null,null,null,null,null,null,null,0,null,null,null,"Per Diem",null,"Type in the allowed per diem based on location.  Use https://www.gsa.gov/travel/plan-book/per-diem-rates or contact your ORS Administrator."]
[null,null,null,null,null,null,null,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,null,null,null,null,"TOTAL",null,null,{"$f":"SUM(T29:T34)","v":0},null,null,null,"Total",null,"This cell will automatically calculate."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Row",null,"If additional rows are needed, please select as needed."]
[]
[]
["Participant Support Cost",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions on Entering Participant Support Cost"]
["Year","Number of Participants",null,"Stipend",null,null,"Travel",null,"Per Diem",null,"Other",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B41*D41+B41*G41+B41*I41+B41*K41","v":0},null,null,null,null,null,"Year",null,"Type in the appropriate Year (ie: 1-5)."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B42*D42+B42*G42+B42*I42+B42*K42","v":0},null,null,null,null,null,"Number of Participants",null,"Type in number of participants."]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Stipend",null,"Type in amount of expected stipend per participant. "]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Travel",null,"Type in expected amount of travel per participant."]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Per Diem",null,"Type in the allowed per diem based on location per participant.  Use https://www.gsa.gov/travel/plan-book/per-diem-rates or contact your ORS Administrator."]
[null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M41:N46)","v":0},null,null,null,null,null,"Others",null,"Type in amount of other costs relevant to Participant Support Costs (ie: materials and supplies, conference fees, etc)."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"This cell will automatically calculate."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Row",null,"If additional rows are needed, please select as needed."]
[]
[null,"COMMENTS:"]

{"sheet":"Other Direct Costs","index":6,"n_rows":137,"n_cols":22,"rows_kept":137,"cut":false,"hidden":false,"merged":[[26,18,27,28],[28,18,28,19],[28,20,28,28],[29,18,29,19],[29,20,29,28],[30,18,30,19],[30,20,30,28],[31,18,31,19],[31,20,31,28],[32,18,32,19],[32,20,32,28],[33,18,33,19],[33,20,33,28],[94,19,94,20],[94,21,94,29],[95,19,95,20],[95,21,95,29],[96,19,96,20],[96,21,96,29],[41,18,41,19],[41,20,41,28],[42,18,42,19],[42,20,42,28],[37,18,38,28],[39,18,39,19],[39,20,39,28],[40,18,40,19],[40,20,40,28],[92,19,93,29],[16,10,16,11],[16,12,16,13],[19,10,19,11],[19,12,19,13],[28,10,28,11],[28,12,28,13],[29,10,29,11],[29,12,29,13],[23,8,23,11],[23,12,23,13],[27,10,27,11],[27,12,27,13],[21,10,21,11],[21,12,21,13],[22,10,22,11],[22,12,22,13],[27,1,27,8],[28,1,28,8],[29,1,29,8],[30,10,30,11],[30,12,30,13],[34,8,34,11],[31,10,31,11],[5,0,5,3],[15,0,15,13],[16,1,16,8],[17,1,17,8],[32,1,32,8],[33,1,33,8],[17,10,17,11],[17,12,17,13],[31,12,31,13],[30,1,30,8],[31,1,31,8],[10,0,10,2],[10,3,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[7,3,7,4],[7,5,7,6],[43,12,43,13],[44,12,44,13],[41,12,41,13],[42,12,42,13],[39,12,39,13],[40,12,40,13],[38,1,38,11],[39,1,39,11],[40,1,40,11],[41,1,41,11],[42,1,42,11],[43,1,43,11],[44,1,44,11],[71,10,71,11],[71,12,71,13],[72,10,72,11],[72,12,72,13],[71,1,71,8],[72,1,72,8],[73,1,73,8],[74,1,74,8],[45,8,45,11],[45,12,45,13],[51,12,51,13],[52,12,52,13],[48,0,48,13],[49,1,49,11],[50,1,50,11],[51,1,51,11],[52,1,52,11],[65,12,65,13],[66,12,66,13],[70,0,70,13],[53,12,53,13],[54,12,54,13],[55,12,55,13],[56,12,56,13],[67,8,67,11],[67,12,67,13],[60,12,60,13],[61,12,61,13],[62,12,62,13],[63,12,63,13],[64,12,64,13],[60,1,60,11],[61,1,61,11],[62,1,62,11],[63,1,63,11],[64,1,64,11],[65,1,65,11],[66,1,66,11],[75,10,75,11],[75,12,75,13],[76,10,76,11],[76,12,76,13],[75,1,75,8],[76,1,76,8],[77,1,77,8],[73,10,73,11],[73,12,73,13],[74,10,74,11],[74,12,74,13],[81,0,81,13],[82,1,82,8],[83,1,83,8],[84,1,84,8],[85,1,85,8],[77,10,77,11],[77,12,77,13],[78,8,78,11],[78,12,78,13],[84,10,84,11],[84,12,84,13],[85,10,85,11],[85,12,85,13],[82,10,82,11],[82,12,82,13],[83,10,83,11],[83,12,83,13],[110,12,110,13],[111,12,111,13],[112,8,112,11],[112,12,112,13],[117,12,117,13],[118,12,118,13],[119,12,119,13],[108,12,108,13],[109,12,109,13],[116,1,116,11],[117,1,117,11],[118,1,118,11],[106,12,106,13],[132,12,132,13],[99,1,99,2],[99,7,99,8],[99,10,99,11],[100,1,100,2],[100,7,100,8],[100,10,100,11],[104,0,104,13],[105,1,105,11],[106,1,106,11],[107,1,107,11],[108,1,108,11],[109,1,109,11],[110,1,110,11],[111,1,111,11],[115,0,115,13],[105,12,105,13],[123,8,123,11],[131,1,131,11],[132,1,132,11],[119,1,119,11],[116,12,116,13],[107,12,107,13],[86,1,86,8],[87,1,87,8],[88,1,88,8],[93,13,94,14],[93,0,94,0],[93,1,94,2],[93,3,94,3],[95,1,95,2],[95,7,95,8],[95,10,95,11],[86,10,86,11],[86,12,86,13],[87,10,87,11],[87,12,87,13],[88,10,88,11],[88,12,88,13],[89,8,89,11],[89,12,89,13],[92,0,92,14],[93,9,94,9],[93,10,94,11],[93,12,94,12],[53,1,53,11],[54,1,54,11],[55,1,55,11],[59,0,59,13],[18,1,18,8],[19,1,19,8],[20,1,20,8],[21,1,21,8],[22,1,22,8],[26,0,26,13],[20,10,20,11],[20,12,20,13],[18,10,18,11],[18,12,18,13],[49,12,49,13],[50,12,50,13],[34,12,34,13],[38,12,38,13],[32,10,32,11],[32,12,32,13],[33,10,33,11],[33,12,33,13],[37,0,37,13],[56,8,56,11],[134,8,134,11],[134,12,134,13],[120,12,120,13],[121,12,121,13],[122,12,122,13],[123,12,123,13],[130,12,130,13],[131,12,131,13],[127,12,127,13],[128,12,128,13],[129,12,129,13],[133,1,133,11],[133,12,133,13],[122,1,122,11],[126,0,126,13],[127,1,127,11],[128,1,128,11],[129,1,129,11],[130,1,130,11],[120,1,120,11],[121,1,121,11],[7,7,7,8],[7,9,7,10],[7,11,7,12],[7,13,7,14],[8,0,8,2],[8,3,8,4],[8,5,8,6],[8,7,8,8],[8,9,8,10],[8,11,8,12],[8,13,8,14],[7,0,7,2],[105,19,105,20],[105,21,105,29],[11,0,11,2],[11,3,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[12,0,12,2],[12,3,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[99,13,99,14],[100,13,100,14],[101,15,101,16],[95,13,95,14],[96,13,96,14],[97,13,97,14],[98,13,98,14],[98,10,98,11],[101,19,101,20],[101,21,101,29],[102,19,102,20],[102,21,102,29],[103,19,103,20],[103,21,103,29],[104,19,104,20],[104,21,104,29],[97,21,97,29],[98,19,98,20],[98,21,98,29],[99,19,99,20],[99,21,99,29],[100,19,100,20],[100,21,100,29],[97,19,97,20],[137,1,145,13],[136,1,136,2],[2,0,2,14],[3,0,3,14],[101,13,101,14],[98,1,98,2],[98,7,98,8],[93,4,94,4],[93,5,94,5],[93,6,94,6],[93,7,94,8],[96,1,96,2],[96,7,96,8],[96,10,96,11],[97,1,97,2],[97,7,97,8],[97,10,97,11],[9,0,9,2],[9,3,9,4],[9,5,9,6],[9,7,9,8],[9,9,9,10],[9,11,9,12],[9,13,9,14]]}
[]
[]
["Texas Tech University, Office of Research Services"]
["Project Budget Template "]
[]
["Please use this page to itemize"]
[]
["Project Summary",null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total"]
["Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D77","v":0},null,{"$f":"'Detailed Budget'!F77","v":0},null,{"$f":"'Detailed Budget'!H77","v":0},null,{"$f":"'Detailed Budget'!J77","v":0},null,{"$f":"'Detailed Budget'!L77","v":0},null,{"$f":"'Detailed Budget'!N77","v":0}]
["Modified Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D78","v":0},null,{"$f":"'Detailed Budget'!F78","v":0},null,{"$f":"'Detailed Budget'!H78","v":0},null,{"$f":"'Detailed Budget'!J78","v":0},null,{"$f":"'Detailed Budget'!L78","v":0},null,{"$f":"'Detailed Budget'!N78","v":0}]
["TDC minus Subs",null,null,{"$f":"'Detailed Budget'!D79","v":0},null,{"$f":"'Detailed Budget'!F79","v":0},null,{"$f":"'Detailed Budget'!H79","v":0},null,{"$f":"'Detailed Budget'!J79","v":0},null,{"$f":"'Detailed Budget'!L79","v":0},null,{"$f":"'Detailed Budget'!N79","v":0}]
["F&A",null,null,{"$f":"'Detailed Budget'!D80","v":0},null,{"$f":"'Detailed Budget'!F80","v":0},null,{"$f":"'Detailed Budget'!H80","v":0},null,{"$f":"'Detailed Budget'!J80","v":0},null,{"$f":"'Detailed Budget'!L80","v":0},null,{"$f":"'Detailed Budget'!N80","v":0}]
["Total Costs",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"'Detailed Budget'!N81","v":0}]
[]
[]
["Materials & Supplies"]
["Year","Item",null,null,null,null,null,null,null,"# of Items","Price",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J18*K18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J19*K19","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,"TOTAL",null,null,null,{"$f":"SUM(M18:N23)","v":0}]
[]
[]
["Publication Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions on Entering M&S, Publication Costs, Human Subject Payments"]
["Year","Item",null,null,null,null,null,null,null,"# of Items","Price",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J29*K29","v":0},null,null,null,null,null,"Year",null,"Type in the appropriate Year (ie: 1-5)."]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J30*K30","v":0},null," ",null,null,null,"Item",null,"Type in description of item (ie: slide covers, gloves, glue, headlamps, etc). "]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"# of Items",null,"Type in number of requested items."]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Price",null,"Type in per unit cost of item."]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Total",null,"This cell will automatically calculate."]
[null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,"Add Row",null,"If additional rows are needed, please select as needed."]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M29:N34)","v":0}]
[]
[]
["Professional Service Agreement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions on Entering Professional Services Agreements, Vendor Contracts, Service Centers, Rental, Other Costs"]
["Year","Item",null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,"Type in the appropriate Year (ie: 1-5)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Item",null,"Type in description of item (ie: computing, scanning, analysis, etc). "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"Type in total amount, or \"=# of hours X $XX/hour\".  "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add Row",null,"If additional rows are needed, please select as needed."]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M40:N45)","v":0}]
[]
[]
["Vendor Contracts"]
["Year","Item",null,null,null,null,null,null,null,null,null,null,"Total"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M51:N56)","v":0}]
[]
[]
["Service Centers"]
["Year","Item",null,null,null,null,null,null,null,null,null,null,"Total"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M62:N67)","v":0}]
[]
[]
["Repairs & Maintenance"]
["Year","Item",null,null,null,null,null,null,null,"# of Items","Price",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J73*K73","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J74*K74","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J75*K75","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,"TOTAL",null,null,null,{"$f":"SUM(M73:N78)","v":0}]
[]
[]
["Human Subject Payment"]
["Year","Subject",null,null,null,null,null,null,null,"# of Subjects","Price",null,"Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J84*K84","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"J85*K85","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,"TOTAL",null,null,null,{"$f":"SUM(M84:N89)","v":0}]
[]
[]
["Animal Cost ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Instructions on Entering Animal Costs"]
["Year","Species",null,"# of Animals","Animals/Cage","Biological Safety Level","Per Animal Cost","Per Diem",null,"Number of Days","Breeding Fees",null,"Other Fees","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Year",null,"Please select year from drop down menu."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A96<>\"\",(D96*G96)+(D96/E96*H96*J96)+M96+K96,\"\")","v":""},null,null,null,null,null,"Species",null,"Type in animal species (ie: cow, sheep, mice, rat, dog, cat, ferret, etc)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"# of Animals",null,"Type in number of animals requested."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"Animals/Cage",null,"Type in number of animals per cage. (ie: Mice = up to 5/cage, Rats = up to 3/cage)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,"Biological Safety Level",null,"Type in Biological Sfatey Level (ie: I, II, III, IV)."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A100<>\"\",(D100*G100)+(D100/E100*H100*J100)+M100+K100,\"\")","v":""},null,null,null,null,null,"Per Animal Cost",null,"Type in unit price per animal including shipping. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(A101<>\"\",(D101*G101)+(D101/E101*H101*J101)+M101+K101,\"\")","v":""},null,null,null,null,null,"Per Diem",null,"Type in perdiem rate for species per Animal Care Services (https://www.depts.ttu.edu/iacuc/acrc/charges.php)."]
[null,null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(N96:O101)","v":0},null,null,null,null,null,"Number of Days",null,"Type in number of days animals are expected to be housed."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Breeding Fees",null,"Type in expected amount of breeding fees.  Please contact Animal Care Services for estimate."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other Fees",null,"Type in expected amount for other fees (ie: vet time, supplies/medications, necropsy, temporary caging, etc)."]
["Rental of Research Space & Equipments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",null,"This cell will automatically calculate."]
["Year","Item Description",null,null,null,null,null,null,null,null,null,null,"Total",null,null,null,null,null,null,"Add Row",null,"If additional rows are needed, please select as needed."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M107:N112)","v":0}]
[]
[]
["Other Costs, Subject to F&A"]
["Year","Item Description",null,null,null,null,null,null,null,null,null,null,"Total"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M118:N123)","v":0}]
[]
[]
["Other Costs, Not Subject to F&A"]
["Year","Item Description",null,null,null,null,null,null,null,null,null,null,"Total"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"TOTAL",null,null,null,{"$f":"SUM(M129:N134)","v":0}]
[]
[null,"COMMENTS:"]

{"sheet":"Reference","index":7,"n_rows":35,"n_cols":15,"rows_kept":35,"cut":false,"hidden":false,"merged":[[29,7,29,8],[30,5,30,6],[30,7,30,8],[31,5,31,6],[31,7,31,8],[29,5,29,6],[30,9,30,11],[31,9,31,11],[14,3,14,6],[15,3,15,6],[17,3,17,6],[29,3,29,4],[30,3,30,4],[31,3,31,4],[17,8,17,10],[18,8,18,10],[19,8,19,10],[20,8,20,10],[25,9,25,11],[26,9,26,11],[28,9,28,11],[27,9,27,11],[27,5,27,6],[27,7,27,8],[28,5,28,6],[28,7,28,8],[25,3,25,4],[31,14,31,15],[25,12,25,13],[26,12,26,13],[29,12,29,13],[30,12,30,13],[31,12,31,13],[27,12,27,13],[28,12,28,13],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[13,8,13,10],[14,8,14,10],[15,8,15,10],[13,2,13,6],[30,14,30,15],[21,8,21,10],[26,3,26,4],[22,8,22,10],[29,9,29,11],[24,2,24,15],[27,3,27,4],[28,3,28,4],[25,5,25,6],[25,7,25,8],[26,5,26,6],[26,7,26,8],[35,1,43,16],[34,1,34,2],[9,7,9,10],[1,0,1,6],[3,8,3,9],[16,7,16,10],[8,7,8,10],[10,8,10,10],[11,8,11,10],[12,8,12,10],[7,2,7,10],[10,3,10,6],[11,3,11,6],[12,3,12,6],[8,2,8,6],[16,2,16,6]]}
[]
["DO NOT CHANGE OR EDIT THE REFERENCE TABLE. "]
[]
[null,null,null,null,null,null,null,null,"Reference Table"]
[]
[]
[]
[null,null,"Benefit Summary "]
[null,null,"Fringe Rates",null,null,null,null,"Medical and Life Insurance for Full Time"]
[null,null,null,null,null,null,null,"FY23"]
[null,null,{"$f":"18%","v":0.18},"Faculty/ Staff",null,null,null,{"$f":"_xlfn.IFS(H10=\"FY23\",622.6,H10=\"\",622.6,H10=\"FY24\",622.602*1.1)","v":622.6},"Employee Only"]
[null,null,{"$f":"10%","v":0.1},"Retired Employees",null,null,null,{"$f":"_xlfn.IFS(H10=\"FY23\",980.6,H10=\"\",980.6,H10=\"FY24\",980.6*1.1)","v":980.6},"Employee and Spouse"]
[null,null,{"$f":"1%","v":0.01},"Students",null,null,null,{"$f":"_xlfn.IFS(H10=\"FY23\",862.3,H10=\"\",862.3,H10=\"FY24\",862.3*1.1)","v":862.3},"Employee and Children"]
[null,null,"Insurance escalator ",null,null,null,null,{"$f":"_xlfn.IFS(H10=\"FY23\",1220.3,H10=\"\",1220.3,H10=\"FY24\",1220.3*1.1)","v":1220.3},"Employee and Family"]
[null,null,{"$f":"10%","v":0.1},"Faculty/ Staff/Studens",null,null,null,{"$f":"AVERAGE(H11:H14)","v":921.45},"Average for Full Time"]
[null,null,null,null,null,null,null,{"$f":"0","v":0},"No Insurance"]
[null,null,"Tuition and Fees Escalator",null,null,null,null,"Medical and Life Insurance for Part Time"]
[null,null,{"$f":"5%","v":0.05},"Students Fees",null,null,null,{"$f":"H11*0.5","v":311.3},"Employee Only(PT)"]
[null,null,null,null,null,null,null,{"$f":"H12*0.5","v":490.3},"Employee and Spouse(PT)"]
[null,null,null,null,null,null,null,431.15,"Employee and Children(PT)"]
[null,null,null,null,null,null,null,610.15,"Employee and Family(PT)"]
[null,null,null,null,null,null,null,460.72500000000002,"Average for Part Time"]
[null,null,null,null,null,null,null,{"$f":"0","v":0}," No Insurance(PT)"]
[]
[null,null,"Tution Fees Grid for Students"]
[null,null,"Term","WCOE - Doctoral",null,"WCOE - Master's",null,"All Colleges except WCOE and RCOB - Doctoral",null,"All Colleges Except WCOE & RCOB - Masters",null,null,"RCOB - Doctoral",null,"RCOB - Masters"]
[null,null,"2022-09-01",10977,null,10059.200000000001,null,9165,null,9051.2000000000007,null,null,10293,null,9579.2000000000007]
[null,null,"2023-01-01",11173.14,null,10240.14,null,9323.33,null,9213.24,null,null,10472.48,null,9751.14]
[null,null,"2023-06-01",11369.28,null,10421.07,null,9481.65,null,9375.27,null,null,10651.95,null,9923.07]
[null,null,"2023-09-01",11525.85,null,{"$f":"F27*1.05","v":10562.160000000002},null,{"$f":"H27*1.05","v":9623.25},null,{"$f":"J27*1.05","v":9503.760000000002},null,null,10807.65,null,{"$f":"O27*1.05","v":10058.160000000002}]
[null,null,"2024-01-01",11731.79,null,10752.14,null,9789.49,null,{"$f":"J28*1.05","v":9673.902},null,null,10996.1,null,10238.69]
[null,null,"2024-06-01",11937.74,null,10942.1235,null,9955.7325000000001,null,9844.0335000000014,null,null,11184.55,null,10419.2235]
[]
[]
[null,"COMMENTS:"]

{"sheet":"Cost Share","index":8,"n_rows":99,"n_cols":22,"rows_kept":99,"cut":false,"hidden":false,"merged":[[37,15,37,16],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[42,15,42,16],[43,15,43,16],[44,15,44,16],[45,15,45,16],[32,21,32,22],[86,10,86,11],[86,12,86,13],[43,0,43,2],[41,13,41,14],[40,5,40,6],[40,7,40,8],[86,14,86,15],[44,0,44,2],[82,13,82,14],[80,13,80,14],[81,0,81,2],[81,3,81,4],[44,3,44,4],[44,5,44,6],[44,7,44,8],[44,9,44,10],[44,11,44,12],[44,13,44,14],[41,0,41,2],[42,0,42,2],[81,5,81,6],[81,7,81,8],[81,9,81,10],[90,8,90,9],[90,10,90,11],[90,12,90,13],[90,14,90,15],[89,0,89,2],[89,6,89,7],[89,8,89,9],[89,10,89,11],[91,6,91,7],[91,8,91,9],[91,10,91,11],[91,12,91,13],[91,3,91,5],[91,16,91,17],[32,5,32,6],[32,9,32,10],[32,13,32,14],[32,17,32,18],[88,0,88,2],[88,6,88,7],[91,14,91,15],[86,16,86,17],[87,3,87,5],[87,16,87,17],[88,3,88,5],[88,16,88,17],[89,3,89,5],[89,16,89,17],[90,3,90,5],[90,16,90,17],[87,14,87,15],[86,6,86,7],[86,8,86,9],[91,0,91,2],[89,14,89,15],[90,0,90,2],[90,6,90,7],[88,8,88,9],[88,10,88,11],[88,12,88,13],[88,14,88,15],[81,13,81,14],[89,12,89,13],[87,0,87,2],[87,6,87,7],[87,8,87,9],[87,10,87,11],[87,12,87,13],[83,0,83,2],[83,3,83,4],[83,5,83,6],[83,7,83,8],[83,9,83,10],[83,11,83,12],[83,13,83,14],[82,0,82,2],[82,3,82,4],[82,5,82,6],[82,7,82,8],[82,9,82,10],[82,11,82,12],[81,11,81,12],[80,0,80,2],[80,3,80,4],[80,5,80,6],[80,7,80,8],[80,9,80,10],[80,11,80,12],[78,13,78,14],[79,0,79,2],[79,3,79,4],[79,5,79,6],[79,7,79,8],[79,9,79,10],[79,11,79,12],[79,13,79,14],[78,0,78,2],[78,3,78,4],[78,5,78,6],[78,7,78,8],[78,9,78,10],[78,11,78,12],[76,13,76,14],[77,0,77,2],[77,3,77,4],[77,5,77,6],[77,7,77,8],[77,9,77,10],[77,11,77,12],[77,13,77,14],[76,0,76,2],[76,3,76,4],[76,5,76,6],[76,7,76,8],[76,9,76,10],[76,11,76,12],[74,13,74,14],[75,0,75,2],[75,3,75,4],[75,5,75,6],[75,7,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[74,0,74,2],[74,3,74,4],[74,5,74,6],[74,7,74,8],[74,9,74,10],[74,11,74,12],[72,13,72,14],[73,0,73,2],[73,3,73,4],[73,5,73,6],[73,7,73,8],[73,9,73,10],[73,11,73,12],[73,13,73,14],[72,0,72,2],[72,3,72,4],[72,5,72,6],[72,7,72,8],[72,9,72,10],[72,11,72,12],[70,13,70,14],[71,0,71,2],[71,3,71,4],[71,5,71,6],[71,7,71,8],[71,9,71,10],[71,11,71,12],[71,13,71,14],[70,0,70,2],[70,3,70,4],[70,5,70,6],[70,7,70,8],[70,9,70,10],[70,11,70,12],[68,13,68,14],[69,0,69,2],[69,3,69,4],[69,5,69,6],[69,7,69,8],[69,9,69,10],[69,11,69,12],[69,13,69,14],[68,0,68,2],[68,3,68,4],[68,5,68,6],[68,7,68,8],[68,9,68,10],[68,11,68,12],[66,0,66,12],[66,13,66,14],[67,0,67,2],[67,3,67,4],[67,5,67,6],[67,7,67,8],[67,9,67,10],[67,11,67,12],[67,13,67,14],[64,13,64,14],[65,0,65,2],[65,3,65,4],[65,5,65,6],[65,7,65,8],[65,9,65,10],[65,11,65,12],[65,13,65,14],[64,0,64,2],[64,3,64,4],[64,5,64,6],[64,7,64,8],[64,9,64,10],[64,11,64,12],[62,13,62,14],[63,0,63,2],[63,3,63,4],[63,5,63,6],[63,7,63,8],[63,9,63,10],[63,11,63,12],[63,13,63,14],[62,0,62,2],[62,3,62,4],[62,5,62,6],[62,7,62,8],[62,9,62,10],[62,11,62,12],[60,0,60,12],[60,13,60,14],[61,0,61,2],[61,3,61,4],[61,5,61,6],[61,7,61,8],[61,9,61,10],[61,11,61,12],[61,13,61,14],[58,13,58,14],[59,0,59,2],[59,3,59,4],[59,5,59,6],[59,7,59,8],[59,9,59,10],[59,11,59,12],[59,13,59,14],[58,0,58,2],[58,3,58,4],[58,5,58,6],[58,7,58,8],[58,9,58,10],[58,11,58,12],[56,13,56,14],[57,0,57,2],[57,3,57,4],[57,5,57,6],[57,7,57,8],[57,9,57,10],[57,11,57,12],[57,13,57,14],[56,0,56,2],[56,3,56,4],[56,5,56,6],[56,7,56,8],[56,9,56,10],[56,11,56,12],[54,0,54,12],[54,13,54,14],[55,0,55,2],[55,3,55,4],[55,5,55,6],[55,7,55,8],[55,9,55,10],[55,11,55,12],[55,13,55,14],[49,11,49,12],[49,13,49,14],[49,0,49,2],[49,3,49,4],[49,5,49,6],[49,7,49,8],[49,9,49,10],[52,13,52,14],[53,0,53,2],[53,3,53,4],[53,5,53,6],[53,7,53,8],[53,9,53,10],[53,11,53,12],[53,13,53,14],[52,0,52,2],[52,3,52,4],[52,5,52,6],[52,7,52,8],[52,9,52,10],[52,11,52,12],[50,13,50,14],[51,0,51,2],[51,3,51,4],[51,5,51,6],[51,7,51,8],[51,9,51,10],[51,11,51,12],[51,13,51,14],[50,0,50,2],[50,3,50,4],[50,5,50,6],[50,7,50,8],[50,9,50,10],[50,11,50,12],[42,9,42,10],[42,11,42,12],[42,13,42,14],[43,5,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[43,13,43,14],[48,13,48,14],[45,11,45,12],[45,13,45,14],[42,5,42,6],[42,7,42,8],[48,0,48,12],[45,0,45,2],[45,3,45,4],[45,5,45,6],[45,7,45,8],[45,9,45,10],[40,9,40,10],[40,11,40,12],[40,13,40,14],[41,5,41,6],[41,7,41,8],[41,9,41,10],[41,11,41,12],[31,13,31,14],[30,0,30,2],[37,0,37,12],[38,13,38,14],[39,5,39,6],[39,7,39,8],[39,9,39,10],[39,11,39,12],[39,13,39,14],[37,13,37,14],[38,3,38,4],[39,3,39,4],[38,5,38,6],[38,7,38,8],[38,9,38,10],[38,11,38,12],[38,0,38,2],[29,0,29,2],[31,0,31,2],[31,5,31,6],[31,9,31,10],[27,21,27,22],[28,5,28,6],[28,9,28,10],[28,13,28,14],[28,17,28,18],[28,21,28,22],[27,5,27,6],[27,9,27,10],[27,13,27,14],[29,5,29,6],[29,9,29,10],[29,21,29,22],[30,5,30,6],[30,9,30,10],[30,13,30,14],[30,17,30,18],[30,21,30,22],[31,17,31,18],[31,21,31,22],[10,2,10,4],[10,5,10,6],[10,7,10,8],[10,9,10,10],[10,11,10,12],[10,13,10,14],[10,15,10,16],[11,2,11,4],[11,5,11,6],[11,7,11,8],[11,9,11,10],[11,11,11,12],[11,13,11,14],[11,15,11,16],[26,9,26,10],[24,19,24,22],[25,21,25,22],[26,21,26,22],[24,3,24,6],[25,5,25,6],[24,7,24,10],[25,9,25,10],[24,11,24,14],[25,13,25,14],[26,13,26,14],[26,17,26,18],[96,16,96,17],[96,0,96,5],[96,6,96,7],[96,8,96,9],[96,10,96,11],[96,12,96,13],[96,14,96,15],[24,15,24,18],[25,17,25,18],[29,13,29,14],[29,17,29,18],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[39,0,39,2],[40,0,40,2],[25,0,25,2],[26,0,26,2],[24,0,24,2],[27,17,27,18],[27,0,27,2],[28,0,28,2],[26,5,26,6],[12,2,12,4],[12,5,12,6],[12,7,12,8],[12,9,12,10],[12,11,12,12],[12,13,12,14],[12,15,12,16],[15,13,15,14],[15,15,15,16],[13,2,13,4],[13,5,13,6],[13,7,13,8],[13,9,13,10],[13,11,13,12],[13,13,13,14],[13,15,13,16],[14,2,14,4],[14,5,14,6],[14,7,14,8],[14,9,14,10],[14,11,14,12],[14,13,14,14],[14,15,14,16],[19,11,19,12],[20,11,20,12],[21,11,21,12],[18,9,18,10],[19,9,19,10],[20,9,20,10],[21,9,21,10],[15,2,15,4],[15,5,15,6],[15,7,15,8],[15,9,15,10],[15,11,15,12],[4,2,4,16],[5,2,5,16],[99,2,107,17],[19,15,19,16],[20,15,20,16],[21,13,21,14],[18,15,18,16],[21,15,21,16],[18,7,18,8],[19,7,19,8],[20,7,20,8],[21,7,21,8],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[18,2,18,4],[19,2,19,4],[20,2,20,4],[21,2,21,4],[18,13,18,14],[19,13,19,14],[20,13,20,14],[18,11,18,12]]}
[]
[]
[]
[]
[null,null,"Texas Tech University, Office of Research Services: Project Budget Template"]
[null,null,"Cost Share Budget  "]
[]
[]
[]
[]
[null,null,"Project Summary",null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total"]
[null,null,"Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D77","v":0},null,{"$f":"'Detailed Budget'!F77","v":0},null,{"$f":"'Detailed Budget'!H77","v":0},null,{"$f":"'Detailed Budget'!J77","v":0},null,{"$f":"'Detailed Budget'!L77","v":0},null,{"$f":"'Detailed Budget'!N77","v":0}]
[null,null,"Modified Total Direct Costs",null,null,{"$f":"'Detailed Budget'!D78","v":0},null,{"$f":"'Detailed Budget'!F78","v":0},null,{"$f":"'Detailed Budget'!H78","v":0},null,{"$f":"'Detailed Budget'!J78","v":0},null,{"$f":"'Detailed Budget'!L78","v":0},null,{"$f":"'Detailed Budget'!N78","v":0}]
[null,null,"TDC minus Subs",null,null,{"$f":"'Detailed Budget'!D79","v":0},null,{"$f":"'Detailed Budget'!F79","v":0},null,{"$f":"'Detailed Budget'!H79","v":0},null,{"$f":"'Detailed Budget'!J79","v":0},null,{"$f":"'Detailed Budget'!L79","v":0},null,{"$f":"'Detailed Budget'!N79","v":0}]
[null,null,"F&A",null,null,{"$f":"'Detailed Budget'!D80","v":0},null,{"$f":"'Detailed Budget'!F80","v":0},null,{"$f":"'Detailed Budget'!H80","v":0},null,{"$f":"'Detailed Budget'!J80","v":0},null,{"$f":"'Detailed Budget'!L80","v":0},null,{"$f":"'Detailed Budget'!N80","v":0}]
[null,null,"Total Costs",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"'Detailed Budget'!N81","v":0}]
[]
[]
[null,null,"Cost Share Summary",null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total"]
[null,null,"Total Sponsor Request",null,null,{"$f":"'Detailed Budget'!D81","v":0},null,{"$f":"'Detailed Budget'!F81","v":0},null,{"$f":"'Detailed Budget'!H81","v":0},null,{"$f":"'Detailed Budget'!J81","v":0},null,{"$f":"'Detailed Budget'!L81","v":0},null,{"$f":"SUM(F20:O20)","v":0}]
[null,null,"Total Cost Share",null,null,{"$f":"G92","v":0},null,{"$f":"I92","v":0},null,{"$f":"K92","v":0},null,{"$f":"M92","v":0},null,{"$f":"O92","v":0},null,{"$f":"SUM(F21:O21)","v":0}]
[null,null,"% of Total Project",null,null,{"$f":"IF(F20>0,(F21/(F21+F20)),\"-\")","v":"-"},null,{"$f":"IF(H20>0,(H21/(H21+H20)),\"-\")","v":"-"},null,{"$f":"IF(J20>0,(J21/(J21+J20)),\"-\")","v":"-"},null,{"$f":"IF(L20>0,(L21/(L21+L20)),\"-\")","v":"-"},null,{"$f":"IF(N20>0,(N21/(N21+N20)),\"-\")","v":"-"},null,{"$f":"IF(P20>0,(P21/(P21+P20)),\"-\")","v":"-"}]
[]
[]
[null,null,null,"Year1",null,null,null,"Year 2",null,null,null,"Year 3 ",null,null,null,"Year 4 ",null,null,null,"Year 5"]
["Item",null,null,"Months","Effort","Amount",null,"Months","Effort","Amount",null,"Months","Effort","Amount",null,"Months","Effort","Amount",null,"Months","Effort","Amount"]
[{"$f":"'Detailed Budget'!A22","v":0},null,null,null,null,{"$f":"E27*D27*'Personnel Expense Calculator'!G42","v":0},null,null,null,{"$f":"I27*H27*'Personnel Expense Calculator'!G42","v":0},null,null,null,{"$f":"M27*L27*'Personnel Expense Calculator'!G42","v":0},null,null,null,{"$f":"Q27*P27*'Personnel Expense Calculator'!G42","v":0},null,null,null,{"$f":"T27*U27*'Personnel Expense Calculator'!G42","v":0}]
[{"$f":"'Detailed Budget'!A23","v":0},null,null,null,null,{"$f":"E28*D28*'Personnel Expense Calculator'!G43","v":0},null,null,null,{"$f":"I28*H28*'Personnel Expense Calculator'!G43","v":0},null,null,null,{"$f":"M28*L28*'Personnel Expense Calculator'!G43","v":0},null,null,null,{"$f":"Q28*P28*'Personnel Expense Calculator'!G43","v":0},null,null,null,{"$f":"T28*U28*'Personnel Expense Calculator'!G43","v":0}]
[{"$f":"'Detailed Budget'!A24","v":0},null,null,null,null,{"$f":"E29*D29*'Personnel Expense Calculator'!G44","v":0},null,null,null,{"$f":"I29*H29*'Personnel Expense Calculator'!G44","v":0},null,null,null,{"$f":"M29*L29*'Personnel Expense Calculator'!G44","v":0},null,null,null,{"$f":"Q29*P29*'Personnel Expense Calculator'!G44","v":0},null,null,null,{"$f":"T29*U29*'Personnel Expense Calculator'!G44","v":0}]
[{"$f":"'Detailed Budget'!A25","v":0},null,null,null,null,{"$f":"E30*D30*'Personnel Expense Calculator'!G45","v":0},null,null,null,{"$f":"I30*H30*'Personnel Expense Calculator'!G45","v":0},null,null,null,{"$f":"M30*L30*'Personnel Expense Calculator'!G45","v":0},null,null,null,{"$f":"Q30*P30*'Personnel Expense Calculator'!G45","v":0},null,null,null,{"$f":"T30*U30*'Personnel Expense Calculator'!G45","v":0}]
[{"$f":"'Detailed Budget'!A26","v":0},null,null,null,null,{"$f":"E31*D31*'Personnel Expense Calculator'!G46","v":0},null,null,null,{"$f":"I31*H31*'Personnel Expense Calculator'!G46","v":0},null,null,null,{"$f":"M31*L31*'Personnel Expense Calculator'!G46","v":0},null,null,null,{"$f":"Q31*P31*'Personnel Expense Calculator'!G46","v":0},null,null,null,{"$f":"T31*U31*'Personnel Expense Calculator'!G46","v":0}]
[{"$f":"'Detailed Budget'!A27","v":0},null,null,null,null,{"$f":"E32*D32*'Personnel Expense Calculator'!G47","v":0},null,null,null,{"$f":"I32*H32*'Personnel Expense Calculator'!G47","v":0},null,null,null,{"$f":"M32*L32*'Personnel Expense Calculator'!G47","v":0},null,null,null,{"$f":"Q32*P32*'Personnel Expense Calculator'!G47","v":0},null,null,null,{"$f":"T32*U32*'Personnel Expense Calculator'!G47","v":0}]
[null,null,null,null,null,{"$f":"SUM(F27:G32)","v":0},null,null,null,{"$f":"SUM(J27:K32)","v":0},null,null,null,{"$f":"SUM(N27:O32)","v":0},null,null,null,{"$f":"SUM(R27:S32)","v":0},null,null,null,{"$f":"SUM(V27:W32)","v":0}]
[]
[]
[]
[]
["Personnel Fringe Benefits"]
[null,null,null,"Year 1",null,"Year 2",null,"Year 3",null,"Year 4",null,"Year 5",null,"Total"]
[{"$f":"A27","v":0},null,null,{"$f":"F27*IF('Personnel Expense Calculator'!E42=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E42=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E42=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E42=Reference!$D$13,0,D27*E27*IF('Personnel Expense Calculator'!L42=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L42=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L42=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L42=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L42=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L42=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L42=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L42=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L42=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L42=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L42=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L42=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J27*IF('Personnel Expense Calculator'!E42=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E42=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E42=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E42=Reference!$D$13,0,H27*I27*IF('Personnel Expense Calculator'!L42=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L42=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L42=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L42=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L42=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L42=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L42=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L42=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L42=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L42=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L42=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L42=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N27*IF('Personnel Expense Calculator'!E42=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E42=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E42=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E42=Reference!$D$13,0,L27*M27*IF('Personnel Expense Calculator'!L42=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L42=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L42=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L42=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L42=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L42=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L42=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L42=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L42=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L42=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L42=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L42=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R27*IF('Personnel Expense Calculator'!E42=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E42=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E42=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E42=Reference!$D$13,0,P27*Q27*IF('Personnel Expense Calculator'!L42=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L42=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L42=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L42=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L42=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L42=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L42=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L42=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L42=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L42=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L42=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L42=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V27*IF('Personnel Expense Calculator'!E42=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E42=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E42=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E42=Reference!$D$13,0,T27*U27*IF('Personnel Expense Calculator'!L42=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L42=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L42=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L42=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L42=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L42=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L42=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L42=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L42=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L42=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L42=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L42=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"SUM(D40:M40)","v":0}]
[0,null,null,{"$f":"F28*IF('Personnel Expense Calculator'!E43=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E43=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E43=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E43=Reference!$D$13,0,D28*E28*IF('Personnel Expense Calculator'!L43=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L43=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L43=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L43=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L43=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L43=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L43=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L43=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L43=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L43=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L43=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L43=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J28*IF('Personnel Expense Calculator'!E43=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E43=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E43=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E43=Reference!$D$13,0,H28*I28*IF('Personnel Expense Calculator'!L43=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L43=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L43=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L43=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L43=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L43=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L43=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L43=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L43=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L43=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L43=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L43=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N28*IF('Personnel Expense Calculator'!E43=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E43=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E43=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E43=Reference!$D$13,0,L28*M28*IF('Personnel Expense Calculator'!L43=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L43=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L43=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L43=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L43=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L43=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L43=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L43=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L43=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L43=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L43=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L43=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R28*IF('Personnel Expense Calculator'!E43=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E43=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E43=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E43=Reference!$D$13,0,P28*Q28*IF('Personnel Expense Calculator'!L43=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L43=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L43=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L43=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L43=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L43=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L43=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L43=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L43=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L43=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L43=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L43=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V28*IF('Personnel Expense Calculator'!E43=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E43=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E43=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E43=Reference!$D$13,0,T28*U28*IF('Personnel Expense Calculator'!L43=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L43=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L43=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L43=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L43=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L43=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L43=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L43=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L43=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L43=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L43=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L43=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"SUM(D41:M41)","v":0}]
[0,null,null,{"$f":"F29*IF('Personnel Expense Calculator'!E44=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E44=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E44=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E44=Reference!$D$13,0,D29*E29*IF('Personnel Expense Calculator'!L44=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L44=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L44=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L44=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L44=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L44=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L44=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L44=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L44=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L44=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L44=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L44=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J29*IF('Personnel Expense Calculator'!E44=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E44=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E44=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E44=Reference!$D$13,0,H29*I29*IF('Personnel Expense Calculator'!L44=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L44=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L44=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L44=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L44=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L44=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L44=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L44=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L44=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L44=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L44=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L44=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N29*IF('Personnel Expense Calculator'!E44=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E44=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E44=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E44=Reference!$D$13,0,L29*M29*IF('Personnel Expense Calculator'!L44=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L44=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L44=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L44=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L44=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L44=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L44=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L44=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L44=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L44=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L44=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L44=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R29*IF('Personnel Expense Calculator'!E44=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E44=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E44=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E44=Reference!$D$13,0,P29*Q29*IF('Personnel Expense Calculator'!L44=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L44=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L44=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L44=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L44=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L44=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L44=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L44=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L44=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L44=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L44=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L44=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V29*IF('Personnel Expense Calculator'!E44=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E44=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E44=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E44=Reference!$D$13,0,T29*U29*IF('Personnel Expense Calculator'!L44=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L44=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L44=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L44=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L44=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L44=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L44=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L44=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L44=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L44=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L44=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L44=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"SUM(D42:M42)","v":0}]
[0,null,null,{"$f":"F30*IF('Personnel Expense Calculator'!E45=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E45=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E45=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E45=Reference!$D$13,0,D30*E30*IF('Personnel Expense Calculator'!L45=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L45=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L45=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L45=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L45=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L45=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L45=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L45=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L45=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L45=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L45=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L45=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J30*IF('Personnel Expense Calculator'!E45=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E45=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E45=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E45=Reference!$D$13,0,H30*I30*IF('Personnel Expense Calculator'!L45=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L45=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L45=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L45=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L45=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L45=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L45=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L45=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L45=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L45=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L45=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L45=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N30*IF('Personnel Expense Calculator'!E45=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E45=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E45=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E45=Reference!$D$13,0,L30*M30*IF('Personnel Expense Calculator'!L45=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L45=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L45=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L45=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L45=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L45=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L45=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L45=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L45=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L45=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L45=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L45=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R30*IF('Personnel Expense Calculator'!E45=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E45=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E45=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E45=Reference!$D$13,0,P30*Q30*IF('Personnel Expense Calculator'!L45=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L45=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L45=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L45=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L45=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L45=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L45=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L45=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L45=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L45=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L45=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L45=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V30*IF('Personnel Expense Calculator'!E45=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E45=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E45=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E45=Reference!$D$13,0,T30*U30*IF('Personnel Expense Calculator'!L45=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L45=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L45=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L45=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L45=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L45=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L45=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L45=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L45=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L45=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L45=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L45=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,0]
[0,null,null,{"$f":"F31*IF('Personnel Expense Calculator'!E46=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E46=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E46=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E46=Reference!$D$13,0,D31*E31*IF('Personnel Expense Calculator'!L46=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L46=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L46=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L46=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L46=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L46=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L46=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L46=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L46=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L46=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L46=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L46=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J31*IF('Personnel Expense Calculator'!E46=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E46=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E46=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E46=Reference!$D$13,0,H31*I31*IF('Personnel Expense Calculator'!L46=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L46=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L46=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L46=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L46=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L46=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L46=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L46=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L46=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L46=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L46=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L46=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N31*IF('Personnel Expense Calculator'!E46=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E46=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E46=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E46=Reference!$D$13,0,L31*M31*IF('Personnel Expense Calculator'!L46=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L46=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L46=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L46=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L46=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L46=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L46=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L46=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L46=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L46=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L46=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L46=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R31*IF('Personnel Expense Calculator'!E46=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E46=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E46=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E46=Reference!$D$13,0,P31*Q31*IF('Personnel Expense Calculator'!L46=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L46=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L46=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L46=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L46=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L46=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L46=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L46=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L46=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L46=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L46=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L46=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V31*IF('Personnel Expense Calculator'!E46=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E46=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E46=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E46=Reference!$D$13,0,T31*U31*IF('Personnel Expense Calculator'!L46=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L46=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L46=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L46=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L46=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L46=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L46=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L46=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L46=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L46=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L46=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L46=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,0]
[0,null,null,{"$f":"F32*IF('Personnel Expense Calculator'!E47=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E47=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E47=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E47=Reference!$D$13,0,D32*E32*IF('Personnel Expense Calculator'!L47=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L47=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L47=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L47=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L47=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L47=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L47=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L47=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L47=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L47=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L47=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L47=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"J32*IF('Personnel Expense Calculator'!E47=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E47=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E47=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E47=Reference!$D$13,0,H32*I32*IF('Personnel Expense Calculator'!L47=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L47=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L47=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L47=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L47=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L47=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L47=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L47=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L47=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L47=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L47=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L47=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"N32*IF('Personnel Expense Calculator'!E47=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E47=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E47=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E47=Reference!$D$13,0,L32*M32*IF('Personnel Expense Calculator'!L47=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L47=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L47=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L47=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L47=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L47=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L47=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L47=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L47=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L47=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L47=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L47=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"R32*IF('Personnel Expense Calculator'!E47=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E47=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E47=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E47=Reference!$D$13,0,P32*Q32*IF('Personnel Expense Calculator'!L47=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L47=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L47=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L47=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L47=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L47=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L47=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L47=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L47=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L47=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L47=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L47=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,{"$f":"V32*IF('Personnel Expense Calculator'!E47=Reference!$D$11,Reference!$C$11,IF('Personnel Expense Calculator'!E47=Reference!$D$12,Reference!$C$12,IF('Personnel Expense Calculator'!E47=Reference!$D$13,Reference!$C$13,0)))+(IF('Personnel Expense Calculator'!E47=Reference!$D$13,0,T32*U32*IF('Personnel Expense Calculator'!L47=Reference!$I$11,Reference!$H$11,IF('Personnel Expense Calculator'!L47=Reference!$I$12,Reference!$H$12,IF('Personnel Expense Calculator'!L47=Reference!$I$13,Reference!$H$13,IF('Personnel Expense Calculator'!L47=Reference!$I$14,Reference!$H$14,IF('Personnel Expense Calculator'!L47=Reference!$I$15,Reference!$H$15,IF('Personnel Expense Calculator'!L47=Reference!$I$16,Reference!$H$16,IF('Personnel Expense Calculator'!L47=Reference!$I$18,Reference!$H$18,IF('Personnel Expense Calculator'!L47=Reference!$I$19,Reference!$H$19,IF('Personnel Expense Calculator'!L47=Reference!$I$20,Reference!$H$20,IF('Personnel Expense Calculator'!L47=Reference!$I$21,Reference!$H$21,IF('Personnel Expense Calculator'!L47=Reference!$I$22,Reference!$H$22,IF('Personnel Expense Calculator'!L47=Reference!$I$23,Reference!$H$23,0))))))))))))))","v":0},null,0]
["Fringe Benefits",null,null,{"$f":"SUM(D40:E45)","v":0},null,{"$f":"SUM(F40:G45)","v":0},null,{"$f":"SUM(H40:I45)","v":0},null,{"$f":"SUM(J40:K45)","v":0},null,{"$f":"SUM(L40:M45)","v":0},null,{"$f":"SUM(N40:O45)","v":0}]
[]
[]
["Equipments"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D50:M50)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D51:M51)","v":0}]
[null,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,null,0]
["Total Equipment",null,null,{"$f":"SUM(D50:E53)","v":0},null,{"$f":"SUM(F50:G53)","v":0},null,{"$f":"SUM(H50:I53)","v":0},null,{"$f":"SUM(J50:K53)","v":0},null,{"$f":"SUM(L50:M53)","v":0},null,{"$f":"SUM(N50:O53)","v":0}]
["Travel"]
["Domestic",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D56:M56)","v":0}]
["Foreign",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D57:M57)","v":0}]
["In-State ",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,null,0]
["Total Travel",null,null,{"$f":"SUM(D56:E59)","v":0},null,{"$f":"SUM(F56:G59)","v":0},null,{"$f":"SUM(H56:I59)","v":0},null,{"$f":"SUM(J56:K59)","v":0},null,{"$f":"SUM(L56:M59)","v":0},null,{"$f":"SUM(N56:O59)","v":0}]
["Participant Support Costs"]
["Stipends",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D62:M62)","v":0}]
["Travel",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D63:M63)","v":0}]
["Subsistance",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Participant Costs",null,null,{"$f":"SUM(D62:E65)","v":0},null,{"$f":"SUM(F62:G65)","v":0},null,{"$f":"SUM(H62:I65)","v":0},null,{"$f":"SUM(J62:K65)","v":0},null,{"$f":"SUM(L62:M65)","v":0},null,{"$f":"SUM(N62:O65)","v":0}]
["Other Direct Costs"]
["Materials and Supplies ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D68:M68)","v":0}]
["Repair and Maintenance ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D69:M69)","v":0}]
["Repair and Maintenance (Other)-Physical Plant Charges",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Publication Costs/Documentation/Dissemination",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Subawards subject to F&A rate",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Subawards not subject to F&A rate (Excluded from MTDC)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Graduate Tuition and Fees (Excluded from MTDC) ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other costs, subject to F&A rate",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Other Costs, not Subject to F&A rate (Excluded from MTDC)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Rental of research space and equipment (Excluded from MTDC)",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Vendor Contracts ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Human Subject Payments ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Service Centers ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Animal Care costs ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Honararium ",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Professional Service Agreement\\Consultants\\Other costs F&A",null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Costs",null,null,{"$f":"SUM(D68:E83)","v":0},null,{"$f":"SUM(F68:G83)","v":0},null,{"$f":"SUM(H68:I83)","v":0},null,{"$f":"SUM(J68:K83)","v":0},null,{"$f":"SUM(L68:M83)","v":0},null,{"$f":"SUM(N68:O83)","v":0}]
[]
[]
[null,null,null,null,null,null,"Year 1",null," Year 2",null," Year 3",null,"Year 4",null,"Year 5 ",null,"Total"]
["Total Direct Costs",null,null,null,null,null,{"$f":"SUM(D84,D66,D60,D54,D46,F33)","v":0},null,{"$f":"SUM(F84,F66,F60,F54,F46,J33)","v":0},null,{"$f":"SUM(H84,H66,H60,H54,H46,N33)","v":0},null,{"$f":"SUM(J84,J66,J60,J54,J46,R33)","v":0},null,{"$f":"SUM(L84,L66,L60,L54,L46,V33)","v":0},null,{"$f":"SUM(G88:P88)","v":0}]
["Modified Total Direct Costs",null,null,null,null,null,{"$f":"G88-D73-D74-D76-D77-D54-D66","v":0},null,{"$f":"I88-F73-F74-F76-F77-F54-F66","v":0},null,{"$f":"K88-H73-H74-H76-H77-H54-H66","v":0},null,{"$f":"M88-J73-J74-J76-J77-J54-J66","v":0},null,{"$f":"O88-L73-L74-L76-L77-L54-L66","v":0},null,{"$f":"SUM(G89:P89)","v":0}]
["TDC - Subs",null,null,null,null,null,{"$f":"G88-D72-D73","v":0},null,{"$f":"I88-F72-F73","v":0},null,{"$f":"K88-H72-H73","v":0},null,{"$f":"M88-J72-J73","v":0},null,{"$f":"O88-L72-L73","v":0},null,{"$f":"SUM(G90:P90)","v":0}]
["F&A",null,null,{"$f":"'Cover Page'!J21","v":0},null,null,{"$f":"'Cover Page'!K37*G89","v":0},null,{"$f":"'Cover Page'!K38*I89","v":0},null,{"$f":"'Cover Page'!K39*K89","v":0},null,{"$f":"'Cover Page'!K40*M89","v":0},null,{"$f":"'Cover Page'!K41*O89","v":0},null,0]
["Total Cost Share",null,null,null,null,null,{"$f":"SUM(G88+G91)","v":0},null,{"$f":"SUM(I88+I91)","v":0},null,{"$f":"SUM(K88+K91)","v":0},null,{"$f":"SUM(M88+M91)","v":0},null,{"$f":"SUM(O88+O91)","v":0},null,{"$f":"SUM(G92:P92)","v":0}]
[]
[]
[]
[]
["Required Minimum Cost Share",null,null,null,null,null,{"$f":"'Detailed Budget'!D81*'Cover Page'!E26-G92","v":0},null,{"$f":"'Detailed Budget'!F81*'Cover Page'!E26-I92","v":0},null,{"$f":"'Detailed Budget'!H81*'Cover Page'!E26-K92","v":0},null,{"$f":"'Detailed Budget'!J81*'Cover Page'!E26-M92","v":0},null,{"$f":"'Detailed Budget'!L81*'Cover Page'!E26-O92","v":0},null,{"$f":"SUM(G97:P97)","v":0}]
[]
[null,null,"COMMENTS:"]