{"text_format":"2","workbook":"xlsx","n_sheets":17,"sheets":["Cover Sheet","RFP Summary","YSM-YM Clinical Plan","AF Summary Template","Salary Build Sheet (Clinical)","Non-Salary Build (Clinical)","Research Plan","OTC Calculation FY22 - OPTIONAL","OTC Calculation FY22 EXAMPLE","Assumptions","Contractual Calculator","I&A Calculator","Definitions ","Version Notes","Research Depository","Depository for MD","Depository1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":29,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Cover Sheet","index":0,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,18,2,19],[3,3,3,10],[3,18,3,19],[4,4,4,5],[5,4,5,5],[8,4,10,10],[0,2,0,5],[1,7,1,8],[2,2,2,5],[2,7,2,8]]}
[null,null,"Shared Services Submission Cover Sheet",null,null,null,"Required Signatures / Attached Email Support:"]
[{"$nulls":7},"Department Chair:"]
[{"$nulls":7},"Service Line Lead:"]
[null,null,null,"Please complete the following cover sheet and include with all SSA submissions"]
[{"$nulls":4},"Department / Section:"]
[{"$nulls":4},"Submission Title:"]
[false,"New Recruit",{"$f":"IF(A7=FALSE,\" \",B7)","v":" "},null,"Description: Please describe the submission including supportive information, background,"]
[{"$nulls":5}," description of the request and relevant details (3-5 sentences)"]
[false,"Replacement",{"$f":"IF(A9=FALSE,\" \",B9)","v":" "}]
[false,"Medical Director"," "]
[false,"Other Support"," "]
[]
[null,null,null,"Please Select from the Below List:"]
[{"$nulls":4},"Check the boxes for those items included in the submission packet, and provide requested documents"]
[{"$nulls":4},"{1}","New Recruit:"]
[]
[]
[]
[{"$nulls":4},"{2}","Replacement"]
[]
[]
[]
[{"$nulls":4},"{3}","Medical Director"]
[]
[]
[]
[]
[{"$nulls":4},"{4}","Other Programmatic Support / Departmental Support / Performance Support"]

{"sheet":"RFP Summary","index":1,"n_rows":47,"n_cols":8,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["RFP Summary","Year 1","Year 2","Year 3",null,null,null,"Notes:"]
[]
["Volume",{"$f":"'YSM-YM Clinical Plan'!C13","v":0},{"$f":"'YSM-YM Clinical Plan'!D13","v":0},{"$f":"'YSM-YM Clinical Plan'!E13","v":0},null,{"$f":"SUM(B6:D6)","v":0}]
["Revenue-generating Clinical FTE1",{"$f":"'YSM-YM Clinical Plan'!C14","v":0},{"$f":"'YSM-YM Clinical Plan'!D14","v":0},{"$f":"'YSM-YM Clinical Plan'!E14","v":0},null,{"$f":"SUM(B7:E7)","v":0}]
["# of Faculty",{"$f":"'YSM-YM Clinical Plan'!C15","v":0},{"$f":"'YSM-YM Clinical Plan'!D15","v":0},{"$f":"'YSM-YM Clinical Plan'!E15","v":0},null,{"$f":"SUM(B8:E8)","v":0}]
["Collections (Based on Full Year)",{"$f":"'YSM-YM Clinical Plan'!C16","v":0},{"$f":"'YSM-YM Clinical Plan'!D16","v":0},{"$f":"'YSM-YM Clinical Plan'!E16","v":0},null,{"$f":"SUM(B9:D9)","v":0}]
["Collections (Prorated if applicable)",{"$f":"'YSM-YM Clinical Plan'!C17","v":0},{"$f":"'YSM-YM Clinical Plan'!D17","v":0},{"$f":"'YSM-YM Clinical Plan'!E17","v":0},null,{"$f":"SUM(B10:D10)","v":0}]
[]
["Revenue/Volume Metrics:"]
["Volume per Revenue-generating cFTE",{"$f":"IF(B7>0,B6/B7,\" \")","v":" "},{"$f":"IF(C7>0,C6/C7,\" \")","v":" "},{"$f":"IF(D7>0,D6/D7,\" \")","v":" "},null,{"$f":"IF(F6>0,F6/F7,\" \")","v":" "}]
["Collections per Revenue-generating cFTE",{"$f":"IF(B7>0,B10/B7,\" \")","v":" "},{"$f":"IF(C7>0,C10/C7,\" \")","v":" "},{"$f":"IF(D7>0,D10/D7,\" \")","v":" "},null,{"$f":"IFERROR(IF(F10>0,F10/F7,\" \"),\" \")","v":" "}]
["Collections per Volume Metric",{"$f":"IFERROR(IF(B10>0,B10/B6,\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(C10>0,C10/C6,\" \"),\" \")","v":" "},{"$f":"IFERROR(IF(D10>0,D10/D6,\" \"),\" \")","v":" "},null,{"$f":"IFERROR(IF(F10>0,F10/F6,\" \"),\" \")","v":" "}]
[]
["Program Development/Direction Support"]
["Clinical Revenue - YNHH(S) Support",{"$f":"'YSM-YM Clinical Plan'!C23+'YSM-YM Clinical Plan'!C24+'YSM-YM Clinical Plan'!C25+'YSM-YM Clinical Plan'!C26","v":0},{"$f":"'YSM-YM Clinical Plan'!D23+'YSM-YM Clinical Plan'!D24+'YSM-YM Clinical Plan'!D25+'YSM-YM Clinical Plan'!D26","v":0},{"$f":"'YSM-YM Clinical Plan'!E23+'YSM-YM Clinical Plan'!E24+'YSM-YM Clinical Plan'!E25+'YSM-YM Clinical Plan'!E26","v":0},null,{"$f":"SUM(B18:D18)","v":0}]
["Clinical Revenue - Other",{"$f":"SUM('YSM-YM Clinical Plan'!C27:C30)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!D27:D30)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!E27:E30)","v":0},null,{"$f":"SUM(B19:D19)","v":0}]
["Grant Revenue - Directs",{"$f":"'Research Plan'!I6","v":0},{"$f":"'Research Plan'!Q6","v":0},{"$f":"'Research Plan'!Y6","v":0},null,0]
["Grant Revenue - Indirects",{"$f":"'Research Plan'!I7","v":0},{"$f":"'Research Plan'!Q7","v":0},{"$f":"'Research Plan'!Y7","v":0},null,0]
["Other Research Revenue ",{"$f":"SUM('Research Plan'!I8:I14)","v":0},{"$f":"SUM('Research Plan'!Q8:Q14)","v":0},{"$f":"SUM('Research Plan'!Y8:Y14)","v":0},null,0]
[]
["Revenue Grand Total",{"$f":"SUM(B18:B22,B10)","v":0},{"$f":"SUM(C18:C22,C10)","v":0},{"$f":"SUM(D18:D22,D10)","v":0},{"$f":"SUM(E18:E22,E10)","v":0},{"$f":"SUM(F18:F22,F10)","v":0}]
[]
["Applicable Assessments"]
["Total Assessments",{"$f":"'YSM-YM Clinical Plan'!C47+'Research Plan'!I33","v":0},{"$f":"'YSM-YM Clinical Plan'!D47+'Research Plan'!Q33","v":0},{"$f":"'YSM-YM Clinical Plan'!E47+'Research Plan'!Y33","v":0},null,{"$f":"SUM(B27:D27)","v":0}]
[]
["Expenses2"]
["Faculty Salaries",{"$f":"'YSM-YM Clinical Plan'!C51+'YSM-YM Clinical Plan'!C52+'Research Plan'!I18+'Research Plan'!I19","v":0},{"$f":"'YSM-YM Clinical Plan'!D51+'YSM-YM Clinical Plan'!D52+'Research Plan'!Q18+'Research Plan'!Q19","v":0},{"$f":"'YSM-YM Clinical Plan'!E51+'YSM-YM Clinical Plan'!E52+'Research Plan'!Y18+'Research Plan'!Y19","v":0},null,{"$f":"SUM(B30:D30)","v":0}]
["All Other Staffing",{"$f":"'YSM-YM Clinical Plan'!C53+'YSM-YM Clinical Plan'!C54+'Research Plan'!I24+'YSM-YM Clinical Plan'!C55","v":0},{"$f":"'YSM-YM Clinical Plan'!D53+'YSM-YM Clinical Plan'!D54+'Research Plan'!Q24+'YSM-YM Clinical Plan'!D55","v":0},{"$f":"'YSM-YM Clinical Plan'!E53+'YSM-YM Clinical Plan'!E54+'Research Plan'!Y24+'YSM-YM Clinical Plan'!E55","v":0},null,0]
["Fringe",{"$f":"'YSM-YM Clinical Plan'!C56+'Research Plan'!I21+'Research Plan'!I25","v":0},{"$f":"'YSM-YM Clinical Plan'!D56+'Research Plan'!Q21+'Research Plan'!Q25","v":0},{"$f":"'YSM-YM Clinical Plan'!E56+'Research Plan'!Y21+'Research Plan'!Y25","v":0},null,0]
["Grant Indirects",{"$f":"'Research Plan'!I34","v":0},{"$f":"'Research Plan'!Q34","v":0},{"$f":"'Research Plan'!Y34","v":0},null,0]
["Non-Salary",{"$f":"SUM('YSM-YM Clinical Plan'!C57:C60)+SUM('Research Plan'!I26:I27)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!D57:D60)+SUM('Research Plan'!Q26:Q27)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!E57:E60)+SUM('Research Plan'!Y26:Y27)","v":0},null,0]
["Total Expenses",{"$f":"SUM(B30:B34)","v":0},{"$f":"SUM(C30:C34)","v":0},{"$f":"SUM(D30:D34)","v":0},null,{"$f":"SUM(F30:F34)","v":0}]
[]
["Contribution Margin (Revenue less Direct Cost)",{"$f":"B24-B35","v":0},0,0,0,0,0]
["Contribution Margin (%)",{"$f":"IFERROR(IF(B37=0,0,B37/B24),0)","v":0},{"$f":"IFERROR(IF(C37=0,0,C37/C24),0)","v":0},{"$f":"IFERROR(IF(D37=0,0,D37/D24),0)","v":0},{"$f":"IF(E37=0,0,E37/E24)","v":0},{"$f":"IFERROR(IF(F37=0,0,F37/F24),0)","v":0}]
[]
["Expense Grand Total",{"$f":"B27+B35","v":0},{"$f":"C27+C35","v":0},{"$f":"D27+D35","v":0},null,{"$f":"F27+F35","v":0},{"$f":"G27+G35","v":0}]
[]
["Total Net Income",{"$f":"B24-B40","v":0},{"$f":"C24-C40","v":0},{"$f":"D24-D40","v":0},{"$f":"E24-E40","v":0},{"$f":"F24-F40","v":0}]
["Net Margin (%)",{"$f":"IFERROR(IF(B42=0,0,B42/B24),0)","v":0},{"$f":"IFERROR(IF(C42=0,0,C42/C24),0)","v":0},{"$f":"IFERROR(IF(D42=0,0,D42/D24),0)","v":0},{"$f":"IF(E42=0,0,E42/E24)","v":0},{"$f":"IFERROR(IF(F42=0,0,F42/F24),0)","v":0}]
[]
["YNHH(S) Overhead - CLINICAL ONLY",{"$f":"'YSM-YM Clinical Plan'!C79+'YSM-YM Clinical Plan'!C80","v":0},{"$f":"'YSM-YM Clinical Plan'!D79+'YSM-YM Clinical Plan'!D80","v":0},{"$f":"'YSM-YM Clinical Plan'!E79+'YSM-YM Clinical Plan'!E80","v":0},{"$f":"E18","v":0},{"$f":"SUM(B45:E45)","v":0}]
[null,{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$H$19:$H$23))/12*(VLOOKUP(#REF!,Depository1!$M$5:$N$21,2,0))","v":{"$error":"#REF!"}},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$H$19:$H$23))/12*(VLOOKUP(#REF!,Depository1!$M$5:$N$21,2,0))","v":{"$error":"#REF!"}},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$H$19:$H$23))/12*(VLOOKUP(#REF!,Depository1!$M$5:$N$21,2,0))","v":{"$error":"#REF!"}}]
["Total YNHH Payment - CLINICAL ONLY",{"$f":"'YSM-YM Clinical Plan'!C82","v":0},{"$f":"'YSM-YM Clinical Plan'!D82","v":0},{"$f":"'YSM-YM Clinical Plan'!E82","v":0},null,{"$f":"SUM(B47:E47)","v":0}]

{"sheet":"YSM-YM Clinical Plan","index":2,"n_rows":87,"n_cols":9,"rows_kept":87,"cut":false,"hidden":false,"merged":[[9,6,10,6],[9,0,9,1]]}
[]
[]
[null,null,"<-----Please Select Type",null,null,null,"PW: yalebulldogs"]
[null,null,"<-----Please Select Identifying Information "]
[null,null,"<-----Please Select  Department"]
[null,null,"<-----Please Select  Department Section (if applicable)"]
[]
["Select Ramp-Up Methodology/Fiscal Year---->","FY 2024","Blank ","Blank","Blank",null,"---> please select"]
["Fiscal Year Start ---->","Full Year"]
[{"$nulls":6},"3 yr. Total"]
[null,"Rates","Year 1","Year 2","Year 3",null,null,null,"Notes:"]
[]
["Volume","wRVUs",{"$nulls":4},{"$f":"SUM(C13:E13)","v":0}]
["Revenue-generating Clinical FTE1",{"$nulls":4},1,{"$f":"SUM(C14:F14)","v":1}]
["# of Faculty",{"$nulls":5},{"$f":"SUM(C15:F15)","v":0}]
["Collections (Based on Full Year)",{"$nulls":5},{"$f":"SUM(C16:E16)","v":0}]
["Collections (Prorated if applicable)",null,{"$f":"MAX(IF(C16>0,(C16-C16/(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))*Assumptions!$D$17),0),0)","v":0},{"$f":"D16*(12-Assumptions!$D$17)/12+(C16-C17)","v":0},{"$f":"(E16*(12-Assumptions!$D$17)+D16*Assumptions!$D$17)/12","v":0},null,{"$f":"SUM(C17:E17)","v":0}]
[]
["Revenue/Volume Metrics:"]
["Collections per Volume Metric",null,{"$f":"IFERROR(IF(C17>0,C17/C13,\" \"),0)","v":" "},{"$f":"IFERROR(IF(D17>0,D17/D13,\" \"),0)","v":" "},{"$f":"IFERROR(IF(E17>0,E17/E13,\" \"),0)","v":" "},null,{"$f":"IFERROR(IF(G17>0,G17/G13,\" \"),0)","v":" "}]
[]
["Program Development/Direction Support"]
["YNHH(S) Direct Salary and Fringe Benefit Support",null,{"$f":"'Salary Build Sheet (Clinical)'!S48","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AG48","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AU48","v":0},null,{"$f":"SUM(C23:E23)","v":0}]
["YNHH(S) Paid Performance Fund ",null,{"$f":"((SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$K$19:$K$23)+SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$K$19:$K$23))/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$Y$19:$Y$23)+SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$Y$19:$Y$23))","v":0},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$AM$19:$AM$23)+SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$AM$19:$AM$23))","v":0},null,{"$f":"SUM(C24:E24)","v":0}]
["YNHH(S) Contractual (include On-Call)",null,0,0,0,null,{"$f":"SUM(C25:E25)","v":0}]
["Other Clinical Contracts (not YNHHS)",null,0,0,0,null,{"$f":"SUM(C26:E26)","v":0}]
["Gifts",null,0,0,0,null,0]
["Clinical Drug Trials",null,0,0,0,null,0]
["VA Funding (Eigths)",null,0,0,0,null,0]
["Other Revenue (non-taxable) - Use for Dept. Support",null,0,0,0,null,0]
[]
["Revenue Grand Total",null,{"$f":"SUM(C23:C30,C17)","v":0},{"$f":"SUM(D23:D30,D17)","v":0},{"$f":"SUM(E23:E30,E17)","v":0},{"$f":"SUM(F23:F30,F17)","v":0},{"$f":"SUM(G23:G30,G17)","v":0}]
[]
["Applicable Assessments"]
["Dean's PFS ",7.7499999999999999E-2,{"$f":"C$17*$B35","v":0},{"$f":"D$17*$B35","v":0},{"$f":"E$17*$B35","v":0},null,{"$f":"SUM(C35:E35)","v":0}]
["YNHHS Contratual Assessment (calc. includes gross-up)",0.11700000000000001,{"$f":"(C$25/(1-B36))-C25","v":0},{"$f":"(D$25/(1-B36))-D25","v":0},{"$f":"(E$25/(1-B36))-E25","v":0},null,{"$f":"SUM(C36:E36)","v":0}]
["Other Contractual (not YNHHS)",0.15,{"$f":"IF($A$3=\"Non-Affiliated PDDO\",0,(C$26/(1-B37))-C26)","v":0},{"$f":"IF($A$3=\"Non-Affiliated PDDO\",0,(D$26/(1-B37))-D26)","v":0},{"$f":"IF($A$3=\"Non-Affiliated PDDO\",0,(E$26/(1-B37))-E26)","v":0}]
["Gifts",0.12,{"$f":"C$27*$B38","v":0},{"$f":"D$27*$B38","v":0},{"$f":"E$27*$B38","v":0},{"$f":"F$27*$B38","v":0},{"$f":"SUM(C38:E38)","v":0}]
["Clinical Drug Trial Assessment",0.23080000000000001,{"$f":"C$28*$B39","v":0},{"$f":"D$28*$B39","v":0},{"$f":"E$28*$B39","v":0},{"$f":"F$15*$B39","v":0},{"$f":"SUM(C39:E39)","v":0}]
["Department Assessment",0,null,{"$f":"D17*$B$40","v":0},{"$f":"E17*$B$40","v":0},null,{"$f":"SUM(C40:E40)","v":0}]
["Yale Medicine Administration ",0.05,{"$f":"$B41*(C17)","v":0},{"$f":"$B41*(D17)","v":0},{"$f":"$B41*(E17)","v":0},null,{"$f":"SUM(C41:E41)","v":0}]
["Yale Medicine Patient Financial Services",8.4599999999999995E-2,{"$f":"C$17*$B42","v":0},{"$f":"D$17*$B42","v":0},{"$f":"E$17*$B42","v":0},null,{"$f":"SUM(C42:E42)","v":0}]
["Revenue Assessments",null,{"$f":"SUM(C35:C42)","v":0},{"$f":"SUM(D35:D42)","v":0},0,{"$f":"SUM(F41:F42)","v":0},{"$f":"SUM(C43:E43)","v":0}]
[]
["Tack-On, Sabbatical, & Child Rearing (select salaries)",{"$f":"Assumptions!D9+Assumptions!D10","v":0.128},{"$f":"('Salary Build Sheet (Clinical)'!N48/12)*VLOOKUP('YSM-YM Clinical Plan'!$B$9,Depository1!$M$5:$N$21,2,0)","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AB48","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AP48","v":0},null,{"$f":"SUM(C45:E45)","v":0}]
["Mission Assessment",null,{"$f":"C17*$B$46","v":0},{"$f":"D17*$B$46","v":0},{"$f":"E17*$B$46","v":0},null,{"$f":"SUM(C46:E46)","v":0}]
["Total Assessments",null,{"$f":"C45+C43","v":0},{"$f":"D45+D43","v":0},0,{"$f":"F45+F44","v":0},{"$f":"SUM(C47:E47)","v":0}]
["Total Assessment Percentage as a % of Revenue",null,{"$f":"IFERROR(IF(C47>0,C47/C32,\" \"),0)","v":" "},{"$f":"IFERROR(IF(D47>0,D47/D32,\" \"),0)","v":" "},{"$f":"IFERROR(IF(E47>0,E47/E32,\" \"),0)","v":" "},null,{"$f":"IFERROR(IF(G47>0,G47/G32,\" \"),0)","v":" "}]
[]
["Expenses"]
["Faculty Salaries",null,{"$f":"('Salary Build Sheet (Clinical)'!L17/12)*VLOOKUP('YSM-YM Clinical Plan'!$B$9,Depository1!$M$5:$N$21,2,0)","v":0},{"$f":"'Salary Build Sheet (Clinical)'!Z17","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AN17","v":0},null,{"$f":"SUM(C51:E51)","v":0}]
["Faculty Incentive Compensation/Bonus",null,{"$f":"('Salary Build Sheet (Clinical)'!L24/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"'Salary Build Sheet (Clinical)'!Z24","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AJ24","v":0},null,{"$f":"SUM(C52:E52)","v":0}]
["M&P Staffing",null,{"$f":"('Salary Build Sheet (Clinical)'!L33/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"'Salary Build Sheet (Clinical)'!Z33","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AN33","v":0},null,0]
["C&T Staffing",null,{"$f":"('Salary Build Sheet (Clinical)'!L40/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+'Salary Build Sheet (Clinical)'!H46","v":0},{"$f":"'Salary Build Sheet (Clinical)'!Z40+'Salary Build Sheet (Clinical)'!Z46","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AN40+'Salary Build Sheet (Clinical)'!AN46","v":0},null,{"$f":"SUM(C54:E54)","v":0}]
["YM CARE Staffing",null,{"$f":"('Salary Build Sheet (Clinical)'!L45/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"'Salary Build Sheet (Clinical)'!Z45","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AN45","v":0},null,{"$f":"SUM(C55:E55)","v":0}]
["Fringe",null,{"$f":"('Salary Build Sheet (Clinical)'!M48/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AA48","v":0},{"$f":"'Salary Build Sheet (Clinical)'!AO48","v":0},null,{"$f":"SUM(C56:E56)","v":0}]
["Space/Sessions",null,{"$f":"'Non-Salary Build (Clinical)'!C16","v":0},{"$f":"'Non-Salary Build (Clinical)'!D16","v":0},{"$f":"'Non-Salary Build (Clinical)'!E16","v":0},null,0]
["Malpractice",null,{"$f":"'Non-Salary Build (Clinical)'!C21","v":0},{"$f":"'Non-Salary Build (Clinical)'!D21","v":0},{"$f":"'Non-Salary Build (Clinical)'!E21","v":0},null,0]
["Medical & Surgical Supplies",null,{"$f":"'Non-Salary Build (Clinical)'!C26","v":0},{"$f":"'Non-Salary Build (Clinical)'!D26","v":0},{"$f":"'Non-Salary Build (Clinical)'!E26","v":0},null,0]
["Other Applicable Costs",null,{"$f":"'Non-Salary Build (Clinical)'!C38","v":0},{"$f":"'Non-Salary Build (Clinical)'!D38","v":0},{"$f":"'Non-Salary Build (Clinical)'!E38","v":0},null,0]
["Total Expenses",null,{"$f":"SUM(C51:C60)","v":0},{"$f":"SUM(D51:D60)","v":0},{"$f":"SUM(E51:E60)","v":0},null,{"$f":"SUM(G51:G60)","v":0}]
[]
["Contribution Margin (Revenue less Direct Cost)",null,{"$f":"C32-C61","v":0},0,0,0,0,0]
["Contribution Margin (%)",null,{"$f":"IFERROR(IF(C63=0,0,C63/C32),0)","v":0},{"$f":"IFERROR(IF(D63=0,0,D63/D32),0)","v":0},{"$f":"IFERROR(IF(E63=0,0,E63/E32),0)","v":0},{"$f":"IF(F63=0,0,F63/F32)","v":0},{"$f":"IFERROR(IF(G63=0,0,G63/G32),0)","v":0}]
[]
["Expense Grand Total",null,{"$f":"C47+C61","v":0},{"$f":"D47+D61","v":0},0,null,0,0]
[]
["Total Net Income before Applicable PDDO Assessments",null,{"$f":"C32-C66","v":0},{"$f":"D32-D66","v":0},{"$f":"E32-E66","v":0},{"$f":"F32-F66","v":0},{"$f":"G32-G66","v":0}]
["Net Margin (%)",null,{"$f":"IFERROR(IF(C68=0,0,C68/C32),0)","v":0},{"$f":"IFERROR(IF(D68=0,0,D68/D32),0)","v":0},{"$f":"IFERROR(IF(E68=0,0,E68/E32),0)","v":0},null,{"$f":"IFERROR(IF(G68=0,0,G68/G32),0)","v":0}]
[]
["YNHH(S) Direct Salary and Fringe Benefit Support - Salary",null,{"$f":"('Salary Build Sheet (Clinical)'!$G$10*'Salary Build Sheet (Clinical)'!$H$10)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$11*'Salary Build Sheet (Clinical)'!$H$11)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$12*'Salary Build Sheet (Clinical)'!$H$12)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$13*'Salary Build Sheet (Clinical)'!$H$13)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$14*'Salary Build Sheet (Clinical)'!$H$14)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$15*'Salary Build Sheet (Clinical)'!$H$15)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+('Salary Build Sheet (Clinical)'!$G$16*'Salary Build Sheet (Clinical)'!$H$16)/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))+C72","v":0},{"$f":"('Salary Build Sheet (Clinical)'!$T$10*'Salary Build Sheet (Clinical)'!$V$10)+('Salary Build Sheet (Clinical)'!$T$11*'Salary Build Sheet (Clinical)'!$V$11)+('Salary Build Sheet (Clinical)'!$T$12*'Salary Build Sheet (Clinical)'!$V$12)+('Salary Build Sheet (Clinical)'!$T$13*'Salary Build Sheet (Clinical)'!$V$13)+('Salary Build Sheet (Clinical)'!$T$14*'Salary Build Sheet (Clinical)'!$V$14)+('Salary Build Sheet (Clinical)'!$T$15*'Salary Build Sheet (Clinical)'!$V$15)+('Salary Build Sheet (Clinical)'!$T$16*'Salary Build Sheet (Clinical)'!$V$16)+D72","v":0},{"$f":"('Salary Build Sheet (Clinical)'!$AH$10*'Salary Build Sheet (Clinical)'!$AJ$10)+('Salary Build Sheet (Clinical)'!$AH$11*'Salary Build Sheet (Clinical)'!$AJ$11)+('Salary Build Sheet (Clinical)'!$AH$12*'Salary Build Sheet (Clinical)'!$AJ$12)+('Salary Build Sheet (Clinical)'!$AH$13*'Salary Build Sheet (Clinical)'!$AJ$13)+('Salary Build Sheet (Clinical)'!$AH$14*'Salary Build Sheet (Clinical)'!$AJ$14)+('Salary Build Sheet (Clinical)'!$AH$15*'Salary Build Sheet (Clinical)'!$AJ$15)+('Salary Build Sheet (Clinical)'!$AH$16*'Salary Build Sheet (Clinical)'!$AJ$16)+E72","v":0},{"$f":"F23","v":0},{"$f":"SUM(C71:F71)","v":0}]
[null,null,{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$H$19:$H$23))/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$V$19:$V$23))","v":0},{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Not Metric-Based\",'Salary Build Sheet (Clinical)'!$AJ$19:$AJ$23))","v":0}]
["YNHH(S) Direct Salary - YSM Overhead Waived",null,{"$f":"(SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$H$19:$H$23))/12*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$V$19:$V$23)","v":0},{"$f":"SUMIF('Salary Build Sheet (Clinical)'!$C$19:$C$23,\"YNHH Metric-Based\",'Salary Build Sheet (Clinical)'!$AJ$19:$AJ$23)","v":0},null,{"$f":"SUM(C73:F73)","v":0}]
["YNHH(S) Direct Salary and Fringe Benefit Support -Fringe",null,{"$f":"(SUM(C72:C73)*Assumptions!$D$15)+(('Salary Build Sheet (Clinical)'!$I$10*'Salary Build Sheet (Clinical)'!$G$10)/12+('Salary Build Sheet (Clinical)'!$I$11*'Salary Build Sheet (Clinical)'!$G$11)/12+('Salary Build Sheet (Clinical)'!$I$12*'Salary Build Sheet (Clinical)'!$G$12)/12+('Salary Build Sheet (Clinical)'!$I$13*'Salary Build Sheet (Clinical)'!$G$13)/12+('Salary Build Sheet (Clinical)'!$I$14*'Salary Build Sheet (Clinical)'!$G$14)/12+('Salary Build Sheet (Clinical)'!$I$15*'Salary Build Sheet (Clinical)'!$G$15)/12+('Salary Build Sheet (Clinical)'!$I$16*'Salary Build Sheet (Clinical)'!$G$16)/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"('Salary Build Sheet (Clinical)'!$T$10*'Salary Build Sheet (Clinical)'!$W$10)+('Salary Build Sheet (Clinical)'!$T$11*'Salary Build Sheet (Clinical)'!$W$11)+('Salary Build Sheet (Clinical)'!$T$12*'Salary Build Sheet (Clinical)'!$W$12)+('Salary Build Sheet (Clinical)'!$T$13*'Salary Build Sheet (Clinical)'!$W$13)+('Salary Build Sheet (Clinical)'!$T$14*'Salary Build Sheet (Clinical)'!$W$14)+('Salary Build Sheet (Clinical)'!$T$15*'Salary Build Sheet (Clinical)'!$W$15)+('Salary Build Sheet (Clinical)'!$T$16*'Salary Build Sheet (Clinical)'!$W$16)+(SUM($D$72:$D$73)*Assumptions!$D$15)","v":0},{"$f":"('Salary Build Sheet (Clinical)'!$AH$10*'Salary Build Sheet (Clinical)'!$AK$10)+('Salary Build Sheet (Clinical)'!$AH$11*'Salary Build Sheet (Clinical)'!$AK$11)+('Salary Build Sheet (Clinical)'!$AH$12*'Salary Build Sheet (Clinical)'!$AK$12)+('Salary Build Sheet (Clinical)'!$AH$13*'Salary Build Sheet (Clinical)'!$AK$13)+('Salary Build Sheet (Clinical)'!$AH$14*'Salary Build Sheet (Clinical)'!$AK$14)+('Salary Build Sheet (Clinical)'!$AH$15*'Salary Build Sheet (Clinical)'!$AK$15)+('Salary Build Sheet (Clinical)'!$AH$16*'Salary Build Sheet (Clinical)'!$AK$16)+(SUM($E$72:$E$73)*Assumptions!$D$15)","v":0},null,{"$f":"SUM(C74:F74)","v":0}]
["YNHH(S) Direct Salary and Fringe Benefit Support -Tack-On",null,{"$f":"(SUM(C73:C74)*Assumptions!$D$15)+(('Salary Build Sheet (Clinical)'!$J$10*'Salary Build Sheet (Clinical)'!$G$10)/12+('Salary Build Sheet (Clinical)'!$J$11*'Salary Build Sheet (Clinical)'!$G$11)/12+('Salary Build Sheet (Clinical)'!$J$12*'Salary Build Sheet (Clinical)'!$G$12)/12+('Salary Build Sheet (Clinical)'!$J$13*'Salary Build Sheet (Clinical)'!$G$13)/12+('Salary Build Sheet (Clinical)'!$J$14*'Salary Build Sheet (Clinical)'!$G$14)/12+('Salary Build Sheet (Clinical)'!$J$15*'Salary Build Sheet (Clinical)'!$G$15)/12+('Salary Build Sheet (Clinical)'!$J$16*'Salary Build Sheet (Clinical)'!$G$16)/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"(SUM(D73:D74)*Assumptions!$D$15)+(('Salary Build Sheet (Clinical)'!$J$10*'Salary Build Sheet (Clinical)'!$G$10)/12+('Salary Build Sheet (Clinical)'!$J$11*'Salary Build Sheet (Clinical)'!$G$11)/12+('Salary Build Sheet (Clinical)'!$J$12*'Salary Build Sheet (Clinical)'!$G$12)/12+('Salary Build Sheet (Clinical)'!$J$13*'Salary Build Sheet (Clinical)'!$G$13)/12+('Salary Build Sheet (Clinical)'!$J$14*'Salary Build Sheet (Clinical)'!$G$14)/12+('Salary Build Sheet (Clinical)'!$J$15*'Salary Build Sheet (Clinical)'!$G$15)/12+('Salary Build Sheet (Clinical)'!$J$16*'Salary Build Sheet (Clinical)'!$G$16)/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0},{"$f":"(SUM(E73:E74)*Assumptions!$D$15)+(('Salary Build Sheet (Clinical)'!$J$10*'Salary Build Sheet (Clinical)'!$G$10)/12+('Salary Build Sheet (Clinical)'!$J$11*'Salary Build Sheet (Clinical)'!$G$11)/12+('Salary Build Sheet (Clinical)'!$J$12*'Salary Build Sheet (Clinical)'!$G$12)/12+('Salary Build Sheet (Clinical)'!$J$13*'Salary Build Sheet (Clinical)'!$G$13)/12+('Salary Build Sheet (Clinical)'!$J$14*'Salary Build Sheet (Clinical)'!$G$14)/12+('Salary Build Sheet (Clinical)'!$J$15*'Salary Build Sheet (Clinical)'!$G$15)/12+('Salary Build Sheet (Clinical)'!$J$16*'Salary Build Sheet (Clinical)'!$G$16)/12)*(VLOOKUP($B$9,Depository1!$M$5:$N$21,2,0))","v":0}]
["Total Direct Salary and Fringe Cost to YNHH(S)",null,{"$f":"C23+C24","v":0},{"$f":"D23+D24","v":0},{"$f":"E23+E24","v":0},{"$f":"SUM(F71:F74)","v":0},{"$f":"E76+D76+C76","v":0}]
[]
["Total YNHH(S) Contractual (include On-Call)",null,{"$f":"IF(AND($A$3=\"YNHHS PDDO\",C68<0),-C68,C26)","v":0},{"$f":"IF(AND($A$3=\"YNHHS PDDO\",D68<0),-D68,D26)","v":0},{"$f":"IF(AND($A$3=\"YNHHS PDDO\",E68<0),-E68,E26)","v":0},{"$f":"IF($A$3=\"YNHHS Contractual - PDDO\",-F68,F25)","v":0},{"$f":"E78+D78+C78","v":0}]
["YNHH Overhead",0.11700000000000001,{"$f":"IF(AND($A$3=\"YNHH PDDO\",(C$68<0)),(-C$68*$B$79)+(C$76)*$B$79,0)","v":0},{"$f":"IF(AND($A$3=\"YNHH PDDO\",(D$68<0)),(-D$68*$B$79)+(D$76)*$B$79,0)","v":0},0,{"$f":"IF($A$3=\"YNHHS Contractual - PDDO\",0,IF(AND($A$3=\"PDDO - YNHH\",F68<0),(F76+F78+-F68),(F76+F78))*$B$79)","v":0},{"$f":"E79+D79+C79","v":0}]
["YNHHS/Other Contract Overhead (calc. includes gross-up)",0.11700000000000001,{"$f":"IF(AND($A$3=\"YNHHS PDDO\",C$68<0),(-C$68/(1-$B$80)+C$68)+C$76/(1-$B$80)+-C$76,0)","v":0},{"$f":"IF(AND($A$3=\"YNHHS PDDO\",D$68<0),(-D$68/(1-$B$80)+D$68)+D$76/(1-$B$80)+-D$76,0)","v":0},0,{"$f":"IF($A$3=\"YNHHS Contractual - PDDO\",((F78+F76)/0.85))-F78-F76","v":0},{"$f":"E80+D80+C80","v":0}]
["Non-Affiliated PDDO Overhead (calc. includes gross-up)",0.15,{"$f":"IF(AND($A$3=\"Non-Affiliated PDDO\",C$68<0),(-C$68/(1-$B$81)+C$68)+C$76/(1-$B$81)+-C$76,0)","v":0},{"$f":"IF(AND($A$3=\"Non-Affiliated PDDO\",D$68<0),(-D$68/(1-$B$81)+D$68)+D$76/(1-$B$81)+-D$76,0)","v":0},{"$f":"IF(AND($A$3=\"Non-Affiliated PDDO\",E$68<0),(-E$68/(1-$B$81)+E$68)+E$76/(1-$B$81)+-E$76,0)","v":0},null,{"$f":"E81+D81+C81","v":0}]
["Total Payment to Yale University",null,{"$f":"IF($A$3=\"Contractual\",(C25+C24+C23+C26+SUM(C36:C37)),(C81+C80+C79+C76+-C68))","v":0},{"$f":"IF($A$3=\"Contractual\",(D25+D24+D23+D26+SUM(D36:D37)),(D81+D80+D79+D76+-D68))","v":0},{"$f":"IF($A$3=\"Contractual\",(E25+E24+E23+E26+SUM(E36:E37)),(E81+E80+E79+E76+-E68))","v":0},null,{"$f":"E82+D82+C82","v":0}]
[]
["1) Expected Volume-generating cFTE (total of all physicians or for one individual)."]
[{"$nulls":5},{"$f":"-F68/(1-$B$79)+$C$68","v":0}]
[{"$nulls":5},{"$f":"F23","v":0}]
[{"$nulls":5},{"$f":"F86+F85+F79","v":0}]

{"sheet":"AF Summary Template","index":3,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"'YSM-YM Clinical Plan'!A3","v":0}]
[]
[null,null,{"$f":"'YSM-YM Clinical Plan'!B8","v":"FY 2024"},{"$f":"CONCATENATE(\"FY\", \" \",RIGHT(C6,4)+1)","v":"FY 2025"},{"$f":"CONCATENATE(\"FY\", \" \",RIGHT(D6,4)+1)","v":"FY 2026"},"FY 23","FY 24","3 Year Total","Comments"]
[null,"cFTE",{"$f":"'YSM-YM Clinical Plan'!C14","v":0},{"$f":"'YSM-YM Clinical Plan'!D14","v":0},{"$f":"'YSM-YM Clinical Plan'!E14","v":0},1,{"$f":"+D7","v":0}]
[null,"Volume",{"$f":"'YSM-YM Clinical Plan'!C13","v":0},{"$f":"'YSM-YM Clinical Plan'!D13","v":0},{"$f":"'YSM-YM Clinical Plan'!E13","v":0},{"$f":"'[1]YSM-YM Clinical Plan'!F14","v":0},{"$f":"'[1]YSM-YM Clinical Plan'!G14","v":1000},{"$f":"SUM(C8:E8)","v":0},{"$f":"'YSM-YM Clinical Plan'!B13","v":"wRVUs"}]
[null,"Volume as % of Benchmark"]
[]
[null,"REVENUE"]
[null,"Total Revenues",{"$f":"'YSM-YM Clinical Plan'!C32","v":0},{"$f":"'YSM-YM Clinical Plan'!D32","v":0},{"$f":"'YSM-YM Clinical Plan'!E32","v":0},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(C12:E12)","v":0}]
[]
[null,"EXPENSES"]
[null,"Subtotal (Assessments)",{"$f":"'YSM-YM Clinical Plan'!C47","v":0},{"$f":"'YSM-YM Clinical Plan'!D47","v":0},{"$f":"'YSM-YM Clinical Plan'!E47","v":0},null,null,{"$f":"+SUM(C15:G15)","v":0}]
[null,"Subtotal (Faculty Expenses)",{"$f":"'YSM-YM Clinical Plan'!C51+'YSM-YM Clinical Plan'!C52","v":0},{"$f":"'YSM-YM Clinical Plan'!D51+'YSM-YM Clinical Plan'!D52","v":0},{"$f":"'YSM-YM Clinical Plan'!E51+'YSM-YM Clinical Plan'!E52","v":0},null,null,{"$f":"+SUM(C16:G16)","v":0}]
[null,"Subtotal (Staff Expenses)",{"$f":"'YSM-YM Clinical Plan'!C53+'YSM-YM Clinical Plan'!C54+'YSM-YM Clinical Plan'!C55","v":0},{"$f":"'YSM-YM Clinical Plan'!D53+'YSM-YM Clinical Plan'!D54+'YSM-YM Clinical Plan'!D55","v":0},{"$f":"'YSM-YM Clinical Plan'!E53+'YSM-YM Clinical Plan'!E54+'YSM-YM Clinical Plan'!E55","v":0},null,null,{"$f":"+SUM(C17:G17)","v":0}]
[null,"Subtotal (Fringe)",{"$f":"'YSM-YM Clinical Plan'!C56","v":0},{"$f":"'YSM-YM Clinical Plan'!D56","v":0},{"$f":"'YSM-YM Clinical Plan'!E56","v":0},null,null,{"$f":"+SUM(C18:G18)","v":0}]
[]
[null,"Subtotal (Non-labor Expenses)",{"$f":"SUM('YSM-YM Clinical Plan'!C57:C60)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!D57:D60)","v":0},{"$f":"SUM('YSM-YM Clinical Plan'!E57:E60)","v":0},null,null,{"$f":"+SUM(C20:G20)","v":0}]
[null,"Total Expenses",{"$f":"C15+C16+C17+C18+C20","v":0},{"$f":"D15+D16+D17+D18+D20","v":0},{"$f":"E15+E16+E17+E18+E20","v":0},{"$f":"F15+F16+F17+F20","v":0},0,{"$f":"+SUM(C21:G21)","v":0}]
[]
[null,"Net Over/(Under)",{"$f":"C12-C21","v":0},{"$f":"D12-D21","v":0},{"$f":"E12-E21","v":0},{"$f":"F12-F21","v":{"$error":"#REF!"}},{"$f":"G12-G21","v":{"$error":"#REF!"}},{"$f":"SUM(C23:E23)","v":0}]
[]
[null,"Non-PDDO Support",{"$f":"'YSM-YM Clinical Plan'!C76","v":0},{"$f":"'YSM-YM Clinical Plan'!D76","v":0},{"$f":"'YSM-YM Clinical Plan'!E76","v":0},null,null,{"$f":"SUM(C25:E25)","v":0}]
[null,"Other Support and Gross-Up",{"$f":"'YSM-YM Clinical Plan'!C78+'YSM-YM Clinical Plan'!C79+'YSM-YM Clinical Plan'!C80","v":0},{"$f":"'YSM-YM Clinical Plan'!D78+'YSM-YM Clinical Plan'!D79+'YSM-YM Clinical Plan'!D80","v":0},{"$f":"'YSM-YM Clinical Plan'!E78+'YSM-YM Clinical Plan'!E79+'YSM-YM Clinical Plan'!E80","v":0},null,null,{"$f":"SUM(C26:E26)","v":0}]
[]
[null,"Total Payment from YNHH(S)",{"$f":"'YSM-YM Clinical Plan'!C82","v":0},{"$f":"'YSM-YM Clinical Plan'!D82","v":0},{"$f":"'YSM-YM Clinical Plan'!E82","v":0},{"$f":"+IF(F23<1,F23*1.15,F23)","v":{"$error":"#REF!"}},{"$f":"+IF(G23<1,G23*1.15,G23)","v":{"$error":"#REF!"}},{"$f":"SUM(C28:E28)","v":0}]

{"sheet":"Salary Build Sheet (Clinical)","index":4,"n_rows":48,"n_cols":53,"rows_kept":48,"cut":false,"hidden":false,"merged":[[5,19,5,32],[5,33,5,46],[6,34,7,34],[6,6,7,6],[5,5,5,18],[6,20,7,20]]}
[]
[]
[{"$nulls":6},"Assume compensation is for 1.0 FTE; formula will prorate for Clinical effort"]
[{"$nulls":6},"Salary support should be proportional to 1.0 FTE"]
[null,"Salary Build Plan"]
[null,null,null,"(impacts family leave fringe)",null,"Year One",{"$nulls":13},"Year Two",{"$nulls":13},"Year Three"]
[null,null,"Position","Clinical or","Grant","Total Clinical","Total Salary Support FTE","Full FTE",null,null,"Year One","Clinical Total","Clinical Total","Clinical Total","Clinical Total","Salary Support","Salary Support","Salary Support","Salary Support","Total Clinical","Total Salary Support FTE",null,null,null,"Year Two","Clinical Total","Clinical Total","Clinical Total","Clinical Total","Salary Support","Salary Support","Salary Support","Salary Support","Total Clinical","Total Salary Support FTE",null,null,null,"Year Three","Clinical Total","Clinical Total","Clinical Total","Clinical Total","Salary Support","Salary Support","Salary Support","Salary Support","Cumulative"]
[null,"Type of Position/Name","Description"," Non-Clinical?","Funded?","FTE (not cFTE)",null,"Compensation","Fringe","Tack-On","Total ","Comp","Fringe","Tack-On","Total","Comp","Fringe","Tack-On","Total","FTE (not cFTE)",null,"Comp.1","Fringe","Tack-On","Total ","Comp","Fringe","Tack-On","Total","Comp","Fringe","Tack-On","Total","FTE (not cFTE)",null,"Comp.1","Fringe","Tack-On","Total ","Comp","Fringe","Tack-On","Total","Comp","Fringe","Tack-On","Total","Clinica lStaff Costs"]
[null,"Faculty Staffing"]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D10=\"Non-Clinical\",IF($E10=\"Yes\",IF(H10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H10*Assumptions!$D$8),IF(H10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H10-Assumptions!$D$18)*Assumptions!$D$13),H10*Assumptions!$D$6)),IF($E10=\"Yes\",IF(H10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H10*Assumptions!$D$8),IF(H10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H10-Assumptions!$D$18)*Assumptions!$D$14),H10*Assumptions!$D$7)))","v":0},{"$f":"IF(E10=\"Non-Clinical\",IF($E10=\"Yes\",IF(H10>Assumptions!$D$18,(Assumptions!$D$18*0),H10*0),IF(H10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H10-Assumptions!$D$18)*0),H10*(Assumptions!$D$9+Assumptions!$D$10))),IF($E10=\"Yes\",IF(H10>Assumptions!$D$18,(Assumptions!$D$18*0),H10*0),IF(H10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H10-Assumptions!$D$18)*0),H10*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"I10+H10+J10","v":0},{"$f":"H10*F10","v":0},{"$f":"I10*F10","v":0},{"$f":"J10*F10","v":0},{"$f":"SUM(L10:N10)","v":0},{"$f":"H10*G10","v":0},{"$f":"I10*G10","v":0},{"$f":"J10*G10","v":0},{"$f":"SUM(P10:R10)","v":0},null,null,null,{"$f":"IF(J10=\"Non-Clinical\",IF($E10=\"Yes\",IF(V10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V10*Assumptions!$D$8),IF(V10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V10-Assumptions!$D$18)*Assumptions!$D$13),V10*Assumptions!$D$6)),IF($E10=\"Yes\",IF(V10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V10*Assumptions!$D$8),IF(V10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V10-Assumptions!$D$18)*Assumptions!$D$14),V10*Assumptions!$D$7)))","v":0},{"$f":"IF(K10=\"Non-Clinical\",IF($E10=\"Yes\",IF(V10>Assumptions!$D$18,(Assumptions!$D$18*0),V10*0),IF(V10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V10-Assumptions!$D$18)*0),V10*(Assumptions!$D$9+Assumptions!$D$10))),IF($E10=\"Yes\",IF(V10>Assumptions!$D$18,(Assumptions!$D$18*0),V10*0),IF(V10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V10-Assumptions!$D$18)*0),V10*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"W10+V10+X10","v":0},{"$f":"V10*T10","v":0},{"$f":"W10*T10","v":0},{"$f":"X10*T10","v":0},{"$f":"SUM(Z10:AB10)","v":0},{"$f":"V10*U10","v":0},{"$f":"W10*U10","v":0},{"$f":"X10*U10","v":0},{"$f":"SUM(AD10:AF10)","v":0},null,null,null,{"$f":"IF(X10=\"Non-Clinical\",IF($E10=\"Yes\",IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ10*Assumptions!$D$8),IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ10-Assumptions!$D$18)*Assumptions!$D$13),AJ10*Assumptions!$D$6)),IF($E10=\"Yes\",IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ10*Assumptions!$D$8),IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ10-Assumptions!$D$18)*Assumptions!$D$14),AJ10*Assumptions!$D$7)))","v":0},{"$f":"IF(Y10=\"Non-Clinical\",IF($E10=\"Yes\",IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*0),AJ10*0),IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ10-Assumptions!$D$18)*0),AJ10*(Assumptions!$D$9+Assumptions!$D$10))),IF($E10=\"Yes\",IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*0),AJ10*0),IF(AJ10>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ10-Assumptions!$D$18)*0),AJ10*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"AK10+AJ10+AL10","v":0},{"$f":"AJ10*AH10","v":0},{"$f":"AK10*AH10","v":0},{"$f":"AL10*AH10","v":0},{"$f":"SUM(AN10:AP10)","v":0},{"$f":"AJ10*AI10","v":0},{"$f":"AK10*AI10","v":0},{"$f":"AL10*AI10","v":0},{"$f":"SUM(AR10:AT10)","v":0},{"$f":"AQ10+AC10+O10","v":0},null,null,{"$f":"IF(G10>0,(G10/#REF!)*H10,\" \")","v":" "},{"$f":"IF(G10>0,(G10/#REF!)*W10,\" \")","v":" "},{"$f":"SUM(AY10:AZ10)","v":0}]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D11=\"Non-Clinical\",IF($E11=\"Yes\",IF(H11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H11*Assumptions!$D$8),IF(H11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H11-Assumptions!$D$18)*Assumptions!$D$13),H11*Assumptions!$D$6)),IF($E11=\"Yes\",IF(H11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H11*Assumptions!$D$8),IF(H11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H11-Assumptions!$D$18)*Assumptions!$D$14),H11*Assumptions!$D$7)))","v":0},{"$f":"IF(E11=\"Non-Clinical\",IF($E11=\"Yes\",IF(H11>Assumptions!$D$18,(Assumptions!$D$18*0),H11*0),IF(H11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H11-Assumptions!$D$18)*0),H11*(Assumptions!$D$9+Assumptions!$D$10))),IF($E11=\"Yes\",IF(H11>Assumptions!$D$18,(Assumptions!$D$18*0),H11*0),IF(H11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H11-Assumptions!$D$18)*0),H11*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"I11+H11+J11","v":0},{"$f":"H11*F11","v":0},{"$f":"I11*F11","v":0},{"$f":"J11*F11","v":0},{"$f":"SUM(L11:N11)","v":0},{"$f":"H11*G11","v":0},{"$f":"I11*G11","v":0},{"$f":"J11*G11","v":0},{"$f":"SUM(P11:R11)","v":0},null,null,null,{"$f":"IF(J11=\"Non-Clinical\",IF($E11=\"Yes\",IF(V11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V11*Assumptions!$D$8),IF(V11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V11-Assumptions!$D$18)*Assumptions!$D$13),V11*Assumptions!$D$6)),IF($E11=\"Yes\",IF(V11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V11*Assumptions!$D$8),IF(V11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V11-Assumptions!$D$18)*Assumptions!$D$14),V11*Assumptions!$D$7)))","v":0},{"$f":"IF(K11=\"Non-Clinical\",IF($E11=\"Yes\",IF(V11>Assumptions!$D$18,(Assumptions!$D$18*0),V11*0),IF(V11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V11-Assumptions!$D$18)*0),V11*(Assumptions!$D$9+Assumptions!$D$10))),IF($E11=\"Yes\",IF(V11>Assumptions!$D$18,(Assumptions!$D$18*0),V11*0),IF(V11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V11-Assumptions!$D$18)*0),V11*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"W11+V11+X11","v":0},{"$f":"V11*T11","v":0},{"$f":"W11*T11","v":0},{"$f":"X11*T11","v":0},{"$f":"SUM(Z11:AB11)","v":0},{"$f":"V11*U11","v":0},{"$f":"W11*U11","v":0},{"$f":"X11*U11","v":0},{"$f":"SUM(AD11:AF11)","v":0},null,null,null,{"$f":"IF(X11=\"Non-Clinical\",IF($E11=\"Yes\",IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ11*Assumptions!$D$8),IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ11-Assumptions!$D$18)*Assumptions!$D$13),AJ11*Assumptions!$D$6)),IF($E11=\"Yes\",IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ11*Assumptions!$D$8),IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ11-Assumptions!$D$18)*Assumptions!$D$14),AJ11*Assumptions!$D$7)))","v":0},{"$f":"IF(Y11=\"Non-Clinical\",IF($E11=\"Yes\",IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*0),AJ11*0),IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ11-Assumptions!$D$18)*0),AJ11*(Assumptions!$D$9+Assumptions!$D$10))),IF($E11=\"Yes\",IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*0),AJ11*0),IF(AJ11>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ11-Assumptions!$D$18)*0),AJ11*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},{"$f":"AK11+AJ11+AL11","v":0},0,0,0,{"$f":"SUM(AN11:AP11)","v":0},{"$f":"AJ11*AI11","v":0},{"$f":"AK11*AI11","v":0},{"$f":"AL11*AI11","v":0},{"$f":"SUM(AR11:AT11)","v":0},0,null,null,{"$f":"IF(G11>0,(G11/#REF!)*H11,\" \")","v":" "},{"$f":"IF(G11>0,(G11/#REF!)*W11,\" \")","v":" "},{"$f":"SUM(AY11:AZ11)","v":0}]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D12=\"Non-Clinical\",IF($E12=\"Yes\",IF(H12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H12*Assumptions!$D$8),IF(H12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H12-Assumptions!$D$18)*Assumptions!$D$13),H12*Assumptions!$D$6)),IF($E12=\"Yes\",IF(H12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H12*Assumptions!$D$8),IF(H12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H12-Assumptions!$D$18)*Assumptions!$D$14),H12*Assumptions!$D$7)))","v":0},{"$f":"IF(E12=\"Non-Clinical\",IF($E12=\"Yes\",IF(H12>Assumptions!$D$18,(Assumptions!$D$18*0),H12*0),IF(H12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H12-Assumptions!$D$18)*0),H12*(Assumptions!$D$9+Assumptions!$D$10))),IF($E12=\"Yes\",IF(H12>Assumptions!$D$18,(Assumptions!$D$18*0),H12*0),IF(H12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H12-Assumptions!$D$18)*0),H12*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(J12=\"Non-Clinical\",IF($E12=\"Yes\",IF(V12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V12*Assumptions!$D$8),IF(V12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V12-Assumptions!$D$18)*Assumptions!$D$13),V12*Assumptions!$D$6)),IF($E12=\"Yes\",IF(V12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V12*Assumptions!$D$8),IF(V12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V12-Assumptions!$D$18)*Assumptions!$D$14),V12*Assumptions!$D$7)))","v":0},{"$f":"IF(K12=\"Non-Clinical\",IF($E12=\"Yes\",IF(V12>Assumptions!$D$18,(Assumptions!$D$18*0),V12*0),IF(V12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V12-Assumptions!$D$18)*0),V12*(Assumptions!$D$9+Assumptions!$D$10))),IF($E12=\"Yes\",IF(V12>Assumptions!$D$18,(Assumptions!$D$18*0),V12*0),IF(V12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V12-Assumptions!$D$18)*0),V12*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(X12=\"Non-Clinical\",IF($E12=\"Yes\",IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ12*Assumptions!$D$8),IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ12-Assumptions!$D$18)*Assumptions!$D$13),AJ12*Assumptions!$D$6)),IF($E12=\"Yes\",IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ12*Assumptions!$D$8),IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ12-Assumptions!$D$18)*Assumptions!$D$14),AJ12*Assumptions!$D$7)))","v":0},{"$f":"IF(Y12=\"Non-Clinical\",IF($E12=\"Yes\",IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*0),AJ12*0),IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ12-Assumptions!$D$18)*0),AJ12*(Assumptions!$D$9+Assumptions!$D$10))),IF($E12=\"Yes\",IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*0),AJ12*0),IF(AJ12>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ12-Assumptions!$D$18)*0),AJ12*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(G12>0,(G12/#REF!)*H12,\" \")","v":" "},{"$f":"IF(G12>0,(G12/#REF!)*W12,\" \")","v":" "},0]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D13=\"Non-Clinical\",IF($E13=\"Yes\",IF(H13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H13*Assumptions!$D$8),IF(H13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H13-Assumptions!$D$18)*Assumptions!$D$13),H13*Assumptions!$D$6)),IF($E13=\"Yes\",IF(H13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H13*Assumptions!$D$8),IF(H13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H13-Assumptions!$D$18)*Assumptions!$D$14),H13*Assumptions!$D$7)))","v":0},{"$f":"IF(E13=\"Non-Clinical\",IF($E13=\"Yes\",IF(H13>Assumptions!$D$18,(Assumptions!$D$18*0),H13*0),IF(H13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H13-Assumptions!$D$18)*0),H13*(Assumptions!$D$9+Assumptions!$D$10))),IF($E13=\"Yes\",IF(H13>Assumptions!$D$18,(Assumptions!$D$18*0),H13*0),IF(H13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H13-Assumptions!$D$18)*0),H13*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(J13=\"Non-Clinical\",IF($E13=\"Yes\",IF(V13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V13*Assumptions!$D$8),IF(V13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V13-Assumptions!$D$18)*Assumptions!$D$13),V13*Assumptions!$D$6)),IF($E13=\"Yes\",IF(V13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V13*Assumptions!$D$8),IF(V13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V13-Assumptions!$D$18)*Assumptions!$D$14),V13*Assumptions!$D$7)))","v":0},{"$f":"IF(K13=\"Non-Clinical\",IF($E13=\"Yes\",IF(V13>Assumptions!$D$18,(Assumptions!$D$18*0),V13*0),IF(V13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V13-Assumptions!$D$18)*0),V13*(Assumptions!$D$9+Assumptions!$D$10))),IF($E13=\"Yes\",IF(V13>Assumptions!$D$18,(Assumptions!$D$18*0),V13*0),IF(V13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V13-Assumptions!$D$18)*0),V13*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(X13=\"Non-Clinical\",IF($E13=\"Yes\",IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ13*Assumptions!$D$8),IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ13-Assumptions!$D$18)*Assumptions!$D$13),AJ13*Assumptions!$D$6)),IF($E13=\"Yes\",IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ13*Assumptions!$D$8),IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ13-Assumptions!$D$18)*Assumptions!$D$14),AJ13*Assumptions!$D$7)))","v":0},{"$f":"IF(Y13=\"Non-Clinical\",IF($E13=\"Yes\",IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*0),AJ13*0),IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ13-Assumptions!$D$18)*0),AJ13*(Assumptions!$D$9+Assumptions!$D$10))),IF($E13=\"Yes\",IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*0),AJ13*0),IF(AJ13>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ13-Assumptions!$D$18)*0),AJ13*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(G13>0,(G13/#REF!)*H13,\" \")","v":" "},{"$f":"IF(G13>0,(G13/#REF!)*W13,\" \")","v":" "},0]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D14=\"Non-Clinical\",IF($E14=\"Yes\",IF(H14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H14*Assumptions!$D$8),IF(H14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H14-Assumptions!$D$18)*Assumptions!$D$13),H14*Assumptions!$D$6)),IF($E14=\"Yes\",IF(H14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H14*Assumptions!$D$8),IF(H14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H14-Assumptions!$D$18)*Assumptions!$D$14),H14*Assumptions!$D$7)))","v":0},{"$f":"IF(E14=\"Non-Clinical\",IF($E14=\"Yes\",IF(H14>Assumptions!$D$18,(Assumptions!$D$18*0),H14*0),IF(H14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H14-Assumptions!$D$18)*0),H14*(Assumptions!$D$9+Assumptions!$D$10))),IF($E14=\"Yes\",IF(H14>Assumptions!$D$18,(Assumptions!$D$18*0),H14*0),IF(H14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H14-Assumptions!$D$18)*0),H14*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(J14=\"Non-Clinical\",IF($E14=\"Yes\",IF(V14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V14*Assumptions!$D$8),IF(V14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V14-Assumptions!$D$18)*Assumptions!$D$13),V14*Assumptions!$D$6)),IF($E14=\"Yes\",IF(V14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V14*Assumptions!$D$8),IF(V14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V14-Assumptions!$D$18)*Assumptions!$D$14),V14*Assumptions!$D$7)))","v":0},{"$f":"IF(K14=\"Non-Clinical\",IF($E14=\"Yes\",IF(V14>Assumptions!$D$18,(Assumptions!$D$18*0),V14*0),IF(V14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V14-Assumptions!$D$18)*0),V14*(Assumptions!$D$9+Assumptions!$D$10))),IF($E14=\"Yes\",IF(V14>Assumptions!$D$18,(Assumptions!$D$18*0),V14*0),IF(V14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V14-Assumptions!$D$18)*0),V14*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(X14=\"Non-Clinical\",IF($E14=\"Yes\",IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ14*Assumptions!$D$8),IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ14-Assumptions!$D$18)*Assumptions!$D$13),AJ14*Assumptions!$D$6)),IF($E14=\"Yes\",IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ14*Assumptions!$D$8),IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ14-Assumptions!$D$18)*Assumptions!$D$14),AJ14*Assumptions!$D$7)))","v":0},{"$f":"IF(Y14=\"Non-Clinical\",IF($E14=\"Yes\",IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*0),AJ14*0),IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ14-Assumptions!$D$18)*0),AJ14*(Assumptions!$D$9+Assumptions!$D$10))),IF($E14=\"Yes\",IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*0),AJ14*0),IF(AJ14>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ14-Assumptions!$D$18)*0),AJ14*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(G14>0,(G14/#REF!)*H14,\" \")","v":" "},{"$f":"IF(G14>0,(G14/#REF!)*W14,\" \")","v":" "},0]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D15=\"Non-Clinical\",IF($E15=\"Yes\",IF(H15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H15*Assumptions!$D$8),IF(H15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H15-Assumptions!$D$18)*Assumptions!$D$13),H15*Assumptions!$D$6)),IF($E15=\"Yes\",IF(H15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H15*Assumptions!$D$8),IF(H15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H15-Assumptions!$D$18)*Assumptions!$D$14),H15*Assumptions!$D$7)))","v":0},{"$f":"IF(E15=\"Non-Clinical\",IF($E15=\"Yes\",IF(H15>Assumptions!$D$18,(Assumptions!$D$18*0),H15*0),IF(H15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H15-Assumptions!$D$18)*0),H15*(Assumptions!$D$9+Assumptions!$D$10))),IF($E15=\"Yes\",IF(H15>Assumptions!$D$18,(Assumptions!$D$18*0),H15*0),IF(H15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H15-Assumptions!$D$18)*0),H15*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(J15=\"Non-Clinical\",IF($E15=\"Yes\",IF(V15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V15*Assumptions!$D$8),IF(V15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V15-Assumptions!$D$18)*Assumptions!$D$13),V15*Assumptions!$D$6)),IF($E15=\"Yes\",IF(V15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V15*Assumptions!$D$8),IF(V15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V15-Assumptions!$D$18)*Assumptions!$D$14),V15*Assumptions!$D$7)))","v":0},{"$f":"IF(K15=\"Non-Clinical\",IF($E15=\"Yes\",IF(V15>Assumptions!$D$18,(Assumptions!$D$18*0),V15*0),IF(V15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V15-Assumptions!$D$18)*0),V15*(Assumptions!$D$9+Assumptions!$D$10))),IF($E15=\"Yes\",IF(V15>Assumptions!$D$18,(Assumptions!$D$18*0),V15*0),IF(V15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V15-Assumptions!$D$18)*0),V15*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(X15=\"Non-Clinical\",IF($E15=\"Yes\",IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ15*Assumptions!$D$8),IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ15-Assumptions!$D$18)*Assumptions!$D$13),AJ15*Assumptions!$D$6)),IF($E15=\"Yes\",IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ15*Assumptions!$D$8),IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ15-Assumptions!$D$18)*Assumptions!$D$14),AJ15*Assumptions!$D$7)))","v":0},{"$f":"IF(Y15=\"Non-Clinical\",IF($E15=\"Yes\",IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*0),AJ15*0),IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ15-Assumptions!$D$18)*0),AJ15*(Assumptions!$D$9+Assumptions!$D$10))),IF($E15=\"Yes\",IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*0),AJ15*0),IF(AJ15>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ15-Assumptions!$D$18)*0),AJ15*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(G15>0,(G15/#REF!)*H15,\" \")","v":" "},{"$f":"IF(G15>0,(G15/#REF!)*W15,\" \")","v":" "},0]
[null,null,null,"Clinical","No",null,null,null,{"$f":"IF(D16=\"Non-Clinical\",IF($E16=\"Yes\",IF(H16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H16*Assumptions!$D$8),IF(H16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!H16-Assumptions!$D$18)*Assumptions!$D$13),H16*Assumptions!$D$6)),IF($E16=\"Yes\",IF(H16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),H16*Assumptions!$D$8),IF(H16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!H16-Assumptions!$D$18)*Assumptions!$D$14),H16*Assumptions!$D$7)))","v":0},{"$f":"IF(E16=\"Non-Clinical\",IF($E16=\"Yes\",IF(H16>Assumptions!$D$18,(Assumptions!$D$18*0),H16*0),IF(H16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H16-Assumptions!$D$18)*0),H16*(Assumptions!$D$9+Assumptions!$D$10))),IF($E16=\"Yes\",IF(H16>Assumptions!$D$18,(Assumptions!$D$18*0),H16*0),IF(H16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!H16-Assumptions!$D$18)*0),H16*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(J16=\"Non-Clinical\",IF($E16=\"Yes\",IF(V16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V16*Assumptions!$D$8),IF(V16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!V16-Assumptions!$D$18)*Assumptions!$D$13),V16*Assumptions!$D$6)),IF($E16=\"Yes\",IF(V16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),V16*Assumptions!$D$8),IF(V16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!V16-Assumptions!$D$18)*Assumptions!$D$14),V16*Assumptions!$D$7)))","v":0},{"$f":"IF(K16=\"Non-Clinical\",IF($E16=\"Yes\",IF(V16>Assumptions!$D$18,(Assumptions!$D$18*0),V16*0),IF(V16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V16-Assumptions!$D$18)*0),V16*(Assumptions!$D$9+Assumptions!$D$10))),IF($E16=\"Yes\",IF(V16>Assumptions!$D$18,(Assumptions!$D$18*0),V16*0),IF(V16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!V16-Assumptions!$D$18)*0),V16*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF(X16=\"Non-Clinical\",IF($E16=\"Yes\",IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ16*Assumptions!$D$8),IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$6)+(('Salary Build Sheet (Clinical)'!AJ16-Assumptions!$D$18)*Assumptions!$D$13),AJ16*Assumptions!$D$6)),IF($E16=\"Yes\",IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$8),AJ16*Assumptions!$D$8),IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*Assumptions!$D$7)+(('Salary Build Sheet (Clinical)'!AJ16-Assumptions!$D$18)*Assumptions!$D$14),AJ16*Assumptions!$D$7)))","v":0},{"$f":"IF(Y16=\"Non-Clinical\",IF($E16=\"Yes\",IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*0),AJ16*0),IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ16-Assumptions!$D$18)*0),AJ16*(Assumptions!$D$9+Assumptions!$D$10))),IF($E16=\"Yes\",IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*0),AJ16*0),IF(AJ16>Assumptions!$D$18,(Assumptions!$D$18*(Assumptions!$D$9+Assumptions!$D$10))+(('Salary Build Sheet (Clinical)'!AJ16-Assumptions!$D$18)*0),AJ16*(Assumptions!$D$9+Assumptions!$D$10))))","v":0},0,0,0,0,0,0,0,0,0,0,null,null,{"$f":"IF(G16>0,(G16/#REF!)*H16,\" \")","v":" "},{"$f":"IF(G16>0,(G16/#REF!)*W16,\" \")","v":" "},0]
[null,"Total Faculty Staffing ",{"$nulls":4},{"$f":"SUM(G10:G16)","v":0},0,0,{"$f":"SUM(J10:J16)","v":0},{"$f":"SUM(K10:K16)","v":0},{"$f":"SUM(L10:L16)","v":0},{"$f":"SUM(M10:M16)","v":0},0,0,0,0,0,0,0,null,0,{"$f":"SUM(W10:W16)","v":0},{"$f":"SUM(X10:X16)","v":0},{"$f":"SUM(Y10:Y16)","v":0},{"$f":"SUM(Z10:Z16)","v":0},{"$f":"SUM(AA10:AA16)","v":0},{"$f":"SUM(AB10:AB16)","v":0},{"$f":"SUM(AC10:AC16)","v":0},{"$f":"SUM(AD10:AD16)","v":0},{"$f":"SUM(AE10:AE16)","v":0},{"$f":"SUM(AF10:AF16)","v":0},{"$f":"SUM(AG10:AG16)","v":0},{"$f":"SUM(AH10:AH16)","v":0},null,{"$f":"SUM(AJ10:AJ16)","v":0},{"$f":"SUM(AK10:AK16)","v":0},{"$f":"SUM(AL10:AL16)","v":0},{"$f":"SUM(AM10:AM16)","v":0},{"$f":"SUM(AN10:AN16)","v":0},{"$f":"SUM(AO10:AO16)","v":0},{"$f":"SUM(AP10:AP16)","v":0},{"$f":"SUM(AQ10:AQ16)","v":0},{"$f":"SUM(AR10:AR16)","v":0},{"$f":"SUM(AS10:AS16)","v":0},{"$f":"SUM(AT10:AT16)","v":0},{"$f":"SUM(AU10:AU16)","v":0},{"$f":"SUM(AV10:AV16)","v":0},null,null,{"$f":"SUM(AY10:AY16)","v":0},{"$f":"SUM(AZ10:AZ16)","v":0},{"$f":"SUM(BA10:BA16)","v":0}]
[null,"Physician Incentive"]
[null,null,"One-Time Incentive ",{"$nulls":5},{"$f":"H19*Assumptions!$D$13","v":0},0,{"$f":"I19+H19+J19","v":0},{"$f":"H19","v":0},{"$f":"I19","v":0},{"$f":"J19","v":0},{"$f":"SUM(L19:N19)","v":0},{"$nulls":7},{"$f":"V19*Assumptions!$D$13","v":0},0,{"$f":"W19+V19+X19","v":0},{"$f":"V19","v":0},{"$f":"W19","v":0},{"$f":"X19","v":0},{"$f":"SUM(Z19:AB19)","v":0},{"$nulls":7},{"$f":"AJ19*Assumptions!$D$13","v":0},0,{"$f":"AK19+AJ19+AL19","v":0},{"$f":"AJ19","v":0},{"$f":"AK19","v":0},{"$f":"AL19","v":0},{"$f":"SUM(AN19:AP19)","v":0},{"$nulls":4},{"$f":"AM19+Y19+K19","v":0}]
[null,null,"Ongoing Incentive ",{"$nulls":5},{"$f":"H20*Assumptions!$D$13","v":0},0,0,{"$f":"H20","v":0},{"$f":"I20","v":0},{"$f":"J20","v":0},0,{"$nulls":7},{"$f":"V20*Assumptions!$D$13","v":0},0,0,{"$f":"V20","v":0},{"$f":"W20","v":0},{"$f":"X20","v":0},0,{"$nulls":7},{"$f":"AJ20*Assumptions!$D$13","v":0},0,0,{"$f":"AJ20","v":0},{"$f":"AK20","v":0},{"$f":"AL20","v":0},0,{"$nulls":4},0]
[null,null,"Moving/Relocation Bonus",{"$nulls":5},{"$f":"H21*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"V21*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"AJ21*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":4},0]
[null,null,"YNHH Metric-Based",{"$nulls":5},{"$f":"H22*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"V22*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"AJ22*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":4},0]
[null,null,"YNHH Not Metric-Based",{"$nulls":5},{"$f":"H23*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"V23*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":7},{"$f":"AJ23*Assumptions!$D$13","v":0},0,0,0,0,0,0,{"$nulls":4},0]
[null,"Physician Incentives Subtotal",{"$nulls":4},{"$f":"SUM(G18:G23)","v":0},{"$f":"SUM(H18:H23)","v":0},{"$f":"SUM(I18:I23)","v":0},{"$f":"SUM(J18:J23)","v":0},{"$f":"SUM(K18:K23)","v":0},{"$f":"SUM(L18:L23)","v":0},0,0,{"$f":"SUM(O18:O23)","v":0},{"$f":"SUM(P18:P23)","v":0},{"$f":"SUM(Q18:Q23)","v":0},{"$f":"SUM(R18:R23)","v":0},{"$f":"SUM(S18:S23)","v":0},{"$f":"SUM(T18:T23)","v":0},null,{"$f":"SUM(V18:V23)","v":0},0,{"$f":"SUM(X18:X23)","v":0},{"$f":"SUM(Y18:Y23)","v":0},{"$f":"SUM(Z18:Z23)","v":0},{"$f":"SUM(AA18:AA23)","v":0},{"$f":"SUM(AB18:AB23)","v":0},{"$f":"SUM(AC18:AC23)","v":0},{"$f":"SUM(AD18:AD23)","v":0},{"$f":"SUM(AE18:AE23)","v":0},{"$f":"SUM(AF18:AF23)","v":0},{"$f":"SUM(AG18:AG23)","v":0},0,null,0,{"$f":"SUM(AK18:AK23)","v":0},{"$f":"SUM(AL18:AL23)","v":0},{"$f":"SUM(AM18:AM23)","v":0},{"$f":"SUM(AN18:AN23)","v":0},{"$f":"SUM(AO18:AO23)","v":0},{"$f":"SUM(AP18:AP23)","v":0},{"$f":"SUM(AQ18:AQ23)","v":0},{"$f":"SUM(AR18:AR23)","v":0},{"$f":"SUM(AS18:AS23)","v":0},{"$f":"SUM(AT18:AT23)","v":0},{"$f":"SUM(AU18:AU23)","v":0},0]
[null,"Total Faculty Salaries",{"$nulls":4},{"$f":"G17","v":0},{"$f":"H24+H17","v":0},{"$f":"I24+I17","v":0},{"$f":"J24+J17","v":0},0,{"$f":"L24+L17","v":0},0,0,{"$f":"O24+O17","v":0},{"$f":"P24+P17","v":0},0,0,0,{"$f":"T17","v":0},null,{"$f":"V24+V17","v":0},0,0,0,0,0,0,{"$f":"AC24+AC17","v":0},{"$f":"AD24+AD17","v":0},0,0,0,{"$f":"AH17","v":0},null,{"$f":"AJ24+AJ17","v":0},0,0,0,0,0,0,{"$f":"AQ24+AQ17","v":0},{"$f":"AR24+AR17","v":0},0,0,0,{"$f":"AV24+AV17","v":0}]
[null,"M&P Staffing"]
[{"$nulls":8},{"$f":"IF($E27=\"Yes\",H27*Assumptions!$D$8,H27*Assumptions!$D$6)","v":0},{"$f":"IF($E27=\"Yes\",H27*0,H27*(Assumptions!$D$9))","v":0},{"$f":"I27+H27+J27","v":0},{"$f":"H27*F27","v":0},{"$f":"I27*F27","v":0},{"$f":"J27*F27","v":0},{"$f":"SUM(L27:N27)","v":0},{"$f":"H27*G27","v":0},{"$f":"I27*G27","v":0},{"$f":"J27*G27","v":0},{"$f":"SUM(P27:R27)","v":0},null,null,null,{"$f":"IF($E27=\"Yes\",V27*Assumptions!$D$8,V27*Assumptions!$D$6)","v":0},{"$f":"IF($E27=\"Yes\",V27*0,V27*(Assumptions!$D$9))","v":0},{"$f":"W27+V27+X27","v":0},{"$f":"V27*T27","v":0},{"$f":"W27*T27","v":0},{"$f":"X27*T27","v":0},{"$f":"SUM(Z27:AB27)","v":0},{"$f":"V27*U27","v":0},{"$f":"W27*U27","v":0},{"$f":"X27*U27","v":0},{"$f":"SUM(AD27:AF27)","v":0},null,null,null,{"$f":"IF($E27=\"Yes\",AJ27*Assumptions!$D$8,AJ27*Assumptions!$D$6)","v":0},{"$f":"IF($E27=\"Yes\",AJ27*0,AJ27*(Assumptions!$D$9))","v":0},{"$f":"AK27+AJ27+AL27","v":0},{"$f":"AJ27*AH27","v":0},{"$f":"AK27*AH27","v":0},{"$f":"AL27*AH27","v":0},{"$f":"SUM(AN27:AP27)","v":0},{"$f":"AJ27*AI27","v":0},{"$f":"AK27*AI27","v":0},{"$f":"AL27*AI27","v":0},{"$f":"SUM(AR27:AT27)","v":0},{"$f":"AM27+Y27+K27","v":0}]
[{"$nulls":8},{"$f":"IF($E28=\"Yes\",H28*Assumptions!$D$8,H28*Assumptions!$D$6)","v":0},{"$f":"IF($E28=\"Yes\",H28*0,H28*(Assumptions!$D$9))","v":0},0,{"$f":"H28*F28","v":0},{"$f":"I28*F28","v":0},{"$f":"J28*F28","v":0},{"$f":"SUM(L28:N28)","v":0},{"$f":"H28*G28","v":0},{"$f":"I28*G28","v":0},{"$f":"J28*G28","v":0},{"$f":"SUM(P28:R28)","v":0},null,null,null,{"$f":"IF($E28=\"Yes\",V28*Assumptions!$D$8,V28*Assumptions!$D$6)","v":0},{"$f":"IF($E28=\"Yes\",V28*0,V28*(Assumptions!$D$9))","v":0},0,{"$f":"V28*T28","v":0},{"$f":"W28*T28","v":0},{"$f":"X28*T28","v":0},{"$f":"SUM(Z28:AB28)","v":0},{"$f":"V28*U28","v":0},{"$f":"W28*U28","v":0},{"$f":"X28*U28","v":0},{"$f":"SUM(AD28:AF28)","v":0},null,null,null,{"$f":"IF($E28=\"Yes\",AJ28*Assumptions!$D$8,AJ28*Assumptions!$D$6)","v":0},{"$f":"IF($E28=\"Yes\",AJ28*0,AJ28*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E29=\"Yes\",H29*Assumptions!$D$8,H29*Assumptions!$D$6)","v":0},{"$f":"IF($E29=\"Yes\",H29*0,H29*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E29=\"Yes\",V29*Assumptions!$D$8,V29*Assumptions!$D$6)","v":0},{"$f":"IF($E29=\"Yes\",V29*0,V29*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E29=\"Yes\",AJ29*Assumptions!$D$8,AJ29*Assumptions!$D$6)","v":0},{"$f":"IF($E29=\"Yes\",AJ29*0,AJ29*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E30=\"Yes\",H30*Assumptions!$D$8,H30*Assumptions!$D$6)","v":0},{"$f":"IF($E30=\"Yes\",H30*0,H30*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E30=\"Yes\",V30*Assumptions!$D$8,V30*Assumptions!$D$6)","v":0},{"$f":"IF($E30=\"Yes\",V30*0,V30*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E30=\"Yes\",AJ30*Assumptions!$D$8,AJ30*Assumptions!$D$6)","v":0},{"$f":"IF($E30=\"Yes\",AJ30*0,AJ30*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E31=\"Yes\",H31*Assumptions!$D$8,H31*Assumptions!$D$6)","v":0},{"$f":"IF($E31=\"Yes\",H31*0,H31*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E31=\"Yes\",V31*Assumptions!$D$8,V31*Assumptions!$D$6)","v":0},{"$f":"IF($E31=\"Yes\",V31*0,V31*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E31=\"Yes\",AJ31*Assumptions!$D$8,AJ31*Assumptions!$D$6)","v":0},{"$f":"IF($E31=\"Yes\",AJ31*0,AJ31*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E32=\"Yes\",H32*Assumptions!$D$8,H32*Assumptions!$D$6)","v":0},{"$f":"IF($E32=\"Yes\",H32*0,H32*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E32=\"Yes\",V32*Assumptions!$D$8,V32*Assumptions!$D$6)","v":0},{"$f":"IF($E32=\"Yes\",V32*0,V32*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E32=\"Yes\",AJ32*Assumptions!$D$8,AJ32*Assumptions!$D$6)","v":0},{"$f":"IF($E32=\"Yes\",AJ32*0,AJ32*(Assumptions!$D$9))","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total M&P Staffing",null,null,null,{"$f":"SUM(F27:F32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(V27:V32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"SUM(AJ27:AJ32)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"C&T Staffing"]
[{"$nulls":8},{"$f":"IF($E35=\"Yes\",H35*Assumptions!$D$12,H35*Assumptions!$D$11)","v":0},0,{"$f":"I35+H35+J35","v":0},{"$f":"H35*F35","v":0},{"$f":"I35*F35","v":0},{"$f":"J35*F35","v":0},{"$f":"SUM(L35:N35)","v":0},{"$f":"H35*G35","v":0},{"$f":"I35*G35","v":0},{"$f":"J35*G35","v":0},{"$f":"SUM(P35:R35)","v":0},null,null,null,{"$f":"IF($E35=\"Yes\",V35*Assumptions!$D$12,V35*Assumptions!$D$11)","v":0},0,{"$f":"W35+V35+X35","v":0},{"$f":"V35*T35","v":0},{"$f":"W35*T35","v":0},{"$f":"X35*T35","v":0},{"$f":"SUM(Z35:AB35)","v":0},{"$f":"V35*U35","v":0},{"$f":"W35*U35","v":0},{"$f":"X35*U35","v":0},{"$f":"SUM(AD35:AF35)","v":0},null,null,null,{"$f":"IF($E35=\"Yes\",AJ35*Assumptions!$D$12,AJ35*Assumptions!$D$11)","v":0},0,{"$f":"AK35+AJ35+AL35","v":0},{"$f":"AJ35*AH35","v":0},{"$f":"AK35*AH35","v":0},{"$f":"AL35*AH35","v":0},{"$f":"SUM(AN35:AP35)","v":0},{"$f":"AJ35*AI35","v":0},{"$f":"AK35*AI35","v":0},{"$f":"AL35*AI35","v":0},{"$f":"SUM(AR35:AT35)","v":0},{"$f":"AM35+Y35+K35","v":0}]
[{"$nulls":8},{"$f":"IF($E36=\"Yes\",H36*Assumptions!$D$12,H36*Assumptions!$D$11)","v":0},0,0,0,0,0,0,{"$f":"H36*G36","v":0},0,0,0,null,null,null,{"$f":"IF($E36=\"Yes\",V36*Assumptions!$D$12,V36*Assumptions!$D$11)","v":0},0,0,0,0,0,0,{"$f":"V36*U36","v":0},0,0,0,null,null,null,{"$f":"IF($E36=\"Yes\",AJ36*Assumptions!$D$12,AJ36*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E37=\"Yes\",H37*Assumptions!$D$12,H37*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E37=\"Yes\",V37*Assumptions!$D$12,V37*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E37=\"Yes\",AJ37*Assumptions!$D$12,AJ37*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E38=\"Yes\",H38*Assumptions!$D$12,H38*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E38=\"Yes\",V38*Assumptions!$D$12,V38*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E38=\"Yes\",AJ38*Assumptions!$D$12,AJ38*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E39=\"Yes\",H39*Assumptions!$D$12,H39*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E39=\"Yes\",V39*Assumptions!$D$12,V39*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E39=\"Yes\",AJ39*Assumptions!$D$12,AJ39*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Total C&T Staffing",null,null,null,{"$f":"SUM(F35:F39)","v":0},{"$f":"SUM(G35:G39)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"YM CARE Staff (C&T)"]
[{"$nulls":8},{"$f":"IF($E42=\"Yes\",H42*Assumptions!$D$12,H42*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E42=\"Yes\",V42*Assumptions!$D$12,V42*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E42=\"Yes\",AJ42*Assumptions!$D$12,AJ42*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E43=\"Yes\",H43*Assumptions!$D$12,H43*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E43=\"Yes\",V43*Assumptions!$D$12,V43*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E43=\"Yes\",AJ43*Assumptions!$D$12,AJ43*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":8},{"$f":"IF($E44=\"Yes\",H44*Assumptions!$D$12,H44*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E44=\"Yes\",V44*Assumptions!$D$12,V44*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"IF($E44=\"Yes\",AJ44*Assumptions!$D$12,AJ44*Assumptions!$D$11)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,"Total YM CARE Staffing",null,null,null,{"$f":"SUM(F42:F44)","v":0},{"$f":"SUM(G42:G44)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Overtime (if applicable)",null,null,"No",null,null,null,{"$f":"IF($E46=\"Yes\",H46*Assumptions!$D$12,H46*Assumptions!$D$11)","v":0},0,{"$f":"I46+H46+J46","v":0},{"$f":"H46","v":0},{"$f":"I46","v":0},0,0,{"$nulls":7},{"$f":"IF($E46=\"Yes\",V46*Assumptions!$D$12,V46*Assumptions!$D$11)","v":0},0,{"$f":"W46+V46+X46","v":0},{"$f":"V46","v":0},{"$f":"W46","v":0},0,{"$f":"SUM(Z46:AB46)","v":0},{"$nulls":7},{"$f":"IF($E46=\"Yes\",AJ46*Assumptions!$D$12,AJ46*Assumptions!$D$11)","v":0},0,{"$f":"AK46+AJ46+AL46","v":0},{"$f":"AJ46","v":0},{"$f":"AK46","v":0},0,{"$f":"SUM(AN46:AP46)","v":0},{"$nulls":4},{"$f":"SUM(H46:W46)","v":0}]
[null,"Total Support Staff Costs",null,null,null,{"$f":"F45+F33+F40","v":0},{"$f":"G45+G33+G40","v":0},{"$f":"H45+H33+H40","v":0},0,{"$f":"J45+J33+J40","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"U45+U33+U40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AH45+AH33+AH40","v":0},{"$f":"AI45+AI33+AI40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Grand Total Staffing",null,null,null,{"$f":"F47+F25","v":0},{"$f":"G47+G25","v":0},{"$f":"H47+H25","v":0},{"$f":"I47+I25","v":0},{"$f":"J47+J25","v":0},{"$f":"K47+K25","v":0},0,0,0,{"$f":"O47+O25","v":0},0,0,0,{"$f":"S47+S25","v":0},0,{"$f":"U47+U25","v":0},0,{"$f":"W47+W25","v":0},0,0,0,0,0,{"$f":"AC47+AC25","v":0},{"$f":"AD47+AD25","v":0},0,0,{"$f":"AG47+AG25","v":0},{"$f":"AH47+AH25","v":0},{"$f":"AI47+AI25","v":0},{"$f":"AJ47+AJ25","v":0},{"$f":"AK47+AK25","v":0},0,0,0,0,0,{"$f":"AQ47+AQ25","v":0},{"$f":"AR47+AR25","v":0},0,0,{"$f":"AU47+AU25","v":0},{"$f":"AV47+AV25","v":0}]

{"sheet":"Non-Salary Build (Clinical)","index":5,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,"Non-Salary Build Plan"]
[]
[null,null,"Year One","Year Two","Year Three","Cumulative",null,"Non-Salary"]
[null,"Type of Position/Name","Total ","Total ","Total ","Costs",null,"Notes"]
[null,"Space/Sessions"]
[null,"Space ",null,null,null,{"$f":"SUM(C10:E10)","v":0},null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[null,"I&A",null,null,null,{"$f":"SUM(C11:E11)","v":0},null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[null,"Insert as necessary",null,null,null,0,null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[{"$nulls":5},0,null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[{"$nulls":5},0,null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[{"$nulls":5},0,null,null,{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}},{"$f":"IF(#REF!>0,(#REF!/#REF!)*#REF!,\" \")","v":{"$error":"#REF!"}}]
[null,"Total Space/Sessions",{"$f":"SUM(C10:C15)","v":0},{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0},{"$f":"SUM(F10:F15)","v":0},null,null,{"$f":"SUM(I10:I15)","v":{"$error":"#REF!"}},{"$f":"SUM(J10:J15)","v":{"$error":"#REF!"}}]
[null,"Malpractice",null,null,null,0]
[null,"Insert as necessary",null,null,null,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Malpractice Total",{"$f":"SUM(C17:C20)","v":0},{"$f":"SUM(D17:D20)","v":0},{"$f":"SUM(E17:E20)","v":0},{"$f":"E21+D21+C21","v":0}]
[null,"Medical/Surgical Supplies"]
[null,"Insert as necessary",null,null,null,{"$f":"SUM(C23:E23)","v":0}]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Medical/Surgical Supplies Total",{"$f":"SUM(C23:C25)","v":0},{"$f":"SUM(D23:D25)","v":0},{"$f":"SUM(E23:E25)","v":0},{"$f":"SUM(F23:F25)","v":0}]
[null,"Other Applicable Costs"]
[null,"ITS",null,null,null,{"$f":"E28+D28+C28","v":0}]
[null,"Telcom",null,null,null,0]
[null,"Computers",null,null,null,0]
[null,"Office/General Supplies",null,null,null,0]
[null,"Travel",null,null,null,0]
[null,"Uniforms",null,null,null,0]
[null,"Insert as necessary",null,null,null,0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[{"$nulls":5},0]
[null,"Other Applicable Costs Total",{"$f":"SUM(C28:C37)","v":0},{"$f":"SUM(D28:D37)","v":0},{"$f":"SUM(E28:E37)","v":0},{"$f":"SUM(F28:F37)","v":0}]
[null,"Grand Total Non-Salary Costs",{"$f":"C38+C26+C21+C16","v":0},{"$f":"D38+D26+D21+D16","v":0},{"$f":"E38+E26+E21+E16","v":0},{"$f":"F38+F26+F21+F16","v":0}]
[null,"1) Please adjust for FTE. "]

{"sheet":"Research Plan","index":6,"n_rows":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":false,"merged":[[2,2,2,8],[2,10,2,16],[2,18,2,24],[40,2,40,8],[41,2,41,8]]}
[null,"Research Mission Business Plan"]
[]
[null,null,"Year 1",{"$nulls":7},"Year 2",{"$nulls":7},"Year 3"]
[null,null,"Grants &\nContracts","Gifts/\nEndowment","Dept-Funded\n(YD)","Dean-Funded\n(APS)","VA","Other\n(please specify)","Total",null,"Grants &\nContracts","Gifts/\nEndowment","Dept-Funded\n(YD)","Dean-Funded\n(APS)","VA","Other\n(please specify)","Total",null,"Grants &\nContracts","Gifts/\nEndowment","Dept-Funded\n(YD)","Dean-Funded\n(APS)","VA","Other\n(please specify)","Total",null,"Grand Total"]
[null,"Revenue:"]
[null,"Grant Directs",0,0,0,0,0,0,{"$f":"SUM(C6:H6)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(K6:P6)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(S6:X6)","v":0},null,{"$f":"I6+Q6+Y6","v":0}]
[null,"Grant Indirects",0,0,0,0,0,0,{"$f":"SUM(C7:H7)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(K7:P7)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(S7:X7)","v":0},null,{"$f":"I7+Q7+Y7","v":0}]
[{"$f":"'YSM-YM Clinical Plan'!$B$39","v":0.23080000000000001},"Clinical Drug Trials",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,{"$f":"I8+Q8+Y8","v":0}]
[0.12,"Spendable Gifts",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"Endowment Income",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"VA Funding",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[{"$f":"'YSM-YM Clinical Plan'!$B$36","v":0.11700000000000001},"YNHHS and Other Clinical Contracts",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"Academic Program Support (APS)",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"Other Revenue (please specify)",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"Revenue Grand Total",{"$f":"SUM(C6:C14)","v":0},{"$f":"SUM(D6:D14)","v":0},0,0,0,0,{"$f":"SUM(C15:H15)","v":0},null,{"$f":"SUM(K6:K14)","v":0},{"$f":"SUM(L6:L14)","v":0},0,0,0,0,0,null,{"$f":"SUM(S6:S14)","v":0},{"$f":"SUM(T6:T14)","v":0},0,0,0,0,0,null,0]
[]
[null,"Expenses:"]
[null,"Faculty Salary: direct charge",0,0,0,0,0,0,{"$f":"SUM(C18:H18)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(K18:P18)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(S18:X18)","v":0},null,{"$f":"I18+Q18+Y18","v":0}]
["DHHS/NIH Cap","Faculty Salary: cost share","n/a",0,0,0,0,0,0,null,"n/a",0,0,0,0,0,0,null,"n/a",0,0,0,0,0,0,null,0]
[null,"Faculty Fringe rate",{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315},null,null,{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315},null,null,{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$6","v":0.315},{"$f":"Assumptions!$D$8","v":0.307},{"$f":"Assumptions!$D$6","v":0.315}]
[null,"Faculty Fringe $",{"$f":"C18*C20","v":0},{"$f":"(D18+D19)*D20","v":0},0,0,0,0,0,null,{"$f":"K18*K20","v":0},{"$f":"(L18+L19)*L20","v":0},0,0,0,0,0,null,{"$f":"S18*S20","v":0},{"$f":"(T18+T19)*T20","v":0},0,0,0,0,0,null,{"$f":"I21+Q21+Y21","v":0}]
[null,"Total Faculty Cost",{"$f":"C18+C21","v":0},{"$f":"D18+D19+D21","v":0},0,0,0,0,0,null,{"$f":"K18+K21","v":0},{"$f":"L18+L19+L21","v":0},0,0,0,0,0,null,{"$f":"S18+S21","v":0},{"$f":"T18+T19+T21","v":0},0,0,0,0,0,null,0]
[]
[null,"Postdoc/Staff Salary",0,0,0,0,0,0,{"$f":"SUM(C24:H24)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(K24:P24)","v":0},null,0,0,0,0,0,0,{"$f":"SUM(S24:X24)","v":0},null,{"$f":"I24+Q24+Y24","v":0}]
[null,"Postdoc/Staff Salary - Fringe",0,0,0,0,0,0,0,null,0,0,0,0,0,0,{"$f":"SUM(K25:P25)","v":0},null,0,0,0,0,0,0,0,null,0]
[null,"Non-Salary Expenses",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[null,"Equipment",0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0,0,0,null,0]
[{"$f":"A8","v":0.23080000000000001},"Clinical Trial Assessment",{"$f":"$A8*C8","v":0},{"$f":"$A8*D8","v":0},0,0,0,0,0,null,{"$f":"$A8*K8","v":0},{"$f":"$A8*L8","v":0},0,0,0,0,0,null,{"$f":"$A8*S8","v":0},{"$f":"$A8*T8","v":0},0,0,0,0,0,null,0]
[{"$f":"A9","v":0.12},"Gift Assessment",{"$f":"$A9*C9","v":0},0,0,0,0,0,0,null,{"$f":"$A9*K9","v":0},0,0,0,0,0,0,null,{"$f":"$A9*S9","v":0},0,0,0,0,0,0,null,0]
[{"$f":"A12","v":0.11700000000000001},"YNHHS Assessment",{"$f":"$A12*C12","v":0},{"$f":"$A12*D12","v":0},0,0,0,0,0,null,{"$f":"$A12*K12","v":0},{"$f":"$A12*L12","v":0},0,0,0,0,0,null,{"$f":"$A12*S12","v":0},{"$f":"$A12*T12","v":0},0,0,0,0,0,null,0]
[{"$f":"Assumptions!$D$9-A32","v":8.5999999999999993E-2},"Supplemental Fringe","n/a",{"$f":"$A31*(D$18+D$19)","v":0},{"$f":"$A31*(E$18+E$19)","v":0},0,"n/a",0,0,null,"n/a",{"$f":"$A31*(L$18+L$19)","v":0},{"$f":"$A31*(M$18+M$19)","v":0},0,"n/a",0,0,null,"n/a",{"$f":"$A31*(T$18+T$19)","v":0},{"$f":"$A31*(U$18+U$19)","v":0},0,"n/a",0,0,null,0]
[0.03,"YSM Sabbatical","n/a",{"$f":"$A32*(D$18+D$19)","v":0},0,0,"n/a",0,0,null,"n/a",{"$f":"$A32*(L$18+L$19)","v":0},0,0,"n/a",0,0,null,"n/a",{"$f":"$A32*(T$18+T$19)","v":0},0,0,"n/a",0,0,null,0]
[null,"Applicable Assessments from above",{"$f":"SUM(C28:C32)","v":0},{"$f":"SUM(D28:D32)","v":0},0,0,0,0,0,null,{"$f":"SUM(K28:K32)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(S28:S32)","v":0},0,0,0,0,0,0,null,0]
[null,"Grant Indirects",{"$f":"C7","v":0},{"$f":"D7","v":0},0,0,0,0,0,null,{"$f":"K7","v":0},{"$f":"L7","v":0},0,0,0,0,0,null,{"$f":"S7","v":0},{"$f":"T7","v":0},0,0,0,0,0,null,0]
[]
[null,"Expense Grand Total",{"$f":"SUM(C22:C32)+C34","v":0},{"$f":"SUM(D22:D32)+D34","v":0},0,0,0,0,0,null,{"$f":"SUM(K22:K32)+K34","v":0},{"$f":"SUM(L22:L32)+L34","v":0},0,0,0,0,0,null,{"$f":"SUM(S22:S32)+S34","v":0},{"$f":"SUM(T22:T32)+T34","v":0},0,0,0,0,0,null,{"$f":"I36+Q36+Y36","v":0}]
[]
[null,"Total Net Income",{"$f":"C15-C36","v":0},{"$f":"D15-D36","v":0},0,0,0,0,{"$f":"SUM(C38:H38)","v":0},null,{"$f":"K15-K36","v":0},{"$f":"L15-L36","v":0},0,0,0,0,{"$f":"SUM(K38:P38)","v":0},null,{"$f":"S15-S36","v":0},{"$f":"T15-T36","v":0},0,0,0,0,{"$f":"SUM(S38:X38)","v":0},null,{"$f":"I38+Q38+Y38","v":0}]
[]
[null,null,"Supplemental info:"]
[null,null,"Please describe grant funding, including % effort on each award if available (eg, 50% effort on R01)"]
[null,null,"Please describe how cost sharing and other unfunded expenses will be covered (eg, \"funded from clinical surplus\", \"funded from reserves\")"]

{"sheet":"OTC Calculation FY22 - OPTIONAL","index":7,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,7],[1,9,1,10],[1,12,2,16],[2,0,2,7],[2,9,2,10]]}
["NIH / HHS SALARY and IRS PENSION CAP - Costing Allocation Calculations "]
["Current NIH Salary Cap",{"$nulls":8},{"$f":"Assumptions!$D$21","v":212100},null,null,"Worker Costing Allocations                      (Effective Effort)"]
["Current IRS Pension Cap",{"$nulls":8},{"$f":"Assumptions!$D$18","v":330000}]
[null,"A","B","C","D (A*B)","E  (B*NIH CAP)","F                      ( (A-Pension Cap)*B)","G                      ( (A-Pension Cap)*B)","H","I","J",null,"K","L","M","N","O",null,"Y"]
["Enter Faculty Name","Actual Salary ","Intended Effort %*","Is this a NIH/HHS Grant?","Actual Salary at required effort","COA Direct Charge Salary","NIH/HHS Over the Cap Salary","PENSION - Over the Cap Salary","COA Direct Charge Fringe","Combined Over the Cap Fringe","Total Cost Sharing",null,"COA Direct Charge","NIH Cap Cost Share","Pension Cap Cost Share (Ledger:71013)","Total","Variance",null,"N"]
["Enter Awards or Grants here",0,0,null,{"$f":"B6*C6","v":0},{"$f":"IF(D6=\"Y\",$J$2*C6,E6-H6)","v":0},{"$f":"IF(D6=\"y\",E6-F6-H6,0)","v":0},{"$f":"IF(B6>=$J$3,((B6-$J$3)*(C6)),0)","v":0},{"$f":"F6*$F$17","v":0},{"$f":"(H6*$H$17)+(G6*$G$17)","v":0},{"$f":"G6+H6+J6","v":0},null,{"$f":"IFERROR(F6/B6,0)","v":0},{"$f":"IFERROR(G6/B6,0)","v":0},{"$f":"IFERROR(H6/B6,0)","v":0},{"$f":"SUM(M6:O6)","v":0},{"$f":"C6-P6","v":0}]
[null,{"$f":"B6","v":0},0,null,0,0,0,0,0,0,{"$f":"G7+H7+J7","v":0},null,0,0,0,0,0]
[null,{"$f":"B7","v":0},0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,0,0,null,0,0,0,0,0,0,0,null,0,0,0,0,0]
[null,null,{"$f":"SUM(C6:C15)","v":0},null,{"$f":"SUM(E6:E15)","v":0},0,0,0,0,0,0,null,{"$f":"SUM(M6:M15)","v":0},{"$f":"SUM(N6:N15)","v":0},{"$f":"SUM(O6:O15)","v":0},{"$f":"SUM(P6:P15)","v":0},{"$f":"SUM(Q6:Q15)","v":0}]
[{"$nulls":4},"FY22 Fringe Rates: ",{"$f":"'Research Plan'!C20","v":0.307},{"$f":"'Research Plan'!D20","v":0.315},0.02]
[]
[]
["Salary Allocated",{"$f":"SUM(F16:H16)","v":0}]
["Fringe Allocated",{"$f":"SUM(I16:J16)","v":0}]
["Total Expense",{"$f":"SUM(B20:B21)","v":0}]

{"sheet":"OTC Calculation FY22 EXAMPLE","index":8,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,0,16],[1,0,1,7],[1,9,1,10],[1,12,2,16],[2,0,2,7],[2,9,2,10]]}
["NIH / HHS SALARY and IRS PENSION CAP - Costing Allocation Calculations "]
["Current NIH Salary Cap",{"$nulls":8},{"$f":"Assumptions!$D$21","v":212100},null,null,"Worker Costing Allocations                      (Effective Effort)"]
["Current IRS Pension Cap",{"$nulls":8},{"$f":"Assumptions!$D$18","v":330000}]
[null,"A","B","C","D (A*B)","E  (B*NIH CAP)","F                      ( (A-Pension Cap)*B)","G                      ( (A-Pension Cap)*B)","H","I","J",null,"K","L","M","N","O",null,"Y"]
["Enter Faculty Name","Actual Salary ","Intended Effort %*","Is this a NIH/HHS Grant?","Actual Salary at required effort","COA Direct Charge Salary","NIH/HHS Over the Cap Salary","PENSION - Over the Cap Salary","COA Direct Charge Fringe","Combined Over the Cap Fringe","Total Cost Sharing",null,"COA Direct Charge","NIH Cap Cost Share","Pension Cap Cost Share (Ledger:71013)","Total","Variance",null,"N"]
["Enter Awards or Grants here",1000000,0.1,"Y",{"$f":"B6*C6","v":100000},{"$f":"IF(D6=\"Y\",$J$2*C6,E6-H6)","v":21210},{"$f":"IF(D6=\"y\",E6-F6-H6,0)","v":11790},{"$f":"IF(B6>=$J$3,((B6-$J$3)*(C6)),0)","v":67000},{"$f":"F6*$F$17","v":6511.47},{"$f":"(H6*$H$17)+(G6*$G$17)","v":5053.8500000000004},{"$f":"G6+H6+J6","v":83843.850000000006},null,{"$f":"IFERROR(F6/B6,0)","v":2.121E-2},{"$f":"IFERROR(G6/B6,0)","v":1.179E-2},{"$f":"IFERROR(H6/B6,0)","v":6.7000000000000004E-2},{"$f":"SUM(M6:O6)","v":0.1},{"$f":"C6-P6","v":0}]
[null,{"$f":"B6","v":1000000},0.1,"N",100000,33000,0,67000,10131,1340,{"$f":"G7+H7+J7","v":68340},null,3.3000000000000002E-2,0,6.7000000000000004E-2,0.1,0]
[null,{"$f":"B7","v":1000000},0.15,"Y",150000,31815,17685,100500,9767.2049999999999,7580.7749999999996,125765.77499999999,null,3.1815000000000003E-2,1.7684999999999999E-2,0.10050000000000001,0.15000000000000002,0]
[null,1000000,0.16,"N",160000,52800,0,107200,16209.6,2144,109344,null,5.28E-2,0,0.1072,0.16,0]
[null,1000000,0.09,"N",90000,29700,0,60300,9117.9,1206,61506,null,2.9700000000000001E-2,0,6.0299999999999999E-2,0.09,0]
[null,1000000,0.25,"Y",250000,53025,29475,167500,16278.674999999999,12634.625,209609.625,null,5.3025000000000003E-2,2.9475000000000001E-2,0.16750000000000001,0.25,0]
[null,1000000,0.05,"N",50000,16500,0,33500,5065.5,670,34170,null,1.6500000000000001E-2,0,3.3500000000000002E-2,0.05,0]
[null,1000000,7.0000000000000007E-2,"N",70000,23099.999999999993,0,46900.000000000007,7091.699999999998,938.00000000000011,47838.000000000007,null,2.3099999999999992E-2,0,4.6900000000000004E-2,6.9999999999999993E-2,0]
[null,1000000,0.01,"Y",10000,2121,1179,6700,651.14699999999993,505.38499999999999,8384.3850000000002,null,2.1210000000000001E-3,1.1789999999999999E-3,6.7000000000000002E-3,0.01,0]
[null,1000000,0.02,"N",20000,6600,0,13400,2026.2,268,13668,null,6.6E-3,0,1.34E-2,0.02,0]
[null,null,{"$f":"SUM(C6:C15)","v":1},null,{"$f":"SUM(E6:E15)","v":1000000},269871,60129,670000,82850.396999999997,32340.634999999998,762469.63500000001,null,{"$f":"SUM(M6:M15)","v":0.26987100000000003},{"$f":"SUM(N6:N15)","v":6.0129000000000002E-2},{"$f":"SUM(O6:O15)","v":0.67},{"$f":"SUM(P6:P15)","v":1},{"$f":"SUM(Q6:Q15)","v":0}]
[{"$nulls":4},"FY22 Fringe Rates: ",{"$f":"'Research Plan'!C20","v":0.307},{"$f":"'Research Plan'!D20","v":0.315},0.02]
[]
[]
["Salary Allocated",{"$f":"SUM(F16:H16)","v":1000000}]
["Fringe Allocated",{"$f":"SUM(I16:J16)","v":115191.03199999999}]
["Total Expense",{"$f":"SUM(B20:B21)","v":1115191.0319999999}]

{"sheet":"Assumptions","index":9,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Assumptions Impacting YSM-YM Business Plan"]
[null,"* Changing the inputs will impact the plan sheet and salary build tab."]
[]
[null,"Fringe"]
[null,null,"M&P - Non-Clinical Faculty",0.315,"FY 2024 Rate"]
[null,null,"Clinical Faculty",0.315,"FY 2024 Rate"]
[null,null,"M&P/Faculty - Grants",0.307,"FY 2024 Rate"]
[null,null,"Tack-On & Sabaatical Assessment",{"$f":"0.086+0.03","v":0.11599999999999999},"FY 2024 Rate"]
[null,null,"Child Rearing Assessment",1.2E-2,"FY 2024 Rate"]
[null,null,"C&T",0.68500000000000005,"FY 2024 Rate"]
[null,null,"C&T - Grants",0.66100000000000003,"FY 2024 Rate"]
[null,null,"Over the Pension Cap",0.02,"FY 2024 Rate"]
[null,null,"Over the Pension Cap - Clinical Faculty",0.02,"FY 2024 Rate"]
[null,null,"Incentive",0.02,"FY 2024 Rate"]
[null,"Other"]
[null,null,"Lag",1.5,"Represents 45 day collection lag"]
[null,null,"Over the Pension Cap Amount1",330000,"CY 2023 Cap"]
[]
[null,"Research"]
[null,null,"NIH Salary Cap",212100,"Cap as per NIH"]
[]
[null,null,"Indirect Rates"]
[null,null,"https://your.yale.edu/research-support/office-sponsored-projects/institutional-information"]
[]
[null,"1) Over the cap amount"]

{"sheet":"Contractual Calculator","index":10,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[3,2,3,4]]}
[]
[{"$nulls":6},"Department"]
[{"$nulls":6},"Gross-Up?"]
[null,null,"YNHHS and Non-Affiliated Hospital Contract Calculator",null,null,null,"No"]
[]
[null,null,null,"Rate","Year 1 ","Year 2","Year 3"]
[null,null,"Base Contract Amount",null,0,0,0]
[null,null,"Department Assessment ",0,{"$f":"IF(G4=\"Yes\",$E$7/(1-$D$8)-$E$7,$D$8*$E$7)","v":0},{"$f":"IF($G$4=\"Yes\",$F$7/(1-$D$8)-$F$7,$D$8*$F$7)","v":0},{"$f":"IF($G$4=\"Yes\",$G$7/(1-$D$8)-$G$7,$D$8*$G$7)","v":0}]
[null,null,"Direct Contract Amount",null,{"$f":"E8+E7","v":0},{"$f":"F8+F7","v":0},{"$f":"G8+G7","v":0}]
[null,null,"YSM/YM Assessment",0.11700000000000001,{"$f":"E9/(1-D10)-$E$9","v":0},{"$f":"F9/(1-D10)-$F$9","v":0},{"$f":"G9/(1-D10)-$G$9","v":0},"Please update to 15% if for non-affiliated"]
[null,null,"Total Amount of Contract",null,{"$f":"E10+E9","v":0},{"$f":"F10+F9","v":0},{"$f":"G10+G9","v":0}]
[null,null,"Gross Assessments ",null,{"$f":"E8+E10","v":0},{"$f":"F8+F10","v":0},0]
[null,null,"Assessment Effective Rate - %",null,{"$f":"IFERROR(E12/E11,0)","v":0},{"$f":"IFERROR(F12/F11,0)","v":0},{"$f":"IFERROR(G12/G11,0)","v":0}]

{"sheet":"I&A Calculator","index":11,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[7,6,7,7]]}
[]
[]
[]
[null,"I&A Calculator to Support Template"]
[]
[null,"Building Purchase",{"$nulls":4},"***Abatement and remediation costs cannot be capitalized. The costs will be expensed in year one (or when abated)***"]
[]
[null,null,"Principle",0,null,null,"Type of Project",null,"Term"]
[null,null,"Int Rate",4.2500000000000003E-2,null,null,"Building Purchase",null,40]
[null,null,"Term-Yrs",40,null,null,"Building Renovation",null,"15-20"]
[{"$nulls":6},"Furniture",null,10]
[null,null,"Annual I&A",{"$f":"PMT(D9/12,D10*12,D8)*-12","v":0}]
[]
[]
[null,"Building Renovation"]
[]
[null,null,"Principle",0]
[null,null,"Int Rate",4.2500000000000003E-2]
[null,null,"Term-Yrs",20]
[]
[null,null,"Annual I&A",{"$f":"PMT(D18/12,D19*12,D17)*-12","v":0}]
[]
[]
[null,"Furniture"]
[]
[null,null,"Principle",0]
[null,null,"Int Rate",4.2500000000000003E-2]
[null,null,"Term-Yrs",10]
[]
[null,null,"Annual I&A",{"$f":"PMT(D27/12,D28*12,D26)*-12","v":0}]

{"sheet":"Definitions ","index":12,"n_rows":39,"n_cols":3,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[null,"PDDO Template Definitions:"]
[]
[null,"Category","Definition"]
[]
[null,"Type"]
[null,"YNHH PDDO","A backstop from YNHH with a unique set of assessments; will populate the assessments on PDDO section at the bottom of the document."]
[null,"YNHHS PDDO","A backstop from a YNHHS entity with a unique set of assessments; will populate the assessments on PDDO section at the bottom of the document."]
[null,"Non-Affliated PDDO","A backstop from non-YNHH/YNHHS entity with a unique set of assessments; will populate the assessments on PDDO section at the bottom of the document."]
[null,"Contractual","A plan to satisfy planning for a contractual agreement. Does not impact the spreadsheet and assessments will only be calculated within the plan. "]
[]
[null,"Position"]
[null,"Replacement","A replacement for an existing faculty position."]
[null,"Acquisition","Acquisition of a new practice or physician."]
[null,"New Hire - Organic","A new hire due to organic growth (clinic volume growth in existing service/clinic, etc.)"]
[null,"New Program (Not Acquired)","A new program being built from the ground up."]
[null,"N/A","Catch-all."]
[null,"One-Time Incentive ","One-time payment(s) funded by Yale University"]
[null,"Ongoing Incentive ","Ongoing payment(s) funded by Yale University"]
[null,"Moving/Relocation Bonus","Payment(s) funded by Yale University related to relocation "]
[null,"YNHH Metric-Based","YNHH funded performance funds paid on-going and based on achievement of metrics and goals (i.e. no YNHH YSM overhead)"]
[null,"YNHH Not Metric-Based","YNHH funded performance fund not tied to metrics (i.e. must pay 18% YSM overhead)"]
[]
[null,"Ramp-Up Methodology","Can select for each of the three years. The standard assumption should be 65/80/100. Will show as blank and the user is to select appropriate ramp-up criteria. "]
[null,"Volume","For clinical business plans, please select the volume metric you are using. The standard is wRVU. "]
[null,"Revenue-Generating cFTE","Time spent seeing patients and/or on direct patient care activity. Should align with departments definition of cFTE. "]
[null,"# of Faculty","Physical bodies associated with the plan. For example, if there is support for 1.6 cFTE which is comprised of two individuals, the number of faculty is two. "]
[]
[null,"Revenue/Volume Metrics:"]
[null,"Volume per Revenue-generating cFTE","A metric to show expected productivity per cFTE. Should be aligned with ramp-up."]
[null,"Collections per Revenue-generating cFTE","A metric to show expected collections per cFTE. Should be aligned with ramp-up."]
[null,"Collections per Volume Metric","A metric to show expected collections on a per unit basis."]
[]
[null,"Program Development/Direction Support"]
[null,"YNHH Direct Salary and Fringe Benefit Support","Typically, medical director support for salary and fringe. The original version will auto-calculate based on the salary build sheet."]
[null,"YNHH Contractual","Contractual arrangements in which YNHH is the other entity (includes on-call)."]
[null,"Other Contractual","Contractual arrangements in which YNHH is not the other entity."]
[null,"Gifts","Contributions made to a University entity; has assessment implications."]
[null,"Other Revenue (non-taxable)","A catch-all for other revenue. "]

{"sheet":"Version Notes","index":13,"n_rows":99,"n_cols":3,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Version Notes:"]
[]
[null,1.1000000000000001,"Fixed formula double counting incentive compensation"]
[]
[null,1.2,"Fixed ongoing versus on-time incentive compensation"]
[]
[null,1.3,"Broke out salary build sheet by year (removed inflationary components)"]
[]
[null,null,"Added non-salary build sheet"]
[]
[null,null,"Added additional lines for incentive compensation "]
[null,null," "]
[null,null,"Added YNHH Contractual to bottom of template to calculate appropriate YNHH commitment"]
[]
[null,null,"Added I&A Calculator and term/interest rate information "]
[]
[null,null,"Programmed new incentive compensation categories"]
[null,null,"---> selecting a YNHH category populates both revenue and expense"]
[]
[null,2019.1,"Updated fringe and assumptions based on the FY 2019 budget instructions"]
[]
[null,null,"Grant Indirects moved to bottom of the document as to not impact net income or YNHH payment (dollars go directly to YSM)"]
[]
[null,null,"Grant fringe rates programmed into the template on the salary build sheet (column D)"]
[]
[null,"2019.1.2","Fixed formula error related to medical directorship salary and fringe "]
[]
[null,"2019.2.0","Adjusted assessments for new methodology"]
[]
[null,null,"Adjusted fringe to reflect clinical and non-clinical for faculty only (42.1% and 2.2%)"]
[]
[null,null,"Fixed PDDO formula to reflect 11.3% overhead"]
[]
[null,"2019.2.1","Fixed PDDO formula which was incorrectly calculating YNHH payment on deficits on RFPs and other non-PDDOs"]
[]
[null,"2020.1.0","Updated fringe and assumptions based on the FY 2020 budget instructions"]
[]
[null,null,"Added password to unlock to top of summary RFP document "]
[]
[null,"2020.1.1","Fixed formula error and a presentation error"]
[]
[null,"2020.1.2","Added YNHHS - Contractual PDDO category with associated formulas and labels."]
[null,null,"Added Conctractual Calculator"]
[]
[null,"2020.12.13.20","Added research template"]
[null,null,"Updated fringe rates for new family rearing rate"]
[null,null,"Added affiliated hospital template"]
[null,null,"Added summary RFP template"]
[null,null,"Updated inaccuracy (in rare occassions) on YNHHS overhead"]
[]
[null,"2021.3.31.20","Formatting enhancements to aid printing"]
[null,null,"Updated fringe and caps to FY 2021 rates/amounts"]
[null,null,"Added non-salary functionality for Research RFP"]
[null,null,"Updated I&A sheet for new University interest rate"]
[]
[null,"2021.8.20.20","Removed error prompts caused by hidden sheets"]
[null,null,"Updated fringe rates for new guidnance on Child Rearing"]
[]
[null,"2022.1.06.21","Moved Tach-On, Sabbatical, and Child Rearing to assessments rather than fringe"]
[null,null,"Added FY22 parameters"]
[null,null,"Adjusted for new YNHH(S) overhead rate from 11.3%/15% to 11.7%"]
[null,null,"Other cosmetic adjustments and formula improvements"]
[null,null," "]
[null,"2022.1.27.21","Fixed formula error for YNHH direct funding"]
[null,null,"Fixed formula error for YNHHS contractual agreements"]
[null,null," "]
[null,"2022.5.3.21","Removed Dean's Dowry as a revenue source"]
[null,null,"Renamed Dowry \"Academic Program Support\""]
[null,null,"Correct proration for tack-on, sabbatical, and child-rearing leave"]
[null,null,"Hid summary tab which is not widely used "]
[null,null,"Corrected Research RFP non-salary issue (unfunded)"]
[]
[null,"2022.9.15.21","Relabeled Business Office Assessment as Department Assessment"]
[null,null,"Fixed YNHH funded salaries formula"]
[null,null,"Revised contractual calculator "]
[]
[null,"2023.1.26.22","Include redesign of Research RFP Template"]
[null,null,"Added YM CARE staffing "]
[null,null,"Updated for FY23 parameters"]
[null,null,"Various formatting changes "]
[null,null,"Changed ramp-up to blank to incent thoughful metrics"]
[]
[null,"2023.6.13.22","Renamed YNHH(S) options and consolidated"]
[null,null,"Added a \"Non-Affiliated\" PDDO category"]
[null,null,"Removed mostly unused categories without formula implications (RFP and Salary Support)"]
[null,null,"Changed NIH cap as of 1/22"]
[null,null,"Fixed Tack-on proration formula"]
[null,null,"Added grand total to Research RFP and locked select cells with formulas"]
[]
[null,"2023.10.31.22","Unlocked commentary on \"Research Tab\""]
[null,null,"Changed font to Times New Roman"]
[null,null,"Removed default assessment rate "]
[null,null,"Added YNHH/YM cover sheet "]
[null,null,"Minor formula and labeling enhancements throughout workbook"]
[]
[null,"2024.02.21.23","Updated for FY24 budget parameters"]
[null,null,"Removed unused research assumptions (custom caps)"]
[null,null,"Added hyperlink to official YSM research assumptions on the assumptions tab"]

{"sheet":"Research Depository","index":14,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"On-Campus",null,"NIH Salary Cap",null,"Yes"]
[null,null,"On-Campus Department of Defense",null,"Custom Cap",null,"No"]
[null,null,"Off Campus",null,"No Cap",null,"Subaward Cap"]
[null,null,"CMHC",null,null,null,"Custom Cap"]
[null,null,"VA"]
[null,null,"Other Federally Sponsored Activities - On Campus"]
[null,null,"Other Federally Sponsored Activities - Off Campus"]
[null,null,"Private < $10K"]
[null,null,"Private $10K-$25K"]
[null,null,"Industry Clinical Trials"]
[null,null,"Fellowships"]
[null,null,"Training Grants"]
[null,null,"Unrestricted Clinical Trial"]
[null,null,"Multiple Awards (Use Custom Indirect Rate)"]

{"sheet":"Depository for MD","index":15,"n_rows":94,"n_cols":12,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Rank","CLINICAL SCIENCE - TOTAL ALL DEPARTMENTS/SPECIALTIES",{"$nulls":6},"25th",null,"Clinical"]
[null,"Instructor","Total Anesthesiology",{"$nulls":6},"Median",null,"Non-Clinical"]
[null,"Assistant Professor","Anesthesiology: General",{"$nulls":6},"75th"]
[null,"Associate Professor","Anesthesiology: Pain Management",{"$nulls":6},"Mean"]
[null,"Professor","Anesthesiology: Pediatric"]
[null,"Section Chief","Total Dermatology"]
[null,"Chair","Dermatology (excluding Mohs Surgery)"]
[null,"Medical Director","Dermatology: Mohs Surgery"]
[null,null,"Total Family Medicine"]
[null,null,"Family Medicine: General"]
[null,null,"Family Medicine: Sports Medicine"]
[null,null,"Family Medicine: Other"]
[null,null,"Total Medicine"]
[null,null,"Allergy/Immunology-Med."]
[null,null,"Cardiology: Total"]
[null,null,"Cardiology: Invasive Interventional-Med."]
[null,null,"Cardiology: Invasive Non-interventional-Med."]
[null,null,"Cardiology: Non-invasive-Med."]
[null,null,"Critical/Intensive Care-Med."]
[null,null,"Endocrinology-Med."]
[null,null,"Gastroenterology-Med."]
[null,null,"General Internal Medicine"]
[null,null,"Geriatrics-Med."]
[null,null,"Hematology/Oncology-Med."]
[null,null,"Hospital Medicine"]
[null,null,"Infectious Disease-Med."]
[null,null,"Nephrology-Med."]
[null,null,"Pulmonary-Med."]
[null,null,"Rheumatology-Med."]
[null,null,"Other Medicine"]
[null,null,"Total OB/GYN"]
[null,null,"OB/GYN: General"]
[null,null,"OB/GYN: Gynecologic Oncology"]
[null,null,"OB/GYN: Maternal & Fetal"]
[null,null,"OB/GYN: Reproductive Endocrinology"]
[null,null,"OB/GYN: Other OB/GYN"]
[null,null,"Total Pathology"]
[null,null,"Pathology: Anatomic"]
[null,null,"Pathology: Clinical"]
[null,null,"Pathology: Other Pathology"]
[null,null,"Total Pediatrics"]
[null,null,"Adolescent Medicine"]
[null,null,"Allergy/Immunology-Peds."]
[null,null,"Critical/Intensive Care-Peds."]
[null,null,"Emergency Medicine-Peds."]
[null,null,"Endocrinology-Peds."]
[null,null,"Gastroenterology-Peds."]
[null,null,"General Pediatrics"]
[null,null,"Genetics-Peds."]
[null,null,"Hematology/Oncology-Peds."]
[null,null,"Hospital Medicine-Peds."]
[null,null,"Infectious Disease-Peds."]
[null,null,"Neonatology"]
[null,null,"Nephrology-Peds."]
[null,null,"Neurology-Peds."]
[null,null,"Pediatric Cardiology"]
[null,null,"Pulmonary-Peds."]
[null,null,"Rheumatology-Peds."]
[null,null,"Other Pediatrics"]
[null,null,"Total Psychiatry"]
[null,null,"Psychiatry: Child & Adolescent"]
[null,null,"Psychiatry: General"]
[null,null,"Psychiatry: Other"]
[null,null,"Total Radiology"]
[null,null,"Diagnostic Radiology: Total"]
[null,null,"Diagnostic Radiology: Interventional"]
[null,null,"Diagnostic Radiology: Non-interventional"]
[null,null,"Nuclear Medicine"]
[null,null,"Radiation Oncology"]
[null,null,"Other Radiology"]
[null,null,"Total Surgery"]
[null,null,"General Surgery"]
[null,null,"Neurosurgery"]
[null,null,"Orthopaedic Surgery: Total"]
[null,null,"Orthopaedic Surgery: General"]
[null,null,"Orthopaedic Surgery: Sports Medicine"]
[null,null,"Orthopaedic Surgery: Other"]
[null,null,"Pediatric Surgery"]
[null,null,"Plastic Surgery"]
[null,null,"Surgical Oncology"]
[null,null,"Thoracic & Cardiovascular Surgery"]
[null,null,"Transplant Surgery"]
[null,null,"Trauma/Critical Care Surgery"]
[null,null,"Urology"]
[null,null,"Vascular Surgery"]
[null,null,"Other Surgery"]
[null,null,"Community Health"]
[null,null,"Emergency Medicine"]
[null,null,"Neurology"]
[null,null,"Ophthalmology"]
[null,null,"Otolaryngology"]
[null,null,"Physical Medicine & Rehabilitation"]
[null,null,"Preventive Medicine"]

{"sheet":"Depository1","index":16,"n_rows":83,"n_cols":25,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[{"$nulls":21},"Yes"]
[null,"60%/85%/100%","YNHH PDDO",null,"Replacement",null,null,"Anesthesiology","Administration",null,null,null,"Start in Q1",12,null,"wRVUs",{"$nulls":5},"No"]
[null,"50%/75%/100%","YNHHS PDDO",null,"Acquisition",null,null,"Comprehensive Cancer Center","Aids",{"$f":"CONCATENATE(\"Internal Medicine\",\" - \",I5)","v":"Internal Medicine - Administration"},null,null,"Start in Q2",9,null,"UHC RVUs"]
[null,"No Ramp Up","Non-Affiliated PDDO",null,"New Hire - Organic",null,null,"Child Study Center","Cardiology","Internal Medicine - Aids",null,null,"Start in Q3",6,null,"Units",{"$nulls":8},"Yes"]
[null,null,"Contractual",null,"New Program (not acquired)",null,null,"Dermatology","Clinical Affairs","Internal Medicine - Cardiology",null,null,"Start in Q4",3,null,"Time Units",{"$nulls":8},"No"]
[{"$nulls":4},"N/A",null,null,"Emergency Medicine","Clinical Scholars","Internal Medicine - Clinical Affairs",null,null,"Full Year",12,null,"Visits"]
[{"$nulls":7},"Genetics","Digestive Diseases","Internal Medicine - Clinical Scholars",null,null,"Start in July",12,null,"Cases"]
[{"$nulls":7},"Internal Medicine","Education","Internal Medicine - Digestive Diseases",null,null,"Start in Aug.",11,null,"Other (Please Explain in Notes)"]
[{"$nulls":7},"Laboratory Medicine","Endocrinology","Internal Medicine - Education",null,null,"Start in Sept.",10,{"$nulls":9},"Clinical Staff"]
[{"$nulls":7},"Neurology","General Medicine","Internal Medicine - Endocrinology",null,null,"Start in Oct.",9,{"$nulls":9},"Administrative"]
[{"$nulls":7},"Neurosurgery","Geriatrics","Internal Medicine - General Medicine",null,null,"Start in Nov.",8,{"$nulls":9},"YM CARE"]
[{"$nulls":7},"Obstetrics & Gynecology","Immunology","Internal Medicine - Geriatrics",null,null,"Start in Dec.",7,{"$nulls":9},"Other"]
[{"$nulls":7},"Ophthalmology and Visual Science","Infectious Diseases","Internal Medicine - Immunology",null,null,"Start in Jan.",6]
[null,0.4,null,0.4,null,null,null,"Orthopaedics and Rehabilitation","Global Health","Internal Medicine - Infectious Diseases",null,null,"Start in Feb.",5]
[null,0.45,0.4,0.45,null,null,null,"Pathology","Nephrology","Internal Medicine - Global Health",null,null,"Start in Mar.",4]
[null,0.5,0.45,0.5,null,null,null,"Pediatrics","Occupational Medicine","Internal Medicine - Nephrology",null,null,"Start in Apr.",3]
[null,0.55000000000000004,0.5,0.55000000000000004,null,null,null,"Psychiatry","Pulmonary","Internal Medicine - Occupational Medicine",null,null,"Start in May",2]
[null,0.6,0.55000000000000004,0.6,null,null,null,"Radiology and Biomedical Imaging","Research Affairs","Internal Medicine - Pulmonary",null,null,"Start in June",1]
[null,0.65,0.6,0.65,null,null,null,"Surgery","Rheumatology","Internal Medicine - Research Affairs"]
[null,0.7,0.65,0.7,null,null,null,"Therapeutic Radiology","Stem Cell Center","Internal Medicine - Rheumatology"]
[null,0.75,0.7,0.75,null,null,null,"Urology","PA Program","Internal Medicine - Stem Cell Center"]
[null,0.8,0.75,0.8,null,null,null,"YM Multi-Specialty Clinics","Administration","Internal Medicine - PA Program",null,null,"Assisstant Professor"]
[null,0.85,0.8,0.85,{"$nulls":4},"Community Physicians",{"$f":"CONCATENATE(\"OB-GYN\",\" - \",I25)","v":"OB-GYN - Administration"},null,null,"Associate Professor ",null,null,"Ongoing"]
[null,0.9,0.85,0.9,{"$nulls":4},"Endocrinology","OB-GYN - Community Physicians",null,null,"Clinician ",null,null,"One-Time"]
[null,0.95,0.9,0.95,{"$nulls":4},"Oncology","OB-GYN - Endocrinology",null,null,"Instructor"]
[null,1,0.95,1,{"$nulls":4},"Perinatology","OB-GYN - Oncology",null,null,"Medical Director"]
[null,"Blank ",1,"Blank",{"$nulls":4},"Reproductive Sciences","OB-GYN - Perinatology",null,null,"Professor "]
[null,null,"Blank",{"$nulls":5},"Teaching","OB-GYN - Reproductive Sciences"]
[null,"FY 2023",null,null,"One-Time Incentive ",null,null,null,"Urogynecology","OB-GYN - Teaching"]
[null,"FY 2024",null,null,"Ongoing Incentive ",null,null,null,"Family Planning","OB-GYN - Urogynecology"]
[null,"FY 2025",null,null,"Moving/Relocation Bonus",null,null,null,"Administration","OB-GYN - Family Planning"]
[null,"FY 2026",null,null,"YNHH Metric-Based",null,null,null,"Hematology / Oncology",{"$f":"CONCATENATE(\"Pediatrics\",\" - \",I34)","v":"Pediatrics - Administration"}]
[null,"FY 2027",null,null,"YNHH Not Metric-Based",null,null,null,"Cardiology",{"$f":"CONCATENATE(\"Pediatrics\",\" - \",I35)","v":"Pediatrics - Hematology / Oncology"}]
[null,"FY 2028",{"$nulls":6},"Endocrinology","Pediatrics - Cardiology"]
[null,"FY 2029",{"$nulls":6},"Gastroenterology","Pediatrics - Endocrinology"]
[null,"FY 2030",{"$nulls":6},"Emergency Dept","Pediatrics - Gastroenterology"]
[null,"FY 2031",{"$nulls":6},"Infectious Disease","Pediatrics - Emergency Dept"]
[null,"FY 2032",{"$nulls":6},"Immunology","Pediatrics - Infectious Disease"]
[{"$nulls":8},"Nephrology","Pediatrics - Immunology"]
[{"$nulls":8},"Neurology","Pediatrics - Nephrology"]
[{"$nulls":8},"General Pediatrics","Pediatrics - Neurology"]
[{"$nulls":8},"Respiratory","Pediatrics - General Pediatrics"]
[{"$nulls":8},"Neonatology","Pediatrics - Respiratory"]
[{"$nulls":8},"Adolescent Medicine","Pediatrics - Neonatology"]
[{"$nulls":8},"Critical Care","Pediatrics - Adolescent Medicine"]
[{"$nulls":8},"Hospitalist","Pediatrics - Critical Care"]
[{"$nulls":8},"Pedi Epilepsy","Pediatrics - Hospitalist",null,null,"Yes"]
[{"$nulls":8},"International Adoption","Pediatrics - Pedi Epilepsy",null,null,"No"]
[{"$nulls":8},"DBP Developmental Behavior Ped","Pediatrics - International Adoption"]
[{"$nulls":8},"Stem Cell CTR","Pediatrics - DBP Developmental Behavior Ped"]
[{"$nulls":8},"Administration","Pediatrics - Stem Cell CTR"]
[{"$nulls":8},"Section of Cardiac Surgery","Radiology and Biomedical Imaging - Interventional "]
[{"$nulls":8},"Medical Education","Radiology and Biomedical Imaging - Body Imaging"]
[{"$nulls":8},"Oncology","Radiology and Biomedical Imaging - Thoracic/Cardiac"]
[{"$nulls":8},"Otolaryngology","Radiology and Biomedical Imaging - Emergency Medicine"]
[{"$nulls":8},"Pediatrics","Radiology and Biomedical Imaging - Breast Imaging"]
[{"$nulls":8},"Plastic","Radiology and Biomedical Imaging - Musculoskeletal"]
[{"$nulls":8},"Section of Thoracic Surgery","Radiology and Biomedical Imaging - Neuro"]
[{"$nulls":8},"Gross Anatomy","Radiology and Biomedical Imaging - Nuclear Medicine"]
[{"$nulls":8},"Neuropathology","Radiology and Biomedical Imaging - Pediatrics"]
[{"$nulls":8},"Surgical Outcomes","Radiology and Biomedical Imaging - Ultrasound"]
[{"$nulls":8},"Transplant",{"$f":"CONCATENATE(\"Surgery\",\" - \",I54)","v":"Surgery - Administration"}]
[{"$nulls":8},"Trauma","Surgery - Section of Cardiac Surgery"]
[{"$nulls":8},"Vascular","Surgery - Medical Education"]
[{"$nulls":8},"Chairman","Surgery - Oncology"]
[{"$nulls":8},"Billing","Surgery - Otolaryngology"]
[{"$nulls":8},"Endocrine Surgery","Surgery - Pediatrics"]
[{"$nulls":8},"Gastrointestinal","Surgery - Plastic"]
[{"$nulls":8},"Stem Cell Ctr","Surgery - Section of Thoracic Surgery"]
[{"$nulls":9},"Surgery - Gross Anatomy"]
[{"$nulls":9},"Surgery - Neuropathology"]
[{"$nulls":9},"Surgery - Surgical Outcomes"]
[{"$nulls":9},"Surgery - Transplant"]
[{"$nulls":9},"Surgery - Trauma"]
[{"$nulls":9},"Surgery - Vascular"]
[{"$nulls":9},"Surgery - Chairman"]
[{"$nulls":9},"Surgery - Billing"]
[{"$nulls":9},"Surgery - Endocrine Surgery"]
[{"$nulls":9},"Surgery - Gastrointestinal"]
[{"$nulls":9},"Surgery - Stem Cell Ctr"]