Consolidated Lair Info Spreadsheet

[Sapph]

Heya, all. :)

My eyes hurt from staring, cutting, pasting, but I took the posts on the community site and put them together into a single spreadsheet. It lists the locations and all as well as the time of the first plot to end in that community. I figure this could be used to sort the list according to time. Also, you can put any notes right in the row.

It's simply and no-frills, but I hope it's useful to someone. :)

http://home.comcast.net/~sapph/dragonlairs.xls

[Valornyx]

Hehe - I just finished doing this for myself and then logged on here to find you'd already done it :)

[TelShyia]

Bout Time[6] hehe

[Kaze]

can someone explain the stat for size of lair plz??
5x5x6 what does that mean?
I presume it meansmeasurements of 24 ie mininum size of each section therefore 5x5x6 means 120x120x144 is this correct?

[Deth]

yes.

[Sapph]

Heya.

Reuploaded SS after fidling with the data types.

So, sorting by date will actually work now. :x

Sorry about the inconvenience. :)

http://home.comcast.net/~sapph/dragonlairs.xls

[Kitimandiri]

Nice!

[Pharcellus]

Here's an OpenOffice 1.0 .sxc version for those who hate Excel: [:)]

Lairs.sxc

OpenOffice

[Frost]

Did the same thing with mine, only added in area using sum of D, E, and F. When you look at it that way, 80% are really all the same size, with few being slightly larger.

[Pharcellus]

Column G is Volume, which is the product of D, E, and F. Adding them yields a number with no useful value.

[Frost]

It may not be true Volume, but shows you rather quickly which are larger in size. It may not have value to you, but that doesn't mean it does not have value. I find it easier to work with, somewhat like 5 x 3 x 10, vs 120 x 72 x 240. I don't like to overthink, what can be done simply. To each his own. There are only four sizes in the end. And unless you changed it, G was price.

[Pharcellus]

It may not be true Volume, but shows you rather quickly which are larger in size. It may not have value to you, but that doesn't mean it does not have value. I find it easier to work with, somewhat like 5 x 3 x 10, vs 120 x 72 x 240. I don't like to overthink, what can be done simply. To each his own. There are only four sizes in the end. And unless you changed it, G was price.

You're apparently talking about the OP's spreadsheet. I am talking about the one I posted.

[Frost]

Yes, I was. No need to install yet onother piece of software. I don't use excel, but I can convert it just fine.