Friday, June 12, 2009

For fun...

I found this bathing suit while looking for a new two-piece one myself:
http://www.swimoutlet.com/product_p/11748.htm

While marveling at this suit, and the whopping $0.05 savings(!), I thought it would be funny to call up the live chat and treat it like a phone sex line (or how I imagine a phone sex line conversation would go).

I also, and I'm being serious when I say this, created a free "postlet" account. If you've looked on craigslist for either real estate or a new apartment for rent you may come across these pretty nice ad templates created by postlet. I was going to put up a big box (like refrigerator-sized) in the real estate section... on the corner of Somewhere and OverThere, provided there's no sudden gust of wind.

That's all I have at the moment.

Monday, June 1, 2009

Deleting Rows in Excel

Cambridge

Local area resident woman, Elena "Lany" Mamlok, has decreased her effort by nearly 50% in manipulating a file.

"So I get this data dump of a report once a month and it's not formatted for anything useful. It costs me at least a day to reformat into something pretty... well, pretty as far as Excel can be attractive," Mamlok whined.

This particular step is where Mamlok deletes over 100 non-consecutive rows. "There's practically no data integrity left by the time I'm done deleting all this crap. I mean, the amount of human error in this process is huge."

Mamlok went on to state that this report does eventually make its way to Senior Vice Presidents in her company.

When asked if she could further explain how she cut her manipulation efforts down dramatically, Mamlok said, "Well, I used to highlight the row and then right click and select delete. Now I just right click, which selects the whole row and gives me the delete option at the same time. So I just saved half."

Half, indeed.