Need help with something complex.
I've been searching for hours and hours and I just don't know exactly what to look for. I created a spreadsheet in excel for a video game that can calculate almost anything in game. And I wanted to take it to a whole new level and make it into a website for people who don't have excel and just making it 10x easier and more accessible to use. I just don't know where to start.
Pretty much the idea is. Person #1 loads the website, he chooses his Hero that he wants to test and an enemy hero he wants to test his damage against. So when he selects his Hero a list of statistics appear that belong to that hero, and when he chooses an enemy hero a list of statistics then appear for that hero, one on the left one on the right for example. And then he inputs the items each hero has and during all this time the Spells for your hero update. The spell would be calculated this way, BaseDmg+[Total Power*(Ratio for that spell)]-(enemy heroes armor). Also all the heroes statistics would change when you select what level you are.
So I want the spells to update depending on the enemy's hero statistics. if he changed the enemy hero, new statistics would show up and the spell damage would be updated again. In excel this is easy because I would write all the values of each hero and then with VLOOKUP the stats would change when the person would change the hero, and the formula's would calculate depending on the armor from the VLOOKUP+Item bonus.
Can anyone point me in the right direction? I hope I made some kinda sense, thank you for reading this.