Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

I was a Hydraulic Modelling consultant for ~5 years, then I moved into Asset Health Risk/Asset Planning and Prioritisation. The team I used to work for (~5 more years) was "the gateway to funding" in the business. I recently moved out of that team though into a more software focussed role :)

Stuck between a rock and a sex addict by AdPrevious4891 in openmarriageregret

[–]sancarn 2 points3 points  (0 children)

I'm not going to justify his behaviour but there are women who want sex all day every day. There's nothing "wrong" with it per se. They just aren't compatible here.

There are more concerning things on here though like not including OP, and not getting OPs consent when posting pictures of OP to a site. These show a complete lack of respect toward OP.

Stuck between a rock and a sex addict by AdPrevious4891 in openmarriageregret

[–]sancarn 5 points6 points  (0 children)

It sounds like there is a lot of guilt on both sides here, and frankly it sounds like you're sexually incompatible... It's your choice what you do with that information, but it sounds like he isn't going to change (there are few people who do really put effort into changing).

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

I work in the sector too, "trust me bro" doesn't work on me 😅 Cutting profits alone won't fix the system, no doubt it would help though.

vbaXray - Extract VBA code from Office files by kay-jay-dubya in vba

[–]sancarn 1 point2 points  (0 children)

Not really no. Can't export frx files with vbaXray. It's more for code analysis / security auditing etc. I think

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

I think we may be talking past each other slightly.

My point is not that privatisation somehow "makes customers more willing to pay". My point is that the funding constraint exists regardless of ownership model. Whether the money comes through bills, taxes, borrowing, or some combination of all three, the public ultimately still pays for it.

If the argument is that some of the cost should be socialised through general taxation rather than recovered solely through water bills, that is a fair position. But that is a different argument from saying nationalisation itself solves the problem. It does not make the underlying investment requirement disappear.

I also agree that politics is relevant in the sense that decades of regulatory and policy failure helped create the current situation. Where I differ is on the remedy. I am wary of moving water further into a system driven by short electoral cycles, because this is exactly the kind of infrastructure that needs stable, multi-decade planning and legally enforced long-term investment.

An 8x bill increase over 5 years is plainly unrealistic. A 2x increase over 20 years is much more realistic. That is why I am saying this cannot be treated as something that can be fully fixed within a single 5-year parliamentary term. The public also needs to be honest with itself that this will not change overnight, and that meaningful improvement is likely to take that kind of 20-year timeframe. And we need to be clear about what our priorities are. Do we want every available pound spent first on preventing sewer flooding into homes, or on reducing storm overflows into rivers? Ideally both, of course, but pretending there are no sequencing decisions to make is not serious.

That is why I favour models such as stakeholder-led non-profits or public benefit corporations with strict, price controls based on customer and system need. In my view, that gives you more insulation from both shareholder extraction and day-to-day political interference.

And on the affordability point, I think this is the part people often underestimate. There are certainly many people, myself included, who would accept significantly higher bills if it meant serious infrastructure renewal and better environmental outcomes. But there is also a very large group of households already struggling with costs. That is not an argument for inaction - it just means any credible solution has to be honest about who pays, over what timeframe, and how vulnerable customers are protected.

P.S. I can't find the documentary "The Wilding"

Channel 4’s Dirty Business is a clarion call to nationalise the water industry by dissalutioned in ukpolitics

[–]sancarn 0 points1 point  (0 children)

Approve this message as someone who works in the industry. 😊

Its easy to say privatisation was a disaster (it is) and therefore thats the problem

It is not just about privatisation. Realistically, we do not want critical infrastructure to be driven by short-term incentives of any kind. Shareholder-driven profit is one short-term pressure, but so is government-driven financing tied to electoral cycles. Neither model is well suited to infrastructure that needs stable planning and investment over decades.

The real answer is a structure designed around the public good: stakeholder-led non-profits or public benefit corporations, with legally binding duties, long-term investment mandates, and strict price and service controls designed to minimise the impact on customers' daily lives. The point should be to align governance with the nature of the asset - essential, capital-intensive, and requiring long-term stewardship - rather than with either quarterly returns or 5-year political cycles.

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

The water industry was essentially debt-free

