i'm gonna let you guys handle this. I saw MATH and ran for the hills
Still love this calc though.
i'm gonna let you guys handle this. I saw MATH and ran for the hills
Still love this calc though.
-hero experience calculator (how many levels with how much experience)
http://evonypedia.com/Hero_Experience_Calculator is very fine but I'm sure you see the advantage of having everything on the same sheet...
-Mini-map : somebody got sued for using a map generated by a bot. This map is personnal, you fill in coords yourself (you, your friends etc) and is in no way against TOS
It's basically just a chart. easy to make easy to use.
wow this is so good man....Nice +rep
First one is easy. For the second, it'll use user's choice.-how many troops you currently have
-how many npc's you can farm, gradually more over time as income/troop training speed increases
Let's start noting some things I'll need to remember:
-Troop losses from 10s
-Taking the farming considerations will allow me to make that chart that updates troops once per day (and not per hour) since the person could farm 5s first, 10s later, or a mix, etc..
Who's gonna use one hero to farm all the NPCs? I'll make a field that allows the user to either set some sort of %tage of 5s to farm per hero (and thus the number of heroes) & 10s, or the number of NPCs farmed per hero.-the increasing level of your hero, based on the amount of exp it will gain from farming
Easy.-hero experience calculator (how many levels with how much experience)
Easy.-hero excal calculator (how much attack with excal? how much attack if you took away excal?)
No idea on how to do this. It'll go into a new sheet, ofc, but I don't see how to do this without it taking a hell lot of cells (one cell per coord, that's around 640k cells for a map that ends at 799,799). It'd be too messy.-Mini-map (in which you can fill in the coordinates of cities to get a general idea of who's where)
Shouldn't be too hard.Here you can go a step further and include a function which allows the player to see what training time per troop s/he would have if s/he applied excal eqn is: (ln[(time+1/base bt)/.9^σ]/ln (.995))/1.25=hero lvl... or eve do this for a polwih wall d, similarly eqn is (ln[(time+1/base bt)/.9^σ]/ln (.995))/1.25=hero lvl where σ=MS/Mc or =Consruction
You mean all the buildings? I could do that.if u want to get uber creative add in a function where the person can see how the pol of the hero affects building time of units
Lucas will pay my lawyer anyway.didnt somone get sued by evony for doing this exact thing?
Here's how to do it:
-build 3 tables. each table with 2 columns and infinite rows. You have column x, and column y. They will represent the coordinates of your cities.
The first table will be called My cities.
The second, Friendly Cities.
The third, Enemy Cities.
You can also add more tables (npc's, valleys, neutrals, etc) but then it gets crowded.
Now, simply make a scatter graph with these tables. It will put a colored dot at the coordinates of each city. make it a golden dot for the My Cities table, a red dot for the Enemy Cities table, a green dot for the Friendly Cities table...
Now, the scatter graph will auto-update itself as you add/remove cities. It will also auto-update the size of the map (if you only fill in coords in Moravia, it will only show the map of Moravia and not the whole 799*799 grid. That way it's clearer and you have less unused white space.)
Hope you understand what I mean...
T![]()
Ooh, I've always done it using one table (a real mess) that way..Now, simply make a scatter graph with these tables.
This should be pretty clear, with the exception that you can't make Lords' names appear in the graph (coords can be shown on the point tho. Still gets messy if you add a lot of coords) To fix that, I could make more tables (one per state) and give the user the option to display one chart per state or one chart for the whole map (resizing it to make it big enough).
Ok, made the drop down list and all that, but I see no option that doesn't require the user to actually fill in the coords by state (he can't just put them all without checking their states).
Here's the beta spreadsheet, any help would be appreciated regarding auto-sorting coords depending on state:
http://www.mediafire.com/file/7ujoc0...C_Map_Beta.xls
Original spreadsheet that has a drop down list taken from http://www.jkp-ads.com/Articles/ShowPicture00.asp (I was using a method that only uses defining names to define the drop down list, which is quite limited and wouldn't allow me to make a drop down list with all the states due to the 255 characters limits)
Lords' names will also show in the, uh, "official" release. Found a neat macro for that.
Updated to v2.0.1
New Features:
- Map
- Hero tab (includes hero EXP calculator, EXP gain calculator from attacking 5s/10s [consecutive attacks or normal attacks], EXP gain calculator depending on killed troop)
- Troops graph (shows current & needed troops, as well as production time [per troop & stacked])
Bookmarks