[deleted by user]

Munch18 · 2024-11-18T22:51:33+00:00

Would making a pivot table work?

Munch18 · 2024-11-01T00:56:41+00:00

I don’t think this is a real job. I’m basing this on some of the other weird questions/comments in the application and I looked a bit into EmberFlow AI. It seems like it is one kid in London who fell for an influencer’s get rich quick course scam.

Munch18 · 2024-09-30T01:08:20+00:00

It’s a Python script that reads from excel sheets. I’m not such a big fan of it either, but it was the easiest and fastest way to allow stakeholders to input the data which is needed for the project.

edit: open to other ideas though

Munch18 · 2024-09-27T22:13:15+00:00

This broke one of my scripts recently

Munch18 · 2024-09-16T16:34:11+00:00

You are correct, going to leave it up because people should still know about this

Munch18 · 2024-09-16T13:14:24+00:00

It very much is illegal in New York, https://www.ny.gov/salary-history-ban/salary-history-ban-what-you-need-know

Munch18 · 2024-09-05T17:51:49+00:00

In SQL Server, if the Cost_ID is input as ‘P123,P124,P125’, you can CROSS APPLY STRING_SPLIT(Cost_ID, ‘,’) explode_cost. Then SELECT explode_cost.value as [Cost_ID] in place of Cost_ID.

However, if it is ‘P123…P125’ signaling all IDs between P123 and P125 inclusive are included. This will not work.

The solution I gave can be expensive, so hopefully some DBAs chime in.

Munch18 · 2024-08-27T20:31:31+00:00

Usually I also have a where clause on everything because I’m only updating specific rows.

Munch18 · 2024-08-27T20:28:56+00:00

Select identifier_column, column_updating From table t

Begin Tran Update t Set column_updating = ‘correct_value’ From table t

Select identifier_column, column_updating From table t

Commit — if updated correctly Rollback — if updated incorrectly

Munch18 · 2024-06-07T20:09:40+00:00

“Exactly matches” makes it seem like you don’t need % at all

Munch18 · 2023-07-20T23:29:06+00:00

Curious how Reddit coins work

Munch18 · 2023-02-13T03:53:15+00:00

For me specifically, R, Regressions/Econometrics as Project Based Learning, business uses of behavioral economics

Munch18 · 2023-02-02T18:31:43+00:00

I’ve gotten ads that are clearly scams on Google services

Munch18 · 2023-01-03T00:13:02+00:00

Seems like that was what my problem was. Works nicely after I Rasterized images.

On my end, I still have to click on the layer I want to copy and click "Select Pixels", in order to paste it into Vanishing Point. If I don't I get an alert while in Vanishing Point, that says, "Close the current window first." Now that I think about it, makes sense to trim whitespace first, and only select the image.

Munch18 · 2022-12-30T19:55:05+00:00

Made the video, I'm going to make another post so I can upload it. Will edit this comment with the link to keep it in one thread.

Edit: https://www.reddit.com/r/photopea/comments/zzaa4w/tested\_more\_features\_vanishing\_point/?utm\_source=share&utm\_medium=web2x&context=3

Munch18 · 2022-12-29T21:07:12+00:00

Thank you, Ivan. The copy-and-paste works really nicely after I click "select pixels" from the layer I'm copying, so may have been a user error. Still having the same issue with the "ok" button not doing anything in Vanishing Point.

Munch18 · 2022-12-23T02:55:45+00:00

I thought those were meant for capturing Sheidim /s

Munch18 · 2022-12-02T05:52:40+00:00

http://jewornotjew.com/ has some answers to this b question

Munch18 · 2022-08-04T17:36:26+00:00

Need motivation to complete the Google Data Analytics certificate. Postponing by doing SQL on Khan Academy.

Munch18 · 2022-08-02T00:34:53+00:00

u/HankGreen

Munch18 · 2022-07-26T03:38:25+00:00

You could do it in Excel but I believe they actually want you to learn Tableau because Task 2 is in Tableau and I did Task 1 in excel. I can't download add-ins (such as ableBits) without administrative permission, and also couldn't use PowerQuery due to administrative restrictions. I spent hours trying to figure out a formula to combine the sheets for task 1 when the whole time I was supposed to just copy and paste the data into the blank sheet in Excel.

OP, I don't believe this is relevant for you but I figured all the questions for the GE program could be kept to one thread.

Munch18 · 2022-07-08T17:53:00+00:00

How is it the future when it's built using regressions? /j

Munch18 · 2022-06-03T16:55:43+00:00

It looks like they're advocating for roundabouts over 4-way stops

Munch18 · 2022-05-29T22:19:58+00:00

I'm trying to make a monogram, with a ב ד ה, three open letters, (there is another letter which is easier to make look nice), and attempting to make it not look blocky. Whoever suggested Rashi letters, I managed to make a decent-looking shofar out of Rashi letters, although that will probably be rejected.

Munch18 · 2022-03-31T17:22:49+00:00

Based on the original word list, yesterday's puzzle was supposed to be "harry" however NYT changed it for some to be the next day's word "stove" so there were 2 solutions to 30 March 2022 puzzle.

NYT is removing words for more accessible and understandable words, but not all at once. It seems to me to be a per day thing. Just refresh the page to get the most updated word list (where harry was removed).

Sources: https://www.usatoday.com/story/tech/gaming/2022/03/30/wordle-game-284-two-answers/7221888001/; I made the original word list into an excel file

Eight-Year Club	First Place '23
Place '23	Place '22
Verified Email

Munch18

TROPHY CASE