Grimrock stats spreadsheet

Talk about creating Grimrock 1 levels and mods here. Warning: forum contains spoilers!
User avatar
Edsploration
Posts: 104
Joined: Wed Sep 19, 2012 4:32 pm

Re: Grimrock stats spreadsheet

Post by Edsploration »

Batty wrote:Oh thanks Edsploration, I'm hoping for dungeons where we get to lvl. 20+.
I don't know if anyone will be making any dungeons big enough to get there the traditional way any time soon, but there's a lot of potential for messing with the way the leveling system works. To me it seems difficult to balance without a deep understanding of game internals, however.
Batty wrote:We need full stats for monsters beyond lvl. 5 which can be calculated using the standard increments.

It would make it easier to define monsters >lvl. 5 if there's a nice chart.
Do you mean health/attack power/protection at monster levels above 5? Well the editor doesn't even let you set a monster higher than 5 so I'd assume anyone doing it manually in the code is going to look into the health/attack power/protection increments on their own, and maybe customize those too. So a reference chart wouldn't be useful I imagine. As for experience, I don't know how it's calculated, but it's not a linear function, and the values displayed by the game appear to be truncated making it difficult to map exactly to an elementary function. Sorry if I'm misinterpreting your meaning with all this. :)

As for their default increment amounts I used some regex slight of hand and voilà! https://docs.google.com/open?id=0B01M18 ... khlbkl4UG8
Komag wrote:
Batty wrote:That is the slickest avatar on the forum!
agreed!
Ha! Well, thanks :D I almost didn't implement it because I thought it was too silly.
Open Project -> Community FrankenDungeon: viewtopic.php?f=14&t=4276
Batty
Posts: 509
Joined: Sun Apr 15, 2012 7:04 pm

Re: Grimrock stats spreadsheet

Post by Batty »

I made a chart of advanced level monster stats (health, attack power, XP given):

https://docs.google.com/spreadsheet/pub ... utput=html

Since >lvl. 5 monsters must be cloned/defined, this chart can be used for quick reference.

The XP given seems to be multiplied by 1.1 to get the next level. They truncated some values and rounded others for the first 5 levels so I just rounded for the numbers above level 5.

High level combat might be really fun!
User avatar
Billick
Posts: 201
Joined: Thu Apr 19, 2012 9:28 pm

Re: Grimrock stats spreadsheet

Post by Billick »

Cool, I've linked these two spreadsheets to the original post in the thread. Also, I have to concur that Edsploration's avatar is awesome.
Halls of Barrian - current version 1.0.3 - Steam Nexus
Me Grimrock no bozo!
User avatar
Huff
Posts: 18
Joined: Fri Jun 22, 2012 9:47 pm

Re: Grimrock stats spreadsheet

Post by Huff »

In case you guys don't have enough XP charts, have another one!
I added "Required XP" to next level, up to level 60. I don't have MS Excel so I did the math manually :P

https://docs.google.com/spreadsheet/ccc ... zhJT2VvUWc
User avatar
Edsploration
Posts: 104
Joined: Wed Sep 19, 2012 4:32 pm

Re: Grimrock stats spreadsheet

Post by Edsploration »

Wall of text incoming, so I tried to highlight the important points. I've updated the main stats spreadsheet. Full credit and thanks goes to Billick of course for compiling most of it! I just built on a bit more and added some specialized info into it...

My updated stats sheet at: https://docs.google.com/spreadsheet/ccc ... FBTNU16SGc

In Armor, added Set column (e.g. Leather, Chitin, Valor).

In Spells, added entries for player-cast utility spells.

Added Alchemy (new tab) with sections listing Tools, Ingredients, and Potions.

Added Food (new tab)

Edit: Oops, forgot to mention... Added Tomes (new tab) including Ixnatifual's Tome Library! (as seen here viewtopic.php?f=14&t=3338)

Added Slots-Builds (new tab) which demonstrates the distribution of item upgrades throughout the main LoG game.

In Exp, added experience to next level and extended the chart up to level 78.

A "First Seen" or "Seen" column to most tabs which lists when the item or monster first appears in the main Legend of Grimrock game. I obtained this data in part by a partial run-through of the game, but mostly by referencing these sources: The "First Seen" data should be quite accurate, but it's possible there are still errors. (e.g. Is the "Gear Amulet" in the game??)

Items which are dropped from monsters are marked as "Seen" as soon as that monster appears in the main LoG game, regardless if the item was physically placed in the dungeon by that point or not. (e.g. Skeleton warrior drops legionary items on dungeon level 1.) However, potions are NOT marked as "Seen" based on where it may be first made from alchemal ingredients. (e.g. The Sulphurous Potion first appears on dungeon level 9, although it could be made by the player as early as dungeon level 3 after a blooddrop blossom is found.)

I added a "Suggested Level" (SL) column next to the "Seen" columns. The purpose of this is to give a reference guide for dungeon designers about where the item or monster should first appear in a dungeon for an excessively smooth leveling/difficulty curve. Specifically, the SL would be the ideal dungeon level for the item or monster to first appear in a dungeon with the same exp-per-level as the official LoG game. This value could probably be considered to be champion level for a 4-champion party.

Take the SL rating with a grain of salt because:
  • This is a first iteration on the rating metric.
  • I have limited understanding of the game internals.
  • There IS wiggle room, especially at higher SL's and SL of armors. Some ratings are more "strict" than others. That is, the item/monsters placement can sometimes be moved a great distance from the SL sometimes without breaking the experience. Use your best judgement.
The Suggested Levels (SL's) are based on (in no particular order):
  • Item/monster stats.
  • Dungeon level it first appears on in the main LoG game.
  • Required level of key skills.
  • Lining up elemental "threats" and "solutions" to be the same SL. (Poison shield and serpent bracer both match the slime's SL of 4, which itself is based on the slime's stats.)
  • Consistency within a "set" of armors. (Should probably not be actually placed together in a real dungeon.)
  • Occasionally, smoothing out the frequency of upgrades throughout the range of the items. (e.g. Staves have SL's of 1,4,6,9 which is smoother than their "Seen" locations of 1,6,7,9.)
  • Special effects/uses of the item.
Monsters should not appear at a level below their SL rating unless a risky encounter is desired or with consideration to surroundings, which may make the fight easier or harder. For example, the single ogre fought in the main game at dungeon level 6 was made much easier because he was placed in a wide-open room.

Items generally have quite a bit of wiggle room and SHOULD be varied to make the dungeon interesting, as long as one choice doesn't overwhelm all the others. Items could be placed below their SL if there is still a shortage of the desired item, or the item is a missable secret. For example, a shuriken with an SL of 5 can be placed on dungeon level 1 without much trouble, because there is only one of them. And a single pair of powerful boots can be dropped early because up to 4 sets of boots are needed by the party. It would be more damaging to take a specific powerful axe and drop it at level 2. That would say to the player, "You'd better spec into axes or miss out!" Keep in mind that some items should be placed for the first time above their SL to give item distribution a natural, sporatic feel.

The SL listed for armor sets tend to be very similar if not the same for all items in the set. That is because their SL is based mostly on the strength of their stats, which are often identicle! But in the main LoG game you'll find the items for a set are found strewn throughout many dungeon levels. It's basically bad design to place all the items for a set on the same level. The dungeon should feel more "organic" by having upgrades come sporatically. The important thing is to not leave any champion's specialty high-and-dry for too long. See the Slots-Builds tab for how the main LoG game distributes item upgrades!

Well that's the gist of it. Please let me know if I've made some mistakes with the hard data, and offer insights to improve the SL ratings. And of course feel free to split your own definitions off if you don't like the way I've compiled them!
Last edited by Edsploration on Fri Oct 05, 2012 2:18 pm, edited 1 time in total.
Open Project -> Community FrankenDungeon: viewtopic.php?f=14&t=4276
Lmaoboat
Posts: 359
Joined: Wed Apr 11, 2012 8:55 pm

Re: Grimrock stats spreadsheet

Post by Lmaoboat »

Is there any charts for the amount of XP each level in the Grimock dungeon gives? Would be a helpful guide for planning out monster placement for each level.
User avatar
Edsploration
Posts: 104
Joined: Wed Sep 19, 2012 4:32 pm

Re: Grimrock stats spreadsheet

Post by Edsploration »

Lmaoboat wrote:Is there any charts for the amount of XP each level in the Grimock dungeon gives? Would be a helpful guide for planning out monster placement for each level.
I am actually writing a javascript tool to do exactly this!!! And a few other things. I'll try to make it presentable soon!

Edit: Actually it will analyze user-made dungeons, not the official LoG game, if that's what you were referring to. I think the official game would have to be done by a manual count, which I have no desire to perform.
Open Project -> Community FrankenDungeon: viewtopic.php?f=14&t=4276
User avatar
Komag
Posts: 3658
Joined: Sat Jul 28, 2012 4:55 pm
Location: Boston, USA

Re: Grimrock stats spreadsheet

Post by Komag »

This information keeps getting better and better, thanks!
Finished Dungeons - complete mods to play
Jordan
Posts: 88
Joined: Fri Apr 13, 2012 10:52 pm

Re: Grimrock stats spreadsheet

Post by Jordan »

Thank you very much for the info.
User avatar
war_dog
Posts: 30
Joined: Thu Apr 12, 2012 3:32 pm

Re: Grimrock stats spreadsheet

Post by war_dog »

thanks a lot!! really usefull :D
Post Reply