user tips

system requirements

product updates

back to index

Say you want to compare results from several RRIFmetic runs graphically and RRIFmetic's graphs just won't do.

Now, you could go the full "export the result grid to Excel" route, but there is a quicker and easier way..... and you don't have to be an Excel pro. It involves quickly grabbing and copying the various single column results from the RRIFmetic results grid and pasting them one at a time into columns in Excel (or the Works spreadsheet... or)

Heres how.... First of all, you should get RRIFmetic and your spreadsheet both running. Next, run a RRIFmetic calc(amortize/smooth) with the results grid in front of you.

Now, find the first column of results which you want to move into the spreadsheet. Now, here's the trick.... Click on the second cell in that column (the 3rd if you count the header row). A message will pop up to the effect that "you have captured column xx in the windows clipboard."

Next move to your Excel (or whatever) spreadsheet and click on an arbitrary top cell.

In Excel, bring down the 'edit' menu and paste..... ta-da! The single result column copies down the column in the spreadsheet.

Repeat this, going back to RRIFmetic, recalcing (either for this file or another) and repeating. (ok, this is tedious, but once you get the hang of it, it will go real fast)

Now you have an Excel spreadsheet with 1 or several columns of data extracted from a RRIFmetic study. This could be one client and several runs, or it could be several clients (a divorce mediation, say).

Now you are on your own. Creating graphs from 1 or more columns of raw data is one of the most basic spreadsheet intro exercizes imaginable. Every spreadsheet will have a simple 'graph wizard' to walk you through creating the graphs, titling, colors... etc. Or get your high schooler to help you.

You won't have to enrol in an "Introduction to Excel" course at your local community college. Trust me.

BTW, you may have to create the years (age) down the column using "fill series" in Excel. Not hard to do.

back to index