{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Budget p.3","Matching p.4","SUBS p.5","Consultants p.6","Faculty Detail p.7","Lists"],"not_rendered":{"charts":0,"images":0,"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":"Budget p.3","index":0,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,2,49,8],[47,0,47,8],[48,0,48,8],[40,0,40,2],[42,0,42,2],[43,0,43,3],[45,0,45,8],[46,0,46,8],[0,1,0,8]]}
[2021," Use Kuali Research for Accurate Budget Calculations "]
[null,null,null,null," (This tool is ONLY for Approximate Planning Purposes )  "]
[" "," ",null,"Period 1","Period 2","Period 3","Period 4","Period 5","Cumulative "]
[null,null,"Start Date"]
["Description",null,"End Date"]
[5000,"Administrative Salaries",null,0,0,0,0,0,{"$f":"SUM(D6:H6)","v":0}]
[5900,"Benefits @ ",0.55600000000000005,{"$f":"D6*$C$7","v":0},{"$f":"E6*$C$7","v":0},{"$f":"F6*$C$7","v":0},{"$f":"G6*$C$7","v":0},{"$f":"H6*$C$7","v":0},{"$f":"SUM(D7:H7)","v":0}]
[5194,"Postdocs/Visit. Fac./Res. Staff/Res. Assoc.",null,0,0,0,0,0,0]
[5910,"Benefits @",0.251,{"$f":"D8*$C$9","v":0},{"$f":"E8*$C$9","v":0},{"$f":"F8*$C$9","v":0},{"$f":"G8*$C$9","v":0},{"$f":"H8*$C$9","v":0},0]
[5100,"Faculty (Fall / Winter)",null,{"$f":"'Faculty Detail p.7'!E6","v":0},{"$f":"'Faculty Detail p.7'!E28","v":0},{"$f":"'Faculty Detail p.7'!E48","v":0},{"$f":"'Faculty Detail p.7'!E68","v":0},{"$f":"'Faculty Detail p.7'!E88","v":0},0]
[5910,"Benefits @ ",0.496,{"$f":"D10*$C$11","v":0},{"$f":"E10*$C$11","v":0},{"$f":"F10*$C$11","v":0},{"$f":"G10*$C$11","v":0},{"$f":"H10*$C$11","v":0},0]
[5260,"Faculty Spring/Summer",null,{"$f":"'Faculty Detail p.7'!E15","v":0},{"$f":"'Faculty Detail p.7'!E36","v":0},{"$f":"'Faculty Detail p.7'!E56","v":0},{"$f":"'Faculty Detail p.7'!E76","v":0},{"$f":"'Faculty Detail p.7'!E96","v":0},0]
[5920,"Benefits @ ",0.30399999999999999,{"$f":"D12*$C$13","v":0},{"$f":"E12*$C$13","v":0},{"$f":"F12*$C$13","v":0},{"$f":"G12*$C$13","v":0},{"$f":"H12*$C$13","v":0},0]
[5240,"Faculty Supplemental   (used rarely, ",null,{"$f":"'Faculty Detail p.7'!E21","v":0},{"$f":"'Faculty Detail p.7'!E41","v":0},{"$f":"'Faculty Detail p.7'!E61","v":0},{"$f":"'Faculty Detail p.7'!E81","v":0},{"$f":"'Faculty Detail p.7'!E101","v":0},{"$f":"SUM(D14:H14)","v":0}]
[null,"      contact RAO)",7.5999999999999998E-2]
[5300,"Part Time Faculty",null,null,null,null,null,null,0]
[5930,"Benefits @ ",7.5999999999999998E-2,{"$f":"D16*$C$17","v":0},{"$f":"E16*$C$17","v":0},{"$f":"F16*$C$17","v":0},{"$f":"G16*$C$17","v":0},{"$f":"H16*$C$17","v":0},0]
[5400,"Full Time Staff",null,null,null,null,null,null,0]
[5940,"Benefits @ ",0.746,{"$f":"D18*$C$19","v":0},{"$f":"E18*$C$19","v":0},{"$f":"F18*$C$19","v":0},{"$f":"G18*$C$19","v":0},{"$f":"H18*$C$19","v":0},0]
[5700,"Part Time Staff",null,null,null,null,null,null,0]
[5970,"Benefits @ ",0.311,{"$f":"D20*$C$21","v":0},{"$f":"E20*$C$21","v":0},{"$f":"F20*$C$21","v":0},{"$f":"G20*$C$21","v":0},{"$f":"H20*$C$21","v":0},0]
[5570,"Students (Contract)",null,null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[5670,"Students (Timecard)",null,null,null,null,null,null,0]
["5950/60","Benefits @     **optional",7.5999999999999998E-2,null,null,null,null,null,0]
[6100,"Supplies",null,null,null,null,null,null,0]
[8910,"Consultant(s) *  Totals populated from p. 6",null,{"$f":"'Consultants p.6'!C13","v":0},{"$f":"'Consultants p.6'!D13","v":0},{"$f":"'Consultants p.6'!E13","v":0},{"$f":"'Consultants p.6'!F13","v":0},{"$f":"'Consultants p.6'!G13","v":0},0]
[8920,"Subaward(s) * Totals populated from  p.5",null,{"$f":"'SUBS p.5'!C13","v":0},{"$f":"'SUBS p.5'!D13","v":0},{"$f":"'SUBS p.5'!E13","v":0},{"$f":"'SUBS p.5'!F13","v":0},{"$f":"'SUBS p.5'!G13","v":0},{"$f":"SUM(D27:H27)","v":0}]
[7000,"Travel, Domestic",null,null,null,null,null,null,0]
[7050,"Travel, Foreign",null,null,null,null,null,null,0]
[6300,"Tuition       (no indirect costs)",null,null,null,null,null,null,0]
[8930,"Capital Equipment (> $5000)   (no I.C.)",null,null,null,null,null,null,0]
[8905,"Participant Costs","              (no I.C.)",null,null,null,null,null,{"$f":"SUM(D32:H32)","v":0}]
[8940,"Hosting Conference Costs      (no I.C.)",null,null,null,null,null,null,0]
[null,"Other, (with I.C.  state code)","            (with  I.C.)",null,null,null,null,null,0]
[null,"Other, (without I.C.  state code)","               (no I.C.)",null,null,null,null,null,0]
["Total Direct Costs",null,null,{"$f":"SUM(D6:D35)","v":0},{"$f":"SUM(E6:E35)","v":0},{"$f":"SUM(F6:F35)","v":0},{"$f":"SUM(G6:G35)","v":0},{"$f":"SUM(H6:H35)","v":0},0]
["On-Campus Direct Cost Base",null,null,{"$f":"D36-D27-D30-D31-D32-D33-D35+'SUBS p.5'!J13","v":0},{"$f":"E36-E27-E30-E31-E32-E33-E35+'SUBS p.5'!K13","v":0},{"$f":"F36-F27-F30-F31-F32-F33-F35+'SUBS p.5'!L13","v":0},{"$f":"G36-G27-G30-G31-G32-G33-G35+'SUBS p.5'!M13","v":0},{"$f":"H36-H27-H30-H31-H32-H33-H35+'SUBS p.5'!N13","v":0},0]
["Off-Campus Direct Cost Base",null,null,null,null,null,null,null,0]
[8990,"Indirect Costs (On-Campus)",0.5,{"$f":"D37*$C$39","v":0},{"$f":"E37*$C$39","v":0},{"$f":"F37*$C$39","v":0},{"$f":"G37*$C$39","v":0},{"$f":"H37*$C$39","v":0},0]
[8990,"Indirect Costs (Off-Campus)",0.26,{"$f":"D38*$C$40","v":0},{"$f":"E38*$C$40","v":0},{"$f":"F38*$C$40","v":0},{"$f":"G38*$C$40","v":0},{"$f":"H38*$C$40","v":0},0]
["TOTAL COST TO SPONSOR",null,null,{"$f":"+D36+D39+D40","v":0},{"$f":"+E36+E39+E40","v":0},{"$f":"+F36+F39+F40","v":0},{"$f":"+G36+G39+G40","v":0},{"$f":"+H36+H39+H40","v":0},0]
[null,null,"Not all 5 yearly columns need be used. Use only the ones you need, leave the rest blank."]
["Cost Sharing/Matching from BYU",null,null,{"$f":"'Matching p.4'!E41","v":0},{"$f":"'Matching p.4'!F41","v":0},{"$f":"'Matching p.4'!G41","v":0},{"$f":"'Matching p.4'!H41","v":0},{"$f":"'Matching p.4'!I41","v":0},{"$f":"SUM(D43:H43)","v":0}]
["Use Cost Sharing/Matching only when necessary",null,null,null,"Cost Sharing/Matching Amounts are populated from the Matching page"]
[null,null,null,null,"(see Excel worksheet green tab below)"]
["** Optional Benefits for Students:  Benefits for students are NOT required for students when they are taking full time load of classes, such as in Fall and/or"]
["Winter Semesters. When a student is not taking a full course load, such as in the Spring or Summer, benefits will be required. Faculty should make their best"]
["estimate of what percentage of student contracts & wages would fall under the benefits requirements and multiply only that amount by the 7.6%."]
[]
[]
[null,null,null,null,"page 3"]

{"sheet":"Matching p.4","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,9],[11,2,11,3],[40,1,40,3],[1,3,1,6]]}
["BYU Internal Cost Sharing / Matching Summary Page"]
[null,null,null,"Use Only if Required by Sponsor"]
[]
[1,"Enter Salaries and Wages in the 5XXX Codes.",null,null,null,null,null,null,"Form Approved:","Sept 2020"]
[2,"Calculate the Fringe Benefits for each category, using the table below."]
[3,"Enter other Direct Costs."]
[4,"Indirect Costs:  If the research is to be performed on campus, compute Indirect Costs by multiplying the Total"]
[null,"Direct Costs by 0.50 (the on-campus rate).  For that part of the research which is to be performed off campus,"]
[null,"Total Direct Costs should be multiplied by 0.26 (the off-campus rate)See below for off-campus rate use.  "]
[5,"Indicate cost sharing below only if required by program."]
[]
[null,null,"Description",null,"Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative "]
[null,5000,"Administrative Salaries",null,0,0,0,0,0,{"$f":"SUM(E13:I13)","v":0}]
[null,5900,"Benefits @ ",{"$f":"'Budget p.3'!C7","v":0.55600000000000005},{"$f":"E13*$D$14","v":0},{"$f":"F13*$D$14","v":0},{"$f":"G13*$D$14","v":0},{"$f":"H13*$D$14","v":0},{"$f":"I13*$D$14","v":0},{"$f":"SUM(E14:I14)","v":0}]
[null,5194,"Postdocs/Visiting Faculty/Research Staff",null,0,0,0,0,0,0]
[null,5910,"Benefits @",{"$f":"'Budget p.3'!C9","v":0.251},{"$f":"E15*$D$16","v":0},{"$f":"F15*$D$16","v":0},{"$f":"G15*$D$16","v":0},{"$f":"H15*$D$16","v":0},{"$f":"I15*$D$16","v":0},{"$f":"SUM(E16:I16)","v":0}]
[null,5100,"Faculty (Fall / Winter) & Res. Assoc.",null,0,0,0,0,0,{"$f":"SUM(E17:I17)","v":0}]
[null,5910,"Benefits @ ",{"$f":"'Budget p.3'!C11","v":0.496},{"$f":"E17*D18","v":0},{"$f":"F17*$D$18","v":0},{"$f":"G17*$D$18","v":0},{"$f":"H17*$D$18","v":0},{"$f":"I17*$D$18","v":0},0]
[null,5300,"Part Time Faculty",null,0,0,0,0,0,0]
[null,5930,"Benefits @ ",{"$f":"'Budget p.3'!C17","v":7.5999999999999998E-2},{"$f":"E19*$D$20","v":0},{"$f":"F19*$D$20","v":0},{"$f":"G19*$D$20","v":0},{"$f":"H19*$D$20","v":0},{"$f":"I19*$D$20","v":0},0]
[null,5400,"Full Time Staff",null,0,0,0,0,0,0]
[null,5940,"Benefits @ ",{"$f":"'Budget p.3'!C19","v":0.746},{"$f":"E21*$D$22","v":0},{"$f":"F21*$D$22","v":0},{"$f":"G21*$D$22","v":0},{"$f":"H21*$D$22","v":0},{"$f":"I21*$D$22","v":0},0]
[null,5700,"Part Time Staff",null,0,0,0,0,0,0]
[null,5970,"Benefits @ ",{"$f":"'Budget p.3'!C21","v":0.311},{"$f":"E23*$D$24","v":0},{"$f":"F23*$D$24","v":0},{"$f":"G23*$D$24","v":0},{"$f":"H23*$D$24","v":0},{"$f":"I23*$D$24","v":0},0]
[null,5570,"Students (Contract)",null,null,null,null,null,null,0]
[null,5670,"Students (Timecard)",null,null,null,null,null,null,0]
[null,"5950/60","Benefits @     *optional",{"$f":"'Budget p.3'!C24","v":7.5999999999999998E-2},null,null,null,null,null,0]
[null,6100,"Supplies",null,null,null,null,null,null,0]
[null,6125,"Publications",null,null,null,null,null,null,0]
[null,7000,"Travel, Domestic",null,null,null,null,null,null,0]
[null,7050,"Travel, Foreign",null,null,null,null,null,null,0]
[null,6300,"Tuition (no indirect costs)",null,null,null,null,null,null,0]
[null,8930,"Capital Equipment    (no I.C.)(> $5K)",null,null,null,null,null,null,0]
[null,null,"Other, state code",null,null,null,null,null,null,0]
[null,"Total Direct Costs",null,null,{"$f":"SUM(E13:E34)","v":0},{"$f":"SUM(F13:F34)","v":0},{"$f":"SUM(G13:G34)","v":0},{"$f":"SUM(H13:H34)","v":0},{"$f":"SUM(I13:I34)","v":0},0]
[null,"On-Campus Direct Cost Base",null,null,{"$f":"E35-E32-E33","v":0},{"$f":"F35-F32-F33","v":0},{"$f":"G35-G32-G33","v":0},{"$f":"H35-H32-H33","v":0},{"$f":"I35-I32-I33","v":0},0]
[null,"Off-Campus Direct Cost Base",null,null,null,null,null,null,null,0]
[null,8990,"Indirect Costs (On-Campus)",0.5,{"$f":"0.5*E36","v":0},{"$f":"0.5*F36","v":0},{"$f":"0.5*G36","v":0},{"$f":"0.5*H36","v":0},{"$f":"0.5*I36","v":0},0]
[null,8990,"Indirect Costs (Off Campus)",0.26,{"$f":"E36*0.26","v":0},{"$f":"F36*0.26","v":0},{"$f":"G36*0.26","v":0},{"$f":"H36*0.26","v":0},{"$f":"I36*0.26","v":0},0]
[null,8990,"Waived Indirect Costs",null,0,{"$f":"F37*0.26","v":0},{"$f":"G37*0.26","v":0},{"$f":"H37*0.26","v":0},{"$f":"I37*0.26","v":0},0]
[null,"TOTAL COST SHARING",null,null,{"$f":"+E35+E38+E40","v":0},{"$f":"+F35+F38+F40","v":0},{"$f":"+G35+G38+G40","v":0},{"$f":"+H35+H38+H40","v":0},{"$f":"+I35+I38+I40","v":0},0]
[]
[]
[]
[]
["Explain where the Cost Sharing/Matching noted above is to come from:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Page 4"]

{"sheet":"SUBS p.5","index":2,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,1,0,7],[0,9,0,14],[1,8,12,8]]}
[null,"BYU 1 to 5 Year (s) Proposal Budget  Subaward(s)",null,null,null,null,null,null,null,"Indirect Costs Base Calculation  (50% on only the first $25,000)"]
[null,"Subaward Description/Name","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative","Subawards","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
[1,null,null,null,null,null,null,{"$f":"SUM(C3:G3)","v":0},null,{"$f":"IF(C3<25000,C3,25000)","v":0},{"$f":"IF(25000-SUM(C3+D3)>=0,D3,IF(25000-SUM(C3)>=0,25000-SUM(C3),0))","v":0},{"$f":"IF(25000-SUM(C3+D3+E3)>=0,E3,IF(25000-SUM(D3+C3)>=0,25000-SUM(D3+C3),0))","v":0},{"$f":"IF(25000-SUM(C3+D3+E3+F3)>=0,F3,IF(25000-SUM(E3+D3+C3)>=0,25000-SUM(E3+D3+C3),0))","v":0},{"$f":"IF(25000-SUM(C3+D3+E3+F3+G3)>=0,G3,IF(25000-SUM(F3+E3+D3+C3)>=0,25000-SUM(F3+E3+D3+C3),0))","v":0},{"$f":"SUM(J3:N3)","v":0}]
[2,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[3,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[4,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[5,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[6,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[7,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[8,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[9,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[10,null,null,null,null,null,null,0,null,0,0,0,0,0,0]
[null,"Totals",{"$f":"SUM(C3:C12)","v":0},{"$f":"SUM(D3:D12)","v":0},{"$f":"SUM(E3:E12)","v":0},{"$f":"SUM(F3:F12)","v":0},{"$f":"SUM(G3:G12)","v":0},{"$f":"SUM(C13:G13)","v":0},null,{"$f":"SUM(J3:J12)","v":0},{"$f":"SUM(K3:K12)","v":0},{"$f":"SUM(L3:L12)","v":0},{"$f":"SUM(M3:M12)","v":0},{"$f":"SUM(N3:N12)","v":0},{"$f":"SUM(J13:N13)","v":0}]
[]
[null,"If there are subawards above, then there needs to be a 'Subrecipient Commitment Form' filled out"]
[null,"        by each one. See RAO."]
[null,"The proper indirect costs will be automatically calculated, please do not alter the formulas."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Page 5"]

{"sheet":"Consultants p.6","index":3,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,1,0,7]]}
[null,"BYU 1 to 5 Year (s) Proposal Budget  Consultants"]
[null,"Consultant Description/Name","Year 1","Year 2","Year 3","Year 4","Year 5","Cumulative"]
[1]
[2,null,null,null,null,null,null,{"$f":"SUM(C4:G4)","v":0}]
[3,null,null,null,null,null,null,0]
[4,null,null,null,null,null,null,0]
[5,null,null,null,null,null,null,0]
[6,null,null,null,null,null,null,0]
[7,null,null,null,null,null,null,0]
[8,null,null,null,null,null,null,0]
[9,null,null,null,null,null,null,0]
[10,null,null,null,null,null,null,0]
[null,"Totals",{"$f":"SUM(C3:C12)","v":0},{"$f":"SUM(D3:D12)","v":0},{"$f":"SUM(E3:E12)","v":0},{"$f":"SUM(F3:F12)","v":0},{"$f":"SUM(G3:G12)","v":0},{"$f":"SUM(C13:G13)","v":0}]
[]
["The proper indirect costs will be automatically calculated, please do not alter the formulas."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Page 6"]

{"sheet":"Faculty Detail p.7","index":4,"n_rows":101,"n_cols":5,"rows_kept":101,"cut":false,"hidden":false,"merged":[[7,0,7,4],[0,0,0,4],[22,0,22,4],[82,0,82,4],[88,0,88,4],[28,0,28,4],[42,0,42,4],[48,0,48,4],[62,0,62,4],[68,0,68,4]]}
["PERIOD 1"]
["Faculty (Fall / Winter)"]
[null,"Name","8 month base","Number of Months","Salary Requested (Calculates Automatically)"]
["Faculty 1",null,0,0,{"$f":"C4/8*D4","v":0}]
["Faculty 2",null,null,null,{"$f":"C5/8*D5","v":0}]
[null,null,null,"Total Faculty Fall/Winter Salary Requested",{"$f":"SUM(E4:E5)","v":0}]
[null,null,null,null,"Populates main budget"]
["Faculty Spring/Summer Salary (research conducted from May to August) - Note Faculty time conducting research from September to April is compensated by academic salary. "]
[null,"Name","8 month base","Number of Spr/Sum Months","Salary Requested (Calculates Automatically) "]
["PI",null,0,0,{"$f":"C10/8*D10","v":0}]
["Co-PI 1",null,null,null,{"$f":"C11/8*D11","v":0}]
["Co-PI 2",null,null,null,0]
["Co-PI 3",null,null,null,0]
["Co-PI 4",null,null,null,0]
[null,null,null,"Total Faculty Spring/Summer Salary Requested",{"$f":"SUM(E10:E14)","v":0}]
[null,null,null,null,"Populates main budget"]
["Faculty Supplemental   (used rarely, contact RAO) "]
[null,"Name","8 month base","Number of Days","Salary Requested (Calculates Automatically) "]
["Faculty 1",null,0,0,{"$f":"C19/1386*8*D19","v":0}]
["Faculty 2",null,null,null,{"$f":"C20/1386*8*D20","v":0}]
[null,null,null,"Total Faculty Supplemental Salary Requested",{"$f":"SUM(E19:E20)","v":0}]
[]
["PERIOD 2"]
["Faculty (Fall / Winter) "]
[null,"Name","8 month base","Number of Months","Salary Requested (Calculates Automatically)"]
["Faculty 1",null,0,0,{"$f":"C26/8*D26","v":0}]
["Faculty 2",null,null,null,{"$f":"C27/8*D27","v":0}]
[null,null,null,"Total Faculty Fall/Winter Salary Requested",{"$f":"SUM(E26:E27)","v":0}]
["Faculty Spring/Summer Salary "]
[null,"Name","8 month base","Number of Spr/Sum Months","Salary Requested (Calculates Automatically) "]
["PI",null,0,0,{"$f":"C31/8*D31","v":0}]
["Co-PI 1",null,null,null,{"$f":"C32/8*D32","v":0}]
["Co-PI 2",null,null,null,0]
["Co-PI 3",null,null,null,0]
["Co-PI 4",null,null,null,0]
[null,null,null,"Total Faculty Spring/Summer Salary Requested",{"$f":"SUM(E31:E35)","v":0}]
["Faculty Supplemental   (used rarely, contact RAO) "]
[null,"Name","8 month base","Number of Days","Salary Requested (Calculates Automatically) "]
["Faculty 1",null,0,0,{"$f":"C39/1386*8*D39","v":0}]
["Faculty 2",null,null,null,{"$f":"C40/1386*8*D40","v":0}]
[null,null,null,"Total Faculty Supplemental Salary Requested",{"$f":"SUM(E39:E40)","v":0}]
[]
["PERIOD 3"]
["Faculty (Fall / Winter)"]
[null,"Name","8 month base","Number of Months","Salary Requested (Calculates Automatically)"]
["Faculty 1",null,0,0,{"$f":"C46/8*D46","v":0}]
["Faculty 2",null,null,null,{"$f":"C47/8*D47","v":0}]
[null,null,null,"Total Faculty Fall/Winter Salary Requested",{"$f":"SUM(E46:E47)","v":0}]
["Faculty Spring/Summer Salary "]
[null,"Name","8 month base","Number of Spr/Sum Months","Salary Requested (Calculates Automatically) "]
["PI",null,0,0,{"$f":"C51/8*D51","v":0}]
["Co-PI 1",null,null,null,{"$f":"C52/8*D52","v":0}]
["Co-PI 2",null,null,null,0]
["Co-PI 3",null,null,null,0]
["Co-PI 4",null,null,null,0]
[null,null,null,"Total Faculty Spring/Summer Salary Requested",{"$f":"SUM(E51:E55)","v":0}]
["Faculty Supplemental   (used rarely, contact RAO) "]
[null,"Name","8 month base","Number of Days","Salary Requested (Calculates Automatically) "]
["Faculty 1",null,0,0,{"$f":"C59/1386*8*D59","v":0}]
["Faculty 2",null,null,null,{"$f":"C60/1386*8*D60","v":0}]
[null,null,null,"Total Faculty Supplemental Salary Requested",{"$f":"SUM(E59:E60)","v":0}]
[]
["PERIOD 4"]
["Faculty (Fall / Winter)"]
[null,"Name","8 month base","Number of Months","Salary Requested (Calculates Automatically)"]
["Faculty 1",null,0,0,{"$f":"C66/8*D66","v":0}]
["Faculty 2",null,null,null,{"$f":"C67/8*D67","v":0}]
[null,null,null,"Total Faculty Fall/Winter Salary Requested",{"$f":"SUM(E66:E67)","v":0}]
["Faculty Spring/Summer Salary "]
[null,"Name","8 month base","Number of Spr/Sum Months","Salary Requested (Calculates Automatically) "]
["PI",null,0,0,{"$f":"C71/8*D71","v":0}]
["Co-PI 1",null,null,null,{"$f":"C72/8*D72","v":0}]
["Co-PI 2",null,null,null,0]
["Co-PI 3",null,null,null,0]
["Co-PI 4",null,null,null,0]
[null,null,null,"Total Faculty Spring/Summer Salary Requested",{"$f":"SUM(E71:E75)","v":0}]
["Faculty Supplemental   (used rarely, contact RAO) "]
[null,"Name","8 month base","Number of Days","Salary Requested (Calculates Automatically) "]
["Faculty 1",null,0,0,{"$f":"C79/1386*8*D79","v":0}]
["Faculty 2",null,null,null,{"$f":"C80/1386*8*D80","v":0}]
[null,null,null,"Total Faculty Supplemental Salary Requested",{"$f":"SUM(E79:E80)","v":0}]
[]
["PERIOD 5"]
["Faculty (Fall / Winter)"]
[null,"Name","8 month base","Number of Months","Salary Requested (Calculates Automatically)"]
["Faculty 1",null,0,0,{"$f":"C86/8*D86","v":0}]
["Faculty 2",null,null,null,{"$f":"C87/8*D87","v":0}]
[null,null,null,"Total Faculty Fall/Winter Salary Requested",{"$f":"SUM(E86:E87)","v":0}]
["Faculty Spring/Summer Salary "]
[null,"Name","8 month base","Number of Spr/Sum Months","Salary Requested (Calculates Automatically) "]
["PI",null,0,0,{"$f":"C91/8*D91","v":0}]
["Co-PI 1",null,null,null,{"$f":"C92/8*D92","v":0}]
["Co-PI 2",null,null,null,0]
["Co-PI 3",null,null,null,0]
["Co-PI 4",null,null,null,0]
[null,null,null,"Total Faculty Spring/Summer Salary Requested",{"$f":"SUM(E91:E95)","v":0}]
["Faculty Supplemental   (used rarely, contact RAO) "]
[null,"Name","8 month base","Number of Days","Salary Requested (Calculates Automatically) "]
["Faculty 1",null,0,0,{"$f":"C99/1386*8*D99","v":0}]
["Faculty 2",null,null,null,{"$f":"C100/1386*8*D100","v":0}]
[null,null,null,"Total Faculty Supplemental Salary Requested",{"$f":"SUM(E99:E100)","v":0}]

{"sheet":"Lists","index":5,"n_rows":61,"n_cols":1,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Aerospace, Aeronautical, and Astronautical Engineering - Engineering: B.01"]
["Agricultural Sciences - Life Sciences: D.01"]
["Anthropology - Social Sciences: H.01"]
["Astronomy and Astrophysics - Physical Sciences: F.01"]
["Atmospheric Science and Meteorology - Geosciences, Atmospheric, and Ocean Sciences: C.01"]
["Bioengineering and Biomedical Engineering - Engineering: B.02"]
["Biological and Biomedical Sciences - Life Sciences: D.02"]
["Business Management and Business Administration - Non-S&E Fields: J.05"]
["Chemical Engineering - Engineering: B.03"]
["Chemistry - Physical Sciences: F.02"]
["Civil Engineering - Engineering: B.04"]
["Communication and Communications Technologies - Non-S&E Fields: J.06"]
["Computer and Information Sciences: A.01"]
["Economics - Social Sciences: H.02"]
["Education - Non-S&E Fields: J.01"]
["Electrical, Electronic, and Communications Engineering - Engineering: B.05"]
["Geological and Earth Sciences - Geosciences, Atmospheric, and Ocean Sciences: C.02"]
["Health Sciences - Life Sciences: D.03"]
["Humanities - Non-S&E Fields: J.03"]
["Industrial and Manufacturing Engineering - Engineering: B.06"]
["Law - Non-S&E Fields: J.02"]
["Materials Science - Physical Sciences: F.03"]
["Mathematics and Statistics: E.01"]
["Mechanical Engineering - Engineering: B.07"]
["Metallurgical and Materials Engineering - Engineering: B.08"]
["Natural Resources and Conservation - Life Sciences: D.04"]
["Ocean Sciences and Marine Sciences - Geosciences, Atmospheric, and Ocean Sciences C.03"]
["Other Engineering - Engineering: B.09"]
["Other Geosciences, Atmospheric and Ocean Sciences - Geosciences, Atmospheric, and Ocean Sciences: C:04"]
["Other Life Sciences - Life Sciences: D.05"]
["Other Non-S&E Fields - Non-S&E Fields: J.08"]
["Other Physical Sciences - Physical Sciences: F.05"]
["Other Sciences: I.01"]
["Other Social Sciences - Social Sciences: H.05"]
["Physics - Physical Sciences: F.04"]
["Political Science and Government - Social Sciences: H.03"]
["Psychology: G.01"]
["Social Work - Non-S&E Fields: J.07"]
["Sociology, Demography, and Population Studies - Social Sciences: H.04"]
["Visual and Performing Arts - Non-S&E Fields: J.04"]
[]
[]
["Basic (Fundamental) Research"]
["Applied Research"]
["Development Research"]
[]
["Avian influenza virus (highly pathogenic)"]
["Bacillus anthracis"]
["Botulinum neurotoxin"]
["Burkholderia mallei"]
["Burkholderia pseudomallei"]
["Ebola virus"]
["Foot-and-mouth disease virus"]
["Francisella tularensis"]
["Marburg virus"]
["Reconstructed 1918 Influenza virus"]
["Rinderpest virus"]
["Toxin-producing strains of Clostridium botulinum"]
["Variola major virus"]
["Variola minor virus"]
["Yersinia pestis"]