Costly Errors Search Results

How To: Avoid Wind Knots in Braided Line

Many people who use braided line complain that it gets wind knots which may have to be cut off and expensive line discarded. Almost all "wind knots" have nothing to do with the wind and are caused by user error. This video explains how to avoid those knots and start taking advantage of braided fishing line.

How-to Ruby : Simple SSH Bruteforcer

Hello fellow training hackers. I do not know if many of you are familiar with ruby, but since it is a useful scripting language, that hasn't been covered too much here on Null Byte, I thought why not do some How-tos about it now and then.

How To: Pop a Car Lock with a Coat Hanger

You've done it, I've done it, almost everyone who owns a car has done it: they've gone an locked themselves out. Well, this good how-to shows how to get back into your older model car with nothing more than a coat hanger. It will requre some trial and error to get it done, but this video is a good primer.

How To: Prank your friends into thinking their computer has had a major DOS error

DOS may be a distant memory for most computer users at this point, but for many it will always be the first thing that pops into their head when they ponder PC computing. Nowadays, the only time most people see anything that even looks like DOS is if they're playing old PC games in a shell or something has gone very, very wrong with their computer. With this prank, you can make your friend believe that the latter has happened to them! All you do is open the DOS command program (Windows XP or ...

How To: Restart Windows OS without rebooting your computer

This how to video shows you how to restart Windows without rebooting the computer. Press control, alt, and delete on the keyboard at the same time. Your task manager program will open. Select processes and click image name to sort it. Select explorer.exe and press end process. Click yes in the warning dialog. Your start menu will disappear. This is usually bad considering you cannot do anything when this happens. Go to file and select new task. Click browse and click on any folder and right c...

How To: Learn to set Type on a Letterpress

Check out this 1959 instructional film on how to manually set type on a letterpress. You can use these techniques to create posters, chapbooks, artist prints, and all kinds of D.I.Y. old school printing fun. All graphic designers and anyone working in the printing should check this out. The video demonstrates basic principles of typesetting and distribution. The film stresses the correct way of manipulating the type, spotting letters before they are chosen and the importance of following copy...

How To: Use Excel round function & number formatting

In this video the instructor shows how to use the Round function and also format numbers in Microsoft Excel. Normally while calculating formulas in Excel, the formatting of numbers can get you into a lot of trouble and to get around this problem you need to use the Round function. To do this take some sample data in a Excel work book and apply any formula that you want on the data to arrive at some calculation. Now because of this formatting some times you can arrive at a wrong result as show...

How To: Dance with sexy booty shaking moves at the club

Let this video be as integral a part of your pre-club prep as hairstyling and putting on makeup. After all, we know that even if we're looking our sexiest in our six inch Blahniks, once we actually hit the dance floor it becomes Awkward Central. Some gals find their groove naturally, but for others, it takes a bit of trial and error (and maybe some Jack Daniel's) to loosen up a bit.

How To: Ignore nested subtotals with AGGREGATE in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 664th installment in their series of digital spreadsheet magic tricks, you'll learn how to make a calculation on a column of values that contain subtotals that you do not want to include in the calculations. The AGGREGATE function will ignore nested SUBTOTAL and AGGREGATE functions when making calculations.

How To: Ignore filtered values making calculations in MS Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 665th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function to make calculations on filtered data. The SUBTOTAL function only has 11 functions, whereas the AGGREGATE has 19 plus options to ignore errors, hidden rows and nested SUBTOTAL or AGGREGATE functions.

How To: Use the AGGREGATE function in Microsoft Excel 2010

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 669th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the AGGREGATE function in Microsoft Excel 2010 and later. This new function is better than SUBTOTAL function because 1) the options argument set to 18 will calculate Percentile and 2) AGGREGATE can handle arrays. See how th...

How To: Use noodle-based compositing in Blender

Conceptually, what is node-based compositing and what do nodes do? This clip uses the factory analogy to convey the concept. Blender can process video, images, sequences, and families of images in a directory. Then you'll fire up Blender and talk about threading nodes and how images are duplicated and routed through the compositing network ("noodle"), how threads are created between sockets. Creating threads, cut threads. The clip also points out common threading errors and misrouting threads...

