编写VBA宏代码以解决旅行推销员问题 [英] Writing the VBA Macro Code to solve Travel Salesman Problem

查看:89
本文介绍了编写VBA宏代码以解决旅行推销员问题的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

任何人都可以帮助我编写VB代码以解决Excel中的Travel Salesman问题.我有一个基点和235个客户.我已经确定了所有235个客户的预期需求概率,并给出了所有客户的经度和纬度,还给出了从各个客户和基础到达的时间(以分钟为单位),还给出了距离. br/>
我可以给您发送文件,以获取有关如何针对此问题编写宏的正确指导.

亲切的问候,

siddharth

Could anyone please help me in wrtiting the VB Code for solving the Travel Salesman Problem in Excel.I''ve a base point and 235 clients . I''ve the Expected Demand Probabilities for all 235 clients and the latitude and longitude are given for all.I''m also given the time ( in minutes ) to reach from various clients and the base.The distance is also given.

Could I please send you the file to have the right guidance on how to write a Macro for this problem.

Kind Regards,

siddharth

推荐答案

写道:​​

我可以给您发送文件以获取有关如何为该问题编写宏的正确指导.

Could I please send you the file to have the right guidance on how to write a Macro for this problem.



没有.另一方面,您可以看看[ ^ ].
:)



Nope. On the other hand, you may have a look at [^].
:)


这篇关于编写VBA宏代码以解决旅行推销员问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