PCSTATS Main Page Follow PCSTATS on Facebook PCSTATS RSS Feed PCSTATS Twitter Feed + Motherboards
+ Videocards
+ Memory
+ Beginners Guides
News & Advanced Search  Feedback?
[X]   Directory of
Guides & Reviews
The PCstats Forums

Beginners Guides
Weekly Newsletter
Archived Newsletters



Contact the Suite 66 Advertising Agency

Seagate Backup Plus Slim External USB 3.0 2TB Hard Drive Review
  More Seagate Reviews... and Hard Drives.
Kingston SSDNow V300 240GB SATA III SSD Review
 [>>]
Beginners Guides: 99 Performance Tips for Windows
 [>>]
Beginners Guides: 99 Performance Tips and Tweaks for Windows
 [>>]
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
 [>>]
More>>

Search...
General News RSS News Feed - PCSTATS
... 95 news stories awaiting approval  
Rosewill Releases RK-9000 Series - Cherry MX Switch Mechanical Keyboards
     Wed, Aug 24 2011 | 4:49P | Peripherals | PermaLink
Posted by: STAFF

 
Rosewill the leading hardware solution provider bringing the best choice in value, will be showcasing its latest technologies to the gaming community at PAX Prime, Penny Arcade Expo 2011. Meanwhile Rosewill will launch and display brand new RK-9000 Series Mechanical Keyboard at Rosewill booth #1240, Seattle Convention Center from August 26th to August 28th.
 
The Rosewill RK-9000 Series Mechanical Keyboard with world-class Cherry MX Switch (Digikey PDF on the Cherry MX) design provides you full with gaming response while offering the bonus of a comfortable key stroke. Moreover, Rosewill RK-9000 Series Keyboard is equipped with both gold plated USB and PS/2 connectors to provide a long lasting high quality connection.  Rosewill RK-9000 series will be available in 4 models which include Cherry MX Blue (RK-9000), Brown (RK-9000BR), Black (RK-9000BL) and Red (RK-9000RE) Switches to match any personal requirements for the dream keyboard. More info: www.rosewill.com

www.pcstats.com

At PAX Prime 2011, Rosewill not only showcases the world leading mechanical gaming keyboards but also displays its extreme gaming hardware including award winning full tower gaming case, Rosewill THOR V2, best selling mid tower case, Rosewill BLACKHAWK and 80 plus GOLD certified LIGHTING series of Power Supply. Also, Rosewill has full lines of gaming peripherals to power up your pc gaming experience.
 
At the Rosewill PAX booth we are hosting 3 days of gaming tournaments, including the most popular PC gaming titles such as Counter-Strike: Source, StarCraft II and Street Fighter 4.  In addition Rosewill has partnered with Kingston and EVGA to be able to bring another major activity, the Gaming Cosplay Costume Contest. It’s easy to participant, dress up at PAX, take a photo at our booth and show up at 4pm on Aug. 27th.  We will let the crowd vote for the best gaming costume! 
 
Rosewill Inc. (www.rosewill.com) is the leading hardware solution provider which believed in Quality, Price and Service. Established in 2004, Rosewill brings quality hardware and affordable prices together. Formed from a top team of hardware professionals, Rosewill is dedicated to our mission to compete and win on price, quality, and service. Our vision is to become the leading brand in computer hardware and peripherals. We aim to achieve this goal by our integrity, our innovative products, and our excellent customer service.

www.pcstats.com
  FULL STORY @ ROSEWILL

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?
     Wed, Aug 24 2011 | 4:15P | Tips | PermaLink
Posted by: STAFF

PCSTATS TechTip... Sort an Excel spreadsheet by email domain?


Q: I need to update my websites' news mailing list and remove duplicates, how do I sort the email list in Microsoft Excel by the domain names only? By default Excel sorts everything in front of the @ symbol alphabetically, I need to sort alphabetically everything following the @ sign. Help!

