Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Maklak]

I'd like a printable version of this: http://df.magmawiki.com/index.php/Gem sorted by name and printable on a single page, for quick reference, which gems to use (value 2 or 3), and what to keep till my jeweler is legendary +5 (everything else). I could do this myself, but perhabs somebody has this already. I tried to search the forum, but found nothing.

The wiki version fits on 6 pages, and that's too much. I couldn't paste it into a spreadsheet, and table pasted into a text file looks like a mess. If no one posts a link to an already existing version, I'll just extract it with a perl script, convert to LaTeX (?) and post it, but I'm lazy. Heck, I'll probably even post a link on the wiki. I only need name of gem and its value for all gems on a single A4 page, sorted by name.

EDIT: Problem solved: https://spreadsheets.google.com/spreadsheet/ccc?key=0ApoOG6GC8_0RdHR5QkNDZlYwa1RYeUpCSzJSNUZIRkE&hl=en_US

[Naina]

Here you go:
https://spreadsheets.google.com/spreadsheet/ccc?key=0Auy0R4dx5JF6dEdwQ3B5WkdCeUp0SjZYSl9vc3lteFE&hl=en_US

On only a tangentially related note, you can paste tables like that one to spreadsheets if you highlight the table, ctrl-c to copy it, open your spreadsheet program (I use open office, but excel is identical in this respect) and choose the 'paste special' option. Select 'Unformatted text' and it'll retain all the formatting the original table did.

[Bognor]

Nice work Naina!

I hope you don't mind, but I've linked the spreadsheet from the wiki.

[Maklak]

I didn't have perl on this machine and sed proved too cumbersome for the task. This almost worked, but not quite.

sed 's/^[A-Za-z\-]*[^A-Za-z]*\([A-Za-z \'\'']*\)[^A-Za-z0-9]*\([0-9]*\).*/\1   \2/' Gems_in.txt > Gems_out.txt

Awk worked, tough:

awk -F"\t" '{ print $2"\t"$3 }' Gems_in.txt | sort > Gems_out.txt

Cygwin or MinGW + MinSys is a great help under Windows.

My version of google spreadsheet is here:

https://spreadsheets.google.com/spreadsheet/ccc?key=0ApoOG6GC8_0RdHR5QkNDZlYwa1RYeUpCSzJSNUZIRkE&hl=en_US

@ Naina:
Thanks. That was close, but I really wanted it to be sorted by gem name, so I used "order by this column" button on the wiki before copying. Using google docs is a good idea, and faster (for this task) than fiddling with LaTeX. I also played a bit with column and font sizes. 

I tried to play with OO Calc "paste special" using tab as separator, but failed for some reason.