These following macros are provided by the Federal Reserve Bank of St. Louis so that users can generate their own triangle tables to show compounded annual rates of change. Although, the tables are similar to those used in mileage charts on road maps, these tables represent growth rates over various periods.
These macros are offered "as-is" as a convenience for visitors to this site for informational purposes only and are intended to be used in conjunction with a validly licensed copy of Lotus 1-2-3® or Microsoft Excel®. THE FEDERAL RESERVE BANK OF ST. LOUIS MAKES NO WARRANTY, EXPRESS OR IMPLIED, AS TO RESULTS TO BE OBTAINED FROM USE OF THESE MACROS, AND MAKES NO EXPRESSED OR IMPLIED WARRANTY OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OR USE. The Federal Reserve Bank of St. Louis shall have no liability for the accuracy or proper functioning of these macros, or for any loss, injury, or damage incurred, directly or indirectly, as a consequence of their use. Lotus 1-2-3 is a registered trademark of Lotus Development Corporation. Microsoft Excel is a registered trademark of Microsoft Corporation. Use of the Lotus 1-2-3 or Microsoft Excel name or offering these macros in this format does not constitute an official endorsement or approval by the Federal Reserve Bank of St. Louis of that product to the exclusion of others that may be suitable.
- Growth rate macro for Excel, Version 5.0 (76KB)
- Growth rate macro for Lotus 1-2-3, Version 4 (240KB)
- Growth rate macro for Lotus 1-2-3, DOS version (39KB)