Travis Horn

Tag

excel

#excel

More content

Read more stories on Hashnode

Articles with this tag

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...

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...

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...

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...

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

Using JavaScript to Work with Spreadsheets, Part 2: Setting up the Workspace

Dec 28, 20204 min read

This is the second article in a series where we’ll be learning to use the powerful logic of a programming language like JavaScript to manipulate...

Using JavaScript to Work with Spreadsheets, Part 2: Setting up the Workspace

Using JavaScript to Work with Spreadsheets, Part 1: The Shape of the Data

Dec 21, 20203 min read

This is the first article in a series where we’ll be learning to use the powerful logic of a programming language like JavaScript to manipulate...

Using JavaScript to Work with Spreadsheets, Part 1: The Shape of the Data