excel worksheet

profileblueamber95
Christopher.Wagoner-EX2016-SkillReview-8-1.xlsx
Home>Computer Science homework help>excel worksheet

Analysis

Sales by Region
Sales by Sales Associate

Sales Data

National Pharmaceutical Sales
First Name Last Name Region Client Annual Sales Commission Rate Commission Earned
Jan Johansen SW2 Ambulatory Care of TX, Inc. 156,208 4% 6,248.32
George Anderson SW1 AZ Ambulatory Care 91,222 2% 1,824.44
Marques Quarles NE2 Baltimore Bariatrics, Inc. 200,708 6% 12,042.48
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 157,721 4% 6,308.84
Matthew Schmidt NW2 Bellevue Bariatics, Inc. 152,101 4% 6,084.04
Matthew Schmidt NW2 Boise Oncology 108,878 2% 2,177.56
George Anderson SW1 CA Chiropractic Associates, Inc. 107,373 2% 2,147.46
Matthew Schmidt NW2 Casper Cardiology, Inc. 207,555 6% 12,453.30
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 153,211 4% 6,128.44
Matthew Schmidt NW2 Cheyenne Cardiologists, Inc. 114,411 2% 2,288.22
Jan Johansen SW2 CO Pharmacies, Inc. 106,266 2% 2,125.32
Marques Quarles NE1 Connecticut Pulmonary Associates, Inc. 103,301 2% 2,066.02
Marques Quarles NE2 DC Dialysis 162,202 4% 6,488.08
Marques Quarles NE2 Delaware Dental Associates 215,609 6% 12,936.54
George Anderson SW1 Emergency Medicine Association 115,609 2% 2,312.18
Jan Johansen SW2 EMTS of CO, Inc. 152,686 4% 6,107.44
Raminian Ahjab NE1 Garden State Pharmacies 122,222 2% 2,444.44
Tatisha Brown SE1 Gerontology Associates of MS 127,555 2% 2,551.10
Matthew Schmidt NW2 ID Internal Medicine Associates 185,272 4% 7,410.88
Tatisha Brown SE1 Internal Medicine of MS 169,272 4% 6,770.88
George Anderson SW1 Joint Healthcare Associates 142,734 4% 5,709.36
Tatisha Brown SE1 LA Cardiologists, Inc. 162,777 4% 6,511.08
Matthew Schmidt NW2 Laramie EMTs, Inc. 201,211 6% 12,072.66
Jan Johansen SW2 Lone Star Medicine 133,991 2% 2,679.82
Tatisha Brown SE1 Louisiana Dermatologists, Inc. 118,118 2% 2,362.36
Xin Zhu SE2 Low County Medical Associates, Inc. 82,625 2% 1,652.50
Raminian Ahjab NE1 MA OBGyn Associates 128,979 2% 2,579.58
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28
Marques Quarles NE2 Maryland Pharmacies, Inc. 209,708 6% 12,582.48
Raminian Ahjab NE2 MD Dental Associates 133,288 2% 2,665.76
Tatisha Brown SE1 MS Women's Clinics, Inc. 133,288 2% 2,665.76
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08
Jan Johansen SW2 Nephrology Associates, Inc. 87,556 2% 1,751.12
Raminian Ahjab NE1 New England Pharmacies, Inc. 91,995 2% 1,839.90
Raminian Ahjab NE1 New England Physicians, Inc. 97,489 2% 1,949.78
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28
George Anderson SW1 NM Pharmacies, Inc. 115,975 2% 2,319.50
Jan Johansen SW2 NV Emergency Medical Associates, Inc. 114,111 2% 2,282.22
Julieta Lopez NW1 OBGyn Associates of Montana, Inc. 88,888 2% 1,777.76
Jan Johansen SW2 OK Clinics 105,767 2% 2,115.34
Julieta Lopez NW1 Oregon Opthamology, Inc. 96,606 2% 1,932.12
Julieta Lopez NW1 Orthodontial, Inc. 83,363 2% 1,667.26
Xin Zhu SE2 Orthopaedic Medical Associates 87,773 2% 1,755.46
Raminian Ahjab NE2 PA Medical Practices, Inc. 88,878 2% 1,777.56
Xin Zhu SE2 Palmetto Physicans 165,700 4% 6,628.00
Xin Zhu SE2 Palmetto Podiatrists, Inc. 82,935 2% 1,658.70
Jan Johansen SW2 Pharmacies of Nevada, Inc. 115,234 2% 2,304.68
Tatisha Brown SE1 Physicians of MS, Inc. 141,111 4% 5,644.44
Xin Zhu SE2 Piedmont Health Associates, Inc. 98,333 2% 1,966.66
Marques Quarles NE2 Rhode Island Gastroenterology, Inc. 91,708 2% 1,834.16
Xin Zhu SE2 SC Medical Associates 115,272 2% 2,305.44
Julieta Lopez NW1 Seattle Psychiatric Associates, Inc. 97,443 2% 1,948.86
Julieta Lopez NW1 Seattle Psychologists, Inc. 97,002 2% 1,940.04
George Anderson SW1 Southwest Dermatology 108,277 2% 2,165.54
George Anderson SW1 Southwest Medical Associates 82,651 2% 1,653.02
Jan Johansen SW2 TEX-MEX Pharmacies, Inc. 153,848 4% 6,153.92
George Anderson SW1 Tri-state Pharmacies 87,442 2% 1,748.84
Xin Zhu SE2 Upstate Pharmacies, Inc. 89,695 2% 1,793.90
Julieta Lopez NW1 Utah Urology Associates, Inc. 82,319 2% 1,646.38
Julieta Lopez NW1 Washington Physicians, Inc. 89,107 2% 1,782.14
Tatisha Brown SE1 Women's Medicine of FL, Inc. 109,333 2% 2,186.66
Matthew Schmidt NW2 WY OBGyn, Inc. 176,168 4% 7,046.72
Matthew Schmidt NW2 Wyoming Health Care, Inc. 111,111 2% 2,222.22
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

