Guides

[center]Heya! Do you like grinding mindlessly for hours in the Coliseum? Do you enjoy cataloging the best drops you find because collecting data is fun? Do you find fulfillment in completing Coliseum challenges and posting your loot collections to forums as a way to document your progress? Me too! You know what I [b]hate?[/b] Typing. Out. All. The. Drops. I. Find. That's what this spreadsheet is for! I made this because I decided to embark on a time-consuming [url=https://www1.flightrising.com/forums/qnc/3310423/1]"Finding an Egg in Every Coliseum Venue" challenge[/url], which means I find a LOT of drops in-between eggs. So many familiars. So many pieces of apparel. My dragons will never go hungry again, I have so much food. [size=4][b][emoji=gold star] [url=https://docs.google.com/spreadsheets/d/1JfFlOaN8XS9WTcRD2z0ptZInUX1lA9hLJfCspa1ke50/edit?usp=sharing]NORMAL VERSION[/url] [emoji=gold star][/b][/size] [i]This version includes all "special" drops from the Coliseum. It excludes food, material, and most trinket drops.[/i] [size=4][b][emoji=blue star] [url=https://docs.google.com/spreadsheets/d/1g3-ZVXXNjKaCyighP3ns9HP04YLdSbzM5yQye_wXt6U/edit?usp=sharing]INCLUSIVE VERSION[/url] [emoji=blue star][/b][/size] [i]This version includes ALL Coliseum drops. All of 'em![/i] [size=4][emoji=rainbow star 2 size=1] [b][url=https://docs.google.com/spreadsheets/d/1KrwkLm1ce3niglDTRuA8XNergC_2I1IMl9jUxW-S8OQ/edit?usp=sharing]FESTIVAL (NORMAL VERSION)[/url][/b] [emoji=rainbow star 2 size=1][/size] [i]This version includes all "special" drops from the Coliseum. It excludes food, material, and most trinket drops. It includes festival items and has a button to wipe your sheet to start fresh. May run a lil slower due to so many moving parts.[/i] [size=4][emoji=pink star size=1] [b][url=https://docs.google.com/spreadsheets/d/17rrS5ctxrGXqvqpZoJOAfM5reJvSeGegxdVsVFv8vT8/edit?usp=sharing]FESTIVAL (INCLUSIVE VERSION)[/url][/b] [emoji=pink star size=1][/size] [i]This version includes ALL Coliseum drops. All of 'em! It also includes festival items and has a button to wipe your sheet to start fresh. May run a lil slower due to so many moving parts.[/i] [size=5][b]How to Use[/b][/size] [list=1] [*]Open the Spreadsheet, then select [b]File > Make a Copy.[/b] Name it whatever you want, and save it to your own Drive. [*]Start Coli grinding! The tabs are organized by Coli venues. Whenever you find something of value (familiar, apparel, runestone, EGG, etc.), add to the tally beneath the respective graphic. [*]The Sheet is organized by drop types (my own preference): [b]Treasure Chests, Familiars, Apparel, Battle Items, Scenes and Vistas, Scrolls and Vials, Skins, Runestones, Deity Dolls (I like them!), and EGGS![/b]. The top bar will keep a summary of the venue's loot you've tallied so far. [*]If you'd like to post your loot collection to the forums, copy and paste the rightmost colored column (again, organized by drop type). It will spit out the widget and number of all your drops, encased in a nice quote for convenience, like so:[/list] [quote name=Familiars][b][item=Leafy Moth]x3 [item=Chipskink]x1 [item=Bumble]x2 [item=Crimson Emperor]x4 [item=Ember Mouse]x4 [item=Ragepuff]x1 [/b][/quote] It's pretty easy to understand! No more time wasted on typing out the loot widgets for forum posts! [size=5][b]Errors[/b][/size] If you notice something that isn't quite right (typo, faulty code, something's wrongly labeled or missing, etc.), let me know where I can find the error and what's wrong. I've been staring at this sheet for days, it's pretty likely that something slipped past me. [size=5][b]Pinglist[/b][/size] [pinglist=33558] Join the Pinglist to receive updates! You will be notified whenever I make adjustments to the sheet. This will include large updates for things like new venues and items, as well as small updates like error edits and minor code edits! ----- [size=2]Huge thank you to [url=https://www1.flightrising.com/forums/gde/1419000]Maki's Coli loot and monsters guide[/url] (where I found all the info for Coli drops) and [url=https://www1.flightrising.com/forums/cc/1985777#post_1985777]Serpenta's bio buttons[/url] (which added a cute flair to the top-left corner of all the venue tabs).[/size][/center]

@RabbitSpirit Thank you, happy to help!! Typing out all the widgets for things like apparel and familiars and whatever else was such a pain in the behind. I did it once, then vowed to create a tool to do it for me the next time because I never wanted to do it again.

[center][b]Spreadsheet Update (March 13, 2024):[/b] Added the Peridot Enhancement apparel set to the Golem Workshop. [item=Peridot Arm Enhancement (Back)][item=Peridot Arm Enhancement (Front)][item=Peridot Spine Enhancement][item=Peridot Ocular Enhancement][item=Peridot Leg Enhancement (Back)][item=Peridot Leg Enhancement (Front)][item=Peridot Jaw Enhancement][item=Peridot Tail Enhancement][item=Peridot Wing Enhancements] [url=https://www1.flightrising.com/forums/ann/3321971/1]Announcement Link[/url][/center]

[center][b]Spreadsheet Update (April 25, 2024):[/b] Added the [b]Ancient Gene Parchment: Pachy[/b] to all venues. [item=Ancient Gene Parchment: Pachy] [url=https://www1.flightrising.com/forums/ann/3330141/1]Announcement Link[/url] Also made minor code adjustments.[/center]

[center][b]Spreadsheet Update (May 26, 2024):[/b] Split the INTRO tab into two tabs: [b]INTRO[/b] and [b]FESTIVALS[/b]. The content in the INTRO tab hasn't changed. The FESTIVAL tab now lets you track the number of festival drops you find, both currency and chests! It also generates forum code for you to post! Great if you're doing Coli festival challenges! Happy Greenskeeper Gathering everyone! Hope you find lots of leaves and chests! [item=Bladed Flatleaf][/center]

[center][b]Spreadsheet Update (June 14, 2024):[/b] Added the [b]Breed Change: Fathom[/b] to all venues. [item=Breed Change: Fathom] [url=https://www1.flightrising.com/forums/ann/3344751]Announcement Link[/url] Hope everyone had a great 11th anniversary and a fantastic Unfathomable Odyssey![/center]

omg, I think I might be in love with you /swoons

Subscribing to this thread for update reasons <3

THANK YOU SO MUCH <3 <3 <3



EDIT: I'm not sure how you put together the sheet and code combo, but I'd like to add chests to the various venues? Things like the Leafy Pack dropped in the Woodland Path, or the Lustrous Shell that's dropped in the Kelp Beds, etc? :)

@ThistleProse I've been debating on and off about adding small chests like that since I personally don't track them, but I'm realizing others do! Give me a little while and I can add them in, it shouldn't take me long!

[center][b]Spreadsheet Update (June 15, 2024):[/b] Added the [b]Treasure Chests[/b] row to all venues. [item=Leafy Pack][item=Barnacle-Encrusted Bottle][item=Frozen Knapsack][item=Waterway Pipe][item=Cryptic Cube] [i][b]Note:[/b] Some venues have treasure chests that share the same graphic but are two different drops (example: the Featherfall Pack and the Feather Pouch from Harpy's Roost). [item=Featherfall Pack][item=Feather Pouch] Check the note in the cell to see which drop is which![/i][/center]