#Excel cell formatting
Explore tagged Tumblr posts
Text
youtube
001 : Excel Tips & Tricks : Learn, How to Apply Automatic Cell Formatting in Excel [2 min]
Subscribe to "Learn And Grow Community"
YouTube : https://www.youtube.com/@LearnAndGrowCommunity LinkedIn Group : https://www.linkedin.com/groups/7478922/
Blog : https://LearnAndGrowCommunity.blogspot.com/
Facebook : https://www.facebook.com/JoinLearnAndGrowCommunity/
Twitter Handle : https://twitter.com/LNG_Community
DailyMotion : https://www.dailymotion.com/LearnAndGrowCommunity
Instagram Handle : https://www.instagram.com/LearnAndGrowCommunity/
Follow #LearnAndGrowCommunity
#Excel tips#Excel tricks#automatic cell formatting#Excel cell formatting#conditional formatting#productivity#data analysis#data visualization#spreadsheet tips#Excel formulas#Excel sheets#Microsoft Excel#Excel tutorial#Excel training#Excel guide#Excel hacks#Excel techniques#Excel mastery#ExcelTips#ExcelTricks#CellFormatting#ConditionalFormatting#ProductivityHacks#DataAnalysis#SpreadsheetTips#ExcelMastery#Youtube
1 note
·
View note
Text
im honestly sooo glad that spreadsheet didn't implode while charborg was using it. i had the stream playing while I was driving to my friend's house cause some random google sheets update had initially broken the script that randomizes the tiles. charborg caught it before stream and I got it fixed but still... fear.
#sheets has some very weird limitations compared to excel that i had to work around in goofy ways#like I could NOT get conditional formatting to operate based on a cell in another tab. it was same tab or broke#and othet stuff
7 notes
·
View notes
Text
My villain origin story is my coworkers messing with the format on our excel spreadsheets
#work#shitpost#workplace drama#excel spreadsheets#work stories#like it’s not that hard to format the cells#it takes two seconds#i hate my job
0 notes
Text
seriously, though. i work in higher education, and part of my job is students sending me transcripts. you'd think the ones who have the least idea how to actually do that would be the older ones, and while sure, they definitely struggle with it, i see it most with the younger students. the teens to early 20s crowd.
very, astonishingly often, they don't know how to work with .pdf documents. i get garbage phone screenshots, sometimes inserted into an excel or word file for who knows what reason, but most often it's just a raw .jpg or other image file.
they definitely either don't know how to use a scanner, don't have access to one, or don't even know where they might go for that (staples and other office supply stores sometimes still have these services, but public libraries always have your back, kids.) so when they have a paper transcript and need to send me a copy electronically, it's just terrible photos at bad angles full of thumbs and text-obscuring shadows.
mind bogglingly frequently, i get cell phone photos of computer screens. they don't know how to take a screenshot on a computer. they don't know the function of the Print Screen button on the keyboard. they don't know how to right click a web page, hit "print", and choose "save as PDF" to produce a full and unbroken capture of the entirety of a webpage.
sometimes they'll just copy the text of a transcript and paste it right into the message of an email. that's if they figure out the difference between the body text portion of the email and the subject line, because quite frankly they often don't.
these are people who in most cases have done at least some college work already, but they have absolutely no clue how to utilize the attachment function in an email, and for some reason they don't consider they could google very quickly for instructions or even videos.
i am not taking a shit on gen z/gen alpha here, i'm really not.
what i am is aghast that they've been so massively failed on so many levels. the education system assumed they were "native" to technology and needed to be taught nothing. their parents assumed the same, or assumed the schools would teach them, or don't know how themselves and are too intimidated to figure it out and teach their kids these skills at home.
they spend hours a day on instagram and tiktok and youtube and etc, so they surely know (this is ridiculous to assume!!!) how to draft a formal email and format the text and what part goes where and what all those damn little symbols means, right? SURELY they're already familiar with every file type under the sun and know how to make use of whatever's salient in a pinch, right???
THEY MUST CERTAINLY know, innately, as one knows how to inhale, how to type in business formatting and formal communication style, how to present themselves in a way that gets them taken seriously by formal institutions, how to appear and be competent in basic/standard digital skills. SURELY. Of course. RIGHT!!!!
it's MADDENING, it's insane, and it's frustrating from the receiving end, but even more frustrating knowing they're stumbling blind out there in the digital spaces of grown-up matters, being dismissed, being considered less intelligent, being talked down to, because every adult and system responsible for them just
ASSUMED they should "just know" or "just figure out" these important things no one ever bothered to teach them, or half the time even introduce the concepts of before asking them to do it, on the spot, with high educational or professional stakes.
kids shouldn't have to supplement their own education like this and get sneered and scoffed at if they don't.
24K notes
·
View notes
Text
Okay so in my Computer Applications class we learned about conditional formatting in Excel, where you can change the color of a cell by inputting certain values.
We're supposed to use it to model heat gradients in metals, but I found a better application:

