© 2003-2024 Ironclad Games Corporation Vancouver, BC. All rights reserved.
© 2006-2024 Stardock Entertainment
Search
Forum Home | Login
DarkFour
DarkFour
Join Date 07/2008
+1

Please, an updated reference sheet

February 17, 2010 10:08:50 PM from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

I request a must needed update on the reference excel spreadsheet. Very helpful.

strategy
Locked Post +1 Karma
Search this post
Advanced Search
Subscription Options
Reason for Karma (Optional)
Successfully updated karma reason!
GJDriessen
DarkFour
GJDriessen
Join Date 09/2005
+1
Reply #1 February 18, 2010 4:02:45 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

I second this request! Karma for the request and the one who updates the sheet.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Guenwhyever
Join Date 06/2009
+1
Reply #2 February 18, 2010 5:04:24 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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

+1
Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
DarkFour
Join Date 07/2008
+1
Reply #3 February 18, 2010 4:15:07 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

new update, nice.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Guenwhyever
Join Date 06/2009
+1
Reply #4 February 18, 2010 6:12:09 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

I'm trying, but it's a lot of text to skim through!

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
SithLordAJ
Join Date 04/2008
+37
Reply #5 March 5, 2010 4:28:06 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Surge72
Join Date 04/2009
+16
Reply #6 March 11, 2010 11:03:47 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Darvin3
Join Date 12/2008
+177
Reply #7 March 11, 2010 3:32:10 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

Un up-to-date spreadsheet really is needed, but in the meantime:

 

Scouts = light armor, anti-light damage
Light Frigate = medium armor, anti-heavy damage
Long Range Frigate = light armor, anti-medium damage
Flak Frigate = medium armor, anti-very-light damage
Siege Frigate = light armor, anti-very-heavy damage
Colony Frigate = light armor, anti-light damage

Fighter = very-light armor, anti-light damage
Bomber = light armor, anti-very-heavy damage
Support Cruisers = heavy armor, anti-heavy damage
Heavy Cruiser = very heavy armor, composite (awesome vs everything) damage

+1
Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Surge72
Join Date 04/2009
+16
Reply #8 March 11, 2010 7:54:06 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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?

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
myfist0
Join Date 01/2010
+319
Reply #9 March 12, 2010 11:05:30 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
ZombiesRus5
Join Date 02/2009
+340
Reply #10 March 12, 2010 11:35:20 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

Quoting Surge72,
reply 8
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?

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"

+1
Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
SithLordAJ
Join Date 04/2008
+37
Reply #11 March 13, 2010 1:00:20 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

Quoting ZombiesRus5,
reply 10

(you will need to convert them from bin to text to view).

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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
myfist0
Join Date 01/2010
+319
Reply #12 March 13, 2010 9:36:15 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
SithLordAJ
Join Date 04/2008
+37
Reply #13 March 15, 2010 2:29:25 AM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
GoaFan77
Join Date 10/2008
+629 moderator
Reply #14 March 16, 2010 4:08:15 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

^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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
SithLordAJ
Join Date 04/2008
+37
Reply #15 March 17, 2010 1:55:44 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

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.

Reason for Karma (Optional)
Successfully updated karma reason!
DarkFour
Twilight_Storm
Join Date 07/2009
+92
Reply #16 April 1, 2010 8:56:08 PM
from Sins of a Solar Empire ForumsSins of a Solar Empire Forums

I'll be starting one as soon as I get my laptop back from the shop.  Sometime around tuesday, I hope...

-Twilight Storm

Reason for Karma (Optional)
Successfully updated karma reason!
View all recent posts
Mark all posts as read Delete cookies created by the forum Return to Top
Stardock Forums v        Server Load Time:   Page Render Time: