Jump to content

ecstasy

US DVD SALES CHART WEEK ENDING DECEMBER 25, 2011 (PG 7)

By ecstasy, in Home Theater Cinema

Recommended Posts





Fake Global Phenomenon

Fake

Posted
Posted

Let's say you want to import a table into Excel.You go to Excel -> Data -> From Web. In the dialog box, you enter the URL of the web page which has the table. Excel automatically recognizes all possible tables. You will see a bunch of yellow marks throughout the page. Click the one on the top-left corner of the desired table. And that's it, table will be imported into Excel.I am gonna be away for another week or so, and can't do all this on my phone, so if you can do it then it would be great.

Link to comment
Share on other sites


rockNrollaDIM Global Phenomenon

rockNrollaDIM

Posted
Posted

Let's say you want to import a table into Excel.You go to Excel -> Data -> From Web. In the dialog box, you enter the URL of the web page which has the table. Excel automatically recognizes all possible tables. You will see a bunch of yellow marks throughout the page. Click the one on the top-left corner of the desired table. And that's it, table will be imported into Excel.I am gonna be away for another week or so, and can't do all this on my phone, so if you can do it then it would be great.

Oh, didn't know Excel had that feature, that's awesome.Give me the URL and I'll play around with it today. Would you want me to post it somewhere or just send it to you?
Link to comment
Share on other sites
Fake Global Phenomenon

Fake

Posted
Posted
http://www.homemediamagazine.com/list/research/top-sellers-45It has links to the weekly sales reports published by Nielsen Videoscan. You open a link and then click on the 'Top 20 selling Blu-ray disc for the week' link. This page will contain the ratio with the highest-selling movie given an index of 100.00 .Put these URLs into Excel and get the table. For some reason, it doesn't recognize that table in my PC. If the same happens to you, just select the whole page (the yellow mark in the top-left). Excel will take some time and might become 'Not Responding' for a few seconds but it will come ultimately. Then delete the top and bottom few rows (which ones you will know when you see it)..We will need these reports starting May 1, 2011. Just put all those tables into one excel file and then upload it on Google Docs and send me a PM with the link.Now that we will have the ratios, all we will need is the sales figures for any one movie from the list of a particular week and all the rest can be calculated. Since the-numbers doesn't have an archive for that, we will have to search manually for those tables with Google. Leave that to me. Then it is just a matter of adding those numbers movie-wise.I won't be back to my PC till Tuesday or Wednesday so take your time. :)
Link to comment
Share on other sites


ecstasy Global Phenomenon

ecstasy

Posted
  • Author
Posted

http://www.homemedia.../top-sellers-45It has links to the weekly sales reports published by Nielsen Videoscan. You open a link and then click on the 'Top 20 selling Blu-ray disc for the week' link. This page will contain the ratio with the highest-selling movie given an index of 100.00 .Put these URLs into Excel and get the table. For some reason, it doesn't recognize that table in my PC. If the same happens to you, just select the whole page (the yellow mark in the top-left). Excel will take some time and might become 'Not Responding' for a few seconds but it will come ultimately. Then delete the top and bottom few rows (which ones you will know when you see it)..We will need these reports starting May 1, 2011. Just put all those tables into one excel file and then upload it on Google Docs and send me a PM with the link.Now that we will have the ratios, all we will need is the sales figures for any one movie from the list of a particular week and all the rest can be calculated. Since the-numbers doesn't have an archive for that, we will have to search manually for those tables with Google. Leave that to me. Then it is just a matter of adding those numbers movie-wise.I won't be back to my PC till Tuesday or Wednesday so take your time. :)

I'm impressed. You really are into these home media sales figures. I always thought it was an untapped source of interest. Blu-Ray.com has a lot of useful information at times.
Link to comment
Share on other sites




Fake Global Phenomenon

Fake

Posted
Posted

Ok Fake that sounds like a pretty big project and not something I should be doing at work, so I will get to it this weekend at home. I'll let you know when I finish.BTW- do you want it all on one sheet, or create a new tab for each week?

