Hope: A Sky Full of Ghosts (tuxdb.com)

Spreadsheets for Story: Here's how we Do It - Devlog #3

Aloha! Azrael here again with a brief follow-up on last's Devlog. Since we shared it on Redditwe gota few great comments and questions. One of them was very interesting to me: Since I thought it might be useful to more people, below you will find the question and answer with a couple of screenshots from our spreadsheet.

How do you set up a spreadsheet to work on a story?

That's a good question, and the answer is,you don't. (::shy smiley::). We first identified a skeleton of the outline in free-form writing, but when it came to its implementation, we needed a structured way to follow it from start to finish.That's where a spreadsheet has worked wonders for us. We have used spreadsheets for characters, relationships, motivations and more, but the biggest impact it's had is breaking down the story into its smallest pieces.

Once we knew what we wanted the story to be, we identified the components common to all scenes and give each a column in the spreadsheet. For us they are:

Objective/Quest: This column will have a brief title for what the scene is about or which quest it belongs to
- i.e.: Access the Lunar Base
What: the what is happening in this scene and only during this tiny part of the scene.
- i.e.: Get to the Control Access Point
How: the how is the scene presented or the objective accomplished, is this a mini game? which one. Is it a cinematic or a scripted scene. That goes here
- i.e.: Navigation: this means the player walks there
Beginning: Well... how the scene starts, the current status or place the game is in
- i.e.: The player/Agatha is at the entrance of the lunar base
Ending: the state the game is in after events have happened
- i.e.: Arrived at the Control Access Point
Comments: this is to guide the scene, mood of the conversation, who is pissed at who and why.
- i.e.: Agatha is dizzy from the trip to the moon.

This example isn't very narrative driven but it illustrate fairly easily all we take into account for each scene. A more narrative example would focus on mood and conversation beats than location. It would look more like this:

Objective: Start the *SPOILERY SPOILER* process
What: Agatha tries to get Mariko's help
How: Conversation + Decisions
Beginning: Mariko is pissed at the crew because *SPOILERY SPOILERS*
Ending: Agatha manages to ease Mariko's concerns but not enough to get her to help at this time.
Comments: at key parts of the conversation, the player will be prompted with 3 options at a time to decide the next line Agatha says to navigate this situation.

A spreadsheet is nothing but a box of boxes and we use those boxes to separate each section of a problem as much as we can to inform how to tackle it narratively. This break down is then used when I sit down to write the dialogue for that specific scene. If the decisions are really important they are included in the Comments, so I can try and nail them correctly. Be careful though, a spreadsheet has infinite columns and rows so you need to commit to the things that actually matter to ALL scenes. Otherwise you'd end up writing lines of dialogue there, which you could do, but makes it harder to export. We tend to think that Story is what happens when you sit down and write what will be on the page but in all honesty, that's only the second to last step in Story. I hope this helps! Let me know how you use spread sheets in your project.

[ 2025-03-03 16:34:54 CET ] [ Original post ]

Hope: A Sky Full of Ghosts

Wil Alvarez Developer

Wil Alvarez Publisher

1970-01-01 Release

Action Indie Strategy Casual RPG Adventure Simulation F2P Sports MMO Racing Singleplayer Multiplayer Coop EA Tags

Game News Posts: 10

🎹🖱️Keyboard + Mouse
🕹️ Partial Controller Support
🎮 Full Controller Support

No user reviews (0 reviews)

Steam Store

Hope: A Sky Full of Ghosts is a minimalist sci-fi point-and-click adventure focused on narrative.

You are Agatha Hope, a leader of the Cicadas, a rebel movement fighting against NexxusCorp's tyranny. To escape their oppression, you must steal their spaceship. To save humanity, you must unite your crew. Your decisions will shape the course of your story. You must overcome challenges through mini-games and puzzles. All in an attempt to accomplish your mission and uncover dark secrets.

MINIMAL SETUPOS: Ubuntu 12.04 / SteamOS 2.0
Processor: Intel i5 Quad-CoreMemory: 4 GB RAM
Memory: 4 GB RAM
Graphics: Intel HD 4000
Storage: 4 GB available spaceAdditional Notes: 32-bit systems must use virtual memory to get over 2GB.

💰 Games on Sale 💰

GAMEBILLET

[ 5975 ]