Page 8 of 31 FirstFirst ... 67891018 ... LastLast
Results 71 to 80 of 301

Thread: AeroCalc v2.0 - Scouts now included

  1. #71

    Default

    Finished

    I'm too shot to send it out yet but here's some detail on how I implemented leadership:



    The formula for A.hero max stack in yellow table (N68)is:
    =(B5*10+150)*B5
    and for leadership AW:
    Code:
    =MAX(0;MIN(1;1-(Q43-$N$68)/100000))
    now, in the number-killed formulas I replaced a reference like to Z59 with:
    Code:
    IF($N$61=0;$Z59;Z59)
    where N61 is the leadership method (4th entry in yellow table). After copy to round 2 it becomes:
    Code:
    IF($N$61=0;$Z59;AI59)
    etc. etc.

    N61 pulls it's value from the summary/main sheet where I added it as another tweaking option.

    I also replaced all the nested IF() functions with MIN()/MAX() where it made sense. After that (and still not happy with performance), I optimized the Location formulas. They have 3 MIN or MAX functions in them with a whole range of cells as parameters. I moved those MIN/MAX formulas to unused cells like AB3 & AC3 and reference those cells instead.

    It'll never become a Ferrari but I'm happy enough with performance now so that even with all the added tweaks it's still reasonable.

    I tested a bit with leadership and found that the difference between static for the whole wave and recalculated for each round is much less than the differences I see between HH and regular hero leading the same waves. I got the feeling the penalty might even be more severe...

    cheers,
    DeVerm.

  2. #72

    Default

    very nice tool

    just want to say that if the defender got balls/cats, the excel seems to misscalc

    thx

  3. #73

    Default

    Devrem would mind linking your version here as well?

    idk if Aero is doing more updates

  4. #74
    Join Date
    Jun 2010
    Location
    Dallas, TX
    Posts
    1,082

    Default

    right now what DeVerm is doing is experimenting only. When things become more solid, i generally do updates then

    Tradey: Can you be more specific please?

  5. #75

    Default

    Quote Originally Posted by tradey View Post
    just want to say that if the defender got balls/cats, the excel seems to misscalc
    I tested scout bombs vs D.cats in a hc16 and the calculator was pretty accurate. I never tried anything vs D.ballys so I have no clue on that..

    cheers,
    DeVerm.

  6. #76

    Default

    Quote Originally Posted by AeroAgg06 View Post
    right now what DeVerm is doing is experimenting only. When things become more solid, i generally do updates then

    Tradey: Can you be more specific please?
    ok good
    I have already added the 40% life to defender but the leadership per round still needs updating.

  7. #77

    Default

    Quote Originally Posted by DaveV View Post
    ok good
    I have already added the 40% life to defender but the leadership per round still needs updating.
    Don't worry about that. For a hit killing 400k warriors in a hc14, the difference between leadership penalty per round vs static for complete wave is less than 1 % of kill rate (3k warriors). It's so small I'm not even gonna be able to tell which one is the right option from comparing waves at hc's. Valley tests can determine which is the right method but for calculating hits on HC's the diff is minimal.

    cheers,
    DeVerm.

  8. #78

    Default

    y, for scout bombing result looks valid

  9. #79

    Default

    I admit it's just to show off a bit but many have been asking about the scout bombs so let me show you the report on one:

    Last night we capped Washington DC and almost all primary hits came from 2 other 16's: Moscow 200 miles to the west and Beijing 200 miles to the east. This one is by far the best scout bomb on pults I have ever seen



    ciao!
    DeVerm.

  10. #80

    Default

    ^^ that is worth of a show off

    So the bigger the wave the higher number of pults it kills? proportionally to a smaller wave .
    100k scouts kills 5-6k or so with 500 ATT I believe

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
  •