Sorry, new on the block so hopefully not breaking any rules already (!)
I'm a cost administrator for a construction company. I keep costing spreadsheets for each building project with tabs for employee costs, professional fees, suppliers etc
The employee costs are in a table with the date (week ending) heading the columns and the employees listed in rows, their weekly hours are inserted into that table.
Now however I've got a situation where some employees pay rates are staying the same, some are going up and some are going down, this is all happening on different dates for different employees. So this simplified table doesn't seem fit for purpose anymore.
I am racking my brains on how to do this simply but I'm struggling. Has anyone had to do this before? I imagine it's common but might be wrong!
Any help would be greatly appreciated!
Bookmarks