Sales Data Filter

National Pharmaceutical Sales
First Name Last Name Region Client Annual Sales Commission Rate Commission Earned
Jan Johansen SW2 Ambulatory Care of TX, Inc. 156,208 4% 6,248.32
George Anderson SW1 AZ Ambulatory Care 91,222 2% 1,824.44
Marques Quarles NE2 Baltimore Bariatrics, Inc. 200,708 6% 12,042.48
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 157,721 4% 6,308.84
Matthew Schmidt NW2 Bellevue Bariatics, Inc. 152,101 4% 6,084.04
Matthew Schmidt NW2 Boise Oncology 108,878 2% 2,177.56
George Anderson SW1 CA Chiropractic Associates, Inc. 107,373 2% 2,147.46
Matthew Schmidt NW2 Casper Cardiology, Inc. 207,555 6% 12,453.30
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 157,721 4% 6,308.84
Matthew Schmidt NW2 Cheyenne Cardiologists, Inc. 114,411 2% 2,288.22
Jan Johansen SW2 CO Pharmacies, Inc. 106,266 2% 2,125.32
Marques Quarles NE1 Connecticut Pulmonary Associates, Inc. 103,301 2% 2,066.02
Marques Quarles NE2 DC Dialysis 162,202 4% 6,488.08
Marques Quarles NE2 Delaware Dental Associates 215,609 6% 12,936.54
George Anderson SW1 Emergency Medicine Association 121,252 2% 2,425.04
Jan Johansen SW2 EMTS of CO, Inc. 152,686 4% 6,107.44
Raminian Ahjab NE1 Garden State Pharmacies 122,222 2% 2,444.44
Tatisha Brown SE1 Gerontology Associates of MS 127,555 2% 2,551.10
Matthew Schmidt NW2 ID Internal Medicine Associates 185,272 4% 7,410.88
Tatisha Brown SE1 Internal Medicine of MS 169,272 4% 6,770.88
George Anderson SW1 Joint Healthcare Associates 142,734 4% 5,709.36
Tatisha Brown SE1 LA Cardiologists, Inc. 162,777 4% 6,511.08
Matthew Schmidt NW2 Laramie EMTs, Inc. 201,211 6% 12,072.66
Jan Johansen SW2 Lone Star Medicine 133,991 2% 2,679.82
Tatisha Brown SE1 Louisiana Dermatologists, Inc. 118,118 2% 2,362.36
Xin Zhu SE2 Low County Medical Associates, Inc. 82,625 2% 1,652.50
Raminian Ahjab NE1 MA OBGyn Associates 128,979 2% 2,579.58
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28
Marques Quarles NE2 Maryland Pharmacies, Inc. 209,708 6% 12,582.48
Raminian Ahjab NE2 MD Dental Associates 133,288 2% 2,665.76
Tatisha Brown SE1 MS Women's Clinics, Inc. 133,288 2% 2,665.76
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08
Jan Johansen SW2 Nephrology Associates, Inc. 86,288 2% 1,725.76
Raminian Ahjab NE1 New England Pharmacies, Inc. 91,995 2% 1,839.90
Raminian Ahjab NE1 New England Physicians, Inc. 97,489 2% 1,949.78
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28
George Anderson SW1 NM Pharmacies, Inc. 115,975 2% 2,319.50
Jan Johansen SW2 NV Emergency Medical Associates, Inc. 114,111 2% 2,282.22
Julieta Lopez NW1 OBGyn Associates of Montana, Inc. 88,888 2% 1,777.76
Jan Johansen SW2 OK Clinics 105,767 2% 2,115.34
Julieta Lopez NW1 Oregon Opthamology, Inc. 96,606 2% 1,932.12
Julieta Lopez NW1 Orthodontial, Inc. 83,363 2% 1,667.26
Xin Zhu SE2 Orthopaedic Medical Associates 87,773 2% 1,755.46
Raminian Ahjab NE2 PA Medical Practices, Inc. 88,878 2% 1,777.56
Xin Zhu SE2 Palmetto Physicans 165,700 4% 6,628.00
Xin Zhu SE2 Palmetto Podiatrists, Inc. 82,935 2% 1,658.70
Jan Johansen SW2 Pharmacies of Nevada, Inc. 112,788 2% 2,255.76
Tatisha Brown SE1 Physicians of MS, Inc. 141,111 4% 5,644.44
Xin Zhu SE2 Piedmont Health Associates, Inc. 98,333 2% 1,966.66
Marques Quarles NE2 Rhode Island Gastroenterology, Inc. 91,708 2% 1,834.16
Xin Zhu SE2 SC Medical Associates 115,272 2% 2,305.44
Julieta Lopez NW1 Seattle Psychiatric Associates, Inc. 95,292 2% 1,905.84
Julieta Lopez NW1 Seattle Psychologists, Inc. 97,002 2% 1,940.04
George Anderson SW1 Southwest Dermatology 108,277 2% 2,165.54
George Anderson SW1 Southwest Medical Associates 82,651 2% 1,653.02
Jan Johansen SW2 TEX-MEX Pharmacies, Inc. 153,848 4% 6,153.92
George Anderson SW1 Tri-state Pharmacies 87,442 2% 1,748.84
Xin Zhu SE2 Upstate Pharmacies, Inc. 89,695 2% 1,793.90
Julieta Lopez NW1 Utah Urology Associates, Inc. 82,319 2% 1,646.38
Julieta Lopez NW1 Washington Physicians, Inc. 89,107 2% 1,782.14
Tatisha Brown SE1 Women's Medicine of FL, Inc. 109,333 2% 2,186.66
Matthew Schmidt NW2 WY OBGyn, Inc. 171,171 4% 6,846.84
Matthew Schmidt NW2 Wyoming Health Care, Inc. 111,111 2% 2,222.22
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08

