?

Log in

No account? Create an account
 
 
18 December 2005 @ 06:53 pm
sunday evening noodling and an sga rec  
The ratio of stories I think about to stories I write is probably about 20:1. Today I imagined Elizabeth/Rodney/Teyla. And even pictured a little moment of Teyla being warm and sweet as she convinced a skittish Elizabeth to carry on with the relationship, and then there was kissing--and Rodney wasn't even in the room! Uncharted territory for my fantasies.

Despite the limited time I have that doesn't stretch to cover all the things I want to do, I spent two hours today starting a spreadsheet of SGA recs. Because how can I properly rec stories if I don't have a spreadsheet? No, seriously. Shut up. There are columns for title, author, date, length and format, rating, pairing, genre, timeline, and keyword summaries. I taught myself how to make drop-down list menus.

Today I am a fan.

I have a little crimp in my ass from sitting at my desk for so long today. I know I got some other stuff done because there is clean laundry on my bed and I own no house elves, but none of that other stuff was writing. Now I'm trying to decide if the butt-crimp is tolerable, or if I should get the hell up and...yeah, then again, a lack of Sunday evening alternatives may render that question moot.

When I asked for Rodney/Elizabeth recs, I got some good ones (more are welcome); in particular, a rec from lydiabell for Once Upon a Time in Moscow by ljmckay, which is incredibly good. To recycle my feedback as a rec:
This is extraordinary; the voices are pitch-perfect, and I love the atmosphere that this creates for a possible backstory between them, with the combination of the exotic--Moscow in winter, the party at the foreign ministry--and the mundane--Rodney working in his lab, shopping for American food--where in fact the mundane isn't really mundane, because he's working on the Stargate project, and the fact of that is just so wonderfully *there*, taken for granted, with no big deal made of it, even though Rodney can't say anything about it to Weir. The way *he* takes it for granted within the story itself is equally cool; it's his work, it's what he does, but his bond with Weir is established over shopping for Snickers bars, and how she laughs at his jokes, not over any smug enigmatic references he might make to his very important work.
I love her Rodney here. This story made me incredibly happy--and I didn't even mention how much I loved her use of Russian. I'm always so envious of people who can use other languages in stories. I'm monolingual and despite some college-era stabs at Italian I don't think that's ever going to change.

Unrelatedly. I've been having impulses lately to post voluminous everyday minutiae--like, page upon wittering page of unremarkable thoughts, lists of things I've read and watched, fannish social chatter, trivia that has stuck to me like lint, et cetera. Nothing's stopping me. I'm not inhibited from talking about myself. This LJ is a three-year testament to that. I just don't think the things rattling around in my head right now are particularly interesting. Instead of this, I give in to the overwhelming urge to provide "real" content, cake instead of birdseed--meaning that I've been feverishly pushing myself to scribble storyish bits.

Hmm, yeah.

I really need to add the words "rec" and "wittering" to my Microsoft Word spellcheck dictionary.
 
 
 
Pouncer: Atlantis risingthepouncer on December 19th, 2005 02:58 am (UTC)
HOW DO YOU MAKE DROP DOWN LIST MENUS?!?!?!? I actually should know this for work, but I've been too embarrassed to ask. *sigh*

Anna S.: atlantis-blue-skyeliade on December 19th, 2005 03:06 am (UTC)
It's surprisingly easy--as so many things are once you master the trick of actually *finding them* in their stupid help documentation.

Anyway, just do this:

1. Go to one of the other worksheet tabs that you can consider more or less as scratch paper.

2. In a column, type your terms, for example: G, PG, R, NC-17.

3. Pull your cursor to select only those cells.

4. When they're selected, go up to the formula bar, which shoudl be the default bar that appears under the toolbar. In the space that probably says "A1" replace that with a name of your choosing, like, Ratings.

5. Go back to the main worksheet. Click "Data > Validation" and allow the type "List."

6. In the "Source" field type =Ratings (or whatever it is). Important: Do not leave out the equal sign, which is necessary when you are using a list that you've put into a different tab/sheet.

Yay!
Anna S.: foraminiferaeliade on December 19th, 2005 03:09 am (UTC)
Oh, wait--sorry! I forgot a step! Ignore that and use this one:

so many things are once you master the trick of actually *finding them* in their stupid help documentation.

Anyway, just do this:

1. Go to one of the other worksheet tabs that you can consider more or less as scratch paper.

2. In a column, type your terms, for example: G, PG, R, NC-17.

3. Pull your cursor to select only those cells.

4. When they're selected, go up to the formula bar, which shoudl be the default bar that appears under the toolbar. In the space that probably says "A1" replace that with a name of your choosing, like, Ratings.

5. Go back to the main worksheet. You will probably want to select an entire column--don't just select the column header (if you've made one), because you need to select all cells in the column for the option to appear in those cells.

6. Now click "Data > Validation" and allow the type "List."

7. In the "Source" field type =Ratings (or whatever it is). Important: Do not leave out the equal sign, which is necessary when you are using a list that you've put into a different tab/sheet.

The menu drop-down should appear for all cells in the column. You can put a different menu in each column.

:D
Anna S.: brainslugeliade on December 19th, 2005 03:11 am (UTC)
(Sigh. Please to forgive my terrible lack of copy-paste and bolding skillz.)
Pouncer: Pleated skirt and heelsthepouncer on December 19th, 2005 05:56 pm (UTC)
Not a problem at all - thank you for braving the wilds of Microsoft help menus and sharing your knowledge with us cowardly brethren *g*
raqsraqs on December 19th, 2005 05:52 am (UTC)
i seriously think that all those abandoned story ideas must contribute to the reason why the ones you DO write are so good. i still have trouble throwing away any story idea because they're so hard for me to come up with - and most of them are NOT GOOD.

i am proud of your drop down menus even though i had nothing to do with them. i am a computer geek.
Lobelia the adverbial: oxfordlobelia321 on December 19th, 2005 10:04 pm (UTC)
The rec sounds gorgeous, thank you!

And spreadsheet recs??? Well, I do FilemakerPro databases. I have rubrics for: author, title, fandom, pairing / characters, keyword. And then I have coded ways of entering info, e.g. if a story is fantastic, I enter a *, and in the keywords I have AU and suchlike, and I could have dropdown menus if I wanted to.

ARGH! When I first read your thing about the spreadsheet, I thought, 'this person is clearly insane and must be removed from my Flist forthwith', until I remembered that I have done the same. For HP and for SGA and for lotrips.

I feel so anal! But then, being in the slashworld, that should perhaps not surprise...
Anna S.: dino-rodneyeliade on December 19th, 2005 10:43 pm (UTC)
ARGH! When I first read your thing about the spreadsheet, I thought, 'this person is clearly insane and must be removed from my Flist forthwith'

Nooo! I'm not...totally insane. And, um, I have to hone my Excel skills anyway, without spending too much workday time, and this makes for a good reason.

...or, yes, insane. Except for how you did it too! And you're probably sane enough, right? *stares at you with sudden suspicion*