Home
Answered Questions
Advanced Physics
Can Someone Provide Steps For How I Would Take My Lab Data And Put It Into The Same Table Formatting

Can someone provide steps for how I would take my lab data and put it into the same table formatting as the examples in the question? I need to make 3 graphs each with secondary y-axis. I have no idea how to use excel.

1. Using EXCEL, construct three neat graphs showing speed, amp, power factor, and efficiency vs. output load in hp (below graphs). DO NOT PLOT LOCKED ROTOR VALUES. Be sure you select x-y type graph so horizontal scale is linear. Do not select the line type graph. Horizontal points should be equally spaced. Connect points with line. DO NOT FIT A LEAST SQUARES CURVE. Face the graph out (which means the horizontal scale is on the right as you view the page as a portrait) in your report for easy viewing. Draw and label a line showing the full-load horsepower on each graph. On the speed graph, draw and label a line showing the nameplate full-load speed. On the amps graph, draw and label a line showing the nameplate full-load current. Use above graphs as examples of what expected. 3-Phase Motor 3-Phase Motor 3-Phase Motor 1.00 250 100.00 0.90 90.00 0.80 80.00 70.00 (9.4) (peon) anbjol % 50.00 % Slip % Torque (Load) (ft*lb) Current (A) Efficiency Power Factor 40.00 30.00 20.00 0.20 10.00 0.10 0% 10% 20% 30% 70% 0.00 100% 40% 50% 60% % Speed RPM) 80% 90% Slip 1%) 0% 20% 80% Current (Amps) 100% 40% 60% % Speed /RPM) 50 100 150 % Torque (Load) ft*lb) 0.00 200 250 Power Factor (ratio) Torgyhon
Nameplate hp, decimal Nameplate r/min Wattmeter multiplier Motor test data Load %FL Load cell force (lb) Wattage (W) (no multiplier) Amps (A) 1.3 Speed (RPM) 1790 1725 1766 1755 1725 1715 1680 1640 1575 Volts (V) 0.42 0.45 0.35 0.28 0.725 1.45 2.175 2.9 3.625 4.35 5.075 5.8 11 0.3 0.16 0.48 0.3 0.12 0.19 200 Lock rot 25 32.5 Synchronous speed (RPM) = 1725 Load cell force (lb) Input Power Torque (XFL) Slip O Speed (RPM) 1790 1725 1766 1755 125 175 v 275 N 1725 Output Power Efficiency (hp) 0.00 0.00 0.13 53.29 0.26 69.43 87.57 0.50 74.60 0.62 74.17 0.73 70.31 0.83 55.16 0.91 30.27 0.00 0.00 Power Factor (ratio) 228.94 176.77 314.29 374.42 406.50 723.38 248.40 535.71 750.00 607.29 -3.77 0.00 -2.38 -1.74 0.00 0.58 2.61 4.93 8.70 100.00 325 500 625 775 1125 2250 3750 1715 o w 175 1680 1640 1575 Lock rotor - 5.8 200 210 11.0