{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions - Start Here","Is 131 the Best Option","131 Program Summary","Credits","Curriculum Development","Salaries & Wages","Salaries & Wages - old","Tuition Remission","Sub-Agreements","Supplies & Services","Investing the Margin","Validation"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":2,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions - Start Here","index":0,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[null,"Instructions"]
[]
[null,"Step 1 - Use the \"Is 131 the Best Option?\" tab to determine whether a 131 is best for you."]
[null,"Goal: Determine whether a program should be a 131 program. 131 programs result in net new enrollment and revenue growth to campus. They must be self-supporting instructional programs that have not been budgeted through UW-Extension and are outside the tuition pool, and they must not compete with, or draw student away from, existing programs. Examples of these non-pooled programs include professional master’s and capstone certificate programs.\n\nHow to use:\nFill out the Yes/No column with the appropriate answer to each question. The result will appear in the Result box below. Read the information to the right. If your result is a 131 program, continue filling out the subsequent tabs of the workbook. If not, a 101 program is likely preferred, so the workbook is no longer relevant."]
[null,"Step 2 - If yes, fill out green boxes on all subsequent tabs."]
[null,"131 Program Summary\n       "]
[null,"This tab aggregates the detailed information on subsequent tabs into a summary of total costs per year.\n\nHow to use:\nFill out the green boxes to specify the general details about the program, such as its name, department, year of implementation, duration, and price."]
[null,"Submodels"]
[null,"Credits"]
[null,"This tab allows users to input the number of credits taken per year (full-time and part-time), as well as the enrollment per year (both residents and nonresidents and for full-time and part-time students).\n\nHow to use:\nAfter inputting the number of years in the Program Duration cells of \"131 Program Summary\"  tab, the cells where data needs to be entered (number of credits per year, and the first-year enrollment for each year) will turn green. This will then act as the input for the continuing student enrollment going forward, as well as the total credits and tuition calculations on the \"131 Program Summary\" tab."]
[null,"Curriculum"]
[null,"This tab breaks down the costs of developing and maintaining course content. The standard cost for course development is $30,000, $15,000 for a transition, and course maintenance is frequently 15% of the development cost, although variance is possible.\n\nHow to use:\nFill in the development cost for each course for each year. The course maintenance column will automatically populate to be 15% of the development cost, although it can be manually altered."]
[null,"Salaries & Wages"]
[null,"This tab breaks down the compensation for each person working for the program and allows people to be classified as either Instructional, Program Support, Program Marketing, Program Development - Startup (DCS / Campus), or Program Development – Startup.\n\nHow to use:\nFill in each green column for each person. The base salary should be entered in the Salary/Wage column and the appropriate pay basis, months, and effort should be inputted to allow the actual requested salary to appear in the Requested Salary column. Input an amount for the \"Compensation Escalator\" to drive the increase in salary over time. Then enter the fringe rate in the specified column, which will calculate the fringe benefit expense and total cost. Make sure to click on the + sign to expand each year and fill in information for every year the individual will be involved in the program."]
[null,"Tuition Remission"]
[null,"This tab calculates costs of tuition remission for Project Assistant and Research Assistant students involved in the program each year.\n\nHow to use:\nFill in each green box with the number of PA/RAs the program will require for each year and semester."]
[null,"Sub-Agreements"]
[null,"This tab calculates the cost of sub-agreements with other schools, categorizes the expense as either instructional or support, and identifies the payment type as either fixed rate or per credit.\n\nHow to use:\nFill in the name of the entity the sub-agreement is with, the type, the payment type, and the amount (ex: $ per credit, or the total fixed amount). The following two columns will calculate based on the payment type and amount."]
[null,"Supplies & Services"]
[null,"This tab allows users to list and describe all purchases, and identify them as instructional, support, or program development.  \n\nHow to use:\nFill out the category (travel, meetings, conferences, supplies, other), describe the cost, choose the type, and list the amount for each year."]
[null,"Investing the Margin"]
[null,"This tab allows users to describe in detail how the residual money will be spent, categorized by department salaries, new faculty lines, additional TA positions or scholarships, professional development, and other.\n\nHow to use:\nFill in the category type, describe the cost, and list the amount for each year."]

{"sheet":"Is 131 the Best Option","index":1,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,1,0,3],[1,1,1,2]]}
[null,"Is 131 the Best Option?"]
[null,"Characteristic",null,"Yes/No"]
[null,1,"Is the program designed for non-traditional students through modality, curriculum, and attentiveness to workforce demand?","yes"]
[null,2,"Does the program have substantial opportunity for scale (e.g. more than 750 incremental annual credits)?","yes","Yes"]
[null,3,"Does the program have substantial opportunity for differentiated market tuition (e.g. above the standard grad rate in your school /college)?","No","No"]
[null,{"$f":"CONCATENATE(3,\".\")","v":"3."},"Does the cost of instruction and support of the program leave room for substantial investment margin?"]
[null,{"$f":"CONCATENATE(4,\".\")","v":"4."},"Does the program require new offerings (courses)?"]
[null,{"$f":"CONCATENATE(5,\".\")","v":"5."},"Is there sufficient demand to cover those courses (e.g. larger than x students)?",null,null,null,"if say no to 2 but have really large program, still could be 131"]
[]
[]
[null,null,"Result"]
[null,null,{"$f":"IF(AND(ISBLANK(D3),ISBLANK(D5),ISBLANK(D4)),\"\",IF(D3=\"No\",\"A 101 (Pooled) Program Is Best For You\",IF(OR(D4=\"Yes\",D5=\"Yes\"),\"A 131 Program Might Be Right For You\",\"A 101 (Pooled) Program Is Best For You\")))","v":"A 131 Program Might Be Right For You"}]

