#conditional Formatting
Explore tagged Tumblr posts
Text
Simple Shit
Hey, ever have your spreadsheet looking like this?
Wanna hide them zeros??? Would you usually just set conditional formatting to turn the text white if the cell=0? Okay cool but you know weirdly printers like to print those 0 even if they're white so it looks a bit shitty when you print it off, and what if you want to make it pretty (get your shit together and format like this for accesibility and easy reading) like...
Then what? Make separate cond format for each other row? NO FUCK THAT. TRY THIS.
Go to "Custom" in the number formatting and type in the box ";;;" (that's three semi-colons).
And it will hide any text in the cell if it meets the right requirements.
❤ ~~ three semicolons my beloved ~~ ❤
BOOM. GOodbye ugly zeros.
YOU GOT THIS :: Follow for more !!
#spreadsheets#fuck yeah spreadsheets#microsoft excel#excel#spreadsheet tips#conditional formatting#easy to read formatting#accessible formatting#making sheets more usable#easy read#formatting like a pro
4 notes
·
View notes
Text
having fun with conditional formatting
1 note
·
View note
Text
Jdkdkdkd
You and @mazegays know me too well XD

look, it's very straightforward. i keep an Excel spreadsheet open on my second monitor, and whenever i see a Contentious Poast making the rounds, i use it to carefully document which of my mutuals reblogged a version of it with Correct Commentary and which ones reblogged a version with Incorrect Conmentary. this either adds to or subtracts from a running total, with the magnitude of the change based on the importance/annoyingness of the post in question. whenever two of my mutuals are in ideological conflict, i use their respective running totals as Elo scores, with the winner of the discourse (i.e. the one i agree with) taking points from the loser. the mutuals at the top of this spreadsheet by the end of the month will be buried with me in my tomb next to my jewels and finery, while the ones at the bottom will be sent out of the Vault's airlock one at a time in an attempt to sate the hunger of the nanomachine clouds. now help me lift this insect corpse, i think i see something salvageable under it
#AGGRESSIVE COLOR CODING#every excel formula under the sun!#conditional formatting#I would go crazy with this shit#alas ... not enough discourse on my dash
8K notes
·
View notes
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
Falmer appearance and attire headcanons
(click on drawings for more details and notes!)
Hair
In Skyrim, we pretty much only see two hair styles to go off of: completely bald and the hair the "shaman" have (which are also the only females we see (a post for another day)).
In concept art, particularly Adam Adamowicz's, we see more potential hairstyles. He draws it as wispy and messy, as well as containing braids and the ties we see in the shaman in the game. This art is largely what defines my own interpretation of their hair.

I picture the typical Falmer hair as wavy, thin, wispy, and looking frizzy. Given the high number of hairless Falmer we see, I imagine baldness is common, particularly among males, and sometimes among females. Their hair can be commonly styled into braids or knots to keep it under control.
The ability to grow long, thick hair is less common, but those who can tend to style it in other unique ways. Especially among females, long hair is commonly styled into large dense locs (akin to a Polish plait) and held into shapes using ropes or leather ties.
(While I think the intention with the way their hair is drawn and modelled in the game models and concept art was that it was braided and held up with those ties, before looking at it closely I always sorta interpreted it as too stiff to just be braided. As a result, I developed the locs headcanon and have become kinda attached to it even though I have 0 in game or lore support for it)
Materials
The material used in their clothing is obviously dependent on what is accessible to them, and given their unique situation that makes the materials they use and value unique as well. In Skyrim, we see that almost all of their armor (which is mostly what we see them wearing) and homes are made of chaurus chitin (and potentially shellbug chitin), so this is likely the most common resource available to them for non-combative coverings as well. Other materials from their arthropods companions could include their cocoons, unhatched eggs, etc.
Bones from other creatures (draugr, skeevers, trolls, adventurers, bandits, etc.) underground or from aboveground raids could also be used fairly often. These could also provide a source of leather or fur, albeit not a lot of it.
Falmer groups and subcultures inside or in close proximity to Dwemer ruins probably make regular use of the materials present in those ruins as well. With all the metal and machinery present in Dwemer ruins, metal probably makes regular appearances in their clothing (and general decorations) even if they can't manipulate it themselves. Falmer more separated from Dwemer ruins would make much lesser use of these materials, however. Additionally, We see implications of Falmer preparing, cooking, and potentially cultivating fungus in-game, but see nothing indicating they have any plants in their diet, and therefore it is unlikely they regularly make or use textiles or fabrics in their clothing, and if they do they likely come form Dwemer ruins or raided adventurers/bandits/settlements from the surface.
On that note, we know that there have supposedly been incidents of Falmer coming to the surface to attack its inhabitants and travelers, as well as instances of them killing bandits, adventurers, and researchers who venture below, so it's not far fetched to believe that they have access to some materials from the surface. This could give them some access to furs from surface animals, beads, glass, jewelry, textiles, metal objects, etc. they might not otherwise have access to. The rarity of these material among the Falmer would depend on the amount of access any given group of Falmer have to the surface, but among many of them these materials could be seen as more valuable for their rarity and the difficulty to gain them.
While gemstones and ore might be accessible from both natural deposits and underground ruins, unless they had some kind of auditory function or unique texture, they might not have much value to Falmer.
General Attire/Accessories
I like to imagine that the Snow Elves, and by extension the Falmer, have an innate cold resistance in the same way Nords do, and therefore don't require clothes for the purpose of warmth even in the chilly caves of Skyrim. Additionally, their blindness likely means that wouldn't dress for visual aesthetic either. My thoughts are that they are then left with the sense of sound and touch to communicate with each other, and their clothing and accessories could reflect that.
Falmer clothing, decoration, and society in general is very heavily based on touch and texture and little on appearances. They touch each other very often for both communication, movement, and just general day-to-day interactions, and their clothes isn’t very modest, but the tactile patterns and materials used can communicate certain things such as position in society, “wealth”/power, whether they are taken, single, pregnant, with a child, etc., their roles, their age, notable achievements/skills, who is who, etc. on both their clothes and buildings. The more noise one makes, the more attention they draw and the more they drown out other noises, and the more noise making things they can “afford” to have, so the amount of noise one makes in a Falmer settlement is a status symbol. Certain types of noises or noise makers are more coveted than others (chitin beads are common, while furs are less common, and materials only gained from raiding the surface are rare and coveted).
Some noise making accessories could include:
Dangling metal, bones, beads, chitin, etc. that hangs off of their clothing or ears and jingle/clank against each other (in my drawing I show them as pretty uniform in shape and size, but they would probably be much more irregular than I depicted them)
Bells (metal or other materials) that are affixed to or dangle off of their clothing or as earrings.
Hollow bracelets, anklets, necklaces, or other accessories that are filled with rocks or beads.
Rattles tied to the body (made of chitin, dried hollow chaurus eggs, dried chaurus cocoons, beads, etc.) with leather or rope.
Flute or whistle like tubes made of metal, chitin, or dried and treated tube-like fungus that makes a woodwind-esque noise when air passes through it in a certain way. They have been designed to make noise easily from even the slightest movements.
Dried grasses (more temporary) tied to the body that make a swishy noise. More permanently, a similar thing can be achieved with hair. The hair can be sourced from Falmer (either through just cutting hair or through taking it from fallen enemies) or killed humans/mer/draugr. That sort of thing can also act as a kind of trophy.
Necklaces with various materials dangling close together that jingle against each other.
Various materials can be tied into braids or the leather ties in their hair as well.
Some textural accessories could include:
Beads. Since they wouldn't have the ability to tell the color of the beads, the patterning of beadwork would be based on the roughness, material, size, or shape of the beads. (I'm sorry I suck as drawing beads)
Furs. This wouldn't be as common since the Falmer likely don't have too much interaction with furry mammals, but some they may have access to that are big enough to make clothing/accessories out of include skeevers or trolls (and potentially rarely animals from the surface). A potential meaning of wearing furs could be as hunting trophies, but it could have other meanings as well.
Chaurus chitin would like be the most common material in Falmer attire, and depending on the part of the chaurus body, the size of the chaurus, or the life stage of the chaurus it was sourced from it could have different textures. Some chitin parts could include large spikes and deep groves, while other parts could be smoother and less rough. The use of this chitin in clothing could take advantage of this contrast in textures. Additionally, chitin or shells from shell bugs might be a different texture from the chaurus chitin. (it's unclear to me whether shell bugs are exclusive to the caves around the Forgotten Vale or if we should consider them distributed throughout Skyrim's underground)
The placement of textured components on the body could have their own meaning to it alongside what accessories or textures are being used.
Specific Falmer Subcultures
While most Falmer settlements we see in Skyrim are just a small-ish collection of huts and chaurus corrals, there are two distinctive settlements that are larger, seemingly more organized, and I like to think have their own distinct subcultures worth mentioning: Blackreach and the Forgotten Vale. The unique scope and environment of these Falmer cities (as I like to think of them) could lend to unique clothing cultures as well.
The Falmer of Blackreach have access to a vast Dwemer settlement and have has the space to spread out throughout it more fully since it seems to be more in tact than other Dwemer ruins we see. These guys would likely have a clothing culture much more heavily based on what the can access from these Dwemer ruins (metal scraps, leftover fabrics, etc.)
The Falmer of the Forgotten Vale would also have access to unique resources, such as Vale deer, Vale sabre cats, and frost giants for fur and leather. Additionally, materials accessed from the Chantry of Auri-El such as textiles from clothing, bedding, tapestries, etc. could give them a greater access to fabrics than other Falmer groups. We don't see many close Dwemer settlements to the Vale, so they would have less Dwemeri influence in their clothing than other Falmer groups.
I like to think that the Falmer's evolution exclusively underground has made them poorly equipped to handle the outdoors during the day and has made them particularly susceptible to sunburn, necessitating the need for covering for those in the Forgotten Vale who have significant settlements outdoors. With greater access to textiles and leather, they could use them as coverings when outdoors.
Armor
I actually have very few notes on armor, for two reasons. 1) I hate designing and drawing armor. It is the bane of my existence. 2) I really like the armor they have in game! I think they look awesome aesthetically, and I like how clearly they are made from chaurus chitin. Per usual, Adam Adamowicz's designs seem to have been the major inspiration for the Falmer armor, and he did a great jobs (even if it isn't the most functional looking armor ever).


