#project for another day

[cube-cumb3r]

How did people answer the Dungeon Meshi question? (aka. how the Hell do you parse through free-form responses?!?)

(art by Ryokō Kui)

This first part is just going to be babble about google sheets and excel functions, feel free to skim or skip to the results.

Here's how the question was formulated: "Which Dungeon meshi character is objectively the best one If you are unfamiliar with dungeon meshi but still have an answer to this question, you can still answer (you don't need to know the character's name)."

As you can imagine, this made the responses exactly as creative as you'd expect. Which has made them both delightful to read through, but also painful to convert into usable data.

I started with making a list of the most frequently used words, excluding common ones. Here's an excerpt.

From this we already can see some hints as to the character most frequently mentioned, but if I were to make a chart of this it'd be a zillion categories, when ideally the responses obviously referring to the same character should be in one group, so we can truely see how many times a character was mentioned, no?

Although I could individually read every answer and categorize them manually I am NOT going to do that because, 1. it's tedious 2. I don't want to 3. I won't learn anything

If I ever work with a dataset of 1000 observations, doing it manually is absolutely not even feasible, therefore it's good to already know a better way to do it.

I was initially hoping to utilize xlookup, but I realized that xlookup doesn't actually do what I think it did. What I was HOPING it would do was to be able to identify keywords within longer answers, such as "cat girl" or "beardy dwarf" and then match them to some sort of index, where it'd be like Oh "cat girl"? That's obviously "Izutsumi". This is not how xlookup works. Xlookup cannot pick out a keyword from a longer response, it can only identify a partial phrase (example, if the full index phrase was "Delicious In Dungeon", a response saying "Delicious" will match, but a response saying "My favorite anime is Delicious in Dungeon", will not match, because xlookup cannot match a PERFECT MATCH from within a longer chunk of text.)

So instead I had to rely on my long-time good-time pal Regular Expression functions and combine them with xlookup. With my reliable sunday lover Regexextract I can Extract keywords out of answers in one step, and then in the next step match said keyword to my index.

INDEX:

^here is the index. Any non-blank response that doesn't match these gets counted as "Other". I tried to make the keywords as short as possible, that way they'd catch as many alternate spellings as possible without me having to write every variation out myself (LAZY!). For example, "bear" and "beard" don't need to be separate keywords (if they like in this index, correspond to the same character), as the keyword "bear" will match both the word Bear and Beard. Though, and as you will see later, making the keywords too short will result in false matches.

I made some Liberal Assumptions as to who a responder meant, such as in answers mentioning 'lesbians' or 'elf', which could in theory mean many characters. I went back and checked and adjusted the index to see that every answer got coded reasonably, but this has resulted in an index that is extremely adapted to this specific dataset, and it would not be as effective or reliable on a different dataset of Dungeon Meshi Answers.

Also, if a responder mentioned multiple characters, the first match is the one they got counted as. This could also be incorrect, depending on the answer.

RESULTS!!!

Here are the results! The title of the chart is wrong, I was obviously asking about the objectively best character, not "favorite"! Oh well. According to 24.4% responders, the objectively best character is Senshi, which is the correct answer (<- JOKE) (<- actually answered 'Marcille' himself)

You might notice quite a large "Other" category of 21.3% too, this is every response that was difficult to match to a specific Dungeon Meshi character, for a variety of reasons. Check out this hideous pie chart.

I don't know who "the one with teacher vibes" or "the one who is secretly a neutron star" is. Sorgy. Some of these were also referring to characters from other media, which is allowed and I respect it, but none of them recurring sadly. Wouldn't it be crazy if like 4 entirely separate people independently answered Sans. What Would It Mean?

Full responses:

With every "identifiable" response just being coded into a category, you don't actually get to see the beautiful ways in which THOSE people responded this question. So, here they are, in ascending order.

Izutsumi (7.5% of responses)

I was expecting more alternate spellings on this one, I personally think her name is tricky to spell, but that didn't seem to be the case. Also, seems that many people who think she's objectively the best one also don't actually know her name.

Falin (9.4% of responses)

Two of the responses here contains the two keywords, "chicken"/"bird" (which would categorize it as "Falin") and "lesb" (Which would actually categorize it as "Marcille"). Luckily, chicken and bird happened to be written first, so those responses got correctly coded as Falin.

Chilchuck (10.0% of responses)

Nearly everyone who think Chilchuck is the best one also seem to know his name. Maybe you need to be familiar with the show to truely appreciate the Chilchuck?

Laios (12.5% of responses)

Here, due to my laziness of not wanting to account for every possible spelling of Laios, "Ludmila" gets miscategorized as Laios because it contains the keyword "la". However, "The paladin" (which I do think actually is referring to Laios) gets accidentally categorized as Laios for the same reason, correctly.

Marcille (12.5% of responses)

The reason I made the controversial judgement call that responses containing the word lesbian would be coded as Marcille, is because I made the very liberal assumption that anyone responding with just "The lesbian" probably did mean Marcille, anyone familiar enough with Dungeon Meshi to mean Otta is probably be familiar enough to know her name. There is one response here saying "Lesbians", and they probably meant both Marcille and Falin but responders only get one character, so it got counted as Marcille.

Senshi (24.4%)

(You might notice as I just did that a response clearly meaning Chilchuck got coded as Senshi because they happened to mention Senshi first. That's my mistake for not making "halfling" it's own keyword. Sorry!)

Similarly to Izutsumi and Falin, Senshi seems to be a character many responders don't know the name of, in fact it looks like he most out of any character had the most responses mention him without knowing his name. Given that, I would make the assumption that most people who are only vaguely familiar with Dungeon Meshi, and perhaps don't even watch the show, overwhelmingly think Senshi is the Best Guy. Does that make it more of a correct answer, or less?

Anyway,

That's that for Dungeon Meshi. Happy Meshing everybody

[LINK TO MASTERPOST]

Does anyone want to do my new google form

[hatterladz]

Okay I'll behave I'm going to go write like a tooootally normal person who didn't just spend half my day giggling about toes

[reds-skull]

Needed to see this man beaten and bruised, but in pink this time

(Also hey I actually have free time again)

[14dayswithyou]

💖 Day 3.5 is now available! 💖

For the last couple of months, only Server Boosters had access to the 3.5 update... Buuuuut now it's available for everyone to play in the 14DWY Discord — and soon itch.io once I'm happy with the QA and state of the game — so please don't feel pressured to join unless you want to!!

The full devlog + even more screenshots are under the cut ^^

What's been added to the 3.5 version?

📺 Streamer Mode!

I've been told that it's difficult to stream and monetise age-restricted videos on YouTube and Twitch, so I added an option to remove the sexual content and strong language used in the demo.

Now y'all can invite Ren into your bed for cuddles without putting your streamer career on the line /silly /lh

This won't affect the 18+ rating or dark themes/elements of the game, however! Although Streamer Mode will prevent you from seeing any "gruesome" CGs in the future, most of the core elements of the game will still be tied to the choices and decisions you make. So you won't miss out on the overall experience by using streamer mode!!

⚙️ Custom Pronouns!

It only took me one entire year to get around to it, but you can finally choose your own preferred pronouns (or use a set of pronouns instead)... At the cost of being able to change them mid-game ^^;

Since the original pronoun screen wouldn't update until a new scene was displayed, I temporarily disabled the feature. But once I find a workaround, I'll bring it back!

💗 Choose how others perceive you!

You can now choose how the cast and narration perceive you! Originally, the narration was kept strictly gender-neutral (outside of pronouns and genitalia picked by the player), but this will soon change in future updates.

For more clarity: you don't get to choose the words specifically, but you can choose between masculine, feminine, and androgynous terms!

📋 Separate top and bottom genitalia!

You can now choose your tatas and pps separately! >:3

Alongside that, you can also choose your preferred body type!

I removed the "both" genitalia option because a few players still assumed it was an obscure version of "intersex". That wasn't my intention and I don't want to mislead anyone, so I took it out for now ^^;

I also didn't want to include a screenshot of the new genitalia choices in action (because it's NSFW), so y'all get the same character menu screen for the nth time instead lmao

📱 Relationship Screen Overhaul!

You can now change your own status for more immersion, and long-term Server Boosters will eventually be able to submit and use their own icon within the game as well!

Stalking finding your friends has now become easier by using "Buddy Maps"; a new app that allows you to see the location of all the cast members!

I want to offer players more incentive to check the relationship screen since they tend to miss the status updates, so hopefully this might help ;v;

It also says it "updates every few hours" so folks don't go overboard and check every 5 seconds to see where Ren is gdsghf (also keep in mind that he's a hacker lol)

🖤 Additional Scenes Update!

Day 2 received a brand new CG!!!!! Originally, I planned on only adding a few CGs sporadically throughout the game, but it didn't feel right to leave Day 2 so... empty... so I added a brand new CG to (hopefully) make things feel more balanced and natural!

If you decline Teo's offer on Day 3, Leon will now call and try to convince you to reconsider. However, players are still allowed to decline, and if they do, they'll reach a dead end.

After listening to feedback on itch, I changed some of the dialogue during Days 1-3 to make it seem more consistent! They're only small changes though, so it's honestly not worth looking for sdgjssga

🎶 Updated BGM and SFX!

I wanted to try out a different style of music to see if it fits the vibe of 14DWY more! The BGM features more acoustics to suit the "beachy" theme of Corland Bay, though I made a conscious effort to include piano elements as well to stay true to the original!!

