Thursday, November 7, 2019

November 2019 Diversions

Eternal links:
Small Angels hamster adoption:
http://www.smallangelsrescue.org/angels/hamsters/

Trying to record Buntopia:

Ideas for how to record stereo from a mixing board using an ipad:
Several nice tips but it doesn't have anything to do with stereo. He recommends a couple of attenuator cables:
https://www.studioscratches.com/how-to-record-high-quality-audio-directly-into-your-iphone/
Several tips:
https://www.cultofmac.com/610284/how-to-record-any-audio-on-your-iphone/

The recommended attenuator cable. It looks good really, but it's still mono:
https://www.amazon.com/Line-level-Audio-Adapter-iPhone-Smartphone/dp/B00OAW85ZG/ref=as_li_ss_tl



Old misc links cleared off of Workie during Nov 2019:
A fun article about the terrible I Dream Of Genie last episode:
https://www.vulture.com/2015/07/inside-i-dream-of-jeannies-strange-bottle-episodeclip-showseries-finale-hybrid.html
An article about a recent training incident in the air force. It was reported breathlessly on a liberal website, it is interesting to read this more professional and detailed account on a military news site:
https://www.airforcetimes.com/news/your-air-force/2019/09/06/air-force-a-10-accidentally-fires-rocket-near-tucson/
A reddit thread about a visit by Elon to Boca Chica; this is the event that coverage of which got one blogger spun up in Florida:
https://www.reddit.com/r/SpaceXLounge/comments/d4frvn/spacexcentric_elon_visited_starhopper_tonight/


Politics:
Trump Booed again at another public event, this time a "wrestling" match. Less dramatic than at the world series, partially due to the organizers trying to slip him in without being noticed: http://nymag.com/intelligencer/2019/11/trump-booed-again-during-understated-appearance-at-ufc-event.html?utm_source=undefined&utm_medium=undefined&utm_campaign=feed-part

Misc Links:
Stanley Kubrik's B&W photos from NYC the 1940s. A nice look back at history, but the term "genius" is a bit generous for someone obsessed with both beautiful women and shoe shine boys. https://www.demilked.com/old-photos-new-york-streets-stanley-kubrick/
The rules for American Education Week visitations this year from GCES. It was a lot of fun:
https://gces.hcpss.org/news/2019/11/american-education-week-2019
A bunch of future astronauts and a couple of token men:
https://twitter.com/NASA_Marshall/status/1204063123310821376
This was a fun article about Hollywood scandals associated with Nickelodeon:
https://www.nickiswift.com/18009/disturbing-secrets-nickelodeon-hid-us/

The straw bale Space Cruiser Yamato. It's apparently in Japan. The detail seems to be all either wood or cardboard.
The magazine article about it: https://www.otakuusamagazine.com/yamato-straw/
First twitter link with photos: https://twitter.com/d9e4a5ad6dae448/status/1190651875705536512/photo/1
Second twitter link with photos: https://twitter.com/kurage52natsu21/status/1190869467296718848/photo/1

Pimple popping links that it is probably not a good idea to view again:
A specific reddit post on an ingrown hair that leads to other threads that eventually lead to nightmare fuel:
https://www.reddit.com/r/popping/comments/6yd0z8/gnarly_ingrown_shoulder_hair/
Pretty much the funniest pop I've ever seen, clipped into a GIF in a Reddit post but with a link to the full YouTube video on the comments:
https://www.reddit.com/r/popping/comments/dw29k8/everysingletime/

Sunday, November 3, 2019

Excel tips for min/max report

When putting together the min/max report, the following links came in handy:

To create the secondary axis, select a data series, and select "Format Data Series", then in Series Options find the option for "Secondary Axis".
https://www.extendoffice.com/documents/excel/2019-excel-make-two-y-axis.html
How to turn on the X and Y axis labels: Find the + sign for "Chart Elements" floating on the right side of the graph and select "Axis Titles". Also you can do any combination of X primary, X seconday, and Y axis labels:
https://www.extendoffice.com/documents/excel/1570-excel-add-axis-label.html#a2
Histograms are built in for Excel 2016. Also I found by trial and error that in order to restrict bin boundaries to the number of desired significant digits, the overflow bin has to either contain some data or be close to the first bin:
https://trumpexcel.com/histogram-in-excel/
Excel has a STDEV function: https://social.msdn.microsoft.com/Forums/en-US/0d8edea2-f08e-41b7-b120-8ac08855c23b/difference-between-stdev-amp-stdevp?forum=sqlanalysisservices
Here's a nice article explaining Mean, Median, and Mode: https://www.purplemath.com/modules/meanmode.htm