Overclock.net › Forums › AMD › AMD - General › The Socket 939 Appreciation Club and Knowledgebase [Official]
New Posts  All Forums:Forum Nav:

The Socket 939 Appreciation Club and Knowledgebase [Official] - Page 2078

post #20771 of 28692
Quote:
Originally Posted by N2Gaming View Post
Yeah really. Man your still awake or are you just waking up?
I was still awake studying for an exam that I had to take first thing in the morning.

Quote:
Originally Posted by txtmstrjoe View Post
Actually, it goes a little bit more beyond that in the case of the S939 DFI LANParty series boards. According to information found on another forum, each board was attuned to handle specific types of RAM ICs.

The Venus and CFX3200, apparently, were supposed to be the cream of the crop, but they are not for overclockers without a ton of patience. I can attest to the goofiness that is the CFX3200...

If that's not a neurotic amount of attention to detail, I don't know what is.
That's very interesting, I didn't know they got that crazy about the RAM IC's.
Quote:
Originally Posted by txtmstrjoe View Post
Go for it!

If you do, it may just be the inspiration I need to get the CFX3200 up and running as a legit rig again! It's running, but purely as a hardware tester right now.
Better than my CFX3200, it's just sitting in a box. I was going to set it up as a folder but it's just easier to have to matching boards for troubleshooting and testing purposes. I can just swap them out and not have to worry about drivers and such. Although, for what it's worth, the CFX3200 is a pretty good overclocker as soon as you get past the cold boot issue.
Black Box
(16 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Asus P8Z77-Vpro Evga 780 Classified Crucial Ballistix 
Hard DriveHard DriveOptical DriveCooling
A-Data 128GB SSD Samsung Spinpoint F3 1TB Pioneer BDR-207DBK Corsair H80 
OSMonitorKeyboardPower
Win 7 pro 64 Hannspree 25" 1080p LCD 2ms Razer Lycosa PC Power & Cooling 760w 
CaseMouseMouse PadAudio
Corsair 550D MX 518 Allsop Creative XFi Xtreme music 
  hide details  
Reply
Black Box
(16 items)
 
  
CPUMotherboardGraphicsRAM
i7 3770k Asus P8Z77-Vpro Evga 780 Classified Crucial Ballistix 
Hard DriveHard DriveOptical DriveCooling
A-Data 128GB SSD Samsung Spinpoint F3 1TB Pioneer BDR-207DBK Corsair H80 
OSMonitorKeyboardPower
Win 7 pro 64 Hannspree 25" 1080p LCD 2ms Razer Lycosa PC Power & Cooling 760w 
CaseMouseMouse PadAudio
Corsair 550D MX 518 Allsop Creative XFi Xtreme music 
  hide details  
Reply
post #20772 of 28692
Quote:
Originally Posted by thlnk3r View Post
Blitz, sounds like it's splitting the work across all the cores. Can you make Office 2007 use just one core for testing? Just to elaborate, what kind of worksheet are you running in Excel? Reason I ask is because I open some pretty large xls documents at work I hardly experience any delay. I think you need to change your avatar title to, "Power User"
Yes, it is splitting the work, but it will not use more CPU. If even it used 50%, things would operate much faster.

As to the file, it started off as a 198 MB TSV (Tab Separated Value) file. When I opened it in Notepad, I would use about 520 MB of RAM and it took about two minutes to open it. So I opened Excel (in 03 compatibility like I always do) and it could not be opened. As many of you know, Excel 03 can only have 65,536 rows and 256 columns per worksheet. So I told it to operate in Excel 07 mode and opened it again. The raw data filled from A1 to CU559527, making it some 559,527 rows by 99 columns.

In case you were curious, this is data of every single person sent to prison in the United States in the year 2007. It tells me everything about them from date of birth, level of education, sentence for longest offense, other offenses, et cetera. I have since pared out the data I do not need (most of the columns via copy-pasting) and split each state onto its own worksheet. The largest of which is California at 120,323 rows. (All have 19 columns.)

After processing the raw data, I had to start making formulae which do what I want with it. For example, one formula (for California) is:
Code:
=ROUND((
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=10),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=11),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=12),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=13),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=14),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=15),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=16),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=20),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=21),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=22),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=30),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=31),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=32),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=40),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=41),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=42),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=90),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=91),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=92),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=100),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=101),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=102),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=120),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=121),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=122),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=130),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=131),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=132),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=140),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=141),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=142),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=150),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=151),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=152),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=160),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=161),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=162),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=170),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=171),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=172),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=180),-('California (6)'!$Q$2:$Q$132000<99999),'California (6)'!$Q$2:$Q$132000)
)/(
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=10),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=11),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=12),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=13),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=14),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=15),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=16),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=20),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=21),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=22),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=30),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=31),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=32),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=40),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=41),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=42),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=90),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=91),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=92),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=100),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=101),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=102),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=120),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=121),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=122),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=130),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=131),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=132),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=140),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=141),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=142),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=150),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=151),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=152),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=160),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=161),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=162),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=170),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=171),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=172),-('California (6)'!$Q$2:$Q$132000<99999))+
SUMPRODUCT(-('California (6)'!$P$2:$P$132000=180),-('California (6)'!$Q$2:$Q$132000<99999))
),2)
At least, that is the code as written. Apparently, Excel has a limit of 8192 characters per formula, so that had to be broken into three cells: =ROUND(Numerator/Denominator,2), =Numerator, and =Denominator.

What that code does is that it takes everyone from the state of California who committed a Violent offense against a person (Column P, defined by Massachusetts Department of Corrections as Murder, Manslaughter, Vehicular Manslaughter, or other Homicide, Kidnapping, Robbery (armed or otherwise), Carjacking, Assault of any flavor, Child Abuse, Blackmail, Extortion, or Racketeering, or any other violent offense such as Assisting a Suicide, Endangerment, et cetera, or the attempt or conspiracy to commit the same) and takes their sentence (Column Q, in months) and divides by their person to determine the average sentence in months for a violent offense. The same is done for sex crimes (defined again by Massachusetts as Rape, Statutory Rape, Sexual Assault, Forcible Sodomy, or Child Molestation, or the attempt or conspiracy to commit the same). This is repeated for all states that report data. In case you were curious, in California, the average sentence is 87.48 and 87.37 months respectfully; the national average is 81.42 and 105.87 months respectfully. One small flaw though: that formula is designed to exclude life sentences, life plus a term of years, life without parole, and death sentences, simply as I do not know how to average them in. This will give states with active death rows a lower apparent sentence.

The reason why I am doing all this: I wanted to see what effect having voter input in judicial selection has on sentencing. My contention is that a judge who must be reelected every few years would be more likely give longer sentences than those who are appointed by the governor without voter oversight. Case in point however, is that these files abuse my computer something fierce, at one point during transferring of data between them I have seen RAM usage as high as 28%. If this post is too long, please let me know, and I will pare most of it out to a blog post and just link over.
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
post #20773 of 28692
Quote:
Originally Posted by blitz6804 View Post
Yes, it is splitting the work, but it will not use more CPU. If even it used 50%, things would operate much faster.
Blitz, see my last question. If Excel only uses one core does it max it out at 100%? Here's a list taken from MSN that shows which features do not work with MTC (multithreaded calculation) just FYI:

Quote:
Some Excel features do not use multithreaded calculation, for example:
  • Data table calculation (but structured references to tables do use MTC).
  • User-defined functions (but XLL functions can be multithread-enabled).
  • XLM functions.
  • INDIRECT, CELL functions that use either the format2 or address options.
  • GETPIVOTDATA and other functions referring to PivotTables or cubes.
  • Range.Calculate and Range.CalculateRowMajorOrder.
  • Cells in circular reference loops.
Also another FYI, I received a doc from a customer this week in .xlsx format that used all 65,536 (yes seriously haha) rows and it opened almost instantly granted I was not transferring data but everything was still fine. I'm on a P4 2.8 with 1GB of memory.

Good luck
Workstation
(13 items)
 
  
CPUMotherboardGraphicsRAM
Athlon II X4 620 Asus M4A785-M Asus 5770 G.Skill 8GB DDR2-800 
Hard DriveOSMonitorPower
WD3200AAJS Windows 7 Pro Acer AL2216W, Samsung P2770 Corsair 550VX 
Case
Tagan Black Pearl 
  hide details  
Reply
Workstation
(13 items)
 
  
CPUMotherboardGraphicsRAM
Athlon II X4 620 Asus M4A785-M Asus 5770 G.Skill 8GB DDR2-800 
Hard DriveOSMonitorPower
WD3200AAJS Windows 7 Pro Acer AL2216W, Samsung P2770 Corsair 550VX 
Case
Tagan Black Pearl 
  hide details  
Reply
post #20774 of 28692
If it is limited at 65,536, then it would be an XLS, not an XLSX. What is a "Data table calculation?" I only use SUMPRODUCT, division, and ROUND as above. Would that be a user-defined function since I use a mixture in one cell?

Okay, testing done... seems Excel ignores me. Whether Multi-threaded calculation is enabled or disabled, I get a 40% load on cores 1 and 3, a 10% load on cores 0 and 2.
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
post #20775 of 28692
Quote:
Originally Posted by blitz6804 View Post
If it is limited at 65,536, then it would be an XLS, not an XLSX. What is a "Data table calculation?" I only use SUMPRODUCT, division, and ROUND as above. Would that be a user-defined function since I use a mixture in one cell?

Okay, testing done... seems Excel ignores me. Whether Multi-threaded calculation is enabled or disabled, I get a 40% load on cores 1 and 3, a 10% load on cores 0 and 2.
Blitz, hmmm perhaps it was a .xls document then. Though I swear I could remember it being .xlsx because my Office 2007 converter popped up....

In any case I'd suggest performing a Google search on each of the terms above as I am unsure what they are. I just grabbed them from the MSN website hoping you would know. Also check out this blog entry on a calculation issue: http://blogs.msdn.com/excel/archive/...ue-update.aspx (not sure if that helps or not but it discusses calculation issues around 65,535.)

Sorry I wish I could help out more. Maybe you could split the documents in half into 6 month ranges?

Good luck
Workstation
(13 items)
 
  
CPUMotherboardGraphicsRAM
Athlon II X4 620 Asus M4A785-M Asus 5770 G.Skill 8GB DDR2-800 
Hard DriveOSMonitorPower
WD3200AAJS Windows 7 Pro Acer AL2216W, Samsung P2770 Corsair 550VX 
Case
Tagan Black Pearl 
  hide details  
Reply
Workstation
(13 items)
 
  
CPUMotherboardGraphicsRAM
Athlon II X4 620 Asus M4A785-M Asus 5770 G.Skill 8GB DDR2-800 
Hard DriveOSMonitorPower
WD3200AAJS Windows 7 Pro Acer AL2216W, Samsung P2770 Corsair 550VX 
Case
Tagan Black Pearl 
  hide details  
Reply
post #20776 of 28692
Oh, that is different bag of worms. If you open an XLSX in Excel 03 via Microsoft's converter, it will only convert the first 65,536 rows. I have tried opening the database in Excel 03 on my Barton laptop (do not even think about asking how long that took) and the states like California with more than 65,536 rows all were missing data, thereby producing different calculated values than those of the XLSX in Excel 07.
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
post #20777 of 28692
hey, I was wondering what you guys say is the max safe operating temperature for my Opty 170-939 chip....it's idling at 42c right now.
Overclock_Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX-60 DFI LP nF4 SLI-DR Expert 4890 BH-5 
OSMonitorKeyboardPower
Tiny7 23" awesome Corsair TX-850 
Case
None 
  hide details  
Reply
Overclock_Machine
(13 items)
 
  
CPUMotherboardGraphicsRAM
FX-60 DFI LP nF4 SLI-DR Expert 4890 BH-5 
OSMonitorKeyboardPower
Tiny7 23" awesome Corsair TX-850 
Case
None 
  hide details  
Reply
post #20778 of 28692
All dual-core 939 Opterons have a maximum temperature of 65º C according to AMD.
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
     
