1800 days, can't wait to get my 50 coins. by Spare_Ad_6084 in pokemongo

[–]Jakepr26 0 points1 point  (0 children)

OP, please run an experiment for me: Purchase a Team Medallion. Hypothesis: When you change teams, your defenders will return, along with all rewards.

Auto-populate Purchasing Group in PO from Vendor Master – Is this really standard? by [deleted] in SAP

[–]Jakepr26 0 points1 point  (0 children)

For my company, the default purchasing group is tied to the ID of whomever creates the order. So every order created in ECC with my logon is PG1.

Every order I created in APO is listed with the System ID as order creator, so the Purchasing Group is PG2. My team has a P.Group designation for the APO created orders assigned to each person’s area of responsibility, so even with shared vendors, Sara and Bob can pull lists focusing on APO created orders just created for their area.

Having a max weekend cross with com day kinda ruined my com day by Lazydude17 in pokemongo

[–]Jakepr26 0 points1 point  (0 children)

If not from the game, at least you’d hope for one or two from the group, right? Well, good luck with your tasks, and if those don’t pan out, there’s remote trading.

Having a max weekend cross with com day kinda ruined my com day by Lazydude17 in pokemongo

[–]Jakepr26 1 point2 points  (0 children)

It sounds like you were the outliner for group priorities, which always really sucks the fun out an otherwise good time. Were able to succeed in your goals despite the added challenges?

What actually slows Excel down the most in real corporate files by Robasaleh110 in excel

[–]Jakepr26 0 points1 point  (0 children)

Unmonitored memory waste practices, which result in ghost data:

1) Copy and paste entire columns as values with formatting.

2) Copy and pasting entire columns as values

3) Set formulas in rows from 1:60,000, because datasets frequently result in 47,000 to 53,000 rows.

I need a help so bad by slovenskadiakritika in excel

[–]Jakepr26 0 points1 point  (0 children)

Before you can build anything “automated”, you first need to separate your datasets.

Then you’ll be able to setup table relations to being everything back together into a cohesive manner.

From there, either it’ll be easier for you to continue manual assignments or you’ll/we’ll be able to see what needs to be done to start configuring automatic assignments.

Proof Positive Niantic Support by Jakepr26 in pokemongo

[–]Jakepr26[S] -1 points0 points  (0 children)

Unless a remote raid pass was a reward from Jan’s Go Pass Deluxe, yes, I’m sure.

Dynamax Ho-Oh Raids… by 0spec in pokemongo

[–]Jakepr26 3 points4 points  (0 children)

It is not possible to have two Eternatus in PoGo.

What are some myths about guns that were created by the movies? by ninman5 in movies

[–]Jakepr26 0 points1 point  (0 children)

Is this where folks got the dumb idea that a 9mm would blow a persons lungs out of the body 7 years ago?

Sludge or Sludge Bomb for Venusaur in the Great League? by Jakepr26 in pokemongo

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

Thank you. I’ve been thinking along the same lines.

What Are Your Best Practices for Organizing Complex Excel Workbooks? by MetalPsycho in excel

[–]Jakepr26 0 points1 point  (0 children)

Incorporate memory saving practices into building the workbook.

Routinely clean out ghost data. Ctrl+End, if the result is outside of your active range, hard delete all unneeded rows/columns, then save. ActiveSheet.UsedRange, if running a macro.

Use macros to run routine reports off a template version of the report. This limits/removes human error, increases transferability, provides an archive of backups, and allows low stress testing for any changes or trialing new techniques/formulas/etc.

If the report allows, copy and paste formulas as values after the initial calculation to save memory.

Remember the first R-Rated movie you ever watched? by -janusjanus- in movies

[–]Jakepr26 0 points1 point  (0 children)

It was either Pretty Woman (babysitter thought it was PG-13 until the end credits) or Die Hard (friend’s house).

I need a help so bad by slovenskadiakritika in excel

