Author Topic: All the levels in spreadsheet format (Read 21534 times)

finlay · « **on:** March 14, 2011, 09:07:07 PM »

EDIT: here's the link, which is different from what it used to be because I changed the folder structure of my dropbox:
http://dl.dropbox.com/u/15543016/lem/Lemmings%20Levels.xls

-----

I have no idea if this has been done already, but I've been compiling all the levels into a spreadsheet for perusal. Source for Lemmings 2 and Holiday Lemmings was tle.vaarties.nl ; source for Genesis lemmings was half playing it through myself and half harvested from Planet Lemmings (or whichever one they get the screenshots from in the review thread).

The others are either harvested straight from the data files that come with the Mac version (which are essentially the same as the DOS version except for Tricky 21 and Taxing 22, where the goal is 100%) or come about as a result of me actually playing through the game. Lemmings Paintball is still a work in progress, however; I couldn't find a source on the internet with a list, so I decided to start playing through the game myself. I'm only up to Tricky 20-something (and the game's at my dad's because he has a windows pc, so I can't keep playing it).

It doesn't include Lemmings 3 because that game has no level titles, or indeed skills in the same sense. It doesn't include Revolution because I don't have access to it. I do have the PS2 version of Lemmings, so I should probably remember to play through the unique levels of that and add them. I don't have the PS3 version, however.

Anyway, I've highlighted quite a few of the cells, often automatically, basically where I think it's noteworthy or unusual. So, for instance, with number of Lemmings, 80 and 50 lemming levels are left with no highlighting but anything inbetween is given a colour, as they're unusual. Yellow cells in the skills columns are 0 - they're highlighted because I used to have each cell filled in with the numeral 0 and needed a way of visually distinguishing them easily, but for various reasons, mostly involving the calculated "Count" field which shows at a glance how many different skills are provided in each level, or how many levels each skill is provided in. For the Genesis version, I've highlighted new levels in blue, and changed levels in red.

I've added comments for the original/ONML levels, as well.

As for Lemmings 2, it's quite big, and only just fits on my rather large screen, but I've set the header and level info to be fixed, so that if you scroll, only the skills move. This should hopefully make it easier to read.

Also, if you try to sort it, be careful, because there are a few lines at the bottom calculating the average and so on, and these could be messed up if you moved them around, so select all the data before you do a sort on them.

Anyway, have a look through it; if you see any glaring errors, let me know!

Hope you enjoy. (If you can't view Excel files, let me know and i'll upload an exported version or something)

http://dl.dropbox.com/u/15543016/lem/Lemmings%20Levels.xls

ccexplore · « **Reply #1 on:** March 15, 2011, 12:12:01 AM »

Wow, someone's having a whole lot of free time lately.

I sure hope having all this free time is a voluntary situation!

It's obviously pretty impressive. I don't completely buy your argument about omitting Lemmings 3 though. It didn't stop you from ~~excluding~~ including Lemmings Paintball even though skills don't exist at all for that game! TLE was not bothered by the lack of level titles in Lemmings 3 either (it just refers to the levels by number). And while it doesn't capture the whole story due to the pick-up nature of the skills, it is still possible to list the number of skills in terms of the total amount of each type scattered across the level.

[edit: fix double negative]

Ron_Stard · « **Reply #2 on:** March 15, 2011, 02:37:26 PM »

Nice work! I can help you on extending this document with all the data from Master system Lemmings, if you want

Adam · « **Reply #3 on:** March 15, 2011, 05:23:49 PM »

Sorry Ron! Started work on adding the Master System stuff before you posted.

Attached in both XLS and XLSX formats.

finlay · « **Reply #4 on:** March 15, 2011, 06:40:01 PM »

Quote from: ccexplore on 2011-03-14 18:12:01

Wow, someone's having a whole lot of free time lately. I sure hope having all this free time is a voluntary situation!

It's obviously pretty impressive. I don't completely buy your argument about omitting Lemmings 3 though. It didn't stop you from ~~excluding~~ including Lemmings Paintball even though skills don't exist at all for that game! TLE was not bothered by the lack of level titles in Lemmings 3 either (it just refers to the levels by number). And while it doesn't capture the whole story due to the pick-up nature of the skills, it is still possible to list the number of skills in terms of the total amount of each type scattered across the level.

[edit: fix double negative]

Meh, TLE has screenshots, though. I don't. I mean I suppose I could list all the skills on the level playing field but it's a bit more of a nebulous figure – the only direct variable in my eyes is the time limit. Paintball has level names and quantifiable stats that come up at the beginning of the level.

As for the free time, I guess it's both voluntary and involuntary...

And SMS lemmings, awesome

finlay · « **Reply #5 on:** March 15, 2011, 10:37:56 PM »

Updated my version to include the SMS levels (slightly altered from Adam's version). I'm also going to update it with more Paintball levels at some point and with the unique levels from the PSP/PS2 version. (also, if I can get ahold of an eyetoy webcam, I'd be able to play the extra PS2 levels......)

Adam · « **Reply #6 on:** March 15, 2011, 11:33:27 PM »

If you want any help with the PSP levels, Finlay, feel free to give me a shout.

Adam · « **Reply #7 on:** March 16, 2011, 12:44:45 AM »

Just done some more updates to the spreadsheet. Thanks to Finlay for the hints & tips.

Adam · « **Reply #8 on:** March 16, 2011, 05:06:13 PM »

Again, another addition here.. added the Mega Drive codes to the Genesis page.

finlay · « **Reply #9 on:** March 16, 2011, 11:42:11 PM »

Cool. I'm working my way through the PS2 version now.

I've also just realised that the reason I had some levels with 0 lemmings in the 2-player Amiga levels was because I was using Lemedit to read the data from them, which only has a two-digit entry field (they should have read 100). I dunno why that didn't occur to me. *facepalm*

Anyway, as I update it I'm just saving it to dropbox, which updates the online download automatically. I'll let you know when I'm finished so that you don't end up with a half-complete one.

edit: done.

LemSteven · « **Reply #10 on:** March 17, 2011, 02:34:37 AM »

Here's another update. I've made a few minor changes to the L3D page to reflect the DOS version. But more importantly, I've added all of the data for Lemmings Revolution.

finlay · « **Reply #11 on:** March 17, 2011, 02:50:29 PM »

Great!

With L3D, it's actually best to note explicitly where they differ, and I'd prefer to keep the PSX version as the reference point, since I spent a while on that one (whenever it was, might be a year or two ago now) – although it may well be the case that the DOS version came before the PSX version, so meh. The graphics on TLE seem to be "better" than the PSX version, but that doesn't prove anything to me.

Anyway, I've worked in the changes to the comments column. (The one I haven't changed is the tileset thing with the snow level that I've marked garden and you marked army – I think this is more to do with the flag that comes up at the start of the level, and unless I wrongly marked it and it's actually army, I'm sure it came up as garden. Snow should probably be a different tileset anyway, strictly speaking. It's also to do with the music in the level, which are definitely organised by theme.)

(That said, I was thinking I should probably change it around so that the Amiga is the reference point for L1 and ONML....)

Adam · « **Reply #12 on:** March 17, 2011, 05:11:24 PM »

Just a suggestion.. there are two sets of codes for the Genesis version.. do you think it'd be worth adding the other set in?

LemSteven · « **Reply #13 on:** March 17, 2011, 05:38:25 PM »

I just did some research on Fun 14 in L3D, and it looks the level theme is different in the PS2 and DOS versions. Specifically, the DOS version uses the Army theme, while the PS2 version uses the Garden theme.

finlay · « **Reply #14 on:** March 17, 2011, 06:47:49 PM »

Quote from: Adam on 2011-03-17 11:11:24

Just a suggestion.. there are two sets of codes for the Genesis version.. do you think it'd be worth adding the other set in?

Didn't you do this already? Unless you mean two different sets in that each level has two codes and you could randomly be shown one or the other, in which case, no, I don't. After all, there are many possible codes for each original Lemmings level and I haven't bothered listing all of those. It's enough to have one, because then you can still get to any level.

@LemSteven: ah! I've noted that in. And changed "Tileset" to "Theme" to make it explicit that the snow levels aren't a separate group anyway. Also it's on the PSX (ie playstation one/PS1) rather than the PS2, just to be pedantic. I know it's probably my fault for mixing them up in the comments or something!

(Maybe because the PS2 can still play PS1 games and I only have a PS2...)

Adam · « **Reply #15 on:** March 17, 2011, 07:21:21 PM »

I couldn't remember if I'd uploaded the updated codes version!

finlay · « **Reply #16 on:** March 17, 2011, 09:27:06 PM »

the what version?

Adam · « **Reply #17 on:** March 17, 2011, 09:31:20 PM »

Damn my phone.. sausage fingers and a tiny keyboard do not make for good typing.. I couldn't remember if I'd uploaded the version with two sets of codes.

Just another thought.. not sure if I've mentioned this/done anything with it publically, but we could use the COUNTIF function to count the number of levels in each style. What do you think?

finlay · « **Reply #18 on:** March 17, 2011, 09:46:00 PM »

Can you? Interesting. I'm forever finding out things about Excel, because those functions can be a bit impenetrable.

Ninja edit: added that next to the tileset key

I've just been changing around the spreadsheet to have the Amiga numbers of lemmings as the reference for Original Lemmings rather than the Mac numbers, which is more confusing because I'm probably the only one that's played that version. But I'm keeping in "Going Their Separate Ways", because I don't think it's worth making a whole new sheet for that. (I mean I could take it out entirely but I quite like it as a level)

Link again so that you don't have to click back a page:

http://dl.dropbox.com/u/15543016/Lemmings%20Levels.xls

Adam · « **Reply #19 on:** March 17, 2011, 10:07:51 PM »

It's possible!

Ron_Stard · « **Reply #20 on:** March 17, 2011, 11:38:58 PM »

New material for the project!

ftp://ftp.worldofspectrum.org/pub/sinclair/games-maps/l/Lemmings_2.png

Notice there are some unique & unpublished levels, only for the Spectrum game (they seem very easy, but i would be nice to play them on Lemmix / Lemmini. One day I will recreate them =) )

ccexplore · « **Reply #21 on:** March 18, 2011, 12:01:53 AM »

If we're going down that route, we can do the same sort of thing for a number of other ports that have modified and/or unique levels. For example I played through NES and Gameboy versions of Lemmings and could contribute on that end, except making level lists like that is just not my thing.

Maybe when I get bored with other stuff......

Adam · « **Reply #22 on:** March 18, 2011, 12:08:29 AM »

I think we'd need a full (and exhaustive) list of ports first, then we'd have to go through them systematically, I guess. It'd be worth it in the end, I think.

ccexplore · « **Reply #23 on:** March 18, 2011, 12:12:26 AM »

Incidentally, all thess information could also be useful to be incorporated in some form in the nascent Lemmings wiki some people here have been starting. wiki are open to the general public to edit, so anyone with interest should feel free to contribute there as well.

finlay · « **Reply #24 on:** March 18, 2011, 01:03:34 AM »

Quote from: Ron_Stard on 2011-03-17 17:38:58

New material for the project!

ftp://ftp.worldofspectrum.org/pub/sinclair/games-maps/l/Lemmings_2.png

Notice there are some unique & unpublished levels, only for the Spectrum game (they seem very easy, but i would be nice to play them on Lemmix / Lemmini. One day I will recreate them =) )

