I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA.
You don't need a macro for calculating the sum of the last 24/48 entries, it can be done with advanced formulas composed from Excel built in functions. I have a free solution ready for you for summing up the last 24 entries, I can send you it immediately if you open a chat. I can complete the other formula (summing 48 entries) immediately if you award me the project.
I can create a macro importing new data for an extra $15 if you provide the structure and file format of the new data.
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution.
Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees.
Regards
Regards