coding updates and spreadsheet output testing