Excel潜能系列——Excel游戏（2v2战斗~5v5战斗模拟器）【更新V1.5】 Einsphoton

系统管理员 2022-06-08 07:54 329阅读 0赞

*  这段时间对Excel的性能做了一下了解，目前已经挖掘Excel功能的30%，用于做这个多人战斗模拟器。
 *  其实Excel还是蛮强大的，尤其是脚本控制这一功能。实际上使用Excel，图形交互操作可以做到的功能都可以使用vba来控制实现，反过来VBA可以实现的逻辑图形交互操作却实现不了。
 *   
 *  次战斗模拟器可以实现多人对战的模拟，虽然当前是2v2的战斗，实际上只要再添加6个战斗单位就可以构成5v5的战斗（很容易）。由于采用了面向对象的思想编程，逻辑结构非常清晰，执行效率也非常高。
 *   
 *  在“Data”页里，用户可以自己添加战斗单位或者修改战斗单位数值，以便在“Emulator”页里取用。
 *   
 *  在之后的版本中会添加快速战斗1000次统计数据的功能，以及5v5的战斗。
 *  此工程打算为之后的多人战斗数学模型的研究做基础。

[![Excel潜能系列——Excel游戏（2v2战斗~5v5战斗模拟器）【更新V1.5】 <wbr>Einsphoton][Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton]][Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton_Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton]

更新日志：

<table style="margin:0px; padding:0px; color:rgb(70,70,70); font-family:&quot;Microsoft YaHei&quot;,&quot;Helvetica Neue&quot;,SimSun; font-size:14px; width:459pt; border-collapse:collapse">    
 <tbody> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); width:459pt; height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">2014.11.05</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">Ver.1.1</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">①修改攻击目标选择BUG</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">②添加战斗动画</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">③数据加载优化</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">　</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">2014.11.05</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">Ver.1.2</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">①添加受击动画</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">②添加死亡效果</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">③修复因没有选择单位而报错的BUG</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">④增添清扫战场功能，每次开启文档以及再一次战斗的时候，战场不会乱糟糟的了</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">⑤游戏界面焕然一新</span></td> 
  </tr> 
 </tbody> 
</table>

<table style="margin:0px; padding:0px; color:rgb(70,70,70); font-family:&quot;Microsoft YaHei&quot;,&quot;Helvetica Neue&quot;,SimSun; font-size:14px; width:459pt; border-collapse:collapse">    
 <tbody> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); width:459pt; height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">2014.11.07</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">Ver.1.3</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">①修复office2013环境下64位报错BUG</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">②修复鞭尸BUG</span></td> 
  </tr> 
  <tr style="height:13.5pt"> 
   <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); background-color:rgb(217,217,217); height:13.5pt"> <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal; line-height:18px"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">③增添快速战斗功能以及数据初步统计</span></p> <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal; line-height:18px"> &nbsp;</p> 
    <table style="margin:0px; padding:0px; width:459pt; border-collapse:collapse">    
     <tbody> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); width:459pt; height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">2014.11.13</span></td> 
      </tr> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">Ver.1.4</span></td> 
      </tr> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">①提高了快速战斗的运算效率</span></td> 
      </tr> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">②进一步增添了战斗数据的统计</span></td> 
      </tr> 
     </tbody> 
    </table> <p style="margin-top:0px; margin-bottom:5px; padding-top:0px; padding-bottom:0px; border:0px; list-style:none; word-wrap:normal; word-break:normal; line-height:18px"> &nbsp;</p> 
    <table style="margin:0px; padding:0px; width:459pt; border-collapse:collapse">    
     <tbody> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); width:459pt; height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px"><strong>2014.11.26</strong></span></td> 
      </tr> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px"><strong>Ver.1.5</strong></span></td> 
      </tr> 
      <tr style="height:13.5pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); height:13.5pt"> <span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px"><strong>①增减战斗伤害公式选择功能</strong></span></td> 
      </tr> 
      <tr style="height:27pt"> 
       <td style="margin:0px; padding:0px; font-family:Verdana,宋体,sans-serif; line-height:18px; border-width:initial; border-style:initial; border-color:rgb(240,240,240); width:459pt; height:27pt"> <strong><span style="font-family:宋体; font-size:14px; word-wrap:normal; word-break:normal; line-height:24px">Tips：用户在设定伤害公式系数的时候悠着点，因为不懂VBA如何安全编程，所以<br> 会出现数据溢出的问题！</span></strong></td> 
      </tr> 
     </tbody> 
    </table> </td> 
  </tr> 
 </tbody> 
</table>

下载链接：http://pan.baidu.com/s/1hqkpvZu

[Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton]: http://s11.sinaimg.cn/mw690/002UUI0Lgy6NnjJdGI29a&690
[Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton_Excel_Excel_2v2_5v5_V1.5_wbr_Einsphoton]: /images/20220608/6814c981883449a49382f7e0a2a85aba.png