Contents of spl.txt is confusing

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

Start by locating the code that generates spl.txt and tracing how readings from multiple analyzers are aggregated. Compare the aggregation with the supplied sample, then verify that signed power is handled correctly and invalid aggregate current, voltage, and power-factor values are represented as N/A.