Thursday, December 31, 2009

We're having a hard-thinking Hogmanay!


Posted via email from michaelpaul's posterous

Tuesday, December 29, 2009

Holiday Drinking Guide - Episode 40

Hooray for Episode 40! And beer! And alkyhall. Through our extensive research, we're going to show you how you can ring in the new year with some new GF drinks you may never have heard of... so get ready to have some fun! In this episode, we review: Redbridge Beer, Woodchuck Draft Cider, Blue Ice Vodka, Frangelico (hazelnut liqueur), and a little Parrot Bay (coconut rum). In addition to the products we tried out on this episode, here are some other gluten free alcohol options: Beers: Bard's, Green, New Grist Vodka: Tito's (corn based), Krome (corn based), U4rik (grape based), Ciroc (grape based), Teton Glacier (potato based) Tequila: Don Julio, Patron, Jose Cuervo
Formats available: MPEG-4 Video (.m4v)

Monday, December 28, 2009

Pancake Showdown: Pamela's vs Gluten Free Mama

In this Pancake Showdown, we pit our undefeated champion, Pamela's Pancake Mix, against a new contender, Gluten Free Mama's. Whose cuisine will reign supreme? The battle is on!
Formats available: MPEG-4 Video (.m4v)

Jake Bakes Marshmallows - Episode 38

We never thought of taking marshmallows beyond their sugary base, but the Jake Bakes company believes this industry has a bright future. We reviewed 5 of their custom marshmallows and, while some of them didn't impress, others were right on. Find out which ones deserve to be in your cupboard in this episode of GFree TV!
Formats available: MPEG-4 Video (.m4v)

Saturday, December 26, 2009

His and hers Sick Station (DIY)


Posted via email from michaelpaul's posterous

Conte's Stuffed Shells - Episode 37

We liked Conte's raviolis when we last reviewed them, but have you ever wondered if those stuffed shells you've seen are worth a try? Well, they are! But they're not without their misgivings: the cheese never sticks to the shells, causing a one-after-the-other eating experience. On the bright side, you get to decide which to eat first: the ricotta cheese or the shell. Add your favorite pasta sauce to complete the meal.
Formats available: MPEG-4 Video (.m4v)

Friday, December 25, 2009

Zing Bars - Episode 36

Zing! Pow! Holy Cow! These Zing Bars are pretty cool. A bit pricey, but they pack a lot of healthy stuff into a tasty snack bar. We review 5 different flavor combinations: Blueberry, Cranberry Orange, Oatmeal Chocolate Chip, Chocolate Peanut Butter, and Peanut Butter Chocolate Chip.
Formats available: MPEG-4 Video (.m4v)

Found a companion who's as tired as I am.


Posted via email from michaelpaul's posterous

Sunday, December 20, 2009

Mikuni Sushi - Episode 35

Mikuni Sushi just unleashed its new gluten-free menu, so we had to visit and try things out. While they made a nice first attempt, we found that we've had better luck making other rolls of their gluten-free with slight modifications. For the sushi aficionado, this would be a bland experience. To gluten-free people who have been dying for sushi, consider this place your resource if you're ever in the Sacramento area.
Formats available: MPEG-4 Video (.m4v)

GFTV E34 - Norlander's Mesquite Sauce

Formats available: MPEG-4 Video (.m4v)

Saturday, December 19, 2009

Natasha's Health Nut Cookies

gfreetv, gluten free, gluten-free, celiac, review, food,
Formats available: MPEG-4 Video (.m4v)

Kettle Cuisine 3 Bean Chili

Beans, beans, the magical fruit... the more you eat, the more you toot! The more you toot, the better you feel... Let's have beans for every meal! OK, OK, maybe not every meal, but this company makes a 3 bean chili that's at least good enough to have on more than occasion!
Formats available: MPEG-4 Video (.m4v)

Wednesday, December 16, 2009

Pacific Catch (San Francisco, CA) - Episode 31

After swimming the seas of Golden Gate Park for the day, we sniffed out the bait and got hooked on the line of the Pacific Catch restaurant in San Francisco, CA. On the corner of 9th Avenue and Lincon Way, they served up some shrimp ceviche, a sake sake roll, and two Chalkboard Specials: one with shrimp served California Grill Style, and one with salmon served Baja BBQ Style. Will they reel us in, or will they let these two fish get away?!
Formats available: MPEG-4 Video (.m4v)

Monday, December 14, 2009

Enjoy Life Cereals - Episode 30

3 different cereals reviewed from Enjoy Life: cranapple crunch, very berry crunch, and cinnamon crunch.
Formats available: MPEG-4 Video (.m4v)

Friday, December 11, 2009

Ginger Elizabeth Chocolates - Episode 29

If you're anywhere near Sacramento, CA, you'll want to check out Ginger Elizabeth Chocolates. We treated ourselves to a small cup of hot sipping chocolate before headed home to review six different kinds of their gourmet chocolate confections. You MUST watch this, and you MUST have some! They're that good. And no, they didn't pay us to say that, and yes, we bought the chocolate we reviewed. Looking forward to our next visit.
Formats available: MPEG-4 Video (.m4v)

Thursday, December 10, 2009

Automating Excel copy and paste jobs across multiple sheets

When I first started this project, I found myself with this Excel workbook that had a few sheets in it, each sheet containing an extract layout for data of a given record type. For example, if the record type was "Person" the extract layout might look like this:



Those things in capital letters are called fields, or headers. In my example above, there are 3 fields/headers. In reality, I currently have a record type that has 118 fields. The problem, as you'll soon see, is that these headers are shown in a top-to-bottom format, instead of left-to-right. My job is to get these guys showing in a left-to-right format. (That's easy; there's a Paste Transpose feature in Excel that does this for me--but it doesn't delete all the other crap in the spreadsheet that I don't need.)

I work with a program called PDI (Pervasive Data Integrator) that doesn't much care for the way these fields are presented in my handy dandy Excel spreadsheet. Instead, it prefers to have those headers across the top of the very first row, like this:


Over time, this small Excel spreadsheet grew from having 3 sheets (record layouts) in the workbook to 13 at the time of this writing.

My goal was to automate the process of moving those fields from a top-to-bottom format to a left-to-right format while simultaneously deleting all the extra junk that appeared to the right of each field in the spreadsheet, like the length of the field, the field's data type, which database table it came from, etc.

So basically my goal was to turn this:


...into this:


See all that extra junk I need to get rid of? At first, I recorded a macro in Excel, but I found that this was simply not acceptable for a number of reasons. The main reason is that it wasn't dynamic. It always selected a certain number of fields, and did whatever it was supposed to do. So, if I had only 10 fields I wanted to do my wizardry on and I used my original code, it would have selected 150 fields (from A2:A151 in Excel terms) and when I then imported those fields into my PDI map, PDI would recognize all 150 fields instead of just the 10. Making matters worse, PDI doesn't let me simply delete all of those extra fields at once (it's buggy like that) so I can only do groups at a time.

Basically, it's a waste of time.

So, I then took that code and decided to make it generic and adaptable. But then there was another problem. "Great, I can get it to automate the process on one sheet, but what about the other 12?" Imagine if there were a hundred sheets. Scale it to a thousand. You get the idea. Time-consuming to do, unless you automate that process.

How did I do it? I did it by using a loop within a loop. The first loop is a For Loop. It says, "For sheet 1 through the very last sheet, do this stuff."

The second loop is a Do While Loop. This loop says "while the currently selected cell is not empty, do this stuff." All it does is examine the cell it's on to see if it's blank or not. If it's not blank, it moves down to the next cell and evaluates it in turn. It does this until it encounters a blank cell, indicating that there is no more data I need to worry about. The key here is that it keeps track of the cell number that it's on.

So, I now have a variable keeping track of my starting and ending cells (myRange1 and myRange2, respectively). That means I can store those guys into a final variable called finalRange, which will be used to tell Excel which range of cells to select.

Cool, huh?

The code below will look like crap on this blog since it's in such a narrow column, but copy and paste it into your Excel workbook's VBA window and it'll work.

Here's the code:

Sub PrepForPDI()
' PrepForPDI Macro
' Keyboard Shortcut: Ctrl+m

'Set up the variables we'll be using
Dim myCounter, endCounter, mySheetCount, i As Integer
Dim myRange1, myRange2, finalRange

'Step 1. Starting at the first sheet, do the following. Repeat for each one until the very last sheet.
For i = 1 To Sheets.Count
Sheets(i).Select 'Select sheet i (starting with 1 since i = 1 above)
myRange2 = "A2" 'This is our starting range
myCounter = 2 'Counter that keeps track of currently selected cell

'While the selected cell is not blank, increase my counter and update my ending range
Do While Range(myRange2).Text <> ""
myCounter = myCounter + 1
myRange2 = "A" & myCounter 'The result of this variable would be A1, A2, A3, depending on where my counter is at
Loop 'go back up to the Do While statement and repeat until a blank cell is encountered

'Once a blank cell is found as we go down our column, jump out of the loop and execute the following:
myRange1 = "A2" 'The start of our selection range in the Excel spreadsheet
endCounter = myCounter - 1 'Subtract 1 from the counter since the counter was last on a blank cell
myRange2 = "A" & endCounter 'The end of our selection range in the Excel spreadsheet
finalRange = myRange1 & ":" & myRange2 'This would look like A2:A114 for example

'Now that we have our final range, select it, copy it, paste (transpose) it, delete the
'rows below row 1 since we only care about preserving this new row 1, and select cell A1
'so that we're always looking at the very first field on any given sheet.
Selection.Copy 'Copy it. :-)
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:=False, Transpose:=True
Application.CutCopyMode = False
Selection.Delete Shift:=xlUp
Next i 'Now i = 2, so when the For statement loops back to Step 1, it will select Sheet number i, or Sheet number 2.
'Select the very first sheet to bring us back to home base.
End Sub

Tuesday, December 1, 2009

Farmer's Kitchen Cafe - Episode 27

While passing through Davis, we stopped at Farmer's Kitchen Cafe for some lunch. We were blown away by this unassuming eatery, and found another hole in the wall that's worth the money. What did we order? Watch and find out!
Formats available: MPEG-4 Video (.m4v)

Monday, November 30, 2009

Erewhon Cereals

We woke up with a hunger. So, what better way to start the morning off than reviewing three different cereals from Erewhon? On the menu: Corn Flakes, Cocoa Crispy Brown Rice, and Strawberry Crisp.
Formats available: MPEG-4 Video (.m4v)

Friday, November 27, 2009

Inside the Orpheum theater on the set of Wicked


Posted via email from michaelpaul's posterous

Crave Bakery: Chocolate Cake - Episode 25

We reviewed their apple and apricot tarts in Episode 21. Now we've got our hands on one of their chocolate cakes... although a little dry after sitting in our freezer/fridge for two weeks, none of the chocolate flavor got lost--that's for sure! We recommend dropping what you're doing and eating this cake the moment you buy it, because if it's this good after 2 weeks, it must be a smash hit when it's freshly baked.
Formats available: MPEG-4 Video (.m4v)

Thursday, November 26, 2009

Beautiful sunset with a tree... Or is it?

Okay, okay, the sunset was a picture I found on the Internet (c) Michael Wang 2005, but I did make the tree myself. It consists of one 3-foot CAT-5 Ethernet cable that I cut into small ~5" pieces before slicing open the tops, exposing the twisted pairs of copper wire, which I then craftily fashioned into the life-like tree you see before you.

Hope you enjoyed the art. Re-tweet if you liked it.


Posted via email from michaelpaul's posterous

Monday, November 23, 2009

Three Senses Gourmet: Chocolate & Caramel Souffles - Episode 24

If you're looking for a special chocolate treat you can enjoy once in a while that will take you to a whole new level of chocolatey goodness, you had better try these souffles from Three Senses Gourmet. We're serious.
Formats available: MPEG-4 Video (.m4v)

Thursday, November 19, 2009

More fall colors on display at work

This one is actually at my office building. Again, taken with iPhone (1st gen FTW), processed with AutoStitch.


Posted via email from michaelpaul's posterous

Beautiful fall colors on display

Panoramic photo of some trees by my office building. Taken with iPhone and processed with AutoStitch.


Posted via email from michaelpaul's posterous

Wednesday, November 18, 2009

Conte's Raviolis - Episode 23

Finally: some gluten-free raviolis! We sample three different varities: spinach & cheese; potato, onion & cheese; and ricotta cheese. It's not easy being cheesy. ;-)
Formats available: MPEG-4 Video (.m4v)

Monday, November 16, 2009

Coconut Bliss Ice Cream Party

Debbie won a contest for an ice cream party from Coconut Bliss, so we decided to use the interwebs and invite some family to the party live! 5 different ice creams reviewed--and they're all freakin' amazing. Join the party and see which was our favorite, won't you?
Formats available: MPEG-4 Video (.m4v)

Tuesday, November 10, 2009

Crave Bakery - Episode 21

Owned and operated by Cameo Edwards, Crave Bakery offers gourmet gluten-free desserts. Today we tasted an apple and an apricot tart... But will they leave us craving more? Find out!
Formats available: MPEG-4 Video (.m4v)

Sunday, November 8, 2009

TweetDeck not working behind your corporate firewall? Try this.

Sometimes you've got a pesky firewall (AKA "proxy server") in your way that prevents you from accessing certain websites. TweetDeck, a popular twitter client running on the Adobe Air platform, seems to have some issues connecting to twitter behind my corporate firewall. I came to find out recently that it is not TweetDeck that is to blame, so much as it is Adobe.

Anyway, here's the fix. Once TweetDeck launches, click on the question mark button at the top right (the tooltip will say "Launch TweetDeck Support"). What should happen is a little window pops up asking you for your proxy server username and password, and then the TweetDeck support website will open. Once this happens, simply click the Refresh button in TweetDeck and your tweets should appear.

Did this work for you, too? Post a comment and let the world know.

Posted via email from michaelpaul's posterous

Friday, November 6, 2009

Another beautiful sunset at the apartment

The bright white in the pic is actually a deep orange that's much better appreciated in person.


Posted via email from michaelpaul's posterous

Monday, November 2, 2009

iPhone App: Is That Gluten Free? - Episode 20

Our first iPhone app review is here: we've found one of the most popular gluten-free apps for the iPhone and put it through its paces, leaving no stone unturned. What we found is that while the app is generally great for determining whether or not something is gluten free, too much time has elapsed between the verification date and the current date, leaving the possibility that the recipe/formula has been altered--which still requires a phone call to the manufacturer to clear up any questions.
Formats available: MPEG-4 Video (.m4v)

Thursday, October 29, 2009

The old "cracked LCD" prank

The setup: friend steps out and leaves computer unlocked (bad security). You step in and display an image of a cracked LCD full screen, then turn off the keyboard and mouse. Trackpad, too.

Sorry, but opportunity... she was a knocking. :-)