(off topic but I also just want to add that he draws them with little hairs and tufts on their ears and I love it. ok that is all)
I do have a few thoughts about armor though.
Even attire made of textiles make noise when someone moves in them, and I can imagine moving around in armor, especially armor made of hard, insect shells would make a lot of noise when someone moves around in it. When you're relying on sound to navigate your environment and pinpoint potential threats or targets, wearing something making a lot of noise would not be ideal. On the other hand, getting into a fight unarmored would be a problem.
So here's my solution: heavy armor (see below) would only be worm within the camps/settlements where noise was already high and space is more cramped (and therefore more risky in a fight) as a sort of guard in case they were attacked. Those guarding the settlements along the outside might still wear armor as well, but less of it. Those going out to scout or hunt (if they do hunt) would wear as little armor as possible, and try to wear it strategically so that it wouldn't rub against itself and make noise. This is why most Falmer we encounter in the game are wearing little except for loin cloths and kneepads.
One more idea I have for armor is a specific armor piece. On the note of guarding or protecting a camp or settlement, I imagine the noises of it all (especially with the noise based headcanons I've laid out here) would make it hard to actually catch any potential threats when you can't see. A large slightly concave piece of armor worn behind the head could block out noises from behind the wearer, as well as a help focus sounds ahead of them.
That is all! Thank you for reading! A lot of these concepts around the culture of sound I think could also be applied to their buildings and even a culture of music, but those are posts for another time.
All of the concept art I used was taken from here and all of the Skyrim screenshots are from UESP.
#skyrim#tes#the elder scrolls#falmer#skyrim headcanon#tes headcanons#headcanon#sorry this is long (but not really)#i just cant express my thoughts like a normal person. college conditioned me to format everything like an essay where i have to provide#sources and shit lol#also im kinda autistic about falmer#i appreciate those of you who read it all!#mine#adam's concept art makes me feel very validated in my echolocation headcanon because its very obvious he references bats in their face#which is another post idea i have for another day#my art
1K notes
·
View notes
Text
(current wc total: 615,812) Word count breakdown so far for this project! Locations are still in-progress, and some of the main quests were transcribed before I knew how to access the files (thus the out-of-order list) so they may still be missing content.
#dragon age inquisition#just idle chatter#for the curious#bearing in mind that i have a few repeat scenes that varied too much based on certain conditions so i just made a whole new post for them#between veilguard transcript posts i've been trying to edit some of the older stuff to start my re-formatting endeavors#joh has been transcribed by another blog but i might try to organize them into a masterpost here (with their links) for ease-of-access#and i'm currently still waffling on companion banter since they're all already on the wiki#you know#becuase i didn't already fill my plate and three more plates with the other games lol#long post#ish#mostly just big images
52 notes
·
View notes
Text
Seeing Venus 'for reference' in the list of possibly habitable exoplanets is so humbling. It's a reminder that "yes, this planet might be an analogue of Earth, or Literal Hell, so don't get too excited just yet"
#cosas mias#astronomy#astrobiology#I've read in Rare Earth and elsewhere that the conditions near a star during formation are highly variable#that's why our inner planets are so different from each other#there must be WILDLY different kinds of planets out there and I can't wait when we truly start to see them#space#the notes are also fun 'this planet might not exist actually'
86 notes
·
View notes
Text
Yeah sex is good, but have you ever gotten all the formulas in your spreadsheet set up just right?
17 notes
·
View notes
Text
yesterday i was asking my dad (a guy who is also a ~spreadsheets 4 lyfe~ type of guy, i come by it honestly) about some specific equation types because i couldn't find where i'd used it previously and i couldn't remember what it was called enough to look it up. and he didn't know what tf i was talking about. he just recommended using data sort. and so i had to dig out my old flight rising fodder boarding manager document and figure out tf the equations were (it was just nested countifs) and when i showed him he was like. i have never heard of that. cool.
28 notes
·
View notes
Text
hey congrats to the two spots of eczema on my arm for finally touching. go fuck yourselves. self. whagever
#they can’t take away my health insurance if i didn’t have any :P#atopic dermatitis#eczema#skin condition#girls with rashes#<- i just think the ‘girls with’ format is funny#pizzacrustdisposal
17 notes
·
View notes
Text
every single day, ppl with zero f1 knowledge decide to post the stupidest think pieces you'll ever see, tagging it with the entire grid and making it everyone else's problem...
#'a driver doesn't just spin on a formation lap like that unless the conditions are dangerous...'#imma hold your hand when i say this......
12 notes
·
View notes
Text
So Chaos Dad woke up and chose violence.
#is it all part of a fuckery?#is it a dream sequence?#having a real hard time with izzy being described as someone who loved ed ‘unconditionally’ where there were clearly SO MANY conditions#the fucking disc horse#everything a goddam ordeal in area fandom#ofmd#the david jenkins bluesky xmas special#i don’t have the kind of emotional stability necessary for this format of storytelling#going back to my re-read of constellationism now
7 notes
·
View notes
Text
Since a lot of daring-for-not-being-dead-yet fuckers have been saying a lot of ableist shit I (relatively) recently made these and I don’t take criticism.
Upset? Take a check to the neck!!



















Anyway and also I love how Fyodor's squad is just made up of white haired otherkins he's so real for that



#someone give me the origins/creators etc of these flags NOW#noelle's rambles#bsd#bsd hcs#neurodivergent hc#disability hc#otherkin hc#from top to bottom#mori and nikolai with HPD#Ranpo with PPD and NPD#Kunikida with OCPD#Lovecraft with narcolepsy#Lucy and Mori with MADD#Chuuya and Mori with depersonalization and derealization#Dazai and Fyodor with OSDD#fyodor with psychosis#Mori and Nathaniel with Dissociative Amnesia#Ivan with AVPD and DPD#i think i may have mixed up the flags here while attempting formatting idk#Sigma and Nikolai with borderline and bipolar#last ones already said#also I'm not tagging all the characters and conditions I'm too tired for this shit someone else do it#happy pride#liberation has no limitation#also no i don't think being otherkin is a disability or an innate result of being neurodivergent btw I just put a lot of stuff in at once#-from someone who is all 3 those things
3 notes
·
View notes
Text
Things you can do in Blood on the Clocktower but probably shouldn’t number 177:
As the Philosopher, choose to gain the Atheist ability
#Blood on the Clocktower#Credit to OwlphaAce for the format#Less obvious as a joke but either 1. You make the Atheist drunk temporarily and nothing changes#Or 2. You give Good an extra win condition but without Mayor protection* and also let the Storyteller break the rules from now on.#They *shouldn't* really break rules if it was not an Atheist starting game but they're now allowed to#*Atheist ability still functions when you die but the Philosopher's does not.
3 notes
·
View notes
Text
When you are going round in circles trying to write a conversation…

This is probably not the behaviour of a competent writer but err… when all else fails, Excel it?
#writing block#excel#I could assign each item a priority value and a tone value#and do some conditional formatting…#I’m such a nerd
12 notes
·
View notes
Text
received one too many unsolicited opinions from people who bought their houses in the celtic tiger era with 150% mortgages and have never known a bidding war. blacked out with the rage. came to panting, sweating, and with a spreadsheet that i have now convinced myself is my key to predicting ireland's housing """market"""
#the results? it's p bad out there im not gonna lie#but i will data analysis my way outta this or die trying#tbf tho my conditional formatting is beautiful if nothing else#SOMEONE SELL ME A FUCKING HOUSE IM LOSING MY MIND
5 notes
·
View notes