Topic: [Spreadsheet] Adventuring Log Template  (Read 6554 times)


« on: June 15, 2021, 10:45:32 AM »
This is a Google Sheets template designed as a replacement for the in-game character [L]og that was removed from the Unreal World v3.63 build.
It is meant to support recording the adventures of a single character per file instance.

Google Drive users can save a copy of the spreadsheet to their drive.
The file can also be saved in different formats offered by the Google Sheets service (MS Excel, OpenDocument, etc.).
Permission is granted to modify this template and share derivatives.

Preview of log excerpts on imgur.

Details, Features, and Recommendations for How to Use:

Make a record of your character's adventures and journeys that you can keep track of from day to day and year to year!
Take notes about animal sightings, encounters with other humans, your standing with the spirits, crafting and gathering activities, and more!
The "Y" tab is the actual journaling template.
The "Y16" tab represents a new character's start and you can duplicate the Y-sheet to begin a fresh page for the new year (Y17, Y18, and so on).
To find your character's age in-game, use the [P] command to open the Character Profile Screen.

Take stock of your settlement's animals, food stores, available tools, and more!
The "camp:" tab is intended to be copied as needed for the player's important settlements.
There are columns available for listing the valuables, tools, weapons, and food items stored at each site.
Users of Night's URWCharacterMenu can grab the camp's coordinates when using the overworld/zoom-out map.
In-game map markers will also track where you have established shelters and settlements.

Keep track of your clothes and armor quality:
Wish you had a better shirt? Want to upgrade your threads for the best looks and protection? Sort out your wardrobe with the "outfit" tab.
Items in the base game are listed by material and (roughly) by bodypart coverage.

The "census" tab is intended to record information about animals you obtain through bartering or otherwise.
How much does your new bull weigh? Find out its carrying capacity by pushing rocks on its back until it can't hold any more. Will it be good for shouldering a log (400 pounds) or an entire tree trunk (500 pounds)?
Conditional formatting is set up so that creatures with a carrying capacity of at least 400 pounds will have their Weight formatted in italics, 500+ pound-lifters will have additional underlining, and monster hefties (600+) pounds will be italicized, underlined AND bolded to show these are your prized packers!
The census can help you identify your livestock by color (or at least you can try to judge what shade the randomized color tinting turned it into).
You can also assign a "job" to your animals to keep track of when they're carrying specific tools, armor, clothing, etc.

Keep a watchlist of goods you would like to purchase:
A reputation in town as a fair barterer will be a plus in order to negotiate a better deal when you're looking to buy.
Ideally, you want to build reputation by trading frequently for small goods before tackling a big purchase such as livestock or a glorious, masterwork-quality battlesword.

Time your fishing hauls
Passive fishing with nets has its rewards and its risks. If you leave your net in the water for too long, you might end up with a load of dead, stinking, rotten fish that won't be good for anything!
Make a note of when you set your nets so you can try to come back for the catch at a reasonable time.

Time your sacrifices to the local spirits
A general sacrifice can be made once a day separately for the spirits of the forest and the spirits of the waters.
Make sure you don't annoy the spirits with too many offerings by tracking whether you've already had them done for the day.

Measure the fruits of your hunting and trapping
So you finally caught the Big Elk for the Advanced Adventures course? Well, just how big are we talking here? Bring up one of the inventory menus (push, pick up, move) to find out how many pounds (or kilograms in the upcoming Unreal World v3.70) the beastie weighs. When you're done butchering it, you'll be able to count how many cuts the carcass gave you.

Keep track of your food preservation techniques
How will you manage to eat 200 pounds of venison before it all goes bad? Even if you chuck the meat in the cellar, it will only keep for a handful of days at most. Sure, you can salt it, but you need to buy the salt first. You can smoke it, but you'll have to tend to the fire every day for a couple of weeks. You can dry it, but the weather needs to be right for it.
The journal can help with timing these cooking activities to reduce spoilage and waste.

On a quest to do what, for whom, when's the deadline, and what sort of reward is promised?
Take notes about your questing activities, how many squirrel furs-worth of credit you have at a village, and what goodies you discover in a treasure cache.

Data validation: The "dataval" tab contains a list of values that are meant to go in the journal columns.
Some cells under the Months column also have hover-tips about when certain seasonable resources are available (milk, bark from trees, birch twigs, and the season for drying fish and meat).
Game file urw_defs.txt (located in the messages folder of the game directory) contains strings for the names of the months. Players who customize the calendar should adjust the dataval column to match their game.
The Day number column accepts only values 1 through 7.
The Week number column accepts only values 1 through 13.

Color-coding for cultural regions, seasons, time markers, livestock species, activities.
These cell colors are applied via conditional formatting on the relevant record columns (not actually done in the dataval tab).
If you want different colors, select the column on the Y-sheet or census-sheet and change the condition rule or remove it entirely.

Custom activities are supported; overwrite the miscellaneous cells.
If your activities exceed the default 10 custom activities, make sure to edit the data validation on the journaling sheets to extend the range of valid cells. Usually this is as simple as editing the row number in the Google Sheets validation window.
Example activities: fire, forage, forge, hidework, weave


« Reply #1 on: June 15, 2021, 04:32:03 PM »
Looks like this will really useful for people like me who always forget where things are. I will probably add a todo list as well because I often forget that I planned to do X or Y some time soon, especially if I am away from the character for a few days.