• 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.

Logic for Logistics -

A

Aaditya Hamine

Member
Hi all !

I need to define a logic for one of my requirement in logistics.
I am attaching a file herewith explaining all the details.

If you have any doubt , please feel free to ask me.please see if you can help me with it.

Thanks.

Aadi
 

Attachments

I think this problem would be a lot more comprehensible if you used a list of specific sailing dates for vessels as opposed to just days. With that data, you could approach the problem in a different manner - as the ship sailing DATES/country of origin are the governing factor in your problem.

With a table of sailing dates it would be very straightforward to compute your pickup deadline for arrival by a specific date.
 
Hi David !
Thanks for your reply.
Well actually real pain lies there only . The shipping industry works on 'day' not on 'date'. Therefore the 'day' is very crucial parameter in deciding the tentative arrival . Therefore I am seeking help which will help me to come up with this logic.
@vletm : Hi ! Its just an example data - I will be having around 20 countries in the complete list. Regarding freight cost - I will fill in the formula's later . As of now i have just linked the volume of consignment with the freight cost.

Thanks and await your suggestions.

Aadi
 
@Aaditya Hamine
Do it work as You wanted?
Select Country > Select date > the results [B11:B18] and [D3].
What is CBM? number, connection with something?
Freight Cost[H3] maybe should be like =[F3]*[H7]
and Every Country have own fixed values
like [H7]=100, [H8]=200 ... not [F3]*100 and so on?
'My Data sheet' should move to another sheet ...?
Is that result area Okay? Need wanted/useful layout.
You'll give parameters, I'll try to ask questions.
 
Aadi -

I had a go at developing a table with some logic for you - take a look at it and see what you can use from it, and let me know what doesn't make sense to you ...
I made up some silly ports to amuse myself while hunkering down from an El Nino storm here :eek:

I think it will get you started and we can with a few more iterations, get it to where you're trying to go ....:cool:
 

Attachments

Hi David !
Appreciate your enthusiasm towards excel . Hunking down in El nino and still writing codes .. Hats off ! :) Hope you are safe and could read this mail.
I feel we need to make slight changes in the logic - as port delivery time changes for every port . We can add separate column within the same data range to get the exact idea.

@vletm - you are awesome man ! You have created a perfect logic. I could not see any formulas or anything. Please help me with those details - so that i could be able to understand the logic very well.

I am newbie to this forum and need to learn a lot from you..

Thanks and look forward to your reply.

Aadi
 
@Aaditya Hamine
Where do You need to see formulas or something?
Is safer to use ... no need to be worry about 'delete'-button mistakes.
Of course, there are formulas ... with Macros ( not cleaned ).

Now, You should test to fill 'Sheet1' ->
check that all dates will be okay as You wanted ->
press [Save] ...
Next shipping and so on ...
Go to 'Sheet2', is there enough information?
Those 'boxes' shows 'where are Your shippings'.
Try add 'new Countries' with needed information.
And test to use again...

Maybe 'Delete' or some function to hide/delete the oldest shippings.
Do You use some 'tracking code'?
Ideas ... Questions?
 
@vletm : Perfect sheet now . I just read the macro you have written.
However I am very to macro and programming in excel - so it was little bit time consuming for me to understand the whole logic.
Anyways you have done a great job and thanks for your help.
I will still keep trying to develop logic on my own ( using basic excel formulas - as i cannot do coding in VB) -
 
You must log in or register to reply here.
Back
Top