正在加载视频...

视频加载失败

返回首页

Difference Between SWITCH & IFS Function in MS #Excel =SWITCH(Measure,B6,C6,B7,C7,B8,C8,"Not Found!") =IFERROR(IFS(Measure=B6,C6,Measure=B7,C7,Measure=B8,C8),"Not Found!") =XLOOKUP(Measure,B6:B8,C6:C8,"Not Found!") =FILTER(C6:C8,B6:B8=Measure,"Not Found!")

ExcelBasement's profile picture

Excel Basement

33,450 subscribers

76,213 次观看 • 3 年前 •via X (Twitter)

#Excel
LIVE

Anya Rossi• Live Now

Private livecam show

0 条评论

暂无评论

原始帖子的评论将显示在这里

相关视频

Alex Palou on the five-point penalty from Indianapolis where his front wing was found to have failed the rule that the front wing must not measure less than 8.300 inches when set at any angle. INDYCAR on FOX
2:55

Alex Palou on the five-point penalty from Indianapolis where his front wing was found to have failed the rule that the front wing must not measure less than 8.300 inches when set at any angle. INDYCAR on FOX

Bob Pockrass

76,201 次观看 • 3 个月前

I'm not trying to formula-shame mothers who can't provide breast milk for their babies. I just found this pasteurized milk vs mother's milk comparison fascinating. While cow's milk of any kind doesn't measure up to mother's milk, it's arguably better than common formula.
1:39

I'm not trying to formula-shame mothers who can't provide breast milk for their babies. I just found this pasteurized milk vs mother's milk comparison fascinating. While cow's milk of any kind doesn't measure up to mother's milk, it's arguably better than common formula.

Cary Kelly

48,380 次观看 • 8 个月前

Why Kendrick Lamar can’t lose at anything. When you humble yourself in front of everybody and God, publicly say, I AM NOT YOUR SAVIOR, and hand the crown 👑 you never asked for back was the ultimate Ego Death. Understand no matter what , he is blessed beyond measure. He’s unshakable because he found solitude in peace and community, not material wealth and aesthetics. There is no comparison. UNDERSTAND THAT.
2:59

Why Kendrick Lamar can’t lose at anything. When you humble yourself in front of everybody and God, publicly say, I AM NOT YOUR SAVIOR, and hand the crown 👑 you never asked for back was the ultimate Ego Death. Understand no matter what , he is blessed beyond measure. He’s unshakable because he found solitude in peace and community, not material wealth and aesthetics. There is no comparison. UNDERSTAND THAT.

CrumbleBastard

12,976 次观看 • 3 个月前

Watch as National Grid UK chomps through a hedge. In nesting season. Despite its DCO stating “”In accordance with good practice measure B02, vegetation with the potential to support breeding birds will be programmed to be removed outside of breeding bird season (March to August inclusive) where practicable”. So why was it not practicable not to do it in this instance?The ecologist found nothing (what a surprise) but there is no way a hedge like this does not have nesting birds. (This is Bramford to Twinstead, not Norwich to Tilbury) Essex Suffolk Norfolk Pylons
0:56

Watch as National Grid UK chomps through a hedge. In nesting season. Despite its DCO stating “”In accordance with good practice measure B02, vegetation with the potential to support breeding birds will be programmed to be removed outside of breeding bird season (March to August inclusive) where practicable”. So why was it not practicable not to do it in this instance?The ecologist found nothing (what a surprise) but there is no way a hedge like this does not have nesting birds. (This is Bramford to Twinstead, not Norwich to Tilbury) Essex Suffolk Norfolk Pylons

Rosie P 🦇 🦎 🕷️ 🦭 🐌 🍃🌳🚲💧

104,005 次观看 • 3 个月前

[WATCH] “My comments were directed at the Auditor-General’s reports. In some areas, the AG has found that there are municipalities with clean audits, and these are duly cited. However, what she has consistently emphasized publicly is that while municipalities in the Western Cape may have clean audits, clean audits do not necessarily mean clean streets. They also do not equate to effective governance. In Khayelitsha, Delft, Philippi, and Kayamandi, DA-run municipalities continue to fail on housing, sanitation, safety, and several other service delivery challenges faced by our people. For the ANC, the true measure of success is not limited to balance sheets, it is also reflected in the lived realities of our communities.” #LeadUsRamaphosa #LocalGovernmentStability
3:58

[WATCH] “My comments were directed at the Auditor-General’s reports. In some areas, the AG has found that there are municipalities with clean audits, and these are duly cited. However, what she has consistently emphasized publicly is that while municipalities in the Western Cape may have clean audits, clean audits do not necessarily mean clean streets. They also do not equate to effective governance. In Khayelitsha, Delft, Philippi, and Kayamandi, DA-run municipalities continue to fail on housing, sanitation, safety, and several other service delivery challenges faced by our people. For the ANC, the true measure of success is not limited to balance sheets, it is also reflected in the lived realities of our communities.” #LeadUsRamaphosa #LocalGovernmentStability

ANC SECRETARY GENERAL | Fikile Mbalula

34,581 次观看 • 11 个月前

🚨 Press secretary Karoline Leavitt just had her first mainstream media takedown just 10 minutes into the first WH press briefing. LEAVITT: [Temporary funding freeze] is a responsible measure. Biden's administration spent money like a drunken sailor. REPORTER: Why impose the pause with little notice? Why not give them time to plan? LEAVITT: There was notice. It was the executive order the president signed. This administration is taking into considering how hard Americans work and give their tax dollars. DOGE and OMB found $37M that was about to go to the World Health Organization. They also found $50M about to go to fund condoms in Gaza. That is a preposterous waste of money.
1:32

🚨 Press secretary Karoline Leavitt just had her first mainstream media takedown just 10 minutes into the first WH press briefing. LEAVITT: [Temporary funding freeze] is a responsible measure. Biden's administration spent money like a drunken sailor. REPORTER: Why impose the pause with little notice? Why not give them time to plan? LEAVITT: There was notice. It was the executive order the president signed. This administration is taking into considering how hard Americans work and give their tax dollars. DOGE and OMB found $37M that was about to go to the World Health Organization. They also found $50M about to go to fund condoms in Gaza. That is a preposterous waste of money.

Eric Daugherty

4,920,887 次观看 • 1 年前

"In sickness and in health" isn't just a line you say once and tuck away, it's the part that proves everything else was real. Finding the right person isn't about who shows up when life is easy, when the sun's out and the road is smooth. It's about the one who pulls up a chair when things get quiet and heavy... who stays when the laughter fades, when the doctor's words hit harder than expected, when strength feels hard to come by. It's the hand that doesn't let go when yours trembles. The voice that softens when yours grows tired. The steady presence that says, without needing big speeches, "I'm still here." The right person won't measure love by convenience or comfort. They'll measure it in moments, long nights, small sacrifices, shared silence, and the quiet promise to face whatever comes, side by side. That's how you know you've found them... Not just in the good times, but in the ones that test everything. In sickness and in health, those aren't just words. They're the proof you chose right. 💛
1:02

"In sickness and in health" isn't just a line you say once and tuck away, it's the part that proves everything else was real. Finding the right person isn't about who shows up when life is easy, when the sun's out and the road is smooth. It's about the one who pulls up a chair when things get quiet and heavy... who stays when the laughter fades, when the doctor's words hit harder than expected, when strength feels hard to come by. It's the hand that doesn't let go when yours trembles. The voice that softens when yours grows tired. The steady presence that says, without needing big speeches, "I'm still here." The right person won't measure love by convenience or comfort. They'll measure it in moments, long nights, small sacrifices, shared silence, and the quiet promise to face whatever comes, side by side. That's how you know you've found them... Not just in the good times, but in the ones that test everything. In sickness and in health, those aren't just words. They're the proof you chose right. 💛

G-MA & G-PA

318,223 次观看 • 3 个月前

Nicole Shanahan: “The power of an Independent movement is to endorse ideas, not people” “I’m not a Kamala Democrat, nor am I a Trump Republican. I am an Independent American laser focused on the issues. What we did on Friday was amazing. We crossed the chasm. We found somebody who was willing to put these ideas on center stage. Millions of people for the first time heard Bobby’s voice. Millions of people are starting to acknowledge how big of an issue the chronic disease crisis is in this country. This is not a fringe issue anymore, Bobby is not a fringe person. He had almost 30,000 people on Friday shouting his name. President Trump, to his credit, put out a hand, shook his hand and said let’s do this. Let’s engage on ideas that matter. We don’t have to agree on everything, this is not us being absorbed into the Trump camp by any measure. This is a partnership.” From NewsNation
1:23

