ࡱ> MPL  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKOQRSTUrWXYZ[\]^_`abcdefghijklmnopqNstuvwxyz{|}~Root Entry Fx: ]IWorkbookC_VBA_PROJECT_CUR"0˹VBA0˹v f2ـ\pUser Ba= -B0=830=ii']8@"1Tahoma1Tahoma1Tahoma1Tahoma1Tahoma1Tahoma1Tahoma1Tahoma1Arial1Tahoma1Tahoma1Calibri1.Times New Roman1Tahoma1Tahoma1̂Calibri1 ̂Calibri1>̂Calibri1?̂Calibri14̂Calibri1,8̂Calibri18̂Calibri18̂Calibri1̂Calibri1 ̂Calibri1h8̂Cambria1<̂Calibri1̂Calibri1̂Calibri14̂Calibri1 ̂Calibri1̂Calibri/#,##0"@.";\-#,##0"@."9#,##0"@.";[Red]\-#,##0"@.";#,##0.00"@.";\-#,##0.00"@."E #,##0.00"@.";[Red]\-#,##0.00"@."k*3_-* #,##0"@."_-;\-* #,##0"@."_-;_-* "-""@."_-;_-@_-k)3_-* #,##0_@_._-;\-* #,##0_@_._-;_-* "-"_@_._-;_-@_-{,;_-* #,##0.00"@."_-;\-* #,##0.00"@."_-;_-* "-"??"@."_-;_-@_-{+;_-* #,##0.00_@_._-;\-* #,##0.00_@_._-;_-* "-"??_@_._-;_-@_-3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_->_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_- ##,### ##,##0.00                                                                        , -  P  P     a>  ff                 `  * +     @ @  Z@ @  @ @ 8@ @ 8@ @   @ @  @ @  Z@ @ Z@   @ @   ""@ @  @ @8@ 88@ @  8@ @ 8@ 8@ @  x@ @ : x@ @: 8@ @  8@ @  8@ @  8@ @  0@ @  0@ @  0@ @  0@ @  8@ @  8@  0@ @   @ @   @   @   @  ||eqL}A} _ _-ef#0.0}A} _ _-ef#0.0}A} _ _-ef#0.0}A} _ _-ef#0.0}A} _ _-ef#0.0}A} _ _-ef #0.0}A} _ _-L#0.0}A} _ _-L#0.0}A} _ _-L#0.0}A} _ _-L#0.0}A} _ _-L#0.0}A} _ _-L #0.0}A} _ _-23#0.0}A} _ _-23#0.0}A} _ _-23#0.0}A} _ _-23#0.0}A}  _ _-23#0.0}A}! _ _-23 #0.0}A}" _ _-#0.0}A}# _ _-#0.0}A}$ _ _-#0.0}A}% _ _-#0.0}A}& _ _-#0.0}A}' _ _- #0.0}}( ??v_ _-̙#0.0-;_-?\ _ @_-@ }}) ???_ _-#0.0???-;_-????\ _ ???@_-@ ???}}* }_ _-#0.0-;_-?\ _ @_-@ }A}- _ _-#0.0}A}. _ _-?#0.0}A}/ _ _-23#0.0}-}0 _ _-}U}1 _ _-#0.0-;_-}}2 _ _-#0.0???-;_-????\ _ ???@_-@ ???}-}3 _ _-}A}4 e_ _-#0.0}A}9 _ _-#0.0}-}: _ _-}x};_ _-#0???-; ????\ ???@_}A}= }_ _-#0}-}> _ _-}A}A a_ _-#0}(}T_ _-}(}U_ _- 20% - :F5=B1M 20% - :F5=B1 ef % 20% - :F5=B2M" 20% - :F5=B2 ef % 20% - :F5=B3M& 20% - :F5=B3 ef % 20% - :F5=B4M* 20% - :F5=B4 ef % 20% - :F5=B5M. 20% - :F5=B5 ef % 20% - :F5=B6M2 20% - :F5=B6  ef % 40% - :F5=B1M 40% - :F5=B1 L % 40% - :F5=B2M# 40% - :F5=B2 L渷 % 40% - :F5=B3M' 40% - :F5=B3 L % 40% - :F5=B4M+ 40% - :F5=B4 L % 40% - :F5=B5M/ 40% - :F5=B5 L % 40% - :F5=B6M3 40% - :F5=B6  Lմ % 60% - :F5=B1M 60% - :F5=B1 23 % 60% - :F5=B2M$ 60% - :F5=B2 23ږ % 60% - :F5=B3M( 60% - :F5=B3 23כ % 60% - :F5=B4M, 60% - :F5=B4 23 % 60% - :F5=B5M0 60% - :F5=B5 23 %! 60% - :F5=B6M4 60% - :F5=B6  23 %":F5=B1A:F5=B1 O %#:F5=B2A!:F5=B2 PM %$:F5=B3A%:F5=B3 Y %%:F5=B4A):F5=B4 d %&:F5=B5A-:F5=B5 K %':F5=B6A1:F5=B6  F %(2>4 u2>4  ̙ ??v% )K2>4uK2>4  ???%????????? ???* KG8A;5=85 KG8A;5=85  }% +&5=56=K9,. 5=56=K9 [0]- 03>;>2>: 1K 03>;>2>: 1 I}%O. 03>;>2>: 2K 03>;>2>: 2 I}%?/ 03>;>2>: 3K 03>;>2>: 3 I}%230 03>;>2>: 4= 03>;>2>: 4 I}% 1B>3KB>3 %OO)2>=B@>;L=0O OG59:0>=B@>;L=0O OG59:0  %????????? ???30720=8570720=85 I}%4 59B@0;L=K9I 59B@0;L=K9  e%$1KG=K95 1KG=K9 2( 1KG=K9 26 1KG=K9 3( 1KG=K9 37 1KG=K9 4( 1KG=K9 48 1KG=K9 59;>E>9?;>E>9  %: >OA=5=8595 >OA=5=85 %; @8<5G0=85n @8<5G0=85  <* @>F5=B=K9%=!2O70==0O OG59:0U!2O70==0O OG59:0 }%->"5:AB ?@54C?@5645=8OO "5:AB ?@54C?@5645=8O %?* $8=0=A>2K9@2$8=0=A>2K9 [0]A%>@>H89A%>@>H89  a%XTableStyleMedium2PivotStyleLight16`=@0D8: Start8|12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152V5A!5=BO1@L29 - 5:BO1@L27 - 2>O1@L5:01@L29 - 4/=20@L26 - 1$52@0;L23 - 10@B30 - 5?@5;L27 - 309N=LN;L27 -223CAB'8A;01 - 78 - 1415 - 2122 - 286 - 1213 - 1920 - 263 - 910 - 1617 - 2324 - 305 - 1112 - 1819 - 252 - 89 - 1516 - 2223 - 294 - 1011 - 1718 - 2425 - 3124 - 3154=I-IIIIIIVVI1@07>20B5;L=0O ?>43>B>2:0@0:B8:0 (@0AA@54.)0CG=K5 8AA;54>20=8O (@0AA@54.)0=8:C;K#A;>2=K5 >1>7=0G5=8O: -:70<5=K y0;5=40@=K9 CG51=K9 3@0D8: ?> =0?@02;5=8N 44.06.01 ?@>D8;L ""5>@8O 8 <5B>48:0 ?@>D5AA8>=0;L=>3> >1@07>20=8O", >G=0O D>@<0=?0CG=K5 8AA;54>20=8O@0:B8:0>43>B>2:0 : A40G5 8 A40G0 -@54AB02;5=85 =0CG=>3> 4>:;0406 6,7S97{a7777,N888>H999L: <Ncc>BOUj_ KU f2ـ (Kuv  dMbP?_*+%A&?'?(?)?M \\b00f03r313w04\Canon MF4010 S, G 4dXA4Canonp  1`>Canon MF4010 Series UFRII LT{ddd      d d d d d dd@@d  d  d dd d"eddd      !"#d"    @  !"#$%&'()*+,-d.d/d012345678d     ddd !"#$%&'()*+,-./01234d!ddd d!    d  @8 4 2<^ 1 4 2<^ 1XXd2 Arial Cyr\CNZ005.ICC\CNZ005.ICC\CNZ005.ICC$&,$&,HArial Cyr0AB@-:8 ?> C<>;G. X   " dX333333?333333?&43U} } 4U} 5(55@5w@5X@5@5`5`5`5@ 5@  5@  5@  5@  5@  5@ 5@ 5@ 5`5`5`5`5`5`5`5`5`5@5@5@5Y@5Y@5Y@5Y@ HtnHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHHH4 C6 I7 III J8 I9 II  J:  I;  III I< III J= I> II J? I@ II JA IB III JC  ID !II" #JE $IF %III' (IG )III+ ,J8 -IH .II/ 0JI 1IJ 2III4 CK DL DM DN DOK DP DQ DR K  DS  DT  DU  DV DL DM DN DOK DW DX DYK DZ D[ D\K DZ D[ D\ D]K  DP !DQ "DR#K $D^ %D_ &D` 'Da (DL )DM *DN +DO,K -DP .DQ /DR0K 1DS 2DT 3DU 4Db Cc C C C C C C C C  C  C  C  C  C C C C C C C C C C C C C C C C C C C  C !C "C! #C" $C# %C$ &C% 'C& (C' )C( *C) +C* ,C+ -C, .C- /C. 0C/ 1C0 2C1 3C2 4C3pCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4I Ld Ld Ld Ld Ld Ld Ld Ld  Ld  Ld  Ld  Ld  Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld  Ld !Ld "Ld #Ld $Ld %Ld &Ld 'Ld (Ld )Ld *Ld +Ld ,Ld -Ld .Ld /Ld 0Ld 1Ld 2Ld 3Ld 4LdpILLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL4pCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4 Ie Mf Lf Lf Lf Fu Fu Fu Fu  Fu  Fu  Fu  Fu  Fu Fu Fu Fu Fu Fu Fu Lg L5 Nu Nu Nu Nu Nu Nu Nu Nu Nu Nu  Nu !Nu "Lg #Lg $Lg %Lg &Lf 'Lf (Lf )Lf *Lf +Lf ,Lf -Lf .L5 /L5 0L5 1L5 2L5 3L5 4L5p IMLLLGGGGGGGGGGGGGGGLLOOOOOOOOOOOOLLLLLLLLLLLLLLLLLLL4p CCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4 Ih Mf Lf Lf Lf Cf Lf Cf Lf Cf Lf Cf Lf Cf Lf Cf Lf Cf Lf Cf Lg L5 Lf Lf Lf Lf Cf Cf Cf Cf Cf Cf Cf !Cf "Cf #Cf $Cf %Cf &Cf 'Cf (Cf )Cf *Lg +Lf ,Lf -Lf .L5 /L5 0L5 1L5 2L5 3L5 4L5 IMLLL Fu L Fu L Fu L Fu L Fu L Fu L Fu L Fu LLLLLL Fu Fu Fu Fu Fu Fu Fu !Fu "Fu #Fu $Fu %Fu &Fu 'Fu (Fu )Fu *LLLLLLLLLLL4p CCCCCGCGCGCGCGCGCGCGCCCCCCGGGGGGGGGGGGGGGGCCCCCCCCCCC4 Ii Mj Lj Lj Lj Cf Fv Cf Fv  Cf  Fv  Cf  Fv  Cf Fv Cf Fv Cf Fv Cf Lg L5 Lf Lf Lf Lf Lf Lf Lf Lf Lf Lf  Lf !Lf "Lf #Lf $Lf %Lf &Lg 'Lk (Lk )Lz *Lz +Lz ,Lz -L5 .L5 /L5 0L5 1L5 2L5 3L5 4L5IMLLL EvG FvG  Fv G  Fv G  FvG FvG FvG FvHLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL4pCCCCCCCGCGCGCGCGCGCGCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4 Il Ld Ld Ld Ld Ld Ld Ld Ld  Ld  Ld  Ld  Ld  Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld  Ld !Ld "Ld #Ld $Ld %Ld &Ld 'Ld (Ld )Ld *Ld +Ld ,Ld -Ld .Ld /Ld 0Ld 1Ld 2Ld 3Ld 4LdpILLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL4pCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4 I4 Ld Ld Ld Ld Ld Ld Ld Ld  Ld  Ld  Ld  Ld  Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld  Ld !Ld "Ld #Ld $Ld %Ld &Ld 'Ld (Ld )Ld *Ld +Ld ,Ld -Ld .Ld /Ld 0Ld 1Ld 2Ld 3Ld 4LdpILLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL4pCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCCC4 Im Ld Ld Ld Ld Ld Ld Ld Ld  Ld  Ld  Ld  Ld  Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld Ld  Ld !Ld "Ld #Ld $Ld %Ld &Ld 'Ld (Ld )Ld *Ld +Ld ,Ld -Ld .Ld /Ld 0Ld 1Ld 2Ld 3Ld 4LdpILLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL4P Qr RRRRRRRRRRRST QnRRRRRRRRRRRS Uu QpRRRRRRRRRRRS) *Uj +Qo,RRRRRRRRS4 Vk QyRRRRRRRRRRRS Vz W{XXXXXXXXXXXY V5 WqXXXXXXXXXXXY) *Vg +Ws,XXXXXXXXY4 Zf [w\\\\\\\\\\\] ^j _xP``aaaaaaaaabcdaaaaaaaaaaabcdaaaaaaaab4D)ltttttttttttt Y@!Y@"Y@#`$Y@%`&`'Y@>@ab4 +4+4 ) )//0011223344))**++,,--..##$$%%&&''(( !!""     //..##$$%%0011223344))**++,,--&&''(( !!""     //..##$$%%0011223344))**++,,--&&''(( !!""     11223344++00%%&&''(())##$$,,--..//** !!""   // ..    00 11 22 33 44  ** ++ ,, --             // .. ## $$ %% 00 11 22 33 44 )) ** ++ ,, -- && '' ((     !! ""                             //..##$$%%44))**++,,--!!""00112233&&''((      $'##(+,,-/0014 "4         !! "" ## $$ %% && '' (( ))       ggD f2ـ   dMbP?_*+%&P&d2?'P&d2?(P&d2?)P&d2?M \\b00f03r313w04\Canon MF4010 S, G 4dXA4Canonp  1`>Canon MF4010 Series UFRII LT{ddd      d d d d d dd@@d  d  d dd d"eddd      !"#d"    @  !"#$%&'()*+,-d.d/d012345678d     ddd !"#$%&'()*+,-./01234d!ddd d!    d  @8 4 2<^ 1 4 2<^ 1XXd2 Arial Cyr\CNZ005.ICC\CNZ005.ICC\CNZ005.ICC$&,$&,HArial Cyr0AB@-:8 ?> C<>;G. X   " dX&U      BBBBBBBBB BBBBBBBBB BBBBBBBBB BBBBBBBBB <>@BB  7 8AB3ggD Module1VS__SRP_24__SRP_3-B0=830   !"#$&'()*+,-./012345679:;<=>?@ABCDFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdfgiklmnopqrtuwxy{* &%(!Start * &%(B@.xkphA@0A@2A@4A@6A@8A@:A@<A@>A@@A@BA@DA@FA@HA@JA@LA@NA@PA@RA@T * &!(!, * &%(P&d2? Z%\5V(XP&d2? Z%\5V(^P&d2? Z%\5V(`P&d2? Z%\5V(b Z%\5V(d Z%\5V(f j5V(hq? l(nStart$((p$(B@Hox@ Z(r &!v\Sheets\sheetDiag.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H 9 l( Z(rqh xB@B Z(ro@0 Z(r &!v\Sheets\sheetVex.xls't t$~:\D|k t|~ z%.xe &%( x%(B@. &%(sofC@H 9t L l(y Z(rq  xB@B Z(r`M o Z(rodu &!v\Sheets\sheetGAK.xls't2 t$~830|k t|~ z%.x2 &%( x%(B@ &%(C@H ()9 l( Z(rq xB@B Z(ro Z(r &!v\Sheets\sheetKP.xls't t$~|`kX t|~ z%.x &%( x%(B@ &%(C@H9 l( Z(rq xB@B Z(ro@ Z(r &!v\Sheets\sheetGEK.xls't t$~|0k( t|~ z%.x &%( x%(B@ &%(C@H9 l( Z(rq xB@B Z(rho` Z(r &!v\Sheets\sheetPractices.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H9 l( Z(r_SRqP xB@B Z(ro(On Error Resume Next Z(r &!v\Sheets\sheetNote.xls't t$~|k t|~ z%.x &%( x%(B@ x%( , 5B@1 - ?.Parent.Close SaveChanges:=False ' True, q &%(6C@H 9> l(B .Rows(1).RowHeight = 15.Columns(1).ColumnWidth = 2.5T( .Cells(1, 2).Value = "") .Cells(1, 2).Font.Name = "Tahoma"% .Cells(1, 2).Font.Bold = True" .Cells(1, 2).Font.Size = 9B .Range(.Cells(1, 2), .Cells(1, 4)).Interior.ColorIndex = 20 .Range(.Cells(1, 2), .Cells(1, 4)).Merge<.Range(.Cells(1, 1), .Cells(101, 1)).Interior.ColorIndex = 2 Z(r$AutoFitMergedCellRowHeight [a1:h200]qH xB@B Z(ro  Z(r &!v\Sheets\sheetKaf.xls't t$~|k t|  v(xME(06 < < $@`-- 4` 6` :` <@` 8` >` 0`'' 2@` H `  T ` $$ R ` kk` &`(`(``l(` N `  P@ ` <<``~ L``` 9 F` D0`  `::` % J`HH` `l( @`MM` Z(`\She`t B`$$ "H`)& (9%i( $` )&.xls%i(0@@H0@@ %hH`#zsY*\R1*#253$*\Rffff*0W5b44d286" 0 P p  (  0P h      (0 8Ph" ( & 8PX p    " & (0 &P x     " & H`hp &      (8"@ H&X &   0@  H Xh"p x& &  8 @ P `p  x " ,   &0 X p x       "   ( 8 P X ` & 6 , F X ` x    $  . 0 ,P ( H 6  B(  p *     "  &  8@H &h      " (0Xpx &       0@"H P (` &   ( 8H Xh 0P X hx    "  & &0 Xp x     (H `x       (8 *P   @  ( *@px  \ ( R Dh  D  8 X p4    0*@4p   ,(X ,p      (  8H "P X(h &   (  0   @ H Xh "p x ( &  8HP X h x       0 8 H X`h    (0H(P"x**       (  0  @ P "X  ` (p     & ! ! 8!@!H!"P!x! ! ! !!!! N" 2P"("$"*" 0#*8# "h#(#*#*# $$*@$ 0p$$$$$$0$$%%%% % 0% 8% H% `%%% % % %4%  H%.0& `& x&& & &&<&8'@'H'P' X' `''' ' '  ' ' *' (( 8( @( H( P( X( `( h( p(x( ( 4(($( B):`)) ) )) ) ")  * &0*  X*h**  * *  ** "* * ,*++ +(+ &H+ p+++ + +  + ++ "+ +*,0,H,P,X, &x, ,,,, , ,- "- - - (-@- P-6p-- - &-  . .(. @. P.`.x. ..&. ..//0/@/H/P/X/`/p/x///////////00(0@0P0 X0h0 0 0 00 0 00"0 000  1* 1P1h1p1x1&111112 2  2 @2 H2 P2 X2 h2 2 2 2 2 2 &2 02 3 03 H3 `3p3x33 3 3333 3 3333 3 3444 4  40484@4 H4 P4`4h4p4 x444 4 44"4 4444 45 5605h5 5 &5 55566 6(6H6P6X6 `6 p66666 6 &6 06 (7 87H7`7x77777777777777888 8(80888H8P8X8`8h8x88888 8 88 8 88 "8 8 .909H9P9X9 &x9 99 9 9 99,:,H:&x:.::: ; (;H;P;X;`; h;x;  ; ;; " ;;; ; ; ;;; ; < <<< (< 0< 8<@<H< X< `< h<p<x<< " <<<< < < <<< < < <<== = . = TP= = >= = := B8> > f> D> H?pStart &%(( * &!(!, ~ z%.x &%( x%(B@ &%(C@H9 l( Z(rq xB@B Z(ro@ Z(r &!v\Sheets\sheetSpec.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H9 l( Z(rq xB@B Z(ro Z(r &!v\Sheets\sheetTitle.xls't t$~|XkP t|~ z%.x &%( x%(B@ &%(C@H5V(5V(5V(9 l(A:A7B@H  B@.1:17B@H  B@.7B@H    7!!#  7!(k  q xB@B Z(roX  Z(r &!v\Sheets\sheetGYP.xls't t$~| k t|~ z%.x &%( x%(B@ &%(C@H5V(5V(5V(9 l(yA:A$B@H  B@.]]]0]H]`5'     7!*-*Z  7(hkH    7! 'y k    7!* * 'yp kh    7!  7! 'y k    7!* *H'y kx V If .Cells(r, 1).Value = " " Or .Cells(r, 1).Value = " " Then" For cl = 2 To rghtK If Mid(.Cells(rsvod + 1, cl).Value, 1, 4) = "" Then> .Cells(r, cl).Interior.ColorIndex = 35 Else= .Cells(r, cl).Interior.ColorIndex = 2 End If Next cl End If   7  77!(]x'   'k      7!'   7! $.  7!.$  7(  7! 9.Pattern = xlGray16 9̙999qkk  7!$tdp  7(%.Cells(r, cl).Interior.ColorIndex = 2   7!(  7!(k  7B@Hq xB@B Z(ro Z(r &!v\Sheets\sheetPlan.xls't t$~|PkH t|~ z%.x &%( x%(B@ &%(9q xlsA.Close xB@B Z(ro Z(r &!v\Sheets\sheetSPlan.xls't t$~|0k( t|~ z%.x &%( x%(B@ &%(9]' l( l( l(  7! 'y0k(   7!1 7B@.k 7B@.]('  7! 'yPkH   '  7!    7( 7 77(  7(  7 77(  7 77(yk q xB@B Z(ro@ Z(r &!v\Sheets\sheetDPlan.xls't t$~|Hk@ t|~ z%.x &%( x%(B@ &%( 9]']7!d;$' $X l( l( l(k07(d  7!  7! ,If .Cells(2, cl).Value = "" Then 7 77(  7(  7 77( /. 7(  7 77(  7( 7 77(  7 77(  7 77(  7(  7 77(  7 77% 999 9q8  7 77% 999 9qEnd Ifk   7! 'ypkh '7  77!(A.Range(.Cells(9, 1), .Cells(9, LastCol)).Interior.ColorIndex = 34" 7 77!(   7!4  7!(k@  7!* 7!(   7  77% 9 9 9qk  7!* 7!(  7!(k@ C147B@H l( 777!Tahoma9999999 99q   7! 7!"  7!("  7!(8 37  7!  7!  7  7$!(kXkP 7B@.Rows("1:1").SelectSelection.Delete Shift:=xlUpColumns("A:H").Select Selection.Delete Shift:=xlToLeft l( 7B@Hqx xB@B` Z(roH Z(r &!v\Sheets\sheetCmptList.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H 9 l(q@ xB@B Z(ro Z(r &!v\Sheets\sheetCmptDD.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H(2)9q  xB@B Z(ro0 Z(r]p * * '  On Error Resume Next &!v\Sheets\sheetCourse .xls't t$~ t|~ z%.x &%( x%(B@ &%(C@H 9 l(U l( 7B@. 7!(7 77 5(  7(  7(  7( 7 9 9 9q 7 9 9 9qp  7( 7 9 9 9q(  7(  7(q  7!! 7B@.k V8:Y87B@H l(qh xB@BkP * Z(ro( Z(r]]On Error Resume Next &!v\Sheets\sheetReduce.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H9'' 2 7! 'y k    7! 'yP kH 7  77 )Range(Cells(1, 1), Cells(138, 29)).Select 5(  7(  7( 7 9 9 9qp  7 9 9 9q@  7 9 9 9q  7 9 9 9q  7 9 9 9q  7 9 9 9q qx qp xB@B Z(roH  Z(r]8]P]h * * ' On Error Resume Next &!v\Sheets\sheetCourse .xls't t$~ t|~ z%.x &%( x%(B@ &%(C@H 9''  7! 'y k    7! 'yH k@ 7  77)Range(Cells(1, 1), Cells(138, 29)).Select@9  5(  7(  7( 7 9 9 9qX 7 9 9 9q( 7 9 9 9q 7 9 9 9q 7 9 9 9q 7 9 9 9qhq`qX xB@Bk@ * Z(ro Z(r &!v\Sheets\sheetPivotTable.xls't t$~|k t|~ z%.x &%( x%(B@ &%(C@H9 l(  7! 7 77 A" 7 77 A$ 7!. " 7 77!("  7!(   7!"  7!(kkk q xB@B Z(roX & *7 9 (9 9q ,7 9 (9 9q .7 9 (9 9q 7 9 (9 9qqoxHh & 7 9 (9 9q0 7 9 (9 9qqo Sub ttt()' Set objExcel = New Excel.ApplicationN Set wbhidden = objExcel.Workbooks.Open("c:\Macros\Primeri\Excel\check.xls")8 Cells(1, 10).Value = wbhidden.Sheets(1).Cells(1, 1)4 wbhidden.Close ' ; Set objExcel = Nothing ' End SubWopenxlsb = Application' .GetOpenFilename("- (*.xls), *.xls")=Set xlsb = Workbooks.Open(Filename:=openxlsb, ReadOnly:=True)ݴAttribute VB_Name = "Module1" Sub MainMacro()  On Error ResufNext6ThisWorkbook.Sheets(1).StartF~i2.Count To 1 Step -1z If eie<> "f&en7s8@DeleteE?d##Ͽ#r#KPo#o#.o#o#plKP_#_#_#bQ_#_#_#_#c_#_#+sS/_#_#_#llO#O#O#R O#O#O#O#J_#_#_#?FFEKo#o#o#o# /k//o#o#o# no#o#o#f#F###& Application.ScreenUpdpng = False End` With4xlsA.CloF1TruSub  CopyPractic0es()T%openaThisWorkbook.Path & "\SheetXs\se.2"hIf Dir(#)$"" Th enExitN WIfShet %A=s.OI(File@name:=-, ReadOnly:=t %#.V(1). Befor! mʀZ \.Select N@(A<0E A@dveWindow.DisplayGridlines elNoteE'On@ Error\sume Nex=)In;A >e}C "KS ' , .[A1:H100]cY[a1] '1 - r'vrentÉ SaveCha@nges:=M @' g, #+LkdXd_dVd '.Ro ws{Heigdht K15h'!%lumnCoAWid`= 2b. 'a.Cell, 2).Value` "LSFo-NTahoma{Bold@ /b SizA9R8(I, 4)).Interior orInde:x 2Mea:h2`c Zc2ԀKafP\OuuOttt ttttytQt7@Bt B44 2ttX+Ϙq_# ˆS_#R#SpecAsp#tt$$$%%%%%i%P%%%.%$  $$$$б:HTitl+###_r#### kǏⓏD}pH2####pge0 up.Zoom+^ jToPa@{1od0Tall*+OOO"A:A")V3Dte Shift:=xlT0oLefvs("1:1ooxlUp Fr1 To 25ؙcq14r, cl?40q;O3 > If Ne`xt cl@r nz8= H~@(K !a.r@ 1` - /rsvod _$_r? 2_+E1"+ 1Fc,Orv C2 "f= K&_1B1?1_FEd1 `V1!v72 0'3B= " "2 *, Ft  9, Mid(p, 4q/a8UriorPmlorIndex&35"E} PODo#jD R7.`RangeP, 0P@,-)).Font.Siz#1XRflnoap`= 2< elA = ^- _1q5&#L- Lenf(>FG > 0 F0 (0, lnA/"".e'!_=`cW@,a ??'1'tern xlSol,id' Gr0ay16rng5xlAutozmxcb 10079487TintAndSha8)i _*o},3gUu/%lL3Ltdp?%$;"H 'O"Ib"$Li0Up!1l NO~2q'θSRaPlan/? x؀/z0%2$ $Ҋ`kH&&l!Xyk.Sheets@(1) .Name = ""\x@End With 'xlsA.Close,v On Erro@r ResuiN8ext'% GApplication.ScreenHUpdngT runSub   CopyPlanSvod(EFalZCopenCa0hisWorkbook.Path & "\\s5S5.If Dir(!)""" ThentExit Y7_IfSet %FA;s.OG( Filen:=-,adOnly:=%#. Before kʁw,> A- Dim LastCol As IntegerGA= 1ActiveWin dow.S}tR4ow@B6@um nX FzePa8nes@ 0 Fcl256 To 2 Stpep -% t.Cell, cl).Valuep <> vE8cl/EK A _Aǀ G.r-1250.7. @.Not D/r, 2/1R..s(r).Deletzd (;g1 'ElErrE#= 336 6e v!! +OA8O7 9b\xAED5! x)[ ya.Range(j,%N5 ).MergeBh? kpa0l p)).HorizontalAlignmentxlCF_hert _ ?~*~AK_H_ h'tDqms_x ssstssrsss Q s sses32sysaqttt q?u?uv:uAsaUVarianؖ/pBv;0RT , (";" !HUB@ound(s1/ {{C(s(0)) + 2 ?~||J}g߹ !WI p?"hDd9X1da3lRI OrO}Z 11'2wP QcX7BX;V g[5 "" Thes0LastHcl Exit K1-rwfi4rsA8K1, 1 - ')).Interior.s2G:'9@34L))1`'qrwZE9r00LGqrw, 6)Dqp= "4UqD 1~1\K2a8aK9 H*_8.EntireRow.H idden`Tr|ueG aP #+>9A B10`@gEdgeTop_= _. OxlAutomaticO++--.[.-a{FD$*)_b}rwg$f"C14").SelectActiveWindCFreezePaneswnDgD41:9CFh @.Nam"Tah@5"SizȒ.Striket@hrough FalsW.Supa`crip3bsOutl؁[u oA Ur3xlNon:S(c*fJ13fJvfG2eB< 11 EhK7/h! 0^{oYB@IO0OO#34 ' 37O g3P-  pyv0`NJoin$e9q=>;.Zs(b*D0:t"'"1$:1< '=ion.s Shifht:= (pG'@'umns("A:HToLefCGDDisplayGridϡ0aD2"10 C" I!/xlsA.Clo>sOn ErrResuE ApplLic`ScMnUpdng:oSub ` CopyCmptList(tl_X 3open ahisWorkbook.Path & "\Sheets\s;a.P.Dir(e)pNR m%SetusAPs.O (FiHlenW:=, ReadOnlxy:=f{ A. !) Before 6sSApEl hab&&KV_% RY%_"R"/tr"n..'"Eo"n"DDO"EO"O"5O"kO"d,O"DO"yO"/O" O"O" O"H"(2)t" C___CoursesNewoo hDim iC As Byt+0e PFor i = 1 0To 7tiCAP8 - iL 'On ErrfResume Next@ope nxlsatThisWorkbook.Path & "\Sheets\sCouprse"k.9"KIf Dir(R) <> "" Then$Set :Atps.O(Filename:=E, ReadOnly:=Tru,e) %#.Q(1).Copy Befor! hy"WivZ.`Selec N\i" 3ActiveWindow.DisplayGridlinespFals+Zoom 85 clB21S A KlumnsN:D@5tP cl.Rows(7).Entire@.Hidden@T2Z.Range(.Cells(8, 22)$, 125)Lz!.Interior/orIndex@xlNon/.Borders(xlDiagonalDo wn).L]StHyle/UpEdgeLeft'K'!Top#"$ Co`3nuousAWeight? `u e.Automatic pEnd !qB=/Exit ik2 HA'  .&.%X= 0a!r(95c9_983, x).Value0%xWr\mi8- y=` 1 4 y, 13 yk # 7fZ1Gr,4^'sd39)Gq0^//T[rkq\A3ǯvCol/vρ! O ge? ti/" ? bH?/? 1? ge/0o o eo o o o geЧ_  .ColorIndex = xlAutoma tic  End With T" .Borders(xlIns@ideVer~a l) X.Lin@eStylelContinuous*Weighta'Thin!OHorizJ^xlsA.CloseApplicon.ScreenUpdngUTru ASub  CopyCour0ses(DoFalDim iC As BytAlastcInteger&ErN= For i+1 To 7@= 8 - i'On Err@ Resume NextPopenHaA?hisWorkbook.Path & "\Sheets\sB"+@.@"If Dir() <> "" Th"eSetsA#s.O@"(Filename:=E, ReadOnly:=gЉ@ A.((1)py Befor4+L! .Selec'N`"<# >= 0SrP?!30?1 Stepp -1`2.Cells(3, x).Valu^e3!aEx Epxit IvfoO 0 /!yI!15_ Gy, 13aa.yv0 o @Range($411), , c)^# '<38, 029))vVa.Number-.<"@y ariorNonDBDiagonalDown) Up,EdgeLef~tT)" xxs.?y okl geTop   / B)Bot v I    p)Rq f 9    /// ////"9OOlO OOO_QqB䨏׷PivotTable? Cwmz{=oₒ Ϯ.kϮTϮ  ϮϮһ̮2c^sp.؁ActiveWindow.DisplayGridlskx#  b3rOr`Call r~Out1(.ÑN1ǕxlnW\ Call RangeBordersInside(.L(.Cells(r, 1H), 2)xlThin) If InStr(1 n1).Value, ".") > 0 T8henBV.Interior.ColorIndex = 34T j0)For cl213 To 2555b2,""! cl1[!End If+NextSgUA rWithCCxlsA.CloseApplication.Scre enUpdng1ITru Sub Pri`vate Out®R As@, xlW @LongA# +AEB.D(op.LineStyle@$xlContinuous.WeightWxlAutom8c J&Bot@ &&Left?&ʉ׋z&& -Ra2___:;!YyY@On Err`Resume gw C:\ Vertnl###]th pAcHorizma__r_rZr28't(tt(('OSet objExcBeaNew b. %wbhi0dden@.Workbooks.Open("c:\Macros*\@m\ \check."Ac 1ۢ` .Sheet|s(xwY ' )otg 0'o b 9 _ =C.GetFilename("- (*q@rq E:=, ReadOnly:=gg1rU~|      zrU $`$`$`$`$!`$I`$q`$`$`$ `$ `$9 `$a `$ `$`$`$`$)`$Q`$y`$`4`=a(4 `=a(n')#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0zsYxAttribute VB_Name = ""  Bas|0{00020819-u 0C$0046} |GlobalSpacAFalse dCreatablPredeclaIdTru B@ExposeTemplateD0eriv$Bus`tomizD2 j#x8AB3  %_VBA_PROJECTdir8 __SRP_0 EME (SLSS<N0{00020820-0000-0000-C000-000000000046}x 4h@%@@pzsY" A@$oh`Attribute VB_Name = " 3" Basp0{0002`0820- C$0046} |GlobalSpacFalse CreatablPredeclaIdTru BExposeTemplateDeriv$Bustomi6zD2P S@ub cmdTeRUPCopy_Click()  MainMacro End pb0LastCol640SplitRowS0 SplitColumn0 FreezePanesMz0lastr30xo0 MergeCellsک0HorizontalAlignmentS@0xlCenter0VerticalAlignmentʡ0sj0Split)0xlRighte0BordersC"0xlInsideVerticaljM0 LineStyle0 xlContinuous[0Weight0xlThinw0xlInsideHorizontal0rwfirst0rw_0 EntireRow0Hidden]0 xlEdgeToph0 Strikethrough"0 Superscript0 SubscriptV0 OutlineFontO0Shadow0 Underline0xlUnderlineStyleNoneQc0(CopyCoursesNew90iC]0xlNone0xlDiagonalDowno@0 xlDiagonalUp0 xlEdgeLeftL0 xlEdgeBottom0xlMedium0 xlEdgeRight%v0lastc$0yp0 NumberFormatR0RangeBordersOutside%0RangeBordersInside0RngU0xlW10xlTop0xlBottom?0xlLeft90 ]0 30cmdCreateRUPCopy_Click0Workbook0l! 13  6AA (J@ Office 11.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{66C7FB4B-F6B4-46B3-9030-DB6B0A22E1CA}#2.0#0#C:\DOCUME~1\User\LOCALS~1\Temp\Excel8.0\MSForms.exd#M0* pHd VBAProject4@j = r zsY J< rstdole>stdole h%^*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\syst em32\e2.tlb#OLE Automation`EOffDicEOficEE2DF8D04C-5BFA-101B-BDE5EAAC42Egram Files\CommonMicrosoft Shared\OFFICE14\MSO.0DLL#M 1@1.0 Ob LibraryKMSForms>SFrms3D452EE1-E08F`A-8-02608C@4D0BB4SFM20L'B _&/;"1jIqAHq00}#0Bq# 50 A66C7FB4B-F6B4-46B3-90DB6B0A@22E1CA6DOCUME~1\User\LOCALS@Temp\Excel8.0bB7.exdcU<".E .`(M A"Clodule1GDlou1 2*HB1BvXB,B(!B+BG-B0=8l3!j2ro-"o)" e3GA3`F2L/ 0 j) K*rU~~~~~~~~k `XF6+Ac8@h  i Qq )Aa ) Q y 9   ! )  VBAProjectModule13Fa *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.7#0#C:\Program Files\Microsoft Office\Office14\EXCEL.EXE#Microsoft Excel 14.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.5#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLL#Microsoft Office 11.0 Object Library*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library *\G{66C7FB4B-F6B4-46B3-9030-DB6B0A22E1CA}#2.0#0#C:\DOCUME~1\User\LOCALS~1\Temp\Excel8.0\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M  zsYModule10W5b44d286 Module1(v-B0=8300U5b44d27a1-B0=830)- 8AB30V5b44d27a3 8AB3j0P0 g30E2\4+@͢a(/;@pJ0t; Excel+0 VBA0Win160Win320Win64F0Mac0VBA6#0VBA7#0 VBAProject0stdole`0Officeu0MSFormsC0 Module1b0 _Evaluate0 (MainMacroz0 ThisWorkbook$0Sheets 0i`0Count0v0Deletex0(CopyNote=0(CopyKaf=0(CopyDiaga0(CopyVex0(CopyGEKrv0(CopyGAKu0(CopyKPs0 (CopyPracticesf=0 (CopyCourses00(CopyPivotTablep0 (CopyCmptDistre0 (CopyCmptListE;0 (CopySpecAsp0 (CopyReduce0 (CopyDPlan0(CopyPlanٵ0 (CopyPlanSvod00(CopyGYP[y0 (CopyTitle0 PageSetup0 LeftMargin]0 Application*0InchesToPointsI0 RightMargin[0 TopMargini0 BottomMarginu0 HeaderMargin80 FooterMargin0 Orientationw0 xlLandscape&0 ActiveWindowzB0TabRatio50Visible0ScreenUpdating! 0openxlsa0Path20xlsAG0 Workbooks0Filenamej0ReadOnly8<0Copyʿ0Before0DisplayGridlinesmX0A1:H100:0a1k\0Zoom0FitToPagesWidea0FitToPagesTallZ0Columnsp90 SelectionZ0Shift0xlToLeftWY0RowsU0xlUp0Cells0ri0cl\0Interior;0 ColorIndex0boty0rght(0e\0ValueK0rsvod0Range 0FontU0Size0ln^0Replacef0Patterni0xlSolid7n0PatternColorIndex0 xlAutomatic@0Color2F0 TintAndShadeq0PatternTintAndShade<0 xlLightU /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLLVBA 9 a0F4C:\Program Files\Microsoft Office\Office14\EXCEL.EXEExcel 1Y@0FC:\WINDOWS\system32\stdole2.tlbstdole CopyPractices AiPL-[DR?C:\Program Files\Common Files\Microsoft Shared\OFFICE14\MSO.DLLOffice a`.E .`M C:\WINDOWS\system32\FM20.DLLMSForms pKfF0k " 3C:\DOCUME~1\User\LOCALS~1\Temp\Excel8.0\MSForms.exd a MainMacroCopyDiagCopyVexCopyGAKCopyKPCopyGEKCopyNoteCopyKaf CopySpecAsp CopyTitleCopyGYPCopyPlan CopyPlanSvod CopyDPlan CopyCmptList CopyCmptDistrCopyCoursesNew CopyReduce CopyCoursesCopyPivotTableRangeBordersOutsideFFRangeBordersInside /rU~}   RngxlWl__SRP_1ePROJECTwmhGPROJECT jSummaryInformation(sModule1Module1-B0=83038AB3ID="{78065441-29C2-4721-95EC-A7BC28402580}" Module=Module1 Document=/&H00000000 Document=3/&H00000000 Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="292BA4BCA8BCA8BCA8BCA8" DPB="A2A02F54A955A955A9" GC="1B1996DF0EE00EE0F1" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 &H00000002={00020818-0000-0000-C000-000000000046};Excel8.0;&H00000000 [Workspace] Module1=266, -14, 986, 602, Z =0, 0, 0, 0, C 3=92, 92, 994, 711, Oh+'0h08 H T`User@@_՜.+,0HP X`hp x DocumentSummaryInformation8vCompObjzf Start  F Microsoft Excel 2003Biff8Excel.Sheet.89q