{"sheet":"131 Program Summary","index":2,"n_rows":93,"n_cols":13,"rows_kept":93,"cut":false,"hidden":false,"merged":[[54,1,54,11]]}
[1,"Program name",null,null,"Program department"]
[{"$f":"A1+1","v":2}]
[{"$f":"A2+1","v":3},"Investment start (Academic Year)",2020,null,"Program duration (years - Full Time)",1]
[4,"Enrollment start (Academic Year)",2021,null,"Program duration (years - Part Time)",2]
[5]
[6,"Resident price per credit",1200,null,"School / college share approach","Net Revenue"]
[7,"Non-resident price per credit",1200,null,{"$f":"CONCATENATE(E22,\" \",\"Instructional cost per credit\")","v":"2022 Instructional cost per credit"},{"$f":"E36/(SUM(E23:E26))","v":{"$error":"#DIV/0!"}}]
[8,null,null,null,{"$f":"CONCATENATE(E22,\" \",\"Support cost per credit\")","v":"2022 Support cost per credit"},{"$f":"E38/(SUM(E23:E26))","v":{"$error":"#DIV/0!"}}]
[9,"Dept scholarship",0.05]
[10,"Waiver percentage",0.05,null,"Campus share",0.1]
[11,"Marketing per new student",3000,null,"School / college share ",0.23]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22,"Fiscal year",{"$f":"C3","v":2020},{"$f":"C22+1","v":2021},{"$f":"D22+1","v":2022},2023,2024,2025,2026,2027,2028,2029]
[23,"Resident Credits (FT)",{"$f":"Credits!D14*Credits!$D$4+Credits!D16*Credits!$D$5+Credits!D18*Credits!$D$6+Credits!D20*Credits!$D$7+Credits!D22*Credits!$D$8+Credits!D24*Credits!$D$9","v":0},{"$f":"Credits!E14*Credits!$D$4+Credits!E16*Credits!$D$5+Credits!E18*Credits!$D$6+Credits!E20*Credits!$D$7+Credits!E22*Credits!$D$8+Credits!E24*Credits!$D$9","v":0},{"$f":"Credits!F14*Credits!$D$4+Credits!F16*Credits!$D$5+Credits!F18*Credits!$D$6+Credits!F20*Credits!$D$7+Credits!F22*Credits!$D$8+Credits!F24*Credits!$D$9","v":0},{"$f":"Credits!G14*Credits!$D$4+Credits!G16*Credits!$D$5+Credits!G18*Credits!$D$6+Credits!G20*Credits!$D$7+Credits!G22*Credits!$D$8+Credits!G24*Credits!$D$9","v":0},{"$f":"Credits!H14*Credits!$D$4+Credits!H16*Credits!$D$5+Credits!H18*Credits!$D$6+Credits!H20*Credits!$D$7+Credits!H22*Credits!$D$8+Credits!H24*Credits!$D$9","v":0},{"$f":"Credits!I14*Credits!$D$4+Credits!I16*Credits!$D$5+Credits!I18*Credits!$D$6+Credits!I20*Credits!$D$7+Credits!I22*Credits!$D$8+Credits!I24*Credits!$D$9","v":0},{"$f":"Credits!J14*Credits!$D$4+Credits!J16*Credits!$D$5+Credits!J18*Credits!$D$6+Credits!J20*Credits!$D$7+Credits!J22*Credits!$D$8+Credits!J24*Credits!$D$9","v":0},{"$f":"Credits!K14*Credits!$D$4+Credits!K16*Credits!$D$5+Credits!K18*Credits!$D$6+Credits!K20*Credits!$D$7+Credits!K22*Credits!$D$8+Credits!K24*Credits!$D$9","v":0},{"$f":"Credits!L14*Credits!$D$4+Credits!L16*Credits!$D$5+Credits!L18*Credits!$D$6+Credits!L20*Credits!$D$7+Credits!L22*Credits!$D$8+Credits!L24*Credits!$D$9","v":0},{"$f":"Credits!M14*Credits!$D$4+Credits!M16*Credits!$D$5+Credits!M18*Credits!$D$6+Credits!M20*Credits!$D$7+Credits!M22*Credits!$D$8+Credits!M24*Credits!$D$9","v":0}]
[24,"Nonresident Credits (FT)",{"$f":"Credits!D15*Credits!$D$4+Credits!D17*Credits!$D$5+Credits!D19*Credits!$D$6+Credits!D21*Credits!$D$7+Credits!D23*Credits!$D$8+Credits!D25*Credits!$D$9","v":0},{"$f":"Credits!E15*Credits!$D$4+Credits!E17*Credits!$D$5+Credits!E19*Credits!$D$6+Credits!E21*Credits!$D$7+Credits!E23*Credits!$D$8+Credits!E25*Credits!$D$9","v":0},{"$f":"Credits!F15*Credits!$D$4+Credits!F17*Credits!$D$5+Credits!F19*Credits!$D$6+Credits!F21*Credits!$D$7+Credits!F23*Credits!$D$8+Credits!F25*Credits!$D$9","v":0},{"$f":"Credits!G15*Credits!$D$4+Credits!G17*Credits!$D$5+Credits!G19*Credits!$D$6+Credits!G21*Credits!$D$7+Credits!G23*Credits!$D$8+Credits!G25*Credits!$D$9","v":0},{"$f":"Credits!H15*Credits!$D$4+Credits!H17*Credits!$D$5+Credits!H19*Credits!$D$6+Credits!H21*Credits!$D$7+Credits!H23*Credits!$D$8+Credits!H25*Credits!$D$9","v":0},{"$f":"Credits!I15*Credits!$D$4+Credits!I17*Credits!$D$5+Credits!I19*Credits!$D$6+Credits!I21*Credits!$D$7+Credits!I23*Credits!$D$8+Credits!I25*Credits!$D$9","v":0},{"$f":"Credits!J15*Credits!$D$4+Credits!J17*Credits!$D$5+Credits!J19*Credits!$D$6+Credits!J21*Credits!$D$7+Credits!J23*Credits!$D$8+Credits!J25*Credits!$D$9","v":0},{"$f":"Credits!K15*Credits!$D$4+Credits!K17*Credits!$D$5+Credits!K19*Credits!$D$6+Credits!K21*Credits!$D$7+Credits!K23*Credits!$D$8+Credits!K25*Credits!$D$9","v":0},{"$f":"Credits!L15*Credits!$D$4+Credits!L17*Credits!$D$5+Credits!L19*Credits!$D$6+Credits!L21*Credits!$D$7+Credits!L23*Credits!$D$8+Credits!L25*Credits!$D$9","v":0},{"$f":"Credits!M15*Credits!$D$4+Credits!M17*Credits!$D$5+Credits!M19*Credits!$D$6+Credits!M21*Credits!$D$7+Credits!M23*Credits!$D$8+Credits!M25*Credits!$D$9","v":0}]
[25,"Resident Credits (PT)",{"$f":"Credits!P14*Credits!$E$4+Credits!P16*Credits!$E$5+Credits!P18*Credits!$E$6+Credits!P20*Credits!$E$7+Credits!P22*Credits!$E$8+Credits!P24*Credits!$E$9","v":0},{"$f":"Credits!Q14*Credits!$E$4+Credits!Q16*Credits!$E$5+Credits!Q18*Credits!$E$6+Credits!Q20*Credits!$E$7+Credits!Q22*Credits!$E$8+Credits!Q24*Credits!$E$9","v":0},{"$f":"Credits!R14*Credits!$E$4+Credits!R16*Credits!$E$5+Credits!R18*Credits!$E$6+Credits!R20*Credits!$E$7+Credits!R22*Credits!$E$8+Credits!R24*Credits!$E$9","v":0},{"$f":"Credits!S14*Credits!$E$4+Credits!S16*Credits!$E$5+Credits!S18*Credits!$E$6+Credits!S20*Credits!$E$7+Credits!S22*Credits!$E$8+Credits!S24*Credits!$E$9","v":0},{"$f":"Credits!T14*Credits!$E$4+Credits!T16*Credits!$E$5+Credits!T18*Credits!$E$6+Credits!T20*Credits!$E$7+Credits!T22*Credits!$E$8+Credits!T24*Credits!$E$9","v":0},{"$f":"Credits!U14*Credits!$E$4+Credits!U16*Credits!$E$5+Credits!U18*Credits!$E$6+Credits!U20*Credits!$E$7+Credits!U22*Credits!$E$8+Credits!U24*Credits!$E$9","v":0},{"$f":"Credits!V14*Credits!$E$4+Credits!V16*Credits!$E$5+Credits!V18*Credits!$E$6+Credits!V20*Credits!$E$7+Credits!V22*Credits!$E$8+Credits!V24*Credits!$E$9","v":0},{"$f":"Credits!W14*Credits!$E$4+Credits!W16*Credits!$E$5+Credits!W18*Credits!$E$6+Credits!W20*Credits!$E$7+Credits!W22*Credits!$E$8+Credits!W24*Credits!$E$9","v":0},{"$f":"Credits!X14*Credits!$E$4+Credits!X16*Credits!$E$5+Credits!X18*Credits!$E$6+Credits!X20*Credits!$E$7+Credits!X22*Credits!$E$8+Credits!X24*Credits!$E$9","v":0},{"$f":"Credits!Y14*Credits!$E$4+Credits!Y16*Credits!$E$5+Credits!Y18*Credits!$E$6+Credits!Y20*Credits!$E$7+Credits!Y22*Credits!$E$8+Credits!Y24*Credits!$E$9","v":0}]
[26,"Nonresident Credits (PT)",{"$f":"Credits!P15*Credits!$E$4+Credits!P17*Credits!$E$5+Credits!P19*Credits!$E$6+Credits!P21*Credits!$E$7+Credits!P23*Credits!$E$8+Credits!P25*Credits!$E$9","v":0},{"$f":"Credits!Q15*Credits!$E$4+Credits!Q17*Credits!$E$5+Credits!Q19*Credits!$E$6+Credits!Q21*Credits!$E$7+Credits!Q23*Credits!$E$8+Credits!Q25*Credits!$E$9","v":0},{"$f":"Credits!R15*Credits!$E$4+Credits!R17*Credits!$E$5+Credits!R19*Credits!$E$6+Credits!R21*Credits!$E$7+Credits!R23*Credits!$E$8+Credits!R25*Credits!$E$9","v":0},{"$f":"Credits!S15*Credits!$E$4+Credits!S17*Credits!$E$5+Credits!S19*Credits!$E$6+Credits!S21*Credits!$E$7+Credits!S23*Credits!$E$8+Credits!S25*Credits!$E$9","v":0},{"$f":"Credits!T15*Credits!$E$4+Credits!T17*Credits!$E$5+Credits!T19*Credits!$E$6+Credits!T21*Credits!$E$7+Credits!T23*Credits!$E$8+Credits!T25*Credits!$E$9","v":0},{"$f":"Credits!U15*Credits!$E$4+Credits!U17*Credits!$E$5+Credits!U19*Credits!$E$6+Credits!U21*Credits!$E$7+Credits!U23*Credits!$E$8+Credits!U25*Credits!$E$9","v":0},{"$f":"Credits!V15*Credits!$E$4+Credits!V17*Credits!$E$5+Credits!V19*Credits!$E$6+Credits!V21*Credits!$E$7+Credits!V23*Credits!$E$8+Credits!V25*Credits!$E$9","v":0},{"$f":"Credits!W15*Credits!$E$4+Credits!W17*Credits!$E$5+Credits!W19*Credits!$E$6+Credits!W21*Credits!$E$7+Credits!W23*Credits!$E$8+Credits!W25*Credits!$E$9","v":0},{"$f":"Credits!X15*Credits!$E$4+Credits!X17*Credits!$E$5+Credits!X19*Credits!$E$6+Credits!X21*Credits!$E$7+Credits!X23*Credits!$E$8+Credits!X25*Credits!$E$9","v":0},{"$f":"Credits!Y15*Credits!$E$4+Credits!Y17*Credits!$E$5+Credits!Y19*Credits!$E$6+Credits!Y21*Credits!$E$7+Credits!Y23*Credits!$E$8+Credits!Y25*Credits!$E$9","v":0}]
[27,"Total Credits",{"$f":"SUM(C23:C26)","v":0},{"$f":"SUM(D23:D26)","v":0},0,0,0,0,0,0,0,0]
[28,"Tuition Revenue",{"$f":"(C23+C25)*$C$6+(C24+C26)*$C$7","v":0},0,0,0,0,0,0,0,0,0]
[29,"Tuition Discount",{"$f":"C28*$C$9","v":0},{"$f":"D28*$C$9","v":0},{"$f":"E28*$C$9","v":0},0,0,0,0,0,0,{"$f":"L28*$C$9","v":0}]
[30,"Tuition Waivers",{"$f":"C28*$C$10","v":0},{"$f":"D28*$C$10","v":0},{"$f":"E28*$C$10","v":0},{"$f":"F28*$C$10","v":0},{"$f":"G28*$C$10","v":0},0,0,0,0,{"$f":"L28*$C$10","v":0}]
[31,"Net Tuition",{"$f":"C28-C29-C30","v":0},{"$f":"D28-D29-D30","v":0},0,0,0,0,0,0,0,0]
[32,"Training Grant (revenue)",null,null,null,null,null,null,null,null,null,null,"Enter per year training grant"]
[33,"Total Revenue",{"$f":"C31+C32","v":0},{"$f":"D31+D32","v":0},0,0,0,0,0,0,0,0]
[34,"Campus Share",{"$f":"(C31)*$F$10","v":0},{"$f":"(D31)*$F$10","v":0},0,0,0,0,0,0,0,0]
[35,"School / College Share",{"$f":"IF($F$6=\"Net Revenue\",(C31)*$F$11,((C31+C32-C34-C36-C37-C38-C47)*$F$11))","v":0},{"$f":"IF($F$6=\"Net Revenue\",(D31)*$F$11,((D31+D32-D34-D36-D37-D38-D47)*$F$11))","v":0},0,0,0,0,0,0,0,0]
[36,"Instructional Cost",{"$f":"'Salaries & Wages'!R39+'Sub-Agreements'!G29+'Supplies & Services'!D29+'Tuition Remission'!B9","v":0},{"$f":"'Salaries & Wages'!S39+'Sub-Agreements'!H29+'Supplies & Services'!E29+'Tuition Remission'!C9","v":0},{"$f":"'Salaries & Wages'!T39+'Sub-Agreements'!I29+'Supplies & Services'!F29+'Tuition Remission'!D9","v":0},{"$f":"'Salaries & Wages'!U39+'Sub-Agreements'!J29+'Supplies & Services'!G29+'Tuition Remission'!E9","v":0},{"$f":"'Salaries & Wages'!V39+'Sub-Agreements'!K29+'Supplies & Services'!H29+'Tuition Remission'!F9","v":0},{"$f":"'Salaries & Wages'!W39+'Sub-Agreements'!L29+'Supplies & Services'!I29+'Tuition Remission'!G9","v":0},{"$f":"'Salaries & Wages'!X39+'Sub-Agreements'!M29+'Supplies & Services'!J29+'Tuition Remission'!H9","v":0},{"$f":"'Salaries & Wages'!Y39+'Sub-Agreements'!N29+'Supplies & Services'!K29+'Tuition Remission'!I9","v":0},{"$f":"'Salaries & Wages'!Z39+'Sub-Agreements'!O29+'Supplies & Services'!L29+'Tuition Remission'!J9","v":0},{"$f":"'Salaries & Wages'!AA39+'Sub-Agreements'!P29+'Supplies & Services'!M29+'Tuition Remission'!K9","v":0}]
[37,"Training Grant cost",null,null,null,null,null,null,null,null,null,null,"Enter costs associated with training grant"]
[38,"Support Cost",{"$f":"'Salaries & Wages'!R40+'Sub-Agreements'!G30+'Supplies & Services'!D30","v":0},{"$f":"'Salaries & Wages'!S40+'Sub-Agreements'!H30+'Supplies & Services'!E30","v":0},{"$f":"'Salaries & Wages'!T40+'Sub-Agreements'!I30+'Supplies & Services'!F30","v":0},{"$f":"'Salaries & Wages'!U40+'Sub-Agreements'!J30+'Supplies & Services'!G30","v":0},{"$f":"'Salaries & Wages'!V40+'Sub-Agreements'!K30+'Supplies & Services'!H30","v":0},{"$f":"'Salaries & Wages'!W40+'Sub-Agreements'!L30+'Supplies & Services'!I30","v":0},{"$f":"'Salaries & Wages'!X40+'Sub-Agreements'!M30+'Supplies & Services'!J30","v":0},{"$f":"'Salaries & Wages'!Y40+'Sub-Agreements'!N30+'Supplies & Services'!K30","v":0},{"$f":"'Salaries & Wages'!Z40+'Sub-Agreements'!O30+'Supplies & Services'!L30","v":0},{"$f":"'Salaries & Wages'!AA40+'Sub-Agreements'!P30+'Supplies & Services'!M30","v":0}]
[39,"Operating Margin - Department",{"$f":"C33-C34-C35-C36-C38-C37","v":0},{"$f":"D33-D34-D35-D36-D38-D37","v":0},0,0,0,0,0,0,0,0]
[40,"Incremental Margin",null,{"$f":"D39-C39","v":0},{"$f":"E39-D39","v":0},{"$f":"F39-E39","v":0},0,{"$f":"H39-G39","v":0},0,0,0,0]
[41]
[42,"Program Investments"]
[43,"Program Development",{"$f":"'Supplies & Services'!D31+'Salaries & Wages'!R43","v":0},{"$f":"'Supplies & Services'!E31+'Salaries & Wages'!S43","v":0},{"$f":"'Supplies & Services'!F31+'Salaries & Wages'!T43","v":0},{"$f":"'Supplies & Services'!G31+'Salaries & Wages'!U43","v":0},{"$f":"'Supplies & Services'!H31+'Salaries & Wages'!V43","v":0},{"$f":"'Supplies & Services'!I31+'Salaries & Wages'!W43","v":0},{"$f":"'Supplies & Services'!J31+'Salaries & Wages'!X43","v":0},{"$f":"'Supplies & Services'!K31+'Salaries & Wages'!Y43","v":0},{"$f":"'Supplies & Services'!L31+'Salaries & Wages'!Z43","v":0},{"$f":"'Supplies & Services'!M31+'Salaries & Wages'!AA43","v":0}]
[44,"Program Development - DCS / Campus",{"$f":"'Supplies & Services'!D32+'Salaries & Wages'!R42","v":0},{"$f":"'Supplies & Services'!E32+'Salaries & Wages'!S42","v":0},{"$f":"'Supplies & Services'!F32+'Salaries & Wages'!T42","v":0},{"$f":"'Supplies & Services'!G32+'Salaries & Wages'!U42","v":0},{"$f":"'Supplies & Services'!H32+'Salaries & Wages'!V42","v":0},{"$f":"'Supplies & Services'!I32+'Salaries & Wages'!W42","v":0},{"$f":"'Supplies & Services'!J32+'Salaries & Wages'!X42","v":0},{"$f":"'Supplies & Services'!K32+'Salaries & Wages'!Y42","v":0},{"$f":"'Supplies & Services'!L32+'Salaries & Wages'!Z42","v":0},{"$f":"'Supplies & Services'!M32+'Salaries & Wages'!AA42","v":0}]
[45,"Course Development",{"$f":"'Curriculum Development'!E24","v":15000},{"$f":"'Curriculum Development'!F24","v":4500},{"$f":"'Curriculum Development'!G24","v":4500},{"$f":"'Curriculum Development'!H24","v":4500},{"$f":"'Curriculum Development'!I24","v":4500},{"$f":"'Curriculum Development'!J24","v":4500},{"$f":"'Curriculum Development'!K24","v":4500},{"$f":"'Curriculum Development'!L24","v":4500},{"$f":"'Curriculum Development'!M24","v":4500},{"$f":"'Curriculum Development'!N24","v":4500}]
[46,"Marketing",{"$f":"$C$11*SUM(Credits!D14:D15,Credits!P14:P15)+'Supplies & Services'!D33+'Salaries & Wages'!R41","v":0},{"$f":"$C$11*SUM(Credits!E14:E15,Credits!Q14:Q15)+'Supplies & Services'!E33+'Salaries & Wages'!S41","v":0},{"$f":"$C$11*SUM(Credits!F14:F15,Credits!R14:R15)+'Supplies & Services'!F33+'Salaries & Wages'!T41","v":0},{"$f":"$C$11*SUM(Credits!G14:G15,Credits!S14:S15)+'Supplies & Services'!G33+'Salaries & Wages'!U41","v":0},{"$f":"$C$11*SUM(Credits!H14:H15,Credits!T14:T15)+'Supplies & Services'!H33+'Salaries & Wages'!V41","v":0},{"$f":"$C$11*SUM(Credits!I14:I15,Credits!U14:U15)+'Supplies & Services'!I33+'Salaries & Wages'!W41","v":0},{"$f":"$C$11*SUM(Credits!J14:J15,Credits!V14:V15)+'Supplies & Services'!J33+'Salaries & Wages'!X41","v":0},{"$f":"$C$11*SUM(Credits!K14:K15,Credits!W14:W15)+'Supplies & Services'!K33+'Salaries & Wages'!Y41","v":0},{"$f":"$C$11*SUM(Credits!L14:L15,Credits!X14:X15)+'Supplies & Services'!L33+'Salaries & Wages'!Z41","v":0},{"$f":"$C$11*SUM(Credits!M14:M15,Credits!Y14:Y15)+'Supplies & Services'!M33+'Salaries & Wages'!AA41","v":0}]
[47,"Total Program Investment",{"$f":"SUM(C42:C46)","v":15000},{"$f":"SUM(D42:D46)","v":4500},{"$f":"SUM(E42:E46)","v":4500},4500,4500,4500,4500,4500,4500,{"$f":"SUM(L42:L46)","v":4500}]
[48]
[49,"Total Operating Margin",{"$f":"C31-SUM(C34:C38)-C47","v":-15000},{"$f":"D31-SUM(D34:D38)-D47","v":-4500},-4500,-4500,-4500,-4500,-4500,-4500,-4500,-4500]
[50,null,null,{"$f":"IF(D49<0,\"-\",ABS(C49/SUM($C$47:D47)))","v":"-"},{"$f":"IF(E49<0,\"-\",ABS(D49/SUM($C$47:E47)))","v":"-"},{"$f":"IF(F49<0,\"-\",ABS(E49/SUM($C$47:F47)))","v":"-"},{"$f":"IF(G49<0,\"-\",ABS(F49/SUM($C$47:G47)))","v":"-"},{"$f":"IF(H49<0,\"-\",ABS(G49/SUM($C$47:H47)))","v":"-"},{"$f":"IF(I49<0,\"-\",ABS(H49/SUM($C$47:I47)))","v":"-"},{"$f":"IF(J49<0,\"-\",ABS(I49/SUM($C$47:J47)))","v":"-"},{"$f":"IF(K49<0,\"-\",ABS(J49/SUM($C$47:K47)))","v":"-"},{"$f":"IF(L49<0,\"-\",ABS(K49/SUM($C$47:L47)))","v":"-"}]
[51,"Payback (unit investment)",null,{"$f":"CONCATENATE(ROUND(COUNTIF(C49:L49,\"<\"&0)+INDEX(C50:L50,,COUNTIF(C49:K49,\"<\"&0)+1),2),\" years\")","v":{"$error":"#VALUE!"}}]
[52]
[53,"Investment Margin - Department",{"$f":"C49","v":-15000},{"$f":"D49","v":-4500},-4500,-4500,-4500,-4500,-4500,-4500,-4500,-4500]
[54]
[55,"Department Investments (using the margin) - notional example"]
[56,"Department Salaries",{"$f":"'Investing the Margin'!D27","v":0},{"$f":"'Investing the Margin'!E27","v":0},{"$f":"'Investing the Margin'!F27","v":0},{"$f":"'Investing the Margin'!G27","v":0},{"$f":"'Investing the Margin'!H27","v":0},{"$f":"'Investing the Margin'!I27","v":0},{"$f":"'Investing the Margin'!J27","v":0},{"$f":"'Investing the Margin'!K27","v":0},{"$f":"'Investing the Margin'!L27","v":0},{"$f":"'Investing the Margin'!M27","v":0}]
[57,"New Faculty Lines",{"$f":"'Investing the Margin'!D28","v":0},{"$f":"'Investing the Margin'!E28","v":0},{"$f":"'Investing the Margin'!F28","v":0},{"$f":"'Investing the Margin'!G28","v":0},{"$f":"'Investing the Margin'!H28","v":0},{"$f":"'Investing the Margin'!I28","v":0},{"$f":"'Investing the Margin'!J28","v":0},{"$f":"'Investing the Margin'!K28","v":0},{"$f":"'Investing the Margin'!L28","v":0},{"$f":"'Investing the Margin'!M28","v":0}]
[58,"Additional TA Positions or Scholarships",{"$f":"'Investing the Margin'!D29","v":0},{"$f":"'Investing the Margin'!E29","v":0},{"$f":"'Investing the Margin'!F29","v":0},{"$f":"'Investing the Margin'!G29","v":0},{"$f":"'Investing the Margin'!H29","v":0},{"$f":"'Investing the Margin'!I29","v":0},{"$f":"'Investing the Margin'!J29","v":0},{"$f":"'Investing the Margin'!K29","v":0},{"$f":"'Investing the Margin'!L29","v":0},{"$f":"'Investing the Margin'!M29","v":0}]
[59,"Professional Development",{"$f":"'Investing the Margin'!D30","v":0},{"$f":"'Investing the Margin'!E30","v":0},{"$f":"'Investing the Margin'!F30","v":0},{"$f":"'Investing the Margin'!G30","v":0},{"$f":"'Investing the Margin'!H30","v":0},{"$f":"'Investing the Margin'!I30","v":0},{"$f":"'Investing the Margin'!J30","v":0},{"$f":"'Investing the Margin'!K30","v":0},{"$f":"'Investing the Margin'!L30","v":0},{"$f":"'Investing the Margin'!M30","v":0}]
[60,"Other",{"$f":"'Investing the Margin'!D31","v":0},{"$f":"'Investing the Margin'!E31","v":0},{"$f":"'Investing the Margin'!F31","v":0},{"$f":"'Investing the Margin'!G31","v":0},{"$f":"'Investing the Margin'!H31","v":0},{"$f":"'Investing the Margin'!I31","v":0},{"$f":"'Investing the Margin'!J31","v":0},{"$f":"'Investing the Margin'!K31","v":0},{"$f":"'Investing the Margin'!L31","v":0},{"$f":"'Investing the Margin'!M31","v":0}]
[61,"Surplus",{"$f":"C53-SUM(C56:C60)","v":-15000},-4500,-4500,-4500,-4500,-4500,-4500,-4500,-4500,-4500]
[62]
[63,"Total Enrollment",{"$f":"SUM(Credits!D14:D15,Credits!P14:P15)","v":0},{"$f":"SUM(Credits!E14:E15,Credits!Q14:Q15)","v":0},{"$f":"SUM(Credits!F14:F15,Credits!R14:R15)","v":0},{"$f":"SUM(Credits!G14:G15,Credits!S14:S15)","v":0},{"$f":"SUM(Credits!H14:H15,Credits!T14:T15)","v":0},{"$f":"SUM(Credits!I14:I15,Credits!U14:U15)","v":0},{"$f":"SUM(Credits!J14:J15,Credits!V14:V15)","v":0},{"$f":"SUM(Credits!K14:K15,Credits!W14:W15)","v":0},{"$f":"SUM(Credits!L14:L15,Credits!X14:X15)","v":0},{"$f":"SUM(Credits!M14:M15,Credits!Y14:Y15)","v":0}]
[64]
[65,"Instructions & notes"]
[66,"Data should be entered only in the cells shaded in green"]
[67,"Incremental margin reflects new margin above prior year"]
[68,"Program development costs should reflect the investment from campus and Division of Continuing Studies"]
[69,"Marketing cost to acquire new students should be $3,000 or more."]
[70]
[71]
[72]
[73]
[74]
[75]
[{"$f":"A75+1","v":76}]
[77]
[78]
[79,"Years"]
[80,2018]
[81,2019]
[82,2020]
[83,2021]
[84,2022]
[85,2023]
[86,2024]
[87,2025]
[88,2026]
[89,2027]
[90]
[91]
[92]
[93]

