#mod a10

[mcytblrsource]

If I wanted to start a zine, how would I go about doing so?

Hi! Thank you for giving me the opportunity to infodump about zines, this might get a little long ;) There are many different ways to make a zine, but the way we often see in fandom right now follows this structure:

Interest check: Explain what your zine is about, have people hear about it, and collect information on the kind of things people would want to see or make in your zine (usually through a google form, but it can also be a tumblr poll or anything else like that)

Mod Applications: Assemble your team! Social media mod, formatting mod, art/writing mod, etc. This is usually done through a google form. Honestly, when selecting your mods, having people you *trust* is what's most important. So while having someone with experience is good, have people you know you can rely on, like your friends, even if they don't have previous experience.

Contributor Applications: Also done through a google form; get people who want to create through the zine to submit examples of their work so you can choose which ones get in the zine.

Creation Period: All the contributors you selected make their pieces! And then you, or the person in charge, assemble everything together.

Release: If you publish the zine online for free, you can have the pdf available to download on itch.io. If you want to print it and sell it, that's a whole different subject that I'm not very knowledgeable about tbh.

The most important part when your zine is starting out is to get the word out there! Make a tumblr blog specifically for the zine, make lots of posts reminding people of when the interest check/mod applications/contributor applications are opening or closing, when you have contributors make posts to introduce them, etc. I find that having visuals accompanying your posts helps a lot, especially if you have a strong visual identity already, it helps people remember your zine. You can also invite guest contributors; people who you invite into the zine as opposed to having them apply (usually creators you like), so they can help share contributors applications.

I also have a lot to say about things to watch out for when making the zine, mostly time management and participant wrangling, but this is supposed to answer the question "how to get started" so I don't want it to get too long lmao. Just make sure to give yourself enough time to do things like looking through form answers or setting up things. Deadlines are great to keep things moving but remember they are self imposed, so don't make it impossible for yourself!

In terms of resources to help you out, I can redirect you towards the Hermit-a-day streamathon panel both mods of this blog were on to discuss everything that goes into making a zine. I know that on the Artbook to Zinethologies streamathon they discussed zine-making, although since I haven't watched it I don't know into how much detail they go.

And don't be afraid to reach out to other zine mods! We're usually more than happy to chat and give advice (case in point here), sometimes even get roped into modding another zine ;) Beware, it becomes an addiction.

HOWEVER with all that said there are many different ways to run a zine!! You can decide to keep it smaller scale and exclusive to friends or people you know, you can skip the applications and have it open to everyone, have people just send in finished pieces, ... the world is your oyster, really. I recommend to go check out @mcyt-flashzine, which helps people run their own mini-zines!

I hope all this all helps, and good luck on your zine making journey! Make sure to tag us in your posts ;)

[morningstarzine]

I’m curious, I know about Aimsey but why are Lizzie and Pearl featured in the Zine?

This zine is about any creators who are in the minority in the cis-male dominated space that is MCYT. That includes women, non-binary people, gender non-conforming people, and transgender people of any identity. For more information, you can read our FAQ here.

[hermitadaymay]

Good morning! As we've passed into our eighth day of the month, I wanted to take a moment to thank our fundraiser's donors so far! We've almost reached $500 raised and I know we can do so much more.

Thank you to Marii, lackyducks, fledge, Aceofthefandoms, dot-moth, JoJoNAloha, RainbowRam042, Psina, a10, vi, stoatunquote, Ari, nic, Crow, Skellybirdie, Chay, elki, Mysteriouswolf, Etho's mousepad, Grimaussiewitch, solidaritytek, Pookapufferfish, and 3 anonymous donors for your generosity over the last week!

As you know, we're raising money for the Hermits' favorite charity, Gamers Outreach, which puts mobile, sanitizable gaming kiosks called "GO karts" into children's hospitals around the world so that kids can have a mental break from the pain and monotony they're experiencing. It gives them something normal to do, an experience they can share with their friends and family - and, as I learned when I volunteered at GO's Gamers for Giving event, medical staff in some places have even started "borrowing" the karts while the kids are asleep for some decompression of their own!

