I request a must needed update on the reference excel spreadsheet. Very helpful.
I second this request! Karma for the request and the one who updates the sheet.
I've recently begun modding sins, so I figured I'd pick up this little project because it will help me out as well as familiarize me with a lot of the entities.
http://spreadsheets.google.com/pub?key=tL2s8xxE429nFYEvV2MfjQg&gid=0
I just started, so don't expect much. The link is automatically updated as I progress though.Any certain categories that you think would be more important than others?As a note, this is all for Diplomacy 1.0
new update, nice.
I'm trying, but it's a lot of text to skim through!
which file has all this info? My graphics card just died and im gonna wait for Fermi to come out before I replace it. Meanwhile, I've had the urge to do some Excel tables for sins along these lines
Ooh thanks for that Guenwhyever. I've made a post in another thread kind of regarding this. See below:
Hi guys.
Sorry for the necro, but I'm new the Sins (bought Trinity a little while ago) and am the kind of person who *needs* to know all of this stuff.
How up to date is this information? I've found when searching myself that alot of the stated percentage damage dealt by different weapon types to different armour types is different now compared with everything I'm reading on the web.
Because of this, I'm trying to update the wiki page on "Ship Types" with the most current data that I find in the game files.
I've found the "DAMAGEPERCENTBONUS" that each weapon type deals to each armour type (in Gameplay.constants), but can not find each ship types armour type, or even which weapon type each ship has.
Have all of the armour types and weapon types remained unchanged for each ship since this was posted? Is it only the numbers that have changed?
Regards.
**Edit **
I've found the armour types of all the ships (in the manual!!) apart from the Colony Frigates (it doesn't state a type) and the Strikecraft (it doesn't mention strikecraft at all).
The manual also lists each ships weapons, but doesn't mention what weapon type the ship is classes as, making knowledge of the armour type rather useless to be honest.
**Edit 2 **
The Trinity Manual states that the Carrier Cruisers have an armour type of "Medium", but all references on the web (the wiki and this thread, for example) are saying they have type "Heavy". Is this a typo in the manual or has it been changed from previous versions?
This is why I would like to know where to look in the game files for such information
https://forums.sinsofasolarempire.com/177335/page/3/#2561660
Un up-to-date spreadsheet really is needed, but in the meantime:
Scouts = light armor, anti-light damageLight Frigate = medium armor, anti-heavy damageLong Range Frigate = light armor, anti-medium damageFlak Frigate = medium armor, anti-very-light damageSiege Frigate = light armor, anti-very-heavy damageColony Frigate = light armor, anti-light damage
Fighter = very-light armor, anti-light damageBomber = light armor, anti-very-heavy damageSupport Cruisers = heavy armor, anti-heavy damageHeavy Cruiser = very heavy armor, composite (awesome vs everything) damage
Thankyou for that Darvin3. Out of interest, how do you know this information? Is it just through vast experience and an ingame "feeling", or can it be found in some game files?
Maybe this info can all be on the SoaSE wiki where anyone can update the page keeping the version for the page at top and editable.
The damage modifiers are in Gameplay.constants, look for lines like this:
DamagePercentBonus:ANTIMEDIUM:Medium 1.33333
The armor and damage type for ship are in the respective entity files (you will need to convert them from bin to text to view).
Look for lines like this in the entity files:
armorType "Light" AttackType "ANTIMEDIUM"
armorType "Light"
AttackType "ANTIMEDIUM"
happen to know a simple way to do this? I'm trying to setup an excel spreadsheet that wont take alot of effort to update (hopefully just copy-paste the files), that way we dont have to wait for these compilations.
First, you need to convert the bin files to text files. This can be done manually or with a bin to text converter like the text bin gui from harpo. Quote from harpo "here is my uploaded sins 1.19, entrenchment 1.05, and diplomacy 1.01 all txted by my text bin gui (all convertable files converted, but excluding movies,textures and sounds)." harpo rocks!
Get NotePad ++ (optional). NotePad ++ is notepad on steroids and great for coding. Free open source.
I had problems with that bin to txt converter, so it's a good thing you linked the direct downloads.
I am pretty much done (really only doing the ships, other stuff should be the same). just have capitals left, but i wanted to ask a question about convention. In the old chart, it lists a number for DPS. When I look in the file, there are numbers for multiple banks. In the capitals, im sure I'll run into multiple weapon types. I noticed that if I took the sum of the banks damage and divided it by the PreBuffCooldownTime, I got the DPS numbers to look like the old chart. I just want to make sure that this way of getting the number is correct, as it is the only calculation that im making and it's so important.
^Yup, that is how the game calculates DPS (though it rounds to the nearest whole number on the display). Capitalships will have 2 or 3 weapons, but they are all Capital type weapons, so just adding the DPS for each weapon should be good enough.
Thank you. I see another thread on this forum has popped up with talk of chart-like qualities. So I might integrate some of the things they are looking at there into this chart.
But the best thing about my chart-it is extremely easy to update. The chart itself is a tabulator. So, you import the txt files and its done. Im planning a macro to do that even. so you might push a button and your chart gets updated.
I'll be starting one as soon as I get my laptop back from the shop. Sometime around tuesday, I hope...
-Twilight Storm
There are many great features available to you once you register, including:
Sign in or Create Account