geometrical design and strength check of a prestressed bolt connection, loaded by static or cyclic loading resp., acting both in the axis of the bolt and in the plane of the connected parts. application is developed in ms excel, is multi-language and supports imperial and metric units. the application includes a table of commonly used materials according to iso, sae, din, bs, af astm and aisi. calculation support many 2d cad systems.