{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["Instructions for Use","UVA Overview","UVA Personnel","Sub01","Sub02","Sub03","Sub04","Sub05","Sub06","Sub07","Sub08","Sub09","Sub10","Sub Formulas"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Instructions for Use","index":0,"n_rows":41,"n_cols":13,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,0,40,12],[20,0,20,12],[36,0,36,12],[6,0,6,12],[29,0,29,12],[31,0,31,12],[32,0,32,12],[33,0,33,12],[22,0,22,12],[23,0,23,12],[26,0,26,12],[27,0,27,12],[28,0,28,12],[7,0,7,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[10,0,10,12],[0,0,0,9],[1,0,1,12],[3,0,3,12],[11,0,11,12],[4,0,4,12],[5,0,5,12],[37,0,37,12],[38,0,38,12],[39,0,39,12],[15,0,15,12],[17,0,17,12],[18,0,18,12],[19,0,19,12],[21,0,21,12],[16,0,16,12],[30,0,30,12]]}
[null,null,null,null,null,null,null,null,null,null,null,null,"Version Date: 06/05/2023"]
["School of Medicine's Office of Grants and Contracts (SOMOGC) - RPPR/Progress Report Budget Workbook\nUser Instructions"]
[]
["• The SOMOGC RPPR/Progress Report Budget Workbook has two main sheets:\n\n"]
["– \"UVA Overview\" which contains all direct and indirect costs for subsequent budget period; and"]
["– \"UVA Personnel\" which allows the user to input salary support details for all personnel listed on the awarded grant for the subsequent budget period."]
["• Most cells in the budget workbook are locked, however, the sections that require user input are highlighted in blue."]
["• Please be patient when clicking on buttons in this workbook as it contains multiple macros and formulas so there may be some lag on occasion."]
[]
["UVA Overview Worksheet"]
["• Before inputing any data, please click on the orange button in the top left labeled, \"CLICK TO EDIT\".  [You may also need to click \"Edit Content\" in the yellow ribbon along the top of the worksheet when Excel opens the workbook for the first time.]"]
["• Insert the Prinicipal Investigator/Program Director (PI/PD) name in cell B1, award title in cell B2, upcoming grant year (e.g., 1) in cell C3,  Oracle Project/Award #s (123456/GB12345) in cell E3, and the subsequent budget period start and end dates in cells C4 and E4, respectively."]
["• The \"UVA Personnel\" section is divided into Senior/Key and Other Personnel. This section shows the subtotals for both personnel types which are pulled from the \"UVA Personnel\" worksheet."]
["• The Other Than Personnel Services (OTPS) section has collapsible groups for \"Equipment,\" \"Travel,\" \"Materials & Supplies,\" and \"Consultant Services\" so that you can itemize these project costs for greater detail. "]
["• In the area to the left of the row numbers, click on       to expand and      to collapse the grouped rows above the icons. When a grouped row is collapsed the remaining visible row will show the subtotal for that cost category."]
["• On the top left of the \"UVA Overview\" worksheet you can click           to collapse and expand all the grouped rows at one time."]
["• Only input capital equipment that does not encumber F&A in the \"Capital Equipment\" lines (12-16)."]
["• If the award has subawards you can click the \"Add Sub\" buttons in the \"Subaward/Consortium/Contractual Costs\" grouped row and a new worksheet will appear at the end of the workbook. "]
["• If you no longer need a subaward that has been added, click the \"Delete Sub\" button and the sheet and its data will be removed."]
["• There are four free fill itemized expenses lines (55-58) in the OTPS section; the first three lines (55-57) encumber F & A costs while the last line (58) does not encumber F & A costs."]
["• The \"Modified Total Direct Costs\" (MTDC) section shows the detailed expenses that are subtracted from the UVA Direct Costs to arrive at the MTDC base."]
["• In cell E79 choose the correct F & A rate to calculate the the award's F & A costs."]
["– Cell E79 is a drop down selection with seven options - UVA's four federally-negotiated F & A rates as well as three \"Other\" rates that can be manually entered (cells L7-L9)."]
["• The section below the \"Research & Related Budget for Next Reporting Period\" can be used to determine how much \"wiggle room\" exists between the budget template total costs and the total costs stipulated in the notice of award (NOA).  This section will automatically exclude consortium F&A expenses."]
[]
["UVA Personnel Worksheet"]
["• The PI/PD name and subsequent budget period dates will automatically populate from the start and end dates input on the \"UVA Overview\" sheet."]
["• In the \"Personnel\" column input the name of the senior/key or other personnel member."]
["• Choose whether the individual is senior/key or other personnel."]
["• Select either faculty, staff, wage, or part-time; this will automatically calculate the fringe benefit rate."]
["– Please note that when both academic and summer efforts are input the worksheet automatically calculates a blended fringe benefits rate that incorporates the faculty rate for the academic year and the part-time rate for the summer months."]
["• Enter the individual's instituational base salary."]
["• Depending on the individual's appointment you can choose the whether their effort is based on calendar, academic, and/or summer months. "]
["• Personnel information in the editable (blue) fields will copy into the subsequent years, but will remain editable in each year.  Calculations will automatically update for any changes made to effort, base salary, or Faculty/Staff designation.  "]
[]
["Subawards/Consortiums Worksheets"]
["• All subaward worksheets have the same basic functionality as the \"UVA Overview\" worksheet."]
["• At the top of the sheet insert the subaward organzation name in cell B1 and the subaward PI/PD in cell B2.  The org name will populate into the \"UVA Overview\" worksheet."]
["• Unlike the \"UVA Overview\" worksheet, the personnel subcategories are collapseble groups that you can expand to insert total salary + fringe support for all subaward personnel."]
["• In cells C66-G66 input the subaward organization's F & A rate for each year."]
["• If needed, below the \"Budget for the Entire Proposed Project Period\" is a collapsible scratch sheet for personnel salary calculations similar to the \"UVA Personnel\" worksheet. Please note that the data input in the scratch sheet does not populate in the budget."]

{"sheet":"UVA Overview","index":1,"n_rows":87,"n_cols":8,"rows_kept":87,"cut":false,"hidden":false,"merged":[[84,0,84,3],[0,6,0,7],[4,0,5,4],[1,1,1,4],[2,0,3,0],[0,1,0,4]]}
["Principal Investigator/Program Director:",null,null,null,null,null,"NOTE: If your award has a specific F&A rate, please fill it in in the blue box below marked \"Other\""]
["Award Title:",null,null,null,null,null,"F&A Description","F&A Rates"]
[null,"Grant Year:",null,"GR#:",null,null,"Off-Grounds",0.26]
[null,"Budget Period Start Date:",null,"Budget Period End Date:",null,null,"Other Sponsored Activities",0.38]
["RESEARCH & RELATED BUDGET\nFOR NEXT REPORTING PERIOD ",null,null,null,null,null,"Instruction",0.56000000000000005]
[null,null,null,null,null,null,"On-Grounds",0.61499999999999999]
[null,null,null,null,{"$f":"\"YEAR \"&C3","v":"YEAR "},null,"Other #1",0]
["UVA Senior/Key Personnel",null,null,null,{"$f":"SUMIF('UVA Personnel'!B8:B22,\"X\",'UVA Personnel'!Q8:Q22)","v":0},null,"Other #2",0]
["UVA Other Personnel",null,null,null,{"$f":"SUMIF('UVA Personnel'!C8:C22,\"X\",'UVA Personnel'!Q8:Q22)","v":0},null,"Other #3",0]
["Subtotal UVA Personnel",null,null,null,{"$f":"ROUND(SUM(E8:E9),0)","v":0}]
["Capital Equipment*",null,null,null,{"$f":"ROUND(SUM(E12:E16),0)","v":0},null,"NOTES"]
["[INSERT EQUIPMENT ITEM]",null,null,null,0]
["[INSERT EQUIPMENT ITEM]",null,null,null,0]
["[INSERT EQUIPMENT ITEM]",null,null,null,0]
["[INSERT EQUIPMENT ITEM]",null,null,null,0]
["[INSERT EQUIPMENT ITEM]",null,null,null,0]
["Travel",null,null,null,{"$f":"ROUND(SUM(E18:E19),0)","v":0}]
["Domestic Travel",null,null,null,0]
["Foreign Travel",null,null,null,0]
["Materials & Supplies  ",null,null,null,{"$f":"ROUND(SUM(E21:E31),0)","v":0}]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["[INSERT ITEMIZED MATERIALS & SUPPLIES]",null,null,null,0]
["Publication Costs ",null,null,null,0]
["Consultant Services",null,null,null,{"$f":"ROUND(SUM(E34:E38),0)","v":0}]
["[INSERT ITEMIZED CONSULTANT SERVICES]",null,null,null,0]
["[INSERT ITEMIZED CONSULTANT SERVICES]",null,null,null,0]
["[INSERT ITEMIZED CONSULTANT SERVICES]",null,null,null,0]
["[INSERT ITEMIZED CONSULTANT SERVICES]",null,null,null,0]
["[INSERT ITEMIZED CONSULTANT SERVICES]",null,null,null,0]
["ADP/Computer Services",null,null,null,0]
["Subawards/Consortium/Contractual Costs",null,null,null,{"$f":"ROUND(SUM(E41:E50),0)","v":0}]
[{"$f":"'Sub01'!$B$1&\" Subaward (#1)\"","v":" Subaward (#1)"},null,null,null,{"$f":"'Sub01'!$C$70","v":0}]
[{"$f":"'Sub02'!$B$1&\" Subaward (#2)\"","v":" Subaward (#2)"},null,null,null,{"$f":"'Sub02'!$C$70","v":0}]
[{"$f":"'Sub03'!$B$1&\" Subaward (#3)\"","v":" Subaward (#3)"},null,null,null,{"$f":"'Sub03'!$C$70","v":0}]
[{"$f":"'Sub04'!$B$1&\" Subaward (#4)\"","v":" Subaward (#4)"},null,null,null,{"$f":"'Sub04'!$C$70","v":0}]
[{"$f":"'Sub05'!$B$1&\" Subaward (#5)\"","v":" Subaward (#5)"},null,null,null,{"$f":"'Sub05'!$C$70","v":0}]
[{"$f":"'Sub06'!$B$1&\" Subaward (#6)\"","v":" Subaward (#6)"},null,null,null,{"$f":"'Sub06'!$C$70","v":0}]
[{"$f":"'Sub07'!$B$1&\" Subaward (#7)\"","v":" Subaward (#7)"},null,null,null,{"$f":"'Sub07'!$C$70","v":0}]
[{"$f":"'Sub08'!$B$1&\" Subaward (#8)\"","v":" Subaward (#8)"},null,null,null,{"$f":"'Sub08'!$C$70","v":0}]
[{"$f":"'Sub09'!$B$1&\" Subaward (#9)\"","v":" Subaward (#9)"},null,null,null,{"$f":"'Sub09'!$C$70","v":0}]
[{"$f":"'Sub10'!$B$1&\" Subaward (#10)\"","v":" Subaward (#10)"},null,null,null,{"$f":"'Sub10'!$C$70","v":0}]
["Equipment or Facility Rental/User Fees*",null,null,null,0]
["Alterations and Renovations",null,null,null,0]
["Tuition Remission*",null,null,null,0]
["Patient Care Costs*",null,null,null,0]
["[INSERT ADDITIONAL OTHER DIRECT COST #1]",null,null,null,0]
["[INSERT ADDITIONAL OTHER DIRECT COST #2]",null,null,null,0]
["[INSERT ADDITIONAL OTHER DIRECT COST #3]",null,null,null,0]
["OTHER DIRECT COSTS - NO F & A*",null,null,null,0]
["Subtotal UVA OTPS",null,null,null,{"$f":"E11+E17+E20+E32+E33+E39+E40+E51+E52+E53+E54+E55+E56+E57+E58","v":0}]
["UVA Total Direct Costs",null,null,null,{"$f":"E10+E59","v":0}]
["Less Capital Equipment*",null,null,null,{"$f":"-SUMIF(E12:E16,\">=0\",E12:E16)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,null,null,{"$f":"-E53","v":0}]
["Less Patient Care Costs*",null,null,null,0]
["Less Equipment or Facility Rental/User Fees*",null,null,null,{"$f":"-E51","v":0}]
["Less Other Direct Costs - No F & A*",null,null,null,{"$f":"-E58","v":0}]
["Less Subaward #1",null,null,null,{"$f":"'Sub Formulas'!E9","v":0}]
["Less Subaward #2",null,null,null,{"$f":"'Sub Formulas'!E17","v":0}]
["Less Subaward #3",null,null,null,{"$f":"'Sub Formulas'!E25","v":0}]
["Less Subaward #4",null,null,null,{"$f":"'Sub Formulas'!E33","v":0}]
["Less Subaward #5",null,null,null,{"$f":"'Sub Formulas'!E41","v":0}]
["Less Subaward #6",null,null,null,{"$f":"'Sub Formulas'!E49","v":0}]
["Less Subaward #7",null,null,null,{"$f":"'Sub Formulas'!E57","v":0}]
["Less Subaward #8",null,null,null,{"$f":"'Sub Formulas'!E65","v":0}]
["Less Subaward #9",null,null,null,{"$f":"'Sub Formulas'!E73","v":0}]
["Less Subaward #10",null,null,null,{"$f":"'Sub Formulas'!E81","v":0}]
["MTDC",null,null,null,{"$f":"E60+SUM(E61:E75)","v":0}]
["UVA F & A Costs",null,null,null,{"$f":"ROUND(E76*E78,0)","v":0}]
[null,null,null,null,{"$f":"IF(E79=\"Off-Grounds\",H3,IF(E79=\"Other Sponsored Activities\",H4,IF(E79=\"Instruction\",H5,IF(E79=\"On-Grounds\",H6,IF(E79=\"Other #1\",H7,IF(E79=\"Other #2\",H8,IF(E79=\"Other #3\",H9)))))))","v":0.61499999999999999}]
[null,null,null,"Select from Dropdowns in each column","On-Grounds"]
["TOTAL DIRECT + F & A COSTS",null,null,null,{"$f":"E60+E77","v":0}]
[]
[null,null,null,null,{"$f":"\"YEAR \"&C3","v":"YEAR "}]
["Total Costs for Next Budget Period listed in NOA",null,null,null,0]
["Total Budgeted Costs (Direct + Indirect)",null,null,null,{"$f":"E80","v":0}]
["Wiggle Room up to Total Costs in NOA",null,null,null,{"$f":"E83-E84","v":0}]
[]
[null,null,null,null,null,null,{"$f":"'Instructions for Use'!M1","v":"Version Date: 06/05/2023"}]

{"sheet":"UVA Personnel","index":2,"n_rows":23,"n_cols":30,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,6,6,6],[4,10,4,12],[5,7,6,7],[4,1,4,2],[0,4,0,13],[0,14,0,16],[5,11,6,11],[5,13,6,13],[2,16,3,16],[2,0,3,13],[0,0,0,3],[5,15,6,15],[5,3,6,3],[5,16,6,16],[5,1,6,1],[5,2,6,2],[5,10,6,10],[5,4,6,4],[5,5,6,5],[4,29,4,30],[22,0,22,8],[6,26,6,27],[4,14,4,16],[5,14,6,14],[5,12,6,12],[5,17,6,17],[5,18,6,18],[5,19,6,19],[5,21,6,21],[4,4,4,9],[5,20,6,20],[5,8,6,8],[5,0,6,0],[5,9,6,9]]}
["UVA Principal Investigator/Program Director:",null,null,null,{"$f":"IF('UVA Overview'!$B$1=\"\",\"\",'UVA Overview'!$B$1)","v":""},null,null,null,null,null,null,null,null,null,"**Note**  BLUE boxes require user input"]
[]
[{"$f":"\"DETAILED BUDGET PERIOD - YEAR \"&'UVA Overview'!C3","v":"DETAILED BUDGET PERIOD - YEAR "},null,null,null,null,null,null,null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"\"YEAR \"&'UVA Overview'!C3","v":"YEAR "},null,null,null,null,null,null,null,7.0000000000000007E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!C4=\"\",\"\",'UVA Overview'!C4)","v":""},{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""},null,null,null,null,null,null,null,null,0]
["PERSONNEL (Applicant Organization Only)","Put an X below on each line Sr. Key or Other Personnel\n(CHOOSE ONE PER ROW)",null,"Type Role for each person in Cells below","Put an X below on each line \nto determine fringe rate \n(CHOOSE ONE PER ROW)",null,null,null,null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data Validation\nRoles on Project"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Faculty","Staff","Wage","Part Time","GRA","Other","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY \nREQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer \nBenefit Rate",null,null,null,null,null,null,null,"PD/PI"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summer Benefit Rate",null,null,null,null,"Benefit Rates",null,null,"Co-PI"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R8*12/1","v":0},{"$f":"S8*9/1","v":0},{"$f":"T8*3/1","v":0},0,{"$f":"ROUND(($R8*$N8)+($S8*$N8)+(($N8/9)*(3)*($T8)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(K8>0,L8=0,M8=0),W8,IF(AND(K8=0,L8>0,M8=0),X8,IF(AND(K8=0,L8=0,M8>0),Y8,IF(AND(K8=0,L8>0,M8>0),X8+Y8,0)))),0),0)","v":0},{"$f":"ROUND(O8+P8, 0)","v":0},0,0,0,{"$f":"IF(E8=\"X\",$AB$8,IF(F8=\"X\",$AB$9,IF(G8=\"X\",$AB$10,IF(H8=\"X\",$AB$11,IF(I8=\"X\",$AB$12,IF(J8=\"X\",$AB$13,IF(E8=\"\",$AB$12,IF(F8=\"\",$AB$12,IF(G8=\"\",$AB$12,IF(H8=\"\",$AB$12,IF(I8=\"\",$AB$12,IF(J8=\"\",$AB$12))))))))))))","v":0},{"$f":"IF(M8>0, Y3, Y4)","v":0},{"$f":"N8*R8*U8","v":0},{"$f":"N8*S8*U8","v":0},{"$f":"((N8/9*3)*T8)*V8","v":0},null,"Faculty",0.28199999999999997,null,"Co-I"]
[null,null,null,null,null,null,null,null,null,null,0,{"$f":"S9*9/1","v":0},{"$f":"T9*3/1","v":0},0,{"$f":"ROUND(($R9*$N9)+($S9*$N9)+(($N9/9)*(3)*($T9)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(K9>0,L9=0,M9=0),W9,IF(AND(K9=0,L9>0,M9=0),X9,IF(AND(K9=0,L9=0,M9>0),Y9,IF(AND(K9=0,L9>0,M9>0),X9+Y9,0)))),0),0)","v":0},{"$f":"ROUND(O9+P9, 0)","v":0},0,0,0,0,{"$f":"IF(M9>0, Y3, Y4)","v":0},{"$f":"N9*R9*U9","v":0},{"$f":"N9*S9*U9","v":0},{"$f":"((N9/9*3)*T9)*V9","v":0},null,"Staff",0.38100000000000001,null,"Res. Asst."]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M10>0, Y3, Y4)","v":0},0,{"$f":"N10*S10*U10","v":0},{"$f":"((N10/9*3)*T10)*V10","v":0},null,"Wage",7.0000000000000007E-2,null,"Res. Tech."]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M11>0, Y3, Y4)","v":0},0,0,0,null,"Part time",0.28199999999999997,null,"CRC"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M12>0, Y3, Y4)","v":0},0,0,0,null,"GRA",0,null,"Lab Tech."]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M13>0, Y3, Y4)","v":0},0,0,0,null,"Other",null,null,"Data Analyst"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M14>0, Y3, Y4)","v":0},0,0,0,null,null,null,null,"Proj. Cord."]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M15>0, Y3, Y4)","v":0},0,0,0,null,null,null,null,"Biostatistician"]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M16>0, Y3, Y4)","v":0},0,0,0,null,null,null,null,"GRA"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"R17*12/1","v":0},{"$f":"S17*9/1","v":0},{"$f":"T17*3/1","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(M17>0, Y3, Y4)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M18>0, Y3, Y4)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M19>0, Y3, Y4)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M20>0, Y3, Y4)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M21>0, Y3, Y4)","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(M22>0, Y3, Y4)","v":0},0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O8:O22)","v":0},{"$f":"SUM(P8:P22)","v":0},{"$f":"SUM(Q8:Q22)","v":0},{"$f":"IFERROR(Q23/#REF!*100,\"\")","v":""}]

