Macro Excel is a powerfull way of processing data
In many case, when data fit in 1 excel sheet, a easy way of processing calculation is macro :
Set your macro in a module.
And then call your macro in the sheet.
Example is available here
Libre Office sheet is available here