Case Description A Setup file definitions B Date, L1, L2 stored in different columns C Date, L1, L12 , L2, L22 stored in different column (Note 4 Columns to be displayed as L1 and L2) D Date is a part of string and has a known FIXED start position E Date is a part of string and has a known FIXED start position and FIXED end position F Date is a part of string and has a known CHARACTER start position G Date is a part of string and has a known CHARACTER start position and known CHARACTER end end position. H How to use the Begin Date and End Date Database sheet. Case A - Data worksheet to Calendar DB  If you have a worksheet with data with the following criteria: Date is stored in Column A (MS Excel Date format) The cell A1 contains the label Date Name is stored in column B The cell B1 contains the label Name (or any other string) Role is stored in column C The cell C1 contains label Role (or any other string) The duration of cell A2 to the last cell in column A is less than 365 days. There are not more than 24 entries per single day Then this format is referred to as Calendar DB format. Please move to step 2. If you have a worksheet with data and would like to use Advanced Calendar for Excel program, use the following definitions to translate your data to Calendar DB format, please review the following definitions:  Parameters  Definition  [a] Date is Stored in Column The NAME of the column that the date is DATE is stored. Example: B Note: Make sure the date is stored in MS Excel format not TEXT. The best test is to change the format of the date and see if the content changes.    [b] The Date is defined by Select one of the OPTIONS below: [1] The column contains only the DATE [2] The DATE can be extracted from the FIRST Character Position up to the End of String [3] The DATE can be extracted from the FIRST Character Position up to       the LAST Character Position [4] The DATE can be extracted from the FIRST ASC Character to the End of String [5] The DATE can be extracted from the FIRST ASC Character up to       the LAST ASC Character  [c] First Character Position If the DATE is stored as a part of string in a same FIXED position In this example the DATE is always stored between position 7 and 16. *DATA 12/25/2003 10:25 Recoded 1234567890123456789012345678901234567890 0000000001111111111222222222233333333334 Then enter 7 for the First Character Position.  [d] Last Character Position If the DATE is stored as a part of string in a same FIXED position In this example the DATE is always stored between position 7 and 16. *DATA 12/25/2003 10:25 Recoded 1234567890123456789012345678901234567890 0000000001111111111222222222233333333334 Then enter 16 for the Last Character Position. Note: When counting the number of characters, make sure you use equal spaced font such as courier new.  [e] First Character in ASCII If the DATE is stored as a part of string with a charter preceding it (In this example the preceding character is a SPACE or  ASCII 32) *Monday 12/25/2003 Then enter 32 for the First Character in ASCII.  [f] Last Character in ASCII If the DATE is stored as a part of string with a character preceding it (In this example the preceding character is a SPACE or  ASCII 32) and a character following it (In this example  is a SPACE or ASCII 32). *Monday 12/25/2003 10:23 Record* Then enter 32 for the Last Character in ASCII.  [g] L1 (1st Line) is stored in Column The program add the L1 and L2 to the calendar. Specify the column name that the L1 is stored. Example: B  [h] L2 (2ND Line) is stored in Column The program add the L1 and L2 to the calendar. Specify the column name that the L1 is stored. Example: C    [i] Additional Information You copy up to 4 columns to your Calendar DB. (1) Enter the STRING that connects L1 and L12Column in the String Column. (2) Enter the second column name in the 2nd Column. For example, The L1 in the Calendar DB will contain B space <> space D and                            L2  in the Calendar DB will contain C space : space E 3.7 String Between L1 and L2 The string between L1 and L2. The default is "--".   How Open the Calendar DB Worksheet The Calendar DB worksheet path name, file name and worksheet name needs to be entered as shown below. There are three option to do it ( Option C is recommended): Option A: The following information is correctly entered and the file is already OPEN Path Name File Name Worksheet Name Option B: The following information is correctly entered and the file is NOT OPEN Path Name File Name Worksheet Name Please click on the "[2A] Open Calendar DB file" and use the dialog to open a Calendar DB formatted file. Option C: Open a Calendar DB file and record the correct information about: Path Name File Name Worksheet Name Please click on the "[2B] Browse and Open Calendar DB file" and use the dialog to open a Calendar DB formatted file.  Parameters  Definition  [a] File Path Name  The path name of the Calendar DB MS Excel file.  Note: Calendar DB file is a file with Date, L1 and L2 defined in            column A, B and C respectively.  [b] File Name  The file name of the Calendar DB MS Excel file.    [c] File Sheet Name  The sheet name of the Calendar DB MS Excel file.     How to Generate the Calendar from the Calendar DB  The following information are required to build a Calendar from the Calendar DB    Parameters  Definition  [a] Start Calendar from this date The calendar will start from this date.  Note: If left blank, then today's date is used.    [b] String Between L1 and L2 The string between L1 and L2.  The default is "--".  [c] Landscape or Portrait Automatically print calendar with following options: Blank             Do not print L                   Print Pre-View in Landscape mode (1 Month Per page) P                   Print Pre-View in Portrait mode (1 Month Per page)  [d] Use LINEFEED to separate L1 and L2 Enter 0 and the L1 and L2 will be connected by the entry in 3.7 or "--"  John -- Room 1234  Enter 1 and the L1 and L2 entered with a LINEFEED  John  Room 1234  [e] Width of the column  Blank means that the program will automatically set the Column Width  Any number will be used to set the column widths.  For Example 19 will set the column width for all columns.  [f] Show Dialog Box: Show Dialog Box: Y Yes to show dialog box  N No not to show the dialog box  [g] Number of Months Per Calendar Number of Months Per Calendar The default is 12. Any number from 1 to 12.  [h] Generate Web pages Y Yes to generate a set of HTML files, one per month of the calendar. The files are stored in a folder named below.  [i] Generate Web pages The PATH NAME of the generated HTML files Make sure it is correct path name such as  C:\My_Calendar Note: some operating systems do not allow space in the path name.  [j] Outline level: The calendar is generated using 4 outline levels 1- Just see the date 2- Just see the first 8 Cells 3- Just see the first 15 Cells 4- just see the first 24 Cells