Titan Quest Fans Forum

General => General Discussion => Topic started by: Bobinho11 on 26 March 2018, 09:50:02

Title: Excel file for items
Post by: Bobinho11 on 26 March 2018, 09:50:02
Is there an excel spreadsheet or something similar i can use to keep track of the stuff i collected? Console player here, so i cant use tqcollector unfortunately ://

Thank you!
Title: Re: Excel file for items
Post by: Bobinho11 on 26 March 2018, 22:14:15
I had this or something similar in mind:

https://www.scribd.com/doc/23541456/monster-infrequents-cheklist

But obviously for ALL rare stuff, formulae, artefacts etc...just like tq collector.

Maybe i will have to make it myself 😎
Title: Re: Excel file for items
Post by: botebote77 on 26 March 2018, 22:44:43
try this

https://titanquestfans.net/index.php?topic=172.0
Title: Re: Excel file for items
Post by: Bobinho11 on 26 March 2018, 22:52:26
Well blimey..that last excel file has all these items, i see, plus ragnarok (which is coming to consoles as well according to the devs), thanks!
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 27 March 2018, 07:26:53
Good luck with the loot hunt Bobinho11.  At the last count, including Ragnarok items, there's 2,284 specials to be found.  ;D
Title: Re: Excel file for items
Post by: Bobinho11 on 27 March 2018, 09:14:42
Thanks..its gonna be a pain in the behind without tq vault and not being able to copy relics/charms ://
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 14:41:29
Good luck with the loot hunt Bobinho11.  At the last count, including Ragnarok items, there's 2,284 specials to be found.  ;D

I'm using the list from epinter, and there are 2057 (i went through the whole list and deleted the ones with duplicate entries), not counting artefacts and formulas separately... if i count them separately, it's 2141 :S

which list were you refering to, medea?
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 01 April 2018, 14:56:53
TQCollector.  Does epinter's list have all the Easter Egg items as well?
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 15:16:03
The letters? I believe so...i guess i will have to cross check it with the tq collector..is there a link to it on this forum?

Thank you!
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 01 April 2018, 15:37:52
The updated one can be downloaded from here:

https://titanquestfans.net/index.php?topic=234.0

Not sure it'll help you though if you can't install it.  :-\

It's not just the parchments, there are also the sets like the Santa set, the Texan, etc.  They're also specials and are included in the TQCollector count.
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 17:53:45
Oh right...the stuff from the secret passage! Completely forgot about those!

I can install it on pc, no?
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 01 April 2018, 18:09:36
Yes.  But if you don't have the game on there I'm not sure it'll pick up anything or install properly.  It needs paths so it can tell you what you've found or not.
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 18:11:45
I see..well, i actually have the game still installed on pc, but its.the anniversary edition, without ragnarok...
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 01 April 2018, 18:31:45
It should still give you all the items that aren't in the expansion since you can toggle it not to show the Ragnarok items.
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 22:14:35
All right, will give it a go and hope that only the secret passage items are missing.

Really thanks a lot, medea, for answering my pestering questions :))
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 01 April 2018, 22:43:59
Not problem. :) It was the helpful folk over on TQ.net that really got me into the game and the way I see it is this forum, any gaming forum really, is all about sharing and passing on the knowledge players of the games have acquired over their years of playing.  If we can't do that we may as well close up shop and play in a vacuum.
Title: Re: Excel file for items
Post by: Bobinho11 on 01 April 2018, 23:13:36
Couldnt agree more! Cheers!
Title: Re: Excel file for items
Post by: epinter on 01 April 2018, 23:28:28
See the file 'tqloot-itemlist.xlsx' in https://drive.google.com/drive/folders/1kN_MOqBMS4hSkQMj0ZNjKi4j7-LN45Tq (https://drive.google.com/drive/folders/1kN_MOqBMS4hSkQMj0ZNjKi4j7-LN45Tq). Is a list with all items (2300 found ).
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 02:14:05
Did u update this list? If not it is the same list from which i removed all the duplicate entries and was left with 2057 items...
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 05:12:13
Did u update this list? If not it is the same list from which i removed all the duplicate entries and was left with 2057 items...

It's a new list. Just items, no drop chance.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 11:43:41
wow, this is amazing, thank you!

I couldn't see the file before on the phone (it didnt show them all for some reason), but they are all visible on pc..

