A Lattice Energy Spreadsheet

A Lattice Energy Spreadsheet is a tool that easily calculates lattice energies. It also illustrates the relation between crystal structure, coordination number, and ionic radii. A Lattice Energy Spreadsheet contains five related worksheets: Lattice Energy, MX Structure Map, Kapustinsky Lattice Energy, Directions, and Discussion, each described below. In the Lattice Energy worksheet, the lattice energy of many binary compounds can be calculated in about a dozen mouse clicks. An element is selected, and the radius corresponding to the desired charge and coordination number is selected. The same is done for the counter ion, and the anticipated crystal structure of the compound is chosen (rock salt, wurtzite, etc.). The lattice energy is then calculated. This sheet uses enthalpies of formation of monatomic gaseous atoms from the elements, ΔH°form, to calculate lattice energies. The results are more accurate than the values obtained by simply summing enthalpies of fusion and vaporization. The results of the corresponding Born-Haber cycle are also graphed on this sheet.
A Lattice Energy Spreadsheet   
(Software, Instructional Material (1))