Category Archives: Scripting

Running a cronjob with Godaddy shared hosting

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: … Continue reading

Popularity: 4% [?]

Comments Off

NanoCharts sparklines Add-in beta for public testing

Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro Download: NanoCharts public beta 0.50 (downloaded 501 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 … Continue reading

Popularity: 17% [?]

2 comments

Automatic custom labels on Excel scatter plot

Keywords: Excel, custom labels, XY plot chart, scatter plot, macro Version: Tested on Excel 2003 and Excel 2007 Download: Quite frequently there is a need to display custom lables in a standard Excel XY-plot. Unfortunately Excel lack a native function … Continue reading

Popularity: 17% [?]

11 comments

NanoCharts enables Excel In-Cell charts with Sparklines concept

Keywords: Sparklines, MicroCharts, NanoCharts, In-cell graphing, mini charts, Excel Version: Tested on Excel 2003 Download: NanoCharts demo (downloaded 1791 times) Sparklines, or Micro charts, a concept invented by graphic design guru Edward Tufte , compress large amounts of data into … Continue reading

Popularity: 11% [?]

4 comments

Automatically calculate confidence intervals in Excel

Keywords: confidence intervals, confidence levels, macro, function, excel, how to Version: Excel 97 or later Download: In excel there are no native function for calculating confidence interval (CI) a function called CONFIDENCE to calculate the confidence interval, but it works … Continue reading

Popularity: 34% [?]

8 comments