Farrix

u/Farrix


r/magicTCG•

I was at the Atlanta GP and lost my Standard deck on Sunday. I've emailed SCG to request they check their lost and found but am reaching out here for help as well.

It was a Rakdos deck, built around Lightning Berserker, Reckless Imp, Silumgar Assassin, and Ruthless Ripper and was in a plastic deck box that was either light blue or aqua marine (I have a hard time telling them apart).

If anyone thinks they may have found it or knows anything about it, please let me know. If more information is needed, send me a message and I can provide more specific information (for verification purposes).

82

r/ffxiv•

I've been playing Dragoon for about a month now and it's the first class I've started with. I feel like I've learned the in's and out's of it pretty well at this point. With that said, I've also noticed that most other Dragoons I see do not use Heavy Thrust or Disembowel and that just blows me away.

I was just in a Titan HM match with another Dragoon and asked him why he wasn't using Heavy Thrust. His response is that it's a bad combo and that "combos go faster the more you use them."

Firstly, and correct me if I'm wrong but I've not seen anything disputing this, combos go at the same speed as your skill speed. They do not chain more quickly the more you use them.

Secondly, you're -not- u

35134


r/magicTCG•

Let's say I use hydroform (http://gatherer.wizards.com/Pages/Card/Details.aspx?multiverseid=366423) on my opponent's land, then create a copy of that creature using Stolen Identity (http://gatherer.wizards.com/Pages/Card/Details.aspx?multiverseid=366427).

Do I now have a land/creature that I can tap for mana?

What happens to the creature token I've just created after the end of turn? Does it stay a flying 3/3 land, turn into a land token, or does it just poof?

114

r/excel•

At work we have an antiquated method of creating user accounts by manually inputting all information in the text boxes of our user creation form online.

Is anyone aware of a simple tutorial that can show me how to export information from Excel to a text field in a browser or can explain it to me? I'm assuming this is going to involve some VB. If I can figure this out, it will save us a lot of time in the future.

Thank you in advance to anyone willing to offer help.

12

r/excel•

I'm trying to find a hyphen in a word and compare the length of the word left after the hyphen.

For example:
Mary-Bell has a hyphen in it. I want to take everything after the hyphen (length of four) and compare it to be greater than or equal to seven in length. Bell is less than seven in this case so it would ideally trigger the "length < 7" function.

My code:
(to find if the last half of the name is > 6)
IF(AND(ISERROR(FIND("-",B5,1))=FALSE, LEN(MID(B5,FIND("-",B5)+1,99)>6),

(to find if the last half of the name is < 7)
IF(AND(ISERROR(FIND("-",B5,1))=FALSE,LEN(MID(B5,FIND("-",B5)+1,99)<7),

Unfortunately, right now this is giving me an error. How do

24

r/bipolar•

My doctor started me on Depakote and Celexa after having come to the conclusion that I may have Bipolar 2. I'll admit, after having been on the medication for about a week that I have noticed what I would call an improvement in my ability to handle triggers without slipping into a deep depression, only instead having a mild panic attack that I was able to recover from within a day and a half or so.

My new problem is right now I feel like I'm back on the upswing. I'm nervous that I'm going to end up back in a manic stage, feel great, and then crash back out of it instead of staying in that median line between depressed and manic. It shouldn't make me anxious to feel good and this is not

43

r/excel•

The password would be formatted in this way:

  1. If the last name is longer than, or equal to, 7 characters, the password will simply be the last name (e.g. =A1). This part is simple enough.
  2. If the last name is less than 7 characters, it will need to be auto-populated with sequential numbering until you reach the 7 character limit. This is the part I'm having trouble figuring out.

Examples:
Smith = smith12
Doe = doe1234
Johnson = johnson

Can anyone help me out with a single formula that could be pasted into a cell and then auto-filled down the page to create these? Any help is much appreciated and will help me to save a few hours of work.

26


r/loseit•

So, this is me in 2007 on the left, at approximately 250+ pounds. Then five years later (today) on the right at 180.

Show me some love? I've been feeling really down on myself lately and could really use the ego boost. :)

http://imgur.com/oiLiU

**Edit: Thanks for the compliments everyone, as it's really made me feel better! I was pretty much on the verge of tears for no reason the day before I posted this. Stress is a killer!

32152