FROG ART
#frogs#Excel#i spent like an hour doing this#should I have been doing my homework instead?#absolutely#do I regret it?#absolutely not#frog art#pixel art
10K notes
·
View notes
Text
anyway i think excel could be a LOT more productive if it made less assumptions, such as just not evaluating formulas if theyre in column A/row 1 ("title row syndrome") or, as i just discovered, if the cell format is set to "text" automatically (i didnt do that, it just randomly decided the cell had to be text format)
#tütensuppe#shakes fist#or that thing where simple referencing also pulls over the format#nobody asked you to do that!!!#tho im using libre office on my work laptop and it also does fun things#such as evaluating the same formula (!) with the same values (!!) differently depending on where it is#im keeping a sheet with my work times bc we have no punch system (people have been arguing about that for years now apparently)#so like im summing up hours over the week and the program will say yep thats 6 hours. done.#put the same formula in another cell and suddenly its 39:40 or whatever#ALSO GIANT PET PEEVE CTRL-A DOESNT WORK IN EXCEL FORMULAS#fucking hell
1 note
·
View note
Text
Conditional formatting my BELOVED
#whhere would we be without her#you can even FILTER TABLES by CELL COLOR once youve conditionally formatted#she is soooo#Microsoft Excel#spreadsheetposting
1 note
·
View note
Text
You can generate Sierpiński carpet (the 2D analog of Menger sponge) at home! I started with addition modulo 3 and some conditional formatting in Excel.
I left the modulus configurable. Powers of 2 produce simple tessellations instead of fractals, so the first viable fractal is A1=3. Here’s the modulus 3 image at 729x729 resolution:
This is the standard sierpinski carpet. But starting with modulus 5, higher primes are going to give us some trippy Menger-analogs with intricate self-similar geometry. Let’s dive in:
Modulus 5
Modulus 7
Not all composite numbers are duds! Mod 9 is beautiful with its single order 3 subgroup.
But Mod 15 is not so much a fractal as a self-similar glitch. The subgroups of order 3 and 5 are all jumbled together!
Modulus 17
Modulus 19
Modulus 23
Modulus 29 with 707281 cells. (That’s 29 to the fourth power!) And that’s the limit, because Excel is running garbage collection nonstop trying to compute any more of the image. Excel 2010 was limited to 2GB of ram and we are out. I call this collection of renders ��seafloor”.
Original Date May 7th, 2023 11:16pm
230 notes
·
View notes
Note
hi! where do you get your drabble prompt lists from? do you have a compilation of all the prompt words somewhere
Thank you so much for asking this! Quite coincidentally, I've been working on a post about how to curate prompt lists without AI, because I'm SO ANNOYED BY PEOPLE SAYING THEY NEED AI FOR PROMPTS. You do not need one iota of AI for writing prompts! Here's how I curated my list of random word prompts, which has enough prompts on it for me to do daily drabbles for something like 27 years if I wanted.
Image-heavy How-To under the cut!
This is my method for curating a prompt list, which means that these are the kinds of prompts that work well for me. I like single-word or short phrase prompts only, because prompts that are too detailed feel "already written" to my brain and don't inspire me. If you have a different style of prompt that you prefer, that's totally fine. You still don't need AI, though, I promise -- any style of prompt you like, you can google it and there WILL be thousands of curated lists created by actual human writers at your disposal. @fixyourwritinghabits has TONS of resources about finding and curating writing prompts without AI.
But if you like single word/random word prompts, this is how I created my Massive Prompt List.
Go to the Porn Battle. WHAT? Yes, I said Go To The Porn Battle, which was a fandom event for many many years and featured any and every pairing under the sun, requested alongside... random prompt words. Some are porny. Most are just words! Pick any given year of Porn Battle from the archives in the sidebar. https://web.archive.org/web/20160716010243/http://battle.oxoniensis.org/
2. Copy the ENTIRE PAGE. This will take a LOT of memory! It is an extremely long page of text! (I did this on a desktop computer. I cannot promise you can do this tutorial as-is on a phone or tablet.)
3. Paste it into Notepad or another PLAIN-TEXT program. Word will try to include the formatting, and we don't want the formatting. Plus, plaintext will use slightly less memory.
4. Copy your plaintext into a word processing program. I used Word 365 without Copilot, and I cannot guarantee that the steps are exactly repeatable in Google Docs, but I would assume that they are pretty close.
5. This step, though, I am NOT sure that you can do in Google Docs, so you may have to play around and see what your options are there. You're going to open up Find+Replace, and FIND all the commas (,) and REPLACE them with tabs (^t).
6. Now you have an even longer document, because obviously tabs take up more physical pagespace than commas do. That's what we want. We're going to copy this entire document...
7. ...And paste it into a spreadsheet. I used Excel, but I assume that Google Sheets has many of the same capabilities. Again, you'll need to play around if you're not using Office. But each tab should be in the next column over. This is key. This is what we want. If your document all copied into one column, go back and try again with the tabs.
8. The FIRST column is all of the FANDOMS AND PAIRINGS. Since I am not interested in keeping those for my prompt list -- I have my own fandoms and my own pairings that I want to write, and odds are I haven't even heard of a lot of the ones people were submitting 15-20 years ago! -- we're going to delete the entire FIRST column. ONLY THE FIRST.
9. Now we have approximately 15,000 random words in their own cells across the spreadsheet. *I* personally like to alphabetize each column to get rid of the blank cells. It's easier to see how many columns we're actually working with that way.
10. Now the slightly tedious work starts: curating the actual list. We're going to cut Column B and paste it at the bottom of Column A. Alphabetize Column A (which now also includes the text from B). And then DATA -> REMOVE DUPLICATES.
11. Repeat for every column until you have one fucking long Column A of random word prompts! Then, go through the list and remove any that you know you will not be interested in writing -- that might be words specific to a fandom you aren't in (Dalek, for example); words that are squicky for you; words that you don't know; words that just don't ping your brain with story ideas. But for that last one... be very generous. Allow EVERY meaning of a word to be a possibility. You might not think that a word fits with your OTP or fandom of choice, but in 99% of cases, you can find a way, I would bet.
12. Copy your WHOLE long-ass Column A of alphabetized words into the List Randomizer. https://www.random.org/lists/
13. Paste the randomized list back into whatever program you want to use to store your list. I keep mine in Excel, separated into smaller 100-prompt lists, but I am nuts when it comes to prompts. You can easily keep your list in Word, or Google Docs, or Ellipsus, or whatever!
14. Write! Play! Have fun!
I also have a couple of already-curated prompt lists on my Tumblr at https://www.aimmyarrowshigh.com/drabbles -- Feel free to use these lists however you wish. I'd love to be tagged to see what you write! :)
29 notes
·
View notes
Text
Shoutout to this one rando internet poster's rando Grandma; I read a post where this person was setting up a computer for their grandmother, explained how it worked, and so on, and then got a call a week later from their indignant gran saying, "Why didn't you tell me about the knitting program?!?!"
Poster says, what knitting program? And she says, it's got lots of little boxes and you can colour them and put things in them. And when they go over to look - it's Excel. She's shrunk the Excel cells and is making knitting patterns in Excel.
Anyway. I now (for the last several years) make all my knitting patterns in Excel*, because if you use conditional formatting then it's extremely powerful. Type 'a' in a cell and it turns a colour; 'b', a different one.
Behold, a simple example.
Can't show you what I'm working on but it's EnormousTM.
And you can just arrow key up and across, row by row; hit save before closing and it'll even save your place.
Also, you can calculate your knitting maths with it.
Random grandma, if you're out there, I owe you one. Call me. We can swap tips and tricks.
*LibreOffice Calc also works but is a little more annoying to use.
#knitblr#knitting#cats#edit: yes i know about x y z specially designed knitting program i don't like them#and i have been doing this for *years* i have my workflow down
63 notes
·
View notes
Text
now that we don't talk

I cannot be your friend, so I pay the price of what I lost And what it cost Now that we don't talk
alpha colonel König x beta ex-lover reader
2nd person, no y/n, she/her pronouns, reader's callsign is Eden, reader speaks French, omegaverse, exes to lovers, fraternization
2.2k words
tw: none
I swear to God one day I'll write something that doesn't involve that big hooded freak. But today is not that day.
Shoutout to loganlermanstanaccount here on Tumblr, who I won't tag. The bullet point headcanons with written parts interspersed format is from their excellent college roommate Miguel O'Hara post, which became their fic Rigor Mortis. I highly recommend both!
Also, excuse the absolutely butchered military content. I'm sure none of this is how it works in real life, but alas, this is fanfiction, not a research paper. Reader serves a Laswell-like role, but I refrained from labeling her as CIA even though I do call her a station chief. For the purposes of this fic, she's the voice in the operatives' ear during ops. We're playing a bit fast and loose with the terminology here.

You’re a highly skilled intelligence agent and operative handler.
You’ve spent most of your life dedicated to your career: moving through the ranks, proving yourself, refusing to let anything stand in the way of your ambitions.
You’ve done some things you aren’t proud of, but always for the right reason. Or the reason that made the most cold, logical sense. Even when your heart tells you otherwise. Nobody in this line of work has clean hands, after all.
You’ve always done what needs to be done. For everyone’s best interest.
Today marks the first day of your collaboration with a PMC called KorTac. You’re hunting down a homegrown cult turned out-of-control terrorist cell.
You haven’t had much experience working with mercenaries, but in terms of hardened war criminals, KorTac’s people are quite well mannered.
Not that you had expected them to be rude and discourteous, but, well. You are an outsider. They haven’t necessarily embraced you, but their reception was nice enough.
You’ve got a meeting with their commander, but you can’t quite find the room you’re supposed to be meeting in. Not a great first impression to make, but luckily, someone takes pity on you.
He introduces himself. Korean. Callsign Horangi.
“You’ll get used to the layout of the base,” he says as you follow him through winding hallways.
“I hope so,” you reply. “I’ll be here for a while." You study the walls, the signs and numbers on the doors, trying your best to memorize everything.
"Do you know your commander well?" you ask. You're not the world's biggest fan of small talk, but you may as well know what you're walking into.
"König? Yeah, we've been close ever since he joined up." Horangi says, leading you into a long hallway. "He's a good guy. A little intense, but don't let that get to you. He's just getting the job done."
"We'll get along if he's competent." You can respect a man who forgoes pleasantries for making sure the shit gets shoveled.
"You don't have to worry about that." Horangi stops and holds the door open for you. "After you."
You study him for just a moment before entering the room. He's curt and to the point. Not bad-looking, either. Hopefully you'll get more chances to—
Your heart nearly stops.
KorTac's commander is facing away from the doorway, shuffling through some papers by the looks of it. But you would know him from any angle. The set of his shoulders, the way his stance is at ease but never truly relaxed, the way his hair curls at the nape of his neck.
You have to force yourself to step into the room. And when you do, he turns around.
You're vaguely aware of Horangi stepping around you to get into the room, but that's happening somewhere far away from the headspace you occupy right now. By the way König's eyes widen as they meet yours, he's in the same place too.
He hasn't aged so much as he's gotten more tired. He never did sleep enough, but now he looks like he hasn't gotten a sound night's rest in a long time. He's put-together, but there's a haggardness to him that probably wouldn't be noticeable to anybody but you. Someone who knew him when he was younger, and in the prime of his life. Someone who used to know every scar on his body, every crease of his brow, and now hasn't seen him in more than a decade.
The man who broke your heart stands on the other end of the room, staring at you as if he's seen a ghost.
The two of you stand there for a while before Horangi's voice shakes you back to reality. "Brought the station chief, sir."
"I...see." König—you suppose that's what he calls himself nowadays, the arrogant prick—clears his throat. "Thank you, Hong-jin."
"No problem." Horangi takes a seat. "The others will be in soon."
Horangi seems like a perceptive enough guy. Can he tell that the room feels several degrees colder? You pull a chair out, the furthest one from König's position possible, and ignore the hurt that briefly flashes across his face as you sit down.
The meeting goes well. It's just an opportunity for you to formally introduce yourself to the KorTac operators you'll primarily be working with for the next few months.
You can tell they're a close knit group by the easy way they interact with each other: they've worked together for a while.
König, too, is part of them, which must be how they pick up on the chilly dynamic between the two of you. Some of them are just puzzled. For most of them, it raises their hackles.
It doesn't matter to you. You can barely focus on getting through the meeting without feeling like you're going to faint.
It's absurd. You're not some delicate Regency-era lady. You're a hardened military officer. But it makes no difference.
It doesn't matter how long it's been, it seems. He's still the only one who can make you feel like this.
You can't get out of there fast enough after the meeting has concluded. Not only are the others shooting you suspicious looks, but you've spent too long in his presence. Any longer, and you don't know how you're going to keep your composure.
But you can't escape him. Of course not. Why did you ever think otherwise? You hear him call for you, and you walk faster. But it's futile.
This hallway is smaller, narrower, less open. Nobody's around to watch when he slams you against the wall to stop your hasty retreat. Nobody's around to see the way you sway in his hold, overwhelmed by the smell of him all around you. You're bathed in it, the overpowering presence of him.
"We need to talk." he demands.
"We just did. Meeting's over," you shoot back, making a paltry attempt to wriggle out of his grasp. He loosens his hold on you, but you're still trapped between him and the wall. No exit.
"I didn't plan this, in case you're wondering."
"That much was obvious." He's let his hair grow out longer, you notice at the most inopportune time possible. It suits him, you think.
He sighs in frustration. "If we're going to work together, we have to be civil."
"Don't worry. I wouldn't expose how much of a scoundrel you are in front of your precious squad," you bite.
You feel a twinge of smug satisfaction as regret settles into his expression. Too little, too late.
"I don't want it to be like this, either," he murmurs. "Ignoring and avoiding each other."
"You don't get to tell me how to act."
"You're right. But it's been a long time. Can't we try to get along? Not for my sake, but...yours."
"Well that's not condescending at all."
"That's not what I meant. I know my team. If you're walking around resenting me openly like that, they won't trust you. And they need to, if you're working with us."
He's right, and you know it. But there's that deep instinct inside you, older than your bloodline, waking up after a long slumber. It wants him, snapping at the bit to give into him and do whatever he asks of you. The urge will consume you if you don't fight it every step of the way.
You glare up at him, hoping you come off as brimming with resentment instead of desire. "As long as you and your team stay professional, I can too."
He's not satisfied with that answer, but it's all you're going to give him.
"Fine." He steps away from you, and you pour all your willpower into commanding your body to stay still. To not chase after his closeness. You sway on the spot, dizzy with his scent after having gone so long without it.
"This hallway is a dead end, by the way."
You try, you really do. But it's hard to be around him without feeling the urge to touch him, to press yourself against him and inhale him like the most destructive drug possible.
Your only recourse is to stay as physically far away from him as possible.
You do your best to ingratiate yourself with the other operators. You and Calisto are fast friends: she's got a breezy confidence to her that's quite refreshing. It also doesn't hurt that you speak French, as well. There's a bit of kinship felt whenever the two of you are holding a conversation none of the others can understand.
Horangi's a different story, though. The initial courtesy he showed you is a bit more clipped, now that it's clear something is up between you and König.
You can't believe you missed it the first time, the way König's smell is all over him. It really has been too long.
The two of them must be pretty close. You give up trying not to fixate on the idea.
You didn't mean to eavesdrop on them, but you were curious. Even more curious when you hear your name mentioned.
"It's pretty clear you and Eden know each other. None of us are stupid."
You freeze in your tracks. The door is closed, but you can hear Horangi's voice, loud and clear in the room behind it.
"It's not relevant. She's just here to do a job."
"I think it's pretty relevant that she gets up and leaves whenever you enter a room, regardless of what she's doing. She can't get away from you fast enough."
You give a surreptitious look at your surroundings, then lean down slightly, pressing your ear to the door.
"You're not going to give this up, are you?"
"Hell fucking no."
You hear König sigh. "Fine. We knew each other before I joined KorTac. Back when I was in the Jagdkommando."
Do you want to hear this? Your painful history, relayed to a near stranger? Horangi's not a stranger to him, that's for sure.
"And?"
"We were...involved."
"You and a beta? Never took you for the type."
"Well, neither did I. But she was...special. Smart, pretty, deadeye with a knife. Wouldn't give me the time of day, of course. I was obsessed with her."
"Naturally."
"Give me a fucking break, okay?"
"Can't wait to hear how this ended."
"Not...great. I was a total dick."
You can say that again, you think.
"I was young. Real dumbass who thought he was hot shit."
"You still aren't."
"Shut the fuck up." Something twinges inside you at the hearty laughter the two of them share. You missed that laugh.
"Despite everything, it was the most stable relationship I've ever been in. We looked out for each other. She knew me better than some of my family does."
"How did you fuck that up, then?"
"I got too comfortable. Started thinking I could do better. God, what a fucking idiot I was. I loved her like crazy, but I didn't realize how good I had it until it was gone."
"She left you?"
"No. I was the one who ended things. In the worst way possible, too. I told her the relationship wasn't going to go anywhere, that we were never going to be a serious thing."
"Ouch. Why not?"
You squeeze your eyes shut. You remember that night, like a shard of glass buried in your chest. As hard as you tried to forget, you'll never forget the way you felt. Like the world was ending.
You'll never forget the decision you had to make.
"I told her I couldn't see myself with a beta long-term."
"...that's fucked up."
"I know. I know. I was too caught up in that shitty macho alpha mindset. I was fucking ravenous back then, and I thought only an omega could give me what I needed."
"I get it now. If I were her, I would have quit on the spot seeing you in that meeting room."
"Yeah. She's a better person than I can ever imagine being."
Well. It's nice to know he regrets it, you think. Not that it does you much good now. Quiet as a mouse, you make a quick exit before you can get caught.
You make it back to the the room you've been assigned to. They were nice enough to give you your own private quarters, something you deeply appreciate when you need to be alone with your own thoughts. Like right now.
It's a strange feeling, to sort of get closure like this. Not at the end, but at the beginning of something new. You still have to see each other. Does it help that you know how he feels? Maybe, but it doesn't ease your own guilt. In fact, it makes it worse.
You're not mad at him for telling Horangi. You're glad he did, actually. There are some secrets that cause more harm to keep than not.
You open a drawer and pull out the pill bottle, hidden underneath your other possessions, and stare at the label.
WARNING - SUPPRESSANTS. NOT TO BE USED BY ALPHAS. ONLY CONSUME UNDER PHYSICIAN SUPERVISION.
You would know.