A: By using Data > Sort in Excel it is possible to do this, but first we'll need to pre-format the email mailing list somewhat.
First off, assuming all your email address are listed in Column A (one email address per row), create a second Column in the Excel document so we can use a formula to output only the data following the @ sign in Column A;
=MID(A1, FIND("@",A1, 1)+1, 255)
Paste the above formula into the first cell of Column B, as you'll see, this formula outputs only the domain part of the email address. Click on that cell and hover the mouse over the bottom right-hand corner of the box until you see the cursor turn into a "+" sign. Now click and drag the checkered box down to the very last row of data to copy the formula across all rows.

Next, select all your data by highlighting Column A and Column B in the margins, then go to Data > Sort > and under 'column' choose 'column B' and press 'okay'. This will tell Excel to sort all the data, alphabetically by the domain names in Column B, from there you can easily find and remove the duplicates.

  FULL STORY @ PCSTATS

BitFenix Shinobi mid tower case
     Wed, Aug 24 2011 | 3:09P | Cases | PermaLink
Posted by: STAFF
The budget mid tower case market used to be filled with cheaply made, under designed junk but if recent trends are any indication, those days are well behind us. BitFenix may not be a household brand just yet but their new Shinobi case could be their ticket to success. Priced at under $85 and sporting a long list of premium features, it certainly looks like it could succeed where others have failed.
  FULL STORY @ HARDWARECANUCKS

Patriot Viper Xtreme Division 2 PC3-15000 2x4GB DDR3 RAM Review
     Wed, Aug 24 2011 | 3:08P | Memory | PermaLink
Posted by: STAFF
Unlike our neighbors down south, everyone knows the Canadian military consists of only about three people: The guy who appears on TV all the time, the security guard who eats donuts while watching hockey, and the janitor who cleans the washroom. A couple of months ago, our family visited Ottawa -- and being the capital city of Canada, it probably does not come as a surprise to you it is filled with lots of government buildings. Upon leaving the beautiful city on a bright Sunday afternoon, we went to a local gas station to fill up our rental car. Unfortunately, the local gas station's washroom is out of order, so my cousin and I went across the street, and spotted an entrance next to a convenience store. We went inside, and asked the security guard if we could borrow the washroom. He quietly mentioned that they don't normally let people in, but he escorted us to the door labeled "Men's" anyway. We were a bit curious about why he said this, so before after we left through the exit, we glanced back, and noticed we have just done some 'business' at what is called the Constitution Building -- a building that belongs to the Government of Canada's Department of National Defense. Oops. At this point, you may be thinking to yourself, "That's nice to know. But what does that have to do with anything?" My answer is, to be honest, "Not a whole lot". The only reason why this incident came to mind is due to a long series of random associations in my mind, originating from the name of the RAM we are reviewing today. To not waste any more of your time, here's the $1,000,000 question: How well does the Patriot Viper Xtreme Division 2 PC3-15000 2x4GB, a product from our fellow American neighbors, step up against the competition? With popular entries from Taiwan, other American manufacturers, and nothing from Canada, read on to find out what we have found!
  FULL STORY @ APHNETWORKS

Zalman ZM-VE200 External HDD Case + Virtual Drive Review
     Wed, Aug 24 2011 | 3:08P | Hard Drives | PermaLink
Posted by: STAFF
USB 3.0 compatible External HDD Enclosures may hold the top spot in terms of raw data transfer speeds but the latest offering by Zalman called the ZM-VE200 offers very good performance via eSATA, excellent build quality, VFW display screen, software-free ISO image mounting and all that at a killer price.
  FULL STORY @ RWLABS

Asus Sabertooth AMD 990FX Motherboard
     Wed, Aug 24 2011 | 3:07P | Motherboards | PermaLink
Posted by: STAFF
"There are a wide array of motherboard manufacturers cranking out AM3+ boards, with chipsets ranging from the venerable 760G up through the gamut of 800 series. Of course AMD has also refreshed its chipset naming to match the new CPUs, and motherboards based on the 970, 990X and top dog 990FX are also available. It's two of these 900 series of boards that ASUS has sent over for review; the one we will be focusing on today is the Sabertooth 990FX."
  FULL STORY @ OCIA

Deus Ex: Human Revolution Performance Preview
     Wed, Aug 24 2011 | 3:05P | Games | PermaLink
