How do I use the “Average Prime Offer Rates” Table using the ASCII comma delimited text file format?
• Microsoft Excel • The ASCII comma delimited text file format allows the “Average Prime Offer Rates” tables to be easily retrieved into a variety of applications, but is best viewed within one that will allow the user to easily manipulate data that is in columnar format. Microsoft Excel is an example of such an application. If you have Microsoft Excel installed on your computer, the “Average Prime Offer Rates” tables will open in Microsoft Excel by default. • Column ‘A’ represents the ‘Effective Date’. Columns ‘B’ through ‘AY’ represent the loan term. • To find the applicable rate, identify the relevant date (the effective dates listed correspond to the Monday after posting and are effective until the next posting takes effect) in the left-hand column, Column ‘A’, and navigate across the row until the rate corresponding to the term of the loan has been reached. Loan terms are arrayed across the top, in Columns ‘B’ through ‘AY’. • Text-Editing/ Word-Processing Application • If you don’
