SOPA

With #SOPA : Everything ███ █████ is█████ ████ fine ████ ███ ██████ love █████ █ your █ ████ government

QR Borg Cube

Assimilate this!

The Borg are here and they want you to spread their message to your collective.
Are you man enough to join the machines?
Enlist now and you too can have your own personal shield generator, and be able to heal and regenerate.

Never be alone again!

Long live the queen!

Foursquare troll

Have started using foursquare and within a month, someone is already ruining the fun for me.  Have managed to get four mayorships and, as part of normal use, have ousted what turned out to be a foursquare troll.  A certain Steef J, aka Steef Jacobson, aka Stephen Steef Jacobson has decided that only he is allowed to be mayor and, after spamming checkins at the venue from which I ousted him, started going after all other venues where I have ever checked in to remove me from mayorship and/or prevent me from becoming a mayor.  How do I know this?  I accepted his friend request and have noticed that he's even checking in at my shul and my son's day care and doing it several times per day and when the venues are closed.
Have now defriended and reported him for abuse to foursquare.  Hope they disable his account as he seems to be going after other people too.

Checking in at multiple locations at the same time and thanks to twitter can track his obnoxious behavior:
https://twitter.com/#!/_steef_

And here he is on foursquare:
https://foursquare.com/_steef_
A Jewish, religious, guy is a mayor at a church? Really?

And he's on facebook too:
https://www.facebook.com/steef.jacobson

Using foursquare? Make sure you don't friend this psycho, or same can happen to you.

UPDATE - 12/19
This guy seems to be doing this to other people to as he's checking in at 4 to 8 different location, within seconds of each checkin and doing this several times per day.  If Steef is harassing you too, email privacy@foursquare.com, give them his username, _steef_ and your username or id and let them know that he's spamming fake checkin in order to remove/prevent you from becoming a mayor.

Excel - Concatenate range

Not as pretty as a custom function, but gets the job done.
To concatenate all values in range A2:A100, place the following formula into B2 and drag/fill it down to B100.

=CONCATENATE(B1,",",A2)

If you want to concatenate all values in a range on the condition that there's a 1 in column B:

=IF(B2=1,CONCATENATE(C1,",",A2),C1)

To avoid the , or 0 at the beginning, in the first cell that should have a value, enter the value manually and copy the formula to the cell below it.

Mystery Manor - Cloakroom

Bow
 - Red dress on the right | On bench, below left bag | 3rd back left shelf
Butterfly
 - On red bag, bottom left | Back, top left shelf
Drapery Cord Tassel
 - Bottom of mirror | Right side of bench
Fan
 - Far left ceiling | Behind box back right
Feather Duster
 - Right side of bench | Right leg of mirror
Fire Alarm
 - Far left ceiling | Above shelves on the right
Gloves
 - Floor, center back | Floor, bottom left | Open drawer back left
Hair Brush
 - Middle of bench | Floor, bottom left
Hanger
 - On chandelier | 5th back right shelf | Back left commode
Iron
 - Floor, center back | Floor, back left | Top back shelf
Keys
 - Left side of mirror
Magazine
 - Floor, center back | Floor, bottom left
Man's Sock
 - Bottom right | Floor, bottom left
Mask
 - Grey jacket on the left | Red dress on the right
Measuring Tape
 - Right commode | Floor, back left
Necktie
 - Left commode | Top shelf, back right
Petunia Flower
 - Behind bench, on the left | Bottom of mirror | Under red dress
Phone
 - Bottom left | On bench, left
Scissors
 - Back, top left shelf | Bottom right
Sewing Machine
 - Back left | 3rd shelf, back right | Under bench
Shoe Horn
 - Second shelf, on the left | Back shelf, center
Sunglasses
 - In mirror | On bench, left | In front of bench
Tag
 - Red coat on the right | On red bag, bottom left | On clear bag on bench
Woman's Hat
 - Bottom shelf on left | Top of mirror | In front of bench
Yarn ball
 - On top of back left commode | Bottom left of mirror | Under stool

Mystery Manor - Bathroom

Angel - Top left.
Apple - Middle of mirror.
Ball - Inside alcove.
Bell - Bottom of cart.
Candlestick - Bottom left of bathtub.
Champagne - Above cart, on left.
Clock - On top of cart.
Detergent - Behind cart.
Fire Alarm - Ceiling above bathtub.
Duck - Left of mirror.
Gear - Inside alcove.
Glove - Bottom right.
Linen Basket - Behind cart.
Perfume - Wall left of bathtub.
Plunger - Ceiling above cart.
Scale - Bottom left.
Seahorse - Ceiling above bathtub.
Shell - Left corner of bathtub.
Ship - Bottom center.
Small Broom - Bottom left.
Vase - Front table.
Wine Glass - Bottom left of bathtub.
Woman's Shoe - Bottom left.
Wrench - Above bathtub.

Mystery Manor - African Room

African Diamond - Floor, right.
African Elephant - Top right wall.
African Mask - Right side of hut.
African Scorpion - Roof, bottom right.
Basket - Right of roof.
Bananas - Held by monkeys.
Butterfly - Right wall, center.
Crocodile Skull - In hut in fire.
Cup - On drum, front center.
Feather - On spear, right of hut.
Goggles - Right wall, bottom right.
Gun - In vase, left of hut.
Knife - Stuck in drum, floor, right.
Pineapple - In hut on table.
Pith Helmet - Floor, right.
Rhino - Left window.
Shaman Amulet - Right of roof.
Shaman Potion - On drum, front center.
Shell - Top of roof.