Spreadsheet: 798285d1664395116-power-query-wont-load-s666-pq-job-costing-by-team-member-report-19-22_edited
Sheet: Sheet1

Job Code | Employee Formatted | Regular Rate | Regular Hours
22011 | Neel Bhattacharya |  | 43.5
22011 | [NAME] | 80 | 11
22011 | [NAME] | 30 | 66
22011 | Alexandra Green |  | 18
22011 | [NAME] | 45 | 0.5
22011 | Tonia [NAME] | 44 | 99
22001 | [NAME] | 65 | 57
22006 | [NAME] | 46 | 72
22006 | [NAME] | 34 | 90
22023 | [NAME] | 96 | 74.7
22028 | [NAME] | 50 | 64
22000 | [NAME] | 80 | 18
22000 | [NAME] | 70 | 54
22000 | [NAME] | 45 | 66.5
22000 | [NAME] | 63 | 42
22000 | [NAME] | 22 | 40
22000 | Justin Ucol | 58 | 14.5
22017 | [NAME] | 44 | 72
22017 | [NAME] | 47 | 38
22097 | [NAME] | 130 | 21.5
22097 | [NAME] | 80 | 1
22069 | [NAME] | 15 | 4
22073 | [NAME] | 65 | 7
22074 | [NAME] | 30 | 1.5
22074 | Alexandra Green |  | 2.5
22074 | [NAME] | 55 | 64
21115 | [NAME] | 84 | 18.5
21115 | [NAME] | 70 | 1.5
22096 | [NAME] | 65 | 20
22096 | [NAME] | 14 | 11.25
22096 | [NAME] | 30 | 4.5
22096 | [NAME] | 50 | 40.5
22096 | [NAME] | 70 | 24.25
22096 | [NAME] | 100 | 42
22096 | [NAME] | 50 | 5.5
22124 | [NAME] | 70 | 5
22016 | [NAME] | 45 | 4.5
22016 | [NAME] | 63 | 7
22016 | [NAME] | 63 | 6.5
22016 | [NAME] | 45 | 34.5
22019 | [NAME] | 80 | 0.5
22019 | [NAME] | 55 | 40
22019 | [NAME] | 45 | 0.5
22019 | [NAME] | 42 | 6.5
22021 | [NAME] | 55 | 6
22022 | [NAME] | 80 | 1
22022 | Alexandra Green |  | 19
22022 | [NAME] | 55 | 20
22022 | [NAME] | 63 | 8
22022 | [NAME] | 60 | 5.25
22022 | [NAME] | 42 | 1.5
22022 | [NAME] | 50 | 59
22022 | [NAME] | 58 | 1
22029 | [NAME] | 130 | 7.5
22029 | [NAME] | 80 | 1
22029 | [NAME] | 67 | 1
22029 | [NAME] | 84 | 1
22029 | [NAME] |  | 39.5
22088 | [NAME] | 55 | 19
22084 | [NAME] | 10 | 21
22002 | [NAME] | 60 | 67
22005 | [NAME] | 70 | 41
22070 | Jr. [NAME] | 50 | 15
22070 | [NAME] | 68 | 0
22070 | [NAME] | 60 | 19.5
22070 | [NAME] | 54 | 72
22110 | [NAME] | 15 | 12
22119 | [NAME] | 80 | 2
22119 | [NAME] | 50 | 7
22119 | [NAME] | 42 | 48
21076 | Neel Bhattacharya |  | 19
21076 | Alexandra Green |  | 3
22012 | [NAME] | 70 | 9
22040 | [NAME] | 40 | 44
22040 | Jr. [NAME] | 50 | 31
22040 | Alexandra Green |  | 5.5
22040 | [NAME] | 55 | 12
22040 | [NAME] | 58 | 0.5
22071 | [NAME] | 63 | 54
22094 | [NAME] | 42 | 16
22114 | Neel Bhattacharya |  | 11
22114 | Alexandra Green |  | 0.5
22114 | [NAME] |  | 20.5
21023 | [NAME] | 65 | 2
21023 | [NAME] | 84 | 8.5
21023 | [NAME] | 165 | 26.25
22104 | [NAME] | 50 | 67
22131-P | [NAME] | 130 | 19.5
22131-P | [NAME] | 84 | 4
22131-P | [NAME] | 70 | 1.75
22131-P | [NAME] | 100 | 2
19117 | [NAME] | 65 | 3
19117 | [NAME] | 84 | 2
19117 | [NAME] | 52 | 5
19117 | [NAME] | 50 | 14
1951 | [NAME] | 52 | 2
20091 | [NAME] | 84 | 4
20108 | [NAME] | 65 | 8
20108 | [NAME] | 84 | 1.5
20108 | [NAME] | 100 | 1.5
21034 | [NAME] | 53 | 7
21034 | [NAME] | 70 | 5.25
21113 | [NAME] | 84 | 4
21113 | [NAME] | 53 | 1
21113 | [NAME] | 70 | 0.75
21114 | [NAME] | 65 | 2
22042 | [NAME] | 52 | 4
22047 | [NAME] | 52 | 3
22055 | [NAME] | 84 | 5
22055 | [NAME] | 84 | 6.5
22055 | [NAME] | 53 | 15
22055 | [NAME] | 70 | 7.5
22103 | [NAME] | 84 | 14
22103 | [NAME] | 52 | 8
22103 | [NAME] | 50 | 14.5
22115 | [NAME] | 67 | 1
22115 | [NAME] | 84 | 6
22115 | [NAME] | 84 | 1
22115 | [NAME] | 60 | 42
22115 | [NAME] | 53 | 41
22115 | [NAME] | 70 | 10.5
22115 | [NAME] | 50 | 15
22121 | [NAME] | 65 | 6
22121 | [NAME] | 52 | 31.5
22121 | [NAME] | 53 | 8
22121 | [NAME] | 50 | 2
22122 | [NAME] | 84 | 2
22122 | [NAME] | 70 | 3.5
22129-P | [NAME] | 84 | 2.5
22129-P | [NAME] | 100 | 2.5
22129-P | [NAME] | 50 | 1
22134 | [NAME] | 65 | 10
22134 | [NAME] | 84 | 7
22134 | [NAME] | 70 | 8
22134 | [NAME] | 100 | 1
22087-P | [NAME] | 15 | 58
22087-P | [NAME] | 38 | 76
22087-P | [NAME] | 80 | 1
22087-P | [NAME] | 24 | 23.75
22087-P | Alexandra Green |  | 10.5
22087-P | [NAME] | 22 | 32
22087-P | [NAME] | 50 | 72
22087-P | [NAME] |  | 20
22087-P | Sujata Sinha |  | 3
22087-P | [NAME] | 65 | 3
22132 | [NAME] | 63 | 5
22102 | Alexandra Green |  | 4
22102 | Justin Ucol | 58 | 47.5
22102 | [NAME] | 65 | 78
22098 | [NAME] | 65 | 21
22098 | [NAME] | 67 | 36
22098 | [NAME] | 84 | 43
22098 | [NAME] | 84 | 11.5
22098 | [NAME] | 14 | 58
22098 | [NAME] | 52 | 12.5
22098 | [NAME] | 50 | 29
22098 | [NAME] | 70 | 4.75
22098 | [NAME] | 100 | 28
22098 | [NAME] | 50 | 4
22135 | [NAME] | 84 | 6
22135 | [NAME] | 60 | 20
22135 | [NAME] | 70 | 18.75