Excel Web Design

Client projects and tech blog posts about Excel

Discover Thyself featuring the Discern-o-Matic QuizDiscover Thyself is a "discernment" site for Quaker teens. Sponsored by Earlham College, it features resources, videos and the all-new "Discer-o-Matic Quiz."

The design is all original. We went through six rounds of the concept design mockups made up on Adobe Fireworks. Because the site is built on WordPress used as a CMS, Earlham College staff was able to add and arrange content even before the design coding began. The site uses the excellent Thematic theme, a blank template that allows for quite sophisticated designs using Action Hooks and complete CSS markup.

The most exciting element of the site is the "Discern-o-Matic" quiz, which takes users through a series of questions. At the end the questions are reorganized and presented to the user to help them understand what it is they want to do. The quiz is powered using the open-source LimeSurvey. Results are outputted via a custom PHP script that polls the LimeSurvey database and outputs in a nicely-worded and formatted WordPress results page. The templates for Lime Survey were altered to mimick the look of the rest of the site; the average user won't notice the pass-off from WordPress to Lime Survey and back to WordPress.

In hopes the quiz might go viral, individual results are saved on a unique URL. Users are invited to share their results page via Facebook.

Visit Site: http://www.discoverthyself.org
Categories: Client Sites , Educational , Facebook , Faith-Based , LimeSurvey , Nonprofit , WordPress
Tags: Wordpress Limesurvey "Earlham College" Discernment Quaker School "High School" Quiz Viral Facebook | Edit
Collected from LinkedIn:

"The list allowed me to click only three attributes, but for Martin I wanted to check them all. He is a wonderful, personable, creative person who also happens to be unflappable. I highly recommend his for web design." March 30, 2010

Tom Ferrick, Journalist/Publisher, Phlmetropolis.com
Hired Martin as a Graphic/Web Designer in 2009
Top Qualities: Great Results, Personable, Good Value.


"Martin has provided -- and continues to provide excellent service and consultation as a Web site developer. For my site on New York-based architecture and history, Mindfulwalker.com, I asked for some complex developments of and changes to a WordPress theme and the site installation. I received the service that I needed and more, and I'm very happy with the site today. Martin brings a variety of assets to his role: He is extremely knowledgeable and capable in programming and Web tools. He's also a good communicator, is very value-conscious about the service he delivers for the cost, and is understanding of client needs. Beyond this, Martin helped with some excellent tutorials as I took over the site. I plan to hire Martin again as I look forward to enhancements and additional developments for my site and business. Martin is excellent at what he does!" May 10, 2009

Susan DeMark, Journalist, Mindfulwalker.com
Hired Martin as a Graphic/Web Designer in 2007
Top qualities: Great Results, Good Value, High Integrity



"Martin provided great value in designing a website for my law practice. He was accessible and facilitated the process, despite our geographical distance, through email and telephone consultations. He was flexible in working with me to achieve what I was looking for within my budget." May 1, 2009

John Kindley, Lawyer.
Hired Martin as a Graphic/Web Designer in 2008
Top qualities: Personable, Good Value, High Integrity



"Martin is not only highly competent as a Web site developer, he's also one of the most honest and trustworthy people I've ever hired. I highly recommend Martin." April 30, 2009

James Maguire, Author, MaguireOnline.com
Hired Martin as a Graphic/Web Designer in 2006, and hired Martin more than once.
Top qualities: Great Results, Personable, Expert



"Martin has worked for our school to integrate Web 2.0 technologies into our communication materials. Martin is highly-personable and his is an expert in current technological approaches. This is a hard match to find in consultants." April 30, 2009

Michael Moulton, Technology Director, William Penn Charter School.
Hired Martin as a IT Consultant in 2007, and hired Martin more than once.
Top qualities: Personable, Expert, High Integrity.



"Martin has an outstanding grasp of everything there is to know about the internet. He is our "go-to" guy whenever we encounter something new and different, especially involving Web 2.0 and Search Engine optimization. He is also an experienced and skilled designer and has excellent PHP/CSS/HTML programming knowledge. Martin is a pleasure to work with in every respect!" May 1, 2009

