Posts

Excel Spreadsheet Formulas for the Week

I'm in charge of the direct mailing at my office. Our leads come in via Excel sheets, which get fed through RoboAgent, and out pops an auto quote. We recently had Database101 run our previous leads through their database to see if we could collect any phone numbers and/or emails. We have 8 separate leads files, and 1 big amended file (with all the leads in no particular order). In order to get the quotes updated, I have to use the ReQuote feature, but wanted to update the individual leads files with phone/email. I opened the leads file, and copy/pasted the Amended file as Spreadsheet 2. So the Phone and Email columns were empty in Spreadsheet 1. Be sure that your columns are aligned! (ie if Phone column in Spreadsheet 1 is column C, then it better be C on Spreadsheet 2).  I used the following 2 links for the formula, just adjusting the columns to match and transplant: =IF(ISNUMBER(MATCH($C7, Sheet2!$C:$C, 0)), INDEX(Sheet2!H:H, MATCH($C:$C, Sheet2!$C:$C, 0)), "") ...

Really? One of these guys could be President?

On one hand we have Newt Gringrich. He's had 2 (known) affairs, which broke apart 2 marriages. He and one of his wives owed between $250K-$500K at Tiffany's. He was also formally disciplined for ethics violations by the House of Representatives. His (in)famous quotes are: "I'm not a natural leader. I'm too intellectual; I'm too abstract; I think too much." This man could be Commander-in-Chief: “If combat means living in a ditch, females have biological problems staying in a ditch for thirty days because they get infections and they don’t have upper body strength. I mean, some do, but they’re relatively rare. On the other hand, men are basically little piglets, you drop them in the ditch, they roll around in it, doesn’t matter, you know. These things are very real. On the other hand, if combat means being on an Aegis-class cruiser managing the computer controls for twelve ships and their rockets, a female may be again dramatically better than a male w...

My Authentic Decals Fall Apart and Disintegrate! (UPDATE)

Image
I bought a set of 1/72 decals for a Messerschmitt Bf-109F-2 on ebay. When I went to apply them to my project, they disintegrated on contact with water! Fell apart completely! So I had the ebay seller send me a new set, thinking I got a bad batch. Nope. Same issue. The email address on their website is wrong too. contact@olimpmodelsgroup.com does not work, but the packaging has contacts@olimpmodelsgroup.com listed, so I'm emailing them to make things right instead of the seller. If they don't though, I'm gonna have to get a refund from the seller for carrying a crappy product. No Disintegration! Kinda appropriate given my project: EDIT: I emailed photos of the decals, and after a few weeks Authentic Decals has sent me a refund of $10 for the decals that fell apart. It doesn't mean that I'll buy any more Authentic Decals, but at least they're a good company. I still have to track down decals for my Messerschmitt project though....

Custom R3-D3 Star Wars 4GB USB Sony MicroVault ClickFlash Drive

Image
This astromech has TONS of memory! Custom R3-D3 Disney Star Tours Exclusive Astromech, assigned to the Starspeeder 3000 USB Flash Drive Made with a 4GB Sony Microvault Click Flash Drive--Preloaded with Data Compression Software Clear dome glows blue when in use!

Shark Navigator Swivel LEAD WARNING

Image
I was at Costco this weekend and was looking over the box for the Shark Navigator Swivel UV410. On the bottom of the box is the following warning: It reads: WARNING: This product contains chemicals, including lead, known to the State of California to cause cancer, and birth defects and other reproductive harm. Wash hands after handling. Scary AND inconvenient

Photos of 27 Boulder Crescent 80903

Image
As promised, photos of the property concerns at 27 Boulder Crescent St, which existed when we moved in. The previous tenant lived at the address for 6 years.

To Our Landlord: Ana Zook

Aug 3, 2011 TO: Ana Zook RE: 27 Boulder Crescent St Colorado Springs CO 80903 I have checked all of the sprinklers and increased the watering time for the front portion in front of the house as well as the back yard. However, Zone 6 does not seem to be doing anything at all, despite running for 20 minutes. Where is Zone 6 in the yard? It is obvious you take pride in the exterior of the homes you rent. Therefore, I thought I’d bring some external property concerns and liabilities to your attention. I have enclosed photos of the concerns which have existed since we took possession of the property. Photo A The back screen door is clearly beginning to rot on the bottom. This damage can be seen from the front and back of the door. Not pictured is the fact that the screen is held on the inside by duct tape Photo B There is a shingle on the rear of the house that is coming up Photo C There is grass growing out of the gutter in the rear of the house. I suspect that the entire gut...