Hello fellow orchard and apple pickers Valentine's Day event is upon us and thus the apple orchards will be full with our hundreds of characters. If you're like me and have a pea sized brain who can't remember 5 minutes ago, I always run into the issue of forgetting which characters ran APQ per reset day. Sooooooo, I slapped together a Google Sheet that helped my friends and me keep track of our 135+ characters for APQ :^) >>> APQ Tracker link <<< Key features of this spreadsheet: Easily mark a character who's run APQ (similar to a to-do list) & reset the all character checkboxes at reset with two button clicks (yay for scripts) Organize all characters' key APQ information: AOE skills for stage 1? Like genesis or Dragon Roar Can it haste for bon? Can it attack the boss? Is it a mule (and thus can't attack)? GR/BR? Class/Job A dashboard that dynamically organizes characters who haven't run APQ, split into categories with the key info above This is useful for the party leader to know who should bring what or who to recruit for missing skills/jobs Record apples picked per character to view overall average apples per set, the standard deviation, and the sample size A fun little leaderboard to compete in RNG with your friends or other characters: View top characters daily View top characters overall View top Apple pickers by person I'm always looking to improve my unnecessarily complicated formulas and spreadsheets, so let me know if you have any suggestions for additional features :3 I will eventually adapt this over into a general bossing tracker after APQ marathon is over.
