Error in Magnetic Sensing Proximity Tool (slyr071a)

Hello Matthis,

Thank you for considering to use Texas Instruments. Looks like you found a limitation in our program.  When a colleague and I wrote it, we did not realize the vba would have issues with European notation.  That is definitely something that needs to be fixed. In the interim, to get the document working for you, I would suggest changing to the US format for your entries.  You should be able to do this by going to File>Options>Advanced then unchecking the Use system separators box and putting "." for what would normally be ",".  Also, it looks like there was an error relating to locking the workbook.  Therefore, I would proceed with the amended file I am uploading here.

MagneticSensingProximityTool_Rev2.xlsm

Hello Patrick,

thanks for your help. Your work around helps, but I get new errors. If I click on "Open Femm" in the dialog, which open on the button "Calculate", the tool says that an incorrect simulation was constructed: Material properties have nott been defined for all regions.

I can't change anything to solve it. Femm 4.2 will show further errors.

Maybe you can help me with this problem too.

Hey Matthis,

That is quite peculiar.  That might be yet again related to the notation.  Perhaps FEMM runs according to your system settings.  So if the excel uses US notation while femm uses the default for your computer which is the European notation, then maybe it takes issue with that.  Looks like I need to get this notation flexibility issue fixed sooner than later in the tool.  I think it might take me a while, so in the mean time, I will provide you with the field values for your stated conditions as well as the femm model it constructed.  For further iteration, you might try changing the default notation used on your computer, or you might just tinker with the generated femm model, or you could possibly send me a list of conditions you would like to sweep through.  In the mean time, I'm going to try to get this document so it works for your default notation.

https://e2e.ti.com/cfs-file/__key/communityserver-discussions-components-files/234/Matthis.femhttps://e2e.ti.com/cfs-file/__key/communityserver-discussions-components-files/234/Matthis.ans

Hello Matthis,

I got my code so that it should be compatible with your default number notation.  I think if the number formats are consistent between programs, then it should work.  Attached is my updated version.  Please let me know if you still run into further issues.

7658.MagneticSensingProximityTool_Rev2.xlsm

Hello Patrick,

I'm sorry but this solve not the problem. The error message is the same. Do you have another idea?

I think if it doesn't work, i have to learn to use the Femm tool ;-)

But I'm confident that you will find a solution.

Hello Matthis,

If you open up femm, what notation is used there?  Do the coordinate numbers in the bottom left corner display in the format 1,55 or 1.55?

Hello Patrick,

the format in Femm seem to be 1.55. I can't find settings for this.

Hello Matthis,

Thanks for that detail.  I will get back to when I figure out what the issue is.