{"sheet":"Credits","index":3,"n_rows":87,"n_cols":25,"rows_kept":87,"cut":false,"hidden":false,"merged":[[1,3,1,4],[11,15,11,24],[11,3,11,12],[13,1,14,1]]}
[1,null,"Instructions: Enter credits and Enrollment Total in each green box"]
[{"$f":"A1+1","v":2},null,null,"Credit Load"]
[{"$f":"A2+1","v":3},null,null,"Full time","Part-time"]
[4,null,"Year 1 -->",30,15,"<-- Year 1"]
[5,null,{"$f":"IF('131 Program Summary'!$F$3>1, \"Year 2 -->\",\"\")","v":""},null,15,{"$f":"IF('131 Program Summary'!$F$4>1, \"<-- Year 2\",\"\")","v":"<-- Year 2"}]
[6,null,{"$f":"IF('131 Program Summary'!$F$3>2, \"Year 3 -->\",\"\")","v":""},null,null,{"$f":"IF('131 Program Summary'!$F$4>2, \"<-- Year 3\",\"\")","v":""}]
[7,null,{"$f":"IF('131 Program Summary'!$F$3>3, \"Year 4 -->\",\"\")","v":""},null,null,{"$f":"IF('131 Program Summary'!$F$4>3, \"<-- Year 4\",\"\")","v":""}]
[8,null,{"$f":"IF('131 Program Summary'!$F$3>4, \"Year 5 -->\",\"\")","v":""},null,null,{"$f":"IF('131 Program Summary'!$F$4>4, \"<-- Year 5\",\"\")","v":""}]
[9,null,{"$f":"IF('131 Program Summary'!$F$3>5, \"Year 6 -->\",\"\")","v":""},null,null,{"$f":"IF('131 Program Summary'!$F$4>5, \"<-- Year 6\",\"\")","v":""}]
[10,null,null,{"$f":"SUM(D4:D9)","v":30},{"$f":"SUM(E4:E9)","v":30}]
[11]
[12,null,null,"Enrollment By Year (Full Time)",null,null,null,null,null,null,null,null,null,null,null,"Enrollment By Year (Part Time)"]
[13,null,null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029},null,null,{"$f":"D13","v":2020},{"$f":"E13","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[14,null,"Program Year 1 - Resident",0,0,0,0,0,0,0,0,0,0,null,"Program Year 1 - Resident",0,0,0,0,0,0,0,0,0,0]
[15,null,"Program Year 1 - Nonresident",0,0,0,0,0,0,0,0,0,0,null,"Program Year 1 - Nonresident",0,0,0,0,0,0,0,0,0,0]
[16,null,{"$f":"IF(C5=\"Year 2 -->\",\"Program Year 2 - Resident\",\"\")","v":""},null,{"$f":"IF(ISBLANK($D5),0,D14)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF(F5=\"<-- Year 2\",\"Program Year 2 - Resident\",\"\")","v":"Program Year 2 - Resident"},null,{"$f":"IF(ISBLANK($E5),0,P14)","v":0},0,0,0,0,0,0,0,0]
[17,null,{"$f":"IF(C5=\"Year 2 -->\",\"Program Year 2 - Nonresident\",\"\")","v":""},null,{"$f":"IF(ISBLANK($D5),0,D15)","v":0},0,0,0,0,0,0,0,0,null,{"$f":"IF(F5=\"<-- Year 2\",\"Program Year 2 - Nonresident\",\"\")","v":"Program Year 2 - Nonresident"},null,{"$f":"IF(ISBLANK($E5),0,P15)","v":0},0,0,0,0,0,0,0,0]
[18,null,{"$f":"IF(C6=\"Year 3 -->\",\"Program Year 3 - Resident\",\"\")","v":""},null,null,{"$f":"IF(ISBLANK($D6),0,E16)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(F6=\"<-- Year 3\",\"Program Year 3 - Resident\",\"\")","v":""},null,null,{"$f":"IF(ISBLANK($E6),0,Q16)","v":0},0,0,0,0,0,0,0]
[19,null,{"$f":"IF(C6=\"Year 3 -->\",\"Program Year 3 - Nonresident\",\"\")","v":""},null,null,{"$f":"IF(ISBLANK($D6),0,E17)","v":0},0,0,0,0,0,0,0,null,{"$f":"IF(F6=\"<-- Year 3\",\"Program Year 3 - Nonresident\",\"\")","v":""},null,null,{"$f":"IF(ISBLANK($E6),0,Q17)","v":0},0,0,0,0,0,0,0]
[20,null,{"$f":"IF(C7=\"Year 4 -->\",\"Program Year 4 - Resident\",\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK($D7),0,F18)","v":0},0,0,0,0,0,0,null,{"$f":"IF(F7=\"<-- Year 4\",\"Program Year 4 - Resident\",\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK($E7),0,R18)","v":0},0,0,0,0,0,0]
[21,null,{"$f":"IF(C7=\"Year 4 -->\",\"Program Year 4 - Nonresident\",\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK($D7),0,F19)","v":0},0,0,0,0,0,0,null,{"$f":"IF(F7=\"<-- Year 4\",\"Program Year 4 - Nonresident\",\"\")","v":""},null,null,null,{"$f":"IF(ISBLANK($E7),0,R19)","v":0},0,0,0,0,0,0]
[22,null,{"$f":"IF(C8=\"Year 5 -->\",\"Program Year 5 - Resident\",\"\")","v":""},null,null,null,null,{"$f":"IF(ISBLANK($D8),0,G20)","v":0},0,0,0,0,0,null,{"$f":"IF(F8=\"<-- Year 5\",\"Program Year 5 - Resident\",\"\")","v":""},null,null,null,null,{"$f":"IF(ISBLANK($E8),0,S20)","v":0},0,0,0,0,0]
[23,null,{"$f":"IF(C8=\"Year 5 -->\",\"Program Year 5 - Nonresident\",\"\")","v":""},null,null,null,null,{"$f":"IF(ISBLANK($D8),0,G21)","v":0},0,0,0,0,0,null,{"$f":"IF(F8=\"<-- Year 5\",\"Program Year 5 - Nonresident\",\"\")","v":""},null,null,null,null,{"$f":"IF(ISBLANK($E8),0,S21)","v":0},0,0,0,0,0]
[24,null,{"$f":"IF(C9=\"Year 6 -->\",\"Program Year 6 - Resident\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($D9),0,H22)","v":0},{"$f":"IF(ISBLANK($D9),0,I22)","v":0},{"$f":"IF(ISBLANK($D9),0,J22)","v":0},{"$f":"IF(ISBLANK($D9),0,K22)","v":0},{"$f":"IF(ISBLANK($D9),0,L22)","v":0},null,{"$f":"IF(F9=\"<-- Year 6\",\"Program Year 6 - Resident\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($E9),0,T22)","v":0},{"$f":"IF(ISBLANK($E9),0,U22)","v":0},{"$f":"IF(ISBLANK($E9),0,V22)","v":0},{"$f":"IF(ISBLANK($E9),0,W22)","v":0},{"$f":"IF(ISBLANK($E9),0,X22)","v":0}]
[25,null,{"$f":"IF(C9=\"Year 6 -->\",\"Program Year 6 - Nonresident\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($D9),0,H23)","v":0},{"$f":"IF(ISBLANK($D9),0,I23)","v":0},{"$f":"IF(ISBLANK($D9),0,J23)","v":0},{"$f":"IF(ISBLANK($D9),0,K23)","v":0},{"$f":"IF(ISBLANK($D9),0,L23)","v":0},null,{"$f":"IF(F9=\"<-- Year 6\",\"Program Year 6 - Nonresident\",\"\")","v":""},null,null,null,null,null,{"$f":"IF(ISBLANK($E9),0,T23)","v":0},{"$f":"IF(ISBLANK($E9),0,U23)","v":0},{"$f":"IF(ISBLANK($E9),0,V23)","v":0},{"$f":"IF(ISBLANK($E9),0,W23)","v":0},{"$f":"IF(ISBLANK($E9),0,X23)","v":0}]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"A66+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]

{"sheet":"Curriculum Development","index":4,"n_rows":30,"n_cols":14,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,3],[18,0,18,3]]}
["Worksheet for Curriculum",null,null,null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029}]
["Course name","Credits","Type","Year of Development",{"$f":"CONCATENATE(E1,\"              \",\"Development Cost (standard $30,000, transition $15,000, and 15% maintenance)\")","v":"2020              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)"},{"$f":"CONCATENATE(F1,\"              \",\"Development Cost (standard $30,000, transition $15,000, and 15% maintenance)\")","v":"2021              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)"},"2022              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2023              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2024              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2025              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2026              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2027              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2028              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)","2029              Development Cost (standard $30,000, transition $15,000, and 15% maintenance)"]
[]
["Course 1",null,"Transition",2020,{"$f":"IF(ISBLANK($A4),\"\",IF(E$1<$D4,\"\",IF(E$1>$D4,30000*0.15,IF($C4=\"Maintenance\",30000*0.15,IF($C4=\"New\",30000,15000)))))","v":15000},{"$f":"IF(ISBLANK($A4),\"\",IF(F$1<$D4,\"\",IF(F$1>$D4,30000*0.15,IF($C4=\"Maintenance\",30000*0.15,IF($C4=\"New\",30000,15000)))))","v":4500},4500,4500,4500,4500,4500,4500,4500,4500]
[null,null,null,null,{"$f":"IF(ISBLANK($A5),\"\",IF(E$1<$D5,\"\",IF(E$1>$D5,30000*0.15,IF($C5=\"Maintenance\",30000*0.15,IF($C5=\"New\",30000,15000)))))","v":""},"","","","","","","","",""]
[null,null,null,null,{"$f":"IF(ISBLANK($A6),\"\",IF(E$1<$D6,\"\",IF(E$1>$D6,30000*0.15,IF($C6=\"Maintenance\",30000*0.15,IF($C6=\"New\",30000,15000)))))","v":""},"","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
[null,null,null,null,"","","","","","","","","",""]
["Insert Here"]
["Total",null,null,null,{"$f":"SUM(E4:E18)","v":15000},4500,4500,{"$f":"SUM(H4:H18)","v":4500},4500,4500,4500,4500,4500,4500]
[]
[]
[]
[null,null,null,null,{"$f":"E1","v":2020},{"$f":"F1","v":2021},2022,2023,2024,2025,2026,2027,2028,2029]
[null,null,null,null,{"$f":"E19","v":15000},{"$f":"F19","v":4500},4500,4500,4500,4500,4500,4500,4500,4500]
[]
[]
[]
["Notes"]
["Must populate green in column A"]
["You may override the development cost or the maintenance cost."]

{"sheet":"Salaries & Wages","index":5,"n_rows":52,"n_cols":50,"rows_kept":52,"cut":false,"hidden":false,"merged":[[1,46,1,49],[38,12,41,14],[1,26,1,29],[1,30,1,33],[1,34,1,37],[1,38,1,41],[1,42,1,45],[1,18,1,21],[1,22,1,25],[0,0,0,2],[27,0,28,15],[43,1,43,2],[1,10,1,13],[1,14,1,17]]}
["Worksheet for Salaries & Wages"]
[null,"Note: Open + for each year to fill in additional data",null,null,null,null,null,null,null,null,{"$f":"'131 Program Summary'!C22","v":2020},null,null,null,{"$f":"'131 Program Summary'!D22","v":2021},null,null,null,{"$f":"'131 Program Summary'!E22","v":2022},null,null,null,{"$f":"'131 Program Summary'!F22","v":2023},null,null,null,{"$f":"'131 Program Summary'!G22","v":2024},null,null,null,{"$f":"'131 Program Summary'!H22","v":2025},null,null,null,{"$f":"'131 Program Summary'!I22","v":2026},null,null,null,{"$f":"'131 Program Summary'!J22","v":2027},null,null,null,{"$f":"'131 Program Summary'!K22","v":2028},null,null,null,{"$f":"'131 Program Summary'!L22","v":2029}]
["Name","Title","Type","Employee Type","Role Description (free form)","Salary / Wage","Pay Basis","Fringe Rate","Compensation Escalator",null,"Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost","Months","Effort","Requested Salary","Total Cost"]
[]
[null,null,"Program Development - Startup (DCS / Campus)","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*K5*L5))),0)","v":0},{"$f":"SUMPRODUCT(M5,1+$H5)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*O5*P5))),0)","v":0},{"$f":"SUMPRODUCT(Q5,1+$H5)*(1+$I5^1)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*S5*T5))),0)","v":0},{"$f":"SUMPRODUCT(U5,1+$H5)*((1+$I5)^2)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*W5*X5))),0)","v":0},{"$f":"SUMPRODUCT(Y5,1+$H5)*((1+$I5)^3)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AA5*AB5))),0)","v":0},{"$f":"SUMPRODUCT(AC5,1+$H5)*((1+$I5)^4)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AE5*AF5))),0)","v":0},{"$f":"SUMPRODUCT(AG5,1+$H5)*((1+$I5)^5)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AI5*AJ5))),0)","v":0},{"$f":"SUMPRODUCT(AK5,1+$H5)*((1+$I5)^6)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AM5*AN5))),0)","v":0},{"$f":"SUMPRODUCT(AO5,1+$H5)*((1+$I5)^7)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AQ5*AR5))),0)","v":0},{"$f":"SUMPRODUCT(AS5,1+$H5)*((1+$I5)^8)","v":0},12,1,{"$f":"ROUND((IF($G5=\"Hourly (H basis)\",$F5,($F5/IF($G5=\"Annual (A basis)\",12,9)*AU5*AV5))),0)","v":0},{"$f":"SUMPRODUCT(AW5,1+$H5)*((1+$I5)^9)","v":0}]
[null,null,"Program Marketing","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D6,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*K6*L6))),0)","v":0},{"$f":"SUMPRODUCT(M6,1+$H6)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*O6*P6))),0)","v":0},{"$f":"SUMPRODUCT(Q6,1+$H6)*(1+$I6^1)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*S6*T6))),0)","v":0},{"$f":"SUMPRODUCT(U6,1+$H6)*((1+$I6)^2)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*W6*X6))),0)","v":0},{"$f":"SUMPRODUCT(Y6,1+$H6)*((1+$I6)^3)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AA6*AB6))),0)","v":0},{"$f":"SUMPRODUCT(AC6,1+$H6)*((1+$I6)^4)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AE6*AF6))),0)","v":0},{"$f":"SUMPRODUCT(AG6,1+$H6)*((1+$I6)^5)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AI6*AJ6))),0)","v":0},{"$f":"SUMPRODUCT(AK6,1+$H6)*((1+$I6)^6)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AM6*AN6))),0)","v":0},{"$f":"SUMPRODUCT(AO6,1+$H6)*((1+$I6)^7)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AQ6*AR6))),0)","v":0},{"$f":"SUMPRODUCT(AS6,1+$H6)*((1+$I6)^8)","v":0},12,1,{"$f":"ROUND((IF($G6=\"Hourly (H basis)\",$F6,($F6/IF($G6=\"Annual (A basis)\",12,9)*AU6*AV6))),0)","v":0},{"$f":"SUMPRODUCT(AW6,1+$H6)*((1+$I6)^9)","v":0}]
[null,null,"Instructional","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D7,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,{"$f":"ROUND((IF($G7=\"Hourly (H basis)\",$F7,($F7/IF($G7=\"Annual (A basis)\",12,9)*K7*L7))),0)","v":0},0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Program Development - Startup (DCS / Campus)","RA / PA / TA",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D8,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,0.5,{"$f":"ROUND((IF($G8=\"Hourly (H basis)\",$F8,($F8/IF($G8=\"Annual (A basis)\",12,9)*K8*L8))),0)","v":0},0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,1,0,0,12,0.5,0,0,12,0.5,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Program Development - Startup (DCS / Campus)","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D9,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Program Support","Unversity Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D10,$B$45:$C$48,2),\"\")","v":0.42499999999999999},"2%",null,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Program Development - Startup","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D11,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,{"$f":"ROUND((IF($G11=\"Hourly (H basis)\",$F11,($F11/IF($G11=\"Annual (A basis)\",12,9)*K11*L11))),0)","v":0},0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,{"$f":"SUMPRODUCT(AO11,1+$H11)*((1+$I11)^7)","v":0},12,1,0,0,12,1,0,0]
[null,null,"Program Marketing","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D12,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,{"$f":"ROUND((IF($G12=\"Hourly (H basis)\",$F12,($F12/IF($G12=\"Annual (A basis)\",12,9)*K12*L12))),0)","v":0},0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Instructional","Faculty / Academic Staff",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D13,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0,12,1,0,0]
[null,null,"Instructional","RA / PA / TA",null,null,"Annual (A basis)",{"$f":"IFERROR(VLOOKUP($D14,$B$45:$C$48,2),\"\")","v":0.33329999999999999},"2%",null,12,0.5,0,0,12,0.5,0,{"$f":"SUMPRODUCT(Q14,1+$H14)*(1+$I14^1)","v":0},12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0,12,0.5,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,{"$f":"SUMPRODUCT(AG20,1+$H20)*((1+$I20)^5)","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[null,null,null,null,null,null,null,null,"2%",null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
["Insert Here"]
[]
[]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,M31,N$5:N$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,Q31,R$5:R$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,U31,$V$5:V24)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,Y31,Z$5:Z$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AC31,AD$5:AD$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AG31,AH$5:AH$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AK31,AL$5:AL$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AO31,AP$5:AP$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AS31,AT$5:AT$25)","v":0},null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AW31,AX$5:AX$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,M32,N$5:N$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,Q32,R$5:R$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,U32,$V$5:V24)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,Y32,Z$5:Z$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AC32,AD$5:AD$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AG32,AH$5:AH$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AK32,AL$5:AL$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AO32,AP$5:AP$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AS32,AT$5:AT$25)","v":0},null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AW32,AX$5:AX$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,M33,N$5:N$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,Q33,R$5:R$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,U33,$V$5:V24)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,Y33,Z$5:Z$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AC33,AD$5:AD$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AG33,AH$5:AH$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AK33,AL$5:AL$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AO33,AP$5:AP$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AS33,AT$5:AT$25)","v":0},null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AW33,AX$5:AX$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,M34,N$5:N$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,Q34,R$5:R$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,U34,$V$5:V24)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,Y34,Z$5:Z$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AC34,AD$5:AD$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AG34,AH$5:AH$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AK34,AL$5:AL$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AO34,AP$5:AP$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AS34,AT$5:AT$25)","v":0},null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AW34,AX$5:AX$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,M35,N$5:N$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,Q35,R$5:R$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,U35,$V$5:V24)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,Y35,Z$5:Z$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AC35,AD$5:AD$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AG35,AH$5:AH$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AK35,AL$5:AL$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AO35,AP$5:AP$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AS35,AT$5:AT$25)","v":0},null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AW35,AX$5:AX$25)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M31","v":"Instructional"},0,{"$f":"R31","v":0},{"$f":"V31","v":0},{"$f":"Z31","v":0},{"$f":"AD31","v":0},{"$f":"AH31","v":0},{"$f":"AL31","v":0},{"$f":"AP31","v":0},{"$f":"AT31","v":0},{"$f":"AX31","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Support",0,{"$f":"R32","v":0},{"$f":"V32","v":0},{"$f":"Z32","v":0},{"$f":"AD32","v":0},{"$f":"AH32","v":0},{"$f":"AL32","v":0},{"$f":"AP32","v":0},{"$f":"AT32","v":0},{"$f":"AX32","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Marketing",0,{"$f":"R33","v":0},{"$f":"V33","v":0},{"$f":"Z33","v":0},{"$f":"AD33","v":0},{"$f":"AH33","v":0},{"$f":"AL33","v":0},{"$f":"AP33","v":0},{"$f":"AT33","v":0},{"$f":"AX33","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Development - Startup (DCS / Campus)",0,{"$f":"R34","v":0},{"$f":"V34","v":0},{"$f":"Z34","v":0},{"$f":"AD34","v":0},{"$f":"AH34","v":0},{"$f":"AL34","v":0},{"$f":"AP34","v":0},{"$f":"AT34","v":0},{"$f":"AX34","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program Development - Startup",0,{"$f":"R35","v":0},{"$f":"V35","v":0},{"$f":"Z35","v":0},{"$f":"AD35","v":0},{"$f":"AH35","v":0},{"$f":"AL35","v":0},{"$f":"AP35","v":0},{"$f":"AT35","v":0},{"$f":"AX35","v":0}]
[null,"Types of Employees and Fringe Rates (illustrative)"]
[null,"Faculty / Academic Staff",0.33329999999999999]
[null,"Student hourly",0.03]
[null,"RA / PA / TA",0.21]
[null,"Unversity Staff",0.42499999999999999]
[]
[null,"Fringe rates from RSP pool"]
[null,"Note - you will want to consider implications of the individual employees (since the 131 program bears actual fringe)"]
[null,"Note - summer fringe expense will be less than this rate"]

{"sheet":"Salaries & Wages - old","index":6,"n_rows":47,"n_cols":87,"rows_kept":47,"cut":false,"hidden":true,"merged":[[0,0,0,2],[43,1,43,2],[27,0,28,10]]}
["Worksheet for Salaries & Wages"]
[null,"Note: Open + for each year to fill in additional data"]
["Name","Title","Type","Employee Type","Role Description (free form)",{"$f":"'131 Program Summary'!C22","v":2020},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!D22","v":2021},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!E22","v":2022},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!F22","v":2023},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!G22","v":2024},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!H22","v":2025},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!I22","v":2026},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!J22","v":2027},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!K22","v":2028},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost",{"$f":"'131 Program Summary'!L22","v":2029},"Pay Basis","Months","Effort","Requested Salary","Fringe Rate","Fringe Benefit","Total Cost"]
[]
["TBN","Faculty","Program Development - Startup (DCS / Campus)","Faculty / Academic Staff",null,100000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(G5=\"Hourly (H basis)\",F5,(F5/IF(G5=\"Annual (A basis)\",12,9)*H5*I5))),0)","v":100000},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((K5*J5),0),\"\")","v":38700},{"$f":"SUM(J5,L5)","v":138700},100000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(O5=\"Hourly (H basis)\",N5,(N5/IF(O5=\"Annual (A basis)\",12,9)*P5*Q5))),0)","v":100000},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((S5*R5),0),\"\")","v":38700},{"$f":"SUM(R5,T5)","v":138700},0,"Annual (A basis)",12,1,{"$f":"ROUND((IF(W5=\"Hourly (H basis)\",V5,(V5/IF(W5=\"Annual (A basis)\",12,9)*X5*Y5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((AA5*Z5),0),\"\")","v":0},{"$f":"SUM(Z5,AB5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AE5=\"Hourly (H basis)\",AD5,(AD5/IF(AE5=\"Annual (A basis)\",12,9)*AF5*AG5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((AI5*AH5),0),\"\")","v":0},{"$f":"SUM(AH5,AJ5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM5=\"Hourly (H basis)\",AL5,(AL5/IF(AM5=\"Annual (A basis)\",12,9)*AN5*AO5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((AQ5*AP5),0),\"\")","v":0},{"$f":"SUM(AP5,AR5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AU5=\"Hourly (H basis)\",AT5,(AT5/IF(AU5=\"Annual (A basis)\",12,9)*AV5*AW5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((AY5*AX5),0),\"\")","v":0},{"$f":"SUM(AX5,AZ5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BC5=\"Hourly (H basis)\",BB5,(BB5/IF(BC5=\"Annual (A basis)\",12,9)*BD5*BE5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((BG5*BF5),0),\"\")","v":0},{"$f":"SUM(BF5,BH5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BK5=\"Hourly (H basis)\",BJ5,(BJ5/IF(BK5=\"Annual (A basis)\",12,9)*BL5*BM5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((BO5*BN5),0),\"\")","v":0},{"$f":"SUM(BN5,BP5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BS5=\"Hourly (H basis)\",BR5,(BR5/IF(BS5=\"Annual (A basis)\",12,9)*BT5*BU5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((BW5*BV5),0),\"\")","v":0},{"$f":"SUM(BV5,BX5)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(CA5=\"Hourly (H basis)\",BZ5,(BZ5/IF(CA5=\"Annual (A basis)\",12,9)*CB5*CC5))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D5,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((CE5*CD5),0),\"\")","v":0},{"$f":"SUM(CD5,CF5)","v":0},null,"Request 3 years"]
["TBN","Faculty","Program Development - Startup (DCS / Campus)","Faculty / Academic Staff",null,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((K6*J6),0),\"\")","v":0},{"$f":"SUM(J6,L6)","v":0},100000,"Annual (A basis)",12,1,100000,0.38700000000000001,{"$f":"IFERROR(ROUND((S6*R6),0),\"\")","v":38700},138700,50000,"Annual (A basis)",12,1,50000,0.38700000000000001,{"$f":"IFERROR(ROUND((AA6*Z6),0),\"\")","v":19350},69350,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((AI6*AH6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM6=\"Hourly (H basis)\",AL6,(AL6/IF(AM6=\"Annual (A basis)\",12,9)*AN6*AO6))),0)","v":0},0.38700000000000001,{"$f":"IFERROR(ROUND((AQ6*AP6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((AY6*AX6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((BG6*BF6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((BO6*BN6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((BW6*BV6),0),\"\")","v":0},0,null,"Annual (A basis)",12,1,0,0.38700000000000001,{"$f":"IFERROR(ROUND((CE6*CD6),0),\"\")","v":0},0,null,"Request 2 years"]
["TBN","Faculty associate","Instructional","Faculty / Academic Staff",null,0,"Annual (A basis)",12,1,{"$f":"ROUND((IF(G7=\"Hourly (H basis)\",F7,(F7/IF(G7=\"Annual (A basis)\",12,9)*H7*I7))),0)","v":0},0.38700000000000001,0,0,80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(O7=\"Hourly (H basis)\",N7,(N7/IF(O7=\"Annual (A basis)\",12,9)*P7*Q7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(R7,T7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(W7=\"Hourly (H basis)\",V7,(V7/IF(W7=\"Annual (A basis)\",12,9)*X7*Y7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(Z7,AB7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AE7=\"Hourly (H basis)\",AD7,(AD7/IF(AE7=\"Annual (A basis)\",12,9)*AF7*AG7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(AH7,AJ7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM7=\"Hourly (H basis)\",AL7,(AL7/IF(AM7=\"Annual (A basis)\",12,9)*AN7*AO7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(AP7,AR7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AU7=\"Hourly (H basis)\",AT7,(AT7/IF(AU7=\"Annual (A basis)\",12,9)*AV7*AW7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(AX7,AZ7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BC7=\"Hourly (H basis)\",BB7,(BB7/IF(BC7=\"Annual (A basis)\",12,9)*BD7*BE7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(BF7,BH7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BK7=\"Hourly (H basis)\",BJ7,(BJ7/IF(BK7=\"Annual (A basis)\",12,9)*BL7*BM7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(BN7,BP7)","v":110960},80000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BS7=\"Hourly (H basis)\",BR7,(BR7/IF(BS7=\"Annual (A basis)\",12,9)*BT7*BU7))),0)","v":80000},0.38700000000000001,30960,{"$f":"SUM(BV7,BX7)","v":110960},80000,"Annual (A basis)",12,1,80000,0.38700000000000001,30960,{"$f":"SUM(CD7,CF7)","v":110960}]
["TBN","Teaching Assistant","Program Development - Startup (DCS / Campus)","RA / PA / TA",null,0,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(G8=\"Hourly (H basis)\",F8,(F8/IF(G8=\"Annual (A basis)\",12,9)*H8*I8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(J8,L8)","v":0},0,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(O8=\"Hourly (H basis)\",N8,(N8/IF(O8=\"Annual (A basis)\",12,9)*P8*Q8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(R8,T8)","v":0},0,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(W8=\"Hourly (H basis)\",V8,(V8/IF(W8=\"Annual (A basis)\",12,9)*X8*Y8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(Z8,AB8)","v":0},null,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(AE8=\"Hourly (H basis)\",AD8,(AD8/IF(AE8=\"Annual (A basis)\",12,9)*AF8*AG8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(AH8,AJ8)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM8=\"Hourly (H basis)\",AL8,(AL8/IF(AM8=\"Annual (A basis)\",12,9)*AN8*AO8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(AP8,AR8)","v":0},null,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(AU8=\"Hourly (H basis)\",AT8,(AT8/IF(AU8=\"Annual (A basis)\",12,9)*AV8*AW8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(AX8,AZ8)","v":0},null,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(BC8=\"Hourly (H basis)\",BB8,(BB8/IF(BC8=\"Annual (A basis)\",12,9)*BD8*BE8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(BF8,BH8)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BK8=\"Hourly (H basis)\",BJ8,(BJ8/IF(BK8=\"Annual (A basis)\",12,9)*BL8*BM8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(BN8,BP8)","v":0},null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BS8=\"Hourly (H basis)\",BR8,(BR8/IF(BS8=\"Annual (A basis)\",12,9)*BT8*BU8))),0)","v":0},0.38700000000000001,0,{"$f":"SUM(BV8,BX8)","v":0},null,"Annual (A basis)",12,1,0,0.38700000000000001,0,{"$f":"SUM(CD8,CF8)","v":0},null,"Request 2 years"]
["TBN","Program Associate","Program Development - Startup (DCS / Campus)","Faculty / Academic Staff",null,40000,"Annual (A basis)",12,1,40000,0.38700000000000001,15480,55480,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(O9=\"Hourly (H basis)\",N9,(N9/IF(O9=\"Annual (A basis)\",12,9)*P9*Q9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(W9=\"Hourly (H basis)\",V9,(V9/IF(W9=\"Annual (A basis)\",12,9)*X9*Y9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AE9=\"Hourly (H basis)\",AD9,(AD9/IF(AE9=\"Annual (A basis)\",12,9)*AF9*AG9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM9=\"Hourly (H basis)\",AL9,(AL9/IF(AM9=\"Annual (A basis)\",12,9)*AN9*AO9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AU9=\"Hourly (H basis)\",AT9,(AT9/IF(AU9=\"Annual (A basis)\",12,9)*AV9*AW9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BC9=\"Hourly (H basis)\",BB9,(BB9/IF(BC9=\"Annual (A basis)\",12,9)*BD9*BE9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BK9=\"Hourly (H basis)\",BJ9,(BJ9/IF(BK9=\"Annual (A basis)\",12,9)*BL9*BM9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BS9=\"Hourly (H basis)\",BR9,(BR9/IF(BS9=\"Annual (A basis)\",12,9)*BT9*BU9))),0)","v":0},0.38700000000000001,0,0,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(CA9=\"Hourly (H basis)\",BZ9,(BZ9/IF(CA9=\"Annual (A basis)\",12,9)*CB9*CC9))),0)","v":0},0.38700000000000001,0,0]
["TBN","University Staff","Program Support","Unversity Staff",null,33886,"Annual (A basis)",12,1,33886,{"$f":"IFERROR(VLOOKUP($D10,$B$45:$C$47,2),\"\")","v":0.38700000000000001},13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000,33886,"Annual (A basis)",12,1,33886,0.38700000000000001,13114,47000]
["TBN","Program Associate","Program Support","Faculty / Academic Staff",null,null,"Annual (A basis)",12,1,{"$f":"ROUND((IF(G11=\"Hourly (H basis)\",F11,(F11/IF(G11=\"Annual (A basis)\",12,9)*H11*I11))),0)","v":0},{"$f":"IFERROR(VLOOKUP($D11,$B$45:$C$47,2),\"\")","v":0.38700000000000001},{"$f":"IFERROR(ROUND((K11*J11),0),\"\")","v":0},{"$f":"SUM(J11,L11)","v":0},40000,"Annual (A basis)",12,1,40000,0.38700000000000001,15480,55480,40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(W11=\"Hourly (H basis)\",V11,(V11/IF(W11=\"Annual (A basis)\",12,9)*X11*Y11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((AA11*Z11),0),\"\")","v":15480},{"$f":"SUM(Z11,AB11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AE11=\"Hourly (H basis)\",AD11,(AD11/IF(AE11=\"Annual (A basis)\",12,9)*AF11*AG11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((AI11*AH11),0),\"\")","v":15480},{"$f":"SUM(AH11,AJ11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AM11=\"Hourly (H basis)\",AL11,(AL11/IF(AM11=\"Annual (A basis)\",12,9)*AN11*AO11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((AQ11*AP11),0),\"\")","v":15480},{"$f":"SUM(AP11,AR11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(AU11=\"Hourly (H basis)\",AT11,(AT11/IF(AU11=\"Annual (A basis)\",12,9)*AV11*AW11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((AY11*AX11),0),\"\")","v":15480},{"$f":"SUM(AX11,AZ11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BC11=\"Hourly (H basis)\",BB11,(BB11/IF(BC11=\"Annual (A basis)\",12,9)*BD11*BE11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((BG11*BF11),0),\"\")","v":15480},{"$f":"SUM(BF11,BH11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BK11=\"Hourly (H basis)\",BJ11,(BJ11/IF(BK11=\"Annual (A basis)\",12,9)*BL11*BM11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((BO11*BN11),0),\"\")","v":15480},{"$f":"SUM(BN11,BP11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(BS11=\"Hourly (H basis)\",BR11,(BR11/IF(BS11=\"Annual (A basis)\",12,9)*BT11*BU11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((BW11*BV11),0),\"\")","v":15480},{"$f":"SUM(BV11,BX11)","v":55480},40000,"Annual (A basis)",12,1,{"$f":"ROUND((IF(CA11=\"Hourly (H basis)\",BZ11,(BZ11/IF(CA11=\"Annual (A basis)\",12,9)*CB11*CC11))),0)","v":40000},0.38700000000000001,{"$f":"IFERROR(ROUND((CE11*CD11),0),\"\")","v":15480},{"$f":"SUM(CD11,CF11)","v":55480}]
["TBN","Faculty","Instructional","Faculty / Academic Staff",null,null,"Annual (A basis)",12,1,0,0.38700000000000001,0,0,null,"Annual (A basis)",12,1,0,0.38700000000000001,0,0,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700]
["TBN","Faculty","Instructional","Faculty / Academic Staff",null,null,"Annual (A basis)",12,1,0,0.38700000000000001,0,0,null,"Annual (A basis)",12,1,0,0.38700000000000001,0,0,50000,"Annual (A basis)",12,1,50000,0.38700000000000001,19350,69350,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700,100000,"Annual (A basis)",12,1,100000,0.38700000000000001,38700,138700]
["TBN","Teaching Assistant","Instructional","RA / PA / TA",null,null,"Annual (A basis)",12,0.5,0,0.38700000000000001,0,0,52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(O14=\"Hourly (H basis)\",N14,(N14/IF(O14=\"Annual (A basis)\",12,9)*P14*Q14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((S14*R14),0),\"\")","v":10062},{"$f":"SUM(R14,T14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(W14=\"Hourly (H basis)\",V14,(V14/IF(W14=\"Annual (A basis)\",12,9)*X14*Y14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((AA14*Z14),0),\"\")","v":10062},{"$f":"SUM(Z14,AB14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(AE14=\"Hourly (H basis)\",AD14,(AD14/IF(AE14=\"Annual (A basis)\",12,9)*AF14*AG14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((AI14*AH14),0),\"\")","v":10062},{"$f":"SUM(AH14,AJ14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(AM14=\"Hourly (H basis)\",AL14,(AL14/IF(AM14=\"Annual (A basis)\",12,9)*AN14*AO14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((AQ14*AP14),0),\"\")","v":10062},{"$f":"SUM(AP14,AR14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(AU14=\"Hourly (H basis)\",AT14,(AT14/IF(AU14=\"Annual (A basis)\",12,9)*AV14*AW14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((AY14*AX14),0),\"\")","v":10062},{"$f":"SUM(AX14,AZ14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(BC14=\"Hourly (H basis)\",BB14,(BB14/IF(BC14=\"Annual (A basis)\",12,9)*BD14*BE14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((BG14*BF14),0),\"\")","v":10062},{"$f":"SUM(BF14,BH14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(BK14=\"Hourly (H basis)\",BJ14,(BJ14/IF(BK14=\"Annual (A basis)\",12,9)*BL14*BM14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((BO14*BN14),0),\"\")","v":10062},{"$f":"SUM(BN14,BP14)","v":36062},52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(BS14=\"Hourly (H basis)\",BR14,(BR14/IF(BS14=\"Annual (A basis)\",12,9)*BT14*BU14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((BW14*BV14),0),\"\")","v":10062},36062,52000,"Annual (A basis)",12,0.5,{"$f":"ROUND((IF(CA14=\"Hourly (H basis)\",BZ14,(BZ14/IF(CA14=\"Annual (A basis)\",12,9)*CB14*CC14))),0)","v":26000},0.38700000000000001,{"$f":"IFERROR(ROUND((CE14*CD14),0),\"\")","v":10062},{"$f":"SUM(CD14,CF14)","v":36062}]
[null,null,null,null,null,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0]
[null,null,null,null,null,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0]
[null,null,null,null,null,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,{"$f":"ROUND((IF(CA17=\"Hourly (H basis)\",BZ17,(BZ17/IF(CA17=\"Annual (A basis)\",12,9)*CB17*CC17))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G18=\"Hourly (H basis)\",F18,(F18/IF(G18=\"Annual (A basis)\",12,9)*H18*I18))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R18,T18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z18,AB18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH18,AJ18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP18,AR18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX18,AZ18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF18,BH18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN18,BP18)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV18,BX18)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA18=\"Hourly (H basis)\",BZ18,(BZ18/IF(CA18=\"Annual (A basis)\",12,9)*CB18*CC18))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G19=\"Hourly (H basis)\",F19,(F19/IF(G19=\"Annual (A basis)\",12,9)*H19*I19))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R19,T19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z19,AB19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH19,AJ19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP19,AR19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX19,AZ19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF19,BH19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN19,BP19)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV19,BX19)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA19=\"Hourly (H basis)\",BZ19,(BZ19/IF(CA19=\"Annual (A basis)\",12,9)*CB19*CC19))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G20=\"Hourly (H basis)\",F20,(F20/IF(G20=\"Annual (A basis)\",12,9)*H20*I20))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R20,T20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z20,AB20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH20,AJ20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP20,AR20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX20,AZ20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF20,BH20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN20,BP20)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV20,BX20)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA20=\"Hourly (H basis)\",BZ20,(BZ20/IF(CA20=\"Annual (A basis)\",12,9)*CB20*CC20))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G21=\"Hourly (H basis)\",F21,(F21/IF(G21=\"Annual (A basis)\",12,9)*H21*I21))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R21,T21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z21,AB21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH21,AJ21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP21,AR21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX21,AZ21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF21,BH21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN21,BP21)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV21,BX21)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA21=\"Hourly (H basis)\",BZ21,(BZ21/IF(CA21=\"Annual (A basis)\",12,9)*CB21*CC21))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G22=\"Hourly (H basis)\",F22,(F22/IF(G22=\"Annual (A basis)\",12,9)*H22*I22))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R22,T22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z22,AB22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH22,AJ22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP22,AR22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX22,AZ22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF22,BH22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN22,BP22)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV22,BX22)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA22=\"Hourly (H basis)\",BZ22,(BZ22/IF(CA22=\"Annual (A basis)\",12,9)*CB22*CC22))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND((IF(G23=\"Hourly (H basis)\",F23,(F23/IF(G23=\"Annual (A basis)\",12,9)*H23*I23))),0)","v":0},"","",0,null,null,null,null,0,"","",{"$f":"SUM(R23,T23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(Z23,AB23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AH23,AJ23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AP23,AR23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(AX23,AZ23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BF23,BH23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BN23,BP23)","v":0},null,null,null,null,0,"","",{"$f":"SUM(BV23,BX23)","v":0},null,null,null,null,{"$f":"ROUND((IF(CA23=\"Hourly (H basis)\",BZ23,(BZ23/IF(CA23=\"Annual (A basis)\",12,9)*CB23*CC23))),0)","v":0},"","",0]
[null,null,null,null,null,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0,null,null,null,null,0,"","",0]
["Insert Here"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salaries & Wages",{"$f":"ROUND(SUM(CD5:CD24),0)","v":379886},"Total Fringe Benefits",{"$f":"ROUND(SUM(CF5:CF24),0)","v":147016}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Salary, Wage, Fringe",{"$f":"SUM(CF26,CD26)","v":526902}]
["NOTE:  if you are paying for PA/RA students,  you MUST complete the Tuition Remission sheet to ensure you request sufficient funds to cover the Tuition Remission costs."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Instructional",{"$f":"SUMIF($C$5:C24,\"Instructional\",$CG$5:CG24)","v":424422}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Support",{"$f":"SUMIF($C$5:C24,\"Support\",$CG$5:CG24)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,L31,M$5:M$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,T31,U$5:U$25)","v":147022},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AB31,AC$5:AC$25)","v":355072},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AJ31,AK$5:AK$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AR31,AS$5:AS$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,AZ31,BA$5:BA$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,BH31,BI$5:BI$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,BP31,BQ$5:BQ$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,BX31,BY$5:BY$25)","v":424422},null,null,null,null,null,null,{"$f":"Validation!$A2","v":"Instructional"},{"$f":"SUMIF($C$5:$C$25,CF31,CG$5:CG$25)","v":424422}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,L32,M$5:M$25)","v":47000},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,T32,U$5:U$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AB32,AC$5:AC$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AJ32,AK$5:AK$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AR32,AS$5:AS$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,AZ32,BA$5:BA$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,BH32,BI$5:BI$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,BP32,BQ$5:BQ$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,BX32,BY$5:BY$25)","v":102480},null,null,null,null,null,null,{"$f":"Validation!$A3","v":"Program Support"},{"$f":"SUMIF($C$5:$C$25,CF32,CG$5:CG$25)","v":102480}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,L33,M$5:M$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,T33,U$5:U$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AB33,AC$5:AC$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AJ33,AK$5:AK$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AR33,AS$5:AS$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,AZ33,BA$5:BA$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,BH33,BI$5:BI$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,BP33,BQ$5:BQ$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,BX33,BY$5:BY$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A4","v":"Program Marketing"},{"$f":"SUMIF($C$5:$C$25,CF33,CG$5:CG$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,L34,M$5:M$25)","v":194180},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,T34,U$5:U$25)","v":277400},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AB34,AC$5:AC$25)","v":69350},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AJ34,AK$5:AK$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AR34,AS$5:AS$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,AZ34,BA$5:BA$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,BH34,BI$5:BI$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,BP34,BQ$5:BQ$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,BX34,BY$5:BY$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A5","v":"Program Development - Startup (DCS / Campus)"},{"$f":"SUMIF($C$5:$C$25,CF34,CG$5:CG$25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,L35,M$5:M$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,T35,U$5:U$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AB35,AC$5:AC$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AJ35,AK$5:AK$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AR35,AS$5:AS$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,AZ35,BA$5:BA$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,BH35,BI$5:BI$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,BP35,BQ$5:BQ$25)","v":0},null,null,null,null,null,null,{"$f":"Validation!$A6","v":"Program Development - Startup"},{"$f":"SUMIF($C$5:$C$25,BX35,BY$5:BY$25)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L31","v":"Instructional"},{"$f":"M31","v":0},{"$f":"U31","v":147022},{"$f":"AC31","v":355072},{"$f":"AK31","v":424422},{"$f":"AS31","v":424422},{"$f":"BA31","v":424422},{"$f":"BI31","v":424422},{"$f":"BQ31","v":424422},{"$f":"BY31","v":424422},{"$f":"CG31","v":424422}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"L32","v":"Program Support"},47000,{"$f":"U32","v":102480},{"$f":"AC32","v":102480},{"$f":"AK32","v":102480},{"$f":"AS32","v":102480},{"$f":"BA32","v":102480},{"$f":"BI32","v":102480},{"$f":"BQ32","v":102480},{"$f":"BY32","v":102480},{"$f":"CG32","v":102480}]
[null,null,null,null,null,null,null,null,null,null,null,"Program Marketing",{"$f":"M33","v":0},0,0,0,0,{"$f":"BA33","v":0},0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Program Development - Startup (DCS / Campus)",194180,277400,69350,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"Program Development - Startup",0,{"$f":"U35","v":0},{"$f":"AC35","v":0},{"$f":"AK35","v":0},{"$f":"AS35","v":0},{"$f":"BA35","v":0},{"$f":"BI35","v":0},{"$f":"BQ35","v":0},{"$f":"BY35","v":0},{"$f":"CG35","v":0}]
[null,"Types of Employees and Fringe Rates"]
[null,"Faculty / Academic Staff",0.38700000000000001]
[null,"RA / PA / TA",0.38700000000000001]
[null,"Unversity Staff",0.38700000000000001]

{"sheet":"Tuition Remission","index":7,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,0,0,10],[11,0,13,4]]}
["Worksheet for Project Budget"]
[]
[]
[null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029}]
["Number of First Semester PA/RA"]
["Sub-Total",{"$f":"ROUND(B5*6000,0)","v":0},{"$f":"ROUND(C5*6000,0)","v":0},0,0,0,0,0,0,0,0]
["Number of Second Semester PA/RA"]
["Sub-Total",{"$f":"ROUND(B7*6000,0)","v":0},{"$f":"ROUND(C7*6000,0)","v":0},0,0,0,0,0,0,0,0]
["Total Tuition Remission",{"$f":"ROUND(SUM(B6, B8),0)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
["NOTE:  To ensure that you have requested sufficient funds to cover the cost of Tuition Remission, please indicate the number of PA/RA students you will have in each year.  If you expect to have one student for the full budget year and another for half the budget year, you may indicate 1.5 students."]

{"sheet":"Sub-Agreements","index":8,"n_rows":30,"n_cols":34,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,1,1,1]]}
[null,"*Note: Default rate for subagreements is $600 per credit hour per student.",null,null,null,null,"Worksheet for Project Budget"]
[]
["Course Name","School / College","Type","Payment Type",{"$f":"CONCATENATE(G3,\" \",\"Payment Amount\",\"*\")","v":"2020 Payment Amount*"},{"$f":"CONCATENATE(G3,\" \",\"Credits\")","v":"2020 Credits"},{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"CONCATENATE(J3,\" \",\"Payment Amount\")","v":"2021 Payment Amount"},{"$f":"CONCATENATE(J3,\" \",\"Credits\")","v":"2021 Credits"},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"CONCATENATE(M3,\" \",\"Payment Amount\")","v":"2022 Payment Amount"},{"$f":"CONCATENATE(M3,\" \",\"Credits\")","v":"2022 Credits"},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"CONCATENATE(P3,\" \",\"Payment Amount\")","v":"2023 Payment Amount"},{"$f":"CONCATENATE(P3,\" \",\"Credits\")","v":"2023 Credits"},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"CONCATENATE(S3,\" \",\"Payment Amount\")","v":"2024 Payment Amount"},{"$f":"CONCATENATE(S3,\" \",\"Credits\")","v":"2024 Credits"},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"CONCATENATE(V3,\" \",\"Payment Amount\")","v":"2025 Payment Amount"},{"$f":"CONCATENATE(V3,\" \",\"Credits\")","v":"2025 Credits"},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"CONCATENATE(Y3,\" \",\"Payment Amount\")","v":"2026 Payment Amount"},{"$f":"CONCATENATE(Y3,\" \",\"Credits\")","v":"2026 Credits"},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"CONCATENATE(AB3,\" \",\"Payment Amount\")","v":"2027 Payment Amount"},{"$f":"CONCATENATE(AB3,\" \",\"Credits\")","v":"2027 Credits"},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"CONCATENATE(AE3,\" \",\"Payment Amount\")","v":"2028 Payment Amount"},{"$f":"CONCATENATE(AE3,\" \",\"Credits\")","v":"2028 Credits"},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"CONCATENATE(AH3,\" \",\"Payment Amount\")","v":"2029 Payment Amount"},{"$f":"CONCATENATE(AH3,\" \",\"Credits\")","v":"2029 Credits"},{"$f":"'131 Program Summary'!L22","v":2029}]
[null,"Wisconsin School of Business","Instructional","Per Credit",{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",E4,E4*F4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",H4,H4*I4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",K4,K4*L4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",N4,N4*O4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",Q4,Q4*R4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",T4,T4*U4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",W4,W4*X4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",Z4,Z4*AA4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",AC4,AC4*AD4),\"\")","v":""},{"$f":"IF(ISBLANK($A4)=TRUE,\"\",600)","v":""},6,{"$f":"IFERROR(IF($D4=\"Fixed Rate\",AF4,AF4*AG4),\"\")","v":""}]
[null,"College of Agricultural and Life Sciences","Instructional","Per Credit","",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",E5,E5*F5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",H5,H5*I5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",K5,K5*L5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",N5,N5*O5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",Q5,Q5*R5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",T5,T5*U5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",W5,W5*X5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",Z5,Z5*AA5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",AC5,AC5*AD5),\"\")","v":""},"",9,{"$f":"IFERROR(IF($D5=\"Fixed Rate\",AF5,AF5*AG5),\"\")","v":""}]
[null,"School of Education","Instructional","Per Credit","",3,{"$f":"IFERROR(IF($D6=\"Fixed Rate\",E6,E6*F6),\"\")","v":""},"",3,"","",3,{"$f":"IFERROR(IF($D6=\"Fixed Rate\",K6,K6*L6),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D6=\"Fixed Rate\",N6,N6*O6),\"\")","v":""},"",3,"","",3,"","",3,"","",3,"","",3,"","",3,""]
[null,"School of Education","Instructional","Per Credit","",3,"","",3,"","",3,"","",3,"","",3,"","",3,"","",3,"","",3,"","",3,"","",3,""]
[null,"College of Letters & Science","Support","Fixed Rate","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,""]
[null,"School of Nursing","Support","Per Credit","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,""]
[null,"College of Agricultural and Life Sciences","Instructional","Fixed Rate","",6,{"$f":"IFERROR(IF($D10=\"Fixed Rate\",E10,E10*F10),\"\")","v":""},"",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,""]
[null,"School of Nursing","Instructional","Fixed Rate","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,"","",6,""]
[null,"School of Education","Instructional","Per Credit","",3,"","",3,{"$f":"IFERROR(IF($D12=\"Fixed Rate\",H12,H12*I12),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D12=\"Fixed Rate\",K12,K12*L12),\"\")","v":""},"",3,"","",3,"","",3,"","",3,"","",3,"","",3,"","",3,""]
[null,"Wisconsin School of Business","Support","Per Credit","",3,{"$f":"IFERROR(IF($D13=\"Fixed Rate\",E13,E13*F13),\"\")","v":""},"",3,"","",3,"","",3,"","",3,{"$f":"IFERROR(IF($D13=\"Fixed Rate\",Q13,Q13*R13),\"\")","v":""},"",3,"","",3,"","",3,"","",3,"","",3,""]
[null,null,"Support","Fixed Rate","",3,{"$f":"IFERROR(IF($D14=\"Fixed Rate\",E14,E14*F14),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D14=\"Fixed Rate\",H14,H14*I14),\"\")","v":""},"",3,"","",3,{"$f":"IFERROR(IF($D14=\"Fixed Rate\",N14,N14*O14),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D14=\"Fixed Rate\",Q14,Q14*R14),\"\")","v":""},"",3,"","",3,"","",3,"","",3,"","",3,""]
[null,null,"Support","Per Credit","",1,{"$f":"IFERROR(IF($D15=\"Fixed Rate\",E15,E15*F15),\"\")","v":""},"",1,{"$f":"IFERROR(IF($D15=\"Fixed Rate\",H15,H15*I15),\"\")","v":""},"",1,"","",1,{"$f":"IFERROR(IF($D15=\"Fixed Rate\",N15,N15*O15),\"\")","v":""},"",1,{"$f":"IFERROR(IF($D15=\"Fixed Rate\",Q15,Q15*R15),\"\")","v":""},"",1,"","",1,"","",1,"","",1,"","",1,""]
[null,null,"Instructional","Per Credit","",1,{"$f":"IFERROR(IF($D16=\"Fixed Rate\",E16,E16*F16),\"\")","v":""},"",1,{"$f":"IFERROR(IF($D16=\"Fixed Rate\",H16,H16*I16),\"\")","v":""},"",1,"","",1,{"$f":"IFERROR(IF($D16=\"Fixed Rate\",N16,N16*O16),\"\")","v":""},"",1,{"$f":"IFERROR(IF($D16=\"Fixed Rate\",Q16,Q16*R16),\"\")","v":""},"",1,"","",1,"","",1,"","",1,"","",1,""]
[null,null,"Support","Per Credit","",3,{"$f":"IFERROR(IF($D17=\"Fixed Rate\",E17,E17*F17),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D17=\"Fixed Rate\",H17,H17*I17),\"\")","v":""},"",3,"","",3,{"$f":"IFERROR(IF($D17=\"Fixed Rate\",N17,N17*O17),\"\")","v":""},"",3,{"$f":"IFERROR(IF($D17=\"Fixed Rate\",Q17,Q17*R17),\"\")","v":""},"",3,"","",3,"","",3,"","",3,"","",3,""]
[null,null,"Support","Fixed Rate","",6,{"$f":"IFERROR(IF($D18=\"Fixed Rate\",E18,E18*F18),\"\")","v":""},"",6,{"$f":"IFERROR(IF($D18=\"Fixed Rate\",H18,H18*I18),\"\")","v":""},"",6,{"$f":"IFERROR(IF($D18=\"Fixed Rate\",K18,K18*L18),\"\")","v":""},"",6,{"$f":"IFERROR(IF($D18=\"Fixed Rate\",N18,N18*O18),\"\")","v":""},"",6,{"$f":"IFERROR(IF($D18=\"Fixed Rate\",Q18,Q18*R18),\"\")","v":""},"",6,"","",6,"","",6,"","",6,"","",6,""]
[null,null,"Support","Per Credit","",9,"","",9,"","",9,"","",9,"","",9,"","",9,"","",9,"","",9,"","",9,"","",9,""]
[null,null,null,null,"",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,"","",null,""]
[null,null,null,null,"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",E21,E21*F21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",H21,H21*I21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",K21,K21*L21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",N21,N21*O21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",Q21,Q21*R21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",T21,T21*U21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",W21,W21*X21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",Z21,Z21*AA21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",AC21,AC21*AD21),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D21=\"Fixed Rate\",AF21,AF21*AG21),\"\")","v":""}]
[null,null,null,null,"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",E22,E22*F22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",H22,H22*I22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",K22,K22*L22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",N22,N22*O22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",Q22,Q22*R22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",T22,T22*U22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",W22,W22*X22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",Z22,Z22*AA22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",AC22,AC22*AD22),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D22=\"Fixed Rate\",AF22,AF22*AG22),\"\")","v":""}]
[null,null,null,null,"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",E23,E23*F23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",H23,H23*I23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",K23,K23*L23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",N23,N23*O23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",Q23,Q23*R23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",T23,T23*U23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",W23,W23*X23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",Z23,Z23*AA23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",AC23,AC23*AD23),\"\")","v":""},"",null,{"$f":"IFERROR(IF($D23=\"Fixed Rate\",AF23,AF23*AG23),\"\")","v":""}]
["Insert Here"]
["Total Sub-Agreements",null,null,null,null,null,{"$f":"ROUND(SUM(G4:G23),0)","v":0},null,null,{"$f":"ROUND(SUM(J4:J23),0)","v":0},null,null,{"$f":"ROUND(SUM(M4:M23),0)","v":0},null,null,{"$f":"ROUND(SUM(P4:P23),0)","v":0},null,null,{"$f":"ROUND(SUM(S4:S23),0)","v":0},null,null,{"$f":"ROUND(SUM(V4:V23),0)","v":0},null,null,{"$f":"ROUND(SUM(Y4:Y23),0)","v":0},null,null,{"$f":"ROUND(SUM(AB4:AB23),0)","v":0},null,null,{"$f":"ROUND(SUM(AE4:AE23),0)","v":0},null,null,{"$f":"ROUND(SUM(AH4:AH23),0)","v":0}]
[]
[]
[null,null,null,null,null,null,{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029}]
[null,null,null,null,"Instructional",null,{"$f":"SUMIF($C$4:$C23,\"Instructional\",G4:G23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",J4:J23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",M4:M23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",P4:P23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",S4:S23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",V4:V23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",Y4:Y23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",AB4:AB23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",AE4:AE23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Instructional\",AH4:AH23)","v":0}]
[null,null,null,null,"Support",null,{"$f":"SUMIF($C$4:$C23,\"Support\",G4:G23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",J4:J23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",M4:M23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",P4:P23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",S4:S23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",V4:V23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",Y4:Y23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",AB4:AB23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",AE4:AE23)","v":0},{"$f":"SUMIF($C$4:$C23,\"Support\",AH4:AH23)","v":0}]

