Steam 커뮤니티 :: 가이드 :: 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,385	순 방문자 수
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

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

tool, I have been using it.

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!

< >