Mopolauta

Elasto Mania board
It is currently 24 May 2017, 10:55

All times are UTC [ DST ]




Post new topic Reply to topic  [ 34 posts ] 
Author Message
 Post subject: Pipe stats
PostPosted: 9 Nov 2016, 21:10 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
>>> Download Pipe stats <<< (4.0 MB)

>>> Download zip with all levels <<< (30.2 MB)

Updated: 20 March 2017

Now includes:
- 131 pipe packs, with a total of 5397 pipes!

- personal times/positions sortable by levpacks
- personal levpack stats for finishes, WRs, and kinglist!!! as well as WR efficiency and average number of points per pack
- levpack rankings for finishes, WRs and kinglist
- separate levpacks for apple battles, multi battles, broken levels and levels with duplicate names
- download links for all levels!


Soo... some of you may remember me asking about various programming and website-related stuff on discord a few months ago. I was hoping to develop my expertise in the field and at the same time create something cool and useful for the community. But it turned out that my gap in the knowledge was so massive that creating this tool in the form of a website would simply take an unrealistic amount of time. Instead, I decided to use the knowledge that I already have and still make the tool. Not in the form of a website or even an application, unfortunately, but a spreadsheet. And so I present to you: pipe stats.

What is it?
- It is a spreadsheet that fetches online times from elmaonline.net and makes basic stats based on them

Why is it pretty cool?
- It is updated on the basis of a worksheet with level indexes from the relevant packs. This means that once those indexes are put to place, times will always be drawn from the correct versions of the levels. Unfortunately the correct versions have to be checked manually, but I do that so don't worry ^^
- It makes it very easy to track your progress through level packs, as it highlights which levels are finished and your percentage completion of level packs. The levels can, of course, be sorted by pack.
- All the nicks that appear in any of the levels are automatically added to the database, so you don't have to worry about registering, submitting your times or anything like that!
- Newly created levels can be easily added. All I need to do is paste in the new indexes and everything else is done automatically.
- Level links are included! So if you feel like checking out this pack, or are missing a few levels, or have some wrong versions, you can just click the links one by one and download the levels. If you want to download a whole pack quickly then copy the indexes you want to a .txt file, open that file in a browser and use "DownThemAll!" extension to download all the files :)
- All the data is in the spreadsheet, so if you find your way around it you can easily play around with it and make your own crazy stats.

What's not that cool (yet)?
- Firstly, it runs through Matlab. Yes, the software for science/engineering-related programming and data processing. Unfortunately it's the only language I feel comfortable in. This means that in order to have the spreadsheet updated, I have to run the Matlab code manually, paste the data into the spreadsheet and upload the new version. It takes me 5 clicks since the majority of the process is automatic, so I can do it at any frequency (or per request), but the plan is to update it roughly weekly (not WR-style-weekly).
- Secondly, for some stupid reason excel drop-down boxes are not searchable, which means that you have to find your nick among the 300+ manually... Thankfully once you select it it stays there ;) You can also type it in (it's case-insensitive)!
- It doesn't contain a great deal of stats for now. However, things such as total times or a compare tool can be very easily coded with the framework that I have now, so I will keep adding new features.

What's important is that this code/spreadsheet can be used to automatically generate stats for any levpack on earth. I'd be more than happy to create a separate, more generic spreadsheet with non-pipe levpacks. All you need to do is send me those indexes :)

And of course I am looking forward to feedback and suggestions for new features! :)

ez,
pawq

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Last edited by pawq on 20 Mar 2017, 06:10, edited 36 times in total.

Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 9 Nov 2016, 21:30 
Offline
Kuski
User avatar

Joined: 13 Aug 2010, 20:31
Posts: 970
[nevermind]


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 9 Nov 2016, 21:52 
Offline
Kuski
User avatar

Joined: 14 Apr 2008, 17:58
Posts: 1458
Location: jkl
Nice stuff, and also nice that it also works in Google Sheets; you could also import the sheet there when updating instead of us having to download it?

Also, I don't know what's going on with the players list but it seems it puts players randomly into 2 alphabetically sorted groups, like

Ali
A.K.B.
Bismuth
Bjenn
Ron
Ropelli
adi
aspec
b0ne
berh
ribot
roope

This makes searching for specific nicks even more annoying :p

Also: where is hazpi pack?)

Also: if you for some reason encounter wrong version of lev being the default what EOL downloads, let me know and I'll fix)

_________________
Team MiE - MiE Cup 1
Prestigious member of 14.6x Tutor14 club


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 9 Nov 2016, 23:02 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
To address your concerns in order:

