msgbartop
Blog About Stuff That's In Your Home | Appliances and Stuff
msgbarbottom

07 Nov 11 Excel Lookup Series #1: VLOOKUP Function 1st Example

See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from column 2 of lookup table. Use Named Range, Data Validation and VLOOKUP to make your lookup more accurate. In This Series learn 15 amazing ways to look things up in Excel. We will look at the functions VLOOKUP, HLOOKUP, LOOKUP, MATCH, INDEX, CHOOSE, and the non-function lookup formula using the intersector operator. We will look at simple lookups all the way to complicated, yet efficient methods to look things up in Excel. This is a logical (beginning to end) story about most of the lookup situations you may encounter in Excel. Excel Magic Trick 167p2 IF function formula: 12 Examples! Excel Magic Trick 167p1 IF function formula: 12 Examples!

Tags: Example, Excel, Function, Lookup, Series, VLOOKUP

16 Aug 11 Esbit Stove Example

A short how-to on using hexamine fuel bar with the Esbit to boil some water.
Video Rating: 4 / 5

All-Brick Rocket Heater. Walls are 4.5″ thick. Wood box / air intake opens @ 4.5″ by 9″, same for burn tube, heat riser & initial exhaust. 10 Bricks per layer in the heater, 16 layers high. Around 180 brick in this heater. One bag of masonry heater mortar. Absorbs lots of heat and gives it out for hours after heater shut down. Plans ? LARSmith217@GMail.Com ( looking for buyer for selling rights to this heater )
Video Rating: 4 / 5

Tags: Esbit, Example, Stove

06 Jun 11 Cisco ASA Version 8.3 NAT Configuration Example

Video Rating: 5 / 5

Hector, the world’s first robotic adult film star, goes to town on household appliances.
Video Rating: 4 / 5

Tags: Cisco, Configuration, Example, version

01 Mar 11 Volumes of Revolution – Disk/Washers Example 2

In this video, I use the same region from part 1, but now I rotate the region about the line y = – 2. For more free math videos, visit PatrickJMT.com

Two window washers in Sao Paulo are recovering from a scare Tuesday, after 49-mph winds caused their cart to swing dangerously back-and-forth, nearly 100 feet above ground. Both men were taken to the hospital for minor cuts and bruises. (May 5)
Video Rating: 4 / 5

Tags: Disk/Washers, Example, Revolution, Volumes

20 Feb 11 Volumes of Revolution – Disk/Washers Example 1

Volumes of Revolution – Disk/Washers Example 1. A problem is shown about how to use the disk/washer method to find a volume of revolution about the X axis.
Video Rating: 4 / 5

Two window washers in California have been rescued after dangling from a high-rise building after their work platform tilted. Officials say the metal scaffolding slipped but the workers didn’t fall because they were wearing safety harnesses. (Aug. 7)

Tags: Disk/Washers, Example, Revolution, Volumes