Wow! No longer do you have to buy those huge marble machine roller coaster toys — you can DIY one! This video covers the materials, tools and techniques used to make a homemade rolling ball marble machine. If you haven't seen this rolling ball marble machine toy in action yet, WATCH IT. It's a looping rolling marble machine made with wood, rebar tie wire and polyurethane tubing, featuring a magnetic elevator.
return a descending sorted list of country names based on the values in a row using an array formula that itself makes use of Excel's INDEX, MATCH, RANK, COLUMN and COLUMNS functions.
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 141st installment in their series of digital spreadsheet magic tricks, you'll learn how to take the number 1 (for day one of the month) and use the DATE function to convert it to a serial number formatted as a date.
Some savings plan pays interest 365 days in a year but you make deposit monthly. You can use Excel functions to calculate the maturity value of the of the monthly plan. To do this you have to use the nominal and effect functions before using the future value functions. First enter the know data like the monthly payment, the number of years of payment, the number of days in a year, and the annual percentage rate. First take the nominal rate and calculate the effective rate with the help of eff...
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 269th installment in their series of digital spreadsheet magic tricks, you'll learn how to
This video shows the method to graph a linear function by finding the X and Y intercept. Only two points are needed to graph linear functions. So we find the point on Y axis or the Y intercept and the point on the X axis or the X intercept. We notice that on the Y axis the X coordinate is zero. So, we find the Y intercept by putting x=0 in the given equation and solving for y. In the same way, we find the X intercept by putting y=0 in the given equation and solve for x. We join the two points...
This video shows how to find the formula of a piecewise function when given a graph. The first step is to write a definition for the graph, which is done by identifying the different domains shown in the graph. The second step is writing formulas for each domain specified by the lines in the graph. The point-slope formula is used to identify the slope and y-intercept for the leftmost domain, which has a sloped line. A point and horizontal line make for simpler equations in the other pieces of...
In this video, one teacher talked in detail about how to solve absolute value functions and how to translate different absolute value functions from one point in the matrix to another one horizontally and vertically. If the function is y=A|x-h|+k, generally, the diagram is symmetric based on the line of X and can be moved vertically based on k. The teacher gave several examples to explain how to illustrate the absolute value function. He started with a simple one: y=|x-h|, then continued with...
Finding horizontal asymptotes is very easy! Not all rational functions have horizontal asymptotes. the function must satisfy one of two conditions dependent upon the degree (highest exponent) of the numerator and denominator. If the degree of the numerator is equal to the degree of the denominator, then the horizontal asymptote is y= the ratio of the leading coefficients. If the degree of the denominator is greater than the degree of the numerator then y= 0. If the degree of the denominator i...
Learn how to convert your multi-function cleaner from dry vacuuming to washing carpets with this tutorial.
Use the Excel Vlookup function in Microsoft Excel 2007 to look up data in a table. This tutorial looks up the level and value of a product from a stock list using the Vlookup function in Excel.
Looking for a fun, simple project to do with your kids this winter season? This cheap and simple art project won't cost you a dime. Learn to make Christmas snowflakes with paper, and pretty soon you'll have great decorations to hang up on the windows.
Even getting your hair trimmed at the salon costs a fortune these days, so why not cut back on unnecessary expenses and do the trimming at home? Take a look at this video to learn how to cut edgy side bangs using a razor.
Using just a few inexpensive pieces of hardware, you can construct your own rack designed for storing and organizing spools of wire. Bolt a dowel to a wall or another rack, then thread your spools on the dowel. You can still get the wire, and now they won't move!
If you're ever done a big race before, then you've probably had to deal with attaching a paper number to your chest with safety pins. In a triathlon, where you are going to have to change clothes multiple times, having to keep unpinning and repinning that number can cost you valuable time and effort. This video will show you how a race belt can simplify the process, making switching your numbers location a breeze, even across multiple outfits.
This how-to video will show you how to make a cool and unique CD case frame for your dad on Father's Day, to make him feel all special inside. Nobody else will have a frame like this! This crafty project is a great way to recycle CD cases you no longer need, and doesn't cost you a dime!
We all remember that "special" kid from 2nd grade who always wore homemade clothing and ate glue because it tasted funny. Well, although we don't recommend you ever go chugging the Elmer's, glue is useful for more than just gluing things together.
When buying blinds or shades, first you will need to determine whether to choose an inside or an outside mount shade. Both options block light and reduct energy costs. Watch this how-to video to learn what you need to know so that you can choose which mount is right for you.
At any given time, about 10% of the UK population have warts, which costs the NHS a staggering £40m a year in treatment. In this exclusive guide, Dr McKenna discusses the various types of wart – from the common wart to the genital wart – and advises on both preventative measures and treatment options available, to ensure that these little blighters will blight you no more. This video tutorial shows how to diagnose and treat warts.
This how to video shows you how to take an inexpensive dog collar and embellish it with fabric and ribbon. Every cat or dog needs a designer collar. Learn how to make one yourself without it costing too much. Makes a great homemade Christmas gift.
Scared to start silkscreening because of the cost? Silkscreen print frames can actually be made at home, and can be used over and over again. Learn how to make a silk screen print frame at home by watching this video printmaking tutorial.
Want to send a 100MB file via e-mail? How about 1GB? This how-to video can help you do it, and it will cost you nothing. Watch this helpful internet tutorial video to learn how to email large files for free.
Love the look of a salon manicure, but don't like paying salon prices? Better TV has tips to get the professional look at home. Watch this video beauty tutorial and learn how to make nails look great yourself at a low cost.
Make a kite that cost a fraction of store bought kites and flies much further. Watch this how to video tutorial and learn how easy it is to make an amazing kite under five dollars.
See how easy it is to make your very own Naruto shoes for cosplay! They're cheap, easy to make, and fun! Anime and manga, all the way!
This video shows you how to expand your RAM in an Asus EEE PC in less than 3 minutes to 2 GByte RAM using 1 Kingston KVR667D2S5/2G Modules, which costs about 50 bucks ..
Learn how to build this mini copter at home. It costs less than five dollars to make. It will be ready to fly in less than five minutes!
How to Make Snorkelbox A $12 underwater video camera housing How to make the Snorkelbox . A $12 in parts low cost easy to make underwater
Hack a car photo to be a really awesome decorative object for your home or office at a very low cost. It's also really fun to make! All it takes is a few LED lights and a 9V battery.
In this quick video learn how to create your own custom chipboard pieces for a fraction of the cost. They look just like the ones you purchase at the scrapbook store! .
Knitting with beads is a lot like regular knitting, only you're attaching beads to your string in order to create a more pearlized look, or to add complexity to a knitted purse, flower, or hat. Adding beads is a wonderful way to switch up the old knitting routine at minimal cost and effort.
Learn a few hands in Texas Hold'em that are second best and could cost you a lot of chips. Second best and dominated hands are good to stay away from. This video will help you understand what to look and how not to loose all your chips.
Why go to the spa when you can make your own soothing salt scrub at home for a fraction of the cost? “Pauper Princess” Lynne Rominger demos how to mix up a batch of skin-softening luxury.
The business world is currently figuring out how to deal with the coronavirus crisis, with many offices opting to work remotely for at least the next few weeks as a safety precaution. Predictably, this has thrown remote meeting software back into the spotlight, especially augmented reality solutions.
One of the leading chipmakers for smartphones is getting ready to announce a new processor made specifically for augmented and virtual reality headsets.
Though Google and Apple have released their own software-based toolkits for AR, components suppliers continue to advance their technology to better support AR experiences on the hardware side.
Theorem Solutions, a company that helps engineering and manufacturing companies reduce their costs, has taken the next step with their mixed reality technology. The company has now added their own app, called Visualization Experience, to the Windows Store for the Microsoft HoloLens
Welcome back to another tutorial on functions. Last time, we looked inside memory to see what functions looked like in the flesh and all that Assembly was pretty nasty. At least you have some exposure to it. This time, we will be examining how functions work with the stack.
In the last tutorial, we learned how to make functions and how they work on the high level. This time, we will take a peek under the hood again, stare deep into its soul and see its ugliness face to face to see how it works in the lower level.
There is a question that has haunted man since the dawn of time: What if you could combine your tablet and your smartphone? Historians around the world have documented wars on the subject, and philosophers and kings who dared ask the question went down in the annals of history.