Hi.
I can offer you instead of macro a standalone desktop application. It will work with XLSX-file and produce the results you need. I will develop this application using .Net Framework. It allows you later to improve the application. For example, it is possible to use some external data source, send the data by email, etc.
If you choose such approach, you will be able to process the data independently of installed version of OpenOffice and also the implemented application will work if Microsoft Office or any similar software is installed.