ࡱ> I  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHKeMNOPQRSTUVWXYZ[\]^_`abcdfghiRoot Entry F t2.YJ@ Workbook MsoDataStore `S'.Y0r2.YYAB4HA5GU==2`S'.Y0r2.YItem PropertiesOXR2QQQJG44CMQ==2`S'.Y0r2.YItem Lh1Properties }SummaryInformation( DocumentSummaryInformation8 CompObj3l ZO\pHadeed, Lauren Carroll Ba==qK58X@"1Calibri1Calibri1Calibri1Calibri1Calibri1 Calibri1Calibri1Calibri1Calibri1Calibri1*h6 Calibri Light1 Calibri1Calibri1Calibri1Calibri1,6Calibri16Calibri16Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1Calibri1 Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.094_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_)                                                                       ff + ) , *      P  P         `            a@   "a@         " ,    @ @   @ @  "@ @  , @ @   @ @   a@  , a@    ,      @ @   @ @   @ @   @ @   @ @  (a@   a@    (@ @  ,       ,   (     "@ @ (   )@ @   @ @ ( "@ @  !@ @   "@ @ ( (@ @  *@ @ ( 1"@ @   @ @  a   ( , a@  ! )@ @  )@ @   " "@ @ ( !@ @  !@ @  !@ @  ||wQ}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-} #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-}  #0\);_("}-} #0\);_("}-} #0\);_("}-}- #0\);_("}-}= #0\);_("}U}> #0\);_(";_(@_)  }-}6  #0\);_("}i}@ #0\);_("ef;_(@_)   }-}A #0\);_("}-}B #0\);_("}-}C #0\);_("}-}D #0\);_("}-}E #0\);_("}-}F #0\);_("}A}G #0\);_(";_(@_) }-}H #0\);_("}-}I #0\);_("}-}J #0\);_("}}K}i}L #0\);_("ef;_(@_)   }i}M #0\);_("ef;_(@_)   }-}N #0\);_("}-}O #0\);_("}-}P #0\);_("}}Q}-}R #0\);_("}-}S #0\);_("}-}T #0\);_("}-}U #0\);_("}i}V #0\);_("ef;_(@_)   }i}W #0\);_("ef;_(@_)   }-}X #0\);_("}-}Y #0\);_("}-}Z #0\);_("}-}[ #0\);_("}-}\ #0\);_("}-}] #0\);_("}-}^ #0\);_("}-}_ #0\);_("}-}` #0\);_("}A}a #0\);_(";_(@_) }-}b #0\);_("}-}c #0\);_("}A}d #0\);_(";_(@_) }-}e #0\);_("}-}f #0\);_("}A}g #0\);_(";_(@_) }-}h #0\);_("}A}i #0\);_(";_(@_) }-}j #0\);_("}-}k #0\);_("}-}l  #0\);_("}-}m #0\);_("}i}n #0\);_("ef;_(@_)   }-}o #0\);_("}-}p #0\);_("}-}q #0\);_("}-}r #0\);_("}A}s #0\);_(";_(@_) }-}t #0\);_("}-}u #0\);_("}-}v #0\);_("}-}0  #0\);_("}-}+ #0\);_("}-}, #0\);_("}-}. #0\);_("}-}< #0\);_("}A}2 #0\);_(";_(@_) }A}3 #0\);_("?;_(@_) }A}4 #0\);_("23;_(@_) }-}5 #0\);_("}A}1 a#0\);_(";_(@_) }A}( #0\);_(";_(@_) }A}9 W#0\);_(";_(@_) }}7 ??v#0\);_("̙;_(@_)    }}; ???#0\);_(";_(@_) ??? ??? ??? ???}}) }#0\);_(";_(@_)    }A}8 }#0\);_(";_(@_) }}* #0\);_(";_(@_) ??? ??? ??? ???}-}? #0\);_("}}: #0\);_(";_(@_)    }-}/ #0\);_("}A}" #0\);_(";_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("23;_(@_) }A}# #0\);_(";_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("23;_(@_) }A}$ #0\);_(";_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("23;_(@_) }A}% #0\);_(";_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("L;_(@_) }A} #0\);_("23;_(@_) }A}& #0\);_(";_(@_) }A} #0\);_("ef;_(@_) }A} #0\);_("L;_(@_) }A}  #0\);_("23;_(@_) }A}' #0\);_(" ;_(@_) }A} #0\);_("ef ;_(@_) }A} #0\);_("L ;_(@_) }A}! #0\);_("23 ;_(@_)  20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 [ % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 Dr % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 K Followed Hyperlink  Or% 1Good;Good  a%2 Heading 1G Heading 1 DTj%[3 Heading 2G Heading 2 DTj%?4 Heading 3G Heading 3 DTj%235 Heading 49 Heading 4 DTj%69 Hyperlink  c% 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  W%3Normal % :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title DTj% >TotalMTotal %[[? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16`pVFaculty Data Sheet Copy of PCN Rosters Here&Copy Census Enroll Report Here  ;5Q55PCN Vacated ByNotesReplacement Title#Faculty Position Request Data SheetFaculty FTE Current Fiscal YrFaculty FTE Last Fiscal YrRequested SalaryFaculty FTE Two Fiscal Yrs Ago Faculty FTE Three Fiscal Yrs AgoTotal Faculty FTE'sTenured/Tenure-Track FTE'sLecturer FTE's or FTE's,Cost of Instruction per Student Credit Hour 2Undergraduate Student Credit Hours (Fall & Spring)-Graduate Student Credit Hours (Fall & Spring)*Total Student Credit Hours (Fall & Spring)%Headcount Majors Three Fiscal Yrs Ago#Headcount Majors Two Fiscal Yrs AgoHeadcount Majors Last Fiscal Yr"Headcount Majors Current Fiscal Yr4Stud Cr Hrs Majors & Non Majors Three Fiscal Yrs Ago2Stud Cr Hrs Majors & Non Majors Two Fiscal Yrs Ago.Stud Cr Hrs Majors & Non Majors Last Fiscal Yr1Stud Cr Hrs Majors & Non Majors Current Fiscal YrNotes:Undergraduate Headcount (Fall)Graduate Headcount (Fall)Total Student Headcount (Fall)Index -Accountversion 3.0 8.9.23Student Head Count Per Faculty:Total Fall Compensation (excl fringes) Two Fiscal Yrs Ago<Total Fall Compensation (excl fringes) Three Fiscal Yrs Ago5Total Fall Compensation (excl fringes) Last Fiscal Yr8Total Fall Compensation (excl fringes) Current Fiscal YrBudgetPCN where Budget residescFaculty FTE/Salary information should be pulled from your college PCN rosters (use a November date)Census Enrollment Dashboard1Filled Positions Only (Use November PCN Rosters)EStudent Headcount information can be found on this report in Power BIMTotal CH's Generated by Department (From Power BI Section Net Revenue Report)VTotal CH's generated by department information can be found on this report in Power BISection Net Revenue Report%Total Student FTE's Generated by Dept]The SNR report can only be run by semester. You will have to export into Excel to analyze it.%Insert College Name / Department NameCollege/DepartmetNHeadcount of Majors (From ARGOs or PowerBI Census Enrollment Dashboard Report)#Contact Brenda Grant with QuestionsClinical FTE's (if Applicable): B BC E EGIcc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VIw ,kUiBFhu!,sn{`c)JE05MOKUBNoB+[j ^p{w2!FʥpާpJʇ5,46BErюdHߣHHϯިˆ @vA8sh\NZ7ͽҿP~(`9gckXuz5 o^P A~0B-^omu^r|s ߪ- A1%t ]m4Ֆ NxQ KTCY]j KZKcP@$I=9P]DɘD1^R&`UT7ax6x"$3ׯ^>}ygNR̭]Yv(L?~_xSⅉo~]aPś/^՟?=wxhlG$»O,:1(FIJ@1vޙ#c;9 xk:L̷1FwකˈhFG5wV 䕸\vclѼGQ*QS,=uM1v!V\H`=">"ΐ*I /sAH>U𱍄QVoD% !p2aʼ~p^#Aai?FrI.1cn̅46)(11 QאnLCt-@\MJQwfܑ[Y; Ze@-IOHz({QvǺFݎ\P8q>S+ T0<,pn/ܛ嫗Bx=kW;d}B(9ŇBpNZqybdEi390Flkru$ ao䈅yVSg\<j Vl#}V^P!aLfvh-U Wv%,וEX2+q`u0#8R!C<Ջd^e7ӪE,*`qyjuy# l:2N5zu{R JkIu],.k[JAS7P2:5ɠv"˳@d\qp-:$DbQt|2 4ն@[rm$N2Lp ʹ#*%(|λ`efaxc:XUS ?C ,MSCF{,90R//Uncompressed-Data//e9>!CKUYHQ>_ьr1iudmFɦ1ȴh%! ڍ h -"h"5`swgswMB.P҈ ~E~OsB|0ͲɜkT/ja;ŇZ]ԕ[QMMbK{$YTBj {$"$[miC[υi>\O137Ш./fD'rWv;kLRmuMD`odhgJG~`S6.Z4:VOU\JRO>W`dY#4pCһ ~FxD*Yb")|mmRS?)Tljf *RЗ9;֜R9zVMe۸oC9dE%=W[e"Xnd??/Ơ%g-5Rmu<^p~#~Z6aأT"r-:{7i13"RC6dwWWoY ,H\gdDeO0D.^Y#RMƶO7JMF̤</P= w".xL_;,b9RcTnz慭Nly О鏿 p&~_ZR}P@qt+,rɴUS_zʍoL8#8a2ANyn!lq3Yx.{OZBǵM^#e(C<COM5excel.exejgiamma 16.0.16130.206448M?"DXX333333?333333?&03U} I0A} A} $A} $ A$   , , ,b ,b ;F  , , , , ;  ;  ,F ,F ,F ;F  ;  ,F ,F ,F ;F  ; ;F  ; , ,_ , , rrrrrrrrr B a1 a a a i% g& a ss c0eefhjkpq dtuuuuuuvCCDCEECCC ^) G G" G G! G G# G G$ H IJIJIJIJ H  IJIJIJIJ H4 IJIJIJIJ K  IJIJIJIJ L # @  %  # M %   @   -  M   @   M   @   M   NNONONONO m2 G G G GEC QRRRREC SRRRREC T#U % #U % #U % #U  % CC V !WC DD !WC DD !WC DD !WC DD XXNNONONONO m+ G G G GNONO YRRRR ECC YRRRR ECC Y#U % #U % #U % #U % ECC V.&WDD &W DD &WDD &WDD  ZCX L!n D D!n D D!n D D!n D D ZCX[\]\]\]\\CCCCCC___ P `` o'oooo o* oo l(B X(z((~((((1Z44X00  ,!,#, o, oo l- !A/ #A3 (*>@  : fyK Census Enrollment DashboardyK https://powerbi.utoledo.edu/Reports/powerbi/Institutional Research/General Inquiry/Census Enrollment DashboardyX;H,]ą'cz yK Section Net Revenue ReportyK https://powerbi.utoledo.edu/Reports/powerbi/Institutional Research/Deans - Chairs - Business Managers/Section Net RevenueyX;H,]ą'cggG ZO $  dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD ZO   dMbP?_*+%,&ffffff?'ffffff?(?)?",333333?333333?&<3U>@ggD  !"#$%&'()*+,-./0124DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. metaAttributes"/> Oh+'0HPl Grant, Brenda S.Hadeed, Lauren CarrollMicrosoft Excel@Wtu@bĄ@i2.Y ՜.+,D՜.+,h PX|  ' Faculty Data SheetCopy of PCN Rosters HereCopy Census Enroll Report Here 'Faculty Data Sheet'!Print_Area  Worksheets Named Ranges0qy _PID_HLINKS SS VersionContentTypeIdA@  zhttps://powerbi.utoledo.edu/Reports/powerbi/Institutional Research/Deans - Chairs - Business Managers/Section Net Revenue,=ohttps://powerbi.utoledo.edu/Reports/powerbi/Institutional Research/General Inquiry/Census Enrollment Dashboard14.8,0x01010010AFA60683BEC2478439232BEFC2B7FF F Microsoft Excel 2003 WorksheetBiff8Excel.Sheet.89q