Author Topic: how to export spreadsheet of unit bonuses?  (Read 3624 times)

Offline superking

  • Hero Member Mark III
  • *****
  • Posts: 1,205
how to export spreadsheet of unit bonuses?
« on: August 24, 2010, 10:52:07 am »
Hi,
sorry if this is obvious somewhere, but I recall chris mentioned a key that makes AI war export an up to date spreadsheet of unit statistics, including the bonus damages etc of each unit. what key is that? and what directory does it export to?
thanks

Offline x4000

  • Chris McElligott Park, Arcen Founder and Lead Dev
  • Arcen Staff
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,651
Re: how to export spreadsheet of unit bonuses?
« Reply #1 on: August 24, 2010, 11:11:48 am »
It's in the controls.txt explanation.  But, basically, you hit F3 to open the debug menu, then hit Ctrl+Shift+F8 and it will immediately exit the program, dumping some spreadsheets, etc, into the Data folder next to your Save folder.

I think there is a bug in 3.188 causing it to crash when trying to generate this, though -- not sure.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline carlosjuero

  • Full Member Mark III
  • ***
  • Posts: 211
Re: how to export spreadsheet of unit bonuses?
« Reply #2 on: August 24, 2010, 12:31:29 pm »
Will post in crash thread on this but there does indeed seem to be a problem w/ 3.188 - just crashed when trying to dump the data.

It's in the controls.txt explanation.  But, basically, you hit F3 to open the debug menu, then hit Ctrl+Shift+F8 and it will immediately exit the program, dumping some spreadsheets, etc, into the Data folder next to your Save folder.

I think there is a bug in 3.188 causing it to crash when trying to generate this, though -- not sure.

Offline Dragon

  • Full Member Mark III
  • ***
  • Posts: 218
Re: how to export spreadsheet of unit bonuses?
« Reply #3 on: August 24, 2010, 07:51:44 pm »
Ahhh, but that is just a text file, not a spreadsheet.....

On a related note, do you think there is any chance that you could put something in game, like a setting, or a hold-down key, that would change the win/loss percentage numbers into showing the raw damage multipliers?

Offline x4000

  • Chris McElligott Park, Arcen Founder and Lead Dev
  • Arcen Staff
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,651
Re: how to export spreadsheet of unit bonuses?
« Reply #4 on: August 25, 2010, 11:58:36 am »
Ahhh, but that is just a text file, not a spreadsheet.....

It's an excel xml file, actually.

On a related note, do you think there is any chance that you could put something in game, like a setting, or a hold-down key, that would change the win/loss percentage numbers into showing the raw damage multipliers?

It's super low on my priority list, but potentially at some point.  Here's why: http://arcengames.com/mediawiki/index.php?title=AI_War_-_Strong_Vs_Weak#Raw_Bonuses
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline Dragon

  • Full Member Mark III
  • ***
  • Posts: 218
Re: how to export spreadsheet of unit bonuses?
« Reply #5 on: August 26, 2010, 01:07:56 am »
Oh, heh, for some reason my computer is set to open up xml files with my text editor, and I didn't even realize it, so I just thought it was a text file....  Even though I have extensions shown....  Oh well...

Opening it up in Open Office Calc doesn't work though....  Know of any free spreadsheet programs that might do the trick?


As far as the link to why showing just the multiplier numbers is bad, I do agree with that.  But at the same time, the part about them being misleading in some cases, specificly:
"How the ships perform if the player uses any tactics other than just running the two groups at one another. "
Is why I would love to have a way to see the bonus damage in game, because I do like to use tactics, and to tell my ships to attack stuff, and I DON'T want to select the entire group and tell them to attack the raid starships, when most of them do low damage.  Knowing that fighters do bonus damage means that I can select just them, and tell them to attack.  Since starships pretty much don't have a useful strong versus week, that is the most useful place where being able to see bonus damage would be handy.  But other things...

For example, if I have fortresses, and Bombards together, and a bunch of ships are heading wards me, if I start to micro, the bombards are listed as having a high percentage to frigates, but they actually do half damage, while they do full damage to bombers, and have a lower percentage.  So it's better for me to have my fort's shooting the frigs and the bombards shooting the bombers.  Someone that doesn't micro isn't going to care about that, but someone that does.....  Well, personally, I think that seeing the damage bonuses is mainly a micro thing...  And while I know you don't like micro, it's sometimes fun to micro battles, so as to feel like you are actually commanding the fleet and stuff.

*shrug*

All in all, I realize that it's not all that important, but it would be cool....  Or some other way to micro so you can tell your ships "this is an important target, if you have a high bonus, shoot it, if not, don't".  Being able to see bonus numbers and then have the player do that seems the easiest way to me, but I would be perfectly happy if I could "select" a hostile unit type from the scout bar, and then see a listing of all the types I have in system, and how well they will do against that type, compared against each other, rather then compared against what they are shooting at.  Then we could just select the top few, or maybe some in the middle if the top few are already shooting more important stuff, and set the "high priority targets" kind of like if you right click on a target that type becomes important.....
« Last Edit: August 26, 2010, 01:23:11 am by Dragon »

