View profile

The Monday 6 - April 12, 2021

Kyle Petzinger
Kyle Petzinger
Hi there, friend.
I’m now 5 days post 2nd shot (Pfizer) and am happy to report virtually zero symptoms following the jab.
I continue to be optimistic and hopeful for a fun summer.
Onto this week’s 6:

1. Newish Excel Function: XLOOKUP
My favorite Excel formula (what, you don’t have a favorite?) is definitely SUMIFS, but VLOOKUP is pretty high up on the list as well. However, VLOOKUP kind of sucks. The combo of INDEX + MATCH gets around some of the deficiencies, but it’s not very intuitive.
Behold XLOOKUP.
XLOOKUP gets around several of the limitations of VLOOKUP (including the ability also to replace HLOOKUP) with less confusion than INDEX + MATCH.
You need a newer version of Office 365 to enjoy. Still, I’ve already replaced all my VLOOKUP, HLOOKUP, and INDEX + MATCH functions with it.
Source: support.microsoft.com
Source: support.microsoft.com
XLOOKUP function - Office Support
2. Better Task Prioritization: The Eisenhower Matrix
I’ve learned if I don’t filter or prioritize my tasks at work, I end up wasting time on less important tasks, missing deadlines, or not meeting my obligations.
To help combat this, I’ve (loosely) adopted the Eisenhower Matrix (evidently invented by the former President and General) to organize myself, prioritize the important tasks, and get stuff done.
The concept is based on assign the following 2 attributes:
  1. How important is the task? AKA, does it really need to be done?
  2. How urgent is the task? AKA, when does the task need completing?
From there, you map every task against this 2x2 (from Eisenhower.me):
Source: Eisenhower.me
Source: Eisenhower.me
I need to improve on not doing the things in the red and orange categories, but c'est la vie.
I try to take the last 15 minutes of each day to map out my tasks for the next day in this matrix, and it has been quite helpful.
The Eisenhower Matrix: Introduction & 3-Minute Video Tutorial
3. Dynamic RGB TV Backlight
I think this is just fun.
We have a Roku Smart TV and, consequently, no longer have any HDMI input devices plugged in. I’ve wanted one of these behind-the-tv lights, but the problem is, the best device on the market (Philips Hue Play HDMI Sync Box) only works if you have something plugged in.
However, I found these Govee RGB LED lights that have a camera capturing what’s onscreen to match the colors of the lights behind.
It works pretty well!
If you plug your smart TV device (Apple TV, Roku, Fire Stick, etc.) into your TV, the Hue HDMI Sync Box is probably the better (albeit more expensive) option, but this is a pretty good alternative.
Check it out:
Mulan 2 is not a good movie.
Mulan 2 is not a good movie.
Govee Immersion WiFi TV RGB LED Backlights with Camera
4. Turn Non-Soft Close Cabinets Into Soft-Close Cabinets
This sub-$50 purchase is one of the best I’ve made in a long time.
Our cabinets in our kitchen are of good quality, but they’re old. We painted them when we moved in, but they’ve always closed loudly and harshly.
After installing these soft-close cabinet door dampers, however, all our doors close smoothly and quietly. Much cheaper than buying all new cabinets!
Here's where they install. Source. Amazon.com
Here's where they install. Source. Amazon.com
It takes 1 screw per damper, and I was able to outfit our whole kitchen with 15+ cabinet doors in about half an hour. You can tweak the tension and/or add two dampers for large doors.
Note: it does not work on drawers, unfortunately. 😢
Rok Hardware 25 Pack Soft Close Damper for Cabinet Doors
5. Excellent Primer on Performance Marketing
This podcast episode does as good a job as I’ve ever had at exploring what performance marketing is, how it is used, and how to position it in a business. I haven’t heard of Jesse Pujji before this interview, but his explanations are articulate and cogent.
Even with my 10+ years in the industry, I still found this episode to be helpful.
If you’re curious about what I do for a living and want to see how performance marketing is the lifeblood of many organizations, give it a listen.
As an aside, Patrick is a phenomenal interviewer, and I recommend checking out the full back catalog as well.
Invest Like the Best with Patrick O'Shaughnessy
6. Dew Point > Humidity
Quiz: Which of these would feel more humid?
  1. 100° F at 32% relative humidity
  2. 62° F at 70% relative humidity
Leading question alert: it’s #1.
Unless you understand the relationship between temperature and relative humidity (explained well in this video), understanding how humid it feels is hard to pinpoint.
Enter dew point. Defined here as:
The dew point is the temperature the air needs to be cooled to (at constant pressure) in order to achieve a relative humidity (RH) of 100%. At this point the air cannot hold more water in the gas form. If the air were to be cooled even more, water vapor would have to come out of the atmosphere in the liquid form, usually as fog or precipitation.
So cool, I barely understood that either, but the tl;dr is: dew point is the measure for how humid it feels, which is all anyone really cares about.
So when deciding what to pack, look at the forecasted dew point at your destination instead of humidity. If the dew point is <60° F, you’re looking 😎.
Here is a handy cheat sheet:
Source: WeatherWorks
Source: WeatherWorks
That’s it! Let me know if you’ve found any of these useful or interesting. Have a great week!
Did you enjoy this issue? Yes No
Kyle Petzinger
Kyle Petzinger @kylepetz

Every Monday, you'll receive the 6 articles, podcasts, tools, products, and more that I found interesting that past week.

If you don't want these updates anymore, please unsubscribe here.
If you were forwarded this newsletter and you like it, you can subscribe here.
Created with Revue by Twitter.