How to search for ~ in Excel

Yahoo Answers really came through for me here.  Just enter tilde twice: ~~

Very interesting article on autism and different measures of intelligence

In wired magazine here.

interesting article on 3d chip lens

here

Amazing article on HDTV calibration

here.

Also Popular Mechanics article on basic HDTV fixes.

50 of the best cookbooks of all time

From the NY Times.

20 life lessons a guy wish he knew at the beginning...

here

Parents and modern furniture...

You know who wins...

NASA picture of the day

Here

NY Times evolutionary article for reference

Fish in multiple ponds

Grow more willpower

NYTimes article, drink lemonade

NY Times, runner high is real.

Runner's high is real.

Great HTML table sorter JS

Frequence Decoder

Note, to change the default order of initial column sorting just add "r" after the column number in the table class.

Why I haven't gotten Lasik...

I already have dry eyes and now I'm definitely never getting it.

20 web developer sites

Seemed like a pretty good list.

How not to interview someone

Facebook founder interview

Latest info on the age of the universe

From the NY Times here.

Evaluating NY teachers by test scores

NY Times article

Interesting perspective on Facebook, short personal view from someone

Here

Let's hope we're not in a double bubble...

From the NY Times opinion page

Now I have to worry about flat lesions...

oy.  Definitely applies since this was found in Japan in the 80's.

Cool interactive Slate delegate counter

For upcoming contests...

Fix for Flex printing

Turns out to be a problem with the background getting shown for a few pixels.  Fix is here.

Configuring Vista for IIS, MySQL, CF, Flex 3 from scratch

Ok, forget Vista for MySQL.  Starting over from XP....

IIS

• Went to Programs control panel and added IIS from the Programs control panel
• Right clicked Computer, chose Manage
• Right clicked on Default Web Site under IIS
• Added index.html to the top of the document list on the Documents tab

MySQL
Turns out MySQL doesn't just work.
http://port25.technet.com/videos/research/MySQL_Windows.pdf

• The MySQL installation requires that User Account Control (UAC) is disabled. If you do not do this, the installation will fail when the system tries to start the service, even if the user allows the change.
• Went to User Accounts control panel and turned off UAC. Had to restart.
  

Climate experts weigh in on cold winter

Here in the NYTimes

Where to get my annual credit report for free

Here

100 Day Autism kit for those who just got a diagnosis

Here at Autism Speaks.

Potential bargain hunting sites...

DealCatcher and SearchAllDeals.com

How to build your own external HD

From a Macworld article

Key question for customer satisfaction

Would you recommend this product to a friend or family member?

Here

Alternate screen capture software

It's called iShowyou. It's really great. You can get it here: http://www.shinywhitebox.com/home/home.html

Also Mousepose is a great mouse companion. http://versiontracker.com/dyn/moreinfo/macosx/25586

Airzooka big brother

The Megazooka...oh yeah baby...

Now we have to watch how much blue light we're exposed too...

Blue light exposure linked to increase cancer risk, but only some forms of cancer.

Good place for stock music

stockmusic.net

Free wake up calls!

From wakerupper.com

Adobe's passport vendor/speeder upper

Peninsula Visa

Learn a language online and for free

LiveMocha
From this NY Times article.

Two NYT articles on autism I don't want to lose

"Her Autistic Brothers"

"For Siblings of the Autistic, a Burdened Youth"

My photos made the local paper

Page 6 in the Mountain View Voice this week.

Also on page 6 back in May of 2007.

Why I love McCain!

NY Times extended video clip of McCain Q&A on Iraq. The true context around the "100 year" commitment remark.

Emergency GPS device

Here for $150. Called the Spot by Globalstar.

Axion axn-9701 resolution

Is only 480 x 234...bummer...

Best places/times to buy electronics

Doesn't appear to be online yet, but in Feb. 2008 article entitled:
The Best Places (and Times) to Buy
some interesting pointers on LCD TVs,etc.

