SUMIFS formula for Excel to sum based on condition across a set of cells

https://www.ablebits.com/office-addins-blog/2014/11/12/excel-sumifs-sumif-multiple-criteria/

Why D65 is the right white point to use for calibration

But you can't compare images on screen and on paper side by side:
http://www.color-image.com/2012/02/monitor-calibration-d65-white-point-soft-proofing/

Didn't know there was this org

https://www.washingtonpost.com/local/education/these-christian-teachers-want-to-bring-jesus-into-public-schools--legally/2016/03/12/bfd95986-dfd3-11e5-8d98-4b3d9215ade1_story.html

Sorting columns (by values in a row) in Excel

http://www.contextures.com/xlSort01.html

Best keynote timers I found online

http://www.ipresentee.com/keynote-countdown-timers/

Great tension photos

http://www.aarontilley.com/

For getting true gain/losses after selling Adobe ESPP or RSUs

This information can be found in the eTrade in the Understanding Your Cost Basis Information for Lots Sold After section. That section can be found by going to:

•  Employee Stock Plan Gains & Losses  (Account - > My Stock Plan -> My Account tab -> Gains & Losses) and filter for the last tax year. Expand the Sale details for the ESPP stock
• The section: Understanding Your Cost Basis Information for Lots Sold After …. has the cost Acquisition Cost and Ordinary Income Recognized

RSU Stocks:

For the RSUs  just need to add the actual cost of the stocks at the day that was vested. It also can be found as Ordinary Income Recognized in Understanding Your Cost Basis Information for Lots Sold After section.

Second answer also works on arrays of array

http://stackoverflow.com/questions/9960908/permutations-in-javascript

Methods for getting attention from large groups

Google search: how to get the attention of a large group
http://www.nuffieldfoundation.org/science-society/gaining-attention-large-group
http://www.ultimatecampresource.com/site/camp-activity/large-group-attention-getters.html
http://appliedimprov.ning.com/forum/topics/1503280:Topic:16633
http://www.experientialtools.com/2012/03/16/large-group-facilitation-tips/
http://www.edutopia.org/groups/classroom-management/737576
http://www.kellybear.com/TeacherArticles/TeacherTip54.html

Future consideration - e bicycle

https://www.faradaybikes.com/features/#a-better-bicycle

Tutorial on how to setup a WordPress based site

https://www.smashingmagazine.com/2016/02/beginners-guide-creating-wordpress-website/ Could come in handy.

Helpful example showing how to conditionally format using a formula

https://support.office.com/en-us/article/Use-a-formula-to-apply-conditional-formatting-FED60DFA-1D3F-4E13-9ECB-F1951FF89D7F

Even better link showing how to do ANDs and the like:
https://support.office.com/en-us/article/Create-conditional-formulas-to-find-data-or-apply-formatting-5CDFB6A3-75FF-48C3-B11F-C15F9563722D

Clever way to erase Android phone

http://www.cnet.com/how-to/the-best-way-to-completely-wipe-your-android-device/
I totally didn't think about encrypting the phone first. Pretty clever. Of course, for any data I had already erased that wouldn't work and would require the fake data load, but I'm not that paranoid.

Future teaching volunteer opportunity?

http://www.citizenschools.org/

For pool overhaul

Consider Corby Gould Pools and going fiberglass

A9 envelop size

A9 is for half sheets of 8.5x11 paper folded in half.

5 3/4 x 8 3/4

Helpful slide formatting tips

https://www.behance.net/gallery/8935661/The-Slide-Deck

Boo - United does not allow for minors to have a frequent flyer account

http://thewinglet.boardingarea.com/kids-frequent-flyer-account/

Supposedly a way to listen to audio over both headphone jack and HDMI, but not working for me

http://www.addictivetips.com/windows-tips/how-to-play-audio-through-hdmi-speakers-simultaneously-in-windows-7/

http://answers.microsoft.com/en-us/windows/forum/windows_7-pictures/is-it-possible-to-get-audio-in-windows-7-through/ac278bd7-4bc3-41d5-9713-669abfccba22?auth=1

How to get Android Samsung S6 to keep vibrating after a text is received

http://forums.androidcentral.com/samsung-galaxy-s6/519602-does-galaxy-s6-have-repeat-message-alert-setting.html