Sins of a Solar Empire : Real-Time Strategy. Unrivalled Scale.
© 2003-2016 Ironclad Games Corporation Vancouver, BC. All rights reserved.
© 2006-2016 Stardock Entertainment

So I have an updated refrence chart...

By on April 6, 2010 1:50:57 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

SithLordAJ

Join Date 04/2008
+37

I started this a couple weeks ago, got really far in like a day, then have been at work non-stop ever since. But I was off yesterday and so I finished it. Couple things I want to say about it though:

There is more I wanted to do with it, but I figured it works like this, so I should let it out now before I get side-tracked on something else

It is an Excel file. I know thats not what everyone is used to, but the purpose of doing it this way is that I set it up in a way that will let anyone update the chart in a flash. All that is needed is to convert the bins to txt, then hit a giant button. it will ask you for the locations of all the files it pulls from (individually; this is one of those things i wanted to work more on), and import all those files into the chart. I did use an older version of excel (2000).

The .XLS file + PDF  <--- Now in one place

edit-updated 12/18/12

This uses the Rebellion stats. Please do not update if you're only interested in Diplomacy stats.

Stats on my stat sheet: 2968 downloads as of last update.... 4945 pdf downloads.

Pinned, Locked Post 69 Replies +2 Karma
Search this post
Subscription Options


Reason for Karma (Optional)
Successfully updated karma reason!
Guenwhyever
mafutnyoas
April 9, 2010 2:21:23 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

.... I'm suprised only one person seems to be interested in this after all the requests.... and a bit curious. Are people not interested because it's an excel file? is it that I dont currently have it hosted somewhere? Is it coz of my unknown name? Does this message have an odor im not aware of?

Reason for Karma (Optional)
Successfully updated karma reason!
April 9, 2010 2:44:14 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

http://forums.sinsofasolarempire.com/378976

Try here.  There've already been 2 charts posted and this would be a great place to put it.  (We're trying to get that page stickied by a moderator)

-Twilight Storm

Reason for Karma (Optional)
Successfully updated karma reason!
April 9, 2010 10:11:58 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Spring or pre-Spring break for many and a lot of trivial posts bump it down.  I'm glad to have it--thanks!.

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 2:39:14 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

apparently it wasnt friday enough yet.

I think I got it hosted. I was worried about having to make up some account im never going to use again just to do it. found out mediafire doesnt require a sign up, so lets see if this works

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 11:12:22 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Very nicely done.  Would be awesome if you could package it as an executable with it's own window and style.  Still it is extreely well done.  Good job.

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 11:17:02 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Might try taking screenshots or something and posting them in the OP, then people would be able to see it if we don't have the right program...I mean if THEY don't have the right program... *Backs out of thread slowly before anyone realises*

-Twilight Stor

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 11:40:35 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Even if you don't have Excel I believe Open Office canopen it and the Excel Viewer is also free.

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 4:00:28 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Quoting SIN-Imperium,
Would be awesome if you could package it as an executable with it's own window and style.

I've thought about this for a number of my excel charts I've made (I use it at work), the thing is there is alot to do to even get 'cells'... to the point that I'd basically be re-writing excel under another name. There might be some ways around the issue... Im not sure. As far as compatibility, thats why I used excel 2000... its older so more people should be able to use it (Has nothing to do with me not personally owning a newer version ). Also, I figure that if I do nothing more on this ever, its in an easily modifiable format that someone else could do more to if needed.

In light of those other pretty charts floating around, I've been thinking of maybe making it look better by making a background picture or something. I dont want something too distracting though, as it could make it hard to read the data.

 

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 4:24:55 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Maybe a faded picture of the Sins wallpaper that came with the desktop theme?(Basically, it's the cover for the game if you bought the original on a disc)

-Twilight Storm

Reason for Karma (Optional)
Successfully updated karma reason!
April 10, 2010 10:16:29 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Managed to do some clever things to make it look more interesting and added more details. I want to do some stuff to the capital ships chart then ill upload it

Reason for Karma (Optional)
Successfully updated karma reason!
April 11, 2010 8:53:27 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

I am okay with the posting of the statistics of the ships in excel, but the formatting looks weird with the charts done for counters.

 

Oh, and in regards to me having the artist's touch...  My brother is the artist, not me.  He went to college for it and has a degree in graphic design.  I'm his younger brother who luckily received a small portion of his talent.  Honestly though, for a non-artist, I would like to consider myself above average, but when you compare me to him or other artists, let's just say its a landslide.

It is funny though...  He does design primarily and programming secondarily.  I do programming primarily and design secondarily.

 

And besides all that, I didn't feel like taking the time to do it by hand.  My chart was a screenshot of a powerpoint slide with the little arrows pointing to everything.

 

I don't know...  The counters page just seems weird because you have multiple sources of the same information and the formatting doesn't line up.  It just looks thrown together, and makes people more likely to skim that part and misread something critical.

Reason for Karma (Optional)
Successfully updated karma reason!
April 11, 2010 11:11:14 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Quoting SithLordAJ,
apparently it wasnt friday enough yet.

I think I got it hosted. I was worried about having to make up some account im never going to use again just to do it. found out mediafire doesnt require a sign up, so lets see if this works

Awesome, SithLordAJ.  Thank You.  You deserve some karma.

Reason for Karma (Optional)
Successfully updated karma reason!
April 12, 2010 12:46:54 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Hey Sith Lord, the links are no longer working!  It says:  File Deleted.  What happened?  They were good just the other day. 

At least I got my Excel copy saved.  I had posted references to "this". 

Reason for Karma (Optional)
Successfully updated karma reason!
April 12, 2010 12:59:50 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Yeah I know that happened. I updated stuff last night and for whatever reason had issues /w editing my post. tried like 50 times and had to just leave it. should be fine now though

Reason for Karma (Optional)
Successfully updated karma reason!
April 12, 2010 1:11:48 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Awesome again, yeah its working now.  Even better chart than before.  I referenced this in the SoaSE, Unit Reference Chart sticky.  

Thanks again.

Reason for Karma (Optional)
Successfully updated karma reason!
April 24, 2010 5:41:28 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Is it possible for your Macro to also pull the Siege figures for the various Cap ships?

We know from the 1.18 changelog what the siege frigates do, but not the Cap ships.  ie:

TEC Krosov Siege Frigate:

  • Planet bombing damage increased from 21 to 25. (Original Sins Only)
  • Planet bombing damage increased from 21 to 31. (Entrenchment Only)

Advent Purge Vessel:

  • Planet bombing damage increased from 21 to 25. (Original Sins)
  • Planet bombing damage increased from 21 to 31. (Entrenchment Only)

Vasari Karrastras Destructor:

  • Planet bombing damage increased from 23 to 27. (Original Sins)
  • Planet bombing damage increased from 23 to 33. (Entrenchment Only)

For example, I believe that both the Advent Progen Mothership and Vasari 'Egg' colonizer Cap ships do "40" base planet damage.

Reason for Karma (Optional)
Successfully updated karma reason!
May 4, 2010 5:54:47 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Quoting SageWon,
Is it possible for your Macro to also pull the Siege figures for the various Cap ships?

Ill work on that soon. anyone got any feedback on the sandbox? or does no one get how that works? btw, sorry I didnt answer right away. just got a new g-card and have been 'making sure it works'.

Reason for Karma (Optional)
Successfully updated karma reason!
May 15, 2010 8:10:26 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

okay, the capital ships now have a column that indicates planet health damage and population damage per second.

I'm not sure if the formula is right. what I do is take the baseDamage/basePopulationKilled and divide by the bombingFreqTime, This makes my numbers unlike what you have in the post above.

Reason for Karma (Optional)
Successfully updated karma reason!
May 16, 2010 7:24:41 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Quoting SithLordAJ,
okay, the capital ships now have a column that indicates planet health damage and population damage per second.

I'm not sure if the formula is right. what I do is take the baseDamage/basePopulationKilled and divide by the bombingFreqTime, This makes my numbers unlike what you have in the post above.

OK.  Thanks.  Yes, the formula is right, and the numbers jive with my research regarding best Sieges, and with Zyrxil's numbers.

Thank You Again.

Reason for Karma (Optional)
Successfully updated karma reason!
May 16, 2010 7:56:53 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

anyone got any feedback on the sandbox? or does no one get how that works?

I have to admit that I looked at it before, and didn't understand how it worked.  So I tried it again, per your request, and find that it is actually quite easy to use.  Just plug in the ship types, and the number of ships, and it gives an instant answer!   But I have to wonder how accurate it is.  For instance, does it accurately account for armor?  And missing shield mitigation can be very big factor, but don't see how that could be possibly included.

The approach I took was to calculate Cost (@4 per crystal/metal) Per DPS & Supply, and Cost Per effective Hull Points & Supply (fleet Supply points):

Name 4   Cost/DPS  DPS/Cost   DPS/Supp    Hit Pts    Cost/HP    HP/Cost   HP/Supp
Seeker Vessel $200 $82 0.0121 1.2143 865.00 $0.2312 4.33 432.50
Arcova Scout Frigate $200 $78 0.0128 1.2813 647.50 $0.3089 3.24 323.75
Jikara Navigator $305 $82 0.0121 1.2333 681.88 $0.4473 2.24 227.29
Pirate Rogue                
Disciple Vessel $410 $48 0.0207 2.1250 917.50 $0.4469 2.24 229.38
Cobalt Light Frigate $520 $55 0.0183 1.9000 1068.50 $0.4867 2.05 213.70
Ravastra Skirmisher $700 $58 0.0171 1.7143 1316.00 $0.5319 1.88 188.00
Illuminator Vessel $840 $51 0.0198 2.7692 1232.00 $0.6818 1.47 205.33
Javelis LRM Frigate $555 $50 0.0198 2.7500 805.00 $0.6894 1.45 201.25
Kanrak Assailant $840 $65 0.0155 2.1667 1020.00 $0.8235 1.21 170.00
Defense Vessel $600 $33 0.0300 4.5000 1383.75 $0.4336 2.31 345.94
Garda Flak Frigate $635 $41 0.0241 3.8333 1530.00 $0.4150 2.41 382.50
Junsurak Sentinel $720 $44 0.0227 3.2667 1578.13 $0.4562 2.19 315.63
Pirate Reaper                
Purge Vessel $1,290 $198 0.0050 0.5417 840.25 $1.5353 0.65 70.02
Krosov Siege Frigate $1,200 $185 0.0054 0.5417 816.00 $1.4706 0.68 68.00
Karrastra Destructor $1,265 $198 0.0051 0.5333 807.50 $1.5666 0.64 67.29
Pirate Pillager                
Aeria Drone Host $3,080       3067.50 $1.0041 1.00 153.38
Percheron Light Carrier $1,975       2467.00 $0.8006 1.25 176.21
Lasurak Transporter $2,010       2459.00 $0.8174 1.22 175.64
Domina Subjugator $1,040 $260 0.0038 1.0000 932.50 $1.1153 0.90 233.13
Cielo Command Cruiser $765 $191 0.0052 0.6667 1142.50 $0.6696 1.49 190.42
Stilakus Subverter $1,040 $231 0.0043 0.9000 990.00 $1.0505 0.95 198.00
Iconus Guardian $1,445 $361 0.0028 0.5714 2242.50 $0.6444 1.55 320.36
Hoshiko Robotics  $670 $168 0.0060 1.0000 1216.25 $0.5509 1.82 304.06
Serevun Overseer $1,290 $287 0.0035 0.6429 1120.00 $1.1518 0.87 160.00
Destra Crusader $1,285 $68 0.0148 1.9000 1774.38 $0.7242 1.38 177.44
Kodiak Heavy Cruiser $1,180 $66 0.0153 1.8000 1912.50 $0.6170 1.62 191.25
Skarovas Enforcer $1,665 $72 0.0138 1.9167 2145.50 $0.7760 1.29 178.79
Pirate Corsair                
Solanus Adjudicator $2,310 $154 0.0065 0.8333 1589.00 $1.4537 0.69 88.28
Ogrov Torpedo Cruiser $1,520 $68 0.0148 1.8750 935.50 $1.6248 0.62 77.96

 

And I also intend to calculate the effective DPS for each ship by race adjusted by the Damage Modifiers.  Again, thanks for your efforts.

Reason for Karma (Optional)
Successfully updated karma reason!
May 21, 2010 2:33:04 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

bump due to usefullness

Reason for Karma (Optional)
Successfully updated karma reason!
June 9, 2010 5:12:23 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Armor should be accounted for correctly unless theres some crazy mechanic i dont know about.

formula is: (Ships' HP)/((Enemy Ships' Atk Bonus * Enemy Ships' DPS)/(1+(Ships' Armor points * 0.05))

