Route Auditing Spreadsheet
This spreadsheet by pidge allows you to write down the actions taken in your route, one-by-one, that affect the state of your party in any way. This includes obtaining items, swapping equips, winning battles, finding coins, selling stuff, using flower tabs, etc etc, literally anything that can affect the state of your coins, frog coins, flowers, inventory, or party members' stats & EXP. It is intended to help you recognize if there is anything in your proposed route changes that would be spending money you don't have, equipping items you don't own, maxing out your inventory when unintended, and such.
How to use
Make a copy of this sheet to start from scratch. Here is the sheet pre-filled with the Any% 2.01 (2021) route.
It runs pretty slowly, so I recommend just writing stuff to it instead of waiting for it to update after every action. It's a google sheet with a lot of math going on in it.
Columns A through OZ are output (calculation) columns, so don't overwrite them.Â
For any row, the output is the state of your game after the actions taken in the previous row.
A through KZ indicate how much of each item you have in your inventory (excluding equipped items) at any point in the route. When you have more than 0, it's highlighted in green to help your decision making.
LA through OG indicate your party members' level, EXP, current equipment, and stats (with and without equip bonuses). (Equipment must be denoted by item ID. All item IDs are listed in the spreadsheet beside their item names). Green columns are your stat value after applying equipment. The white column to the left of a green column indicates the character's base stat without equipment.
OH through OU give you an idea of how full your inventories are, how many coins/flowers you have, and how many times you've used Jump. "Min" and "max" means that you can accommodate for things like 25% boss drops or Mario being KOed before he can finish using Jump. In your item/equip columns, the center column will show a red question mark if the sheet has detected that you've tried to sell, toss, or equip an item you haven't indicated that you own yet.
OV through OZ are a quick reference for your party's levels, intended to help you figure out when swap glitches might be eligible, or when you might run into animation pauses during stars. Cells will be highlighted green when someone levels up.
If the math isn't working out, because you're trying to swap equips you don't have or buying items with a full inventory or whatever, output cells will be highlighted to tell you as much.
Column PA, Action Name, you can write anything you want. It's there for you to remember what's going on with the steps you take. e.g. "Sea star hit 1" or "Beat Croco" or "Sell stuff in Moleville"
Columns PB through ACU are your deltas (NOT totals!). This is where you can write what's changing with every action you do.
For coins, frog coins, and flowers that you receive, and Jumps that you do, you can fill out a min and a max for however many you're gaining/spending/doing. Most of the time you won't need to fill out a max. However it can be useful if you're trying to experiment with coin routing and want to note a treasure chest as optional to see how it'd affect your coin route later on. Don't use these columns for shop actions, those are handled below.
The Recruits column is for when your party members join. Put 1 in their column at the row representing the point at which they enter your party.
The EXP column you should fill out if you gain EXP from a battle or a star. You don't need to do it hit-by-hit, but doing so will show you at which hit each level is gained (to plan around things like levelup animation paused). The sheet will add it to everyone who you've indicated has joined your party, and will double the amount for whoever you've indicated has EXP booster. If you don't know how much EXP a fight will give you, you can use pidge's EXP router to figure it out.
Each character has 3 equip columns. If you are changing someone's equips, in your action, put the new equip IDs in the slots for that character that are being changed. To unequip a slot, simply use the number 0 for the id. You can look at the columns to the left of Column OY to see what equips your characters have at any point in the run. (This means don't put "76" in Mario's accessory slot for literally every row after you equip Jump Shoes. You only need to write it at the point where you physically equip them.)
Each character also has a POW, HP, and SP column. If you see that a character has leveled up, put 1 in the column corresponding to which stat you'd pick for them. You can then see in your left columns how this will impact their stats. Don't need to indicate the amount, that is supplied by the sheet. These cells are highlighted in green when the sheet detects a levelup, to remind you to fill them out.
Each character except Mario also has a swap column right in the middle. Use this if you are performing skill swap during a levelup. Put the ID of the character (mallow=2, geno=3, bowser=4, peach=5) you are swapping with in the same row where you choose your levelup stat bonus, and it will switch their stat increases appropriately.
There is a column for "Shop?" which you can simply fill out with TRUE or leave blank. All of the columns to the right of this are columns corresponding to invidual items. If you indicate -1 for an item, it will assume you just tossed it, unless you have "Shop?" set to TRUE, then it will assume you sold it, and give you the correct coins (prices are stored elsewhere in the sheet. This means DON'T use the Coins column for buying/selling in shops!). The reverse is also true, if you indicate 1 for an item, it will assume you just found it or were given it, unless you have SHOP checked off, then it will assume you're buying it and will subtract the requisite coins.
To account for freebies in fights, I indicate the (negative) number of the item I have to use in battle, and then in the "extra" column beside it, indicate the (positive) number of freebies I want to account for. In the reverse, to indicate things like "get sewer flower if you missed doge jump", you do the reverse (positive number for min, negative number for max).
Happy routing!