• Go to the mass evaluation web site at https://www-nds.iaea.org/amdc/ and click on mass16.txt for the mass table, or more generally, the updated version of that file; catkin2.03 is being distributed with the 2016 mass evaluation from July 2019 onwards.
• Save this mass file as a text file on your disk
• Save a copy of the kinematics spreadsheet with its original mass table as a backup, in case of mistakes.
• In the copy of catkin that you are planning to update, select the worksheet mass_rmd.mas and unprotect it using
• Review>Unprotect sheet  or whatever your version of EXCEL requires, and the password masses as prompted at the top of the sheet
• Highlight the existing mass data in this sheet as follows:
• Highlight (select) the part-row A8:F8 in this sheet - note that this excludes column G
  
• With the "shift" key held down, double click on the bottom perimeter line of the highlighting - this should result in the whole mass table (columns a through F) being highlighted right to the bottom of the list
• Select (Edit > Clear > All) or equivalent to clear the contents of this whole area (gulp!)
• Get rid of the extra Z value added at the bottom by scrolling to the bottom of the list (or where it once was!) and then:
• Select the added Z cell (probably with a value 123), and delete its contents (hit backspace and tab)
• Go to the top of the sheet by pressing control-Home or otherwise
• Select cell A8
• Access the mass file that is stored on your disk by opening it in EXCEL:
• File > Open > mass16.txt (double click) ... or substitute the name of any more-recent mass file (Note that the filename may not appear on the list you are offered in EXCEL because EXCEL may be listing only the spreadsheet files and you have a text file - simply change the file type in the directory window to read "all files")
• A window will come up for the text import wizard - the next instructions are within this window...
  
• Scroll down so that you can see the first row of actual mass values, the neutron mass  (row 40, in the 2003 mass.mas03 file)
• In the same window, set "Start import at row:" to be equal to the appropriate value (40, in the 2003 mass.mas03 file)
• Ensure that "Fixed width" is selected, for defining the fields (columns) in the file
• Click "Next" on the import wizard window
• Click inside the data area, with single clicks immediately to the right hand side of  each digit in 0 1 1 0 1 in the neutron line and create vertical delimiter lines pointing upwards at these column values
• Click immediately to the right of the n in "space n" for the element column (this will also include both letters of He in the column)
• Click after the mass excess for the neutron including the decimals, to make another delimeter, for the mass excess column
• Click after the next number, which is the error in the mass excess
• Scroll down the file to be sure that there are no minus signs on the wrong sides of lines. You will find that there are some other data that appear between the columns for the element symbol and the mass excess - add another line to the right of these entries to make another column. Don't worry about the # symbol appearing in various places.
• Click "Next" again
• Column One will be highlighted. Select the button "Do not import column (skip)" for this column
• Select Column 2 (click once in the header of column 2 where it probably says "Gen" ) and scroll down in the data window until you can see "N-Z" which is just before the mass values start
• Select the button "Do not import column (skip)" for this column
• Leave the columns N, Z, A and EL as "General" - they will be imported. Set the column in between EL and the MASS EXCESS to be skipped, and also set any columns to the right of the error in the mass excess to be skipped. Remember to scroll sideways to check that any columns to the right are set as "skip".
  
• Click "Finish" and you will find a new spreadsheet with the imported data; there should be columns A through F
• Select the first row, columns A through F
• Hold "Shift" and double-click on the bottom of the selected regio to select all of the data in this new sheet
• Click on the copy icon, or select from the menu: Edit>Copy
• Click on the underscore in the SPREADSHEET (NOT the main EXCEL window) and you can shrink the new spreadsheet and see the original catkin spreadsheet again, showing the mass table with the big empty space where your masses used to be
• In the catkin masses sheet, the cell A8 should be selected
• Select the paste icon, or select from the menu: Edit>Paste to paste in all of the new data - hurrah, the masses are back!
• Select the cell B8, which is "0", being the atomic number for the neutron
• Double click on the bottom of the cell, to go to the bottom of the list or otherwise find a way to go to the bottom of the list e.g. ctl-End
  
• Add one more Z value Z that exceeds all genuine list values, at the bottom of the list in column B, to make the lookup procedure work for the last mass in the table, in case you are ever working with the heaviest nucleus in the table. The distributed list uses 123 for this Z.
  
• The last column of the spreadsheet (i.e. column G, labelled "mass excess to use") should have appeared automatically. All it does is strip the trailing # from the end of the unmeasured values. But if the new file has more masses, then column G will finish before the end of the mass list. In that case:
• scroll up/down to the last entry in column G that does have the mass value in it
• select the cell for the last value in column G
• double-click on the square at the bottom right of the cell, and it will auto-complete the column by copying the formula down the rest of the column until the end of column F, which is what we want
• By control-Home or otherwise, get to the top of the sheet
• Select cell D8 and change the contents from "n" to "nn" as the symbol for the neutron. This is necessary to distinguish it from Nitrogen in a case-insensitive manner.
• Note that the name of the mass sheet MUST stay as mass_rmd.mass for lookup functions in the calulator sheet to work.
• Save the EXCEL file by File>Save or SaveAs to produce your updated kinematics sheet.

The method formerly used for the AME 1995 table is shown here and is different because the file structure is different.
The other difference from previous versions of these instructions is due to the shift of the main mass website
from Orsay to the Brookhaven NNDC site and then we now link to the IAEA mirror of the new Chinese site.

Wilton Catford    17 July 2019