top of page
Technical Gameplay and Systems Designer
Back to Portfolio
Battle of Britain Dog Fight Simulator
I made this tool in one week as a proof-of-concept for real-time battle simulation in Excel. The tool features a selection of planes, guns, bullet types, battle FOV, etc. to create realistic battle statistics in real-time.
The tool uses over 1000 lines of VBA code to drive time simulations and battle calculations.
The battle can be modified via attack POV, the distance between the two fighters, the angle of attack, and the spread range of the gun to derive the accuracy of each shot per bullet.
There are 3 bullet modifiers:
- Burn deals damage over x amount of seconds
- Pierce has the chance to hit multiple areas of the plane
- Shred takes off an extra x amount of armor
The tool calculates which area of the plane has been hit depending on the angle of attack and POV, tracks separate fuselage and wing HP/armor, and can provide real-time damage output and death specific to what area of the plane has failed.
bottom of page