Nicole Shanahan: “The power of an Independent movement is to endorse ideas, not people” “I’m not a Kamala Democrat, nor am I a Trump Republican. I am an Independent American laser focused on the issues. What we did on Friday was amazing. We crossed the chasm. We found somebody who was willing to put these ideas on center stage. Millions of people for the first time heard Bobby’s voice. Millions of people are starting to acknowledge how big of an issue the chronic disease crisis is in this country. This is not a fringe issue anymore, Bobby is not a fringe person. He had almost 30,000 people on Friday shouting his name. President Trump, to his credit, put out a hand, shook his hand and said let’s do this. Let’s engage on ideas that matter. We don’t have to agree on everything, this is not us being absorbed into the Trump camp by any measure. This is a partnership.” From NewsNation

Holden Culotta

217,264 次观看 • 2 年前

Chelloor Mahadeva temple, Malappuram: Update. After death of Chief Priest in temple pond, followed by other omens, the worship at this ancient temple has been stopped temporarily. The police investigation and inquest has concluded that death is by drowning. This is second known death by drowning in the temple pond. The presence of a very powerful and fierce Goddess Bhadrakali is evident in the temple, who is not worshiped now. Also certain vastu errors has been found in earlier restorations done. The temple is thousands of years old and in the category of Mahakshethra. UgraNarasimha Charitable Trust will revive the temple, following all rituals and as per temple vastu shastra. As a first measure Devaprashnam will be held by senior Kerala astrologers. #ReclaimTemples #KL022
0:42

Chelloor Mahadeva temple, Malappuram: Update. After death of Chief Priest in temple pond, followed by other omens, the worship at this ancient temple has been stopped temporarily. The police investigation and inquest has concluded that death is by drowning. This is second known death by drowning in the temple pond. The presence of a very powerful and fierce Goddess Bhadrakali is evident in the temple, who is not worshiped now. Also certain vastu errors has been found in earlier restorations done. The temple is thousands of years old and in the category of Mahakshethra. UgraNarasimha Charitable Trust will revive the temple, following all rituals and as per temple vastu shastra. As a first measure Devaprashnam will be held by senior Kerala astrologers. #ReclaimTemples #KL022

Reclaim Temples

17,817 次观看 • 4 个月前

This is crazy. Here are 2 fields, - One is natural grass - The other is artificial turf If you take a temperature gun and measure the temperature the grass field is 104 degrees. The artificial grass is 178 degrees “Which field do you want your kids playing on? Not to mention the smell, the reek of burning plastic. It is so disgusting” We have to stop with everything being synthetic and go back to natural I found that artificial turf can routinely get extremely hot on sunny days, often reaching 180°F The “reek of burning plastic” comes from the plastic blades polyethylene, polypropylene and rubber heating up and off-gassing For reference touching something that’s 180 degrees can cause a severe second degree burn
2:18

This is crazy. Here are 2 fields, - One is natural grass - The other is artificial turf If you take a temperature gun and measure the temperature the grass field is 104 degrees. The artificial grass is 178 degrees “Which field do you want your kids playing on? Not to mention the smell, the reek of burning plastic. It is so disgusting” We have to stop with everything being synthetic and go back to natural I found that artificial turf can routinely get extremely hot on sunny days, often reaching 180°F The “reek of burning plastic” comes from the plastic blades polyethylene, polypropylene and rubber heating up and off-gassing For reference touching something that’s 180 degrees can cause a severe second degree burn

Wall Street Apes

93,133 次观看 • 2 个月前

One of the world’s most experienced brain-imaging psychiatrists dropped a bombshell on Tucker Carlson’s show. Dr. Daniel Amen (80,000+ brain scans in his career) revealed the results of his published study on 1,000 regular cannabis users vs healthy controls: → Every single region of the brain showed significantly lower blood flow and activity on SPECT imaging → The same scans also measure mitochondrial function (the energy factories inside your cells) — and those were dramatically lower too → A brand-new 2024 study from an completely independent research group on another 1,000 young cannabis users found the exact same pattern, especially in the brain areas responsible for learning and memory This isn’t opinion. These are measurable, published findings from two separate teams using advanced brain imaging. Whether you use cannabis or not, the science is worth knowing. Watch the 1:55 clip below — Dr. Amen explains it clearly and calmly.
1:55

One of the world’s most experienced brain-imaging psychiatrists dropped a bombshell on Tucker Carlson’s show. Dr. Daniel Amen (80,000+ brain scans in his career) revealed the results of his published study on 1,000 regular cannabis users vs healthy controls: → Every single region of the brain showed significantly lower blood flow and activity on SPECT imaging → The same scans also measure mitochondrial function (the energy factories inside your cells) — and those were dramatically lower too → A brand-new 2024 study from an completely independent research group on another 1,000 young cannabis users found the exact same pattern, especially in the brain areas responsible for learning and memory This isn’t opinion. These are measurable, published findings from two separate teams using advanced brain imaging. Whether you use cannabis or not, the science is worth knowing. Watch the 1:55 clip below — Dr. Amen explains it clearly and calmly.