CPUMotherboardGraphicsRAM
Intel Core i7-3770k ASRock Z77 Extreme6 LGA 1155 EVGA GeForce GTX 780 FTW (03G-P4-3784-KR) Crucial Ballistix Sport 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 HD103SJ Hitachi Deskstar 5K3000 HDS5C3020ALA632 Hitachi Deskstar 7K1000 HDS721075KLA330 Hitachi X Mobile 
Optical DriveCoolingCoolingCooling
LG CH08LS10 (SATA BD-R / DVD±R / CD-RW) Prolimatech Megashadow Scythe S-Flex SFF21G x2 Scythe S-Flex SFF21F x2 
CoolingCoolingCoolingOS
Thermalright TR-FDB-1600 x4 XCLIO Amazing Fan 250mm Scythe Kama Bay SCKB-1000BK x3 Windows 7 Home Premium x64 SP1 
OSOSOSOS
Windows XP Home x64 SP3 (via Virtualbox) Fedora 15 LXDE (via Virtualbox) Slackware Linux XFCE (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorMonitorMonitorKeyboard
LG 47LH40 Acer G276HL Gbd Acer G276HL Gbd Unicomp Classic 104 Black Buckling Spring PS2 
PowerCaseMouseMouse Pad
Silverstone OP1000-E Modded Thermaltake Armor VA8003BWS Logitech G500 Massive generic black foam mat 
AudioAudioAudioAudio
Creative Sound Blaster X-Fi Titanium Fatal1ty C... Denon AVR-1910 Polk Audio Monitor 40 Polk Audio Monitor 30 
AudioAudioAudioAudio
Polk Audio CS1 Polk Audio PSW10 Jamo C400SUR Plantronics Gamecom 377 
AudioOtherOtherOther
LG HBM-235 Genovation ControlPad 683 Canon Imageclass MF4450 12" Dual White Cold Cathode Kit x3 
OtherOtherOtherOther
Microsoft Strategic Commander UPEK Eikon Digital Privacy Manager Logitech G27 Playseat Revolution (NASCAR) 
OtherOtherOtherOther
Playseat Revolution Gearshift Holder Sony DualShock 3 Microsoft Lifecam VX-1000 D-Link DBT-120 
OtherOther
APC SMT1500 HP Photosmart 3210xi All-in-One 
CPUMotherboardGraphicsRAM
Intel Core 2 Duo T7700 Merom Toshiba ISRAA 1.0 (Socket 479) ATI Mobility Radeon HD2600 modded CCC 10.6 OCZ2MV6674GK 
Hard DriveHard DriveOptical DriveCooling
Hitachi Travelstar 7K500 HD20500 Western Digital Caviar Blue (WD6400BEVT-22A0RT0) Matshita DVD-RAM UJ-850S ATA Stock heatpipe system 
CoolingOSOSOS
Thermaltake Massive23 CS Windows 7 Home Premium x64 SP1 Windows XP Home x64 SP3 (via Virtualbox) DOS 5.0 (via DOSbox) 
MonitorKeyboardPowerCase
17.0" Diagonal Widescreen WSXGA+ Internal only 19 V, 6.32 A Stock 17" Satellite shell (8.5 lbs) 
MouseMouse PadAudioAudio
Logitech G500 Small generic black foam mat HP Thin USB Powered Speakers Fiio E5 Headphone Amplifier 
AudioOtherOther
Griffin iTrip P1141 Microsoft GPS 168 Toshiba Backpack PA1366U-1NCS 
CPUMotherboardGraphicsRAM
AMD Athlon XP-M 2500+ Barton Hewlett-Packard 0024 ATI Mobility Radeon IGP-320M Crucial CT6464X265.16FG 
Hard DriveOptical DriveCoolingOS
Toshiba MK4021GAS Toshiba SD-R2512 Stock heatpipes Windows XP Home SP3 
MonitorKeyboardPowerCase
15.0" XGA TFT Internal only 18.5 V, 4.9 A Stock 15" Pavilion Shell (8 lbs) 
MouseMouse PadAudioOther
Logitech MX510 Gaming Optical Generic gel-based green Internal Altec Lansing only Targus PAU10KU 
OtherOther
D-Link DWL-G650M Generic black messenger-style bag 
  hide details  
Reply
post #20779 of 28692
@Thlnk3r, download and use OpenOffice if you don't have MS Office 07. It'll allow you to use the full potential of DocX & XLSX files.

Quote:
Originally Posted by ny_driver View Post
hey, I was wondering what you guys say is the max safe operating temperature for my Opty 170-939 chip....it's idling at 42c right now.
According to AMD it's 65*C
Test Bed
(24 items)
 
TTTbox
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 3570K  Biostar TZ774XE Power Color AX5770 1GB 4x4GB 1866Mhz 9-10-9-27-2T 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 1TB Samsung Spinpoint F3 1TB Western Digital Green 2TB Samsung Spinpoint M4 500GB 
Hard DriveOptical DriveCoolingOS
Intel X-25M G2 80GB Lite-On BluRay Drive Arctic Cooling Freezer 13 Pro Windows 7 Ultimate 
MonitorKeyboardPowerCase
Dell U2212HM Deck Legend Frost Tactile Silverstone Strider Plus 750w Custom Acrylic Test Bed 
MouseMouse PadAudioAudio
Logitech G500 Cooler Master Storm Tactics FPS Beyer Dynamics DT-990 600ohm Samson MediaOne 3A 
AudioAudioOtherOther
FiiO E09k QOGIR FiiO E17 ALPEN Microsoft Lifecam Studio Blue Yeti Pro Microphone 
CPUMotherboardGraphicsRAM
AMD A10-A5800K ASRock FM2A85X-ITX Radeon HD7770 1GB 2x8GB 1866mhz C9 
Hard DriveHard DriveOptical DriveCooling
SanDisk Ultra Plus 128GB 2TB 5400 RPM  24x DVD Drive Noctua L9A 
OSMonitorKeyboardPower
Windows 7 Home Premium 32" IPS TV Logitech K400 Seasonic G360 
CaseMouseAudio
Cooler Master Elite 120 Advanced Logitech K400 Trackpad Custom 2.1 Home Theater Setup 
  hide details  
Reply
Test Bed
(24 items)
 
TTTbox
(15 items)
 
 
CPUMotherboardGraphicsRAM
Core i5 3570K  Biostar TZ774XE Power Color AX5770 1GB 4x4GB 1866Mhz 9-10-9-27-2T 
Hard DriveHard DriveHard DriveHard Drive
Samsung Spinpoint F3 1TB Samsung Spinpoint F3 1TB Western Digital Green 2TB Samsung Spinpoint M4 500GB 
Hard DriveOptical DriveCoolingOS
Intel X-25M G2 80GB Lite-On BluRay Drive Arctic Cooling Freezer 13 Pro Windows 7 Ultimate 
MonitorKeyboardPowerCase
Dell U2212HM Deck Legend Frost Tactile Silverstone Strider Plus 750w Custom Acrylic Test Bed 
MouseMouse PadAudioAudio
Logitech G500 Cooler Master Storm Tactics FPS Beyer Dynamics DT-990 600ohm Samson MediaOne 3A 
AudioAudioOtherOther
FiiO E09k QOGIR FiiO E17 ALPEN Microsoft Lifecam Studio Blue Yeti Pro Microphone 
CPUMotherboardGraphicsRAM
AMD A10-A5800K ASRock FM2A85X-ITX Radeon HD7770 1GB 2x8GB 1866mhz C9 
Hard DriveHard DriveOptical DriveCooling
SanDisk Ultra Plus 128GB 2TB 5400 RPM  24x DVD Drive Noctua L9A 
OSMonitorKeyboardPower
Windows 7 Home Premium 32" IPS TV Logitech K400 Seasonic G360 
CaseMouseAudio
Cooler Master Elite 120 Advanced Logitech K400 Trackpad Custom 2.1 Home Theater Setup 
  hide details  
Reply
post #20780 of 28692
Thread Starter 
Quote:
Originally Posted by ny_driver View Post
hey, I was wondering what you guys say is the max safe operating temperature for my Opty 170-939 chip....it's idling at 42c right now.
A good question would be why is the idle temperature so high? What is your ambient temperature (temperature of the room you're in)?
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 BE Gigabyte GA-MA790FXT-UD5P Sapphire Radeon HD 3870 2 x 2GB Crucial Ballistix Tracers PC3 10600 
Hard DriveCoolingOSPower
Almost 8TB of storage AMD Stock Cooler Windows Home Server CoolerMaster SilentPro M 700W 
Case
Lian Li PC-V2000B (with thlnk3r mods) 
  hide details  
Reply
    
CPUMotherboardGraphicsRAM
Phenom II X3 720 BE Gigabyte GA-MA790FXT-UD5P Sapphire Radeon HD 3870 2 x 2GB Crucial Ballistix Tracers PC3 10600 
Hard DriveCoolingOSPower
Almost 8TB of storage AMD Stock Cooler Windows Home Server CoolerMaster SilentPro M 700W 
Case
Lian Li PC-V2000B (with thlnk3r mods) 
  hide details  
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: AMD - General
Overclock.net › Forums › AMD › AMD - General › The Socket 939 Appreciation Club and Knowledgebase [Official]