Search the Community
Showing results for tags 'spreadsheet'.
Found 2 results
I am working on a spreadsheet of all stock and mod weapons that I have. Unfortunately there are tons of them, and typing in all these values by hand is quite a pain. I figured there has to be a way I can extract data from converted config.bin files for each weapon. (Spreadsheet would parse through the *.cpp files -- somehow - I don't know how yet). So where I am stuck is... how do I find these values in the config.bin/.cpp (converted) file for example the Khaybar? The values I have used in the spreadsheet are screenshotted, using the ACE virtual arsenal. Where is Range defined? Where is Impact defined? Where is MIL and MOA accuracy defined? Where is weight kg/lbs defined? Where is the ammo type defined? Where is the muzzle velocity in meters/second and feet/second defined? Where is barrel twist and length defined? displayName="$STR_A3_CfgWeapons_arifle_Katiba_F0"; gives me the weapon name, but not in a user-friendly way. How can I find that? Lastly, do any of these numbers have to be multiplied by another number to get the "true" representative number? For example, I see dispersion is for example 0.00145 You'll see in the screenshot below the cheap way I have to figure out range/impact by placing a grid of 10 squares over the graph bars, then deduce from that.
Last year I created a calculator in spreadsheet form to make the WW4 Extended infantry armor and ammo data more precise. While it's still not perfect is quite a good approximation to how the synergy between armor and ammunition works in-game. You can view the calculator here: https://docs.google.com/spreadsheets/d/1M5rf--TbuvFtRhTt2rOsluyEBiPbVOU_ZNyj3wyqPP0/edit?usp=sharing You should be able to edit the first rows (green colored) from the Armor data and Ammo data sheets to test it out. You should also be able to make a copy to your own Drive account, so you can keep tinkering with all this. Or you can download it as xlsx file to use it offline: https://drive.google.com/open?id=0By2CaodBQ84GRldBb3BvSGdRN1U You can open this file with Microsoft Excel or LibreOffice Calc. Hope this helps others mod makers around here.