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?
@jimdiggins101
3 жыл бұрын
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.
@jimdiggins101
3 жыл бұрын
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.
@khurramhaseeb3655
3 жыл бұрын
@@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.
@jimdiggins101
3 жыл бұрын
@@khurramhaseeb3655 Oh, that makes sense. I'm glad it worked out.
@khurramhaseeb3655
3 жыл бұрын
@@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 :)
@harounemoussa2453
24 күн бұрын
did it thank you Mr jim
@jimdiggins101
23 күн бұрын
You betcha
@dayvsonevangelista1977
2 жыл бұрын
Excelente, ótima aula!
@fajarrajendra9613
3 жыл бұрын
Thank you sir.
@jimdiggins101
3 жыл бұрын
You are welcome.
@dickeyspaz3222
2 жыл бұрын
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.
@jimdiggins101
2 жыл бұрын
I'm out of the office now. When I return I will take a look at it.
@jimdiggins101
2 жыл бұрын
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.
@dickeyspaz3222
2 жыл бұрын
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.
@vurainy
2 жыл бұрын
Excellent!
@jimdiggins101
2 жыл бұрын
Thanks.
@wapeekung
9 ай бұрын
Can you provide excel sheet? Thank you very much
@liranhefetz5527
5 ай бұрын
PLEASE... Can you provide excel sheet? Thank you very much! +++
@millwright7564
2 жыл бұрын
Jim this looks great. could you please pass along the sheet? if not i will re-create it myself.
@jimdiggins101
2 жыл бұрын
Sorry, I cannot distribute spreadsheets. If you run into any problems creating your own, I would be glad to help.
@ranjitkar2381
Жыл бұрын
Hi...Mr Jim... thanks for this informative video...kindly could you provide spreadsheet for me...
@hovanuc187
Жыл бұрын
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
@jimdiggins101
Жыл бұрын
Voltage is a potential difference and the polarity of the voltage has no bearing on the measurement. Use negative voltage if you like.
@andinstrumentcontrol4159
Жыл бұрын
Excellent!Can you provide excel sheet? Thank you very much
@arturogonzalez2220
Жыл бұрын
Jim, where do you get the values for Peak to Peak travel and Measured Value?
@jimdiggins101
Жыл бұрын
I posted videos explaining how to perform the dynamic and static tests.
@toddwillis7206
3 жыл бұрын
Hey! Can you provide the spreadsheet!
@orlandoortizvillegas9450
3 жыл бұрын
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
@jimdiggins101
3 жыл бұрын
Thank you. Do you want the spreadsheet from this video?
@orlandoortizvillegas9450
3 жыл бұрын
@@jimdiggins101 Yes sure, I would be very grateful
@jimdiggins101
3 жыл бұрын
@@orlandoortizvillegas9450 Email?
@kadirkucuk35
Жыл бұрын
Hi Jim Can you provide excel sheet ?
@dipakbhalodia7155
5 ай бұрын
Can you provide exell sheet formula
@dipakbhalodia7155
5 ай бұрын
Your email id please send
@josepatino7142
11 ай бұрын
Can you provide excel sheet? Thank you very much
@alpha7701
3 жыл бұрын
Can you provide excel sheet.
@jimdiggins101
3 жыл бұрын
Sure
@jimdiggins101
3 жыл бұрын
Where should I send it?
@ederlopes4208
3 жыл бұрын
@@jimdiggins101 Could you send to me? eder251095@gmail.com
Пікірлер: 47