Answers.Body: <p><a href="http://brickset.com/sets/">Brickset</a> allows you to export a search as .CSV and appears to include prices for all regularly available sets - this does exclude promotional sets (i.e. in-store, newspaper vouchers, magazine gifts, partner stores, or VIP/special offers) and educational sets (only available through specialist educational retailers), or pick-a-brick/model options.</p>
  
  <p><a href="https://i.sstatic.net/vHjiq.png"><img src="https://i.sstatic.net/vHjiq.png" alt="Export as CSV"></a></p>
  
  <p>Running a quick SUM() over the price columns results in the following totals for 2015 and 2016 as examples - which gives you to total for the sets that were released in those teritories - if you want you can play around with the data yourself to merge the different sets, as well as apply either an average or premium amount (based on the number of bricks) for the promotional sets:</p>
  
  <pre><code>| Year | # Sets |    UK £   |    US $   |   CAN $   |   EUR €   |
  |------|--------|-----------|-----------|-----------|-----------|
  | 2015 |    771 | 12,607.44 | 16,117.06 | 18,364.45 | 14,140.92 |
  | 2016 |    828 | 13,531.21 | 16,915.18 | 19,718.39 | 15,886.59 |
  </code></pre>
  
  <p>As you can see the total number of sets is variable (2011 had only 584 sets for example) so the total price will vary each year.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T11:51:55.543Z
Answers.Text: Very nice! (In case anyone else was wondering, those sums don't necessarily mean that collecting Lego is significantly cheaper in Canada with current exchange rates; apparently some sets aren't available there or there's just missing data.) It also includes a number of things that I didn't mean to include in my question (e.g. video games, stationery).  I will have to spend some time playing around with this. =)
Answers.UserDisplayName: jamesdlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-12-15T10:53:32.597Z
Answers.LastActivityDate: 2016-12-15T10:53:32.597Z
Answers.UserDisplayName: Zhaph - Ben Duguid
Body: <p>I'm curious: has anyone done the math to determine how much it would cost to purchase one of every retail Lego set released each year?</p>
  
  <p>Clarifications:</p>
  
  <ul>
  <li>I don't know if there are sets available in the United States that aren't available in Europe (or vice versa).  Assume United States with USD prices.</li>
  <li>I'm asking about sets newly released that year, not sets from previous years that are still being sold.</li>
  <li>Obviously each year will be different.  Perhaps consider just 2016 and 2015 (and maybe a sampling of others to see what the trend is like).</li>
  </ul>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-12-15T03:52:57.087Z
Comments.Text: Before doing anything else, I would send JANGBRiCKS on youtube a private message and see if he'll respond. He buys just about every set released by TLG to review them (out-of-pocket, too, not sponsored). He might have a good estimate to give you. [Here is Jang's Channel](https://www.youtube.com/user/LEGOJANG)
Comments.UserDisplayName: SlicksterTheBrickster
Tags: <shopping><set-database>
Title: How much would it cost to buy one of every retail LEGO set released in a year?
UserDisplayName: jamesdlin
ThreadText: # How much would it cost to buy one of every retail LEGO set released in a year?
  
  (Asked by: username_0 on 2016-12-15)
  
  I'm curious: has anyone done the math to determine how much it would cost to purchase one of every retail Lego set released each year?
  
  Clarifications:
  
  * I don't know if there are sets available in the United States that aren't available in Europe (or vice versa). Assume United States with USD prices.
  * I'm asking about sets newly released that year, not sets from previous years that are still being sold.
  * Obviously each year will be different. Perhaps consider just 2016 and 2015 (and maybe a sampling of others to see what the trend is like).
  
  **Tags:** shopping, set-database
  
  > **Comments:**
  > **username_1**: Before doing anything else, I would send JANGBRiCKS on youtube a private message and see if he'll respond. He buys just about every set released by TLG to review them (out-of-pocket, too, not sponsored). He might have a good estimate to give you. [Here is Jang's Channel](https://www.youtube.com/user/LEGOJANG)  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-12-15. Score: 19 | Accepted answer
  
  [Brickset](http://brickset.com/sets/) allows you to export a search as .CSV and appears to include prices for all regularly available sets - this does exclude promotional sets (i.e. in-store, newspaper vouchers, magazine gifts, partner stores, or VIP/special offers) and educational sets (only available through specialist educational retailers), or pick-a-brick/model options.
  
  [![Export as CSV](https://i.sstatic.net/vHjiq.png)](https://i.sstatic.net/vHjiq.png)
  
  Running a quick SUM() over the price columns results in the following totals for 2015 and 2016 as examples - which gives you to total for the sets that were released in those teritories - if you want you can play around with the data yourself to merge the different sets, as well as apply either an average or premium amount (based on the number of bricks) for the promotional sets:
  
  ```
  | Year | # Sets |    UK £   |    US $   |   CAN $   |   EUR €   |
  |------|--------|-----------|-----------|-----------|-----------|
  | 2015 |    771 | 12,607.44 | 16,117.06 | 18,364.45 | 14,140.92 |
  | 2016 |    828 | 13,531.21 | 16,915.18 | 19,718.39 | 15,886.59 |
  
  ```
  
  As you can see the total number of sets is variable (2011 had only 584 sets for example) so the total price will vary each year.
  
  > **Comments:**
  > **username_0**: Very nice! (In case anyone else was wondering, those sums don't necessarily mean that collecting Lego is significantly cheaper in Canada with current exchange rates; apparently some sets aren't available there or there's just missing data.) It also includes a number of things that I didn't mean to include in my question (e.g. video games, stationery).  I will have to spend some time playing around with this. =)  
  
  ---
  
  