Excel/ODF Tool Set

[Mr. Vulcan]

posted on October 12th, 2012, 4:42 pm

Last edited by Mr. Vulcan on October 18th, 2012, 4:10 am, edited 2 times in total.

Hi folks,

I'm releasing a set of tools for batch creation of ODFs. Download here

The tools should work just fine for A1/A2 modding. To use in FleetOps, some setup may be required (nothing too hard).

The tools allow you to enter all your ODFs and ODF commands into Excel, edit values directly or use formula to compute the various ODF specs, and batch export everything into your addon folder. A basic "import" functionality exists for reading in data from your existing ODFs.

There are additional tools to help with computation of

- system hitpoints
- weapon hitChance lists (per ship custom hitChance, baseDamage, etc)
- weapon/ship statistics (which ships use this weapon, which ships belong to this class, etc)

Quick screens:







There are two Excel workbooks in the download and a documentation file.

1. ODF_Data_Units
2. ODF_Data_Weapons
3. Readme.pdf

This is the initial release, so bugs are to be expected. You can always catch me here on the forums for any bug reports or feature requests.

Cheers,
Mr. V

Updated to V1.1

Changes:
- Import ordnance ODFs along with weapon ODFs with no extra set up
- No need to set up all column headings (commands). Extra commands will be appended at the end of the second row.
- Append new ships to existing lists (hitChance, damageBase, etc..)

posted on October 12th, 2012, 5:11 pm

these sound good would you mind if we tweak these to be more usefull for fo?

posted on October 12th, 2012, 8:23 pm

these sound good would you mind if we tweak these to be more usefull for fo?

Not at all, please do

posted on October 13th, 2012, 8:38 pm

well i would but my excel has corrupted if/when i fix it i'll look into it

posted on October 18th, 2012, 4:11 am

Updated to V1.1

Changes:

- Import ordnance ODFs along with weapon ODFs with no extra set up.
- No need to set up all column headings (commands). Extra commands will be appended at the end of the second row.
- Append new ships to existing lists (hitChance, damageBase, etc..)

Link in the original post

Mr. V

posted on July 8th, 2013, 11:02 am

More than welcome to expand and tweak. If You need to ask me anything about the scripts, drop me a msg. Cheers

posted on July 8th, 2013, 11:30 am

You just responded to a spambot...

posted on July 8th, 2013, 11:37 am

yeah it nearly identically copied a post 4 posts above it by blade

posted on July 8th, 2013, 1:51 pm

My bad, that's what happens when you get over excited and here I thought someone wanted to look at the scripts. lol