Excel: Create a Pictograph
A pictograph is a graphs that is created with pictures of the represented object instead of bars or lines. They provide interesting and unique ways to present data and can be created in Excel using these directions.
ODBC Error – The specified DSN contains an architecture mismatch
This will fix a common error trying to add or configure a database source in Windows 7.
iPhone: Create Custom Vibration Patterns
Creating your personal vibration pattern on your iPhone is easy. No jailbreak required.
Photoshop CS6: Easy Subject Removal
Have you ever wanted to remove something from your photos, but worried that you don’t have the Photoshop skills to do it? With the new Content-Aware fill feature in CS6, even Photoshop amateurs can seamlessly remove unwanted content from their pictures.
uTorrent: Dramatically Increase Download Speeds
Using these simple adjustments should greatly improve uTorrent download performance.
Are you tired of uTorrent’s sluggish download speed that does not take full advantage of your high speed internet? This is a very frequent complaint among uTorrent users that can be fixed by tweaking uTorrent’s settings.
For this tutorial we are going to assume that you have uTorrent running and a torrent is being downloaded.
As you can see, our current speed is only at 146kB/s. Considering my broadband capabilities, I am not using my entire download potential.
1. Bring up the Preferences window by either pressing Ctrl+P or clicking Options -> Preferences.
As you can see both maximum upload and download speeds are set at 0. uTorrent even tells you that 0 means that your download will be executed at its maximum potential. In many circumstances, however, this is not the case.
2. Now we have to change the download speed to something much higher than the expected allotted bandwidth. We will use 3000kB/s. You will likely set the upload speed to as little as possible; however, do not set lower than 7kB/s. We’ll use 8kB/s.
Note: If you set the upload limit to below 7kB/s, uTorrent will cut off your download speed exponentially.
3. Press Apply then OK.
Congratulations you’re done. If this works for you, you should soon notice an increase in your download speeds.
Through these steps, I have increased my download speed almost by a factor of five. Obviously, your mileage and success will vary on your broadband potential. In many cases, however, this tweak will dramatically improve your torrent download speeds.
Create a Histogram Graph in Excel
A histogram graph is used to graphically demonstrate the distribution of data within Excel. The instructions here are for Excel 2013, but histograms can be created in prior versions of Excel in a similar fashion.
Use Photoshop To Remove Blemishes, Pimples, and Moles
Photoshop’s wonderful Patch Tool will let you retouch your image to remove common skin imperfections. This is a common, uncomplicated task that anybody who uses Photoshop can accomplish.
SQL Server: How to Swap Values between Two Columns
When working with databases, moving and swapping values between columns is a common task.
How to Browse the Web Anonymously with Tor
The power of the Tor Browser Bundle allows you to browse the internet anonymously.
Install Pear on Windows 7 64x using WAMP
Installing PEAR on Windows 7 seems simple; however, a few headaches with some recent versions of PHP can leave some people confused. The go-pear.bat file doesn’t exist in some 64x downloads of WAMP and PHP. By following these steps to workaround this issue, you should be able to get Pear installed into your WAMP setup.
Use Python 2 with the Python IDLE on Windows