Camus

184,977 次观看 • 8 个月前

Steve Jobs: The difference between good people and great people is 50-to-1 “I’ve always considered part of my job was to keep the quality level of people in the organizations I work with very high. I mean that’s what I consider one of the few things I can contribute individually myself — versus the team that work with — is to really try to instill in the organization the goal of having only A players.” Steve argues this is especially important in technology where there’s a huge range between the best person and the worst person: “In a lot of fields, the difference between, say, the worst taxicab driver and the best taxicab driver to get you across town in Manhattan might be 2-to-1. The best one will get you there in 15 minutes, the worst one will get you there in half an hour… Or the best cook and the worst cook, maybe it’s 3-to-1… But in the field that I’m in. In software in particular. The difference between the best person and the worst person is about 100-to-1 or more.” He continues: “The difference between a good software person and a great software person is probably 50-to-1 or 25-to-1. Huge dynamic range. And therefore, I have found — and not just in software but in almost everything I’ve done — it really pays to go after the best people in the world.” But as Steve points out, this isn’t always easy: “It’s very painful when you have some people that are not the best people in the world, and you have to get rid of them. But I’ve found that my job has sometimes been exactly that, to get rid of some of the people that didn’t measure up. And I’ve always tried to do it in a humane way, but nonetheless it has to be done and it’s not ever fun.”
1:53

Steve Jobs: The difference between good people and great people is 50-to-1 “I’ve always considered part of my job was to keep the quality level of people in the organizations I work with very high. I mean that’s what I consider one of the few things I can contribute individually myself — versus the team that work with — is to really try to instill in the organization the goal of having only A players.” Steve argues this is especially important in technology where there’s a huge range between the best person and the worst person: “In a lot of fields, the difference between, say, the worst taxicab driver and the best taxicab driver to get you across town in Manhattan might be 2-to-1. The best one will get you there in 15 minutes, the worst one will get you there in half an hour… Or the best cook and the worst cook, maybe it’s 3-to-1… But in the field that I’m in. In software in particular. The difference between the best person and the worst person is about 100-to-1 or more.” He continues: “The difference between a good software person and a great software person is probably 50-to-1 or 25-to-1. Huge dynamic range. And therefore, I have found — and not just in software but in almost everything I’ve done — it really pays to go after the best people in the world.” But as Steve points out, this isn’t always easy: “It’s very painful when you have some people that are not the best people in the world, and you have to get rid of them. But I’ve found that my job has sometimes been exactly that, to get rid of some of the people that didn’t measure up. And I’ve always tried to do it in a humane way, but nonetheless it has to be done and it’s not ever fun.”

Startup Archive

45,180 次观看 • 7 个月前

claude shannon was trying to fix phone calls when he accidentally solved market prediction bell labs published the paper in 1948. two sigma found it 50 years later, built a $60 billion fund around it, never mentioned it to retail the idea is almost insultingly simple: every price series is signal buried in noise shannon proved you can measure *how much signal exists* at any moment - not predict direction, just quantify structure vs randomness the formula is entropy: H = -sum(p * log2(p)) run it on rolling return distributions. outputs a number between 0 and 1 H above 0.7 = noise. random walk. stay out H below 0.35 = structure detected. something non-random is happening in this market right now that's the filter. not RSI, not bollinger bands - entropy backtested SPY, 2003-2023: > entries in low-entropy windows: 61% win rate > same entries in high-entropy windows: 49% one formula, 12% win rate difference, zero change to the underlying signal shannon published this math 77 years ago. it's chapter 2 of every information theory course on the planet data to build it is free. the python is 40 lines Bookmark this before you scroll past they spent decades keeping you staring at lagging indicators while they were measuring the information content of the exact same price data you've always had
0:30

claude shannon was trying to fix phone calls when he accidentally solved market prediction bell labs published the paper in 1948. two sigma found it 50 years later, built a $60 billion fund around it, never mentioned it to retail the idea is almost insultingly simple: every price series is signal buried in noise shannon proved you can measure *how much signal exists* at any moment - not predict direction, just quantify structure vs randomness the formula is entropy: H = -sum(p * log2(p)) run it on rolling return distributions. outputs a number between 0 and 1 H above 0.7 = noise. random walk. stay out H below 0.35 = structure detected. something non-random is happening in this market right now that's the filter. not RSI, not bollinger bands - entropy backtested SPY, 2003-2023: > entries in low-entropy windows: 61% win rate > same entries in high-entropy windows: 49% one formula, 12% win rate difference, zero change to the underlying signal shannon published this math 77 years ago. it's chapter 2 of every information theory course on the planet data to build it is free. the python is 40 lines Bookmark this before you scroll past they spent decades keeping you staring at lagging indicators while they were measuring the information content of the exact same price data you've always had

