Unique Solution Search Results

How To: Solve a system of linear equations by substitution

System of equations is nothing but a system which contains more than one linear equations. This system of equations can be solved to arrive at the solution of the system. A simple system of the linear equations can be a pair of equations. To solve this kind of system you can employ the substitution method. So take the two equation of the system. Solve for the value of y in the first equation in terms of x. Now take this value of y and substitute in the second equation y value. Now the second ...

How To: Cut up your t-shirt and look unique and stylish

In this Beauty & Style video tutorial you will learn how to cut up your t-shirt and look unique and stylish. Take a loose baggy style shirt and make two marks with scissors just near the shoulder seam. Then cut down the center of the t-shirt about 2inches. Now cut from the shoulder marks up to the center point and on the back just cut straight along the shoulder cut marks. Then cut open the top part of the sleeves little short of the shoulder seams. After this cut off the bottom seam. Then st...

How To: Make potassium trichromate

In this how-to video, you will learn how to make potassium trichromate. You will need potassium chromate and dichromate. It is easy to go between the two. You can add a base to the dichromate to make the chromate. It will go from orange to yellow. The trichromate can be produced. You will need nitric acid, potassium dichromate, and sodium disulphate. First, make a solution of sodium sulphate. Take a long test tube and the potassium dichromate to it. Add double the volume of concentrated nitri...

How To: Extract a unique list from a huge data set 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 581st installment in their series of digital spreadsheet magic tricks, you'll learn how to use the advanced filter tool with criteria to extract a unique list of employees for each department from a huge data set with transactional records.

How To: Group duplicates & extract unique records 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 577th installment in their series of digital spreadsheet magic tricks, you'll learn how to use SUMPRODUCT and the join symbol (&/ampersand) to group duplicates and then see how to use advanced filtering to extract a list of unique records.

How To: Dynamically count unique words in a column in MS Excel

New to 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 Excel tutorial from ExcelIsFun, the 293rd installment in their series of digital spreadsheet magic tricks, you'll learn two cell formulas and a named formula that will dynamically count unique words in a column. As you add new records, the count will automatically update. This is accomplished through use of Excel's MAX, ROW, OFFSET, SUMPRODUCT, ISTEXT and COUNTIF f...

How To: Make a champagne ginger cocktail

Bartender Gene shows you how to make a unique, healthy, ginger infused cocktail. Simmer 1/2 cup water, sliced, fresh ginger and sugar to make a ginger infused syrup. Remove from heat, let cool, then add 1/2 cup vodka and refrigerate. When your syrup is cool, strain out the ginger and throw it away. Place candied ginger at the bottom of the glass and pour in about a tablespoon of the syrup. Top off with sparkling wine and serve. Follow these easy steps to create a celebratory, unique, good for...

How To: Milk a cow

Modern milking parlors use machines, but milking a cow by hand is an ancient art. Here’s the "udderly" perfect way to do it.

Spice Rack Explosives: How to Make Gunpowder with Salt & Sugar

The best chemistry experiments are those you can perform with items already laying around your house. With only some sugar, salt substitute and an instant cold pack, you can make your very own gunpowder! Being able to make homemade gunpowder without a trip to the store can be a lifesaver, no matter if it's just for testing out a Civil War-era musket, blowing up stubborn tree stumps, or preparing for battle when imperialists overrun your country.

How To: Grind your own spices

In this tutorial, we learn how to grind your own spices. Spices grow all over the world, which can give them all unique tastes. Start off by grabbing the spices that you want to mix together. Use your favorite spices to make your own unique tastes. If you are roasting, you should not roast or toast the spices all together at once, so they don't incorporate smells. After you do this, you will use a mortar and a pestle to crush down the spices. Start pounding on the spices to release the oils a...

How To: Write a unique personal statement essay

In this tutorial, we learn how to write a unique personal statement essay. Personal statement is the heart of the application where you can give voice to your accomplishments, dreams, and goals. You want to stand out from the rest of the applicants, so you need to express what's important to you. You can show them how well you write and show passion, your smarts, and sense of humor as you write. You can do this because you are prepared and you are being true to yourself. Once you understand t...

How To: Turn a tank top or tee into a better fitting, cute, unique shirt

Your tanks and your tees aren't fitting just right, don't throw them away or toss them in a storage box just yet. Grab some scissors and cut that sucker up, then mold it in a better fitting, unique and cute shirt. The easiest part is simply slicing up the back up the shirt, but then comes the strings. Watch and see for yourself. This is a great way to transform a normal T-shirt or tank top into something more creative.

How To: Do funky grooves on your guitar

In this video, we learn how to play guitar: Funk Grooves. First, learn how to slide your finger from the ninth chord using the third bar. As you do this, it will create a groove in your music that is unique and very "funky". Once you learn how to do this, you will be able to make funk groove music easily. Don't forget to mix things up with other chords to make up your own unique sounds as well. Remember to make sure you keep your right hand moving as you play, so you don't create any squeaky ...

How To: Create a column of unique values in an Excel LU table

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 159th installment in their series of digital spreadsheet magic tricks, you'll learn how to solve Duplicate VLOOKUP function problems with a COUNTIF formula that creates a column of unique values for the first column in the lookup table.

How To: Dry fruit from your garden

Curtis Smith of Southwest Yard and Garden show viewers how they can dry fruit from their garden. First, you need to wash your hands before handling your fruit. To wash your hands you want to remove any jewelry, wet your hands, lather your hands and rub them together for 20 seconds and rinse. Dry them on a clean towel so you don't recontaminate. You can dry fruit in your oven if you don't have a dehydrator by setting your oven on the lowest setting, 150 degrees F, and leaving the oven open unt...

How To: Remove fake nails with acetone

Joyce teaches viewers how to remove fake nails by using acetone. First, you should get acetone solution and submerge your nails into the solution for a few minutes and the nails will come off by themselves. For fake nails, you can apply nail polish remover and the nails will easy pull off. You can also just wait for your nails to grow and the fake nails will naturally fall and you can just easily pull them off. You can also get a cutter and slip this in between your fake nail and real nail an...

How To: Perform the Barus effect

Watch this instructional science video to observe the Barus effect in action. A dyed solution of POLYOX (polyethylene oxide - it is the stuff used as the lubricant on the strip found in all modern razors) is extruded from a 50 mL syringe. On exit, a marked swelling in the liquid stream several times the diameter of the orifice is observed. The effect is referred to as the Barus Effect, but it also goes by several other names including the Merrington Effect, Die Swell, and Extrudate Swell.

How To: Create an arched top keepsake box

In this how to video, John W. Nixon from Eagle Lake Woodworking demonstrates how to build an Arched-Top keepsake made from Cocobolo. This unique arched-top keepsake box is an eye catching item with a unique feature on the inside, a place to frame a picture. The process for making a dovetailed box is detailed in this video, as well as, the procedure for shaping the arched lid. Watch this how to video and you can create an arched top keepsake box to give as a gift or keep for yourself.