Documentation 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 Contractor Name Jose Saldana Rate per Word

Documentationnew Perspectives Excel 2019 Module 7 Eom Project 2cont

Documentation 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 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..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 A-2 Silver Reviews A-1 Silver Q&As A-1 Platinum Q&As B-2 Platinum Copywriting C-2 Bronze Internal C-2 Gold Reviews C-3 Silver Reviews C-2 Silver Q&As B-1 Bronze Copywriting C-1 Platinum Internal B-2 Silver Q&As B-2 Bronze Internal B-3 Platinum Reviews B-3 Silver Internal C-3 Platinum Copywriting C-1 Gold Q&As A-3 Silver Copywriting A-1 Bronze Reviews C-1 Bronze Copywriting A-3 Platinum Internal B-1 Platinum Q&As B-1 Gold Copywriting C-1 Silver Reviews C-2 Platinum Reviews B-2 Gold Copywriting A-2 Bronze Q&As C-3 Bronze Reviews A-3 Bronze Q&As B-3 Gold Q&As B-1 Silver Reviews A-2 Gold Reviews B-3 Bronze Reviews C-3 Gold Copywriting A-3 Gold Internal A-1 Gold Internal 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 .

Gold Platinum . Silver . Grand Total ..... Platinum Editing Groups Editing Groups - Platinum Level Projects Group ID Level Specialty Project Type Jan Feb Mar Total Projects A-2 Platinum Reviews New A-1 Platinum Q&As Repeat B-2 Platinum Copywriting Repeat C-1 Platinum Internal New B-3 Platinum Reviews Repeat C-3 Platinum Copywriting Repeat A-3 Platinum Internal New B-1 Platinum Q&As Repeat C-2 Platinum Reviews Repeat Most projects: Total reviews: