1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  3. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  4. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  5. Dismiss Notice
  6. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

Civ III Combat Calculator (.EXE)

Discussion in 'Civ3 - Utility Programs' started by BomberEscort, Jan 18, 2004.

  1. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    It's finally here... :D

    the conversion of my Excel spreadsheet into an EXE file for all those who wanted to use it but didn't have Excel. Also, I will no longer be supporting the spreadsheet.

    *** Latest Version 1.35 ***


    v1.32
    • Custom Terrain Bonuses from -99% to +999% in 1% increments.
    • Defender and Attacker HP increase to a maximum of 20 from 6.
    • Bombard Rate-of-Fire increased to a maximum of 20 from 6.
    • New Fields to show cumulative percentages of winning with 6+ HP
      for Non-Bombard Attacks and 7+ HP for Bombard Attacks.
    • Fast Defender/Attacker HP and Experience are no longer tied to one another. Conscripts to Elites with 1 to 20 HP are now possible.
    • With the use of the new Custom Terrain setting you can achieve any Total Defensive Bonus from -99% to 1174% in 1% increments!
    • SAM Missile Battery Defenses from 1 to 99 (Default 8)
    • Interception Percentages from 1% to 100% (Default 50%)
    • A tool-tip functionality has been incorporated as a rudimentary form of help. Hover over a section and information shall be displayed.
    • Added Defensive Equivalent Option.
    • Fixed problem with Bombardment Percentages not showing correctly when lethal bombard was off. The totals were correct, the error was in the HP loss individual Percentages.
    • Added Default Bombard values for reference when using Offensive Bombard.
    • Rearranged to make the calculator more compact.

    v1.33
    • Reworked Defensive Equivalent to include all units instead of slow only.
    • Individual Battle percentages now show for Defensive Bombard, Fast units and Slow units. Totals were not effected.
    • Added 'help' text for the Defensive Equivalent function.

    v1.35
    • Fixed bug with retreat AHPL/DHPL not showing correctly
    • Fixed bug with Defensive Bombards not calculating correctly in some instances

    Scroll Down past the screenshot for the EXE file ;)
     
  2. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
  3. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    Here is the program...

    Version 1.00 removed after 21 downloads...
    Version 1.01 removed after 58 downloads...
    Version 1.10 removed after 83 downloads...
    Version 1.15 removed after 1,005 downloads...
    Version 1.22 removed after 841 downloads...
    Version 1.30 removed after 16 downloads...
    Version 1.32 removed after 192 downloads...
    Version 1.33 removed after 458 downloads...


    Calculator EXE
    http://forums.civfanatics.com/uploads/33932/CivIIICombatCalculator_v1.36_.zip

    Calculator VB6 Source
    http://forums.civfanatics.com/showpost.php?p=4908955&postcount=82
     
  4. Gogf

    Gogf Indescribable

    Joined:
    Oct 12, 2003
    Messages:
    10,163
    Location:
    Plane Of Fish Sticks
    NICE!! Great job!
     
  5. Sparta

    Sparta Chieftain

    Joined:
    Sep 25, 2003
    Messages:
    1,256
    sweet! thanks BomberEscort!
     
  6. Oldenbarnevelt

    Oldenbarnevelt Chieftain

    Joined:
    Jan 16, 2004
    Messages:
    15
    Location:
    Dutch Republic
    Congrats on your first VB program! As far as I can see the calculation results are correct. A nice tool! A little nitpicking: "Lethal Bomard" should be "Lethal Bombard".

    --
    My first post to a Fanatics Forum :)
     
  7. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    Thanks... Also, nitpicking is fine, I like to pick nits... :D

    Also, welcome to CivFanatics!
     
  8. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    Version 1.01 available...

    Fixed some very minor errors, AA still on schedule for the next version release (mid-Feb)
     
  9. jaafit

    jaafit Chieftain

    Joined:
    Jan 18, 2004
    Messages:
    45
    Location:
    OR, USA
    Nice job. Another nit: The tool-tip on AHPL is the same as the tool tip on DHPL.

    One question: why does a fast attacker have less chance of winning than a non-fast attacker?
     
  10. socralynnek

    socralynnek Civ & Hattrick addict

    Joined:
    Sep 1, 2003
    Messages:
    1,412
    Location:
    Northern Germany
    It's because the fast attacker runs away when reaching 1 HP, while the others fight on. So, if you fight on, you have a small chance to win, so it's a small increase in winning, but also notice the bigger increase in losing...
     
  11. jaafit

    jaafit Chieftain

    Joined:
    Jan 18, 2004
    Messages:
    45
    Location:
    OR, USA
    Ahhh, got it. Thanks.
     
  12. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    I believe this was fixed in version 1.01, it is on the copy I have... If it isn't let me know and I will repost.
     
  13. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
  14. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    The AA formula is now apart of the Civ III Combat Calculator v1.10... Credit to alexman and his work over at Poly in this endeavor and his testing on the formula... Our results and conclusions are in agreement.
     
  15. jaafit

    jaafit Chieftain

    Joined:
    Jan 18, 2004
    Messages:
    45
    Location:
    OR, USA
    I downloaded v 1.10 and it's still the same.

    I love this program though! I just used it today in my war against Ottomans, trying to decide if my 4hp calvary with radar tower should attack his 1 hp tank on a hill. I put in the values and it looked like I had about a 50/50 so I went for it. I lost 3 hp, and then... :)
    No more tank.
     
  16. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    Ok, I see what you are talking about now, I thought you meant the numbers 0-5 under that... I will fix this in the next version (I'm going to wait to see if any more errors crawl out of the woodwork...)
     
  17. Civrules

    Civrules We the People

    Joined:
    Apr 6, 2003
    Messages:
    5,621
    Gender:
    Male
    Location:
    US
    BomberEscort, thank you. I was unable to use your other excel calc but this seems to work fine. Now I can use this!!

    Thanks a lot!!! :goodjob:
     
  18. Pepso

    Pepso Chieftain

    Joined:
    Aug 4, 2003
    Messages:
    4
    Hi BomberEscort, first of all congrat's for this very nice program.

    Secondly as you are an expert in this matter i was thinking if you could explain how the bombardment formula is calculated and if it's the same as the defensive bombardment, or you could just indicate some thread's you know, as i don't want to start a new one over this matter again.

    And keep up the good work.
     
  19. BomberEscort

    BomberEscort Don't be alarmed; this is a kindness

    Joined:
    Jul 28, 2003
    Messages:
    1,100
    Gender:
    Male
    Location:
    Kansas City
    The Bombardment Formula:

    (BombardAttack / (BombardAttack + ModifiedDefense))^RateOfFire

    e.g.- If the Bombard Attack = 4, Modified D = 6, ROF = 3 then...

    Chance the Defender Takes 0 Damage = (6/10)^3 = 0.216
    (Defender has to win all 3 battles)

    Chance the Defender Takes 1 Damage = (6/10)^2 * (4/10)^1 * nCr(3,1) = 0.36 * 0.4 * 3 = 0.432
    (Defender wins 2 battles, Attacker Wins 1, 3 Ways to Happen)

    ... Same for the other values (Defender takes 2 and 3 damage)

    As for Defensive Bombardment, that is something different... ;)
     
  20. Pepso

    Pepso Chieftain

    Joined:
    Aug 4, 2003
    Messages:
    4
    Thanks BomberEscort. :)
     

Share This Page