You can pitch in to our fundraiser here - you have less than 4 days remaining to get as your incentive a ficlet commission by Leopardmask! And you can enter a raffle for as little as $1 - though I gotta say, some of those raffles are getting pretty competitive!

And now back to your regularly-scheduled amazing Hypno fanworks!

-Mod Luna

[clownartmonth]

CLOWNBLR 2023 GIFT EXCHANGE SIGNUPS & RULES

Clown month 2024 is still a ways away, so in the meantime, let's have some fun! Here is the Clownblr Gift Exchange 2023!

Before signing up, read all the info & rules under the cut carefully, and if you still have unanswered questions, you can send me an ask or a dm.

Signups are open until November 25th!

> SIGNUPS HERE <

> CLOWN MONTH INFO HERE <

First off, what is a Secret Santa gift exchange?

A Secret Santa is a holiday gift exchange where participants create something for another person based on that person’s request. The fun of it is, once you know who you will be drawing for, you keep it a secret until you present it to them! And you will, in turn, receive a gift, but you won’t know from who until all the drawings are sent in.

To get a better idea, you can see the gifts from the previous year here

Since this is a Clownblr (clown tumblr) event, all the requests and subsequent gifts must be clown-adjacent, but otherwise, you can request whatever you want, as long as it is SFW.

The timeline:

On November 25th, the signups will be closed.

On December 1st, you will receive a message, either through tumblr dms or the other means of contact you put in, informing you of who you are drawing for, and what their request is. You will then have until the posting dates to create their gift.

The posting period is December 25th 2023 - January 5th 2024. If you wish to post your drawing yourself on tumblr, you must tag the person the gift is for, as well as this blog ( @clownartmonth ) so that I can see it and reblog it. You can also send your drawing to me as a submission, or dm it to your recipient. If you choose to do the latter you must send me a dm informing me of it.

What I signed up, but find out I can’t participate or need more time?

That’s fine, life happens! Please inform me of it as soon as possible so that I can get a backup artist for your recipient’s request. You can also ask for an extension, within a reasonable time frame, which your recipient will be informed of.

General rules:

NSFW in not allowed, horror & gore is permitted only if your recipient explicitly asked for them.

You are not allowed to share your piece before the posting period (December 25th - January 5th)

This time, this event is limited to drawings (traditional or digital). Artists of all skill levels are welcomed, however you are expected to put in a minimum of effort into your piece. Remember, this is someone’s gift! You can see gift from the previous year here.

The code word is "pink"

As always, your mod is a10, feel free to send in any questions you may have! And have fun!

[darcylewisbingohq]

1. driftwood | bonfire | pyromania

2. sweater weather | a dark and stormy night| 10 days of rain

3. centaur | Sleepy Hollow, NY | bakotsu

4. Halloween virgin | Halloween veteran | Queen of Halloween

5. hidden lagoon | The Pettenedda (well monster) | a bunyip in the billabong

6. dungeon | hidden away in Hydra’s sub-basement | subterranean terror

7. supernatural harbinger (Vardøger) | bilocation (doppelgänger) | the Gothic double (Jekyll v. Hyde/Banner v. Hulk)

8. the Hanging Wood | Witches Castle | the Black Forest

9. Chinese Lantern | vampire fruit | Ghost Gum

10. sheet ghost | haunt | ghost POV

11. phobia | fear made flesh | [insert your personal fear here]

12. alienation | Hill of Crosses | “Waltzing Matilda”

13. mutation | sentient Hydra experiment | interviewing a monster

14. Sasquatch | Wild Man of the Woods | Silvanus (similar to a satyr or faun)

15. tarot cards | crystal ball | ouija board

16. a sling ring | a mystery portal | Doors of Death

17. immortal enemy(ies) to lover(s) | succubus soulmate | fiends for life

18. feline | witch’s familiar | thylacine sighting

19. dragon | La Gargouille | kaiju battle

20. enthrall | ‘like a moth to a flame’ | Mothman

21. a virgin sacrifice | fresh flesh | Drop Bear

22. cider festival | beer garden | Oktoberfest

23. rum runner | mooncusser | Half Moon Bay

