For HHQ,
http://puu.sh/7mE1h.txt
Go to Google Docs and create a new spreadsheed. Down in the bottom left corner there's a small + button, press that, and you'll now have two sheets. Sheet1 and Sheet2
Go to sheet 2 and paste the item list from the puush into it. If you see anything obvious I missed, toss that in
(it doesn't have to be, but to keep it simple just paste it in column A)
Then in Column B, put "Starved Ancient Effigy" and "Clue Scroll" (if you care about clues.
Optionally in Column C you can put Gold, Green, Crimson and Blue charms and Key tokens.
Now go back to sheet 1. You have a couple options here... You can either use the row numbering to count as the kill number (so cell A1 would be your first drop, A2 would be second, etc) or you can create a table that has headings to label each column.. I like to just let the row numbers be a kill number/some form of counter
Click in the cell you want your first drop to be entered in. Go up to the "data" tab and select "validation". On the "Criteria" line, click the small box that's in the bottom right of this puush..
http://puu.sh/7mExS.png
Go to sheet 2, highlight the list of drops, hit OK, hit Save. Repeat for the first cell of any other columns (effigy column, charm column).. And then drag the "formula" down the columns by clicking the small box in the bottom corner of the cell and dragging down
http://puu.sh/7mEP1.png
http://puu.sh/7mE1h.txt
Go to Google Docs and create a new spreadsheed. Down in the bottom left corner there's a small + button, press that, and you'll now have two sheets. Sheet1 and Sheet2
Go to sheet 2 and paste the item list from the puush into it. If you see anything obvious I missed, toss that in
(it doesn't have to be, but to keep it simple just paste it in column A)
Then in Column B, put "Starved Ancient Effigy" and "Clue Scroll" (if you care about clues.
Optionally in Column C you can put Gold, Green, Crimson and Blue charms and Key tokens.
Now go back to sheet 1. You have a couple options here... You can either use the row numbering to count as the kill number (so cell A1 would be your first drop, A2 would be second, etc) or you can create a table that has headings to label each column.. I like to just let the row numbers be a kill number/some form of counter
Click in the cell you want your first drop to be entered in. Go up to the "data" tab and select "validation". On the "Criteria" line, click the small box that's in the bottom right of this puush..
http://puu.sh/7mExS.png
Go to sheet 2, highlight the list of drops, hit OK, hit Save. Repeat for the first cell of any other columns (effigy column, charm column).. And then drag the "formula" down the columns by clicking the small box in the bottom corner of the cell and dragging down
http://puu.sh/7mEP1.png
Fun fact: Zaros uses Linkify
Lady of Zaros
Proud Linkify user
- Become one of the Family!
07-Mar-2014 21:42:37