The annoying thing now will be to make a kazzillion mule characters for storage :/

PS: what are these items?

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS

(supposedly all from Ragnarok)
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 11:54:54
There is an updated TQVault for out of game storage purposes.

https://titanquestfans.net/index.php?topic=246.0

It works with PCs, but I don't know if there's a console version yet.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 11:55:54
There is an updated TQVault for out of game storage purposes.

https://titanquestfans.net/index.php?topic=246.0

It works with PCs, but I don't know if there's a console version yet.

thanks, but yes, i would need something for the console.. doubt this will happen though :)
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 12:05:22
Well, you never know.  If the game's popular someone out there will adapt it for consoles.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 12:39:50
could be, yes :)

so after using epinter's new list, deleting from it the quest items, i am left with 2288 items, that include these weird 5 items:

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS


If i delete these 5 as well, i am left with 2283 items, whereas TQ Collector says 2284... going crazy here :D the problem is also that i can't see the ragnarok items in TQ Collector, because i don't have the expansion :S
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 12:47:09
2284 includes the Ragnarok stuff.  Try toggling the big R at the top of the Collector - that should switch the Ragnarok items off.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 13:00:18
epinter's list includes ragnarok as well so i don't want to exclude that + ragnarok is coming to consoles as well.

i did however just realise that TQ Collector includes these cheat sets:

373624 "Armament of Gaul"
437626 "Armament of Germania"
925678 "Garb of the Great Merchant"
274267 "Shinobi Shozoku"

Which are definitely not available on console..  but that's 13 items so it's still not completely the same:

Epinter's list: 2283 items .. if i delete the 6 weird ones from before = 2277
TQ Collector: 2271

edit: TQ collector says there are 19 parchments, epinter's list says 20.

Confusion confusion... :)
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 13:22:45
There are only 16 in the IT/AE version of the game.  Ragnarok pushed them up to 19.
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 13:57:49
I think "The Pieces" parchment is not shown by tqcollector.
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 14:12:28
No, that's not seen by the Collector - at least not yet.  Mind you is that a quest item? 
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 14:18:24
No, that's not seen by the Collector - at least not yet.  Mind you is that a quest item?

Yes, from the secret quest
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 14:23:46
Wouldn't show in the Collector then as it's a quest item.  None of those items do.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 16:02:38
I see, so its going out of my list..

Epinter, what are those 6 items i mentioned earlier? Any idea?
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 16:17:36
Special sets that can only be gained by using Unlock Codes.  They used to be yellow items, not sure what they are in AE.  They're not really much good actually, but okay for adding to the collection.

274267 Shinobi Shozoku
925678 Garb of the Great Merchant
437626 Garb of Germania
373624 Garb of Gaul
6788 Li'l Lued

Just start playing one of your toons, hit escape to get to Unlock Content, click on it, type in a code and click okay and the set will fall at your feet. Li'l Lued is an Artifact.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 16:24:59
I meant these 6 from epinters list:

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS

I know about the sets you mentioned, medea, but they are not availabe on consoles :/
Title: Re: Excel file for items
Post by: Medea Fleecestealer on 02 April 2018, 16:47:57
Never come across those, so either new for console or something else.
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 17:21:23
I meant these 6 from epinters list:

PI Amulet
PI Axe
PI Greaves
PI Helmet
PI Torso
tagPANTS

I know about the sets you mentioned, medea, but they are not availabe on consoles :/

The tq database has some items without name that I already ignored. Just found that the "PI *" are items for tutorial. tagPANTS needs to be removed too, looks like another not used item inside the database.
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 19:10:59
I've made a cleanup in the list, removed:

-Tutorial items
-Dev/test items
-Duplicated mi items (base game/ragnarok)
-Temporary records causing duplicated items

Now the list has 2264 items.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 19:22:54
Great, thanks a lot! And i am sorry for pestering both of you with all these questions :)))

Are the quest items still included?

Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 19:29:18
Great, thanks a lot! And i am sorry for pestering both of you with all these questions :)))

Are the quest items still included?

I removed all items with type QuestItem and classification Quest. The only quest related item that is present in the list, is a parchment that is not exactly a quest item...
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 19:31:19
awesome, i will use this a basis for tracking my collection, thanks a lot! :)
Title: Re: Excel file for items
Post by: epinter on 02 April 2018, 23:40:21
awesome, i will use this a basis for tracking my collection, thanks a lot! :)