Posted by: STAFF
We secured an advance copy of Deus Ex: Human Revolution so that we could show our readers how the game will perform when it launches later today. We've given it a quick once-over with four different video cards. We have a full run-down of the game coming after it officially launches, but this is here to whet your appetites now!
  FULL STORY @ HUMAN

 
Nexus SM-9000C Silent mouse
     Wed, Aug 24 2011 | 3:05P | Mouse Pads | PermaLink
Posted by: STAFF
We've reviewed a couple Nexus mice in the past, and today we will take a look at their newest no-sound mouse called SM-9000. SM-9000 is similar to the ones we've reviewed in the past except that it is a full-sized mouse with some nice new features. Read the full article and see how well it performs.
  FULL STORY @ RBMODS

MSI N560GTX TI HAWK
     Wed, Aug 24 2011 | 3:05P | Video Cards | PermaLink
Posted by: STAFF
The MSI N560GTX TI HAWK addresses customers who are interested in overclocked graphics cards but still want to overclock even further. Can it compete against the competition?
  FULL STORY @ HT4U

AMD A6-3650, A8-3850 APUs
     Wed, Aug 24 2011 | 3:04P | CPU / Processors | PermaLink
Posted by: STAFF
"AMD's Bulldozer architecture is still a few more months away, but now we at least have new APUs to tinker with in the mean time. And while Brazos APUs were aimed at 'surrogates' like nettops/netbooks, the new Sabine and Lynx platforms are more full-fledged and intended for real PCs: mobile and desktop, respectively."
  FULL STORY @ IXBTLABS

Sennheiser PX 200-II
     Wed, Aug 24 2011 | 3:03P | Audio / Sound | PermaLink
Posted by: STAFF
Sennheiser\'s newest portable headphones are dubbed the PX 200-II. Its design closely resembles that of the previous high end ultra portable offering, the PX 200s. The new II-version features a multitude of smaller upgrades.
  FULL STORY @ TECHPOWERUP

Coolmax V-500 Power Supply Review
     Wed, Aug 24 2011 | 3:03P | Power Supply | PermaLink
Posted by: STAFF
"The Coolmax V-500 costs only USD 22 at Newegg.com and, therefore, we were very skeptical that it could deliver its labeled wattage, 500 W. Wattage, as we always explain, isn't everything. Let's see the other downsides of using a cheap power supply."
  FULL STORY @ COOLMAX

Sapphire Pure Platinum H67 Socket 1155 Motherboard
     Wed, Aug 24 2011 | 3:03P | Motherboards | PermaLink
Posted by: STAFF
Today, we will take on the Sapphire Pure Platinum H67. Yes, Sapphire is making motherboards again. If you weren't aware of this, then we suggest taking a look at our exclusive on their P67 offering here. Getting back to the matter at hand, the Pure Platinum H67 takes advantage of everything the H67 chipset has to offer like SATA III, PCIe 2.0, built-in graphics and support for the Sandy Bridge processor. Sapphire is entering every phase of motherboard manufacturing, but lets see if the Pure Platinum H67 is worthy of your dollar bills.
  FULL STORY @ PLATINUM

Corsair Force GT 120 GByte Review
     Wed, Aug 24 2011 | 3:03P | Memory | PermaLink
Posted by: STAFF
With the Force GT, Corsair has a Solid State Drive in its portfolio which is based on the latest SandForce SF-2281 series SSD processor. The drive also features SATA-III support and Corsair claims that the it can reach throughput rates of more than 500 MByte. Also for the IOPS the manufacturer promises sky-high numbers. When processing 4 KByte blocks the Force GT should be able to max out at a whopoing 85'000 IOPS.
  FULL STORY @ OCAHOLIC

VTX3D Radeon HD 6790 1GB
     Wed, Aug 24 2011 | 12:03P | Video Cards | PermaLink
Posted by: STAFF
www.pcstats.com

With all the fancy and feature-dripping high-end video cards it's easy to forget some of the better value cards on the market today, and the fact that not everyone has the budget, or even the need, for a $500+ video card. So today we take a look at VTX3D's Radeon HD 6790 equipped with 1GB of speedy GDDR5 memory linked to a 256-bit memory interface, 800 stream processors with over 1.3 Teraflops of compute power, and support for latest the DirectX 11 features.

  FULL STORY @ OVERCLOCKERS