one sheet would be better, one chart below the other.
Link to comment
Share on other sites






ecstasy Global Phenomenon

ecstasy

Posted
  • Author
Posted

US DVD Sales Chart for Week Ending Nov 13, 2011Rank Prev. Rank Title Units this Week % Change Total Units Sales this Week Total Sales Weeks in Release1 (-) Harry Potter and the Deathly Hallows, Part 2 2,829,814 -.-% 2,829,814 $42,220,825 $42,220,825 12 (1) Cars 2 764,050 -59.4% 2,647,254 $12,033,788 $41,694,251 23 (-) Barbie: A Perfect Christmas 330,522 -.-% 330,522 $4,624,003 $4,624,003 14 (8) Harry Potter and the Deathly Hallows, Part I 282,415 263.1% 6,088,628 $1,832,873 $81,426,305 315 (-) The Change-up 243,930 -.-% 243,930 $4,639,549 $4,639,549 16 (2) Crazy, Stupid, Love 218,179 -53.6% 688,038 $3,327,230 $10,492,580 27 (3) Water for Elephants 167,525 -59.2% 578,063 $2,626,792 $9,064,028 28 (27) Barbie: Princess Charm School 153,942 1,027.1% 606,793 $2,115,163 $8,090,463 99 (4) Captain America: The First Avenger 153,376 -42.2% 1,120,101 $2,759,234 $19,659,782 310 (12) The Twilight Saga: Eclipse 134,416 121.7% 8,329,733 $2,082,104 $151,126,756 4911 (18) Harry Potter and the Half-Blood Prince 112,627 216.4% 9,172,916 $449,382 $117,381,387 10112 (-) The Original Television Christmas Classics 112,434 -.-% - $2,528,641 - 37413 (-) Harry Potter: The Complete 8-Film Collection 98,478 -.-% 98,478 $4,824,437 $4,824,437 114 (-) Harry Potter and the Sorcerer's Stone 94,799 -.-% - $520,447 - 49415 (-) Harry Potter and the Order of the Phoenix 88,856 -.-% 11,492,082 $602,888 $223,370,921 20516 (-) Harry Potter and the Chamber of Secrets 86,026 -.-% - $601,322 - 44917 (10) Bridesmaids 85,177 32.3% 2,275,950 $1,361,980 $36,357,651 818 (6) Green Lantern 78,386 -9.7% 827,591 $1,175,006 $12,450,485 519 (-) Harry Potter and the Prisoner of Azkaban 77,254 -.-% - $1,041,384 - 36420 (11) Bad Teacher 75,458 20.0% 506,363 $1,357,489 $9,046,964 421 (-) Harry Potter and the Goblet of Fire 73,989 -.-% 11,104,331 $872,330 $217,408,633 29722 (9) Transformers: Dark of the Moon 67,398 -3.3% 1,863,318 $1,178,791 $33,307,056 723 (22) X-Men: First Class 61,738 203.6% 1,165,144 $616,763 $19,993,465 1024 (5) Winnie the Pooh 58,577 -34.9% 332,797 $1,010,453 $5,813,129 325 (7) Horrible Bosses 49,294 -42.2% 814,576 $738,917 $12,707,695 526 (13) Fast Five 44,550 -24.2% 1,416,626 $756,905 $23,390,602 627 (15) Monte Carlo 38,768 -19.6% 295,439 $666,422 $5,027,262 428 (16) Zookeeper 32,543 -24.0% 496,478 $576,011 $8,728,621 529 (19) Thor 26,600 -15.9% 1,039,203 $473,214 $17,967,847 930 (29) Rio 25,911 91.0% 2,782,024 $388,406 $42,037,167 15http://www.the-numbers.com/dvd/charts/weekly/thisweek.php

Link to comment
Share on other sites










Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.


×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use and Guidelines. Feel free to read our Privacy Policy as well.

  I accept