Offline superking

  • Hero Member Mark III
  • *****
  • Posts: 1,205
Re: how to export spreadsheet of unit bonuses?
« Reply #6 on: August 26, 2010, 06:18:20 am »
I just wanted to figure out what missle turrets are good for  :)

Offline RCIX

  • Core Member Mark II
  • *****
  • Posts: 2,808
  • Avatar credit goes to Spookypatrol on League forum
Re: how to export spreadsheet of unit bonuses?
« Reply #7 on: August 26, 2010, 08:10:48 pm »
Their main use is shooting at bombers; they're the only turrets that don't fall to pieces in the face of a bomber wave. I still think they could use a boost to their anti-bomber-ness, but that's another topic...
Avid League player and apparently back from the dead!

If we weren't going for your money, you wouldn't have gotten as much value for it!

Oh, wait... *causation loop detonates*

Offline x4000

  • Chris McElligott Park, Arcen Founder and Lead Dev
  • Arcen Staff
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,651
Re: how to export spreadsheet of unit bonuses?
« Reply #8 on: August 26, 2010, 09:01:37 pm »
I believe those spreadsheets can be opened in openoffice, but you may have to open them in a certain type of format.  It's not the newer Office 2007 xml format, it's the older office 2003 xml format, if that helps.  At some point I'd like to switch it, as the newer 2007 format is certainly less verbose and a lot cleaner in general, but these things take time.  The excel 2003/2007 viewer, which is free from microsoft, would also definitely open them if you want.

In terms of having a hotkey to toggle them on in-game, you do make good points.  Remind us after the porting, if you like, and we'll see what we can do. ;)

One of the things I plan to do after the porting is also revamping turrets quite a bit in general, making them larger, stronger, (and fewer) and a lot more specialized.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline RCIX

  • Core Member Mark II
  • *****
  • Posts: 2,808
  • Avatar credit goes to Spookypatrol on League forum
Re: how to export spreadsheet of unit bonuses?
« Reply #9 on: August 26, 2010, 09:27:30 pm »
One of the things I plan to do after the porting is also revamping turrets quite a bit in general, making them larger, stronger, (and fewer) and a lot more specialized.
Again? yay :)
Avid League player and apparently back from the dead!

If we weren't going for your money, you wouldn't have gotten as much value for it!

Oh, wait... *causation loop detonates*

Offline x4000

  • Chris McElligott Park, Arcen Founder and Lead Dev
  • Arcen Staff
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,651
Re: how to export spreadsheet of unit bonuses?
« Reply #10 on: August 26, 2010, 09:30:49 pm »
Did I already do that at some point in the past?  I don't recall.  I remember adding more turrets, etc.  But one thing I notice lately is that people ALWAYS build these in groups of 5+, etc.  That just makes the battlefield harder to parse, slows down the simulation, and makes it harder to find them to pause them when they are being rebuilt and sucking down your economy, etc.

I figure I'll up their attributes and costs by 5X, down their ship cap by the same amount, and then just generally make them more specialized as kind of a separate thing.
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline RCIX

  • Core Member Mark II
  • *****
  • Posts: 2,808
  • Avatar credit goes to Spookypatrol on League forum
Re: how to export spreadsheet of unit bonuses?
« Reply #11 on: August 26, 2010, 09:49:27 pm »
Waaay back in early 1.x or 2.x days you pumped them up because they weren't really all that powerful.

More specialized would be good; pleeeeeease make missile turrets anti-bomber :)
Avid League player and apparently back from the dead!

If we weren't going for your money, you wouldn't have gotten as much value for it!

Oh, wait... *causation loop detonates*

Offline x4000

  • Chris McElligott Park, Arcen Founder and Lead Dev
  • Arcen Staff
  • Zenith Council Member Mark III
  • *****
  • Posts: 31,651
Re: how to export spreadsheet of unit bonuses?
« Reply #12 on: August 26, 2010, 09:52:39 pm »
Waaay back in early 1.x or 2.x days you pumped them up because they weren't really all that powerful.

Oh, that's right. :)  Good memory!  I doubt few around here would recall that, and it certainly wasn't at the top of my mind, either.

More specialized would be good; pleeeeeease make missile turrets anti-bomber :)

Well... wait, but frigates and missiles and general are no longer the bomber specialists: that's fighters since the triangle was reversed months ago.  So really it should be the short-range turrets that do that, eh? ;)
Have ideas or bug reports for one of our games?  Mantis for Suggestions and Bug Reports. Thanks for helping to make our games better!

Offline superking

  • Hero Member Mark III
  • *****
  • Posts: 1,205
Re: how to export spreadsheet of unit bonuses?
« Reply #13 on: September 04, 2010, 10:47:18 am »
lasers, with their 100% hit rate, would be the more logical anti-bomber

Offline Fox Soul

  • Full Member Mark II
  • ***
  • Posts: 156
  • [color=pink]Cookies![/color]
Re: how to export spreadsheet of unit bonuses?
« Reply #14 on: September 04, 2010, 08:33:59 pm »
Why not go back to our roots and see what we used to do for bomber defense?

http://www.youtube.com/watch?v=1fsIXmdIa4I
AI War - A good offense is a good defense.