Canuck21 Posted June 2, 2021 Share Posted June 2, 2021 For those of you who are into doing a fair number of Quick Battle scenarios, I have built an Excel Spreadsheet to calculate force parameter values. What this spreadsheet does is build in some random values by using modifiers calculated from a random number generator, which are applied to the parameters: Experience, Motivation, Fitness, Leadership and Head Count. What you can do from this is build a force (human selected - both sides) meeting certain criteria according to what you want out of your forces. It will restrict you from building a "king-kong" type force so you'll have to make selections based on the modifiers that were generated. You may have some tough decisions to make about some of the parameters, depending on the latest "dice roll". Where this has come from is I like to build quick battles which are tiny (by my definition - Coy size for an attacking force is pretty much my maximum), which means that BF's definition of tiny is too large for me. As such, I select the forces myself (if I just select my size and let the AI do it's thing for the other side, they will vastly outnumber me in most cases). So to give me some structure and randomness with the quality of my forces, I will use this spreadsheet to set my parameters with, at the size of force that I want. If I want a very experienced force (let's say, "Crack"), then I may have to give up something somewhere else, such as Leadership values, head count, etc. Also, at the bottom, there is a force ratio calculator for the various types of battles. So if you want an Attack battle, and you want your forces to be between 2 and 3 to 1 in size (points), then you plug the number of points you chose for your forces, plus the multipliers you want to have as an advantage (2 and 3), and the number of points for the other side will be calculated for you. Once you've filled out your force, you can then go in and fill out your opponent's forces using the guide. The requirements will be you'll have to have MS Excel and the most advanced function you'll have to do in it is know how to copy & paste special - values (it tells you how to do that in the sheet). Other than that there are only a few fields to fill in and the rest is done for you. This sheet is really mainly for people who play QB's against the AI, but if you're doing a PBEM or H2H of any kind and want to generate original battles for that, this will enable you to add some randomness to your forces. I will be testing the sheet over the next day or two, so if anyone is interested, I'd be happy to make it available. If anyone would like to play test it, I'd be most appreciative of any feedback. There are no macros in this so viruses will not be an issue. Ok, I hope that makes some semblance of sense. I've been at this since early this morning and my brain is a little as I write this, so if you have questions, fire away below. Thanks for your time . 2 Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.