Sign in with
Sign up | Sign in
Your question

Core2Duo CPU and Memory Settings - Excel Tool

Last response: in CPUs
Share
September 18, 2006 7:26:42 PM

I made a really cool excel sheet, if you dont have excel then please feel free to download open office... it works great with this... If you can mirror the file, it would be nice...

Edit: Files on the bellow link do not work right now... we are addressing this issue... if the files do not download for you, please email me at big_green_jelly_bean-=<at>=-yahoo.com Please replace the "-=<at>=-" with "@". This is to help prevent spammers from spamming me:) 

Download Core 2 Duo Settings Finder

---------
It contains 3 sheets...

First Sheet is A complete list of all the FSB, Multipliers, and clockspeeds
Range: Multiplier 15-5 and a huge selection of FSB's

Second Sheet is a "Target CPU Speed." All you do is enter the Target CPU speed, and it gives you all of the Memory Speeds for all the different Memory Multipliers and CPU Multipliers

The Third Sheet is the exact oposite. it is "Target Memory Speed" and all you do is enter the Speed you want your Memory to run at, and it will show you all of the CPU/FSB combinations for each of the memory multipliers.

---------------
I feel this tool will be great for people who might find more fine tuned settings at different Multipliers... Please share your experiances and if you want, please feel free to improve:)  Please no Hijacking or Side Topics.

Please use at your risk.
Mike

Prior Art Protection under copyright and patent law applies.
Other then that... Please Share, Modify, Sell, Claim Ownership and/or use freely.
Please do not give to any alien species triing to take over the world
September 18, 2006 8:33:12 PM

I will give it a try.

I hope this help me with my upcoming build.
Related resources
September 18, 2006 9:36:36 PM

Would be great if you could incorporate some voltage settings into the spreadsheet (if possible). Maybe list the top 3 boards, and top 3 memory modules, and have people drag and drop and select their components, spitting out the answers. Would be nearly impossible for you to do on your own, but maybe work with 9 (3X3) reliable sources to get through it. Just an idea if you're interested in saving the world and have the time. Thanks for the sheet!
September 19, 2006 12:41:54 AM

Unfortunately voltage is one of thoose variables you yourself has to find... I wish I could point to certain settings and then say they will be unreliable, but that is just not the case... Each CPU and Mobo acts and can handle differences...

Mike
September 19, 2006 11:22:48 AM

Quote:
have people drag and drop and select their components, spitting out the answers.


I can't think of a way to make Excel work that way.

Besides, as Green Jelly says, it's not that easy. A certain memory and mobo might work for somebody that uses water cooling, but it won't work for your peltier cooler.
September 19, 2006 11:30:14 AM

Is there someplace where people post working settings? The spreadsheet is interesting, but it just proves how many different combinations there are. Add to that other variables like the memory manufacturer and additional cooling, and the mathematical combinations are staggering.

Me personally, I just want a reliable machine that goes a little faster. It's cool that other people trick their computer out with nitrogen or immerse it in salad oil. I just want my 3D renders a few minutes sooner. I've visited the bleeding edge often, but nobody lives there.

Thanks for putting the spreadsheet out there, Mike. It's cool to lay it all out like that.

Tom
September 19, 2006 1:13:47 PM

Quote:
have people drag and drop and select their components, spitting out the answers.


I can't think of a way to make Excel work that way.

Maybe it's time to go take an Excel class... See, you're not quite as stupid as you think you are. You're proving that the spread sheet approach as currently presented doesn't do the OC job for you. You still have to start at point A, progress to B, etc.

Quote:
Besides, as Green Jelly says, it's not that easy. A certain memory and mobo might work for somebody that uses water cooling, but it won't work for your peltier cooler.


I stand corrected - maybe you ARE as stupid as you think you are...
September 19, 2006 1:39:34 PM

Are you looking for a mirror?

:-D
September 19, 2006 2:53:02 PM

>I stand corrected - maybe you ARE as stupid as you think you are...

Oh, I see. I left the other discussion because you are boring. You felt all alone and came here to pick a fight. Ooooooh, *that's* scary. I would think you are accustomed to being ignored by now.

On the other hand, maybe you're just dumb. I'll type slower. Overclocking requires adequate heat sinking. Therefore, exactly the same motherboard and memory modules will fail with poor heat management, but work with proper heat management. Clear now?

Why do you insist on wearing a light-up Dumb Ass sign? Believe me, your words alone are enough.
September 19, 2006 4:16:57 PM

Quote:
Overclocking requires adequate heat sinking.


What an ignorant statement. Running at stock clock requires adequate heat removal so this requirement is not owned by overclocking. The added heat load from an OC varies hugely from CPU to CPU. For example, bumping my Opty 170 from stock to 2.6 required no change in cooling - because stock cooling was adequate. Go bump a P4 by an equivalent fraction (if you can) and stock cooling won't hack it.

