ࡱ>  -bdq{,  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry FF k=@gWorkbook31K_VBA_PROJECT_CUR"10P//WVBAPM YA\pAlexandre Pinho Ba= *(,)+ ThisWorkbook=`T6)8X@"1HArial1HArial1HArial1HArial1HArial1HArial1HArial1 HArial1HArial1,HLucida Console1 HArial1HArial1 HArial1HArial1. HTimes New Roman1 HArial1 HArial1HArial1HArial1 HArial1HArial1HArial19HArial1 HArial1 HArial1 HArial1HArial1 HArial1HArial1*h6Z Calibri Light1,6ZCalibri16ZCalibri16ZCalibri1ZCalibri1ZCalibri1<ZCalibri1>ZCalibri1?ZCalibri14ZCalibri14ZCalibri1 ZCalibri1 ZCalibri1ZArial1ZCalibri1ZCalibri1 ZCalibri1ZCalibri3#,##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"0.0                /  /  /  /  /  /  /  /  /  /  /  /  .  .  .  .  .  .  .  .  .  .  .  .  #  '   ) ff     ,  "   P  P !  !  %   ( ` $  +    &    - a *  @ a" "x  "x  h  `@ @   d@ @   ` "p@ @  "P  D  d  `  d  "x  `@@  `@  `@  `   ` @   `   `@ @   d@ @   D  `@@  `@  `  @  `@  h  `   ` @   `   `   h@   h@  a"  a"  @ )p@ )p )p  )x@ )x )x  "x  h  h a"@ a" a"  a" @  a"  a"   h  h  "x@  a" a"@ a" a"   a"   h@ a" a# a!  @ a"@ @  "x  a"   `  h  a" "x a" "x a" "x  h!@ @   h!@ @   h!!@ @   h@ @   h@ @   h!@ @   `!@ @   `@ @   `!@ @   `!@ @   `!@ @  "p!@ @   d!@ @   `!!@ @    h@ @    h@ @    h!@ @   p@  p  p  !x !x !P P  x  x""@ @   x@  H  x""@ @   x""@ @   x""@ @ 7  x""@ @  !x !x  @  `@ @ "p@ @  d@ @  `!@ @ (p!@ @   x  a!  h  `@ @   `@ @   `@ @ <  `@ @ 9 a!  x x@ x  h  H  h@  h@   x  ` a!@ a!  x x   d""@ @ + a#""@ @ +   h@  h  `@@  `@  `  @  h@  `  `   `@  ` @   `   `   "x"@@   "x"@   "x " @  a"@  !x a! "x@ @  "x@ @  "x!@ @  "x@ @  "x@ @  "x!@ @  a"@@  a"@  a"  @  a!    0 a!@ a! a!  a""@  a*@ a* a*  *0@ * *0 a* *x   x  P !x a"@ a" a"  "x !x@ @ + !x!@ @ + x@@+ x@+ x  @+ x @ + x + x + !x!@ @ + !x!!@ @ + "x@ "x "x  !x@ @  !x!@ @  "x@@  "x@  "x  @  a" a"@ a" a"  "x@@  "x@  "x  @  !x"@@ + !x"@ + !x " @ + (p@ (0 (0 (0@ a" a! )p@ )p )p  a*@ a* a*   x ||&@(p}-}= * #,##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` InputConfig EHelp2'Demo Restrictions5Macro Configurations BEMHS_, Main OutLookTest  ;E   ;   ;   ;  ResetTaskList RestoreMSG SetMSGfVf@ @@;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  @@    Starting Date Closing DateTasksLevel Task NameColorName Month NamesJanuaryFebruaryMarchAprilMayJuneJulyAugust SeptemberNovemberDecemberOctoberDeadline Start DateEnd Date 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.%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.www.officehelp.bizSplit bySplit every (months)|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.~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(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.Calendar Plan PersonalizationOXClick here to PERSONALIZE your Calendar Plan (Fonts, Colors, Month and Weekday names, & )Outlook Interface SettingsCalendar Plan PERSONALIZATION+Make your Calendar Plan look like YOU want./Replace the words on the yellow cells with yourImport from this Outlook FolderDeadline Marker Tasks Level Tasks ColorYes% DoneResourceOptional Fields"Fields Always Included on the PlanIncludepreferred names.Define Column Widths%Office Tutorials & Software SolutionsKSpecializing in easy-to-use Calendar & Planner Solutions and FREE TutorialsFont Header Background color and Font#Task Name Background color and Font)Optional Fields Background color and FontCalendar Area Background color.Calendar Area weekend color (Daily plans only)&Define COLORS and FONTS for your Plans4Insert the desired width on each column yellow cell.corresponding Plan area.(of each identified Cell to customize the$Change the Background color and Font Deadline marker background color Plan Type#Import Completed Tasks (Tasks only)3Import Tasks without Start / Due dates (Tasks only)NImport Contact info (Protected by Outlook, user will need to grant permission)No'Define OUTLOOK ADVANCED import settingsSheetCalendarInclude Levels;Include Excel Default Gridlines on the Output Calendar Plan5Define Global Formatting for the Output Calendar PlanAllPrepare BudgetCollect Last Y Spendingy ConsolidateCategory Allocate Team Preparations ExecutionTests Sub-Test 1 Sub-Test 2DUse Start / End dates on Task bars (Monthly / Weekly Calendars only) Demo Plan MAIN_TITLEMAIN_END=Configure Message Box Texts - ONLY WORKS FOR CUSTOM EDITION@Define HOW Month Names should be identified on the Calendar Plan What are Monthly Calendar Plans?Monthly Calendar Plans are calendar plans with a column for each separated month in the calendar main interval. This gives lessdetail but produces compact calendars for larger periods. Better for really large periods, when the "big picture" is important.What are Yearly Calendar Plans?!Can I make all calendars at once?3Can I import Tasks lists from Version 3.0 or below?Yes. Just copy/paste the task list into version 4. The fixed columns are the same, so it will work. You CANNOT import the optional6fields because they didn't exist on previous versions.$What is the "Include Levels" option?Pinclude all tasks. With this filter, YOU choose what level of detail to include.iConfig sheet. You can also define (On by default) that for Monthly and Weekly calendars the start and endFdate are used instead (Deadlines will be in (), like (19) for day 19).!What is the "Reset Tasks" button?will be PERMANENTLY ERASED.What about the Optional Fields?VThere are 3 optional fields that can be used or not. Their label<s can also be changed:@Resource: For the task resource, usually the person name or code ;% Done: % field for the % of task done. Usually 0% at start9Category: Task category, in case tasks can be categorized ZIt is possible to change both 3 labels by entering new labels into cells I35, J35 and K35.JIf they are set to "Exclude" then the column will not be used on the plan.(How to Import OUTLOOK Calendar and Tasks{To import Outlook Calendar or Tasks, all you need to do is to run the macro on the PC where the Outlook you want to sync isinstalled, and with the same account. For most cases, all you need to do is select the source and press the "Import Outlook" button.ZImport from this Outlook Folder: Select the source for import: Calendar (default) or Tasks Task Color: Color to use for the task bar. All Outlook imported events will have this color after import. You can manually change it. bTask level: Level to use for ALL Outlook imported events. You can manually change it after import. hDeadline marker: Letter to use for ALL Outlook imported events. You can manually change it after import.:There are also some ADVANCED SETTINGS on the Config sheet:%-3mImport Completed Tasks: For Tasks only, define if tasks already completed should be imported. Default is Yes.Import Tasks without Start / Due dates: For Tasks only, define if tasks without a defined Start or End date should be imported.'{Import Contact info (Protected by Outlook, user will need to grant permission): Define if the Contact info of the Calendar O&Can I personalize the POP-UP messages?Only on the future CUSTOM EDITION or SOURCE CODE EDITION. Changing the messages on the Config sheet will not work on this version.7What are the customization options of the CONFIG sheet?eMonth names: Month names used on the calendars. Can be changed to personalize language or to shorten. WThe macro will copy, for each area (Headers, Optional Columns, Plan,& ) the cell formatsbGridlines: If Yes, the resulting Plan will have gridlines. Default is No, with a blank background. Deadline Start / End Dates: If Yes, the deadline maker for tasks on the Monthly and Weekly calendars will be its date like (dd).*Outlook: Check details on the title below.A completely new style of calendars. They present full years on matrix of Months vs Days and therefore need no external legend for thetasks. But it is a very convenient format for year long events like meetings, holidays, vacations and long plans like software roll-outs.If you have a Task list with several levels (0,1,2& ), it will not make sense to use all tasks on all calendars. In a Monthly or Weeklycalendar it may make sense to eliminate the details and use only top-level (0,1..) tasks. On a daily calendar, it makes sense to The Reset tasks button will delete ALL tasks on the task list. Therefore, you have to confirm TWICE the action. All existing TasksqIf it has a letter, it will be used on the last day of the task. You can personalize the background color on the \These columns are optional because they can be disabled by changing cells I34, J34 and K34. `The CONFIG sheet allows for several customizations of the Calendar Plans generated by the macro:dColumn Widths: Change column widths for the columns, so that you don't have to manually adjust them.^Backgrounds and Fonts: Here you can decide how each area on your Calendar Plan can be colored.Yin Background (all) and fonts (where indicated). Try different colors to see the results!|events or tasks should be imported. This will trigger an Outlook protection and will require the user to manually accept it..JThe month names can be changed on the appropriate Config table, if you want to use alternate ones (foreign languages, shorter,...)Y Sub-Test 3 Sub-Test 4No SplitCalendar Generation Finished.NThis macro is a member of www.OfficeHelp.Biz full family of Calendar Products.PLANACCPlanningHRImplementationTEAMJohnLiz7Yes, of course. Just select "All" on the Plan Type box.!)2Lin each case is used. Split By (months) will work for individual plan types.'WARNING: On Free DEMO Editions, the All option disables the Split By (months) field. Instead, the optimum selection for the Plan Demos<MDemo 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:A- 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 date8- Monthly Calendars are restricted to 7 months (columns)Q- Yearly calendars are restricted to 2004 and 2005 - will not produce other years+How to get the Full (unrestricted) Version?<Simply download it from OfficeHelp.Biz website on this link:)Get the Full (Unrestricted) Version Here!Return to Input PageRESTRICTED DEMO&Click here for a list of restrictions.+Click here to get the UNRESTRICTED version..Click here to configure the ADVANCED settings'Plan Generator Vs4.1 - ADVANCED EditionH 2006 WWW.OFFICEHELP.BIZ - Calendar Plan Generator 4.1 ADVANCED EditionmCustomize these messages to create YOUR OWN personalized Calendar Plan Generator! Only on the CUSTOM EDITION! OfficeHelpC WWW.OFFICEHELP.BIZ - Calendar Plan Generator 4.1 ADVANCED Editiond dd,ee hjS|n Dq s vxez{z{tE}X~NR_O q$zߗ5vcc: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 : Ӳ߼1y Q )q&0I9BK!Ui^gpAzьa9Y1y Q!*3)=qFOYIbkt!~iŝͣթݯ %-5=EMU ]emu"}(. 48=cB+GKPUKZ_chkm3rv{Ss;˦[#  dMbP?_*+%&?'?(?)?M\\imomaia\MAIAHPIMOB04? dXXLetter.HP LaserJet 4100 PCL 627xeK/CQǣ ,,|JZ$64z%D* b#%'ounC#1ߜ9Vm.=@~9J+AP*@dI2Ch -d:K$Ex2 NAgʎ"{WN ]0h/BQwDK'*o$$#w/~$ dp$=C-(amkm0PE[^8U9<"_D IVh6%gdh޸E[º WN2/h\w9}Uژh5xYxh yZVekTډ31Wgki;gbO7z333ٚ0[[J.aDnBfa? Wa+m#5EO[*9[2VX|A" dXX??&U} @} @}  @}  @}  @} t @} E0@} E@}  @} . @} t@} .@} . @: 33 3 3@ 33@3Z@3@3K@3 3K@ 3 3K@ 3 3 3 3<@<@  K@K@K@K@  hNNNNNNNNNGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGGG2 OPPPv d7 AQ G DL q RGQLDLLRGQ~ K @ DL | RG <  QMDLkRG Q~ K@ DL y RG c   QDDLkRG  Q l D> L | RG d  QDDLLRG  Q mw D= LLRG  STTTT c- w  GGGGGww Py   xyyyyzy R ^____{wCCC  Sy noooop   n Z }L W\ ntLRG n~ ~? Y tL xG   ntLRG n ~Q Xtk   nt} n  ntttop qrrurs    D$ lz$6Lhhh>H@4$*4JhT2  !" #$%&'()*+,-./0 1 @2 3 4 5 6 7 8 9 : ; < = > ?   B ^   !_! !` ! ` ! `! ! " " " " " ""\ "\ " ] " " "~ #E#U #H#F@@F@@ #E}#G~ #@@ # # #~ $E? $H$F@@F@ $E~$G~ $(@ $ E $ $ ~ %E@% %H%F@F@@ %E%G~ %F@ % E % ~ &E&HFFEGE &~ 'E' 'H'F@F @ 'E'G~ '@ ' E ' '~ (E?(U (H(F @F@ (E(G~ (@ ( E ( ~ )E? )UH)F@@F@ )E)G~ )@ ) E ) ~ *E*UHFFEGE ~ +E+U +H+F@F0@ +E+G~ +@ + E + ~ ,E? ,H,F @F@ ,E,G,Q? , E , ~ -E@- -H-F@F@ -E-G~ - @ - E - ~ .E@ .H.F@F@ .E.G~ . . E . ~ /E@ /H/F@F@ /E/G~ / / E / 0EG~ 0 0 E 1EG~ 1 1 E 2EG~ 2 2 E 3EG~ 3 3 E 4EG~ 4 4 E 5EG~ 5 5 E 6EG~ 6 6 E 7EG~ 7 7 E 8EG~ 8 8 E 9EG~ 9 9 E :EG~ : : E ;EG~ ; ; E <EG~ < < E =EG~ = = E >EG~ > > E ?EG~ ? ? E D lLb~~4~t*~x~tt444444444444444@ 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 [ \ ] ^ _ @EG~ @ @ E AEG~ A A E BEG~ B B E CEG~ C C E DEG~ D D E EEG~ E E E FEG~ F F E GEG~ G G E HEG~ H H E IEG~ I I E JEG~ J J E KEG~ K K E LEG~ L L E MEG~ M M E NEG~ N N E OEG~ O O E PEG~ P P E QEG~ Q Q E REG~ R R E SEG~ S S E TEG~ T T E UEG~ U U E VEG~ V V E WEG~ W W E XEG~ X X E YEG~ Y Y E ZEG~ Z Z E [EG~ [ [ E \EG~ \ \ E ]EG~ ] ] E ^EG~ ^ ^ E _EHFFG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHFFG~ ` ` E aEHFFG~ a a E bEHFFG~ b b E cEHFFG~ c c E dEHFFG~ d d E eEHFFG~ e e E fEHFFG~ f f E gEHFFG~ g g E hEHFFG~ h h E iEHFFG~ i i E jEHFFG~ j j E kEHFFG~ k k E lEHFFG~ l l E mEHFFG~ m m E nEHFFG~ n n E oEHFFG~ o o E pEHFFG~ p p E qEHFFG~ q q E rEHFFG~ r r E sEHFFG~ s s E tEHFFG~ t t E uEHFFG~ u u E vEHFFG~ v v E wEHFFG~ w w E xEHFFG~ x x E yEHFFG~ y y E zEHFFG~ z z E {EHFFG~ { { E |EHFFG~ | | E }EHFFG~ } } E ~EHFFG~ ~ ~ E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E D l4444444444444444444444444444444                                EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E D l4444444444444444444444444444444                                EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E D l4444444444444444444444444444444                                EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E EHFFG~  E D l4444444444444444444444444444444                                     EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHFFG~   E !EHFFG~ ! ! E "EHFFG~ " " E #EHFFG~ # # E $EHFFG~ $ $ E %EHFFG~ % % E &EHFFG~ & & E 'EHFFG~ ' ' E (EHFFG~ ( ( E )EHFFG~ ) ) E *EHFFG~ * * E +EHFFG~ + + E ,EHFFG~ , , E -EHFFG~ - - E .EHFFG~ . . E /EHFFG~ / / E 0EHFFG~ 0 0 E 1EHFFG~ 1 1 E 2EHFFG~ 2 2 E 3EHFFG~ 3 3 E 4EHFFG~ 4 4 E 5EHFFG~ 5 5 E 6EHFFG~ 6 6 E 7EHFFG~ 7 7 E 8EHFFG~ 8 8 E 9EHFFG~ 9 9 E :EHFFG~ : : E ;EHFFG~ ; ; E <EHFFG~ < < E =EHFFG~ = = E >EHFFG~ > > E ?EHFFG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHFFG~ @ @ E AEHFFG~ A A E BEHFFG~ B B E CEHFFG~ C C E DEHFFG~ D D E EEHFFG~ E E E FEHFFG~ F F E GEHFFG~ G G E HEHFFG~ H H E IEHFFG~ I I E JEHFFG~ J J E KEHFFG~ K K E LEHFFG~ L L E MEHFFG~ M M E NEHFFG~ N N E OEHFFG~ O O E PEHFFG~ P P E QEHFFG~ Q Q E REHFFG~ R R E SEHFFG~ S S E TEHFFG~ T T E UEHFFG~ U U E VEHFFG~ V V E WEHFFG~ W W E XEHFFG~ X X E YEHFFG~ Y Y E ZEHFFG~ Z Z E [EHFFG~ [ [ E \EHFFG~ \ \ E ]EHFFG~ ] ] E ^EHFFG~ ^ ^ E _EHFFG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHFFG~ ` ` E aEHFFG~ a a E bEHFFG~ b b E cEHFFG~ c c E dEHFFG~ d d E eEHFFG~ e e E fEHFFG~ f f E gEHFFG~ g g E hEHFFG~ h h E iEHFFG~ i i E jEHFFG~ j j E kEHFFG~ k k E lEHFFG~ l l E mEHFFG~ m m E nEHFFG~ n n E oEHFFG~ o o E pEHFFG~ p p E qEHFFG~ q q E rEHFFG~ r r E sEHFFG~ s s E tEHFFG~ t t E uEHFFG~ u u E vEHFFG~ v v E wEHFFG~ w w E xEHFFG~ x x E yEHFFG~ y y E zEHFFG~ z z E {EHFFG~ { { E |EHFFG~ | | E }EHFFG~ } } E ~EHFFG~ ~ ~ E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                     EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHFFG~   E !EHFFG~ ! ! E "EHFFG~ " " E #EHFFG~ # # E $EHFFG~ $ $ E %EHFFG~ % % E &EHFFG~ & & E 'EHFFG~ ' ' E (EHFFG~ ( ( E )EHFFG~ ) ) E *EHFFG~ * * E +EHFFG~ + + E ,EHFFG~ , , E -EHFFG~ - - E .EHFFG~ . . E /EHFFG~ / / E 0EHFFG~ 0 0 E 1EHFFG~ 1 1 E 2EHFFG~ 2 2 E 3EHFFG~ 3 3 E 4EHFFG~ 4 4 E 5EHFFG~ 5 5 E 6EHFFG~ 6 6 E 7EHFFG~ 7 7 E 8EHFFG~ 8 8 E 9EHFFG~ 9 9 E :EHFFG~ : : E ;EHFFG~ ; ; E <EHFFG~ < < E =EHFFG~ = = E >EHFFG~ > > E ?EHFFG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHFFG~ @ @ E AEHFFG~ A A E BEHFFG~ B B E CEHFFG~ C C E DEHFFG~ D D E EEHFFG~ E E E FEHFFG~ F F E GEHFFG~ G G E HEHFFG~ H H E IEHFFG~ I I E JEHFFG~ J J E KEHFFG~ K K E LEHFFG~ L L E MEHFFG~ M M E NEHFFG~ N N E OEHFFG~ O O E PEHFFG~ P P E QEHFFG~ Q Q E REHFFG~ R R E SEHFFG~ S S E TEHFFG~ T T E UEHFFG~ U U E VEHFFG~ V V E WEHFFG~ W W E XEHFFG~ X X E YEHFFG~ Y Y E ZEHFFG~ Z Z E [EHFFG~ [ [ E \EHFFG~ \ \ E ]EHFFG~ ] ] E ^EHFFG~ ^ ^ E _EHFFG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHFFG~ ` ` E aEHFFG~ a a E bEHFFG~ b b E cEHFFG~ c c E dEHFFG~ d d E eEHFFG~ e e E fEHFFG~ f f E gEHFFG~ g g E hEHFFG~ h h E iEHFFG~ i i E jEHFFG~ j j E kEHFFG~ k k E lEHFFG~ l l E mEHFFG~ m m E nEHFFG~ n n E oEHFFG~ o o E pEHFFG~ p p E qEHFFG~ q q E rEHFFG~ r r E sEHFFG~ s s E tEHFFG~ t t E uEHFFG~ u u E vEHFFG~ v v E wEHFFG~ w w E xEHFFG~ x x E yEHFFG~ y y E zEHFFG~ z z E {EHFFG~ { { E |EHFFG~ | | E }EHFFG~ } } E ~EHFFG~ ~ ~ E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                     EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHFFG~   E !EHFFG~ ! ! E "EHFFG~ " " E #EHFFG~ # # E $EHFFG~ $ $ E %EHFFG~ % % E &EHFFG~ & & E 'EHFFG~ ' ' E (EHFFG~ ( ( E )EHFFG~ ) ) E *EHFFG~ * * E +EHFFG~ + + E ,EHFFG~ , , E -EHFFG~ - - E .EHFFG~ . . E /EHFFG~ / / E 0EHFFG~ 0 0 E 1EHFFG~ 1 1 E 2EHFFG~ 2 2 E 3EHFFG~ 3 3 E 4EHFFG~ 4 4 E 5EHFFG~ 5 5 E 6EHFFG~ 6 6 E 7EHFFG~ 7 7 E 8EHFFG~ 8 8 E 9EHFFG~ 9 9 E :EHFFG~ : : E ;EHFFG~ ; ; E <EHFFG~ < < E =EHFFG~ = = E >EHFFG~ > > E ?EHFFG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHFFG~ @ @ E AEHFFG~ A A E BEHFFG~ B B E CEHFFG~ C C E DEHFFG~ D D E EEHFFG~ E E E FEHFFG~ F F E GEHFFG~ G G E HEHFFG~ H H E IEHFFG~ I I E JEHFFG~ J J E KEHFFG~ K K E LEHFFG~ L L E MEHFFG~ M M E NEHFFG~ N N E OEHFFG~ O O E PEHFFG~ P P E QEHFFG~ Q Q E REHFFG~ R R E SEHFFG~ S S E TEHFFG~ T T E UEHFFG~ U U E VEHFFG~ V V E WEHFFG~ W W E XEHFFG~ X X E YEHFFG~ Y Y E ZEHFFG~ Z Z E [EHFFG~ [ [ E \EHFFG~ \ \ E ]EHFFG~ ] ] E ^EHFFG~ ^ ^ E _EHFFG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHFFG~ ` ` E aEHFFG~ a a E bEHFFG~ b b E cEHFFG~ c c E dEHFFG~ d d E eEHFFG~ e e E fEHFFG~ f f E gEHFFG~ g g E hEHFFG~ h h E iEHFFG~ i i E jEHFFG~ j j E kEHFFG~ k k E lEHFFG~ l l E mEHFFG~ m m E nEHFFG~ n n E oEHFFG~ o o E pEHFFG~ p p E qEHFFG~ q q E rEHFFG~ r r E sEHFFG~ s s E tEHFFG~ t t E uEHFFG~ u u E vEHFFG~ v v E wEHFFG~ w w E xEHFFG~ x x E yEHFFG~ y y E zEHFFG~ z z E {EHFFG~ { { E |EHFFG~ | | E }EHFFG~ } } E ~EHFFG~ ~ ~ E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~        !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcefghijklmnopqrstuvwxyz{|}~ E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                     EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E  EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHFFG~   E !EHFFG~ ! ! E "EHFFG~ " " E #EHFFG~ # # E $EHFFG~ $ $ E %EHFFG~ % % E &EHFFG~ & & E 'EHFFG~ ' ' E (EHFFG~ ( ( E )EHFFG~ ) ) E *EHFFG~ * * E +EHFFG~ + + E ,EHFFG~ , , E -EHFFG~ - - E .EHFFG~ . . E /EHFFG~ / / E 0EHFFG~ 0 0 E 1EHFFG~ 1 1 E 2EHFFG~ 2 2 E 3EHFFG~ 3 3 E 4EHFFG~ 4 4 E 5EHFFG~ 5 5 E 6EHFFG~ 6 6 E 7EHFFG~ 7 7 E 8EHFFG~ 8 8 E 9EHFFG~ 9 9 E :EHFFG~ : : E ;EHFFG~ ; ; E <EHFFG~ < < E =EHFFG~ = = E >EHFFG~ > > E ?EHFFG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHFFG~ @ @ E AEHFFG~ A A E BEHFFG~ B B E CEHFFG~ C C E DEHFFG~ D D E EEHFFG~ E E E FEHFFG~ F F E GEHFFG~ G G E HEHFFG~ H H E IEHFFG~ I I E JEHFFG~ J J E KEHFFG~ K K E LEHFFG~ L L E MEHFFG~ M M E NEHFFG~ N N E OEHFFG~ O O E PEHFFG~ P P E QEHFFG~ Q Q E REHFFG~ R R E SEHFFG~ S S E TEHFFG~ T T E UEHFFG~ U U E VEHFFG~ V V E WEHFFG~ W W E XEHFFG~ X X E YEHFFG~ Y Y E ZEHFFG~ Z Z E [EHFFG~ [ [ E \EHFFG~ \ \ E ]EHFFG~ ] ] E ^EHFFG~ ^ ^ E _EHFFG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHFFG~ ` ` E aEHFFG~ a a E bEHFFG~ b b E cEHFFG~ c c E dEHFFG~ d d E eEHFFG~ e e E fEHFFG~ f f E gEHFFG~ g g E hEHFFG~ h h E iEHFFG~ i i E jEHFFG~ j j E kEHFFG~ k k E lEHFFG~ l l E mEHFFG~ m m E nEHFFG~ n n E oEHFFG~ o o E pEHFFG~ p p E qEHFFG~ q q E rEHFFG~ r r E sEHFFG~ s s E tEHFFG~ t t E uEHFFG~ u u E vEHFFG~ v v E wEHFFG~ w w E xEHFFG~ x x E yEHFFG~ y y E zEHFFG~ z z E {EHFFG~ { { E |EHFFG~ | | E }EHFFG~ } } E ~EHFFG~ ~ ~ E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E D l4444444444444444444444444444444                                EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHFFG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                     EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHVVG~   E !EHVVG~ ! ! E "EHVVG~ " " E #EHVVG~ # # E $EHVVG~ $ $ E %EHVVG~ % % E &EHVVG~ & & E 'EHVVG~ ' ' E (EHVVG~ ( ( E )EHVVG~ ) ) E *EHVVG~ * * E +EHVVG~ + + E ,EHVVG~ , , E -EHVVG~ - - E .EHVVG~ . . E /EHVVG~ / / E 0EHVVG~ 0 0 E 1EHVVG~ 1 1 E 2EHVVG~ 2 2 E 3EHVVG~ 3 3 E 4EHVVG~ 4 4 E 5EHVVG~ 5 5 E 6EHVVG~ 6 6 E 7EHVVG~ 7 7 E 8EHVVG~ 8 8 E 9EHVVG~ 9 9 E :EHVVG~ : : E ;EHVVG~ ; ; E <EHVVG~ < < E =EHVVG~ = = E >EHVVG~ > > E ?EHVVG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHVVG~ @ @ E AEHVVG~ A A E BEHVVG~ B B E CEHVVG~ C C E DEHVVG~ D D E EEHVVG~ E E E FEHVVG~ F F E GEHVVG~ G G E HEHVVG~ H H E IEHVVG~ I I E JEHVVG~ J J E KEHVVG~ K K E LEHVVG~ L L E MEHVVG~ M M E NEHVVG~ N N E OEHVVG~ O O E PEHVVG~ P P E QEHVVG~ Q Q E REHVVG~ R R E SEHVVG~ S S E TEHVVG~ T T E UEHVVG~ U U E VEHVVG~ V V E WEHVVG~ W W E XEHVVG~ X X E YEHVVG~ Y Y E ZEHVVG~ Z Z E [EHVVG~ [ [ E \EHVVG~ \ \ E ]EHVVG~ ] ] E ^EHVVG~ ^ ^ E _EHVVG~ _ _ E D l4444444444444444444444444444444` 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 { | } ~  `EHVVG~ ` ` E aEHVVG~ a a E bEHVVG~ b b E cEHVVG~ c c E dEHVVG~ d d E eEHVVG~ e e E fEHVVG~ f f E gEHVVG~ g g E hEHVVG~ h h E iEHVVG~ i i E jEHVVG~ j j E kEHVVG~ k k E lEHVVG~ l l E mEHVVG~ m m E nEHVVG~ n n E oEHVVG~ o o E pEHVVG~ p p E qEHVVG~ q q E rEHVVG~ r r E sEHVVG~ s s E tEHVVG~ t t E uEHVVG~ u u E vEHVVG~ v v E wEHVVG~ w w E xEHVVG~ x x E yEHVVG~ y y E zEHVVG~ z z E {EHVVG~ { { E |EHVVG~ | | E }EHVVG~ } } E ~EHVVG~ ~ ~ E EHVVG~   E D l4444444444444444444444444444444                                EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444                                     EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E  EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E EHVVG~   E D l4444444444444444444444444444444  ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  EHVVG~   E !EHVVG~ ! ! E "EHVVG~ " " E #EHVVG~ # # E $EHVVG~ $ $ E %EHVVG~ % % E &EHVVG~ & & E 'EHVVG~ ' ' E (EHVVG~ ( ( E )EHVVG~ ) ) E *EHVVG~ * * E +EHVVG~ + + E ,EHVVG~ , , E -EHVVG~ - - E .EHVVG~ . . E /EHVVG~ / / E 0EHVVG~ 0 0 E 1EHVVG~ 1 1 E 2EHVVG~ 2 2 E 3EHVVG~ 3 3 E 4EHVVG~ 4 4 E 5EHVVG~ 5 5 E 6EHVVG~ 6 6 E 7EHVVG~ 7 7 E 8EHVVG~ 8 8 E 9EHVVG~ 9 9 E :EHVVG~ : : E ;EHVVG~ ; ; E <EHVVG~ < < E =EHVVG~ = = E >EHVVG~ > > E ?EHVVG~ ? ? E D l4444444444444444444444444444444@ 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 [ \ ] ^ _ @EHVVG~ @ @ E AEHVVG~ A A E BEHVVG~ B B E CEHVVG~ C C E DEHVVG~ D D E EEHVVG~ E E E FEHVVG~ F F E GEHVVG~ G G E HEHVVG~ H H E IEHVVG~ I I E JEHVVG~ J J E KEHVVG~ K K E LEHVVG~ L L E MEHVVG~ M M E NEHVVG~ N N E OEHVVG~ O O E PEHVVG~ P P E QEHVVG~ Q Q E REHVVG~ R R E SEHVVG~ S S E TEHVVG~ T T E UEHVVG~ U U E VEHVVG~ V V E WEHVVG~ W W E XEHVVG~ X X E YEHVVG~ Y Y E ZEHVVG~ Z Z E [EHVVG~ [ [ E \EHVVG~ \ \ E ]EHVVG~ ] ] E ^EHVVG~ ^ ^ E _EHVVG~ _ _ E D l4444444444444444444444444444444` a b c d e f g h i  j k l m n o pqrstuvwxyz{|}~`EHVVG~ ` ` E aEHVVG~ a a E bEHVVG~ b b E cEHVVG~ c c E dEHVVG~ d d E eEHVVG~ e e E fEHVVG~ f f E gEHVVG~ g g E hEHVVG~ h h E iG~ i i jIWWjG kIWWkG lIWWlG mIWWmG nIWWnG oIWWoG pIWWpG qIWWqG rIWWrG sIWWsG tIWWtG uIWWuG vIWWvG wIWWwG xIWWxG yIWWyG zIWWzG {IWW{G |IWW|G }IWW}G ~IWW~G IWWGDl4444444444 IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl      IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWW G IWW G IWW G IWW G IWW G IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl !"#$%&'()*+,-./0123456789:;<=>? IWW G !IWW!G "IWW"G #IWW#G $IWW$G %IWW%G &IWW&G 'IWW'G (IWW(G )IWW)G *IWW*G +IWW+G ,IWW,G -IWW-G .IWW.G /IWW/G 0IWW0G 1IWW1G 2IWW2G 3IWW3G 4IWW4G 5IWW5G 6IWW6G 7IWW7G 8IWW8G 9IWW9G :IWW:G ;IWW;G <IWW<G =IWW=G >IWW>G ?IWW?GDl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @IWW@G AIWWAG BIWWBG CIWWCG DIWWDG EIWWEG FIWWFG GIWWGG HIWWHG IIWWIG JIWWJG KIWWKG LIWWLG MIWWMG NIWWNG OIWWOG PIWWPG QIWWQG RIWWRG SIWWSG TIWWTG UIWWUG VIWWVG WIWWWG XIWWXG YIWWYG ZIWWZG [IWW[G \IWW\G ]IWW]G ^IWW^G _IWW_GDl`abcdefghijklmnopqrstuvwxyz{|}~ `IWW`G aIWWaG bIWWbG cIWWcG dIWWdG eIWWeG fIWWfG gIWWgG hIWWhG iIWWiG jIWWjG kIWWkG lIWWlG mIWWmG nIWWnG oIWWoG pIWWpG qIWWqG rIWWrG sIWWsG tIWWtG uIWWuG vIWWvG wIWWwG xIWWxG yIWWyG zIWWzG {IWW{G |IWW|G }IWW}G ~IWW~G IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl      IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWW G IWW G IWW G IWW G IWW G IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl !"#$%&'()*+,-./0123456789:;<=>? IWW G !IWW!G "IWW"G #IWW#G $IWW$G %IWW%G &IWW&G 'IWW'G (IWW(G )IWW)G *IWW*G +IWW+G ,IWW,G -IWW-G .IWW.G /IWW/G 0IWW0G 1IWW1G 2IWW2G 3IWW3G 4IWW4G 5IWW5G 6IWW6G 7IWW7G 8IWW8G 9IWW9G :IWW:G ;IWW;G <IWW<G =IWW=G >IWW>G ?IWW?GDl@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_ @IWW@G AIWWAG BIWWBG CIWWCG DIWWDG EIWWEG FIWWFG GIWWGG HIWWHG IIWWIG JIWWJG KIWWKG LIWWLG MIWWMG NIWWNG OIWWOG PIWWPG QIWWQG RIWWRG SIWWSG TIWWTG UIWWUG VIWWVG WIWWWG XIWWXG YIWWYG ZIWWZG [IWW[G \IWW\G ]IWW]G ^IWW^G _IWW_GDl`abcdefghijklmnopqrstuvwxyz{|}~ `IWW`G aIWWaG bIWWbG cIWWcG dIWWdG eIWWeG fIWWfG gIWWgG hIWWhG iIWWiG jIWWjG kIWWkG lIWWlG mIWWmG nIWWnG oIWWoG pIWWpG qIWWqG rIWWrG sIWWsG tIWWtG uIWWuG vIWWvG wIWWwG xIWWxG yIWWyG zIWWzG {IWW{G |IWW|G }IWW}G ~IWW~G IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWG IWWGDl                                 IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G IWW G IWW G IWW G IWW G IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW G  IWW GDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  IWW G ! IWW! G " IWW" G # IWW# G $ IWW$ G % IWW% G & IWW& G ' IWW' G ( IWW( G ) IWW) G * IWW* G + IWW+ G , IWW, G - IWW- G . IWW. G / IWW/ G 0 IWW0 G 1 IWW1 G 2 IWW2 G 3 IWW3 G 4 IWW4 G 5 IWW5 G 6 IWW6 G 7 IWW7 G 8 IWW8 G 9 IWW9 G : IWW: G ; IWW; G < IWW< G = IWW= G > IWW> G ? IWW? GDl@ 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 [ \ ] ^ _  @ IWW@ G A IWWA G B IWWB G C IWWC G D IWWD G E IWWE G F IWWF G G IWWG G H IWWH G I IWWI G J IWWJ G K IWWK G L IWWL G M IWWM G N IWWN G O IWWO G P IWWP G Q IWWQ G R IWWR G S IWWS G T IWWT G U IWWU G V IWWV G W IWWW G X IWWX G Y IWWY G Z IWWZ G [ IWW[ G \ IWW\ G ] IWW] G ^ IWW^ G _ IWW_ GDl` 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 { | } ~   ` IWW` G a IWWa G b IWWb G c IWWc G d IWWd G e IWWe G f IWWf G g IWWg G h IWWh G i IWWi G j IWWj G k IWWk G l IWWl G m IWWm G n IWWn G o IWWo G p IWWp G q IWWq G r IWWr G s IWWs G t IWWt G u IWWu G v IWWv G w IWWw G x IWWx G y IWWy G z IWWz G { IWW{ G | IWW| G } IWW} G ~ IWW~ G  IWW GDl                                 IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW GDl                                 IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW G IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWD>l                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW IWW IWW IWW IWW IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWWDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  IWW ! IWW " IWW # IWW $ IWW % IWW & IWW ' IWW ( IWW ) IWW * IWW + IWW , IWW - IWW . IWW / IWW 0 IWW 1 IWW 2 IWW 3 IWW 4 IWW 5 IWW 6 IWW 7 IWW 8 IWW 9 IWW : IWW ; IWW < IWW = IWW > IWW ? IWWDl@ 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 [ \ ] ^ _  @ IWW A IWW B IWW C IWW D IWW E IWW F IWW G IWW H IWW I IWW J IWW K IWW L IWW M IWW N IWW O IWW P IWW Q IWW R IWW S IWW T IWW U IWW V IWW W IWW X IWW Y IWW Z IWW [ IWW \ IWW ] IWW ^ IWW _ IWWDl` 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 { | } ~   ` IWW a IWW b IWW c IWW d IWW e IWW f IWW g IWW h IWW i IWW j IWW k IWW l IWW m IWW n IWW o IWW p IWW q IWW r IWW s IWW t IWW u IWW v IWW w IWW x IWW y IWW z IWW { IWW | IWW } IWW ~ IWW  IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW IWW IWW IWW IWW IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWWDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  IWW ! IWW " IWW # IWW $ IWW % IWW & IWW ' IWW ( IWW ) IWW * IWW + IWW , IWW - IWW . IWW / IWW 0 IWW 1 IWW 2 IWW 3 IWW 4 IWW 5 IWW 6 IWW 7 IWW 8 IWW 9 IWW : IWW ; IWW < IWW = IWW > IWW ? IWWDl@ 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 [ \ ] ^ _  @ IWW A IWW B IWW C IWW D IWW E IWW F IWW G IWW H IWW I IWW J IWW K IWW L IWW M IWW N IWW O IWW P IWW Q IWW R IWW S IWW T IWW U IWW V IWW W IWW X IWW Y IWW Z IWW [ IWW \ IWW ] IWW ^ IWW _ IWWDl` 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 { | } ~   ` IWW a IWW b IWW c IWW d IWW e IWW f IWW g IWW h IWW i IWW j IWW k IWW l IWW m IWW n IWW o IWW p IWW q IWW r IWW s IWW t IWW u IWW v IWW w IWW x IWW y IWW z IWW { IWW | IWW } IWW ~ IWW  IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW IWW IWW IWW IWW IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWW  IWWDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9 : ; < = > ?  IWW ! IWW " IWW # IWW $ IWW % IWW & IWW ' IWW ( IWW ) IWW * IWW + IWW , IWW - IWW . IWW / IWW 0 IWW 1 IWW 2 IWW 3 IWW 4 IWW 5 IWW 6 IWW 7 IWW 8 IWW 9 IWW : IWW ; IWW < IWW = IWW > IWW ? IWWDl@ 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 [ \ ] ^ _  @ IWW A IWW B IWW C IWW D IWW E IWW F IWW G IWW H IWW I IWW J IWW K IWW L IWW M IWW N IWW O IWW P IWW Q IWW R IWW S IWW T IWW U IWW V IWW W IWW X IWW Y IWW Z IWW [ IWW \ IWW ] IWW ^ IWW _ IWWDl` 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 { | } ~   ` IWW a IWW b IWW c IWW d IWW e IWW f IWW g IWW h IWW i IWW j IWW k IWW l IWW m IWW n IWW o IWW p IWW q IWW r IWW s IWW t IWW u IWW v IWW w IWW x IWW y IWW z IWW { IWW | IWW } IWW ~ IWW  IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWWDl                                 IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IWW IJJ IJJ IJJ IJJ IJJDl                                 IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJDl                                 IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJ IJJDl                                 IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ IJJ IJJ IJJ IJJ IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJ  IJJDl ! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5 6 7 8 9  IJJ ! IJJ " IJJ # IJJ $ IJJ % IJJ & IJJ ' IJJ ( IJJ ) IJJ * IJJ + IJJ , IJJ - IJJ . IJJ / IJJ 0 IJJ 1 IJJ 2 IJJ 3 IJJ 4 IJJ 5 IJJ 6 IJJ7 I8 I9 I8 (  x  6xkCC@],@ށ9 $<Run<   JA?? officehelp4Picture 47officehelp4yK yK http://www.officehelp.biz/officehelp/default.asp?ent=demosite4yX;H,]ą'c. ]&`xx 6 6`ykCC@S],6@+ށ9 $<Import from Outlook< xx j 60|kCC@ O v],j@Kށ9 $ < Reset Tasks<J xx  6ykCC@S],@ށ9 $<Import from Outlook< >@.        !!    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=demosite yK www.officehelp.bizyK ~http://www.officehelp.biz/officehelp/default.asp?ent=demosite4yK YClick here to PERSONALIZE your Calendar Plan (Fonts, Colors, Month and Weekday names, & ) Config!A1yK 2Click here to configure the the ADVANCED settings Config!A18yK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demosite4zyK Demo Restrictions'Demo Restrictions'!A1 yK 'Click here for a list of restrictions.'Demo Restrictions'!A1< yK ,Click here to get the UNRESTRICTED version.yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demosite4PyK *Get the Full (Unrestricted) Version Here!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demosite4yX;H,]ą'cT yK ,Click here to get the UNRESTRICTED version.yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demosite4yX;H,]ą'c DLEnter valid date Invalid date!e #i8 alIncludeExcludex!! l6Insert % of work done for this task. 0 is the Default.)Decimal number greater than or equal to 0o#i =Insert a Single Character as Deadline Market (or leave empty)(Limited to a single character (or Empty)i0i Number out-of-limits/Select default level for Outlook imported tasksPlease select option from list. y)1234M Enter valid date Invalid date!le orTADLEnter valid date Invalid Date!leor}  Select location for split plans.'Invalid input. Please select from list.seSheet Workbookr  Months per PlanNumber out-of-limits3Select where to split Calendar Plans (or No Split).Please select option from list.No Split345678125 4 Enter Plan Nameofim (Select the type of Plan to be generated.'Invalid input. Please select from list.%"Daily Weekly Monthly YearlyAllt JSelect Outlook folder to use as source for event import: Calendar or TasksPlease select option from list.yTasksCalendarl Levels to Include in the PlanNumber out-of-limits/All levels up to the indicated will be includedPlease select option from list.;l8All01234567891011121314151617181920  Sheet1ggD YA F        !"#$%&'()*+/^123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]._`abcdefghijklmnoprstuvwxyz{|}~ 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" NX??&U} . @} @} . @F                               Z*'Plan Generator Vs4.1 - ADVANCED Edition XYYYYYYYYYYZ T  [G\GGGGGGGG] |UK\GGGGGGGG] [K\GGGGGGGG]              [K\GGGGGGGG]  [    GG GV GGG]  [  GG Ga GGG]  b   GGGGGG]  [   GGGGGG] [  GGGGGG] [  GGGGGG] [  GGGGGG] a GGGGGG] a GGGGGGGG] a GGGGGGGG] [ GGGGGGGG] [ GGGGGGGG] a GGGGGGGG] aGGGGGGGGGG]  b           [GGGGGGGGGG] [~ @Z" % Done GGQk!@QZ"  Resource GG ~   @ Z"  Category ][GGGGGGGGGG] [~ 7@  GG GlGGGGG] aGGGGGGGGGG]  k           [GGGGGGGGGG] D? ly"."."."LL66666666666".""X".   !  "  #  $  %  &  '  (  )  *  + , -  .  /  0  1  2  3 4 5  6  7  8  9  : ;  <  =  > ?    e f  o ! ! n ! " "e "g" " m " # $ $e $h$ % & &i& ' ([ (j(GGGGGGGG] )[GGGGGGGG] *[ *p*GGGGGGGG] +[GGGGGGGG] , v,           -[GGGGGGGG] .[ .[ .r.GGGGGGGG] /[GGGGGGGG] 0[ 0[ 0s0GGGGGGGG] 1[GGGGGGGG] 2[ 2u 2t2GGGGGGGG] 3[GGGGGGGG] 4 {4           5[GGGGGGGG] 6[ 6u 6z6GGGGGGGG] 7[GGGGGGGG] 8[ 8[ 88GGGGGGGG] 9^________` :: ;[GGGGGGGG] <a< <<G] =aGGGGGGGG] >> >> ? ?? DlX8X"B"8"8"8"."B"B"B"."B"B"."B"B@ A B  C D 6E  @aGGGGGGGG] AA B CXYYYYYYYYZ D5D E^__________` \d"."". _  _H  0(   x  6fkCC@ >Y ?], @ށ9 $<Reset Messages<b xx  6fkCC@ ; = ], @ށ9  $ <Set Messages<Y >@. ",, DD   44 :: << AA          >> ?? 7DD yK )Back to the Main Display user interface. Input!A1AA yK nCustomize these messages to create YOUR OWN personalized Calendar Plan Generator! Only on the CUSTOM EDITION!yK http://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00044&ent=Demosite42   TAp  Decimal number between 0 and 100Invalid number sd 2 For RESOURCE field only Out-of-limitsIf YES, will import the name of the Task/Appointment owner in Outlook This information is protected by Outlook and will require the user to grant access permission on Outlook each time it is used.Please select option from list. pYesNoN22  Out-of-limitsNTasks only. If YES, will import Tasks without a valid Start and / or Due date.Please select option from list. otYesNoN00  Out-of-limits0Tasks only. If YES, will import completed tasks.Please select option from list. asYesNoN..  Out-of-limits1If YES, Excel default gridlines will be included.Please select option from list. sYesNoN66  Out-of-limits0If YES, task bars will have a START and END day.Please select option from list. sYesNoN88 Sheet6ggD YA $ z$  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" @X??&U} . @} @} . @                                        Z*'Plan Generator Vs4.1 - ADVANCED Edition XYYYYYYYYYYZ   [G\GGGGGGGG] [K\GGGGGGGG] [K\GGGGGGGG] [K\GGGGGGGG]  [K\GGGGGGGG] b# GGGGGGGGGG]  [GGGGGGGGGG] [, GGGGGGGGGG] [+ GGGGGGGGGG] [/GGGGGGGGGG] a.GGGGGGGGGG] aGGGGGGGGGG] aNGGGGGGGGGG] [GGGGGGGGGG] [OGGGGGGGGGG] aGGGGGGGGGG] aGGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] aHGGGGGGGGGG] [GGGGGGGGGG] [LGGGGGGGGGG] [IGGGGGGGGGG] [GGGGGGGGGG] aJGGGGGGGGGG] Dlo"."..."."...."."."."..".".."  ! " # $ % & ' ( ) * + , - . / 0123456789:;<=>? [GGGGGGGGGG] ![M!GGGGGGGGGG] "[K"GGGGGGGGGG] #[GGGGGGGGGG] $a$GGGGGGGGGG] %[GGGGGGGGGG] &[&GGGGGGGGGG] '['GGGGGGGGGG] ([GGGGGGGGGG] )b)GGGGGGGGGG] *[GGGGGGGGGG] +[+GGGGGGGGGG] ,[,GGGGGGGGGG] -[GGGGGGGGGG] .a.GGGGGGGGGG] /[GGGGGGGGGG] 0[0GGGGGGGGGG] 1a1GGGGGGGGGG] 2[2GGGGGGGGGG] 3[GGGGGGGGGG] 4a94GGGGGGGGGG] 5[GGGGGGGGGG] 6[?6GGGGGGGGGG] 7[@7GGGGGGGGGG] 8[:8GGGGGGGGGG] 9[A9GGGGGGGGGG] :[;:GGGGGGGGGG] ;[GGGGGGGGGG] ; <aB<GGGGGGGGGG] =[GGGGGGGGGG] = >[C>GGGGGGGGGG] > ?[D?GGGGGGGGGG] ?Dl".."."..".".."."...".".....,.,8@ABCDEFGHIJKLMNOP Q R S T U V W X Y Z [ \ ] ^ _ @ @ AaEAGGGGGGGGGG] AB[GGGGGGGGGG] C[FCGGGGGGGGGG] D[GDGGGGGGGGGG] EaGGGGGGGGGG] FaFGGGGGGGG] GGGGGGGGG] HHGGGGGGGG] IIGGGGGGGG] JJGGGGGGGG] KaGGGGGGGGGG] LaLGGGGGGGG] MGGGGGGGG] NNGGGGGGGG] OOGGGGGGGG] PaGGGGGGGGGG] QaQGGGGGGGGGG] R[GGGGGGGGGG] S[SGGGGGGGGGG] T[GGGGGGGGGG] U[ U\UGGGGGGGGG] V[ V\%VGGGGGGGGG] W[ W\& WGWGGGGGGGG] X[\ XGXGGGGGGGG] Y[\ YGYGGGGGGGG] Z[ Z\ ZGGGGGGGGG] [[ [\'[GGGGGGGGG] \[ \\!\GGGGGGGGG] ][GGGGGGGGGG] ^a^GGGGGGGGGG] _[GGGGGGGGGG] D l,8".."."...".".."."."66B88666".` 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 { | } ~   ``GGGGGGGGGG] a[GGGGGGGGGG] b[ b\bGGGGGGGGG] c[ c\cGGGGGGGGG] d[ d\dGGGGGGGGG] e[\GGGGGGGGG] f[f\GGGGGGGGG] g[g\GGGGGGGGG] h[h\GGGGGGGGG] i[\GGGGGGGGG] jajGGGGGGGGGG] k[GGGGGGGGGG] l[lGGGGGGGGGG] m[GGGGGGGGGG] nanGGGGGGGGGG] o[GGGGGGGGGG] p(p q r[GGGGGGGGGG] sa"sGGGGGGGGGG] t[GGGGGGGGGG] u[)uGGGGGGGGGG] v[GGGGGGGGGG] wa$wGGGGGGGGGG] x[GGGGGGGGGG] y[*yGGGGGGGGGG] z[GGGGGGGGGG] {a{GGGGGGGGGG] |[GGGGGGGGGG] }[}GGGGGGGGGG] ~[GGGGGGGGGG] aGGGGGGGGGG] Dl."666"...".".".".""."."."."."."                                [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [\ GGGGGGGGG] [\ GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [GGGGGGGGGG] aGGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [\GGGGGGGGG] [\GGGGGGGGG] [\GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ \GGGGGGGGG] [ GGGGGGGGG] [\GGGGGGGGG] 5 ^__________` BX"."66688666".".."6666"."6666".  _PH00(  >@. *  pq  @@ 7 yK )Back to the Main Display user interface. Input!A12   TA)L   Sheet4ggD YA ,k2  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 Vs4.1 - ADVANCED Edition XYYYYYYYYYYZ   [G\GGGGGGGG] K\GGGGGGGG] [K\GGGGGGGG] [K\GGGGGGGG]  [KGGGGGGGG] [K  GGGGGGGG] [K  GGGGGGGG] [K  GGGGGGGG] [K  GGGGGGGG] [KGGGGGGGG] bGGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [GGGGGGGGGG] [ GGGG] ^__________`  0ao"."."."8888"."."6"  PHP0(  >@. "   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=00002&ent=demosite42   TA)L  Sheet7ggD YA {:A  dMbP?_*+%&?'?(?)?MPDF995S oNXLetterPRIV0''''\KhC}_" NX??&U} . @} @} . @                                @       Z*'Plan Generator Vs4.1 - ADVANCED Edition XYYYYYYYYYYZ 0  [G\GGGGGGGG] [1K\GGGGGGGG] [2K\GGGGGGGG] [K\GGGGGGGG] b# GGGGGGGGGG]  [GGGGGGGGGG] [, GGGGGGGGGG] [+ GGGGGGGGGG] [/ GGGGGGGGGG] a.GGGGGGGGGG] [GGGGGGGGGG] b3GGGGGGGGGG] [GGGGGGGGGG] 4          ! [GGGGGGGGGG] b6GGGGGGGGGG] [GGGGGGGGGG] "8##########$ hiiiiiiiiiij hiiiiiiiiiij effffffffffg 5 [\GGGGGGGGG] ^__________` >0o".".."."...."."."."."""."  _PH`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 YA XF,J  dMbP?_*+%&?'?(?)?"??&U                      %%%%%%%%%%  %%%%%%%%%%       $,$8$88$$$$$$$$$$PH@0(  >@  7 Sheet2ggD Module1 0__SRP_2-HH__SRP_3ThisWorkbook*+  !"#$%&()*+,.0123456789:;<=>?@ACDEFHJKLMNOPQRSTUVWXYZ[]^_`bdefghijklmnopqrstuwxyz|~17*\R0*#2*\R0*#f*\R0*#13*\R1*#54*\R1*#121$*\Rffff*0]58e64b41$*\Rffff*0[58e64b41$*\Rffff*0X58e64b41$*\Rffff*0W58e64b41*\R0*#16*\R1*#289*\R1*#11*\R1*#a4*\R1*#32*\R1*#2d*\R1*#84*\R1*#57*\R1*#51*\R1*#285߁ 0 0 H  h x            0 @ P P8CpT4X,(H&pt.((X((dP((Z]lٞxME|@08$> :LPLLL L< Wʘ&1Bʘ*PBʘ,Bʘ0Kʘ4K ʘ68$B ʘ: "K ʐ>@0#HʐB#HʐF#HʐJHʐLx$HʐP$HʐT00%HʐV(&HʐZPp%Hʐ^&Hʐ`x@'Hʐd'H ʐh (H"ʐj)H#ʐnp)H%ʐr)H'ʐt*H(ʐx@p*H*ʐ|0+H,ʐ~hP+H-ʐ,H/ʐ,H1ʐ,H2ʐp-H4ʐ .H6ʐP.H7ʐ0H/H9ꀚx;@ꀜX<@ꀠ >@ꀤ@@ꀦA@ꀪ C@ꀮh(E @ꀰ,F @ꀴ 4H @ꀸ<J@ꀺH@K@ꀾpHM@XPO@TP@\R@dT@hU@pW@HxY@8|Z@`\!@WARNING - Invalid task dates% ' on line %%<B:D@%a&@P c(@( d)@Pf+@ h-@xi.@k0@@ m2@n3@p5@X     r7@  t9@@  u:@h ( w<@ ` @0l  @ h  @0d  !|A@"x  ~C@&0!D@%*X!F@ %.!H@ %2!J@6h  L@8!M@<!O@(Macro execution stopped by user request. @0`H"k:: L`P2k`Nx`Ph ^`P8k))`Nx`Ph dh`X: k`Nx n``<kKK`Nt`xr X`P>8ki 8.iou a `? k i g th`xis p`t> D h`@Ak(**I Hi 0+`Dtk `Nt8+` `Eo `t@`p`lc va`her t+z` `G`o """`tvar_`8Hp `l `h8 `` `X `xTUTLO`R    `JDo %%Di _Wi` i$intly $ `MHk` i) <j% < `Nk ##| i> B2i@'i((!iBHS iD hiF themiH$'iJ('iL,'iN0'+X`PPkH iZ '`Nt'`\p' ^`Qki> eSK ```Sk`x `t`Npbjec+b`U@kid  `ft \`Np S l`VhkPin (ʘ"Bʘ$Bʘ((Bʘ.xKʘ2Kʘ8K WARNING - Invalid calendar datesʐDh HʐH`HʐNHʐR%HʐXXP%Hʐ\%Hʐb`'Hʐf'H!ʐlH@)H$ʐpp)H&ʐvP*H)ʐz*H+ʐ8+H.ʐ`H,H0ʐ,H3ʐ-H5ʐ(.H8ʐP/H:ꀞ=@ꀢ?@ꀨB@ꀬ@$D @ꀲ0G @ꀶ8I@ꀼDL@0LN@XQ@`S@lV@ tX@p[ @]"@^#@_$@ `%@( b'@x e*@ g,@ j/@ l1@h o4@ q6@  s8@0 x v;@ D x=@ ` y>@ xz?@( |{@@ P }B@(  E@,  G@0 I@4@  K@:  N@> P@ʐ<"H p0 @0 82C WWW.OFFICEHELP.BIZ - Calendar Plan Generator 4.1 ADVANCED Edition!oCalendar Generation Finished. This macro is a member of www.OfficeHelp.Biz full family of Calendar Products.HPlease select at least one calendar type: Daily, Weekly, Monthly or YearwThe main START DATE for calendar plan (Cell C7) greater than its END DATE (Cell C9). The calendar cannot be generated. The START DATE for task 'Xg is greater than its END DATE. The task will have no calendar bar. Press OK to proceed, CANCEL to stop.!"WARNING - Calendar needs SplittingThe requested calendar has  the maximum finish date is I. Proceed automatically splitting calendars every last complete month?The requested calendar has days. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 days. For a starting date of weeks. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 weeks. For a starting date of ducts the maximum finish date is stI. Proceed automatically splitting calendars every last complete month?TE foWARNING - Outlook SecurityeateThe Resource optional field is active. Importing the resource field from Outlook calendar appointments will fire a Warning message from Outlook stating that another application is trying to access Outlook addresses. It will only work IF you do ALLOW it to proceed.- Cale(OUTLOOK Task / Appointment Import Wizardlendar+OUTLOOK Task / Appointment import finished.lum*Import tasks starting on Excel row number?ximuWARNING - Task List Resetore 2YThe existing Task List will be COMPLETELY ERASED if you proceed. Do you want to clean it?y splWARNING 2 - Task List Resetomp>Are you sure you want to COMPLETELY ERASE the whole Task List?Task List has been erased. andThe requested calendar has s. months. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 months. For a starting date of ars the maximum finish date is I. Proceed automatically splitting calendars every last complete month?portidDEMO Version limited to 7 tasks and will only work from 2004 to 2005. Using 2004 to 2005 instead of in;DEMO Version limited to 7 tasks and 7 months for each plan.ses:DEMO Version limited to 7 tasks and 7 weeks for each plan.(:DEMO Version limited to 7 tasks and 27 days for each plan.oint-WARNING - Original messages will be restored. vThe existing Messages will be COMPLETELY ERASED if you proceed and the original ones restored. Do you want to proceed?/WARNING 2 - Original messages will be restored.k List vThe existing Messages will be COMPLETELY ERASED if you proceed and the original ones restored. Do you want to proceed?)The original messages have been restored.e onlHWARNING - Original messages will be REPLACED by the ones inserted below.th is The existing Messages will be REPLACED by the ones below if you proceed. You may restore the original messages later using the RESET button. Do you want to proceed?/WARNING - Only available on the CUSTOM Edition. 2004 tThe function you are trying to use is not available on this Edition. Please upgrade to the CUSTOM Edition using the Upgrade Link on this page.@(0T @0D ed t@X04 s fo@1$ (@0  s wi@H1 p@0 be @0 you@ gina@1 you @ 0@01 ges @ @`1 ges @ RASE<>BDFhex1HJLNd.1PRTVd?1XZ\^s 1`bdf1hjlnes1prtv b2xz|~lo 2Thisti Mp7 337@:TVXRth@83X @P3H re t@h38 avai@3( n. P@3 CUS@x7 e Up@8 age.H @X!8 @ xh   (P` @ h@h0(X( 00!x Hpp8x H8h ( h `(P "P !P x 0  x h  X@ h !X!!hp0!H``(p0  PxXP@   :@ 2DZ\@7 zC@7 @7 @ :@ 8 @88 @ zC9 999@:TVXR@89X @P9H @h98 @9( @9 @9 @(: @ 8D>@`Z@: 9\<b@ @@: @ P;;;(;H<@f8@@;t @X;d @` `l?@p;P @@ ?@;0 @< @ :h>>;;  4?@ < "&(*,.00<26:=`=H= >8>vr@Dd:@x =z8>XbR@x=` @@=P @=@ @=0 @= @ @ E0=4|2~.=0@ >T8?P? ?>@x @8?h @X @h?H @8 h@8@(A@P@ @FCB@@p @l |>@h @@X ?@@H @@8 @( @@$ >@A @ ?@ H(ApBBBB(CB@x B@(Bh @@BX @XBH @8 3C@C( @B BBDA@C`BB@@C CB =? M?@hC`XCC zC?AEyD@C M?C@C:@C`ChCf ?@D CC@8D`A(DC@C @ @`D ?PDD@D` BxD8DyD@ M?D`D:@`Df @@PEPEEhE`x?xEPEAE@>4>:0@FHFFFF@FxFXF`xhF@F?68zC? B@Gd @F` @GP @L ?@ G< @8G, @PG @ @hG @ @@ 0HIHIHH8H0IPH`zz `H8HTXR6@H@ ,C@H0 @H @I @8J @xI @I ?pHZ\H@`I @ @I @ J @I ?@I @I @J @ @PJ @hJ ?@J @p @` PKKhKM0MXM8KHMr @(Lx @Kh @KX @KH @K8 @K( @@L @L @L @L @XL @pL @L @M @L @L @M @ @p ?@` @P pM0M`m?@L`XM@D `PNhNN8NA@x @Nh @X @H (Hh`PhOOOP8PPO(PPVX@@A@x 1@Oh @OX @OH @8 @O( ?@ @ PPP@`8P@xP @ h0QHQQ0QhQHQ`XxXQ0Q@>t>@` @P hRRRS8SPR(SPVzCzC@x @Rh ?@RX @RH ?@8 @R( @ @ =?PSS:@`8ShP8TTTHTPUhU@DTVZ@Tl TR\6^:@`T\ @xTL ?@T< @T, @ @U >@8U @ ?@ U @ @ @ `?0TbX: VpVV VXV8V`bxHV VzChj@V` |>@P @@ ?PpWWXWpzC@x @h  p!%3'KX*\R1*#3e5*\R1*#284$*\Rffff*0R58e64b41*\R0*#e*\R0*#14*\R1*#3e4*\R1*#132*\R1*#13b*\R1*#13b*\R1*#126*\R0*#1*\R0*#d&@4X86& f( ( J & (0 X ( d( p H FH F :  <  6hT< D  (08@HPX`hpx N (@`p  2(&@h " $ 0   ( $0 X h x(MZ  @ HP  X ` h p x                      ( 0 8 @ H P ` h "p &x   $3  0 @  P"6p  JJ Jp  " 0   $@3Hhp x    +  "60 *H"6x   *E0S0SH x&E,S,S 3 ( "0 @8 @x 8 (L (LH(Lp*I8G*I 0 HP Xh*Lp  *@ & 8W 8WX8W:W2U @  `  h  p  x    0W 0Q *I! @! X!h! p!!0W!0Q!*I! " 0"@" H"X"0W`"0Q"*I" " ##  #0# "8#*K`# #0W#0W#0W$0W8$0Wh$0W$0W$0W$0W(%0WX%0W%0W% ,%&0W &0WP&0W&0W&0W&0W'0W@'p' x'.T'*L'*L'*L((8WX(8W(8W( ,) .T0),O`).T),O).T),O *.TP*.T*.T* "* 8W+8W@+ 2x+ + + + "+ ++ %+ , ,  , (, 8,H, P, X,  h,, , 4, 0,,,  ,:(- @- P-X-`- h-x- -:(- - --- -. .:( . `. p.x.. .. .:(. . /// /(/   0/-@/X/-`/x/ /$/1/'/ Z/ (0@0 H0 " P0 X02p0 &00 " 00  $00A020d12 1701H1 " P1 <X1<p161111 161111 16122 2 (2602H2P2X2 `2h28p2 62222  2 62222  223 >3 @H33 B33  3 3 3 33 3 3 B333 <p4X4 x4"4 <q4 45 55 B5 5(5H5 h5p50555<p55 6 <q6 X66fh66f6 6b6 P7`78h777 7 7 777 77 " 7 77:8 %@8P8X8`8h8p8x8;8;86868;8;899 9(90989@9 H9h9p9x9999 99 9 " 9 (9 69696:6(:6@:6X:6p:6:6:6:6:6:6; ; "  ;  (;9@; #X;9h; *;;; ;9; ";9;=;9<=<90< "H<  (X<<9< #<< <9< "<< =9= "(=8= @= B H=P= `=h= x=%== = = " =  = (=9> >9(> *@>P>X> `>9h> >9> >9> >9> >  ?9(? !@?9P? h?9x? ? ? "? ?? ? ? @ @  (@"0H@p@ ,@"0@@  .@<p(A hA pA AAABwAB -B (B B 0B 28BpB BBB*"B$BB C C " C "C(C C) (C) OfficeHelp 2006 - www.officehelp.biz Version Code COMMON CODE MODULE=HO]]$p]$x]$1ib]$D0]$(A-]$PDE]$A00]$x2}\]$\wi]$]$$ EDITION Constants]$8]$ Define MSGBOX Strings]$Calendar Generation Finished. @ @NThis macro is a member of www.OfficeHelp.Biz full family of Calendar Products.\>]$HPlease select at least one calendar type: Daily, Weekly, Monthly or Year@?]$(Macro execution stopped by user request.]$wThe main START DATE for calendar plan (Cell C7) greater than its END DATE (Cell C9). The calendar cannot be generated. h>]$ WARNING - Invalid calendar dates?]$WARNING - Invalid task dates]$The START DATE for task ']$ ' on line ]$g is greater than its END DATE. The task will have no calendar bar. Press OK to proceed, CANCEL to stop.!:]$"WARNING - Calendar needs Splitting]$The requested calendar has ]$days. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 days. For a starting date of 0]$ the maximum finish date is (]$. @ @DProceed automatically splitting calendars every last complete month?X]$The requested calendar has P]$ weeks. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 weeks. For a starting date of ]$ the maximum finish date is ]$. @ @DProceed automatically splitting calendars every last complete month?x]$WARNING - Outlook Security]$The Resource optional field is active. Importing the resource field from Outlook calendar appointments will fire a Warning message from Outlook stating that another application is trying to access Outlook addresses. It will only work IF you do ALLOW it to proceed.]$(OUTLOOK Task / Appointment Import Wizard]$+OUTLOOK Task / Appointment import finished. ]$*Import tasks starting on Excel row number?]$WARNING - Task List ResetH]$YThe existing Task List will be COMPLETELY ERASED if you proceed. Do you want to clean it?]$WARNING 2 - Task List Resetp]$>Are you sure you want to COMPLETELY ERASE the whole Task List?]$Task List has been erased.]$The requested calendar has ]$ months. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 months. For a starting date of @]$ the maximum finish date is ]$. @ @DProceed automatically splitting calendars every last complete month?]$dDEMO Version limited to 7 tasks and will only work from 2004 to 2005. Using 2004 to 2005 instead of h]$;DEMO Version limited to 7 tasks and 7 months for each plan.8]$:DEMO Version limited to 7 tasks and 7 weeks for each plan.]$:DEMO Version limited to 7 tasks and 27 days for each plan.`]$-WARNING - Original messages will be restored.]$vThe existing Messages will be COMPLETELY ERASED if you proceed and the original ones restored. Do you want to proceed?]$/WARNING 2 - Original messages will be restored.]$vThe existing Messages will be COMPLETELY ERASED if you proceed and the original ones restored. Do you want to proceed?]$)The original messages have been restored.]$HWARNING - Original messages will be REPLACED by the ones inserted below.]$The existing Messages will be REPLACED by the ones below if you proceed. You may restore the original messages later using the RESET button. Do you want to proceed?]$/WARNING - Only available on the CUSTOM Edition.(_C_M]$The function you are trying to use is not available on this Edition. Please upgrade to the CUSTOM Edition using the Upgrade Link on this page.0_TASKS> Declare Variables for Constants (for personalization edition)_TAS] P] x] X] ] ] ] ] ] ] ] @] h] ] ]  ] ] ] H] ] p] 0] X] ] ] ] ] ] ] ] ]  ] H] 8H Declare public variables (used all over the macro code, on all modules)] p`XCEL]  B_var_] ( P EK] (x P_B_v]   x ]  @ ar] h  ]    UTLO] @ 0 h  1]   ( TLOO] !P x 0! X!_W]  ! ] !] @ h ! $] !  Currently Set from Constants_B_* Future edition will allow personalization <$BG'<j :Get them from Config Set SheetMIT_ <_B_ D.EXCEL_ D.T_2B2MHS %F%H!JX 'B4MHS %F%H!JX @ @B5MHS %F%H!JX 'k d  Gets them from constants <' >'kP B' D' F' H' J' L' N' P' R' T' V' X' Z' \' ^' `' b' d' f' h' j' l' n' p' r' t' v' x' z' |' ~' < '<C_@ o8 0 Set messages to Hidden storageSK]pCA@@ Check if it is CUSTOM EditionMIT_ :  T V X A@R(|k Set ObjectsC_EXC D.IT_4 D.C_EXCE Confirm Message SetC_EXCE  T V Z $R'NWEEKSL N \G|jC_EXCE Set cells from CONFIGOUTLD61Config %F%H!JX B2MHS %F%H(JTLE~ D63Config %F%H!JX B4MHS %F%H(J_WARNID64Config %F%H!JX B5MHS %F%H(JITLE22o) Restores Config Sheet MSG from constants]A@@ Check if it is CUSTOM EditionNTHS :  T V X A@R_3|8k0 Set Objects  D.r_MSG_ D.W_ Split Multiline Constant > @ @$`'P Confirm Message ErasingG_  T V Z $R'NNING_M N \G|jANING_# Confirm Message Erasing - 2nd timeING_WA  T V Z $R'N_B_ N \G|jMSG_ Set cells from constants CONFIGM <D61Config %F%H(JWARNIN$PD63Config %F%H(J$PD64Config %F%H(J MHSr? <B2MHS %F%H(Jau$PB4MHS %F%H(JueTh$PB5MHS %F%H(J(  b X A@Rox9 Obtain values from the input sheet into public variables9 Only point of code contact with the configuration values]P1 Set MSG variables from constants or Config SheetA@@ Get main header valuesplC5Input %F%H!J'C7Input %F%H!J'C9Input %F%H!J'F11Input %F%H!J'N N$fALLG'8cG0 NX '8jC11Input %F%H!J'N߷ NNo Split'dP NX 'k8C13Input %F%H!J''' ' $hG'cG'jD Select what plan should be madeL_'>F7Input %F%H!JX Daily'F7Input %F%H!JX Weekly'F7Input %F%H!JX Yearly'F7Input %F%H!JX Monthly'Z bb F7Input %F%H!JX All p  Make all in a single run'''''>k Get Optional Fields  I35Input %F%H!J+C27Config %F%H!J+I34Input %F%H!J'N k NIncludeq +; d8+X k J35Input %F%H!J+G27Config %F%H!J+J34Input %F%H!J'Nb / j NIncludeE +S d`+s kHK35Input %F%H!J+K27Config %F%H!J+K34Input %F%H!J'N L NIncludeR +V  d+i  kp Get Task Name Column Width$ $ C29Config %F%H!J'<  <  Get Month Names< C12Config %F%H!J+C13Config %F%H!J+C14Config %F%H!J+C15Config %F%H!J+C16Config %F%H!J+C17Config %F%H!J+C18Config %F%H!J+C19Config %F%H!J+C20Config %F%H!J+C21Config %F%H!J +C22Config %F%H!J +C23Config %F%H!J +& Get Weekday names - Not in use in 4.0F12Config %F%H!J+F13Config %F%H!J+F14Config %F%H!J+F15Config %F%H!J+F16Config %F%H!J+F17Config %F%H!J+F18Config %F%H!J+k0 Get Outlook DefaultsC23Input %F%H!j!l'C25Input %F%H!J' C27Input %F%H!J'  G25Input %F%H!J'  C47Config %F%H!JX Yes'C49Config %F%H!JX Yes'C51Config %F%H!JX Yes'4% Get Background and Fonts from ConfigC33Config %F%H!j!l' C33Config %F%H!$."C35Config %F%H!j!l'&C35Config %F%H!$.(C37Config %F%H!j!l'*)C37Config %F%H!$.,-C39Config %F%H!j!l'."C41Config %F%H!j!l'0C43Config %F%H!j!l'2 Get Global Output Variables).0C55Config %F%H!JX Yes'6C57Config %F%H!JX Yes':, Store full calendar length before splitting ' 'oh On Error Resume Nextp v r(t]A@@'N D. D.A@d' zG|j Demo Restrictions 8 > . Show on emessage instead of one per plan type  X b A@Rkk 4  NDL NWK NMTH NYR .A@dkHA@|YR'Nk( 2  NDL NWK NMTH NYR .A@dkA@~MTH'Nk .  NDL NWK NMTH NYR .A@dk(A@WK'Nk 0  NDL NWK NMTH NYR .A@dkA@DL'Nkx N  X b A@RdH  X b A@Rk(p  !  T X $R'x ! eS MsgBox Err.Description, vbCritical + vbOKOnly, " 2005 WWW.OFFICEHELP.BIZ - ERROR" Resume Nextk`oX col = "C:F" $B@H  (oX] F!'Sheet '  FB@ $FB@H $F $FB@ $FB@H  $F(oX   %(   %(  % 9 9 9lq   % 9 9 9lq   % 9 9 9lqx   % 9 9 9lq@  !!   % 9 9 9lq   % 9 9 9lq k k 7 Selection.Borders(xlInsideVertical).LineStyle = xlNone9 Selection.Borders(xlInsideHorizontal).LineStyle = xlNoneo h] 'N N$'N N'k N'i  ]0HB 6Input %F%H!JX ' 6 'F'  X 8X G  'jB Input %F%H!JX '  ' 'i ` ]]0H' X X  T X $R'x'd B 6Input %F%H!JX ' 6'F' B Input %F%H!JX ' E Input %F%H!JX'F Input %F%H!JX'   G Input %F%H!JX     T Z $R'x x \'E $HB@Hk kk  '  'k 'zi` Set Print Area  $!:  $! !( !999999? r%9? r%9 r%9 r%9? r%9? r%999 99 9 99.PaperSize = xlPaperA4 9 9999 9"qo ! Apply supplied font to selection !& !$(& !( !$(( !l !$(l !* !$(* !, !$(, ! !$( !. !$(. !0 !$(0 !2 !$(2 !4 !$(4 !6 !$(6 !8 !$(8 !: !$(:o Insert task cells >$B@H @ P(R >$B@H !j (9l V9Tq >$B@H B P(R >$B@H DX $XX P(R >$B@H FX $XX P(R >$B@H H P(R" Insert Optional fields if present JXX > $B@H J P(Rk L > $B@H L P(Rk N > $B@H N P(Rkho`]h Z'N N '\ \ N \ $'Nk N'Xi Insert task cells!ThisBook.Sheets("Input").Activate >$B@H P(R >$B@H !j9l V9Tq@ >$B@H P(R >$B@H P(R >$B@H P(R >$B@H P(R Clean Optional fields > $B@H P(R > $B@H P(R > $B@H P(Ro Reset Full Task List]8Ph?A@@ Set Objects D. D.a.a Confirm Task List Erasing  T V Z $R'NA N \G|j4>% Confirm Task List Erasing - 2nd time.a  T V Z $R'NzC? N \G|j?( Loop to insert blank lines on all tasksB 6Input %F%H!JX 'zC'  Delete content from row|> 6  A@^  'B 6  Input %F%H!JX '=  b X A@Rox=, Returns the letter of a given column numberai.ai] dZ$h d$j'fd< dZ$h A$h  'N:A N$j'fk< f'bi< n p(rox<p<]$C WWW.OFFICEHELP.BIZ - Calendar Plan Generator 4.1 ADVANCED Edition "C'Attribute VB_Name = "Module1" ' (C) OfficeHelp 2006 - wPww.oTh*. biz ZVersion Code"COMMON CODE M ODULE.PublicLnst MaxDemo Tasks~7 Day2HWee=49>Month@10!hCal/5/1H771WKZTLrux \DL M$TH YR StartRow36EDITIoants0ItsA+CanChangeMSG@FalsmDefine  BOX SngOC_MAIN_ TITLE" WWW.OFFICEHELP.BIZVendar Plan Generator 4.1 ADVANCED ExditPE lh3!SV+*wi0have no'"bar. Press OK to proceed, CakLADWXCEL_LIM,IT/_n s Splittin gOE DAYS '$Q`S&8has0@-(d`. Excel |e N on@e256 columns @and up!6P are`d"Yh(ead s(ma`ximumg'@rgth/thereA`_e 250@Dy@F@aak`F:@ k#C_4CP#< automat6i`+"s3s every lacomple mA?UWEEK_D_zC_S(b wye@2!Ifo( ,kNj"lsC_OUTLOOK_$P=- Outlook SPdrity!Ms ue ResourcPphal field4active. ImporB 0IasfromAappointme% NfiIt3Ework IF you do ALLOW o!F_UTV& / A  Wi0zardFINISHp| i@Ր<!Rp  qes'NeVrnuB_CLEAy%wLipG"etN%exW `PLETELY ERASifBU Dowc n  r{"K 20 ? SGRA+$suE ] "2whole"  0J' ubeen Psa I@TH^^z u^9 e4/{/{/{/{t6B/{#{^eO{t? ^^^^^{{{a!<P _YEAR_DEMOqrlimit{9O7 >5only work from 20 04 to85.@ Using L instead of " Public Co* MSG_MONTH_DEMO = "Version limited7 tasks and 7 months for each plan.\@WEEKLY,]weei\DAI-@27 day!\RESET_WARNING_TIT LE - Original messages will be restored+*The@ existM'COMPLETELY ERASED if you procegdto$on#! Do wantr ?k=2=2>CT@>> >;Nf3fUzhadvezen{R EPLAC@zby'7terbelowK K`U # L. Y Nmay%.&#late8r u3* button.?Qǒ NO'available CUSTOM Exdit $+ $funceare0 try!ruse is not L Pleaupgrad]o$Kh#ULink p` ' Decl!VariGC$ys (pEo@izae)AĽ_MAIN$As Str`END ERR_SELCALMACR O_ESCDATESsC"_TASKS; I!_1_2_3tEXCEL_`LIMIT+DAYScu} cM}4 x{ z" / r? OUTLOOKy",0?'ÒFIpNISHYOiR OWCLEAB˅@FSG @!2_$_$ӧ?3$;UpvU(P^d aPov@ldmacro code,ZmodulesUNewPBookWpb, This_pMain5I nputPNaLmeZ, S, InputNLevelConfig4`DatesX, MSunteOptionFlag Su b Set=Variables() ' Cur@rently from BstantsFut!p edi, w ill a personaliza If IsNull(S) Then[= 0CanChange 'Get themGOSheet52> ) "viskActiveWorkb!MainE _MAIN_TITLE CStr((Th.&s("MHS").R!5("B2Vaxlue@[END4 & vbCrLf a"5L"End If@ ElseC' ^sH^conE-@C69 ERR_SELCALAA_CRO_ESCB MADDATESBB, _TASKS BA_1#U2233EXCEL_LIMITgQ_ DAYS hM7 4 4 WEEKXHh?  IHhOUTLOOK_WARNING82g m&X"FINISHEb_E ROW CLEAboSX=C?SSG @=G6#/SGA 2.%rm McqRQ~??ti7celS2danҟ {  ONFIGߛߛћN %ߞgD61|/*//3/r?ge0//и("D699Re7Q:03 10h::@::: :#Q1M:xp:A:>|W:A:r8#::'oH&plBMuxltiR= Sa(Cj7eR)@Erasing^@REPbP y@@0@ R#) - 2nd time aux = MsgBox(MSG_RESET_WARNING_D2, vbExclamation +CriticalOKCancel, TITLE2)If vb1 Then Exit Sub$ ' Set Xls from constantsCONFIG ThisBook.Sheets("Config").Range("D61A ValueyC_MAIN_O& 3 AuxStr(0m ?41' MHSC bB2"a @/K5D>.-P3InforOKOnly֌ E… GetInp$utqs(O' Obtain vuĉthe i sto p ublic ripable@ point of dentact with 3ur Dim²As String($ED?BmC9'#~F1s f UCase(`)`u"ALL"c"NLeve= 1000 Else CLng("0" &47EaC"No Split6ByMonths 0V8 @[Ifd+$ Lay`== K*:1f AC$ouX= NWeek1 GlobalMaxDay* 3w@@(</1.Extraa -(USelefhat pS@oould beXdAllOpȐFlag Fa%"MakeDaily(Cj(EfSD"`* a F  Year   F? 5 B f &  -0h` allS a sPMle run,TruT_ee #E3%R3%FieldQUBR>sz%o%abg5I3RLenφC2% SDy"PS"IncludeG P(= 7Hz3n15 { J?r>al1("GO??= ? ac ?ut?z32?2w&K?=?("K??;K3??aB c ?>|&E;`Task lumn Width qaCoQBO;C2 BEbeA@?tz(_- z(˛C1(3&"C1M(4// 6,5// XQ.6// 8_th}C7// "]8//"C20_U>9// L10??0)1))"Config").Range("C23`Value ' Get Weekday names - Not @in use4.0 If Fal Then  InputtNr(0) = ThisBook.Sheetscr F12H1W$HH2$$4H3U$$5$4$$6$5U$$76$8E nd IfOutl| Defa@ults DColorInterior. IndexFLevelb`D!DeadlineKSourc !G2TasksComplet(CStr( C4!g"Yes ")CNoDa 9%8I Allow%ecureFields%c 51 BackPgrou`Fa`Fonts fro,m HH 4erlBGE3aFS? A q>  A+g3>v% D OptionalC2hG?v ?% #PlanAreahPr end@4AOR ~Mar6k_KI4VKEZGl`obal f@ Variable UseGri_hG#5&isU@ !}sȘ?s$s~ia Store full cal0ar `gth befsplitting Real[ST4GED=bSub` Main(L' On Err bResume NextPNUGoTo hPCleCance l Ap` ca1a1.EnaKeRy>xlH"rDim aux As Str `, msgQ#geB`CMSGa= ""3E[ActiveWorkbo'Uoғp2#NRBa#Checkǘ Exit `S'xmo P30@ on$ItsADeà`AFlag1' Show on esagst[ of`e per pA typqMsgBox 0_DAILY_DEMO, vbOKOnly +TIn'm,MAIN_TITL~Es Ň` YR AfMakeYearDL" OrB"DWKMTHYR"o L!W ?Q  F aQ' @3i` {Mvhfggin0 A.in.?0WK+WxP9"x  qR"K DLDai"! -sinDL(?S/7XEERR_SELCAL_Eor_EWEEQ (GENDiJi l:@j .NumbR= L185i= #(RMACRO_ESC1Excla RSRu @Eҵrr.Number > 0 Th en ' MsgBox EDescription, vbCritical +0OKOnly, " 2005 WWW.OFFICEHELP.BIZ - @ERROR" 'Resume Next En0d If Sub  SetColumnWidth(cl As String, w Integer) ' col = "XC:Fk;s7).Selecp .]w@@CreateOutputSheet(NewNa_D=Dim LasJLoP L u= sEunO4g8" &0!Add ,(+ 1(& 2sIMove After:=C(F@9BN UN1MWMakeBorde@r(w, iNBoolean1mj s(xlDiagonalDown).Lin@eStyle@px lNone_Up With@EdgeLeftBC Conti`nuous WeightorIndexB-Automa AŁ!C$Topm# ah9t_@__$_$_$la6R/???'IfY>@-~1a 2QInsideVerH%R% .SxlThiCEV|Horizfalk b !Ei'_3l" 9Func CoǀTasks()ᨉA !aux#xA= NR#?)SiSReal$CT`LcY! y`O%  OnAo|r z #UXl#2yll2u, CNTGs pw!wC("1siDk.q"In ").Range("BAStartARow).ValueT-P~D1:2= 0W hi0l7<> "EPCLng() <= "NLevels)rD1怑1_hi_t\lP- u2@Wend %$!` e!@ CheckA D砘-T Q 4 ! S3sFd!!, emsge#, fla1,= T\ruĈ(S*T)`_CGEDCKc=Ը(MSG_DATES_MAINExcdlaonT0ITLEU Fals E !O0O0O0kN00L0100!O O O G ?,Q <8?oy!7Ats(AEA_SQ0&ooGGF'@ >+%i%%TASKS_1@PPPG 8(M20& 3,vbOKCancel,,_ - P3 p<= 04FIo ? [3@*]WVVSV?V.on Sub SetPrintArea(a As Long, b(c(d()~ '   *On Error Resume Next2ActiveSheet.PaDgeup. = Cells(a).Address & ":"c, dVWith [.LeftHeaderf"" @Center Righ(Foo?( ( (Margin(Application.InchesToPos(0.|75jl)1Top 1 Bot8tom CW 0. 7J0BingsTFalseH}GridlineCommdxl Noorizontal lyPÙVertvOri@B}xlLandscap .Draft'@perSizeP@ rA4A)FirstNumb`xlAuK9 cOrdxlDownThe nOverBlackAndWh it M+Zooma.Fit`X~shWid1h T'End {CFGoTo 0`AACopyF`0(F!W' iy sujed f  to sele`#i S.A.Bold!C,Cola = F."wIndexb Styl"+rI`Mic Ct@bתU4r!!bc lMSaveTaskDet4aiL"Levele, >D`L@!S0STDa j Variant, E>DNAB:%Pe@rcDone D@ouble,ourcbCatt] ' InsɰI t cqx4y , 2).0cwy*rmulaR1C1, 3{W5IxioF3pt; POt x!sxlSoxlidCK 4wO pO E4s(5OOC(GetqOnl(y(C())T 6c#', 7O&d"Opal fields if plIf CDbl(!)) <>0) etp9 &t&QIfd 30""?U;, 10OODe]O 1@6 11`;P QZIFunl &DT(? Dim aux', PAt= DTP8In+p`, " "+PPp > 0(aP - 天  0 e F~lean)T8u ?Ms 'ThisBook.s("Input"vPXz)O!ONullOOerOr24OaOi, O [ ?O!DSMK ' Ca# \KjG_9T9!2mD'lA1 z@S0JetC2st(p1'et *Full Task List Dim CNT As Long,AIndexHStriPau8 SetMSGVari ables,' 0 Object(R ThisBook = ActiveWorkbL Main&,' Confirm Eras = M@sgBox(_CLEANING0_WAR , vbExclamation +CriticalOKCancel, !TITLDE)8If 9vbwen Exit Sub[ - 2nd time&`2Ba20sE3Loop to insert blank lines SzatĀAC= "" & C(B.Sheets("Input").Range("B StartRow).`Value-= 0C%While9<>@.' Delete content from rowCleanL@2 H @=+ 1:@N@:Ã;WendCCӨ3InforȹOKOnl6y[% ER"X Fun w@;ColLetter( Num!):p' Returns the .I od gn 0lumn numberÐout}',"jlD<sc("Z")bma<2hDxElsdkkd -D +CA -: "A"W@  $If% C#`!(E')AGrideaLs(sAO indow.Display3Ak= Ah3 (L:P7%`:d8%t_ t d`0A `)t`60 L:P9%`:d8%t_ t d`0A O)t`60 L:P:%`:d8%t_ t d`0A O)t`60 I:P;%`:d8%t_ t d`0A `1x)t`60 #xMd@0 <0:P=]350h }>lx*#P/I:P?%`:d8%t_ t d`0A `1x)t`60 lx@0  lxPL:PA%`:d8%t_ t d`0A `)t`60  %Md@0 B0(P]350   W:PC%`:d8%t_ t d`0A K#D0/)t`60 W:PC%`:d8%t_ t d`0A K#E0/)t`60 W:PC%`:d8%t_ t d`0A K#F0/)t`60 W:PC%`:d8%t_ t d`0A K#G0/)t`60 U:PC%`:d8%t_ t d`0A K#H0/)t`60      W:PI%`:d8%t_ t d`0A `#D;/)t`60 Q:PJ%`:d/%t_ t d`0A B`)t`60 I:PK%`:d8%t_ t d`0A `1x)t`60 lxL0((W:PM%`:d8%t_ t d`0A `#D;/)t`60 Q:PN%`:d/%t_ t d`0A B`)t`60 I:PO%`:d8%t_ t d`0A `1x)t`60 lxL0((W:PP%`:d8%t_ t d`0A `#D;/)t`60 Q:PQ%`:d/%t_ t d`0A B`)t`60 I:PR%`:d8%t_ t d`0A `1x)t`60 lxL0((K:PS%`:d/%t_ t d`0A B)t`60 W:PT%`:d/%t_ t d`0A `#;/)t`60 W:PA%`:d/%t_ t d`0A `#;/)t`60 W:PU%`:d/%t_ t d`0A `#;/)t`60 W:PV%`:d/%t_ t d`0A `#;/)t`60 W:PW%`:d/%t_ t d`0A `#;/)t`60 W:PX%`:d/%t_ t d`0A `#;/)t`60 W:PY%`:d/%t_ t d`0A `#;/)t`60 W:PZ%`:d/%t_ t d`0A `#;/)t`60 W:P[%`:d/%t_ t d`0A `#;/)t`60 W:P\%`:d/%t_ t d`0A `# ;/)t`60 W:P]%`:d/%t_ t d`0A `# ;/rU~| A B???@i99999:)9:Y   Y yA@  IA1A 2A4B,A0!BABqBB!CA( )*A,CCCCDK <)<ADaDDALDDE1EaEEEEEFAFaFFFFFG!GAGaGGGGGH!HAHaHHHHHI!IAIaIIII J)JIJiJJJa8JJ K)KIKiKKLL"LM1MQM QQ)RQRRRRRS9SiSSSSS T!TATiTTTTUYUUU VAVyVVV!WaWWWAXXX)YaYYYY)ZIZZZZ[I[q[[[[A\q\\\]]]])^]4Ml@ " idh$ HQhh$ HQhM:T%d:l%h_ h dd4A$ K)hd64$:T %d:l%h_ h dd4A$ K#  *# *#: %:%_  dA K#*2 )hd64$  T T T T T T T T T T$ T( T, T0 T4 T8 T< T@ TD TH TL TP TT  TX !T\ "T` #Td $Th %Tl &Tp Tt 'Tx T| TK߂$ < hd4$X (F3'':8)N((@:X*NHH +6H($ HQ$ HQ6'':8,N((A:X-NHH^+qx6H(lx:8.%:X/%_  dHA( KF%:%:%_  dC )6H(:80%:X/%_  dHA( KF%: %:%_  dC )6H(:81%:X/%_  dHA( KF%: %:%_  dC )6H(!X(Ph,H(@ (F3'':8)N((@:X*NHH +6H($ HQ$ HQ+  *FH( 2(h5H6'':83N((A:X4NHH^+qx6H(lx6'':85N((A:X4NHH^+qx6H(lx3E: %:8.%:X/%_  dHC )5HS(X%hH%:0%:/%_  d(C )6H(S(X%hH%:1%:/%_  d(C )6H(E: %:8%:X%_  dHC )5HS(X%hH%: %:%_  d(C )6H(S(X%hH%: %:%_  d(C )6H(3'':83N((@:X6NHH +6H(@(Ph$H()t`60 W:P^%`:d/%t_ t d`0A `# ;/)t`60 W:P_%`:d/%t_ t d`0A `# ;/)t`60 W:P`%`:d/%t_ t d`0A `# ;/)t`60 W:Pa%`:d/%t_ t d`0A `# ;/)t`60 W:Pb%`:d/%t_ t d`0A `# ;/)t`60 W:Pc%`:d/%t_ t d`0A `# ;/)t`60 W:Pd%`:d/%t_ t d`0A `# ;/)t`60 W:Pe%`:d/%t_ t d`0A `# ;/)t`60 T:P^%`:d8%t_ t d`0= fA g")t`60 L:Ph%`:d8%t_ t d`0A ")t`60 L:PJ%`:d8%t_ t d`0A `)t`60 L:Pi%`:d8%t_ t d`0A `)t`60 W:Pj%`:d/%t_ t d`0A K#k0/)t`60 W:Pl%`:d/%t_ t d`0A K#k0/)t`60 W:Pm%`:d/%t_ t d`0A K#k0/)t`60 T:Pn%`:d/%t_ t d`0= fA g")t`60 O:Pn%`:d/%t_ t d`0A op)t`60 T:Pq%`:d/%t_ t d`0= fA g")t`60 O:Pq%`:d/%t_ t d`0A op)t`60 T:Pr%`:d/%t_ t d`0= fA g")t`60 O:Pr%`:d/%t_ t d`0A op)t`60 T:Ps%`:d/%t_ t d`0= fA g")t`60 T:Pt%`:d/%t_ t d`0= fA g")t`60 T:Pu%`:d/%t_ t d`0= fA g")t`60 W:Pv%`:d/%t_ t d`0A K#k0/)t`60 W:Pw%`:d/%t_ t d`0A K#k0/)t`60  p(Px$t`0  x4K% x$ x <xx (yCtx$ HQxx$ HQx z  { 0'' M@@@:`|NPP +6P  /(lt}0lt~0lt0lt0  z Ct (lt}0lt~0lt0lt0z  z Ct (lt}0lt~0lt0lt0  z ~Ct C(lt}0lt~0lt0lt02  z }Ct lty0-' 'PM@@@M`@ +6P -' 'PM@@@M`@ +6P $ xx lx 1' 'PM@@0 M`@^+pr6P /$ xx lx/4(txP `2 Fh%x$ `x8x58&Dh%x $ xx D`$P xH8$lp$ p 0llqxplx#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$p(Pt$hp$   LL LLL`8`4`0+P`kyy?i `Ht`p`l`h`d```X`P`L`H`D`x<`H8`4`0`( `k44 i iiii0i Pi$pi(i,`x`t`p` hPp|` %@pH ( X @ x r8>XbR@D @p 4 @ $ @  @  @ @ @  * @0 @ @`  @ T|>@>@ @ @ | @l @\ `Hx0 P *@  ?@  @h @ @8 ?@ ?@ @ 0`xHPhp6l@P :@@ @< @, zC@  @ @( :8H V"$@ @@ zC@X @P @h `:p:@ @`hj@( :@':@ ('@ @ `h,@ :5:@`5(=zC8"$p@8 :@P @h @| zC@l @\ @X :@H @D @@ zC@(< @8 @x(8XPh`0`x8$@H @ @@ @ @( @ @ hP"$0@  @8 @X @p @ @  V.@pt @ p`8@n @Hh `  @d H @T p"@P`"H&@@ +@@<`+@8 @P( @h @ @ H@ @ `5@ `0D@ XU@`@U@ @ `bm 8X0 h8X`p`xX(8$6@` @P @ @h @ @8 @ @ @ @ @ @ @ 8P($&@x @xh P%@d`8%V*,"@T x5@P`5@@ G@@<`0G@, XU@(`@U@  @ @ @ @ P0pxp(@Vf@X @H @8 @( @ @ @P h(@ P@ @ @  @H`8PP2@ ` @`H@ `p" P8   'KX$*\& 0  @ `p  @   +4Y8p x0V(+   0 8@ 4^H$   "&   @H &h2E 16    8 Xp$A6_     (  *0 @ H  P  X  h  x       $F  :h  H P X  ` h p x     *         !   "  0  H X ` x          * F(  p @      D      0 @GH  @G   7  :*P  B &   < @ H  X )h # A20 H %X<kh *     $<kH E` *    %"5A *( 8 @ H P )` x  :  ( 0 @HP 4`     ( 0  8@AH *h x    1   &H : PX`hpx       B & 8 @ X h-x  (  0Y<q@2a.X0Y0Y88fh0Y0Y2(( ` p , = "   *   ( 0+@ P,X*h x (     E  *  (0 E@ #`%p     E " $ ( *@PX ` h :x    E " $ ( *@PX ` h :x  4: 8   0@<rH<r2b.Y0Z0`0Z8g0Z 0Z@ p         "   . (!@!X! p! E!6! !!!!! ! "(" C@" *`"p"x"  " $" "$" &" " )#2# *0#@#H# P#X#`#h#p#x##### ### # #) (C) OfficeHelp 2006 - www.officehelp.biz Version Code` DAILY PLAN SPECIFIC CODE MODULE On Error Resume Next Create Calendar]@Xp0]8\ r(32 Demo Restrictions 8 >  X b      #$%&'2)*+,-./01"3456789<P>?@ABCDEFGHIJKLMNO;QRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~ A@RkkS DEMO and ALL MODE: Use the most appropriate split for each calendar (better demos) 8 >G'j Define Split limit '  * G *'j G *'j% Check if calendar fits (Max Columns) .d X X$X ' X'??d * $'d $ $$$':  *  *         T $R'  GA@jd     A@d`A@kPkHo@]Xp]0g i]H`xE. The'F' Define Split limitto pro 'o  * G *'j G *'j9 Calendar loop - while the set finish date is not reached X'sheets X' 256 c ' X' are ud  $'cad $ $$$'date '  ' 'A@dd $X X$X 'd $X'lendard  $' G'jques   has ' 'dd $ $$$'d fokx  G'jard $' '8 ' 'o ]0H`.]xD Select Output Sheettting ' GOutput'j CreateOutputSheet NewSheetNamety  WorkbookG !.j B@ %FB@H  %F( Set Gridlinessage 6GA@ljth Set Generic HeadingsyingARQ@A@reB XA@ work TaskB  $H(JB  :B  $HB@H  9 999999q !jon E 9l V9Tq "A@$ING - A@set Optional ColumnsC'st wil ASED i $d. D  $XA@? $   $H(JRese   :   $HB@He whol  9 999999qp !jcale 9l V9TqH "A@$el she A@y 25 $h $j'used fk $hD$h  'ore 25 Insert Daysarting$' 8  "G "'jk $'~ ~  G ~'j Insert Taskslendar 8 ~ $G $'~jk ~$'si$ Insert General and Headings Bordersrom 20  $    ~  $$HB@Hit A@s an  $   ~  $$HB@H A@week Freeze Taks : $B@H7  p(27 day Set Print Area Sheetiginal         A@dp    ~     A@k( Move cursor to top$B@Higin3 Increse Start Row for next plan (if in same sheet) Messa SheetG    'jed andox] 8Ph]igin](ored.]@XWA X'iginal X'will bd  $X 'ted 8  $Th $ 'sad  $X'e oneskpkh'F'F 'gi   using Insert Day Do yod  $'   '  $B@H $h P(R "A@$ ( $ $G 0'cG 'j.i !j 9l V9Tq0 A@ draw vertical background line $ $G 0'cG .'j?  :   $B@H !j; 9l V9TqXP Insert Month Name $ ' $  $'  $B@H !j 9l V9Tq  @A'  P(R ' "A@$:     $   $$HB@H.a  9 999999q ' A@ k k  ?  $  $$HB@H  9 999999q A@Ak  Insert Week Number $:' 'k   $B@H !j 9l V9Tqp  ''W  P(R'  ': "A@$k $   A  $    $$HB@H:  9 999999qh k` A@H 'i8 p]0H]`x] A?]8 Get Main Dates X'>; X':d  $X ' 8  $d $ $X' MsgBox edate?k k  Get Task DataG 6Input %F%H!JX 'HB 6Input %F%H!JX 'C 6Input %F%H!j!l'D 6Input %F%H!J'E 6Input %F%H!JX' X X G 'jF 6Input %F%H!JX'0I 6Input %F%H!JX'J 6Input %F%H!JX 'K 6Input %F%H!JX ' ' X X G 'j? 6 'F'F'F'  X 8X  % Insert data into fixed heading cells   $B@H H P(R (A@$  Paint BG Colore !j &9l V9Tq X lB !$(&d !$(& X B@k " Insert data into optional columns'  % Donea$     $B@H Paint BG Color !j *9l V9Tq X ?     $B@H  P(R0% ( ,A@$kh  'kP Resource$B     $B@H  P(RSelection.NumberFormat = "0%" Paint BG Color !j *9l V9Tq ,A@$? X G !$(&j  'kP Category$;     $B@H  P(RBSelection.NumberFormat = "0%" Paint BG Color !j *9l V9Tq ,A@$ X G !$(&j  '?kP   X X X X   XA@ 1 Increase calendar line only if the line was used  '  'kG Input %F%H!JX 'HcB Input %F%H!JX '?C Input %F%H!j!l'D Input %F%H!J'?E Input %F%H!JX' X X G 'jF Input %F%H!JX' ' X X G 'j0I Input %F%H!JX'J Input %F%H!JX 'K Input %F%H!JX '  '  ' 8  "G'jkH@ 'i0P] Optio( Check if task is within calendar limitsH   G|jC27   G|j%H   G|jI34 Draw task bar%H d  $ 'd  $'8   X ' d ' k MsgBox stCol, , endCol7  %  +     $B@H !j/ j 9l V9Tqxd $' Xd $' Inpu MsgBox cntDate, , RealTaskEDate7  % $f $f P(R % !jJ' 29l V9Tq  9 999999q`kXkPkHo@8Attribute VB_Name = "Module2" ' (C) OfficeHelp 2006 - wPww.oTh*. biz ZVersion Code"DAILY PLAN SPECIFIC CODE MODULEHSub MainDL()DOn Error ResuNext CreaCalenda@r Dim9xDays As Long, NewSheetSMaxLidne)Au :FWC2D,/Start2^E@ 8= 0j C ' Check ifiHfi(lumnISet@isBookWorkb a= Abs(CLng(!YDiff("d", CR()EDa)jSrTb))3@g=$fA8Add '- |1,! s SeJl(Year_A" @K1-1 9!8!L8|>=aekk)#l(A!lEXCELlYSLIMIT_1h & &bp-2  )3)4zYesNozExclazc#ς{d!l'vbCTProceeda-hsDL#:E,>x (1@CHqAh)) +u>$b aq!Make4ƥ"s!K __ϩր<7_π_, fAC @~leanuurrA5u&a md2f 11xcS2= True: ImWSW\WWXd;y[Wi>SWiloopqhil3msV  d!mis not chedQe7JXs 1!`!= ayX_XM\-[ןXQXe 1%d,(r W2%q#CDi LDWC [rra; )sutWteyOn:q ouofD= ҩ_=A4  >y[r? WDI,o o_?)Q߁~ ځ 90r<*w Z)(OFcWnS0Gf0 p @q@tpebSؔcpq2' gQllQg,Q9LXEB' Select Ouzt $fPlan$fk@"0"1!b?"C2zCount0 OrZLay0 `xs.0$Ӄ.Av@h[s(1).Sel@ect NewBook.SheetName = `L8' Set Gridlines(If Use(pFalse ThLen^2eL^ 05Peneric Headi ngWjColumnWidth "A", 2.299 BCDbl(Task;)2Range("B" & 4 + PlanCount).Valuy""( ":#(6 $Wi[ion*.HorizontalAlig nmentxlCerVerticWrap8Tex"5Ori*at@10-AddIndM ShrinkToFiMerg@eCellsTrueCEnd = `"!   DL(`> GlobalB}+ 2{ # u q uV3|    @S'  G^alE sbN2o;M0)Xp"L 0@' + Extra` )낯.igF/-jp/ Kq  k Freez ak/tr6_nActiveWindow.Pa`*'[Veq Pt pAreaS!&1vSplitByLay@~= """5' 4p, ntC+/'pF20B - @E# wo#@?n!J7,AMs' Move curs`to top-1, Sub Fun@#on<1>>mlX@ Long) Dim sdate!Dp, e N, auxalf>rqAg1ncox`sweek1, wflag֘lea!mn As St,g,t o w, s ll2Wks%'cg (Tds9ED= Abs(CLng(Diff("d )) m0;%_ӱ1@r- 1!1+  Od@D":= I:#=p08CP#= _Fg a 5'=Ђte& , llr&+'=555, ncol).Sele ct ActiveCell.FormulaR1C1 = Day(auxDate)CopyFont Hea8der8ion.ColumnWidth3DIf WeekdC\ 1 Or7 Then Qor*PlanAreaEend0Else %BG3}WiGRInterior^orIndexG7= PatnxlSolidaEnd 4M@akeBor xlThin, FaY' draw vertical backgrou#lin>e#dXO ll2<1 To ml&NJs(6 + + C1t, ncў d? e fgNexD' Insa Mh Nam_wn2? - 1Bm `Input s() & "@& Years(4Q^PbOKNTc='&QoB<> cuKB"'" +C =# Kz M > Start'Num" ARange(#W,.saV,Š1>~) aK3/a. Horiz@MalAlignme =`CeVKBottom WrapT\R% .OriYat@ 0 AddB ShrinkToFitMergbsTruneO%4!?; If' Kll` (Ays)I?ILߴH=HG.#&#._#f#7"." ._"" w_ `CbY8` q̋2 wflag#,A C=4nv  s#qu`ܜ+#.tlB_t 3#/`sw𞏠9a"'WaN7Q uoG ps+ycH)6Qz@"`n @|)eeOl`ExtraA V A_eςEAxlAAz8AAW.A_AAA<*?B9BסsDLp$a QFunon !$Task(max1As Long) Di@@ѢQStsg, ȠE`(,ҶCNT%@&NTTot GSq݁q3E/JDpQɱ$!1 WPercDoneDoubleResourcrECgoryz,* Real: A&' Get MaDin@tescsVdCa(¹STeEDE= Abs(CLng(Diff("d", d, r))TDItsADemo|BӐ%>= x1Q%?D a3SMa`C6' MsgBox edate End Ifx X' Get Task Data8Name = CStr(ThisBook.Sheets("Input").Range("G" & StartrRow).Value)NIndexO"*T YBYCol,orYJC%Interior.!QXDeadlin-DR&S7E'If C#ۂ,) < s) ThenBu#EMwF#}PercDoBKCDblX("0 NIResourcO JC@gory ?KReal?@T[Jk) >>DkHkll) + 1: ll27: CNT0Tot a 0CWhile@o<> ""CLng(H~A{NLepvelsA' Insert Ma into fixed hfing cell*skCA(+ PlanCount, 2).SelectActivea.FormulaR1C1 a opyFdK aaP3= >0z A .Bold!ruȿEls,Fa?F.C%HKaGopt/WcolumnG>C ' % /Ꭻ'BXO Fields(0qYtS3`m$TcJ!KdK La.>dk/N umberBatq@/"0%NqCBoB/+Q TS((X+  ' El_*R*1_*{  rm00" 0onal<0C0"C"3(3eY {S%%=f&%H' { %%2%%%%%% C?%<s| %%6%%ә%/$%%%%%nnt%F%%% DrawBarDL maxy,,㬟"),C.ۣ֥Jt уcrease calendar only if thewasp use<1дEqu?A`OMll%?ԋ0.Value)  TaskColor = ThisBook.Sheets("Input").Range("C" & ll).Interior.rIndex Deadline DT FSDatCC(E IqIf A)) < sd1)}xen 9 FEFFFReal4'6 X) >=Xe X# XPercDoCDbl("0IQI.*ResourcQeStrdJC^gory@C!2Kll+ 1G@CNT@VItsADem>oB} AA^@ >= Max=sº"" End IfWendGACInsertDL%Total AFunction ASub DrawA BarDL(maxcol As Long, xnumB, ‚õ@#A#GJ#@ Fy}4iKX nDim staC!4ccnta!&' Check if tv is within cal ar mitsD+&fw< C!ThyExit )!>d$'%p'51bar # = StartPlaBn umnN6+ Abs(Diff("d",,)$$'=Pf X!,.= ElseQ ]' MsgHBoxc>, Ond#D<= o$XA(FA= 0 To !Cells(]+ )unt&L+SelectKW@F  kF֋a s@od9e.PatnxlSoli,}!yK ->Add>81, $= Nex4-Rf11t<! UCasWAa0t> ""OTa RAMve.`mulaR1C1   MarkerBG12O; q.Horizon^Ali@gnment#CMe?&.VbiN+BottomrWrapT#9Fa<"D.Oriaf0}.@*qn   `rinkTo2F`V= Merg s UQut^qd1__SRP_4(.__SRP_5}Module3=v__SRP_60@ O (]/\M@ O (]/6 vPpV v6pV* $ W5ttqpkVD %lpC7 %lpC8 qp+n ;5V\M @ O (]/\M@ O (]/6 vPpV vQpV4 ddEl4vi %lPi%$ X$5* $ W5TTqPkVD %lPC7 %lPC8 qP 4fd%\M @ (Up>55k>RS*F\M @ `1D6Avi %lPi%$ X$5* $ W5@@q<v6i %llT?;+= )FlT@F,%P'@%v=v#*F%$ P,/P5hP'@%v=v#*#A*#v=*#v#*F%$ P2 P5P $ QP@%.@%/ c@%0(@%1f@%2f@%3 c@%4c*P $ PW5qPv6i@%lC7@%lC8 q 9 :+ ;5!v= B C`=5 Tfv= BD B{E ^Fqp8lp8 qp p^Gqx lxvH[lx{Hzlxz qx x^Iqpvi@%(%P$ XPlpvi%lxvJi|%<$ X<\X\$ X)PElhvi%l0i%$ X$5* $ W5TTqPvgi%lPC7%lPC8 qPlpPElhvi%l0i%$ X$5#o2Elhvi%l0i%$ X$5"l8F%$ (,* $ W5@@q<vgi%lR Elhvi%l0i%$ X$5"l4F%$ (,* $ W5,,q(vgi%l(C7%l(C8 q( j :lpPD +c% $ WdCe5l0q0:o(HLoPoXNN hl k$lhqhl`q`r:Wll#*F%:X%" X " d#YAZK#*1t2)6 r:+ll#*F%:X%" X " d#YAZK#*1p2)6 b<ll#*F%:X%" X " d#Y=5A7"qL/)6YDll#*F%:X%" X " d#YAZ`1H/)6Zl#*F%:X%" X " d#YAZNtX/)6oXN OtXZ\ll#*F%:X%" X " d#YAZNtP/)6oPt(oPN7 OtPg:]^ll#*F%:X%" X " d#YAZHtxMED@> LL LLL`8`4`P0+h`@k{{-i `Ht`p`l`h`d```X`P`L`H`D`<``8`4`0`( p `hPkXX i iii(iH Shei hGi$eOuti(i, `xB@`tB@`p%F` hridl`f A@` (`ener`"@ \A `x k i$  i& Hi(9`  h` ``" \9l`XA@$hp 0mns  %(p p r8>XbR@@ @ 0 @ @  ?@ @8 @ @ x *P @ @( @  h T@ @ @@ @X x @h @X x`HX@*@p @ =@ @ @ @ (@ >@ Hx0``H@6l@P A@@ @0< @0, :@ @ @ ?H V"$@ @ @ @ @ `0@ X@`@xhj@ '@8 '@ @ `(,@ P5@H``85`=h8"&pp@ @ @ @| @l @\ @X @pT HX@P pXp[@@ @< @8 @4 @0 XX@p(h8@h`x8&@( @p @ @ @P @ @ @ @ @ P"$ @8 @P @ h@` VH@~ @l ('@h`'@d @hT @D @4 @$ @ @ ` 1@ `0@L08P H0`xH`x 8&6@x @ @ @ @P @ @ @  @ @8 @ @ @ H8P($&@x @h &@(d`&hV*," @PT `@6@xP`h(6@@ PH@<`xH@, V@(`V@  @  h@8 @P @  h( X H 8P XpH.V@X @PH 0@h8 @( @ @@ @ @ @ M@ @( p@p @ @ X @`:hP@ M@8 E(E@ P!@``8!.@p @l : @( h M:  <f2@@X @ E @T` h ( E` @P `x P I !@ X ( !h!!!P!0!@l !@!!!!@@!H `!@"8 @!( @0" @! "! M@ xH"! @ 8@ P#!" p  p 'KX$*\Rffff*0X58e64b41*\R1*#3e4*\R1 "&     @8P(  @   +(4YH 0V(+  0 @ HP 4^X$   "&  0 PX &x2E 16  0  H  h  $A 6_       (  0 8  *@ P X  `  h  x         $F  :h  X ` h  p x       *         !    "  @  X h p           * R8   L     $(FH     D    BG hBGp 7  :*8 h B p&x   <( 0  @ )Ppx*! # ?   ( *8 Ah .#  %   *     ( %@ "5X A *   )  :X`hpx    4 (08@ HP X hp x  B &    0-@` h (x  0Y<q2aH.X0Y0Y088fX0Y0Y 2( ( 8 ,H =x "   *   + , *0 @ (H  p x  E  *  E #(%8 HX` p x  E " $  *  ( 0 :@` p x  E " $  *  ( 0 :@` p x 4: 8  (<r0<rp2b.Y0ZH0Zh8g0Z0Z 0 8 X h x       "     ( B ! *h!x!! ! .!!!!  " "8"2 P"<"  """""  " ## C0# *P#`#h#  p# ,x# ##*M#*K#-($ (8$H$ P$ X$  *`$  E$6$ $ $$ $$ % $% 0%$8% X% )h% %2%%"J%% *%%% &&&& &(&0&8&@&H& P&X&`& h& B p&x& & &  &6& && '%8' P' `' p'x' 4M'' '  ' ' ') (C) OfficeHelp 2006 - www.officehelp.biz Version Code`! WEEKLY PLAN SPECIFIC CODE MODULE Adapted from the daily version On Error Resume Next Create Calendar]@Xp]8 r( X Demo Restrictions 8 >  X b A@RkkS DEMO and ALL MODE: Use the most appropriate split for each calendar (better demos)t limi 8 >G'j Adjust GlobalMaxDays for Weeks  X ' Define Split limit? '?   $'  *  G * 'j G * 'j% Check if calendar fits (Max Columns) .?d X X$X ' X'd *  $'d $ $$$'?  *    *         T $RX '  GA@jd     A@dA@kpkho`0]pte]0Hsheets]`xX''F' Define Split limitd '  *  G * 'j G * 'j9 Calendar loop - while the set finish date is not reached X'$ X' ' X' d  $'d $ $$$'d fo '  ' 'A@dd $X X$X 'd $X'd  $' G'jt Ou   ing ' 'dd $ $$$'etykh  G'jd $' '( ' 'o]0H`xge]A@ Select Output Sheet Headi ' GOutput'j  CreateOutputSheet NewSheetName  WorkbookG !.j  B@H %FB@H9  %F( Set Gridlines 6GA@ljl Set Generic HeadingsG - ARQ@A@ OB XA@C'TaskB  $H(J$B  :B  $HB@H   9 999999q !j 9l V9Tq "A@$9 A@ Optional ColumnsC'V9T el she $y 25  $XA@' $   $H(JD   :   $HB@H  9 999999q` !j In 9l V9Tq8 "A@$G A@ $h $j'ert Gek $hD$h  ' Insert Days~ $'$H 8  "G "'jkp $'~ ~  G ~'j Insert Tasksweek 8 ~ &G &'~jk ~$'7 $ Insert General and Headings Borders  $    ~    $$HB@Hp A@   $   ~    $$HB@Ho to A@ Insert border over each month Row  ~  sheet    $     $$HB@H A@X Freeze Taks : $B@H p(ored. Set Print Area' Sheetwill b    X     A@'sad    ~X     A@'gik@ Move cursor to topert Da$B@H$3 Increse Start Row for next plan (if in same sheet)$h SheetG    'jo] 8Ph']](@A@]Xp d X'al bac X'ned  $X ' 8  &.' & 'd  $X'  kk'F'F 'F'P  h Name Insert Dayd  $' $     '  ' # Insert week number and format cell'   $B@H"A@$  P(R+ Insert week number in cell "A@$  (B@H ' !j9 9l V9Tq A@  ' Insert Month Name $ '  $  $'   $B@H  !j9 9l V9Tq8  '  P(RA ' "A@$ert We     $   $$HB@H $  9 999999q` ' A@k@ k8  $  $  $$HB@HA  9 999999q A@9k k 'ip ]0H`]x] 8`]P Get Main Dates X'  X'8d  $X 'X' 8  &:d & $X' MsgBox edatekH k@  Get Task Data MG 6Input %F%H!JX 'HB 6Input %F%H!JX 'C 6Input %F%H!j!l'D 6Input %F%H!J''E 6Input %F%H!JX' X X G 'jt F 6Input %F%H!JX' ' X X G 'jF0I 6Input %F%H!JX'J 6Input %F%H!JX 'K 6Input %F%H!JX ' 6 'F'F'F'j? F X 8X  % Insert data into fixed heading cellsX   $B@H into H P(Rg ce (A@$   Paint BG Color !j &9l V9Tq X e !$(&d !$(& X B@k " Insert data into optional columns'  % Done I$nto     $B@H Paint BG Color !j *9l V9Tq X      $B@H  P(RX 0% ( ,A@$ $k  'k Resource$h     $B@H  P(R$Selection.NumberFormat = "0%"H Paint BG ColorSe !jerFo *9l V9Tq ,A@$lor X G !$(&j  '$k Category$&j     $B@H  P(R$Selection.NumberFormat = "0%"H Paint BG ColorSe !jerFo *9l V9Tq ,A@$lor X G !$(&j  '$k  Insert main cells dataj   X X X X   XA@ X 1 Increase calendar line only if the line was used  ' w  'kG Input %F%H!JX 'HFB Input %F%H!JX 'FC Input %F%H!j!l'%FD Input %F%H!J' E Input %F%H!JX' X X G 'jX F Input %F%H!JX'0I Input %F%H!JX'J Input %F%H!JX 'K Input %F%H!JX ' ' X X G 'j  '  ' 8  "G'jk`X 'iHh] ]( @ ]X " Paint BG Color before drawing bar   $    X  $$HB@H !j .9l V9Tqp( 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   Draw Bar       $B@H !j 9l V9Tq & In first and last column, include day :    G' $h P(Rj  G' $h P(Rj !$(0  (kk$ Add Deadline Marker- Reloop as days d  $ 'd  $'   ' d ' k  d $' d $'    $f : $f P(RdP'( $h) P(Rk  !j 29l V9Tq  9 999999qkkkop ] ( @ X  Initiate flags'  Calculate number of daysd ( &$'" Iterate finding the right week  "d  &$' $X X  ' yd $  "G  ' jk@8 'i( ŶAttribute VB_Name = "Module3" ' (C) OfficeHelp 2006 - wPww.oTh*. biz ZVersion Code"WEEKLY PLAN SPECIFIC CODE MODULE%Adapted from the dai0ly vN#Sub MainWK()iOn Error Resu!Next CreaCalendar Dim9xDays As Long, NewShee6t S Ma xLineAu FinD2,/Start# ((`n- 2) *!Fc[=1 = 0bNc' Check if'?fi c!`lumn?Set isBook gBorkb ~= Abs(b5!Diff("dP", C(H')j') `G?$Add S,,A$ d3'l Seel(YearA#\K1-Q`4(#9>) i>>=AdC):CX,",(EXCELbSLIMIT_1 & `2'-3E-4YesNo`rvbExclaə)0A`% vbb Proceed0sWKC!E,,1`L+z)-P>$h?G-! qqMake02tU RZ [PzzA{xx x%{@w3|P.xyxxte, fn`Alean=urrqц7&a }1t2f 1 cS2= True: Ipq?a2S?aPl7aP*=o\@o\c o\`\u{loophil>s`[p `is not 0ched%_Ve9HJnKqSP ?`$Awte\# - 1_\61- \Q\e 1Il*YuW2'?Fri LDWF 7Swxwa; )yxρOxt  x jo"a2>»#bE?1 5u>p DI_ga)D?)Q߅, օ 0!<* Z)"cWpS0޸f0r| s)wse1ess pqU, MaxStartDate As 8 Dim llxLong, AuxLoop@ ' Select Output Sheet8NewName = InBPlan#|If $""` Then_"uCrec 0\mCount~0 OrSplitByLayer"Workbook=Set&Bs.Add,Y.ActivC Gs(1).t Gridlines Use LFalseӀX eL  (eneric Heading+ColumnWidth "A", 2.29CMB@CDbl(Task0) Range("B" & 4 + `).Valun"Ar ( "2:(5 KVWic-Zion!.HorizontalAlignm"exlCer Vertic WrapTex#XOriat @f0IndElShrin kToFiMergeCells!TrueCEnd n) -Ac("D"4S'Ins[`~yDp fs(ABtsADemo A>=aAuc aya[ DxWK(`> Global+ " #/   Weeks S E   `۳S'RGA_aPl bCNro{Mp) YqbL80'e+ Exxtra` @&@%4>)0p07H an⥽ Cdp  o/-  tt#%b3xovxeach mzhtTt) Y;0ll wD# S' Freezak4%sMJrnReWi ndow.Pa9Q = ! PPt ASA9mǂ3ǃ1 4#, 6.nt%CLng(B!R/2?/SE`6 7 @@Aa' M* curs`to topc@1, = Maxas > - 1^ bOxAddO!PEnd If = "":= True:= StartPlanColumnNum: = 0CFor llN`0 To D"' Insert WC1a[k0p>,DW Qday(D )1 OXr ()UnA1 + 2%K8-I+c7wAnu@mber a[format cell C@s(5'U, )).@Select Active .XmulaR1C1?N% inopyFont HeaderK!Cion.{Width3 "e==D BGWiG A|rior- orIndex PatternxlSolidk[MakeBor  xlThin, False)= <f,M'h N@f|ATw=@b s(E) & " & Year c $s(4_H+ _1 K1D;>.1"K`y<>k$ ^"'"@$(+ !C]`a >AaRange(23ڨ), 6 D) K8.Horiz`PalAliPgnme~= _C-eoV icBottom WrapText@9o5r.Ori@atFtc*>.m@ _*.ShkToFi?.MergTQ~n qDQ5R=2[A?G?GӅy ? {u(ner_({"f_(b}g('w''^._'*_'x'n&_ &q_& d&!ߟ## ""Np83gSc!WK7x qFuno TasksWK(max()WAAkQu1?|E@ CNT%QNTTotaS!q, !E/CQDlin4uWPercDoDoubleResourcJCPgoryC/TRea&l: C' Get0! sS̯̬ί̯̯̯̯-@qu9q0/&ͿPMsgBox#.C1@ta)U(s@kWe WK WPercDoneX`bl("0HI[SResourc,StrJ)CgoryU!)fKAllI + 1: ll26: CNTB0Tota 0AWhile‚Index <> ""Lng(AC= CBNLevels ' Insert qa into fixed heading@ cells C(-+ PlanCount, 2).SelectK Active .Formul`aR1C1@:A+Name opyFxontB;' Pa@* BG ColorKWith "ion.Interi >.T=BGQ Patn@.x@lSolidExnd a|L3=| 0b{ A .Bold$rul$Els,Fa? .C%HK!IfkGopt/WcolumnG>C - % 'BXO Fields(0qY tS3`m$TaJ!KdK La. ed ) Then # !ll + 1 xCNT  7ItsADemo+F>= M,ax:s@InHdex+""E nd IfWend ACInsHertWK%T@otal AFunction  ASub DrawA BarWK(maxcol As Long, linenumsIY, GS`@CdColorA DeadAiKuDDim stC@i# cntI% WeekFlaglean,: LC NDtaysNA\' Paint B G 3befo0re dT/ b areCells(T+ PlanCount, StartlumnNum),  + CLng$8) - 1)).Select`With  @.Interio$.OAre8aBGcPa t@nKxlSo$Pg {p# 'aF7L=: @@2C, ST]EDd$Rland. @,-]'sub`tract@F uto make *e+KC ' add hnU Os on the s! 3.3!Cl=ã2ElseQ2? h#<=a7 6@gFp@= 0 To j&AIga[ZhKiAhij%'@O first 2a&la, @includ@Hay{ConfigUseQ*sW[O:o/1 Afve.`mulaR1C1@-"'a| 5443oo6ogPFont.Siz8 5 HorizalAlignme_= xlCeT{?NexZ' A96Marker- Reloop a`s dayS V ,=?mpbAbs( Diff("d",V,"9)h= oV߯" $!" /Ce oCCAG)Ao@b1, X[b-P ß5UCas03A!) <> ">" p>ҕ= Fa YrAo;d;JO@(@;`")ȯb5qYY%36Zuq(; .OFt SOFBV@ip{IBottom"WrapTG!obOriMaQ0_R2P!2rinkTfD_9 P' Calculate number of days|NDayCols = Abs(DDiff("d",tEnd& Start)) Iterfinding the righ@t week%F or llb0 8To rauxV Add~ ll v1If C+(Search )>N) TXhen4WILen+ 1 `Exit X Else?( (6= 1) Or (urB 7= < If2Next2V Funct iom  (( 1]Z ( 0)pM @B9 Nth6C@pJvIq8 q0X"dX#XM @mp Ot\5?\M @ P (]/lXi]/5L vIl0qPl0q0Av!i %lPi%$ X(5#vQi %$ (, = >%( % $ R v:pV* $ W9qkVD %lC; %lC< q+~ ?5vQ{Q%\M @ (Up>55k>ST*F\M @ `1D6Av!i %lPi%$ X(5* $ W9llqhv:i %lhC; %lhC< qh l@lD=)UlD*F%$ (,5lDC@ = > lPvIv!i %l8i%$ Xv!iT%lPi4%d$ Xd $  )d 6 $ Q %2 %3f %4( %5f %6f %7 c %8clPq8+~ ?5lXi ]3Jv!i %l8i%$ Xv!iT%lPi4%d$ Xd $  )d 6 $ Q %2 %3f %4( %5f %6f %7 c %8c+~ ?5 Xfl0qxdd@P(lD@(d   y y- FqD6lD1(09 N6YV$#*F%:W%"X & d'XAYK1t/)6q:/$#*F%:W%"X & d'XAYK#*1p2)6 a@$#*F%:W%"X & d'X=9A;"qL/)6XH$#*F%:W%"X & d'XAY`1H/)6YZ$#*F%:W%"X & d'XAYNtX/)6oXN~ OtXY[$#*F%:W%"X & d'XAYNtP/)6oPt(oPN OtPf:\]$#*F%:W%"X & d'XAYHt* $ W9hhqdvbi%ldC;%ldC< qdlpPN+c% $ WcCd5,f% $ WcCd5*lpDrU~| s B??Lp&BqyeIfe^dfLY___xi99)RRQ]IpS_`A```)YaIaaaII\aYb`0iT])^eh!R9AhQR(]d!TC99S T)<eedJZ)giggIAL[Kgg" @$ @ @d ub.''M@@:0N  6  u{ {v { vqH     "qD5 lH qHlH qH v 9yy  Fql6 yt\%\M0@9  Otd5 ^dM0@ dM@ U U (B9 Ot\6 lllH[u'X'xM@4vlD#*#v*F o\0vFodvF^ql26 xXllX "llvv  $(Pt4 @ xXpJp.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~(Pt  P vCt lt0 Ctv!v"#0d.< '@%P$ P ($Q<%P "%X 0&1<(@%P"%X &P d'<()P<6ltF,%<(@%P"%X &P d'<))P< u* + + RQ@+,C -/y.;+/C -/A:,0%P'@%/v!#*F%$ P,/P5_P'@%/v!#*#1*#v!#*F%$ P2P5P $ QP@%2@%3f@%4(@%5f@%6f@%7 c@%8c*P $ PW9qPv:i@%lC;@%lC< q = >+ ?5 @ATd lTBlTC;+A -FlTDF,%P'@%vAv!#*F%$ P,/P5hP'@%vAv!#*#E*#vA*#v!#*F%$ P2 P5P $ QP@%2@%3 c@%4(@%5f@%6f@%7 c@%8c*P $ PW9qPv:i@%lC;@%lC< q = >+ ?5!vA F G`A5 TfvA FH F{I ^Jqp8lp8 qp p^Kqx lxv [lx{ zlx1z 1qx x^Lqpv!i@%(%P$ XPlpv!i%lxvMvIi|%<$ X<\X\$ X)Pl0q0B2Elhv!i%l0i%$ X(5"l8F%$ (,* $ W9@@q<vfi%llpP$+c% $ WcCd5l0q0BR Elhv!i%l0i%$ X(5"l4F%$ (,* $ W9,,q(vfi%l(C;%l(C< q( i >lpPD +c% $ WcCd5l0q0:o(HLoPoXNN hl j$lhqhl`q`r:Vll#*F%:W%"X & d'XAYK#*1t2)6 r:/ll#*F%:W%"X & d'XAYK#*1p2)6 b@ll#*F%:W%"X & d'X=9A;"qL/)6YHll#*F%:W%"X & d'XAY`1H/)6ZZll#*F%:W%"X & d'XAYNtX/)6oXN OtXZl#*F%:W%"X & d'XAYNtP/)6g:\]ll#*F%:W%"X & d'XAYHt LL LLL< ,p` o%%`Nt`0p+2`pk+`tk Va`p@`Nl 6`h k866;i: Xi<xi>`@xx `Bt `Dp `Fl `HXh j`Jd j`L`ndar`8\`NXd `P@T'`RPd `TL 8P` kOOqi: i<8 Ti>GA@`@8x `Bt `Dp ``Fl H`Hh X`Jpd `L``?`\ `NX'`PT `RP`jLok A`lD Exc`n`<`T8`p4`J,`r* `t$'P`v limi`x d is+|`t+in P`ftk ObpP*%@Xh(@vrDd2@x 4 68@ ` @8P @P@ @0 @ @ @ @ @ @ @ @ @ XbRT@xX  ` x  H ( `2x8  6@P h @ d @ T @P @ @ @ 0 @ @ @8 @ @ (pX h H ` 4TbXR@8 < @P , @  @ @ @  V^ <d@ @( @ @p @@ @X @ | @ l @ \ ( @L @< @8 @ 4  @, @ @0 ( X @p $ @ ? H @ H -8Hx0X P(p4TbXR@h @ @ @ @ @ 8V^ <|@ @@ @ @X `@ @? pd@ 6pFxx`|xx P'KX$*\Rffff*0Y58e64b41*\R1*#54*\R1*#3e4*\R1*#132*\R1*#121$*\Rffff*0      J8 ) $(  &8~`   LS   0p  6  0 P` hpLx      ( 0 8 @ " H <P &  &     8  @ H P Jh  )   $ ( @ X  h  DS  0    6 X h             0  8 @  H X  %x         "     8@"P  x   D]   0  8X`hpx B   ((&$ &H p x ) (C) OfficeHelp 2006 - www.officehelp.biz Version Code` OUTLOOK SYNC CODE On Error Resume Nextx.p v r(t]@Xr  Import Outlook Valueste C D.@ D.A@d$2'0   0$4'N NG|j0 NX 'N NG 0'Nj Calendar+ Import from Outlooks Calendar AppointmentsED E   NX A@60d( Import from Outlooks Task List   NX A@8.aik  X b A@R.   T X $R'x  eS MsgBox Err.Description, vbCritical + vbOKOnly, " 2005 WWW.OFFICEHELP.BIZ - ERROR"?kop$ Detect the first free task list rowa.a]?3 Loop from first task row until a free one is found`?B 6Input %F%H!JX '.ai' C  'B 6  Input %F%H!JX 'GA@ 6  '2i6 Imports Outlook Appointment data into Excel task list`]](@Xp] Set Constants 'L 'N L'P 4$t limi C Resource Field is active - Show message box about Outlook Security'j  T b X A@RkP Create Outlook ObjectsheOutlook.Application$V.@X'MAPI @%X.H P H%Z.B  B!\.D  Restrict and Sort appointments [Start] >= ' :ddddd h:nn AMPM$' AND [End] <= ' <ddddd h:nn AMPM$' D%^.J[Start] JB@` Insert Tilte Line >A@^ >   : <Outlook Imported AppointmentsA@< $* Loop to insert outlook tasks on task list' F J0 Delete content from row (start with blank line) >  A@^ Get from Calendar 4$  Resource Field is active F!b'Td'Tk >     F!f$d F!$d F!h TA@<  'If cnt = 30 Then Exit For Release Outlook Objects.F.B.H.@o6 Imports Outlook Appointment data into Excel task list]Xp]0H]`x] ]8 Set Constants 'L 'N N'P 4$ C Resource Field is active - Show message box about Outlook Security  T b X A@Rk  Create Outlook ObjectsOutlook.Application$V.@MAPI @%X.H P H%Z.B B!\.D Insert Tilte Line >A@^ >   : <Outlook Imported TasksA@< * Loop to insert outlook tasks on task list' F D0 Delete content from row (start with blank line) >  A@^ Get from Tasks 4$  Resource Field is active F!z'Td0'Tk 'x$  Category Field is active F!~$|'pd'pk$  Perc Done Field is active0 F!Xd'Jd`'JkP F!'r r G'xj F!:X 't t t 01-01-4501 :'t G'xjk F!X 'v v v 01-01-4501 <'v G'xjk` x >     t$d v$d F!h J T pA@<  'kIf cnt = 20 Then Exit For Release Outlook Objects.F.B.H.@oP] (Not Defined)'f nGTask Not Started'fj nGTask In Progress'fj nG Task Complete'fj ( nG Task Waiting'fjt nG Task Deferred'fj f'|ixAttribute VB_Name = "Module4" ' (C) OfficeHelp 2006 - wPww.oTh*. biz ZVersion Code"OUTLOOK SYNC CODE,Public Sub OutLookT est()BOn Error ResuNext GoTo handleCaPncel@l@ AppTat .Enab KeRyxlUH9r Dim au@x As Sng, AuxRoBwLongS ' ImportT4 Values Set ThisB@2ActiveWorkbIMain GetIn8put./I= DetectFirstEmptyOT0b= Box(MSG_@_ROW, TpITLEtIVfB}"2e_xitf CLng("0" & M0 ,C@ADiSourc˜Calendar A#[from\s @yointment`0hC RealESTDate, 3EC ' .Descripw Critical "5 WWW.OFFICEHELP.BIZ ERROR A2=*E*{Fu^nurkǀ'o the f!p free t@l@ rowCNT , @IndejAd@ae!p `^C un til acone is found# x& C("u.Sh@eets("ba").Range("BStarts ).a= 0 WhileH<> "-cq+ 1#kߟ@A KW@ // X#A?@? BL(a:c b'A;' Es dat$a o iel'IHEDObj, oFolder! FItemsG. APPns3d`ct'olsVs  , t+d3T0oUseONlDIr1)iuws|trP`' uConstav^ = 992s@13| = SS JAllow SecureField!DyOJals(1)S.1'_ss bM:arPJShmessage box abouRity# dRy|WARNING_0Xvb`@/bY?%"a1!h' Cre`s&,'*=("4.0/="DEqa)= .spacpIMAPI/utlDefault*( ݨoC2. 'U0 Sap~ph= 'UFBy7D, "d h:nn AMPM")"' AND [] <0SGu .b tZ!InseTi"lPLinClean=!0`a0MaCSavera il, 0, ColorDeadl,O3 4DWedj"=b"`)f rtoSb 3Rrs |݂sl`yK=5i Each 0P#S\CompleBoolean, Aux@-H!CDisaAAD ' Set ConstantscNY= 9KAs` = 13BV= `CIf AllowDSecureFieldind InputOptional(1) Then-' FX is active - Shmessage box aboutBityKMsgB MSG__WARNING_, vb!lama' +AInforOKOnly, `TITLEj IfG`CreD ԄbAg= C )(" . wlic"@{#{k=u.GetNa"pace("MAPIEx#Defaultn(:.+#`nse@rt TilZLin]Ca[AJA [SaveADetails!, 0,:ColorDead:l` ,cauf, #&ed s" """#' Loop t>o@`IBs |on``cFor Each $\;' DBe}contfrom r@X(r%with blanne/" 2'߀S ? 'qq! q )ED.OwnerElsB"  4Ei%= FaJ ы2ӋC`rgory ̋A= ,Wtus!l(b=.STATUS5R01e Be upg`EDbl("0" :&).(h) / 100/y]Nu'fmwA`Nqs("a TruX$jsr51Bh "" Ow@= "01- 4501"jz=Hwa Nou  0p 4CgDueAN&(qT dr n_X0rE>e Oc +qbLevel_dSdqValue(i,Ҷ[)BMS, 1, hL?1)c+ 1m 'pcP= 20cPit f3NexAYpb &/i= NothiAGA 0QFun`s;SsҾ!^)'3S 8(sf~dd)p{ p=> t3ed1In `Progr2uHX3_Wai6t0H4Operr z ? q! SCi9999lipm9mymmm1npndn o9oYohXopIqlAp`q)rIr!qrrxrs|YsssAttt)u KF% x$ x <xx$ HQxx$ HQx  ^qp9'''' pM@@MP@ M`@ 1t6 lt 0 lt*#P1t/lt3 lp1t v 0ltPY  ltPY  )'' MP@@M`@ 6 $ xx lx1'' MP@0M`@^i6 $ xx lx %,.t$x |(q : $#h*F@%P:T%d"X d dP AK#*1p2h)dP6 @ qt lp =ltqtx : $lt#h*F@%P:T%d"X d dP AK#*1p2h)dP6 @ }$ltqx((Pp,hdP@ p q` qXl`qTuY)''  M,@p!M<@ 6  " #  4x5 :<$%x %4h5 T@h &4t5 tW '4p5 :(:,)N  l M<@ *:+:)NlM@ *|:l,\%p<-4d6 |\<:<.%d/ l 0S C$$ C((,1C44lM,@l M<@23Y8l 4(24($ q\ldlt l\Y8 0ulW 5`1L5 " CLlW 64 7lW8( 7lW9 CL,`$23:l\Y8 4(24($6 l\q\ lu clctchcx#`HP0 LlPhpxdt@ 4($ |\<X q` qXlXqTuY)'' M@p!M @ 6 " # 4x5: $%x%4h5T@h&4t5tW'4p5 l 0S C Cɬ;ClM@l M @23Yl 4(2 q\lplt2l\Y 0uolW<`185y C8plW="Y >145 C4%: lW?Hdt,6t,lW@Vp*5k*uA#plWBK1$5l$ 0l$C0g 1$ uDgplWEK1 5l  0l C0 1 uDp k%]l$ 7l  7lW948,`Ǵ23:l\Y 4(/6l\q\ lu8clctchcxXXP@ 8lP$4hpxdt L$FCt  GCt 6HCt LICt bJCt xKCtltCx,Pxt WrU $`$`0` ,,(0` ,,((!`(nDrٞ#<\XtIٕsi F "6EAnx "6EAn\XtIٕsiMESheet6(__SRP_16&__SRP_17BModule5z(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%@h % %Xp@@``0'KX$*\Rffff*0Z58e64b414xAttribute VB_Name = "She@et6" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU qujui4Qjyj`rU @nrU $ `$ `$#121$*\Rffff*0R58e64b41*\R0*#1*\R0*#17*\R0*#13*\R0*#2*\R1*#13c*\R1*#13b*\R1*#126*\R1*#289*\R1*#11*\R1*#2d*\R0*#f*\R1*#285 0 0 (H &p "  &  "   0H P .Xpx  Z  &    8 Xh8(  ,  9  @(%P4^x,Bu(@("H px   "%'hٞnxMED@> LL LLL`8`4`0+h`(k{{*i `Ht`p`l`h`d```X`P`L`H`D`<``8`4`0`( p `PPkXX i iii(iHi hi$i(i,`x`t`p` h`f ` (``"@ \ `` k i$ i& i(`h` ``" \`Xp 0h %(p p r8>XbR~?@@ @ 0 @ @  @ @8 >@ @ x *?P @ @( >@  h T@ ?@ @@ @X x >@h @X ?x`HX@*@p @ :@ @ @ ?@ (@ @ Hx0``H@6l?@P @@ @0< @0, @ @ ?@ H V"$@ @ @ @ ?@ `0@ @>X:@`@xhj@ '@8 ?':@ @ `(,@ P5@H` =?`85:`=:h8"(pp@ @ @ @| @l @\ @X @pT HW:@P pWpZ@@ @< @8 @4 @0 XpX@P(h8@h`xzC8(h@( @p @ @ @P @ @ <@ @ @ ?P"$ @8 @P @ h?@`? VH@~ @l ((@h`(@d @hT @D @4 @$ @ @ `2@ `AM08P HHx`0`x?8(6@x @ @ @ @8 @ @ @>@ @ ?@  ?@h @ @ ?8P($&@x ?@h ?&C@d`&PV*,">@8T (6?@`P`?P6C@@ x8H@<``H@, ?V@(`AV@  @ @  @8 @ ? h( X H 8 @hXH.V@X 1?@8H @P8 ?@h( ?@ @( @ @z?@ @ ?@ ?@ @X @ P;@ @@`h:hP@ ;@  @ 8!@p`H !.@p :@l p:@ h :8B <f2@X ( E@T`P  E?@P `8 I !@ X  ( !P!!!8!!@l (!!!h@h!H ?@"8 @!( @" @! !! @ ?0"! (B@ @ ;! p  p 'KX$*\Rffff*0[58e64b41*\R1*#3e4*\R1*#132*\R1*&     @8P(  @   +(4YH 0V(+  0 @ HP 4^X$   "&  0 PX &x2E 16  0  H  h  $A 6_       (  0 8  *@ P X  `  h  x         $F  :h  X ` h  p x       *         !    "  @  X h p           * R8   L    $(FH     D    BG hBGp 7  :*8 h B p&x   <( 0  @ )Ppx*! #":   0@ *PA42  %  *  ( 8 @ %X p A *   )  :X`hpx    4 (08@ HP X hp x  B &    0-@` h )x  0Y<q2aH.X0Y0Y088fX0Y0Y 2( ( 8 ,H =x "   *   + , *0 @ (H  p x  E  *  E #(%8 HX` p x  E " $  *  ( 0 :@` p x  E " $  *  ( 0 :@` p x 4: 8  (<r0<rp2b.Y0ZH0Zh8g0Z0Z 0 8 X h x       "     ( B ! *h!x!! ! .!!!!  " "8"2 P"<"  """""  " ## C0# *P#`#h#  p# ,x# ##*M#*K#-($ (8$H$ P$ X$  *`$  E$6$ $ $$ $$ % $% 0%$8% X% )h% %2%%"J%% *%%% &&&& &(&0&8&@&H& P&X&`& h& B p&x& & &  &6& && '%8' P' `' p'x' 4H'' ''  ' ' () (C) OfficeHelp 2006 - www.officehelp.biz Version Code" MONTHLY PLAN SPECIFIC CODE MODULE Adapted from the weekly version On Error Resume Next Create Calendar]@Xp] r( Demo Restrictions 8 >  X b A@RkkS DEMO and ALL MODE: Use the most appropriate split for each calendar (better demos) 8 >G'j Adjust GlobalMaxDays for Months  X ' Define Split limit '   $'  *  G * 'j G * 'j% Check if calendar fits (Max Columns) .d X X$X ' X'd *  $'d $ $$$'  *    *         T $RX '  GA@jd     A@dA@kpkho`0]p]0H]`x'F' Define Split limit '  *  G * 'j G * 'j9 Calendar loop - while the set finish date is not reached X' X' ' X'd  $'d $ $$$' '  ' 'A@dd $X X$X 'd $X'd  $' G'j   ' 'dd $ $$$'kh  G'jd $' '( ' 'o]0H`x] Select Output Sheet ' GOutput'j CreateOutputSheet NewSheetName  WorkbookG !.j B@ %FB@H%  %F( Set Gridlines 6GA@lj Set Generic HeadingsARQ@A@B XA@TaskB  $H(JB  :B  $HB@H  9 999999q !j 9l V9Tq "A@$ A@ Optional ColumnsC'  $  $XA@ $   $H(J   :   $HB@Hx   9 999999q` !j 9l V9Tq8 "A@$ A@ $h $j'k $hD$h  ' Insert Days$' 8  "G "'jkp $'~ ~  G ~'j Insert Tasks 8 ~ (G ('~jk ~$'$ Insert General and Headings Borders0  $    ~    $$HB@H A@  $   ~    $$HB@H A@ Insert border over each month:  ~     $     $$HB@H A@X Freeze Taks : $B@H p( Set Print Area Sheet    X     A@d    ~X     A@k@ Move cursor to top $B@H3 Increse Start Row for next plan (if in same sheet) SheetG    'jX6o] 8Ph]$](@$ D]Xp X'G X'd  $X ' 8  ( ( 'd  $X'vY ((n- 2) aG!d#\=#2F `-O%Che ck if@ficlumn@Set@ isBo okgAWorkb= Ab s("6!"Diff("d", C(')j() '@@$cAdd ,,?$& ! Sefl(Yeara#_$BG1-R4(%#?) j #?>=aD)";_X,b,(EXCELcSLIMIT_1 &! 壀@2-^3d 4YesNosvbExcla#Cb)0 &Gvb Proceed1s"EL`-1M |)C.Q> 0 .! Q0 AMake?2uv [3 p{{a|yy yE|`xS}+~1k1Uy yfoCBlean=urr&a_@P2f ?c2 U12= @True: x2PAIr?bBS?b@#s*=A]7;28^?]c/]'' ' loop1hil3Ns\qp d!i@s not PchedEWe4:HJnKqÝSP? `$= a]# - 1\ - ?]Q?]e 1Jl*ZW2')FR0) LDW/F0S?x8xqK )zgygOxt  x0jRb8?sbU?1 :u>/p N_ga)O)Q,~  f0!<*b j)"ߋcW qS 1߸v0s sVZw?seQe?s?s LPong, MaxFinDate As 8Start T Dim( llLAu xLoop  ' Select Output Shee"t8NewName = In!0Plan>If $"" Then_"uCre?c 0\mCount~0      !"#$%&'*B,-./0123456789:;<=>?@A)CDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvxyz}~OrASplitBy Layer "Workbook=Set&Bs.Add,Y.ActivC Gs(1).t Gridlines 1Use LFa8lseX eL=  (eneric Hea0dingColumnWidth "A", 2X.29CMB@CDbl(Task 0) Range("B" & 4 + `).Valu"Ar &( ":(53 KVWi-Zion!.HorizontalAl ignmexlCer Vertic Wrap8TexXOriat @f0qIndElShrinkToFiMergeCellsTrueCEnd !n) -c(h"D"4S'Ins[yD@σp fs(ABtsADemo A>=Auc aya[ DMTH(p> Global"+ ѕ2 # +  M[hs s u ! S'GP_alň~ bNoM)`YAqLx0'+ Extra` @&%4)00wH an" d  p0-  /tt,bwov xeach mCAtsA)1:_VOllh ?:D# S' Freez@ak$snsI/rneWindow.PaQ =  Pt AS8A "ƃ1 4@#, 6/.nt%CLng(JBQ.2?{!/SE/6 t6 ?#`' M* cursto top#@1, uIncrePв@ Row fnAp (if in ssWd+0i+g`+ 6s QSubYFun`\onN5Qm)s7Asd!eN9Sauxi,*.gQ1ncolݵ As Long, sweek wflagpBoolean Dim mnameTStrio "w colHInteger 1ll2BMo@nthCou.r1 sdate = CD(InputS*T )eEDAuxDaysAAbs(CLng(Diff("d",  S#))*If ItsADemo T|heH )>`= Maxbs>- 1_ cPAddP!QEnd If= "": = True: s= StartPlanColumnNum: b= 0@For ll@O00 To "' Insert W{C2a[Bl 1q,X Rby( )@1) Or v(B)U@<#Pn; +J;/A B+n Bm number agformat cellC@s(5#c @, -).Select Act(ive.fmulaR1C1N)ORF$$in"opyF@ Hea8derAOCion.FWidth 3OG=D BGOWiG rior,!orIndex .PatternxlSolD $ ]"'" &C"!Eb(C\ @bp >TARange(23), 6 `@)w~ K8/aa.Horiz LalAlignPment`CeKjV\icmBottom!bWrapTexA?2Ur.Ori@|at D f*.oA> _*.ShkToFi?.MergS!Aq q+Q5dtZADD5| ?B)Rq(oqer_(Q~e_(Gg('w''^._'=0W_'x'n&_ &q_&`&!## ""Np83S1MTH 7 QFuno  tTasksap(max)WQQN13z0+aCNT% RNTTota"Sq, !E/CQD linD4uWPercDo@DoubleResourcJCPgoryr/TReal: s' Get! sSϬѯϯϯϯϯ-{uJұ0; ' MsgBox3C)/cQ0ta*0(spk=@eets("2").S"GхґRow).Val|ueA-ՀCA"AB+hiO t~C(60heets("Input").Range("D" & StartTaskRow).Value  LSDate = C(ThisBook.SE)IfG#mY) <sdh) Then W xE*FReal5*W) >We W! WPercDonbl("0HI[SResouDrc,StrJC`goryA{͡KAllI + 1: ll26: CNT0Tota 0While‚Index <>8 ""ALng(ACBNLevels ' Insert qa into fixed heading@ cells C(-+ PlanCount, 2).SelectK Active .Formul`aR1C1@:A+NamD#CopyFontB;!K' Pa@* BG ColorK With "ion.Interi[ ! .*= BFGp Pat@ n xlSolidEnd aP3= 0b{ A .Bold$raaEls&Fa? .C%gHK!IfkGo pt/WcolumnG>C - % ძ'BXO Fields(0qY tS3`m$TaJ!KdK La. edD) Then #3 !llT+ 1 CNT_ 7ItsADem>o+F>= MaxAs Index"" End IfpWendGACI nsertMTH%Total  Function ASub Draw Bar (maxcol As Long, linentumsAJ, HASAC A ColorA Dead{AiuDDim st@Di cntI% WeekFlag@lean, L@C NDaysO\' Paint0 BG 3before dU/0 bareCells(T+ PlanCount, StartlumnNum),  + CLng$8) - 1)).SelectWith @@.Interio$.EOAreaBGcPat@nKxlSoli$QLa #Check if t@n is w@in cal5arKmitsC @b@cE< M"rExit U}L>$Pg p# 'OaF7L= @@2Month(! d, bSTZE~DİDRBn.d/,-^'subtractF uto maxke *C+KD ' add< hoU `Os on the s $4#/)4aCm=2ElsHG)#<=B7 D6 gFq= 0 To k&!ga\hiAhig5q'' firstd apla, includ`H ay{ConfigUsea*s&W[O:o'/1 Afve.`mulaR1C1@-"'|@54D3oo/6oPFP=.Stiz!8 5HorizalA@lignme_= xlCeTE{?Nex$Zc' A96Marker- Reloop as0 dayS +,=?mbAbs( Diff("d",V,=)h= oV" $!/C qoC C)Aopbw1, X[b-P+5UCas3A!) <> ""沈 p>= Fa YrAo;d;JOQ1@(@;")U_Y qY%36.Zu ; .OFt SOFBVi{IBottom"WrapTG!obOriMa0_R2P!2prinkT 13-0 @2 BAjAFunctioCA__SRP_a#0__SRP_bModule6+$__SRP_c!$|CB9 Nth6C@pJvIq8 q0X"dO#XM @mp Ot\5:\M @ P(]/lXi]/5ClXi ]gt vIl0qPl0q0Av!i %lPi%$ X(52\M @ $ (,5 = >%( % $ Q v:pV* $ W9qkVD %lC; %lC< q+~ ?5%\M @ (Up>5\M @ `1D5Av!i %lPi%$ X(5* $ W9llqhv:i %lhC; %lhC< qh l@lD=)RlD*F%$ (,5lDC@ = > lPvIv!i %l8i%$ Xv!iT%lPi4%d$ Xd $  )d 6 $ Q %2 %     !"#%&'(*,-./012345678:;<=>?@ABCDEFGHJKLMOPQRSTUVWXYZ[\]^`abdefghijklmnopqrstuvwxyz{|}~3f %4( %5f %6f %7 c %8clPq8+~ ?5lXi ]3Av!i %l8i%$ Xv!iT%lPi4%d$ Xd $  )d 6 $ Q %2 %3f %4( %5f %6f %7 c %8c+~ ?5 Xfl0qxd\@P(lD@(d   y y- FqD6lD)9 N6YS$#*F%:T%"X & d'UAVK1t/)6q:/$#*F%:T%"X & d'UAVK#*1p2)6 a@$#*F%:T%"X & d'U=9A;"qL/)6XH$#*F%:T%"X & d'UAV`1H/)6YW$#*F%:T%"X & d'UAVNtX/)6oXN OtXYX$#*F%:T%"X & d'UAVNtP/)6oPt(oPN OtPf:YZ$#*F%:T%"X & d'UAVHt* $ W9hhqdv_i%ldC;%ldC< qdlpPO+c% $ W`Ca5,f% $ W`Ca5*lpD% $ b rU~|  o B??Lp%Bq yeIfe^dfX`hp LY___xi99)RRQ]IpS_`A```)YaIaaaII\aYb`0iT])^eh ! R9ALQRd!TC99S T)<eedJZ)giggI [Kgg" @$ @ @d ub.''M@@:0N  6  u{ {v { vqH     "qD5 lH qHlH qH v 9yy  Fql6 yt\%\M0@9  Otd5 ^dM0@ dM@ U U (B9 Ot\6 lllH[u'X'xM@4vlD#*#v*F o\0vFodvF^ql26 xXllX "llvv  *$(Pt4 @ xXpJp.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~(Pt  P vCt lt0 Ctv!v"#0d.< '@%P$ P ($Q<%P "%X 0&1<(@%P"%X &P d'<()P<6ltF,%<(@%P"%X &P d'<))P< u* + + RQ@+,C -/y.;+/C -/A:,0%P'@%/v!#*F%$ P,/P5_P'@%/v!#*#1*#v!#*F%$ P2P5P $ QP@%2@%3f@%4(@%5f@%6f@%7 c@%8c*P $ PW9qPv:i@%lC;@%lC< q = >+ ?5 @ATd lTBlTC;+A -FlTDF,%P'@%vAv!#*F%$ P,/P5hP'@%vAv!#*#E*#vA*#v!#*F%$ P2 P5P $ QP@%2@%3 c@%4(@%5f@%6f@%7 c@%8c*P $ PW9qPv:i@%lC;@%lC< q = >+ ?5!vA F G`A5 TfvA FH F{I ^Jqp8lp8 qp p^Kqx lxv [lx{ zlxz qx x^Lqpv!i@%(%P$ XPlpv!i%lxvMvIi|%<$ X<\X\$ X)Pl0q0B3Elhv!i%l0i%$ X(5"l8F%$ (,* $ W9@@q<vci%llpP%+c% $ W`Ca5l0q0BS Elhv!i%l0i%$ X(5"l4F%$ (,* $ W9,,q(vci%l(C;%l(C< q( f >lpPE +c% $ W`Ca5l0q0:o(HLoPoXNN hl g$lhqhl`q`r:Sll#*F%:T%"X & d'UAVK#*1t2)6 r:/ll#*F%:T%"X & d'UAVK#*1p2)6 b@ll#*F%:T%"X & d'U=9A;"qL/)6YHll#*F%:T%"X & d'UAV`1H/)6ZWll#*F%:T%"X & d'UAVNtX/)6oXN OtXZXll#*F%:T%"X & d'UAVNtP/)6g:YZll#*F%:T%"X & d'UAVHtp "    Dr8      ,     Z x "   "/( "+0X ,./zٞsxMEL@> LLLL8`t`fp`l`h`d`\`T`P`XL`8H`N D`@`h< $ `"`` H` %Xk@@i `Hx`t`p`l`d`\`X`T`P`@H`D`@`<`4ndar`X2 ` d is `'lk44Bi $dii = 3i  Ri( .Fi H i$h ok Ai(ask `H x` p`l0`d```\hxH'Px %x@Xp8 X @ P H 8Xb@p \ @ L @ < |>@ , @  ?@ @ @ @0 @>@` @ ?( R@x @ @ @>@| @l ?@ h  zC@d (  ?@` @h \ ?@ X @ T @P @L =?Hx0H@006l@L @< zC@8 @( @H :@ @X hH V"$zC@ @p @ :@x @ `@0 @X`|> :(P@H @` zC@` @ @ :@ @ @ zC@ @ `H1?@ p0:?@`X:zC@ A@ A@` ?D@`zC8D&(xI =?@t @d ?`M@``zCM hb0@P R@@L`?0R@h< zCXW@8`@W:@( h\@$`\@  c@ =c:g:@ p@` @ 8X`x0@HP@Hl @ \ @X @H @D `@P4 @x0`h``@8 @ @ P!0000@`x!@ &@`&@X 0+@`p+V@ X0@`0@ :@`:8X8(H.V@l @`\ @X @H @8 P@4`8@x$ @ @  @ ` @H 8@p`` @ H@`p@ @`@8 (@``P@ x8#@``#@ *@`*@@x 0/@ht`X/@d @4@``h4@P M9MM@L`M9MM@0< >M@X8`H>@( p0C@$`XC@ M@`MMM@  MRMM@H`8R@p ` W :@`HWM@ p\@` \@ aM@`EaEH   VM@x @h @ X 8 @ T` @` D @x 4 @ $ @ @! @8!`M(! M@`! P!!@!`x!8!@! !`!M@!`!!@ !!@`M!MMx $P8PP#h##"%$8$"`$"`x""($6fHP@ # @8# @# @$ @# @x$ @# @# @ @# @$ "@t P$$$@p`8$$#8h@l @$\ @$L @< @, @ @ 0% &p%h&P&&'8&@% MMMM@ @( @& @ 688"MM@& @& @ @& @& MMMM@& MMMM@ MMMM@ @('x @@'p @X'h @p'` @X ( h  (p(@(*)(*(hH@X(L @)< @(, @@* @( 7777((MMMM@) )(MM@8) @ ) @P) @) @h) @) @) @ @ @X* *)@*`0*)((VfP2.aap*(@ ?@t *X*!?@p`:**!:@l `.a*%h)HP `7  " &   &82E` 16   :7(63h$A6_ (0 8@ *HX` h p 6/ ,@  ^|    6_ #8_(08@HPX `h *p    Bg&(  *@  P  X  `  h  x X_ < < 6  ( 0  8 6@ X ` h  p 6x     6        b )       8_ H P 8_p    8_   8_  @ 8_P   8_      1    0&P x24  ";("30X  `7  "  ) " ++ (08 !@ *P`hpx <<6    6  8 @ H P6X p x  6    <   ( *  0 8 @H P " X )` p * <<6 608@ H6Phpx 6 6 6  (<0<H6`x 6 6 6 (0 86@X`h p6x   )<<6    ( 068 P X ` h6p    6    6      " (  *0@H P X<`<x6    6    6    ( 068 P X ` hpx B &&   0 @ H P`  p  #  8(!@+X+h(Sx<<<<6    ( 0<8<Ph   x   ,[  ,[ *[  *[P .c *Z *Z *[ @ X h &x<)0h+ $<@.e` - ( <  ( 8@P`h2Dp &<)+ + ( <@  ` p    ! ! !         ! !  ! (! " 0!8! X!x!! !"!(!"  "0Y8"<qh"2a".X"0Y#@#0Y`###8f#0Y#0Y $ P$p$.Vx$ *$.V$ *$ % 8% H% X% 07x%%<r%<r%2b0&.Yh&0Z&&0Z&8g'0ZP'0Z' ''.W' *(.W(( *X(x((((( ((( ( " ()) .0)`)x)) )  )6) J)@*  X*x*%***2* "*(+ *0+ @+ H+ P+ X+  `+(0x+ +)+ 2+ *+++  , ,,, ,(,0,8,@, H,P,X, `, p,) (C) OfficeHelp 2006 - www.officehelp.biz Version Code! YEARLY PLAN SPECIFIC CODE MODULE8 Developed specifically due to completly different logic]@Xp $' $' Demo Restrictions 8     D  $ and  $. X b A@R''khk`% Make calendars for each year on listbett     'j A@kT If Sheet mode was selected, the legend has to be added and some calculations remadeE Sheet? Insert Special Day ListDays  $'.a Set Print Area Sheet   !A@~?d  !A@?k Move cursor to top$B@Hk`oX]0H`x] Select Output Sheet ' GOutput'j CreateOutputSheet NewSheetName  WorkbookG !.j B@ %FB@H  %F( Set Gridlines 6GA@lj Set Generic Headings  WorkbookGARQ@A@j  WorkbookGB XA@jTaskB  $H(JB  :B  $HB@H  9 999999q !j 9l V9Tq "A@$ A@  WorkbookGC:AGA@j Insert Title B2:AG2Arial A@ Make GridB  :AG  B  :AG  A@ A@ Insert YearC  :C  $HB@H  P(RC  :AG  $HB@H  9 999999q !j 9l V9Tqh "A@$ Insert Month Names  B   :B   $HB@H $ P(R !j &9l V9Tq (A@$B  :B  $HB@HB Make gross border on months   %(   %(  % 9 9 9lq  % 9 9 9lq  % 9 9 9lqP  % 9 9 9lq Insert Day Numbers C$h  $b  :C$h  $b  $HB@H  P(R "A@$H Paint Inexistent days  February has 29 daysAF  :AG  $HB@HdFebruary has 28 daysAE  :AG  $HB@HkP 0A@AG  :AG  $HB@H 0A@AG  :AG  $HB@H 0A@AG  :AG  $HB@H 0A@AG  :AG  $HB@H 0A@ A@ Freeze TaksC:C$B@H p( Increment PlanCount WorkbookG  'j Insert Special Day List SheetGDays  $'j Set Print Area Sheet   !A@d  !A@k Move cursor to top$B@Ho` $HB@H  P(R !$(& !$(,  9 999999 99q B@G  !$' 9 909498969.92 9: 9lqP    %(@   %(   %X' 9 9 9lq  % ( 9 9 9lq  %vY< 9 9 9lqp  %' 9 9 9lq8   %(k '! Set BG Color if there is a color !j 9l V9Tq k o  $HB@H Set BG Color  !jB@H .9l V9TqP   %(um   %($  % 9 9 9lq   %A@ 9 9 9lq   % 9 9 9lqx   %@ 9 9 9lq@   %% 9 9 9lq   %  9 9 9lq   %($   %(  %9 9 9 9lqh   %A@ 9 9 9lq0   % $ 9 9 9lq   %9 9 9 9lq   % 9 9 9lq   %p 9 9 9lqP D $HB@H   %(   %(  % Main 9 9 9lq   % $ 9 9 9lq   % 9 9 9lqX   %@ 9 9 9lq   %%F 9 9 9lqkox !jX  9l V9Tq    %('   %(  %H! 9 9 9lq8  %X' 9 9 9lq  %put 9 9 9lq  % ' 9 9 9lqko]xput ] 8P]h!] 8]P >''f#'X ' 6',' into Input'ce Set Column LettersB@HC+L+U+E+N+W+' $fNONE! Insert Label!B >$HB@HLegend P(Rert da !$(&al !$(,B >:AG >$HB@H   %(   %($   %(l   %(  % 9 9 9lq   %($   %(  ' List Days / CategoriesvJ  B X   %F%H!JX 'ion. G'jE X   %F%H!JX '9lE X   %F%H!J'GF X   %F%H!J' CC X   %F%H!j!l'G X   %F%H!J'mberFoK X   %F%H!J' !B X   %F%H!J' y   X 8X  Days Insert label (day or category) $ $HB@H '  P(R1 I G !$(&cG !$(&j  !$(l Insert day (day or category)G $ $HB@H!' $/ $h P(R  change font size to 8 d !$(0  (F Insert ColorXD $ $HB@HF A@  ' F'  '  ''kd, ,, ,I  Insert label (day or category) $ $HB@HF'  P(R !$(&  !$(l Insert Color $ $HB@H A@  ,'  ' '  '  'k(k kkk  'k  'ih]](@Xp]]0 Set Main Dates1/1/ X'1/1/  X'd $' Get Task DataG 6Input %F%H!JX 'HB 6Input %F%H!JX 'C 6Input %F%H!j!l'D 6Input %F%H!J'E 6Input %F%H!JX' X X G 'jF 6Input %F%H!JX' ' X X G 'j0I 6Input %F%H!JX'J 6Input %F%H!JX 'K 6Input %F%H!JX ' Check for empty tasks'E 6Input %F%H!J'  G'jF 6Input %F%H!J'  G'j 6 'F'  X 8X   Insert main cells data  X X X X   XA@kPG Input %F%H!JX 'HB Input %F%H!JX 'C Input %F%H!j!l'D Input %F%H!J'E Input %F%H!JX' X X G 'jF Input %F%H!JX'0I Input %F%H!JX'J Input %F%H!JX 'K Input %F%H!JX ' Check for empty tasks'E Input %F%H!J'  G'jF Input %F%H!J'  G'j ' X X G 'j  '  ' 8  "G'jkoH]   ]   ( Check if task is within calendar limits   G|j   G|j   G|j G|j Calculate Loopd  $'D if task is one or more years, then dates are wrong or empty - leave mG|j Loop each task day  d  $' $h '  $ ' Paint BG Color on the cell  $  $$HB@H !j 9l V9Tq Deadline marker  Gd $'j   $f $f P(R !j 29l V9Tq  9 999999qkko:Attribute VB_Name = "Module6" ' (C) OfficeHelp 2006 - wPww.oTh*. biz ZVersion Code"YEARLY PLAN SPECIFIC CODE MODULE%Developed specinally due to completifferent@ logic5 ) MsgBox MSG__DEMO &] " and ".A.", vbOKOn\+Informa/,MAIN_T|IToL43AJ@5GE!\IfC'v calendars @! each y{ list L>=zKHForDo B ?E0A NexD)@Sheet m was selected, the ldeg0 hb`e addAasFo݀8culXs remaρ$ÝplitByLayerB"L' Insert Sal Day LHĹ=D  ("s?1 + Count] ' SPri@pArea'?(\A  t2,A3`, 33 Els@e 185N Move curFs@E4topCells(1, 1).SB;cAɒ((yi)Max-Hew:{S, AuL@FinA taxStartll@ LoopB.堡>Y Out NK $@C"CW G a;' C Lteb  BU c0 Or[`SLfWorkbookwDF B sp.Add `.Av BA7e9=#iGr8idlAϣ %UseFa]|!o}!eA eneric Headingg͟$"OColumnWidth "AA2.29 _/RrZBPCDbl(Task2 Rangeh("B1k4p=v).Val``#-(n:r(5Wi> {.HorizontalAlignmeP= xl2Certi]ojWrapTextOri7@Ra0@*InFd_.ShYkToFi? .M0ergeLTr>uTK!3.Int0%o 4orx1'erBGB PatnxlSoli6CopyFs,eryBordpxlMedium, X0(@s?. 7.C:AG) gsVuTitl=, "TB220Arial16Black  =.+" p,(17,})/0 +/Pa|.tT Y@6C\t)6BVr).mᰐR1C1"s_OF>_=pTl_=_=_=._=? ._=V0_=g_=_=Y_=_=_=d <_=l/@_=r_=_= 6%M?h 1`kq= 0 Tpo 11 :^60ll'^'/($( r (WRR . UnR`. +R5Rˊp& ":B" & (17 + PlanCount)).Select ' Make gross border on months Rion.B>s(xlDiagonalDown).LineStyle = @xlNonerUp7With vEdgeLeft.)_ |CinuouWeightNMediumColor IndexAutomaticpEnd FKTopKBot@4&RS?LA&Re?&2&s' Insert Day Number@For ll@0 To 30 @Range(ALetter(As@c("C")l4l)5J@": ActiveCell.@&mulaR1C1#'(+ 1 CopyF HeaNext#' Paint existe@dayIf yYear Mod 4 hen# 'February has 29 gg$"AFB+!AG0Els뤈8EyA}Ifcb#BAreaWeekend 9or, FaFB"9@2 y11L?%14K6KcACTasksYRb' Freeze TakgDumns: D#yWindow.Panes1lTru$^% Incremas&CtInputSplitByLay<> "Workbook" Tvg]&18 G"PSpecia:lPLASheetTN '0Uq("s", 1k1Setx PrH16v= "hA 2,!3"# p, 33cE 18 iB ove cursPcto top1[s(1( qSub`T itle(R As Stg,!3E9BGG!Lo2n@TF^XTSi(MKcBoolean@x sLO3?h4hb SSjntP ld-Ital= 0 ThenA' Set !if there is a c^RNInt`erior(.$x< PatnSolidf Sub  Mak@eGrid(Range As String, Hea )Q ).A=.=6CC#KDiagonalDown~YUp 7EdgeLeft@NMcThiIxlLAZ%Top?%4?%sA%Bot{%T%RA@{8h(֙#_ _&_&@ KCHoriz¿ %' m -_n(7-z@oS x'O7oh @/?0 !P ̍6_Vif @OO <> ""윣Xۍ!AxlB?<ĭ!3Fb?!3o?< [G2ok ?>. u!k+ >p /,&, I! p K 4   AqUU!q Pai4ntV?(dLoMKsBoolean /k //ϲ9A SSMK/K/KO!1/K#KD With Selection.Borders(xlEdgeL@eft)  .LineStyle = xlContinuousF .WeightBThin 6 .Color Index!Automatic&pEnd T|op "ElTBotuUURp * AIf Sub FunB InsertSpecialDayList(WTL As String,artRow Long) xDimA , out, CriteriaACNTD, DDate.IELabelDCaLevC$Caux Out.BeenDoneG B'(3>!  InputSheetNam Test$wa4L=0cz,= -1= "#"d,= 0CTask9#@,D, "%'@t umn Let "NONE" Thed!0'Dd "Range("B" &F3).AlveCell.Formul aR1C1"Lepgend 'FldTrue lItalicQ":AG DiagoBn`own)NeUpauOqa{m{ ݅3fo/#@_ideBV_icalnH+ 2 P ' qd ds / YegorieBWhi@_KQ80XMCPW(psBook.Ts(kJ).y/?)).Valuex0@Null?OkPOZ= ? t? 4 E&? 3o=i&d_7aBEABhOwiFF1BL\OK?cRCNInor0,W//#M } $]K$} OOc K)1 A (c'k#$SLng(D_r n*" NBs).k51 0! ( Kr < bl("0 okIo i @..J/-D/3e("K/)' Check fPeFtB! SG= FaabG++&;;OrR%Nu^B/D$D/&kd0$w ,= YJR:Bj= While K<<>K,Lng( 7`!"QNLevels7Wgvm!_cs \W1Draw`x7t=3A@4)sh2NM }DeL@C=! + 1CNT@VItsADemoP @ >= Max ,sZIndex"" End IfWendGA Sub  DrdawBYRoAs @lean, @, ?aKC#ColW@Long,HDeadlixStrik4Dim DLoop Ccnt'NDays ACalGRowe, "$nif"m is with@in cal*ar limitDp74!<$&Exxit ,0%>D)g w6#alcul (%= Abs(!)Diff("d^"3C")į' ":more years, FtAes awr= `#- Jvr"c@\365#[k&B?each#2day#F B= 0 To  OcA9<@= A|dd"i !B= 2 x@(#D aH= PlanCPount 5`Month' PaiBG on$ cell#C`sA S)).SelectgWT ion.Interior.eKPatnxlSoli!DNex ' f=marke<> K>R+|12PW:=On1pUC|as1m1E @> 0lA1Active.@%m2R1C1Joo % MbBGoC"@; 1.Horiz+alAl ignme*= xxlCE5.`VertiOB ottom.WrapT!,Oriat*P0O.;* _àckToFVMergs ?A_ts XWHJCLX5HX $ QXDl%D$l%D%fl%D&(l%D'fl%D((l%DMfl%D)lv%DNfl%D*cD!X $ XOX*X $ XWHJ44q0XFl%l0Cil%l0CPfl%l0CQfl%l0CRfl%l0CSfl%l0CTfl%l0CUl%l0CV il%l0C- q0$< %l%X $ XH>C?X5H< %l%X $ XH>C?X5H6l%X $ XH>qXl%lC?l%lC@l%lC- q6l%X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q< %l %X $ XH>C?X5H,*X $ XWH+qXil%lC-l%lC. q6 4@P(D4XH| )X'\% Fl%$ XX*X $ XWH+88q4XvWil%l4C-l%l4C. q4<$%l%X $ XH>C?X5H<$%l%X $ XH>C?X5H6l%X $ XH>qXl%lC?l%lC@l%lC- q6l%X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>wrU~|  x^pA$^B R^I 9 B??)RLY___xi99RQ]IpS_`A```)YaIaaaII\aaba 9b ! Ybqb(S9SiS])iTbbbq bJZI[cIcc[[q\A\q[[\ccCccS d!dKAdid99 T!TddddALQeyeee)<ee IfLM\@L L"qt5LM\@L L"qp5LltlprM\@L M@ 'l'M@@:<L,: : 6L, l qt qp lpltltxlpdd x  xfd v  0"v Y\ C``^ ql/` v  0/!YPv llYTYXY\ +!YPllYTYXY\ 7(\%(%L$ XL,L5,@0$P 4 `LL, l xvCt lt0Ctv v 0d.8 '<%L$ L (Q8L "X 018(<%L"X L d8)L86ltF(%8(<%L"X L d8)L8 u + v v 0+ RQ@+C /v v 0^y ;+!C /A:("%L'<%!v #*F%$ L,/L5_L'<%!v #*##*#v #*F%$ L2L5L $ QL<%$<%%f<%&(<%'f<%(f<%) c<%*c*L $ LW+qLv,i<%lC-<%lC. q / 0+ 15v v 02+2C /@+YY3CY4Ct 52|!v #*#6*#v #*Ǹ!v #*#6*#v #*Ǽ 72+, 8_L'<%9v #*#:*#v #*F%$ L2L5# i<%L$ (L,L_L'<%9v #*#6*#v #*F%$ L2L5L $ QL<%$<%%f<%&(<%'f<%(f<%) c<%*c*L $ LW+qLv,i<%lC-<%lC. q / 0X dgL'<%!v lX#*##*#v lX#*F%$ L2L5&lX;F<%L$ (L,L*L $ LW+qLv<i<%lC-<%lC. q = 0 Xf_L'<%!v #*##*#v #*F%$ L2L5<%<%L $ L>C?L5<%<%L $ L>C?L56<%L $ L>ddq`L<%l`C?<%l`C@<%l`C- q`6<%L $ L>PPqLL<%lLC?<%lLC@<%lLC- qL6< %L $ L><((q$L<%l$C?<%l$C@<%l$C- q$Xdp L'<%9 AlXY B#v #*#C*#9 AlXY B#*#v #*F%$ L2L5)lXi<%L$ (L,L / 0 Xf   _L'<%Dv #*#6*#v #*F%$ L2L5G _L'<%Ev #*#6*#v #*F%$ L2L5+F 8_L'<%G v #*#6*# v #*F%$ L2L5+F 8_L'<%G v #*#6*# v #*F%$ L2L5+F 8_L'<%Gv #*#6*#v #*F%$ L2L5+F 8_L'<%Gv #*#6*#v #*F%$ L2L5+F 8 l H1:qXl%lC?l%lC@l%lC- q<$%l%X $ XH>C?X5H<$%l%X $ XH>C?X5H6l%X $ XH>qXl%lC?l%lC@l%lC- q6l%X $ XH>xxqtXl%ltC?l%ltC@l%ltC- qt6l %X $ XH>ddq`Xl%l`C?l%l`C@l%l`C- q`6l %X $ XH>PPqLXl%lLC?l%lLC@l%lLC- qL6l %X $ XH><((q$Xl%l$C?l%l$C@l%l$C- q$ = )X'\%Fl%$ XX<$%l%X $ XH>C?X5H<$%l%X $ XH>C?X5H6l%X $ XH>qXl%lC?l%lC@l%lC- q6l%X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q6l %X $ XH>qXl%lC?l%lC@l%lC- q  lPT8xdP<(XH*x $ xWh+XXqTx iD%lTC-D%lTC. qT<$%D%x $ xh>C?x5h<$%D%x $ xh>C?x5h6D%x $ xh>qxD%lC?D%lC@D%lC- q6D%x $ xh>qxD%lC?D%lC@D%lC- q6D %x $ xh>qxD%lC?D%lC@D%lC- q6D %x $ xh>qxD%lC?D%lC@D%lC- q 8P Xxh 8 q@ qpXCl qh $qtYC<ZC9$;[$;\$;];^;_; q#l M@ `:a]@5$ 8'%!#*F%$ /5!:b%$ (,+c% $ WJCK5+c% $ WJCL5S'%!#*#6*##*F%$ 25<%% $ >C?5<%% $ >C?5<%% $ >C?5<%% $ >C?56 % $ >ttqp%lpC?%lpC@%lpC- qp<% % $ >C?5<% % $ >C?5l@q@ ll=$ [!lt#*F%llF%"cX  dldA\eK1l/)l6\llF]d31Cl[]lt#*F%llF%"cX  dldA\eK1/)l6\[]lt#*F%llF%"cX  dldA\eOt\/)l6\[flt#*F%llF%"cX  dldA\eOtT/)l6\c9lt#*F%llF%"cX  dld=\+AL-"qd/)l6\LZglt#*F%llF%"cX  dldA\e`1P/)l6\Zhlt#*F%llF%"cX  dldA\e`1L/)l6\[!lt#*F%llF%"cX  dldA\e"qH/)l6\ll=l= lHvi  0c <'%ll@#*F%$ /5)jlP*F%$ (,5lH+c% $ WJCK5,f% $ WJCK5+< $ WJC-5<'%l$l@#*F%$ /5e:j\M@ k:l\\M@L mL,%$ (,6 \L,-(% $ WJCP5(% $ $<'%l$l@#*F%$ /5+d 8lql^ qlhqhl@q@ DYl<*#Y*#YlL*#Y*#2 <'%ll@#*F%$ /5)jlL*F%$ (,5+c% $ WJCK5+< $ WJC-5<'%l$l@#*F%$ /5+d 8lQstqokeP h%^*\G{00020430-C 0046}#2.0#0#C:\Windows\SysWOW64\22.tlb#OLE Automation0EOfficEOficwh E2DF8D04C-5BYSLIMIT_1(C_EXCEL_DAYSLIMIT_2(C_EXCEL_DAYSLIMIT_3(C_EXCEL_DAYSLIMIT_4(C_EXCEL_WEEKSLIMIT_1(C_EXCEL_WEEKSLIMIT_2(C_EXCEL_WEEKSLIMIT_3(C_EXCEL_WEEKSLIMIT_4(C_OUTLOOK_WARNING_TITLE(C_OUTLOOK_WARNING_MSGPP(C_OUTLOOK_TITLE~ (C_OUTLOOK_FINISHED&D (C_OUTLOOK_ROWZ8(C_CLEANING_WARNING_TITLEr(C_CLEANING_WARNING_MSG(C_CLEANING_WARNING_TITLE22A(C_CLEANING_WARNING_MSG2(C_CLEANING_WARNING_MSG3(C_EXCEL_MONTHSLIMIT_13 (C_EXCEL_MONTHSLIMIT_24 (C_EXCEL_MONTHSLIMIT_35 (C_EXCEL_MONTHSLIMIT_46  (MSG_YEAR_DEMO^(MSG_MONTH_DEMO;`(MSG_WEEKLY_DEMO(MSG_DAILY_DEMOp(MSG_RESET_WARNING_TITLEk(MSG_RESET_WARNING_MSG(MSG_RESET_WARNING_TITLE2u(MSG_RESET_WARNING_MSG2Ţ(MSG_RESET_WARNING_MSG3Ƣ(MSG_SET_WARNING_TITLE(MSG_SET_WARNING_MSG (MSG_NOSET_WARNING_TITLE%(MSG_NOSET_WARNING_MSG(MSG_MAIN_TITLEz (MSG_MAIN_END!(MSG_ERR_SELCAL^# (MSG_MACRO_ESC(MSG_DATES_MAINY(MSG_DATES_TITLEq,(MSG_DATES_TITLE_TASKSa(MSG_DATES_TASKS_1(MSG_DATES_TASKS_2(MSG_DATES_TASKS_3(MSG_EXCEL_LIMIT_TITLEu(MSG_EXCEL_DAYSLIMIT_1ƕ(MSG_EXCEL_DAYSLIMIT_2Ǖ(MSG_EXCEL_DAYSLIMIT_3ȕ(MSG_EXCEL_DAYSLIMIT_4ɕ(MSG_EXCEL_WEEKSLIMIT_15(MSG_EXCEL_WEEKSLIMIT_26(MSG_EXCEL_WEEKSLIMIT_37(MSG_EXCEL_WEEKSLIMIT_48(MSG_OUTLOOK_WARNING_TITLE(MSG_OUTLOOK_WARNING_MSG)(MSG_OUTLOOK_TITLE(MSG_OUTLOOK_FINISHED(MSG_OUTLOOK_ROW(MSG_CLEANING_WARNING_TITLED9(MSG_CLEANING_WARNING_MSGQ(MSG_CLEANING_WARNING_TITLE2 &(MSG_CLEANING_WARNING_MSG2շ(MSG_CLEANING_WARNING_MSG3ַ(MSG_EXCEL_MONTHSLIMIT_1(MSG_EXCEL_MONTHSLIMIT_2(MSG_EXCEL_MONTHSLIMIT_3(MSG_EXCEL_MONTHSLIMIT_4(NewBook,Workbookk(ThisBook-3 (MainWorkbook (InputPlanName (InputSTDate (InputEDDateI(InputMakeDaily'6(InputMakeYearlyW(InputMakeMonthly(InputMakeWeekly_(InputSplitByMonthsS(InputSplitByLayeri (PlanCount͎(NWeek/ (GlobalMaxDaysu](ExtraDay(NRTasksp(RealInputSTDate(RealInputEDDateǠ(InputMonthNamesv (OutlookColor (OutlookLevel^(OutlookDeadline@ (OutlookSource΃(OutlookTasksComplete0(OutlookTasksNoDateJ(InputWeekdayNamesU(InputOptionalFields (InputOptionalFieldNamesa4(InputOptionalFieldLenqv(StartPlanColumn(StartPlanColumnNum(TaskNameColumnWidthj (HeaderBGColor (a ,*\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 Generator'KX  ٞ Module10R58e64b41Module1xrThisWorkbook0S58e64b41uThisWorkbook Sheet10T58e64b41w Sheet1)0 Sheet40U58e64b41y Sheet4L|H Sheet50V58e64b41{ Sheet5`Module20W58e64b41|Module2xx^Module30X58e64b41 Module3>hModule40Y58e64b41*Module4OX/ Sheet60Z58e64b41 Sheet6Module50[58e64b41Module5nhModule60]58e64b41Module6sz Sheet20^58e64b41 Sheet24 Sheet70_58e64b41 Sheet7 @`Hx y&̳E.Ok-aˎbWKʈQ#CѺlMMBeaz"O,~0 J*VaZG#_0ّR[L uVTV0 AHA@~;|}UL@7a+eDGN@§ǝGe)MR(sC32"}gYK;0a y bQF Excel+ VBAWin16~Win32Win64xMacVBA6#VBA7# CalendarPlanstdole`Officeu Module1b _Evaluate (MaxDemoTasksҙ (MaxDemoDays (MaxDemoWeeks (MaxDemoMonths (MaxCalDayst (MaxCalWeeks\(WK_(DL\(MTHw(YRp_ (StartTaskRow(ItsADemo" (CanChangeMSG (C_MAIN_TITLEׇ (C_MAIN_END}vbCrLf (C_ERR_SELCAL (C_MACRO_ESCF (C_DATES_MAIN5x (C_DATES_TITLE>l(C_DATES_TITLE_TASKS*E(C_DATES_TASKS_1(C_DATES_TASKS_2(C_DATES_TASKS_3 (C_EXCEL_LIMIT_TITLE9|(C_EXCEL_DAHeaderFontԈFontU(TaskNameBGColor> (TaskNameFont$:(OptionalFieldsBGColor0(OptionalFieldsFont3(PlanAreaBGColor=(PlanAreaWeekendColor(DeadlineMarkerBGColor(AllowOutlookSecureFieldsȋ (UseGridlinesU (InputNLevels$(ConfigUseDatesDeadline8 (MSGCounter (AllOptionFlag2(SetMSGVariablesIsNullActiveWorkbookSheets Range ValueK(SetMSG$auxuAuxStr?MsgBoxR vbExclamation vbCritical+}vbOKOnly vbOKCancelx?vbCancel' (RestoreMSG%Split) vbInformationn(GetInputValues;UCase5 DayInterior; ColorIndex(Main, handleCancel\ Application*EnableCancelKeyxlErrorHandlermsgQ(CheckTaskDatesM ( MakeYearlPlanv( MainMTH\(MainWK(MainDL'ErroNumber-(SetColumnWidthcl\wmColumnsp9 SelectionZ ColumnWidth(CreateOutputSheet( NewName# LastSheet!c SheetName6Count0vAddrMove>yAfterX (MakeBorderI-i`BordersC"xlDiagonalDownJ@ LineStylewxlNone xlDiagonalUp xlEdgeLeftL xlContinuous[Weight1 xlAutomatic@ xlEdgeToph xlEdgeBottom xlEdgeRight%vxlInsideVerticaljMxlThinwxlInsideHorizontal (CountTasks[(CountRealTasks TaskIndexqll^ll2CNT+sd_ed]flag (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(CopyFontkBoldColor2F FontStyleItalic! OutlineFontOSizeShadow Strikethrough" SubscriptV Superscript Underline(SaveTaskDetails#LlineLevelDeadLine(STDateEDDateκTaskName_PercDoneResourceCatJ} ActiveCell FormulaR1C1SPatternixlSolid7n (GetDateOnlyDT\Pg (CleanTaskLine (ResetTaskList (ColLetter#ColNumXEoutZAsc!uChrK~ (SetGrideLines]Ast(_ ActiveWindow+DisplayGridlines ThisWorkbook| Sheet1 Sheet4 Sheet5 Module2cMaxDays NewSheetNameMaxLines/AuxDays MaxFinDate MaxStartDateUInitDate} FinishDate4MaxNDaysK4 DisplayAlertsDateDiffDateAdd/6 DateSerialUYear6nMonthvbYesNovbYesa?(ProceedDatesDL(MakeCalendarDLpCurrDateH NextStartDatedNextFinishDate{Flag2nAuxLoop0 WorkbooksBActivate|HorizontalAlignmentS@xlCenterVerticalAlignmentʡWrapText} AddIndent2W ShrinkToFitA MergeCellsکxlMedium (InsertDaysDL# (InsertTasksDL8a FreezePanesMzmlB^sdate\edateNDays auxDate_ CellColorncolsweekwflagW%mnameonameMwnamecolscolHWkRows\TWeekdayxlBottom?maxcol5CNTTotald TaskSDate\^ TaskEDatec TaskColorq TaskDeadline! TaskPercDone^ TaskResource  TaskCategoryTaskCnt/ RealTaskEDatee InsertIndent- NumberFormatR (DrawTaskBarDLOlinenumֶstColendColwcntDatePR Module3d MaxNWeeksaa(Day2Week(ProceedDatesWK(MakeCalendarWK  (InsertDaysWK (InsertTasksWKc WeekCounter (DrawTaskBarWKQWeekFlag'WeekLen=NDayCols\s SearchDate/ CalStartDater^ CalEndDate|k Module4e (OutLookTestMhandleCancelOutlookAuxRow1(DetectFirstEmptyRow vInputBox (ImportOutlookCalendar(ImportOutlookTasks StartDateEEndDateXStartRowOUTLOOK,VoFolder>oItemszoItemsOutlAPPx oItemsRestrict^olFolderCalendar) olFolderTasks olFolderToUse CONDIT strResourceAr CreateObject GetNamespaceCGetDefaultFolder*Items`hRestrict)(Sort Organizer DateValue/StartSubjectRP strSubjectO dStartDate]dEndDateϦstrCalw TaskCompletea AuxStartDate' AuxEndDate? DisableTaskPOwner% (GetStatusNameSTATUS+PercentCompleteϘComplete DueDate Sheet6 Module5f MaxNMonths ( Day2Month+( ProceedDatesMTH~-( MakeCalendarMTHP ( InsertDaysMTH( InsertTasksMTHr MonthCounter( DrawTaskBarMTH0GMonthLeny Module6gnYearsYeareYearNLines5( MakePlanw( InsertSpecialDayListrLyYear$NLine) ( MakeTitle̲vbBlack( MakeGridʥ( PaintSelectionOZ ( InsertTasksYRcTitle~SelRangeaBGColorTFontuTSizeTColor5MKBorder- IndentLevel ReadingOrder xlContextPMergeq_xlUnderlineStyleNoneNd HeaderRangecWTLIndexCriteria7DColorDDateIsDDateEoDLabelDCat CDLevel gOutIndexBeenDone`ColorColLabelColeColIndexInputSheetName[ TestCriteria? ColorLegend TaskEmptyTaskTest ( DrawTasksYR0DLoop/CalDayDCalRow)_CalCol Sheet2 Sheet7 Worksheet_Defaultj _B_var_UCasea _B_var_LeftQ _B_var_Chr\; _B_var_NLines_B_var_ColorLegendI _B_var_sdateIp _B_var_edateu_B_var_AuxDays _B_var_msgbr _B_var_Format # +   uwy"{ "}!$߷sv.@ P@ Ddir+Z__SRP_0".=__SRP_19PROJECTwmI7FA-101@B-BDE5EA*AC42EProgram Files (x86)\Common \Microsoft Shared\OFFICE16\MSO.0DLL#P 16.0 Object Libra,ry'} ٞ@Module1GmduY1 2 (HB1BrrXB,BT!B+BBsThisWorkb@ookG@TAtisWkbok!M 2 $$"B#$ASheetBS@#e@wtAG2B/I)4GL4@<%44L|U 5 5 5 5 b< 'K2/K2@/K2}Y-Kx+K 33u33>9h99/:X//VOfD6-:6-:61d5:@HHHp+nu+o 6/:qzo+st+WAWf+2m+Vq+4k+U& 7m97i97 7S99OrU~~~y a          Calendar Plan GeneratorclwNewNameiabcd 1.a8FLlineLevelColorDeadLineSTDateEDDateTaskNamePercDoneResos have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 weeks. For a starting date of  4WARNING - Outlook Security POUTLOOK Task / Appointment Import WizardCountRealTasksCheckTaskDates The Resource optional field is active. Importing the resource field from Outlook calendar appointments will fire a Warning message from Outlook stating that another application is trying to access Outlook addresses. It will only work IF you do ALLOW it to proceed. 2WARNING - Task List Reset. The existing Task List will be COMPLETELY ERASED if you proceed. Do you want to clean it? 6WARNING 2 - Task List Reset! |Are you sure you want to COMPLETELY ERASE the whole Task List? 4Task List has been erased.O 6 months. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 months. For a starting date of  tDEMO Version limited to 7 tasks and 27 days for each plan.GetInputValuesMainSetColumnWidth4 DEMO Version limited to 7 tasks and will only work from 2004 to 2005. Using 2004 to 2005 instead of  vDEMO Version limited to 7 tasks and 7 months for each plan. tDEMO Version limited to 7 tasks and 7 weeks for each plan.CreateOutputSheet MakeBorder ZWARNING - Original messages will be restored.= The existing Messages will be COMPLETELY ERASED if you proceed and the original ones restored. Do you want to proceed? ^WARNING 2 - Original messages will be restored. i//)0` RestoreMSG RThe original messages haveK*         rU~~~~~r~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~s 9EE4!1M}  a A<p8)8!,##$'( A88888!9A9a ia ia ia i)a NPPPQAQiQAa NOOPLAPiPPYa N9kYkkkkqa ia NNNO)OQOyOOa NqMMMMM!NYNNa ia ii71./+Module1 ThisWorkbookSheet1Sheet4Sheet5Module2Module3Module4Sheet6Module5Module6Sheet2Sheet7 CalendarPlan# WWW.OFFICEHELP.BIZ - Calendar Plan Generator 4.1 ADVANCED Edition :Calendar Generation Finished.  ) This macro is a member of www.OfficeHelp.Biz full family of Calendar Products.& Please select at least one calendar type: Daily, Weekly, Monthly or Year PMacro execution stopped by user request. TImport tasks starting on Excel row number?= 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 8WARNING - Invalid task dates 2The START DATE for task ' ' on line  SetPrintArea5 is greater than its END DATE. The task will have no calendar bar. Press OK to proceed, CANCEL to stop. DWARNING - Calendar needs Splitting 6The requested calendar has % Proceed automatically splitting calendars every last complete month?M ,days. Excel sheets have only 256 columns and up to 6 are used for headings. The maximum calendar length is therefore 250 days. For a starting date of  8 the maximum finish date is  . VOUTLOOK Task / Appointment import finished. CountTasksN 2 weeks. Excel sheet been restored.& WARNING - Original messages will be REPLACED by the ones inserted below. 7 37@0FC:\Windows\SysWOW64\stdole2.tlbstdole ...PL-[DREC:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\MSO.DLLOfficeT HThe existing Messages will be REPLACED by the ones below if you proceed. You may restore the original messages later using the RESET button. Do you want to proceed? ^WARNING - Only available on the CUSTOM Edition.?C:\Program Files (x86)\Microsoft Office\Root\Office16\EXCEL.EXEI The function you are trying to use is not available on this Edition. Please upgrade to the CUSTOM Edition using the Upgrade Link on this page.FHC:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLLVBA 6 6Y70FExcelSetMSGVariablesSetMSGCopyFontMFSaveTaskDetails GetDateOnly CleanTaskLine ResetTaskList ColLetter SetGrideLinesFF Range Value B4 B59 Calendar Generation Finished. This macro is a member of www.OfficeHelp.Biz full family of Calendar Products. ALL 0f 1  $(,048<@DHLPTX\`dhlptx|   P".o(ha be DKa`xFFy?? B2 MHS& . Proceed automatically splitting calendars every last complete month?VBE7.DLL yA0 y?( D61 Config D63 D64 yAS 8 yA X C5 Input C7 C9 F11 C11 No Split C13 F7 Daily Weekly Yearly Monthly All I35 C27 I34 Include J35 G27 J34 K35 K27 K34 C29 C12 C14 C15 C16 C17 C18 C19 C20 C21 C22 C23 F12 F13 F14 F15 F16 F17 F18InteriorColorIndex C25 G25 C47 Yes C49 C51 C33Font C35 C37 C39 C41 C43 C55 C57 yA x InsertDaysWK yA F  DL WK MTH YR MakeYearlPlanMakePlan MakeTitleMakeGridPaintSelectionInsertSpecialDayList InsertTasksYR DrawTasksYR MainMTHProceedDatesMTHMakeCalendarMTH InsertDaysMTHInsertTasksMTHDrawTaskBarMTH Day2MonthMainWKProceedDatesWKMakeCalendarWK InsertTasksWK DrawTaskBarWKDay2WeekMainDLProceedDatesDLMakeCalendarDL InsertDaysDL InsertTasksDL DrawTaskBarDLfĤIx8< yA  SelectColumnWidth Sheet AfterMoveNameBordersLineStyle WeightColumns Count B E F GAddress :PageSetupPrintAreaLeftHeaderCenterHeaderRightHeaderLeftFooterCenterFooterRightFooterLeftMarginRightMarginTopMarginBottomMarginHeaderMarginFooterMarginPrintHeadingsPrintGridlinesPrintComments $CenterHorizontally  CenterVerticallyOrientation DraftFirstPageNumber OrderBlackAndWhiteZoomFitToPagesWideFitToPagesTallBold ColorFontStyle ItalicOutlineFontSize ShadowStrikethroughSubscriptSuperscriptUnderlinePattern  yAi 8 Z A yA X yA` x and  Days yA)  Output WorkbookF Task :B &HorizontalAlignment "VerticalAlignmentWrapTextAddIndentShrinkToFitMergeCells C:AG B2:AG2 Arial :AG C :C AF AE AG C:CIndentLevelReadingOrder Merge # , L U N W NONE Legend K ' / yA!  1/1/ d D I J yA  yA  yA InsertIndent 0%NumberFormat '( ) Calendar yA( 8 'W=o@"AWYFKsHEŞDFWorkbook @FU^vS DjQ% F;˦urLٜDF Worksheet5Ƅ)Okig ii Ibm wu.Axfc9Q8AGQ OutLookTestDetectFirstEmptyRowImportOutlookCalendarImportOutlookTasks GetStatusNameEnd yAT 0 &Outlook.Application MAPIGetNamespace  GetDefaultFolder Items [Start] >= ' ddddd h:nn AMPM ' AND [End] <= 'Restrict [Start]Sort :Outlook Imported AppointmentsOrganizer StartSubject yA P yA p yA  ,Outlook Imported Tasks Owner STATUSPercentCompleteCompleteStartDate 01-01-4501DueDate (Not Defined) Task Not Started Task In Progress Task Complete Task Waiting Task Deferred\XtIٕsi "6EAnSKhttp://www.officehelp.biz/officehelp/default.asp?ent=demosite7-http://www.officehelp.biz/AP'Macro Configurations'!A1%tHelp!A1[Vhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00044&ent=Demosite4  Input!A1  Input!A1]Vhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=Macro&id=00002&ent=demosite4  Input!A1BLZhttp://www.officehelp.biz/officehelp/viewcontents.asp?cl=PC%20Tip&id=00004&ent=MacroHelp2  Input!A1 FMicrosoft Excel 2003 WorksheetBiff8Excel.Sheet.89q