Salary allocation

[el_greco]

Hi all,
I have a method to allocate salaries to various projects that have different budget levels and duration. The aim is to use up the maximum of the available budget. The salaries are allocated based on priority. Projects, salaries and LOE's are pro-ratio-ed. I believe that there's a problem at the end of the calculation (step 4) as the software it has been fed into is taking ages to come to a result.

Could anyone help by checking the calculations? Could there further be a possibility to reduce the number of calculation steps? I'm not able to share the excel file but happy to share it through dropbox or other.

Thanks a lot in advance for your support!

 

[LouiseMtt]

Sounds like your formula setup might be too complex or iterative for the software to handle efficiently. Simplifying the steps, using helper columns, or breaking the calculation into smaller chunks usually speeds things up. If you can share via Dropbox, someone could check for bottlenecks directly.