I didn't know it would work with google sheets o,o I'll try to do that so you don't have to redl!

I thought the same when I saw the player list... But excel is just stupid and sorts according to ansii characters, so it's capitals first, followed by lower-case... Tried to gogel a bit and it seems there's no ez/quick way around that, so I just left it. Thankfully the searching thingy that recognises the nick and looks for times is case-insensitive, so you can type roope, Roope or whatever into the field and it'll work.

The HazPi pack, as well as APipes, mawpis, PawqPs and more are on the way. But obviously there are almost 400 HazPis, so it'll take a while :)

And I'll pm you about default levs.

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 10 Nov 2016, 12:02 
Offline
39mins club
User avatar

Joined: 19 Nov 2005, 10:45
Posts: 4514
Location: Deep in your Imagination, Twirling your Dreams and Weaving your thoughts.
Awesome work Pawq :D

_________________
TT: 39:59:02 | AvgTT: 42:02:00 | Targets: 5 WC, 33 Pro, 16 Good | 20 Australian Records | Cyberscore! |
"Feelings of love are just a temporary lapse in judgement. Like a kind of mental illness." -- Suzumiya Haruhi


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 14 Nov 2016, 02:21 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Just uploaded an updated version (updated link in the first post).

The spreadsheet now contains 50 pipe packs and a total of 3059 levels!

I've also added a ranking of top finishers. This can be shown as a total of all levels, or split by level pack.

Top5 finishers atm are:
RearNakedChoke - 1561 (51.03%)
pawq - 1255 (41.03%)
adi - 1197 (39.13%)
DRACON - 773 (25.27%)
Pab - 717 (23.44%)

Some other notable stats:
- The only person to have finished all APipe's is Pab, the levpack's designer.
- There are 3 people who completed all 3 ChainPipes: Markku, adi & jblaze.
- Nobody finished all HazPi's. Boomer is closest with 393/394. The remaining pipe has only been finished by finman.
- The biggest pipe pack in elma, mawpi, is near completion. The top finisher is adi with 747/770, followed by RearNakedChoke with 562 and DRACON with 225.

The spreadsheet still isn't upped to google sheets as some functionality isn't working there. I will work on it.

Hope you find it useful/interesting!

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 15 Nov 2016, 16:04 
Offline
38mins club
User avatar

Joined: 7 May 2007, 19:24
Posts: 265
Nice job! I wonder if it's necessary to keep broken levs like mawpi348 and/or (impsy) apple battle levs at all in list. At least it would be nice if they didn't count in total. For example my stats are 747/770 but actually I've only 6-7 unfinished mawpi's.

Dunno how to handle mawpi500, both pipes are awesome.

mawpi490 is cool gravity pipe, so I fixed one unworking gravity apple and finished it. I suggest changing it :)

_________________
Team MiE


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 17 Nov 2016, 17:34 
Offline
Kuski

Joined: 7 Oct 2011, 11:41
Posts: 75
Location: Kiev
Interesting thing) Nice work! :beer: Didnt know, that Im 4th in the list. Ofc, many ppl could play and finish levs offline (especially old levs before eol era).


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 20 Nov 2016, 19:18 
Offline
39mins club
User avatar

Joined: 10 Dec 2003, 16:31
Posts: 1451
Location: Lund, Sweden
Max nice initiative pawq!

:beer:

_________________
Team LOS website


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 25 Nov 2016, 02:00 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Ladies and gentlemen, the big update is here!

Download!

The spreadsheet was expanded to 65 pipe packs with a total of 3370 pipes!

The stats were severely upgraded too! See below for a teaser ;)

Image

Unfortunately I wasn't able to upload the spreadsheet to Google Sheets due to a limit in cell number (2mln...), but I will try to find a workaround. Nothing's guaranteed unfortunately.

Next to come... "Download" links for zip archives of all and every pipe pack!

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 25 Nov 2016, 08:28 
Offline
Kuski
User avatar

Joined: 30 Aug 2009, 20:55
Posts: 1580
Location: Uppsala, Sweden.
What does the numbers mean, can't open file don't have excel or sach program
nvm got openoffice, what does the efficiency stat mean though like what does it base that on

_________________
Image
kartoffel


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 25 Nov 2016, 13:05 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
It's really not that hard to check o,o it's what percentage of your finishes are WRs.

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 25 Nov 2016, 21:09 
Offline
Kuski
User avatar

Joined: 30 Aug 2009, 20:55
Posts: 1580
Location: Uppsala, Sweden.
Ok ty I gues I suk then

