If a shot hits a different unit that the one it was aimed at, it will do half the damage. – However, a shot that „misses“ can still hit the intended or nearby units. This is how often a unit will hit exactly where it aims, in percent. – If the value is red, it means the unit doesn't have any range, and the LOS value is noted instead.Ĭolumn 6: Acc(uracy) of ranged units. – Usually, the line of sight will be 2 tiles bigger than the range, so an archer with 5 range will have 7 LOS. – If the values are noted like this: 3-15, it means the unit has 3 minimum and 15 maximum range. – If the value is black, the unit has the noted amount of range. For ranged units, this is the time between the projectiles being shot (So there is no difference between the target being close or far away)Ĭolumn 5: Ra(nge) of attack and Line of sight (LoS). If the value is 3, it means 3 seconds will pass between two attacks of that unit (therefore lower is better). is the number of units that can be garrisonedĬolumn 2: M(elee)/P(ierce) armor, reduces each type of damage by the given amount.Ĭolumn 3: Standard attack value, whether it's M(elee) or P(ierce).Ĭolumn 4: Fire rate (FR). Here's an example entry with explanations to show how the spreadsheets should be read.Ĭolumn 1: Name of the unit. ![]() If you like what I'm doing and have the money, you're welcome to donate :) Donate to Jineapple [Here's how a printed version looks If you like it, leave a like rating and save it as a favorite, this helps make it more visible and possible for others to find it as well. There is also a "last updated" version date in the top left corner of each picture so you can see if your is outdated. There's a lot of theory being offered - but you'll still have to do the practice yourself ) This guide is mostly aimed at intermediate players who know the basics but haven't yet memorized all unit counters, civ bonuses, and so on, but even experts may find a thing or two they didn't know before. There are two version, for the base game and the expansions: I am also working on a mod to replace the in-game tooltips with actually useful information. You can find the PDF files for downloading at Or if you prefer, just keep the files (Maybe on a second monitor) around for quick reference Just print it out on sturdy paper, glue it together and you're good to go. Some might remember the Leaflet that came with the CD version - Now you can make your own, with even more information and up to date! It's all there, and on just a few pages optimized for printing. How long does it take for a Boyar to train? What bonuses do Saracens get? Do the Japanese get bloodlines? How big is the Tarkan's anti-building bonus? Here we discuss the TEXT Functions in Excel, STATISTICAL Functions in Excel, DATE & TIME Functions, and MATHEMATICAL Functions in Excel along with practical examples and downloadable excel template.This guide aims to be a reference for anything you might want to know about unit stats or civilizations. This has been a guide to Excel Formulas Cheat Sheet. It will open a dialog box, as shown in the below screenshot.Īnd choose the function as per requirement from the list. If you missed or forget any function syntax, go to the FORMULAS tab and click on the Insert Function button below the screenshot or press the SHIFT+F3 key.Things to Remember About Excel Formulas Cheat Sheet Please refer to the below screenshot, where I have applied the functions on strings and shown their workings. We will understand the working of this function with some example. The most commonly used mathematical functions are SUM, SUBTOTAL, RANDBETWEEN, PRODUCT, SQRT etc. It will open a drop-down list of functions as per the below screenshot. ![]() Click on the Math & Trig functions category.Please refer to the below screenshot, where I have applied the functions on values and shown their workings. ![]() Let’s understand this with some examples in the below screenshot. The most commonly used DATE & TIME functions are NOW, DATE, WEEKDAY, TODAY, WORKDAY, etc. It will open a drop-down list of functions, as shown below screenshot.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |