Planetarion Forums

Kal · 20 Sep 2003, 10:27

It has come to my attention that certain alliances I don't like all that mugh got hold of my bcalc, so I thought it was time everyone got to use it if they so wish.

I will caution that it is not 100% accurate and may still have lots of bugs. BUT from testing so far on straight combat it seems to be accrate enough for most purposes. I would like feedback on the roid protection part though as that has not been tested.

Also if anyone feels like making a php version with parsers please contact me.

to contact me use this email address - [email protected]

http://members.lycos.co.uk/kalvirtus/supercalc.xls

Anakin · 20 Sep 2003, 10:51

Atleast someones trying i suppose (-:

Nadar · 20 Sep 2003, 10:52

To bad everyone got hold of it m8

But the calc rocks, and so do you.. you sure works ur ass off

DarkAngel · 20 Sep 2003, 10:57

Glad to see a decent effort finally ..

(note. my calc is my head (: )

waassaa · 20 Sep 2003, 11:00

Quote:

Originally posted by KalVirtus
It has come to my attention that certain alliances I don't like all that mugh got hold of my bcalc, so I thought it was time everyone got to use it if they so wish.

first off, great work, played through a few battle reports and its quite close....

but..

which alliances got it that u don't like

waassaa

[]LCH[] HC

gzambo · 20 Sep 2003, 11:09

fair play to u for sharing it

Kal · 20 Sep 2003, 12:22

Quote:

Originally posted by waassaa
first off, great work, played through a few battle reports and its quite close....

but..

which alliances got it that u don't like

waassaa

[]LCH[] HC

don't like was a bit harsh on my part, i don't dislike any planetarion alliance, but i do like some more than others... and i guess a certina amount of bitterness might still exist over a certain war on round 9

[i2k]Xy · 20 Sep 2003, 12:29

ph33r teh Kal \0_

Gerbie · 20 Sep 2003, 15:06

Maybe this will incourage PA team to incorporate the actual numbers in a public bcalc.

Tomkat · 20 Sep 2003, 16:48

I tested it with some of my breports and it is roughly accurate (give or take 5% losses).

Cochese · 20 Sep 2003, 17:09

Time to publish everything, Spinner.

You've been punk'd!

Kal · 20 Sep 2003, 17:12

wheres the fun in that though someone should be writing some funky tools to crack the exact stats.

shoudl work along the lines of:

standard bcalc with scan parers etc

BUT with:

combat report parser - u say which side u were, and what your ptiorities were

system them gradually improves the stats overtime as more reports are pasted, leading to an increasingly more accurate calc.

dabult · 20 Sep 2003, 18:08

Accurate indeed, only a few k losses wrong.

Nice going Kal

Petru · 20 Sep 2003, 19:22

I'd be interested to see the actual stats behind the calc

Tomkat · 20 Sep 2003, 20:14

Quote:

Originally posted by Petru
I'd be interested to see the actual stats behind the calc

You click on the cells. In the top it shows you.
It's just some basic "IF" commands.

Kal · 20 Sep 2003, 21:48

yep, its all quit simple really

u just have damage stats armour stats, then a weighting that u work out by looking at a couple of early combat reports to see how they relate. then its all simple really.

I do admit that i kinda fudged ship proorities due to silly excel only being able to handle a certina number of nested if statements, + there are some assumptions involved as well on what certina things in the manual and the game actually mean. But on the whole its straight forward, I mean I wouldn;t call myself a techie or stats expert or anything, I just wanted a simple innacurate bcalc... but then other people seemed to want proper features so it kinda evolved.

Petru · 20 Sep 2003, 21:48

Quote:

Originally posted by Tomkat
You click on the cells. In the top it shows you.
It's just some basic "IF" commands.

I may be an Excel noob (and am, freely admitted), but where in....

=IF(B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35=0,0,(B4/$O4)*(($A$43-$A$46))/(B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35))

This, does it show me stats? :|

Kal · 20 Sep 2003, 21:51

lol, next to the ship classes each ship targets are some numbers...
armour,damage,cost thosoe are the stats

Tomkat · 20 Sep 2003, 22:14

Quote:

Originally posted by Petru
I may be an Excel noob (and am, freely admitted), but where in....

=IF(B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35=0,0,(B4/$O4)*(($A$43-$A$46))/(B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35))

This, does it show me stats? :|

It means:
If B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35=0
then the answer in the cell is 0.
If not, it is (B4/$O4)*(($A$43-$A$46))/(B$4+B$5+B$12+B$13+B$20+B$21+B$22+B$28+B$29+B$35))

I can't be bothered the check the exact cells.

Kal · 21 Sep 2003, 04:51

thats the forumla for dividing up the damage between ships for any who cares

Borg · 21 Sep 2003, 11:03

sweet work m8, and as to understanding how it works , well I am wayyyy tooo thick for that.
It works, thats what counts, and the +-5% inaccuracy just leaves a little spice in the calc, I have played games with relish where the calc had a 15-20% inacurracy built in but still had lots of fun winning or losing

Again, well done m8

Kal · 21 Sep 2003, 11:40

I just discovered a bug in how damage is assigned to individual ships. If you set up up so one side has say 2-3 different fi, and it is meant to loose all fi... it won't in fact some fi will loose more that there originally were. I'm not entirly sure how to fix this, so if anyone has any ideas please get in touch.

Kal · 21 Sep 2003, 11:54

I *think* I have worked out how to fix it, and I *think* it will lead to more accurate calcs in general. I will put an updated version up later today or tomorrow. I will also add in total number of resources lost by attackers and defenders

Kal · 21 Sep 2003, 12:30

new version uploaded with the same url

http://members.lycos.co.uk/kalvirtus/supercalc.xls

this should be more reliable on calcs with nearly all ships dying

DJet · 21 Sep 2003, 15:10

450 Elaphe apprantly don't kill a single zik FR....

Kal · 21 Sep 2003, 15:33

maybe i added some bug, sorry, i'll go back and check it all

Tomkat · 21 Sep 2003, 15:34

Quote:

Originally posted by DJet
450 Elaphe apprantly don't kill a single zik FR....

Elaphe < *

:|

Kal · 21 Sep 2003, 15:45

fixed, I had done something stupid :/

Doorsdown · 21 Sep 2003, 15:47

doing great work kal

Darkness · 21 Sep 2003, 16:16

real nice work Kal

das_experiment · 21 Sep 2003, 19:52

i cant get it to work

none of my programs can deal with a xls file :\

Nadar · 21 Sep 2003, 20:41

Quote:

Originally posted by das_experiment
i cant get it to work

none of my programs can deal with a xls file :\

lmao.. Dont come tell me that you dont have Excel on your windows CD?

Eventh · 21 Sep 2003, 21:40

Quote:

Originally posted by Nadar
lmao.. Dont come tell me that you dont have Excel on your windows CD?

I dont got excel on my windows cd??

Hurragutten · 21 Sep 2003, 21:43

Impressing

thanks a lot

das_experiment · 21 Sep 2003, 21:56

i dont have a excel on my cd tyvm

some1 plz host it online :P

parser etc.

Kal · 22 Sep 2003, 01:22

i'm going to clean up the formulas in excel tomorrow ot make them easier for others to follow.

If anyone wishes to help make a php based system with parsers please get in touch, the more the merrier.

email me at [email protected]

Kal · 23 Sep 2003, 21:24

I have just been told it loads perfectly with open office and btw its up to version 1.43 now

TehVader · 23 Sep 2003, 23:23

Great work Kal

Now if my targets would stop getting def I may finally be able to see how accurate it is

Scoot951 · 23 Sep 2003, 23:37

Quote:

Originally posted by das_experiment
i cant get it to work

none of my programs can deal with a xls file :\

I think M$ has an Excel viewer for free.

Kal · 24 Sep 2003, 11:37

A combat issue was highlighted in a conversation yesterday. It seems spinner made things a lto more complicated that we previously thought. Hence I would appreciate people sending me any combat reprots they have which were set to mixed/mixed and no war (also telling me which side they were on) and then i can attempt to adjust for spinners deviousness. Until that is done I would recoomend only trusting the calc as a very rough guide.

General Martok · 24 Sep 2003, 12:31

Check Strategy Forum for battle reports Kal

Kal · 24 Sep 2003, 19:21

Now upto version 2 thanks to the Lockhead, Focht and NB3. With some mysteries still in the pax combat formula I have adjusted the calc to show more losses so that we have a worst case scenario. I have also adjusted the priorities system after a conversation with NB3. The major thing left now is that the roid protection scheme may be entirly wrong, or may need some weighting. So if people failt to cap roids when the percentage is below 100% please let me know and mail me the combat report.

[email protected]

http://members.lycos.co.uk/kalvirtus/supercalc.xls

This should load fine in excel or open office.

A fully web based version is the works by various people, and hopefully will be ready soon.

Again thanks to Lockhead, Focht, NB3 and all others who have helped improve this.

Kal · 25 Sep 2003, 15:16

http://members.lycos.co.uk/kalvirtus/PaXCalc.xls

Lots of new features and bug fixes bring us up to version 3.0 I apologise to people who calced with Version 2.x there was a major Crusier bug which meant some people lost Cruiser fleets. this has now been fixed and lots of requested features have been implemented.

I can tell you that hopefully soon a proper web based calc will be available but it won't be as feature complete as the excel version initally... This does of course require that a certain alliance does release it, but I am confident that they will.

Lockhead · 28 Sep 2003, 00:12

Announcement about Web-based Bcalc:
http://pirate.planetarion.com/showth...hreadid=170372

Greets, Lockhead