Livsun

109,820 次观看 • 5 天前

“COVID misinformation.” “Conspiracy theories,” they said. #13 – Repeated COVID shots weaken the immune system #12 – Ivermectin worked! #11 – The unvaccinated were scapegoated for failure of COVID vaccines #10 – Mask wearers paradoxically had an increased risk of contracting COVID. #9 – Natural immunity proves to be seven times more protective #8 – Ivermectin, is now showing 15 anti-cancer mechanisms of action. #7 – Hospitals murdered COVID patients. #6 – New-found emails prove Biden White House hid COVID-19 vaccine harms from the public. #5 – The COVID shots were not the only toxic measure forced on humanity. #4 – Nearly 1 in 3 COVID vaccine recipients suffered neurological side effects. #3 – Research finds heart anomalies within 48 hours after the COVID-19 shot. #2 – Pfizer hid nearly 80% of COVID-19 vaccine trial deaths from regulators in order to qualify for Emergency Use Authorization. #1 – Perverse brainwashing techniques Ryan Cole
2:31

“COVID misinformation.” “Conspiracy theories,” they said. #13 – Repeated COVID shots weaken the immune system #12 – Ivermectin worked! #11 – The unvaccinated were scapegoated for failure of COVID vaccines #10 – Mask wearers paradoxically had an increased risk of contracting COVID. #9 – Natural immunity proves to be seven times more protective #8 – Ivermectin, is now showing 15 anti-cancer mechanisms of action. #7 – Hospitals murdered COVID patients. #6 – New-found emails prove Biden White House hid COVID-19 vaccine harms from the public. #5 – The COVID shots were not the only toxic measure forced on humanity. #4 – Nearly 1 in 3 COVID vaccine recipients suffered neurological side effects. #3 – Research finds heart anomalies within 48 hours after the COVID-19 shot. #2 – Pfizer hid nearly 80% of COVID-19 vaccine trial deaths from regulators in order to qualify for Emergency Use Authorization. #1 – Perverse brainwashing techniques Ryan Cole

Dr Dave Cartland BMedSc MBChB Ex-MRCGP

352,799 次观看 • 2 年前

✅If you can do around 40 consecutive push-ups, it’s a strong indicator of good fitness and a much lower risk of heart attack or stroke A study published in JAMA Network Open (2019) involved over 1,000 male firefighters. Here’s what it found: 1. Men who could complete more than 40 push-ups in a single attempt had a 96% lower risk of heart disease events (heart attack, stroke, or cardiac arrest) over 10 years compared with those who could do fewer than 10. 2. The push-up test was a simple measure of overall fitness, particularly upper-body strength and cardiovascular endurance. 3. Push-up capacity correlated strongly with aerobic fitness (VO₂ max), a key predictor of heart health. Important caveats: 1. The study included middle-aged men (mean age ~40) who were physically active firefighters, not the general population. 2. It shows association, not causation: Being fit enough to do 40 push-ups reflects good cardiovascular fitness, which lowers heart disease risk. 3. The protective effect comes from the fitness level and not the push-ups themselves. (VC: Dr Jacob George)
1:04

✅If you can do around 40 consecutive push-ups, it’s a strong indicator of good fitness and a much lower risk of heart attack or stroke A study published in JAMA Network Open (2019) involved over 1,000 male firefighters. Here’s what it found: 1. Men who could complete more than 40 push-ups in a single attempt had a 96% lower risk of heart disease events (heart attack, stroke, or cardiac arrest) over 10 years compared with those who could do fewer than 10. 2. The push-up test was a simple measure of overall fitness, particularly upper-body strength and cardiovascular endurance. 3. Push-up capacity correlated strongly with aerobic fitness (VO₂ max), a key predictor of heart health. Important caveats: 1. The study included middle-aged men (mean age ~40) who were physically active firefighters, not the general population. 2. It shows association, not causation: Being fit enough to do 40 push-ups reflects good cardiovascular fitness, which lowers heart disease risk. 3. The protective effect comes from the fitness level and not the push-ups themselves. (VC: Dr Jacob George)

Dr Sudhir Kumar MD DM

48,880 次观看 • 10 个月前

