815 reputation
1722
bio website code.google.com/p/…
location Westminster, CO
age 29
visits member for 4 years
seen May 6 at 4:42

I'm passionate about coding and researching the history of technology as well as exploring where technology is leading.

I used to work in flight simulation doing both hardware implementation (electrical design, wiring), web development (design, development, webmaster), as well as software development (desktop development in C#).

I'm a big fan of both using and contributing to Open source projects.

I am the creator of the pypreprocessor library that can be found on PYPI as well as Google code.


Feb
8
comment Text to columns conversion in Google Spreadsheets
@bobesponja Thanks for the heads-up. I know there's a bug with Google Scripts where event triggers from imported scripts don't register properly. To fix it, just add the onOpen trigger manually.
Feb
1
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra In your first solution try copying B2 to B3. The result cells contain continuation formulas, not raw data. The cells outputted from the script contain the actual raw data so they can be copied/moved without any issues. The intent of this question is to find an equivalent to Excel's 'Text to Columns' feature. Until, Google officially adds support the script is as close as it's going to get.
Jan
31
comment Text to columns conversion in Google Spreadsheets
@JacobJanTuinstra Because the capability can be added via Google Apps Scripting. I ended up solving my own problem by writing a 'Text To Columns' script that can now be found in the Script Gallery. Googlegooru also posted a video tutorial demonstrating its usage here googlegooru.com/text-columns-google-spreadsheets.
Sep
5
comment How can I avoid sites that scrape and republish others?
@Basilevs lol, I'm glad I could help.
Feb
16
comment How do I link a cell in Google Spreadsheets to a cell in another document?
+1 Whoa! I didn't realize there was an in-line version. The other option is to use Google Apps scripting. Create a function that uses SpreadsheetApp.openById([ID]).getRange() and set a local range with that.
Feb
16
comment Request for somebody to comment on a section of a Google Docs document?
Damn... That's pretty spiffy.
Feb
16
comment Block quote and folding in Google Docs
Hopefully they'll bring the old format back. Until then, this is the only option. If you follow my link to GetSatisfaction.com they're aware that a lot of their users prefer the old format and from talking to the Google's rep, it doesn't sound like they're going to disable the old version any time soon.
Feb
16
comment Block quote and folding in Google Docs
To workaround all the browser inconsistencies, Google switched over to a SVG rendering model for Docs instead of using HTML. That's why the new version of docs doesn't support raw HTML/CSS editing. I have already raised the issue (and received a response) with Google on GetSatisfaction.com here getsatisfaction.com/google/topics/…. I'm hoping, with enough support we can get them to bring the old format back under a different name.
Feb
16
comment Google Apps for Business Local Backup
No problem. I have been using Dropbox user since the start and Docs for the past year. The hard part is convincing the company I work for to do the same. If you wanted a shared solution in Google Apps for Business, one option would be to create a group account. Make the group account the owner of the shared docs within that group and attach the offline sync to the group account. With Insync, you can attach multiple nodes to a single account.
Feb
16
comment Google Apps for Business Local Backup
@OrangeBox Fair enough. I found a better solution. See my new answer.
Feb
7
comment What “address book” web app would you recommend?
I do the same with an iPhone. The trick to syncing contacts is to setup a Microsoft Exchange server and enter your Google account info. When I add new contacts to that phonebook they're automatically updated and the native Address Book app works perfectly with the integrated contacts.
Feb
7
comment Google Apps as an online harddrive?
and... if you delete a folder on your desktop, it doesn't delete all the files within that collection online.
Feb
7
comment How can I remove individual google products?
This doesn't necessarily answer your question but with 'Google Apps for Business' you can turn off individual services through the Domain Administrator settings.
Feb
7
comment How can I delete a paid Google Apps Business account without stopping my Postini service if I use Postini for the same domain?
This isn't a definitive answer because it may not be 100% accurate... but, no. It looks like Google has married the two services so it isn't possible to use one without the other.
Feb
7
comment Will Google track me less if I pay for Google Apps for Business?
@Jaips Yes, unless you disable and opt out of all tracking services.
Feb
7
comment Will Google track me less if I pay for Google Apps for Business?
@Zac AFAIK, only the ads in Gmail target information based on your emails.
Feb
7
comment Will Google track me less if I pay for Google Apps for Business?
+1 Good stuff @Eight Days of Malaise.
Feb
6
comment Google Apps for Business Local Backup
@OrangeBox You do realize that after a sync, all of the files that are dumped into dropbox get synced back to all the users computers, right? What you're suggesting is rolling your own version of a service that is already available at a reasonable price. I hope your time isn't worth much because the scope of duplicating that kind of feature set is definitely non-trivial. Especially for obscure features like administering Google Apps Domains and Dropbox Team accounts. Best of luck...
Feb
3
comment How Can I Delete My YouTube Account?
+1 @rlb.usa It's there as I just used it a few days ago. It takes some time for Google to perpetuate updates to all of it's users accounts. Try clearing your cache to see if that makes a difference.
Feb
2
comment How can I refer to two different columns in a COUNTIF function?
@tic I wasn't using the boolean true (which is TRUE in Google Spreadsheets) I was referring to 'true' the string that the op used in his question. Try it, I'm pretty sure that if you test the values for C:C it will always return TRUE on a non-empty string. In the spreadsheet cells Google sticks to the Excel rules over JavaScript. Welcome to the fun world of leaky abstractions.