Hi Jim I have managed to replicate the spreadsheet and am able to get the same results. However, I am not able to get the conditional formatting to work on my sheet. I am not sure why?
I'm not sure. When i get a minute of free time, i will attach a different conditional formatting formula that you can enter directly into the formula bar.
Here is an alternate way of doing it; place this formula =IF(AND(M8I3),"pass","fail") in the adjacent cell directly to the right of the "Percent of Deviation" cell (O9,O11.....). This is an IF argument that ensures the deviation is between the tolerance stated in the upper box of the form. This will serve the same purpose.
@@jimdiggins101 Thanks for your kind help. It is now sorted. The problem I had was I didn't change cell I3 to percentage and it caused all the issue. As soon as I changed it everything started working.
Jim thanks for putting this together. Unfortunately I have run into a small snag on the Dynamic Test formatting as my numbers don't quite match and I haven't been able to figure out why. My Peak to Peak =D30*2*(SQRT(2)) Measured Travel =F30/F2 Distance Deviation =H30-B30 ISF Deviation % =((F30/B30)-F2)/F2 If I enter in the Peak to Peak Travel of 5 and Measured Voltage of 0.3535 I get Peak to Peak Voltage 0.999848 , Measured Travel 4.99924 , Distance Dev -.00075 and ISF DEV % -0.02. These numbers are slightly off compared to your example and I haven't figured out why. Spent the last few hours but calling it a night and will try again tomorrow. This will be a great tool once I get it figured out.
Excellent this and the other videos, where it explains how to obtain the GAP, please, would you be so kind to provide me with your excel sheet where the test is recorded
Hi Jim I have managed to replicate the spreadsheet and am able to get the same results. However, I am not able to get the conditional formatting to work on my sheet. I am not sure why?
I'm not sure. When i get a minute of free time, i will attach a different conditional formatting formula that you can enter directly into the formula bar.
Here is an alternate way of doing it; place this formula =IF(AND(M8I3),"pass","fail") in the adjacent cell directly to the right of the "Percent of Deviation" cell (O9,O11.....). This is an IF argument that ensures the deviation is between the tolerance stated in the upper box of the form. This will serve the same purpose.
@@jimdiggins101 Thanks for your kind help. It is now sorted. The problem I had was I didn't change cell I3 to percentage and it caused all the issue. As soon as I changed it everything started working.
@@khurramhaseeb3655 Oh, that makes sense. I'm glad it worked out.
@@jimdiggins101 Thanks for your help, it is very much appreciated... Let's see what the team feels when they put it to test in a few days :)
did it thank you Mr jim
You betcha
Muchas gracias, excelente explicación
.
Excelente, ótima aula!
Jim, where do you get the values for Peak to Peak travel and Measured Value?
I posted videos explaining how to perform the dynamic and static tests.
Jim this looks great. could you please pass along the sheet? if not i will re-create it myself.
Sorry, I cannot distribute spreadsheets. If you run into any problems creating your own, I would be glad to help.
Jim thanks for putting this together. Unfortunately I have run into a small snag on the Dynamic Test formatting as my numbers don't quite match and I haven't been able to figure out why. My Peak to Peak =D30*2*(SQRT(2)) Measured Travel =F30/F2 Distance Deviation =H30-B30 ISF Deviation % =((F30/B30)-F2)/F2 If I enter in the Peak to Peak Travel of 5 and Measured Voltage of 0.3535 I get Peak to Peak Voltage 0.999848 , Measured Travel 4.99924 , Distance Dev -.00075 and ISF DEV % -0.02. These numbers are slightly off compared to your example and I haven't figured out why. Spent the last few hours but calling it a night and will try again tomorrow. This will be a great tool once I get it figured out.
I'm out of the office now. When I return I will take a look at it.
The number of decimal points that are configured in the cell formatting will produce a slight discrepancy. I bet this is what you are seeing.
Jim thanks for the reply. I will look at that first thing in the morning. Gotta hot job with a few Lucas Schaevitz lvdt's at the moment.
Excellent!
Thanks.
Hi jim diggins. Why is the voltage value according to the datasheet approximately negative -1 to -17vdc. But you take the positive value 1 to 17 vdc
Voltage is a potential difference and the polarity of the voltage has no bearing on the measurement. Use negative voltage if you like.
Thank you sir.
You are welcome.
Excellent!Can you provide excel sheet? Thank you very much
Hi...Mr Jim... thanks for this informative video...kindly could you provide spreadsheet for me...
Excellent this and the other videos, where it explains how to obtain the GAP, please, would you be so kind to provide me with your excel sheet where the test is recorded
Thank you. Do you want the spreadsheet from this video?
@@jimdiggins101 Yes sure, I would be very grateful
@@orlandoortizvillegas9450 Email?
Can you provide excel sheet? Thank you very much
Hey! Can you provide the spreadsheet!
PLEASE... Can you provide excel sheet? Thank you very much! +++
Hi Jim Can you provide excel sheet ?
Can you provide exell sheet formula
Your email id please send
Can you provide excel sheet? Thank you very much
Can you provide excel sheet.
Sure
Where should I send it?
@@jimdiggins101 Could you send to me? eder251095@gmail.com
Can you provide excel sheet? Thank you very much
Sure.