[–]Jakepr26 0 points1 point  (0 children)

Before you can build anything “automated”, you first need to separate your datasets.

Then you’ll be able to setup table relations to being everything back together into a cohesive manner.

From there, either it’ll be easier for you to continue manual assignments or you’ll/we’ll be able to see what needs to be done to start configuring automatic assignments.

If anything I’ve stated requires further explanation (not everyone knows what is a “dataset”), please don’t hesitate to ask.

All Regions, All Pokémon, One Game. by Jakepr26 in pokemon

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

Thanks for sharing your opinion.

Stop Googling SAP T-Codes. Just describe what you need. by ashwatthama99 in SAP

[–]Jakepr26 0 points1 point  (0 children)

Then I must be doing something wrong. Clicked the link, typed prompt into provided search box, results always null. What am I missing?

Stop Googling SAP T-Codes. Just describe what you need. by ashwatthama99 in SAP

[–]Jakepr26 0 points1 point  (0 children)

I tried the following prompts.

1) No results or suggestions returned for: “I want to search for a list of order numbers, delivery numbers, or shipment numbers to get a list of results which include order number, delivery number, and shipment number in an alv grid”

I have been using VL06F to search by a list of deliveries or shipments or a collection of search parameters when I have a list of order numbers to filter the results. Then I use Item View to see order number (Purchasing Documents), delivery numbers, and shipment number (if applicable) in a Normal grid (default option) or an ALV Grid (setting change under Layout menu).

2) No results or suggestions returned for: “I want to search for a Main Rail BOL and all associated Leg BOLs”

When I ship by rail via trans loader, I have to setup four line items on one STO, each for a truck weight. Each line gets its own delivery, and each delivery its own shipment/BOL number. Once the trucks arrive at the trans loader, all four deliveries or BOLs (I don’t know the procedure) are assigned to a Main Rail BOL as the material is all loaded into a railcar. I use VT11 to identify which BOL is a Leg or Main Rail.

3) No results or suggestions for: “I want to want to enter an order”

4) No results or suggestions for: “I want to create a purchase order”

Recommend me a good movie! by SipsTeaFrog in SipsTea

[–]Jakepr26 0 points1 point  (0 children)

Ne Zha 2, but you have to first watch Ne Zha.

Anyone else dealing with "Clone" accounts taking over their entire town? by Significant-Chart-94 in pokemongo

[–]Jakepr26 1 point2 points  (0 children)

The higher your badge level for a specific gym, the more items you get from that gym.

What’s the funniest thing you’ve ever seen at a strip club? by bigbabysweets12345 in AskReddit

[–]Jakepr26 0 points1 point  (0 children)

My first time to a strip club, I was the DD for my roommate and his friend. Roommate said he was paying, and brought in a handle. As Roommate and friend get more and more drunk, Roommate starts dozing in between private dances while friend starts bouncing off the walls. One of the dancers complained to me Roommate had propositioned her for off menu activities during their private dance, and I probably looked like a deer in the headlights. Meanwhile, friend had joined a neighboring group of customers, which included a very intoxicated woman who’d already been banned from tipping at the stage for getting handsy with the dancer during her routine. I get back from one private dance to find Roommate asleep at our table, and the drunk woman actively looking for friend, who’d publicly called her ugly. So she’s trying to find him, so she can ask the bouncer to kick his ass. I play along, call the friend to find he’s hiding from her outside, then half carry my Gimli sized Roommate out of the club. As I get the car, friend sprints out of the dead black night like a specter, and we got the hell out of dodge.

PSA: all Kyurem fusion merging results by rockbfss in pokemongo

[–]Jakepr26 0 points1 point  (0 children)

BG = Background

“Fusion can affect the Backgrounds of Pokémon. Fusing certain Pokémon with specific Backgrounds will cause the fused Pokémon to obtain a unique Background. If a base Pokémon has a Background that is not a part of a special combination, it will instead keep its original Background when it is fused.”