24. Jersey Devil | Monster of Ravenna | La Llorona

25. costume | disguised naiad | swan maidens

26. (pre)deceased | axe murder | Fall River, Mass.

27. howl | werewolf | Forest of the Wolves

28. runic carvings | curse | a cult of witches

29. Blood Moon | The Hunt | the Wild Hunt/Santa Compaña

30. catacombs | reliquary | ossuary church

31. rich people Halloween party | a Gothic masquerade | Hydra’s Halloween Ball

Alternates

Because the Darcy Lewis Bingo Mod Team are writers and artists ourselves, we understand that not all prompts are created equal and, therefore, are not necessarily inspiring to all creators. So, for 2024-25, we are including a list of 10 fun, spooky alternate prompts you’re welcome to use on any day you get stumped by the creator prompts we’ve supplied above. Each alternate prompt may only be used once, however, so use them wisely and don’t take them for granted. These are not easier prompts by any means! And don’t forget that all of your Promptober fills must incorporate our beloved Lady of the Astrophysics Lab, Dr. Darcy Lewis!

A1. a 2-sentence horror story (req.: cannot be longer than 2 sentences & must tell a complete horror story)

A2. Darcy’s First Halloween

A3. a Halloween Darcy drabble (req.: exactly 100 words)

A4. the Avengers go out on Halloween Night in New York City

A5. an onomatopoeic story or poem (req.: must include at least 13 onomatopoetic words)

A6. a Darcy retelling of the Headless Horseman (or your favorite classic spooky story)

A7. an acrostic poem about Darcy, the Avengers, and Halloween

A8. The Mummy AU

A9. an autumnal Darcy haiku

A10. record a podfic (with permission) of a friend’s spookiest Darcy fic

With our alternates, this means every player begins this round of Promptober with a whopping 103 spooky season prompts. We can’t wait to see what you make of them in the year to come. Have a spooky time creating, Darcy Friends!

Promptober 2024 is a list of 31 this-that-or-the-other prompt themes handpicked by our mod team to cross international borders for creators to choose from to create spooky, oogie, or hygge fanworks for the autumn & Halloween season (or for Scary Christmas, Valloween/St. Guillotine’s Day, Half-Halloween, Gay Halloween!, Summerween, Scary Christmas in July, or Autumn Down Under for our Aussie creators). We continue to be not your mom so we’re not here to tell you when or how long you can celebrate your Spooky Season. Here at Darcy Lewis Bingo HQ, all your spooky holiday lifestyle choices are valid. In fact…

Important Dates & Deadlines

Promptober begins on August 3rd, 2024 this round, but you know how we feel about deadlines. 🔪 So, for this round of Promptober, we’re doing away entirely with hard deadlines and we mean it! You have from August 3rd, 2024 until our next Halloween event begins, and even beyond that, if you like! Though we do strongly recommend wrapping up this challenge before the next spooky challenge begins, this event remains open basically as long as this bingo exists. No pressure to complete, ever, just inspo and encouragement. 🧡

Promptober Challenges

Promptober Mini Challenge: choose and complete fannish works for any 13 of the prompts from this list for our mini challenge. Creators may choose 13 prompts from the list of prompts—any 13 prompts at all!

Promptober Mega Challenge: choose and complete fannish works for 31 of the listed prompts for our spooky main event! Creators may choose any 31 of the total 93 prompts listed to complete this event.

For an extra personal challenge, you may limit yourself to only posting a fanwork inspired by one of the prompts listed by the number that corresponds to each day of October for every day of the month all month long, but it’s absolutely not required for completion of this event. We want you to succeed and create, and to share new Darcy works, so our goal is always to support you in your fannish creative endeavors and make that as easy as possible.

*If you post every day in October as a personal challenge, mention us @darcylewisbingohq in your tumblr posts to let us know you’ve posted a new work or update so we can reblog your daily posts in as close to real time as possible. Once we’ve left a like on your post, rest assured: that means it’s in our queue, just waiting its turn to be featured on our blog.

Promptober 2024 Guidelines

Promptober fills must prominently feature our beloved Lady of Astrophysics, Dr. Darcy Lewis!

Promptober creators have all of our 2024-2025 round to work on this event! If you want to work on it the whole year until we release the next spooky season event, we encourage you to do that. If spooky challenges are particularly your jam, we’d love to see what you do with ours when you’ve got the whole year to tackle it!

entries—Your fanwork is NOT required to use the prompt exactly as it appears on this list. Prompts need only inspire your fanwork, whether they appear word for word in it or not. However the prompt inspires you is correct, as far as we’re concerned. Subvert the prompt, reverse the prompt, marry the prompt—it’s up to you.

All forms of fannish works are accepted and encouraged for this event! Fanfic, fanart, poetry, podfics, fanvids, playlists, fiber and other crafts, fan edits, moodboards, etc.

You may start posting your Promptober fanworks as soon as they’re ready to share. No need to wait until October and no need to rush to get them all done in that month, either.

Fanwork Fill Requirements

100 words for written works or word art, with the exception of poetry with independent formatting rules (such as haikus).

1 image for artwork or handcrafts of any kind and a description for the visually impaired of the medium used and what it represents.

1 image for cosplay or character-bounding and a description for the visually impaired of cosplay or clothing and any other fashion influences incorporated into the costume or clothing (be descriptive! talk about fabrics and colors, tone and texture! describe the emotions the colors you used evoke in you as the creator!)

9 elements for moodboards (background, images, texts, ephemera) and a description for the visually impaired of the moodboard and what it represents.

6 images for social media AUs and a description for the visually impaired of the creation and what it represents.

10 songs for playlists and a text list of artists and songs to give credit to the original artists, plus a description for the visually impaired of what the playlist represents and how it relates to Darcy.

Still not sure if your creation will meet the minimum prompt fill requirements? @ a mod! we’ll create new requirements based on new types of creator fanwork submissions, as needed.

These participation requirements are identical to our annual bingo event; those guidelines are always pinned at the top of our tumblr blog where they’re easy to find; the link to those guidelines and fill requirements can also be found on Discord in our #bingo-info channel.

[hermitzine]

Are you aware of any other zine accounts within the hermitcraft/trafficblr community? Im looking to get involved with this sort of stuff but honestly have no idea where to look!!

We have just the blog for you! @mcytblrsource tracks all things happening in the MCYT fandom, all kinds of events including zines! There are currently a few zines with open applications, or gearing up to opening them, and you can find them listed there.

And fun fact, our mod a10, who is currently writing this answer and is VERY excited you asked, helps run the blog!

[angara-mfrp]

hi this is skadi. today's date is 3/10 and you can reach me here. i'll be dropping all of my characters. thats rover from wuthering waves, baiheng from honkai star rail (C11) , and dionysus from hades game (A10).

Sorry to see you go! We wish you all the best in the road ahead, and hope to see you again! - Mod Cassowary

[mcyt-animatics]

Welcome to mcyt-animatics! A source blog dedicated to archiving current and past mcyt animatics and animations.

Tag us in all future projects!

MEMBERS:

— mod tides: @blocky-tides

— mod a10: @boxbug / @blocksnbeetles

[kareamemad]

دليل شامل: تحويل الملليجرام إلى جرام في Excel باستخدام دالة QUOTIENT

