Yea, results match garmin now for PSD so I'm confident with the math
Will work on 2nd csv output that is converted to feet per second, time corrected, and cleaned up. I got to playing with putting all the info into an array but then exporting the array as csv is giving me issues. I think I'm going to work around rather than solve the issue. Will manually make a csv, import it, export it so it has appropriate headers and see how that goes. Expect an update to the script later today.
Code:
$csv_data = $csv1 | where 'type' -eq 'data' | where 'local number' -eq 4
$measured = $csv_data.'value 2' | measure-object -average
$newNumbers = 0
ForEach ($number in $csv_data) {
$newNumbers += [Math]::Pow(($number.'value 2' - $measured.Average), 2)
}
$stdDev = [math]::Sqrt($($newNumbers / ($measured.Count - 1)))
$stdDevp = [math]::Sqrt($($newNumbers / ($measured.Count)))
$stddev_fps=$stddev / 304.79999025
$stddevp_fps=$stddevp / 304.79999025Will work on 2nd csv output that is converted to feet per second, time corrected, and cleaned up. I got to playing with putting all the info into an array but then exporting the array as csv is giving me issues. I think I'm going to work around rather than solve the issue. Will manually make a csv, import it, export it so it has appropriate headers and see how that goes. Expect an update to the script later today.