Problem 1: Power is calculated as negative for one of the power analyzer - it is due to low crest factor setting and power factor being low. In this case, the reported power is wrong and it is not correct to take its absolute value and do the summation.
Problem 2: Instead of "-1" for the aggregated current, voltage and pf values, can we use "N/A" as "-1" is used for invalid readings?
Time,11-28-2024 14:30:28.612,Watts,606.412000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:28.612,Watts,-11.112000,Volts,243.470000,Amps,-3.081500,PF,0.408900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:28.355,Watts,595.300000,Volts,242.780000,Amps,2.518100,PF,0.973800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:29.622,Watts,643.639000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:29.622,Watts,-11.039000,Volts,243.430000,Amps,-3.081130,PF,0.407100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:29.355,Watts,632.600000,Volts,242.720000,Amps,2.681900,PF,0.971800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:30.622,Watts,682.164000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:30.622,Watts,-11.064000,Volts,243.420000,Amps,-3.080940,PF,0.409300,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:30.364,Watts,671.100000,Volts,242.670000,Amps,2.851500,PF,0.969900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:31.622,Watts,755.054000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:31.622,Watts,-11.054000,Volts,243.250000,Amps,-3.080880,PF,0.409400,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:31.365,Watts,744.000000,Volts,242.420000,Amps,3.138200,PF,0.978000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:32.622,Watts,740.083000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:32.622,Watts,-11.083000,Volts,243.350000,Amps,-3.080950,PF,0.410300,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:32.355,Watts,729.000000,Volts,242.510000,Amps,3.083500,PF,0.974900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:33.632,Watts,769.698000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:33.632,Watts,-11.098000,Volts,243.320000,Amps,-3.081160,PF,0.410100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:33.365,Watts,758.600000,Volts,242.470000,Amps,3.193900,PF,0.979500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:34.632,Watts,755.717000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:34.632,Watts,-11.117000,Volts,244.000000,Amps,-3.081040,PF,0.410500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:34.375,Watts,744.600000,Volts,243.190000,Amps,3.135800,PF,0.976400,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:35.632,Watts,753.159000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:35.632,Watts,-11.059000,Volts,244.770000,Amps,-3.080300,PF,0.410000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:35.365,Watts,742.100000,Volts,243.940000,Amps,3.114000,PF,0.976900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:36.622,Watts,770.804000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:36.622,Watts,-11.104000,Volts,244.770000,Amps,-3.081190,PF,0.407800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:36.354,Watts,759.700000,Volts,243.920000,Amps,3.179700,PF,0.979600,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:37.622,Watts,780.482000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:37.622,Watts,-11.082000,Volts,244.770000,Amps,-3.080810,PF,0.408600,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:37.365,Watts,769.400000,Volts,243.910000,Amps,3.216500,PF,0.980700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:38.632,Watts,765.867000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:38.632,Watts,-11.067000,Volts,244.740000,Amps,-3.080700,PF,0.408500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:38.375,Watts,754.800000,Volts,243.900000,Amps,3.163500,PF,0.978300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:39.622,Watts,782.686000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:39.622,Watts,-11.086000,Volts,244.720000,Amps,-3.080990,PF,0.408000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:39.355,Watts,771.600000,Volts,243.860000,Amps,3.227000,PF,0.980500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:40.622,Watts,769.779000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:40.622,Watts,-11.079000,Volts,244.660000,Amps,-3.080940,PF,0.407900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:40.355,Watts,758.700000,Volts,243.820000,Amps,3.177000,PF,0.979500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:41.622,Watts,746.589000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:41.622,Watts,-11.089000,Volts,244.660000,Amps,-3.080630,PF,0.410100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:41.355,Watts,735.500000,Volts,243.840000,Amps,3.089300,PF,0.976400,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:42.622,Watts,754.862000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:42.622,Watts,-11.062000,Volts,244.710000,Amps,-3.080360,PF,0.409900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:42.364,Watts,743.800000,Volts,243.880000,Amps,3.124300,PF,0.976200,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:43.632,Watts,780.874000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:43.632,Watts,-11.074000,Volts,244.710000,Amps,-3.080720,PF,0.408700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:43.375,Watts,769.800000,Volts,243.850000,Amps,3.221400,PF,0.979900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:44.622,Watts,748.595000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:44.622,Watts,-11.095000,Volts,244.800000,Amps,-3.080500,PF,0.410800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:44.354,Watts,737.500000,Volts,243.980000,Amps,3.093800,PF,0.977000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:45.632,Watts,767.615000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:45.632,Watts,-11.115000,Volts,244.820000,Amps,-3.080490,PF,0.411800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:45.375,Watts,756.500000,Volts,243.980000,Amps,3.168800,PF,0.978500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:46.622,Watts,771.301000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:46.622,Watts,-11.101000,Volts,244.750000,Amps,-3.080750,PF,0.409900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:46.364,Watts,760.200000,Volts,243.910000,Amps,3.181500,PF,0.979600,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:47.621,Watts,766.070000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:47.621,Watts,-11.070000,Volts,244.770000,Amps,-3.080220,PF,0.411000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:47.354,Watts,755.000000,Volts,243.930000,Amps,3.164900,PF,0.977900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:48.622,Watts,776.995000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:48.622,Watts,-11.095000,Volts,244.840000,Amps,-3.080580,PF,0.410300,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:48.354,Watts,765.900000,Volts,243.990000,Amps,3.201000,PF,0.980700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:49.622,Watts,781.971000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:49.622,Watts,-11.071000,Volts,244.970000,Amps,-3.080360,PF,0.410000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:49.355,Watts,770.900000,Volts,244.110000,Amps,3.217100,PF,0.981600,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:50.631,Watts,760.758000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:50.631,Watts,-11.158000,Volts,246.110000,Amps,-3.080690,PF,0.410800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:50.364,Watts,749.600000,Volts,245.310000,Amps,3.123000,PF,0.978500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:51.622,Watts,761.201000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:51.622,Watts,-11.101000,Volts,246.630000,Amps,-3.080490,PF,0.408100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:51.354,Watts,750.100000,Volts,245.800000,Amps,3.116900,PF,0.979000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:52.622,Watts,767.712000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:52.622,Watts,-11.112000,Volts,246.590000,Amps,-3.080420,PF,0.409000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:52.365,Watts,756.600000,Volts,245.760000,Amps,3.141900,PF,0.979800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:53.635,Watts,752.428000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:53.635,Watts,-11.128000,Volts,246.750000,Amps,-3.080700,PF,0.408200,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:53.365,Watts,741.300000,Volts,245.930000,Amps,3.084100,PF,0.977400,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:54.631,Watts,712.721000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:54.631,Watts,-11.121000,Volts,246.850000,Amps,-3.080730,PF,0.407500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:54.364,Watts,701.600000,Volts,246.070000,Amps,2.927500,PF,0.973900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:55.623,Watts,748.395000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:55.623,Watts,-11.095000,Volts,246.880000,Amps,-3.080480,PF,0.407400,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:55.355,Watts,737.300000,Volts,246.060000,Amps,3.068300,PF,0.976500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:56.622,Watts,763.089000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:56.622,Watts,-11.089000,Volts,246.800000,Amps,-3.080230,PF,0.408500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:56.354,Watts,752.000000,Volts,245.950000,Amps,3.121900,PF,0.979300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:57.632,Watts,779.574000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:57.632,Watts,-11.074000,Volts,246.710000,Amps,-3.080230,PF,0.407900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:57.365,Watts,768.500000,Volts,245.860000,Amps,3.185800,PF,0.981100,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:58.622,Watts,758.584000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:58.622,Watts,-11.084000,Volts,246.780000,Amps,-3.079830,PF,0.410400,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:58.365,Watts,747.500000,Volts,245.940000,Amps,3.106200,PF,0.978500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:30:59.637,Watts,768.109000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:30:59.637,Watts,-11.109000,Volts,246.820000,Amps,-3.080110,PF,0.410100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:30:59.354,Watts,757.000000,Volts,245.980000,Amps,3.142900,PF,0.979100,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:00.622,Watts,775.403000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:00.622,Watts,-11.103000,Volts,246.800000,Amps,-3.080430,PF,0.408200,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:00.354,Watts,764.300000,Volts,245.950000,Amps,3.169600,PF,0.980500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:01.622,Watts,757.331000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:01.622,Watts,-11.131000,Volts,246.760000,Amps,-3.080390,PF,0.409900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:01.354,Watts,746.200000,Volts,245.940000,Amps,3.102500,PF,0.977900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:02.632,Watts,735.782000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:02.632,Watts,-11.082000,Volts,246.800000,Amps,-3.079980,PF,0.409500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:02.364,Watts,724.700000,Volts,245.980000,Amps,3.019200,PF,0.975800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:03.622,Watts,763.880000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:03.622,Watts,-11.080000,Volts,246.790000,Amps,-3.079920,PF,0.409700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:03.354,Watts,752.800000,Volts,245.960000,Amps,3.125700,PF,0.979200,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:04.622,Watts,752.404000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:04.622,Watts,-11.104000,Volts,246.790000,Amps,-3.080050,PF,0.410200,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:04.355,Watts,741.300000,Volts,245.970000,Amps,3.082400,PF,0.977700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:05.641,Watts,756.474000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:05.641,Watts,-11.074000,Volts,246.750000,Amps,-3.080000,PF,0.409000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:05.355,Watts,745.400000,Volts,245.930000,Amps,3.102300,PF,0.977000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:06.622,Watts,748.778000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:06.622,Watts,-11.078000,Volts,246.810000,Amps,-3.079920,PF,0.409500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:06.354,Watts,737.700000,Volts,246.010000,Amps,3.074600,PF,0.975300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:07.632,Watts,777.641000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:07.632,Watts,-11.241000,Volts,246.820000,Amps,-3.081110,PF,0.411600,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:07.375,Watts,766.400000,Volts,245.970000,Amps,3.177000,PF,0.980800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:08.622,Watts,776.816000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:08.622,Watts,-11.716000,Volts,246.780000,Amps,-3.084460,PF,0.418100,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:08.355,Watts,765.100000,Volts,245.920000,Amps,3.172800,PF,0.980600,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:09.622,Watts,769.214000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:09.622,Watts,-11.714000,Volts,246.790000,Amps,-3.084530,PF,0.417700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:09.354,Watts,757.500000,Volts,245.980000,Amps,3.147800,PF,0.978300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:10.622,Watts,775.502000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:10.622,Watts,-11.702000,Volts,246.790000,Amps,-3.084420,PF,0.417700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:10.365,Watts,763.800000,Volts,245.960000,Amps,3.169100,PF,0.979900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:11.621,Watts,764.080000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:11.621,Watts,-11.580000,Volts,246.860000,Amps,-3.083370,PF,0.416900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:11.354,Watts,752.500000,Volts,246.060000,Amps,3.123100,PF,0.979300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:12.622,Watts,767.610000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:12.622,Watts,-11.110000,Volts,246.840000,Amps,-3.080400,PF,0.408700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:12.354,Watts,756.500000,Volts,246.020000,Amps,3.140200,PF,0.979200,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:13.632,Watts,736.776000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:13.632,Watts,-11.076000,Volts,246.880000,Amps,-3.079940,PF,0.409200,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:13.375,Watts,725.700000,Volts,246.080000,Amps,3.022500,PF,0.975700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:14.622,Watts,754.775000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:14.622,Watts,-11.075000,Volts,246.900000,Amps,-3.080050,PF,0.408600,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:14.354,Watts,743.700000,Volts,246.080000,Amps,3.089600,PF,0.978200,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:15.632,Watts,763.309000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:15.632,Watts,-11.109000,Volts,246.830000,Amps,-3.080190,PF,0.409700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:15.375,Watts,752.200000,Volts,246.000000,Amps,3.122900,PF,0.979200,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:16.632,Watts,771.293000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:16.632,Watts,-11.093000,Volts,246.850000,Amps,-3.080350,PF,0.408000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:16.365,Watts,760.200000,Volts,246.030000,Amps,3.153600,PF,0.979800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:17.621,Watts,760.229000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:17.621,Watts,-11.129000,Volts,246.840000,Amps,-3.080770,PF,0.407700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:17.360,Watts,749.100000,Volts,245.990000,Amps,3.114000,PF,0.977800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:18.622,Watts,763.670000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:18.622,Watts,-11.070000,Volts,246.810000,Amps,-3.080430,PF,0.406500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:18.355,Watts,752.600000,Volts,245.970000,Amps,3.125600,PF,0.978900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:19.632,Watts,777.367000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:19.632,Watts,-11.067000,Volts,246.750000,Amps,-3.080420,PF,0.406500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:19.375,Watts,766.300000,Volts,245.880000,Amps,3.178700,PF,0.980500,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:20.622,Watts,771.375000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:20.622,Watts,-11.075000,Volts,246.740000,Amps,-3.080430,PF,0.406900,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:20.354,Watts,760.300000,Volts,245.900000,Amps,3.155300,PF,0.979900,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:21.621,Watts,782.802000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:21.621,Watts,-11.102000,Volts,246.720000,Amps,-3.080290,PF,0.409000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:21.354,Watts,771.700000,Volts,245.870000,Amps,3.198300,PF,0.981300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:22.622,Watts,625.778000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:22.622,Watts,-11.078000,Volts,246.880000,Amps,-3.080350,PF,0.407200,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:22.355,Watts,614.700000,Volts,246.200000,Amps,2.565200,PF,0.973300,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:23.642,Watts,606.579000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:23.642,Watts,-11.079000,Volts,246.870000,Amps,-3.079860,PF,0.409800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:23.374,Watts,595.500000,Volts,246.220000,Amps,2.483900,PF,0.973700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:24.622,Watts,606.136000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:24.622,Watts,-11.036000,Volts,246.230000,Amps,-3.080130,PF,0.407300,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:24.354,Watts,595.100000,Volts,245.560000,Amps,2.488400,PF,0.973800,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:25.632,Watts,606.023000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:25.632,Watts,-11.123000,Volts,246.060000,Amps,-3.080390,PF,0.410600,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:25.364,Watts,594.900000,Volts,245.390000,Amps,2.489000,PF,0.974000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:26.632,Watts,608.683000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:26.632,Watts,-11.083000,Volts,246.020000,Amps,-3.080320,PF,0.409000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:26.365,Watts,597.600000,Volts,245.340000,Amps,2.500900,PF,0.974000,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:27.632,Watts,606.075000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:27.632,Watts,-11.075000,Volts,246.050000,Amps,-3.080280,PF,0.408800,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:27.375,Watts,595.000000,Volts,245.390000,Amps,2.490400,PF,0.973700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:28.622,Watts,607.377000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:28.622,Watts,-11.077000,Volts,246.100000,Amps,-3.079800,PF,0.411300,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:28.365,Watts,596.300000,Volts,245.410000,Amps,2.494200,PF,0.974100,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:29.621,Watts,606.163000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:29.621,Watts,-11.063000,Volts,246.130000,Amps,-3.079960,PF,0.409700,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:29.354,Watts,595.100000,Volts,245.480000,Amps,2.489700,PF,0.973700,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:30.622,Watts,605.224000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:30.622,Watts,-11.124000,Volts,246.360000,Amps,-3.080720,PF,0.408500,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:30.365,Watts,594.100000,Volts,245.710000,Amps,2.483200,PF,0.973600,Mark,2024-11-28_14-28-23_testing
Time,11-28-2024 14:31:31.622,Watts,606.171000,Volts,-1.000000,Amps,-1.000000,PF,-1.000000,Mark,2024-11-28_14-28-23_testing,Analyzer1,Time,11-28-2024 14:31:31.622,Watts,-11.071000,Volts,246.970000,Amps,-3.079710,PF,0.410000,Mark,2024-11-28_14-28-23_testing,Analyzer2,Time,11-28-2024 14:31:31.365,Watts,595.100000,Volts,246.310000,Amps,2.480900,PF,0.973900,Mark,2024-11-28_14-28-23_testing
Problem 1: Power is calculated as negative for one of the power analyzer - it is due to low crest factor setting and power factor being low. In this case, the reported power is wrong and it is not correct to take its absolute value and do the summation.
Problem 2: Instead of "-1" for the aggregated current, voltage and pf values, can we use "N/A" as "-1" is used for invalid readings?