Loading...
Home2017-05-16T14:51:11-07:00

Categories

Archives

3Dec 2018

Business Value QuadArrow

December 3rd, 2018|Categories: Best Practices, Marketing, Strategy|Comments Off on Business Value QuadArrow

“What’s the Business Value?”

This is one of the most important questions I hear often.  Businesses large and small, new and mature, want to best understand how they can maximize the value they deliver to others, such as their customers.  The question really includes not only how much value, but where and to whom within an organization.  For example:

  • Marketing and sales people want to communicate ROI (return on investment) for buying their products over alternatives.
  • Early stage startup founders seeking product-market-fit want to know who values their new offering the most.
  • Large enterprises considering a company-wide switch to a new software […]
5Apr 2018

URL Decode formula for Excel

April 5th, 2018|Categories: Microsoft Excel|Comments Off on URL Decode formula for Excel

Excel provides a EncodeURL() function to encode URLs, but surprisingly does not provide any function to decode a URL (e.g., DecodeURL or UnencodeURL).  Instead, you can use the following formula:

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(CELL_CONTAINING_ENCODEDURL,"%3F","?"),"%20"," "),"%25", "%"),"%26","&"),"%3D","="),"%7B","{"),"%7D","}"),"%5B","["),"%5D","]"),"%3A",":"),"%22","""")

Replace CELL_CONTAINING_ENCODEDURL with cell address containing the encoded URL.

Please let me know if I’ve missed any codes and I’ll update the formula.

Thanks to Christi Olson for providing basis of the formula.  I completed it with some missing pieces.
28Nov 2017

Why You Should Choose Photographers Who Will Provide RAW Images

November 28th, 2017|Categories: Photography|Comments Off on Why You Should Choose Photographers Who Will Provide RAW Images

I’m an advanced hobby photographer.  I take lots of photos of my family, but alas, am rarely in any myself.  Occasionally, I’d like to hire a professional photographer to take family photos.  But I don’t need them to edit the photos because I’m experienced at editing.  In fact, because photos are such valuable personal memories, I’ll spend more time and effort editing photos of my family than any pro photographer would find cost effective.  But to edit quality photos properly, you should start with original RAW images.  These are like having the negatives back in film days.

However, I’m baffled how […]

14May 2017

6 Document Collaboration Methods…Compared

May 14th, 2017|Categories: Collaboration, Email, Knowledge Management|Comments Off on 6 Document Collaboration Methods…Compared

Do you collaborate on documents with co-workers? I.e., do you edit the same doc or file (I use “docs” and “files” interchangeably herein) with one or more people sometimes?

Duh, who doesn’t, right?

Unless your company has strict policies, you probably have some options on how you share documents. You could use browser-based apps like Google Docs or Microsoft OfficeOnline. Or you could email file attachments around.

(I can’t believe I’m still writing about email file attachments for doc collab; but alas, status quo is hard to change.)

Different users have different preferences and different […]

Go to Top