One Aging Geek

Friday, April 29, 2005

New tool, same old problems

I've been posting mostly using w.bloggar and mostly directly from SharpReader. But my w.bloggar installation got fubarred just after that the author's website got hacked. And, of course, contrary to my normal practice I hadn't saved the install file. So I had to wait for the site to get rebuilt. So far all it has is a new version of w.bloggar and that new version doesn't coexist with the plugin from SharpReader. In the hunt for a new posting tool and also with some growing annoyance at the lack of updates to SharpReader, I turned up Sauce Reader. It's not a bad reading tool and is only just OK as a posting tool (it has a built-in weblog post tool or can call w.bloggar... but that latter ability is broken). So the new tool is Sauce Reader. The same old problem is horrible mangling of text. Probably due to incorrectly marked content on the Web. Probably due to Microsoft tools lying about charset. Sigh.

BMD: Burrito of mass destruction

Seems like there have been several of these lately, not sure why.  This one is particularly funny.


Burrito of Mass Destruction

Xeni Jardin: A call about a suspected lethal weapon at a middle school caused police to place armed officers on rooftops, shut off nearby streets, and lock down the school. The culprit: a giant burrito. A suspicious onlooker phoned authorities yesterday after seeing a boy carry something long and foil-wrapped into Marshall Junior High.

Two hours later, drama ended when item was identified as a 30-inch burrito filled with steak, guacamole, lettuce, salsa, and jalapenos, wrapped inside tin foil and a white T-shirt.
Link (thanks, caines)

Wednesday, April 27, 2005

Brilliant or pathetic, only time will tell

Update: fixing up mangled text. I'm really struggling to decide if this is brilliant (in the sense of a way to make lots of money) or pathetic (as in totally clueless). It could be that this is the next Reality TV. While I don't personally watch any of the reality TV shows (no really not a one), I know that a huge number of people do and that the production costs are a fraction of "real" TV shows.

Infinity Broadcasting to air podcasts on the radio

Engadget podcast icon - normal size

From the same company bringing visual radio to the States comes another, um, creative stab at salvaging flagging revenues: putting podcasts on the air. Infinity Broadcasting will be launching the world’s first all-podcast radio station on May 16, dubbed KYOURadio. They’re converting previously talk-radio format 1550 KYCY, a San Francisco AM station, to entirely listener-submitted content. Podcasters will submit digital audio files for consideration, which will be reviewed for quality standards and FCC guidelines before being simultaneously broadcast over AM and streamed online at Infinity is going to cover licensing fees so podcasters can use major record label music in their shows, although this won’t really benefit those who play primarily indie and unsigned artists. Plus, licensing complications have prevented Infinity from offering downloadable program archives, which misses one of the essential aspects of podcasting: the time-shifting element. The whole reason many of us find the time to listen is because we can download shows and take them anywhere on portable players — so while we think it’s a positive trend that the airwaves are being opened up to the great unwashed masses, it’s really a different animal from podcasting proper.

Something I (sadly) might need one of these days

Update: Fix up some mangled text, still some left. Sigh.

Professional Excel Development

Posted by timothy (34% noise) View r3lody (Raymond Lodato) writes

Over the years, I've read a number of books on Excel programming. Each one seemed much like the previous one, generally talking about writing macros and creating data-entry forms. Professional Excel Development takes the concept quite a bit farther. Rather than giving you the same old tired lessons, this book goes into detail on exactly how to build professional level applications. It even explains how to make your Excel-based application look as though Excel had nothing to do with it. Suffice it to say, this isn't your daddy's Excel book Read on for the rest of Lodato's review.

The authors, Stephen Bullen, Rob Bovey, and John Green, show a level of sophistication well beyond the norm. They'd rather teach you the proper way to program instead of teaching you how to use Excel. In fact, the first thing they do is distinguish five different levels of usage: Excel users, Excel power users, VBA developers, Excel developers, and professional Excel developers. The book is written for the highest level, so expect a lot of depth.

