Saturday, January 4, 2020

Algorithm vs. Function

Algorithm is a set of instructions. It is a series of steps (or process) for performing a calculation. 

Function is an implementation of an algorithm. It is the mathematical relationship between inputs and outputs.

Thursday, December 5, 2019

Concatenate Text in Google Sheets ("Combine Text" from multiple cells)

GOAL:  Concatenate Text in Google Sheets ("Combine Text" from multiple cells)

Use the symbol

   & combines text
   + combines numbers for formulas

   " " allows you to add spaces or characters or other words between text

EXAMPLE:  =A1&" "&B1

A1 =Josh
B1 =Wentz
C1 =A1&" "&C2

Output: Josh Wentz


Sunday, December 1, 2019

Mac Folder Directory (Search/Jump/Go To)

GOAL: Search or Jump To or Go To a specific folder directory in Mac.


1. Finder app

2. Shift + Command + G


Go > "Go to Folder..."

Spotify "Import iTunes Playlists" (for Matching/Mirroring Nested Playlists)

GOAL:  Import iTunes Playlists into Spotify.  Match iTunes playlists with Spotify playlists.  Ensure that nested playlists (hierarchies) are mirrored between Spotify and iTunes.  Links below are specifically for Mac.

PROBLEM:  Spotify removed the feature to "Import iTunes Playlists" around Feb 2018.


1. Download an older version of Spotify (either link below works)

2. Install

3. File > Import Playlists > iTunes

NOTE: This DOES NOT import iTunes "Smart Playlists."  Spotify unfortunately never supported this feature. You'll have to copy your "Smart Playlists" into normal "Playlists" in iTunes prior to importing in Spotify.

Local Files Not Matching, 2018-10-13
Importing iTunes Playlists, 2018-02-19
Import iTunes Playlists - Sharing from iTunes, 2017-02-14
Local Files Matching & "Unlink tracks" action, 2014-01-24

Saturday, May 11, 2019

Google Voice "Voicemail to Text" Setting is Disabled / Grayed Out

PROBLEM:  The Google Voice "voicemail to text" or "Get voicemail via message" setting is Disabled / Grayed Out.

  1.  > "3 lines" (in upper left corner)  >  "Legacy Google Voice"
  2. [From "Legacy Google Voice"]  >  Gear icon (in upper right corner) > Settings
  3. "Edit" button under the number
  4. Change the phone type/category to "Mobile"
  5. Save
  6. > Gear icon (in upper right corner)
  7. Get voicemail via message > Turn On (slider now works)

Your phone needs to be recategorized as a "Mobile" number.  The "voicemail to text message" setting is likely disabled / grayed out because it's currently categorized as a "Home" land-line number.

Google recently changed the way linked/forwarding telephone numbers are added to a Google Voice configuration.  
  • If you add a phone telephone number via using the mobile Google Voice app, it will classify that number as a mobile number, which can receive forwarded text messages.
  • If you add a phone number via the Google Voice web page user interface (UI) at, then it will classify the number as a land line, which cannot receive text messages, so the text forwarding check boxes will be grayed-out.
Steps to find the "Legacy Google Voice Settings".

Friday, April 26, 2019

WiFi / VPN Issues on Mac (refresh settings!)

PROBLEM:  There are issues connecting to WiFi or VPN on your Mac.


1. Open Terminal app

2. sudo route flush 

Saturday, January 26, 2019

Download / Export All Photos from Evernote Folder

GOAL:  Download or export all photos from an Evernote folder to your Mac desktop.


1. Open your offline Evernote Mac desktop app.  If you don't already have it, download it here

2. Navigate to the Evernote folder you want to export photos from.

3. Select the notes that have the desired photos. 

  • Multiple Notes:  "Shift" + select multiple notes
  • All Notes:  Command + A
4. File > "Save Attachments to Folder..."

5. Select or create the destination export folder.

6. Save

RESULT:  Now all photos (PNG, JPG, etc) from your selected Evernote notes are extracted into an offline folder.

Friday, November 2, 2018

JIRA Shortcut: Search for any command

GOAL: Search for a certain command or field in JIRA.


Just press: "."

Tap the "period" button, that's all, and a JIRA search box will show.

Open Vector in Google Slides on Mac

Goal:  Open a vector file (illustrator or sketch or .EMF) in Google Slides on a Mac. 