{"sheet":"Sub01","index":3,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[4,0,4,1],[0,1,0,2],[1,1,1,2],[2,0,3,0],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,8,77,8],[76,9,77,9],[76,10,77,10],[93,0,93,3],[6,0,7,2],[8,0,8,1],[76,3,77,3],[76,15,77,15],[71,1,71,7],[76,11,77,11],[75,1,75,3],[61,4,61,5],[76,4,77,4],[76,5,77,5],[76,13,77,13],[76,14,77,14],[73,10,74,10],[75,4,75,6],[75,8,75,10],[73,0,74,7],[76,12,77,12],[76,6,77,6],[76,7,77,7]]}
["Subaward #1 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"'UVA Overview'!C4","v":"00:00:00"}]
[null,"Budget Period End Date:",{"$f":"'UVA Overview'!E4","v":"00:00:00"}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M9","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},{"$f":"ROUND(I80+J80, 0)","v":0},null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,{"$f":"L86*12/1","v":0},{"$f":"M86*9/1","v":0},{"$f":"N86*3/1","v":0},null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub02","index":4,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[61,4,61,5],[0,1,0,2],[1,1,1,2],[4,0,4,1],[2,0,3,0],[6,0,7,2],[8,0,8,1],[76,15,77,15],[93,0,93,3],[76,11,77,11],[76,12,77,12],[76,13,77,13],[76,14,77,14],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,10,77,10],[75,1,75,3],[71,1,71,7],[73,0,74,7],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,6,77,6],[76,0,77,0]]}
["Subaward #2 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"'UVA Overview'!C4","v":"00:00:00"}]
[null,"Budget Period End Date:",{"$f":"'UVA Overview'!E4","v":"00:00:00"}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M17","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"C9","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub03","index":5,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[4,0,4,1],[6,0,7,2],[61,4,61,5],[0,1,0,2],[1,1,1,2],[2,0,3,0],[8,0,8,1],[76,13,77,13],[76,14,77,14],[76,5,77,5],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[71,1,71,7],[76,15,77,15],[93,0,93,3],[76,0,77,0],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,10,77,10],[75,1,75,3],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,11,77,11],[76,12,77,12]]}
["Subaward #3 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M25","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub04","index":6,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[61,4,61,5],[0,1,0,2],[4,0,4,1],[2,0,3,0],[6,0,7,2],[1,1,1,2],[8,0,8,1],[76,13,77,13],[76,14,77,14],[76,5,77,5],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[71,1,71,7],[76,15,77,15],[93,0,93,3],[76,0,77,0],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,10,77,10],[75,1,75,3],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,11,77,11],[76,12,77,12]]}
["Subaward #4 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M33","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub05","index":7,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[61,4,61,5],[0,1,0,2],[2,0,3,0],[4,0,4,1],[6,0,7,2],[1,1,1,2],[8,0,8,1],[76,13,77,13],[76,14,77,14],[76,5,77,5],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[71,1,71,7],[76,15,77,15],[93,0,93,3],[76,0,77,0],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,10,77,10],[75,1,75,3],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,11,77,11],[76,12,77,12]]}
["Subaward #5 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M41","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub06","index":8,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[76,12,77,12],[75,1,75,3],[0,1,0,2],[4,0,4,1],[2,0,3,0],[61,4,61,5],[6,0,7,2],[1,1,1,2],[8,0,8,1],[76,11,77,11],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,15,77,15],[93,0,93,3],[71,1,71,7],[76,14,77,14],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,13,77,13],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,10,77,10]]}
["Subaward #6 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M49","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub07","index":9,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[76,12,77,12],[75,1,75,3],[0,1,0,2],[4,0,4,1],[61,4,61,5],[2,0,3,0],[1,1,1,2],[6,0,7,2],[8,0,8,1],[76,11,77,11],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,15,77,15],[93,0,93,3],[71,1,71,7],[76,14,77,14],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,13,77,13],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,10,77,10]]}
["Subaward #7 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M57","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub08","index":10,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[76,12,77,12],[75,1,75,3],[61,4,61,5],[0,1,0,2],[2,0,3,0],[4,0,4,1],[6,0,7,2],[1,1,1,2],[8,0,8,1],[76,11,77,11],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,15,77,15],[93,0,93,3],[71,1,71,7],[76,14,77,14],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,13,77,13],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,10,77,10]]}
["Subaward #8 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M65","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub09","index":11,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[0,1,0,2],[1,1,1,2],[2,0,3,0],[4,0,4,1],[6,0,7,2],[76,10,77,10],[76,11,77,11],[61,4,61,5],[8,0,8,1],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[75,1,75,3],[76,15,77,15],[93,0,93,3],[71,1,71,7],[76,14,77,14],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,12,77,12],[76,13,77,13],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9]]}
["Subaward #9 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M73","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub10","index":12,"n_rows":94,"n_cols":19,"rows_kept":94,"cut":false,"hidden":true,"merged":[[76,12,77,12],[75,1,75,3],[61,4,61,5],[1,1,1,2],[0,1,0,2],[4,0,4,1],[2,0,3,0],[6,0,7,2],[8,0,8,1],[76,11,77,11],[73,0,74,7],[73,10,74,10],[75,4,75,6],[75,8,75,10],[76,15,77,15],[93,0,93,3],[71,1,71,7],[76,14,77,14],[76,0,77,0],[76,1,77,1],[76,2,77,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,13,77,13],[76,6,77,6],[76,7,77,7],[76,8,77,8],[76,9,77,9],[76,10,77,10]]}
["Subaward #10 - Organization Name"]
["Subaward PI:"]
[null,"Budget Period Start Date:",{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""}]
[null,"Budget Period End Date:",{"$f":"IF('UVA Overview'!E4=\"\",\"\",'UVA Overview'!E4)","v":""}]
["Balance remaining of first $25,000 included in UVA MTDC:"]
[]
["RESEARCH & RELATED BUDGET\n BUDGET FOR NEXT PERIOD"]
[]
[null,null,{"$f":"'UVA Overview'!E7","v":"YEAR "}]
["Senior/Key Personnel (List Sr. Key in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C11:C15),0)","v":0}]
[]
[]
[]
[]
[]
["Other Personnel (List Other Personnel in Blue Cells Below)","Role",{"$f":"ROUND(SUM(C17:C21),0)","v":0}]
[]
[]
[]
[]
[]
["Subtotal Personnel",null,{"$f":"C10+C16","v":0}]
["Capital Equipment (List Capital Equipment in Blue Cells Below)*",null,{"$f":"ROUND(SUM(C24:C28),0)","v":0}]
[]
[]
[]
[]
[]
["Travel",null,{"$f":"ROUND(SUM(C30:C31),0)","v":0}]
["Domestic Travel"]
["Foreign Travel"]
["Materials & Supplies (List Materials & Supples in Blue Cells Below)",null,{"$f":"ROUND(SUM(C33:C43),0)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Publication Costs "]
["Consultant Services (List Consultants in Blue Cells Below)",null,{"$f":"ROUND(SUM(C46:C50),0)","v":0}]
[]
[]
[]
[]
[]
["ADP/Computer Services"]
["Subaward/Consortium/Contractual Costs"]
["Equipment or Facility Rental/User Fees*"]
["Alterations and Renovations"]
["Tuition Remission*"]
["Patient Care Costs*"]
[]
[]
[]
["Subtotal OTPS",null,{"$f":"C23+C29+C32+C44+C45+C51+C52+C53+C54+C55+C56+C57+C58+C59","v":0}]
[{"$f":"B1&\" Total Direct Costs\"","v":" Total Direct Costs"},null,{"$f":"C22+C60","v":0}]
["Less Capital Equipment*",null,{"$f":"-SUMIF(C24:C28,\">=0\",C24:C28)","v":0},null,"*Excluded from F&A rate calculation"]
["Less Tuition Remission*",null,{"$f":"-C55","v":0}]
["Less Patient Care Costs*",null,{"$f":"-C56","v":0}]
["Less Equipment or Facility Rental/User Fees*",null,{"$f":"-C53","v":0}]
["Less Subaward*",null,{"$f":"'Sub Formulas'!M81","v":0}]
["MTDC",null,{"$f":"C61+SUM(C62:C66)","v":0}]
[{"$f":"B1&\" F & A Costs\"","v":" F & A Costs"},null,{"$f":"ROUND(C67*C69,0)","v":0}]
["Input F&A rate on this row"]
[{"$f":"B1&\" TOTAL DIRECT + F & A COSTS\"","v":" TOTAL DIRECT + F & A COSTS"},null,{"$f":"C61+C68","v":0}]
[]
["EXPAND FOR SCRATCH SHEET","NOTE: INFORMATION BELOW DOES NOT POPULATE ABOVE"]
[]
["DETAILED BUDGET PERIOD",null,null,null,null,null,null,null,"FROM","THROUGH",{"$f":"'UVA Overview'!E7","v":"YEAR "}]
[null,null,null,null,null,null,null,null,{"$f":"IF('UVA Overview'!$C$4=\"\",\"\",'UVA Overview'!$C$4)","v":""},{"$f":"IFERROR(I75+364,\"\")","v":""}]
["PERSONNEL (Applicant Organization Only)","Personnel Type",null,null,"Months Devoted to Project",null,null,"Enter Inst. Base Salary","       DOLLAR AMOUNT REQUESTED"]
["NAME","Sr. Key \nPersonnel","Other \nPersonnel","ROLE ON PROJECT","Cal. Months","Acad. Months","Sum. Months","INST. BASE SALARY","SALARY REQUESTED","FRINGE BENEFITS","TOTAL","CM % Effort","AM % Effort","SM % Effort","Benefit Rate","Summer Months Rate"]
[]
[null,null,null,null,{"$f":"L79*12/1","v":0},{"$f":"M79*9/1","v":0},{"$f":"N79*3/1","v":0},null,{"$f":"ROUND(($L79*$H79)+($M79*$H79)+(($H79/9)*(3)*($N79)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E79>0,F79=0,G79=0),Q79,IF(AND(E79=0,F79>0,G79=0),R79,IF(AND(E79=0,F79=0,G79>0),S79,IF(AND(E79=0,F79>0,G79>0),R79+S79,0)))),0),)","v":0},{"$f":"ROUND(I79+J79, 0)","v":0},null,null,null,null,null,{"$f":"H79*L79*O79","v":0},{"$f":"H79*M79*O79","v":0},{"$f":"((H79/9*3)*N79)*P79","v":0}]
[null,null,null,null,0,{"$f":"M80*9/1","v":0},{"$f":"N80*3/1","v":0},null,{"$f":"ROUND(($L80*$H80)+($M80*$H80)+(($H80/9)*(3)*($N80)),0)","v":0},{"$f":"ROUND(IFERROR(IF(AND(E80>0,F80=0,G80=0),Q80,IF(AND(E80=0,F80>0,G80=0),R80,IF(AND(E80=0,F80=0,G80>0),S80,IF(AND(E80=0,F80>0,G80>0),R80+S80,0)))),0),)","v":0},0,null,null,null,null,null,{"$f":"H80*L80*O80","v":0},{"$f":"H80*M80*O80","v":0},{"$f":"((H80/9*3)*N80)*P80","v":0}]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
[null,null,null,null,0,0,0,null,0,0,0,null,null,null,null,null,0,0,0]
["SUBTOTALS",null,null,null,null,null,null,null,{"$f":"SUM(I79:I92)","v":0},{"$f":"SUM(J79:J92)","v":0},{"$f":"SUM(K79:K92)","v":0},{"$f":"IFERROR(K94/#REF!*100,\"\")","v":""}]

{"sheet":"Sub Formulas","index":13,"n_rows":81,"n_cols":17,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,{"$f":"'Sub01'!C5","v":0}]
[null,null,"SUB1",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB1",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub01'!C70","v":0},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub01'!C52","v":0},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub01'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E5)","v":0},{"$f":"SUM(E5:F5)","v":{"$error":"#REF!"}},{"$f":"SUM(E5:G5)","v":{"$error":"#REF!"}},{"$f":"SUM(E5:H5)","v":{"$error":"#REF!"}},{"$f":"SUM(E5:I5)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M5)","v":0},{"$f":"SUM(M5:N5)","v":{"$error":"#REF!"}},{"$f":"SUM(M5:O5)","v":{"$error":"#REF!"}},{"$f":"SUM(M5:P5)","v":{"$error":"#REF!"}},{"$f":"SUM(M5:Q5)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E5-$F$2>0,$F$2,E5)","v":0},{"$f":"IF(F5>E8,E8,F5)","v":{"$error":"#REF!"}},{"$f":"IF(G5>F8,F8,G5)","v":{"$error":"#REF!"}},{"$f":"IF(H5>G8,G8,H5)","v":{"$error":"#REF!"}},{"$f":"IF(I5>H8,H8,I5)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M5-$F$2>0,$F$2,M5)","v":0},{"$f":"IF(N5>M8,M8,N5)","v":{"$error":"#REF!"}},{"$f":"IF(O5>N8,N8,O5)","v":{"$error":"#REF!"}},{"$f":"IF(P5>O8,O8,P5)","v":{"$error":"#REF!"}},{"$f":"IF(Q5>P8,P8,Q5)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$2-E7","v":0},{"$f":"$F$2-SUM(E7:F7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E7:G7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E7:H7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E7:I7)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M7","v":0},{"$f":"$F$2-SUM(M7:N7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M7:O7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M7:P7)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M7:Q7)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E5+E7","v":0},{"$f":"-F5+F7","v":{"$error":"#REF!"}},{"$f":"-G5+G7","v":{"$error":"#REF!"}},{"$f":"-H5+H7","v":{"$error":"#REF!"}},{"$f":"-I5+I7","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M5+M7","v":0},{"$f":"-N5+N7","v":{"$error":"#REF!"}},{"$f":"-O5+O7","v":{"$error":"#REF!"}},{"$f":"-P5+P7","v":{"$error":"#REF!"}},{"$f":"-Q5+Q7","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub02'!C5","v":0}]
[null,null,"SUB2",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB2",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub02'!C70","v":0},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub02'!C52","v":0},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub02'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E13)","v":0},{"$f":"SUM(E13:F13)","v":{"$error":"#REF!"}},{"$f":"SUM(E13:G13)","v":{"$error":"#REF!"}},{"$f":"SUM(E13:H13)","v":{"$error":"#REF!"}},{"$f":"SUM(E13:I13)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M13)","v":0},{"$f":"SUM(M13:N13)","v":{"$error":"#REF!"}},{"$f":"SUM(M13:O13)","v":{"$error":"#REF!"}},{"$f":"SUM(M13:P13)","v":{"$error":"#REF!"}},{"$f":"SUM(M13:Q13)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E13-$F$10>0,$F$10,E13)","v":0},{"$f":"IF(F13>E16,E16,F13)","v":{"$error":"#REF!"}},{"$f":"IF(G13>F16,F16,G13)","v":{"$error":"#REF!"}},{"$f":"IF(H13>G16,G16,H13)","v":{"$error":"#REF!"}},{"$f":"IF(I13>H16,H16,I13)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M13-$F$2>0,$F$2,M13)","v":0},{"$f":"IF(N13>M16,M16,N13)","v":{"$error":"#REF!"}},{"$f":"IF(O13>N16,N16,O13)","v":{"$error":"#REF!"}},{"$f":"IF(P13>O16,O16,P13)","v":{"$error":"#REF!"}},{"$f":"IF(Q13>P16,P16,Q13)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$10-E15","v":0},{"$f":"$F$2-SUM(E15:F15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E15:G15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E15:H15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E15:I15)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M15","v":0},{"$f":"$F$2-SUM(M15:N15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M15:O15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M15:P15)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M15:Q15)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E13+E15","v":0},{"$f":"-F13+F15","v":{"$error":"#REF!"}},{"$f":"-G13+G15","v":{"$error":"#REF!"}},{"$f":"-H13+H15","v":{"$error":"#REF!"}},{"$f":"-I13+I15","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M13+M15","v":0},{"$f":"-N13+N15","v":{"$error":"#REF!"}},{"$f":"-O13+O15","v":{"$error":"#REF!"}},{"$f":"-P13+P15","v":{"$error":"#REF!"}},{"$f":"-Q13+Q15","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub03'!C5","v":0}]
[null,null,"SUB3",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB3",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub03'!C70","v":0},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub03'!C52","v":0},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub03'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E21)","v":0},{"$f":"SUM(E21:F21)","v":{"$error":"#REF!"}},{"$f":"SUM(E21:G21)","v":{"$error":"#REF!"}},{"$f":"SUM(E21:H21)","v":{"$error":"#REF!"}},{"$f":"SUM(E21:I21)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M21)","v":0},{"$f":"SUM(M21:N21)","v":{"$error":"#REF!"}},{"$f":"SUM(M21:O21)","v":{"$error":"#REF!"}},{"$f":"SUM(M21:P21)","v":{"$error":"#REF!"}},{"$f":"SUM(M21:Q21)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E21-$F$18>0,$F$18,E21)","v":0},{"$f":"IF(F21>E24,E24,F21)","v":{"$error":"#REF!"}},{"$f":"IF(G21>F24,F24,G21)","v":{"$error":"#REF!"}},{"$f":"IF(H21>G24,G24,H21)","v":{"$error":"#REF!"}},{"$f":"IF(I21>H24,H24,I21)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M21-$F$2>0,$F$2,M21)","v":0},{"$f":"IF(N21>M24,M24,N21)","v":{"$error":"#REF!"}},{"$f":"IF(O21>N24,N24,O21)","v":{"$error":"#REF!"}},{"$f":"IF(P21>O24,O24,P21)","v":{"$error":"#REF!"}},{"$f":"IF(Q21>P24,P24,Q21)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$18-E23","v":0},{"$f":"$F$2-SUM(E23:F23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E23:G23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E23:H23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E23:I23)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M23","v":0},{"$f":"$F$2-SUM(M23:N23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M23:O23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M23:P23)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M23:Q23)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E21+E23","v":0},{"$f":"-F21+F23","v":{"$error":"#REF!"}},{"$f":"-G21+G23","v":{"$error":"#REF!"}},{"$f":"-H21+H23","v":{"$error":"#REF!"}},{"$f":"-I21+I23","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M21+M23","v":0},{"$f":"-N21+N23","v":{"$error":"#REF!"}},{"$f":"-O21+O23","v":{"$error":"#REF!"}},{"$f":"-P21+P23","v":{"$error":"#REF!"}},{"$f":"-Q21+Q23","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub04'!C5","v":0}]
[null,null,"SUB4",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB4",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub04'!C70","v":0},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub04'!C52","v":0},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub04'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E29)","v":0},{"$f":"SUM(E29:F29)","v":{"$error":"#REF!"}},{"$f":"SUM(E29:G29)","v":{"$error":"#REF!"}},{"$f":"SUM(E29:H29)","v":{"$error":"#REF!"}},{"$f":"SUM(E29:I29)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M29)","v":0},{"$f":"SUM(M29:N29)","v":{"$error":"#REF!"}},{"$f":"SUM(M29:O29)","v":{"$error":"#REF!"}},{"$f":"SUM(M29:P29)","v":{"$error":"#REF!"}},{"$f":"SUM(M29:Q29)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E29-$F$26>0,$F$26,E29)","v":0},{"$f":"IF(F29>E32,E32,F29)","v":{"$error":"#REF!"}},{"$f":"IF(G29>F32,F32,G29)","v":{"$error":"#REF!"}},{"$f":"IF(H29>G32,G32,H29)","v":{"$error":"#REF!"}},{"$f":"IF(I29>H32,H32,I29)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M29-$F$2>0,$F$2,M29)","v":0},{"$f":"IF(N29>M32,M32,N29)","v":{"$error":"#REF!"}},{"$f":"IF(O29>N32,N32,O29)","v":{"$error":"#REF!"}},{"$f":"IF(P29>O32,O32,P29)","v":{"$error":"#REF!"}},{"$f":"IF(Q29>P32,P32,Q29)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$26-E31","v":0},{"$f":"$F$2-SUM(E31:F31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E31:G31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E31:H31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E31:I31)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M31","v":0},{"$f":"$F$2-SUM(M31:N31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M31:O31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M31:P31)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M31:Q31)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E29+E31","v":0},{"$f":"-F29+F31","v":{"$error":"#REF!"}},{"$f":"-G29+G31","v":{"$error":"#REF!"}},{"$f":"-H29+H31","v":{"$error":"#REF!"}},{"$f":"-I29+I31","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M29+M31","v":0},{"$f":"-N29+N31","v":{"$error":"#REF!"}},{"$f":"-O29+O31","v":{"$error":"#REF!"}},{"$f":"-P29+P31","v":{"$error":"#REF!"}},{"$f":"-Q29+Q31","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub05'!C5","v":0}]
[null,null,"SUB5",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB5",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub05'!$C$70","v":0},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub05'!$C$52","v":0},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub05'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E37)","v":0},{"$f":"SUM(E37:F37)","v":{"$error":"#REF!"}},{"$f":"SUM(E37:G37)","v":{"$error":"#REF!"}},{"$f":"SUM(E37:H37)","v":{"$error":"#REF!"}},{"$f":"SUM(E37:I37)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M37)","v":0},{"$f":"SUM(M37:N37)","v":{"$error":"#REF!"}},{"$f":"SUM(M37:O37)","v":{"$error":"#REF!"}},{"$f":"SUM(M37:P37)","v":{"$error":"#REF!"}},{"$f":"SUM(M37:Q37)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E37-$F$34>0,$F$34,E37)","v":0},{"$f":"IF(F37>E40,E40,F37)","v":{"$error":"#REF!"}},{"$f":"IF(G37>F40,F40,G37)","v":{"$error":"#REF!"}},{"$f":"IF(H37>G40,G40,H37)","v":{"$error":"#REF!"}},{"$f":"IF(I37>H40,H40,I37)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M37-$F$2>0,$F$2,M37)","v":0},{"$f":"IF(N37>M40,M40,N37)","v":{"$error":"#REF!"}},{"$f":"IF(O37>N40,N40,O37)","v":{"$error":"#REF!"}},{"$f":"IF(P37>O40,O40,P37)","v":{"$error":"#REF!"}},{"$f":"IF(Q37>P40,P40,Q37)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$34-E39","v":0},{"$f":"$F$2-SUM(E39:F39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E39:G39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E39:H39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E39:I39)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M39","v":0},{"$f":"$F$2-SUM(M39:N39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M39:O39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M39:P39)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M39:Q39)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E37+E39","v":0},{"$f":"-F37+F39","v":{"$error":"#REF!"}},{"$f":"-G37+G39","v":{"$error":"#REF!"}},{"$f":"-H37+H39","v":{"$error":"#REF!"}},{"$f":"-I37+I39","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M37+M39","v":0},{"$f":"-N37+N39","v":{"$error":"#REF!"}},{"$f":"-O37+O39","v":{"$error":"#REF!"}},{"$f":"-P37+P39","v":{"$error":"#REF!"}},{"$f":"-Q37+Q39","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub06'!C5","v":0}]
[null,null,"SUB6",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB6",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub06'!$C$70","v":0},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub06'!$C$52","v":0},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub06'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E45)","v":0},{"$f":"SUM(E45:F45)","v":{"$error":"#REF!"}},{"$f":"SUM(E45:G45)","v":{"$error":"#REF!"}},{"$f":"SUM(E45:H45)","v":{"$error":"#REF!"}},{"$f":"SUM(E45:I45)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M45)","v":0},{"$f":"SUM(M45:N45)","v":{"$error":"#REF!"}},{"$f":"SUM(M45:O45)","v":{"$error":"#REF!"}},{"$f":"SUM(M45:P45)","v":{"$error":"#REF!"}},{"$f":"SUM(M45:Q45)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E45-$F$42>0,$F$42,E45)","v":0},{"$f":"IF(F45>E48,E48,F45)","v":{"$error":"#REF!"}},{"$f":"IF(G45>F48,F48,G45)","v":{"$error":"#REF!"}},{"$f":"IF(H45>G48,G48,H45)","v":{"$error":"#REF!"}},{"$f":"IF(I45>H48,H48,I45)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M45-$F$2>0,$F$2,M45)","v":0},{"$f":"IF(N45>M48,M48,N45)","v":{"$error":"#REF!"}},{"$f":"IF(O45>N48,N48,O45)","v":{"$error":"#REF!"}},{"$f":"IF(P45>O48,O48,P45)","v":{"$error":"#REF!"}},{"$f":"IF(Q45>P48,P48,Q45)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$42-E47","v":0},{"$f":"$F$2-SUM(E47:F47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E47:G47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E47:H47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E47:I47)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M47","v":0},{"$f":"$F$2-SUM(M47:N47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M47:O47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M47:P47)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M47:Q47)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E45+E47","v":0},{"$f":"-F45+F47","v":{"$error":"#REF!"}},{"$f":"-G45+G47","v":{"$error":"#REF!"}},{"$f":"-H45+H47","v":{"$error":"#REF!"}},{"$f":"-I45+I47","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M45+M47","v":0},{"$f":"-N45+N47","v":{"$error":"#REF!"}},{"$f":"-O45+O47","v":{"$error":"#REF!"}},{"$f":"-P45+P47","v":{"$error":"#REF!"}},{"$f":"-Q45+Q47","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub07'!C5","v":0}]
[null,null,"SUB7",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB7",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub07'!$C$70","v":0},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub07'!$C$52","v":0},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub07'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E53)","v":0},{"$f":"SUM(E53:F53)","v":{"$error":"#REF!"}},{"$f":"SUM(E53:G53)","v":{"$error":"#REF!"}},{"$f":"SUM(E53:H53)","v":{"$error":"#REF!"}},{"$f":"SUM(E53:I53)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M53)","v":0},{"$f":"SUM(M53:N53)","v":{"$error":"#REF!"}},{"$f":"SUM(M53:O53)","v":{"$error":"#REF!"}},{"$f":"SUM(M53:P53)","v":{"$error":"#REF!"}},{"$f":"SUM(M53:Q53)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E53-$F$50>0,$F$50,E53)","v":0},{"$f":"IF(F53>E56,E56,F53)","v":{"$error":"#REF!"}},{"$f":"IF(G53>F56,F56,G53)","v":{"$error":"#REF!"}},{"$f":"IF(H53>G56,G56,H53)","v":{"$error":"#REF!"}},{"$f":"IF(I53>H56,H56,I53)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M53-$F$2>0,$F$2,M53)","v":0},{"$f":"IF(N53>M56,M56,N53)","v":{"$error":"#REF!"}},{"$f":"IF(O53>N56,N56,O53)","v":{"$error":"#REF!"}},{"$f":"IF(P53>O56,O56,P53)","v":{"$error":"#REF!"}},{"$f":"IF(Q53>P56,P56,Q53)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$50-E55","v":0},{"$f":"$F$2-SUM(E55:F55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E55:G55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E55:H55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E55:I55)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M55","v":0},{"$f":"$F$2-SUM(M55:N55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M55:O55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M55:P55)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M55:Q55)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E53+E55","v":0},{"$f":"-F53+F55","v":{"$error":"#REF!"}},{"$f":"-G53+G55","v":{"$error":"#REF!"}},{"$f":"-H53+H55","v":{"$error":"#REF!"}},{"$f":"-I53+I55","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M53+M55","v":0},{"$f":"-N53+N55","v":{"$error":"#REF!"}},{"$f":"-O53+O55","v":{"$error":"#REF!"}},{"$f":"-P53+P55","v":{"$error":"#REF!"}},{"$f":"-Q53+Q55","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub08'!C5","v":0}]
[null,null,"SUB8",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB8",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub08'!$C$70","v":0},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub08'!$C$52","v":0},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub08'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E61)","v":0},{"$f":"SUM(E61:F61)","v":{"$error":"#REF!"}},{"$f":"SUM(E61:G61)","v":{"$error":"#REF!"}},{"$f":"SUM(E61:H61)","v":{"$error":"#REF!"}},{"$f":"SUM(E61:I61)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M61)","v":0},{"$f":"SUM(M61:N61)","v":{"$error":"#REF!"}},{"$f":"SUM(M61:O61)","v":{"$error":"#REF!"}},{"$f":"SUM(M61:P61)","v":{"$error":"#REF!"}},{"$f":"SUM(M61:Q61)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E61-$F$58>0,$F$58,E61)","v":0},{"$f":"IF(F61>E64,E64,F61)","v":{"$error":"#REF!"}},{"$f":"IF(G61>F64,F64,G61)","v":{"$error":"#REF!"}},{"$f":"IF(H61>G64,G64,H61)","v":{"$error":"#REF!"}},{"$f":"IF(I61>H64,H64,I61)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M61-$F$2>0,$F$2,M61)","v":0},{"$f":"IF(N61>M64,M64,N61)","v":{"$error":"#REF!"}},{"$f":"IF(O61>N64,N64,O61)","v":{"$error":"#REF!"}},{"$f":"IF(P61>O64,O64,P61)","v":{"$error":"#REF!"}},{"$f":"IF(Q61>P64,P64,Q61)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$58-E63","v":0},{"$f":"$F$2-SUM(E63:F63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E63:G63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E63:H63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E63:I63)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M63","v":0},{"$f":"$F$2-SUM(M63:N63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M63:O63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M63:P63)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M63:Q63)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E61+E63","v":0},{"$f":"-F61+F63","v":{"$error":"#REF!"}},{"$f":"-G61+G63","v":{"$error":"#REF!"}},{"$f":"-H61+H63","v":{"$error":"#REF!"}},{"$f":"-I61+I63","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M61+M63","v":0},{"$f":"-N61+N63","v":{"$error":"#REF!"}},{"$f":"-O61+O63","v":{"$error":"#REF!"}},{"$f":"-P61+P63","v":{"$error":"#REF!"}},{"$f":"-Q61+Q63","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub09'!C5","v":0}]
[null,null,"SUB9",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB9",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub09'!$C$70","v":0},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub09'!$C$52","v":0},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub09'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E69)","v":0},{"$f":"SUM(E69:F69)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:G69)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:H69)","v":{"$error":"#REF!"}},{"$f":"SUM(E69:I69)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M69)","v":0},{"$f":"SUM(M69:N69)","v":{"$error":"#REF!"}},{"$f":"SUM(M69:O69)","v":{"$error":"#REF!"}},{"$f":"SUM(M69:P69)","v":{"$error":"#REF!"}},{"$f":"SUM(M69:Q69)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E69-$F$66>0,$F$66,E69)","v":0},{"$f":"IF(F69>E72,E72,F69)","v":{"$error":"#REF!"}},{"$f":"IF(G69>F72,F72,G69)","v":{"$error":"#REF!"}},{"$f":"IF(H69>G72,G72,H69)","v":{"$error":"#REF!"}},{"$f":"IF(I69>H72,H72,I69)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M69-$F$2>0,$F$2,M69)","v":0},{"$f":"IF(N69>M72,M72,N69)","v":{"$error":"#REF!"}},{"$f":"IF(O69>N72,N72,O69)","v":{"$error":"#REF!"}},{"$f":"IF(P69>O72,O72,P69)","v":{"$error":"#REF!"}},{"$f":"IF(Q69>P72,P72,Q69)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$66-E71","v":0},{"$f":"$F$2-SUM(E71:F71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E71:G71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E71:H71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E71:I71)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M71","v":0},{"$f":"$F$2-SUM(M71:N71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M71:O71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M71:P71)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M71:Q71)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E69+E71","v":0},{"$f":"-F69+F71","v":{"$error":"#REF!"}},{"$f":"-G69+G71","v":{"$error":"#REF!"}},{"$f":"-H69+H71","v":{"$error":"#REF!"}},{"$f":"-I69+I71","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M69+M71","v":0},{"$f":"-N69+N71","v":{"$error":"#REF!"}},{"$f":"-O69+O71","v":{"$error":"#REF!"}},{"$f":"-P69+P71","v":{"$error":"#REF!"}},{"$f":"-Q69+Q71","v":{"$error":"#REF!"}}]
[null,null,null,null,null,{"$f":"'Sub10'!C5","v":0}]
[null,null,"SUB10",null,"Y1","Y2","Y3","Y4","Y5",null,"SUB10",null,"Y1","Y2","Y3","Y4","Y5"]
[]
[null,null,null,"$/yr",{"$f":"'Sub10'!$C$70","v":0},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},null,null,"$/yr",{"$f":"'Sub10'!$C$52","v":0},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Sub10'!#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"CumTotal",{"$f":"SUM(E77)","v":0},{"$f":"SUM(E77:F77)","v":{"$error":"#REF!"}},{"$f":"SUM(E77:G77)","v":{"$error":"#REF!"}},{"$f":"SUM(E77:H77)","v":{"$error":"#REF!"}},{"$f":"SUM(E77:I77)","v":{"$error":"#REF!"}},null,null,"CumTotal",{"$f":"SUM(M77)","v":0},{"$f":"SUM(M77:N77)","v":{"$error":"#REF!"}},{"$f":"SUM(M77:O77)","v":{"$error":"#REF!"}},{"$f":"SUM(M77:P77)","v":{"$error":"#REF!"}},{"$f":"SUM(M77:Q77)","v":{"$error":"#REF!"}}]
[null,null,null,"Eligible",{"$f":"IF(E77-$F$74>0,$F$74,E77)","v":0},{"$f":"IF(F77>E80,E80,F77)","v":{"$error":"#REF!"}},{"$f":"IF(G77>F80,F80,G77)","v":{"$error":"#REF!"}},{"$f":"IF(H77>G80,G80,H77)","v":{"$error":"#REF!"}},{"$f":"IF(I77>H80,H80,I77)","v":{"$error":"#REF!"}},null,null,"Eligible",{"$f":"IF(M77-$F$2>0,$F$2,M77)","v":0},{"$f":"IF(N77>M80,M80,N77)","v":{"$error":"#REF!"}},{"$f":"IF(O77>N80,N80,O77)","v":{"$error":"#REF!"}},{"$f":"IF(P77>O80,O80,P77)","v":{"$error":"#REF!"}},{"$f":"IF(Q77>P80,P80,Q77)","v":{"$error":"#REF!"}}]
[null,null,null,"Remain",{"$f":"$F$74-E79","v":0},{"$f":"$F$2-SUM(E79:F79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E79:G79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E79:H79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(E79:I79)","v":{"$error":"#REF!"}},null,null,"Remain",{"$f":"$F$2-M79","v":0},{"$f":"$F$2-SUM(M79:N79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M79:O79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M79:P79)","v":{"$error":"#REF!"}},{"$f":"$F$2-SUM(M79:Q79)","v":{"$error":"#REF!"}}]
[null,null,null,"SS Entry",{"$f":"-E77+E79","v":0},{"$f":"-F77+F79","v":{"$error":"#REF!"}},{"$f":"-G77+G79","v":{"$error":"#REF!"}},{"$f":"-H77+H79","v":{"$error":"#REF!"}},{"$f":"-I77+I79","v":{"$error":"#REF!"}},null,null,"SS Entry",{"$f":"-M77+M79","v":0},{"$f":"-N77+N79","v":{"$error":"#REF!"}},{"$f":"-O77+O79","v":{"$error":"#REF!"}},{"$f":"-P77+P79","v":{"$error":"#REF!"}},{"$f":"-Q77+Q79","v":{"$error":"#REF!"}}]