I figured it'd be better to give players a live example before I make a poll (to see if they prefer the change or not) and publish it to Itch.

Some new SFX have also been added, though it's very minimal and honestly not that noticeable.

How to download and play the update?

(warning: clicking on the following links will open Discord!!) To download the Day 3.5 update, simply join the 14DWY Discord server, verify your age, and visit the "14dwy-updates" channel!

Alternatively, you can also wait until the update is publicly released on Itch to play it as well!! (It normally gets released shortly after a round of QA testing/getting feedback from the server, though I may release it earlier if I feel like it hehe ^^)

Enjoy!!

[wombywoo]

sick bby 🤧

[tamelee]

Happy 3/7day 🥰~! 'One day we'll look back on all these memories and smile about it'

Process + detail:

[heartorbit]

stay warm! 🌟🍬🤖🎈

[dailyhatsune]

electric angel and 31 year old chimera

[nhura]

Life is too short.

[ my art ] [ twitter ]

(detail + ratio rambling under the cut >_>)

This is one of those "I need a break between my ten other illustrations, let me do a lil sketchy sketch :D" that got too ambitious etc. etc. I never want to see the color red again" moments. BUT!

I really, really like to explore Ratio's viscerality and what's happening between his brain and his nerves, like... all of this thorough control and discipline and he still has to breathe and react to himself and his surroundings, you know? His accomplishments are insane for "his age"* but he's going to run out of "age" at some point! His ambitions are so far reaching that he's not worried about getting doctorate degree Number Nine! Rather, his efforts are pointed outwards, into the universe, for the universe. As you know.

Speaking of his degrees, I had a half thought a while ago that we've seen him with two types of laurel pins.

One is him in his suuuuuper cute mother goose avatar (three leaves) and the other is the hat he's wearing everywhere else (eight leaves).

The thought was, "Aww, what if they're like commemorative pins counting the number of his degrees or whatever :)". Literally only because there's eight in the current one. This is kind of silly because then you'd HAVE to have an obscene number of degrees even for a normal person for your leaf pin to start looking like a laurel in the first place so scratch that BUT it's cute to think that it's still academic regalia. Something something I work in higher ed myself and it's like... it's like that.

The university goldsmith appreciates the job security.

I REMEMBER WHY I BROUGHT THAT UP. FOLLOWING the fantasy where more leaves = more knowledge!, in summary, even though Ratio seems to be a little beyond trying to get a prize every time he learns something now. But he does want to Keep Going. He can only Keep Going.

So I drew him in a bathtub full of an uncountable amount of gold leaves looking at the camera with an indescribable expression born from a hunger that will never be satiated lol DETAIL SHOT!

*Referenced only vaguely in a comment in the context of astonishment, but it could have easily have been "woah he's accomplished so much for his age (young)" as it could be "woah he looks good for his age (older)". There is no canon age and even then, reconciling standardized system time versus planetary time versus "does his particular breed of lizard human have the same lifespan as tumblr user nhura?" is a losing game for everyone involved! Here's what I think: I think he started going grey in his early twenties, whatever that means in spacefantasygame, and that that's very cute on him.

Do YOU think Ratio would be tempted by immortality???? Or would he MIND HIS BUSINESS

[deep-space-lines]

I MADE MYSELF AN EARTHMOVER

The idea that earthmover plushie was something i could realistically maybe make was beamed into my brain on friday may 10th at exactly 11:23 PM and then proceeded to consume my entire weekend. i did not know if this would work but i did it. i made him. my weird lopsided dog Benjamin

(I'd be happy to write up the pattern/instructions if people are interested- I think it'd be pretty simple to recreate since he's like 90% rectangles- but be warned that I have never tried to draft a plushie pattern from scratch before and it's kinda janky as hell the way the legs are attached feels like one of those illegal lego techniques so you have to promise not to make fun of me ok)

[t3chborb]

Cuddling the big scary robot would save me actually.

[yeonjune]

Yeonjun about the strain he felt while preparing for his debut solo project ✙ "GGUM" MAKING FILM

[spearxwind]

No further questions necessary your honor

[deoidesign]

Return date for my webcomic, Time and Time Again!

It's been set for a while but sometimes they change the date without warning, so I'll keep you updated if anything changes!

I'm extremely proud of the work I've been doing on it, I can't wait to share everything!

See you then!

[ph-cutie]

trustworthy interviewees

nonshiny version belowcut

[xxplastic-cubexx]

thoughts on hellfire gala charles? i’m obsessed with that design

Design Wise if we mean the one by lucas werneck, theeen...... i have no clue im divided on it honestly LOL

i like the halo idea, im just not sure im totally sold on the whole execution...

ive always wanted to draw it tho so. have a scribbly if you may :)

bonus cause i need to hang him up like a set of keys