#A Beginner&039;s Guide to Excel

[needtricks-blog]

Data Scrapping Code to Scrap Data from the website

Below is the general code structure for web scraping using Python’s Beautiful Soup library. Keep in mind that web scraping is subject to ethical and legal considerations, and it’s important to make sure that you have permission to scrape data from the website in question. (more…) “”

[fluk3sake]

Find Character in String from Right in Excel

Find Character in String from Right in Excel

Working with some log files based on a Flat file, we use Excel to get the data in a structured way to be able to use against other datasets. Getting data from these Text-based logs does sometimes need some creativity. This is the case when trying to get an unknown amount of characters after the last instance of a specific character. To understand how to get to this, let’s work through three…

[bulkyphrase]

Everybody & the Avengers Team

I've got a new fic rec list for you!

The stories in the "X & the Avengers Team" tags focus on one person's relationship to the Avengers team as a whole. Courtesy of AO3's tag browse and Excel, here's a ranked list of the top 20 most popular pairings:

Tony Stark | 2470 total, 240 OTP

Peter Parker | 2255 total, 85 OTP

Steve Rogers | 602 total, 56 OTP

Loki | 387 total, 26 OTP

Natasha Romanov | 308 total, 35 OTP

Clint Barton | 268 total, 46 OTP

Bruce Banner | 244 total, 15 OTP

Thor | 209 total, 7 OTP

Avengers Team | 174 total, 24 OTP

James "Bucky" Barnes | 156 total, 7 OTP

Wanda Maximoff | 143 total, 4 OTP

Phil Coulson | 105 total, 9 OTP

Darcy Lewis | 91 total, 6 OTP

Matt Murdock | 60 total, 8 OTP

Sam Wilson | 53 total, 5 OTP

Nick Fury | 41 total, 5 OTP

Harry Potter | 40 total, 0 OTP

Pepper Potts | 31 total, 1 OTP

Vision | 29 total, 2 OTP

Stiles Stilinski | 25 total, 0 OTP

In chart form, if you like charts:

Notes:

The numbers after the names are the number of stories tagged with that ship. OTP means the number of stories where that is the only relationship tagged on the story. Numbers are accurate as of July 2021.

Story Recommendations

For your reading pleasure, included below is at least one fic rec for each pairing except the crossovers from non-Marvel fandoms (apologies to Mr. Potter & Mr. Stilinski). Most are gen fic, and even in the ones with a romantic pairing, romance is not the focus.

Tony Stark

As Subtle As Cognitive Recalibration by petroltogo (Teen, 8949) tumblr: @tonystarktogo

Standing inside his penthouse, listening to Rogers, Barton and Banner explain to Fury how they just happened to stumble over the Tesseract on a routine security check of Stark Tower’s roof and wouldn’t you know, they’ve managed to fight off the looming alien invasion before it could really start and secure the missing overpowered nightlight is one of the most surreal situations Tony has ever had the displeasure of experiencing.

Peter Parker

the worst field trip ever by shrill_fangirl_screaming (Teen, 3420) tumblr: @i-am-having-an-emotion

"We're on a field trip," Peter said. "To here. And Tony decided to be our tour guide and absolutely embarrass me, so can you please help get him under control?"

Which is how Peter Parker, architect of his own destruction, ended up with not one but two superhero pseudo-dads being annoying on his school field trip.

Steve Rogers

Do You Remember Being Happy? ('Cause I Sure Don't) by GalaxyThreads (Teen, 11022) tumblr: @galaxythreads

That seems about right. He doesn't know how he knows that, though. He does have vague memories of an annoyed fondness at finding peanut butter in some sort of jam. Thor's doing, because he doesn't see the point of using two knives when one works just as fine. He knows that. How does he know that? He knows all those little details, though, almost innately. How can he know these strangers so deeply?

Everyone else below the cut!

Loki

Proprietary by TheThirdMarauder (Teen, 7639)

No, Loki simply wants the Avengers conquered. The details of whom, how, and when matter not. Unless, of course, said details interfere with Loki's plans. Then, well, then none can fault him for protecting his own interests.

Loki has always been exceptionally good at lying to himself.

Natasha Romanov

What Girls Are Made Of by enigma731 (Teen, 4613) tumblr: @enigma731

She rolls her eyes but does as he’s indicated, using his shoulders to leverage herself up onto his back, her arms around his neck and her legs hugging his waist.

“You know,” he says blithely, “this isn’t really what I tend to picture when I think of a hot girl riding me.”

Natasha groans, deciding that if his sense of humor gets them arrested, she’ll kill him herself. “Just go.”

Clint Barton

Dear Clint Barton (circa age 7) by pollyrepeat (Teen, 4221)

With a normal person, this might count as blackmail material, but a) this is a case of mutually assured destruction if ever there was one, and b) Fury is immune to embarrassment. Not just in the regular, Tony Stark way, either, oh no. Things that could possibly end up being embarrassing to Fury get somehow warped and changed until they go from mortifying all the way over into useful and/or good for his image. It’s like a superpower.

Carrying Clint’s small child self around on his shoulders more than once has probably already hit the interagency rumour mill as an example of Fury’s innate awesomeness: good with rocket launchers and small children.

Also available as a podfic!

Bruce Banner

They're Not Wrong by Trumpeteer34 (Teen, 10163)

As Tony began to pace around the hole in the road to keep himself from shooting repulsors at the nearby buildings in a fit of rage, Thor began to study the nearby area. There was no sign of either the Hulk or Bruce Banner beyond the crater. The surrounding area, aside from the rubble of the fight, held no clue as to their friend’s location.

