Do you need totals per column per file, or totals per column for all files?
Ditto, are the per row percentages:
- The sum of this row is x% of the total of all values in this file? Or for all files?
- Or one percentage for each column of that value relative to the column total for this file? Or all files?
- Or one percentage for each of the five groups of 4 values relative to this file? Or all files?
Your 'spec' leaves so much unclear.
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.