Rather than simply show how to record a macro and reuse it, they start by talking about coding practices, naming conventions and application structure. That's followed by an entire chapter on worksheet design, including names, styles, validation, formatting and controls. After a chapter on add-ins, they launch into the topic of dictator applications, that is, applications that completely take over the Excel interface and look like a regular, non-Excel program.

The following chapters go into much more detail about wringing every ounce of functionality from Excel, and then turning to the operating system and Visual Basic for more help. After discussing data manipulation with databases, they talk about using XLLs and the C API, VB.NET, and writing Help files to complete the application. The entire structure of the book builds around a time-entry application that is developed from a simple spreadsheet to a full-blown, production quality program. A CD-ROM is also included with all of the source code and multiple examples that are scattered throughout the book.

Reading Professional Excel Development is not something to be taken lightly. The authors have done a fine job putting together a cohesive methodology for using Excel as an application development platform. I know of no other book that covers this platform in such depth. At times I found myself lost in the details, but I suspect a "professional Excel developer" (which I am not) would be delighted in the depth of description and copious examples provided.

I tried to relate a lot of what Stephen, Rob, and John discussed to OpenOffice Calc, to see if it could be ported to an open source environment. I was surprised by how much actually came across. Granted, items in OpenOffice are sometimes in different places, or named differently, than their counterparts in Excel, but most of the same functionality is there. Unfortunately, most of the examples are written in VBA, whi’h doesn’t translate cleanly into OpenOffice. Still, with perseverance, you would probably be able to develop most of what is described in the book.

Professional Excel Development is an extremely well-written book that covers the use of Excel to a depth few authors have dared to tread. The text gives you the tools to build applications that are much more than automated spreadsheets. Almost any program your imagination can devise can be created using the techniques given, which is a testimony to the power of Excel. Bash Microsoft if you want, but they do sometimes come up with a winner, and Professional Excel Development allows you to take full advantage of its capabilities.

You can purchase Professional Excel Development: The Definitive Guide to Developing Applications Using Microsoft Excel and VBA from Slashdot welcomes readers' book reviews, to see your own review here, read the book review guidelines, then visit the submission page.

He picked the wrong title - by InstBrad (Score: 4, Insightful) Thread Had the book b“en called “Professional OpenOffice”Development”, this crowd would have fallen all over themselves praising it.

It gets real tiring listening to all the folk’ that couldn’t say a nice word about a MS product if you paid them. Gu…ss what folks… there are millions and millions of people that use Excel in very sophisticated ways. Why? Because it works well enough. With the help of this book, maybe it will work even better.

There are many ways to skin a’cat. You haven’t g’t a lock on God’s One True Programming Language.

I know where they use excel - by Mantorp (Score: 5, Insightful) Thread It’s called the real world, based on the ridiculous comments thus far I suggest a visit.

all hail the ignorant masses! - by Jailbrekr (Score: 5, Insightful) Thread To quote the first two: “BR> “Professional Exc’l Development? Isn”t that an oxymoron?” &nb“p; “Professional Excel Development is like painting a ho”se with tomatoe paste” The entire financial sector bases its existance on Excel. Brokers, bankers, and virtually every banking or stock related position has a deep dependance on Excel. Laugh all you like at the thought of a professional excel developer, but I highly doubt that these firms will simply drop Excel in favour of some smelly nerds coding in C#.

God help us - by oniony (Score: 4, Informative) Thread Heaven forbid any of the traders in the investment bank I work in get a hol’ of a copy of this. It’s bad enough as it is trying to get them to move over to the manageable, scalable applications we build for them without encouraging them to build more spreadsheet solutions.

This better be for Office 2003 - by MrAnnoyanceToYou (Score: 4, Informative) Thread My advice is to not build huge applications in Office unless you have absolutely up-to-date versions. There are certain points in Office 97 / 2000 where you get to a critical load area of your code and suddenly die. Function calls’are in the help but don’t quite work pr’perly. Old pr’ducts aren’t supported. I’m buying this book because I need it, but building an app with older tools - something many office users are relegated to - is not that great an idea. Note: this could all change in Office 2003.