Spreadsheet

This is one of the first spreadsheet I created at Nvizzio Creations Inc.

This spreadsheet have the following features:

• UID have a Data Validation to setup the beginning of the ID, this way we can keep consistency between loc strings
• If the row does not have an entry, "@@Ignore" will be used, this is for the exporter to exclude it, I also took advantage of it to categorize the loc strings
• I used multiple Conditional Formatting to check whether the table contain duplicates, whether it needs to be sent for translation, and also highlight strings from other languages to help Translators identify which strings to update
• I created a separate sheet to work as an Index page, this sheet uses FILTER() to grab the categories from the Localization sheet to give quick access to the cell
• Used GOOGLETRANSLATE() to give placeholder strings for other languages
• Columns and Rows with "@@Ignore" will be grayed out, I use this to organize the tables

This is a weight table that I created at Nvizzio Creations Inc. My coworker and I often ask each other where to go during lunch and we would always waste a lot of time just to pick a place, therefor I decided to create a spreadsheet that would help us decide.

This spreadsheet have the following features:

• Each restaurants have a base weight of 500
• Each time a restaurant have been picked, the weight is reduced by half
• We can double the weight by choosing the preference type
• We can exclude a restaurant type
• We can exclude individual restaurants

In this case, I've used it to help myself find a restaurant to go to but the application of it can be used for AI within the game, having a weight that dynamically change depending on the situation to give more life to the AI