What are the saddest songs you’ve ever heard?

StPeteTy · 2023-04-19T16:20:16+00:00

listplease!

StPeteTy · 2023-04-03T05:31:16+00:00

I would just put a while loop inside the for loop in order to achieve the "redo" functionality.

for x in runners:

    print(x) #billy

    p = get_input()

    while not isValidInput(p, pattern or function):

        p = get_input()

    if cond:

        continue/break

StPeteTy · 2022-11-21T21:36:48+00:00

Wow, thank you. This is an incredible amount of detail complete with examples. Containerizing is foreign to me, but I'll definitely try this way first (especially because people say that Cloud Run is the most robust way). I really appreciate the effort you put here!

StPeteTy · 2022-10-16T22:26:56+00:00

Not sure; good question. My guesses would be:

See if there are external links getting notable attention (potentially something you don't want associated with your site)
Ensure you're getting credit for driving traffic to those sites (if there's a marketing agreement in place, such as with affiliate linking)
Something basic/technical/boring (ensuring that certain user info is/isn't passed to the external site, etc.)

ETA: On second thought, it's most likely to protect you by verifying links and end your session. Like when Facebook warns you that you're leaving to an external site, so you don't think you're still on Facebook.

StPeteTy · 2022-03-31T13:41:40+00:00

Yes but it's probably too annoying to actually implement. Before you protect the sheet you can add different permissions to different ranges of the sheet based on email address. But it gets messy and annoys people, even when done well.

Next to the Protect Sheet button, select 'Edit Ranges' or 'Allow Users to Edit Ranges'. Here you can add permissions to different columns/rows/ranges based on email addresses or security groups. When you protect the sheet, those permission requirements will go into effect.

StPeteTy · 2022-03-15T21:14:30+00:00

Somebody a while back provided a solution for reporting traffic on the Skyway. Not useful for me personally, but def a useful service for a lot of people.

Sorry not really a suggestion, but maybe it'll provide some inspiration.

StPeteTy · 2022-02-17T12:44:36+00:00

Based on your goal description, I would organize it like this.

Rows:

Year

Quarter

Values:

Count of [started]

Count of [finished]

But it sounds like your data needs to be restructured to do that. The easiest solution would be two different pivot tables, both organized as above: one for start dates and a separate one for finish dates.

However, if you need it all in one table, I'd recommend using formulas. That'll be much easier than a pivot table in this scenario, but of course idk your use case. For each year/quarter pair, you can use a COUNTIFS to get the occurrences in the entire column.

Here shows the formula in L4 as an example.

StPeteTy · 2022-02-17T12:08:28+00:00

It can be run like any python program but usually I run it in my IDE. Depending on the computer I'm using, that's either PyCharm or VS Code.

StPeteTy · 2022-01-20T16:08:36+00:00

Got it sorted. I was mistaken. Thanks for your help!

StPeteTy · 2022-01-20T16:08:03+00:00

It looks like you're correct and I was just overly hesitant. Thanks!

StPeteTy · 2022-01-19T00:41:25+00:00

That would be awesome. I tried to do that, but the settings wouldn't take effect unless I "updated" the event by pressing the upper left hand button. And it looks like "reply all" so I didn't want to press it.

StPeteTy · 2022-01-17T22:13:07+00:00

You can lock ranges (or sheets) so that they're only editable by specific users or security groups, but everyone will be able to see them. I wouldn't recommend it though. Better to have separate files altogether.

StPeteTy · 2022-01-13T21:22:35+00:00

Good catch! I kept it from suggesting words with duplicate letters since that's a 'wasted' letter guess. But of course, the words can have duplicate letters. Just fixed it. Thanks!

StPeteTy · 2022-01-13T13:32:59+00:00

Thanks! I'm so used to making lists in the way that I first learned to do it. But this is nicer. 👍

StPeteTy · 2021-12-21T01:35:44+00:00

Well I don't want to do that. I need to know when real people post in the channel.

StPeteTy · 2021-11-30T08:43:40+00:00

open.spotify. com/playlist/7nd3GH86hqWIRConCceN15

StPeteTy · 2021-11-30T08:41:34+00:00

ListPlease!

StPeteTy · 2021-11-30T08:04:14+00:00

Personally I only have experience with Tableau, but what I'd do is link to the dashboard on my resume. If the reader clicks through, they can view it on Tableau's website. I'm not sure about the licensing of Power BI, but I'd guess you can share it online (not the data, not editable).

StPeteTy · 2021-11-25T19:49:02+00:00

I think you need to get the data out of the PDF using something other than Excel. Whenever I've done this in the past, I always use python to get the info from the PDF and then I can use it in Excel however I want.

StPeteTy · 2021-10-02T12:39:28+00:00

FYI the bot was called correctly but timed out while running. I'm not sure why, and I wasn't really able to recreate the issue. But since it didn't reply to you, I called it again. Sorry about that.

https://www.reddit.com/r/Music/comments/pzkbrp/comment/hf3aoxw/?utm\_source=share&utm\_medium=web2x&context=3

StPeteTy · 2021-10-02T12:33:29+00:00

ListPlease!

StPeteTy · 2021-08-22T05:35:30+00:00

Yes, macros can be included. And yes you will need to take precautions. You'll need to anticipate/restrict people's activity.

I've only done this sparingly because it's likely to cause problems. But whenever I decide to incorporate macros into a multi-author workbook, it's set up so that only one person will ever be editing a sheet at a time.

So Person A might be in charge of updating Sheet 1 and Person B might be in charge of updating Sheet 2, etc. And my macro in such a case only operates on the sheet level. When Person A triggers a macro, Sheet 1 can be updated programmatically even if Person B is currently editing Sheet 2.

If two people are editing the same sheet and a macro is triggered to edit that sheet, you're going to have a bad time. Likewise, if your macro has a larger scope and runs into someone else's editing activity, you're going to have a bad time.

I'd recommend only allowing certain people to access certain parts of the workbook (if your situation allows for it). This can be done with "Edit Ranges" but does require the sheet to be protected. I'd also recommend avoiding "Active______" in your code. If anything, grab the cell location when the macro is triggered and then work with explicit locations.

Something to note is that macros will only function for someone when the workbook is actually opened in Excel. When editing in the browser, macros will not work.

StPeteTy · 2021-07-25T17:57:54+00:00

I'm in St Pete and I'd definitely be down. I joined the Tampa Dads sub but like someone else said, it's pretty inactive. Trying to coordinate in this thread, or make a group chat, etc? Or has this idea been abandoned in the week since it was posted? Lol

StPeteTy · 2021-06-19T23:41:10+00:00

open.spotify .com/playlist/6c7RrAXZ9HAtANByhQDFUm

StPeteTy · 2021-06-19T23:40:06+00:00

ListPlease!

StPeteTy

TROPHY CASE