“I’m never late. I’m never frenzied. If you’re frenzied, it’s YOU.” In my 30 years in business I've worked directly with hundreds of entrepreneurs & C-level execs, several self-made billionaires, and even a few icons. What I observed—which may seem counterintuitive to some—is: 👉The most effective people aren't "busy". They have plenty of time for all the important things. They don't rush from one thing to the next. It's not because they have less complicated lives than the rest of us. It's exactly the opposite—*because* they have massive demands on their time, they’re RUTHLESS about these 5 things (they're all simple, but not easy): 1) Focus on a few important things 2) Say no to unimportant things 3) Set boundaries (and don’t compromise them) 4) Measure output, not input (results, not effort) 5) Recognize the importance of free time Just listen to Jeff Bezos in his prime (pun intended): "I get up early, I go to bed early, and I like to putter in the morning. My puttering time is very important to me—that's why I set my first meeting for 10am." If you feel busy and frantic, the problem and the solution are found in the same place—the mirror. 🫵 (h/t Amanda Orson for the inspo — she’s a good follow!)
2:39

“I’m never late. I’m never frenzied. If you’re frenzied, it’s YOU.” In my 30 years in business I've worked directly with hundreds of entrepreneurs & C-level execs, several self-made billionaires, and even a few icons. What I observed—which may seem counterintuitive to some—is: 👉The most effective people aren't "busy". They have plenty of time for all the important things. They don't rush from one thing to the next. It's not because they have less complicated lives than the rest of us. It's exactly the opposite—*because* they have massive demands on their time, they’re RUTHLESS about these 5 things (they're all simple, but not easy): 1) Focus on a few important things 2) Say no to unimportant things 3) Set boundaries (and don’t compromise them) 4) Measure output, not input (results, not effort) 5) Recognize the importance of free time Just listen to Jeff Bezos in his prime (pun intended): "I get up early, I go to bed early, and I like to putter in the morning. My puttering time is very important to me—that's why I set my first meeting for 10am." If you feel busy and frantic, the problem and the solution are found in the same place—the mirror. 🫵 (h/t Amanda Orson for the inspo — she’s a good follow!)

Kevin Dahlstrom

921,573 次观看 • 2 年前

The Government of Zimbabwe intends to introduce a Statutory Instrument prohibiting medical aid societies from owning medical service providers such as clinics and pharmacies. Beyond being anti “open for business,” this move risks decimating the medical insurance sector in the same way policy and monetary instability destroyed confidence in the pension sector. The real problem is not vertical integration by medical aid societies. The real problem is hyperinflation, currency instability and the collapse of confidence in our monetary system. Medical insurance has simply found a way to work around that dysfunction. The proposed SI will likely lead to a sharp increase in medical fees and it is customers who will suffer most. The doctors and pharmacists lobbying for this measure are being anti-business and ultimately, acting against their own long-term interests. A better response would be for them to come together and establish medical aid societies that can rival the existing players. If we destroy medical aid societies, customers will not suddenly rush to private doctors and pharmacies. Many will simply stop using formal doctors and pharmacies altogether, as we have seen in parts of Africa where medical aid systems collapsed.
2:32

The Government of Zimbabwe intends to introduce a Statutory Instrument prohibiting medical aid societies from owning medical service providers such as clinics and pharmacies. Beyond being anti “open for business,” this move risks decimating the medical insurance sector in the same way policy and monetary instability destroyed confidence in the pension sector. The real problem is not vertical integration by medical aid societies. The real problem is hyperinflation, currency instability and the collapse of confidence in our monetary system. Medical insurance has simply found a way to work around that dysfunction. The proposed SI will likely lead to a sharp increase in medical fees and it is customers who will suffer most. The doctors and pharmacists lobbying for this measure are being anti-business and ultimately, acting against their own long-term interests. A better response would be for them to come together and establish medical aid societies that can rival the existing players. If we destroy medical aid societies, customers will not suddenly rush to private doctors and pharmacies. Many will simply stop using formal doctors and pharmacies altogether, as we have seen in parts of Africa where medical aid systems collapsed.

Tinashe

36,972 次观看 • 4 个月前

