#idk google sheets/excel is hard
Explore tagged Tumblr posts
Text
idk what im doing but im doing something
#.txt#making a spreadsheet for sims is hard#but at least i won't have to keep track on a sticky note like i've been doing LMAO#maybe eventually i'll create a better system#idk google sheets/excel is hard
11 notes
·
View notes
Text
Obey Me! Card Planning Tips
Hello! This game causes us all a lot of pain and suffering, but I’m MANAGING (?), so I thought I’d give what I’d consider some tips to maybe make things feel slightly more possible for you :)
I’ll split it into three parts and put it all under a read more.
Team Strength Calculation
Team Preparation
General Tips for Resources and Daily DP
Part 1: Team Strength Calculation
Each stage has 2 sins tied to it, as you’ve probably noticed. In chapters 1-20, the stats of these two sins are boosted for ALL cards (character and support) by 15%.*
In chapters 1-20, your team’s strength is calculated with the following formula:
Strength = 1.15(AttributeSin1Total) + 1.15(AS2Total) + Other5SinsTotal
For example, let’s look at Lesson 10-20, which is a Gluttony/Lust battle. My team is composed of Pandas Mean Profit (Greed), A Special Ceremony (Lust), and Colorful Panic (Pride). And I’m using zero support cards just so I only have to add up 3 numbers.
Strength = 1.15(24338) + 1.15(34921) + 122736 = 190884**
Keep in mind that the buffs only apply to the attribute sin scores. If the battle is Gluttony/Lust, the Pride scores will stay at their base values. This is the case for all lessons up through chapter 20, both normal and hard mode.
However, from Lesson 21 onwards, there are two changes. One, there is a primary sin and a secondary sin for each battle, marked by which icon is bigger in the preparation screen. (There always has been, but now it matters which is which.) In boss battles, both are primary. Second, the buffs have changed drastically.
Every card has its main sin, obviously, and its strength in that sin is the strongest. However, they still have strength in the other 6 sins as well. There are two non-main sins that a card is very strong in, two that it is average in, and two that it is terrible in.
The percent increase is now dependent on how good a card is in the battle's two attribute sins. (Remember that these buffs still only affect that sin, not the card’s total strength.)
If a card is the same sin as the battle’s primary sin, that sin gets a 160% buff
If a card is the same sin as the battle’s secondary sin, that sin gets a 90% buff
If a card’s second or third best sin is the battle’s primary sin, that sin gets a 30% buff
If a card’s second or third best sin is the battle’s secondary sin, that sin gets a 10% buff
Any sins lower than third best no longer get a buff
I’m not going to make a formula this time because it’s too long and situational. But let’s look at that same 3-card team again, this time with Lesson 21-5, a Lust/Gluttony stage in that order.
Pandas Mean Profit has an average Lust score, so it gets no bonus. Its Gluttony is its 3rd best sin, so that gets a 10% buff (10752 > 11827)
A Special Ceremony is a Lust card, so its Lust gets a 160% buff (17308 > 45000). Its Gluttony sucks, though, so that doesn’t get a bonus.
Colorful Panic has Lust as its second best sin, so it gets a 30% buff (10423 > 13549). Gluttony is its third best, so that gets a 10% buff too (9866 > 10852).
With the new system, the team’s Lust score has skyrocketed from 40158 to 65739. However, its Gluttony score dropped from 27987 to 26399.
This means that the sins of your cards suddenly matter more in battle. (And honestly I don’t think that’s a bad thing. I know people complain that it makes it harder, but. If my Comedy team in A3! is made entirely of Action/Drama cards with poor Comedy, I shouldn’t expect that team to do well. Idk why people think that shouldn’t apply to Obey Me.) Which brings us to part 2.
By the way, colored glow sticks raise the card’s total strength by 10%, and rainbow glow sticks raise it by 30%.
* It’s actually like 14.99% but it’s effectively the same. The “slightly under but so close that I’m just rounding for significant figures” thing will be consistent for all of these buffs.
** The actual in-game strength is 190881, 3 points off due to the .99% thing.
Part 2: Team Preparation
I’m so sorry. But someone has to say it. Are you listening? Great.
URs aren’t automatically better than SSRs. Honestly, they never were. They ESPECIALLY aren’t now. You’re not losing the battle because you’re using SSRs. You’re losing the battle because you’re throwing Wrath cards at a Sloth opponent.
Morning Voice is an Envy SSR card. My copy of the card is only level 10, and in a Lesson 21+ Envy battle, its Envy score is 6866.
What is my Level 90 UR Colorful Panic’s Envy score in the same battle?
3489.
Colorful Panic is a higher rarity and 80 levels higher. It has worse Envy. Why? Because Envy is its worst sin.
Obviously you aren’t going to be using a level 10 card in a battle, so for a more realistic standpoint, my copy of Resentment Runs Deep (SSR Envy) has 46108 Envy in the same battle. That’s 13x better than the UR.
I’ll repeat it one more time before I move on. The sin scores of a card are far more important than the rarity of the card. A random SR card of the right sin is better than a UR with no sin bonus. The most impressive thing about a UR is how hard it is to get one.
Anyway, what does this mean? Is it hopeless?
Well, if you wanted to binge all three seasons within the first month of playing, yes. But let’s assume that’s not the case. (Side note, but the feeling that our cards are never good enough is definitely exacerbated by the aggressive speed at which they release new lessons combined with the fandom’s apparent allergy to spoiler warnings, but that’s a point for another post maybe.)
Remember that having URs isn’t actually all that important. Now remember the sheer amount of SSRs they release since they also aggressively release events. Also remember that with every 10-pull, you’ll get at least one SSR+. (Also remember to never do single pulls; they're not worth it at all.) If you’re really struggling with a lot of battles, here’s how you can improve your scores while focusing on as few cards as possible.
Open an Excel document or Google Sheets page and make a chart that looks something like this:
[Image Description: An 8x8 Excel sheet. ��The columns are labelled with each of the seven deadly sins, and the rows are labelled Cards 1 through 3 and Support 1 through 3, with a blank row in between. The rest of the sheet is blank.]
Now choose a card you want to use. Doesn’t matter why you want to use it, maybe you like how it looks, maybe you worked really hard to get it, maybe you like its ability, maybe it’s just your current strongest card. I don’t care. For my chart I’m gonna use Pandas Mean Profit because it’s really pretty and I got it from the 100-pull pity reward.
Look at your card’s top 3 sins and put them into the chart. For the character cards, note who the card is, because you can’t double up. For reference later, also note whether it’s 1st, 2nd or 3rd best. (Be sure to do this through Contacts and not a battle so there are no buffs skewing the scores.)
Once that’s in, choose another card you like for a different sin and input that card’s top 3 sins. Envy is still completely empty, so I’ll put Resentment Runs Deep in next. It’s an SSR, but I really love the Refresh Team ability. Do this for one character card and one support card of each sin at first, if you can. It doesn’t matter what level they are right now. Then fill in whatever blanks you have with cards that specialize in that sin.
If a sin comes up more than 3 times, keep whichever ones are strongest in that sin without overlapping characters. Play around with it until you get something that works for you. Keep note of the sins you’re lacking cards for.
[Image Description: The same Excel Sheet as before, except filled in with various Obey Me card names. The cells in rows 2 through 4 are color coded to match the character of the card. Each cell marks in parentheses how strong the card is in the sin of the column it’s in from 1 to 3.]
Mine looks like this. This chart isn’t perfect (if you look, none of my cards had Envy as a good non-main sin, and Pandas and Bunny have too much overlap for the same character), but it works as a rushed example. I used the cell colors to mark the characters.
Are these the teams you should be using for each battle? No, obviously not. First off there’s no single-sin battle, and second off the game will still build the teams for you.
BUT, this greatly lowers the amount of cards you need to pour resources into. Instead of 42 cards, with this chart I only have to focus on 18 cards in order to be guaranteed that all my cards get at least a SLIGHT boost in each battle. The best-case scenario would drop it down to 14 cards.
Later on, once you’ve managed the cards on your chart, the next thing to do would be to find main sin cards to replace those that are only third best in their sin. On mine I’d definitely focus on a Gluttony character card next, but in general Sloth is the one you want to be the most proactive about.
That should help you get through at least Season 2. Season 3 is admittedly where the difficulty actually IS ridiculous, but Season 2 really isn’t as hard as we’ve been saying. It just requires more planning than “the first three URs I ever got.”
I do still apologize for the resources and Grimm it’ll take, though :’)
Part 3: General Tips for Resources and Daily DP
This section is just some extra tidbits to help you have the resources to get cards and upgrade them.
[Image Description: The “hard to swallow pills” meme. The pills read “You don’t need every single card and unless you’re a whale eventually you’re going to have to prioritize some events and ignore others or you’ll never have the resources to improve the cards you already have.”]
However, events ARE good for farming Grimm, so it’s not the end of the world if you want every SSR. The only issue will come up when you need hard mode items and never have any AP, but it’s manageable.
If you’re going to log in more than once throughout the day, you can do the 2-1 job distribution. If not, do three jobs with one character each so you get the daily task done
To save money for leveling up your good cards, complete the devil tree daily mission with N-rank cards.
Use vouchers over DP whenever you can (and use Raven to get vouchers). The 99 DP level-up sale IS worth it if you can afford it, because that’s like 50% off a 10-pull once you do two.
I’m not certain, but I THINK skill level also influences how often an ability activates? I feel like my Lv 10 SSR cards activate often but my Lv 1 URs never do. So if you’re relying on an ability, the permanent SSRs might be worth looking at over limited time cards.
Anyway, I hope this helps at all in our mutual suffering.
28 notes
·
View notes
Text
welp. I had my interview. it started off on a bad note not due to any fault on my part, but instead because I was given the wrong time in the email - I was told I had to be online at 2pm, but my interview slot was for 3pm. I didn’t question this when I got the email because I thought I just had to be online an hour earlier, because of the task I had to do. so I was on zoom, and nothing, for ten, fifteen mins. finally I emailed and asked, and they clarified within about ten mins that yes, my interview started at 3pm.
and idk if it was just me starting off on the wrong foot so to speak but I just felt uneasy from then. even before that I felt like this was just Not going to play out the way I wanted, and quelle surprise. I was right. I had to do a task first. the first bit was on google docs which was easy enough. the next bit was on google sheets which I’ve only used like three times, so I felt it was nowhere near as user-friendly as excel. (tbh it’s probably more that I have used excel a gajillion times and google sheets a handful of times, so I didn’t understand the functions as well) so it took longer and I couldn’t complete the third component of the task.
that was stressful enough. then I had my first interview with the panel I had met in my initial interview. it went okay at first, but I felt nowhere near as confident as in my initial interview. the star answers I was supposed to give just - did not come out. and I could tell I was rambling a bit. plus it didn’t help that none of these questions were framed in the “give me an example when” format which is how I operate best in interviews.
THEN. then. an interviewer asked a question. I started answering it and then had to ask him to repeat it. the same thing happened when it got back to that specific interviewer (there were three total). but the second time, I couldn’t figure out what to say. I just couldn’t say anything. I kept tripping up on my words and twice I put my face in my hands and said “sorry”. at the same point a splitting headache was kicking in which did not help. I mumbled something about how this is the first day I was fasting. one of the interviewers took pity on me and said I could have two minutes if I needed a break.
idk how I managed to, but I sat down two mins later after nearly hyperventilating and managed to give a proper answer to the question that was asked. they said then that to conserve my energy that would be their last question, and that then I could ask any questions I had. which I did, and that helped calm me a bit because I had those prepared at least. and I asked them and we got the conversation flowing and I wondered if maybe I could rescue this mess (bc at one point during above hyperventilation I seriously considered sitting down and telling them I couldn’t do it, that I had to go, that I should just end the zoom call).
at the end of the first interview I apologised profusely and thankfully the interviewers were really nice about it, and they said I didn’t need to apologise and that if I need another break before the next interview I could have that. I also know for a fact that they take mental health far more seriously so hopefully when they said that they meant it.
the second interview felt much more chilled, and was less about my competencies and more about who I am as a person, and how I could fit into the team. it was much smoother but I could tell it wasn’t quite as chilled as they were making it out to be, in that this would form part of their opinion of me as a candidate.
but. I don’t think I got the job. I don’t think I deserve it either. and honestly that feeling on its own makes me feel awful. I hate myself, and I hate my brain for short-circuiting on me when I needed it the most. I hate that this had to happen on the first day of a holy month for me. but I hope that I can move past this. and I will just try really hard to keep it together until monday when they let me know how I did. I don’t feel positive about it though. even with them being understanding - I’ve just seen when situations like this can be the difference between giving someone the job and not.
I don’t know if I’m ready to talk about this on chat yet. I will say if that changes.
2 notes
·
View notes