Skip to main content

Posts

Showing posts with the label Google Spreadsheets

The $100 Barrel is Back: Why Your Next Trip to the Pump Just Got Expensive

If you feel like you’re paying more to fill up this week, you aren’t imagining it. The conflict in the Middle East has officially hit the "Oil Phase," and the numbers coming off the ticker are starting to look like a crisis. Here is the breakdown of why gas prices are spiking and what the world is doing to stop the bleeding. 1. The $100 Barrier has Shattered For the first time in over three years, oil prices have officially surged past $100 per barrel . At the peak of the panic this week, Brent crude hit nearly $120 , driven by one simple fear: the total closure of the Strait of Hormuz. Because 20% of the world’s oil passes through that one narrow waterway, the moment Iran threatened it, the markets went into a tailspin. 2. Pain at the Pump: By the Numbers This isn't just a "Wall Street" problem; it's a "Main Street" problem. The U.S. Average: Nationwide gas prices have jumped roughly 27 cents in a single week , hitting an average of $3.58 per gal...

How To Use GoogleLookup in Google Spreadsheets

Just like Microsoft Xl google Spreadsheets also has a lookup function. XL has the vlookup  The V in VLOOKUP stands for vertical. Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data that you want to find. Google Spreadsheets are becoming more and more popular because it is so easy to use and you can open documents from Gmail directly into Google Spreadsheets.  Here is a brief explanation on using this feature given by the Google Docs Blog .  To use the GoogleLookup function, enter the following formula in the desired spreadsheet cell: =GoogleLookup(“entity” ; “attribute”)  where “entity” represents the name of the entity you want to access and “attribute” is the type of information that you want to retrieve. For example, I want to know the atomic number of gold. In this case, gold is the entity while atomic number is the attribute. In the desired cell, I enter =GoogleLookup(“Gold” , “Atomic Number”). Be sure to include quotation mar...