The New menu is the best way to create a new Excel workbook ready to work with Lertap.  It's not the only way, but it's the best.  Why?  Because it results in an Excel workbook set up to display Lertap's preferred fonts, and a workbook with the two core Lertap worksheets, Data and CCs.


To find out what the New menu's options do, click on the options in this little snapshot:


The tab's New menu.


It is possible to create a Lertap workbook without using the New menu options.  All that's required by Lertap is an Excel workbook with data records in a worksheet named Data, and control lines (or "cards") in a worksheet named CCs.


If you presently have an Excel workbook with data records in it, you can try to rename the worksheet with the data records to Data, and insert a new worksheet with a name of CCs.  That will work.  However, font problems may develop when Lertap's Run menu options are taken -- Lertap's reports, such as that seen in the Stats1f worksheet, may turn out to be poorly formatted.


If this happens, a suggestion is to use the New menu to "Make a new blank Lertap 5 workbook" (the Blank option).  Then, from the original workbook, copy all data records to the blank workbook's Data worksheet.


Click here for a definition of a Lertap workbook.


The New Menu is discussed in Chapter 3 of the manual, under the section titled "Setting up a new workbook".  (Note: the examples in the manual are all based on older versions of Excel, prior to Excel 2007 and later.)


In the printed manual, the reference is page 60.