Central Perk

marți, 21 decembrie 2010

White House Staff: It Gets Better

Your Daily Snapshot for
Tuesday, Dec. 21, 2010

White House Staff: It Get Better

Inspired by President Obama’s It Gets Better video, several LGBT White House staffers decided to add their voices to the project. President Obama has more LGBT appointees than any previous administration and he is committed to making his administration reflect the diversity of our nation.

Watch the video.

Seth's Blog : The first rule of doing work that matters

[You're getting this note because you subscribed to Seth Godin's blog.]

The first rule of doing work that matters

Go to work on a regular basis.

Art is hard. Selling is hard. Writing is hard. Making a difference is hard.

When you're doing hard work, getting rejected, failing, working it out--this is a dumb time to make a situational decision about whether it's time for a nap or a day off or a coffee break.

Zig taught me this twenty years ago. Make your schedule before you start. Don't allow setbacks or blocks or anxiety to push you to say, "hey, maybe I should check my email for a while, or you know, I could use a nap." If you do that, the lizard brain is quickly trained to use that escape hatch again and again.

Isaac Asimov wrote and published 400 (!) books using this technique.

The first five years of my solo business, when the struggle seemed neverending, I never missed a day, never took a nap. (I also committed to ending the day at a certain time and not working on the weekends. It cuts both ways.)

In short: show up.

• Email to a friend •

•

luni, 20 decembrie 2010

Mish's Global Economic Trend Analysis

Grand Rapids Michigan Outsources Airport Parking Operations To Private Firm
Unintended Consequences
New York Times 10th Annual Year in Ideas; #1 Idea: Do-It-Yourself Macroeconomics

Grand Rapids Michigan Outsources Airport Parking Operations To Private Firm

Posted: 20 Dec 2010 03:58 PM PST

The trend towards dumping public unions continues to escalate in cities across the country. Latest on the list is from Michigan where a board votes to outsource parking operations at Grand Rapids airport

Airport leaders unanimously selected a private firm to take over parking operations at Gerald R. Ford International Airport today, despite impassioned pleas by employees who will now have to reapply for their jobs and likely face pay and benefit cuts.

The vote to select Chicago-based Standard Parking to manage parking came after several parking employees that are now employed by Kent County spoke during the public comment period. The group questioned the fairness of the process and asked the board to delay the vote and give them more time to negotiate to keep their current jobs.

Finance Director Brian Picardat and airport leaders said the decision was difficult and based on a projected savings of $1.5 million over five years, even after a wage concession offered by current parking employees was factored in.

In an article just prior to the decision, the Grand Rapids Press noted ...

Parking agents who do maintenance and assist customers can make between $14 to $19 an hour, not including tips. Those jobs also come with nearly a 33 percent medical and fringe benefit package.

Airport Director Jim Koslosky said the decision was tough because union leaders offered wage concessions that would have reduced the hourly pay rate to around $13 an hour, saving about $135,000 a year. But, even factoring in the wage concessions, airport staff determined that going with the private company would still result in a net savings of $1.5 million over five years. Without the wage concessions, the switch would save $1.9 million over five years.

"Standard Parking already operates the airport's express shuttle lot and valet parking services, Koslosky said. The firm beat out five other companies that bid on the contract, including Grand Rapids-based Ellis Parking.

The union members are complaining about fairness.

What can possibly be more fair to everyone than putting the contract out to bid to 5 competing firms and taking the best offer?

What's 100% fair is to watch out for taxpayers, not unions.

Expect outsourcing to intensify. It will be a major theme in 2011, and a very welcome them at that. Taxpayers have simply had enough.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com
Click Here To Scroll Thru My Recent Post List

Unintended Consequences

Posted: 20 Dec 2010 11:01 AM PST

Here is an interesting video about the unintended consequences of various government actions. Ignore the lead-in message about hyperinflation and the scratchy-sounding start of a Fox News segment on BP and oil in the Gulf. Once the video gets going, the message about unintended consequences is very well presented.

Link to Video: http://www.youtube.com/watch?v=Ij4H9M55c64

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com
Click Here To Scroll Thru My Recent Post List

New York Times 10th Annual Year in Ideas; #1 Idea: Do-It-Yourself Macroeconomics

Posted: 20 Dec 2010 09:37 AM PST

For the past 10 years, at the end of the year, the New York Times discusses 10 ideas for the past year. The ideas vary widely and may pertain to social trends, sports, or war. The lead-in idea for 2010 was "Do-It-Yourself Macroeconomics".

It certainly is an honor to be mentioned along with the Big Picture and Calculated Risk. Here is a snip from the 10th Annual Year in Ideas.

For the 10th consecutive December, the magazine has chosen to look back on the past year through a distinctive prism: ideas.

