Triple Triad Checklist

I love checklist spreadsheets, so I made one for Triple Triad. I used the data from http://ffxivtriad.com to create it.

Here's a link.

To get a copy you can edit, go to that link, then go to the file menu and click "Create a copy."


There are two tabs: one for cards, one for NPCs. On the Cards tab, put an x in the checkmark column if you have the card. As it says at the top, an orange background for an NPC/duty/etc indicates that it is the only way to get the card (counting different versions of the same duty as the same thing, such as Ifrit HM and Ifrit EX). Card stats are listed from the top number going clockwise. Next to the number of cards you've collected is a number of *s indicating the limit on four of your five cards. When your collection hits 30, it'll change to **, and then to *** when your collection hits 60.

On the NPCs tab, do not mark the far left "Done" column. Instead, if you've beaten the NPC at least once, put an x in the "Beat" column. There's a ***** card that you can get from beating 30 unique opponents, and the number of people you've beaten will turn gold when you've marked off 30 NPCs.

The cards that the NPC can drop will be purple if you don't have them and green if you checked them off on the cards tab. Once you have every card an NPC can drop marked off on the cards tab and the NPC marked as having been beaten at least once on the NPC tab, an "x" will automatically appear in that NPC's "done" column and the NPC will be grayed out.


In other words, the only thing you should have to do to the spreadsheet is to put an x next to every card you've obtained and every NPC you've won at least one match against, and the spreadsheet will do the rest.


The tier of the NPC denotes how much they cost to play, and also how much they give on a win. The rules indicate the fixed rules for that NPC - if you notice, all 1st tier NPCs (and the 0th tier NPC) have the "All Open" rule, and all 2nd and 3rd tier NPCs have the "Three Open" rule. No 4th or 5th tier NPCs have either of those rules. I found that interesting.

The Req column lists any requirements you have to meet to play that person, such as having Ixali rep at Rank 7 to play vs Sezul Totoloc. This column is incomplete and I'll update it as I hear of more requirements (for instance, I'd bet the Indolent Imperial requires you to complete the quest "The Ultimate Weapon," but that's hard for me to test).

The NPC card lists are currently blank. When I get the time, I'll add those later. Let me know if you have any feedback or if there are any errors on the page.


To update your sheet when new cards come out, I recommend following these instructions:

1. Make a copy of the latest clean version of the spreadsheet.
2. On your old spreadsheet, in the "Triple Triad Cards" tab, select all of column "A" (the one with all your "x"s in it) and copy/ctrl-C.
3. On the new spreadsheet, in the "Triple Triad Cards" tab, select all of column "A", then rightclick and choose "Paste Special - Paste values only".
4. Do a quick check to make sure the right cards are all marked correctly - I try not to rearrange the cards so this will work, but I did insert a card once that I had missed, so it doesn't hurt to verify the transfer worked right.
5. On the "Triple Triad NPCs" tab, do the same thing, except with the "B" ("Beat") column, if you're tracking the NPCs you've beaten at least once for those achievements.

Changelog
v3.2.1 - Updated for patch 3.2 with all currently available information. Added all the new cards, added a ninth card to the Gold and Mythril packs, and put in all currently available information for the NPC opponents. NPCs will need further updating, particularly when someone hits Rank 8 with the Gnath.
v3.2.3 - Added exact quest names for Vath and Vanu Vanu opponent requirements. Still missing confirmation on the Vath Deftarm's drops and rules.
v3.2.4 - Added quest names for Sezul Totoloc and Mogmill. Still missing Wymond's quest and probably a few others. Added in some more win/lose/draw values (still missing a few, especially for the new ones). Added the details for the Vath Deftarm. Made the number of stars beside your collection indicating star limitations max out at three stars. Marked House Fortemps Manservant as being rank 3 (not rank 4) because he has the rule "Three Open."
v3.2.5 - Added two missing card drops from NPCs - Chimera from Fufulupa and Tonberry from Memeroon (thanks, Shisana!).
v3.5.1 - Updated with all cards up to patch 3.56.
v4.0.1 - Updated with all cards and NPCs from patch 4.0, but some cards lack how to get them and some NPCs are missing card drops.
v4.0.2 - Missing data has been filled in, and all cards and NPCs from 4.0 are all set now.

It's been confirmed by many players that you do not need rank 7 to play with Sezul but that there is a timer for lower ranks so you can only play him at certain times if you aren't max rank. I don't think anyone knows the details of said timer however.

I don't understand how this sheet works. It's on "read-only" to me...

Quote:

---

Originally Posted by mbncd

It's been confirmed by many players that you do not need rank 7 to play with Sezul but that there is a timer for lower ranks so you can only play him at certain times if you aren't max rank. I don't think anyone knows the details of said timer however.

---

Thanks! I'll keep updating the requirements as they're known.

Quote:

---

Originally Posted by cgbspender

I don't understand how this sheet works. It's on "read-only" to me...

---

Go to "file -> make a copy" to make your own copy of the sheet. It's read-only so no one can mark up the copy that everyone sees.



I think I'll add notes to explain the sheet rather than relying on people reading my explanation here.

Quote:

---

Originally Posted by cgbspender

I don't understand how this sheet works. It's on "read-only" to me...

---

You need to make a separate copy for yourself in order to edit it. It was mentioned in the OP, just after the link:
"To get a copy you can edit, go to that link, then go to the file menu and click "Create a copy.""

(I'm not certain whether that requires having an account with Google or not. For me, it automatically put it into my Google Docs when I did that.)

Okay, the sheet has been updated. If you are already using a copy of the sheet and want to use the new version, I'd recommend just making a fresh copy and copying over your x's. That'll be much faster than copying over changed formulas and formatting and such. If the notes copy over (not sure if they will) and you do not want them, just go to "Edit -> Clear notes" and they'll all go away.


Changes:

New information has been added, taken from ffxivtriad.com. A couple mistakes were corrected, but there is a lot of misinformation being posted to that site. The most common mistake people are making is confusing two NPCs that are in the same zone, and claiming on the wrong NPC's page the drops that they received from the other NPC.

There is a new tab - Triple Triad Packs. This is just like the NPCs tab, except for the card packs and individual cards. You do not have to do anything on this tab - it'll all automagically update.

I have added notes to the sheet explaining each column and any dubious information. I do not know if these notes transfer when copying the sheet.

Cards that can only be obtained from a specific NPC or from a specific card pack will now highlight in gold in the NPC and Pack tabs, just like on the card tab.

Most of the win/draw/loss values have been added.


If you find any mistakes on the sheet, feel free to post here, but unless it's a technical problem with the sheet, you should also go to ffxivtriad.com and post there. Please take careful note of what NPC you are playing against before posting to an NPCs page on that site. Many people are not and causing confusion.

Thanks for setting this up. I like keeping track of such stuff, and your checklist spreadsheet is set up much better than any I might have come up with, even if I found all the data to fill it with.

Quote:

---

Originally Posted by Niwashi

Thanks for setting this up. I like keeping track of such stuff, and your checklist spreadsheet is set up much better than any I might have come up with, even if I found all the data to fill it with.

---

I make these all the time because I find it fun. Really, it's just practice for the MIT Mystery Hunt, where being able to throw together a complex Google Drive spreadsheet to solve a puzzle with remote team members is incredibly useful.

For FFXIV, I have one that tracks each stage of the Zodiac questline that I should share at some point. A few parts aren't quite done - animus page only tracks dungeons with an eye for overlap with another job's Zodiac, novus stage isn't quite done (can't get all the PLD numbers or the PIE meld chances for any class =\), and I haven't bothered with the first stage at all.

I have one to track beast tribe faction, which helps you see the optimal order to do Ixali quests in for the fastest progress. I shared that one here a while back - no idea if anyone cared XD

