Quest spreadsheets.

[posu]

I always use spreadsheets to manage my quest items and I'm sure other players would enjoy that too. For those of you who enjoy them but too lazy to make them, here are the ones I made. As I make more, I'll put them here.

The format I use is pretty self explanatory, perhaps even more so if you are experienced with excel. If you don't get it, skim my tutorial below.



Key Quests:
- Desert Beach Key Quests. (Print)
- Caballa Relics Key Quests. (Print)
- Oops Wharf Key Quests. (Print)
- Mermaid Palace Key Quests. (Print)
- Ghost Blue Key Quests. (Print)
- Rose Garden Key Quests. (Print)
- Black Swamp Key Quests. (Print)
- Snow Hill Key Quests. (Print)
- Techichi Volcano Key Quests. (Print)
- Tapasco Volcano Key Quests. (Print)

- All-in-one Key Quests.


Episode Quests:
- Episode 1 Quests. (Print)
- Episode 2 Quests. (Print)
- Episode 3 Quests. (Print)
- Episode 4 Quests. (Print)
- Episode 5 Quests. (Print)

Others:
- Abyss Sticker Quests. (Print)




Tutorial:

Spoiler!

To maximize the usefulness of the spreadsheets and manipulate the data, you have two options:

#1) Export the spreadsheets onto your computer. (File > Export > .xls)
#2) Log onto Google Docs with your gmail account. Open my spreadsheets and create a copy (File > Create a copy...). And that's it. Most convenient.


Using the spreadsheets:

First, input the amount of characters you have by replacing the 1 (Default) at the top with the amount of characters you are farming for. If you are only farming for 1 character, leave this value alone.





The Required column displays the amount of the item you are required to complete the quest. Input the amount of the items you have currently in the Currently column. That amount will be deducted from the Remaining column and it will display the amount you have left to complete. Furthermore, the % column will display the percentage of your progress.

The Item column lists the item names and the Description column shows you where you can find that item (the info may not be complete but it should be close).

Enjoy and feel free to rep me.

[Esper]

Nice job.

Would it be okay if I input this into the wiki techi quest for others when they check wiki?

[posu]

I don't see why not. :D

edited: if possible, link it back to this thread.

[Sombre]

GL with that.

[Tardar]

Very nice, easy to understand. 8D

[posu]

I added a copy of Snow Hill/Ice Dungeon. If anyone wants me to add a particular quest first, tell me and I will do it.

More importantly, I realized that you don't have to export the spreadsheets to edit the data, you can do it with a Google Docs account; read the tutorial for more. Also, I updated the tutorial with images for players inexperienced with spreadsheets.

[Khmer1337]

lol i also use spread sheets but mines is way different, i use paper and pencil lol and i erase the number and replace it everytime i get one of the needed items

[Sombre]

Umm I made one for episode 2 if you want to use it (Currently on Ep. 2):
http://spreadsheets.google.com/ccc?k...eEGTgiWzpStKnQ

[arno]

These sheets are great!
Thank you for sharing them.

Umm I made one for episode 2 if you want to use it (Currently on Ep. 2):
http://spreadsheets.google.com/ccc?k...eEGTgiWzpStKnQ

Yours work, but all items after Dark Choco Piece did not consider the amount of characters you had.

Do you know how I could get them all on one doc. as different sheets? I tried exporting/importing, but they ended up all separately. Maybe I'll do it again in Excel.

[posu]

Originally Posted by Sombre

Umm I made one for episode 2 if you want to use it (Currently on Ep. 2):
http://spreadsheets.google.com/ccc?k...eEGTgiWzpStKnQ

I appreciate your effort but you took down some of the formulas. Simply said, your version doesn't work correctly.

Originally Posted by arno

Do you know how I could get them all on one doc. as different sheets? I tried exporting/importing, but they ended up all separately. Maybe I'll do it again in Excel.

At the bottom of Excel where you have the various sheets, right click a new sheet and click insert. Then drag a different .xml file into the current spreadsheet. The other .xml will go into the current one. Rinse and repeat until you have all the key quests in the same .xml. That's one way I know of.

[Qio]

wow ty for this its rly usefull
+rep

[badna0]

this is really useful. I tried to +rep. but I already have to you lately, apparently.

guess you're just too awesome.

[Esper]

Usopsama, thanks for creating a spread sheet for all the maps that have key quests / episode items.

I have put all of your spreadsheet links and thread info into the quest pages.

[posu]

Originally Posted by Mirae

Usopsama, thanks for creating a spread sheet for all the maps that have key quests / episode items.

I have put all of your spreadsheet links and thread info into the quest pages.

Thanks for doing that.

Originally Posted by arno

Do you know how I could get them all on one doc. as different sheets? I tried exporting/importing, but they ended up all separately. Maybe I'll do it again in Excel.

I added an all-in-one version.

[badna0]

small corrections, I believe for swamp you need 25,25 swamp worms (instead of 25, 15), and 25 tadpole eggs (according to the wiki). Keep up the great work!

[Vith]

Arg, I forgot to make a post to tell you how much I appreciate the time and effort you put into making these. Thanks usopsama, it's greatly appreciated!

Once again, you make a great contribution to the community. I tried to give you reputation, but it said I had to give some more before I gave you reputation again. D;

[posu]

Originally Posted by badna0

small corrections, I believe for swamp you need 25,25 swamp worms (instead of 25, 15), and 25 tadpole eggs (according to the wiki). Keep up the great work!

I corrected them. Thanks for the head's up. :D

Originally Posted by Vith

Arg, I forgot to make a post to tell you how much I appreciate the time and effort you put into making these. Thanks usopsama, it's greatly appreciated!

Once again, you make a great contribution to the community. I tried to give you reputation, but it said I had to give some more before I gave you reputation again. D;

You are giving me too much credit.

Anyway, I'm glad people are finding these spreadsheets useful. :D

[Melody]

uhh... i think for episode 3 chapter 1 you missed a few items D:

[posu]

Originally Posted by Melody

uhh... i think for episode 3 chapter 1 you missed a few items D:

Fixed. :D

[ZeroShadow]

usopsama, on the episode 3 quests, you've put 5 papyrus but it's only 1 I guess oO

And great work with those. Helps a lot when I'm doing quests ;D