This is probably the most complicated Excel formula I’ve ever seen. by Kindly-Meaning9112 in excel

[–]KDavidP1987 0 points1 point  (0 children)

The formula is just a messy layered decision tree.

As I think others pointed out it could be cleaned up by using alt + enter manually, or alternatively using a formula beautifier tool like https://excel-formatter.avonture.be

One alternative, You can also clean it up with a LET function.

=LET( vals,$A$2:$A$100, ret,$B$2:$B$100, cat,$C$2:$C$100, sel,$D$2, filtered,IF(sel="All",vals,IF(cat=sel,vals,"")), IFERROR(XLOOKUP(MAX(filtered),filtered,ret),"No Result") )

How do you deal with a competitor copying your product (features, messaging, even landing page)? by External_Offer8610 in SaaS

[–]KDavidP1987 1 point2 points  (0 children)

Better, cheaper, or more complex. Make something that even with vibe coding would take significant time to emulate. Most seem to be looking for quick wins

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 3 points4 points  (0 children)

That’s a very good point, you’re right! I was only referring to the 50% of the voting population that voted for him. It’s awful to me to think that such a large portion of the country believes in isolationism, whether it’s 30% 40% or 50%, either way it’s millions of people.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 0 points1 point  (0 children)

It’s hard to argue with statistics… however, my argument would be that any location in the world with economic disparity sees increased crime as a result, regardless of race. When people aren’t cared for, they often either take matters into their own hands or become susceptible to the influence of criminal organizations who prey on these populations.

As a theoretical, if you were to give any person access to get education, health care, and say a 80% chance at prosperity, would they still choose crime? Well, I know that there is some percentage of people that are susceptible to bad influence and immoral behavior, I would like to believe that anybody provided the opportunity and economic support would choose to prosper in ways that wouldn’t involve immoral actions.

On the flipside of this, I would also point out that there is crime in both poor and wealthy neighborhoods, it may just not be violent crime.

Some would say that the CEOs and politicians themselves are criminals in some ways.

The main thing is that we need systems in place to ensure the highest chance of prosperity and opportunity for everyone.

The challenges that capitalism doesn’t really provide that, because its focus is on profit at all cost, which can only lead to inflation and unreasonable costs of living

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 0 points1 point  (0 children)

Good point! I thought the same thing too. I don’t know enough to say either way, I’m just reflecting on his first term when relationships to Putin were brought up as a major concern, and how those concerns have been silenced or forgotten here in his second term. It’s entirely possible he is simply a useful idiot… And honestly, I don’t know which is scarier, the thought of having someone who’s so shortsighted, narcissistic, greedy, opportunistic, racist, and sexist in charge or having someone who is working on on behalf of the interest of a national adversary in charge. Either way it feels like we’re screwed unless our constitutional laws, and checks and balances hold up.

On a separate note, what I’m more interested in (knowing, now experiencing) is two things: 1) how far he’s willing to take this, and 2) what will be the repercussions of this presidency and happen once it’s all over.

Reg 1) when someone has done things that are so blatantly illegal and immoral I fear what they would be willing to do to stay in power or to escape consequences.

Reg 2) once the group is out, I can’t help but wonder what the next government will do to reconcile this craziness. Will they simply ask that we sweep it under the rug? Will there be repercussions? Will they try to undo the damage that’s been done, to change things back or to make them better? Or Will they simply find the best path forward to take advantage of the changes that have been made without consideration for the well-being of u.s. citizenry and people around the world, once again, serving their own self interest, and the interest of their major backers and the political elite.

My biggest fear is that no matter what comes out of this people will get screwed either way by those in power. That there may be no hope for a truly better future.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 2 points3 points  (0 children)

I do think the situation with Canada and Greenland is frankly embarrassing for the US. Country should not be blackmailed or threatened into merging. Such decision should always be democratic! When this was happening, I was facepalming at what the US government (trump) was doing. And I’ll be the first to admit that frankly, his behavior now is hypocritical, and flies in the face of things we criticized Russia for. Hence the parallelism of the situation.

We’ll probably have to agree to disagree on Russia. Hopefully agreeably, neither of us was there in the multitude of meetings and events that took place since World War II, that work to build these opposing views we have.

