FAQ: Rankings and statistics

[jlehtone]

I say thanks, cos now I can work out my factory potential total profit/hr

How does one "work out"? There are couple things I'd like to calculate, but parsing XML is not yet in my repertoire.

[Geggo]

I say thanks, cos now I can work out my factory potential total profit/hr

How does one "work out"? There are couple things I'd like to calculate, but parsing XML is not yet in my repertoire.

Import to excel and let it chew it.

hmm. I seem to have lost atleast 150 active satelites after last nights Incursion to Xenon space, damned ie is not letting me see past 25 first results. and I'm prophibited from installing firefox at work.

[jlehtone]

No excel here and oocalc ain't chewing on first bite. Time to use the larger hammer.

[exogenesis]

No excel here and oocalc ain't chewing on first bite. Time to use the larger hammer.

You can get the xml file into OO-calc by renaming it a .txt file and file-open in calc as a CSV file.
Since there's no macros scripting language in calc (?), to calculate the total factory profit/hr you could e.g.
find & replace all <profit value=" with empty-string, then replace all " /> similarly.
This will turn all the 'factory profit' cells into numbers rather than text,
then a simple =SUM(Dxx:Dyy) at the bottom would add them up (it treats each text containing cell as value 0).

EDIT: spelling : OO not OOS

[TBV]

What happens if you want to upload stats from a different game?

I assume that only one set of stats per player can be displayed.

I suppose I could just try it and see what happens.

[Gimlis]

All I ever used were the patches and bonuspack. Somewhere along the line something triggered the "modified" tag in my game. It was annoying at the time, as I had never opened the script editor.

same here latest Bonus pack and 2.5 patch no other mods or scripts have been installed or used. I had started a non plot game using the custom game option a while ago and it's marked as modified even though it's in an unmodified universe .

any way I did some checking and found that starting a game using the custom game in X-Universe option results in a game with the modified tag despite lack of any mods or scripts.
all other starts work without adding the modified tag..

so to those with a modified tag it may have been caused by choosing custom game and not due to a bugged patch or bonus pack script.
either way it seems the only way to loose that tag is to start over using one of the other games starting options

[jlehtone]

You can get the xml file into OO-calc by renaming it a .txt file and file-open in calc as a CSV file.

Amazingly that works, but I might learn to use Python and XML for more fun.


Edit:

same here latest Bonus pack and 2.5 patch no other mods or scripts have been installed or used. I had started a non plot game using the custom game option a while ago and it's marked as modified even though it's in an unmodified universe .

Tested both 2.5 and 2.0.02 for that start. Both yield the tag. The map is said to be unsigned, so the tag is not from 2.5.

[killershoe]

any way I did some checking and found that starting a game using the custom game in X-Universe option results in a game with the modified tag despite lack of any mods or scripts.
all other starts work without adding the modified tag..

Well that explains why my game is getting marked. I hope there is way to change this I have logged a lot of time into this game.

[Gimlis]

any way I did some checking and found that starting a game using the custom game in X-Universe option results in a game with the modified tag despite lack of any mods or scripts.
all other starts work without adding the modified tag..

Well that explains why my game is getting marked. I hope there is way to change this I have logged a lot of time into this game.

Yeah for those who put alot of time into building an empire under that start I hope so to.
for me it was my 2nd start and I only put a little time into it so starting over wasn't that much of a set back,, still a bummer but one I'll get over it...

[pjknibbs]

But a custom start IS a modified start. Someone using that start could be playing in an entirely different universe to someone using a normal start--therefore there's no realistic way for Egosoft to provide a means to remove the Modified tag on those games.

[jlehtone]

Little bit of Python (never used before), and I get XML->CSV->neat oocalc tables.

Now ships have "price" and "ware". Apparently the price is for the plain ship, for Pandora tuned and regular Dragons have same value. So upgrades, tunings, and cargo must be in ware. <edit> Tunings are in "ware". </edit>

