Keywords: histogram, normal distribution, Excel 2007, column chart
Version: Should work with any version. Tested with Excel 2007.
This article contain a quick tutorial on how to create a simple histogram in Excel 2007, to visualize for example student test score, like in the example.
Continue Reading »
Popularity: 18% [?]
Share This
Posted in Excel | No Comments »
Download: QC chart for Excel 2007 / 2003 (downloaded 87 times)
A couple of years ago I created a very simple QC-chart to keep track if instrument performance over periods of time. The chart fetches the usual data from user input and calculates average, upper and lower control and warning limits, and plots these data into an Individuals chart and a Moving average chart.
Once you have established the acceptable performance of your instrument/method, this makes it very easy to see if your method is performing poorly.
The baseline performance is usually established by collecting data over an extended time period, say one month, using some form of stable reference testing material. In the case of chemical analysis this can be a certified reference material (CRM) consisting of for example metal ions of a known concentration in a stable sample matrix.
Continue Reading »
Popularity: 15% [?]
Share This
Posted in Excel | No Comments »
Traditionally it has been quite hassle to integrate a forum to a wordpress powered site, using a number of such bridge hacks to integrate phpBB and SMF I know how much work and trouble it can be; if you even get it to work. One option has been to use bbPress, a Wordpress forum plugin which works nicely out of the box, but leaves a lot to be desired in terms of design and functions.
Therefore I was quite excited to find a plugin called Simple:Press forum, which is a forum with features and functions that is much closer to what you expect to find i a modern forum:
- ‘Pretty/SEO’ Friendly Permalinks. And the good news - should also be able to display links with the old url structure.
- Private Messaging - the second most regular request.
- Powerful User Group and Permission structure. Fine control over who can see and do what.
- New ‘QuickLinks’ dropdown on the Search Bar displaying recent and unread posts
- Bulk Moderate Posts needing approval and read new posts in one place
- Login Form bought into current page view
- Mass Deletion tool for the removal of old topics
- Many ‘Custom’ options: Up to three custom icons in login bar; set custom icons for all Groups and Forums; Use a graphic in place of page title; Create a special ‘editor’ message
- Redirect RSS Feeds to external services (i.e., FeedBurner)
- ‘Pluggable’ page rendering code allowing replacement functions and custom code routines
- TinyMCE V3 with much improved text handling and formatting
- Optional Image File Uploading (only using TinyMCE editor)
- Improved Notification, Messaging and form validations
- EMail Overrides and create text of New User Email
- Democracy Polls plugin support
- Images as Thumbnails that expand
Continue Reading »
Popularity: 22% [?]
Share This
Join the forum discussion on this post - (1) Posts
Posted in Blogging etc, Wordpress | No Comments »
I needed a way to log the date and time the last time a user logged in I looked around for a plugin to do this for me, but found none, so I decided to try and write a function myself.
This one I struggled with and in the end it came out like something of a abomination of a function, but at least it gets the job done. It uses the WP_AUTHENTICATE hook to call the function where a simple login check is done, and if successful, the timestamp is writted to the wp_users table.
You can either insert a new field called user_lastlogin (or what you prefer) in wp_users like I did, or you can make a new table to store the login log.
The code follows below. Happy logging!
Continue Reading »
Popularity: 26% [?]
Share This
Join the forum discussion on this post - (1) Posts
Posted in Blogging etc, web development, Wordpress | No Comments »
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: 26% [?]
Share This
Posted in Scripting | No Comments »