to your HTML Add class="sortable" to any table you'd like to make sortable Click on the headers to sort Thanks to many, many people for contributions and suggestions. Licenced as X11: http://www.kryogenix.org/code/browser/licence.html This basically means: do what you want with it. */ var stIsIE = /*@cc_on!@*/false; sorttable = { init: function() { // quit if this function has already been called if (arguments.callee.done) return; // flag this function so we don't do the same thing twice arguments.callee.done = true; // kill the timer if (_timer) clearInterval(_timer); if (!document.createElement || !document.getElementsByTagName) return; sorttable.DATE_RE = /^(\d\d?)[\/\.-](\d\d?)[\/\.-]((\d\d)?\d\d)$/; forEach(document.getElementsByTagName('table'), function(table) { if (table.className.search(/\bsortable\b/) != -1) { sorttable.makeSortable(table); } }); }, makeSortable: function(table) { if (table.getElementsByTagName('thead').length == 0) { // table doesn't have a tHead. Since it should have, create one and // put the first table row in it. the = document.createElement('thead'); the.appendChild(table.rows[0]); table.insertBefore(the,table.firstChild); } // Safari doesn't support table.tHead, sigh if (table.tHead == null) table.tHead = table.getElementsByTagName('thead')[0]; if (table.tHead.rows.length != 1) return; // can't cope with two header rows // Sorttable v1 put rows with a class of "sortbottom" at the bottom (as // "total" rows, for example). This is B&R, since what you're supposed // to do is put them in a tfoot. So, if there are sortbottom rows, // for backwards compatibility, move them to tfoot (creating it if needed). sortbottomrows = []; for (var i=0; i
What is the total percentage change between an old figure and a new one? And for that matter, what is the average rate of change over the time between when the old and new values were recorded?
These are questions that we answer all the time, so we were somewhat gobsmacked to realize that we had never gotten around to posting a tool that anyone can use to answer the same questions for themselves. So, we're getting around to it today!
The data you'll need to enter in the tool below is really straightforward: you just need to enter an older (or starting) value, a newer (or ending) value, and enter the amount of time that elapsed between when these figures were noted. Our tool will find the total percentage change between the older and newer values and will also find the compound annual growth rate (CAGR) that corresponds with the time interval and values that you enter.
That's it! Here's the tool:
In the calculations for the tool above, the total elapsed time is found by adding each of the entries for elapsed years, months and days. We figure that feature makes this particular tool slightly easier to use with time periods you're much more likely to know than what some similar tools that you might find elsewhere on the web require.
Looking at what we do, we find we do this kind of math all the time for all kinds of things, such as finding out how big an increase in a budget line item, taxes, GDP, investment value or other personal finance stuff is compared a previous level or to find out what the annualized rate of change in a value between two points in time might be.
Like we said at the beginning - we were surprised to find we hadn't done it already!
Labels: tool
Welcome to the blogosphere's toolchest! Here, unlike other blogs dedicated to analyzing current events, we create easy-to-use, simple tools to do the math related to them so you can get in on the action too! If you would like to learn more about these tools, or if you would like to contribute ideas to develop for this blog, please e-mail us at:
ironman at politicalcalculations
Thanks in advance!
Closing values for previous trading day.
This site is primarily powered by:
The tools on this site are built using JavaScript. If you would like to learn more, one of the best free resources on the web is available at W3Schools.com.