"Price" for Mammoth is ~22 mil and that you probably get if selling. There are three odd ones: Phoenix, Titan, and Colossus. The "price" for Phoenix is <edit>89 mil</edit>, and you can buy one for 69 mil.

Incidentally Phoenix, Titan, and Colossus have "special" resource requirements if you are building them in your HQ, so no news, just affirmation of "strangeness".

So, if you want big "assets", be a Teladi and buy Phoenix en masse.

[Gimlis]

But a custom start IS a modified start. Someone using that start could be playing in an entirely different universe to someone using a normal start--therefore there's no realistic way for Egosoft to provide a means to remove the Modified tag on those games.

Yes you can use the custom start to play in a modified or seperate user created universe. But You can also use it to start in the un-modified X-universe minus the plot, which is realy no different than using Bankrupt Assasin or Argon merchant. the modified tag should'nt be there unless Mods unsigned scripts or an alternate universe are used.

So many players who did not use a modified universe or unsigned scripts are stuck with a modfied tag.

Stats or not either way I still enjoy the game....

[Jiggaman]

Does Bonus Pack stuff tagged the game as modified? Just did a clean install, and I want to do this from the right way right now.

[Stormsong]

Does Bonus Pack stuff tagged the game as modified?

If you mean the official Bonus Pack, then no it doesn't.

[jlehtone]

Regarding PlayerStats.pck:

I was looking at the <favourite_ships> node and found no entries for Hyperion, Eclipse, Chimera, Medusa, nor LX within, although I definitely have flown them a bit.

Furthermore, the sum of favorites is 3 days short of game time (42 days), but that can be partly explained by station visits?

[Sandalpocalypse]

I think it's fascinating how the major discrepancy between Modified and Unmodified games is that the worth of assets - 1.7 trillion compared to 300 billion! I wonder how much of that is due to one or two extraordinary games ?

[jlehtone]

Very expensive ships and Ashley's Fabs, I think. With those Fabs you can build complex of 20 XXL just as easily as you do 20 L in unmodded, only the "asset value" is larger (would that turn 300 bil to 1.2 tril?). And you can capture Capital ships with right scripts, don't you? So in modded game you collect Terran Carriers, while unmodded gathers Pirate Busters. Such things do add up.

[WillWilk]

- at present, there are some very strange statistics

X3 tables showing the leader on 100%,
followed by 17% in second place, make me wonder..

- of course, I could be wrong, though..

- in the number-of-cups-of-tea-consumed-during-gameplay table,
- I should be pretty high..

The strangest statistic I've found so far is that for "Lasers fired per hour" - the top ranked player (SymTec ltd.) doesn't appear AT ALL in the Lasers fired or Laser hit efficiency tables (I've searched to the end of both of these). This makes me think that there may be some bugs in the stats code or invalid data in the database. The hit efficiency table in particular makes me think that this entry is wrong as the last place in this table shows zero percent so I'd expect all the players who have uploaded stats to appear in it.

Will

[jlehtone]

... or invalid data in the database.

What if the "Foo/hour" values are calculated on submission and stored in tables rather than recalculating on the fly? Query optimization. And that Symtec's entry might be a bit of test data entered before release, but not properly cleared. During the first days the tables did show other entries too that were clearly from testers, but do not show any more.

[pjknibbs]

The strangest statistic I've found so far is that for "Lasers fired per hour" - the top ranked player (SymTec ltd.) doesn't appear AT ALL in the Lasers fired or Laser hit efficiency tables (I've searched to the end of both of these). This makes me think that there may be some bugs in the stats code or invalid data in the database.

As I said in another thread, that value is a holdover from a test game Symtec uploaded while the patch was still in beta where he basically loaded a new game and emptied his guns for 30 seconds into the nearest target. The bug is that he's now uploaded a new game that should have replaced those stats, but for some reason it has not.