Go Back   UPNetwork > Independent Forums > Fizzy Bubbles > FB Time Out

Thread Tools
Old 07-27-2020, 04:47 PM   #1
Cascade Badge
ChrisClark13's Avatar
Join Date: May 2012
Location: Utah, USA
Posts: 418
A Post Autoformatter (And Trainer Log) Google Sheet

So, I've gone and made this Google Sheet that you can dump all your bookkeeping info into and it will spit back out automagically formatted posts for use in your Trainer Profile and the various Bank shops (with some exceptions for things that get rarely tracked by most people).


To get started, use the File menu drop-down and select "Make a copy".
From there, simply replace all the information I've put in with your own info.

Before using this to replace what you have in your Trainer Profile, MAKE A BACKUP!

If you have multiple characters that's not really supported, so I suggest making an entirely new Google Sheet for each one if you want to keep their inventories and logs separate.


First off,
This is meant to help get all your various bits of information together, it does not replace your Trainer Profile thread, you still have to keep that up to date! It merely exists to help you do the bookkeeping and upkeep for your thread! (And don't you dare just link to your Google Sheet in your Trainer Profle and stop updating your thread either.)

(Note: Certain things such as Clarity and FC are not currently supported to be tracked by this.)
  • Inventory / Candy / Wallet / Watts Log
    A sheet with sections for keeping track of (you guessed it) your inventory, your rare candies, your pokedollars, and your watts.
    • Inventory Log
      The inventory section can do more than just be a list of what's in your pockets, you can list the same item on it multiple times (say, separate instances of buying some Pokeballs) and it can also track where you've used up your items. All these additions and removals of items will be tallied up later.
      • Quanity Change (REQUIRED): A positive or negative number. How much of that item was added or removed from your inventory.
      • Item (REQUIRED): The name of the item being added or removed. Make sure to spell the name of that item the same way each time.
      • Category (REQUIRED for the first instance of that item): What category the item is to be sorted into. You are not restricted to categories that are found in the games. This is important for how the items will be sorted in the output later.
      • Description (Optional): Some items are unique to FB or maybe you just want to add some flavor text. What you type here will show up in the output later. (Only the description for the first instance of an item that shows up in the log will be used.)
      • Source (Optional, but highly recommended): While this is not used in any output right now, isn't important to keep note of where your items came from and where they're going to?
      • Date (Optional, but highly recommended): Not used in any output right now, but isn't keeping note of when changes happened to your inventory important?
      • Link (Practically REQUIRED): Strictly, this is optional... but if it's an really important item (*cough* Heart Scales *cough*) you're required to keep track of this anyways. Putting the link in here will create a link to where you got the item (and where it was used) in the output.
    • Calculated Inventory
      A summed up list of all item quantities in the Inventory Log. As this automatically fills itself out, do not edit this section.
    • Rare Candies / Wallet / Watts Log
      All of these function in the same way, save for one difference in the Rare Candy section. All fields are required (if not by the sheet, then by the FB rules) and all of them are used in creating the output.
      • Quanity Change: How much was added, or removed, from that currency.
      • Source: A descriptive name for source of the change to the currency. (Examples: "Feeding 10 Candies to my pokemon", "Grabbing my Weekly Candy", "Spent money at the Department Store")
      • Date: The date the change occurred.
      • Link: A URL link to the source of the change.
      • Shop Update: Put an "x" next to the row(s) that have been accounted for by the shop owners in their updates. This keeps outdated lines from showing up in the output.
      • Current Post Link (Rare Candy Log ONLY, REQUIRED, at the top of the list): A link to the current post where are you tracking your Rare Candy totals. This keeps the outputted post from linking to itself (even though it would be a spicy meme to let it do so).
  • Inventory Output
    • Output Preview: A preview of what the output will look like (BBCode tags included).
    • Form Output: The section you are meant to copy paste from, copying from the Output Preview will mess up the BBCode and do other funky things once it's pasted anywhere else that's not another spreadsheet program.
    • Settings: A few settings you can change to control the output.
      • Split Inventory into Categories?: Split the inventory into specific Categories of items or just have it as one big blob?
      • Inventory Item Prefix: A bit of text that will be put at the start of each line that has an item on it.
      • Padding Lines After Category: Extra padding lines after each inventory category section.
    • Item Categories: This is where you can specify what order the item categories will show up in in the output. You can put down categories that don't have any items in them at the moment and they will still show up in the output.
  • Wallet / Rare Candy / Watts Output
    All of these function the same way. Nothing on these sheets is meant to be edited manually.
    • Forum Formatted Output: These lines are what you can copy-paste to the forums.
    • Output Data: You can take a look at the data as it's being turned into the output post here. Mainly, you can look at the current block it's processing, your deposits, and your withdrawals each in their own lists.
  • Link Storage: A little area where you can use to store important links (and dates) so you can easily copy them around to other parts of the sheet. (If you want to be extra fancy, create a Named Range pointing at parts of this sheet and use that to copy the data around.)
  • Level Up Move Formatting Helper: The only page in the entire spreadsheet that absolutely does not interact with others in any way.
    • OUTDATED: Use https://chrisclark13.github.io/Fizzy...MoveSetViewer/
    • Quick Guide: Paste in the corresponding information from each website page (Veekun, Serebii SwSh Dex, Serebii PLG Dex) and collect the output at the far right by copying it. If putting it somewhere else in the sheet, be sure to do Right Click > "Paste special" > "Paste values only" (or CTRL+SHIFT+V).
      A full guide for this may come later and I can also create a standalone version of this if people really want it.
  • Pokemon Sheets Output
    A page that (can) collect all the output from the various Pokemon Pages. However, it will not do so automatically- you must specify each sheet you want to pull in the data for. If you want to collate multiple, separate lists of your Pokemon- feel free to duplicate this page.
    • Settings: A couple settings that you can change, though they should be good to just leave these be.
      • Output Cell: The address of the cell that contains the Output Preview on each and every Pokemon Sheet. If you've not added any extra rows to the Pokemon Sheets, then you don't need to change this.
      • Spaces between Pokemon profiles: How many spaces of padding you want between each Pokemon profile.
    • Pokemon Sheet Tab Names: A list where you must enter in the exact name of the Tab of each Pokemon Sheet in the spreadsheet (that you want to show up in the output).
    • Fetched Sheet Output: If you've entered in the Sheet Tab Name correctly, then data will automagically show up here. Goes without saying, but don't edit this list.
    • Output Preview: A preview of what your list of Pokemon Profiles will look like, BBCode left in. Don't copy from this section, bad things will happen to your post.
    • Forum Output: The section you are supposed to copy-paste from.
  • Pokemon Sheet Output Configuration
    A one-stop place where you can change how the output from your Pokemon Sheets will look. All Pokemon Sheets will use the settings you specify here.
    • Output Place Holders: To be used with the Output Specification Template. Putting in one of the tags on the right side of the list be later replaced with the corresponding information on each Pokemon Sheet. (If you must, absolutely must, make edits to this- add in things at the bottom of the list! Otherwise, things can and will break horribly and your Pokemon Sheets will turn into an absolute mess.)
    • Settings: Only one setting at the moment.
      • Output Level in Level-Up Moves List?: Changes a small thing about how the Level-Up move list is outputted. Best way to show this is with a couple examples:
        • ON Example: Growl (-), Tackle (-), Screech (6), Body Slam (20), ...
        • OFF Example: Growl, Tackle, Screech, Body Slam, ...
    • Output Specification Template: This is where you can specify exactly how the output from each Pokemon Sheet will be formatted! You probably will want to change to your liking. Using the Output Placeholder Tags, note where you want information to be filled in. You do not have to use every Placeholder Tag. (Try taking an existing Pokemon profile and replacing the specific pokemon information with the placeholder tags if you get stuck.)
  • Blank Pokemon Sheet: Guide for how to do Pokemon Sheets in the next post.
  • ...Additional Pokemon Sheets...: Recommended to color the Tabs (Right Click > "Change color") to match each Pokemon's primary type.

Last edited by ChrisClark13; 08-02-2020 at 03:06 PM.
ChrisClark13 is offline   Reply With Quote
Old 07-27-2020, 04:52 PM   #2
Cascade Badge
ChrisClark13's Avatar
Join Date: May 2012
Location: Utah, USA
Posts: 418
Pokemon Sheet Guide

First off, copy the Blank Pokemon Sheet repeatedly (Right Click > "Duplicate") so that you will have a sheet for each and every Pokemon that you have.

Also, if there is a section that wants a link and no link is provided- no URL BBCode tags will be generated for it.

The rough layout of the sheet is as follows:
  • Top Left: Important information that does not generally change. Some of the cells have white text on top of a dark grey background. Those are automatically filled in so don't edit them.
  • Right: Level, Bond, Contest Stats, and Move Lists.
  • Middle Left: Profile Output for Forums and Profile Output Preview. You will want to copy from the "Profile Output for Forums" section or else your post will be messed up.
  • Far Bottom Left: A section for processing the data in the sheet. Highly recommended that you do not touch this area unless you know what you are doing.

(more coming tomorrow, for now just mess with things and see what changes to learn what's going on)

Last edited by ChrisClark13; 07-27-2020 at 05:03 PM.
ChrisClark13 is offline   Reply With Quote

Lower Navigation
Go Back   UPNetwork > Independent Forums > Fizzy Bubbles > FB Time Out

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -5. The time now is 03:42 PM.

Design By: Miner Skinz.com
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2022, vBulletin Solutions, Inc.