Our digest of short entries refracts the light beam of human inspiration, breaking it up into its constituent colors — innovations and insights from a spectrum of fields, including economics, biology, engineering, medicine, literature, sports, music and, of course, raw-meat clothing. Happy thinking!

D.I.Y. Macroeconomics

Until recently, the economics profession largely controlled the production, dissemination and interpretation of economic data. Now there's a new trend afoot: do-it-yourself macroeconomics, in which ordinary citizens pull apart the data and come to their own conclusions.

The democratization of economics owes much to the financial crisis that first hit in 2007. That ongoing catastrophe, which few economists predicted, tarnished the profession's reputation, prompting some to look elsewhere for answers. They turned to — where else? — the Internet, where vast amounts of economic data that had once been hidden from public view were now online. Sites like FRED, maintained by the Federal Reserve Bank of St. Louis, enabled anyone with a connection to the Web to download data on everything from local home-price indexes to credit-card balances to weekly fluctuations in diesel prices.

At the same time, a growing army of knowledgeable "econo-bloggers" began analyzing the data available online. Strikingly, many of the authors of these blogs — the brains behind the Big Picture, Calculated Risk, Mish's Global Economic Trend Analysis and others — aren't academic economists but people with real-world experience in financial markets. Their Web sites offer sophisticated interpretations of economic data and hold passionate debates with their readers over the merits of the data. As a result, economic data that were formerly greeted with grudging acceptance by the public — the latest unemployment figures, for example — are now the catalyst for endless popular exegeses.

Please see the article for a wide variety of other ideas.

Mike "Mish" Shedlock
http://globaleconomicanalysis.blogspot.com
Click Here To Scroll Thru My Recent Post List

SEOmoz Daily SEO Blog

Excel For SEOs: Manipulating URL Strings with Functions

Posted: 19 Dec 2010 01:17 PM PST

Posted by MikeCP

Over the past few months, I've been preparing a guide with the tentative title, Excel for SEOs: Lessons for Aspiring Ninjas. I've embarked on this great journey because sometime during the #Mozinar back in September I decided that my Excel abilities were far too limited, especially compared to all the smarty pants that were giving great presentations and advice about SEO data analysis.

After talking with some of my colleagues I found that I wasn't alone in my feelings of Excel inadequacy. So Excel for SEOs: Lessons for Aspiring Ninjas was born as a means to help others by documenting my quest for Excel Ninj-ocity. The full document will be released sometime in January, but here is a selection that I hope provides some value alone.

While having a working knowledge of the functions described below can help with a multitude of SEO tasks, the specific tasks that we'll be completing in the following include:

Isolating the root domains from a group of full URLs
Stripping the descriptive portion of a URL out of the full URL

-----SNIP-----

Lesson 2: More Functions - Text Manipulation

The functions on which we'll be focusing in this lesson are useful for dealing with text manipulation. As we'll see from the examples, there are quite a few scenarios wherein the SEO has to manipulate a text string. Some of the formulas we'll talk about are pretty simple to grasp individually, but can get a bit confusing when used together. We'll touch on:

LEN
SEARCH/FIND
LEFT, RIGHT, MID

LEN

Microsoft Excel Definition: Returns the number of characters in a text string.

Syntax: LEN(text)

Example of LEN function
I doubt this requires much explanation. LEN alone is fairly useless. Sorry LEN.

SEARCH/FIND

Microsoft Excel Definition:
SEARCH - Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).
FIND - Returns the starting position of one text string within another text string. FIND is case-sensitive.

Syntax: SEARCH(find_text,within_text,start_num) and FIND(find_text,within_text,start_num)

There are two differences between SEARCH and FIND. SEARCH is not case-sensitive, FIND is. SEARCH allows the use of wildcards, FIND does not. Under most circumstances, SEARCH is all you need, but it helps to know that FIND is always there if you've got to deal with pesky capital letters in URLs or something similar. Another reason to choose FIND is if you're dealing with URLs that contain parameters. Without properly escaping question marks, they will act as wild cards, which may cause some frustration.

In our example below, we've pulled out the character number at which the "/blog/" string begins. Much like LEN, this function is a bit silly on its own, but can be combined with some of our other functions to do some cool things.

This is good but its not very pretty, let's use IFERROR to get rid of those #VALUE!s

The IFERROR syntax: IFERROR(value,value_if_error)

So much better!

LEFT, RIGHT, MID

Microsoft Excel Definition:
LEFT: Returns the specific number of characters from the start of a text string.
RIGHT: Returns the specific number of characters from the end of a text string.
MID: Returns the characters from the middle of a text string, given a starting position and length.

Syntax:
LEFT(text,num_chars)
RIGHT(text,num_chars)
MID(text,start_num,num_chars)

