knyttlevels.com spreadsheet - filter by category, screen count, & more

  • 11 Replies
  • 1593 Views
*

Offline Pie_Sniper

  • 109
  • 14
    • View Profile
Go to spreadsheet
Last updated: 2024-08-07

You must make a copy of the spreadsheet (File -> Make a copy) if you want to use the filters.

I downloaded every level from knyttlevels.com and wrote a program to collect metadata about them. I have made that data available in a spreadsheet at the above URL along with a rudimentary interface for filtering and sorting levels by various criteria.

The data includes:
  • Original name, author, upload date, and URL from the level archive
  • World.ini fields: Name, Author, Description, Categories, Difficulties, Size, and Format
  • Screen count
  • Auto-detected KS edition (e.g. KS Plus, KS Ex)
  • Directory stats: file count, total unpacked size, Map.bin size, and World.ini size

Please let me know if you find any inaccuracies. At this time, I am aware that it wrongly detects a few levels as KS Advanced levels. The reason is they contain bank 254 objects 1-22 without any [Custom Object B#] or [Templates] sections and use only vanilla features besides. I suspect these objects were placed accidentally when the designer thought they had bank 255 selected. Unfortunately, this case is virtually impossible to detect programmatically.

*

Offline Purple Ink

  • 413
  • 41
    • View Profile
Really cool stuff! Thanks for sharing. :)

*

Offline pacifishi

  • 58
  • 11
  • Av intet blir intet
    • View Profile
Awesome!

A 'key/legend' tab may be useful - Here are some descriptions from the level editor

            
Category                              
Tutorial - A tutorial that teaches you to play Knytt Stores and contains tips and tricks.            
Challenge - A Challenge level - make sure your skills are sharp!            
Puzzle - In a Puzzle level, you need some serious thinking            
Maze - A Maze Level - Can you find where you're going?            
Environmental - An environmental level - No puzzles, no challenge, just beautiful landscape.            
Playground - A Playground doesn't have an ending or a goal - a good place to practice.            
Misc - A level that doesn't fit into any of the other categories.            
               
Difficulty                        
Easy   - An easy level.            
Normal - A normal level.            
Hard - A hard level.            
Very Hard - Be prepared for a challenge!            
Lunatic - A ridiculously hard level.            
               
Size                           
Small - A small level.            
Medium - A medium sized level.            
Large - A large level.            
               
Format                           
0 - ?         
1 - ?      
2 - ?      
4 - ?

Edition (download links)
Vanilla - https://nifflas.ni2.se/games/
Plus - http://egomassive.com/ks/
Extended - https://grayface.github.io/ks/
Advanced - https://nifflas.lp1.nl/index.php?topic=761.15

*

Offline pacifishi

  • 58
  • 11
  • Av intet blir intet
    • View Profile


















Quick graphs based on the data (hopefully these pictures aren't too large!)

Useful equations for others to mess around with the spreadsheet:

=unique(range)   Returns unique values in a range, discarding duplicates
Example: =unique(D:D) would show all unique 'Category A' descriptions

=countif(range, criterion)   Returns a conditional count in a range
Example: =unique(D:D, W2) where cell W2 = Puzzle would show the number of times 'Puzzle' appears in 'Category A'

=SUMPRODUCT(--(ISNUMBER(FIND(criterion, range))))   Returns a conditional count in range, includes partial matches
Example: =SUMPRODUCT(--(ISNUMBER(FIND(X2, N:N)))) where cell X2 = 2008 would show the number of times '2008' appears in 'Archive.Date (UTC)'

=countblank(range) Returns count of blank cells in a range
« Last Edit: August 14, 2024, 20:58:56 by pacifishi »

*

Offline Lucinda

  • 142
  • 32
  • Projectors for eyes
    • View Profile
Fascinating and surprising charts, Fishi
Rome wasn't built in a day.

*

Offline pacifishi

  • 58
  • 11
  • Av intet blir intet
    • View Profile
Fascinating and surprising charts, Fishi

I'm interested with what or who caused the resurgence in activity in 2018...

Also, from digging around it seems like the format values relate to compatibility depending on what version of KS you have. Is this right?

format=0 (compatible with 1.0.4, 1.1.0, 1.2.1, KS+)
format=1 (compatible with 1.1.0, 1.2.1, KS+)
format=2 (compatible with 1.2.1, KS+)
format=4 (compatible with KS+, activates extra features)



*

Offline Pie_Sniper

  • 109
  • 14
    • View Profile
Great charts, pacifishi. What does the "File Count / Upload" chart show? I'm not sure what its x axis is.

As for the formats, yes, they indicate compatibility. I know Format=2 is compatible with the last official KS release, Format=3 is KS Ex, and Format=4 is KS+. I don't know specifically which were the first versions to use Format=1 and Format=2 but I would guess you're right. The KS Ex editor doesn't automatically set the format to 3 when you make a new level, so I think that's why no levels declare that format on the archive.

Some levels use Format=2 to remain playable in vanilla KS while having extra features (like golden creatures) when played in KS+. Generally, KS+ doesn't disable features when playing a Format=2 level, but there are a handful of places where it has separate Format=2 and Format=4 paths in the code (such as in the screen rendering code).

Regarding the activity in 2018, someone uploaded 109 levels on June 5th, 2018. Most of them were pretty old, including for example most of Nifflas' levels. I think someone just wanted to upload all the levels they had that weren't already on the archive so they wouldn't become lost. Taking that into account, 2018 was comparable to other years.
« Last Edit: August 20, 2024, 00:43:00 by Pie_Sniper »

*

Offline pacifishi

  • 58
  • 11
  • Av intet blir intet
    • View Profile
What does the "File Count / Upload" chart show? I'm not sure what its x axis is.

It's sort of confusing but you pick a spot on the X axis and draw an imaginary line upwards, see where that line intersects the red and blue, and look at the Y axis for the values of each. Maybe better in picture form: https://i.imgur.com/88iyYO3.png


Regarding the activity in 2018, someone uploaded 109 levels on June 5th, 2018. Most of them were pretty old, including for example most of Nifflas' levels. I think someone just wanted to upload all the levels they had that weren't already on the archive so they wouldn't become lost. Taking that into account, 2018 was comparable to other years.

Mystery solved, thanks!

*

Offline Lucinda

  • 142
  • 32
  • Projectors for eyes
    • View Profile
Pacifishi I am desperate for more level spreadsheet content btw <3
Oh and Robin, I will try to add this stuff to my fanpage soon
Rome wasn't built in a day.

*

Offline Pie_Sniper

  • 109
  • 14
    • View Profile
It's sort of confusing but you pick a spot on the X axis and draw an imaginary line upwards, see where that line intersects the red and blue, and look at the Y axis for the values of each. Maybe better in picture form: https://i.imgur.com/88iyYO3.png

I see. A histogram would be a little easier to read for that. I've attached histograms of file and screen count. The top 1% outliers are grouped in the last bucket.

Oh and Robin, I will try to add this stuff to my fanpage soon

Sounds good. In that case, I'll keep the URL stable when I update it.

*

Offline pacifishi

  • 58
  • 11
  • Av intet blir intet
    • View Profile
Pacifishi I am desperate for more level spreadsheet content btw <3
Oh and Robin, I will try to add this stuff to my fanpage soon

Yes! And does Under The Umbrella still exist?  I went to check for levels but couldn't find it anymore :rosa:

*

Offline Lucinda

  • 142
  • 32
  • Projectors for eyes
    • View Profile
I will DM it to you (on the Nifforum DMs)
Rome wasn't built in a day.