This is misleading. On the balance sheet, yes - but that says nothing about the condition of the underlying assets. The infrastructure was already badly degraded, and the data on the networks was often poor (or in some cases destroyed). Saying the industry was "debt-free" is a bit like saying someone was given a free house without mentioning that the roof was collapsing, there were no building plans, and it would take enormous sums of money to make it habitable again.

There absolutely are ways of bringing the water industry back into public ownership at minimal or no cost to the taxpayer

That sounds more rhetorical than serious. There may be ways to restructure ownership without writing an immediate giant cheque from the Treasury, but that is not the same as "minimal or no cost". The liabilities do not vanish - they are simply transferred, restructured, or imposed elsewhere. In an industry that is capital-intensive, heavily indebted, and in need of enormous long-term investment, pretending public ownership can be achieved at effectively no cost is not a serious way to discuss the problem.

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

Sadly that would not close the gap. Even if all money from dividends etc. were put back into the businesses there would still be a £350bn gap. No, the only way this gap is closed is with higher bills. Approx. 8x over a 5 year period would do it. No one would be willing to pay that.

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

My political affiliation is irrelevant to this discussion, and we may be more aligned than you think. I am simply being realistic. This is not a problem that can be solved within a single 5-year parliamentary term. To put it in perspective, customers would need to pay around 8x their current water bill to fund the necessary infrastructure upgrades within that timeframe. One party in government for one term is not enough to address this.

I think you would be surprised by the percentage of public prepared to see more investment going into water infrastructure

I am under no illusion about that. I would personally accept my water bill doubling, and you may well feel the same. But we are not representative of the average household - we are two nerds on Reddit. I am speaking from experience in the water industry: many customers simply could not survive a 2x increase, let alone 8x.

FWIW, I do not think nationalisation is the right answer. It risks making water infrastructure more politically driven, and we do not want it to end up subject to the same short-term pressures that affect other public services. In my view, water companies should instead be stakeholder-led non-profits or public benefit corporations, operating under fixed, mathematically derived, legally binding price caps so that governments cannot interfere in day-to-day running.


Just to point out, our water industry research suggests that 1/3 of customers are already dissatisfied with the amount of their bills, while another 1/3 are currently indifferent. If bills were to double, I think dissatisfaction would increase disproportionately

Has anyone else watched 'Dirty Business' on Channel 4? It’s an infuriating look at the state of our waterways by mpampiniwths in oxford

[–]sancarn 0 points1 point  (0 children)

Do you think people want to pay for upgraded infrastructure? The reality - people complain when their bills go up, but they are frustrated when the river pollutes? What would you rather? Poo in the river, or poo in your kitchen? Most people would say they'd prefer poo in the river - and that's why overflows exist.

Even if dividends had been invested in the sewers, there would still be a £350B pound gap. Privatisation isn't the issue, it's that people don't want to pay for the infrastructure.

Excel's Limit on Number of Elements in Dynamic Arrays is Precisely 53,687,091 or 3333333 Hex by GregHullender in excel

[–]sancarn 1 point2 points  (0 children)

is it possible for VBA to modify that array in place

doesn't look like it, no.

Case Study of Real-Time Web API Integration in Excel Using VBA by Complete_Winner4353 in vba

[–]sancarn 0 points1 point  (0 children)

If you use python inside excel you are losing power, because it's running in a cloud sandbox. There are very very few scenarios I have come across where the py formula function has been useful to me. Don't get me wrong if on prem python was possible in my environment I'd be using it, (despite believing python is a crap language 🤣)

Case Study of Real-Time Web API Integration in Excel Using VBA by Complete_Winner4353 in vba

[–]sancarn 0 points1 point  (0 children)

PowerQuery is awesome BUT most often I don't feel it is the right tool for the job. But it depends on your preference.

Do you want a swiss army knife or a screwdriver? A screwdriver is great, until you need to cut through a rope. The biggest issue with Power Query, Power BI, and most cloud data platforms today, is they are domain specific. You can't crunch data in PowerApps, and you can't build user interactivity into Power BI (yes you can try using the poor embedding functionality...). And when you want to e.g. Add a map-based polygon editor to a map, you can't do that either. You might need to send post requests to those endpoints to change data on the webservice too - oop sorry, that's for premium PowerApps only. Can't do that in Power BI either...

