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!
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!