New ODF/Excel Tools

[MrVulcan]

Hi folks,

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

The tools may or may not be useful to anyone modding FleetOps since the set up is very different. However, it should work just fine for A1/A2 modding.

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 three Excel workbooks in the download and a documentation file.

1. ODF_Data_Ships
2. ODF_Data_Stations
3. ODF_Data_Weapons
4. 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

 

[Adm_Z]

So this could be used to make a weapon and say, compute the damage base and hit chance concerning all your ships and stations?

 

[MrVulcan]

Exactly

- You would have to set up your Ships Data first (At least the filenames and one other column to identify the ship class)
- Then set up the modifiers on the HitChance worksheet
- List the classes of ships for which you want to modify the hitChance
- Hit run and you should have a list of hitChances for a weapon to use.
- Now set up the weapons table and use the hitChances you calculated on the HitChance worksheet.

This only saves you time and effort if you separate your ships into classes, or races, or some other category. Currently, the hitChance classes are based on the second column of the Ship Data, which is the include file to define the ship class.

Edit: made the instructions a bit more detailed

 

[Adm_Z]

So could this be adapted to add a ship to preexisting lists? Basically, I would want to add a new ship to, say FO, and then list all the weapons already in FO, and then have it add the new ship to all the damagebase and hitchance lists based on their base value and the modifiers the new ship has. (because ships have passives and can be separated into classes)

 

[MrVulcan]

Adm_Z,

Currently, it creates a brand new list based on your ships in the ShipData workbook. If you can list all FO ships in that workbook, then adding a new ship to hitChance lists is straight forward.

I suppose the hard part is making the list of existing ships in the first place. I'm not sure how many there are in FO, especially if you need to list all ships for "replace weapons" too. This might be tedious to set up..

Thinking on it a bit longer, perhaps I can also make the lists feature useful to you without having to import all the ship data... should have an update soonish

 

[Adm_Z]

Thats awesome. And yeah, there are a lot of ships in FO. Every ship has 6 odf's for each rank, + another set for second avatars, + duplicates for replaceweapons... I think tedious is an understatement. Then, when on average ships have three weapons each, multiplied by 6 ranks and possibly avatars..... yeah its a lot. It explains why FO has over 9,300 odf's.:Y

 

[MrVulcan]

Updated to V1.1


Changes:
- Append new ships to existing lists (hitChance, damageBase, etc..)
- 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.


Link to the updated file: Excel-ODF Tool Set.


I bet you could set up the ships worksheet to automatically compute the avatars/rank/etc for your own ships. Just a matter of modifying the values or weapon references Maybe this will be useful in FleetOps after all, heheh

 

[Adm_Z]

I am definitly going to need to learn how to use this. :Y Awesome work Mr. V.