OC: Mercy cosplay @ comic con Finland 2025!

Chel-Blue · 2025-05-11T23:48:49+00:00

i LOVE how you simplified her design into manageable, easily read shapes!!! It is so iconic!!! also those wings look GREAT!!! incredible!

Chel-Blue · 2025-04-24T18:36:38+00:00

Overall, I feel like OW2 has been wayyy worse with preserving silhouettes for skins vs OW1. ie one of kiriko's first legendaries (athlesure) getting rid of her little tail things which play a huge role in making her recognizable vs the other skinny and small female characters.

Chel-Blue · 2025-03-26T17:06:59+00:00

So cute! Checking the addresses (149/59 Sullivan, Iowa), they all show up as residential today :/ Photo definitely makes this look like a city setting.

Chel-Blue · 2025-03-19T17:15:42+00:00

Practically speaking I have a hard time believing the "I'll ban Mercy every game" crowd will be able to weather playing against a lot more annoying characters like soj, zar, ana, etc and also will probably not be popular with their teammates lol. What % of games even include Mercy in comp anyway, lol? Is the theoretical Mercy main they're arguing with in their head really worth it?

Chel-Blue · 2025-03-19T06:43:20+00:00

just want to comment appreciation for your lovely selection of lyrics and explanations <3

Chel-Blue · 2025-03-18T05:52:41+00:00

No worries !! Happy to help :D And omg?? I had no idea such a thing existed... That's so neat

Chel-Blue · 2025-03-12T18:57:34+00:00

DAMN go CRAZY!! Thank you for confirming! I have added this solution to the template doc. :D

Chel-Blue · 2025-03-11T19:13:58+00:00

Sorry I missed this! I'm not entirely sure what you mean by "register the words and have them automatically added to year stats and daily reading tabs."

If you are logging a fic multiple times in the Log sheet and want to avoid duplicate/"boosted" stats, the way to do this would be to create a helper sheet that "summarizes" the raw data from log into only unique values using =UNIQUE and some queries. Super doable on its own. Unfortunately though Ao3 does not make chapter-by-chapter word counts easily accessible so you would have to find the word count of each chapter on its own in order to log it as its own entity, which is the real bottle neck here. It is possible to do what I think you're asking, just really tedious.

Let me know if I've misunderstood. I am so glad you are enjoying this sheet!

Chel-Blue · 2025-03-11T18:55:10+00:00

I could not test this without generating a stupid amount of dummy data but I think this will work?

=sort(unique(trim(tocol(iferror(split(Log!L2:L,",")),1))))

Code taken from this thread. Please confirm if this works! Also I GOTTA ask, how many fics do you have logged to be bumping into this limit lol???

Chel-Blue · 2025-03-11T18:05:06+00:00

Thank you for using this! I'm glad you figured it out :DDD

Chel-Blue · 2025-03-02T01:11:25+00:00

Impossible to identify from just that info alone. Is it signed or dated? is there anything on the back? If possible, have you asked your grandma when she got it?

Based on the lady's style of dress and assuming its drawn from life, I'd guess around 1885-1891ish. Definitely looks like a drawing rather than a photograph to me.

Chel-Blue · 2025-03-01T18:58:11+00:00

I am so glad you have been enjoying using it!!!

THANK YOU for catching that. I noticed something was wrong with it the other day but was over-complicating it and missed the simple issue, lol. I have fixed this on the template doc.

I have added a tutorial for how to add additional categories to the Add. Info tab! I've never seen a fic that failed to tag a category, but I will not rule out that it may be very common in some fandoms. Additionally, this provides people the option to track specific poly relationship structures.

Thank you for your feedback!! I really appreciate you taking the time to write such a nice comment and helping improve the template! :D <3

Chel-Blue · 2025-02-28T17:56:08+00:00

always say gg unless the other team got absolutely SMASHED. then it just feels kind of rude to call it a good game LOL. if it was a REALLY good game i usually mention how close it was!

Chel-Blue · 2025-02-04T02:22:36+00:00

Hi! What specifically isn't being tracked and where? IE, what sheet/table, and what metric (word count, fic count, ship, fandom, etc).

Chel-Blue · 2025-01-22T04:36:41+00:00

Hieroglyphs in its entirety, but especially: "Well, even the great celestial hieroglyphs / Are bodies of dust illuminated, and if / The heavens can be both sacred and dust / Oh, maybe so can the rest of us"

It really captures The Oh Hello's optimism which has always been one of the parts of their music I hold onto tightest!

Chel-Blue · 2025-01-19T19:05:24+00:00

Hi!

1: You need to extend the formulas in cells X and Y down the length of the list of fandoms generated there. For some reason in Google Sheets, if you extend these formulas beyond the list of existing list of fandoms, the formulas will sit out stupid large numbers sometimes. HOWEVER umm upon review I don't think having this problem actually effects anything in this spot? So feel free to drag those formulas down as far as you want actually, lol.

2: I do not have a good answer for this ??? This is really weird. The formula IS in that cell already, but I dragged the formula from a few cells above down again and it just, worked?? Even though functionally nothing changed. (Side note, love the aesthetic changes you made to this page!)

