Thanks, the ExcelR package seems like a nice idea, I will take a look at that for future dashboards. As my current implementation is based on the DT package, I will probably introduce column headers (like A, B, C ,D ) on top of the column names, and will use that to allow some pseudo code like calculations.
Any other ideas that are compatible with a DT implementation?`
@woodward thanks I will see how business users will use R here, or whether I provide a simple interface for just the arithmetic operations.
Thanks so far!