Hello everyone. There is a little project I could use some help with. I would like this done in a spreadsheet, so I can mess around with different values. The Problem: On one hand, I have a permanent magnet and, on the other, I have a ferromagnetic object. I want to find out the force the magnet is exerting on my object from any given distance. If I’m not mistaken, one of the bigger issues here is the shape of the magnet, because that can affect flux density. Let’s work with a nice, generic shape. The values I’d like to play around with are: the grade of the magnet the size of the magnet the composition of the ferromagnetic object the size of the ferromagnetic object the distance between the two I want to keep it simple. I don’t need the spreadsheet to have all the information stored on all neodymium magnets from N27 to N64. It should just tell me the different inputs it needs, and I’d be more than happy to look them up. The same goes for the ferromagnetic object. Thanks in advance.