دليل شامل: تحويل الملليجرام إلى جرام في Excel باستخدام دالة QUOTIENT    دليل شامل: تحويل الملليجرام إلى جرام في Excel باستخدام دالة QUOTIENT   عند العمل مع البيانات التي تتضمن وحدات قياس مختلفة مثل الملليجرام (mg) والجرام (g)، نحتاج إلى أدوات فعالة لتحويل هذه الوحدات بدقة. في هذا المقال، سنتعلم كيفية استخدام دالة QUOTIENT في Excel لتحويل القيم من ملليجرام إلى جرام، مع شرح مفصل لأساسيات هذه الدالة وكيفية تطبيقها عمليًا.  المحتويات 1. الفرق بين الجرام والملليجرام 2. ما هي دالة QUOTIENT؟ 3. كيفية استخدام دالة QUOTIENT لتحويل الملليجرام إلى جرام 4. مقارنة بين QUOTIENT وINT  5. أمثلةعملية 6. الأسئلةالشائعة 7. الخلاصة  الفرق بين الجرام والملليجرام  1 جرام = 1000 ملليجرام   تُستخدم الجرامات لقياس الكتل الكبيرة نسبيًا (مثل وزن الأطعمة).   تُستخدم الملليجرامات لقياس الكتل الصغيرة (مثل جرعات الأدوية).   ما هي دالة QUOTIENT؟  تعريف الدالة دالة QUOTIENT في Excel تُستخدم لإرجاع الجزء الصحيح فقط من نتيجة قسمة عددين، دون أي كسور أو باقي.   الصيغة:    excel   =QUOTIENT(البسط, المقام)    المعلمات:     `البسط`: العدد المراد تقسيمه.     `المقام`: العدد المقسوم عليه.   مثال توضيحي excel =QUOTIENT(5, 2)  // النتيجة: 2 (لأن 5 ÷ 2 = 2.5، وتُرجع الدالة الجزء الصحيح فقط)  كيفية استخدام دالة QUOTIENT لتحويل الملليجرام إلى جرام  الخطوات 1. إعداد البيانات:      أدخل القيم بالملليجرام في العمود `A` (مثال: `A2:A100`).      أنشئ عمودًا جديدًا (`B`) للقيم المحولة إلى جرام.  2. تطبيق الدالة:      في الخلية `B2`، اكتب المعادلة التالية:       excel      =QUOTIENT(A2, 1000)          اسحب المعادلة لأسفل لتطبيقها على الخلايا الأخرى في العمود `B`.  3. حساب الباقي بالملليجرام (اختياري):      إذا كنت تريد عرض الباقي بالملليجرام، استخدم دالة `MOD` في العمود `C`:       excel      =MOD(A2, 1000)     مثال تطبيقي | العمود A (ملليجرام) | العمود B (جرام) | العمود C (الباقي ملليجرام) | |||| | 1200                 | =QUOTIENT(A2,1000) → 1 | =MOD(A2,1000) → 200       | | 3500                 | =QUOTIENT(A3,1000) → 3 | =MOD(A3,1000) → 500       |  مقارنة بين QUOTIENT وINT | الوظيفة      | QUOTIENT                     | INT                          | |||| | الوصف    | تُرجع الجزء الصحيح من القسمة. | تُرجع أكبر عدد صحيح ≤ العدد. | | الصيغة   | `=QUOTIENT(عدد, مقسوم)`      | `=INT(عدد)`                  | | مثال     | `QUOTIENT(5, 2) = 2`         | `INT(2.5) = 2`               | | الفرق    | لا تعمل مع الأعداد السالبة.  | تعمل مع الأعداد السالبة.     |  أمثلة عملية  المثال 1: تحويل 2500 ملليجرام  الجرام:    excel   =QUOTIENT(2500, 1000(  // النتيجة: 2    الباقي:    excel   =MOD(2500, 1000(      // النتيجة: 500    النتيجة: `2 جرام و 500 ملليجرام`.  المثال 2: جمع قيم متعددة لحساب إجمالي الجرامات من عدة قيم: excel =QUOTIENT(SUM(A2:A10), 1000)  الأسئلة الشائعة  1. متى أستخدم QUOTIENT بدلاً من INT؟  استخدم `QUOTIENT` عندما تريد الجزء الصحيح من القسمة فقط.   استخدم `INT` عندما تريد تقريب أي عدد عشري لأسفل (حتى لو لم يكن ناتج قسمة).   2. كيف أتعامل مع القيم السالبة؟  `QUOTIENT` لا تعالج الأعداد السالبة بشكل صحيح (تُرجع خطأ `DIV/0!`).   في هذه الحالة، استخدم `INT` بدلاً منها.   3. هل يمكن استخدام QUOTIENT مع نطاقات خلايا؟ نعم، مثل:  =QUOTIENT(SUM(A2:A10), 1000)  النهاية  دالة QUOTIENT هي أداة فعالة لتحويل الملليجرام إلى جرام في Excel، حيث تُرجع الجزء الصحيح من القسمة فقط.   يمكن استخدامها مع `MOD` لحساب الباقي بالملليجرام.   تفوق `QUOTIENT` عند التعامل مع الأعداد الموجبة، بينما `INT` أكثر مرونة مع الأعداد السالبة.  دوال الاكسل via عالم الاوفيس https://ift.tt/Tds4YtL April 19, 2025 at 03:02AM

[bamca]

BR2728-a10

[ranakaushal]

Refurbished iPhone Under 20000: The Best Value Deals by ControlZ

In today’s fast-paced digital world, owning an iPhone has become more of a necessity than a luxury. However, not everyone is willing to shell out hefty amounts for a brand-new device. Enter refurbished iPhones — a cost-effective alternative that allows you to enjoy the premium Apple experience without breaking the bank. If you’re on the lookout for a refurbished iPhone under 20000, ControlZ offers some of the best deals available in the market.

What Is a Refurbished iPhone?

Before diving into the benefits and options available, it’s crucial to understand what a refurbished iPhone is. A refurbished iPhone is a pre-owned device that has been returned due to various reasons—ranging from minor defects to simply being unwanted. These devices undergo rigorous testing, repair, and quality checks before being offered for resale, ensuring that they function as good as new.

At ControlZ, every refurbished iPhone is carefully tested to meet high standards, offering you a top-notch product at a fraction of the original price. So, you get the Apple experience without the Apple price tag!

Why Choose a Refurbished iPhone?

Cost-Effective: A refurbished iPhone under 20000 is a steal for anyone looking to own an Apple product without the high price. Compared to a new iPhone, you could save up to 50% or more.

Sustainable Choice: Choosing a refurbished iPhone helps reduce electronic waste. By giving a second life to an iPhone, you’re contributing to a more eco-friendly planet. ControlZ emphasizes sustainability by promoting the reuse of tech, reducing the need for new resources.

Warranty Included: Unlike buying a used iPhone from an unverified source, ControlZ offers a warranty on all refurbished devices. This provides you peace of mind knowing that if anything goes wrong, you’re covered.

Top Performance: Refurbished iPhones at ControlZ undergo extensive testing to ensure they operate just like new. With fast processing speeds, excellent cameras, and sleek designs, you won’t feel any difference in performance compared to a new model.

Best Refurbished iPhone Models Under 20000

Here are some of the best refurbished iPhone models you can grab for under 20000 at ControlZ:

iPhone 7: The iPhone 7 is a classic choice for budget-conscious buyers. Featuring a 12MP camera, A10 Fusion chip, and a sleek design, it delivers solid performance for day-to-day tasks. Plus, it’s water-resistant!

iPhone 6S: Another great option under 20000, the iPhone 6S packs the power of the A9 chip, a 4.7-inch Retina display, and 3D Touch technology. Ideal for those who enjoy photography and apps with ease.

iPhone SE (1st Gen): Compact and powerful, the iPhone SE (1st Gen) offers excellent performance with its A9 chip and 12MP camera. It’s the perfect choice if you prefer a smaller phone without compromising on speed or quality.

Why Buy From ControlZ?

Quality Assurance: ControlZ ensures that each refurbished iPhone meets stringent quality checks before it reaches your hands. From the battery to the screen, everything is tested for optimal performance.

Affordable Prices: ControlZ specializes in offering premium tech at pocket-friendly prices. The best part? You can easily find refurbished iPhones under 20000 that suit your needs and budget.

Customer Support: With excellent after-sales service and customer support, ControlZ makes sure your buying experience is smooth. Their support team is always ready to assist you in case you have any queries or issues.

Environmentally Friendly: ControlZ is committed to sustainability. Buying a refurbished iPhone not only saves you money but also reduces electronic waste and the demand for new device manufacturing.

Final Thoughts

If you’ve been dreaming of owning an iPhone but don’t want to spend a fortune, opting for a refurbished iPhone under 20000 is an excellent decision. ControlZ offers the best value deals, combining quality, performance, and affordability. With a range of models to choose from, you’re sure to find the perfect iPhone that fits your needs and budget.

