Browse
Category
DiscussionsPuzzles / Events

Datapuzzle [Solution posted]

Open
slowpard

I love Tropico series and, in my humble opinion, the 4th part is the best. So I decided to giveaway one copy of full Tropico 4 bundle with all DLCs.

But I won't give a paradise island with blackjack and whores bananas and rebels without making sure that the future El Presidento will cope with the burden of country management.

So here is some obscure dataset (excel version, Google Docs version) (it's quite similar to these economic reports on inflation, interest rates, RUBUSD non-deliverable forward rates and other strange things which nobody understands). Prove that you won't need counsellors (or talking bananas) who one day might stage a coup d'etat!

BONUS BUNDLE TRAIN

Here we go: A Puzzle

Solution for bonus bundle-train: VBx9w - these are local extreme points (minimums/maximums).
Solution for Tropico puzzle: a8yzL

You could build a regression model and then find anomal values for the dependent (second in this case) variable, but the easiest way is to build a plot - I used R, but you can build such a plot even with GDocs (also remember a hint about case of the letters, I think, now it's quite obvious):

View attached image.
9 years ago*

Comment has been collapsed.

58 Comments
perrolijo

Ok I downloaded the file. First step complete.
I opened the file. Second step complete :)
I understand nothing. FML :D

Bump

9 years ago
Permalink

Comment has been collapsed.
slowpard

Try to find some dependency.

9 years ago
Permalink

Comment has been collapsed.
slowpard

I wonder whether my poor sense of humour (or English?) scares off people or complexity of the puzzle does that? :D

9 years ago
Permalink

Comment has been collapsed.
perrolijo

Maybe it is the fact of downloading an unknown file :/
But I downloaded it (in a virtual machine) and it is only plain text ^^

9 years ago
Permalink

Comment has been collapsed.
slowpard

Added excel and GDocs versions.

9 years ago
Permalink

Comment has been collapsed.
Starlynk

I'll give it a shot when I get home later today :-)

9 years ago
Permalink

Comment has been collapsed.
DarkMercy

Interesting puzzle but its beyond me. Tried manipulating the data a few different ways and no luck. Oh well, not like I could enter the GA anyway.

9 years ago
Permalink

Comment has been collapsed.
slowpard

Bump for the sake of econometric gods.

9 years ago
Permalink

Comment has been collapsed.
chour

After some most basic 'exploration' found <redacted> which are <redacted>, but it gave me nothing. Well, not exactly nothing but one name which I don't think I can apply anywhere. So stuck there.

9 years ago*
Permalink

Comment has been collapsed.
iracional88

I have the game, but dataset is a dataset, so here goes :P
EDIT: As OP requested.

9 years ago*
Permalink

Comment has been collapsed.
slowpard

Think about letter case.

9 years ago
Permalink

Comment has been collapsed.
chour

Thanks for that. Solved!

9 years ago
Permalink

Comment has been collapsed.
iracional88

EDIT: Yeah, tried a few things, but will think on it more.
Thank you for the puzzle, in any case :D

9 years ago*
Permalink

Comment has been collapsed.
slowpard

You're giving too much hints, please, edit your messages, especially, the first one. :)

9 years ago
Permalink

Comment has been collapsed.
iracional88

Done. Sorry, didn't realize it.

9 years ago
Permalink

Comment has been collapsed.
slowpard

OK, no more hints, but an additional giveawyay of Cities: Skylines added, link is in Tropico GA.

9 years ago
Permalink

Comment has been collapsed.
Starlynk

Didn't bump for solve yet, so here it is!

This really isn't as hard as it seems people :-) but I guess it helps that data analysis is a big part of my daily job :-P

9 years ago
Permalink

Comment has been collapsed.
IvanRed

Bump for solved. Nice puzzle indeed.

9 years ago
Permalink

Comment has been collapsed.
slowpard

Bump bump bump.

9 years ago
Permalink

Comment has been collapsed.
Homero

Not sure if I found something or just a coincidence.

9 years ago
Permalink

Comment has been collapsed.
Plimsoll

bump for economy

9 years ago
Permalink

Comment has been collapsed.
Loops

Feel a bit cheated because I missed all the hints... :P

9 years ago*
Permalink

Comment has been collapsed.
slowpard

There were no hints, which you can't find here now. :)

9 years ago*
Permalink

Comment has been collapsed.
Loops

There are a lot of <redacted> and deleted posts above I sure would have liked a peek at though.

9 years ago
Permalink

Comment has been collapsed.
slowpard

Yep, I asked to remove one post, because it was almost a plain answer there. :)

Try not to overcomplicate things, almost everyone who solved it said that it was quite easy, so don't think about removed 'hints'.

9 years ago
Permalink

Comment has been collapsed.
perrolijo

Bump for solved, without the <redacted> hints
(come on Loops, you can!)

9 years ago
Permalink

Comment has been collapsed.
Arynia

I have absolutely no idea where to start with this one xD

9 years ago
Permalink

Comment has been collapsed.
Nordhbane

The wife's got two games on her wishlist, Skylines is one of them. Would have loved to figure this one out, but after sorting back and forth, this way and that, bruteforcing and what not, I'm gonna have to give up. Either I'm missing an obvious hint, or it's just not my forte.

9 years ago
Permalink

Comment has been collapsed.
slowpard

Bump.

9 years ago
Permalink

Comment has been collapsed.
SilentGuy

Hm, a lot of numbers, a lot of interesting statistics to generate, but so far, no luck

9 years ago
Permalink

Comment has been collapsed.
ercalote

Does the solution depend on the tools you use? I mean there can be small differences even if you use same methods but with different software.

9 years ago
Permalink

Comment has been collapsed.
slowpard

No, differences are quite large, Actually, you don't need to calculate anything (at least, anything complicated, it depends on a solution).

9 years ago*
Permalink

Comment has been collapsed.
SilentGuy

Now I'm even more confused...

9 years ago
Permalink

Comment has been collapsed.
mandrill

bump for solved

9 years ago
Permalink

Comment has been collapsed.
Klinge

Bump for still some time left to solve this!

9 years ago
Permalink

Comment has been collapsed.
SilentGuy

Bump for thanks for reminding me and solved ;)

9 years ago
Permalink

Comment has been collapsed.
slowpard

Bump for less than 24 hours left for C:S.

9 years ago
Permalink

Comment has been collapsed.
ercalote

I have found 2 very interesting things about the dataset, but still do not understand how to apply them to get the solution..

9 years ago
Permalink

Comment has been collapsed.
theBlindOne

Bump for finally solved. :D

9 years ago
Permalink

Comment has been collapsed.
slowpard

7-hours-Cities-Skylines-bump.

9 years ago
Permalink

Comment has been collapsed.
perrolijo

22 minutes remaining Cities-Skylines

9 years ago
Permalink

Comment has been collapsed.

Sign in through Steam to add a comment.