[练习题][VBA第4期]字符串首尾相连

Luckyguy2008 · 发表于 2007-11-17 22:51

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用ldy在2007-11-17 22:40:00的发言： 2008 做过EH的29期VBA竞赛题吧?此题就是从那里转化而来。2008做此题应该不会太困难。</div>是做了，但是思路怎么跟这个不一样呢，难道我那题做错了[em04][em04][em04]

ldy · 发表于 2007-11-17 23:05

呵呵是我的思路你用你的代码算一算下面这个10 个金币是否 = 435  ---刚才打错字<table cellspacing="0" cellpadding="0" width="420" border="0" xstr="" style="WIDTH: 320pt; BORDER-COLLAPSE: collapse;"><colgroup><col span="10" width="42" style="WIDTH: 32pt; mso-width-source: userset; mso-width-alt: 1344;"></col><col></col><col></col><col></col></colgroup><tbody><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl24" width="42" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green 2pt double; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: yellow;">起点</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl36" width="42" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: lime;">98</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl36" width="42" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: lime;">39</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl26" width="42" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl29" width="42" xnum="" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green 2pt double; BORDER-LEFT: green; WIDTH: 32pt; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">8</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl35" height="34" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: yellow;">14</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl33" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: lime;">87</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl37" xnum="" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: lime;">29</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent;"></td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 0.5pt solid; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green 0.5pt solid; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl34" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: yellow;">59</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl34" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: yellow;">58</td><td class="xl34" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: yellow;">51</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl31" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 0.5pt solid; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" xnum="" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">26</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl27" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td><td class="xl30" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 0.5pt solid; BACKGROUND-COLOR: transparent;">　</td></tr><tr height="34" style="HEIGHT: 25.5pt; mso-height-source: userset;"><td class="xl32" height="34" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green 2pt double; BORDER-BOTTOM: green 2pt double; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl28" style="BORDER-RIGHT: green 0.5pt solid; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: transparent;">　</td><td class="xl25" style="BORDER-RIGHT: green 2pt double; BORDER-TOP: green; BORDER-LEFT: green; BORDER-BOTTOM: green 2pt double; BACKGROUND-COLOR: lime;">终点</td></tr></tbody></table>

[此贴子已经被作者于2007-11-17 23:11:15编辑过]

Luckyguy2008 · 发表于 2007-11-17 23:29

坏了，果然做错了，我第一趟捡的是最大值333，但回来时只能捡到73，一共才406。 我只考虑了去和回都捡大的，没考虑要2次和最大，想的太简单了。 [em04][em04][em04][em04][em04]

[此贴子已经被作者于2007-11-17 23:31:45编辑过]

ldy · 发表于 2007-11-17 23:39

我找不到取巧的方法，只有全部来回循环一遍比较取最大值。

Luckyguy2008 · 发表于 2007-11-17 23:53

想了一下，去用循环，回来可以用我原来的方法。 但是去如果是个全循环计算量可能比较大，再想想有没有简单方法。

qee用 · 发表于 2007-11-17 23:56

呵呵,怎么讨论到竞赛题上了.ldy兄这道题出的很好.辛苦了.

ldy · 发表于 2007-11-18 00:02

用兄好，这题就是从我解竞题赛的思路转化而来。to 2008 别的不方便讨论。把我的代码运行速度给你参考一下 历遍所有来回组合，18个金币 0.1秒，35个金币以下一秒左右，60个金币耗时 1--3分钟。如果98个金币，去程组合 48620 个，来回程组合将是几亿种（小于6.25亿）我这个程序最少运行1--2天，好在没对金币数量有要求。除了历遍比较的方法想不出其他的法了。

qee用 · 发表于 2007-11-18 00:12

嗯.ldy兄,如果好好想想,相信你一定能找到更快的方法.我使用的是一种不稳定的算法,运行时间取决于数据分布,98-运气好的时候1秒以下就可以解决.呵呵[em07]

Luckyguy2008 · 发表于 2007-11-18 00:17

不讨论了，我再好好想想 另外，我目前错误的方法98个金币来回也就10毫秒[em04][em04][em04][em04][em04]

ldy · 发表于 2007-11-18 00:20

呵呵我的方法很笨。对于算法还没入门，20 号以后拜读用兄大作。

		自动登录	找回密码
密码			注册

[练习题][VBA第4期]字符串 首尾相连

[练习题][VBA第4期]字符串首尾相连