These programs calculate weight or volume norms for rocks from whole rock chemical analyses. The method is a modification of the original CIPW procedures. NORM4.xlsx is for one sample at a time: type in the analysis in the yellow field, weight and volume norms come out in the blue fields. NORM4.xlsm is a macro-enabled version: Enter multiple analyses on the second page, select volume or weight norm type, and press the start button (follow instructions). This version will do as many analyses as Excel has columns. It is slow. To speed it up, I disabled screen-writing, so nothing shows to the second page screen until all the analysis norms have been calculated. Try a small number of analyses first, to make sure it's working.

This was never published, it's a pretty standard procedure. I wrote the spreadsheets for my own use, and put them on the web, and here at the request of others.