As part of Grone's human resource management they ned to produce a per employee time sheet each month. Their HR software cannot handle this, so that I was tasked with building a tool to automate this tedious work at the end of each month.
The solution is a simple Ruby & Tcl/TK based application that can be used cross-platform on Windows and Mac OS X workstations. The programm imports data directly from the HR software, processes it and outputs template based Excel sheets that can be printed and archived. In a second step a VBScript automation allows for easy printing of all Excel files for a given month without any further interaction by the Grone staff.