free tool for QuickField simulation software, permanent magnet force 3D

This script calculates the force and torque acting between several axially magnetized cylinders, arbitrarily positioned in 3D space.

Calculation is based on the discretization of the prismatic surface by user-defined number of divisions, and numerical integration of the surface integrals using the formulas:
F = 0.5 ∫(H(B·n) + B(H·n) - n(H·B))ds T = 0.5 ∫([rxH](B·n) + [rxB](H·n) - [rxn](H·B))ds,
where F and T are vectors of the magnetic force and torque,
r and n are the radius vector and the normal vector to the surface element,
B and H are the flux density and strength vectors of the combined magnetic field.

Script allows to combine the field of up to 5 magnetized cylinders. Input parameters of the script are the fields marked yellow on the sheet UI of the Excel document. Output results are displayed in the fields marked blue on the same sheet.

The software is provided "as is" and the author disclaims all warranties with regard to this software including all implied warranties of merchantability and fitness. in no event shall the author be liable for any special, direct, indirect, or consequential damages or any damages whatsoever resulting from loss of use, data or profits, whether in an action of contract, negligence or other tortious action, arising out of or in connection with the use or performance of this software.