This project has moved. For the latest updates, please go here.

The following SQL server script can be run against your openPDC configuration database to convert all line-to-neutral voltage magnitudes to line-to-line by applying a square root of 3 factor to the value:

USE openPDC
GO
UPDATE Measurement SET Multiplier = 1.732050807568877 WHERE Measurement.PointID IN
   (SELECT CONVERT(INT, SUBSTRING(ID, CHARINDEX(':', ID) + 1, 10)) AS PointID
   FROM ActiveMeasurement WHERE SignalType='VPHM')

Last edited Aug 1, 2012 at 4:38 PM by ritchiecarroll, version 6

Comments

No comments yet.