Sorry if you started to use it, but I had to update the list again :D

I removed some duplicated Monster Infrequents and Legendary, 1 test formula, 1 test artifact, and 1 test parchment.

Also added some monster infrequents that was missing (some of gigantes items).

19 parchments
93 charms
123 relics
84 formulas
84 artifacts
735 monster infrequents
337 items inside sets (doesn't include 13 items from yellow sets unlockable using code)
792 legendary + epic (excluding items from sets)
Total of 2267 items.
Title: Re: Excel file for items
Post by: Bobinho11 on 02 April 2018, 23:46:33
No problem, thanks for doing this and keep me updated please if you make any more changes 😀
Title: Re: Excel file for items
Post by: AlcyonV on 03 April 2018, 03:26:29
19 parchments
93 charms
123 relics
84 formulas
84 artifacts
735 monster infrequents
337 items inside sets (doesn't include 13 items from yellow sets unlockable using code)
792 legendary + epic (excluding items from sets)
Total of 2267 items.

TQCollector counts 336 set items (without the 13 others) and 791 uniques. I don't know where the difference lies.
Title: Re: Excel file for items
Post by: epinter on 03 April 2018, 04:37:44
In set items, TQCollector is missing "Blackbeard's Hook" (Buccaneer's Garb).

In the uniques, TQCollector is missing "The Sword in the Stone" (Legendary).

These items doesn't drop anywhere.

EDIT: Also, TQCollector has "Outrider's Skullcap" and "Outrider's Tunic" duplicated, in "Centaur" and "Centaurs (Corinth)"
Title: Re: Excel file for items
Post by: Bobinho11 on 03 April 2018, 08:36:15
In set items, TQCollector is missing "Blackbeard's Hook" (Buccaneer's Garb).

In the uniques, TQCollector is missing "The Sword in the Stone" (Legendary).

These items doesn't drop anywhere.

EDIT: Also, TQCollector has "Outrider's Skullcap" and "Outrider's Tunic" duplicated, in "Centaur" and "Centaurs (Corinth)"

Why dont they drop? Bugged?
Title: Re: Excel file for items
Post by: botebote77 on 03 April 2018, 09:13:24
the sword in the stone cannot be dropped by monsters because they cannot equip it.. they cannot pull it from the stone, only the worthy can

lol seriously i didn't know this item existed in the game

edit: i searched for it and this is what i found:

(https://vignette.wikia.nocookie.net/titanquest/images/8/8f/Tq-club-l-the-sword-in-the-stone.png/revision/latest?cb=20180204000346)

it's a club.. it seems even the hero is not worthy.. he/she cannot pull it from the stone and cannot get its magical powers ;D
Title: Re: Excel file for items
Post by: Bobinho11 on 03 April 2018, 10:23:53
so we might as well delete it from the list :D

what about blackbeard's hook? does this even exist?

it's not listed here for example:

https://www.tq-db.net/set/buccaneers-garb
Title: Re: Excel file for items
Post by: AlcyonV on 03 April 2018, 22:00:37
In set items, TQCollector is missing "Blackbeard's Hook" (Buccaneer's Garb).

In the uniques, TQCollector is missing "The Sword in the Stone" (Legendary).

These items doesn't drop anywhere.

EDIT: Also, TQCollector has "Outrider's Skullcap" and "Outrider's Tunic" duplicated, in "Centaur" and "Centaurs (Corinth)"

Thanks for the answer. Actually not any important stuff here. I didn't mentionned the MI outrider's stuff because I already said this to Malgardian in TQC thread a few days ago.

Blackbeard's hook doesn't drop at all according to Epinter.
Title: Re: Excel file for items
Post by: Bobinho11 on 04 April 2018, 10:02:47
ok, so i will delete both items from the list, ty all!
Title: Re: Excel file for items
Post by: Tauceti on 04 April 2018, 10:49:05
Have you access to some of the items properties ?

I am in search of a list of items that come with proc skills:
-activated on attack
-activated upon taking damage
-activated upon taking melee damage
-activated upon taking ranged damage
-activated when equipped
-activated on low health
SimplePortal 2.3.7 © 2008-2024, SimplePortal