Posted via email from michaelpaul's posterous

Wednesday, October 28, 2009

Thursday, October 22, 2009

Halloween Candy Special - Episode 19

It's our Halloween Sweets Spooktacular, and we've got a special time-sensitive contest! We sink our teeth into some tasty treats that you, too, can enjoy! Surf Sweets, Licorice International, Brighton's Candy and Sweets Company, and Pure Fun are on the menu today--but how did they fare with the critics? Find out!
Formats available: MPEG-4 Video (.m4v)

Monday, October 19, 2009

Nana's Cookie Company - Episode 18

We take a bite out of crime and investigate Nana's Cookie Company. Results were inconclusive, but for people whose diets are restricted to the degree that borders on insanity, these are worth a try. For the record, these cookies have: No Dairy, No Refined Sugars, No Eggs, No Cholesterol, No Trans Fats, No Hydrogenated Oils, No Preservatives, and No GMOs. Nana's Cookies are also vegan and kosher.

Saturday, October 17, 2009

What should I carve into this pumpkin? Photorealistic. Lots of canvas to work with.

Years past, I've carved some pretty bad-ass shit into pumpkins, from Betty Boop to my own shiny happy mug (and the mug of my wife, too). More pics at


Posted via email from michaelpaul's posterous

Protect your electronics, invest in an InvisibleShield