1. Find your vector online ( - OR - Create your vector (Illustrator or Sketch)

2. Convert your vector to .EMF ( - OR - Save/Export your vector as .EMF

3. Download "Open Office" (

In Open Office:

4. Open the newly downloaded app "Open Office"

5. Insert > Picture > From file... > select your .EMF file

6. Right click on imported picture (EMF) > select "Break"

7. File > Save as > .PPT

In Google Slides:

8. File > Import slides... > Upload tab > select your new .PPT

9. Select your vector slide.  Your vector is now in a Google Slide!

Sunday, September 24, 2017

Open Recently Closed Tab in Chrome (Mac)

KEYBOARD SHORTCUT to open recently closed tab in Google Chrome for Mac.

Command Shift T

Screenshot with Mac

GOAL:  Screenshot a portion of the page with Mac.

PART of the screen:  Command Shift 4

FULL screen:  Command Shift 3

Send to CLIPBOARD:  Shift Control Command 4

Force Quit an App

GOAL:  Force quit an app that is not loading.  Shortcuts below...

Command + Option + Esc

Control + Alt + Delete

Tuesday, February 7, 2017

Slack Shortcut: Search for a Person or Group

Search for a particular person or group or channel in Slack with a keyboard shortcut.  This shortcut is specific to Mac.


Command + K

Monday, October 17, 2016

Digitize Your Handwriting into a Font

GOAL:  Digitize your handwriting and turn it into a font.  Made possible by


1.  Print this template and fill out all of the squares with a black marker.

2. Scan it as a Photo (at 300 dpi) in grayscale, not color.  Save as JPG.

3. Upload the JPG, PNG, or PDF template to

4. Choose .TTF file format + Download

5. Mac Steps: Go to Apps > Font Book

6. Drag & drop your .TTF file into the Font Book App

Now, open up Word and use your new font!

Friday, October 7, 2016

Copy Unique Values in Google Sheets

Copy unique values from one column to another column in Google Sheets (or Excel).



A1:A10 is the range of cells you hope to narrow to only unique values

Column A:
Column B: Use this formula:
and get the following:

Wednesday, September 7, 2016

Hover Text for HTML

GOAL:  Add "hover text" when a mouse hovers over a certain word in an HTML webpage.  

<p title="Hover Text"> Word <p>



Hover over the "Word" above to see "Hover Text".  This is a very simple way of adding hover text using a native part of HTML:  the title attribute.  Note: You can use the "title" attribute with HTML text tags beyond <p> tag, such as <h1>, <h2>, <h3>.

Tuesday, September 6, 2016

Find Color Code of an Image on your Screen

GOAL:  Figure out the color code of something on your desktop screen so that you can use / reference that color in another app or site.  


1. Download Color Picker App from Mac App Store

2. Open App & Click "Magnifying Glass" Button

3. Select the colored pixel on your screen that you'd like to reference

4. Copy HEX Code & Paste into another app or webpage

This post is specific to MAC.  It can also be helpful for: 
- Finding a color to use when coding webpages
- Finding a color to use on a Google Slide

Monday, August 29, 2016

Cyberduck Permission Denied (Upload Failed in GUI, but not Terminal)

Cyberduck "Upload Failed" in the Mac GUI.  Permission denied.

Update Cyberduck to the latest version

Cyberduck > Check for updates...


Editing a file in the Cyberduck Graphical User Interface (GUI) resulted in "Upload Failed.  Permission Denied. Please contact your web hosting service provider for assistance.

Editing that same file through terminal in nano threw no permissions errors.

Specific to:

  • Mac
  • Cyberduck

Monday, May 2, 2016

Keynote Slides: Print Each Page of the Animation

GOAL:  Print each slide of a Keynote, including each step of all animations.

STEPS inside of Keynote

1. File
2. Export To > PDF...
3. Click the checkbox: "Print each stage of builds"

4. Next...
5. Export / Save
6. Open that PDF & Print

Monday, January 18, 2016

Youtube Link to a Specific Time

GOAL:  Send a link to a specific time in a youtube video.


1.  Add  #t=10m11s  after your link

                 t = time, m = minutes, s = seconds

2.  Example: 

This jumps the person opening the link to that exact minute and second of the video.

Upload Audiobook to Audible

GOAL:  Import or Upload an audiobook from a CD or MP3 to the Audible App.


  1. Create an iTunes playlist called "Audiobooks"
  2. When syncing your iPhone to your computer:
    • Inside of the sync settings > under Book:Audiobooks
    • Select checkbox to sync books from that "Audiobooks" playlist
    • When iPhone is synced, the audiobooks transfer from your computer to your phone
  3. A new iTunes tab now automatically pops up in the "Audible" app

Friday, December 11, 2015

Re-Enable Widgets Dashboard in Mac El Capitan

GOAL:  Enable the widgets dashboard in Mac El Capitan.  Apple disabled by default, but the widgets can be re-enabled with steps below.


1.  System Preferences

2.  Mission Control

3.  Dashboard dropdown:  choose "As Space"

The furthest left most desktop will now show your widgets dashboard.  Example:

Thursday, September 10, 2015

Fix Gray Exclamation Point Triangle in Gmail

PROBLEM:  Gray exclamation point triangle is showing up in the middle of Gmail.

1.  Setting gear  ( top right ) > Themes
2.  Select another theme

Close Tab in Google Chrome [Keyboard Shortcut]

Command + w

Closes tab directly with keyboard, without clicking the X in Chrome.
Specifically for Mac & Chrome.

Google Calendar: Keyboard shortcut to Save Event

GOAL:  Save a Google Calendar event from the details page with a keyboard shortcut.  

Command + s

This command saves this page without clicking:

Specifically for Mac & Chrome.

Sunday, August 2, 2015

BOOTCAMP missing from Finder in Mac OSX

PROBLEM:  BOOTCAMP is not showing up in Finder.  This is often after using the Bootcamp partition through your Windows Virtual Machine in Parallels Desktop or VMware.


1. Search for the app:  Disk Utility

2.  Click on "BOOTCAMP" on left side panel (which is likely grayed out)

3.  Click "Mount" (at top)

4.  BOOTCAMP now shows up inside of Finder

Monday, June 22, 2015

Format JSON in Chrome

GOAL:  Format JSON files inside of Chrome.  Flat JSON files can often be really tough to scan through.  This will add hierarchy and color formatting to any JSON inside of Chrome.


1.  JSONView: download from chrome web store

2.  + Add to Chrome > Checking... > Add

3.  Open JSON File (in Chrome) and view the hierarchical / colored formatting

Wednesday, April 22, 2015

Download Facebook Photo Album to Mac

GOAL:  Download all photos from 1 album in Facebook.  For Google Chrome & Mac specifically.


1.  From Chrome > Open link to Download FB Album mod (chrome extension)

2.  "Add to Chrome"

3.  Go to your Facebook Album of photos to download

4.  Look for Facebook icon in URL bar & Click on it:

5. On pop-up > click blue "Normal" button

Note:  the chrome extension creates a custom webpage full of the photos from your one FB album.  Below, we'll save this webpage and all of its photos to your desktop.

6.  From this newly created webpage, type: Command + S

7.  Save As: Facebook-Album.html.  Format: Webpage, Complete.  Click "Save"

8.  The html & photos from that facebook webpage are now on your desktop in the Facebook-Album_files folder.

9.  Copy photos from the folder created on your desktop to your Mac Pictures folder of interest.

Thursday, February 26, 2015

Change Image on Select Dropdown HTML+JS

GOAL:  Switch out an image on a webpage based off of a select dropdown option. [HTML + JavaScript]

<select onchange="$('#imageToSwap').attr('src', this.options[this.selectedIndex].value);">
    <option value="           49940.jpg" selected>Facebook</option>
    <option value=" 
    <option value="     logo-of-photo-camera_318-64651.jpg">Instagram</option>

<img id="imageToSwap" class="profile" src="">

See the Pen Change Image on Select Dropdown by Josh Wentz (@joshwentz) on CodePen.

Thursday, February 12, 2015

Compress Large PDF Files for Emailing [Mac]

PROBLEM:  PDF file is too large to email.
GOAL:  Compress large PowerPoint / Keynote files so that they can be easily emailed.


1. In Mac, Open the "Preview" app

  • This process compresses the images in the document. The compressed images look the same as the originals when viewed onscreen, but they may be of lower quality when printed.

2.  Open the large PDF document

3.  File > Export...

4.  Quartz Filter dropdown:  change from None to "Reduce File Size"

5.  Save a document as a PDF file

Tuesday, January 20, 2015

Gmail: Move Email Back to Inbox

PROBLEM:  There does not seem to be a button in gmail to move an email back to inbox after removing the inbox label or archiving it.


1.  In your browser URL, change  #inbox  to  #all

2.  Enter to refresh page

3.  "Move to Inbox" button will now show up

Wednesday, November 12, 2014

Computer Time Jargon: Unix Epoch, UTC, GMT

Computers represent TIME with many words that have similar meaning.  It creates a wall of words to climb before understanding.

UNIX Time = UNIX Epoch Time = Epoch Time = POSIX Time 

  • the number of seconds since 1/1/1970, the year Unix was born 
    • Unix computers count the time in seconds since its official "birthday," -- called "epoch" in computing terms -- which is Jan. 1, 1970.  
    • Unix engineers needed to set a uniform date for the start of computing time, and New Year's Day, 1970, the same year they started developing it, seemed most convenient.
    • Linux follows the same tradition. [Reference]
    • Years < 1970 are negative
  • Timezone it represents ALWAYS equals UTC = Universal Time = GMT [Reference]
  • More Jargon:
    • Epoch = reference point from which time is measured
    • POSIX = Portable Operating System Interface.  These are the standards that Unix and Linux were built upon.
UTC = Coordinated Universal Time = GMT = Greenwich Mean Time

  • Timezones around the world are expressed as positive or negative offsets from UTC.


#Wall.Of.Words #computing

Friday, October 17, 2014

Checkboxes: Check All or None on Webpage

GOAL:  Repeat checkbox multi-select similar to Google Docs and Gmail for editing multiple items in JavaScript / jQuery.

$('input:checkbox').attr('checked', true);
$('input:checkbox').attr('checked', false);

Thursday, September 11, 2014

"Save as Image" PNG/JPEG in Keynote [for Mac]

GOAL:  Save image in Keynote as a PNG, JPEG, PDF, or TIFF.


1.  Copy Image in Keynote

2.  Open Preview App

3.  File > New from Clipboard

4.  Desired image should now be opened

5.  File > Save... > Choose Format > OK

Crop Image in Mac Keynote

PROBLEM:  Cannot find "Crop" or crop icon anywhere in Keynote.


1.  Click Image

2.  Format > Image > Edit Mask

3.  Crop button now shown.  Adjust to desired size.

4.  Done


Tuesday, July 15, 2014

iframe Part of a Webpage

Scrape a part of a webpage onto another.

iframe + disable scroll + adjust margins + set width/height

<iframe src="" scrolling="no" style="height: 280px; width: 619px; margin-top: -220px; margin-left: -230px; border: 0px none;"></iframe>

Scraped Example of World Population Website

This will work as long as the webpage doesn't re-arrange content.  Debated between an iframe or jquery to scrape a certain element.  Accessing with jquery ended in permission error:

Tuesday, June 24, 2014

Mac App Can't Be Opened Because Unidentified Developer [Fix]

Can't be opened because it is from an unidentified developer (often from a newly downloaded app from the internet).  Only OK shows in the pop-up and there is no way to Open.


1.  Applications folder

2.  Right Click on App

3.  Open

4.  Pop-up now shows "Open" button.  Click "Open" to use the app.

Friday, May 30, 2014

Revit Origin

GOAL: find the origin (0,0,0) of a Revit 3D Building Model

  1. Double Click "Level 1"
  2. "View" Tab
  3. Visibility / Graphics
  4. + Site
  5. Check "Project Base Point" & Survey Point
  6. Apply
  7. OK

Origin will now show in red.

Specific to Revit 2012.  No guarantees past this.

Wednesday, May 28, 2014

Server Jargon: Memory vs. Storage

The memory and storage are separate pieces of hardware from the processor (described here) also on the motherboard of a computer or server.

Memory = RAM = Random Access Memory
  • Short Term Memory
  • Physically: a thin metal & plastic board

Storage = Disk Space = Hard Drive (HD) = Solid State Drive (SSD)
  • Long Term Memory
  • Physically: a small metal box

WOW.  If you're a server beginner, this is another Wall Of Words you have to climb.
I'm not a computer engineer, just a software developer.  This is my understanding as of May 2014.


Server Jargon: Processor vs. Core vs. Thread

A thread is inside of a core which is inside a processor which sits in a socket on a motherboard of a computer or server.  WOW.  If you're a server beginner, this is one of the Wall Of Words you have to climb.

Processor = CPU = Central Processing Unit
  • Physically:  a tiny metal board with circuits and nano-sized wiring that sits inside of a "socket" on the "motherboard".
    • Socket = the slot the processor sits in on the "motherboard"
    • Motherboard = PCB = Printed Circuit Board for a computer/server
      • 2014 Support:  only 2 sockets / slots are in a motherboard
  • Sized by:  
    • Clock Speed = # calculations in 1 second before degrading (measured in 1million+ cycles/second, MHz or GHz)

Core = a processor inside of a processor
  • Physically: a small black box inside the processor
  • 2014 Support:  2-4 cores can fit inside a processor

Thread = a process = 1 terminal command
  • Physically:  No, thread's don't exist physically.  This is an abstracted OperatingSystem / Software concept.  Certain software languages can only run 1 thread at a time.
  • 2014 Support:  2 threads can run inside a core

I'm not a computer engineer, just a software developer.  This is my understanding as of May 2014.


Thursday, May 22, 2014

Reduce File Size of Image

  2. Open image from computer > Browse for image
  3. File > Save...
  4. Format:  JPEG
  5. Adjust Quality dial & see resulting Size (KB) at bottom
    6.  OK
    7.  Choose where you want the image downloaded to

Free Online Alternative to Photoshop

Pixlr is a free, online, web app alternative to Adobe Photoshop...

It can perform many of the basic functions of Photoshop such as:
  • resizing images
  • setting a transparent background
  • deleting chunks of the image with magic wand
  • converting to JPEG, PNG, BMP, TIFF
  • adjusting the color or grayscale, etc.  
It's all FREE and doesn't require any installs.

Friday, May 2, 2014

Bootstrap #id href Link Covered by Nav Bar [Fixed]

< h1 id="output" style="padding-top:40px; margin-top:-40px;">

this does not create extra space in content & href to #output now jumps down to this anchor without the top nav bar (default in twitter bootstrap) covering the title up.  no change needed for the href="#output" tag at top.



Thursday, May 1, 2014

OpenSSL Bug Fix for Ubuntu Linux 12.04 by Bitnami

The OpenSSL Heartbleed Bug affected the majority of the internet in early April 2013.  If you haven't patched your ubuntu server yet...

built on: Tue Jun  4 07:26:06 UTC 2013
(or anything earlier than Apr 7 2014 is vulnerable to the OpenSSL Bug)
OpenSSL 1.0.1 14 Mar 2012 does not matter [reference], only the "built on" date.

built on: Mon Apr  7 20:33:29 UTC 2014

sudo apt-get update 
sudo apt-get upgrade
(note: upgrade does not change your ubuntu version)

1. wget 
2. chmod +x ./

3. sudo ./ --mode text


Bitnami creates custom builds of Ubuntu to make the setup easier for developers.  

Disk Space Tool for Ubuntu Linux Server

Find out the breakdown of which files/folders are taking up the most room on your computer / server through command line / terminal.
sudo apt-get install gt5

from the directory you want to analyze:

Ctrl + Z

Ubuntu Linux 12.04


Forward Penn State Email to Gmail

  1. Change your forwarding address (here)
  2. Sign In 
  3. Change

Friday, April 18, 2014

Shortcut Top/Bottom of Page in Chrome for MacOSX

Top of Page
FN + LEFT arrow 
or CMD + UP arrow

Bottom of Page
FN + RIGHT arrow 
or CMD + DOWN arrow

Chrome Web Browser on MacBook OSX
Small Keyboard without right Number Keypad

Wednesday, April 16, 2014

Google Maps Autocomplete

As a user types in an address, Google Maps attempts to auto-complete so the user can see all locations in the world that match the entered address.  It ultimately saves the user time so they only have to enter the start of the address.

All JavaScript & HTML in one file here:


Live Web App:

Code here


Thursday, April 10, 2014

Fix "Cannot find module OpenStudio" for Node.js Bindings on Ubuntu Linux

ERROR: Cannot find module 'OpenStudio'

PROBLEM: Your JavaScript cannot find where the OpenStudio software libraries are.  


1. Login as user & add to $PATH
export NODE_PATH=/usr/local/lib/openstudio/node
sudo -s 
sudo echo 'export NODE_PATH=/usr/local/lib/openstudio/node' >> /etc/profile 
sudo echo 'export PATH=$PATH:$NODE_PATH' >> /etc/profile
2. Login as root & add to $PATH
sudo -i 
sudo echo 'export NODE_PATH=/usr/local/lib/openstudio/node' >> /etc/environment
sudo echo 'export PATH=$PATH:$NODE_PATH' >> /etc/environment

echo $PATH

/usr/local/lib/openstudio/node must show up

POST SPECIFIC TO : Linux Ubuntu 12.04
Jason Turner, Empty Crate

    throw err;
Error: Cannot find module 'OpenStudio'
    at Function.Module._resolveFilename (module.js:338:15)
    at Function.Module._load (module.js:280:25)
    at Module.require (module.js:364:17)
    at require (module.js:380:17)
    at Object. (/home/ubuntu/
    at Module._compile (module.js:456:26)
    at Object.Module._extensions..js (module.js:474:10)
    at Module.load (module.js:356:32)
    at Function.Module._load (module.js:312:12)
    at Function.Module.runMain (module.js:497:10)