Browsing the archives for the Scripting category

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: 6% [?]

Popularity: 6% [?]

NanoCharts sparklines Add-in beta for public testing

Keywords: NanoChart, Microcharts, Sparklines, Excel, VBA, Macro
Download: NanoCharts public beta 0.50 (downloaded 354 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: 24% [?]

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: Automatic scatter plot labels (downloaded 4207 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% [?]

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 1258 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: 11% [?]

Popularity: 11% [?]

Automatically calculate confidence intervals in Excel

Keywords: confidence intervals, confidence levels, macro, function, excel, how to
Version: Excel 97 or later
Download: Confidence interval macro (downloaded 2841 times)
In excel there are no native function for calculating confidence interval (CI) a function called CONFIDENCE to calculate the confidence interval, but it works slightly different from the custom confidence function I present here.
Since I [...]

Popularity: 32% [?]