Why I am a “late adopter” of virtually everything

June 20, 2014

Rant On.  100% ON.

I’m writing this post on a Lenovo Yoga 2 laptop that will be returned to Best Buy by the time you have read this.

Nothing but a nightmare.  Starts off with one of those improvements that we all love so much:

image

3200 Lines of Resolution, WOW!  So Why do I have it set at 1600???

Read the rest of this entry »


Holiday Bonus Post: Mobile Frame Zero!

December 24, 2013

Let’s Say You’re a Big Nerd…

…and you haven’t spent enough time with your kids over the past year.  Looking for a good way to spend many quality hours with the brood?

I give you…  Mobile Frame Zero.  (And if you’re not a big nerd, well, you may just want to stop reading right now).

image

A Game Where You Design and Build Your Own “War Mechs” Out of Legos?  Yes Please.
(My Mechs on Top.  My Son’s on Bottom.)

A 100% “Open Source” Mech Game That You Can Play for Free??

For nearly 30 years, I have been aware of games like Warhammer – epic tabletop nerd games – and wanted to at least try them.  But they are SUPER expensive.  You can rack up thousands of dollars buying the miniatures, and then spend forever painting them.  So, um, no.  I’ve stayed away.

But what about a mech game where you make your own miniatures out of Legos???  Pure freaking genius, especially considering that the people reading this post ALONE, in total, probably possess millions of unused Lego blocks.

Well, the creators of Mobile Frame Zero weren’t done there.  They also made their RULES free to download!  Optionally, you can choose to pay them $10 for the PDF, kinda like a donation.  Or you can buy a physical copy of the rulebook, like I did.  But they are VERY clear that they do NOT mind you downloading the game for free.  Put that together with the Legos you already have and you’re ready to play.  (Well, you need some dice too, but keep reading for a hookup).

Read the rest of this entry »


Mystery Pic = Washington Monument

November 11, 2013

 
image

Top of the Washington Monument (left), Excel 2013 Power Pivot Chart (Right)

imageMany of you guessed correctly in the comments on Friday, but just to make sure, yes, that was the Washington Monument.

My dad is managing the monument’s restoration project down in DC, which afford him all kinds of neat photo ops like that.

I love the picture for the whole “tip of the spear” vibe.  Which is where we all live these days, in the vanguard of Power Pivot adoption.

One of my friends and former colleagues on the Power Pivot team, Sasha Juric, is quite the creative type, and couldn’t resist “modeling” the picture in Excel 2013.

If you’d like to grab the workbook he used, it’s grabbable here.


Friday Bonus: Mystery Picture!

November 8, 2013

 
image

My Dad Took this Picture Today.  What Is It?
(Leave Guesses in Comments)


Friday Bonus: A Blog Stats “Whodunit?” (AKA “We Are Legion.”)

August 2, 2013

 
image

A Single Post (the “Cheese” Post About Power Pivot Being Removed From
Most Versions of Excel 2013) Had Its Best Day Ever Yesterday.  Why?

Yesterday I awoke to unusually high traffic on the site.  A single post – Who Moved My PowerPivot Cheese? – was going gangbusters.

What does “gangbusters” mean?  Well, for perspective, let’s check out the Mary Jo Foley Effect:

Read the rest of this entry »


Three Pictures: All Cool, Two Funny

July 24, 2013

 
Three pictures landed in my inbox in the past 24 hours that I just had to share Smile

1) Condoms Power???

image

Without a Doubt:  A Very Strange Superpower Indeed Smile

The author of this Power Pivot workbook has agreed to write a guest post in exchange for my assistance.  Let’s hope he follows through, because it’s a fascinating model in addition to having a funny sheet tab name.  In the end it’s a very serious subject regarding HIV prevention in the Pacific Islands.

2) Comprehensive Export Support

Read the rest of this entry »


A Swarm of Helpful People

July 1, 2013

 
Humans are just amazing.  We don’t survive on our own – even strangers come to your aid, by the dozen, and I am incredibly fortunate for that.

When I hurt myself last weekend, I just felt stupid.  I was laying there on this sea of trampolines, 100 feet from the stairs down, sweating, and unable to even straighten my right leg.  I might as well have been a thousand miles from the exit.  It’s a weird feeling – knowing, for certain, that if I were alone, I would eventually starve to death right in that spot.

My knee was basically disassembled into component parts, but the pain from that wasn’t so bad.  It was the helplessness that sucked.  The physical sense of helpless (described above) was only one part.  As an independent contractor in the process of launching a new enterprise, I had rolled the dice on temporarily going without health insurance.  This was uncharted territory for me – what exactly was going to happen now?  The System equates No Insurance with Cannot Pay For It.  I knew that I could afford it, but how do you get expensive help from people who don’t think you can pay?

Then the fire department and paramedics showed up.  Like ten guys.  Splinting my leg, moving me onto a stretcher board.  All while basically working in quicksand – trampolines aren’t the friendliest work surface.  I just kept apologizing – “guys I am so sorry to put you through this, but thank you.”  That, and make jokes.  Like “guys, I only signed up for an hour of trampoline time and now that it’s six o’clock I think this place is about to throw me out.”

