data science

A reupload of Joel Spolsky's talk teaching spreadsheet users the Excel features they are probably missing, such as keyboard navigation, named ranges, tables and lookups. The original disappeared and this copy comes from the Wayback Machine.

A screencast tutorial on Specter, a Clojure library for navigating and transforming nested data structures declaratively, demonstrated in a REPL.

Ben Krasnow of Applied Science explains how electrophoretic e-paper displays work and how he modified the driver firmware and waveform lookup tables of a 4.2-inch panel to reach roughly 3Hz partial refresh. It covers the tweakable constants in the refresh process and touches on colored e-ink microcapsules.

Applied Science builds a replica Apollo DSKY using an electroluminescent driver circuit and screen-printed conductive ink, with source and PCB files published.

Ben Krasnow of Applied Science shows how to make small batches of specialty glass with minimal equipment, including designing and making photochromic glass. He covers ingredients, melting and the challenges involved.

Ben Krasnow of Applied Science uses an antique 4x5 view camera to make high-resolution photolithography masks in a home shop. He photographs a poster-sized printout onto litho film to get features around 20 microns.

Tech Ingredients shows how to make a homemade radiative cooling paint, with a custom liquid panel that cools below ambient temperature outdoors. The video covers the materials and how to apply the paint.

NightHawkInLight shows how to make ultra-white radiative paint that cools surfaces below ambient temperature without electricity. He walks through the research papers and the household-materials process.

James Trunk introduces Clojure syntax and thinking, covering its core data structures, immutability, the thread-last macro and live data analysis in the REPL.

Markus Triska tours Prolog's most distinctive features, including its use as a database and query language, rule processing, constraint solving and compile-time rewriting. It also covers concise meta-interpreters.