OpenXcom Forum

Modding => Released Mods => The X-Com Files => Topic started by: spawi on December 27, 2020, 08:43:37 am

Title: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: spawi on December 27, 2020, 08:43:37 am

Hey Folks, check out this tool I just wrote:

https://github.com/konrad-jamrozik/oxcetools

You can use this to analyze, using Excel, weapon stats.

Here is an example (with SPOILERS), of stats of all (<- spoilers!) pistols in game, sorted by aimed accuracy:

https://github.com/konrad-jamrozik/oxcetools/blob/main/media/pistols_by_aimed_accuracy.png

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: Finnik on December 29, 2020, 11:04:47 am

Can we have another tool to convert things back to .rul? =)

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: spawi on May 15, 2021, 09:54:22 am

Gladly, but first I need to find the time and motivation ;)

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: pedroterzero on May 18, 2021, 03:18:32 pm

A couple of weeks ago I was working on including this feature in a future version of my vscode extension. I have an alpha that does two way (rul => csv and csv => rul), it's not out yet though:

(https://i.imgur.com/Ve2ffjg.gif)

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: spawi on May 19, 2021, 12:54:50 am

Whoa, looks awesome!

Btw is your VSCode extension available to fork and edit?

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: pedroterzero on May 21, 2021, 11:45:59 am

Yep, it's here: https://github.com/pedroterzero/oxce-yaml-helper

I had to pick a license first, I had not done so yet ;)

Title: Re: [Tool] Script to read items data into .csv, for analysis with Excel.
Post by: spawi on May 23, 2021, 03:12:47 am

Quote from: pedroterzero on May 21, 2021, 11:45:59 am

Yep, it's here: https://github.com/pedroterzero/oxce-yaml-helper

I had to pick a license first, I had not done so yet ;)

Awesome, thx! :)