{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[[16,0,20,0]]}
["UW-Milwaukee",null,null,null,null,null,null,null,null,null,null,"Fee in addition to tuition"]
["Distance Education Fee Authorization",null,null,null,null,null,null,null,null,null,null,"Fee in lieu of tuition"]
[]
["Academic Year:  ______",null,null,null,null,null,null,null,null,null,null,"Graduate",649.16999999999996]
[null,null,null,null,null,null,null,null,null,null,null,"Undergraduate",337.13]
["Course starts fall term and continues through summer term of following year. Use one form for multiple programs, unless the fee amount varies by program within a school or college, then submit a form for each unique fee charged. Example 1: if a college uses a fee in addition to tuition for some programs but uses a “fee in lieu of tuition” pricing strategy for other programs, submit two forms; Example 2: If two departments within a college charge different distance education fees, submit a form for each fee amount charged."]
[]
["School/College (and Program if submitting multiple forms):  ____________________________________________________"]
[]
["Pricing Strategy:  (        Program or       Course) :                                                                                                              (drop down list)"]
[]
["Program Type:                                                                                                                                                                      (drop down list)"]
[]
["Amount of Fee Requested (per credit):  "]
[]
["Justification for Distance Education Fee (see Distance Education Pricing Principles on page 2):"]
[]
[]
[]
[]
[]
[]
["Org Code: (indicate Fund - Dept - Program)"]
["Revenue:"]
["Anticipated enrollment"]
["Anticipated # of credits (eg., 1-4)"]
["Anticipated number of courses:"]
["   Anticipated SCH",{"$f":"B25*B26*B27","v":0}]
["UG or Grad Off-Campus Resident 1-credit @ 100% revenue",{"$f":"IF(B12=\"Graduate\",VLOOKUP(B12,L4:M5,2,FALSE),IF(B12=\"Undergraduate\",VLOOKUP(B12,L4:M5,2,FALSE),\"\"))","v":""}]
["  Anticipated tuition generated: ",{"$f":"B28*B29","v":{"$error":"#VALUE!"}}]
["  Distance Education Fee revenue generated:",{"$f":"B14*B28","v":0}]
["Total Projected Revenue:",{"$f":"B30+B31","v":{"$error":"#VALUE!"}}]
[]
["Anticipated Expense:  (List all that apply)"]
["Instructor(s) salary:"]
["Course development stipend:"]
["Program Manager:"]
["Technical support staff: "]
["Graduate assistant:"]
["Student help:"]
["Total salary:",{"$f":"SUM(B35:B40)","v":0}]
["Fringe (40% of total salary)",{"$f":"B41*0.4","v":0}]
["Total Salary and Fringes",{"$f":"B41+B42","v":0}]
["Supplies and other expenses"]
["10% tax on Distance Education Fee (committed to Learning Technology Support and seed funding for new online progams)",{"$f":"B31*0.1","v":0}]
["Total Anticipated Expense:",{"$f":"B43+B44+B45","v":0}]
[]
["Projected Net Revenue/(Loss)",{"$f":"B32-B46","v":{"$error":"#VALUE!"}}]
["Signatures:"]
[]
["Dean                                                                                                                                                                                                        Date"]
[]
[]
["Provost                                                                                                                                                                                                     Date"]
[]
["cc: Special Assistant to the Provost"]
["       Administrative Officer, Division of Academic Affairs"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}