Pc build advice

I like your spreadsheet

Unless you don't care on spending an additional 1000$, the I7 4790k is definitely in a better spot. Sure, the extra performance is going to be considerable, but then you should just go with the 5930k or better yet the 8 core 5960x. As for gaming, the 4790k will probably outperform the 5xx0k/x, due to it's higher clock rate. For rendering, the haswell-e's will outperform the devils canyon.

PCPartPicker part list / Price breakdown by merchant

CPU: Intel Core i7-4790K 4.0GHz Quad-Core Processor (£243.99 @ Ebuyer)
Motherboard: Asus MAXIMUS VII GENE Micro ATX LGA1150 Motherboard (£142.98 @ Aria PC)
Memory: G.Skill Ripjaws X Series 16GB (2 x 8GB) DDR3-1600 Memory (£108.35 @ CCL Computers)
Storage: Samsung 840 EVO 250GB 2.5" Solid State Drive (£89.72 @ CCL Computers)
Storage: Samsung 840 EVO 250GB 2.5" Solid State Drive (£89.72 @ CCL Computers)
Storage: Western Digital BLACK SERIES 1TB 3.5" 7200RPM Internal Hard Drive (£55.00 @ Amazon UK)
Video Card: Zotac GeForce GTX 980 4GB Video Card (£409.98 @ Ebuyer)
Case: NZXT Switch 810 (White) ATX Full Tower Case (£130.57 @ Scan.co.uk)
Power Supply: SeaSonic X Series 850W 80+ Gold Certified Fully-Modular ATX Power Supply (£140.65 @ CCL Computers)
Optical Drive: Samsung SH-224DB/BEBE DVD/CD Writer (£10.46 @ Aria PC)
Operating System: Microsoft Windows 8.1 (OEM) (64-bit) (£72.35 @ Aria PC)
Total: £1493.77
Prices include shipping, taxes, and discounts when available
Generated by PCPartPicker 2014-11-09 15:31 GMT+0000

Personally I believe I brought you in under budget with what I'd consider to be the better set-up per price/performance for gaming. Now, granted you may have other ideas in mind for what you'd use your processor for, aside from gaming.

It may be better just to go with the 4790K, There will be advantages just from the DDR4 alone if you go with the i7 5820k. One thing to note about the i7 5820k is that the PCI-E bandwidth is not as great as the other Haswell-E Processors. so 28 lanes opposed to the usual 40 fro previous gen Socket-R SKUs. Also when you get the i7 5820k that is the lowest binned processor in the Haswell-E 2011-3. opposed to the highest Binned lga 1150 i7 4790k. I would opt for the i7 5930K if your going to get the X99 platfrom. Everything is going to cost so much anyway, so get the best you can.
 



its enjoyable to make these graphs im not sure why, my primary use will be gaming but i also want to be able to stream; i assumed having more cores would make this better, another reason for going with the 5820k is i was wanting to somewhat future proof my system in regards to the new x99 chipset and ddr4 modules. i went for the reference design so i could hook up a watercool system to my gpu also, is the zotac any better then the model i chose?
 


You should better go with 4790K and GTX 970, the gtx 970 may be replaced in the next 2 years but the CPU is an amazing one, no change will be needed for years.
DDR4 and the new Z170 (LGA 1151) chipset are gonna be high priced in the next few years (i assume 3 years from now and the priced are gonna start to go down and in about 4 kinda "normal")
So you better buy something cheaper now and upgrade in the future without regrets.

What size of case do you want? ATX, MINI, MICRO? because if you are not gonna add a GPU, you should go with MINI/MICRO ART to save some space.
 

I doubt the GTX 970 will get old after two years... it will still be strong enough to run games in two years.
 
The 970 should still be quite viable in 2-3 years. Of course there will most likely be various options that are better suited to individualized needs, at that time. However, it'll still be sporting a progressive architecture that'll make AMD throw their hands up, this time next year. It's not like the 770 is even feeling it's age yet. It just has the issues of the older architecture and it's price/performance doesn't hold a candle to the 970.