Dear all

We have the attached spreadsheet using the four tabs shown, the formulas being used in the Salaries and Time sheets are calculated using the Staffdetails tab, this original layout allows for only two changes in Salary Costs\Charge Out Rates throughout the year

What we're looking to achieve is add additional columns in the Staffdetails sheets for Salary Costs (D to H) and additional columns to Charge Out Rates (L to O), this will allow for further changes in salary and charge out rates throughout the year.
MasterBudget2_NewLayout.jpg

The other problem posed is in Columns B and C on the Staffdetails page as they are also brought into play on the formulas used on the Salaries page, which you can hopefully see.

If anyone can shed any light on the best practice to achieve this i'd be really grateful if you could drop me a line

Many thanks

ubeauty

Master Budget 13_14.xls