Since I began contributing to this sub, I've noticed that almost all sheets, even the ones with a lot of data and complexity, aren't very readable. This is not unexpected, though … most people working with sheets are not graphic designers or user experience experts.
Though I too am neither of these things, I have worked on front ends on several projects and worked with some world-class UX folks, so I've picked up some tips along the way. I thought it would be helpful to describe my approach to formatting sheets to give an example of the kind of things that can help make data more easily readable. The idea is not that everyone should format sheets the exact way I do, but rather focus on the more general principles that don't even occur to most people.
Here's a new sheet with some fake data and minimal formatting.
Default formatting
The only formatting that's been done here is bolding the header row, applying default number format to the GPA column, and some column width tweaks. Not so great.
Before I start focusing on eye candy, the first thing I would do to a sheet like this is normalize the data itself. I would put different data in different columns. Specifically, I would split first and last names into different columns. An easy way to do this is select the column and go to Data > Split text to columns. Then, the last names need to be changed from upper case. To do this, insert a column right, then use the formula in C2: =PROPER(B2) and copy it down the column, select those properly formatted values and copy, paste special, values only over B2:B, and then delete the C column with the formulas.
The next thing is to make the column headers as terse as possible. It's preferable to use an abbreviation and move the full explanation into a note attached to that column heading. Also, I would not use initial caps on every word, it's not a title, it's just a heading. Finally, set the significant digits on numerical data. For the GPA, we're only tracking to one decimal point, so get rid of the second one.
Here's where we're at so far after fitting column widths to data:
After normalizing data
Now we can start on the eye candy.
I follow the Tufte school of table design, which means less is more.
First step is to get rid of all lines, colors, and text formatting (bold, italics, etc), and only add back formatting that actually makes the data more readable. This means turn off gridlines, no bolded headers. To make the data easier to follow, increase the font size one or two steps of the headers, and add back faint horizontal lines.
Next step is to align headers with data. Since numerical data is right-aligned, the headers for those cols should match. Also, all data on the sheet should be top-aligned except for headers, which are bottom-aligned. Also, let long headers wrap.
Give the tab a meaningful name. Keep it terse, there's no need for words like "info", "data", etc. Just say what's on that tab.
Finally, freeze header row and name columns (this makes the table easier to navigate on small screens, like mobile). Get rid of excess rows and cols. It can make sense to keep a handful of spare rows at the bottom, but once you have the basic sheet laid out there's not really a good reason to keep any excess cols to the right. When new columns are needed, you'll almost always be inserting them based on a current column's format anyway, so you won't generally want to just use a spare one off to the right. (if you didn't know, inserting a col left or right inserts it with the formatting of the col it's based on.)
Here's where we're at (I renamed the EC col and dropped its note):
Cleaner format
Now it's a good idea to go through the cols and apply explicit formatting. Set text cols to text, numbers to numbers, etc.
Add more formatting on the data. Change places to smart chips instead of just using state codes. Use people smart chips if possible as well. Change cols with limited values to dropdowns (Gender, Class). Do data validation on cols (GPA must be between 0 and 4 and Class rank must be greater than or equal to 1).
If there's a way to limit the values in extracurriculars, bring in another tab with all legal values and limit the values in that col as well. This will help normalize all of the data so that you won't see different ways of representing the same data ("Track & field", "Track and Field", etc.).
Finally, here's where we end up:
Final formatted sheet
This is a far more readable and information-rich sheet than where we started, and the data it contains is far more constrained so that any inconsistencies or irregularities will be marked with an error. This can now serve as a solid base on which to start building more advanced functionality. For instance, we could add a col at the far right and get the Google Maps URL for the home state if we wanted to by putting in I2: =H2.url. If these students had accounts in the same Google Workspace domain and they were representable using People smart chips, we may be able to extract a lot of information in the other cols that way.
Again, this isn't the end-all be-all for formatting, if you read Tufte's advice on representing richer data sets you'll find a lot more advice for formatting much more complex data and keeping it readable. But I hope this convinces some folks that even fairly simple sheets can benefit a lot by avoiding approaches that draw more attention to formatting than the data itself.

We recently spoke with Anthony Barone, Co-Founder & Managing Director of StudioHawk UK, about the challenges of launching and running an SEO agency. Anthony shared his journey from being an SEO outsider to becoming the Head of the UK Headquarters for an Australian digital SEO agency. Throughout our conversation, we explored the challenges, opportunities, and strategies of starting and running an SEO agency in a competitive market.
In this article, we will draw from Anthony’s direct personal experience to provide key tips for starting an SEO agency. We’ll also cover some major pitfalls to watch out for.
Key tips for starting an SEO business:

• Define your niche: Offering basic SEO services is no longer enough to stand out. Identify a niche to specialize in and target.
• Get out and network: Build your network by attending events and meetups, and engaging with communities. Exchange experiences and generate leads.
• Form strategic partnerships: Look for and collaborate with companies offering complementary services for mutually beneficial relationships.
• Deliver high-quality work: Set the bar high and raise it often to build your reputation.
• Keep learning: Continually expand your SEO expertise, learn from experts, and outpace changes and trends.

The first steps to starting an SEO company
Starting an SEO agency goes beyond understanding SEO. It’s also about understanding the market, identifying competitors (and how you differ), and building partnerships. Anthony took these exact steps when launching his SEO agency in the UK. He believes everyone should apply them when setting up an SEO business.
Network to build a client base and partnerships
Start your SEO agency with networking. Become more active in the community and build relationships to find your first few clients. Join networking groups, attend business meetups and events, and start booking introductory calls with potential prospects.
Define your competitors
Research major players in your market, including competing agencies and potential partners.
Since the SEO field’s barrier to entry is pretty low, your chances of finding a mix of large agencies and smaller firms are high. Identify the ones you can emulate. Note their operations, capabilities, client portfolios, and how they position themselves.
You should also closely analyze the market you’re entering. When Anthony expanded his agency to the UK, he discovered one of the most competitive and knowledgeable markets, and the competition there wasn’t just limited to other agencies. The UK is home to many reputable brands and adept in-house teams. This means you need to know your stuff and prove your expertise. Anything less and you won’t have the opportunity to speak with or win the business of bigger companies.
Excelling in competitive landscapes like SEO necessitates brushing up on your field, your goal, and the value you bring, and devising a standout SEO strategy that resonates with your client’s business goals.
Differentiate your agency
StudioHawk initially set itself apart by skipping the traditional account manager middleman. The company instructed its SEO specialists to work directly with clients, providing expertise straight from the source.
There are also many other ways to stand out:

• Specialization: Don’t position yourself as a generalist agency. Focus instead on a specific niche like ecommerce SEO, local SEO, SaaS SEO, etc.
• Proprietary process: Develop a unique methodology for your campaigns that no other agency offers.
• Added value: Provide bundle packages for additional services like CRO, PPC, and web development. Some of your rivals may not provide this service.

There are many opportunities to differentiate your agency according to its unique strengths and philosophies. In StudioHawk’s case, Anthony capitalized on his proven track record from Australia and embraced the Aussie way of doing things. So, use any assets and value-added services that set your agency apart.
Map out your ideal client
Here is why StudioHawk made the strategic decision to focus on the small-to-medium enterprise (SME) market (when launching in the UK):

• SMEs generally have smaller budgets: StudioHawk responded by offering competitive prices and lower overhead costs.
• Many SMEs suffer from poor experiences: This inspired Anthony’s team to create quality services in a field marred by low-quality SEO providers who use churn and burn tactics.
• Smaller businesses crave more personalized service: This calls for tighter client bonds.

Anthony’s team impressed SMEs by keeping things simple and transparent. They focused on clearly communicating their service and its effect on the client’s business goals and revenue targets.
Hiring and training new talents
Build your agency’s SEO team with candidates who align with your company culture and match your core values. Don’t just focus on technical skills. SEO expertise is an important skill but can be taught without much friction. Training culturally incompatible employees to have the right mindset and attitude is much harder.
Be patient and discerning. Consider the candidate’s energy and soft skills during the SEO interview process. Integrating candidates into your team is easier if they mesh with your philosophy and vibe.
Developing clear frameworks
Provide hands-on training and set clear systems and frameworks for your team. People need to be told what to do, what their job is, how to do it, and why they are doing it. Lack of structure leads to inconsistency, low-value work, and misalignment with client expectations.
Craft clear job descriptions with set responsibilities, metrics, and each role’s expected outputs. Your overall order of operations can be as loose or hardline as desired, but create a guidebook, rules, and criteria around it. Resources like these help new hires understand their role and responsibilities.
Always stay on top of SEO
Clients value experts, so you must constantly grow by following new trends and updates, and learning from industry leaders.
Make ongoing education and collaboration part of your core values. Here is how Anthony’s team implemented this:

• They attended industry-specific events and SEO conferences.
• They built relationships with respected thought leaders.
• They subscribed to newsletters and joined online communities.

The bottom line? Engage with the broader SEO community. Don’t work in isolation.
Share wins and lessons
Share knowledge internally. Learn from your colleagues through:

• Campaign review sessions, where your SEO specialists can present their high-performing work and failures side by side. Pinpoint strategies leading either to success or poor results.
• Collaborative brainstorming, specifically on reporting enhancements, use of tools, client interaction, etc.
• Workshops on industry-specific insights, where the team discusses strategies for various niches.

This allows team members to improve and learn from one another continually.
Adapt to search evolution
SEO is going to get harder. With EEAT, SGE, and algorithm updates, SEO professionals who want to make a bigger splash must work harder to improve their content and quality.
For example, SGE is already altering the SERP landscape. Its AI-powered responses include links to Quora and Reddit. This means you should consider socials as additional traffic channels. SGE snippets vary across industries, especially in ecommerce, indicating the need to create exceptional product descriptions and pages. Ads are also occupying more space.
A lot is going on. You must watch these shifts carefully while integrating your business into the overall marketing ecosystem.
Pitfalls to avoid when starting and running an SEO agency

1. Don’t focus on things outside your control

Don’t compare yourself to others or set unrealistic goals. There will always be people smarter or better than you. Rather than dwelling on the unreachable, focus on factors you can control; the number of meetings you hold, the quality of your team’s work, developing efficient systems and processes, and so on.
You can always control your motivation and discipline. Your “why” for being in this business is also within your scope of influence.

1. Remember your ‘Why’

Zero in on your core reason for starting your SEO business if you haven’t already. Not establishing a “why” prevents you from seeing the bigger picture.
Maybe your “why” revolves around creating the best agency out there. It could also be a less lofty goal, like designing a lifestyle business that helps you spend more time with your family. Whatever your core purpose is, identify it and reference it constantly.
Reconnect with your initial inspiration for starting your business. Then, focus on improving operations and steadily working towards your goals.

1. Don’t blame clients if they quit

Take responsibility and learn from client churn. Losing a client can hurt, but blaming the client won’t do you any favors. There is always a lesson to be extracted from the situation, so take accountability.
Put yourself in the client’s shoes. Try to understand why they parted ways with you. Was there a failure in communication or reporting? Did they fail to see the value? Did the client need more meetings to stay informed and involved?
Conduct NPS (Net Promoter Score) or feedback surveys regularly. This can help you consistently improve and understand what your clients did and didn’t like.

1. Know your numbers

Launching an agency is exciting, and cooperating with clients is a key aspect of the business. But it’s your business at the end of the day, and you need to run it that way. If you want your agency to operate for a long time and be successful, learn how to master its financial and operational aspects.
Wrapping up
Starting an SEO agency and running it successfully requires strategic planning, continuous learning, effective team management, and commitment to high-quality work. Thankfully, these are all aspects you can control. Focus on these elements to build a solid foundation for success.

I am using the following method to read from a very large file and write the results to a new file. The amount of data read from the input file and written to a new file can very wildly, from a few KiB to a couple GiB. I am using this method in a program to parse/extract a filesystem binary image - so this method gets used a lot. How can I improve the efficiency of this method? It is at least 2x slower (in the best case) than a synchronous version I wrote.
Some things that may or may not be helpful to mention:

• Data is read a block at a time from the image, and the blocks of data for a file may or may not be local to each other. I think that blocks are typically local to each other, though.
• blocksize is a variable that's defined by the filesystem I'm trying to parse, it can be as large as 4 KiB
• The filesize (i.e. how many bytes this method will read) is known prior to the call

Sorry if I'm not including enough information - I am new to asynchronous programming (and I guess I/O techniques beyond simple reads/writes). Thanks in advance

