I want to create a small site for the guild in the game Albion Online.
What is the point. Because this is an online game with a bias on pvp, very often small groups of people are formed in the guild to go to the location and hunt other players in order to take possession of their things. After that, all things are sold and the proceeds are divided into all participants in the event. Because very often it can last 3-4 hours, during this time there is a trickle of people, which makes it difficult at the end of the trip to calculate who should pay what amount, because someone was from beginning to end, and someone was an hour .
There is an excel table for this, but I want to try to make everything even more convenient and beautiful. I want anyone to be able to go to the site, find the event by the date or by the name of the chest and see how much is due to him.
I also want to add a function in which all these amounts that each participant in the trip were summed up, because hiking is frequent and sometimes inconvenient to look for a person to give him money for several trips at once.
I want the player to enter his nickname or find it on the list and see how much money he has accumulated and for what dates.
I will attach the excel file I am currently using.
It would be cool to come up with a solution for this, if it does not require large expenses.
Waiting for your suggestions.