I’ve been modelling employment plans into my financial model and I’ve been trying to take into account that I might have empty cell values for their employment date in my base model, and then set different employment times in various scenarios. Therefore I’ve had to implement some “EmployeeStartDate != Empty” checks for various variables. After all my calculations are done, I’m left with a small sum of expenses related to employees that are not yet employed, and therefore should not be there. In trying to trace those expenses to find the faulty variable function, I found that it would be super helpful if I could get a breakdown of the contributions to the calculated cell value when I hover or right click a specific cell.
For instance my “Personell expenses” could be derived from salary, software needs, indirect costs of office space etc. If I were to hover a specific cell it would be awesome to see how much each of these categories contributed to the final result.
Personell Expenses – Jan – Feb
Arnold – 0 – 2000
I hover the 2000 cell and see:
Indirect expenses: 500
Something like this would really make modeling faster, because I would be able to identify the roots of potential calculation problems a lot faster. Now I have to check every contributing factor for mistakes until I find it, and these things happen a lot as I try to prototype calculations. If you added a % at the end (and possibly something similar when hovering the overall variable) it would also improve analysis.