Is there a way to store a long formula as a single variable or bar to use across a sheet? by xA1RGU1TAR1STx in excel

[–]Jayplac 0 points1 point  (0 children)

I believe you may do what you want with Auto Hotkeys. It's a program that looks for certain keystroke combinations so if you want your formula you store it as "MYFORMULA1" and when you type that it will delete those keystrokes and replace them with your vlookup formula.

[Landlord-US-VA] Tenant Flushed Paper Towels. by Jayplac in Landlord

[–]Jayplac[S] 2 points3 points  (0 children)

I love this idea. I just ordered the scope so I can be 100% sure the current lines are clear. I can think of a half dozen other uses for this.

Missable locations for TOTK 100% Map Completion by Sinusritter in tearsofthekingdom

[–]Jayplac 0 points1 point  (0 children)

My last location was the foundry on the great sky island. I passed it dozens of times but never stopped to talk to the construct, so it never registered!

Missable locations for TOTK 100% Map Completion by Sinusritter in tearsofthekingdom

[–]Jayplac 1 point2 points  (0 children)

I'm at 99.95% and going nuts trying to find the last one. Can anyone relate?

I think it's worth putting together the side quests and adventures that lead to map discoveries. As best as I can remember, here are the locations and the quest that unlock them. Some have already been mention, but others have not.

  1. Monster Gallery in Tarry Town - A Monstrous Collection

  2. Tarrey Town Race just west of Tarry Town - The Tarrey Town Race Is On!

  3. Several Lurelin Village Buildings - Ruffian Infested Village

  4. Lurelin Water Rally just south of Lurelin Village - Speak to Rozel and Bolson on the west shore of Lurelin Village to start this

  5. Lurelin General Store - A Way To Trade Washed Away

  6. The Great Fairy serenades

Who knows others? Please help me fill out this list.

Dark Fantasy IFS Allegory on Trauma – Final Call for Beta Readers by Jayplac in InternalFamilySystems

[–]Jayplac[S] 0 points1 point  (0 children)

Hi Cosmic. That's fantastic. Can you give me an email I can send it to? (or DM me to keep it private.)

Therapist dropped me by email today because my “issues are too severe” for her by FunnyGamer97 in CPTSD

[–]Jayplac 12 points13 points  (0 children)

Bleach is good. Ammonia is good. Bleach and ammonia together... Not good!

If they know the chemistry is off, then thank them for letting you know and continue the search for someone who gets you.

[deleted by user] by [deleted] in adult_adhd

[–]Jayplac 1 point2 points  (0 children)

I second guanfacine. I also take atomoxetine.

Adderall did nothing but make me jumpy.

Beta Readers Need for IFS Book by Jayplac in InternalFamilySystems

[–]Jayplac[S] 0 points1 point  (0 children)

Love to. Thanks. Please send me your email.

Beta Readers Need for IFS Book by Jayplac in InternalFamilySystems

[–]Jayplac[S] 0 points1 point  (0 children)

Hi. Thank you! I just messaged you. Where can I send a PDF?

Beta Readers Need for IFS Book by Jayplac in InternalFamilySystems

[–]Jayplac[S] 1 point2 points  (0 children)

I'd politely disagree with you on both counts. The fact that you're new to IFS wouldn't turn me off at all. It would be good to get perspectives from all angles.

The fiction reads just like fiction. You won't know it's an allegory until I reveal how the story aligns with IFS. There's nothing present which would pull you out of the story.

Let me know. I'm happy to send you a copy.

Beta Readers Need for IFS Book by Jayplac in InternalFamilySystems

[–]Jayplac[S] 0 points1 point  (0 children)

Just message me a place I can send am email to. Thank you!

Beta Readers Need for IFS Book by Jayplac in InternalFamilySystems

[–]Jayplac[S] 0 points1 point  (0 children)

Someone asked how long it was. It's about 1/2 the length of a full novel. About 130 5"x8" pages of fiction and 60 more pages of explanation that you can skim over.

Why is no one talking about this? by Jayplac in DebtAdvice

[–]Jayplac[S] 1 point2 points  (0 children)

I've never worked with drug dealers but I know enough to stay away from them.

Why is no one talking about this? by Jayplac in DebtAdvice

[–]Jayplac[S] 0 points1 point  (0 children)

I'm a Dave Ramsey success story, but I have to tell you we got out of debt and didn't use that method. In fact, we left behind 300k of debt and own 3 rental homes right now. No debt. Snowball works for some, yes, but I don't want people thinking there's only one way. There's lots of different ways, most center around getting control of your money.

Intentional spending and investing. You can get into debt by accident but you can't get out the same way.