Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the layouts of the Holiday Data?

Data holiday layouts
0
Posted

What are the layouts of the Holiday Data?

0

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

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.

Experts123