Bach’s Prelude in C Minor, BWV 999: When the Direction Is Set from the First Note A master archer does not determine the arrow’s flight at the moment the string is released. By then, nearly everything has already been decided. The aim has been fixed. The bow has been drawn. The force has been gathered. When the arrow leaves the bow, it simply completes what was prepared long before. Bach’s Prelude in C Minor, BWV 999, unfolds in the same way. At first hearing, the piece appears to change very little. Bach maintains almost the same arpeggiated pattern throughout—each chord’s notes sounded in succession according to a single, unbroken figuration from beginning to end. The rhythm remains steady, the motion continuous, and there are no passages of technical display. Yet when the music ends, the listener senses that they have been carried to a place entirely different from where they began. This transformation does not come from a striking melody. It arises from the way Bach orders the chords themselves. In this Prelude, no chord simply appears and disappears. Each one quietly prepares the ground for the chord that follows, much as the archer draws the bowstring a little farther with every small movement. Each action readies the next. From the opening measures, Bach therefore establishes not only a destination but a living chain of relationships among the chords. Everything that comes afterward is no longer arbitrary; it is the natural consequence of what has already taken place. That is why the music carries an unbroken sense of forward motion, even while its surface remains almost unchanged. The work begins in C minor, a key whose color is dark and inwardly unsettled. Bach does not create tension through sudden leaps or sharp contrasts. Instead, he lets the bass move by the smallest steps while the arpeggio pattern continues without interruption. Each change is so slight that, heard in isolation, it seems almost insignificant. Yet when the steps are joined, each one adds a further measure of tension. It is like the archer drawing the bowstring by degrees—without any dramatic gesture—storing energy for the release that must eventually come. Near measure 11, new colors begin to appear, most notably the Neapolitan chord on D-flat. The listener does not need to know its name to feel what it does. From this point the forward impulse already set in motion grows stronger still. The music does not turn aside; it simply draws the string tighter. The most remarkable passage lies at the center of the Prelude. From measure 13 to measure 33, Bach holds a single D in the bass for twenty-one measures while the chords above continue to change. On the surface the music seems to slow. In truth, this is the moment when the archer has drawn the bow to its fullest extent and now holds the posture firm. He has not released. He has not relaxed. While the bass note D remains motionless, every new chord above adds one more increment of tension. The entire energy of the work is held, gathered, and compressed. The listener may not be able to name what is happening, yet feels the music approaching a point that can no longer be delayed. This is not a stopping. It is the ripening of force. And then the moment comes. In the final measure the G-major chord sounds like the release of the bowstring. Nothing about it feels sudden, for the whole preceding process has been leading to this single instant. The closing chord is not an idea introduced at the last moment; it is the inevitable fruit of the chain of relationships established from the first measure. Yet Bach does not let the arrow fall. Instead of returning to C minor, he ends on a half cadence upon G major. The causal sequence he has built is therefore left open. The arrow has left the string, but the listener is not shown where it lands. The energy of the entire Prelude continues its flight beyond the final note. This is Bach’s particular mastery. He does not generate development through large turning points, but through an absolute inner order. Each chord grows out of the one before it and, at the same time, prepares the one that follows. It is this chain of causality that gives the Prelude its feeling of being at once entirely natural and entirely necessary. By the end, the listener does not feel that Bach has chosen a conclusion. They feel that the music could not have ended any other way. Perhaps this principle is not confined to music alone. An arrow does not reach its mark through the instant of release. Its path was decided the moment the archer set the aim and then held that aim steady through every stage of the draw. A single small deviation, and all the force so carefully stored loses its meaning. It is the same with human life. Once a person has found a goal worthy of pursuit, what matters most is no longer the moments of sudden inspiration, but the quiet capacity to remain faithful to the direction already chosen. Each small decision, each time one resists the urge to turn aside, each step taken even when the outcome is not yet visible—these are like drawing the bowstring a little farther. Taken one by one they may seem of little consequence, yet over time they accumulate into the strength that carries a person toward the goal. Perhaps this, too, is what Bach placed within Prelude BWV 999. From the very first note he established both a destination and the chain of relationships that would lead to it. Every chord remained true to the direction set at the beginning. It is this steadfastness that makes the final chord feel not like chance, but like necessity. And just as the arrow keeps flying after it has left the bow, Bach closes the Prelude on an open harmony—as if to remind us that once the direction has been set, the journey continues onward. One may hear Bach’s Prelude in C Minor, BWV 999 performed by David Tayler on the archlute. With the instrument’s warm, resonant voice, the Prelude’s quiet architecture comes into clear relief, allowing each harmony to unfold with unhurried clarity and revealing the quiet necessity of every step in Bach’s musical design.
2:07