Cooler Master GeminII S524 HSF
     Wed, Aug 24 2011 | 12:02P | Cooling / Heatsinks | PermaLink
Posted by: STAFF
The Cooler Master GeminII S524 is a great cooler that has more than enough cooling potential for stock builds that want to be silent. It also has excellent cooling potential for users who want to push their hardware as far as they can; the 4.0Ghz San Ace test is a good example of this. The only thing we would have liked to see with the S524 us a simpler install method.
  FULL STORY @ REVIEW

General News NEWS PAGE: of 1272    

Hardware Sections     04/16/2014 | 3:03PM  
Beginners Guides
PCSTATS RSS Feeds
RSS Newsletter
RSS News
Motherboards
Mouse Pads
Networking
Notebooks
Peripherals
Powersupply
Printers
Servers
Videocards
Editorials
Cases and Access.
CD-ROMs
Computers / SFF PCs
Cooling - Heatsinks
CPU / Processors
Digital Cameras
Hard Drives
Home Theatre
Memory
MP3 Players
Monitors
Technology Content    
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Beginners Guide: Hi-Resolution Panoramic Images with MSFT ICE
Jan 27 | Beginners Guides  
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Samsung ATIV Book 9-Lite NP915S3G-K01 13.3-inch Touch Screen Notebook Review
Dec 23 | Notebooks
Rating:  
Seagate FreeAgent GoFlex TV HD Media Player Review
Seagate FreeAgent GoFlex TV HD Media Player Review
Nov 25 | Home Theatre
Rating:  
Beginners Guide: How To Install / Remove an Intel Socket LGA2011 CPU
Beginners Guide: How To Install / Remove an Intel Socket LGA2011 CPU
Nov 19 | Beginners Guides
Rating:  
Beginners Guide: Install/Remove Intel Socket LGA1156 CPU and Heatsink
Beginners Guide: Install/Remove Intel Socket LGA1156 CPU and Heatsink
Nov 18 | Beginners Guides
Rating:  
Beginners Guides: Repairing a Cracked / Broken Notebook LCD Screen
Beginners Guides: Repairing a Cracked / Broken Notebook LCD Screen
Oct 02 | Beginners Guides
Rating:
A broken or cracked LCD screen makes a laptop utterly useless, good thing PCSTATS can show you how to replace that busted laptop screen with a minimum of fuss and for less money than a service center charges. PCSTATS will be fixing a cracked LCD screen on a Lenovo T530 ThinkPad notebook, the general procedures outlined here work for any notebook though.
Gigabyte GA-X79-UD5 Intel X79 LGA2011 Motherboard In-Depth Review
Gigabyte GA-X79-UD5 Intel X79 LGA2011 Motherboard In-Depth Review
Jul 27 | Motherboards
Rating:
The Gigabyte GA-X79-UD5 is an awesome 'Sandy Bridge-E' motherboard for anyone in the business of content creation, yet still nimble enough to take on multi-videocard gaming and overclocking at the end of a days work.
MORE » Complete PCSTATS Article and Review Listings...

The best Guides by the best writers on the internet; PCstats Beginners Guides explain computers, software, and all those other wonderful things that cause you frustration.