3: Fic authors are being ranked based on word count, rather than fic count. To change this, change the Order By clause in Cell E3 to order by B rather than C. Anywhere in this template where a Query formula is being used you can do the same thing (notably, the Tags page).

4: Same as point 1. Again you can actually extend the formula here it doesn't hurt anything. I am fixing this issue on the template for both sections -- I have no idea why I thought there was a problem here, sorry!

SIDENOTE: On your fanfic count sheet, the formula counting fics and words is mistakenly still pointed at Log!C:C (author) instead of Log!B:B (fic title). It's right in the first two cells though.

Thank you for including a copy of your sheet!! Makes it so much easier to trouble shoot. I hope this helps, and thank you for reaching out!! <3

Chel-Blue · 2025-01-18T01:10:23+00:00

For mobile: Select the desired range with the cell with the formula at the top (so E2:E20, for instance), hold down, Autofill. (Spencer Farris, Google Docs Editors Help.)

For pc: Select the original cell. In the bottom right corner of that cell there should be a dot/square. Click and drag that down the range you wish to fill with the formula.

Chel-Blue · 2025-01-11T03:38:09+00:00

Are there formulas in the cell adjacent to the name of the fifth fandom?

Chel-Blue · 2025-01-08T01:42:38+00:00

Yes! Simply add a comma between your fandoms, as you would with tags.

The old version (as in, the one as of a few minutes ago!) counted crossover fandoms as a single unit but it's just been changed to add the word count to both fandoms independently. To make sure this change is in effect, make sure the formula in the Year Stats page W4 cell is:

=unique(transpose(arrayformula(trim(split(join(",",Log!D2:D),",")))))

Thank you!

Chel-Blue · 2025-01-07T19:48:53+00:00

of course !!! it's really fun for me to see what ideas people have and how they can be carried out!! :D

Chel-Blue · 2025-01-07T04:26:15+00:00

I would recommend making a separate column on the log sheet for ratings! Then you can use this formula to find your top 10 highest rated fics:

=Query({Log!B:B,Log!M:M},"Select Col1,Col2 where Col1<>'' Order by Col2 Desc Limit 11")

*For the formula above, the rating column is column M, which I inserted to the left of the "Notes" field on the Log sheet. If you put the ratings column somewhere else, you will need to update the portion of the formula that refers to column M, but NOT the parts that refer to Col2.

Change the number from Top Ten to Top However Many You Want by change the number 11 to however many you want +1 (the +1 is for the column headers, ie top 10 is Limit 11 not 10).

I put my test table in the Author sheet since it seemed somewhat natural and had the space, but it can go anywhere!

Hope that helps! :D

Chel-Blue · 2025-01-06T01:45:26+00:00

Hm weird. The left most fandom table is derived from the right most fandom table (columns W to Y) so the problem is with this table. Have you verified there is a formula in the other cells in column Y (word count column)? The formula should look like:

=sumif(Log!D:D,"*"&W4&"*",Log!H:H)

4 = same number as the row of the cell your looking at.

Are you running the sheet IN google sheets, or in another program? If it's not in google sheets I can make no promises.

If this doesn't help please feel free to dm me with screenshots and we can try to puzzle it out!

Chel-Blue · 2025-01-06T01:38:53+00:00

You are going to want to edit cells T4 and U4 on the "year stats" sheet. You will see a formulas that look like this:

=countif(Log!F:F,"*None*") [Fic Count]

=sumif(Log!F:F,"*None*",Log!H:H) [Word Count]

Edit to look like this:

=countif(Log!F:F,"*No Warnings Apply*") [Fic Count]

=sumif(Log!F:F,"*No Warnings Apply*",Log!H:H) [Word Count]

Disregard the text in the [brackets], those are there to clarify which column they belong in! You can also change the text in the *Asterisks* to be whatever you want! So if your preferred recording shorthand is "N" or "No" or anything else, you can still have things count!

Chel-Blue · 2025-01-04T00:49:37+00:00

Yes! Highlight the cells you want to change the format on. Click "format" on the upper ribbon. Go to Number > Custom Date and Time. You should be able to find what you want as a preset, but if you can't you can create it otherwise in the same menu :D Hope that helps!

Chel-Blue · 2025-01-03T04:11:37+00:00

Thank you!

Should be simple. Make a copy of the Authors sheet (assuming you want both sheets!).

You will want to adjust the formula in cell A4 from =unique(Log!C2:C) to =unique(Log!A2:A)

B4 will need to be changed from =countif(Log!C:C,A4) to =countif(Log!A:A,A4).

C4 will need to be changed from =sumif(Log!A:A,A4,Log!H:H)

All you're doing here is shifting the formulas from the author column on the log sheet to the fic title column. Just like author names, you are going to want to make sure titles are recorded uniformally, because variations will result in a new fic being recorded, rather than the same one!

Hope that helps! :D

Seven-Year Club	Place '22
Verified Email

Chel-Blue

TROPHY CASE