New ODF/Excel Tools

The best Modding forum in the Armada community, some of the best modders come here.

Moderators: MrVulcan, thunderchero

Post Reply
User avatar
MrVulcan
Site Administrator aka Fleet Admiral
Site  Administrator aka Fleet Admiral
Posts: 659
Joined: Fri Apr 25, 2003 2:00 am
Location: TO CA

New ODF/Excel Tools

Post by MrVulcan » Fri Oct 12, 2012 12:29 pm

Hi folks,

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

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.

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:

Image

Image

Image

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
Last edited by MrVulcan on Wed Oct 17, 2012 11:59 pm, edited 2 times in total.

User avatar
fuller
Cadet 4th Year
Cadet 4th Year
Posts: 137
Joined: Fri Sep 23, 2011 2:00 am

Post by fuller » Fri Oct 12, 2012 1:21 pm

Nice work Mr.V, great idea.

User avatar
MrVulcan
Site Administrator aka Fleet Admiral
Site  Administrator aka Fleet Admiral
Posts: 659
Joined: Fri Apr 25, 2003 2:00 am
Location: TO CA

Post by MrVulcan » Wed Oct 17, 2012 11:57 pm

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.

Shadow2Lead
Cadet 1st Year
Cadet 1st Year
Posts: 2
Joined: Thu Feb 25, 2016 1:34 am

Re: New ODF/Excel Tools

Post by Shadow2Lead » Thu Feb 25, 2016 5:15 pm

I've been working on adding the Federation back into Star Wars Fleet Command since ST vs SW 2 was never completed and in an effort to figure out balancing have been inputting all the SWFC odfs into an excel document one odf at a time. But this looks like it would be both easier to use and far more detailed than my rather limited aims. Any chance that this is in the downloads section somewhere I couldn't find it or you could reupload it since the rapidshare link seems to have died?

User avatar
MrVulcan
Site Administrator aka Fleet Admiral
Site  Administrator aka Fleet Admiral
Posts: 659
Joined: Fri Apr 25, 2003 2:00 am
Location: TO CA

Re: New ODF/Excel Tools

Post by MrVulcan » Fri Feb 26, 2016 12:14 pm

Sure thing. I am bit busy for the next two days, but can resurrect the tool and upload it on here. [edit: found the tool, uploaded]

ODF-Excel Tools

I have made extensive changes to the tool since version 1.1, so I will also upload the new version once I update the documentation. You can use this one in the meanwhile.

Cheers!

Shadow2Lead
Cadet 1st Year
Cadet 1st Year
Posts: 2
Joined: Thu Feb 25, 2016 1:34 am

Re: New ODF/Excel Tools

Post by Shadow2Lead » Sun Feb 28, 2016 7:54 pm

Great, thank you very much!

User avatar
galac
Cadet 3rd Year
Cadet 3rd Year
Posts: 97
Joined: Thu Aug 29, 2013 2:00 am

Re: New ODF/Excel Tools

Post by galac » Mon Feb 29, 2016 9:31 am

MrVulcan wrote:Sure thing. I am bit busy for the next two days, but can resurrect the tool and upload it on here. [edit: found the tool, uploaded]

ODF-Excel Tools

I have made extensive changes to the tool since version 1.1, so I will also upload the new version once I update the documentation. You can use this one in the meanwhile.

Cheers!

(Off topic) MrVulcan did you get my message??

Post Reply

Who is online

Users browsing this forum: Bing [Bot] and 16 guests