telophase: (Default)
telophase ([personal profile] telophase) wrote2011-11-22 02:57 pm

(no subject)

I just wonder why the people who kindly collate all the links to Yuletide letters into a spreadsheet don't put them in with each request in a separate row. Right now, it's excellent if you're sorting by requester's name, and terrible if you want to sort by fandom. You have to do a ctrl-f and search for the fandom's name, which takes much longer and assumes you know what you're looking for and spelling it correctly.

My first guess is that it's easier, except that it's really not significantly easier - right now, in order to make it, each individual element has to be copied and pasted and to make it sortable by fandom, you'd just c&p onto different lines, then highlight the URL and requester's name, copy, and paste two more times.

(ETA: Or do what I just did, which is download the table, c&p it 4 times (once for each of the request columns) then delete the extraneous column in each section.)

(ETA2: Turns out there's a little button at the bottom, in faded-out text, that says "Letters by Fandom A-Z" which will sort them in fandom order for you.)

(Not participating this year; just poking about looking at them in case anything sounds interesting.)
lnhammer: the Chinese character for poetry, red on white background (Default)

[personal profile] lnhammer 2011-11-22 09:36 pm (UTC)(link)
Actually, you can view the spreadsheet by fandom -- at the bottom, click "Letters by Fandom A-Z."

---L.
mme_hardy: White rose (Default)

[personal profile] mme_hardy 2011-11-23 04:47 pm (UTC)(link)
That faded little letter is actually a separate tab; blame Google's GUI redesign.
mme_hardy: White rose (Default)

[personal profile] mme_hardy 2011-11-23 05:07 pm (UTC)(link)
I am very annoyed at how badly the new designs interact with larger fonts. In fact, the spreadsheet flat-out orders me to return to the default font size. No.

[identity profile] mscongeniality.livejournal.com 2011-11-22 09:16 pm (UTC)(link)
Yeah, I thought about that last year. I should pull down the list also. I didn't sign up due to a serious lack of free time, but I'm haunting the Pinch Hit list all the same....

[identity profile] telophase.livejournal.com 2011-11-22 09:20 pm (UTC)(link)
Here's the version I just did (https://docs.google.com/spreadsheet/ccc?key=0Amfzj2xDkJtmdDlUczN0a1hkVy0yOHVtUjQtNWt5amc) that's sortable by fandom.

I doubt I'll have time to do a pinch hit or treat, but I do love poking through the letters. :)

[identity profile] mscongeniality.livejournal.com 2011-11-22 09:34 pm (UTC)(link)
Oh, I won't have time. That doesn't mean I'm not going to be tempted and probably give in.