Poking around a bit I didn't see anything like this around so I made my own!
A spreadsheet for tracking Swipp materials doubling as an overview of where to find them
Save a copy to use it yourself.
Of note:
- hover over any item listed to see where to find it. Gathering-only items are highlighted in pale red, coli-only in pale yellow, Swipp-only in gold. Note that items that are available in chests as well aren't listed as gathering/coli/Swipp-only. The number after a gathering method indicates the number of stars that item is (aka, how good at that gathering method you'll have to be to be able to find it), with the asterisk indicating rainbow-star level items.
- if you have enough of a given item for a trade, the "owned" and "needed" fields are highlighted in green. The "enough for" column autocalculates how many trades you could make with Swipp for that item at the moment, and turns green if it's at least one.
- if you enter "N" in the "Interested?" column, the row will turn grey - making it easier to filter out those trades you don't want to make or aren't focusing on. The original colours are all preserved and will return if you edit away the "N" later.
Because I like making life harder for myself by reinventing the wheel, I compiled the info on where to find a given Swipp item from Azophel's Gathering Reference Guide, Maki's text-only Coli drop guide, Amaterasu's Apparel Guide, the Marketplace entry on the FR wiki and Pepperdragon's Chest Locations and Contents. Thank you so much to everyone who worked on those!
If there are any inaccuracies or I missed any trades, please tell me!
A spreadsheet for tracking Swipp materials doubling as an overview of where to find them
Save a copy to use it yourself.
Of note:
- hover over any item listed to see where to find it. Gathering-only items are highlighted in pale red, coli-only in pale yellow, Swipp-only in gold. Note that items that are available in chests as well aren't listed as gathering/coli/Swipp-only. The number after a gathering method indicates the number of stars that item is (aka, how good at that gathering method you'll have to be to be able to find it), with the asterisk indicating rainbow-star level items.
- if you have enough of a given item for a trade, the "owned" and "needed" fields are highlighted in green. The "enough for" column autocalculates how many trades you could make with Swipp for that item at the moment, and turns green if it's at least one.
- if you enter "N" in the "Interested?" column, the row will turn grey - making it easier to filter out those trades you don't want to make or aren't focusing on. The original colours are all preserved and will return if you edit away the "N" later.
Because I like making life harder for myself by reinventing the wheel, I compiled the info on where to find a given Swipp item from Azophel's Gathering Reference Guide, Maki's text-only Coli drop guide, Amaterasu's Apparel Guide, the Marketplace entry on the FR wiki and Pepperdragon's Chest Locations and Contents. Thank you so much to everyone who worked on those!
If there are any inaccuracies or I missed any trades, please tell me!
hopeless nerd 
