PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.
The more I learned MOD, the more excuses I found to use it.
Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...