Excel Tip: Copy Subtotal (Aggregate) Data Only

Have you ever used Excel’s subtotal functionality?  It’s great for counting things.  For instance, I’m running some tests right now, where the output is a sequence.  If I run the test 10,000 times, then I have 10,000 sequences.  I want to know how many times each sequence happens.  I copy the output into Excel, then …

Ornamental Decoration in 17th Century France

Jean Le Pautre (Lepautre or Lepaultre) (1618-1682) has been described as the most important ornament engraver of the 17th century. His prodigious output extended to more than 2000 prints, mostly from his own original designs. He was not only the originator of the grandiose Louis XIV style but was also responsible for disseminating and popularising …

But, you could eat a bagel or donut?

The other evening while out with neighbors for dinner I mentioned that I had pork chops for breakfast the day before. Her response: I couldn’t eat a pork chop for breakfast. So, have a look at my breakfast. Would you rather eat breakfast cereal, a donut or a bagel like she does? She does struggle …

A “Healthy” Doctor Runner with Heart Disease

Following on the Salazar post on marathoners is another less dramatic story, but with the same plot: Excessive Running. The doctor who looked the picture of health and was a runner was expected to ace his treadmill stress test. Yet, he flunked and was found to have calcified arteries Hidden Heart Disease. Note that by …