Deleted User - 848891818
Guest
Hello Community,
in the last few months I always created an Excel Tool when I wanted to get more information about whats going on, or when i wanted to have a forecast.
You can download it and an instruction here:
https://github.com/Kis4m3/Tribalwars-Planner
It has the following features:
Not all settings could be tested properly.
Therefore times could vary a few seconds to the actual times and i am not sure if all macros are working properly
I'd be verry happy about feedback and suggestions for improvement.
in the last few months I always created an Excel Tool when I wanted to get more information about whats going on, or when i wanted to have a forecast.
You can download it and an instruction here:
https://github.com/Kis4m3/Tribalwars-Planner
It has the following features:
- Settings: In the settings page you can translate between german and english and insert all the relevant settings of the world you are using it for
- Construction Planner: Optimal expansion of a village can be planned (including troops). But you can also use it to design a balanced account manager template. If you enter the current information of a village (buildings, troops and rests), all further buildings and recruitment (via the percentage utilization of the barracks/stall/workshop) can be planned. -> Good for early game
- Formatting: Allows the "Construction Planner" to be exported as a table formatted in DS
- Farm Planner: Calculates the raw material production and the number of lcavs needed for the farm
- Attackplanner_Sendingtime: Here the sending times of several villages of origin to several target villages for one arrival time can be determined in a matrix. The sending time is colored on the basis of a time frame entered
- Attackplanner_Traveltime: Here the transit times from several villages of origin to several target villages can be determined in a matrix. The travel time is colored based on a time frame entered
- Command Planner: Lets you plan individual commands and export them for IGMs/ notepad
- Noble Planner: Here it is calculated under input of the mines and recruitment buildings, as well as the village type (Off, Dualdeff, Flexdeff), as well as the current and the target AGs, when the Ressources for the storage for the desired AGs are available. -> Good for the Midgame
- Recruiting Planner: Simple calculation of construction times and costs of troops depending on the barrack/stall/workshop level.
- Village planner: Determination of villagers and points of a village
- Traveltime Calculator: Calculation of the transit time, as well as the time of dispatch or arrival and return
- Bashpoint Calculator: Here you can calculate how much Offbash or Deffbash there is for the losses of the attacker or defender
- Watchtower: Here you can calculate when attacks are detected by a watchtower. It is possible to view several watchtowers and commands at the same time
- Tech times: Here you can see the research times and costs depending on the forging stages
- Amortization Mines: Calculate how long it takes for the cost of one level of all mines to be recouped by increasing production.
- Ram table: Here you can see the decrease of the rampart steps depending on the ram tech - for explanations see other thread
- Catapult table: Here you can see how many building levels are destroyed with how many katas. Condition: All katas survive. This table is tech dependent
- Catapult table_surviving: Here you can calculate the number of catapults and determine the destruction.
- Moral Calculator: Basically the same as the Moral Calculator in the Simulator - but you can see more information here. Unfortunately there are some rounding errors with a server runtime of less than 125 days
- Farm Limit: Here you can simulate the combat power when the farmrule is activated.
- Simulator old: A simulator for the old fighting system (without bow!).
- Build times wall: Here you can calculate the build times of the wall for the set world speed per level and cumulated for all village headquarter levels and format them as a table.
- There are some more Sheets with data you need for the Tools
Not all settings could be tested properly.
Therefore times could vary a few seconds to the actual times and i am not sure if all macros are working properly
I'd be verry happy about feedback and suggestions for improvement.