Pages

Tuesday, April 3, 2007

Running, Gunning and Weighting for Averages

Scale balance It's true. Sometimes we really have no idea at all where our next tool is going to come from!



Take the tool the tool we're introducing today, which may be used to calculate weighted averages for rate calculations, such as finding a blended interest rate for a number of debts or investments, and which came about as we realized that we would need to refer to a tool like this for one of our upcoming projects.



The problem with that though is that calculating weighted averages is boring. Sure, we could lay out our standardized input data table and our standardized output result table and all would be well, except that you and we as users of the tool are now trapped into whatever number of numbers that we arbitrarily set for the tool.



Not only is that boring, it's wrong! So, we've opted for a run-and-gun approach. Start by entering the amount and corresponding rate for the numbers in which you're interested in the two lines below. When you click the "Calculate" button, your blended result reflecting the combined sum of your previous inputs, as well as the weighted average for the rate will appear in the first line.



From there, it's just a matter of entering data on the second line and repeating the process until you're completely done. No muss, no fuss, and best of all, no surplus or shortage of input data fields!
























Amount and Rate Data
Line Amount Rate (%)
1
2














Just be cautious in entering data - there's no back button! Plus, clicking the "Reset" button will reset all the initial values back to zero!

0 comments:

Post a Comment