Aussie rules with input file

Tags
Challenge
No

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:

Start

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

  • 5,8

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

Output

Here's another example. To start:

Start

In goat007.csv:

  • 3,2

Output:

Output

You need to make the input CSV file(s) yourself, with Notepad (Windows), or TextEdit (Mac).

Upload your workbook, and a test CSV file.

Where referenced