User manual LJZSOFT XLCALENDAR

[. . . ] XLCalendar User Manual Version 1. 7 2009-09 Copyright© 2006-2009 LJZsoft Corporation All rights reserved Contents CHAPTER 1 INTRODUCTION. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 CHAPTER 2 INSTALLATION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. 1 SOFTWARE REQUIREMENTS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. 2 INSTALLING XLCALENDAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 2. 3 UNINSTALLING XLCALENDAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 CHAPTER 3 QUICK START. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 CHAPTER 4 DIRECTORIES AND FILES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 CHAPTER 5 CALENDAR TEMPLATES AND PARAMETERS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. 1 ABOUT CALENDAR TEMPLATES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. 2 CREATING A WORKSHEET FOR MONTHLY CALENDAR . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 5. 3 CREATING A WORKSHEET FOR YEARLY CALENDAR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8 5. 4 ABOUT PARAMETERS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 5. 5 PARAMETERS FOR MONTHLY CALENDAR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 5. 6 PARAMETERS FOR YEARLY CALENDAR. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 CHAPTER 6 FILE FORMATS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 6. 1 PARAMETER FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 6. 1. 1 About Parameter Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 6. 1. 2 [Monthly Calendar] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 6. 1. 3 [Yearly Calendar] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 6. 2 HOLIDAY FILES. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 6. 3 XLCALENDAR. INI. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 6. 3. 1 About XLCalendar. ini . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 6. 3. 2 [Environment] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 6. 3. 3 [Monthly Calendar] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 -I- 6. 3. 4 [Yearly Calendar] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26 6. 3. 5 [MonthName] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 6. 3. 6 [WeekdayName] Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 CHAPTER 7 CUSTOMIZING CALENDARS. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 7. 1 MODIFYING CALENDAR PARAMETERS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 7. 2 MODIFYING CALENDAR TEMPLATES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 7. 3 ADDING YOUR OWN CALENDARS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 7. 4 ADDING YOUR HOLIDAY FILES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 7. 5 ADDING MONTH NAMES AND WEEKDAY NAMES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 CHAPTER 8 LICENSE AND SUPPORT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 8. 1 LICENSE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 8. 2 SUPPORT AND CONTACT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 - II - Chapter 1 Introduction XLCalendar is a calendar generator for Microsoft Excel that outputs calendars in Microsoft Excel spreadsheet format. Using XLCalendar, you can easily make various kinds of perpetual calendars, and custom calendars in your own language, holidays and styles. XLCalendar includes the following features: Outputting calendars in Microsoft Excel spreadsheet format Use Microsoft Excel to make calendars, and output calendars in Microsoft Excel spreadsheet format. Supporting various kinds of calendars Using XLCalendar, you can make various kinds of perpetual calendars. [. . . ] Or else, it gets holidays from the file you selected. - 14 - Chapter 6 File Formats 6. 1 Parameter Files 6. 1. 1 About Parameter Files The parameter file is an . INI file that contains some parameters for the calendar template file. The calendar parameter file is located in the same directory as the template file, and has a same base name as the template file. 6. 1. 2 [Monthly Calendar] Section The [Monthly Calendar] section contains the settings how to output monthly calendar. Output=Y/N This setting specifies whether to output the monthly calendar. If the value is N, the monthly calendar will not be used. SheetName=<sheetname> This setting specifies the name of the worksheet for the monthly calendar. <sheetname> value is the name of the worksheet. FirstDayOfWeek=<firstdayofweek> This setting specifies the first day of the week. "Tuesday" or "2" means the week starts at Tuesday. . . FirstCellOfDay=<firstcellofday> This setting specifies the position where the day of the month will be inserted. XLCalendar will compute the positions for each day. - 15 - ColIntervalOfDay=<colintervalofday> This setting specifies the number of columns between two days. RowIntervalOfDay=<rowintervalofday> This setting specifies the number of rows between two days or two weeks. OutWeekday=Y/N This setting specifies whether to output the name of weekday. If the value is N, the name of weekday will not be used. FirstCellOfWeekday=<firstcellofweekday> This setting specifies the position where the name of weekday will be inserted. XLCalendar will compute the positions for each weekday. WeekdayName=<weekdayname> This setting specifies the weekday name. For example, "Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday". OutWeekNumber=Y/N This setting specifies whether to output the week number. If the value is N, the week number will not be used. FirstCellOfWeekNumber=<firstcellofweeknumber> This setting specifies the position where the week number will be inserted. <firstcellofweeknumber> value is the first cell for the week numbers. XLCalendar will compute the positions for each week number. FirstWeekContainAtLeastDay=<firstweekcontainatleastday> This setting specifies the days that the first week of year contains at least. "1" means the first week - 16 - of year contains at least 1 day. For USA, the first day of week starts at Sunday, and the first week of year contains at least 1 day. For ISO standard, the first day of week starts at Monday, and the first week of year contains at least 4 days. OutMonth=Y/N This setting specifies whether to output the month. If the value is N, the month will not be used. FirstCellOfMonth=<firstcellofmonth> This setting specifies the position where the month will be inserted. XLCalendar will compute the positions for each month. MonthName=<monthname> This setting specifies the month name. For example, "Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep, Oct, Nov, Dec". OutYear=Y/N This setting specifies whether to output the year. If the value is N, the year will not be used. FirstCellOfYear=<firstcellofyear> This setting specifies the position where the year will be inserted. OutHoliday=Y/N This setting specifies whether to output the holidays. If the value is N, the holidays will not be used. FirstCellOfHoliday=<firstcellofholiday> This setting specifies the position where the name of holiday will be inserted. - 17 - MultiHolidays=<multiholidays> This setting specifies how to process holidays when there are multiple holidays on the same day. If the value is 2, the others on the same day will be put into the next columns. Holiday1=<date1>, <type1>, <name1> Holiday2=<date2>, <type2>, <name2> Holiday3=<date3>, <type3>, <name3> . . . . . . If <type1> value is "day" or "", <date1> is the month and the day. [. . . ] (2) Click the Yearly Calendar tab, change the parameters for yearly calendar. (3) Press OK button to confirm the changes, press Cancel button to discard the changes. In XLCalendar window, press Save button to save the parameters. 7. 2 Modifying calendar templates 1. In XLCalendar, select the calendar template file, and press Open button to open the calendar template file. [. . . ]