I saw some screenshots of gameboy lemmings on Planet Lemmings today that looked very like this, particularly things like the spiral instead of the spiderweb, but quite a lot of the altered layouts for this were the same for that. It wasn't a complete list, though.

Edit: Updated to include the Sinclair levels.

(I've also included Adam's tileset counter thingie)

finlay · « **Reply #25 on:** March 18, 2011, 06:00:59 PM »

Quote from: ccexplore on 2011-03-17 18:12:26

Incidentally, all thess information could also be useful to be incorporated in some form in the nascent Lemmings wiki some people here have been starting. wiki are open to the general public to edit, so anyone with interest should feel free to contribute there as well.

What should be on there? I'm not sure where I would start.

It's not really got any indexes or anything like that, which is making it difficult for me to navigate easily....

Adam · « **Reply #26 on:** March 18, 2011, 06:39:51 PM »

It's not really got anything at the moment, Finlay.. I'm not too experienced with Wikis, but set one up in case we wanted to do something with it in the future.

finlay · « **Reply #27 on:** March 31, 2011, 02:05:42 AM »

Just made a couple of corrections to the Xmas levels if anyone's interested - in particular, Flurry 8, which is actually one level on the Amiga and Mac versions and another on the DOS version (you can download the one I extracted from the Mac version here: http://dl.dropbox.com/u/15543016/flurry08.lvl ), and also the Xmas 92 demo.

finlay · « **Reply #28 on:** May 11, 2011, 01:03:54 AM »

I have just updated the file (still at the same place: http://dl.dropbox.com/u/15543016/Lemmings%20Levels.xls ) with the 2-player levels from the Genesis version. Now I'm actually just wondering if the Amiga level order is actually closer to the Genesis level order with these; the order that I have already put the levels in is just the order that the level files are in. Does anyone know?

I've also added the names of the NES levels, a lot of which are different, and the codes. I found a site where you can just play this online as a flash game, so in theory I could just harvest the data from there, but it would be slow work – a lot of the levels are a bit too hard for me to just play through when I'm only trying to get the level data, especially when the interface, controls etc are very different to what I'm used to. A preliminary look, however, suggests that it shares a number of levels with the Sinclair and Gameboy versions, but in colour. Anyway, I've got the level names and the data that you see on the thumbnail screen (rate, time, number of lemmings, goal), which I took from a walkthrough online, but I could only find skills data for the Fun levels. Anyone able to help here? (I did find a site that had recordings of people solving the levels, IIRC, so I might try that next...)

Adam · « **Reply #29 on:** May 11, 2011, 01:11:58 AM »

I'm gonna be a little bit out of action for the next week, but I'll gladly help you with the updates - the NES game is HORRID to play, though.. it's dire, simply dire.

ccexplore · « **Reply #30 on:** May 19, 2011, 01:00:32 AM »

Quote from: finlay on 2011-05-10 19:03:54

Anyway, I've got the level names and the data that you see on the thumbnail screen (rate, time, number of lemmings, goal), which I took from a walkthrough online, but I could only find skills data for the Fun levels. Anyone able to help here?

As it turned out, a long while ago when I played NES Lemmings, I tried to make a webpage with basically the same information you're gathering in the spreadsheet. Unfortunately it looks like that mini-project was never completed--I only got up to all the Fun levels and their repeats.

Nevertheless, it's another step towards eventual completion, so here you go. Unzip and then open the "nescode" (or something like that) HTML file to view in browser. (It was originally hosted in geocities which has gone defunct since.)

CynicalOkie · « **Reply #31 on:** May 19, 2011, 05:06:14 PM »

Wow, I never realized that there were only 9 levels that utilized the Crystal set... Darn shame, because that was my 2nd favorite set next to Hell.

Adam · « **Reply #32 on:** May 19, 2011, 05:30:34 PM »

The Crystal set was definitely underused, but it's also difficult to make decent levels with it. There are a few new Crystal levels in the PSP version.. I'll get round to making them in the classic styles at some point!

finlay · « **Reply #33 on:** May 29, 2011, 08:17:35 PM »

Because, let's face it, I'm a bit of a geek for finding out where they've altered the game on different platforms (and can't be bothered making a new thread for this), can anyone confirm/deny this about the SNES version?
http://idlingspace.com/game/perfect_lemmings/lemmingology_us/index.html

Basically aside from All the 6's → Ohayo Lemming san! there was also a few changes in the graffiti on some levels including "Paradise can wait" instead of "Heaven can wait". True?

It's worth looking through the rest of that site, incidentally; although it's all in Japanese you can catch little bits from the screenshots and the bits of text that are in English. There's a tool where you can jump to any level and put a bomber shape over it to see how much terrain the bomber would take away, and stuff like that.

And there's a backroute they found on Sunsoft special 1 (which is the same as Sunsoft 27 on the Genesis version, "Two heads are better", although checking now, on the Genesis version the backroute's been closed by a big hunk of metal) which I've never seen before...

Adam · « **Reply #34 on:** May 29, 2011, 08:45:35 PM »

Heaven was replaced by 'Paradise', I know this much. I believe DEATH was also replaced in Taxing 24 with TERMINATE.

It's interesting to note that All the 6s was actually coded into the SNES version, and can be accessed via a code.

ccexplore · « **Reply #35 on:** May 29, 2011, 08:46:33 PM »

Quote from: finlay on 2011-05-29 14:17:35

Because, let's face it, I'm a bit of a geek for finding out where they've altered the game on different platforms (and can't be bothered making a new thread for this), can anyone confirm/deny this about the SNES version?
http://idlingspace.com/game/perfect_lemmings/lemmingology_us/index.html

Basically aside from All the 6's → Ohayo Lemming san! there was also a few changes in the graffiti on some levels including "Paradise can wait" instead of "Heaven can wait". True?

Cool!

Yes, I have confirmed all the ones shown on that webpage. There are also some minor title changes in other levels if I recall, for example Taxing 16 is "Umbrella Land" probably because Mary Poppins is foreign to Japanese pop culture.

I'm slightly surprised at the Taxing 24 graffiti change (death -> terminate), as the longer word actually also necessitated moving the entrance trapdoor further to the left in order to fit. But then again, as they were already adding extra levels into the game, might as well have a little fun at the existing levels.

Funny they didn't also try to fit "Sunsoft" in that level somewhere.

ccexplore · « **Reply #36 on:** May 29, 2011, 08:56:24 PM »

Quote from: Adam on 2011-05-29 14:45:35

It's interesting to note that All the 6s was actually coded into the SNES version, and can be accessed via a code.

Unless it's something you know that is not shown in the website, you might've confused the Japanese version with the US version. From what I can tell on the website, the Japanese version retains the 666, while the US version they changed I guess to placate the you-know-whos. <insert sorely missing lemmings rolling-eyes emoticon here>. The Japanese passwords are not usable on the US version AFAIK.

Still, it would not surprised me at all if the 666 version is actually kept in the ROM and still accessible one way or another, whether via password or via GameShark or similar cheat devices. I wouldn't know though.

ccexplore · « **Reply #37 on:** May 29, 2011, 09:00:34 PM »

I also have to say, I'm impressed at some of their solutions featured on the website. They even have a Tricky 23 solution that is similar in concept to the lose-1 solution (but saves less), though they did resort to the simpler "use floaters to create a gap in the crowd" method of allowing the left-facing miner to be assigned, rather than my much trickier method of cursor placement.

Adam · « **Reply #38 on:** May 29, 2011, 09:02:33 PM »

Quote from: ccexplore on 2011-05-29 14:56:24

Still, it would not surprised me at all if the 666 version is actually kept in the ROM and still accessible one way or another, whether via password or via GameShark or similar cheat devices. I wouldn't know though.

When I say code, I mean gameshark or something similar!

geoo · « **Reply #39 on:** May 29, 2011, 09:11:01 PM »

As this is the perfect opportunity to practise my feeble Japanese, I'm offering to translate a few sections of anyone's choice from this page into English.
Will likely contain some errors, but I hope to do at least a bit better than, say, some machine translation.

finlay · « **Reply #40 on:** May 29, 2011, 11:56:38 PM »

Japanese makes me despair because I can read the kana fine but the kanji make my head explode...

Anyway, I've added this info as a note, because the rest of the info for the SNES version is the same. Not sure whether I should incorporate their codes.

On the subject of codes, does anyone have a list of codes for Lemmix? They just happen to be different.

" title="Angry" class="smiley" />

And I've added the PS3 version to the spreadsheet, although it was from a badly-written walkthrough which didn't have full info for all the levels, just their entry number of lemmings and skills – so rates and numbers of entrances/exits might be missing. If anyone wants to fill that in feel free.

ccexplore · « **Reply #41 on:** May 30, 2011, 03:03:46 AM »

Quote from: geoo on 2011-05-29 15:11:01

As this is the perfect opportunity to practise my feeble Japanese, I'm offering to translate a few sections of anyone's choice from this page into English.
Will likely contain some errors, but I hope to do at least a bit better than, say, some machine translation.

Well if you insist, you can go ahead and practice on "Lemmings Preparation" and "Lemmingoloy Mathematics". I suspect one could probably just feed the pages through machine translation and still proably glean enough information of interest from even the terrible results (heck, some of the information doesn't even need to be translated), but a better translation certainly won't hurt.

[EDIT: actually, the page on the 2-player levels probably benefits most from translation:

Logged