Travis Horn

Travis Horn

Reverse-Proxying Node.js Apps on Windows with IIS

Apr 2, 20216 min read

You can run Node.js apps on Windows with the added layer of a reverse-proxy with the built-in web service manager IIS. Together with a process manager like PM2, it’s a viable strategy to run apps for production. Why use a reverse proxy? Having a ded...

Reverse-Proxying Node.js Apps on Windows with IIS

Some ways to align the last row in a flexbox grid

Mar 18, 20213 min read

Using flexbox doesn’t always produce the expected alignment, especially on the last row of a grid. When you use justify-content: space-between it will place a large gap in the last row unless there are a square number of items. Say we have a collect...

Some ways to align the last row in a flexbox grid

Excel Formula to Scale Data from 0 to 1

Mar 11, 20213 min read

Say we have a set of data in column A. 469 396 600 177 240 155 204 454 278 233 And we want to scale the data so that the lowest value equates to 0 and the highest value equates to 1. If you just want a quick formula to do this, you can copy the line...

Excel Formula to Scale Data from 0 to 1

Using JavaScript to Work with Spreadsheets, Part 5: Parsing XLSX Files

Jan 18, 20216 min read

This is the fifth article in a series where we’ll be learning to use the powerful logic of a programming language like JavaScript to manipulate spreadsheet data. In this article, we’ll talk about how to read and parse XSLX files using JavaScript in N...

Using JavaScript to Work with Spreadsheets, Part 5: Parsing XLSX Files

Using JavaScript to Work with Spreadsheets, Part 4: Making the CLI More Robust

Jan 11, 20216 min read

This is the fourth article in a series where we’ll be learning to use the powerful logic of a programming language like JavaScript to manipulate spreadsheet data. In this article, we’ll talk about how to add a dependency from the npm registry and we’...

Using JavaScript to Work with Spreadsheets, Part 4: Making the CLI More Robust

Using JavaScript to Work with Spreadsheets, Part 3: Accepting Arguments & Reading Files

Jan 4, 20218 min read

This is the third article in a series where we’ll be learning to use the powerful logic of a programming language like JavaScript to manipulate spreadsheet data. In this article, we’ll talk about how to make a Node.js program, have it accept file pat...

Using JavaScript to Work with Spreadsheets, Part 3: Accepting Arguments & Reading Files