Spreadsheet Hell

Relationships (fortunately not mine) are complicated. As I have ears that hear everything... I now know a colleague of mine is trying to negotiate the finances of her child vis a vis a spreadsheet. That is one complicated relationship. It involves college tuition, child support and an ex. She has exclaimed, "I am in spreadsheet hell." Who isn't? I thought this was a fairly good analogy for complicated relationships--- trying to resolve emotional conflicts through logical steps, efficiently and fairly. Does not work out well.
My spouse is dealing with the conflict of a friend that is no more and a friend that soon shall no longer exist. Friend A has simply grown into a person that Jack no longer has anything in common with. Friend B is dying. The (d)evolution of friendship A is logically expected --- people change (or don't) and expectations are no longer in sync. It sucks but it is logical. Friendship B involves a smart person stupidly deciding (consciously or subconsciously) that a diabetes diagnosis should result in a death sentence - due to gross negligence. This is far more difficult to deal with. We are talking major spreadsheet hell. You feel shitty because your friend will be dead soon and angry because it could have been avoided but it is too late now for could haves. It does not logically follow. Someone's inability to care for himself -- decisions made emotionally are wreaking havoc on the physical and metaphysical realms. The anger, frustration, and helplessness are waging battle with feelings of affection and sorrow.