goose_ooc | activity tracker 3.0!

do you play characters?
at the end of every month, do you scramble to find enough proof that yes, you play them?
ooooor do you just like spreadsheets and charts and shit?

if you answered "PROBABLY" to any of the above questions, the activity tracker might be right for you! and this is me telling you all about the newest version! i name them now. i named v3.0 "blunderbuss."

tl;dr: the activity tracker is a google drive spreadsheet! you input threads, comments, etc. so you can find them easily when AC rolls around! AND SO MUCH MORE!

changes to version 3.0 include:

automatically generated HTML for activity checks!
cool charts that reveal to you your favourite garbage!
an easier way to input your characters in the first place!
a lot more instructions/a table of contents/etc.!
AND OTHER THINGS!!! (there's a changelog in it, too. they're all there.)

here's the link to the new version! if you want to see it filled out, here's a copy with my y1 activity! (it's probably missing some stuff from the end of the year atm. guess how much i care? nada.)

i think that's all for now. :|a you can ask questions in the comments if something isn't unclear, or to tell me i did something wrong. or whatever.

OH AND i started keeping track of AT-related posts in my CDJ. idk why you would need them but they're there; there's also a link to it on the spreadsheet's "Information" sheet.

- kas

Flat | Top-Level Comments Only

also a convenient place to show you what the HTML generator makes, the following is copied and pasted right from the spreadsheet!

Kurt: Birthday river walk with Ursula + HORSES. CAN. TALK.
Quinn: Shinny game #1! + A journal-delivered, mistletoe-related plea
Casey: SALUTE DOM'S SHORTS! + Trapped in the closet
Kazim: Kazim gets traded to the opposition + Baby's first anon post

If I change the colors on the tabs at the bottom so I can remember which is which will that fuck things up

NOPE & actually that's a really smart idea, thx i'm totally stealing it.

they're only colour-coded for like... "PUT THINGS HERE" and "LOOK AT THINGS HERE" and "PLEASE GO AWAY THIS SHEET'S A TOTAL MESS"

Re: QUESTIONS/MISTAKES I MADE

novelling - 2017-08-15 22:21 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:22 (UTC) - Expand

novelling - 2017-08-15 22:23 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:26 (UTC) - Expand

novelling - 2017-08-15 22:35 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:41 (UTC) - Expand

novelling - 2017-08-15 22:44 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:47 (UTC) - Expand

i found a tiny almost me-exclusive issue

I was trying to figure out why the note about names matching the cast list was necessary and just happened to dump Ursula into the sheet and the generated IC tag doesn't work because of the space in her last name. :x i think something like Substitute(Information!E37," ","+") would work to correct it?

OOH GOOD POINT!! what does it generate as a tag for ursula for you? it gives me http://gooseberryhigh.dreamwidth.org/tag/Ursula+de%20Luca which still works when i paste it into chrome.

magitechnically - 2017-08-15 23:13 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:16 (UTC) - Expand

magitechnically - 2017-08-15 23:19 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:30 (UTC) - Expand

a couple of things :o

— typo on the first page, "istructions"
— title of doc says "Goosebery"
— "Further details about the activity requirements can be found on the mod journal" still links to IJ

smh

thaaank you for noticing that. (i'm especially ashamed of "goosebery.") all have been fixed! 💜

i figured titled threads would be overkill but GUESS WHAT, SO IS EVERYTHING ELSE I DO!

I can't believe there are charts now

I love you

i can't believe there weren't charts before

i love me too and i also love you. i especially love you for reposting under a header :*

Re: OTHER STUFF

browbeats - 2017-08-15 22:16 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:17 (UTC) - Expand

magitechnically - 2017-08-15 22:21 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:24 (UTC) - Expand

oh boy oh booooy

Yer a wizard

18 years later and still no hogwarts letter.........

novelling - 2017-08-15 22:29 (UTC) - Expand

sunsoutgunsout - 2017-08-15 22:40 (UTC) - Expand

novelling - 2017-08-15 22:42 (UTC) - Expand

You are very very good I can't wait for this beautiful spreadsheet to embarrass me over which characters I give the most attention to.

i knew quinn was my obvious favourite child but seeing the chart kind of hurt? i need to be more fair this year.

evercreep - 2017-08-15 22:23 (UTC) - Expand

kas you are so spectacular like....... honestly

i've learned so much about spreadsheets this year just because i was trying to emulate 1% of your amazingness

ty! :3

if you ever need something explained or a hand figuring out how somebody did a thing you can always hmu! I LOVE SPREADSHEETS

nothalfplaid - 2017-08-16 01:43 (UTC) - Expand

DID I EVER TELL YOU YOU'RE MY HEROOOO

i will always listen 😘

i'm totally gonna use this this year. it's gonna happen

I believe you can fly
I believe you can touch the sky

you should give alex access so she can make threatening activity fairy comments when it's AC time

theniceboy - 2017-08-15 23:11 (UTC) - Expand

theniceboy - 2017-08-15 23:15 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:17 (UTC) - Expand

theniceboy - 2017-08-15 23:22 (UTC) - Expand

browbeats - 2017-08-15 23:24 (UTC) - Expand

theniceboy - 2017-08-15 23:26 (UTC) - Expand

browbeats - 2017-08-15 23:29 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:32 (UTC) - Expand

theniceboy - 2017-08-15 23:39 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:40 (UTC) - Expand

theniceboy - 2017-08-15 23:41 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:43 (UTC) - Expand

novelling - 2017-08-15 23:41 (UTC) - Expand

sunsoutgunsout - 2017-08-15 23:42 (UTC) - Expand

im in luv with ur spreadsheets

Oh my god.

(´・ω・`)

(no subject)

badassbeaterbabe - 2017-08-16 14:06 (UTC) - Expand

sunsoutgunsout - 2017-08-16 14:08 (UTC) - Expand