When I joined the company, we talked about all sort of systems that we would need to get up and running pronto. Things like a CRM solution, subscribing to a sales suite like salesforce.com, etc. I made the rather bold statement that we should just use some spreadsheets to track things. There were several reasons…
Many people are familiar with the idea of looking at a sales pipeline and discounting the potential revenue by the probability that the deal will close. (e.g., a $1M deal that has a 10% chance of closing is discounted to $100k). For relatively small organizations, it turns out that using this thinking and applying…
I’m doing some VS2005 development using a nifty tool called TallPDF. It lets me build up a PDF from XML files from one of my clients (among other nice capabilities). I ran into a silly problem, and thought that I should share some solutions to it. I could open the compiled HTML help (.CHM)…
I posted an Excel spreadsheet to a document library in our Sharepoint 2003 site. When I open it from there, all of the Pivot Table source data is ‘broken’. Rather than using the named range ‘[rangename]’ that I had given when I set up the Pivot Table, it now points to https://[servername]/[sitename]/[filename]’![rangename] which it then…
I’ve been trying out new (for me) Microsoft widgets on my laptop. In doing so, I’ve run across a few things that work well: Windows Live Toolbar – I’ve been a Google toolbar guy for years. One of the main things I like about it is the Autofill capability. Live Toolbar now has that with the…