Linux, Excel
I was the head of the IT group (called Core Tech) of my university residence of 120 people (Collegio San Paolo). There I created many projects, but one of them is special to me:
- An accounting system to share the cost of the common printer, using:
- CUPS for authentication and log
- Awk for filtering of the log
- Bash and Cron for the periodic upload of the log to Google Drive
- Google Sheets for the accounting
This automation allowed us to scale up the system and provide a very convenient way of printing to the 120 guests of the residence. With about 100'000 pages printed per year and a much cheaper price than any print shop, this project was a real success!