Avcom Simulator

The Avcom Simulator is designed to test the game Swashbuckling mechanics (Avatar Combat or Avcom). The sheet runs in Excel an allows the user to enter variables such as Offense and Damage resistance.

The sheet will then run a 1v1 combat tracking to hits, damage and guard regen until one side or the other dies. Various statistics are then displayed.

Simulations can either be run singularly or in a batch using the buttons at the top of the screen. Batch simulations output the results to a Log table in a separate tab.





How to use the simulator

 * Download and unzip the file
 * Open the file with MS Excell 2003 or later
 * Ensure macros are enabled for the sheet
 * Enter the required variables in the peach input fields (default entries are shown below)
 * Click the buttons to run a simulation
 * For a single fight simply click the Single button and read the results
 * For a batch click the batch button then enter the number of fights when promoted, read the results in the log.

Default Variables
Set for a Level 50 character with no skills and a Light weapon first class
 * Guard 350
 * Guard Regen 15/sec
 * Dodge 86
 * Parry 134
 * Offense 1100

Compatibility

 * MS Excel 2003 - Untested
 * MS Excel 2007 - Working
 * MS Excel 2010 - Untested
 * Open office - Untested
 * Google Documents - Untested

Feedback
Please leave feedback on the discussion page

Current Version
Avcom Simulator.xlsm