_________________
Image
kartoffel


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 2 Dec 2016, 04:57 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
The spreadsheet has been updated and now includes 91 pipe packs with a total of 4216 pipes!!!

Download!

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 2 Dec 2016, 07:39 
Offline
Kuski
User avatar

Joined: 16 Jun 2002, 07:36
Posts: 694
Location: Oslo, Norway
coal effort etc. thumbs up butt
seems like would be good project to make automatic updating and instead use some single file embedded html type of thing

_________________
Prestigious member of 14.6x Tutor14 club


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 2 Dec 2016, 20:27 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
It would be indeed. But I can pretty much only code in matlab and I have no idea how to implement automatic matlab updating in any html sort of thing. It's my lil dream to have this online and more interactive, but I just lack the skill/time. If anyone wanted to take it from here they'd be more than welcome to!

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 10 Dec 2016, 01:53 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Updated the data in the spreadsheet.

Download

Image

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 13 Dec 2016, 07:07 
Offline
Kuski
User avatar

Joined: 21 Feb 2016, 17:59
Posts: 251
request: download zip of all levels and elma levelpack thingy with all levels (i never use levelpacks feature so forgot how to make, it was some txt file or what?)

_________________
Image


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 13 Dec 2016, 15:49 
Offline
Kuski
User avatar

Joined: 31 Dec 2012, 18:07
Posts: 644
Location: Oslo, Norway
Vermin Supreme wrote:
request: download zip of all levels and elma levelpack thingy with all levels (i never use levelpacks feature so forgot how to make, it was some txt file or what?)


You have to put levpack name and key (and .txt output) into eolconfig. Top right corner iirc.

_________________
My fake plants died because I did not pretend to water them.


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 13 Dec 2016, 22:55 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
There ya go:

https://drive.google.com/open?id=0B2Pr58R_gw1pc1lMdDJCYkcxM3M

Also added link to first post. I think it's going to be okay for people to just download this zip and extract only those levels they want (I assume everyone can scroll). I'd have to spend a few hours making separate zip's for each levpack and I just don't think it's necessary. If anyone has a very good argument for doing that then please come forward =)