Maybe I could account for mitigation by assuming its maxed out all the time? or look at the opposing dps to see if it maxes it out and then do it. problem is what to do when it's not maxed out and exactly how to fit it in the formula. I'm pretty sure I read that shield mitigation works when shields are down, but that no one really knows what point it takes affect.

Reason for Karma (Optional)
Successfully updated karma reason!
June 15, 2010 6:07:35 AM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

This excel sheet looks quite helpful, but I cannot seem to enter information Sandbox Calc. tab. Or perhaps I misunderstand it's function. Is it supposed to be a calculator as it looks to be? I'm fighting a TEC AI and I'd love to see what I would need to defeat it.

Reason for Karma (Optional)
Successfully updated karma reason!
July 10, 2010 2:28:18 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

I'm sorry I did not respond sooner. It is a calculator and should be able to give you a rough idea of what you would need to match up to a fleet on a ship by ship basis. Strikecraft and capitals are not working at the moment, but those should be fairly easy to judge on their own

To be able to do this, you will need to have the excel version, PDF version wont calculate anything. The white boxes are ones you must enter information into. Do not enter anything into the colored boxes. To fill out the chart correctly, follow these steps:

  1. Underneath the blue Faction box, enter your faction (TEC, Advent, Vasari)
  2. Underneath the blue Ship Type box, enter a ship type from your fleet (eg. Long for a long range frigate). This is easy to mess up as its keyed to pick up certain words and not others. To see exactly how you should phrase it, you can look up the ship type in the Damage Modifiers Chart tab or the Frigate Comparison Chart.
  3. Next, underneath the blue # of ships box, enter how many of that ship you have
  4. the rest of the boxes for now can be ignored
  5. Underneath the chart on the sandbox page is another entry box. follow steps 1-3 for your opponent's ship.
  6. As you type in information, the calculator should instantly re-calculate to see which ship wins that encounter. As such, you can change the information till you get the result you want; For example, by increasing the number of ships you have. Or try giving your self a damage % increase. This represents research or other bonus you might be able to get.
  7. Its best to pick a combination of your ship and your opponent's ship that are counters. For example, you might not have Long range frigates yet, but your opponent is hammering you with them. If you enter the number of long range frigates that your opponent has, you can try a few different ship types till you find your ship type that will be responsible for taking out the long range frigates.

Please remember that this is just to give you a rough idea. I am willing to listen to ideas to make it more detailed, with the understanding that I can never make it a perfect match and probably never better than a rough idea. I am thinking of adding the ability to have a composite fleet comparison, but that will take some work. That would allow me to put strikecraft and capitals in, but as i said, its alot of work. I'd either have to make up some way of assigning ship types to target another ship type, or treat the whole fleet as one big ship vs other big ship.

Reason for Karma (Optional)
Successfully updated karma reason!
July 10, 2010 2:37:19 PM from Sins of a Solar Empire Forums Sins of a Solar Empire Forums

Kinda wish these forums had the auto-email on replies option. I could respond a lot quicker.

Reason for Karma (Optional)
Successfully updated karma reason!
Stardock Forums v1.0.0.0    #101114  walnut1   Server Load Time: 00:00:00.0000328   Page Render Time: