There are two main documents I use while developing Garden. First is a spreadsheet that contains a large portion of game information and mechanics. The second is a text document containing all story-related materials. In this post, I will briefly introduce the spreadsheet.
The first sheet of the file is reserved for some general information like a rough development schedule, estimated player progress during the story, and general notes. Next is a changelog sheet containing changes from previous versions. It is followed by an exp table for player progress and map layout sheets.
The next two sheets are probably the most important ones to me while developing. They are the player character stat calculator sheet and the enemy sheet. The character stat calculator uses the same values that are used in-game to quickly display various stats based on level and equipment. It also shows how those stats affect the characters' skills. The enemy sheets show all the technical information of different enemies. Both sheets are used to create the key encounters in the game, mostly boss encounters, that require careful tuning to reach desired experience for the player.
The rest of the sheets are mostly lists of data: enemy skills, items, NPC vendors, and a game mechanic guide sheet intended to be included in-game.
Last, but not least is a notes sheet used to keep track of some variables, math calculations, and misc info.