New Perspectives Excel 2019 | Module 11: SAM Project 1b

Romano Collectibles
CREATE ADVANCED PIVOTTABLES AND USE DATABASE FUNCTIONS

Author: Jinrui Dong

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.
 Romano Collectibles
Storage
ID Item Category Location Condition
CM-4096 Amazing Spider Man #301 Comic books Bin 12 Near Mint
CM-4103 Wolverine #2 Comic books Bin 14 Good
CO-5066 Jefferson 1938 nickel Coins Bin 4 Good
CM-4188 The Infinity Gauntlet Comic books Bin 13 Very Good
CO-5104 Roosevelt 1947 dime Coins Bin 4 Very Good
CO-5113 Olympics 1984 dollar Coins Bin 3 Mint
MO-3027 Academy Award poster 1999 Movies Bin 10 Good
MO-3045 Indiana Jones storyboard Movies Bin 10 Good
SP-1751 Topps 1991 baseball cards Sports Bin 1 Very Good
CM-4209 Avengers #690 Comic books Bin 12 Very Good
CO-5218 Roosevelt 1951 dime Coins Bin 4 Near Mint
CO-5197 Liberty 1986 dollar Coins Bin 3 Very Good
SP-1854 Signed mini helmet Sports Bin 2 Near Mint
SP-1890 Game football Sports Bin 2 Very Good
TO-2011 Table-top pinball Toys Bin 7 Very Good
CM-4242 Venom #1 Comic books Bin 14 Near Mint
CO-5276 Delaware 1999 quarter Coins Bin 4 Very Good
MO-3153 Star Wars store display Movies Bin 11 Very Good
SP-1904 Framed pitchers panel Sports Bin 3 Very Good
SP-1922 NBA trading cards Sports Bin 1 Very Good
SP-1957 Game used floor card Sports Bin 3 Near Mint
SP-1961 Champions of golf cards Sports Bin 1 Good
SP-1977 Signed golf ball Sports Bin 2 Very Good
SP-1982 Masters score card Sports Bin 1 Very Good
CO-5303 South Carolina 2000 quarter Coins Bin 4 Near Mint
MO-3209 Back to the Future poster Movies Bin 10 Very Good
MO-3301 Gone with the Wind script Movies Bin 11 Fair
MO-3387 Captain America shield Movies Bin 9 Near Mint
SP-1953 Signed cover Sports Bin 3 Fair
CO-5355 Washington 1945 quarter Coins Bin 4 Near Mint
MO-3412 Christmas Story lamp Movies Bin 8 Very Good
TO-2004 Vintage erector set Toys Bin 5 Near Mint
TO-2033 Wooden blocks Toys Bin 6 Near Mint
les
Purchase
Acquired Price Current Value Category Number Total Value
2016 $250 $365 Comic books 5 $880
2016 $60 $180 Coins 8 $764
2016 $23 $50 Movies 7 $630
2017 $150 $160 Sports 10 $1,231
2017 $75 $250 Toys 3 $390
2017 $20 $49
2017 $65 $75 Current Value
2017 $20 $45 >200
2017 $85 $200 Number of items: 4
2018 $100 $110
2018 $95 $125 Acquired
2018 $57 $120 2020
2018 $125 $150 Number of items: 5
2018 $250 $300
2018 $120 $260 Condition
2019 $65 $65 Near Mint
2019 $17 $25 Total Value: $1,233
2019 $18 $20
2019 $50 $70 Condition
2019 $92 $95 Very Good
2019 $95 $108 Average Value: $140
2019 $50 $50
2019 $100 $108
2019 $80 $80
2020 $14 $20
2020 $140 $140
2020 $25 $45
2020 $100 $145
2020 $66 $70
2021 $95 $125
2021 $150 $160
2021 $24 $100
2021 $20 $30
Average Value
$176
$96
$90
$123
$130
 Romano Collectibles
Current Value Totals Category
Condition Acquired Coins Comic books Movies Sports Toys
Very Good 2017 $250 $160 $200
2018 $120 $110 $300 $260
2019 $25 $20 $353
2020 $140
2021 $160
Good 2016 $50 $180
2017 $120
2019 $50
Fair 2020 $45 $70
Mint 2017 $49
Near Mint 2016 $365
2018 $125 $150
2019 $65 $108
2020 $20 $145
2021 $125 $130
Total Result $764 $880 $630 $1,231 $390
Total Result
$610
$790
$398
$140
$160
$230
$120
$50
$115
$49
$365
$275
$173
$165
$255
$3,895
 Romano Collectibles
Count of Items Acquired
Category 2016 2017 2018 2019 2020 2021 Total Result
Sports 1 2 6 1 10
Coins 1 2 2 1 1 1 8
Movies 2 1 3 1 7
Comic books 2 1 1 1 5
Toys 1 2 3
Total Result 3 6 6 9 5 4 33
 Romano Collectibles
Data
Category Count of ID Purchase Price Totals Current Value Totals Average of Purchase Price
Coins 8 $396 $764 $49
Comic books 5 $625 $880 $125
Movies 7 $518 $630 $74
Sports 10 $993 $1,231 $99
Toys 3 $164 $390 $55
Total Result 33 $2,696 $3,895 $82
ctibles

of Purchase Price
 Romano Collectibles
Purchase Prices Acquired
Category Item 2016 2017 2018 2019 2020 2021 Total Result
Coins
Delaware 1999 quarter $17 $17
Jefferson $23 $23
Liberty 1986 dollar $57 $57
Olympics 1984 d $20 $20
Roosevelt 1947 $75 $75
Roosevelt 1951 dime $95 $95
South Carolina 2000 quarter $14 $14
Washington 1945 quarter $95 $95
Comic books
Amazing $250 $250
Avengers #690 $100 $100
The Infinity Gau$150 $150
Venom #1 $65 $65
Wolverin $60 $60
Movies
Academy Award $65 $65
Back to the Future poster $140 $140
Captain America shield $100 $100
Christmas Story lamp $150 $150
Gone with the Wind script $25 $25
Indiana Jones s $20 $20
Star Wars store display $18 $18
Sports
Champions of golf cards $50 $50
Framed pitchers panel $50 $50
Game football $250 $250
Game used floor card $95 $95
Masters score card $80 $80
NBA trading cards $92 $92
Signed cover $66 $66
Signed golf ball $100 $100
Signed mini helmet $125 $125
Topps 1991 base $85 $85
Toys
Table-top pinball $120 $120
Vintage erector set $24 $24
Wooden blocks $20 $20
Total Result $333 $415 $747 $567 $345 $289 $2,696