Build Pricing Spreadsheet

[SeanWilkes87]

Hello people,
 
I am creating a spreadsheet that breaks down the percentage of your dollar for each component you will buy for your new build. It lists motherboard, CPU, GPU, RAM, HDD/SSD, Case, PSU & peripherals. You just type in the minimum and maximum you are willing to spend and it calculates your price point minimum and maximum for your build.
 
I am posting this here because I would like for anyone with more experience than I have (which is about everyone here) to chime in and see if I have appropriately divided the percentages correctly.

 

Motherboard 12.5%

CPU              17.5%

GPU              21.0%

RAM              13.0%

HDD/SSD        8.0%

Case              14.0%

Peripherals      4.0%

 

Also here is a PCPartPicker setup I created from this spreadsheet based on a $1000 maximum build  

http://pcpartpicker.com/p/gcWkK8

[Tedster]

I don't think it's a good idea charting it like this because you could game pretty darn well on the Pentium G3258 ($50) and a cheap motherboard ($30 if you were lucky), with a pretty good graphics card.

[MrChavelo]

More like

 

Motherboard: 12.5%

CPU: 17.5%

GPU: 30%

RAM: 12.5%

HDD/SSD: 12.5%

Case: 7.5%

Peripherals: 7.5%

 

 

But what about the PSU?

[ImBleu]

I'd give a lot less to Case and through that towards the CPU and GPU. I also feel RAM is given too much. I have like $100 of Ram and a $300 CPU, not quite 17.5% / 13%.

[ImBleu]

More like

 

Motherboard: 12.5%

CPU: 17.5%

GPU: 30%

RAM: 12.5%

HDD/SSD: 12.5%

Case: 7.5%

Peripherals: 7.5%

 

 

But what about the PSU?

 

Maybe it was included with the Case. All I could think of to justify 14% on the Case.

[WereCat]

Hmm I tried but I come to conclusion that I cant do percentages. If I have budget $1000 for PC then the percentages will be a lot different than if I had $500 or $3000 budget.

 

Example:

In $3000 budget 50% would be GPU

In $500 budget 20-25% would be GPU

[ZetZet]

In my case motherboad - whatever is left fk it. Definitely not going to spend more on motherboard that on storage. 

And 17,5% on cpu 12,5% on mobo? Are you high?

[martward]

It really depends on the type of build, the build I am planning is about

 

Motherboard: 10%

CPU: 25%

GPU: 15%

RAM: 10%

HDD/SSD: 20%

Case: 20%

Peripherals: 0% (I stick with what I've got for yeeeaars)

[SeanWilkes87]

Sorry thought i added PSU I gave that 10%

 

We have nothing to do today at work and just finding things to do lol.

[SeanWilkes87]

More like

 

Motherboard: 12.5%

CPU: 17.5%

GPU: 30%

RAM: 12.5%

HDD/SSD: 12.5%

Case: 7.5%

Peripherals: 7.5%

 

 

But what about the PSU?

 

I came up with a model really close to this that came up with some pretty interesting builds in PCPartPicker with budgets as low as $250 all the way up to $1,500

 

I went:

 

Motherboard: 12.5

CPU: 17.5

GPU: 30%

RAM: 12.5%

HDD/SSD: 12.5%

Case 8.5%

PSU: 6.5%

 

I removed the peripherals because most of us have those things laying around.

[CatzRuleZWorld]

It all depends on what you're wanting out of it. If you are only gaming then 2.5 times the CPU price should be spent on the GPU but if you're wanting more CPU power you could have them cost the same. The motherboard is something that doesn't really work that dynamically. You get a $50-$60 motherboard for a <$600 build and you get a $90-$150 motherboard on anything above that. Unless you're going for looks or specific features that's all your options pretty much. The only thing like this that would be useful is if you put in a bunch of "if"s in there and made it tell you what kind of thing to get. Like if(CPU<=$150,H81 motherboard, Z97)