70.2K
Verified Solution
Link Copied!
plot the load and unload vs applied hysteresis graph for both the tables. so you should have 2 graphs for table 1. one graph for mV vs mass, and the other for kg vs mass. the upscale and downscale will allow us to discuss the hysteresis so that's why each graph needs to include both load and unload. likewise for table 2, each graph should have both upscale and downscale, table 2 you need to plot the master vs calibration (ALL GRAPHS NEED TO BE PLOTTED IN EXCEL)
Table 1. Load cell calibration results Mass (kg) Unload (kg) 0.015 0.115 0.21 0.31 0.41 0.505 0.605 0.7 0.8 0.9 1.01 1.11 1.21 1.305 1.405 1.5 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 25 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4 4.1 42 Output load (kg) 0 0.1 0.193 0.295 0.395 0.49 0.59 0.69 0.785 0.885 0.985 1.095 1.195 1.295 1.39 1.49 1.59 1.685 1.785 1.88 1.98 2.095 2.19 2.29 2.39 2.485 2.585 2.685 2.78 2.88 2.98 3.095 3.19 3.29 3.39 3.485 3.585 3.685 3.78 3.88 3.98 4.095 4.195 Load (in V) 0.403 0.449 0.494 0.54 0.585 0.632 0.678 0.723 0.768 0.814 0.861 0.91 0.96 1.003 1.051 1.096 1.143 1.188 1.234 1.28 1.326 1.379 1.421 1.47 1.514 1.56 1.607 1.653 1.698 1.743 1.788 1.843 1.886 1.934 1.976 2.027 2.067 2.117 2.164 2.208 2.256 2.31 2.357 1.6 1.7 1.795 1.895 2.005 2.105 2.2 2.3 2.4 2.495 2.595 2.69 2.79 2.885 3 3.1 3.2 3.295 3.39 3.49 3.59 3.685 3.785 3.885 4 4.1 4.2 Unload (IV) 0.403 0.448 0.495 0.541 0.587 0.632 0.676 0.724 0.77 0.815 0.869 0.913 0.96 1.006 1.05 1.097 1.141 1.189 1.234 1.28 1.339 1.376 1.424 1.469 1.515 1.561 1.606 1.649 1.696 1.743 1.791 1.843 1.889 1.935 1.978 2.024 2.072 2.118 2.161 2.21 2.261 2.311 2.353 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5 4.29 4.39 4.485 4.585 4.685 4.785 4.88 4.98 2.398 2.446 2.493 2.538 2.584 2.624 2.676 2.718 4.295 4.395 4.49 4.59 4.69 4.785 4.88 4.98 2.399 2.448 2.491 2.539 2.581 2.631 2.673 2.718 Table 2. Pressure Gauge calibration results Master/small gauge Pressure (Psi) Calibration/big gauge Pressure (Psi) Upscale Downscale Upscale Downscale 0 20 1 19.8 5 15 4.7 15 10 10 10.3 10.1 15 5 15 5 20 0 19.8 1 Table 1. Load cell calibration results Mass (kg) Unload (kg) 0.015 0.115 0.21 0.31 0.41 0.505 0.605 0.7 0.8 0.9 1.01 1.11 1.21 1.305 1.405 1.5 0 0.1 0.2 0.3 0.4 0.5 0.6 0.7 0.8 0.9 1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 25 2.6 2.7 2.8 2.9 3 3.1 3.2 3.3 3.4 3.5 3.6 3.7 3.8 3.9 4 4 4.1 42 Output load (kg) 0 0.1 0.193 0.295 0.395 0.49 0.59 0.69 0.785 0.885 0.985 1.095 1.195 1.295 1.39 1.49 1.59 1.685 1.785 1.88 1.98 2.095 2.19 2.29 2.39 2.485 2.585 2.685 2.78 2.88 2.98 3.095 3.19 3.29 3.39 3.485 3.585 3.685 3.78 3.88 3.98 4.095 4.195 Load (in V) 0.403 0.449 0.494 0.54 0.585 0.632 0.678 0.723 0.768 0.814 0.861 0.91 0.96 1.003 1.051 1.096 1.143 1.188 1.234 1.28 1.326 1.379 1.421 1.47 1.514 1.56 1.607 1.653 1.698 1.743 1.788 1.843 1.886 1.934 1.976 2.027 2.067 2.117 2.164 2.208 2.256 2.31 2.357 1.6 1.7 1.795 1.895 2.005 2.105 2.2 2.3 2.4 2.495 2.595 2.69 2.79 2.885 3 3.1 3.2 3.295 3.39 3.49 3.59 3.685 3.785 3.885 4 4.1 4.2 Unload (IV) 0.403 0.448 0.495 0.541 0.587 0.632 0.676 0.724 0.77 0.815 0.869 0.913 0.96 1.006 1.05 1.097 1.141 1.189 1.234 1.28 1.339 1.376 1.424 1.469 1.515 1.561 1.606 1.649 1.696 1.743 1.791 1.843 1.889 1.935 1.978 2.024 2.072 2.118 2.161 2.21 2.261 2.311 2.353 4.3 4.4 4.5 4.6 4.7 4.8 4.9 5 4.29 4.39 4.485 4.585 4.685 4.785 4.88 4.98 2.398 2.446 2.493 2.538 2.584 2.624 2.676 2.718 4.295 4.395 4.49 4.59 4.69 4.785 4.88 4.98 2.399 2.448 2.491 2.539 2.581 2.631 2.673 2.718 Table 2. Pressure Gauge calibration results Master/small gauge Pressure (Psi) Calibration/big gauge Pressure (Psi) Upscale Downscale Upscale Downscale 0 20 1 19.8 5 15 4.7 15 10 10 10.3 10.1 15 5 15 5 20 0 19.8 1
Answer & Explanation
Solved by verified expert