{"sheet":"Supplies & Services","index":9,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,null,"Worksheet for Project Budget"]
[]
[]
["Category","Details","Type",{"$f":"'131 Program Summary'!C22","v":2020},{"$f":"'131 Program Summary'!D22","v":2021},{"$f":"'131 Program Summary'!E22","v":2022},{"$f":"'131 Program Summary'!F22","v":2023},{"$f":"'131 Program Summary'!G22","v":2024},{"$f":"'131 Program Summary'!H22","v":2025},{"$f":"'131 Program Summary'!I22","v":2026},{"$f":"'131 Program Summary'!J22","v":2027},{"$f":"'131 Program Summary'!K22","v":2028},{"$f":"'131 Program Summary'!L22","v":2029},"Cumulative"]
["Marketing",null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D5:M5)","v":0}]
["Supplies",null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D6:M6)","v":0}]
["Marketing",null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
["Supplies",null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
["Other",null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,0]
[null,null,"Program Marketing",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(D24:H24)","v":0}]
["Insert Here",null,"Program Marketing"]
["Total Supplies",null,null,{"$f":"ROUND(SUM(D5:D24),0)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"ROUND(SUM(N5:N24),0)","v":0}]
[]
[]
[null,null,"Instructional",{"$f":"SUMIF($C$5:$C$25,$C29,D$5:D$25)","v":0},{"$f":"SUMIF($C$5:$C$25,$C29,E$5:E$25)","v":0},0,0,0,0,0,{"$f":"SUMIF($C$5:$C$25,$C29,K$5:K$25)","v":0},0,0]
[null,null,"Program Support",{"$f":"SUMIF($C$5:$C$25,$C30,D$5:D$25)","v":0},{"$f":"SUMIF($C$5:$C$25,$C30,E$5:E$25)","v":0},0,0,0,0,0,{"$f":"SUMIF($C$5:$C$25,$C30,K$5:K$25)","v":0},{"$f":"SUMIF($C$5:$C$25,$C30,L$5:L$25)","v":0},0]
[null,null,"Program Development - Startup",{"$f":"SUMIF($C$5:$C$25,$C31,D$5:D$25)","v":0},0,0,0,0,{"$f":"SUMIF($C$5:$C$25,$C31,I$5:I$25)","v":0},0,{"$f":"SUMIF($C$5:$C$25,$C31,K$5:K$25)","v":0},0,0]
[null,null,"Program Development - Startup (DCS / Campus)",{"$f":"SUMIF($C$5:$C$25,$C32,D$5:D$25)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"Program Marketing",{"$f":"SUMIF($C$5:$C$25,$C33,D$5:D$25)","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Investing the Margin","index":10,"n_rows":90,"n_cols":13,"rows_kept":90,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[1,"Worksheet for Investing the Margin"]
[{"$f":"A1+1","v":2},null,"This page should reflect how they will spend the money (in detail). Categories include department salaries, new faculty lines, additional TA positions or scholarships, professional development, and other."]
[{"$f":"A2+1","v":3},null,"The format will be a hybrid of \"Salaries & Wages\" and \"Supplies\""]
[4,null,"The summary categories should show up on the \"131 Program Summary\" "]
[5,"Category","Description",{"$f":"CONCATENATE('131 Program Summary'!C22,\" \",\"Amount\")","v":"2020 Amount"},{"$f":"CONCATENATE('131 Program Summary'!D22,\" \",\"Amount\")","v":"2021 Amount"},{"$f":"CONCATENATE('131 Program Summary'!E22,\" \",\"Amount\")","v":"2022 Amount"},{"$f":"CONCATENATE('131 Program Summary'!F22,\" \",\"Amount\")","v":"2023 Amount"},{"$f":"CONCATENATE('131 Program Summary'!G22,\" \",\"Amount\")","v":"2024 Amount"},{"$f":"CONCATENATE('131 Program Summary'!H22,\" \",\"Amount\")","v":"2025 Amount"},{"$f":"CONCATENATE('131 Program Summary'!I22,\" \",\"Amount\")","v":"2026 Amount"},{"$f":"CONCATENATE('131 Program Summary'!J22,\" \",\"Amount\")","v":"2027 Amount"},{"$f":"CONCATENATE('131 Program Summary'!K22,\" \",\"Amount\")","v":"2028 Amount"},{"$f":"CONCATENATE('131 Program Summary'!L22,\" \",\"Amount\")","v":"2029 Amount"}]
[6]
[7,"New Faculty Lines"]
[8,"Additional TA Positions or Scholarships"]
[9,"Professional Development"]
[10,"Department Salaries"]
[11,"Other"]
[12,"Department Salaries"]
[13,"Other"]
[14,"Additional TA Positions or Scholarships"]
[15,"Department Salaries"]
[16,"New Faculty Lines"]
[17,"Additional TA Positions or Scholarships"]
[18,"Professional Development"]
[19,"Department Salaries"]
[20,"New Faculty Lines"]
[21]
[22]
[23]
[24,"Insert Here"]
[25,null,"Total",{"$f":"SUM(D7:D24)","v":0},{"$f":"SUM(E7:E24)","v":0},0,0,0,0,0,0,0,0]
[26]
[27,"Department Salaries",null,{"$f":"SUMIF($B$7:$B$24,$B27,D$7:D$24)","v":0},{"$f":"SUMIF($B$7:$B$24,$B27,E$7:E$24)","v":0},0,0,0,0,0,0,0,0]
[28,"New Faculty Lines",null,{"$f":"SUMIF($B$7:$B$24,$B28,D$7:D$24)","v":0},0,0,0,0,0,0,0,0,0]
[29,"Additional TA Positions or Scholarships",null,0,0,0,0,0,0,0,0,0,0]
[30,"Professional Development",null,0,0,0,0,0,0,0,0,0,0]
[31,"Other",null,0,0,0,0,0,0,0,0,0,0]
[32,null,{"$f":"'131 Program Summary'!B53","v":"Investment Margin - Department"},{"$f":"'131 Program Summary'!C53","v":-15000},{"$f":"'131 Program Summary'!D53","v":-4500},{"$f":"'131 Program Summary'!E53","v":-4500},{"$f":"'131 Program Summary'!F53","v":-4500},{"$f":"'131 Program Summary'!G53","v":-4500},{"$f":"'131 Program Summary'!H53","v":-4500},{"$f":"'131 Program Summary'!I53","v":-4500},{"$f":"'131 Program Summary'!J53","v":-4500},{"$f":"'131 Program Summary'!K53","v":-4500},{"$f":"'131 Program Summary'!L53","v":-4500}]
[33]
[34,null,"Check",{"$f":"D32-D25","v":-15000},{"$f":"E32-E25","v":-4500},{"$f":"F32-F25","v":-4500},-4500,-4500,-4500,-4500,-4500,-4500,-4500]
[35]
[36,"Notes"]
[37,"Must add fringe to new faculty lines (38.7%) and department salaries (38.7%)"]
[38,"Investment margin must be targeted at important department priorities so that the \"check\" line is very close to zero (minimal surplus)"]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[{"$f":"A66+1","v":67}]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]

{"sheet":"Validation","index":11,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Type","Supplies","S/C share","Payment Type","Employee Type","Schools","Credit Flow","Years","Course Type"]
["Instructional","Travel","Net Revenue","Fixed Rate","Faculty / Academic Staff","College of Agricultural and Life Sciences","Constant",1,"New"]
["Program Support","Marketing","Margin","Per Credit","RA / PA / TA","Wisconsin School of Business","Variable",2,"Transition"]
["Program Marketing","Meetings",null,null,"Unversity Staff","School of Education",null,3,"Maintenance"]
["Program Development - Startup (DCS / Campus)","Conferences",null,null,null,"College of Engineering",null,4]
["Program Development - Startup","Supplies",null,null,null,"School of Human Ecology",null,5]
[null,"Other",null,null,null,"College of Letters & Science",null,6]
[null,null,null,null,null,"School of Nursing"]
[null,null,null,null,null,"School of Pharmacy"]
[null,null,null,null,null,"Law School"]
[null,null,null,null,null,"School of Medicine and Public Health"]
[null,null,null,null,null,"School of Veterinary Medicine"]