Download - Tools


In this area some small tools and and useful software can be found, developed by us or our clients.

Following tools are available (please click on the corresponding title to get a more detailed instruction):

Surface calculations for anodizing

Many thanks to Mr. Ing. Rudolf Berger for providing this sheet. His instruction can also be found directly in the sheet on table „Brief instruction“. The sheet also works under OpenOffice/LibreOffice.

The table on sheet "Surfaces" should help to calculate the complete surface to be anodized.

Nearly all work pieces can be divided into rectangular or circular shaped parts - at least approximately.

The dimensions of the determined part surfaces are inserted as basic shapes.

Through holes, blind holes, long holes, grooves, breakthroughs and pockets are inserted into the corresponding marked fields. If there are negative values here, this is not a mistake! Long holes and grooves are always calculated with semicircular ends. The length of a long hole or a groove is the physical one e.g. measured by a slide. Breakthroughs and pockets are considered rectangular, without corner radii. This is because the calculation without corner radius is much easier and the error occurring compared to the total surface is negligible.

The last two input options sustracts individual, adjacent surfaces from the total result. These correction is necessary, for example, if the surface of a round rod, which has a milled square end, has to be calculated correctly. The basic shapes, namely the round bar and the square, are filled with their dimensions. Therefore all the outer surfaces of the two bodies have to be determined. The concealed boundary surface, common to both shapes, must be substracted. In the example given, this is the cross-section of the square. The correction fields give negative values, thus reducing the area. So no negative input is required!

As the result the total surface and the needed current for decorative anodizing at standard conditions is shown.

If this table does not always find exact values, however - with some skill when dividing into basic forms - a good to very good approximation can be achieved. For completely exotic forms your creativity may be required!

Please click on the desired file to download it:

FileDescriptionFile sizeLast modified
Download this file (Surfaces.xlsx)Surfaces.xlsxExcel sheet for calculation of complex work pieces for anodizing17 kB2016-12-13