Earlier, you computed the score of an Aussie rules game. Do it again, but with the input from a CSV file.
The worksheet starts like this:
The program reads the file name from the worksheet, reads goals and behinds from that file, computes the score, and outputs the data. For example, if the file is...
... then goals is 5, and behinds is 8. Each goal is worth six points, and each behind is worth one point.
Here's the output with that data:
Here's another example. To start:
You need to make the input CSV file(s) yourself, with Notepad (Windows), or TextEdit (Mac).
Upload your workbook, and a test CSV file.