KobaBOS Spreadsheet

kobayashi

Deity
Joined
Feb 15, 2001
Messages
2,709
Location
Singapore
That would be the 'Kobayashi Battle Outcome Simulator' in full. I've been testing it in parallel with my WWII scenario and it seems to predict pretty well.

Its an Excel spreadsheet I wrote that simulates combat between two units 100 times and shows you the average result and amount of damage sustained. Input items are A/D Factor, Hit Points and Fire Power. Using it has helped me to avoid physically making the units attack each other repeadtedly.

As a result, I am having a low hit point, high firepower scenario where unexpected outcomes occur more frequently. For example, once in a while a VA Wellington tail gunner will nail the Messerschmitt Bf109 before it destroys the bomber. Or occasionally a Panzer III division attacking mere infantry may get decimated. Another interesting thing that that happens under the high fp/ low hp environment is that the surviving unit always gets damaged (i.e. sustain some attrition)and need to rest after battle.

I have sent a copy of KobaBOS to JohnV for testing and if he thinks its OK too, we'll make it available for download soon.
 
Send it to me, too. If it's not too large. You know my e-mail adress. Seems it can help with balancing the units very well!

------------------
Concordia res parvae cres****.
 
This is whay happens when a fund manager becomes a designer.
rolleyes.gif
Everything gets organized.
wink.gif


------------------
<IMG SRC="http://forums.civfanatics.com/ubb/blast.gif" border=0><FONT size="4"><FONT COLOR="blue">All knowledge begins with the Phrase:</FONT c><FONT COLOR="red"> I don't know</FONT c></FONT s><IMG SRC="http://forums.civfanatics.com/ubb/ninja1.gif" border=0>
 
Originally posted by Alcibiaties of Athenae:
This is whay happens when a fund manager becomes a designer. <IMG SRC="http://forums.civfanatics.com/ubb/rolleyes.gif" border=0> Everything gets organized. <IMG SRC="http://forums.civfanatics.com/ubb/wink.gif" border=0>

I have mixed feelings about the advance of calculating devices. Of course its great that we have computers (and Civ2) but when I was at the petrol kiosk (gas station) the other day, the cashier tried to mentally calculate what two items of $31 cost in total and gave up. He ended up using a calculator.

When I was in school (in the 70's), calculators were expressly forbidden and we used a book of numbers called logarithm tables to do the more complex calculations. Seems the younger generation's brains are getting 'lazy' from not having to calculate anything. Very soon they'll stop teaching multiplication tables at school.
 
Originally posted by kobayashi:
I have mixed feelings about the advance of calculating devices. Of course its great that we have computers (and Civ2) but when I was at the petrol kiosk (gas station) the other day, the cashier tried to mentally calculate what two items of $31 cost in total and gave up. He ended up using a calculator.

When I was in school (in the 70's), calculators were expressly forbidden and we used a book of numbers called logarithm tables to do the more complex calculations. Seems the younger generation's brains are getting 'lazy' from not having to calculate anything. Very soon they'll stop teaching multiplication tables at school.
I agree with what you are saying here. When I graduated High School (1979), no one used calculators, we did it all on paper or in our heads. In College (1986-90, I was in the army from 1980-86) I was one of the few students who could do calculations without a calculator. I think we are relying just a bit to much on technology, and not enough on Brain power.


------------------
<IMG SRC="http://forums.civfanatics.com/ubb/blast.gif" border=0><FONT size="4"><FONT COLOR="blue">All knowledge begins with the Phrase:</FONT c><FONT COLOR="red"> I don't know</FONT c></FONT s><IMG SRC="http://forums.civfanatics.com/ubb/ninja1.gif" border=0>
 
Ahhhhh.... I have finally found it!

What's up Kobayashi? You probably got an email and PM from me by now. I just found this thread in the way back. So sign me up.

avant393@aol.com

I can really use this for my upcomming Stalingrad scenario.
Thanks,
FMK
 
What version of Excel did you use for that anyway?

Also, I know for a fact what you're saying is true about calculations, but as long as I am alive I will teach my children and their children math...I think it is important to exercise the mind.

John

 
Holy Crap! Thats some nice piece of work Kobayashi! For me even a spreadsheet is intimidating, so I haven't tried it out yet. Do you have other directions other than what is already in there? You know, a moron's version?
cwm40.gif


Thank you very much. Much appriciated.

FMK
 
It is quite complicated and has many sheets but you only have to look at the one on the front.

There are six cells which you enter the Attack,Hit Points, Firepower of the attacker and Defence,Hit Points, Firepower of the Defender. These are highlighted in blue (or was it green).

The results of 100 battles will be shown. This will show how many battles the attacker and defenders won and what was the damage sustained by the survivor.

Press F9 to recalc to show another 100 battles. After a while you will notice that the Hitpoints and Firepower are quite important in determining accidental outcomes.
 
It was so impressive I started wondering what all those years of math had brought me two (it are only three years of math now, actually. I still have 3 years to go).

------------------
Concordia res parvae cres****.
 
I suppose I've become quite adept at doing spreadsheets because of my job. KobaBOS is relatively simple compared to building spreadsheets to optimise risk-return characteristics (this invloves calculating correlations of different markets and stocks and building efficient frontier).

Having said this, my little piece of work is nothing compared to the hyper accurate formulas based on the binomial distribution method postulated by Keenan and Nemo.
 
Wow! I'm getting dissy reading this....someone hold me before I fall! Oh wait, I'm sitting in a chair, so...

------------------
Concordia res parvae cres****.
 
Will this work with the Excell from Microsoft Office 2000? I don't think it runs quite properly for me.

[This message has been edited by Field Marshal Klesh (edited April 15, 2001).]
 
Originally posted by kobayashi:
Office 2000 should be able to open spreadsheets from earlier versions.
Yeah, I can open it.

Can you define doesn't run properly? (like can't load?)Its not a program so it doesn't actually run. You just key in the numbers and see the results.
Okay, well... I type in the numbers and nothing happens. Page stays exactly the same. I have never used Excel so I don't know if there is a 'run calculations' command that I need to enter? I feel like a moron. <IMG SRC="http://forums.civfanatics.com/ubb/redface.gif" border=0>


[This message has been edited by Field Marshal Klesh (edited April 15, 2001).]
 
Originally posted by willemvanoranje:
Same thing happened to me. Just try the F9 key.



When I hit F9, in the lower left of the screen I see that it says 'recalculating cells'. But again, there are no results. Do I need to look elsewhere for the results or do they appear on the main page?
 
Back
Top Bottom