Spreadsheet geekery

[enigel]

First I must thank bookshop, whose gigantic spreadsheet of doom inspired me to make my own, and http://techonthenet.com for their nifty Excel function reference. *g*

I have compiled a humongous spreadsheet with all nominated fandoms, number of requests and number of offers in separate columns.

Get

Comments

[pene]

brilliant!

just noting that Starstruck (1982) is incorrect in there. You have it listed as having 1982 offers! but actually it has 0 requests and 0 offers

[enigel]

Ahaha! It figured that there had to be one fandom that would defeat my cunning tests! :D (That would be the day when we see a fandom with 1982 offers... O_O)

Thank you! I'll post an updated version, since someone had sneaked under the wire *again* and the counts were a wee bit off...

[pene]

heh.

of course the first thing I did was sort by number of offers - just for interest. And as I'd not offered Starstruck I knew it was out ;)

[blienky27]

Heh. That person who slipped in just under the wire and made you cry might just be me. Heh. Sorry about that. I turned my form in exactly ten minuted before signups closed.

[enigel]

Hee! I'm actually glad you made it and are not somewhere sad about missing Yuletide. ;)

[muccamukk]

-peers-

I'm not much for computers, but what's it do?

-pokes-

I think that it doesn't work in OpenOffice?

[enigel]

Ah, no idea about that, as I'm enjoying the last few parts of the Excel 2007 trial I have with my laptop. Is OpenOffice supposed to open Excel files? I could try to save it in a compatibility mode...

[niki_chidon]

OpenOffice Calc recognises Excel files. I had no problems viewing it.

[muccamukk]

I can view it, only the formulas in rows d through o aren't sensible.

[franzeska]

The way you deal with number fandom names is to get two lists: one with the nominated fandoms and one with the fandom names plus requests and offers. Sort both alphabetically. Then you can use the length function to get just the #,#) bit. If you copy that into a text program and then copy it back using the text import wizard, you can get just the numbers, separated into columns. (You can assign commas and the close parenthesis to be cell delimiters.)

The way the length function works is this:

=right(B1,len(A1)+2)

[enigel]

I... entirely forgot about the nominated fandoms page. (It's not linked from the home page! :D)

Thank you. :D (I suspected I was doing it in a more complex fashion than needed... On the plus side, I've learned more Excel than in the whole year before Yule!)

[franzeska]

Hee! I've had to learn it for work and found the left/right + len function trick online somewhere.

[t_lyrical]

Ohohoh, the Temeraire fandom is making me so happy now. Can't wait to read the fics. *beams*