All scripts have now been consolidated into Functions, a simple menu has been created, that has the ability to detect a weekend, and the ability to update the current day added.
The Holiday function is a work in progress. It generates a pop-up that asks how many days have been taken off. At the last test it did not work as planned, but feel free to tweak it.
As the server scripts have been set to run at 00/05/10/15 past the hour respectively, the consolidation script was set to run at 20. That way, any update of yesterdays info will be good as of 23:20 and any daily update will be accurate within one hour.
Update May 2017
The menu has been adapted to include SQL queries using the MySQL functions. Save the SQL functions to MySQL.ps1 for the menu to work. There is also a requirement to install the MySQL Connector on the PC that will run the queries. https://www.mysql.com/products/connector/
