Help with Design / Structure of Salary Forecast Spreadsheet

[LordGanicus]

Hi there,

I need some advice to see if there was a better way to present my salary forecast in excel.

The challenge for me is, with a huge data set, I am having to replicate the rows of staff 7 times to take into account the various lines of remuneration. This is because we split our salaries into various compositions, and not each staff is entitled to certain allowances.

The excel represents an extract populated with fake data.

Assuming I had 1000 staff, thats 7000 rows of data that would need to be presented in a single sheet. Would there be a better way of doing this?

Thanks in advance.

Kind regards