How Stuff Works article on how to gather drinkable water

here

Great article showing how LEDs work

Here on How Stuff Works. Great diagrams and descriptions...although it wasn't quite clear what they meant by "holes."

Two articles on cough/cold remedy new guidance

One on a NY Times blog

News Analysis on FDA updated recommendation

NyTimes article on maintaining balance and exercises to do so

Here

NyTimes article on best BPM songs for exercise...

Like I ever exercise...but if I did, some recommendations on what types of music to listen to.

Reduced thimerosal exposure in CA did not lessen Autism trend

From Associated Press.

Examples of people's photos getting misappropriated by large corporations

Here

Creating a softbox on the cheap

From Macworld article.

10 tips on buying an HDTV

PC World again.

Managing bad PR on the web

Again PC World article.

Suggestions if I ever want to add in Adsense

From pc world article.

Best graphics card ~$100 on Tom's Hardware

Link to the article here.

Hands burning after dicing up a jalapeno pepper...

Hopefully this advice will work...

Good discussion of various model release forms

Here

Best Steve Martin clip on saving money from Saturday Night Live

Skit was called Don't Buy Stuff You Cannot Afford:
http://www.hulu.com/watch/1389

Flex deployment issue resolved

Did a clean install of only CF8 and figure out what I needed to do on my deployment machine vs. what I had on my development machine:

1) changed the service.html configuration file to list my deployment server as the actual data source
2) added my cfc components to the exported Flex folder (Flex isn't smart enough to realize it needs to do this itself).
3) renamed the parent folder to keep the hierarchy the same (in terms of where the CFC folder was in relation to the Flex file)

Could it really fix BF2142 with widescreen support?

Giving this a try right now...fingers crossed...

Uber links on how to tie a tie

Mahalo daily video episode on tie tying
Mahalo links

Good online place for cheap unlocked phones

http://www.blogger.com/img/gl.link.gif

The place for cell phone info

Phone Scoop

Found the IP address to my Comcast router...

192.168.100.1

Good to know..

Another automated CRUD generator for Flex/CF

Looks like it generates XML too (which I don't want), but in case I ever get sick of the visualizer that comes with FlexBuilder, Illudium PU-36 looks like an option.

Probably better basic remoteobject actionscript example code from Adobe documentation

Found here.

ActionScript equivalent of mx:remoteobject

import mx.rpc.remoting.RemoteObject;
import mx.rpc.events.ResultEvent;
import mx.rpc.events.FaultEvent;
import mx.rpc.events.InvokeEvent;
import mx.messaging.Channel;
import mx.messaging.channels.AMFChannel;
import mx.messaging.ChannelSet;
import flash.events.Event;

import mx.controls.Alert;


public function onCreationComplete () : void
{
   //create the remote objects first    
   createRemoteObjects();
   
   //set the AMF Channel on the remote objects    
   setUpAmfChannel();
}

public function createRemoteObjects () : void
{
   ro = new RemoteObject();
   ro.destination = "ColdFusion";
   ro.source = "path.to.cfc";
   
   ro.addEventListener("fault",ro_fault_handler);
      
      //You probably want and need a result handler...
      ro.methodName.addEventListener("result",methodName_result_handler);
      //You may need this if you need to do something when a method is called
      ro.methodName.addEventListener("invoke",methodName_invoke_handler);
      //You may need this if you need to catch and handle errors differently
      ro.methodName.addEventListener("fault",methodName_fault_handler);
      //This is just sugar, you really dont need it unless you want it.
      ro.methodName.showBusyCursor = true;      
}


/* You can call the following method anytime to set the amf channel for a remote object on the fly */
public function setUpAmfChannel () : void
{
   var amfChannel:Channel = new AMFChannel("my-cfamf","http://server/flex2gateway/");
   amfChannelSet = new ChannelSet();
   amfChannelSet.addChannel(amfChannel);
   
   //repeat the following line for all remoteObjects
   this.ro.channelSet = amfChannelSet;
}

public function ro_fault_handler ( event:FaultEvent ) : void
{
   Alert.show( event.fault.faultString, 'Error');
}

public function call_methodName () : void
{
   //use this to call the method
   ro.methodName(/*pass arguments here*/);
}

public function methodName_invoke_handler ( event:InvokeEvent ) : void
{
   //this will fire when the method is invoked
}

public function methodName_fault_handler ( event:FaultEvent ) : void
{
   //this will fire when the method throws an error 
}

public function methodName_result_handler ( event:ResultEvent ) : void
{
   //this will fire when a result comes back from the method 
}

Getting started with FlexLib 2.1

This link helped me figure out how the heck to setup the FlexLib 2.1 library. Kinda flailed before reading this...yes I'm a newb.

Got stuck on Session and Global variables in a flex app

I need to keep these around for a CF8 Exchange set of operations.

Had to go all the way to this India post to find the full path for accessing variables declared in the Application scope. Not sure why Mike Chambers in his post didn't put the full path.

Oh my GOSH, getting CFEclipse installed was a total pain!

Wow, it should NOT have been this hard. Writing this down so I don't have to figure this all out again later...

- Eclipse seemed to work fine with THIS version of the Java 2 Standard Edition (J2SE) Java Runtime Environment (JRE) 1.5.0 update 11 found here.
Eclipse versions of Java supported

- Then I installed the Eclipse for RCP/Plug-in developers

- But the FINAL trick was that you can't just double click on any CFM/CFC file. Arg! You have to create a project first with the files in the right part of the hierarchy. Aaaaaah! I think I even had this working before, but uninstalled because of the blank window issue.
See post here.

This one showed me why adding CFEclipse to the Flex Builder 2 install didn't work.

Now I find that Eclipse 3.3 isn't compatible with FlexBuilder 2.0.1. Ack! Looks like Flex Beta 3 might fix it...

Decent post on DOA's, Gateways and beans

Found here.

Oh MY gosh, this killed me for two days...

Couldn't figure out why all the examples were breaking...until I remembered to do a Google on the error message I was receiving:
"VerifyError: Error #1053: Illegal override of subtopic in mx.messaging.Consumer"

The answer is to:
If you look in the properties for a Flex project under FB2 w/a CF8 server, you'll see that there's an entry pointing to {cf_install_path}/wwwroot/WEB-INF/flex/libs/fds.swc. This library conflicts with the Flex2 framework SWCs that come with FlexBuilder. The solution?? Pretty easy.

In the project's Properties panel (right-click the project and hit Properties...) you'll see a Flex Build Path entry in the list on the left. Click it, then choose the Library Path tab on the right. Now click "Add SWC Folder..." and navigate to your CF server's {cf_install_path}/wwwroot/WEB-INF/flex/libs folder and click Choose. This will add the {cf_install_path}/wwwroot/WEB-INF/flex/libs folder as a Flex2 library folder to your project.

Arg! Full original post with more info is here.

A whole doc on CF MX and Flex 2

Right here.

Secret sauce to hooking up CF to Flex

Looks like the simple example I was looking for is here from the Flex Doc team.

Create mysql database

mysql> CREATE DATABASE menagerie;

To list db inside of MySQL server

Can't remember this stuff...
Just type "show databases;" from sql command line.

How to backup an MySQL db

Described here.

To restore just type:
mysql projecttracker < bobber.sql

May need this later...

http://www.jeffryhouser.com/index.cfm/2007/10/9/Why-does-ColdFusion-return-a-CFC-to-Flex-as-a-generic-object

Custom keyboard shortcuts on 10.3+

Couldn't remember if I needed to enter the parent menu name; answer no. Also saw that to enter ellipses you hit Cmd+;. Nice.

Article here.

To install CF Extension wizards to FB2

Follow the instructions in the folder installed during FB2 install:

Installing the ColdFusion Extensions for Adobe® Flex™ Builder™ 2

Before you install the ColdFusion Extensions for Flex Builder, you must have the following products installed:

Flex Builder 2
ColdFusion MX 7.0.2
Note: If you installed a previous version of the ColdFusion Extensions for Flex Builder, you must uninstall that version before installing the ColdFusion Extensions for Flex Builder feature. To do so, stop Flex Builder, delete all files that begin with "com.adobe.coldfusion." from the plugins folder that is under the Flex Builder folder, and then restart Flex Builder.

To install the ColdFusion Plugin for Flex Builder 2:

In Flex Builder, select Help > Software Updates > Find and Install.
Select the Search For New Features To Install option, and then click Next.
Click New Archived Site.
Select the ColdFusion_FlexBuilder_Feature.zip file, and then click Open.
When the Edit Local Site dialog box appears, click OK.
Ensure that the ColdFusion_FlexBuilder_feature.zip is selected, and then click Finish.
In the Search Results window, select the check box next to ColdFusion_FlexBuilder_Feature.zip, and then click Next.
Select the I Accept The Terms In This License Agreement option, and then click Next.
Click Finish.
Click Install All.
When the installation is complete, click Yes to restart Flex Builder.
To uninstall the ColdFusion Extensions for Flex Builder, you must first disable them, and then uninstall them.

To uninstall the ColdFusion Extensions for Flex Builder:

Select Help > Software Updates > Manage Configuration.
Select the ColdFusion Plugins feature.
Click Disable and then click OK.
Click Yes to restart Flex Builder.
When Flex Builder restarts, select Software Updates > Manage Configuration.
Click the Show Disabled Feature button, if you don't see the ColdFusion Flex Builder feature.
Select the ColdFusion Flex Builder feature and click Uninstall.
Click Yes to confirm that you want to uninstall.
Restart Flex Builder.

CF Wizards in Flex Builder?

I'll have to look at these videos...

Coupon page

Looked pretty decent, at least for Franklin Covey stuff. Fabulous Savings.

Local candy maker - for future wife gift...

Gateau et Ganache

When to use # marks in CF code and when not

I was getting really confused for a while. Per page 179 in Ben Forta's web app construction kit book:

The following is the same functionally:
<cfset fullname="#FirstName# #LastName#">
<cfset fullname=FirstName & " " & LastName>

But his rule is: only use number signs when referring to variables and functions WITHIN A BLOCK OF TEXT.

I wish some of the sample code was more clear on this (like that generated by DW wizard).

Had to use this link to figure out how to get the demo code to appear.

But turns out it's a little harder than that. Tags like cfinvokeargument expect strings for each of each named value pairs, so we require "#variable#" syntax if we are passing in a struct...oy...

How to insert a row in Excel using keyboard shortcuts...

There really should be a direct keyboard shortcut just for this...

Jonathan, on February 22nd, 2007 at 11:39 am Said:
Insert a new row…
1 - Shift Space to select the row
2 - Control + to insert a new row
Delete a row
1 - Shift Space to select the row
2 - Control - to remove row

or even better
Alt+Enter to avoid having to use the shortcut key (after selecting a row)

Quick directions for getting IIS up and running

I always forget the right permissions to set. Wizard included with IIS makes it easy. Instructions here.

Finally figured out how to do a cluster/stacked column chart in Excel 2007

I got confused about the instructions here.
I couldn't figure out at a high level what the steps were about. Now that I better understand what's going on, here's the conceptual idea of what's going on:

• We first select a dummy table of data that contains only the labels we want to use on the horizontal axis. All values are 0 so this can be shown on the graph without actually changing the view of the data we really want to see.


• We then copy in all the data we really want to use. Map that data to be plotted on a secondary axis. We want the secondary axis for this info since the tick marks for secondary data always show by default at the top of the chart (you can change this, but it doesn't quite line up).


• We also change the overlap of each data bar to be 0 so we get the look we're going for.


• Explicitly ask for the Secondary Axis to be shown so that it behaves as we expect.
  


• Adjust the selected data so that the first blank row of data is used (for spacing purposes).


• Go to the HORIZONTAL axis options dialog and change the secondary VERTICAL access to appear Low (that is to the left, stupidest UI I've ever seen...). Vice versa for the primary vertical axis.
  


• Hide the appropriate tick marks and data labels for the axis we're not using.

Here are the semi-step by step instructions:
1. Select the small table of data you want to use for the blank horizontal axis and create a Stacked Column Chart from that data (see example file here).

2. Now select the real data you want to use and paste in the data into the chart we just created.

3. Select one of the data bars that has real data, and then right click. Select Format Data Series...

4.Change Gap Width to be 0%. Choose to Plot Series On: Secondary Axis. Click OK.

5. Do this for the rest of all the "real" data bars (you will only have to the Plot part).

6. Go to Chart Tools, Layout, Axes, Secondary Horizontal Axis, Show Left to Right Axis. Now things should be looking better (real axis on the bottom, fake one on top).

7. Right click again on one of the real data series. Choose Select Data...

8. Click each of the Legend Series can contains real data (not the dummy one) and edit the "Series name" so that it doesn't include the first blank row. Also adjust the "Series values" to INCLUDE the first blank line. Do this for all of your columns of data.

9. Go to Chart Tools, Layout, Axes, Primary Horizontal Axis, More Primary Horizontal Axis Options.

10. Change the "Vertical axis crosses:" to be "At maximum category". This switches the primary axis to be to the right.

11. Go to Chart Tools, Layout, Axes, Secondary Horizontal Axis, More Secondary Horizontal Axis Options.

12. Change the "Vertical axis crosses:" to be "Automatic". This switches the secondary axis to be to the left.

13. Turn off all unneeded tick marks and labels by changing them to None in the appropriate More Axis Options dialogs.

14. Turn on/off the appropriate horizontal gridelines.

15. Delete the dummy series from the legend.

16. Yikes! That was waaay harder than it should have been.

Wow...

Great webpage on secondary axises in Excel

I finally understand what a secondary axis is and how some of the hacks work.

Dr. James Watson - when genetics loses its soul

An interesting set of comments the co-discoverer of DNA has made over the years.

Another recap/fact check on Inconvenient Truth

Washington Post fact check

Drive space hierarchical tools

http://www.nytimes.com/2007/10/11/technology/circuits/11askk-003.html?em&ex=1193371200&en=dd7e5992516f2324&ei=5087%0A

Article from NY Times on possible tools.

Named and dynamic ranges in Excel

Sooo exactly what I needed...go Excel...did I just say that?
http://www.cpearson.com/excel/named.htm

Autism Video Glossary

Great resource. Requires setting up a username. Quick video experience kinda stinks, but great stuff.
http://www.autismspeaks.org/

Why is it so hard to find screenshot utilities for cell phones?

Kinda a basic thing...for any UI designer that is.

Couldn't get FExplorer 1.7 to install on my test Nokia N75. Finally found this for my old Treo 700w:
http://www.iliumsoft.com/site/fp/screen_capture.php

Phew!
Bob

Judge's ruling on Gore's Inconvenient Truth - where he exaggerated

http://blog.washingtonpost.com/fact-checker/2007/10/an_inconvenient_truth_for_al_g.html

Tutorials on how to create a combined cluster stacked column chart in Excel

Links to tutorials:
http://www.peltiertech.com/Excel/ChartsHowTo/ClusterStack.html

Nice quick library to concatenate two queries in CF

Code found here.

Article on how to parse 2 buttons using CF

easycfm tutorial on this

Techie explanation of EAR and WAR files

Still only kinda get it...but good enough for now...
Here

Nice guide for setting up IIS on windows XP

Here it is

SJ Mercury News article on CEA and EQ coverage

http://www.mercurynews.com/pattyfisher/ci_6850326