The How to site

It’s not rocket science, but it took me a while to figure out how to run a cron job on a PHP script with Godaddy shared hosting. Without further ado, here it is:
/web/cgi-bin/php “$HOME/html/yourpath/yourpath/yourscript.php”
Hope it helps someone.
Popularity: 27% [?]Share This

Popularity: 27% [?]

Read Full Post »

Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro
Download: NanoCharts public beta 0.50 (downloaded 132 times)
Some time ago I announced a mini-project called NanoCharts, which is  an implementation of Edward Tuftes Sparklines concept. Sparklines (and NanoCharts) are basically small, word sized graphics for high density visualization of data. I have been working to make available a sort […]

Popularity: 23% [?]

Read Full Post »

Keywords: Excel, custom labels, XY plot chart, scatter plot, macro
Version: Tested on Excel 2003 and Excel 2007
Download: Automatic scatter plot labels (downloaded 390 times)
Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function to insert custom labels; the only options available are Series names, […]

Popularity: 19% [?]

Read Full Post »

Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel
Version: Tested on Excel 2003
Download: NanoCharts demo (downloaded 409 times)
Sparklines, or Micro charts, a concept invented by graphic design guru Edward Tufte , compress large amounts of data into intense, word-sized graphics, like for example:

Popularity: 29% [?]Share This

Popularity: 29% [?]

Read Full Post »

Keywords: confidence intervals, confidence levels, macro, function, excel, how to
Version: Excel 97 or later
Download: Confidence interval macro (downloaded 135 times)
In excel there is no native function for calculating confidence interval (CI) and since I need to do this calculation on a regular basis i decided to simplify this work by writing a VB function […]

Popularity: 13% [?]

Read Full Post »