I also have a really complex one for crafting, but I dunno if I want to share it. You fill in the current MB prices on the raw materials tab and it updates all the raw materials that can be crafted and shows which ones cost less to buy vs craft. It also updates the final products tab with the cost to make various items, and if you enter the sale prices of stuff, it tells you how much profit you'd make if you sold it at that price. It's really easy to use it to determine the most profitable crafts at any given time, and if you include the sales speed of the item (# of days between now and the oldest sale on the item's sales history), it'll calculate estimated desirability. The desirability formula also takes into account the investment/profit ratio (how much money is tied up in the item before it sells vs how much you make from the sale). You can also mark quantities sold, and another tab shows you your profits and is set up so you can track profit over time by copy/pasting a line with the formulas removed every time you reset your for sold items list. It's also broken down by category so you can see what craft is the most profitable for you (for me, back when I actually used the sheet it was LTW hands down). Another tab shows profit from desynth automatically updated from the other tabs. Another tab is an endgame crafter gear checklist (updated for 2.3 - stopped bothering to keep track after Artisan's tools) which includes the price to maxmeld each piece of gear.

If anyone wants any of these, feel free to ask here and I can (re)share them. The crafting one though, if you want that, you'll have to contact me privately as I don't really want to put that out there. Also, the crafting one hasn't really been updated since 2.3. When I had what I felt was enough money, I became rather zen about crafting and stopped caring if I made a profit or not. I mostly sell raw materials, items obtained via desynth, and items brought back by retainers these days anyway.

(contact info located in the spreadsheet in the top-left note)

Was there ever a sheet made that includes the new cards/packs/NPCs for HW?

I think the OP has done some great work but do you know FFXIVTRIAD.COM does a checklist?.. Yup, all you need to do is login :)
The link is not shared on the main page for whatever reason..
Also with this you will not need to worry about additional update lists and copy/paste ever again ^^

http://ffxivtriad.com/login

Once you have checked off NPC/Cards they move to the bottom of the list, so you can easily compare the timers of the NPC to the cards you need..

http://snag.gy/f4fMT.jpg
http://snag.gy/do3dx.jpg
http://snag.gy/mn95A.jpg

I am well aware of that site, and used to use it till I found this spreadsheet. That site's interface is atrocious and I have had multiple login and registration issues with it. I refuse to use my social media accounts to log in because privacy concerns and the site account registration doesn't work at all. Due to those reasons I much prefer the superiority and simplicity of the spreadsheet. If no one has updated the spreadsheet, I'll just add to it myself. So my question from before still stands. Has anyone updated the spreadsheet linked in the original post for HW? Thank you.

Oh, hi there, I didn't think anyone was still using my sheet since that website came out (except me), so I never updated the master blank one just my own personal one. I can port the updates over if you'd like. That site is wonderful for stuff like seeing what NPCs are open and it's a great place for people to report new info, but I always liked the simplicity of a checklist spreadsheet for actually keeping track of what I've found. Personal preference and all.

Okay! The spreadsheet has been updated with all the new information for the new cards and NPCs and such. I recommend re-copying the clean version of the sheet and re-marking the cards you have and the NPCs you defeated.

I added data validation to the checkmark columns so instead of having to type in "x", you just hit enter twice. Since I discovered this feature, I've found I far prefer being able to check things off this way.

Please let me know if there are any errors. I took the data straight from ffxivtriad.com, and a few values in the win/draw/lose MGP gains column look really odd. I haven't verified them in-game.

For those who use this checklist, I've updated it with the 3.2 data. However, the information available is not 100% complete. Among other things, no one can have the Gnath Beast Tribe reputation up to Rank 8 yet, and it is believed that rank 8 is required for one of the challengers.

As usual, it's easiest to update your copy of the sheet by re-copying the sheet and then copy/paste your checkmarks from your old sheet to the new one.

This is amazing!!!! Thank you so much for making it. :)

You should update your list as having 90 cards does not allow you to build a 4 star deck.