“Guys, he’s gone,” Tony growled into the communicator on their private line, drawing Thor out of his darkening thoughts. “Someone tranqed him and took him. He’s gone.”

Honorary mention goes to the Responsible Science series by @letteredlettered - the stories don’t have the "Avengers Team & Bruce Banner" tag, but they could, and they are amazing. The best Bruce Banner writing I've ever come across.

Thor

Fortunately, I Am Mighty by onward_came_the_meteors (General, 3062)

Steve was the first one to speak. “Are you okay?”

Thor nodded. Which was a bad idea, as it turned out, because now there were little gray lights flashing in front of his eyes. “I’m fine.” Absolutely everyone narrowed their eyes, and he added, “But, uh. Could we possibly not get back in the car just yet?”

Avengers Team

Civil Wasn't by onward_came_the_meteors (General, 7123)

"We're having an ideological conflict here," Tony stated with disbelief. "Are you telling me you still want to go out to dinner?"

"It's a standing engagement, Tony," Rhodey reminded him.

"Not you too��"

"We already had to reschedule from Friday when Natasha was..." Rhodey frowned. "What were you doing?"

The question was directed toward Natasha, who shrugged and said, "Spy stuff."

James "Bucky" Barnes

You Know How I Feel, aka, The Adventures of Bucky and Muffy the Dinosaur by ifeelbetter (Not Rated, 4511) tumblr: @ifeelbetterer

“As you may have heard, Bucky Barnes, a.k.a. The Winter Soldier, recently rescued a tiny part-robot dinosaur during the Avengers’ battle with Dr. Doom in Antarctica,” the other newscaster explained. “Pictures of Barnes and the dinosaur were posted on twitter by fellow Avenger, Clint Barton, a.k.a. Hawkeye, and immediately made Barnes’s new pet America’s sweetheart.”

“Her name’s Muffy,” said Steve."

Wanda Maximoff

and the woman was young again by Mira_Jade (General, 3669)

Tony Stark called them the Cap's Kooky Quintet, and sometimes the term amused her – causing her to lift a sardonic brow where someday a smile would truly smile. She enjoyed the presence of comrades – true comrades – and she enjoyed the way their minds wove and bound together about each other to fluctuate against her senses as one. There was something soothing about being in their midst, and even when their loud and brash ways – their painful Americaness - rubbed her raw and drained on her, it was ever the knitting of their minds that soothed those moments over, and made them inconsequential.

Phil Coulson

Coulson's First Day of School by storiesfortravellers (Teen, 3055)

Coulson looked up at him. “I like drawing pictures with Mr. Rogers. I like having tea parties with Ms. Potts. I like it when Dr. Banner reads me books, and I like it when Natasha teaches me things. And I like when you play with me. You do really good voices when we play action figures. And you’re the only one who lets me do stuff like jump off the high diving board at the pool or eat three cupcakes or play tackle with kids at the park.”

Clint didn’t realize that. He was pretty sure that meant that he was doing something wrong.

Darcy Lewis

Beginner Yoga for Dummies (Darcys) and Sad Hobos by chailover (Teen, 3434)

Darcy had a theory: crazy attracted crazy, working kind of like gravity. It was pretty much her explanation for her life after Thor. And if she had thought the type of crazy Thor attracted was bad, be it Loki or the Warrior Three and Sif, or the dark elves and the Convergence, it was still nothing against what the Avengers manage en masse.

Matt Murdock

Double Blind by smilebackwards (Teen, 2381) tumblr: @smilebackwards

Stark snaps his fingers. “You can’t see half of my inventions. This explains so much about you and why you’ve never been properly impressed by me.”

“Does it?” Matt says, ambiguously.

Sam Wilson

Bystander by scribblemetimbers (Teen, 52029)

“I just want you to know,” Sam says loudly, cautiously raising his hands, “That I’m very poor and very sleep-deprived and literally the only thing you can kill me for right now are my notes.” He pauses. Wait. On second thought: “Please don’t steal my notes.”

“I’m not—I’m not a mugger,” Not Mugger rasps out, and for all that he looks about to keel over and die, the man actually manages to sound offended.

Nick Fury

Bedtime Story by dixiehellcat (Teen, 2532) tumblr: @deehellcat

Fury snorted. “I have to check in with the duty officer. I’ll be back in, let’s say twenty minutes. I expect all of you to have whatever your pre-bedtime routines are completed, and be in here pajama’ed and ready to be read to.”

He tapped the book under his arm, then left with the usual dramatic swish of his long coat. Bruce scratched his head. “Did…he just say be ready to be read to?”

Pepper Potts

Pepper and the Avengers (Which She Knows Nothing About) by rebelmeg (General, 6696) tumblr: @rebelmeg

The Avengers, that mismatched group of hurt and heroism, was one of the most important things in Tony Stark’s life. So, naturally, Pepper had made them an important part of her life too.

Vision

039. Intoxicated by aimmyarrowshigh (Teen, 100) tumblr: @aimmyarrowshigh

It might be nice to fit in, just this once. To lose a bit of composure.

Vision floated over to the refrigerator and, with some timidity, pulled off a magnet. He stuck it to his forehead.

[fluk3sake]

Learn Excel: What is Excel? Excel Layout

Learn Excel: What is Excel? Excel Layout

Whenever I meet a User that complains about knowledge and learning Excel better, I find that most of the time it is because they are shown the difficult side of Excel. With the difficult part, I mean they see functions within functions and get told these functions are easy. This is true if you used each function separately or even if you understand a few concepts of how Excel works. What is…