What are the layouts of the Holiday Data?
There are three layouts. One is a giant Spreadsheet. The first column, from rows 2 to 11322, contains a sequential series of dates. The first row contains a series of column headings, the first being for the dates, and each subsequent one for each Center. For example, if you license 20 Centers, the Spreadsheet layout will have 21 columns. Each cell in the Spreadsheet layout contains one of three entries: a “g” to indicate a good business day; a “w” to indicate a weekend; or a number to indicate a holiday. A separate lookup table enables you to determine the name of the holiday. To view a sample of the Spreadsheet layout, click here. The second layout (called TriCol) consists of three columns, containing the date, the name of the Center and the status of that day in that Center. In this layout, there is one row for each non-business day (either a holiday or weekend) in each Center. The TriCol layout contains less raw data than the Spreadsheet layout because it does not list good busines