Overclock.net › Forums › Intel › Intel CPUs › Spreadsheet to help picking BCLK / CPU Multi / DRAM Multi
New Posts  All Forums:Forum Nav:

Spreadsheet to help picking BCLK / CPU Multi / DRAM Multi

post #1 of 3
Thread Starter 
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

Usage

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.

Edited by scubadiver - 1/12/11 at 4:37pm
Mako
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 980X @ 4.14 HT 1.352V 180x23 Asus P6X58D Premium Gigabyte HD5870 Eyefinity 6 12GB G.Skill DDR3-1600 (3x4GB) F3-12800CL9T-12GBRL 
Hard DriveOSMonitorPower
Crucial RealSSD 256GB Windows 7 Ultimate x64 Dell 30" with 2 x Samsung SyncMaster 204B "wings" Coolermaster Silent Pro 1000W 80+ Gold 
Case
Lian Li PC-B25S 
  hide details  
Reply
Mako
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 980X @ 4.14 HT 1.352V 180x23 Asus P6X58D Premium Gigabyte HD5870 Eyefinity 6 12GB G.Skill DDR3-1600 (3x4GB) F3-12800CL9T-12GBRL 
Hard DriveOSMonitorPower
Crucial RealSSD 256GB Windows 7 Ultimate x64 Dell 30" with 2 x Samsung SyncMaster 204B "wings" Coolermaster Silent Pro 1000W 80+ Gold 
Case
Lian Li PC-B25S 
  hide details  
Reply
post #2 of 3
great idea
Centurion
(14 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II 940 @3.3GHz 1.25V Gigabyte 790X-DS4 XFX 5850 8GB OCZ DDR2-800 
Hard DriveCoolingOSMonitor
Corsair Force 3 TRUE Win 7 Pro x64 ACER 23" TN  
PowerCase
400W Silverstone Strider Antec P182 
  hide details  
Reply
Centurion
(14 items)
 
  
CPUMotherboardGraphicsRAM
Phenom II 940 @3.3GHz 1.25V Gigabyte 790X-DS4 XFX 5850 8GB OCZ DDR2-800 
Hard DriveCoolingOSMonitor
Corsair Force 3 TRUE Win 7 Pro x64 ACER 23" TN  
PowerCase
400W Silverstone Strider Antec P182 
  hide details  
Reply
post #3 of 3
Thread Starter 
Thanks. I have added a little screenshot so that people can quickly see roughly what it looks like without having to download the Excel file itself. There are no macros in it.
Mako
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 980X @ 4.14 HT 1.352V 180x23 Asus P6X58D Premium Gigabyte HD5870 Eyefinity 6 12GB G.Skill DDR3-1600 (3x4GB) F3-12800CL9T-12GBRL 
Hard DriveOSMonitorPower
Crucial RealSSD 256GB Windows 7 Ultimate x64 Dell 30" with 2 x Samsung SyncMaster 204B "wings" Coolermaster Silent Pro 1000W 80+ Gold 
Case
Lian Li PC-B25S 
  hide details  
Reply
Mako
(13 items)
 
  
CPUMotherboardGraphicsRAM
i7 980X @ 4.14 HT 1.352V 180x23 Asus P6X58D Premium Gigabyte HD5870 Eyefinity 6 12GB G.Skill DDR3-1600 (3x4GB) F3-12800CL9T-12GBRL 
Hard DriveOSMonitorPower
Crucial RealSSD 256GB Windows 7 Ultimate x64 Dell 30" with 2 x Samsung SyncMaster 204B "wings" Coolermaster Silent Pro 1000W 80+ Gold 
Case
Lian Li PC-B25S 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Intel CPUs
Overclock.net › Forums › Intel › Intel CPUs › Spreadsheet to help picking BCLK / CPU Multi / DRAM Multi