Bach’s Prelude in C Minor, BWV 999: When the Direction Is Set from the First Note A master archer does not determine the arrow’s flight at the moment the string is released. By then, nearly everything has already been decided. The aim has been fixed. The bow has been drawn. The force has been gathered. When the arrow leaves the bow, it simply completes what was prepared long before. Bach’s Prelude in C Minor, BWV 999, unfolds in the same way. At first hearing, the piece appears to change very little. Bach maintains almost the same arpeggiated pattern throughout—each chord’s notes sounded in succession according to a single, unbroken figuration from beginning to end. The rhythm remains steady, the motion continuous, and there are no passages of technical display. Yet when the music ends, the listener senses that they have been carried to a place entirely different from where they began. This transformation does not come from a striking melody. It arises from the way Bach orders the chords themselves. In this Prelude, no chord simply appears and disappears. Each one quietly prepares the ground for the chord that follows, much as the archer draws the bowstring a little farther with every small movement. Each action readies the next. From the opening measures, Bach therefore establishes not only a destination but a living chain of relationships among the chords. Everything that comes afterward is no longer arbitrary; it is the natural consequence of what has already taken place. That is why the music carries an unbroken sense of forward motion, even while its surface remains almost unchanged. The work begins in C minor, a key whose color is dark and inwardly unsettled. Bach does not create tension through sudden leaps or sharp contrasts. Instead, he lets the bass move by the smallest steps while the arpeggio pattern continues without interruption. Each change is so slight that, heard in isolation, it seems almost insignificant. Yet when the steps are joined, each one adds a further measure of tension. It is like the archer drawing the bowstring by degrees—without any dramatic gesture—storing energy for the release that must eventually come. Near measure 11, new colors begin to appear, most notably the Neapolitan chord on D-flat. The listener does not need to know its name to feel what it does. From this point the forward impulse already set in motion grows stronger still. The music does not turn aside; it simply draws the string tighter. The most remarkable passage lies at the center of the Prelude. From measure 13 to measure 33, Bach holds a single D in the bass for twenty-one measures while the chords above continue to change. On the surface the music seems to slow. In truth, this is the moment when the archer has drawn the bow to its fullest extent and now holds the posture firm. He has not released. He has not relaxed. While the bass note D remains motionless, every new chord above adds one more increment of tension. The entire energy of the work is held, gathered, and compressed. The listener may not be able to name what is happening, yet feels the music approaching a point that can no longer be delayed. This is not a stopping. It is the ripening of force. And then the moment comes. In the final measure the G-major chord sounds like the release of the bowstring. Nothing about it feels sudden, for the whole preceding process has been leading to this single instant. The closing chord is not an idea introduced at the last moment; it is the inevitable fruit of the chain of relationships established from the first measure. Yet Bach does not let the arrow fall. Instead of returning to C minor, he ends on a half cadence upon G major. The causal sequence he has built is therefore left open. The arrow has left the string, but the listener is not shown where it lands. The energy of the entire Prelude continues its flight beyond the final note. This is Bach’s particular mastery. He does not generate development through large turning points, but through an absolute inner order. Each chord grows out of the one before it and, at the same time, prepares the one that follows. It is this chain of causality that gives the Prelude its feeling of being at once entirely natural and entirely necessary. By the end, the listener does not feel that Bach has chosen a conclusion. They feel that the music could not have ended any other way. Perhaps this principle is not confined to music alone. An arrow does not reach its mark through the instant of release. Its path was decided the moment the archer set the aim and then held that aim steady through every stage of the draw. A single small deviation, and all the force so carefully stored loses its meaning. It is the same with human life. Once a person has found a goal worthy of pursuit, what matters most is no longer the moments of sudden inspiration, but the quiet capacity to remain faithful to the direction already chosen. Each small decision, each time one resists the urge to turn aside, each step taken even when the outcome is not yet visible—these are like drawing the bowstring a little farther. Taken one by one they may seem of little consequence, yet over time they accumulate into the strength that carries a person toward the goal. Perhaps this, too, is what Bach placed within Prelude BWV 999. From the very first note he established both a destination and the chain of relationships that would lead to it. Every chord remained true to the direction set at the beginning. It is this steadfastness that makes the final chord feel not like chance, but like necessity. And just as the arrow keeps flying after it has left the bow, Bach closes the Prelude on an open harmony—as if to remind us that once the direction has been set, the journey continues onward. One may hear Bach’s Prelude in C Minor, BWV 999 performed by David Tayler on the archlute. With the instrument’s warm, resonant voice, the Prelude’s quiet architecture comes into clear relief, allowing each harmony to unfold with unhurried clarity and revealing the quiet necessity of every step in Bach’s musical design.

🌸🎵 Beautiful Melody 🎶💖

17,329 次观看 • 1 个月前