ࡱ>  dg~~f  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abchfcijklmnopqrstuvwxyz{|}~Root Entry F[)e|WorkbookA_VBA_PROJECT_CUR"1T$Fp$MsoDataStore:8T$Y$YHWZECZ==2T$pY$Item SProperties M5KGOBFB==2T$Y$Item  Properties!OCtls VBA7Y$@Je$ ɀ\p Guangmin Xie Ba=  ThisWorkbook= %8@"1Arial1Arial1Arial1Arial1Arial1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1& Courier New1.Times New Roman1!Arial1.Times New Roman1Arial1&! Courier New1& Courier New1Arial1.Times New Roman1Arial1.Times New Roman1.Times New Roman1 Arial1Arial1.Times New Roman1.Times New Roman1.Times New Roman1.Times New Roman1& Courier New1Arial1.Times New Roman1& Courier New1.Times New Roman1.8Times New Roman1 Arial1$Arial12Bookman Old Style1Arial1.Times New Roman1.Times New Roman1&  Courier New1 Arial1. Times New Roman1.Times New Roman1.Times New Roman1Arial1.Times New Roman1.8Times New Roman1. Times New Roman1.Times New Roman1:Arial Rounded MT Bold1Arial1. Times New Roman1Arial1 Arial1 Calibri1Calibri1Calibri1 Calibri1 Calibri1Calibri1Arial1Calibri1,>Calibri1>Calibri1>Calibri1>Calibri1 Calibri1Calibri1?Calibri1h>Cambria1 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\);_(* "-"??_);_(@_)4/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_)0+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_)83_(* #,##0.000_);_(* \(#,##0.000\);_(* "-"??_);_(@_):5_(* #,##0.0000_);_(* \(#,##0.0000\);_(* "-"??_);_(@_) 0.0%00 "$"#,##0 "Line"\ 00.0 00000 0.000 0.0000 0.00000=8_("$"* #,##0.0_);_("$"* \(#,##0.0\);_("$"* "-"??_);_(@_)94_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"??_);_(@_),'[<=9999999]###\-####;\(###\)\ ###\-####3._(* #,##0.0_);_(* \(#,##0.0\);_(* "-"?_);_(@_)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) 0.00000000000 0.########### ##########[$-409]h:mm:ss\ AM/PM$[$-409]dddd\,\ mmmm\ dd\,\ yyyy 0.?????????? 0.???????????                6  6  6  6  6  6  6  6  6  6  6  6  7  7  7  7  7  7  8 89 ,9  8  8 9 9 8 8 9  9 8 8 69 9 8 8 9  9  8  8  9  9  8 : .;  < ff+ ) , * = 8 = 8= 8> $ ?  @ P A P B B # C  D ` E 9     F  G G = a8 H    &  1.  @@  1&@  1&P @  @ &       !  @  P@  @@ " @     P  D  D + D  D + D  D  1"D  +"D  "D  1*D  1.D 1*D 1.D 1.D   D  ! D  D % D %.x@@ D+ %.x@ D+ %.x @ D+ !D+ &D+  D+  D+ & D+ & D+ & D+  1" D+  1"D+  1"@ D+  1* D+  1* D+  1* @ D+ 1. D+ 1. D+  D+   @ D+ & D+  D+  1*D+ 1*D+  D+ &U@ D+ D+ &xU@   @ 1"|  1&|  1&|@  1&|@  1&|   1&|@   h@  H 1*|  1*|  1*| @  1*| @   `@ 1.|"@   `@@  h   h@  h  @   h@  h    h   hP@  &x"@   H   @ @    @  1.|   1.|   1.|   1"|   1"\  1&|@   1*|   1*|   1*| @  &x  &t  .x`@  x`  x@ &xU@   H  &X &X  h@ &x@ &x @ &x@  &x  @   h  &x  &x   "x   "x @   "x  1#|  1&|  &x   L %#|  1"|   l  1#\ 1&\ &|  1#|&@  1&|&@  &x& @   h x"@  x 'x@@ (x@ .D+  D+  H 'x@  `` @  ``   ```   1  1*    @  & !   " && &U@ &U@ 1. 1. &"@ & &   1" 1. &"@  &   1&  1&@  1&@  1&   1&@  1&@@  1&  @  1  1 @  1 @ #@ ) ) ! @ )  @ ) @ ) !@ @ ) @ @ )  @ ) @ ) !@ @ ) @ @ )  @ ) ) !@ ) @ )  !  ! P  ! P  ! PP ) )  ! P  ! PP ) @ @    @ ` @ ` ``  @@ .`@  1"  1* )" ) " )"@ ) "  @ )" ) " " "@  "  "  @    #  !# ) D+ )  @ D+ ) D+ ) D+ ) @ D+ ) D+ ) @ D+ ) @ @ D+ )  @ D+ ) l  ) l! @  ) l @  ) "|  )"|  )"\ ) l@  ) "|  )"|@  ) l@ @  ) h&@  ) h&@ @  ) h & @  ) !@ @ ) !!@ @ ) @ )  ) @ &D+ 1#|@  1#|a@  %#|a@  1"|a@   la @  " "  1"   1*   L + H + h ) "!!@ @ " 1 1 %   1 1 @ 1 1 #T #\  #|@  #|P @ *!#| *!#|P  +#|@ *!#|PP  #\ #P #X  1#|@  1#|P @ * !#| * !#|P  #X &xP  @ .U@ 1 D+ ) l@ ) l!@ @ ) l@ @ ) l  @ ) l@  ) l!@ @  ) l  @  ) L ) l!@  ) l  ) l@ @    )x  @   h  h  @  h ")@  h  @ )x  @  h    @ @  x@  h@  )x@   h  1.|@  "@ @   1*| @     @    ! @    !@ @  ) l@ ) l@ @ ) l"@@  ) l!"@ @  ) l"@ @  ) l"@  ) "|!@  * !#|  * !#|P   #|@  #|P @ * !#|Q@  * !#|PQ @  ) !@ @ *p &x"@  &p"@  &p " @  1*|! @  -x"@   1*| @ x /&x""@ @  1.| &x   !@ @    !@ @    !!@ @  ) l  ) l @ ) l @  ) l  ) l @ ) l" @  1.| " @  &x " @  2 H / H , H  H "X  H  !!@ @  1"|  "@ @    @ @   !@ @     @ / P ! , H    @   @      "@   @ @   @ @    !@ @    !!@ @    !@ @    ! @    !@@    !@    ! @    @ @   @ !   @ @    !@ @   @ @    @   @ @    !@ @    @ @     @    @          !@    @     @     @     @      %.x@ F+  @ @   a@ @   !@ @   !@ @   !a@ @   "@ @    @   @ @   !@ @   !@ @  !@ @ .!@ @  #D+ # @D+ !@ !@ @ D+ 1"|@@  1"|  @  x@ x 1*|@@ 1*|  @ 1*| @  1*|  (X &" 1 @ 1 1 35 3 ||]}<} yyyy_)ef\([$}<} yyyy_)ef\([$}<} yyyy_)ef\([$}<} yyyy_)ef\([$}<} yyyy_)ef\([$}<} yyyy_)ef \([$}<} yyyy_)L\([$}<} yyyy_)L\([$}<} yyyy_)L\([$}<} yyyy_)L\([$}<} yyyy_)L\([$}<} yyyy_)L \([$}<} yyyy_)23\([$}<} yyyy_)23\([$}<} yyyy_)23\([$}<} yyyy_)23\([$}<}  yyyy_)23\([$}<}! yyyy_)23 \([$}U}" yyyy_)[$ -##0.}U}# yyyy_)ef[$ -ef##0.}U}$ yyyy_)L[$ -L##0.}U}% yyyy_)23[$ -23##0.}U}& yyyy_)[$ -##0.}U}' yyyy_)ef[$ -ef##0.}U}( yyyy_)L[$ -L##0.}U}) yyyy_)23[$ -23##0.}U}* yyyy_)[$ -##0.}U}+ yyyy_)ef[$ -ef##0.}U}, yyyy_)L[$ -L##0.}U}- yyyy_)23[$ -23##0.}U}. yyyy_)[$ -##0.}U}/ yyyy_)ef[$ -ef##0.}U}0 yyyy_)L[$ -L##0.}U}1 yyyy_)23[$ -23##0.}U}2 yyyy_)[$ -##0.}U}3 yyyy_)ef[$ -ef##0.}U}4 yyyy_)L[$ -L##0.}U}5 yyyy_)23[$ -23##0.}U}6 yyyy_) [$ - ##0.}U}7 yyyy_)ef [$ -ef ##0.}U}8 yyyy_)L [$ -L ##0.}U}9 yyyy_)23 [$ -23 ##0.}U}: yyyy_)[$ -##0.}}; }yyyy_)[$ -##0.   }}< yyyy_)[$ -##0.??? ??? ??? ???}U}A yyyy_)[$ -##0.}U}B yyyy_)[$ -##0.}U}C yyyy_)[$ -##0.}(}D yyyy_)}U}F ayyyy_)[$ -##0.}A}G yyyy_)[$ -}A}H yyyy_)?[$ -}A}I yyyy_)23[$ -}-}J yyyy_)}}L ??vyyyy_)̙[$ -̙##0.   }A}M }yyyy_)[$ -}U}N eyyyy_)[$ -##0.}-}O yyyy_)}}Pyyyy_)[$##  }}Q ???yyyy_)[$##??? ???  ??? ???}-}S yyyy_)}-}T yyyy_)}U}U yyyy_)[$##}-}V yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(}yyyy_)}(} yyyy_) 20% - Accent1H 20% - Accent1 ef  20% - Accent2H" 20% - Accent2 ef  20% - Accent3H& 20% - Accent3 ef  20% - Accent4H* 20% - Accent4 ef  20% - Accent5H. 20% - Accent5 ef  20% - Accent6H2 20% - Accent6  ef  40% - Accent1H 40% - Accent1 L  40% - Accent2H# 40% - Accent2 L湸  40% - Accent3H' 40% - Accent3 L  40% - Accent4H+ 40% - Accent4 L  40% - Accent5H/ 40% - Accent5 L  40% - Accent6H3 40% - Accent6  Lմ  60% - Accent1H 60% - Accent1 23  60% - Accent2H$ 60% - Accent2 23ٗ  60% - Accent3H( 60% - Accent3 23֚  60% - Accent4H, 60% - Accent4 23  60% - Accent5H0 60% - Accent5 23 ! 60% - Accent6H4 60% - Accent6  23  "Accent1MAccent1 O O %# Accent1 - 20%Y Accent1 - 20% ef ef %$ Accent1 - 40%Y Accent1 - 40% L L %% Accent1 - 60%Y Accent1 - 60% 23 23 % &Accent2M!Accent2 PM PM %' Accent2 - 20%Y Accent2 - 20% ef ef %( Accent2 - 40%Y Accent2 - 40% L湸 L湸 %) Accent2 - 60%Y Accent2 - 60% 23ٗ 23ٗ % *Accent3M%Accent3 Y Y %+ Accent3 - 20%Y Accent3 - 20% ef ef %, Accent3 - 40%Y Accent3 - 40% L L %- Accent3 - 60%Y Accent3 - 60% 23֚ 23֚ % .Accent4M)Accent4 d d %/ Accent4 - 20%Y Accent4 - 20% ef ef %0 Accent4 - 40%Y Accent4 - 40% L L %1 Accent4 - 60%Y Accent4 - 60% 23 23 % 2Accent5M-Accent5 K K %3 Accent5 - 20%Y Accent5 - 20% ef ef %4 Accent5 - 40%Y Accent5 - 40% L L %5 Accent5 - 60%Y Accent5 - 60% 23 23 % 6Accent6M1Accent6  F  F %7 Accent6 - 20%Y Accent6 - 20%  ef  ef %8 Accent6 - 40%Y Accent6 - 40%  Lմ  Lմ %9 Accent6 - 60%Y Accent6 - 60%  23  23 %:BadEBad   %; Calculation Calculation   }% < Check Cell Check Cell   %????????? ???= Comma>( Comma [0]?&Currency@. Currency [0]A Emphasis 1S Emphasis 1  r %B Emphasis 2S Emphasis 2  sq %C Emphasis 3S Emphasis 3  z %DExplanatory TextB5Explanatory Text E : Followed Hyperlink FGoodGGood   a%G Heading 1G Heading 1 I}%OH Heading 2G Heading 2 I}%?I Heading 3G Heading 3 I}%23J Heading 49 Heading 4 I}%K( Hyperlink LInputInput ̙ ̙ ??v% M Linked CellK Linked Cell }% NNeutralMNeutral   e%"Normal ONormal 27Normal 2 % PNoten Note    QOutputOutput   ???%????????? ???R$PercentS Sheet Title= Sheet Title I}% TTitle1Title I}% UTotalMTotal %OOV Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight168 ``i̜̙3f3333f3ffff333ff333f33f33BBB\`)Section1Section2(Section3Section4Section5NSection 2 (Est.)عSection 3 (Est.)Validity Checks\Macros 2  ;,   ;!  ;(   ;-   ;#  ;O  ; UploadData_Click% ValidateSection1_Click% ValidateSection2_Click% ValidateSection3_Click% ValidateSection4_Click% ValidateSection5_Click H {"%GdzUTRAm@=GdzUTRAmC'ܼ xTMkQ=o" USii[KB$!M@dp%х u!PܸpE]].юdP*^8sxK %".LpH\Gr|J?FnBX)f+'**~ztp Zʩ8A%X5n.Nߌx:Xup;P&C+RlgQjzT5 BI̥Rb.[fW/ClW,[Ueg1k;L r)[# }<]Cbv"NN=IhՆPPA8 k/oD(O؃/ˇ}o#_'~߱W2yҠ h#" (98H`iشŲC[K+n8@FR|$ c>쓪[ӏ ]kO~?upww8$]I>f{<z6ɶ~Cy+WӪ{Ye[uLM!Oٮ7Ѹ,ѷ\K+>OFtzC6(ؑ DP}ECSCLșԚ[682'i 鐪#B0ޘ0{Jrky'!Q$:suOBIߤp"y('Պ:B|ˆw@=oy('Պ:B|ˆHI8s w =xTMkSA=oWڦC)!Z. ?XC?_EYte}n.s͍I Nνgν73Iav@G0_} D`+H𞘶 _?#PbSz}ne+XGM Y{Qק-LgP&# n8~~b/80gU4J`u<+Aݩ4^ ymW&e"s=TJGrm~V3p3 |~ )/8*;Eh6e0G>VI8r~?bd'yr6g'WQݎGMA(vTy}_q[Q:8=*}_,9Mٛ^eMVx ^CMZ^\ЪD%>2"zpSnXWGUCN'޾E'|ޱ05߽W;Fgazu}˘%'dzOVK PgqKD?k`}p̪f/ߍNmh!7)x"ȷ Aǚ=@=ȷ Aǚ= v(xUMk\U~dRj6ƢL(F#A R|43хn\(n\q,>ϹL/cgy?{{{o a^|)`_z0R}4#wuL `q~6T՟O;41>ɨ2Uwn)Yڲ+.)< Qb/=s͝~ĶnGvp};#$s^ϲz@YN ш8&^?l[6Jvu^ڲ qլ gG233es[,Ǻis`5-Ҡmi%^iZ}eƿzή-w{PXS}tWq4QM Ab%͢Ǥ8s8B0Y'i/7;kP/Y}Gι?sy oFyWR{;E;#":|-M]M_ݱfj:V&He*;}c̯Vq᣽to?#^;gO&-5eo-ѴOMV~!W_w?Kd/l-yCW]K%Tynvk$;JN)Z6R:yt?z/R=,#ҙ=JD>NQc6޺/o'$w7kpzH`oszw֢%_, &p m2.rw~:/P?>h/1#$9x븱pвM3Q* f1aխܦwz61W9)e{<Z>W֛'U q/oju2_6)|L1zJL(Goơm!K?OFtzCdYJuob0D(=z_1BS;#bsq892ulub8 .4suhA"٤#[}($wyo]cx B|Uu# ^h"Pީc@=PީcC(ܼ xTMOSQ=1 Bb\j5˜.lB i6/.Llb4D ;D,t%{.#i:ɗ4RBГas˒}rH 7͸|!Nr*ȻJ\>FH=s"$} 0{Kx@=$} 0{Kxp*x.CQ׹U-K!~D ~#yhx L $Fս޻{OotmD{0iƃG]z,KgR̀4xRɩksj,7PqgVIںX-O IۜJ*FrYX-iÏ?ɲ'3W}4?wC!|){5ͼ wE!AF%ܛS5j,cfi¨U-R#i9iF>>sgjݟE55 h_n[#{xxsv3˩.dns8`NvQˋvE|˲=Ff<50{zuK G3 A@@   Institution:Respondent Name: Phone Number:E-Mail Address:MENWOMEN(1)(2)(3)(4)(5)(6)(7)(8)(9)(10) Academic RankNumber of FacultyTotal Contracted Salaries ($)Not Tenure-TrackOn Tenure-TrackTenuredYPart a. Faculty on 9-Month Contracts (i.e., regardless of number of salary installments) 1. Professor 2. Associate 3. Assistant4. Instructor 5. Lecturer 6. No Rank 7. TOTALMPart b. Faculty on 12-Month Contracts (i.e., on actual basis, no conversion) PROFESSOR ASSOCIATE ASSISTANT INSTRUCTORLECTURERNO RANKMajor BenefitsTotal ExpenditureNo. Cov.BENEFITS AS PERCENT OF SALARY BENEFITS AVERAGERPart a. Faculty on 9-Month Contracts (i.e., regardless of number of installments) ALL RANKS1. Retirement 2. Medicalo*Benefits in kind reported under "Other" are those with cash alternatives (e.g., moving, travel, housing, etc.)**Benefits that are not computed as a percentage of salary are not subject to conversion (medical, disability, tuition, dental, unemployment, other)6Please refer to instructions for complete definitions./Part a. Full-time Faculty on 9-Month ContractsNumber of Continuing FacultyTotal Salary OutlaysPercentage Increase0Part b. Full-time Faculty on 12-Month Contracts[(Pr.=Professor, Ao.=Associate, Ai.=Assistant, In.=Instructor, Le.=Lecturer, and NR=No Rank)7These cells are used in the "Validity Checks" worksheetSalary9-Month12-Month IntervalsPr.Ao.Ai.In.Le.NR1.$270,000 and Over2.-3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.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.67.68.69.70.71.72.73.74. Below 30,00075.TOTALTotal INSTRCUTORx**Benefits which are not computed as a percentage of salary are not subject to conversion (e.g., medical, tuition, etc.)%Part a. Faculty on 9-Month Contracts&Part b. Faculty on 12-Month ContractsSec IVSec IV / Sec I Outlays Total Faculty Tenure Status Average Men Average WomenOutlays Benefits No. Cont. FacultyCurrent Yr. OutlaysPercent Increase No. FacultyEstimated Outlays Difference Combined convertedPresident/Chancellor Chief Administration OfficerChief Development OfficerChief Financial OfficerChief Academic Officer Base Salary Supplement#Note: Please refer to InstructionsBData Entry Validity Checks for Various Sections (See Instructions)Section III. Continuing Faculty#Section I. Salary and Tenure StatusSect. IIRPlease complete the following fields to ensure proper identification of this file.CConversion factor for 12-month faculty salaries (see instructions):CPart c. (Calculates automatically) 9-Month plus 12-Month ConvertedEPart c. (Calculates automatically) 9-Month plus 12-Month converted**CPart c. (Calculates automatically) 9-Month plus 12-Month convertedMPart c. (Calculates automatically) 9-Month plus 12-Month contracts converted~For those institutions not able to complete columns (1), (2), or (3), see the instructions and the Section III (Estimate) tab. 3. Dental5. Disability 6. Tuition7. FICA8. Unemployment9. Group Life10. Worker's Comp. 11. Other* 12. TOTAL+4. (Optional) Medical combined w/dental  2. Medical** 3. Dental**)4. (Optional) Medical combined w/dental** 5. Disability** 6. Tuition**8. Unemployment**+4. (Optional) Medical combined w/dental+4. (Optional) Medical combined w/dental0 "4. Combined Medical/DentalUnit ID:cPart b. Faculty on 12-Month Contracts (give actual amounts here and enter conversion factor below)Please include all faculty members reported in section 1. If both 9-month and 12-month contracts are reported in section 1, please use the same format here.QAmerican Association of University Professors Faculty Compensation Survey 2010-11`Section 1: Number, Total Salaries, and Tenure Status of Full-Time Instructional Faculty, 2010-11FSection 2: Major Benefits for Full-Time Instructional Faculty, 2010-11Totals by Rank^If reporting by rank, use the cells below. Otherwise, use "Undifferentiated Rank" to the rightUNDIFFERENTIATED RANKYSection 3: Salaries and Percentage Increase for Continuing Instructional Faculty, 2010-11sPlease Note: Individuals reported in Column (1) should be only those who held faculty positions in both 2010-11 and (l2009-10. This number will almost always be smaller than that in Section 1 of this report. Report individualsZ'pin the row for the rank the person held in 2009-10. If you have questions, see the instructions or contact AAUP.2( in 2009-101 (2) Current Yr. (2010-11)(3) Previous Yr. (2009-10)CSection 4: Distribution of Full-Time Instructional Faculty, 2010-111Section 5: Compensation for Senior Administrators Instructions:For each administrative position, enter the annual amounts for 2010; report amounts for one individual only and for the institution specified in this data file. Use the most current figures available and convert partial-year figures to an annual basis.6 Base Salary is the contractual base salary provided by the institution.  Supplement is the cash value of any supplemental compensation provided by the institution or a private foundation. Include additional direct compensation supplementing the base salary, including bonuses or deferred compensation, which might come from the institution itself, directly from state government, or from an affiliated private foundation. Do not include housing, entertainment, travel allowances or general expense accounts, club memberships, or tuition allowances for dependents.Confidentiality Notice:The figures supplied in this section will be used for aggregate calculations only; they will not be published or disclosed for individual institutions.Section 2 -- Estimating Benefits by Rank, 2010-11 (Use of this worksheet is optional, and applies only if benefits by rank are not available; see instructions before completing)2,3/,Section 3 -- Estimating Percentage Increase for Continuing Instructional Faculty, 2010-11 (Complete only if actual salary amounts are not available; see instructions before completing)Z,[/, Survey Year:In order to use this data file, please enable macros. In the  Security Warning line above, click the Options button, choose  Enable this content and then click OK.Note on copy/paste: Improperly formatted data may create problems for the validation checks and formulas built into this file. For best results, if you want to copy data from another source-including another Excel file-use only the "Paste Values" function. If you paste in values with decimal points or commas, the file may not function properly. If you need help with this feature, please contact AAUP Research. 5Application Ver 1.7.2.919Kwadwo Owusu-Aduemiri, Director of Institutional Research 850-412-5156 oir@famu.eduݔ ;jlKz0k(W#RN}~ޛ =>mnל ` : ; W ֢"Ѯ.]cc4c =_MA ɀ C#  dMbP?_*+%&?'?(?)?MXerox WorkCentre 7345 PCL6S oD,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationPORTRAITCollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰr?@ABCDEFGHIJKLMNOPQRSTUWXYZ[\]_`abcdefgijklmnpqrstuvwxyz{|}~":5j(6(!C4 Bͫ= \2#\2##-?@,+Authenticating user.R(@Microsoft Sans Serif#-?@8+Validating all sections data.(@Microsoft Sans Serif#-?@,+Gathering data ..rif(@Microsoft Sans Serif#-?@h+NStatus : Data uploaded successfully. Last Update date/time 01/20/2011 09:17 AM (@Microsoft Sans SerifҋB `$H=(@Microsoft Sans Serif ݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "D,,??&cU} m} l} l}  l}  l}  l} l}  l} l} $ } $ l} mn} mo} $ l}  l}  l} $ l} $ lC\@@)@)@)@)@)@)@)@ @ )@  Y0 m0 ru w  |  | ~   ll         ll ~ PA ll    ll   \\\\ ll   \\\\ ll   \\\\ ll ~ l@\\\\ ll\\\\ ll  \ ll \\\\ ll        pq           st               vvvv   xy BL@ 0@@H@=@6@?:@ zzz{ BQ@L)@.@I@L@:b@5@@@ zzz{ BM@h<@:@@L@*3@@@@ zzz{ B1@HP-A1@9@L7@@ zzz{  zzz{  zzz{ Ah@ -B skABJ@BF@CY@Ad@ByeABG@  BL@  CO@zzz{   zzz{ BL@:g??K@2@l??0@ zzz{ B<@CA?@5@;@2*"@2@ zzz{ B3@U@$@@@@@9@? zzz{ B$@#$@1@=/A1@ zzz{  zzz{  zzz{ A@\@ -@B@cAB2@B1@CS@AW@B<]AB9@  BA@  CA@ zzz{   zzz{D@lP:NNNNNN.:.,^@ffff>>qDffff>>q !"#$%& '(h@)*+,-./0 1 2 3 4 5 6 7 8 9 : ; < = > ?   D\@   % LL E]TNbA  %LLD(  E@   % LL E@   FY@   % LL DG@   % LL EAtQMA   %LLD(  E@   % LL E@   FE@!   %  LL zzz{ !!GX@! !H.IZA! !H@! !H5@# !IQ@! !GT@! !HJtQz"WA! !H@!  ! H>@" ! II@#  !zzz{ ""D@S@" "E;jRA" "EA@" "EB@$ "F@" "D@V@" "EEhGUA" "E:@"  " EM@"  " F@# "zzz{ ##G;@# #HE5A# #H;@# #H" #I# #GE@# #H \t.?A# #HD@#  # H@$ # I&  #zzz{ $$D$ $E$ $E$ $E! $F$ $D$ $E$ $E$  $ E$  $ F% $zzz{ %%G% %H% %H% %H% %I% %G% %H  %H%  % H%  % I& %zzz{ &&As@&&& -@&BNouA&&&BQ@&&&BN@&&&Cf@&&&APp@&&&B٢ pA& &&BR@&&& BW@&&& C@X@!&&zzz{' '} ( (          ( 6z袋.?( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ? Dl,VVVVVq*F @ A B @ A B ( \    l  =$       ! "! e" ("  # # $# $ !$ %% '%  % U"'%  :& & #& #& & && )& & '&  ^ F(  ~  <>~CC@ @ ],@>~@4y~;~9  $<Validate Section 1<j  ~~  <?~CC@ @y  ],@?~` y~>~9 $ < Upload Data<G   JA ?@ProgressBar1  N] 0 &y~xMSComctlLib.ProgCtrl.2`H9368265E-85FE-11d1-8BE3-0000F8754DA1x  >A ?@Label2 u 0]X 0 .z~ȼ Forms.Label.1`lx  >A ?@Label1 u ]X 0 .z~ Forms.Label.1xx  >A ?@Label3 u ]X 0 .@{~ܼ Forms.Label.1Dlx  >A ?@Label4 u  ~]X @0 .}~ Forms.Label.1~v  s <A ?@TextBox1 ]Z 0 0}~Forms.TextBox.1XdP>@dB(( ((  7 Sheet1ggD ɀ .-  dMbP?_*+%&?'?(?)?MXerox WorkCentre 7345 PCL6S oL,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationLANDSCAPE_CC90CollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "L,,??&cU} m} $ } m} $ } m} $ } m} $ } m} $ } m} $ } m} $ } m} $ } m} I} I}  |} I |}  |}  |} |}  |} } I}  s} I s}  s}  s} !!s} "" s} #$ .##J #J # #  #w@0####3@ # # # # ### # #0#### ####### # #J@0# (        ! "  #  $   }}}}}}}ttttttt" % & ' & ' & ' & '  &  '  &  '  & ' & ' ( )" *& ~ ~ ~! ~" ~# ~$ + u u u! u"  u# !u$ "v+ ,6v>T@I^@N9@[@AD@  9 JA  #DDDDD D 9v@#DDDDD D   ,Sj1^? =ZZ DZZBSS(7? =ZZ DZZBS*? =ZZ DZZBS™P? =ZZ DZZBS  =ZZ D ZZBS =ZZ D ZZBr2!L? \ZZ <DDDDD D ZZB ,w(@ iD (D CHECK"3D  CHECKDD"BwwwwwW@iD (D CHECK"3D  CHECKDD"Bwi?Y@iD (D CHECK"3D  CHECKDD"BwffffF@ iD (D CHECK"3D  CHECKDD"B w(!iD  (D  CHECK"3D   CHECKD D "B!w "iD  (D  CHECK"3D   CHECKD D "B"x颋.J@ DDDDD D  GDDDDD D  CHECK"DDDDD D   CHECKPDDDDD D DDDDD D "B -6'AS@;@\@7X@PA@@  9 ]>FA #DDDDD D 0t@- #LLLLLL  -S3斮? =ZZ DZZBS? =ZZ DZZBSAY[? =ZZ DZZBS? =ZZ DZZBST  =ZZ D ZZBS  =ZZ D ZZBrڧ(? %\ZZ <DDDDD D ZZB -w؉@s*!iL (L CHECK"3L  CHECKLL"BwlK@s* iL (L CHECK"3L  CHECKLL"Bw$ @s* iL (L CHECK"3L  CHECKLL"Bwl&e@ s* iL (L CHECK"3L  CHECKLL"B w ! s* iL (L CHECK"3L  CHECKLL"B!w 8 "!s*!! iL (L CHECK"3L  CHECKLL"B"x-@"*"" LLLLLL GLLLLLL CHECK"LLLLLL  CHECKPLLLLLLLLLLLL"B  9  #DDDDD D   S =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS  =ZZ D ZZBS| =ZZ D ZZBr $\ZZ <DDDDD D ZZB w w iD (D CHECK"3D  CHECKDD"Bw iD (D CHECK"3D  CHECKDD"Bw  iD (D CHECK"3D  CHECKDD"B wX !iD  (D  CHECK"3D   CHECKD D "B!w "iD  (D  CHECK"3D   CHECKD D "B"x4 DDDDD D  GDDDDD D  CHECK"DDDDD D   CHECKPDDDDD D DDDDD D "B     - #LLLLLL  S =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS =ZZ D ZZBS =ZZ D ZZBr &"\ZZ <DDDDD D ZZB w@ w8 wwp  w ! !w"!"x  "          S  =ZZ D ZZBS  =ZZ D ZZBS  =ZZ D ZZBS  =ZZ D ZZBS \ =ZZ D ZZBS L  =ZZ D ZZBr  %\ZZ <D D D D D D ZZB  w  w   wD   w   wh  !  !w0  "! "x|  "          S  =ZZ D ZZBS  =ZZ D ZZBS  =ZZ D ZZBS  =ZZ D ZZBS   =ZZ D ZZBS   =ZZ D ZZBr  #\ZZ <D D D D D D ZZB  wd  w   w   w  wl  !  !w  "! "x  " 6 HO#AT@b3^@#A@[@X AD@   AA   v@   S ո? =ZZ D ZZBS iN? =ZZ D ZZBS gA0? =ZZ D ZZBS ~Xŷ? =ZZ D ZZBS   =ZZ D ZZBS ` =ZZ D ZZBr UwF:? \ZZ <D D D D D D ZZB  wM_ǽ@  w3333g@  wq@  w]ڕ@  w  !  !w  "! "xLչ@ " 6 @@U@@V@_@@\@@E@   A   v@   S &px? =ZZ D ZZBS x$G0x? =ZZ D ZZBS a6mx? =ZZ D ZZBS Jx? =ZZ D ZZBS   =ZZ D ZZBS   =ZZ D ZZBr Erx? \ZZ <D D D D D D ZZB  ws@  w{/{@  wP^Cy=w@  wys@  w`  !  !wl "! "xnz@ " 6 @@Q@g@W@@@Q@n@6@   @@   o@   S b*^? =ZZ D ZZBS .o[? =ZZ D ZZBS ޠ\V? =ZZ D ZZBS !ոgbR? =ZZ D ZZBS x  =ZZ D ZZBS   =ZZ D ZZBr ӈ Z? \ZZ <D D D D D D ZZB  w%~Fh@  wX0c@  wv`xa@  w.B\@  wp  !  !w "! "xNNNNNd@" 6@@U@@V@_@@\@@E@   A  v@  S&px? =ZZ DZZBSx$G0x? =ZZ DZZBSa6mx? =ZZ DZZBSJx? =ZZ DZZBS  =ZZ D ZZBS  =ZZ D ZZBrErx? \ZZ <DDDDD D ZZB ws@w{/{@wP^Cy=w@wys@  w! !w "!"xnz@"      S =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS =ZZ DZZBS<  =ZZ D ZZBSd  =ZZ D ZZBr \ZZ <DDDDD D ZZB wwww  w! !w"!"x" J6CA(  -#K@U@ %BLHA#K_@ %BJ7CA #K\@ %BL*(A#KE@ %B J # K % B L# K % B# L OaA " % #Kv@ %B# %#K %B SV? =ZZ DZZBSWKs? =ZZ DZZBS/#4? =ZZ DZZBSN@? =ZZ DZZBS  =ZZ D ZZBS =ZZ D ZZBryc? \ZZ <DDDDD D ZZB w0@(*w{@ "wl(C@!"w$ID@ w  !w(!"xH@(" & ~ ~ ~! ~" ~# ~$ + u u u! u"  u# !u$ "v+ ,6')AR@AI@AI@X)A:@  9 tyV? '!=Z Z  D%Z Z BS%vALj? =Z!Z! D%Z!Z!BS%} ? $=Z"Z" D%Z"Z"BS%#UW׵? #=Z#Z# D%Z#Z#BS%x  %=Z$Z$ D% Z$Z$BS%|  =Z%Z% D% Z%Z%Br%r5? ( \Z&Z& <D%D%D%D%D% D% Z&Z&B %%w.PF%@(* %w5[@(&%w̥l0Ӝ@(%%wQXD@(%% w (%  %!w (%!%"xa@(%" &!&(@ & DD !&c@ & DD !&Sx@ & DD !&`f@ & DD !&&@ & DD !&d@ & DD !&SX@ & DD !&@Q@ & DD !&  & D D !&  & D D !& S &! D D !&  & D D !& SA ) D D &@"!& * DD !&' DD  &S&W{? =Z Z  D&Z Z BS&o"\Gz? *=Z!Z! D&Z!Z!BS&oKz? &=Z"Z" D&Z"Z"BS&. Mz? "=Z#Z# D&Z#Z#BS&  ""=Z$Z$ D& Z$Z$BS&  =Z%Z% D& Z%Z%Br&Tbr9z? %\Z&Z& <D&D&D&D&D& D& Z&Z&B &&w֥ց@('&w[@aTG}@('&wlx@(&&wRgt@(* & w (% &!w (& !&"x=|@('"" '+'XE@ (D DZ( !'`@ ' DD +'P?@ 'D DZ( !'`@ ' DD +'{Ltš@ 'D DZ( !'W@ ' DD +'PH袋@ 'D DZ( !'C@ ' DD +'  ' D D Z( !'  ' D D +' P 'D D Z( !'  ' D D +' P͢NS@ D D Z( 'y@+' 'D DZ( !'( DD  'S'k^? %=Z Z  D'Z Z BS'lYZ? =Z!Z! D'Z!Z!BS'RPT? '=Z"Z" D'Z"Z"BS'~cS? "=Z#Z# D'Z#Z#BS'  #=Z$Z$ D' Z$Z$BS'  ' =Z%Z% D' Z%Z%Br'0OgY? *\Z&Z& <D'D'D'D'D' D' Z&Z&B ''w /T˺g@(''wjLd@(''w8 Da@(''w!ýJ[@(' ' w ('  '!w (* !'"xFYc@(" (+(Ft@ )DDZ( !(c@ ( DD+(S$@ (DDZ( !(`f@ ( DD+(.]0@ (DDZ( !(d@ ( DD+(SEݤ@ (DDZ( !(@Q@ ( DD+(  ( D D Z( !(  ( D D +( S ( D D Z( !(  (! D D +( S\t1 A D D Z( (@+( (DDZ( !() DD (S(blx? ("=Z Z  D(Z Z BS(@8 {x? (=Z!Z! D(Z!Z!BS(ogx? (=Z"Z" D(Z"Z"BS(Rt[x? (=Z#Z# D(Z#Z#BS(  )=Z$Z$ D( Z$Z$BS(  #=Z%Z% D( Z%Z%Br(Snx? &\Z&Z& <D(D(D(D(D( D( Z&Z&B ((w1@(((w;#a{@('(wEGw@(((wt %s@(&( w (&  (!w ((!("xwql.z@(* " )!) DD!)) DD!)) DD!)) DD!)) DD!)) DD!)) DD!)) DD!) ) D D !) ) D D !) ) D D !) ) D D !)  D D )!)) DD!)  DD )S) =Z Z  D)Z Z BS) #=Z!Z! D)Z!Z!BS) "=Z"Z" D)Z"Z"BS) '=Z#Z# D)Z#Z#BS)  !=Z$Z$ D) Z$Z$BS)  '=Z%Z% D) Z%Z%Br) \Z&Z& <D)D)D)D)D) D) Z&Z&B ))w ))w * )w $!)w ) ) w $ )!w )"!)"x "" **RtqPA("***  -#*c@  %)B*]7PA(**#*`f@ ( %)B* KA(&*#*d@ % %)B*%d3A(*#*@Q@ ! %)B* ( *#*  * %) B* (&*#*  * %) B#* iA * %) #*@$ %)B#* & %)#*) %)B *S*Cb/(? *"=Z Z  D*Z Z BS*i%K? *=Z!Z! D*Z!Z!BS*? *=Z"Z" D*Z"Z"BS*8hk? *=Z#Z# D*Z#Z#BS* $ =Z$Z$ D* Z$Z$BS* *=Z%Z% D* Z%Z%Br*!C!`? *\Z&Z& <D*D*D*D*D* D* Z&Z&B **w~@(*wZ͸@(**w0kS@(**w@@((* w (* *!w (*!*"zs @(*" +.++yyyyyy{" ,/,,{{{{{{{" -0--{{{{{{{" %E>>< {  " Z&     D*  *  * & Z $ !&   D"& " "    HEC !D"& D"" !D"  D"  D"&  D"&  "! ! $! B!" $" "  "  # # # $ $ #$ $  $ "% % % % % %  & & & &  & "' "( ( ") ) $) ) * * * *  *  *  * *  * * * J'*  r* !r (  ~  <~CC@"Q],@~$d~9  $<Validate Section 2<jC2>@22"  7 Sheet2ggDggh'h@ ɀ # $  dMbP?_*+%&?'?(?)?MXero      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~x WorkCentre 7345 PCL6S od,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationLANDSCAPE_CC90CollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "d,,??&cU} I } m} m} } } $ #Y0h@h@h@h@ 0@        @   @       1  2 3 4      R@#EQd[/? /D DDDB  \@*E6y Q r?  9 /L LLLB  Z@n5 Q3T?    B@>A =A Qf?    Q       #Nt@ % #L/ivA % #LuA % Mڕ|?"  5  2 3 4      P@*v)EQj/D DDDB L@F>x2Qa?9/L LLLB I@f^Qy'? 7@0/5AQQ]R?  Q   #Nh@ %@#L3pA %@#L`"YpA %@M55^?   2 3 4      Oa@! LL*PE{QgA DDZ( *PXBt) gA DDZ( EQFovi? /D DDDB R`e@*S5ItQmhA D DZ( *SբȁgA D DZ( Qldr?("9"/L LLLB Oc@*PebA D DZ( *P] bA D DZ( Q!E?( RN@*S HA D DZ( *S,hlLGA D DZ( Q?* ?( D l """" BFsII== BFsII== BF !"  O * P D DZ( * P D DZ(  Q(! !!R!*!S !D DZ( *!S !D DZ( !( "#"N@" %!@#"LcѕA  %!@#"LשzA " %!@"M`*^?( .( `*        B  B      e  (           U" :             ! ! ! " " " 0(  ~  <~CC@o@],@~@ P~9  $<Validate Section 3<jH>@HJ7 Sheet3ggD ɀ P=Հ  dMbP?_*+%&?'?(?)?MXerox WorkCentre 7345 PCL6S o=,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationPORTRAITCollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "=,,??&cU} } } } } } $ } } $ PY0@0 ;J                                 $ $ 6$ 7 8  9  :  9 : ;  < = > ? @  A  <  =  >  ? @ A < = > ? @ A < = > ? @ A B C NzAg LLg LLg LLg LLg LLg LLg LLg LLg LLg LLg LLg LL D,A L EzA LNSA LgggggOggOggOggg FA E,ANAgggggggggggg G A EANnA gggggggggggg H A  E  AN  A  g  g  g  g  g  g  g  g g g  g  g  I @ A  E xA N ? `6A  g  g  g  g  g  g  g`6A  g  g  g  g  g  J L A  E 8 A N   A  g  g  g  g  g  g  g  g  g  g  g  g  K  A  E K A N   A  g  g  g  g  g  g  g  g  g  g  g  g  L  A  E  A N  a A g  g  g  g  g  g  g  g  g  g  g  g  M@w A Ex A N` Agggggggg gg gg N A E8w AN ) Agggggggggggg O> A E AN Agggggggggggg P A E> AN Agggggggggggg Q@ A Ex AN`T Agggggggggggg RjA E8 AN Agggggggggggg SA EiAN?AgggggggAggggg T1A EANAgggggggggggg U@A Ex1AN?`Aggggggg`Aggggg VA E8AN? GAggggggg GAggggg W\A EAN?AgAggggggggggg XA E\ANAgggggggggggg Y@$A ExAN`rAgggggggggggg ZA E8$AN? Aggggggg Aggggg [A EAN?9Ag9Aggggggggggg \~ OA EAN@A DgA LLgggggg LLgggggf ]~ @A EZxOA`Ag LLgggggg'< LLgggggf ^~ A EZ8A?? eAg eA'6 LLg eAgggggggggg fD%Cl66Dv??????????????????????n8  ! "#$% &'()*+,-./0123456789:;<=>? _~ zA EZ A?A g  g  g  g  g  g  gA  g  g  g  g  g! f !`~ !@ !EZ!zA???,A!g,A!!g!!g!!g!!g!!g!!g,A!!g,A!!g!!g!!g!!g"!f "a~ "@ "EZ"@?@ @"g""g @""g""g""g""g""g A""g""g""g""g""g#"f #b~ #L@ #EZ#p@@??@@@@@#g@ A##g@@##g@@##g##g##g##g0nA##g0nA##g@ A##g##g##g$#f $c~ $@ $EZ$K@@@@?@$g A$$g A$$g$$g$$g$$g$$gA$$g@$$g$$g$$g$$g%$f %^d~ %_@ %`EZ%ap@??@@@w@%g@w@%%g@w@%%g%%g%%g%%g%%g@w A%%gpA%%g%%g%%g%%g&%f &e~ &^@ &EZ&@?@@@&g@&&g A&&g&&g&&g&&g&&gA&&g&&g&&g&&g&&g'&f 'f~ '@ 'EZ']@@@@??@'gA''g A''g''g''g''g''g A''g@''g@''g''g''g('f (g~ (d@ (EZ(@?@@(g(((1< LL(g(((g(((g(((g(((g(((g@(((1< LL(g A(((g(((g(((g(((g)((f )h~ )@ )EZ)c@??@?%@)g%@)()g%@)()g)()g)()g)()g)()g% A)()g)()g)()g%@)()g)()g*()f *i~ *j@ *EZ*@@@@@@@*g`~A*(*gA*(*gA*(*g*(*g*(*g*(*gA*(*gA*(*g*(*g*(*g*(*g+(*f +j~ +@ +EZ+i@@@@?+@+g+A+(+g+(+g+A+(+g+(+g+(+g+(+g+A+(+g+@+(+g+(+g+(+g+(+g,(+f ,k~ ,p@ ,EZ,@@?@?@?@,gA,(,g@,(,gA,(,g@,(,g,(,g,(,g A,(,g@,(,g,(,g,(,g,(,g-(,f -l~ -@ -EZ-o@@?@@?1@-g1A-(-g-(-g1@-(-g-(-g-(-g-(-g1A-(-g eA-(-g1@-(-g-(-g-(-g.(-f .m~ .v@ .EZ.@@@@@@@.gA.(.gA.(.g`A.(.g.(.g.(.g.(.g`A.(.gA.(.g.(.g.(.g.(.g/(.f /n~ /@ /EZ/u@@?@?7@/gA/(/g/(/g7@/(/g/(/g/(/g/(/gp#A/(/g7@/(/g/(/g/(/g/(/g0(/f 0o~ 0|@ 0EZ0@?@@@@@0g@0(0gA0(0g0(0g0(0g0(0g0(0gKA0(0gA0(0gA0(0g0(0g0(0g1(0f 1p~ 1@ 1EZ1{@@???@@@?=@1g@A1(1g=@1(1g=@1(1g=@1(1g1(1g1(1g@A1(1g=A1(1g=A1(1g=@1(1g1(1g2(1f 2q~ 2@ 2EZ2@@??@@@@2g A222;< LL2g@222g@222g222g222g222gA222;< LL2gA222gA222g222g222g322f 3r~ 3@ 3EZ3@@@@@@C@3g@eA323g@eA323g323g323g323g323g@eA323gCA323g@eA323g323g323g423f 4s~ 4@ 4EZ4@@@@?@@@@4gA424g A424gA424g@424g424g424gA424gA424g A424g424g424g524f 5t~ 5 @ 5EZ5@?@??@?I@5gI@525g@A525gI@525g525g525g525gI@525gIA525gI@525g525g525g625f 6]u~ 6@ 6EZ6 @@@?@??@?@6gA626gA626g@626gA626g626g626g@626g@626g2A626g@626g626g726f 7v~ 7@ 7EZ7@@??@@O@7gOA727g727gO@727g727g727g727gO@727gOA727gOA727g727g727g827f 8w~ 8@ 8EZ8@@@@?@@@?@8g`0A828g GA828gA828g@828g828g828gA828g A828g A828g@828g828g928f 9x~ 9@ 9EZ9@@ @??@@U@9g@ A929gU!A929g929g929g929g929gU@929gU@929g@ A929gUA929g929g:29f :y~ :@ :EZ:@@@@@@@:gA:2:gzA:2:gA:2:g:2:g:2:g:2:g:2:gA:2:gA:2:g:2:g:2:g;2:f ;z~ ;@ ;EZ;@@ @@?@?[@;g@A;2;g[ A;2;g@A;2;g[@;2;g;2;g;2;g;2;g;2;g[A;2;g[@;2;g;2;g<2;f <{~ <@@ <EZ<@@&@@??@@<g A<<<E< LL<g%A<<<gA<<<g@<<<g<<<g<<<g@<<<E< LL<g<<<g@<<<g<<<g<<<g=<<f =|~ =F@ =EZ=?@@"@@?@@=g@A=<=gM!A=<=g@A=<=g=<=g=<=g=<=g=<=g=<=g@=<=g@A=<=g=<=g><=f >}~ >L@ >>E@?$.??>><>ǽ"><>+><>><>><>><>><>><>g A><>><>><>?<>f ?~~ ?R@ ?EZ?K@@ @???@?g?<?g@A?<?gA?<?g@?<?g?<?g?<?g?<?g@?<?g@?<?g?<?g?<?g@<?fDCl888@ABCDEFGHIJKLMN O,0 @~ @X@ @EZ@Q@$@@@@@@g@<@g e!A@<@g eA@<@g@<@g@<@g@<@g@<@g@<@gA@<@g@@<@g@<@gA<@f A~ A^@ AEZAW@@ @@?@@AgA<Ag@$AA<AgAA<Ag@$AA<AgA<AgA<AgA<AgA<Ag@A<Ag@A<AgA<AgB<Af B~ Bd@ BEZB]@@@??@BgB<BghAB<BghAB<Bg@B<BgB<BgB<BgB<BgB<BgB<Bg@B<BgB<BgC<Bf C~ Cj@ CEZCc@@.@@@@CgC<Cg@AC<CgX'AC<Cg@C<CgC<CgC<CgC<CgC<CgC<Cg@C<CgC<CgD<Cf D~ Dp@ DEZDi@@@@@DgD<DgD<Dg`AD<DgAD<DgD<DgD<DgD<DgD<DgD<Dg@ AD<DgD<DgE<Df E~ Ev@ EEZEo@$@@@EgE<EgE<EgAE<EgAE<EgE<EgE<EgE<EgE<EgE<EgE<EgE<EgF<Ef F~ F|@ FEZFu@? @@@FgFFFM0 LLFgFFFg@FFFgAFFFgFFFgFFFgFFFM0 LLFgFFFgFFFgzAFFFgFFFgGFFf G~ G@ GEZG{@@@@GgGFGgGFGg@GFGg~@GFGgGFGgGFGgGFGgGFGgGFGgGFGgGFGgHFGf H~ H@ HEZH@?@@HgHFHgHFHg@HFHg@HFHgHFHgHFHgHFHgHFHgHFHgHFHgHFHgIFHf I~ I@ IEZI@@? @IgIFIgIFIgIFIg@IFIgIFIgIFIgIFIgIFIgIFIg @IFIgIFIgJFIf J~ J@ JEZJ@@JgJFJgJFJgJFJgJFJgJFJgJFJgJFJgJFJgJFJgJFJgJFJgKFJf K~ K@ KEZK@?@KgKFKg@KFKgKFKgKFKgKFKgKFKgKFKgKFKgKFKgKFKgKFKgLFKf L~ L@@ LEZL@?@LgLFLg@LFLgLFLgLFLgLFLgLFLgLFLgLFLgLFLgLFLgLFLgMFLf M~ ML@ MEZM?@F@MgMFMgMFMgMFMgMFMgMFMgMFMgMFMgMFMgMFMgMFMgMFMgNFMf N N NTNL@NgNNNN LLNgNNNgNNNgNNNgNNNgNNNgNNNN LLNgNNNgNNNgNNNgNNNgON O O O#OT@U@O %N9OU_@OOOO -9OU\@OOOUE@OOOUO OO VO OO TR@O OO UK@O OO UJ@O OO U;@OOOUOOOVO O#Ohr\A %NOh(aAOOOO -Ohc [AOOOh@AOOOhOOOhOOOhI]AOOhSAOOOhKNAOOhH^8AOOOhOOOhOO$T#,8(  * # " " "$ LO O eO (O  O O O O  O  O  O O U"O :O @ (   ~  <~CC@N_],@~` 䴛P~9  $<Validate Section 4<j>@A /7 Sheet4ggD ɀ  L   dMbP?_*+%&ffffff?'ffffff?(?)?MXerox WorkCentre 7345 PCL6S od,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationPORTRAITCollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "dXX333333?333333?&<3cU} }  } $ wh@g@h@h@ h@h@h@h@ h@  ; v@ @      @w Aj@ ~ @A ~  A ~ |A       x&&$&&&&P(  ~  <~CC@`\],@~ QP~9  $<Validate Section 5<j>@  47 Sheet5ggD ɀ -I,f  dMbP?_*+%&A&?'?(?)?MXerox WorkCentre 7345 PCL6S oP,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationLANDSCAPE_CC90CollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "P,,??&cU} mW}  W} $W}  W} $W}  W} $W}  W} $W} W} $W} W} $W} I W} c} mW}  W} I W} $ W}  W} $ W} W} $ W-0 ,0 @      ,0@ ,0  Z d    ! "  #   $  d e%  &  '  &  '  &  '  &  '  &  '  &  '   * [ \ ] ] ]! ] ]# ^$ ,, DZZ>W@U@ (ZZDZZ, DZZ>W_@  (ZZDZZ, DZZ>W\@ % (ZZDZZ, DZZ>WE@ (ZZDZZ,   DZZ> W (ZZDZZ,  DZZ> W (ZZDZZ9 ! &#DDDDD D %bv@ ZZ _,*jjjjjk -( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(   D DD >   (ZZDZZ(  D DD >   (ZZDZZ bb i-, DZZ, DZZ, DZZ, (DZZ, D ZZ,  D ZZ (  D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  D DD >   (ZZDZZ(  D DD >   (ZZDZZ bb i, DZZ, DZZ, DZZ, DZZ, D ZZ, D ZZ (  D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  ! D DD >  (ZZDZZ(  ! D DD >   (ZZDZZ bb , !DZZ,  DZZ, DZZ, DZZ, ! D ZZ, " D ZZ ( "D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( "D DD> (ZZDZZ(  " D DD >  (ZZDZZ(   D DD >  " (ZZDZZ bb i, "DZZ, DZZ, DZZ, # DZZ, %D ZZ, D ZZ (   D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ bb i,  $D ZZ,  D ZZ,  D ZZ,   D ZZ,   D ZZ,  D ZZ 0 $h!A /$?ZZ% @U@ ZZ0 !r$A /$?ZZ% _@ ZZ0 C v~ A /$?ZZ% \@ ZZ0 JA /$?ZZ% E@ ZZ0  /$?ZZ%  ZZ0  /$?ZZ%  ZZ9 !Z$B>A  #D D D D D D  "v@( - )#LLLLL L  f, /$? D ZZ, /$? D ZZ, /$? D ZZ, /$? D ZZ,  D ZZ,  D ZZ (  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ(  % D D D >  (ZZD ZZ(  D D D >  (ZZD ZZ bb i,  D ZZ,  D ZZ,  D ZZ,  D ZZ,  $D ZZ,   D ZZ ,  D ZZ> @U@ (ZZD ZZ,  D ZZ> _@ (ZZD ZZ,  D ZZ> \@ ((ZZD ZZ,  &D ZZ> E@ (ZZD ZZ,  & D ZZ>   (ZZD ZZ,  D ZZ>  (ZZD ZZ9 ! "#D D D D D D % bv@ ZZ f* jjjjjk ,  D ZZ> @U@ (ZZD ZZ,  D ZZ> _@ (ZZD ZZ,  D ZZ> \@ (ZZD ZZ,  D ZZ> E@ (ZZD ZZ,   D ZZ>  #(ZZD ZZ,  D ZZ>   (ZZD ZZ9 ! #D D D D D D % bv@ ZZ f* jjjjjk ( (D DD> (ZZDZZ( D DD>  (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  ( D DD >  (ZZDZZ(  D DD >   (ZZDZZ bb i, ) DZZ, (DZZ, DZZ, DZZ, ( D ZZ, " D ZZ (  -#X@U@ ( %B(&#X_@  %B(#X\@  %B(#XE@ & %B (# X % B (# X  % B9 ! #DDDDD D "v@(  g, %DZZ,  DZZ, "DZZ, DZZ, D ZZ,   D ZZ $&'h ] ] ]! ] ]# ^$ ,, DZZ>WR@ (ZZDZZ, DZZ>WK@ (ZZDZZ,  DZZ>WJ@ (ZZDZZ,  DZZ>W;@  (ZZDZZ,   DZZ> W (ZZDZZ,  DZZ> W (ZZDZZ9 !  #DDDDD D %bj@  ZZ _,*jjjjjk -( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(   D DD >   (ZZDZZ(  D DD >   (ZZDZZ bb i-, DZZ, DZZ, DZZ, DZZ,  D ZZ,  D ZZ ( D DD> (ZZDZZ( D DD>  (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  D DD >   (ZZDZZ(  D DD >  (ZZDZZ  bb i, DZZ, DZZ, DZZ, DZZ, D ZZ, D ZZ ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( !D DD> (ZZDZZ(  D DD >   (ZZDZZ(  D DD >   (ZZDZZ bb ,  DZZ, DZZ, $DZZ, !DZZ,  D ZZ,  D ZZ ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  D DD >  (ZZDZZ(  D DD >   (ZZDZZ bb i, $DZZ, "DZZ, "DZZ, 'DZZ, D ZZ, D ZZ ( 'D DD> (ZZDZZ( #D DD> (ZZDZZ( D DD> (ZZDZZ( D DD> (ZZDZZ(  D DD >  # (ZZDZZ(  # D DD >   (ZZDZZ bb i, DZZ, DZZ, DZZ, #DZZ, $D ZZ, 'D ZZ 0"A!A /$?ZZ%R@ ZZ0uGA /$?ZZ%K@ ZZ0Zd{}A /$?ZZ%J@ ZZ0V-:@ /$?ZZ%;@  ZZ0  /$?ZZ%   ZZ0  /$?ZZ%  ZZ9 !B5A '#DDDDD D "j@(!  f,/$?  DZZ,/$?  DZZ,/$?  DZZ,/$? DZZ, D ZZ,  D ZZ (  D DD> (ZZDZZ( D DD> (ZZDZZ( %D DD> (ZZDZZ(  D DD> (ZZDZZ(  $D DD >   (ZZDZZ(  D DD >   (ZZDZZ bb i, %DZZ, DZZ, #DZZ, DZZ, %D ZZ, D ZZ ,% DZZ>R@ (ZZDZZ, &DZZ>K@ (ZZDZZ, &DZZ>J@  (ZZDZZ, DZZ>;@ (ZZDZZ,  DZZ>   (ZZDZZ,  DZZ>   (ZZDZZ9 ! #DDDDD D %bj@ ZZ f*jjjjjk ,% DZZ>R@ (ZZDZZ, 'DZZ>K@  (ZZDZZ, 'DZZ>J@ (ZZDZZ, 'DZZ>;@ (ZZDZZ,  ' DZZ>   (ZZDZZ,  ' DZZ>   (ZZDZZ9 ! & #DDDDD D %bj@ ZZ f*jjjjjk (Y D DD> (ZZDZZ(Z D DD> (ZZDZZ([ D DD> (ZZDZZ([ D DD> (ZZDZZ( Z D DD >   (ZZDZZ( % D DD >   (ZZDZZ bb i, DZZ, (DZZ,  DZZ, DZZ, D ZZ, D ZZ (   -#R@  %B(#XK@  %B(#XJ@ % %B(#;@ % %B ( #   % B (#   % B9 ! ##DDDDD D "j@(!  g,# DZZ,# DZZ,#  DZZ,# ) DZZ,# !D ZZ,$ D ZZ $`Xh ] ] ]! ] ]# ^$ ,* DDZ( %c@ Z Z * DDZ( %`f@ &Z!Z!* DDZ( %d@ Z"Z"* DDZ( %@Q@ ' Z#Z#*   D D Z( %  ' Z$Z$*  ) D D Z( %  & Z%Z% !( -) #LLLLL L "@((  _,, DZ Z ,  DZ!Z!, )DZ"Z",  DZ#Z#,  D Z$Z$, )D Z%Z% -(# LL(  ((# ((% ((  (% (  ( (! ! (% "(!  i-, )DZ Z ,  DZ!Z!, DZ"Z", )DZ#Z#, D Z$Z$, D Z%Z%Del2\\\W\\\W !@"#$%&'() *Ja+a,a  ("   LL (   (   (&   (   (   (   (#   (   (    (   (   ! (  "()  i,  D Z Z ,  (D Z!Z!,  D Z"Z",  D Z#Z#,  D Z$Z$,   D Z%Z% !!(!!! LL!( !! (!!!( !! (!!!(!!! (( !!()!!  (!!! ($!!  (!!! () !! ! (! !"("  !,! D!Z Z ,! D!Z!Z!,! 'D!Z"Z",! ) D!Z#Z#,! D! Z$Z$,! D! Z%Z% ""(""" LL"(%"" ("""("" ((""("" ("""(""  (""" ( ""  (""" ("" ! ( ""()  "i," D"Z Z ," !D"Z!Z!," " D"Z"Z"," D"Z#Z#," D" Z$Z$," D" Z%Z% ##(### LL#( ## (###(## (###(## (###(##  (### (##  (### ( ## ! (  #"()  #i,# ! D#Z Z ,# D#Z!Z!,# D#Z"Z",# %D#Z#Z#,# D# Z$Z$,# D# Z%Z% $0$s0A /$?Z Z %$c@ $Z Z 0$xµς.A /$?Z!Z!%$`f@ $Z!Z!0$(A $/$?Z"Z"%$d@ Z"Z"0$`;/psA /$?Z#Z#%$@Q@ $ Z#Z#0$  $/$?Z$Z$%$   Z$Z$0$  $/$?Z%Z%%$  'Z%Z%$ !$LŶGA( $"@(  $f,$0$? D$Z Z ,$/$? $ D$Z!Z!,$/$? $D$Z"Z",$/$? D$Z#Z#,$  D$ Z$Z$,$ $ D$ Z%Z% %%(%%% LL%( %% (%%%( %% (%%%( %% (%%%(%%  ( %% (%%  (%%% ((%% ! () %"(  %i,% % D%Z Z ,% D%Z!Z!,% D%Z"Z",% D%Z#Z#,% D% Z$Z$,% D% Z%Z% &*& D DZ( %&c@ $ Z Z *& &D DZ( %&`f@ Z!Z!*&  D DZ( %&d@ $Z"Z"*& &D DZ( %&@Q@ &Z#Z#*&   D D Z( %&  'Z$Z$*&  &D D Z( %&  $ Z%Z%& !(  &"@(   &f,& D&Z Z ,& D&Z!Z!,& D&Z"Z",& D&Z#Z#,& &D& Z$Z$,& & D& Z%Z% '*' D DZ( %'c@ &Z Z *' D DZ( %'`f@ Z!Z!*' 'D DZ( %'d@ $Z"Z"*'  D DZ( %'@Q@  Z#Z#*'  'D D Z( %'  & Z$Z$*'  'D D Z( %'  'Z%Z%' !(# '"@(  'f,' ( D'Z Z ,' ' D'Z!Z!,' D'Z"Z",' &D'Z#Z#,' D' Z$Z$,' D' Z%Z% ((((((  LL!(  DD((((!( ( DD((((!(  DD((((!(  DD( (((!(  D D ( (((!(   D D ( !(!  ("(   (i,( "D(Z Z ,( D(Z!Z!,(  D(Z"Z",( % D(Z#Z#,( # D( Z$Z$,( D( Z%Z% ))( )))  -#)c@ " %(B)())#)`f@ # %(B)())#)d@  %(B)())#)@Q@  %(B) ())#)   %( B) ()#)   %( B) !() )"@(#   )g,) )D)Z Z ,) D)Z!Z!,) D)Z"Z",) 'D)Z#Z#,) D) Z$Z$,)  D) Z%Z% *.* *e ++ +e ,, ,e!+9:: ,& "      "       &  e%   (     *  ( &     U" :&     "  $        " # * " &    *        ! *! ! " " &# *# # )$ $$ $  $ !$ ($ ($ '$ $  & && &  &  &  *& ! J& r& r%' r*' 5#' $'  ire ' rue' lOp*(  DOW( TRU') ! Edg>@7 Sheet6ggD ɀ #l  dMbP?_*+%&A&?'?(?)?MXerox WorkCentre 7345 PCL6S od,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationLANDSCAPE_CC90CollateONDuplexNONEResolutionRes300x300      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRTUVWXYZ[\]^_`abdehsjklmnopqrgtuvwxyz{|}PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "d,,??&cU} I Y} mY} mY} Y} $ Y#0@0WW       W W   WW  W    02 3 4  1    %8@U@ ZZe>r\A OZZ /ZZDZZB>r\A( LL~ : %9_@ ZZe@r%aA OZZ /ZZDZZB@r%aA(~ ; %8\@ ZZe@rZA OZZ /ZZDZZB@rZA(~ : %9E@ ZZe@A OZZ /ZZDZZB@A(~ ; %8 ZZe  OZZ /ZZDZZB( ~ : % 9 ZZe   OZZ /ZZD ZZB (~ ; # 6v@  % e AxA OZZ /ZZD ZZB#   % ( i D D D     02 3  4  1    %8R@ ZZeB]A OZZ /ZZDZZBB]A(LL~ : %9K@ ZZe-SA OZZ /ZZDZZB-SA(~ ; %8J@ ZZe&7NA OZZ /ZZDZZB&7NA(~ : %9;@ ZZe_8A OZZ /ZZDZZB_8A(~ ; %8 ZZe  OZZ /ZZDZZB(~ : %9 ZZe  OZZ /ZZDZZB( ~ ; #6j@  %@e^qA OZZ /ZZDZZB#  %@(i DDD   02 3 4  1    2c@( LL*L(w1jA DDZ( *L(w1jA DDZ( 3(LLL 4`f@(*ahA DDZ( *ahA DDZ( 5( 2d@(*|.cA DDZ( *|.cA DDZ( 3(  4@Q@(*\EpJA DDZ( *\EpJA DDZ( 5( 2(* DDZ( * DDZ( 3( 4(* D DZ( * D DZ( 5( #6@  %@#  % #  % 7(-((((D1l BF BF BF ;W!hW " .)))*!/+++, d( +  )   Z)   (  %        & ! U"! :>@d    7 Sheet7ggD ɀ  U  dMbP?_*+%&A&?'?(?)?MXerox WorkCentre 7345 PCL6S od,,Letter (8.5 x 11")DINU"hDc[-:hSMTJXXerox WorkCentre 7345 PCL6RESDLLUniresDLLXrxTrueTypeFontDlOptionTTF_DOWNLOAD_AS_TRUETYPEXrxEdgeToEdgeEDGE_TO_EDGE_OFFColorModeMonoXrxHalftoneXRX_NORMAL_HTXEROX_JOB_SETUP_BEGINCBXEROX_JOB_SETUP_ENDCBXEROX_DOC_BEGINCBXEROX_DOC_SETUP_ENDCBXEROX_PAGE_SETUP_BEGINCBXEROX_PAGE_SETUP_ENDCBXEROX_PAGE_FINISH_BEGINCBXEROX_PAGE_FINISH_ENDCBXEROX_DOC_FINISH_BEGINCBXEROX_DOC_FINISH_ENDCBXEROX_JOB_FINISH_BEGINCBXEROX_JOB_FINISH_ENDCBOrientationPORTRAITCollateONDuplexNONEResolutionRes300x300PaperSizeLETTERD1NRX ciz MSCF],90R'//Uncompressed-Data//Y'CKZklE>m-YHiP Bi﫷>`Dž<,m/Zh11>~#?gAT!*FH!R1BAF޻!Vݻ|;39gΞ9eՁә$ʪrUaDS_OŵNgrPMN!M:$=_]3蹓PD`}PYH\¸H=[╌t6ҨN'q&)GnAWǣzQ⧹e9Q$8d_.pƳ!ۓ')qi6];}\#9Go4m.fr}_lK:2S&gdDTG$ki Ւ~V},y?eP_9aɖ Jz4Em&-ZcKq/q6c&T]i)=傇]&5:T3*7|jݳ6<&߱9bԢ̲ll3A ֛ wi!(qέiKR:q5~__;wg P&Yn^k ->$ hk?8Z |ꈧ{oiA&ڀD8R.Q[فA%"7yH$%J&ݡץzВjݰrݰ0m۬ڞ<,6e哏 1+9i ͠x)]>QqgE0Y3^Ȫ^ȫEXIb8s(:q=xw5PFa0m)g9m1^6I^*XW(dn,͢}tYGWiڳptnD. ¦: 2%CgoPewn2m$!"ډr n Hk2Pq+^._'~N#3l=|A"$mD^I4zX`SB*Zˇ]$C'Vi x1r)^ r&^ͳxy'pm͔20þ|i^!8 CyP\X8NGh"#s)7_ЇɫE/eW,U,R(Gnm,yⱉ14tWyY@Q\@#alcޘ ~}o3rۏ1V^Ha.巤+lZXxCN J_l'ZQSHĨ^>d"6 >f+. }3Bf(6r8”n.jA5C9>UHvK*T *5ٗ-ޣ^97UxZi!s,:NU+LؼQUpT : ^c yIb \<֦1"9|NJT>P9C9F|ٜ1bs|Έ|{o6sFGs JH>g,J7b\7E{cgD Q/#F'/]P"OPBQ C'(aQ C'(2r,O OH^^'P"BB-.,@̛b]>`ׄ= P&&ʛP&(qtlyEkߣ6DBt z>a^3KGL-f8h|\ވho>7UiTnl}οI'Ɩ;ί[-#q>ߥՋAlEi $ ybqoHdq&Ij}΁Mvs}!f̾g5vBα9PIFߘKI?s17Ɨr/$[ )i#t?(LM.,M>K,F[3zb'gqp75Ͽ'COM5excel.exeFrancis  o "d,,??&cU} W} W} W} $ W} I W} W} W} I W} W} W} I W} W} $ W} W} $ W;n! n!             o      p r  p  qr k9 l l l l m l l l  l  l  m     %<@U@ ZZ]bF~ G; ;  D  OKERRORBOKCbn۶m@ -Z ZZBCb5rO3@ -Z ZZB%>>r\A ZZDbF~ .ZD  OKCHECKBOK<R@ Zj:XA Zc bF~  MZ  CHECK0Z  OKCHECK"BOKD bF~ .ZO@D  OKERRORBOK >r\A ZO@! ? ~@  D D= @ҁm? 'D D DB_@ F~ ID  4D dA  OKCHECK"BOK %<_@  ZZ]b(F~ G; ;  D  OKERRORBOKCb|@ -Z ZZBCb۶mۺ@ -Z ZZB%@r%aA ZZDb0F~ .ZD  OKCHECKBOK<\@ Z jR_A Z c b8F~  MZ   CHECK0Z   OKCHECK"BOKD b@F~ .ZO@D  OKERRORBOK >(aA  ZO@ ?@(    LL @*4aG?( 1 'L LLB@HF~( SIL 4LdA  OKCHECK"BOK %<\@ ZZ]bPF~ G; ;  D  OKERRORBOKCb,4" @ -Z ZZBCbf@ -Z ZZB%>@rZA ZZDbXF~  .ZD  OKCHECKBOK<Z@ Z jYA  Z c b`F~ MZ   CHECK0Z   OKCHECK"BOKD bhF~ .ZO@D  OKERRORBOK >c [A  ZO@ ?@(   @MR j?( @pF~( OK %<E@ ZZ]bxF~ G; ;  D  OKERRORBOKCbZZZZږ@ -Z ZZBCbp= 7@ -Z ZZB%>@A ZZDbF~ .ZD  OKCHECKBOK<B@ Z j>A  Z c bF~ MZ   CHECK0Z   OKCHECK"BOKD bF~ .ZO@D  OKERRORBOK >@A  ZO@ ?@(   @/9tu?( @F~(OK %< ZZ]bF~ G; ;  D  OKERRORBOKCb  -Z ZZBCb  -Z ZZB%>  ZZDbF~ .Z D  OKCHECKBOK< Z j Z c bF~  MZ   CHECK0Z   OKCHECK"BOKD bF~ .ZO@D  OKERRORBOK >  ZO@ ?(   @!( @!( %< ZZ]bF~ G; ;  D  OKERRORBOKCb! -Z ZZBCb ! -Z ZZB%>  ZZDbF~ .Z D  OKCHECKBOK< Z j Z c bF~ MZ   CHECK0Z   OKCHECK"BOKD bF~  .ZO @D  OKERRORBOK >  ZO@ ?(   @!( @!( % <v@ ZZ] bF~ G; ;  D   OKERRORBOKC b*) @ -Z ZZBC b:P@ -Z ZZB% >AxA ZZ b <t@ Z j/ivA Zc bF~  MZ  CHECK0Z  OKCHECK"BOK # >BxA % @ ?@(   @%ثrZ?(   @F~( OK :" <bbb>c<===>?@@ % <R@ ZZ] bF~ G; ;  D   OKERRORBOKC bI$I@ -Z ZZBC b98^@ -Z ZZB% >B]A ZZD bG~ .ZD   OKCHECKBOK <P@ Z jZA Zc bX MZ  CHECK0Z  OKCHECK"BCHECKD bG~  .ZO @D   OKERRORBOK >I]A ZO@ ?й@(     LL @h4:L?(   @G~( OK % <K@ ZZ] bG~  G; ;  D   OKERRORBOKC b%I$@ -Z ZZBC b^@ -Z ZZB% >-SA ZZD b G~ .ZD   OKCHECKBOK <L@ Z jmSA Zc b(G~ MZ  CHECK0Z  OKCHECK"BOKD b0G~  .ZO @D   OKERRORBOK >SA  ZO@ ?^@(   @Gwc?(   @8G~( OK % <J@ ZZ] b@G~ G; ;  D   OKERRORBOKC b @ -Z ZZBC b'l@ -Z ZZB% >&7NA ZZD bHG~  .ZD   OKCHECKBOK <I@ Z j̫MA Zc bPG~  MZ  CHECK0Z  OKCHECK"BOKD bXG~ .ZO @D   OKERRORBOK >KNA  ZO@ ?@(   @Se?(   @`G~( OK %<;@  ZZ]bhG~ G; ;  D  OKERRORBOKCb<@ -Z ZZBCbf@ -Z ZZB%>_8A ZZDbpG~ .ZD  OKCHECKBOK<7@ Zj0/5A Zc bxG~  MZ  CHECK0Z  OKCHECK"BOKD bG~ .ZO @D  OKERRORBOK >H^8A  ZO@ ?t(   @Tc**(  @G~( OK %< ZZ]bG~ G; ;  D  OKERRORBOKCb! -Z ZZBCb! -Z ZZB%>  ZZDbG~ .Z D  OKCHECKBOK< Zj Zc bG~  MZ  CHECK0Z  OKCHECK"BOKD bG~ .ZO@D  OKERRORBOK >  ZO@ ?(   @ !( @$!( %< ZZ]bG~ G; ;  D  OKERRORBOKCb(! -Z ZZBCb,! -Z ZZB%>  ZZDbG~ .Z D  OKCHECKBOK< Zj  Zc bG~ MZ  CHECK0Z  OKCHECK"BOKD bG~ .ZO@D  OKERRORBOK >  ZO@ ?(   @0!( @4!( %<j@ ZZ]bG~ G; ;  D  OKERRORBOKCbx!!@ -Z ZZBCb 5@ -Z ZZB%>^qA ZZb<h@ Zj3pA Zc bG~ MZ  CHECK0Z  OKCHECK"BOK # >eqA  %  с ?+@(   @8TY?( @G~( OK "<bbb>c<===>?@@ %<c@ Z Z ]bG~ G;  ;   D  OKERRORBOKCbJj`^@ -Z  Z Z BCb Sשj@ -Z  Z Z B%>L(w1jA Z Z DbG~  .Z*D  OKCHECKBOK<a@ ZjE{QgA  Zc bG~ MZ  CHECK0Z  OKCHECK"BOKO bH~ 9:O@:O @BD  OKERRORBOK* >]n.:W4jA D Z( D  ?袋@(    LL @ahA  Z!Z!DbH~  .Z*D  OKCHECKBOK<`e@ Zj5ItQmhA Zc b H~ MZ  CHECK0Z  OKCHECK"BOKO b(H~ 9:O@:O @BD  OKERRORBOK* >fEKhA  D Z( D  ?E]@(   @;4 OT?( @0H~( OK %<d@  Z"Z"]b8H~  G;"" ;""  D  OKERRORBOKCbh @ -Z" Z"Z"BCb|.cA Z"Z"Db@H~  .Z*D  OKCHECKBOK<c@ ZjebA Zc bHH~  MZ  CHECK0Z  OKCHECK"BOKO bPH~ 9:O@:O @BD  OKERRORBOK* >cA  D Z( D  ?袋i@(   @q$xh?( @XH~(OK %<@Q@ Z#Z#]b`H~ G;## ;##  D  OKERRORBOKCb^p@ -Z# Z#Z#BCb6_;V@ -Z# Z#Z#B%>\EpJA Z#Z#DbhH~  .Z*D  OKCHECKBOK<N@ Zj HA Zc bpH~  MZ  CHECK0Z  OKCHECK"BOKO bxH~ 9:O@:O @BD  OKERRORBOK* >.JA  D Z( D  ?.%@(   @Ez]j?( @H~(OK %< Z$Z$]bH~ G;$$ ;$$  D  OKERRORBOKCb8! -Z$ Z$Z$BCb  Z$Z$DbH~  .Z* D  OKCHECKBOK< Z j  Z c bH~ MZ   CHECK0Z   OKCHECK"BOKO bH~ 9:O@:O@BD  OKERRORBOK* >  D Z( D  ?(   @@!( @D!( %< Z%Z%]bH~ G;%% ;%%  D  OKERRORBOKCbH! -Z% Z%Z%BCbL! -Z% Z%Z%B%>  Z%Z%DbH~ .Z* D  OKCHECKBOK< Z!j  Z!c bH~ MZ!  CHECK0Z!  OKCHECK"BOKO bH~ 9:O @:O@BD  OKERRORBOK* >  D Z( D  ?(   @P!( @T!( %<@ Z&Z&]bH~ G;&& ;&&  D  OKERRORBOKCb&@ -Z& Z&Z&BCbZݍ@ -Z& Z&Z&B%>t4_A Z&Z&<<@  Z"jcѕA Z"c bH~  MZ"  CHECK0Z"  OKCHECK"BOK # >EgA  % L ?t.@(   @P Z?( @H~(OK<oG2=3**4O333**4dKKKBB |       ' "CHE   "O   CH  &  O       O    O  *   O O  U"  :    $      O          O          &         O  ! (   O     O   "   )        & $   &      ! '    J  r  r r 5#  ire" rue% lOp DOW TRU  Edg " DGE( OFF# eM lft$ ORM !OX_ _BE ROX  P_E  OX_& CB C_S$ CB' E_S$ NC AGE  DC  AGE!  EGI( X_P$ H_E OX_$ H_B% ERO  ISH! ERO! ISH XE  INI  Or% PO! lla lex olu 00x Siz   ( PH`0(  >@    7 Sheet8ggD ɀ 4  dMbP?_*+%&ffffff?'ffffff?(?)?M HP Color LaserJet CM1312 MFP S(C odXXLetter+DINU" ZV SMTJ HP Color LaserJet CM1312 MFP Series PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueHPPCompositeUSBGetSerialNumberhppdvq01.dll_getDeviceSerialNumberWHPPInstallTimeConfighppdvq01.dll_getDevicePPMDuplexerWHPPCompositeUSBFilehppdvq01.dll_getDeviceSerialNumber_getDevicePPMDuplexerResolution600dpiFastResFalseOrientationPORTRAITHPOrientRotate180FalsePaperSizeLETTERMediaTypeAUTOCollateOFFHPMediaTypeTreeviewPopupTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineJPEGEnableAutoHPEnableGrafitCompressionTrueHPRequestObjectTagDumpFalseHPRequestNullStripCommandFalseHPHybridRenderSwitchHPHybridAutoAlternateLetterHeadFalseHPPaperSizeALMConstraintsA5PrintQualityGroupPQGroup_1HPDocPropResourceDatahpzhl5k4.cabHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_ColorOptions_HalftoneSmoothHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Photo_NeutralGrays4-ColorHPColorModeCOLOR_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_COLORAUTHHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpc13126.xmlHPEnableObjectTaggingTrueHPReverseScanLinesForDuplexTrueHPEnablePageTimerFalseHPEnableNullStripsTrueHPEnableEfficientMonoFALSEHPEnableImageProcessingPathFALSEHPCallToWritePrinterRequiredTRUEHPMemoryManagerTrueHPGetCompressionRatioValue17MaxStripHeight64HPGetByteAlignedValueForWidth256HPGetDeltaRowHalfToneValue1HPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPCL6PassThroughTrueHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotateHPPrintOnBothSidesManuallyFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPZPE5k4HPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionHPPrintInGrayScaleFalseHPPngPassthroughTruePSAlignmentFileHPZLS5k4HPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHub_OrdersuppliesTRUEHPSmartHubInet_SID_263_BID_514_HID_265HPConsumerCustomPaperTrueHPEnableRAWSpoolingTrueRGBColorDefault-sRGBHPPhotoFixLaserOFFHPRedEyeReductionOffHPSmartFocusOffHPContrastOnHPDigitalFlashOnHPSharpnessOnHPSmoothingOnHPMHDLLNameHPFIE5k4HPPreAnalysisTrue IUPHxkA&PD-.^AQ#66خC1[H%Ń'x?xTzf7MBi}̛73ּNUN$BHH܀jmO> G à)_Ll m#_d!?XjFQ7D )x'wNs bڧi?P I#^h\8( },pg/]f1N.d Lq GO Va-Ֆ#L"Vݳ1ӄ_ףeN )ձe;4lVeI'q-R&S9i̩:noqQE(o+aYcG+y>Lx,d?p!z$R*̫ ӍcaQmm-~?ܓ/zWHWRQ"aлZ3i"+%p)Qe´ ! ؙla]K_L[||ן^}W.|k~p΀AAAA8X< "dXX333333?333333?&<3ҊU;@       """" " " " " """""""""""""""4|2&&&&&&&&&&&&&&&&&&&&&&PHp0(  >@    47 Sheet9ggD This value indicates the number of saves or revisions. The application is responsible for updating this value after each revision. i="http://schemas.microsoft.com/office/2006/metadata/properties/metaAttributes"/>DocumentLibraryFormDocumentLibraryFormDocumentLibraryForm rU 8  ThisWorkbook$'i5__SRP_4' __SRP_5VSheet1.6B*\R1*#109*\R1*#fc*\R0*#1*\R0*#14*\R0*#2*\R1*#fc4 " D( 8p * , , 48 $p $ ( , . *Hx "  V 80H `""""  8  0 H  @X  ZF " 8@ H ` &h  B B 8 H P `  "  0  L lo}E,#<L9L8sVUFqq~L^ő.A xqq~L^ő.A L9L8sVUME< [LSS L>"<N0{00020819-0000-0000-C000-000000000046}X XMacros%% X`(|+ `@ k..i  able <8`xk@i> ablei   @x`8dkO B`xk^ 6p`k piH  Kx0n.Ce % OtP$-- %`Pp---- T` 4k  Kxkhil % F0`h$k  Kx( % "`|+p if &ih $B@%BHXp8x0P8$Fht@x  8P^bd@t @`p x8@lO `@h `@X p@T @D D4@4 @$ 0p$6,@x #8XX p @ $RTHZF@l @ \ @ L @ < @ , @  @ @ P@0 @H @` @x *\@ \R H ` 0 b^d @x t @ d B @` @ P @@ @ <  @8O ( `@4   ` ( @ ` Px "$,02.@ z 0@x N@t (@ d 'y`x `_*%h` j@ \ |@X z @ H -@8 3@ ( @8 #\@ ,@ #ʅ@ KGP S 468:'GN<pH 8"$~@z @x @t @d  0pH@dN$*\Rffff*0E4e901441*\R1*#33a*\R1*#fc*\R1*#109*\R1*#92*\R1*#101H hx 8   " 0"P"`"p"  " * , , 4P $ $ ( , .0  `    . (  "     8 H  h x  :  8> &T H  P ` $h        " 8  3( !@ "0X  ,  " 8  ! "0 0.i@3p "  " * 0 >  :`  x]Macrosڈ0*H=Added for disable cut copy past By Akhilesh Gautam 10/22/2010A6' 1Turn events back on an set saved property to true $(* (,o 8A@" cutA@" copyA@" pasteA@" pastespecial^c $B@&^v $B@&+{DEL} $B@& +{INSERT} $B@& $((oHx$ EnableControl 21, False ' cut% EnableControl 19, False ' copy& EnableControl 22, False ' paste. EnableControl 755, False ' pastespecial Application.OnKey "^c", "" Application.OnKey "^v", """ Application.OnKey "+{DEL}", ""% Application.OnKey "+{INSERT}", ""' Application.CellDragAndDrop = FalseUnhide all worksheets $(DAF(Application.OnKey "^v", "PastonlyValues"!Application.ScreenUpdating = Trueo]8XTurn off screen flashing $(DRecord active worksheet R.NHide all sheetsAT4Save workbook directly or prompt for saveas filename H Excel Files (*.xls), *.xlsX $%V'P PFalseG P B@Hjd B@ZkRestore file to where user wasAF NB@\Restore screen updates $(Do p1Hide all worksheets except the macro welcome page] b $^(` J !^ J! G d J(`j J $^B@\oX1Show all worksheets except the macro welcome page] J !^ J! G b J(`j J %^!`G %^B@Hj d $^(`op0 Dim CB As CommandBar# Dim C As CommandBarControl* For Each CB In Application.CommandBars7 Set C = CB.FindControl(Id:=Id, recursive:=True)4 If Not C Is Nothing Then C.Enabled = Enabled NextoH@Attribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2Option /licit Const WelcomePagY"Macros~ P15 Sub _Activ () 'AddCfor dis8cut copy pa/By Akhilesh Gautam 10/22/2010!-. 'A EnA2trol` 21, C' ! 19 *2 A3j755O specialQDApp@]aA`.OnKey "^c", "@ZBv+{DEL}0  INSERT CellDragAndDropBQaf EndI TBeeCl(Cancel As BooleanOup!as c the sheet K '-ROKh(KAKJ2JJJfJ1FcIuvwI +{eHOG/s/Turn off events to prb unwantloops 3E=aTA$'Evaluif wd is( saa Zemua defaultopmt With A If Not .S" ThengSelect CMsgBox("Do you ]changesmade'" & .bޠ& "'? _+  vbYesNom+ vbEx >mdneIs" 'Calls/rouxtine "C"" No#n`* 3_yS?I 'SDupcedur2caRJGoa= .a1PB1If' 0"wMicke0d, t!/.back {(,C'oPrwiPwQ,w)P,ing fur $g ?* `--+, o7f7'.B`B6:=fb5//EA:i0:i)(ByVal AsUIHj,:kq'oJ$oJyoJn.oJ6ve 6 A!sp+ 'Kp0|erty BtҥB (To D$regpMr!@\:(% * q :d!5pU'4᡿_Dea|)q K|_@|ol |te|c գ|n|{|ǩ|C<:ok_OpenߑOϹo A@Ϲn`xϹϹ޻ϹMϹ> c!S'Unhiy@/.ScreenUpd0&aJ?ShowAl,lS'"^EPonlRue$)$(fXDim w:s As Worksheet, aW newFnameStri ng 'Turn off screen flash '%',%'<%:\ %'L%l! l | `1pl5 lp 0F '%'%'%'%'%'%'%',%'<%'L%lpF\%$  $  t ( l! l l,0tpxl  3P%`:d%t! t d`)t`!t$ Qt[<x84x Hl40/4 x  x8V,`:d%t! t d` )t`H0<8x4t`L!t$ Qt[pxl`hx Hlh0/hS x  xl#8T(X%t$ t dTWD)tT5D1T(X%t$ t dT )tT34%T:X%t! t dT)tTX0plxhtTD8  $0 44444rU @$`(A` #,`$#$`($`,(A` $`$`,`&#nrU t$y`$`,\Rffff*0F4e901441*\R1*#33b*\R1*#10d*\R0*#12*\R0*#f*\R0*#21*\R1*#29c*\R1*#fc*\R0*#1*\R0*#14*\R1*#101*\R0*#10*\R0*#15*\R0*#f*\R0*#f<XDLTX`(h "  " ( .0.H,`5x. ,0   "     8@1H1X h 2 .  6 .H x ( .    C (0 8  X`  .h   '*6  .$7 6+8 'p   ,5    (p0+p $7.+82+@x '   6 ( * @@ P (   0( HP X B ` h p  b<     8  @  H  X p .+x          .4cpoD@;@':I FJ7)JË˻lx,ProgressBar1, 5, 1, MSComctlLib, ProgressBarLabel2, 14, 8, MSForms, Label!TextBox1, 21, 9, MSForms, TextBoxLabel1, 17, 10, MSForms, LabelLabel3, 18, 11, MSForms, LabelLabel4, 19, 12, MSForms, LabelJ7)JË˻loD@;@':IMEX @[LSS8sss>"<\<`   (( P p ,x #  6+    * 6+8px 2     B )  <@ >     ( B 08@)Hhp%x& 3 $D"   ( 0@H PX` x ]A@po`X] R%v't R,v t R,v R%vB@H |$z$x't RB@~ t R,v RB@DeActiveProgressBaroMsgBox ("WChi")]]0 !v!' !v!'PastedRange = Target, If Application.CutCopyMode = xlCopy Then6( Application.EnableEvents = False Application.Undo0 Target.PasteSpecial Paste:=xlPasteValues' Application.EnableEvents = True End If!If (Application.OnKey("^v")) Then(Target.PasteSpecial Paste:=xlPasteValuesEnd If  RB@~  !v!( l]H Get the Target Cell]`]x !: 'dh !v!'kP  #  ) .    !vB@HTu $!!(vent'Maximum of 10 digits allowed in a cell. A@.bo (vand Fkpkh X XSection1 X $'ave 'l    (v 2k      )  $%^%v!$!Please enter a conversion factor. A@.kXdP !vB@Hic $!!(k on] $'   ose th Only numeric values are allowed. A@.d#Please enter only an integer value. A@.hangesk (v$(kh ElseP/ If (Not (vTargetCellRow <= 8)) Thens! ShouldRun = False# Target.Cells.Selectty to : Application.Selection.Interior.Color = 255J MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly! Target.Cells = "" End Ifkk RB@'lko'  Section1           Conversion Fector   )'] $'   ' Only numeric values are allowed. A@.0'd@  $'k dallow integer only $   X  $''Maximum of 10 digits allowed in a cell. A@.k ''kpkh  e      $" Changed By Akhilesh on 26/10/2010 . ] .$'$ ''Maximum of 10 digits allowed in a cell. A@.k0d(  '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.kk+---------------26/10/2010------------------ ''kPdH' 'k0d(8allow decimal and round the value to the nearest integer $" Changed By Akhilesh on 26/10/2010 . ] .$'$ ''Maximum of 10 digits allowed in a cell. A@.kd  '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.kk+---------------26/10/2010------------------ ''k0k(k kd'ki]p .  6MsgBox "Please enter only an integer value.", vbOKOnly '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))d8 'k(  X'  X'd 'ki] . ] ]8 $X ' . ^ .$'/$$X$X 'd$X'kd X'kd 'k  X' 'xiph_Attribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2ControlProgressBar1 , 5, MSComctlLi8b,  #Label24, 8, MSFor0ms, TextBox:29 9@ 170(%3 @*1f+@81*1@;Dim ShouldRun As Boolean4 AP@m@o Sub @XmandButton1_Click() DeActw]` End WorksA_ B oldVal C@z.Cells(@@3@_B# @.Select F Trim(Year(Now)LUnprot i3) @% DrawingObjs:=_, c`]entScenaribo 'R.._Change(By@- TargeZtA>R B 'Msg\ ("WChi"d aEv1ColumELRow `"#C:.-f 'Pasted"If App@Sation.CutCopyModxl The'aEnAEv/@ dRUndoBSpecial :=xl`.uesH#Y!iIf2(OnKey("^v"))a'?% Not (28i c[c! "x.Int $or>or@,vbWhit`A ALis`id#a' GYthe%[!1A ! Vlan@!a!Ret InStr( Adda, ":") > 0 ߧ@L11Er{q 7 Iq > 8 AZl< 35) Or 41&g#6 @.O15aa Len(&!1?8Z\3sB~)255 Q"Maximum of 10 digits allow`in a c0k.", vbOKOnlyw1 0"x%qGoTo L:og]? 4=2 @#idx(CǠ)"Z), XYP"Sk1C1/7, 3cq 1o0C'= TXWQ9<> P?cQI424/4w 41r35H7U8 "3A `s(1)T4`G1ue) <=F)-P`Hse oer+o nvers fact [,hK969o:co:@A[valof!l*H6 I/,3? numٰoc  0B_B' _oF an ivg_5yI5 _1= 8VdQ? >o$p{^$$ r$^^ll; Mt.Cells = "" ' End If ^ H <`PL:$ActiveSheet.Protect DrawingObjs:=True, contentScenarioNShouldRun6w  Sub Priva@te Funon Valid(By vCol As IA ger,  Row Ref vgNameStrof*(u Ret Vlant) BooleanUMpFalse If (+<> "") xTheHSဪion1r= 2 Orx= 456J7910 1$aE'ConvHers% F'orm%11 A@v]@& HDim valofL@VT) $Len( ) < `):'oEMsgBox "Only numeric-ues are allowed.", vbOK K(F@|0@EIH Round@, 11 AMjK g'" ih o (Is@l(/)/- > 10u.:Mir( `@00Maximum of digit0c0` a c1Q%h-H!LE?,Ym /a$= 3p8$j>~< "  3U/IsDecimal: `' Changed@ Akhilesh E 26/10/2010$Gna;1, f*, ".> COPart !`HSplit#  a (0UU@*inU Li ?e=& )O; ';);m<<_Uuo'- ,`/Cu/C A KadB ap~r!1h theo tone pstteA&FexFF4bFFIF1RBFFUs F1F6 ?5?5?5?59/)+u& FyFueFno&FsF 0pval1%roundedH W 0R(\, 2)#CDD.Split( E/Mid((1), y1)t= 5t GJ0Dbl0@ + @ K%A~E 8N\C 8²:Ag __SRP_6L__SRP_7)^kSheet2xQ__SRP_cRD4K) H:X8((]t58?  XhM  XhhhEDX]/8Vpzkz~ hEDXb  h0 K/ d(0h8K) H:X8((]t58R%l 8 ! 8KF688&:X8(H]t58<3:XN88 #/58D(X%8q(l "-E68"(X%8Hk(h587(X%8Hk(h58MHkXh`  XhhhHkX]/8Vpz h0 K/ 0h 8P H \ d @ 8 XX! `Y9  h ` @9` )0/#,y`I/#,`i/# y@P @tH  @\ 9 @d Q @h@ i @\8n8%h$ @h#f*\R0*#15*\R0*#f*\R1*#fc*\R0*#28"..0,H5`x "   C  11(0.8  X` 'hx. $76+ '  (0 ,:8 h  p  x (   $ 7   .+ 02+8 p 'x 0   B     rC   (M[A#@D;mDxx98 F>EL"NLx>EL"NLD;mDxx98MEL @[LSS8>"i iiii 0i  @ ` P %,8`/ hi i  @h ,`0 ox li i  @h @ @ ,`k@ pKKi ` ii$i  X `xMaxi@ owed@ @ @ `8%bl4 @Pp8hd th8XHRCentre7@h SDLL@X peFo@H OAD_@08 oEdg@`( olor@ eXR@x B_SE@ OB_S@ C_BE H8  p` xBXEHNISH_BRl$.SH@ T PORT@D exN@0 4 0x30@$ @H  @ @  @x @` k@ 90@ @ a//@ @ bm@ t ,K@d ;y  h h 8 P h {` z  Kc -1`t2K 1?.R E@ d c|@b @ P Ƌ @ @ @ 0 e@ h@  k@ n@ q@ t x P h AD` z \X : Mpt {\@8 X %@h H  @ 8 0@( 0 @  I! '30%@ 0@ 0@ 0@ X`@ H h tp:/`z ft%2Server8ty(7).$.:00^@0t ww.m@p orp/@`` 0Ser@xP rt0M@@ orpp@0 ecur@ ty(7@8 00(@ }@  0'@  @ *@P m*@h  *@ >@ k@ H@@ < bP@x e^=@h X@7@X tf@(T o@P t@X@ P@H@p0 + @ tb @ *H@ Mic@0 orit@ 1404@ !Mi@ r Au@ @H Q@` .@x @ X@x /@h b@X h@H H@8 d|NK@( C[]@H ,` @ pHγeH%!@ 77# +@ 7+GubC h pki/`z ++://www@X scor@H @08 ia/m@( @ 2h8h8Dt\ dN*\R1*#222$*\Rffff*014ebe49c4*\R1*#33b*\R1*#10d*\R0*#21*\R1*#29c*\R1*#fc*\R0*#1*\R0*#14*\R0*#10*\R0*#f*\R0*06+       rF( >  4 B( Tp  (0,8#P h6+p * 6+08 2@ x    / / 0  /H  /h   /  /   /  / 8 @  H  /`  /   /  /   /  /0 P  /h  /         B    ) <  > `            B    )( H P %X &p  3  $D "       ( 08@ X`h B px 6  % X ` 3  @0 8 HAP p 4# H 0 8 3  B   A( HX ` h p x4#% H P 3  @  ( 8A@ `p x 4# H   ( 3  B  A 8H P X ` hpx ]h]X R%v't R,v t R,v R%vB@Hop]] RB@~t  !v!( lDim isValid As BooleanRB@ Get the Target Cellre !v!' !v!']]  !: 'd !v!'k . tion   !vB@H $!!(atio'Maximum of 10 digits allowed in a cell. A@. (v(Fkk X XSection2 X $'able 'l  If  (v k`dX !vB@H $!!( ]8 $'    Only numeric values are allowed. A@.d#Please enter only an integer value. A@. k (vkpkh` RB@'lo0P'  Section2              allow integer only $   X  $''Maximum of 10 digits allowed in a cell. A@.k ''k            e8allow decimal and round the value to the nearest integer $- If (Len(CellValue) > 10) Then; CellValue = Mid(CStr(CellValue), 1, 10)N MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 . ]P .$'$ ''Maximum of 10 digits allowed in a cell. A@.kPdH  '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.kk+---------------26/10/2010------------------ ''kpkhk` ]h]   $' 9undiffP6:Q16 R%B@ersionP19:Q29 R%B@ 9rankeB6:M16 R%B@ B19:M29 R%B@eric 12undiffeP6:Q16 R%B@@P19:Q29 R%B@  12rankeinteB6:M16 R%B@B19:M29 R%B@'kd 9undiffceP6:Q16 R%B@'P19:Q29 R%B@ 9rankeB6:M16 R%B@B19:M29 R%B@ 12undiffe CP6:Q16 R%B@0/2010P19:Q29 R%B@ 12rankeB6:M16 R%B@B19:M29 R%B@gitskPkH'k8d0'k i]  . 'Maxi 6MsgBox "Please enter only an integer value.", vbOKOnly '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))dX 'kH  X'0  X'w decid 'ki8] .  on 26]] $X ' .  .$'$$Xowed$X 'd$X'kd X'CStr(Ckd 'k  X'llowed 'i'']       $!R%v!d $!R%v!d $!R%v!d $!R%v!d ent] ans = MsgBox("You are trying to enter data in the Reporting by Rank section, data in the Undifferentiated Rank section will be deleted.", vbOKCancel)Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from undifferentiated rank column first, or do not enter data in the columns by rank. $.'  ::MsgBox "Delete from Undifferentiated & keep entered data."'9undiff'd   $!R%vB@H9rank''kpkh      e    $!R%v!d  $!R%v!d] ans1 = MsgBox("You are trying to enter data in the Undifferentiated Rank section, data in the Reporting by Rank section will be deleted.", vbOKCancel)Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from rank columns first, or do not enter data in the undifferentiated column. $.'  :;MsgBox "Delete from Reporting By Rank & keep entered data."'9rank'd   $!R%vB@H9undiff''k z k      e $!R%v!d $!R%v!d $!R%v!d $!R%v!d] ans2 = MsgBox("You are trying to enter data in the Reporting by Rank section, data in the Undifferentiated Rank section will be deleted.", vbOKCancel)Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from undifferentiated rank column first, or do not enter data in the columns by rank. $.'  ::MsgBox "Delete from Undifferentiated & keep entered data."'12undiff'd   $!R%vB@H12rank''kkx      e    $!R%v!d  $!R%v!d]  ans3 = MsgBox("You are trying to enter data in the Undifferentiated Rank section, data in the Reporting by Rank section will be deleted.", vbOKCancel)Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from rank columns first, or do not enter data in the undifferentiated column. $.'  :;MsgBox "Delete from Reporting By Rank & keep entered data."'12rank'd   $!R%vB@H12undiff''kzkkixAttribute VB_Name = "She@et2" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Dim ShouldRun As Boolean P%) Sub Works_Activ () oldVal ]e.Cells(6, 2 "+0.Selec@t EndU  ]Change(By, Tarhget &A'ue'VariancA1ERet>In@Str(1,0.Address, ":") > 0DAEB)*'%aHIfANotn  .7Len(a1JYiApplicationd^c!J255MsgBox "Maximum of 10 digits allowin a c@v.", vbOKOnlyo @CwaGoTo L):+]d= 4idA)(C(Y), `T"S`q$2CL1, eRD6$M= e]<> y,)e{& [ơ? _G"NG{valofA@@@4(]"!a) <> KcQ-VP n$umc uey`VreVUiPK`neqY o. an igerc1+1y1/.I2dPd DrawingOb"j,s:=q{, $co ntScenWoC +~#or@Funwon{6srvaa]qF, d6lRef vr7 %0qaV3@c)Q i@ '7%w07"0Ys  /!@)'a(b= 3 O!= 5791117 (v>< 30)N/'bX()4A IsO/@%q?5sg'1= Mid(NRyee e e4 !=U!.yt A24680s%!116d e PimalGd rou"A!2N to ne9`st! IsDecA(X%'V!va?"FPv5""""" ' dI Akhilesh0] 26/10/2010+#c 6 zq9ParخJSt? u(B>^Cf `o ?oze& oyCellValue = 0 'Mid(CStr(C!), 10) MsgBox "Maximum of 10 digits allowed in a c.", vbOKOnlyEnd If'- 26/10/2010 [Ret}idateTrue  OIf (@) ThenDim @Sec1 As ing ang R8&Not CheckForUnd@efinedk (vRowCotl,+)7x"""= "9undiff"M Active@Sheet.&("P6:Q16").ClearContentsG 19:Q29 Else &ranBk%B6:M%Be%M%12?L?L L12L9>&H{a NAGbNNiUNNN NNtN"P&/N?&?&ed5N(`%'T !Fun`o!Priv  IsInt(ByRefVariantb)aBoo@ On Errorsume Nexvtc !gI&nain , D".> 0'EP se Zer ox ana egv1zoS`(  - 1)? <_ QP(Crv = Gpe!$KGoTo 0 sDe cimaldbߔl# U! 1"1rojedf$qW7bRQ(72z5Split(M?' Qq(1Ԩ>= 5-EC! Dbl(0+ (({ i)7()ߏ0 %Ie%P0A0a +p-J+,=# J08B, ByblNU{N 4Q-i!#ү > 5 A0 0< 17P(vy1 > p4?!׸ !Ap*cation.C {qs(306H).TZ <0W Or /(7()1(OI17~s"{{tan\'b("You are try to tca@c the!jportby" q sep, iergiqd will be deleted%hCan4 +  2: riesq both Qo d columns. ri (r c@Zr co rr` # fromc first, p|do not  P/4(cvb4xPydD & keep entered data." CheckForUndefinedRank = TrueZRetSec<"9undiff ElsjApplication.ActiveSheet.Cells(vRow, vCol).SelecvtvurFaGEnd IfG1^If I `> 5 AO < 17)(T1[8) 0Then+ i2 To 13% ? (17, i).Text <> 0) Or30 $}Dim ans11I# '*MsgBox("You are trying to in the @@ntiats@o@y, @ReportAby will` be d}."bOKCancel) )(@ 2:]+,*ries*bothB+A>d -columns. Please Dei@7r c@racorr43f0rom D first, or do notJT:;vbDCED'l "DP (\B.& _{r ^m +o Exit FuJnoy NscT18 3w4A?$|16a_a JB7v2{a2ZE Ai} lne XH8HqHxHRH?_<`$wA12A@I@_3%iHo c EFFaF0FOI? H}?=B{A433A?`???sA?F0{9 Ap????ea???TDIACAx?m|E?d }9?AQOAOAOADiHDAA@a_XA  /58D(X%8q(l -E68"(X%8Hk(h587(X%8Hk(h58MHkXh`  XhhhHkX]/8Vpz h0 K/ 0h 8$pz 1 k k kk (`%(@%pt!  t @ p A'(]<(%(%!   @ Ax'(]"@ y@ @` @ g5@ ?@ )@x M>K,@p Ͽ H (h H ` h `0 z p H 0 `t .@ d B@b @ P 4@P @ @8 0 5@ @h  @ `@ jX X p h  `@ z  X @ N"@ X t D@ H Dim @ 8 w = @( Val @ Mont0 X 0 x h lida` z se Appl rkshee@ X @H H high@` 8 be @( A@  s(4)w, vCol).Ier@ @ kshe@ ngOb@ s:=T( hDp\ 8dN*\R1*#222$*\Rffff*024ebe49c5*\R1*#330   B     &0 X p 06+      4# >H  4 B T p (,# 6+P X`* p6+ 2  (  0  8  @ H P X ` h p B x   ) <  > 0  8 @ H `  h x     B    )   % &  3  $D8 "`  x                ]]X  R%v't  R,v t  R,v  R%vB@Hop]] RB@~  !v!( l] Get the Target Cel    (E% !"#$&')*+,-F/12345@789:;<=>?.ABCDPGHIJKLMNOQbRUTVWXaZ[\]^_`Sdfghijklmnopqrstuvwxyz{|}cl !v!' !v!'] ]8 !: 'd !v!'k& If (Len(CellValue) < 11) Then  . !v   !vB@Hio $!!(se'Maximum of 10 digits allowed in a cell. A@. (vFkk X XSection3 X $' 'l    (vkHd@ !vB@H $!!(]P $'    Only numeric values are allowed. A@.d#Please enter only an integer value. A@. kp (vkX Else Target.Cells.Select6 Application.Selection.Interior.Color = 255܋OF MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly Target.Cells = "" End Ifk@8 RB@'loh'  Section3     allow integer only $   X  $''Maximum of 10 digits allowed in a cell. A@.k ''d'k      e 8allow decimal and round the value to the nearest integer $- If (Len(CellValue) > 10) Then; CellValue = Mid(CStr(CellValue), 1, 10)N MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 . ]h .$'$ ts''Maximum of 10 digits allowed in a cell. A@.--kd  '&Mid(CStr(CellValue), 1, 10)`'Maximum of 10 digits allowed in a cell. A@.k k+---------------26/10/2010------------------9 R ''d'kkkd'kix] .  R% 6MsgBox "Please enter only an integer value.", vbOKOnlynk '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))B@d 'k  X'ce  X'B@d 'kphi`P] . ]] $X ' .  R% .$'P19:$$Xnk$X '%d$X'khd` X'PkHd@ 'k0  X' 'i Attribute VB_Name = "She@et3" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Dim ShouldRun As Boolean P%) Sub Works_Activ () oldVal ]e.Cells(9, 2 "+0.Select EndU\Change(By+ Target;RA@' 3vA.ColumBRow  %Unprot"@.IntfHor.or@5v`bWhit@y If (a) ThNeA%is@-idg' G2theE5.C'4&9 9M F> '&A'ue'VapriancAER et>InStr(1,0.Address, ":") > 0DAE)*'%HI0f 'Len(&) < 11ANot f;f.a > ~1E%`Application$e!Q255!MsgBox "Maximum of  digits allowin a c}.", vbOKOnly `KA eGoTo L 2:4qɅf= =ida2(C(b), g @]"S z`&3@CT;E[%:qEg= fg<> , +(gi ƭMMvalof!/FE 9qoa&!v6;+<W .+ num0[c ue.re/o. O-Pv`eAa oA2 an igernJ95E2N N0\EDDllo_7[@xDzPz DrawingODbj>s:=,H contScenmo'Y 8< 259>'f128?AIs\ )q;@@u1= Mid(^_.r rr9, =w`(!?I/yBA()= 3 OIS4#oowo PimalNd rouqV to ne`st5:IsDecAx`EZBa1F@? ? ?    dB Akh ileshd 26/10/2010!c ն6 zaz6ParCSPt? u(0pElse/If ( Len(C}Va@lue) >) Then2. = 0 'Mi@d(CStr#, 10)!M  '- 26/10/2010  RetBEO=idate@ TruKdhy"" 4  G Fun0ctio{7Priv) E IsInt(ByRef@:As Variant) @Boolea@On Error Resume Next-Dim c@#CIninC, "."U0Ο'EPse enter "o an%egvA^ G!($- 1)iC+Db'($CA)a ,-=  y k1GoTo 0C==Decimal$>6u?>@- w7>E91a)!roundedHWg-R(g 2-*Og7! Split(G "6(1))@[= 5n[aC7ADbl(0 + H +P!aqR!ig(?IDE.#IsJa!3` W!IiYyA9%% Y) $y$&$i%890` ` IW.(X %(8%h$ @hlh.(X %(8%:%h$ @hh,(X %(8%lh$ @hh5(X %(8%h$ @hh5(0lhp l xT$ @TTC$%xaDTTa4,c)T6D4 41xaDTTa4"i$hT6D41xaDTTa4"i$XT6D4.xaD`# /5D :$:'xaDTTa4T5D.:$ D(]p45D2D($ ]t0$xaDTTT5D7($% T!  T WD C)T5D+'''4:$NDD 6D4':$%xaDTT,T5D5K#CXEhEdkp2k 4 @( @xaDTT,T5D$xaDTTT5D7($% T!  T WD C)T5D k$/D4gn+'''4:$NDD 6D4+'''4:$NDD 6D4':$%xaDTT,T5D0c$%c%c%T$ @T T 4 <0$Xhx,TD4TlCtpz lt=@ 0;k kkbtMd@hkbltJ 0(0 ltFdNPP  `1t6P0 +'' '0:dNPP 6P0  ltFd0pz :d09 k k kk9btMd@lkb*lt ,:d NPPlt0 05P#(d%P0( ]t5P 1t+'' '0:dNPP 6P0 ltJ  1t+'' '0:dNPP 6P0  ltFd0pz7 :d0Ipz/ T,0tP0 K) H:X 8((]t58?  XhM  XhhhEDX]/8Vpzkz~ hEDXb  h0 K/ d(0h8K) H:X 8((]t58R%l 8  8KF688&:X 8(H]t58<3:X N88 /58D(X%8q(l -E68"(X%8Hk(h587(X%8Hk(h58MHkXh`  XhhhHkX]/8Vpz h0 K/ 00h 8888rU D$`\,A`` @`d )0/#,`hI/#,`li/#nrU 0!IiYyA%% Y) $q%i%890` ` Sheet4 1&__SRP_10! __SRP_11#\Sheet56*  (0B 8@H)P <p >    (8 @HPX B  `hpx  $  8@ PX `px]]X R%v't R,v t R,v R%vB@Hop]] RB@~  !v!( l] Get the Target Cell !v!' !v!'] ]8 !: 'd !v!'k . alue   !vB@H $!!('Maximum of 10 digits allowed in a cell. A@. (vFkkIf (Len(CellValue) < 11) Then X XSection4 X $'l 'l    (vXkPdH !vB@H $!!($]P $'   umeric Only numeric values are allowed. A@.ead#Please enter only an integer value. A@. kx (vhk` Else RB@ Target.Cells.Select6 Application.Selection.Interior.Color = 255or =F MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnlyvbOK Target.Cells = ""ls = End If EnkH@ RB@RB@'loh'  Section4n3      P al allow integer only $   X  $''Maximum of 10 digits allowed in a cell. A@.k ''kkkd'kih] . value 6MsgBox "Please enter only an integer value.", vbOKOnly If '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))Vad 'k  X'N  X'MsgBoxd 'ki] . " C]] $X '  . h .$'$$X$X 'd$X'kd X'kd 'kp  X' 'Hi@8Attribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Dim ShouldRun As Boolean P%) Sub Works_Activ () oldVal ]e.Cells(6, 5 "+0.Select EndU\Change(By+ Target;RA@' 3vA.ColumBRow  %Unprot"@.IntfHor.or@5v`bWhit@y If (a) ThNeA%is@-idg' G2theE5.C'4&9 9M F> '&A'ue'VapriancAER et>InStr(1,0.Address, ":") > 0DAE)*'%HIfaNot 7F .eLen(Fa1a[Application`c!L255eMsgBox "Maximum of 10 digits allowin a c`x.", vbOKOnly @F!zeGoTo L-:  #@=^ʴf?BP FKʜԡJ?flCxKʜԡJ?flC=^ʴf?BPME8 [LSS8>"<<<N0{00020820-0000-0000-C000-000000000046} %% % rp`k\@tl h`0pk`::)  %@h @X ` ` ` @ ,h`xk dBi iii(Ifi Hi  X ,` / hVi i  P@h  ,`@ lhi `y ani  @ h@ El@ %bl4 @hhpXXp@R@h @X @H T@8 @( @ @ @ ,@  8P(X0 x Rl$.@T @@D g@4 @p$ @ @ @ O@ @ @H @ @ @ $@` @p h 0 ( 0 H h ` z X 0  `th .@ d @b @ P @8 @ @ 0 @h @P  @ @ @ x @ X h `( z h @ ( @ X @ H @ 8 @( @  xPDp\ dN*\R1*#222$*\Rffff*034ebe49c6*\R1*#33b*\R1*#10d*\R0*#21*\R1*#29c*\R1*#fc*\R0*#1*\R0*#14*\R0*#10*\R0*#f8"..0,H5`x"   C  11.   @H 'P` .h$76+ '  $  ,5H x   ( $7.+@2+H '   & < L  $p 0   B   2 ( ` x06+ /m'1al*< 11Def=2  0-ogi RžRvalofAOFK?@9io&C6) |< #/g e1. Hnum0[c ureP1re10 _Pv`eAa o@5 an igernߝJ]84' -Gϊ?G?Gll}o CGzPz DrawingObj>s:=!, contScenmo?'i<1׈Fun onHv0xs[ , d HlRef v•b0I %FBqaD@tz)QiRdI5WpH"Po qS6> 4 A ,b[7> 5< 8r}'j34@Is^ )o? ?AOzC= Mid(^a /0owp owow.aV=c+gNpf˵/0 cBy*P*On Er"rdResY Nex!dcEU 'uYYp03 '![ !(&g"- 1)' < eP(rq0/%G;b0cODecimalpdblI6IdblValue, ".") > 0) Then  Dim val1 Droun8ded.& = CStr(RJD(d2))\I f (InL1,> ;]Split( 4[*_CInt(Mid(7(1), k1)= 5 ckaDbl20+ ElH 8 F X p (,# 6+P X`* p6+ 2 (0 8@HPX`B  hpx < > ( 0 8 P  X h p x   B    )   % &  3  $D( "P  h p               ]]X R%v      !"#$%&'()*+,-/0123456789:;<=?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^`acdefghijkmnopqrstvwxyz{|}~'t R,v t R,v R%vB@Hop]] RB@~  !v!( l] Get the Target Cell !v!' !v!'] ]8 !: 'd !v!'k . alue   !vB@H $!!('Maximum of 10 digits allowed in a cell. A@. (vFkkIf (Len(CellValue) < 11) Then X XSection5 X $' 'l    (vkPdH !vB@H $!!(]P $'    Only numeric values are allowed. A@.d#Please enter only an integer value. A@.kx (vk` Else Target.Cells.Select6 Application.Selection.Interior.Color = 255or =F MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnlyvbOK Target.Cells = ""ls = End If EnkH@ RB@RB@'loh'  Section5n3   8allow decimal and round the value to the nearest integer $1 If (Len(CellValue) > 10) Then? CellValue = Mid(CStr(CellValue), 1, 10)R MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 . Str(1,]h .$'$ ''Maximum of 10 digits allowed in a cell. A@.kd  '& Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.k k+---------------26/10/2010------------------ ''kkkd'ki] .  6MsgBox "Please enter only an integer value.", vbOKOnly '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))d 'k  X'  X'd 'kxip`] . ]] $X ' .  .$'"h#@ȶdtr Lr= FMk1EB?xMk1EB?ȶdtr Lr=ME [LSS8>"LLN0{00020820-0000-0000-C000-000000000046} %% % rp`k\@tl h`Hpk`::)  %@h @X ` ` ` @ ,`k d$$Bi iii(Ifi Hi  X @P ,` hfi i   @ Only,` oX lxi xA@.i  @h El@ @ t%bl4 @hpXpXR@h @X @H @8 @( @0 @ @ @ 8P(@pH xRl$.@T @XD @4 @$ @ @ @0 @ @ @` @ @ @ @x @p H (h H ` h `0 z p H 0 `t .@ d @b @ @ @P 0 @8 @h  @ @ @ XX 8 h X  p h 5b/`@ z lՀ X Lg@ ՟kd@ X V)@ H >@ 8 ;@( +@P  :˝00{@ 0u1@ G@ U @ tionhDp\ 8dN*\R1*#222$*\Rffff*044ebe49c8*\R1*#33b*\R1*#10d*\R0*#21*\R1*#29c*\R1*#fc*\R0*#1*\R0*#14*\R0*#10*\R0*#f*\R0*#15*\R0*#f8"..0,H5`x"   C  11.   @H 'P` .h$76+ '  $  ,5H x   ( $7.+@2+H '   & < L  $p 0  $$X$X 'd$X'kxdp X'kXdP 'k@  X' 'iصAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2Dim ShouldRun As Boolean P%) Sub Works_Activ () oldVal ]e.Cells(6, 2 "+0.Select EndU\Change(By+ Target;RA@' 3vA.ColumBRow  %Unprot"@.IntfHor.or@5v`bWhit@y If (a) ThNeA%is@-idg' G2theE5.C'4&9 9M F> '&A'ue'VapriancAER et>InStr(1,0.Address, ":") > 0DAE)*'%HIfaNot 7F .eLen(Fa1a[Application`c!L255eMsgBox "Maximum of 10 digits allowin a c`x.", vbOKOnly @F!zeGoTo L-:/m'1al*< 11Def=2  0-ogi RžRvalofAOFK?@9io&C6) |< #/g e1. Hnum0[c ureP1re10 _Pv`eAa o@5 an igernߝJ]84' -Gϊ?G?Gll}o CGzPz DrawingObj>s:=!, contScenmo?'i<1׈Fun onHv0xs[ , d HlRef v•b0I %FBqaD@tz)QiRdI5WpH"Po qS6= 2l O.39A  'rh imal 2d rou/CB9 to nrest%4nAIsDecC% AC{?= Mid(^c` 7+u2yyyo PI1E)u' d@' Akhilesh@I 26/10/2010BFoz!_.ParȢ(StW? u(0)oZOOOIfe& _y ',e@, J '- 26/10/2010 8  RetValue = pCellR4i0dateLZTrue(End If  Els9R&KFunction Pri v|  IsInt(ByRef inbAs Variant) BooleaOn Error Resume NextRDim cCIf (InStr(1,*, ".") > 0) The''MsgBox "P3se enter on ly an egv.", vbOKO6"=`'Mid( , CH- 1))TfN@(D CRAXM<)   cGoTo 0 |zR{DecimalD|dbAy|E|EW|s13[AroundedZCRA (2E[ JW"! Split(G = 5n[a7ADbl(0)) + H +P!aq}%ig_IDE.#IsJa!3` W__SRP_12 __SRP_13"\Sheet6Sheet7W.(X%(8%h$ @hlh.(X%(8%:%h$ @hh,(X%(8%lh$ @hh5(X%(8%h$ @hh5(0lhp l xT$ @TTC$%xaDTTa4,c)T6D4 41xaDTTa4"i$hT6D41xaDTTa4"i$XT6D4.xaD`# /5D :$:'xaDTTa4T5D.:$ D(]p45D2D($ ]t0$xaDTTT5D7($% T!  T WD C)T5D+'''4:$NDD 6D4':$%xaDTT,T5D5K#CXEhEdkp2k 4 @( @xaDTT,T5D$xaDTTT5D7($% T!  T WD C)T5D k$/D4gn+'''4:$NDD 6D4+'''4:$NDD 6D4':$%xaDTT,T5D0c$%c%c%T$ @T T 4 <0$Xhx,TD4plCtpz lt=] 0Xk k VbtMd@lkbTlt ,:d N@@lt0 0P5@#(d%P@0( ]t5@ 1t+'''0:dN@@ 6@0?ltJ = 1t+'''0:dN@@ 6@0 ltFd0pzfpz/ p,0tP@00   K) H:X 8((]t58R%l 8  8KF688&:X 8(H]t58<3:X N88 /58D(X%8q(l -E68"(X%8Hk(h587(X%8Hk(h58MHkXh`  XhhhHkX]/8Vpz h0 K/ 0h 8888rU D$`\,A`` @`d )0/#,`hI/#,`li/#n',#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0dNxAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'Q#xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0dNxAttribute VB_Name = "She@et7" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2'K#Sheet8&.frmLoginY__SRP_14><__SRP_15 _xME (SLSS<N0{00020820-0000-0000-C000-000000000046}@(%H@0dNxAttribute VB_Name = "She@et8" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU iB ++1VU   AAUP Error.A@.FoF   (d ( ( (kXP|H@Unhandled Error : !   AAUP Error.A@.FoAttribute VB_Name = "frmLogin"  Bas|0{0B62F61F-8231-4334-877C-D2C7950D8367}{2986C682-012CJ4A-B712-C4A42A93D841} dGlobalSpacoFalse CreatablPredeclaIdTru BExpo se0TemplateDerivCustomizD P Sub cmd_Click() On Error GoTo f: If (txtUsern.Valun"") Or @IsNull) Then lbl+.Ca`ption' is requi to auttic).aaExit,E`nd If%Password%wK%E %:A1v/P?S3v= E5Me.Hid ACpfFlMsgBox "Unhan dl` : " &y.Descric, vbCri\l, "AAUPÁ_Resu@a@ KCommButpton2ܕ) E"z BeOut7!! !!or!!>ǰAپYܱ<> Akg`ABa)O`Mp(nMd?l++M+ %%A)/qV!W C)CQCyCB4 C8)9<)C@ /D) H/I/`  L/I'`IP)!Ti0`eW Kl\hx! x h:X]/H4D! D 4 $)xD6h4$ x! x @x\hx! x h:X]/H4D! D 4 $)xD6h4$ x! x @xx! x @x$hx! x h` x5h$hx! x h`x5h K xx ,''4:XNHHl*Fh /x6hH4 i|$- (xDhH40 @  @K:l]@: TX! X @/TXX! X @X$:lN\\X! X X5\$:lN\\X! X X5\KT XX ,''$:lNDDlT*F\ /TX6\D$ x$- $TX\D$HLTHrU `$X A :\(TIE$hc1mDWWI]6J@sL(dK2u(CU夈 xu(CU夈 (TIE$hME8SPSSS6" LLLL<<<0{0B62F61F-8231-4334-877C-D2C7950D8367}{2986C682-012C-434A-B712-C4A42A93D841} @`0k `   `k$% %@h%%pX@ .@l @\ x@X @T @D @4 @$ @ @  @Hx @0h @xX @`H @D @4 @$ @ @ .@ p@` dN$*\Rffff*014ecf53dd$*\Rffff*0>4e90143f*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#C:\Windows\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#41*\G{AC2DE821-36A2-11CF-8053-00AA006009FA}#2.0#0#C:\Windows\system32\FM20.DLL\2#Microsoft Forms 2.0 Object Library*#44*\R0*#13*\R0*#19*\R0*#1*\R0*#14 48<@DHLPT4 ""\28px"\2  $ $  08@:KH "  :(0 "8@H Xh p $ $:K F ! !$E4&User Name is required to authenticate. (7 |k ! !$%Password is required to authenticate. ( the T|k (' !' !' B@ |Unhandled Error : !   AAUP Error.A@.Foh@F''' B@(| Unhandled Error : !`$A`$`nrU @$`$`$`$`$!`$I`$q`$`$`SheetCommandeE__SRP_20e__SRP_3/ byCommonMethods-*\R1*#10d*\R1*#fc*\R1*#101*\R0*#1*\R0*#14*\R0*#13*\R0*#19*\R1*#10d*\R1*#fc*\R1*#101*\R0*#21*\R0*#23$*\Rffff*014ecf53dd*\R0*#f*\R0*#10*\R0*#12*\R0*#2*\R0*#19*\R0*#fx ( 0 8 6P   . * ,( (X  "8@HP>`&x>+  ~Kpx     @ .` , , (  "1|3{<xME\@> LLLLLLL"L<`' <`pauta`n % <`hh 0( 8 ` k M p` kg @@( @8hXXP(`x@ 8 h $$. dos@P t sp@ p S\@ ` TF@\ \W@ L te@ < DR@ , 86@  GP@ ws@( sp@ S\@ CL  @ D$. IVR@( t \P@X p C:@p ` ys@\ l\@ L 2X@ < PD@ , s\@  po@ \W@ DI@ Wi@ em ` F$. V.L@t ws@0p sp@H` S\@\ NI@xL C:@< ys@, l\@ 2X@ XB@ in@ m3@ IVH8H$. hae@t =.@p BA@ ` S;@\ JS@PL H@h< WS@, _A@ E=@ SO@ ER@ y @ S@B$. @t @p @` Tp@\ @0L @H< h@`, @x @ @ HTp@ @ p($4p8$@.@x @t @d @X` @P @@ @(0 @@ @ @p @ @ @ @0 @ @ @ hBDFHR@` Vxb4@x @p @` @P @@ @, @ @  @8 @P @h @ @ @ @ H|fh4 @ @ X$@x @t @(d @` @@P @@ @p0 @ @p($@Xx @t @d @` @P @@ @0 @ `bxvxz|~@t @p @0l @Hh @`d @x` @\ @X @T @P @L @H @ D @8@ @P< @h8 @4 xp0 X8`vxH $x .@p @l @\ @X @H @8 @( @ @H @` @ @ @ P8H 8 h P!H ``xxpH@l  @j  @d  @!b !$x .@P \ @ X @ H @D @ 4 @ !$ @  @h! @8! !@ @ @ @! @! !!4@ !!4!!:X@ x`HX$#($#$""#"`zx"""@#l #" @0#j H## @X#` p#0#@^ $X#$x .@#X @#T @#D @@ @$0 @p$ @@$ @$ @$ @ @ @ @$ $X#_#a@ %xX'&('&'%%&%`|x%%%@&l &% @0&j H&& @X&d p&0&@b p'X&$x .@&\ @&X @&H @D @'4 @'$ @@' @' @' 'X&@ @ @ @' &)@  X*)(*)*(()(`~x(((@)l )( @0)j H)) @X)d p)0)@b *X)$x .@)\ @)X @)H @D @*4 @p*$ @@* @* @* @ @ @ @* *X)")#@ P8  -H,,x,++0,+`x+++@,l ,+ @j (., $x .@`,d @,` @,P @8-L @,< @,, @h- @- @- @. @P- @- @- @ @- @- @ @- @ @ ,XPP @ dN$*\Rffff*0>490143$**0490157*1*#33<H P X Q`   H    & d3ZJ     & 0d3PZJ    ( &8 ` d3 ZJ H  P  X &h  d3 ZJ x     &  d3 ZJH            H  I    ( I8 IP h  p  x I I     d *H :x &   b *x 8 &  .   SP Lp D  \  P h   %     II0 8 @IPIh   D .    0HHI`Ix   0HIII  8|@  <$+n8M$+nMh    P     p  +$++0*+@p.+JM    Z; x    $<'20h Sp  ZJ K(M0VP p 4J KMV ( .J8h KpMV  .J K @MHh p~K".08@ H 6`   . * ,8 (h  ( "H P X ` >p &   >+    ~K!!! ! 6! ! " . " *P" ," (" " p#"####>#&###>+# 0$8$ @$~KH$$$ $ 6$ (% H% .h% *% ,% (% & &"&&&&>'&'('0'>+8'x'' '~K'((  ( 68( p( ( .( *( ,) (@) h) *" *(*0*8*>H*&`*p*x*>+*** *~K*X+ `+ h+ <+ + &+ ., ,8, ,h, (, 0, ,B--- - b-  . $@. .h. ,. ,. (. 0 / P/Bp/x/ ///<`0>0>0> 1>1<11 11 1~K222 2 J2 2 $3 .@3 ,p3 ,3 (3 03 (4BH4P4 X4`4h4 x555555555.56 <v6X6 <y`66 6 66  6 >6 &"7 ""87 D`7 D7 B7 B88 @8 88 8  8 >8 &"(9 $"P9 Dx9 D9 B: BP: @: ::::.:(; <v@;; <y;; ; ;;  ; >; ("8< ""`< D< D< B= B`= @= == =  > >> ("P> $"x> D> D> B0? Bx? @? @@@@ @  (@  0@ :@@ F@ J@ HA L`A LA JB JPB HBBB <B 8C@C HC~KPCCC C JC HD $hD .D ,D ,D ( E 0HE xEBEE EEhE  F(F0F8F@F^XF  F \-F >(G DhG GG G G fG@HHH PHXH`H~KhHHH H JI `I $I .I ,I ,J (8J 0`J JBJJ JJJ hKpKxKKKKKKKK <vKL L"-0L&"XLHL>L <yMPM XM"-hM("MHM>N@N HN PN XN `N pNNO OOO~K OOO O JO P $8P .`P ,P ,P (P 0Q HQBhQpQ xQQQ RRRRRRRRRR <vS@S <yHSS S SS  S >S &"S L T JpT LT UU U  (U >8U ("xU LU JU L@V VV V V VWW WWW~KW0X8X @X JXX X $X .X , Y ,PY (Y 0Y YBYZ ZZZ ZZZZZZ[f[ p[d[ [[ \ \ \  \J}8\ \ \"\ "\@\B(]@p]] ]J] (^ 8^"H^ "h^@^B^@_P_ X_Jx_ _ _"_ "`@(`Bh`@`` `Ja ha xa"a "a@aBb@Pbb bJb c c"(c "Hc@hcBc@c0d 8dJXd d d"d "d@eBHe@ee eJe Hf Xf"hf "f@fBf@0gpg xgg   gg g g gXh`h hhphxh~Khii i >(i hi i .i ,i ,j (8j 0`j j"j <jJj QkI8kIPkIhkIk 8Jk.Jk,Jl,J0lH`lxl l @l l l .m ,Hm ,xm (m 0m n" nI(nI@n QXnIxnInIn8Jn.Jn,J(o,JXoHoMoMoMoMp p0p] X] ] ] ] (] P---- Summary ----/*** This Procedure Validate Section 1 Data. *** None None' Akhilesh Gautam$ 8/9/2010% Akhilesh Gautamd Er" 9/8/2010 Change the Sub Name from Button2_Click() to ValidateSection1_Click() attach it to the button and put the summary.---- End Summary ---- F] "$$ $%^B@H " A@.|pkh/Section 1 data has been successfully validated. A@.& | QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.&Fo---- Summary ----|*** This Procedure Validate All Sections Data and Call webservice to authenticate User/Unitid and upload data to Server. ***55or = NoneѲ澱 None' Akhilesh Gautam =% 8/15/2010% Akhilesh Gautam" 9/8/2010 Change the Sub Name from Button3_Click() to UploadData_Click() attach it to the button and put the summary. ---- End Summary ---- > 1 F $%^!*(Value ](]@ $%^!0!` $%^!0!2 4m of6A@pA@8 @ $%^!:(<  Validating the Inputsed B $%^!>(`]X "$$ Application.Worksheets(1).SelectMsgBox vErr, vbOKOnly'?Validation failed. Please rerun the validation for each section @Validation FailedA@. M@Validation failed. Please rerun the validation for each section. $%^!>( |k' "$B Application.Worksheets(2).SelectMsgBox vErr, vbOKOnly?Validation failed. Please rerun the validation for each section @Validation FailedA@.@Validation failed. Please rerun the validation for each section. $%^!>(|k "$D Application.Worksheets(3).SelectMsgBox vErr, vbOKOnly?Validation failed. Please rerun the validation for each section @Validation FailedA@.@Validation failed. Please rerun the validation for each section. $%^!>(|k "$F Application.Worksheets(4).SelectMsgBox vErr, vbOKOnly?Validation failed. Please rerun the validation for each section @Validation FailedA@.@Validation failed. Please rerun the validation for each section. $%^!>(|kx "$H Application.Worksheets(5).SelectMsgBox vErr, vbOKOnly?Validation failed. Please rerun the validation for each section @Validation FailedA@.@Validation failed. Please rerun the validation for each section. $%^!>(|PkH Authenticate User]p]'J $%^!N(` $%^!>(` R B@P  $%^!N(` $%^!>(`&Fk  $%^!N(` $%^!>(`&Fk8 ReUsername:] vUsername = InputBox("Please enter your user name.", "AAUP::User Authentication")$ If (vUsername = "") Then3 MsgBox "User name cannot be blank." GoTo ReUsername: End If RePassword:\ vPassword = InputBox("Please enter your password.", "AAUP::User Authentication")$ If (vPassword = "") Then2 MsgBox "Password cannot be blank." GoTo RePassword: End If '**** Authenticate user * $%^%v'LCservice:mexAddress='https://research.aaup.org/ExcelService.svc/mex'', ,6, address='https://research.aaup.org/ExcelService.svc' ', ,M, binding=WSHttpBinding_IExcelService, bindingNamespace='http://tempuri.org/' ', ,A, contract=IExcelService, contractNamespace='http://tempuri.org/' ',] , V%X.T''Z  $%^!N(` $%^!>(`&Fk  $%^!N(` $%^!>(`&Fkp   $%^%v!$x L  T%\'J 'vUserid = service1.OutputTest(OutError) J **** Gathering Data *** $%^!^(` $%^!N(` $%^!>(`]$b'`**** Uploading Data *** $%^!0(` $%^!^(` $%^!N(` $%^!>(`' J $%^%v!$x L ` )  $%^%v!$x$4    T%d '5 Check the error code and display error on the Sheet.    Data Upload StatusA@. Status :  Last Update date/time  |MM/dd/yyyy hh:mm AM/PM$ $%^!0( 4 $%^!0(2d0  Data Upload StatusA@. Status :  Last Update date/time  |MM/dd/yyyy hh:mm AM/PM$ $%^!0( f $%^!0(2IApplication.Worksheets(1).Label4.Caption = "Data uploaded successfully.."k 'd z Check the error code if related to user then show userform and display error there other wise display error on the Sheet. J B@PZF Je   Unit Id ErrorA@. Je  Primary User ErrorA@. Je   Survey ErrorA@. Je  Review & Sign off ErrorA@. Je  Survey Already Exists ErrorA@.kH  $%^!N( 4 $%^!N(2'kd]@Data have already been uploaded, would you like to upload again? hAAUP$.'  46Fkhk`&X|P H] !l4Disconnected internet connection / Down web service.'j !le)Passing invalid parameters to web method.'jk $%^!>!` j@Validation failed. Please rerun the validation for each section. $%^!>(I .d j $%^!>(k 4 $%^!>(2 $%^!N!`e jAuthenticating user fail. $%^!N(d@ j $%^!N(k 4 $%^!N(2 $%^!^!`e jGathering data fail. $%^!^(d j $%^!^(kh 4 $%^!^(2 $%^!0!`e jUploading data fail. $%^!0(d j $%^!0(k 4 $%^!0(2k jQUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.d j Unhandled ErrorA@.k&Fo---- Summary ----/*** This Procedure Validate Section 2 Data. *** None None' Akhilesh Gautam$ 8/9/2010% Akhilesh Gautam" 9/8/2010 Change the Sub Name from Section2_Click() to ValidateSection2_Click() attach it to the button and put the summary.---- End Summary ---- F]@ "$B $%^B@H " A@.|`kX/Section 2 data has been successfully validated. A@.&| QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.&Fop---- Summary ----/*** This Procedure Validate Section 3 Data. *** None None' Akhilesh Gautam$ 8/9/2010% Akhilesh Gautam" 9/8/2010 Change the Sub Name from Section3_Click() to ValidateSection3_Click() attach it to the button and put the summary.---- End Summary ----X F] "$D $%^B@H " A@.|k/Section 3 data has been successfully validated. A@.&| QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.&Fo(---- Summary ----/*** This Procedure Validate Section 4 Data. *** None None' Akhilesh Gautam$ 8/9/2010% Akhilesh Gautam" 9/8/2010 Change the Sub Name from Section4_Click() to ValidateSection4_Click() attach it to the button and put the summary.---- End Summary ---- F] "$F $%^B@H " A@.|k/Section 4 data has been successfully validated. A@.&|x pQUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.&Fo---- Summary ----/*** This Procedure Validate Section 5 Data. *** None None' Akhilesh Gautam$ 8/9/2010% Akhilesh Gautam" 9/8/2010 Change the Sub Name from Section5_Click() to ValidateSection5_Click() attach it to the button and put the summary.---- End Summary ---- F]H "$H $%^B@H " A@.|k/Section 5 data has been successfully validated. A@.&8|0 (QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.&Fo---- Summary ----5*** This Procedure Generate XML String to Upload. *** None XMLString ' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----` $v $x $z $| $~ $ 'bi`---- Summary ----\*** This Procedure Generate XML String for Section Institute/Conversionfector to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----F'v]@Uid@Inst@RName@Phone@Email@CF' @Uid $%^%v!$x$' @Inst $%^%v!$x$' @RName $%^%v!$x$' @Phone $%^%v!$x$' @Email $%^%v!$x$' @CF)  $%^%v!$x$' 'vzQUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.Fip ---- Summary ----C*** This Procedure Generate XML String for Section 1 to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----F'x]8@Rank@facultyOn@gender@nooffaculty@totalsalary@notTenure@onTenure@Tenured']P]h]' ]]''   & 9 Months Data     $%^%v!$ '    $%^%v!$ e'kP H  x 'x x@Rank  $%^%v!$$'x x @facultyOn9Month$'x x@genderMen$'x x @nooffaculty  $%^%v!$x$'x x @totalsalary  $%^%v!$x$'x x @notTenure  $%^%v!$x$'x x @onTenure  $%^%v!$x$'x x@Tenured  $%^%v!$x$'x'k0  x 'x x@Rank  $%^%v!$$'x x @facultyOn9Month$'x x@genderWomen$'x x @nooffaculty  $%^%v!$x$'x x @totalsalary  $%^%v!$x$'x x @notTenure   $%^%v!$x$'x x @onTenure   $%^%v!$x$'x x@Tenured   $%^%v!$x$'x'k''   e*12 Months Data     $%^%v!$ '    $%^%v!$ e'k(   x 'x x@Rank  $%^%v!$$'x x @facultyOn12Month$'x x@genderMen$'x x @nooffaculty  $%^%v!$x$'x x @totalsalary  $%^%v!$x$'x x @notTenure  $%^%v!$x$'x x @onTenure  $%^%v!$x$'x x@Tenured  $%^%v!$x$'x'k  x 'x x@Rank  $%^%v!$$'x x @facultyOn12Month$'x x@genderWomen$'x x @nooffaculty  $%^%v!$x$'x x @totalsalary  $%^%v!$x$'x x @notTenure   $%^%v!$x$'x x @onTenure   $%^%v!$x$'x x@Tenured   $%^%v!$x$'x'k?''k?? 3 GetXMLForSection1 = GetXMLForSection1 & DataRow? GetXMLForSection1 = Replace(GetXMLForSection1, "@Rank", "")D GetXMLForSection1 = Replace(GetXMLForSection1, "@facultyOn", "")A GetXMLForSection1 = Replace(GetXMLForSection1, "@gender", "")F GetXMLForSection1 = Replace(GetXMLForSection1, "@nooffaculty", "")F GetXMLForSection1 = Replace(GetXMLForSection1, "@totalsalary", "")D GetXMLForSection1 = Replace(GetXMLForSection1, "@notTenure", "")C GetXMLForSection1 = Replace(GetXMLForSection1, "@onTenure", "")B GetXMLForSection1 = Replace(GetXMLForSection1, "@Tenured", "")'xk=5GetXMLForSection1 = GetXMLForSection1 & ""<z<<QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.Fi <---- Summary ----C*** This Procedure Generate XML String for Section 5 to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----F']`@Rank@basic@supplement'] ]8]P'   $%^%v!$  $%^%v!$   ' @Rank  $'L4Trim(Application.Worksheets(5).Cells(vRow, 1).Value) @basic  $%^%v!$x$'  @supplement  $%^%v!$x$''k@888 `GetXMLForSection5 = ""'k77z77QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.Fi7---- Summary ----C*** This Procedure Generate XML String for Section 4 to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----hF'~]@Rank@facultyOn@salaryintervals@value']]]' O]] ''     $%^%v!$ ' ~ '~ ~@Rank  $'~ ~ @facultyOn9Month$'~ ~@salaryintervals  $%^%v!$$'~ ~@value   $%^%v!$x$'~'    $%^%v!$ e' ~ '~ ~@Rank  $'~ ~ @facultyOn12Month$'~ ~@salaryintervals  $%^%v!$$'~ ~@value   $%^%v!$x$'~'k111 GetXMLForSection4 = ""'~k00z00QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.FiP0---- Summary ----C*** This Procedure Generate XML String for Section 3 to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----8F'|]x@Rank@facultyOn@noofcontinueFaculty@salaryCurrenyear@salaryPreviousYear']]]'  ]]''     $%^%v!$ '    $%^%v!$ e'kh,`,  | '| |@Rank  $%^%v!$$'| | @facultyOn9Month$'| |@noofcontinueFaculty  $%^%v!$$'| |@salaryCurrenyear  $%^%v!$x$'| |@salaryPreviousYear  $%^%v!$x$'|'k*  | '| |@Rank  $%^%v!$$'| | @facultyOn12Month$'| |@noofcontinueFaculty  $%^%v!$$'| |@salaryCurrenyear  $%^%v!$x$'| |@salaryPreviousYear  $%^%v!$x$'|'k`)X) GetXMLForSection3 = ""'|kh(`(zX(P(QUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.Fi'---- Summary ----C*** This Procedure Generate XML String for Section 2 to Upload. *** None XMLString' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----F'z]H@Rank@facultyOn@benefit@totalExp@noofCov']`]x]' ]'   (E And val(Application.Worksheets(2).Cells(vRow, vCol).Value) > 0) Then9Month'   e-DAnd val(Application.Worksheets(2).Cells(vRow, vCol).Value) > 0) Then12Month'k$ ]'      $%^%v!$ add z 'z z@Rank1$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp  $%^%v!$x$'z z@noofCov  $%^%v!$x$'z' G  'j     $%^%v!$ eadd z 'z z@Rank2$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp  $%^%v!$x$'z z@noofCov  $%^%v!$x$'z' G  'j     $%^%v!$ eadd z 'z z@Rank3$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp  $%^%v!$x$'z z@noofCov  $%^%v!$x$'z' G  'j      $%^%v!$ eadd z 'z z@Rank4$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp  $%^%v!$x$'z z@noofCov   $%^%v!$x$'z' G  'j       $%^%v!$ eadd z 'z z@Rank5$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp   $%^%v!$x$'z z@noofCov   $%^%v!$x$'z'  G  'j       $%^%v!$ eadd z 'z z@Rank6$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp   $%^%v!$x$'z z@noofCov   $%^%v!$x$'z'  G  'j     $%^%v!$ eadd z 'z z@Rank7$'z z @facultyOn $'z z@benefit  $%^%v!$$'z z @totalExp  $%^%v!$x$'z z@noofCov  $%^%v!$x$'z' G  'jk`XkPH GetXMLForSection2 = ""'zkzQUnhandled Error :Please contact with AAUP System administration with description: !  Unhandled ErrorA@.Fi---- Summary ----7*** This Procedure use for Active Progress Section. *** None None' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----5Application.Worksheets(1).ProgressBar1.Visible = True $%^!:( @ $%^!:(< $%^!0(` $%^!^(` $%^!N(` $%^!>(`Validating all sections data. $%^!>(Authenticating user. $%^!N(Gathering data .. $%^!^(Uploading data .. $%^!0( $%^!:B@o---- Summary ----9*** This Procedure use for DeActive Progress Section. *** None None' Akhilesh Gautam% 8/16/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ---- $%^!0(` $%^!^(` @ $%^!:(< $%^!N(` $%^!>(` $%^!:(`Validating all sections data. $%^!>(Authenticating user. $%^!N(Gathering data .. $%^!^(Uploading data .. $%^!0( $%^!:B@  $%^!>(2  $%^!N(2  $%^!^(2  $%^!0(2oAttribute VB_Name = "SheetCommand" Public isRanked As B@ooleanlv`Usern|8S ng6Passworp 6Out ErrorSVa`riant7CodeUpload;' '- Sury  *** This Proceduralida|Section 1 Data .  None Akhilesh Gautam8/9/p2010 u>pP' 9/8&&LastU(>Chang e theJb ~from Button2_C@|k() to V II1attach itA  @ pu@@sa.k1).Label1.Capz, ='P.?Exit Sub Lޑ'Aunt@e User Dim vid As Integ B Year 1= 0Q2.VisibleQPTrue*1FalsLfrmLogin.Show (vbModal) K6nam(""h9*\:AGoTo Method:2QPas`swordYo~n|a81 'ReA[!6 '#eI9InpuRt("de`r your u@f .`"AAUhP::a k "`G Ee A cann be blanka" E<@ :N =Y pB? Jn%  C@Reeq\l'*7e VD  b LOz$ ]'2lp=v%.E5Upload(n, Tprim(? 5 CL3cALAue)O, E()'.uTest(_rvrp > 0(61\[ GapBUqʾ \\3Q8 ?-1BGxmlGe%_s= FXMLC(|Q $1k 4 9PC[Q 51`c.D~;id;;;A , isReCDec(Trim(Application.Worksheets(1).Cells@(41, 14Value)), vUsernamePassword, UploadError) "' Check the e5 code and displayon# S.GIf ({ < 0) Then*MsgBox OutUabOKOnly, "Datac Status""Label4.Cap = "$ : " &;" LastA7date /timeFormat(NowJMM/dd/y hh:mm AM/PM"oM-eColor' vbRed8Else>O(O&@IOKlOGreՙ[Oi'Iued successfully..E@IfbWBOzif rel@]d to u zn sho:wf`^re o wis eO:•id@-19frmLogpin.S@ GoTo Recn:OA$,2sUnit Id 18`tl 3 s Pary )4Surve6y_ G 5_ S ReviewSig`n off6Alreadxists7q2wVa{A66D?BDim@=bsk ans8d(SwhavbPU L, would you li keCN again?"1|YesNorAAUPqa2#vbp?=sAa=Z ExitMethod Sub V;3mYage Asring 0.Numbez-214722102^X`Disconnect_intet " / Down web WviceaeK45descrip :" &J.D, vbCritical,r"pElse#Cnd"Resume ExitMethod: ESub '- Summ0ary  ***is Procedure Validate Secx2 Da0ta.  <param>No0neAkhilesh Gautam</ 8e>8/9/2010 upP'F 89/8DLastU>Cth@?ub Na!SfromB2_Click() toJIat0h itA butt@ pu@ǀja.a.Worksheets(2).SelDAOKOnly ;}xr?xte>B?x;4a4;te;?x?x?x ;>n;0x; ;40w0 ww4;$mwr¡w3p 4;wwǧ!wwQ;A"+;&5;;?;;;;; <;;te;@B;an5;;;;;;;n;;Ƴ;;5;B7;;5;41;r; 4;5;;;;Bw?wwwww Resume ExitMethod: End SubP'-0mmary 0 '*** This Procedure Generate XML String to Upload. bn None</returns>=<Akhilesh Gautam,8/16/2010%'upd(dž 9/8&A&LastU(>Put the ." &ForIns@titute&L "Se31U2345JSuqfor 7 A/ConversWf>/F剿t' @@Uid@?9@CF'`e>!ata= Replace(, "", Trim(Applica.Worksheets(1).Cells(3, 3).Value))( ! ~4 B(  5  .  6  7"8  7  CF 41, 18F7bBF!g@= pmMsgBox "Unhandledp:Please  Vt@U with AAUP System administP|3descrip(&:eP<.D7, vbCrp8cal ,. $ o @Hi^1m> `@\?φφ\edbSZφKexr\cBφφ φ φ"@YX\|r \x\\w A 16 A@< 2 3)>'9 Months r v= 2 <11< 7UssL`5t > 0#u$=yuA5Else6> ?|??Tr^ If Next pO %@P:fi6&% bp>r??3ro 1` RTVD"9&"?[M?K G?RJ qb5, 2Ƞ lace(GetXMLForSection1, "@totalsalary", Trim(Applica.Worksheets(1).Cells(vRow, 3).Value`))  = RepnotTenure+4Eon1?5E?> d+~6>CheckAtleastOneTrueEnd IfGIf (FoundWomen) ThenGwv& Data@ZRankD䣀Afacu ltyOn"9@Month"genderWpnoof)h7Vcv8??49Ѧ101d?+bMen=DFhkEl se > 24 A< 31C '12 bns vCol 2 To 11+B < 7" _E 2 0!h˪a> 6 + Next$1E O \=? /^ /^/:+3*^12?^pOOJ7^`1^`,ox^pMp2ER ^A^?N #^ߏ.1/ ^on]C}s 𢟡WoC1oC_ZoCoCoCʟM oC IO K Co;o;`;+////!寡@C{CC @CCC*? ; Cplication.Worksheets(1).Cells(vR ow, 1@ FExit:Cρ Fun@FErrorDMsgBox "Unhandled" B :Pe contact with AAUP System adminis trBdescripe:" & A .Dg, vbCritl`^LoResumeN %!'- SummC $***`wis P roced= GHene@e x String for $ 5 to Upload .  None @ # Akhilesh Gautam8/16/28010up>d  &9/8 C L@U >Put the @,'."0@  0 Or _%3IEoc14o%sk?o+ 2) 'Trim/, QH/}5!"Y'?= g(&<#& >' i]8 87t>6raja_Mpllll llllllSOltvQll7lll4llm>llll <Ƽ>@b 10 And ' A0) ThenFound12A& Dxata^~Rank[>->p 12E b`RIf>Next WUoF`yeQ'D"DN`one@ # Akhilesh Gautam8/16/2010upd  &9/8 C L U >Put the @,'.@OyD<9Currenyear>@TPrevious~Yx9z@#E3r> тIPgerD{NLBoo< uONBNPA1"= 9 P24Crw9qv?X y9$= 6{Hr "t= 21Y! < 15on}ٕ3ەaՍ > ߍ֍ 18///ߍ"?19k  :48_%3@]r9ϟc >"ϽQ??:@y 'ƽ2'EP?7<ߛoooyJ8ΰ?oI;0//12////qf//1"22RҔ/// //*/  fNo0neC@createdBy>Akhilesh Gautam8/16/p2010F  u|pdF 9\/8DLU>Put the ,'.@@%@ AAIntegerColǎ'Boon @wWB = 6 +29#|ย TvE ) > 5 A< 17 'al2v@0 > 0id i9Mh'E)183 '?bDͿ`12d"%*<> ""A2IsAd>d;= ob5 a`d2=17# (Or%3r7y1Q'add>=Ba=OOonQBRψm2d@"1"lC`!/eG撜51OO/B%NP_Wl0 2@T_n\_%pT; 3S<4B5+ 1?* eJ4 757 7 7727sOAx"27)|)7ty?/ 7(&7 UOOJ7tsmoJL@c/Ss?7O^5_Hj77Bt=ڏ7767@qAo#777 77tO_$Z$737#ײce(GetXMLForSection2, "@facultyO@n", vF0) ~ = Replabe nefitVal(Applicay.Worksheets(2).Cells(vRow, 1).,ue)Etot alExpBTrim$C6MCnooPfCovB7BCheckAtle@astOneTrueIf (vCol 6) `Then + 1 Else!E8 Or 9) And v40 > 0C!S+'addSQ& D8ata@'Rankn"4"?p?oj.o8\^ o9wog'o8o o10(o11_o_o_oP1_oНYEo5_o= ަ!MMg1#_o7w0_/ʅ7/Z 7_o}71goo72737Д?67w?iq7Q1= ?7r/*7~677tyOu =۬7 S 7O@1xoz7773O@H ]7 772o O76777777 772 7rO/*77777E774OOK7771s777ko776) Then v Col =`+ 1 End If` $Next"f(If (CheckAtleastOne`False7'GetXMLForSection"2%"None</returnsEcreatedBy>Akhilesh Gautam8/16/2010F  updF q 9/8DLU>Put 0the @TK.3?G b 2?,%01.Cam@"ValiHing all Ds `\(`%pt$ t p d\)tp\&'''<xM`@ 6<+''':`N<< 6<K tt , '':` N l*F< /t6< (x,tp\<TKx |>\(`%pt$ t p d\)tp\&'''<xM`@ 6<+''':`N<< 6<K tt , '':` N l*F< /t6< (x,tp\<TKx |>\(`%pt$ t p d\)tp\&'''<xM`@ 6<+''':`N<< 6<K tt , '':` N l*F< /t6< (x,tp\<J K#t*#pL*#l M#h*#dL*#` N#\*#XL*#T O#P*#LL*#H P#D*#@L*#< Q#8*#4R*1x2"tplhd`\XTPLHD@<84121H(-xPtplhd`\XTPLHD@<84 K^CxSCt(H%((%X(\%lp$ p l dX'= -Tlt U1t/)plX6(H%((%X(\%lp$ p l dX'= -Vlt U1t/)plX6(H%((%X(\%lp$ p l dX'= -Wlt U1t/)plX6(H%((%X(\%lp$ p l dX'= -Xlt U1t/)rU~| ~ !yA(++A+)q Y2 4 4I !?iA;q;;;I7q7A @qABB IE1F HQIRiJJqaSJ1K K!GG)O LQLLLiMOM PPQ!RR TTTQUUOOa9 XQXy[ \[[WSK `y\\\A]]a]]]1^i^^^AdffgQgggggghAh^a_AllnQoApq rTKx |>\(`%pt$ t p d\)tp\&'''<xM`@ 6<+''':`N<< 6<K tt , '':` N l*F< /t6< (x,tp\<KJ:P%`(d%tx$ x t d`W0C)xt`50`(d%tx$ x t d`W0AfP]/(@%$   dWA]/) xt`60  QP @%`(d%tx$ x t d`W0C)xt`50HcP%`(d%tx$ x t d`W0C)xt`50 13'':P N@:d!N00 60J:P"%`(d%tx$ x t d`W0C#)xt`50  3'':P N@:d!N00 60J:P"%`(d%tx$ x t d`W0C#)xt`50 Z3'':P N@:d!N00 60J:P"%`(d%tx$ x t d`W0C#)xt`50 3'':P N@:d!N00 60J:P"%`(d%tx$ x t d`W0C#)xt`50 z3'':P N@:d!N00 60J:P"%`(d%tx$ x t d`W0C#)xt`50pHcP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50d%%$&0IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`500{IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50S(P%(%`(d%tx$ x t d`0'Up)xt`50(C, l,)*1, l,**1, l,+*1,%'0,Md@ , 460 :d (d0IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`500IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50@@(P%(%`(d%tx$ x t d`0'= -@ @.Up)xt`60 kHcP%`(d%tx$ x t d`W0/C)xt`50IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50 01<HcP%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0/C)xt`50IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50 (d,@(P%(%`(d%tx$ x t d`0'= -@<@ @(p)%(P %(%$   d'= - 1@@, @2  ) xt`60,(d]g +'':d3N00 60 4:d5 0:P6:@7N 8%`(%tx$ x t d`WC#)xt`60MP%`(d%tx$ x t d`W0C)xt`50+'':d3N00 60 4:d5 0:P6:@7N 8%`(%tx$ x t d`WC#)xt`60MP%`(d%tx$ x t d`W0C)xt`50 :d  k%$&; k +'':d9N00 60 kC+'':d:N00 60 k|+'':d;N00 60 k+'':d<N00 60 k+'':d=N00 60J `(d%tx$ x t d`W0$C#)xt`50MP%`(d%tx$ x t d`W0$C)xt`50 :d ;'':P>N:d?N00^i60d]3$ xx  lx!@CM$ xx  lxMACS`(d%tx$ x t d`W0AcP]3)xt`60 l0J:P"%`(d%tx$ x t d`W0C#)xt`50IKlFP%`(d%tx$ x t d`W0C#)xt`50MP%`(d%tx$ x t d`W0C)xt`50|S`(d%tx$ x t d`W0$AcP]3)xt`60 l0HJ:PB%`(d%tx$ x t d`W0$C#)xt`50KlFP%`(d%tx$ x t d`W0$C#)xt`50MP%`(d%tx$ x t d`W0$C)xt`50|S`(d%tx$ x t d`W0/AcP]3)xt`603 l0J:PC%`(d%tx$ x t d`W0/C#)xt`50KlFP%`(d%tx$ x t d`W0/C#)xt`50MP%`(d%tx$ x t d`W0/C)xt`50|S`(d%tx$ x t d`W0AcP]3)xt`60| l0J:PD%`(d%tx$ x t d`W0C#)xt`50-KlFP%`(d%tx$ x t d`W0C#)xt`50MP%`(d%tx$ x t d`W0C)xt`50 l0K xx , '':d N l*F0 /x60 .'':P N00Md@ 60 @-((<,Hxt`0TKx |>\(`%pt$ t p d\)tp\&'''<xM`@ 6<+''':`N<< 6<K tt , 'plX6(H%((%X(\%lp$ p l dX'= -Ylt U1t/)plX6(H)%(( %X(\%lp$ p l dX'= -Zlt U1t/)plX6ltCxK pp , '':\ N l*F /p6 [o,-xt,plX,KzCxtpnrcjbphpfkrkrp cbevkpr@p@D(H%X\$ \ X dD'A \/)\XD6phYvkpr@p@D(H%X\$ \ X dD'A \/)\XD6Ypf pdb\kh  lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"     2 !"#$%&'()*+,-./013456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~^_lx U1x"`alx U1xr@($%D(H%X\$ \ X dD'= -blx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -clx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -dlx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -elx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -flx U1x/)\XD6pnkf lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"^_lx U1x"galx U1xr@($%D(H%X\$ \ X dD'= -blx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -clx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -dlx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -elx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -flx U1x/)\XD6pnphpfVkrkrVp c vkpr@p@D(H%X\$ \ X dD'A \/)\XD6k ph vkpr@p@D(H%X\$ \ X dD'A \/)\XD6 pf pdkh lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"h_lx U1x"`alx U1xr@($%D(H%X\$ \ X dD'= -blx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -clx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -dlx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -elx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -flx U1x/)\XD6pnkfF lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"h_lx U1x"galx U1xr@($%D(H%X\$ \ X dD'= -blx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -clx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -dlx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -elx U1x/)\XD6r@($ %D(H%X\$ \ X dD'= -flx U1x/)\XD6pnphpf rdj- knuCxK \\ , '':H N l*F /\6 w,-xt0 \XD8KzCx{Ctpnr cjbr@(,%L(P%`d$ d ` dL 'A \r@(%(%$   d'A \2) d`L6 V lxlt*1x-kr#]lx U1x/r@(,%L(P%`d$ d ` dL '= -|lx U1x/)d`L6 r@(,%L(P%`d$ d ` dL '= -}lx U1x/)d`L6 pn rdj- knuCxK dd , '':P N l*F /d6  w,-xt< d`L (KuCxxCtpnrOcj]phpfpcbSvkp r@p@D(H%X\$ \ X dD'A \/)\XD6Jph lxlt*1x-kp#]lx U1x/"^_lx U1xr@($%D(H%X\$ \ X dD'A \to#ylx U1x2)\XD6r@p@D(H%X\$ \ X dD'= -zlx U1x/)\XD6pnGvkp r@p@D(H%X\$ \ X dD'A \/)\XD6Gpf lxlt*1x-kp #]lx U1x/"h_lx U1xr@($%D(H%X\$ \ X dD'A \to#ylx U1x2)\XD6r@p@D(H%X\$ \ X dD'= -zlx U1x/)\XD6pn pdbJ rdj- knpCxK \\ , '':H N l*F /\6 re,-xt0 \XDKgCxtCtpn rcjOphpfpcbSvkrr@p@D(H%X\$ \ X dD'A \/)\XD6phGvkrr@p@D(H%X\$ \ X dD'A \/)\XD6Gpf pdbJkh lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"^_lx U1xr@($%D(H%X\$ \ X dD'A \to#ulx U1x2)\XD6r@($%D(H%X\$ \ X dD'= -vlx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -wlx U1x/)\XD6pnkfC lxlt*1xr@($%D(H%X\$ \ X dD'A \to#]lx U1x2)\XD6"h_lx U1xr@($%D(H%X\$ \ X dD'A \to#ulx U1x2)\XD6r@($%D(H%X\$ \ X dD'= -vlx U1x/)\XD6r@($%D(H%X\$ \ X dD'= -wlx U1x/)\XD6pn rdj- knbCxK \\ , '':H N l*F /\6 d,-xt0 \XD(KCxiCtpnrcjCdkrkrR^CdlkrkrlhCd ld=pbpc^}kpkpr@p@@(D%TX$ X T d@'A \/)XT@6& lxlt*1x"j]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp# kppp}kpkpr@p@@(D%TX$ X T d@'A \/)XT@6 lxlt*1x"n]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp kppp}kpkpr@p@@(D%TX$ X T d@'A \/)XT@6P lxlt*1x"o]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kpM kppp}kpkp r@p@@(D%TX$ X T d@'A \/)XT@6 lxlt*1x"p]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp kppp}kp kp r@p@@(D%TX$ X T d@'A \/)XT@6z lxlt*1x"q]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp w kppp}kp kp r@p@@(D%TX$ X T d@'A \/)XT@6 lxlt*1x"r]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp   kppp}kpkpr@p@@(D%TX$ X T d@'A \/)XT@6 lxlt*1x"s]lx U1x"ld_lx U1xr@( %@(D%TX$ X T d@'A \to#klx U1x2)XT@6r@( %@(D%TX$ X T d@'= -llx U1x/)XT@6r@( %@(D%TX$ X T d@'= -mlx U1x/)XT@6pn kp kppp pd^ rdj- knCxK XX , '':D N l*F /X6 c(0-xtd0 XT@x4J(P%`(d%tx$ x t d`W0C)xt`50QP @%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0/C)xt`50IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50J:PE%`(d%tx$ x t d`W0C#)xt`50J:PF%`(d%tx$ x t d`W0$C#)xt`50J:PG%`(d%tx$ x t d`W0/C#)xt`50J:PH%`(d%tx$ x t d`W0C#)xt`50H`(d%tx$ x t d`W I)xt`5 \4$- xt`0 hIfP%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0/C)xt`50QP @%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0$C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50IfP%`(d%tx$ x t d`W0C)xt`50J:PE%`(d%tx$ x t d`W0C#)xt`50J:PF%`(d%tx$ x t d`W0$C#)xt`50J:PG%`(d%tx$ x t d`W0/C#)xt`50J:PH%`(d%tx$ x t d`W0C#)xt`50H`(d%tx$ x t d`W I)xt`5 MP%`(d%tx$ x t d`W0C)xt`50MP%`(d%tx$ x t d`W0$C)xt`50MP%`(d%tx$ x t d`W0/C)xt`50MP%`(d%tx$ x t d`W0C)xt`50\h$- xt`0      %$ `$ `$9 `$a `$ `$`nrU ( `0, `< ` )0/( ` PdN*\R1*#222$*\Rffff*0H4e9015f7*\R1*#33b*\R1*#10d*\R1*#fc*\R1*#101*\R0*#f*\R0*#13*\R0*#10*\R0*#19*\R0*#1*\R0*#14*\R0*#f*\R0*#15$*\Rffff*0>4e90143f   4 *X $ . , , (@ 0h B >  0q(X(c`   NPhpxt(()ޝ4@xME<0> LLLL <%% +%+$@`0k` i  +`Zrns>`X@ hile`>```iles` iles+`t+i --i+` k i  'i@%i`$ivi t id@ H@ @ @H +x`/@ i @h '+ `o ##i v@h @ @ upda+B(` k` i !`x$%`v@d 8``b `` !`^ `\ !+D`  (  4@ Bx T  (8 :`G# 6+ '* (6+X 2   rC    '@6+ 0  8 @ HrFP >   4 BX T  (! :@!`!Gh!#! !6+!! !'!* "6+8"p"x" 2" "" """&" #  0# 'H#@`#6+# #  # # #4## >$  P$ 4h$ B$ T$ @% (`% :%%G%#% %6+%(& 0&'8&* P&6+&&& 2& '' '' '2 8' p'  '''@'6+'( ( ( ((0(8(P( >p( ( 8( F) XH) ) () :)*G*#0* H*6+P** *'** *6+*+ + 2(+ `+h+p+ x+++++ + L+B + ,  , 08, Fh, F, , - (- &8- `- ---)- <- > .H. P.X.`.x. .. .... L.B ///) /@/H/%P/&h/ 3/ $D/"/ // /0 00 0 (00080 P0X0`0 <h0 0 *0 $0 .1 ,H1 ,x1 (1 01 2B  2(202 *82h2p2 x2222222 *22223 3F}(3 p3 Fx3 3 3333 D4H4>P40 h4(e4&R44 4 ,4 T(5 5 5 H5 25 (6 $6 66 6 7 77 ,7H7P7X7p7 7F}7 7 F7 (8 0888@8`8 Dh88>80 8(e9&R(9P9 X9 ,`9 T9 9 : J: 2`: : $ ; H;`; h; p; , x;;j ; <(< 0<P<6 @=x= =6 p>> > > ^> ? (?0?d&8?? ? <? ? *@ $8@ .`@ ,@ ,@ (@ 0A HAB hApAxA *AAA AAAAA *A B B(B@B0oXB  BBDB B >B 0 C (e0C &RXC CC C C CC ,CCC0oD  @DHDDPD D >D 0 D (eD &RE 8E@E HE PE XEDxE6 EEF F ^FpF xFFd&FF F <G @G *XG $G .G ,G ,H (@H 0hH HB HHH *HIIII I &(IPIhIDI I >I 0 I (eJ &R@J hJpJ xJ J J ^JJ JKd&KpK xK <K K *K $L .0L ,`L ,L (L 0L MB 8M@MHM *PMMMMMM MMMDM @N >HN 0 `N (eN &RN NN N N O ^OhO pOxOd&OO O " O P P  P 28P<pP PPPP] ---- Summary ----.*** This function Validate Section 1 Data. *** $ Return Error Message True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----' '$ F $%^B@~]] Check for the UnitID'' $%^%v!d$x'$ $%^%v!(Please enter unit id.'FkH'']]]]]]('HCheck ineger/decimal 9 Months fields and Check for the Number of faculty b''''  '  Section1   $%^%v! $'$(The highlighted cell need to be updated.'   $%^%v!(Fd   $%^%v!   $%^%v!$'k8    $%^%v!$x   $%^%v!X'k   e   $%^%v!$x    $%^%v!X 'ry -k8 e   $%^%v!$x   $%^%v!X'k      e   $%^%v!$x    $%^%v!X 'Xk8k0" If (RetVal <> "") ThenJ Application.Worksheets(1).Cells(vRow, vCol).Value = RetVal End Ifk  '$  9-Month, Men,$'F  e '$ 9-Month, Women,$'Fk''ICheck ineger/decimal 12 Months fields and Check for the Number of faculty ''''  '  Section1   $%^%v! $'$(The highlighted cell need to be updated.'   $%^%v!(Fdx   $%^%v!   $%^%v!$'k    $%^%v!$x   $%^%v!X'k   e   $%^%v!$x    $%^%v!X 'k e   $%^%v!$x   $%^%v!X'k      e   $%^%v!$x    $%^%v!X 'kk" If (RetVal <> "") ThenJ Application.Worksheets(1).Cells(vRow, vCol).Value = RetVal End Ifkph  '$ 12-Month, Men,$'F  e'$ 12-Month, Women,$'FkCheck conversion fector $%^%v!$ $%^%v!$)  $%^%v!$ Please enter a conversion factor''$k GMsgBox "Please enter data in section 1.", vbOKOnly, "Validation Error."Please enter data in section 1.''$k@1If (((Val(Application.Worksheets(1).Cells(23, 2).Value) <> 0 Or Val(Application.Worksheets(1).Cells(23, 3).Value) <> 0) And (Val(Application.Worksheets(1).Cells(31, 2).Value) <> 0 Or Val(Application.Worksheets(1).Cells(31, 3).Value) <> 0)) And Val(Application.Worksheets(1).Cells(41, 11).Value) <= 0) Then0 ErroMsg = "Please enter a conversion factor" ValidateSection1Data = False3 'Application.Worksheets(1).Cells(41, 11).Select5ElseIf (((Val(Application.Worksheets(1).Cells(23, 7).Value) <> 0 Or Val(Application.Worksheets(1).Cells(23, 8).Value) <> 0) And (Val(Application.Worksheets(1).Cells(31, 7).Value) <> 0 Or Val(Application.Worksheets(1).Cells(31, 8).Value) <> 0)) And Val(Application.Worksheets(1).Cells(41, 11).Value) <= 0) Then0 ErroMsg = "Please enter a conversion factor" ValidateSection1Data = False3 'Application.Worksheets(1).Cells(41, 11).SelectEnd Ifp  $%^B@z@ 8 '$QUnhandled Error :Please contact with AAUP System administration with description: ! ' i J**** This function Retrun the error message for Section 1. ---- Summary ---- Row No,Month( String Error Message' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----@3Sum of tenure status columns does not equal total : '    Professor'  e  Associate'  e  Assistant'  e  Instructor'  e  Lecturer'  e  No Rank'k@ i8 **** This function is a Generic function get the cell value and Section and validate the cell value as per the Rule . ---- Summary ----J Column No./Row No./Sheet Name/Cell Value/Return Cell Value True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----' $x Section1           Conversion Fector   )k(allow integer only $x$ $x  $xX  $''Maximum of 10 digits allowed in a cell. A@.k ''kh  e   _'d8allow decimal and round the value to the nearest integer $x$- If (Len(CellValue) > 10) Then; CellValue = Mid(CStr(CellValue), 1, 10)N MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 $x. ] $x.$'$ ''Maximum of 10 digits allowed in a cell. A@.kd $x '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.khk`+---------------26/10/2010------------------ ''kkk Section2e              allow integer only $x$ $x  $xX  $''Maximum of 10 digits allowed in a cell. A@.k ''k            e8allow decimal and round the value to the nearest integer $x$- If (Len(CellValue) > 10) Then; CellValue = Mid(CStr(CellValue), 1, 10)N MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 $x. ] $x.$'$ ''Maximum of 10 digits allowed in a cell. A@.kd $x '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.kk+---------------26/10/2010------------------ ''k0k( Section3e     allow integer only $x$ $x  $xX  $''Maximum of 10 digits allowed in a cell. A@.k@ ''k(      e 8allow decimal and round the value to the nearest integer $x$- If (Len(CellValue) > 10) Then; CellValue = Mid(CStr(CellValue), 1, 10)N MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 $x. ] $x.$'$ ''Maximum of 10 digits allowed in a cell. A@.kd $x '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.k@k8+---------------26/10/2010------------------ ''kk Section4e      P  allow integer only $x$ $x  $xX  $''Maximum of 10 digits allowed in a cell. A@.k ''kk Section5e  8allow decimal and round the value to the nearest integer $x$1 If (Len(CellValue) > 10) Then? CellValue = Mid(CStr(CellValue), 1, 10)R MsgBox "Maximum of 10 digits allowed in a cell.", vbOKOnly End If" Changed By Akhilesh on 26/10/2010 $x. ] $x.$'$ ''Maximum of 10 digits allowed in a cell. A@.kpdh $x '&Mid(CStr(CellValue), 1, 10)'Maximum of 10 digits allowed in a cell. A@.kk+---------------26/10/2010------------------ ''kkkxdp'k`iXE**** This function Check if the cell value is Integer On Error Resume Next Dim cVal) If (InStr(1, intValue, ".") > 0) Then? MsgBox "Please enter only an integer value.", vbOKOnly? cVal = Mid(intValue, 1, (InStr(1, intValue, ".") - 1)) Else cVal = intValue End If IsInt = (cVal = CInt(cVal)) intValue = CInt(cVal)On Error GoTo 0`]` .  6MsgBox "Please enter only an integer value.", vbOKOnly '/Mid(intValue, 1, (InStr(1, intValue, ".") - 1))d 'k  X'  X'dh 'kXPiHE**** This function Check if the cell value is Decimal x] . ]] $X ' .  .$'$$X$X 'd$X'kd X'kd 'k  X' 'i5**** This function Validate Section 2 ---- Summary ----$ Return Error Message True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ---- 'B F#Application.Worksheets(2).Unprotect]]'']]]]]$Check ineger/decimal 9 Months fields''  '     $%^%v!$ '     $%^%v!$ e''k(  d  Section2   $%^%v! $'B $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fd & If (RetVal <> "") ThenN Application.Worksheets(2).Cells(vRow, vCol).Value = RetVal End IfkX A If (DataIn9Rank = True And DataIn9Undiff = True) Then, ValidateSection2Data = False~ ErroMsg = "Data can't be entered in 'Reporting by Rank' and 'Undifferentiated Rank' columns at the same time." GoTo ExitFunc: End Ifk ''%Check ineger/decimal 12 Months fields''  '     $%^%v!$ '     $%^%v!$ e''k  d  Section2   $%^%v! $'B $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fd& If (RetVal <> "") ThenN Application.Worksheets(2).Cells(vRow, vCol).Value = RetVal End IfkC If (DataIn12Rank = True And DataIn12Undiff = True) Then, ValidateSection2Data = False~ ErroMsg = "Data can't be entered in 'Reporting by Rank' and 'Undifferentiated Rank' columns at the same time." GoTo ExitFunc: End Ifk    'BbData can't be entered in 'Reporting by Rank' and 'Undifferentiated Rank' columns at the same time.'FkCheck conversion fector $%^%v!$ $%^%v!$ $%^%v!$ $%^%v!$)  $%^%v!$.Please enter a conversion factor in section 1.''B $%^%v!$ $%^%v!$ $%^%v!$ $%^%v!$)  $%^%v!$e.Please enter a conversion factor in section 1.''BkH@WApplication.Worksheets(2).Protect DrawingObjects:=True, contents:=True, Scenarios:=Truez 'BQUnhandled Error :Please contact with AAUP System administration with description: ! 'XiP5**** This function Validate Section 3 ---- Summary ----$ Return Error Message True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----('D F#Application.Worksheets(3).Unprotect]]'']]]$Check ineger/decimal 9 Months fields''      $%^%v!$ 'kh=  Section3   $%^%v! $'D $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fkp<h<`<''%Check ineger/decimal 12 Months fields     $%^%v!$ 'k;  Section2   $%^%v! $'D $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fk:::Check conversion fector  )  $%^%v!$.Please enter a conversion factor in section 1.''Dk99WApplication.Worksheets(3).Protect DrawingObjects:=True, contents:=True, Scenarios:=Truez9 9'DQUnhandled Error :Please contact with AAUP System administration with description: ! '9i95**** This function Validate Section 4 ---- Summary ----$ Return Error Message True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----'F F#Application.Worksheets(4).Unprotect]`]x'']Check ineger 9/12 Months fields O   Section4   $%^%v! $'F $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fk55x5p5WApplication.Worksheets(4).Protect DrawingObjects:=True, contents:=True, Scenarios:=Truez5 5'FQUnhandled Error :Please contact with AAUP System administration with description: ! '4i45**** This function Validate Section 5 ---- Summary ----$ Return Error Message True/False' Akhilesh Gautam% 8/15/2010% Akhilesh Gautam" 9/8/2010* Put the summary.---- End Summary ----'H F#Application.Worksheets(5).Unprotect]] '']8Check ineger/decimal    Section5   $%^%v! $'H $%^B@~(The highlighted cell need to be updated.'   $%^%v!( $%^B@Fk1110WApplication.Worksheets(5).Protect DrawingObjects:=True, contents:=True, Scenarios:=Truez0 0'HQUnhandled Error :Please contact with AAUP System administration with description: ! '0i0P RB@~ $(*Application.Undo+Selection.PasteSpecial Paste:=xlPasteValuesData copy/paste not allowed.  Paste Failed.A@. $(* RB@o//Attribute VB_Name = "CommonMethods" Public PastedRange As  '- Summar y &*** This function ValidaSe 1 Data. *0 Return Error MessageTrue/Fals# crefdBy>Akhilesh Gauta8m8/15/2010 up\(dž 9/8&&LU(>Put the s8.1z7?2Oƀ/NoOfFacultyMZFD CountoDAt"OneuIm= *'C<in!A/decimal 9 Month ields a\kANumber of f1 F@-DC17: R2@#)!= 0C1  FFdBcP2!11c 1KATNotSQ(v,"b, "Em", M).-, ) Za ly[ %TThigh&l`@ cg need to b` "" AKA3IsNull~/.^ae{iAC@H2:aa_@ lfCo?^Uq 4 Or 56  onh )#W A+ o7 o/R(9101 alue Xa` _(8@JA'i fLeJQՙ/*"*G( N`o S qU(DyM?SjjGetr'"9-,Pn,")dG' o^  tauaoß  Wome;  S2512 û3M_TiAP1t/dA%'e-_@1_m_ϟ %_se(A +"_ll__<_ȱ1_1> Else If (Application.Worksheets(1).Cells(vRow, vCol).Value <> "" And Not IsNull/)) Then AtleaseOnen= Tru E|If ; = 2ZTrimVz,[NoOfFacultyMBCInt3uax4 Orр;5 6rACountAB+ F[`F7@Ϳ)FKD;#<910 1_!_K_! ?a!As)d&D'efRet 9'?-=  TNext( )&MidateSecAA1Data@NFaErroMsgGetrD"12-Month, Men,"h+GoTo ExitFunc:Q;4_BWomd#.@4Check convers߄ f`(or ( ޷31, 3Oban?s(!8*)"s(4&1`ue= &0I{'"P" e@nter aactor"#?$=;2$*sy& '%Box @*@a in s* 1."`bOKOnly, "Dq r.  u1 'B_(23, Ï_!Soo""2%a-o)80?-?%%BM% f%"?J%"'Vke Sel$;uH(271:d oo2oooB?-?0??@:`/BP?ftf?ćK7$Y HfC Prot DrawingODbjs:=, Mt(Scenario3 lq rrDm*]th/Unhandled Ar : dVdt0 with AAUP System administrRdescrip!:" &.D7YResumex2 9 '*pis fzArun the er message for ԂU@X *@5- Summary 0 ,ٰAkhilesh Gautam8/15/2010pĸʳ܎t.Column No./#She"NaPme/C"V"/$Re@Pn GTr ue/FaAkhilesh GautaXm8/15/2010F  upBF 9/8DALastU>ʳa. ""GEbH= "DS1F!= BkbX= 4ld5h6h¥dBd1b1it!#!'ConverseFf org11 A7v.  A={C+'alli9 only @P (Is@=(*)G  Lenn x> 1e@= Mid(C A., 1@0)HMsgBox "Maximum of` digits bed in ab.", vbOKO` -$ P=B"R+P!i E$@3HF <;><< Zd=decimalrou'HAZtoXnearestB>8 z 4!DC!A ~ aLV":"'"tr>w"""""# ' Chang`'By bon 26/10[SsPIn/.6, ". J> 4پYʲ>?<0SSplits@5d(0@={0/K3?20N9z 'FOv)g,bc 'q8.Wue_OK ,πpw2΀(o[ 7\Z¾13X1 ʡ](|>^0ŦՏz9ۥ 10) Then |V = Mid(CStr, 10)zMsgBox "Maximum ofo digits allowed in a c.", vb@OKOnlyPEnd If ' ChangIBy Akhilesh on 26/10/2010"Inh!bTrim l"." ;Dim IntPart22Spli|t(423(0)DoTAE;jT l -  )Re>t"QF"@idateA Truk2e7A4vSheetName "Section3@iA Col2 AzvRo w@8< 25咥&'teg 4S< 17T5< 8O o(1#/p/p2s_piZp@*p8%%%% #r g^+ߎn5!= 2t3R @?s ?s?ser/ sqw)6!p@!sP/!ݦ!!!! `!_Ett5Ot?H If (Len(IntPart5(0)) > 10) Then CellValue = 0TMsgBox "Maximum of digits allowed in a cT.", vbOKOnlyqWEndElse/Trim(k 'Mid(CStr#, 10)>'M '- 26/10/2010 2RetES idate Truf*'Ft AFu nctio@ '*is f Check @if the veger * Priv1  Is (ByRefCAs Variant) Boolea!'On Error Resume Next'ADim cg@5AInin, "."]'EPse ent.o@ anA&2bm' 3Y- 1)`\"cm d 3"' (dC)af @ (GoToA*"**'*,* bd&„+ l mE+:+;= ).akk3qonqDecimalq$rdb$5r?GC*G q%aN B1%rounded|aag\lR(g 2a?g7! Split(M' ǒQ@q(1)b*> >= 5a0T)CDbl(+ ([$19-}97(x?)k%Is'= J a o0o0eGLi"r Sel 2j/b{ Summ0ary zU

ܰڲѱx/FaAkhilesh Gautam8/15rٰܱܳt..h,.Interior.Color = 255  Application.Worksheets(2).Protect Drawi ngObjs:=True, contScena GoTo ExitFunc: Else ' If (RetVal <> "") Then(8Cells(vRow,$ v).(ue.(End If R SQDataIn9Rank3) A Unpdiff `Hi`dateS2FaErrPoMsg"can't be ered in 'Report!n by A'' Ja%'C$er idcolumns at the same time."HMs EMONext C e10@fC'Check@0eger/decim12 Mhs fields >In12]JE]FD19 29w217}Ç%"@E| < 14HzK"@u() > 0 <*G> 15k#?.4hg> ois6 U=. G=-OrBx@215m$!eaaNot k(a7"m", 5 , C)5AzUnpc=` highl`t+cH ne toAupdyE_Gʡ 7 EJB${_#B@S b]A}xgEP?(ta TQeeeeeeeeRCAezyCoe)r(9JK 9??9 oooooo>s )3v@vHers for (( kc`17,YĔ)=0rY30)*5[1)p41` 2uP#<=zXPleas aѲXacts 1`O= :q$ }?ۻ6?#l7?? ?al? ?fer?? ?=PÑ6'dֿ־A qQRyurnR r Message𴡳/7Akhilesh Gautam8/15/2010Put the summary.  '- End S @ Public Function VHalidSe3Data(ByRef ErroMsg As St ring)Boolean 9 = True  On>r GoTo :App{aw.Worksheets(3).Unprot Dim vRowkIntegerCol  = 0RetNhInRank^ Undiff 'Check in>/decimal 9 Months fields/In9 |Fals}*D12 Fork=$14 s ^2   I(f (c(Cells(A, v ). ue) > 0) TheiA&F,jIfC%Not;(Ah, """, (, Ci))@1NGX,Ȕ E= "G@ highlted c@S ne@to be ud."DcA`rior.g=P 255eP Draw@Objs:=Am, c`QentSceNex8t Skb12bH]19aZ2]]+]Inp]] 2]2).]I]e;]]rR]u]]$]  ][@jversuf@moR ~A LRu1ED41, 1dX.<` 7Pse er a~act@Ein s; a 1J`T= $je? E7A'yGHHAd PrrDH ta/Unhandl +Ar : with AAUP System admi`nistr2d@escripA:" &.D7sSRe`e 2 gS'*pvi@ < 4 *K' ܰѱ</ L/Akhilesh Gauta8m8/15/201>0VbrSpTI藍› hBol>looɯl).nosts(TToon#oeMW^6/ / / & A^ ^S^p^^p`^r^^ 1^\^v^5^L^rp|^ ^se^rns> ' Akhilesh Gautam8/15/2010J,NupdD2N79/8M"LLastUP>Put the summary.@`= 255b0P DrawObjs:=, contScena ãxitAD!eIfcNext E'_eY r rr?@9Unh0andl7r $:Puseb$act with AAUP System admin0istrrde script:"d &w.Dg$Re e #bSub P@onlyues () A veS i,EnabpleEva'^0Undo`}Sel`BE . eSp}ale:=xl c Box "@#py/pe n`|allo we@]`tbOKO@{ Fa@¢`C{C* ( __SRP_a8__SRP_b,l4Sheet9u~__SRP_8) tMd@T T !5TV'tMd@T T4(D ]t5TA@tMd@T ($ TKF4 "`1t6 TT4$+''$'4:d#NTT $6T4$ ltFd0pzk k kkpz tMd@T T %5T:tMd@T T:D&4(]t6T4GtMd@T :D&N44T$ '$/6T4#(d%T4( ]t5T 1t+''$'4:d#NTT $6T4$'tMd@T T4(D ]t5T 1t+''$'4:d#NTT $6T4$ ltFd0pz (0Ck k k k k k k kk! tMd@T T !5T'tMd@T T4(D ]t5T@tMd@T ($ TKF4 "`1t6 TT4$+''$'4:d#NTT $6T4$ ltFd0pzCk k k k k k k kk tMd@T T %5T:rU~|  7!yI'i# ,)/, -Y--..Y))++ $A! y$!9%%I&& 00)1i111!2)35TpzK>\(`%pt$ t p d\)tp\pZpXq(H%((%\(`%pt$ t p d\= : ]3)tp\6Cpzc(%(H%((%\(`%pt$ t p d\= C )tp\6  1 FpZpXpZcppppX c5 :` Z@X@\(`%pt$ t p d\A CkZkX 2)tp\6pz 1 e((%Z@X@\(`%pt$ t p d\= C )tp\6F)Z@X@\(`%pt$ t p d\A :( ]<Z@X@(%$   d=p `'P) tp\6 p`xp kX]sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6X`Z@X@\(`%pt$ t p d\A Ep)tp\6'kXkXkXRsZ@X@\(`%pt$ t p d\=  :( ]@)tp\6MdkZ@X@\(`%pt$ t p d\A Ep)tp\6' kX5sZ@X@\(`%pt$ t p d\=  :( ]@)tp\60`Z@X@\(`%pt$ t p d\A Ep)tp\6'kX kX kX 'sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6%dkZ@X@\(`%pt$ t p d\A Ep)tp\6 Xd kkbpzkZ ' F kkpzkZ ' F ZdipZpXZcL ppppX cH :` Z@X@\(`%pt$ t p d\A CkZkX 2)tp\6pz 1 e((%Z@X@\(`%pt$ t p d\= C )tp\6Fu Z@X@\(`%pt$ t p d\A :( ]<Z@X@(%$   d=p `'P) tp\6 p` p kX sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6 `Z@X@\(`%pt$ t p d\A Ep)tp\6s kXkXkX sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6 dkZ@X@\(`%pt$ t p d\A Ep)tp\6s kX sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6| `Z@X@\(`%pt$ t p d\A Ep)tp\6s kX kX kX s sZ@X@\(`%pt$ t p d\=  :( ]@)tp\6q dkZ@X@\(`%pt$ t p d\A Ep)tp\6 XdH kk pzkZ ' F kk pzkZ ' F ZdL(H%((%\(`%pt$ t p d\A (%(8%(%$   dA ()%( % (% $$ $  d pAP 2)tp\$ 6 pP' 1 pz kD 1 pzRcH%c(%c%\(`%pt$ t p d\ )tp\pz& tt , l*' /t FR(|Ttp\$  pP3lCt -lt*1xk k 5 lx.*1xk k V lx/*1xk k w lx0*1xk k  lx1*1xk k  lx2*1xk k  lx3*1x ,xt `  lCtpz#tMd@T T:D ]@5T 08(%<@$ @ < d8)@<8 1 e(%x@v@8(%<@$ @ < d8= C )@<86Rc(%c%c%8(%<@$ @ < d8 )@<8  vdTH xdX9pxpvp^p\xcHvc> :D d}kvk^x@v@8(%<@$ @ < d8A /)@<86p^}kvk\x@v@8(%<@$ @ < d8A /)@<86p\z5kvkv2x@v@8(%<@$ @ < d8A d(Ckxkv 2)@<86.pz>8(%<@$ @ < d8)@<8 1 e(%x@v@8(%<@$ @ < d8= C )@<86Rc(%c%c%8(%<@$ @ < d8 )@<8 0 vde xdV kbk^k`k\}pz 61  ((%(%8(%<@$ @ < d8A (%(|%(%$   d\AL ( %(%0(4%DH$ H D d0A (%(%(%$   d`AP L ( )%( %0(4%DH$ H D d0A 2 L)@<8HD0HD06\L`P 41 pz ((%(%8(%<@$ @ < d8A (%(|%(%$   d\AL ( %(%0(4%DH$ H D d0A (%(%(%$   d`AP L ( )%( %0(4%DH$ H D d0A 2 L)@<8HD0HD06\L`P 41 pzpz& @@ , l*' /@  (dL@<8HD0HD0\L`PpzKbpxpv f@P f@0 xc,nvc(dox@v@(@% $$ $  dA /)$ 6 c@Px@v@(@% $$ $  dA d)Ckxkv 2)$ 6Xpz>(@% $$ $  d)$  1 e(%x@v@(@% $$ $  d= C )$ 6Rc %c%c%(@% $$ $  d )$ _ vd(N xd,?pxpvxcvcox@v@(@% $$ $  dA /)$ 6 c@0x@v@(@% $$ $  dA d(Ckxkv 2)$ 6pz>(@% $$ $  d)$  1 e(%x@v@(@% $$ $  d= C )$ 6Rc %c%c%(@% $$ $  d )$ _ vd xdPc@]/0c ]/'|()%( %(% $$ $  dlA\ L'</)$ 6l\L] 41 pzpz& $$ , l*' /$ _@00Pd8 $ |l\<lpzKpxpvxOc`vc\x@v@@(D%TX$ X T d@A d*C  kxkv 2 )XT@6pz>@(D%TX$ X T d@)XT@ 1 e(%x@v@@(D%TX$ X T d@= C )XT@6Rc0%c%c%@(D%TX$ X T d@ )XT@ vd\: xd`+pz& XX , l *' / X  (d( XT@lpzKpxpvx c`vc\x@v@@(D%TX$ X T d@A d+C  kxkv 2 )XT@6pz>@(D%TX$ X T d@)XT@ 1 e(%x@v@@(D%TX$ X T d@= C )XT@6Rc0%c%c%@(D%TX$ X T d@ )XT@ vd\: xd`+pz& XX , l *' / X  (d( XT@0 P   >I/(! `i/(I `0(q `0( `0( `0$ `n<jxN#<ש@j[ FzPDy{NQ4"lxzPDy{NQ4"lש@j[ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@\\0dN$*\Rffff*0G4e9014414xAttribute VB_Name = "She@et9" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU H!iI49`rU @nK0* pHd VBAProject4@j = r dN J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\syst em32\e2.__SRP_9+(B_VBA_PROJECT"dirO__SRP_0*%1<]GKJT@lG;a2./AnNL`K?O@[o8 N{*dթ0J!@#:zOe `Fҫq2ӘwMMג<{|(J1PzCWB!g>enJ@@;: @هJ Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`OfficeuMSFormsC MSComctlLibm ThisWorkbook| _Evaluate WelcomePage8sWorkbook_ActivategWorkbook_BeforeCloseCancel EnableControl Application*OnKeyPCellDragAndDrop EnableEventsSaveddMsgBoxR vbYesNoCancelq vbExclamationvbYesa? CustomSavevbNo%vbCancel'Workbook_BeforeSave lSaveAsUIWorkbook_Deactivate4 Workbook_OpenScreenUpdating!  ShowAllSheetsSaveAsf;ws_ WorksheetaWsunewFname. ActiveSheet%N HideAllSheetsGetSaveAsFilename fileFilterSaveActivate| WorksheetsVisiblexlSheetVisiblexlSheetVeryHiddenId]Enabled۪ Sheet1 ShouldRunCommandButton1_Click( DeActiveProgressBar)Worksheet_Activate+oldValmCellsTrim@Year6nNow% Unprotect?ProtectfDrawingObjectsߺcontents= ScenarioskWorksheet_ChangeSTargetFRange vTargetCellColumnGvTargetCellRowzColumniRowInterior;Color2FvbWhite^KisValid@N CellValue@RetValueTAddressValueK SelectionZvbOKOnlyLEnd| ValidateCelltVal valofCell}vCol"+vRowc{ vSheetNameqRoundIsIntL IsDecimalIntPartSplit)IntPart1P9intValuecValdblValueDval1 roundedValT Sheet2RetSec1<Rang CheckForUndefinedRank. ClearContents{RetSecM,i`ansxt vbOKCancelx?ans1=/ans2>/ans3?/ Sheet3 Sheet4 Sheet5 Sheet6 Sheet7 Sheet8 frmLogin=cmdLogin_ClickfErr txtUsernameIsNulllblErrorsCaptionx txtPassword, ( vUsernameW ( vPasswordHide9zExitSub*Erro Description  vbCritical+}CommandButton2_Click( OutError@UserForm_ActivateZs SheetCommandu( isRanked ( ErrorCode0e ( UploadErrorg( ValidateSection1_ClickFVErrorvErrI6( ValidateSection1DataT ExitMethodo( UploadData_Click'TextBox1SmexMonikerStringN&addrLabel4, ForeColorvbRedG/ UploadAgain( ActiveProgressBar ProgressBar1vHeight|Label1, vbInformationn( ValidateSection2Data"r( ValidateSection3Data( ValidateSection4Data( ValidateSection5Data'vUserid)"vYear1Label2,ShowvbModaltservice1z Interaction GetObjectzRecheckhValidateExcelUploadxLabel3,sxml J GetXMLStringYUploadExcelDatabvba  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.6#0#C:\Program Files\Microsoft Office\Office12\EXCEL.EXE#Microsoft Excel 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation(*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.4#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL#Microsoft Office 12.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\Windows\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{20876330-4B4F-41C5-88BE-26F8944EED59}#2.0#0#C:\Users\Francis\AppData\Local\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0#C:\Windows\system32\MSCOMCTL.OCX#Microsoft Windows Common Controls 6.0 (SP6)0*\G{FB75446F-9C90-43B5-A1E5-C8B8BC1290E0}#2.0#0#C:\Users\Francis\AppData\Local\Temp\Excel8.0\MSComctlLib.exd#Microsoft Windows Common Controls 6.0 (SP6)\ uM   dN     ThisWorkbook0E4e901441ThisWorkbookK, Sheet10F4e901441k Sheet14 Sheet2014ebe49c4 Sheet20A Sheet3024ebe49c5 Sheet3H%' Sheet4034ebe49c6 Sheet4`$ Sheet5044ebe49c8 Sheet5hx" Sheet6074e90143f Sheet6,- Sheet7084e90143f Sheet7Q- Sheet8094e90143f Sheet8K-frmLogin014ecf53ddfrmLogin:SheetCommand0>4e90143fSheetCommand{CommonMethods0H4e9015f7CommonMethods4@ Sheet90G4e901441 Sheet9N @` H0x(vRJn~lɾv ?POvח#Green_vbYesNo errmessageBNumber-( ValidateSection2_Click( ValidateSection3_Click?( ValidateSection4_Click9( ValidateSection5_ClickIGetXMLForInstitute4GetXMLForSection1?GetXMLForSection2@GetXMLForSection3AGetXMLForSection4BGetXMLForSection5CFErrorDataRow |ReplacefFExitCheckAtleastOnepFoundMen FoundWomenܯFound9yFound12vvFaculty}IsAdded{RefreshvbBlack CommonMethodsZ ( PastedRangeErroMsg?ExitFuncRetVal; NoOfFacultyM NoOfFacultyF FacultyCountM. FacultyCountF'AtleaseOneValueA GetErrorMsgniRowqforMonthUIntPart2Q9IntPart3R9IntPart5T9 DataIn9Rank/ DataIn9Undiff DataIn12RankDataIn12Undiff/ DataInRankl DataInUndiff$C DataIn9Month8 DataIn12Month%( PastonlyValues Sheet9Workbookk BeforeClose~; BeforeSave Deactivatej_DefaultjChange _B_var_TrimmT_B_var_isValidCB _B_var_Midp_B_var_DataIn9Month_B_var_DataIn12MonthUserFormNcmdLoginCommandButton2}Click _B_var_Format '     k  #(A tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE12\MSO.0DLL#M 1q Ob Li`braryKMSFor ms>SFrms$3D452EE1-E0D8F`A-8-02608C4D0BB4SFM20L'B &/;"1jIqAHq00}#0Bq# 50 A2087634B4F-41C5-88BE-26F8944EED596Users\Francis\AppData\Local\Temp\Exc`el8.0d8.xexde=@#.E .`M H @MSctl@p>j*ChmtLhibl|5831FDD16-0C5C-11D@2-A9FCBNF8754DA1lOMCTL.O,CX/ RControls 6.0 (SP6)7870%dFB46F-9C90-4@3B5-A1lC8B8BC1290EE`Nc~9g9/9!@@\ PuM;" D"ThisWorkb@ookG`TiqW=rkEEL"NLCheckForUndefinedRank D Section2 9undiff P6:Q16 RangeClearContents P19:Q29 9rank B6:M16 B19:M29 12undiff 12rank *Please enter unit id. x   aB)Ihd٘'dK.x&h Section3=^ʴf?BPKʜԡJ?flC Section4ȶdtr Lr=Mk1EB? Section5 0   ^c ^v +{DEL} +{INSERT}TextCommandButton2 ZDo you want to save the changes you made to ' '? ^Section 1 data has been successfully validated.* Unhandled Error :Please contact with AAUP System administration with description:fĤIx8< Unhandled Error  PThe highlighted cell need to be updated. 9-Month, Men, 9-Month, Women, K*         rU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~e m%K4GXB   a Y !Q 1a Q1i1a i!i11!)a i!i1Aa i!i1Ya i!i1q   a DaDDDa Y Y 1 i 9 i ) a x q19qa YA   VBAProject ThisWorkbookSheet1Sheet2Sheet3Sheet4Sheet5Sheet6Sheet7Sheet8frmLogin SheetCommand CommonMethodsSheet9F /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA Y 0F4C:\Program Files\Microsoft Office\Office12\EXCEL.EXEExcel Qy@0FC:\Windows\system32\stdole2.tlbstdole aPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLLOffice Ai`.E .`M C:\Windows\system32\FM20.DLLMSForms aap0c OKA&NY8C:\Users\Francis\AppData\Local\Temp\Excel8.0\MSForms.exd Aai\ uM  C:\Windows\system32\MSCOMCTL.OCX MSComctlLib aaoDuCȸ<C:\Users\Francis\AppData\Local\Temp\Excel8.0\MSComctlLib.exd Q ay ValidateSection1_ClickUploadData_ClickValidateSection2_ClickValidateSection3_ClickValidateSection4_ClickValidateSection5_Click GetXMLStringGetXMLForInstituteGetXMLForSection1GetXMLForSection5GetXMLForSection4GetXMLForSection3GetXMLForSection2ActiveProgressBarDeActiveProgressBar @ , MacrosFL9L8sVUFqq~L^ő.A DFWorkbookWorkbook_ActivateWorkbook_BeforeCloseWorkbook_BeforeSaveWorkbook_Deactivate Workbook_Open CustomSave HideAllSheets ShowAllSheets EnableControl @FFFVisible SelectoD@;@':I FJ7)JË˻l"-?@Label4#-?@Label3Label2!:5j(6( ProgressBar1":12-Month, Men, 12-Month, Women, @Please enter a conversion factor >Please enter data in section 1. 0  txtPassword{lFWJOcmdLogin fSum of tenure status columns does not equal total :  Professor  Associate  Assistant  Instructor  Lecturer  No Rank ^Section 3 data has been successfully validated. \Please enter a conversion factor in section 1. ^Section 4 data has been successfully validated. ^Section 5 data has been successfully validated.3 Data can't be entered in 'Reporting by Rank' and 'Undifferentiated Rank' columns at the same time. Height Label1 C8f Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from undifferentiated rank column first, or do not enter data in the columns by rank.TextBox1 Label4ForeColorProgressBar1b Section 2: There are data entries in both the rank and undifferentiated columns. Please either clear incorrect data from rank columns first, or do not enter data in the undifferentiated column. ^Section 2 data has been successfully validated.! ~Validation failed. Please rerun the validation for each section "Validation Failed" Validation failed. Please rerun the validation for each section.Caption Label2+뵃F,m P(TIE$hc1mDWWI]6J@sL(dK2u(CU夈  txtUsername!-6S` lblError  HcmdLogin_ClickCommandButton2_ClickUserForm_Activate `# service:mexAddress='https://research.aaup.org/ExcelService.svc/mex' l, address='https://research.aaup.org/ExcelService.svc' . Last Update date/time  ,MM/dd/yyyy hh:mm AM/PM( , binding=WSHttpBinding_IExcelService, bindingNamespace='http://tempuri.org/'" , contract=IExcelService, contractNamespace='http://tempuri.org/' &ValidateExcelUpload Label3UploadExcelData $Data Upload Status Status :  @CF Unit Id Error $Primary User Error Survey Error .Review & Sign off Error 6Survey Already Exists Error" Data have already been uploaded, would you like to upload again? AAUP   <SurveyData>   hDisconnected internet connection / Down web service. RPassing invalid parameters to web method. 2Authenticating user fail. (Gathering data fail. (Uploading data fail. r X 4 x @Email :Validating all sections data. (Authenticating user. "Gathering data .. "Uploading data ..Refresh $Unhandled Error :  AAUP Error. LUser Name is required to authenticate. JPassword is required to authenticate. @Phone </SurveyData>d <institute><unitid>@Uid</unitid><institution>@Inst</institution><respondentName>@RName</respondentName><Phone>@Phone</Phone><email>@Email</email><conversionfactor>@CF</conversionfactor></institute> @Uid @Inst @RName   @Rank @facultyOn 9Month @gender Men @nooffaculty @totalsalary @notTenure @onTenure @Tenured Women 12Month (@noofcontinueFaculty "@salaryCurrenyear  <section1><rank>@Rank</rank><facultyOn>@facultyOn</facultyOn><gender>@gender</gender><nooffaculty>@nooffaculty</nooffaculty><totalsalary>@totalsalary</totalsalary><notTenure>@notTenure</notTenure><onTenure>@onTenure</onTenure><Tenured>@Tenured</Tenured></section1>P 8<section2><rank>@Rank</rank><facultyOn>@facultyOn</facultyOn><benefit>@benefit</benefit><totalExp>@totalExp</totalExp><noofCov>@noofCov</noofCov></section2> 1 @benefit @totalExp @noofCov 2 3 4 5 6 7 <section3><rank>@Rank</rank><facultyOn>@facultyOn</facultyOn><noofcontinueFaculty>@noofcontinueFaculty</noofcontinueFaculty><salaryCurrenyear>@salaryCurrenyear</salaryCurrenyear><salaryPreviousYear>@salaryPreviousYear</salaryPreviousYear></section3> &@salaryPreviousYearJ <section4><rank>@Rank</rank><facultyOn>@facultyOn</facultyOn><salaryintervals>@salaryintervals</salaryintervals><value>@value</value></section4> @salaryintervals @value2 <section5><rank>@Rank</rank><basic>@basic</basic><supplement>@supplement</supplement></section5> @basic @supplement>__SRP_1frmLogin 63@Je$`e$fo24  ( 8 YH ProgressBar1  XLabel2 hTextBox1  xLabel1Label3Label4 TargetvColvRow vSheetName CellValueRetValueintValuedblValueErroMsgiRowforMonthRetSec 7 7 7/ Do$   }2R KQDBTahomad(2Label1rd{{d(RPlease enter your user name and password used to login to AAUP Survey Application.!/(@Microsoft Sans SerifH,0{5TahomaH,*1{5Tahoma( User NameiE5Tahoma(PasswordE5Tahomard(LoginardENuTahomard(CancelrdENuTahomard!&5Tahomard( 4txtUsername ( 8txtPassword: (2<Label2rd (28Label3rd: $8cmdLogin],8CommandButton2O](20lblErrorq Microsoft Forms 2.0 FormEmbedded Object9qVERSION 5.00 Begin {C62A69F0-16DC-11CE-9E98-00AA00574A4F} frmLogin Caption = "Login to AAUP Survey" ClientHeight = 3420 ClientLeft = 45 ClientTop = 435 ClientWidth = 7350 StartUpPosition = 1 CompObj5aVBFrame.PROJECTwmRPROJECT'CenterOwner TypeInfoVer = 12 End ThisWorkbookThisWorkbookSheet1Sheet1Sheet2Sheet2Sheet3Sheet3Sheet4Sheet4Sheet5Sheet5Sheet6Sheet6Sheet7Sheet7Sheet8Sheet8SheetCommandSheetCommandCommonMethodsCommonMethodsSheet9Sheet9frmLoginfrmLoginID="{00000000-0000-0000-0000-000000000000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet2/&H00000000 Document=Sheet3/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Document=Sheet6/&H00000000 Document=Sheet7/&H00000000 Document=Sheet8/&H00000000 Module=SheetCommand Module=CommonMethods Document=Sheet9/&H00000000 Package={AC9F2F90-E877-11CE-9F68-00AA00574A4F} BaseClass=frmLogin HelpFile="" Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="0B09A79DCBA1CBA1CEA6CEA6" DPB="33319FF5DA12DA1225EEDB1226DB68868F7F5A2289A94E1D1E0A250159D82E21A36DFD80A8" GC="5B59F72D1E2E1E2E1E" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=0, 0, 0, 0, C Sheet2=0, 0, 0, 0, C Sheet3=0, 0, 0, 0, C Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C Sheet6=0, 0, 0, 0, C Sheet7=0, 0, 0, 0, C Sheet8=0, 0, 0, 0, C SheetCommand=0, 0, 0, 0, C CommonMethods=0, 0, 0, 0, C Sheet9=0, 0, 0, 0, C frmLogin=0, 0, 0, 0, C, 23, 23, 984, 678, C Oh+'0HP`p A.A.U.PFrancisMicrosoft Excel@@a@a@4%$՜.+,D՜.+, X`p SummaryInformation(9DocumentSummaryInformation8XCompObj r A.A.U.P Published Macros'Section 2 (Est.)'!Print_Area'Section 3 (Est.)'!Print_AreaSection1!Print_AreaSection2!Print_AreaSection3!Print_AreaSection4!Print_Area'Validity Checks'!Print_Area  Worksheets Named RangesP 4<_Status Not Started F&Microsoft Office Excel 2003 WorksheetBiff8Excel.Sheet.89q