Tasting Comparison of 3 sriracha brands: Lee Kum Kee, Saigon Sisters, and Sky Valley.
Yesterday we did Trader Joe’s, Lee Kum Kee and Saigon Sisters. Trader Joe’s as salty and not so spicy. Today, someone at Whole Foods was kind enough to give me a bottle of Sky Valley. Here is the tasting …
It had to be done! Review of 3 brands of sriracha. Lee Kum Kee is my favorite. It could be spicier but as a complete experience, it’s the clear winner.Please comment. Share your thoughts.
Ever wanted to draw in Excel? Highlight certain things?
The Inking feature allows you to do it.
(This grew out of a blogpost on monitoring the fundraising of a nonprofit. You can see it here: http://bit.ly/100nsKY )
Sometimes we want to see 2 very different bits of data in one graph. In this case, it helps to see the donation totals and the number of donations together.
In Excel lingo, we create a Secondary Axis.
What we get from this is evidence that the campaign is coasting to an end. Even though we saw a big jump in the donation dollars in July, the number of donation continues to trend downward. This tells us that 1 or 2 huge donors showed up in July.
We could see this by just looking at the numbers but it’s much easier to grasp with a visual.
Many of us have given out bad information about VLOOKUPS. We’ve said that VLOOKUP always starts its search at the top of our lookup array and it goes step-by-step until it finds the closest or exact match.
That’s called a Liner Search and that’s what happens when we want an exact match. We designate that by using ‘false’ in the formula.
When we want an approximate match, we use ‘true’ and the VLOOKUP does a BINARY SEARCH. In that, the search starts in the middle of the list, eliminates half, then hops to the middle of the remaining half … eliminating chunks of the list until there is either:
1. and exact match
2. 1 choice left, or
3. an error
I detail this in the video.
—
For my annotation I use
1. Microsoft’s Snipper Tool
2. Bamboo’s pen & tablet
A travel agent presented this challenge because she was always struggling when a client wanted to go on a trip to a specific destination but when she’d look it up, the client either didn’t have enough money or didn’t have enough time.
She asks:
“We always know the time needed and the budget for each destination. Can I use Excel to look at the budget and time available first, then pick from the remaining destinations.”
YES!
Here is an Excel 2013 solution using Slicers with Tables.
Excel VBA code programmed to estimate the next result of selling a stock based on Current price, estimated purchase date, number of shares, estimated tax exposure.
The script goes online to retrieve the current stock price, the stock price from the estimated purchase date, and calculates the estimated net
Oz shows how to tie a bowtie and reminds gentlemen that clip-on and pre-tied bowties are unacceptable if you’re over 12 years old.
Unfortunately, good self-tie bow ties are hard to find. Many of mine were custom made. The other were found on eBay.