private async Task WriteFileContentsAsync(Inode inode, FileStream outputStream) { int remainder = (int)(inode.Size % BlockSize); remainder = (remainder == 0) ? (int)BlockSize : remainder; List dataPointers = GetDataPointersForInode(inode); byte[] data = new byte[BlockSize]; List taskList = new List(); int i = 0; while (i < dataPointers.Count - 1) { FileStream.Seek(dataPointers[i], SeekOrigin.Begin); i++; taskList.Add(FileStream.ReadAsync(data, 0, (int)BlockSize)); taskList.Add(outputStream.WriteAsync(data, 0, (int)BlockSize)); } await Task.WhenAll(taskList); if (dataPointers.Count != 0) // handle remainder { FileStream.Seek(dataPointers[i], SeekOrigin.Begin); int numBytesRead = FileStream.Read(data, 0, remainder); if (numBytesRead == remainder) { outputStream.Write(data, 0, remainder); } } } 

Hemorrhoids, though often a source of discomfort and embarrassment, are a common affliction affecting millions of individuals worldwide. The discomfort they bring can range from mild irritation to severe pain, leading many to seek relief through various treatments. One such solution gaining attention is Simple H Hemorrhoid Cream. In this article, we'll delve into what Simple H Cream is, how it works, its ingredients, benefits, drawbacks, and a final conclusion on its efficacy.
Simple H Cream is a topical treatment designed to alleviate the symptoms associated with hemorrhoids. It is formulated with a blend of natural ingredients known for their soothing and anti-inflammatory properties. This cream aims to provide fast and effective relief from pain, itching, burning, and swelling caused by hemorrhoids.
What is Simple H Cream?
Simple H Cream is a topical ointment specifically developed to target the discomfort and irritation associated with hemorrhoids. It comes in the form of a smooth, easy-to-apply cream that is intended for external use only. The combination of its natural ingredients makes it a popular choice for individuals seeking a gentle yet effective solution to their hemorrhoid symptoms.

Click Here To Order Simple H Cream From The Official Website

How Does Simple H Cream Work?
Simple H Cream works through its unique blend of ingredients that target various aspects of hemorrhoidal symptoms. Calendula and cucumber extract provide soothing relief to inflamed tissues, while witch hazel helps reduce swelling and irritation. Phenylephrine hydrochloride acts as a vasoconstrictor, shrinking blood vessels and reducing bleeding. Licorice root and aloe vera contribute to the overall healing process, promoting tissue repair and reducing discomfort.
How to Use Simple H Hemorrhoid Cream?
Using Simple H Cream is straightforward. Wash the affected area with mild soap and water, then gently pat it dry. Apply a small amount of the cream to the affected area, covering it with a thin layer. Use as directed on the packaging or as advised by your healthcare provider. It's essential to follow the recommended usage instructions for optimal results and to avoid any potential adverse effects.
Ingredients in Simple H Hemorrhoid Cream:
Simple H Cream contains a blend of natural ingredients, including:
· Calendula: Known for its anti-inflammatory properties, calendula helps soothe irritated skin and reduce swelling.
· Phenylephrine Hydrochloride: A vasoconstrictor that helps shrink swollen blood vessels, reducing bleeding and discomfort.
· Licorice Root: Possesses anti-inflammatory properties and aids in skin healing.
· Cucumber Extract: Provides cooling and soothing relief to inflamed tissues.
· Witch Hazel: Known for its astringent properties, witch hazel helps reduce swelling and inflammation.
· Aloe Vera: Has moisturizing and healing properties, promoting tissue repair and reducing discomfort.
Benefits of Simple H Cream:
· Provides fast relief from pain, itching, burning, and swelling associated with hemorrhoids.
· Formulated with natural ingredients known for their soothing and anti-inflammatory properties.
· Easy-to-use cream that can be applied directly to the affected area.
· Can be used multiple times a day for ongoing relief as needed.
· Does not contain harsh chemicals or artificial fragrances.

Click Here To Order Simple H From The Official Website

Drawbacks of Simple H Cream:
While Simple H Cream offers numerous benefits, it's essential to consider potential drawbacks, including:
· Individual sensitivity or allergic reactions to any of the ingredients.
· Temporary stinging or burning sensation upon application, which is common with many topical hemorrhoid treatments.
· May not provide complete relief for severe or advanced cases of hemorrhoids, requiring additional medical intervention.
Conclusion - Simple H Cream:
Simple H Hemorrhoid Cream offers a promising solution for individuals seeking relief from the discomfort and pain of hemorrhoids. With its blend of natural ingredients and targeted approach to symptom relief, it provides an effective option for managing this common condition. However, like any over-the-counter remedy, it's essential to use Simple H Cream as directed and consult with a healthcare professional if symptoms persist or worsen. Overall, Simple H Cream stands out as a reliable choice for addressing hemorrhoidal discomfort and promoting healing.

Click here to order Simple H Hemorrhoid Cream from its official website.


https://www.latinoleadmn.org/group/leadership-action-team/discussion/24e447c4-b67a-4b0d-8bcd-280d28397f4d
https://www.50statecoalition.com/group/eviefinn-1/discussion/d89cf02f-dd38-4f38-a193-e0515832d37b
https://www.irvac.org/group/mysite-200-group/discussion/a8bdb1c0-c8d2-454f-b3b5-c4105d0253f5
https://www.myrtlebeastocr.com/group/news-events/discussion/e2b1aed8-075b-4069-bc1f-e12108eeafc3
https://www.grbudc.com/group/fathers-day-luncheon-pictures/discussion/97863a96-e364-429e-b169-8bf7d65721fd
https://www.oksoberfest.com/group/oksoberfest-group/discussion/c305981f-3a69-4b93-b867-43ae0daab448
https://www.espacobaiao.com/group/grupo-template-2-espaco/discussion/6642c9a3-1360-4259-a381-4d6b6a653ad9
https://www.beyondyogabysaillo.com/group/my-site-2-gruppe/discussion/061a93c2-5e80-45cb-a958-9d81eac7907f
https://forum.freeflarum.com/d/63299-simple-h-cream-reviews-analyzing-the-pros-and-cons
https://diendannhansu.com/threads/simple-h-cream-reviews-what-experts-and-users-are-saying.435130/
https://blog.rackons.in/simple-h-cream-reviews-its-scam-or-not

I've been quietly working on this server for a while, but it's now reached the point where we are hampered by a lack of players (and thus prospective helpers for building the server infrastructure). Thus, I present to you...
Halsion Reach: Precipicea.
Version: 1.18.2 Modpack: Halsion Reach: Precipicea (Technic launcher) Official Discord: discord.me/halsionreach (Using discord.me link for ease of memory). Primary unique features:

• WIP full economy (All items will have a designated value in the economy, allowing for a globally stable economic system)
• Public transport transit system (WIP as of this post)
• Active staff (Myself and my mother, both of whom are more than happy to help with any issues you might have
• Ability to create a co-operative "base" Settlement which will feed into the economy through a chosen Specialisation
• Specialisations include Residential Sprawl, Extraction (Ore mining), Arcane (magic based), Industrial (Tech based), Aquaculture (fishing and farming of ocean-based materials), and Commercial Hub (Mixed shop and residential areas, creating a kind of live-in marketplace)
• Not quite a unique feature, but common sense rules (no offensive names or structures, no griefing/theft, etc).
• A simple ranking system: Nomad (Player has just joined, but not yet become a Resident of any Settlement, nor Founded a Settlement), Resident (Has joined but not Founded a Settlement), Mayor (Has Founded a Settlement). These are the only 3 ranks needed for the way my server works.
• Above these are the staff ranks: Builder, Moderator and Admin
• Currency may be obtained by selling material goods to a shop, selling items you own "off market", or by attending a bank branch with copper ingots. You may also use the Amadron Tablet to trade copper nuggets and ingots for coins.
• Simple currency system: Coins are worth 10 of the coin below them, and coin piles are worth 9 of their coin material.
• Unique heart system thanks to Spice of Life: Carrot Edition. You begin with 1 heart, but can obtain up to in excess of 30 bars of health.

Description

Have you ever wondered what it would be like to live in a city in minecraft? Well look no further, because in the Halsion Reach Modded Nationbuilding Project (Or Halsion Reach Nation Project for short), you can do just that! Want to become a world-famous engineer? Go for it! Want to become an all-powerful mage? Sure! Or perhaps your mind is set on a more... Commercial endeavour. The world is waiting... Why not become an ultra-wealthy business mogul? Whatever you want to be, the Reach can get you there.
Halsion Reach: Precipicea is simply waiting for you to take the leap of faith. Join us, and make your mark on this world.

A common claim in HP fandom is that Harry doesn’t appreciate Hermione enough. A weirder assertion I sometimes see is that Ron compliments or appreciates Hermione more than Harry.
Admittedly, Hermione does a lot for Harry throughout the books, and he doesn’t always express his thoughts directly to her. Nevertheless, there are many passages where Harry directly compliments Hermione (often using words of very high praise), as well as quite a few where he expresses his admiration of her to other people.
This essay will explore those complimentary passages from the books. I won’t include simple expressions of gratitude (though those exist too between Harry and Hermione), nor will I recount here the many passages where Harry merely thinks highly of Hermione or appreciates her without saying anything aloud. Frankly, that would make this essay much too long, and I want to focus on real compliments and praise.
After we’ve explored how Harry compliments Hermione along with her reactions, we’ll take a look at how Ron tends to praise Hermione, as well as the different way she reacts to both boys. Not surprisingly to most readers here, we’ll see that Harry is the boy Hermione truly loves praise from. Unfortunately in Ron’s case, his compliments almost never land well (if they land at all).
I’m going to keep the commentary shorter here on many passages, as this is primarily intended to be a list to demonstrate just how much Harry appreciates Hermione and thinks highly of her. Nevertheless, we’ll see a number of patterns emerge as we go through.

Harry’s direct compliments

Let’s begin with one of the most well-known interactions in the early books between Harry and Hermione (PS16):

Hermione’s lip trembled and she suddenly dashed at Harry and threw her arms around him.
‘Hermione!’
‘Harry – you’re a great wizard, you know.’
‘I’m not as good as you,’ said Harry, very embarrassed, as she let go of him.
‘Me!’ said Hermione. ‘Books! And cleverness! There are more important things – friendship and bravery and – oh Harry – be careful!’

There’s not much new to say about this passage—Harry is about to go on alone, putting himself in great danger. Hermione’s lip trembles in emotion, and she embraces Harry for the first time in the books, praising him as a “great wizard.” And yet, Harry claims he’s simply not as good as Hermione.
Still, the two of them go back and forth about it in a cute way, as Hermione then says “Me!” and proceeds to implicitly compliment Harry’s friendship and bravery further.
I mention this latter detail of the back-and-forth because it gets mirrored four years later, except this time with Harry being the one to say, “Me?” See OotP15:

‘Harry, you’re the best in the year at Defence Against the Dark Arts,’ said Hermione.
‘Me?’ said Harry, now grinning more broadly than ever. ‘No I’m not, you’ve beaten me in every test –’
‘Actually, I haven’t,’ said Hermione coolly. ‘You beat me in our third year – the only year we both sat the test and had a teacher who actually knew the subject. But I’m not talking about test results, Harry. Think what you’ve done!’

We know of Harry’s prowess at DADA. Can anyone forget the insanely powerful Patronus Harry conjured at the end of PoA, which Hermione noted was “very, very advanced magic”? It’s again cute that they get into a disagreement, both modestly trying to one-up the praise of the other here while claiming they themselves aren’t the best.
But I already skipped over another moment a few chapters earlier in OotP9:

[Ron] dashed from the room, leaving Harry and Hermione alone.
For some reason, Harry found he did not want to look at Hermione. He turned to his bed, picked up the pile of clean robes Mrs Weasley had laid on it and crossed the room to his trunk.
‘Harry?’ said Hermione tentatively.
‘Well done, Hermione,’ said Harry, so heartily it did not sound like his voice at all, and, still not looking at her, ‘brilliant. Prefect. Great.’
‘Thanks,’ said Hermione. ‘Erm – Harry – could I borrow Hedwig so I can tell Mum and Dad? They’ll be really pleased – I mean prefect is something they can understand.’

The circumstances are complicated here, because Harry’s feeling really conflicted about not getting a prefect’s badge. He doesn’t want to look at Hermione, because I think he feels like she’d be disappointed in him, as she was so enthusiastic about the idea of being prefect with him a few minutes before. I analyzed this whole section in greater depth in another essay, so I won’t get into all of that here.
For the present, let’s just note that Harry is feeling very emotional and is about to launch himself into one of the longest internal monologues in the books, feeling quite down about himself. Yet he still finds the strength to tell Hermione how “brilliant” he thinks she is. Even if he’s hurting and can’t even look at her, he wants her to know he’s proud of her.
This isn’t the only place where Harry spontaneously feels the need to give Hermione compliments even under less-than-ideal circumstances. He seems to place great importance in ensuring that Hermione knows how highly he thinks of her. We particularly see this later in the series. In HBP25, Hermione basically accuses Harry of being mildly sexist because he refuses to take her theory seriously that the “Prince” (the former owner of the potions book) might have been a woman:

‘Listen, Hermione, I can tell it’s not a girl. I can just tell.’
‘The truth is that you don’t think a girl would have been clever enough,’ said Hermione angrily.
‘How can I have hung round with you for five years and not think girls are clever?’ said Harry, stung by this.

Harry’s “stung” that Hermione would think of him as sexist, but he’s specifically disappointed because he knows how brilliant and clever Hermione is. He thinks she’s amazing and incredible and the best in his year at school. I wonder if this passage leads Harry to reflect a bit on how he may not always voice his opinion to Hermione enough, as there’s a marked change in DH, where Harry more frequently tells Hermione directly how highly he thinks of her.
For example, in DH9, in the scene after the trio was attacked by Dolohov and Rowle, Harry calls her “brilliant” for casting a memory charm:

She took a deep, calming breath, then pointed her wand at Dolohov’s forehead and said, ‘Obliviate.’
At once, Dolohov’s eyes became unfocused and dreamy.
‘Brilliant!’ said Harry, clapping her on the back. ‘Take care of the other one and the waitress while Ron and I clear up.’

Later, after Harry and Hermione escape Nagini’s attack at Bathilda Bagshot’s house, Harry calls her “incredible” (DH18):

‘You’re still really angry at me, aren’t you?’ said Hermione; he looked up to see fresh tears leaking out of her eyes, and knew that his anger must have shown in his face.
‘No,’ he said quietly. ‘No, Hermione, I know it was an accident. You were trying to get us out of there alive, and you were incredible. I’d be dead if you hadn’t been there to help me.’
He tried to return her watery smile, then turned his attention to the book.

As in the OotP passage where Harry is feeling depressed about the prefect’s badge, here Harry isn’t really ready to talk. His wand is broken, he was injured by Nagini, and he spent the night having visions of Voldemort killing his parents. It’s not at all an exaggeration to say this is probably the most dire part of Harry’s journey in the books. And yet he still values Hermione enough not only to agree to talk when he’s not ready, but also to immediately forgive her and call her “incredible” for her quick thinking the previous night.
Moreover, we can see how much this means to Hermione at that moment, as she smiles in gratitude at Harry, in contrast to her tear-streaked face.
Later in DH, after Hermione was tortured at Malfoy Manor, we again see Harry expressing his understanding and gratitude for Hermione when he first talks to her (DH24):

Harry had walked up several steps before stopping and looking back.
‘I need you two, as well!’ he called to Ron and Hermione, who had been skulking, half-concealed, in the doorway of the sitting room.
They both moved into the light, looking oddly relieved.
‘How are you?’ Harry asked Hermione. ‘You were amazing – coming up with that story when she was hurting you like that –’
Hermione gave a weak smile as Ron gave her a one-armed squeeze.

Harry calls her “amazing,” and once again Hermione smiles in reply. I should also pause here to note that these superlatives aren’t common for Harry. In fact, they’re unique to Hermione. Harry doesn’t call anyone else “amazing” or “incredible” anywhere in the books.
And these are far from the only times Hermione’s quick thinking saves the day. A few months earlier, she once again apparated Harry (and Ron too) away in mid-air to escape Luna’s father’s house, coming up with a detailed plan in a matter of seconds to hide Ron while exposing Harry during the escape (for strategic reasons). Harry then agrees Hermione is a genius and tells her doesn’t know what they’d do without her (DH22):

‘You’re a genius,’ Ron repeated, looking awed.
‘Yeah, you are, Hermione,’ agreed Harry fervently, ‘I don’t know what we’d do without you.’
She beamed, but became solemn at once.

I’d note another detail here. Ron does compliment Hermione too in this passage, calling her a “genius” multiple times. Yet it’s only once Harry finally tells her how much she means to him that Hermione “beams” in reply. (In a previous essay, I examined how frequently Hermione “beams” at Harry, much more than anyone else.)
This is a pattern we see repeatedly in the books, where Ron’s praise is ignored in favor of Harry’s. Perhaps the clearest example is in HBP9:

[Slughorn:] ‘Oho! “One of my best friends is Muggle-born and she’s the best in our year!” I’m assuming this is the very friend of whom you spoke, Harry?’
‘Yes, sir,’ said Harry.
‘Well, well, take twenty well-earned points for Gryffindor, Miss Granger,’ said Slughorn genially.
Malfoy looked rather as he had done the time Hermione had punched him in the face. Hermione turned to Harry with a radiant expression and whispered, ‘Did you really tell him I’m the best in the year? Oh, Harry!’
‘Well, what’s so impressive about that?’ whispered Ron, who for some reason looked annoyed. ‘You are the best in the year – I’d’ve told him so if he’d asked me!’
Hermione smiled but made a ‘shush’ing gesture, so that they could hear what Slughorn was saying. Ron looked slightly disgruntled.

Harry had already praised Hermione to Slughorn privately (a fact we’ll come back to), but hearing this praise from Harry causes Hermione to turn toward Harry with a “radiant expression,” overwhelmed with joy at the idea that Harry thought of her as the “best in the year.” (The word choice of “radiant” here is rather special for JKR, as I’ve noted in a previous essay.)
Meanwhile, poor Ron is off to the side, looking “slightly disgruntled” when Hermione shushes him in class for a similar remark.

Ron’s compliments to Hermione

Unfortunately for Ron, Hermione’s reaction in the Slughorn scene is typical. We’ve seen Hermione repeatedly smiling and looking radiant at Harry’s compliments, as well as reacting by praising him in return. Ron, on the other hand, is almost exclusively met with tepid if not outright negative reactions from Hermione even when he says nice things about her.
I drew on a list of Ron compliments created by Ron/Hermione shippers here, but the original list only gave Ron’s lines, without Hermione’s reactions, which I’ve restored below. (The reason for the omission of Hermione’s responses will soon become clear.)
Ron first shows genuine admiration for Hermione back in PoA15 when she slaps Draco and then storms out of Divination. However, the first time Ron actually tries to express this appreciation verbally probably happens in OotP12:

[Hermione:] ‘About You-Know-Who. He said his “gift for spreading discord and enmity is very great. We can fight it only by showing an equally strong bond of friendship and trust –”’
‘How do you remember stuff like that?’ asked Ron, looking at her in admiration.
‘I listen, Ron,’ said Hermione, with a touch of asperity.
‘So do I, but I still couldn’t tell you exactly what –’
‘The point,’ Hermione pressed on loudly, ‘is that this sort of thing is exactly what Dumbledore was talking about. You-Know-Who’s only been back two months and we’ve already started fighting among ourselves. And the Sorting Hat’s warning was the same: stand together, be united –’

Although this isn’t a direct compliment, we’re told that Ron is actually looking at Hermione “in admiration.” Unlike his more typical annoyance with her, he’s actually impressed here by her memory. And yet Hermione responds with “asperity,” harshly putting him down for not listening better. When Ron gets defensive and tries to react, Hermione “loudly” talks over him and essentially ignores Ron completely.
This is far from the only time Hermione will ignore Ron’s occasional kind words, because she clearly knows it’s unusual behavior. She tells us this directly (OotP14):

‘OK, write that down,’ Hermione said to Ron, pushing his essay and a sheet covered in her own writing back to Ron, ‘then add this conclusion I’ve written for you.’
‘Hermione, you are honestly the most wonderful person I’ve ever met,’ said Ron weakly, ‘and if I’m ever rude to you again –’
‘– I’ll know you’re back to normal,’ said Hermione.

Ron was trying to thank her for help with his homework, but Hermione recognizes this praise as obviously transactional. She has noticed he’s only nice to her when she does things for him, but otherwise his “normal” behavior toward her is a bit rude. (As a sidenote: we’ve already seen Harry repeatedly refer to Hermione as “brilliant.” Ron, in contrast, does call Hermione sort of “brilliant” twice, both times sarcastically referring to theories or ideas he thinks are ridiculous. See CoS13, DH25.)
Ron’s attempts at recognizing Hermione’s achievements also look very different from Harry’s. In HBP5, when Hermione is worrying about her O.W.L. exam performance, Ron does acknowledge Hermione’s academic performance a couple times, in passages that Ron/Hermione fans will point to as evidence of his supposed admiration.
Yet they don’t come off as compliments. They are aggressive and exasperated and almost making fun of Hermione at the end. And look how Hermione reacts:

‘Hermione, will you shut up, you’re not the only one who’s nervous!’ barked Ron. ‘And when you’ve got your ten “Outstanding” O.W.L.s ...’
‘Don’t, don’t, don’t!’ said Hermione, flapping her hands hysterically. ‘I know I’ve failed everything!’
[…]
‘I – not bad,’ said Hermione in a small voice.
‘Oh, come off it,’ said Ron, striding over to her and whipping her results out of her hand. ‘Yep – nine “Outstandings” and one “Exceeds Expectations” in Defence Against the Dark Arts.’ He looked down at her, half-amused, half-exasperated. ‘You’re actually disappointed, aren’t you?’
Hermione shook her head, but Harry laughed.

So yes, Ron acknowledges her achievements here, but he does so in the process of telling her to “shut up,” barking at her, and then becoming “exasperated” at her personal goals. I think we can all take a step back and acknowledge that Hermione is a fairly extreme perfectionist, and her level of anxiety at potentially “failing everything” comes across as weird and a bit irrational. Still, rather than helping her “calm down” (as many Ron/Hermione fans would say Ron does), Ron exacerbates Hermione’s level of disquiet, causing her to become “hysterical” and then later embarrassed, reacting in a “small voice.”
Harry would have just clapped her on the back and called her “brilliant” or something, to which she’d probably smile in reply. Harry doesn’t share Hermione’s level of academic dedication, but he still appreciates it, rather than trying to shame Hermione for being an overachiever. Yet Ron manages to make her uncomfortable in several different ways in this scene, even as he recognizes how well she would do.
And we’ve only started on the types of negative reactions Hermione has to Ron’s attempts at recognizing her achievements. In HBP21 after apparition practice in Hogsmeade, Ron cuts in to call her performance “perfect”:

‘Good one,’ said Harry. ‘How’d you do, Hermione?’
‘Oh, she was perfect, obviously,’ said Ron, before Hermione could answer. ‘Perfect deliberation, divination and desperation, or whatever the hell it is – we all went for a quick drink in the Three Broomsticks after and you should’ve heard Twycross going on about her – I’ll be surprised if he doesn’t pop the question soon –’
‘And what about you?’ asked Hermione, ignoring Ron.

Ron’s praise is undermined with the dismissive “whatever the hell it is,” once again making it clear that he doesn’t value Hermione’s attention to detail and high standards. Hermione’s response is, reasonably, then to simply ignore Ron.
Admittedly, Ron appears to realize some of his failings and makes an attempt in Deathly Hallows, reading the Twelve Fail-Safe Ways to Charm Witches book and trying to learn how to compliment a girl. It unfortunately doesn’t go quite smoothly for Ron at first (DH7):

Hermione made purple and gold streamers erupt from the end of her wand and drape themselves artistically over the trees and bushes.
‘Nice,’ said Ron, as with one final flourish of her wand, Hermione turned the leaves on the crab-apple tree to gold. ‘You’ve really got an eye for that sort of thing.’
‘Thank you, Ron!’ said Hermione, looking both pleased and a little confused. Harry turned away, smiling to himself. He had a funny notion that he would find a chapter on compliments when he found time to peruse his copy of Twelve Fail-Safe Ways to Charm Witches […].

Ron arguably is trying here, but as we know from OotP, Hermione knows Ron’s more typical reaction toward her is rudeness. Hence we see her a “little confused” yet still somewhat pleased.
This kind of dual reaction from Hermione is usually the best Ron can hope for. Unlike Hermione’s instant smiles and happiness from Harry’s compliments, she views Ron with suspicion. Hermione always appears to keep in mind that Ron’s pleasant reactions are atypical and thus not to be trusted. We see this again as Hermione enters before Bill and Fleur’s wedding, wearing a lovely dress (DH8):

‘[…] wow,’ [Ron] added, blinking rather rapidly as Hermione came hurrying towards them. ‘You look great!’
‘Always the tone of surprise,’ said Hermione, though she smiled.

Note the “though she smiled” qualification here, which is pointing out that Hermione’s reaction is not exactly positive and arguably unkind. Hermione is here making a reference to an earlier conversation after the Seven Potters. When Tonks mentioned how “great” Ron was stunning a Death Eater, Hermione reacted positively with “you did?” Hermione was sincerely proud of Ron at that moment, hugging him, and yet Ron reacted with the phrase “Always the tone of surprise,” rejecting her and breaking off from her embrace.
Admittedly, Ron was a bit right in that scene to acknowledge that Hermione almost never recognizes his achievements. Yet in the wedding scene, we see Hermione throw that verbal dig back at Ron, effectively taking what appears to be a more sincere compliment from Ron and undermining it. She’s telling him (and the reader) that he doesn’t generally find her attractive and wouldn’t typically say such a nice thing to her.
In effect, she’s somewhat begrudgingly smiling while taking a swipe at Ron’s more typical behavior.
There’s really only one time in all of the books that I have found where Hermione actually reacts positively (without qualification) to Ron’s praise. That occurs in DH9 after she reveals how she had packed so much in her beaded bag in preparation for the Horcrux hunt and emergencies:

‘I told you at The Burrow, I’ve had the essentials packed for days, you know, in case we needed to make a quick getaway. I packed your rucksack this morning, Harry, after you changed, and put it in here ... I just had a feeling …’
‘You’re amazing, you are,’ said Ron, handing her his bundled-up robes.
‘Thank you,’ said Hermione, managing a small smile as she pushed the robes into the bag. ‘Please, Harry, get that Cloak on!’

We see her here at least giving Ron a “small smile,” though she quickly turns to Harry, more concerned again about him. Still, it’s a legitimate positive reaction to a compliment from Ron. We shouldn’t have to pause and reflect on that so much, except for the fact that this is a rather unique occurrence. Every other time Ron says something nice about Hermione, she ignores it, gets annoyed, dismisses it, gets suspicious or confused, or has some other negative reaction like we saw.
And even this one pleasant moment between Ron and Hermione is immediately undermined a few pages later:

Ron struggled for a moment before managing to extract his wand from his pocket.
‘It’s no wonder I can’t get it out, Hermione, you packed my old jeans, they’re tight.’
‘Oh, I’m so sorry,’ hissed Hermione, and as she dragged the waitress out of sight of the windows Harry heard her mutter a suggestion as to where Ron could stick his wand instead.

Yes, Ron was happy for a moment and praised Hermione for packing his stuff, but it turns out she did it wrong in Ron’s eyes. She packed the wrong jeans, and Hermione reacts very negatively, telling Ron to shove his wand up his arse. Hermione here must feel like Ron is conforming to the behavior she described back in OotP—he’s only nice until he turns back to his “normal” negative behavior toward her.

Harry complimenting Hermione to other people

We don’t really have space here to investigate the many other times Harry thinks highly of Hermione, is grateful for her, or appreciates some aspect of her in his internal thoughts. But it’s perhaps useful to end this exploration by noting how many other times Harry still manages to praise Hermione verbally, unprompted, to other people.
We can start with the scene that inspired Slughorn in the quotation discussed above, where Ron was disgruntled at Hermione’s ecstatic reaction to Harry’s compliment. See HBP4:

[Slughorn:] ‘Your mother was Muggle-born, of course. Couldn’t believe it when I found out. Thought she must have been pure-blood, she was so good.’
‘One of my best friends is Muggle-born,’ said Harry, ‘and she’s the best in our year.’

Note that there’s really no good reason for Harry to praise Hermione so specifically and highly here. Slughorn was discussing Lily, and Harry could have simply countered with the fact that he had talented Muggle-born friends too. Yet he singles out Hermione to compare to his mother’s talent and goes further—calling her the best student in his year.
Ron never has a comparable passage in the books. Many of his compliments or nice moments are very situational with Hermione, not spontaneous praise. This is probably one reason why Hermione also shushes Ron when he tries to echo Harry later with Slughorn: she knows if Harry said something, he meant it and wasn’t just trying to flatter her or be nice because of the situation.
The best Ron can manage on a couple occasions are vague acknowledgments to Harry about Hermione. Such as CoS14:

“What does she understand?” said Harry distractedly, still looking around, trying to tell where the voice had come from.
“Loads more than I do,” said Ron, shaking his head.

Not exactly a compliment, but this one makes lists of Ron’s compliments sometimes, just because it’s so rare for Ron to say something even this nice about Hermione. Even when Ron is clearly impressed by Hermione slapping Draco and then storming out of Trelawney’s class in PoA15, the most he can manage to say to Harry is:

‘Some day Hermione’s having, eh?’ Ron muttered to Harry, looking awed.

We’re told that Ron’s “looking awed” here, but he still can barely say anything directly praiseworthy about her.
Meanwhile, Harry simply cannot stop himself from saying how amazing Hermione is. As far back as CoS2:

‘Harry Potter asks if he can help Dobby ... Dobby has heard of your greatness, sir, but of your goodness, Dobby never knew ...’
Harry, who was feeling distinctly hot in the face, said, ‘Whatever you’ve heard about my greatness is a load of rubbish. I’m not even top of my year at Hogwarts, that’s Hermione, she –’
But he stopped quickly, because thinking about Hermione was painful.

Remember when we saw that Hermione tried to compliment Harry and tell him he was a great wizard in PS or the best in DADA in OotP? Harry couldn’t help deferring to Hermione, trying to praise her as better. The same thing happens when Dobby speaks of Harry’s “greatness” here—and Harry immediately thinks of the greatest person he knows: Hermione Granger.
Harry can’t even let the Quidditch team think he was smart enough to come up with the Impervius Charm for his glasses (originally during the Quidditch match back in PoA9). When Angelina proposes using the spell again in OotP18, Harry simply has to give Hermione credit:

[Angelina:] ‘[…] Harry, didn’t you do something to your glasses to stop the rain fogging them up when we played Hufflepuff in that storm?’
‘Hermione did it,’ said Harry. He pulled out his wand, tapped his glasses and said, ‘Impervius!’

It’s not exactly a compliment, but it just shows yet again how much he wants everyone to know how amazing Hermione is.
This reflex Harry has to praise Hermione comes up in the strangest places, getting him into arguments with his love interests. When Cho brings up the jinx that resulted in Marietta’s outbreak of pimples, Harry can’t help contradicting her (OotP28):

‘That was a really horrible trick of Hermione Granger’s,’ said Cho fiercely. ‘She should have told us she’d jinxed that list –’
‘I think it was a brilliant idea,’ said Harry coldly. Cho flushed and her eyes grew brighter.
‘Oh yes, I forgot – of course, if it was darling Hermione’s idea –’

Cho is actually quite insightful about the role of Hermione in Harry’s life here. She earlier got jealous when Harry prioritized Hermione on Valentine’s Day, and now she gets annoyed at how “brilliant” Harry considered “darling Hermione’s idea.”
Just as in Quidditch with his glasses, Harry can’t help acknowledging Hermione’s brilliance, even with another girl he likes. He could have been a little more diplomatic with Cho in disagreeing with her, but instead his reflex is to defend Hermione.
Perhaps the most absurd moment of praise for Hermione randomly comes up as Harry’s breaking up with Ginny (HBP30):

‘I never really gave up on you,’ [Ginny] said. ‘Not really. I always hoped ... Hermione told me to get on with life, maybe go out with some other people, relax a bit around you, because I never used to be able to talk if you were in the room, remember? And she thought you might take a bit more notice if I was a bit more – myself.’
‘Smart girl, that Hermione,’ said Harry, trying to smile.

Think about what’s going on in this moment. Ginny just admitted how strong her feelings for Harry are, that she “never really gave up” on him, from when she was a young girl. She’s effectively trying to inform him of her commitment, of his status as her first love. If Harry had deep feelings for Ginny, we might expect him at this point to recognize how long Ginny had cared, how much she had tried to learn to be “herself” around him, to get him to notice her.
And instead the first words from Harry’s lips are to acknowledge how smart Hermione is. He’s breaking up with his girlfriend… and praising another girl’s intelligence? I know Harry can be rather thick sometimes, but this is not the thing to do in the middle of a break-up. It’s no wonder Cho was so jealous of Hermione.

Conclusion

Once again, as in many of my other essays, I think we can see patterns emerging around Harry and Hermione’s unique relationship. We see them repeatedly praising each other spontaneously. And Harry can’t help but blurt out how brilliant Hermione is to other people, even in situations where it’s arguably inappropriate.
Ron’s efforts at compliments are nothing like that, unfortunately. We might even feel a bit bad for him when he does begin to make an effort in DH, as it’s clear Ron is never going to have the impact on Hermione that Harry’s compliments do.
I mentioned at the outset that there are many people who say Harry isn’t appreciative enough toward Hermione. It’s true that we don’t hear him say it aloud all the time, particularly in the early books. Yet it’s very clear even in the first book that Harry thinks Hermione is a better wizard than he is. And he doesn’t hesitate to tell her, or to announce it to Dobby in CoS.
As the series progresses, Harry’s outward appreciation increases, to the point where we see him calling her “amazing” and “incredible” and the “best in our year,” terms that he only ever says about Hermione. Perhaps even more importantly, we see that Hermione knows how special she is to Harry, how sincere his compliments are, as we see her repeatedly responding with emotional smiles and even a “radiant expression” to these words.
I didn’t even explore most of the passages where Hermione praises or compliments Harry in the books (and there are plenty more of those too), but we can see the strength of Harry and Hermione’s friendship and care for each other. They both strive to raise each other up, especially in stressful times when they need it the most.
I’d like to acknowledge members of the HMS Harmony Discord server for their support and suggestions. Specifically, thanks to Jiraffas for suggesting an essay on this topic. Thanks for Dragonfly for convincing me to include a section on Harry complimenting Hermione to other people and for reminding me of the Angelina moment in OotP. In general, I’m grateful for the discussion and commentary from the Harmony community.
If there are any moments you think I missed, please point them out in comments! I’d like this essay to be a resource for those who want to debunk fandom claims concerning Harry’s supposed lack of appreciation toward Hermione.

Just got an email from AG1 about some recent research and blind controls they’ve done. Came here to read what people’s thoughts were.
Email read as:
Hey mate,
I hope this finds you better than ever.
Very excited to tell you that we published the results of our first clinical trial on AG1 this week.
AG1 Daily Nutrients and Gut Health - Research Study
I’m so proud of the team and excited to share the results with you.
Most supplements rely only on third-party individual ingredient research to validate their claims.
Building on years of ingredient research and over 1,000 peer-reviewed studies to support the efficacy and safety of the individual ingredients in AG1, we have been doing the work to take it many steps further.
Our in-house Research team worked with independent scientists and labs to conduct a set of three studies on the complete AG1 formula.
This includes studying AG1 in an in vitro lab model simulating the human digestive tract, observing how it helps people feel over 90 days in an observational study, and now, validating those results with a randomized, placebo-controlled clinical trial.
We publish the methodology, results, and links to peer-reviewed publications here on our site.
Since 2010, I’ve been inspired to make taking ownership of your health through foundational nutrition simple, powerful and convenient.
AG1 is Foundational Nutrition. A daily supplement of micronutrients, phytonutrients, and gut health support.
AG1 is not a replacement for food. Whole food is always first.
AG1 is not a medicinal or megadose of herbs and extracts (that would not be foundational nor is this something you would ever want to do daily forever).
Daily nutrients and gut health. In one simple scoop every day, and done better than anyone else ever has in one product.
That is it, that is our promise.
These research studies are the latest milestone in our continuous pursuit of excellence. This commitment to research is ongoing, and we’ll use these results and learnings to power the development of future studies.
Click here to learn more → AG1 Daily Nutrients and Gut Health - Research Study
Thank you for being an awesome AG1 customer.
“100% Focus on Happiness” that is my mantra, and it starts with phenomenal health.
Best,
Chris “Kiwi” Ashenden Founder and CEO, AG1

Hello everyone! Its been 8 months since the original post I made. I've been busy with life in the meanwhile and just now I remembered I didn't post the completed retexture anywhere, I found a video about the making of the skins and uploaded the pack to google drive, sadly gamebanana and thunderstore requires a javascript code to automatically install any mod posted in their site, and besides me not knowing how to do this, its a very simple installation process.
As mentioned in the title, you can use DripRemix as its the easiest way, but feel free to change the game files if you prefer. To install with DripRemix, first you need to install the mod, then go to the BRC folder, open the ModdingFolder, go to BRC-Drip remix and extract the .rar, the files are already organized and will replace only the first or the "standard" skin for every character, if you prefer you can change the number on the end of the images you downloaded to change another skin, I'm not sure if dripremix allow more than the 4 original skins but I believe it does.
Feel free to use and modify my skins! Credit me if you want (and remember) and share the file with your friends!
(The video below shows only some skins that were done in the past, but the .rar have all the characters with black and white clothes!)
(PS: this is the third time i try posting with the video, if the video don't appear i'll link the original post in the comments)
Link: https://drive.google.com/file/d/1qalPv-xGY_AMo_VpsyODDgX-qtMOGmXY/view?usp=sharing

Hello everyone! I would like to have some help for a problem i have I want to extract two parameters: date_from: the start of the period date_to: the end of the period
I tried using this example but it sometimes misses at simple prompts
What can i add to make it better? Here’s the code i made
Basically i want it to get from the user’s prompt the correct date or period

1- If your team is not ready to leave yet, RUN AWAY from the landing zone once the 2-minute extraction countdown is over, Pelican one will hover above and provide POWERFUL covering fire around the landing zone until the end the game.
Edit: +1 Pelican one COULD BE damaged or destroyed, once it's damaged (ON FIRE) it WILL FLY AWAY when the FIRST diver gets on, so drop all the samples and let the diver carrying all the simples get on the ship.
+2 You can drop samples/gears by pressing "X".
2- No team needs more than 2 of the same backpack or support weapon.
3- DROP YOUR SUPPORT WEAPON AND GUARD DOGS FOR YOUR TEAMMATES ONCE THE COOLDOWN IS UP! DROP YOUR SUPPORT WEAPON AND GUARD DOGS FOR YOUR TEAMMATES ONCE THE COOLDOWN IS UP! DROP YOUR SUPPORT WEAPON AND GUARD DOGS FOR YOUR TEAMMATES ONCE THE COOLDOWN IS UP!
4- Mortars are always BAD for bugs unless it's the missile launch mission AND guard dogs are always BAD for bots.
5- You can adjust the radar by yourself, there is a sound cue once you hit the right spot. if you are not sure, dial it back, then listen for it again.
Those are just on the top of my head, you are welcome to add them.

Clover

Five humans, missing...

Spoilers for all of Undertale Yellow's main routes below
Undertale Yellow is a fan-made prequel to the hit indie game Undertale. While Undertale follows the story of Frisk, the seventh human child to fall into the monster ruled Underground, Undertale Yellow follows the story of their immediate predecessor. Meet Clover, the sixth human. Unlike the humans that fell before, this gun-toting cowboy is unique in the sense that their journey to the Underground was no accident. Clover entered the Underground voluntarily in order to investigate the disappearances of the previous five humans and, if it turned out they perished at some point after their fall, hoped to avenge their deaths. See, while Frisk possessed a red SOUL that embodied Determination, Clover's SOUL is yellow for the trait of Justice. Clover's journey would lead them all throughout the Underground, meeting some monsters that will be familiar to those who have played Undertale and some brand new faces as well.
Like Undertale before it, Undertale Yellow's story can be altered significantly depending on the player's actions. Perhaps Clover befriends the monsters they meet and determines they were unfairly trapped underground, deciding to sacrifice themselves to bring monster kind closer to freedom. Or maybe Clover will blame the monsters for the deaths of the previous human children, avenging them with swift cruelty. Either way, Clover will act in the way they believe they can best embody Justice.

So How Do the Fights Work Anyway?

Like its predecessor, Undertale Yellow tends to treat RPG mechanics as literal aspects of the game's world. Due to the abstract nature of fights in both Undertale and Undertale Yellow, with enemy monsters targeting Clover's SOUL rather than their physical body, it's understandable that there may be some confusion about how Clover actually scales to certain monsters. Luckily, this is a bit more clear in Undertale Yellow than it was in the original game, as the reveal trailer shows that the attacks of monster are things that Clover physically has to react to and dodge (we even see this same attack utilized in game) even though the battle menu only shows their SOUL.
But this is just for when encounters have already begun, what about before that? And what triggers encounters anyway? There's an area in the Wild East where boulders are falling onto the path that Clover needs to dodge. If they fail to avoid them, this begins an encounter too, where Clover is given the opportunity to avoid the "attacks" in the battle menu to negate damage. Other examples include Clover escaping damage from hot steam after touching it and avoiding damage from Axis' energy balls after they hit them. What this means for standard versus fights is a little vague, but it likely means that any attack that would deal meaningful damage starts an encounter and that it would be impossible to simply kill Clover with a sneak attack. Even if it hit them, Clover would still get the opportunity to dodge before the proper fight begins. That said, there is one example of Clover dying without triggering an encounter at the end of the Neutral Route. It's possible this is because it was an unescapable situation but the mechanics of it are still vague and unclear.
As seen with the previous examples such as the falling boulders and steam, it seems that attacks that hit Clover's SOUL and their physical body are more or less interchangeable. Or rather, it isn't possible to circumvent the SOUL to only hit the physical body because even attacks that hit Clover's physical body will trigger an encounter that can then be dodged or endured by the SOUL.
Finally, it's worth noting that the sizes of objects can vary from their appearances in the battle to what they look like in the overworld. We see Clover's SOUL alongside their physical body a few times throughout the game and it's pretty consistently a little larger than their torso. So this thread will describe feats with that scale in mind.

Other Things To Note

• At the end of certain routes, Clover acquires certain abilities/powerups that don't necessarily apply to the rest of the game. Feats or items that are limited to those routes will be marked with the corresponding route.
  
  • [Pacifist] Feat
• Like your standard RPG's, Undertale Yellow possesses a leveling system that will increase the more enemies that Clover kills, with certain abilities being unlocked after certain levels are achieved. However, in the Genocide route Clover showed off the ability to level up rapidly simply by being filled with enough righteous fury. Abilities that are locked behind certain levels will also be marked accordingly.
  
  • Feat^{LV 19}
• The majority of feats will come from Undertale Yellow, but occasionally clips from trailers and other promotional material on the director of the game's Youtube channel will be used, which will be labeled with a T like so:
  
  • Feat^T

Physicals

Strength

• Breaks a piece of wood that had jammed an elevator door with a pickaxe, which broke the pickaxe despite it being described as sturdy previously
• Pushes aside a cabinet
• While physically holding the lid of a trash can Clover is able to deflect Axis' energy attacks back at him which destroyed portable generators about as tall as Axis himself
  • Clover also uses this lid to deflect Axis' bombs
• [Anti-Feat] Needs Martlet's help moving a table

Speed/Agility

• Runs roughly 2/3rds faster than they walk, traveling the same distance in 1.5 seconds that it took them 2.5 seconds to walk
• Climbs a good distance up a rope, though Flowey resets the timeline before they reach the top
• While fighting Decibat they react and move relatively to various attacks that appear to be sound-based
  • Note that blue attacks don't harm you if you're standing still and orange attacks don't if you're moving
• Passes over a bridge when the boards were constantly elevating and lowering
• Moves out of the way of Dunebud's arrows
  • We see in the game's reveal trailer that these arrows move much faster than their in-game counterparts would suggest
• Avoids the soundwaves produced by Starlo's bell attack
• Escapes Axis during their chase
• Jukes the hell out of Axis
• Moves relatively to the arrows and flintlock pistol shots of a pair of mini robots
• Climbs a laundry chute

Durability
Blunt

• A tumbleweed knocks them onto a lower platform and they don't even flinch
• Even while using the Patch, Clover's starting accessory that offers no extra defense, Clover can withstand several giant boulders smashing into them
  • While using the Steel Buckle or superior defensive items, this damage is totally negligible
• Takes several blows from Ed that launch massive boulders into the air
• Withstands the Guardener's attacks which could smash giant gears that are larger than Clover
• [Genocide] Gets hit by large meteors summoned by Zenith Martlet

Falling

• Jumps down a hole into the Underground and lands on a bed of flowers
• Falls through the floor of the Ruins and lands in a bed of flowers in the Dark Ruins, quickly jumping to their feet afterwards
• Crashes a speeding boat over a ledge, sending them over and into the mines
  • Flowey did comment they seemed pretty hurt by this
• Falls down a trap door

Heat

• Survives in the Steamworks with no issue, which was hot enough to light Moe's clothes and stand on fire over the course of their conversation
• Withstands multiple fire attacks from Asgore before eventually succumbing to them (with Asgore being the strongest non-final boss monster in the original Undertale)

Other

• Gets shocked repeatedly by Dalv's electrical attacks, enduring four before eventually succumbing
• A giant fan produces a sandstorm that pushes them back a considerable distance
• Gets hit by dynamite thrown by Starlo
• Survives multiple shots from Starlo's revolver
• Withstands hits from Axis' energy balls which later destroy Axis' portal generators
  • During Axis' boss fight, Clover takes no damage from this at all
• With the highest defensive accessory they take negligible damage from Ceroba's attacks which shatter stone pillars (they also take a glancing blow from these attacks in a cutscene without damage, though it takes them some time to return to their feet)
  • [Pacifist] Clover later withstands Ceroba's attacks after she had powered up into her Kitsune form, which dealt double damage compared to her previous attacks (2HP with the best defensive item instead of 1HP)
• [Pacifist] Endures for a little over a minute after their soul had been extracted from their body (though they were too weak to do anything but crawl)
• [Genocide] Gets crushed by blocks with enough force to shatter them which are not affected by their SOUL's energy beams
• [Genocide] Here is the top of UG Apartments before Clover's battle with Zenith Martlet compared to after, which assuming Martlet's attacks were responsible for any of this damage means that Clover would scale to it
• [Genocide] Clover grows so powerful that Asgore's trident shatters against their SOUL^{LV 20}

Skill

• Shoots a hat off a dummy
• Beats Starlo in a quickdraw contest
• After being fully lasso'd by Starlo, Clover is still able to effectively avoid his attacks and even tricks him into shooting his own lasso twice
  • Starlo is accurate enough to shoot sticks of dynamite out of the air
  • Clover is still able to fight back as well
• Can shoot something as small as a micro froggit
• Opens a door by shooting its control panel
• Plays a mean harmonica^T
• Holy shit they're so sick with it^T

Justice SOUL

• Flowey talks about how Boss Monsters are stronger than others and that a human SOUL is even more powerful than them
• [Pacifist] During the final boss, Clover is powered up and given a plethora of different abilities (the reason for this isn't explicitly stated, but it's likely because they felt their cause was just, more so than they ever had in the rest of the game)^{LV 1}
  • [Pacifist] Endures repeated enraged attacks from Ceroba that should have killed them before returning to full HP as the next phase of the boss starts^{LV 1}
  • [Pacifist] Can fire energy blasts from their SOUL which are strong enough to overpower Ceroba's own charged blasts^{LV 1}
    • They can quickly fire smaller shots on top of the more powerful charge shots^{LV 1}
    • A weaker version of Ceroba's attacks could shatter stone pillars^{LV 1}
  • [Pacifist] Is able to phase through attacks, including otherwise unavoidable AOE attacks^{LV 1}
  • [Pacifist] Clover is able to Hope, allowing them to take an extra hit without damage^{LV 1}
  • [Pacifist] Clover is able to Endure, regenerating health from a range of 5HP to 10HP^{LV 1}
  • [Pacifist] Clover is able to Remember, granting them a speed buff over the course of that turn^{LV 1}
  • [Pacifist] After cracking Ceroba's Kitsune mask, Clover is able to see a memory of her past talking to her dying husband^{LV 1}
• [Genocide] After hearing that Axis, the penultimate boss, killed a human child, Clover is filled with such rage and a desire for justice that they automatically leveled up and developed the ability to shoot energy blasts from their SOUL. The first blast obliterated the trash can lid Axis was using as a shield and after further leveling up they fired a massive beam that obliterated Axis entirely. Clover also gained an assortment of other abilities at this point^{LV 15/19}
  • [Genocide] Smaller shots can be rapid fired and a brief charge allows Clover to fire the beam^{LV 19}
    • [Genocide] It required two small shots to destroy the meteors Zenith Martlet summons and they're completely obliterated by the beam^{LV 19}
    • [Genocide] With enough shots Clover destroys Martlet's armor that their gun was completely useless against (based on the fact that the Fight button is locked during the phase of the fight that she's wearing the armor)^{LV 19}
    • [Genocide] Clover's beam is strong enough to completely obliterate Asgore as well as his throne and the wall behind him^{LV 20}
  • [Genocide] Like in the Pacifist ending, Clover is able to dash which smashes blocks that their shots and beams couldn't break and allows them to phase through otherwise unavoidable attacks without damage^{LV 19}
  • [Genocide] After destroying Martlet's armor, Clover is able to see into mind and witness her backstory^{LV 19}
  • [Genocide] Clover is able to Endure, automatically recovering anywhere from 20HP to 25HP^{LV 19}
  • [Genocide] Here is the top of UG Apartments before Clover's battle with Zenith Martlet compared to after, with Clover presumably being responsible for at least some of the damage^{LV 19}
• [Genocide] Throughout the game, Clover is able to undo mistakes thanks to the SAVE function. Primarily, this is thanks to Flowey doing so for you, becoming an in-universe stand-in for standard RPG Saving and Loading and ultimately allowing them to revive at the latest SAVE point for standard enemies or directly back into the battle for Boss encounters. However, at the end of the Genocide route Clover levels up enough to steal Flowey's control of the timeline, ultimately taking the SAVE ability for themselves which they can use to SAVE and LOAD in the middle of battle^{LV 20}

Gear

Note that while Clover can store excess items in boxes they find around the Underground, they can only carry eight items in their inventory not including their current Weapon, Ammo, Armor, and Accessory. Later in the game they discovered the Dimensional Satchel which allows them to access the boxes from anywhere, but they still only have eight slots to bring into an encounter.
Weapons
Guns

• Toy Gun - Clover's default weapon is a simple toy gun
• Wild Revolver - A gift from Starlo, purchased from Blackjack's shop
  • While the Toy Gun only fires once per turn, the Wild Revolver is fired six times in a row
  • While the Wild Revolver looks and functions like a typical revolver, note that Blackjack does say that he made it so as not to be lethal (though the following line about how anything could be lethal if used enough times consecutively makes this seem more like a meta joke about RPG fight mechanics, even going so far as to mention the ballet shoes that are a weapon in the original Undertale)

Feats
Note that cutscenes will always play out the same regardless of whether the Toy Gun or Wild Revolver is being used, so while the Revolver is obviously the more powerful of the two the Toy Gun is much more powerful than it's name would suggest and the following feats apply to both weapons.

• Damages machinery
• Critically damages Axis who could withstand his own energy balls being reflected back at him with no physical damage, merely draining his power instead
  • After being rebounded Axis' attacks destroyed portable generators as tall as Axis himself
• Destroys robots with repeated shots
• Executes undamaged monsters in cutscenes/scripted fights in both the Pacifist and Genocide routes
• [Anti-Feat] Was unable to destroy the trash can lid Axis was using as a shield

Ammo
Rather amusingly, Clover will jam whatever odd materials they can find into their weapon which somehow works perfectly^T

• Rubber Ammo (AT 0) - The default ammo that Clover started their journey with
  • Toy Gun Wild Revolver
• Pebble Ammo (AT 3) - Small rocks that Clover discovered in the Dark Ruins
  • Toy Gun Wild Revolver
• Ice Ammo (AT 6) - Discovered near the start of Snowdin, these fragments of a shattered ice crystal don't melt and cool Clover's gun upon being loaded
  • Toy Gun Wild Revolver
• Coffee Ammo (AT 4 + 1 SPEED after perfect attack) - Found in a barrel near the exit of Snowdin
  • Toy Gun Wild Revolver
  • Compare the increased speed to Clover's normal battle speed
• Flint Ammo (AT 9) - Salvaged from an ore deposit outside the East Mines
  • Toy Gun Wild Revolver
    • Note that the shots make small explosions upon impact
• Glass Ammo (AT 5 + 2HP) - Taken from a shattered glass in the Dunes Gift Shop
  • Toy Gun Wild Revolver
• Silver Ammo (AT 3 + Bonus Damage for Perfect Shot) - Purchased from Blackjack's shop
  • Toy Gun Wild Revolver
• Nails (AT 10) - Found in a box in the Steamworks greenhouse
  • Toy Gun Wild Revolver
• [Neutral/Genocide] Friendliness Pellets (AT 11) - A gift from Flowey, acquired outside of the Steamworks
  • Toy Gun Wild Revolver

Armor

• Warn Hat - The default armor that Clover started their journey with
• [Pacifist/Neutral] Nice Hat - Visually identical to Clover's old one and offers no extra defense or benefits, but it is a pretty nice hat

Accessories

• Patch (Armor DF 0) - The default accessory that Clover started their journey with
• Feather (Armor DF 2) - A stray feather located in the tunnels near Dalv's house
• Honeydew Pin (Armor DF 4) - Purchased at the Honeydew Resort shop
• Band Merch Pin (Armor DF 5) - A pin given to Clover by a band's super fan in Honeydew Resort
• Steel Buckle (Armor DF 7) - Found inside a cubby in the East Mines
• Safety Jacket (Armor DF 6) - Found on a hook in the East Mines
• Fancy Holster (Armor DF 8) - Purchased from Blackjack's shop
• Safety Goggles (Armor DF 9) - Acquired from Vendy in the Steamworks
• Silver Scarf (Armor DF 6 and +2HP Every Turn) - Given to Clover by Slurpy in Snowdin after freeing his tongue from a frozen pole
  • Here is the scarf in use
• Delta Run Patch (Armor DF 10) - Purchased from Bits and Bites at UG Apartments
• Golden Bandana (Armor DF 12) - Found in a chest in the Steamworks
  • This did come at the cost of sacrificing the Golden Pear, Golden Coffee, and Golden Cactus

Food/Healing Items
Note that at their weakest (LV 1), Clover has 20HP and at their strongest (LV20), Clover has 100HP
Single Use

• Lemonade - 7HP
• Lukewarm Pop - 8HP
• Candy Corn - 9HP
• Packing Peanuts - 10HP
• Sea Tea - 10HP (+ Temporary Speed Increase)
  • Here is the Sea Tea in use
• Monster Candy - 10HP
• Corn Dog - 12HP
• Cold Pop - 12 HP
• Sponge Cake - 14HP
• Hot Pop -14 HP
• Trail Mix - 14HP
• Corn Chowder - 15HP
• Moss Salad - 17HP
• Ice Tea - 20HP
• Green Tea - 21HP
• Flower Stew - 20HP
• Hot Dog - 20HP
• Fruitcake -25HP
• [Pacifist/Genocide] Adult Soda - ???HP
  • It's actually 20HP
• [Genocide] Oasis Latte - 25HP
• [Neutral] Cake - 30HP
• [Genocide] Cinnamon Cookie - 35HP
• Golden Pear - Invulnerability for two hits
  • Here is the G. Pear in use
• Golden Coffee - Increases Clover's speed for 3 turns
  • Here is the G. Coffee in use (also note that this buff carries on to future encounters if the three turns aren't used)
• Golden Cactus - 15HP for 3 turns (Lose 5HP after first bite)

Two Uses

• Grassy Fries - 14HP
• Beef Jerky - 16HP

Unlimited Supply

• Spider Donut - 12HP
• Popato Chisps - 13HP
• Honeydew Coffee - 14HP
• Honeydew Pancake - 16HP
• Ice Water - 15HP
• Monster Candy+ - 15HP
• Root Beer - 18HP
• G.B. Bear - 20HP
• Dihydrogen Monoxide - 20HP
• Feisty Slider - 30HP
• Gravity Granola - 30HP
• Cinnamon Butterscotch Strudel - 30HP
• Floral Cupcake - 50HP
• Gun Powder - ???HP
  • Completely maxes out Clover's HP
  • Note that Clover can only acquire one of these on the Genocide Route

Misc

• Solves Martlet's extremely complicated lava rock puzzle
• Beats the infamous Shuffler gang at their own game
• Uses flint and a steel buckle to burn a thick stick that was jamming an elevator
• Keeps up with El Bailador during their dance off, who was out of breath after the fact
• [Pacifist/Neutral] The Doc in the Wild East can overcharge Clover's health with a one time extra 15HP (nearly double their health at LV 1)
• Stealthily creeps around the Steamworks factory, figuring out a passcode while staying out of Axis' view
• Clover has incredible willpower, since even after Flowey kills them and attempts to absorb their SOUL, Clover is able to resist him for the entirety of the ensuing boss fight which ends when Flowey realizes they'd be fighting for all eternity if they continued and opts to simply reset the timeline instead
• Breaks it down

Somebody calls for help
You answer the call

Link for all the chapters available here: Engines of Arachnea on Royal Road
Having said his piece, Rene had expected the woman to accept her role as a prisoner of the Fleet. But no sooner had he taken his knee of her back than she was at him again, rolling over and cursing as she tried to spit him on her claws. Training kicked in and Rene applied the wrestling component of his hand-to-hand combat course. He secured underhooks with his arms, locking them together with his hands and hugging her tight from behind. Zildiz bucked and twisted around in a futile attempt to make room for her blades, even managing to get one of her knees beneath her and push off the ground. Rene allowed her to gain her feet, cunningly using the opening to slip the loop of his encircling arms around her waist. Now in complete control of her center of gravity, Rene swung his leg out and arched his back, heaving her up and over like a sack of turnips in a textbook suplex. A fraction of a second before he smashed the top of her skull into the hard ground, he remembered that he was supposed to keep prisoners alive and preferably not in a vegetative state, and so he cushioned the fall with his own body, falling on his side to increase surface area and dissipate the force.
Zildiz was caught totally by surprise. Unlike Rene she had neglected to tuck in her chin before the moment of impact, a vital detail which was one of the first things a recruit was taught to do on the mats.
“Oof!” she said as all the breath slammed out of her by the throw. Rene felt her body go limp as her dazed senses tried to adjust to the violent change of orientation. He took advantage of this moment of weakness and looped his legs around her body, locking his ankles together to form a full body triangle. His left forearm punched up and took her neck in a rear naked choke, a suffocating vise formed by the insides of his elbow crushing her windpipe and carotid arteries.
“I warned you,” he told her. His choking hand grabbed the inside of his other elbow, right forearm sneaking behind her neck and under his armpit, tightening the garrote even further.
“Had enough?”
“Hrrnnkk…” Zildiz choked. She lifted an arm and slid back the blade until it was the length of a finger, deliberately giving Rene the universal gesture to go and fornicate with himself, before sheathing the claw entirely and aiming her fist at him over her shoulder.
Rene ducked as the blade shot out again, only just avoiding it going through his eye socket and into his brain. As it was, it only nicked his temple, sending warm lines of blood trickling down his visor. Rene hugged her even tighter, constricting the chokehold until he heard her breathing reduced to an agonized wheeze. He throttled her until she stopped moving, her struggles weakening until she went completely lax. Then he held the choke for exactly three seconds longer, counting carefully to avoid giving her lasting brain damage. He let go and was relieved to hear her snoring faintly. Gently rolling her onto her back so she didn’t suffocate in the dirt, Rene cast about for a means to secure his prisoner. He had only a few seconds before she regained consciousness. Quickly he cut some vines from the surrounding trees and knotted them into a crude rope. He flipped her back over again and tied her hands at the wrists and elbows. He had no illusions that it would hold her for long. He tied her wings together at their bases for good measure. She had two sets of them, but the larger pair was missing one of its partners that had been torn off at the socket to reveal a gaping wound. They were wondrously tough membranes considering how thin and flexible they were, as sturdy as ultrapod leather. Rene looked over his work and loosened it a bit so as not to cut off the circulation in her arms. It wasn’t bad for something done on the fly. Then again, he’d been playing this whole thing by ear ever since the ambush that had cut his unit to pieces. Ye gods, but that whole experience felt like a lifetime ago. He had not expected to ever use that component of his hand-to-hand training designed for fighting human opponents. Of course, he’d helped put down a fair share of civil unrest in his time, but even during the worst of the food riots in Mound Ulysses he’d never so much as given a person a light shove. The civilians knew better than to antagonize a battalion of the Fleet’s finest over something as routine and reoccurring as a government rationing in the face of crop failure.
He felt quite bad about having to roughhouse the woman, that is, until she sat up awake and glowered hatefully at him, coughing and retching.
“Don’t,” he pleaded with her in exasperation as she gave him the old stink eye, “I don’t want to fight you again.”
“Why?” she spat defiantly, “Afraid you’d lose?”
“Uh huh,” Rene grunted, amused and even a little impressed by her spunk. She couldn’t have weighed more than sixty kilos soaking wet and was at least half a foot shorter than him even with that exomorph of hers, but this woman was all fight and no quit. She would have to be, living on the surface world and facing these abominations day after day. Rene looked at the dismembered corpses of the black-furred devils and had a sudden jolt of inspiration. As Zildiz tested the strength of her restraints Rene went over to the monster he had chopped to bits and poked the misshapen hump on its back, which had excreted thick ribbons of silk at the moment of death. Feeling more than a little squeamish, Rene pulled on the threads of silk. He had only meant to collect two or three meters of the material, but more and more of the stuff kept unwinding out its glands like a handkerchief from a magician’s pocket. Eventually his hands became enmeshed in the horrid stuff and he had to struggle like the dickens to unstick himself and scrape it off onto a bush where it stuck like a lumpy hammock. Remembering how his enemy had plugged the stab wound in its gut, Rene snapped off a twig and curled it into the white mess like those vendors at the fairs did with candy cloud treats, ending up with a spool of silk. He applied it to the cut on his temple by winding it around his head like a bandage, and was gratified when it stopped the bleeding almost immediately. He heard the rustle of dead leaves and turned around to find Zildiz furtively attempting to sidle away from him.
“Don’t even try it,” he told her, “Or I’ll run you down and knock you senseless. I’m taking you back to civilization. The Fleet needs to know what it’s up against out here, and you’re a veritable trove of information.”
Zildiz squatted back down and stared at him, simmering with resentment. Rene shook his head and continued his work, moving on to the monster that had been the first to die at the woman’s hands. Cutting open its hump, Rene was rewarded with a dense lump of thread still packed inside its spinneret. He took another twig and spooled it in, then wrapped the bundle of silk in a large leaf.
A leg twitched of its own accord. Rene nearly dropped the bundle as he sprang back, sword upraised. The devil’s limbs began doing a tap dance and Rene relaxed a bit, recognizing it as the onset of rigor mortis. The side of its face was split open and hanging loosely by a strap of flesh. Struck by a nagging suspicion, Rene stooped down and peeled off the segments of its head, holding the edge of his sword against its neck to decapitate it in the event that it proved too lively for his liking.
The musculature and armor tore away just like it had with Zildiz’s helm, and for the second time that night he found himself staring into the face of another living human being. Only this time it was a man whose face was utterly disfigured, a perversion of the basic form. In the place of his lower jaw were fingerlike protrusions of gummy tissue and exposed nerve endings. His nose cartilage was likewise missing, leaving only a pair of holes dribbling with snot. The man blinked, and glassy eyes with almost no whites at their edges fixed Rene in their gaze.
“Kill…me…” the man whispered.
Rene began to shake uncontrollably, wiping a trembling hand across his mouth as he was forced to consider the carnage he’d just wrought in a new and horrifying light. These weren’t three dead monsters littering the jungle floor; these were three dead men, and some of them he had killed himself.
“Kill me!” the man begged him. He was young, barely Rene’s age, his smooth skin untroubled by the wrinkles of age and worry. He had clear brown pupils and dark, expressive brows. If it weren’t for all the rest of him, Rene might’ve mistaken him for a fresh-faced recruit at the academy, or a paperboy climbing up the terraced apartments of inner hive to deliver news of the Fleet’s latest victory.
On unsteady legs Rene staggered back to Zildiz’s side and away from the awful truth he had uncovered.
“Something the matter?” Zildiz asked in a gleeful tone, “Feeling a little worse for wear, are we?”
“Shut it,” Rene said distantly. He dragged Zildiz to her feet and began winding the silk around her wrists, layering them over thick and tying them off with a simple knot. He kept the vines on her for added insurance and told her to start walking.
“Where to?” she demanded.
“I’m not feeding you to my children, if that’s what you’re asking,” he muttered, “I don’t have any to begin with, and even if I did, I sure as hell wouldn’t raise them to be cannibals.”
Zildiz didn’t move, so Rene grabbed her and frog marched her away. He had no real destination in mind—he just had to get away from this place and the bodies he’d made. Zildiz rounded on Rene, saying:
“Aren’t you going to deal with him? I only severed his neural connection to paralyze his exomorph. He’s still very much alive.”
“No!” Rene yelled, “That’s not how I—how people do things. Almighty ancestors, is that so hard for you to grasp?”
“Yes,” Zildiz replied quite candidly.
“He’s a living, breathing human being. I don’t know if you’ve heard, but those are pretty rare on Arachnea and worth keeping around.”
“No. He is a Leaper. After extracting your gilt helix, he and his packmates would devoured you right then and there.”
“That’s why you saved me, isn’t it? So they couldn’t obtain this shiny helix thing?”
Zildiz ignored his question, continuing:
“If you leave him here, at best he will die of exposure. At worst, his tribe will come looking for him, and if they find him, they will run us down and kill us anyway.”
Rene bit his lip. She spoke the truth and they both knew it. But after all this world had already taken from him, there remained one thing which he refused to part with. And Rene knew that if he gave in now and took the expedient option—the sensible option—he would be surrendering it forever.
“Sorry,” he said finally, “That’s against the rules.”
He dragged Zildiz over to the Leaper and spoke to him, saying:
“I won’t kill you. I’m not about to eat you either, so you can stop begging for a quick death. As long as you tell me what I want to know, we’ll leave you here and go our separate ways. I might even patch your wounds if you’re cooperative. Does that strike you as a fair bargain?”
The Leaper met this pronouncement with a look of utter perplexity that mirrored the one on Zildiz’s face.
“I’ll take that silence as a yes,” Rene said impatiently, “You’ll begin by telling me your name.”
“Kryptusshh,” the Leaper said slowly, as if not daring to hope.
“Very good. Are there any more of your people out there, Kryptus?”
“Why sshhould I trusht you? I would only be dooming more of my kindred, and there issh no certainty you would not kill me afterwardssh.”
“It’s a chance you have to take,” Rene shrugged, “Either that, or I’ll let this woman do as she pleases with you. And just between you and me,” he said in a loud stage whisper, “She doesn’t seem all that fond of your sort.”
Zildiz and Kryptus locked eyes with each other. Rene could almost feel the waves of hatred coming off her as she bristled, every tendon in her body tensing expectantly. Kryptus must have seen something he didn’t like, for he looked away and said:
“I am a warrior of the Weeping Vipersh. We are roughly eleven hundred sshtrong. One tenth of that number are bravesshh like me.”
“He lies,” Zildiz said, baring her teeth in a snarl, “That is less than half their true strength. He does not count the adolescents and the old loom-mothers, who are the deadliest of their kind.”
“Three hundred, then, if they are consshidered,” Kryptman quickly admitted, “Your pardon, merciful one.”
“I’ll excuse your forgetfulness just this once,” Rene warned, “But your memory better not fail you again.”
He questioned the Leaper closely. Kryptus claimed that only he and his pack had seen the safety pod’s crash landing, and that they had told no one else as they wished to claim the great prize all for themselves. The Weeping Vipers were the largest tribe in the rainforest and were always looking for an advantage over their numerous and belligerent neighbors. Apparently Kryptus had hoped to gain a modicum of the Divine Engine’s power by extracting something called a ‘gilt helix’ from Rene’s blood.
“Jussht one sample would have shatishfied uss,” Kryptus swore, “Then we would have taken you back to the Loom alive.”
“I’m sure nothing would’ve pleased you better,” Rene said wryly, all too cognizant of Zildiz’s earlier assumption that he planned to feed her to the Fleet’s youth.
Rene learned from Kryptus that the Divine Engine had ignited a blazing wildfire that was swiftly spreading north and west. The tribes would likely have noticed it by now, and would all be sending braves in a joint effort to douse the flames. For some reason all the Leapers felt collectively responsible for the wellbeing of the region, and could not allow it to come to harm for fear of dire repercussions.
“Last question. Is anyone going to come looking for you?”
“Not till the morning.”
“Good!” said Zildiz, breaking out of Rene’s grip and aiming a vicious kick at the side of the Leaper’s head. Rene barely caught her and yanked her back, shouting:
“Blood and thunder, woman! Is there nothing you won’t do to piss me off?”
“Are you insane? You cannot possibly mean to leave him alive!” the Gallivant hissed.
“That’s exactly what I’m going to do. Now come here!”
Rene took her by the elbow and pulled her forward, leaving Kryptus where he lay.
“You promished you would tend to my woundssh!” the Leaper cried after them.
“Don’t push your luck!” Rene said over his shoulder, “Anyone who follows us will meet the same end as your friends.”
He and his prisoner went tramping off into the night, Zildiz raging at him all the while.
“Fool! We will both come to regret that decision!”
“You’re probably right,” Rene had to agree.
“Then why did you do it?”
“For the same reason I’m letting you strut around and screech into my ear. What can I say? I’m a conversationalist.”
Link for all the chapters available here: Engines of Arachnea on Royal Road

It's super simple but took me FOREVER to figure out.
Step 1: Download the latest LINUX release of PokeRogue from the GitHub repo: https://github.com/Admiral-Billy/Pokerogue-App/releases/tag/v2.3.1
Step 2: Extract and put the folder wherever you want to store the game
Step 3: Run the executable and the move to the top menu, and download the files for offline play.
Step 4: Once all the files are downloaded, exit the game.
Step 5: add the executable to steam
Step 6: Switch over to gaming mode
Step 7: find the PokeRogue game in your non-steam games, and go into properties.
Step 8: add the following to your launch options: --no-sandbox
Step 9 (optional): Go into the controller settings and change the right trackpad to be a mouse, and change click to be left click. Then, change one of the back-buttons (I use R4) to be Alt. Alt will show/hide the top menu, so you can change wether you're on/offline.
Step 10: Run the game! You should be able to play with the default gamepad config, in fullscreen, and switch between on and offline whenever you want!
Let me know if there's any issues with the steps and wether anything needs clarification!

Hi all!
Pretty new to Python in general and to Pandas in particular. I have successfully extracted data from an API, but I am running into a problem.
I have a very simple DataFrame with two columns. The values in the second column are in lists, but I would like to extract only the numerical values from these and replace the current data in that column.
This is what the df looks like:

kommunkod	values
0114	[50101]
0115	[34999]
0117	[49271]

This is what I'd like to achieve:

kommunkod	values
0114	50101
0115	34999
0117	49271

Thankful for ant pointers on this!