#ms-excel

[picknmixsims]

Who's The Daddy?

A new transform for finding pregnant Sims via Hood Exporter V2.1

Download the whosthedaddy.zip file and place the whosthedaddy.xsl file in the Resources\XSL subdirectory of Hood Exporter.

After exporting with the whosthedaddy.xsl transform active,

the resulting WhosTheDaddy.csv file can be opened with MS-Excel for further processing.

[oiuytrewq-00]

A basic computer course provides foundational knowledge and skills necessary for effective computer use. Participants learn to navigate operating systems, utilize essential software applications like Microsoft Office, and manage files efficiently. The course covers internet browsing, email communication, and basic cybersecurity practices to ensure safe online activities. Additionally, students gain problem-solving abilities for common technical issues, making them more confident and capable in everyday digital tasks. This course is ideal for beginners looking to enhance their computer proficiency and productivity in both personal and professional settings.

[rainbow-taishi]

HSR Jiaoqiu made in Microsoft Excel

+ snippet on how I made it

[attitudeacademu4u]

Harnessing the Power of Functions: Excel Tips for Analysis

Welcome to the world of Excel, where data transforms into insights, and functions are the building blocks of powerful analysis. Whether you're a seasoned analyst or just starting your journey with spreadsheets, understanding and mastering Excel functions can significantly enhance your analytical capabilities. In this blog, we'll explore the fascinating realm of Excel functions, from the basics to advanced techniques that can revolutionize the way you handle data.

[bopex-guru]

Effortless Excel Data Cleanup: Remove Duplicates in Excel Like a Pro

MS Excel is a powerful tool for managing and analyzing data, but duplicate entries can hinder your progress and accuracy. Fortunately, Excel provides efficient methods to identify and remove duplicates, allowing us to streamline your data and work with confidence. In this article, I will guide you through the step-by-step process of removing duplicates in Excel, making sure that our data is clean…

[saydesole]

Black Southern Blues Singers

Happy Black History ✊🏿

Marvin Sease 1946-2011

Betty Wright 1953-2020

Johnnie Taylor 1934-2000

Denise Lasalle 1934-2018

Z.Z Hill 1935-1984

Ms. Jody 1957- Living

Mel Waiters 1956-2015

Tyrone Davis 1938-2005

[phoenixyfriend]

New OC clones idea

His name is XL. He's average clone size, so people are naturally curious about what the name means. They ask if it's a dirty joke about his dingaling.

It's not. He pulls up some files. He's the quartermaster. He uses Space Excel, and it's not CALLED Excel, but he Excels at it. Hence XL.

His friends in two other battalions are Spread and Sheets. All of them get asked the Is It A Dirty Joke question and ALL respond with The Same Fucking Move (files).

This clone's job is spreadsheets and he LOVES it.

[ingravinoveritas]

Someone shelving a DVD of Staged series 1 and 2 in the LGBTQ+ section of a shop is entirely too accurate and will never not be hilarious...

[every-pauling]

let’s fucking GO

[mint-ty]

Guyyyyysssss I got a job offer!!!! 😭😭😭 after a full year of jerking off I can finally be back in society!! I was so burned out from my last job and basically had quit on a spot when I was told (TOLD!) to do even more overtime than I was already doing. It took me around 7 months to feel like I wouldn't puke from just hearing my alarm clock again. It also means that from next month I will stop spamming tumblr like it's my main occupation 😂 (I probably will be spamming only in the evenings, we'll see).

It also means that my first salary will go to buying bojere commissions 😌

[picknmixsims]

Careers & School Data

A new transform for extracting career and school data via Hood Exporter V2.0

Download the careers.zip file and place the extracted careers.xsl file in the Resources\XSL subdirectory of Hood Exporter (there should be five other .xsl files in there already).

After exporting with the careers.xsl transform active, the resulting Careers.csv file can be imported into MS-Excel for further processing.

[ostolero]

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

[barcodenumber00]

the innies at mammalians nurturable seem to be there permanently. or they seem to be unable to leave.

most of them appear to be unclean, or have no access to personal care or are unclear on how to interact with people. if ms. huang was acquired by the company as a child, or if lumon has no issue taking on children, who's to say at least some of the employees at mammalians nurturable weren't also brought in as children, severed young enough that their memories were split before their minds could fully develop, flocking to the sound of a bell - like a school bell, maybe? (we see in ms. cobel's shrine that the Eagans owned schools)

What if they were the very first to be severed and they were hidden down below as failed experiments on young children? mammalians nurturable is also an interesting name. humans are mammals too.

his outie excelled at stargazing - glow in the dark stars in a child's bedroom.

[tatzelwyrm]

If I had watched this episode before Covid I might have thought the townspeople's aggression and readiness to turn to violence was a bit exaggerated.

But since I'm watching this in 2025, the only part of this episode I find unrealistic is that there isn't also a counter mob denying that anthrax is real.

[obi-wann-cannoli]

Okay so Mr Milchick in this episode - to me it felt like he was saying reprimands he himself had received as a child. And it has that clear Kier cult vibe to it.

Combine that with his discussion with Ms Huang regarding her fellowship, implying there’s a specific program Ms Huang is a part of that Milchick possibly has experience with?

Combine THAT with the theory that Cobelvig has been in the Kier cult since she was a child.

And I think we’re seeing three people raised fully in the Kier cult (either as orphans or with their family) chosen specifically to manage the severed floor. (And a potential parallel to the Eagen family itself? Maybe? It’s a stretch)

[ruushes]

the ginormous cartoon mallet is perfect 10/10 no notes but what is with this pose 😭😭