Altersheet
The project was born from the need to replace previously used spreadsheets (Microsoft Excel) to track employee attendance and the tasks in which their time was spent.
Benefits brought by Altersheet are better usability, greater control over tasks with different levels of user authorization and, above all, the ability to have real-time reports of hours worked on a particular day, month, or year by a single employee Or the entire workforce.
Architecture
The current live version of AlterSheet is made up of two main pieces:
- A NodeJS instance serving static content for the browser and processing all the necessary business logic
- A MySQL instance
Where possible, all the computational intensive tasks have been delegated to either the browser JavaScript VM, or to MySQL through specific SQL queries; this made our choice to solely use NodeJS viable, given its single thread/event driven architecture. Any blocking CPU intensive task in NodeJS would otherwise seriously impact the throughput of the application.
Online demo
You can find an online demo at http://altersheet-demo.altereos.com/
Simple user:
user: user / password: altereos
Admin user:
user: admin / password: altereos