Read the rest of this entry »


Memorial Day Musings: The Four Team Theory

May 28, 2013

 
image

We Typically Thought of the Cold War as a Struggle Between Two Opposing Teams.
But I Now Think There Were Actually Four Opposing Teams.
(and Four Teams in Every International Struggle – Past and Present)

Continuing a holiday tradition of sorts, tonight I thought I’d share a long-simmering, Off Topic thought.  Our regularly scheduled program of Excel, PowerPivot, BI, etc. resumes Thursday.

Let’s start with a movie quote, shall we?

“Why was the gun not loaded???”

image

In “Elizabeth:  The Golden Age,” Spain sends an assassin to shoot Queen Elizabeth of England.
He fires, but the gun was deliberately loaded with powder only – no bullet.  Why?

Here’s one of those movies that my wife watches while I type away on my laptop and only halfway pay attention.  But boy, did this sequence get my attention.

Read the rest of this entry »


My New “Recording Studio”

May 23, 2013

 

The Official PowerPivotPro Sound Booth
(Yes, all Good Sound Booths Have Primus Posters)

Even though today’s post is the first time you’ve seen a video from me in a long time, I’ve actually been doing quite a bit of video recording lately – stuff that pays the bills while I spin up my new (unannounced) company, and stuff that supports the launch of said company.

Recording some guest modules for Chandoo’s PowerPivot training course is one example of this (I am finishing those today, so for those of you who enrolled, look to see those show up sometime in the next week).

As part of this process I realized that I needed a better setup for sound.  A home recording studio on the cheap. 

It wasn’t that expensive, so I thought I’d share what I got:

Read the rest of this entry »


Heading Down to Uniontown (MrExcel HQ)!

May 10, 2013

 

image

Chandoo:  “It’s 46 miles to Uniontown, we’ve got a full tank of gas, half a stack of Excel books, it’s overcast, and we’re wearing sunglasses.”

Rob:  “Hit it.”

Hitting the Road.  Holding a Mini-Summit.

Chandoo and I are jumping in the car this afternoon for a short journey down I-77 to a place MrExcel calls home.  Well, at least, that’s where Bill lives and works today.  He is, sadly, moving to Florida this summer.  (The second friend of mine to leave Ohio for Florida since I moved here – traitors! Smile)

This is going to be fun, having the three of us in one place like this.  But I’m a little bummed that we couldn’t get a good picture of us sitting IN the car.  There was too much glare on the windshield.

Otherwise, we were prepared to re-enact this classic scene:

image

Me, Chandoo, and Bill in One Place?  Serious Stuff?  Maybe.

When a bunch of Excel “heavies” get together like this for a day, you might think the gathering looks like this:

image

Sometimes, that’s true.  But they just as often turn out more like the barbecue scene from Mystery Men:

image

I’m interested to see which way today goes Smile


Thanksgiving Weekend Bonus Post: The Cult of the Right Thing (and other Microsoft Cults)

November 26, 2012

 
image

This Vanity Fair Article Blames Microsoft’s Lost Decade on its Employee Review System -
I Hated that System But I Think the Real Problem Was Something Else

Continuing a bit of a tradition of more “reflective” holiday articles, today I thought I’d share some long-simmering thoughts on Microsoft, especially in light of various developments this year (including the recent departure of Steven Sinofsky).  Along the way I’m going to share some of my own experiences that I’ve been meaning to write about.  I think those will give my broader point some “flavor.”  This is a longish post and probably is better described as an “article.”  I think this topic, overall, is relevant to ANY professional enterprise, but the quality of my thoughts is for you to judge as always.

The Vanity Fair article above got a lot of attention this summer.  In it, the author exposes a culture of infighting and rivalries at Microsoft, and he attributes Microsoft’s past decade of struggles to that culture.  The article continues from there and attributes that culture to the performance review system, specifically the practice of “stack ranking.”

I disliked *both* the 2010 political environment at MS *and* the stack rank system, so when a colleague of mine told me about this article that linked two of my least-favorite things from Redmond, I had to buy the magazine and read the whole thing.  But before I share my opinion, we have to explain what stack ranking is.

Read the rest of this entry »


Monday Bonus: SalesForce Data Imported into PowerPivot Without Programming?

July 30, 2012

 
SalesForce.com data loaded into PowerPivot (No Special Skills Required)

SalesForce.com data loaded into PowerPivot (No Special Skills Required!)

This Whole Cloud Thing Just Might Catch On…

We live in pretty exciting times.  Sometimes it’s simply amazing what I can do from my desk, without having to take off my Excel hat.  All of these various technologies available to us in the cloud, plus PowerPivot’s ability to talk to them…  the net impact really starts to add up sometimes.

All of the Tables Available, Just Select and Click Finish

I didn’t have to do anything “technical” to pull this off really, I just end up using the PowerPivot import wizard:

Simple import of Salesforce.com data into PowerPivot, just select and click

Simple import of Salesforce.com data into PowerPivot, just select and click

What’s the Trick?

Read the rest of this entry »