Commissions

National Pharmaceutical Sales
First Name Last Name Region Client Annual Sales Commission Rate Commission Earned Rating
Raminian Ahjab NE1 Garden State Pharmacies 122,222 2% 2,444.44 2,444.44
Raminian Ahjab NE1 MA OBGyn Associates 128,979 2% 2,579.58 2,579.58
Raminian Ahjab NE2 MD Dental Associates 133,288 2% 2,665.76 2,665.76
Raminian Ahjab NE1 New England Pharmacies, Inc. 91,995 2% 1,839.90 1,839.90
Raminian Ahjab NE1 New England Physicians, Inc. 97,489 2% 1,949.78 1,949.78
Raminian Ahjab NE2 PA Medical Practices, Inc. 88,878 2% 1,777.56 1,777.56
George Anderson SW1 AZ Ambulatory Care 91,222 2% 1,824.44 1,824.44
George Anderson SW1 CA Chiropractic Associates, Inc. 107,373 2% 2,147.46 2,147.46
George Anderson SW1 Emergency Medicine Association 115,609 2% 2,312.18 2,312.18
George Anderson SW1 Joint Healthcare Associates 142,734 4% 5,709.36 5,709.36
George Anderson SW1 NM Pharmacies, Inc. 115,975 2% 2,319.50 2,319.50
George Anderson SW1 Southwest Dermatology 108,277 2% 2,165.54 2,165.54
George Anderson SW1 Southwest Medical Associates 82,651 2% 1,653.02 1,653.02
George Anderson SW1 Tri-state Pharmacies 87,442 2% 1,748.84 1,748.84
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 157,721 4% 6,308.84 6,308.84
Tatisha Brown SE1 Bama Chiropractic Clinics, Inc. 153,211 4% 6,128.44 6,128.44
Tatisha Brown SE1 Gerontology Associates of MS 127,555 2% 2,551.10 2,551.10
Tatisha Brown SE1 Internal Medicine of MS 169,272 4% 6,770.88 6,770.88
Tatisha Brown SE1 LA Cardiologists, Inc. 162,777 4% 6,511.08 6,511.08
Tatisha Brown SE1 Louisiana Dermatologists, Inc. 118,118 2% 2,362.36 2,362.36
Tatisha Brown SE1 MS Women's Clinics, Inc. 133,288 2% 2,665.76 2,665.76
Tatisha Brown SE1 Physicians of MS, Inc. 141,111 4% 5,644.44 5,644.44
Tatisha Brown SE1 Women's Medicine of FL, Inc. 109,333 2% 2,186.66 2,186.66
Jan Johansen SW2 Ambulatory Care of TX, Inc. 176,208 4% 7,048.32 7,048.32
Jan Johansen SW2 CO Pharmacies, Inc. 106,266 2% 2,125.32 2,125.32
Jan Johansen SW2 EMTS of CO, Inc. 152,686 4% 6,107.44 6,107.44
Jan Johansen SW2 Lone Star Medicine 133,991 2% 2,679.82 2,679.82
Jan Johansen SW2 Nephrology Associates, Inc. 87,556 2% 1,751.12 1,751.12
Jan Johansen SW2 NV Emergency Medical Associates, Inc. 114,111 2% 2,282.22 2,282.22
Jan Johansen SW2 OK Clinics 105,767 2% 2,115.34 2,115.34
Jan Johansen SW2 Pharmacies of Nevada, Inc. 115,234 2% 2,304.68 2,304.68
Jan Johansen SW2 TEX-MEX Pharmacies, Inc. 153,848 4% 6,153.92 6,153.92
Julieta Lopez NW1 OBGyn Associates of Montana, Inc. 88,888 2% 1,777.76 1,777.76
Julieta Lopez NW1 Oregon Opthamology, Inc. 96,606 2% 1,932.12 1,932.12
Julieta Lopez NW1 Orthodontial, Inc. 83,363 2% 1,667.26 1,667.26
Julieta Lopez NW1 Seattle Psychiatric Associates, Inc. 97,443 2% 1,948.86 1,948.86
Julieta Lopez NW1 Seattle Psychologists, Inc. 97,002 2% 1,940.04 1,940.04
Julieta Lopez NW1 Utah Urology Associates, Inc. 82,319 2% 1,646.38 1,646.38
Julieta Lopez NW1 Washington Physicians, Inc. 89,107 2% 1,782.14 1,782.14
Marques Quarles NE2 Baltimore Bariatrics, Inc. 300,708 6% 18,042.48 18,042.48
Marques Quarles NE1 Connecticut Pulmonary Associates, Inc. 103,301 2% 2,066.02 2,066.02
Marques Quarles NE2 DC Dialysis 162,202 4% 6,488.08 6,488.08
Marques Quarles NE2 Delaware Dental Associates 215,609 6% 12,936.54 12,936.54
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28 6,636.28
Marques Quarles NE2 Maryland Pharmacies, Inc. 209,708 6% 12,582.48 12,582.48
Marques Quarles NE1 Maine Medical Associates, Inc. 165,907 4% 6,636.28 6,636.28
Marques Quarles NE2 Rhode Island Gastroenterology, Inc. 91,708 2% 1,834.16 1,834.16
Matthew Schmidt NW2 Bellevue Bariatics, Inc. 152,101 4% 6,084.04 6,084.04
Matthew Schmidt NW2 Boise Oncology 108,878 2% 2,177.56 2,177.56
Matthew Schmidt NW2 Casper Cardiology, Inc. 207,555 6% 12,453.30 12,453.30
Matthew Schmidt NW2 Cheyenne Cardiologists, Inc. 114,411 2% 2,288.22 2,288.22
Matthew Schmidt NW2 ID Internal Medicine Associates 185,272 4% 7,410.88 7,410.88
Matthew Schmidt NW2 Laramie EMTs, Inc. 201,211 6% 12,072.66 12,072.66
Matthew Schmidt NW2 WY OBGyn, Inc. 176,168 4% 7,046.72 7,046.72
Matthew Schmidt NW2 Wyoming Health Care, Inc. 111,111 2% 2,222.22 2,222.22
Xin Zhu SE2 Low County Medical Associates, Inc. 82,625 2% 1,652.50 1,652.50
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08 6,073.08
Xin Zhu SE2 Orthopaedic Medical Associates 87,773 2% 1,755.46 1,755.46
Xin Zhu SE2 Palmetto Physicans 165,700 4% 6,628.00 6,628.00
Xin Zhu SE2 Palmetto Podiatrists, Inc. 82,935 2% 1,658.70 1,658.70
Xin Zhu SE2 Piedmont Health Associates, Inc. 98,333 2% 1,966.66 1,966.66
Xin Zhu SE2 SC Medical Associates 115,272 2% 2,305.44 2,305.44
Xin Zhu SE2 Upstate Pharmacies, Inc. 89,695 2% 1,793.90 1,793.90
Xin Zhu SE2 NC Medical Associates 151,827 4% 6,073.08 6,073.08

