Search results

P
Excel math question

VLOOKUP is indeed the best option here, provided your table is formatted in a convenient way for the look-up function. Since it sounded like you need the result of both B2 & B3 cells for the look-up, you can concatenate them as your search key. E.g. your look-up table could be like this...
- Phil L
- Post #4
- Jan 17, 2017
- Forum: Windows
P
Is your processor Running slower than you think it should be ? Or at a different multiplier than it should be ?

I had an odd experience with CPU running slow but not due to speed step recently. I was able to fix it in the end, but I'll post the experience below in case someone encounters it in the future. My coworker's computer that our IT had set up ran quite sluggishly. The computer was purchased...
- Phil L
- Post #82
- Jan 17, 2017
- Forum: CPUs and Overclocking
P
Thermal Paste on gpu?

Although 70 deg. C doesn't sound so bad, I also don't play FF14 so I don't know how demanding it is. On top of that your graphics setting and resolution also matter. A better test would be say Furmark at fullscreen (whatever resolution you run at), and see what that's like. Personally I had...
- Phil L
- Post #10
- Sep 2, 2014
- Forum: Graphics Cards
P
Difference between gaming and workstation video cards?

Comment below is specifically for SolidWorks 2010/2011 and Radeon cards, but may apply to future versions of SolidWorks. I've built a workstation for a coworker using a gamer card, HD 6870 specifically, for SolidWorks at work, and it runs perfectly fine. I've also tried forcing equivalent...
- Phil L
- Post #14
- Apr 23, 2013
- Forum: Graphics Cards
P
Samsung Series 7 Laptops

