Paki-usap kelangan ko ng tulong. Marunong ako mag excel pero di ako mahusay. Kelangan ko ng excel sheet na mag cocompute para sakin ng scenario na ito:
1. First, there will be a maximum of 20 Total Order Cost.
2. All Total Order Costs data must be AUTOMATICALLY distributed and must be BALANCE on 3 different groups: 'Delivery Option 1', 'Delivery Option 2, and 'Delivery Option 3'
3. Data on each group will be summed up.
4. Each sum should be CLOSE WITH EACH OTHER AS POSSIBLE. Best case scenario is they are all equal but since data will depend on every situation, it is understandable that sum of data on each cannot be always possible to be equal to each other. But the goal still remains, dapat magkakalapit ang bawat ng values.
5. Picture below is an actual cost distribution na ginawa ko manually. 12 Data lang yan pero para ma distribute ko ng balanse, inabot ako ng higit isang oras para ma trial and error yung paglipat lipat ng mga values sa iba ibang Delivery Options para lang maka siguro akong yang nakuha ko na yan ay yung best possible distribution at wala nang iba. So sa magagawa pong program/code, yan na po yung reference nyong output para masabi nating working as expected yung code.
Sana matulungan nyo po ako please Need ko po talaga yan dahil ang tagal ko maka tapos ng isang ganyan partida yang sinend ko ay 12 data palang. Maxmium na na-experience ko ay 18 Data at di ko na alam gano ko katagal bago ko natapos balansehin yun.
Ok lang po kahit Excel or Visual Basic. Kung Excel, walang problema kung naka Macro (di pa kasi ako marunong mag Macro). Basta ang mahalaga po ay madistribute ko sila as perfect as possible.
Maraming maraming salamat po!
1. First, there will be a maximum of 20 Total Order Cost.
2. All Total Order Costs data must be AUTOMATICALLY distributed and must be BALANCE on 3 different groups: 'Delivery Option 1', 'Delivery Option 2, and 'Delivery Option 3'
3. Data on each group will be summed up.
4. Each sum should be CLOSE WITH EACH OTHER AS POSSIBLE. Best case scenario is they are all equal but since data will depend on every situation, it is understandable that sum of data on each cannot be always possible to be equal to each other. But the goal still remains, dapat magkakalapit ang bawat ng values.
5. Picture below is an actual cost distribution na ginawa ko manually. 12 Data lang yan pero para ma distribute ko ng balanse, inabot ako ng higit isang oras para ma trial and error yung paglipat lipat ng mga values sa iba ibang Delivery Options para lang maka siguro akong yang nakuha ko na yan ay yung best possible distribution at wala nang iba. So sa magagawa pong program/code, yan na po yung reference nyong output para masabi nating working as expected yung code.
Sana matulungan nyo po ako please Need ko po talaga yan dahil ang tagal ko maka tapos ng isang ganyan partida yang sinend ko ay 12 data palang. Maxmium na na-experience ko ay 18 Data at di ko na alam gano ko katagal bago ko natapos balansehin yun.
Ok lang po kahit Excel or Visual Basic. Kung Excel, walang problema kung naka Macro (di pa kasi ako marunong mag Macro). Basta ang mahalaga po ay madistribute ko sila as perfect as possible.
Maraming maraming salamat po!
Attachments
-
You do not have permission to view the full content of this post. Log in or register now.