• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Salary distribution by two criteria

I have an area of land divided into different locations (as in Table 1), where seasonal crops are grown (as in Table 2).
There are also salaries for each location (as in Table 1).
I want to distribute these salaries to crops (in Table 2) by two criteria (cultivated area - number of months of cultivation)
Is there a function to help me in the fair distribution of salaries? How did you use it?


Salaries are a general cost and are not allocated to locations
Therefore, we are trying to find a criterion for their fair distribution
And you solved the best fair standard
Thanks vltem