Total value of all CGC graded copies of All-American 1-60

[tb]

I did an experiment to calculate the total value of all CGC graded copies of All-American 1-60. I scanned in the guide values as text, pasted them into Excel, did the same with valiantman's census report, and multiplied the two spreadsheets. 45 minutes later, I got the values below (filling in meaningful values where none were listed in the guide). Not very interesting as such, but I do think it would be interesting to correlate the CGC census with other databases, such as values, circulation figures, and age.

 

1 16450

2 1600

3 0

4 0

5 581.25

6 682.5

7 0

8 2600

9 1500

10 0

11 0

12 0

13 495

14 1155

15 390

16 187431.5

17 28599.95

18 14248.5

19 13750

20 8489.25

21 5372.5

22 3220

23 1907.5

24 5206

25 9007.9

26 4162.4

27 16425.25

28 4356

29 4125

30 5885

31 1080.75

32 594

33 1221

34 1674.75

35 610.5

36 1254

37 3902.5

38 330

39 610.5

40 2252.5

41 214

42 535

43 769.25

44 408

45 1893.75

46 1734

47 669

48 0

49 481.5

50 1170.5

51 828

52 3053.25

53 2565

54 1116

55 1725

56 810.75

57 2139

58 903

59 500.25

60 2599

Total: 375285.25

[sfilosa]

Well thet total value of all those issues, is probably less than the total value of all Hulk #181's in CGC 9.6 or higher.

 

So I say buy all the All Americans!!!

[tb]

The table (far) below shows the total guide value for the census population of

Action 1-100 and Amazing Spider-Man 1-100. The first row shows the total number

of submitted copies grouped by grade along with the sum of their guide values.

Since Action 1 skews the values a lot, both the sums for 1-100 and 2-100 are

shown (two last rows).

 

According to Overstreet, the value of the 894 copies of Action Comics are worth

$2,301,509.50, while the 21,739 copies of ASM are worth $8,844,778.20.

 

Grade

10

9.9

9.8

9.6

9.4

9.2

9.0

8.5

8.0

7.5

7.0

6.5

6.0

5.5

5.0

4.5

4.0

3.5

3.0

2.5

2.0

1.8

1.5

1.0

0.5

Total

Action Comics 1-100

Total copies

0

0

4

17

25

26

52

37

52

54

75

67

57

63

63

79

69

43

36

27

17

6

6

9

10

894

Total value (1-100)

0

0

6040.00

30695.00

37260.00

39825.00

73136.00

309085.50

53511.00

231824.25

105761.00

233670.25

45252.00

133850.75

51521.00

140458.75

356024.00

105871.50

187117.50

111460.00

45988.00

1720.00

1438.00

13256.70

3945.60

2301509.50

Total value (2-100)

0

0

6040.00

30695.00

37260.00

39825.00

73136.00

34085.50

53511.00

38136.75

105761.00

92607.75

45252.00

28663.25

51521.00

54396.25

50024.00

38934.00

14992.50

15835.00

7738.00

1720.00

1438.00

15038.40

4066.20

821572.00

ASM 1-100

Total copies

0

2

102

903

1893

2201

2407

2030

2150

1702

1561

1078

917

698

894

768

835

491

425

241

148

82

75

62

74

21739

Total value (1-100)

0.00

1332.00

101608.00

597240.00

1010526.00

1190485.00

1009631.00

918760.50

855370.00

684128.25

549402.00

399548.00

238935.00

210625.25

236240.00

192771.00

224432.00

141295.00

129882.00

66105.00

42811.00

22291.20

12752.50

6916.20

1691.30

8844778.20

Total value (2-100)

0.00

1332.00

50408.00

462840.00

818526.00

998485.00

907756.00

671198.00

654120.00

525728.25

419452.00

264248.00

159885.00

124137.75

146990.00

118183.50

127532.00

68407.50

54657.00

28917.50

13061.00

5291.20

3827.50

2071.20

671.30

6627725.70

[tb]

Another installment: the relation between print run for 4 key DC titles and

the CGC census population (I am trying to learn Excel and am using GA comics

as example data).

 

[sfilosa]

I use Excel all the time for work (and comic analysis). How do you copy the screen (or a chart) into this thread?

[tb]

I haven't figured it out yet so I just used a screen capture. I've seen other people use nice tables (Arty's census of Church books, for example). Please let me know if you find a good way to do it.

[sfilosa]

How do you do the screen capture?

[ultimatevenom]

How do you do the screen capture?

'Print Screen'

 

Just right of F12

[greggy]

How do you do the screen capture?

'Print Screen'

 

Just right of F12

Plus you would have to open up a program like paint and paste the capture into the program. Then you save it as a jpg and voila!

[ultimatevenom]

How do you do the screen capture?

'Print Screen'

 

Just right of F12

Plus you would have to open up a program like paint and paste the capture into the program. Then you save it as a jpg and voila!

[deathlok]

I use Excel all the time for work (and comic analysis). How do you copy the screen (or a chart) into this thread?

 

From Excel, all you have to do is copy the data you want. Then open MSPaint and paste the data you just copied. Useful when copying large portions of data.

 

You can use the "Print Screen" button, but that only copies the data you can see on your screen. If you have a long list of data this won't work.

 

On either method, you then just adjust the image how you want it. You can add in color or highlights as you desire. Then save it as a .jpg file.

[Arty]

No, no ...never save excel screencaptures as jpg.

 

Use .png instead. Its just a fraction of jpg file size with perfect quality (lossless) .

If MSpaint doesn't support that file format, download irfanview...it's a great freeware program.

[Norrin_Radd]

I am trying to learn Excel and am using GA comics as example data

 

I use Excel at work. Let me know if you have any questions about spreadsheet functions or dressing up your charts.

[tb]

This shows the distribution of submissions for the most common value ranges (thanks for the png-tip).