I have beein using all kinds of strange constructs to be able to select a random row (often user or post) from table, and then I stubled over this on sitepoint forums:
SELECT * FROM users WHERE age > 20 ORDER BY RAND() LIMIT1
One simple argument to the query! Awsome. Hope it helps you as much as it helped me.
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 downloadable example.
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.
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)
