• 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

    Hui...

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

allocation issue

Praveenrvpk93

New Member
i have generation from various statements. i want to allocate this to customers proportionally.
I have derived statement wise total proportional units upto which the customer is eligible.
I have to allocate this proportional units to the customers as slot wise with proportion to the slot wise generation.
By doing this the following criteria should get tally.
1.Proportional units should be allocated to the customers
2.The closing banking should not be less than zero
3.Net value of total allocation should not be more than the planning as slot wise.
Please find the attached file. in this i am done a sample allocation but the alloted unis is more the planning to be allocated.
kindly advise me
 

Attachments

  • allocation.xlsx
    36.8 KB · Views: 8
Back
Top