InvisibleShield is a product from Zagg that I find most interesting: it's a case without being a case. It's made of the same material that's used to protect helicopter rotor blades from being damaged, and is virtually scratch proof. What's more, it's custom cut to your specific electronic device. So far, I've put an InvisibleShield on my iPhone, iMac, and a digital camera. You can't even tell it's there, but for the fact that your grip on the device improves about a hundred times. (I stuck my iPhone to my sliding glass door and it hung there for about 10 seconds before it fell off.)

The only downer about this product is the application process: you've got to get it just right, otherwise it won't stay adhered. Moreover, it takes a long time for the product to completely dry off once applied--so you must, must must exercise patience once it's applied! I applied it in the evening and just let it sit overnight. So, don't apply it during the day or you'll be sorry.

This is not an ad, although I wish I were getting paid for writing this. I just really like the product.

You can get deals by following twitter accounts @zaggdaily and @zaggman.

Thursday, October 15, 2009

Jungle Grub - Episode 17

Get your grub on as we take you the Jungle and back! Jungle Grub bars are great for kids, as they meet recent SB-19 Nutritional Guidelines that limit sugar, fats and calories found in foods consumed by kids. (Good for adults, too.)
Formats available: MPEG-4 Video (.m4v)

Monday, October 12, 2009

Puppy dog eyes. I haz dem.


Posted via email from michaelpaul's posterous

Dippy Chick - Episode 16

The mixes from Dippy Chick were a mixed bag: the ranch was a little strong--though that could have been our fault--but the Crabby ol' Beach Seafood Dip Mix was fantastic. Too bad we didn't have any shrimp on hand.
Formats available: MPEG-4 Video (.m4v)

Thursday, October 8, 2009

Glutino Dream Cookies - Episode 15, Part II

O-R-E-Oh, wait, these aren't Oreo cookies, but they come pretty darn close! We give you the straight scoop on these fabulous cookies. Thanks to Glutino.
Formats available: MPEG-4 Video (.m4v)

Wednesday, October 7, 2009

Glutino Crackers & Pretzels - Episode 15, Part I

Part 1 of a 2-part series on Glutino Foods. Four varieties of crackers are reviewed, as well as three different types of pretzels. Are they as good or better than their glutinous counterparts? Find out in this episode of GFree TV
Formats available: MPEG-4 Video (.m4v)

Tuesday, October 6, 2009

Gluten Free Cafe Assorted Sesame Bars - Episode 14

From chocolate to lemon to a touch of cinnamon, these sesame bars from Gluten Free Cafe really satisfy. The Chocolate has hints of espresso, while the lemon hits you with the zing of lemon zest, and the cinnamon takes us back to weekend breakfasts of french toast with the family. Definitely worth stocking up on these!
Formats available: MPEG-4 Video (.m4v)

Wednesday, September 30, 2009

Jules Gluten Free Graham Cracker Gingersnap Mix - Episode 13

Will the Jules Gluten Free Graham Cracker Gingersnap Mix put an end to our quest for the perfect graham cracker mix, or will we still be on the hunt? It seems that it's still open season.
Formats available: MPEG-4 Video (.m4v)