Spreadsheet: 851077d1701331856-analyse-customer-feedback-by-team-member-book4-6-aligw
Sheet: analysed

DATA NEEDED & SOURCES
Really helpful if we can add their role in column A, based on whether the name was in column D or E
source of data from raw data | D2 | F2 | G2 | H2 | j2 | L2 | m2 | N2 | O2
Role | Name | Satisfied | Boat | Kind & friendly | Energised | teaching | Welcome | Food | pre trip info
Skipper | [NAME] | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 3
source of data from raw data |  | F2 | G2 | I2 | K2 | L2 | m2 | N2 | O2
Mate | [NAME] | 5 | 3 | 5 | 5 | 3 | 3 | 3 | 3
SORTED DATA BELOW |  |  |  |  |  |  |  |  |  |  | SUMMARY DATA BELOW
Role | Name | Satisfied | Boat | Kind & friendly | Energised | teaching | Welcome | Food | pre trip info |  | Average Scores | Satisfied | Boat | Kind & friendly | Energised | teaching | Welcome | Food | pre trip info
Skipper | [NAME] | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 3 |  | [NAME] | Average of all [NAME]'s 'Satisfied scores' | etc
Mate | [NAME] | 5 | 3 | 5 | 5 | 3 | 3 | 3 | 3 |  | [NAME] | etc | etc
 | [NAME] | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 3 |  |  | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 4
Skipper | [NAME] | 5 | 2 | 5 | 5 | 5 | 5 | 1 | 2 |  | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 |  | [NAME] | 2 | 3 | 5 | 5 | 3 | 3 | 3 | 3
Skipper | [NAME] Zijden | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5 |  | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] | 4 | 2 | 4 | 4 | 3 | 4 | 2 | 3 |  | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5 |  | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 4
Skipper | [NAME] Zijden | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 |  | [NAME] | 2 | 3 | 2 | 2 | 3 | 3 | 3 | 3
Skipper | [NAME] Zijden | 5 | 3 | 5 | 5 | 5 | 5 | 4 | 5 |  | [NAME] Zijden | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] Zijden | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4
Skipper | [NAME] Zijden | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4
Skipper | [NAME] Zijden | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 5
Skipper | [NAME] Zijden | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 5
Skipper | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] | 5 | 4 | 5 | 5 | 4 | 4 | 3 | 4
Skipper | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] Zijden | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Skipper | [NAME] Zijden | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 3
Skipper | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 3 | 5
Skipper | [NAME] Zijden | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 2 | 3 | 5 | 5 | 3 | 3 | 3 | 3
Mate | [NAME] | 5 | 2 | 5 | 5 | 5 | 5 | 1 | 2
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 4 | 2 | 4 | 4 | 3 | 4 | 2 | 3
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 4 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 3 | 5 | 5 | 5 | 5 | 4 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 4
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 4 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 4 | 5 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 4 | 4 | 3 | 4
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 5 | 3
Mate | [NAME] | 5 | 4 | 5 | 5 | 5 | 5 | 3 | 5
Mate | [NAME] | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5