Friends of the B&C community. After countless tiresome hours of spreadsheet nonsense I bestow upon thee a spreadsheet to simplify the gun customization process. The link is HERE. However, be warned. First, the spreadsheet is still modifiable as I cannot protect particular cells to keep the formulas used from being edited; so please use/select only the drop boxes in the "workbench" tab. Secondly, there is a known discrepancy with the calculation from my spreadsheet to the actual calculation of attributes in the B&C gun customization area. The devs are aware of the discrepancy and are looking into it. So for the time being use the spreadsheet for more of a guide rather than an actual verbatim gun creation tool.
Now, for a little tutorial... Users want to begin by clicking the above link (duh). When the page opens to GoogleDrive's GoogleSheets you will notice four tabs: First, is the "Weapons" tab where users can view all the weapons and their corresponding attributes in B&C. Second, is the "Attachments" tab where users can view all the gun attachments and their corresponding attributes. Third, is the "Gear" tab where users can view all wearable gear items (helmets, uniforms, and vests) and their attributes. Finally, there is the "Workbench" tab. This is where the magic happens. You will see a table that can be modifiable. PLEASE only modify/change cells in column "B". At the far left of column "B" is a little drop-down menu that will display a list of the current category's items. Select the desired item and you will notice the attribute points auto-populate in the cells to the right. At the bottom of the gun creator are the total attribute points for that gun. (NOTE: This is where the discrepancy is. The devs are looking into B&C to get this balanced. Yet, the spreadsheet still serves its purpose.) Below this is where users can select their desired gear. Attribute points are totaled beneath this as well. And finally, beneath this, are the total attribute points for both the gun and the gear.
I hope users of the B&C community find this spreadsheet helpful in creating the best set-up for their operators. Users, PLEASE PLEASE PLEASE take care not to edit any cells in this spreadsheet other than the cells used to "select" weapons, attachments, and gear in the sheet labelled "Workbench". There is no protection set in this document simply because it will only allow users to view and not select (edit) their desired get-up.
Community members, feel free to contact me with any misinformation in the spreadsheet.
Also, I plan to add more guns, attachments, and gear as more updates are released.