Civ III Combat Calculator (.EXE)

BomberEscort · Jan 18, 2004, 05:46 AM

It's finally here...

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

BomberEscort · Jan 18, 2004, 05:47 AM

Screenshot

BomberEscort · Jan 18, 2004, 05:49 AM

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/upload...tor_v1.36_.zip

Calculator VB6 Source
http://forums.civfanatics.com/showpo...5&postcount=82

Gogf · Jan 18, 2004, 12:01 PM

NICE!! Great job!

Sparta · Jan 20, 2004, 09:27 AM

sweet! thanks BomberEscort!

Oldenbarnevelt · Jan 21, 2004, 08:49 AM

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

BomberEscort · Jan 21, 2004, 09:30 AM

Quote:

Originally posted by Oldenbarnevelt
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

Thanks... Also, nitpicking is fine, I like to pick nits...

Also, welcome to CivFanatics!

BomberEscort · Jan 22, 2004, 05:17 AM

Version 1.01 available...

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

jaafit · Jan 23, 2004, 02:50 AM

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?

socralynnek · Jan 23, 2004, 03:42 AM

Quote:

Originally posted by jaafit
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?

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...

jaafit · Jan 23, 2004, 04:55 AM

Ahhh, got it. Thanks.

BomberEscort · Jan 23, 2004, 05:24 AM

Quote:

Originally posted by jaafit
Nice job. Another nit: The tool-tip on AHPL is the same as the tool tip on DHPL...

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.

BomberEscort · Jan 23, 2004, 05:27 AM

Also, the AA section is ahead of schedule, after I get the kinks in the formula straightened out I should have it ready by the end of the month...

Go here...

http://forums.civfanatics.com/showth...88#post1540188

for details on the AA Formula...

BomberEscort · Jan 24, 2004, 05:19 AM

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.

jaafit · Jan 24, 2004, 05:41 AM

Quote:

Originally posted by BomberEscort

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.

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.

BomberEscort · Jan 24, 2004, 05:46 AM

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...)

Civrules · Jan 24, 2004, 11:18 AM

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!!!

Pepso · Jan 24, 2004, 09:23 PM

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.

BomberEscort · Jan 26, 2004, 05:40 AM

Quote:

Originally posted by Pepso
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.

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...

Pepso · Jan 26, 2004, 01:10 PM

Thanks BomberEscort.

Jan 18, 2004, 05:46 AM	#1
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	Civ III Combat Calculator (.EXE) It's finally here... 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 __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Sep 08, 2005 at 07:03 PM.

Jan 18, 2004, 05:47 AM	#2
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	Screenshot Screenshot __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Aug 04, 2006 at 07:57 PM.

Jan 18, 2004, 05:49 AM	#3
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	CivIII Combat Calculator (EXE) 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/upload...tor_v1.36_.zip Calculator VB6 Source http://forums.civfanatics.com/showpo...5&postcount=82 __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Dec 23, 2006 at 09:22 AM. Reason: Re-uploaded file upon request

Jan 18, 2004, 12:01 PM	#4
Gogf Indescribable Join Date: Oct 2003 Location: Connecticut Posts: 9,726	NICE!! Great job! __________________ [21:34] <Bill3000> I met someone over the internet yesterday and he slept over [21:35] <Bill3000> not the first time [21:37] <Bill3000> you consented!

Jan 22, 2004, 05:17 AM	#8
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	Version 1.01 available... Fixed some very minor errors, AA still on schedule for the next version release (mid-Feb) __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study

Jan 20, 2004, 09:27 AM	#5
Sparta Emperor Join Date: Sep 2003 Posts: 1,256	sweet! thanks BomberEscort!

Jan 21, 2004, 08:49 AM	#6
Oldenbarnevelt Chieftain Join Date: Jan 2004 Location: Dutch Republic Posts: 15	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

Jan 23, 2004, 02:50 AM	#9
jaafit Chieftain Join Date: Jan 2004 Location: OR, USA Posts: 37	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?

Jan 23, 2004, 04:55 AM	#11
jaafit Chieftain Join Date: Jan 2004 Location: OR, USA Posts: 37	Ahhh, got it. Thanks.

Jan 23, 2004, 05:27 AM	#13
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	Also, the AA section is ahead of schedule, after I get the kinks in the formula straightened out I should have it ready by the end of the month... Go here... http://forums.civfanatics.com/showth...88#post1540188 for details on the AA Formula... __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study Last edited by BomberEscort; Jan 23, 2004 at 12:23 PM.

Jan 24, 2004, 05:19 AM	#14
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	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. __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study

Jan 24, 2004, 05:46 AM	#16
BomberEscort P51 Mustang Pilot Join Date: Jul 2003 Location: Missouri USA Posts: 793	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...) __________________ NEW Civ III Combat Calculator for C3C (.EXE) NEW Civ III Best Attacker Utility (.XLS) Anti-Air Combat Formula Revealed Comprehensive Retreat Study

Jan 24, 2004, 11:18 AM	#17
Civrules All rights reserved™-TTYL Join Date: Apr 2003 Location: U.S.A. Posts: 5,519 Images: 119	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!!! __________________ Civilization IV Articles: Civ4 Info Center (Last Updated on April 16th) \| Final Preview: Filling in the Gaps (Posted on October 24th) \| Hands-On Preview (Posted on October 13th). Pirates! Articles: Exclusive Insider Information Article \| Pre-Release Information. CivFanatics Forum Info: General Forum FAQ \| Forum Rules \| Forum BB Tags.

Jan 24, 2004, 09:23 PM	#18
Pepso Chieftain Join Date: Aug 2003 Posts: 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. Last edited by Pepso; Jan 24, 2004 at 10:42 PM.

Jan 26, 2004, 01:10 PM	#20
Pepso Chieftain Join Date: Aug 2003 Posts: 4	Thanks BomberEscort.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
As promised, a Civ III combat test map	Dan Magaha FIRAXIS	Civ3 - General Discussions	75	Nov 05, 2004 04:41 PM
Civ Assistants Utility [ in-Civ combat calculator! ]	CivLackey	Utility Programs	49	Jul 09, 2004 05:24 AM
Civ III ptw crashes during heavy combat	baare	Civ3 - Multiplayer & PBEM	11	Mar 25, 2004 01:14 PM
Combat Calculator	Thunderfall	Utility Programs	24	Jul 21, 2003 06:04 PM
How many you ever used the combat calculator?	Grey Knight	Civ3 - General Discussions	14	Sep 06, 2002 04:38 PM

Powered by vBulletin® Copyright ©2000 - 2009, Jelsoft Enterprises Ltd. This site is copyright © 2000 - 2009, Civilization Fanatics' Center.
Support CFC: Amazon.com \| EB Games \| Amazon UK \| Amazon DE \| Amazon CA \| Amazon FR