NeeP
12-23-2013, 03:31 PM
XenoBot Manager
So since EpicBotter doesn't seem to exist anymore and I was really waiting for this XenoBot Manager I thought why not team up the forum people and make one Excel table where people can organize their money maker chars.
I always spend a considerable amount of time in checking how much stamina each char has, which char to put where exp, is the bank balance ok or should I give some more cash, which chars are currently on etc. 12 money maker accounts aren't so easy to manage. So this is what I try with this Excel table: calculating and displaying as much as possible to get an overview and to make it easier to decide which char to put where (maybe also additionally as time table) and to generaly make it easier to calculate the income of every char.
The problem is this Excel requires some formulas since it should auto calculate things like Stamina based on what you input and I don't have any clue how to solve this. So I ask the forum community to help with this "Xenobot Manager" so everyone can profit of it.
How does it currently look like?
I've started it in excel since I think it is the easiest way. Ofc if someone could make it exe application it would be also cool. Currently it looks like this:
http://i.imgur.com/STFXQVr.png?1
Where do you need help?
-Stamina calculator built-in that can predict the current stamina and when it reaches full stamina, it should count down the stamina like tibia does, meaning maybe the dropdown list at "Status" should trigger the stamina calculator like this: Online = calculator counts down the stamina as the char is exping and vice versa: Offline = calculates the time that is needed to regain stamina
(Optional: idk if that is possible and how but perfect would be that the Excel macro gets the online character list of tibia.com and decides itself if a char is on that list and thus online and exping or not)
Example: Character1 is put exp, I select "Online" from the Status dropdown menu. Excel slowly counts down the stamina as in Tibia it goes down the same time. Once the char is logged out and I update the Excel table by selecting "Offline" at the corresponding char, the stamina slowly grows again.
- Spawn checker: Two chars which are marked as online can't be in the same hunting ground. If the Excel table notices 2 chars which are both marked as online and in the same location, it should "warn" the user by a pop-up or blinking window or w.e.
- Spawn proposer: Spawns are sorted into level range categories. The spawn checker checks the level of a char and proposes a hunting ground of the matching category but also considering the spawn checker (if the spawn is already occupied or not). If the spawn is free it is ok, else propose another spawn which is made for the char's level range.
Example: Character1, lvl 8 knight. The Excel tool should propose Thais north trolls, since trolls is in the spawn category lvl 8-15. Now it sees Character2 is already signed up for that place in the excel tool before. Excel proposes Ab'dendriel trolls cuz no char in the list has it as written in the "Location" of the table.
- Bank account calculator: when you change the "Status" of a char to online, it should calculate the current bank balance using a given cash rate (which you can get from HUDs and maybe imported from a log file which a lua script puts out) and the hunting time (the time delta between this moment and the moment when you flipped the switch and selected "Online"). Maybe also making a warning when to refill the cash (if you waste hunt) so you never run out of cash.
What do I get for helping?
Unlike EpicBotter team I don't want to sell that so it will always be an open source project where everyone who needs can download this Xenobot Manager. By helping you improve it and also you can profit of the help of others so in the end you have a working tool that helps you in managing your characters.
Current Version:
Hope this teamwork can be done :D
So since EpicBotter doesn't seem to exist anymore and I was really waiting for this XenoBot Manager I thought why not team up the forum people and make one Excel table where people can organize their money maker chars.
I always spend a considerable amount of time in checking how much stamina each char has, which char to put where exp, is the bank balance ok or should I give some more cash, which chars are currently on etc. 12 money maker accounts aren't so easy to manage. So this is what I try with this Excel table: calculating and displaying as much as possible to get an overview and to make it easier to decide which char to put where (maybe also additionally as time table) and to generaly make it easier to calculate the income of every char.
The problem is this Excel requires some formulas since it should auto calculate things like Stamina based on what you input and I don't have any clue how to solve this. So I ask the forum community to help with this "Xenobot Manager" so everyone can profit of it.
How does it currently look like?
I've started it in excel since I think it is the easiest way. Ofc if someone could make it exe application it would be also cool. Currently it looks like this:
http://i.imgur.com/STFXQVr.png?1
Where do you need help?
-Stamina calculator built-in that can predict the current stamina and when it reaches full stamina, it should count down the stamina like tibia does, meaning maybe the dropdown list at "Status" should trigger the stamina calculator like this: Online = calculator counts down the stamina as the char is exping and vice versa: Offline = calculates the time that is needed to regain stamina
(Optional: idk if that is possible and how but perfect would be that the Excel macro gets the online character list of tibia.com and decides itself if a char is on that list and thus online and exping or not)
Example: Character1 is put exp, I select "Online" from the Status dropdown menu. Excel slowly counts down the stamina as in Tibia it goes down the same time. Once the char is logged out and I update the Excel table by selecting "Offline" at the corresponding char, the stamina slowly grows again.
- Spawn checker: Two chars which are marked as online can't be in the same hunting ground. If the Excel table notices 2 chars which are both marked as online and in the same location, it should "warn" the user by a pop-up or blinking window or w.e.
- Spawn proposer: Spawns are sorted into level range categories. The spawn checker checks the level of a char and proposes a hunting ground of the matching category but also considering the spawn checker (if the spawn is already occupied or not). If the spawn is free it is ok, else propose another spawn which is made for the char's level range.
Example: Character1, lvl 8 knight. The Excel tool should propose Thais north trolls, since trolls is in the spawn category lvl 8-15. Now it sees Character2 is already signed up for that place in the excel tool before. Excel proposes Ab'dendriel trolls cuz no char in the list has it as written in the "Location" of the table.
- Bank account calculator: when you change the "Status" of a char to online, it should calculate the current bank balance using a given cash rate (which you can get from HUDs and maybe imported from a log file which a lua script puts out) and the hunting time (the time delta between this moment and the moment when you flipped the switch and selected "Online"). Maybe also making a warning when to refill the cash (if you waste hunt) so you never run out of cash.
What do I get for helping?
Unlike EpicBotter team I don't want to sell that so it will always be an open source project where everyone who needs can download this Xenobot Manager. By helping you improve it and also you can profit of the help of others so in the end you have a working tool that helps you in managing your characters.
Current Version:
Hope this teamwork can be done :D