Reading MCNP data into Excel (2002).

This figure is a frame from an animation showing a liquid carbon dioxide shield filling a cavity around a reactor. Unlike previous animations, this one used Excel instead of expensive graphics software. The MCNP data is read in from a "mctal" file generated by MCNP and then the data is plotted in Excel.
The figure above shows a simpler example of how to read and display MCNP data in Excel. The MCNP input file for this example is one that is created in the Visual Editor class. The input is run and a mctal file is generated. The mctal file is read in by Excel using the visual basic script shown here. This is done on sheet 1. Sheet2 (shown above) is used to manipulate the tally data read in on sheet1 and make a contour plot. To adapt this to your specific needs, you will need to modify the script to correspond to the type of tallies you ar using.