Maintenance Mechanic at Fender Musical Instruments (Corona, CA)

September 16th, 2011

TV moment, but you could do that if you had to. Just like MacGyver you can use practical scientific knowledge and … might have the perfect gig for you. And don’t worry, unlike MacGyver you won’t have to rely strictly on your trusty…

How to Save a Hosted File as a Google Apps Document

January 31st, 2010

With all this talk of the “cloud” why is it that to copy files in the cloud we still have to download files from the cloud and re-upload them to the cloud? Well, with Google Apps’ new “upload any file” feature you don’t have to. Here’s an example. Of course, one could argue that one of the benefits of the cloud is that you don’t need a copy and to that I’d say you’re probably right but people are information packrats.

SO here’s a real-world example: say you’re searching for the owner’s manual for your cordless telephone system and you want to keep a copy for future reference. In the past you would search for the file on the Web, save it your hard drive and then possibly re-upload it to some remote storage. In this new era of cloud computing, though, here are the steps I took:

1) Search for the file on the Web. I google’d “kx-tg4000b manual filetype:pdf” (I wanted a PDF file specifically) and got a handful of results (duh)

2) Copy the link URL. The second result was what I was looking for: a link to a PDF copy of the owner’s manual for my phone system. So I right-clicked on the link and chose “Copy Link Location” (Firefox) so that I had the URL for the file I wanted.

3) Upload to Google Docs. Now here’s where we save a step. In the past I would have downloaded the file to my local machine and then done what I needed to with it. This time, I went to Google Docs instead and clicked the “Upload” button at the top of the navigation bar on the left. I clicked the “Select files to upload” link and got the familiar Windows file dialog. I pasted in the URL I had copied in Step 2 and hit “Open”

After a brief pause Google had sucked over the file info (I thought it might just be downloading the file to my desktop and re-uploading in the background but I took a look at the network traffic and that doesn’t seem to be the case) and all I had to do was hit “Start Upload” (NOTE: checking the “Convert documents … to Google Docs format doesn’t seem to have any impact on PDF files).

And there you have it! Your very own “cloud-to-cloud” copy of the file.

As I like to say, there’s a fine line between being lazy and being efficient… and this definitely straddles that line.

How to Change the Number Format for an Axis in an Excel 2007 PivotChart

January 8th, 2010

I was banging my head against the wall trying to figure out how to change the number format (i.e date format or adding comma separators for large numbers, etc) for a Pivot Chart in Excel 2007 and the method is pretty un-intuitive so I thought I would share (if I can save even one person the headache I just went through it’ll be worth it).

1. Click on the chart you would like to change. This should open up the Pivot Table Field List automatically, but if not here are the steps:
1a. Under the PivotChart Tools dynamic menu choose “Analyze”
1b. Click on “Field List”
2. In the “Values” area of the Pivot Table field list click on the drop down arrow of the value you want to change the format of
3. Choose “Value Field Settings…”
4. Click the “Number Format” button

Now you should see the all-too-familiar number format dialog. Go ahead and set the format as you like. Hit OK and then OK on the previous dialog and presto!

User Experience Researcher at Zappos (Las Vegas, NV)

January 5th, 2010

passionate person that is you: You are Sherlock Holmes and MacGyver rolled into one, cool UX package. Nothing excites you more than sleuthing to find what issues our website users may be encountering or what enhancements would make them…

Lead iPhone Engineer at Citysearch (West Hollywood, CA)

November 18th, 2009

to make up for somewhat fewer resources. If you have Macgyver-like tendencies, well put them to good use!
? Game development experience
? OpenGL, CoreGraphics, and/or CoreAudio experience
? Strong grasp of algorithms and data structures
?…

How to Reboot a Linksys WRT54G Router Remotely

November 17th, 2009

From time to time my Linksys WRT54G wireless router loses external connectivity for no apparent reason and the solution is to simply hit the reset button on the back of the unit (or unplug it and plug it back in). However, today I was feeling lazier than usual and didn’t want to get off my duff and go downstairs to physically reboot the unit so I tried to do so through the admin console. I searched high and low in the admin UI and then on various forums and couldn’t figure out how to do a soft reset. Then, I started tinkering and found a little trick: if you save your current config and then upload that config the router will reboot. Here’s the play by play:

1. Go to the Config Management section of the Administration tab at http://<YOUR ROUTER IP>/bkconfig.htm (usually this is something like http://192.168.1.1/bkconfig.htm)

2. Click on the Backup button and save the corresponding config file

3. Click the Browse button to locate that file and then hit Restore

The page will spin indefinitely but if you wait a few minutes your router will actually come up (you can test this by hitting the config page URL again IN A DIFFERENT TAB/WINDOW).

What can I say, laziness is the mother of innovative problem solving… or something like that.

NOTE: I’m running firmware version v1.01.1 (old??) so your exact UI elements / URLs may vary

Mozart Meets MacGyver (ColdFusion developer) at Matrix Group International (Crystal City, VA)

September 30th, 2009

with the creativity of Mozart and the analytic skills of MacGyver to join our exceptional software team.

You will:

* be an outstanding Web back-end developer, working on multiple projects for a variety of clients; creating dynamic…

Mozart Meets MacGyver (ColdFusion developer) (Washington, Dc)

September 22nd, 2009

with the creativity of Mozart and the analytic skills of MacGyver to join our exceptional software team.

You will:

* be an outstanding Web back-end developer, working on multiple projects for a variety of clients; creating dynamic…

Web Development Intern at Pittsburgh Technology Council (Pittsburgh, PA)

September 16th, 2009

development, interactive design and social media. A true e-MacGyver of sorts.

We??re looking for an energetic, super-creative student to develop web pages, small web sites, e-newsletters, widgets and more.

We??re also looking for someone …

Technical Arts Director at Community Christian Church (Naperville, IL)

September 14th, 2009

and potential for permanent full-time. Were looking for a MacGyver-type to oversee and consult with campuses on technical arts, including media, sound, and lighting. . If you live and breathe things like cables, adapters, amps, and …