Learn how to use your computer better, master the internet while protecting yourself, and know what to do when your hard drive kicks the bucket.

  1. 10 Steps to a Secure PC
  2. 101 Tips and Tweaks for Windows XP
  3. 104 Killer Tech Tips for Windows XP
  4. 99 Performance Tips for Windows XP
  5. 99 Windows Vista Performance Tips
  6. Annual PC Checkup Checklist
  7. Assembling Your Own PC
  8. Back up and Restore Data in WinXP
  9. Browser Hijacking and How to Stop it
  10. Building a Home Theatre PC / HTPC
  11. Burning CDs and DVDs
  12. Cloning WindowsXP
  13. Converting Videotape Into Video Files
  14. Crash Recovery: The Blue Screen of Death
  15. Creating a Weblog / Blog
  16. Creating MP3 Music Files
  17. Decrypting Lost Document & Zipped File Passwords
  18. Diagnosing Bad Hard Drives
  19. Diagnosing Bad Memory
  20. Downgrading Windows Vista Back To Windows XP
  21. Dual OS Installation of WindowsXP 32-bit/64-bit
  22. Encryption and Online Privacy
  23. Ergonomics & Computers
  24. Flashing a Video Card BIOS
  25. Flash Memory Data Recovery and Protection
  26. Firewalls and Internet Security
  27. Firewall Setup and Configuration
  28. Forgotten Passwords & Recovery Methods
  29. Formatting and Partitioning a Hard Drive
  30. Fundamentals of Upgrading a PC
  31. Hard Drive Data Recovery
  32. Home Networking and File Sharing
  33. How to Install: Intel Socket 775 CPU and Heatsink
  34. How to Install: Intel Socket 1366 CPU and Heatsink
  35. How to Install: Intel Socket 1155 CPU and Heatsink
  36. How to Install: AMD Socket AM3 CPU and Heatsink
  37. How to Install: AMD Socket FM1 CPU and Heatsink
  38. How to Fix Homesite Design Mode to Work in WindowsXP/ Vista
  39. How To Make a Budget Desktop Computer on the Cheap
  40. How to Update a Motherboard BIOS
  41. Installing RAID on Desktop PCs
  42. Installing Windows Vista
  43. Installing Windows XP
  44. Internet Connection Sharing
  45. Legally Copying Software and Music
  46. Linux Part 1: Getting Familiar
  47. Linux Part 2: Installing a PC
  48. Linux Part 3: New Software
  49. Little Known Features of WindowsXP
  50. Making Old Software Compatible with Windows Vista
  51. Making DVD Movies from Video Files
  52. Most Common Ways to Kill a PC
  53. Optical Drives & Recording Formats
  54. Overclocking the CPU, Motherboard & Memory
  55. Overclocking the Videocard
  56. Preventing Data Theft from a Stolen Laptop
  57. Printer Sharing on a Home Network
  58. Quick Guide for Eliminating Spyware and Hijacker Software
  59. RAM, Memory and Upgrading
  60. Registry: Backups, Repairs, and Protection
  61. Remote Access to Computers
  62. RSS Feed Setup & Subscriptions
  63. Safe Mode in Windows Vista For Crash Recovery
  64. Setting up an FTP Server in WinXP
  65. Slipstreaming WindowsXP with Service Pack 2
  66. Spyware Protection and Removal
  67. Stopping Spam
  68. Stopping Vista From Thrashing Hard Disks to Death
  69. Synchronizing Files and Folders
  70. Unattended Windows 2000/XP Installations
  71. Understanding & Creating Batch Files
  72. Understanding & Tweaking WindowsXP Services
  73. Upgrading A Motherboard Without Reinstalling
  74. Upgrading Win98 to Windows XP
  75. USB Memory Drive Projects & Tips
  76. VPNs and Internet Connection Security
  77. Website Hosting From A Home PC
  78. Website Hosting With Apache
  79. Windows Vista Crash Recovery and Repair Install
  80. Windows XP Command Prompt
  81. Windows XP Safe Mode Explained
  82. Wireless Home Networking
  83. Wireless Network Security
"Get the 'Stats and Stay Informed!"


Frostytech's Top 5 Heatsink Comparison Charts

Recommended Tech Resources:
Tom's Guide Frostytech.

 
The PCstats Forums
 
PCstats Network Features Information About Us Contact
FrostyTech
TransmetaZone
BeginnersPC
PCSTATS Newsletter
PCSTATS Forums
ShoppingList Assistance
Tech Glossary
Technology WebSite Listings
PermaLink News
Archived News
Submit News (Review RSS Feed)
Site Map
PCSTATS Wallpaper
About Us
Employment
Privacy Policy
Advertise on PCSTATS

How's Our Driving?
© Copyright 1999-2014 www.pcstats.com All rights reserved. Privacy policy and Terms of Use.