BOOM! There you have it. (In case it wasn't clear, the suppressants are for omegas.)
@sprout-fics's omegaverse 141 headcanons series inspired me to write something based off the idea of an omega disguising themselves as a beta in the military. Please check out her series, it's great.
I was really into exploring how omegaverse dynamics can make complicated relationships even messier. I did consider writing this story without the omegaverse, but I think now it's kind of an essential element. (I also just. Want them to have crazy nasty omegaverse sex. Sue me) I can't picture König ever breaking up with someone he deeply loved and was obsessed with, unless he had a reason like that. Still not a great reason, but a little bit understandable. Eden being a disguised omega also adds a bit of spice to the exes-to-lovers arc, too: she could have just come out and told him she's not actually a beta, but she chose not to for the sake of her career. Oof. Ruthless judgement calls were made on both sides.
I put this out because this idea had me in a STRANGLEHOLD, and I just had to get it out before I burst. Hopefully my writing's still up to par 😅 As for Kingdom Come, part iii may take a little while longer because a lot is going to happen in it, so I hope this can tide you guys over until then.
As usual, comments and feedback are always appreciated! I would love to talk about this au more. And again, if you'd like to be tagged, drop a reply. And if you're in the taglist and would like to be removed/only tagged for Kingdom Come, please let me know!
@crowbird @poohkie90 @cumikering @iytatsworld @papaver-decervicatus @anxietyrain @riotakire @ax0lotly @cookiepie111 @kacchasu @no1runawaymilkdad @chthonian-spectre @backwards-readings @yxllowtxpe @garbau @hexqueensupreme @queenthorin1 @violetstyless @her-majesty-theking @vegan-peppermint @peonytarian @ghostslittlegf @euuuuuuun @e1x03 @kokonoiwife @deaddainish @dragonfang @teehee-47 @catluvwr @keiva1000 @waves-against-a-cliff @channelsoph @cutiecusp @itsagrimm @dins-riduur-anthe @mantishymns @lexuria
#könig#konig#könig cod#konig cod#konig x reader#konig x you#könig x reader#könig x you#cod#cod mw2#call of duty#mw2#konig mw2#könig mw2#fic: now that we don't talk
240 notes
·
View notes
Text
I've now posted my second weekly QL recap post and I'm honestly just really proud of myself. Not just that I've stuck to doing it but also that I've managed to make it something I might actually be able to keep doing because I've made it as easy as possible for myself. That way it's less likely that it'll start feeling like a chore or that it'll take up a lot of my time when I'd rather be talking about the shows than formatting a post.
So because I'm a nerd and I kinda wanna show off a little bit because I'm proud of what I've managed to make, let me tell you exactly what I've set up to make my weekly recap post.
The basis for the post is simple enough: an excel spreadsheet and a python script.
My Spreadsheet of BLs
The spreadsheet is based on My Watchlist on MyDramaList which I literally just do ctrl+A and copypaste into a sheet. This is then automatically compiled into a different sheet where I've made a better overview of all the shows I'm watching and have watched in the past.
Based on this I've set up the weekly overview in a separate sheet shown below
When I'm compiling my weekly recap I can then easily add any new information here.
For new shows I add the information below to the sheet
- MD Title (copied from MyDramaList overview sheet)
- Title (usually copy of MD title with minor edits)
- Site I'm watching the show on
- Tags I want to use for the show
- Episode nr. I'm starting the show on
I also make a banner for the show but I've found a good source for images so it doesn't take long most of the time.
I have to manually upload the banner for the first week but then for the second week a show is in the recap, I can add the HTML for the banner from the previous week's post to the sheet. That way the banner will just be automatically be added to the post every week after that.
Throughout the week I then write notes on each episode I watch into the sheet and before I make the actual post I add the order I want the shows to appear in on the post.
The Script is Where the Magic Happens
When I've finished filling out the spreadsheet for the week I go to my python script, change the week number in the script and run the script.
In the script I've taken the HTML code from my original recap post and set it up so the script fills the information from my spreadsheet for each show into the right places in the HTML code. Since I doubt you guys would find it riveting to look at my full script, here's a little snippet!
When I run the script it then prints out the HTML for the post which I can insert into a new post on tumblr and voila, a weekly recap!!!
I do then have to go through the text for each show and add breaks and spellcheck because that's easier to do here than in the excel cell where I write the notes to begin with. If I have any overall notes or any new banners I have to add, then this is also when I'd do it.
I'm sure there are things you could set up in a better way but this works for me and reduces the amount of time I have to set aside every week for creating the post by a lot. It just makes it easier for me to share my thoughts in a way that's nice to look at without having to spend a ton of time formatting a post each week.
Hope this didn't take away any of the magic behind my posts but just gave a cool insight into the things you can do to make recurring posts easier to make.
Any questions or comments are welcome!
Side note: if you use tumblr on the mobile app and notice that any of the lines with "Episode x of x || Watching on:[site]" are split into two lines, let me know!
That line was surprisingly the hardest to make look the way I wanted because the width of posts and look of text types change depending on whether you're on desktop or the mobile app.
#Sof's a Nerd™ and owning it#I'm actually pretty new to python#so it took me a hot minute to figure out how to wrangle the information out of the spreadsheet and into the HTML script#but at the end I'm pretty satisfied with the result of my hard work#I'd much rather have spent time on the script and spreadsheet in advanced than have to spend a lot of time on the post every Sunday/Monday#it makes it easier to keep up doing the recap posts when I'm busy during the weekend#I was also worried that it would become a chore and as a result also make it a chore to watch BL which is the last thing I want to do#Sof watches BL#Sof Watches Weekly
18 notes
·
View notes
Text
What if Azul was visited by three spirits of Christmas? I present to you…
A Twst-mas Carol!
This was supposed to be uploaded bi daily for the next week or so. It might not stick to the schedule but I am currently in the middle of finals so…
- - - - - - - -
This was just too easy. Such an uncommon chance for students to fix their grades right after the testing season, but with the caveat that one would have to study over the winter break? To most students, it would be impossible to achieve this while also visiting home and celebrating the holiday season.
Fortunately, Azul had no such frivolities to take up his valuable time.
- - - - - - - - -
Chapter One: Skully’s Ghost
“Skully is dead, to begin with. Although you may have been able to tell that if you paid attention to the uniform he’s wearing.”
Professor Trein drew his student’s attention to the image projected on the classroom wall. The pale, grinning student seemed to be matching everyone’s gaze, as if he were one of the school’s enchanted paintings.
A gloved hand shot up in the air, and Trein nodded towards him.
“The uniform he’s wearing is one of the oldest types ever used. If I recall correctly, this uniform is so old that it wouldn’t have a magic pen holster.”
“Excellent, Riddle. You are correct. Skully was a student at NRC back in the…”
As Riddle took a moment to quietly preen himself for his in depth answer, the silver haired classmate next to him tuned out the lesson’s introduction as he added “create extra unit study guide” to his daily checklist.
He snapped back into focus as Trein began to write on the chalkboard. The words read: “Bonus Quiz: 1/13”. A few students groaned or let out a sound of discontent, drawing an icy stare from Professor Trein.
“I certainly hope I am not hearing students complain about my generosity. You must be aware that there are some of you who desperately need a bump in their grades to start off the new year. I have even themed it to a holiday, of sorts. It will be festive to learn about the life of such an influential figure, I assure you.”
A brown haired student raised his hand in polite protest.
“Professor, do you really mean January thirteenth? That's the day after we get back from break.”
“It is. My gift to you this year is that it won't be on the twelfth. Do not make me rethink this.”
Azul interjected with such a polite tone that Trein hardly noticed him speak out of turn.
“Thank you for giving us some grace, Professor. May I ask what format the quiz will be in?”
Trein nodded and turned to the board to continue writing test details. As he did, Azul began writing on a new page, titling it “Bonus Quiz Study Sheet: Draft #1”. He felt a grin tug at his face. This was just too easy. Such an uncommon chance for students to fix their grades right after the testing season, but with the caveat that one would have to study over the winter break? To most students, it would be impossible to achieve this while also visiting home and celebrating the holiday season.
Fortunately, Azul had no such frivolities to take up his valuable time.
And if any desperate student were to return to campus and realize they were sorely unprepared for the quiz, they would know who to come grovelling-er, requesting help to.
Sometimes, he felt like NRC was just made for him to run his business in.
As he packed his books after class, he overheard two students talking under the general chatter of the classroom. It wouldn’t have piqued his interest, but he heard his name being said.
“Figures that Azul would be all suck up to Trein just because he assigned homework for the break. That scrooge wouldn’t know holiday spirit if it smacked him in the face…”
“Really? I mean, I know he’s a suck up, but what’s he got against Christmas?”
“You don’t know? Dude, last year h-”
The boy who was speaking was hushed by his companion, who had noticed that the classroom was now too quiet to brazenly gossip with the subject of your tale in the room. He must be the one with a brain cell, Azul assumed.
Azul played the fool as he left the classroom, pretending he hadn’t been eavesdropping. It seemed to work, as he heard a small sigh of relief when he was further from the door.
It was almost too easy to fool the students here sometimes. After all, Azul was an expert in pretending not to hear someone slander his name.
—------------------------------
Christmastime was always extremely busy on the Night Raven College campus, and no day was busier than the early afternoon of Christmas Eve. Between dorm celebration preparations and the unfortunate students stuck studying for a final on the last possible day they could have one, the air was just as electrified as the lights strung up around campus as the sun neared its highest point in the sky.
Not that anyone in the Mostro Lounge had any time to leave their dorm and see the sun. As the premiere studying destination for students on crunch time, today was almost as busy as their Black Friday sale, back when Azul had given what he viewed as absurdly generous price cuts such as five dollars off of an appetizer.
The kitchen was buzzing with workers trying to get out orders to match the pace they were receiving them, and part of that process was the underappreciated work of the dishpit. At least, Ernesto thought they were underappreciated. Even with the overtime hours he managed to get working at the Mostro Lounge, he still had to pick up shifts at Sam’s shop to make ends meet.
“Jeez, what’s got you all frowny? I thought you’d be happy that we got a longer shift today.”
Ernesto’s newest partner in crime, Ruggie Buuchi, was passing washed plates to him to dry them off. Although the two hadn’t been coworkers for long, they had been getting along pretty well, and working the dishpit like a well oiled machine. And as for their small talk…well, game recognizes game, and griping about your boss would never go out of style.
“Yeah, it definitely helps…just not looking forward to the break. I mean, aren’t you gonna miss the revenue?”
Ruggie gave Ernesto a toothy grin.
“See, that’s where you and I differ, Honest-”
“Shhhh! It’s Ernesto now. Legally.”
Ernesto looked around to make sure no one had heard Ruggie before letting him continue.
“Right, right. Anyway, ‘Ernesto’, you aren’t part of a dorm where the Christmas party is funded by a literal prince~! The feast is good, but the leftovers are better.”
“Ughhh…lucky. You know, if anyone in Ramshackle had known in advance about the whole Christmas tradition stuff you guys do, we could have scorned up some gifts for the exchange…”
“Do you even know what types of gifts the dorms swap with each other tomorrow?”
“Uh…cash and checks?”
“Shehehe…I always forget that you’re only as knowledgeable as a freshie when it comes to how we operate here. You know how all of the dorms are always trying to one up each other in any way possible?”
“Yes, I-ohhhh. I see…”
“Bingo. The gifts the dorms give out to every other dorm have to be even more extravagant than their competition. That is the spirit of the season here at NRC. Last year, Scarabia literally gave out gold bars and rubies. Although I hear that Jamil put the kibosh on that this year.”
“Hmmm…thanks for the intel, Ruggie. Maybe I’ll see about working the Octavinelle Christmas party this year. I would have to miss the holiday, but it would all be worth it if I can-mpfgh?”
Ruggie slapped a moderately clean dish towel over Ernesto’s mouth as a certain half of Octavinelle’s infamously dynamic duo seemed to materialize behind them.
“Shark Sucker and Dreamfish~! What’cha talkin about?”
Floyd Leech leaned over Ruggie as he seemed to make himself comfortable at the loss of his coworkers’ personal space. Ernesto shot a confused look at Ruggie, as if to ask “Doesn’t he do most of the cooking? Why is he here?”. Ruggie seemed to get the confusion, returning his silent question with a shrug and speaking to the eel hovering above him.
“We were just talking about our plans for over the break.”
“That’s right! In fact, you have perfect timing, Floyd. I was just going to ask if you needed any assistance for Octavinelle’s Christmas part-mphh!”
Ernesto couldn’t hear it, but Floyd caught Ruggie mumble “Laugh with me” under his breath, and cast it on Ernesto. The pair both had a hand covering their mouths now, although Ernesto looked fairly confused, trying his best to tug at his rouge limb.
“Ohhh…fresh meat doesn’t know about how we operate here, huh. Thing is, Dreamfish, we don’t do the whole ‘Last day on campus and week before Christmas’ celebration here. No party. Ain’t that right!?”
Floyd turned to the guppies scurrying around in the kitchen, barking his question at them and receiving a dozen “Yes, Chef!”s in return. He grinned.
“Ahhhh…that’s always so funny.”
Floyd finally stood up to his full height, stretching and allowing Ruggie more room to breathe without being loomed over.
“I’m sure ya get the picture, yeah? Ruggie, keep the fresh meat in line…no more Christmas talk. Not good for the dishes.”
Despite his nonsensical words, the expression Floyd held on his face was more than enough persuasion for Ruggie to give a thumbs up-which Ernesto then unwillingly copied. Floyd seemed satisfied with this, and went back to his station to cook up a storm.
Ruggie let out a sigh of relief, releasing Ernesto from his hold.
“What the fu-n things…was that all about?”
“Real smooth there, pal. And it…look, you don’t wanna know. And you should know by now that probing too far into Octavinelle matters is an easy way to get zapped, squeezed, or disappeared.”
“Very funny.”
“Not joking.”
Ernesto looked at Ruggie with concern, but Ruggie was already back to washing dishes. He handed Ernesto a tray of clean utensils and plates and grabbed one of his own.
“Whaddya say we go reset some of the tables?”
“Get out of here before a certain someone has another mood swing? Yes please.”
As they walked out into the front and started resetting dirty tables, Ernesto tried to redirect their conversation.
“So, outside of…impossible things, do you know anywhere a guy can get some extra cash over the break? Like a part time gig or something?”
“Oh my, is one of our valued employees considering other lines of work?”
Ruggie and Ernesto’s tails both straightened up as they heard the distinctly polished tone of their employer.
“And during our busy winter season as well…whatever would we do to cover the gap he would leave…”
Ruggie grimaced as he mumbled to Ernesto.
“Double trouble. Play. Nice.”
The pair slowly pivoted to face Azul and Jade. The latter was currently holding a stack of library books that covered everything below his eyes, yet his suspiciously saccharine smile could still be felt through the pages.
“Boss-man, vice-boss-man, how’d your finals go?”
“They went well. What’s this about making extra income during the winter break?”
Azul smiled at Ruggie with all the warmth of an electric candle, instantly deflecting his attempt to redirect the conversation. Ernesto played as much charm as he could in his own expression before answering.
“Well…of course I don’t want to quit this wonderful job you gave me, Ashengrotto. I just was trying to see if there was some low level thing I could pick up over the break, since Mostro Lounge closes when the student body goes home. You can never work hard enough, you know…?”
Ernesto gave a somewhat forced laugh, which Azul thankfully added on to.
“Of course, I wouldn’t expect anything less from an…enterprising individual such as yourself! Well, as I am always trying to help my employees the way our beloved Sea Witch would help those around her, I suppose I could check with Crowly about any maintenance needed over the break. I’m sure I could convince him to work with me…”
“Really? That would be a lifesaver, honestly-”
“...so long as I receive a cut of the profits as well. Perhaps…50%?”
“Wh-but-...50%?! You can’t be serious!”
“I most certainly am, Ernesto. I doubt that he would offer a job such as this to just anyone without a recommendation, and I’m quite sure that he would not be interested in giving someone with your…”
Azul traced a hand around Jade’s eye, circling the spot where wood had once grown out from under his skin, a reminder of just how little bargaining room Ernesto had at NRC.
“...track record, an important task such as the campus’ maintenance over the break. This would be in both of our best interests.”
Ernesto gritted his teeth, fangs pressing into his lip.
“I…didn’t want to have to tell you this, but…Gidel isn’t doing so hot lately. He’s got some sorta sickness, and the cold weather is not helping…if I could get some extra money saved up, I could try and figure something out for him. I already can’t get the kid any Christmas gifts, and I won’t be there for him tomorrow morning as is, and I…I…uh…”
As Azul’s gaze turned icy enough to cause even Jade’s eyes to turn away at just the word “Christmas”, Ernesto quickly realized exactly who was responsible for the lack of holiday festivities in Octavinelle.
“Uh…by that, I just mean-”
“You’re truly pushing my generous spirit, Ernesto. Once again, I must remind you that I was almost down two excellent employees because of your antics, and yet I still employed you here in my own pride and joy. If you must find a cure for what I doubt is more than an exaggerated case of the common cold, perhaps you can implore Rollo to use his finely honed botany skills and grow you a basic cure. I will see you here, tomorrow morning, for your shift. Be grateful that I’m still keeping you on for it. Jade?”
Jade nodded at Azul, and the two made their exit into the dormitory’s housing area. As they did, Ruggie and Ernesto’s posture finally returned to normal. Ernesto seemed particularly deflated as he returned to working, his tail almost brushing in between his legs at one point. They worked in silence for another half hour before heading to the back. Ruggie was taking off for the day, while Ernesto was taking his unpaid lunch break. As they adjusted their hours on their timesheets, Ruggie finally spoke again.
“…for what it’s worth, good luck with Gidel.”
“Thanks…good luck with your pack back home.”
“…Thanks.”
With their attempts at merriments exchanged, Ruggie took off his apron and headed out to help with Savannaclaw’s final preparations.
—------------------------------
Azul considered himself a very fortunate student. Every other Housewarden was likely up right now, scurrying around their dorm in preparation for tomorrow’s activities. If not them, then their poor classmates. Meanwhile, he had spent his afternoon quietly studying, making a guide on this Skully student and his impact on Twisted Wonderland. He had to admire his drive, and his ability to show the world how to celebrate a holiday.
“If only everyone would understand how ridiculous this holiday is…then we would be getting somewhere. Humbug, all of it…”
Azul wasn’t quite sure if that word was in style nowadays, but he made a point of trying out new human words whenever he could.
Azul signed contentedly as he sunk into his pillows and blankets, putting a sleep mask over his eyes to simulate the darkness of the ocean he once spent every night in. He had always enjoyed letting the sounds of his dormitory lull him to sleep after a long day of work. They were the same ones he had enjoyed since childhood. The swoosh of the current, the way the kelp and seaweed would rub together, the sounds of chains clanking against each other…
Wait.
He shifted in bed, tossing to another side.
“Mmm…not quite right. Come on…almost showtime now…”
That's not right, is it? No, he was certainly hearing the sounds of chains being dragged along something. And…a voice, as well. He shut his eyes tighter still. This had to be a dream, so no use in opening them, yes.
“Ahh. There we go, put this one over on this side and-WOAH-”
The sound of more chains falling onto the ground, and a loud thud. Azul shot up in bed, grabbing his magical pen from underneath his pillow and pointing it at the darkness.
“Who’s there?”
Silence. Azul narrowed his eyes, longing for the limbs he would use underwater to see into the darkness ahead of him. He had dealt with some students attempting to steal his valuables in the dead of night, but never someone entering his personal quarters like this.
“I heard you before. I know that you’re here…”
Getting no response once again, Azul cast a spell to illuminate his room and locate the intruder. The visage he saw startled him into dropping his pen, leaving the room just lit enough for him to see an extremely tall, lanky man grinning ghoulishly at him. The man wore an outfit that lacked color, and shades that covered his eyes completely. If Azul squinted, he almost thought that he could see through him. What's more, he was covered in rows of chains that seemed to bind him to the floor…specifically, one of the books Jade had obtained for Azul that evening. Azul looked at the ghost once more and sat up straighter, his eyes widening.
“You…this can’t be possible…”
The ghost sighed, pinching his forehead.
“No, no, that’s not right. Close your eyes, we’re doing this again. I need to strike fear into you.”
“You’re doing an excellent job of that, I can assure you.”
“You don’t get it! This is hardly the type of introduction a story like this deserves…do you at least recognize me?”
“I certainly do…you…you are Skully, aren’t you? The student from our lesson today?”
Skully seemed to brighten at the recognition, slowly moving over to Azul’s bedside and bowing to him.
“What a sharp mind, as always! I would kiss your hand, if not for these chains holding me down.”
“I would truly prefer that you not do that. Are you perhaps lost? This isn’t Ramshackle, you know.”
Skully’s laugh was that of bones clattering together cheerily. It sent a shiver up Azul’s spine.
“Of course I know where Ramshackle is! Not that I could go there…nor do I want to, at least, not tonight! Tonight…”
He leaned forward, body and chains towering over Azul.
“Tonight, I’m here for you, Azul~!”
Azul did his best to maintain his composure, locking eyes with Skully as his glasses slipped down, revealing reddish orange pupils.
“I am here to save you, Azul! For I was once like you, set in my ways about how to celebrate the spirit of a holiday. So set in my ways, that I ended up hurting some dear friends of mine. These chains, Azul, they are the manifestation of those that I hurt in my callousness. Each link, a regret that I hold.”
Azul looked at the chains again, processing Skully’s words. It was then that he noticed an all too familiar substance coating the chains, dripping black ink down onto the floor. His heart stopped for a moment.
“What…is that?”
Skully’s demeanor stiffened a touch as he rubbed some of the blot between his fingers.
“I think you know exactly what this is. And I know that you’re smart enough to put two and two together.”
For once, Azul did not have any protest or accusation for his ghostly visitor. The air was still…until Skully seemed to snap back into a more lightheated tone.
“I also know that you do not hold the spirit of christmas in your heart, Azul! In fact, your heart is two sizes too sm-no. Wait. I have this mixed up. One moment!”
Skully laughed nervously, turning his back to Azul (who was currently double checking his heartbeats) and summoning a book. He frantically flipped through its pages, searching for something, although Azul could not tell what it was that he was looking for.
“Come on…oh, I hope Jack isn’t watching this right now…embarrassing…”
Azul tried to focus on seeing through Skully’s body in order to see what he was reading. He could almost make out the words on the back cover.
“Does that say…Christmas Storybook Collection-”
“NO IT DOESN’T-”
Skully snapped the book closed as it poofed away into the air.
“Ignore that. Don’t worry about it. You should be more worried about the spirits that are going to visit you tonight, after all.”
Azul was about to inquire about the book again, but stopped once Skully mentioned the prospect of even more unwelcome visitors.
“More spirits? What is the reason for this pestering? Did someone curse me?”
“I prefer to call it haunting. And of course not! This is a gift, Azul. Without…what was the phrase..ah, yes!”
Skully leaned closer again, his voice gaining an eerie tremble.
“Without their visits, you cannot hope to shun the path I tread!”
Azul scoffed.
“This is nonsense. Why would my lack of festive spirit doom me to a fate such as yours?”
“That’s a spoiler. I can’t tell you that yet! Just know that you must expect the first visitor when the clock chimes one…one…one…one…..”
As Skully’s body faded out of vision, his voice faded into an echo.
Azul huffed, readjusting his sleepwear and lying back down.
“Ghosts…festive spirit…humbug…”
He heard a highly pitched squeal, similar to that of Idia’s when he would watch his favorite idol group during their club meetings.
“He really is a prototypical Scrooge! I can’t believe I get to “A Christmas Carol” someone…! Oh, Jack would be so proud of me…so Christmassy for him, but so dark, gothic, and somber for me, what a beautifully dreary-”
Azul cleared his throat.
“I can still hear you. That makes it rather hard to fall back asleep.”
“Oh! I’ll be quiet then. Just remember…when the clock strikes oneeeeee…….”
Azul groaned in annoyance.
“Hu-mmm….”
He wanted to say humbug, but he stopped after the first syllable. The day had already been tiring, and this ghostly visitor only increased his exhaustion. He felt himself sink into what should have been a pleasant slumber, but a smile did not grace his face for even a moment.
#twisted wonderland#azul ashengrotto#twst#christmas carol#a twstmas carol#skully j graves#I hope my one skully mutual approves of this or I will be embarrassed#I also hope my muppet Christmas carol sibling approves of this#floyd leech#jade leech#fellow honest#ernesto foulworth
18 notes
·
View notes
Note
If a Time Lord went deep-sea diving, would it be possible for them to use their respiratory bypass system to prevent (or at least lessen the effects of) nitrogen narcosis and decompression sickness?
Can Time Lords prevent deep sea diving conditions?
If I had a penny for every question about deep-sea diving I'd had, I'd have, well, none, so thank you for this truly original query 😃
🌊 Understanding the Risks
To answer this question, we first need to understand what makes deep-sea diving dangerous:
1️⃣ Narcosis: At great depths, increased pressure causes inert gases (primarily nitrogen) in the air mixture to dissolve into the bloodstream and tissues at much higher levels than on the surface. This happens due to Henry's Law, which states that gas solubility increases with pressure. When too much nitrogen saturates the nervous system, it impairs brain function, causing symptoms like confusion, euphoria, and hallucinations—aka, "the rapture of the deep."
2️⃣ Decompression Sickness (DCS): During ascent, as pressure decreases, dissolved gases come out of solution. If the ascent is too rapid, nitrogen forms bubbles in the blood and tissues. These bubbles block blood flow, damage tissues, and can cause joint pain, paralysis, or even death.
🫁 Gallifreyan Biology vs. Deep-Sea Hazards
Gallifreyan biology gives them an edge in extreme conditions, and it's not all about the respiratory bypass.
1️⃣ Advanced Oxygen Regulation
A Gallifreyan's independent pulmonary network separates oxygen delivery from their circulatory systems. This could theoretically reduce nitrogen uptake into the bloodstream, as their respiratory efficiency might decrease the volume of dissolved gases under pressure.
Their ability to suppress metabolism voluntarily means they can slow gas absorption further, providing a natural buffer against narcosis and DCS. However, this is only a delay tactic—it doesn't eliminate the problem entirely.
2️⃣ The Role of the Kaizegea
The kaizegea (a GIL concept as an organ for filtration, likely to be renamed soon) acts as a highly sophisticated filter, rerouting gases based on their utility. While this would slow nitrogen saturation, its limitations are obvious:
No Escape Hatch: Underwater, the body cannot expel excess nitrogen or other inert gases. If nitrogen accumulates, it becomes a ticking time bomb, waiting to cause trouble during ascent.
Overload Risks: Even with advanced filtering, extreme pressures would eventually overwhelm the kaizegea's capacity, allowing nitrogen to infiltrate tissues.
3️⃣ Respiratory Bypass
The respiratory bypass allows Time Lords to halt gas intake entirely, conserving internal oxygen and reducing exposure to additional nitrogen. However, this technique is time-limited (12–20 minutes during exertion) and doesn't address gases already absorbed into tissues.
4️⃣ Adaptability of the Pulmonary Network
Gallifreyan carrier cells can reprocess CO₂ into oxygen, providing a temporary salvation in low-oxygen environments. Unfortunately, this doesn't mitigate the physical effects of dissolved gases under high pressure.
⚠️ What a Gallifreyan Can and Can't Do
So despite their biology, Gallifreyans cannot escape the fundamental rules of physics:
Narcosis: Gallifreyan neural plasticity and psionic control might delay the onset of the symptoms of narcosis, but the sheer volume of dissolved gases at extreme depths would still impair their judgment and motor functions.
Decompression Sickness: The respiratory bypass and kaizegea can slow gas absorption and allow better degassing, but any inability to expel excess nitrogen underwater creates a high-risk scenario. A rapid ascent would trigger bubble formation, potentially causing severe DCS.
Buoyancy Control: Time Lords can consciously regulate oxygen levels in their bodies, giving them excellent buoyancy control. This could reduce exertion and assist with a controlled ascent. However, this ability doesn't counteract the need for proper decompression practices.
🏫 So ...
While Gallifreyan biology offers plenty of tools to manage the risks of deep-sea diving, they're not immune to the laws of physics. The kaizegea and respiratory bypass can delay problems but can't eliminate them, especially if nitrogen accumulates over time. In fact, their advanced systems might create new risks, like a build-up of inert gases that could exacerbate narcosis or DCS.
Controlled ascents, decompression stops, and proper dive planning are still essential. And hey, if anyone could make a wetsuit look great, it's probably a Gallifreyan.
Related:
💬|🫁😮💨How do Oxygen levels affect Time Lords?: The effects of different oxygen levels on Time Lords and their respiratory resilience.
🤔|🫁😶🌫️Is there a gas Gallifreyans are particularly sensitive to?
💬|🫁🏊Can Gallifreyans drown?: Limitations of the respiratory bypass.
Hope that helped! 😃
Any orange text is educated guesswork or theoretical. More content ... →📫Got a question? | 📚Complete list of Q+A and factoids →📢Announcements |🩻Biology |🗨️Language |🕰️Throwbacks |🤓Facts → Features:⭐Guest Posts | 🍜Chomp Chomp with Myishu →🫀Gallifreyan Anatomy and Physiology Guide (pending) →⚕️Gallifreyan Emergency Medicine Guides →📝Source list (WIP) →📜Masterpost If you're finding your happy place in this part of the internet, feel free to buy a coffee to help keep our exhausted human conscious. She works full-time in medicine and is so very tired 😴
#GIL#gallifrey institute for learning#dr who#dw eu#ask answered#whoniverse#doctor who#GIL: Asks#GIL: Species/Gallifreyans#GIL: Biology#GIL: Biology/Respiratory#GIL: Biology/Medical#gallifreyan biology#time lord biology
14 notes
·
View notes
Text
a Problem I Invented For Enrichment was bothering me so much at work i decided to open excel at home and figure it out
when im outputting from excel to a mail merge, it discounts the formatting on currency cells (so it gets rid of the £ sign and any commas), so i needed a way to add those in that doesn't involve me doing it manually to every number bc im lazyyy
introducing the humble character count-sensitive parser, it works on any number from 1 to 9 digits and adds the currency sign and commas in in a way that will output to a mail merge
#dibi#i love excel it's fun#ignore the word 'salary' in there all this is very arbitrary#i didnt even need to do the 'check if its under 4 or over 6 digits' part#i only needed this to work in the thousands never the hundreds or the millions#but the thing was i started thinking#what if one day i DO need that (unlikely)#so i made it account for number length and add the right number of commas.#for funsies :3
7 notes
·
View notes
Text
OK. some quick cardassian speculative biology headcanon thoughts before i go to bed. i might incorporate this stuff into a more formal well formated thing later but rn i'm just spewing some thoughts
cardassians are not poikilotherms (as in earth reptiles) - they're endotherms (more specifically fitting into the baseoendotherm category imo, see this paper for more info on that term). their average healthy body temperature is ~34-35°C, so a little cooler than humans, but still warm.
cardassians are able to enter a state of torpor under high stress or in very cold or hot conditions, in which their body temperature can drop as low as 20°C and their bmr (basal metabolic rate) is significantly reduced. however, entering this state is often a last resort, as it's quite dangerous and can become a precursor to death if the stressful environmental conditions aren't ameliorated.
cardassians do not like the cold, and will enter a state of cold induced torpor in temperatures which are relatively survivable for a human being. even when it isn't cold enough to threaten their health, a cardassian can become drowsy and uncomfortable in cooler temperatures. they tend to find temperatures of 25°C and above the most comfortable.
they have dichromatic vision, which corresponds to red-green colour blindness in humans. however, despite having less cone cells, their eyes have far more rod cells than a human being, giving them excellent night vision. this is aided by the presence of a tapetum lucidum (which has the added bonus of looking super creepy in a dark room).
the forehead ridge or "chufa" (i've heard this term was coined in a particular cardassian speculative biology fic but i have yet to find it, please lmk if you have a link!) is actually a pineal eye. like most (extant earth animal) pineal eyes, it is covered with skin and has little purpose other than differentiating between light and shadow. most cardassians are not consciously aware of perception from this eye, but may subconsciously change their behaviour based on its input (i.e., a cardassian with their chufa covered may end up feeling fatigued, as light detection from the chufa helps them to maintain their circadian rhythm and if light isn't falling on it, their body will produce more sleep hormones). a sleeping cardassian can quickly be woken by a change in ambient light, as their chufa never "closes", and so can detect light changes even when they're asleep.
cardassians are more light sensitive than humans. their natural circadian rhythm is more crepuscular than diurnal, and so they are most alert and active at dawn/dusk or in lower light levels.
cardassians have both "scales" and hair, much like an armadillo. the scales function as armor plating, with the most armor on the sides and back of the neck, and over the spine, although it is present to some degree over the whole body.
they have to shed in order to grow, and adults continue to shed their scales, albeit at a lower frequency. shedding happens once every few months in children and juveniles, and once ever 1-3 years in adults. shedding lasts about 2 weeks. it is seen as a time of vulnerability, as it generally leads to a decrease in energy, among other symptoms, and a freshly shed cardassian's armor is soft and easy to pierce. for that reason, adult cardassians will often disguise the signs of shedding (i.e., paling of the scales is compensated for through applying makeup etc), and usually become reclusive and defensive once it can no longer be disguised.
cardassians naturally have a range of pigmentation in the chufa and neck ridges, ranging from grey to bright blue. these areas contain simple chromatophores, and in all cardassians they tend to "flush" blue when they're excited or experiencing intense emotions. however, their "neutral" colour can differ greatly from individual to individual. some cardassians use makeup to enhance the colours (think blush or lipstick in humans), as a more vivid blue is sometimes seen as attractive. the coloration is not sexually dimorphic.
cardassians do not have a corpus callosum between their brain hemispheres, instead they have multiple commissures. i might think more abt this one and the potential effects on cognition later but rn i just think it's cool and wanted to include a mention of it at least
ok that is all i have for now lol i'm getting sleepy........ as i said earlier, i may add to this post if i get more ideas, and maybe one day present this stuff in a better format
82 notes
·
View notes