Page 2 of 11 FirstFirst 1234 ... LastLast
Results 11 to 20 of 107

Thread: Gcalc

  1. #11
    Join Date
    Dec 2009
    Location
    Arkansas
    Posts
    2,253

    Default

    i'm gonna let you guys handle this. I saw MATH and ran for the hills

    Still love this calc though.

    ~Betrayed's Little Geeky Kitty~

    ~Read My Story Here Show Your Support~

    I cyber stalk people for fun

  2. #12

    Default

    -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.
    Grey is prey, Red is dead.

    Thanks to Tsubasa!
    Quote Originally Posted by Rota View Post
    He is not picking his nose, his finger is clearly out of his nose. The pic is obviously the transition after he has picked his nose, but before the finger goes into his mouth. It's an action shot.

  3. #13
    Join Date
    Jan 2010
    Location
    Eating a cat
    Posts
    2,220

    Default

    Quote Originally Posted by thierryd View Post
    -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.
    yea definatly better inside the chart, Didnt know if there was a way to incorperate that calc into the sheet and save some time ... Now tha u mentioned the law suit watch us both get an infraction

  4. #14
    Join Date
    Apr 2011
    Location
    Miami(North Cuba Lol)
    Posts
    1,166

    Default

    wow this is so good man....Nice +rep

  5. #15

    Default

    -how many troops you currently have
    -how many npc's you can farm, gradually more over time as income/troop training speed increases
    First one is easy. For the second, it'll use user's choice.
    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..

    -the increasing level of your hero, based on the amount of exp it will gain from farming
    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.

    -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?)
    Easy.
    -Mini-map (in which you can fill in the coordinates of cities to get a general idea of who's where)
    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.

    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
    Shouldn't be too hard.

    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
    You mean all the buildings? I could do that.

    didnt somone get sued by evony for doing this exact thing?
    Lucas will pay my lawyer anyway.

  6. #16

    Default

    Quote Originally Posted by GermainZ View Post
    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.
    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
    Grey is prey, Red is dead.

    Thanks to Tsubasa!
    Quote Originally Posted by Rota View Post
    He is not picking his nose, his finger is clearly out of his nose. The pic is obviously the transition after he has picked his nose, but before the finger goes into his mouth. It's an action shot.

  7. #17

    Default

    Now, simply make a scatter graph with these tables.
    Ooh, I've always done it using one table (a real mess) that way..
    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).

  8. #18

    Default

    Quote Originally Posted by GermainZ View Post
    Ooh, I've always done it using one table (a real mess) that way..
    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).
    Sounds good man.
    Grey is prey, Red is dead.

    Thanks to Tsubasa!
    Quote Originally Posted by Rota View Post
    He is not picking his nose, his finger is clearly out of his nose. The pic is obviously the transition after he has picked his nose, but before the finger goes into his mouth. It's an action shot.

  9. #19

    Default

    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.

  10. #20

    Default

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •