Bigquery pivot rows to columns
Also known as Othello...
2012.01.21 22:39 trustmeimaliar Also known as Othello...
2013.01.18 07:41 kennethlaskoski Periodic Table
The Periodic Table of Elements
2023.06.10 05:11 FreshlyPeeledBananas Need help reimagining my board
| I'm currently on a mission to simplify my component-bloated game by reducing some of them. The game is about salvaging resources from the ocean through contracts using boats and divers. If you want more details and to see the early prototypes, you can check out my previous posts here: https://www.reddit.com/BoardgameDesign/comments/vfenys/road_to_my_first_prototype_its_a_salvage_scuba/ https://www.reddit.com/BoardgameDesign/comments/zptgcs/after_months_of_intense_online_prototyping_last/ One group of things I want to remove from the game are the Depth chips, Depth cards, and Exploration event cards. And that's where I need your help. I'm looking to reimagine the game board. Right now, the board is made up of nine pieces, creating a 3x3 grid. Each piece, called a region, measures 24cm x 24cm (~9.5in x ~9.5in) and is divided into smaller 3x3 sections, which are further divided into 2x2 quadrants. https://preview.redd.it/hfrvvrsxx35b1.jpg?width=742&format=pjpg&auto=webp&s=d1415b9144d3a5591bc7235585f4405937420fd3 The game starts with 2 revealed regions and when a player explores an unexplored region, they draw a Depth card and a Resource card. These cards determine the depth chips and resources to be placed on the revealed part of the board. Additionally, they draw an exploration event card, which could be a treasure report, an animal event, or nothing at all. But here's the problem: there are just too many components, and it doesn't really feel like you're exploring because you can already see the seabed, so there's no real sense of revelation. Plus, the depth chips don't match up exactly with what you see, and the resources don't match the environment either, so no real immersion either. https://preview.redd.it/v4aeoa0hx35b1.jpg?width=4285&format=pjpg&auto=webp&s=d0813852e90081ace24d8551fe21223987c98aa8 Here's an idea I had: instead of the current larger regions, we could have smaller 2x2 sections for each piece, making them measure 16x16cm (~6.3in x ~6.3in). Each piece would have two sides: one for the sea surface and the other for the seabed. We'd start with the sea surface facing up, and when a player explores, they would flip the piece to reveal the seabed with the depths shown in the illustration. It could also incorporate other elements like animal events or treasure reports into the illustrations. Plus, this reduction in size would lead to a lower table real state also (there would be one less row and column of sections overall). However, there's a practical challenge with this solution. Flipping the board pieces might be a bit tricky. Notching the pieces could be an option, but I'm not a big fan of that idea because it might disrupt the immersive feeling of the game. Do you have any suggestions on how to tackle this issue and find a simple and friendly solution? submitted by FreshlyPeeledBananas to BoardgameDesign [link] [comments] |
2023.06.10 05:10 Kyojin1919 Comfort Save
What are your comfort saves?
For me, it’s either a classic Man City save where I attempt to win everything at least five years in a row or a Brighton save where I try to get them their first major trophy.
submitted by
Kyojin1919 to
footballmanagergames [link] [comments]
2023.06.10 05:09 TheItalianMi1f lock your doors the weather is controlling you
2023.06.10 05:09 AutoModerator [Genkicourses.site] ✔️ Alex Cattoni – Posse Eye Brand Voice Challenge Program ✔️ Full Course Download
| ➡️ https://www.genkicourses.site/product/alex-cattoni-posse-eye-brand-voice-challenge-program/⬅️ Get the course here: [Genkicourses.site] ✔️ Alex Cattoni – Posse Eye Brand Voice Challenge Program ✔️ Full Course Download https://preview.redd.it/skdibup5sw4b1.jpg?width=510&format=pjpg&auto=webp&s=2311b7809340bcaf707ee6d9c87d81b576ba6587 Courses proof (screenshots for example, or 1 free sample video from the course) are available upon demand, simply Contact us here Learn How To Craft A Spellbinding Brand Voice That Helps You Stand Out, Sell Out & Effortlessly Attract Your Dream Customers – In Only 5 Days What You Get: DAY 1 6 QUESTIONS THAT EVOKE YOUR POWER VALUES Today, 89% of customers are loyal to brands that share their values and that only means one thing – it’s no longer enough to have the highest quality product or the cheapest price. If you want to stand out and rise above the noise, you’ve got to get crystal clear on who you are ( really) and what you stand for. In this session, we’ll evoke your power values and unlock your conviction codes, the magnetic coordinates that call in your dream customers. DAY 2 BECOMING THE TRUSTED SOURCE YOUR CUSTOMERS SEEK Mirror, mirror on the wall, who is the brand to rule them all? Now that you’ve identified who you are as a brand, it’s important to deeply understand who you serve. On day 2, you’ll identify your brand personality and the unique ways you reflect your values to the world. With the Mentor’s Mirror, you’ll find out how to emotionally connect with your customer’s core values, drives and desires to become the trusted source for the guidance they seek. DAY 3 HOW TO CRAFT A BRAND DNA BEYOND COMPARE On day 3 of the Challenge, I’ll help you identify your brand DNA – the stand-out positioning strategy that makes you different from any other brand out there. You’ll crystallize the most important messaging assets in any Brand Voice, unapologetically declare your mission and map out your action plan for total world domination. Take it from me, when you fight for what you believe in and fiercely serve your customers, it’s Mission Posse-ble. DAY 4 3 STEPS TO BUILDING A POWERFUL BRAND STORY Your story is the window to your brand’s soul. It’s how your customers connect to you, rally behind you and stay with you. Every great brand has a powerful story – a domino effect of defining moments, scary pivots and late night “ahas!” that led you to where you are now… and future events, yet to happen, that will continue to guide your path as you build your empire. In this session, you’ll learn how to craft a deeply relatable brand story using our proven 3-part storytelling structure. DAY 5 CONJURING A SPELLBINDING BRAND VOICE Now that you’ve identified all 4 elements of your brand strategy, it’s time to look through the Posse Eye to discover your Brand Rally Cry. On day 5, you’ll learn how to conjure a spellbinding Brand Voice and craft the unifying call that will captivate your customers and rally raving fans. You’ll walk away with your very own Brand Voice Guide and discover the practical ways you can use it to bring clarity to your messaging and ignite your mission. Bonuses: FREE BONUS #1 – FREE TEMPLATE & GUIDE THE COPY POSSE BRAND VOICE GUIDE + CUSTOMIZABLE TEMPLATE Want a behind-the-scenes look at how the Copy Posse was born? Throughout this Challenge, you’ll discover how I crystallized my brand positioning strategy, rallied over 300,000 rad humans around the world and built a lucrative 7-figure brand in under 3 years. The best part? You’ll get a never-seen-before copy of the Copy Posse Brand Voice Guide PLUS a customizable template that you can use to Possify and glossify your very own Brand Voice Guide. FREE BONUS #2 – TELL-ALL INTERVIEW WHERE ARE THEY NOW? — HOW 6 ASPIRING COPYWRITERS IGNITED THEIR BUSINESSES IN UNDER A YEAR In this Q&A interview with 6 graduates of Alex’s flagship copywriting coaching program — the Copy Posse Launch Pad — you’ll discover how these aspiring copywriters used the techniques and templates that they learned from the Copy Posse (including the branding and storytelling strategies that you’ll access in this Challenge) to quit their jobs, ignite their copywriting skills from scratch and build fun, fulfilling, and lucrative businesses in less than ONE YEAR. FREE BONUS #3 – COPY CRITIQUE COPY HOT SEAT — WATCH AS ALEX REVIEWS 3 STUDENTS’ BRAND VOICE GUIDES During this video critique, Alex shares her screen so you can look over her shoulder as she reviews and critiques 3 Challengers’ Brand Voice Guides. Watch from behind the scenes as she reveals valuable insight and copywriting tricks to help you finesse your own Brand Voice Guide, followed by answers to your most pressing questions when it comes to crafting your Rally Cry and sharing it with the world… LIMITED-TIME BONUS #1 Sales Emails & Social Media Swipe File THE CONFIDENTIAL POSSE EYE LAUNCH BLUEPRINT Want real proof that the Copy Posse branding framework freakin’ works? Get an insider copy of my complete and confidential launch blueprint for The Posse Eye Challenge. This swipe file includes ALL sales and content emails and EVERY social media post that my team and I wrote to successfully launch the live challenge for the first time, based on our own Brand Voice Guide. LIMITED-TIME BONUS #2 Masterclass BRAND SOUL WORK WITH ANITA STUBENRAUCH An ex-Apple veteran who worked her way from retail store employee to executive speechwriter, designing presentations given to Steve Jobs AND authoring Apple’s credo, Anita runs Cause:Effect Creative, a brand vision-writing agency that helps purpose-driven leaders and organizations rally hearts and minds around what fuels their soul. In this video masterclass with Anita, she’ll take you through her proprietary process and powerful questions to ask for a stellar creative brief and reveal the 5 biggest takeaways when it comes to building (and writing for) a soul-aligned brand. submitted by AutoModerator to Genkicourses_Com [link] [comments] |
2023.06.10 05:08 skquestion The Doctor Park Avenue Armory rush seating
I purchased Rush tickets from TodayTix for The Doctor, and our seats were in the rear center back, in the absolute last row, as the only person behind me was a staff who seemed to have what looked like a digital prompter tablet in front of him. I did not know what his role was. Then as the show began, he made so much noise it was unbelievable. He kept turning pages of something all throughout, then kept crinkling something which I assumed was perhaps some gadget for the show but actually when I turned around I saw it was a candy wrapper. He was constantly opening his bag, taking something out, then turning some sheets over and over. He was clearly working which was simply very noisy, and the seats directly in front of him should not be sold, even for a discounted rush price, to theatergoers who want to watch theater. At some point, I realized these seats simply were not tenable, it wasn't possible to focus on the show. Rush tickets should not be a throwaway scam. We are paying for entertainment after all. It was the most aggravating, painful 2 hours (that's how long the first act was). I walked out after the first act.
submitted by
skquestion to
Broadway [link] [comments]
2023.06.10 05:07 aeouo I always find Azul tricky to teach
I've noticed that despite having relatively simple rules, Azul is a game that I somewhat struggle to teach.
I think I find it difficult to explain because of the gameplay loop (drafting tiles, placing tiles in the pattern lines, placing them on the mosaic, tiling the wall, scoring). Everything is so tightly connected to the steps before and after that you really need to understand it all for the game to make sense. I guess I would contrast it with Dominion. In Dominion, a new player won't grasp all the action cards or strategies, but they can at least do something like, "Oh, I'll buy a smithy and it'll give me more cards in the future. That seems good!". Even if sub-optimal, they can make a plan, execute it and see benefits. In Azul, if you don't understand a step, the whole thing stops making sense, so I feel bad.
Here's what I try to do (and what people think): To begin, I'll lay out some piles with tiles as visual aids and explain that we are trying to make beautiful mosaics for the king. Then I have to choose how to present the gameplay loops. I'm brushing over gameplay details here, because I'm just giving the general gist of the problem I tend to have.
If I Go Up the Chain - Before building our mosaics, we need to get tiles from the factories (with you so far)
- On your turn, you can choose any one pile and one type of tile and take all tiles of that type from that pile. So, you could take these 3 black tiles, or these two yellow tiles (Wait, but what tiles do you want?)
- You then add them to a row next to your wall (Where should you put them?)
- When all the center tiles are gone, you take the complete rows and transfer tiles over to your wall. (Ok, but why?)
- Explain the scoring rules (Oh, that's how this works. What were all the details again?)
If I Go Down the Chain - This game is played in rounds and at the end of each round, you'll score points (with you so far)
- So, in each round you'll place tiles on your wall and you get points based on how it interacts with other tiles already on your wall (I guess. Where did those other tiles come from? Where did the new tiles come from?)
- To place a tile, you need to have a full row of that tile type in the row next to the mosaic (Ok, but where did the tiles come from? Why are some rows not full? Why are they different lengths?)
- Here's how you actually get the tiles from the factories (Oh, I see. Wait, what were all the steps again?)
What to do? I notice most guides say to start with how to score points / the objective, but in Azul that just seems particularly confusing as a starting place. It's either dive into the minutia of "If you place this tile next to these tiles, you get this many points", while everyone wonders where the hell these tiles came from, or gloss over everything with, "You'll get points based on how tiles end up in your mosaic", which leaves everyone wondering what affects the points and how the tiles end up in the mosaic.
I've mostly followed the "If I Go Up the Chain" path when explaining. While people don't tend to have the motivation for why to do certain things, they at least mostly understand the actual mechanics once I get to the end. Writing this all out, I'm thinking that maybe the best way is to go down the chain, then back up. Start by saying something like, "I find that before you make a decision in Azul, it helps to understand the consequences of those decisions. Because of that, I like to begin by explaining the end of the game first and then work backwards to the start of the game. That way, you can see what the after-effects of a decision might be. Because I'll be working backwards, it might be unclear how we get to each step as I'm covering it, but don't worry, we will cover it. Also, once I've covered everything backwards, I'll make sure to run through it again from beginning to end, so that you can see how the game plays out. But if anything is unclear or confusing, please ask questions and I'll make sure to address them"
I suppose that might help with expectation setting, so that people can focus on the incomplete information I give at each step, then I can help synthesize it all at the end.
I don't know, anybody have thoughts? Azul is often a great gateway game, so when I teach it I don't want anyone to struggle through without getting it, then feel like they didn't really have a chance to play well because they didn't understand the details.
submitted by
aeouo to
boardgames [link] [comments]
2023.06.10 05:05 389Tman389 [Fun Spot Atlanta] 9 June 2023 Trip Report
| Today I woke up at dawn to fly across the country to Atlanta and start this years road trip. Got a few warmups with the comically fast and janky Sky Trains at the Dallas and Atlanta airports before heading straight to Fun Spot Atlanta. The approach to the park is incredible, there’s nothing but trees all around until BAM a 15 million dollar RMC pops out in the distance. Parking was free today which was nice, so within 10 minutes of arriving we were already on ArieForce One (x6). The ops were incredibly slow with one train and the long list of tasks the 2 ride ops had to handle, but it didn’t matter and we marathoned the crap out of it! If anything the break was necessary so our shins didn’t get cut off from the crazy airtime. ArieForce One is definitely a front row ride in all aspects other than the first drop. The airtime, sense of speed, and inversions hit much harder with a higher quality in the front. Coming into the Raven truss dive you get ejected out of our seat, and the massive over bank lifts you up with a decent intensity as well. I was surprised at how insane the first zero g roll over the arcade was and how manageable the ending airtime hills were. To give my shins a break we went and rode the lovable E&F Miler jank that was Hurricane (x1) and Sea Serpent (x1). Hurricane had some super comfortable seats but the sharp turns were a little painful on the legs. They may be old but those E&F hurricane rides are a lot of fun. Sea Serpent was most interesting to me because they have the ride raised on some wood pallets which looks pretty strange to me. It’s incredible to me that you can marathon a coaster as good as ArieForce (until your shins can’t take it anymore) so easily. There were quite a few people at the park on a Friday night as well so all the coasters were full every time they were run. I really hope this works out for Fun Spot. I’m rooting for them. Anyways next up is a first visit to SFOG after an incredible start to the trip submitted by 389Tman389 to rollercoasters [link] [comments] |
2023.06.10 05:03 Aurora_Goreslinger HELP accidently took the sugar pills instead of regular ones
It is now 6 days after my period and I'm so fucking stupid I just realized I've been taking sugar pills those 6 days. I've had sex twice in this time span. If I take normal birth control tonight and plan B tomorrow will it work? I've missed up to 3 days in a row before of my birth control and never had problems but now I really fucked up.. when would be a good time to try a pregnancy test as well? I don't know how early they can detect.
submitted by
Aurora_Goreslinger to
birthcontrol [link] [comments]
2023.06.10 05:02 AVeryCoolGamer Rate my Prison
2023.06.10 05:02 halcyonhal Power way off for Smartrow vs s4
I have a Smartrow that I’ve hooked up to my garmin watch. The power output just doesn’t seem to make much sense… I’ll be rowing a reasonable pace and it’ll say ~140 watts.
The s4 says 220watts. In comparison to my two bikes that have power meters, I feel like it is more likely to be in the 200w range. 140 is just nothing… particularly as you push with both legs (vs one at a time on a bike).
Kinda of frustrated as Smartrow is a pain in the butt and the only reason you really bother with it, is if you really wanted accurate data.
Has anyone else been able to validate that the power output from their Smartrow is accurate?
Not exactly sure how you’d do that but thought it’s worth asking :)
submitted by
halcyonhal to
smartrow [link] [comments]
2023.06.10 05:01 AutoModerator [Genkicourses.site] [Get] ✔️ Adam Bensman – 6-Figure Income Sprint ✔️ Full Course Download
| ➡️ https://www.genkicourses.site/product/adam-bensman-6-figure-income-sprint/⬅️ Get the course here: [Genkicourses.site] [Get] ✔️ Adam Bensman – 6-Figure Income Sprint ✔️ Full Course Download *Exclusively for Copywriters With Existing Clients and 1+ Years Experience* The Copywriter’s 6-Figure Income Sprint My Proven “Turn Key” Business Model to Earn a Consistent – Per Month, Every Month, With Fewer Clients, Making a Deeper Impact, and Taking Back Your Life 📷 Are you ready to transform your freelance copywriting job into a sustainable, scalable, and wildly profitable 6-figure business in as fast as 60 days like Chris? Not only did this work for Chris, I discovered this model as I grew to per month of income in less than 24 months… While having STRICT client boundaries, NOT working weekends, NOT working evenings, and vacationing multiple times per year… AND delivered the best (record breaking) results for my clients. I’m going to show you exactly how I did it. Join me as I guide you step-by-step through an ultra-personal video-course experience to… - STOP providing strategy and consulting for free
- STOP being an order taker
- STOP selling “words on a page”
- STOP bidding projects
- STOP the never-ending cycle of prospecting for the next client
- STOP the feast-famine cycle (best month followed by worst)
- STOP letting clients control your life and walk all over you
And most importantly… - START getting paid (a lot) for strategy and consulting
- START being an advisor to clients who respect you
- START providing comprehensive strategy (first) and copywriting
- START earning – per client (even small biz’s)
- START developing deeper relationships with your clients
- START earning consistent, predictable, reliable income every single month
- START taking care of YOU, set boundaries, and build your business around your life
You’ll be guided through my easy-to-follow, 6-step process to learn the theory behind the pivots you’ll be making for your own businesses. Then we’ll shift our focus to execution. Each module has a “business assignment,” so you’ll experience wins damn-near every day you’re in there building your business. It will all come together, one puzzle piece at a time. You’re going to experience a massive transformation – both personally and professionally as you reposition and repackage your existing services into a high-ticket, retainer model business that will empower you to earn … or even PER MONTH with only a handful of clients that you actually LOVE working with. But it ain’t all about the money, honey. This is about building your LIFE first. Because burnout happens when you are trying to fit in everything that’s truly important “when there’s time.” (This is the miserable cycle of “fitting my life in around my business” — been there?) What’s important for you to have more time for? For me, it’s time with my wife, our 2 dogs, friends, mountain biking, fitness, cooking, travel, and unplugging in nature. ← All things I didn’t have time for when I was non-stop prospecting and reacting to client demands… Listen, The Copywriter’s 6-Figure Income Sprint is no-fluff, jam-packed with value, and has literally everything you need to implement this “turn key” business plan and create your new lifestyle business earning serious money in as fast as 60 days if you apply these steps as you learn. 📷 Courses proof (screenshots for example, or 1 free sample video from the course) are available upon demand, simply Contact us here submitted by AutoModerator to Genkicourses_Com [link] [comments] |
2023.06.10 05:00 japanpole SANFL Match Thread: Baby Crows vs. Woodville West Rowey's
Since Reddit is going to end soon, I might as well go rogue and start SANFL match threads.
Watch us play 2 Eagles teams in a row
submitted by
japanpole to
adelaidefc [link] [comments]
2023.06.10 05:00 Rosa_Colored_Glasses Camelot shake up halfway through!
| Andrew Dunlap out at intermission, Fergie Philippe in as Arthur! Not quite sure why, but so many props to Fergie - to completely pivot from Sir Sagramore to King Arthur, absolutely stunning and marvelous. submitted by Rosa_Colored_Glasses to Broadway [link] [comments] |
2023.06.10 04:59 Mustella_ Progression Sheet Savior Updated
Since the
SuckHard's calculator is
updated for Savior and
Haste's spreadsheet hasn't been updated for a while, I came up with a new version (with
u/Haste-'s approval, ofc).
---
Maplestory Reboot Progression Sheet [Savior Updated] ---
Besides the usual
'Average' costs that Haste created, I also added a
'75th percentile' column for more risk-averse people.
Quick guide on how to use it:
- make a copy of the spreadsheet;
- fulfill the bold numbers in column J;
- check boxes for what you already achieved;
- sort it using column G (averages) or H (75th %iles);
- the bigger the number, the more cost-efficient will be the upgrade.
Let me know if there's any wrong data; I'm also open to suggestions for next updates.
submitted by
Mustella_ to
Maplestory [link] [comments]
2023.06.10 04:59 Working_Page_2833 Selling Laufey Tix (ONE)
Hi guys,
I'm selling one of my tickets to Laufey for Los Angeles November 18th! I am seated at Row M Seat 39! If you look up an image it's kinda fire let's be honest. I'm only selling because I got a ticket for a more preferred date. I'm not a scammer plssssss I'm also gullible so please don't scam me I BEG. Selling for $210 but we can chat and figure out what works best for you.
submitted by
Working_Page_2833 to
laufeymusic [link] [comments]
2023.06.10 04:57 djsjjskssks how can i make this circle into a square
| how can i make the next rows of this project turn the circle shape into a square so that i can add it to a blanket? like how can i go about making the corners for this? any advice will help:) submitted by djsjjskssks to crochet [link] [comments] |
2023.06.10 04:56 butdoiknowiknow I was prescribed 0.5mg clonazepam, what routine should I follow to prevent intolerance/addiction?
I’m thinking it definitely shouldn’t be taken everyday.
How about alternative days? Or maximum 3x a week? Max 3 days in a row? Anyone know before I end up reaching that stage myself? 😂
I started taking pristiq everyday last week but I’m thinking of taking clonazepam to bide my anxiety until the pristiq starts working in a few weeks. I feel like pristiq is making me more anxious, but I’ll have to stay on till I reach its effective results in a few weeks.
submitted by
butdoiknowiknow to
Anxiety [link] [comments]
2023.06.10 04:54 _The_Librarian I've been playing with prompts and stuff and a post earlier had me playing around with vectorization. I'm not great a coding but here's what I have!
Yes it's thrown together pretty messily. I was playing with the concept of dual-sided prompting using the "role" part of gpt3.5turbo. Which is why it's just a simple SQL table instead of anything actually good.
The vectors are pretty simple at the moment but I just thought I'd throw this out there for people who are smarter than me that can take it further. Eventually I want to be able to search through the vectors via time.
import datetime import pickle import openai import sqlite3 import os from openai import OpenAIError from sklearn.feature_extraction.text import TfidfVectorizer import config from config import ( API_FILE, CONVERSATION_OUTPUT_FILE, REMOVE_OUTPUT_STRINGS_FILE, USER_NAME, BOT_NAME, DATABASE_NAME, delete_table_on_exit, MAX_TOKENS, TEMPERATURE, TOP_P, PRESENCE_PENALTY, FREQUENCY_PENALTY, BEST_OF, STOP_SEQUENCES, ) DESCRIPTION_TEXT, DIRECTIVE_TEXT = config.load_all_files() def authenticate_openai(): try: with open(API_FILE, "r") as file: openai.api_key = file.read().strip() except: print("Failed to authenticate with OpenAI API. Please check your credentials and try again.") exit() def create_tables(): with sqlite3.connect(f"{DATABASE_NAME}.db") as conn: cursor = conn.cursor() cursor.execute(""" CREATE TABLE IF NOT EXISTS conversation_history ( id INTEGER PRIMARY KEY, user_prompt TEXT, chatbot_response TEXT, vector BLOB, timestamp TEXT ) """) conn.commit() return conn vectorizer = TfidfVectorizer() def generate_vector(user_prompt, chatbot_response): # combine the user and chatbot responses into one "document" document = user_prompt + " " + chatbot_response # fit_transform expects a list of documents, and we only have one, # so we wrap our single document in a list vectors = vectorizer.fit_transform([document]) # fit_transform returns a sparse matrix, but we need to store our vector # in the database as a simple list, so we convert the matrix to an array # and then convert the array to a list dense_vector = vectors.toarray() vector = dense_vector.tolist() return vector def build_messages(conversation_history, DESCRIPTION_TEXT, DIRECTIVE_TEXT): messages = [{"role": "system", "content": DESCRIPTION_TEXT, "name": BOT_NAME}] for exchange in conversation_history: messages.append({"role": "user", "content": exchange[USER_NAME], "name": USER_NAME}) if exchange[BOT_NAME]: messages.append({"role": "assistant", "content": exchange[BOT_NAME], "name": BOT_NAME}) messages.append({"role": "system", "content": DIRECTIVE_TEXT, "name": BOT_NAME}) return messages def generate_response(conversation_history, max_tokens=MAX_TOKENS): try: messages = build_messages(conversation_history, DESCRIPTION_TEXT, DIRECTIVE_TEXT) # print("Generated messages:", messages) response = openai.ChatCompletion.create( model="gpt-3.5-turbo", messages=messages, max_tokens=MAX_TOKENS, n=BEST_OF, temperature=TEMPERATURE, top_p=TOP_P, frequency_penalty=FREQUENCY_PENALTY, presence_penalty=PRESENCE_PENALTY, stop=STOP_SEQUENCES if STOP_SEQUENCES else None, ) generated_text = response.choices[0].message['content'].strip() # print("Generated text:", generated_text) if not generated_text: raise Exception("ChatGPT failed to generate a response.") return generated_text except OpenAIError as e: delete_last_row(conn) print(f"Error: {str(e)}") raise Exception("ChatGPT failed to generate a response.") def clean_response_text(text): text = ' '.join(text.split()) text = '\n'.join(line.strip() for line in text.splitlines() if line.strip()) return text def insert_conversation(conn, user_prompt, chatbot_response, vector): timestamp = datetime.datetime.now().isoformat() # get the current time in ISO 8601 format with conn: cursor = conn.cursor() # convert the vector to a binary string using pickle vector_blob = pickle.dumps(vector) cursor.execute("INSERT INTO conversation_history (user_prompt, chatbot_response, vector, timestamp) VALUES (?, ?, ?, ?)", (user_prompt, chatbot_response, vector_blob, timestamp)) conn.commit() def get_conversation_history(cursor, max_tokens=4096): rows = [] token_count = 0 for row in cursor.execute("SELECT id, user_prompt, chatbot_response FROM conversation_history ORDER BY id DESC"): user_prompt_len = len(row[1]) if row[1] is not None else 0 chatbot_response_len = len(row[2]) if row[2] is not None else 0 row_token_count = user_prompt_len + chatbot_response_len if token_count + row_token_count < max_tokens: token_count += row_token_count rows.append(row) else: break rows.reverse() conversations = [{"id": row[0], USER_NAME: row[1], BOT_NAME: row[2]} for row in rows] return conversations def sort_conversations(conversations): sorted_conversations = sorted(conversations, key=lambda x: x['id'], reverse=False) return sorted_conversations def delete_last_row(conn): cursor = conn.cursor() cursor.execute("DELETE FROM conversation_history WHERE id = (SELECT MAX(id) FROM conversation_history)") conn.commit() def print_conversation_history(cursor): conversation_history = get_conversation_history(cursor) for exchange in conversation_history: if exchange[USER_NAME]: print(f"\n{USER_NAME}: {exchange[USER_NAME]}") if exchange[BOT_NAME]: print(f"\n{BOT_NAME}: {exchange[BOT_NAME]}") return conversation_history def write_conversation_to_file(text): now = datetime.datetime.now() timestamp = now.strftime("%Y-%m-%d %H:%M:%S") with open(CONVERSATION_OUTPUT_FILE, 'a', encoding='utf-8') as f: f.write(f"---START---{timestamp}---\n{text}\n---END---\n") def close_connection(conn): conn.close() conn = sqlite3.connect(f"{DATABASE_NAME}.db") create_tables() def main_loop(): cursor = conn.cursor() while True: user_input = input(f"\n{USER_NAME}: ") if user_input.lower() == "exit": break if user_input.lower() == "delete memory": delete_last_row(conn) print("Deleted memory.") continue # initially insert the user_prompt with placeholder chatbot_response and vector insert_conversation(conn, user_input, None, None) conversation_history = get_conversation_history(cursor, max_tokens=4096 - MAX_TOKENS) try: output = generate_response(conversation_history) clean_response = clean_response_text(output) print(f"\n{BOT_NAME}: {clean_response}") vector = generate_vector(user_input, clean_response) # update the placeholder chatbot_response and vector in the last inserted row vector_blob = pickle.dumps(vector) cursor.execute("UPDATE conversation_history SET chatbot_response = ?, vector = ? WHERE id = (SELECT MAX(id) FROM conversation_history)", (clean_response, vector_blob)) conn.commit() write_conversation_to_file(user_input) write_conversation_to_file(clean_response) except Exception as e: print(e) continue if delete_table_on_exit: cursor.execute("DROP TABLE conversation_history") conn.commit() # Close the database connection conn.close() if __name__ == "__main__": authenticate_openai() main_loop()
Here's the config.py that goes with it:
# folders and files API_FILE = "openai_api_key.txt" CONVERSATION_OUTPUT_FILE = "conversationlog.txt" REMOVE_OUTPUT_STRINGS_FILE = "removeoutputstrings.txt" # names USER_NAME = "User" BOT_NAME = "CDB" DATABASE_NAME = f"{BOT_NAME}" # bools delete_table_on_exit = False # gpt config MAX_TOKENS = 1024 TEMPERATURE = 0.5 TOP_P = 1.0 PRESENCE_PENALTY = 1.1 FREQUENCY_PENALTY = 1 BEST_OF = 1 STOP_SEQUENCES = None # file loader DESCRIPTION_NAME = "Contrarian" DIRECTIVE_NAME = "ContrarianDi" DESCRIPTION_FOLDER = "descriptions" DIRECTIVE_FOLDER = "directives" DESCRIPTION_FILE_NAME = DESCRIPTION_NAME + ".txt" DIRECTIVE_FILE_NAME = DIRECTIVE_NAME + ".txt" def get_file_path(folder, file_name): return f"{folder}/{file_name}" def load_file(file): with open(file, 'r', encoding='utf8') as f: text = f.read() return text def load_all_files(): DESCRIPTION_TEXT = load_file(get_file_path(DESCRIPTION_FOLDER, DESCRIPTION_FILE_NAME)) DIRECTIVE_TEXT = load_file(get_file_path(DIRECTIVE_FOLDER, DIRECTIVE_FILE_NAME)) return DESCRIPTION_TEXT, DIRECTIVE_TEXT
submitted by
_The_Librarian to
LocalLLaMA [link] [comments]
2023.06.10 04:53 katnerys-targaryen Roommates with Benefits Chapter Eleven Preview
submitted by katnerys-targaryen to Choices [link] [comments]
2023.06.10 04:51 docXfamas [H] June Choice and other bundled games [W] Paypal, TF2 keys
Note:
- All keys are primarily from US/NA region
- My list maybe slightly outdated so I apologize in advance if some of the games mentioned are already traded/Sold.
- I accept XBOX keys as well.
- I accept PayPal only via goods and services so all transactions will include fees.
- My Wishlist, I am mostly uninterested in other games.
HAVE
JUNE 2023 games - Curse of the Dead Gods
- Ghostwire: Tokyo
- Remnant: From the Ashes - Complete Edition
- Eternal Threads
- GRIME
- Honey, I Joined a Cult
- Meeple Station
- Turbo Golf Racing
MAY MADNESS MULTIPLAYER - Generation Zero® x 2
- Midnight Ghost Hunt x 2
- Northgard x 2
- Borderlands 3: Super Deluxe Edition x 2
- Destiny 2: Beyond Light
- Gloria Victis x 2
- PULSAR: Lost Colony x 2
MAY 2023 games - Behind the Frame: The Finest Scenery x 2
- Bendy and the Dark Revival x 3
- Builder Simulator x 2
- Operation Tango x 2
- Spiritfarer®: Farewell Edition x 2
- The Invisible Hand x 2
- Warhammer 40,000: Chaos Gate - Daemonhunters x 4
- Windjammers 2 x 3
APRIL 2023 games - Aliens: Fireteam Elite x 5
- DEATH STRANDING DIRECTOR'S CUT x 4
- Founders' Fortune x 1
- Life is Strange 2 Complete Season (incl. Mascot Bundle DLC) x 5
- Monster Prom 2: Monster Camp x 2
- Revita x 2
- Rollerdrome NA region x 4
- The Life and Suffering of Sir Brante x 2
MARCH 2023 games - BIOMUTANT x 2
- Demon Turf x 2
- Edge Of Eternity x 3
- Golden Light x 3
- Hero's Hour (NA Region) x 4
- Jurassic World Evolution 2 x 2
- Monster Crown x 3
- Rogue Lords x 3
Safe in Our World Charity Bundle 2023 - A Little Golf Journey x 2
- Arcade Paradise - Arcade Paradise EP x 2
- Chivalry: Medieval Warfare x 2
- Eternal Threads x 2
- Field of Glory II x 2
- Hue x 2
- Ice Age: Scrat's Nutty Adventure
- Indivisible x 2
- Murder by Numbers
- Perfect x 2
- PlateUp!
- Rescue Party: Live! x 2
- Rise of the Slime x 2
- Songbringer
- Soul Axiom Rebooted x 2
- Spiritfarer®: Farewell Edition x 2
- Steel Rats x 2
- STONE x 2
- Strange Brigade x 2
- Teacup
- The Last Campfire x 2
- Turbo Golf Racing x 2
- Warhammer 40,000: Gladius - Relics of War x 2
- White Day: A Labyrinth Named School x 2
- Sifu Deluxe Edition Upgrade Bundle x 2
FEBRUARY 2023 games - Fallout + Fallout 76
- Five Dates x 2
- Fobia - St. Dinfna Hotel x 3
- Othercide
- Pathfinder: Wrath of the Righteous - Enhanced Edition x 2
- ScourgeBringer x 2
- Shady Part of Me x 2
Survival Instinct Bundle - SCUM x 2
- Starsand x 2
- State of Decay 2 x 2
- SurrounDead x 2
- The Long Dark: Survival Edition x 2
- Volcanoids
JANUARY 2023 games DECEMBER 2022 Monthly Bundle Leftovers - Greedfall
- Wasteland 3
- Blade Assault
- Super Magbot
- TOEM
- Where the Water Tastes Like Wine
Black Friday VR Voyager's Pack - A Fisherman's Tale
- Car Mechanic Simulator VR
- Cook-Out
- I Expect You To Die
- Sairento VR
- Shooty Fruity
- SUPERHOT VR
- The Curious Tale of the Stolen Pets
- The Wizards - Dark Times
- Until You Fall
OTHER KEYS - Agatha Christie - Hercule Poirot: The First Cases
- The Smurfs - Mission Vileaf
- Anna's Quest
- AtmaSphere
- BATTLETECH
- Cardaclysm
- Dead Age 2: The Zombie Survival RPG
- Derange
- DISTRAINT 2 x 2
- Driftland: The Magic Revival
- Enclave (Gold)
- Everreach: Project Eden
- Fantasy Blacksmith
- Golf Club Wasteland
- Heal
- INDUSTRIA
- Interplanetary: Enhanced Edition
- Jack Orlando: Director's Cut
- Journey of a Roach
- Last Inua
- LEAVES - The Journey
- LEGO Batman 3: Beyond Gotham
- LEGO Marvel Super Heroes
- LEGO® MARVEL's Avengers
- LEGO® The Hobbit™
- Main Assembly
- Majesty 2 Collection
- My Big Sister
- Noosphere
- OUTBUDDIES DX
- Paw Paw Paw
- Pesterquest
- Plants vs. Zombies: Battle for Neighborville (ORIGIN KEY)
- PUBG: Battlegrounds – Golden G-Coin Box
- Red Wings: Aces of the Sky
- Seed Hunter x 2
- Ship Simulator Extremes
- Shooting Stars!
- Smart Factory Tycoon
- Space Cows
- Stars End
- Stubbs the Zombie in Rebel Without a Pulse
- The Deed II
- The LEGO Movie - Videogame
- The LEGO NINJAGO Movie Video Game
- The Textorcist: The Story of Ray Bibbia
- The Town of Light
- Truck Racer
- Warhammer 40,000: Mechanicus
- Wildfire
- Worms Clan Wars
- Zanzarah: The Hidden Portal
- The House of Da Vinci (ROW)
NOVEMBER 2022 Monthly Bundle Leftovers - Kingdoms of Amalur: Re-Reckoning FATE Edition
- Raji: An Ancient Epic
- Shadow Tactics: Blades of the Shogun - Aiko's Choice
- UnMetal
- Roboquest x 2
- Morbid: The Seven Acolytes
- Eldest Souls
2K MEGAHITS BUNDLE - Hidden & Dangerous 2: Courage Under Fire x 3
- Hidden & Dangerous: Action Pack x 3
- X-COM: Complete Pack x 3
- CivCity: Rome x 3
- Duke Nukem Forever collection x 4
- Railroad Tycoon 2: Platinum x 3
- Railroad Tycoon 3 x 3
- Sid Meier's Railroads! x 3
- The Golf Club 2019 Featuring PGA TOUR x 3
- WWE 2K BATTLEGROUNDS + Ultimate Brawlers Pass x 4
- BioShock: The Collection (EU region) x 2
- BioShock: The Collection (NA region) x 2
- Borderlands 3: Super Deluxe Edition
- PGA Tour 2K21 x 3
- Sid Meier's Civilization VI x 2
- XCOM: ULTIMATE COLLECTION x 4
LIST OF ALL HB LEFTOVERS - - 11-11 Memories Retold x 2
- 112 operator
- 198x
- 8 doors
- 911 Operator x 2
- A Case Of Distrust
- A plague tale: innocence x 2
- Aegis Defenders x 3
- Ageless x 3
- Agents Of Mayhem
- Alien Spidy
- American Fugitive x 2
- Amnesia: rebirth x 3
- Amnesia: The Dark Descent + Amnesia: A Machine for pigs
- Anna's Quest
- As Far As The Eye
- Ashampoo Photo Optimizer 7
- Automachef x 3
- Bartlow's Dread Machine
- Beholder 2
- Between the stars x 4
- Beyond the wire x 2
- Bionic Commando x 2
- Bloodstained: Ritual of the Night
- Book of Demons x 3
- Boomerang Fu
- Boreal Blade x 3
- Boundless
- Broken Age x 2
- Brothers: A Tale of Two Sons
- Butcher
- Capitalism 2
- Car Mechanic Simulator 2018
- Carnival Games VR
- Civilization III x 2
- Cook, Serve, Delicious! 3
- Crazy Machines 3
- CROSSBOW: Bloodnight x 2
- Crown Trick
- Cursed Castilla (Maldita Castilla Ex)
- Cyber Hook x 2
- Dagon: by H. P. Lovecraft - The Eldritch Box DLC x 2
- Dangerous Worlds x 2
- Dark Future: Blood Red States
- Darksburg x 2
- Dead In Vinland x 2
- Dear Esther: Landmark Edition
- Deathloop x 3
- Deleveled x 2
- Desert Child
- Desolate x 2
- Desperado 3
- DiRT Rally 2.0 - H2 RWD Double Pack
- DiRT Rally 2.0 - Opel Manta 400
- Dirt Rally 2.0 - Porsche 911 RGT Rally Spec
- Disjunction - gog
- Dragon's Dogma: Dark Arisen x 3
- Drake Hollow x 2
- Draw Slasher x 2
- Drawful 2
- Drawful 2
- Driftland: The Magic Revival x 3
- Ducati - 90th Anniversary
- Due Process x 3
- EarthX
- Ember
- Encodya - GOG x 2
- Endless Space 2 x 2
- Endzone - A World apart
- Enslaved™: Odyssey To The West™ Premium Edition
- Evergarden x 2
- Evoland Legendary Edition x 2
- Expeditions: Viking
- Fable Anniversary
- Family Man x 3
- Farmer's dynasty x 2
- Fear Effect Sedna
- Field of Glory: Empires
- Fling to the Finish
- Forager
- Frog Detective 2: The Case Of The Invisible Wizard x 3
- Fun With Ragdolls: The Game x 2
- Fury Unleashed x 5
- GameGuru x 2
- GameMaker Studio 2 Creator 12 Months x 2
- Garage: bad trip
- Gas Station Simulator x 2
- Gauntlet
- Genesis Alpha One Deluxe Edition x 3
- Ghost Of A Tale
- Gnog
- Go Home Dinosaurs x 2
- Graveyard Keeper
- Greak: Memories Of Azur
- GRIP: Combat Racing Artifex DLC x 3
- Guts and glory
- Hellpoint x 2
- Hexologic
- Hiveswap friendsim x 2
- Hiveswap: Act 1
- Hot Wheels Unleashed x 2
- Hotshot Racing x 3
- Ikenfell x 2
- Immortal Planet
- Imperator: Rome Deluxe Edition x 2
- In sound mind x 2
- Indivisible x 3
- Inmost
- Iris And The Giant
- Iron Danger
- Jurassic World Evolution x 2
- Katana zero
- Kerbal Space Program
- Kingdom Two Crowns
- Kingdom: New Lands x 2
- Kyle is Famous: Complete Edition
- Lacuna - A Sci-fi Noir Adventure
- Lawn mowing simulator
- Levelhead x 2
- Liberated GOG x 2
- Lostwinds
- Lovecraft's Untold Stories x 3
- Lust for Darkness x 2
- Lust from Beyond: M Edition x 2
- Maneater
- Memoria + Soundtrack
- Metro Exodus
- Midnight protocol x 2
- Milky Way Prince - The Vampire Star x 2
- Mo:astray
- Monaco
- Monster Hunter: World
- Moon Hunters
- Mordhau
- Morkredd x 3
- Motorcycle Mechanic Simulator 2021
- Moving Out
- Music Maker EDM Edition x 2
- Nebuchadnezzar
- Necromunda: Hired Gun
- NecroWorm x 2
- Neoverse x 3
- Neverout x 2
- Nex Machina
- Nickelodeon all-star brawl
- Nickelodeon Brawl
- Niffelheim x 2
- Nowhere Prophet x 3
- Orbital Racer x 2
- Out of Reach: Treasure Royale x 2
- Out Of Space
- Outward + The Soroboreans And Outward Soundtrack x 3
- Partisans 1941 x 2
- Path Of Giants
- Pathfinder Second Edition Core Rulebook and Starfinder Core Rulebook x 2
- Pathfinder: Kingmaker Enhanced Plus Edition
- Pathfinder: Kingmaker - Royal Ascension
- Pathfinder: Kingmaker - Wild Cards
- Pathway
- Paw paw paw x 3
- PC Building Simulator x 2
- Peaky Blinders: Mastermind x 2
- Pesterquest x 3
- Phantom Doctrine x 2
- Pikuniku
- Pine
- Pixplode x 2
- Police stories
- Popup Dungeon
- Post Void
- Prison Architect + Aficionado (Dlc)
- Pumpkin Jack x 2
- Purrfect Date
- Quantum Break x 2
- RAD x 4
- Railway Empire
- Red solstice 2: survivors
- Relicta x 3
- Remnants of Naezith
- Remothered: Broken Porcelain x 2
- Resident Evil 4 (2005)
- Resident Evil 5 Gold Edition
- Resident Evil HD REMASTER x 3
- Resident Evil Revelations x 4
- Resident Evil Revelations 2 - Episode 1: Penal Colony x 3
- Retimed x 3
- Ring of pain x 4
- Rise Of Industry x 3
- Roarr! Jurassic Edition x 2
- Rover Mechanic Simulator x 3
- RPG Maker VX
- Rustler x 4
- Saturday Morning RPG
- Say No! More
- Shing! x 2
- Shining Resonance Refrain x 2
- Shoppe Keep 2
- Simple Rockets 2
- Simplerockets 2 x 2
- Simulacra + Simulacra 2
- Size Matters x 3
- Skullgirls 2nd Encore
- Slinger VR x 2
- Sniper Ghost Warrior Contracts x 2
- Soulblight x 2
- Spec Ops: The Line
- Speed Brawl x 2
- Splasher
- Starbound
- Stealth 2: A Game Of Clones
- Still There x 3
- Stories Untold
- Street Fighter V x 2
- Strider x 2
- Struggling x 2
- Stubbs The Zombie In Rebel Without A Pulse
- Super Meat Boy x 2
- Supraland x 2
- SYSTEM SHOCK: ENHANCED EDITION x 2
- Tabletop Playground x 3
- Telefrag VR x 2
- The Amazing American Circus x 2
- The Ambassador: Fractured Timelines
- The Ascent x 2
- The Bard's Tale IV: Director's Cut x 3
- The Beast Inside x 3
- The Coma 2: Vicious Sisters x 2
- The Darkness II x 2
- The Haunted Island, A Frog Detective Game x 3
- The Henry Stickmin Collection x 2
- The Shapeshifting Detective
- The Survivalists
- The Swords Of Ditto: Mormo's Curse x 2
- The Textorcist: The story of Ray Bibbia x 2
- The USB Stick Found in the Grass x 2
- The Walking Dead: Saints & Sinners x 2
- The Wild Eight
- Them's Fightin' Herds
- Throne Of Lies® The Online Game Of Deceit
- Through The Darkest Of Times x 3
- Tilt Brush x 2
- Timelie
- Toejam & Earl: Back in the Groove x 2
- Tohu x 3
- Tools up x 2
- Tooth and Tail
- Total Tank Simulator x 2
- Townsmen - A Kingdom Rebuilt x 2
- Toybox Turbos
- Train Station Renovation x 2
- Treasure Hunter Simulator x 2
- Trine 4: The Nightmare Prince x 2
- Tropico 4
- Truberbrook / Trüberbrook
- Tumblestone
- Tyranny: Deluxe Edition x 2
- Undungeon
- Vagante
- VALKYRIA CHRONICLES 4 COMPLETE EDITION
- Vampire: The Masquerade - Shadows Of New York x 3
- Vane x 3
- Vikings - Wolves of Midgard
- Voidigo
- Wanderlust: Travel Stories x 2
- Wandersong x 2
- Wargroove x 2
- Warhammer: Chaosbane x 2
- WARSAW x 5
- We Are Alright x 2
- Werewolf: The Apocalypse Heart Of The Forest x 3
- Wildfire
- Worms rumble + legends pack dlc x 3
- Wrath: Aeon Of Ruin
- WWE 2k Battlegrounds
- X-morph Defense x 3
- X-Morph: Defense + European Assault, Survival of the Fittest, and Last Bastion DLC x 2
- Xcom® 2: Resistance Warrior Pack
- Yoku's Island Express
- Zombotron
LIST OF ALL FANATICAL LEFTOVERS - - Leisure Suit Larry - Wet Dreams Don't Dry
- Leisure Suit Larry - Wet Dreams Dry Twice
- Aragami
- Unto The End
- Anuchard
- Call of Juarez Gunslinger
- Darkwood
- Interstellar Space: Genesis
- Unexplored 2: The Wayfarer's Legacy
- 198X
- A.I.M. Clan Wars
- Alekhine's Gun
- Alwa's Awakening
- American Fugitive
- Ballpoint Universe - Infinite
- Battlestar Galactica Deadlock
- Blasphemous
- Bunker Punks
- Clustertruck
- Clutch
- Cobra Kai: The Karate Kid Saga Continues
- Convoy
- Cook, Serve, Delicious! 3?!
- Cosmic Star Heroine
- Crash Drive 3
- Danger Scavenger
- Degrees of Separation
- Demon Pit
- Detective Di: The Silk Rose Murders
- DiRT Rally
- Do Not Feed the Monkeys
- Dracula: Love Kills
- Driftland: The Magic Revival
- Eador. Imperium
- El Matador
- Eternity: The Last Unicorn
- Fantasy Versus
- FAR: Lone Sails x 2
- Fictorum
- Four Sided Fantasy
- Fun with Ragdolls: The Game
- Garfield Kart - Furious Racing
- GemCraft - Chasing Shadows
- Gift of Parthax
- Grand Mountain Adventure
- GRID Autosport - Premium Garage Pack DLC
- GRID Autosport - Road & Track Car Pack DLC
- Guts and Glory
- Heavy Burger
- Horizon Chase Turbo x 2
- Hyperdrive Massacre
- Iratus: Lord of the Dead
- JumpJet Rex
- King's Bounty: Warriors of the North
- Kings of Kung Fu
- Liberated
- Lichdom: Battlemage
- Magrunner: Dark Pulse
- Making History: The Calm and the Storm Gold Edition
- Mech Mechanic Simulator
- Men of War
- Monster Slayers
- Monster Slayers - Advanced Classes Unlocker
- Monster Slayers - Fire & Steel Expansion
- Morbid: The Seven Acolytes
- My Time At Portia
- Mytheon
- NecroVisioN: Lost Company
- Neversong
- Nongunz: Doppelganger Edition
- Overlord: Ultimate Evil Collection
- Planet Alcatraz
- PlataGO!
- Rage in Peace
- Re-Legion
- Rebel Galaxy Outlaw
- Redeemer: Enhanced Edition x 2
- Reventure
- RollerCoaster Tycoon Classic
- Save Room - Organization Puzzle
- Shadowhand: RPG Card Game
- Shark Attack Deathmatch 2
- Silver Chains
- Sin Slayers
- Slain: Back from Hell
- Songbird Symphony
- Space Hulk Ascension
- SPACECOM
- Sparklite
- Star Wolves
- Star Wolves 3: Civil War
- Sunblaze
- Super Panda Adventures
- Super Trench Attack!
- Supreme Ruler 1936
- Supreme Ruler: Cold War
- Tacoma
- Tannenberg
- Tesla vs Lovecraft
- The Long Reach
- The Surge
- The Uncertain - The Last Quiet Day
- The Vagrant
- This Strange Realm Of Mine
- This War of Mine: Stories - Season Pass DLC
- Torchlight
- Toybox Turbos
- Unexplored
- UNLOVED
- V-Rally 4
- Verdun
- Warhammer 40,000: Sanctus Reach
- Wayward Souls
- Wick
- Wick
- World's Dawn x 2
- Yet Another Zombie Defense HD x 2
- Yooka-Laylee and the Impossible Lair
AS OTHER KEYS (UNSURE IF UNUSED SO I WILL GO FIRST) - 10 Second Ninja X
- A story about my uncle
- AGELESS
- Automobilista
- Before We leave
- Caveman World: Mountains of Unga Boonga
- Charlie's Adventure
- Cultures - 8th Wonder of the world
- Dead Age
- DUCATI - 90th Anniversary
- Dust to the End
- Earth 2140
- Fated Souls 3
- Figement
- HELLDIVERS™ Dive Harder Edition
- HELLDIVERS™ Dive Harder Edition
- Ikenfell
- Iron Sky Invasion
- Jorney of a roach
- Lawn Mowing Simulator
- Munin
- My Big Sister
- Narita Boy
- Nigate Tale
- Nigate Tale
- Nordlicht
- Nuclear DAWN
- Of Orcs and Men
- Oh My Gore
- Oh My Gore!
- Pitiri 1977
- Remnants of Naezith
- Scheming Through The Zombie Apocalypse: The Beginning
- Scheming Through The Zombie Apocalypse: The Beginning
- Ship simulator extreme
- Snake Pass
- Sorry, James
- The Deed Dynasty
- Tohu
- Tools Up!
- Toy tinker Simulator
- Treasure Hunter Simulator
- Vagrant Hearts 2
- Whispering Willows
- Windscape
- A Sceptic's Guide to Magic
- Age of Wonders III
- Amnesia Collection x 2
- Assassin's Creed® Chronicles China UPLAY key
- Canyon Capers
- CAPITALISM 2
- CHESS ULTRA
- Chicken Assassin Reloaded
- Deponia: The Complete Journey x 2
- Dirt Rally x 2
- ELIZA
- Enclave (Gold)
- ETHERBORN
- F1 2017 1988 McLAREN MP4/4 Classic Car DLC
- Garfield Kart
- Gold Rush! Classic
- Gothic 3
- Headsnatchers x 2
- Heli Heroes
- Homefront
- Introvert Quest
- Kingdom: Classic
- Knights and Merchants
- Layers of Fear + Soundtrack
- LEGO® The Hobbit™
- Majesty 2 Collection
- Manual Samuel
- Medieval Kingdom Wars
- Mystery Castle: The Mirror's Secret
- Oh My Gore!
- PAC-MAN 256
- Pixel Puzzles: UndeadZ
- Port Royale 3
- Rig n Roll
- RIOT - Civil Unrest
- Satellite Reign
- Shooting Stars
- THE HEX
- The Red Solstice x 2
- THEM'S FIGHTIN' HERDS
WANT
PayPal
MY REP Wishlist Gems
TF2 keys/ Csgo Cases
submitted by
docXfamas to
SteamGameSwap [link] [comments]
2023.06.10 04:44 TheAviotorDemNutzz Since we talk a lot about rates, here is an informative take on why rates will likely hit 5.25%
I think people will need to prepare of rates to hit 5.25%. I don't want to mince words, the BoC will likely hike at least one more time, but likely twice more, because it would be extremely unusual for them to go into a pause, hike, and then pause again, also taking into consideration they said yesterday:
Bank of Canada deputy governor Paul Beaudry says recent economic data suggests the risk of sticky inflation has gone up, prompting the central bank’s decision to raise interest rates on Wednesday. Beaudry said economic data released since April “tipped the balance” for the central bank. “We've had an accumulation of evidence – on many fronts, over time and across a whole set – that tell us that inflation seems to be more sticky and it's going to be harder to get it down to that 2 per cent," Beaudry said. Beaudry says the rapid rise in consumer spending took the central bank by surprise, while buyers appear to be returning to the housing market. “When we looked at the dynamics in inflation combined with excess demand, that really has increased the risk that we are not going to be able to get inflation down without a bit more monetary tightening,” Beaudry said
https://www.bnnbloomberg.ca/rate-hike-prompted-by-higher-risk-of-sticky-inflation-boc-s-beaudry-1.1930724 If they are thinking core inflation is getting sticky then there is is a good chance there could be 2 more hikes in store. It is also very important to note even if a recession starts they might not be able to cut rates, it's important to look at history and see what happened the last time we had this level of inflation. From the WSJ:
Were the Fed to ease because of growth fears before inflation has been vanquished, it would risk repeating its stop-and-go tightening of the 1970s, which economists now see as a costly policy error. To avoid that mistake, “the Fed may not be able to pivot and cut rates quickly or at all” if a recession begins later this year, said Krishna Guha, vice chairman of Evercore ISI, in a recent report.
“Stop-and-go” refers to how the Fed oscillated between raising rates to tame inflation and then backing off to shore up growth—succeeding at neither. It began in the late 1960s, when Chairman William McChesney Martin Jr. paused rate rises during a recession scare. It worsened under Fed Chairman Arthur Burns, who raised rates significantly between 1972 and 1974 but cut them the following year in the midst of a sharp recession. Inflation fell but settled at still-elevated levels.
“The problem in the 1970s was you tightened. You hit the labor market. And you eased up, and you never took care of the problem,” said Peter Hooper, global head of economic research at Deutsche Bank. Ultimately, it took a change in tactics by the Fed in 1981 under Chairman Paul Volcker to raise rates to far higher levels for inflation to come down and stay down.
Mr. Hooper, who began his career at the Fed in 1973, thinks Mr. Powell won’t repeat those mistakes because the central bank has exhaustively studied them.
https://www.wsj.com/articles/for-the-fed-easing-too-soon-risks-repeat-of-stop-and-go-1970s-11657454403 So I would make arrangements for what you need to do with rates at 5.25% today, instead of in a panic a couple months down the line.
Thanks to
u/_wpgbrownie_ for this insightful compilation.
submitted by
TheAviotorDemNutzz to
TorontoRealEstate [link] [comments]
2023.06.10 04:44 Dismal-Principle-260 Technology Consulting vs Software Development
Hi people!
I seek advice regarding a couple of career choices that I need to make. I am a fresh graduate with a master's in computer science and around 3 YOE working with developing cloud platforms for a couple of Big Tech companies (before I started my Master's).
I got an offer from a Big 4 for the position of a Senior Technology Consultant in their Financial Services organization, and started with them in mid May. But I got an interview callback from one other company (a prominent clearing house) in my first week with my current employer. I went ahead with the interview, and was able to secure an offer. It's a senior developer position.
I have a fair idea of what to expect from the second offer in terms of long term career prospects, but I am not able to identify what upside/downside I might have if I stick at my current Big4 position. I want to stay in the financial services domain for the next few years, and want to pivot to the quant side eventually if I can. Can someone tell me which place might be better for me if I want to do that? I want to stay fairly technically oriented during my career. What are the other upside of being a consultant with a big 4(if any) that I might not be aware of? It's still early weeks for me with the company, so I'm not able to gauge it well enough.
A couple of side note questions:
- Will it look bad for me in future job searches that I left a company 1 month into the job?
- I wanted to know what's the average bump in TC one would expect in my position? I am technically a lateral hire, but it's also just been 3 weeks since I graduated. FYI, I have been offered a ~13% bump in TC with my initial offer.
Thank you for your help in advance!
submitted by
Dismal-Principle-260 to
Big4 [link] [comments]