amigarobot

[amigarobot]

learned a new fuckening excel formula

after doing this kind of work for 10 years professionally

it's something incredibly obvious but I was doing it with writing out formulas because I'm too smart for my own good

background:

"upper()" and "lower()" are used on text strings to change the case of the letters. so for example:

upper("apple") = APPLE

lower("Fuck You") = fuck you

and so...

sometimes I would want to make a name like

diane mononym

or

DIANE MONONYM

into

Diane Mononym

and so I would use left() and right() and mid() to pull that shit out carefully and re-assemble it together. I was going to keep it brief because it's a bunch of bullshit but I decided to sit down and write out the formula because the people ought to see bullshit if they really wanted.

below the jump.

before we dive in, let me explain some of the formulas here for your reference.

some stuff with strings:

upper([string]) make the string upper case lower([string]) make the string lowercase concatenate([string) put the contents together as a single string left([string],[number]) take X-many characters off the left right([string],[number]) take Y-many characters off the right trim([string]) remove extra spaces from the string

and some stuff with math:

len([string]) measures how many characters there are in a string for example: "diane" is five (5) letters long, "mononym" is seven (7) characters long search([desired character],[string]): this is used to find a specific character in a string. so like here we'll look for " " the space character. which will denote how far in number of characters into the string that is so for example in "diane mononym" the space " " is six (6) characters in, where the name would be split in half

and so the strategy is to split the name into two words, then split the words into two parts, the first letter and the rest of the characters

so here we go.

the written-out formulas:

A1 ="diane mononym"

B2 =CONCATENATE(

UPPER(LEFT(TRIM(LEFT($A$1,SEARCH(" ",A1))))),

LOWER(RIGHT(TRIM(LEFT($A$1,SEARCH(" ",A1))),LEN(TRIM(LEFT($A$1,SEARCH(" ",A1))))-1)),

" ",

UPPER(LEFT(TRIM(RIGHT($A$1,LEN($A$1)-SEARCH(" ",$A$1))),1)),LOWER(RIGHT(TRIM(RIGHT($A$1,SEARCH(" ",A1))),

LEN(TRIM(LEFT($A$1,LEN($A$1)-SEARCH(" ",A1))))-1))

)

blink yet?

let me annotate this to explain what's happening here.

here's the formulas, annotated:

A1 ="diane mononym" // I wrote this out

B2 =CONCATENATE( // combine this as one string

UPPER(LEFT(TRIM(LEFT($A$1,SEARCH(" ",A1))))),

// use the space character to find out where the space is and grab the left of the two words, take the first character from the left and make it uppercase

LOWER(RIGHT(TRIM(LEFT($A$1,SEARCH(" ",A1))),LEN(TRIM(LEFT($A$1,SEARCH(" ",A1))))-1)),

" ",

// use the space character to find out where the space is and grab the left of the two words, take the remaining characters from the right and make them lowercase

UPPER(LEFT(TRIM(RIGHT($A$1,LEN($A$1)-SEARCH(" ",$A$1))),1)),LOWER(RIGHT(TRIM(RIGHT($A$1,SEARCH(" ",A1))),

// use the space character to find out where the space is and grab the right of the two words, take the first character from the left and make it uppercase

LEN(TRIM(LEFT($A$1,LEN($A$1)-SEARCH(" ",A1))))-1))

// use the space character to find out where the space is and grab the rightof the two words, take the remaining characters from the right and make them lowercase

)

the laborious result:

A1 = diane mononym

B2 = Diane Mononym

This works pretty nicely and with the individual components broken out, you can even do funky stuff like reformat the name to something like

Mononym, Diane

but astute readers will note a specific limitation of this method. what if your person has three names (a middle, naturally),

you are completely shit out of luck.

may as well start this at 9 AM because this is going to take longer than it has to. I am not going today though because getting here writing this has already taken up the better part of an hour.

and I went searching for this because reformatting a name like "KATHERINE HENNESY TEMPO" into "Katherine Hennessy Tempo" would have devoured my soul

but the trick is to use if we're hypothetically tackling this is to be able to count Z-many additional spaces to break up but it's not dynamic. you need to keep adding formulas for each additional segment. hell on earth so let's not

and that's where I arrived at too. hm maybe I'm not too ambitious for my own good.

and so I found it immediately on a brief and mundane stack overflow page. behold. the new formula I did not know existed before today

PROPER()

which does that automatically.

just makes the first letters of a word............ Proper.

Dynamic Mixed Case.

GUESS I better go Fuck Myself

GUESS I BETTER GO FUCK MYSELF

guess i better go fuck myself

Guess I Better Go Fuck Myself

thank you for reading

edit: 20 min later

[amigarobot]

let me once again issue the call to download umineko project. let sayaka ohara's witch cackling into your life.

[amigarobot]

fragmented, yet flawless

[amigarobot]

i’m obsessed with how these ponies look theyre sooooo cute

[amigarobot]

I have yet to play Needy Girl Overdose (NEEDY STREAMER OVERLOAD) so I don’t have much of interest to say about it but, I wanted to share this because it’s so cool to see a (comparatively) popular & modern game has been utilizing Ukagaka to make radio dramas! and even with English subtitles included. before the game came out I remember reading a Japanese publication saying they drew influence from Ukagaka (I believe Nini Radio by Triumphal Records specifically? also this makes it pretty obvious), as well as old-school denpa visual novels so I suppose it’s an expected tie-in but I’m still surprised they pulled it off because I haven’t seen Ukagaka used this way in a long time. the Angel Radio segments are programmed by Coyakoya (they aren't in the credits on youtube but I think it's safe to assume they probably were involved based on this process video?) and illustrated by Para Dot.

[amigarobot]

“Winter Bonsai” 1982 by  Eyvind Earle (1916-2000)

[amigarobot]

katherine hennessy tempo IV and grim. kestrel and scholar. comm by @pluviomancy of our characters for our songs for the dusk game

[amigarobot]

ghost/shell conceptual diagram (2001)

[amigarobot]

Top 10 dragon living spaces

[amigarobot]

1970 pink hair doll from Hong Kong

[amigarobot]

(flex)(emo)

[amigarobot]

stressed tf out and not much time to draw this week.

have a baby ladybird and baby wilma 👶🏾

[amigarobot]

my fields of mistria cutie coming along

her name is sage and she’s an archeologist

she has a crush on ryis the carpenter and fellow farmer hayden (because i cannot choose between them)

[amigarobot]

Apparently he's a penguin... Nah he gives pigeon vibes

[amigarobot]

bro i LOVE indigenous fusion music i love it when indigenous people take traditional practices and language and apply them in new cool ways i love the slow decay and decolonisation of the modern music industry

[amigarobot]

We've looked back on the records of 2024, so here's a sampler of games that you can play right now for the low price of free:

Beetle Ninja (a hero-for-hire RPG set two weeks before the end of the world, built for repeated playthroughs) / Grimm's Hollow (a spooky and sweet RPG set in the afterlife where you play as a Reaper hiding your ghost sibling)

Remember Places? (locked inside, an AI is your only friend) / Liminal Dreams (a game about exploring bizarre world and meeting strange strangers)

Drown the Bride (a point n' click adventure visual novel about meeting your friend's fiancee in a historically themed fantasy world) / MAMA (a visual novel where you pass out at a yuri convention you were attending with your girlfriend, and awake to find yourself in your childhood home making certain... connections about your mother's actions in the past)

Slider (a tile-based sliding puzzle adventure to find your cat via manipulating the world around you) / The King is Watching (defend your kingdom against an army; buildings are only productive when your gaze is upon them)

Rental (a short and spooky game about renting a cabin, reminiscent of classic survival horror games) / Illusion Carnival (a lost soul wanders a 2.5D pop-up book-like amusement park, evading the attacks of the anomalies that would love to eat them up)

HavE (a visual novel set at a ski resort vacation goes awry in ways that may be supernatural) / Zodiac Paradigm (a murder mystery visual novel arises when twelve animals are called to be a part of the Emperor's council, yet thirteen arrive)

Bad Manors (a point n' click visual novel on Halloween where your friend can't make it to an escape room with you, so a helpful stranger goes in his place) / Reaper's Goodbye (five patrons of a food stall tell their tales while waiting for the midnight train)

SWOLLEN TO BURSTING UNTIL I AM DISAPPEARING ON PURPOSE (a weirdo RPG in which a flying saucer crashes into the town of "Vomit", but you have packages to deliver) / Until Biglight (technically a demo, a sample of a cancelled project of poverty, cats, mice, violence, words like "hyperreality", and planning an assassination)

C.H.A.I.N. / C.H.A.I.N.G.E.D. / The Madvent Calendar (Three anthologies from the Haunted PS1 community. A game of game development telephone, a branching path telling a tale of time travel and family, and a haunted advent calendar.)

[amigarobot]

So Jefferson says he hasn’t talked to Orpheus in about 16 years. Triana is about 16. I think they had a situationship, but then Byron met Tatyana and it got all complicated and then Triana was born and Jefferson ghosted him.