Holidays
There's no column for holiday pay in the sheet. You could easily add one. Or, you could use what's there, as is and enter holiday hours as vacation. However, I think if an employee gets paid holiday pay, a separate column would be easier to track.
The sheet doesn't deal with compensation, but that would be easy enough to add by adding a row that included rate for each column and totaling them.
I don't think most companies would honor comp/overtime in a holiday week, but you know, they might. That's why the sheet is so simple -- every company has their own policies, but this sheet can be easily enhanced to provide more information.
Excel can do it all for you, if you use the right formulas!