Unit Statistics and Spreadsheets
-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Unit Statistics and Spreadsheets
So I recently did some math on some units (mainly Ottoman ones) because I love incorporating math in aoe3, kinda like Spirit of the Law lol. But anyways, imma keep uploading all the spread sheets I make on here when I get a chance. So if any one wants to look over them to see if they will be helpful for some people. They mainly involve K/D ratios vs certain units and cost/attack or cost/HP ratios.
- Attachments
-
- Spain.xlsx
- How key Spanish rush units perform against other Age II units.
- (10.6 KiB) Downloaded 44 times
-
- UnitPerStat(JaniComparison).xlsx
- How Jans perform compared to other musketeers.
- (14.32 KiB) Downloaded 65 times
-
- UnitPerStat(AbusGun).xlsx
- How Abus perform when fighting other Age II units.
- (12.29 KiB) Downloaded 62 times
-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
fandom haha, but also some extra stuff thats not on the web i got from in game (such as unit classifications).
-
lemmings121
- Jaeger
- Posts: 2674
- Joined: Mar 15, 2015
- ESO: lemmings121
Re: Unit Statistics and Spreadsheets
try this site, lots of usefull and precise info there.GandolfTheWhite7 wrote:fandom haha, but also some extra stuff thats not on the web i got from in game (such as unit classifications).
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.

-
Riotcoke
- Retired Contributor
- Posts: 4094
- Joined: May 7, 2019
- ESO: Riotcoke
- Location: Dorsetshire
- Clan: UwU


Re: Unit Statistics and Spreadsheets
I feel your grenadier stats might be slightly off, same with dops and pikes. Are you classing the light inf multiplier as Abus' multiplier instead of the Cyote multiplier @Joshua667746

twitch.tv/stangoesdeepTV
-
lemmings121
- Jaeger
- Posts: 2674
- Joined: Mar 15, 2015
- ESO: lemmings121
Re: Unit Statistics and Spreadsheets
btw... @Buckethead cant you do some blackmagic and extract the updated data com current patch and host it somewhere in esoc? in a nice huge table like the link I posted. rly useful for quick checking some stats.lemmings121 wrote:try this site, lots of usefull and precise info there.GandolfTheWhite7 wrote:fandom haha, but also some extra stuff thats not on the web i got from in game (such as unit classifications).
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.

-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
@Riotcoke In regards to the strikes for the dops etc to kill an AG, I got their attack, saw if they had any multipliers vs AG, then found how many hits it would take to kill an AG. For the shots for an AG to kill a dop etc, I classified the dop as heavy inf and as a result added a 1.5 multiplier to the 40 ranged attack. Which part was wrong?
-
Riotcoke
- Retired Contributor
- Posts: 4094
- Joined: May 7, 2019
- ESO: Riotcoke
- Location: Dorsetshire
- Clan: UwU


Re: Unit Statistics and Spreadsheets
Ah i see the place you're getting mistaken, in TAD the "light infantry" tag is designated for cyotemen, the aztec cav. Any multipler for light inf is only for cyotes not for Skirmishers or Abus.GandolfTheWhite7 wrote:@Riotcoke In regards to the strikes for the dops etc to kill an AG, I got their attack, saw if they had any multipliers vs AG, then found how many hits it would take to kill an AG. For the shots for an AG to kill a dop etc, I classified the dop as heavy inf and as a result added a 1.5 multiplier to the 40 ranged attack. Which part was wrong?

twitch.tv/stangoesdeepTV
-
lemmings121
- Jaeger
- Posts: 2674
- Joined: Mar 15, 2015
- ESO: lemmings121
Re: Unit Statistics and Spreadsheets
Check the unit tags in the site I linked, you are making a mess there with your unit tags. the game can be missleading in some information. what actually matters for bonuses is those tags.GandolfTheWhite7 wrote:@Riotcoke In regards to the strikes for the dops etc to kill an AG, I got their attack, saw if they had any multipliers vs AG, then found how many hits it would take to kill an AG. For the shots for an AG to kill a dop etc, I classified the dop as heavy inf and as a result added a 1.5 multiplier to the 40 ranged attack. Which part was wrong?

-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
@Riotcoke ok ill check out the sight Lemmings posted, but were u referring to the strikes to kill an abus gun, or the shots to be killed by an abus gun?
-
iCourt
- Retired Contributor
- Posts: 700
- Joined: Jan 14, 2016
- ESO: iCourt
- Location: Monterey, California
Re: Unit Statistics and Spreadsheets
Ah! I'll remake this all for you. I used to have a PDF of this. This was by far the best and easiest to read unit guide.lemmings121 wrote:try this site, lots of usefull and precise info there.
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.
I will make an RE version and an EP version and reupload it on ESOC in a week or twos time. Gonna get started. I'll get it stickied once it's posted.
-
deleted_user
- Ninja
- Posts: 14364
- Joined: Mar 26, 2015
Re: Unit Statistics and Spreadsheets
mac gameranger players are really the unsung heroes of aoe3
Re: Unit Statistics and Spreadsheets
Oh my god the PDF is coming backiCourt wrote:Ah! I'll remake this all for you. I used to have a PDF of this. This was by far the best and easiest to read unit guide.lemmings121 wrote:try this site, lots of usefull and precise info there.
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.
I will make an RE version and an EP version and reupload it on ESOC in a week or twos time. Gonna get started. I'll get it stickied once it's posted.
I used to open that file daily to check unit stats
-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
imma try program a mini excel file or something so when u put the number of resources in for a unit/s v unit/s fight, it will say who will win and by how much, although dunno how to attribute like distance for mele units to walk and sstuff like that
-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
aye do we think when rushing on RE deccan should the ottoman player go TP, House, Market+Hunting Dogs__OR___TP, House, Mosque+Millet System?
-
harcha
- Gendarme
- Posts: 5257
- Joined: Jul 2, 2015
- ESO: hatamoto_samurai
Re: Unit Statistics and Spreadsheets
or double TP on the 2 TP lineGandolfTheWhite7 wrote:aye do we think when rushing on RE deccan should the ottoman player go TP, House, Market+Hunting Dogs__OR___TP, House, Mosque+Millet System?
POC wrote:Also I most likely know a whole lot more than you.
POC wrote:Also as an objective third party, and near 100% accuracy of giving correct information, I would say my opinions are more reliable than yours.
-
lemmings121
- Jaeger
- Posts: 2674
- Joined: Mar 15, 2015
- ESO: lemmings121
Re: Unit Statistics and Spreadsheets
and i open this web archive thingMitoe wrote:Oh my god the PDF is coming backiCourt wrote:Ah! I'll remake this all for you. I used to have a PDF of this. This was by far the best and easiest to read unit guide.lemmings121 wrote:try this site, lots of usefull and precise info there.
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.
I will make an RE version and an EP version and reupload it on ESOC in a week or twos time. Gonna get started. I'll get it stickied once it's posted.
I used to open that file daily to check unit stats


-
Joshua667746
- ESOC Media Team
- Posts: 55
- Joined: Jun 6, 2020
- ESO: GandalfTheWhite7
Re: Unit Statistics and Spreadsheets
@harcha I've found the double TP is actually between 15-20 seconds slower than the hunting dogs. Cuz u get the upgrade instantly on deccan pre much. So ur age up can be qued 10% faster. I get the double TP would be better sometimes. But the fact ur attacking and getting xp in ur opponents base makes up for it in my experience.
-
iCourt
- Retired Contributor
- Posts: 700
- Joined: Jan 14, 2016
- ESO: iCourt
- Location: Monterey, California
Re: Unit Statistics and Spreadsheets
Update on this: I will have this finished this week. When I started working on this my town reopened... and it was a shit show. We were one of the few beach towns in open in California. And then we had BLM protests so my base was on heightened threat levels etc... total shit show. We just got closed back down, so I now have some decent time to focus on making all the patch edits.iCourt wrote:Ah! I'll remake this all for you. I used to have a PDF of this. This was by far the best and easiest to read unit guide.lemmings121 wrote:try this site, lots of usefull and precise info there.
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.
I will make an RE version and an EP version and reupload it on ESOC in a week or twos time. Gonna get started. I'll get it stickied once it's posted.
The RE version is completed. I have these on a google doc, so I'll give access to ESOC admins that want to jump in and fix anything that changes on a future patch or any small errors I could have missed. Not sure if you want to add a web page for it similar to the patch notes etc.
Re: Unit Statistics and Spreadsheets
I would always try and stop this as the other team. I think it would be rare that you manage to do this.harcha wrote:or double TP on the 2 TP lineGandolfTheWhite7 wrote:aye do we think when rushing on RE deccan should the ottoman player go TP, House, Market+Hunting Dogs__OR___TP, House, Mosque+Millet System?
Re: Unit Statistics and Spreadsheets
Hey hey! How's the document coming along?iCourt wrote:Update on this: I will have this finished this week. When I started working on this my town reopened... and it was a shit show. We were one of the few beach towns in open in California. And then we had BLM protests so my base was on heightened threat levels etc... total shit show. We just got closed back down, so I now have some decent time to focus on making all the patch edits.iCourt wrote:Ah! I'll remake this all for you. I used to have a PDF of this. This was by far the best and easiest to read unit guide.lemmings121 wrote:try this site, lots of usefull and precise info there.
http://web.archive.org/web/201007111028 ... units.html
old and dead original link, but still on web archive.
I will make an RE version and an EP version and reupload it on ESOC in a week or twos time. Gonna get started. I'll get it stickied once it's posted.
The RE version is completed. I have these on a google doc, so I'll give access to ESOC admins that want to jump in and fix anything that changes on a future patch or any small errors I could have missed. Not sure if you want to add a web page for it similar to the patch notes etc.

Who is online
Users browsing this forum: No registered users and 1 guest