|
20 Sep 2003, 10:27
|
#1
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
Battle Calc
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
|
|
|
20 Sep 2003, 10:51
|
#2
|
Stealth & Shadows
Join Date: Aug 2001
Posts: 192
|
Atleast someones trying i suppose (-:
|
|
|
20 Sep 2003, 10:52
|
#3
|
I see you!
Join Date: Sep 2002
Location: In any girl
Posts: 2,825
|
To bad everyone got hold of it m8
But the calc rocks, and so do you.. you sure works ur ass off
|
|
|
20 Sep 2003, 10:57
|
#4
|
Nothing Is Forever.
Join Date: Mar 2002
Location: Fallen From Grace.
Posts: 475
|
Glad to see a decent effort finally ..
(note. my calc is my head (: )
__________________
dead.
|
|
|
20 Sep 2003, 11:00
|
#5
|
unknown to all
Join Date: Dec 2002
Location: barca spain
Posts: 199
|
Re: Battle Calc
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
__________________
If i had all the answers, I would pose less questions
Not in any alliance, but to be found in the #LCH channel amongst others. Just wanted that cleared up.
|
|
|
20 Sep 2003, 11:09
|
#6
|
Fightin-irish for life
Join Date: Mar 2001
Location: guinness brewery
Posts: 2,177
|
fair play to u for sharing it
__________________
Ascendancy, now with added Irish
"In the absence of orders, find something and kill it."
-Rommel
|
|
|
20 Sep 2003, 12:22
|
#7
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
Re: Re: Battle Calc
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
|
|
|
20 Sep 2003, 12:29
|
#8
|
Why so serious?
Join Date: Jul 2002
Location: Norway
Posts: 199
|
ph33r teh Kal \0_
__________________
Don't Trust Anyone
4S
Illuminati
|
|
|
20 Sep 2003, 15:06
|
#9
|
pe0n
Join Date: Oct 2002
Location: Kindom of the Netherlands
Posts: 1,347
|
Maybe this will incourage PA team to incorporate the actual numbers in a public bcalc.
__________________
round 5 noob
round 6 noob
round 7 noob: rank 6.198 25:20:25 - VoC member
round 8 noob: rank 4.112 7:2:3 - TFD member
round 9 rank 941 23:1:9 - TFD HC
round 9.5 rank 860 22:7:3 - TFD HC
round 10: rank unknown (was #1 for a while) 5:2:5 - Vengeance pe0n
round 10.5: rank 683 19:10:2 - VGN member
round 11: rank 138 8:8:4 - VsN member
round 12: rank 515 - VGN 'special attack officer' -> jumped ship to Rock
round 13: rank 85: NoS
|
|
|
20 Sep 2003, 16:48
|
#10
|
:alpha:
Join Date: May 2002
Location: London, UK
Posts: 7,871
|
I tested it with some of my breports and it is roughly accurate (give or take 5% losses).
__________________
"There is no I in team, but there are two in anal fisting"
|
|
|
20 Sep 2003, 17:09
|
#11
|
Retired
Join Date: Feb 2001
Location: The Back Porch Bar
Posts: 2,593
|
Time to publish everything, Spinner.
You've been punk'd!
__________________
I'd rather be fishing.
Utterly useless since r3
|
|
|
20 Sep 2003, 17:12
|
#12
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
20 Sep 2003, 18:08
|
#13
|
Ark-miner wannabe
Join Date: Dec 2001
Location: Aug 2007
Posts: 1,005
|
Accurate indeed, only a few k losses wrong.
Nice going Kal
|
|
|
20 Sep 2003, 19:22
|
#14
|
mefs
Join Date: May 2000
Location: Luton
Posts: 334
|
I'd be interested to see the actual stats behind the calc
__________________
Originally posted by HobbieRogue4
My old Wolfpack forum account was quite litterally:
Username: HobbieRogue4
Password: ****petru
I was 'angry' a lot back then. :/
|
|
|
20 Sep 2003, 20:14
|
#15
|
:alpha:
Join Date: May 2002
Location: London, UK
Posts: 7,871
|
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.
__________________
"There is no I in team, but there are two in anal fisting"
|
|
|
20 Sep 2003, 21:48
|
#16
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
20 Sep 2003, 21:48
|
#17
|
mefs
Join Date: May 2000
Location: Luton
Posts: 334
|
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? :|
__________________
Originally posted by HobbieRogue4
My old Wolfpack forum account was quite litterally:
Username: HobbieRogue4
Password: ****petru
I was 'angry' a lot back then. :/
|
|
|
20 Sep 2003, 21:51
|
#18
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
lol, next to the ship classes each ship targets are some numbers...
armour,damage,cost thosoe are the stats
|
|
|
20 Sep 2003, 22:14
|
#19
|
:alpha:
Join Date: May 2002
Location: London, UK
Posts: 7,871
|
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.
__________________
"There is no I in team, but there are two in anal fisting"
|
|
|
21 Sep 2003, 04:51
|
#20
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
thats the forumla for dividing up the damage between ships for any who cares
|
|
|
21 Sep 2003, 11:03
|
#21
|
Proud NoSser
Join Date: Feb 2003
Posts: 43
|
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
__________________
Assimilation is never without some pain, but only for you
Proud to be NoS
My views are my personal views and are not a statement from NoS
|
|
|
21 Sep 2003, 11:40
|
#22
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
21 Sep 2003, 11:54
|
#23
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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
|
|
|
21 Sep 2003, 15:10
|
#25
|
Wearer of The Hat
Join Date: Mar 2001
Location: Bedfordshire, UK
Posts: 252
|
450 Elaphe apprantly don't kill a single zik FR....
|
|
|
21 Sep 2003, 15:33
|
#26
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
maybe i added some bug, sorry, i'll go back and check it all
|
|
|
21 Sep 2003, 15:34
|
#27
|
:alpha:
Join Date: May 2002
Location: London, UK
Posts: 7,871
|
Quote:
Originally posted by DJet
450 Elaphe apprantly don't kill a single zik FR....
|
Elaphe < *
:|
__________________
"There is no I in team, but there are two in anal fisting"
|
|
|
21 Sep 2003, 15:45
|
#28
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
fixed, I had done something stupid :/
|
|
|
21 Sep 2003, 15:47
|
#29
|
Aria's TeddyBear :p
Join Date: Apr 2002
Location: Rhode Island, USA
Posts: 516
|
__________________
Proud to be have been Fyre, NewDawn, NoS - The Illuminati, [ 1u p]
R3 [Acid] peon
R4 - R7 [Fyre] HC
R7 - R8 [ND] HC
R8 - R13 [NoS] MC
R14 - R16 [ 1u p] MO
R17 Retired
|
|
|
21 Sep 2003, 16:16
|
#30
|
NoS forever
Join Date: Jun 2002
Location: Austrian Wastelands
Posts: 92
|
real nice work Kal
__________________
Peace is held through Love, Understanding and Superior Firepower
[NoS] forever
|
|
|
21 Sep 2003, 19:52
|
#31
|
Registered User
Join Date: Dec 2002
Location: Oslo
Posts: 279
|
i cant get it to work
none of my programs can deal with a xls file :\
|
|
|
21 Sep 2003, 20:41
|
#32
|
I see you!
Join Date: Sep 2002
Location: In any girl
Posts: 2,825
|
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?
|
|
|
21 Sep 2003, 21:40
|
#33
|
Retired?
Join Date: Mar 2003
Location: Norway
Posts: 289
|
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??
__________________
Played since round 3 in various alliances: G-II, Elysium, The Brotherhood, NewDawn, VisioN & more
Current status: Will never play again ever!
I was 3:2:2 in round 10 \o/
|
|
|
21 Sep 2003, 21:43
|
#34
|
Registered User
Join Date: May 2002
Location: Somewhere over the rainbow
Posts: 284
|
Impressing
thanks a lot
__________________
thx for reading
|
|
|
21 Sep 2003, 21:56
|
#35
|
Registered User
Join Date: Dec 2002
Location: Oslo
Posts: 279
|
i dont have a excel on my cd tyvm
some1 plz host it online :P
parser etc.
|
|
|
22 Sep 2003, 01:22
|
#36
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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]
|
|
|
23 Sep 2003, 21:24
|
#37
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
I have just been told it loads perfectly with open office and btw its up to version 1.43 now
|
|
|
23 Sep 2003, 23:23
|
#38
|
NewDawn pe0n
Join Date: Oct 2001
Location: #NewDawn
Posts: 313
|
Great work Kal Now if my targets would stop getting def I may finally be able to see how accurate it is
__________________
NewDawn
|
|
|
23 Sep 2003, 23:37
|
#39
|
Das Scoot
Join Date: May 2001
Posts: 788
|
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.
__________________
n00b since Jan 11th, 2001
I don't really know what I'm doing here
|
|
|
24 Sep 2003, 11:37
|
#40
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
24 Sep 2003, 12:31
|
#41
|
used to register
Join Date: Feb 2002
Location: Netherlands
Posts: 979
|
Check Strategy Forum for battle reports Kal
__________________
R1: ??:?? | R2: 51:6 | R3: 37:12 | R4: 186:13 | R5: 13:17 | R6: 1:25
R7: 15:14 | R8: 34:4 / 52:10 ¤ | R9: 16:2 | R9.5: 34:6 / 41:6 ¤
R10: 2:2 | R10.5: 15:4 | R11: 28:8 | R12: 22:9
Damn, outdated and too lazy to edit, retired now
-----
Started playing again Still too lazy to update though
|
|
|
24 Sep 2003, 19:21
|
#42
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
25 Sep 2003, 15:16
|
#43
|
Inactive peon
Join Date: Jan 2003
Posts: 6,050
|
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.
|
|
|
28 Sep 2003, 00:12
|
#44
|
Cabeza Coder
Join Date: Oct 2000
Posts: 212
|
Announcement about Web-based Bcalc:
http://pirate.planetarion.com/showth...hreadid=170372
Greets, Lockhead
__________________
Lockhead
Developer, Solutions Architect, DevOps Engineer
lockhead.net
Quote:
Round 24 Conspiracy HC Comment at my planet
<Germania> 4.9.1
<Germania> hes our top hostile
|
|
|
|
|
All times are GMT +1. The time now is 12:02.
| |