This thread has been locked.

If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.

DRV5056: DRV5056 Distance Measurement Tool

Part Number: DRV5056
Other Parts Discussed in Thread: DRV5055

Hi all,

i used DRV5056 Distance Measurement Tool (sbac231.xls) but i does not work with rectangular magnet input data.

Futhermore, Excel indicates that the file is corrupted when opened it.

I have the pb with to different computer ...

Could you please confirm the issue ?

Best regards.

  • Remy,

    Thank you for reaching out and letting us know you are having trouble with the tool.  We'd like to get it up and running for you.  I am able to use the tool without issue.  Can you confirm your input values? If using a block shaped magnet, please be sure to add a length, L, or else the tool will be unable to perform the calculation for the field.  Here's an example screen capture that resulted from some random inputs.

    There are no macros running in the background on this tool.  All calculations are performed via a lookup table into hidden cells using standard excel formulas.  I would recommend that you redownload the tool and double check for the corrupt file issue.  I do not see this error when I download and open it via the link you provided. 

    Can you also confirm the version of excel which you are using?

    thank you,

    Scott Bryson

  • Hi Scott,

    thank you for your reply.

    Here is a screenshot. When i select BLOCK, #NAME? appears ...

    I use EXCEL 2019 on a computer and 2016 on an other.

  • Remy,

    I am using Excel 2019 as well, and so I wouldn't expect any compatibility issues. 

    I'm afraid the screenshot you added did not post correctly and I cannot see your image.  Please be sure to use the attach image icon above the text editor.

    Thanks,

    Scott

  • Hi Scott,

    we are right, sorry fo that,

    Here is again. Note that the spreadsheet is working well with cylinder magnet.

  • Remy,

    I'm curious whether or not the language settings in your operating system or within Office are causing a conflict here.  I do believe that the standard variable separation in excel formulas are ',' for English and ';' for French.  I attempted to switch my settings as far as I was able while still being able to use my machine and the tool still appeared functional.  It looked like Excel had automatically changed the commas to semicolon on my machine. 

    While trying to recreate the problem, the only way I was able to get a NAME error in the last four rows was to intentionally corrupt the variable name association to the first two input rows.  B(0.1 mm) and VOUT(0.1 mm) are using the VLOOKUP function find a calculated row matching the value tied to the cell with name "d1MIN"  at B4, and B(49.501mm) and VOUT(49.501mm) are doing the same while looking for the value matching "d2MAX" at B5.

    In Excel2019 you should be able to locate variables by name using the drop down to the left of the formula bar.

    If you select any of these variable names, it should jump to and select the associated cells.  Please make sure that the "d1MIN" and "d2MAX" variables correctly jump to B4 and B5. You should also be able to select the variable  "Br" to check that the syntax of the equation matches your system language requirements.

    So far, however, when attempting to use the tool as intended, I have not been able to recreate this NAME error.  It does appear to operate normally.  

    As an alternative to changing all of your system settings to English, you might consider using the field calculator located on the device product page for DRV5055 which is a sister device to this one.

    https://www.ti.com/product/DRV5055

    It is slightly more cumbersome to use since this tool does not generate the output plot for you automatically, but you should be able to estimate the field at specific locations.  With this information you can calculate the output based on your selected device sensitivity.  You will want to be sure to consider the BL min value listed in the datasheet to ensure you stay within the linear output range of the device.

    Thanks,

    Scott

  • Hi Scott,

    thank you for your feedback.

    I checked every step you detailed but unfortunately i do not manage to success.

    I used the other tool you mentionned for DRV5055 and simulate different shape to equal same magnet field at a defined distance.

    Best regards.

  • Remy,

    I'm sorry that you weren't able to get the tool working on your machine.  The NAME error occurs when the cell names are not valid.  If the names are correctly linked to the cells mentioned above, then it should be able run the VLOOKUP function and generate the needed calculations.

    It sounds like you were able to calculate the fields using the other tool.  Please let us know if you need any further support.

    Thanks,

    Scott