Sponsored Links

License

CC-GNU GPL
All source code and document content on this page is licensed under the CC-GNU GPL.

projects

Stuff to take up some of my free time; other web projects, communication tools (templates and samples), interesting chunks o' code ...

Web Projects

Offsite Strategy

When I talk about having an "offsite strategy" meeting, I'm looking to get out of the office and have some good, "strategic" conversation over a cup of coffee or a beer ...

OffsiteStrategy.com Web site
OffsiteStrategy.tar.gz Source code
Back to Top

Document Samples

Presentations

Powerpoint Fun Samples.ppt Includes the Movie Preview / Coming Attractions slide (read more ...)

Spreadsheets

Portfolio Management Sample.xls A sample (hacked up, not fully working) of a Project Portfolio Management worksheet (read more ...)
Column Validation Sample.xls Working example of VBA to validate existence of data in a column of a data table (read more ...)

White Papers

Master Data Benchmarking (Survey).xls Bootstrap Market Research: Master Data Management (Survey Form) (read more ...)
Master Data Benchmarking (Results).pdf Bootstrap Market Research: Master Data Management (Results) (read more ...)
Latest Update: 12/17/2009
Back to Top

Templates

Word Processing

Cazh1 White Paper Template.ott Open Office Writer 2.0 - generic, but very clean, white paper template (read more ...)
Back to Top

PHP

c_log.php Standardized logging of processes for your php web scripts.
PushToRemote.php Publish folder to a web server using FTP. Assumes you have a nice clean local copy of your web site, you've made a lot of changes, and you want to get your external web server to match. This routine uses FTP to make the push, and includes these features:
  • Make a local backup (tarball) of the destination site before you clomp thru with your changes (allows for disaster recovery)
  • Adjusts for time difference between your local machine and your web server
  • You can specify which folders and/or files to skip, if required Standardized logging of processes for your php web scripts.
RandomQuote.php
RandomQuoteData.txt Print a random quote form a formatted list.
Back to Top

SQL

fnGetWorkingDays() MS SQL Server 2000 function that counts the number of working days between two dates, including the start and end days
Back to Top

VB Script / ASP

WriteParameter() Function that writes a named query string parameter
Back to Top

VBA - Visual Basic for Applications

MS Excel

CustomToolBar() Create a custom toolbar, with custom menu option - Excel version
DailyEMailCount() Loop thru Outlook folders, count read / unread eMails
GetFileName() Use a standard MS Office File Open dialog to get a file name
(this should work in any Office app)
NicePrintPage() I always like my print output pages formatted with a nice clean look feel, and standardized page header / footer. This routine nicely puts all of my fav formats in a single place.

MS Outlook

countMailItems() Count items in your Mail folders, and display the folders that have greater than some max value. Tool for use when managing your mail.

MS Project

CustomToolBar() Create a custom toolbar, with custom menu option - Project version
NicePrintPage_Gantt() I always like my print output pages formatted with a nice clean look feel, and standardized page header / footer. This routine nicely sets up a Gantt view for printing.
NicePrintPage_Resource() Same as above, but this one nicely sets up a Resource view for printing.
SetSortName() I like my Resources to sort by last name, but display FirstName LastName

MS Word

CustomToolBar() Create a custom toolbar, with custom menu option - Word version
Back to Top