RPG Leveling System

Using an Excel spreadsheet, this project was to create a simulated action RPG leveling system which comprised of three main parts. The first part was to create three different character classes and three different enemy classes which have base statistics and resultant statistics. The resultant statistics needed to be linked with the base statistics in such a way that if a base stat changed, it would change the resultant stat. Also, there had to be a simulated 'pit fight' between any of the characters or enemies where their statistics would determine who would win. The three character classes used were Warrior, Archer and Wizard, while the enemy classes were Spider, Demon and Dragon. The base stats of each were Strength, Agility, Dexterity and Defense with the resultant stats being Health, Max Carry Weight, Damage per Second and Speed. Below is an image of part one:

The second part of the project was to create a hypothetical projectile for each character and show different attributes for each one using graphs. Each projectile needed to have a simulated path, velocity, blast radius and damage over distance. Below are the graphs for each character in comparison to one another to show which is better in each category:

The third part of the project consisted of expanding further and going more in depth into the stats of each character by introducing an element of chance into the pit fights. The pit fights were also extended to five rounds with the characters and enemies health stats carrying over into each round. The new chance stats which were added consisted of an accuracy bonus, dodge chance, critical hit chance and critical damage multiplier. Below are the images displaying the new stats and the five round pit fights: