Guides

[b]10-DROP COLI CHALLENGE FOUND [url=http://www1.flightrising.com/forums/qnc/1832206]HERE[/url][/b]. *but can be used by anyone to track "interesting" loot (such as: apparel, battle stones, etc.). [u]What's the 10-drop coli challenge?[/u] It's a coliseum challenge by @Zyxx where you look for 10 'interesting' loot (chest, familiar, battle items, apparel, etc) per venue. You can't move from one venue to another unless you've found 10, and you can't go back to a venue once you finish it (unless you're done with the challenge). You can choose to count duplicates (ex. getting 3 Health Potions counts as 3 items) or not (ex. getting 3 Health Potions count as 1 item). The spreadsheet/tool keeps track of your current and past venues, your loot (and amount of loot) per venue, and the completion status of each venue as well as the challenge as a whole. It also automatically produces the bbcode for your loot for easy copy-pasting purposes. [center][url=https://docs.google.com/spreadsheets/d/1RMO8rZbBikcc2nT4EiCBtmMrBa6rb3UtmfZVazseasc/edit?usp=sharing][img]http://i.imgur.com/tLQjCOs.png[/img][/url] To use, go to [b]File -> Make A Copy[/b]. [b]* [url=https://www.dropbox.com/s/utu4bi7hv8z1tsc/10droptracker%20.exe.rar?dl=0].EXE APPLICATION VERSION[/url] (out of date)[/center] For any concerns/complaints/suggestions, please either pm me or ping me here with your concern/complaint/suggestion.

KNOWN ISSUES
These are issues which are very unlikely to get fixed because they're largely dependent on Google sheets' limitations/things I can't find a solution to.

** "COMPLETED" venues will have an "INVALID" error show up on the items list. This will NOT affect anything else in the spreadsheet.
(UPDATE: THIS ERROR IS NOW FIXED AND SHOULDN'T SHOW UP.)

---

UPDATES
To update: copy paste the affected area from the main sheet to your personal copy, OR make a new copy of the main.
If making a new copy and copy pasting current progress, manually enter the venues and copy and paste ONLY the items and amts.

2020
SEP 6 ** all data updated, portal added. venue info format changed a bit again to try to make it less laggy.
Affected area: all sheets. better to just make a new copy.

2019
DEC 10 ** MEGA UPDATE. all data is now up to date, as well as minor fixes to make future updates less headache inducing.
Affected area: references&ordering&sheet tabs. better to just make a new copy.

2018
Aug 30 ** IMPORTANT. overhauled references using Gathouria's modifications (with editing).
Aug 30 ** fixed forgotten cave not showing up. added validation formula that accidentally got deleted last time.

Aug 28 ** general updates. added festival chests + currency. added 19th venue slot. modified completion status so now registers ">=10" as complete.

2017
Apr 23 ** added festival chests + giant sand dollar

Apr 07 ** updated all venues+loot up to apr 2. added new settings tab to choose what gets included.

2016
Jul 24 ** added Vistas and the two new woodland path skins

Jun 6 ** added an option to choose whether to count duplicates or not.

Jun 3 ** fixed a problem where only the bbcode for the first venue was showing; forgot to put in the function for the bbcode for the other venues. Also, spreadsheet now has a link to this thread.

RESOURCES USED
** google drive thank you, google, for providing for all of my digital needs.
** Maki's Coliseum Drops (Text Only) for the loot lists
** good old fashioned fr updates for updated lists

@retrace

Is there a way to count duplicates of an item without breaking the COMPLETE/INCOMPLETE parameters? (ex. in the Ghostlight Ruins I got 6 Health Potions and 7 Bonebound Chests, which I had been counting as one unique drop for the challenge, but that adds up to more than 10 items total).

@retrace

Just wanted to say thank you; it works pretty well - apart from the duplicate extra items already mentioned it's pretty perfect!

@Miraear
Not in the default sheet, no, though you can modify the functions on your personal copy. If you check the functions used for the 'IN/COMPLETE' cells for each function, you'll see they say something like =IF(SUM(C4:C13)=10,"COMPLETE","INCOMPLETE"). What you can do is to change this to =IF(COUNTA(B4:B13)=10,"COMPLETE","INCOMPLETE") IN THE CELL B2 (aka the first in/complete cell). Then, copy the cell and paste it on the other in/complete cells so they automatically change B4:B13 to whatever range is needed. That should do the trick, but contact me if there are any complications. :)

@Voleste
No prob. :D And the above should work as a no-counting-duplicates workaround.


Note to self: add option to choose whether counting dupes or not

@retrace

Thank you, that works well! However, it does cause most of the loot cells for each venue to create a red tab that says "Invalid content: This cell's contents violate its validation rule"

@Miraear
All venues? Or all venues except for your current venue?
If the validation error warning only appears once you've finished a venue, that's an unfortunate side-effect of the way I made the sheet, but should be mostly harmless.

Due to college being a female dog in heat, the spreadsheet might be just a bit outdated. Will be working on updating it as much as I can, but I only have a day free before I'm swallowed by classes again so no promises.

EDIT: nvm, I apparently didn't miss much. spreadsheet is now, as far as I can tell, fully updated. have fun.

I LIVE

updated the link for the challenge thread and Sigiele/Zyxx's ping.
will be updating all new items since the last time.
might try to add a settings tab if i have time later? would make it possible to choose which kinds of loot to count, etc.