[mcytblrsource]

opinions on shrimp event

shimp 🦐

Well if it's an event we have to report on it!

MONTHLY RECAP: JANUARY (SPECIAL EDITION)

Jan 13: The entirety of mcytblr is terrorized by mysterious shrimps. It's shrimptastic and also quite baffling

[morningstarzine]

in your faq, im aware youve stated the zine will involve marginalized gender identities, but i wanted to ask if it will also involve marginalized sexualities? there is often overlap there, but for example, would scott, a gay cis man, fit in this zine? neat project either way!

Our zine is focused only on creators of marginalized gender identities/experience, so that does not include any cis men, regardless of sexuality. A zine focusing on queer creators would be amazing to see, but that is not the one we are making this time!

[hermitadaymay]

Hello and welcome to week three of Hermit-a-Day May! I once again want to take a moment to shoutout the donors to our Gamers Outreach fundraiser. As of the writing of this post, we're at $843 raised! Which is pretty good, but I think we can do better...

...which is why I am considering adding one more item to the raffle! I have in my possession one brand new, completely unopened Scarland Artbook. And if we hit, let's say, $1,500 in the next week - that is, before 5/22, Keralis day - I will add it to the raffle. You can't get these things anymore, folks. If you missed it, they're gone. Except this one.

Anyway, on to thanking our amazing recent donors: thank you to NamesakeRabbit, Marii, sayojin, munchkin1156, dot-moth, a10, Ombby, Pencilcase, A Wild Bird, Topaz, and 5 anonymous donors for your generosity over the last week!

One thing I would like to note today is that we've had several people not opt into as many rewards as they could given the amount they donated. For those of you who donated under your url, I've reached out to check with you about that - but if you donated anonymously or under a name I can't connect to a username, if you're not sure you got the most out of your donation and want me to check, please feel free to dm me at @as-if-unreal and I will check for you while maintaining your anonymity.

You can pitch in to our fundraiser here - you have that same mount of time, until 5/22, to donate $35 for a custom collage by blocky-tides! And you can enter a raffle for as little as $1 - right now, your best odds are with Kiri's scene commission raffle, but none of the races are decided yet, and even one entry to any raffle could win you an awesome prize!

And now, Jevin day!

-Mod Luna

[betweenmountainsskyrim]

This is an overview of what is likely to be Khatryr, a city left over from Falmer culture, inhabited by some snow elves and bosmers.

Khatryr is inspired by Falmer architecture, with the exception of the roofs that I borrowed from Dwemer architecture. I thought it would make for an attractive and elegant visual ensemble.

There are some models of buildings, which are characterized by not having internal cells. The concept here was to bring sounds and lighting directly from the outside and harmonize the internal environment with the external landscape.

It is a location to appreciate the aesthetics, generate some screenshots, and is characterized by including several sound effects of birds and other small insects that I captured here in my region and then edited using Audacity (thanks to the developers of Audacity for their hard work).

Khatryr is located on rock formations suspended in the air, supported by a powerful ancient magic created to save what little of the Falmer culture still remained. The presence of magical anomalies symbolizes the magic that sustains the great mountains in the air.

It's a city whose existence was unknown to the people of Skyrim and which has now been revealed. The city, therefore, is not lore-friendly, but I thought that architecture like this should have a more significant presence in the game.

The city's frame consumption is high due to the rock formations that ended up blowing up the textures, which forced me to intensify the use of frame-consuming objects, such as flowers and trees.

Regarding the trees, by the way, there are a variety of cherry trees created especially for this location, trees that were retextured using vanilla textures, including a cherry tree model whose crown - when looked at from a certain point of view - reveals the shape of a heart, a small tribute to someone I love who is currently very far away. I tried to create the most beautiful city I could with you in mind.

