RowUpdating ve RowUpdated

How to Survive Camping - a bridle of flesh

2020.12.02 07:06 fainting--goat How to Survive Camping - a bridle of flesh

I run a private campground. Last post I said that I might not survive to post again, but here we are. I’ve got stitches in my forehead, I’m on a decent amount of pain meds, and my brother will hate me if he ever finds out what I’ve done. But I’m alive.
If you’re new here, you should really start at the beginning, and if you’re totally lost, this might help.
I went to the family graveyard just after dawn. It felt like the right thing to do. I sat in front of my parent’s gravestone and stared at the matching dates of when they died. I’ve faced my own death before. I hear it every night, skulking outside the window, circling the house in search of the little girl from which it takes its appeasement. Yet that is a vague future and I fear it in much the same way that you may fear a cancer diagnosis or a car crash. It is one of many possible ends. It can be held at bay in the mind as a remote possibility.
What I contemplated that morning was a death so close at hand I could feel its breath on the back of my neck. There was a deadline. It is one thing to expect to die. It is another to be able to count the minutes.
I think I sought some kind of peace. The presence of my parents, perhaps. But my vigil only served to remind me that they are dead and gone and I was facing this alone.
It was almost a relief when the sun rose, for I could at least get moving and feel like I was doing something to save myself and my niece.
There was a bundle on the porch when I returned to my house. At first I thought it was a dead snake, then I thought it was rope. As I drew closer I saw the buckles and realized it was a crafted item, the leather thongs cut as thin as embroidery floss. Tentatively, I picked it up and let it unfold, trying to decipher the fastenings and in what arrangement they were supposed to lay. The leather was soft and supple and I thought it would break, when I tested one of the cords for strength. It held, however, and the more I tried the more I realized that it was not going to break, not for me, or any creature human or otherwise.
I’ve seen such craftsmanship before.
A gift from the harvesters.
It was a bridle. A bridle cut from the strip of skin they took from my brother.
I was revolted just holding it. How could I not be? The feel of my brother’s skin, so soon after watching him suffer as it was peeled from his arm. Under ordinary circumstances I think I would have hurled it into the bottom of a desk drawer and tried to forget about its existence. But desperation allows us to do things that were once detestable. It is a powerful force.
I took the bridle with me.
The old sheriff had offered his help with this problem, but I’d turned him down. This wasn’t something we could fix with guns. What kind of gun do you use to take down something the size of an elephant, anyway? No, this was a problem that had to be solved with inhuman means. My normal allies didn’t have the ability. Beau at least seemed to approve of the plan, when I told him, though I couldn’t tell if it was because it would work or if he was pleased that the dapple-gray stallion wouldn’t see it coming.
That’s right. For all you smartasses in the comments last post, it’s Kate coming out of the corner with a steel chair.
(also, not sure what that “NFC” stuff was about, but if it has anything to do with old land, could the owner I dunno, message me or something? We should chat)
I went to my neighbor’s property. The one with the lake. I stood at the edge and took a deep breath. It was quite a bit early, but I didn’t have any better ideas. This had to work. I had to make it work. So I mustered all that anger and frustration and I piled it into my chest and then with all the strength I had, I yelled down at the water.
“Hey assholes!” I cried. “Do you want to help me save Christmas?”
For a few minutes, nothing happened. I stood there with my heart hammering, feeling mildly self-conscious, and waited. If they didn’t show, I told myself, I would swim down to the bottom of that lake and drag them up. Then, just as I was getting ready to yell again, a single ripple appeared in the center of the lake. It spread outwards until it reached the bank and vanished. As soon as the water had returned to a mirror surface, the stillness shattered again. The surface churned, fairly boiling with activity, and then a horse’s head surged out of the water. It ducked its head, forelegs straining to drag it upwards, and then the rider broke through the surface. He sat proudly on the horse’s back, unstirred by its struggles, back straight with one hand on the reins, the other on the hilt of his sword. The pointed tip on his helmet glinted in the bright sunlight. Around him, the water continued to churn as more horses and their riders appeared, climbing their way out of the water and stamping to a stop in a row in front of me.
My “summoning ritual” had worked. The shulikun had come.
The lead rider leaned down out of the saddle, putting his face close to mine. He smelled strongly of peppermint.
“We don’t care to be insulted,” he said sternly.
“I knew it’d get your attention.”
“You play a dangerous game here, camp manager.”
He swung himself back in the saddle, leaving behind a faint scent of evergreen.
“I’m all out of fucks to give. I need your help.”
And I explained the situation. They, of course, wanted to know what this had to do with saving Christmas. Wasn’t it obvious, I snapped at them. They cared that everyone was in the Christmas spirit and if just one person wasn’t, well then down to a cold and watery grave they went. So wouldn’t they care if there was one family out there that would spend their Christmas in mourning, because their first-born child had been stolen from them and wouldn’t be there to celebrate their first Christmas? How can anyone possibly enjoy Christmas with such a heavy burden on their shoulders?
They considered. The riders shifted in their saddles, glancing at one another and they conferred in low voices and I am actually not sure if it was Russian or not. Finally, they all turned to stare down at me again and my heart raced, knowing that this was the moment of judgement.
“A child’s first Christmas should be joyous,” the shulikun intoned. “We will help.”
I wasn’t going to argue, but I still think the whole ‘first Christmas’ thing is a bit silly when the child isn’t going to remember any of it.
The lead rider edged his horse forwards and reached a hand down towards me. I stared at it suspiciously.
“I was… hoping to borrow a horse?” I suggested tentatively.
In the stories, it takes a horse to defeat a horse.
“Do you know how to ride?”
“Does it matter? Aren’t they… magical horses?”
His eyes narrowed.
“Get on,” he said tersely.
I took his hand and he swung me up into the saddle. It was graceful only because the shulikun heaved me high enough to grab my waist and then spun me about before I hit the saddle like I was a ballerina or something. I’m honestly shocked I didn’t kick the horse in the head. I barely had time to situate myself properly. My legs were almost overlapping with his, as the saddle afforded very little room for me. His body was cold against my back and the smell of mint was overwhelming.
Then he kicked his horse into motion and I was bounced up and almost fell off sideways, but his arms on the reins went around my body and kept me in place. The shulikun yelled orders at his companions as we went. The horses covered yards at a time, each step sending the scenery lurching past as a dizzying rate. We were at the edge of the property, then across the road, then racing down the street that ran parallel to the campground. The horses jumped a car at one point and I twisted in the saddle to see if the driver had even noticed us, but we were too far away and the car had vanished and we were cutting into a field that sat between the campground and the town.
“What’s your plan?” the shulikun asked.
“Uh, I have a bridle,” I said.
“We’ll get you close and I’ll throw you onto its back.”
“I won’t last a second.”
The shulikun only laughed, a deep, humorless laugh in the back of his throat. Predatory. I remained silent, afraid to ask what they planned to do, keenly aware that we only know the sanitized version of Christmastime. The stories of old have teeth and I had invoked creatures from the early time when the world was raw and dangerous and death walked hand-in-hand with humanity.
The dapple-gray stallion came to meet us. We were at the edge of the field, riding parallel to the woods. The stallion burst through the trees, smashing the young saplings aside as it emerged. The shulikun split in two, each group veering sharply away from the stallion, branching out to race diagonally away from it. The monstrous horse pursued. I could not see it around the shulikun’s body and I did not dare lean out to look, as the horse was in a full gallop now and I felt like I was going to bounce wildly off its back if I eased my death-grip on the saddle for a moment.
“Hold these,” the shulikun said, shoving the reins into my hands.
“The hell do I do with them?” I yelled, aghast.
“Don’t drop them. That’s all.”
Clearly the horse knew what it needed to do. I swore under my breath and hunkered low over the saddle, wrapping the reins around my hands so I could keep clutching the saddle for some vestige of stability. The shulikun twisted behind me and I risked a half-glance backwards to see what the hell he was doing.
He was drawing back a horse bow.
I… really wish I knew more about these thing’s origins.
He fired. The other riders were doing the same. I could see the dapple-gray stallion’s head now, its lips peeled back to reveal its canines, breath coming out in steamy clouds and its eyes were wide and fixed on the horses it pursued, wild with hunger. It was gaining.
The arrow stuck into its neck. The dapple-gray stallion didn’t seem to notice, even as more arrows struck its neck and sides. A little blood leaked out, but that was all. Behind me, the shulikun dropped its bow back over the quiver and wrapped something around his wrists. I saw it glint in the sunlight. A thread, shimmering like silver, connecting him to the arrow.
A tether.
The horse carrying us slowed down. The dapple-gray stallion veered sharply in our direction, hooves churning, stretching its head and opening its mouth for the fatal bite at the other horse’s throat. Opposite us, the shulikun jerked hard on their own tethers, their horses straining to pull the stallion back and away from us, forcing it to keep going straight ahead.
So this was how they were going to keep it from throwing me off. It was surrounded now and so long as the tethers held, it would not be able to move wildly in any one direction.
“There is your child!” the shulikun shouted at me. “Be mindful - we will be most displeased if you kill the one you recruited us to save.”
I got one glance at what he was referring to before he grabbed hold of the back of my jacket. One glimpse before I was heaved into the air and sent flying through the distance between me and the dapple-gray stallion.
A child rode on its back. She was dressed in rags and carried a stout stick that had been carved to a point at one end as a makeshift spear. Her hair was matted and wild and it was the same muddy brown as my own. Old blood stained her hands like she was wearing crimson gloves.
Then I landed almost on top of her.
I hit the horse sideways, my stomach over top of its back. Its body was so broad that I wasn’t in immediate danger of falling off, especially as the shulikun dragged it out of its gallop. I flailed wildly, seizing hold of the girl’s ankle. She was twisting around in turn, raising her makeshift weapon. Not that it did much good. She was still just a child and I was a full grown adult. I gave her a good yank and threw her right off the horse’s back.
Beneath me, the dapple-gray stallion screamed in rage. I could feel the vibration of its cry in my chest. I sidled around, sliding myself further up its body until I could reach the mane. I tangled my fingers into the coarse hair and pulled myself upright. The horse attempted to buck or roll, but each time it moved in any one direction, the shulikun’s horses would dig in and pull it back into place.
The bridle was slender enough that I could roll it up and tuck it in my pocket. I pulled it free and let it fall into shape. The horse tossed its head, as if sensing what I held.
“My brother gave his flesh for this,” I snarled. “Fitting, isn’t it, that you’d be ensnared by the very person you thought to enslave!”
And I dropped it over the stallion’s head.
Instantly, the horse’s struggles ceased. It lowered its head, growing docile in a heartbeat. I reached around its neck and took up the reins. All around me, the shulikun loosened their tethers and then one brought his horse up alongside the stallion to pull the arrows free. The stallion didn’t even twitch. It stood as still as a statue with the bridle of flesh over its head.
“Remember to fulfill what you promised,” the lead shulikun yelled at me as the company formed up around him. “There shall not be a sorrowful Christmas this year!”
I waved at them and they galloped off, quickly vanishing into the distance. I had the horse. Now to retrieve my niece.
And at that thought, she tackled me off the horse.
Look. She had the element of surprise.
I caught one glimpse at her face as she straddled my prone form, her sharpened stick raised high and aimed at my throat. Her lips were peeled back, her eyes were wide in frenzied desperation. Her cheeks were gaunt and she barely looked human in that moment.
And before she could bring the weapon down on me, I swung a fist and hit her right on the jaw.
Yes, that’s right. I punched a five year old.
She was knocked sideways. She rolled and came up on all fours, poised, debating internally on whether to fight or flee. Then the dapple-gray stallion spoke. Its words came with an effort, as if it forced each one past the bridle, its voice pained and grating.
“Feast on her flesh, my child,” it said. “This is what you were born to do.”
The girl’s indecision vanished. Her feral rage evaporated, replaced with a calm focus. And when she ran at me, the wild energy was gone from her movements, replaced with a fluid, deadly precision. She snatched up a rock from the field in her hand and threw herself at me.
I couldn’t use my knife. I couldn’t use any weapon, really, not if I wanted to avoid killing her. I caught her at around chest-level instead, blocking her body with my arm. She brought the rock down at my head, I jerked out of the way and it hit my shoulder instead.
Her feet planted against my gut, she grabbed hold of my arm, and then she bit me. On the forehead, near the hairline. And let me tell you, head wounds bleed a lot. I shrieked in pain and threw her off of me and I felt the wound tear as her teeth ripped out a sizable chunk of flesh. Blood poured down the side of my face and I instinctively squeezed one eye shut tight as the salt burned into it.
Stumbling with pain, disoriented by the shift in perspective, I failed to prepare for her next attack. She hit me from behind, leaping onto my back and wrapping her skinny arms around my neck. I felt her teeth bite down on the thick cord of muscle connecting the neck to the shoulders and I screamed in pain as she tore more flesh free. I heard her swallow.
She was going to eat me alive if I didn’t do something.
So I let myself fall backwards. I didn’t expect her to simply let me fall on her. She was agile. And as I expected, she hoisted herself up and over my head and shoulders, intending to land on my chest once my back hit the ground.
I grabbed her as we fell. Seized her arms and locked them against her body and then rolled, putting her on the ground and me over top of her.
I am still a grown adult and she is still just a child.
She shrieked and struggled but with the full weight of my body I was able to hold her still. My blood splattered on the ground next to her as I grimly held on, realizing that she wasn’t about to tire and I didn’t really have a good way to tie her up.
So I sat on her. And while she flailed and bit at me, I called Bryan on my cellphone.
He showed up with the dogs and some rope and helped me tie up my niece. For good measure I also gagged her with a handkerchief so she couldn’t bite me anymore. I am now on a heavy dose of antibiotics and had to get my tetanus shot updated because of her.
Bryan took her to my house in his car so we could figure out what to do. I rode the dapple-gray stallion back to the campground. I made it walk slowly, clasping some wadded up gauze from a first aid kit Bryan keeps in his car to my forehead, trying to pretend that the blood loss really wasn’t that big of a deal.
The horse-eater was waiting at the edge of the woods when I reached the campground. I directed the stallion over to it and painfully slid off its back. The horse-eater extended one pale hand and I passed the reins to it, careful to avoid touching its thin fingers for no other reason than I wanted as little contact with it as possible. The dapple-gray stallion remained subdued the entire time, as if it were nothing but an ordinary horse.
“This is a fine bridle,” the horse-eater said, inspecting it carefully. “Good craftsmanship. A price was paid for it.”
“Is our bargain concluded?” I snapped. I wasn’t in the mood to discuss the harvester’s handiwork.
“Indeed it is. My thanks, campground manager. Should I come across you again, I will tear you in two and feed your entrails to my horse.”
Then it swung itself up onto the stallion. I saw for a brief moment what was underneath its cloak. A humanoid body, the limbs twisted oddly, bound in scraps of leather and metal. Then the cloak settled around it again, as dark as night and encasing it in its shadowy form so that the only thing I could see of its features was the glowing red eye.
“You should have known you could not elude me forever,” the horse-eater hissed, patting the horse’s neck. “But if you serve me well, I shall forgive your disobedience, and give you such a feast of flesh to sup upon.”
Then it kicked at the horse’s side and vanished back into the woods.
I really hope that feast of flesh isn’t going to be my campers when we reopen in the spring.
When I returned to the house I found that Bryan wasn’t there. There was a text on my phone saying that he’d taken my niece to someone that might be able to help and I should just go on to the urgent care and get the bite wounds looked at. He’d fill me in on the details of any arrangement when I got back.
And he did. He was waiting at the house when I returned. His dogs loitered on my furniture. I’m not sure how my sofa managed to fit three of them at once, but somehow they made it work.
“Where’s my niece?” I asked, somewhat in a panic.
The reality of the situation was starting to sink in. My niece had aged. She’d tried to kill me and would likely try again as soon as we released her. What on earth was I going to tell my brother? Oh yes here’s your daughter she’s five now and her hobbies include horseback riding and murder.
But Bryan apparently had the same concerns and had made some decisions in my absence. He’d taken her to the fairy. The one with the deer.
They would take charge of the girl. They would send her to live with their kind in the hills, until enough time had passed that she could be returned to her family once her age matched the timeline.
“You gave her to the fairies?!” I said, somewhat shrill from panic.
“Think about it, Kate,” Bryan snapped. “She is five, maybe six, years older than she should be. How are we going to make that work?”
We get away with faking the cause of death because the police department is on our side and that’s done before the death certificate is issued. We don’t have a way to alter a birth certificate that’s already been filed. Maybe it’s possible or maybe we could just… forge the child an identity… but the town doesn’t have the sort of people that know how to do that. I sure don’t know how to go about it. Furthermore, we were dealing with a cannibalistic feral child. How did we rehab someone like that? Sure, we’ve got a therapist in town, but she’s not nearly qualified for something like this. Outside help would certainly attract attention.
He… had some very good points.
“I don’t know how I’m going to break the news to my brother,” I sighed. I wanted to collapse on the sofa, but yanno, it was full of dog.
Bryan hesitated and when he spoke, he chose his words carefully. I wouldn’t have to, he said. The fairy had secured the help of a changeling. I could take them to Tyler and his wife instead and when their real daughter was ready to leave the hills, the fairies would erase all memory of what had passed and it would be like nothing had ever happened.
It was… a horrible solution that he offered me.
Isn’t the illusion of happiness enough? Why else was the idea of the child’s first Christmas so special, when it would mean nothing to the baby? It was all for the parents. So they could experience that joy. Maybe I’m just a cold and cynical person and all the parents out there are going to yell at me in the comments, but I’m prepared for that.
There’s been enough messed up stuff in our lives that I wanted my brother to not experience this sort of heartbreak, even if his happiness was based entirely on a lie. I told Bryan I’d take them the changeling.
Finally, I asked the question I was dreading. How he’d managed to secure all this assistance. I think I was hoping that the fairy was just being kind, on account of the relationship the two have.
“I made a deal with them,” he said wearily. “One that I’m responsible for fulfilling.”
“Why did you do that?” I asked, my voice high with panic. “That’s not your job!”
He whirled on me with uncharacteristic anger.
“Maybe I just wanted to save someone from having a fucked up childhood like we did!”
Before I could reply, he put his back to me and stalked away. He paused at one point and I hesitated, wanting to call after him, to ask him what he meant by ‘we’, but he shook himself and kept going. I stayed silent.
I found out what the price for the fairy’s help was the next day. Bryan showed up to work without the dogs. They were on loan, he said. On loan until the fairy defeats his enemy.
I’m a campground manager and I’ve found the enemy of the horse-eater. I can’t think of anything worse, because if the fairy is its enemy, then there’s only one identity that I can think of for the horse-eater. The invaders of Ireland. The ancient enemy of the fairies.
We’re dealing with a formorian.
And I gave it a horse. [x]
Read the full list of rules.
Visit the campground's website.
submitted by fainting--goat to nosleep [link] [comments]

2020.12.01 23:00 ECommerce_Guy Quickest Way for Two Self-Taught Guys to Get a Database Up and Running?

Hey guys!
If memory serves me well, I think I posted in here maybe some 3-4 months ago and I made quite a bit of progress, so I was hoping to get a new set of tips to hopefully push me in the right direction.
The Problem:
I'm working at an ecommerce company and over the last two years I've been tasked with developing a system to keep track of everything. The company started as the bare startup so Google Sheets were the way to go. I got into that position by accident and with absolutely no prior knowledge or educational background in even remotely related fields, so progress was slow (only "experience" I had was messing around in Unity/C# for a year or so).
First iteration of the system was a simple logistic tracker based solely on Sheets. It died fairly quickly due to obvious reason. The second was built in Sheets but with heavy lifting done through AppsScript (JavaScript I guess? In a way at least). That one survived longer, but business grew and due to complexity ever increasing (but also volume of data needed to be processed), I managed to switch to the new one as the second was living its final days.
Third and current iteration - still built in Sheets as the primary interface, but with all the heavy lifting moved to Python, mostly relying on Pandas, again, due to obvious reasons.
This system does seem to work quite well, with couple important issues that still persist:
Why the f*** are you using sheets?
What can you guys offer?
On my end, I have some kind of knowledge of Python, very rudimentary JS and C# and can find my way around SQL variants. Good enough knowledge of Unix-based OSs that I can survive using them (including stuff like setting up cron jobs and similar).
My colleague on the other hand is very experienced web dev with good knowledge of JS, CSS and PHP. Tbh, I am so bad with web dev, that I am even bad at explaining what exactly the guy covers, but I do know that he keeps our sites looking good, having some very advanced functionality (members' area, dynamic content, etc) and bringing them back to life following all kinds of server problems and crashes.
What is your question in the end?
What would be the quickest way for us to move away from Sheets towards something more robust? Is it even a real option for a team of two with the skills above?
What would be the simplest database option for us to get up and running? Is it even achievable to have a web-based interface matching the look and feel of the sheets?
Thanks in advance!
submitted by ECommerce_Guy to learnprogramming [link] [comments]

2020.12.01 22:56 Enviious Issue with keyboard on brand new laptop

My sister recently bought the HP Pavilion laptop that comes with a GPU for her daughter, but she's having issues with it. It will start acting up seemingly at random while using the physical keyboard, when you press keys on the bottom row, like for example M, it will type m7 or if you press v, you get v4. I've tried a keyboard checker and have confirmed that it is indeed pressing the two different keys at once. It also doesn't do it on an external keyboard. I've tried uninstalling the driver and updating it, but it still happens. So my question is, is the keyboard just messed up and should we exchange it once there's stock?
submitted by Enviious to techsupport [link] [comments]

2020.12.01 22:00 SilphScience December 2020 Field Research and Raid Bosses Megathread

This thread will be updated as reports come in. Let us know what you've found!

Field Research

Research Breakthrough Encounter: Lapras (s) or Unova Darumaka
New tasks:
Task Reward
Send 3 Gifts to friends Houndour (s)
Give your buddy 3 treats Spheal
Earn 5 hearts with your buddy Growlithe (s)
Catch 3 Fire-type Pokemon Torchic (s)
Use 5 berries to help catch Pokemon Ponyta (s)
Evolve a Pokemon Flareon
Catch 5 Pokemon with Weather Boost Snover (s)
Trade a Pokemon Snorunt (s)
Catch 5 different species of Ice-type Pokemon 2 Rare Candy
Defeat 2 Team GO Rocket Grunts Vulpix (s)
Hatch an egg Sneasel (s)
Win 2 Raids A-Sandshrew (s)
Here are the tasks that stay each month:
Task Reward
Catch 5 Pokémon with Weather Boost Poliwag(s), Vulpix (s)
Evolve a Pokemon. Eevee(s)
Catch a Dragon-type Pokémon Dratini(s)
Catch 10 Pokémon Magikarp(s)
Make 5 Nice Throws Voltorb(s)
Make 3 Excellent Throws in a row Larvitar (s), Gible (s)
Make 3 Great Throws in a row Onix(s)
Make 3 Great Throws Lileep(s), Anorith(s), Gastly (s)
Win a Level 3 or higher raid Kabuto(s), Omanyte(s)
Win 5 raids Aerodactyl(s)
Power Up Pokémon 5 times Bulbasaur(s), Charmander(s), Squirtle(s)
Make 5 Great Curveball Throws in a row Spinda #4 (s)
The following tasks are with us too, for the duration of the Kalos event
Task Reward
Catch 3 Normal-type Pokémon Bunnelby
Catch 5 Flying-type Pokémon Fletchling
Catch 7 Fire-type Pokémon Litleo

Raid Bosses

You'll start seeing new raid bosses after this post is an hour old. However, as the Kalos event starts in your timezone you will also see Fletchling and Litleo in T1 raids.
Tier Raid Bosses
1 Klink (s), Timburr (s), Espurr, Swinub, Snorunt (s), Cubchoo
3 A-Marowak (s), Machamp, Mawile (s), Excadrill, Hariyama
5 Kyurem
Mega Charizard X (s), Gengar (s), Abomasnow (s)
submitted by SilphScience to TheSilphRoad [link] [comments]

2020.12.01 19:34 prettyoaktree *** DECEMBER 2020 MONTLY HIGHLIGHTS ***

This is your monthly highlights post, curated and refreshed to keep important stuff at the top. If you are new to OTF or our subreddit, this is the best place to start. As always, you can use this thread to share and discuss upcoming intel for the month, tornado templates, and other random topics.

Key Dates for The Month:

We’re a bit light on intel for this month. If your studio published any information about upcoming workouts please post the details in the comments or submit using our form. In case you are wondering, we have not seen any information about the traditional 12 Days of Fitness workouts, so perhaps they are not happening this year.
The community calendar has been updated to include these events. Remember that our community calendar depends on your contributions. If you are aware of any other upcoming events for the month, please submit intel using our form.

Reminder: Minimum Karma Required To Participate in This Subreddit

To help us combat recent spamming and trolling, we have implemented a minimum karma requirement for participating in this community. This threshold is used to screen both posts and comments, and while we are not going to disclose the exact number, we want to assure you that it is set low enough that it would not prevent you from participating if you are new to the sub, or if you’ve earned a bunch of downvotes for a comment. If your post or comment is removed for low karma, you will get a message from SplatBot informing you of the removal, and you can reply to that message if you wish to appeal the decision.

Reminder: Safe Space for OTF Discussions

Our shared love and interest in all things OTF is the reason this sub exists, and we are going to make sure that it is a safe place to discuss OTF. We know that not everyone has the same views on whether it is safe to return to OTF, but that doesn’t mean we need to attack each other for our personal opinions and choices, whatever they might be.

Resources for New Members and Everyone Else

Want to nominate a post for listing in next month's highlights? Just tag u/prettyoaktree, u/lookie4dacookie, u/matthotlips, or u/jenniferlynn5454 in it and ask for it to be bookmarked.
-The Modsquad
submitted by prettyoaktree to orangetheory [link] [comments]

2020.12.01 14:28 Hangeland_py I made a small shopping program, and now im wondering how i can improve it ANY help appreciated!

Hello Pythoneers and Pythonistas!
I've been working on this code that takes input (user_id, product, and amount) from the user and edits an excel accordingly adding new rows. It also makes a chart in a sheet in the excel file but disregard that.
I'm now wondering how I were to improve this code, and make it smoother, use fewer lines to save space etc. I think that the readability is a bit bad and conciseness is lacking.
All help and suggestions and thoughts regarding this are warmly welcome!
Thank you in advance,

Here is the code (that I'm storing in four different .py files):
    from shopping import Shoppingimport pandas as pdfrom config import pathsdef main(): users_df = pd.read_excel(paths["data"],sheet_name="USERS") products_df = pd.read_excel(paths["data"],sheet_name="PRODUCTS")
while True: print("\n\nNEW SHOPPING\n\n") print({users_df.loc[i,"Id"]:users_df.loc[i,"Name"] for i in range(users_df.shape[0])}) user = input("Please enter user id\n")try: user = int(user)except: print("\nUser not found.\n")continueif users_df.loc[users_df["Id"]==user,:].shape[0]==0: print("\nUser not found.\n")continue print({products_df.loc[i,"Id"]:products_df.loc[i,"Name"] for i in range(products_df.shape[0])}) product = input("Please enter product id\n")try: product = int(product)except: print("\nProduct not found.\n")continueif products_df.loc[products_df["Id"]==product,:].shape[0]==0: print("\nProduct not found.\n")continue
amount = input("Please give order amount.\n")try: amount = int(amount)except: print("\nOrder amount must be an integer.\n")continue
shop = Shopping(user, product, amount) __name__ == "__main__": main()

from datetime import datetimefrom config import pathsfrom manage_excel import ExcelDataManager
class Shopping(): def __init__(self, user_id, product_id, amount):self.user_id = user_idself.product_id = product_idself.amount = amountself.date_time = = Falseself.cart_id = self._add_cart()def _add_cart(self): edm = ExcelDataManager() inserted_id = edm.add_row("CARTS", {'UserId': self.user_id,'ProductId': self.product_id, 'Amount': self.amount, 'DateTime': self.date_time, 'Success': self.success})return inserted_iddef _check_stock(self): edm = ExcelDataManager() product = edm.find_rows("PRODUCTS",{'Id': self.product_id}) stock = product.iloc[0,2]return stock >= self.amount, stock
def shop(self): edm = ExcelDataManager() check, stock = self._check_stock()if check: edm.update_row("PRODUCTS",self.product_id, {'Stock': stock-self.amount}) edm.update_row("CARTS", self.cart_id, {'Success': True}) print("Shopping was successful.")else: print("Shopping was not successful.")
from datetime import datetimefrom config import pathsimport pandas as pdclass ExcelDataManager(): def __init__(self):self.df_users = pd.read_excel(paths["data"],sheet_name="USERS")self.df_products = pd.read_excel(paths["data"],sheet_name="PRODUCTS")self.df_carts = pd.read_excel(paths["data"],sheet_name="CARTS")def add_row(self, table, row):if table == "USERS": latest_id = self.df_users.iloc[-1,0] row["Id"] = latest_id + 1 df_ = pd.DataFrame(data=[row])self.df_users = self.df_users.append(df_)elif table == "PRODUCTS": latest_id = self.df_products.iloc[-1,0] row["Id"] = latest_id + 1 df_ = pd.DataFrame(data=[row])self.df_products = self.df_products.append(df_)elif table == "CARTS": latest_id = self.df_carts.iloc[-1,0] row["Id"] = latest_id + 1 df_ = pd.DataFrame(data=[row])self.df_carts = self.df_carts.append(df_)self._update_data_and_charts()return latest_id + 1def update_row(self, table, id, row):if table == "USERS":for k,v in row.items():self.df_users.loc[self.df_users["Id"]==id,k] = velif table == "PRODUCTS":for k,v in row.items():self.df_products.loc[self.df_products["Id"]==id,k] = velif table == "CARTS":for k,v in row.items():self.df_carts.loc[self.df_carts["Id"]==id,k] = vself._update_data_and_charts()
def find_rows(self, table, filters):if table == "USERS": mask = () first_item = Truefor k,v in filters.items():if first_item: mask = (self.df_users[k]==v)else: mask = mask&(self.df_users[k]==v) first_item=False df_ = self.df_users.loc[mask,:]elif table == "PRODUCTS": mask = () first_item = Truefor k,v in filters.items():if first_item: mask = (self.df_products[k]==v)else: mask = mask&(self.df_products[k]==v) first_item=False df_ = self.df_products.loc[mask,:]elif table == "CARTS": mask = () first_item = Truefor k,v in filters.items():if first_item: mask = (self.df_carts[k]==v)else: mask = mask&(self.df_carts[k]==v) first_item=False df_ = self.df_carts.loc[mask,:]return df_def _update_data_and_charts(self):with pd.ExcelWriter(paths["data"],engine="xlsxwriter") as writer:self.df_users.to_excel(writer,sheet_name="USERS",index=False)self.df_products.to_excel(writer,sheet_name="PRODUCTS",index=False)self.df_carts.to_excel(writer,sheet_name="CARTS",index=False) df_ = self.df_carts.loc[self.df_carts["Success"]==True, :].merge(self.df_products, left_on="ProductId", right_on="Id").loc[:,["Name","Amount"]] df_.to_excel(writer,sheet_name="CHARTS",index=False) workbook = writer.bookworksheet = writer.sheets["CHARTS"] piechart = workbook.add_chart({"type":"pie"}) piechart.add_series({"values":f"'CHARTS'!B2:B{2+df_.shape[0]}","categories":f"'CHARTS'!A2:A{2+df_.shape[0]}"}) worksheet.insert_chart("D3",piechart)
from os import pathpaths = {"data": path.join(path.dirname(__file__),"data","DATA.xlsx")}
submitted by Hangeland_py to learnpython [link] [comments]

2020.12.01 10:28 leftieant arcpy da cursors throwing "Runtime Error"

Gday everyone
I've hit a strange problem with a Python process I'm trying to build that uses a couple of arcpy.da cursors.
The way the process is structured, firstly I am using a arcpy.da.InsertCursor to add rows to a feature class based on logic from a prior step. The process is running fine up until this point.
I then need to call an arcpy.da.UpdateCursor on the same feature class, and this is where I'm striking the "Runtime error - cannot open file feature_class_name".
I thought maybe it was due to the cursor from the InsertCursor object still being live, so I've refactored the script to explicitly delete the object, with no luck. I also thought there may be a race condition where the UpdateCursor was being called before the InsertCursor object was deleted, so I explicitly built in a 5 second pause. No success either.
I'm 100% certain I have the syntax right (but will double and triple check tomorrow so I don't look like an idiot) - but I'm at a bit of a loss with this issue.
Has anyone got any suggestions that may send me in the right direction?
On ArcMap 10.7.1 by the way.
Thanks in advance!
EDIT: code below:

 hashes_source = [] with arcpy.da.SearchCursor(source_ch_data,fieldlist[0:-4]) as cur: #with arcpy.da.InsertCursor("PRELIMINARY_REPORTS_ALL",fieldlist) as icur: for row in cur: sourcehash = get_hash(row) hashes_source.append(sourcehash) if sourcehash not in hashes: #insert into destination table #need to add CURRENT flag, version, hash print "Inserting row for",sourcehash icur = arcpy.da.InsertCursor("PRELIMINARY_REPORTS_ALL",fieldlist) icur.insertRow(row+("Y",last_update_dto,None,sourcehash)) del icur time.sleep(5) # process runs ok to this point, fails where UpdateCursor is called below # error message below: ''' Traceback (most recent call last): File "C:\folder_location\", line 101, in  with arcpy.da.UpdateCursor("PRELIMINARY_RECORDS_ALL",["CURRENT_RECORD_YN","RECORD_RETIRED_DT","HASH_SHA256_HEX"]) as cur: RuntimeError: cannot open 'PRELIMINARY_RECORDS_ALL' ''' # iterate through destination table # if hash not in source table, retire the record with arcpy.da.UpdateCursor("PRELIMINARY_RECORDS_ALL",["CURRENT_RECORD_YN","RECORD_RETIRED_DT","HASH_SHA256_HEX"]) as cur: for row in cur: if row[2] not in hashes_source: print "Retiring record",row[2] row[0] = "N" row[1] = last_update_dto cur.updateRow(row) 

submitted by leftieant to askgis [link] [comments]

2020.12.01 07:23 Flabberjackets Am I Desperate? I Just Want One Friend!

Someone Im trying to be friends with sent a text asking to hang. She said
“hey! do you ever wanna go to barnes and nobles and look for manga sometime? I’ve actually never been in that section before and I’ve always wanted to look around”
I responded with
“Yah for sure. If your trying to go this weekend I’m busy Saturday but totally free Sunday 👍🏻”
No response so Sunday I text
“Hey! Are you free anytime this week? Lmk.”
No response. This happened during the 20th and 22nd of November. I found out that she ended up going alone without me.
I don’t have many friends so I thought I’d try asking her to hang again. I just can’t figure out why she’d ask me to go and never update or anything. There’s nothing I said or did that could change her opinion of me I only texted her saying I was free. I’m gonna text
“Hey! Do you wanna take a study break from finals Wed or Thurs? Catch up and grab food on campus?”
It’s been a longer than a week. It’s not clingy or desperate to text three times in a row if it’s been that long right? What do I do?
submitted by Flabberjackets to socialskills [link] [comments]

2020.12.01 06:24 Daztur [Spoilers Extended] Where I Reread Armageddon Rag by GRRM: Part X

Where I Reread Armageddon Rag by GRRM: Part X
Links to earlier posts in this series can be found at the end of this post. Bolded quotes indicate italics in the original.
Chapter 17
Cue the music:
Winter has come for Sandy, which seems to involve him becoming a crusty shut-in. He rents out a roach-infested apartment and blows off his friends and spends all day “getting stoned every day and watching lots of TV” before changing gears and writing long navel-gazing un-mailed letters to his old college buddies, the contents of which were are mercifully spared. He can afford his lockdown lifestyle because his realtor girlfriend bought out his half of their home’s equity.
The only interesting thing that happens for months is that the Wholesome Maine Cop tells him that “NO INDICATION THAT LYLE OR ANYONE FITTING HIS DESCRIPTION TRAVELED TO MAINE IN SEPTEMBER.” So Edan Morse has an alibi for the killing of the Nazgul’s manager and there’s no evidence his Lyle did it, but Sandy is far too thick/horny to figure out that Ananada (the not-Melisandre character) looks pretty damn suspicious through simple process of elimination.
Then the dreams start again…
He dreams of Ice and Fire.
“He dreamed of Sharon dressed in ice, her skin blue with the cold, her glasses rimed by frost.”
“He was in Vietnam, and the silver jets screamed overhead and the napalm fell, and he felt its searing kiss on his body, burning, burning, an agony that lasted half the night.”
And a whole lot more, including possibly prophetic dreams about a war amidst oil fields, many seemingly sent by Morse’s blood magic. Then he starts dreaming of Armegeddon.
The Nazgul are covered in blood or fire or “writhing like a man possessed” before a ravening crowd and preparing the sacrifice if a “thin bleeding woman” who he’d seen before and who I noted as perhaps a Shireen-like figure in a previous post.
“In the Rag, all the dead look just like you*, one line promised. And they fought on. Dead or alive, it made no difference on armageddon day.”* So Armgeddon day will be marked by armies of the dead. Sound familiar to anyone?
Then the totally not suspicious at all Ananda shows up and they bang and Ananda recruits Sandy as press agent for the Nazgul. As first Sandy is hesitant to sign on for Morse who he believes is “a fucking murderer” but the condition of his various old college buddies convinces him that he can just continue as he has. It’s “too late” for the 60’s to win. “But what if it wasn’t?” At the very least he believes all kinds of crazy shit is going to go down and he wants a front row seat.
Then they bang again. I’m sure you don’t need me to tell you the details of “the throbbing in his loins.”
I like the last bit of this chapter, Sandy calls up his old magazine publisher in the middle of the night and:
“Just me, Jared,” Sandy said. “I wanted to tell you that the Martians have landed. And guess what? I’m their press agent.”
Up next: getting the bang back together.
On a Darkling Plain
Just like how Martin quoted The Second Coming by Yeats last time, this time he quotes Dover Beach by Arnold: Give it a read if you’re not familiar with it. This is obviously a poem that’s crawled its way into Martin’s brain as it’s quoted in A Song for Lya as well. For a deep dive into Dover Beach and ASoIaF see this post here: which makes some good points (such as House Darklyn being a reference to this poem) although I think he’s reaching in some places.
The last few lines contain images that Martin draws especially heavy on:
And we are here as on a darkling plain
Swept with confused alarms of struggle and flight,
Where ignorant armies clash by night.
In A Song for Lya, Martin uses the imagery of a darkling plain to describe how people interact with each other. No matter how much we love each other we’re always separate, always alone and stumbling in the darkness there’s always a wall between people inhibiting perfect empathy that nothing can tear down, leaving us as “ignorant armies [that] clash by night.”
In this book (and perhaps in A Song of Ice and Fire) this same imagery seems to take on grander meaning than personal relationships. The forces at play aren’t on grand crusades against evil, but rather “ignorant armies” fumbling about in darkness. Major players who are working hard to bring Westeros closer to Armageddon such as Melisandre and Euron have no clue what they’re doing and are sending the whole world into a “darkling plain.”
"I dreamed of you."
Sandy tells Ananda “I’ve dreamed of you,” echoing Jaime to Brienne in much the same context: dreams being sent to nudge the behavior of people. One of the things I’m looking forward the most in reading TWoW is to be able to learn more about the people sending these dreams and then going back over the first five books and seeing who might have sent what dream and to what purpose. Just like ASoS made so much of the political plotting in AGoT make more sense in retrospect, TWoW will make so much of the supernatural maneuvering that’s been going on all through the series make more sense, so that it’ll serve as decoder glasses which’ll allow us to wring more meaning out of the books we’ve already read.
Previous updates:
Part I:
Part II:
Part III:
Part IV:
Part V (stupidly mis-titled as Part IV) :
Part VI:
Part VII:
Part VIII: Part IX:
submitted by Daztur to asoiaf [link] [comments]

2020.12.01 04:40 blue_trackerbot WoW Linxy in Hotfixes – Updated November 30

General Discussion » Hotfixes – Updated November 30



NOVEMBER 30, 2020

  • Opening Misplaced Supplies should now count progress towards the achievement Treasures of Maldraxxus . Players may need to collect it a second time to earn credit.
  • The Elusive Faerie Cache required for Treasures of Ardenweald is now less elusive.
  • Hunter
    • Beast Mastery
      • Wild Spirits (Night Fae Ability) will no longer deal damage multiple times when using Bestial Wrath with Animal Companion (Talent) or when using Barbed Shot with Stomp (Talent).
    • Marksmanship
      • Corrected an issue where Shadowcore Oil Blast would incorrectly interfere with Steady Focus (Talent) when casting two Steady Shots in a row.
      • Corrected an issue where Bursting Shot was causing Wild Spirits (Night Fae Ability) to unintentionally deal multiple hits to the enemy.
  • Death Knight
    • General
      • Resolved several issues with Death Knight voice effects. Go forth and intimidate your enemies with a clearer /roar!
  • Priest
    • General
      • Phantasmic Detonation will now properly explode when the Volatile Phantasm (Torghast Power) illusion is defeated.
  • Shaman
    • Restoration
      • [ Work in progress ] The Primal Tide Core Legendary effect will now only apply Riptide to friendly players.
  • Added two Battle Ready Tauralus outside the Seat of the Primus for faster travel through the covenant hall.
Creatures and NPCs
  • Nikara Blackheart at Sophia’s Aria in Bastion now deals appropriate damage and is now less challenging.
  • Wingsmash is now ready to help fight Harika the Horrid in Revendreth no matter how many players give him weapons at the same time. Additionally, the Ballista Bolts respawn more frequently, and Sacks of Dredhaven Tools will no longer spawn as they are obsolete. Wingsmash will also no longer get stuck at the broken ballista and now resets properly.
Dungeons and Raids
  • De Other Side
    • Mueh’zala
      • Added a power bar to Mueh’zala so that he may better convey when his next Soulcrusher is coming.
  • Necrotic Wake
    • Dungeon enemies can no longer immediately recast Spine Crush.
  • Plaguefall
    • Infinitely Divisible Ooze now correctly drops for Agility and Intellect classes.
  • Spires of Ascension
    • The transport kyrian will now carry druids in their combat shapeshift forms.
Items and Rewards
  • Reduced the idle sound effect volume of the Warstitched Darkhound mount.
  • The Hearty Dragon Plume toy now has a 15 minute cooldown (was 5 minutes).
  • Players are now able to watch other’s strum their Fae Harp toy. Enjoy the show!
  • Fixed an issue that caused characters to remain laughing after using the S.E.L.F.I.E. Camera MkII.
  • Deep Fried Seraph Tenders now only work outdoors and not in dungeons or battlegrounds. Tooltips will be updated to reflect this in a future patch.
  • Pre-Mixed Pot of Noodles now grants an appropriate amount of Versatility for Pandaren characters at level 60.
Player versus Player
  • Oribos PvP quests, such as “Observing Battle,” should now show a turn-in location once completed.
  • Hunter
    • Hunter’s Mark now lasts 30 seconds instead of indefinitely when used against an enemy player.
  • [ With regional restarts ] Resolved an issue where experience gained from crafting a Legendary item would sometimes not retain after relogging into the game.
  • Budding Lashers now reward Herbalists loot after gathering their corpses.
  • Covenant Campaign
    • Fixed an issue where players below level 50 who entered into the Threads of Fate experience would have issues accessing quests in the Shadowlands.
    • Fixed an issue where Anima Salvage Callings could not be abandoned or completed after changing covenants.
  • Bastion
    • Fixed an issue where opening Silver Strongboxes would sometimes not reward credit for “The Sweetest Tribute” quest.
    • “A Friendly Rivalry” can now be turned in while the “Training Regimen” World Quest is available.
    • Fixed an issue where the quest, “Hero’s Rest” could not be turned into the ever-present version of Kalisthene.
    • Fixed an issue where the Chamber Incense Burner could be not be interacted with during the quest “You Go First.”
  • Maldraxxus
    • Mounts are no longer allowed on the island that holds the Unfinished Blade for “Through the Fire and Flames.”
    • Players on the quest “Return to Draka” will now find her at the Seat of the Primus.
    • More enemies now have a chance to drop Poxedskin Samples required for the dungeon quest “Plaguefall: Knee Deep In It.”
    • Increased the Traitor’s Head drop rate required for “Bring Me Their Heads.”
    • The Animates required to recruit for the quest “Ani-Matter Animator” has been lowered to 12 (was 15) and the respawn rate has been increased.
    • Increased the respawn rate of the Ash Ghouls required for “Unbearable Light.”
    • Enemi should now offer the quests “Slaughter Daughter” and "Bottled up Inside’ for players who have lost them.
  • Ardenweald
    • Fixed a bug that caused quest objectives to sometimes be invisible on “Cut the Roots” and “Take the Power”.
  • Revendreth
    • Stonehead is hungry! “Snacks for Stonehead” should now correctly be available to all players in the Ember Ward.
    • “Halls of Atonement: Your Absolution” should now be correctly offered to all Venthyr covenant players by Archivist Fane in Halls of Atonement.
  • The Maw
    • Prince Renathal now stealths when the player enters stealth during the storyline quest, “Torghast, Tower of the Damned”.
    • Added more souls to rescue within Cocyrus for the quest “Rule 1: Have an Escape Plan.” We’re not proud about damning more souls into the Maw… but it should help make completing the quest easier.
  • Exile’s Reach
    • Fixed an issue where players on Exile’s Reach who completed either “Down with the Quilboar” or “Forbidden Quilboar Necromancy” without accepting the other quest would be unable to see Mithdran Dawntracker to continue the story.
  • Run Without Tiring (Niya Soulbind Ability) no longer continues to heal when health is full.
The Maw: Eye of the Jailer
  • Saving Souls with the Soulkeeper present no longer grants Stygia after reaching Threat Level 5.
  • Fixed an issue which could cause the Soulkeeper to unexpectedly be present with your character in the Maw when Anima Salvage was an active calling. It will once again only be present when you are tasked with collecting souls.
World Quests
  • Fixed an issue with world quest “Allay Their Fears” not appearing.
  • Fixed an issue where Korinna’s Allaying Crook could be used on living targets during the Bastion World Quest “Allay Their Fears.”
  • Fixed an issue where it was more challenging than intended to maintain a Precision streak during the Bastion World Quest “We’ll Make an Aspirant Out of You.”
  • Fixed an issue where “Battles Won Long Ago” could erroneously be repeated.
  • Battle Pet World Quests should now properly count for Callings that require you to complete activities in a zone.
  • Increased the respawn rate of the Crates of Salvaged Explosions for the Maldraxxus World Quest “Gettin’ Even.”

NOVEMBER 27, 2020

  • Mage
    • General
      • Fixed an issue where Clouded Diamond (Torghast Anima Power) would not trigger with Arcane Momentum.
  • Warlock
    • General
      • Corrected an issue where Soul Rot (Night Fae Ability) was unable to be used if the warlock was low on health.
  • Corrected an issue that could cause players who were trying to switch covenants to incorrectly be treated as having previously been a member of their desired new covenant.
Creatures and NPCs
  • Stablemaster Vasilica has taken up shop in Sinfall to help Venthyr covenant members recover their lost pets.
Items and Rewards
  • The Mistcaller Ocarina trinket now refreshes its buff duration when the buff is already applied and the buff now lasts 15 minutes (was 5 minutes).
  • Covenant Campaign
    • Fixed an issue where characters who chose to enter the Threads of Fate could have quests in their log from “The Looming Dark” campaign that could no longer be completed.
  • Bastion
    • Fixed an issue where there were two Centurion Colossi visible during the quest “The Final Countdown.”
  • Maldraxxus
    • Characters in Threads of Fate mode should no longer be offered the Maldraxxus quest “WANTED: The Key of Eyes” as it takes place in a level 60 area.
  • Ardenweald
    • Fixed an issue during the quest “Ride to Heartwood Grove” where the Riding Stag would not want to be mounted.
  • Revendreth
    • Players who logout during “Refuge of Revendreth” should no longer be required to restart the quest to complete it.
    • Archivist Fane will now allow those sworn to the Venthyr to obtain the quest “Halls of Atonement: Your Absolution.”
    • Prince Renathal will now accept the turn in of “Cages For All Occasions” while mounted on a Bridled Shadehound.
  • The Maw
    • Resolved an issue where Brethlun the Brand can become stuck and permanently evade all oncoming attacks during the quest “The Brand Holds the Key.”
  • Battle for Azeroth
    • Fixed an issue where Tyrande could get stuck in combat during the Battle for Azeroth Alliance scenario “In Darkest Night.”
Torghast, Tower of the Damned
  • Any Soul Ash that was not looted from defeated enemies will now be sent directly to your character’s currency collection the next time you log back into the game.
World Quests
  • Increased the spawn frequency of Brittle Bark Mischief-Makers needed for the World Quest “Spriggan Size Me!”
  • Fixed an issue where Kleia could display incorrectly during the Bastion World Quest “Flight School: Falling With Style.”

NOVEMBER 26, 2020

  • [ With realm restarts ] Oribos no longer separates players with War Mode enabled from those who have it disabled.
  • Falling off the edge of the Shattered Grove in Maldraxxus will no longer send the character to Westfall or the Barrens. Falling to your death is enough punishment.
  • Mage
    • General
      • Fixed an issue where Dimensional Blade (Torghast Anima Power) would sometimes not instantly kill Mawrats when Blinking through them.
  • Paladin
    • Retribution
      • Seraphim (Talent) now correctly triggers Selfless Healer (Talent).
  • Shaman
    • Enhancement
      • Windfury Totem procs now have sound and the volume of the Maelstrom Weapon proc sound has been lowered.
  • Players who switch covenants after completing the Maw introduction and gathering 5 Redeemed Souls for their first covenant should now find that they have 5 Redeemed Souls waiting for them in their new covenant. Players who changed covenants prior to this fix and were roadblocked by missing Redeemed Souls should visit Oribos, which will perform a process that corrects the issue.
  • Adventures missions now appear immediately after completing the tutorial when switching covenants.
  • Kleia is now a bit more chatty and now welcomes being the chosen Soulbind in Elysian Hold.
  • Fixed an issue that caused a player to be rejected from their chosen covenant. Covenant pacts lost in this way can now be re-selected.
Creatures and NPCs
  • Scorched Crypt Key can now open the Crypt Door to Innervus.
  • Night Fae characters in Soulshape form can now pass through the barrier protecting Skuld Vit.
  • Derwynnthlmn will now offer his Flight Master services to players that have chosen the Night Fae Covenant.
Dungeons and Raids
  • Halls of Atonement
    • Fixed an issue where Revendreth players with combat pets could not correctly interact with Loyal Stoneborn.
Items and Rewards
  • The cooldown of Slumberwood Band’s effect can no longer be prematurely cleared by death or by using immunities and similar effects.
  • The Oribobber now makes sound when a fish is hooked.
  • Resolved an issue where Master Duelist’s Chit trinket would fail to correctly display its visual effect when striking targets at range.
  • Covenant Campaign
    • Fixed an issue where depositing anima during the Covenant Campaign tutorial quest “Into the Reservoir” could sometimes consume the player’s earned anima instead of the tutorial anima.
    • Fixed an issue where Night Fae players who skipped parts of Covenant Chapter 1 by speaking to the Winter Queen, but had not yet done the campaign quests at the Star Lake Amphitheater on any character, would be unable to turn in the quest “Show, Don’t Tell.”
    • The boss will no longer reset when dealing the killing shot at the same time as being ejected from Bron during the Mikanikos “Path of Ascension” scenario.
    • Lady Moonberry has finished her prank and is no longer in two places at once for Night Fae who leveled via Threads of Fate during the quest “The Boon of Shapes.”
  • Bastion
    • The chest for “Trial of Courage” no longer despawns as soon as you reach it.
    • Fixed an issue where the Chamber Guardians could fail to attack during the quest, “You Go First.”
  • Maldraxxus
    • The Harvesting Hook required for “Give Them a Hand” now displays that it’s on cooldown.
    • To prevent phasing issues, “Kill Them, Of Course” must be turned in before “Secrets Among the Shelves” can be accepted.
    • Ve’nari’s Orb of Teleportation now correctly brings all members of a party along for the ride during the quest “Hope Never Dies.”
    • Fixed an issue that sometimes caused a door to not open while progressing through the quest, “Secrets Among the Shelves.”
  • Ardenweald
    • Elder Finnan, Elder Gwenna, and Groonoomcrooek have all returned to their homes, if you are searching for them for the Lady of the Falls after accepting “Ages-Echoing Wisdom.”
    • Nesting Valeshrieker will now respawn after a hunter tames the beast while on the quest “Wildseed Rescue.”
  • Revendreth
    • Fixed an issue where Stage 3 of “The Master of Lies” scenario completed automatically if the objective’s area was reached on an earlier stage.
    • General Kaal will now accept the turn in for “The Master Awaits” after dismounting Myskia.
Torghast, Tower of the Damned
  • Added missing sounds to some creatures and boss abilities.
  • Fixed an issue that sometimes caused Arch-Suppressor Laguas to become afflicted with Thrall’s Earthen Crush ability and permanently evade all oncoming attacks.
  • Fixed an issue that allowed Unnatural Power to be removed with mind control abilities.
World Quests
  • Fixed an issue where some players could not see the obstacles during the Bastion World Quest, “Flight School: Flapping Frenzy.”
  • Increased the respawn rate of the enemies required for completing “Pest Removal.”
  • “Calling the Champions” now gives credit to all party members.

NOVEMBER 25, 2020

  • Players can now hearthstone from the Maw despite being afflicted with Immediate Extermination.
  • Demon Hunter
    • Vengeance
      • The impact from Soul Cleave now has sound.
  • Paladin
    • Retribution
      • Execution Sentence (Talent) now has a more pronounced sound.
  • Rogue
    • General
      • Resolved an issue that prevented the reactivation of Flagellation (Venthyr Ability) and granting Haste while the Rogue’s target is still alive.
  • Beginning construction of the Venthyr Anima Conductor now properly consumes available Anima.
Creatures and NPCs
  • Battle Ready Tauralus can no longer be interacted with while mounted.
  • Male Gilnean guards now have male voices.
  • Stygian Abductors now abide by the laws of gravity after being slain.
  • Resolved an issue that caused the Forlorn Prisoner’s Forlorn’s Grace buff to increase damage instead of decrease damage.
  • A Plague Guard now stands watch at the Mareileth Camp in Blighted Scar.
  • Fixed an issue where Sundancer’s Echo of Dresaelus buff could be taken into unintended areas.
Dungeons and Raids
  • Mists of Tirna Scithe
    • Fixed an issue in the Misty Forest where a maze door would not open when approaching the door from the side.
    • Slain gorms should now drop loot as intended.
    • Tred’ova
      • Fixed an issue that sometimes caused Mink Link to become unbreakable if targeted players were 40 yards apart when the spell was cast.
  • Theatre of Pain
    • Mistress Dyrax
      • Players are no longer afflicted by Mass Temptation after combat has ended.
Items and Rewards
  • Fixed an issue which caused Selfless Forgelite’s mail armor on Forgelite Neptira to be incorrectly ineligible for purchase and use in transmogrification.
  • Slumberwood Band can no longer trigger in Arena or Rated Battlegrounds.
  • Veiled Satchel of Cooperation can now be opened from characters level 50 to 60. Satchels earned prior to the fix will require reaching level 60 to open.
  • The Garb of the Harmonious transmogrification set now displays the correct chestplate.
  • Turning in Twinklestar’s Gardening Toolkit to Twinklestar no longer consumes other players’ toolkits.
  • Many Shadowlands Inscription supplies can now be placed in an Inscription bag.
  • The Brimming Ember Shard trinket channel is now intentionally interrupted when casting another spell during the channel.
  • Covenant Campaign
    • Fixed an issue where players who choose to skip portions of Chapter 1 of their Covenant Campaign would not have any Redeemed Souls available to them. Players who experienced this issue should now receive the Redeemed Souls the next time they visit their Covenant Sanctum.
    • Fixed an issue where the quests following the Covenant Campaign quests “A Call to Service” could become unavailable if players logged out before accepting the next quest.
    • Fixed an issue where the Kyrian Covenant Campaign quest “Our Most Precious Resource” could become unavailable if players logged out before accepting it.
    • Fixed an issue where players aligned with the Kyrian Covenant who skipped the campaign quest “It’s All Coming Together” would not see the chapter “Among the Kyrian” as complete.
    • Sesselie now appears in the appropriate phase to offer the Night Fae Covenant Campaign quest “Replenish the Reservoir.”
    • The patrol have bolstered themselves and can no longer be defeated while on the Night Fae Covenant quest “A Night in the Woods.”
  • Bastion
    • Fixed an issue where players could be unintentionally killed while escaping the Necrotic Wake during the quest, “A Time for Courage.”
    • The objective to the quest “The Mnemonic Locus” should now be visually clearer.
    • A teleportation pad is now available to use after jumping off the platform while completing “The Hand of Doubt” in Bastion.
  • Maldraxxas
    • Stringy Spores and Stringy Growths are now visible on the minimap for easier collecting during the quests, “Spores Galore” and “Pulling Hairs.”
    • The Unfinished Blade required for “Through the Fire and Flames” can now be looted by multiple players at the same time and respawns faster.
    • Players who defeat Cheliceria without first obtaining the Key of Eyes will no longer be blocked from completing the quest, "WANTED: The Key of Eyes.”
    • Aspirant Thales and the Rune of Might are now immediately available after exiting the Soulfused Construct during the quest, “In The Flesh.”
    • Renny the Fox, the sly star of “That Darn Fox” has been given a stern talking to and should be responsive to players trying to catch him after their heroic rescue in Maldraxxus.
    • Increased the respawn rate of the enemies required to complete “The Hunt for the Baron.”
  • Ardenweald
    • Fixed an issue where players who completed “Shooing Wildlife” would not see Dreamweaver to start “Tending to Wildseeds.”
    • Guardian Molan is now visible for turning in “Blooming Villains.”
    • Te’zan and Nia now return to the forest after completing “Recovering the Heart” in Ardenweald.
    • Primrose will now correctly stealth if the player uses stealth during “Break it Down.”
  • Revendreth
    • Characters should no longer get stuck in combat for extended durations in the Ember Ward while on the quest “An Uneventful Stroll.”
    • Lord Chamberlain’s Protection now applies to all party members on the quest “The Accuser’s Secret.”
    • Fixed an issue where some players were unable to speak to Vorpalia to complete the quest “In the Ruin of Rebellion.”
    • Prince Renathal should now make an appearance at the end of the “Master of Lies” scenario even if players have killed all the Royal Nightcloaks between Myskia and Sire Denathrius.
  • Fixed an issue where the fight event during the Rogue Order Hall Campaign quest “Picking A Fight” would sometimes not start.
  • Master Cheng now deals appropriate damage while on the Monk quest, “Begin Your Training: Master Cheng.” Master Hight had a talk with Cheng about how many new monks were being battered, bruised, and literally set on fire within the Peak of “Serenity” and asked that he scale it back a bit.
The Maw: Eye of the Jailer
  • Fixed an issue where players who reached Threat Level 5 would still have the Eye of the Jailer Stygia and Ve’nari Reputation reduction debuff the next day.
Torghast, Tower of the Damned
  • Fixed an issue that prevented Frostbite Wand (Torghast Anima Power) from healing targets under the effect of Cyclone.
World Quests
  • The manifestations for “Swarming Souls” now respawn more frequently and the completion requirement has been lessened.
  • Fixed an issue where some players could not interact with Gatamatos during the Bastion World Quest “Training Regimen.”
  • Increased the health of the accompanied dredger and the time between waves of enemies for “Demolition Detail”.
November 24, 2020
  • Hunter
    • General
      • Resolved an issue where Hunters leaving their Resonating Arrow (Kyrian Ability) area effect could apply the Resonating Arrow debuff to unintended targets.
      • Wild Spirit’s (Night Fae Ability) visual effects now appear for enemy players.
  • Monk
    • General
      • Calculated Strikes (Potency Conduit) no longer causes Spinning Crane Kick to deal less damage than intended when using a two-handed weapon.
    • Windwalker
      • Resolved an issue that prevented Bonedust Brew (Necrolord Ability) from refunding Chi when using Spinning Crane Kick.
  • Shaman
    • General
      • Deathseer Choker (Torghast Anima Power) now properly increases the damage of any summoned units.
      • Vesper Totem (Kyrian Ability) will no longer incorrectly pulse a heal when casting Stormkeeper (Talent) as Elemental and Enhancement specializations.
    • Elemental
      • Fixed an issue that allowed Chain Harvest (Venthyr Ability) to work with Echoing Shock (Talent).
    • Restoration
      • Mana Tide Totem will no longer incorrectly applies to enemy players in PvP combat.
  • Warlock
    • General
      • Fixed an issue that caused Smoking Shard of Teleportation (Torghast Anima Power) to not work properly if an active demon isn’t summoned.
Creatures and NPCs
  • Zo’sorg and Purveyor Zo’kuul went on a brief hiatus while an issue was being resolved. The PvP vendors should now be back in Oribos at the usual location.
  • Players above level 50 now properly retain their full combat bonus when fighting enemies from the Legion expansion.
  • Fixed an issue where some of the Aspirant Defenders at Aspirant’s Rest in Bastion would not help nearby players. They have since come to an agreement that you need no further training and are once again ready to assist.
  • Indomitable Schmitd should now react to the Fuseless Special bomb more reliably.
  • Foreman Thorodir is now immune to damage and will accept your quest turn in without interruption from nearby gorm.
Dungeons and Raids
  • Spires of Ascension
    • The kyrian in Path of Ascension will stay lower to the ground when using their diving attacks.
Items and Rewards
  • The Phial of Ravenous Slime toy has been temporarily disabled.
  • Pinch of Faerie Dust should now only be usable in Ardenweald, and should be unavailable inside dungeons, including Mists of Tirna Scithe.
  • Kyrian Javelins are no longer able to be used against enemy players.
  • The Empyreal Ordnance trinket from the Spires of Ascension dungeon should now only drop for caster specializations.
  • The Overflowing Ember Mirror trinket no longer double dips into Versatility.
  • The Brimming Ember Shard trinket channel has been reduced to 1.2 seconds (was 6 seconds) and the number of pulses during the channel has been increased. Additionally, the overall healing has been increased by 36% and the overall damage increased by 56%.
  • Alchemy
    • Spectral Flask of Power should no longer provide a 2 hour duration for non-Alchemists.
  • Leatherworking
    • Bone Bound Knuckles are now Bind on Equip.
  • Changed a setting that should allow players to consistently see and interact with others in their group in the four Shadowlands zones and the introductory Maw.
  • The quest “Shadowlands: A Chilling Summons” should no longer be offered to players who have not activated the expansion.
  • All quest credit for “Through the Shattered Sky” is now shared with all party members when Party Sync is enabled.
  • Horde players on the Battle for Azeroth War Campaign will automatically be removed from the instanced version of Orgrimmar while on the introductory quests for Shadowlands.
  • The Echoes of Mortality required for the quest “The Eternal Traveler” are now obtainable in the Shadowlands.
  • Darion Mograine should no longer be phased out for some party members before accepting the quest “Field Seance”.
  • Fixed an issue that caused players to disconnect if they fall into the Maw’s dark abyss during the introduction questline. The Jailer won’t be pleased to hear the news of your escape…
  • Fixed an issue where party members were unable to see Thanikos Spinerender during the Bastion quest “A Time for Courage”.
  • Fixed an issue during the Bastion quest “A Temple in Need” where Galistos’ Burdens would appear before players had successfully completed the previous wave of Galistos’ Burdens.
  • Fixed an issue where the Hurl Kyrian Hammer vehicle ability could fail to appear during the Bastion quest “The Enemy You Know”.
  • Players may now turn in the Bastion side quest “Functioning Anima Core” to Kalisthene when they first meet her during the campaign quest “Go in Service”.
  • Fixed an issue where players who were not eligible to close Swelling Tears in Bastion could see them.
  • Fixed several issues that would prevent Andira from being retrieved for some players during the quest, “Larion at Large”.
  • Fixed an issue where neutral enemies would attack players unprovoked during the Bastion world quest “A Crisis of Memory”.
  • Adjusted the Ardenweald Campaign so that it will no longer overlap with the Maldraxxus Campaign.
  • “The Arbiter’s Will” and “The Land of Strife” are now under Chapter 1 of the Maldraxxus Campaign.
  • Secutive Mavix no longer disappears after abandoning the Maldraxxus quest, “A Deadly Distraction”.
  • Ve’nari’s Anima Shroud stealth aura has been buffed while on the quest, “Delving Deeper”.
  • The quest objectives needed to complete “Hazardous Waste Collection” should now spawn more frequently.
  • Players can no longer be attacked by enemy players while under the effects of Paralytic Plague during the quest “Fit For a Margrave” and while stunned in the air during the quest “Through the Fire and Flames”.
  • Baroness Vashj is now able to multitask and will accept the turn in for the Maldraxxus quest “Straight to the Heart” while she’s engaged in combat. She does have four arms after all.
  • Quest credit for “A Bond Beyond Death” will now continue after defeating Deslan the Torturer.
  • Fixed an issue that could sometimes cause the cutscene in the Grove of Awakening to fail to play.
  • Fixed an issue where grouped players could have a party member become unable to complete the Ardenweald quest “Wildseed Rescue”.
  • Fixed an issue where the Blighted Beast would become stuck with no way to complete the quest, “Toppling the Brute”.
  • Dreamweaver’s position has been updated for accepting the quest, “Hungry for Animacones”.
  • Flutterby has given her questly duties to Sesselie so now players can turn in the quest “Replenish the Reservoir”.
  • While on the Revendreth quest “A Reflection of Truth”, the ground visual for Crimson Barrage should remain visible when Projected Textures is disabled in the System Settings menu.
  • Fixed an issue where grouped players could have a party member become unable to complete the Revendreth quest “A Reflection of Truth”.
  • “The Master of Lies” scenario will now advance beyond Stage 1 for the entire party, regardless of watching or exiting the cutscene. Additionally, the area required for completing Stage 3 is now easier to locate.
  • The Signaling Beacon required for completing the Maw quest “Rule 3: Trust is Earned” should no longer be affected by combat in its vicinity.
November 23, 2020
  • Druid
    • General
      • Fixed an issue where characters would occasionally be shifted out of Travel Form when logging in after being disconnected or force quitting the game.
    • Balance
      • Fixed an issue where Adaptive Swarm (Necrolord Ability) would not increase the damage of damage over time effects.
    • Feral
      • Each Ferocious Bite from Convoke the Spirits (Night Fae Ability), with Sabertooth (Talent) selected, should now extend Rip by 5 seconds.
  • Priest
    • Shadow
      • Shadowform is now learned at level 10 (was level 12).
      • Devouring Plague is now learned at level 12 (was level 10).
  • Mage
    • Frost
      • Resolved an issue where Ray of Frost (Talent) would sometimes not grant 2 charges of Fingers of Frost after the channeled icy beam has completed.
Creatures and NPCs
  • Fixed an issue that could cause Mothbane the Mighty to despawn immediately when engaged in combat.
Dungeons and Raids
  • Halls of Atonement
    • Halkias
      • The damage from Refracted Sinlight should now properly align with the beam’s visual effect.
  • Black Rook Hold
    • Reduced the damage from being hit by boulders in the boulder gauntlet.
Items and Rewards
  • The Draught of Ten Lands is now capped at level 49 (was level 50).
  • The maximum level on Lightning-Forged Augment Rune has been increased to 59 (was level 50).
  • Ashjra’kamas, Shroud of Resolve will no longer grant Draconic Empowerment for characters above level 50.
    • Heart of Azeroth
      • Fixed an issue that could cause some characters who had previously used Laser Matrix (Azerite Trait) to enter combat with creatures even after the trait was unequipped.
  • The Death Gate to the Maw should now be available when ready to turn in the Alliance quest, “The Path to Salvation”.
  • Fixed an issue where groups doing the Bastion quest “The Work of One’s Hands” could get into a state where the heat bar would fail to progress.
  • The House of Rituals has sent reinforcements to Bastion, resulting in more available targets for the quest “Double Tap”.
  • Fixed an issue where groups could have difficulties completing the Bastion quest “Step Back From That Ledge, My Friend”.
  • Fixed an issue where interacting with Vulnerable Aspirants would dismount you during the Bastion quest “On the Edge of a Revelation”.
  • Necrotic Droplets in the Temple of Courage are no longer level 60 and are very sorry for being so aggressive.
  • Fixed an issue where Gerdus would not always be available to turn in the Bastion quest, “WANTED: Gorgebeak”.
  • Fixed an issue that caused the name of The Jailer to be missing from the subtitles in the Maw cinematic.
World Events
  • Death Rising vendor, Crusader Adevald Ironbeard, has found his way to the Argent Tournament grounds and has stationed himself alongside the tournament reward vendors.
2020-11-23 21:12:41
submitted by blue_trackerbot to blue_tracker [link] [comments]

2020.12.01 01:55 fightshade I’m using VBA to copy data from multiple sheets to another single sheet and would like to make it more efficient if possible.

I’m using excel to convert data from a spreadsheet into xml for translation into a data service. I have a vba macro to pull data from the first sheets in a specific order and put them into a single tab for easy translation.
I’m wondering if there might be a more efficient way to do this. Currently, 8-10k rows takes 45-60 minutes. I have a representative example of the vba I’m using. I’ve cobbled it together and tweaked it over the last few weeks. This was my first attempt at using vba.
Private Sub CommandButton12_Click()
Application.ScreenUpdating = False
Dim blankrowMG As Long, lastrowMG As Long, iMG As Long lastrowMG = Sheets("Group").Cells(Rows.Count, 1).End(xlUp).Row
Worksheets("XML").Cells.ClearContents Worksheets("XML").Range("A1").Value = "placeholder"
For iMG = 1 To lastrowMG If Sheets("Group").Cells(iMG, 1) <> "" Then Worksheets("Group").Cells(iMG, 1).Copy blankrowMG = Sheets("XML").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Sheets("XML").Cells(blankrowMG, 1).PasteSpecial Paste:=xlPasteValues End If Next iMG
blankrowxml = Sheets("XML").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row Worksheets("XML").Cells(blankrowxml, 1).Value = "placeholder" With Sheets("XML") .Range(.Range("A1"), .Range("A1").End(xlDown)).Copy End With
Application.ScreenUpdating = True MsgBox (“XML copied to clipboard.") End Sub
submitted by fightshade to excel [link] [comments]

2020.12.01 01:00 k9centipede 2020 December Tournament Announcements

Welcome to the December Tournament for WizCARD 2020!
With the popular success of the May 2020 WizCARD Tournament Extra Credit, the staff of /HarryPotter are excited to bring it back as a recurring quarterly event!

What is WizCARDs?

For those that did not participate in the previous extra wizCARD activities, or need a refresher, WizCARD is a fast paced "Card Game", utilizing rules similar to Rock Paper Scissors.
Cards can be 1 of 3 TYPES (Creature, Spell, Item) and 1 of 4 COSTS (Fire, Earth, Air, Water), with each card having a unique name. A total of 120 cards, of equal variety, will be utilized per round. Each round ends once all cards have been played (or a time limit is met).
Creature beats Item. Item beats Spell. Spell beats Creature.
Fire beats Air. Air beats Earth. Earth beats Water. Water beats Fire. Earth and Fire are Neutral. Air and Water are Neutral.
When playing, the Type is versus the card played BEFORE you (worth +5/-5/0), while the Cost is versus the card played AFTER you (worth +2/-2/0).
There is a single Google Form and Sheet to play through, with 7 11 randomly selected cards on display. The card selection updates after every card played, or after an hour of no play.

December Announcements

We’ve done some adjusting to take in the opinions and suggestions from the players of the previous tournament. This is still a work in progress, so keep notes of what you do and do not like as the month progresses, and we will take your concerns into consideration for the next tournament in March 2021!
We have the same Discord chat for the activity. Forms and Sheets will be new. There will also be a new Verification Thread that everyone must re-verify in.
The complete deck size in play this month will be 288 cards. There will be 36 Power Cards in play this month, they are denoted with a ! at the end of the name on the form, as well as a description in the form text. (the full list will be on the sheet and also provided in a comment below).
Bug Policy (simplified): If you see a bug, report it in the Discord ASAP (the first spotter gets a special flair!). Game will be shut down until the bug is repaired.
We will retain the 1 Captain Reshuffle per Round. Hand-size is 11 cards.
Power-Ups and Hourly Doubling are both also still in play.
Power-Up: If 3+ cards in a row match a House’s Element (Gryffindor = Fire, Hufflepuff = Earth, Ravenclaw = Air, Slytherin = Water) that House gets a Power-Up worth 3 pts.
Hourly Doubling: If all 4 Houses play during a single hour, all points earned are doubled.
First Big Change:

Introducing ROUND ZERO!

We will now start the month off with a low-stakes, near-no-limit*, no-add-on, no-teams, full deck speed-run game! This will calibrate where the houses’ stats will start off too. This will start some time on Tuesday Dec 1st. No House Points will be awarded based on this round, but beginning stats will be calculated from it.
* Limits will be 1 hr cool down, 15 cards per hour, 15 card streak

December Schedule

There will be 7 Rounds, each with 3 days set aside of them, with a break for the Christmas Holiday. The first 3 and the second 3 sets will have different pairing mechanics (see below), while the last round will be similar to Round Zero with no pairing mechanics. Round Start Times will remain on the fly, with intention for a 1-hr heads up (in discord) before they begin.

Set A, Rounds 1-3: Versus

This set will have each House competing against just 1 other House at a time (like Quidditch!)
  • Dec 3rd - Gryffindor vs Hufflepuff & Ravenclaw vs Slytherin
  • Dec 6th - Gryffindor vs Ravenclaw & Slytherin vs Hufflepuff
  • Dec 9th - Gryffindor vs Slytherin & Ravenclaw vs Hufflepuff

Set B, Rounds 4-6: Pairs

This set will have each House paired up with another House to possibly win the Gold Medal (same as back in September)
  • Dec 13th - Gryffindor & Hufflepuff vs Ravenclaw & Slytherin
  • Dec 16th - Gryffindor & Ravenclaw vs Slytherin & Hufflepuff
  • Dec 19th Dec 21th - Gryffindor & Slytherin vs Ravenclaw & Hufflepuff

Set C, Rounds 7: Full

This set will have no pairings and no versus.
  • Dec 27th - All Houses


All adjustments mentioned below will ONLY occur between Sets. So, After Round Zero, then after Round 3, and again after Round 6. Your House Captain is your Team’s liaison to discuss changes and to get your voice heard.

Stat Changes

  • When sets get applied after Round Zero, they will (potentially) start as: Cool-Down: 4 hours Streak Limit: 3 cards Hour Limit: 5 cards
After each set, the total points earned by each house will be calculated, as well as what % they earned of the total points earned.
Houses that earn >33% of the total points, will LOSE a stat value. Houses that earn <18% of the total points, will GAIN a stat value. Houses that ranked 4th anytime in the previous set can move 2 stat values around. Houses that ranked 3rd anytime in the previous set can move 1 stat value around.
(This system may be adjusted on the fly, not written in stone, but any changes will be made with a consensus of the Staff & Captains, and explained as transparently as possible).

Add-On Changes

After Round Zero, EACH House will get to pick 1 item from the Add-On Menu to be used for the duration of the game. This will be a blind choice, with each house NOT knowing what the other houses pick until choices are declared. If there are any overlaps, no new choices are made.
Between sets, any house that got 4th or 3rd place, can opt to add into play, or remove from play, 1 Add-On.
Player Bonus Options
  • Joker Card Bonus (play the last card submitted in the previous round)
  • Random Player Bonus (randomly selected at end of game)
  • Last Card Bonus (last to earn points with a card)
  • Longest Play Bonus (x2 players with biggest gap between them)
House Bonus Options
  • Quidditch Bonus (house with lowest average speed for plays)
  • Mugwump Bonus (house that first plays all 12 card options)
  • Order of Merlin Bonus (house that gives most points to 4th place)
Other Add-On Options
  • Daily Double (random secret card is worth x2)
  • Speedrun Finale (last 12 cards have no time limits or hour limits)

Card Changes

The game will start with the 36 power cards that were created last Tournament. We may adjust/remove/add them between sets as feels appropriate to do so, to keep the game as balanced as possible. We also may adjust the deck size as needed to keep on schedule.
An additional mechanics that will NOT be in play this Tournament, but is written down for consideration for future tournaments:
Each house is ranked by total points earned, and given the option to swap out cards from the deck with cards from a pool set-aside, with 4th place swapping 4 cards, 3rd place swapping 3 cards, 2nd place swapping 2 cards, and 1st place swapping 1 card.

General Notes

Please remember that this is intended for entertainment and enjoyment. Good Sportsmanship is expected from all participants, as well as understanding that this IS a competition. Although working with other houses can be an asset in some parts of the game, it is not required. There are multiple avenues for houses to succeed, and to enjoy themselves, and it is up to each house individually to decide how they will play and what strategy will help them win.

House Points

Currently we have 300 house points.

VIPs & MVPs.

VIPs will work by taking the top 25% of players PER ROUND by point total, and sorting them by Card Point Average, and giving the top 4 1st/2nd/3rd/4th Place VIP.
MVPs will work by taking the top 25% of players ALL MONTH by point total, and sorting them by Card Point Average, and giving the top 4 players over-all, and per House, MVP.
Each 1st/2nd/3rd/4th Place VIP earned will be worth 10/9/8/7 credits respectively. Each House MVP earned will be worth 6 credits. Each Over-All MVP earned will be worth 5 credits.
100 House Points split among all VIP/MVP Credits earned.

House Rankings

During the Paired Set, in addition to individual ranks, Houses can earn Gold Medals. During the Versus Set, houses will get credit for being 1st or 2nd in their pairing.
Each 1st/2nd/3rd/4th Ranking earned will be worth 10/9/8/7 credits respectively. Each Gold Medal earned will be worth 5 credits.
100 House Points split among all House Ranking Credits earned.


There is an unknown amount of bonuses that will be available throughout the tournament for Houses to earn. Each Bonus is worth 2 credits.
100 House Points split among all the Bonuses earned.
For additional ways to earn House Points, visit /HPStudyHall!

Edits and Comments Logged Here

  • fixed the Round 6 date from Dec 21 to Dec 19th
  • if there is enough interest we will have another R0 game over Christmas for anyone wanting a chance to socialize
submitted by k9centipede to wizCARDs [link] [comments]

2020.11.30 23:55 alessg10 How would I convert this code into a class?

import pygame # Define some colors BLACK = (0, 0, 0) WHITE = (255, 255, 255) BLUE = (0, 0, 255) RED = (255, 0, 0) WIDTH = 20 HEIGHT = 20 MARGIN = 5 # Create a 2 dimensional array. A two dimensional # array is simply a list of lists. grid = [] for row in range(10): # Add an empty array that will hold each cell # in this row grid.append([]) for column in range(10): grid[row].append(0) # Append a cell # Set row 1, cell 5 to one. (Remember rows and # column numbers start at zero.) grid[1][5] = 1 # Initialize pygame pygame.init() # Set the HEIGHT and WIDTH of the screen WINDOW_SIZE = [255, 255] screen = pygame.display.set_mode(WINDOW_SIZE) # Set title of screen pygame.display.set_caption("Battleship") # Loop until the user clicks the close button. done = False # Used to manage how fast the screen updates clock = pygame.time.Clock() # -------- Main Program Loop ----------- while not done: for event in pygame.event.get(): # User did something if event.type == pygame.QUIT: # If user clicked close done = True # Flag that we are done so we exit this loop elif event.type == pygame.MOUSEBUTTONDOWN: # User clicks the mouse. Get the position pos = pygame.mouse.get_pos() # Change the x/y screen coordinates to grid coordinates column = pos[0] // (WIDTH + MARGIN) row = pos[1] // (HEIGHT + MARGIN) # Set that location to one grid[row][column] = 1 print("Position of mouse:", pos, "Grid coordinates: ", row, column) # Set the screen background screen.fill(BLACK) # Draw the grid for row in range(10): for column in range(10): color = WHITE if grid[row][column] == 1: color = BLUE pygame.draw.rect(screen, color, [(MARGIN + WIDTH) * column + MARGIN, (MARGIN + HEIGHT) * row + MARGIN, WIDTH, HEIGHT]) # Limit to 60 frames per second clock.tick(60) # Go ahead and update the screen with what we've drawn. pygame.display.flip() # Be IDLE friendly. If you forget this line, the program will 'hang' # on exit. pygame.quit() 
How would I turn the code above into a class where I could then put the main program loop into a controller class for a game?
# -------- Main Program Loop ----------- while not done: for event in pygame.event.get(): # User did something if event.type == pygame.QUIT: # If user clicked close done = True # Flag that we are done so we exit this loop elif event.type == pygame.MOUSEBUTTONDOWN: # User clicks the mouse. Get the position pos = pygame.mouse.get_pos() # Change the x/y screen coordinates to grid coordinates column = pos[0] // (WIDTH + MARGIN) row = pos[1] // (HEIGHT + MARGIN) # Set that location to one grid[row][column] = 1 print("Position of mouse:", pos, "Grid coordinates: ", row, column) 
code link
submitted by alessg10 to learnpython [link] [comments]

2020.11.30 20:19 TheElectrician01 New Quests/Achievements are too "hard"?

With the new quest system, and achievement system out, I've been playing trying to "maximize" my efficiency for completing tasks while still playing the modes I find fun. Seeing as though I don't have infinite money to spend, and I've only been playing for a little over a year, I am aware that there are many many quests and achievements that I just won't be able to accomplish ever, and that is alright, with enough time I'm sure I will get them one day maybe.
There are however a few quests in particular that are extremely hard to get (Mostly in the Weekly quest section), though until today I have not had any problems earning them with some time and a little luck. A few I have to re-roll like the Play 10 Old-Gods since I only own one right now, and consistently getting them in games and being able to play them is really hard. The one that I got today, and wasn't able to Re-Roll since I rolled another was to Win 4 Games in Arena (In one run, not just 4 wins).
I have not played Arena in a long time, and I thought "well, 4 out of 12 seems reasonable, hard, but reasonable" Additionally it is the last quest I have to do to earn the Achievement for get all 12 Weekly Quests done in 1 Month. Great right?
No, even with the assistance of some tier lists, and recommendations, my own intuition, and experience with MTG drafts. I have now spent all morning, and a total of 3,000 Gold, and the highest run that I achieved was 3 Wins. I even once got 3 Wins in a row and then immediately lost 3 in a row... This is the most frustrated I have been with a game/card game in possibly ever. I am now out of Gold, and Don't really want to spend $2 to attempt again today. (Which on a different note this is one of the only quests that technically requires you to SPEND money to participate in) At least one of the only I've seen so far that requires you to spend money.
So my 11/12 Weekly quests, and pretty much this week until I make it to the next level of the reward track to get another 150 Gold to possibly try again. Those have come to an end today. I will of course get another opportunity tomorrow, but this is ridiculous. I know ultimately that the Arena losses are my fault, some mis-play, or bad pick, or something because I am an average player at best, not a professional. In fact I only just reached Diamond 10 today because my other weekly quest was the win 7 Standard games, which was also quite hard today. But that quest is at least free.
I really wish that Blizzard and Hearthstone was "cheaper" or at least they modify the new quests and achievements...Thank you!

S.N.; If anyone has any suggestions on maybe how to get 4 wins in Arena I'd be open!
Update; after getting a couple levels and getting some feedback, I've attempted now 6 more times at the arena, and have still not made it to four wins.
submitted by TheElectrician01 to hearthstone [link] [comments]

2020.11.30 17:16 coastalsagebrush Tracking keeps saying that customer was unavailable

Hi there!
So I ordered something offline and they shipped it out through FedEx. It was supposed to arrive yesterday but the tracking info updated to "Delivery exception (Customer not available or business closed)". Says it's out for delivery today again.
This happened last time something came through FedEx too except that was some time sensitive bank documents. 2 times in a row they said that the customer was not available even though everyone was home. I ended up having to call them and pick it up in store but for this new package, I don't even have a tracking number. The website tracks it through the order number.
Why does FedEx keep doing this? My house isn't hard to get to. There's no gate. They could just leave the package at the door like UPS/Amazon/and even USPS does. If they ever came because both instances I've been home all day waiting for the delivery and a FedEx van has never driven by.
submitted by coastalsagebrush to FedEx [link] [comments]

2020.11.30 16:48 Bond_em7 [Confounded Memories] JP Megathread (XII)

I know I'm late on this due to the holiday and the VI event is also dropping so I hope to get both up here in short order. It should be noted that I saw an update where you can turn off the Historia Crystal BGM here so for global we should see the same by this event (we usually get QoL changes like this early).
Normal weekly event with a Stroke of the Brush - The Forsaken. The inital reveal and discussion is here. The last XII event was only about 3 months ago.
Thanks to Stylus_Index and onthefaultline for the translation work, dataminers like ElNinoFr (and other I'm sure), and S0litair3d as always for the posts on GameFaqs that allows me to do these and also thanks to Pyrotios for always checking my work and helping make sure these things are accurate.

Recent JP Megathreads

Journey through the Dark City (IX) Core Torment (Core/Beyond) Fat Black Chocobo: Shadowy Magicites Thrills and Treats/Dragonlord Bahamut (XIV) Clash of Gunblades (VIII) The Ultimate Magic (II) Confounded Memories (VI) Fat Black Chocobo: Radiant Magicites A Tender Melody Dedicated to You (IV) Fat Black Chocobo: A Howling Forgery (FBC)

Fantasy Fest 2020

Megathread Relics

Helpful Links

General JP Version Information FFRK Community Database AASBs without En-Element and where to get it (RunAwayWojo)

Confounded Memories (XII)

Event start time: 27/11 15:00 JST
New True Arcane Vaan
New Sync Vayne, Reks
New Limit Overflow Vayne
New Awakening Vayne
New Flash Art Vayne
New LMR Vayne, Reks
Record Boards:
  • Vayne
Record Board Abilities:
  • Vayne: "Force of Will" PHY/BLK(Darkness): 6x single hybrid Dark.
  • Reks: "Sword Combo" PHY(Spellblade): 6x single Lightning.

Relic Draw Banners

Banner 1
Relic Type Character Soul Break/Legend Materia
Ruby Chestplate (Stat/CT/Cost) Light Armor (Wind+) Vaan True Arcane: "Pyroclasm Inferno" (NAT: Instant self En-Wind (stacking), BDL+1, "True Arcane Augment Mode", ZSBC).
Recompense (DMG/CT) Sword (Dark+) Vayne Synchro: "Stalk of Sephira" (PHY/BLK: 15x single ranged hybrid Dark/NE; self ATK/DEF +50% OR MAG/DEF +50%, En-Dark(3 stacks), Synchro Mode, BDL+1, "Rising Dynast").
Rudra Tulwar R (DMG/CT) Sword (Lightning+) Reks Synchro: "Dalmascan Whorl" (PHY: 15x single Lightning/NE; self En-Lightning(3 stacks), Synchro Mode, BDL+1, "Dalmascan Hazard").
Enigma (DMG/CT) Sword (Dark+) Vayne Limit Overflow: "Contempt" (PHY/BLK: 4x single piercing critical ranged hybrid Dark overflow).
Muted Steel (DMG/CT/Use) Sword (Dark+) Vayne Awakening: "Wave of Darkness" (PHY: 15x single ranged hybrid Dark/NE; party IC1; self En-Dark (stacking), "Awoken Striving Politician Mode", BDL+1).
Javelin (DMG/CT/Use) Spear (Lightning+) Reks Awakening: "Dalmascan Swornblade" (PHY: 15x single Lightning/NE; party ATK/MAG/DEF/RES +30%; self En-Lightning, "Awoken Lightning Mode", BDL+1, "Dalmascan Oath").
Dragon Whisker Spear Basch Chain: "Bulwark of Hope" (NAT: Instant party ATK/MAG/DEF/RES+30%, XII 99-chain, 50% XII Field, IC1).
Convalescent Clothes Light Armor Reks Ultra: "Thunderblade Rush" (PHY: 10x single Lightning/NE; party Guts; self En-Lightning, "Thunderblade Rush").
Hyper Wrist Bracer Vayne Flash+: "Shadow of Solidor" (NAT: Instant 1x single ranged hybrid Dark/NE overflow; self En-Dark (stacking), ZSBC).
Venetian Shield Shield Basch Flash+: "Heroic Loyalty" (NAT: Instant self 500 SB Points, ZSBC).
Mythril Armor Heavy Armor Vayne LMR+: "Boost (Vayne)" (Boost: Dark Damage +25%).
Crescent Sword Sword Reks LMR+: "Boost (Reks)" (Boost: Lightning Damage +25%).
Banner 2
Relic Type Character Soul Break/Legend Materia
Rudra Tulwar (DMG/CT) Sword (Wind+) Vaan Synchro: "Deep Impact" (PHY: 15x single Wind/NE; self En-Wind(3 stacks), Synchro Mode, BDL+1).
Genji Shield (DMG/CT/Use) Shield (Wind+) Vaan Awakening: "Luminescence" (PHY: 15x single Wind/NE; self En-Wind(stacking), "Awoken Thief Mode", BDL+1, IC Thief, "Luminescence").
Fran's Guise (DMG/CT/Use) Light Armor (Lightning+) Fran Awakening: "Thunderous Shatterheart" (PHY: 15x single ranged Ice/Lightning/NE; self HQC1, "Awoken Viera Warrior Mode", BDL+1, "Twin Element Mode II", "Flowing Mist").
Joyeuse Sword Larsa Awakening: "Soothing Wave" (WHT: Instant Medica h105, 100% Raise, Guts, Haste, Astra, Esuna; self "Awoken Potion Mode").
Valiant Gun (Fire+) Balthier Awakening: "Untouchable Blaze" (PHY: 15x single ranged Fire/NE; self En-Fire, "Awoken Fire Mode", HQC, BDL+1, "Scorching Shot").
Polaris Gun Balthier Chain: "Prodigal Son" (NAT: Party Haste, ATK/MAG+30%. FFXII Chain-150).
Recurve Crossbow Bow Fran Chain: "Consuming Frost" (NAT: Instant party ATK+50%, Ice 99-Chain, 50% Ice Field, Ice Damage +20%).
Celebrant's Miter Hat Larsa Ultra: "Shower of Potions" (WHT: Instant party h85 Medica, Crit Damage +50%, QC2).
Murasame Katana Vaan Flash+: "Spiral Wind II" (NAT: Instant self En-Wind(stacking), IC1, Zero SB Cost).
Chiron's Bow Bow Fran Flash+: "Unusual Marksman" (NAT: Instant self 500 SB, ZSBC).
Officer's Hat Hat Balthier Flash+: "Morning Fortune" (NAT: Instant self En-Fire(stacking), 250 SB Points, ZSBC).
Snow Scarf Light Armor Fran LMR+: "Enfeeble (Fran)" (Chase 3 Ice: ST 10% Imperil Ice).
Note: Bolded relics are new.
Available videos of the new relics SBs are linked to the relic names.
Video of all new relic animations here. (Thanks Kyzuki).
Modes and Notes
Banner 1
  • Vaan's True Arcane:
    • "True Arcane Augment Mode": BDL+1/2 and multiplier increased for second activation if at least 5/8 Wind abilities are used.
    • "Apex Pyroclasm": (PHY: 20x single Wind/NE, 1x single Wind/NE overflow; self Remove "True Arcane Augment Mode").
  • Vayne's Synchro:
    • Attack (Dark) "Coup of Darkness": (PHY/BLK: 6x single ranged hybrid Dark/NE; self ?~?% maxHP recoil with ?~? uses, BDL+1 1).
    • Defend (Dark, "Rising Dynast") "Dark Tactics": (PHY/BLK: 1x single ranged hybrid Dark/NE overflow; self ?% maxHP recoil, Dark Ability Damage +30% 2).
    • Defend (Dark, no "Rising Dynast") "Dark Tactics": (PHY/BLK: 1x single ranged hybrid Dark/NE overflow).
    • "Rising Dynast": Chase HP<20%: (PHY/BLK: 5x single piercing ranged hybrid Dark/NE; self 100% HP Recovery, Guts, remove "Rising Dynast").
  • Reks' Synchro:
    • Attack (Lightning) "Levin Pledge": (PHY: 6x single Lightning/NE; self Lightning Ability Damage +30% 1).
    • Defend (Lightning) "Sword Charge": (PHY: Instant 3x single Lightning/NE; self QC3).
    • "Dalmascan Hazard (0-3 XII hero alive)": (NAT: ST 10% Imperil Prismatic).
    • "Dalmascan Hazard (4+ hero alive)": (NAT: ST 30% Imperil Prismatic).
  • Vayne's Awakening:
    • "Awoken Striving Politician Mode": Unlimited Dark hones; Dark Rank Based QC; Chase Dark: (PHY/BLK: 6x single ranged hybrid Dark/NE). Chase every 2nd Chase: (NAT: Party Dark Damage +10%).
  • Reks' Awakening:
    • "Awoken Lightning Mode": Unlimited Lightning hones; rank boost (Lightning); auto WCast Lightning.
    • "Dalmascan Oath" (0-1 XII hero alive): Party 50% DR1.
    • "Dalmascan Oath" (2-3 XII hero alive): Party 50% DR1, +15% Weakness Damage.
    • "Dalmascan Oath" (4+ XII hero alive): Party 75% DR1, Party +30% Weakness Damage.
  • Reks' Ultra:
    • "Thunderblade Rush": Chase Lightning: Front-Row PHQC1.
Banner 2
  • Vaan's Synchro:
    • Attack (Thief) "Twisting Hazzard": (PHY: 6x single Wind/NE; party 40% DR1. Short CT (.825s)).
    • Defend (Thief) "Eager Notos": (PHY: Instant 3x single Wind/NE, If DR +DEF/RES/MND -30%).
  • Vaan's Awakening:
    • "Awoken Thief Mode": Unlimited Thief hones; rank boost (Thief); auto WCast Thief.
    • "Luminescence": Chase 2 Thief: Self En-Wind.
  • Fran's Awakening:
    • "Awoken Viera Warrior Mode": Unlimited Ice/Lightning hones; rank boost (Ice/Lightning); Chase Ice/Lightning: (PHY: 6x single ranged Ice/Lightning/NE).
    • "Twin Element Mode II": En-Ice/En-Lightning(stacking).
    • "Mist Flow": Chase 3 Ice/Lightning: Minor Imperil Ice OR Lightning; self [En-Ice, Ice Damage +10%] OR [En-Lightning, Lightning Damage +10%]).
  • Larsa's Awakening:
    • "Awoken Potion Mode": Unlimited White hones; rank based White cast speed x(2/2.2/2.4/2.6/3); Chase White: (NAT: Medica 1500, Esuna).
  • Balthier's Awakening:
    • "Awoken Fire Mode": Unlimited Fire hones; rank boost (Fire); auto WCast Fire.
    • "Scorching Shot": Chase 2 Fire: (PHY: 6x single ranged Fire/NE).
B1: I didn't see any responses last week on if this section was useful for people or not. I'm going to skip this week since I've got to get two of these up today but if you have an opinion on if my analysis is useful or not please leave it so I know going forward.
There's also an upcoming FFX/V/XIII/I Premium Lucky (Gem only, first pull half price). Here's what it has:
  • Wakka Sync (Water+ Blitzball)
  • Faris LBO (Wind+ Light Armor)
  • Wakka AASB2 (Water+ Bracer)
  • Faris AASB2 (Fire+ Light Armor)
  • Sazh AASB (Fire+ Gun)
  • Garland AASB (Dark+ Sword)
  • Wakka X 2.0 Realm Chain
  • Faris V 2.0 Realm Chain
  • Sazh XIII 2.0 Realm Chain
  • Garland I 2.0 Realm Chain
  • Wakka Flash+
  • Garland Flash+
If you spot any mistakes or have suggestions on how to improve the quality of my guides, feel free to comment here and I'll do my best to address them ASAP!
submitted by Bond_em7 to FFRecordKeeper [link] [comments]

2020.11.30 16:07 anglejongen Infinite "Preparing Automatic Repair" boot loop. / Unsure if software or hardware

Today, I decided to try and play around with the fan curve on my AIO. I have an extraordinarily loud system, so I wanted to tone it down a little bit. I did two things: I changed it in the BIOS (which didn't change much), and installed AI Suite 3, Asus' own software. I updated drivers from the suite, I edited my fan curves, and for several hours, all was well in the world.
6-7 hours later, as I was enjoying my much more pleasant gaming experience, my system crashed. I've had that often when trying to lower the fan curve on my GPU, I figured it would restart like it always does in such instances. Alas.
Since then, I've had the following loop happen:
  1. POST works.
  2. After POST, I get a "Preparing Automatic Repair" message.
  3. After a few seconds, system automatically reboots.
It can happen dozens of times in a row, and it never lasts more than 5-10 seconds without rebooting. I can access the BIOS, no problem. I've stayed in there for 30 minutes without issue. All my fans seem to be working, my CPU temp is a continuous 30-32C.
Steps taken so far:

Here are my specs from UserBenchmarks:
CPU: Intel Core i5-9600K - 95.2%
GPU: AMD RX 5700-XT - 106.9%
SSD: SanDisk SSD Plus 240GB - 52.9%
RAM: Team Group Inc. TEAMGROUP-UD4-2400 2x8GB - 81.6%
I also have a Deepcool GAMMAXX L240 V2 69.34 CFM Liquid CPU Cooler, a few other SDD and HDD, and a few case fans.
I'm stumped. What should be my next steps?
submitted by anglejongen to techsupport [link] [comments]

2020.11.30 14:34 MarkDMill Great deals for 11/30, including lots of WeMo deals, a massive Cuber Monday Mac bundle, and more

Oka Unarchiver has sponsored an ad-free MDM Deals this week and is giving away their premium version 100% free to MDM Deals fans. Oka Unarchiver is a fast, comprehensive, simple, and powerful, zip/unzip tool. Read more and get it free
I looked through over 660 deals and curated over $5,530 in savings for you. You’re welcome. If I've saved you money, would you kick back a portion and support this site via Patreon or Buy Me a Coffee? Patreon is ongoing with perks for you; Buy Me a Coffee is one-time; both are awesome and super appreciated.
Amazon Tech Deals for 11/30 ⠀ - Today's Amazon tech deals include:
submitted by MarkDMill to MDMDeals [link] [comments]

2020.11.30 13:40 dddiamonddd How do I get Excel to indicate which is the lowest of four (or more) values?

I'm setting up a spreadsheet to help me compare the best place to buy different groceries and to act as a reference point to recognise whether a deal really is a deal.
I've so far envisioned this spreadsheet as follows:
For example:
Say I have a row for Chicken. Retailer 1 has a price of £5.15 per kg, Retailer 2 has a price of £5.20 per kg, Retailer 3 has a price of £4.95 per kg, and Retailer 4 has a price of £5.19 per kg. I want the "Cheapest" column to return Retailer 3, and to automatically update the result when I tell the spreadsheet that a retailer has adjusted their price.
Alternatively, it would also be fine if I could have it highlight the cheapest of the four? I just want a nice obvious indicator of which is the cheapest really!
Bonus/Wishlist Item: This isn't necessary, as I'm quite happy to manually do this. However, it'd be really cool if I could also have a column that I can input a deal price into and have that column (or one beside it) update to confirm whether the deal is cheaper than the cheapest retailer. eg. from my example above, let's say Retailer 2 now has a deal and the price of chicken with that deal is now £4.85 per kg. I'd like it if I could just put that into this column and have it compare to Retailer 3 and come back with a yes or a no about whether it's cheaper. I know this is something that I could very easily work out myself, but I'm trying to externalise as much of the thinking as I can get away with haha.
Hopefully this makes sense!
Thank you in advance.
submitted by dddiamonddd to excel [link] [comments]

2020.11.30 06:38 Father-Son-HolyToast OP and his girlfriend have an argument about whether to get a new dog, and in a stunning escalation, the girlfriend retaliates by kidnapping OP's children (whom, to be clear, she has no relation to). [Posted 6 months ago]

This is a repost. The original post is by CertainQuestion2.
Hi there, in a bit of a bad situation right now what with the big blank on at the moment. Okay so basically me and my girlfriend have been going through a really big rough patch recently over a dog of all things. Bit of backstory our current dog was sold to us as a cross between a Jack Russel and a pug (A puggle if you will) but it turns out she's not one but is a cross between a pug and some sort of mystery dog and to make things worse we insisted on raising it 'free range' so that meant no leads, letting it go where it wanted when it wanted and leaving a bag of food out so it could eat when it felt like it. The aftermath is a very unsociable, angry and fat pug with joint problems that thinks it owns the world and has another year at best. My girlfriend is adamant she wants another dog and we've been arguing over what type (As she wants from the same dodgy breeder). Well last night it finally reached a breaking point when she announced that she's already contacted him and got us a deposit for one and that we're naming it 'Queenie'. Frankly fed up I said that's fine but it isn't coming inside the house, ever. A massive row ensued and I spent the night in the shed.
This morning come inside to find gf and kids gone with a note saying that the relationship can't go on anymore and said for me to not try and find her. Immediately rang our social worker who confirmed that they're 'all fine' and for their own safety they won't be telling me where they've gone. Pointed out that they're not actually her kids and was promptly hung up on. Tried contacting my ex (We have a cordial relationship, will explain in one sec) but she's been on voicemail all day. Contacted 101 who said there was nothing the police could do and to contact our social worker.
Okay so now here's the part I really need to explain, the kids are not my gfs, she's only their stepmum. For a bit of backstory there are two kids, one is 8, the other 6. Their real mum (And my ex) was always very unsure about having kids but was constantly talked out of getting sterilised and we ending up having two by accident. She does love them but felt she'd never be able to be a 'real mother' to them and her relationship is more akin to a big sister or a best friend. They get on really well but like I said, there's no real maternal affection and she didn't feel that married life was suited for her. We came to a cordial agreement and split shortly after our second was born. So yeah that's why I'm really horrified by this situation, they don't see my now ex-gf as their mother and when I looked in their rooms I noticed they hadn't taken their phones or ipads or anything, just school work and some clothes.
Is there anything I can do? Social worker won't talk to me and the police aren't getting involved. I've never been in a situation like this before and I honestly don't even know how to process this.
Mini update: Hello everyone, just wanted to thank everyone who's given me advice. I finally managed to speak with my ex-wife and she's with me at the moment. Complete news to her and she's utterly fuming. We've contacted the police again (On 101 might I add) and were fobbed off again (Mother isn't "involved", something she took offence at, and the social worker is handling things so no reason to be concerned). Ex-wife is both livid and deeply upset as there is a woman out there running around with our kids and she feels as though she's to blame. Also I checked and the passports are still here. Tried contacting her parents (Who I get on with) and they were blindsided by it too.
Mini update 2: Thank you everyone for being so supportive and helpful. Today has quite possibly been the worst day of my life and when I found that note I thought that was it. But you've all been so good and ex-wife is ringing 999 now. Will keep you all updated.
Hello all, seems I created a bit of a big scare, for good reason. For all of those who I was off my head, on drugs, etc. (You know who you are) well guess I was in shock.
Anyway not really much to say, ex-wife rang up 999, was a bit economical with the truth (Said woman had kidnapped her children pretty much), police get involved straight away and they're safe home now. Ex-gf is obviously in deep shit. As for the social worker, it seems that gf was telling people I was abusive, was on drugs 24/7, addicted to masturbating, etc. basically everything to make me seem utterly awful though apparently she's still in trouble. If you want to DM me about how awful of a person I am then don't bother as I won't be checking this account again. Big thanks to everyone who helped, and from now on going to not let the kids out of my site. Peace.
submitted by Father-Son-HolyToast to BestofRedditorUpdates [link] [comments]

2020.11.30 03:08 CD_Sheep [hiring] Trying again, reposting with more info from yesterday. Was excel project, but now maybe a java based web app that is hipaa compliant...

So I've posted this twice before. The first time I hired someone to do this project with excel and power query, per the recommendation. But they never delivered on the project.
I posted again yesterday and spoke with a few of you, but have had a bunch of different suggestions as to the best way to do this.
One particular guy was very nice and helpful and suggested that maybe a web application would be the way to go, but he wasn't well versed in hipaa compliance, so I'm going to try this again.
I will give a brief but hopefully detailed enough overview of exactly what I want to accomplish.
My business works with children on changing behaviors. We have to document a lot of information, most of it will be documented on on screen/file, called a session note. The session notes are individualized to each client we have, with some information prefilled, and some that needs to be filled as staff run their sessions. One of the individualized components of these session notes is the behavior data collected.
This data is different for each client, changes from time to time, and is collected multiple times a week. The data comes in the form of frequency data (i.e. Behavior 1 occurred 6 times), duration (behavior occurred for 3 minutes), percentage (responded correctly 35%) of the time, and some more complex forms. The exact data type isn't terribly important, because I know excel can handle all of that. I'll just need to ability to easily edit the session note sheet with new behaviors that we want to collect, or deleting behaviors from sheets.
Each client will have their own session note sheet, with their own unique information (behaviors, name, insurance and some other stuff pre-filled). And then my employees will load up the clients excel session sheet prior to a session, input information in the sheet, and fill out the data as they complete the session. At the end of the session I want them to be able to 'save' this session note. This is where the automated process needs to come in.
When they save the session note I want a few things to occur.
Save a new copy (not overwriting the existing session note) of that session note with a specific naming format (i.e. client or something like that. Take the data off of this excel session note and divvy it up into other excel sheets that already exist. The most notable example of this is the behavior data that is collected. When the sheet is saved I want that data to be sent to another excel sheet that corresponds with this clients data sheet and save all of the data row by row, with the date for the new column entry for each of those pieces of data. This new excel sheet I'm referring to (I'll call it our client data sheet) will have new entries multiple times a week, so I want it to automatically keep updating as my employees complete session sheets. I will have another excel sheet that is used basically as a timecard. So when an employee fills out a session sheet, it'll take the date/time/client information from that session sheet and send it to a timecard sheet that corresponds with their info. Having this all work online is important, as most of my staff don't have offline excel, and I want to make it as easy as possible for them. And having a nice, easy to use interface is very important, because I want an easy learning curve for my staff. Lastly, the ability for me to manage these sheets with some technical learning will be helpful, and so that I can train some of my clinical supervisors staff to do some things as well.
I'm not married to doing this any specific way, I just need it to work well and am open to suggestions.
The advantage, I would think, to a web application is that I won't have to pay subscription fees for each of my staff's account like I would through something like google sheets or office enterprise. But honestly, I am totally open to suggestions.
In order of importance I want.
  1. It works well.
  2. It is easy to use.
  3. It is customizable as we grow and expand on this project, which we will.
  4. It has a low initial cost to get built.
Whoever I hire, if things go well, I'd imagine I would have lots of additional work down the road with this project.
edit My initial budget I hired someone for this project was $200. I'm fine with increasing the budget if the quality is there. Open to negotiation. I am hesitant to pay upfront again though, as the previous person has still not refunded my money and I'm stuck dealing with the mess that is paypal.
submitted by CD_Sheep to forhire [link] [comments]

2020.11.30 02:17 Red_Icnivad TIMESTAMP rows keep adding DEFAULT CURRENT_TIMESTAMP and ON UPDATE clause. [MariaDB]

I've never run into this before, but it's driving me crazy and just corrupted a whole bunch of data that needed accurate timestamps. Basically the database has added DEFAULT CURRENT_TIMESTAMP and ON UPDATE CURRENT_TIMESTAMP to the row definition. If I update or recreate the row, it has the same properties.
See screenshot here:
I've tried updating it with phpmyadmin, as well as the raw command, and it won't go away. The table was made via script, not phpmyadmin, so I think it's something in the database. If I delete the row and re-add it, it has the same unwanted attributes.
Just figured out what it is. For anyone else coming across this, default behavior changed in MariaDB >= 10.1.8 for explicit_defaults_for_timestamp to be set to OFF. With that set off, sql will automatically add the DEFAULT and ON UPDATE commands I have. The fix is to change that setting, or to add DEFAULT NULL, which seems like a jenky workaround. More about it here:
submitted by Red_Icnivad to mysql [link] [comments]