Author:
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. New Perspectives Excel 2016 | Module 5: SAM Project 1a Forge and Polish Jewelry
WORKING WITH EXCEL TABLES, PIVOTTABLES, AND PIVOTCHARTS
Brandon Jimenez ot edit this sheet. If your name does not appear in cell B6, please download a new copy of the file
from the SAM website. Material
Gold Silver Copper Total Result Data
Product ID Sum - 2018Sum - 2019Sum - 2020
$2,610
$3,710
$6,400
BGGB-104
$890
$480
$1,990
BGGB-117
$120
$1,780
$1,490
BGGB-147
$1,180
$920
$1,300
BGPS-194
$420
$530
$1,620
$1,590
$4,010
$4,390
BSPP-144
$240
$470
$1,250
BSPS-136
$70
$1,800
$1,380
BSPS-142
$1,280
$1,740
$1,760
$3,740
$3,350
$3,370
BCPP-182
$1,910
$1,200
$1,380
BCPS-117
$800
$590
$340
BCPS-132
$1,030
$1,560
$1,650
$7,940 $11,070
$14,160 Forge and Polish Jewelry
Sales Records - 2018 - 2020
Product ID
BGGB-147
BGGB-104
BGGB-117
BCPP-182
BSPP-144
BCPS-117
BCPS-132
BGPS-194
BSPS-142
BSPS-136
Total Type
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet
Bracelet Material
Gold
Gold
Gold
Copper
Silver
Copper
Copper
Gold
Silver
Silver Embellishment
Glass Beads
Glass Beads
Glass Beads
Pearl
Pearl
Precious Stones
Precious Stones
Precious Stones
Precious Stones
Precious Stones 2018
$1,180
$890
$120
$1,910
$240
$800
$1,030
$420
$1,280
$70
Err:508 2019
$920
$480
$1,780
$1,200
$470
$590
$1,560
$530
$1,740
$1,800
Err:508 2020
$1,300
$1,990
$1,490
$1,380
$1,250
$340
$1,650
$1,620
$1,760
$1,380
Err:508 Forge and Polish Jewelry
Sales Records - 2018 - 2020
Product ID
NSPP-128
NSPP-242
NSGB-147
NSPS-143
NCPS-145
NCPS-223
NCPS-171
NCPS-178
NCGB-215
NCGB-223
NGGB-171
NSGB-196
NSPP-157
NGPP-119
NGPS-123 Type
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace
Necklace Material
Silver
Silver
Silver
Silver
Copper
Copper
Copper
Copper
Copper
Copper
Gold
Silver
Silver
Gold
Gold Embellishment
Pearl
Pearl
Glass Beads
Precious Stones
Precious Stones
Precious Stones
Precious Stones
Precious Stones
Glass Beads
Glass Beads
Glass Beads
Glass Beads
Pearl
Pearl
Precious Stones 2018
$680
$680
$340
$580
$1,610
$1,710
$760
$1,250
$1,070
$260
$340
$0
$780
$1,890
$1,820 2019
$20
$280
$420
$1,830
$220
$570
$1,250
$1,120
$800
$1,900
$1,370
$1,410
$260
$600
$1,900 2020
$1,340
$1,550
$1,420
$860
$90
$1,630
$980
$1,540
$310
$630
$1,650
$1,130
$580
$1,570
$2,160 Forge and Polish Jewelry
Sales Records - 2018 - 2020
Product ID
ECPS-154
ECPP-234
ECPB-177
ECPS-155
ECPP-138
ECPB-191
ECPS-189
ECPP-227
ECPS-126
ECPP-213 Type
Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring EGPP-152
EGPP-241
EGPP-203
EGPS-193
EGPS-246
EGPP-126
EGPS-119
EGPB-128
EGPP-196
EGPP-140 Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring
Earring ESPP-242
ESPP-144
ESPP-149 Earring
Earring
Earring Material
Copper
Copper
Copper
Copper
Copper
Copper
Copper
Copper
Copper
Copper
Copper Total
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold Total
Silver
Silver
Silver
Silver Total
Grand Total Embellishment
Precious Stones
Pearl
Glass Beads
Precious Stones
Pearl
Glass Beads
Precious Stones
Pearl
Precious Stones
Pearl
Pearl
Pearl
Pearl
Precious Stones
Precious Stones
Pearl
Precious Stones
Glass Beads
Pearl
Pearl
Pearl
Pearl
Pearl 2018
$1,290
$1,150
$240
$870
$1,540
$1,180
$1,520
$210
$1,230
$1,140
$10,370
$1,900
$1,360
$330
$720
$940
$1,230
$280
$1,850
$320
$1,090
$10,020
$1,920
$1,470
$870
$4,260
$24,650 2019
$850
$650
$480
$730
$850
$600
$1,770
$710
$550
$1,930
$9,120
$1,760
$1,800
$930
$1,770
$950
$1,460
$1,440
$440
$1,480
$120
$12,150
$610
$690
$300
$1,600
$22,870 2020
$70
$240
$1,110
$900
$1,940
$40
$560
$1,100
$560
$1,170
$7,690
$800
$660
$1,890
$1,770
$120
$1,390
$1,700
$1,790
$850
$370
$11,340
$850
$1,900
$620
$3,370
$22,400 Forge and Polish Jewelry
Sales Records - 2018 - 2020
Product ID
RSPS-126
RGGB-200
RGPP-137
RGPP-103
RCGB-201
RSPS-228
RGPS-151
RGPS-215
RGGB-210
RCGB-224
RSPS-161
RSGB-170 Type
Ring
Ring
Ring
Ring
Ring
Ring
Ring
Ring
Ring
Ring
Ring
Ring Material
Silver
Gold
Gold
Gold
Copper
Silver
Gold
Gold
Gold
Copper
Silver
Silver Embellishment
Precious Stones
Glass Beads
Pearl
Pearl
Glass Beads
Precious Stones
Precious Stones
Precious Stones
Glass Beads
Glass Beads
Precious Stones
Glass Beads 2018
$1,580
$1,590
$1,080
$980
$920
$1,790
$20
$1,250
$1,230
$1,110
$1,300
$1,650 2019
$1,700
$1,360
$1,650
$1,880
$1,080
$340
$480
$1,980
$1,260
$510
$1,300
$1,190 2020
$430
$1,190
$130
$100
$600
$270
$1,810
$1,340
$430
$410
$1,680
$80 Forge and Polish Jewelry
Sales Records - 2018 - 2020
Product ID
RGPP-103
RGPP-137
EGPP-140
EGPP-241
EGPP-152
EGPP-196
EGPP-126
NGPP-119
EGPP-203 Type
Ring
Ring
Earring
Earring
Earring
Earring
Earring
Necklace
Earring Material
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold
Gold Embellishment
Pearl
Pearl
Pearl
Pearl
Pearl
Pearl
Pearl
Pearl
Pearl 2018
$980
$1,080
$1,090
$1,360
$1,900
$320
$1,230
$1,890
$330 2019
$1,880
$1,650
$120
$1,800
$1,760
$1,480
$1,460
$600
$930 2020
$100
$130
$370
$660
$800
$850
$1,390
$1,570
$1,890 Type
Bracelet Earring Necklace Data
Product ID Sum - 2018Sum - 2019Sum - 2020
$7,940 $11,070 $14,160
BCPP-182
$1,910
$1,200
$1,380
BCPS-117
$800
$590
$340
BCPS-132
$1,030
$1,560
$1,650
BGGB-104
$890
$480
$1,990
BGGB-117
$120
$1,780
$1,490
BGGB-147
$1,180
$920
$1,300
BGPS-194
$420
$530
$1,620
BSPP-144
$240
$470
$1,250
BSPS-136
$70
$1,800
$1,380
BSPS-142
$1,280
$1,740
$1,760
$24,650 $22,600 $22,400
ECPB-177
$240
$480
$1,110
ECPB-191
$1,180
$600
$40
ECPP-138
$1,540
$580
$1,940
ECPP-213
$1,140
$1,930
$1,170
ECPP-227
$210
$710
$1,100
ECPP-234
$1,150
$650
$240
ECPS-126
$1,230
$550
$560
ECPS-154
$1,290
$850
$70
ECPS-155
$870
$730
$900
ECPS-189
$1,520
$1,770
$560
EGPB-128
$1,850
$440
$1,790
EGPP-126
$1,230
$1,460
$1,390
EGPP-140
$1,090
$120
$370
EGPP-152
$1,900
$1,760
$800
EGPP-196
$320
$1,480
$850
EGPP-203
$330
$930
$1,890
EGPP-241
$1,360
$1,800
$660
EGPS-119
$280
$1,440
$1,700
EGPS-193
$720
$1,770
$1,770
EGPS-246
$940
$950
$120
ESPP-144
$1,470
$690
$1,900
ESPP-149
$870
$300
$620
ESPP-242
$1,920
$610
$850
$13,770 $13,950 $16,955
NCGB-215
$1,070
$800
$310
NCGB-223
$260
$1,900
$630
NCPS-145
$1,610
$220
$90
NCPS-171
$760
$1,250
$980
NCPS-178
$1,250
$1,120
$1,540
NCPS-223
$1,710
$570
$1,630
NGGB-171
$340
$1,370
$1,650 NGPP-119
NSGB-147
NSGB-196
NSPP-128
NSPP-157
NSPP-242
NSPS-143
NGPS-123
Ring
Total Result $1,890
$340
$0
$680
$780
$680
$580
$1,820
$14,500
$60,860 $600
$420
$1,410
$20
$260
$280
$1,830
$1,900
$14,730
$62,350 $1,570
$1,420
$1,130
$1,340
$580
$1,550
$860
$1,675
$8,470
$61,985 Material
Gold Type
Bracelet
Earring Data
Sum - 2018Sum - 2019Sum - 2020
$2,610
$10,020 $3,710
$12,150 $6,400
$11,340 Silver $40,000
$35,000 Bracelet
Earring $1,590
$4,260 $4,010
$1,600 $4,390
$3,370 Copper $30,000
$25,000 Bracelet
Earring
Total Result Sales by Mate $3,740
$10,370
$32,590 $3,350
$8,850
$33,670 $3,370
$7,690
$36,560 $20,000
$15,000
$10,000
$5,000
$0 Gold Silver Copper
Type Sum - 2018 Sales by Material lver Copper
Type Sum - 2018 Total Result
Sum - 2019

 

• 1496733997-Report.xlsx
• 1496734006-Instructions_NP_EX16_5a.docx

SuperTutor

(15)

Status NEW Posted 06 Jun 2017 07:06 AM My Price 20.00

-----------

Attachments

file 1496734012-Solutions file.docx preview (51 words )

S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------

Not Rated(0)

• Buy Answer