The way I solved this puzzle has a nice use of value.split(//) to get an array of letters from a string, as well as:
That’s quite a list of functions for something I thought was relatively straightforward!
There’s also a more appropriate use of the OpenRefine Record mode in the second part (although I still revert to the horrible hack used in day 2 to add together all the numbers in a column). Creating the records in the second part includes a neat hack to group together a set number of rows which works easily because of a quirk of the way OpenRefine handles numbers which I completely fail to explain properly in the screen capture!