Give Feedback
0 of 0
About this mod
Patches ballistic weapons and caliber conversion modifications based on ammo type. Values can be set for (Pistol/Rifle) Base damage, out of range damage multiplier, reload speed and on hit data. Requires Excel & FO4Edit
- Requirements
- Permissions and credits
- Donations
Brian's FO4Edit / Excel Ammo Type Weapon Damage Patcher
Patches ballistic weapons based on ammo type. Requires Excel & FO4Edit
Github
Who this is for
Anyone who has way too many weapon mods and wants to quickly normalize damage/range/on hit/reload for all of them based on ammo type
Notes
Bash no longer required to convert the spreadsheet as long as you have Excel or an editor capable of using macro embedded spreadsheets. Use the xlsm spreadsheet and click the button on the right side. You will see the text appear in the window above. Click into this text box then press Ctrl+A and then Ctrl+C to select all text and copy to the clipboard. From here paste the text into the FO4Edit script as described in the tutorial video
Spreadsheet includes all vanilla and dlc ballistic ammo as well as some other mods in my load order. The ammo name comments are for mainly setup for the Armament mod, so items such as 9x19mm and 7.62x51mm are actually .38 and 5mm respectably. Weapons and object modifications changing calibers will not be affected if there is no entry for their calibers in the AmmoList
Known Issues
You entered an incorrect filename
OMOD1 using ammo X beloning to Weapon1 using ammo Y is not patched when ammo X is in the spreadsheet and ammo Y is not
Conflicts with OMODs that do the following
Video Tutorial (does not touch on xlsm macro spreadsheet)
Dependencies
Excel:
Other (Only required if you are using something other than excel):
Installation
FO4Edit Script
Bash Script (Only required if you are using something other than excel)
Usage
Everyone w/ Windows & Excel:
Linux / People without Excel:
License
Patches ballistic weapons based on ammo type. Requires Excel & FO4Edit
Github
Who this is for
Anyone who has way too many weapon mods and wants to quickly normalize damage/range/on hit/reload for all of them based on ammo type
Notes
Bash no longer required to convert the spreadsheet as long as you have Excel or an editor capable of using macro embedded spreadsheets. Use the xlsm spreadsheet and click the button on the right side. You will see the text appear in the window above. Click into this text box then press Ctrl+A and then Ctrl+C to select all text and copy to the clipboard. From here paste the text into the FO4Edit script as described in the tutorial video
Spreadsheet includes all vanilla and dlc ballistic ammo as well as some other mods in my load order. The ammo name comments are for mainly setup for the Armament mod, so items such as 9x19mm and 7.62x51mm are actually .38 and 5mm respectably. Weapons and object modifications changing calibers will not be affected if there is no entry for their calibers in the AmmoList
Known Issues
You entered an incorrect filename
- No idea why it does this... lol. It still works. You will have to delete the ESP if you want to update it though
OMOD1 using ammo X beloning to Weapon1 using ammo Y is not patched when ammo X is in the spreadsheet and ammo Y is not
- It was designed this way. OMODs are not patched if their base weapon isn't
Conflicts with OMODs that do the following
- Receiver grades AND ammo conversions (e.g. Advanced 7.62 Receiver, Powerful 7.62 Receiver), These will end up about the same damage
Video Tutorial (does not touch on xlsm macro spreadsheet)
Dependencies
Excel:
- FO4Edit
- MXPF
Other (Only required if you are using something other than excel):
- BASH (Only if you want to use the xlsx instead of the xlsm):
- bc
- xlsx2csv
Installation
FO4Edit Script
Copy 'FO4 - Brians Weapon Patcher.pas' to 'Fo4Edit/Edit Scripts'
Install MXPF to 'Fo4Edit/Edit Scripts/lib'Bash Script (Only required if you are using something other than excel)
# Download the SH file to Linux or to WSL
chmod +x ./weapons.sh
sudo apt install bc
sudo pip install xlsx2csvUsage
Everyone w/ Windows & Excel:
* Run Excel and disable protected mode
* Edit values and click the button on the right
* Replace the section in the Fo4Edit script same as described in video
* Run Fo4Edit script & save
* Make sure plugin loads last
Linux / People without Excel:
./weapons.sh <path_to_xlsx>
# Output will go to './test.txt' and to stdout
# Copy the output into the FO4 edit script where you see the same values (overwrite them)
# Apply script to records you want in FO4Edit and saveLicense
MIT License
Copyright (c) 2022 Brian Wilson
Permission is hereby granted, free of charge, to any person obtaining a copy
of this software and associated documentation files (the "Software"), to deal
in the Software without restriction, including without limitation the rights
to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all
copies or substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE
SOFTWARE.