-- ------------------------ --
-- Trend Channels For Elden --
-- ------------------------ --

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V RMS A', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V RMS B', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V RMS C', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I RMS A', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I RMS A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I RMS B', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I RMS B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I RMS C', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I RMS C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'RMS'),
		(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
		'I RMS N', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I RMS N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'IN_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'Avg Imbalance'),
		(SELECT ID FROM Phase WHERE Name LIKE 'LineToNeutralAverage'),
		'V Imbalance Avg LN', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Imbalance Avg LN' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'V_IMB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'Avg Imbalance'),
		(SELECT ID FROM Phase WHERE Name LIKE 'LineToNeutralAverage'),
		'I Imbalance Avg LN', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Imbalance Avg LN' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'I_IMB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V THD A', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDVA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V THD B', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDVB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V THD C', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDVC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I THD A', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I THD A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDIA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I THD B', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I THD B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDIB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I THD C', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I THD C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDIC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'TotalTHD'),
		(SELECT ID FROM Phase WHERE Name LIKE 'NG'),
		'I THD N', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I THD N' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'THDIN_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Flicker Pst A', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst A' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'PST_10MIN_VA')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Flicker Pst B', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst B' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'PST_10MIN_VB')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'FlkrPST'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Flicker Pst C', 0, 1, 0, 0, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Flicker Pst C' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'PST_10MIN_VC')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_VA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'V Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_VB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Voltage'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'V Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_VC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'V Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'V Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'AN'),
		'I Harmonic A 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic A 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_IA_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'BN'),
		'I Harmonic B 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic B 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_IB_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 2', 0, 1, 0, 2, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 2' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM2_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 3', 0, 1, 0, 3, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 3' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM3_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 4', 0, 1, 0, 4, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 4' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM4_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 5', 0, 1, 0, 5, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 5' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM5_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 6', 0, 1, 0, 6, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 6' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM6_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 7', 0, 1, 0, 7, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 7' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM7_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 8', 0, 1, 0, 8, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 8' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM8_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 9', 0, 1, 0, 9, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 9' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM9_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 10', 0, 1, 0, 10, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 10' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM10_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 11', 0, 1, 0, 11, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 11' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM11_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 12', 0, 1, 0, 12, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 12' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM12_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 13', 0, 1, 0, 13, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 13' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM13_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 14', 0, 1, 0, 14, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 14' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM14_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 15', 0, 1, 0, 15, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 15' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM15_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 16', 0, 1, 0, 16, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 16' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM16_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 17', 0, 1, 0, 17, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 17' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM17_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 18', 0, 1, 0, 18, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 18' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM18_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 19', 0, 1, 0, 19, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 19' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM19_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 20', 0, 1, 0, 20, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 20' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM20_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 21', 0, 1, 0, 21, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 21' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM21_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 22', 0, 1, 0, 22, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 22' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM22_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 23', 0, 1, 0, 23, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 23' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM23_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 24', 0, 1, 0, 24, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 24' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM24_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 25', 0, 1, 0, 25, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 25' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM25_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 26', 0, 1, 0, 26, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 26' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM26_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 27', 0, 1, 0, 27, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 27' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM27_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 28', 0, 1, 0, 28, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 28' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM28_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 29', 0, 1, 0, 29, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 29' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM29_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 30', 0, 1, 0, 30, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 30' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM30_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 31', 0, 1, 0, 31, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 31' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM31_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 32', 0, 1, 0, 32, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 32' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM32_IC_10MIN')
GO

INSERT INTO Channel (MeterID, AssetID, MeasurementTypeID, MeasurementCharacteristicID, PhaseID, Name, Adder, Multiplier, SamplesPerHour, HarmonicGroup, Description, Enabled, ConnectionPriority, Trend)
	VALUES
		((SELECT ID FROM Meter WHERE Name LIKE '%Elden%'),
		(SELECT ID FROM Asset WHERE AssetName LIKE '%Elden%'),
		(SELECT ID FROM MeasurementType WHERE Name LIKE 'Current'),
		(SELECT ID FROM MeasurementCharacteristic WHERE Name LIKE 'SpectraHGroup'),
		(SELECT ID FROM Phase WHERE Name LIKE 'CN'),
		'I Harmonic C 33', 0, 1, 0, 33, NULL, 1, 0, 1)
GO
INSERT INTO Series (ChannelID, SeriesTypeID, SourceIndexes)
	VALUES
		((SELECT ID FROM Channel WHERE Name = 'I Harmonic C 33' AND MeterID = (SELECT ID FROM Meter WHERE Name LIKE '%Elden%')),
		(SELECT ID FROM SeriesType WHERE Name LIKE 'Average'),
		'HRMM33_IC_10MIN')
GO

