SAM Project Assignment 7
rfeliz12
NP_EX19_EOM7-2_RichardFeliz_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 7: EOM Project 2 | |
| Content Shop | |
| SUMMARIZING YOUR DATA WITH PIVOTTABLES | |
| Author: | Richard Feliz |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Contract Writers
| Content Shop Contract Writers | ||||||||
| Contractor ID | S-567 | Years | 0 | 1 | 2 | 3 | 4 | |
| Contractor Name | Jose Saldana | Rate per Word | $0.25 | $0.30 | $0.35 | $0.40 | $0.50 | |
| Assignments | ||||||||
| Contractor ID | Name | Years | Rate per Word | Avg Eval | Avg Score | Q&As | Reviews | Copywriting |
| A-701 | Victor Alvarez | 2.5 | $0.35 | 7.50 | 7.50 | |||
| B-022 | Doug Bidinger | 1.0 | $0.30 | 5.00 | 6.00 | |||
| B-216 | Antoine Bossard | 1.5 | $0.30 | 6.75 | 7.25 | |||
| C-147 | Mary Kay Cavanaugh | 4.0 | $0.50 | 5.50 | 8.00 | |||
| D-724 | James Dargenio | 3.0 | $0.40 | 8.00 | 7.50 | |||
| F-629 | Pilar Flores | 4.0 | $0.50 | 8.00 | 8.50 | |||
| F-975 | Rachel Fuller | 0.5 | $0.25 | 7.50 | 10.00 | |||
| H-108 | Min Hong | 3.5 | $0.40 | 6.50 | 6.50 | |||
| J-869 | Katrina Jackson | 2.0 | $0.35 | 5.75 | 6.00 | |||
| L-293 | Jum Li | 3.0 | $0.40 | 8.00 | 8.00 | |||
| L-452 | Will Lucht | 3.0 | $0.40 | 7.75 | 7.50 | |||
| O-443 | Kerry O'Keefe | 2.0 | $0.35 | 5.25 | 6.00 | |||
| P-508 | Liz Payton | 0.5 | $0.25 | 6.25 | 6.25 | |||
| P-692 | Patrick Pfeiffer | 3.0 | $0.40 | 7.00 | 8.50 | |||
| P-733 | Calvin Purcell | 4.0 | $0.50 | 8.00 | 7.50 | |||
| S-567 | Jose Saldana | 4.5 | $0.50 | 8.50 | 9.00 | |||
| S-752 | Anthony Scalizzi | 2.5 | $0.35 | 7.00 | 7.50 | |||
| S-939 | Martin Schuster | 4.0 | $0.50 | 6.75 | 7.00 | |||
| V-098 | Maria Velazquez | 2.0 | $0.35 | 6.00 | 6.00 | |||
| W-231 | Latoya Wheeler | 2.0 | $0.35 | 7.00 | 6.75 | |||
Editing Projects
| Projects | ||||||
| Group ID | Level | Specialty | Jan | Feb | Mar | Total Projects |
| A-2 | Platinum | Reviews | 10 | 8 | 11 | 29 |
| A-2 | Silver | Reviews | 8 | 9 | 10 | 27 |
| A-1 | Silver | Q&As | 7 | 9 | 9 | 25 |
| A-1 | Platinum | Q&As | 7 | 8 | 9 | 24 |
| B-2 | Platinum | Copywriting | 10 | 7 | 7 | 24 |
| C-2 | Bronze | Internal | 6 | 8 | 10 | 24 |
| C-2 | Gold | Reviews | 7 | 7 | 9 | 23 |
| C-3 | Silver | Reviews | 8 | 7 | 8 | 23 |
| C-2 | Silver | Q&As | 8 | 7 | 8 | 23 |
| B-1 | Bronze | Copywriting | 7 | 8 | 8 | 23 |
| C-1 | Platinum | Internal | 7 | 6 | 9 | 22 |
| B-2 | Silver | Q&As | 6 | 8 | 8 | 22 |
| B-2 | Bronze | Internal | 5 | 7 | 10 | 22 |
| B-3 | Platinum | Reviews | 8 | 6 | 6 | 20 |
| B-3 | Silver | Internal | 5 | 7 | 9 | 21 |
| C-3 | Platinum | Copywriting | 7 | 7 | 6 | 20 |
| C-1 | Gold | Q&As | 6 | 7 | 7 | 20 |
| A-3 | Silver | Copywriting | 4 | 6 | 10 | 20 |
| A-1 | Bronze | Reviews | 8 | 6 | 6 | 20 |
| C-1 | Bronze | Copywriting | 8 | 8 | 4 | 20 |
| A-3 | Platinum | Internal | 5 | 7 | 8 | 20 |
| B-1 | Platinum | Q&As | 7 | 8 | 5 | 20 |
| B-1 | Gold | Copywriting | 6 | 7 | 6 | 19 |
| C-1 | Silver | Reviews | 5 | 5 | 9 | 19 |
| C-2 | Platinum | Reviews | 6 | 5 | 6 | 17 |
| B-2 | Gold | Copywriting | 3 | 7 | 8 | 18 |
| A-2 | Bronze | Q&As | 5 | 6 | 7 | 18 |
| C-3 | Bronze | Reviews | 5 | 5 | 8 | 18 |
| A-3 | Bronze | Q&As | 7 | 4 | 7 | 18 |
| B-3 | Gold | Q&As | 6 | 5 | 5 | 16 |
| B-1 | Silver | Reviews | 4 | 4 | 8 | 16 |
| A-2 | Gold | Reviews | 4 | 5 | 5 | 14 |
| B-3 | Bronze | Reviews | 5 | 5 | 3 | 13 |
| C-3 | Gold | Copywriting | 2 | 4 | 6 | 12 |
| A-3 | Gold | Internal | 5 | 2 | 5 | 12 |
| A-1 | Gold | Internal | 4 | 2 | 4 | 10 |
Editing PivotTable
| Copywriting | Internal | Q&As | Reviews | Total Total Editing Projects | Total Average of Total Projects | |||||||||||||||||||||||||||||||||||||||||||||||||
| A-3 | B-1 | B-2 | C-1 | C-3 | A-1 | A-3 | B-2 | B-3 | C-1 | C-2 | A-1 | A-2 | A-3 | B-1 | B-2 | B-3 | C-1 | C-2 | A-1 | A-2 | B-1 | B-3 | C-1 | C-2 | C-3 | |||||||||||||||||||||||||||||
| Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | Total Editing Projects | Average of Total Projects | |||
| Bronze | 23 | 23 | 20 | 20 | 22 | 22 | 24 | 24 | 18 | 18 | 18 | 18 | 20 | 20 | 13 | 13 | 18 | 18 | 176 | 19.5555555556 | ||||||||||||||||||||||||||||||||||
| Gold | 19 | 19 | 18 | 18 | 12 | 12 | 10 | 10 | 12 | 12 | 16 | 16 | 20 | 20 | 14 | 14 | 23 | 23 | 144 | 16 | ||||||||||||||||||||||||||||||||||
| Platinum | 24 | 24 | 20 | 20 | 20 | 20 | 22 | 22 | 24 | 24 | 20 | 20 | 29 | 29 | 20 | 20 | 17 | 17 | 196 | 21.7777777778 | ||||||||||||||||||||||||||||||||||
| Silver | 20 | 20 | 21 | 21 | 25 | 25 | 22 | 22 | 23 | 23 | 27 | 27 | 16 | 16 | 19 | 19 | 23 | 23 | 196 | 21.7777777778 | ||||||||||||||||||||||||||||||||||
| Grand Total | 20 | 20 | 42 | 21 | 42 | 21 | 20 | 20 | 32 | 16 | 10 | 10 | 32 | 16 | 22 | 22 | 21 | 21 | 22 | 22 | 24 | 24 | 49 | 24.5 | 18 | 18 | 18 | 18 | 20 | 20 | 22 | 22 | 16 | 16 | 20 | 20 | 23 | 23 | 20 | 20 | 70 | 23.3333333333 | 16 | 16 | 33 | 16.5 | 19 | 19 | 40 | 20 | 41 | 20.5 | 712 | 19.7777777778 |
Platinum Editing Groups
| Editing Groups - Platinum Level | |||||||
| Projects | |||||||
| Group ID | Level | Specialty | Project Type | Jan | Feb | Mar | Total Projects |
| A-2 | Platinum | Reviews | New | 10 | 8 | 11 | 29 |
| A-1 | Platinum | Q&As | Repeat | 7 | 8 | 9 | 24 |
| B-2 | Platinum | Copywriting | Repeat | 10 | 7 | 7 | 24 |
| C-1 | Platinum | Internal | New | 7 | 6 | 9 | 22 |
| B-3 | Platinum | Reviews | Repeat | 8 | 6 | 6 | 20 |
| C-3 | Platinum | Copywriting | Repeat | 7 | 7 | 6 | 20 |
| A-3 | Platinum | Internal | New | 5 | 7 | 7 | 19 |
| B-1 | Platinum | Q&As | Repeat | 7 | 7 | 5 | 19 |
| C-2 | Platinum | Reviews | Repeat | 6 | 6 | 6 | 18 |
| Most projects: | |||||||
| Total reviews: | |||||||
