Play Now Login Create Account
illyriad
  New Posts New Posts RSS Feed - Advanced Attacking: a work in progress
  FAQ FAQ  Forum Search   Register Register  Login Login

Topic ClosedAdvanced Attacking: a work in progress

 Post Reply Post Reply Page  123 7>
Author
 Rating: Topic Rating: 2 Votes, Average 5.00  Topic Search Topic Search  Topic Options Topic Options
Salararius View Drop Down
Postmaster
Postmaster
Avatar

Joined: 26 Sep 2011
Location: USA
Status: Offline
Points: 519
Direct Link To This Post Topic: Advanced Attacking: a work in progress
    Posted: 30 Sep 2013 at 02:11
Originally posted by Angrim Angrim wrote:

was any version of this released that would avoid the Excel requirement?  OpenOffice, gdocs, or other...?

Try this:

https://docs.google.com/spreadsheet/ccc?key=0Ao6l7avI4cJvdEdncmd6bzBDZnl2ZUprQmZYMmY1TWc&usp=sharing

it's based on the same calculations but the presentation may be different.

Back to Top
Angrim View Drop Down
Postmaster General
Postmaster General
Avatar

Joined: 02 Nov 2011
Location: Laoshin
Status: Offline
Points: 1212
Direct Link To This Post Posted: 29 Sep 2013 at 17:14
was any version of this released that would avoid the Excel requirement?  OpenOffice, gdocs, or other...?
Back to Top
Salararius View Drop Down
Postmaster
Postmaster
Avatar

Joined: 26 Sep 2011
Location: USA
Status: Offline
Points: 519
Direct Link To This Post Posted: 21 Oct 2012 at 04:08
Originally posted by dunnoob dunnoob wrote:

Testing your link, Google asks me to login, and Chrome offers to do this for me.  (IIRC that's a new spyware feature offered in about:flags for the stable Chrome versions.)  After that Google allows me to request access.  Is that as you wanted it, did you forget to set some public flag, or is your link the version for co-authors instead of users?  

yes, i posted the wrong link :(  Which is all just as well because I didn't check to see how the code would work on other browsers, not very well.  Just got too excited to be doing something more productive than forum posting.  Oh well, back to work.  The link should work for Chrome (I hope).  As I said, I'm learning as I go.

Back to Top
dunnoob View Drop Down
Postmaster
Postmaster
Avatar

Joined: 10 Dec 2011
Location: Elijal
Status: Offline
Points: 800
Direct Link To This Post Posted: 20 Oct 2012 at 10:04
Testing your link, Google asks me to login, and Chrome offers to do this for me.  (IIRC that's a new spyware feature offered in about:flags for the stable Chrome versions.)  After that Google allows me to request access.  Is that as you wanted it, did you forget to set some public flag, or is your link the version for co-authors instead of users?  
Back to Top
Salararius View Drop Down
Postmaster
Postmaster
Avatar

Joined: 26 Sep 2011
Location: USA
Status: Offline
Points: 519
Direct Link To This Post Posted: 20 Oct 2012 at 04:36
This was one of the first truly helpful tools I used for Illy.  I was tinkering with Google web apps tech and thought Innoble's spreadsheet would be a fun project to practice with to learn the new tech.  Here's the link, I believe it's the same calculations as Innoble's work, just in a web page.

This link should give public access (sorry for the bad link earlier).


Doesn't seem to work very well in browsers other than Chrome.  Obviously not what I wanted.  I'll keep working and see if I can iron out the issues.



Edited by Salararius - 21 Oct 2012 at 04:05
Back to Top
Cleopatra View Drop Down
New Poster
New Poster
Avatar

Joined: 07 Jun 2012
Status: Offline
Points: 35
Direct Link To This Post Posted: 25 Jul 2012 at 01:13
So is it
1.
BTAF×PRESTIGE BONUS

or?

2.
  • Basic Total Attack Formula (BTAF)

BTAF=TUAF + TCAF

 

  • Total Unit Attack Formula (TUAF)

TUA= (UBA×PRESTIGE BONUS) × UC × UB

 

  • Unit Base Attack (UBA)

UBA= Unit Base Attack Variable

 

  • Unit Count (UC)

UC= Total # of Unit Type Troops

 

  • Unit Bonus (UB)

UB= 1 + UTB/100 +UDB/100

 

  • Unit Type Bonus (UB)

UTB= Unit Type Terrain Bonus Variable

 

  • Unit Division Bonus (UB)

UDB= Unit Type Division Bonus Variable

 

  • Total Commander Attack Formula (TUAF)

IF (CBA ×HF) UBA × UC

THEN TCAF= UBA × UC × CB

UNTIL (UBA × UC) (CBA × 2)

THEN TCAF = CBA × 2 × CB

IF (CBA × HF) UBA × UC

THEN TCAF= CBA × HF × CB

 

  • Commander Base Attack (CBA)

CBA= Commander Unit Base Attack Variable

 

  • Heroism Factor (HF)

HF=(1 + 6 × H)

 

  • Heroism (H)

H= Heroism Variable

 

  • Commander Bonus (CB)

CB= 1 + CTB/100 + CDB/100

 

  • Commander Terrain Bonus (CTB)

CTB= Commander Terrain Bonus Variable

 

  • Commander Division Bonus (CDB)

CDB+ Commander Division Bonus Variable





Edited by Cleopatra - 25 Jul 2012 at 01:16
Back to Top
SugarFree View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 09 Feb 2012
Status: Offline
Points: 350
Direct Link To This Post Posted: 24 Jul 2012 at 14:32
i think : 10% + attack means that the individual unit attack is raised by 10%?
Back to Top
Cleopatra View Drop Down
New Poster
New Poster
Avatar

Joined: 07 Jun 2012
Status: Offline
Points: 35
Direct Link To This Post Posted: 24 Jul 2012 at 14:29
I take it that means that commanders do NOT actually attack troops. Hmmm, well that changes the dynamics up quite a bit. When you say that is a known issue, does that mean that commanders are SUPPOSED to attack troops, but for some reason don't actually do it? Or does that mean that they never intended for commanders to attack troops, but now might be considering changing it?

Oh, and one other question. Where does the prestige bonus to attack/defense get factored in at?

Edited by Cleopatra - 24 Jul 2012 at 14:29
Back to Top
SugarFree View Drop Down
Forum Warrior
Forum Warrior
Avatar

Joined: 09 Feb 2012
Status: Offline
Points: 350
Direct Link To This Post Posted: 24 Jul 2012 at 08:24
o gosh, geeks...
the commander issue IS known to the devs.

Back to Top
Cleopatra View Drop Down
New Poster
New Poster
Avatar

Joined: 07 Jun 2012
Status: Offline
Points: 35
Direct Link To This Post Posted: 24 Jul 2012 at 05:20
Even if the NPC doesn't have a commander, the player would still have one. So whether or not the attacking commander inflicts any actual damage on the defending NPC or not is still relevant.

I am not planning on actually running my own calculator, I just want to know how it all fits together. Understanding bits and pieces of the attack system doesn't really let me plan out an overall strategy.  
Do commanders kill attacking troops? Do they kill defending troops? Do the kill no troops at all? Why does it matter what the commander's attack does? How do defending commanders affect the battles? 

If I have all the equations, I can figure all that out for myself. 

Basically, I understand what the list of factors involved is, but I'm trying to understand how they interrelate, what actual impact each of them has, and how they combine.  
Back to Top
 Post Reply Post Reply Page  123 7>
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.