Quote:
Therefore, exactly the same motherboard and memory modules will fail with poor heat management, but work with proper heat management. Clear now?


Don't got try rewriting the context. The earlier post said:

"A certain memory and mobo might work for somebody that uses water cooling, but it won't work for your peltier cooler."

That's a total crock of sh!t in part because it's non-specific. What people in general accomplish by going from air to water to TEC or phase is the ability to run at higher CPU VCore. So if you are capable of getting a decent OC on water (and I seriously doubt that you are) then you're probably running a functional mobo and RAM. By cooling the CPU with something more exotic than water, you typically gain CPU performance, not RAM performance , not mobo performance. Sure, you may be able to hit a different RAM or FSB sweet spot, but that's just another benefit of gaining access to higher CPU performance. If you doubt this, just go look at the numbers on systems reported here or on XS for example. Most people running phase are doing it specifically for VCore increase. I've seen people post specs where, upon switching from water to phase, they actually lowered FSB (and in the process the speed of their RAM) and then got higher system clock by bumping the CU multiplier up to its limit. Or are you now going to tell me that NB and RAM cooling is what most people do with Phase and TEC?

Quote:
Why do you insist on wearing a light-up Dumb Ass sign? Believe me, your words alone are enough.


Look in the mirror, dude, you're amassing a big pile of BS because you don't know WTF you're talking about.
September 19, 2006 4:44:02 PM

Please dont respond to Clueless.... he tends to hijack threads and flame people... and I doubt he even looked at what the excel sheet does... This is his history, and please dont let him ruin this thread like he does everything else he touches. Hes got some major problems, and responding to him wont help him solve them.

The Excel sheet is beign modified to include more information on what it does. What it doesnt do is that it DOESNT tell you what to set your machine too, or what is safe. All it does is show you the numbers that you need to set your machine to certain values... It can not show what is safe and what isnt... It also cannot show what voltages you need and what you should run... Wusy's guide is pretty good for this as a Base... To get the most out of your machine you need to play with the numbers and try different settings that are not in his guide. Their is no perfect solution... and their is no way we can provide you with answers... If there was we would do so...
September 19, 2006 4:56:25 PM

Quote:
Please dont respond to Clueless....

Do as he says, not as he does. Green Jelly is your commander, you must abide his every wish!
Quote:
he tends to hijack threads

Err, dude, talking about cooling, OCing, etc., as I've done on this thread is TOTALLY on-topic. So STFU.
Quote:
and flame people...

Hilarious coming from you. You've never flamed anyone here, have you? And you've never lied about anyone here, have you? ...How's that 6800 OC project going, dude?
Quote:
and I doubt he even looked at what the excel sheet does...

Then you'd be wrong. I don't see any VALUE to your sheet, but that's beside the point.
Quote:
The Excel sheet is beign modified to include more information on what it does. What it doesnt do is that it DOESNT tell you what to set your machine too, or what is safe. All it does is show you the numbers that you need to set your machine to certain values... It can not show what is safe and what isnt... It also cannot show what voltages you need and what you should run...

Sounds like a priceless resource. How did overclockers make it this far without your sheet?
Quote:
Wusy's guide is pretty good for this as a Base... To get the most out of your machine you need to play with the numbers and try different settings that are not in his guide. Their is no perfect solution... and their is no way we can provide you with answers... If there was we would do so...

Shouldn't you learn some basic troubleshooting skills before you try to become the forum's new OC Guru?
September 19, 2006 5:18:27 PM

Quote:
That's a total crock of sh!t in part because it's non-specific.


HAHAHAHAHA. :lol:  Hook, line and sinker, there matey. Ye zipped it in yer fly agin. HA HAHAHA HAHAHA! :lol: 

Yer as witless as yer are stupid, but at least yer mother named ye proper, Clueless. I'll not be listenin' to any more of yer nonsense, but jest ye keep talkin'.

Aye, I think I may have peed me breeches. :p  :lol: 

Arrrrr!
September 19, 2006 10:04:10 PM

I've finally had a chance to examine the code behind your spreadsheet, and trace the links. Very nice work. It must have taken a while to put it all together. It is interesting to fiddle with the various combinations.

Offtopic: Anybody have suggestions on a cheap video card that won't bottleneck this 3D rendering system? My overclocking plans are conservative because I don't want the system to wedge halfway into a 30 hour render.

Asus P5B
Core 2 Duo E6600
Crucial Ballistix DDR2-1000

Tom
September 20, 2006 1:28:31 AM

Quote:
Ye zipped it in yer fly agin.


Interpretation: "I have nothing to counter with since you've totally pwned me from a technical perspective, so I'll try a sidestep. I'm also jealous because mine won't reach all the way out to my zipper."

