Hoarder's Excel Document

I know I'm not the only person out there who is a filthy hoarder. Just can't stop hoarding all the uniques, gotta catch 'em all!

I had way too much time on my hands and made an excel spreadsheet to keep track of what uniques I have and which ones I don't, figured if anyone else wants a blank copy so they can keep track of there's, well might as well here you go.

Edit: and now it is google sheet. anyone can make a copy of the document for themselves.

https://docs.google.com/spreadsheets/d/1uFZSz9CfeC4Tp27BPHRDTATUkpBCBlpcqbJDD17ft1A/edit?usp=sharing

Next post details the spreadsheet further.
Dernière édition par caucheka#3960, le 4 juin 2017 à 21:36:26
Dernier bump le 5 juin 2017 à 11:58:22
Right so I almost forgot to mention how this works.

multiple sheets break the entire list of uniques down into categories, and each page might be broken down further (maces broken into one handed, sceptres, and 2 handeds respectively)

first column displays the name of the unique.

second column if you put a number in it totals at the bottom, made for tallying up how many you own on the page (should of put in a place to list how many there was in total on that page, oh well...)

third column refers to how to obtain it, if it is blank then it's available from any monster of its level or greater. posts a league name here if it is league exclusive, if its upgradable from a blessing (and what type of blessing), if its obtained from corrupting something, from a prophecy (fated or chain), or a vendor recipe in some cases.

fourth column mostly depends on the third, if the item is obtained from a prophecy it lists the prophecy name, if it is corrupted or upgraded (through a blessing) then it displays the base item, or it will display the vendor recipe. otherwise if there's something in the fourth column its just a note.

its also partially color coded, red items are from corruptions, green items are from prophecies, and yellow items are upgraded from blessings.

this spreadsheet also has a page for prizes and relics.
here's a screenshot, might as well.

Awesome. I'd to get that link!
Don't know why they would have removed the link, I've successfully posted links to Google Sheets countless times in the past, and Acquisition and Procurement certainly haven't gotten any reprimands from GGG either. Maybe it has to do with the WannaCrypt scare? Or you chose a shady hosting site?

In any case, thanks for sharing.
Need game info? Check out the Wiki at: https://www.poewiki.net/

Contact support@grindinggear.com for account issues. Check out How to Report Bugs + Post Images at: https://www.pathofexile.com/forum/view-thread/18347
Let me tell you why that link was possibly removed.

.xlsx files contain macros.
.xls files do not.

Opening a .xlsx file can install keyloggers and a variety of other malicious programs which could possibly compromise your account.

not sure why this had to be a .xlsx file, since it isn't doing anything fancy at all...

I am not saying that the program contains malicious scripts, or that this is the reason that GGG removed the links - i am just providing a possible reason.
"
MBata a écrit :


not sure why this had to be a .xlsx file, since it isn't doing anything fancy at all...


Xlsx is the default format to save as in MS Office after 2003 versions. Most people don't bother changing from default.
Need game info? Check out the Wiki at: https://www.poewiki.net/

Contact support@grindinggear.com for account issues. Check out How to Report Bugs + Post Images at: https://www.pathofexile.com/forum/view-thread/18347
"
adghar a écrit :
Don't know why they would have removed the link, I've successfully posted links to Google Sheets countless times in the past, and Acquisition and Procurement certainly haven't gotten any reprimands from GGG either. Maybe it has to do with the WannaCrypt scare? Or you chose a shady hosting site?

In any case, thanks for sharing.


because i linked the dropbox file i uploaded it to. ill see about converting it to a google sheet.
This shouldn't take too long at all give me 20 minutes and i'll have it up.
"
MBata a écrit :
Let me tell you why that link was possibly removed.

.xlsx files contain macros.
.xls files do not.

This is wrong. Both can contain macros. They're just different formats, one being the closed source proprietary format MS has been using and developing since the dawn of MS-Office, the second being an open format anyone can implement.
MS created the OOXML (office open xml) file formats (docx, xlsx, pptx) in order to get the ISO acknowledge it as a standard for storing documents. The other standard is ODF, which is used by OpenOffice, LibreOffice, AbiWord and some other less well known office applications.
Further reading: https://en.wikipedia.org/wiki/Office_Open_XML

So either one, xls or xlsx, is potentially risky and would have been removed.
Bird lover of Wraeclast
Las estrellas te iluminan - Hoy te sirven de guía
Te sientes tan fuerte que piensas - que nadie te puede tocar

Signaler

Compte à signaler :

Type de signalement

Infos supplémentaires