Quote:

---

Originally Posted by Grimmel

You should update your list as having 90 cards does not allow you to build a 4 star deck.

---

Oh yeah, I guess it does imply that. I'll max the stars beside the deck at 3.

EDIT: Updated the sheet.

I have been using this checklist and love it! However there is something to add atm (was unable to add comment on sheet)

NPC Momeroon also gives out Tonberry as a reward.

Only thing i have found so far. Ill keep updated if i find more :3

Edit: More addings.

NPC Fufulupa Also gives Chimera.

Quote:

---

Originally Posted by Shisana

I have been using this checklist and love it! However there is something to add atm (was unable to add comment on sheet)

NPC Momeroon also gives out Tonberry as a reward.

Only thing i have found so far. Ill keep updated if i find more :3

Edit: More addings.

NPC Fufulupa Also gives Chimera.

---

Thanks!

Sorry about the comments thing - I had the settings wrong. You should now be able to comment for future corrections.

Anytime, ill make comments accordingly as i find more things :3 love the guide!

The Y field for both these characters is missing. I'd patch it up myself but I can't make head nor tail of the sheet formulas that you've used. I still have to say though, it is a marvelous spreadsheet.

This checklist should now be updated with all of the latest cards. Please let me know if there are any errors.

There are three cards up on ffxivtriad from the latest batch that do not have stats, names, or ways to acquire them. I have left spaces open for them in the sheet, listing them as (unreleased card 1/2/3).

Thank you for keeping up with this, it's a fantastic tool and works perfectly. Clearly a lot of work was put in to this, and it is really appreciated!

The checklist has been updated for 4.0.

Triple triad npcs of 4.0 have been generous. Already have all 4.0 npc cards

Thanks for updating this spreadsheet; I have found it very useful.

Just a quick question, is there an easy way to transfer our data from an older version of the spreadsheet to this new one? Thanks.

Quote:

---

Originally Posted by pacifist0rz

Thanks for updating this spreadsheet; I have found it very useful.

Just a quick question, is there an easy way to transfer our data from an older version of the spreadsheet to this new one? Thanks.

---

Sorry for the late reply, I don't check the forums much these days.

The quick way to transfer data:

1. Make a copy of the latest version of the spreadsheet.
2. On your old spreadsheet, in the "Triple Triad Cards" tab, select all of column "A" (the one with all your "x"s in it) and copy/ctrl-C.
3. On the new spreadsheet, in the "Triple Triad Cards" tab, select all of column "A", then rightclick and choose "Paste Special - Paste values only".
4. Do a quick check to make sure the right cards are all marked correctly - I try not to rearrange the cards so this will work, but I did insert a card once that I had missed, so it doesn't hurt to verify the transfer worked right.
5. On the "Triple Triad NPCs" tab, do the same thing, except with the "B" ("Beat") column, if you're tracking the NPCs you've beaten at least once for those achievements.

That shouldn't take more than a minute or so, and is far, far less painful than editing your old sheet. It's how I update mine.

I'm sorry for reviving this old thread but I HAVE to thank you for this. Never really farmed cards until now and I wanted to start and this is helping me so much. Cheers!

I love this, thank you very much for it!

Will you do a new update with the new cards from last nights update?

Thanks again!!!

Thank you very much!

Just wanted to thank you again for updating this spreadsheet for 4.2

Question: The directions for updating to a new sheet indicate copying/pasting the Xs column, and the author states they don't rearrange the card list so it should be fine.

But what if I've rearranged my own existing list? At various points I've sorted by zone (to find NPCs near me) or name (to double-check my list and be sure I've checked all the right ones). How can I ensure my list is sorted the same as the original so that my Xs will paste into the right boxes? As it stands right now I'm afraid to try it since I assume it'll just copy the Xs down the column into the correspondingly-placed boxes on my sheet, which won't match the order of the new sheet.

Thank you so very much for taking the time to make this six years ago! Its still really useful.