how to make a distance table with excel?? Please help me

Bagaimana cara membuat tabel jarak menggunakan excel bro??

Thanks for uploading this ✨

Thanks!

Really cool

Should we add the distance from the last node to initial node to the objective?

The only mistake which i can see that for 1-1 should be defined high value

weon eres la mejor wea que me ha pasado en la vida

How can I solve the same Problem but not for all cities ? how would be the solution if I need to show the distance just for 3 or 4 cities from this 7 cities ?

Hallo, can I have your Email? I need your help to fix a Travelling Problem but for a Warehouse

I need help with Simulation contact me plz

Hi Joseph, Can i also use simplex for tsp using solver.

Hi Jeffy, could you explain how to solve it, but with starting/ending point as 1? I need to calculate route starting on point 1 and then going back to this city.

Hi. I did not get, what are you doing at 00:34

Hi, how can i get this software?

What if I need to fix the starting to to be number 1? What are more conditions I need to add there

Awesome!

not bad, can you also make a tutorial for bold (**content**) or italic (*content*)

Este we sabe cosas

Do you know how to save solver model in LibreOffice exporting to Excel?

why I can't repeat it by cos? and tan?

Good video Jeffy, thank you.

Literally life-changer information!!!!!!! Thanks a lot

So useful and simple, But how can i set a starting point, supposing that 1 is the centre of distrubution where the trucks or vehicles are supposed to come back again?

Hi Joseph....i got furthur less using the same data and same technique as advised by you...126

thanks a lot

Where is route? You got distance but how about path?

i dont think thats right

Hey Jeffy, nice video. I found it interesting that you showed how to solve the TSP using the evolutionary algorithm on Solver. I`ve always solved it as an exact method, and I found it very simple to apply with GA. Thanks for this!

Good one

Congrats

Very informative..

Thank you for making a smart video! I did my task of TSP using this video!

Thank you for sharing this. It's clear and straight to the point!

Very nice, thank you!

in your calculation you did not return to pint 1 which you started from.

No useless explanations, straight to the point! Great work!

I'm using excel 2007.There's no diff option.so i downloaded open solver but there this problem can't be solved.What can i do?

Dear sir There is a significant mistake in the formula of cell n2h1 . because its depends on cell D, while it should be depended on the cell C (input cell) Thank you

dear sir. why did you use minuse sign for b1 and b2 and b3 in calculating instead of positive sign ? thank you

SO SIMPLE. I LOVE YOU . YOU SAVED MY ASSIGNMENT.

Can any one help me with simulation model ? What I’m working for my final thesis.

Very good, very simple, thank you.

If you limit the solver to 20 seconds, it will only find the best one it was able to get to in 20 seconds. While it is _a_ solution, it is not guaranteed to be the best solution.

thanks a lot but another time when you try to record a lesson plz record in quite a place, not in the street

What if the starting point and ending point are two different locations and fixed? Looking for a quick reply.

YOOO Mr Joseph, shout out to youuuuuuu. Thanks to you, I can get my Assignment done. HELLO MR SILVAM

why is the evolutionary solver preferredm in this problem

Which method is used in this video to solve TSP? I tried the same problem using zero- one programming in excel solver (simplex algorithm) and it gives the same result but involves many constraints..

It didnt work