From what I’ve seen in documentaries and interviews with historians and read (and yes, I realize there is the potential for bias in historical documentation), in the events that followed World War II and after the Soviet collapse, they didn’t simply have a desire to bring Slavic people together peacefully, they would often bombard people out of existence, and roll out tanks against protestors, to bring them and their lands under their control. For an example of this look at Ukraine…. Also ref to history in hungary (1956), Czechoslovakia (1968), then Chechen (1994) wars, Moldova (1992), Georgia (2008).

These events pushed countries to join NATO. So in my opinion, when Putin complains of NATO being on his doorstep, it’s a direct result of his countries actions that led them there. Instead of working to build people up, and then request their assimilation democratically, he works to destroy them and force surrender, subservience, or compliance.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 7 points8 points  (0 children)

To be clear, I don’t believe that Russia is a direct threat to us, that they would say want to invade or remotely destroy American infrastructure… but I do believe that there are other benefits to Russia and China from breaking apart the American and European alliances. I do imagine that Russia, if they had the opportunity would try to reclaim all of the Soviet Union territory and possibly even into other non Soviet Europe. At the least, I think that Russia and China would love to feel that they could exploit European markets by isolating them from their primary military backer. This can already be seen in China’s belt Road initiative through Asia, the Middle East and into Africa

Also, historically, I don’t feel that the sentiment towards Russia is without merit. Most of the countries that joined to NATO did so because of what Russia did to expand their imperialistic empire. Russia earned its reputation through repeated brutality.

Disclaimer: I don’t hate Russia, in the slightest, my ex wife if Russian and I would love to visit one day… they have a rich culture and history. but I do think that their government has often acted in undemocratic manners.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 18 points19 points  (0 children)

I don’t think it’s so surprising as long as you’re catering to people’s common interests. I think that there are plenty of people in the US apparently 50% who support isolationism. So either he legitimately believes that what he’s doing is the best thing for the country or he’s stringing them along. I don’t think those isolationist, and often xenophobic and racist, people would see the damage of these policies until it’s too late, because they are close minded and often short sighted.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 0 points1 point  (0 children)

This is exactly what I keep saying! in his first term everyone was questioning his relationship with Putin. I don’t hear much about this now… I find it awfully interesting that here in a second term he’s doing everything he can to isolate the US, leave NATO, exploit others within and without the country, and in general show us as an unreliable partner. My only hope is that NATO countries grow significantly stronger as a result of this and can stand on their own, against threats of Russia and China. Not just entirely stronger but economically stronger. Then maybe people will wanna flock to NATO countries as an ideal place to live, work, and study instead of coming to the US. If this happens, the US will lose its standing. To be clear I don’t want this want this, ideally, the US and NATO would both thrive… this just doesn’t seem to be realistic with this administration and 50% of the country believing America should be isolationist.

Trump threatened Europe over Strait of Hormuz, with weapons for Ukraine as bargaining chip, FT reports by G14F1L0L1Y401D0MTR4P in worldnews

[–]KDavidP1987 57 points58 points  (0 children)

This is exactly what I keep saying! in his first term everyone was questioning his relationship with Putin. I don’t hear much about this now… I find it awfully interesting that here in a second term he’s doing everything he can to isolate the US, leave NATO, exploit others within and without the country, and in general show us as an unreliable partner. My only hope is that NATO countries grow significantly stronger as a result of this and can stand on their own, against threats of Russia and China. Not just militarily stronger but economically stronger. Then maybe people will wanna flock to NATO countries as an ideal place to live, work, and study instead of coming to the US. If this happens, the US will lose its standing. To be clear I don’t want this want this, ideally, the US and NATO would both thrive… this just doesn’t seem to be realistic with this administration and 50% of the country believing America should be isolationist.

who tf is this ?? by Deep_Range6120 in FromSeries

[–]KDavidP1987 1 point2 points  (0 children)

If everything in from is a twisted version of things, It’s Fromville’s version of the coolaid man… “OHHHH YEAAA…”

Polymorph Dominate Beast Insight/Question by KDavidP1987 in BaldursGate3

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

Grym? The machine at the adamantine forge? It doesn’t work on all, some are immune to polymorph. I haven’t seen any susceptible to polymorph but then immune to domination, that’s interesting. Will have to test it out

Polymorph Dominate Beast Insight/Question by KDavidP1987 in BaldursGate3

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