Barbara Raphael, Founder/Owner, Raphael Webscapes, LLC.
Worked directly with Martin at Raphael Webscapes.
Categories: references
Tags: Architecture, Budget, Communication, Consultations, Go-To Guy, Graphic, Haddonfield, History, Honest, It Consultant, Journalist, Law Practice, Lawyer, Linkedin, New York City, Raphael Webscapes, School, Search Engine Optimization, Technology Directory, Trustworthy, Web 2.0, Web Designer, Website, Wordpress | Edit
Mindful WalkerNew York City Journalist Susan DeMark looks for the stories behind the architecture, buildings, history, and nature of NYC and beyond. She and a graphic designer put together the look of the site and I performed the CSS magic to translate their vision into a WordPress blog.

Visit: Mindful Walker

Categories: Client Sites , Custom Design , Journalists & Artists , WordPress
Tags: Architecture, Css, Graphic Design, Journalism, Journalist, New York, Wordpress | Edit
screen-shotMy Twitter followers will know I've been slightly obsessed by Google's new browser, Chrome, since word leaked that it was going to be released today (Tues, Sept 2). I've been hitting reload on the download site fairly obsessively. A few minutes ago my persistence was rewarded and I'm writing to you all from the new browser (here's the official release announcement).

Why a New Browser?!?

Before I begin, let me recommend the Google Chrome online comic book for those with tech interests. Google does a good job explaining why they've joined the browser wars. At first glance it seems a needless move: they already fund much of the development on the open source Firefox browser. But Firefox, like Microsoft Internet Explorer and every other browser, is built around certain assumptions about how browsers process applications. Google is starting from scratch and thinking about the browser as an operating system running increasingly sophisticated applications (like Gmail). Chrome separates memory process and internet permissions in new ways.

Obviously, Google is going after Microsoft (the initial release of Chrome is Windows only)--not just its browser but its Vista operating system as well. With the expansion of high speed internet access and so-called "cloud computing," functions that used to require stand-alone clients can now be handled inside the browser. Email has probably become the most widely adopted browser applications but you can also do things photo editing and video recording through the browser. Google knows that once an application is running inside a browser, the operating system doesn't matter. Gmail works equally fine from Vista, Mac OS X, or Linux.

It is in Google's strategic interest to advance the state of browser technology and they do that with Chrome. But it is in the interest that everyone have access to these latest innovations and that all browsers can run the most sophisticated applications Google engineers can put together. So Chrome is open source and Google invites other browsers to incorporate many of its features.

First Thoughts on the Product:

The download was quick and easy (of course).

I was surprised that when installing it only offered to import my MS Internet Explorer bookmarks. My most complete and up-to-date bookmark list is in Firefox (synced among my operating systems by the excellent Foxmarks extension).

I went pretty immediately to Gmail. Google says they've rewritten a lot of the background rendering code from scratch and I was expecting to see instantaneous loading. Frankly, it seemed to load as quickly as it does in Firefox. Any apparent speed increase isn't immediately obvious (this is a testament to how fast they've managed to get it to load in all browsers).

speed-dialThe interface is very simplified: few buttons, tabs up top, no status bar. There's a lot of surprises here, like an automatically generated page with thumbnails of your most frequently visited sites (see image, right), an idea borrowed from Opera browser's "Speed Dial" feature (available through to Firefox users through the Speed Dial extension).

gmail-as-app You can also "Create application shortcuts" which turn services such as Gmail into client-like applications that sit on your desktop (screenshot right). Open them up from here and the normal location bar and browser buttons are gone.

There's a lot more to explore here. It's obvious that Google has put a lot of thought into this. I'm not going to dismiss any feature or oddity too quickly. They helped a lot of us rethink how we organize email using a single "Archive" folder instead of the elaborately-maintained folder hierarchy. Google actually have put out a number of half-baked and under-supported services (Froogle and Google Checkout come most immediately to mind) but it's clear that the Google Chrome browser is a very serious initiative by the company.

Will I Use It?

The big question, right? Actually, I won't use it much for now. For one thing, I'm a Mac user. I have a Windows XP virtual machine running most of the time courtesy of VMWare's Fusion. I'm sure Google has set a high priority to make Mac OS X and Linux versions of Chrome--they're whole strategy rests on this being woven into the browser lingua franca that keeps Microsoft's Vista at bay, remember?, but until that time Chrome won't be my natural first choice.

But I'm also going to miss my Firefox extensions. I forgot that the web has lots of ads (Adblock Plus). And I don't like the extra clutter of Gmail without Better Gmail 2 (just the "Folders4Gmail" feature of the latter saves my eye more scanning time than any speed tweak Chrome delivers). And these days the Web Developers Toolbar, Lastpass, FireFTP extensions are pretty essential to my work day.

But if a native Mac version was released? And if Firefox extensions started being rewritten for Chrome? I just flipped back to my regular browser to check something and even after an hour with Chrome, Firefox felt so heavy and clunky. It is possible to see Chrome could a serious contender for my attention.
Categories: Practical 2.0
Tags: Bookmarks, Browser, Firefox, Fireftp, Gmail, Google, Google Chrome, Internet Explorer, Lastpass, Linux, Mac Os, Opera, Twitter, Vista | Edit
I was recently working with a client who has a large Google Adwords campaign, with an annual ad budget in the low six figures. He's been very careful about the keywords he's chosen and we've both poured over the Google Analytics figures to see how the campaign progressed.

It took a third party keyword tracking system to discover that many of the ads were being served up to wrong keywords in the Google searches. I want to keep the client's identity private, so let me use an analogy: say you're a boomerang maker and you've bought a campaign intending ads to show up for those who search "boomerang" in Google. What we discovered is that Google was serving up a large percentage of these ads for searchers of "frisbees" -- close, but not close enough for searchers to care. Few people clicked on the misplaced ad. We're talking serious money wasted on ads served up to the wrong target audience.

How did a carefully constructed ad campaign get on so many poorly-targeted searches? Google allows fuzzy matching under their broad match guidelines:
For example, if you're currently running ads on the broad-matched keyword web hosting, your ads may show for the search queries web hosting company or webhost. The keyword variations that are allowed to trigger your ads will change over time, as the AdWords system continually monitors your keyword quality and performance factors. Your ads will only continue showing on the highest-performing and most relevant keyword variations.
You can disable these broad searches using negative keywords (i.e., "-frisbee") and with specific keywords ("boomerang").

But Google does not make it easy to see just where your ads are going. You have to set up a special Search query performance report. It's really essential that anyone doing a large Google Ad campaign set up one of these searches and have it automatically emailed to them every month. Google clearly wasn't tracking the "performance" of its broad search on this client's ad. I'm particularly disturbed that we didn't see these misdirected keywords listed in the Google Analytics tracking reports. It is dangerous to use the same company to both sell you a service and to report how well it's been doing.

Credit where it's due: it was the excellent long-tail blog content service Hittail that gave us the information that Google was misdirecting its ads. See my previous Hittail coverage.
Categories: Analytics , Beyond SEO
Tags: Adwords, Analytics, Hittail, Performance, Report, Search | Edit
Web 2.0 tools have changed the boundary lines between techies and program staff in many nonprofits over the past few years. At least, they should have, though I know of various organizations that haven't made the conceptual leap to the new roles.

OLD SCHOOL: Webmaster

Let me explain by talking about my own changing work role. Even a few years ago, I was a paid staff webmaster. You could divide my work into two large categories. The first was techie: I managed server accounts, set up required databases, designed sites. I got into the HTML code, the PHP, the Javascript, CSS, etc.

The other was content: when program-oriented staff had new material they wanted on the website they would email it to me or walk it over. I would put in my work queue, where it might sit for weeks if it wasn't an organizational priority. When it came time to add the material I would boot up Dreamweaver, a relatively expensive program that was only accessible from my laptop and I would put the material onto the website. Needless to say, with a process like this some parts of the website never got very much attention.

At some point I start sneaking in a content management system for frequently-changed pages. This seemed very hackish and not good at first but over time I realized it greatly speeded up my turn-around time for basic text content. But the organizations I worked for still relied on the old model, where staff give the webmaster content to put up.

NEW SCHOOL: Web Developer

Nowadays I'm a web developer, a freelancer with an ever changing list of clients. I typically spend about a month putting together a site based on a content management (like this) or automatic feed system (like I did for Philadelphia's William Penn Charter School). I do a certain amount of training and while I might add a little content for testing purposes, I step back at the end of the process to let the client put the material up themselves. I'm available for questions but I'm surprised about how rarely I'm called.

Here's two examples. Steadyfootsteps is a blog by an American physical therapist in Vietnam. When we started, she didn't even have a digital camera! I gave her advice on cameras, started her on a Flickr account, set up a fairly generic Movable Type blog with some custom design elements and answered all the questions she had along the way. She went to town. She's put tons of pictures and embedded Youtube videos right in posts. Here's a non-techie who has contributed a lot to the web's content!

Penn Charter is a school that was already on Flickr and Youtube but wanted to display the content on their website in an attractive way. I pulled together all the magic of feeds and javascripts to have a media page that showcases the newest material.

They're very different sites, but in neither instance does the client contact me to add content. They rely on easy-to-use Web 2.0 services: no specialized HTML knowledge required.

NEW TOOLS, OLD MODEL

I got an email not so long ago from an old boss who manages a monthly magazine. Her site has been radically rebuilt over the years. Dreamweaver is out and content management is in. They use Drupal, which my friend Thomas T. of the Philadelphia Cultural Alliance tells me won the recent popularity contest among nonprofit techies. This is great, a definite step forward, but what confused me is that my old boss was asking me whether I would be interested in returning to my old job (the successor who oversaw the Drupal upgrade is leaving).

They still have a webmaster? They still want to funnel website material through a single person? Every staffperson there is adept at computers. If a physical therapist can figure out Flickr and Movable Type and Youtube, why can't professional print designers and editors?

My hourly rate ranges from two to five times what she'd be likely to pay, so I turned her down. But I did ask why she wanted a webmaster. Now that they're on Drupal it seems to me that they'd be better off switching from the webmaster to the web developer staffing model: hire me as a freelance consultant to do troubleshooting, staff training and the occassional special project but have the regular fulltime staff do the bulk of the content management. I'd think you'd end up with a site that's more lively and updated and that the cost would about the same, despite my higher hourly rates.

I've heard enough stories of places where secretaries have come out of the shadows to embrace content management and have helped transform websites. I'm the son of a former secretary so I know that they're often the smartest employees at any firm (if you walk into an office looking for the expert on advanced Excel features you'll surely find them sitting right there behind the receptionist desk).