The buildings still need a final review, especially the side walls of the staircase (I'm not satisfied with the current work) and the door frames. The largest building needs to have its furniture organized on the second floor. There are still several NPCs missing to give more life to the place, as well as lines of dialogue. The blacksmith is not yet selling items. The library needs to have its internal cell revised, which is why it was left out of the video. I still intend to optimize the performance to gain some FPS. My computer uses an AMD A10 7850K processor, which together with my 16Gb RAM memory form the bottleneck of my setup.

Khatryr is one of the cities featured in the Between Mountains mod for Skyrim Special Edition. The mod is also intended to be available for the Anniversary Edition.

Between Mountains expands the edge of the outer world of Skyrim, connecting Falkreath to the outskirts of Markarth behind the mountain range created to form the original border of the game and which separates Skyrim from Craglorn.

Thanks to the developers of the Avidemux Video Editor software for allowing the editing of this video. Thanks to the developers of Outfit Studio, SSE NIF Optimizer and also Bethesda Archive Extractor, without these software the creation of new buildings and trees would not have been possible. Thanks also to Bethesda for the Creation Kit and to the Skyrim modding community for the learning I have gained so far.

Thanks for watching. If you liked this video, like, share and leave your comment or question. If possible, help in the development of this mod by joining Patreon. Thank you very much.

[modelsbytalias]

Mastering Advanced Excel Functions: A Deep Dive into XLOOKUP, INDEX, and More

Microsoft Excel stands as a powerful tool with a plethora of functions designed to streamline data analysis and manipulation.

XLOOKUP and VLOOKUP Example:

Traditionally, VLOOKUP has been a staple for searching and retrieving data in Excel. However, the introduction of XLOOKUP has brought a more flexible and efficient alternative. XLOOKUP allows users to search a range, find the exact match, and return corresponding values. XLOOKUP and vlookup example:

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

Suppose we have a table with employee information, and we want to find the department of a specific employee with ID 101. The XLOOKUP version would look like this:

=XLOOKUP(101, A2:A10, B2:B10, "Not Found")

This XLOOKUP formula is more straightforward and eliminates the need for counting columns.

XLOOKUP with Multiple Criteria:

One significant advantage of xlookup with multiple criteria is its ability to handle multiple criteria without the need for complex workarounds. Let's consider a scenario where we want to find the salary of an employee in a specific department:

=XLOOKUP (1, (A2:A10=101)*(B2:B10="HR"), C2:C10, "Not Found")

Here, xlookup multiple criteria seamlessly incorporate using array multiplication, providing a concise and powerful solution.

INDEX and MATCH with Multiple Criteria:

The combination of index match multiple criteria in INDEX and MATCH functions is another powerful tool for handling multiple criteria scenarios. Suppose we want to find the project code for an employee in a specific department:

=INDEX (D2:D10, MATCH (1, (A2:A10=101)*(B2:B10="HR"), 0))

In this example, MATCH, combined with array multiplication, efficiently handles multiple criteria, while INDEX retrieves the corresponding project code.

MOD Function in Excel:

The mod function excel, it returns the remainder of a division operation. It finds applications in scenarios where cyclical patterns or repetitions are involved. For instance, to highlight every third row in a dataset:

=MOD (ROW (),3)=0

This formula, applied as a conditional formatting rule, would highlight every third row.

Smallest Function in Excel:

The smallest function in excel (SMALL) is handy for retrieving the nth smallest value from a dataset. If we have a list of scores and want to find the third smallest score:

=SMALL (A2:A10, 3)

This formula returns the third smallest score from the specified range.

Excel INDEX Function:

Excel index function is versatile and can be used for various purposes, such as retrieving values from a specified location or creating dynamic ranges. For example, to dynamically reference a range based on a category selection:

=INDEX ($B$2:$B$10,MATCH(G2,$A$2:$A$10,0))

Here, INDEX-MATCH combination dynamically fetches the values based on the selected category.

TODAY Function in Excel:

Excel today function simplifies date-related calculations by automatically returning the current date. For instance, to calculate the age of an individual:

=TODAY ()-B2

This formula subtracts the birthdates in cell B2 from the current date, providing the age.

SUBTOTAL Function in Excel:

The SUBTOTAL function is useful for performing operations on filtered data, ensuring that calculations consider only the visible cells. For example, to find the average salary of visible rows:

=SUBTOTAL (101, C2:C10)

Subtotal function in excel calculates the average salary considering only the visible cells after applying a filter.