How To: Fix a DGET #NUM! error in Microsoft Excel

New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 595th installment in their series of digital spreadsheet magic tricks, you'll learn how to resolve a problem that the DGET function and advanced filter have with criteria and duplicates. See how to switch to either the VLOOKUP function or not criteria for advanced filter.

How To: Build a unique terraced garden

In this episode of Southwest Yard and Garden Curtis Smith shows you how to turn a steep slope into a usable garden. By building walls along the slope using serpentine designs he shows you how to obtain a compromise of both strength and artistic design. Starting with a good concrete footer and rebar you can construct a retaining wall strong enough to hold the weight of the slope. Materials such as wood and railroad ties can be used but may not stand the test of time as the weight of the soil c...

How To: Check spelling and grammar in MS Word 2010

This video tutorial is a quick explanation of the ins and outs of spell and grammar check when using MS Word 2010. One of the main things highlighted in this video is that unlike previous additions, this year's version offers more contextual correction. For example, when the word their was used in an article, it was spelled correctly but used in the wrong context. The spell and grammar checker will underline this to let you know that it is incorrect. If you hit the spell and grammar check but...

How To: Get unbooted in Farm Town (09/04/09)

Farm Town hacks, cheats, glitches. How to hack Farm Town. Watch this video tutorial to learn how to get unbooted in Farm Town (09/04/09). This helps when you are plowing or harvesting someone else's farm and that booted error screen comes up telling you to reload the game.

How To: Understand circuit bending

In this video, we learn how to understand circuit bending. Circuit bending is noodling around with circuitry to see how it sounds and get different noises out of it. When you go into a motherboard and see the circuits that are inside of it, these can make noise if you re-circuit them. This can help you be creative and turn the electronic circuit board into a canvas. This can let someone immediately create something out of this and use it as an art form. It takes trial and error to find someth...

How To: Verify a drive on your Mac

In this video tutorial, viewers learn how to verify a drive on a Mac computer. Begin by opening Finder and select Applications. Open Utilities and then select Disk Utility.app. Now select a disk drive that you would like to verify. Make sure that you are in the First Aid tab and check the Show Details. Then click on Verify Disk. Now wait for the drive to be verified. Once finished, it will display all the items that were checked. This video will benefit those viewers who use a Mac computer an...

How To: Batch resize photo in Photoshop

Are your high resolution photos taking too much space on your hard drive? Tired of getting file too large error when emailing photos? Don't worry Photoshop Samurai will help you batch resize your photos as fast as a ninja! You will need: Photoshop (Not Elements version), photos that need to be resized Go to file, then scripts and select image processor. Select the source folder (where your pictures are stored on your computer). Then select a destination location (where you would like the proc...

How To: Create a system repair disc in Windows 7

This video teaches you how to create a system repair disc in Windows 7. Go to Start-All Programs-Maintenance-Create a System Repair Disc. This will help you boot Windows to repair or recover your system after a serious error. Once you click that, Windows 7 will prompt a new window telling you to put a blank disc in your disc drive. Make sure that you do have a blank DVD to insert, for the Windows 7 to create that System Repair Disc. Wait for the process to finish and you have yourself a syste...

How To: Register a dog with the AKC

You have a purebred, make it official. With a few simple forms your purebred dog can be a member of the American Kennel Club and carry on the traditions of and gain access to this exclusive organization. Your dog can have an official pedigree.

How To: Jailbreak version 3.1.2 iPhone and iPod with Blackra1n

iPodTouchHelping teaches you how to Jailbreak version 3.1.2 iPhone and iPod using Blackra1n. Connect your iPod or iPhone to your computer and make sure it appears in iTunes. You need to go to Blackra1n and click on the Windows icon. Download the program and run it. Click Make it rain in the Blackra1n application. You might get some error messages, just ignore them. The process will finish and the device will reboot. You will see the Blackra1n icon on your device, tap that and select Cydia and...