Overclock.net banner
1 - 3 of 3 Posts

17 Posts
Discussion Starter · #1 ·
I made this spreadsheet up to help me quickly and visually pick values that would be within my own "target" ranges, and I thought it might come in handy for others as well.

You can set up the way it works in the yellow cells at the top, and then the rest of the table will change colours accordingly.

Attachment 189739


Pick a target range for each of BCLK / CPU / DRAM up the top ("Target Lo" to "Target Hi"), and corresponding values will be marked in green in the table. Add in the lowest you would consider ("Minimum Lo") and values down to that will be in yellow. Add in a "Extended Hi" and values up to that (above the top of your green values) will be in light blue.

Then all you do is find a row which has the values you want in green. Preferably with a bit of green either side, so you have some room to move.

If you want to make the table a bit smaller vertically then change the BCLK Delta value (it will range down from the "BCLK Hi" value in steps of that size, and will always include the BCLK Standard value even if it's not naturally in the step interval)

Practical Example

I have it set up for my intended targets for my system (first OC build). Intel i7 980X with Noctua NH-D14 air cooling on a Asus P6X58D Premium with 12GB G.Skill Ripjaws DDR3-1600 DRAM (3 x 4GB).

I followed Miahallen's Guide to Overclocking, and found the BCLK for my board seemed ok up to 210 (overnight IBT test), so I set that as the top of my table ("BCLK Hi"). I tested my DRAM and found it OK up to it's rated speed 1600 so I set that as my upper target ("DRAM Target Hi"), and 1333 (arbitrary) as the lowest target in "DRAM Target Lo" (the Minimum and Extended DRAM targets were arbitrarily small distance away from these).

AFTER I had determined these individual limits, I set up this spreadsheet:

I wanted to get my CPU to over 4GHz, so that was my Target Lo for CPU, and I figured a reasonable upper target (for my air cooling) based on what I had read through the forums was probably 4350MHz. I put an Extended Hi target for the CPU as 4650MHz, not that I would expect to achieve that on air (at least not with any stability, and probably not without cooking my i7 980x CPU during a stability test)

The CPU Multi Lo just sets where the multiplier starts, same for the DRAM one. My board seemed to only have even DRAM multipliers, if that's not the case for everyone then let me know and I will add in a DRAM Multi Delta as well (presently effectively fixed at "2")

I picked the x23 CPU multiplier in the table, as it put my DRAM into a mild underclock, and the range of "green" for the CPU multi corresponded to the "green" range for DRAM. I intend to tighten timings in future, and I read that with 12GB as 3 x 4GB it is probably pushing it to expect it to go past 1600MHz.

For example a potentially problematic multiplier would have been x26 which (aside from being even) would mean if I managed to push past about 4186MHz I would suddenly go from having my DRAM run at 1600 to running it really slow (based on what I considered "acceptable" for the DRAM)

Anyway on a x23 multiplier so far I have got up to 4140MHz which is stable based on 50 runs of LinX at "All Mem" settings (problem size 37568), followed by 30 hours of Prime95 Torture Test. I will post my full build log + process in another thread.

Anyway, suggestions for improvements to the spreadsheet are welcome. Hope someone finds this useful.
1 - 3 of 3 Posts
This is an older thread, you may not receive a response, and could be reviving an old thread. Please consider creating a new thread.