This is very similar to the way I used to build, format and release rota's and other excel sheets for our workers that worked from home.
It's very simple to create and convert to HTML once I have the information you wish to be published.
if you would like to speak to me in greater depth please feel free to email me at stufarnell at googlemail dot com