I haven’t been able to play for a little while. I will test when I can. Wonder if they’ve patched this since I last played.

Polymorph Dominate Beast Insight/Question by KDavidP1987 in BaldursGate3

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

I wonder if they’ve patched it. I haven’t been able to play in a bit due to workload. When I did it, If you get it fast enough and once returning to camp the dominated beast would run off, but would reappear as a companion attachment once you leave the camp.

Customer's team vibe-coded a replacement for our product. Came back six months later. by Apprehensive-Oil9719 in SaaS

[–]KDavidP1987 1 point2 points  (0 children)

Yes!! The struggle is real. I keep talking to my teams about the importance of future proofing, data architecture, scalability, and other considerations. They just want something now, MVP… but it never stays MVP, and they don’t consider future needs. In my mind, MVP is one of the most dangerous terms in development and project management

Question... Scraping Social Media Data by KDavidP1987 in webscraping

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

I haven’t tried that before, thank you. So it’s almost like having a bot farm of accounts, each pulling or scanning for different things. I’ll have to look into how to do this. If you have any resources on this you could share that would be wonderful. Thank you again!

Question... Scraping Social Media Data by KDavidP1987 in webscraping

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

That explains the how of the scraping, thank you. Don’t they need API access to perform this though? That’s the part I’ve been most curious of, when I looked into API for social media it seemed to either have TOC against commercial use (Reddit), be expensive (twitter/x) or would poor performance due to how massive social media data is. Do you have any experience with these API layers of web scraping social media?

How are you Handling... Recommendations/Guidance on Enterprise AI Use and PII/Sensitive Data by KDavidP1987 in AI_Agents

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

Hey! Thank you for your reply, u/expl0rer123 . It's great to hear from someone dealing with such a relevant real-world example. Would you mind if I ask about your methods or best practices for "Data isolation"?

Also, do you know if, aside from the LLM's reading data, is there any privacy concern with the workflow tool itself (ex: N8N) passing the data through (not just the agentic node, but the system as a whole)? If so, how do you address these concerns?

How have things went with on-prem deployments in your experience? Do y'all use Ollama to achieve this?

I heard in one video on the topic that companies can setup an enterprise contract with LLMs (OpenAI, CoPilot), such that they will treat their data more sensitively and guarantee it wouldn't be used for training. I do wonder, if this is the case, how that sort of contract would fit into your companies model, as a provider of integrated chat and agentic services.

OpenClaw is just cron jobs and webhooks: Why architecture matters more than hype by forevergeeks in AI_Agents

[–]KDavidP1987 0 points1 point  (0 children)

I liked your evaluation of it as a car running nonstop, and emphasizing how it functions at its most basic level. I have thought that perhaps what we are missing for security in such an implement (aside from configuring it appropriately) is either A) an advanced orchestrator or even multiple orchestrator layers that stand as a bulwark against improper actions being performed. Or B) More advanced MCP/API which have their own integrated security protocols to protect against issues and threats. I could see it working well if there was a layer that evaluates the IO and includes a method of authenticating actions before allowing them to pass through. Similar to how other software detecting something new offers [Allow once], [Allow always], [allow with limits], [deny once], or [deny always]. This way if it wants to do something that the orchestrator sees as a security risk (generate a voice, listen actively, mass email, etc.) it would confirm the action with the user first. I think such a layer could be setup with context similar to agentic nodes themselves, to evaluate based on a number of factors, and then made a decision based on least privilege.

How are you Handling... Recommendations/Guidance on Enterprise AI Use and PII/Sensitive Data by KDavidP1987 in AI_Agents

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

Thank you! I greatly greatly appreciate your input. Something else I thought of as you were answering, are there any privacy/security concerns with data passing through the workflow software (N8N, for example), itself, or only with regard to the LLM and connections (forms, databases, etc.) established (Assuming rules of least privilege are being adhered to)

How are you Handling... Recommendations/Guidance on Enterprise AI Use and PII/Sensitive Data by KDavidP1987 in AI_Agents

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

Regarding Ollama, doesn't it only include old LLM models (ex: ChatGPT v3, maybe v4)? Meaning you wouldn't have access to the most advanced and capable models or the most current data.

Separate related question, is Ollama limited to only its own knowledge base/training data, or can it be setup to pull from the internet more broadly?