FINALLY: WHAT'S UP WITH DRUPAL?

I'm trying to join the bandwagon and use Drupal for a upcoming site that will have about a dozen editors. But there's no built-in WYSIWYG editor, no little formatting icons. Sure, I myself could easily hand-code the HTML and make it look nice. But I don't want to do that. And it's unrealistic to think I'm going to teach a dozen overworked secretaries how to write in HTML. The interface needs to work more or less like Microsoft Word (as it does in Movable Type, CushyCMS, Google Docs, etc.)

Most Drupal sites I see seems from the outside like they're still old school: staff webmaster through whom most content funnels. Is this right? Because if so, this is really just an institutionalization of the content hack I did six years ago. Can anyone point me to lively, active Drupal sites whose content is being directly added by non-techie office staff? If so, how is it set up?
Categories: Drupal , Practical 2.0 , Web Design
Tags: Css, Dreamweaver, Drupal, Flickr, Javascript, Movable Type, Penn Charter, Philadelphia, Php, School, Web 2.0, Web Developer, Youtube | Edit

Last weekend I found myself with the scenario no solo web designer wants to be faced with: a dead laptop. It was eighteen months old and while it was from Hewlett Packard, a reputable company, it's always had problems over overheating. Like a lot of modern laptop makers, HP tried to pack as much processor power as they could into a sleek design that would turn eyes on the store shelf. They actually do offer some free repairs for a list of half a dozen maladies caused by overheating but not for my particular symptoms. When I have a free afternoon, a big pot of coffee and lots of music queued up I'll give them a call and see if I can talk them into fixing it.

