Creative uses of google sheets

Craft a Compelling Character Sheet for RPGs (RPGs)

Craft a Compelling Character Sheet for RPGs (RPGs)

Setting Up the Sheet: Open a new Google Sheet and rename it to your character’s name.

Character Stats: Dedicate the first few rows to your character’s core attributes. In column A, list “Strength,” “Dexterity,” “Constitution,” “Intelligence,” “Wisdom,” and “Charisma.” In column B, enter your character’s ability scores for each attribute (numbers assigned during character creation).

Stat Modifiers: In column C, calculate the modifier for each ability score. For example, for a Strength score of 16, the modifier would be +3 (consult your RPG rulebook for specific modifier calculations).

Derived Stats: Use formulas to automate calculations for derived stats like hit points, armor class, and spellcasting ability. In cell D2 (assuming Strength is in cell B2 and its modifier is in C2), enter the formula =10+FLOOR(B2/2,0)+C2 This calculates your character’s base hit points (10), adds half their Strength score rounded down (FLOOR function), and then adds the Strength modifier.

Inventory Management: Create a new sheet named “Inventory” or dedicate a section within your character sheet. List items by name in column A, quantity in column B, and weight in column C. For equipment, add a column D labeled “Slot” where you can enter “Head,” “Chest,” “Hands,” etc., to keep track of equipped items.

Storytelling Through Spreadsheets: Dedicate a sheet named “Backstory” or a section within your main sheet. Here, write your character’s backstory, personality traits, and motivations. You can even include images by inserting them and resizing them appropriately.

Conditional Formatting for Quick Reference: Highlight low health points for a sense of urgency. In the hit points cell (D2 in our example), navigate to Format > Conditional formatting. Set the formatting style to “Change background color” and the rule to “Less than” with a value of, for example, “25%” (your character’s hit points are critically low). Choose a red background color to visually indicate danger.

Plan Your Dream Vacation with Google Sheets as Your Travel Buddy:

Plan Your Dream Vacation with Google Sheets as Your Travel Buddy:

Destination Research Central: Create a new sheet named “Destinations.” List potential destinations in column A. In columns B, C, and D, use the web scraping function (Google Sheets add-ons) or manual searches to populate flight prices from different airlines for various travel dates.

Tip: While web scraping add-ons can automate this process, always check the add-on’s privacy policy and terms of service before using it.

Itinerary Builder: Create a new sheet named “Itinerary” or dedicate a section within your main sheet. List each day of your trip in column A. In columns B, C, D, and E, detail your planned activities, accommodation details (hotel name, confirmation number), transportation arrangements (flight times, confirmation numbers), and any local attractions you want to visit.

Budgeting Made Easy: Create a new sheet named “Budget” or dedicate a section within your main sheet. List categories like “Accommodation,” “Food,” “Transportation,” “Activities,” and “Souvenirs” in column A. In column B, set a realistic budget for each category based on your research and spending habits. Use the SUM function ( =SUM(B2:B6) ) at the bottom of column B to calculate your total planned budget.

Become a Citizen Scientist with Google Sheets:

Become a Citizen Scientist with Google Sheets:

Data Collection Platform: Find a citizen science project that interests you (e.g., birdwatching, weather monitoring). Citizen science programs often provide downloadable datasheets. Use this as a guide or create a new Google Sheet with similar columns.

Collaboration is Key: Most citizen science projects have online communities or forums. Share the link to your Google Sheet with other participants after setting the permission level to “Anyone with the link can view” (located in the top right corner of the sheet under “Share”). This allows others to contribute their observations.

Tip: Citizen science projects often have specific data collection protocols. Ensure your Google Sheet reflects these protocols for consistency and comparability of data.

Gamify Your Goals and Boost Motivation:

Gamify Your Goals and Boost Motivation:

Progress Tracker: Create a new sheet named “Goal Tracker.” List your goals in column A, with each goal occupying a separate row. In column B, break down each goal into smaller, more manageable tasks. In column

Leave a Comment

Your email address will not be published. Required fields are marked *