1B - Spreadsheet was extremely challenging for me; it took me over 2 hours to get AC, and then when I went to see solutions from red/orange people, it made even less sense. I've seen a bunch of practice solutions to this problem that are basically the following (with minor variation):
Solution