Once upon a time having a suddenly dead computer in the middle of a bunch of big projects would have been disaster. But over the last few years I've been putting more and more of my data "in the cloud," that is: with software services that store it for me.

Email in the Cloud

I used to be a die-hard Thunderbird fan. This is Firefox's cousin, a great email client. I would take such great care transfering years of emails every time I switched machines and I spent hours building huge nested list of folders to organize archived messages. About a year ago Thunderbird ate about three months of recent messages, some quite crucial. At that time I started using Google's Gmail as backup. I set Gmail to pick up mail on my POP server and leave it there without deleting it. I set Thunderbird to leave it there for week. The result was that both messages would be picked up by both services.

After becoming familiar with Gmail I started using it more and more. I love that it doesn't have folders: you simple put all emails into a single "Archive" and let Google's search function find them when you need them.You can set up filters, which act as saved searches, and I have these set up for active clients.

Why I'm happy now: I can log into Gmail from any machine anywhere. No recent emails are lost on my old machine.

Project Management in the Cloud

I use the fabulous Remember the Milk (RTM) to keep track of projects and critical to-do items. Like Gmail I can access it from any computer. While messing around setting up backup computers has set me back about ten days, I still know what I need to do and when I need to do it. I can review it and give clients renewed timelines.

An additional advantage to using Remember the Milk and Gmail together is the ability to link to emails. Every email in Gmail gets its own URL and every saved "filter" search gets its own URL. If there's an email I want to act on in two weeks, I set up a Remember the Mail task. Each task has a optional field for URLs so I put the the email's Gmail URL in there and archive the email so I don't have to think about it (part of the Getting Things Done strategy). Two weeks later RTM tells me it's time to act on that email and I follow the link directly there, do whatever action I need to do and mark it complete in RTM.