Given your need, you may also consider a Sager/Clevo which can be cheaper, has good display (big plus for digital photos), and may offer better bang for the buck. If shopping in the US, many resellers also offer free shipping along with a 3% cash discount (if you use money order, certified...
- Phil L
- Post #4
- Sep 7, 2012
- Forum: Laptops
P
2nd gen i7 vs 3rd gen i5?

Without knowing the specific laptop models, I would say go for Ivy Bridge. Here is why, Let's look at the spec, i7-2670qm: 4(8) cores, 2.2GHz, turbo to 3.1/3.0/2.8 GHz, HD3000, 45w TDP i5-3210m: 2(4) cores, 2.5GHz, turbo to 3.1 GHz, HD4000, 35w TDP iGPU wise hands down IB is better, though...
- Phil L
- Post #4
- Aug 31, 2012
- Forum: CPUs and Overclocking
P
Need help with Workstation!!

Well specifically for AutoCAD and SolidWorks you can just use a GeForce or Radeon with no drawback whatsoever (other than a pretty shadow/reflection feature on SolidWorks that does nothing useful, which you can enable/hack with minimal work). This would save you couple hundred to a few thousand...
- Phil L
- Post #8
- Aug 24, 2012
- Forum: Laptops
P
First Build Recommendation: CAD Workstation

First, you do not need fancy monitors for CAD work at all, what mfenn suggested will do perfectly well. Who cares if your monitor is not 95% gamut when you are doing CAD work... it's not Photography or CG work. As for for SolidWorks, it's all basically single threaded. It uses multithreading...
- Phil L
- Post #15
- Aug 22, 2012
- Forum: Computer Building
P
Need help with Workstation!!

Do you need a Dell or other name brand workstation laptop for the 24/7 services they provide? Do you need the validation/certification that comes with a workstation laptop as part of company policy? The reason I ask is because often you may not actually need a true workstation laptop with...
- Phil L
- Post #4
- Aug 22, 2012
- Forum: Laptops
P
Not happy with Coolermaster 212+ Evo

Someone correct me if I'm wrong, but I believe the CPU diode sensor is also not very well calibrated no? I.e. while it is accurate on relative increase/decrease in temperature, there can also be a systematic error up to a couple degree C reported (e.g. true temp 30 may be reported as 35, true...
- Phil L
- Post #21
- Aug 22, 2012
- Forum: Cases & Cooling
P
Quick 7850 Experience - Repasting

Just something I thought worth sharing. TL: DR - If your GPU is running hotter than you like (even at stock), or you would like to use lower fan rpm to reduce noise, then a quick 5 min of TIM repasting job might just do the trick for you. **************************************************...
- Phil L
- Thread
- Aug 22, 2012
- Replies: 0
- Forum: Graphics Cards
P
Prim95 Help

Are you overclocking? Illegal sumout means the computed answer is different from the pre-loaded database value, meaning your system is unstable. Perhaps you need to increase the voltage or dial back the overclock. It could also be faulty ram, incorrect timing on RAM, etc. You need to provide...
- Phil L
- Post #2
- Aug 21, 2012
- Forum: CPUs and Overclocking
P
Budget Gaming Build Suggestion

The clock is indeed higher, and so are the score. I tested it by running kombustor bench with and without OC. Also GPU-z and MSI Afterburner both log the clock increase as well. With 12.8 and CCC, same test did show OC clock and score gain, but the system becomes unstable in game (passes...
- Phil L
- Post #20
- Aug 19, 2012
- Forum: Computer Building
P
430w not enough for little boost on 3570k?

I have similar setup, 3570k with MSI 7850 TwinFrozr. I do have a Seasonic 520w, but this sytem should not even use 300w. Anyway, as for OC, my CPU is 4.2 (stock voltage with -0.015 offset), while GPU is at 1050/1450. However, at first I had issue with GPU OC also, it would often crash during...
- Phil L
- Post #9
- Aug 19, 2012
- Forum: Power Supplies
P
Budget Gaming Build Suggestion

Well, not really sure if it was the driver or CCC or both, but I've switched to using an older version of Catalyst (12.3) and have CCC uninstalled. But so far I've been running it no problem at 1050/1450, up from 860/1200 (limit of MSI Afterburner, without using Trixx or GPU Tweak). Even...
- Phil L
- Post #18
- Aug 19, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Oh I know OC is not guaranteed. Anyway further tests seems to suggest it's the memory clock. I can push the core clock much higher (currently at 1050, stock is 860) but leaving the memory at stock (1200), and so far no problem in game. Do you know what speed is the RAM rated for or how I can...
- Phil L
- Post #16
- Aug 18, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Hehe, it does get quite loud at 100% fan speed. Thankfully, with some tweaking in game settings and a custom fan profile, it's much much better. As for voltage, I was wondering if I could lower the voltage to reduce temp more, but alas no such option :) Now if I can just address the...
- Phil L
- Post #14
- Aug 18, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Quick update. I have assembled the system, and it's working reasonably well. I have only done some mild quick OC, since I don't have the time right now to seriously work on it. Presently, I have the CPU at 4.2 @ 1.072V. Idle temp is 28~34 C with ambiant of 20~25 C, max temp during 5 loops of...
- Phil L
- Post #12
- Aug 18, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Will do :) I'll update this thread, hopefully i'll get the parts within the week.
- Phil L
- Post #11
- Aug 14, 2012
- Forum: Computer Building
P
Delidded my i7-3770K, loaded temperatures drop by 20°C at 4.7GHz

200 um is very close to 8 mil (i.e. 8 thousandths of an inch, or 203.2 um), and you can buy shim stocks of various thickness and different materials (copper, steel, stainless steel, aluminum, titanium, and so on). You can buy a uniform thickness roll (typically in 6" x 50" or 15.24 cm x 127...
- Phil L
- Post #243
- Aug 14, 2012
- Forum: CPUs and Overclocking
P
Budget Gaming Build Suggestion

Thanks for the suggestions, I've decided to go with said MSI card and other parts. Should have them within a week hopefully :) Thanks again for the help Ken, lehtv, and mfenn, much appreciated.
- Phil L
- Post #9
- Aug 13, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Thanks Ken, that's what I was hoping for. As for the 1GB ya, I saw an XFX one, was kind of puzzled by it. Thanks again :)
- Phil L
- Post #7
- Aug 12, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Thanks for the suggestion, much appreciated :) I do think I'll push the budget a bit more and get a 7850 too. Is there a particular brand that's preferred?
- Phil L
- Post #5
- Aug 12, 2012
- Forum: Computer Building
P
Budget Gaming Build Suggestion

Hi all, I'm thinking of putting together a new budget build for myself after using my old rig for >3 yrs. While I can still run most games that I do play at low settings, it's showing its age on some others (slight lags for example). Here are the basic questionnaire answers, and some more...
- Phil L
- Thread
- Aug 10, 2012
- Replies: 19
- Forum: Computer Building
P
Use workstation drivers or desktop drivers?

There is at least one way to trick the installer. Typically this is done to install workstation driver onto mainstream gamer cards, but no reason why it wont work in reverse, provided you using a driver of same base architecture. To do that you have to modify the INF file in the driver package...
- Phil L
- Post #5
- Dec 17, 2011
- Forum: Graphics Cards
P
MSI motherboard i5 2500k overclocking problem

Just a cautionary note, the board may be and likely is on auto voltage. So while you can run the cpu at 4.5 (and can probably go even higher), it's probably running at much higher voltage and thus temperature than needed, as auto tends to do. Therefore you should try to see if you can tweak...
- Phil L
- Post #9
- Nov 1, 2011
- Forum: CPUs and Overclocking
P
i7-2600K to be used for distributed computing (eg. SETI) - To overclock or not?

If you aren't overclocking, the only real difference between 2600k and 2600 is the iGPU. Therefore it depends on whether you want to use that or a dGPU for display (and maybe some GPGPU power if your software utilize that). If you plan on gaming, then dGPU is preferred, but even then having an...
- Phil L
- Post #13
- Nov 1, 2011
- Forum: CPUs and Overclocking
P
Does nVidia Optimus Completely Shut Down GPU?

My guess is that the problem is probably the same as is with QuickSync and dGPU on Sandy Bridge desktop. Namely if you shut the power to the dGPU, there is no more display coming out of it, so you would have to have your monitor connected to the iGPU at all time instead. Then you would need...
- Phil L
- Post #5
- Aug 22, 2011
- Forum: Graphics Cards
P
Smart Value Indication

I couldn't find this SMART attribute on the Intel SSD Toolbox User Guide, but in general the number you want to compare it to is the Threshold value. Also if the Intel SSD Toolbox is like other SMART monitoring software, it'll actually warn you (or highlight the item in a different colour), if...
- Phil L
- Post #2
- Aug 20, 2011
- Forum: Memory and Storage
P
Program that tells you why it takes so long to boot windows?

You can try Soluto (http://www.soluto.com/) also for something simple and quick.
- Phil L
- Post #5
- Aug 19, 2011
- Forum: Windows
P
ACHI versus RAID

Based on my understanding, functionally they are the same (running under RAID implies you are running your drives via AHCI, but not the other way around), except RAID allows you to set up disk arrays too.
- Phil L
- Post #2
- Aug 16, 2011
- Forum: Computer Building
P
Occam's Razor - when has it been wrong?

My understanding of Occam's Razor is not so much that the simpler explanation is "correct" when all else being equal, rather that you should start with the simpler explanation as it is the easiest one to test the validity of. The approach is to use the minimum number of parameters you can to...
- Phil L
- Post #8
- Aug 7, 2011
- Forum: Ask a Technical Professional
P
Need help with putting this Desktop together please

This should go into General Hardware. Additionally, it would be helpful if you can supply more details (e.g. time to purchase, screen resolution, brand/oc preference, types of game you are playing/want to play, etc.). Follow the format in this sticky...
- Phil L
- Post #3
- Jul 26, 2011
- Forum: Computer Building
P
Smallest case for Intel i5 2500

150 W should be sufficient to run an i5 2500, provided you don't overload you system with tons of peripherals. You can also opt for 200 W unit with your mini-itx tower. Newegg shows some In Win cases that have 200 W psu. Alternatively, you can also get a mini-itx tower without psu and add...
- Phil L
- Post #3
- Jul 22, 2011
- Forum: Cases & Cooling
P
SSD and Streaming Video

I don't know how you might do that, but I do not think you need to worry about writing even hundreds of GB to your SSD either. NANDs are quite durable. (http://www.xtremesystems.org/forums/showthread.php?271063-SSD-Write-Endurance-25nm-Vs-34nm/) These SSD are have endured tens~hundreds of...
- Phil L
- Post #3
- Jul 9, 2011
- Forum: Memory and Storage
P
Tagging pictures in windows 7

It's not clear to me what the problem is exactly without seeing a screenshot of what your windows explorer window looks like. However, one possibility is you may have the "Details Pane" hidden (the lower bar with file name/type, date taken, tags, ratings, dimensions, and size info). To show...
- Phil L
- Post #2
- Jul 7, 2011
- Forum: Windows
P
Are the Olympic Records corrected to gravity?

Gravity on the surface of Earth varies due to latitude (Earth is not truly spherical), altitude, and local geology (different rock density). For the latitude variation the effect is greatest between pole and equator, but it's only ~0.3%, not 0.3 m/s^2 which is ~3%. That said, I don't think...
- Phil L
- Post #2
- Jun 20, 2011
- Forum: Ask a Technical Professional
P
TFGHT is compressed! Can't install Windows.

Think of striping as having multiple read/write heads (HDD) or more channels (SSD), which in either case meant higher bandwidth. Since the data is distributed but not duplicated, there is no wasted space, provided the disks are the same size of course. You only waste space if you have drives...
- Phil L
- Post #13
- Jun 19, 2011
- Forum: Memory and Storage
P
how to increase WoW patch speeds

This may not help, however, I've had issues in the past with the Blizzard Updater being far slower than my connection allows (due to the Blizzard throttling download based on upload I was told). I rectified the problem by extracting the torrent file using an utility (from...
- Phil L
- Post #6
- Jun 19, 2011
- Forum: Networking
P
TFGHT is compressed! Can't install Windows.

I think you are confusing Raid 0 (striping) with Raid 1 (mirroring). Did you want faster performance (Raid 0, ~119Gb) OR data redundancy (Raid 1, ~64Gb)? Win7 does this on HDDs too, but it doesn't always have a drive letter to allow you to access it by default, but you can always see it under...
- Phil L
- Post #7
- Jun 19, 2011
- Forum: Memory and Storage

RESOURCES

Top Bottom