excel

Intention = Better Improvement

When people ask me what they can do to move up in their career I ask them
what they got better at this past year. Oftentimes, the answer is a blank
stare.

There are certain things we get better at with just routine and repetition.
Back in my teenage years, I got pretty sick at spinning a pizza in the air or
backing in a car while working as a valet. Reps were enough to get you most of
the way to greatness.

At a higher level, in most professional settings, fewer tasks get better
with muscle memory. Instead, it’s the personal toolkit that needs to be grown.
And the only way to grow the toolkit is via intentionality. Showing up is
essential, but not enough on its own.

The onus is on us to do the work to identify skills and know-how that can
contribute to the team’s success. Then we have to go out and get them; no one
is going to tell us or push us to improve. The good news is it’s easier than
ever before. We can perform brain surgery with eight hours of prep time and
YouTube if we wanted to.

What skills can you acquire this year that will transform your effectiveness
and grow your abilities and confidence?

p.s. If you’re a regular user of Excel, I can’t recommend the Index/Match formula enough. It’s insanely helpful and only takes a few minutes to master if you put your mind to it.

Hat tip to my buddy at CultishCreative.com for inspiration this morning.

Auto-Calculating Carpet Loss of Life Excel Build

Yeah, it sounds like a mouthful, but you get it. With 2500+ bedrooms, anything we can do to make mundane tasks faster is a life saver, so we’re always looking for ways to make our lives easier (see our Mission Statement post).

Below is a sample shot of a feature I added to our Excel Turn board where we’ve loaded the last replacement date for every carpet in the community and it will give us a bill-back amount we should charge the previous resident (if at all) when we schedule a new replacement. Just enter the new replacement date and voila!

CarpetLossOfLife

We track our current carpet on a five year life span, but I’ve seen commercial grade products that may have a 7-8 life span. The cool part is we can change the total calculations by manipulating the price we pay for carpet up top on the page, or the life span if we switch to a stronger carpet and it will adjust all future calculations. Cool, right?

The other exciting aspect of this is we’re far more guaranteed to insure we’re properly charging back for this common loss and we can cross reference the totals for carpet bill-backs from our turn board with our budget’s actual charges to insure we didn’t miss anything.

Total build time was around three hours and another 2-3 hours of inputting the last known carpet replacement dates for each unit. Note: this was made slightly easier than usual as the entire property got new carpets during renovations in 2011, so not every single unit needed data input, we just assumed 2011 unless we’d had an invoice since then.