A Spreadsheet To Facilitate Group Theory Calculations and Display of Character Tables

Abstract

A Microsoft Excel workbook is described that can be used to perform group theory calculations using character tables for 50 chemically significant point groups. The workbook will reduce arbitrary representations, calculate direct products, and identify erroneous representations. In addition, the character tables can be projected for use in the classroom or copied to a word-processor for publication.

Flexibility in MOFs: do scalar and group-theoretical counting rules work?

“…We used spreadsheets developed by Niece 41 to speed up these routine tasks. The electronic supplementary information contains a step-by-step derivation for the pcb assembly.…”

A Master Class in Dimensional Analysis: the Universal Gas Constant

“…16,17 We use the ubiquitous Microsoft Excel spreadsheet program as an efficient method of organizing the large amount of data in a streamlined fashion. This program has been used in undergraduate instruction on various aspects of quantitative analysis [18][19][20][21][22][23][24][25] and a number of books have been written on its use as a computational tool in solving problems in the chemical sciences. [26][27][28][29] Surprisingly, however, no exercises are given on its possible use in fundamental dimensional analysis as described in this work.…”

Vector algebra and molecular symmetry: a tribute to Professor Josiah Willard Gibbs

“…In the second line, m gives the number of unmoved atoms related to the given symmetry operation. With the help of the character table of D 2d , we can decompose the reducible representation 3N into irreducible ones (irreps) [14]:…”

“…Symmetry is an important property of molecular shapes [12]. A great number of papers have dealt with the symmetry aspects of molecules in the chemical education literature [1,2,5,6,10,[14][15][16][17]20,21]. For the description of the static symmetry of rigid molecules, the point groups [4] as well as the framework groups [18] are used in chemical education.…”