Vermin Supreme wrote:
request: (...) elma levelpack thingy with all levels
I never used that feature and have no idea how to touch it so ;-(

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 14 Dec 2016, 03:28 
Offline
Kuski
User avatar

Joined: 21 Feb 2016, 17:59
Posts: 251
thanks

_________________
Image


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 15 Dec 2016, 02:01 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Another update is here, and the spreadsheet now includes 119 pipe packs with a total of 5004 pipes!!!

Download the latest spreadsheet! (3.6 MB)

Download a zip with all levels! (28.1 MB)

Until now I've still had some bits and pieces of pipes in various places, but as of now I've literally run out of packs, so I will only expand the spreadsheet if new packs are brought to my attention - please do this as I'm sure there are plenty I've missed!

I've separated apple battles and multi battles (only those impossible to finish), as well as broken levels (those with apples/flowers in ground) into separate "packs" so as not to spoil actual pack stats.

There's also a duplicate folder - these are all those that occurred with exactly the same name, but were both completely different valid levels (in some cases even both were battled). Copying these into your lev folder will obviously result in some "overwrite?" prompts, so please be cautious about this. I decided to include them separately so as not to lose/forget them forever, but you can ignore them at your leisure.

I've also added date stamps to both the spreadsheet and the pipe archive. This should help with bookkeeping : )

Cheers! :beer:

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 15 Dec 2016, 09:08 
Offline
Kuski
User avatar

Joined: 21 Feb 2016, 17:59
Posts: 251
missing japti levels at least, can be downloaded from my site some of them

_________________
Image


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 16 Dec 2016, 09:55 
Offline
Kuski
User avatar

Joined: 21 Feb 2016, 17:59
Posts: 251
BZPxxx is in .zip and they are not pipes

_________________
Image


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 16 Dec 2016, 12:53 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Already picked up by adi, but thanks! They'll be removed in the next update. (Same with Elvlp??)

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 17 Dec 2016, 21:22 
Offline
Kuski
User avatar

Joined: 15 Dec 2011, 01:07
Posts: 296
Location: Norway
I answer'ed your discord chat. :) Sik work this. I will look at it someday. :)

_________________
Image
[13:22:24] (ImagebEAT) blaz super pro
[17:06:15] (ImageRamone) ok I suckj. blaz rules


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 20 Dec 2016, 16:28 
Offline
Kuski

Joined: 27 Jul 2013, 16:23
Posts: 224
I'm late to the boat but for future reference, if want to download an individual pack, you could put link in excel file to url as such:

elmaonline.net/downloads/battles_lev_zip/-365675-365676-365677-365678-365679-365680-365681-365682-365683

using level ids

_________________
>>>ALL CONTRIBUTIONS<<<

DINO RUN 2 | FANCYPIC.EXE | SPINBOOSTING | Best public int replays


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 22 Dec 2016, 00:21 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Wooo, does this automatically zip and dl the levs? Can't try now.

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 12 Jan 2017, 06:37 
Offline
Kuski
User avatar

Joined: 28 Aug 2010, 22:17
Posts: 210
Location: +∞
Cool, thanks! :beer:

_________________
RiP Mawane ((


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 2 Feb 2017, 23:19 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Pack and spreadsheet updated! They now include 131 pipe packs with a total of 5327 pipes!

Download the latest spreadsheet! (3.8 MB)

Download a zip with all levels! (29.9 MB)

updates:
- moved aappie29 to broken levs
- removed BZP0xx (non-pipe)
- removed ELVLP (non-pipe)
- added VOU
- added PToolFF
- added TL packs: 0hjus, 0ilpipe, 0melet, 0ntelo, 0rava, 0rja, 0tsoni

Cheers! :beer:

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 3 Feb 2017, 19:43 
Offline
38mins club
User avatar

Joined: 7 May 2007, 19:24
Posts: 265
Oo finally! Haven't really played for weeks but now I went through all unfinished pipes and gathered them here:

http://kopasite.net/up/ahk4nczwquuek61/pipelist.txt

I guess broken pipes should be removed at some point. But dunno about impsy hard/impsy pipes...those are too hard for me to finish even with sl. I also collected "ez" unfinished pipes for myself. Actually some of them are also pretty impsy like penapies but at least finishable with saveload.

_________________
Team MiE


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 3 Feb 2017, 22:09 
Offline
38mins club
User avatar

Joined: 5 Jun 2003, 22:48
Posts: 284
Location: Lizard lounge
Here are a few more levels for the duplicate names folder, completely different versions than the ones currently in the pack.

CMcPP21.lev http://elmaonline.net/statistics/level/369739 (current pack has http://elmaonline.net/statistics/level/60689)
infpipe1.lev http://elmaonline.net/statistics/level/369743 (current pack has http://elmaonline.net/statistics/level/91371)
infpipe2.lev http://elmaonline.net/statistics/level/369744 (current pack has http://elmaonline.net/statistics/level/91370)
MLPpi015.lev http://elmaonline.net/statistics/level/369808 (current pack has http://elmaonline.net/statistics/level/32168)
MLPpi016.lev http://elmaonline.net/statistics/level/369809 (current pack has http://elmaonline.net/statistics/level/32169)
MLPpi018.lev http://elmaonline.net/statistics/level/369810 (current pack has http://elmaonline.net/statistics/level/32172)


I also scanned the pack for identical levels with different filenames, using Smibu's Level manager. I guess it doesn't make sense to remove levs at least from complete packs, but just for reference, these levels are identical:

0melet12 == 0melet13
0rava59 == 0rava60
0rava63 == 0rava99
0rava71 == 0rava72
0tsoni02 == 0tsoni03

CMcPP16 == eaPipe06
CMcPP17 == eaPipe07
CMcPP18 == eaPipe08
CMcPP19 == eaPipe09
CMcPP20 == eaPipe10

D0305L04 == PLP15

infpip10 == infpipeX
infpip37 == infpip38
infpip40 == infpip41 == infpip42

PC05 == XZpipe04
PLP14 == XZpipe01

_________________
Prestigious member of 14.6x Tutor14 club


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 18 Mar 2017, 03:33 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Pack and spreadsheet updated!

Download the latest spreadsheet! (3.8 MB)

Download a zip with all levels! (29.9 MB)

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
 Post subject: Re: Pipe stats
PostPosted: 20 Mar 2017, 06:12 
Offline
Kuski
User avatar

Joined: 24 Aug 2008, 19:56
Posts: 5433
Location: Southampton, UK
Pack and spreadsheet updated!

Download the latest spreadsheet! (4.0 MB)

Download a zip with all levels! (30.2 MB)

A bunch of broken levels were moved to the broken pack, some duplicates added, some moved, + 70 new battle pipes added.

np)

_________________
Image
Team TR
Multi WR in Labyrinth with GRob
Best Internal Total Times, Pipe stats & Pipe archive
World kuski map, World Cup stats


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 34 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group