Ya failed da pirates day test too, ya skanky scallawag.
September 20, 2006 4:13:21 AM

Quote:
I've finally had a chance to examine the code behind your spreadsheet, and trace the links. Very nice work. It must have taken a while to put it all together. It is interesting to fiddle with the various combinations.

Offtopic: Anybody have suggestions on a cheap video card that won't bottleneck this 3D rendering system? My overclocking plans are conservative because I don't want the system to wedge halfway into a 30 hour render.

Asus P5B
Core 2 Duo E6600
Crucial Ballistix DDR2-1000

Tom


We created a new one... Me and Tom... I guess the memory multiplier is double the value I had... and that the equations changed from a multitude of 4 to a multitude of 2...

This will allow people to be more accurate... A 533mhz Memory Speed @ FSB 266 is a 1:1 multiplier... I thought it was 1:2...

Anyways, the original answers where right... just not the details... thanks for the compliment... keep checking back here... we will have a new version

Night all
Mike
September 20, 2006 5:34:23 AM

I must say you realy sound like a jerk, if hes wrong at least say it more polite than "your stupid, go die".
September 20, 2006 5:53:30 AM

Quote:
I must say you realy sound like a jerk, if hes wrong at least say it more polite than "your stupid, go die".


Hey Murdera, I never told anyone to die so quit fabricating!
September 20, 2006 6:26:26 AM

Quote:
I must say you realy sound like a jerk, if hes wrong at least say it more polite than "your stupid, go die".


Hey Murdera, I never told anyone to die so quit fabricating!

You are correct; perhaps that was a poor choice of words. Your words seemed pretty much to convey that idea however.
September 20, 2006 7:03:25 AM

Quote:
I must say you realy sound like a jerk, if hes wrong at least say it more polite than "your stupid, go die".


Hey Murdera, I never told anyone to die so quit fabricating!

You are correct; perhaps that was a poor choice of words. Your words seemed pretty much to convey that idea however.

Given your handle, maybe it's logical for you to think as such. Death is too severe a punishment in my opinion. In fact, the consequences of their ignorance provide adequate suffering.
September 20, 2006 7:31:21 PM

GOD DAMN IT!!! STOP HIJACKING THIS THREAD!!!

Please for the love of god, can a moderator delete all this crap that doesnt belong in this thread... No one would want to wade through this crap to read real information... If I have too I will just start a new thread with a new version number... maybe after a few versions certain people will get tired of this...

-------------------------------------------------------------

BTW:
We are finalizing a new version with descriptions/warnings/instructions/colors/corrections and consistancy.
Should be up soon! I will update the top thread when it gets posted...
September 20, 2006 8:50:17 PM

Quote:
can a moderator delete all this crap that doesnt belong in this thread...

You'd love to have total censorship rights for the entire forum, wouldn't you?

Quote:
If I have too I will just start a new thread with a new version number... maybe after a few versions certain people will get tired of this...

I've been tired of it since the very beginning. Maybe there's hope for you eventually...
September 22, 2006 2:08:35 AM

New version available... With COLORS!!! hahah

and descriptions, warnings, consistancy some corrections, and a few major fixes...

Got to download it...
September 22, 2006 12:58:37 PM

What is the purpose of line 8 on the first spreadsheet?

I really like your spreadsheet. The formulas are well written. But if you don't document it better, you will be the only one who can use it.

Like I said, nice work on the spreadsheet.

Tom
September 22, 2006 1:20:06 PM

Quote:
What is the purpose of line 8 on the first spreadsheet?

I really like your spreadsheet. The formulas are well written. But if you don't document it better, you will be the only one who can use it.

Like I said, nice work on the spreadsheet.

Tom


I beleive that is where you can set an exact FSB... though in actuallity, all of the fields are that way...

let me check...

Yep... just change the value form the far left...

The graph is only in range of 5's... if you find around the number you want... you can then narrow it down with that top field...

However you can change any of the FSB numbers on the entire graph...

you can also add lines, then drag the equations (bottom right corner on selected area)... they are set up to handle this...

Mike
September 30, 2006 3:15:51 AM

Files on the supplied link do not work right now. I am attempting to addressing this issue with the man whos kind enough to host them.

If the files do not download for you using the first page, please email me at big_green_jelly_bean-=<at>=-yahoo.com Please replace the "-=<at>=-" with "@". This is to help prevent spammers from spamming me:) 

PLEASE: If you can mirror the site, and host the file, it would be helpfull for many people.

I am also working on a new version that will explain the bios settings for all motherboards I can get information on... If you own a Core 2 Duo capable MoBo, and can supply me with the settings that are listed in the bios, I will add it to my list, and work hard at getting descriptions for them. I will also be including Wusy's recommended basic OC settings.
!