peterNavig

New Member
Joined
Feb 12, 2019
Messages
1
Hi,

I am trying to calculate the optimal way to load containers.

I have the current amount of fuel in each container and I have the amount of fuel I know will burn in aggregate prior to reaching my terminus where I will refuel the containers.

I can choose which container I burn fuel from.

I can refuel a container which is less than 10% full, if its >10% the fuels wont mix. I want to be able to load as much fuel as possible at the next terminal.

So I have the following inputs stored in an excel:

FuelConsumed
FuelTodayContainer1
FuelTodayContainer2
FuelTodayContainer3
FuelTodayContainer4
FuelTodayContainer5
FuelTodayContainer6
CapacityContainer1
CapacityContainer2
CapacityContainer3
CapacityContainer4
CapacityContainer5
CapacityContainer6

I think the answer for me is to create an iterative loop such that I satisfy my criteria; to maximise fuel loaded subject to the limitation that I can only load into containers where my capacity prior to loading is less than 10% of the full capacity.

I havent used VBA for a long time and I am struggling to come up with the code to run this.

Any help would be really appreciated.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Forum statistics

Threads
1,213,551
Messages
6,114,266
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top