Both LEFT and RIGHT return the characters from a given position in a text string starting from either side of a string. MID is great for extracting a portion of a text string. I've lumped the three together because they are often used in conjunction with each other (along with a few of the earlier functions). Let's dive into an example:

Bringing it all together - Example 1

Let's say we've been given a list of URLs, and we want to extract just the domain.

Using LEFT and SEARCH together

This formula will do the job. Let's break down this nested formula, and see how it pulls just the domain out of our URL. Starting from the middle we see SEARCH, which uses the syntax:

SEARCH(find_text,within_text,start_num)

In plain terms, this formula finds the first instance of "/" in the cell to the left, starting at the 8th character from the beginning, which is done to start passed the double slash in http://. As we see below, the result for the first row of data is 22.

The same formula with the inner function calculated

Now we are left with a simple LEFT formula. Remember, the syntax for LEFT is LEFT(text,num_chars).

In plain terms: Give us the first 22 characters starting from the beginning. The number of characters differs depending on URL, but adjusts accordingly when applied to the rest of the table. We now have a nice listing of just root domains.

root domains calculated with Excel functions
Our list of root domains. The formula reflects the change to a table format from the simple range used previously.

Example 2

Let’s use SEARCH (with wildcards) and MID together to extract a portion of a URL:

A list of raw URLs
Let's assume we want to pull the descriptive piece out of each of these URLs for reporting purposes

We’ll definitely be making use of MID, as the text we want is in the MIDdle of our string. We’ll need to determine how many characters make up the "-tXXX.html" bit at the end of each URL. Since the length of this portion of the URL varies, but the format doesn’t (that is, "-t" + "numbers" + ".html"), we can use wildcards to find this character count.

Again, the syntaxes for these 2 functions:
MID(text,start_num,num_chars)
SEARCH(find_text,within_text,start_num)

Let's break down the formula for the first URL in our list.

Cell A2: http://www.example.com/lamp-maintenance-t83.html

 =MID(A2,SEARCH("/",A2,8),SEARCH("-t*.html",A2)-SEARCH("/",A2,8)) =MID(A2,23, SEARCH("-t*.html",A2)-23)

We've calculated the first instance of a "/" after the 8th character. This gives us our start_num values. We're also using the * wildcard to help us get the character count of the right-most chunk of text.

 =MID(A2,23,SEARCH("-t*.html",A2)-23) =MID(A2,23,40-23)

We can easily calculate the number of characters for our MID once we know where our non-descriptive characters begin.

 =MID(A2,23,17) /lamp-maintenance

Hooray!

Example 2.5

Let's make a small adjustment to our original URL to demonstrate how we can use LEN in this formula.

Cell A2: http://www.example.com/t1521-lamp-maintenance.html

 =MID(A2,SEARCH("-",A2)+1,LEN(A4)-SEARCH("-",A2)-5) =MID(A2,29+1,50-29-5) lamp-maintenance

The additional +1 and -5 are necessary to make minor adjustments to the final outcome. Without them, our final result would have been "-lamp-maintenance.html".

-----SNIP-----

Thus concludes the sample lesson on manipulating text strings in Excel. I hope you've found it useful, and not too confusing!

If you have any questions, ask away in the comments and follow me (@MikeCP) and @Distilled on Twitter for more info on the full release of Excel for SEOs: Lessons for Aspiring Ninjas. There's much more where this came from, including bits on pivot tables, VLOOKUP, Index/Match, OFFSET, and more!

Do you like this post? Yes No

Story Time with President Obama

Your Daily Snapshot for
Monday, Dec. 20, 2010

Photo of the Day

President Barack Obama high-fives a girl named Malia after reading "'Twas the Night Before Christmas” to the second graders in the library of Long Branch Elementary School in Arlington, Va., Dec. 17, 2010. (Official White House Photo by Pete Souza)

marți, 21 decembrie 2010

White House Staff: It Gets Better

Seth's Blog : The first rule of doing work that matters

The first rule of doing work that matters

More Recent Articles

luni, 20 decembrie 2010

Mish's Global Economic Trend Analysis

Mish's Global Economic Trend Analysis

SEOmoz Daily SEO Blog

SEOmoz Daily SEO Blog

Lesson 2: More Functions - Text Manipulation

LEN

SEARCH/FIND

LEFT, RIGHT, MID

Bringing it all together - Example 1

Example 2

Example 2.5

Story Time with President Obama

Pagini

Persoane interesate

Arhivă blog

marți, 21 decembrie 2010

More Recent Articles

luni, 20 decembrie 2010

Lesson 2: More Functions - Text Manipulation

LEN

SEARCH/FIND

LEFT, RIGHT, MID

Bringing it all together - Example 1

Example 2

Example 2.5

Pagini

Persoane interesate

Arhivă blog

Subscribe to