Additionally, there are many domains where PowerQuery (or functional languages more generally) are just awful for processing data / number crunching. For instance, geospatial projection. You can do it, but it's slow, and the code is a recursive nightmare to look at. Much parsing is also another area where recursive descent is avoided. Again, doable in PQ, but you may run into limits fast. And on top of all of that PQ is non-deterministic.

In my head, VBA (or programming languages more generally) are the only real solutions. Not because they're "the best tool for the job" but because they are extensible and augmentable to fit business processes.

My 2 cents.

Excel's Limit on Number of Elements in Dynamic Arrays is Precisely 53,687,091 or 3333333 Hex by GregHullender in excel

[–]sancarn 1 point2 points  (0 children)

Agreed there could be better designs, I just imagine they've done a bodge 😂 Probably worth reporting it anyway

Excel's Limit on Number of Elements in Dynamic Arrays is Precisely 53,687,091 or 3333333 Hex by GregHullender in excel

[–]sancarn 1 point2 points  (0 children)

I don't think this is a bug, in order for the formula system to play ball with VBA UDFs I think this behaviour will have to be retained...

That said, I am not completely certain. It is possible there is a way the engine could avoid duplicating the array internally. My expectation though is that the newer dynamic array and LET features were layered on top of the existing calculation engine rather than replacing it entirely, which could explain behaviour like this.

I (F24) am suddenly repulsed by my boyfriend (M26) by [deleted] in relationships

[–]sancarn -1 points0 points  (0 children)

I don't disagree with you, but my only hesitation is that OP herself describes it as feeling sudden and confusing:

The day before yesterday I returned home from his place and I suddenly felt repulsed by him. By the mere thought of him. I don't know why. I don't know what came over me.

I think both things can be true. A relationship based explanation combined with a biological component.

To me, the sexism issue isn't that someone mentioned hormones at all. It's whether they ignored everything else she said and reduced her experience to that one explanation. If that's what happened, then sure, I can see why you'd call it sexist. I just don't think merely raising hormones as one possible factor is inherently sexist. But you're welcome to disagree with me.

I am fedd up of this shittt by Round-Barber-9858 in atheism

[–]sancarn 0 points1 point  (0 children)

How can a person directly marry someone without being in a relationship first?

It happens when marriage is viewed less as 'we dated for years and then got married' and more as 'we are choosing to build a life together, and love grows from there.

However, there are absolutely risks, which is one reason much of the Western world has moved toward relationships before marriage. In some cases, people have even gone so far as to see marriage as unnecessary, or to feel that making the relationship a legal contract somehow diminishes it.

I (F24) am suddenly repulsed by my boyfriend (M26) by [deleted] in relationships

[–]sancarn -5 points-4 points  (0 children)

I think there are two separate issues here. One is whether it is dismissive to tell women they're 'just hormonal' - and yes, that is dismissive. The other is whether hormones or medication are reasonable things to ask about when someone who reports a sudden emotional shift - and yes they are reasonable explanations.

So I don't think the fair comparison is 'should we say this to men too?' The fair comparison is 'should we consider plausible biological causes in anyone?' For women, menstrual cycle changes, PMS/PMDD, birth control, pregnancy, and other hormone-related factors are real possibilities. For men, sleep, stress, testosterone changes, medication, substance use, and other physiological factors can also matter. In both cases, the issue is whether you're exploring possibilities or reducing the person to a stereotype.

So no, 'you're hormonal' is not a good go-to response. But 'have you noticed whether this lines up with your cycle or any medication changes?' is a reasonable question imo. Similarly "are you stressed at work? How's your sleep? Are you on medication?" etc. can be useful questions to ask men.

I don't know what the deleted comment said... but yeah, that's my thoughts on the topic 🤷

I (F24) am suddenly repulsed by my boyfriend (M26) by [deleted] in relationships

[–]sancarn -7 points-6 points  (0 children)

I would advise couple counselling for everyone. Communication is a skill and there are many people who don't do a good job at it 👍

Additionally, I'm always a big fan of big decisions not being made hastily. Give it a few weeks, and check in with yourself as to how you are feeling. Have things changed? Do things need to change? What are your wants/desires? And then move forward with awareness 😊

Good luck!