Search form

Content: 

TimeValue Software Blog

Pasting Excel into TValue 6

By Martel Pellerin

How many times have you had a detailed schedule in Excel and wanted to copy it into TValue instead of inputting it line by line? With TValue 6, pasting lines from Excel into the cash flow matrix can be easy with this advanced feature.

The key is to have the Excel schedule in the same format as TValue. This means Excel needs to match the order of TValue’s cash flow matrix: Event | Date | Amount | Number | Period | End Date | Memo. At a minimum, which is what most people need, the first column in Excel needs to be the Event name, the second column the Date, and the third column the Amount. Then you can copy the cells in Excel, go to TValue 6, put the mouse on the first cell you want to paste into, and then click the Paste icon on the left-hand side of the Ribbon. If you have a Rate Change, Loan Details, and/or Special Series, additional columns may be needed.

If you have check numbers or notes for the individual payment items, you can copy and paste them from Excel into the Memo column. You will need to check the number of Events, but these notes may go in column G in Excel. If you want to know how to layout Excel, I have two recommendations. First, is build a schedule in TValue 6 and copy and paste it into Excel and you will see what information goes into what columns.

Second, see the examples in the TValue 6 Help menu: use F1, go to Index, and then type in Excel: Pasting from Excel. You will see the various combinations of Events, Special Series, Period, etc. Once again, the key is having the columns in the right order in Excel with an Event in the first cell of each row. You will need to copy all of them at one time to get them into TValue 6.

This is an excellent feature that is offered in TValue 6 and should save you substantial time getting the benefits of TValue.

Archive