ࡱ> bh  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FwWG5@<Workbook$Q_VBA_PROJECT_CUR""!pN5VBA@J0 YA\pAlexandre Pinho Ba=(*) ThisWorkbook=`T6)8X@"1$Arial1$Arial1$Arial1$Arial1$Arial1$Arial1$Arial1 $Arial1$Arial1,$Lucida Console1 $Arial1$Arial1 $Arial1$Arial1. $Times New Roman1 $Arial1 $Arial1$Arial1$Arial1, $Lucida Console1*h6 Calibri Light1,6Calibri16Calibri16Calibri1Calibri1Calibri1<Calibri1>Calibri1?Calibri14Calibri14Calibri1 Calibri1 Calibri1Arial1Calibri1Calibri1 Calibri1Calibri3#,##0\ " ";\-#,##0\ " "=#,##0\ " ";[Red]\-#,##0\ " "?#,##0.00\ " ";\-#,##0.00\ " "I"#,##0.00\ " ";[Red]\-#,##0.00\ " "q*6_-* #,##0\ " "_-;\-* #,##0\ " "_-;_-* "-"\ " "_-;_-@_-k)3_-* #,##0\ _ _-;\-* #,##0\ _ _-;_-* "-"\ _ _-;_-@_-,>_-* #,##0.00\ " "_-;\-* #,##0.00\ " "_-;_-* "-"??\ " "_-;_-@_-{+;_-* #,##0.00\ _ _-;\-* #,##0.00\ _ _-;_-* "-"??\ _ _-;_-@_-"#,##0\ "Esc.";\-#,##0\ "Esc."'"#,##0\ "Esc.";[Red]\-#,##0\ "Esc."(##,##0.00\ "Esc.";\-#,##0.00\ "Esc."-(#,##0.00\ "Esc.";[Red]\-#,##0.00\ "Esc."D?_-* #,##0\ "Esc."_-;\-* #,##0\ "Esc."_-;_-* "-"\ "Esc."_-;_-@_-JE_-* #,##0\ _E_s_c_._-;\-* #,##0\ _E_s_c_._-;_-* "-"\ _E_s_c_._-;_-@_-LG_-* #,##0.00\ "Esc."_-;\-* #,##0.00\ "Esc."_-;_-* "-"??\ "Esc."_-;_-@_-RM_-* #,##0.00\ _E_s_c_._-;\-* #,##0.00\ _E_s_c_._-;_-* "-"??\ _E_s_c_._-;_-@_- m/d/yyyy"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"                &  &  &  &  &  &  &  &  &  &  &  &  %  %  %  %  %  %  %  %  %  %  %  %        ff     #     P  P         `   "        $ a !  @ a" "x  "x  h  `@ @   d@ @   `  h@ @   h@ @  "p@ @  "P  D "x@ @   d  `  d  "x  `@@  `@  `@  `   ` @   `   `@ @   d@ @   D  `@ @ 9  `@ @   `@ @ <  `@@  `@  `  @  `@  h  `   ` @   `   `   h@   h@  a"   @ a"  @ )p@ )p )p  )x@ )x )x  "x "x  h  h "x   h@  h a" a#  @ a a a a"@  "x@ @   "x  "x"@@   "x"@   "x " @  a" "x@ "x "8"@ "x  (p@ (0 (0 (0@ a"@ a" a"  a" a! )p@ )p )p  a*@ a* a*  ||Ŧ}-}= * #,##0.}A}2 * #,##0.* "-"??\}A}3 * #,##0.?* "-"??\}A}4 * #,##0.23* "-"??\}-}5 * #,##0.}A}1 a* #,##0.* "-"??\}A}( * #,##0.* "-"??\}A}9 e* #,##0.* "-"??\}}7 ??v* #,##0.̙* "-"??\_-@_--?\ _ @_-@ }}; ???* #,##0.* "-"??\???_-@_--????\ _ ???@_-@ ???}}) }* #,##0.* "-"??\_-@_--?\ _ @_-@ }A}8 }* #,##0.* "-"??\}}* * #,##0.* "-"??\???_-@_--????\ _ ???@_-@ ???}-}? * #,##0.}x}:* #,##0.* "???_-@ ????\ ???@_}-}/ * #,##0.}U}> * #,##0.* "_-@ }A}" * #,##0.* "}A} * #,##0.ef* "}A} * #,##0.L* "}A} * #,##0.23* "}A}# * #,##0.* "}A} * #,##0.ef* "}A} * #,##0.L* "}A} * #,##0.23* "}A}$ * #,##0.* "}A} * #,##0.ef* "}A} * #,##0.L* "}A} * #,##0.23* "}A}% * #,##0.* "}A} * #,##0.ef* "}A} * #,##0.L* "}A} * #,##0.23* "}A}& * #,##0.* "}A} * #,##0.ef* "}A} * #,##0.L* "}A}  * #,##0.23* "}A}' * #,##0. * "}A} * #,##0.ef * "}A} * #,##0.L * "}A}! * #,##0.23 * " 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L˭ % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  L % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23 % 60% - Accent3M( 60% - Accent3 23 % 60% - Accent4M, 60% - Accent4 23f % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23Ў % "Accent1AAccent1 [ % #Accent2A!Accent2 }1 % $Accent3A%Accent3  % %Accent4A)Accent4  % &Accent5A-Accent5 Dr % 'Accent6A1Accent6  pG %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,( Comma [0]-&Currency.. Currency [0]/Explanatory TextG5Explanatory Text %0 : Followed Hyperlink 1Good;Good  a%2 Heading 1G Heading 1 DTj%[3 Heading 2G Heading 2 DTj%?4 Heading 3G Heading 3 DTj%235 Heading 49 Heading 4 DTj%6( Hyperlink 7InputuInput ̙ ??v% 8 Linked CellK Linked Cell }% 9NeutralANeutral  e%"Normal :Noteb Note   ;OutputwOutput  ???%????????? ???<$Percent =Title1Title DTj% >TotalMTotal %[[? Warning Text? Warning Text %XTableStyleMedium2PivotStyleLight16` W~Input HelpDemo RestrictionsMacro Configurations_  Main  ;   ;S   ; fNf8@0 2;R3HV!Tң2KFHV!Tң2KJFIF``C   %# , #&')*)-0-(0%()(C   (((((((((((((((((((((((((((((((((((((((((((((((((((T" }!1AQa"q2#BR$3br %&'()*456789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz w!1AQaq"2B #3Rbr $4%&'()*56789:CDEFGHIJSTUVWXYZcdefghijstuvwxyz ?+&k屲E76bR,  0bif ĀHn;OVus6ah e#=WКTiW RQcBdJPʫ1>lh cUԭ-YHեGURgOV89]>+ź ZvλY8}?٠lw5K>kM*kiIȕۓ@RwF56Z\C*FV(wG9NGL}E|O!;-aEsr '=qw ~xtjMX峖7i2 oCo@jډUmBQ$ vqQw>ḨqA6e=i"䌶ݑ]I|C[ɣz[oKE/]ی_1Tw8+|4'cm2Ḓ mI9͞093imtH2 Q&7G. J{]óEww;9]+]gҺM$^f%\]@|ܜɒ  tEflc$D31;*chPIB&j7#75O[{>~ҺEd~!;w}t8:6& jLNUqҀ<\H7H,ؖu&:3X<1vSÄR_Fצ;=0dsЌC^zݻD;,EΛ$y32rq4^sϨxR E$\uaᵅ)/l $vO{?|wCPҎ^PlbS"2}B޾N/SzE&55ůmFR"2(rN8“ҜSR洩i%o}?iZ&άY+x [qrU#bS )Cg>0wRNs0|;ӼKxW^SAnh|d݄qt_=+:NN>tFD&o=Ӽ[bI4Syƫf5=9J->G!_$s<~zt 8f~.=[:r=Jo/Gw|5 \^G|INeY hw }fK!_ݏS~=t_zaY % ʜ1眑2}-_#ezlb.ۆ?N_oOw:{v̶}FU~A=? >VP.ʆ3Mm,wGP:]ީsk7]/&Njw8ү#}?wZQꍤ;԰4?ӧ%ʒo=:*cI;yUw3< g!Sojծ.mat8ijH G!@A3ڨAIo`9 P|>/-e,"$۱zsؐv4 jV~KkY_cXyM/:=V\I"7c #Wt[WcQHYе~+cKr@„KqS<c?O=Y^#Yϋ~N/?jwD,xwa>Z€-x— i*c6/d9Z~x,kj+F$^ 'C)j~ -& 8f'I85`ZC1>7OܜC@zhw4|oWjE16g,}ggU ;|9R<=9|Q^?>M~Hݧ>Y^v>&+EZT} 14~7/Wj!apK@zIkԢǺo7o>m_3gz"u3?fn~_mEZ50` ~om^U7~6ME+'Cַ^Ru=/Ø<=P9Pƽ"h)֦Ko<5U#U9vxuo틻GUk h|CNTE d/jM'IS~l^/ޛҝ3h\7?'0ӈk?'ݷSp?otlXGMV6cou?i.1߇2Yhj_&GM'퍷/<ڡTO:7mgΕl-,~9˶J.5 7x,{nkOF7Nݤߟ97n_?bX]ni#R&KQx (ZTH{N߆%4dO]Fvs{zdϚ&^:bx}_OmXCI v :ŌdS@ j;u ۅА砎8"(ªJyԿo#Ftwc/o=Y iii?6wnXkǝg=]W\K jv"0.. 1N G;Hd3O-@0Sن~淅r~Ys\'D^kx[ϳ -Ү7Q4DݏE#ᯘ-5ٱ#ͬ]k_--r'ڭ~ӢiM| [u_+AIیgLw/Oɻ$!̮ ?[3 >/I$Sw97G!>?矡5 ,6iu)lqK$IPyDUN馗.U*mj||RnEl,$ r3ϝ_)xNӵ;9. *B1$>GﵬQ܌?\QϋYTP c/ݪNsVQiSkYQ_Z' cin.~?Ok_3Z/ %>P_ťCmviHvfg~+]LVg5cfO6kn"bΕ]73c>-|][WH^,>m??)j4_y4ٴbMoQ]zfkԬ~k ھplu |Gưd]_jey DD+SeWC->}:I7 UԳ;G-?v9Ni]~T0ߏ|bueF$ōYYQN@Q3k:wP`Bqd# AG4)/#Y]Ɲ V~Bn`>h}U4B]:]A"\m#DvaY1AɠH5/V_ֆCN#햟vGMZ k3eEVZr"3d s%pc$[k7j:kG2?dܟ`Wͮl3b R`v1N[ ƭxLAy'Q3pA7L8515ijrJ=5PqOW+j인$S]kK_֚-Zn>mOֲ?ZoN>3ʷuZ!t屌gʷ"?z~oʶ4&}MJxg'kY&#?7k&1۷Η7\&۟IYH<)lɷ m_kAM6?#?jٿL}/7w٠91iCmiw$}mʶZs_M*Zۭ7'6R%Gu?~L'IӍ6@MQs'-o\U'i6_?9/3+j인$S]kK_֚-Zn>mOֲ?ZyoyV|kS:N1Z VGG~mVO5KhtŤokKe=4o&&o GY9v7U4vF7^0#ɷoz-l>"ciWGֺ0,Ɲhʾ# \_֑/KlOAK%u{rB 1֞|[Q^F/>K f.Cm=W>gOqOV-f$;E]/O3x#LBIy: kwgAgbd%eI~Uv.P)BZOŹnw9.ovb( ?>_kf+jnc:bmI/5]AY؀hc5Y?w|== KGp:%(jrA:|( 7n m`)o3tQ@ OihҲ^k6#Z EZxIEmu%&vI,OE@Zټ+ڻ۷<Θ:dRKypl6vyv ([5hrd~БԖ/SRMF{ 62cOQE3  @@  *r Starting Date Closing DateTasksLevel Task NameColorName Month NamesJanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberNovemberDecemberOctoberDeadlineY Start DateEnd Datey Demo Plan Usage Help(Can I leave a Blank line between tasks ?kThe Plan will start and finish on the dates supplied on the Input cells C7 (Start Date) and C9 (Close Date)nThe Plan generator will create a plan on a new Workbook using the supplied name (Input cell C5) for the Sheet.The month names can be changed on the appropriate Input table, if you want to use alternate ones (foreign languages, shorter,...)%How to input the tasks for the plan ?cYes, just enter a level 0 blank task (no data or name). The supplied sample data has one (line 19).6How does the Plan Generator knows when the tasks end ?9Insert data for the tasks on the appropriate Input table:nLevel: Level of the task. Level 0 means a task group so no % is used and has a bold label. Labels are indentedStartDate: Date when the task bar should start. If before the Plan start date, the bar will start on the first day on the plan. Name: Task name or label!Can I change the resulting plan ?GWhy do I get a Macro security warning when opening the Plan Generator ?NCan I save the Plan Generator with the Plan Data ? Can I have several copies ?mColor: Color to use for the task bar. Just change the cell background color using the taskbar button for thatgDeadline: If it has a "Y" or "y", the task bar will end with a red "D" on the last day, the deadline vEndDate: Date when the task bar should end. If after the last day on the Plan, the bar will end on the Plan last date.The macro will stop on the first task line with no data on the task level. So if you leave the task level empty on a line, it will stop there even if more tasks exist after that line.yOf course. It's an Excel Sheet like any other. There is nothing special once it's generated, only colored cells and data.sAgain, of course. It's a regular Excel file. There are NO MACROS on the resulting plan, only on the generator file.7 @There are office Macro Virus, so office can be configured to request permission to run macros. Only run macros from known sources.Macros are a very useful tool to automate tasks in Office. Unfortunately, like another programming language, it can be misused.HELP using this macro.Office XP/2003 Warning: Macros may need to be activated. Follow instructions on the message Excel 2003 will show, if necessary.AOfficeHelp macros are Virus Free and can be open with confidence.Macro Configuration HelpMacros are a possible security threat. Therefore, they are disabled in many recent Microsoft Office Editions. Learn more on how to5configure them so that you can utilize this software.9Help - The button doesn't work but there are no warnings :If you can open the Excel file (both the DEMO and/or the commercial version) and get no warnings but the button just won't work, you have Macro support disabled on Excel. Please refer (click here) to our article on Macro security issues for information on how to configure Microsoft Office Macro security settings.(Back to the Main Display user interface..How can I get Help configuring Macro Settings?Doesn't work? Click Here:Check this FREE Online PC TIP on our website: (Click Here)Automatic Calendar SplitThe Calendar Plan Generator macro will warn you if the calendar reach the limits and propose an automatic split of the calendar into 7last full month. No months will be split in the middle.Prepare BudgetCollect Last Y Spending Consolidate Allocate Team Preparations ExecutionTestsDailyWeeklywww.officehelp.bizThe PC HelpSiteSplit bySplit every (months)Make Sub-Test 1 Sub-Test 2 Sub-Test 3 Sub-Test 4Sheet|Excel has a built in limit of 256 columns. Since it uses a column for each day/week, and some columns are used for data and formatting, you cannot have calendars longer than 253 days/weeks. Very long calendars can also be impossible to read once printed.yseveral plans. For your convenience, each calendar will have the task headings and splits are automatically made at the *What is the "Split Every (months)" option?Instead of having very long calendars, you can have them split for you, automatically, every N months. You have to select a value3from the list supplied, other values will not work.What is the "Split by" option?~If your calendar plan is split, you can opt for each calendar plan to be made on the same sheet (having them all together and lpre-formatted for the printer) or separated on an Excel Workbook for each. Same sheet is the default option.What are Daily Calendar Plans?mdetail but produces long calendars for large periods. Better for smaller periods, when details are important.What are Weekly Calendar Plans?ydetail but produces compact calendars for larger periods. Better for larger periods, when the "big picture" is important..Can I make them both using the same task list?Yes, of course. Just select "make" on both of them and press run. But it is usually better to use different "Split by (months)" valuesfor each type. For a 1 year calendar, the best values for split are 3 months for daily and 6 months or no split for weekly calendars.~Daily Calendar Plans are calendar plans with a column for each separated day in the calendar main interval. This gives maximum}Weekly Calendar Plans are calendar plans with a column for each separated week in the calendar main interval. This gives less)Get the Full (Unrestricted) Version Here!Demo Restrictions`This file is a FREE to download DEMO from OfficeHelp.Biz. It is restricted on its functionality..The following restrictions apply to this DEMO:+How to get the Full (unrestricted) Version?<Simply download it from OfficeHelp.Biz website on this link:Return to Input PageA- Only the first 7 tasks will be used (the remaining are ignored)C- The calendar is limited to 27 days / 49 weeks from the start date(Can I stop the macro while it's running?Yes. Press the ESC key and it will stop with a warning message that it was interrupted before finishing generating the calendar.#Plan Generator BASIC Edition - DEMO OfficeHelpz^U UdUKVXZ5x^& ` cp6ddWfri XlEncc:PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭VzpBU&+3[ΫI]s[JPǭq'Is[Tޠ;yVݣhxEs'>^r~25xo[;v?r^BJtk5VEB]ϝ .1"\Ы$@)$: C%X'dB(N I ǕW##EZ!ag?ywo|~7-斪4G(^r7/|m#f3|e=O"x@x},DD@!6P>[#j — pJuf+N 3? # x$tdF<s)yl#ti{b-U JL*!<(hc-]r$D)% n}I"F\K#A\&!ԚoN_Zz/u$, D 08L*g(OMFNיƌC&8d2x^%Oaa?HGf\t$Qb(5a$Ucv)৉B={`-7 WդMoV!qtMXE3b̎j ]cc$|1I sUǘA$]*g3_g?SP{iK3s3-~1X43X ?Z]ofjlf0-h߈*VFh7aHw"l=1Ok>JyۚZ*.gu5w]j^f_qc2ʧe6 t6b#{>-t0M0A!';qp)L2VNC֐c %KV^2+Man4 Nyeeo^5Tdmc r@c)hl]VӃQڳc Q į.DYo,i0w$ "qfQlUh,9D4>[@+qt=x>WîO9W dឆ59ڎp`@8proބUDɿTЮ*JP>hd%WȻ]P%E!/EUUӪj6쭺7 )if1m lvE^t1pZsަnu[}BU% UL3MXKÂQvxi [-U58 ުvТ++sv21.wE,;,=Ϭ4t'ˇDEվXXעE[> :0տWNG9 +:./30ς0pmk^Mێ ON Iс?lN_Қ{ Nl+/acͩQD;(&>^K5/F 1Ä&8n[5;/]ݦl>*;xGſ {,YŁ<>ngpT8cW !9󾧪DR $XPb2ҳџxmYszmЙ kjǃ`R$$AlvEoz,oYE&Ti" wSn]r⣝g*d5,%' N3 ˧$ee?_ H4:p*żX8EQD=MN[$p.o>.e_ wty ], Ĺpg6r oa{}wzCat뵎otƞS 00rxuQalAQE׭ƤZn?AQkMFCӝK v͡wj-g80ӭF]Gvv=/PK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-! &g 6+theme/theme/theme1.xmlPK-! ѐ'q theme/theme/_rels/themeManager.xml.relsPK]l Ncu-W YA ( Þiy!1AQaq  #)).949I?DYJOiUZy`fkqv!|1AɗQ٢aA Ѽa)Ii1Q q9!&*/Y4!9=ByGAL QUZa_)dhmrIw|ـi1QqǶ  dMbP?_*+%&?'?(?)?MArrabida BWC odXXLetter DINU"4d IUPHdLetter [none] [none]Arial6P d?ACPINHO1<Automatic>0    Type new Quick Set name here" dXX??&U} @} @}  @} . @}  @} t @} (@} E@} .@} . @( 22 2 2@ 22@2Z@2@2K@2 2K@ 2 2K@ 2 2 22                @ pfQQQQQQQQGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG1RSSS zf k; AT G DO rGUTODOOUT~ N @ DO vMU I B TPDOrUBBB T~ N@ DO rHU J TDDOrUBB T~ t@ DL O sM U q  TDDOOUCC T uR DK OOUCC VWWWW i1 C ~e~~~~~  M H H H H H H I~ EX JF@@F@@ E@ I ~ E? ]JF@@F@ EA I ~ E@[ JF@F@@ EB I ~ E\JFFE I ~ E\ JF@@F@ EC I ~ E?X JF@F@ ED I~ E? XJF@@F@ EE I~ EXJFFE I~ EX JF@F0@ EF I~ E? \JF @F@ EN I~ E@\ JF@F@ EO I~ E@ \JF@F@ EP~ E@ \JF@F@ EQ yfEEJYYEjEEJYYE {eDd lx8Hd``:2"0bXNX0XXN0XNX@N   ! " # $ % & ' ( ) * + , - . / 0123456789:;<=>? EEJYYE |!EEJYYE!}"EEJYYE"}#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED^l @ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE߁EEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYEXEEJYYEYEEJYYEZEEJYYE[EEJYYE\EEJYYE]EEJYYE^EEJYYE_EEJYYED@l`abcdefghijklmnopqrstuvwxyz{|}~`EEJYYEaEEJYYEbEEJYYEcEEJYYEdEEJYYEeEEJYYEfEEJYYEgEEJYYEhEEJYYEiEEJYYEjEEJYYEkEEJYYElEEJYYEmEEJYYEnEEJYYEoEEJYYEpEEJYYEqEEJYYErEEJYYEsEEJYYEtEEJYYEuEEJYYEvEEJYYEwEEJYYExEEJYYEyEEJYYEzEEJYYE{EEJYYE|EEJYYE}EEJYYE~EEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@lEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l     EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYE EEJYYE EEJYYE EEJYYE EEJYYE EEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYEEEJYYED@l !"#$%&'()*+,-./0123456789:;<=>? EEJYYE!EEJYYE"EEJYYE#EEJYYE$EEJYYE%EEJYYE&EEJYYE'EEJYYE(EEJYYE)EEJYYE*EEJYYE+EEJYYE,EEJYYE-EEJYYE.EEJYYE/EEJYYE0EEJYYE1EEJYYE2EEJYYE3EEJYYE4EEJYYE5EEJYYE6EEJYYE7EEJYYE8EEJYYE9EEJYYE:EEJYYE;EEJYYE<EEJYYE=EEJYYE>EEJYYE?EEJYYED@l@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_@EEJYYEAEEJYYEBEEJYYECEEJYYEDEEJYYEEEEJYYEFEEJYYEGEEJYYEHEEJYYEIEEJYYEJEEJYYEKEEJYYELEEJYYEMEEJYYENEEJYYEOEEJYYEPEEJYYEQEEJYYEREEJYYESEEJYYETEEJYYEUEEJYYEVEEJYYEWEEJYYE XKZZ YKZZ ZKZZ [KZZ \KZZ ]KZZ ^KZZ _KZZDl`abcdefghijklmnopqrstuvwxyz{|}~ `KZZ aKZZ bKZZ cKZZ dKZZ eKZZ fKZZ gKZZ hKZZ iKZZ jKZZ kKZZ lKZZ mKZZ nKZZ oKZZ pKZZ qKZZ rKZZ sKZZ tKZZ uKZZ vKZZ wKZZ xKZZ yKZZ zKZZ {KZZ |KZZ }KZZ ~KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ       !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefgijklmnopqrstuvwxyz{|}~KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl      KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl !"#$%&'()*+,-./0123456789:;<=>? KZZ !KZZ "KZZ #KZZ $KZZ %KZZ &KZZ 'KZZ (KZZ )KZZ *KZZ +KZZ ,KZZ -KZZ .KZZ /KZZ 0KZZ 1KZZ 2KZZ 3KZZ 4KZZ 5KZZ 6KZZ 7KZZ 8KZZ 9KZZ :KZZ ;KZZ <KZZ =KZZ >KZZ ?KZZDl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @KZZ AKZZ BKZZ CKZZ DKZZ EKZZ FKZZ GKZZ HKZZ IKZZ JKZZ KKZZ LKZZ MKZZ NKZZ OKZZ PKZZ QKZZ RKZZ SKZZ TKZZ UKZZ VKZZ WKZZ XKZZ YKZZ ZKZZ [KZZ \KZZ ]KZZ ^KZZ _KZZDl`abcdefghijklmnopqrstuvwxyz{|}~ `KZZ aKZZ bKZZ cKZZ dKZZ eKZZ fKZZ gKZZ hKZZ iKZZ jKZZ kKZZ lKZZ mKZZ nKZZ oKZZ pKZZ qKZZ rKZZ sKZZ tKZZ uKZZ vKZZ wKZZ xKZZ yKZZ zKZZ {KZZ |KZZ }KZZ ~KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl      KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl !"#$%&'()*+,-./0123456789:;<=>? KZZ !KZZ "KZZ #KZZ $KZZ %KZZ &KZZ 'KZZ (KZZ )KZZ *KZZ +KZZ ,KZZ -KZZ .KZZ /KZZ 0KZZ 1KZZ 2KZZ 3KZZ 4KZZ 5KZZ 6KZZ 7KZZ 8KZZ 9KZZ :KZZ ;KZZ <KZZ =KZZ >KZZ ?KZZDl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @KZZ AKZZ BKZZ CKZZ DKZZ EKZZ FKZZ GKZZ HKZZ IKZZ JKZZ KKZZ LKZZ MKZZ NKZZ OKZZ PKZZ QKZZ RKZZ SKZZ TKZZ UKZZ VKZZ WKZZ XKZZ YKZZ ZKZZ [KZZ \KZZ ]KZZ ^KZZ _KZZDl`abcdefghijklmnopqrstuvwxyz{|}~ `KZZ aKZZ bKZZ cKZZ dKZZ eKZZ fKZZ gKZZ hKZZ iKZZ jKZZ kKZZ lKZZ mKZZ nKZZ oKZZ pKZZ qKZZ rKZZ sKZZ tKZZ uKZZ vKZZ wKZZ xKZZ yKZZ zKZZ {KZZ |KZZ }KZZ ~KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ KZZ KZZ KZZ KZZ KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  KZZ ! KZZ " KZZ # KZZ $ KZZ % KZZ & KZZ ' KZZ ( KZZ ) KZZ * KZZ + KZZ , KZZ - KZZ . KZZ / KZZ 0 KZZ 1 KZZ 2 KZZ 3 KZZ 4 KZZ 5 KZZ 6 KZZ 7 KZZ 8 KZZ 9 KZZ : KZZ ; KZZ < KZZ = KZZ > KZZ ? KZZDl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @ KZZ A KZZ B KZZ C KZZ D KZZ E KZZ F KZZ G KZZ H KZZ I KZZ J KZZ K KZZ L KZZ M KZZ N KZZ O KZZ P KZZ Q KZZ R KZZ S KZZ T KZZ U KZZ V KZZ W KZZ X KZZ Y KZZ Z KZZ [ KZZ \ KZZ ] KZZ ^ KZZ _ KZZDl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   ` KZZ a KZZ b KZZ c KZZ d KZZ e KZZ f KZZ g KZZ h KZZ i KZZ j KZZ k KZZ l KZZ m KZZ n KZZ o KZZ p KZZ q KZZ r KZZ s KZZ t KZZ u KZZ v KZZ w KZZ x KZZ y KZZ z KZZ { KZZ | KZZ } KZZ ~ KZZ  KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ KZZ KZZ KZZ KZZ KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  KZZ ! KZZ " KZZ # KZZ $ KZZ % KZZ & KZZ ' KZZ ( KZZ ) KZZ * KZZ + KZZ , KZZ - KZZ . KZZ / KZZ 0 KZZ 1 KZZ 2 KZZ 3 KZZ 4 KZZ 5 KZZ 6 KZZ 7 KZZ 8 KZZ 9 KZZ : KZZ ; KZZ < KZZ = KZZ > KZZ ? KZZDl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @ KZZ A KZZ B KZZ C KZZ D KZZ E KZZ F KZZ G KZZ H KZZ I KZZ J KZZ K KZZ L KZZ M KZZ N KZZ O KZZ P KZZ Q KZZ R KZZ S KZZ T KZZ U KZZ V KZZ W KZZ X KZZ Y KZZ Z KZZ [ KZZ \ KZZ ] KZZ ^ KZZ _ KZZDl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   ` KZZ a KZZ b KZZ c KZZ d KZZ e KZZ f KZZ g KZZ h KZZ i KZZ j KZZ k KZZ l KZZ m KZZ n KZZ o KZZ p KZZ q KZZ r KZZ s KZZ t KZZ u KZZ v KZZ w KZZ x KZZ y KZZ z KZZ { KZZ | KZZ } KZZ ~ KZZ  KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ KZZ KZZ KZZ KZZ KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  KZZ ! KZZ " KZZ # KZZ $ KZZ % KZZ & KZZ ' KZZ ( KZZ ) KZZ * KZZ + KZZ , KZZ - KZZ . KZZ / KZZ 0 KZZ 1 KZZ 2 KZZ 3 KZZ 4 KZZ 5 KZZ 6 KZZ 7 KZZ 8 KZZ 9 KZZ : KZZ ; KZZ < KZZ = KZZ > KZZ ? KZZDl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @ KZZ A KZZ B KZZ C KZZ D KZZ E KZZ F KZZ G KZZ H KZZ I KZZ J KZZ K KZZ L KZZ M KZZ N KZZ O KZZ P KZZ Q KZZ R KZZ S KZZ T KZZ U KZZ V KZZ W KZZ X KZZ Y KZZ Z KZZ [ KZZ \ KZZ ] KZZ ^ KZZ _ KZZDl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   ` KZZ a KZZ b KZZ c KZZ d KZZ e KZZ f KZZ g KZZ h KZZ i KZZ j KZZ k KZZ l KZZ m KZZ n KZZ o KZZ p KZZ q KZZ r KZZ s KZZ t KZZ u KZZ v KZZ w KZZ x KZZ y KZZ z KZZ { KZZ | KZZ } KZZ ~ KZZ  KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ KZZ KZZ KZZ KZZ KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZ  KZZDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  KZZ ! KZZ " KZZ # KZZ $ KZZ % KZZ & KZZ ' KZZ ( KZZ ) KZZ * KZZ + KZZ , KZZ - KZZ . KZZ / KZZ 0 KZZ 1 KZZ 2 KZZ 3 KZZ 4 KZZ 5 KZZ 6 KZZ 7 KZZ 8 KZZ 9 KZZ : KZZ ; KZZ < KZZ = KZZ > KZZ ? KZZDl@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z [ \ ] ^ _  @ KZZ A KZZ B KZZ C KZZ D KZZ E KZZ F KZZ G KZZ H KZZ I KZZ J KZZ K KZZ L KZZ M KZZ N KZZ O KZZ P KZZ Q KZZ R KZZ S KZZ T KZZ U KZZ V KZZ W KZZ X KZZ Y KZZ Z KZZ [ KZZ \ KZZ ] KZZ ^ KZZ _ KZZDl` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   ` KZZ a KZZ b KZZ c KZZ d KZZ e KZZ f KZZ g KZZ h KZZ i KZZ j KZZ k KZZ l KZZ m KZZ n KZZ o KZZ p KZZ q KZZ r KZZ s KZZ t KZZ u KZZ v KZZ w KZZ x KZZ y KZZ z KZZ { KZZ | KZZ } KZZ ~ KZZ  KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZDl                                 KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KZZ KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLLDl                                 KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLLDl                                 KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLL KLLDl                                 KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL KLL KLL KLL KLL KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLL  KLLDl ! " # $ % & '  KLL ! KLL " KLL # KLL $ KLL% K& K' K R1:(  x  6CFCC@9 ],@-9 $<Run<  1 HA?? officehelp4Picture 47officehelp4yK yK http://www.officehelp.biz/officehelp/default.asp?ent=demositeyX;H,]ą'c4R =]&1`>@. J "  7f yK HELP using this macro.Help!A1yK Doesn't work? Click Here'Macro Configurations'!A1yK www.officehelp.bizyK 6http://www.officehelp.biz/yK www.officehelp.bizyK http://www.officehelp.biz/officehelp/default.asp?ent=demositeyX;H,]ą'cPyK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite3yX;H,]ą'cyK *Get the Full (Unrestricted) Version Here!yK http://localhost/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demozyK Demo Restrictions'Demo Restrictions'!A1. yK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demozyK Demo Restrictions'Demo Restrictions'!A1P"yK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite3yX;H,]ą'cM Enter valid date Invalid date!  lTADLEnter valid date Invalid Date! l}  Select location for split plans.'Invalid input. Please select from list.VSheet Workbookr  Months per PlanNumber out-of-limits3Select where to split Calendar Plans (or No Split).Please select option from list. No Split3456784 4 Enter Plan Nameofim FSelect "Make" to produce a daily calendar (with a column for each day)'Invalid input. Please select from list.isMake Don't Make' HSelect "Make" to produce a weekly calendar (with a column for each week)'Invalid input. Please select from list.Make Don't Make' DLEnter valid date Invalid date!car W Sheet1ggD YA Tu  dMbP?_*+%&?'?(?)?MPDF995S oNXLetterPRIV0''''\KhC}_" NX??&U} . @} . @} . @T                                         Z&#Plan Generator BASIC Edition - DEMO ^__________`  aGbGGGGGGGGc aNbGGGGGGGGc aNbGGGGGGGGc aNbGGGGGGGGc  aNbGGGGGGGGc h' GGGGGGGGGGc  aGGGGGGGGGGc a0 GGGGGGGGGGc a/ GGGGGGGGGGc a3GGGGGGGGGGc g2GGGGGGGGGGc gGGGGGGGGGGc gnGGGGGGGGGGc aGGGGGGGGGGc aoGGGGGGGGGGc gGGGGGGGGGGc g\GGGGGGGGGGc aGGGGGGGGGGc acGGGGGGGGGGc a]GGGGGGGGGGc aGGGGGGGGGGc g^GGGGGGGGGGc aGGGGGGGGGGc adGGGGGGGGGGc a_GGGGGGGGGGc aGGGGGGGGGGc g`GGGGGGGGGGc Dlk"."..."."...."."."."..".".."  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  aGGGGGGGGGGc !aa!GGGGGGGGGGc "ab"GGGGGGGGGGc #aGGGGGGGGGGc $g=$GGGGGGGGGGc %aGGGGGGGGGGc &aS&GGGGGGGGGGc 'aT'GGGGGGGGGGc (a>(GGGGGGGGGGc )aU)GGGGGGGGGGc *a?*GGGGGGGGGGc +aGGGGGGGGGGc ,gV,GGGGGGGGGGc -aGGGGGGGGGGc .aW.GGGGGGGGGGc /aX/GGGGGGGGGGc 0 1gY1GGGGGGGGGGc 2aGGGGGGGGGGc 3aZ3GGGGGGGGGGc 4a[4GGGGGGGGGGc 5gGGGGGGGGGGc 6g6GGGGGGGGGGc 7aGGGGGGGGGGc 8a"8GGGGGGGGGGc 9aGGGGGGGGGGc :a :b#:GGGGGGGGGc ;a ;b);GGGGGGGGGc <a <b*<GGGGGGGGGc =a =b$=GGGGGGGGGc >a >b+>GGGGGGGGGc ?a ?b%?GGGGGGGGGc Dl".."."....."."..".".."."."66666@ A B C D E F G H I J K L M N O P Q R S  @aGGGGGGGGGGc AgAGGGGGGGGGGc BaGGGGGGGGGGc Ca CGGGGGGGGGGc DaGGGGGGGGGGc Eg!EGGGGGGGGGGc FaGGGGGGGGGGc G,G H IaGGGGGGGGGGc Jg&JGGGGGGGGGGc KaGGGGGGGGGGc La-LGGGGGGGGGGc MaGGGGGGGGGGc Ng(NGGGGGGGGGGc OaGGGGGGGGGGc Pa.PGGGGGGGGGGc QaGGGGGGGGGGc R9R Sdeeeeeeeeeef ,|"."."."."".".".".".  ePH 0(  >@. *  GH RR 00 7RR yK )Back to the Main Display user interface. Input!A12   TA)L   Sheet4ggD YA   dMbP?_*+%&?'?(?)?M\\imomaia\MAIAHPIMOB04? dLetter.HP LaserJet 4100 PCL 627xe.CQqC ^GwO Qf+!D, X'܆Fb9%sZ3TFHviōr$WAP*@d;"jd:@:Zju)$e2 "I$C@hxd<^6 7£(oK.3'UH>HF/$_AH rCIzIh8Z\1hr`{`ɱĆ~>rk뛿:m{~n=;)"_@VRh6%kdhθE[ O2/h\w9}Uژh5xYxh yZVekTډ31Wgki;gbO7z333ٚ0[[J.aDnBfa? Wa+m#5EO[*9[2VX|A" PX??&U} . @                              Z&#Plan Generator BASIC Edition - DEMO ^__________` f aGbGGGGGGGGc wgNbGGGGGGGGc aNbGGGGGGGGc ahNbGGGGGGGGc  aNxGGGGGGGGc aN xl GGGGGGGGc aN xm GGGGGGGGc  aNxGGGGGGGGc hi GGGGGGGGGGc aGGGGGGGGGGc ajGGGGGGGGGGc aGGGGGGGGGGc a eGGGGc deeeeeeeeeef k ,|k"."."."88"."."6"  PH0 0(   >@. "   7d yK Retrun to Input Page Input!A18yK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite32   TA)L   Sheet6ggD YA   dMbP?_*+%&?'?(?)?MPDF995S oNXLetterPRIV0''''\KhC}_" NX??&U} . @} @} . @                                @       Z&#Plan Generator BASIC Edition - DEMO ^__________` 4 aGbGGGGGGGGc a5NbGGGGGGGGc a6NbGGGGGGGGc aNbGGGGGGGGc h' GGGGGGGGGGc  aGGGGGGGGGGc a0 GGGGGGGGGGc a/ GGGGGGGGGGc a3 GGGGGGGGGGc g2GGGGGGGGGGc aGGGGGGGGGGc h7GGGGGGGGGGc aGGGGGGGGGGc 8 aGGGGGGGGGGc h:GGGGGGGGGGc aGGGGGGGGGGc < oppppppppppq oppppppppppq lmmmmmmmmmmn 9 abGGGGGGGGGc deeeeeeeeeef >0k".".."."...."."."."."""."  ePH@0(  >@. *     7 yK )Back to the Main Display user interface. Input!A1b yK ;Check this FREE Online PC TIP on our website: (Click Here)yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=PC%20Tip&id=00004&ent=MacroHelp22   TA)L  Sheet5ggD Module1 N__SRP_2__SRP_3ThisWorkbook   !#%&'()*+,-./012345789:<>?@ABCDEFGHIJKLMNPQRSUWXYZ[\]^_`abcdefgijklnpqrstuwxyz{|}x PT5 2wD*\R1*#3e5$*\Rffff*0958e64b99*\R1*#13b*\R1*#126*\R0*#13*\R1*#54*\R1*#3e4*\R1*#132*\R1*#121*\R1*#13b$*\Rffff*0:58e64bad$*\Rffff*0;58e64bad*\R0*#1*\R0*#17*\R0*#e*\R0*#14*\R0*#15*\R0*#16*\R1*#289*\R1*#11*\R1*#a4*\R1*#32*\R1*#2d*\R0*#2*\R1*#84*\R1*#57*\R1*#51 0 0 H  h x       0 Hh "d ">@ٞPxMEl@06> LLLLP L@BDFH%@@D" @F $@J( , @N4 @PP 8 @Tx @@xH? X`x k`Zx dP` o,,0`Zt`nr`? ` 8k\i i ``( k bi `x`t `k((nI i +8`tk `Zt+`o`t`p`l`h+r`Po ""`t`p`l`h```X`nT``R `Dk""i 8iXixiʘ" Bʘ$Bʘ((Kʘ.xKʘ2B;0 @<  @>8 @B` @H( @L0 @R(<@VH@x `(( P(8PP x `8`89  0 @H t 9b@` d 9@` n@x P @@ p@ 0 A@@ Day@ JLNbPTV 8  lhp8:XRr@x  0Bt.Dvz| x~^B@H@ ` J@8 P @P @ $^@h 0 @ ove@  @ @ $@   @ @ dX@x 0@h @X curs@H @8 3 I0H(\@p (@l @h @@X @XH @p8 ?@( zC@$ E@ @ :@ 0H@x B@h @X @H @8 @( @` @`?@ ` :@` ?zC@ E@@`0@h PX@`?@@ ?h@`:@ ?@` ByD `x?R?xH`x?28:@d @0` @`P ?@L @x< @>@, @ @ @ @ @D@ Hx0`rz P ?>@zx28@@ @D@(0 @@ :@X @p @ ?@ @` @>@ @ @ @ @ @D@0 @H :@ @x @ ?@ @p @>@` @P ^?8Xx8h AE@x @h :@X @ H @P8 ?@h( @ @ @ @X ?@ zC@ E@ @p :@( @@ @ ?@ @p @` @P \?@>@L`zC?@D  x (L(L(L6W8W8*Ip   *L   *@0 2`    "  %    ( 0 8  HX `p x      3h`G  $r7 ' Th  "  2( &8H " PX  $hxA2d27 "  <<(6@X`h p6x 6 6  6( @ H P X6` x    > @ B( 0  8  @  P  ` h p x B   <p    <q ` p    B      6   <p   (  <q8  x 6f 6f     (80HP X ` p  "  : % (08;@;X6p6;; (08@HP X `) (C) OfficeHelp 2005 - www.officehelp.biz Version Code00 COMMON CODE MODULE.8\]$ 2]$x]$1ib]$8D0]$(A-]$PDE]$A00]$x2}\]$8wi] `] 8] ` ] ( P ] (x ]C5Input 8%\%^!`'<C7Input 8%\%^!`'>C9Input 8%\%^!`'@F7Input 8%\%^!`X Make'B?F11Input 8%\%^!`X Make'DC11Input 8%\%^!`'Z ZNo Split'Fd8 ZX 'FAk C13Input 8%\%^!`'H\>'J'L F'N @$bG'PcG'Pj`B, Store full calendar length before splitting> >'T @'VoP On Error Resume Nextf l h(jB] 8'Z p.8 p.:A@X'R rG|j 0 BA@tDL'Zk . D ZDL :.8A@XkHA@vWK'Zk( Z(Macro execution stopped by user request.  z . WWW.OFFICEHELP.BIZ - Calendar Plan Generator$x'nlan GedN MsgBox Err.Description, vbCritical + vbOKOnly, " WWW.OFFICEHELP.BIZ - ERROR"ceHekf   ekoP col = "C:F" $B@H  (oP]0H \!'Sheet '  \B@ $\B@H $\ $\B@SH $\B@H  $\(7vo`   %(l   %(R  %BcIj 9 9 9q(  %*=Q 9 9 9q  %0$% 9 9 9q  %u2c 9 9 9q   % y 9 9 9q@  %9& 9 9 9qk7 Selection.Borders(xlInsideVertical).LineStyle = xlNone 9 Selection.Borders(xlInsideHorizontal).LineStyle = xlNoneox]  R'Z Zyber$'Zroot.c Z'Rk0 Z'i 8]xYB 2Input 8%\%^!`X '.com 2 'F' ;FbB Input 8%\%^!`X 'k  ';  'C+ 'i]0H`C73]xH4`' >X @X wThe main START DATE for calendar plan (Cell C7) greater than its END DATE (Cell C9). The calendar cannot be generated.  z WARNING - Invalid calendar dates$x'nt'dB 2Input 8%\%^!`X '645Z 2 'F'427061  B Input 8%\%^!`X 'ga  E Input 8%\%^!`X'&F Input 8%\%^!`X'w   ]jThe START DATE for task 'G Input 8%\%^!`X  ' on line  g is greater than its END DATE. The task will have no calendar bar. Press OK to proceed, CANCEL to stop.   WARNING - Invalid task dates$x'n80801Z n 01Z0'E $^B@HkPkHk@  '&!  'k 'ri Set Print AreaTa  $!:  $! !(Colum !veWi999999? h%9? h%9 h%9rD  h%9LeftFo? h%9? h%999 9 99 99.PaperSize = xlPaperA4eade 9 999 9"9$q@o89Please select at least one calendar type: Daily or Weekly z | . WWW.OFFICEHELP.BIZ - Calendar Plan GeneratorA@xCalendar Generation Finished. ~ ~NThis macro is a member of www.OfficeHelp.Biz full family of Calendar Products. z | . WWW.OFFICEHELP.BIZ - Calendar Plan GeneratorA@xHNAttribute VB_Name = "Module1" ' (C) OfficeHelp 2005 - wPww.oTh*. biz ZVersion Code"COMMON CODE M ODULE.PublicLnst MaxDemo Tasks~13D Day2"7Wee>49a ItsA_ZTru \Cal-5=-1771I.WK+DL StartuRow 18NewBook As Workb, This MainNInputPlan(Sng,  STDa EDMakeDailyA!lean AHplitByMonthsALo LayZp6@pene|rap8 H 6GeFinished." &PCrLf"1\ macro is a membPw of.Biz3@fam f 7 rpcts.EE  >:r\P<<18h%Q;h= Mr(`g execu@ stopped by usreqzt Excla cooh1`G0P% > 0 ' L.Descr ip a"CritiPV?" ERROR!ZQ;(U6ColumnWi@dth(cl, wN0 ' col"C:Fsp).S04wVwps0GCre Outp(˨XL6Q 3[a0= bs.b P16Hs.Add ,+!wA(bLMove After:=bs(VP/me/ (D D]Border(w, iԹdrs(xlDiagonalDown).LineStylQxxlN@N!UpnWiЂ'"gEdgeLeftCon0uous#"Weight%B'orIndex@xlAutow(ColorIndexpAuto maticDEnd If i pThenzInsideVerKal5 &XxlThi;] _WHorizX/IfC['҂Y VNone_=A!Sub @ FunB CountTasks() As Long Dim aux= NR C0 CReal pD@ II G' A 03G0On Error Resume Next:&?String, ll2cntA)= "" & C@(B@sBook.Sheets("Input").Range("BStarb0Row).Valuel= @ + 1: a= 0&Whig<<>CllKa G Wend!B@;@ :heckaDateT*lea :X::_sd 9ED+ = MsgBox("` main START DATE fZcal-ar plan (Ce0C7) gre&r thits ENDd9).!w cannot be generd. ", vb ExclaonPvbOKOnly, "WARNING - Invalid d s"#Fals$#E&!DYiii "jjA~5Q "<<ӜUc *=#FF"EF_ Q.KKF }@ >;-i--tyi 'UUsUG 0Y"' `+lЕ 1 is22s1wi#have no-bar. Press OK to proceed, C ANCEL!stop.34OKCancel33RϾ3ivbs_"J= x7di"c;\uz  Tl^dAb:@ede*beaF/eHSubЗtP0~tRAQ(a\bc_^ Lt`.ic0SAveR~.PageSeptup. !Ys(a, b).Addb#& ":(c, dcb.Lef0tHeaP`""Center=`.ǯFooMargpk= A`pplicInchesToPos(0.75b3 Topoo1Bot0?ooj#oo0. R%as<=S'Grid N Comm!xl"No5/$ly.s&E/ .OriRxlLand0scapDP" .Draft'5@perSizCPPrA4H Firsta7NumbenrODown1iOverBlackAndtZoommFit0,`?,sW161 .FitToPagesTall = 1 End With ,Sub <lhqhlpqplhqx8(Yt,d`L<KpR^6'': /N0:@0N00^qT60pRyp:.#*F0%:@%_  dAK#*1t2)6 0 qp qh lt=yq:.lp#*F0%:@%_  dAK#*1t2)6 0 lt=Vf:1lp#*F0%:@%_  dANt`/)6 0f:2lp#*F0%:@%_  dANtX/)6 0 o`oXT3lp#*F0%:@%_  dA'P'p:4N15:K#*#6*#lp#*#7*F^qT2 )60pPlTRpR8'@%1lp#*F0%$ /50lhqhlpqpkRpz,(YtL0pPT ih%iH%x$ Xx(A8:9i%i%$ XA8%$ @W`:C;)x6(`%x$ @xW(:PPqLx:h%lLC<:h%lLC=:h%lLC>:h%lLC?:h%lLC@:h%lLCA;D ?x$ x oDkh%lLCBx;D ?x$ x oDkh%lLCCx6D 9x$ x oDkh%lLCDx6D 9x$ x oDkh%lLCEx;D ?x$ x oDkh%lLCFx;D ?x$ x oDkh%lLCGxfh%lLCHfh%lLCIh%lLCJfh%lLCKfh%lLCLh%lLCMfh%lLCNh%lLCOh%lLCPfh%lLCQfh%lLCR(h%lLCS(h%lLCT qL8T(YP4 x(`C$ `x8#x58&Dh%x $ x$xQx D`$Y xH8$lp$ p 0llqxp%lx#h*1t/hA$ '(%lxi8%'H%'X%p$ p ()p$2$ltFX%p$ p d$#)p$d$lxiX%p$ p dQ$o %ltFH%rU T$`$`,`0&(`0,!`/#$I`$q`$`8`((((rU~|  U  9 a  ) I i 9  1 Q iq Q9 Y1Y 9aq9Qi I!Y I!a!iQ ) i $L:P%`:d%t_ t d`0A ` )t`60 L:P%`:d%t_ t d`0A O)t`60 L:P%`:d%t_ t d`0A O)t`60 W:P%`:d%t_ t d`0A K# 0 /)t`60 W:P %`:d%t_ t d`0A K# 0"/)t`60 I:P %`:d%t_ t d`0A `1x)t`60 lx 0 $ lxP$L:P %`:d%t_ t d`0A `()t`60 , 0$4%Md@0 0(P]350 8 8 @ H?`(Yx t`0 TKv% x$ x <xCtx$ HQxx$ HQx  <    Ct " lt0   Ct lt0+3'':@N00@:`NPP 6P0tG'':`N00@*#*#*FP 26P0$ xx !lx7'':@N000:`"NPP^pr6P0$ xx !lx (t(xP0`2 Fh%x$ `x8#x58&Dh%x $ x$xQx D`$Y xH8$lp$ p 0llqxp%lx#h*1t/hA$ '(%lxi8%'H%'X%p$ p ()p$2$ltFX%p$ p d$#)p$d$lxiX%p$ p dQ$o %ltFH% $  d&')p 5 2$ltFX%p$ p d$#)p$7 FH%$ltFX%p$ p d$()p$0p(Yt$hp$  D6h %x $ x()qxh%lC*h%lC+h%lC, q6h %x $ x()qxh%lC*h%lC+h%lC, q D<Y$x(l< <qtlt. ^-qt lt<ltqxA<$Y 8Kp: .#d*F<%L:P%`_ ` dLAK#*1t2d)`L6 < qp qh lt=*q: .lp#d*F<%L:P%`_ ` dLAK#*1t2d)`L6 n<jxٞ#<ړ-KJ*ZGF;MNx;MNÕړ-KJ*ZGME(SLSS6"N0{00020819-0000-0000-C000-000000000046}(%H` %& %`h8@HH02wD$*\Rffff*0<58e64c274xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2rU i222 /42 3__SRP_8`__SRP_9"BSheet1$~__SRP_a 6 `rU @n<jxٞ)#<LGp  F!KILKx!KILKLGp ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %( %`h8@``02wD$*\Rffff*0=58e64c274xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU q333I34-.`rU @n<jxٞL|#<*[TmOi(6A Fo"Kw jx__SRP_b;BSheet4 =~__SRP_c O__SRP_dTBo"Kw j*[TmOi(6AME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %* %`h8@``02wD$*\Rffff*0>58e64c274xAttribute VB_Name = "She@et4" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU !.3I.I34-.`rU @n<jxٞ#<o),.ERFCK FSheet5V~__SRP_eh__SRP_fmBModule2i@DFGtSKj*x@DFGtSKj*o),.ERFCKME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` %, %`h8@``02wD$*\Rffff*0?58e64c274xAttribute VB_Name = "She@et5" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU 0q.3.I34-.`rU @nrU $*\R1*#132*\R1*#121$*\Rffff*0958e64b99*\R0*#13*\R0*#e*\R0*#1*\R0*#17*\R0*#2*\R1*#13c*\R1*#13b*\R1*#126*\R1*#289*\R1*#11*\R1*#2d*\R1*#285*\R0*#f 0 0 &H "p x &  "    0H  ,`  9 %4^(j@("     "(&0Xx      @I!RٞxxMEH@> LL LLLXL2`@H R` k00'`0x`2t`4p`6l`8d`:\`<T`>pL%\`J ke`V@Inpu`X8`X `ZX0C11`\. %^`@( T`x XkaaW`0x%^`2t'J`4pN`6l`8d`B`:\lend`Xitti+|@``kppi B`p`h`dX`\`X`VH`P`L D`J `D *`P@`>9 C`8 the`4not +~`hk;;(i 8`t `pF`l`h`d$F`\'6`TX'`P `L`6H >`@': `k44c i ji('ZiHih0i( SiH '2i$ji(Sheei,`x.4`tSH`p `h@.%@ph x hF*:8@>Dr@D x @ 4 C@ $ % Do@  $^@  J @8 ` FJLH~Nx@ h@P l@ !@  9r@ x@ In@ '@ "@ | @( l N@@ \ In@X L @p < 0j@ , 4@  l an@ t @ @  PRT$^B@H`Hx0 0 F*>@FJLHan@  C9).@  J @H A@@ @ 0@` TD Move rs@ @ 3 I0`xH0H8x@P<JH^4^@`T @xD X'@@ T DA@0 X @X $@ 6' @ X'@ @ @  6@ t Da@ `$8 dtz("|$@ $bx$^@` $@ `%'c@ 0.@`.`N$~P@p @ @ @ @| @l @h @d @0` @H\ @X ( h8P`|x(>@D($FJ@h$ @ @H @6 @0 @ @ @ @ @x 8bt2@ @ @  @xx @(t`@@r @Pl h( @h P @8X x"@`T`"PP&`L8J^dLP@P @L @< @P, x8,@x(``,@ @ @ @ @ @( `@6@ `h(E@ PS@`xS@ ``kHxx`(@0x`~xx>@D($F28@0 @p @0 @ @ @X @ @ @ @ @ @ @ J"@ @H @` @xx @p @h P h8@` pHDJtF@xX @H @8 @( @X @ @ 0@ @ @ @ p@`@ @`8@ ` "Hd h2wD$*\Rffff*0:58e64bad*\R1*#3e4 H Xh p+4Y 0V(0+P p    4^$ ( 08 @ "H&Px   &2E (186P  h $A6_   ( 0 8 @  H P  *X h p  x +    &A 6_   (  0 8 @ H  P X  *`  p  x  +            8 @ X  `   *p F   @  8   H 1`  x    4=  4= 0 8 7X  :p *  B  & 0P  X h<x    ) (#@XAh2+ %<g *    ( *8$Vh E *    )B8A *     )  + :X`hpx    4  (08@ H P Xh p/A *     1   ( +8H&HP :x       ( B 0 8 Xx   -  ( (0 80YP<q2a.X0Y(X0Yx& = "(8 +HX *` =p ! %4:<r<r02bp.Y0Z0Z(X`   "  .H`x  C6   8H C` *   $ $ &  # !8 *HX` hpx   ) (C) OfficeHelp 2005 - www.officehelp.biz Version Codek DAILY PLAN SPECIFIC CODE MODULE On Error Resume Nextib Create Calendar]@Xp0] h(B Define Split limit: F'@ @ * G *'@j @G *'@j% Check if calendar fits (Max Columns) :.8Dd @X >X$DX '6 >X':Hd * :$F'8d 8$J 8$L$H$F': 6 * @ *The requested calendar has 6 days. Excel sheets have only 256 columns and 3 are used for headings. The maximum calendar length is therefore 253 days. For a starting date of  : the maximum finish date is  8. ~ ~DProceed automatically splitting calendars every last complete month? N  WARWNING$x'6 6 PGA@Rjd0 6 F  F A@RdA@Tkko]Xp]0]H`x'F'\ Define Split limit F'@ @ * G *'@j @G *'@j9 Calendar loop - while the set finish date is not reached >X'< @X'> <'X >X':d @ :$F'8d 8$J 8$L$H$F': :'Z \ X'> Z'@A@Tdd Z$FX >X$DX '6d Z$FX':d @ :$F'8 G'\j 8 > >'8 >':dPd 8$J 8$L$H$F':k 6 @G'jd Z$F'X :'Z <'> >'@o]0H`]x Select Output Sheet <'2 2GOutput'2j CreateOutputSheet NewSheetName J HWorkbookG ^!.4j 4B@`SH 4%\B@H  2 4%\( Set Generic HeadingslARQ@A@RBA@TaskB J $^(`(B J :B J $^B@H  d9b d9f9h99j9l9nq !p99 t9rq !v(x zA@C(\@A@% DoneC J $^(`C J :C J $^B@Hrs  d9b d9f9h99j9l9nq !p.Lin9 t9rqx !v(x zA@ Insert Daysroot.c$'40 ( 4 "G "'4jk 4$|'0 0 N G 0'Nj Insert Tasks%\ ( 0 $G $'0jk 0$~'4$ Insert General and Headings Bordersput  J $ 4 J  0 P $$^B@H zA@ J $ J  0 P $$^B@H zA@4` Freeze Taks D:D$B@HATE  (ar pla Set Print Areaan HSheetl C9). 4 J  N P  A@RNINd 4 J  0 P  A@k Move cursor to top^!$B@H3 Increse Start Row for next plan (if in same sheet) HSheetG J 4  'Jjo] 8Ph]]!`]( >X']j @X'ART DAd  $DX '6 ( 6 $^ $ '6' d 6 $FX'eater kk'F'F'da  6 proce Insert Day. d  $F'  'es J $B@H01Z0 $b ($^ !v(x (@ $ $G0'cG'j !p@ 9 t9rq A@h$ If weekend, draw vertical gray line5  $ $  cD%T  J $B@H !pv 9 t9rqk Insert Month Name 2  $L 'TI Input 8%\%^!`  $J'(T J $B@H !p,9 t9rq8  '  ( ' !v(x   J $ J  $$^B@HFi  d9b 9f9h99j9l9nq` ' A@k@ k8  6 J $ J $$^B@H?  d9b 9f9h99j9l9nq A@q0k  Insert Week Number X $G'jvF J $B@H+c !p$ 9 t9rq  ''W L (' L 'L !v(xk $  6 q J $ J  P $$^B@H  d9b 9f9h99j9l9nq k A@\M 6'|i @]]0H`x] Get Main Dates >X'6D @X'( d  $DX '6 ( 6 $Mld $ $FX' MsgBox edate k k  Get Task DataG 2Input 8%\%^!`X 'B 2Input 8%\%^!`X 'C 2Input 8%\%^!p!'D 2Input 8%\%^!`'E 2Input 8%\%^!`X' X X G 'j5F 2Input 8%\%^!`X' ' X X G 'j% 2 'F'F'% $  J $B@H  ( X 6 !v(xd X B@  J $B@H0 (( 0% ( kH   X X X X   XA@ 5G Input 8%\%^!`X 'B Input 8%\%^!`X 'C Input 8%\%^!p!'-D Input 8%\%^!`'E Input 8%\%^!`X' X X G 'j%F Input 8%\%^!`X' ' X X G 'j#  '%  '  ' (  "G'jk(  '~i] 8PJ( Check if task is within calendar limits   G|j" X   G|jJ   G|j6 Draw task barF%d  $D 'd  $D'6   0 'd 'k MsgBox stCol, , endCol'  AK    J   $B@H !p  9 t9rqXd $F'8d $F'5 MsgBox cntDate, , RealTaskEDatep  c % $YWD (m !p%9 t9rq  d9b 9f9h99j9l9nqHk@k8k0o( Attribute VB_Name = "Module2" ' (C) OfficeHelp 2005 - wPww.oTh*. biz ZVersion Code"DAILY PLAN SPECIFIC CODE MODULEHSub MainDL()DOn Error ResuNext CreaCalenda@r Dim9xDays As Long, NewSheetSMaxLidne)Au :FWC2D,/Start2'Then== 0 C ' Check if cm fi8(,lumns|2Set@isBook@WorkbEk= Abs(CLng(AZDiff("d", CR(?ED)SrT)) v=ID  u@%8Add@O- >1BzSerial(YearD-Bn1<-1rCqAndq>ql4[GSMsgBox("@: requested5has P" & &dn. Excel sams have only 2 56 coB; a3 are u s fzhead ings. maximum @{gth is tPhere e 3 CFa sq`of1/" `gs@ /:@.Avb0CrLf"Proce aut (1 a)) aE>{gE! q!MakebB"`AIfh EeK aIh? , flaglea@;CurrA5ƁTQF 2 ``*b= Truxe: Cxdddf 9Hc-dtUk E% loopAhileb>sc,>notLachedTz^e7Jds 1! `!= aIe/ei-PhoeQoee 1p,(r UW2%=CDu LDWC ga; ~)CWteROn:q o_oңfD= _=ءA4  >IQG WNI,o o_?)Q a bc0<*w Z)(OFߋcWnS0e¸f0p @qМtp_ebS_ϔcrpq2' QSllQg# ' Select Out= CePllanf+"/"`! C2zCount0 OrҠLayer"Ɵs. #.Activ[s(1).[t2= t Gen`¸c H CRHWid"A`2X.29B3Range("B!b4 + PlanCount).Value = "Task" Range("B" & ( D":06 ).S electWith  ion&.HorizontalAlig nment|xlCer(Vertic&WrapTexDFals"eAOriTat b0AddInd ShrinkToFi)MergeCelDlsTru7E8nd y1 ~.InterionAColorEx'15QPatnxlSolid 8.F`.BoldOMakeBorder xlMedium, >Set@"umnWidm"C", 5.164DCA% Done {.Kf=OX ..@ EB'InsAt Days#MaxLineacAs()If ItsADemop The &>= `"!  AaIfcǀ_cADL('> GlobalLb C} GB Ac  b#!@7c'  General aHeadings $7c|+v, 2), !v#`@E+ Extra=)k²Jn_ls(ٽY& & Freeze Tak#ãs("D:D"ActiveWindow.Pa`K2 Pt Ar eaHnputSplitByL ay`SheeI "C .6s q9SubD Fun on689ml As Long) Dim sd(ate!Dp, 2endK, auxalfS97`Qg1ncoxsweek1, wflagBooleaX!mnSt)g, o w1, s ll2%6c= C (TdsTEDAyeAbs(CLng(Diff("d ))Og7%YiANl1 - 1!1+  $k @":= D:#= ԙF@0@!= 0 To t_ %%2={te , |ll b$0l6l:5P2, ?;QrmulaR1C1P6 (!7cCY3= 3 W /46 1 Or  7CA 48 Qro5lg  lThinjf >end, @draw vT gray l_)_GqSs'2'm!q z@ʂ"1ooBA /Ne794M@8h NRQ= (jAj-22/ cW=hisX|k.biRc"IEU& "& YearT*p:rcol).Sel@ect With ih    i/ !"#$%&'()*+,-.0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSUVWXYd[\]^_`abcTefgmjkl|opqrsuvwxyz{n}on.Interior.ColorIndex = 15 :Patjn4xlSolid>End "If oname <> mTh enoActiveCell.FormulaR1C1_"'" &76 1R=Font.Bold$True !Ln` > 4 IKR ange(Ks(4 + PlanCount, s, *- 1~)*‹K. HorizaalAlignmentdxlCe؁Vertic @BottomW@rapTexFalsIFOriYat!0Add*YShrinkToFiMerg†sq'OE-i d,MakeBorder xlThin, ,IfG ll(AuxDays)PxT]n.?G*.F.>F.E .?E~.D6A&@@=' Insk Week Numbp@day(aA(te)B2A wpflagW6+AU߶߶bk.=h'c/swY = okعWN%$o`'+ 1+߽ 8WAs56 Or Jy y7")%p;=Extra@_{`_{h=xlOa3=փE==_=g =+=o>y^NogSC>\DLpT] QFuno TATasksDL(maxQAs Long) Dim MANPStpg~,2H`(, )2U, cu'SDate1q=E/@DeadlinÅSRealj ' Get@ Main QsSsdA = C1(InputST)eEDu= Abs(CLng(Diff("d", 3q))T=ItsADemo;%>= x1a>? a,SMaAC /' MsgBox)#!a" @( sBook qeets("B")."GU StartRow).ValueGA&= "CABU%=iO tCEh&*DR 25)_[E?Y%!) <./>r 4he("F;:I r) 4 /rq%l1:I= 7:I= dWhile'""s2ll20H211G ABR0= E~Wb!XC+('3֗3E!aQ"0%HEnd If DrawTaskBarDL maxcol, ll2, CDatPe(sd)4e 4pSJ>"E"Color, DeadlineJReal.Name = "" & CStr( ThisBook.Sheets("Input").Ran ge("G.ll).Value)A RIndex/SB/)n)LC"Interior.IR *DL #7!OEJMIfgdz <Å ThenwK#Bxf#FU# %G ,) >,,AX+ 1B c= Mavx1s% EaHWendKCI`nsert@=  Function APSub ~(~ As LongtnumB:{, &!? #A+Je@ ]|i< RDim staC@!llga/' Check if t is within cal ar limits*f[< C!^Exit )!>d$'%p'51bar # = B4@QAbs(aDiff("d",7B)y%= OF`Uc),=cElseQ Z' M sgBoxC<, yLnd;#D<=LkFo7lq0 To caCells(A[+ PlanCount&J+).SelectKW D i.Ÿa @@oD7Ce.Pat`nxlSolilzwK ->Addy>1,}A= Nex4-TZ9W ;- UCase(?) "Y"K 1AKve.mulaR1C1!D"v3OB1q.HorizontalAlignmeRexlCe#i.V^iK+B`ottomrW0rapT@!Fa :"D.Oriac0.'Oj  r@inkToFR= Mergs UQ9p"[`1__SRP_4 '__SRP_5oModule3q__SRP_6Z'vi$%lPi%$ X#52\M$@ B$ (,5+c$% $ W4C55%($% $ CV\M$@ D (]/\M@ D (]/60pV&pV* $ W1xxqtkVD$%ltC2$%ltC3 qt+r 65V\M$@ D (]/\M@ D (]/64 dhEl4vi$%lPi%$ X#5* $ W1XXqTkVD$%lTC2$%lTC3 qT 4fh)(\M$@ Up>6Ek>#P*F%L:$F%"X ! d"LGAH:I\M@ <`1D/P)L6 <Avi$%lPi%$ X#5* $ W1,,q(($%l(C2$%l(C3 q( l@lD=)JlD*F%$ (,5lDC@+c$% $ W4C55lPvi$%l8i%$ Xvi%lPi%L$ XL$ )L6 $ Q$%*$%+f$%,($%-f$%.f$%/ c$%0clPq8+r 65lXi$]3vi$%l8i%$ Xvi%lPi%L$ XL$ )L6 $ Q$%*$%+f$%,($%-f$%.f$%/ c$%0c+r 65(\M$@ D (]35'pJAvi$%lPi%$ X#5* $ W1qkVD$%lC2$%lC3 qkJ? lPqL1KvL#P*F%$ (,/P5pJvL{L+c$% $ W4C55H\M$@ D (]/lXi](/5 vi$%lLi%$ Xvi%lPv>i%L$ XL$ )L6 $ Q$%*$%+f$%,($%-f$%.f$%/ c$%0c+r 65 Xf "qx LY4 xX,D@4 PL< y 0 y -0  FqH6lH(09  N 6YM#*F%: F%"X ! d"GAHK1t/)6q:'#*F%: F%"X ! d"GAHK#*1p2)6 a7#*F%: F%"X ! d"G=1rU~| W9 x! &y&&Y' (%1!! $$$Q y(((p 9 1 )!)I)i))*QA*q***a+9+Y+!y+++I!+ Y),' a ' ,,9Q,,-Ii-Q-8" D$ D DvqHlHJ qHlHb qH v9yy$  Fql6$yt\%\M4@9 $ $Otd5$^dM4@$ dM@ U$U (B9  Ot\6 $lllH'' :<N,,4ll#*#*F$o\4:od:::|l:\L^ql26$lL, ll 1"llvv& / kh8(YtDD$lL, pJp.vq(l(6 q(l(N q(ytTytLoTt8yt\+\M@l(9  Otd5YdM@ dM@ UU 9  Ot\6o\t0k.o8~o0~ V0M@9  oLN  Fql6 (0M@9  Nt\6+\M@l(9  Otd5 kJp. odoLoLtdoLt\S^dM@ dM@ UU (B9  Ot\6  lll(hpJ$0M@9  Ot85o\t0oT~oL~(Yt LvCt lt0Ctvv0d.@ 'D%T$ T (Q@ T " X 0!1@(D%T" X !T d"@#)T@6ltF0%@(D%T" X !T d"@$)T@ RQ@+%C &/+'C &/A:0(%T'D%'v#*F%$ T,/T5_T'D%'v#*#)*#v#*F%$ T2T5T $ QTD%*D%+fD%,(D%-fD%.fD%/ cD%0c*T $ TW1qT(D%lC2D%lC3 q+cD%T $ TW4C5T5+ 65 (\@+7C &/A:08%T'D%7v#*F%$ T,/T5_T'D%7v#*#9*#v#*F%$ T2T5T $ QTD%*D%+ cD%,(D%-fD%.fD%/ cD%0c*T $ TW1qT(D%lC2D%lC3 q+cD%T $ TW4C5T5+ 65 ^:qplp  qp p^;qx lxv<lx{<'lx' qx x^=qpviD%( %T$ XTlpvi%lxv>i%@$ X@lhl$ h)T@h6l+ 65viD%( %T$ XTvi%lxv>i%@$ X@lhl$ h)T@h6l+ 651:D?%T$ `Tl#T5lcD%T$ DT,T v@0G=v<v>YXlpvY\Y`Yd A=lxv>YXlpvY\Y`Yd A7(D%( %T$ XTl#T5l v@0vlp{@$8Y t0 T@hld ytpyth<pM@hM$@  Fi6($]Z ($)pM$@B9  Nth6C@pJ q8X"d #XM$@mp  Ot\5lXqPAA2"qP/)6XN#*F%: F%"X ! d"GAH`1L/)6YO#*F%: F%"X ! d"GAHNt\/)6o\0N~ 0Ot\YP#*F%: F%"X ! d"GAHNtT/)6oTt@oTN OtT ql qh qd lp==lhvi %(%$ X#5"ltF %$ (,lpP+c % $ W4C55m*lpD % $ Q=lhvi %(%$ X#5!( %$ (,%: R% $ S:o@hLPoTpo\xNɀ0NɈhl T$r:Mll#*F%: F%"X ! d"GAHK#*1t2)6 r:'ll#*F%: F%"X ! d"GAHK#*1p2)6 b7ll#*F%: F%"X ! d"G=1A2"qP/)6YNll#*F%: F%"X ! d"GAH`1L/)6ZOll#*F%: F%"X ! d"GAHNt\/)6o\0N 0Ot\ZPll#*F%: F%"X ! d"GAHNtT/)6oTt@oTN4 OtTlhqhllqlldqd{ld {Cpldqx%8Y p0Lt,`     /C(lMH@lMX@ 8 8("qx686lMH@l MX@ 8 8("qt58 thth lt  pltdCviX%lxlpi%$ X(#5(* $ W81q$iX%lC2X%lC3 q$hMX@9 8 8Oth58 pf$hMX@9 8 8Oth58 oh, #l(MX@8 U8:HV]358 !:XN%$ (,* $ W81q(X%lC2X%lC3 q $ QX%*X%+fX%,(X%-fX%.fX%/fX%0c(0Y8(R`$`$`(`!((!`1(PI`$1Iay((,,,,(0,nrU $`$`$#11*\R1*#2d*\R1*#285*\R0*#f  0 0 (H &p "  &  "   &0 X  p 8(  , H 9X x(%4^,n("    "&0P p   8(  @ P `p x+4Y 0V"A$Xٞ>xMEH@> LL LLLXL2`@H`@D `h k00/`0x`2t`4p`6l`8d`:\`<T`>L *`J The `V@as `X8el s`Zp0colu`\. or h`@0( cal `Pkhh_`0x fin`2t`4pProc`6llitt`8dlast`:\N `X'+p`@kQQi `p`h`d`\`X` V`P`L`J `D`h@`>`8`4`80+`hk;;i `t`0p`l`h`d`\`T`P`L`6H`@ ``kCCS i 8iXixiiXix i$i(i,`x`8t`p`h`f ```\ `xk i@ i` i`` h` `` \`Xp08 %p  @ 0 hNFVT*:@@ @p 0 8@>DFJLH@X @  @ @ @ @ @` @  @ @H ( ~NxP@x @ @ x @ h @ X @ H @ 8 @ ( @8  @P  @ @ x`H8 F*>@FJLH@P @h @ @ @ @ D@ @ Hx0`(X@ <JH^4^@T @D @h@ @0 @ @p @ @P @ @ @ @H `dtz("@p 8@`` @ `H%@ p.@`.N&P@ @ @  @8 @| @l @h @d L@` LO@\ @X @(T @P @x(XPX`00`x>@D(&FJ@H @ @ @6 @p @ @ @ @( @8 Lt2-@  @ @h @`@~ @L8J^d@x @t @Pd @T @D h'@@`H'@0 @ @ @ @ @X `p01@ `X@Lx00H`xX0>@D(&F28@H0 @( @` @@ @ @ @ @p @X @ @ @ @ hJ"@ @ @ @0x @Hp @h P8hP0H>@JtD@L @XH p0@8D (X@@ @0 @ @ @ @p @ P@``8X@ @ )@( )Fd+@ @0@`h(0@ `P4@  hP0@l @DF@H @8 @( @0 @  @ H @ @   2wD$*\Rffff*0;58e64bad*\R1*#3e4*\R1*#132*\R1*#121$*\Rffff*0958e64b99*\R0*#13*\R0*#e*\R0*#1*\R0*#17*\R0*#2*\R1*#13c*\R1*#13b*\R1*#126*\R1*#289*\R1*(8+X x    4^$(0 8@ H "P&X   &2E 0 1@ 6X  p   $A 6_   ( 0 8 @ H  P X  *` p x  +    &A 6_  ( 0  8 @ H P  X `  *h  x    +           ( @ H `  h   *x F   @  @   $P x F       1 (  8 P6=h6= 7  : *`  B &    <0P X  h )x*# # ?  @ P *` A .# + %  *   ( 0 @ P )h B A *   )(@+H X:h    4(`hpx      B   ( 0 H X-h  (  0Y<q02ap.X0Y0Y(X`& = " + * =  !@ %P`4:h<r<r2b .YX0Z0Z0@P` h  "  .(@  Xp2 6   (08  @P Ch *     *  C6 ( 8@ HP X $p $  #! *  (08@HP X`h p B x    6 &(%@ X h x 4M     ) (C) OfficeHelp 2005 - www.officehelp.biz Version Code! WEEKLY PLAN SPECIFIC CODE MODULE Adapted from the daily versionb On Error Resume Next1B Create Calendar]@Xp]: h(B'@ Adjust GlobalMaxDays for Weeks N X 'N Define Split limit) F'@ V T V$' @ *  G * '@j @G * '@j% Check if calendar fits (Max Columns)@, :.8e ed @X >X$DX '6 >X':,@,d *  :$F'8d 8$J 8$L$H$F':@, 6 *   @ *Yb The requested calendar has  weeks. Excel sheets have only 256 columns and 3 are used for headings. The maximum calendar length is therefore 253 weeks. For a starting date of  : the maximum finish date is  8. ~ ~DProceed automatically splitting calendars every last complete month? N  WARWNING$xX '6 6 PGA@jdX 6 F  F A@d A@kko0]p]0H]`x'F'\ Define Split limit F'@ @ *  G * '@j @G * '@j9 Calendar loop - while the set finish date is not reached >X'< @X'> <'X >X':d @ :$F'8d 8$J 8$L$H$F': :'Z \ X'> Z'@A@dd Z$FX >X$DX '6d Z$FX':d @ :$F'8 G'\j 8 > >'8 >':dHd 8$J 8$L$H$F':k 6 @G'jd Z$F'X :'Z <'> >'@o]0H`x] Select Output Sheet <'2 2GOutput'2j CreateOutputSheet NewSheetName J HWorkbookG ^!.4j 4B@` 4%\B@H 2 4%\( Set Generic HeadingsARQ@A@BA@TaskB J $^(`B J :B J $^B@H  d9b d9f9h99j9l9nq !p9 t9rqx !v(x zA@C(\@A@% DoneC J $^(`C J :C J $^B@H  d9b d9f9h99j9l9nq !p9 t9rqp !v(x zA@ Insert Days$'4 ( 4 "G "'4jk 4$'0 0 N G 0'Nj Insert Tasks ( 0 &G &'0jk 0$'4$ Insert General and Headings Borders J $ 4 J  0 P $$^B@H zA@ J $ J  0 P $$^B@H zA@ Insert border over each month  0  J   $ 4 J   $$^B@H zA@ Freeze TaksD:D$B@H ( Set Print Area HSheet 4 J  NX P  A@dX 4 J  0X P  A@k Move cursor to top$B@H3 Increse Start Row for next plan (if in same sheet) HSheetG J 4  'Jjoh] 8Ph]](]@X >X' @X'x>d  $DX '6 ( 6 & & '6d 6 $FX'k`kX'F'F'F'  6F Insert Dayd  $F' $  6  '  ' # Insert week number and format cell J $B@H L (+ Insert week number in cell !v(x (' !pF 9 t9rq A@ L 'L Insert Month Name 2  $L '4I Input 8%\%^!`  $J' J $B@H& !p9 t9rq  '  ( ' !v(x   J $ J  $$^B@HE  d9b 9f9h99j9l9nq ' A@k k  6 J $ J $$^B@H"  d9b 9f9h99j9l9nqX A@k@ k8 0 'i p]0]H`x] Get Main Dates >X' @X'd  $DX '6ղ ( 6 &d & $FX' MsgBox edatek k  Get Task DataG 2Input 8%\%^!`X 'B 2Input 8%\%^!`X 'C 2Input 8%\%^!p!'x>D 2Input 8%\%^!`'E 2Input 8%\%^!`X' X X G 'jF 2Input 8%\%^!`X' ' X X G 'j 2 'F'F' ײ  J $B@H  (4 X  !v(xd X B@  J $B@H3 (0% (k   X X X X   XA@ G Input 8%\%^!`X 'B Input 8%\%^!`X 'ZC Input 8%\%^!p!'3D Input 8%\%^!`'E Input 8%\%^!`X' X X G 'jx>F Input 8%\%^!`X' ' X X G 'j  '  '  ' (  "G'jkxp 'i`]8Ph]]( Check if task is within calendar limits   G|j   G|j   G|j Draw task bar  > @$'  > @$'   'subtract start col to make len  '! add heading columns on the sheet    'd 'k    Z  J   $B@H !p 9 t9rqPH$ Add Deadline Marker- Reloop as daysd  $D 'd  $D'@޲    'd 'k  ݲd $F'pd $F'&   $YeD ( !p%9 t9rq  d9b 9f9h99j9l9nqkkko]     Initiate flags' Calculate number of daysd  $D' Iterate finding the right week  d  $F' X X  'ydx $  G  'jk80 'i Attribute VB_Name = "Module3" ' (C) OfficeHelp 2005 - wPww.oTh*. biz ZVersion Code"WEEKLY PLAN SPECIFIC CODE MODULE%Adapted from the dai0ly vN# Sub MainWK()kOn Error ResuNext CreaCalendar Dim9xDays As Long, NewSheetz S MaxLine Au FinD2,/Start ((a!- 2)@2Then = C' 0= 0 C' Check if cD fin'Alumns/Set@isBookvBorkb= Abs(jCDiff("d", C(N)CO) #'X?$WAdd S,B[ l Serial(YearA#BFK1-Q`4(#>) And C=!@dC):CX,",MsgBox("`? re0ques9ha`s " &"JY&wx. Excel ss h@ave on2 56 coB? a3 are ustheadings. ma`ximumG`g th isreze 253 dF a s!ofe2@" y@` d?.AvbCrLf"Proce@autom`@#c`itt!E%s ey la`@comple@m!?`WvbYes$No vb&laa on, "WARWNING")dI4>5b8 AJsWK:E&,E1#fO)Fi>F! q!MakeOե3"AIfh E!__r;/op/o/ote, flaFgxNleaCurrAqq}_*a tFP2j >S2= True: I' mmmP*Iiic ii!hloophi4le@sh|@not`Oachedōce9HJzKqCSP `$tei# - 1i61}- OiQOie} 1Il*fW2'?F"v LDWF 7S/(a; )WOxt  x jo¶a2>b#bE?1 5u>9qG DIN)&o a??)Q0, a Qde0!<ς*Z= \Z)"+$cWpS0Uոf0_r)wsOe1eSO4fBFpqGUCnlli# ' Select Out CTgPlanmf`"/= "Outpu t" ' @CreateSheet New! NameIf PlanCount = 0 Or InSplitByLayer0"Workbook" Then SB":8s.AddXj.Activ s(1).Select_0'Generic Headings PColumnWidth "A", 2.T29B3 Range("B"@ & 4 +)@.ValueH"Task ( ":#(5 ${WiPionB.HorizontalAlignmexlCerVertic WrapTexAzFalsĀOriat 70tIndM ShrinkToFiMerg@eCellsTruEnd C5.14#DC% Done GGG%B3GCG׿GJgG.F.EEEB'Inst DayMaxpLineac¯As ()ItsADemoa- &>= `CϦ#AaIfcA_cAWK('> Global"Kcb _C} GWeeksF&b ,E+CcDw)c' b4al a Cd7|Bkv`), av@%#`(+@ Extra)ϫn_ls[g O  %bSovSeaPch m0VhF or ll&0 To q& - Z1 o ԉ,xll14Ax w 'Nq Y' Freezep Tak0Es("D:D"{eWindow.yPac>P tt AS1 "2㗃 h 4, 6% o' 2CLng(:;)P%(2Eoovf$.G :' M0# cursP"to top41,P"ʢuIncrese Start Row fnQp (if in s sQ&o +@hg+AW%6s Sub FunonTE.Hml As Long) Dim sdP!Dp, endZ, auxap5Bog1nco, swU1, wflag1pleap!mnStp*g, o w ll2q[Bo0t u!= CAz(TE*DAyuAb s("/Diffx("dP A)~)!?w"%ie/|saN#11K $ U3S+":= F: s= 4: ICKYF]+Qe'=te& ",]`1+(Tj)_11(`)}'*` Ix ;Ljp+ 1 2/numb'}Bmat cPsGz, Q oe c_A`rmulaR1C1` Nq `I1whWidth = 3 Cel@lColor15 lWiSelection.Interior H.IndexGPPatDn%xlSolida #End u MakeBorder xlThin, False %`NWeekX+ 1  ' Insert Mo"njNamwn col (StartTaskRow - 2) +(auxDate) FThenK )AAveA7.FormulaR1C1R"'ADO =CǫFz .Boldfru | *Q > 4^ (A Coasa, B- 1)SiAKk3 .Horiz4alAlignment6hxlCeV ic Bottom WrapT'Ss1q=E/fDeadline2! SRealj' GePain QssVd}@C1("{STT~eEDu= Abs(CLng(Diff("d", d, r))T`?ItsADemo ?%>= Max1sA qp/cphc2-@' MsgBox'C1Aa"= C(G}iԐ&= "B^Br%=iC%F*DR 21EY %-Á) < #c)%">r5F[: r) 43r 0rt:B:I= 6:I= TWhile' ""s23uM+ ȷ2?ϬĬ11G aBR) 0"GEЯWcb!XC+('B3q NumberQa"0%HE!Draw Barmje03+#!#.S$#g?%;)$C AMHODHDNllM%??82N? b,M#:"Input").Range("C" & ll).Interior.ColorIndex TaskDeadline = ThisBook.Sheets( DValue PSDatCC(IE I)JIf GAS) <sdb)en WrFEFFFReal4'X) >Xe X# 1!ll2+ 1 cnt  ItsADemoGGAz@A >= Max1sRB"" @End IfW8endGACInsertWK% Funct ion ASu@b Draw BarWK(maxcol As L ong, numtq, L@CW?A ƻ Stl1YA#  WeekFlagAlean,z LA&C NDaysA CY' Check if t@ is within Hcal#arPmhits2fc!< C)Th Exit 1)>d,7'-p# '=bar(= 2&( , ST&EDd.lnd5= -:'subtractart Qto make *kc+ 3 ' add h`Gumns on the s#oG1!ieFdElsȫG ht#|<=`l4 F oElu0 To"!Cells(Er+ Plan@Count,D'+SelectKWR fϋa @4o$EeP.PatnxlSoli 1G Nex' A 7Marker- Reloop as day/$hW4Abs(SDiff(X"d""!7,g)V1= XAbaIG2H[$$h&_1#ol1, XKb-pP[.1 UCaseFŵ)$"Y"r AkveA0.0mulaR1C1!Dq@/Җ[/3O/_/%HorizontalAl ignmeBxlCeO8.V~ig+BottomrWrapTs8Fa*M"D.hOria0.%q  0}kToFn= Mergs UQ2Ӑw EpSearch2!q, CalSti^p94Յ, aux]Ж&љ 'xitiyg fdPQz= 4alcp1@ber ofS?O qOI_indQvuright wSH% e1teHlllBWB37W!r Y(Ph(= 1@) Or (P= U$=֤`VPay.   $ GpV* $ W5qkVD %lC6 %lC7 q+~ :5vF{F)(\M @ Up>6Hk>#x*F%t: I%" X % d&tJAK:L\M@d dT`1D/x)t6 dTAv i %lPi%$ X'5* $ W5DDq@( %l@C6 %l@C7 q@ l@lD=)MlD*F%$ (,5lDC@+c % $ W8C95lPv i %l8i%$ Xv i0%lPi%t$ Xt$ )t6 $ Q %. %/f %0( %1f %2f %3 c %4clPq8+~ :5lXi ]3v i %l8i%$ Xv i0%lPi%t$ Xt$ )t6 $ Q %. %/f %0( %1f %2f %3 c %4c+~ :5 Xfl0qx@Y(DD@4 xtdT y 0 y -0  FqH6lH1(009  N 6YN#*F%: I%" X % d&JAKK1t/)6q:+#*F%: I%" X % d&JAKK#*1p2)6 a;#*F%: I%" X % d&J=5A6"qP/)6XO#*F%: I%" X % d&JAK`1L/)6YP#*F%: I%" X % d&JAKNt\/)6o\0N~ 0Ot\YQ#*F%: I%" X % d&JAKNtT/)6oTt@oTN OtT ql qh qd lp==lhv i %(%$ X'5"ltF %$ (,lpP+c % $ W8C95m*lpD % $ R=lhv i %(%$ X'5!( %$ (,%: S% $ T:o@hLPoTpo\xNɀ0NɈhl U$r:Nll#*F%: I%" X % d&JAKK#*1t2)6 r:+ll#*F%: I%" X % d&JAKK#*1p2)6 b;ll#*F%: I%" X % d&J=5A6"qP/)6YOll#*F%: I%" X % d&JAK`1L/)6ZPll#*F%: I%" X % drU~| X9 qx! &y&&Y' (%1! 0 $$$Q y(((p 9 1 )!)I)i))*QA*q***a+9+Y+!y+++I!+),Y' a ',9Q,,-Ii-Q-h" @$ @ @v{vqH0 0"qD50lHz qHlH qH v 9y y 0  Fql60y t\%\M @9 0 0Otd50^dM @0 dM@ U0U (B9  Ot\6 0lllH('':8N((4lD#*#*F0o\ :od:::xh:XH^ql260hH(ll% a"llvvV _ Jh(YtD@0hH(pJp.vq(l(6 q(l(N q(y tTy tLoTt8y t\+\M@l(9  Otd5YdM@ dM@ UU 9  Ot\6o\t0k.o8~ o0~  V0M@9  oLN  Fql6 (0M@9  Nt\6+\M@l(9  Otd5 kJp. odoLoLtdoLt\S^dM@ dM@ UU (B9  Ot\6  lll(hpJ$0M@9  Ot85o\t0oT~ oL~ (Yt , vCt lt0Ctv v!"0d.@ 'D%T$ T (#Q@$T "$X 0%1@(D%T"$X %T d&@')T@6ltF0%@(D%T"$X %T d&@()T@ RQ@+)C */++C */A:0,%T'D%+v #*F%$ T,/T5_T'D%+v #*#-*#v #*F%$ T2T5T $ QTD%.D%/fD%0(D%1fD%2fD%3 cD%4c*T $ TW5qT(D%lC6D%lC7 q+cD%T $ TW8C9T5+ :5 (\@+;C */A:0<%T'D%;v #*F%$ T,/T5_T'D%;v #*#=*#v #*F%$ T2T5T $ QTD%.D%/ cD%0(D%1fD%2fD%3 cD%4c*T $ TW5qT(D%lC6D%lC7 q+cD%T $ TW8C9T5+ :5 ^>qplp  qp p^?qx lxvlx{'lx1' 1qx x^@qpv iD%( %T$ XTlpv i%lxvAi%@$ X@lhl$ h)T@h6l+ :5v iD%( %T$ XTv i%lxvAi%@$ X@lhl$ h)T@h6l+ :5Xlxd`v iD%lXi %T$ XTlpv i%lXi%@$ X@lhl$ h)T@h6l+ :5 Xf`1:DB%T$ `Tl'T5lcD%T$ DT,T v!C0*=vvAYPlpv YTYXY\ Di=lxvAYPlpv YTYXY\ D7(D%( %T$ XTl'T5l v!C0v lp{ ,8Y t0 T@hlly tpy th<pM@hM @  Fi6( 1]Z ( 0)pM @B9  Nth6C@pJ q8 q0X"d#XM @mp  Ot\5?\M @ E (]/lXi]/5l0qPl0q0Av i %lPi%$ X'5#vFi %$ (,+c % $ W8C95%( %&JAKNt\/)6o\0N 0Ot\ZQll#*F%: I%" X % d&JAKNtT/)6oTt@oTN4 OtTlhqhllqlldqd{ld {Cpldqx8Y p0Lt,     /  lL L"qx5L  l L L"qt5L ltlxqtlxqx thth lt pltdDkCv i0%lxlpi%@$ X@'@5*@ $ @WL5q@$i0%lC60%lC7 q pfDC(lM @lM0@ L L"qx6L6lM @l M0@ L L"qt5L ththpltdH$hM0@9 L LOth5L pf$hM0@9 L LOth5L oh,#l(M0@L VL: W]35L!:0O%@$ (@,@*@ $ @WL5q@(0%lC60%lC7 q@ $ Q@0%.0%/f0%0(0%1f0%2f0%3f0%4c(0Y@LL  qh6lM8@lMH@ ( ("q\5(Xl\d%lMH@lX9 ( (Ot`5( o`lhqh?`MH@( E ((8]/lXl\6(lhqh XfU lhiHl (Yl(M__SRP_7vSheet6~~__SRP_10__SRP_11B`(`!((!`1(PI`$1Iay((,,,,(0,0q` Aa,,,n<jxٞ#<H5J^& FH!G( g.xH!G( g.H5J^&ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@``02wD$*\Rffff*0@58e64c274xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU `.3.I34-.`rU @n粀0* pHd CalendarPlanD $ Gene_VBA_PROJECTtdir__SRP_0__SRP_1X (MakeBorderI-i`BordersC"xlDiagonalDownJ@ LineStylewxlNone xlDiagonalUp xlEdgeLeftL xlContinuous[Weight1 ColorIndex xlAutomatic@ xlEdgeToph xlEdgeBottom xlEdgeRight%vxlInsideVerticaljMxlThinwxlInsideHorizontal (CountTasks[(CountRealTasks TaskIndexqll^ll2cnt+sd_ed]flag vbOKCancelx?vbCancel' (SetPrintAreanaXcZd[ ActiveSheet%N PageSetup PrintAreaPCellsAddress LeftHeader CenterHeaderD RightHeader LeftFooter CenterFooter RightFooter|S LeftMargin]InchesToPointsI RightMargin[ TopMargini BottomMarginu HeaderMargin8 FooterMargin PrintHeadings)nPrintGridlines@ PrintCommentsxlPrintNoCommentsCenterHorizontallyCenterVerticallyI Orientationw xlLandscape&Draft:FirstPageNumber%OrderAxlDownThenOver BlackAndWhiteZoomFitToPagesWideFitToPagesTallZ ThisWorkbook| Sheet1 Sheet4 Sheet5 Module2cMaxDays NewSheetNameMaxLines/AuxDays MaxFinDate MaxStartDateUInitDate} FinishDate4MaxNDaysK4 DisplayAlertsDateDiffDateAdd/6 DateSerialUYear6nMonthvbYesNovbYesa?(ProceedDatesDL(MakeCalendarDLpCurrDateH NextStartDatedNextFinishDate{Flag2n WorkbooksBActivate|HorizontalAlignmentS@xlCenterVerticalAlignmentʡWrapText} AddIndent2W ShrinkToFitA MergeCellsکInterior;PatternixlSolid7nFontUBoldxlMedium (InsertDaysDL# (InsertTasksDL8a ActiveWindow+ FreezePanesMzmlB^sdate\edatendays auxDate_ CellColorncolsweekwflagW%mnameonameMwnamecolscolH ActiveCell FormulaR1C1SWeekdayxlBottom?maxcol5TaskName_ TaskSDate\^ TaskEDatec TaskColorq TaskDeadline! RealTaskEDatee InsertIndent- NumberFormatR (DrawTaskBarDLOlinenumֶstColendColwcntDatePRUCase5  Module3d MaxNWeeksaa(Day2Week(ProceedDatesWK(MakeCalendarWK  (InsertDaysWK (InsertTasksWKc WeekCounter (DrawTaskBarWKQWeekFlag'WeekLen=NDayCols\s SearchDate/ CalStartDater^ CalEndDate|k Sheet6 Worksheet_DefaultjNumber-_B_var_AuxDays _B_var_sdateIp _B_var_edateu _B_var_UCasea ' ) +-/@b Bb,0a ,*\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications&*\G{00020813-0000-0000-C000-000000000046}#1.9#0#C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXE#Microsoft Excel 16.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation4*\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.8#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLL#Microsoft Office 16.0 Object Library .Calendar Plan Generator2wDٞModule10958e64b99Module1xD@ThisWorkbook0<58e64c27'ThisWorkbook Sheet10=58e64c27) Sheet1)0 Sheet40>58e64c27+ Sheet4L|H Sheet50?58e64c27- Sheet5`Module20:58e64bad.Module2xxRModule30;58e64badModule3>X Sheet60@58e64c27 Sheet60xH`^zL}H V*MiQcClVzO^^RSAD4GHS1.7Ɲ+tJє-}[P@`e R fzMdU}T_84J b Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# CalendarPlanstdole`Officeu Module1b _Evaluate (MaxDemoTasksҙ (MaxDemoDays (MaxDemoWeeks(ItsADemo" (MaxCalDayst (MaxCalWeeks\(WK_(DL\ (StartTaskRow(NewBook,Workbookk(ThisBook-3 (MainWorkbook (InputPlanName (InputSTDate (InputEDDateI(InputMakeDaily'6(InputMakeWeekly_(InputSplitByMonthsS(InputSplitByLayeri (PlanCount͎(NWeek/ (GlobalMaxDaysu](ExtraDay(NRTasksp(RealInputSTDate(RealInputEDDateǠ(GetInputValues;auxuSheets Range ValueKDay(Main, handleCancel\ Application*EnableCancelKeyxlErrorHandlermsgQActiveWorkbook(CheckTaskDatesM(MainDL'(MainWKMsgBoxRvbOKOnly vbInformationnvbCrLfErro vbExclamation(SetColumnWidthcl\wmColumnsp9 SelectionZ ColumnWidth(CreateOutputSheet( NewName# LastSheet!c SheetName6Count0vAddrMove>yAfterrator@.8alendr PEa G.eDr2to1=   2wD"<+9stdole>QstqokeP h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysWOW64\22.tlb#OLE Automation0EOfficEOficwh E2DF8D04C-5BFA-101@B-BDE5EA*AC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE16\MSO.0DLL#P 16.0 Object Libra,ry'}ٞ@Module1GmduY1 2 (HB1BrD@XB,BT!B+BBsThisWorkb@ookG@TAtisWkbok!M 2 $$"B#$ASheetBS@#e@wtAG2B/I)4GL4@<%44L|U 5 5 5 5 b< 'K2/K.2@/K2RY8x+K 3333X>56m+6@m+6 qUi+VrU~~{ a     Calendar Plan GeneratorclwNewNameiabcdmlmaxcollinenumsdateedate TaskSDa calendar bar. Press OK to proceed, CANCEL to stop. 8WARNING - Invalid task datesAddress :PageSetupPrintAreaLeftHeaderCenterHeaderRightHeaderLeftFooterCenterFooterRightFooterLeftMarginRightMarginTopMarginBottomMarginHeaderMarginFooterMarginPrintHeadingsPrintGridlinesPrintComments $CenterHorizontally  CenterVerticallyOrientation DraftFirstPageNumber ' OrderBlackAndWhiteZoomFitToPagesWideFitToPage~sTall d 6The requested calendar has J " days. Excel sheets have only 256 columns and 3 are used for headings. The maximum calendar length is therefore 253 days. For a starting date of  8 the maximum finish date is  .$ Proceed automatically splitting calendars every last complete month? WARWNING        )   !  I     @ Output WorkbookF A Task :B &HorizontalAlignment "VerticalAlignmentWrapTextAddIndentShrinkToFitMergeCellsInteriorPatternFontBold C % Done :C D:D 'W  ( ` DInsertIndent 0%NumberFormat Y   DF Worksheet*[TmOi(6Ao"Kw jo),.ERFCK@DFGtSKj*H5J^&H!G( g.K & weeks. Excel sheets have only 256 columns and 3 are used for headings. The maximum calendar length is therefore 253 weeks. For a starting date of ړ-KJ*ZGF;MNDFWorkbook @FLGp  F!KILKK* rU~~~~~~~~~~~~~~~~~~~~~~~~ 53dY@D2+ a p q )Iqa )3 a )31a )3Ia )3aa   1Yya 8 1 Y a )3  CalendarPlanModule1 ThisWorkbookSheet1Sheet4Sheet5Module2Module3Sheet6FHC:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLLVBA  0F?C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXEExcelMainDLProceedDatesDL  @0FC:\Windows\SysWOW64\stdole2.tlbstdole aPL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLLOffice Ai`GetInputValuesMainSetColumnWidthCreateOutputSheet MakeBorder CountTasksCountRealTasksCheckTaskDates SetPrintArea T (MakeCalendarDL InsertDaysDL InsertTasksDL DrawTaskBarDL MainWKProceedDatesWKMakeCalendarWK InsertDaysWK InsertTasksWK DrawTaskBarWKDay2Week C5 InputFF Range Value C7 C9 F7 Make F11 C11 No Split C13VBE7.DLLBorders   PFFy F  DL WK rPlease select at least one calendar type: Daily or Weekly \ WWW.OFFICEHELP.BIZ - Calendar Plan Generator :Calendar Generation Finished.  Name) This macro is a member of www.OfficeHelp.Biz full family of Calendar Products.fĤIx8< PMacro execution stopped by user request.y p  S     SelectColumnWidth Sheet AfterMoveLineStyle WeightColorIndex B= The main START DATE for calendar plan (Cell C7) greater than its END DATE (Cell C9). The calendar cannot be generated.  @WARNING - Invalid calendar dates E F 2The START DATE for task ' G ' on line 5 is greater than its END DATE. The task will have note TaskEDate TaskColor TaskDeadline RealTaskEDate SearchDate CalStartDate CalEndDate 2 -#Module1Module1ThisWorkbookThisWorkbookSheet1Sheet1Sheet4Sheet4Sheet5Sheet5Module2Module2Module3Module3Sheet6Sheet6PROJECTwmPROJECT @SummaryInformation(#DocumentSummaryInformation8H ID="{00000000-0000-0000-0000-000000000000}" Module=Module1 Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Document=Sheet4/&H00000000 Document=Sheet5/&H00000000 Module=Module2 Module=Module3 Document=Sheet6/&H00000000 HelpFile="" Name="CalendarPlan" HelpContextID="0" Description="Calendar Plan Generator" VersionCompatible32="393222000" CMG="B7B51B5665BA98BE98BE9CC29CC2" DPB="EEEC42AF4ED198EE98EE671299EEF9B1F922B87F6751B8614C30885C7DE3CE41DB4D166FC12082" GC="252789E4F71AF81AF81A" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Module1=22, 22, 554, 462, Z ThisWorkbook=66, 66, 613, 506, C Sheet1=132, 132, 679, 572, Sheet4=0, 0, 0, 0, C Sheet5=0, 0, 0, 0, C Module2=22, 33, 906, 631, Module3=66, 99, 943, 697, Sheet6=0, 0, 0, 0, C Oh+'0HPl www.OfficeHelp.BizAlexandre PinhoMicrosoft Excel@| h@L=@  ՜.+,D՜.+,| PXl t| ; SiteApps InputHelpDemo RestrictionsMacro Configurations'Demo Restrictions'!Print_AreaHelp!Print_Area"'Macro Configurations'!Print_Area  Worksheets Named Ranges  8@ _PID_HLINKSA@ `L_1>http://www.officehelp.biz/officehelp/default.asp?ent=demosite\ Vhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite3|)'Demo Restrictions'!A1ZQhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demo|)'Demo Restrictions'!A1h>Hhttp://localhost/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demo\Vhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite3L_>http://www.officehelp.biz/officehelp/default.asp?ent=demosite7-http://www.officehelp.biz/AP'Macro Configurations'!A1%tHelp!A1  Input!A1\Vhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00043&ent=demosite3  Input!A1BLZhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=PC%20Tip&id=00004&ent=MacroHelp2  Input!A1 FMicrosoft Excel 2003 WorksheetCompObjkBiff8Excel.Sheet.89q