商店页面
Ashes of the Singularity: Escalation
全部 讨论 截图 艺术作品 实况直播 视频 新闻 指南 评测

Ashes of the Singularity: Escalation

商店页面
Ashes of the Singularity: Escalation > 指南 > X-Peri-MENTAL 的指南
评价数不足
Ashes of the Singularity: Escalation - Unit Database Spreadsheet
由 X-Peri-MENTAL 制作
Introduction
With RTS games I like to know the detailed statistics of units and be able to compare units with other units without flicking between pages. To that end I have created a unit database spreadsheet which I have shared with the community.
   
奖励
收藏
已收藏
取消收藏
创建者
X-Peri-MENTAL
离线
类型: 模组或配置
Languages: 英语
发表于
更新日期
2017 年 2 月 21 日 下午 4:53
2019 年 2 月 10 日 上午 7:47
2,387 不重复访客数
15 当前收藏人数
指南索引
总览
How the Unit Database Spreadsheet Works 
Shortcomings 
Descriptions 
Unit Database Spreadsheet 
Version 
留言
How the Unit Database Spreadsheet Works
The summary spreadsheet references three hidden sheets which contain the contents of UnitTemplates.csv, WeaponModuleTemplates.csv and ModuleText.csv the idea being when new patches are released the contents of the files can be copied into the spreadsheets with minimum effort to display the latest data. The summary sheet uses unit IDs to pull the relevant data from the first mentioned file. Weapon data is pulled using the last file to determine the weapon ID from the name and then use this to pull the data from the second file.
Shortcomings
Please bear in mind this is a work in progress and not all the statistics are guaranteed to be correct. The quantity of weapons a unit has and what type is manually added to the summary sheet and is therefore prone to error.
Descriptions
  • Unit Metal requirement is also shown with unassisted construction consumption rate (Metal / Build Time), useful for balancing economy and construction projects.
  • Unit Radioactives requirement is also shown with unassisted construction consumption rate (Radioactives / Build Time), useful for balancing economy and construction projects.
  • Second HP value in brackets is HP with armour bonus (armour calculation is typically used to reduce inflicted damage, it can also be thought of as increased HP, ignore for armour penetrating weapons).
Unit Database Spreadsheet
Click here for Unit Database Spreadsheet[docs.google.com].
Version
10/02/19
  • Data updated to Ashes of the Singularity: Escalation version 2.77.

20/02/18
  • Added PHC Atlas and Substrate Tormentor units.
  • Corrected armour equivalent HP values.
  • Data updated to Ashes of the Singularity: Escalation version 2.71.

19/09/17
  • Updated to match new internal names.
  • Weapons max range turns blue if it exceeds vision range indicating radar or scouting required to achieve weapons range potential.
  • Data updated to Ashes of the Singularity: Escalation version 2.5.

29/08/17
  • Started to include dreadnought upgrades.
  • Converted lookup function to use column label instead of column index.
  • Data updated to Ashes of the Singularity: Escalation version 2.4.

13/06/17
  • Data updated to Ashes of the Singularity: Escalation version 2.3 .
20 条留言
< >
drivver44 2021 年 2 月 10 日 上午 4:13 
just a heads up this
the spreadsheets are all out of date as of the 2.92 and 3.0 balance changes
however paragraph 1 is how find the stuff
music98god 2019 年 2 月 11 日 上午 7:17 
Thank you for continuing to update:steamhappy: is there a build efficiency or penalty to the sapper? how long does it take to build defensive buildings and the resources compared to upgrading defensive buildings when building with the sapper? Some units are missing prerequisites because you can't build them with just the factory.
demongo1154 2019 年 2 月 10 日 上午 10:48 
sweet, nice work keeping this updated...
X-Peri-MENTAL  [作者] 2019 年 2 月 10 日 上午 7:48 
Data updated to Ashes of the Singularity: Escalation version 2.77
tford1956 2019 年 2 月 10 日 上午 5:32 
It would be nice if we could download or print this spreadsheet.
TAG_Utter 2018 年 12 月 6 日 下午 4:08 
Is it possible you update for new changes?
X-Peri-MENTAL  [作者] 2018 年 2 月 25 日 上午 3:31 
@ Chronopolize - Okay I will get those changes implemented. That is not good for the modders though if the in game stats do not match the data sets. I did think the Mauler performed much better in game than the data suggested.
Chronopolize 2018 年 2 月 22 日 上午 10:30 
@X-Peri-MENTAL
Oh wow. Glad you're finding use out of it.

Yeah, the weapon might be recorded as a 1x, but somehow the cutting array has four weapons points. The mauler does ~630 damage (~510 to a cruiser with 20% armor) per sweep to a target, suggesting it has 4 copies of the recorded weapon (based on stats). I also found out you can see 4 lasers if you look closely.
https://i.imgur.com/nixYhlM.jpg
For shield vs armor, here's a dev reply: https://i.imgur.com/ISkSElB.png
X-Peri-MENTAL  [作者] 2018 年 2 月 22 日 上午 4:01 
@Chronopolize
* Apollo main gun corrected for Flak Cannon from Falcon AA Autocannon.
* In SS_2_Mauler.modules there are 2x 'Mauler Plasma Cannon' and 1x 'Hyena Laser Cutting Array'. I don't see a 4x of a weapon?
* Can you provide a refenece for armor applying to shields? Seens a very odd and counter intuitive design choice.

P.S. Thanks for your mutiplayer :War: tool, I have been using it. :steamhappy:
Chronopolize 2018 年 2 月 20 日 下午 11:28 
Noticed Apollo has the Flak Cannon, not the Falcon Mark 1 AA Flak Cannon. Also the Mauler has 4x of its weapon, despite the in game not showing a (x4) count.
I also learned that shields are effected by armor too, so it would be nice if there could be a similar "effective health" for shields as well.
Thanks for the 2.7.1 update!