PivotTable

Row Labels Sum of Annual Sales Sum of Commission Earned
Ambulatory Care of TX, Inc. $ 156,208 $ 6,248
AZ Ambulatory Care $ 91,222 $ 1,824
Baltimore Bariatrics, Inc. $ 200,708 $ 12,042
Bama Chiropractic Clinics, Inc. $ 310,932 $ 12,437
Bellevue Bariatics, Inc. $ 152,101 $ 6,084
Boise Oncology $ 108,878 $ 2,178
CA Chiropractic Associates, Inc. $ 107,373 $ 2,147
Casper Cardiology, Inc. $ 207,555 $ 12,453
Cheyenne Cardiologists, Inc. $ 114,411 $ 2,288
CO Pharmacies, Inc. $ 106,266 $ 2,125
Connecticut Pulmonary Associates, Inc. $ 103,301 $ 2,066
DC Dialysis $ 162,202 $ 6,488
Delaware Dental Associates $ 215,609 $ 12,937
Emergency Medicine Association $ 115,609 $ 2,312
EMTS of CO, Inc. $ 152,686 $ 6,107
Garden State Pharmacies $ 122,222 $ 2,444
Gerontology Associates of MS $ 127,555 $ 2,551
ID Internal Medicine Associates $ 185,272 $ 7,411
Internal Medicine of MS $ 169,272 $ 6,771
Joint Healthcare Associates $ 142,734 $ 5,709
LA Cardiologists, Inc. $ 162,777 $ 6,511
Laramie EMTs, Inc. $ 201,211 $ 12,073
Lone Star Medicine $ 133,991 $ 2,680
Louisiana Dermatologists, Inc. $ 118,118 $ 2,362
Low County Medical Associates, Inc. $ 82,625 $ 1,653
MA OBGyn Associates $ 128,979 $ 2,580
Maine Medical Associates, Inc. $ 331,814 $ 13,273
Maryland Pharmacies, Inc. $ 209,708 $ 12,582
MD Dental Associates $ 133,288 $ 2,666
MS Women's Clinics, Inc. $ 133,288 $ 2,666
NC Medical Associates $ 303,654 $ 12,146
Nephrology Associates, Inc. $ 87,556 $ 1,751
New England Pharmacies, Inc. $ 91,995 $ 1,840
New England Physicians, Inc. $ 97,489 $ 1,950
NM Pharmacies, Inc. $ 115,975 $ 2,320
NV Emergency Medical Associates, Inc. $ 114,111 $ 2,282
OBGyn Associates of Montana, Inc. $ 88,888 $ 1,778
OK Clinics $ 105,767 $ 2,115
Oregon Opthamology, Inc. $ 96,606 $ 1,932
Orthodontial, Inc. $ 83,363 $ 1,667
Orthopaedic Medical Associates $ 87,773 $ 1,755
PA Medical Practices, Inc. $ 88,878 $ 1,778
Palmetto Physicans $ 165,700 $ 6,628
Palmetto Podiatrists, Inc. $ 82,935 $ 1,659
Pharmacies of Nevada, Inc. $ 115,234 $ 2,305
Physicians of MS, Inc. $ 141,111 $ 5,644
Piedmont Health Associates, Inc. $ 98,333 $ 1,967
Rhode Island Gastroenterology, Inc. $ 91,708 $ 1,834
SC Medical Associates $ 115,272 $ 2,305
Seattle Psychiatric Associates, Inc. $ 97,443 $ 1,949
Seattle Psychologists, Inc. $ 97,002 $ 1,940
Southwest Dermatology $ 108,277 $ 2,166
Southwest Medical Associates $ 82,651 $ 1,653
TEX-MEX Pharmacies, Inc. $ 153,848 $ 6,154
Tri-state Pharmacies $ 87,442 $ 1,749
Upstate Pharmacies, Inc. $ 89,695 $ 1,794
Utah Urology Associates, Inc. $ 82,319 $ 1,646
Washington Physicians, Inc. $ 89,107 $ 1,782
Women's Medicine of FL, Inc. $ 109,333 $ 2,187
WY OBGyn, Inc. $ 176,168 $ 7,047
Wyoming Health Care, Inc. $ 111,111 $ 2,222
Grand Total $ 8,144,659 $ 261,614

PivotChart

Row Labels Sum of Annual Sales
Ahjab $ 662,851
Anderson $ 851,283
Brown $ 1,272,386
Johansen $ 1,125,667
Lopez $ 634,728
Quarles $ 1,315,050
Schmidt $ 1,256,707
Zhu $ 1,025,987
Grand Total $ 8,144,659

Total Ahjab Anderson Brown Johansen Lopez Quarles Schmidt Zhu 662851 851283 1272386 1125667 634728 1315050 1256707 1025987