Project Notes in the Cloud

I long ago started keeping notes for individual projects in the most excellent Backpack service. You can store notes, emails, pictures and just about anything in Backpack and have it available from any computer. You can easily share notes with others, a feature I frequently use to create client cheatsheets for using the sites I've built. Now that I use Gmail and it's URL feature, I put a link to the client's Gmail history right on top of each page. Very cool!

Another life saver is that I splurge for the upgraded account that gives me secure server access and I keep my password lists in Backpack. There's a slight security risk but it's probably smaller than keeping it on a laptop that could be swiped out of my bag. And right now I can log into all of my services from a new machine.

Keeping the Money Flowing from Clouds

The latest Web 2.0 love of my life is Freshbooks, a service that keeps track of your clients, your hours and puts together great invoices you can mail to them. I'm so much more professional because of them (no more hand written invoices in Word!) and when it's billing time I can quickly see how many unbilled hours I've worked on each project and bang!-bang!-band! send the invoices right out. Because the data is online, I was able to bill a client despite the dead computer, providing my exact hours, a detailed list of what I had done, etc.

Others

Calendar: I always go back and forth between loving Google Calendar and the calendar built into Backpack. Because I can never make up my mind I've used ICal feeds to cross-link them so they're both synced to one another. I can now use whichever is most convenient (or whichever I'm more in the mood to use!) to add and review entries.

Photos: Most of the photos I've taken over the past four years are still sitting on my dead laptop waiting for me to find a way to get them off of the harddrive. As tragic as it would be to loose them, 903 of my favorite photos are stored on my Flickr account. And because I emailed most of them to Flickr via Gmail most of those are also stored on Gmail. I will do everything I can to get those lost photos but the worst case scenario is that I will be stuck with "only" those 900.

Your Examples?

I'd love to hear how others are using "the cloud" as real-time backup.

Categories: Practical 2.0 , Windows to Mac
Tags: Calendar, Flickr, Freshbooks, Gmail, Hp, Laptop, Remember The Milk | Edit

Search

As Seen In

EBook

Shortcut cover
Web 2.0 Mash-Ups & Niche Aggregators (O'Reilly Media, 2008, $9.95): Order here.

Social Networks

Other Sites

Archives